Re: use variable in SQL statement [message #36436] |
Tue, 27 November 2001 21:53 |
ngoc nhung
Messages: 1 Registered: November 2001
|
Junior Member |
|
|
page1: [url="adpropriete_detail.asp?a=<%=rs("IDlocation")%]"><%=rs.fields("IDlocation")%>
page2: SQL = "Select Locations.IDlocation, Locations.region FROM Locations, upload where locations.IDlocation=upload.IDlocation and locations.IDlocation='&a'"
error: error '80020009' Exception occurred.
----------------------------------------------------------------------
|
|
|