cfflush - flushing quits sometimes in middle of loop

I have a page where a query resultset of various documents to be emailed or faxed to clients is being looped over. These can take up to 10 seconds to process, so I flush the progress to the browser so the user can see that document x of y total has been sent (or has failed). Y is usually 200,

Asynchronous action inside CFC function

Hi I have a function that gets some binary data, uses that data to do a cffile action=write, and then returns the file's path as a string. I'm experiencing a problem that suggests the function is doing the return before the write action has completed. In the code below, will the function wait

problem using cfheader to create csv file from query

I'm running into a problem using cfheader, and wondering if there's a workaround. What's happening is this: I have a form page, and onSubmit of the form, a js validation function is called. This performs a number of tasks in addition to validation, and during its execution it looks at the

Get text value from xmlsearch()

Is there any way to get the 09-09-2009 string using xmlSearch() for the below xml? employee startDate09-09-2009/startDate /employee I've been doing something like this, which is a real pain: arrDate = xmlSearch(xml, //employee/startDate); strDate = arrDate[1].XmlText; It seems that

Function to decode string?

I have a string variable that I'm using dynamically in an XML document, so it's necessary to use XMLFormat() or HTMLEditFormat() to change special characters like , , and so that the XML doesn't break. However, I need to convert those back to their literals before saving to the DB, i.e., I

Re: Cfcontent MS Excel 2007 errors?

I've had the same problem, although the file will open after the user clicks yes. I Looked to see if there's a different MIME type to use for .xlsx files vs. .xls files, and there is (see http://blogs.msdn.com/vsofficedeveloper/pages/Office-2007-Open-XML-MIME-Types.aspx). But using that mime

cfcontent with excel 2007

Have seen a few posts around the web with this problem, but no evident solution. I have a cfm page that I want to make exportable to excel 2007 (.xlsx file). From what I've seen here: http://blogs.msdn.com/vsofficedeveloper/pages/Office-2007-Open-XML-MIME-Types.aspx it looks like the

Re: cftransaction

Thanks everyone - looks like the sproc is indeed committing on the backend. I do miss writing my own queries... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing

cftransaction

Hi all, I understand the gist of cftransaction, but I've tried using it with a conditional rollback on an action page in the below example and it doesn't seem to work. saveDataToDatabase() submits data to a stored procedure, which always returns a string: empty string if the data was saved, or

Re: cftransaction

Good catch - you're right; I would normally include a cfif to append the return string and the br to allReturnMessages only if the return string isn't empty. The stored proc was written by someone else, so I'm not 100% sure what's happening with it, which is part of the problem. I suppose

Re: String to List?

You've gotta love this bit of code: REreplace(arguments.strInputString,(.)(.),\1#arguments.strDelimiter#\2#ar guments.strDelimiter#,ALL) lol Oh come on, that's funny! :OD Yeah, I know. :) I haven't added regex to my knowledge repertoire yet, so I just modified the code snippet offered in

Re: String to List?

I'd be interested to know how the code I suggested performs in comparison to the regex with the 360k string - in theory it outperform it: cfset myList = ArrayToList( myString.toCharArray() ) / Running on CF8, I used cftimer to test execution time on a string 360K long (all

Re: String to List?

I just noticed that listFromChars() is essentially 1 line of code, also. My bad... Bottom line for me is to learn regex and more Java! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date

String to List?

Disclaimer - I haven't had to do any fancy string manipulation in a while... I had thought that ANY string can be treated like a list (for example, such that abcdef can be treated as a list containing six elements and a delimiter of ). Not so, I recently discovered when I tried to use

Re: String to List?

Thanks all! Good stuff all around...really must get myself locked onto regex one of these days :). I came up with this: cffunction name=stringToDelimListRE access=public returnType=string output=false hint=Takes a string argument and inserts the second argument between each character.

Recursion to retrieve blog thread - help please

I feel I should know how to do this, but I haven't really had to write a function like this yet. We have a blog site where, currently, users can post entries to their own respective blog, and replies can be made to that entry. Entries are kept in an entries table, and replies are kept in a

Re: Recursion to retrieve blog thread - help please

Thank you very much - this works beautifully! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive:

Re: Preventing cache in IE with cfheader

Instead of messing with HTTP headers, just append a random variable to the image URL: img src=image.gif?638232 / Jochem Thanks! Works perfectly. The developer I work with points out that sometimes you might want the image cached unless it has been updated, and the solution to that is

