I don't need to select something to use it in where, I only need to select
that which I am going to display (aka cfoutput). Thanks though.
--Aimee
At 05:43 PM 9/17/2001 -0400, you wrote:
>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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
