Connect submit button to recordset value

Results 1 to 3 of 3

Thread: Connect submit button to recordset value

  1. #1
    Join Date
    Dec 1969

    Default Connect submit button to recordset value

    I have a simple .asp page that displays the data from an Access db (product, manufacturer, link&#039;d image ect). I also have a &#039;RentMe&#039; button that I want a user to be able to press and have it populate another page with the value of the resultant product value (gathered by &#060;%=rsGlobalWeb("Product")%&#062; )<BR><BR>How can this be achieved? Cookies, Arrays? I&#039;m a newbie so go easy. Thanks

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Pass the value to the next page

    as a querystring<BR><BR><BR>you will then get that value using Request.Querystring("ParameterName") then display it<BR><BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default Place rs value in a form field...

    &#060;input name="ProductCode" type="hidden" value="&#060;%=rsGlobalWeb("Product")%&#062;"&#062 ;<BR><BR>And then in the action page from the form definition...You would use in a SQL statement like...<BR><BR>strSql = "SELECT Field1, Field2, FieldN FROM SomeTable "<BR><BR>If your id is numeric use this...<BR><BR>strSql = strSql & "WHERE ProductId = " & Trim(Request.Form("ProductCode"))<BR><BR>If your id is character use this...<BR><BR>strSql = strSql & "WHERE ProductId = " & "&#039;" & Trim(Request.Form("ProductCode")) & "&#039;"<BR><BR>KLC<BR><BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts