RE: Table Data
Morning Mike, I think part of the problem was that the group by was cutting it down to 11 hours, so I worked with an SQL guy on creating a sub query, it took a few revisions but we finally got it up and running, it's a bit of a monster to say the least. SELECT Hour.HourOfDay, DATEPART(month, Hour.ReportDate) AS myMonth, DATEPART(day, Hour.ReportDate) AS myDay, DATEPART(year, Hour.ReportDate) AS myYear, DATEPART(hour, Hour.ReportDate) AS myHour, DATEPART(Weekday, Hour.ReportDate) As myWeekday, DATENAME(Weekday, Hour.ReportDate) As myWeekdayName, SUM(CASE WHEN MacLog.LogClass_ID = 1 THEN 1 ELSE 0 END) AS Success, SUM(CASE WHEN MacLog.LogClass_ID = 2 THEN 1 ELSE 0 END) AS Failed, SUM(CASE WHEN MacLog.LogClass_ID = 3 THEN 1 ELSE 0 END) AS NoAction, COUNT(DISTINCT MacLog.MacAddress_ID) AS UniqueDevices FROM( SELECT DISTINCT Hour.HourOfDay, DateAdd(Day, DateDiff(Day, 0, MacLog.DateTime), 0) AS ReportDate FROM Hour INNER JOIN MacLog ON MacLog.DateTime BETWEEN cfqueryparam value=#ARGUMENTS.StartDate# cfsqltype=cf_sql_timestamp / AND cfqueryparam value=#ARGUMENTS.EndDate# cfsqltype=cf_sql_timestamp / ) AS Hour LEFT OUTER JOIN MacLog ON Hour.HourOfDay = DATEPART(hour, MacLog.DateTime) AND Hour.ReportDate = DateAdd(day, DateDiff(Day, 0, MacLog.DateTime), 0) AND MacLog.DateTime BETWEEN cfqueryparam value=#ARGUMENTS.StartDate# cfsqltype=cf_sql_timestamp / AND cfqueryparam value=#ARGUMENTS.EndDate# cfsqltype=cf_sql_timestamp / AND MacLog.ThinkTank_ID = cfqueryparam value=#ARGUMENTS.ThinkTankID# cfsqltype=cf_sql_integer maxlength=4 / GROUP BY DATEPART(month, Hour.ReportDate), DATEPART(day, Hour.ReportDate), DATEPART(year, Hour.ReportDate), DATEPART(hour, Hour.ReportDate), DATEPART(Weekday, Hour.ReportDate), DATENAME(Weekday, Hour.ReportDate), Hour.HourOfDay ORDER BY DATEPART(month, Hour.ReportDate), DATEPART(day, Hour.ReportDate), DATEPART(year, Hour.ReportDate), Hour.HourOfDay That works a charm at the moment, I've still got a lot of testing to do with it, crunching the numbers by hand alongside to check the results, but it appears to be working just fine. Thanks for your initial ideas of the hours table and the LEFT OUTER JOIN, that got us off to a good footing when working on this. Cheers mate, Rob -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 07 May 2007 17:23 To: CF-Talk Subject: RE: Table Data Hmmm. Well, I checked the HOUR() function and it returns 0-23 for the hours as I hoped. I just tried a simple test and it worked for me. I did get multiple records for one hour, but I expected that from the test data I entered. I also got all other records, for each our in my Hours table. These were met with NULLs from the main table. Do you have all the hours (0-23) in your Hours table? Come to think of it, I bet your GROUP BY could be reducing the total number of hours down to 11. You may need to do it in a nested query or create a view for your first query (that sums and counts), then LEFT OUTER JOIN that view to the Hours table. M!ke -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Monday, May 07, 2007 8:46 AM To: CF-Talk Subject: RE: Table Data Thanks Michael, After playing around with this a lot today, it seems to defiantly be my GROUP BY clause that's causing the issue. The query isn't returning 0 results like I thought it was, I'd just picked a date which had no records (doh!) but now I've picked another date, it'll return 11 records (which is the number of hours that have records existing) which sort of brings us back round to square 1 again. I've
cfchart issues
Guys, I've got a weird drawing issue with my chcharts, for some sets of data it seems to screw up where the data points should be, I've taken a screen capture to show you what I mean. http://80.244.184.135/chart.png As you can see, it plots the lines as it should do, but seems to offset some of the markers, very strange. Any ideas why this might be, is it a known bug? Thanks, Rob ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277229 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Switch applications in the middle of a page
Sean, Correct me if I am wrong, but in the application.cfc the this.name sets the Application Name. If that is correct then this is actually set on every request is it not when it is in the global space of the cfc? On 5/8/07, Sean Corfield [EMAIL PROTECTED] wrote: On 5/7/07, Mike Chabot [EMAIL PROTECTED] wrote: How show I rewrite this code now that App B was changed from using Application.cfm to using Application.cfc? Just run a cfapplication tag and the necessary methods / includes. Application.cfc is meant to represent a best practice approach where the application name is set just once per request, right at the beginning. Of course there are sometimes use cases where a best practice rule has to be broken... -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277230 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ANN: cfFrameworks.com workshop: Peter Bell on Lightwire
HI All, For those of you not on the cfFrameworks mailing list Peter Bell will be doing a workshop on his Lightwire framework tomorrow night 7pm GMT. If you have any questions or just want to come along and watch please do. More info here: http://www.cfframeworks.com/blog/index.cfm/2007/4/27/cfFrameworkscom-workshop-Peter-Bell-on-Lightwire - http://wapurl.co.uk/?CAI11HC register here: http://upcoming.yahoo.com/event/186522/ - http://wapurl.co.uk/?GJH9XSZ -- Nick Tong web: http://talkwebsolutions.co.uk blog: http://succor.co.uk f..works:http://cfframeworks.com short urls: http://wapurl.co.uk green link: http://wapurl.co.uk/?4Z2YDLX ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277231 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Client-provided cookies
Anyone know if its possible for the client to set a cookie for the server to reply with in the same fashion that the server asks the client to maintain state across http requests? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Lack of CF understanding: Info Week
Google triphomes homeaway (dont want to post a link to this junk), go to the article, click on discuss, search for coldfusion, note that the next page says: Your search for confusion found ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277233 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Client-provided cookies
yep through the url... But I do not reccommend it for security reasons. Why do you ask? On 5/8/07, Ariel Jakobovits [EMAIL PROTECTED] wrote: Anyone know if its possible for the client to set a cookie for the server to reply with in the same fashion that the server asks the client to maintain state across http requests? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277234 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Client-provided cookies
Not sure if this is what you mean, but the web developer tool bar plugin for firefox lets you make your own cookies. http://chrispederick.com/work/webdeveloper/ cookies - add cookie On 08/05/07, Ariel Jakobovits [EMAIL PROTECTED] wrote: Anyone know if its possible for the client to set a cookie for the server to reply with in the same fashion that the server asks the client to maintain state across http requests? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277235 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting a list of all the instances on a server
So how does JRun gather a list of all the instances on its server or the 'cfusion' (port 8300) administrator? I'm just wondering if there is a way to tap into that? Cheers again, James I could be way of base here, but my understanding is you can't. The reason being is that CF is run on an Application Server, in normal installs that is Jrun and they run in their own space without any knowledge of each other. On 5/8/07, James Buckingham [EMAIL PROTECTED] wrote: ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277236 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MX7: Updating a single server in a cluster...
We've got two load-balanced Windows 2003 servers, each with one cluster holding two instances each. The only way I can see I can do this is to create a checklist of all the instances present on a server and keep sending CFHTTP requests through the domain telling it to update the server config. The request then returns the name of the instance which just processed that request and my code ticks it off the list to say that one has been updated. It then loops through it again until all the instances on the list have been done. I'd rather be able to say Update the configruation of the instance(s) on port 8301 of IP address xx.xx.xx.xx. Then repeat this process for port 8302 on the same one. It would be tidier and less of an overhead. Cheers, James James Buckingham wrote: I noticed on the Scorpio Wish list that someone has asked for this but I was wondering if anyone knew a workaround which would allow me to update a single server in a cluster? Basically I want to make separate CFHTTP requests to each server to tell it to run its own configuration file. My understanding of this though is if I call the machines IP then ColdFusion will intercept that request and send it in the Cluster's Round Robin. How is your cluster configured? Jochem ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277237 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Getting a list of all the instances on a server
It gets it from a servers.xml file stored c:\jrun\lib Then I guess from there it gets the info from each of the config files for each instance location. -Original Message- From: James Buckingham [mailto:[EMAIL PROTECTED] Sent: 08 May 2007 11:35 To: CF-Talk Subject: Re: Getting a list of all the instances on a server So how does JRun gather a list of all the instances on its server or the 'cfusion' (port 8300) administrator? I'm just wondering if there is a way to tap into that? Cheers again, James I could be way of base here, but my understanding is you can't. The reason being is that CF is run on an Application Server, in normal installs that is Jrun and they run in their own space without any knowledge of each other. On 5/8/07, James Buckingham [EMAIL PROTECTED] wrote: ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277238 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Lack of CF understanding: Info Week
I wrote the author an email... Tried to point out (in a short, nice way) that the technical statements about ColdFusion were completely false. - Yves - On 5/8/07, Adrian [EMAIL PROTECTED] wrote: Google triphomes homeaway (dont want to post a link to this junk), go to the article, click on discuss, search for coldfusion, note that the next page says: Your search for confusion found ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277239 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting a list of all the instances on a server
For security reasons I doubt very much that you can get that information, I could be wrong though. But can I ask the age old question What exactly are you wanting to do? On 5/8/07, James Buckingham [EMAIL PROTECTED] wrote: So how does JRun gather a list of all the instances on its server or the 'cfusion' (port 8300) administrator? I'm just wondering if there is a way to tap into that? Cheers again, James I could be way of base here, but my understanding is you can't. The reason being is that CF is run on an Application Server, in normal installs that is Jrun and they run in their own space without any knowledge of each other. On 5/8/07, James Buckingham [EMAIL PROTECTED] wrote: ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277240 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX7 Upgrade Server keeps Restarting
On Sunday 06 May 2007, [EMAIL PROTECTED] wrote: # Java VM: Java HotSpot(TM) Server VM (1.4.2_09-b05 interpreted mode) That latest fixes allow using a newer JVM (...2.11 ?). Have you tried that ? j com.gp.client.chart.axis.axis.MxScaleDimension.getLabel(I)[C+15 Is that your code, or a CFChart internal ? -- Tom Chiverton Helping to vitalistically fashion global users on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277241 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Lack of CF understanding: Info Week
On Sunday 06 May 2007, Eric J. Hoffman wrote: Triphomes originally was built using Cold Fusion, a web site development tool that runs on (I am sure he meant to inject only here) on Windows, and depends on Microsoft's Internet Information Server and SQL Server Database. Just as with its other sites, HomeAway added more It's perfectly possible their specific CF app only runs on Windows. -- Tom Chiverton Helping to challengingly monetize turn-key IPOs on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277242 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Lack of CF understanding: Info Week
Yeah but that is their app not CF itself. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: 08 May 2007 12:32 To: CF-Talk Subject: Re: Lack of CF understanding: Info Week On Sunday 06 May 2007, Eric J. Hoffman wrote: Triphomes originally was built using Cold Fusion, a web site development tool that runs on (I am sure he meant to inject only here) on Windows, and depends on Microsoft's Internet Information Server and SQL Server Database. Just as with its other sites, HomeAway added more It's perfectly possible their specific CF app only runs on Windows. -- Tom Chiverton Helping to challengingly monetize turn-key IPOs on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfchart issues
Rob, I've got a weird drawing issue with my chcharts, for some sets of data it seems to screw up where the data points should be, I've taken a screen capture to show you what I mean. http://80.244.184.135/chart.png As you can see, it plots the lines as it should do, but seems to offset some of the markers, very strange. From looking at the chart and not knowing your data, it looks like the markers are correct and the lines are off. The lines stop on May 22, 2002 while the markers go to May 23, 2002. It looks like the lines are offset by one day. Have you verified your CF tags are correct? -Dan ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277244 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe CS3 Web Edition leaves me wanting, moving to Eclipse! W AS (RE: Frameworks)
Thanks Sean, While I'm very interested in svn, just going to take some time to figure out how it's going to work with our site load... Read below for some additional comments. Again thanks for your comments... On 5/8/07, Sean Corfield [EMAIL PROTECTED] wrote: On 5/7/07, Casey Dougall [EMAIL PROTECTED] wrote: How long would that take to commit these edits using SVN? Right-click, Team Commit add (an optional) comment explaining what the change does / fixes and click OK. Sounds good... Can they be done with the client on the phone? You randomly change code while the client's on the phone?!? You don't make them log a change request / bug for changes? We log the request as we're talking with them. We have a task management system that's really tricked out. You need to understand. sometimes these updates are 3 minutes. Not code related but maybe a rate change. While we offer a custom CMS solutions, many clients would still rather call us to make a quick change to their rates for the following season. They have a 5 page website where the dates and rates change for the following year, maybe even a new menu. These are the sites that are the problem. While SVN may work well on our dedicated servers, it's not going to work out on shared windows asp hosting... While we continue to move these sites to our dedicated boxes, it's a lot of work and non billable much of the time. You don't quote them for a change? Wow, so are so totally setting the wrong expectations - you are devaluing us all. Don't get me wrong. Many of these items I'm talking about are edits not projects we do quote those. Projects need signed contracts, edits just get billed. Sorry to be so harsh but you're acting like a cowboy and that takes everyone's rates down. I'm not sure what you are billing but I can almost guarantee our rates are above or equal to what your are charging. We still run into some issues quoting projects correctly at times, but we've been getting a lot better on that tip. Like the projects you expect take 3 hours running over to 6 +. What happens when it's one of our older sites we haven't created a repository for? Import it into SVN. It may take a while but you can do it overnight and make the change the next day (think that's too slow - see above). Or you can be proactive and just start importing old sites now. Ha... Think it's time to start looking at Terabyte Drives... Because that's what its going to take. Maybe not when we are setting up the sites but by years end or end of 2008 after we have rounds and rounds of edits... We're also talking lots of sites. cvsdude has great hosted plans for SVN and Trac - bug tracking is the critical other side of source code control, in my opinion. Eh, we would most likelly handle most SVN in the office and figure out a way to upload those changes to the live servers. I'd really be interested in how we can accomplish more version control but I really don't see the benefit on the small 5/10 page sites Well, once it becomes the way you work, you soon realize that any other way is sub-par. There really is no project too small for version control. -- True true, as with anything in life, it might take you a while to pick up on something new but once you do, there is just no turning back... But I'm still not eating shell fish!!! Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ -- Casey ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe CS3 Web Edition leaves me wanting, moving to Eclipse! W AS (RE: Frameworks)
Sean, What happens when it's one of our older sites we haven't created a repository for? Import it into SVN. It may take a while but you can do it overnight and make the change the next day (think that's too slow - see above). Or you can be proactive and just start importing old sites now. From his previous e-mails, it sounds like he's dealing with very small applications (only a dozen or so templates.) In that case an import is very fast. Basically, the import depends on the number of files and total size of the project you're importing. Really large files with lots of large source code files (like large PSD/Flash files) will obviously take longer. Even with the largest projects I've imported, you can probably start it before going to lunch and have it finish when you come back. A small project should import in just a few minutes. -Dan ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277246 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Transfer Adaptor / MG:U
Any ideas why, when used within a MGU application that my Transfer Adapter comes up as com.adobe.hs.common.orm.TransferAdapter? Specific reference to Adobe? N ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277247 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe CS3 Web Edition leaves me wanting, moving to Eclipse! W AS (RE: Frameworks)
Casey, Ha... Think it's time to start looking at Terabyte Drives... Because that's what its going to take. Maybe not when we are setting up the sites but by years end or end of 2008 after we have rounds and rounds of edits... We're also talking lots of sites. SVN will use a lot less disk space then making complete copies of pages. Only deltas (changes) are stored, so there's not a lot of disk space used. If you change a single character in a 2MB file, it only needs to log the single character it changed to be able to ever restore the file to it's previous state. -Dan ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Table Data
That's good to hear. BTW, you may be able to simplify this a bit. Place your larger query in the sub-select area, then the outside select would only do the outer join. SELECT HourOfDay, ReportDate FROM Hours LEFT OUTER JOIN ( SELECT ReportDate FROM MacLog WHERE... GROUP BY... ) AS TempMacLog ORDER BY ... The inner-most SELECT statement would do all the summarizing with the GROUP BY, then the outer SELECT would only need to add the hour of day value. M!ke -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 2:33 AM To: CF-Talk Subject: RE: Table Data Morning Mike, I think part of the problem was that the group by was cutting it down to 11 hours, so I worked with an SQL guy on creating a sub query, it took a few revisions but we finally got it up and running, it's a bit of a monster to say the least. SELECT Hour.HourOfDay, DATEPART(month, Hour.ReportDate) AS myMonth, DATEPART(day, Hour.ReportDate) AS myDay, DATEPART(year, Hour.ReportDate) AS myYear, DATEPART(hour, Hour.ReportDate) AS myHour, DATEPART(Weekday, Hour.ReportDate) As myWeekday, DATENAME(Weekday, Hour.ReportDate) As myWeekdayName, SUM(CASE WHEN MacLog.LogClass_ID = 1 THEN 1 ELSE 0 END) AS Success, SUM(CASE WHEN MacLog.LogClass_ID = 2 THEN 1 ELSE 0 END) AS Failed, SUM(CASE WHEN MacLog.LogClass_ID = 3 THEN 1 ELSE 0 END) AS NoAction, COUNT(DISTINCT MacLog.MacAddress_ID) AS UniqueDevices FROM( SELECT DISTINCT Hour.HourOfDay, DateAdd(Day, DateDiff(Day, 0, MacLog.DateTime), 0) AS ReportDate FROM Hour INNER JOIN MacLog ON MacLog.DateTime BETWEEN cfqueryparam value=#ARGUMENTS.StartDate# cfsqltype=cf_sql_timestamp / AND cfqueryparam value=#ARGUMENTS.EndDate# cfsqltype=cf_sql_timestamp / ) AS Hour LEFT OUTER JOIN MacLog ON Hour.HourOfDay = DATEPART(hour, MacLog.DateTime) AND Hour.ReportDate = DateAdd(day, DateDiff(Day, 0, MacLog.DateTime), 0) AND MacLog.DateTime BETWEEN cfqueryparam value=#ARGUMENTS.StartDate# cfsqltype=cf_sql_timestamp / AND cfqueryparam value=#ARGUMENTS.EndDate# cfsqltype=cf_sql_timestamp / AND MacLog.ThinkTank_ID = cfqueryparam value=#ARGUMENTS.ThinkTankID# cfsqltype=cf_sql_integer maxlength=4 / GROUP BY DATEPART(month, Hour.ReportDate), DATEPART(day, Hour.ReportDate), DATEPART(year, Hour.ReportDate), DATEPART(hour, Hour.ReportDate), DATEPART(Weekday, Hour.ReportDate), DATENAME(Weekday, Hour.ReportDate), Hour.HourOfDay ORDER BY DATEPART(month, Hour.ReportDate), DATEPART(day, Hour.ReportDate), DATEPART(year, Hour.ReportDate), Hour.HourOfDay That works a charm at the moment, I've still got a lot of testing to do with it, crunching the numbers by hand alongside to check the results, but it appears to be working just fine. Thanks for your initial ideas of the hours table and the LEFT OUTER JOIN, that got us off to a good footing when working on this. Cheers mate, Rob ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277249 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Smith CF server now open source
On 5/7/07, David McCan [EMAIL PROTECTED] wrote: FYI, I checked the smithproject.org website and noticed that they have open sourced it. Cool, thanks for pointing this out. I just blogged about it at www.opensourcecf.com Rick ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277250 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Lack of CF understanding: Info Week
I also wrote to the author of the article, and he responded, asking for permission to publish my response as a Letter to the Editor... which I granted. Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277251 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Lack of CF understanding: Info Week
Awesome Rick. ;-) Yves On 5/8/07, Rick Root [EMAIL PROTECTED] wrote: I also wrote to the author of the article, and he responded, asking for permission to publish my response as a Letter to the Editor... which I granted. Rick ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277252 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Lack of CF understanding: Info Week
Great stuff Rick, I look forward to reading it, Once it's up for all to see be sure to post a link. Rob -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 08 May 2007 13:12 To: CF-Talk Subject: Re: Lack of CF understanding: Info Week I also wrote to the author of the article, and he responded, asking for permission to publish my response as a Letter to the Editor... which I granted. Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Adobe CS3 Web Edition leaves me wanting, moving to Eclipse! W AS (RE: Frameworks)
Well, it would log the single character, as well as all meta-data to associate it to the file + comments ;) But yea, they are tons smaller. I think the biggest hurdle for me was to a) get away from direct server editing (sooo easy, yet so dangerous), move to local PC development (buy some RAM), and add SNV into my process after any local code / test / code / test cycles are done. It does take longer to do little changes, and I have to force myself to remember to commit and comment them, but it has helped me in the long run. Chris -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 7:59 AM To: CF-Talk Subject: RE: Adobe CS3 Web Edition leaves me wanting, moving to Eclipse! W AS (RE: Frameworks) Casey, Ha... Think it's time to start looking at Terabyte Drives... Because that's what its going to take. Maybe not when we are setting up the sites but by years end or end of 2008 after we have rounds and rounds of edits... We're also talking lots of sites. SVN will use a lot less disk space then making complete copies of pages. Only deltas (changes) are stored, so there's not a lot of disk space used. If you change a single character in a 2MB file, it only needs to log the single character it changed to be able to ever restore the file to it's previous state. -Dan ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277254 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Lack of CF understanding: Info Week
Here's the letter I wrote Mr. Babcock, Your recent article Restore Backbone To Brittle Sites seems to imply that Coldfusion only runs on Windows, IIS, and SQL Server: TripHomes originally was built using ColdFusion, a Web site development tool that runs on Windows and depends on Microsoft's Internet Information Server Web server and SQL Server database. Of course, Coldfusion does not RELY on any of those things. At most, it typically relies on JRun, but will work with a variety of J2EE servers. It runs quite nicely on other platforms (Solaris and Linux, among others), and even on Windows supports the use of OTHER web servers, like Apache. I suspect, but nobody will ever know, that the site would have been just fine on Coldfusion, but as often happens with sites that grow over time, Best practices fall apart. It's easy to rebuild a site in any language and make it perform better than a site that was built over time. Heck, you could take a web site build in .NET over the last few years, and rebuild it today and make it better. Of course, I'm a coldfusion developer, so I take issue with the implications your article makes, that coldfusion is unreliable (it's not), and that it relies on Windows and IIS (it does not) Thanks for your time. Rick Root ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277255 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Lack of CF understanding: Info Week
Well put Rick. Yves On 5/8/07, Rick Root [EMAIL PROTECTED] wrote: Here's the letter I wrote Mr. Babcock, Your recent article Restore Backbone To Brittle Sites seems to imply that Coldfusion only runs on Windows, IIS, and SQL Server: TripHomes originally was built using ColdFusion, a Web site development tool that runs on Windows and depends on Microsoft's Internet Information Server Web server and SQL Server database. Of course, Coldfusion does not RELY on any of those things. At most, it typically relies on JRun, but will work with a variety of J2EE servers. It runs quite nicely on other platforms (Solaris and Linux, among others), and even on Windows supports the use of OTHER web servers, like Apache. I suspect, but nobody will ever know, that the site would have been just fine on Coldfusion, but as often happens with sites that grow over time, Best practices fall apart. It's easy to rebuild a site in any language and make it perform better than a site that was built over time. Heck, you could take a web site build in .NET over the last few years, and rebuild it today and make it better. Of course, I'm a coldfusion developer, so I take issue with the implications your article makes, that coldfusion is unreliable (it's not), and that it relies on Windows and IIS (it does not) Thanks for your time. Rick Root ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Client-provided cookies
Anyone know if its possible for the client to set a cookie for the server to reply with in the same fashion that the server asks the client to maintain state across http requests? No, that's not possible, in that a cookie refers to a specific kind of token set by the server. However, in the absence of cookies, you can use a token sent on every request within URL or form data. Unlike a cookie, though, you will need to send this on every request; a cookie can be set once, after which the server can expect to receive the cookie automatically upon subsequent page requests. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277257 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting a list of all the instances on a server
But can I ask the age old question What exactly are you wanting to do? No problem - this is actually starting to tie in with my last post MX7: Updating a single server in a cluster... so better to start relating everything together and carry on from one post. I want to be able to update a server config which sits on each instance. The config is the same for each but I need to reinitialise it on all of them at the same time. I'd like to write a script which automates the process of gathering the instance details from a server and updates each one individually as we actually have five servers with multiple instances on the go now. Right now I've got a bit of a manual process going on which identifies via the server_name which server I'm on, it then gets a hard coded list of the instances names and starts firing CFHTTP requests at the server until each instance has updated and returned a value that it's completed. It then ticks that instance off the list and starts the CFHTTP again until all the instances have been done. I've explained this a bit better in the post I've mentioned above but I just think this way of doing it is a bit heavy-handed. Cheers, James ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277258 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Getting a list of all the instances on a server
It gets it from a servers.xml file stored c:\jrun\lib Great, I'll have a look and give that a shot. Thank you very much. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277259 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Getting a list of all the instances on a server
James, How about this instead: Stick a 'config' file in a common location to each server. Run a scheduled task every X minutes to read this file and compare a date/time stamp to the last date/time stamp of the config loaded in the server scope. If they are different, update the config from this shared file. You would just need to create the scheduled tasks and use a CAR to deploy to the other servers. Chris -Original Message- From: James Buckingham [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 8:59 AM To: CF-Talk Subject: Re: Getting a list of all the instances on a server But can I ask the age old question What exactly are you wanting to do? No problem - this is actually starting to tie in with my last post MX7: Updating a single server in a cluster... so better to start relating everything together and carry on from one post. I want to be able to update a server config which sits on each instance. The config is the same for each but I need to reinitialise it on all of them at the same time. I'd like to write a script which automates the process of gathering the instance details from a server and updates each one individually as we actually have five servers with multiple instances on the go now. Right now I've got a bit of a manual process going on which identifies via the server_name which server I'm on, it then gets a hard coded list of the instances names and starts firing CFHTTP requests at the server until each instance has updated and returned a value that it's completed. It then ticks that instance off the list and starts the CFHTTP again until all the instances have been done. I've explained this a bit better in the post I've mentioned above but I just think this way of doing it is a bit heavy-handed. Cheers, James ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277260 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe CS3 Web Edition leaves me wanting, moving to Eclipse! W AS (RE: Frameworks)
Another reason not to buy Dreamweaver CS3 KTML for Dreamweaver Forum :: Is KTML dead and gone? * http://tinyurl.com/2hzegp* I enjoyed using ktml in projects. While it had some little hiccups from time to time setting up, I found the frontend to work well on most html input areas. So with the switch to eclipse, comes the change to fckeditor... -- Casey ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277261 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Reading a spool file from an iSeries/AS400 using Java / CF
I have a CFC I wrote that has many spool file functions in it, one of which reads a spool file and returns it as text. Well, my issue is that the byte reader is incredibly slow for 50 - 100+ page documents. I see a few other stream file read methods in the java api, but I cannot figure out how to invoke them properly. Has anyone else done this before, or have a function that uses Java to read a spool file? Here is my function to read currently (which is way too slow). cffunction name=getSpoolFile returntype=any hint=Returns a formatted spool file from the AS400 - required the getSpoolFileList function be executed first! cfargument name=index required=true type=numeric hint=Index of the spool file to be retrieved cfset var spoolData = '' / cfset var buffer = '' / !---// Set my print parameters based on incoming arguments.format //--- cfset PrintParameterList.setParameter(PrintObject.ATTR_WORKSTATION_CUST_OBJECT , /QSYS.LIB/QWPDEFAULT.WSCST) / cfset PrintParameterList.setParameter(PrintObject.ATTR_MFGTYPE, *WSCST) / !---// Load spool file into memory as an object //--- cfset spoolObj = SpooledFileList.getObject(numberFormat(arguments.index)) / !---// Return a transformed input stream //--- cfset spoolFile = spoolObj.getTransformedInputStream(PrintParameterList) / cfset savechar = 1 / cfloop condition=savechar neq -1 !---// Read one byte from our file //--- cfset savechar = spoolFile.read() / cfif savechar eq -1 cfbreak /cfif !---// This will format the save file to be printed properly from the web //--- cfswitch expression=#savechar# cfcase value=32 cfset buffer = buffer ' ' / /cfcase cfcase value=12 cfset buffer = buffer 'p style=page-break-after: always/p' / /cfcase cfdefaultcase cfset buffer = buffer chr(savechar) / /cfdefaultcase /cfswitch /cfloop cfset spoolData = buffer / cfreturn spoolData / /cffunction ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Annoying Dreamweaver error
When saving a file, Dreamweaver sometimes churns for a while and then gives the following error message: A script in file c:\Program Files\Macromedia\DreamweaverMX\Configuration\Translators\TMCallback.js has been running for a long time. Do you want to continue? Has anyone seen this error and/or know the fix? I didn't find anything meaningful on Google. I am using Dreamweaver 8 with validator set to HTML 4.0 and CFMX 7. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
declare sql variables
I'm having difficulty declaring sql variables. I've not done so (correctly) before, but I think it may solve my problem. I've assigned variables on the fly, though. The following fails with the declare statement in. It's fine without it. I want to declare a var and set it to empty, ''. other sql ( DECLARE @find varchar(30) SELECT p.publication_name, p.publication_id, o.dept,o.link AS author_link, NVL(o.lname, a.a_lname)AS lastname, NVL(o.mname, a.a_mname) || '.' AS middlename, NVL(o.fname, a.a_fname)AS firstname, a.publicationa_id FROM publications p INNER JOIN publications_authors a ON p.publication_id = a.publication_id ) So, the question is, how do I declare a variable and set it to blank? I've used examples from sql tutorial web pages and it doesn't seem to work (at least that part is consistent). thanks. -- Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Annoying Dreamweaver error
When saving a file, Dreamweaver sometimes churns for a while and then gives the following error message: A script in file c:\Program Files\Macromedia\DreamweaverMX\Configuration\Translators\TMCallback.js has been running for a long time. Do you want to continue? Has anyone seen this error and/or know the fix? I didn't find anything meaningful on Google. Does it happens on files with plenty of cfinclude? Try this. Go to: Edit Preferences Invisible Elements Uncheck Show contents of included files. Let us know if it solve the problem Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277265 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Annoying Dreamweaver error
I ran into that a few times as well as other issues and cannot find the answer. I am giving up on DW and moving back to HS+. In fact, all my work I have done this morning is on HS. More reliable. Bruce -Original Message- From: Billy Cox [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 6:44 AM To: CF-Talk Subject: Annoying Dreamweaver error When saving a file, Dreamweaver sometimes churns for a while and then gives the following error message: A script in file c:\Program Files\Macromedia\DreamweaverMX\Configuration\Translators\TMCallback.js has been running for a long time. Do you want to continue? Has anyone seen this error and/or know the fix? I didn't find anything meaningful on Google. I am using Dreamweaver 8 with validator set to HTML 4.0 and CFMX 7. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277266 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Annoying Dreamweaver error
how big is the file that you are saving? IE number of line of code. We've found that sometimes really large files can cause JS timeout's for DW features. jonese On 5/8/07, Billy Cox [EMAIL PROTECTED] wrote: When saving a file, Dreamweaver sometimes churns for a while and then gives the following error message: A script in file c:\Program Files\Macromedia\DreamweaverMX\Configuration\Translators\TMCallback.js has been running for a long time. Do you want to continue? Has anyone seen this error and/or know the fix? I didn't find anything meaningful on Google. I am using Dreamweaver 8 with validator set to HTML 4.0 and CFMX 7. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277267 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: declare sql variables
Try this: DECLARE @find varchar(30); SET @find = ''; If you do not set it to '', then I think it is NULL, which is quite different in SQL terms. Does that help at all? .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 9:47 AM To: CF-Talk Subject: declare sql variables I'm having difficulty declaring sql variables. I've not done so (correctly) before, but I think it may solve my problem. I've assigned variables on the fly, though. The following fails with the declare statement in. It's fine without it. I want to declare a var and set it to empty, ''. other sql ( DECLARE @find varchar(30) SELECT p.publication_name, p.publication_id, o.dept,o.link AS author_link, NVL(o.lname, a.a_lname)AS lastname, NVL(o.mname, a.a_mname) || '.' AS middlename, NVL(o.fname, a.a_fname)AS firstname, a.publicationa_id FROM publications p INNER JOIN publications_authors a ON p.publication_id = a.publication_id ) So, the question is, how do I declare a variable and set it to blank? I've used examples from sql tutorial web pages and it doesn't seem to work (at least that part is consistent). thanks. -- Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277268 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Annoying Dreamweaver error
Ooh..ooh..oooh.. I know this one... Dreamweaver chokes when it tries to render multiple or large cfincludes.. Turn off any rendering of includes, should solve it. -- Scott Stewart ColdFusion Developer SSTWebworks 7241 Jillspring Ct. Springfield, Va. 22152 (703) 220-2835 http://www.sstwebworks.com -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 9:51 AM To: CF-Talk Subject: Re: Annoying Dreamweaver error how big is the file that you are saving? IE number of line of code. We've found that sometimes really large files can cause JS timeout's for DW features. jonese On 5/8/07, Billy Cox [EMAIL PROTECTED] wrote: When saving a file, Dreamweaver sometimes churns for a while and then gives the following error message: A script in file c:\Program Files\Macromedia\DreamweaverMX\Configuration\Translators\TMCallback.js has been running for a long time. Do you want to continue? Has anyone seen this error and/or know the fix? I didn't find anything meaningful on Google. I am using Dreamweaver 8 with validator set to HTML 4.0 and CFMX 7. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277269 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Lack of CF understanding: Info Week
Rick, I can offer this insight. A couple of years ago, a client (who had obviously been schmoozed by a Typo3 evangelist) asked me to explain why ColdFusion was better than Typo3. This of course is like asking which is better, fiberglass or a Nissan Altima. The difference between applications and the underlying technology is lost on non-developers. Some people profit from this ignorance. The question is whether you want to fight the darkness or simply join in the profiteering. Kudos to you for attempting to set the record straight. -Billy Cox -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 7:32 AM To: CF-Talk Subject: Re: Lack of CF understanding: Info Week Here's the letter I wrote Mr. Babcock, Your recent article Restore Backbone To Brittle Sites seems to imply that Coldfusion only runs on Windows, IIS, and SQL Server: TripHomes originally was built using ColdFusion, a Web site development tool that runs on Windows and depends on Microsoft's Internet Information Server Web server and SQL Server database. Of course, Coldfusion does not RELY on any of those things. At most, it typically relies on JRun, but will work with a variety of J2EE servers. It runs quite nicely on other platforms (Solaris and Linux, among others), and even on Windows supports the use of OTHER web servers, like Apache. I suspect, but nobody will ever know, that the site would have been just fine on Coldfusion, but as often happens with sites that grow over time, Best practices fall apart. It's easy to rebuild a site in any language and make it perform better than a site that was built over time. Heck, you could take a web site build in .NET over the last few years, and rebuild it today and make it better. Of course, I'm a coldfusion developer, so I take issue with the implications your article makes, that coldfusion is unreliable (it's not), and that it relies on Windows and IIS (it does not) Thanks for your time. Rick Root ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Transfer Adaptor / MG:U
Hi Neil, I think this was because Sean Corfield helped write it, if i remember correctly. HTH On 08/05/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Any ideas why, when used within a MGU application that my Transfer Adapter comes up as com.adobe.hs.common.orm.TransferAdapter? Specific reference to Adobe? N ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277271 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: [QUAR] Re: Annoying Dreamweaver error
I have unchecked the show includes option. So far, I haven't seen the error anymore. Thanks. -Original Message- From: Massimo Foti [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 8:48 AM To: CF-Talk Subject: [QUAR] Re: Annoying Dreamweaver error When saving a file, Dreamweaver sometimes churns for a while and then gives the following error message: A script in file c:\Program Files\Macromedia\DreamweaverMX\Configuration\Translators\TMCallback.js has been running for a long time. Do you want to continue? Has anyone seen this error and/or know the fix? I didn't find anything meaningful on Google. Does it happens on files with plenty of cfinclude? Try this. Go to: Edit Preferences Invisible Elements Uncheck Show contents of included files. Let us know if it solve the problem Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277272 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
GotCFM.com needs a volunteer designer
Guys, I'd like to revamp the look of GotCFM.com to: 1) Give it more of a modern feel (Web 2.0-style) 2) Reorganize the the site to better focus on the main task of promoting CFML I'm hoping someone might be interested in helping out with the design of the site. In exchange, I would happily give credit to that person in the copyright section of the site (eg: Site Design by) as well as a nice 125x125 banner promoting their services. If you're interested, please contact me offlist. I'd also like to again ask for case studies and feedback on what the community feels could be included into GotCFM to help promote the CFML language. Rey... ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277273 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Table Data
Thanks for the help on that Mike, I'll toy around with simplifying it later today, I like to keep things as lightweight as possible. On a slightly different concept I've been trying to adapt that query to group my data into days (that's the easy part) and then display them as a week, and I want the query to always return 7 results, if there aren't any records for that day then just leave it at 0, whereas without any of this fancy LEFT OUTER stuff it'll just leave a gap. I've posted about it on the SQL list but not had any bites yet, perhaps you could pass your eye over it and give me your thoughts. http://www.houseoffusion.com/groups/sql/thread.cfm/threadid:776 It's the same query as below but gives a bit more of an explanation of what I'm trying to do with it. Just for the record I'd also like to -THEN- make a version of the query that has the same resulting effect but for 12 months of the year :-D Thanks again pal, Rob -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 08 May 2007 13:05 To: CF-Talk Subject: RE: Table Data That's good to hear. BTW, you may be able to simplify this a bit. Place your larger query in the sub-select area, then the outside select would only do the outer join. SELECT HourOfDay, ReportDate FROM Hours LEFT OUTER JOIN ( SELECT ReportDate FROM MacLog WHERE... GROUP BY... ) AS TempMacLog ORDER BY ... The inner-most SELECT statement would do all the summarizing with the GROUP BY, then the outer SELECT would only need to add the hour of day value. M!ke -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 2:33 AM To: CF-Talk Subject: RE: Table Data Morning Mike, I think part of the problem was that the group by was cutting it down to 11 hours, so I worked with an SQL guy on creating a sub query, it took a few revisions but we finally got it up and running, it's a bit of a monster to say the least. SELECT Hour.HourOfDay, DATEPART(month, Hour.ReportDate) AS myMonth, DATEPART(day, Hour.ReportDate) AS myDay, DATEPART(year, Hour.ReportDate) AS myYear, DATEPART(hour, Hour.ReportDate) AS myHour, DATEPART(Weekday, Hour.ReportDate) As myWeekday, DATENAME(Weekday, Hour.ReportDate) As myWeekdayName, SUM(CASE WHEN MacLog.LogClass_ID = 1 THEN 1 ELSE 0 END) AS Success, SUM(CASE WHEN MacLog.LogClass_ID = 2 THEN 1 ELSE 0 END) AS Failed, SUM(CASE WHEN MacLog.LogClass_ID = 3 THEN 1 ELSE 0 END) AS NoAction, COUNT(DISTINCT MacLog.MacAddress_ID) AS UniqueDevices FROM( SELECT DISTINCT Hour.HourOfDay, DateAdd(Day, DateDiff(Day, 0, MacLog.DateTime), 0) AS ReportDate FROM Hour INNER JOIN MacLog ON MacLog.DateTime BETWEEN cfqueryparam value=#ARGUMENTS.StartDate# cfsqltype=cf_sql_timestamp / AND cfqueryparam value=#ARGUMENTS.EndDate# cfsqltype=cf_sql_timestamp / ) AS Hour LEFT OUTER JOIN MacLog ON Hour.HourOfDay = DATEPART(hour, MacLog.DateTime) AND Hour.ReportDate = DateAdd(day, DateDiff(Day, 0, MacLog.DateTime), 0) AND MacLog.DateTime BETWEEN cfqueryparam value=#ARGUMENTS.StartDate# cfsqltype=cf_sql_timestamp / AND cfqueryparam value=#ARGUMENTS.EndDate# cfsqltype=cf_sql_timestamp / AND MacLog.ThinkTank_ID = cfqueryparam value=#ARGUMENTS.ThinkTankID# cfsqltype=cf_sql_integer maxlength=4 / GROUP BY DATEPART(month, Hour.ReportDate), DATEPART(day, Hour.ReportDate), DATEPART(year, Hour.ReportDate), DATEPART(hour, Hour.ReportDate), DATEPART(Weekday, Hour.ReportDate), DATENAME(Weekday, Hour.ReportDate), Hour.HourOfDay ORDER BY DATEPART(month,
Re: MX7: Updating a single server in a cluster...
James Buckingham wrote: We've got two load-balanced Windows 2003 servers, each with one cluster holding two instances each. Are the instances only connected to a webserver, or are they accessible through their own buildin webserver too? The only way I can see I can do this is to create a checklist of all the instances present on a server and keep sending CFHTTP requests through the domain telling it to update the server config. The request then returns the name of the instance which just processed that request and my code ticks it off the list to say that one has been updated. It then loops through it again until all the instances on the list have been done. I'd rather be able to say Update the configruation of the instance(s) on port 8301 of IP address xx.xx.xx.xx. Then repeat this process for port 8302 on the same one. It would be tidier and less of an overhead. You have to make sure that the individual instances are accessible through their own webserver. Then you need a list of all instances and you just cfhttp to each instance. Jochem ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Outputting structs
Hi All, i've created a struct which when outputted, outputs in the 'wrong order' If you run the code below when you're in a subdirectory, i.e: /home/mydir1/mydir2/somepage.cfm each dir and page name is added to the struct in order: When I dump the struct, it comes out in the correct order, but when I loop it as a collection, it comes out in a wierd order? I know that structs don't have exact row numbering, but can anyone tell me why the dump order is different to the actual outputted order? Thanks T cfsilent cfscript //Create a struct to play with Bread.struct=StructNew(); //Set our root location currentlocale=/; /cfscript !---CGI.SCRIPT_NAME is the var with the current location in--- cfloop list=#cgi.SCRIPT_NAME# delimiters=/ index=i cfscript //Insert the looped value into the struct, replacing underscores and .cfm //The keyname becomes the URL, and the keyvalue is the text to link StructInsert(Bread.struct, #currentLocale##i#, #replace(replace(i, '_', ' ', 'all'), '.cfm', '', 'all')#); //Update currentlocale, which acts as the string to update currentlocale=#currentLocale##i#/; /cfscript /cfloop /cfsilent !---For demo purposes, dump the struct - note the order--- cfdump var=#bread# !---Output the struct--- cfoutput div p cfloop collection=#bread.struct# item=i cfoutput a href=#i##bread.struct[i]#/a gt; /cfoutput /cfloop p /div /cfoutput ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277276 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Outputting structs
can anyone tell me why the dump order is different to the actual outputted order? No, other then that all the documentation about structs says that the data is unordered so it can come out in any manor. If one needs to order the data one usually uses arrays. Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277277 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Outputting structs
My CFDumps seem to change order when I dump them out. I am surprised that your CFDump outputs in a consistent order. Instead of doing a collection loop, try doing a list loop over the struct keys StructKeyList(), then using those keys to access the struct. This might be more consistent. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 10:26 AM To: CF-Talk Subject: Outputting structs Hi All, i've created a struct which when outputted, outputs in the 'wrong order' If you run the code below when you're in a subdirectory, i.e: /home/mydir1/mydir2/somepage.cfm each dir and page name is added to the struct in order: When I dump the struct, it comes out in the correct order, but when I loop it as a collection, it comes out in a wierd order? I know that structs don't have exact row numbering, but can anyone tell me why the dump order is different to the actual outputted order? Thanks T cfsilent cfscript //Create a struct to play with Bread.struct=StructNew(); //Set our root location currentlocale=/; /cfscript !---CGI.SCRIPT_NAME is the var with the current location in--- cfloop list=#cgi.SCRIPT_NAME# delimiters=/ index=i cfscript //Insert the looped value into the struct, replacing underscores and .cfm //The keyname becomes the URL, and the keyvalue is the text to link StructInsert(Bread.struct, #currentLocale##i#, #replace(replace(i, '_', ' ', 'all'), '.cfm', '', 'all')#); //Update currentlocale, which acts as the string to update currentlocale=#currentLocale##i#/; /cfscript /cfloop /cfsilent !---For demo purposes, dump the struct - note the order--- cfdump var=#bread# !---Output the struct--- cfoutput div p cfloop collection=#bread.struct# item=i cfoutput a href=#i##bread.struct[i]#/a gt; /cfoutput /cfloop p /div /cfoutput ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277278 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Outputting structs
Structures do not output in a specific order. If you need alphabetical display then you'll have to use another data type. -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 9:26 AM To: CF-Talk Subject: Outputting structs Hi All, i've created a struct which when outputted, outputs in the 'wrong order' If you run the code below when you're in a subdirectory, i.e: /home/mydir1/mydir2/somepage.cfm each dir and page name is added to the struct in order: When I dump the struct, it comes out in the correct order, but when I loop it as a collection, it comes out in a wierd order? I know that structs don't have exact row numbering, but can anyone tell me why the dump order is different to the actual outputted order? Thanks T cfsilent cfscript //Create a struct to play with Bread.struct=StructNew(); //Set our root location currentlocale=/; /cfscript !---CGI.SCRIPT_NAME is the var with the current location in--- cfloop list=#cgi.SCRIPT_NAME# delimiters=/ index=i cfscript //Insert the looped value into the struct, replacing underscores and .cfm //The keyname becomes the URL, and the keyvalue is the text to link StructInsert(Bread.struct, #currentLocale##i#, #replace(replace(i, '_', ' ', 'all'), '.cfm', '', 'all')#); //Update currentlocale, which acts as the string to update currentlocale=#currentLocale##i#/; /cfscript /cfloop /cfsilent !---For demo purposes, dump the struct - note the order--- cfdump var=#bread# !---Output the struct--- cfoutput div p cfloop collection=#bread.struct# item=i cfoutput a href=#i##bread.struct[i]#/a gt; /cfoutput /cfloop p /div /cfoutput ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Outputting structs
On 8 May 2007, at 15:31, Ben Nadel wrote: My CFDumps seem to change order when I dump them out. I am surprised that your CFDump outputs in a consistent order. Yep! everytime... Instead of doing a collection loop, try doing a list loop over the struct keys StructKeyList(), then using those keys to access the struct. This might be more consistent. Same behaviour this end. Thankfully, in this example, the values are guaranteed to get larger by nature, so I could so a structsort by len() I guess... T ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: declare sql variables
Try this: DECLARE @find varchar(30); SET @find = ''; Thanks for replying. I get missing right parenthesis as an error. Maybe that's because it's an inside query that is queried by an outside query? I didn't paste the whole thing cause I was trying to minimize the possible confusion. The whole thing is: SELECT publication_name,publicationa_id,publication_id,dept,middlename, lastname || ',' || substr(firstname,1,1) || '.' as the_name, firstname || lastname as the_full_name, CASE WHEN author_link is not null then 'a href=' || author_link || '' || lastname || ',' || substr(firstname,1,1) || '.' || '/a' ELSE lastname || ',' || substr(firstname,1,1) || '.' || middlename END as author_formatted FROM ( DECLARE @find varchar(30); SET @find = ''; SELECTp.publication_name, p.publication_id, o.dept,o.link AS author_link, NVL(o.lname, a.a_lname)AS lastname, NVL(o.mname, a.a_mname) || '.' AS middlename, NVL(o.fname, a.a_fname)AS firstname, a.publicationa_id FROM publications p INNER JOIN publications_authors a ON p.publication_id = a.publication_id LEFT JOIN people o ON a.id = o.id ORDER BY publicationa_id asc ) Without the declare/set, I get no error. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277281 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Outputting structs
On 5/8/07, Andy Matthews [EMAIL PROTECTED] wrote: Structures do not output in a specific order. If you need alphabetical display then you'll have to use another data type. Or just loop over an alphabetized list of structue keys and do the output that way. Rick ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277282 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Lack of CF understanding: Info Week
On Tuesday 08 May 2007, Robertson-Ravo, Neil (RX) wrote: Yeah but that is their app not CF itself. I read it as: Triphomes originally was built using Cold Fusion, ColdFusion is a web site development tool that runs on on Windows and other places , and (but) Triphomes depends on Microsoft's Internet Information Server and SQL Server Database. Just as with its other sites, HomeAway added more -- Tom Chiverton Helping to biannually disintermediate viral portals on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277283 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Features, Tags, Etc. on Linux
Howdy, I am considering moving some CF sites that are currently hosted on Windows shared hosting servers to a Linux hosting environment. My question is, which features of CF (CFMX 7, specifically) are not available on Linux platforms? Note that this is not intended to be a Linux vs Windows debate. I am interested in knowing only what features, tags, etc. that aren't available if I decide to move to a Linux hosting environment. Thanks! -- Best regards, Chris Montgomery ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277284 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: declare sql variables
Daniel, Yes, you can't declare your variable within a sub-select statement. Declare it before you start the first query and you should be fine. Dean On 5/8/07, daniel kessler [EMAIL PROTECTED] wrote: I get missing right parenthesis as an error. Maybe that's because it's an inside query that is queried by an outside query? I didn't paste the whole thing cause I was trying to minimize the possible confusion. The whole thing is: SELECT publication_name,publicationa_id,publication_id,dept,middlename, lastname || ',' || substr(firstname,1,1) || '.' as the_name, firstname || lastname as the_full_name, CASE WHEN author_link is not null then 'a href=' || author_link || '' || lastname || ',' || substr(firstname,1,1) || '.' || '/a' ELSE lastname || ',' || substr(firstname,1,1) || '.' || middlename END as author_formatted FROM ( DECLARE @find varchar(30); SET @find = ''; SELECTp.publication_name, p.publication_id, o.dept,o.link AS author_link, NVL(o.lname, a.a_lname)AS lastname, NVL(o.mname, a.a_mname) || '.' AS middlename, NVL(o.fname, a.a_fname)AS firstname, a.publicationa_id FROM publications p INNER JOIN publications_authors a ON p.publication_id = a.publication_id LEFT JOIN people o ON a.id = o.id ORDER BY publicationa_id asc ) Without the declare/set, I get no error. -- __ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: declare sql variables
This didn't appear to post the first time (I waited almost an hour), so here goes again and sorry if it posts twice. Try this: DECLARE @find varchar(30); SET @find = ''; Thanks for replying. I get missing right parenthesis as an error. Maybe that's because it's an inside query that is queried by an outside query? I didn't paste the whole thing cause I was trying to minimize the possible confusion. The whole thing is: SELECT publication_name,publicationa_id,publication_id,dept,middlename, lastname || ',' || substr(firstname,1,1) || '.' as the_name, firstname || lastname as the_full_name, CASE WHEN author_link is not null then 'a href=' || author_link || '' || lastname || ',' || substr(firstname,1,1) || '.' || '/a' ELSE lastname || ',' || substr(firstname,1,1) || '.' || middlename END as author_formatted FROM ( DECLARE @find varchar(30); SET @find = ''; SELECTp.publication_name, p.publication_id, o.dept,o.link AS author_link, NVL(o.lname, a.a_lname)AS lastname, NVL(o.mname, a.a_mname) || '.' AS middlename, NVL(o.fname, a.a_fname)AS firstname, a.publicationa_id FROM publications p INNER JOIN publications_authors a ON p.publication_id = a.publication_id LEFT JOIN people o ON a.id = o.id ORDER BY publicationa_id asc ) Without the declare/set, I get no error. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFMX7 Upgrade Server keeps Restarting
I have tried ...2.11 with no success. Maybe I should try a higher version. The below line is cfchart, not my code. I'm still getting consistent restarts on a few templates and cfchart. I might have to pay adbobe for support on this one I think... Brook -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: May 8, 2007 4:30 AM To: CF-Talk Subject: Re: CFMX7 Upgrade Server keeps Restarting On Sunday 06 May 2007, [EMAIL PROTECTED] wrote: # Java VM: Java HotSpot(TM) Server VM (1.4.2_09-b05 interpreted mode) That latest fixes allow using a newer JVM (...2.11 ?). Have you tried that ? j com.gp.client.chart.axis.axis.MxScaleDimension.getLabel(I)[C+15 Is that your code, or a CFChart internal ? -- Tom Chiverton Helping to vitalistically fashion global users on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: declare sql variables
This didn't appear to post the first time (I waited almost an hour), so here goes again and sorry if it posts twice. Try this: DECLARE @find varchar(30); SET @find = ''; Thanks for replying. I get missing right parenthesis as an error. Maybe that's because it's an inside query that is queried by an outside query? I didn't paste the whole thing cause I was trying to minimize the possible confusion. The whole thing is: SELECT publication_name,publicationa_id,publication_id,dept,middlename, lastname || ',' || substr(firstname,1,1) || '.' as the_name, firstname || lastname as the_full_name, CASE WHEN author_link is not null then 'a href=' || author_link || '' || lastname || ',' || substr(firstname,1,1) || '.' || '/a' ELSE lastname || ',' || substr(firstname,1,1) || '.' || middlename END as author_formatted FROM ( DECLARE @find varchar(30); SET @find = ''; SELECTp.publication_name, p.publication_id, o.dept,o.link AS author_link, NVL(o.lname, a.a_lname)AS lastname, NVL(o.mname, a.a_mname) || '.' AS middlename, NVL(o.fname, a.a_fname)AS firstname, a.publicationa_id FROM publications p INNER JOIN publications_authors a ON p.publication_id = a.publication_id LEFT JOIN people o ON a.id = o.id ORDER BY publicationa_id asc ) Without the declare/set, I get no error. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Error,jrpp-3 - Any ideas?
I have no idea how to trouble shoot this error in our exception log. Any ideas? It is causing huge request back-ups and essentially shuts down the cf server. 365 Error,jrpp-3,05/08/07,10:08:15,SchoolSites, The specific sequence of files included or processed is: C:\Inetpub\WebSites\route.cfm 366 java.lang.ThreadDeath 367 at java.lang.Thread.stop(Thread.java:630) 368 at com.intergral.fusionreactor.L.L.é(Unknown Source) 369 at com.intergral.fusionreactor.L.C.A(Unknown Source) 370 at com.intergral.fusionreactor.L.C.run(Unknown Source) -JH ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277288 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Features, Tags, Etc. on Linux
On Tuesday 08 May 2007, Chris Montgomery wrote: question is, which features of CF (CFMX 7, specifically) are not available on Linux platforms? Zero. -- Tom Chiverton Helping to economically disintermediate magnetic portals on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277290 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Error,jrpp-3 - Any ideas?
On Tuesday 08 May 2007, Jim H wrote: I have no idea how to trouble shoot this error in our exception log. Any ideas? It is causing huge request back-ups and essentially shuts down the cf server. Remove the FusionReactor configs. -- Tom Chiverton Helping to apprehensively repurpose virtual eyeballs on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277291 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: declare sql variables
Um, don't you use Oracle? The syntax you're trying to use is sql server syntax. Here's some info on Oracle syntax for bind variables: http://www.akadia.com/services/ora_bind_variables.html ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277292 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF Features, Tags, Etc. on Linux
I am considering moving some CF sites that are currently hosted on Windows shared hosting servers to a Linux hosting environment. My question is, which features of CF (CFMX 7, specifically) are not available on Linux platforms? Note that this is not intended to be a Linux vs Windows debate. I am interested in knowing only what features, tags, etc. that aren't available if I decide to move to a Linux hosting environment. All CF features are available on Linux, with the exception of COM integration. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277293 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Features, Tags, Etc. on Linux
Well, if you are relying on COM for things you may need to re-think it. COM is Windows. Chris -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 11:30 AM To: CF-Talk Subject: Re: CF Features, Tags, Etc. on Linux On Tuesday 08 May 2007, Chris Montgomery wrote: question is, which features of CF (CFMX 7, specifically) are not available on Linux platforms? Zero. -- Tom Chiverton Helping to economically disintermediate magnetic portals on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277294 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF 7 data source limit
Does anyone know if there is a limit to the number of DSNs CF 7 supports? Ben Higgins ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277295 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Features, Tags, Etc. on Linux
Feature-wise, there shouldn't be any difference, unless you have something that requires COM objects, or a compiled C++ CFX tag. Also, I think you are out of luck if you use Access databases (which you shouldn't anyway). Where you are most likely to run into issues is with path and file references since: 1. Linux filenames are case-sensitive (for example, Application.cfm (or ..cfc) starts with an uppercase A - and this will matter on Linux.) 2. path references use / instead of \, 3. there are no drive letters (i.e. C:\) On 5/8/07, Chris Montgomery [EMAIL PROTECTED] wrote: Howdy, I am considering moving some CF sites that are currently hosted on Windows shared hosting servers to a Linux hosting environment. My question is, which features of CF (CFMX 7, specifically) are not available on Linux platforms? Note that this is not intended to be a Linux vs Windows debate. I am interested in knowing only what features, tags, etc. that aren't available if I decide to move to a Linux hosting environment. Thanks! -- Best regards, Chris Montgomery ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277296 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF 7 data source limit
No actual limit I think, but not doubt limited to disk space as the connection strings etc get written to disk. -Original Message- From: Ben D. Higgins [mailto:[EMAIL PROTECTED] Sent: 08 May 2007 16:44 To: CF-Talk Subject: CF 7 data source limit Does anyone know if there is a limit to the number of DSNs CF 7 supports? Ben Higgins ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277297 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Microsoft JDBC Drivers
Anyone using drivers other than the vanilla shipping DataDirect ones? Anyone using the Microsoft SQL JDBC drivers? N ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277298 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
AJAX - The easiest way possible. Spry?
I'm working with a form that'd be perfect for ajax. http://208.106.220.252/addnewquestions.cfm Depending on what you select in the top menu, the other menu items change. What would be the easiest way to incorporate ajax for this? Should I use spry? I've never ajaxed anything before. Thanks, Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277299 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting a list of all the instances on a server
I've got a few ideas of the back of all these suggestions. Thanks a lot for your help everyone. Cheers, James ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277300 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Lack of CF understanding: Info Week
Fiberglass no wait... Altima... ugh, I'm I can't decide. !k -Original Message- From: Billy Cox [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 8:01 AM To: CF-Talk Subject: RE: Lack of CF understanding: Info Week Rick, I can offer this insight. A couple of years ago, a client (who had obviously been schmoozed by a Typo3 evangelist) asked me to explain why ColdFusion was better than Typo3. This of course is like asking which is better, fiberglass or a Nissan Altima. The difference between applications and the underlying technology is lost on non-developers. Some people profit from this ignorance. The question is whether you want to fight the darkness or simply join in the profiteering. Kudos to you for attempting to set the record straight. -Billy Cox -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 7:32 AM To: CF-Talk Subject: Re: Lack of CF understanding: Info Week Here's the letter I wrote Mr. Babcock, Your recent article Restore Backbone To Brittle Sites seems to imply that Coldfusion only runs on Windows, IIS, and SQL Server: TripHomes originally was built using ColdFusion, a Web site development tool that runs on Windows and depends on Microsoft's Internet Information Server Web server and SQL Server database. Of course, Coldfusion does not RELY on any of those things. At most, it typically relies on JRun, but will work with a variety of J2EE servers. It runs quite nicely on other platforms (Solaris and Linux, among others), and even on Windows supports the use of OTHER web servers, like Apache. I suspect, but nobody will ever know, that the site would have been just fine on Coldfusion, but as often happens with sites that grow over time, Best practices fall apart. It's easy to rebuild a site in any language and make it perform better than a site that was built over time. Heck, you could take a web site build in .NET over the last few years, and rebuild it today and make it better. Of course, I'm a coldfusion developer, so I take issue with the implications your article makes, that coldfusion is unreliable (it's not), and that it relies on Windows and IIS (it does not) Thanks for your time. Rick Root ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277301 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error,jrpp-3 - Any ideas?
Which configs are you talking about? Thanks! JH On Tuesday 08 May 2007, Jim H wrote: I have no idea how to trouble shoot this error in our exception log. Any ideas? It is causing huge request back-ups and essentially shuts down the cf server. Remove the FusionReactor configs. -- Tom Chiverton Helping to apprehensively repurpose virtual eyeballs on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277302 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Microsoft JDBC Drivers
Yes what would you like to know. On 5/9/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Anyone using drivers other than the vanilla shipping DataDirect ones? Anyone using the Microsoft SQL JDBC drivers? N ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277303 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: AJAX - The easiest way possible. Spry?
If you're looking for quick and easy, i like JSMX a lot (http://www.lalabird.com). It's a really lightweight library... but it does require that you know the client side JS pretty well in order to manipulate the results. Spry sort of masks that need to know JS... but in order to use it, you need to learn Spry :) I'd say if you're decent with JS, and just want lightweight fast-and-easy get a response from the server, then JSMX will work. If you're not comfortable doing the client side manipulations, check out Spry. On 5/8/07, Will Tomlinson [EMAIL PROTECTED] wrote: I'm working with a form that'd be perfect for ajax. http://208.106.220.252/addnewquestions.cfm Depending on what you select in the top menu, the other menu items change. What would be the easiest way to incorporate ajax for this? Should I use spry? I've never ajaxed anything before. Thanks, Will ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277304 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: AJAX - The easiest way possible. Spry?
Depending on what you select in the top menu, the other menu items change. What would be the easiest way to incorporate ajax for this? Should I use spry? I've never ajaxed anything before. I've not used Spry, but jQuery's ajax implementation is incredibly easy to use. -- Josh ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277305 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Microsoft JDBC Drivers
You are using them now? Any pitfalls? faster then DataDirect? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Andrew Scott To: CF-Talk Sent: Tue May 08 17:20:34 2007 Subject: Re: Microsoft JDBC Drivers Yes what would you like to know. On 5/9/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Anyone using drivers other than the vanilla shipping DataDirect ones? Anyone using the Microsoft SQL JDBC drivers? N ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277306 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: AJAX - The easiest way possible. Spry?
Yeah, that is a good entry to it all. I worked with Todd the lead on that product before, he knows his stuff and wants it to mature (just in a different way than other open source libs) This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Charlie Griefer To: CF-Talk Sent: Tue May 08 17:14:53 2007 Subject: Re: AJAX - The easiest way possible. Spry? If you're looking for quick and easy, i like JSMX a lot (http://www.lalabird.com). It's a really lightweight library... but it does require that you know the client side JS pretty well in order to manipulate the results. Spry sort of masks that need to know JS... but in order to use it, you need to learn Spry :) I'd say if you're decent with JS, and just want lightweight fast-and-easy get a response from the server, then JSMX will work. If you're not comfortable doing the client side manipulations, check out Spry. On 5/8/07, Will Tomlinson [EMAIL PROTECTED] wrote: I'm working with a form that'd be perfect for ajax. http://208.106.220.252/addnewquestions.cfm Depending on what you select in the top menu, the other menu items change. What would be the easiest way to incorporate ajax for this? Should I use spry? I've never ajaxed anything before. Thanks, Will ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277307 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Error,jrpp-3 - Any ideas?
Which configs are you referring to? Thanks, JH On Tuesday 08 May 2007, Jim H wrote: I have no idea how to trouble shoot this error in our exception log. Any ideas? It is causing huge request back-ups and essentially shuts down the cf server. Remove the FusionReactor configs. -- Tom Chiverton Helping to apprehensively repurpose virtual eyeballs on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277308 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Microsoft JDBC Drivers
honestly I have not done a comparison in speed, and haven't noticed any pitfalls. On 5/9/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: You are using them now? Any pitfalls? faster then DataDirect? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Andrew Scott To: CF-Talk Sent: Tue May 08 17:20:34 2007 Subject: Re: Microsoft JDBC Drivers Yes what would you like to know. On 5/9/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Anyone using drivers other than the vanilla shipping DataDirect ones? Anyone using the Microsoft SQL JDBC drivers? N ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277309 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Transfer Adaptor / MG:U
Hi Nick, Makes sense. Cheers See you at Scotch :-) This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Nick Tong To: CF-Talk Sent: Tue May 08 15:06:49 2007 Subject: Re: Transfer Adaptor / MG:U Hi Neil, I think this was because Sean Corfield helped write it, if i remember correctly. HTH On 08/05/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Any ideas why, when used within a MGU application that my Transfer Adapter comes up as com.adobe.hs.common.orm.TransferAdapter? Specific reference to Adobe? N ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277310 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Microsoft JDBC Drivers
So why did you move to using them? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Andrew Scott To: CF-Talk Sent: Tue May 08 17:40:47 2007 Subject: Re: Microsoft JDBC Drivers honestly I have not done a comparison in speed, and haven't noticed any pitfalls. On 5/9/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: You are using them now? Any pitfalls? faster then DataDirect? This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Andrew Scott To: CF-Talk Sent: Tue May 08 17:20:34 2007 Subject: Re: Microsoft JDBC Drivers Yes what would you like to know. On 5/9/07, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Anyone using drivers other than the vanilla shipping DataDirect ones? Anyone using the Microsoft SQL JDBC drivers? N ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277311 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: declare sql variables
Um, don't you use Oracle? The syntax you're trying to use is sql server syntax. Here's some info on Oracle syntax for bind variables: Yes, I do, thank you for remembering. I had searched with SQL as the main part of the title and should've added Oracle. I looked over that page and it certainly stresses the importance of bind variables for performance. Unfortunately, it left me feeling a little duh and all I have left are questions. - I suspect I should use the PL/SQL example. Is that right? - In the PL/SQL example, it does all this as part of a procedure. Does it need to be that way? - So I do(?): declare x varchar(10) begin my SELECT stuff end; I have not been able to find a combination that works without error and all I wanna do is preset a variable and ues it. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277312 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
eBay API Integration with CF
Just checking out there in the CF community if any of you CF developers had any experience working with eBay Integration and CF? If so, can you tell me what we are in for as far as integrating CF with the eBay API. Thanks, Dave Hatz ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277313 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: declare sql variables
Daniel Kessler wrote: ( DECLARE @find varchar(30) SELECT p.publication_name, p.publication_id, o.dept,o.link AS author_link, NVL(o.lname, a.a_lname)AS lastname, NVL(o.mname, a.a_mname) || '.' AS middlename, NVL(o.fname, a.a_fname)AS firstname, a.publicationa_id FROM publications p INNER JOIN publications_authors a ON p.publication_id = a.publication_id ) So, the question is, how do I declare a variable and set it to blank? Why do you want to declare a variable? You are not even using it in your statement. What is the problem for which you think a variable declaration is the solution? Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe CS3 Web Edition leaves me wanting, moving to Eclipse! W AS (RE: Frameworks)
On 5/8/07, Casey Dougall [EMAIL PROTECTED] wrote: We log the request as we're talking with them. We have a task management system that's really tricked out. OK. You had me worried for a while :) Thanx for explaining how you actually work because I didn't get any of that from your original email and I was really concerned that you were looking for a band-aid on a complete lack of process. Glad to hear that's not the case. And sorry if my email sounded harsh... I still think SVN will be beneficial, cost-effective and only minimally-invasive so it's definitely worth checking out. Whether Eclipse suits your development style is another matter (it's great for backend stuff like CFCs and HTML-free CFML pages) but if you have a lot of CSS and fancy visual layout, DW is definitely better - the downside is the poor source control integration in DW. I really do wish Adobe would fix that (heck, people have been requesting CVS and SVN integration in DW for *years*). -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277315 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: declare sql variables
On 5/8/07, daniel kessler wrote: - I suspect I should use the PL/SQL example. Is that right? - In the PL/SQL example, it does all this as part of a procedure. Does it need to be that way? Depends on what you're trying to accomplish. Note that using cfqueryparam, you're essentially creating a bind variable anyway - so with CF, I don't see what you'd gain. What are you really trying to do? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277316 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PBEWithMD5AndDES
Andrew, In case you ever want to encrypt something using Password Based Encryption in ColdFusion, I've included the code below which encrypts the password and encodes it as base64. It's pretty straight forward in CF. The problem was not CF implementation; it was my understanding of PBE, salts, iterations and Byte arrays. With greater understanding, the solution was very simple. A big thanks to Tom Donovan who sent me the information on how to create the byte array in ColdFusion! cfscript theEncrytString = nations1; thePassword = C1F9J9V5; theMethod = PBEWithMD5AndDES; theEncoding = Base64; theSalt = BinaryDecode(c773218c7ec8ee99,Hex); theIterations = 20; test = Encrypt(theEncrytString, thePassword, theMethod, theEncoding, theSalt, theIterations); /cfscript Christine Davis ColdFusion Lead Nations Technical Services Prairie Village, KS 913-748-8044 ext 4703 [EMAIL PROTECTED] ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Flex and Coldfusion
I'm playing around with Flex and was wondering if there was a place with some nice tutorials showing how to integrate CF with Flex. Anyone have any URLs to some tutorials? Thanks! ~Steve ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flex and Coldfusion
www.adobe.com/devnet This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Steve Good To: CF-Talk Sent: Tue May 08 19:28:09 2007 Subject: Flex and Coldfusion I'm playing around with Flex and was wondering if there was a place with some nice tutorials showing how to integrate CF with Flex. Anyone have any URLs to some tutorials? Thanks! ~Steve ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277319 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CSS Help
Ok, I am beating my brain on the table again. I have a css stylesheet attached to a cfm page. I call the stylesheet from the head section of the page by using: link href=css/main.cfm rel=stylesheet type=text/css media=all Yes, the css file is a cfm page because I need to have dynamic colors in the css for each individual site. (the code houses various versions of the site). It is not working. I am not getting any of the css or the cf variables displayed. Any suggestions? Thanks! JH ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277320 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flex and Coldfusion
CFFlex.com. Also, you can check out a list at Andy Jarrett's blog: http://andyjarrett.co.uk/andy/blog/index.cfm/2006/2/7/Flex-2-tutorials Rey Steve Good wrote: I'm playing around with Flex and was wondering if there was a place with some nice tutorials showing how to integrate CF with Flex. Anyone have any URLs to some tutorials? Thanks! ~Steve ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CSS Help
What does the source of the generated HTML look like? Are you getting style blocks? Do you have more than one? I've never actually seen it done like this, generally a .css file is dynamically loaded based on the site. _ Jake Churchill CF Webtools 11204 Davenport, Ste. 200b Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Jim H [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 12:32 PM To: CF-Talk Subject: CSS Help Ok, I am beating my brain on the table again. I have a css stylesheet attached to a cfm page. I call the stylesheet from the head section of the page by using: link href=css/main.cfm rel=stylesheet type=text/css media=all Yes, the css file is a cfm page because I need to have dynamic colors in the css for each individual site. (the code houses various versions of the site). It is not working. I am not getting any of the css or the cf variables displayed. Any suggestions? Thanks! JH ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277322 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CSS Help
Whap happens when you call the CSS file directly in the URL (as if you were going to it as a page)? Also, are you using: cfcontent type=text/css / In the CSS (cfm) page? .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Jim H [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 1:32 PM To: CF-Talk Subject: CSS Help Ok, I am beating my brain on the table again. I have a css stylesheet attached to a cfm page. I call the stylesheet from the head section of the page by using: link href=css/main.cfm rel=stylesheet type=text/css media=all Yes, the css file is a cfm page because I need to have dynamic colors in the css for each individual site. (the code houses various versions of the site). It is not working. I am not getting any of the css or the cf variables displayed. Any suggestions? Thanks! JH ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277324 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSS Help
I would expect it would need to be a cfinclude rather than a linkref. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Jim H To: CF-Talk Sent: Tue May 08 18:31:31 2007 Subject: CSS Help Ok, I am beating my brain on the table again. I have a css stylesheet attached to a cfm page. I call the stylesheet from the head section of the page by using: link href=css/main.cfm rel=stylesheet type=text/css media=all Yes, the css file is a cfm page because I need to have dynamic colors in the css for each individual site. (the code houses various versions of the site). It is not working. I am not getting any of the css or the cf variables displayed. Any suggestions? Thanks! JH ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277323 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Add Together Values of Dyanamic Fields
Yes, that was very helpful. Thanks a lot! Without specifics, I can give you a general example: Var objForm = document.forms[ 0 ]; Var objInput1 = objForm.elements[ dynamic_field_1 ]; Var objInput2 = objForm.elements[ dynamic_field_2 ]; Var objInput3 = objForm.elements[ dynamic_result ]; objInput3.value = (objInput1.value * 1) + (objInput2.value * 1); Of course, there is no validation here. I have to *1 to make sure that it KNOWS not to do string concatenation, but rather mathematical addition. Does that help? . Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Joel Watson [mailto:[EMAIL PROTECTED] Sent: Friday, May 04, 2007 10:39 AM To: CF-Talk Subject: Add Together Values of Dyanamic Fields I have a form in which several of the fields are generated dynamically based on the choice of the user. I would like to be able to somehow grab the entered values of the fields (client-side) and add them together into another field before the form is submitted. I realize that technically this is a client-side question, but was hoping that someone might have run across/done this before. Thanks! ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277325 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CSS Help
It is not working. I am not getting any of the css or the cf variables displayed. I think you need to do cfinclude to do what you are trying to do. CF won't process the file unless you cfinclude it. And, I bet there's some restriction on using a .css extension when linking to a stylesheet, though I'm not sure. -- Josh ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Add Together Values of Dyanamic Fields
Sweeet. -Original Message- From: Joel Watson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 08, 2007 2:42 PM To: CF-Talk Subject: Re: Add Together Values of Dyanamic Fields Yes, that was very helpful. Thanks a lot! ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277327 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4