Re: Mac 10.7 datasource problem

2011-08-04 Thread Sean Corfield
Probably firewall related? On Wed, Aug 3, 2011 at 4:41 PM, Mike P mike...@optonline.net wrote: Since I upgraded to lion, my sql server datasource has stopped working. The error message i'm getting is: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]No more

Re: cffunction - initialize query as empty string or QueryNew

2011-08-04 Thread Raymond Camden
Woah woah woah. I want to be sure we are -very- clear here. Peter, you said, With CF9 you don't need the var keyword anymore, and if you don't need backwards compatible code it's (arguably) clearer to not use it at all. That is not true. You do need to var scope. What you don't need to do is

CFSPREADSHEET/ ZIP Code Format?

2011-08-04 Thread Steve Keator
Hi All, I've done some pretty extensive searching for this topic and haven't been able to come across it, so please forgive me if I've missed it somewhere else. Has anyone ever run into issues formatting cells containing ZIP codes for Excel using CFSPREADSHEET? I've tried several different

RE: COMPLEX SQL RANDOM: SOLVED

2011-08-04 Thread Robert Harrison
Thanks for all of your answers. I tried a few of the suggestions but they weren't quite right. Bill Franklin's answer, while not complete, made me rethink what I was doing from a different point of view. My error was that I was chaining all of the record together as though I was trying to

RE: COMPLEX SQL RANDOM

2011-08-04 Thread Bill Franklin
Yeah, for my needs, I used the following (for our Oracle backend database).. SELECT * FROM ( SELECT rownum, {various fields} FROM {some joined tables} WHERE {some criteria} ORDER BY dbms_random.value ) WHERE rownum = {however many I needed} -Original Message- From:

Re: cffunction - initialize query as empty string or QueryNew

2011-08-04 Thread Peter Boughton
Sorry, yeah, that was worded badly. I should have prefixed that with If you *always* use the local scope, you don't need var... Annoyingly I can't go back and revise the message, and for some reason it got posted twice too. :/

Re: cffunction - initialize query as empty string or QueryNew

2011-08-04 Thread Gerald Weir
Thank you Ray and Peter for your answers/clarification on this question. It's clear now and every helpful. Jerry ~| Order the Adobe Coldfusion Anthology now!

OO ColdFusion, somebody tell me if this is overkill

2011-08-04 Thread Scott Stewart
Ok, here goes.. I've got a component with a bunch of database calls, each db call function is private. The component also contains public methods that call the private methods. My thought is this.. Separate the private functions into their own component, and use the extends property to stitch

Re: OO ColdFusion, somebody tell me if this is overkill

2011-08-04 Thread Dave Watts
I've got a component with a bunch of database calls, each db call function is private. The component also contains public methods that call the private methods. My thought is this.. Separate the private functions into their own component, and use the extends property to stitch everything

Re: OO ColdFusion, somebody tell me if this is overkill

2011-08-04 Thread Tim Newton
To add to what Dave already stated, it looks like you're trying to separate data access logic from business logic and only expose direct access to your data layer privately. This is a common model where service components (these contain business logic) call Data Access Objects (DAOs - these

Re: cfsharepoint and Sharepoint 2010

2011-08-04 Thread Tim Newton
Dawn, After having struggled with authentication issues and malformed SOAP messages for the last 2 days, my guess is that SharePoint 2010 is not yet supported by the cfsharepoint tag. It appears that the java stub files generated by the Axis 1.2.1 client are not in sync with what SharePoint

Re: cfsharepoint and Sharepoint 2010

2011-08-04 Thread Steve 'Cutter' Blades
Not positive, but I think that's being addressed in the next version of ColdFusion. According to this post from Ray, the Axis update to Axis 2 is in there... http://www.coldfusionjedi.com/index.cfm/2011/3/3/ColdFusion-X-Writeup Steve 'Cutter' Blades Adobe Community Professional Adobe

Re: COMPLEX SQL RANDOM: SOLVED

2011-08-04 Thread Maureen
Is there a reason you are selecting portal_polls.answer2 and portal_polls.answer4 twice, or is that a typo? On Thu, Aug 4, 2011 at 6:13 AM, Robert Harrison rob...@austin-williams.com wrote: Thanks for all of your answers. I tried a few of the suggestions but they weren't quite right. Bill

Re: OO ColdFusion, somebody tell me if this is overkill

2011-08-04 Thread Nathan Strutz
Sounds like it's not a terrible idea. The pattern you're looking toward moving to is called the Service Pattern. It puts an interface into your Model. It's a good strategy if you are trying to reduce complexity (like number of functions in a component), split out concerns (like public versus

left, right, mid? (no political content)

2011-08-04 Thread Les Irvin
Let's say I have a number of strings as such: xx123_23 xx37465_2345 xx2_12 xx21_4374837438 xx4655_432 all have xx at the beginning and then an underscore somewhere beyond that. With such random and varied lengths, how do I return the following strings: 1) only the digits between the xx and the

