Advice about merging into certificates and outputting to pdf
Hi All, First, happy thanksgiving to everyone (who is celebrating that holiday). Second, a quick question. We're developing a basic certificates feature in our event tool. The idea is that you register for an event, attend the event, and then get a certificate (most likely pdf) for the event. In creating the certificate, we have been provided with some word document templates. My expectation is that the output would need to be in PDF format. We will need to merge in the name of the person attending as well as the date and perhaps a few other fields. We have done some template merging and output to pdfs using CF Report Builder in the past so I was thinking about that. However, given CF's built in PDF tools, I'm assuming there are good ways to build this feature without CF Report Builder. If any of you have been down this road and have suggestions, I'm definitely interested. I know that there is a lot out there on PDF features (I have the WACKs), but am looking for some guidance on a best practice for this kind of feature. Thanks in advance! Nick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357221 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Admin System - Temp Tables? Advice?
I'm in the process of rewriting the admin system for an older website. On this version, client want to be able to edit/add/delete anything at will, and have it NOT got live until he's decided he's done with that part. My current thought is to use a temp table(s) that: a. when visiting an edit page - LOADS the live data into the temp table b. all editing is done in the temp table c. once he likes it, he can hit the publish button, and the temp data replaces whatever is currently in the live table. d. after that transaction is completed, the temp table is emptied again Seem like a plan? Is there a better way? How does everybody else handle this stuff? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350501 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
re: Admin System - Temp Tables? Advice?
Or have a 'versions' table attached to the 'page' table. Versions can have status, with a maximum of 1 'published' for any given pageID, and versions can have publicationStart and publicationEnd dates. Gives you the flexibility of rolling back to previous versions as well. Just a thought. From: Les Mizzell lesm...@bellsouth.net Sent: Wednesday, March 21, 2012 12:22 PM To: cf-talk cf-talk@houseoffusion.com Subject: Admin System - Temp Tables? Advice? I'm in the process of rewriting the admin system for an older website. On this version, client want to be able to edit/add/delete anything at will, and have it NOT got live until he's decided he's done with that part. My current thought is to use a temp table(s) that: a. when visiting an edit page - LOADS the live data into the temp table b. all editing is done in the temp table c. once he likes it, he can hit the publish button, and the temp data replaces whatever is currently in the live table. d. after that transaction is completed, the temp table is emptied again Seem like a plan? Is there a better way? How does everybody else handle this stuff? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350502 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Admin System - Temp Tables? Advice?
I have done this three ways. I had an edit table (like your temp table) and that worked fairly well. I did versioning as Jason mentioned, that was a bit of a PITA. The other way was to use a preview page and I submitted the form data to the preview page via AJAX and populated it that way. The Ajax method worked best with simple pages i.e. not a lot of joins. G! On Wed, Mar 21, 2012 at 12:21 PM, Les Mizzell lesm...@bellsouth.net wrote: I'm in the process of rewriting the admin system for an older website. On this version, client want to be able to edit/add/delete anything at will, and have it NOT got live until he's decided he's done with that part. My current thought is to use a temp table(s) that: a. when visiting an edit page - LOADS the live data into the temp table b. all editing is done in the temp table c. once he likes it, he can hit the publish button, and the temp data replaces whatever is currently in the live table. d. after that transaction is completed, the temp table is emptied again Seem like a plan? Is there a better way? How does everybody else handle this stuff? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350503 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Admin System - Temp Tables? Advice?
My current thought is to use a temp table(s) that: a. when visiting an edit page - LOADS the live data into the temp table b. all editing is done in the temp table c. once he likes it, he can hit the publish button, and the temp data replaces whatever is currently in the live table. d. after that transaction is completed, the temp table is emptied again Seem like a plan? Is there a better way? How does everybody else handle this stuff? I would create an actual persistent table for this - if you literally mean a temporary table, that table will only last while the database session is active, and could go out of scope before the user has completed his edits. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350504 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Admin System - Temp Tables? Advice?
Most of the case, the user does not want a new item to be published bedore it is completed. For existing items, only little adjustements are made and this may be done on line. If it is your case, just add some Active logical field in the table and display the item only if the active flag is set. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 and Excel - advice sought
On Wed, Jan 4, 2012 at 7:42 PM, Les Mizzell lesm...@bellsouth.net wrote: I've not had a chance to work with cfspreadsheet yet. Works OK reading different version Excel files? What other experiences has everybody had? If folks seem to think it works better than what I'm doing in CF8, I'll convince them to upgrade their server... I've had pretty good success with CFSPREADSHEET, though I have found that it runs faster when you specify just the subset of sheet/column/row data you want back. Less data = faster. Your milage may vary. I wouldn't count on anyone else's experience with that file, your sheet may have differences that no-one else can speak to. Really, I would recommend installing the trial of CF9 (locally if needed) and testing it out yourself over relying on other people's advice. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349360 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 and Excel - advice sought
Larger files (1000+ records) though - usually time out and the import fails. Excel 2007 (.xlsx) and forward usually fails too. A thousand records is not a huge amount, unless there are a large number of columns involved. How many columns? What portion of the process consumes the bulk of the time - reading the file or inserting that information into your database? Because if you are looping, that tends to chew up a lot of time. -Lei ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9 and Excel - advice sought
Is CF9 limited to the versions of Excel it will work with? I've got an application running in CF8 to import email/name lists using the POI Utility (thanks Ben Nadlel). When (and it's not often) the client normalizes their data and removes all formatting, AND uses a pre Excel 2007 file (.xls), the utility works great. That usually doesn't happen - there's formatting, and gawd knows what they leave in the files. If it's a small list being imported, the utility will usually manage to chew through it and import the data. Larger files (1000+ records) though - usually time out and the import fails. Excel 2007 (.xlsx) and forward usually fails too. I'm not sure what my solution is yet. I need a more robust utility and that can what they're going to throw at it, because they're NOT going to worry about formatting, or converting the files to csv, or any of that stuff... I've thought about using a ODBC Socket and use the Excel as a datasource and read from that, but there's no way I'm going to convince them to ALWAYS have that first row as the column headers either. YES - I know this is partially a problem with the client! Nothing I can do about that part! They pay well and often I've not had a chance to work with cfspreadsheet yet. Works OK reading different version Excel files? What other experiences has everybody had? If folks seem to think it works better than what I'm doing in CF8, I'll convince them to upgrade their server... Thanks, Les ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Database fail over advice
Greetings, My boss has asked me to come up with a plan of action in case one of our databases is off line or if we loose connectivity to it. In this setup we have one DB in one location and another one at a different ISP. I think he wants a solution in which if its possible that CF would be able to make the change if some sort of situation were to occur and we can't reach site A. One thing that I thought of would be to run a simple query and if it times out or we get a DB error then we would switch to the alternate DB. I have just started thinking about this scenario and since I have never been tasked with this type of challenge before I thought I would ask. Thanks, Mallory Woods ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346867 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Database fail over advice
I presume you already have the database clustering sorted and just want to handle the CF DSN side of things ? The easy way to do this is to have 2 DSN's, one pointing to each server. In your OnRequest method simply check the database connection, if it fails, switch to the other DSN. Russ On Fri, Aug 19, 2011 at 9:10 PM, Mallory Woods mallory.wo...@gmail.comwrote: Greetings, My boss has asked me to come up with a plan of action in case one of our databases is off line or if we loose connectivity to it. In this setup we have one DB in one location and another one at a different ISP. I think he wants a solution in which if its possible that CF would be able to make the change if some sort of situation were to occur and we can't reach site A. One thing that I thought of would be to run a simple query and if it times out or we get a DB error then we would switch to the alternate DB. I have just started thinking about this scenario and since I have never been tasked with this type of challenge before I thought I would ask. Thanks, Mallory Woods ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Database fail over advice
Mallory, A while back one of the CFGURU's, Mike Brunt, did an excellent presentation at CF.Objective() 2009 called the Server of Doom. What he covered in the preso was performance and redundancy. His slide show is still on SlideSix http://slidesix.com/view/mbruntcfwhisperercfobjective09 The last section covers the database performance and a simple but effective failover setup. It involves user SQL Server express as a witness server to determine when failover is needed. Mike's blog is here http://www.cfwhisperer.com/post.cfm/cfobjective-powerepoint-on-coldfusion-and-database-performance Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Aug 19, 2011, at 3:10 PM, Mallory Woods wrote: Greetings, My boss has asked me to come up with a plan of action in case one of our databases is off line or if we loose connectivity to it. In this setup we have one DB in one location and another one at a different ISP. I think he wants a solution in which if its possible that CF would be able to make the change if some sort of situation were to occur and we can't reach site A. One thing that I thought of would be to run a simple query and if it times out or we get a DB error then we would switch to the alternate DB. I have just started thinking about this scenario and since I have never been tasked with this type of challenge before I thought I would ask. Thanks, Mallory Woods ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Database fail over advice
Russ Wil Thanks I will be looking at that slideshow. On Fri, Aug 19, 2011 at 4:20 PM, Wil Genovese jugg...@trunkful.com wrote: Mallory, A while back one of the CFGURU's, Mike Brunt, did an excellent presentation at CF.Objective() 2009 called the Server of Doom. What he covered in the preso was performance and redundancy. His slide show is still on SlideSix http://slidesix.com/view/mbruntcfwhisperercfobjective09 The last section covers the database performance and a simple but effective failover setup. It involves user SQL Server express as a witness server to determine when failover is needed. Mike's blog is here http://www.cfwhisperer.com/post.cfm/cfobjective-powerepoint-on-coldfusion-and-database-performance Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Aug 19, 2011, at 3:10 PM, Mallory Woods wrote: Greetings, My boss has asked me to come up with a plan of action in case one of our databases is off line or if we loose connectivity to it. In this setup we have one DB in one location and another one at a different ISP. I think he wants a solution in which if its possible that CF would be able to make the change if some sort of situation were to occur and we can't reach site A. One thing that I thought of would be to run a simple query and if it times out or we get a DB error then we would switch to the alternate DB. I have just started thinking about this scenario and since I have never been tasked with this type of challenge before I thought I would ask. Thanks, Mallory Woods ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving to DC, need advice
Jason, you can expect $80 - $90 per hour easily if you don't have layers in between.. On Thu, Nov 4, 2010 at 4:18 PM, Jason Birch birchma...@yahoo.com wrote: I am a Senior ColdFusion Developer that is moving out to the Washington, DC. Obviously housing is a premium in the DC area. I would like to buy or rent a house in one of the suburbs, so that we can have a fenced in yard for my dogs. What suburbs are the safest and most affordable in DC that have single family homes (not townhomes/apartments)? Which area is lower in taxes? Commuting by train/light rail would be ideal. Also, what is a typical salary range for Senior CF Developers in the DC area? Thanks! - Jason ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4391 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
Upgrading ColdFusion from MX 7 to 9 - Any Advice, Guidance, Best Practices, Etc?
Fellow CF Zealots: I'm in the process of having a new dedicated server being built by Hosting.com (formerly HostMySite.com) that will be running, among other things, ColdFusion 9. Once the build is completed in the next couple days, I will be systematically moving a few dozen websites from the existing box running CF MX 7 to the new box running CF 9. I'm looking for any type of input or feedback regarding any gotchas, pitfalls, etc. that I should be aware of during the upgrade. Also, does anyone have any type of best practices document, upgrade guide or whitepaper that I could review? Any help would be greatly appreciated; thank you so very much in advance! Sincerely, Christian N. Abad - President Accessible Computing, Inc. 1210 McLaughlin Drive Charlotte, NC 28212 http://www.AccessibleComputing.com 704.900.1825 (Direct Line) li...@accessiblecomputing.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Upgrading ColdFusion from MX 7 to 9 - Any Advice, Guidance, Best Practices, Etc?
Make sure you have all the hotfixes and updates installed, there were a few things that got screwed with CF9 functionality wise that have since been fixed plus some security issues as well. Other than that I think you will be pretty safe, we have not had any issues moving customers to CF9. Regards -- Russ Michaels www.cfmldeveloper.com - free CFML hosting for developers my blog: http://russ.michaels.me.uk/ skype: russmichaels ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading ColdFusion from MX 7 to 9 - Any Advice, Guidance, Best Practices, Etc?
Josh Adams recently posted a collection of information on the topic. http://blog.joshuaadams.com/index.cfm/2010/11/2/Upgrading-from-ColdFusion-MX-7-or-ColdFusion-8-to-ColdFusion-9 http://blog.joshuaadams.com/index.cfm/2010/11/2/Upgrading-from-ColdFusion-MX-7-or-ColdFusion-8-to-ColdFusion-9 -Adam On Wed, Nov 10, 2010 at 10:47 AM, Russ Michaels r...@michaels.me.uk wrote: Make sure you have all the hotfixes and updates installed, there were a few things that got screwed with CF9 functionality wise that have since been fixed plus some security issues as well. Other than that I think you will be pretty safe, we have not had any issues moving customers to CF9. Regards -- Russ Michaels www.cfmldeveloper.com - free CFML hosting for developers my blog: http://russ.michaels.me.uk/ skype: russmichaels ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Upgrading ColdFusion from MX 7 to 9 - Any Advice, Guidance, Best Practices, Etc?
On Wed, Nov 10, 2010 at 7:32 AM, Christian N. Abad li...@accessiblecomputing.com wrote: I'm in the process of having a new dedicated server being built by Hosting.com (formerly HostMySite.com) that will be running, among other things, ColdFusion 9. Once the build is completed in the next couple days, I will be systematically moving a few dozen websites from the existing box running CF MX 7 to the new box running CF 9. One thing you'll notice is that CF9 is dramatically faster than CFMX7! -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwoo ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Moving to DC, need advice
I am a Senior ColdFusion Developer that is moving out to the Washington, DC. Obviously housing is a premium in the DC area. I would like to buy or rent a house in one of the suburbs, so that we can have a fenced in yard for my dogs. What suburbs are the safest and most affordable in DC that have single family homes (not townhomes/apartments)? Which area is lower in taxes? Commuting by train/light rail would be ideal. Also, what is a typical salary range for Senior CF Developers in the DC area? Thanks! - Jason ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4349 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-jobs-talk/unsubscribe.cfm
Need Advice on Processing After a Page Has Been Rendered
I have a script that pulls data from several external sources and returns the top 500 results and takes about 3-5 seconds to render. To speed things up, I want to database the results for later use. How can I database the results while the user is viewing the page without the increasing the pages render time? In other words, how can I write the data to a database... but only after the page has been completely rendered? What would be the best way to do this? I'm currently using CF8. Thanks Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335465 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need Advice on Processing After a Page Has Been Rendered
Ajax? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need Advice on Processing After a Page Has Been Rendered
Save the query result to a session var or to a file as part of the page processing. Then have an ajax call to a secondary page that will do the insert or bulkinsert. Once the page has loaded (onLoad) have an ajax call to the secondary page. That's one way. I'm quite sure there's many others. On Mon, Jul 19, 2010 at 11:18 AM, Che Vilnonis ch...@asitv.com wrote: I have a script that pulls data from several external sources and returns the top 500 results and takes about 3-5 seconds to render. To speed things up, I want to database the results for later use. How can I database the results while the user is viewing the page without the increasing the pages render time? In other words, how can I write the data to a database... but only after the page has been completely rendered? What would be the best way to do this? I'm currently using CF8. Thanks Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335467 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need Advice on Processing After a Page Has Been Rendered
Some ideas to explore: cfhttp with an immediate timeout cfthread CF Event Gateways Writing 500 rows to a database table should only take a few milliseconds, which would be unnoticeable relative to the amount of time you say the page takes to load. If the database is slow for some reason, perhaps create a light-weight database table optimized for fast inserts. Trying to spawn another thread for database inserts might not be worth it unless the database inserts are noticeably slow. To optimize calls to external systems, explore the cfthread tag, assuming you are using the Enterprise edition of CF. -Mike Chabot On Mon, Jul 19, 2010 at 11:18 AM, Che Vilnonis ch...@asitv.com wrote: I have a script that pulls data from several external sources and returns the top 500 results and takes about 3-5 seconds to render. To speed things up, I want to database the results for later use. How can I database the results while the user is viewing the page without the increasing the pages render time? In other words, how can I write the data to a database... but only after the page has been completely rendered? What would be the best way to do this? I'm currently using CF8. Thanks Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need Advice on Processing After a Page Has Been Rendered
I've dealt with this issue time and time again. For instance, you want the results to be downloaded in an excel document but you don't want to compromise the time it takes to render just the HTML. I have an image that is hidden and a spinner saying 'loading excel results'. Then at page load an ajax call will request the process and when it is finished, will show the image that will allow the user to download the excel document. You can do exactly the same thing where you have a notification saying that the data is being inserted and then a success message after it is complete. Be careful not to set up any process that will cancel the request or the transaction may not complete. In other words, you need to ensure that the request can still process even if the page is closed or expect incomplete transactions. You might need to take a look at cftransaction or a sql transaction statement so you aren't getting partial inserts/updates. On Mon, Jul 19, 2010 at 8:59 AM, Mike Chabot mcha...@gmail.com wrote: Some ideas to explore: cfhttp with an immediate timeout cfthread CF Event Gateways Writing 500 rows to a database table should only take a few milliseconds, which would be unnoticeable relative to the amount of time you say the page takes to load. If the database is slow for some reason, perhaps create a light-weight database table optimized for fast inserts. Trying to spawn another thread for database inserts might not be worth it unless the database inserts are noticeably slow. To optimize calls to external systems, explore the cfthread tag, assuming you are using the Enterprise edition of CF. -Mike Chabot On Mon, Jul 19, 2010 at 11:18 AM, Che Vilnonis ch...@asitv.com wrote: I have a script that pulls data from several external sources and returns the top 500 results and takes about 3-5 seconds to render. To speed things up, I want to database the results for later use. How can I database the results while the user is viewing the page without the increasing the pages render time? In other words, how can I write the data to a database... but only after the page has been completely rendered? What would be the best way to do this? I'm currently using CF8. Thanks Che ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
BarCode Application | Advice Required
Dear Experts, I have a client who wants to make a barcode application for his general store for billing purposes. Its like the very common application every other departmental store uses for billing purposes for its customers. I just want to know, is it possible to develop something like that in ColdFusion (web-based technology in general). If yes, does any one has any experience to share or reference material? Regards, Arsalan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333100 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: BarCode Application | Advice Required
It's not hard to integrate barbecue into CF: http://barbecue.sourceforge.net/ mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 23 April 2010 17:42, Arsalan Tariq Keen arsalk...@hotmail.com wrote: Dear Experts, I have a client who wants to make a barcode application for his general store for billing purposes. Its like the very common application every other departmental store uses for billing purposes for its customers. I just want to know, is it possible to develop something like that in ColdFusion (web-based technology in general). If yes, does any one has any experience to share or reference material? Regards, Arsalan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333101 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Need advice on creating Login/Logout feature in CF
Hi there, I'm working on my first full CF website. I've done work in the past using CF and Flash as well as CF and Flex, so you'd think doing just CF would be easier. Unfortunately the entire process is giving me an inferiority complex. :( In any case, I'm trying to do a simple login/logout feature. I've read a number of articles discussing the use of an Application.cfc to secure an app (Ben Forta's book) but I'm still having trouble. The thing is, I don't need my entire app secure, I just need one page secured (a member_profile.cfm). I've tried placing the member_profile.cfm page in a folder and adding the Application.cfc to that folder. This works but if I want to logout of the site, I need to have my logout.cfm in the folder as well (which of course automatically asks me to login). There has got to be a better way. Should I be using an Application.cfm file? I'm clearly missing something fundamental here. Any advice/direction would be greatly appreciated. Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323781 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need advice on creating Login/Logout feature in CF
Try only using one application.cfc in the web root and then, in that file, do something like: cfif FindNoCase(member_profile.cfm, cgi.SCRIPT_NAME)!--- auth logic ---/cfif P.S. Are you using a CFML framework...? http://cfframeworks.com On Mon, Jun 22, 2009 at 3:46 PM, jason robinson ja...@planetyou.net wrote: Hi there, I'm working on my first full CF website. I've done work in the past using CF and Flash as well as CF and Flex, so you'd think doing just CF would be easier. Unfortunately the entire process is giving me an inferiority complex. :( In any case, I'm trying to do a simple login/logout feature. I've read a number of articles discussing the use of an Application.cfc to secure an app (Ben Forta's book) but I'm still having trouble. The thing is, I don't need my entire app secure, I just need one page secured (a member_profile.cfm). I've tried placing the member_profile.cfm page in a folder and adding the Application.cfc to that folder. This works but if I want to logout of the site, I need to have my logout.cfm in the folder as well (which of course automatically asks me to login). There has got to be a better way. Should I be using an Application.cfm file? I'm clearly missing something fundamental here. Any advice/direction would be greatly appreciated. Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need advice on creating Login/Logout feature in CF
So, put your one template in it's own folder, with it's own Application.cfc that extends the root Application.cfc, but has additional functionality added to it's methods. Say you have an onRequestStart method in the root Application.cfc. You want the functionality of that method, plus the security stuff: cffunction name=onRequestStart access=public output=false returnType=boolean cfargument name=thePage type=string required=true / cfset SUPER.onRequestStart(thePage = ARGUMENTS.thePage) / !--- The security logic stuff --- cfreturn true / /cffunction Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com On 6/22/2009 3:46 PM, jason robinson wrote: Hi there, I'm working on my first full CF website. I've done work in the past using CF and Flash as well as CF and Flex, so you'd think doing just CF would be easier. Unfortunately the entire process is giving me an inferiority complex. :( In any case, I'm trying to do a simple login/logout feature. I've read a number of articles discussing the use of an Application.cfc to secure an app (Ben Forta's book) but I'm still having trouble. The thing is, I don't need my entire app secure, I just need one page secured (a member_profile.cfm). I've tried placing the member_profile.cfm page in a folder and adding the Application.cfc to that folder. This works but if I want to logout of the site, I need to have my logout.cfm in the folder as well (which of course automatically asks me to login). There has got to be a better way. Should I be using an Application.cfm file? I'm clearly missing something fundamental here. Any advice/direction would be greatly appreciated. Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323784 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for advice on how to do this - remote printing
Hello Mike, You should check out WebSDK from Nicelabel (http://www.nivelabel.com) A bit costly maybe but with the potential of hundreds of remote points.. We use it for onsite checkin to conferences/meetings etc. work very well. Helge -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: 10. juni 2009 4:35 To: cf-talk Subject: Re: Looking for advice on how to do this - remote printing I am afraid i dont know we're only starting out on a new project but it could be dozens or even hundreds of remote points, scattered all over the place. So that represents lots of scalability issues in designing the application which i'm giving a lot of thought. But its the remote printing to a whole variety of locations, where there will be no interaction with the system apart from a non-IT trained person picking up the printed out put and executing the job.It's the connectivity to all those devices and how to trigger the printing that gives me cause to ponder. We can have intelligence on that device so it can format printing and all that if i sent it a XML packet or some such. It would be good to be able to require only a power point there if possible - so they plug it into the power, turn it on at the wall and its available to the system by itself. that way there's no need for us to provide keyboards, screens, training etc if that is at all possible. Certainly no specialised staff. I'm sorry if i have to be a bit vague about the actual specifics of the app - its still in progress and once launch i can say more. But since we're only now scoping out the job launch is a while away yet. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Jun 11, 2009 at 12:22 AM, Ryan Letullebayous...@gmail.com wrote: How many daily tickets on average? -- Ryan LeTulle On Wed, Jun 10, 2009 at 2:28 AM, Mike Kear afpwebwo...@gmail.com wrote: I am working on a project where I am going to have to print up a job ticket in a remote location. An event happens on the web site, and it causes this job ticket to print out in one of perhaps thousands of locations unattended. The people who are going to fill the job will have no interaction with teh system except to take the job ticket off the printer and do the task. We've specced out the whole application except for the part where we connect all these remote locations to the web site. What i want is to be able to push a xml packet to this remote location and get back an ack so i know its been received and executed. Since there will be minimal training of the staff at the remote locations and they wont necessarily have access to IT staff or other specialists, we were hoping to be able to keep it as simple as the EFTPOS terminals they have in retail stores. The main difference is that with a EFTPOS terminal the store clerk starts the transaction - we're going to start this transaction at the other end and push it down to the remote location. Daily running cost is a factor, so we dont want to have the remote devices making calls to our system by modem every few minutes - we want to have it all run from our web site. Any ideas on how this could be done? The environment as far as we have it: We have a CF8 Enterprise/Win2003/SQLServer web site, and think the remote sites will need a small low-cost self-contained Linux box with a little thermal printer or something but exactly how they're connected we havent worked out yet. Anyone have experience with this kind of scenario? Perhaps a factory job ticket or a retail point of sale system maybe? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Looking for advice on how to do this - remote printing
I am working on a project where I am going to have to print up a job ticket in a remote location. An event happens on the web site, and it causes this job ticket to print out in one of perhaps thousands of locations unattended.The people who are going to fill the job will have no interaction with teh system except to take the job ticket off the printer and do the task. We've specced out the whole application except for the part where we connect all these remote locations to the web site.What i want is to be able to push a xml packet to this remote location and get back an ack so i know its been received and executed. Since there will be minimal training of the staff at the remote locations and they wont necessarily have access to IT staff or other specialists, we were hoping to be able to keep it as simple as the EFTPOS terminals they have in retail stores. The main difference is that with a EFTPOS terminal the store clerk starts the transaction - we're going to start this transaction at the other end and push it down to the remote location. Daily running cost is a factor, so we dont want to have the remote devices making calls to our system by modem every few minutes - we want to have it all run from our web site. Any ideas on how this could be done? The environment as far as we have it: We have a CF8 Enterprise/Win2003/SQLServer web site, and think the remote sites will need a small low-cost self-contained Linux box with a little thermal printer or something but exactly how they're connected we havent worked out yet. Anyone have experience with this kind of scenario? Perhaps a factory job ticket or a retail point of sale system maybe? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323328 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for advice on how to do this - remote printing
I had a similar, yet much smaller project last summer... Our student center allows students to checkout laptops for a couple of hours. The staff wanted to be able to print receipts when checked-out/in. Also, the system was to be web-based. We purchased an Epson POS thermal printer with USB and attached it to a remote computer. (By remote, I mean across campus about 1000' away.) Once the USB POS printer was connected to the remote computer, I shared the printer. On the web server, I connected to the remote POS printer. Then, I was able to send text files to the POS printer and have it print correctly. Finally, I created my CF application that generates a string of text and command characters. This string is saved to a text file, on the web server. CFEXECUTE then runs a print command that passes the text file to the POS printer. The printer prints and everyone is happy. Thanks, Mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for advice on how to do this - remote printing
I did a similar thing by sending a fax to the remote locations. Worked nicely. The fax told them the job, and also told them to acknowledge receipt on the website.. so they would go to the website and a list of pending jobs was waiting for them, in case they missed a fax somehow.. Then they just check off the completed items. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for advice on how to do this - remote printing
How many daily tickets on average? -- Ryan LeTulle On Wed, Jun 10, 2009 at 2:28 AM, Mike Kear afpwebwo...@gmail.com wrote: I am working on a project where I am going to have to print up a job ticket in a remote location. An event happens on the web site, and it causes this job ticket to print out in one of perhaps thousands of locations unattended.The people who are going to fill the job will have no interaction with teh system except to take the job ticket off the printer and do the task. We've specced out the whole application except for the part where we connect all these remote locations to the web site.What i want is to be able to push a xml packet to this remote location and get back an ack so i know its been received and executed. Since there will be minimal training of the staff at the remote locations and they wont necessarily have access to IT staff or other specialists, we were hoping to be able to keep it as simple as the EFTPOS terminals they have in retail stores. The main difference is that with a EFTPOS terminal the store clerk starts the transaction - we're going to start this transaction at the other end and push it down to the remote location. Daily running cost is a factor, so we dont want to have the remote devices making calls to our system by modem every few minutes - we want to have it all run from our web site. Any ideas on how this could be done? The environment as far as we have it: We have a CF8 Enterprise/Win2003/SQLServer web site, and think the remote sites will need a small low-cost self-contained Linux box with a little thermal printer or something but exactly how they're connected we havent worked out yet. Anyone have experience with this kind of scenario? Perhaps a factory job ticket or a retail point of sale system maybe? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323337 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Looking for advice on how to do this - remote printing
I am afraid i dont know we're only starting out on a new project but it could be dozens or even hundreds of remote points, scattered all over the place. So that represents lots of scalability issues in designing the application which i'm giving a lot of thought. But its the remote printing to a whole variety of locations, where there will be no interaction with the system apart from a non-IT trained person picking up the printed out put and executing the job.It's the connectivity to all those devices and how to trigger the printing that gives me cause to ponder. We can have intelligence on that device so it can format printing and all that if i sent it a XML packet or some such. It would be good to be able to require only a power point there if possible - so they plug it into the power, turn it on at the wall and its available to the system by itself. that way there's no need for us to provide keyboards, screens, training etc if that is at all possible. Certainly no specialised staff. I'm sorry if i have to be a bit vague about the actual specifics of the app - its still in progress and once launch i can say more. But since we're only now scoping out the job launch is a while away yet. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Jun 11, 2009 at 12:22 AM, Ryan Letullebayous...@gmail.com wrote: How many daily tickets on average? -- Ryan LeTulle On Wed, Jun 10, 2009 at 2:28 AM, Mike Kear afpwebwo...@gmail.com wrote: I am working on a project where I am going to have to print up a job ticket in a remote location. An event happens on the web site, and it causes this job ticket to print out in one of perhaps thousands of locations unattended. The people who are going to fill the job will have no interaction with teh system except to take the job ticket off the printer and do the task. We've specced out the whole application except for the part where we connect all these remote locations to the web site. What i want is to be able to push a xml packet to this remote location and get back an ack so i know its been received and executed. Since there will be minimal training of the staff at the remote locations and they wont necessarily have access to IT staff or other specialists, we were hoping to be able to keep it as simple as the EFTPOS terminals they have in retail stores. The main difference is that with a EFTPOS terminal the store clerk starts the transaction - we're going to start this transaction at the other end and push it down to the remote location. Daily running cost is a factor, so we dont want to have the remote devices making calls to our system by modem every few minutes - we want to have it all run from our web site. Any ideas on how this could be done? The environment as far as we have it: We have a CF8 Enterprise/Win2003/SQLServer web site, and think the remote sites will need a small low-cost self-contained Linux box with a little thermal printer or something but exactly how they're connected we havent worked out yet. Anyone have experience with this kind of scenario? Perhaps a factory job ticket or a retail point of sale system maybe? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for advice on how to do this - remote printing
In my earlier reply, I mentioned that we are using an Epson POS printer with USB. This same printer can be used with a built-in NIC. That means it would not need a host computer to which it is attached. Thanks, Mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for advice on how to do this - remote printing
Something like Mike's printer solution sounds promising to me. You might need to look into some special formatting/pl for the output so the printer can understand it natively though. I did some work in labs with Zebra printers that required that to print out barcodes. -- Ryan LeTulle On Wed, Jun 10, 2009 at 9:44 AM, Dawson, Michael m...@evansville.eduwrote: In my earlier reply, I mentioned that we are using an Epson POS printer with USB. This same printer can be used with a built-in NIC. That means it would not need a host computer to which it is attached. Thanks, Mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Looking for advice on how to do this - remote printing
What is the nature of the connection between the server and these printers? Will they be on the same LAN or WAN or are they only going to be accessible over the internet? If the former, many modern network printers have the capability to be sent print jobs to their IP address. Thus I would suggest digging up the specifications of these printers and see what options they may be exposing for you. HTH Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for advice on how to do this - remote printing
You guys are all being very helpful, as always. This is good stuff and it's helping me work out possibilities. @Mike Dawson: thanks Mike, directly accessing the NIC wont work in this case because we wont have all these devices on the same premises. They'll be too remote for a single network.Depending on how the project develops once it's launched, there could be devices all over the country. I dont think you can connect on a single network that far can you and therefore be able to access the NICs directly? I think it will require internet if we're to keep it low cost? @Ryan LeTulle: yes i think thats a certainty.That way we send the absolute minimum of data down the line and use the programmign inside the printer to format it and make it look pretty for the user. It's a fairly straightforward process to have templates stored in laser printer memory and overlaid with all kinds of fonts, graphics, logos, shading etc so a small amount of data prints up as quite a complex page. And you can manipulate those templates remotely too. I did that for several years before i started building web sites. @Ian Skinner: Thanks Ian, that's really the nub of the discussion at our end - how are we going to connect the print devices? I have a background in programming laser printers - that's what i did for a living before getting into web development. so i have no problem taking text and converting it using PCL or PostScript or other language formats so it produces pretty print from a tiny ASCII text file. But the issue for us is how to connect these devices? If we connect them to the internet, there's a modem and phone line and connection to pay for. If we use a wifi connection we can probably do a deal for many of the little dongles and get the cost of that down, but then cell phone coverage is great in the cities but pretty flaky in a lot of areas outside the cities. Most of these locations have a fax, so another option would be to connect our device to that somehow, rather in the way the answering machines pass faxes through and snag people talking I'm kind of hoping someone is going to say why dont you and suggest one of those 'slap the forehead'-'why the hell didn't *I* think of that! ideas. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Jun 11, 2009 at 12:59 AM, Ian Skinnerh...@ilsweb.com wrote: What is the nature of the connection between the server and these printers? Will they be on the same LAN or WAN or are they only going to be accessible over the internet? If the former, many modern network printers have the capability to be sent print jobs to their IP address. Thus I would suggest digging up the specifications of these printers and see what options they may be exposing for you. HTH Ian ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for advice on how to do this - remote printing
They'll be too remote for a single network.Depending on how the project develops once it's launched, there could be devices all over the country. I dont think you can connect on a single network that far can you and therefore be able to access the NICs directly? I think it will require internet if we're to keep it low cost? It is possible with a VPN through the internets. However, I'm no network guy, so I can't give you the details on what it would take. mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323356 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: need some database advice
Yeah.. I realized that I was the only one that has already listened to the entire song catalog. But like you said, for most people that won't be the case and I will make my mark all listened link only mark the songs listed on the page, not the entire catalog. Thanks! Mike Barney Boisvert wrote: Databases are good at storing data. With proper indexing, a few million rows is nothing. I'd store tracks listened to. Make the model simpler, speed user creation, and odds are most people are going to listen to less than 25K distinct songs so it'll require less rows too. --- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com On Jan 12, 2009, at 11:37 PM, Mike Soultanian msoul...@csulb.edu wrote: Hey Everyone, I have a project and I'm trying to figure out the best way to go about it. What I want to do is keep track of what songs a user has listened to and what songs they haven't. The first thing that comes to mind is a table with song IDs and a table with user IDs and a join table between the two that keeps track of what song a user has listened to. With 50,000 songs, that could be a lot of records in the join table. Is there a more efficient way to tackle this kind of problem? I don't think I'll have that many users, but even if I had ten users, that table could be pretty big. I'm trying to think if there are any tricks such as whether to store if a user has listened to a track or store if they haven't. I plan to have a button called mark all as listened, which could empty the join table of any records pertaining to that user if I was storing the tracks they didn't listen to. So the join table would initially start out very large for a user and then drop down... that's just one thought I had. If anyone has any tricks, I'd appreciate your advise! Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: need some database advice
What do you do when they hit mark all listened? Barney Boisvert wrote: Databases are good at storing data. With proper indexing, a few million rows is nothing. I'd store tracks listened to. Make the model simpler, speed user creation, and odds are most people are going to listen to less than 25K distinct songs so it'll require less rows too. --- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com On Jan 12, 2009, at 11:37 PM, Mike Soultanian msoul...@csulb.edu wrote: Hey Everyone, I have a project and I'm trying to figure out the best way to go about it. What I want to do is keep track of what songs a user has listened to and what songs they haven't. The first thing that comes to mind is a table with song IDs and a table with user IDs and a join table between the two that keeps track of what song a user has listened to. With 50,000 songs, that could be a lot of records in the join table. Is there a more efficient way to tackle this kind of problem? I don't think I'll have that many users, but even if I had ten users, that table could be pretty big. I'm trying to think if there are any tricks such as whether to store if a user has listened to a track or store if they haven't. I plan to have a button called mark all as listened, which could empty the join table of any records pertaining to that user if I was storing the tracks they didn't listen to. So the join table would initially start out very large for a user and then drop down... that's just one thought I had. If anyone has any tricks, I'd appreciate your advise! Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317831 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: need some database advice
Insert into linkTable Select song.id, #userId# from song Where not exists ( Select * From linkTable Where songId = song.id And userId = #userId# ) Obviously with CFQUERYPARAM and no auto-capitalize. cheers, barneyb On 1/13/09, Mike Soultanian msoul...@csulb.edu wrote: What do you do when they hit mark all listened? Barney Boisvert wrote: Databases are good at storing data. With proper indexing, a few million rows is nothing. I'd store tracks listened to. Make the model simpler, speed user creation, and odds are most people are going to listen to less than 25K distinct songs so it'll require less rows too. --- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com On Jan 12, 2009, at 11:37 PM, Mike Soultanian msoul...@csulb.edu wrote: Hey Everyone, I have a project and I'm trying to figure out the best way to go about it. What I want to do is keep track of what songs a user has listened to and what songs they haven't. The first thing that comes to mind is a table with song IDs and a table with user IDs and a join table between the two that keeps track of what song a user has listened to. With 50,000 songs, that could be a lot of records in the join table. Is there a more efficient way to tackle this kind of problem? I don't think I'll have that many users, but even if I had ten users, that table could be pretty big. I'm trying to think if there are any tricks such as whether to store if a user has listened to a track or store if they haven't. I plan to have a button called mark all as listened, which could empty the join table of any records pertaining to that user if I was storing the tracks they didn't listen to. So the join table would initially start out very large for a user and then drop down... that's just one thought I had. If anyone has any tricks, I'd appreciate your advise! Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317832 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: need some database advice
I'm doing the same but with voting. People get to vote once per item and I store this so they can't vote again. I'm doing something like: SELECT vote FROM vote WHERE userID = theUserVoting AND itemID = theItemTheyreAttemptingToVoteFor This runs a lot and so far so good. What I AM having problems with is getting a random item that they've yet to vote for. I have this: SELECT TOP 1 itemID FROM item WHERE itemID NOT IN ( SELECT itemID FROM vote WHERE userID = theUserVoting ) I've read around a bit and EXISTS might be the way forward but the examples I've read use IN and not NOT IN. Any ideas? Sorry for the half-a-thread hijack! Adrian -Original Message- From: Mike Soultanian [mailto:msoul...@csulb.edu] Sent: 13 January 2009 07:37 To: cf-talk Subject: need some database advice Hey Everyone, I have a project and I'm trying to figure out the best way to go about it. What I want to do is keep track of what songs a user has listened to and what songs they haven't. The first thing that comes to mind is a table with song IDs and a table with user IDs and a join table between the two that keeps track of what song a user has listened to. With 50,000 songs, that could be a lot of records in the join table. Is there a more efficient way to tackle this kind of problem? I don't think I'll have that many users, but even if I had ten users, that table could be pretty big. I'm trying to think if there are any tricks such as whether to store if a user has listened to a track or store if they haven't. I plan to have a button called mark all as listened, which could empty the join table of any records pertaining to that user if I was storing the tracks they didn't listen to. So the join table would initially start out very large for a user and then drop down... that's just one thought I had. If anyone has any tricks, I'd appreciate your advise! Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317843 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: need some database advice
SELECT TOP 1 itemID FROM item WHERE itemID NOT IN ( SELECT itemID FROM vote WHERE userID = theUserVoting ) That doesn't work? Should work fine, as should NOT EXISTS: SELECT TOP 1 i.itemID FROM item i WHERE NOT EXISTS ( SELECT v.itemID FROM vote v WHERE v.itemId = i.itemId AND v.userID = theUserVoting ) Dom 2009/1/13 Adrian Lynch cont...@adrianlynch.co.uk: I'm doing the same but with voting. People get to vote once per item and I store this so they can't vote again. I'm doing something like: SELECT vote FROM vote WHERE userID = theUserVoting AND itemID = theItemTheyreAttemptingToVoteFor This runs a lot and so far so good. What I AM having problems with is getting a random item that they've yet to vote for. I have this: SELECT TOP 1 itemID FROM item WHERE itemID NOT IN ( SELECT itemID FROM vote WHERE userID = theUserVoting ) I've read around a bit and EXISTS might be the way forward but the examples I've read use IN and not NOT IN. Any ideas? Sorry for the half-a-thread hijack! Adrian -Original Message- From: Mike Soultanian [mailto:msoul...@csulb.edu] Sent: 13 January 2009 07:37 To: cf-talk Subject: need some database advice Hey Everyone, I have a project and I'm trying to figure out the best way to go about it. What I want to do is keep track of what songs a user has listened to and what songs they haven't. The first thing that comes to mind is a table with song IDs and a table with user IDs and a join table between the two that keeps track of what song a user has listened to. With 50,000 songs, that could be a lot of records in the join table. Is there a more efficient way to tackle this kind of problem? I don't think I'll have that many users, but even if I had ten users, that table could be pretty big. I'm trying to think if there are any tricks such as whether to store if a user has listened to a track or store if they haven't. I plan to have a button called mark all as listened, which could empty the join table of any records pertaining to that user if I was storing the tracks they didn't listen to. So the join table would initially start out very large for a user and then drop down... that's just one thought I had. If anyone has any tricks, I'd appreciate your advise! Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: need some database advice
Cheers Dom. I read that NOT EXISTS did little or nothing for performance in this case. Of course I can't point you to where I read that! Anyone know for sure? Adrian -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: 13 January 2009 13:48 To: cf-talk Subject: Re: need some database advice SELECT TOP 1 itemID FROM item WHERE itemID NOT IN ( SELECT itemID FROM vote WHERE userID = theUserVoting ) That doesn't work? Should work fine, as should NOT EXISTS: SELECT TOP 1 i.itemID FROM item i WHERE NOT EXISTS ( SELECT v.itemID FROM vote v WHERE v.itemId = i.itemId AND v.userID = theUserVoting ) Dom 2009/1/13 Adrian Lynch cont...@adrianlynch.co.uk: I'm doing the same but with voting. People get to vote once per item and I store this so they can't vote again. I'm doing something like: SELECT vote FROM vote WHERE userID = theUserVoting AND itemID = theItemTheyreAttemptingToVoteFor This runs a lot and so far so good. What I AM having problems with is getting a random item that they've yet to vote for. I have this: SELECT TOP 1 itemID FROM item WHERE itemID NOT IN ( SELECT itemID FROM vote WHERE userID = theUserVoting ) I've read around a bit and EXISTS might be the way forward but the examples I've read use IN and not NOT IN. Any ideas? Sorry for the half-a-thread hijack! Adrian -Original Message- From: Mike Soultanian [mailto:msoul...@csulb.edu] Sent: 13 January 2009 07:37 To: cf-talk Subject: need some database advice Hey Everyone, I have a project and I'm trying to figure out the best way to go about it. What I want to do is keep track of what songs a user has listened to and what songs they haven't. The first thing that comes to mind is a table with song IDs and a table with user IDs and a join table between the two that keeps track of what song a user has listened to. With 50,000 songs, that could be a lot of records in the join table. Is there a more efficient way to tackle this kind of problem? I don't think I'll have that many users, but even if I had ten users, that table could be pretty big. I'm trying to think if there are any tricks such as whether to store if a user has listened to a track or store if they haven't. I plan to have a button called mark all as listened, which could empty the join table of any records pertaining to that user if I was storing the tracks they didn't listen to. So the join table would initially start out very large for a user and then drop down... that's just one thought I had. If anyone has any tricks, I'd appreciate your advise! Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317846 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: need some database advice
Unless all the users listen All songs, the cross table will not be that large. The only trouble with a cross table is when you have to replace joins by others. In your case you don't even have that problem since all what can happen is adding new records. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317851 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: need some database advice
I've heard that NOT EXISTS works better with a larger set of records.. If it's only a few I heard that NOT IN would be better to use. Of course this is just what I heard from our Oracle DBA a few years ago. So YMMV... best choice is to run a test.. load 50K rows and check. On Tue, Jan 13, 2009 at 8:14 AM, Adrian Lynch cont...@adrianlynch.co.uk wrote: Cheers Dom. I read that NOT EXISTS did little or nothing for performance in this case. Of course I can't point you to where I read that! Anyone know for sure? Adrian -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: 13 January 2009 13:48 To: cf-talk Subject: Re: need some database advice SELECT TOP 1 itemID FROM item WHERE itemID NOT IN ( SELECT itemID FROM vote WHERE userID = theUserVoting ) That doesn't work? Should work fine, as should NOT EXISTS: SELECT TOP 1 i.itemID FROM item i WHERE NOT EXISTS ( SELECT v.itemID FROM vote v WHERE v.itemId = i.itemId AND v.userID = theUserVoting ) Dom 2009/1/13 Adrian Lynch cont...@adrianlynch.co.uk: I'm doing the same but with voting. People get to vote once per item and I store this so they can't vote again. I'm doing something like: SELECT vote FROM vote WHERE userID = theUserVoting AND itemID = theItemTheyreAttemptingToVoteFor This runs a lot and so far so good. What I AM having problems with is getting a random item that they've yet to vote for. I have this: SELECT TOP 1 itemID FROM item WHERE itemID NOT IN ( SELECT itemID FROM vote WHERE userID = theUserVoting ) I've read around a bit and EXISTS might be the way forward but the examples I've read use IN and not NOT IN. Any ideas? Sorry for the half-a-thread hijack! Adrian -Original Message- From: Mike Soultanian [mailto:msoul...@csulb.edu] Sent: 13 January 2009 07:37 To: cf-talk Subject: need some database advice Hey Everyone, I have a project and I'm trying to figure out the best way to go about it. What I want to do is keep track of what songs a user has listened to and what songs they haven't. The first thing that comes to mind is a table with song IDs and a table with user IDs and a join table between the two that keeps track of what song a user has listened to. With 50,000 songs, that could be a lot of records in the join table. Is there a more efficient way to tackle this kind of problem? I don't think I'll have that many users, but even if I had ten users, that table could be pretty big. I'm trying to think if there are any tricks such as whether to store if a user has listened to a track or store if they haven't. I plan to have a button called mark all as listened, which could empty the join table of any records pertaining to that user if I was storing the tracks they didn't listen to. So the join table would initially start out very large for a user and then drop down... that's just one thought I had. If anyone has any tricks, I'd appreciate your advise! Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317852 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
need some database advice
Hey Everyone, I have a project and I'm trying to figure out the best way to go about it. What I want to do is keep track of what songs a user has listened to and what songs they haven't. The first thing that comes to mind is a table with song IDs and a table with user IDs and a join table between the two that keeps track of what song a user has listened to. With 50,000 songs, that could be a lot of records in the join table. Is there a more efficient way to tackle this kind of problem? I don't think I'll have that many users, but even if I had ten users, that table could be pretty big. I'm trying to think if there are any tricks such as whether to store if a user has listened to a track or store if they haven't. I plan to have a button called mark all as listened, which could empty the join table of any records pertaining to that user if I was storing the tracks they didn't listen to. So the join table would initially start out very large for a user and then drop down... that's just one thought I had. If anyone has any tricks, I'd appreciate your advise! Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317829 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: need some database advice
Databases are good at storing data. With proper indexing, a few million rows is nothing. I'd store tracks listened to. Make the model simpler, speed user creation, and odds are most people are going to listen to less than 25K distinct songs so it'll require less rows too. --- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com On Jan 12, 2009, at 11:37 PM, Mike Soultanian msoul...@csulb.edu wrote: Hey Everyone, I have a project and I'm trying to figure out the best way to go about it. What I want to do is keep track of what songs a user has listened to and what songs they haven't. The first thing that comes to mind is a table with song IDs and a table with user IDs and a join table between the two that keeps track of what song a user has listened to. With 50,000 songs, that could be a lot of records in the join table. Is there a more efficient way to tackle this kind of problem? I don't think I'll have that many users, but even if I had ten users, that table could be pretty big. I'm trying to think if there are any tricks such as whether to store if a user has listened to a track or store if they haven't. I plan to have a button called mark all as listened, which could empty the join table of any records pertaining to that user if I was storing the tracks they didn't listen to. So the join table would initially start out very large for a user and then drop down... that's just one thought I had. If anyone has any tricks, I'd appreciate your advise! Thanks, Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317830 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
product search query - advice needed
hi guys, i have a product table with over 500 records in it. each product is linked to a category and brand. when a user inputs a search i need all three elements searched (plus other fields as you will see in query below). at the moment, the query is not the fastest of queries (database is mysql). i was wondering if anyone can see any obvious mistakes i am making with this function... pid = product id cid = category id bid = brand id cfquery SELECT P.pid, P.price, P.price_sale, P.bid, P.display, P.views, PD.ptitle, PD.availability FROM tblProducts P INNER JOIN tblProductDesc PD ON P.pid = PD.pid INNER JOIN tblProductCatLink PCL ON P.pid = PCL.pid INNER JOIN tblCat C ON PCL.cid = C.cid INNER JOIN tblCatDesc CD ON C.cid = CD.cid INNER JOIN tblBrand B ON P.bid = B.bid WHERE ((P.code LIKE '%searchstring%') OR (PD.ptitle LIKE '%searchstring%') OR (PD.pdesc LIKE '%searchstring%') OR (PD.fill_type LIKE '%searchstring%') OR (PD.summary LIKE '%searchstring%') OR (PD.features LIKE '%searchstring%') OR (CD.ctitle LIKE '%searchstring%') OR (B.btitle LIKE '%searchstring%')) AND P.display = 1 GROUP BY P.pid, P.price, P.price_sale, P.bid, P.display, P.views, PD.ptitle, PD.availability ORDER BY PD.ptitle ASC /cfquery thanks heaps. mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: product search query - advice needed
First up, I'm sure you don't need telling you should be using CFQUERYPARAM for your query variables... (Of course, you may have just omitted that to simplify your example). It's not the easiest query to optimise; have you considered a different approch: make a Verity index of your products. It's not something I've done much of myself, but it should also give you other benefits such as better returns for near matches... (If Verity isn't a good way to go for this, I'm sure someone will correct me...) Seb Seb Duggan Web ColdFusion Developer e: s...@sebduggan.com t: 07786 333184 w: http://sebduggan.com From: Mike Little m...@nzsolutions.co.nz Sent: 16 December 2008 09:06 To: cf-talk cf-talk@houseoffusion.com Subject: product search query - advice needed hi guys, i have a product table with over 500 records in it. each product is linked to a category and brand. when a user inputs a search i need all three elements searched (plus other fields as you will see in query below). at the moment, the query is not the fastest of queries (database is mysql). i was wondering if anyone can see any obvious mistakes i am making with this function... pid = product id cid = category id bid = brand id SELECT P.pid, P.price, P.price_sale, P.bid, P.display, P.views, PD.ptitle, PD.availability FROM tblProducts P INNER JOIN tblProductDesc PD ON P.pid = PD.pid INNER JOIN tblProductCatLink PCL ON P.pid = PCL.pid INNER JOIN tblCat C ON PCL.cid = C.cid INNER JOIN tblCatDesc CD ON C.cid = CD.cid INNER JOIN tblBrand B ON P.bid = B.bid WHERE ((P.code LIKE '%searchstring%') OR (PD.ptitle LIKE '%searchstring%') OR (PD.pdesc LIKE '%searchstring%') OR (PD.fill_type LIKE '%searchstring%') OR (PD.summary LIKE '%searchstring%') OR (PD.features LIKE '%searchstring%') OR (CD.ctitle LIKE '%searchstring%') OR (B.btitle LIKE '%searchstring%')) AND P.display = 1 GROUP BY P.pid, P.price, P.price_sale, P.bid, P.display, P.views, PD.ptitle, PD.availability ORDER BY PD.ptitle ASC thanks heaps. mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: product search query - advice needed
Nothing is glaring, but you would definitely want to look at optimizing MYSQL for this. You can create indexes, views, etc that should help with the speed. Take a look at http://www.learn-mysql-tutorial.com/ for a bunch of optimization tips/tricks. hi guys, i have a product table with over 500 records in it. each product is linked to a category and brand. when a user inputs a search i need all three elements searched (plus other fields as you will see in query below). at the moment, the query is not the fastest of queries (database is mysql). i was wondering if anyone can see any obvious mistakes i am making with this function... pid = product id cid = category id bid = brand id cfquery SELECT P.pid, P.price, P.price_sale, P.bid, P.display, P.views, PD. ptitle, PD.availability FROM tblProducts P INNER JOIN tblProductDesc PD ON P.pid = PD.pid INNER JOIN tblProductCatLink PCL ON P.pid = PCL.pid INNER JOIN tblCat C ON PCL.cid = C.cid INNER JOIN tblCatDesc CD ON C.cid = CD.cid INNER JOIN tblBrand B ON P.bid = B.bid WHERE ((P.code LIKE '%searchstring%') OR (PD.ptitle LIKE '%searchstring%') OR (PD.pdesc LIKE '%searchstring%') OR (PD.fill_type LIKE '%searchstring%') OR (PD.summary LIKE '%searchstring%') OR (PD. features LIKE '%searchstring%') OR (CD.ctitle LIKE '%searchstring%') OR (B.btitle LIKE '%searchstring%')) AND P.display = 1 GROUP BY P.pid, P.price, P.price_sale, P.bid, P.display, P.views, PD. ptitle, PD.availability ORDER BY PD.ptitle ASC /cfquery thanks heaps. mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: product search query - advice needed
thanks seb and jd, i will look into views in mysql - i was actually oblivious to the fact that i could do this in 4? i have used mssql in the past where i could use both views and stored procedures so this is a bit new to me. the search sting is generated autmatically using boolsearch so i will need to update that function to include cfqueryparams. good advice. mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316816 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: product search query - advice needed
ah, just discovered my version of mysql 4.1.18 does not support views. i shall talk nicely to my webhost i think!!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316819 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: product search query - advice needed
The main reason why I switched from MySQL to PostgreSQL years ago was that MySQL failed to support standard RDBMS features including views, stored procedures, functions, transactions, triggers and more. I hear the newer versions of MySQL can do some of these now, but why limit yourself. Get PostgreSQL http://www.postgresql.org Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Dec 16, 2008, at 2:04 PM, Mike Little wrote: ah, just discovered my version of mysql 4.1.18 does not support views. i shall talk nicely to my webhost i think!!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316820 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Upload of files (particularly images) - advice needed...
Thanks for the input - but not really what I am looking for. I am leaning towards some kinda flash/customtag - I've seen a couple of examples online but none that quite satisfy all my needs at once. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Upload of files (particularly images) - advice needed...
- faster uploads - multiple file upload - limits on how large files you can upload (bytesize) - limits on how large images you can upload (pixelsize) - good error handling So... any recommendations? Thx :o) I would think CFMultiUploader would solve a lot of your issues. http://www.danvega.org/blog/index.cfm/cfmu It does multiple file upload elegantly, and does allow a limit on bytesize. Regarding your 1st request - that is more a client/server issue and while good code can help - someone uploading a bunch of files on a slow connection - it will be slow no matter what. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315283 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Upload of files (particularly images) - advice needed...
I mean fast in comparison to the traditional form-post upload - I am sure most solutions would be faster than that :) But I'll definitely look into your suggestion. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315321 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Upload of files (particularly images) - advice needed...
Hello experts We are looking to improve file uploads into our CMS. Currently we are using a form-post and CFFile, but I am not happy with the performance. I have the following wishlist; - faster uploads - multiple file upload - limits on how large files you can upload (bytesize) - limits on how large images you can upload (pixelsize) - good error handling So... any recommendations? Thx :o) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315190 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Upload of files (particularly images) - advice needed...
What we have done is write up a client application that converts the image files to BASE64 format and then break these text files up into smaller chunks and then transmit them piece by piece... The client piece is done in .NET but you may be able to swing it in JS but I am not certain though.. Let me know if you want more information Hello experts We are looking to improve file uploads into our CMS. Currently we are using a form-post and CFFile, but I am not happy with the performance. I have the following wishlist; - faster uploads - multiple file upload - limits on how large files you can upload (bytesize) - limits on how large images you can upload (pixelsize) - good error handling So... any recommendations? Thx :o) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315200 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) Apache Configuration Advice
I will just post a link to what I submitted to the CF-OT forum. But, this is an important issue to us and I wanted to make sure as wide an audience sees it as permissible. Looking at the CF-OT forum, it seems to be a sparsely used list and I do not know how well attend it is. I've poised this issue at an Apache form [http://www.apacheforum.com/forumdisplay.php?f=15] as well. But it does not seem to be a hot bed of activity either. I'll gladly accept other recommendations for appropriate and useful lists to post my issue to. Apache Configuration Advice: http://www.houseoffusion.com/groups/cf-ot/thread.cfm/threadid:136. TIA Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311218 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for advice on permissions
IMHO, independant permissions for viewing, adding, editing, deleting elements may be going too much into details and obviously adding to the complexity. Having only one permission for each type of element should be enough. - any one can view elements on the public site anyway, so no permission is needed; - permission for adding elements, but not editing or deleting it in case of error is kind of weird; - why any one could delete an element, but not just modify it is there is anything wrong with it? My system uses a table for all CMS types of elements (less than 20 of them). Each type has a two characters code. Every user has a list of all types he can edit (ie: view, add, modify, delete); This list is set in a session variable at login time. In the admin module, the menu is generated according to the codes found in this permissions list. As an extra security measure, the presence of the element code in the list is checked again at the top of all editing modules (one line of code). Setting perrmissions for users is just a matter of checking appropriates checkboxes in a form and storing the list of permissions in the appropriate field for this user. Now I agree that this appraoch is not database wise normalized, but it is much more easy and efficient if you have say less than 1000 different types of permisions. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307601 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Looking for advice on permissions
Thanks for your suggestions Claude. Perhaps i should give you a bit more background to this project. Just to clarify, the scenario is about the opposite to the one you are puzzled by. I see the circumstances where we might want to allow someone to edit content, but for safety's sake not delete it or add new content. Also i have a current need at a radio station to allow the sports people to work on the sports part of the site, but not touch the programming pages. We want to let the people working on one radio show to be able to update their page - add, edit and delete content, but only from their page.I dont want to let them accidentally (or deliberately - egos are huge at a radio station!) interfere with any other show's content. Another client is a professional association and has the same CMS. They have lots of user groups, related to the different branches of the profession. Most of the content on that site is only visible to people who are logged in. There's a basic .site visible to the wide world, but most of the meat is only visible to people who are logged in. We also want to make some content visible only to people who are logged in AND who are members of a user group - Usergroup executive meeting minutes for example, or policy white papers. Thats why i wanted to set up the permissions to be able to assign read as well as add/edit/delete rights. I'm doing it at the moment but its clumsy and a real kludge, and if anyone comes up with a new scenario that i need to account for, it will probably hurt my brain figuring it out. So since i'm working on the next version of the CMS now, i'd like to incorporate a better permissions scheme if i can find one.If i can't, i'll make do with what i have. Hence my original question. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307634 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for advice on permissions
Thanks Gerald, I'll go have a look at that reference. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Jun 17, 2008 at 6:58 AM, Gerald Guido [EMAIL PROTECTED] wrote: I don't have an answer but I can point you in a direction of a possible option. Take a look at this: http://photos.guidofamily.org/grid.PNG We need to do some fine grained permissions. Not nearly as fine grained as your require. But I can see adding other edit/permissions options to the drop down for each member according to a resource. Or possibly having group rights (admin, user, editor or what not) and granting an individual certain rights (as defined by a group) to a particular resource. I used coldext to do this btw. http://coldext.riaforge.org/ coldext was pretty easy to pick up. And Justin was nice enough to answer some questions when I needed a hand with it. Let me know if you need any help with this as I have some working code examples. HTH G ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307635 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for advice on permissions
-Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2008 6:52 PM To: CF-Talk Subject: Re: Looking for advice on permissions Thanks for your suggestions Claude. Perhaps i should give you a bit more background to this project. Just to clarify, the scenario is about the opposite to the one you are puzzled by. I see the circumstances where we might want to allow someone to edit content, but for safety's sake not delete it or add new content. For what it's worth we see this all the time. (Some) people can edit content or remove it from view (effectively deleting it), but only a select very few people can actually delete content. This is due, in our case, to SOX laws and accountability: you can't delete any content (EVER!) unless that content has been fully reviewed by legal first. In practice this means that content is essentially never deleted (although we sometimes delete content that never actually made it to the public site for some reason). In case it's not clear this also means that all content management must be source controlled and we must be able to show the content as it appeared publically at any point in its lifetime. The Law... it's a bitch. Also i have a current need at a radio station to allow the sports people to work on the sports part of the site, but not touch the programming pages. We want to let the people working on one radio show to be able to update their page - add, edit and delete content, but only from their page.I dont want to let them accidentally (or deliberately - egos are huge at a radio station!) interfere with any other show's content. Similarly we used to host agency sites for detached brokers. It would be (literally) criminal to allow one broker to edit the content of another's (a competitor's) site. I don't have any real suggestions... just commiserating that these situations do exist. ;^) Jim Davis ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307641 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Looking for advice on permissions
You know, I've been struggling with this too. Not really struggling, as, hell, you can code up something that will work for one set of variables pretty easy, but making a general deal that's flexible and whatnot? Harder. I'm leaning pretty heavy towards AOP and business object level permissions. As in, this person has these rights to these functions. I'm not sure about overhead, and you *really* want the condensed spring format for doing AOP (I can't wait till that's officially in ColdSpring) but it's the finest you can get. I like to get as fine as possible, and then do a bunch of global type deals so you don't always have to drop to that fine level of detail (real PITA with hundreds of objects). The nice thing is that you can get the function map right from the live code, so part of what needs to be documented/stored is coming from the same stuff that needs to use it, which is nice. That single point of reference deal. Of course, now Im wondering if I can do something like Hibernate does for when you change the database model (it'll automatically try to change the database to keep it in sync, if you so choose) when I change functions around and whatnot. The other thing I've done that was easy but not as portable, was to use a framework to access the model, and then do all the authorization on the framework events. With MG this isn't too bad, and you can even crawl through stuff to get the available event names from the code itself. But it breaks down at that fine-grained control level. You end up with multiple events and duplication or complicated inheritance schemes, etc.. I've been diddling with object-based AOP authorization POCs for a while, but I'm not quite there yet. Something's always not quite flexible for case X, or case Y, or the syncing sucks, or some-such. I'll holler if I find that magic bullet. The all in one, nimble fighter, long-range bomber deal. It does happen, every once in a while. -- Jack Burton: Just remember what ol' Jack Burton does when the earth quakes, and the poison arrows fall from the sky, and the pillars of Heaven shake. Yeah, Jack Burton just looks that big ol' storm right square in the eye and he says, Give me your best shot, pal. I can take it. On Tue, Jun 17, 2008 at 4:51 PM, Mike Kear [EMAIL PROTECTED] wrote: Thanks for your suggestions Claude. Perhaps i should give you a bit more background to this project. Just to clarify, the scenario is about the opposite to the one you are puzzled by. I see the circumstances where we might want to allow someone to edit content, but for safety's sake not delete it or add new content. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307648 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Looking for advice on permissions
I have decided that the permission system i use on my CMS is getting too complicated and difficult to administer, and my users are having problems understanding it, so I want to fix it. Can any suggest a good scheme ot use, or point me to some reading to help me figure out what i need to do? The permissions needs to account for the following: user can (or can't ) see a content element (i.e. page or part of a page or image in a gallery) user can (or can't ) Edit a content element user can (or can't ) Add a new content element user can (or can't ) Delete a content element user can (or can't ) See/Add/Edit/Delete a content element belonging to a specific class of elements (e.g. belongs to a user group or something) Hopefully, I'll be able to assign a number or id or something to a content element and that will determine who gets to see it, or have access to it in the CMS. Currently i have a group id (or list of groups) that every user belongs to and an access level they hold defining what they get to do in teh CMS but its too broad-brushstroke. I need to give users the rights to edit and delete in one area, but only read in another for example. Or give someone access to see the whole site, but only edit content in some of the pages. The system i'm using is struggling to cope with all the variations I'm giving it to deal with. Does anyone have a neat and tidy and very flexible permission system i could learn from? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307549 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for advice on permissions
I don't have an answer but I can point you in a direction of a possible option. Take a look at this: http://photos.guidofamily.org/grid.PNG We need to do some fine grained permissions. Not nearly as fine grained as your require. But I can see adding other edit/permissions options to the drop down for each member according to a resource. Or possibly having group rights (admin, user, editor or what not) and granting an individual certain rights (as defined by a group) to a particular resource. I used coldext to do this btw. http://coldext.riaforge.org/ coldext was pretty easy to pick up. And Justin was nice enough to answer some questions when I needed a hand with it. Let me know if you need any help with this as I have some working code examples. HTH G On Mon, Jun 16, 2008 at 4:33 AM, Mike Kear [EMAIL PROTECTED] wrote: I have decided that the permission system i use on my CMS is getting too complicated and difficult to administer, and my users are having problems understanding it, so I want to fix it. Can any suggest a good scheme ot use, or point me to some reading to help me figure out what i need to do? The permissions needs to account for the following: user can (or can't ) see a content element (i.e. page or part of a page or image in a gallery) user can (or can't ) Edit a content element user can (or can't ) Add a new content element user can (or can't ) Delete a content element user can (or can't ) See/Add/Edit/Delete a content element belonging to a specific class of elements (e.g. belongs to a user group or something) Hopefully, I'll be able to assign a number or id or something to a content element and that will determine who gets to see it, or have access to it in the CMS. Currently i have a group id (or list of groups) that every user belongs to and an access level they hold defining what they get to do in teh CMS but its too broad-brushstroke. I need to give users the rights to edit and delete in one area, but only read in another for example. Or give someone access to see the whole site, but only edit content in some of the pages. The system i'm using is struggling to cope with all the variations I'm giving it to deal with. Does anyone have a neat and tidy and very flexible permission system i could learn from? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307567 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Advice and direction, please.
Hi All, I need a little help and direction with a project. Iâve got 50+ .pdf âjournals.â Each journal has 3 to 5 articles in it. We want to make the journalâs text searchable, and to be able to send (download) just the related article(s) instead of the whole journal. Weâre running CF8 and MySql on windows and we own the journals, so there arenât any copyright issues. Question 1 â Which search engine â Verity or Google? We already use Verity on our site, but Google is pretty cool and powerful. Question 2 â Where to store the pdfâs â in a directory or in MySql? Iâve gathered from other peopleâs posts that there are issues with MySqlâs BLOB data type. I donât know exactly what those issues are - would I run into them storing pdfâs in MySql? Question 3 â pdf files â Should I save each article as a separate file (or record) or should I leave the articles in the journal and let CFPDF pull the particular article out? If youâve had a similar project, what did you do and why? Thanks!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307420 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Advice and direction, please.
Google can index PDF files can't it? Why not install a Google search on your site and let it go to town on your directory structure? -Original Message- From: Ry Mittlestadt [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2008 11:18 AM To: CF-Talk Subject: Advice and direction, please. Hi All, I need a little help and direction with a project. Iââ¬â¢ve got 50+ .pdf ââ¬Ëjournals.ââ¬â¢ Each journal has 3 to 5 articles in it. We want to make the journalââ¬â¢s text searchable, and to be able to send (download) just the related article(s) instead of the whole journal. Weââ¬â¢re running CF8 and MySql on windows and we own the journals, so there arenââ¬â¢t any copyright issues. Question 1 ââ¬â Which search engine ââ¬â Verity or Google? We already use Verity on our site, but Google is pretty cool and powerful. Question 2 ââ¬â Where to store the pdfââ¬â¢s ââ¬â in a directory or in MySql? Iââ¬â¢ve gathered from other peopleââ¬â¢s posts that there are issues with MySqlââ¬â¢s BLOB data type. I donââ¬â¢t know exactly what those issues are - would I run into them storing pdfââ¬â¢s in MySql? Question 3 ââ¬â pdf files ââ¬â Should I save each article as a separate file (or record) or should I leave the articles in the journal and let CFPDF pull the particular article out? If youââ¬â¢ve had a similar project, what did you do and why? Thanks!! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307422 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need some advice on approach...
Thanks for the wildcard idea, Isaac... that definitely sounds better! Welcome. :) -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 617.365.5732 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307213 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need some advice on approach...
Thanks for the feedback, Isaac... Welcome. Actually come to think of it, you can specify an arecord for *.domain.com as a wild-card for any values that aren't otherwise set for that domain. So you should be able to make it automatically throw people into the agents directory with just the one a-record and save yourself some hassle. :) It occurred to me when I started reading this that I was rushing when I thought through the mod_rewrite thing -- because mod_rewrite (or in your case isapi_rewrite) only goes to work after the a-record identification has already been done, so rewrite won't help you there. That's actually what I was thinking is that it could save you from having to create and manage all those a-records, but I think really just using the *.c21ar.com as a catch-all a-record should have the effect you want. I had one of those wildcards on my turnkey.to domain a while back, although I haven't done anything other than receive email with that domain name in several years. Anyway, your logic looks fine. I would definitely wrap a couple of cfqueryparams around those values in your query and probably create an agent.cfc to store in the session instead of putting individual values there. Even if all the CFC does is contain this.first_name = blah, etc. it'll be a step in the direction of encapsulating. hth -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 617.365.5732 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307134 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need some advice on approach...
Thanks for the wildcard idea, Isaac... that definitely sounds better! Rick -Original Message- From: s. isaac dealey [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2008 8:49 PM To: CF-Talk Subject: Re: Need some advice on approach... Thanks for the feedback, Isaac... Welcome. Actually come to think of it, you can specify an arecord for *.domain.com as a wild-card for any values that aren't otherwise set for that domain. So you should be able to make it automatically throw people into the agents directory with just the one a-record and save yourself some hassle. :) It occurred to me when I started reading this that I was rushing when I thought through the mod_rewrite thing -- because mod_rewrite (or in your case isapi_rewrite) only goes to work after the a-record identification has already been done, so rewrite won't help you there. That's actually what I was thinking is that it could save you from having to create and manage all those a-records, but I think really just using the *.c21ar.com as a catch-all a-record should have the effect you want. I had one of those wildcards on my turnkey.to domain a while back, although I haven't done anything other than receive email with that domain name in several years. Anyway, your logic looks fine. I would definitely wrap a couple of cfqueryparams around those values in your query and probably create an agent.cfc to store in the session instead of putting individual values there. Even if all the CFC does is contain this.first_name = blah, etc. it'll be a step in the direction of encapsulating. hth ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Need some advice on approach...
Hi, all... I'm working on a real estate website and for the first time, I'm setting up agents' sites using subdomains. I have some ideas on how to approach this, but I thought I'd ask about those of you with experience doing this kind of thing to offer advice. First, on the folder structure. I've set up an agents folder under the root of the main broker site and setting up my standard subfolders, cfm, images, includes, etc. Is there a far better way to set up the structure? Or would I be better off to set up an independent agents site with the agents folder (or whatever it would be called) as the root folder? Does it matter? Secondly, will the folder structure I've started setting up (agents structure under the current main site webroot) allow me to create subdomains for each agents without problem? john.c21ar.com? I can use cfif's in the application.cfm (yes, still using application.cfm... I'll work on application.cfc on the next project. This is already way behind schedule to change now) to determine the agent by url variable (if they're coming to the site internally, and cgi.server_name if they're coming to the subdomain directly from outside the main site, via the subdomain name, john.c21ar.com. cfif (isdefined('url.subdomain') and url.subdomain is 'john.c21ar.com') or cgi.server_name contains 'john.c21ar.com' (Variables setup for particular agent etc, etc.) /cfif What's a better approach to using subdomains? Thanks for any advice. Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307046 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need some advice on approach...
Hey Rick. Brief recommendation. You mentioned you're using Application.cfm still - what you might want to do is add an Application.cfm in your /agents subdirectory to modify whatever the original Application.cfm did to set up the page... /root/Application.cfm original code ... /root/agents/Application.cfm cfinclude template=../Application.cfm change paths if necessary, etc ... That way you don't need to check for the subdomain to see if they're coming to one... you know, 'cause they're in that directory... however fitting them into that directory is another story. You can of course set up an a-record(?) for each agent that points to their directory, but that's a lot of configuration (or I would expect it to be) - my bet would be to use either mod_rewrite on Apache or isapi_rewrite on IIS to change the URL based on a rule, so that as far as the server is concerned any request to [not www].c21ar.com is actually to www.c21ar.com/agents/?subdomain=[not www] or to www.c21ar.com/agents/[not www]/ depending on how you structured it -- I was a little fuzzy on the details. :) hth -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 617.365.5732 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need some advice on approach...
Hi, Isaac... At this point, I was think that identifying the agent involved via the referring url or internally via a url variable would allow me to query a db for all needed variables, turn those variables into session variables, and then setup the agent pages via the session variables. I don't know much anything much about isapi_rewrite (did find that ionic has a free version, but it's functionality with II6 is a bit sketchy...), however, that approach, using folders for each agent requires duplicate code and I was thinking that it would be more efficient to use the same code with different variables. However, that may not be true and the only thing being saved by taking the code-reuse route would be server space. To clarify your statement about application.cfm... Are you suggesting putting an application.cfm in the main agents folder, and then having an application.cfm in *each* of the specific agents' folders and simply have that included application.cfm contain the specific variables needed an agent? So, that's preferable to just using one application.cfm in the main agents folder and determining the agent to use via cgi.server_name or url variables and a series cfif's and queries? Rick -Original Message- From: s. isaac dealey [mailto:[EMAIL PROTECTED] Sent: Sunday, June 08, 2008 11:29 AM To: CF-Talk Subject: Re: Need some advice on approach... Hey Rick. Brief recommendation. You mentioned you're using Application.cfm still - what you might want to do is add an Application.cfm in your /agents subdirectory to modify whatever the original Application.cfm did to set up the page... /root/Application.cfm original code ... /root/agents/Application.cfm cfinclude template=../Application.cfm change paths if necessary, etc ... That way you don't need to check for the subdomain to see if they're coming to one... you know, 'cause they're in that directory... however fitting them into that directory is another story. You can of course set up an a-record(?) for each agent that points to their directory, but that's a lot of configuration (or I would expect it to be) - my bet would be to use either mod_rewrite on Apache or isapi_rewrite on IIS to change the URL based on a rule, so that as far as the server is concerned any request to [not www].c21ar.com is actually to www.c21ar.com/agents/?subdomain=[not www] or to www.c21ar.com/agents/[not www]/ depending on how you structured it -- I was a little fuzzy on the details. :) hth -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 617.365.5732 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307055 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need some advice on approach...
To clarify your statement about application.cfm... Are you suggesting putting an application.cfm in the main agents folder, and then having an application.cfm in *each* of the specific agents' folders and simply have that included application.cfm contain the specific variables needed an agent? So, that's preferable to just using one application.cfm in the main agents folder and determining the agent to use via cgi.server_name or url variables and a series cfif's and queries? Umm... no my original thinking was just to have the one Application.cfm in the root /agents/ folder to include the root app.cfm from the parent app, so that one app.cfm in agents would run all the agents... however... if you're planning to give them urls like /c21ar.com/agents/[agent]/ then it's conceivable you could use an application.cfm in each directory to identify the agent and set up the environment for their page. I wouldn't put all the code in their individual application.cfm however if you're going to do that, I would create a function (or maybe even a CFC :) in the parent application.cfm and then in the app.cfm for the individual agent, you can just call that function to set up the environment like /agents/Application.cfm cfinclude template=../Application.cfm cfset agentEnv = CreateObject(component,agentEnv).init() / /agents/[agent]/Application.cfm cfinclude template=../Application.cfm cfset agentEnv.setup([agent]) / if that makes sense. ;) but no originally I was just thinking you would have just the /agents/Application.cfm and it would perform whatever variable testing it needed to perform to identify the agent. I suppose actually rather than another Appication.cfm in each directory you could just have an /index.cfm that includes ../index.cfm or the like - that way you've still got just the one application.cfm and really just the one page template too... unless you wanted to cache some custom layout for them in their index template. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 617.365.5732 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307062 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need some advice on approach...
Thanks for the feedback, Isaac... I was actually planning to use url's like agent.c21ar.com and create subdomains (A records in the DNS manager) and then point those subdomains to the main agents' folder and use cfif statements to setup the variables for a particular agent's version of the site. If a visitor is coming to an agent's site from a page on the main website, then I can pick up a url variable to id the agent. If a visitor is coming to an agent's site from their domain, I can use the cgi.server_name variable to id the domain and get the agent info that way. Then I can convert the data into session variables that will be changed only if the cgi.server_name is not the same as the session.subdomain or if a url.agent_id variable is present... (I don't know if this approach is without problems or not... I guess I need to go ahead and do some testing to see if it breaks down in practice.) Do you see any problems with this approach? cfif (isdefined('session.subdomain') and session.subdomain is not '#cgi.server_name#') or isdefined('url.agent_id') cfquery name='get_agent_info' datasource='#dsn#' select * from hmls_agents cfif isdefined('url.agent_id') where hmls_agent_id = '#url.agent_id#' cfelse where domain_name = '#cgi.server_name#' /cfif /cfquery cfoutput query='get_agent_info' cfset session.agent_first_name = '#first_name#' cfset session.agent_last_name = '#last_name#' cfset session.agent_phone = '#phone#' etc... /cfoutput /cfif Umm... no my original thinking was just to have the one Application.cfm in the root /agents/ folder to include the root app.cfm from the parent app, so that one app.cfm in agents would run all the agents... however... if you're planning to give them urls like /c21ar.com/agents/[agent]/ then it's conceivable you could use an application.cfm in each directory to identify the agent and set up the environment for their page. I wouldn't put all the code in their individual application.cfm however if you're going to do that, I would create a function (or maybe even a CFC :) in the parent application.cfm and then in the app.cfm for the individual agent, you can just call that function to set up the environment like /agents/Application.cfm cfinclude template=../Application.cfm cfset agentEnv = CreateObject(component,agentEnv).init() / /agents/[agent]/Application.cfm cfinclude template=../Application.cfm cfset agentEnv.setup([agent]) / if that makes sense. ;) but no originally I was just thinking you would have just the /agents/Application.cfm and it would perform whatever variable testing it needed to perform to identify the agent. I suppose actually rather than another Appication.cfm in each directory you could just have an /index.cfm that includes ../index.cfm or the like - that way you've still got just the one application.cfm and really just the one page template too... unless you wanted to cache some custom layout for them in their index template. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 617.365.5732 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need advice - googlebot is creating errors.
It looks like the characters were escaped, you need to escape the first ampersand when posting it amp;amp;amp; = amp;amp; The only thing that comes to mind, unless Google is broke, is that you may have a page where you are escaping a URL twice. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query on query advice
Hi bobby, this would be fantastic but it only allows you to pass in one column to merge them together. however i need them to merge together based on 2 primary key columns thanks richard I, and another guy, used this years ago to do just that. http://cflib.org/udf.cfm?ID=1021 .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com hi, i have 2 coldfusion queries and need to combine them together on their primary keys the problem is, is that i don't know what the column names will be, i only know what the primary keys will be. therefore i have no idea how to join them together based on this. i usually join queries together using: select s.subject id, t.testid from subjects s, tests t etc... i also know that query on query in coldfusion is very limited. so i would like some advice on the best possible way to do this please Note: i Have looked on cflib and seen a query merge function but it only allows me to pass in 1 column name as a primary key whereas my queries have more than 1 primary key (1 query has subjectid, testoccasionid - and another query has subjectid, testoccasionid, and tesid - so i need to join them up based on the subjectid, and testoccasinid) for example, i have 2 queries: query1 = subjectID(PK), testOccasionID(PK), x amount of additional columns query2 = subjectID(PK), testOccasionID(PK), testID(PK) x amount of additional columns they are both queries in coldfusion so i may be wrong but i am thinking that i can only use query on query to join them but i am not sure how thanks for your help richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304863 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query on query advice
Doesn't a left outer join do the job? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query on query advice
Hi Gerald, yeah that seems the best way to go about it thanks gerald richard you can use ColumnList to tease out the column names and use them to dynamicly created the query. cfquery name=getProj datasource=#application.DSN# SELECT * FROM tblProj /cfquery cfset mystring = getProj.ColumnList And do a replace to tack on the table name to the vars so the read something tblProj.id, tblProj.name, etc. cfquery name=getEmp datasource=#application.DSN# SELECT * FROM tblEmp /cfquery cfset mystring2 = getEmp.ColumnList And do a replace to tack on the second table name to the vars and then going the two lists like so: ListAppend(mystring ,mystring2 ) Then if you know the tables and the ID's you can build the query from the above. hth G On Tue, May 6, 2008 at 1:22 PM, Richard White [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query on query advice
hi axel, i have tried this but query of query in coldfusion doesnt seem to accept left outer join. i get an error saying '...syntax error near left...' is the left outer join meant to work in query of query in coldfusion thanks richard Doesn't a left outer join do the job? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304909 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: query on query advice
No-can-do compadre. There are some funky workarounds (http://instantbadger.blogspot.com/2006/07/faking-left-outer-join-in-que ry-of.html) but query of query's do not natively support that syntax. Very sad indeed ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Thursday, May 08, 2008 11:39 AM To: CF-Talk Subject: Re: query on query advice hi axel, i have tried this but query of query in coldfusion doesnt seem to accept left outer join. i get an error saying '...syntax error near left...' is the left outer join meant to work in query of query in coldfusion ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query on query advice
thank brad your right it is a shame, i hope that adobe will be enhancing the query of query to support any sql as this will make all our jobs easier :) thanks No-can-do compadre. There are some funky workarounds (http://instantbadger.blogspot.com/2006/07/faking-left-outer-join-in-que ry-of.html) but query of query's do not natively support that syntax. Very sad indeed ~Brad hi axel, i have tried this but query of query in coldfusion doesnt seem to accept left outer join. i get an error saying '...syntax error near left...' is the left outer join meant to work in query of query in coldfusion ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304923 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query on query advice
Go forth unto all the nations and make your voice heard. Or at least go forth unto Adobe... http://www.adobe.com/go/wish ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Thursday, May 08, 2008 12:07 PM To: CF-Talk Subject: Re: query on query advice thank brad your right it is a shame, i hope that adobe will be enhancing the query of query to support any sql as this will make all our jobs easier :) thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304924 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query on query advice
thanks for the link i just submitted the request :) Go forth unto all the nations and make your voice heard. Or at least go forth unto Adobe... http://www.adobe.com/go/wish ~Brad thank brad your right it is a shame, i hope that adobe will be enhancing the query of query to support any sql as this will make all our jobs easier :) thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query on query advice
Me too :) I also threw the fact that there are no string manipulation functions in QofQ like substring or mid. ~Brad -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Thursday, May 08, 2008 12:19 PM To: CF-Talk Subject: Re: query on query advice thanks for the link i just submitted the request :) Go forth unto all the nations and make your voice heard. Or at least go forth unto Adobe... http://www.adobe.com/go/wish ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304929 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
query on query advice
hi, i have 2 coldfusion queries and need to combine them together on their primary keys the problem is, is that i don't know what the column names will be, i only know what the primary keys will be. therefore i have no idea how to join them together based on this. i usually join queries together using: select s.subject id, t.testid from subjects s, tests t etc... i also know that query on query in coldfusion is very limited. so i would like some advice on the best possible way to do this please Note: i Have looked on cflib and seen a query merge function but it only allows me to pass in 1 column name as a primary key whereas my queries have more than 1 primary key (1 query has subjectid, testoccasionid - and another query has subjectid, testoccasionid, and tesid - so i need to join them up based on the subjectid, and testoccasinid) for example, i have 2 queries: query1 = subjectID(PK), testOccasionID(PK), x amount of additional columns query2 = subjectID(PK), testOccasionID(PK), testID(PK) x amount of additional columns they are both queries in coldfusion so i may be wrong but i am thinking that i can only use query on query to join them but i am not sure how thanks for your help richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304802 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query on query advice
you can use ColumnList to tease out the column names and use them to dynamicly created the query. cfquery name=getProj datasource=#application.DSN# SELECT * FROM tblProj /cfquery cfset mystring = getProj.ColumnList And do a replace to tack on the table name to the vars so the read something tblProj.id, tblProj.name, etc. cfquery name=getEmp datasource=#application.DSN# SELECT * FROM tblEmp /cfquery cfset mystring2 = getEmp.ColumnList And do a replace to tack on the second table name to the vars and then going the two lists like so: ListAppend(mystring ,mystring2 ) Then if you know the tables and the ID's you can build the query from the above. hth G On Tue, May 6, 2008 at 1:22 PM, Richard White [EMAIL PROTECTED] wrote: hi, i have 2 coldfusion queries and need to combine them together on their primary keys the problem is, is that i don't know what the column names will be, i only know what the primary keys will be. therefore i have no idea how to join them together based on this. i usually join queries together using: select s.subject id, t.testid from subjects s, tests t etc... i also know that query on query in coldfusion is very limited. so i would like some advice on the best possible way to do this please Note: i Have looked on cflib and seen a query merge function but it only allows me to pass in 1 column name as a primary key whereas my queries have more than 1 primary key (1 query has subjectid, testoccasionid - and another query has subjectid, testoccasionid, and tesid - so i need to join them up based on the subjectid, and testoccasinid) for example, i have 2 queries: query1 = subjectID(PK), testOccasionID(PK), x amount of additional columns query2 = subjectID(PK), testOccasionID(PK), testID(PK) x amount of additional columns they are both queries in coldfusion so i may be wrong but i am thinking that i can only use query on query to join them but i am not sure how thanks for your help richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304803 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: query on query advice
I, and another guy, used this years ago to do just that. http://cflib.org/udf.cfm?ID=1021 ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 06, 2008 1:22 PM To: CF-Talk Subject: query on query advice hi, i have 2 coldfusion queries and need to combine them together on their primary keys the problem is, is that i don't know what the column names will be, i only know what the primary keys will be. therefore i have no idea how to join them together based on this. i usually join queries together using: select s.subject id, t.testid from subjects s, tests t etc... i also know that query on query in coldfusion is very limited. so i would like some advice on the best possible way to do this please Note: i Have looked on cflib and seen a query merge function but it only allows me to pass in 1 column name as a primary key whereas my queries have more than 1 primary key (1 query has subjectid, testoccasionid - and another query has subjectid, testoccasionid, and tesid - so i need to join them up based on the subjectid, and testoccasinid) for example, i have 2 queries: query1 = subjectID(PK), testOccasionID(PK), x amount of additional columns query2 = subjectID(PK), testOccasionID(PK), testID(PK) x amount of additional columns they are both queries in coldfusion so i may be wrong but i am thinking that i can only use query on query to join them but i am not sure how thanks for your help richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304804 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Need advice - googlebot is creating errors.
Lately when crawling my site, googlebot has been throwing errors. Instead of the url parameters being seperated by an , when I get an error, the cgi.query_string value has an amp; as a seperator instead. (see below.) Has anyone come across this before? Any ideas on how to stop it from happening again? http://www.domain.com/index.cfm?type=selectModelamp;makeid=100 should be http://www.domain.com/index.cfm?type=selectModelmakeid=100 Thanks, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304759 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need some advice on speeding up query...
Where would I find info on how to use a thread like that? I don't have a clue... the cf docs? Know of a blog about it? The cfdocs should pretty much cover it, you're just throwing a cfthread tag with action=run around the code that does the re-cache. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_t_04.html --- Mary Jo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304233 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need some advice on speeding up query...
So, would this be accurate? cfthread action=run name=update_query cfquery... My huge union all query... /cfquery /cfthread Is that all there is to it? And this creates a running of the query which doesn't involve the browser? Is that what this means (from the cfdocs): run: Creates a thread and starts it processing. Code in the cfthread tag body runs simultaneously and independently of page-level code and code in other cfthread tags. Rick -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 10:32 AM To: CF-Talk Subject: Re: Need some advice on speeding up query... Where would I find info on how to use a thread like that? I don't have a clue... the cf docs? Know of a blog about it? The cfdocs should pretty much cover it, you're just throwing a cfthread tag with action=run around the code that does the re-cache. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_t_04.html --- Mary Jo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304234 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need some advice on speeding up query...
Is that all there is to it? And this creates a running of the query which doesn't involve the browser? Is that what this means (from the cfdocs): Basically, yes, although I wouldn't really think of it in terms of whether or not the browser is involved, it's more to do with the current running thread on the server that is processing the page...it starts a new thread that will call the query which will run independent of the rest of your code and will not have to wait for it to complete before passing the results back to the browser, it sort of just skips over that and keeps running while the new thread is off running at the same time in parallel. The end result being that the page will not take any longer to run as far as the user is concerned than a typical update would. It's something you want to be judicious about using, as you don't want to overtax a server by constantly creating new threads...but it's a nice solution for a situation like this where you have a small number of users that will be only be updating the tables once in awhile. --- Mary Jo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need some advice on speeding up query...
And to reiterate, don't stick the entire query in there, it should be out in a CFC, or at the very least, in a separate template so if you make any changes, you aren't updating it in multiple files. You would just use a variable for the cachedwithin time sort of like this: cfparam name=Request.CacheTime default=#CreateTimeSpan(0, 1, 0, 0)# cfquery name=ReallyBigQuery datasource=MyDS cachedwithin=#Request.CacheTime# /cfquery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304247 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need some advice on speeding up query...
Oops, sorry about that partial post To reiterate, don't stick the entire query in there, it should be out in a CFC, or at the very least, in a separate template so if you make any changes, you aren't updating it in multiple files. You would just use a variable for the cachedwithin time sort of like this: cfparam name=Request.CacheTime default=#CreateTimeSpan(0, 1, 0, 0)# cfquery name=ReallyBigQuery datasource=MyDS cachedwithin=#Request.CacheTime# SQL Here /cfquery And then in your cfthread you would just have something like this, which calls the above code (you wouldn't necessarily need a request variable, depending on your application): cfthread action=run name=refresh_cached_query cfset Request.CacheTime = 0 cfinclude template = path_to_query_page.cfm /cfthread ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need some advice on speeding up query...
Thanks for all the info, Mary Jo! It's been ( and will be ) a big help! Rick -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2008 2:24 PM To: CF-Talk Subject: Re: Need some advice on speeding up query... Oops, sorry about that partial post To reiterate, don't stick the entire query in there, it should be out in a CFC, or at the very least, in a separate template so if you make any changes, you aren't updating it in multiple files. You would just use a variable for the cachedwithin time sort of like this: cfparam name=Request.CacheTime default=#CreateTimeSpan(0, 1, 0, 0)# cfquery name=ReallyBigQuery datasource=MyDS cachedwithin=#Request.CacheTime# SQL Here /cfquery And then in your cfthread you would just have something like this, which calls the above code (you wouldn't necessarily need a request variable, depending on your application): cfthread action=run name=refresh_cached_query cfset Request.CacheTime = 0 cfinclude template = path_to_query_page.cfm /cfthread ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need some advice on speeding up query...
how and where is that url/link generated? can you also pass the property type in the url? that can tell you which table to query... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Rick Faircloth wrote: Now's here's a new problem I haven't encountered. How do I use a url variable to link to a property details page when the properties are in 8 different tables? The issue really isn't the variable, since I can use the aliased variable property_id (once I add it to the query). I know I could use property_details.cfm?property_id=cfoutput#get_properties.property_id#/cfoutput, however, on the details page, I would need to search all eight property tables for the correct property id. Is this the method I'm stuck with because all the properties aren't in a single table? Pass the aliased variable property_id and search all 8 tables for it? Perhaps I should just put them all into one big property table instead of keeping them separate as the data vender has them... Thoughts? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304133 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4