Yes, it does. I used the query builder to create the queries as well so I
am pretty sure there would be no spelling problems either.
--Aimee
At 07:29 AM 9/18/2001 +1000, you wrote:
>Maybe a stupid question, but does TermID exist in either or both tables?
>
>Darryl
>
>-----Original Message-----
>From: Aimee Abbott [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, September 18, 2001 7:44 AM
>To: CF-Talk
>Subject: cf 5 can't join fields
>
>
>Hello all,
>
>I used cold fusion 5 and the Merant database drivers to create a new
>database (is this dbase V?) Anyway, now I have created four tables and I
>am trying to join two of them. What I would like to do is:
>
>select TERMS.termID, TERMS.term, CROSSREF.crossText
>from TERMS, CROSSREF
>where TERMS.termID = CROSSREF.termID
>
>but I get an error:
>An error occurred retrieving data: ODBC Error Code =S0022 (column not found)
>[MERANT]{ODBC dBase driver]Field not found TERMID
>Do I need to do joins in some different way with this driver? I have
>looked at the odbc*.pdf file that comes with CF5 and it looks like what I
>am doing should work just fine. Is there something I need to setup on the
>server in some different way????
>Aimee
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
