DW8 Update Records in ASP

Forum|Forum|18 years ago
August 5, 2007
5 replies
368 views

Hi,

I've been having major problems updating records in a database using asp in dw8.

I've got the update page displaying with all relevant fields filled in but the thing dont update the database.

I've tried all the tutorials i could find from here, other web resources & about 5 books I have on it, but still no luck.

If anybody could help me out here, I would be most grateful.

Thanks in Advance,

Peter.

Server side applications

This topic has been closed for replies.

M

marketingyardAuthor

Participant

Hi Paul,

I've emailed you the code.

Thanks in Advance,

Peter.

N

Newsgroup_User

Inspiring

Can you post the code

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"marketingyard" <webforumsuser@macromedia.com> wrote in message
news:f95c8c$1cs$1@forums.macromedia.com...
> Hi Mike,
>
> I did use the Update Record Wizard, but I got no error messages.
>
> On Pressing the Update Button I was taken to the URL I defined after
> update, but the database didnt update.

M

marketingyardAuthor

Participant

Hi Mike,

I did use the Update Record Wizard, but I got no error messages.

On Pressing the Update Button I was taken to the URL I defined after update, but the database didnt update.

M

MikeL7

Inspiring

You should check the Server Behaviors panel and look for a red ! exclamation point, and if not check the name of the table updating is correct. You might try remaking the form if you can't find anything or try making a small 1 menu 1 txt field form that updates the same table, if that works look over the details again, post get table name ect.

M

MikeL7

Inspiring

Did you use the Update record wizard?
What error messages do you get?
Check your permissions, IUSR must be able to write to db
check your INSERT sql

M

marketingyardAuthor

Participant

Additional info:

My update form is using 14 fields, 4 of which are menu items with values from their respective recordsets, 3 are text areas & the rest are text fields.

all the current data from the index selected appears in their respective field ready to edit for update, but it dont update!

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.