Help with asp here please

WIBSBOT · 12 Dec 2006 at 15:54

I'm new to asp and need some help...

I'm trying to allow a user to enter text into a text box (which I've done). I then want to read through a database table (access db) and use this data to do some text matching against the text box.

I just can't work out what to use. In VB I would have loaded the table into a recordset and read round that. Can I do this with asp ?

toString · 12 Dec 2006 at 16:11

'asp' is vbscript, so it's pretty much the same thing.

Code:

Set RS= cn.Execute("select info from table")

Do While Not RSS.eof
	Response.Write RS("info")
RS.MoveNext
Loop

WIBSBOT · 12 Dec 2006 at 16:13

KingAdora said:
'asp' is vbscript, so it's pretty much the same thing.

Code:

Set RS= cn.Execute("select info from table") Do While Not RSS.eof Response.Write RS("info") RS.MoveNext Loop

Thanks,
I'll give that a go.

I suppose I was getting a little confused with the 'AccessDataSource Control' and how I would use that to do this, although I don't want to display the table and that's all this seems to do.

Mr^B · 13 Dec 2006 at 13:39

AccessDataSource control sounds like you're using ASP.Net rather than ASP.

toString · 13 Dec 2006 at 13:53

Where's that rant thread when you need it!!!