I am wondering if there is a more elegant way to get the current server date/time than the way I've been doing it. The way I've been doing it works about 99.8% of the time and then, inexplicably, doesn't and I don't know why, but it throws an error.
I made a tiny table with two fields, one is datetime type. I insert a single record with getdate() then grab its value right after. I cfset the date value as a var. Then I do a datecompare. But once in a great while the date value 'set' ends up blank--no clue why. So I guess I need to find a different way to accomplish this. Sample code follows. <cftransaction> <cfquery name="inow" datasource="#variables.odbcd#"> insert into tb_temp1 (temp1now) values (getdate())</cfquery> <cfquery name="maxid" datasource="#variables.odbcd#"> select max(temp1id) as maxid from tb_temp1</cfquery> </cftransaction> <cfquery name="timenow" datasource="#variables.odbcd#"> select temp1now from tb_temp1 where temp1id = #maxid.maxid#</cfquery> <cfset newnow = '#DateFormat(timenow.temp1now,"mm/dd/yyyy")# #TimeFormat(timenow.temp1now,"hh:mm:ss tt")#'> Then (using a value pulled from a query on test settings): <cfset precision = 's'> <CFSET okopen = DateCompare(variables.newopen, variables.newnow, variables.precision)> And about 1 out of every... maybe 150 times this runs, I get the error: ------------- An error occurred while evaluating the expression: okopen = DateCompare(variables.newopen, variables.newnow, variables.precision) Parameter 2 of function DateCompare which is now " " must be a date/time value ------------- It's just often enough to really annoy a customer with 500 students testing a week, and just rare enough to seem like it OUGHT to work, code-wise. Does anybody have any ideas? I open to just about anything by now. :-) Best regards, PJ --- [This E-mail scanned for viruses by Declude Virus] ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
