help with db recordset

Hi There, I am new to asp, i am creating an app using asp/access2000 my site
is live/
http://shopgpbikes.com/sport.asp

What I am looking to do is when thumbnail is clicked
i want the record set plus the large image to appear in the popup. As it is
now just the large image shows in the popup.
Any help would be greatly appreciated.
CT.

Re: help with db recordset

On Sun, 23 Jan 2005 15:01:28 -0500, "ct"
wrote:

>Hi There, I am new to asp, i am creating an app using asp/access2000 my site
>is live/
>http://shopgpbikes.com/sport.asp
>
>What I am looking to do is when thumbnail is clicked
>i want the record set plus the large image to appear in the popup. As it is
>now just the large image shows in the popup.
>Any help would be greatly appreciated.

Obvious answer: Add the code to display whatever you want in the
popup window.

Unfortunately, we can't see your code so we can't help on that end.
You can loop through the recordset and display it, but without an idea
of your record layout and columnh structure it's tough to even suggest
code.

Jeff

Re: help with db recordset

Here is the code for the sport.asp

<%@ LANGUAGE="VBSCRIPT" %>
<%Response.Buffer=TRUE%>
<%
Dim cnnSimple ' ADO connection
Dim rstSimple ' ADO recordset
Dim strDBPath ' path to our Access database (*.mdb) file


' MapPath of virtual database file path to a physical path.
' If you want you could hard code a physical path here.
strDBPath = Server.MapPath("bikes.mdb")


' Create an ADO Connection to connect to the scratch database.
' We're using OLE DB but you could just as easily use ODBC or a DSN.
Set cnnSimple = Server.CreateObject("ADODB.Connection")

' This line is for the Access sample database:
cnnSimple.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
strDBPath & ";"



' Execute a query using the connection object. It automatically
' creates and returns a recordset which we store in our variable.
Set rstSimple = cnnSimple.Execute("SELECT * FROM sport where year <=1997
")


' Display a table of the data in the recordset. We loop through the
' recordset displaying the fields from the table and using MoveNext
' to increment to the next record. We stop when we reach EOF.
%>

Re: help with db recordset

On Mon, 24 Jan 2005 07:53:31 -0800, Charlie Terzo
wrote:

In the future, try to post only the relevant code, not the entire
page. Stripping out formatting helps too. At any rate, I think the
issue you're asking about is here:

>
>

>href="javascript:launch('images/bikes/<%= rstSimple("image_lrg")
>%>')"> width="150"
>height="97" border="0"

<%= rstSimple("year")
>%>
> >face="Arial" size="2" color="#FFffff">Make
> : >size="2" color="#C0C0C0">
>

<%= rstSimple("make")
>%>
> >face="Arial" size="2" color="#FFffff">Model
> : >size="2" color="#C0C0C0">
>

<%= rstSimple("model")
>%>
> >face="Arial" size="2" color="#FFffff">Description
> : >size="2" color="#C0C0C0">
>

<%= rstSimple("description")
>%>

This apparently displays a single record, with all the information and
a Popup of the image in a larger format. That uses this portion of
the code (code wraps):

> >href="javascript:launch('images/bikes/<%= rstSimple("image_lrg")
>%>')"> width="150"
>height="97" border="0"

The JavaScript link only displays the image, nothing else. To display
the rest, you need to modify the link above to do more than just
launch the image file.

What you might do is use the primary key for the record (couldn't tell
waht it was or even if you have one...) and call a new page and pass
that value to it, then re-read the database for just that record and
display the details. Sort of like:

Link:


target=_blank">
width="150" height="97" border="0"

ShowDetails.asp:

<%

ItemID = Request.Querystring("ItemID")
strDBPath = Server.MapPath("bikes.mdb")
Set cnnSimple = Server.CreateObject("ADODB.Connection")
cnnSimple.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
strDBPath & ";"
Set rstSimple = cnnSimple.Execute("SELECT * FROM sport where
PrimaryKeyField = ItemID
")

{ Display the fields, blah, blah, blah... }

Keep in mind this isn't tested and syntax is from memory, but easy
enough to Google. You'll need to change your field names and make
sure you have a unique ID field (primary Key).

Jeff

Re: help with db recordset

Thanks so much!
I will work on this.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!