ASP Recordset Help!

[longsdale]

Hi,
I have been trying to construct a results page in dreamweaver/asp if i put
a search in with one parameter it works fine (ie, select name from names where
name = 'MMcolPara') where MMcolPara is equal to Request.Form("Name"). BUT when
i add more boxes to my form and go to my results page and add new parameters
like varProductName which is equal to Request.Form("ProductName") and add it to
the sql query (ie, select name from names where name = 'MMcolPara' and/or
ProductName = 'varProductName') i get errors, why???
I'm trying to return either both results or just one result depending on the
info sent. I realise i must have to set up if... else.. clauses???
Any help in this matter?
Thanks, Ian

[Paul Whitham TMM]

Ian

There is no such thing as an And/Or condition in a SQL statement, it is
either one or the other. If you use wildcard values as the defaults in your
query then you can use And statements regardless of what is passed from the
form.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"longsdale" <webforumsuser@macromedia.com> wrote in message
news:d2broj$49d$1@forums.macromedia.com...

> Hi,
> I have been trying to construct a results page in dreamweaver/asp if

i put

> a search in with one parameter it works fine (ie, select name from names

where

> name = 'MMcolPara') where MMcolPara is equal to Request.Form("Name"). BUT

when

> i add more boxes to my form and go to my results page and add new

parameters

> like varProductName which is equal to Request.Form("ProductName") and add

it to

> the sql query (ie, select name from names where name = 'MMcolPara' and/or
> ProductName = 'varProductName') i get errors, why???
> I'm trying to return either both results or just one result depending on

the

> info sent. I realise i must have to set up if... else.. clauses???
> Any help in this matter?
> Thanks, Ian
>