BTW - I've just worked out the firewall issues I was having at my new company so I am now online. Greeting UK developers.
~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 06 June 2003 14:00 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] form.fieldnames Ian, No * required in the DELETE. <cfquery datasource="#dsn#"> DELETE FROM artformjoin WHERE userid = #variables.userid# </cfquery> Use form[field] to reference the content of your form field. <cfquery datasource="#dsn#"> INSERT INTO artformjoin (userid, artformid) VALUES (#variables.userid#, #form[field]#) </cfquery> Be aware that form.artform will be a comma delimited list of artform ids if the user selects more than one artform in form. You probably need some this like this. <cfif field eq 'artform'> <cfloop list="#form[field]#" index="artformid"> <cfquery datasource="#dsn#"> INSERT INTO artformjoin (userid, artformid) VALUES (#variables.userid#, #artformid#) </cfquery> </cfloop> </cfif> Stephen -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
