Search results for query: *

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

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

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

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

Hi, I was provided a csv file with a list of affirmations for a project that I am working on. The issue is, apparently the original file was generated in Word, pasted into Excel and output to csv. When I send text messages with the affirmations I am seeing a lot of odd characters i.e. "I am...

I use cfmail quite frequently, but have not fund a good solution to update list records when the email bounces. Does anyone have a solution?

Hi, I am running the following if statement <cfif getdealerupdates.dealerstatus IS "A"><cfset isactive = "1"><cfelse><cfset isactive = "0"></cfif> It always returns isactive as 0. I ran this right after the cfset noted above: <cfoutput>Status: #getdealerupdates.dealerstatus# - Active Flag...

We are trying to parse xml and one of the node names is STATEORPROVINCECOUNTRYSUB-DIVISION. The hyphen in the node name cause the following error Element DEALERPARTY.SPECIFIEDORGANIZATION.POSTALADDRESS.STATEORPROVINCECOUNTRYSUB is undefined in a Java object of type class...

Hi, How do I display this a percent: #(TheCount/58)# Currently it displays as: 0.275862068966% I need: 27% Thannks

My client and business partner have thrown a business rule monkey wrench into my app and I am perplexed as to how we might handle it. Here's the scenario: Leads come into our system and are routed to the closest dealership. The dealership contact receives an email with a link to open a web page...

Should be simple but coming from ColdFusion to ASP it has me perplexed. I have a page that passes id like http://url.com?id=123 I need to pass that ID in a new href tag. This is what I have and it bombs: <a...

We have a simple DTS that basically dumps records into a text tab delimited file nightly. We would like to first check to see if there are records prior to creating the file. Something like an ActiveX task that runs the query, gets rowcount and if rowcount = 0 halt the DTS otherwise process the...

Is there a ColdFusion tag that functions like Proper in Excel? I have all of this data entered by sales people in ACT that I pulled into MS SQL 2000, but it seems some of the sales team have caps lock stuck on because the first and last names are all in upper case. I would like to present it...

Hi. I am looking for code or a tool to auto-generate forms from MS SQL tables. Seems like it would save a lot of time when developing table administration functions. Anyone familiar with something like this? I will write the insert/update statements, I just want a way to point to a SQL table...