Recent content by kathryn

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

Well...that was easy! Thanks, I was, as usual trying to do it the hard way (checking the registry!) Kathryn

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

You are a LIFESAVER!!!! I have spent three days pulling my hair out on this one. Thank you so much. If I hadn't already named him, I would almost name my first born son after you! (Your name doesn't happen to be John, by any chance?) Have a happy New Year and thanks again. Kathryn

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

thanks for the suggestion. I assumed that I had to use the code instead of the named constant. I will give that a try. Kathryn

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

tleish, Yes, the exec is in the correct place. Even though it is in the system32 directory, it can be called directly from the c: prompt. One important thing I didn't mention is that I can get another, dummy, VBscript to run using the exact same syntax. The dummy script just copies a file...

tleish, Thanks for the quick reply. The answers to your questions are: 1. Yes, CFEXECUTE is enabled. 2. The cfoutput is there because originally the arguments for the wscript.exe were dynamically generated. We have hardcoded them for debugging purposes. 3. Yes, the ping of yahoo worked...

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