Search results for query: *

Thank you, thank you, thank you! Worked great!

What I need are clients that subscribe to ANY of the newsletters in the list. Thanks so much for your help.

Wondering if you can help me. I have a friend who is generating a list from check boxes on a form. He then wants to retrieve clients who subscribe to newsletters based on the list, it's been 10 years since I've done any programming and I can’t remember how to do it. This is what he has...

I am pulling my hair out. This is my first stab at parsing XML and getting the values into a MS SQL database. MY CODE <cffile action="Read" file="C:\inetpub\wwwroot\am\xml\thexml.xml" variable="readText"> <!--- Create a new ColdFusion XML document object ---> <cfxml variable="XMLFile">...

Disregard I fixed it. I was setting media node outside of the loop and therefor was not getting a proper count for the index.

I can't find any documentation on the error "The index of a child element is out of range." Here's my code: <cffile action="Read" file="C:\inetpub\wwwroot\ammarine\xml\inventory#dateformat(NOW(),"MM_DD_YY")#.xml" variable="readText"> <!--- Create a new ColdFusion XML document object --->...

Hi, Looking for a solution to skip moving file names prefaced with donotimport. Basically, I want to move all files with the excetion of those that start with donotimport. So my files in the directory may look like: newmembers5_22_2011.txt newmembers5_23_2001.txt newmembers5_23_2011.xml...

Hi, I am having a hard time wrapping my head around this issue. cfpdf merge requires the absolute path of the files to be set in the tag, comma delimited. For example, see the following code: <cfpdf action="merge" source=" E:\webs\XXXX\YYYY\ZZZZ\newsletters\Wheat167.pdf...

Hi, I have been tasked with sending SMS messages through a third party gateway. This gateway requires Basic Authentication??? Does anyone know where I can find documentation on this authentication method? Here's all they gave me: "All REST API calls require the user to authenticate via Basic...

Hi, The issue: I need to pull 1 random record form a table to send a message via email to a recipient. Client can select times and message types. Once a message has been sent it is flagged and won't be sent again to the client (until all messages within a given category have been sent to the...

Disregard I got it. Thanks again.

Thanks! One additional question if you don't mind. I need to replace a bunch of characters. This works with the except it also removes all of the spaces. #rereplace(description, '[^\w]', '', 'all')#. I'm not sure what to do. Right now it looks like...

Hi - I have a database column named description that contains data that looks like: - Peel and Stick Darkening Vinyl Tempory Shade- No Pull Cord Danger- Easily Adjusts to Any Window (18~ x 36~)- EZ 1 Piece Installation I want to create a bulleted list using the hyphen (-) as the delimiter. So...

Fantastic. Thank you very much.

I used Bammy's code: <cfloop index="index" list="#txtfile#" delimiters="#chr(10)##chr(13)#"> <cfset index = ReplaceNoCase(index,"||","| |","ALL")> <cfif Right(index,1) EQ "|"> <cfset index = index & " " /> </cfif> <cfif Left(index,1) EQ "|"> <cfset index = " " &...

Thanks guys, it's working great with one exception. The name MARCOS GONZALEZ in the file becomes MARCOSGONZALEZ in the import. How can this be avoided. Thanks again for your help.

Thanks! Meetings this morning, will try as soon as I break free and will let you know.

Hello, This worked quite well for me until this morning when I added 2 additional fields to the database to separate first, last and mi. Here's a sample of the text file: JOHN|G|SMITH|JOHNGSMITH@ATT.NET|MARCOS GONZALEZ|NEW ACCOUNT Here's my code: <cffile action="read"...

Hi, I need to run a scheduled task on the quarter hour starting at 12:00 AM. 12:00 Am 12:15 AM 12:30 AM.... For some reason, the timing gets off by 1 minute randomly. I will see the task run on the quarters, then it will run at 2:01 PM, 2:16 PM, 2:31 PM. WHY? I attached a snap shot of my...

Thank you. I will give it a shot.