It looks like you're not even selecting crossref.termID to use in your where
statement.
-Bill
brainbox
----- Original Message -----
From: "Aimee Abbott" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 5:44 PM
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
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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
