Need help with WHERE clause

[Craig]

Hi

Using ASP VP, DW 8.0.2 and MS Access

I have a dynamic page that is accessed through a URL such as:

www.domain.com/file.asp?ClientSize=average

However, I want to specify more than one parameter in the URL such as:

www.domain.com/file.asp?ClientSize=average&Medium=design

What is the syntax for a WHERE clause that will do this?

Right now the WHERE clause reads:

WHERE ClientSize LIKE %MMColParam%

and MMColParam has the parameters:

Name: MMColParam
Type: Text
Value:Request.QueryString("ClientSize")
Default value: 1

How can I add more than one parameter?

Please help! Thanks

Craig

 

[Sylvain Lafontaine]

The syntaxe WHERE ClientSize LIKE %MMColParam% seems particular and should
work with Access, ADP or SQL-Server; so I suppose that you are using some
code generator (DM 8.0.2?) who is writing back the right code. In your
case, adding an AND statement should do it:

WHERE ClientSize LIKE %MMColParam% and Medium like %MMDesign%

 

[Craig]

Hi

Yes, DW 8.0.2 wrote the code. I tried to learn from it so to speak and
failed. Then I tried to do the same thing again and it worked.

Don't ask my why; I'm just happy that it works.

Code is a prickly thing!

Thanks

c