Re: CRUD Generator
lol. Great reply. :-) Thx Barney! On 11/9/05, Barney Boisvert [EMAIL PROTECTED] wrote: Based on my experience building custom, app-specific generators, what I've liked, disliked, and considered... A generator should be able to be rerun at arbitrary times and update the CRUD part without affecting anything else. It should create beans that have getters/setters for properties. It should allow custom mappings between table names and entity names (i.e. I can say a table called 'mytable' maps to an entity called 'TableDeMoi'). There should be some automated translation for underscore_separated names to camelCase names, both for entities and fields. Surrogate primary keys should always be translated to 'id' properties on entities (i.e. person.person_id maps to Person.getId()). Both of these should be optional/customizable if you're distributing. Methods should be smart enough to only do something when needed. So if I load an entity and then immediately call save(), nothing should happen, since the entity's properties haven't been changed. There should be a 'save' method, which will intelligently insert or update, ideally only the modified fields on updates. Beans should have a constructor that accepts full instance data as args. Beans should automatically have basic validation coded by the generator. I.e. INT fields can automatically check for integer-ness, varchar fields can be checked for length restrictions, etc. That should be easily extensible by the app developer, of course, without affecting the ability to regenerate if the DB schema changes. Beans should have getMemento and setMemento methods that allow for serializing the object state. According to the DP, the memento should be opaque (usually an inner class), but CF doesn't afford that very easily, so non-opaque is fine with me. Whatever that memento is, it should be trivially serialized/deserialized, or some other means of serializing/deserializing should be exposed. Some entity relationship support would be ideal, based on DB foreign keys. I.e. if the 'car' table has an 'ownerId' field that references person.id http://person.id, there should be getOwner:Person and setOwner(Person):void methods, and probably getOwnerId:int and setOwnerId(int):void methods as well. Ideally the Person object would have getCarList, addCar, and removeCar methods as well, but that's harder to autogenerate, unless you're doing the whole schema at once, rather than a single entity/table. And then the holy grail: many-to-many relationship support. I'd be happy with forcing the 'link' table to be it's own implicit entity, as long as the two 'real' entities are smart enough to have direct access to the other 'real' entity. I.e. the link table entity is an exposed implementation detail. For example, people own cars, cars are owned by people. Person, Car, and CarOwnership entities with Person.getCarList, Car.getOwnerList, and CarOwnership.getPerson methods, along with their supporting methods. Updates to relationships need to be clearly documented, as does the effect of calling save on an entity with modified related objects. Propogation is good, but should be disable-able at some level or another. I'd hope to see factory/managers for the beans so they're easy to use. Aside from getPersonById, and getNewPerson, also have createPerson(name, dob, ...), deletePerson(id), and updatePerson(id, name, dob...) for calling from your UI(s). This would also be the place for doing caching and lazy loading in an encapsulated way. If you cache, hooks should be exposed that can be used for syncing across a cluster (the sync stuff would be built by the app developer and utilize the hooks). Some recognition of concurrency issues should be made, even if it's just to explicitly say you're on your own. Smart updates (i.e. only updating modified fields) goes a long way to mitigating this issue, but doesn't address it completely. For example UPDATE table SET f = f + 1 WHERE id = 3; is atomic, but t=getTById(3);t.setF(t.getF() + 1);t.save(); is not atomic. Concurrency issues don't exist with the former, but do with the latter, unless the whole thing is in a transaction. That's a restriction this type of code can't enforce, but a well designed application will likely exhibit that behaviour so if clearly documented, I'd say it's reasonable to assume. Of course, there are sound arguments against this sort of thing at all. It's a delecate balance between using a tool to help you do your job, and relying on a tool because you can't really do your job. I'm all for using them until you've got a sound reason not to, though. cheers, barneyb On 11/8/05, John C. Bland II [EMAIL PROTECTED] wrote: What is it everyone looks for in a CRUD generator? I see some folks saying they'd like to see best practices, some want getters/setters, and others just want a function you pass everything too. Just a little reserach...
RE: Having a mulit-instance service run under a specific service.
You can definitely run the services using any user. I'd check the user has 'full access' to all files and folders from X:\JRun4\Servername\ and down. That's overkill on the permissions but you get the drift. Also have a look in the log files, or start the server instance in console mode to see what's happening. (Create a .bat with 'jrun -start servername' etc. Then 'Run As...' on the .bat with your desired user name.) Cheers. -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 November 2005 2:00 PM To: CF-Talk Subject: RE: Having a mulit-instance service run under a specific service. I can only say that I was able to run multiple instances, of the CF Developer version, with a Windows domain account. I didn't have any problems with restarting the service. Are there any log entries that show the actual cause? Does your account have the logon as a service permission? If you make your account an administrator of your server, does it work? If you set it back to system, does it work again? M!ke -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 08, 2005 5:30 PM To: CF-Talk Subject: Having a mulit-instance service run under a specific service. Is there something different to having a multi-instance service run under a specific user besides local? I've tried setting this to a different user and I get an error that the service can not be restarted, it is not responding. This is windows 2000 server and CFMX7.01 running in multi-instance configuration. I only want one instance to use a specific user at this time. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA 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. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223654 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CRUD Generator
lol. Great reply. :-) -- John C. Bland II I do what I can do when I can do it. - Chris Tucker, Money Talks http://www.gotoandstop.org - Home of FMUG.az ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223655 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
capture rendered HTML to an image
Hi all, I'm looking for an approach that's not too complex to implement to capture rendered HTML to a Jpeg. The idea is to create a thumbnail gallery for templates in an automated fashion. Using cfdocument and outputting to a jpeg would be perfect, but cfdocument only outputs to PDF and FlashPaper :-( Any suggestions would be welcome! thanks Nando ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223656 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CRUD Generator
Barney, Sounds like it's almost ready! On 11/9/05, Barney Boisvert [EMAIL PROTECTED] wrote: Based on my experience building custom, app-specific generators, what I've liked, disliked, and considered... A generator should be able to be rerun at arbitrary times and update the CRUD part without affecting anything else. It should create beans that have getters/setters for properties. It should allow custom mappings between table names and entity names (i.e. I can say a table called 'mytable' maps to an entity called 'TableDeMoi'). There should be some automated translation for underscore_separated names to camelCase names, both for entities and fields. Surrogate primary keys should always be translated to 'id' properties on entities (i.e. person.person_id maps to Person.getId()). Both of these should be optional/customizable if you're distributing. Methods should be smart enough to only do something when needed. So if I load an entity and then immediately call save(), nothing should happen, since the entity's properties haven't been changed. There should be a 'save' method, which will intelligently insert or update, ideally only the modified fields on updates. Beans should have a constructor that accepts full instance data as args. Beans should automatically have basic validation coded by the generator. I.e. INT fields can automatically check for integer-ness, varchar fields can be checked for length restrictions, etc. That should be easily extensible by the app developer, of course, without affecting the ability to regenerate if the DB schema changes. Beans should have getMemento and setMemento methods that allow for serializing the object state. According to the DP, the memento should be opaque (usually an inner class), but CF doesn't afford that very easily, so non-opaque is fine with me. Whatever that memento is, it should be trivially serialized/deserialized, or some other means of serializing/deserializing should be exposed. Some entity relationship support would be ideal, based on DB foreign keys. I.e. if the 'car' table has an 'ownerId' field that references person.id http://person.id, there should be getOwner:Person and setOwner(Person):void methods, and probably getOwnerId:int and setOwnerId(int):void methods as well. Ideally the Person object would have getCarList, addCar, and removeCar methods as well, but that's harder to autogenerate, unless you're doing the whole schema at once, rather than a single entity/table. And then the holy grail: many-to-many relationship support. I'd be happy with forcing the 'link' table to be it's own implicit entity, as long as the two 'real' entities are smart enough to have direct access to the other 'real' entity. I.e. the link table entity is an exposed implementation detail. For example, people own cars, cars are owned by people. Person, Car, and CarOwnership entities with Person.getCarList, Car.getOwnerList, and CarOwnership.getPerson methods, along with their supporting methods. Updates to relationships need to be clearly documented, as does the effect of calling save on an entity with modified related objects. Propogation is good, but should be disable-able at some level or another. I'd hope to see factory/managers for the beans so they're easy to use. Aside from getPersonById, and getNewPerson, also have createPerson(name, dob, ...), deletePerson(id), and updatePerson(id, name, dob...) for calling from your UI(s). This would also be the place for doing caching and lazy loading in an encapsulated way. If you cache, hooks should be exposed that can be used for syncing across a cluster (the sync stuff would be built by the app developer and utilize the hooks). Some recognition of concurrency issues should be made, even if it's just to explicitly say you're on your own. Smart updates (i.e. only updating modified fields) goes a long way to mitigating this issue, but doesn't address it completely. For example UPDATE table SET f = f + 1 WHERE id = 3; is atomic, but t=getTById(3);t.setF(t.getF() + 1);t.save(); is not atomic. Concurrency issues don't exist with the former, but do with the latter, unless the whole thing is in a transaction. That's a restriction this type of code can't enforce, but a well designed application will likely exhibit that behaviour so if clearly documented, I'd say it's reasonable to assume. Of course, there are sound arguments against this sort of thing at all. It's a delecate balance between using a tool to help you do your job, and relying on a tool because you can't really do your job. I'm all for using them until you've got a sound reason not to, though. cheers, barneyb On 11/8/05, John C. Bland II [EMAIL PROTECTED] wrote: What is it everyone looks for in a CRUD generator? I see some folks saying they'd like to see best practices, some want getters/setters, and others just want a function you pass everything too. Just a little
Re: CRUD Generator
On Wednesday 09 November 2005 07:02, Barney Boisvert wrote: Based on my experience building custom, app-specific generators, what So you're gonna have this rolled out by, say, Friday ? :-) -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223658 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CRUD Generator
2007...no specific day...just '07. j/k On 11/9/05, Thomas Chiverton [EMAIL PROTECTED] wrote: On Wednesday 09 November 2005 07:02, Barney Boisvert wrote: Based on my experience building custom, app-specific generators, what So you're gonna have this rolled out by, say, Friday ? :-) -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223659 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cf shopping cart
So whatever happened to our open source cfm shopping cart? Has it already been ditched? ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223660 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfinclude from a template, or onRequestStart?
He's not saying to but the actual html in the app.cfc file he's saying put the include. And I don't see why you couldn't or wouldn't. I'm doing it on a current site and other than a few hair pulls it works great. The main problem is that if you have a page you don't want it on then you got a problem. I have heard a few ppl say it's not a good idea but they dont explain why not? here's a quote out of one of the 2 tuts I have read on application.cfc onRequestEnd This function is called at the end of a page request after all other ColdFusion code has executed. If you have application specific logic that should only be run at the end of your page, this is the place to put it. The following example simply outputs a footer by including the footer.cfm file: cffunction name=onRequestEnd output=Yes returntype=void cfargument name=targetPage type=String required=Yes / cfinclude template=footer.cfm / /cffunction So when when ppl say its bad then WHY is it bad, it seems to run just as good as any other method. ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Matthew Walker [EMAIL PROTECTED] Sent: Tuesday, November 08, 2005 9:12 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: cfinclude from a template, or onRequestStart? Personally, I wouldn't put any display elements in application.cfc but rather use it for app setup purposes (defining global variables, initialising shopping carts, etc). If you wanted to have a different page template on a page it might be a big hassle -- or one day you may want a page that delivers RSS or CSV or something else. Depending on the way your site is structured, you may find custom tag pairs are a nice way of wrapping templates around your pages ... ... ... -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 November 2005 2:46 p.m. To: CF-Talk Subject: cfinclude from a template, or onRequestStart? I usually assemble my pages with a cfinclude header, menu, footer, etc. But I figured it might be better to include the header.cfm in onRequestStart, and footer.cfm in onRequestEnd to keep from spreading includes all over the place. This way they'd all be in one spot. Am I thinking right?? Thanks, Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223661 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf shopping cart
Well I did offer some space on CFDeveloper for it, but no-one was interested. Just another good idea that never happens I guess. -- Snake -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 09 November 2005 10:21 To: CF-Talk Subject: cf shopping cart So whatever happened to our open source cfm shopping cart? Has it already been ditched? ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223662 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Reseller Accounts
Anne, Resellers can set their own currency symbol, so you can charge your customers in $, YEN, or whatever you like. Russ -Original Message- From: Anne Girardeau [mailto:[EMAIL PROTECTED] Sent: 08 November 2005 23:48 To: CF-Talk Subject: Re: ColdFusion Reseller Accounts Russ, that is pretty cool. However, since I'm in the states, I think some of my clients may prefer to pay for their hosting in $ rather than £. But, if you have the option to pay for accounts with $ that would be absolutely awesome. Let me know. Thanks, --Anne John C. Bland II wrote: Oh now that's sweet. On 11/7/05, Snake [EMAIL PROTECTED] wrote: Our control panel allows resellers to use it's billing system or turn it off and use their own system. They can create their own plans, charge what they want when they want, set tax, set discounts, etc. Russ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223663 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFFTP and CFDIRECTORY
once I have made a connection using CFFTP, how would I then use that to run a CFDirectory operation so that I can then run a CFFile operation, read the contents of the files and then delete said files? so far I have tried with no luck: cfftp connection=this_bounceback_list action=open username=LCBounceback password=password server=whatever port=2121 name=this_connection stopOnError=yes cfftp connection=this_bounceback_list action=GetCurrentDir stopOnError=Yes cfdirectory directory=#cfftp.returnvalue# name=bounceback_folder filter=*.msg Thanks in advance Dave ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223664 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Difficult Sort - Theory
MySQL doens't have view support until 5.0, and that's only been out for a few weeks, Once I saw the data I had to work with, and the 3857 different ways the client wanted to search/sort, I was aching to be able to use views! Certainly would have simplified the process! -- --- Les Mizzell ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223666 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFFTP and CFDIRECTORY
You can not use the CFDirectory base don the connection. You have to use the CFFTP ACTION=LISTDIR and then use that information. To read a File from the FTP, you will have to download The file to the local server then read it. Such as: CFFTP ACTION=GETFILE Then use CFFILE ACTION=READ -Original Message- From: Dave Ashworth [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 7:24 AM To: CF-Talk Subject: CFFTP and CFDIRECTORY once I have made a connection using CFFTP, how would I then use that to run a CFDirectory operation so that I can then run a CFFile operation, read the contents of the files and then delete said files? so far I have tried with no luck: cfftp connection=this_bounceback_list action=open username=LCBounceback password=password server=whatever port=2121 name=this_connection stopOnError=yes cfftp connection=this_bounceback_list action=GetCurrentDir stopOnError=Yes cfdirectory directory=#cfftp.returnvalue# name=bounceback_folder filter=*.msg Thanks in advance Dave ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223667 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: PERL form email with attachment?
On Monday 07 November 2005 19:25, Burns, John D wrote: Anyone have a simple script laying around to do this or could some write one out real quick? If not, no biggy. Just trying to prove how much http://jenda.krynicky.cz/perl/Sender.pm.html#sending%20a%20file%20that%20was%20just%20uploaded%20from%20a%20html%20form -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223668 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SESSION or not to SESSION
I am developing a dataing site for a friend, and it looks pretty good, and working really well.. I expected to be able to have time to upgrade as time went on and members went up, but my 'friend' has just bought the member list from a another dating site which is closing down, so all of a sudden I am gonna find my site has 2000 active users, and 27000 casual Whoppee Now the site has SQL2000 in the background so I am not concerned about database access, and I am even going to split the database to two independant sections, but my problem is THIS When users login, a whole host of SESSION variables are created, I also use SESSION variables for quite a few functions as I like to use ARRAYS to kweep things neat, and I cant create arrays with CLIENT variables, and I dont like to use COOKIES as they can be blocked. But lets imagine when we go live, all 29000 sign on, all these SESSION variables will exist in the servers memory, and what happens if loads more sign up? Am I worrying unduly? or is there a better way (can session variables be stored in the database itself? Any suggestions welcome Morgan ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223669 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SESSION or not to SESSION
unless you're explicitly passing CFID and CFTOKEN variables from page to page...session variables rely on cookies. (i know that's not answering the question you posed...but something to take into consideration if you're truly that concerned about using cookies. FWIW, if your site requires a login, I think it's perfectly valid to state, your browser must have cookies enabled to properly use this site. Might you lose a few users that won't use cookies? Possibly (but I'd argue it would be very few). But the users that do continue on...you at least know that they're aware of the requirements and will have cookies enabled. On 11/9/05, Morgan Leecy [EMAIL PROTECTED] wrote: I am developing a dataing site for a friend, and it looks pretty good, and working really well.. I expected to be able to have time to upgrade as time went on and members went up, but my 'friend' has just bought the member list from a another dating site which is closing down, so all of a sudden I am gonna find my site has 2000 active users, and 27000 casual Whoppee Now the site has SQL2000 in the background so I am not concerned about database access, and I am even going to split the database to two independant sections, but my problem is THIS When users login, a whole host of SESSION variables are created, I also use SESSION variables for quite a few functions as I like to use ARRAYS to kweep things neat, and I cant create arrays with CLIENT variables, and I dont like to use COOKIES as they can be blocked. But lets imagine when we go live, all 29000 sign on, all these SESSION variables will exist in the servers memory, and what happens if loads more sign up? Am I worrying unduly? or is there a better way (can session variables be stored in the database itself? Any suggestions welcome Morgan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223670 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Generate PPT slides from CF
I'm trying to generate PPT slides from CF and I'm running into some difficulty. I've got some reports that users can run whenever they're like and the display in HTML by default. On one report, we put a Powerpoint button that spits out the same HTML and just specifies the filename as .ppt and returns the header for that. This works fine for a simple tabled report as PPT converts the HTML to a slide. The issue that I'm running into is when there is an image on the report. If I put it in as an img src... it works fine, but if you don't have access to the internet, it won't work. I'd like to somehow embed an image in there so that users can take it on the road for presentations. Anybody done something like this or have any ideas? I've looked in the exchange for tags but haven't had much luck. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223671 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SESSION or not to SESSION
I would reevaluate the session variables you have and see what variables never change between users. I would then take those variables and move them to the application scope. Any functions you are using I would move to the application scope. I would NOT use client variables. The biggest bottleneck for your application will be from the database to your application enviroment. Every time you would need to read or write a variable would be a write to the database. Bob Everland ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223672 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SESSION or not to SESSION
It may help if someone can answer this question: How much memory does it really take to store a single session. How much can you store in the single session to know you're safe with this sort of issue? Anyone have any numbers for this sort of thing? Obviously, each application is different, but how much memory space would it take to store a session with 50 variables in it and 20 arrays/structs with say another 50 variables in each. Assume each value is 200 characters or less. Also, what's the overhead on storing objects in sessions? Is everything simple calculated by figuring how many bytes the text is and assume each session takes that much memory or is there some sort of compression or overhead happening to affect the numbers? John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Morgan Leecy [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 9:21 AM To: CF-Talk Subject: SESSION or not to SESSION I am developing a dataing site for a friend, and it looks pretty good, and working really well.. I expected to be able to have time to upgrade as time went on and members went up, but my 'friend' has just bought the member list from a another dating site which is closing down, so all of a sudden I am gonna find my site has 2000 active users, and 27000 casual Whoppee Now the site has SQL2000 in the background so I am not concerned about database access, and I am even going to split the database to two independant sections, but my problem is THIS When users login, a whole host of SESSION variables are created, I also use SESSION variables for quite a few functions as I like to use ARRAYS to kweep things neat, and I cant create arrays with CLIENT variables, and I dont like to use COOKIES as they can be blocked. But lets imagine when we go live, all 29000 sign on, all these SESSION variables will exist in the servers memory, and what happens if loads more sign up? Am I worrying unduly? or is there a better way (can session variables be stored in the database itself? Any suggestions welcome Morgan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223673 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SESSION or not to SESSION
I'll go along with this sentiment. Use session variables when you need them, but put what you can into the applicaiton and request scopes. RAM is cheap. --Ferg Robert Everland III wrote: I would reevaluate the session variables you have and see what variables never change between users. I would then take those variables and move them to the application scope. Any functions you are using I would move to the application scope. I would NOT use client variables. The biggest bottleneck for your application will be from the database to your application enviroment. Every time you would need to read or write a variable would be a write to the database. Bob Everland ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223674 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Spaces in cfexecute on Windows machine
Thanks for the help. The escaped double-quotes did the trick. Adrian Showalter Software Developer Holmes BizNet www.HolmesBizNet.com http://www.HolmesBizNet.com 330.893.3901 ext 102 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223675 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
reload Java classes
All, Before I give up on this (since I have searched the Interweb and have not got any solutions), I wanted to ask the people on the list about this. I have a Java program that is currently under development and I call Java class using the cfobject tag. I am having to restart the CFMX 7 server every single time that I have to make a change to the class. Is there absolutely no way the class can reload itself without this constant restarting? I can already hear the sighs out there! No, I am not deploying CF in a J2EE environment , so I can't modify jrun-web.xml to do anything. This is CFMX 7 running on IIS/Win 2K. Thanks, George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223676 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generate PPT slides from CF
On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote: I'm trying to generate PPT slides from CF and I'm running into some difficulty. I've got some reports that users can run whenever they're like and the display in HTML by default. On one report, we put a Powerpoint button that spits out the same HTML and just specifies the filename as .ppt and returns the header for that. This works fine for a simple tabled report as PPT converts the HTML to a slide. The issue that I'm running into is when there is an image on the report. If I put it in as an img src... it works fine, but if you don't have access to the internet, it won't work. I'd like to somehow embed an image in there so that users can take it on the road for presentations. Anybody done something like this or have any ideas? I've looked in the exchange for tags but haven't had much luck. This doesn't *exactly* meet the requirements, but there's a web-based presentation tool, S5 (http://www.meyerweb.com/eric/tools/s5/) that feels a lot like PowerPoint (unless you use really fancy transistions) but is all (x)HTML under the hood. It *might* be easier just to use it since you can use the HTML you are already building directly in a slide, embed images, etc -- and then package it all up to take on the road. It's a single HTML file, a theme, a JS file, and any media you include. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223677 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: calling java class from CFMX
Robert, Sorry for dropping off. I just read this email. I did find out that I was thinking badly about it. I did do this by actually instantiating the Java class using cfobject. Thanks, George On 11/7/05, Robert Munn [EMAIL PROTECTED] wrote: WHy not just call your Java class using CFOBJECT to instantiate the native Java object? In order to do that, you'll need to reference your additional classes in the CFMX classpath arguments. If you need this class to have some special security permissions, you might also want to consider writing a wrapper class that calls the other class by impersonating another user account. All, CFMX 7 on Win 2000 (a test server). I wrote a Java program and compiled it on the server under another user account (not the one running the CFMX service). The program compiled correctly and I was able to run it using the command line. Now it imports some specific java libraries that are not in the JRE. I want to be able to run this Java class peridocally so I thought I could simply add a CF task that cfexecutes the class using the cmd.exeprogram. I know that this might be a security issue. I have two questions: 1. Is it a security issue? If so, how else can I run the Java class? It is a normal java program with a main() method that directs various methods. 2. If not a security issue, does the account that runs CFMX (currently a local system account) have to be one that is not a system account? I am currently running the cfexecute by calling the complete classpath that is required for the java program to execute. However I am just getting a blank page and nothing else. Regards, George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223678 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SESSION or not to SESSION
On 11/9/05, Ken Ferguson [EMAIL PROTECTED] wrote: I'll go along with this sentiment. Use session variables when you need them, but put what you can into the applicaiton and request scopes. RAM is cheap. --Ferg Agreed. Actually, it's a lot easier to turn the calculation around. You have a maximal peak of a little less than 30,000 users (2000 active 27000 casual), so 1MB of RAM gives each of those 30k users 33bytes. Assuming Unicode to give a lot of overhead, that's 16 usable bytes per MB. Cut that in half to factor in a lot of overhead and you've got 8 usable bytes left. So 1 GB of RAM for session use would give you 8000 bytes per person with plenty of room left over that's assuming your box can *handle* all 30k at once, which is pretty unlikely :) Using a more realistic scenario like 1000 users with active sessions 1MB - 1000 bytes - 500 unicode characters -50%overhead- 250 usable bytes/user So 1GB yields 250,000 usable bytes of storage for that user. That's a lot of storage sidebarI'm using characters to equate to usable bytes since ColdFusion isn't really typed -- under the hood, it's converted in many cases, but using characters should be on average equal or greater than the underlying data strucuture. This is really an order of magnitude calculation so the specifics are not a big deal -- and if anything, these should be pretty conservative numbers./sidebar So the point is, you really have to put a *lot* in session scope and/or have a *lot* of users to approach any real worries about session memory. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223679 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SESSION or not to SESSION
question: Do you have to modify the JVM settings so that CF can actually use our theoretical 1GB of RAM? -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: 09 November 2005 16:02 To: CF-Talk Subject: Re: SESSION or not to SESSION On 11/9/05, Ken Ferguson [EMAIL PROTECTED] wrote: I'll go along with this sentiment. Use session variables when you need them, but put what you can into the applicaiton and request scopes. RAM is cheap. --Ferg Agreed. Actually, it's a lot easier to turn the calculation around. You have a maximal peak of a little less than 30,000 users (2000 active 27000 casual), so 1MB of RAM gives each of those 30k users 33bytes. Assuming Unicode to give a lot of overhead, that's 16 usable bytes per MB. Cut that in half to factor in a lot of overhead and you've got 8 usable bytes left. So 1 GB of RAM for session use would give you 8000 bytes per person with plenty of room left over that's assuming your box can *handle* all 30k at once, which is pretty unlikely :) Using a more realistic scenario like 1000 users with active sessions 1MB - 1000 bytes - 500 unicode characters -50%overhead- 250 usable bytes/user So 1GB yields 250,000 usable bytes of storage for that user. That's a lot of storage sidebarI'm using characters to equate to usable bytes since ColdFusion isn't really typed -- under the hood, it's converted in many cases, but using characters should be on average equal or greater than the underlying data strucuture. This is really an order of magnitude calculation so the specifics are not a big deal -- and if anything, these should be pretty conservative numbers./sidebar So the point is, you really have to put a *lot* in session scope and/or have a *lot* of users to approach any real worries about session memory. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223680 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
test
test ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223681 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SESSION or not to SESSION
On 11/9/05, Kerry [EMAIL PROTECTED] wrote: question: Do you have to modify the JVM settings so that CF can actually use our theoretical 1GB of RAM? My understanding is yes -- but that assumes your app is really going to use all that memory -- the calculation was basically an order-of-magnitude to see where assumptions break down. Load testing of course is the only real way to tune for performance under load. As an aside, it may be that moving some of the session data that's db-related back to the db and requerying (and relying on the db cache to keep things speedy) may be a performance boost compared to storing in session. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223682 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Export Matrix to Excel
(If this is a dupe, I apologize) I am trying to export a data table to an Excel spreadsheet. The data table looks like IdA, 1, x IdA, 2, y IdA, 3, z .. etc. IdB, 1, q IdB, 2, r IdB, 3, s ... etc. I want the spreadsheet to look like: ID 123 .. A xyz ... B qrs ... Etc. Can anyone suggest an approach to arrange the data for export to a spreadsheet. TNX if you can help. Rick. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223683 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
qForm issue
I am having issue with qForms. In IE the error is could not get the display property. Invalid argument. In Firefox it does works and giving me the required result, but with error. Exception... Permission denied to get property XULElement.selectedIndex when calling method The only modification I've done is with the qform.js file under function _f_throwError(error) I have added these two lines in that function just to display inline error msgs in the form. document.getElementById(id).style.visibility = visible; document.getElementById(id).style.display = table-row; if there is any other solution to display the inline error msgs on forms that would be greate too.. thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223684 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf shopping cart
I think this is a excellent idea! Lets try this again. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 7:21 AM To: CF-Talk Subject: RE: cf shopping cart Well I did offer some space on CFDeveloper for it, but no-one was interested. Just another good idea that never happens I guess. -- Snake -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 09 November 2005 10:21 To: CF-Talk Subject: cf shopping cart So whatever happened to our open source cfm shopping cart? Has it already been ditched? ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223685 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: User Defined Functions in ColdFusion
On Wednesday 09 November 2005 03:11, simmyana a wrote: Hi, I have created an UDF in MS sql and I want to use it in coldfusion while writing the query. could you please tell me as how to use UDF of MS Sql in Coldfusion? If you can type it into whatever database tool you use, you can use it in cfquery... Typicaly, the contents of cfquery will look like: select myFunction() as result from dual or select myFunctionForThisColumn(columnName) as result from tableName if it acts on a table/column. -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223686 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Tools to convert old Ami Pro v3 documents?
Sorry for the slightly off-topic post, but I've got a client who's trying to convert a bunch of old Ami Pro v3 documents to Word (or at least some other modern day format.) Ami Pro v3 is an older Dos/Windows 3.1 application by Lotus that no longer runs under the new operating systems. While Word does have an Ami Pro filter, it seems to only work with documents that contain only text. Most of these documents contained graphics and layouts drawn with the Ami Pro toolset. All of these documents come up blank. Does anyone know of a tool that will accurately convert Ami Pro documents? Worst case scenario is I try to get the software running on old PC and try to get a version of Acrobat running on the box. I batch conversion tool would make life much, much easier. rant Archived files are a bit of a dirty little secret in the computer industry that really tends to affect small business owners. I've seen some business owners archive data as their supposed to, but then not be able to get to the archived data years later because the software needed to read/write the data doesn't work anymore. You also have to be very careful in the media you choose to backup to. Many people think that any CD-R/CD-RW will last virtually forever, but I've seen cheap CD-R media go bad within 2 years--to the point were the disc is unreadable. You have to be very careful w/archived data if it's information that crucial to your business. /rant -Dan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223687 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf shopping cart
I am excited about it and will be able to help out next week. I am not the strongest developer, but will be more then willing to put in my two cents worth. Russell - Original Message - From: Aldon [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, November 09, 2005 10:44 AM Subject: RE: cf shopping cart I think this is a excellent idea! Lets try this again. -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 7:21 AM To: CF-Talk Subject: RE: cf shopping cart Well I did offer some space on CFDeveloper for it, but no-one was interested. Just another good idea that never happens I guess. -- Snake -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: 09 November 2005 10:21 To: CF-Talk Subject: cf shopping cart So whatever happened to our open source cfm shopping cart? Has it already been ditched? ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223688 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf shopping cart
dave wrote: So whatever happened to our open source cfm shopping cart? Has it already been ditched? ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. Someone needs to grab that project by the horns and lead it. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223689 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Generate PPT slides from CF
John Paul - So this is really a separate file type and presentation system? We are supporting corporate customers who are really tied to PPT already so we really need something that can generate a PPT slide completely. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 10:43 AM To: CF-Talk Subject: Re: Generate PPT slides from CF On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote: I'm trying to generate PPT slides from CF and I'm running into some difficulty. I've got some reports that users can run whenever they're like and the display in HTML by default. On one report, we put a Powerpoint button that spits out the same HTML and just specifies the filename as .ppt and returns the header for that. This works fine for a simple tabled report as PPT converts the HTML to a slide. The issue that I'm running into is when there is an image on the report. If I put it in as an img src... it works fine, but if you don't have access to the internet, it won't work. I'd like to somehow embed an image in there so that users can take it on the road for presentations. Anybody done something like this or have any ideas? I've looked in the exchange for tags but haven't had much luck. This doesn't *exactly* meet the requirements, but there's a web-based presentation tool, S5 (http://www.meyerweb.com/eric/tools/s5/) that feels a lot like PowerPoint (unless you use really fancy transistions) but is all (x)HTML under the hood. It *might* be easier just to use it since you can use the HTML you are already building directly in a slide, embed images, etc -- and then package it all up to take on the road. It's a single HTML file, a theme, a JS file, and any media you include. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223690 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: formatting a date in cfgrid
Just figured this problem out last night. I lost your original email, but from your screen shot it looks the same. It's not in the docs but put a type=date on the cfgridcolumn On 11/4/05, Alexander Hinkley [EMAIL PROTECTED] wrote: i did the update this morning.. i still get the same results.. http://single-dads.us/grid.jpg the petid field shows the format of the date as it comes from the db... via remoting.. On 10/28/05, Mike Nimer [EMAIL PROTECTED] wrote: Upgrade to 7.0.1, we fixed some bugs in cfgrid in the updater. I think this was fixed as well. ---nimer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223691 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
(Admin) Report help
While looking over some stuff on House of Fusion yesterday I noticed that I've been logging information since around march and I've had over 16.5 million page views in that time (about 2 million a month). The logging has records of what's a bot and what's a human. The problem? No reporting interface to the data. I was wondering if anyone here with experience with reporting has a few moments to devote to writing a report interface to the data. I'll be giving out the CFC and database structure I use to the community so whoever helps with the reporting will have their name associated with the full project. You can contact me off list, by yahoo chat or phone for more info or ideas. Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223692 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: reload Java classes
keep on restarting that server :) http://livedocs.macromedia.com/jrun/4/Getting_Started_with_JRun/intro5.htm hot deploy works wehn a jsp or servlet is called. So, CreateObject() will not effect this. DK On 11/9/05, George Abraham [EMAIL PROTECTED] wrote: All, Before I give up on this (since I have searched the Interweb and have not got any solutions), I wanted to ask the people on the list about this. I have a Java program that is currently under development and I call Java class using the cfobject tag. I am having to restart the CFMX 7 server every single time that I have to make a change to the class. Is there absolutely no way the class can reload itself without this constant restarting? I can already hear the sighs out there! No, I am not deploying CF in a J2EE environment , so I can't modify jrun-web.xml to do anything. This is CFMX 7 running on IIS/Win 2K. Thanks, George ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223693 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: (Admin) Report help
Are you just talking about something like a log analyzer? Wouldn't it be better to use something other than CF for that? There are lots of other software pieces out there to do that. I looked into doing it before but to read the file line by line and do database operations just seems extremely inefficient with Cf. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 12:20 PM To: CF-Talk Subject: (Admin) Report help While looking over some stuff on House of Fusion yesterday I noticed that I've been logging information since around march and I've had over 16.5 million page views in that time (about 2 million a month). The logging has records of what's a bot and what's a human. The problem? No reporting interface to the data. I was wondering if anyone here with experience with reporting has a few moments to devote to writing a report interface to the data. I'll be giving out the CFC and database structure I use to the community so whoever helps with the reporting will have their name associated with the full project. You can contact me off list, by yahoo chat or phone for more info or ideas. Thanks ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223694 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generate PPT slides from CF
On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote: John Paul - So this is really a separate file type and presentation system? We are supporting corporate customers who are really tied to PPT already so we really need something that can generate a PPT slide completely. Yep -- alternative system. Tough challenge! The only thing I can think of is really complicated -- using VBA to write the slide directly. Something like using cfobject and the underlying com object as shown in this VBA example http://skp.mvps.org/ppt00046.htm#2 Argh! :) John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 10:43 AM To: CF-Talk Subject: Re: Generate PPT slides from CF On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote: I'm trying to generate PPT slides from CF and I'm running into some difficulty. I've got some reports that users can run whenever they're like and the display in HTML by default. On one report, we put a Powerpoint button that spits out the same HTML and just specifies the filename as .ppt and returns the header for that. This works fine for a simple tabled report as PPT converts the HTML to a slide. The issue that I'm running into is when there is an image on the report. If I put it in as an img src... it works fine, but if you don't have access to the internet, it won't work. I'd like to somehow embed an image in there so that users can take it on the road for presentations. Anybody done something like this or have any ideas? I've looked in the exchange for tags but haven't had much luck. This doesn't *exactly* meet the requirements, but there's a web-based presentation tool, S5 (http://www.meyerweb.com/eric/tools/s5/) that feels a lot like PowerPoint (unless you use really fancy transistions) but is all (x)HTML under the hood. It *might* be easier just to use it since you can use the HTML you are already building directly in a slide, embed images, etc -- and then package it all up to take on the road. It's a single HTML file, a theme, a JS file, and any media you include. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223695 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: (Admin) Report help
All of the information is already in a DB with a very efficient structure. For example, the user agents are all ids rather than strings linked to a lookup table. I'm looking to create different forms of daily, weekly and monthly stats into separate tables for ease and speed but the issue has always been displaying the data. Showing off that browser X has 80% vs. browser Y and bot Z is taking up 15% of all hits. The data is probably useful just to show how many hits the site gets per day, week, etc. Are you just talking about something like a log analyzer? Wouldn't it be better to use something other than CF for that? There are lots of other software pieces out there to do that. I looked into doing it before but to read the file line by line and do database operations just seems extremely inefficient with Cf. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 12:20 PM To: CF-Talk Subject: (Admin) Report help While looking over some stuff on House of Fusion yesterday I noticed that I've been logging information since around march and I've had over 16.5 million page views in that time (about 2 million a month). The logging has records of what's a bot and what's a human. The problem? No reporting interface to the data. I was wondering if anyone here with experience with reporting has a few moments to devote to writing a report interface to the data. I'll be giving out the CFC and database structure I use to the community so whoever helps with the reporting will have their name associated with the full project. You can contact me off list, by yahoo chat or phone for more info or ideas. Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223696 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Tools to convert old Ami Pro v3 documents?
Did you try this one: http://support.microsoft.com/Default.aspx?kbid=208863 Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion and BlueDragon applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm iMS-Lite - the completely free mail server solution for applications and application servers http://www.coolfusion.com/iMSLite --- On Wednesday, November 09, 2005 11:37 AM, Dan G. Switzer, II scribed: --- Sorry for the slightly off-topic post, but I've got a client who's trying to convert a bunch of old Ami Pro v3 documents to Word (or at least some other modern day format.) Ami Pro v3 is an older Dos/Windows 3.1 application by Lotus that no longer runs under the new operating systems. While Word does have an Ami Pro filter, it seems to only work with documents that contain only text. Most of these documents contained graphics and layouts drawn with the Ami Pro toolset. All of these documents come up blank. Does anyone know of a tool that will accurately convert Ami Pro documents? Worst case scenario is I try to get the software running on old PC and try to get a version of Acrobat running on the box. I batch conversion tool would make life much, much easier. rant Archived files are a bit of a dirty little secret in the computer industry that really tends to affect small business owners. I've seen some business owners archive data as their supposed to, but then not be able to get to the archived data years later because the software needed to read/write the data doesn't work anymore. You also have to be very careful in the media you choose to backup to. Many people think that any CD-R/CD-RW will last virtually forever, but I've seen cheap CD-R media go bad within 2 years--to the point were the disc is unreadable. You have to be very careful w/archived data if it's information that crucial to your business. /rant -Dan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223697 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Tools to convert old Ami Pro v3 documents?
If none of the conversion filters work for you and you have to hand-step it through several processes, you might try one of the macro packages like Automate (www.unisyn.com) Best regards, Ron -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 8:38 AM To: CF-Talk Subject: OT: Tools to convert old Ami Pro v3 documents? Sorry for the slightly off-topic post, but I've got a client who's trying to convert a bunch of old Ami Pro v3 documents to Word (or at least some other modern day format.) Ami Pro v3 is an older Dos/Windows 3.1 application by Lotus that no longer runs under the new operating systems. While Word does have an Ami Pro filter, it seems to only work with documents that contain only text. Most of these documents contained graphics and layouts drawn with the Ami Pro toolset. All of these documents come up blank. Does anyone know of a tool that will accurately convert Ami Pro documents? Worst case scenario is I try to get the software running on old PC and try to get a version of Acrobat running on the box. I batch conversion tool would make life much, much easier. rant Archived files are a bit of a dirty little secret in the computer industry that really tends to affect small business owners. I've seen some business owners archive data as their supposed to, but then not be able to get to the archived data years later because the software needed to read/write the data doesn't work anymore. You also have to be very careful in the media you choose to backup to. Many people think that any CD-R/CD-RW will last virtually forever, but I've seen cheap CD-R media go bad within 2 years--to the point were the disc is unreadable. You have to be very careful w/archived data if it's information that crucial to your business. /rant -Dan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223698 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: capture rendered HTML to an image
Efflares ImageCR does website screenshots as well as some of the more incredible image manipulation function available. Check em out at http://www.efflare.com Emmet -Original Message- From: Nando [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 4:08 AM To: CF-Talk Subject: capture rendered HTML to an image Hi all, I'm looking for an approach that's not too complex to implement to capture rendered HTML to a Jpeg. The idea is to create a thumbnail gallery for templates in an automated fashion. Using cfdocument and outputting to a jpeg would be perfect, but cfdocument only outputs to PDF and FlashPaper :-( Any suggestions would be welcome! thanks Nando ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223699 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf shopping cart
OK, I have setup a forum for the project. You will need to register at www.cfdeveloper.co.uk to get access Then goto forums -- projects -- cf_shoppingcart The forum password is: tangerine If we get the discussion going here and plan out all the features, then I can setup the development web space and decide who will manage it. -- Russ -Original Message- From: Jordan Michaels [mailto:[EMAIL PROTECTED] Sent: 09 November 2005 17:05 To: CF-Talk Subject: Re: cf shopping cart dave wrote: So whatever happened to our open source cfm shopping cart? Has it already been ditched? ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. Someone needs to grab that project by the horns and lead it. -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223700 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Tools to convert old Ami Pro v3 documents?
Howie, Did you try this one: http://support.microsoft.com/Default.aspx?kbid=208863 Yes, but as stated in my e-mail, it does not correctly open Ami Pro files that have images/drawings in them. -Dan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223701 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: qForm issue
The only modification I've done is with the qform.js file under function _f_throwError(error) I have added these two lines in that function just to display inline error msgs in the form. document.getElementById(id).style.visibility = visible; document.getElementById(id).style.display = table-row; What are you expecting those lines to do? Unless you've modified the _f_throwError function in some other manor, the variable id would have no value. -Dan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223702 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Tools to convert old Ami Pro v3 documents?
Yes, I read your mail but wasn't sure that this was the converter you were using. Howie --- On Wednesday, November 09, 2005 1:29 PM, Dan G. Switzer, II scribed: --- Howie, Did you try this one: http://support.microsoft.com/Default.aspx?kbid=208863 Yes, but as stated in my e-mail, it does not correctly open Ami Pro files that have images/drawings in them. -Dan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223703 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
removing trailing comma in CSV row
I am trying to build lines of CSV data. However, I don't know exactly how to get rid of the LAST comma in the line. Here is the result: 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6, (note trailing comma) Here is the code (ugly as it may be): cfquery . select spdinput_id, location,score from spdout group by spdinput_id, location, score order by spdinput_id, location /cfquery cfloop from=1 to=#get_result.recordcount# index=i step=1 cfoutput query=get_result group=spdinput_id #spdinput_id#, cfoutput#score#,/cfoutput p /cfoutput /cfloop Any ideas appreciated. Rick. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223704 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
removing trailing comma in CSV row
I am trying to build lines of CSV data. However, I don't know exactly how to get rid of the LAST comma in the line. Here is the result: 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6, (note trailing comma) Here is the code (ugly as it may be): cfquery . select spdinput_id, location,score from spdout group by spdinput_id, location, score order by spdinput_id, location /cfquery cfloop from=1 to=#get_result.recordcount# index=i step=1 cfoutput query=get_result group=spdinput_id #spdinput_id#, cfoutput#score#,/cfoutput p /cfoutput /cfloop Any ideas appreciated. Rick. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223705 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: reload Java classes
Gah! And a thousand coises! Thanks, George On 11/9/05, Douglas Knudsen [EMAIL PROTECTED] wrote: keep on restarting that server :) http://livedocs.macromedia.com/jrun/4/Getting_Started_with_JRun/intro5.htm hot deploy works wehn a jsp or servlet is called. So, CreateObject() will not effect this. DK On 11/9/05, George Abraham [EMAIL PROTECTED] wrote: All, Before I give up on this (since I have searched the Interweb and have not got any solutions), I wanted to ask the people on the list about this. I have a Java program that is currently under development and I call Java class using the cfobject tag. I am having to restart the CFMX 7 server every single time that I have to make a change to the class. Is there absolutely no way the class can reload itself without this constant restarting? I can already hear the sighs out there! No, I am not deploying CF in a J2EE environment , so I can't modify jrun-web.xml to do anything. This is CFMX 7 running on IIS/Win 2K. Thanks, George ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223706 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
encrypt + file append + decrypt
okay, been looking at this for a while now, cant see why its not working, suggestions appreciated! !--- environment: cfmx 6.1, win2K code objective: encrypt string + linebreak, append to file (repeat), read file, decrypt, display in textarea expected output: 1 2 3 4 5 6 7 8 9 10 actual output: 1 --- cfset logdir = getdirectoryfrompath(getcurrenttemplatepath()) cfset logfil = encrypted.txt cfset logpath = logdirlogfil cfif fileexists(logdirlogfil) cffile action=delete file=#logpath# /cfif cfloop from=1 to=10 index=i cfset message = encrypt(URLEncodedFormat(ichr(13)chr(10)),hash(logfil)) cfif not fileexists(logdirlogfil) cffile action=write file=#logpath# output=#message# addnewline=no cfelse cffile action=append file=#logpath# output=#message# addnewline=no /cfif /cfloop cffile action=read file=#logpath# variable=filcontents cfoutput textarea #URLDecode(decrypt(filcontents,hash(logfil)))# /textarea /cfoutput thx all. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223707 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: removing trailing comma in CSV row
do a left(string, len(string) - 1) On 11/9/05, Richard Colman [EMAIL PROTECTED] wrote: I am trying to build lines of CSV data. However, I don't know exactly how to get rid of the LAST comma in the line. Here is the result: 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6, (note trailing comma) Here is the code (ugly as it may be): cfquery . select spdinput_id, location,score from spdout group by spdinput_id, location, score order by spdinput_id, location /cfquery cfloop from=1 to=#get_result.recordcount# index=i step=1 cfoutput query=get_result group=spdinput_id #spdinput_id#, cfoutput#score#,/cfoutput p /cfoutput /cfloop Any ideas appreciated. Rick. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223708 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: removing trailing comma in CSV row
use listAppend() cfset scoreList = / cfset scoreList = listAppend(scoreList, score) / cfoutput#score#/cfoutput if you don't want to change your logic, you can still set it to a variable and use the left() function. #left(score, len(score)-1)# On 11/9/05, Richard Colman [EMAIL PROTECTED] wrote: I am trying to build lines of CSV data. However, I don't know exactly how to get rid of the LAST comma in the line. Here is the result: 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6, (note trailing comma) Here is the code (ugly as it may be): cfquery . select spdinput_id, location,score from spdout group by spdinput_id, location, score order by spdinput_id, location /cfquery cfloop from=1 to=#get_result.recordcount# index=i step=1 cfoutput query=get_result group=spdinput_id #spdinput_id#, cfoutput#score#,/cfoutput p /cfoutput /cfloop Any ideas appreciated. Rick. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223709 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Generate PPT slides from CF
If you are ready to risk Automation of Office components on your server using CF, then I do have some code that might help you. Email me offline and I can send it to you. Or you could look at the code at CFcomet: http://cfregex.com/cfcomet/. Regards, George On 11/9/05, John Paul Ashenfelter [EMAIL PROTECTED] wrote: On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote: John Paul - So this is really a separate file type and presentation system? We are supporting corporate customers who are really tied to PPT already so we really need something that can generate a PPT slide completely. Yep -- alternative system. Tough challenge! The only thing I can think of is really complicated -- using VBA to write the slide directly. Something like using cfobject and the underlying com object as shown in this VBA example http://skp.mvps.org/ppt00046.htm#2 Argh! :) John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 10:43 AM To: CF-Talk Subject: Re: Generate PPT slides from CF On 11/9/05, Burns, John D [EMAIL PROTECTED] wrote: I'm trying to generate PPT slides from CF and I'm running into some difficulty. I've got some reports that users can run whenever they're like and the display in HTML by default. On one report, we put a Powerpoint button that spits out the same HTML and just specifies the filename as .ppt and returns the header for that. This works fine for a simple tabled report as PPT converts the HTML to a slide. The issue that I'm running into is when there is an image on the report. If I put it in as an img src... it works fine, but if you don't have access to the internet, it won't work. I'd like to somehow embed an image in there so that users can take it on the road for presentations. Anybody done something like this or have any ideas? I've looked in the exchange for tags but haven't had much luck. This doesn't *exactly* meet the requirements, but there's a web-based presentation tool, S5 (http://www.meyerweb.com/eric/tools/s5/) that feels a lot like PowerPoint (unless you use really fancy transistions) but is all (x)HTML under the hood. It *might* be easier just to use it since you can use the HTML you are already building directly in a slide, embed images, etc -- and then package it all up to take on the road. It's a single HTML file, a theme, a JS file, and any media you include. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223710 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: qForm issue
Actually I've added these three lines. var id = this.obj.name + 1; document.getElementById(id).style.visibility = visible; document.getElementById(id).style.display = table-row; I've added the td id=formfieldname1 right under the row where the form field is and put the visibility=hidden. so, what I was trying to do is once those qforms gonna make those fields background red, just display that tr too. and in IE its giving me an error, and in firefox it gives me an error as well as it displays correctly too. Please advise. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223711 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: capture rendered HTML to an image
The last example on this page shows how to use ImageCR with our free cfx_url2bmp tag to create website screenshots. http://efflare.com/docs/CFX_ImageCR3/reference/examples/index.html#Website%20Screenshot We will be expanding on this in the future. -- CrystalM Efflares ImageCR does website screenshots as well as some of the more incredible image manipulation function available. Check em out at http://www.efflare.com Emmet -Original Message- From: Nando [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 4:08 AM To: CF-Talk Subject: capture rendered HTML to an image Hi all, I'm looking for an approach that's not too complex to implement to capture rendered HTML to a Jpeg. The idea is to create a thumbnail gallery for templates in an automated fashion. Using cfdocument and outputting to a jpeg would be perfect, but cfdocument only outputs to PDF and FlashPaper :-( Any suggestions would be welcome! thanks Nando ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223712 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Tools to convert old Ami Pro v3 documents?
-Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 11:38 AM To: CF-Talk Subject: OT: Tools to convert old Ami Pro v3 documents? Sorry for the slightly off-topic post, but I've got a client who's trying to convert a bunch of old Ami Pro v3 documents to Word (or at least some other modern day format.) Ami Pro v3 is an older Dos/Windows 3.1 application by Lotus that no longer runs under the new operating systems. While Word does have an Ami Pro filter, it seems to only work with documents that contain only text. Most of these documents contained graphics and layouts drawn with the Ami Pro toolset. All of these documents come up blank. Does anyone know of a tool that will accurately convert Ami Pro documents? There's a tool called Conversions Plus that did this kind of thing... not sure if it's any better than the one you're using but it might help. http://www.dataviz.com/products/conversionsplus/ Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223713 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: what do you use instead of cfx_openimage?
I got the price wrong in this message last Friday. The personal version is $49 not $75. -- CrystalM Many people use our tag, cfx_imagecr3. Some hosts install it on all their servers. Efflare ImageCR 3 http://efflare.com/products/cfx_imagecr $75 personal license http://efflare.com/purchase?personal -- CrystalM is nobody using cfx_openimage? is there another similar good tool (for easy setupuse in shared hosting environment) I wanna resize images and read image dimensions.. what are you using? -- Sebastian Mork [EMAIL PROTECTED] -- On Thu, 03 Nov 2005 17:32:55 +0100 Sebastian Mork [EMAIL PROTECTED] wrote: Hi, in my app I use cfx_openimage (in a shared hosting environment running win(nt?), cfmx7.0). I used the tag for months for reading images to get infos about the dimension without poblems. suddenly, two days ago a user told me he gets an error viewing some other user profiles. hmm, thats strange, from one day to another the cfx_tag produces an error, the html-title says 'jrun servlet error' and '500 null' is shown. the hosting-comp. said thay didn't change anything. and I did not change anything in the code, too. they restarted cfmx and the whole server without success. and, I read cfx_openimage needs a temp-dir (c:\temp), but they didn't delete that dir and the installation of that tag is made in the default-directory.. so what?? I've created a test-page with the following code, its just an example, that code worked fine in my app: #filename# is: D:\friendcom.de\wwwroot\MachII\summComm\views\images\index10.jpg code: CFX_OPENIMAGE ACTION=IML FILE=#filename# COMMANDS=getsize heres the test-page: http://friendcom.de/sc/views/test.cfm any ideas? thx -- Sebastian Mork [EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223714 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: removing trailing comma in CSV row
What you can do rather than trying to delete the Last comma is simple: In your CFLOOP, change your #score#, line to: cfoutput#score#CFIF I NEQ get_result.recordcount,/CFIF/cfoutput This way when you loop over the items and reached the Last one, it will NOT put the comma into the CSV file. -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 1:43 PM To: CF-Talk Subject: removing trailing comma in CSV row I am trying to build lines of CSV data. However, I don't know exactly how to get rid of the LAST comma in the line. Here is the result: 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6, (note trailing comma) Here is the code (ugly as it may be): cfquery . select spdinput_id, location,score from spdout group by spdinput_id, location, score order by spdinput_id, location /cfquery cfloop from=1 to=#get_result.recordcount# index=i step=1 cfoutput query=get_result group=spdinput_id #spdinput_id#, cfoutput#score#,/cfoutput p /cfoutput /cfloop Any ideas appreciated. Rick. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223715 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: removing trailing comma in CSV row
i'd still vote for listAppend(), since that's effectively what you're doing. set an empty variable, and then rather than outputting it with a literal comma following it, call a listAppend() function. On 11/9/05, ColdFusion Developer [EMAIL PROTECTED] wrote: What you can do rather than trying to delete the Last comma is simple: In your CFLOOP, change your #score#, line to: cfoutput#score#CFIF I NEQ get_result.recordcount,/CFIF/cfoutput This way when you loop over the items and reached the Last one, it will NOT put the comma into the CSV file. -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 1:43 PM To: CF-Talk Subject: removing trailing comma in CSV row I am trying to build lines of CSV data. However, I don't know exactly how to get rid of the LAST comma in the line. Here is the result: 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6, (note trailing comma) Here is the code (ugly as it may be): cfquery . select spdinput_id, location,score from spdout group by spdinput_id, location, score order by spdinput_id, location /cfquery cfloop from=1 to=#get_result.recordcount# index=i step=1 cfoutput query=get_result group=spdinput_id #spdinput_id#, cfoutput#score#,/cfoutput p /cfoutput /cfloop Any ideas appreciated. Rick. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223716 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfinclude from a template, or onRequestStart?
I don't see why you couldn't or wouldn't Well you certainly could, although I wouldn't. It is the kind of thing that may not be a problem now but could be a hassle later. As you describe in your first paragraph below, it's a hassle when suddenly you *don't* want that template wrapped around your content for a new page. I would generally only put things I *always* wanted in application.cfc/cfm. I couldn't guarantee that anything I was displaying would be *always* wanted, as I may want a different template for a popup page, or I may be delivering a different type of content such as XML. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 November 2005 11:47 p.m. To: CF-Talk Subject: RE: cfinclude from a template, or onRequestStart? He's not saying to but the actual html in the app.cfc file he's saying put the include. And I don't see why you couldn't or wouldn't. I'm doing it on a current site and other than a few hair pulls it works great. The main problem is that if you have a page you don't want it on then you got a problem. I have heard a few ppl say it's not a good idea but they dont explain why not? here's a quote out of one of the 2 tuts I have read on application.cfc onRequestEnd This function is called at the end of a page request after all other ColdFusion code has executed. If you have application specific logic that should only be run at the end of your page, this is the place to put it. The following example simply outputs a footer by including the footer.cfm file: cffunction name=onRequestEnd output=Yes returntype=void cfargument name=targetPage type=String required=Yes / cfinclude template=footer.cfm / /cffunction So when when ppl say its bad then WHY is it bad, it seems to run just as good as any other method. ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Matthew Walker [EMAIL PROTECTED] Sent: Tuesday, November 08, 2005 9:12 PM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: cfinclude from a template, or onRequestStart? Personally, I wouldn't put any display elements in application.cfc but rather use it for app setup purposes (defining global variables, initialising shopping carts, etc). If you wanted to have a different page template on a page it might be a big hassle -- or one day you may want a page that delivers RSS or CSV or something else. Depending on the way your site is structured, you may find custom tag pairs are a nice way of wrapping templates around your pages ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223717 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: removing trailing comma in CSV row
cfoutput query=get_result group=spdinput_id #spdinput_id#, cfoutput#score#cfif currentrow LT recordcount,/cfoutput p /cfoutput !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 12:42 PM To: CF-Talk Subject: removing trailing comma in CSV row I am trying to build lines of CSV data. However, I don't know exactly how to get rid of the LAST comma in the line. Here is the result: 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6, (note trailing comma) Here is the code (ugly as it may be): cfquery . select spdinput_id, location,score from spdout group by spdinput_id, location, score order by spdinput_id, location /cfquery cfloop from=1 to=#get_result.recordcount# index=i step=1 cfoutput query=get_result group=spdinput_id #spdinput_id#, cfoutput#score#,/cfoutput p /cfoutput /cfloop Any ideas appreciated. Rick. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223718 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: removing trailing comma in CSV row
How about just using one of the queryToCSV functions from CFlib http://www.cflib.org/udf.cfm?ID=556 http://www.cflib.org/udf.cfm?ID=1197 so you don't have to reinvent the wheel :) On 11/9/05, Richard Colman [EMAIL PROTECTED] wrote: I am trying to build lines of CSV data. However, I don't know exactly how to get rid of the LAST comma in the line. Here is the result: 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6, (note trailing comma) Here is the code (ugly as it may be): cfquery . select spdinput_id, location,score from spdout group by spdinput_id, location, score order by spdinput_id, location /cfquery Any ideas appreciated. Rick. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223719 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: removing trailing comma in CSV row
Ooops... Forgot my closing /cfif. Change this line: cfoutput#score#cfif currentrow LT recordcount,/cfoutput to this line: cfoutput#score#cfif currentrow LT recordcount,/cfif/cfoutput !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 1:48 PM To: CF-Talk Subject: RE: removing trailing comma in CSV row cfoutput query=get_result group=spdinput_id #spdinput_id#, cfoutput#score#cfif currentrow LT recordcount,/cfoutput p /cfoutput !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 12:42 PM To: CF-Talk Subject: removing trailing comma in CSV row I am trying to build lines of CSV data. However, I don't know exactly how to get rid of the LAST comma in the line. Here is the result: 42, 0,0.9,0,-0.1,0.8,0,1.2,0.1,0.1,1.5,0.3,0,1.3,0,0,0.9,0.4,0,0,0.1,0.6, (note trailing comma) Here is the code (ugly as it may be): cfquery . select spdinput_id, location,score from spdout group by spdinput_id, location, score order by spdinput_id, location /cfquery cfloop from=1 to=#get_result.recordcount# index=i step=1 cfoutput query=get_result group=spdinput_id #spdinput_id#, cfoutput#score#,/cfoutput p /cfoutput /cfloop Any ideas appreciated. Rick. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223720 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: removing trailing comma in CSV row
On 11/9/05, Richard Colman [EMAIL PROTECTED] wrote: I am trying to build lines of CSV data. However, I don't know exactly how to get rid of the LAST comma in the line. There's an easy solution that involves thinking differently about the list you're outputting: Instead of worrying about removing the *last* comma, consider a list with the *first* comma removed. In other words, think about ,a,b,c with the leading comma removed instead of a,b,c, with the trailing comma removed. That's easy to do: cfloop from=1 to=#get_result.recordcount# index=i step=1 cfoutput query=get_result group=spdinput_id #spdinput_id# cfoutput,#score#/cfoutput p /cfoutput /cfloop (same as your code but no comma after spdinput_id - it's before score instead) -- Sean A Corfield -- http://corfield.org/ Got frameworks? If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223721 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Fist try at an async gateway
I've created an async gateway that is supposed to do some processing that may take a few seconds and send out an e-mail with the results. My hope of using an async gateway was that I could fire off several requests that each would process there data and return a result. The problem I'm having is that the gateway is being processed in serial rather then parallel. Is this the correct behavior? I don't get async gateways working at the same time, as much as a windows 2000 server can multi-task. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA 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. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223722 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Server Processes
I have a site thats eating up server processes! Any idea on what coul be causing this??? Aldon ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223723 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ColdFusion MX CFLDAP NullPointerException bug
Hi all, I hit the CLDAP NullPointerException bug with ColdFusion MX 6.1 (with Updater): http://www.sargeway.com/blog/index.cfm?mode=entryentry=36 http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:10/threadid:1283 I am running ColdFusion for J2EE with JVM 1.4.2_09 and I cannot revert to an older JVM, since I am not the one in charge for the system. Apparently Macromedia never released an hotfix for the bug. Do you have any info about it? Is there any workaround for the issue? Thanks a lot. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223724 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fist try at an async gateway
I'd look at the code to see if there's something in it causing it to operate in serial. I've got a number of parallel processes going and they have no contact with each other at all. If you have a lock, a cftransaction or anything else which can stop the parallel processing of your code, you'll get a serial like result. I've created an async gateway that is supposed to do some processing that may take a few seconds and send out an e-mail with the results. My hope of using an async gateway was that I could fire off several requests that each would process there data and return a result. The problem I'm having is that the gateway is being processed in serial rather then parallel. Is this the correct behavior? I don't get async gateways working at the same time, as much as a windows 2000 server can multi-task. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA 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. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223725 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion MX CFLDAP NullPointerException bug
there were issues with CFLDAP and JVM versions. For certain, CFLDAP does not work with 1.4.2_07.look like not _09 either. workaround? write your LDAP call in Java...a bit of work but not too terribly difficult. DK On 11/9/05, wolf2k5 [EMAIL PROTECTED] wrote: Hi all, I hit the CLDAP NullPointerException bug with ColdFusion MX 6.1 (with Updater): http://www.sargeway.com/blog/index.cfm?mode=entryentry=36 http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:10/threadid:1283 I am running ColdFusion for J2EE with JVM 1.4.2_09 and I cannot revert to an older JVM, since I am not the one in charge for the system. Apparently Macromedia never released an hotfix for the bug. Do you have any info about it? Is there any workaround for the issue? Thanks a lot. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223726 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Email a pdf as attachment at regular interval
I have a cfr report (pdf is the result) that I would like to automatically generate and email once per month to two people. How do I attach the pdf as an attachment? Do I need to generate the pdf and save it as a file and then attach it as an email, or can I generate and email at the same time? ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223727 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
project progression holding up other projects
I have a bit of a problem with a team of developers. Its a new company and somewhat of a new problem. We use VSS to do the basic functions of checking out files, and developers keep them checked out until the file and changes in question are in production. This has obvious problems - if another project comes along and has to also change that particular template then it cant progress any faster through the SDLC than the project that got there first. Anyone have any answers to this problem? -- Duncan I Loxton www.sixfive.co.uk http://www.sixfive.co.uk [EMAIL PROTECTED] I can only please one person per day. Today is not looking good. Tomorrow isn't looking much better. Dilbert ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223728 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion MX CFLDAP NullPointerException bug
I would not mind seeing an example of that. We have certainy had our fair share of LDAP issues since upgrading to 6.1 from 5.0 On 11/9/05, Douglas Knudsen [EMAIL PROTECTED] wrote: workaround? write your LDAP call in Java...a bit of work but not too terribly difficult. DK ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223729 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Embedding Password question...
Hello, I have a concern about embedding a password in my site. I have a site which uses two LDAP accounts for displying and editing the site contents which are stored in LDAP. So my issue is that I'm storing a password in one of my cfc files which is using an account(Service Type Account) and I'm affraid if someone gets a hold of this cfc file they now have the account name and password to my LDAP directory. Can someone please suggest a better way to store the password for the site. Thanks, - Charles PS: This a is a short term need, I'm going to do a re-write to leverage the LDAP directory and the assigned privileges in the directory to control this but for the next few months I have to live with this. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223730 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Email a pdf as attachment at regular interval
1) scheduled task to run the file that send the mail every hour 2) yes generate and save the PDF before mailing 3) attach using the family of cfmail tags (it's all in the help files) HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223731 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Email a pdf as attachment at regular interval
Do I have to manually run the CFR page and do a file/save as from the resultant PDF, or can I automate that part of the process as well so there is no user intervention required in the process? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223732 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Difficult Sort - Theory
I forgot this is MySQL. My bad... On 11/9/05, Les Mizzell [EMAIL PROTECTED] wrote: MySQL doens't have view support until 5.0, and that's only been out for a few weeks, Once I saw the data I had to work with, and the 3857 different ways the client wanted to search/sort, I was aching to be able to use views! Certainly would have simplified the process! -- --- Les Mizzell ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223733 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: project progression holding up other projects
Multiple checkout. Different systems deal with it different ways. VSS sipmly allows multiple checkout, which means that if I have a file checked out you can come along and check it out as well, and any conflicts have to be resolved before check-in. I'm at a new job where we use Perforce, and it deals with this concept in a more robust way. It supports the notion of branching, so for each project, you build a new branch, then you re-integrate your changes from the project branch back into the main branch when you finish your work. You can have multiple concurrent branches from the mainline, but you still have to resolve any conflicts that come up during re-integration (check-in, in VSS speak). I have a bit of a problem with a team of developers. Its a new company and somewhat of a new problem. We use VSS to do the basic functions of checking out files, and developers keep them checked out until the file and changes in question are in production. This has obvious problems - if another project comes along and has to also change that particular template then it cant progress any faster through the SDLC than the project that got there first. Anyone have any answers to this problem? -- Duncan I Loxton www.sixfive.co.uk http://www.sixfive.co.uk [EMAIL PROTECTED] I can only please one person per day. Today is not looking good. Tomorrow isn't looking much better. Dilbert ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223734 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: qForm issue
document.getElementById(id).style.display = table-row; Hmmm, the display argument in a style should be one of inline block or none I think. I get the same error message with wrong values for display. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223735 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Fist try at an async gateway
I'd look at the code to see if there's something in it causing it to operate in serial. I've got a number of parallel processes going and they have no contact with each other at all. If you have a lock, a cftransaction or anything else which can stop the parallel processing of your code, you'll get a serial like result. That was a thought, I am calling a cfx tag that I'm told is multi-threadable, but I didn't actually write it so who knows. To test this, I simplified my async function so that it just counts ticks for 5 seconds and then finishes. This still seems to be serially processing. Does it matter how I call the async function? I'm using this example code to test my concepts. Does it matter that I'm calling the same async gateway from the same cfm template over and over that would case the cfc to be serially run? cfloop query=allSTEmails pSending an event to the CFML event gateway that is registered in the ColdFusion MX Administrator as BSMailBlaster.p cfscript status = false; props = structNew(); props.email = allSTEmails.email; props.ID = allSTEmails.N_PER_ID; status = SendGatewayMessage(BSMailBlaster, props); if (status IS True) WriteOutput('p#currentRow#: Event Message #props.email# has been sent./p'); else WriteOutput('p#currentRow#: Event Message #props.email# has NOT been sent./p'); /cfscript /cfloop -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA 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. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223736 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: reload Java classes
Gah! And a thousand coises! Thanks, George On 11/9/05, Douglas Knudsen [EMAIL PROTECTED] wrote: This topic seems to come up often with no solution that I've seen. I have the same situation and spent quite a bit of time reading articles written by people that claim it's possible in MX, as well as reading the JRun and CF documentation with none of the proposed solutions working for me. Finally after sending emails to several article authors (with no responses) I read this http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=1561.htm and moved on without hope of finding an answer unless one of the authors responds to me. To get around the problem for now, I just create a main method that runs the class files and run them on a command line. This has gotten be through 90% of the development process of all the stuff I've created. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223737 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Embedding Password question...
We had a similar concern sometime back, we solved it by placing the user name and password in an ini file that required high level permissions to access. We then read the ini file on the applicationStart and store the value in application memory. You can further complicate this by encrypting the user name and password. HTH -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223738 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fist try at an async gateway
Have you tried it without waiting for a status result? Also, the question has to do with the code within the async process, not the code calling it. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223739 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Server Processes
long running code? Have you turned on logging for long templates and checked the logs for timeouts, errors or excessive wait times? I have a site thats eating up server processes! Any idea on what coul be causing this??? Aldon ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223740 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Query of Queries Subquery
I'm having trouble doing a subquery using a query of queries. Is this even possible or am I doing something wrong. I have the simplified code below. Thanks. cfquery name=OOrder datasource=database dbtype=ODBC SELECTZip FROM UPS /cfquery cfquery name=Minneapolis dbtype=Query SELECT* FROM OOrder Where zip IN (Select Zip from cstSpecialZip) /cfquery ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223741 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Open source shopping cart
OK a change to my last post. I have now created a new Open Projects category in the forums, and the shopping cart forum is now in here. For those that want to be involved, please come and register at www.cfdeveloper.co.uk and post in the main cf_shoppingcart, and we will get things moving. -- Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223742 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Query of Queries Subquery
QofQ doesn't support subqueries. cheers, barneyb On 11/9/05, Lee [EMAIL PROTECTED] wrote: I'm having trouble doing a subquery using a query of queries. Is this even possible or am I doing something wrong. I have the simplified code below. Thanks. cfquery name=OOrder datasource=database dbtype=ODBC SELECTZip FROM UPS /cfquery cfquery name=Minneapolis dbtype=Query SELECT* FROM OOrder Where zip IN (Select Zip from cstSpecialZip) /cfquery -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223743 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: preventing multiple form submissions
Store the cgi.remoate_addr and the current date/time in a database. It should be easy to go from there. If you dont want to do that... you can try something like this... http://acoderslife.com/downloads/bhcaptcha/ ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Ron Gowen [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 08, 2005 12:47 PM To: CF-Talk Subject: Re: preventing multiple form submissions captcha may be an option, though probably not the best for a search feature: http://www.alagad.com/ On 11/8/05, Protoculture [EMAIL PROTECTED] wrote: we would like to limit the amount of times a user may search/ie use our search facility as we think that we may be under some kind of script attack at the moment. What would be some solutions to prevent a certain number of form submissions from taking place in a given period of time? -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/164 - Release Date: 11/9/2005 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223744 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query of Queries Subquery
You can't do sub queries in Q of Q. Ade -Original Message- From: Lee [mailto:[EMAIL PROTECTED] Sent: 09 November 2005 22:15 To: CF-Talk Subject: Query of Queries Subquery I'm having trouble doing a subquery using a query of queries. Is this even possible or am I doing something wrong. I have the simplified code below. Thanks. cfquery name=OOrder datasource=database dbtype=ODBC SELECTZip FROM UPS /cfquery cfquery name=Minneapolis dbtype=Query SELECT* FROM OOrder Where zip IN (Select Zip from cstSpecialZip) /cfquery ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223745 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query of Queries Subquery
Sad but true... You'll have to run a third QoQ to filter it. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 5:23 PM To: CF-Talk Subject: RE: Query of Queries Subquery You can't do sub queries in Q of Q. Ade -Original Message- From: Lee [mailto:[EMAIL PROTECTED] Sent: 09 November 2005 22:15 To: CF-Talk Subject: Query of Queries Subquery I'm having trouble doing a subquery using a query of queries. Is this even possible or am I doing something wrong. I have the simplified code below. Thanks. cfquery name=OOrder datasource=database dbtype=ODBC SELECTZip FROM UPS /cfquery cfquery name=Minneapolis dbtype=Query SELECT* FROM OOrder Where zip IN (Select Zip from cstSpecialZip) /cfquery ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223746 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query of Queries Subquery
Or, just had a thought, make the the sub query dynamic cfquery name=OOrder datasource=database SELECT Zip FROM UPS /cfquery cfquery name=Minneapolis dbtype=Query SELECT* FROM OOrder Where zip IN (#ValueList(OOrder.Zip)#) /cfquery You might want to allow for no records though. Ade -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: 09 November 2005 22:28 To: CF-Talk Subject: RE: Query of Queries Subquery Sad but true... You'll have to run a third QoQ to filter it. ...:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 5:23 PM To: CF-Talk Subject: RE: Query of Queries Subquery You can't do sub queries in Q of Q. Ade -Original Message- From: Lee [mailto:[EMAIL PROTECTED] Sent: 09 November 2005 22:15 To: CF-Talk Subject: Query of Queries Subquery I'm having trouble doing a subquery using a query of queries. Is this even possible or am I doing something wrong. I have the simplified code below. Thanks. cfquery name=OOrder datasource=database dbtype=ODBC SELECTZip FROM UPS /cfquery cfquery name=Minneapolis dbtype=Query SELECT* FROM OOrder Where zip IN (Select Zip from cstSpecialZip) /cfquery ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223747 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query of Queries Subquery
Is cstSpecialZip another query record set? How about... cfquery name=Minneapolis dbtype=Query SELECT* FROM OOrder Where zip IN (cfqueryparam value=0#valueList(cstSpecialZip.zip)# cfsqltype=CF_SQL_INTEGER list=Yes) /cfquery In case you're wondering, the 0 will catch empty record set cases (I'm assuming zip is an integer field). -Original Message- From: Lee [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 November 2005 11:31 a.m. To: CF-Talk Subject: Query of Queries Subquery I'm having trouble doing a subquery using a query of queries. Is this even possible or am I doing something wrong. I have the simplified code below. Thanks. cfquery name=OOrder datasource=database dbtype=ODBC SELECTZip FROM UPS /cfquery cfquery name=Minneapolis dbtype=Query SELECT* FROM OOrder Where zip IN (Select Zip from cstSpecialZip) /cfquery ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223748 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Fist try at an async gateway
Is this on CF Enterprise or on CF Developer? The async g/w on Developer only processes one request at a time hence it would appear to be serial execution. On 11/9/05, Ian Skinner [EMAIL PROTECTED] wrote: I've created an async gateway that is supposed to do some processing that may take a few seconds and send out an e-mail with the results. My hope of using an async gateway was that I could fire off several requests that each would process there data and return a result. The problem I'm having is that the gateway is being processed in serial rather then parallel. Is this the correct behavior? I don't get async gateways working at the same time, as much as a windows 2000 server can multi-task. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223749 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Embedding Password question...
Thanks! I was afraid that was what I was going to need to do. - Charles On Nov 9, 2005, at 1:55 PM, Alan Rother wrote: We had a similar concern sometime back, we solved it by placing the user name and password in an ini file that required high level permissions to access. We then read the ini file on the applicationStart and store the value in application memory. You can further complicate this by encrypting the user name and password. HTH -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223750 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Embedding Password question...
I just entered a feature enhancement for this. (I have been sitting on this task for too long and, when I saw your thread, I thought it was finally time.) Similar to storing CFQUERY datasource connections in the ColdFusion Administrator, I would like the ability to store usernames/passwords for CFLDAP and CFFTP, etc in the CF Administrator. The main purpose is to keep usernames and passwords away from developers. Sometimes, when using CFLDAP, you must specify a domain administrator account to perform certain functions. I would prefer these passwords to now always appear, in plain text, in any pages that use CFLDAP/CFFTP. You might add your own to increase the importance of this feature. M!ke -Original Message- From: Charles E. Heizer [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 2:57 PM To: CF-Talk Subject: Embedding Password question... Hello, I have a concern about embedding a password in my site. I have a site which uses two LDAP accounts for displying and editing the site contents which are stored in LDAP. So my issue is that I'm storing a password in one of my cfc files which is using an account(Service Type Account) and I'm affraid if someone gets a hold of this cfc file they now have the account name and password to my LDAP directory. Can someone please suggest a better way to store the password for the site. Thanks, - Charles PS: This a is a short term need, I'm going to do a re-write to leverage the LDAP directory and the assigned privileges in the directory to control this but for the next few months I have to live with this. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223751 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Embedding Password question...
When sharing hosting on a less-than-secure server, I enhanced the security of the passwords in my source code by writing simple java classes that return the password hardcoded within. The classes were written so that they would only run in code calling them from the correct directory on the server (i.e. if someone else tried to run the class it returned nothing) and this was independent of CF sandboxing. I loaded the classes dynamically, so they were never in the CF classpath. It isn't perfect, since decompiling the class would get the password, but if someone is in a position to do that then they can also decompile CF and get the encryption/decryption keys for datasource passwords (and compromise the enhancement that has been talked about in this thread too). ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223752 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
re: Open source shopping cart
I'm on board and hopefully some of these ppl will get off their collective butts and chip in this time. Shouldn't take long if everyone takes a task and just gets it done. Would be cool if we did a new project every month and would help out the community a lot. Now if we can only get ppl to follow through with their words. I guess we'll find out who the true cfm lovers are ;)~ And being too busy isnt an excuse, im as busy as anyone and if i can find time so can y'all! So let's GET 'R' DONE this time! I have web space too if needed. ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Snake [EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 5:20 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Open source shopping cart OK a change to my last post. I have now created a new Open Projects category in the forums, and the shopping cart forum is now in here. For those that want to be involved, please come and register at www.cfdeveloper.co.uk and post in the main cf_shoppingcart, and we will get things moving. -- Russ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223753 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54