Search results for query: *

Good morning, all. I have a database table, tblJobPostings that I need to clean up. I have a number of rows with data in the Title field that looks like Manager Trainee - AnyTown XX123 CSR - MyTown ZQ123 Branch Manager - YourTown AA345 I need to get at the town names, i.e. AnyTown, MyTown...

Good evening, I have written an agent which forwards all mail received into a public folder to different addresses, based on the text in the message. The forwarding is working fine; however, all the forwarded mail is coming from me and not from the folder. The folder has an email address...

Good morning! Here is the situation. We have set up a simple script that forwards email from a public folder. We wrote the script while at the client PC, using Properties...Agents. Here are my questions: How do I get debug information? I don't want anything fancy, I just want a popup to...

Good afternoon all, I have created a DTS package that contains an Execute SQL Task, and ActiveX Scripting Task, and another Execute SQL Task. What the DTS Package does is delete indexes from a table if they exist (the first Execute SQL task), load in a variable number of text files from a...

Is it possible to create a custom form for emails which has a dropdown box with a limited number of recipients listed in it? If so, how would it work? Would we use scripting with the Send event? Any ideas, references, resources, or war stories would be greatly appreciated. Kathryn

Good afternoon all, This is what I want to do: 1. Drop indexes from a table. 2. Append a variable number of text files to the table. 3. Rebuild the indexes on the table. The text files are all in the same directory on the network and they are the only files in the directory. Since the...

Good afternoon, all. This is minor, but it should be fixable. When I check a sql file out of Visual SourceSafe, I open Query Analyser and click File Open. The default directory is the Personal directory under C:\winnt\profiles... I would like it to be the directory that VSS checked the sql...

I am going nuts trying to get a very simple (??!!) CFSCRIPT to work. I would appreciate any ideas. I have gotten very detailed in what I have done to pinpoint the problem. The following code works fine: ****BEGIN CODE SNIPPET***** /* set a reference to the opened document*/ objDoc =...

Good afternoon, all, I have been fighting with the CFSCRIPT below for hours. I have scoured the Internet for help and haven't found a solution. I found a CFSCRIPT to convert a Word document to HTML in cfcomet.com. The code works fine with some modification, to a point. The problem comes...

OK, here is the situation We have a development server, GENESIS, which is an NT box with CF 5.0 Server installed. On this box, CFEXECUTE runs fine. The CFEXECUTE calls wscript.exe which runs a VBScript to convert uploaded Word and Excel documents to HTML. We also a test server, ODYSSEY...

Good morning, all. Long time no post. I am helping a coworker with a project. He needs to change the linking fields of a subform in code. The problem is that in certain circumstances, there will be one field to link the form/subform and in other fields there will be two fields. What happens...

Good afternoon, all. Here is our problem. We have 600 branches who do not, and will not, have access to Internet email. They can receive internal email from each other and from headquarters. The branches do have access to select sites on the Internet and can order items from our vendors...

This problem has been bugging me for a while and I am wondering if anyone else experiences it or has a solution. I have checked the MS KB to no avail. If I apply formatting such as bullets, numbers, centering to a line of a Word document, the format is applied to the entire document. I can...

Good morning, all. I have written a VBScript to save an uploaded document as HTML for our Intranet. The code works fine; the file is found, saved with the .htm extension, and then displayed. The only problem is that all formatting is lost, such as font sizes and bolding! I have looked in the...

OK here is the text of my vbs file, which I am calling using wscript.exe (Windows Scripting): Dim objApp 'variable for an instance of the appropriate Application' Dim objDoc 'variable for an instance of document' Dim result 'variable for result to html.xla' Dim newFileName 'variable for new...

Good afternoon,all. Does anyone know the correct syntaxt to use the htmlconvert function from the html.xla add-in from within VBScript? This is what I have so far: set objApp = createObject("Excel.Application") msgbox("instance of excel created") //open the document...

Good afternoon. Thanks to NIMDA, our development server had to totally be rebuilt with all software reloaded. Since then, VSS has been running very slowly. Checking in and out individual files takes 2 - 3 seconds, and forget checking out an entire large project. Does anyone have anyplace...

Good morning, all. Excuse the very basic nature of this question, but how do I use VBScript with ColdFusion? All the documentation says that the <Script> tag only is for JavaScript. I am writing a custom tag to put on our server which will convert uploaded MS Office documents to HTML. I know...

Good morning, all. I have just been assigned a project to set up a company wide knowledge base and I am soliciting ideas, references, warnings, and resources. We will be using SQL Server for the database. There will be a user portion of the site and an admin portion. From the user portion we...

Good morning, all. Here is my problem. We have a number of Word and Excel documents that are currently available on our company Intranet. We have just rolled out the Intranet, so it is only available at HQ. We are slowly beginning to give our branches access, but our branch employees...