Update record on page load

[johngordon12]

This is probably something that's a lot simpler than I realise.

Basically, I have a site with an online store, that transfers customers to a remote payment gateway, and returns them to the main site once an order has been processed.

So on my success landing page, I want to update the order_status field from 'pending' to 'approved'.

But when I go to add an update record behaviour to the page, dreamweaver wants me to create a form. So whilst I've done that in the past, ie have a form where users can update records, and hit submit to trigger the changes, how can I simply get a record to update upon a page loading?

Hope that makes sense.

Cheers.

[Newsgroup_User]

Under Server Behaviours, select Commands and choose "update" from the Type
menu.
It's a little bit more involved than the update behaviour, but will do the
job very nicely.


"Iain71" <webforumsuser@macromedia.com> wrote in message
news:eqd32t$g8f$1@forums.macromedia.com...
> This is probably something that's a lot simpler than I realise.
>
> Basically, I have a site with an online store, that transfers customers to
> a
> remote payment gateway, and returns them to the main site once an order
> has
> been processed.
>
> So on my success landing page, I want to update the order_status field
> from
> 'pending' to 'approved'.
>
> But when I go to add an update record behaviour to the page, dreamweaver
> wants
> me to create a form. So whilst I've done that in the past, ie have a form
> where
> users can update records, and hit submit to trigger the changes, how can I
> simply get a record to update upon a page loading?
>
> Hope that makes sense.
>
> Cheers.
>

[johngordon12]

Where is that?

I'm looking in the server behaviours tab of Application Panel - and have the options : recordset, repeat region, insert record, update record etc - but don't see Commands.

Looked under the Commands menu at the top, but no sign of anything in there.

[Newsgroup_User]

Also available under the Bindings Tab.
See screen shots at: www.scstechsolutions.co.uk/command.gif
The interface image is after the 8.02 update so if you haven't installed
that then this will look different.

I'm using ASP, not sure if this interface is available under other server
environments.

Justin

"Iain71" <webforumsuser@macromedia.com> wrote in message
news:eqd5n4$jeu$1@forums.macromedia.com...
> Where is that?
>
> I'm looking in the server behaviours tab of Application Panel - and have
> the
> options : recordset, repeat region, insert record, update record etc - but
> don't see Commands.
>
> Looked under the Commands menu at the top, but no sign of anything in
> there.
>

[johngordon12]

I've actually just MX04. Had a rummage in the help, and discovered that it's only an ASP thing.

This must be possible tho'... surely... anybody?