Image Page using a Database

[J Rhymes]

I’ve set up a page to display items for sale and a linked image through our
access database. http://70.154.145.58/customers/equipment_sale.asp Everything
works like I want. After looking at it I figured it would be better to have a
list with a thumbnail something like this
http://70.154.145.58/customers/equipment_sale_a.asp. My problem is I can’t
figure out how to pass the ProductID, when selected, to the page to show the
details. Is this possible? I’ve tried everything I could think of.

 

[Murray]

The thumb image would have to link to the product page like this -

<a href="products.asp?product=<% yourproductIDfield %>"...

and the products page would have to read that ProductID from the url (with
request.querystring('productID') - or whatever the variable name is), and
then use that value to filter the recordset in the SELECT statement.

Does that make sense?

 

[J Rhymes]

Thanks, Please stay with me. I’m trying to get it to work. This it what I have

<a href="equipment_sale.asp?ProductID=<% ProductID %>"

This is what I get:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'ProductID'
/customers/equipment_sale3.asp, line 45


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; SV1; .NET CLR
1.1.4322; .NET CLR 2.0.50727)

Page:
GET /customers/equipment_sale3.asp

 

[Murray]

Hmm - how have you defined the field "ProductID" in the database?

 

[J Rhymes]

It's the primary key as text. Is that what you're asking?

 

[J Rhymes]

....Or is this what you'r elooking for?

SELECT * FROM Eq_Sale ORDER BY ProductID ASC

It may be where I'm placing the tag that's given me the error.

<a href="equipment_sale.asp?productID=<% ProductID %>
<img border="0" src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69">

 

[Murray]

<a href="equipment_sale.asp?productID=<% ProductID %>">
<img border="0" src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69"></a>

That's how your markup should look - is that correct?

 

[J Rhymes]

I think I'm getting closer with this

<a href="equipment_sale.asp?ProductID=<%=FP_FieldURL(fp_rs,"ProductID")%>">
<img border="0" src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="71">

Which is sending a link to the other page like this:

http://70.154.145.58/customers/equipment_sale.asp?ProductID=DRG-05

Is this what I'm after?
My other page is displaying this:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

 

[Murray]

ProductID=DRG%2D05
-----------------------^^^^^

