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?


RsCUSTOMER.open "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

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