We have migrated to a new platform! Please note that you will need to reset your password to log in (your credentials are still in-tact though). Please contact email@example.com if you have questions.
Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
forum, I need some help and advice on the last part of a project I am concluding. I am working with updating a database using forms and coldfusion. The way I have things set up, the form will pass selected items from a form element such as a menu, and uses that selected value in SQL to change the database.
Now for one of the records I would like to delete, I will need two variables passed from the form to use within my SQL in my action page. My problem comes that the values I am sending are dynamic and the form element only allows for one value(variable) to be passed. I've been trying to create a variable within my form so that I can pass it along to my action page, but I get an error saying the variable is undefined in my form.
The syntax I've been using includes both to create the variable, and is reassign the variable in the form. Turns out, that either the variable is not being reassigned, or it is not being transfered to the action page.
Heres example code =================================
. . .
================================ my action page that calls the created 'variable' : ================================ . . .
SOFTWARE ON COMPUTER NOT REMOVED !!
DELETE FROM COMPUTERSSOFTWARE WHERE COMPUTERID = #Form.selectComputerSoftware# AND SOFTWAREID = #Form.variable#
. . . ================================
....my thought to pass a created variable is not working. I really need some help with this, if possible. My online searching is not successful and I am coming close to an end. I, somehow, need to give my action page two variables. I even attempted to use a , but apparently, I cannot have this inside cfoutput tags.