*** RESOLVED *** ASP >> SQL SELECT * and WHERE ? How does it work?

[Franky]

Hi,

I extend now my question.

I am currently creating a ASP-FIle in which I want to use only selected data. This data I want to get with:

numID_Region = 2
numID_Area = 4

I got already the answer if I use WHERE with one option, How i can use WHERE with two options?

With one option I got this answer here and it works fine (Thanks):
Set rstProvince = CreateObject("ADODB.Recordset")
rstProvince.Open "SELECT * FROM Guide WHERE ID_Region = " & numID_Region & " ORDER BY ID_Region, ID_Province", con


So, now the question, how can I include the second Restriction?


Thanks in advance for your help
Franky



I found the solution, thanks!