I am still using MySQL4 for the database.
Both tables are identical besides the table name.
When the data is inserted into the registration table, I use the current date
in ColdFusion to put into the SQL query.
When the user confirms their account, I pull their customer data by ID and
simply c
Donald,
Did you upgrade your database from MySQL4 to MySQL5 as part of your upgrade to
CF8?
If so, you might check your submitDate field in your tblRegistration and see if
the default still exists in the table (assuming you were using a default value
to set the current date in that table).
It
Is there any chance something like this can happen if a websites SSL security
certificate expires?
That is one thing that happened during the time this problem occurred.
But out of about 40 customer fields (two others were also even dates), that one
date field was the only one that kept getting
I'm not supplying -00-00 exactly.
The proper date shows up in the temporary table.
But when copied to the customer table through the above SQL statement, it
receives -00-00 (null).
~|
ColdFusion 8 - Build next generati
ColdFusion will throw an error when if you supply -00-00 as the value
for any date functions, cfqueryparam, cfargument with a type of date, etc.
because -00-00 is not a valid date (neither is 02-30-2007).
HTH,
Aaron
P.S. I had this same problem and Sean Corfield alerted me to the fact that
Hello,
Recently I've noticed a weird problem.
During registration, I keep customer information in a registration (temporary)
table until they confirm their account via email.
Once the account is confirmed, I copy their data from the registration table
into the customer table.
The SQL is simil
6 matches
Mail list logo