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 <

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 no

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
>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. > >http://www.happyhacker.com/WebDev.cfm?Cat=CF&SubCat=Ord

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 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 unique DB i

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. http://www.happyhacker.com/WebDev.cfm?Cat=CF&SubCat=Ordering#

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 di

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 displaye

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

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 and the same for movedown . And it works my question is how can i update the database ~| ColdFusion 8 - Build next generation

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 so

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