How can I access JavaScript variable from asp?

vicky2003 · May 28, 2003

HI friends,
I got a problem here , anyone could help me?
I'm creating a web form,user can choose different table in this form, then the form will show all the fields in this table. SO I add a event: OnTableSelectChange(). In this function, I try to get table's name,then use ADO get field name from database,the code is :
{
strTableName = document.frmEditSql.elements["selTableName"];
<%
Dim rs
Set cnnADO = dbGetConnection()
strSQL= "select * from " & strTableName
strSQL = strSQL &" where ROWNUM<1"
Set rs = cnnADO.Execute(strSQL)
count = rs.Fields.Count
dim index
For index=0 to count-1
%>objFields.options[<%= index %>] = new Option("<%= rs.fields(index).name%>","<%= rs.fields(index).name%>&quot

;

<%
Next
%>

}
But in asp code, it can't get strTableName from JavaScript. How can I make it work?
Thanks!
vicky

onpnt · May 28, 2003

you need to submit the value to the server in some way

thread216-557022

_________________________________________________________
[sub]$str = "sleep is good for you. sleep gives you the energy you need to function";
$Nstr = ereg_replace("sleep","coffee",$str); echo $Nstr;[/sub]

[sup]

http://www.onpntwebdesigns.com

[/sub]

vicky2003 · May 28, 2003

do you mean "submit" this page to server?
If it is,whole pages contents will be update,I can't let it happen. have any idea?

vicky

onpnt · May 28, 2003

Hi vicky,
yes, you need to determine a way to get the value that you want to be incorpurated into your client level scripting to the server side scripting (ASP) there is no dynamic interaction between the two. The most common ways of performing this task is using hidden form fields to send the values or URL querystrings. eg: page.htm?variable=test

_________________________________________________________
[sub]$str = "sleep is good for you. sleep gives you the energy you need to function";
$Nstr = ereg_replace("sleep","coffee",$str); echo $Nstr;[/sub]

[sup]

http://www.onpntwebdesigns.com

[/sub]

vicky2003 · May 28, 2003

if do so,how can I make sure every items in the form keep previous value? Should I make it myself or use some character of IE(I don't know) when the form loading?
really appreciate your help

onpnt · May 28, 2003

the request object should be all you need.
eg:
when you load the form just include the value attrib to call for the request value
<input type="text" name="txt" value="<%=Request.Form("txt&quot

%>">

what is going to happen here is if the request value is emtpy the value taht is loaded into the input will simply be empty. but if the page had been submitted due to you needing a server script run then when the page loads again the value that the user entered thus will be there again.

there are some simple validation steps you can also take to figure on what you want to load in the page or not.
for example the entire page can become a If conditional statement
<%
If Request.Form("txt&quot

<> "" Then
load something
Else
%>
<body>
<form>
<input type="txt" name="txt">
</form>
<% End If %>

etc...

This being a page that submit's to itself in the action of the form as a page named page.asp having the form tag
<form action="page.asp" method="post">

hope that helps out a bit
if you still have problems can you give details as to what the page is doing and what you need it to do.

_________________________________________________________
[sub]$str = "sleep is good for you. sleep gives you the energy you need to function";
$Nstr = ereg_replace("sleep","coffee",$str); echo $Nstr;[/sub]

[sup]

http://www.onpntwebdesigns.com

[/sub]

vicky2003 · May 29, 2003

this help a lot,so appreciate!

adam0101 · May 29, 2003

Sometimes it's easier just to include a hidden iframe on your page. Submit your request for the little information you need from the db through this iframe so the main frame stays as it is. Then, put an onload attribute in the body tag of the page that loads in the iframe that will put the retrieved data on the main page. For example, the following code will take the zip code the user enters and fill in the City and State for that zip code without leaving the main page.


<html>
<head>
<script language="JavaScript">
function getCityState(zip){
document.ihidden.location.href='getCityState.asp?zip='+zip;
}
</script>
</head>
<body>
<iframe name="ihidden" style="position:absolute;visibility:hidden"></iframe>
<form name="mainForm" action="mainPageHandler.asp" method="post">
<input type="text" name="City" readonly><br>
<input type="text" name="State" readonly><br>
<input type="text" name="ZipCode" onblur="getCityState(this.value)">
</form>
</body>
</html>


<html>
<head>
<script language="JavaScript">
function doload(){
<%
'Put code to open your db here

Set rsCityState = conn.Execute("SELECT * FROM Zips WHERE ZipCode='" & Request("zip&quot

& "'&quot

If rsCityState.EOF Then
Response.Write "alert('Zip Code not found!')"
Else
Response.Write "parent.document.mainForm.City.value='" & rsCityState("City&quot

& "';"
Response.Write "parent.document.mainForm.State.value='" & rsCityState("State&quot

& "';"
End If
%>
}
</script>
<body onload="doload()">

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How can I access JavaScript variable from asp?

vicky2003

Programmer

onpnt

Programmer

vicky2003

Programmer

onpnt

Programmer

vicky2003

Programmer

onpnt

Programmer

vicky2003

Programmer

adam0101

Programmer

Similar threads

Part and Inventory Search

Sponsor