Preventing cache in IE with cfheader

I'm having trouble getting IE not to cache image files on a particular page. I have a page where image files can be uploaded and overwrite existing files (similar to a Myspace type page that displays your picture; you can upload another gif or jpg via form field, submit, and then page

Re: Preventing cache in IE with cfheader

I'm having trouble getting IE not to cache image files on a particular page. I have a page where image files can be uploaded and overwrite existing files (similar to a Myspace type page that displays your picture; you can upload another gif or jpg via form field, submit, and then page

Passing a query string as a single url variable

Trying to pass a custom query string to a template through the URL, example (assume all inside cfoutput tags): cfset qrystr=name=Janeeyes=brownhair=blondnumber=2125551234 Here is the qrystr encoded: #URLEncodedFormat(qrystr)#br a

cfhttp and tab-delimited

If I have a tab-delimited text file I want to make into a query object using cfhttp, how should I enter the value for the delimiter attribute in the cfhttp tag? The O'Reilly book demonstrates how to write it for comma-delimited: cfhttp URL=http://...file.txt; name=myquery delimiter=,

Re: cfhttp and tab-delimited

Thanks! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236080 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe:

Re: maintaining state in multipage form

It sounds like a session variable containing an array of checkboxes and their selected values might be in order. Assuming the user has cookies enabled (or if you pass the session tokens on the URLs) this should be fairly simple to implement. -Justin I'd considered using a session var, but

Re: maintaining state in multipage form

True, but then the user needs to be able to go back to any form page they've been to, uncheck boxes if they want, and have those values effectively removed from the session array... ~| Message:

Re: maintaining state in multipage form

Think I might have the solution - in the session array or list, save each element in the list as [widgetid]|[pagenumber]. Submit each page to the next, appending the session var with the checked widgets' ids, but first REMOVE all widgets from the list that have the submitting page's number.

Re: maintaining state in multipage form

The only problem with that is that the form isn't linear; in addition to to the previous page/next page links, each page has a direct link, so the user can go straight to page 56 if they don't want to have to click next page 55 times. But you're right; the bottom line is that each click needs

maintaining state in multipage form

I've taken over a web application where at one point, the user has a long list of items to choose from to be compared to one another. Each product has a checkbox next to it, and after checking off those products the user wants to see, the user submits the form and views a comparison table.

cfgraph problem

This is a troublesome problem I’m having with Cfgraph (using CF 6.1). I’m thinking that the root of the problem may be that I’m trying to create a graph that has 2 scale axes, rather than 1 scale axis and 1 item axis. In any event, I’d greatly appreciate the help of any gurus or

Trouble connection to local database

I'm trying to set up a local dev/testing environment on my PC, using CFMX 6.1 and SQL Server 2000 (both installed on my local box). I've got the correct un and pw for CF to get into the database, but each time I try to set the DSN in CF administrator, it gives me an error saying: Connection

Re: Trouble connection to local database

Forgot to add, after you do the Service Pack, get the latest updates from Macromedia especially the macromedia_drivers.zip. Sorry do not remember which HotFix it was. Thanks! Looks like DLing and installing Servce Pack 4 was all I had to do - SQL Server DSNs in CF are connecting and

Get character in string at position X?

I can do this in Javascript, but I've been through the index of my CF book and haven't found the a CF function that will return the character at position X in a given string. (I tried treating the string as a list, using the listGetAt function and specifying as the delimiter, but CF balked at

Re: Get character in string at position X?

I can do this in Javascript, but I've been through the index of my CF book and haven't found the a CF function that will return the character at position X in a given string. (I tried treating the string as a list, using the listGetAt function and specifying as the delimiter, but CF

CFMX and memory Leaks

I have ColdFusion MX and SQL Server 2000 running on the same WIN 2003 Server. We run a pretty query intensive site, and we've had problems with SQL Server memory leaks for a long time which I'd really like to clean up so we don't have to stop and restart SQL Server every 24 hours...Stopping and

cfhttp - connection refused

I have a template that accesses another local template through cfhttp: cfhttp url=http://www.mysite.com/directory/session_tracker_update.cfm; method=post cfhttpparam type=formfield name=yes value=no /cfhttp cfset get_sessions = #cfhttp.filecontent# And then displays #get_sessions#