Updating in cold fusion
Updating in cold fusion - Hot adult girls chat wap
You can CFLOOP over that list of IDs to do your form variable evaluations for your update queries rather than guess at what values you should use to build the radio form element names you might have passed in. Post back here and tell us how you're doing and whether you need still more assistance.As a hint: you'll need to make use of this CF function to properly create the values you'll need to do the update SQL: Evaluate().
Anyway, in there you should see a number of variables that look like this: radio_1, radio_2, radio_4, radio_10 and so on and they'll have either "approve" or "decline" values.So, on your form page you now have a variable that holds a comma delimited list of you IDs from the q Item query.You can pass that to the action page in a hidden form field like so: tag you have on your form page. Now, on the action page, if you run the CFDUMP of the form scope again you'll see a variable there called IDs and the value for it will look something like this: 1,2,3,4,5,6,7,8,9,10.So I need SQL that will update the database based on the radio buttion chosen for the records. You'll also require the form's action page (place where you're sending the form information) that will contain the SQL query that does the update.Thanks Edit: Please use the code button when posting blocks of CF code This post has been edited by Craig328: 29 November 2010 - PM Welcome to D. Of course, for anyone to accurately assist you we'd need to know the table you'd be wanting to perform the insert or update on, as well as the column names and datatypes of those columns.How about you tell us a little something about your experience level and the project you're working on while you go get that database info?
For starters though, the form elements you have there, the radio buttons, the way you have it set now, you won't be able to tell which record you're wanting to update on the action page. we'll continue but in the future when you need code assistance, please show some initiative and actually try it yourself before asking others to do it for you. What you'll need is a little more than the SQL to update the database record.You look like you're kind of a beginner to CF and that's okay.Note that you won't see every ID you might have pulled for q Item that you looped over to create the form matrix on your form page.This is because unless the user selects either approve or decline (they select neither) the form element won't be passed and, thus, you won't have it on action page.Andrea Rossi, founder and chief technology officer at Leonardo Corporation, gets a royalty on sales.