I have a project that I'm working on that will require me to do the following: 1. retrieve an updated text file from a remote server (not under my control) and...
... You said you've alreay got this going - as you say a CFHTTP (or CFFTP if needed) will pull the file easilly. ... Just run a query that truncates the table...
... That would seem to be the basic idea, yes. What I've done in the past is have an intermediate load table that has far less in the way of integrity checking...
... updating the SQL table with it? Do I convert the text file to a list or something? Nope, you get yourself CF_REExtract, call it with some clever REGEXPs, ...
If this is going to be an automated process, you need to be firm in that the input file MUST be in a certain format or chunks will be blown. It's the only way...
Maybe I was wrong but the line of code was inside a cfoutput??? ... From: coldfusion-howto@yahoogroups.com [mailto:coldfusion-howto@yahoogroups.com] On Behalf...
Different explanation: You don't need them when you're between the < and > of a CF tag, unless you're in between " marks: <cfset youDontNeedThemHere =...
got it thanks ... From: coldfusion-howto@yahoogroups.com [mailto:coldfusion-howto@yahoogroups.com] On Behalf Of Joe Rinehart Sent: Monday, August 01, 2005 3:16...
Thanks for the heads up John I have always done things without the pound signs. It kinda through me for a loop, aside from the fact that it just looked...
Hi all Just a quick question Would it be feasible to assume that… when coding one should double up on "ALL" the special characters when they are needed to be...
Hatton, Thanks for the response. I have the choice of tab delimited or comma delimited list. Would comma delimited be the better way to go? Thanks, Scott ... ...
Jane, This is great, it'll definitely get me started in the right direction. Thanks for the help and explanation. Certainly much more than I asked for or...
Claude, Thanks! This looks like a very good alternative to other info I've received on here. I appreciate the info. I'm sure it will all come in handy. ...
John, Thanks for the advice. The information is available as comma delimited, tab delimited or as an excel file. I believe the data is very reliable as I've...
placing the same email twice in one form example;input form name age height weight blah blah email email verification/confirmation comment send Scott...
Give each a different name and then compare them on the action page or via Javascript on submit. It's really no harder than including your age field. -John ...
I am using CFsavecontent to create a variable for overlib. The code is a little complex and difficult to maintain withouth some formatting. Apparently...
ColdFusion Hosting Providers ColdFusion Hosting Providers' List brought to you by *** ColdFusion-HowTo: Yahoo's No. 1 and the biggest group for ColdFusion...
coldfusion-howto@yaho...
Aug 2, 2005 12:45 am
34266
Try <CFSET xxx=Replace(StripCR(xxx),Chr(10),"","ALL")> This will strip out Carriage Returns and Line Feeds. Also, you do not need pounds in there. -John ... ...
Thank You John. I relied on 6.1 reference manual. Have anice day. ContiW _____ From: coldfusion-howto@yahoogroups.com [mailto:coldfusion-howto@yahoogroups.com]...
I am trying to generate a word document using coldfusion. The problem is, the data to be rendered in the document is a SQL query which returns multiple values....