Re: left, right, mid? (no political content)

2011-08-04 Thread John M Bliss
Hint: check out list functions and use delimiter=_ On Aug 4, 2011 1:05 PM, Les Irvin les.cft...@gmail.com wrote: Let's say I have a number of strings as such: xx123_23 xx37465_2345 xx2_12 xx21_4374837438 xx4655_432 all have xx at the beginning and then an underscore somewhere beyond

Re: left, right, mid? (no political content)

2011-08-04 Thread Leigh
(I am certain someone else will suggest a regex. So I will not bother ;) Try treating it as a list delimited by an underscore _ 1) only the digits between the xx and the _ ListFirst() would return the characters before the _. Then use right() or mid() to extract the characters beyond the

RE: CF 9 ODBC data source with Windows 2008 64-bit

2011-08-04 Thread Nathan Chen
Dave and All: I downloaded and installed JDBC 4.2 from DataDirect site. Now I am not sure what the strings on the CF Admin data source setup page should look like. I select Other on the driver drop-down and on the second page: should I enter these? JDBC URL:

giving users a selection of email type

2011-08-04 Thread Greg Morphis
I'm giving users a choice of email type, html or plain. Is there a way of getting around having 2 different emails, one for html content and one stripped of tags? ~| Order the Adobe Coldfusion Anthology now!

Re: CF 9 ODBC data source with Windows 2008 64-bit

2011-08-04 Thread Dave Watts
Is it possible for you to use the JDBC driver instead - either CF (DataDirect) or Oracle? I downloaded and installed JDBC 4.2 from DataDirect site. Are you using CF Enterprise or Standard? If you're using Enterprise, you don't have to download anything - it's included with CF. Dave Watts,

Re: giving users a selection of email type

2011-08-04 Thread Bryan Stevenson
Why yes there isthey are called multipart e-mailshave a look at CFMAILPART (or something to that effect). It allows you to send one e-mail with both a plain text and HTML portion.then it's up to receiver's mail client to display what the user wants to see ;-0 HTH Cheers On Thu,

Re: giving users a selection of email type

2011-08-04 Thread Steve Milburn
There are some RegEx solutions for stripping HTML tags from a string. You could have a single email containing the tags, but before you send it, check to see if the user prefers plain and if so, run it through the RegEx. Steve On Thu, Aug 4, 2011 at 3:11 PM, Greg Morphis gmorp...@gmail.com

Re: giving users a selection of email type

2011-08-04 Thread Casey Dougall
Yeah, you also need to put text before html in order for it to show HTML in Gmail if I recall cfmail cfmailparam type=text This is your plain text /cfmailparam cfmailparam type=html pThis is your html/p /cfmailparam /cfmail In order for On Thu, Aug 4, 2011 at

Re: giving users a selection of email type

2011-08-04 Thread Greg Morphis
I looked at that, I want to control the email flow. If they choose to receive text only then I want to send a text only email stripped of html.. I've looked at this http://stackoverflow.com/questions/4550583/whats-the-best-way-to-remove-html-from-a-string but I'm not sure this is the way I want

RE: CF 9 ODBC data source with Windows 2008 64-bit

2011-08-04 Thread Nathan Chen
Dave, I am using Standard. Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, August 04, 2011 1:19 PM To: cf-talk Subject: Re: CF 9 ODBC data source with Windows 2008 64-bit Is it possible for you to use the JDBC driver instead - either CF

Re: giving users a selection of email type

2011-08-04 Thread Wil Genovese
Here is what I consider a very fine blog post on how to properly use the CFMAIL and it's related tags, including a way to strip html to create nice text portions of the email. http://www.trunkful.com/index.cfm/2010/5/27/How-to-CFMAIL-Properly-and-Keep-the-SPAM-in-the-Can -yes, that was a

Re: giving users a selection of email type

2011-08-04 Thread Steve Milburn
Maybe I misunderstood the question, but this still seems to require the management of 2 blocks of texts, which I thought is what the original poster was trying to avoid. Using RegEx to strip all HTML markup, only 1 block of text needs to be maintained. Steve On Thu, Aug 4, 2011 at 3:25 PM,

Re: OO ColdFusion, somebody tell me if this is overkill

2011-08-04 Thread Dave Watts
Sounds like it's not a terrible idea. The pattern you're looking toward moving to is called the Service Pattern. It puts an interface into your Model. It's a good strategy if you are trying to reduce complexity (like number of functions in a component), split out concerns (like public versus

Re: giving users a selection of email type

