*** 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!

[JoshT]

ASP doesn't know your SQL string from any other string, and VBScript doesn't offer cool variable interpolation like Perl, so:

rstProvince.Open "SELECT * FROM Guide WHERE ID_Region = " & numID_Region & " ORDER BY ID_Region, ID_Province", con

[Franky]

Thanks, it works.

[Franky]

..

[JoshT]

rstProvince.Open "SELECT * FROM Guide WHERE ID_Region = " & numID_Region & " AND ID_Area = " & numID_Area & " ORDER BY ID_Region, ID_Province", con

You're simply creating an SQL string dynamically.

[Franky]

I did exactly what you showed me here.

Maybe it was a writing error from my side. I will check it again.

Thanks

[veryjonny]

Use:

select * from TableName where Fieldname1 = '" & myvar & "'  and FieldName2 = '" & myvar2 & "'"

Hope this helps.

[JoshT]

Originally posted by Franky
I did exactly what you showed me here.

Maybe it was a writing error from my side. I will check it again.

Thanks

I edited out a small typo - let us know if you get specific error messages.