Home » SQL & PL/SQL » SQL & PL/SQL » Re: use variable in SQL statement
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.

Previous Topic: Re: How to Retrieve CLOB withADODB Command Parameter...?
Next Topic: Retrieving Multiple Rows of Single Column as a String concatenated with comma
Goto Forum:

Current Time: Thu May 23 02:21:34 CDT 2024