Multi Parameter Query - problem sending more then one parameter

Vesper

Hi,

I am trying to create an ASP file which will search Multiple Values in a Database. Everything is fine if there is one parameter but if there are more I receive an SQL error message:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Alt LIKE Pa_RaM000 OR WHERE Alt LIKE Pa_RaM001'.

Any help solving the problem would be appreciated (I am struggeling with it for almost 2 weeks and haven't managed to solve it).

the parameters come as a splited string (already splitted)

I am using the following code for parameter and query definition:

Expand|Select|Wrap|Line Numbers

 
QString="SELECT PartNo, Alt, UNIT, QTY1 FROM Stock WHERE Alt LIKE ? "
 
for i=Lbound(Splitted) to Ubound(Splitted)

   Recordset2__MMColParam=Splitted(i)

   Recordset2_cmd.Prepared = true

   set Param =  Recordset2_cmd.CreateParameter("param"+chr(i), 200, 1, 255, "%" + Recordset2__MMColParam + "%") ' adVarChar

   Recordset2_cmd.Parameters.Append(Param)

   if i>0 then 

      QString = QString & "OR WHERE Alt LIKE ? "

   end if

next 
 
QString = QString & "ORDER BY Alt ASC" 

Recordset2_cmd.CommandText=QString

Thanks,
Vesper Ventura

jhardman

Vesper

Syntax should be "WHERE xxx LIKE 'Joe' OR xxx LIKE 'Fred' "...etc.
You should not say OR WHERE

Jared

Vesper

Quote:

Originally Posted by jhardman

Vesper

Syntax should be "WHERE xxx LIKE 'Joe' OR xxx LIKE 'Fred' "...etc.
You should not say OR WHERE

Jared

Thanks, I will try that right away.

Vesper Ventura

Multi Parameter Query - problem sending more then one parameter

re: Multi Parameter Query - problem sending more then one parameter

re: Multi Parameter Query - problem sending more then one parameter

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about