[thelist] Pass ASP query sting to SQL statement

Ken Schaefer Ken at adOpenStatic.com
Sun Aug 12 20:23:02 CDT 2007


The problem is that OP is specifying an undefined CursorType:

> videos.CursorType = 1

Cheers
Ken


-----Original Message-----
From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Taurus James
Sent: Saturday, 11 August 2007 10:31 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] Pass ASP query sting to SQL statement

3. I want to say the recordset connection code looks suspect, but it's been a long time since I've done Access. Try fixing the first two points above and see if they clear up the DB error. I think the error you see is because the query is invalid. Try executing the query within Microsoft Access, substituting the vidid. I will say that the error "Appears" to be complaining about the "source" property. I've never used it. Keep in mind that your version of ADO may not support this property. Try this:

dim strSQL
strSQL = "SELECT [SPECIFIC FIELD1], [SPECIFIC FIELD2], [ETC.] FROM videos where active='yes' and Id=" & vidid

...and then...

videos.Open(strSQL)



More information about the thelist mailing list