Search results for query: *

Hi All As always any help greatfully received. New to working with forms, etc. I have a project that requires me to capture a few selections from the user before executing code. I have filled a combo box OK. WHen you drop the box you see all the required values. When you click on one of the...

Hi All Any help greatfully received. Need to use TO_CHAR function but I cant get the ole provider to pass the double quotes needed for the TO_CHAR arguments. The error returns "Column (%d/%m/%y %T) not found in any table in the query (or SLV is undefined)." the sql works fine using SQL...

Hi All As always any help gratefully received. I would like some advice calling a stored proc from a vbScript I have tried several methods cnIfmx.BeginTrans Set cmd.ActiveConnection = cnIfmx cmd.CommandType() = 4 cmd.CommandText = "CALL sp_myProc (?,?,?,?,?,?,?,?,?,?)" cmd.Execute and also...

Hi there I Know what I want but not sure how to get it! I need to replace some switches that were supplied and configured by a 3rd party. We have some exisiting VLANs and I need to add a couple to spread between sites. Site A has an existing HP4903 with various modules all currently using the...

Hi there I have an exchange 2003 server. One external users needs to send us large mail 30MB pretty regulary. Our server is bouncing these back with; This message is larger than the current system limit or the recipient's mailbox is full. Create a shorter message body or remove attachments...

Hi there As always, any help gratefully received. I know virtually nothing about http post. however, I need to knock a script up that allows me to pass data to a URL in the form of www.somedomain.com...

Hi there As always, any help gratefully received. I have written a small vb script to update various records in an informix database. However, when I run my connection.execute(sql) line I receive the following error; EIX000: 9-346) Could not update a row in the table. I have checked the sql...

Hi All AS always, any help gratefully received. Just testing a ADO connection before getting too far down the line and have the following problem When I create a recordset and loop through them, the wheels fall off at record 83 regardless of the SQL, i.e. SELECT FIRST 100... or SELECT * FROM...

Hi All, Any help gratefully received, I have been setting up a new Exchange Server. While setting up new recipient policies, I deleted the default policy, since then I have discovered lots of articles telling me not to delete it (Doh!). However, there dont seem to be any telling me how to...

i All As always any help gratefully received. Have loaded Office 2003. One user with brand new (Roaming) profile cannot send attachments from directly in MS Excel, i.e. Send as attachment. All that happens is Excel returns the error "General Mail Failure: Quit Microsoft Excel, restart the Mail...

Hi there As always, any help gratefully received. I am working on a project to check data in two databases in an attempt to match and update common ref to both systems. The two systems had been run as stand alone for some time and suffered a variety of data entry "standards". I have written a...

Hi All As always, any help gratefully received. I am writing a vbScript to insert jobs in to a jobs table. For the most part, the valuse to be entered are static. However, as you would expect I have a few variables I need to change with each insert. I have never worked out how to set the value...

Hi All As always, any help gratefully received. I am writing a vbScript to insert jobs in to a jobs table. For the most part, the valuse to be entered are static. However, as you would expect I have a few variables I need to change with each insert. I have never worked out how to set the value...

Hi there As always any help gratefully received. I am about to upgrade our existing MF XPa FR1 Farm (4 svrs) to Presentation Server XPe. Before I pull it all apart, I would like to know if anyone has any advice they think may be of help. ANy best practice or considerations would be very...

Hi there I am pretty used to writing vbScript to manage databases. However SQL Stored Procs are pretty new to me. Any help gratefully received. I would like to create a record set from a normal SELECT Statment (Will return about 3,500 records) and execute a script for each record. EG: SELECT...

Hi there AS always any help gratefully received. I have a problem filtering records in a query with nested query. As you will see from the SQL below, I want to filter records based on a nested query with a record count < 2. For some reason I cant work out, the result is ignoring the HAVING...

Hi there As always any help appreciated. Have been using vbs to manage database for sometime but only recently realised its possible to use parameter queries with vbs. Something I thought was the luxury of vb.NET C#, etc. However looking for a breif example of how I might use this in an insert...

Hi there Have written small script to add records to various tables. Run as a SQL Script (on Advantage Database OLEDB connection), SQL script works fine. However, I want to run this as a processed transaction , if one fails then roll all back. However, when using commandtext, will not rollback...

Hi there As always any help gratefully received. Looking fr some ideas to read excel without installing excel app. Did try to set up ODBC DSN but am having trouble. Dont have any preference on connection method but.... I must be able to move around just like any other database connection...

Hi there As always any help gratefully received. Am writing script to create a csv file based on data from a DB. the script is something like; strComment = objRc1.Fields("CommentField") csv.Write strComment The problem I have is, as I try to add a new record to my csv file, things get messed...