Recordset SQL: help for a WHERE with multiple fields

[promastermz]

Ive a problem with Dreamweaver and SQL query.
This query works:

SELECT *
FROM table
WHERE table.field1 LIKE %MMColParam%

The MMColParam is a Request.Form("variable") from a previous form in ASP page.
But if i try to extend to two or more fields the WHERE function with OR, like the following query, i receive a syntax error!

SELECT *
FROM table
WHERE table.field1 LIKE %MMColParam% OR table.field2 LIKE %MMColParam%

Whats the right syntax format for this type of query?

Thanx a lot

[Guest]

maybe depends on the database you use

possible solution:
SELECT *
FROM table
WHERE table.field1 LIKE '%' + MMColParam + '%' OR table.field2 LIKE '%' + MMColParam + '%'

hope this helps
sebastian

[Newsgroup_User]

Not sure which db but try adding ('s as below

SELECT *
FROM table
WHERE (table.field1 LIKE %MMColParam%) OR (table.field2 LIKE
%MMColParam%)

[Newsgroup_User]

Syntax errors are often caused by incorrect field types. Check that both
database fields are exactly the same type.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"promastermz" <webforumsuser@macromedia.com> wrote in message
news:f6sqap$399$1@forums.macromedia.com...
> Ive a problem with Dreamweaver and SQL query.
> This query works:
>
> SELECT *
> FROM table
> WHERE table.field1 LIKE %MMColParam%
>
> The MMColParam is a Request.Form("variable") from a previous form in ASP
> page.
> But if i try to extend to two or more fields the WHERE function with OR,
> like
> the following query, i receive a syntax error!
>
> SELECT *
> FROM table
> WHERE table.field1 LIKE %MMColParam% OR table.field2 LIKE %MMColParam%
>
> Whats the right syntax format for this type of query?
>
> Thanx a lot
>
>