What is that character (the one between "G" and "05"?

--
Murray
--------------
MVP FrontPage

I think I'm getting closer with this

<a
href="equipment_sale.asp?ProductID=<%=FP_FieldURL(fp_rs,"ProductID")%>">
<img border="0" src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="71">

Which is sending a link to the other page like this:

http://70.154.145.58/customers/equipment_sale.asp?ProductID=DRG-05

Is this what I'm after?
My other page is displaying this:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

<a href="equipment_sale.asp?productID=<% ProductID %>">
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69"></a>

That's how your markup should look - is that correct?

 

[J Rhymes]

DRG-05
I tried typing it in the address bar manually but it gave me the same
results.
This is my query on the other end:

SELECT * FROM Eq_Sale WHERE (Request.Querystring = ':roductID::')

ProductID=DRG%2D05
-----------------------^^^^^

What is that character (the one between "G" and "05"?

--
Murray
--------------
MVP FrontPage

I think I'm getting closer with this

<a
href="equipment_sale.asp?ProductID=<%=FP_FieldURL(fp_rs,"ProductID")%>">
<img border="0" src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="71">

Which is sending a link to the other page like this:

http://70.154.145.58/customers/equipment_sale.asp?ProductID=DRG-05

Is this what I'm after?
My other page is displaying this:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

<a href="equipment_sale.asp?productID=<% ProductID %>">
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69"></a>

That's how your markup should look - is that correct?


--
Murray
--------------
MVP FrontPage


...Or is this what you'r elooking for?

SELECT * FROM Eq_Sale ORDER BY ProductID ASC

It may be where I'm placing the tag that's given me the error.

<a href="equipment_sale.asp?productID=<% ProductID %>
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69">

:

Hmm - how have you defined the field "ProductID" in the database?

--
Murray
--------------
MVP FrontPage


Thanks, Please stay with me. I'm trying to get it to work. This it
what
I
have

<a href="equipment_sale.asp?ProductID=<% ProductID %>"

This is what I get:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'ProductID'
/customers/equipment_sale3.asp, line 45


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; SV1;
.NET
CLR
1.1.4322; .NET CLR 2.0.50727)

Page:
GET /customers/equipment_sale3.asp


:

The thumb image would have to link to the product page like this -

<a href="products.asp?product=<% yourproductIDfield %>"...

and the products page would have to read that ProductID from the
url
(with
request.querystring('productID') - or whatever the variable name
is),
and
then use that value to filter the recordset in the SELECT
statement.

Does that make sense?

--
Murray
--------------
MVP FrontPage


I've set up a page to display items for sale and a linked image
through
our
access database.
http://70.154.145.58/customers/equipment_sale.asp
Everything
works like I want. After looking at it I figured it would be
better
to
have a
list with a thumbnail something like this
http://70.154.145.58/customers/equipment_sale_a.asp. My problem
is I
can't
figure out how to pass the ProductID, when selected, to the page
to
show
the
details. Is this possible? I've tried everything I could think
of.

 

[Thomas A. Rowe]

<%
ProductID = Request.QueryString("ProductID")
%>

SELECT * FROM Eq_Sale WHERE ProductID = '" & ProductID & "'

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

DRG-05
I tried typing it in the address bar manually but it gave me the same
results.
This is my query on the other end:

SELECT * FROM Eq_Sale WHERE (Request.Querystring = ':roductID::')

ProductID=DRG%2D05
-----------------------^^^^^

What is that character (the one between "G" and "05"?

--
Murray
--------------
MVP FrontPage

I think I'm getting closer with this

<a
href="equipment_sale.asp?ProductID=<%=FP_FieldURL(fp_rs,"ProductID")%>">
<img border="0" src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="71">

Which is sending a link to the other page like this:

http://70.154.145.58/customers/equipment_sale.asp?ProductID=DRG-05

Is this what I'm after?
My other page is displaying this:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers


:

<a href="equipment_sale.asp?productID=<% ProductID %>">
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69"></a>

That's how your markup should look - is that correct?


--
Murray
--------------
MVP FrontPage


...Or is this what you'r elooking for?

SELECT * FROM Eq_Sale ORDER BY ProductID ASC

It may be where I'm placing the tag that's given me the error.

<a href="equipment_sale.asp?productID=<% ProductID %>
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69">

:

Hmm - how have you defined the field "ProductID" in the database?

--
Murray
--------------
MVP FrontPage


Thanks, Please stay with me. I'm trying to get it to work. This it
what
I
have

<a href="equipment_sale.asp?ProductID=<% ProductID %>"

This is what I get:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'ProductID'
/customers/equipment_sale3.asp, line 45


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; SV1;
.NET
CLR
1.1.4322; .NET CLR 2.0.50727)

Page:
GET /customers/equipment_sale3.asp


:

The thumb image would have to link to the product page like this -

<a href="products.asp?product=<% yourproductIDfield %>"...

and the products page would have to read that ProductID from the
url
(with
request.querystring('productID') - or whatever the variable name
is),
and
then use that value to filter the recordset in the SELECT
statement.

Does that make sense?

--
Murray
--------------
MVP FrontPage


I've set up a page to display items for sale and a linked image
through
our
access database.
http://70.154.145.58/customers/equipment_sale.asp
Everything
works like I want. After looking at it I figured it would be
better
to
have a
list with a thumbnail something like this
http://70.154.145.58/customers/equipment_sale_a.asp. My problem
is I
can't
figure out how to pass the ProductID, when selected, to the page
to
show
the
details. Is this possible? I've tried everything I could think
of.

 

[J Rhymes]

Thanks Thomas. I assume that the top part goes in the hyperlink and should
look like this:

equipment_sale.asp?ProductID=<%ProductID = Request.QueryString("ProductID")%>

Am I correct? Or am I missing everything? I've tried it in the query in the
results page and it give me an error.

<%
ProductID = Request.QueryString("ProductID")
%>

SELECT * FROM Eq_Sale WHERE ProductID = '" & ProductID & "'

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

DRG-05
I tried typing it in the address bar manually but it gave me the same
results.
This is my query on the other end:

SELECT * FROM Eq_Sale WHERE (Request.Querystring = ':roductID::')

ProductID=DRG%2D05
-----------------------^^^^^

What is that character (the one between "G" and "05"?

--
Murray
--------------
MVP FrontPage


I think I'm getting closer with this

<a
href="equipment_sale.asp?ProductID=<%=FP_FieldURL(fp_rs,"ProductID")%>">
<img border="0" src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="71">

Which is sending a link to the other page like this:

http://70.154.145.58/customers/equipment_sale.asp?ProductID=DRG-05

Is this what I'm after?
My other page is displaying this:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers


:

<a href="equipment_sale.asp?productID=<% ProductID %>">
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69"></a>

That's how your markup should look - is that correct?


--
Murray
--------------
MVP FrontPage


...Or is this what you'r elooking for?

SELECT * FROM Eq_Sale ORDER BY ProductID ASC

It may be where I'm placing the tag that's given me the error.

<a href="equipment_sale.asp?productID=<% ProductID %>
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69">

:

Hmm - how have you defined the field "ProductID" in the database?

--
Murray
--------------
MVP FrontPage


Thanks, Please stay with me. I'm trying to get it to work. This it
what
I
have

<a href="equipment_sale.asp?ProductID=<% ProductID %>"

This is what I get:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'ProductID'
/customers/equipment_sale3.asp, line 45


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; SV1;
.NET
CLR
1.1.4322; .NET CLR 2.0.50727)

Page:
GET /customers/equipment_sale3.asp


:

The thumb image would have to link to the product page like this -

<a href="products.asp?product=<% yourproductIDfield %>"...

and the products page would have to read that ProductID from the
url
(with
request.querystring('productID') - or whatever the variable name
is),
and
then use that value to filter the recordset in the SELECT
statement.

Does that make sense?

--
Murray
--------------
MVP FrontPage


I've set up a page to display items for sale and a linked image
through
our
access database.
http://70.154.145.58/customers/equipment_sale.asp
Everything
works like I want. After looking at it I figured it would be
better
to
have a
list with a thumbnail something like this
http://70.154.145.58/customers/equipment_sale_a.asp. My problem
is I
can't
figure out how to pass the ProductID, when selected, to the page
to
show
the
details. Is this possible? I've tried everything I could think
of.

 

[Thomas A. Rowe]

No...

Your link should look like:

equipment_sale.asp?ProductID=<%=RecordSetName("ProductID")%>

then on equipment_sale.asp

you add the following:

<%
ProductID = Request.QueryString("ProductID")
%>
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

Thanks Thomas. I assume that the top part goes in the hyperlink and should
look like this:

equipment_sale.asp?ProductID=<%ProductID = Request.QueryString("ProductID")%>

Am I correct? Or am I missing everything? I've tried it in the query in the
results page and it give me an error.

<%
ProductID = Request.QueryString("ProductID")
%>

SELECT * FROM Eq_Sale WHERE ProductID = '" & ProductID & "'

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

DRG-05
I tried typing it in the address bar manually but it gave me the same
results.
This is my query on the other end:

SELECT * FROM Eq_Sale WHERE (Request.Querystring = ':roductID::')

:

ProductID=DRG%2D05
-----------------------^^^^^

What is that character (the one between "G" and "05"?

--
Murray
--------------
MVP FrontPage


I think I'm getting closer with this

<a
href="equipment_sale.asp?ProductID=<%=FP_FieldURL(fp_rs,"ProductID")%>">
<img border="0" src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="71">

Which is sending a link to the other page like this:

http://70.154.145.58/customers/equipment_sale.asp?ProductID=DRG-05

Is this what I'm after?
My other page is displaying this:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers


:

<a href="equipment_sale.asp?productID=<% ProductID %>">
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69"></a>

That's how your markup should look - is that correct?


--
Murray
--------------
MVP FrontPage


...Or is this what you'r elooking for?

SELECT * FROM Eq_Sale ORDER BY ProductID ASC

It may be where I'm placing the tag that's given me the error.

<a href="equipment_sale.asp?productID=<% ProductID %>
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69">

:

Hmm - how have you defined the field "ProductID" in the database?

--
Murray
--------------
MVP FrontPage


Thanks, Please stay with me. I'm trying to get it to work. This it
what
I
have

<a href="equipment_sale.asp?ProductID=<% ProductID %>"

This is what I get:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'ProductID'
/customers/equipment_sale3.asp, line 45


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; SV1;
.NET
CLR
1.1.4322; .NET CLR 2.0.50727)

Page:
GET /customers/equipment_sale3.asp


:

The thumb image would have to link to the product page like this -

<a href="products.asp?product=<% yourproductIDfield %>"...

and the products page would have to read that ProductID from the
url
(with
request.querystring('productID') - or whatever the variable name
is),
and
then use that value to filter the recordset in the SELECT
statement.

Does that make sense?

--
Murray
--------------
MVP FrontPage


I've set up a page to display items for sale and a linked image
through
our
access database.
http://70.154.145.58/customers/equipment_sale.asp
Everything
works like I want. After looking at it I figured it would be
better
to
have a
list with a thumbnail something like this
http://70.154.145.58/customers/equipment_sale_a.asp. My problem
is I
can't
figure out how to pass the ProductID, when selected, to the page
to
show
the
details. Is this possible? I've tried everything I could think
of.

 

[J Rhymes]

I’m sorry I’m a total idiot. Where on the equipment_sale.asp page do I need
to add that? It won’t accept it under the database custom query. Also
RecordSetName gets bumped as a Type Mismatch. Do I need to substitute it with
something?

No...

Your link should look like:

equipment_sale.asp?ProductID=<%=RecordSetName("ProductID")%>

then on equipment_sale.asp

you add the following:

<%
ProductID = Request.QueryString("ProductID")
%>
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

Thanks Thomas. I assume that the top part goes in the hyperlink and should
look like this:

equipment_sale.asp?ProductID=<%ProductID = Request.QueryString("ProductID")%>

Am I correct? Or am I missing everything? I've tried it in the query in the
results page and it give me an error.

<%
ProductID = Request.QueryString("ProductID")
%>

SELECT * FROM Eq_Sale WHERE ProductID = '" & ProductID & "'

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


DRG-05
I tried typing it in the address bar manually but it gave me the same
results.
This is my query on the other end:

SELECT * FROM Eq_Sale WHERE (Request.Querystring = ':roductID::')

:

ProductID=DRG%2D05
-----------------------^^^^^

What is that character (the one between "G" and "05"?

--
Murray
--------------
MVP FrontPage


I think I'm getting closer with this

<a
href="equipment_sale.asp?ProductID=<%=FP_FieldURL(fp_rs,"ProductID")%>">
<img border="0" src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="71">

Which is sending a link to the other page like this:

http://70.154.145.58/customers/equipment_sale.asp?ProductID=DRG-05

Is this what I'm after?
My other page is displaying this:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers


:

<a href="equipment_sale.asp?productID=<% ProductID %>">
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69"></a>

That's how your markup should look - is that correct?


--
Murray
--------------
MVP FrontPage


...Or is this what you'r elooking for?

SELECT * FROM Eq_Sale ORDER BY ProductID ASC

It may be where I'm placing the tag that's given me the error.

<a href="equipment_sale.asp?productID=<% ProductID %>
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69">

:

Hmm - how have you defined the field "ProductID" in the database?

--
Murray
--------------
MVP FrontPage


Thanks, Please stay with me. I'm trying to get it to work. This it
what
I
have

<a href="equipment_sale.asp?ProductID=<% ProductID %>"

This is what I get:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'ProductID'
/customers/equipment_sale3.asp, line 45


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; SV1;
.NET
CLR
1.1.4322; .NET CLR 2.0.50727)

Page:
GET /customers/equipment_sale3.asp


:

The thumb image would have to link to the product page like this -

<a href="products.asp?product=<% yourproductIDfield %>"...

and the products page would have to read that ProductID from the
url
(with
request.querystring('productID') - or whatever the variable name
is),
and
then use that value to filter the recordset in the SELECT
statement.

Does that make sense?

--
Murray
--------------
MVP FrontPage


I've set up a page to display items for sale and a linked image
through
our
access database.
http://70.154.145.58/customers/equipment_sale.asp
Everything
works like I want. After looking at it I figured it would be
better
to
have a
list with a thumbnail something like this
http://70.154.145.58/customers/equipment_sale_a.asp. My problem
is I
can't
figure out how to pass the ProductID, when selected, to the page
to
show
the
details. Is this possible? I've tried everything I could think
of.

 

[Thomas A. Rowe]

You would add that at the top of the page before the current ASP code. The recordsetname you would
replace with the name of the recordset you are currently using.

Since you are using the FP database component, you will have to wait for someone else to help you
this, as I only do handcoded ASP/VBScript.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

I'm sorry I'm a total idiot. Where on the equipment_sale.asp page do I need
to add that? It won't accept it under the database custom query. Also
RecordSetName gets bumped as a Type Mismatch. Do I need to substitute it with
something?

No...

Your link should look like:

equipment_sale.asp?ProductID=<%=RecordSetName("ProductID")%>

then on equipment_sale.asp

you add the following:

<%
ProductID = Request.QueryString("ProductID")
%>
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

Thanks Thomas. I assume that the top part goes in the hyperlink and should
look like this:

equipment_sale.asp?ProductID=<%ProductID = Request.QueryString("ProductID")%>

Am I correct? Or am I missing everything? I've tried it in the query in the
results page and it give me an error.

:

<%
ProductID = Request.QueryString("ProductID")
%>

SELECT * FROM Eq_Sale WHERE ProductID = '" & ProductID & "'

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


DRG-05
I tried typing it in the address bar manually but it gave me the same
results.
This is my query on the other end:

SELECT * FROM Eq_Sale WHERE (Request.Querystring = ':roductID::')

:

ProductID=DRG%2D05
-----------------------^^^^^

What is that character (the one between "G" and "05"?

--
Murray
--------------
MVP FrontPage


I think I'm getting closer with this

<a
href="equipment_sale.asp?ProductID=<%=FP_FieldURL(fp_rs,"ProductID")%>">
<img border="0" src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="71">

Which is sending a link to the other page like this:

http://70.154.145.58/customers/equipment_sale.asp?ProductID=DRG-05

Is this what I'm after?
My other page is displaying this:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers


:

<a href="equipment_sale.asp?productID=<% ProductID %>">
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69"></a>

That's how your markup should look - is that correct?


--
Murray
--------------
MVP FrontPage


...Or is this what you'r elooking for?

SELECT * FROM Eq_Sale ORDER BY ProductID ASC

It may be where I'm placing the tag that's given me the error.

<a href="equipment_sale.asp?productID=<% ProductID %>
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69">

:

Hmm - how have you defined the field "ProductID" in the database?

--
Murray
--------------
MVP FrontPage


Thanks, Please stay with me. I'm trying to get it to work. This it
what
I
have

<a href="equipment_sale.asp?ProductID=<% ProductID %>"

This is what I get:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'ProductID'
/customers/equipment_sale3.asp, line 45


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; SV1;
.NET
CLR
1.1.4322; .NET CLR 2.0.50727)

Page:
GET /customers/equipment_sale3.asp


:

The thumb image would have to link to the product page like this -

<a href="products.asp?product=<% yourproductIDfield %>"...

and the products page would have to read that ProductID from the
url
(with
request.querystring('productID') - or whatever the variable name
is),
and
then use that value to filter the recordset in the SELECT
statement.

Does that make sense?

--
Murray
--------------
MVP FrontPage


I've set up a page to display items for sale and a linked image
through
our
access database.
http://70.154.145.58/customers/equipment_sale.asp
Everything
works like I want. After looking at it I figured it would be
better
to
have a
list with a thumbnail something like this
http://70.154.145.58/customers/equipment_sale_a.asp. My problem
is I
can't
figure out how to pass the ProductID, when selected, to the page
to
show
the
details. Is this possible? I've tried everything I could think
of.

 

[Stefan B Rusynko]

In valid syntax
<a href="equipment_sale.asp?ProductID=<% ProductID %>"
should be
<a href="equipment_sale.asp?ProductID=<%=ProductID %>"

That presumes somewhere above in the page the Variable is ProductID is getting a value from your DB
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Thanks, Please stay with me. I’m trying to get it to work. This it what I have
|
| <a href="equipment_sale.asp?ProductID=<% ProductID %>"
|
| This is what I get:
|
| Error Type:
| Microsoft VBScript runtime (0x800A000D)
| Type mismatch: 'ProductID'
| /customers/equipment_sale3.asp, line 45
|
|
| Browser Type:
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; SV1; .NET CLR
| 1.1.4322; .NET CLR 2.0.50727)
|
| Page:
| GET /customers/equipment_sale3.asp
|
|
| "Murray" wrote:
|
| > The thumb image would have to link to the product page like this -
| >
| > <a href="products.asp?product=<% yourproductIDfield %>"...
| >
| > and the products page would have to read that ProductID from the url (with
| > request.querystring('productID') - or whatever the variable name is), and
| > then use that value to filter the recordset in the SELECT statement.
| >
| > Does that make sense?
| >
| > --
| > Murray
| > --------------
| > MVP FrontPage
| >
| >
| > | > > I've set up a page to display items for sale and a linked image through
| > > our
| > > access database. http://70.154.145.58/customers/equipment_sale.asp
| > > Everything
| > > works like I want. After looking at it I figured it would be better to
| > > have a
| > > list with a thumbnail something like this
| > > http://70.154.145.58/customers/equipment_sale_a.asp. My problem is I can't
| > > figure out how to pass the ProductID, when selected, to the page to show
| > > the
| > > details. Is this possible? I've tried everything I could think of.
| >
| >
| >

 

