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
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
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
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
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:
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. :/
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!
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
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
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
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
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
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
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
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
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
(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
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:
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!
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,
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,
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
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
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
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
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
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,
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
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
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
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!
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
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
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
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
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:
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
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
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
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 , '_' ) /
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
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
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
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
44 matches
Mail list logo