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

  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?

    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...
  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.

    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...
  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.

    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...
  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

    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...
  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?

    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...
  18. milton747

    Need to add ORDER BY ... DESC

    Beautiful! Thanks PH.
  19. 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...
  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