Newbie Q: calling access data on onclick function

Jeremy · Jeremy

I am working on a page which will post a set of images which can be
clicked upon to show a larger image along with information associated
with the image from the access data table(s) onto a pseudo-window
using CSS (to avoid pop-up blockers). So basically, I call the images
from the table and display them on the page. When one is clicked, a
'window' will open showing the info associated with that particular
image. Given that there will be a large number of pictures (1000+),
each with several data associated with it, using an array is not
practical to pull the data so I'd like to call the data using another
sql call associated with, say, the image name.

Anyone know how I might go about this??

Thanks in advance,

Jeremy

PS: Here is my code so far-

<%@LANGUAGE="JAVASCRIPT"%>

<head>
<script language="JavaScript">
<%

var imgs="";
var ident=0;
var pics = "";

var conn = Server.CreateObject("ADODB.Connection");
var rs = Server.CreateObject("ADODB.Recordset");
var sql1 = "SELECT DISTINCT * FROM Photos, Artists WHERE
Photos.[Artist ID] = Artists.[Artist ID] ORDER BY Photos.Entered
DESC";
conn.Open("DSN=photo");
rs.Open(sql1,conn);

var n=0;
var i=0;
var j=0;
while (!rs.EOF)
{
var img = rs.Fields("Photo").value;
var art = rs.Fields("Artist").value;
var ttl = rs.Fields("Title").value;
var spc = rs.Fields("Species").value;
var dsc = rs.Fields("Description").value;
var org = rs.Fields("Organization").value;
var ad1 = rs.Fields("Address1").value;
var cty = rs.Fields("City").value;
var stt = rs.Fields("State").value;
var zip = rs.Fields("Zip").value;
var cry = rs.Fields("Country").value;
var eml = rs.Fields("Email").value;
var web = rs.Fields("Web").value;
var pics = pics += "<td id=" + i + "
onClick=\"Pic_Do();Pic_Get(this);\"><img name='" + img + "' src
='../images/photos/" + img + "' width='100' height='100'>
 <br>\n";
rs.MoveNext();

var imgs = imgs += "src[" + i + "] ='../images/photos/" + img +
"'\n";
i=i+1;
}
rs.Close();
%>

function Pic_Do() {
document.forms['winForm'].className='winShow'
}
function Pic_Get(cell) {
var ident = cell.id;
var src = new Array();
<%=imgs%>
document.images['SelPic'].src = src[ident];

}
</script>
<style type="text/css">

</style>
</head>
<html>
<BODY>

<FORM id="pic" name="picform" class="pics">
<table>
<tr>
<%=pics%>
</tr>
</table>
</FORM>
<span id="win" class="WinHide">
<form name="winForm">
<table>
<tr>
<td>
<img name="SelPic" height="200" width="200"><br>
</td>
<td>
<b>Title: </b><br>
<b>Species: </b><br>
<b>Description: </b><br>
<b>Photographer: </b><br>
<b>Organization: </b><br>
<b>Address: </b><br>
<b>Email: </b><br>
<b>Web Site: </b><br>
</td>
</tr>
</table>

<center>
<input type="Button"
OnClick="document.forms['winForm'].className='WinHide'" value="Close
Window">
</center>

</form>
</span>
</BODY>
</HTML>

Evertjan. · Evertjan.

Jeremy wrote on 08 jul 2004 in microsoft.public.inetserver.asp.db:

> I am working on a page which will post a set of images which can be
> clicked upon to show a larger image along with information associated
> with the image from the access data table(s) onto a pseudo-window
> using CSS (to avoid pop-up blockers). So basically, I call the images
> from the table and display them on the page. When one is clicked, a
> 'window' will open showing the info associated with that particular
> image. [snip]

You are making an serverside variant string called pics,
that you are never using.

So I cannot fathom what you would want to do.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Newbie Q: calling access data on onclick function

Thread Tools

Display

Newbie Q: calling access data on onclick function

Similar Questions and Discussions

Calling a php Function from an onClick event

onClick without loosing data

Calling a function within a function registered to an event

Error calling MS-Access Module Function from SQL

data access in a udf table function

Re: Newbie Q: calling access data on onclick function

Posting Permissions