Passing Property values

[emcveigh]

I am trying to pass a property from a web page to my ActiveX control. I can succesfully pass it to a text field or to a caption, but I cannot pass it to a variable. I need to store it in a variable in order to call it in a SQL statement. Does anybody have any suggestions? I'm desperate....

Thanks in advance for any help you can give me!!!!

Emma

 

[pcr9]

declare the variable as soon as the script starts and then refer to that in the normal sql line. For example (in ASP):

<%
varTextbox = Request.Form(&quot;textbox&quot 'value from html
Dim oRSa
sqlText=&quot;SELECT * FROM my_table WHERE my_column LIKE '&quot; &amp; varTextbox &amp; &quot;';&quot;
Set oRSa = Server.CreateObject(&quot;ADODB.Recordset&quot
oRSa.ActiveConnection = Conn
oRSa.Open sqlText
%>