insert into application_skills
SELECT <cfqueryparam value="#client.candidate_id#"
cfsqltype="CF_SQL_NUMERIC"> AS candidate_id,
<cfqueryparam value="#skill_id#" cfsqltype="CF_SQL_NUMERIC"> AS
skill_id,
<cfqueryparam value="#formData[i]#" cfsqltype="CF_SQL_NUMERIC">
as
proficiency_id,
skillType_id
FROM (select skillType_id from computerSkills_lookup where skill_id =
<cfqueryparam value="#skill_id#" cfsqltype="CF_SQL_NUMERIC">) skills
On 7/7/05, Loathe <[EMAIL PROTECTED]> wrote:
> 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
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase Studio MX from House of Fusion, a Macromedia Authorized Affiliate and
support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=50
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:163648
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
