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 strongm 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: *

  1. milton747

    How to count rows?

    SOLUTION.... Include where in count sub-query. Sorry. SELECT brnNumber AS brnNumber, brnCity AS brnCity, x.rc FROM branchlocations, ( SELECT count(*) AS rc FROM branchlocations WHERE brnState = 'VT' ) AS x WHERE brnState = 'VT'
  2. milton747

    How to count rows?

    ...AFTER the WHERE clause is applied? Thanks. Milt. SELECT brnNumber AS brnNumber, brnCity AS brnCity, x.rc FROM branchlocations, ( SELECT count(*) AS rc FROM branchlocations ) AS x WHERE brnState = 'VT' ---------------------------------- Simply delete the WHERE line and all rows are...
  3. 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)
  4. 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...
  5. milton747

    Sub-Totalling - Help.

    ...- custID == items == - orderID - price - quantity - Below works to return order total. SELECT orders.custID, orders.orderID, SSA.OT FROM orders INNER JOIN (SELECT items.orderID, SUM ( items.quantity * items.pricequote ) AS OT FROM items GROUP BY items.orderID ) SSA ON SSA.orderID =...
  6. milton747

    Sub-Totalling in SQL - Help.

    Hi there, It doesn't likeL CustTotal.Total AS .... CountryTotal.Total AS .... Maybe .Total is not supported in this tool. Would it possible to use SUM() here?
  7. milton747

    Sub-Totalling in SQL - Help.

    ...it would handle grouping but it seems buggy.) SELECT CUSTOMERS.COUNTRY, CUSTOMERS.CUSTOMERNAME, ORDERS.ORDERNUMBER, ORDERDETAILS.QUANTITYORDERED * ORDERDETAILS.PRICEEACH AS LINETOTAL, (SELECT SUM( ORDERDETAILS.QUANTITYORDERED * ORDERDETAILS.PRICEEACH) FROM ORDERDETAILS WHERE...
  8. milton747

    Radio button alignment - Help.

    Thanks Chris. I'll tinkering with your sample. Milt.
  9. 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"...
  10. milton747

    Wanted: One line per country

    ...------------------ SELECT CLASSICMODELS.CUSTOMERS.COUNTRY, CLASSICMODELS.ORDERS.ORDERNUMBER, SUM (CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED * CLASSICMODELS.ORDERDETAILS.PRICEEACH) AS LT from CLASSICMODELS.CUSTOMERS, CLASSICMODELS.ORDERDETAILS, CLASSICMODELS.ORDERS WHERE...
  11. milton747

    Won't execute my JS function?

    Thanks Greg. Even after I dynamically add js8.js to the HTML page, it does not run j8() which is inside js8.js? I can't see why not. Best Regs, Milt.
  12. 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) {...
  13. milton747

    help related to mid function

    Dim ssn As String Dim s As String ssn = "123456789" s = Mid$(ssn,1,3) + "-" s = s + Mid$(ssn,4,2) + "-" s = s + Mid$(ssn,6,4) showFactoryStatus(s)
  14. 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.
  15. 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?
  16. milton747

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

    TO: Vragabond and Olaf. Thanks guys. I'll try out the solutions you posted.
  17. milton747

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

    ...or ii) Rename it to B202 and then override some of the settings, and add new ones. (Essentially, traditional OO class inheritance mechanism) *REASON* I have a s/ware product that can apply CSS styles to elements BUT the styles must be specific names. So, I want to use my existing css files...
  18. milton747

    Need to add ORDER BY ... DESC

    Beautiful! Thanks PH.
  19. milton747

    Need to add ORDER BY ... DESC

    ...as onHold, sum(TotalResolved) as resolved from ( SELECT country, case when status = 'Cancelled' then CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED * CLASSICMODELS.ORDERDETAILS.PRICEEACH else 0 end as TotalCancelled, case when status = 'Shipped' then CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED *...
  20. 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

Part and Inventory Search

Back
Top