Re: Is this a valid SQL query?

2000-05-14 Thread Dick Applebaum
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, >

RE: Is this a valid SQL query?

2000-05-15 Thread Trip Ward
; 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 o

Re: Is this a valid SQL query?

2000-05-14 Thread WL
> 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

RE: Is this a valid SQL query?

2000-05-15 Thread KChapman
cc: Subject: RE: Is this a valid SQL query?