Please feel free to fix the typos by removing the extra space after the pound sign on the second insert value and the missing right parenthesis ")" to close the Values Caluse. Be aware there may be others, my example was created in the e-mail and untested.
-------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ....-----Original Message----- ....From: Ian Skinner ....Sent: Thursday, July 14, 2005 4:27 PM ....To: CF-Talk ....Subject: RE: 2 Primary Keys .... ....The fastest fix, from the example you provided, is to put pounds around ....the evaluate function otherwise you are trying to put a large string into ....you join column. .... ....But better yet may be something like this: ....<cfloop query="FindAttributes"> .... <cfif form["attribute_" & FindAttributes.attributeID] EQ "true"> .... <cfquery datasource="user020"> .... INSERT INTO .... tbl_020publicProfilesAttribes .... (profileID,attributeID) .... VALUES ( .... #InsertProfileDetails.profileID#, .... # form["attribute_" & ....FindAttributes.attributeID]# .... </cfquery> .... </cfif> ....</cfloop> .... ....While writing this to show how to eliminate the need for the evaluate ....functions by using structure and array notation I noticed that the form ....variable in the If statement was different then the one in the insert ....statement. One has an underscore "_" and the other does not. Is this ....not an error? .... ....-------------- ....Ian Skinner ....Web Programmer ....BloodSource ....www.BloodSource.org ....Sacramento, CA .... ...."C code. C code run. Run code run. Please!" ....- Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211939 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
