I need help, I am tring to pull records from a SQL database based on whatever lastname the client enters into the html page.
I went to the toolbox in interdev and droped RecordSet onto my page, then I went to the SQL bulder and created my SELECT statement:
SELECT FNAME,LNAME
FROM customers
now I only want to get the records that match a variable from Request.Form("Lastname"
with is called strLastname. I tried:
WHERE LNAME = strLastname
If I am doing this wrong, or you can help with this code, I thanks you in advance.
If I hardcode the last name, I get the record, but when I try to use the lastname from strlastname it does not work.
I went to the toolbox in interdev and droped RecordSet onto my page, then I went to the SQL bulder and created my SELECT statement:
SELECT FNAME,LNAME
FROM customers
now I only want to get the records that match a variable from Request.Form("Lastname"
with is called strLastname. I tried:WHERE LNAME = strLastname
If I am doing this wrong, or you can help with this code, I thanks you in advance.
If I hardcode the last name, I get the record, but when I try to use the lastname from strlastname it does not work.