Adding variable to sql statement

[johnv20]

Hi,
I have a form of type:

<form METHOD=&quot;POST&quot; ACTION=&quot;Recordset.asp&quot;>
Enter Family Name <input type=&quot;text&quot; name=&quot;Family&quot;></p>
<input type=&quot;submit&quot; value=&quot;Submit&quot; name=&quot;Family&quot;></p>
</form>

which is writing to an asp page using javascript as follows

<%@ Language=JavaScript %>
Family = String(Request(&quot;Family&quot);
sql = &quot;select * from table where Family = &quot; + Family + &quot;;

however no matter which way I write the code the family variable is not being defined - could somebody please help me.

 

[zakd]

---Recordset.asp---

Dim strFamily
strFamily = Request.Form (&quot;family&quot
SQL = &quot;SELECT * FROM Table WHERE (Family =&quot; & strFamily & &quot&quot;

 

[mithrilhall]

I'm not familiar with Javascript as server-side but possibly something like this:

var Family = String(Request(&quot;Family&quot);
sql = &quot;select * from table where Family = &quot; + 'Family' + &quot;;

Did you try to write your Family variable to the page or bring it up in an alert box? If so does it have a value?

Or try this:

sql = &quot;select * from table where Family = &quot; + &quot;/Family&quot;/;

 

[fiorine]

You're sending the variable in the form and asking for it from the url address
try putting request.form(&quot;Family&quot
instead of String(Request(&quot;Family&quot);