capturing asp data in clientside javascript

Terry Joseph Migliorino · October 31st, 2005, 01:25 PM

I need to either open a database with javascript or pass an asp array to a javascript array, the following is what I've tried.
In the <head>:

var arrCollageImg = new Array;
arrCollageImg = <%=arrCollageData%>;

Then later in the <body> of the page I will do the following:

<script type="text/javascript">
  for(var i=0;i<arrCollageImg.length - 1; i++){
   document.write("<div>");
   document.write("<img src='images/collage/" + arrCollageImg[4][i] + "'")
   document.write("/<div>");
  }
</script>

Any help will be apprieciated.

Terry Migliorino

ChrisScott · October 31st, 2005, 01:42 PM

Hi Terry,

How you populate your client-side array will depend on it's dimensions in the server side array.
So for an array in ASP / VBScript you could do something like...

Code:

var arrCollageImg = new Array();
<%
For i = 0 To UBound(arrCollageData)
    Response.Write "arrCollageImg[" & i & "] = """ & Replace(arrCollageData, """", "\""") & """;"
Next
%>

HTH,

Chris

Terry Joseph Migliorino · October 31st, 2005, 01:52 PM

Thanks Cris.

I'm still getting an error, but it may be in my asp code (which is vbscript).

Terry Migliorino
[email protected]

ChrisScott · November 1st, 2005, 04:26 AM

Hi Terry,

Can you post your code and the error, please (including where the array is populated in ASP)?

Cheers,

Chris

crmpicco · November 1st, 2005, 07:19 AM

you can connect to a DB with JavaScript, but it is not recommended for security reasons.

also, if arrCollageImg has no elements it cant pick out a UBound.

Picco

www.crmpicco.co.uk

Terry Joseph Migliorino · November 1st, 2005, 03:57 PM

This is the vbscript that populates arrPageData.

<%
    dim oRS, arrPageData, intArrLen1, intArrLen2

    select case session("sesPageName")
        case "restorationPage"
            strSql = "qryAllRestorationData"
        case "retouchingPage"
            strSql = "qryAllRetouchingData"
        case "collagePage"
            strSql = "qryAllCollageData"
        case "galleryDigitalMenuPage"
            strSql = "qryAllDigitalGalleryData"
        case "galleryPhotoMenuPage"
            strSql = "qryAllPhotoGalleryData"
    end select

    Set oRS = Server.CreateObject("ADODB.Recordset")
    oRS.Open strSql, "dsnCJMGData", adOpenStatic, adLockOptimistic
    arrPageData = oRS.GetRows
    intArrLen = ubound(arrPageData,2)
    oRs.Close
    Set oRs = Nothing
%>

This is the page code.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<%
    session("sesPageName") = "collagePage"
%>

<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta name=vs_defaultClientScript content="JavaScript">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="GENERATOR" content="Microsoft FrontPage 6.0" />
<meta name="ProgId" content="FrontPage.Editor.Document" />
<link rel="stylesheet" type="text/css" href="CJMGraphicsPublic.css" />

<title>CJM Graphics Collage Page</title>
<script language="javascript">

</script>
</head>

<body>
<script type="text/javascript">
  for(var i=0;i<arrCollageImg.length - 1; i++){
   document.write("<div>");
   document.write("<img src='images/collage/" + arrCollageImg[4][i] + "'")
   document.write("/<div>");
  }
</script>

</body>

</html>

</html>

Terry Migliorino
[email protected]

crmpicco · November 2nd, 2005, 05:29 AM

i'm having a similar problem:

Code:

    var cabin = "<%=cabin_name%>";
    alert("cabin = " + cabin);

Why wont this work? I have set the value cabin name in the ASP??

Picco

www.crmpicco.co.uk

ChrisScott · November 2nd, 2005, 05:37 AM

Hi Terry,

The second argument of UBound should be 1 for the first dimension, 2 for the second etc. not 0, 1, ...

HTH,

Chris

ChrisScott · November 2nd, 2005, 07:52 AM

Picco,

You code looks fine, there must be an error somewhere else in the page - the variable may have gone out of scope / be empty / etc.

Cheers,

Chris

crmpicco · November 2nd, 2005, 09:10 AM

the general structure is

ASP Page:

<%
asp code....

%>
<scrript src="inc.js>

<% cabin_name = "UUUU" %>

can i not get "cabin_name" inside the inc.js file?

www.crmpicco.co.uk