you need to Evaluate the fieldname. try: INSERT INTO artformjoin (userid, artformid) VALUES (#variables.userid#, #Evaluate(field)#)
actually I'm not sure that'll work, as all that field is is a string with the value "Artform". You'd really have to use #Evaluate(Form.ArtForm)# or something like that I think. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Ian Westbrook" To: "cfug dev list" <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: eam.net> Subject: [ cf-dev ] form.fieldnames 06/06/2003 13:38 Please respond to dev Hi I asked about this the other day, but I'm having problems getting it working this is the form: <cfquery datasource="#dsn#" name="artforms"> SELECT id, artform FROM artforms ORDER BY artform </cfquery> <form...> <cfoutput query="artforms"> <tr> <td>#artform#</td> <td><input type="checkbox" name="artform" value="#id#"></td> </tr> </cfoutput> <tr> <td> </td> <td><input type="submit" name="addartforms" value="add information" onclick="this.value='adding...';"></td> </tr> </form> and this is the code to process it: <cfif IsDefined("form.fieldnames")> <CFLOCK SCOPE="session" TIMEOUT="30" TYPE="Exclusive"> <cfif IsDefined("form.userid")> <cfset userid = #form.userid#> <cfelse> <cfset userid = #session.userid#> </cfif> // ie the above is either a value passed from a hidden form field, or is the user's sessionid <cfquery datasource="#dsn#"> DELETE * FROM artformjoin WHERE userid = #variables.userid# </cfquery> // whatever their artform choices are curently, delete them before adding the choices from the form. If they are adding for the first time the RC of the above query will be 0, but that doesn't matter <cfoutput> <cfloop index="field" LIST="#form.fieldnames#"> <cfif field IS NOT 'addartforms' AND field IS NOT 'userid' AND field IS NOT 'cfid' AND field IS NOT 'cftoken' AND field IS NOT 'page' AND field IS NOT 'action'> // ie if the form field is _not_ one of the hidden variables being passed <cfquery datasource="#dsn#"> INSERT INTO artformjoin (userid, artformid) VALUES (#variables.userid#, #field#) </cfquery> </cfif> </cfloop> </cfoutput> </CFLOCK> </cfif> and I'm getting this error: ODBC Error Code = 07001 (Wrong number of parameters) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly. SQL = "INSERT INTO artformjoin (userid, artformid) VALUES (16, ARTFORM)" it's trying to write the name of the field rather than its value... (ie the table is expecting a number and it's getting text) anyone any ideas? TIA Ian W Ian Westbrook, FutureDream Media Limited, (W): www.futuredream.net (E): [EMAIL PROTECTED] (T): +44 (0) 1303 258 985 (M): 07939 510 812 This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding any comments, opinions, information or conclusions expressed in this message are those of the originator, not of FutureDream Media Ltd, unless otherwise explicitly and independently indicated by an authorised representative of FutureDream Media Ltd. -- ** 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]
