Updating or deleting records in a database

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Updating or deleting records in a database

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Updating or deleting records in a database

Page: [1]

hme1

Posts: 4
From: Martinez, CA. USA
Status: offline

Updating or deleting records in a database - 3/24/2001 20:51:00

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::


Spooky Posts: 26603 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Updating or deleting records in a database - 3/25/2001 20:28:00 Youll need to store "AccessNumber" in a hidden field, so that it knows what record to update . "PhoneNumberl" is a typo? Should be PhoneNumber I think? ------------------ Spooky "I am Spooky of Borg. Prepare to be assimilated, babycakes!" Subscribe to OutFront News Database / DRW Q & A The Spooky Login! (in reply to hme1)


adamhum Posts: 28 From: Tucson, Az, USA Status: offline	RE: Updating or deleting records in a database - 3/25/2001 20:32:00 Spooky, do you mean Accountnumber or Accessnumber? (in reply to hme1)


Spooky Posts: 26603 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Updating or deleting records in a database - 3/25/2001 16:52:00 Sorry, yes (in reply to hme1)