Skip to main content
Participant
December 10, 2008
Question

Adding a record from IE7 form

  • December 10, 2008
  • 1 reply
  • 478 views
When I try to add a record to my database from a form in IE7 i got the following message

The error occurred in C:\ColdFusion8\wwwroot\admin\add.cfm: line 74

72 : <cfif IsDefined("FORM.Fecha_Ingreso") AND #FORM.Fecha_Ingreso# NEQ "">
73 : ###FORM.Fecha_Ingreso###
74 : <cfelse>
75 : NULL
76 : </cfif>

the coldfusion installation is OK, the connection to the database is OK, everything seems to be OK except when I tried to add the record. Anyone can help me please I´m a total Coldfusion dude.
This topic has been closed for replies.

1 reply

Inspiring
December 10, 2008
what's up with 3 # ???? that's really 2 more than usually necessary...

what data type is your db column you are trying to insert data into is
set to?
if it is a text-based data type, you need to enclose the value you are
inserting into in in ' (single quotes): '#form.Fecha_Ingreso#'. but you
should really learn to and get the habit of using <cfqueryparam> tag...
details are in the docs.

what type of form field is your Fecha_Ingreso?

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/