my "two" cents . . .
depending on your specific application, you may want to use the
tworelatedselects tag . . . .
I believe you can get it from the Developer Exchange in the Allaire site.
Trip Ward
Webmaster
EBStor.Com
(703)393-7930 ext. 273
> -----Original Message-----
> From: WL [SMTP:[EMAIL PROTECTED]]
> Sent: Sunday, May 14, 2000 9:49 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Is this a valid SQL query?
>
>
> > Looks OK... by not working, I assume you mean that you get no results
> returned.
>
> yeah. It just keeps on loading, but nothing happens. Could this be
> because
> I'm running CF Express? I haven't yet experienced a problem like this -
> usually I'm at fault(!) and it tells me so, or it says CFXpress doesn't
> support this function. But with this, it just doesn't do anything.
>
> Any ideas?
>
> Thanks
>
> Will
>
> >
> > You might add:
> >
> > sub_categories.cat_id
> >
> > to your SELECT clause and remove the WHERE clause...
> >
> > You will see what the actual data is (could be a lot of data).
> >
> > HTH
> >
> > Dick
> >
> > At 2:19 PM +0100 5/14/2000, WL wrote:
> > >Hi,
> > >
> > >Is this OK for a SQL query? The 2 tables in question are categories
> and
> > >sub_categories. Everything seems ok, but it's not working..
> > >
> > ><cfquery name = "cats" datasource = "localads">
> > > Select categories.ID, categories.cat_name, sub_categories.sub_id,
> > >sub_categories.sub_name, sub_categories.sub_descript
> > >
> > > FROM categories,sub_categories
> > >
> > > WHERE sub_categories.cat_id = categories.ID
> > >
> > >
> > ></cfquery>
> > >
> > >Thanks,
> > >
> > >Will
> > >
> >
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --------------------------------------------------------------------------
> ----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.