advcomputer
Posts: 68
|
| Posted: 07/02/2007, 8:46 AM |
|
I saw this on another thread and it seems pretty simple to execute. I tried the ASP code both BeforeExecuteSelect and BeforeBuildSelect event and they both retrun the same error;
where clause = 'fat' AND 'go'AND 1001
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/Classes.asp, line 3338
Any help would be appreciated. Thanks in advance,
Jeff
===============================================================================
dim keywords, keyword, sep, where
' Probably want this in the Before Build Select of the Grid
where = ""
sep = ""
keywords = split(CCGetParam("Textbox1",""), " ") ' Split the Textbox containing ouse search parmeters, making an array of words
for each keyword in keywords
if keyword <> "" then
where = where & sep & "'" & keyword & "'"
sep = " AND "
end if
next
where = where & "AND " & request("s_categorydescription")
' DIsplay the where clause
print "where clause = " & where
' Eventcaller will be the Grid's datasource
upload.datasource.Where = where
|
 |
 |
wkempees
Posts: 1679
|
| Posted: 07/02/2007, 9:38 AM |
|
Only help I can offer is
where clause = 'fat' AND 'go'AND 1001
is missing a space between 'go'AND
also
where clause =
seems wrong too, even compared to the example you include.
The error point to misformed SQL, most of the time (missing field, misspelled fieldname or in this case ......)
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
