Re: Quick Poll - what kind of files do you use every day?
On Sat, 29 Jan 2005 22:40:28 -0800, Rob [EMAIL PROTECTED] wrote: cfml (cfm,cfc), xml, dtd, xsd, xsl (xslt), css, js, html (xhtml, htm), bat, sh, plist, php .log (as text) .txt (as text, someone else mentioned this) .sql -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192237 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Quick Poll - what kind of files do you use every day?
Hey Rob, .as (flash actionscript) -joe On Sat, 29 Jan 2005 22:40:28 -0800, Rob [EMAIL PROTECTED] wrote: I am trying to figure out what kind of file support needs to be in an IDE I am working on for cf development - can anyone add to this list? cfml (cfm,cfc), xml, dtd, xsd, xsl (xslt), css, js, html (xhtml, htm), bat, sh, plist, php c++, and java wont be included directly, but are their any big ones I am missing or that you use? Thanks, Rob -- ~Blog~ http://www.robrohan.com ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192238 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
discussion groups
Any recommendations for (threaded) discussion groups based in CF? Ideally, I'm looking for something that is: 1. CF-based 2. Compatible with SQL-Server backend 3. Full access to source code (either as open source, or via purchasing) 4. Capable of handling high volumes (1000 postings per day) Thanks, Greg Saunders Socratic Arts http://www.socraticarts.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192239 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: discussion groups
I recommend the followingI think it meets your criteria; I checked out several, and liked this one best. http://www.adersoftware.com/index.cfm?page=cfbb Cheers, Doug -Original Message- From: Greg Saunders [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 8:19 AM To: CF-Talk Subject: discussion groups Any recommendations for (threaded) discussion groups based in CF? Ideally, I'm looking for something that is: 1. CF-based 2. Compatible with SQL-Server backend 3. Full access to source code (either as open source, or via purchasing) 4. Capable of handling high volumes (1000 postings per day) Thanks, Greg Saunders Socratic Arts http://www.socraticarts.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192240 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Is it feasible to create an online back-up system with CF?
Good morning... I'm going to be offering online (Internet-based) backup/storage for my clients and have been looking at various solutions (non-CF) already offered and began to wonder if it was possible to create a browser-based backup system using CF and perhaps scheduled tasks to backup files via http or to ftp accounts. Anyone tried anything like this? I've found some solutions, but I have to end up spending about $100 for software per PC to be backed up and that's a steep price per machine just to get them started. Also...anyone know if it's possible to offer this kind of service using any FTP capabilities that might be built-in to Windows 2003 Server Web Edition? Currently using CF 4.5.2 and Windows 2000 Server, but could upgrade if the upgrade provides appropriate capabilities towards my goals... Ideas? Thanks, Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.1 - Release Date: 1/27/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192241 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Quick Poll - what kind of files do you use every day?
Rob wrote: I am trying to figure out what kind of file support needs to be in an IDE I am working on for cf development - can anyone add to this list? cfml (cfm,cfc), xml, dtd, xsd, xsl (xslt), css, js, html (xhtml, htm), bat, sh, plist, php c++, and java wont be included directly, but are their any big ones I am missing or that you use? OpenOffice.org files. (They are really just zip'ed XML files that you can unzip with your favorite tool, but native support is nice.) Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192242 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Using ant 1.6.2 with CFMX
I wonder why the ant classes (Version 1.5) have to be integrated in jrun.jar? Because of this, we are not able to use ANT version 1.6.2 with CFMX. Adding the ANT 1.6.2 jar to the classpath doesn't help, because of the jrun.jar being loaded before the ant.jar. So we had and have problems if we build applications using ant taskdefs. Do you know a workaround for this problem? This problem is not only related to ant, what happens if we use different versions of itext, sax ... in custom applications? Thanks, Florian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192243 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Forcing dowload of text file, unformatted
How do I force the download of a TEXT file to the client browser? I tried this, but it gives me a strange filename. What I want for a filename is: Assemblymap_1006.txt Instead I get Kit_download_assemblymap.cfm For the filename. So what am I doing wrong: CFHEADER NAME=Cache-Control VALUE=0 CFHEADER name=Content-type value=application/octet-stream CFHEADER name=Content-Disposition value=attachment; filename=assemblymap_#url.id#.txt cfcontent file=assemblymap_#url.id#.txt type=application/octet-stream ALSO, I need to download UNFORMATTED text as it appears in the original file. The downloaded file seems to have spaces and linebreaks removed. I can do it on the screen with a pre tag. please advise if you can. TNX. Rick Colman ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192244 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Forcing dowload of text file, unformatted
I wrote this tag up to do file pushes of all kinds. The example below will force open a show/save dialog. If you want to display in the browser window itself, To send a txt file straight to the browser for display (maintaining your formatting) change variables.DisplayType to inline. !--- the tag call --- cfset variables.FilePath=z:\myfiles\ftp\ cfset variables.FileName=mysecretfile.txt cfset variables.MIMEType=text/plain cfset variables.DisplayType=attachment cf_pushfile FilePath=#variables.FilePath# FileName=#variables.FileName# MIMEType=#variables.MIMEType# DisplayType=#variables.DisplayType# !--- cf_pushfile --- cfset variables.FileToPush=attributes.FilePathattributes.FileName cfheader name=content-disposition value=#attributes.DisplayType#; filename=#attributes.FileName# cfcontent type=#attributes.MIMEType# file=#variables.FileToPush# I adapted the above from the tutorial here: http://mysecretbase.com/How_To_Display_Protected_Files.cfm HtH, -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192245 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Poll - what kind of files do you use every day?
Others mentioned SQL and ASP (which should include .asa). Theoretically, this could include ASP.Net, but ASP.Net already has a couple of very nice IDEs. Though less common, I still have several sites out there that use server side includes (.shtm and .shtml). Most of these are moving to Dreamweaver/Contribute templates (.dwt). In addition to writing bat (.bat and .cmd) scripts, I write a number of Windows Scripting Host files (.js and .vbs) for server maintenance and such. I also write sieve scripts for mail server spam filtering, but I've never seen a standard extension for those. I commonly edit ini (.ini) files from within an IDE as most applications store their config in an initialization file, a java properties file, or an XML file. Besides .xml, there are a number of common extensions for XML files (.svg, .xsd, .config, .rss, .rdf, .opml, .cml). I have to admit, I've very intrigued by the question. :) Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 1:40 AM To: CF-Talk Subject: Quick Poll - what kind of files do you use every day? I am trying to figure out what kind of file support needs to be in an IDE I am working on for cf development - can anyone add to this list? cfml (cfm,cfc), xml, dtd, xsd, xsl (xslt), css, js, html (xhtml, htm), bat, sh, plist, php c++, and java wont be included directly, but are their any big ones I am missing or that you use? Thanks, Rob -- ~Blog~ http://www.robrohan.com ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192246 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Quick Poll - what kind of files do you use every day?
From: Rob [mailto:[EMAIL PROTECTED] I am trying to figure out what kind of file support needs to be in an IDE I am working on for cf development - can anyone add to this list? cfml (cfm,cfc), xml, dtd, xsd, xsl (xslt), css, js, html (xhtml, htm), bat, sh, plist, php c++, and java wont be included directly, but are their any big ones I am missing or that you use? For those of us doing PHP work from time to time, especially with PHPBB or vBulletin, .tpl files are common. They are the files that coincide with the styles/skins that those applications use. Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192247 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Forcing dowload of text file, unformatted
This is great, Thank you. Also, it turns out that my formatting problem results from the original text file begin generated on a UNIX system, so there is some sort of problem with end of line characters when displayed on non-unix systems ... -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 9:06 AM To: CF-Talk Subject: Re: Forcing dowload of text file, unformatted I wrote this tag up to do file pushes of all kinds. The example below will force open a show/save dialog. If you want to display in the browser window itself, To send a txt file straight to the browser for display (maintaining your formatting) change variables.DisplayType to inline. !--- the tag call --- cfset variables.FilePath=z:\myfiles\ftp\ cfset variables.FileName=mysecretfile.txt cfset variables.MIMEType=text/plain cfset variables.DisplayType=attachment cf_pushfile FilePath=#variables.FilePath# FileName=#variables.FileName# MIMEType=#variables.MIMEType# DisplayType=#variables.DisplayType# !--- cf_pushfile --- cfset variables.FileToPush=attributes.FilePathattributes.FileName cfheader name=content-disposition value=#attributes.DisplayType#; filename=#attributes.FileName# cfcontent type=#attributes.MIMEType# file=#variables.FileToPush# I adapted the above from the tutorial here: http://mysecretbase.com/How_To_Display_Protected_Files.cfm HtH, -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Quick Poll - what kind of files do you use every day?
Good list :) I am not going for full fledge language support, just basic I often gotta do a quick edit to ... while I am working on cfml stuff and this a good list - totally forgot about ini and rss stuff arg On Sun, 30 Jan 2005 12:09:14 -0500, Ben Rogers [EMAIL PROTECTED] wrote: Others mentioned SQL and ASP (which should include .asa). Theoretically, this could include ASP.Net, but ASP.Net already has a couple of very nice IDEs. Though less common, I still have several sites out there that use server side includes (.shtm and .shtml). Most of these are moving to Dreamweaver/Contribute templates (.dwt). In addition to writing bat (.bat and .cmd) scripts, I write a number of Windows Scripting Host files (.js and .vbs) for server maintenance and such. I also write sieve scripts for mail server spam filtering, but I've never seen a standard extension for those. I commonly edit ini (.ini) files from within an IDE as most applications store their config in an initialization file, a java properties file, or an XML file. Besides .xml, there are a number of common extensions for XML files (.svg, .xsd, .config, .rss, .rdf, .opml, .cml). I have to admit, I've very intrigued by the question. :) Ben Rogers http://www.c4.net v.508.240.0051 f.508.240.0057 -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 1:40 AM To: CF-Talk Subject: Quick Poll - what kind of files do you use every day? I am trying to figure out what kind of file support needs to be in an IDE I am working on for cf development - can anyone add to this list? cfml (cfm,cfc), xml, dtd, xsd, xsl (xslt), css, js, html (xhtml, htm), bat, sh, plist, php c++, and java wont be included directly, but are their any big ones I am missing or that you use? Thanks, Rob -- ~Blog~ http://www.robrohan.com ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192249 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Quick Poll - what kind of files do you use every day?
Good call with the .log one - I added color coding for logs and a tail viewer :) On Sun, 30 Jan 2005 00:19:28 -0800, Sean Corfield [EMAIL PROTECTED] wrote: On Sat, 29 Jan 2005 22:40:28 -0800, Rob [EMAIL PROTECTED] wrote: cfml (cfm,cfc), xml, dtd, xsd, xsl (xslt), css, js, html (xhtml, htm), bat, sh, plist, php .log (as text) .txt (as text, someone else mentioned this) .sql -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 5 invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Quick Poll - what kind of files do you use every day?
Would you like to be able to open them into the XML format, or edit them in a rendered way like in OpenOffice? On Sun, 30 Jan 2005 16:47:40 +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: Rob wrote: I am trying to figure out what kind of file support needs to be in an IDE I am working on for cf development - can anyone add to this list? cfml (cfm,cfc), xml, dtd, xsd, xsl (xslt), css, js, html (xhtml, htm), bat, sh, plist, php c++, and java wont be included directly, but are their any big ones I am missing or that you use? OpenOffice.org files. (They are really just zip'ed XML files that you can unzip with your favorite tool, but native support is nice.) Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192251 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Quick Poll - what kind of files do you use every day?
Rob wrote: Would you like to be able to open them into the XML format, or edit them in a rendered way like in OpenOffice? The XML format. More generalized: support for compressed versions (zip, gzip and deflate) of CFML, HTML, XML, ASP etc. pages. Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192252 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: discussion groups
Galleon is available via DRK. You can see it in action here: www.camdenfamily.com/morpheus/forums In two days I'll be posting an update that will address your 3rd issue. On Sun, 30 Jan 2005 07:19:10 -0600, Greg Saunders [EMAIL PROTECTED] wrote: Any recommendations for (threaded) discussion groups based in CF? Ideally, I'm looking for something that is: 1. CF-based 2. Compatible with SQL-Server backend 3. Full access to source code (either as open source, or via purchasing) 4. Capable of handling high volumes (1000 postings per day) Thanks, Greg Saunders Socratic Arts http://www.socraticarts.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192253 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL on CFMX
I use 4.1 exclusively. It's got some nice advantages over 4.0 and 3.23, such as subqueries, column-level character set support, proper handling of temporary tables in transactions, and a few other things. Which isn't to say 4.0 or 3.23 is a bad way to go, just you're goingto be missing out on some of those features. Subqueries, in particular. cheers, barneyb On Sat, 29 Jan 2005 13:31:12 -0400, Stan Winchester [EMAIL PROTECTED] wrote: I am using MySQL 4.1. Should I be using an earlier version? Do many hosting company use 4.1? Thanks for the tech articles! Could it be that you are using MySQL 4.1? http://www.talkingtree.com/blog/index.cfm?mode=aliasalias=MySQL41 http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253 The server and ports are correct. -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 6 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF-based Online Backup System...any thoughts?
Doable? Been Done? Any thoughts on what I asked about earlier? --- Good morning... I'm going to be offering online (Internet-based) backup/storage for my clients and have been looking at various solutions (non-CF) already offered and began to wonder if it was possible to create a browser-based backup system using CF and perhaps scheduled tasks to backup files via http or to ftp accounts. Anyone tried anything like this? I've found some solutions, but I have to end up spending about $100 for software per PC to be backed up and that's a steep price per machine just to get them started. Also...anyone know if it's possible to offer this kind of service using any FTP capabilities that might be built-in to Windows 2003 Server Web Edition? Currently using CF 4.5.2 and Windows 2000 Server, but could upgrade if the upgrade provides appropriate capabilities towards my goals... Ideas? Thanks, Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.1 - Release Date: 1/27/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192255 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF-based Online Backup System...any thoughts?
Rick, what are you backing up? Files from a server or files from a client PC? - Original Message - From: [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, January 30, 2005 11:46 AM Subject: CF-based Online Backup System...any thoughts? Doable? Been Done? Any thoughts on what I asked about earlier? -- -- --- Good morning... I'm going to be offering online (Internet-based) backup/storage for my clients and have been looking at various solutions (non-CF) already offered and began to wonder if it was possible to create a browser-based backup system using CF and perhaps scheduled tasks to backup files via http or to ftp accounts. Anyone tried anything like this? I've found some solutions, but I have to end up spending about $100 for software per PC to be backed up and that's a steep price per machine just to get them started. Also...anyone know if it's possible to offer this kind of service using any FTP capabilities that might be built-in to Windows 2003 Server Web Edition? Currently using CF 4.5.2 and Windows 2000 Server, but could upgrade if the upgrade provides appropriate capabilities towards my goals... Ideas? Thanks, Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.1 - Release Date: 1/27/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192256 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF-based Online Backup System...any thoughts?
[EMAIL PROTECTED] wrote: I'm going to be offering online (Internet-based) backup/storage for my clients and have been looking at various solutions (non-CF) already offered and began to wonder if it was possible to create a browser-based backup system using CF and perhaps scheduled tasks to backup files via http or to ftp accounts. What exactly are the requirements? File encryption? Transfer encryption? Full backups? Incremental backups? Differential backups? Bandwidth use? Automation level? Client push or server pull? Also...anyone know if it's possible to offer this kind of service using any FTP capabilities that might be built-in to Windows 2003 Server Web Edition? No way. FTP uses plain text transfers including plain text passwords. People make backups of data because that data is valuable and that usually means they don't want prying eyes. Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192257 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF-based Online Backup System...any thoughts?
Hi, Rob... Backing up data from client's workstations or servers...whatever they have their data on to my server(s)... -Original Message- From: Rob Munn [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 3:04 PM To: CF-Talk Subject: Re: CF-based Online Backup System...any thoughts? Rick, what are you backing up? Files from a server or files from a client PC? - Original Message - From: [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, January 30, 2005 11:46 AM Subject: CF-based Online Backup System...any thoughts? Doable? Been Done? Any thoughts on what I asked about earlier? -- -- --- Good morning... I'm going to be offering online (Internet-based) backup/storage for my clients and have been looking at various solutions (non-CF) already offered and began to wonder if it was possible to create a browser-based backup system using CF and perhaps scheduled tasks to backup files via http or to ftp accounts. Anyone tried anything like this? I've found some solutions, but I have to end up spending about $100 for software per PC to be backed up and that's a steep price per machine just to get them started. Also...anyone know if it's possible to offer this kind of service using any FTP capabilities that might be built-in to Windows 2003 Server Web Edition? Currently using CF 4.5.2 and Windows 2000 Server, but could upgrade if the upgrade provides appropriate capabilities towards my goals... Ideas? Thanks, Rick -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.1 - Release Date: 1/27/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF-based Online Backup System...any thoughts?
Jochem wrote: What exactly are the requirements? File encryption? Transfer encryption? Full backups? Incremental backups? Differential backups? Bandwidth use? Automation level? Client push or server pull? Rick's Response: Yes to all of the above...on the last two, everything would have to happen automatically, as with most backup software...set it and forget it. Client push or server pull...don't know how to answer that...not enough understanding on my part about the difference... Rick -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 3:09 PM To: CF-Talk Subject: Re: CF-based Online Backup System...any thoughts? [EMAIL PROTECTED] wrote: I'm going to be offering online (Internet-based) backup/storage for my clients and have been looking at various solutions (non-CF) already offered and began to wonder if it was possible to create a browser-based backup system using CF and perhaps scheduled tasks to backup files via http or to ftp accounts. What exactly are the requirements? File encryption? Transfer encryption? Full backups? Incremental backups? Differential backups? Bandwidth use? Automation level? Client push or server pull? Also...anyone know if it's possible to offer this kind of service using any FTP capabilities that might be built-in to Windows 2003 Server Web Edition? No way. FTP uses plain text transfers including plain text passwords. People make backups of data because that data is valuable and that usually means they don't want prying eyes. Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192259 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF-based Online Backup System...any thoughts?
If I could just figure out how WebDrive maps a WebDAV compliant server to a drive letter on a user's system, I could do that manually each time and just use WinBackup's software to backup to that drive... Rick -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 3:09 PM To: CF-Talk Subject: Re: CF-based Online Backup System...any thoughts? [EMAIL PROTECTED] wrote: I'm going to be offering online (Internet-based) backup/storage for my clients and have been looking at various solutions (non-CF) already offered and began to wonder if it was possible to create a browser-based backup system using CF and perhaps scheduled tasks to backup files via http or to ftp accounts. What exactly are the requirements? File encryption? Transfer encryption? Full backups? Incremental backups? Differential backups? Bandwidth use? Automation level? Client push or server pull? Also...anyone know if it's possible to offer this kind of service using any FTP capabilities that might be built-in to Windows 2003 Server Web Edition? No way. FTP uses plain text transfers including plain text passwords. People make backups of data because that data is valuable and that usually means they don't want prying eyes. Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192260 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF-based Online Backup System...any thoughts?
[EMAIL PROTECTED] wrote: Jochem wrote: What exactly are the requirements? File encryption? Transfer encryption? Full backups? Incremental backups? Differential backups? Bandwidth use? Automation level? Client push or server pull? Yes to all of the above... Then you are in for a fat client, because file encryption is not going to work from a browser / HTTP based solution. You might want to check out what subscription based commercial solutions are available in your area. Most telco's here work with at least one backup provider for their business lines. If you want to do everything yourself, check out Boxbackup: http://www.fluffy.co.uk/boxbackup/ Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF-based Online Backup System...any thoughts?
Jochem wrote: No way. FTP uses plain text transfers including plain text passwords. Rick's Response: The combination of WinBackup and WebDrive that I've been experimenting with is running through FTP... WinBackup offers up to 256 bit AES Encryption, but WebDrive, which is connecting to my FTP Server is not securing passwords? So the data is encrypted, but the passwords are not and open to be stolen? You can tell, probably, that I'm in way over my head with this stuff... Rick -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 3:09 PM To: CF-Talk Subject: Re: CF-based Online Backup System...any thoughts? [EMAIL PROTECTED] wrote: I'm going to be offering online (Internet-based) backup/storage for my clients and have been looking at various solutions (non-CF) already offered and began to wonder if it was possible to create a browser-based backup system using CF and perhaps scheduled tasks to backup files via http or to ftp accounts. What exactly are the requirements? File encryption? Transfer encryption? Full backups? Incremental backups? Differential backups? Bandwidth use? Automation level? Client push or server pull? Also...anyone know if it's possible to offer this kind of service using any FTP capabilities that might be built-in to Windows 2003 Server Web Edition? No way. FTP uses plain text transfers including plain text passwords. People make backups of data because that data is valuable and that usually means they don't want prying eyes. Jochem ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192262 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF-based Online Backup System...any thoughts?
[EMAIL PROTECTED] wrote: If I could just figure out how WebDrive maps a WebDAV compliant server to a drive letter on a user's system, I could do that manually each time and just use WinBackup's software to backup to that drive... Put a batchfile in the startup folder. Page 63 of the User Guide for the syntax :-) Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192263 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF-based Online Backup System...any thoughts?
[EMAIL PROTECTED] wrote: The combination of WinBackup and WebDrive that I've been experimenting with is running through FTP... WinBackup offers up to 256 bit AES Encryption, but WebDrive, which is connecting to my FTP Server is not securing passwords? Correct. So the data is encrypted, but the passwords are not and open to be stolen? Correct. So with that password somebody can access the backups and download them or worse, delete them. Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192264 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF-based Online Backup System...any thoughts?
Hmmm...interesting...which User Guide are we talking about? Rick -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 3:39 PM To: CF-Talk Subject: Re: CF-based Online Backup System...any thoughts? [EMAIL PROTECTED] wrote: If I could just figure out how WebDrive maps a WebDAV compliant server to a drive letter on a user's system, I could do that manually each time and just use WinBackup's software to backup to that drive... Put a batchfile in the startup folder. Page 63 of the User Guide for the syntax :-) Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192266 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF-based Online Backup System...any thoughts?
As Jochem suggests, you need some sort of client to enable the functionality. WebDAV support on the server side is something you need to deal with separately, but it sounds like you have an idea of what that would entail. Check the WebDAV site for more details if you need it: http://www.webdav.org/projects/ My thinking is that you could access WebDAV bits written in Java from CFMX to deal with the server side issues. I looked at doing this at one point in the past, but WebDAV support was not as robust as it is today. For the client side, I've never seen it, but my guess about WebDrive is that they have some sort of ActiveX desktop component you have to download and install on the client PC to enable this support. Look at how RDS works in Homesite+/DW. The client side is a component that installs onto your desktop and integrates with IE. - Original Message - From: [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, January 30, 2005 12:25 PM Subject: RE: CF-based Online Backup System...any thoughts? If I could just figure out how WebDrive maps a WebDAV compliant server to a drive letter on a user's system, I could do that manually each time and just use WinBackup's software to backup to that drive... Rick -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 3:09 PM To: CF-Talk Subject: Re: CF-based Online Backup System...any thoughts? [EMAIL PROTECTED] wrote: I'm going to be offering online (Internet-based) backup/storage for my clients and have been looking at various solutions (non-CF) already offered and began to wonder if it was possible to create a browser-based backup system using CF and perhaps scheduled tasks to backup files via http or to ftp accounts. What exactly are the requirements? File encryption? Transfer encryption? Full backups? Incremental backups? Differential backups? Bandwidth use? Automation level? Client push or server pull? Also...anyone know if it's possible to offer this kind of service using any FTP capabilities that might be built-in to Windows 2003 Server Web Edition? No way. FTP uses plain text transfers including plain text passwords. People make backups of data because that data is valuable and that usually means they don't want prying eyes. Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192266 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF-based Online Backup System...any thoughts?
[EMAIL PROTECTED] wrote: Hmmm...interesting...which User Guide are we talking about? The WebDrive User Guide. Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192267 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Image popup UDF
I got tired of linking to an original image via target =_blank to enlarge the
view. There's no control over it. So I built a variation of Nate's popup window
UDF from WACK.
Here's what I've come up with, maybe someone has some improvements? Would a
custom tag be better for this? There are quite a few parameters, but they make
it much more flexible.
Any suggestions would be appreciated. It seems to work great in testing.
cffunction name=ImagePopup returntype=string hint=Sends in an image name
and makes
a larger version popup from it. Also displays the image itself on your page,
in whatever size you specify
cfargument name=ImageName type=string required=yes
cfargument name=LinkFolder type=string required=yes
cfargument name=LinkText type=string required=no default=Click to
enlarge
cfargument name=PopupWidth type=numeric default=450
cfargument name=PopupHeight type=numeric default=500
cfargument name=PopupTop type=numeric default=200
cfargument name=PopupLeft type=numeric default=200
cfargument name=Scroll type=string default=yes
cfargument name=ImgWidth type=numeric default=100
cfargument name=ImgHeight type=numeric default=100
cfset var Features =
cfset var LinkCode =
cfset Features = width=#ARGUMENTS.PopupWidth#,
height=#ARGUMENTS.PopupHeight#, top=#ARGUMENTS.PopupTop#,
left=#ARGUMENTS.PopupLeft#, scrollbars=#ARGUMENTS.Scroll#
cfsavecontent variable=LinkCode
cfoutput
a href=#LinkFolder#/#ARGUMENTS.ImageName#
onClick=popupWin=window.open('#LinkFolder#/#ARGUMENTS.ImageName#','wcspopup','#Features#');
popupWin.focus(); return false;
onMouseOver=window.status='#JSStringFormat(LinkText)#';return true;
onMouseOut=window.status=''; return true;img
src=#LinkFolder#/#ARGUMENTS.ImageName# height=#ARGUMENTS.Imgheight#
width=#ARGUMENTS.ImgWidth# border=0 alt=Click for a larger view //a
/cfoutput
/cfsavecontent
cfreturn LinkCode
/cffunction
And here's how I use it. Apply to a hard-coded image name, or the way I am, a
query.
!--- This UDF makes images pop up in a new window via Javascript. List
attributes in this order:
imagename, image folder, mouseover text, Popup width, Popup height, distance
from top, distance from left,scrollbar yes or no, image width, image height ---
#ImagePopup(getimages.imagename, productimages, Click for larger view, 500,
500, 20, 300, yes, 175, 175)#
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192268
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF-based Online Backup System...any thoughts?
So what's the solution to secure online storage if not FTP? VPN? What's the point of having User Accounts on my server to access FTP directories if the User Account passwords aren't secure with FTP? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 3:42 PM To: CF-Talk Subject: Re: CF-based Online Backup System...any thoughts? [EMAIL PROTECTED] wrote: The combination of WinBackup and WebDrive that I've been experimenting with is running through FTP... WinBackup offers up to 256 bit AES Encryption, but WebDrive, which is connecting to my FTP Server is not securing passwords? Correct. So the data is encrypted, but the passwords are not and open to be stolen? Correct. So with that password somebody can access the backups and download them or worse, delete them. Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192269 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF-based Online Backup System...any thoughts?
[EMAIL PROTECTED] wrote: So what's the solution to secure online storage if not FTP? VPN? VPN, SSH, SFTP, IPSec etc. What's the point of having User Accounts on my server to access FTP directories if the User Account passwords aren't secure with FTP? It keeps honest people honest. Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfeclipse
I have been using Eclipse (cfeclipse)locally for development but have yet to connect up to a remote site... which made me just realize I don't know how to do it! Is there a particular plugin I need for this? Thanks! Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192271 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfeclipse
There is no way to use RDS (if that's what you need). To use FTP with the stable version you can import and export projects (you may have to get the FTP and WebDav plugin - HelpSoftware UpdatesFind and Install... and look in the Eclipse.org bookmark). If you are using the non-stable you can use the file explorer view to edit remote ftp files, but you can not create / delete remote files yet. Right now, for the sites I have to upload, I code local and then use Ant or Fugu (a separate tool) to upload them - I consider it to be better practice to code local and only upload when done, but I know reality is not always that kind. So - long way around - if you're not using FTP you can't Cheers, Rob On Sun, 30 Jan 2005 16:38:11 -0500, Michael T. Tangorre [EMAIL PROTECTED] wrote: I have been using Eclipse (cfeclipse)locally for development but have yet to connect up to a remote site... which made me just realize I don't know how to do it! Is there a particular plugin I need for this? Thanks! Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192272 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfeclipse
From: Rob [mailto:[EMAIL PROTECTED] There is no way to use RDS (if that's what you need). To use FTP with the stable version you can import and export projects (you may have to get the FTP and WebDav plugin - HelpSoftware UpdatesFind and Install... and look in the Eclipse.org bookmark). If you are using the non-stable you can use the file explorer view to edit remote ftp files, but you can not create / delete remote files yet. Right now, for the sites I have to upload, I code local and then use Ant or Fugu (a separate tool) to upload them - I consider it to be better practice to code local and only upload when done, but I know reality is not always that kind. So - long way around - if you're not using FTP you can't Thanks Rob. No RDS desires here... only FTP :-) I will check into the FTP options.. What are the long terms plans for remote file support in eclipse, any idea? Thanks, Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192273 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfeclipse
I can't answer for the Eclipse project itself, but we plan to support FTP and SFTP through something similar to the existing Navigator view. The basic idea being that you can right-click on a file and folder and choose get/put/synchronize. When you choose one of those options you are presented with a dialog box that allows you to specify the FTP server and relative path details. If you have previously performed an FTP operation on that file/folder, or one of it's ancestors in the project tree, those details will be prefilled in the dialog. We might also keep a history of FTP connections per tree location so you can choose push to a staging server or to a live server for example without having to remember and type in the connection details for each. Spike Michael T. Tangorre wrote: From: Rob [mailto:[EMAIL PROTECTED] There is no way to use RDS (if that's what you need). To use FTP with the stable version you can import and export projects (you may have to get the FTP and WebDav plugin - HelpSoftware UpdatesFind and Install... and look in the Eclipse.org bookmark). If you are using the non-stable you can use the file explorer view to edit remote ftp files, but you can not create / delete remote files yet. Right now, for the sites I have to upload, I code local and then use Ant or Fugu (a separate tool) to upload them - I consider it to be better practice to code local and only upload when done, but I know reality is not always that kind. So - long way around - if you're not using FTP you can't Thanks Rob. No RDS desires here... only FTP :-) I will check into the FTP options.. What are the long terms plans for remote file support in eclipse, any idea? Thanks, Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfeclipse
From: Spike [mailto:[EMAIL PROTECTED] I can't answer for the Eclipse project itself, but we plan to support FTP and SFTP through something similar to the existing Navigator view. The basic idea being that you can right-click on a file and folder and choose get/put/synchronize. When you choose one of those options you are presented with a dialog box that allows you to specify the FTP server and relative path details. If you have previously performed an FTP operation on that file/folder, or one of it's ancestors in the project tree, those details will be prefilled in the dialog. We might also keep a history of FTP connections per tree location so you can choose push to a staging server or to a live server for example without having to remember and type in the connection details for each. Awesome. In the meantime I think the webdav/ftp plugin should work.. although it's a little tedious to use. The Navigator integration you mentioned would be very cool. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192275 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Is it feasible to create an online back-up system with CF?
I'm sure there is a way to programatically add FTP accounts to your windows box using CF. The user then clicks a link opening thier FTP account in the browser and drag and drop the files to be backed up. You can then sweep the directory of each user when they login and present the files for download via HTTP. Something like this? The only problem is that it is user initiated, but you could create a script that they schedule to run on thier machine to initate the backup. Regards, Jon On Sun, 30 Jan 2005 10:31:48 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Good morning... I'm going to be offering online (Internet-based) backup/storage for my clients and have been looking at various solutions (non-CF) already offered and began to wonder if it was possible to create a browser-based backup system using CF and perhaps scheduled tasks to backup files via http or to ftp accounts. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfeclipse
Personally, I really LIKE the FTP/WebDAV method...
And it fits well with Rob's write local/publish remote best practices idea.
However, there's a bug in the FTP tool that will result in an error
message that reads:
Site Missing for {ftp URL}
I've traced it back to the FTP plugin not writing configuration
information for a second site, possibly a second FTP URL at the same
IP? That's where I've run into it the worst.
While I don't have time to actually get into dealing with the Java to
fix it, I do know what the problem is an am working on finding a
workaround. The issue is that it creates a several-character signature
that links the Eclipse project to the FTP URL, and I haven't found a
reliable means to detect/edit it and insert it into the config file.
The config file for the FTP/WebDAV plugin is at:
\eclipse\workspace\.metadata\.plugins\org.eclipse.team.core\.targetSites
The signature for the site is a mix of null characters and other
special characters tailed with a 3-letter code...
So, I'll let you know when I know more...
Laterz,
J
On Sun, 30 Jan 2005 17:33:02 -0500, Michael T. Tangorre
[EMAIL PROTECTED] wrote:
From: Spike [mailto:[EMAIL PROTECTED]
I can't answer for the Eclipse project itself, but we plan to support
FTP and SFTP through something similar to the existing Navigator view.
The basic idea being that you can right-click on a file and
folder and
choose get/put/synchronize. When you choose one of those
options you are
presented with a dialog box that allows you to specify the FTP server
and relative path details. If you have previously performed an FTP
operation on that file/folder, or one of it's ancestors in
the project
tree, those details will be prefilled in the dialog. We might
also keep
a history of FTP connections per tree location so you can
choose push
to a staging server or to a live server for example without having to
remember and type in the connection details for each.
Awesome.
In the meantime I think the webdav/ftp plugin should work.. although it's a
little tedious to use. The Navigator integration you mentioned would be very
cool.
Mike
--
Continuum Media Group LLC
Burnsville, MN 55337
http://www.web-relevant.com
http://cfobjective.blogspot.com
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192277
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: better way to code?
Claude Schneegans wrote: It seems to use the power of CF more. It may be, but is it really what makes good code? The first code is more intuitive , logical and it corresponds to the real situation. It explains more clearly the two situations that can be encountered. The second code leads to think that the second case is an error of the first, which is not true. And BTW, the first code could still be embeded inside a CFTRY to handle true errors, ... and use all the power of CF! ;-) Also, the use of try/catch in this way is generally not so great because you could catch more than you bargained for. Using the if, you're testing for a very specific condition that you can anticipate and handle. With the catch, you will not only catch the exception you expect, but anything else which you don't expect, which you probably should be letting get thrown up to the caller rather than be caught. In general, when dealing with exceptions, you should catch only that which you expect and can deal with, anything else should be allowed to be thrown up to the caller which may understand the context of the exception better, and so be better equipped to handle it. Obviously in this simple example, there isn't much else that could go wrong to cause an exception to be thrown, but it's something to keep in mind. -- - Chris Jensen [EMAIL PROTECTED] Educational Experience (Australia) Postal Address: PO Box 860, Newcastle NSW 2300 Freecall: 1-800-025 270 International: +61-2-4923 8222 Fax:(02) 4942 1991 International: +61-2-4942 1991 Visit our online Toy store! http://www.toysandmore.com.au/ - ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfeclipse
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Personally, I really LIKE the FTP/WebDAV method... And it fits well with Rob's write local/publish remote best practices idea. After playing around with it for an hour or so I would agree. It is nice.. not as cumbersome as I first thought. Getting the commands into the navigator pane would be a nice addition... right click context menus on the files would be a definite plus. Right not it is not so bad though... the files appear in the outgoing pane so you know what needs to go... not too bad at all. Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfeclipse
Absolutely... I'd like to see something Dreamweaver-like, with a Syncronize, Put, and Get button across the top of the Project pane. Selecting files in the pane and then clicking any of the 3 buttons avctivates that function. I don't know if it's possible to hook CFE into the FTP plugin though... I'm just looking forward to seeing what these guys produce in the future. And Rob and Spike... you guys rock. Thanks for all the work. Laterz, J On Sun, 30 Jan 2005 18:58:25 -0500, Michael T. Tangorre [EMAIL PROTECTED] wrote: From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Personally, I really LIKE the FTP/WebDAV method... And it fits well with Rob's write local/publish remote best practices idea. After playing around with it for an hour or so I would agree. It is nice.. not as cumbersome as I first thought. Getting the commands into the navigator pane would be a nice addition... right click context menus on the files would be a definite plus. Right not it is not so bad though... the files appear in the outgoing pane so you know what needs to go... not too bad at all. Mike -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192280 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfeclipse
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] And Rob and Spike... you guys rock. Thanks for all the work. No doubt! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192281 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Image popup UDF
Will, do you have Dreamweaver MX?
-Joe
On Sun, 30 Jan 2005 15:58:32 -0400, Will Tomlinson [EMAIL PROTECTED] wrote:
I got tired of linking to an original image via target =_blank to enlarge
the view. There's no control over it. So I built a variation of Nate's popup
window UDF from WACK.
Here's what I've come up with, maybe someone has some improvements? Would a
custom tag be better for this? There are quite a few parameters, but they
make it much more flexible.
Any suggestions would be appreciated. It seems to work great in testing.
cffunction name=ImagePopup returntype=string hint=Sends in an image
name and makes
a larger version popup from it. Also displays the image itself on your page,
in whatever size you specify
cfargument name=ImageName type=string required=yes
cfargument name=LinkFolder type=string required=yes
cfargument name=LinkText type=string required=no default=Click to
enlarge
cfargument name=PopupWidth type=numeric default=450
cfargument name=PopupHeight type=numeric default=500
cfargument name=PopupTop type=numeric default=200
cfargument name=PopupLeft type=numeric default=200
cfargument name=Scroll type=string default=yes
cfargument name=ImgWidth type=numeric default=100
cfargument name=ImgHeight type=numeric default=100
cfset var Features =
cfset var LinkCode =
cfset Features = width=#ARGUMENTS.PopupWidth#,
height=#ARGUMENTS.PopupHeight#, top=#ARGUMENTS.PopupTop#,
left=#ARGUMENTS.PopupLeft#, scrollbars=#ARGUMENTS.Scroll#
cfsavecontent variable=LinkCode
cfoutput
a href=#LinkFolder#/#ARGUMENTS.ImageName#
onClick=popupWin=window.open('#LinkFolder#/#ARGUMENTS.ImageName#','wcspopup','#Features#');
popupWin.focus(); return false;
onMouseOver=window.status='#JSStringFormat(LinkText)#';return true;
onMouseOut=window.status=''; return true;img
src=#LinkFolder#/#ARGUMENTS.ImageName# height=#ARGUMENTS.Imgheight#
width=#ARGUMENTS.ImgWidth# border=0 alt=Click for a larger view //a
/cfoutput
/cfsavecontent
cfreturn LinkCode
/cffunction
And here's how I use it. Apply to a hard-coded image name, or the way I am,
a query.
!--- This UDF makes images pop up in a new window via Javascript. List
attributes in this order:
imagename, image folder, mouseover text, Popup width, Popup height, distance
from top, distance from left,scrollbar yes or no, image width, image height
---
#ImagePopup(getimages.imagename, productimages, Click for larger view,
500, 500, 20, 300, yes, 175, 175)#
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192282
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Selecting one record and potentially two others.
For those good SQL types out there. I need a query that will pick one record by it's id, this part is easy. What I would like is a query that picks this one record and the record immediatly before it and after it by id sequence, if they exist. An example may be clearer. ID image photographer 1 a.jpg Sam 2 b.jpg Sam 3 c.jpg Sam 7 d.jpg George 8 f.jpg George 10 g.jpg George 11 h.jpg George 12 i.jpg George If id 2 is passed I would like records 1, 2, and 3. If id 3 is passied I would like records 2 and 3, only want records of the same photographer as the passed ID. if id 10 is passed I would like records 8, 10 and 11, even though there is a gap, I would like three records. I suspect I need sub-selects, but I can not quite picture how they would go together. This is against a SQL Server DBMS if that matters. Thank You. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Selecting one record and potentially two others.
Ian Skinner wrote: I need a query that will pick one record by it's id, this part is easy. What I would like is a query that picks this one record and the record immediatly before it and after it by id sequence, if they exist. An example may be clearer. ID image photographer 1 a.jpg Sam 2 b.jpg Sam 3 c.jpg Sam 7 d.jpg George 8 f.jpg George 10 g.jpg George 11 h.jpg George 12 i.jpg George SELECT TOP 2 ID, image, photographer FROM photo WHERE ID = cfqueryparam ... AND photographer = cfqueryparam ... ORDER BY ID ASC UNION SELECT TOP 2 ID, image, photographer FROM photo WHERE ID = cfqueryparam ... AND photographer = cfqueryparam ... ORDER BY ID DESC Jochem ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Selecting one record and potentially two others.
Ian, Here is my first stab even though I haven't tested it. select a.*, (select top 1 id from temp_image b where b.photographer = a.photographer and b.id a.id ) as nextid, (select top 1 id from temp_image b where b.photographer = a.photographer and b.id a.id order by id desc ) as previousid from temp_image a where a.photographer = 'George' and a.id = 10 Qasim On Sun, 30 Jan 2005 16:52:43 -0800, Ian Skinner [EMAIL PROTECTED] wrote: For those good SQL types out there. I need a query that will pick one record by it's id, this part is easy. What I would like is a query that picks this one record and the record immediatly before it and after it by id sequence, if they exist. An example may be clearer. ID image photographer 1 a.jpg Sam 2 b.jpg Sam 3 c.jpg Sam 7 d.jpg George 8 f.jpg George 10 g.jpg George 11 h.jpg George 12 i.jpg George If id 2 is passed I would like records 1, 2, and 3. If id 3 is passied I would like records 2 and 3, only want records of the same photographer as the passed ID. if id 10 is passed I would like records 8, 10 and 11, even though there is a gap, I would like three records. I suspect I need sub-selects, but I can not quite picture how they would go together. This is against a SQL Server DBMS if that matters. Thank You. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192285 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Selecting one record and potentially two others.
From: Ian Skinner [mailto:[EMAIL PROTECTED] What I would like is a query that picks this one record and the record immediatly before it and after it by id sequence, if they exist. An example may be clearer. If id 2 is passed I would like records 1, 2, and 3. If id 3 is passied I would like records 2 and 3, only want records of the same photographer as the passed ID. if id 10 is passed I would like records 8, 10 and 11, even though there is a gap, I would like three records. Ian, How about... -- Middle ID, passed in? DECLARE @M_ID INT -- Low end ID DECLARE @L_ID INT -- High end ID DECLARE @H_ID INT SET @M_ID = 4 SET @L_ID = (SELECT USER_ID FROM APP_USER WHERE USER_ID = (SELECT MAX(USER_ID) FROM USER WHERE USER_ID @M_ID)) SET @H_ID = (SELECT USER_ID FROM APP_USER WHERE USER_ID = (SELECT MIN(USER_ID) FROM USER WHERE USER_ID @M_ID)) PRINT @L_ID PRINT @M_ID PRINT @H_ID Modify the above to better suit your needs... Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192286 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Image popup UDF
Will, do you have Dreamweaver MX? Yes Joe, that's pretty much all I use. I hope you're not gonna tell me it already does something like this?? LoL Will ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192287 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: discussion groups
I just downloaded and installed that one. I keep getting an error saying the stored procedures cannot be found. They are there. I ran the two routines that set up and populate the data tables and stored procedures. Any ideas? Lee On Sun, 30 Jan 2005 08:31:00 -0500 Doug Hyde [EMAIL PROTECTED] wrote: I recommend the followingI think it meets your criteria; I checked out several, and liked this one best. http://www.adersoftware.com/index.cfm?page=cfbb Cheers, Doug -Original Message- From: Greg Saunders [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 8:19 AM To: CF-Talk Subject: discussion groups Any recommendations for (threaded) discussion groups based in CF? Ideally, I'm looking for something that is: 1. CF-based 2. Compatible with SQL-Server backend 3. Full access to source code (either as open source, or via purchasing) 4. Capable of handling high volumes (1000 postings per day) Thanks, Greg Saunders Socratic Arts http://www.socraticarts.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192288 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: discussion groups
i installed it too. The only problem i had was that my db user did not have permissions to execute the SPs; i added the permission to each SP manually in enterprise manager, and after that it worked. I also had to set an email address for the from address in the administrator before i could register new accounts. After that, it's been great; i really like it so far. Greg Saunders At 07:26 PM 1/30/2005, Lee wrote: I just downloaded and installed that one. I keep getting an error saying the stored procedures cannot be found. They are there. I ran the two routines that set up and populate the data tables and stored procedures. Any ideas? Lee On Sun, 30 Jan 2005 08:31:00 -0500 Doug Hyde [EMAIL PROTECTED] wrote: I recommend the followingI think it meets your criteria; I checked out several, and liked this one best. http://www.adersoftware.com/index.cfm?page=cfbb Cheers, Doug -Original Message- From: Greg Saunders [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 8:19 AM To: CF-Talk Subject: discussion groups Any recommendations for (threaded) discussion groups based in CF? Ideally, I'm looking for something that is: 1. CF-based 2. Compatible with SQL-Server backend 3. Full access to source code (either as open source, or via purchasing) 4. Capable of handling high volumes (1000 postings per day) Thanks, Greg Saunders Socratic Arts http://www.socraticarts.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192289 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
eclipse css plugin
I have been toying with the CSS pluign (http://csseditor.sourceforge.net/) for a little bit but can not seem to get it to work... it doesn't even show up in the show view window (not even under other. I did confirm that it is in the plugins directory and eclipse sees it via the plugin manager... Any ideas? Is there a better css plugin I should look at? Is there a specific email list for eclipse questions? :-) Thanks Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192290 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX and CGLOBAL/CDATA not purging
Hey all, In the process of performing a yearly upgrade I was quite surprised to find that my CGLOBAL and CDATA tables contained over 20 million (yes, million) entries each, and the CGLOBAL.MYD file alone had a size of 3.1 gigs. Needless to say, I had been operating under the assumption that the tables were purging correctly. Apparantly I was incorrect. Anyway, I've taken a hatchet to the tabbles and whacked them down to size, and have verified that indeed the purge option (30 days) is selected. Does anyone have any clue why my tables aren't purging? I am running mysql / CFMX6.1 / lotsa mem / dual xeon Terry ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192291 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
install issues
Ok, so my 6.1 install isn't going well. The install has placed and started the server, but without connectors. when I run the manual install on the connectors (after verifying that the server is running) I get a message that basically says that the JNDI listening port listed in the jndi.properties file may not be accessible because of TCP/IP filtering or a firewall (my firewall was disabled prior to the install, and filtering isn't enabled). Or that the host may be unaccessible as it is listed in the security.properties file (I did have to manually add 'localhost' to this file and restart the CFMX server). I've checked the livedocs, but without any success to these specific issues. Any ideas? specs: WinXP Pro CFMX 6.1 (devnet) ZoneAlarm (disabled) Windows Firewall (always disabled) TIA, Cutter ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192292 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: discussion groups
It looks really good, hopefully we will be able to buy it now that DevNet has gone? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192293 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: discussion groups
Andrew, please check my blog on Feb 1st. Sorry to be coy, I just can't say anything more till then. On Sun, 30 Jan 2005 22:52:44 -0400, Andrew Grosset [EMAIL PROTECTED] wrote: It looks really good, hopefully we will be able to buy it now that DevNet has gone? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192294 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: eclipse css plugin
Answering backwards: http://www.cfeclipse.org (http://cfeclipse.tigris.org/servlets/ProjectMailingListList) Try making a file with a .css extension and see if when you open it the css editor doesn't kick in. I've had pretty good luck with that plugin actually. If you're running Mac OSX and want to try out a beta version of the IDE (with that css plugin working) let me know On Sun, 30 Jan 2005 21:35:58 -0500, Michael T. Tangorre [EMAIL PROTECTED] wrote: I have been toying with the CSS pluign (http://csseditor.sourceforge.net/) for a little bit but can not seem to get it to work... it doesn't even show up in the show view window (not even under other. I did confirm that it is in the plugins directory and eclipse sees it via the plugin manager... Any ideas? Is there a better css plugin I should look at? Is there a specific email list for eclipse questions? :-) Thanks Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192295 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFSCHEDULE RSS into DB
Great title, I know. Thanks... I'll be here all week... That said, I've managed to grab a bunch of RSS feeds that I'd like to use as content on my site and I want to utilize CFSCHEDULE (and I'm a novice with this) to actually run the page and insert the data into the database so that I don't have to rely upon an external source for my pages to load. I've been told that yes, this is being done before, but I truly need some help getting the content into my database. A tutorial or brief guidance would be very welcome! Thanks in advance! Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192296 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: eclipse css plugin
To expand on what Rob said, the CSS Editor plugin doesn't have any views or perspecitves associated with it. However, it does make use of the Outline view, which CFEclipse uses as well to make an outline of your code. The editor kicks in right away when you open a .CSS file, assuming your file associations are hooked up right. -nathan strutz http://www.dopefly.com/ Rob wrote: Answering backwards: http://www.cfeclipse.org (http://cfeclipse.tigris.org/servlets/ProjectMailingListList) Try making a file with a .css extension and see if when you open it the css editor doesn't kick in. I've had pretty good luck with that plugin actually. If you're running Mac OSX and want to try out a beta version of the IDE (with that css plugin working) let me know On Sun, 30 Jan 2005 21:35:58 -0500, Michael T. Tangorre [EMAIL PROTECTED] wrote: I have been toying with the CSS pluign (http://csseditor.sourceforge.net/) for a little bit but can not seem to get it to work... it doesn't even show up in the show view window (not even under other. I did confirm that it is in the plugins directory and eclipse sees it via the plugin manager... Any ideas? Is there a better css plugin I should look at? Is there a specific email list for eclipse questions? :-) Thanks Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192297 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
WAP Devices
I'm trying to do some wap programming, and frankly, all i've got is my cell phone, which is fine for using WAPs, but its uncomfortable for testing and debugging (small screen, few colors) and I was wondering if anyone knew of any wap devices with a qwerty keyboard and a sizable screen. I live in the sticks and only get coverage from ALLTEL.. Cingular gets... some coverage so its a last resort but I'd prefer an alltel solution. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192298 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: eclipse css plugin
From: Nathan Strutz [mailto:[EMAIL PROTECTED] To expand on what Rob said, the CSS Editor plugin doesn't have any views or perspecitves associated with it. However, it does make use of the Outline view, which CFEclipse uses as well to make an outline of your code. The editor kicks in right away when you open a .CSS file, assuming your file associations are hooked up right. That's what threw me off... no views or perspectives. Once I opened up a CSS file and started defining some styles it worked like a charm. Thanks guys. Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192299 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFSCHEDULE RSS into DB
Ahh... Scrap this one. Funny thing about sending something to a list--seem to find answers on my own quicker that way. Sorry for the noise. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192300 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: WAP Devices
there are WAP simulators readily available all around the net. Just Google WAP simulator - Original Message - From: Tony Hicks [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Sunday, January 30, 2005 9:05 PM Subject: WAP Devices I'm trying to do some wap programming, and frankly, all i've got is my cell phone, which is fine for using WAPs, but its uncomfortable for testing and debugging (small screen, few colors) and I was wondering if anyone knew of any wap devices with a qwerty keyboard and a sizable screen. I live in the sticks and only get coverage from ALLTEL.. Cingular gets... some coverage so its a last resort but I'd prefer an alltel solution. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192301 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: WAP Devices
The WML extension for FireFox is particularly handy. On Sun, 30 Jan 2005 22:24:30 -0800, Rob Munn [EMAIL PROTECTED] wrote: there are WAP simulators readily available all around the net. Just Google WAP simulator ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192302 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
MS SQL 2000 Table Structure Print out
MS SQL 2000 I want to show a table structure, and tried the following CFQUERY NAME=ShowTable DATASOURCE=PartsList DESCRIBE Pumpparts /CFQUERY This only throws an error Could not find stored procedure 'DESCRIBE'. What am I missing? Or, am I using the wrong thing here? DESCRIBE table_name This command provides information about the columns of the table. It shows the column names, the type / size and scale (if applicable) and other useful information. Thanks, Nick ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192303 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
