DW8 Update Records in ASP

[marketingyard]

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.

[marketingyard]

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!

[MikeL7]

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

[marketingyard]

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.

[MikeL7]

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.

[Newsgroup_User]

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.

[marketingyard]

Hi Paul,

I've emailed you the code.

Thanks in Advance,

Peter.