Image Page using a Database

J

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.
 
M

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

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
 
J

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">
 
M

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

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
 
M

Murray

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

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

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


J Rhymes said:
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 said:
<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

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 = '::productID::')

Murray said:
ProductID=DRG%2D05
-----------------------^^^^^

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

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


J Rhymes said:
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 said:
<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.
 
T

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
==============================================


J Rhymes said:
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 = '::productID::')

Murray said:
ProductID=DRG%2D05
-----------------------^^^^^

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

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


J Rhymes said:
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

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.

Thomas A. Rowe said:
<%
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
==============================================


J Rhymes said:
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 = '::productID::')

Murray said:
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.
 
T

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
==============================================


J Rhymes said:
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.

Thomas A. Rowe said:
<%
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
==============================================


J Rhymes said:
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 = '::productID::')

:

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

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?

Thomas A. Rowe said:
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
==============================================


J Rhymes said:
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.

Thomas A. Rowe said:
<%
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 = '::productID::')

:

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.
 
T

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
==============================================


J Rhymes said:
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?

Thomas A. Rowe said:
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
==============================================


J Rhymes said:
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 = '::productID::')

:

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.
 
S

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

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.

Thomas A. Rowe said:
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
==============================================


J Rhymes said:
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?

Thomas A. Rowe said:
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 = '::productID::')

:

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.
 
T

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
==============================================


J Rhymes said:
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.

Thomas A. Rowe said:
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
==============================================


J Rhymes said:
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 = '::productID::')

:

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top