This seems to have brought me a step closer. The window opens, but I receive the following error:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/SpamAvenger013009/Contact.asp, line 11
In the window in which the error is displayed...
Turns out there was a problem with the SQL... a data type mismatch on Report.asp.
SQL = "SELECT * FROM tblDesc WHERE fkeyIDProduct = '" & prodID & "'"
I removed the single quotes since the value being passed is a number and it works perfectly!
Thank you so much for all your help!
One...
It is indeed
...Report.asp?id=string product Name
So the product id is being passed in the querystring.
I will try your suggestion on the Report.asp page and let you know how it goes. :-)
I am curious though; I have tested the SQL within the database to ensure the results and it works...
I must have written it backwards, because I changed it from strProduct to pkeyIDProduct and received the "mismatch in criteria expression error". It was originally strProduct, which then produced the "no records found" per the code you suggested.
So, I'm confused since I am passing the...
Your suggestion worked like a charm on both counts. The first page works perfectly and I indeed received "no records found" on the second page, which lead me to question the sql. Previously, on the second page, prodID was set to strProduct; however, that's not whats being passed in the...
Thanks for the wonderful help. I'm making progress, but getting a few errors. Thanks for being patient too! It's been a long time since I've done this and memory isn't what it use to be.
So, using the code suggested by g0ste I receive the following error:
Item cannot be found in the...
I appreciate the response, but I am still confused. The links are populated on the first page from the database:
<% If rs.Fields("strType") = 1 Then
Do While not rs.EOF
Response.Write ("<li><a href='#' name='product'")
Response.Write ("onClick='fncSelected()'")
Response.Write...
I have three basic pages that are populated with information from a database. The first page contains a list of links. When the user selects a link, a second page is opened and certain fields are populated with the product information specific to the link selected.
I have written all the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.