Hi, have a question about database formating with coldfusion query. In my database I have "2008-11-01", but when I export a csv file it changes the format. What is the best date format so when you upload the csv(I have a CF app that writes it to the DB) it keeps the same date format. It seems that when the date format was lost everything broke, but when I saw that the data format was changed and that was fixed everything worked again.
Also, when you upload a csv files,a nd write that to the DB,and you have a DB with auto increment, does this still work when you do not know how many rows you write, or is this just something that is done one by one. That is, if you are on 7, and you write another one it is 8, but when you upload and write a csv to the DB, you may not know. Sorry if I don't explain well, as I could include code as well. Thanks so much, John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4131 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
