2. ASPRunnerPro General questions
  3. Advanced Search - Removal
This topic is locked

Advanced Search - Removal

 		2/8/2006 9:51:02 AM
ASPRunnerPro General questions
D
 dpkona author

Sergey
I'd like to remove the andor situation from the advance search page involving the 'all conditions' and the 'any conditions' option. However, I get an error everytime I try to remove. I've tried everyway that I can think of - commenting out, removing the whole table, and making the radio buttons hidden. I get the same message every time.
Error after modifying "_search.asp"
"Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

Microsoft ODBC Microsoft Access Driver Syntax error (missing operator) in query expression '( and tbl_Summ_Nov05.Center =301000)'.

/FlashNov05/tbl_Summ_Nov05_list.asp, line 573"
Thanks

David
Sergey Kornilov admin 2/8/2006

I guess you cannot make radio buttons hidden - in this case radio button value won't be submitted.
Try to remove radio buttons and put the following hidden field to form:

<input type="hidden" name="andor" value="and">


If this doesn't help change vDeug variable in include/commonfunctions.asp from False to True and print this SQL query on the page.
D
 		dpkona author 2/9/2006

That's what i did. Did not work.
D
 		dpkona author 2/9/2006

result of debug
select Summ_ID, Center, Center_Desc, Summary_Account, Key, YTD_Dec, Dec, Nov_Act, Nov_Bud, November variance, Oct, Sep, Aug, Jul, Jun, May, Apr, Mar, Feb, Jan From tbl_Summ_Nov05 where ( and, or tbl_Summ_Nov05.Center =301000) ORDER BY Summ_ID ASC
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
MicrosoftODBC Microsoft Access Driver Syntax error (missing operator) in query expression '( and, or tbl_Summ_Nov05.Center =301000)'.
/FlashNov05/tbl_Summ_Nov05_list.asp, line 573
Sergey Kornilov admin 2/9/2006

Did you remove all references to input type="radio" name="andor"?
D
 		dpkona author 2/14/2006

Do I need to remove all references in all files or just in the _search.asp file? Because if it is just the _search.asp file, I continue to get errors.
Sergey Kornilov admin 2/14/2006

You need to do this just in ..._search.asp file.
After I did this search page works just fine.