RE: Order By question

2010-06-30 Thread Jon Sala
Exclude them from the query, then append them with QueryAddRow() and QuerySetCell() -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Wednesday, June 30, 2010 1:03 PM To: cf-talk Subject: Order By question Not 100% sure how to do this... Need to return a list

RE: Order By question

2010-06-30 Thread Jon Sala
disagree with this approach. Doing it in the db will be much faster. On Wed, Jun 30, 2010 at 3:06 PM, Jon Sala jon.s...@albertahealthservices.ca wrote: Exclude them from the query, then append them with QueryAddRow() and QuerySetCell() -Original Message- From: Les Mizzell [mailto:lesm

CFPDF Merge - ZLIB Error - CF8 vs CF9

2010-06-04 Thread Jon Sala
Hello all - is there a patch/JAR somewhere that addresses this? It works on CF9Dev, but not on CF8Ent I've come up empty searching. cfpdf action = merge source = #variables.mergefilelist# destination = baz.pdf Action MERGE Cause Unable to copy the stream. Detail Error: Unable to

RE: CFPDF Merge - ZLIB Error - CF8 vs CF9

2010-06-04 Thread Jon Sala
Forgot to mention - there was a reason this server was not brought to CF 8.0.1 -Original Message- From: Jon Sala Sent: Friday, June 04, 2010 1:47 PM To: cf-talk Subject: CFPDF Merge - ZLIB Error - CF8 vs CF9 Hello all - is there a patch/JAR somewhere that addresses this? It works

RE: Spreadsheet manipulation - clearing/deleting cell contents

2010-05-28 Thread Jon Sala
I may not be following you on this Leigh; if I put a long string in A1 using SpreadsheetSetCellValue and nothing in B1, A1 is still clipped...? -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Friday, May 28, 2010 2:32 AM To: cf-talk Subject: RE: Spreadsheet

RE: Spreadsheet manipulation - clearing/deleting cell contents

2010-05-28 Thread Jon Sala
So it seems the culprit is creating a spreasheet from a query with SpreadsheetAddRows(). Rows created by QueryAddRow() although empty, are not 'blank' in Excel's opinion. In this case, I needed some blank spreadsheet rows to inject long overflowing strings, inbetween the rows of source query

RE: Spreadsheet manipulation - clearing/deleting cell contents

2010-05-27 Thread Jon Sala
Yes, thanks Leigh that is great cheat to get into production with! Hopefully it doesn't break to soon if ever, -- Jon -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Wednesday, May 26, 2010 9:02 PM To: cf-talk Subject: Re: Spreadsheet manipulation -

Retrive query cell value by key/value pair instead of row number?

2010-05-26 Thread Jon Sala
Is it possible to retreive from a query in memory a cell value by a key value pair, ie other than the usual row number: myquery.columname[i]? Something like myquery.columname[myquery.keyval:thisquery.Id] For example, in a cfscript block I'm looping through a query, and under certain conditions

RE: Retrive query cell value by key/value pair instead of row number?

2010-05-26 Thread Jon Sala
write a function that takes a colname, col value and query name, and perform a qoq- assuming the function will have access to the original query... Hope that helps! On 5/26/10, Jon Sala jon.s...@albertahealthservices.ca wrote: Is it possible to retreive from a query in memory a cell value

Spreadsheet manipulation - clearing/deleting cell contents

2010-05-26 Thread Jon Sala
The spreadsheet functions appear to create empty cells that aren't really empty - could use some help on this.. The need has arisen to clear cells in certain locations to allow text in the cell to the immediate left to 'overflow'; Monkeying around with SpreadsheetSetCellValue('') etc.,

Can't capture console output from MS util

2010-04-28 Thread Jon Sala
We've got a new AD server that refuses to cooperate with CFLDAP CF8 or CF9: (Authentication failed:[LDAP: error code 49 - 80090308: LdapErr: DSID-0C090334, comment: AcceptSecurityContext error, data 525, vece ]) However, I've been wrestling with that one long enough for now; I've got to

RE: Flash on iPhone

2010-03-31 Thread Jon Sala
Ach - it's already tomorrow in Australia! From: John M Bliss [bliss.j...@gmail.com] Sent: March 31, 2010 7:43 PM To: cf-talk Subject: Flash on iPhone And heck froze over: http://www.macworld.com.au/iphone/view/apple-introduces-flash-for-iphone-4703 --

RE: ColdFusion-Builder mailing list

2010-03-22 Thread Jon Sala
Thanks Michael. My delete key has been taking a real beating. From: Michael Dinowitz [mdino...@houseoffusion.com] Sent: March 22, 2010 10:42 PM To: cf-talk Subject: ColdFusion-Builder mailing list Just a fast reminder to people that there is a ColdFusion

RE: calling a template but not waiting for it to finish running

2010-03-09 Thread Jon Sala
Yes, find it clean to set up a gateway instance and then call SendGatewayMessage() for background processing. Not sure if Matthew's Crystaltech will let him access that. -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Tuesday, March 09, 2010 12:48 PM To: cf-talk

(OT) Air for Mobile Devices

2010-02-27 Thread Jon Sala
Anyone here participating in an Air for Mobile forum somwhere they'd care to recommend? Pretty quite over at the HOF AIR list. This message and any attached documents are only for the use of the intended recipient(s), are confidential and may contain privileged information. Any unauthorized

RE: Gateway Instance In/Out

2010-02-17 Thread Jon Sala
I'm interested in that as well; might be helpful in debugging gateways that seem to retrigger spontaneously. For instance, I've set some up to reindex Verity collections when a message is sent via SendGatewayMessage(), but occasionally once started, loop indefinately. -Original

RE: Use CFLDAP to retrieve list of groups user belongs to

2010-01-28 Thread Jon Sala
Just loop through the memberOf data as a list: cfldap action=query name=qryLDAP start=DC=yourdomain,DC=ca attributes=cn,title,mail,telephonenumber,givenname,sn,department,description,memberOf,samaccountname scope=SUBTREE

RE: Why .Net is on its last legs

2010-01-22 Thread Jon Sala
Developpers re-use code so much nowadays that it takes 4 gig RAM to do about the same thing we did before in Clipper with 256k ;-)) ROTFL! Made the whole thread worthwhile. This message and any attached documents are only for the use of the intended recipient(s), are confidential and may

Requesttimeout equivalent?

2010-01-22 Thread Jon Sala
We have a CF system that harvests data from an ASPX based site, which is frequently timing out. As I have no access to the ASPX side, does anyone know if there is an equivalent to the ol' requesttimeout URL parameter? Thanks, -- Jon This message and any attached documents are only for the use

XMPP gateway cfc as a web service?

2009-12-21 Thread Jon Sala
I've got an XMPP gateway instance set up and working nicely (I use it as a debugging tool to send my IM client variable values, etc.). I'd like to call this same CFC as a web service, from a different machine - is this possible? The http://server/xmppmsg.cfc?WSDL comes back OK, but I get the