How would I code >= or <= in an SQL- 92 equivalent? And what is SQL-92?
Rick -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, July 31, 2006 4:19 AM To: CF-Talk Subject: RE: Anyone see anything wrong with this code? I would also consider dropping the != syntax for some SQL-92 equivalent. -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 31 July 2006 04:57 To: CF-Talk Subject: RE: Anyone see anything wrong with this code? No luck involved with CreateODBCDate recognizing Form.Start_Date... the date will have already passed through some validation. Ever since I started using MySQL a few years ago, I've had difficulties getting it to accept dates without the "mmm d, yyyy" formatting. Could be something I'm not setting up properly in the db itself... perhaps a mask or something. But this method has always worked and gives me what I want going in and out, so it's not a problem. I can't argue with success... Rick -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Sunday, July 30, 2006 10:55 PM To: CF-Talk Subject: Re: Anyone see anything wrong with this code? >>Value="#DateFormat(CreateODBCDate(Form.Start_Date), "mmm d, yyyy")#" If CreateODBCDate recognizes Form.Start_Date as a valid date, just because you are lucky, then CreateODBCDate is your solution. But, as soon as you do have an ODBC date, why the heck reformat it as a string? Just use Value=#CreateODBCDate(Form.Start_Date)# then. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248231 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
