Request.queryst ring or Recordset.GetSt ring?

[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.queryst ring and Recordset.GetSt ring, 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=Mic rosoft.Jet.OLED B.4.0;� & _

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

‘Opening Database

Dim rs

Set rs = Server.CreateOb ject(“ADODB.R ecordset�)

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("anotherfiel dnamehere") &
"</b>"

Recordset.GetSt ring() 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.Queryst ring gets you the query string
from a URL (the bit after ? in http://support.microsoft.com/?kbid=123456 -
Request.Queryst ring("kbid") would return "123456")
--
Jason Brown
Microsoft GTSC, IIS

This posting is provided "AS IS" with no warranties, and confers no
rights.
"andrewdrei b" <an*********@di scussions.micro soft.com> wrote in message
news:B6******** *************** ***********@mic rosoft.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.queryst ring and Recordset.GetSt ring, 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=Micro soft.Jet.OLEDB. 4.0;" & _

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

'Opening Database

Dim rs

Set rs = Server.CreateOb ject("ADODB.Rec ordset")

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