Can anybody tell me how (or if) I can control the way in which Spectra stores datetime values?
The situation as I understand it at the moment is that if I have a date "12/01/2001" then it is stored in the WDDX packet as a raw string. However, if I then mark that property as searchable, the tags <cfa_recordupdate> and friends convert it to a number by adding zero. The trouble occurs in that the number produced is in US format. I.e. if I try: <cfset string="12/01/2001"> <cfset datenumber = string + 0> <cfoutput>new date is: #DateFormat(datenumber)#</cfoutput> then this outputs 1st December instead of 12th January, which is fine if you meant to input a US-format date, but not so good if you live in the UK. Is there any way to tell Coldfusion to do its conversion-to-number thing using locale settings, or am I doomed to go and hack all the relevant Spectra tags and/or override the property definitions so that they convert the date string to the correct number before the properties struct gets anywhere near the record-updating tags? Many thanks, -Tristan. -- [EMAIL PROTECTED] http://www.roddis.org -------------------------------oOo--------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
