Yep.
INSERT INTO table_name (
var_one,
var_two)
VALUES (
'#var_one#',
'#var_two#')
<!----------------//------
andy matthews
web developer
certified advanced coldfusion programmer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--------------//--------->
-----Original Message-----
From: Chelsie Lawson [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 30, 2006 8:46 AM
To: CF-Talk
Subject: Re: Firefox Compatibility
did I mention that I'm completely new to CF....what would be the query code?
<cfquery name="AddEval" datasource="studentsurvey">
INSERT INTO Results
</cfquery>
do I have to list EVERY field with # # around them, separated by a comma??
> It's interesting that FORM.FIELDNAMES has a trailing comma.
>
> I have no idea why it would, but that might be the cause of the
> problem.
>
> Ditch cfinsert and use cfquery instead =) It's safer and performs
> better, and is far easier to debug.
>
> Rick
>
> Chelsie Lawson wrote:
> > here's the results:
> >
> >
> > FIELDNAMES STUDENTID,INDEXNO,FACULTY_ID,DATEMODIFIED,TIMEMODIFIED,
> GENDER,CLASSIFICATION,GPA,REASON4COURSE,NUMOFSTUDENTS,QUESTION1,
> QUESTION2,QUESTION3,QUESTION4,QUESTION5,QUESTION6,QUESTION7,QUESTION8,
> QUESTION9,QUESTION10,QUESTION11,QUESTION12,QUESTION13,QUESTION14,
> QUESTION15,QUESTION16,QUESTION17,QUESTION18,QUESTION19,QUESTION20,
> QUESTION21,QUESTION22,COMMENTS,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262241
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
