Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005

    Unanswered: Query and textbox difficulty.

    Can anyone help please? On a login page i have constructed, u can login (if ur registered) by entering your surname and postcode. Once logged in i would like a welcome note to display the Customer_Name on the Customer homepage. If i use the following statement would it find the items in the specified text boxes and print the correct name? "Select Customer_Name from CUSTOMER WHERE Customer_Surname = the value in the text box AND Customer_PostCode = the value in the text box", Conn

    <%Response.write("Welcome" & rsCUSTOMER("Customer_Name")%>

    Any help would be much appreciated.
    Regards, John

  2. #2
    Join Date
    Feb 2005
    You should get the customer name based on your query, though you might want to make sure that the surname and postal code is a unique combination or you'll end up with more than 1 result

Posting Permissions

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