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

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!

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

Code:

---

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

---

Thanks, it works.

..

VB Code:

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.

I did exactly what you showed me here.

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

Thanks

Use:

Code:

---

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

---

Hope this helps.:)

Quote:

---

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.