Hi BJ
I can figure out a solution, I just wanted to make sure i wasn't missing
something before i got to work.
Thanks
Scott
BJ Freeman wrote:
I subscribe to having the db on a separate machine than the application.
it really speeds things up when your in 100K records.
Then using Cursors you don't load the whole Recordset into the
application. Which ofbiz does.
so it is not as much a resource hog as some might think.
Scott if you looking for a solution. why not put in the jira so people
can add snippets that might help.
Chris Howe sent the following on 6/30/2006 8:10 PM:
It's a relatively easy script to make (although a
resource hog I would imagine)
find all product
iterate through them their related
ProductCategoryMember and if it returns null, add that
product to your list
--- Scott Gray <[EMAIL PROTECTED]> wrote:
I guess at the end of the day, we could just drop
everything and use webtools ;-)
Scott
BJ Freeman wrote:
if you handy with SQL and understand the entity
relations you can use
the webtools.
Chris Howe sent the following on 6/30/2006 7:02
PM:
didn't there used to be in the catalog manager a
link
that would list all products that were without a
category? I don't see it there anymore
--- Si Chen <[EMAIL PROTECTED]>
wrote:
It can still be searched but if it's not in
ProductCategoryMember it won't show up in
categories' product
listings.
On Jun 30, 2006, at 6:35 PM, Scott Gray wrote:
Hi
Is there any way to find products that aren't
associated with any
category? For example, let's say we're adding
10
new products
everyday but occasionally you forget to
associate
a product with a
category, would this mean the product is lost
until someone notices
that it's missing from the ecommerce pages?
Thanks
Scott