2011-08-04 Thread Bryan Stevenson
Well OKI'll come in with the unpopular vote thenDON'T STRIP HTML! Here is why. I have always found that the text you are left with will NOT look nice to the person receiving it. So by doing it the way I suggested, you can customize the plain text (like all caps heading instead of a

Re: OO ColdFusion, somebody tell me if this is overkill

2011-08-04 Thread Nathan Strutz
Oh Dave, you're such a literalist and a pessimist. Since we're talking literals, having a component with nothing but private methods is usually wrong, they will likely change to package access. So there :p I disagree with what you said about reducing complexity. Reducing the number of methods

CFBuilder 2 Search

2011-08-04 Thread Justin Hansen
In CFBuilder 1, when you searched you used to be able to expand an click on the actual line # with the match on it. This is no longer the case in CFB2? WTF? I've looked around for a setting, can't find anything Any ideas? Explanations? Fixes? I got half a mind to switch back to CFB1!

RE: CFBuilder 2 Search

2011-08-04 Thread Andrew Scott
Hmm sounds like you have a serious problem, I am doing that right this minute. Regards, Andrew Scott http://www.andyscott.id.au/ -Original Message- From: Justin Hansen [mailto:jhan...@uhlig.com] Sent: Friday, 5 August 2011 6:43 AM To: cf-talk Subject: CFBuilder 2 Search In

Re: CFBuilder 2 Search

2011-08-04 Thread Wil Genovese
read this. http://orangexception.com/post/8085089387/file-search-in-coldfusion-builder-open-search-dialog It's there. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Aug 4, 2011, at 3:42 PM, Justin

Re: giving users a selection of email type

2011-08-04 Thread Jochem van Dieten
On Thu, Aug 4, 2011 at 10:11 PM, Bryan Stevenson wrote: Well OKI'll come in with the unpopular vote thenDON'T STRIP HTML! I have always found that the text you are left with will NOT look nice to the person receiving it. As always that depends on the quality of the input. If you

Re: giving users a selection of email type

2011-08-04 Thread Bryan Stevenson
Let's agree to disagree Jochempretty OK is not in my vocabulary.but striving for perfection is ;-) An automated process cannot make the types of changes (which are human judgement calls) I mentioned. No process can say hey that doesn't look right and I think I'll make it all caps for

Re: CFBuilder 2 Search

2011-08-04 Thread AJ Mercer
in the search dialog you will see three tabs. I think the default on is JAVA, and you want one of the others. Once you have found the one you want, there is a customise button on the search dialog and you can turn the other 2 off. On 5 August 2011 04:42, Justin Hansen jhan...@uhlig.com wrote:

RE: COMPLEX SQL RANDOM: SOLVED

2011-08-04 Thread Robert Harrison
That was a typo. I fixed that as soon as I saw the output. Thanks Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be

RE: CFBuilder 2 Search

2011-08-04 Thread Justin Hansen
Ahhh Thank you that's much much better! This has been bugging me for weeks! Thank you! Thank you! Thank you! Justin -Original Message- From: Wil Genovese [mailto:jugg...@trunkful.com] Sent: Thursday, August 04, 2011 3:47 PM To: cf-talk Subject: Re: CFBuilder 2 Search

Re: CFBuilder 2 Search

2011-08-04 Thread AJ Mercer
cool. Hat tip to Sean Corfield :-) On 5 August 2011 07:02, Justin Hansen jhan...@uhlig.com wrote: Ahhh Thank you that's much much better! This has been bugging me for weeks! Thank you! Thank you! Thank you! Justin -Original Message- From: Wil Genovese

Re: left, right, mid? (no political content)

2011-08-04 Thread Peter Boughton
If the format is as simple as this, regex would be overkill. Also, don't forget that list functions ignore empty delimiters (by default), so can just do: cfset FirstNumber = ListFirst( CurrentLine , 'x_' ) / cfset LastNumber = ListLast( CurrentLine , '_' ) /

Re: left, right, mid? (no political content)

2011-08-04 Thread Leigh
Also, don't forget that list functions ignore empty delimiters (by default), so can just do: cfset FirstNumber = ListFirst( CurrentLine , 'x_' ) / Quite possibly. But only if the value of x is known and is not repeated elsewhere within the string. Otherwise the results might be

Re: left, right, mid? (no political content)

2011-08-04 Thread Peter Boughton
Uh, the original post states all have xx at the beginning. I can only read that as two literal x characters, not some random value, and similarly the description of the format as xx-digits-underscore-digits seems to be pretty explicit. Given the information provided, the results are entirely

Re: left, right, mid? (no political content)

2011-08-04 Thread Leigh
Peter, It was quite clear how you interpreted the values .. And as I said, your read on it is quite possibly right. But these are assumptions we are making after all. So it is certainly worth a quick mention that the results could be very different if x is not what you assumed. Though

cfinput-datefield calendar not displaying month and year

2011-08-04 Thread derek felsher
Hi folks I am trying to use the cfinput datefield in CF8. Everything works fine except when the calendar opens, the month and year do not show at the top of the popup. When I move the mouse over the area and click where they should display, then they appear??? Many thanks in advance Derek