Re: trying to shorten long string

2015-03-07 Thread Captain Obvious
Variable I is undefined. This works, cfif len(variables.description) gt 200 cfset variables.i = false cfloop condition=variables.i eq false cfset variables.description = listDeleteAt(variables.description,listLen(variables.description, .),.) cfif

Re: need a host

2014-11-20 Thread Captain Obvious
Same here, no complaints with Hostek service or support at all. On Nov 20, 2014 9:39 AM, Rick Faircloth r...@whitestonemedia.com wrote: I've always gotten quick, personal attention to any issues that may arise. On 11/19/2014 9:27 PM, Rick Eidson wrote: I posted about this last week...

Re: Anyone have experience running CyberSource Secure Acceptance

2014-09-16 Thread Captain Obvious
http://www.bennadel.com/blog/2412-crypto-cfc-for-hmac-sha1-hmac-sha256-and-hmac-md5-code-generation-in-coldfusion.htm ~| Order the Adobe Coldfusion Anthology now!

Re: Package routing and maps

2014-07-25 Thread Captain Obvious
Just use the google maps javascript api. No cf or java required. As with the cf UI tags, skip the cfmap tags - after ten minutes with the js api you won't need them. On Fri, Jul 25, 2014 at 8:20 PM, Eric Roberts ow...@threeravensconsulting.com wrote: Google has the best integration with CF as

Re: Run or spawn a desktop program

2014-05-02 Thread Captain Obvious
No. Thank God ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358540

Re: Creating Grayscale PDF with CFDocument in CF8?

2014-01-31 Thread Captain Obvious
Perhaps a print stylesheet? On Fri, Jan 31, 2014 at 12:57 PM, Dave Hatz daveh...@hatzventures.org wrote: Anyone know how to create a PDF document in grayscale? We have a web page that we give the user the ability to create a PDF of the page. The client doesn't want any of the color that

Re: ColdFusion Make Lead Story in Information Week

2013-11-08 Thread Captain Obvious
meh - Not really specific to CF. The first comment in the original blog post summed it up well enough - lack of due diligence by sysadmins. ~| Order the Adobe Coldfusion Anthology now!

Re: CF10 dump bug

2013-09-11 Thread Captain Obvious
For me it works as you expect if I alter the regex by adding a question mark like this [[:space:]]{2,}? See Lazy Quantifier: http://msdn.microsoft.com/en-us/library/3206d374.aspx On Wed, Sep 11, 2013 at 12:02 PM, Nando d.na...@gmail.com wrote: Ray, Thanks again for your suggestion to try

Re: Syntax is driving me nuts!

2013-08-20 Thread Captain Obvious
IsDefined(form.rel_#ar#) On Tue, Aug 20, 2013 at 11:55 AM, Raymond Camden raymondcam...@gmail.comwrote: Use structKeyExists. cfif structKeyExists(form, qty_#upd#) On Tue, Aug 20, 2013 at 10:48 AM, Rick Sanders r...@webenergy.ca wrote: Hey guys, I'm trying to add multiple items

Re: Short Question? CFOUTPUT converting quot; to

2013-04-30 Thread Captain Obvious
If you view source for the cfoutput block you will find quot;mystringquot; Looks like your html doc, not cfohtput, is rendering the entity code as expected. ~| Order the Adobe Coldfusion Anthology now!

Re: Case Sensitive QofQ and Operators

2013-04-09 Thread Captain Obvious
Use the UPPER operator native to your SQL dialect or set a cf var to the desired value and then use that var to construct your query. On Apr 9, 2013 11:45 AM, Brian Thornton br...@cfdeveloper.com wrote: If you have a solution that would be great, and an explanation would be even better...

Re: cfm files bypass permissions -- htm files get 401 unauthorized

2012-10-26 Thread Captain Obvious
Chris - glad it worked out (this is jt) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Getting data from MS Access and importing into SQL.

2012-08-13 Thread Captain Obvious
Maybe this: - have end-users upload entire MDB. - in uploaded MDBs insert links to SQL Server tables. - execute a set of Insert queries to copy data from MDB tables to SQL Server tables. ~| Order the Adobe Coldfusion

Re: Getting data from MS Access and importing into SQL.

2012-08-13 Thread Captain Obvious
If end users have connectivity to the sql server, yes (no special interface required though). On Mon, Aug 13, 2012 at 1:15 PM, Russ Michaels r...@michaels.me.uk wrote: it is possible to add a custom interface for msaccess that links it to sql server, so users can do this directly. I don;t

Re: I doubt anyone can help me with this, but...

2012-02-22 Thread Captain Obvious
Just charge for the labor accordingly... Have managed to talk clients out of all sorts of outlandish impulses by bringing up the costs ($ or time or both). Questions that start with Can we [some technical thing]? can usually be answered Yes, given [required resources]. The more interesting

Re: Escaping #

2012-01-22 Thread Captain Obvious
/* note: your cfparam needs form.namefirst not just namefirst */ cfoutput cfloop index = i from = 1 to = 50 cfparam name= form.namefirst#i# default= /cfloop cfloop index=i from=1 to=50 input type=text class=txt name=namefirst#i#

Re: KCfinder with CKeditor and Coldfusion?

2011-12-08 Thread Captain Obvious
CKfinder and CKeditor and Coldfusion? Yes. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

RE: SOT: Mobile Web App Dev Problem

2011-12-06 Thread Captain Obvious
FWIW - could not reproduce the problem on my Transformer, using Browser. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: SOT: Mobile Web App Dev Problem

2011-12-05 Thread Captain Obvious
500 error : Table 'holtzmanrentals.rentalmainphotos' doesn't exist ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: arraydeleteat display issue

2011-10-12 Thread Captain Obvious
ArrayDeleteAt returns true\false based on the success of the operation. Both your samples create the impression you want to display that value. Try this, cfif (ArrayLen(session.order_array) gt 6) cfset ArrayDeleteAt(session.order_array,7) /cfif

Re: cf9 multiple sheet excel

2011-08-01 Thread Captain Obvious
Me too. Have you figured a way to avoid Excel 2010 from producing the message below when opening files generated in this manner? The file you are trying to open is in a different format than specified by the extension... On Mon, Aug 1, 2011 at 1:07 PM, Bill Franklin

RE: cf9 multiple sheet excel

2011-08-01 Thread Captain Obvious
Ah, thanks Leigh. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346435

RE: cf9 multiple sheet excel

2011-08-01 Thread Captain Obvious
Tried that (specifying XML in filenme attribute of cfheader tag) but Excel 2010 appends .xls to the filename, which then results in the extension prompt. No such problem prior to MS-Office 2007. But thanks Bill, appreciate the input.