Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: milton747
  • Content: Threads
  • Order by date
  1. milton747

    How to count rows?

    I have working SQL to count number of rows returned. When I insert a WHERE clause for VT(Vermont), the correct 4 rows are returned, but the row count is still a huge number. (I was expecting the count to be 4 to match the 4 rows returned.) Can anyone suggest SQL to count number of rows...
  2. milton747

    Matte display laptop - Recomendations?

    I'm searching for a *matte display* laptop. Does anyone have a laptop with matte display they could recommend? Thanks. My old Toshiba Tecra A1 needs replacing. (I get headaches from glossy LED backlit displays)
  3. milton747

    RUNNINGCOUNT-SO-FAR function ??

    Hi, I wish there was a RUNNINGCOUNT-SO-FAR function. I have got the 1st 3 cols including ROWSPERCOUNTRY. (See SQL below) I've played with various aggregates, but can't get the WANT_UNIQUE_WITHIN_COUNTRY column. Essentially a unique number for each customer within its country. (Restarts for each...
  4. milton747

    Sub-Totalling - Help.

    Hi everyone, I am going crazy trying to nest subqueries to get simple sub-totals. The goal is a row like this: STATE | CUSTID | CUSTNAME | ORDERID | STATE TOTAL | CUSTOMER TOTAL | ORDER TOTAL I'm trying to wrap INNER JOINS around my core SQL (which returns ORDER TOTAL) to get the other 2...
  5. milton747

    Sub-Totalling in SQL - Help.

    I'm not a SQL guru. I need to have a column which shows order total for each customer (LL_ORDERTOTAL summed foreach customer) and order total for each country (LL_ORDERTOTAL summed foreach country) I think I need some subqueries, but like I say, it's bit beyond me. Any assistance welcomed. (The...
  6. milton747

    Radio button alignment - Help.

    Hi, I'm having trouble aligning radio buttons down the page. 2 buttons per row, but they are not aligned. Any help welcome. Thanks (New to DIV and CSS) <HTML> <form name="regionForm"> <div style="margin: 0 auto"> <div style="width: auto; padding: 5px;"> <input type="radio" name="reg"...
  7. milton747

    Wanted: One line per country

    Newbie to SQL. SQL works, but what I'm hoping for is one line for all orders for a country. Currently get this: Australia 1201 22.23 Australia 1233 90.55 Belgium 2344 88.07 Belgium 2348 12.67 Can't think what I need to GROUP BY to get it. ------------------ SELECT...
  8. milton747

    Won't execute my JS function?

    Hi, I added a JS file to my HTML file programatically. It appended just fine, but it wont execute the function inside the JS file. Can any see what I'm doing wrong? Thanks. ----------------------------------- <html> <head> <script type="text/javascript"> function FindTotal(first,next,last) {...
  9. milton747

    HTML Constant? eg: $HOME=&quot;C:/home101&quot;

    Hi, Simple I hope. Is there a way to define a constant in an HTML file then use it throughout. (So I don't have to do a group replace) eg: <head> HOME="C:/home101" </head> <body> <H1>$HOME</H1> Will display C:/home101. (Could Javascript do the job somehow?) Thanks Milt.
  10. milton747

    URLBase to folder mapping?

    I have: http://127.0.0.1:58048/viewer/frameset Is there a way to find out where the Tomcat instance that is listening on 58048 is actually installed on the machine?
  11. milton747

    Is it possible to &quot;inherit&quot; and &quot;override&quot; CSS files?

    Is it possible to "inherit" and "override" CSS files? EG: Imagine I have A.css containing a style called A101. Is it possible to have B.css which includes A.css and then overrides style A101, either: i) Simply rename it to B202, and keep all the characteristics unchanged or ii) Rename it to...
  12. milton747

    Need to add ORDER BY ... DESC

    Hi folks, I need to add: ORDER BY TotalShipped DESC to get rows with large numbers first. Any help welcome.I've tried vairous places and get SQL errs. Thanks Milton ----------- select country, sum(TotalShipped)as shipped, sum(TotalCancelled) as cancelled, sum(TotalInProcess) as inProcess...
  13. milton747

    How to determine a .class file JAVA version?

    I was sent a .class file I have to use in a program. Is there a way to determine the JDK it was compiled with? ie: 1.4 vs.1.5 vs 1.6? Thanks
  14. milton747

    Counting Rows

    I'm hoping this is simple. I have a list categories, A,B C. I want to get the count of the number of occurances each category appears in another table. Result Wanted: Category COUNT_OF_LINES A 10 B 12 C 8 Psudeo SQL SELECT CATEGORY (SELECT COUNT_OF_LINES FROM...
  15. milton747

    Find non-matching rows?

    I'm trying to detect missing links in my tables. The SQL below revealed 16 rows (2 orders) in the ITEMS table, which do *not* have a matching entry in the ORDERS table. SELECT orders.orderID, items.orderID, items.itemcode, items.quantity, items.pricequote FROM orders RIGHT JOIN items ON...
  16. milton747

    Customer Total?

    Hi Folks, The CustomerTotal is always the same as the GrandTotal. I thought my syntax would provide the total for ALL orders for each Customer ID. Any suggestions? Thank U. TABLES..... Table_Orders * OrderID * CustID Table_Customers * CustID Table_Items * OrderID * itemcode * quantity *...
  17. milton747

    Aggregates

    Hi folks, I added a clause to a previously working SQL. (Provided kindly form this forum) (See below for complete good and bad verisons. ) The good version inserts the OrderTotal in each row: (SELECT SUM ( items.quantity * items.pricequote ) FROM items WHERE items.orderID =...
  18. milton747

    Excel; Pivot Table drop downs

    Is there a way to re-populate a 2nd pivot drop down based on the choice made in a pivot drop down? (Page Level) eg: If I have USA, and Europe in drop down #1, I only want to show either US States or EU countries in the 2nd drop down? Thanks
  19. milton747

    Percent needed

    I'm calulating each order line as a % of the total. OK, but I'm getting too many rows per order. EG: There are 3 lines in order #6. I get 9 rows back, 3 for each line. I was hoping for 1 row with the percentage in PCT. (I cannot use DISTINCT as there are lines with same OID and QTY) I've tried...
  20. milton747

    One Row Wanted.

    I'm the reports guy, so I struggle with SQL a bit. Here's my jam: For a particular customer, for all their orders, get the total quantity of each item they buy, and order big to small. (So we know what they buy most of.) Here' s what I have, but each order is separate. The ORDER BY 3 DESC...

Part and Inventory Search

Back
Top