That is SQL92. You had != which is probably best set as <>
"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Rick Faircloth To: CF-Talk Sent: Mon Jul 31 15:45:56 2006 Subject: RE: Anyone see anything wrong with this code? 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:248233 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4