You sir are a sexy biotch :)
-----Original Message-----
From: Marlon Moyer [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 07, 2005 10:53 PM
To: CF-Community
Subject: Re: SQL Question
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
> >
> >
> >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:163650
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
