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

    Replace NULL characters in string???

    I wasn't sure where to post this but I thought I would start here. My issue. I have a column in a table that can contain up to 7000 characters. Some the rows that resides in this column has a null value as the very last character. How can I remove that null character without manually doing it?
  2. freavis

    Stange file renaming problem.

    PHV - Thanks for the quick reply. I'm not sure I understand what you are saying to do. Could you maybe give a simple example of what you mean? Thanks, Frank
  3. freavis

    Stange file renaming problem.

    I have a script that goes through a folder and finds all files with a .kof extension. I then add a timestamp on the filename. ex.(test.kof to test2005082411.kof) However, I am getting mixed results on some systems this runs on. On some systems it works fine and others it is renaming way to...
  4. freavis

    F1 to continue to boot on DL360

    Have a question on an older DL360 that we are trying to use. I thought you might have seen this before. It is a Dual PIII 800 When it boots up it puts a message on the screen like this: 601 – Diskett Controller Error Then it says: Compaq Integrated Smart Array Controller v 1.42 Press...
  5. freavis

    Counting pages in a PDF

    I am trying to find a way to automate counting pages in a pdf. Does anyone know a way to count the nubmer of pages in a pdf using vbscript? I need it to search through a directory and its subdirectories based on a date range. Thanks, Frank
  6. freavis

    SQL RecordSet problem

    This was very helpful. There was one small problem though. I had to add rs.MoveNext to the loop. Went into an infinite loop the first time I ran it. Thank you very much for your help.
  7. freavis

    SQL RecordSet problem

    I am trying to run a query that return the output to a message box. However not being real familiar with recordsets I'm not sure how to return the info to the message box. I'm assuming that I will need to use some type of array. Please help. Script: Dim db, rundate, count db =...
  8. freavis

    ADO Update question

    I have a script that updates records in a DB and I want to know how many rows were updated when the script is done. Where and what do I need to add to this script to accomplish that? Dim db db = InputBox("Enter the database name you want to update.") 'Create Connection set con =...
  9. freavis

    Calculate space usage for a folder and all subfolders

    I am trying to calculate the size of a folder using a vbscript. I have already got a script that works using the .size property. But if you look at the propertys of a folder you will see a "Size:" and a "Size on Disk:". Does anyone know how to get the Size on Disk back...
  10. freavis

    Scheduled tasks error

    That is what the problem is. Thanks for such a quick response.
  11. freavis

    Scheduled tasks error

    I have been running a scheduled task on a computer for 2 weeks now. A couple days ago it stopped running. I figured it is a account/password problem but it does not appear to be that after checking. What I see in the log is that it completed but with an exit code of 80. I can't not find...
  12. freavis

    Delete print jobs from a print queue

    I have a print queue set up to save print jobs after printing for accounting purposes. I need a script that will delete jobs older that a specified date from that queue. Any ideas/code would be greatly appreciated. Thanks
  13. freavis

    Searching for files using vb script

    Try this one. Copy and paste into notepad 'Purpose: 'Recursively search a directory of files for a match by extension ' and place the results into an Excel spreadsheet ' 'Usage: 'Simply double-click the vbs file. The script will...
  14. freavis

    need help with a file cleanup script

    I need to create a script that searches a specified directory and its subfolders and deletes files that match a list of defined strings. I'm not an experienced vbscript user yet, so any help I could get would be greatly appreciated. Here is the list of files the script needs to search and...
  15. freavis

    FTP limit on mget

    also the files that I'm trying to do the mget on 25.3 they look something like this DMAPCHECK2001081609425019.DSS
  16. freavis

    exit script

    you can also create a script called EXIT and put one line in it 'exit' single quotes around it and make it executable and that will work also
  17. freavis

    exit script

    Sorry, try this in the .profile alias EXIT='exit' you need to put single quotes around the system command
  18. freavis

    exit script

    can you just set up an alias in their .profile alias EXIT=exit so that EXIT and exit are the same command
  19. freavis

    FTP limit on mget

    I am ftping to a SCO server and doing a mget on some files and notice that somewhere between 150 and 180 files there is a file limit. I get the error: "Arguments too long can't find list of remote files, oops" I find this to be a rather small number since AIX will let you do over 500...

Part and Inventory Search

Back
Top