Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Order data in a table
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Order data in a table

 Post Reply Post Reply
Author
Boecky View Drop Down
Groupie
Groupie
Avatar

Joined: 23 December 2002
Location: Belgium
Status: Offline
Points: 110
Post Options Post Options   Thanks (0) Thanks(0)   Quote Boecky Quote  Post ReplyReply Direct Link To This Post Topic: Order data in a table
    Posted: 20 June 2003 at 6:37am

Hi, I want to make a table with some links in it to order on name, addres, telephone,... I already make something that "works", but I want to replace the If ... Then statement to a Select Case. Can someone help me?


<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="include/Connection.inc" -->
<%
Dim Conn
Dim rsTest

Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\test\testdb.mdb"
Conn.Open ConnStr

Set rsTest = Server.CreateObject("ADODB.Recordset")
rsTest.ActiveConnection = Conn

Dim strCase
strCase = Request.QueryString("sort")
If strCase = "naam" Then
  rsTest.Source = "Select * FROM tblKlant ORDER BY Naam ASC;"
Else
  rsTest.Source = "Select * FROM tblKlant ORDER BY Telefoon DESC;"
End If
rsTest.Open
%>

Back to Top
MorningZ View Drop Down
Senior Member
Senior Member
Avatar

Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793
Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post Posted: 20 June 2003 at 8:43am
Dim strCase
strCase = Request.QueryString("sort")
If strCase = "" Then
  rsTest.Source = "Select * FROM tblKlant ORDER BY " & strCase
Else
  rsTest.Source = "Select * FROM tblKlant"
End If
Contribute to the working anarchy we fondly call the Internet
Back to Top
Boecky View Drop Down
Groupie
Groupie
Avatar

Joined: 23 December 2002
Location: Belgium
Status: Offline
Points: 110
Post Options Post Options   Thanks (0) Thanks(0)   Quote Boecky Quote  Post ReplyReply Direct Link To This Post Posted: 20 June 2003 at 9:24am
Works great, thanks!
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.