> Yeah I ran into the same thing when I tried convertin a sql > db to mysql. Had lotsa queries that bombed out. Speakin of > queries, I think dave might have some good tips on mysql. he > uses it alot.
<soap box> This is the #1 reason why I try to stay informed on what features are proprietary and what is standard. For example, I see a lot of CF developers use isNull(), which is proprietary MS TSQL. You can use the exact same syntax with coalesce(), but coalesce does more stuff if you need it, and it's ANSI standard. Microsoft is not alone in making proprietary extensions to SQL, but most of the ANSI SQL standard works fine across all databases. You might think you'll never switch DBs, but it happens more than you think. What if your company get's purchased, and the new owners are a strict Oracle shop? Or, what if you get a new Boss that hates your DB? You can't predict the future, but you can prepare for it. </soap box> -------------------- "EMF <idahopower.com>" made the following annotations. ------------------------------------------------------------------------------ This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. ============================================================================== ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:258455 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
