Is this a valid SQL query?
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.. 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 Thanks, Will -- Lukrative Media Ltd - Berkshire, UK -- 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.
Re: Is this a valid SQL query?
Looks OK... by not working, I assume you mean that you get no results returned. 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.. > > > 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 > > > > >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.
RE: Is this a valid SQL query?
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.. > > > > > > > > > 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 > > > > > > > > > > > > > > >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.
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.. > > > > > > 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 > > > > > > > > > >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.
RE: Is this a valid SQL query?
I don't think that's the answer. It is possible that you don't have any matching entries in your database. --Katrina Katrina Chapman Consultant Ameriquest Mortgage Trip Ward com> cc: Subject: RE: Is this a valid SQL query? 05/15/00 05:42 AM Please respond to cf-talk 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.. > > > > > > > > > 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 > > > > > > > > > > > > > > >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. -- 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.