Results 1 to 5 of 5
Jun 20, 2002, 04:17 #1
- Join Date
- Jun 2001
- 1 Post(s)
- 0 Thread(s)
recordset with query- a real puzzler!Code:
sqlStr="SELECT users.userID,....cut and pasted from access sql view;" connection rsUserData.open sqlStr,con1,3,3Code:
connection rsUserData.open "queryName" ,con1,3,3
be identical, although the top way a bit faster.
I want to use the first way because I need to pass a parameter
to the WHERE clause from the asp page.
The problem is that the first way draws an error on the line where
the recordset is opened. And its an unspecified error- the worse kind!
/matifone/mat_asp/personal.asp, line 39
Any ideas as to why an exact cut and pasted query that
works in access, and works when an asp page refers to
it by name, would not work when it is given as a parameter
Alternatively, is there a way of passing my parameter to
the query even though I am calling it by name in
Hope this is an interesting question to somebody.