Search results for query: *

I have created a DTS package under the dbo user (server administrator). When I run this package manually, by clicking Execute Package, it drops a table with all the content, re-creates the table, does a text file import into the table and then sends an email to me. The package works fine...

Hello, In my macro I have a condition that if a file does not exists, then display a message and stop the macro... this works.. If the file exists, then: 1) display a message that the file was found, 2) ask for today's date, 3) import the file, and 4) notify the user when the import is...

Hello, I am trying to use this Regex pattern to read a text file that is comma separated and uses double quote as the text qualifier. "(.*?)","(.*?)","(.*?)","(.*?)","(.*?)","(\w{2})","(.*?)","(.*?)","(.*?)".*[\r|\n] I tested it with Expresso and got the results I wanted. The question is: How...

Could anyone tell me if it is possible to do this? I have an email sent as text only, no HTML tags. Now, I need some text in it to be bold and/or RED color. If this is possible, how ?? Thanks for your help.

I am running a page with this code, but it doesn't seem to be working...the table to be affected is not changing. The dts package is saved in the SQL Server. Please, could anyone tell me what am I missing or doing wrong ? <cfstoredproc procedure = "DTS_FILE2" dataSource = "CATS"...

Hello friends, I am trying to learn how to schedule a job, but I also have this project that seems to be perfect to use this tool. I would like to schedule a job that would: 1) Run a DTS package I have created (which updates Table2 by droping the rows and replacing them with the content of a...

Hello, I have looked at many other forums and threads and have not found anything that does exactly what I need. But, I also know very little VB. Item 1 is done. I can do items 3 and 4. I need help with Item 2. 1) I want to have a button that when pressed opens an Input box and asks for a...

Hi, Help,..... please, please ? If I enter a piece of data, like zip code, and submit it in a form, then run a query that looks for that zip code... I would like to obtain the record number and display it in a message box, or in another field in the same form. By record number I mean the...

Could someone explain to me what the code below does and why it is throwing an error? rRemoveLeadingZeros=true rDecimalPlaces=2 strTemp=rValue=00000000986 if rRemoveLeadingZeros = True then strTemp = REReplace("^0+([0-9]{" & rDecimalPlaces + 1 & ",})$",strTemp,"$1") end if 'line 21...

Could someone explain to me what the code below does and why it is throwing an error? rRemoveLeadingZeros=true rDecimalPlaces=true strTemp=rValue=00000000986 if rRemoveLeadingZeros = True then strTemp = REReplace("^0+([0-9]{" & rDecimalPlaces + 1 & ",})$",strTemp,"$1") end if 'line 21...

Hello, I have a form in which I validate the controls with javascripts. All of them work fine and there is no sign of "errors on page" in the status bar of my IE browser. When I click submit after filling out all the fields, nothing happens. I have set the action page and the form name and all...

Hello, I have a form in which I validate the controls with javascripts. All of them work fine and there is no sign of "errors on page" in the status bar of my IE browser. When I click submit after filling out all the fields, nothing happens. I have set the action page and the form name and all...

Please advice. I need to compare the columns Category against myPreferences. Both columns contain a list of values (there could be a lot of values). I want to find out if Category contains any of the values contained in myPreferences. Is this possible?? could you help me please? Thanks.

Hello, please help. I am using Coldfusion to create a form. The user is ordering T-shirts for the team. What I wish to accomplish in part of this form is the following: The user will select an activity (examples: chess club, soccer, golf). The change in the drop down box should trigger...

Hello, I would like my code to populate a key-value structure according to the selection from a Drop down box called &quot;ThisActivity&quot; (Chess Club, Soccer, Golf), the keys of the structure (example: Ts-YM, Ts-YL) are contained in a table, the structure name is &quot;Items&quot;, and the...

Hello, What do I need to do to stop that? I have stated the noresize attribute on the frames. Thanks in advance. Ross

I can't seem to find an answer to my problem. Please advice. This code works if the user has Full Acrobat, but what should I do if they only have Reader?? this.mailDoc(true, &quot;name@address.com&quot;, &quot;&quot;, &quot;&quot;, &quot;Subject&quot;); As the Acrobat Help says and every...

Please, can someone tell me what is wrong in the code below? I am just starting to learn SQL, (by myself) and need some guidance... Thank you. I get this error messages: Server: Msg 156, Level 15, State 1, Line 4 Incorrect syntax near the keyword 'IF'. Server: Msg 156, Level 15, State 1, Line...

HI, I would greatly appreciate any help on this issue. If I have this code: <cfquery name=&quot;names&quot; datasource=&quot;workshop&quot; dbtype=&quot;ODBC&quot;> Select name, email, #listClassCodes# From InsAsst Order by name </cfquery> How can I reference the names.fieldname and obtain...

Please, help me. I know very little Javascript. [sadeyes] I want to validate a group of radio buttons and if the NO (position 1) is selected then the Selection box 4 has to be answered also. Here is my code, it works in IE, but NN. Thanks ahead for your help. if (!(frmForm.q3[0].checked ||...