javascript + database

[Navodit]

Hi

I want to write code in Javascript which pulls out entries from a database
via a for loop. Essentially what I am trying to do is something like:

//setting up database connection
<%
Set cnn = ...
filePath = ...
cnn.Open ....
Set rst = ...
sqlquery = "SELECT ....."
rst.open sqlquery, cnn, 2, 2
%>

//Javascript code
<SCRIPT LANGUAGE = "JavaScript">
<!--
.....
function test()
{
document.Insurance.county.length = 10;
for (var x = 1; x <= 10; x++)
{
document.Insurance.county[x].value = rst("County_ID");
document.Insurance.county[x].text = rst("County");
rst.next();
}
}
.....
--!>

Is something like this possible or am I doing something incorrect here? This
is part of a code for a form where "County" is a dropdown. So instead of
hardcoding the values for "County_ID" and "County", I want to write a for
loop which loads the values to be displayed in the dropdown from the
database. Any help/hints/suggestions would be highly appreciated...

Navodit

[Evertjan.]

Navodit wrote on 11 apr 2007 in comp.lang.javascript:

Hi

I want to write code in Javascript which pulls out entries from a
database via a for loop. Essentially what I am trying to do is
something like:

//setting up database connection
<%
Set cnn = ...
filePath = ...
cnn.Open ....
Set rst = ...
sqlquery = "SELECT ....."
rst.open sqlquery, cnn, 2, 2
%>

//Javascript code
<SCRIPT LANGUAGE = "JavaScript">
<!--
....
function test()
{
document.Insurance.county.length = 10;
for (var x = 1; x <= 10; x++)
{
document.Insurance.county[x].value = rst("County_ID");
document.Insurance.county[x].text = rst("County");
rst.next();
}
}
....
--!>

Is something like this possible or am I doing something incorrect
here? T

You are disregarding serverside and clientside script.

Serverside asp can be either vbscript or j[ava]script, but is executed on
the server, where your database resides.

rhe resiult of rst("County_ID") is only available on the server script,
unless you port it as a inline string to the client:

var C-id = "<% = rst("County_ID") %>";

but on the client rst.next(); means nothing at all.

Serverside code results in a html [+ clientside code] stream to the
client where the html and the clientside code are interpreted by the
browser. The serverside code is finished before that.

[Real Gagnon]

Is something like this possible or am I doing something incorrect

here? This is part of a code for a form where "County" is a dropdown.
So instead of hardcoding the values for "County_ID" and "County", I
want to write a for loop which loads the values to be displayed in the
dropdown from the database. Any help/hints/suggestions would be highly
appreciated...

You ASP code is running on the server-side and the javascript on the
client-side so the javascript can't use directly your ASP rst object.

One way is to put the rst data into an hidden field and then from
javascript, extract the data from the hidden field.

One example at :
http://www.rgagnon.com/jsdetails/js-0117.html

Bye.
--
Real Gagnon from Quebec, Canada
* Java, Javascript, VBScript and PowerBuilder code snippets
* http://www.rgagnon.com/howto.html
* http://www.rgagnon.com/bigindex.html

[wreed]

On Apr 11, 1:18 pm, Real Gagnon <[e-mail]:

Is something like this possible or am I doing something incorrect
here? This is part of a code for a form where "County" is a dropdown.
So instead of hardcoding the values for "County_ID" and "County", I
want to write a for loop which loads the values to be displayed in the
dropdown from the database. Any help/hints/suggestions would be highly
appreciated...

You ASP code is running on the server-side and the javascript on the
client-side so the javascript can't use directly your ASP rst object.

One way is to put the rst data into an hidden field and then from
javascript, extract the data from the hidden field.

One example at :http://www.rgagnon.com/jsdetails/js-0117.html

Bye.
--
Real Gagnon from Quebec, Canada
* Java, Javascript, VBScript and PowerBuilder code snippets
*http://www.rgagnon.com/howto.html
*http://www.rgagnon.com/bigindex.html

Try loading your recordset into an array then converting the asp array
to javascript, check out
http://www.aspfree.com/c/a/ASP/Conve...d-Venkatraman/

[Ivan Marsh]

On Wed, 11 Apr 2007 12:01:05 -0500, Navodit wrote:

Is something like this possible or am I doing something incorrect here?
This is part of a code for a form where "County" is a dropdown. So
instead of hardcoding the values for "County_ID" and "County", I want to
write a for loop which loads the values to be displayed in the dropdown
from the database. Any help/hints/suggestions would be highly
appreciated...

As others have suggested you may need to read up on the client/server
model for programming web applications.

The only way for JavaScript to be able to see your server-side data is to
pass it to the client using your server-side script.

You do this by having the server-side script create the client-side
javascript:

<?
$test_var = "I am a test variable";
echo "<script type='text/javascript'>";
echo "var test = $test_var;";
echo "</script>";
?>

This will leave you with a client-side variable "test" that has been
loaded with data from the server-side variable "test_var".

[Marc]

"Ivan Marsh" <an*****@you.nowwrote in message
news:pa****************************@you.now...

On Wed, 11 Apr 2007 12:01:05 -0500, Navodit wrote:

>Is something like this possible or am I doing something incorrect here?
This is part of a code for a form where "County" is a dropdown. So
instead of hardcoding the values for "County_ID" and "County", I want to
write a for loop which loads the values to be displayed in the dropdown
from the database. Any help/hints/suggestions would be highly
appreciated...

As others have suggested you may need to read up on the client/server
model for programming web applications.

The only way for JavaScript to be able to see your server-side data is to
pass it to the client using your server-side script.

You do this by having the server-side script create the client-side
javascript:

<?
$test_var = "I am a test variable";
echo "<script type='text/javascript'>";
echo "var test = $test_var;";
echo "</script>";
?>

This will leave you with a client-side variable "test" that has been
loaded with data from the server-side variable "test_var".

echo "var test = '$test_var';";