Passing db values to function

[Darby]

Hello,
I am creating dynamic images with corresponding checkboxes by pulling
data from an Access database. The onchange event of the checkboxes
calls a javascript function which basically stores the image name
taken from the database into an array. Unfortunately I am having a
problem doing this the way I would like. I have no problem passing
the primary key from the Access database (IDNum), which is an
autonumber, but I am unable to pass the name of the image (Name) which
I have designated as a text data type. I get an error message telling
me the value I am trying to pass is undefined. I would appreciate any
help on this.

Dim connCW, strQuery, rsItem, counter

'Create and open the database connection object
Set connCW = Server.CreateObject("ADODB.Connection")
connCW.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & Server.MapPath("../db/Library.mdb")
SET rsItem = connCW.Execute("SELECT * FROM
"&request.querystring("pres")&" WHERE
Category='"&request.querystring("cat")&"'")

counter=1

Response.write "<table cellpadding=0 cellspacing=0><tr>"
Do While Not rsItem.EOF

Response.Write "<td align=center width=200><a
href=FullView.asp?Slide="&rsItem("Name")&"><img
src=../"&request.querystring("pres")&"/"&request.querystring("cat")&"/Slides/150/"&rsItem("Name")&"
border=0 width=150 height=113></a><br>"

'this DOES NOT work as it is now, but works if I change "Name" to
"IDNum"
Response.Write "<input type=checkbox name="&counter&"
onchange=javascript:checkBoxes("& rsItem("Name") &")></td>"

if counter mod 4=0 then
Response.Write "</tr><tr><td>&nbsp</td></tr><tr>"
end if
counter=counter+1
rsItem.MoveNext
Loop
response.write "</table>"

connCW.close()

[Manohar Kamath [MVP]]

Because on the Javascript side, the name is a string - you need to enclose
it in 's. Otherwise, Javascript will think it is a variable you haven't
defined, and hence the error.

Try:

Response.Write "<input type=checkbox name="&counter&"
onchange=javascript:checkBoxes('"& rsItem("Name") & "')></td>"



--
Manohar Kamath
Editor, .netWire
[url]www.dotnetwire.com[/url]


"Darby" <darby_chris@hotmail.com> wrote in message
news:88c20d1b.0408061126.767cd8c8@posting.google.c om...

> Hello,
> I am creating dynamic images with corresponding checkboxes by pulling
> data from an Access database. The onchange event of the checkboxes
> calls a javascript function which basically stores the image name
> taken from the database into an array. Unfortunately I am having a
> problem doing this the way I would like. I have no problem passing
> the primary key from the Access database (IDNum), which is an
> autonumber, but I am unable to pass the name of the image (Name) which
> I have designated as a text data type. I get an error message telling
> me the value I am trying to pass is undefined. I would appreciate any
> help on this.
>
> Dim connCW, strQuery, rsItem, counter
>
> 'Create and open the database connection object
> Set connCW = Server.CreateObject("ADODB.Connection")
> connCW.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
> "DBQ=" & Server.MapPath("../db/Library.mdb")
> SET rsItem = connCW.Execute("SELECT * FROM
> "&request.querystring("pres")&" WHERE
> Category='"&request.querystring("cat")&"'")
>
> counter=1
>
> Response.write "<table cellpadding=0 cellspacing=0><tr>"
> Do While Not rsItem.EOF
>
> Response.Write "<td align=center width=200><a
> href=FullView.asp?Slide="&rsItem("Name")&"><img
>

src=../"&request.querystring("pres")&"/"&request.querystring("cat")&"/Slides
/150/"&rsItem("Name")&"

> border=0 width=150 height=113></a><br>"
>
> 'this DOES NOT work as it is now, but works if I change "Name" to
> "IDNum"
> Response.Write "<input type=checkbox name="&counter&"
> onchange=javascript:checkBoxes("& rsItem("Name") &")></td>"
>
> if counter mod 4=0 then
> Response.Write "</tr><tr><td>&nbsp</td></tr><tr>"
> end if
> counter=counter+1
> rsItem.MoveNext
> Loop
> response.write "</table>"
>
> connCW.close()

[Darby]

"Manohar Kamath [MVP]" <mkamath@TAKETHISOUTkamath.com> wrote in message news:<O65quEAfEHA.3732@TK2MSFTNGP11.phx.gbl>...

> Because on the Javascript side, the name is a string - you need to enclose
> it in 's. Otherwise, Javascript will think it is a variable you haven't
> defined, and hence the error.
>
> Try:
>
> Response.Write "<input type=checkbox name="&counter&"
> onchange=javascript:checkBoxes('"& rsItem("Name") & "')></td>"
>
>
>
> --
> Manohar Kamath
> Editor, .netWire
> [url]www.dotnetwire.com[/url]
>
>
> "Darby" <darby_chris@hotmail.com> wrote in message
> news:88c20d1b.0408061126.767cd8c8@posting.google.c om...

> > Hello,
> > I am creating dynamic images with corresponding checkboxes by pulling
> > data from an Access database. The onchange event of the checkboxes
> > calls a javascript function which basically stores the image name
> > taken from the database into an array. Unfortunately I am having a
> > problem doing this the way I would like. I have no problem passing
> > the primary key from the Access database (IDNum), which is an
> > autonumber, but I am unable to pass the name of the image (Name) which
> > I have designated as a text data type. I get an error message telling
> > me the value I am trying to pass is undefined. I would appreciate any
> > help on this.
> >
> > Dim connCW, strQuery, rsItem, counter
> >
> > 'Create and open the database connection object
> > Set connCW = Server.CreateObject("ADODB.Connection")
> > connCW.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
> > "DBQ=" & Server.MapPath("../db/Library.mdb")
> > SET rsItem = connCW.Execute("SELECT * FROM
> > "&request.querystring("pres")&" WHERE
> > Category='"&request.querystring("cat")&"'")
> >
> > counter=1
> >
> > Response.write "<table cellpadding=0 cellspacing=0><tr>"
> > Do While Not rsItem.EOF
> >
> > Response.Write "<td align=center width=200><a
> > href=FullView.asp?Slide="&rsItem("Name")&"><img
> >

> src=../"&request.querystring("pres")&"/"&request.querystring("cat")&"/Slides
> /150/"&rsItem("Name")&"

> > border=0 width=150 height=113></a><br>"
> >
> > 'this DOES NOT work as it is now, but works if I change "Name" to
> > "IDNum"
> > Response.Write "<input type=checkbox name="&counter&"
> > onchange=javascript:checkBoxes("& rsItem("Name") &")></td>"
> >
> > if counter mod 4=0 then
> > Response.Write "</tr><tr><td>&nbsp</td></tr><tr>"
> > end if
> > counter=counter+1
> > rsItem.MoveNext
> > Loop
> > response.write "</table>"
> >
> > connCW.close()

Thanks Manohar, that did it for me.

Chris.