[J Rhymes]

Thanks all for the help. I ended up rebuilding the results page and change
some code here and there using the samples ya'll supplied and I finally got
it working. This is going to work out great! I still have some cleaning up to
do and some navigation to put in but here is the page
http://70.154.145.58/customers/equipment_sale_a.asp Thanks again for the
help.

You would add that at the top of the page before the current ASP code. The recordsetname you would
replace with the name of the recordset you are currently using.

Since you are using the FP database component, you will have to wait for someone else to help you
this, as I only do handcoded ASP/VBScript.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

I'm sorry I'm a total idiot. Where on the equipment_sale.asp page do I need
to add that? It won't accept it under the database custom query. Also
RecordSetName gets bumped as a Type Mismatch. Do I need to substitute it with
something?

No...

Your link should look like:

equipment_sale.asp?ProductID=<%=RecordSetName("ProductID")%>

then on equipment_sale.asp

you add the following:

<%
ProductID = Request.QueryString("ProductID")
%>
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


Thanks Thomas. I assume that the top part goes in the hyperlink and should
look like this:

equipment_sale.asp?ProductID=<%ProductID = Request.QueryString("ProductID")%>

Am I correct? Or am I missing everything? I've tried it in the query in the
results page and it give me an error.

:

<%
ProductID = Request.QueryString("ProductID")
%>

