Hi,

I'm having trouble with using a Javascript value in ASP. In my asp page I have a form:

<form name="form">

<input type="text" name="country">

<input type="submit" name="submit" onclick="return cmdSubmit_onclick()">

</form>

On top of my asp page I have a Javascript function link this:

function cmdSubmit_onclick() {

ctry = document.form.country.value

if (ctry!="")

{

<% strSQL = "SELECT Country FROM SC WHERE Country = " &ctry%>

}

}

My question is how do I use the value of ctry in ASP?

Really appreciate if someone could help me.

Thanks

No way, AFAIK. Javascripts executes on client, but vbscript in your case executes on server, i.e. before javascript. The only solutions is to load all countries from database and make javascript array out of them, and then select proper country by js from js array.

So, since ASP is executing vbscript first means you can dynamically build javascript out of asp (let's say database records), but tot vice versa.

can submit the form to the same page:

<form name="form" method=post action="thispage.asp>

Capture ctry in code:

ctry = request.form("ctry")

then perform sql action.