Claude, Ok... How do you get Access to use the join syntax?
-mark -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, November 30, 2007 9:06 AM To: CF-Talk Subject: Re: sql editor >>For example, if you use Access to create JOIN query you will not get JOIN syntax. Instead you will get what I usually refer to as the "Access" join syntax. Although I agree that the Access query builder has its limit, it does support INNER, LEFT anf RIGHT joins. I have written my own "advanced query builder", part of my "ODBCMyAdmin" project. It supports JOIN, WHERE, ORDER BY, GROUP, HAVING, sub queries, UNION, etc. All with drag'n drop on tables and columns, 100% CF and Javascript code, CF 5, 6, 7, 8 compatible... I just need lots of time, which I don't have, to document it and package it :-( -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294009 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
