Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. symnow

    Pass Value of Clicked Link to a Second Page

    Life savers... both of you! Thanks so much for the help. All three pages are running smoothly. Have a great weekend and thanks again!
  2. symnow

    Pass Value of Clicked Link to a Second Page

    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...
  3. symnow

    Pass Value of Clicked Link to a Second Page

    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...
  4. symnow

    Pass Value of Clicked Link to a Second Page

    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...
  5. symnow

    Pass Value of Clicked Link to a Second Page

    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...
  6. symnow

    Pass Value of Clicked Link to a Second Page

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

    Pass Value of Clicked Link to a Second Page

    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...
  8. symnow

    Pass Value of Clicked Link to a Second Page

    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...
  9. symnow

    Pass Value of Clicked Link to a Second Page

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

Part and Inventory Search

Back
Top