SELECT * FROM Eq_Sale WHERE ProductID = '" & ProductID & "'

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


DRG-05
I tried typing it in the address bar manually but it gave me the same
results.
This is my query on the other end:

SELECT * FROM Eq_Sale WHERE (Request.Querystring = ':roductID::')

:

ProductID=DRG%2D05
-----------------------^^^^^

What is that character (the one between "G" and "05"?

--
Murray
--------------
MVP FrontPage


I think I'm getting closer with this

<a
href="equipment_sale.asp?ProductID=<%=FP_FieldURL(fp_rs,"ProductID")%>">
<img border="0" src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="71">

Which is sending a link to the other page like this:

http://70.154.145.58/customers/equipment_sale.asp?ProductID=DRG-05

Is this what I'm after?
My other page is displaying this:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers


:

<a href="equipment_sale.asp?productID=<% ProductID %>">
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69"></a>

That's how your markup should look - is that correct?


--
Murray
--------------
MVP FrontPage


...Or is this what you'r elooking for?

SELECT * FROM Eq_Sale ORDER BY ProductID ASC

It may be where I'm placing the tag that's given me the error.

<a href="equipment_sale.asp?productID=<% ProductID %>
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69">

:

Hmm - how have you defined the field "ProductID" in the database?

--
Murray
--------------
MVP FrontPage


Thanks, Please stay with me. I'm trying to get it to work. This it
what
I
have

<a href="equipment_sale.asp?ProductID=<% ProductID %>"

This is what I get:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'ProductID'
/customers/equipment_sale3.asp, line 45


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; SV1;
.NET
CLR
1.1.4322; .NET CLR 2.0.50727)

