Connect to Database

awieds · 06-29-2005, 12:11 AM

How do I connect to a database using Javascript? I have an asp page. I connect to the database using VBscript and it works fine but I don't know how to connect using javascript.
The following is my vbscript code:

Set rs = Server.CreateObject("ADODB.Recordset")
strQuery="Select * from products"
rs.Open strQuery, MM_myConn_STRING, 0, 2 ,1
How do I do that in javascript??

Either that or I can create an array using vbscript if there is a way for me to access it in javascript.

Thanks!

DJMaze · 06-29-2005, 12:52 AM

do you know javascript is client side scripting?
anything which is on that side of the globe shouldn't contain any login system so not available

redhead · 06-29-2005, 12:54 AM

Quote:

How do I do that in javascript??

You don't
Javascript runs clientside, asp runs serverside.
Do you see the difference ??

The way to go, would be to create your javascript holding the information fetched from the database using your vbscript, so you'd dynamicaly create the javascript from your serverside run asp, which then can be run clientside.

awieds · 06-29-2005, 12:59 AM

Yes, I understand. I am just stuck!
How do I create the array using vbscript and then access it through javascript??
(Because I need to access an element on the page to match up so I need to do that using javascript)
When I tried creating a recordset with VBscript and then using it with javascript it didn't recognize the recordset

awieds · 06-29-2005, 01:35 AM

How do I create javascript holding infofetched from database using vbscript?
Thanks!

awieds · 06-29-2005, 01:54 AM

I created the array in vbscript but my javascript code doesn't recognize it. How can I get it to recognize it?
Thanks

DJMaze · 06-29-2005, 04:55 AM

Code:

<script language="JavaScript1.2">
var myarray = new array();
</script>

Do you have any code to share with us so that we realy understand what, how and when?

awieds · 06-30-2005, 12:05 AM

Sorry...

Code:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<!--#include file="../Connections/myConn.asp" -->
<%
Dim rs
dim strQuery
dim arrProducts()
dim arrDescription()
dim i
Set rs = Server.CreateObject("ADODB.Recordset")
strQuery="Select * from products" 
rs.Open strQuery, MM_myConn_STRING, 0, 2 ,1
while not rs.bof and not rs.eof
		redim preserve arrProducts(i)
		redim preserve arrDescription(i)
		arrProducts(i)=rs("ProductName")
		arrDescription(i)=rs("Description")
		i=i+1
		rs.movenext
wend
rs.Close()
set rs=nothing
%>
<script language="javascript">
<!--

function PopulateDesc(prod)
{
alert(prod);
}
</script>
</head>
<body>
<select name="products" id="products" language="javascript" onChange="PopulateDesc(myForm.products.value)">
<% dim j 
for j=lbound(arrProducts) to ubound(arrProducts)%>
<option value="<%=arrProducts(j)%>"><%=arrProducts(j)%> </option>
<%next%>
</select>
</body></html>

I am trying to get the product that the user selected. I have an alert in my javascript function to test it. It works fine, I got the product. Then I want to get the decription of that product and populate a textbox with it. I have made two parallel arrays in vbscript but how can I use the arrays in javascript or get the product into vbscript??
Thanks for any help!

redhead · 06-30-2005, 02:26 AM

Would somethign like this do ?

Code:

...
<script language="javascript">
<!--
var description = new array (
<% dim i 
for i=lbound(arrDescription) to ubound(arrDescription)%>
"<%=arrDescription(i)%>",
""
);

function PopulateDesc(prod)
{
     document.myForm.description.value=description[0 + prod];
}
// -->
</script>
...
<form name="myForm">
<select name="products" id="products" language="javascript" onChange="PopulateDesc(myForm.products.value)">
<% dim j 
for j=lbound(arrProducts) to ubound(arrProducts)%>
<option value="<%=j%>"><%=arrProducts(j)%> </option>
<%next%>
</select>
<input type="text" name="description" value="">
</form>
...