SQL Select From Integer and Text Columns At Same Time

J

Jeff G

I have a search box where people can enter in either text or numbers. I
would like to query the SQL DB columns that are both integers and text from
just 1 search box.

Example:

SELECT * FROM faq WHERE (qa_text LIKE '%::search::%' OR qa_integer =
::search::)

The DBRW validates the query. When I enter a number in search, it finds the
qa_ID just fine. But when I enter in text in the search box, I get

Database Results Wizard Error
Description: [Microsoft][ODBC SQL Server Driver]Invalid use of default
parameter

Help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Select search on integer and text columns 1
Unable to display values in 2nd list box from 1st list box selection 2
Query using text from form or anything if empty 2
List Box search 4
Sql Syntax Query missing managed metadata in select 0
DBRW generating ADODB.Command error '800a0cc1' 16
SQL statement in form text control 2
Help! Help! ASP Form 6

Top