Request.querystring or Recordset.GetString?

[andrewdreib]

I am still very new to ASP and am trying to create an ASP page that gets
records from a database. Right not I can successfully get one field of
information at a time and randomize it, but I need the whole string. I've
been searching the internet trying to find an answer to this question and I
found these two commands Request.querystring and Recordset.GetString, but I
don't think I know how to use them properly.

Here's the code I have now:

====================

‘Connection String and SQL statement

Dim query, connStr

query = “select * from numbers�

connStr = “Provider=Microsoft.Jet.OLEDB.4.0;� & _

“Data Source = F:\Inetpub\wwwroot\numbers.mdb;�

‘Opening Database

Dim rs

Set rs = Server.CreateObject(“ADODB.Recordset�)

rs.Open query, connStr, 3, , adCmdText

‘Generating random number from total number of records

Dim intRnd

Randomize Timer

intRnd = (Int(RND * rs.RecordCount))

‘Now moving the cursor to random record number

rs.Move intRnd

‘Showing the random statement

Response.Write “<b>� & rs(“ID�) & “</b>�

‘Closing the database

rs.Close

Set rs = Nothing

====================

Any help would be greatly appreciated, I'm running short on time.

~Andrew

[Jason Brown [MSFT]]

I don't think you want either of those, but I'm not quite clear on what "but
I need the whole string" means.

you're successfully writing the ID field, right? does this mean you want to
write another field too?

in that case:

Response.Write "<b>" & rs("ID") & " : " & rs("anotherfieldnamehere") &
"</b>"

Recordset.GetString() is a method for fast data retrieval that will convert
the WHOLE recordset into a string. I don't think you want that, since you're
grabbing one row, not all. Request.Querystring gets you the query string
from a URL (the bit after ? in http://support.microsoft.com/?kbid=123456 -
Request.Querystring("kbid") would return "123456")
--
Jason Brown
Microsoft GTSC, IIS

This posting is provided "AS IS" with no warranties, and confers no
rights.
"andrewdreib" <an*********@discussions.microsoft.com> wrote in message
news:B6**********************************@microsof t.com...

I am still very new to ASP and am trying to create an ASP page that gets
records from a database. Right not I can successfully get one field of
information at a time and randomize it, but I need the whole string. I've
been searching the internet trying to find an answer to this question and
I
found these two commands Request.querystring and Recordset.GetString, but
I
don't think I know how to use them properly.

Here's the code I have now:

====================

'Connection String and SQL statement

Dim query, connStr

query = "select * from numbers"

connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Data Source = F:\Inetpub\wwwroot\numbers.mdb;"

'Opening Database

Dim rs

Set rs = Server.CreateObject("ADODB.Recordset")

rs.Open query, connStr, 3, , adCmdText

'Generating random number from total number of records

Dim intRnd

Randomize Timer

intRnd = (Int(RND * rs.RecordCount))

'Now moving the cursor to random record number

rs.Move intRnd

'Showing the random statement

Response.Write "<b>" & rs("ID") & "</b>"

'Closing the database

rs.Close

Set rs = Nothing

====================

Any help would be greatly appreciated, I'm running short on time.

~Andrew