Re: Update database by moving selection up and down

2007-10-05 Thread erik tom
I think he is asking how to get what is submitted into the database, not how to submit the form itself. I am guessing this is just a mult-select being submitted. What I have done in the past is when I submit the form I run a JS function that grabs the values(which are the PKs for what is

Re: Update database by moving selection up and down

2007-10-05 Thread Aaron Rouse
Here you go, someone apparently asked me a long time ago since the content of my site is probably a good 5 years old. Probably a better way to do this, but like I said I just keep reusing the same custom tag for it here since it works.

Re: Update database by moving selection up and down

2007-10-05 Thread Scott Weikert
erik tom wrote: Tell me how. I am calling the function like this input id=moveUP name=moveUp onclick=moveUp(-1) and the same for movedown . And it works my question is how can i update the database With your moveUp(-1) call, are you passing just a -1 or are you also passing whatever

Re: Update database by moving selection up and down

2007-10-05 Thread erik tom
Here you go, someone apparently asked me a long time ago since the content of my site is probably a good 5 years old. Probably a better way to do this, but like I said I just keep reusing the same custom tag for it here since it works.

Re: Update database by moving selection up and down

2007-10-05 Thread Aaron Rouse
Why do you have Form.requirements in your where clause? You would be looping over a LIST of unique IDs and referencing the loop's index in your where clause. Change the index name for the loop and reference that in the where clause then see what happens. On 10/5/07, erik tom [EMAIL PROTECTED]

Re: Update database by moving selection up and down

2007-10-05 Thread erik tom
Why do you have Form.requirements in your where clause? You would be looping over a LIST of unique IDs and referencing the loop's index in your where clause. Change the index name for the loop and reference that in the where clause then see what happens. Nothing is happening. Also I noticed

Re: Update database by moving selection up and down

2007-10-05 Thread Aaron Rouse
As I said that example is rather old, it looks like the second parameter should be the name of the field to save the values into. Could just delete it and hard code the name of the field to save to. I do not have my tag handy from work right now or I'd just send it to you. On 10/5/07, erik tom

Update database by moving selection up and down

2007-10-04 Thread erik tom
I have a drop down menu which does add remove functions from 1 drop down to another , and aslo have up and down arrows which do the respective movement. Now I need to find a way how to update the sort order in the database if I move the item up/down. The application is written IN CF. Here is my

Re: Update database by moving selection up and down

2007-10-04 Thread Brian Kotek
Submit the form or execute an AJAX request. On 10/4/07, erik tom [EMAIL PROTECTED] wrote: I have a drop down menu which does add remove functions from 1 drop down to another , and aslo have up and down arrows which do the respective movement. Now I need to find a way how to update the sort

Re: Update database by moving selection up and down

2007-10-04 Thread erik tom
Submit the form or execute an AJAX request. Tell me how. I am calling the function like this input id=moveUP name=moveUp onclick=moveUp(-1) and the same for movedown . And it works my question is how can i update the database

Re: Update database by moving selection up and down

2007-10-04 Thread Brian Kotek
I'm afraid you're not making sense. You want to know how to submit a form to the server? Use a submit button. Or a JavaScript function that submits the form ( http://www.javascript-coder.com/javascript-form/javascript-form-submit.phtml ). On 10/4/07, erik tom [EMAIL PROTECTED] wrote: Submit the

Re: Update database by moving selection up and down

2007-10-04 Thread Aaron Rouse
I think he is asking how to get what is submitted into the database, not how to submit the form itself. I am guessing this is just a mult-select being submitted. What I have done in the past is when I submit the form I run a JS function that grabs the values(which are the PKs for what is