Re: MySQL vs PostgreSQL
Aaron Roberson wrote: pgAdmin III comes installed out of the box with PostgreSQL and I cannot figure out how to create tables using it either. At least in phpPgAdmin I can write SQL directly to create tables, but phpMyAdmin has UI features for creating tables. I would prefer using phpPgAdmin since I am so familiar with phpMyAdmin. However, if I went to work for a company that used PostgreSQL with anything other than PHP I could bet that they wouldn't use phpPgAdmin. You should give the command line client (psql) a try. A command line client may sound archaic, but it offers some pretty nifty advantages: - you can run it over a remote shell; - it can do anything a GUI can, and some things a GUI can not; - you keep up to date with your SQL; - it is incredibly feature rich (inline help, tab auto-complete, statement history etc.). Especially the tab auto-complete is a great feature. You just type the first few characters, press tab and the client completes it for you. Very similar to how tab auto-complete works in the Windows or Unix command line, it saves you a ton of typing and you don't have to switch between keyboard and mouse all the time as you have to do in a GUI. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the name of that CF server...
Christopher Jordan wrote: Smith looks cool, but (last time I checked) it doesn't support CFCs! Yikes. I would love to see it go open source and all that, but I wouldn't use it until it supports CFCs. Would you use it, or would you support it? Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263692 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flash Player 8+ requirement for an App
On Monday 11 December 2006 21:14, OÄuz Demirkapı wrote: their clients issues to update Flash Player. They have some important clients which do not have any rights to update any software on their computers as policy and they can not update into the current Flash Player and this is a big issue for us now. Now is a time for them to engage then. Play the 'flash 9 is more secure' card if you have to. At the end of the day, if they really like the app, they'll update. -- Tom Chiverton Helping to authoritatively orchestrate seamless deliverables 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://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263693 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
last updated date from MySql database
Hi, I want to show the last updated date on a site. Rather than do this manually, is there a way I can get this programatically for a table in mySQL? Also, is it possible with an MSACCESS database? Part of the site runs on an old access database, so rather than update it all (they don't want to pay for it) it would be cool to grab all these dates from the databases and compare them to find the most recent one. Thanks in advance guys Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263694 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL vs PostgreSQL
Jochem van Dieten wrote: You should give the command line client (psql) a try. A command line client may sound archaic, but it offers some pretty nifty advantages: and of course it will put hair on your chest. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263695 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flash Player 8+ requirement for an App
O?uz Demirkap? wrote: If you have an application which requires Flash 8+ to run but your client`s clients could not update their Flash player because of lack of knowledge or without having required rights. What would you suggest to your client? Send him 2 quotes, one for the application using Flash 8, one for the application using a custom workaround to work without Flash 8. Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263696 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Dynamicaly Building CFSTOREDPROC tag, can it be done?
Before I spend a load of time that I really do not have available at present experimenting with this I thought that I would ask the question here. I was wondering if anybody has ever dynamically built a cfstoredproc tag and then executed it. The situation I have is that I have ben asked if it is possible to dynamically build a cfstoredproc tag on the fly when you only know the number and type of parameters and SQL stored procedure name at run time. Has anybody ever done anything like this before? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263697 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: whats the purpose of an objectFactory?
As others are indicating, factories become more and more useful as your application becomes more and more complex. In the first app i built using CFC's, after about a year of iterations and improvements, i had well over 1800 CreateObject() calls in the thing. One day a problem arose because of the mapping to those objects. I wanted to fork the development, maintain the current version and keep going with a new one. So the 2 versions couldn't use the same mapping. I was nervous about doing a search and replace through the whole application, because i wasn't sure if it would break anything. So i carefully stepped through each CreateObject() call. It took me a long time, and i made a few mistakes along the way. All in all, i think it took me the better part of a day more or less to deal with it, after dithering about my approach, working through all those CreateObject() calls, and fixing my mistakes. It was on that day that the usefulness of factories really came home to me. If i had encapsulated all my CreateObject() calls in a factory, i could have simply copied the original, ran a quick search and replace on the copy, and even could have swapped the new factory in for the old one. If i had to possible fix a mapping issue every time i installed an instance of my app, if it were an ASP type of thing, then i'd only need to adjust the factory. Which makes all the instances of my app MUCH more maintainable, because i can roll out bug fixes to all the instances without fiddling with each one. Mike's comment about how CFC use has increased also applied to me. It didn't make sense to use a factory to me at first either. But the need crept up on me. That's the reason i'd suggest to someone for getting into factories early. Encapsulating object creation make your app much more flexible and easy to maintain, down the road. It's really true, even in ColdFusion. Nando On 12/12/06, Mike Kear [EMAIL PROTECTED] wrote: My experience has been thinking i only have a few objects so it's not really worth the effort of building a factory. But i built one anyway for the experience. But when i look at that first OOP project now, a year later, i see my site which was originally going to have only 10 objects now has more than 50. I'm REALLY glad i built the factory now! Once you see how great this OOP thing is, you start bolting on applications like there's no tomorrow, and complexity starts coming looking for you. When you think you are only going to have a few objects, I reckon for most cases, that's only because you have missed something. And you're going to get more complexity anyway. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 12/12/06, Judith Dinowitz [EMAIL PROTECTED] wrote: I'm going to look for some decent example of a objectFactory and do some testing to see if there is a performance hit. That sounds like a great idea. Here is an objectFactory to look at and compare with: http://www.phillnacelli.net/blog/index.cfm/2006/11/21/ObjectFactory-Explained Please let us know what you find. -Aaron Well, as I believe Chris Scott explained in his article ColdSpring Fundamentals (FAQU 2), object factories really make a difference when your application gets highly complex and you start having many more objects to initialize with dependencies... That's what ColdSpring tries to do, to manage the objects for you. If you've only got 8 or 9 objects, then maybe an object factory is not for you. Judith ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263698 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFSearch taking well over 1min to return anything.
I have experienced this with collections that are built up incrementally over time, where basically the index ends up in a very inefficient state. Try re-indexing the collection and see if it improves the query time. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, December 11, 2006 10:38 PM To: CF-Talk Subject: Re: CFSearch taking well over 1min to return anything. Has anyone else experienced this? I have a collection that is taking 90 seconds to do a CFSEARCH. It has probably about 10k-15k records in it. This is only ONE collection and it's doing a simple search. The collection has both files (word, pdf, excel) and data (from custom queries). 90 seconds is just unacceptable and I need to find out WHY it's taking so long and an alternative solution. Any thoughts or suggestions? We are running CFMX 6.1 and cannot upgrade to CFMX 7 at this time. Thanks, Dave ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ts date format
How can I have a search with two dynamic dates; one the day before and one the current day? I current use an Access dbase and have the timereceived field set as date/time. This line works: where timereceived between {ts '2006-12-06 00:00:00'} and {ts '2006-12-09 00:00:00'} But I need it to be dynamic. I tried this: cfset today = #dateformat(now()-1)# where timereceived = '#dateformat(today, -mm-dd)#' but of course it gives a Data type mismatch in criteria expression. error Here is the code: CFQUERY name=get datasource=bbb _log SELECT * FROM bbb where timereceived between {ts '2006-12-06 00:00:00'} and {ts '2006-12-09 00:00:00'} /cfquery Thanks. RO HWW ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263700 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ts date format
Use CreateODBCDate() to format the dates. Also, just an FYI, when you use BETWEEN with date/time fields, you need to accommodate the time part of the field. Generally a DBMS DateDiff() is a better option. --- Ben -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 8:53 AM To: CF-Talk Subject: ts date format How can I have a search with two dynamic dates; one the day before and one the current day? I current use an Access dbase and have the timereceived field set as date/time. This line works: where timereceived between {ts '2006-12-06 00:00:00'} and {ts '2006-12-09 00:00:00'} But I need it to be dynamic. I tried this: cfset today = #dateformat(now()-1)# where timereceived = '#dateformat(today, -mm-dd)#' but of course it gives a Data type mismatch in criteria expression. error Here is the code: CFQUERY name=get datasource=bbb _log SELECT * FROM bbb where timereceived between {ts '2006-12-06 00:00:00'} and {ts '2006-12-09 00:00:00'} /cfquery Thanks. RO HWW ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263701 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ts date format
Orlini, Robert wrote: How can I have a search with two dynamic dates; one the day before and one the current day? I current use an Access dbase and have the timereceived field set as date/time. This line works: where timereceived between {ts '2006-12-06 00:00:00'} and {ts '2006-12-09 00:00:00'} But I need it to be dynamic. I tried this: cfset today = #dateformat(now()-1)# where timereceived = '#dateformat(today, -mm-dd)#' but of course it gives a Data type mismatch in criteria expression. error Here is the code: CFQUERY name=get datasource=bbb _log SELECT * FROM bbb where timereceived between {ts '2006-12-06 00:00:00'} and {ts '2006-12-09 00:00:00'} /cfquery I think you are looking for something like... cfset startdate = now() - 1 cfset enddate = now() + 1 CFQUERY name=get datasource=bbb _log SELECT * FROM bbb where timereceived between #createodbcdate(startdate)# and #createodbcdate(enddate)# /cfquery That will get everything from midnight of the previous day to midnight of the current day. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: whats the purpose of an objectFactory?
PS ... On the way to the post office to check my mail, i realized i forgot to say something in my reply. :-) Your approach of creating all your objects in Application.cfm and placing them in application scope kind of encapsulates your object creation for now. But this approach will break down the moment you need an object in a different scope, say session scope. And the way it seems you are doing it is not as efficient as it could be. I'm looking at your example and assuming it's verbatim: cfset application.objectOne = CreateObject('component', 'cfc.navigation') cfset application.objectTwo = CreateObject('component', 'cfc.users') cfset application.objectThree = CreateObject('component', 'cfc.email') In this way, you recreate the objects for each request. There's little point in using application scope in this case. It would be much more efficient if you created a singleton factory in application.cfm like so (with a double lock as shown, to make sure you have only one instance of the Factory in application scope): cfif NOT StructKeyExists(application,Factory) cflock name=factoryLock Timeout=10 THROWONTIMEOUT=No Type=Exclusive cfif NOT StructKeyExists(application,Factory) cfset application.Factory = CreateObject('component',' cfc.Factory').init(passInAppSettingsHere) /cfif /cflock /cfif And then in Factory.init(), you can instantiate any singletons you need into the variables scope of the factory and they'll persist then effectively in application scope for the duration of your application. A singleton, if you don't know the term, is one and only one instance of an object that persists in application scope in CF. I guess you could also use the term for a server scoped object. --- simple Factory.cfc example --- cffunction name=init access=public returntype=Factory output=no cfargument name=AppSettings type=any required=Yes/ cfset variables.AppSettings = arguments.AppSettings / cfset variables.Navigation = createNavigation() / cfset variables.Navigation.init(variables.AppSettings.getDsn()) / cfreturn this / /cffunction cffunction name=createNavigation access=public returntype=any output=no cfset var Navigation = createObject('component','cfc.Navigation') / cfreturn Navigation / /cffunction cffunction name=getNavigation access=public returntype=any output=no cfreturn variables.Navigation / /cffunction ... When you need your persisted Navigation object somewhere in your application, you can do this: application.Factory.getNavigation ().getBreadcrumb(uniqueIdentifierForThisPage) And if you need the navigation for a particular visitor you, could do something like this: session.navigation = application.Factory.createNavigation() .. session.navigation.setUserRole(session.User.getRole()) session.navigation.getUserNav() The example might be a bit contrived, but i'm only trying to show that with a factory, you can cache objects in application scope within the factory itself, which means you only need to deal with double locking in one place for singletons. Or you can use the same factory to create objects for one time use or session scoped objects. Different people will design factories in different ways, and use different naming conventions for the functions. The more sophisticated your factory, the more flexible and abstract. You could for instance build a load() function something like this: cffunction name=load access=public returntype=any output=false cfargument name=objectName required=Yes type=string / cfargument name=isSingleton default=false type=boolean / cfif arguments.isSingleton IS true cfif StructKeyExists(variables,arguments.objectName) return variables[arguments.objectName] cfelse create arguments.objectName put it in variables scope return variables[arguments.objectName] /cfif cfelse create arguments.objectName return it /cfif /cffunction That's fine, but what if you need to pass in parameters to your init() function? how would you do that? What if one of your parameters is another object? Now we're getting close to ColdSpring, so we might as well use it. But for most people starting out with factories, it's probably easier to get a feel for them using a simple factory you build yourself that has separate create() or get() functions for each object. Once the usefulness of it really clicks, then ColdSpring might be the next step. But i can guarantee to you that factories can be very useful. You just need to take a few more steps into deeper water with your CFC use and it will become apparent. On 12/12/06, Nando [EMAIL PROTECTED] wrote: As others are indicating, factories become more and more useful as your application becomes more and more complex. In the first app i built using CFC's, after about a year of iterations and improvements, i had well over 1800 CreateObject() calls in the
RE: What's the name of that CF server...
I'd be interested in knowing what new things it brings to the table. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, December 11, 2006 4:49 PM To: CF-Talk Subject: RE: What's the name of that CF server... IgniteFusion certainly looks good on the website at initial glance... - It's Free - Custom Tags - UDFs - CFCs - Application and Session Scoping - Stored Procedure Support - Good database compatibility - Small Footprint (2MB) Hmmm doesn't support cfqueryparam, however... I've been using that forever... does everyone still consider that imperative for security? Doesn't use CFSchedule, but Windows Scheduler can take care of that. Doesn't support LSParseCurrency ... problem... Doesn't support LSParseNumber ... problem... (Could Regex's take the place of those fuctions?) Everything else I can live without... Sounds pretty good... ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263704 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: last updated date from MySql database
Resending this. I had a major mailserver problem this am and lost a few mails, so just incase I missed any replies! -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED] Sent: 12 December 2006 09:55 To: CF-Talk Subject: last updated date from MySql database Hi, I want to show the last updated date on a site. Rather than do this manually, is there a way I can get this programatically for a table in mySQL? Also, is it possible with an MSACCESS database? Part of the site runs on an old access database, so rather than update it all (they don't want to pay for it) it would be cool to grab all these dates from the databases and compare them to find the most recent one. Thanks in advance guys Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263705 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wierd IE 7 issue
I encountered the same thing when I first started testing on IE7. If you use the Enter button to submit the form, the submit form element does not get passed. My workaround for this was to create a hidden variable with the same name as the submit button so the action page will test for if isdefined(form.submit) and will find it regardless. Bruce Sorge wrote: Hey, has anyone ran into an issue where ID7 does not pass form variables to the action page? I just had that happen to me an I had to reboot my system and now it works fine. I realize that IE 7 is new, but the client uses IE exclusively and there are already folks here that are using version 7. The only thing that I can think of is that maybe I had too many tabs? I typically have about 5-7 tabs going at once. I think that is not it though. I did google the issue and did not come up with anything. Bruce ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263706 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What's the name of that CF server...
I would think that you could write your own variable sanitizer to make up for the lack of cfqueryparam... WHERE ID = cfx_sanitize type=varchar maxLength=7 value=#form.myVar# / Anyone done something like that? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, December 11, 2006 4:49 PM To: CF-Talk Subject: RE: What's the name of that CF server... IgniteFusion certainly looks good on the website at initial glance... - It's Free - Custom Tags - UDFs - CFCs - Application and Session Scoping - Stored Procedure Support - Good database compatibility - Small Footprint (2MB) Hmmm doesn't support cfqueryparam, however... I've been using that forever... does everyone still consider that imperative for security? Doesn't use CFSchedule, but Windows Scheduler can take care of that. Doesn't support LSParseCurrency ... problem... Doesn't support LSParseNumber ... problem... (Could Regex's take the place of those fuctions?) Everything else I can live without... Sounds pretty good... ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263707 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What's the name of that CF server...
Hmmm doesn't support cfqueryparam, however... I've been using that forever... does everyone still consider that imperative for security? I certainly do. Essentially, you won't be able to use any commercial or open source software with IgnireFusion because pretty much everyone uses cfqueryparam. Or at least, they should =) Doesn't support LSParseCurrency ... problem... Doesn't support LSParseNumber ... problem... You could probably emulate this stuff with Java relatively easily. Sounds pretty good... Not without cfqueryparam, that's for sure. Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ts date format
Jim Wright wrote: CFQUERY name=get datasource=bbb _log SELECT * FROM bbb where timereceived between #createodbcdate(startdate)# and #createodbcdate(enddate)# /cfquery Seeing Ben's post reminded me that this query will eliminate 3.33 milliseconds of time... where timereceived = #createodbcdate(startdate)# and timereceived #createodbcdate(enddate)# should make sure all milliseconds are accounted for. and the monks won't have to find somewhere to put that extra time (Terry Pratchett fans may understand this reference). ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263710 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the name of that CF server...
Peterson, Chris wrote: I would think that you could write your own variable sanitizer to make up for the lack of cfqueryparam... WHERE ID = cfx_sanitize type=varchar maxLength=7 value=#form.myVar# / Anyone done something like that? I suppose you could do that even without a cfx tag, just with a regular custom tag... but I'd call it cf_queryparam =) You'd keep the security functionality, but you'd still lose the performance benefits of cfqueryparam (bind variables) Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263711 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What's the name of that CF server...
Well, you'd have a replacement for the security functionality, but it would be different and it would have to be very well written. A bind parameter is security in itself (in a DB that genuinely supports bind parameters anyway). On 12/12/06, Rick Root [EMAIL PROTECTED] wrote: Peterson, Chris wrote: I would think that you could write your own variable sanitizer to make up for the lack of cfqueryparam... WHERE ID = cfx_sanitize type=varchar maxLength=7 value=#form.myVar# / Anyone done something like that? I suppose you could do that even without a cfx tag, just with a regular custom tag... but I'd call it cf_queryparam =) You'd keep the security functionality, but you'd still lose the performance benefits of cfqueryparam (bind variables) Rick ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263712 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: anyone ever privately buy a domain?
So I'm privately buying a domain from the owner. Is there any proedure or service I could use to protect both of us in this transaction? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UPS API
Ok - I got the basics working. Look for a UPS Package to be released tonight. On 12/11/06, Mary Jo Sminkey [EMAIL PROTECTED] wrote: They should have a developer tools account. I believe I had a Developer account at one time. That was about a year ago so I may be wrong They used to, yes. It was changed a few months ago and even though I *had* a developer account it made me re-register and apply for a UPS account. I was *really* ticked off, what a dumb policy change. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263714 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: last updated date from MySql database
I want to show the last updated date on a site. Rather than do this manually, is there a way I can get this programatically for a table in mySQL? I guess I'm confused. Do you want to show the last time a DB table was updated, or just show the latest record using a time stamp field? If it's the former, you could use an 'on insert' trigger to keep track of updates to the table, but it would be much easier if you just had a date/time field in the table where you put in now() with each insert/update, and then display that on your site. -- My Sites: http://www.techfeed.net/blog/ http://www.cfquickdocs.com/ http://cfformprotect.riaforge.org/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: anyone ever privately buy a domain?
Yeah, purchase with a credit card or through paypal. That way the transaction can be revoked if needed. -Kyle On Dec 12, 2006, at 6:35 AM, Dov Katz wrote: So I'm privately buying a domain from the owner. Is there any proedure or service I could use to protect both of us in this transaction? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263717 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: UPS API
Ray, That is really great to hear. Is the API fairly easy to work with? It seems the coding was easier than the account sign up! Dan On 12/12/06, Raymond Camden [EMAIL PROTECTED] wrote: Ok - I got the basics working. Look for a UPS Package to be released tonight. On 12/11/06, Mary Jo Sminkey [EMAIL PROTECTED] wrote: They should have a developer tools account. I believe I had a Developer account at one time. That was about a year ago so I may be wrong They used to, yes. It was changed a few months ago and even though I *had* a developer account it made me re-register and apply for a UPS account. I was *really* ticked off, what a dumb policy change. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263716 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dynamicaly Building CFSTOREDPROC tag, can it be done?
This can be accomplished in SQL Server without dynamically writing the stored procedure. You have to pass in the maximum number of parameters every time to the stored procedure. To do this, you cfparam all of the proc params above the stored procedure call. Inside of the stored procedure, you detect for the default values of each paramater. If the default value is there, you set the sql variable to null. Now the rea magic is where you use the variable inside of the queries: if @foo = 0 begin select @foo = null end select * from bar b where IsNull(b.foo,'') = IsNull(NullIf(@foo,''),IsNull(b.foo,'')) If @foo is null, the where clause is never executed and all values are returned. If @foo has a value, the where clause is executed and you have a filtered data. So in short, you can any number of variables passed as long as you pass a default value that you detect for inside the procedure. It is also not dynamically written so that the execution plan will stay consistent. Teddy On 12/12/06, Andy Mcshane [EMAIL PROTECTED] wrote: Before I spend a load of time that I really do not have available at present experimenting with this I thought that I would ask the question here. I was wondering if anybody has ever dynamically built a cfstoredproc tag and then executed it. The situation I have is that I have ben asked if it is possible to dynamically build a cfstoredproc tag on the fly when you only know the number and type of parameters and SQL stored procedure name at run time. Has anybody ever done anything like this before? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263718 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: anyone ever privately buy a domain?
So I'm privately buying a domain from the owner. Is there any proedure or service I could use to protect both of us in this transaction? You could use an escrow service. I occasionally do that for high-value transactions. 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! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263720 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dynamicaly Building CFSTOREDPROC tag, can it be done?
Caveat: A fellow developer Allen Underwood demonstrated the perfection of this clauseto me a year ago. Teddy On 12/12/06, Teddy Payne [EMAIL PROTECTED] wrote: This can be accomplished in SQL Server without dynamically writing the stored procedure. You have to pass in the maximum number of parameters every time to the stored procedure. To do this, you cfparam all of the proc params above the stored procedure call. Inside of the stored procedure, you detect for the default values of each paramater. If the default value is there, you set the sql variable to null. Now the rea magic is where you use the variable inside of the queries: if @foo = 0 begin select @foo = null end select * from bar b where IsNull(b.foo,'') = IsNull(NullIf(@foo,''),IsNull(b.foo,'')) If @foo is null, the where clause is never executed and all values are returned. If @foo has a value, the where clause is executed and you have a filtered data. So in short, you can any number of variables passed as long as you pass a default value that you detect for inside the procedure. It is also not dynamically written so that the execution plan will stay consistent. Teddy On 12/12/06, Andy Mcshane [EMAIL PROTECTED] wrote: Before I spend a load of time that I really do not have available at present experimenting with this I thought that I would ask the question here. I was wondering if anybody has ever dynamically built a cfstoredproc tag and then executed it. The situation I have is that I have ben asked if it is possible to dynamically build a cfstoredproc tag on the fly when you only know the number and type of parameters and SQL stored procedure name at run time. Has anybody ever done anything like this before? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOT: anyone ever privately buy a domain?
Or you could use some sort of escrow service. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Kyle Hayes [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 8:45 AM To: CF-Talk Subject: Re: SOT: anyone ever privately buy a domain? Yeah, purchase with a credit card or through paypal. That way the transaction can be revoked if needed. -Kyle On Dec 12, 2006, at 6:35 AM, Dov Katz wrote: So I'm privately buying a domain from the owner. Is there any proedure or service I could use to protect both of us in this transaction? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263722 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamicaly Building CFSTOREDPROC tag, can it be done?
The situation I have is that I have ben asked if it is possible to dynamically build a cfstoredproc tag on the fly when you only know the number and type of parameters and SQL stored procedure name at run time. Has anybody ever done anything like this before? No, I haven't, but you could build it by creating the CF code for the cfstoredproc as strings (with cfset or something), save it to a file, and then cfinclude that file to run it. This is the only way I know of to dynamically create/execute CF code. -- My Sites: http://www.techfeed.net/blog/ http://www.cfquickdocs.com/ http://cfformprotect.riaforge.org/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263721 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: UPS API
It was a bit tricky figuring out the post - but I'm past that now. I plan to have a tech demo (with no docs) by lunch. On 12/12/06, Dan Vega [EMAIL PROTECTED] wrote: Ray, That is really great to hear. Is the API fairly easy to work with? It seems the coding was easier than the account sign up! Dan On 12/12/06, Raymond Camden [EMAIL PROTECTED] wrote: Ok - I got the basics working. Look for a UPS Package to be released tonight. On 12/11/06, Mary Jo Sminkey [EMAIL PROTECTED] wrote: They should have a developer tools account. I believe I had a Developer account at one time. That was about a year ago so I may be wrong They used to, yes. It was changed a few months ago and even though I *had* a developer account it made me re-register and apply for a UPS account. I was *really* ticked off, what a dumb policy change. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263723 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: UPS API
Now you need to make a cfc that automatically signs up for an account and writes all your keys to a .txt file =) Chris -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 10:06 AM To: CF-Talk Subject: Re: UPS API It was a bit tricky figuring out the post - but I'm past that now. I plan to have a tech demo (with no docs) by lunch. On 12/12/06, Dan Vega [EMAIL PROTECTED] wrote: Ray, That is really great to hear. Is the API fairly easy to work with? It seems the coding was easier than the account sign up! Dan On 12/12/06, Raymond Camden [EMAIL PROTECTED] wrote: Ok - I got the basics working. Look for a UPS Package to be released tonight. On 12/11/06, Mary Jo Sminkey [EMAIL PROTECTED] wrote: They should have a developer tools account. I believe I had a Developer account at one time. That was about a year ago so I may be wrong They used to, yes. It was changed a few months ago and even though I *had* a developer account it made me re-register and apply for a UPS account. I was *really* ticked off, what a dumb policy change. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263724 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UPS API
One thing that *is* nice about the UPS API is its support for multi-package shipments. You can send all the items you are shipping and get one single rate back. Very nice. This seems to be something that both Fedex and USPS still haven't caught up with. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263725 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: whats the purpose of an objectFactory?
On 12/12/06, Nando [EMAIL PROTECTED] wrote: In the first app i built using CFC's, after about a year of iterations and improvements, i had well over 1800 CreateObject() calls in the thing. By the power of Greyskull! Are you trying to take over the world with your 1800 objects? ;-) We use a lot of object calls thru out our sites. The way we have managed them is with a masterController. It is mapped to all of the sites and handles all of the work. Sort of MVC but not really. We do use a lot of singletons. I guess that is why I'm having a hard time seeing the benefit of a factory. We can instantiate all the objects we need when the app gets initialized. The app only gets reinitialized when it is necessary. So maybe we don't need to worry about a factory at this point but I still want to learn more about how they can help. I'm going to do some testing to see if there is any cost to using one. When I get the results I'll pass them on to the group. Phil ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263726 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UPS API
Nice - I'll look into it. My first release will just do the simple Address Verification stuff. It is done now - I'm just waiting till lunch to make a zip of it. On 12/12/06, Mary Jo Sminkey [EMAIL PROTECTED] wrote: One thing that *is* nice about the UPS API is its support for multi-package shipments. You can send all the items you are shipping and get one single rate back. Very nice. This seems to be something that both Fedex and USPS still haven't caught up with. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263727 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: What's the name of that CF server...
Hmmm doesn't support cfqueryparam, however... I've been using that forever... does everyone still consider that imperative for security? Yes. Additionally, cfqueryparam has substantial performance benefits as well. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263708 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: whats the purpose of an objectFactory?
I do use this technique. cfif NOT isDefined('application.layout') OR isDefined('url.appInit') I just didn't want to take the time to write it out though. hahaha Thanks for posting that though. I think there are a lot of people that don't know that they need to do these sort of things. Thanks again Nando. On 12/12/06, Nando [EMAIL PROTECTED] wrote: PS ... On the way to the post office to check my mail, i realized i forgot to say something in my reply. :-) Your approach of creating all your objects in Application.cfm and placing them in application scope kind of encapsulates your object creation for now. But this approach will break down the moment you need an object in a different scope, say session scope. And the way it seems you are doing it is not as efficient as it could be. I'm looking at your example and assuming it's verbatim: cfset application.objectOne = CreateObject('component', 'cfc.navigation') cfset application.objectTwo = CreateObject('component', 'cfc.users') cfset application.objectThree = CreateObject('component', 'cfc.email') In this way, you recreate the objects for each request. There's little point in using application scope in this case. It would be much more efficient if you created a singleton factory in application.cfm like so (with a double lock as shown, to make sure you have only one instance of the Factory in application scope): cfif NOT StructKeyExists(application,Factory) cflock name=factoryLock Timeout=10 THROWONTIMEOUT=No Type=Exclusive cfif NOT StructKeyExists(application,Factory) cfset application.Factory = CreateObject('component',' cfc.Factory').init(passInAppSettingsHere) /cfif /cflock /cfif And then in Factory.init(), you can instantiate any singletons you need into the variables scope of the factory and they'll persist then effectively in application scope for the duration of your application. A singleton, if you don't know the term, is one and only one instance of an object that persists in application scope in CF. I guess you could also use the term for a server scoped object. --- simple Factory.cfc example --- cffunction name=init access=public returntype=Factory output=no cfargument name=AppSettings type=any required=Yes/ cfset variables.AppSettings = arguments.AppSettings / cfset variables.Navigation = createNavigation() / cfset variables.Navigation.init(variables.AppSettings.getDsn()) / cfreturn this / /cffunction cffunction name=createNavigation access=public returntype=any output=no cfset var Navigation = createObject('component','cfc.Navigation') / cfreturn Navigation / /cffunction cffunction name=getNavigation access=public returntype=any output=no cfreturn variables.Navigation / /cffunction ... When you need your persisted Navigation object somewhere in your application, you can do this: application.Factory.getNavigation ().getBreadcrumb(uniqueIdentifierForThisPage) And if you need the navigation for a particular visitor you, could do something like this: session.navigation = application.Factory.createNavigation() .. session.navigation.setUserRole(session.User.getRole()) session.navigation.getUserNav() The example might be a bit contrived, but i'm only trying to show that with a factory, you can cache objects in application scope within the factory itself, which means you only need to deal with double locking in one place for singletons. Or you can use the same factory to create objects for one time use or session scoped objects. Different people will design factories in different ways, and use different naming conventions for the functions. The more sophisticated your factory, the more flexible and abstract. You could for instance build a load() function something like this: cffunction name=load access=public returntype=any output=false cfargument name=objectName required=Yes type=string / cfargument name=isSingleton default=false type=boolean / cfif arguments.isSingleton IS true cfif StructKeyExists(variables,arguments.objectName) return variables[arguments.objectName] cfelse create arguments.objectName put it in variables scope return variables[arguments.objectName] /cfif cfelse create arguments.objectName return it /cfif /cffunction That's fine, but what if you need to pass in parameters to your init() function? how would you do that? What if one of your parameters is another object? Now we're getting close to ColdSpring, so we might as well use it. But for most people starting out with factories, it's probably easier to get a feel for them using a simple factory you build yourself that has separate create() or get() functions for each object. Once the usefulness of it really clicks, then ColdSpring might be the next step. But i can guarantee to you
Re: What's the name of that CF server...
I would use it. If I then knew enough about it, I'd participate in forums as part of community support if that's what you're getting at. But as a result of this thread, I've come to realize there are more CFML parsers out there than I had realized. Cheers, Chris Jochem van Dieten wrote: Christopher Jordan wrote: Smith looks cool, but (last time I checked) it doesn't support CFCs! Yikes. I would love to see it go open source and all that, but I wouldn't use it until it supports CFCs. Would you use it, or would you support it? Jochem ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263729 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ts date format
Thanks Jimall is OK now! -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 9:27 AM To: CF-Talk Subject:Re: ts date format Jim Wright wrote: CFQUERY name=get datasource=bbb _log SELECT * FROM bbb where timereceived between #createodbcdate(startdate)# and #createodbcdate(enddate)# /cfquery Seeing Ben's post reminded me that this query will eliminate 3.33 milliseconds of time... where timereceived = #createodbcdate(startdate)# and timereceived #createodbcdate(enddate)# should make sure all milliseconds are accounted for. and the monks won't have to find somewhere to put that extra time (Terry Pratchett fans may understand this reference). ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263730 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: whats the purpose of an objectFactory?
Why would I want to load an object into the application scope just to load more objects? This is one more piece of code that has to be ran, maintained, suck up processes, suck up memory, to explain Wouldn't it be best to just keep it simple and call right to the CFC? It sounds to me like you're using CFCs more as code libraries and less as objects, or that your particular application(s) generally only use singletons (one instance of an object only), like an object that handles security. In these cases factories are next to useless - as you noted why would you want to write a factory to build one instance of an object? Factories build instances of objects for you. And more than that, they may build instances of different objects depending on the input you send to the factory when you request an instance. In the simpler case, elsewhere in this thread someone already pointed out the benefits of using a simple factory for instantiation of a single object type when you are creating lots of those objects - you consolidate initialization of the object in one place, simplifying your code and making maintenance easier. Consider a hypothetical situation... I work at a university. So I might have objects that represent Faculty, Staff, and Students, all inhieriting from a Person class. I could use the factory to decide for me whether I need to instantiate a Faculty, Staff, or Student at runtime, and to centralize that decision making activity for me. Another example would be a factory that creates instance of objects that wrap remote services.. If you had a class that generically implemented access to various kinds of remote data (XML files, CFCs, web services, etc). The implementation of those classes would be different for each type of call, but the interface - the properties and method definitions - would be the same. At runtime the application wouldn't need to care if it was holding a RemoteCallCFC or a RemoteCallWebService. A factory would determine which class was necessary, instantiate it, initialize it, and pass it back to the requesting program. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263731 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
returntype=boolean error.
Still trying to work through various issues setting up a web service to perform a number of different functions. Below should insert a record into the database. But I'm getting: faultDetail: {http://xml.apache.org/axis/}stackTrace:org.xml.sax.SAXException: Bad types (boolean - class coldfusion.xml.rpc.QueryBean) What's wrong with the type? Boolean is a correct value, right? cffunction name=newCLIENT access=remote returntype=boolean hint=Add a New Client cfargument name=WSClientName type=string / cfquery INSERT INTO ClientInfo (ClientName) VALUES ( cfqueryparam cfsqltype=CF_SQL_VARCHAR null=false value=#WSClientName# /) /cfquery cfreturn true /cffunction ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263732 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFC's
I came across this post where people were discussing the use of smith as an alternative to CFMX. Anyways, I was wondering what other peoples thoughts on the subject were. I have to agree that Macromedia Coldfusion is kind of getting away from what made CFML so popular and that was rapid developement. It seems that it is taking me twice as long to write alot of the code (using CFC's) then it did before hand, and the complication level has also increased. I am afraid to look at CFMX 8 as I feel that OO is the way CF is going. Message: While more competition in the CFML market is a great thing, this engine won't run any of the popular frameworks as it is missing one of the most important features of CFML; CFCs!!! Think of saying you have developed a Java engine, but it doesn't support user defined classes! Not much point. So yes, if all an engine had to do was to support simple Tags and CFML functions, then of coure it would be fast. Reply: Actually, I regard this as a Good Thing. CF is a champion for pounding out small sites quickly. I'd go as far to say that in that capacity probably nothing can beat it. I haven't seen anything that beats cfquery cfoutput. CFCs tried to bring objects and OO to CF, and they've gone a long way to destroying the principal strength of the language - simplicity. Take a look at the CF community these days and most of what you'll find is intellectual masturbation. They're going down the same road Java went down recently. A proliferation of frameworks, to the point where they have numerous ORMs and even a Spring clone. You have to wonder if at any point these guys don't say, Hmm, why don't we just use Java? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263733 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFC's
Wow, my experience is exactly the opposite. CFC's for me allow granularity - each named function has 1 purpose. I control its input and its output, and I can test it independent of any other code. I tend to write all my functions, and then just wire them up in a separate template. As far as where CF8 is going, remember you don't have to use CFC's if they don't work well for you, you can still do old-skool UDF's, CFX_ tags, etc. Do it how you want, its just a new option available! Chris -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 10:50 AM To: CF-Talk Subject: CFC's I came across this post where people were discussing the use of smith as an alternative to CFMX. Anyways, I was wondering what other peoples thoughts on the subject were. I have to agree that Macromedia Coldfusion is kind of getting away from what made CFML so popular and that was rapid developement. It seems that it is taking me twice as long to write alot of the code (using CFC's) then it did before hand, and the complication level has also increased. I am afraid to look at CFMX 8 as I feel that OO is the way CF is going. Message: While more competition in the CFML market is a great thing, this engine won't run any of the popular frameworks as it is missing one of the most important features of CFML; CFCs!!! Think of saying you have developed a Java engine, but it doesn't support user defined classes! Not much point. So yes, if all an engine had to do was to support simple Tags and CFML functions, then of coure it would be fast. Reply: Actually, I regard this as a Good Thing. CF is a champion for pounding out small sites quickly. I'd go as far to say that in that capacity probably nothing can beat it. I haven't seen anything that beats cfquery cfoutput. CFCs tried to bring objects and OO to CF, and they've gone a long way to destroying the principal strength of the language - simplicity. Take a look at the CF community these days and most of what you'll find is intellectual masturbation. They're going down the same road Java went down recently. A proliferation of frameworks, to the point where they have numerous ORMs and even a Spring clone. You have to wonder if at any point these guys don't say, Hmm, why don't we just use Java? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263734 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFC's
I think the exact opposite. CFC's have increased my code reusability, which significantly speeds up my development time. Not to mention the ease of maintenance that it brings to the table. Old-school spaghetti code isn't going to save you any time when it comes to maintenance and portability. I'd argue that CFC's speed up the rapid development that we've all come to love about CF. I also don't think that CFC's are that difficult to learn. Just like regular coding, it takes time to learn the most efficient way to get your result, but the basics are not that daunting. Anyways, that's my (differing) opinion. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 10:50 AM To: CF-Talk Subject: CFC's I came across this post where people were discussing the use of smith as an alternative to CFMX. Anyways, I was wondering what other peoples thoughts on the subject were. I have to agree that Macromedia Coldfusion is kind of getting away from what made CFML so popular and that was rapid developement. It seems that it is taking me twice as long to write alot of the code (using CFC's) then it did before hand, and the complication level has also increased. I am afraid to look at CFMX 8 as I feel that OO is the way CF is going. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263735 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFFORM: select checkboxes I need help
Is there any special recipe I'm missing in order to get select and checkboxes to work with cfform? Here's what I have. table width=100% border=0CFform action=#CGI.SCRIPT_NAME# method=post name=baby_picture_upload ENCTYPE = multipart/form-data scriptsrc=../../../cfide/scripts/ tr td width=36% align=rightYour First Name:/td td width=64%cfinput name=first_name required=yes message=First Name is Required. validateat=onsubmit type=text class=formfield id=first_name/td /tr CFQUERY name=get_states datasource=#datasource# select * from dbo.tbl_states order by stateAbbrev ASC /CFQUERY tr td align=rightLast Name:/td tdcfinput name=last_name required=yes message=Last Name is required. validateat=onsubmit type=text class=formfield id=last_name/td /tr tr td align=rightCity/td tdcfinput name=city required=yes message=City is required. validateat=onsubmit type=text class=formfield id=city State: cfselect name=state query=get_states value=stateAbbrev display=stateAbbrev required=yes message=State is require size=1 option value= selected=selectedST/option /cfselect /td /tr tr td align=rightEmail:/td tdcfinput name=email required=yes message=A valid email address is required. validate=email validateat=onsubmit type=text class=formfield id=email /td /tr tr td align=rightChild's First Name:/td tdcfinput name=babys_name required=yes message=Child's First Name is Required. validateat=onsubmit type=text class=formfield id=babys_name/td /tr tr td align=rightChild's Birthday:/td td!--- MONTH --- cfselect name=birthmonth required=yes message=The Month value of the Birthday is required. option value=MM/option option value=0101/option option value=0202/option option value=0303/option option value=0404/option option value=0505/option option value=0606/option option value=0707/option option value=0808/option option value=0909/option option value=1010/option option value=/option option value=1212/option /cfselect !--- DAY --- cfselect name=birthday required=yes message=The Day value of the birthday is required. optionDD/option option value=0101/option option value=0202/option option value=0303/option option value=0404/option option value=0505/option option value=0606/option option value=0707/option option value=0808/option option value=0909/option option value=1010/option option value=/option option value=1212/option option value=1313/option option value=1414/option option value=1515/option option value=1616/option option value=1717/option option value=1718/option option value=1919/option option value=2020/option option value=2121/option option value=/option option value=2323/option option value=2424/option option value=2525/option option value=2626/option option value=2727/option option value=2828/option option value=2929/option option value=3030/option option value=3131/option /cfselect !--- YEAR --- cfselect name=birthyear required=yes message=The Year value of the birthday is required. option/option option value=20032003/option option value=20042004/option option value=20052005/option option value=20062006/option /cfselect/td /tr tr td align=rightChild's age in picture:/td tdcfselect name=babyspictureage required=yes message=Child's age in picture is required option value= selected=selectedSelect Age/option option value=99 Months/option option value=210 Months/option option value=211 Months/option option value=212 Months/option option value=213 Months/option option value=214 Months/option option value=215 Months/option option value=216 Months/option option value=217 Months/option option value=218 Months/option option value=219 Months/option option value=320 Months/option option value=321 Months/option option value=322 Months/option option value=323 Months/option option value=324 Months/option /cfselect/td /tr tr td align=rightAre you the legal
RE: CFC's
Wow, both our replies had the same thoughts, and we even both said 'old-school', ha! Chris -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 11:01 AM To: CF-Talk Subject: RE: CFC's I think the exact opposite. CFC's have increased my code reusability, which significantly speeds up my development time. Not to mention the ease of maintenance that it brings to the table. Old-school spaghetti code isn't going to save you any time when it comes to maintenance and portability. I'd argue that CFC's speed up the rapid development that we've all come to love about CF. I also don't think that CFC's are that difficult to learn. Just like regular coding, it takes time to learn the most efficient way to get your result, but the basics are not that daunting. Anyways, that's my (differing) opinion. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 10:50 AM To: CF-Talk Subject: CFC's I came across this post where people were discussing the use of smith as an alternative to CFMX. Anyways, I was wondering what other peoples thoughts on the subject were. I have to agree that Macromedia Coldfusion is kind of getting away from what made CFML so popular and that was rapid developement. It seems that it is taking me twice as long to write alot of the code (using CFC's) then it did before hand, and the complication level has also increased. I am afraid to look at CFMX 8 as I feel that OO is the way CF is going. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263737 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC's
Actually, I regard this as a Good Thing. CF is a champion for pounding out small sites quickly. I'd go as far to say that in that capacity probably nothing can beat it. I haven't seen anything that beats cfquery cfoutput. CFCs tried to bring objects and OO to CF, and they've gone a long way to destroying the principal strength of the language - simplicity. You know, just because something exists in the language, that doesn't mean you're required to use it if you don't want to. That said, some people do things other than pounding out small sites quickly, and their needs may therefore be a little different from yours. And in my experience, many of those small sites that get pounded out so quickly, need to be extended and maintained to be useful over time; I've come to regret some of the pounding I did. Take a look at the CF community these days and most of what you'll find is intellectual masturbation. They're going down the same road Java went down recently. A proliferation of frameworks, to the point where they have numerous ORMs and even a Spring clone. You have to wonder if at any point these guys don't say, Hmm, why don't we just use Java? I do think that programmers tend to overthink things sometimes, and reading CF OO discussions often seems like a variation of how many angels can dance on the head of a pin, but I wouldn't categorize the community effort to implement OO concepts intellectual masturbation, since these concepts can be very useful. They tend to be more useful as your applications become larger and more complex. Why do you think CF, and Java, and web developers in general are going in this direction, if these problems aren't worth solving? 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! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC's
Well, I agree and disagree at the same time I suppose. I honestly believe that most folks on here found ways of making their code modular using different frameworks. Mainly by the use of cfmodule and cfinclude. For me, I really do not care one way or another as far as using CFC's, I think alot of it though is overplay. It seems to me to be alot easier to write queries and do an cfinclude then it is to write out cfcomponentcffunctioncfargument etc. etc. I think if a developer is getting into SOAP and other things like that, then the use of CFC's would be more needed. Of couse that is just my view. Doug - Original Message - From: Peterson, Chris [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, December 12, 2006 8:59 AM Subject: RE: CFC's Wow, both our replies had the same thoughts, and we even both said 'old-school', ha! Chris -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 11:01 AM To: CF-Talk Subject: RE: CFC's I think the exact opposite. CFC's have increased my code reusability, which significantly speeds up my development time. Not to mention the ease of maintenance that it brings to the table. Old-school spaghetti code isn't going to save you any time when it comes to maintenance and portability. I'd argue that CFC's speed up the rapid development that we've all come to love about CF. I also don't think that CFC's are that difficult to learn. Just like regular coding, it takes time to learn the most efficient way to get your result, but the basics are not that daunting. Anyways, that's my (differing) opinion. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 10:50 AM To: CF-Talk Subject: CFC's I came across this post where people were discussing the use of smith as an alternative to CFMX. Anyways, I was wondering what other peoples thoughts on the subject were. I have to agree that Macromedia Coldfusion is kind of getting away from what made CFML so popular and that was rapid developement. It seems that it is taking me twice as long to write alot of the code (using CFC's) then it did before hand, and the complication level has also increased. I am afraid to look at CFMX 8 as I feel that OO is the way CF is going. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263739 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFC's
Huzzah! -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 10:59 AM To: CF-Talk Subject: RE: CFC's Importance: High Wow, both our replies had the same thoughts, and we even both said 'old-school', ha! Chris -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 11:01 AM To: CF-Talk Subject: RE: CFC's I think the exact opposite. CFC's have increased my code reusability, which significantly speeds up my development time. Not to mention the ease of maintenance that it brings to the table. Old-school spaghetti code isn't going to save you any time when it comes to maintenance and portability. I'd argue that CFC's speed up the rapid development that we've all come to love about CF. I also don't think that CFC's are that difficult to learn. Just like regular coding, it takes time to learn the most efficient way to get your result, but the basics are not that daunting. Anyways, that's my (differing) opinion. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 10:50 AM To: CF-Talk Subject: CFC's I came across this post where people were discussing the use of smith as an alternative to CFMX. Anyways, I was wondering what other peoples thoughts on the subject were. I have to agree that Macromedia Coldfusion is kind of getting away from what made CFML so popular and that was rapid developement. It seems that it is taking me twice as long to write alot of the code (using CFC's) then it did before hand, and the complication level has also increased. I am afraid to look at CFMX 8 as I feel that OO is the way CF is going. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263740 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFC's
Doug, You are confusing a few different ideas here I think ... Yes, there is a lot of chat nowadays about frameworks and methodologies and the like. But that has nothing to do with CFCs really. Fusebox, for example, existed long before CFCs were introduced. I think what you are seeing is that many CFers have matured, their apps are more sophisticated, they have been introduced to concepts and practices popularized buy other languages, and they are trying to apply that thinking back to ColdFusion. And that's great, if it works for you. If it does not, then do what you do now. With the exception of a few features (creating web services, writing Flex back-ends in CF, and working with event gateways, to name a few), CFCs are entirely optional. Having said that, I don't believe that CFCs themselves have introduced OOP type complexity. Sure, CFCs can be part of a more sophisticated application architecture, but hey are also useful as an organization mechanism when building simple n-tier apps. Look at it this way, all of those cfinclude and Custom Tags that we built for years as a way to organize our code, well, CFCs are often better suited for the task. It's nothing to do with OOP if you don't want it to be. And as for I am afraid to look at CFMX 8 as I feel that OO is the way CF is going, fear not. We'll add object type functionality when and if it makes sense, but we have no intentions of losing what made CF CF in the first place, simplicity and productivity. --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 10:50 AM To: CF-Talk Subject: CFC's I came across this post where people were discussing the use of smith as an alternative to CFMX. Anyways, I was wondering what other peoples thoughts on the subject were. I have to agree that Macromedia Coldfusion is kind of getting away from what made CFML so popular and that was rapid developement. It seems that it is taking me twice as long to write alot of the code (using CFC's) then it did before hand, and the complication level has also increased. I am afraid to look at CFMX 8 as I feel that OO is the way CF is going. Message: While more competition in the CFML market is a great thing, this engine won't run any of the popular frameworks as it is missing one of the most important features of CFML; CFCs!!! Think of saying you have developed a Java engine, but it doesn't support user defined classes! Not much point. So yes, if all an engine had to do was to support simple Tags and CFML functions, then of coure it would be fast. Reply: Actually, I regard this as a Good Thing. CF is a champion for pounding out small sites quickly. I'd go as far to say that in that capacity probably nothing can beat it. I haven't seen anything that beats cfquery cfoutput. CFCs tried to bring objects and OO to CF, and they've gone a long way to destroying the principal strength of the language - simplicity. Take a look at the CF community these days and most of what you'll find is intellectual masturbation. They're going down the same road Java went down recently. A proliferation of frameworks, to the point where they have numerous ORMs and even a Spring clone. You have to wonder if at any point these guys don't say, Hmm, why don't we just use Java? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263741 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC's
Doug, Doug Brown wrote: I came across this post where people were discussing the use of smith as an alternative to CFMX. Anyways, I was wondering what other peoples thoughts on the subject were. I have to agree that Macromedia Coldfusion is kind of getting away from what made CFML so popular and that was rapid developement. It seems that it is taking me twice as long to write alot of the code (using CFC's) then it did before hand, and the complication level has also increased. I am afraid to look at CFMX 8 as I feel that OO is the way CF is going. I'm not an OO programmer, but I still reckon that going OO is the right path for CF to take. Message: While more competition in the CFML market is a great thing, this engine won't run any of the popular frameworks as it is missing one of the most important features of CFML; CFCs!!! Think of saying you have developed a Java engine, but it doesn't support user defined classes! Not much point. So yes, if all an engine had to do was to support simple Tags and CFML functions, then of coure it would be fast. Reply: Actually, I regard this as a Good Thing. CF is a champion for pounding out small sites quickly. The good news here, is that CF still is very good at pounding out small sites. I think the idea that that CF has the potential for much, much more than creating small sites. It's got the capacity to build complex Web2.0-type applications. The OO features that have been added only help to further development in that direction. There's no rule that says you *have to* use them. I'd go as far to say that in that capacity probably nothing can beat it. I haven't seen anything that beats cfquery cfoutput. CFCs tried to bring objects and OO to CF, and they've gone a long way to destroying the principal strength of the language - simplicity. In what ways have they destroyed the language. I can still use simple coding techniques, just as I could with CF4.5 and CF5. The addition of the new techniques doesn't mean you have to use them. They're just additional tools in the tool box. Take a look at the CF community these days and most of what you'll find is intellectual masturbation. Hmm... that's a bit crude, if you ask me. When I look at the CF community today, I see folks collaborating and trying to make things better for other developers. I see more experienced developers trying to help out newer developers. I also see folks defending CF against PHP, Ruby and the like. They're going down the same road Java went down recently. A proliferation of frameworks, to the point where they have numerous ORMs and even a Spring clone. I don't use a single framework in my coding, though I think I can see the benefit, I've just not spent the time to learn one. So again, just use the tools in the tool box that you need and ignore the rest. You have to wonder if at any point these guys don't say, Hmm, why don't we just use Java? One of the beauties of CF is that you can intermix it with java, because the thing is written in java but you don't have to. Cheers, Chris ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263742 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC's
Straight from the horses mouth -- as it were ;o). Very well put Ben. Thanks. Cheers, Chris Ben Forta wrote: Doug, You are confusing a few different ideas here I think ... Yes, there is a lot of chat nowadays about frameworks and methodologies and the like. But that has nothing to do with CFCs really. Fusebox, for example, existed long before CFCs were introduced. I think what you are seeing is that many CFers have matured, their apps are more sophisticated, they have been introduced to concepts and practices popularized buy other languages, and they are trying to apply that thinking back to ColdFusion. And that's great, if it works for you. If it does not, then do what you do now. With the exception of a few features (creating web services, writing Flex back-ends in CF, and working with event gateways, to name a few), CFCs are entirely optional. Having said that, I don't believe that CFCs themselves have introduced OOP type complexity. Sure, CFCs can be part of a more sophisticated application architecture, but hey are also useful as an organization mechanism when building simple n-tier apps. Look at it this way, all of those cfinclude and Custom Tags that we built for years as a way to organize our code, well, CFCs are often better suited for the task. It's nothing to do with OOP if you don't want it to be. And as for I am afraid to look at CFMX 8 as I feel that OO is the way CF is going, fear not. We'll add object type functionality when and if it makes sense, but we have no intentions of losing what made CF CF in the first place, simplicity and productivity. --- Ben -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 10:50 AM To: CF-Talk Subject: CFC's I came across this post where people were discussing the use of smith as an alternative to CFMX. Anyways, I was wondering what other peoples thoughts on the subject were. I have to agree that Macromedia Coldfusion is kind of getting away from what made CFML so popular and that was rapid developement. It seems that it is taking me twice as long to write alot of the code (using CFC's) then it did before hand, and the complication level has also increased. I am afraid to look at CFMX 8 as I feel that OO is the way CF is going. Message: While more competition in the CFML market is a great thing, this engine won't run any of the popular frameworks as it is missing one of the most important features of CFML; CFCs!!! Think of saying you have developed a Java engine, but it doesn't support user defined classes! Not much point. So yes, if all an engine had to do was to support simple Tags and CFML functions, then of coure it would be fast. Reply: Actually, I regard this as a Good Thing. CF is a champion for pounding out small sites quickly. I'd go as far to say that in that capacity probably nothing can beat it. I haven't seen anything that beats cfquery cfoutput. CFCs tried to bring objects and OO to CF, and they've gone a long way to destroying the principal strength of the language - simplicity. Take a look at the CF community these days and most of what you'll find is intellectual masturbation. They're going down the same road Java went down recently. A proliferation of frameworks, to the point where they have numerous ORMs and even a Spring clone. You have to wonder if at any point these guys don't say, Hmm, why don't we just use Java? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263743 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC's
Reply: Actually, I regard this as a Good Thing. CF is a champion for pounding out small sites quickly. I'd go as far to say that in that capacity probably nothing can beat it. I haven't seen anything that beats cfquery cfoutput. CFCs tried to bring objects and OO to CF, and they've gone a long way to destroying the principal strength of the language - simplicity. Take a look at the CF community these days and most of what you'll find is intellectual masturbation. They're going down the same road Java went down recently. A proliferation of frameworks, to the point where they have numerous ORMs and even a Spring clone. You have to wonder if at any point these guys don't say, Hmm, why don't we just use Java? Please keep in mind that this was not my writing, but the writing of someone else who was posting to a message board. I do not want anyone to think that we are masturbating around here :) I think the discussions that the community has are outstanding. I think I was just wondering where exactly CF was headed and if it will continue to be the product that everyone came to love by providing simplicity in design. Doug ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263744 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC's
I am new to CFC's. For a long time I could not see the practical pupose of them other than to get us CF'ers to go the way of OOP. (also, all of last year and half of 2004 was spent preparing and being in Iraq, and when I returned my job changed from CF to .NET, so I have been out of the CF programming game for a while). So after reviewing them some more I have come to realize that they are great. I am using them quite extensively now on some applications that I am currently doing. I have already saved time by not having to type the same query 2 or threee times. I like that if I need to change a query, rather then do it over X pages (assuming a year or two I remember where they are all at), I change it in one place. I am sure I can do this using a custom tag, but I think that the CFC method is more intuitive. Ben Forta has some articles on line that extol the positive attributes of CFC's, and really that is how I started to look at them again. Thanks Ben for showing me the light. Bruce ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263745 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Buying CF7 Standard in bulk / cheapest prices? OEM?
Hey all, I'm in the market to buy two licenses to CF7 Standard, like, yesterday. And starting in January we hope to need to buy on the order of ten per month. Any suggestions for best prices? Any bulk sellers? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263746 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: last updated date from MySql database
Hi Jacob, I just want to check the last time a table was updated and display that time on the homepage. I know I can write some code that marks the time of an update or insert into the database and use that, but I noticed that mySQL tables have an update time on them, and wondered if I can shortcut and just use that data. There are a number of tables that can be updated, so I'd need to check them all, compare the updated times and only show the most recent. Does that make more sense? Cheers Will -Original Message- From: Jacob Munson [mailto:[EMAIL PROTECTED] Sent: 12 December 2006 14:43 To: CF-Talk Subject: Re: last updated date from MySql database I want to show the last updated date on a site. Rather than do this manually, is there a way I can get this programatically for a table in mySQL? I guess I'm confused. Do you want to show the last time a DB table was updated, or just show the latest record using a time stamp field? If it's the former, you could use an 'on insert' trigger to keep track of updates to the table, but it would be much easier if you just had a date/time field in the table where you put in now() with each insert/update, and then display that on your site. -- My Sites: http://www.techfeed.net/blog/ http://www.cfquickdocs.com/ http://cfformprotect.riaforge.org/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263747 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wierd IE 7 issue
Cool, so I am not the only one. I am sure that M$ is aware of this and hopefully will issue a fix. On 12/12/06, Jake Churchill [EMAIL PROTECTED] wrote: I encountered the same thing when I first started testing on IE7. If you use the Enter button to submit the form, the submit form element does not get passed. My workaround for this was to create a hidden variable with the same name as the submit button so the action page will test for if isdefined(form.submit) and will find it regardless. Bruce Sorge wrote: Hey, has anyone ran into an issue where ID7 does not pass form variables to the action page? I just had that happen to me an I had to reboot my system and now it works fine. I realize that IE 7 is new, but the client uses IE exclusively and there are already folks here that are using version 7. The only thing that I can think of is that maybe I had too many tabs? I typically have about 5-7 tabs going at once. I think that is not it though. I did google the issue and did not come up with anything. Bruce ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263748 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFSearch taking well over 1min to return anything.
I have experienced this with collections that are built up incrementally over time, where basically the index ends up in a very inefficient state. Try re-indexing the collection and see if it improves the query time. When you say 're-index' the collection, do you mean to do a purge and then cfindex again? We do that every week. We are finding though the same results you are mentioning and that maybe we should delete the collection and start fresh every week. Any other thoughts? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263749 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFSEARCH restarting ColdFusion in MX 6.1
Has anyone had any problems with the CFSEARCH tag causing CF to restart in MX 6.1? If so, what did you do to resolve? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263750 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: TinyMCE editor question
Those are conditional statements left in by word: You'll need to tell TinyMCE to strip them: Look at the TinyMCE documentation - there's a config there which helps you get towards XHTML compliance - use that in combination with parsing the string to strip out all the crap. T On 9 Dec 2006, at 00:37, Victor Moore wrote: Hi all, I have installed TinyMCE editor on a site and while it was easy to install and work with, has some issue: For example if a user copy and paste content from MS-Word 2003 using Firefox, everything looks OK in Firefox but it displays: !--[if !supportLists]--â !--[endif]-- when viewing the page with IE. If the same exercise is done using IE all the line breaks are removed. Is anything that can be done or is just bad luck using content from MS-Word Thanks Victor PS If anybody has an example cfm page of using FCKeditor, really appreciate. I have to fix this ASAP ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263751 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFC's
On Tuesday 12 December 2006 16:17, Ben Forta wrote: seeing is that many CFers have matured, their apps are more sophisticated, they have been introduced to concepts and practices popularized buy other languages, and they are trying to apply that thinking back to ColdFusion. Indeed. From my point of view, we're now an order of magnitude or more above simply asking the user a few questions on a form and feeding those into a query and printing out the query in a table. We want to break the request/response cycle, we want to make out code testable so we can fix things with out worrying about what we broke, we want to be able to reuse code and we want to be able to use the same code from an AJAX app, a CFML page, and a Flex application. That's just of the top of my head. Doing all that (and more !) with out objects doesn't bear thinking about. So, now we have a lot of objects - there is now a management problem. Over in Java-land they've solved some of these with ORMs and DI systems like Spring and Hibernate - why not take those ideas and reuse them ? This way we get the speed and grace of CFML with the power of Java-like frameworks and methods of working. -- Tom Chiverton Helping to augmentatively leverage revolutionary supply-chains 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://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263752 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC's
On Tuesday 12 December 2006 16:26, Doug Brown wrote: numerous ORMs and even a Spring clone. You have to wonder if at any point these guys don't say, Hmm, why don't we just use Java? Because I once wrote a large site in Java. It was a horrible, horrible experience compaired to ColdFusion. That doesn't mean I didn't learn some things. -- Tom Chiverton Helping to simultaneously enhance market-driven architectures 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://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263753 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
XML
I am kind of new to handling XML in CF. Here is my basic XML data preferences elementView JID view=yes / SKU view=yes / ElementDescription view=yes / ElementType view=yes / TypeOfShot view=yes / SimpleORAdvanced view=yes / Props view=yes / OutlineType view=yes / notes view=yes / careyNotes view=yes / Round view=yes / ElementStatus view=yes / ElementStatusDate view=yes / /elementView /preferences I want to loop over the items in elementView and display the view attribute. Is there a good way of looping over this data and outputting it? Can I somehow get the names of the items, JID, SKU, etc... then use that to dynamically make #session.prefs.preferences.elementView.JID.XMLAttributes.view# #session.prefs.preferences.elementView.SKU.XMLAttributes.view# Etc... I am also new to using the MS SQL datatype XML. Any thing I should know about before I go trying to insert my above XML into the database? Thanks! Chad ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263754 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC's
On Tuesday 12 December 2006 16:19, Christopher Jordan wrote: the benefit, I've just not spent the time to learn one. So again, just use the tools in the tool box that you need and ignore the rest. Just because there is a hammer in the box, doesn't mean you should use a hammer for doing up a screw :-) -- Tom Chiverton Helping to conveniently harness B2C products 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://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263755 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFSearch taking well over 1min to return anything.
Yup - you can just do cfindex action=refresh ... which purges and rebuilds. If your collection changes frequently, you should do this regularly - more than once a week may even be necessary. I generally just set it up in the scheduler to refresh each night and then forget about it. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 10:32 AM To: CF-Talk Subject: Re: CFSearch taking well over 1min to return anything. I have experienced this with collections that are built up incrementally over time, where basically the index ends up in a very inefficient state. Try re-indexing the collection and see if it improves the query time. When you say 're-index' the collection, do you mean to do a purge and then cfindex again? We do that every week. We are finding though the same results you are mentioning and that maybe we should delete the collection and start fresh every week. Any other thoughts? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263756 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Wierd IE 7 issue
I would not hold my breath. I have noticed this behavior on IE 6 as well. Steve Bruce Sorge wrote: Cool, so I am not the only one. I am sure that M$ is aware of this and hopefully will issue a fix. On 12/12/06, Jake Churchill [EMAIL PROTECTED] wrote: I encountered the same thing when I first started testing on IE7. If you use the Enter button to submit the form, the submit form element does not get passed. My workaround for this was to create a hidden variable with the same name as the submit button so the action page will test for if isdefined(form.submit) and will find it regardless. --- --- ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263757 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC's
While the complexity of my CFML has certainly increased in the past several years, so has the complexity of the web applications I am building now. To be honest the master/detail drill down and very basic crud stuff I used to do isn't really around anymore. Now application shave to integrate seamlessly into multiple environments, interface with other applications and services, and generally be much more intense (read enterprise level government development). No I'll grant that for those people that are out there still doing basic web sites and so forth, well, all the complexity is unnecessary, however, CF 8 will I am sure be backwards compatible for the most part, and you will still be able to write procedural CFML if that's your preference. Remember, no one is making you use OO principals. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 10:50 AM To: CF-Talk Subject: CFC's I came across this post where people were discussing the use of smith as an alternative to CFMX. Anyways, I was wondering what other peoples thoughts on the subject were. I have to agree that Macromedia Coldfusion is kind of getting away from what made CFML so popular and that was rapid developement. It seems that it is taking me twice as long to write alot of the code (using CFC's) then it did before hand, and the complication level has also increased. I am afraid to look at CFMX 8 as I feel that OO is the way CF is going. Message: While more competition in the CFML market is a great thing, this engine won't run any of the popular frameworks as it is missing one of the most important features of CFML; CFCs!!! Think of saying you have developed a Java engine, but it doesn't support user defined classes! Not much point. So yes, if all an engine had to do was to support simple Tags and CFML functions, then of coure it would be fast. Reply: Actually, I regard this as a Good Thing. CF is a champion for pounding out small sites quickly. I'd go as far to say that in that capacity probably nothing can beat it. I haven't seen anything that beats cfquery cfoutput. CFCs tried to bring objects and OO to CF, and they've gone a long way to destroying the principal strength of the language - simplicity. Take a look at the CF community these days and most of what you'll find is intellectual masturbation. They're going down the same road Java went down recently. A proliferation of frameworks, to the point where they have numerous ORMs and even a Spring clone. You have to wonder if at any point these guys don't say, Hmm, why don't we just use Java? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263758 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML
The attachement should help you. Teddy On 12/12/06, Chad Gray [EMAIL PROTECTED] wrote: I am kind of new to handling XML in CF. Here is my basic XML data preferences elementView JID view=yes / SKU view=yes / ElementDescription view=yes / ElementType view=yes / TypeOfShot view=yes / SimpleORAdvanced view=yes / Props view=yes / OutlineType view=yes / notes view=yes / careyNotes view=yes / Round view=yes / ElementStatus view=yes / ElementStatusDate view=yes / /elementView /preferences I want to loop over the items in elementView and display the view attribute. Is there a good way of looping over this data and outputting it? Can I somehow get the names of the items, JID, SKU, etc... then use that to dynamically make #session.prefs.preferences.elementView.JID.XMLAttributes.view# #session.prefs.preferences.elementView.SKU.XMLAttributes.view# Etc... I am also new to using the MS SQL datatype XML. Any thing I should know about before I go trying to insert my above XML into the database? Thanks! Chad ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263759 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: XML
The attachment should help you. Teddy Except this list strips all attachments! -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning 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. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263760 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Web Services choke on HTTP Compression?
Thanks, Steven! That is brilliant. I guess I knew that ColdFusion just used the WSDL to generate the stub objects, but I didn't know about the server port element tying it to the actual webservice server. Saving the WSDL to my local machine works like a charm. The only weirdness is that our business partner swears that they don't use HTTP compression on the server. Maybe its just an incompatibility with ColdFusion, Web Services and SSL. Thanks Agan! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263761 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: XML
Hehehe... you can send it to my email. cgray careyweb com -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 12:10 PM To: CF-Talk Subject: RE: XML The attachment should help you. Teddy Except this list strips all attachments! -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning 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. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263762 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC's
word -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 11:47 AM To: CF-Talk Subject: Re: CFC's On Tuesday 12 December 2006 16:19, Christopher Jordan wrote: the benefit, I've just not spent the time to learn one. So again, just use the tools in the tool box that you need and ignore the rest. Just because there is a hammer in the box, doesn't mean you should use a hammer for doing up a screw :-) -- Tom Chiverton Helping to conveniently harness B2C products 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://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263763 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFC's
== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html == ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263764 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Buying CF7 Standard in bulk / cheapest prices? OEM?
I've had good luck with CDW. Michael Muller wrote: Hey all, I'm in the market to buy two licenses to CF7 Standard, like, yesterday. And starting in January we hope to need to buy on the order of ten per month. Any suggestions for best prices? Any bulk sellers? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263765 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: last updated date from MySql database
I just want to check the last time a table was updated and display that time on the homepage. I know I can write some code that marks the time of an update or insert into the database and use that, but I noticed that mySQL tables have an update time on them, and wondered if I can shortcut and just use that data. There are a number of tables that can be updated, so I'd need to check them all, compare the updated times and only show the most recent. Oh, I see. I didn't know mySQL did that. I don't know how you'd access that. How are you seeing this last updated date, from the MySQL Admin? You could google around, there might be something with show tables you could do... ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263766 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Buying CF7 Standard in bulk / cheapest prices? OEM?
I'm in the market to buy two licenses to CF7 Standard, like, yesterday. And starting in January we hope to need to buy on the order of ten per month. Any suggestions for best prices? Any bulk sellers? For your first two licenses, your best bet is just to purchase them from the Adobe Store; that way, you don't have to wait on a delivery since you can use the online delivery option. For subsequent licenses, unfortunately, I don't think that you're going to get a lot of flexibility with pricing, since 10 per month isn't really bulk for most stores. Fig Leaf Software is an Adobe reseller; if you're interested in talking to one of our salespeople about pricing options, let me know offlist. 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! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263767 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Buying CF7 Standard in bulk / cheapest prices? OEM?
Hi Michael, have you ever considered Railo as an exchange for CFMX? Ist's almost 100% compatible to CFMX and is a very performanct alternative. Just check it at www.railo.ch Cheers Gert Franz Railo Technologies GmbH ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263768 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Upload files to IIS Virtual Directory
My goal is to have an internal Intranet site where users can 2 upload files to some internal servers (to replace a manual process we currently do for them). We're using IIS 6, and CF 7. The problem is that this CF server is hosting a lot of existing sites, and we've got it setup to use the local system account, and the other guys on my team are loath to change that to a domain account because of all the other sites. So cffile won't work, because the local system account doesn't have access to the remote shares. I do have a domain account that we could use, but I'm not sure how to do it. We thought about setting up a virtual directory in IIS, and use the domain account for the authentication. This seems to work in IIS (I can see the files on the remote share), but I can't figure out how to write to it using CF. I've tried using cfhttp method=put, with cfhttpparam type=file, but that doesn't work. Any ideas? I'm kind of in over my head with this IIS/domain stuff. -- My Sites: http://www.techfeed.net/blog/ http://www.cfquickdocs.com/ http://cfformprotect.riaforge.org/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263769 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UPS API
http://ray.camdenfamily.com/index.cfm/2006/12/12/First-draft-of-UPS-Package-Released Enjoy. On 12/12/06, Raymond Camden [EMAIL PROTECTED] wrote: Nice - I'll look into it. My first release will just do the simple Address Verification stuff. It is done now - I'm just waiting till lunch to make a zip of it. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263770 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Coldfusion roadmap
Hello, I was wondering if there is a roadmap for Coldfusion like new versions etc... I thought I heard that it was EOL since Adobe bought it but I can't find any info on that. Thanks, -Charles ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263771 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion roadmap
Uh oh, here it goes again! The ever present EOL stuff.. Let's just say, ColdFusion is alive and well.. With a major new version out next year. 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: Charles E. Heizer To: CF-Talk Sent: Tue Dec 12 18:10:29 2006 Subject: Coldfusion roadmap Hello, I was wondering if there is a roadmap for Coldfusion like new versions etc... I thought I heard that it was EOL since Adobe bought it but I can't find any info on that. Thanks, -Charles ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263772 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion roadmap
Hello, I was wondering if there is a roadmap for Coldfusion like new versions etc... I thought I heard that it was EOL since Adobe bought it but I can't find any info on that. It's definitely not EOL, here's the preview site for CF 8 (aka Scropio): http://labs.adobe.com/wiki/index.php/Scorpio -- My Sites: http://www.techfeed.net/blog/ http://www.cfquickdocs.com/ http://cfformprotect.riaforge.org/ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263773 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
File upload max size
Someone was asking recently how you can limit the size of uploaded files, well I just came across this. http://www.cftagstore.com/tags/flashmultipleupload.cfm Russ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263774 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion roadmap
I heard that Elvis is alive and well in a trailer park just outside Milwaukie. I heard that Iraq had WOMD. I heard there were fairies and a talking toadstool at the bottom of my garden. I heard *yawn* Andy (jackanory, jackanory, tra la la la la la) ok, sorry if I'm being really sarcastic but its a well know fact (blogs, mailing lists, Adobe Labs, etc) that CF is NOT going away. On 12/12/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Uh oh, here it goes again! The ever present EOL stuff.. Let's just say, ColdFusion is alive and well.. With a major new version out next year. 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: Charles E. Heizer To: CF-Talk Sent: Tue Dec 12 18:10:29 2006 Subject: Coldfusion roadmap Hello, I was wondering if there is a roadmap for Coldfusion like new versions etc... I thought I heard that it was EOL since Adobe bought it but I can't find any info on that. Thanks, -Charles ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263775 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion roadmap
Actually, I read his post differently. He specifically mentioned new versions. I think he is asking for how long a version of the product is supported. Sort of like Microsoft tells you that they will end support for Version X, Z number of years after Version Y comes out. Steve -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 1:24 PM To: CF-Talk Subject: Re: Coldfusion roadmap I heard that Elvis is alive and well in a trailer park just outside Milwaukie. I heard that Iraq had WOMD. I heard there were fairies and a talking toadstool at the bottom of my garden. I heard *yawn* Andy (jackanory, jackanory, tra la la la la la) ok, sorry if I'm being really sarcastic but its a well know fact (blogs, mailing lists, Adobe Labs, etc) that CF is NOT going away. On 12/12/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Uh oh, here it goes again! The ever present EOL stuff.. Let's just say, ColdFusion is alive and well.. With a major new version out next year. 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: Charles E. Heizer To: CF-Talk Sent: Tue Dec 12 18:10:29 2006 Subject: Coldfusion roadmap Hello, I was wondering if there is a roadmap for Coldfusion like new versions etc... I thought I heard that it was EOL since Adobe bought it but I can't find any info on that. Thanks, -Charles ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263776 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfcUnit
I am running some test cases using cfcUnit, My question is when i ran this test the first time i forgot to pass the datasource to my init method. I have since added it but it still does not see it in the setup? Is this cached, am i missing something? cfcomponent namespace=StudentInterviewTest extends= org.cfcunit.framework.TestCase cfset variables.studentInterview = cffunction name=setup access=private returntype=void cfset variables.studentInterview = createObject(component, StudentInterview).init(mydsn) /cffunction cffunction name=testSendInterviewEmail access=public returntype=void cfset studentInterview.sendInterviewEmail(arg1,arg2) /cffunction /cfcomponent -- Thank You Dan Vega [EMAIL PROTECTED] http://www.danvega.org ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263777 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
TODAY: MDCFUG on Tuesday 12/12/06: CF Admin, Fusebox 5
You are invited to Maryland ColdFusion User Group Meeting on Tuesday 12/12/2006. 6:30pm â CFMX Administrator 'for Dummies' with Jo Ann Goertner 8:00pm â Fusebox 5: what is new with Sandra Clark (Times are Eastern Standard Time) Can't make it to the meeting? Remote access via Adobe chats http://adobechats.adobe.acrobat.com/mdcfug121206/ TeraTech, Inc. 405 E. Gude Dr Suite 207 Rockville, MD 20850 301-424-3903 For a map or for directions: Go to http://www.cfug-md.org/directions/directions.cfm. To enter the TeraTech building after 6:00 pm use the keypad entry system on the right side of the front door. Press the button to select TeraTech on the keypad and hit the call button, press 0 for someone to pick it up and they will let you in. Topic: CFMX Administrator 'for Dummies' In my first 4 years writing, troubleshooting and maintaining ColdFusion code, I have always treated the CF Administrator as someone else's territory. It's my last resort, my afterthought when all else fails. Why? Mostly because it's unfamiliar. I'm afraid I'll break something. And, there's always been someone else I could go to. Great excuses! Yet, there are basic things every CF developer needs to know about the Administrator. Yes, even those of us who don't have primary responsibility to maintain the server. What are they? That's what we'll look at in this presentation. I'm picking the brains of my someone elses and I'll share with you what I learn. If you've had the same excuses I have, I invite you to get over them along with me! Jo Ann Goertner can be reached at joann (at) teratech.com. Topic: Fusebox 5: what is new In this talk, Sandra Clark, will cover Fusebox 5, from new features to backwards compatibility. Along the way, she will touch on: * Using Multiple Fusebox Applications in one ColdFusion Application * New Application Initialization * New Verbs/Syntax available, including nesting! * New Execution Modes, when to use them * Implicit Circuits * Extending the Framework with lexicons. Bio: Sandra Clark, an advanced Macromedia Certified ColdFusion developer, is a Senior Software Developer with the Constella Group in Bethesda, Maryland. She has contributed material to the ColdFusion 5.0 Certified Developer Study Guide published by Syngress Media/Osborne McGraw Hill, and to the ColdFusion Developers Journal. She has also spoken at various CFUGS and ColdFusion User Conferences around the country. Sandra is an active proponent of applying accepted and proven web standards to development as a way of improving accessibility as well as making life easier on developers. Sandra Clark can be reached at slclark (at) shayna.com. -- Michael Smith, TeraTech Inc - Tools for Programmers(tm) TeraTech voted Best Consulting Service by CFDJ readers! CF/ASP Web, VB, Math, Access programming tools and consulting 405 E Gude Dr Ste 207, Rockville MD 20850 USA Please check out http://www.teratech.com/ - email mailto:[EMAIL PROTECTED], or call us for more information; in the USA at 1-800-447-9120, +1-301-424-3903 International, Fax 301-762-8185 Thanks! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263778 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Coldfusion roadmap
I thought I heard that it was EOL since Adobe bought it but I can't find any info on that. Charles, now c'mon, man... I think you answered your own question. :-) And check this out: http://www.flickr.com/photos/amuller/280186935/ Either the oracle of cf is attempting a career-ending exhibition, or he must just be real jazzed on the upcoming CF8. Personally, I really think he'd still like us to buy his books. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- [EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 10:10 AM To: CF-Talk Subject: Re: Coldfusion roadmap Uh oh, here it goes again! The ever present EOL stuff.. Let's just say, ColdFusion is alive and well.. With a major new version out next year. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263779 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Flash Form and opening a page in a new browser.
Hi all, I've got kind of a weird problem with opening a new window from a flash form. First let me say this is for IE6, I haven't tried any other browsers because we are a closed IE shop (not my choice). I have 2 cfinputs on the flash forms (code below). One to open a new window and display a pdf, the other to open a new window and display an xls file. The pdf works exactly as expected. The excel opens a new window with the error: Action canceled Internet Explorer was unable to link to the Web page you requested. The page might be temporarily unavailable. Please try the following: Click the Refresh button, or try again later. If you have visited this page previously and you want to view what has been stored on your computer, click File, and then click Work Offline. For information about offline browsing with Internet Explorer, click the Help menu, and then click Contents and Index. Internet Explorer If you click refresh after the error comes up, the xls displays correctly. If you hit the page directly it displays correctly, it only errors when called from a button in a flash form. Code: cfinput type=Image src=/images/excel.gif height=23 width=25 name=Excel onclick=_root.getURL('my_xls.cfm?lid=' + #Variables.logID#, _blank'); / cfinput type=Image src=/images/icon_pdf.gif height=23 width=25 name=PDF onclick=_root.getURL('my_pdf.cfm?lid=' + #Variables.logID#, '_blank'); / Thanks, Steve ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263780 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: UPS API
You are a machine dude. Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263781 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Previous/Next Button Issue
I am trying to apply a previous next button and limit the records to 10. When the page views the data replicated 10 times for each record. This code generates the data: cfoutput cfif CurrentRow MOD 2 is 1 cfset bgcolor = ##f2f2f3 cfelse cfset bgcolor = ##ff /cfif cfloop query=GetExp startrow=#URL.StartRow# endrow=#EndRow# tr bgcolor=#bgcolor# class=font8td class=reda href=EmpDetail.cfm?emp_id=cfoutput#URLEncodedFormat(queryGrid.e_emp_i d)#/cfoutputcfoutput#transitparams#/cfoutput class=red#fldname#/a/td td class=font8#fldtitle#/td td class=font8#fldwork_phone#/td/cfloop /tr /cfoutput/cfloop This code handles the record count: !--- Retrieve expense records from database --- cfquery name=GetExp datasource=empldir SELECT * FROM emps ORDER BY name ASC /cfquery !--- Number of rows to display per Next/Back page --- cfset RowsPerPage = 10 !--- What row to start at? Assume first by default --- cfparam name=URL.StartRow default=1 type=numeric !--- We know the total number of rows from query --- cfset TotalRows = GetExp.RecordCount !--- Last row is 10 rows past the starting row, or --- !--- total number of query rows, whichever is less --- cfset EndRow = Min(URL.StartRow + RowsPerPage - 1, TotalRows) !--- Next button goes to 1 past current end row --- cfset StartRowNext = EndRow + 1 !--- Back button goes back N rows from start row --- cfset StartRowBack = URL.StartRow - RowsPerPage Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263782 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: TODAY: MDCFUG on Tuesday 12/12/06: CF Admin, Fusebox 5
Michael, will that be broadcast live via Adobe chats? On 12/12/06, Michael Smith [EMAIL PROTECTED] wrote: You are invited to Maryland ColdFusion User Group Meeting on Tuesday 12/12/2006. 6:30pm CFMX Administrator 'for Dummies' with Jo Ann Goertner 8:00pm Fusebox 5: what is new with Sandra Clark (Times are Eastern Standard Time) Can't make it to the meeting? Remote access via Adobe chats http://adobechats.adobe.acrobat.com/mdcfug121206/ TeraTech, Inc. 405 E. Gude Dr Suite 207 Rockville, MD 20850 301-424-3903 For a map or for directions: Go to http://www.cfug-md.org/directions/directions.cfm. To enter the TeraTech building after 6:00 pm use the keypad entry system on the right side of the front door. Press the button to select TeraTech on the keypad and hit the call button, press 0 for someone to pick it up and they will let you in. Topic: CFMX Administrator 'for Dummies' In my first 4 years writing, troubleshooting and maintaining ColdFusion code, I have always treated the CF Administrator as someone else's territory. It's my last resort, my afterthought when all else fails. Why? Mostly because it's unfamiliar. I'm afraid I'll break something. And, there's always been someone else I could go to. Great excuses! Yet, there are basic things every CF developer needs to know about the Administrator. Yes, even those of us who don't have primary responsibility to maintain the server. What are they? That's what we'll look at in this presentation. I'm picking the brains of my someone elses and I'll share with you what I learn. If you've had the same excuses I have, I invite you to get over them along with me! Jo Ann Goertner can be reached at joann (at) teratech.com. Topic: Fusebox 5: what is new In this talk, Sandra Clark, will cover Fusebox 5, from new features to backwards compatibility. Along the way, she will touch on: * Using Multiple Fusebox Applications in one ColdFusion Application * New Application Initialization * New Verbs/Syntax available, including nesting! * New Execution Modes, when to use them * Implicit Circuits * Extending the Framework with lexicons. Bio: Sandra Clark, an advanced Macromedia Certified ColdFusion developer, is a Senior Software Developer with the Constella Group in Bethesda, Maryland. She has contributed material to the ColdFusion 5.0 Certified Developer Study Guide published by Syngress Media/Osborne McGraw Hill, and to the ColdFusion Developers Journal. She has also spoken at various CFUGS and ColdFusion User Conferences around the country. Sandra is an active proponent of applying accepted and proven web standards to development as a way of improving accessibility as well as making life easier on developers. Sandra Clark can be reached at slclark (at) shayna.com. -- Michael Smith, TeraTech Inc - Tools for Programmers(tm) TeraTech voted Best Consulting Service by CFDJ readers! CF/ASP Web, VB, Math, Access programming tools and consulting 405 E Gude Dr Ste 207, Rockville MD 20850 USA Please check out http://www.teratech.com/ - email mailto:[EMAIL PROTECTED], or call us for more information; in the USA at 1-800-447-9120, +1-301-424-3903 International, Fax 301-762-8185 Thanks! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263783 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UPS API
Agreed! haha On 12/12/06, Will Tomlinson [EMAIL PROTECTED] wrote: You are a machine dude. Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263784 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Upload files to IIS Virtual Directory
My goal is to have an internal Intranet site where users can 2 upload files to some internal servers (to replace a manual process we currently do for them). We're using IIS 6, and CF 7. The problem is that this CF server is hosting a lot of existing sites, and we've got it setup to use the local system account, and the other guys on my team are loath to change that to a domain account because of all the other sites. So cffile won't work, because the local system account doesn't have access to the remote shares. I do have a domain account that we could use, but I'm not sure how to do it. We thought about setting up a virtual directory in IIS, and use the domain account for the authentication. This seems to work in IIS (I can see the files on the remote share), but I can't figure out how to write to it using CF. I've tried using cfhttp method=put, with cfhttpparam type=file, but that doesn't work. I'm not exactly sure what you're trying to accomplish with CFHTTP. Would this happen after the user has uploaded a file locally? If my guess is correct, what kind of response do you get when you use CFHTTP? Presumably, you get an error message? You should be able to use CFHTTP METHOD=PUT with CFHTTPPARAM TYPE=FILE. Are you sure you can write to the remote share using WebDAV at all? Have you tested this? As an alternative to this approach, which seems a bit ugly, why not use something else to get files from the local drive to the remote share? A scheduled task, or a watched directory, etc? If you're running CF in the multiserver configuration, you could even use a separate CF instance just for this, with the appropriate security context for that instance only. 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! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263785 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Java 6 JRE?
I KNOW it wont be supported, but has anyone tested the Java 6 JRE with CF? I was gonna toss it on a dev server and was just wondering if anyone else has tried it. Chris ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263786 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Internet Merchant Account - Europe
Would someone know where i could get an Internet Merchant Account that would work with PayFlowPro? The problem? Me and my business are based in Switzerland. I need to set up a subscription based payment system, and i would prefer to use PayFlowPro if possible. The rep at PayFlowPro tells me they can do it if i can get a compatible merchant account. thanks, Nando ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263787 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Java 6 JRE?
Well, since someone threw it out there, Scorpio hasn't been released yet... You think Adobe might test with 6 JRE and make it work with Scorpio? Then again I'm a little ticked at Adobe for Scorpio... My maintenance agreement ends in March and Scorpio won't be released until after that (or so I've read on the net I could be wrong). Now I have to come up with a new business case to try and get the upgrade and upper management is going to want to know if a new maintenance agreement is worth it since we didn't get anything from the last one. Steve -Original Message- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 1:51 PM To: CF-Talk Subject: Java 6 JRE? I KNOW it wont be supported, but has anyone tested the Java 6 JRE with CF? I was gonna toss it on a dev server and was just wondering if anyone else has tried it. Chris ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263788 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Internet Merchant Account - Europe
Have you tried saferpay.com or telecash.de ? Or you can check following webpages: http://www.postfinance.ch/yellowpay http://www.datatrans.ch http://www.firstdata.de http://www.heidelpay.de Nando wrote: Would someone know where i could get an Internet Merchant Account that would work with PayFlowPro? The problem? Me and my business are based in Switzerland. I need to set up a subscription based payment system, and i would prefer to use PayFlowPro if possible. The rep at PayFlowPro tells me they can do it if i can get a compatible merchant account. thanks, Nando -- ~~~ OÄuz Demirkapı TeraTech Inc. | Senior Developer 405 East Gude Dr Suite 207, Rockville, MD 20850, USA Voice: +1 (301) 424-3903 ext 111 | Fax: +1 (301) 762-8185 Web: http://www.teratech.com | E-mail: oguz.demirkapi AT teratech.com Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~~~ ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263789 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Previous/Next Button Issue
Without troubleshooting the code, what's the problem you are having? -Original Message- From: Steve LaBadie [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 12, 2006 1:45 PM To: CF-Talk Subject: Previous/Next Button Issue I am trying to apply a previous next button and limit the records to 10. When the page views the data replicated 10 times for each record. This code generates the data: cfoutput cfif CurrentRow MOD 2 is 1 cfset bgcolor = ##f2f2f3 cfelse cfset bgcolor = ##ff /cfif cfloop query=GetExp startrow=#URL.StartRow# endrow=#EndRow# tr bgcolor=#bgcolor# class=font8td class=reda href=EmpDetail.cfm?emp_id=cfoutput#URLEncodedFormat(queryGrid.e_emp_i d)#/cfoutputcfoutput#transitparams#/cfoutput class=red#fldname#/a/td td class=font8#fldtitle#/td td class=font8#fldwork_phone#/td/cfloop /tr /cfoutput/cfloop This code handles the record count: !--- Retrieve expense records from database --- cfquery name=GetExp datasource=empldir SELECT * FROM emps ORDER BY name ASC /cfquery !--- Number of rows to display per Next/Back page --- cfset RowsPerPage = 10 !--- What row to start at? Assume first by default --- cfparam name=URL.StartRow default=1 type=numeric !--- We know the total number of rows from query --- cfset TotalRows = GetExp.RecordCount !--- Last row is 10 rows past the starting row, or --- !--- total number of query rows, whichever is less --- cfset EndRow = Min(URL.StartRow + RowsPerPage - 1, TotalRows) !--- Next button goes to 1 past current end row --- cfset StartRowNext = EndRow + 1 !--- Back button goes back N rows from start row --- cfset StartRowBack = URL.StartRow - RowsPerPage Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www3.esu.edu ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263790 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4