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 Rhinorhino 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: JAFrank
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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>...
  4. 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
  5. 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...
  6. 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...
  7. JAFrank

    Transfer files from Mac to PC?

    I am trying to find a simple way for a user to transfer some Postscript files from their OS 9.2 Mac to a Win2K Pro workstation. Unfortunately, I'm mostly a PC guy, and I suspect I may be making it too hard. The Pro version of Win2k doesn't have services for Mac - and there is no budget for...
  8. JAFrank

    Identify Ultra 60 CPU?

    Is there a way to tell which cpu an Ultra 60 is running without opening the case? Even better if it can be done without rebooting.... Thanks! Allen
  9. JAFrank

    Capture ps output over time?

    Is there a way to capture, say, 60 seconds or so of ps output? Our system uses a customized user interface which has a button to save accounting info to a file. What I am trying to do is figure out what program it calls, so that I can set up a cron entry which runs the process on a regular...
  10. JAFrank

    Execute program as su

    Ok, I know I should know how to do this, but apparently there's a dead brain cell right there.... I need to run a program from the command line as su - can someone help me with the syntax? Thanks! Allen
  11. JAFrank

    Command history in csh (amateur question)

    Is there a way to use the command history in csh in the same way that you can in bash, or even DOS (Doskey)? I love the way you can use your arrow keys to scroll through the command history with the arrow keys and edit recent commands right on the command line. I have read the man pages on...
  12. JAFrank

    Help with Find command

    Hello, I am trying to use a cron entry to clean old files out of an archive directory. I have set it up using the following command: 0,5,10,15,20,25,30,35,40,45,50,55 * * * * find /var/spool/archive -name &quot;?f*&quot; -mtime +1 -exec rm -f {} \; Every 5 minutes, it checks...
  13. JAFrank

    Unable to update Public Free / Busy Data. Operation Failed

    I have searched the forums and see that this subject has come up before, but the suggested remedy did not have any effect for me. I am running Outlook 2000 on Win98Se, accessing an Exchange 5.5 server. Every time I add or change a calendar event, after about 5 minutes I get a dialog with the...
  14. JAFrank

    Capture network printer to LPT?

    Is there a way in WIN2K to capture a network printer and map it to a local port like you can do in Win98? We have a legacy application which needs to print to lpt1, and we would like to send it to a network printer... Thanks JAF
  15. JAFrank

    Sun Monitor on Wintel pc?

    Has anyone done this? I have an opportunity to pick up a very slightly used 21&quot; Sun monitor - I don't have the model number right here in front of me - for a very good price. I know I can get a vga to Sun adapter for the cable, but I am wondering if I have to do anything special to make...
  16. JAFrank

    Limit access to certain IP addresses?

    I am planning to install an Ultra 10 in another city as a print server/controller for a production print device. All print work will come from a host in my city, and will be sent via LPR as a Postscript file. We would like to find a way to lock this machine down to the point that it will only...

Part and Inventory Search

Back
Top