Page:
GET /customers/equipment_sale3.asp


:

The thumb image would have to link to the product page like this -

<a href="products.asp?product=<% yourproductIDfield %>"...

and the products page would have to read that ProductID from the
url
(with
request.querystring('productID') - or whatever the variable name
is),
and
then use that value to filter the recordset in the SELECT
statement.

Does that make sense?

--
Murray
--------------
MVP FrontPage


I've set up a page to display items for sale and a linked image
through
our
access database.
http://70.154.145.58/customers/equipment_sale.asp
Everything
works like I want. After looking at it I figured it would be
better
to
have a
list with a thumbnail something like this
http://70.154.145.58/customers/equipment_sale_a.asp. My problem
is I
can't
figure out how to pass the ProductID, when selected, to the page
to
show
the
details. Is this possible? I've tried everything I could think
of.

 

[Thomas A. Rowe]

You are welcome and glad to see that you have it working.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

Thanks all for the help. I ended up rebuilding the results page and change
some code here and there using the samples ya'll supplied and I finally got
it working. This is going to work out great! I still have some cleaning up to
do and some navigation to put in but here is the page
http://70.154.145.58/customers/equipment_sale_a.asp Thanks again for the
help.

You would add that at the top of the page before the current ASP code. The recordsetname you
would
replace with the name of the recordset you are currently using.

