<ja***@catamaranco.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
:I am hoping a mixed ASP- Javascript programmer could help me with this
: scenario:
:
: I have a list box populated with randomized records (NewID()) from a
Broker
: (Salesperson) sql server table.
:
: Each time the user selects one of the broker items I need to display a
Image
: of the broker in the table cell next to it.
:
: I have found a number of online js scripts that use the image selector
route
: but I am unable to work out to populate the list
: item from the database AND at the same time utilize the JS...
:
: Are there any coders who come across a solution like this. Here is an
: example of my ASP code populating the List box:
:
: Set oCmd = GetStoredProcedure(oConn,"spr_GetBroker")
: set oRS = oCmd.execute()
: Response.write ("<TR><TD class=text><strong>Broker:</strong></TD><TD>")
: Response.write "<select name='u_BrokerID' size='4'
: onChange='generateimage(this.options[this.selectedIndex].value)'>"
: '//Response.Write("<TR><TD
: class=text><strong>Broker:</strong></TD><TD><SELECT NAME=u_BrokerID>")
: If oRS.eof then
: Response.Write("<option>No records found for Nation</option>")
: else
: while not oRS.eof
: Response.Write("<OPTION VALUE=""" & oRS.fields(0) & """>" &
: oRS.fields(1) & "</OPTION>")
: oRS.movenext
: wend
: End If
:
: Response.Write("</SELECT>")
:
: I now need to load the images (from the imagePath inside my database ie
: rs(3)) and then trigger an event to launch a new image
: in the next table cell...
:
: Appreciate any advice!!!
Maybe this will help you get started...untested
sub prt(str)
response.write(str & vbCrLf)
end sub
Set oCmd = GetStoredProcedure(oConn,"spr_GetBroker")
set oRS = oCmd.execute()
prt("<html>")
ptr("<head><title></title>")
prt("<script type=""text/javascript"">")
prt("function generateimage(x) {")
prt(" document.getElementById('brokerimage').src = ""/images/" + x +
".jpg"";")
prt(" }")
prt("</script>")
prt("</head>")
prt("<body>")
prt("<table>")
prt("<tr colspan=2><td class=text><b>Broker:</b></td><tr>")
prt("<tr><td>
prt("<select name=""u_BrokerID"" size=""4""
onChange=""generateimage(this.options[this.selectedIndex].value)"">")
If oRS.eof then
prt("<div>No records found for Nation</div>")
else
do while not oRS.eof
prt("<option value=""" & oRS.fields(0).value & """>" &
oRS.fields(1).value & "</option>")
oRS.movenext
loop
End If
prt("</select></td>")
prt("<td><img id="brokerimage" name="brokerimage" src="""" /></td>")
prt("</table>")
prt("</body>")
prt("</html>")
set oRS = nothing
set oCmd = nothing
--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center -
http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation -
http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library -
http://msdn.microsoft.com/library/default.asp