RE: One textarea on form not going into the database

[Susan N. Klos]

I don't know.  It didn't work and then it did.  I was using <cfinsert> because the insert query I wrote kept giving me an error.  I went back to the query after <cfinsert> didn't work,  made sure all the fields were named the same everywhere, and it worked.  Go figure.  You misspell something and CF just is not intuitive enought to know you meant something else.  I guess this is good, since the overintuitiveness (is this a word?) of Word9, gets in the way of my creativity sometimes.

-----Original Message-----
From: Dave Cahall [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 12:36 PM
To: '[EMAIL PROTECTED]'
Subject: RE: One textarea on form not going into the database

To answer your previous question, scoping the variables means using the scope prefix such as form,session,variables,url,client etc.

 

JOOC (Just out of curiosity), what was the problem?

 

Dave Cahall
Vice President, Professional Services
Digitaris Technologies, Inc.
Office: 972.690.4131 ext 116
Mobil: 214.914.9947

-----Original Message-----
From: Susan N. Klos [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 10:03 AM
To: '[EMAIL PROTECTED]'
Subject: RE: One textarea on form not going into the database

Never mind.  Figured it out

-----Original Message-----
From: Susan N. Klos [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 10:48 AM
To: DFWCFUG (E-mail)
Subject: One textarea on form not going into the database

 

 Why would this not go into the database when everything else on the page does?

<tr><td >&nbsp;&nbsp;</td><td >Data Source:</td><td >&nbsp;&nbsp;</td><td ><i>(Oceanside School Discipline Reports)</i></td><td ><textarea cols="20" rows="3" name="DataSource" wrap="virtual"></textarea> </td></tr>

 

The field in the database is named DataSource.  The action page query is:

 

<CFQUERY  DATASOURCE="#Application.db#">
        INSERT into tblActivityProgramObjectives
        (ActivityID, GoalDate, TargetPopulation, ProposedChange, AmountofChange, DataElement, Year_DataSource, GoalYear, DataSource, BaselineStatistic, CurrentStatus, CurrentStatusIsNA)
        VALUES (#ActivityID#, '#dateformat(GoalDate,"mm/dd/yyyy")#', '#TargetPopulation#', '#ProposedChange#', '#AmountOfChange#', '#DataElement#', '#Year_DataSource#', '#GoalYear#', '#DataSource#', '#BaselineStatistic#', '#CurrentStatus#', '#CurrentStatusIsNA#')
    </CFQUERY

 

Any help would be greatly appreciated.