Re: cleaning up a word file
Copy pasting into what? If it is just a doc displayed in word into a text area, you don't need to do anything -- you are copying the text only, not the formatting info. HTH Dick On Jun 21, 2004, at 10:42 PM, Dave Lyons wrote: i have a user that will be using a mac and copying pasting code from word files, any good tags to make sure that code is cleaned up good? I remember seeing something somewhere but cant remember where ty! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cflocation fails
You should also have a peek at the headers sent back and forth, to diagnose if it is a client or server problem. cflocation sends a 302 http status code and a new url. -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Kevin Roche [mailto:[EMAIL PROTECTED] | Sent: Monday, June 21, 2004 16:45 | To: CF-Talk | Subject: RE: cflocation fails | | The problem has been reported on two different machines. | | Although there is conditional logic the required location | including URL variables is definitely shown in the address box. | | I am begining to think there is a response time problem on the server. | | Kevin |-Original Message- |From: James Smith [mailto:[EMAIL PROTECTED] |Sent: 21 June 2004 13:24 |To: CF-Talk |Subject: RE: cflocation fails | | |I wouldn't have thought so because the correct URL is in | the browser window, |if conditional logic was stopping the cflocation being | executed then there |would be no way for the browser to have the URL.I would | suspect the |browser is not handling the relocation properly, are you | able to test it |from a different machine? | | is it possible that there is conditional logic around the | relocation and the conditional test fails the first time that | page loads? | | Hi, | | I have a strange situation which I can't track down. | | I have an application that I have been using | successfully for some | time running on CFMX 6.1 | | Recently the application has been giving problems because the | cflocation tags are not working sometimes. | | The characteristics are that the browser shows the | redirected URL at | the address bar and the content (Usually nothing or | debug info) for | the page that issues the cflocation. | | If you position the cursor in the address bar and hit | enter you do | then go to the correct page. | | Anyone seen this before? | | Anyone know what could possibly cause it? | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: JRUN and ColdFusion MX
Troy Don't forget, there are a number of books online at livedocs http://livedocs.macromedia.com/jrun/4/index.html The getting started one is a good introduction if you're not familiar J2EE application servers KOla -Original Message- From: Troy Simpson [mailto:[EMAIL PROTECTED] Sent: 21 June 2004 22:29 To: CF-Talk Subject: JRUN and ColdFusion MX All, Is there another list for JRUN or would this be the list for JRUN? Does anyone have a recommendation for a book on JRUN so that I can get up and running soon as possible. Thanks, Troy -- Troy Simpson Applications Analyst/Programmer, OCPDBA, MCSE, SCSA North Carolina State University Libraries Campus Box 7111 | Raleigh | North Carolina ph.919.515.3855 | fax.919.513.3330 E-mail: [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cleaning up a word file
Dave This may be of some help http://www.cflib.org/udf.cfm?ID=319 Reformats special chars typically found when copying and pasting from Word. HTH KOla -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED] Sent: 22 June 2004 06:43 To: CF-Talk Subject: cleaning up a word file i have a user that will be using a mac and copying pasting code from word files, any good tags to make sure that code is cleaned up good? I remember seeing something somewhere but cant remember where ty! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cleaning up a word file
FGS! Let The Hobbit Happen!!! _ From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: Tuesday, 22 June 2004 6:35 PM To: CF-Talk Subject: RE: cleaning up a word file Dave This may be of some help http://www.cflib.org/udf.cfm?ID=319 Reformats special chars typically found when copying and pasting from Word. HTH KOla -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED] Sent: 22 June 2004 06:43 To: CF-Talk Subject: cleaning up a word file i have a user that will be using a mac and copying pasting code from word files, any good tags to make sure that code is cleaned up good? I remember seeing something somewhere but cant remember where ty! _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cleaning up a word file
textarea field -- Original Message -- From: Dick Applebaum [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 22 Jun 2004 00:26:28 -0700 Copy pasting into what? If it is just a doc displayed in word into a text area, you don't need to do anything -- you are copying the text only, not the formatting info. HTH Dick On Jun 21, 2004, at 10:42 PM, Dave Lyons wrote: i have a user that will be using a mac and copying pasting code from word files, any good tags to make sure that code is cleaned up good? I remember seeing something somewhere but cant remember where ty! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cleaning up a word file
i saw that but it looks like it doesnt do all the charachters, the ones im more interested in are the damn boxes, maybe the same though. maybe just need a regex to strip all but letters and #'s hint hint mr doom! haha -- Original Message -- From: Kola Oyedeji [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 22 Jun 2004 09:34:59 +0100 Dave This may be of some help http://www.cflib.org/udf.cfm?ID=319 Reformats special chars typically found when copying and pasting from Word. HTH KOla -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED] Sent: 22 June 2004 06:43 To: CF-Talk Subject: cleaning up a word file i have a user that will be using a mac and copying pasting code from word files, any good tags to make sure that code is cleaned up good? I remember seeing something somewhere but cant remember where ty! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cleaning up a word file
u ok this am peter? ;) -- Original Message -- From: Peter Tilbrook [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Tue, 22 Jun 2004 19:06:41 +1000 FGS! Let The Hobbit Happen!!! _ From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: Tuesday, 22 June 2004 6:35 PM To: CF-Talk Subject: RE: cleaning up a word file Dave This may be of some help http://www.cflib.org/udf.cfm?ID=319 Reformats special chars typically found when copying and pasting from Word. HTH KOla -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED] Sent: 22 June 2004 06:43 To: CF-Talk Subject: cleaning up a word file i have a user that will be using a mac and copying pasting code from word files, any good tags to make sure that code is cleaned up good? I remember seeing something somewhere but cant remember where ty! _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cleaning up a word file
MX only!!! REReplace(str,[^[:print:]\t\r\n],,all) It also replaces some characters that are usually printable like paragraph sign or copyright. Maybe use the udf from a previous mail to convert smart quotes first. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: dinsdag 22 juni 2004 11:23 To: CF-Talk Subject: RE: cleaning up a word file i saw that but it looks like it doesnt do all the charachters, the ones im more interested in are the damn boxes, maybe the same though. maybe just need a regex to strip all but letters and #'s hint hint mr doom! haha [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cleaning up a word file
What about cleaning word html when someone copy/paste from a word file to an Iframe? Is there something to clean that code? Thanks Pat _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: June 22, 2004 06:02 To: CF-Talk Subject: RE: cleaning up a word file MX only!!! REReplace(str,[^[:print:]\t\r\n],,all) It also replaces some characters that are usually printable like paragraph sign or copyright. Maybe use the udf from a previous mail to convert smart quotes first. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: dinsdag 22 juni 2004 11:23 To: CF-Talk Subject: RE: cleaning up a word file i saw that but it looks like it doesnt do all the charachters, the ones im more interested in are the damn boxes, maybe the same though. maybe just need a regex to strip all but letters and #'s hint hint mr doom! haha _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cleaning up a word file
What do you mean? Remove html or just clean up word html? -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: dinsdag 22 juni 2004 12:38 To: CF-Talk Subject: RE: cleaning up a word file What about cleaning word html when someone copy/paste from a word file to an Iframe? Is there something to clean that code? Thanks Pat _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: June 22, 2004 06:02 To: CF-Talk Subject: RE: cleaning up a word file MX only!!! REReplace(str,[^[:print:]\t\r\n],,all) It also replaces some characters that are usually printable like paragraph sign or copyright. Maybe use the udf from a previous mail to convert smart quotes first. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: dinsdag 22 juni 2004 11:23 To: CF-Talk Subject: RE: cleaning up a word file i saw that but it looks like it doesnt do all the charachters, the ones im more interested in are the damn boxes, maybe the same though. maybe just need a regex to strip all but letters and #'s hint hint mr doom! haha _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cleaning up a word file
CFDEV wrote: What about cleaning word html when someone copy/paste from a word file to an Iframe? Is there something to clean that code? You need Taz's patented MSClean tag. There is a URL, but I forget it and Taz isn't aroundIf you email me offline I'll send you a copy... Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF and Eclipse
On Friday 18 Jun 2004 18:34 pm, Guy Rish wrote: Just as a point of reference, RichPalette is currently planning to release Cheers for that. Any news on a beta for people nit lucky enough to be able to go to CFFUNthis weekend ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Dreamweaver seeing database
No, Dreamweavers sees none of the datasources. (snippets, etc.)What does IIRC mean? IIRC = If I Remember Correctly ;) In order for Dreamweaver to connect to your localhost CF server (to see the datasources, etc) you need to use the Site functionality. When setting this up you have to point the Testing Server to your local box (assuming that is where you're running CF).It will then check for access and ask for the RDS password. It's a tad different than the way Studio did things - with Studio you were always plugged in to the server if you made a connection, with Dreamweaver it only enables the functionality if you're working on a site that needs it. Hope this helps! Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Unresponsive requests - very strange
Enable query tracing (ODBC Control Panel) and get a log of the actual query being send to the database. Then scrutinize that for issues in the date pattern: 04/30/04 vs 05/01/04 vs 04/05/01 etc. Jochem Thanks for the tip. I'll give it a shot. Since my first message I have split out the five queries that get run in the request and I have isolated the problem query. I manually change the date in the SQL and I can watch it choke on some dates but not others in production while in development and integration (but pointing to production data) all dates work fine . . . interesting problem . . . George [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
caching problems again...
From what I've seen with coldfusion MX so far is its caching is garbage, I have caching turned off everywhere I can find the options to, however the following still happens. 1.I can physically delete a template from the server, but a user can still access it via the web. 2.I fix a typo in some code, save it, and the typo is still there. 3.To work around #2 I've tried renaming the template, deleting it, and uploading the current one with the old name just to get a 404 error even though the file exists.. What confuses me is this doesnt always happen..And when it does happen, it usually fixes itself in anywhere from 10 to 15 minutes.. Does anyone know of how else I can completely disable caching?I heard there was a registry key that needed to be changed.. -mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CSV HELL
Hi all: I'm writing a little function that parses a CSV file into a query (I know this has been done before, but I need it to specifically handle Excel csv exports). Here's the snag: Whenever Excel sees a comma or a quote in one of the cells, it wraps it in quotes. If it doesn't find either, it doesn't. So for example, here's a row: This is red, This is sorta red, This is blue, really Now, the above is 3 columns in Excel. The 2nd column has quotes around 'red' so Excel wraps the whole thing in quotes and escapes the quotes around the word red by doubling them. This is relatively easy to handle. The doosy is the third column. Excel found a comma so it wrapped it in quotes (which is fine). The problem is, listgetat and other list functions are pretty useless to me because it thinks a fourth column exists (containing: really). I'm guessing I can probably go down some sort of regular _expression_ hell to do this, but is there an easier way? Thanks, Rich [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF and Eclipse
Matt Said there will be a public Beta after CFFUN. Cheers _ Mr Kev McCabe Senior ETV Developer, Application Development Team Interactive Technology Development British Sky Broadcasting First Floor North East, West Cross House Isleworth Middlesex TW7 5QD Tel: +44 (0) 20 7941 5329 Fax: +44 (0) 20 7941 5243 _ -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 22 June 2004 12:06 To: CF-Talk Subject: Re: CF and Eclipse On Friday 18 Jun 2004 18:34 pm, Guy Rish wrote: Just as a point of reference, RichPalette is currently planning to release Cheers for that. Any news on a beta for people nit lucky enough to be able to go to CFFUN this weekend ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: caching problems again...
With regards to point 1, delete the class files from CFusionInstallRoot\wwwroot\WEB-INF\cfclasses or if you are using 6.1 you should be able to stop it from creating the class files in the cacheing page Save Class Files HTH - Original Message - From: techmike [EMAIL PROTECTED] Date: Tue, 22 Jun 2004 08:14:06 -0400 Subject: caching problems again... To: CF-Talk [EMAIL PROTECTED] >From what I've seen with coldfusion MX so far is its caching is garbage, I have caching turned off everywhere I can find the options to, however the following still happens. 1.I can physically delete a template from the server, but a user can still access it via the web. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CSV HELL
Can you have the CSV created using the pipe ( | ) or double pipes as the separator instead of the comma?Then just define the pipe symbol as the delimiter for listGetAt(). HTH -Original Message- From: Rich Ziade [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 8:15 AM To: CF-Talk Subject: CSV HELL Hi all: I'm writing a little function that parses a CSV file into a query (I know this has been done before, but I need it to specifically handle Excel csv exports). Here's the snag: Whenever Excel sees a comma or a quote in one of the cells, it wraps it in quotes. If it doesn't find either, it doesn't. So for example, here's a row: This is red, This is sorta red, This is blue, really Now, the above is 3 columns in Excel. The 2nd column has quotes around 'red' so Excel wraps the whole thing in quotes and escapes the quotes around the word red by doubling them. This is relatively easy to handle. The doosy is the third column. Excel found a comma so it wrapped it in quotes (which is fine). The problem is, listgetat and other list functions are pretty useless to me because it thinks a fourth column exists (containing: really). I'm guessing I can probably go down some sort of regular _expression_ hell to do this, but is there an easier way? Thanks, Rich _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cleaning up a word file
Remove the non necessary html/css tag that word html create... Thanks Pat _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: June 22, 2004 06:59 To: CF-Talk Subject: RE: cleaning up a word file What do you mean? Remove html or just clean up word html? -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: dinsdag 22 juni 2004 12:38 To: CF-Talk Subject: RE: cleaning up a word file What about cleaning word html when someone copy/paste from a word file to an Iframe? Is there something to clean that code? Thanks Pat _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: June 22, 2004 06:02 To: CF-Talk Subject: RE: cleaning up a word file MX only!!! REReplace(str,[^[:print:]\t\r\n],,all) It also replaces some characters that are usually printable like paragraph sign or copyright. Maybe use the udf from a previous mail to convert smart quotes first. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: dinsdag 22 juni 2004 11:23 To: CF-Talk Subject: RE: cleaning up a word file i saw that but it looks like it doesnt do all the charachters, the ones im more interested in are the damn boxes, maybe the same though. maybe just need a regex to strip all but letters and #'s hint hint mr doom! haha _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cleaning up a word file
Remove the non necessary html/css tag that word html create... I wrote an online editor with a limited set of features that does quite a decent job removing Word's garbage from HTML. You can get the custom tag here: http://www.cfmentor.com/code/index.cfm?action=""> The website is in italian, but code and instructions are in english. It's free, so it may be wort a try :-) I started working on a newer, improved version, but it's not going to be available anytime soon... Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF and Eclipse
There will be no beta released before the conference. And official beta program will be launched shortly after the conference (where the preview beta is being released).We will be happy to make an announcement to this list. rish -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 6:06 AM To: CF-Talk Subject: Re: CF and Eclipse On Friday 18 Jun 2004 18:34 pm, Guy Rish wrote: Just as a point of reference, RichPalette is currently planning to release Cheers for that. Any news on a beta for people nit lucky enough to be able to go to CFFUN this weekend ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CSV HELL
This is the regexp hell. There is no error handling for wrong csv. It
also doesn't handle CR/LF in a quoted value. It's MX, but with some
minor modifications it should work on CF5. But hey, I only had 20' to
write it.
I think you can use cfhttp to do it too.
Pascal
cfsavecontent variable=str
a,b,c
This is red, This is sorta red, This is blue, really
1,2,3
/cfsavecontent
cfscript
function CsvToQuery(str){
var columnlist = ;
var line = ;
var i = 1;
var j = 0;
var startrow = 1;
var start = 1;
var val = ;
var stTmp = StructNew();
var qReturn = ;
// if the columnlist isn't specified, use the first line in the
csv as columnlist
if(ArrayLen(arguments) GT 1){
columnlist = arguments[2];
}
else{
columnlist = ListFirst(str,chr(13)chr(10));
startrow = 2;
}
qReturn = QueryNew(columnlist);
for(i=startrow;i LE ListLen(str,chr(13)chr(10));i=i+1){
line = ListGetAt(str,i,chr(13)chr(10));
j = 0;
QueryAddRow(qReturn);
start = 1;
while(true){
stTmp = REFind(([^,]*|[
\t]*(?:|[^])*[ \t]*)(,|$),line,start,true);
if(stTmp.pos[1]){
j=j+1;
if(stTmp.len[2]){
val =
Mid(line,stTmp.pos[2],stTmp.len[2]);
if(REFind(^[
\t]*((|[^])*)[ \t]*$,val)){
val = REReplace(val,^[
\t]*((|[^])*)[ \t]*$,\1);
val =
Replace(val,,,all);
}
}
else val = ;
QuerySetCell(qReturn,ListGetAt(columnlist,j),val);
start = stTmp.pos[1]+stTmp.len[1];
}
else break;
}
}
return qReturn;
}
/cfscript
cfdump var=#CsvToQuery(str)#
cfdump var=#CsvToQuery(str,'x,y,z')#
-Original Message-
From: Rich Ziade [mailto:[EMAIL PROTECTED]
Sent: dinsdag 22 juni 2004 14:15
To: CF-Talk
Subject: CSV HELL
I'm guessing I can probably go down some sort of regular
_expression_ hell to do this, but is there an easier way?
Thanks,
Rich
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: ColdFusion Blogging Tool
By the way, is there a cf-based (or otherwise) blog that can be installed for multiple users on the same server. I know Ray's blog can be used for this, but then it would mean about a hundred datasources. Anything database-driven? George, Movable Type, WordPress 1.2, probably TextPattern, and so on. *Most* blogapps support multiple authors/blogs at this point. Do you need to be self-hosted? If not, drop me a line... a dedicated JournURL community can host as many authors and individual/group blogs as you need. -- Roger Benningfield work: http://journurl.com/ blog: http://admin.support.journurl.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: JRUN and ColdFusion MX
I am looking more for the administration side of managing a JRun4 Server. Troy Dave Watts wrote: Is there another list for JRUN or would this be the list for JRUN? There is a separate JRun list hosted by houseoffusion.com. Does anyone have a recommendation for a book on JRUN so that I can get up and running soon as possible. To the best of my knowledge, there are no books specifically about the latest version of JRun. In general, writing applications for JRun doesn't seem to be much different than writing them for any other J2EE application server, so if that's what you're looking for you might just pick up a book on that general topic. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Patch Error - CF Won't Start
My mom always told me to follow directions, but of course I never listened, and now it's biting me in the butt.I was applying this patch to one of our servers this morning: http://www.macromedia.com/devnet/security/security_zone/mpsb03-06.html Unfortunately rather than do things in the prescribed order, I stopped CF, updated the crimson.jar file, restarted CF, made the JVM setting changes, and then attempted to restart CF but CF won't start.I rebooted the server and still no luck.I still had the old crimson.jar file on another server so I replaced it on this server, but CF still won't start. Is there a way to get rid of the JVM settings I added without having CF running (meaning I can't get to the administrator)?I just didn't know if that stuff was stored in a config or xml file of some sort that could be edited directly.If not I can reinstall CF but I'd like to avoid that if possible. Thanks, Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cleaning up a word file
FCKEditor seems to do a really good job of cleaning this up.It uses a series of regexes, although they are run in _javascript_.Shouldn't be too tough to convert. Download FCKEditor 1.6 from sourceforge, look in the /js/ folder for fck_actions.js.They're grouped together in their own commented function. -- --Matt Robertson-- MSB Designs, Inc. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX on Windows Server 2003
Are there any gotchas related to running CFMX on WS '03? For second time already we lost access to the CFMX Administrator, I amm getting a CF error that the path is not found. Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Patch Error - CF Won't Start
Your jvm.config file should be located under in a bin/ folder of your CFMX installation root. you can edit it and remove the changes you made and then attempt to restart CFMX that way. BTW are you running CFMX as a standalone or as a JRUN instance? Cheers G On Tue, 22 Jun 2004 09:43:21 -0400, Matt Woodward [EMAIL PROTECTED] wrote: My mom always told me to follow directions, but of course I never listened, and now it's biting me in the butt.I was applying this patch to one of our servers this morning: http://www.macromedia.com/devnet/security/security_zone/mpsb03-06.html Unfortunately rather than do things in the prescribed order, I stopped CF, updated the crimson.jar file, restarted CF, made the JVM setting changes, and then attempted to restart CF but CF won't start.I rebooted the server and still no luck.I still had the old crimson.jar file on another server so I replaced it on this server, but CF still won't start. Is there a way to get rid of the JVM settings I added without having CF running (meaning I can't get to the administrator)?I just didn't know if that stuff was stored in a config or xml file of some sort that could be edited directly.If not I can reinstall CF but I'd like to avoid that if possible. Thanks, Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Patch Error - CF Won't Start
Weird--I don't see a jvm.config file in my install root/bin.This is CFMX 6.1 standalone (not JRun instance).I'll poke around and see if I can find that file in any other CFMX directory. Thanks, Matt Your jvm.config file should be located under in a bin/ folder of your CFMX installation root. you can edit it and remove the changes you made and then attempt to restart CFMX that way. BTW are you running CFMX as a standalone or as a JRUN instance? Cheers G [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Patch Error - CF Won't Start
Found one in CFusionMX/runtime/bin.Replaced the updated file with the .bak file and that did the trick.Thanks! Matt Weird--I don't see a jvm.config file in my install root/bin.This is CFMX 6.1 standalone (not JRun instance).I'll poke around and see if I can find that file in any other CFMX directory. Thanks, Matt Your jvm.config file should be located under in a bin/ folder of your CFMX installation root. you can edit it and remove the changes you made and then attempt to restart CFMX that way. BTW are you running CFMX as a standalone or as a JRUN instance? Cheers G [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
how to change IP cfmail uses when sending?
I'm sending email to my subscription list from my office computer using CFMX. If using cfmail, it says something like from name ([127.0.0.1]) by etc, whereas if sent by Outlook it says from [my dsl ip] by etc. Why is that? I'm thinking that the 127.0.0.1 ip won't be appreciated much by spam filters. Has anyone found that to be the case? And, if so, anyway that that can be worked around with cf? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
DES Encryption Decryption w/ CFML?
I need to encrypt and decrypt with CF in order to be able to work with someone else's system. What's the best tool for DES encryption in in CF?? I'm using CFMX, by the way. Thanks, Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cleaning up a word file
On Tue, 22 Jun 2004 00:26:28 -0700, Dick Applebaum [EMAIL PROTECTED] wrote: Copy pasting into what? If it is just a doc displayed in word into a text area, you don't need to do anything -- you are copying the text only, not the formatting info. This is not true, as I've run into this problem first-hand in a couple of data entry tool projects I have worked on. MS quotes, apostrophes, emdashes, etc., all paste as they are formatted in MS Word into textareas, at least in IE 6 on Windows. Unfortunately, when this gets saved to the database (in our case, Oracle using cfqueryparam), these special characters are saved as boxes, which is a pain in the butt. To get around this problem, I use a great UDF (that was also just updated a few days ago to improve its scrubbing range) in the cfquerparam calls to clean up these sorts of characters: http://www.cflib.org/udf.cfm/demoronize Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: JRUN and ColdFusion MX
I think you are just left with the documentation then. Although admin on JRUN is not much more complicated than CF Admin. It's all pretty self-explanitory. -Adam - Original Message - From: Troy Simpson [EMAIL PROTECTED] Date: Tue, 22 Jun 2004 09:32:36 -0400 Subject: Re: JRUN and ColdFusion MX To: CF-Talk [EMAIL PROTECTED] I am looking more for the administration side of managing a JRun4 Server. Troy Dave Watts wrote: Is there another list for JRUN or would this be the list for JRUN? There is a separate JRun list hosted by houseoffusion.com. Does anyone have a recommendation for a book on JRUN so that I can get up and running soon as possible. To the best of my knowledge, there are no books specifically about the latest version of JRun. In general, writing applications for JRun doesn't seem to be much different than writing them for any other J2EE application server, so if that's what you're looking for you might just pick up a book on that general topic. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: how to change IP cfmail uses when sending?
stylo stylo wrote: I'm sending email to my subscription list from my office computer using CFMX. If using cfmail, it says something like from name ([127.0.0.1]) by etc, whereas if sent by Outlook it says from [my dsl ip] by etc. Why is that? IF the mail is received by the mail server from the localhost, that's the IP Address of localhohst.Your outlook is probably running on your desktop, which is presumably NOT the mail server, and so it records the remote IP of your desktoip. I'm thinking that the 127.0.0.1 ip won't be appreciated much by spam filters. Has anyone found that to be the case? And, if so, anyway that that can be worked around with cf? Since the mail headers contain the actual IP address of your mail server when the message is received by another mail server, it shouldn't be a problem.. I've never noticed any such problems with outbound CF mail.I just verified that my cf server sends mail that includes a Received from localhost line. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DES Encryption Decryption w/ CFML?
What are you trying to encrypt? Source code? Data transmission? URL variables? -Adam - Original Message - From: Jon Block [EMAIL PROTECTED] Date: Tue, 22 Jun 2004 10:02:18 -0400 Subject: DES Encryption Decryption w/ CFML? To: CF-Talk [EMAIL PROTECTED] I need to encrypt and decrypt with CF in order to be able to work with someone else's system. What's the best tool for DES encryption in in CF?? I'm using CFMX, by the way. Thanks, Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Patch Error - CF Won't Start
Problem now is that apparently this server is unpatchable.I fixed the jvm.config file and CF starts fine WITHOUT Macromedia's new arguments in there, but with them in there, the server won't start even if I do the update in the correct order.Anyone else had this problem with this particular patch? Matt Found one in CFusionMX/runtime/bin.Replaced the updated file with the .bak file and that did the trick.Thanks! Matt Weird--I don't see a jvm.config file in my install root/bin.This is CFMX 6.1 standalone (not JRun instance).I'll poke around and see if I can find that file in any other CFMX directory. Thanks, Matt Your jvm.config file should be located under in a bin/ folder of your CFMX installation root. you can edit it and remove the changes you made and then attempt to restart CFMX that way. BTW are you running CFMX as a standalone or as a JRUN instance? Cheers G [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Patch Error - CF Won't Start
Argh--never mind.I was using the Websphere file.You'd think since this is the third server I'm patching I'd have it down by now! ;-) Thanks again for pointing out the jvm.config file, that at least helped me avoid a reinstall! Matt Problem now is that apparently this server is unpatchable.I fixed the jvm.config file and CF starts fine WITHOUT Macromedia's new arguments in there, but with them in there, the server won't start even if I do the update in the correct order.Anyone else had this problem with this particular patch? Matt Found one in CFusionMX/runtime/bin.Replaced the updated file with the .bak file and that did the trick.Thanks! Matt Weird--I don't see a jvm.config file in my install root/bin.This is CFMX 6.1 standalone (not JRun instance).I'll poke around and see if I can find that file in any other CFMX directory. Thanks, Matt Your jvm.config file should be located under in a bin/ folder of your CFMX installation root. you can edit it and remove the changes you made and then attempt to restart CFMX that way. BTW are you running CFMX as a standalone or as a JRUN instance? Cheers G [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: JavaScript - Return Confirm
I'm trying to use _javascript_ to issue a popup confirm before it goes to a page. I'm using the return confirm function below which I used in a onSubmit. I'm kinda new to JS. Can I use the return confirm like an alert? It doesn't stop to confirm.
Does someone have a better way? Thanks.
CFIF IsDefined(form.add.x)
Script Language = _javascript_
return confirm('Are you sure you want to RELEASE this PO?');
/script
CFLocation URL=""
/CFIF
Roberto O.
¿
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: CFMX on Windows Server 2003
Make sure you havn't added a new website that uses the same IP (All Unasigned) the default site uses. Other know problem. If you delete a Scheduled Task using the CFSchedule Tag it will only remove from the list in the admin the scheduled Task will continue to run until you restart the CF Service. This may be the reseon behind the JRUN errors on win 2003. Rick Eidson Partner CTO ArcRiver Technology, LLC ASP, PHP, PERL, Cold Fusion Hosting Kansas City http://www.arcriver.com/ Kansas City Musicians http://www.1sourceentertainment.com/ - Original Message - From: stas [EMAIL PROTECTED] Date: Tue, 22 Jun 2004 09:43:45 -0400 Subject: CFMX on Windows Server 2003 To: CF-Talk [EMAIL PROTECTED] Are there any gotchas related to running CFMX on WS '03? For second time already we lost access to the CFMX Administrator, I amm getting a CF error that the path is not found. Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: JavaScript - Return Confirm
You are mixing server side and client side here. You need to put the JS in the onsubmit of the form (and not in your action page):
form ... confirm('Are you sure you want to RELEASE this PO?');
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: dinsdag 22 juni 2004 16:15
To: CF-Talk
Subject: OT: _javascript_ - Return Confirm
I'm trying to use _javascript_ to issue a popup confirm before
it goes to a page. I'm using the return confirm function
below which I used in a onSubmit. I'm kinda new to JS. Can I
use the return confirm like an alert? It doesn't stop to confirm.
Does someone have a better way? Thanks.
CFIF IsDefined(form.add.x)
Script Language = _javascript_
return confirm('Are you sure you want to RELEASE this PO?');
/script CFLocation URL="">
/CFIF
Roberto O.
¿
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Java-CF MX 6.1 (Enterprise edition) integration
I've found it a good rule of thumb to plan on writing a wrapper cfc for any classes you are going to use. That extra layer with help when unexpected errors occur down the road. -Adam - Original Message - From: Stavros Tekes [EMAIL PROTECTED] Date: Tue, 22 Jun 2004 00:54:40 -0400 Subject: Re: Java-CF MX 6.1 (Enterprise edition) integration To: CF-Talk [EMAIL PROTECTED] Thanks Kola, I am interested in using some jar files (tag libraries) but I will also need to call some funciton stored in class files (directly from cfscript). My main concern is drawbacks that might be caused when trying to integrate java function in CF. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: DES Encryption Decryption w/ CFML?
I don't know yet ... i'm supposed to pass some data to someone else's system encrypted with DES... what DES tools can / should I use? Jon _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 10:14 AM To: CF-Talk Subject: Re: DES Encryption Decryption w/ CFML? What are you trying to encrypt? Source code? Data transmission? URL variables? -Adam - Original Message - From: Jon Block [EMAIL PROTECTED] Date: Tue, 22 Jun 2004 10:02:18 -0400 Subject: DES Encryption Decryption w/ CFML? To: CF-Talk [EMAIL PROTECTED] I need to encrypt and decrypt with CF in order to be able to work with someone else's system. What's the best tool for DES encryption in in CF?? I'm using CFMX, by the way. Thanks, Jon _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmx and CAPTCHA
Sure,I'd be happy to offer 20% off the $50 license to anyone at all though June 31st.Send me an email via the Contact Us form on alagad.com and I'll hook you up. Doug Hughes On Mon, 21 Jun 2004 13:44:43 -0400, Burns, John D [EMAIL PROTECTED] wrote: Doug, Any break on your Image Manipulation CFC for fellow CF-Talkers?Just figured I'd ask :-) John -Original Message- From: Doug Hughes [mailto:[EMAIL PROTECTED] Sent: Monday, June 21, 2004 11:57 AM To: CF-Talk Subject: Re: cfmx and CAPTCHA 1) Hi Joe! 2) I talked to Ben Forta when he came to the DC WAMMO meeting about the CFCs being replicated across clustered servers.His answer, in a nutshell was that they didn't have the time to do it.He also indicated that there was a good chance that it would be supported in the future. However, I know nothing about blackstone. Doug Hughes (Check out my ColdFusion Image Manipulation CFC at http://www.alagad.com/index.cfm/name-aic) On Fri, 18 Jun 2004 17:50:58 +0100, Kola Oyedeji [EMAIL PROTECTED] wrote: Apparently Blue dragon can but I haven't tried it ;-) KOla -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 13:43 To: CF-Talk Subject: RE: cfmx and CAPTCHA why don't CFC instances go across cluster members? I don't really know why they don't, just that they don't. I suspect that JRun has some sort of serializer to write its own session variables to strings, and that this serializer doesn't know what to do with CFC instances, but I really don't know for certain. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX on Windows Server 2003
Rick, I have no sites listening on All unassigned, but I do have a couple of sites set up with host headers assigned to the same IP. - Original Message - From: Rick Eidson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 10:26 AM Subject: Re: CFMX on Windows Server 2003 Make sure you havn't added a new website that uses the same IP (All Unasigned) the default site uses. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Cross Site Scripting
This was covered quite well in an earlier thread: http://www.listsearch.com/cf-talk.lasso?id=31210-session=listsearch_coldfusion:A3EA90500f040147C3sOm28F6DCB However, there's something I'd like clarification on. The custom tag CodeCleaner and the URLScan IIS security tool were both thrown out as options for scanning the request for invalid/malicious requests. Am I correct in that if I use URLScan to scan the incoming request I do not need to use CodeCleaner to do the same? In fact would using them both for this cause problems? I ask because from http://www.securityfocus.com/infocus/1755 it mentions under normaling the URL that one common reason for web apps to break once URLScan is implemented is it is known to break various web applications. The cause of this failure is typically because the application expects to receive encoded characters and tries to process regular characters as encoded characters. Why would one choose CodeCleaner over URLScan for scanning requests? Specifically for XSS (not its brother SQL Injection) what other measures should be taken besides URLScan? I was thinking form input validation, but wouldn't URLScan include those in it's scan once the user submits the form (even if it's a post submission)? What information in the request is not scanned by URL Scan? Since URLScan would need to be set to the weakest setting required for the application (e.g. - if some fields required the use of some special characters and others didn't URLScan would have to allow those specifical characters) I may have to do some additional checking in these types of circumstances (using CodeCleaner). However, assuming I can lockdown requests with URLScan without exceptions like these would URLScan provide the protection I need for XSS? If not, what else should I be looking at? I found the notification for the following XSS vulnerability: http://www.macromedia.com/devnet/security/security_zone/mpsb03-06.html . Does URLScan not include scans of these aspects so we need to make sure we don't use these (or scan them with CodeCleaner)? I'm working on a CF5 box with IIS5. Eventually I'll need to lock down CF MX with IIS6 at which point UrlScan won't do as much since IIS6 includes a lot (http://www.microsoft.com/technet/security/tools/urlscan.mspx?#XSLTsection123121120120) Any thoughts would be appreciated. Thanks, Bob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Problem Ampersand () in URL and File path 'Nix
I have written a little CF app that parses my iTunes library.xml file, and builds structures of the track and playlist info. When a user logs in, he sees a table of playlists and the info for the tracks in the selected playlist: Song TitleArtistDuration Much as it appears in iTunes when the user selects a tune, the trackID is sent to the program. The program retrieves the location of the track by accessing the track structure: Application.Tracks[URL.TID][Location] This returns a URL to the file in the format: file://localhost/Users/test/Music/iTunes/iTunes%20Music/ Simon%20%20Garfunkle/Unknown%20Album/Mrs.%20Robinson.mp3 The program URLDecodes this into a file path: /Users/test/Music/iTunes/iTunes Music/Simon Garfunkle/Unknown Album/Mrs. Robinson.mp3 Then the, program serves the file with: !--- Abort if we can't find the file --- cfif NOT FileExists((FilePath)) cfabort /cfif !--- this works for mp3 --- CFHEADER NAME=Content-Disposition VALUE=attachment; filename=song.mp3 cfcontent type = audio/mp3 file=#FilePath# deleteFile = No All this works fine except when there is an ampersand () in the URL/file path.Then, CF can't find the file to serve: Now, OS X allows ampersands in file names and directory names. When a song is iMported/read/dropped into iTunes, iTunes builds a directory structure based upon: ---Artist Name --Album Name (or Unknown Album) -file name in my example: ---Simon Garfunkle --Unknown Album -Mrs. Robinson.mp3 And CFFilecan't handle the ampersand in the Simon Garfunkle directory. The Mac Finder (File system GUI) has no problem with the ampersand. But, the underlying FreeBSD Unix-based Darwin requires that the ampersand (and spaces) be escaped. /Users/test/Music/iTunes/iTunes\ Music/Simon\ \ Garfunkle/Unknown\ Album/Mrs.\ Robinson.mp3 or the whole thing enclosed in quotes. How do I get CFFile FileExists to handle a file path with an ampersand? What characters should I look out for on windows-based iTunes? TIA Dick In times like these, it helps to recall that there have always been times like these. - Paul Harvey - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFML Visual Studio Plugin
Anyone know of a plugin to give CFML support in Visual Studio .NET? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: HitBox for web traffic/marketing
So Andrewdoes the CGI.HTTP_X_Forwarded_For give the IP of the computer behind a proxy server?? Thanks Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Andrew Grosset To: CF-Talk Sent: Monday, June 21, 2004 8:23 PM Subject: Re: HitBox for web traffic/marketing came across this cgi.variable the other day, not sure if this helps or not but: ColdFusion with Proxy detection: cfif CGI.HTTP_X_Forwarded_For EQ cfset ipaddress=CGI.Remote_Addr cfset a=1 cfelse cfset ipaddress=CGI.HTTP_X_Forwarded_For cfset a=2 /cfif [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: SQL Backup Events Filling Application Log
Hi All, sorry about the OT post can't find an answer on Google. We have a Maintenance Schedule that backups all of our databases. This is great, however every time it does it creates an event in the event viewer and fills up our application log. Does anyone know a way to make it not announce an event? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Chr() for a tab?
I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Writing cfoutput to a text file
I am trying to dump a query to a text file.. I tried using CFFILE but I get an error saying Object type cannot be written to file. Error attempting to write non string/binary data to file. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (91:1) to (91:114) in the template file D:\wwwroot\advantage\eCount\GenerateFileManually.cfm. Am I doing something wrong? ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Chr() for a tab?
On Tue, 22 Jun 2004 10:05:01 -0500, Phillip B [EMAIL PROTECTED] wrote: I've looked around and can't find the char() for a tab. Anyone know off hand? Chr(9) Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Chr() for a tab?
http://www.asciitable.com/ Phillip B wrote: I've looked around and can't find the char() for a tab. Anyone know off hand? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
9 i believe... -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 11:05 AM To: CF-Talk Subject: Chr() for a tab? I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
Chr(9) -- Horizontal Tab Chr(11) -- vErtical Tab -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 11:05 AM To: CF-Talk Subject: Chr() for a tab? I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
9 _ From: Phillip B [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 11:05 AM To: CF-Talk Subject: Chr() for a tab? I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Chr() for a tab? (never mind)
I got it now. Chr(9) Phillip B wrote: I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Chr() for a tab?
Phillip B wrote: I've looked around and can't find the char() for a tab. Anyone know off hand? 9 Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Chr() for a tab?
Chr(9) http://asciitable.com/ I've looked around and can't find the char() for a tab. Anyone know off hand? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
www.asciitable.com Bookmark it, it's a great reference site. Mike I've looked around and can't find the char() for a tab. Anyone know off hand? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
chr(9) is a tab. -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 9:05 AM To: CF-Talk Subject: Chr() for a tab? I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Chr() for a tab?
Chr(9) Jeff - Original Message - From: Phillip B To: CF-Talk Sent: Tuesday, June 22, 2004 8:05 AM Subject: Chr() for a tab? I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
ASCI is 9. John -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 11:05 AM To: CF-Talk Subject: Chr() for a tab? I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
chr(9) _ From: Phillip B I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFML Visual Studio Plugin
That would be rich! Paul Kenney [EMAIL PROTECTED] 916-212-4359 -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 7:56 AM To: CF-Talk Subject: CFML Visual Studio Plugin Anyone know of a plugin to give CFML support in Visual Studio .NET? This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540.It contains information which is confidential and may also be privileged.It is for the exclusive use of the intended recipient(s).If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
chr(9) - j james curran technical director nylon technology mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 212-691-1134 -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 11:05 AM To: CF-Talk Subject: Chr() for a tab? I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
Chr(9) -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: dinsdag 22 juni 2004 17:05 To: CF-Talk Subject: Chr() for a tab? I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
09 will give you a tab. Check this url for an ASCII table. http://www.motionnet.com/cgi-bin/search.exe?a=showlinkno=65 Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Phillip B [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 10:05 AM To: CF-Talk Subject: Chr() for a tab? I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Chr() for a tab?
chr(9) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Writing cfoutput to a text file
Error attempting to write non string/binary data to file. The problem is exactly what it says. You can't dump a query to a file, you need to convert it to a string. [EMAIL PROTECTED] wrote: I am trying to dump a query to a text file.. I tried using CFFILE but I get an error saying Object type cannot be written to file. Error attempting to write non string/binary data to file. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (91:1) to (91:114) in the template file D:\wwwroot\advantage\eCount\GenerateFileManually.cfm. Am I doing something wrong? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Chr() for a tab?
Is there any use for a vertical tab in CF or in web programming at all? Chr(9) -- Horizontal Tab Chr(11) -- vErtical Tab [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Writing cfoutput to a text file
Can you show a little more of your code? Phillip B. [EMAIL PROTECTED] wrote: I am trying to dump a query to a text file.. I tried using CFFILE but I get an error saying Object type cannot be written to file. Error attempting to write non string/binary data to file. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (91:1) to (91:114) in the template file D:\wwwroot\advantage\eCount\GenerateFileManually.cfm. Am I doing something wrong? http://www.houseoffusion.com/banners/view.cfm?bannerid=38 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
formatting URL params for search engine bots
Hey All, I'm looking at converting URL param formatting like so: www.domain.com/index.cfm?page=about to something like this?? www.domain.com/index.cfm/page/about I'm pretty sure Ben Forta had a way of doing thisanybody know of a UDF/CFC/custom tag? Also...any comments on how effective this change is in getting bots/spiders to index a site. TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Writing cfoutput to a text file
I gernerally use a cfsavecontent around a cfdump and write the resulting string to the text file using cffile. Tyler Clendenin GSL Solutions _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 11:09 AM To: CF-Talk Subject: Writing cfoutput to a text file I am trying to dump a query to a text file.. I tried using CFFILE but I get an error saying Object type cannot be written to file. Error attempting to write non string/binary data to file. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (91:1) to (91:114) in the template file D:\wwwroot\advantage\eCount\GenerateFileManually.cfm. Am I doing something wrong? ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Writing cfoutput to a text file
you should loop through it within the confines of a cfsavecontent tag and then take that variable that cfsavecontent creates, and dump that to the csv file. dumbed down example: cfquery name=get cfsavecontent variable=getResults cfloop query=get cfoutput #stuff1#,#stuff2# /cfoutput /cfloop /cfsavcontent cffile output=#getResults# action=""> this should paint a better picture of what you want... tw -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 11:09 AM To: CF-Talk Subject: Writing cfoutput to a text file I am trying to dump a query to a text file.. I tried using CFFILE but I get an error saying Object type cannot be written to file. Error attempting to write non string/binary data to file. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (91:1) to (91:114) in the template file D:\wwwroot\advantage\eCount\GenerateFileManually.cfm. Am I doing something wrong? ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
just cause we only had 12 answers and 13 sounds soo good today, its chr(9) :) helpful little bunch we are! -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 11:16 AM To: CF-Talk Subject: RE: Chr() for a tab? chr(9) _ From: Phillip B I've looked around and can't find the char() for a tab. Anyone know off hand? Thanks Phillip B. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: JRUN and ColdFusion MX
I don't think there are any recent books specifically on JRun, Drew Falkman wrote a book but I believe its quite dated now. Kola -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 21 June 2004 23:51 To: CF-Talk Subject: RE: JRUN and ColdFusion MX Is there another list for JRUN or would this be the list for JRUN? There is a separate JRun list hosted by houseoffusion.com. Does anyone have a recommendation for a book on JRUN so that I can get up and running soon as possible. To the best of my knowledge, there are no books specifically about the latest version of JRun. In general, writing applications for JRun doesn't seem to be much different than writing them for any other J2EE application server, so if that's what you're looking for you might just pick up a book on that general topic. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cross Site Scripting
Bob Jacoby wrote: Why would one choose CodeCleaner over URLScan for scanning requests? I would feel very jittery about giving up urlscan.Its a powerful tool.I suppose if you pass a lot of urlencoded data via the url you could eventually hit a snag.However I try to minimize what I expose over a url so this may be part of why I've never experienced a problem.As a result of the thread you mentioned I expanded my use of CodeCleaner to scrub url strings with no ill effects. wouldn't URLScan include those in it's scan once the user submits the form (even if it's a post submission)? a POST-type form variable isn't passed via the url, so I would think URLScan would miss it completely... unless there's something in URLScan that I'm unaware of that scrubs POST (non-url) form vars? Haven't read the docs on that in quite awhile. What information in the request is not scanned by URL Scan? Anything that isn't in the url, subject to the above caveat, but I'm pretty sure URLScan does exactly -- and only -- what its name implies. -- --Matt Robertson-- MSB Designs, Inc. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFCs and CFLoginUser()
My current thinking on creating logins with CFCs is that you create a CFC that passes in the Form.username and Form.password into a CFC that Queries the DB and returns a Query object containing all of your information. Once I've passed your username and password into the CFC and returned all of your info (First Name, Last Name, Preferences, ID, Role) I then use cfloginuser to log the user in. This has brought up a couple of questions. 1. Would I check the query *inside* the CFC that queries the DB for your information to make sure it's a valid Query Object? (In other words, to make sure recordcount didn't equal 2 or 0). 2. Would you place your CFLogin code *inside* the CFC? I don't get that, but someone here mentioned that you could do that. Query the DB, check the Query, and login the user, all inside the CFC. If that's the case, what would you return? I think this is all a best practices question...so any advice is appreciated. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
just cause we only had 12 answers and 13 sounds soo good today, its chr(9) :) helpful little bunch we are! Post whore you are :-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ColdFusion Blogging Tool
you could probably easily adapt Ray's to be used for multiple blogs from one datasource. FuseBlog allows multiple sites from one datasource. Does Ray's run on the latest free bluedragon? Eric _ From: George Abraham [mailto:[EMAIL PROTECTED] Sent: June 21, 2004 8:40 AM To: CF-Talk Subject: Re: ColdFusion Blogging Tool By the way, is there a cf-based (or otherwise) blog that can be installed for multiple users on the same server. I know Ray's blog can be used for this, but then it would mean about a hundred datasources. Anything database-driven? Thanks, George _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Writing cfoutput to a text file
You can't 'dump' it, but you can output it.Here's an example: cfquery name=Maker datasource=test SELECT myfile.FIELD1, myfile.FIELD2 FROM myfile WHERE 0=0 ORDER BY myfile.FIELD1 ASC /cfquery cfloop query=Maker cfset variables.DestFile=foo_ Maker.FIELD1 .txt cffile action="" output=#Maker.FIELD2# file=c:\cfusionmx\wwwroot\bar\#variables.DestFile# /cfloop -- --Matt Robertson-- MSB Designs, Inc. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: formatting URL params for search engine bots
I don't think query strings are still an issue with search engine bots. But you can look at sesConvertor on fusium.com -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: dinsdag 22 juni 2004 17:35 To: CF-Talk Subject: formatting URL params for search engine bots Hey All, I'm looking at converting URL param formatting like so: www.domain.com/index.cfm?page=about to something like this?? www.domain.com/index.cfm/page/about I'm pretty sure Ben Forta had a way of doing thisanybody know of a UDF/CFC/custom tag? Also...any comments on how effective this change is in getting bots/spiders to index a site. TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
how about asc( ) _ From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: June 21, 2004 10:14 PM To: CF-Talk Subject: Re: Chr() for a tab? Phillip B wrote: I've looked around and can't find the char() for a tab. Anyone know off hand? 9 Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: JRUN and ColdFusion MX
Also do check out Brandon Purcell's site out (http://www.bpurcell.org/) He has some pretty useful info on JRun and CFMX integration, logging information etc... G On Tue, 22 Jun 2004 16:43:53 +0100, Kola Oyedeji [EMAIL PROTECTED] wrote: I don't think there are any recent books specifically on JRun, Drew Falkman wrote a book but I believe its quite dated now. Kola -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 21 June 2004 23:51 To: CF-Talk Subject: RE: JRUN and ColdFusion MX Is there another list for JRUN or would this be the list for JRUN? There is a separate JRun list hosted by houseoffusion.com. Does anyone have a recommendation for a book on JRUN so that I can get up and running soon as possible. To the best of my knowledge, there are no books specifically about the latest version of JRun. In general, writing applications for JRun doesn't seem to be much different than writing them for any other J2EE application server, so if that's what you're looking for you might just pick up a book on that general topic. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
Occasionally used as a delimiter in strings _ From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 11:32 AM To: CF-Talk Subject: Re: Chr() for a tab? Is there any use for a vertical tab in CF or in web programming at all? Chr(9) -- Horizontal Tab Chr(11) -- vErtical Tab _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: formatting URL params for search engine bots
Ben wrote up the tag he made for this on his site.Surprisingly it looks to be gone (was a link to cfdj's site).Check them.I also have a copy of the tag he posted if you need it. --Matt Robertson-- MSB Designs, Inc. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Chr() for a tab?
On Tuesday 22 Jun 2004 16:31 pm, Michael Dinowitz wrote: Is there any use for a vertical tab in CF Outputing text files ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: formatting URL params for search engine bots
All of HoF is set up with SES (search engine safe) urls. If your using IIS I'll post up my latest script for it. Lets just say that Google have over 130,000 pages of HoF indexed and they're almost all dynamic. Hey All, I'm looking at converting URL param formatting like so: www.domain.com/index.cfm?page=about to something like this?? www.domain.com/index.cfm/page/about I'm pretty sure Ben Forta had a way of doing thisanybody know of a UDF/CFC/custom tag? Also...any comments on how effective this change is in getting bots/spiders to index a site. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Writing cfoutput to a text file
This shows the html code for the CFDUMP, I cant get this to work. -Original Message- From: Tyler Clendenin [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 10:37 AM To: CF-Talk Subject: RE: Writing cfoutput to a text file I gernerally use a cfsavecontent around a cfdump and write the resulting string to the text file using cffile. Tyler Clendenin GSL Solutions _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 11:09 AM To: CF-Talk Subject: Writing cfoutput to a text file I am trying to dump a query to a text file.. I tried using CFFILE but I get an error saying Object type cannot be written to file. Error attempting to write non string/binary data to file. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (91:1) to (91:114) in the template file D:\wwwroot\advantage\eCount\GenerateFileManually.cfm. Am I doing something wrong? ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CSV HELL
There's a really nice set of utility classes available at
http://www.ostermiller.org/utils/CSV.html that I've used with great success
for parsing CSV files.It takes care of all the nastiness with quotes in
Excel CSV files.It also has classes for handling normal CSV files.
Little more work than dropping in a UDF, but it's blazing fast.
Cheers,
barneyb
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 6:29 AM
To: CF-Talk
Subject: RE: CSV HELL
This is the regexp hell. There is no error handling for wrong csv. It
also doesn't handle CR/LF in a quoted value. It's MX, but with some
minor modifications it should work on CF5. But hey, I only had 20' to
write it.
I think you can use cfhttp to do it too.
Pascal
cfsavecontent variable=str
a,b,c
This is red, This is sorta red, This is blue, really
1,2,3
/cfsavecontent
cfscript
function CsvToQuery(str){
var columnlist = ;
var line = ;
var i = 1;
var j = 0;
var startrow = 1;
var start = 1;
var val = ;
var stTmp = StructNew();
var qReturn = ;
// if the columnlist isn't specified, use the first line in the
csv as columnlist
if(ArrayLen(arguments) GT 1){
columnlist = arguments[2];
}
else{
columnlist = ListFirst(str,chr(13)chr(10));
startrow = 2;
}
qReturn = QueryNew(columnlist);
for(i=startrow;i LE ListLen(str,chr(13)chr(10));i=i+1){
line = ListGetAt(str,i,chr(13)chr(10));
j = 0;
QueryAddRow(qReturn);
start = 1;
while(true){
stTmp = REFind(([^,]*|[
\t]*(?:|[^])*[ \t]*)(,|$),line,start,true);
if(stTmp.pos[1]){
j=j+1;
if(stTmp.len[2]){
val =
Mid(line,stTmp.pos[2],stTmp.len[2]);
if(REFind(^[
\t]*((|[^])*)[ \t]*$,val)){
val = REReplace(val,^[
\t]*((|[^])*)[ \t]*$,\1);
val =
Replace(val,,,all);
}
}
else val = ;
QuerySetCell(qReturn,ListGetAt(columnlist,j),val);
start = stTmp.pos[1]+stTmp.len[1];
}
else break;
}
}
return qReturn;
}
/cfscript
cfdump var=#CsvToQuery(str)#
cfdump var=#CsvToQuery(str,'x,y,z')#
-Original Message-
From: Rich Ziade [mailto:[EMAIL PROTECTED]
Sent: dinsdag 22 juni 2004 14:15
To: CF-Talk
Subject: CSV HELL
I'm guessing I can probably go down some sort of regular
_expression_ hell to do this, but is there an easier way?
Thanks,
Rich
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Writing cfoutput to a text file
A small word of warning / caution with this way of exporting, you may want to split the data up into blocks and write chunks to the file rather than the whole lot. We had a situation where a user was impatient, we were exporting a lot of data at the time and ending up killing the machine :( - Original Message - From: Tony Weeg [EMAIL PROTECTED] Date: Tue, 22 Jun 2004 11:35:13 -0400 Subject: RE: Writing cfoutput to a text file To: CF-Talk [EMAIL PROTECTED] you should loop through it within the confines of a cfsavecontent tag and then take that variable that cfsavecontent creates, and dump that to the csv file. dumbed down example: cfquery name=get cfsavecontent variable=getResults cfloop query=get cfoutput #stuff1#,#stuff2# /cfoutput /cfloop /cfsavcontent cffile output=#getResults# action="" Remove Footer Here--> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Writing cfoutput to a text file
Yes but I need to dump the whole query formatted just how the sql query formats it. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 10:54 AM To: CF-Talk Subject: Re: Writing cfoutput to a text file You can't 'dump' it, but you can output it.Here's an example: cfquery name=Maker datasource=test SELECT myfile.FIELD1, myfile.FIELD2 FROM myfile WHERE 0=0 ORDER BY myfile.FIELD1 ASC /cfquery cfloop query=Maker cfset variables.DestFile=foo_ Maker.FIELD1 .txt cffile action="" output=#Maker.FIELD2# file=c:\cfusionmx\wwwroot\bar\#variables.DestFile# /cfloop -- --Matt Robertson-- MSB Designs, Inc. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Chr() for a tab?
so it's chr(11)? -Original Message- From:Tangorre, Michael Date:6/22/04 11:56 am To:CF-Talk Subj:RE: Chr() for a tab? just cause we only had 12 answers and 13 sounds soo good today, its chr(9) :) helpful little bunch we are! Post whore you are :-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
UDDI Registry
Has anyone implemented or interested in implementing a private UDDI registry for your CFML webservices? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Writing cfoutput to a text file
so, loop through it, make each field, have a #queryName.column#, value in the cfsavecontent. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 12:41 PM To: CF-Talk Subject: RE: Writing cfoutput to a text file Yes but I need to dump the whole query formatted just how the sql query formats it. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 22, 2004 10:54 AM To: CF-Talk Subject: Re: Writing cfoutput to a text file You can't 'dump' it, but you can output it.Here's an example: cfquery name=Maker datasource=test SELECT myfile.FIELD1, myfile.FIELD2 FROM myfile WHERE 0=0 ORDER BY myfile.FIELD1 ASC /cfquery cfloop query=Maker cfset variables.DestFile=foo_ Maker.FIELD1 .txt cffile action="" output=#Maker.FIELD2# file=c:\cfusionmx\wwwroot\bar\#variables.DestFile# /cfloop -- --Matt Robertson-- MSB Designs, Inc. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: formatting URL params for search engine bots
Also...any comments on how effective this change is in getting bots/spiders to index a site. It's my understanding that it doesn't generally affect indexing, but may affect page rankings. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
