Re: Data Parse error

[Maureen]

Use <cfqueryparm> and set the datatype for each field to match the
datatype in the database.  Make sure that any fields that are set to
not null in the database actually contain data before trying to insert
them.  Make sure the value of any key field field is unique and does
not already exist.

If you have debug on, you should be able to see the actual SQL that is
causing the error.

On Wed, Mar 17, 2010 at 12:42 PM, Steven Sprouse <sspro...@ccboe.com> wrote:
>
> You all have been able to help me so much this week with a form I've been 
> working on, and it's nearly complete. The final step is to get the data 
> entered into the database without throwing an error.
>
> The error is: Error Executing Database Query. [Macromedia][SequeLink JDBC 
> Driver][ODBC Socket][DataDirect][ODBC SequeLink driver][ODBC 
> Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL 
> <br>The error occurred on line 487.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331841
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm