Search results for query: *

I have a project that will need to show some apparel slowly spinning, similar to the Adidas Gigaride does with the 360 spin. I am wondering if they have a physical shoe and shoot it a certain way and then add those into Flash, or if they shoot the shoe and then put the frames into like RayDream...

Nevermind I forgot the group by :(

Okay this is where I am at. SELECT B.RDSTAT, COUNT(*) FROM ORPRDETL A, ORPRDETL B WHERE A.RDSTAT = 200 AND B.\"RDORD#\" = A.\"RDORD#\" AND B.RDENDX = '2006-02-27' AND B.RDENDX <> '1940-01-01' AND B.RDSTAT = (SELECT MAX( C.RDSTAT) FROM ORPRDETL C WHERE C.\"RDORD#\" = B.\"RDORD#\" AND C.RDENDX <>...

I've been looking at this, although not with an open mind, for about 2 days and I dont see anyway to get the current location of an item that left area 2 on x date, I might be wrong. This one got me counts. SELECT B.STAT, COUNT(*) FROM ORTL A ,ORTL B WHERE A.STAT = 3 AND B.INVOICE =...

Yeah thats sounds like a better idea, I'll post back what I find out.

The total for the last query is 131 out of a total number of 849 items that left area 2 on 3/1/2006.

I wish I could edit my posts :) sorry about the one line reply my mouse got ahead of my brain. I changed it a little bit to SELECT B.STAT, COUNT(*) FROM ORTL A ,ORTL B WHERE A.STAT = 3 AND B.INVOICE = A.INVOICE AND B.NDX >= 2006-01-31 AND B.STAT = (SELECT MAX(C.STAT) FROM...

Result for that is 8 = 56814.

SELECT B.STAT, COUNT(*) FROM ORTL A ,ORTL B WHERE A.STAT = 3 AND B.INVOICE = A.INVOICE AND B.NDX >= A.NDX AND B.STAT > A.STAT GROUP BY B.STAT This query seems to get me the counts for each area that the order has been too, however I need the query to not count the area if an order is...

This is the second time I'm going to attempt to post this, last time it didnt seem to take :( Anyway I'm using iSeries Access Driver for ODBC v9.blah.blah. Currently I am configuring a System DNS for each Library, I have tried to list multiple Libraries, on the 2nd tab, the driver for some...

Might have figured this one out myself.

The way I did my ODBC was through the Data Sources control panel, but I only saw where I could specify one Library, not very familiar with the window DSN setup.

There is one problem and that is I am doing this through and ODBC connection to an AS/400 and the two tables are in two seperate libraries, so I dont think the joins will work.

Okay thanks, just getting back to it after being out a few days.

There is no flag, however my report starts when the invoice leaves area 2

I forgot to answer the other question about not needing certian ones, 0 I dont need 1 is something all together different

Here is one set of scans from one invoice. Red is the area, green is the invoice #. 655391 E 1 1 10 0 2005-12-22 15:59:00 32 2005-12-22 16:21:00 76 0 1.00 C 1940-01-01 655391 E 2 1 20 1 2006-01-19 16:44:00 5 2006-01-19 16:44:00 5 0 1.00 C 1940-01-01 655391 E 3 1 30 2 2005-12-22 16:21:00 76...

SELECT COUNT(*) FROM \"ORTL\" WHERE \"STAT\" = 3 AND \"STAT\" !> 3 AND \"NDX\" = '2006-01-31' is what I tried next. then I tried I also did SELECT COUNT(*) FROM \"ORTL\" WHERE \"STAT\" = 3 AND \"STAT\" !> 3 AND \"STAT\" !< 3 AND \"NDX\" = '2006-01-31' I got the same count as the previous query...

SELECT COUNT(*) FROM \"ORTL\" WHERE \"STAT\" = 3 AND \"NDX\" = '2006-01-31' which gets me all the ones that are =3, of course :), however the same record could be finished and out the door and I need to know that as well as those that are at area 4, 5, 6 and 7. I know I'm not thinking clearly...

I'm running a query and I need some help going through the logic. First off the data is organized by an invoice number, however the invoice number is not important in the query, the query is looking for the current location of an item in a certain route that started on x date. So lets say...