I have an area on my web site where people can update their “customer profile.” (At least that is what I’m trying to accomplish) First they pull their information up from a drw by account number. http://www.greenhouseservice.com/e-service/existing_customers.asp Use account#00001 to bring up a default record. After clicking on their name, they are taken to the form to edit their record. (Their existing information is pulled over to the edit form in query string) When the updated information is submitted to the update drw, I’m getting an error.
The drw I am pulling from is called Customers. I am using a custom SQL code. Whenever I choose custom SQL, no form fields come up. Is this right? What am I doing wrong? Any help that can be offered would be much appreciated. I have pasted the SQL code below.
UPDATE Customers
SET Name='::Name::', Address='::Address::', City='::City::',
ZipCode=::ZipCode::, PhoneNumber=::PhoneNumberl::,
EMail= '::EMail::'
WHERE AccountNumber= ::AccountNumber::
![]("http://www.frontpagewebmaster.com/ubb/smile.gif")
