Selecting database records using the QueryString

[courtjester]

Ok, can anyone please explain this to me . Hey Smokie, I used the Exact title . thanks for your help guys.

[Webforumz Staff]

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

mypage.asp?id=5

[Smokie]

thats it Court Jester

[courtjester]

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]

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]

for example:

Code: Select all

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: Select all

<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]

COOL! Thanks Rob for taking the confusion away . Thanks Smokie, that's a big help as well, This totally rocks!

[courtjester]

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: Select all

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

and here's the entire thing...

Code: Select all

<% 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]

try this:

Code: Select all

<%
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]

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

[courtjester]

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

www.haeglodesigns.com/tests/querystrings.asp