Since you are using the FP database component, you will have to wait for someone else to help you
this, as I only do handcoded ASP/VBScript.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================

I'm sorry I'm a total idiot. Where on the equipment_sale.asp page do I need
to add that? It won't accept it under the database custom query. Also
RecordSetName gets bumped as a Type Mismatch. Do I need to substitute it with
something?

:

No...

Your link should look like:

equipment_sale.asp?ProductID=<%=RecordSetName("ProductID")%>

then on equipment_sale.asp

you add the following:

<%
ProductID = Request.QueryString("ProductID")
%>
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


Thanks Thomas. I assume that the top part goes in the hyperlink and should
look like this:

equipment_sale.asp?ProductID=<%ProductID = Request.QueryString("ProductID")%>

Am I correct? Or am I missing everything? I've tried it in the query in the
results page and it give me an error.

:

<%
ProductID = Request.QueryString("ProductID")
%>

SELECT * FROM Eq_Sale WHERE ProductID = '" & ProductID & "'

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


DRG-05
I tried typing it in the address bar manually but it gave me the same
results.
This is my query on the other end:

SELECT * FROM Eq_Sale WHERE (Request.Querystring = ':roductID::')

:

ProductID=DRG%2D05
-----------------------^^^^^

What is that character (the one between "G" and "05"?

--
Murray
--------------
MVP FrontPage


I think I'm getting closer with this

<a
href="equipment_sale.asp?ProductID=<%=FP_FieldURL(fp_rs,"ProductID")%>">
<img border="0" src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="71">

Which is sending a link to the other page like this:

http://70.154.145.58/customers/equipment_sale.asp?ProductID=DRG-05

Is this what I'm after?
My other page is displaying this:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers


:

<a href="equipment_sale.asp?productID=<% ProductID %>">
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69"></a>

That's how your markup should look - is that correct?


--
Murray
--------------
MVP FrontPage


...Or is this what you'r elooking for?

SELECT * FROM Eq_Sale ORDER BY ProductID ASC

It may be where I'm placing the tag that's given me the error.

<a href="equipment_sale.asp?productID=<% ProductID %>
<img border="0"
src="web_pics/<%=FP_FieldLink(fp_rs,"Image1")%>.JPG"
width="95" height="69">

:

Hmm - how have you defined the field "ProductID" in the database?

--
Murray
--------------
MVP FrontPage


Thanks, Please stay with me. I'm trying to get it to work. This it
what
I
have

<a href="equipment_sale.asp?ProductID=<% ProductID %>"

This is what I get:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'ProductID'
/customers/equipment_sale3.asp, line 45


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; SV1;
.NET
CLR
1.1.4322; .NET CLR 2.0.50727)

Page:
GET /customers/equipment_sale3.asp


:

The thumb image would have to link to the product page like this -

<a href="products.asp?product=<% yourproductIDfield %>"...

and the products page would have to read that ProductID from the
url
(with
request.querystring('productID') - or whatever the variable name
is),
and
then use that value to filter the recordset in the SELECT
statement.

Does that make sense?

--
Murray
--------------
MVP FrontPage


I've set up a page to display items for sale and a linked image
through
our
access database.
http://70.154.145.58/customers/equipment_sale.asp
Everything
works like I want. After looking at it I figured it would be
better
to
have a
list with a thumbnail something like this
http://70.154.145.58/customers/equipment_sale_a.asp. My problem
is I
can't
figure out how to pass the ProductID, when selected, to the page
to
show
the
details. Is this possible? I've tried everything I could think
of.