Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Problems with Search parameter

Problems with Search parameter

Thread begun 5/01/2012 11:07 am by sandy170299 | Last modified 5/08/2012 10:19 am by Ray Borduin | 1919 views | 4 replies |

5/01/2012 11:07 am | #1 sandy170299

Problems with Search parameter

This site (donationSearch.cfm) is not working properly when search is submitted. I am receiving the following error: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 5: Incorrect syntax near ')'.

Do you need a copy of the file?

5/01/2012 2:19 pm | #2 Jason ByrnesWebAssist

yes, please send a copy of the search page.

5/01/2012 2:28 pm | #3 sandy170299

Jason, can you open a support ticket? The page may contain some data I don't want visible. Thank you!

5/01/2012 2:29 pm | #4 Jason ByrnesWebAssist

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

If anyone else is experiencing this same issue, please append to this thread.

5/08/2012 10:19 am | #5 Ray BorduinWebAssist

This was an issue with your "Reconciled" dropdown list. The first option "--choose an option --" needs to have a blank value specified or else it will actually use the text to search the field and in this case it was a numeric field, causing the error.

To fix the problem I updated:

<option>-- choose an option --</option>

to:

<option value="">-- choose an option --</option>

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.