Forums

This topic is locked

Multiple Deletes and updates from the same table?

Posted 28 Jul 2001 19:52:07
1
has voted
28 Jul 2001 19:52:07 I Mahomed posted:
how do you delete/update multiple records in the same table ?

from 1 form ?


Replies

Replied 28 Jul 2001 21:03:15
28 Jul 2001 21:03:15 I Mahomed replied:
Ok figured out how to do this 1,
ill write a tutorial later but heres how if ane1 needs to know

ADD a normall Update or Delete behaviour in your form. UD4 then adds a hidden value which requests from your unique key.
change this value to a variable which is set to the critiria u want matched to be deleted
1 other thing once you do this a RED exclamation mark will apear in your server behaviors, thats fine it will still work just dont open the behaviour or ud4 will set it back.


<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> dunno if this makes sense <img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>

laters
disorder


Replied 29 Jul 2001 03:39:47
29 Jul 2001 03:39:47 Dennis van Galen replied:
i am curious, how do you determine the value in the hidden field ?
I use that trick to update different fields in a record, so i was wondering what you use this for and how does it work if it is to effect multiple records, is there a page before this one where the user determines that value through a form or link ?


With kind regards,

Dennis van Galen
Webmaster SPG Finance
KPN Telecom Holland NV
Replied 29 Jul 2001 05:42:15
29 Jul 2001 05:42:15 I Mahomed replied:
well yes, there is a page before that inserting the into another table then sticking a request.form into url param. which passes it to the hidden value in the form <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

if ane1 got a better way of doing this lemme know <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>


Reply to this topic