No, I don't think that is it. I have been playing with it some more over
the past few minutes and am finding it seems to have something to do with
the table.field syntax. If I even do:
SELECT crossref.TERMID, crossref.CROSSTID, crossref.CROSSTTEXT
FROM crossref
or just:
SELECT terms.TERMID, terms.TERM, terms.DEFINE
FROM terms
(which I copied straight from the query builder) I get the same error
message. How can this be?
--Aimee
At 07:40 AM 9/18/2001 +1000, you wrote:
>You don't need to SELECT something in order to use it in the WHERE clause.
>I'm guessing that TermID doesn't exist in one of the tables, although I
>could be wrong.
>
>-----Original Message-----
>From: Bill Davidson [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, September 18, 2001 7:44 AM
>To: CF-Talk
>Subject: Re: cf 5 can't join fields
>
>
>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
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
