OOps I meant to mention this is a MS SQL 2000 DB.
On 1/27/2011 1:33 PM, Kelly Matthews wrote:
Ok so I haven't really written any code in tSQL yet that does major looping
like I'm doing in CF. Figured I'd post this here and see if anyone had some
input on how to convert this into tSQL so it
Sorry if this is a repost. I am not sure it posted the first time.
I do not think any looping is required. You should be able to do this using
sub queries within the where clause.
If you are using cfx_prod_custCat as a lookup table simply look for any
category that is not listed in the
I do not think any looping is required. You should be able to do this using
sub queries within the where clause.
If you are using cfx_prod_custCat as a lookup table simply look for any
category that is not listed in the custcat_id field:
UPDATE Categories SET hasproducts = 0 WHERE category
I forgot to mention that this would be MS SQL 2000
On 1/27/2011 1:33 PM, Kelly Matthews wrote:
Ok so I haven't really written any code in tSQL yet that does major looping
like I'm doing in CF. Figured I'd post this here and see if anyone had some
input on how to convert this into tSQL so
Ditto on the repost, not sure if my first reply posted...
Actually it's much more than that. There are a ton of categories that won't
have products, however, if they are a parent of a sub category that has a
product, they ultimately have products as well. This is why it requires nested
Sorry that I answer didn't take inheritance into account. Is there a maximum
number of levels of subcategories, or will it always be an unknown? I have
done looping with tSQL in the past using cursors, and it really is a pain.
You could use a UDF (User Defined Function) and return a table
It can go up to 5 levels deep, no more than that. Re: the UDF, that's a good
idea, I'll take a look at the link, thanks!
Sorry that I answer didn't take inheritance into account. Is there a
maximum number of levels of subcategories, or will it always be an
unknown? I have done looping
CFFLUSH?
At 03:11 PM 5/18/2004, you wrote:
Hello all,
I am using ColdFusionMX on Solaris8/9
I need to query some resources that do not respond in a timely manner
and as a fix, I can not cache the data.
So what I would like to do is submit the request(queryies) to the
various backend systems,
Oh, one other thing.
How could I submit several requests to various back-end systems (RDBMS,
IMAP, HTTP, etc. ) simultaneously.
For example, I want to execute the following request simultaneously.
All requests are independent of others.So I do not have to wait for
one come back before
, May 18, 2004 3:36 PM
To: CF-Talk
Subject: Re: How would I do this?
Oh, one other thing.
How could I submit several requests to various back-end
systems (RDBMS,
IMAP, HTTP, etc. ) simultaneously.
For example, I want to execute the following request simultaneously.
All requests
Message-
From: Troy Simpson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 4:36 PM
To: CF-Talk
Subject: Re: How would I do this?
Oh, one other thing.
How could I submit several requests to various back-end systems (RDBMS,
IMAP, HTTP, etc. ) simultaneously.
For example, I want to execute
11 matches
Mail list logo