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 copy it from the Registration table into the Customer table. Now that the (SSL) security certificate has been renewed on the website, that one date field is copying over perfectly fine. I cannot think of an explanation for this issue, especially since the other date fields never had a problem. Just the submitDate... > 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 might be that the data was copied over, but not some of the > settings. > > Steve > > > 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 similar to this: > > > > INSERT INTO tblCustomers (firstName, lastName, submitDate) > > SELECT firstName, lastName, submitDate > > FROM tblRegistration > > WHERE customerID = #getUserInfo.customerID# > > > > This has worked fine for over 400 customers so far. > > > > But recently I have noticed the submit date is copying over > > incorrectly and is being inserted as null (0000-00-00). > > > > The only thing I could think of that has changed is that Crystal > Tech > > (the hosting company) has switched over to ColdFusion 8. > > > > Is there any obvious solution to this problem that I have missed? > > Could it be something that changed in ColdFusion 8? > > > > Any help would be appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290783 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
