Update Statement is Using defaults instead of Data

	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

Update Statement is Using defaults instead of Data

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 >> Update Statement is Using defaults instead of Data

Page: [1]

DKN

Posts: 35
From: Olathe, Kansas, USA
Status: offline

Update Statement is Using defaults instead of Data - 10/24/2001 16:43:00

I have one page that displays the data in text boxes and post to my edit page that has the DRW with the update SQL. When I submit the changes, the DRW uses all my default values instead of the text box values.
I am using Access 2000 for the db.
I have used the DRW before many times to update records and never run into this before.

Any Ideas why this would occur? I thought it possibly might be the number of fields. I have probably 50 or so.

Thanks


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Update Statement is Using defaults instead of Data - 10/24/2001 20:50:00 The text box names are exactly the same as the DRW input expects? ------------------ ��k� "I am Spooky of Borg. Prepare to be assimilated, babycakes!" Subscribe to OutFront News Database / DRW Q & A The Spooky Login! VP-ASP Shopping cart (in reply to DKN)


DKN Posts: 35 From: Olathe, Kansas, USA Status: offline	RE: Update Statement is Using defaults instead of Data - 10/24/2001 21:16:00 Yes, the are identical. I have check several times. (in reply to DKN)


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Update Statement is Using defaults instead of Data - 10/25/2001 20:22:00 What is the exact update SQL string you are using? ------------------ ��k� "I am Spooky of Borg. Prepare to be assimilated, babycakes!" Subscribe to OutFront News Database / DRW Q & A The Spooky Login! VP-ASP Shopping cart (in reply to DKN)

DKN

Posts: 35
From: Olathe, Kansas, USA
Status: offline

RE: Update Statement is Using defaults instead of Data - 10/25/2001 20:33:00

its somthing like:

update Table1
set
First='::First::',
Last='::Last::',
Phone='::Phone::'
Where ID=::ID::

I have about 50 or so fields that I am trying to update at once. do you think this would cause this error?

(in reply to DKN)

DKN

Posts: 35
From: Olathe, Kansas, USA
Status: offline

RE: Update Statement is Using defaults instead of Data - 10/25/2001 14:48:00

I have discovered my problem. Here is the answer for anyone with a similar problem.

The names of my text boxes had been concatenated with a 1 so when they were submitted to the DB it was not recognizing them and using the defaults.

Thanks for the help Spooky, always appreciated.

(in reply to DKN)

KeithG

Posts: 92
From: Irving TX Irving, Texas, USA
Status: offline

RE: Update Statement is Using defaults instead of Data - 10/25/2001 23:42:00

DKN

I have had that problem in the past, It happens when you are working on a form and copy and paste a form field and FP does not like the same name on multiple fields so it adds a 1 up number to each copy. Very distracting isnt it?

Keith

(in reply to DKN)

DKN

Posts: 35
From: Olathe, Kansas, USA
Status: offline

RE: Update Statement is Using defaults instead of Data - 10/26/2001 20:29:00

Thats exactly what happend. Where were you a few days back when I was pulling my hair out.

Thanks

DKN

(in reply to DKN)


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Update Statement is Using defaults instead of Data - 10/26/2001 15:31:00 "Yes, the are identical. I have check several times" (in reply to DKN)