Blarg! I tried this too: FROM query1 LEFT OUTER JOIN query2 ON query1.primaryKey = query2.primaryKey
I have yet to put any brain power into an alternative so suggestions on alternative ways to get this done would be appreciated. Adaryl "Did you reboot?" Wakefield Aviator by passion Programmer by sheer force of will ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 04, 2004 12:07 PM Subject: [KCFusion] QofQ & phone numbers > > Kevin, > > Check out www.cflib.org, they have a ton of simple custom tags that will help do little tasks. They probably have one that will format a date into a phone number. I think using a Mid function to pull the left, middle, and right string values from the number will work as someone suggested. > > Adaryl, > > I'm pretty sure that QofQ won't successfully handle all types of joins. It lacks 100% compatibility with Ansi standards on SQL. Sorry. Try replacing the *= with the more usual left outer join type of statements. *= is an older standard that while still somewhat supported in SQL Server (and fully supported in Oracle I think), it may not be compatible with CF in a QofQ. > > Ryan > > > > > > > > > ========================================================= > Kansas City ColdFusion User Group's website & listserv is > hosted through the generous support of Clickdoug.com > To send email to the list, email [EMAIL PROTECTED] > To (un)subscribe, email [EMAIL PROTECTED] with your request. > For hosting solutions http://www.clickdoug.com > Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. > ====================================================== > ========================================================= Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com To send email to the list, email [EMAIL PROTECTED] To (un)subscribe, email [EMAIL PROTECTED] with your request. For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. ======================================================
