Recent content by freavis

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?

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

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

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

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

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.

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

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

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

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

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

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

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

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

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