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:262216
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
