Re: Query/Report Builder
We have both Crystal Reports and SQL Server 2008 Reporting Services at work. While they are not super customized, they do serve the purpose of allowing users to run some rudimentary reports. However, neither is ColdFusion-based, and it sounds like that is what you are looking for. On Sun, Jan 3, 2010 at 7:51 PM, b...@bradwood.com wrote: I'm not totally sure what you are after-- I Googled Quick Query and all I could find was a MS Access plug-in. As for allowing your users to write their own queries, I really can't imagine doing this without an interface that enforced your specific business rules and limited them from running something really stupid. This is probably why the query builders I have seen before were specific to an application and its entities/relationships. There may or may not be something built in CF out there, but if you really trust your users to run anything they want on the DB, then install Query Analyzer and give them a log in with only select permissions (The thought of that kind of scares me...), or try to define a handful of reports that funnel them in a specific direction where you can control the SQL statement, but they can filter, group, and sort by themselves. ~Brad Original Message Subject: Query/Report Builder From: Tom Jones tjo...@acworld.com Date: Sun, January 03, 2010 5:12 pm To: cf-talk cf-talk@houseoffusion.com Hello, I have been looking through the archives but really did not find much on this. I'm looking for a web based query builder. I want to let my users create their own queries. It must have been done before, so I really dont want to re-invent the wheel. I came across something called Quick Query but it's a ASP.Net thing and I'm not running on Windows nor do I really want to use ASP. :-) Are there any projects or something that will give me a head start or do I need to write it from scratch? Thanks, tom ~| 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:329394 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfcontent with excel 2007
I have not tried this, but what if you change the cfcontent type to unknown? Like so: cfcontent type=unknown cfheader name=Content-Disposition value=filename=report.xlsx On Thu, Dec 31, 2009 at 2:37 AM, Christophe Maso zum...@hotmail.com wrote: Have seen a few posts around the web with this problem, but no evident solution. I have a cfm page that I want to make exportable to excel 2007 (.xlsx file). From what I've seen here: http://blogs.msdn.com/vsofficedeveloper/pages/Office-2007-Open-XML-MIME-Types.aspx it looks like the correct MIME type for Excel 2007 (.xlsx) files is NOT vnd.ms-excel, but rather application/vnd.openxmlformats-officedocument.spreadsheetml.sheet . So, when the proper url var is passed to the page, I include these lines of code: cfcontent type=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet cfheader name=Content-Type value=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet cfheader name=Content-Disposition value=filename=report.xlsx And in that case the user is prompted to open or save the .xlsx file. However, Excel 2007 can't open the file; it gives an error message saying that the file format is not valid. No problem if I export it all using vnd.ms-excel as the MIME-type instead, but then it saves as an .xls file, not an .xlsx file. Any help on how I can get it to save as an .xlsx file? (Using CF8). Thanks, CM ~| 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:329395 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/Report Builder
So, I kind of found something that I'm looking for at http://plugins.jquery.com/project/SQL_QUERY_BUILDER;. The Tables and Columns are static but I'm looking in to changing that so it's a little bit more real time. Tom I'm not totally sure what you are after-- I Googled Quick Query and all I could find was a MS Access plug-in. As for allowing your users to write their own queries, I really can't imagine doing this without an interface that enforced your specific business rules and limited them from running something really stupid. This is probably why the query builders I have seen before were specific to an application and its entities/relationships. There may or may not be something built in CF out there, but if you really trust your users to run anything they want on the DB, then install Query Analyzer and give them a log in with only select permissions (The thought of that kind of scares me...), or try to define a handful of reports that funnel them in a specific direction where you can control the SQL statement, but they can filter, group, and sort by themselves. ~Brad Hello, I have been looking through the archives but really did not find much on this. I'm looking for a web based query builder. I want to let my users create their own queries. It must have been done before, so I really dont want to re-invent the wheel. I came across something called Quick Query but it's a ASP.Net thing and I'm not running on Windows nor do I really want to use ASP. :-) Are there any projects or something that will give me a head start or do I need to write it from scratch? Thanks, tom ~| 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:329396 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
line-through in select tag
Anyone know of a way to get a CSS line-through in an HTML select tag? I tried this but it does not work. select optionspan style=text-decoration:line-through;#dollarFormat(productData.Price)#/span/option /select ~| 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:329397 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
question about javascript
I do not know where else to ask this so I am asking here... can javascript manipulate png files like action script can? ie - adding glows, change the color? -- When you choose hope, anything is possible. -Christopher Reeve ~| 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:329398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: question about javascript
Javascript cannot change the file itself, but it can apply filters client-side to an image using CSS. andy -Original Message- From: Clint Tredway [mailto:grum...@gmail.com] Sent: Monday, January 04, 2010 2:43 PM To: cf-talk Subject: question about javascript I do not know where else to ask this so I am asking here... can javascript manipulate png files like action script can? ie - adding glows, change the color? -- When you choose hope, anything is possible. -Christopher Reeve ~| 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:329399 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: question about javascript
cool, that may work. actionscript doesn't change the file when changing the color, just applies a transform which happens to be color. I am thinking of converting this http://www.fastlane-grpahix.com/designerinto a javascript app instead of Flex. On Mon, Jan 4, 2010 at 2:46 PM, Andy Matthews li...@commadelimited.comwrote: Javascript cannot change the file itself, but it can apply filters client-side to an image using CSS. andy -Original Message- From: Clint Tredway [mailto:grum...@gmail.com] Sent: Monday, January 04, 2010 2:43 PM To: cf-talk Subject: question about javascript I do not know where else to ask this so I am asking here... can javascript manipulate png files like action script can? ie - adding glows, change the color? -- When you choose hope, anything is possible. -Christopher Reeve ~| 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:329400 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: line-through in select tag
This worked on FF but not IE 7 (got figure). select option style=text-decoration:line-through;span style=text-decoration:line-through;#dollarFormat(productData.Price)#/span/option /select On Mon, Jan 4, 2010 at 3:18 PM, Chad Gray cg...@careyweb.com wrote: Anyone know of a way to get a CSS line-through in an HTML select tag? I tried this but it does not work. select optionspan style=text-decoration:line-through;#dollarFormat(productData.Price)#/span/option /select ~| 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:329401 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: line-through in select tag
In this page ' http://htmlhelp.com/reference/css/text/text-decoration.html', this code is used: span style=text-decoration: line-throughline-through/span I am able to view the desired effect using IE8 and FF 3.5.6 I cannot test this on IE7 and earlier at the moment, however. William -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Monday, January 04, 2010 2:47 PM To: cf-talk Subject: Re: line-through in select tag This worked on FF but not IE 7 (got figure). select option style=text-decoration:line-through;span style=text-decoration:line-through;#dollarFormat(productData.Price)#/spa n/option /select On Mon, Jan 4, 2010 at 3:18 PM, Chad Gray cg...@careyweb.com wrote: Anyone know of a way to get a CSS line-through in an HTML select tag? I tried this but it does not work. select optionspan style=text-decoration:line-through;#dollarFormat(productData.Price)#/spa n/option /select ~| 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:329402 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQLServer Express and SQLServer - totally compatible?
I'm building a second machine which will run CF on it, and will need to manipulate my SQLServer2005 databases on a network server. I'm going to be connecting this machine to these databases on an external drive as though they're local, because i'm going to be swapping back and forth between these machines regularly. I dont want to keep attaching and detatching lots of databases - i'd rather just connect the external database to this machine and then boot it up. So if i have SQLServer2005 (the full version) driving the databases when I'm working at one location, and SQLServer2005 Express driving the databases when I'm working at my other location, will that cause problems in the databases? Are the two versions fully compatible at least as far as database file structure etc is concerned? I should also add that I'm only going to be using the Express on a dev machine - not connected to the internet, and there wont be multiple users. And i hardly ever use the advanced features of the database for these little applications - things like syndication and triggers etc - i prefer to have ColdFusion take care of all those kinds of jobs. So for the most part, the databases are simple data storage mechanisms, with all the processing of data being done in ColdFusion. Can anyone see a problem if i do this?I'm not sure the machine I'm building justifies the cost of buying a licence for SQLServer2005 the full version. -- 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:329403 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQLServer Express and SQLServer - totally compatible?
Leaving aside the advisability of doing this :) I have detached and reattached SQL 05 express DBs to prod servers and vice versa - and I will give you a qualified Yes that what you want to do will work. Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Monday, January 04, 2010 8:05 PM To: cf-talk Subject: SQLServer Express and SQLServer - totally compatible? I'm building a second machine which will run CF on it, and will need to manipulate my SQLServer2005 databases on a network server. I'm going to be connecting this machine to these databases on an external drive as though they're local, because i'm going to be swapping back and forth between these machines regularly. I dont want to keep attaching and detatching lots of databases - i'd rather just connect the external database to this machine and then boot it up. So if i have SQLServer2005 (the full version) driving the databases when I'm working at one location, and SQLServer2005 Express driving the databases when I'm working at my other location, will that cause problems in the databases? Are the two versions fully compatible at least as far as database file structure etc is concerned? I should also add that I'm only going to be using the Express on a dev machine - not connected to the internet, and there wont be multiple users. And i hardly ever use the advanced features of the database for these little applications - things like syndication and triggers etc - i prefer to have ColdFusion take care of all those kinds of jobs. So for the most part, the databases are simple data storage mechanisms, with all the processing of data being done in ColdFusion. Can anyone see a problem if i do this?I'm not sure the machine I'm building justifies the cost of buying a licence for SQLServer2005 the full version. -- 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:329404 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQLServer Express and SQLServer - totally compatible?
I'm building a second machine which will run CF on it, and will need to manipulate my SQLServer2005 databases on a network server. I'm going to be connecting this machine to these databases on an external drive as though they're local, because i'm going to be swapping back and forth between these machines regularly. I dont want to keep attaching and detatching lots of databases - i'd rather just connect the external database to this machine and then boot it up. Honestly, I don't know if SQL Server will let you do this. I suspect it might not, as Windows can detect removable drives. So if i have SQLServer2005 (the full version) driving the databases when I'm working at one location, and SQLServer2005 Express driving the databases when I'm working at my other location, will that cause problems in the databases? Are the two versions fully compatible at least as far as database file structure etc is concerned? Yes, you can use database files created by one with the other, although there may be some limitations if you use certain features in SQL Server 2005 when you create the database files (such as the ability to create databases larger than 4GB - that's not supported by Express). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more inform ~| 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:329405 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQLServer Express and SQLServer - totally compatible?
Just a thought: if you're carting an external disk back and forth, why not put a VM with SQL Express and your databases on that disk? Personally I run a little VM farm with SQL and CF all off the one eSATA disk. All is kosher as far as SQL is concerned, and if you need to get data onto another server you've still got linked servers and/or SSRS, or even just a file copy of the results of your processing. BTW, I would not be at all suprised if SQL had some kind of fit when your database files arrive back from wherever with a big hole in their LSN's. It's precisely for this reason that detaching/reattaching is necessary. Jaime On Tue, Jan 5, 2010 at 12:05 PM, Mike Kear afpwebwo...@gmail.com wrote: I'm building a second machine which will run CF on it, and will need to manipulate my SQLServer2005 databases on a network server. I'm going to be connecting this machine to these databases on an external drive as though they're local, because i'm going to be swapping back and forth between these machines regularly. I dont want to keep attaching and detatching lots of databases - i'd rather just connect the external database to this machine and then boot it up. So if i have SQLServer2005 (the full version) driving the databases when I'm working at one location, and SQLServer2005 Express driving the databases when I'm working at my other location, will that cause problems in the databases? Are the two versions fully compatible at least as far as database file structure etc is concerned? I should also add that I'm only going to be using the Express on a dev machine - not connected to the internet, and there wont be multiple users. And i hardly ever use the advanced features of the database for these little applications - things like syndication and triggers etc - i prefer to have ColdFusion take care of all those kinds of jobs. So for the most part, the databases are simple data storage mechanisms, with all the processing of data being done in ColdFusion. Can anyone see a problem if i do this?I'm not sure the machine I'm building justifies the cost of buying a licence for SQLServer2005 the full version. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET http://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:329406 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQLServer Express and SQLServer - totally compatible?
Thanks Dave, and thanks Mark. That gives me what i want. I'll make sure i have good backups of the databases, then try it and see what happens. In this case, I dont think i'm going to get databases bigger than 4GB. It's only for development and I can think of only two cases in the last 5 years where I've had databases approaching that size for development.Production databases yes, but this isnt for production. And I can confirm that SQLServer2005 will allow you to connect databases on removable drives. I was trying it last week, when I was thinking about how i was going to do this.I had the same thought as you, Dave, so I put a few databases on a removable drive including my little intranet, connected them, and there had been no database errors on those CF Datasources in a day of use. A bit of a surprise really, since in a production environment it wouldn't be a good idea. I would have thought Microsoft would have prevented it happening in the first place. I suppose conceptually it's no different to connecting a server to a database file on a network drive.I might even end up using a USB Key instead of a removable drive! Thanks for your advice. 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, Jan 5, 2010 at 1:16 PM, Dave Watts dwa...@figleaf.com wrote: I'm building a second machine which will run CF on it, and will need to manipulate my SQLServer2005 databases on a network server. I'm going to be connecting this machine to these databases on an external drive as though they're local, because i'm going to be swapping back and forth between these machines regularly. I dont want to keep attaching and detatching lots of databases - i'd rather just connect the external database to this machine and then boot it up. Honestly, I don't know if SQL Server will let you do this. I suspect it might not, as Windows can detect removable drives. So if i have SQLServer2005 (the full version) driving the databases when I'm working at one location, and SQLServer2005 Express driving the databases when I'm working at my other location, will that cause problems in the databases? Are the two versions fully compatible at least as far as database file structure etc is concerned? Yes, you can use database files created by one with the other, although there may be some limitations if you use certain features in SQL Server 2005 when you create the database files (such as the ability to create databases larger than 4GB - that's not supported by Express). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.c ~| 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:329407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQLServer Express and SQLServer - totally compatible?
So in your view of it, I'd be using SQL Express running on the external drive for all my machines? (not production though). Thats an interesting thought The total size of all my databases for my development projects is about 2GB so i could probably fit the whole thing, including SQL Express on a USB key couldn't I? 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, Jan 5, 2010 at 1:29 PM, Jaime Metcher jmetc...@gmail.com wrote: Just a thought: if you're carting an external disk back and forth, why not put a VM with SQL Express and your databases on that disk? Personally I run a little VM farm with SQL and CF all off the one eSATA disk. All is kosher as far as SQL is concerned, and if you need to get data onto another server you've still got linked servers and/or SSRS, or even just a file copy of the results of your processing. BTW, I would not be at all suprised if SQL had some kind of fit when your database files arrive back from wherever with a big hole in their LSN's. It's precisely for this reason that detaching/reattaching is necessary. Jaime ~| 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:329408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQLServer Express and SQLServer - totally compatible?
Dave, I didn't catch that it was an external drive - I think if it's an external USB drive you might be right - I was thinking more along the lines of a hot swap sata drive on a sled that plugs into a empty bay. I know with 2000 you could only do direct attached, but now days there are so many storage choices I believe they have changed that limitation. Mike, A quick google search brought up this link: http://stackoverflow.com/questions/78560/locked-sql-server-data-files I think it relates directly to what you want to do - I would read it carefully. It seems like you might end up with ACL signiture or other file status or permission issues when spooling up these files. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, January 04, 2010 8:16 PM To: cf-talk Subject: Re: SQLServer Express and SQLServer - totally compatible? I'm building a second machine which will run CF on it, and will need to manipulate my SQLServer2005 databases on a network server. I'm going to be connecting this machine to these databases on an external drive as though they're local, because i'm going to be swapping back and forth between these machines regularly. I dont want to keep attaching and detatching lots of databases - i'd rather just connect the external database to this machine and then boot it up. Honestly, I don't know if SQL Server will let you do this. I suspect it might not, as Windows can detect removable drives. So if i have SQLServer2005 (the full version) driving the databases when I'm working at one location, and SQLServer2005 Express driving the databases when I'm working at my other location, will that cause problems in the databases? Are the two versions fully compatible at least as far as database file structure etc is concerned? Yes, you can use database files created by one with the other, although there may be some limitations if you use certain features in SQL Server 2005 when you create the database files (such as the ability to create databases larger than 4GB - that's not supported by Express). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more inform ~| 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:329409 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
