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

    How to create variable sized booklets on the fly in Postscript

    Do you have access to the Digimaster "Interface Developer's Guide? This document will probably get you started in the right direction. You can download the correct version for your system software here...
  2. JAFrank

    I could really use help with a SQL query

    I think I found a solution, but I would appreciate any feedback on ways that it might fail. I ended up moving my subqueries into the from clause, like this: select d.debtor_id, d.name1, emp.name, sum(t.cur_bal) as total from dm.dbtr d left outer join (select debtor_id, max(pmt_date)...
  3. JAFrank

    I could really use help with a SQL query

    I am getting so close, but I have run up against another odd behavior, and can't figure a way around it. Here is my query as it currently stands: Select d.debtor_id, d.name1, sum(t.cur_bal) as total, max(e.name), max(p.pmt_date) from dm.dbtr d left outer join dm.dbtremp e on...
  4. JAFrank

    I could really use help with a SQL query

    This is great! and I appreciate your help. Sadly, it turns out that I was trying to fix the wrong problem - and in an effort to simplify the question, I left out information (which I thought wasn't important) which is related to the problem. This query actually involves a join of 7 tables. I...
  5. JAFrank

    I could really use help with a SQL query

    Thanks, Does it make a difference that the debtor id and name are coming from a different table than the debts? Would I just need to add a join? select [debtor ID], [debtor name], sum([debt balance]) from [dbtr] join [debt] on [dbtr.debtor ID] = [debt.primary debtor ID] where...
  6. JAFrank

    I could really use help with a SQL query

    Thanks for any help, I think I am thinking myself into a corner... In my database I have (among others) 2 tables. One is a list of people who owe money (debtors) and the other is a list of individual debts. A debtor can have one or more debts. Debts are assigned a 3 digit status code. What I...
  7. JAFrank

    Combine 2 aggregate queries into one select statement?

    Thanks for the explanation. Luckily, nulls aren't a factor in this data. Each record will have *something* in each field, so all I have to worry about is calculating a "total if this" and a "total if that". It's working now, using two queries, and has been for a month or so - but something in...
  8. JAFrank

    Combine 2 aggregate queries into one select statement?

    Thanks for the explanation. Since I have one of those jobs where I don't get to do any one thing regularly, and have to jump from skillset to skillset (and language to language when I DO get to code), I tend to gravitate toward syntax that will be easy for me to understand when I next look at...
  9. JAFrank

    Combine 2 aggregate queries into one select statement?

    Ok, cool. And then in the second example, "NonLetterCount", we are using "then 0 else TotalCount" rather than "<> "Letter"? It looks like 2 ways to achieve the same result?
  10. JAFrank

    Combine 2 aggregate queries into one select statement?

    Thanks for this. I have never used Case in SQL, so I would like to make sure that I am clear on what this is doing: Select Sum(Case when PaperSize = 'Letter' Then TotalCount Else 0 End) As LetterCount, Sum(Case When PaperSize = 'Letter' Then 0 Else TotalCount End) As NonLetterCount...
  11. JAFrank

    Combine 2 aggregate queries into one select statement?

    I have 2 queries which perform aggregates (sum) on the same column, depending on the value of a different column in the same table - similar to this: SELECT SUM(TotalCount) WHERE PaperSize = "Letter" SELECT SUM(TotalCount) WHERE PaperSize <> "Letter" The actual queries are slightly more...
  12. JAFrank

    Outlook unable to open the outlook window. Exchange

    Can you tell me which settings you changed? I have run into this exact problem, and it's driving me batty! Thanks! JAFrank
  13. JAFrank

    Force log off in a domain environment

    Mark, my experience has been that setting logon time restrictions will prevent a user from logging in, but has no effect on a user who remains logged in after their time has expired. In other words, If I allow users to login between 7am and 6pm, a user who goes home at 5pm and leaves his...
  14. JAFrank

    spool file takes really long time to reach printer

    Did you ever get this fixed? What version of System Software are you running on your iR110? If you are running one of the 5.x versions, there is a patch available for the machine that addresses this exact problem. At one of my customers, installing this patch reduced the spool time of a...
  15. JAFrank

    Is it possible to LPR print from my app?

    I am in the planning stages of writing an application that will make a small modification to a Postscript file & then send it to a printer. I can't find any information on LPR in any of the VB help or in the MS KB. It's easy from the command line: lpr -S <server> -P <port/printer> <filename>...
  16. JAFrank

    Script to restart a process in Solaris 8

    Also, can vncserver be run by a user with less privileges than root?
  17. JAFrank

    Script to restart a process in Solaris 8

    I am trying to come up with a script that can be run periodically (via cron?) that would grep ps -A for Xvnc, and if it is not found, start vncserver. Any help would be appreciated. jafrank
  18. JAFrank

    Make VB4 32bit app watch a folder (hotfolder)

    Thanks for the reply. I am trying to figure out what would happen if the file were still being written when my program checked the folder? Would it generate an error, or would it try to process the incomplete file? The file I am processing is created by a &quot;Print to File&quot; process...
  19. JAFrank

    Automating &quot;Print to file&quot; - Possible????

    I am doing some work on an old DOS app which runs acceptably well in a Win2k console window. Unfortunately, it is hard coded to print it's reports to a dot matrix printer on LPT1. The ouput from this app has to be entered into another program, and currently someone has to retype the data from...
  20. JAFrank

    Make VB4 32bit app watch a folder (hotfolder)

    I am writing a VB app that opens a text file, manipulates the contents a little, and writes out to a new text file. I can make it work perfectly using manual controls, but what I would like to do is have it 'watch' a folder and have it do the conversion on any file that appears in the folder...

Part and Inventory Search

Back
Top