Selecting database records using the QueryString

courtjester · August 25th, 2004, 10:55 AM

Ok, can anyone please explain this to me

. Hey Smokie, I used the Exact title

. thanks for your help guys.

Webforumz Staff · August 25th, 2004, 06:55 PM

sSQL = "SELECT whatever FROM wherever WHERE userid=" & request.querystring("id")

mypage.asp?id=5

Smokie · August 26th, 2004, 04:07 AM

thats it Court Jester

courtjester · August 26th, 2004, 08:56 AM

ok, I see the code, but how do I get that to work for me? Where do I place that code? Does it go as a part of my link? Still confused.. thanks.

Rob · August 26th, 2004, 09:09 AM

Court Jester... you really have answered your own question here in your initial post.

You include the ID of the item you want from the database in your link (as a querystring)... eg:- mypage.asp?id=272

and then use the SQL select statement you posted to get at the element in the db who's id matches. you can pull whatever data you need to from the database (i know you know how to do that, so wont go into it) and display it.

Smokie · August 26th, 2004, 09:38 AM

for example:

Code:

Set objRS = objConn.Execute("SELECT [ID],[Title] FROM table")
If objRS.EOF Then
  Response.Write "no records"
Else
  Do While Not objRS.EOF
    Response.Write "<a href=details.asp?ID="&objRS("ID")&">"&objRS("Title")&"</a>
"
  objRS.MoveNext
  Loop
End If
objRS.Close
Set objRS = Nothing

The above will create something like this:

Code:

<a href=details.asp?ID=1>Mr Smith</a>

<a href=details.asp?ID=2>Mrs Jones</a>

<a href=details.asp?ID=3>Mr Small</a>

<a href=details.asp?ID=4>Mrs West</a>

Does that help?

courtjester · August 26th, 2004, 11:35 AM

COOL! Thanks Rob for taking the confusion away

. Thanks Smokie, that's a big help as well, This totally rocks!

courtjester · August 26th, 2004, 11:39 PM

hrmmm I tried the code you gave me smokie, and while I understand what it does and all.. the way you did it is a lot different then I normally do it. I am getting an error on line 16 which is this:

Code:

Set objRS = objConn.Execute("SELECT [ID],[PageName] FROM Page")

and here's the entire thing...

Code:

<% Set connectionToDatabase=Server.CreateObject("ADODB.Connection")
connectionToDatabase.ConnectionTimeout=60
connectionToDatabase.Open "DSN=Mydatabase"

dim objRS
dim objConn
objRS = recordSet
objConn = connectionToDatabase

Set objRS = objConn.Execute("SELECT [ID],[PageName] FROM Page")
If objRS.EOF Then
  Response.Write "no records"
Else
  Do While Not objRS.EOF
    Response.Write "<a href=details.asp?ID="&objRS("ID")&">"&objRS("PageName")&"</a>"
  objRS.MoveNext
  Loop
End If
objConn.Close
Set objConn = Nothing
%>

thanks for your help

ohhh and this is the error....
Microsoft VBScript runtime error '800a01a8'

Object required: 'Provider=MSDASQL.1;E'

/tests/querystrings.asp, line 16

Smokie · August 27th, 2004, 05:15 AM

try this:

Code:

<%
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionTimeout=60
objConn.Open "DSN=Mydatabase"

Set objRS = objConn.Execute("SELECT [ID],[PageName] FROM Page")
If objRS.EOF Then
  Response.Write "no records"
Else
  Do While Not objRS.EOF
    Response.Write "<a href=details.asp?ID="&objRS("ID")&">"&objRS("PageName")&"&lt/a>"
  objRS.MoveNext
  Loop
End If
objConn.Close
Set objConn = Nothing
%>

courtjester · August 27th, 2004, 11:30 AM

Thanks a ton Smokie. It works great! Thanks so much for your help!

courtjester · August 27th, 2004, 03:52 PM

Ohhh here is my first test at this :wink:.

www.haeglodesigns.com/tests/querystrings.asp