Re: Mac 10.7 datasource problem
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 data available to read. Anyone know anything about this? gles.com/ http://worldsingles.com/ Railo Technologies, Inc. -- http://www.getrailo.com/ Perfection is the enemy of the good. -- Gustave Flaubert, French realist novelist (1821-1880) ~| 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:346512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cffunction - initialize query as empty string or QueryNew
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 use var statements to work with the var scope. You can use the local scope instead. So to be clear, these two options are ok. cfset var x = 1 cfset local.x = 1 On Wed, Aug 3, 2011 at 1:37 PM, Gerald Weir g.w...@projectsinknowledge.com wrote: Peter, great examples, really helpful. In a nutshell, if I get it, in CF9 you do not need to use: cfset var local = StructNew() / because you are going to define your vars as: local.myVar1 and local.myVar2 and the local structure is already defined by default. You refer to your vars throughout the cffunction as local.myVar. Hope that's right, Jerry ~| 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:346513 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFSPREADSHEET/ ZIP Code Format?
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 methods of doing so, including many different variations of using a dataformat attribute on a spreadSheetFormatCell/spreadSheetFormatColumn but have not been successful with anything thus far. I can't be the only one who's run into this problem. So I'm counting on you, folks. Any thoughts? Cheers, Steve ~| 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:346514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: COMPLEX SQL RANDOM: SOLVED
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 select data from the chained tables. All I really cared about was that if it was not EVERYONE, that a poll X group X student relationships existed. I only needed one record to prove that. The solution, which works, is below: cfquery name=random_poll datasource=#dsn# SELECT TOP 1 portal_polls.poll_id, portal_polls.question, portal_polls.answer1, portal_polls.answer2, portal_polls.answer2, portal_polls.answer4, portal_polls.answer4, portal_polls.number_answers FROMportal_polls WHERE (portal_polls.start_date #Now()# and portal_polls.end_date #Now()#) and (everyone=1 OR exists (SELECT DISTINCT poll_id FROM portal_groups_x_polls, portal_groups_x_students WHERE portal_groups_x_polls.poll_id=portal_polls.poll_id and portal_groups_x_students.group_id=portal_groups_x_polls.group_id and portal_groups_x_students.student_user_id=#session.userid#)) and not exists (SELECT poll_id FROM portal_students_x_polls_completed WHERE portal_students_x_polls_completed.poll_id=portal_polls.poll_id and portal_students_x_polls_completed.student_user_id=#session.userid#) ORDER BY NEWID(); /cfquery Thanks Everyone! 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 either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged ~| 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:346515 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: COMPLEX SQL RANDOM
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: Jochem van Dieten [mailto:joch...@gmail.com]
Sent: Wednesday, August 03, 2011 3:08 PM
To: cf-talk
Subject: Re: COMPLEX SQL RANDOM
On Wed, Aug 3, 2011 at 9:36 PM, Bill Franklin wrote:
Why not try something like this...(not sure which database you are using)
SELECT TOP 1 *
FROM
(
SELECT DISTINCT portal_polls.poll_id, portal_polls.question,
portal_polls.answer1, portal_polls.answer2, portal_polls.answer2,
portal_polls.answer4, portal_polls.answer4, portal_polls.number_answers
FROM portal_polls, portal_groups_x_polls, portal_groups_x_students
WHERE (portal_polls.start_date #Now()# and portal_polls.end_date
#Now()#)
and (everyone=1 OR
(portal_groups_x_polls.poll_id=portal_polls.poll_id and
portal_groups_x_students.group_id=portal_groups_x_polls.group_id and
portal_groups_x_students.student_user_id=#session.userid#))
and not exists (SELECT * FROM
portal_students_x_polls_completed WHERE
portal_students_x_polls_completed.poll_id=portal_polls.poll_id and
portal_students_x_polls_completed.student_user_id=#session.userid#);
)
Because this query does not have a random result. The result of the
outer query will always be the first row of the inner query. The
result of the inner query will be in a predictable order based on the
indexes and statistics (probably whichever row is returned first by
the index over poll_id, start_date and end_date as I suspect that will
be the driving index).
Jochem
--
Jochem van Dieten
http://jochem.vandieten.net/
~|
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:346516
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cffunction - initialize query as empty string or QueryNew
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. :/ ~| 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:346517 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cffunction - initialize query as empty string or QueryNew
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! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
OO ColdFusion, somebody tell me if this is overkill
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 everything back together Any instantiation would call the public methods. Any thoughts? Am I going to far with code separation.. Thanks Scott ~| 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:346519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OO ColdFusion, somebody tell me if this is overkill
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 back together Any instantiation would call the public methods. Any thoughts? Am I going to far with code separation.. What is the purpose of doing that? Generally, you want to model components after the actual objects your program is trying to describe, as closely as possible. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| 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:346520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OO ColdFusion, somebody tell me if this is overkill
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 contain only CFQUERY or stored proc calls). If your concern is securing your database functions, try restricting your DAO functions to package level access. That should provide nice separation and simple access restriction. ~| 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:346521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfsharepoint and Sharepoint 2010
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 2010 is expecting in its soap requests. At least this appears to be the case for the GetListItems method which is what I've been trying to use. If anyone knows different, please feel free to correct me, but I can't seem to get past the issue at this point. ~| 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:346522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfsharepoint and Sharepoint 2010
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 Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com Co-Author Learning Ext JS 3.2 Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 8/4/2011 12:35 PM, Tim Newton wrote: 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 2010 is expecting in its soap requests. At least this appears to be the case for the GetListItems method which is what I've been trying to use. If anyone knows different, please feel free to correct me, but I can't seem to get past the issue at this point. ~| 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:346523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: COMPLEX SQL RANDOM: SOLVED
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 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 select data from the chained tables. All I really cared about was that if it was not EVERYONE, that a poll X group X student relationships existed. I only needed one record to prove that. The solution, which works, is below: cfquery name=random_poll datasource=#dsn# SELECT TOP 1 portal_polls.poll_id, portal_polls.question, portal_polls.answer1, portal_polls.answer2, portal_polls.answer2, portal_polls.answer4, portal_polls.answer4, portal_polls.number_answers FROM portal_p ~| 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:346524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OO ColdFusion, somebody tell me if this is overkill
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 private), accommodate a changing architecture (like you're doing), and especially if you will expose any of your application through web services later. Be careful that you don't put all your business logic in the services you create, creating an anemic domain model problem. Also, I would say congrats to you for seeing a problem, realizing a viable solution, and only later finding out that it's an already-well-known pattern. I think that's the mark of really knowing your stuff (and also that you should read up on your design patterns). nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Thu, Aug 4, 2011 at 8:40 AM, Scott Stewart sstwebwo...@bellsouth.netwrote: 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 everything back together Any instantiation would call the public methods. Any thoughts? Am I going to far with code separation.. Thanks Scott ~| 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:346525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
left, right, mid? (no political content)
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 _ 2) only the digits after the _ Thanks in advance for your help! Les ~| 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:346526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: left, right, mid? (no political content)
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 that. With such random and varied lengths, how do I return the following strings: 1) only the digits between the xx and the _ 2) only the digits after the _ Thanks in advance for your help! Les ~| 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:346527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: left, right, mid? (no political content)
(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 xx. 2) only the digits after the _ Use ListLast() ~| 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:346528 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF 9 ODBC data source with Windows 2008 64-bit
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: jdbc:oracle:@myDBServer.myDomain.com:ORCL Driver Class: oralce.jbdc.OracleDriver Driver Name: oracle.jar How about the connection string field in the advanced settings section? Can someone who has done this before help me out? I am using Oracle 10g and Win 2008 R2 64-bit. Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, July 25, 2011 11:20 AM To: cf-talk Subject: Re: CF 9 ODBC data source with Windows 2008 64-bit I am guessing this issue has been discussed but I just haven't followed it. In my production server(Windows 2008 R2 64-bit), I installed Oracle 11g client and I was able to connect to my Oracle 10g DB via the odbc DSN I created. But when I went to CF Admin and tried to create a DSN using ODBC Socket driver, it gives me this mismatch error. Is it possible for you to use the JDBC driver instead - either CF (DataDirect) or Oracle? If not, you'll need to download and install a 64-bit Oracle ODBC driver, if such a thing exists. But I'd recommend using JDBC if at all possible. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:346529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
giving users a selection of email type
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! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 ODBC data source with Windows 2008 64-bit
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, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:346531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: giving users a selection of email type
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, 2011-08-04 at 14:11 -0500, Greg Morphis wrote: 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! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346532 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: giving users a selection of email type
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 wrote: 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! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: giving users a selection of email type
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 3:25 PM, Bryan Stevenson br...@electricedgesystems.com wrote: 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, 2011-08-04 at 14:11 -0500, Greg Morphis wrote: 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! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346534 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: giving users a selection of email type
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 to go so I'm asking you all :) On Thu, Aug 4, 2011 at 2:25 PM, Bryan Stevenson br...@electricedgesystems.com wrote: 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, 2011-08-04 at 14:11 -0500, Greg Morphis wrote: 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! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF 9 ODBC data source with Windows 2008 64-bit
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 (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, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:346536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: giving users a selection of email type
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 shameless plug for my blog - but the post is relevant. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Aug 4, 2011, at 2:27 PM, Casey Dougall wrote: 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 3:25 PM, Bryan Stevenson br...@electricedgesystems.com wrote: 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, 2011-08-04 at 14:11 -0500, Greg Morphis wrote: 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! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: giving users a selection of email type
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, Bryan Stevenson br...@electricedgesystems.com wrote: 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, 2011-08-04 at 14:11 -0500, Greg Morphis wrote: 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! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OO ColdFusion, somebody tell me if this is overkill
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 private), accommodate a changing architecture (like you're doing), and especially if you will expose any of your application through web services later. I think you're assuming facts not in evidence here. The OP didn't mention any potential reuse or services layer. And simply creating two classes from one doesn't reduce complexity, it just moves it around. Finally, it's extremely common for classes to contain both private and public methods - objects are supposed to manage themselves without exposing implementation details, and that's what private methods let us do. Simply separating private and public methods into two objects doesn't really solve any problem if you're simply going to extend the class with the private methods in one new class. Finally, there's no mention of accommodating a changing architecture in the OP's question. I'm not trying to be unpleasant here, but I just don't see any of those concerns in the original question. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:346539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: giving users a selection of email type
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 bold underlined one via HTML). So for reasons like that, blindly removing tags just doesn't cut it in my books. my 2 cents Cheers On Thu, 2011-08-04 at 14:28 -0500, Greg Morphis wrote: 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 to go so I'm asking you all :) On Thu, Aug 4, 2011 at 2:25 PM, Bryan Stevenson br...@electricedgesystems.com wrote: 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, 2011-08-04 at 14:11 -0500, Greg Morphis wrote: 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! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: OO ColdFusion, somebody tell me if this is overkill
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 a component and reducing the number of lines in a file, does reduce the complexity of the file, which can be a serious problem in a lot of applications. If the file is getting unwieldy and excessively large, splitting out functionality (in a logical way) is always a good idea. However it does add another complexity of having more files. Realize that the reverse of this is a single-file-do-all-spaghetti-chaos application, but taken normalization to an extreme gives you hundreds of useless files. Your software will be always be complex. How you handle it always matters. Finally, changing architecture is exactly what Scott was asking about in the first place, even though he didn't say it directly. nathan strutz [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz] On Thu, Aug 4, 2011 at 1:05 PM, Dave Watts dwa...@figleaf.com wrote: 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 private), accommodate a changing architecture (like you're doing), and especially if you will expose any of your application through web services later. I think you're assuming facts not in evidence here. The OP didn't mention any potential reuse or services layer. And simply creating two classes from one doesn't reduce complexity, it just moves it around. Finally, it's extremely common for classes to contain both private and public methods - objects are supposed to manage themselves without exposing implementation details, and that's what private methods let us do. Simply separating private and public methods into two objects doesn't really solve any problem if you're simply going to extend the class with the private methods in one new class. Finally, there's no mention of accommodating a changing architecture in the OP's question. I'm not trying to be unpleasant here, but I just don't see any of those concerns in the original question. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:346541 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFBuilder 2 Search
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! Thanks, Justin ~| 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:346542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFBuilder 2 Search
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 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! Thanks, Justin ~~ ~~~| 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:346542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf- talk/unsubscribe.cfm ~| 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:346543 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder 2 Search
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 Hansen wrote: 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! Thanks, Justin ~| 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:346544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: giving users a selection of email type
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 have properly written HTML and you: - remove everything outside the body; - remove script tags including content; - remove style tags including content; - replace anchors with their href; - remove all tags; - collapse whitespace; - rewrap with a flowed algorithm; the content will look pretty OK. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| 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:346545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: giving users a selection of email type
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 better emphasis.or add whitespacehard wrap a line...and so on ...but each to their ownjust providing the OP with options and reasons why ;-) FYI...this has nothing to do with proper HTML (but I understand what you're talking about). Cheers On Thu, 2011-08-04 at 22:49 +0200, Jochem van Dieten wrote: 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 have properly written HTML and you: - remove everything outside the body; - remove script tags including content; - remove style tags including content; - replace anchors with their href; - remove all tags; - collapse whitespace; - rewrap with a flowed algorithm; the content will look pretty OK. Jochem -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| 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:346546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFBuilder 2 Search
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: 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! Thanks, Justin ~| 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:346547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: COMPLEX SQL RANDOM: SOLVED
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 either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged -Original Message- From: Maureen [mailto:mamamaur...@gmail.com] Sent: Thursday, August 04, 2011 1:38 PM To: cf-talk Subject: Re: COMPLEX SQL RANDOM: SOLVED 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 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 select data from the chained tables. All I really cared about was that if it was not EVERYONE, that a poll X group X student relationships existed. I only needed one record to prove that. The solution, which works, is below: cfquery name=random_poll datasource=#dsn# SELECT TOP 1 portal_polls.poll_id, portal_polls.question, portal_polls.answer1, portal_polls.answer2, portal_polls.answer2, portal_polls.answer4, portal_polls.answer4, portal_polls.number_answers FROM portal_p ~| 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:346548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFBuilder 2 Search
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 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 Hansen wrote: 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! Thanks, Justin ~| 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:346549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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 [mailto:jugg...@trunkful.com] Sent: Thursday, August 04, 2011 3:47 PM To: cf-talk Subject: Re: CFBuilder 2 Search 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 Hansen wrote: 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! Thanks, Justin ~| 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:346550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: left, right, mid? (no political content)
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 , '_' ) / ~| 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:346551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: left, right, mid? (no political content)
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 unpredictable. ~| 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:346552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: left, right, mid? (no political content)
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 predictable. ~| 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:346553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: left, right, mid? (no political content)
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 hardly anything to make a fuss over. -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:346554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfinput-datefield calendar not displaying month and year
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 ~| 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:346555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
