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:163642
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=89.70.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
