I had a little extra code in the previous one.
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 computerSkills_lookup where skill_id = <cfqueryparam
value="#skill_id#" cfsqltype="CF_SQL_NUMERIC">
On 7/7/05, Marlon Moyer <[EMAIL PROTECTED]> wrote:
> 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 Homesite Plus with Dreamweaver from House of Fusion, a Macromedia
Authorized Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=55
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:163649
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
