Perez, Jimmy writes: > I would suspect something with the ODBC driver as opposed to version of CF. Was >this on different machines? Finding the right layer to check is the hard part... >
Hey Jimmy: Thanks for the response. Yes, these are on different machines. Win2k vs WinNT, CF 4.5 vs CF 5 (same version of Access tho). And yes, isolating the error is the hard part...which is why i was asking here. i figured somebody smarter than I (in other words, anybody subscribed) might be able to help narrow it down, as you did. I appreciate it. charlie > hth > Jimmy > > Jesus said "I am the bread of life. He who comes to Me shall never hunger, and he >who believes in Me shall never thirst." John 6:35 > > -----Original Message----- > From: charlie griefer [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 10, 2002 11:43 AM > To: CF-Talk > Subject: SQL query woes...cf 4.5 v 5.0 > > > hey all... > > i have a query running against an Access database. on CF 5, works fine. on > cf 4.5, i get a SQL error. > > ODBC Error Code = S1000 (General error) > [Microsoft][ODBC Microsoft Access Driver] Join expression not supported. > > the JOIN looks like this: > FROM items INNER JOIN divorder ON val(left(items.costCtr,1)) = > divOrder.ccStart > > basically, i need to take the value from a column of one table > (divOrder.ccStart) and join it on the first character from the column of > another table (items.costCtr). further funkiness in that one column is > numeric (divOrder.ccStart), and one is text (items.costCtr). > > Even so, the query worked on CF 5. > > This is the first instance that I've encountered tho where CF versions > (supposedly) would be involved in successfully executing a particular query. > > I guess what I'm wondering is...can anybody possibly confirm that it is CF? > is there anything else that i should be looking at? And if it is CF, why? > :) > > thanks, > charlie > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
