Oh, It's SQL Server 2000 btw.
-----Original Message----- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 10:29 PM To: CF-Community Subject: SQL Question Is there anyway to make something like this work: insert into application_skills ( candidate_id, skill_id, proficiency_id, skillType_id ) values ( <cfqueryparam value="#client.candidate_id#" cfsqltype="CF_SQL_NUMERIC">, <cfqueryparam value="#skill_id#" cfsqltype="CF_SQL_NUMERIC">, <cfqueryparam value="#formData[i]#" cfsqltype="CF_SQL_NUMERIC">, select skillType_id from computerSkills_lookup where skill_id = <cfqueryparam value="#skill_id#" cfsqltype="CF_SQL_NUMERIC"> ) Where I essentially just select the value to insert into my fourth column? It keeps blowing up. BTW this isn't in procedures, not sure if I can just do a select prior to the insert to get what I need and stick it in a variable. Tim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:163644 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
