Re: Basic mySQL workbench question
Rob, You might want to join this list: http://lists.mysql.com/gui-tools Rob Voyle said the following on 1/3/2011 9:05 AM: I have created a table in mysql and need to modify the column attributes. Using mysql workbench I can create the model and modify the columns but how do I save the changes to the table columns. -- Best regards, Chris Montgomery ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340356 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Embedding Flash Files in CF Page
Jason Fisher said the following on 9/5/2009 11:19 AM: [snip] If it's still not flying, give us a quick overview of the file locations, including the template and the files above, and we'll see what we can see from there. Good luck! Jason, et. al., I did finally get this to work on my local dev box awhile ago by making it simple. I put all of the files (swfobject.js, mediaplayer.swf, my .flv file) in one folder and ran it from there. The flash file loaded and ran fine. The problem I have been encountering with this, and still am, is when trying to fun .flv videos in a site created under the Mura CMS. Per above, when I moved the files outside of Mura's framework on my dev box, as a proof of concept, it worked fine. The next step is to figure out how to get it running under Mura. But at least I know how to get .flv videos to run under CF now. :) Thanks for the help, guys. -- Best regards, Chris Montgomery ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Embedding Flash Files in CF Page
Howdy, I've never worked with Flash files before and now have a need to embed some in a CF page. The files are in .FLV format, not .swf. Is there a quick tutorial on how to do this in CF? I'm on a CF8 server. FWIW, I want to do something like what is on this page: http://www.phantomscreens.com/content/video.php. I need to do this pretty quick so I would greatly appreciate any tips. Thanks! -- Best regards, Chris Montgomery ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326015 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedding Flash Files in CF Page
Jason Fisher said the following on 9/4/2009 6:14 PM: That should get you started ... Thanks, Jason, I'll give it a whirl. I'll need to tinker with it to have it render all six videos (just like the page I cited previously). -- Best regards, Chris Montgomery ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326021 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedding Flash Files in CF Page
Jason Fisher said the following on 9/4/2009 9:00 PM: Yeah, just give each DIV a unique ID, each video gets its own script block, and then make sure that each so.write() method references its matching DIV's ID, and you'll be good to go. Great, thanks for the help! -- Best regards, Chris Montgomery ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326025 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedding Flash Files in CF Page
Well, after trying everything I can think of, this isn't working. Could there possibly be some mime type issues with the .flv files? I'm testing this on my local development box, WinXP Pro, CF8, using the built-in web server with CF. Jason Fisher said the following on 9/4/2009 6:14 PM: Get a copy of swfobject.js from Google Code (http://code.google.com/p/swfobject/) and then get a copy of mediaplayer.swf (can be free, depending: http://www.longtailvideo.com/players/jw-flv-player/). Put this in the head: script type=text/javascript src=js/swfobject.js/script Then put this on your page: div id=player!--- This DIV is where the movie will end up getting written. ---/div script type=text/javascript !-- var so = new SWFObject(swf/mediaplayer.swf, mpl, 360, 280, 8); so.addParam(allowscriptaccess, always); so.addVariable(height, 280); so.addVariable(width, 360); so.addVariable(file, flv/yourMovieFile.flv); so.addVariable(frontcolor, 0x33); so.addVariable(lightcolor, 0x88); so.addVariable(link, flv/yourMovieFile.flv); so.addVariable(volume, 100); so.addVariable(autostart, true); so.addVariable(usefullscreen, true); so.addVariable(showdownload, false); so.addParam(allowfullscreen, true); so.addParam(quality, high); so.write(player); //-- /script That should get you started ... -- Best regards, Chris Montgomery ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326031 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ecommerce emergency
James Holmes said the following on 7/22/2009 9:21 PM: The only sane advice, given those conditions, is to buy a cart product (e.g. http://www.cfwebstore.com/). +1 Well worth the money when you consider the headaches and time it will save. -- Best regards, Chris Montgomery ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324841 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare Two MySQL Databases?
Marie Taylore said the following on 7/14/2009 6:24 PM: What's the easiest quickest way to compare two MySQL Schemas (databases)? Marie, You might want to check out MySQL Workbench: http://www.mysql.com/products/workbench/ Under the Change Management section of that page: To help DBAs and developers with change management, MySQL Workbench includes Schema Synchronization and Comparison utilities. A DBA can compare two live databases or a model and a live database and visually see the differences, and also perform a synchronization between a model and a live database or vice versa. -- Best regards, Chris Montgomery ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion SME
Could be lots of things, including Sloppy Meateaters (band) or Sausage McMuffin with Egg: http://www.acronymfinder.com/SME.html Although I suspect Pranathi's guess that it means Subject Matter Expert is correct. Mark Mandel said the following on 7/8/2009 11:05 PM: Or it could be Subject Matter Expert.. ;o) Guess it depends on context. Mark On Thu, Jul 9, 2009 at 2:05 PM, Mark Mandel mark.man...@gmail.com wrote: Small to Medium Enterprise http://en.wiktionary.org/wiki/SME -- Best regards, Chris Montgomery ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion SME
David McGuigan said the following on 7/8/2009 11:12 PM: PHP developer 2: Eff my life. So, what is the meaning of Eff? (this can go on and on...) -- Best regards, Chris Montgomery ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324375 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Case of Table Names in Queries (MySQL / Linux / CFMX7)
I moved a site from one linux server to another linux server over the weekend. The CF server is MX7. The database for this site is MySQL 5.x and was replicated from the old server to the new server. All database table names are lower case. When running a cfquery on the site after the move, I am getting an error that the table doesn't exist: Error Executing Database Query. Table 'mydatabasename.User' doesn't exist I am confused why the table user is being upper cased. The cfquery statement is (cfqueryparams removed for simplification): cfQuery name=CurrentUser datasource=#request.DSN# select UserID,FirstName,LastName,Login,Password from user where login = '#Trim(Form.Login)#' and Password = '#Trim(Form.Password)#' /cfQuery and the executed SQL is: select UserID,FirstName,LastName,Login,Password from User where login = '' and Password = 'x' As you can see, the table name user is lower case in the cfquery statement but is converted to User when the query is executed. This is where I am confused and don't understand why. The lower_case_table_names system variable on the MySQL server is set to the default value of 0. This is the same way the old server was set up and the query worked fine. Any idea on why this is happening? -- Best regards, Chris Montgomery ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323261 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Calendar Application to Consolidate Many Nonprofit Organizations
I am searching for a calendar application that can manage a consolidated calendar for many nonprofit groups. The main web site (for an animal welfare coalition) would display all events for multiple groups (say, 25-40 animal welfare agencies) and also allow each group to log in and enter/manage their calendar of events. This main coalition site will be developed using CF. The other part of the application would use web services where each nonprofit group would display just their group's calendar of events on their group's web site (which may or may not be CF-based) and also allow them to login at their own web site and enter/manage their group's calendar with the data residing on the main site. I hope that description makes sense. So, is anyone aware of such a beast? I would prefer such an app (if it exists) be written in ColdFusion, but since I'm doing this for free, I guess I can't be too picky. I originally thought to do this using Google calendar but they seem to have a limit on being able to consolidate calendars into one master calendar. Appreciate any ideas. -- Best regards, Chris Montgomery ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322692 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Calendar Application to Consolidate Many Nonprofit Organizations
Hi Alan, Alan Rother said the following on 5/21/2009 4:44 PM: Have you considered (Since your doing it for free) using Google Calendar? Yes, as I mentioned in my original post, but my experience with this, after some experimentation, is that it can't handle importing more than about a half dozen calendars into one master calendar. I'll go back and look at it again, though, since it's been almost a year since I last played with it. Maybe they've bumped up the number of calendars that can be merged into one. Other than that, you could look at the great CF based calendar Ben Nadel built Thanks for the lead, but this app (and others that I've looked at so far) don't seem to have the ability to allow remote sites to display their data or manage their calendar data except by logging into the one site where it's running. I was just fishing to see if any such calendar app exists that would allow this capability. I've not messed with web services yet, so this might be my first leap into the frying pan. :) Cheers. -- Best regards, Chris Montgomery ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anybody out there comtemplating or currently building their own blog?
Rick Faircloth said the following on 1/7/2009 4:09 PM: Ray, how easy is it to customize the look of BlogCFC? Is it just a matter of editing the CSS, or do I have to work with CFLayout, etc. I'm not Ray, but I customized BlogCFC much the same as Ray did on his site (using a template from styleshout.com). It took me several hours to customize, mostly integrating the new template CSS into the structure of BlogCFC. My server is still running CFMX 7 so I had no need to mess with CFLayout, either. I didn't use the calendar component in BlogCFC because it had some layout issues and wouldn't properly fit in the sidebar. I didn't have a lot of time to fool with it and just never went back to fix it. My blog is at http://www.jcmonty.com/index.cfm but I haven't blogged in awhile. I spend too much time fooling with the cats to get much productive work done these days. Off to trap a sick feral cat.. -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What IDEs are folks using?
Neil Ross said the following on 12/8/2008 5:05 PM: I'm curious as to what people are using for IDE of choice these days. Still using CF Studio 5. :) -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JRun Servlet Error After Reinstall of Developer Edition (CFMX7)
James Holmes said the following on 9/18/2008 8:08 PM: CF mappings don't help the built in webserver find your pages. You need to move your files into CF's webroot. Thanks, James. Actually, I was able to get it working the way I want, without moving my site files under the CF webroot location. I did some more digging and found a tech note on how to set up virtual mappings in the E:/Programs/CFusionMX7/wwwroot/WEB-INF/jrun-web.xml file (I had forgotten about this since it was a couple of years ago when I last configured my CF dev server). I was also able to leave the CFIDE files under the CF webroot. Here's what I ended up with in jrun-web.xml: virtual-mapping resource-path/WEB-INF/resource-path system-pathE:/Programs/CFusionMX7/wwwroot/WEB-INF/system-path /virtual-mapping virtual-mapping resource-path/myapps/resource-path system-pathD:/webapps/myapps/system-path /virtual-mapping Sites entered in the browser like this now work: http://localhost:8500/myapps/mysite/ P.S. As to my other issue, enabling RDS fixed the problem with not being able to browse file directories. Cheers. -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312826 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
JRun Servlet Error After Reinstall of Developer Edition (CFMX7)
Ok, I feel like an idiot and must be missing something obvious. I had to reinstall my developer edition of the CF server on my local box (Win XP SP2). Since doing so, I cannot get CF pages to work. When I try to load a page I am receiving a 404 JRun Servlet Error. The sites on my dev box are under the d:\webapps\myapps folder. I have this mapped in CF Admin as /myapps. I configured CF during install to run the built-in web server. So, for example, when I start the CF server and enter http://localhost:8500/myapps/mysite; in the browser address bar, this results in a 404 /myapps/mysite error. If I add index.cfm to the path, I get a 404 File not found: /myapps/mysite/index.cfm error. What am I overlooking? Separately, when attempting to create a mapping, clicking on the Browser Server form button to select a folder path brings up the Select Directory on the Server window to select a folder but after a few seconds it throws up a Server Error message (IO error on server communication). I didn't encounter this problem before reinstalling the CF developer edition on my box. Any ideas? Thanks. -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312773 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Configuring Apache Web Server 2.2.9 and CFMX 7.02
Bump. Still looking for a little help installing the Apache hot fix (wsconfig.jar) on WinXP. Anyone? Thanks. Cutter (CFRelated) said the following on 8/6/2008 11:49 AM: Slightly older Apache, but this might help: http://blog.cutterscrossing.com/index.cfm/2007/1/16/CFMX7-and-Apache-224 Cutter, Thanks for that. To clarify my original post, I guess what I am having difficulty with at this point is installing the new wsconfig.jar connector (downloaded from the cited hotfix web page). This would be Step 2 that you mentioned (go to the command line to 'install' the new connector). The code I previously provided was my attempt to do that but it errored when I ran it at the command line. Does anyone have a working example of code to do this that I can look at and tailor to my local setup? Thanks. -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310896 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Configuring Apache Web Server 2.2.9 and CFMX 7.02
Howdy, I'm having difficulty configuring Apache Web Server 2.2.9 to work with CFMX 7.02 on my local Windows XP dev box. I've attempted to follow the directions for this at http://kb.adobe.com/selfservice/viewContent.do?externalId=8001e97sliceId=2 (under the section ColdFusion MX 7.0.1 or 7.0.2 Server edition) and modified the example code listed in item 5 as follows: [code] e:\programs\cfusionmx7\runtime\jre\bin\java -cp e:\programs\cfusionmx7\runtime\lib -Dtrace.ci=1 -jar wsconfig.jar -server coldfusion -ws apache -dir e:\Programs\Apache2.2\conf -bin e:\Programs\Apache2.2\bin\httpd -script e:\Programs\Apache2.2\bin\apachectl -coldfusion -v [-apxs] [/code] When I run this at the command prompt, I am receiving an error Unable to access jarfile wsconfig.jar. I'd greatly appreciate any hints to troubleshoot this. Thanks. -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310287 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Configuring Apache Web Server 2.2.9 and CFMX 7.02
Cutter (CFRelated) said the following on 8/6/2008 11:49 AM: Slightly older Apache, but this might help: http://blog.cutterscrossing.com/index.cfm/2007/1/16/CFMX7-and-Apache-224 Cutter, Thanks for that. To clarify my original post, I guess what I am having difficulty with at this point is installing the new wsconfig.jar connector (downloaded from the cited hotfix web page). This would be Step 2 that you mentioned (go to the command line to 'install' the new connector). The code I previously provided was my attempt to do that but it errored when I ran it at the command line. Does anyone have a working example of code to do this that I can look at and tailor to my local setup? Thanks. -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310292 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Beyond Captcha
Tom Chiverton said the following on 2/8/2008 3:41 AM: At the end of the day, it's an arms race, and right now I don't see a way to defeat the current man-in-the-middle-offering-free-porn work around. Frankly, I think we users / developers spend way too much time trying to one-up the lowlife spammers. Instead, we should quit wasting time, re-channel our energies, grab some baseball bats, and start hunting the bastards down and beat the livin' crap out of 'em! -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298562 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Translating MSSQL Scripts into MySQL Scripts
Rick Faircloth said the following on 2/4/2008 12:53 PM: Can anyone recommend a program that will translate MSSQL scripts into MySQL scripts? I found some on Google. couldn't find a way to do it on mysql.com. Before I try a program to do this, I thought I'd get some recommendations from those of you with experience at this. I can create the database/tables manually, but I sure would like to save some time! Rick, Have you tried using the MySQL Migration Toolkit from MySQL's site? (http://www.mysql.com/products/tools/migration-toolkit/) I have used it to convert a couple of MS Access databases to MySQL but haven't tried it yet on MS SQL Server. The tutorial is at http://www.mysql.com/products/tools/migration-toolkit/tutorials/migrate-sql-server.html -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL Comparison Tool
Gerald Guido said the following on 2/1/2008 12:38 PM: MysqlYog Enterprise has some pretty amazing DB sync utilities. It ever writes the SQL to sync up the table structure. http://webyog.com/en/ This is what I use and I've been very happy with it so far. -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297950 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Viviotech Outage
toby dagenhart said the following on 1/4/2008 2:35 PM: I've tried every number I have. What phone numbers do you have? I don't have any for Viviotech and wanted to call to see what's up but, of course, their site is down so I can't go look up their phone numbers. :( -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295896 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Viviotech Outage
Aaron Roberson said the following on 1/4/2008 3:01 PM: I'm not getting that, I'm still getting no connection... -Aaron On Jan 4, 2008 12:42 PM, toby dagenhart [EMAIL PROTECTED] wrote: Their site is showing an internal server error now instead of no connection, so maybe they are making progress. And I'm getting a Server not found error. -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF forums
Yves Arsenault said the following on 12/17/2007 2:09 PM: There is also : FuseForum (Kevin Roche) http://fuseforum.riaforge.org/ I've never used FuseForum. I haven't either but I did just download the code for it since it's done in Fusebox 5.1 and I'm interested in seeing how others handle login/security in FB 5+ apps. I may have missed it, just took a quick peek at the code, but it didn't look to me like it had any login/security enabled. Maybe I just didn't see it? -- Best regards, Chris Montgomery ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294945 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Online Form Creation?
Terry said the following on 9/8/2007 9:34 AM: Has anyone seen a CF open source way to allow your clients to roll their own forms for their site? I haven't had any luck finding an example. Terry, Would something like this work? http://fbx_formbuilder.riaforge.org/ -- Best regards, Chris Montgomery ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What application platform is this? Could it be CF
[EMAIL PROTECTED] said the following on 8/23/2007 3:56 PM: If someone has a link structure on their site of ... www.site.com/omapps/ContentServer?cid=1058290118806pagename=InvestorRelations%2FPage%2FIR_Standardc=Page What application platform is this? The CID looks like it could be Coldfusion. Any thought? Hard to tell but it looks like a content management system that lots of insurance companies are using. The CID appears to be an identifier for a block of content, probably pulled from a database, but I don't see a direct relationship to CF there. -- Best regards, Chris Montgomery ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287003 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: slideshow application
Ray Champagne said the following on 8/16/2007 10:55 AM: I have the need for a slideshow application. My needs are pretty basic. It needs to: Ray, I have almost exactly the same needs except, for me, money DOES matter. I'm looking to implement this on a couple of nonprofit sites for which I don't get compensated. I'd appreciate it if you could keep us informed what you find in your search. Cheers. -- Best regards, Chris Montgomery ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286381 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Client
OÄuz_Demirkapı said the following on 7/23/2007 11:29 AM: Do you have any MySQL client suggestion? I have MySQL 5.x and I need a solution which also supports Unicode. I use SQLyog: http://www.webyog.com/en/ -- Best regards, Chris Montgomery ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284382 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Editor
Wil Genovese said the following on 6/26/2007 1:02 PM: I only trust in the power of God, not the power company. Save Early, Save Often! Or get a UPS. Has saved my butt more than once when the power suddenly went out. -- Best regards, Chris Montgomery ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282274 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Good SSL Provider
Robert Rawlins - Think Blue said the following on 6/21/2007 12:12 PM: I'm looking for an SSL provider at the moment and I'm kind of open to suggestions, the more secure the better, obviously. However, I don't want to pay through the nose for it if possible. Rob, By provider I assume you're looking for a place to purchase SSL certificates? If that's the case, I recently purchased a RapidSSL cert here for $14.95: http://www.theplanet.com/hosting-products/ssl/ -- Best regards, Chris Montgomery (`-''-/).___..--''`-._ `6_ 6 ) `-. ( ).`-.__.`) (_Y_.)' ._ ) `._ `. ``-..-' _..`--'_..-_/ /--'_.' ,' (il),-'' (li),' ((!.-' ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281817 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL - need auto increment back to 0...
Will Tomlinson said the following on 5/13/2007 9:11 AM: Thanks Neil! I ended up finding TRUNCATE TABLE with your search. Seemed to do the trick. In addition to what others have said, some of the MySQL GUI programs will let you reset the autoincrement numbering fairly easily. For example, I use SQLYog and have done this several times using the Advanced Properties button under the Alter Table (F6) window. I believe Navicat also has a similar feature although I haven't used Navicat much. -- Best regards, Chris Montgomery ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277997 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Features, Tags, Etc. on Linux
Howdy, I am considering moving some CF sites that are currently hosted on Windows shared hosting servers to a Linux hosting environment. My question is, which features of CF (CFMX 7, specifically) are not available on Linux platforms? Note that this is not intended to be a Linux vs Windows debate. I am interested in knowing only what features, tags, etc. that aren't available if I decide to move to a Linux hosting environment. Thanks! -- Best regards, Chris Montgomery ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277284 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Querying Using List Input To Field
Howdy,
I'm having a bit of a brain fart trying to figure this out. I want to
join four tables to find a user/volunteer that is assigned to
categories, pulling out all categories they are in based on a list of
IDs coming from a form submission.
Here's what my tables look like:
vols_volcat
===
VolCatID (smallint)
VolunteerID (smallint)
volcategories
=
VolCatID (smallint)
VolCategory (varchar)
volunteers
==
VolunteerID (smallint)
UserID (smallint)
users
=
UserID (smallint)
FName (varchar)
Lname (varchar)
The formfield being passed into the action page will contain one or more
IDs from a multiple select list (in my test case, form.VolCatID =
6,7,15,16).
Here's two queries that I've tried. There is one volunteer listed in the
vols_volcat table (volunteerID = 4) that matches all four IDs in
form.VolCatID passed in, but the query is returning only the first match
for VolCatID (6). I suspect the problem is that I'm using the IN
clause in the WHERE statement (where it stops after matching the first
number in the list). I need to grab all VolCategory fields the volunteer
matches.
1st query:
SELECT
volcategories.volcategory,
volunteers.volunteerID,
users.userid,
users.fname,
users.lname
FROM
volcategories
Inner Join vols_volcat ON vols_volcat.VolCatID = volcategories.VolCatID
Inner Join volunteers ON volunteers.VolunteerID = vols_volcat.VolunteerID
Inner Join users ON volunteers.UserID = users.UserID
WHERE vols_volcat.VolCatID IN ('#form.VolCatID#')
2nd query:
select
volcategories.volcategory,
volunteers.volunteerID,
users.userid,
users.fname,
users.lname
from
vols_volcat, volcategories, volunteers, users
where
vols_volcat.volcatID = volcategories.volcatID AND
vols_volcat.volunteerID = volunteers.volunteerID AND volunteers.userID =
users.userID AND vols_volcat.volcatID IN ('#form.VolCatID#')
I'm thinking there needs to be a loop somewhere in there to loop over
the form.VolCatID list being passed in, but can't get my head around it.
Any help would be appreciated.
Using CFMX 7 on local Windows dev box and MySQL 5.x
Thanks.
--
Chris Montgomery
Airtight Web Services http://www.airtightweb.com
Web Development, Web Project Management
210-490-2415 (office), 210-232-2790 (mobile)
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269578
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Querying Using List Input To Field
Peter Boughton said the following on 2/12/2007 4:16 PM: Take the single quotes out. That did it, thanks. Better still, use CFQP... WHERE vols_volcat.VolCatID IN (cfqueryparam value=#form.VolCatID# cfsqltype=CF_SQL_INTEGER list=true/) Yeah, I usually go back and add those after I get things working properly. Just wasn't there yet. Thanks, Peter. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management 210-490-2415 (office), 210-232-2790 (mobile) ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269601 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FireFox 2 Download help
Ben Nadel said the following on 10/25/2006 8:30 AM: Hey all, I keep trying to download FireFox 2, but the link never works: http://mozilla2.mirrors.tds.net/pub/mozilla.org/firefox/releases/2.0/win 32/en-US/Firefox%20Setup%202.0.exe Does this work for anyone else? Is there somewhere else I can download this? It might be better to ask this in the Firefox support forum: http://forums.mozillazine.org/viewforum.php?f=38 FWIW, the following link, placed at the top of the Mozilla home page, seems to work: http://www.mozilla.com/products/download.html?product=firefox-2.0os=winlang=en-US -- Chris Montgomery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257991 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Training Resources in Florida
Howdy, A project manager friend of mine just got hired at a Florida government IT position. Their shop uses ColdFusion and the developers there are in need of professional level CF training and he contacted me asking about resources for CF training. Their location is in Tallahassee. Is anyone aware of CF training resources in that area? Thanks. -- Chris Montgomery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254217 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Project Management Software
Chad McCue said the following on 8/17/2006 7:25 AM: Does anyone currently use a windows based software program that tracks the life a project and can also handle daily time sheets for employees so an administrator can track what each employee does all day. Don't know if this will fit your needs, but may be worth checking out: http://www.openworkbench.org/ -- Chris Montgomery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Configuring Built-in Web Server Question
Thanks, Larry and James. I think those links will help me. Cheers. -- Chris Montgomery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247411 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Configuring Built-in Web Server Question
My dev box environment: CFMX 7.02 Enterprise (Dev Version) Running the built-in server config (ex: http://localhost:8500/app_root/) Windows XP Pro Until recently, I had CF 5 and CFMX7 installed and running separately on my local dev box. The other day, I uninstalled the CF5 server and now am running only the CFMX7 developer version. I can't figure out how to set up the web server so that I can have my applications outside of the webroot (currently at E:\Programs\CFusionMX7\wwwroot). I would like to have my web applications at E:\webapps and configure the built-in web server to run them there (like I did with CF5). Any help appreciated. Thanks. -- Chris Montgomery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247327 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Configuring Built-in Web Server Question
Steve Brownlee said the following on 7/21/2006 3:16 PM: Give this a shot, guys. Email me with any questions http://www.orbwave.com/cfjboss/2005/02/coldfusion-from-anywhere.html Thanks, Steve, but I really don't want to reinstall the CFMX server with the J2EE installation. I'm interested in finding a solution (if there is one) to use the built-in web server configuration. Cheers. -- Chris Montgomery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247397 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: shopping cart integration
Rick Faircloth said the following on 7/15/2006 1:33 PM: Sounds like this might work ok for my client who wants to have renters make monthly rental payments, but a more robust system might be called for with a regular shopping cart. It would be a pain to have to leave a site to check a shopping cart, then go back to the merchant site. It's too bad there's not a way to use a PayPal shopping cart integrated into my own pages... You might want to check out PayPal's Website Payments Pro. It's a fairly new offering from PayPal and it may do what you want. Customers don't leave your web site. From what I can tell, it doesn't require you to have a credit card merchant account or to have to use a separate payment gateway system like Authorizenet. All for $20/month (which is quite a bit cheaper than paying monthly fees for your credit card merchant account and payment processor). Note: I haven't used it yet, but it looks promising for those wanting to integrate a credit card processing system into their shopping cart and get up and running quickly. https://www.paypal.com/cgi-bin/webscr?cmd=_wp-pro-overview-outside There's also a new solution from Google, Google Checkout, that offers an API for integrating it into an e-commerce site: https://checkout.google.com/sell?promo=sbhp Again, I have no experience with this and only heard about it recently. Hope that helps. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management 210-490-2415 (office), 210-232-2790 (mobile) ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246665 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Studio Edits Not Being Saved?
RADEMAKERS Tanguy said the following on 7/12/2006 9:16 AM: check the list archives, or check their (Zone Alarm) web site - i don't know anything about this firsthand, just remembered that somebody else had this problem recently. Happy. Googling. The problem I was having indeed appeared to be with ZoneAlarm Pro. Here's a thread I found that provided some background: http://tinyurl.com/o3us4 I *was* running the latest version of ZA and that's when the problem showed up (after a recent upgrade). Anyway, I removed ZA and am now running the Comodo Personal Firewall (beta version - the latest stable was crashing too often). For now, I should at least be able to get some productive work done (after battling this silly problem for four days). And since I uninstalled CFStudio in the process of troubleshooting, and my fledgling attempts to try HomeSite didn't work, it looks like CFEclipse is my editor of choice for the time being. Cheers. -- Chris Montgomery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246439 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Studio Edits Not Being Saved?
Howard Owens said the following on 7/12/2006 7:41 AM: Are you doing local saves, or remote (FTP) saves? Local saves only on my dev box. I've found that Studio will stop saving sometimes on FTP edits. It takes a restart to get it saving again. Usually, this happens if I use any kind of search and replace over FTP. I've never had the problem on a local file. I've never used Studio for FTP edits, always used an external FTP program to upload my edited files to the remote server. Been using CF Studio for years and this is the first time I have experienced a problem like this. I may try a reinstall tomorrow (just the basic version 5) and see if that works. If it does, I'll install the version 7 updater files and see what happens. Thanks. -- Chris Montgomery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246230 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Studio Edits Not Being Saved?
This is weird. Just playing around, I installed CFEclipse, edited a .cfm file, reloaded it in my browser and the edits don't show up. I tried it again, this time editing/saving in UltraEdit, reloaded the file in my browser and it shows the edits just fine! What the hey? -- Chris Montgomery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246232 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Studio Edits Not Being Saved?
RADEMAKERS Tanguy said the following on 7/12/2006 4:55 AM: Last person to have this problem, it was due to a bug with firewall software (Zone Alarm?) blocking a change to the file update timestamp: the file was changed, but since the update time wasn't changed, the server didn't reload it. Hmm, that could be it. I am running ZA for my firewall. Any idea where I can find out more on this issue to resolve it? Thanks. -- Chris Montgomery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246260 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Studio Edits Not Being Saved?
I was talking with another developer today, trying to troubleshoot a CF application. During our conversation, when everything we tried was failing, he suggested that CF Studio might not be saving my file edits. After some experimentation, I have verified that he appears to be correct. Edits saved in CF Studio don't seem to be getting saved (although they show up in the file when I open it in UltraEdit32). If I make another edit to the file with UltraEdit32 and save it again, the edits DO show up when I reload the affected page in my browser. (I suspect this behavior might also be true for other text editors, e.g. WordPad). I am using CF Studio 5 with the updates for CFMX 7 running in WinXP. I ran the updater (it is actually for Homesite +) recently and this is the first time I've noticed any problem with edited files not loading after they were edited and saved in CF Studio. Has anyone else noticed this oddity? If so, is there a fix for it? Thanks. -- Chris Montgomery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246222 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Major cities around the world
Carlos A said the following on 6/26/2006 4:24 PM: I'm looking for a service that will provide a database containing 200-300 countries with a related table containing the major states (I know other countries do not necessarily refer to them as states) for each country. I've purchased the Globixdata product but it has just under 3 million states! United States has over 180,000 state entries alone. I have a country select list that will dynamically populate a state select list based on the country selected. I plan on using ajaxCFC to accomplish this. Any info the list can provide will be greatly appreciated. This isn't exactly what you want, but the CIA World Factbook might be useful: http://www.cia.gov/cia/publications/factbook/index.html -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management 210-490-2415 (office), 210-232-2790 (mobile) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244869 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: Dynamically Sort HTML Tables
-Original message- From: Daniel Mackey [EMAIL PROTECTED] Date: Mon, 24 Oct 2005 13:02:35 -0400 To: CF-Talk cf-talk@houseoffusion.com Subject: Re: Dynamically Sort HTML Tables Try this one: http://webfx.eae.net/dhtml/sortabletable/sortabletable.html Thanks, I'll check this out tonight after work. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 (office), 210-232-2790 (mobile) ~| 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:222115 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
Trouble Ticket Application
I've been working on building a system for logging help request calls for our nonprofit organization. It dawned on me that I'm reinventing the wheel and that what we need is a help desk/ticket tracking system that could be adapted to our specific needs. Since this will come out of my hide (time), I'm wondering if there are any free / open source help desk/ticket systems already out there. One that is developed in CF would be better than some other language, but I'm going to be practical and open-minded about it. Thanks in advance if you know of any such apps that exist. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 (office), 210-232-2790 (mobile) ~| 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:222116 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: Any Interest in a Completely Free CFML Calendar?
Jordan Michaels said the following on 10/14/2005 4:28 PM: For some time now, Vivio Technologies has been debating whether or not to put forth the effort to complete the development of a completely free, (under a modified open-source MIT license) CFML calendar application. The idea was to develop a calendar application that anyone could do anything they want with, and help support the Cold Fusion community as a whole. Companies who develop in CFML would have the ability to -re-design, re-code, -re-brand, re-sell, or whatever else they wanted to do with the calendar application. The calendar would be able to run under BlueDragon FREE edition, and use open-source databases like PostgreSQL and MySQL. That way, no user anywhere would need to pay for anything more then the cost of hosting in order to deploy the calendar. Our question is simple: Would there be any interest in something like this? [snip] I would definitely be interested. I have a couple of nonprofit sites that I would like to use it on and it would save me loads of time. Any idea when the downloads might be available? Thanks. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 (office), 210-232-2790 (mobile) ~| 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:221939 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 Studio Updater for MX 6.1
HOFLee _ said the following on 9/23/2005 7:25 PM: Do you mean these? From MX6.1 home page http://www.macromedia.com/software/coldfusionmx61/downloads/ Macromedia HomeSite+ (ColdFusion Studio) Tag Updater http://download.macromedia.com/pub/coldfusion/tag_updates/HomesiteTags.zip http://download.macromedia.com/pub/coldfusion/tag_updates/HomeSiteExtensions.zip Yes, thanks much. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 (office), 210-232-2790 (mobile) ~| 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:219210 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Embedding ASP Code into CF Form Page
S. Isaac Dealey said the following on 3/30/2005 5:54 PM: Yea, that's the catch -- the CF compiler doesn't have any server-side ecmascript (i.e. runat=server) implementation and even if it did I'm guessing the rest of that server-side javascript code references ASP-specific objects (as an example [which won't appear in that script I'm sure] connecting to ADO for database access). One way or another it basically means completely rewriting the script to use it within CF -- hence the need for cfhttp. Well, my efforts so far have been futile. I haven't been able to get anything returned in the cfhttp.filecontent variable. The other cfhttp variables are all returning something, just not filecontent. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 (office), 210-232-2790 (mobile) ~| 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:200897 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 Hosting - unfair - a suggestion
Sunday, April 11, 2004, 11:20:26 PM, Doug White wrote: Doug == Stop spam on your domain, Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == If everyone who hosts would do what Doug just did, i.e., put a simple reference to their hosting business in their sig, then I think that would solve the problem. A web URL like that is relatively unobtrusive and it doesn't get in your face. Now if we could get Doug to start using a cut line. :) (just kiddin', Doug!) Cheers. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Email Not Being Sent from Local Server (CF5)
Howdy, Since migrating to a new computer a couple months back, now running Win XP Pro with CF version 5, I can't get any mails generated with the cfmail tag to leave the local server. They keep getting stuffed in the cfusion/mail/UnDelivr folder. I've tried using 127.0.0.1 and my regular SMTP mail server for my ISP (which used to work on the old machine). Any ideas on what I can check? It ain't critical, but it's very annoying when developing/testing pages that need to send emails and they won't go. Thanks! -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Email Not Being Sent from Local Server (CF5)
Howdy Jochem, Friday, April 9, 2004, 2:09:34 PM, Jochem van Dieten wrote: mail.log Ok, so this is saying that authentication is required. I didn't have this problem when I was running Win2k, but anywayif I check the box for Verify Mail Server Connection in CF Admin, I get the message ColdFusion connected to your server. Verification completed without error. I don't understand what's happening. Also, how does one provide authentication data for the mail server...I am not seeing a way to enter that anywhere. Like I said, sending mail from the local dev box wasn't a prob before I moved to Win XP Pro. Thanks. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Looking Up Issues on MM Site
Howdy Jochem, Monday, December 1, 2003, 3:30:14 PM, Jochem van Dieten wrote: You don't. You know the number if you filed the bug. So if you want to review past issue/bug reports to see if anyone has already filed one before you want to file one, then you're out of luck? Must lead to lots of dupe reports, no? -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Looking Up Issues on MM Site
Howdy, Tuesday, October 28, 2003, 2:17:51 PM, Jochem van Dieten wrote: Don't forget to fill out the wishform on the Macromedia website. mmdd has been the ISO standard way of writing a short date since before ColdFusion existed, and it is about time that that standard is supported. issue #49751 How the heck does one look up issues on Macromedia's site? I tried searching for the above issue number and got no hits. Is there a search form just for looking up issues? Thanks. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Different Results on Two Servers (CF5, MS Access)
Thursday, November 20, 2003, 9:42:04 AM, Chris Montgomery wrote: I have an interesting situation. Running a test page against the same data (copied the database from remote server to local server on my dev box), I am getting different results. Both CF servers are version 5 (Enterprise on my dev box, Pro on the hosted server) and the database is MS Access 2000. [snip] No ideas what could cause this? Thanks. -- Chris Montgomery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Different Results on Two Servers (CF5, MS Access)
Howdy Bryan, Friday, November 21, 2003, 10:46:24 AM, Bryan F. Hogan wrote: What is the data and what is different about it between servers? Explained in my original post: http://www.houseoffusion.com/cf_lists/index.cfm?method=messagemessageID=144657forumid=4 -- Chris Montgomery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Different Results on Two Servers (CF5, MS Access)
Howdy Bryan, Friday, November 21, 2003, 11:11:32 AM, Bryan F. Hogan wrote: Could it be that the remote server has only patch 2 installed? I assume you mean the operating system? Actually, that's my local server. For reasons I can't remember at the moment, I've not wanted to install Win2k service pack 3. Is it possible that this would cause the difference in results? Or would having CF5 Pro on the hosted site and CF5 Enterprise server locally cause different results? Thanks. -- Chris Montgomery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Different Results on Two Servers (CF5, MS Access)
Howdy Bryan, Friday, November 21, 2003, 11:47:14 AM, Bryan F. Hogan wrote: Most likely there is some sort of bug that was corrected in patch 3 that effects your results. The different versions I very much doubt is the problem. Install patch 3 and see if your local copy looks like your remote copy. Interesting. I did install Win2k SP3 on my local box and it did, in fact, give me the same results as on the remotely hosted server. What apparently was tripping me up was the cfqueryparam in the query. I had: cfquery name=GetAppts datasource=#request.dsn# SELECT ApptTime, ApptLength FROM Reservations WHERE EventID = #eventID# AND ApptTime = cfqueryparam value=#steptime# cfsqltype=CF_SQL_TIMESTAMP /cfquery Changing the cfsqltype to CF_SQL_TIME fixed the problem and gave me the correct results on both servers. Thanks, Bryan, for guiding me through this. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Different Results on Two Servers (CF5, MS Access)
Howdy, I have an interesting situation. Running a test page against the same data (copied the database from remote server to local server on my dev box), I am getting different results. Both CF servers are version 5 (Enterprise on my dev box, Pro on the hosted server) and the database is MS Access 2000. Server info (remote): Server.ColdFusion.ProductName -- ColdFusion Server Server.ColdFusion.ProductVersion -- 5, 0, 0, 0 Server.ColdFusion.ProductLevel -- Professional Server.OS.Name -- Windows NT Server.OS.AdditionalInformation -- Service Pack 3 Server.OS.Version -- 5.0 Server.OS.BuildNumber -- 2195 Server info (local): Server.ColdFusion.ProductName -- ColdFusion Server Server.ColdFusion.ProductVersion -- 5, 0, 0, 0 Server.ColdFusion.ProductLevel -- Enterprise Server.OS.Name -- Windows NT Server.OS.AdditionalInformation -- Service Pack 2 Server.OS.Version -- 5.0 Server.OS.BuildNumber -- 2195 The results I get against the test data are: Local dev box: 11:00 AM - Filled 11:35 AM - Filled 12:10 PM - Filled 12:45 PM - Filled 01:20 PM - Filled 01:55 PM - Filled 02:30 PM - Filled 03:40 PM - Filled send email, no open time slots Remote server: 11:00 AM - Open 11:35 AM - Filled 12:10 PM - Filled 12:45 PM - Filled 01:20 PM - Filled 01:55 PM - Open 02:30 PM - Open 03:05 PM - Open 03:40 PM - Open Open And the code in the test template: [begin code dump] cfset breaklength = 10 cfset sessionlength = 25 cfset openAppts = False cfset EventID = 43 cfquery name=GetEvents datasource=#request.dsn# dbtype=ODBC SELECTStartTime, StopTime FROM Events WHERE EventID = #eventID# /cfquery cfset steptime = getevents.starttime !--- loop over appt times --- cfloop condition=DateCompare(StepTime, getevents.StopTime) LT 1 cfquery name=GetAppts datasource=#request.dsn# SELECT ApptTime, ApptLength FROM Reservations WHERE EventID = #eventID# AND ApptTime = cfqueryparam value=#steptime# cfsqltype=CF_SQL_TIMESTAMP /cfquery !--- if appttime not empty --- cfif GetAppts.RecordCount cfoutput#TimeFormat(stepTime)#/cfoutput - Filledbr !--- if apptlength equals sessionlength --- cfif getappts.apptlength EQ sessionlength !--- increment steptime (session.breaklength + session.sessionlength --- cfset steptime = DateAdd(n, (breakLength + SessionLength), steptime) /cfif !--- if apptlength gt sessionlength --- cfif getappts.apptlength GT sessionlength cfset ApptEnd = DateAdd(n, (getappts.apptlength + breaklength), getappts.appttime) cfloop condition=DateCompare(StepTime, ApptEnd) LT 0 !--- increment steptime (session.breaklength + session.sessionlength --- cfset steptime = DateAdd(n, (breakLength + SessionLength), steptime) /cfloop /cfif !--- else, appt time slot is empty --- cfelse !--- check to see if next appt time would extend beyond event stop time; if so, break out of loop and don't show time slot --- cfif getevents.StopTime LT DateAdd(n, sessionLength, steptime) cfbreak cfelse cfset OpenAppts = True cfoutput#TimeFormat(stepTime)#/cfoutput - Openbr !--- increment steptime --- cfset steptime = DateAdd(n, (breakLength + SessionLength), steptime) /cfif /cfif /cfloop !--- end loop over appt times --- cfif OpenAppts Open cfelse send email, no open time slots /cfif [end code dump] Can anyone tell me why the results returned from executing the above code would be different on the remote server vs my local box? This has me scratching my head. Thanks. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: HTML a title help
Monday, November 17, 2003, 2:57:24 PM, Richard Crawford wrote: The reason why Netscape (and other Mozilla-based browsers) won't do tooltips via the title attribute of the anchor tag is that the title attribute is NOT a part of the HTML specification. I haven't installed Netscape since about version 4.79, but my anchor tags DO display tooltips from the title attributes in Moz/Firebird 0.61. I believe they were also doing that in Moz version 1.3/1.4 before I switched exclusively to Firebird. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Compensating for Server Time
Howdy, What's the best way to compensate for time on a server in a hosted environment when the time is set to a different time than a user's local time zone? Ex: client is in Central Time, server is on Eastern Time (one hour ahead); client wants everything to reflect local time. Thanks. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Compensating for Server Time
Sunday, November 16, 2003, 2:55:11 PM, Jochem van Dieten wrote: I use the AT TIME ZONE functionality from SQL, it even compensates for daylight savings time... Thanks Jochem, Tony, Tim, Novak, et. al. I'll look into your recommendations. I should have clarified the situation a bit more, however. The database is MS Access (for now; will probably upsize to MS SQL server soon). I want to keep this is simple as possible (because I'm a simple person). I am going to assume that the user's time zone is always local because my client's business is local. So, in effect, I need only subtract one hour from the server's time for any transaction (storing appointment times, mainly). I guess I could set this as a constant in a request variable in the application.cfm file and then use that for the current time from then on. Would that seem feasible? Cheers. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Compensating for Server Time
Howdy Tony, Sunday, November 16, 2003, 3:49:51 PM, Tony Weeg wrote: there is a great little cfc @ cfczone.org Ooops, forgot to mention: this is on CF5/Windows. I'll take a look at the CFC anyway, might give me some good tips. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Compensating for Server Time
Looks like LocalTime() at cflib.org might be just what the doctor ordered ( http://www.cflib.org/udf.cfm?ID=719 ). Gonna give it a try. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Compensating for Server Time
Sunday, November 16, 2003, 6:14:47 PM, Chris Montgomery wrote:
LocalTime() at cflib.org
This UDF uses cffunction, which I guess is an MX tag. I converted Chad
Jackson's UDF to be compatible with CF5 (in case anyone else wants it).
Note that the offset is for Central Daylight Time (-6).
!---
Function that returns adjusted local server time.
@return Returns a date object.
@orignal_author chad jackson
@author chris montgomery
@version 1, September 24, 2002
@version 2, November 16, 2003 (CF5)
---
cfscript
function LocalTime()
{
var timeZoneInfo = GetTimeZoneInfo();
// local time GMT offset.
var offset = -6;
var GMTtime = DateAdd('s', timeZoneInfo.UTCtotalOffset, Now() );
var theLocalTime = DateAdd('h',offset,GMTtime);
return theLocaltime;
}
/cfscript
pThe date/time on the server is: cfoutput#now()#/cfoutput/p
pThe local date/time is cfoutput#Localtime()#/cfoutput/p
Cheers.
--
Chris Montgomery
Airtight Web Serviceshttp://www.airtightweb.com
Web Development, Web Project Management, Software Sales
210-490-2415
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
OT: Macromedia software ready for Linux (Articles)
Howdy, Codeweavers announces support for developing with Macromedia Dreamweaver MX and Flash MX under Linux: http://news.com.com/2110-7344_3-5098169.html http://www.osviews.com/modules.php?op=modloadname=Newsfile=articlesid=358mode=threadorder=0thold=0 -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Web Discussion: ASP.net vs. Cold Fusion (sic)
Howdy, Just saw this: http://www.webproworld.com/viewtopic.php?t=7446 -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Studio 5 Character Entities for XHTML
Anyone? Thursday, September 25, 2003, 12:49:35 PM, Chris Montgomery wrote: I'm still using CF Studio 5. These days, I'm working on XHTML sites and have a question about character entities in Studio. By default, the View toolbar in Studio has a button for Extended and Special Characters (it's the Omega symbol, looks sorta like a horseshoe hanging from a nail). If, for example, I want to insert a double quotation mark in a template, clicking on the above button and then clicking again on the double quote mark enters quot; in the template. Using XHTML, I would rather have it enter #34; . Same for all of the other extended and special characters. Does anyone know if it's possible to edit the extended character set that this button uses to enter them in templates? Thanks. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Studio 5 Character Entities for XHTML
Howdy Douglas, Monday, September 29, 2003, 2:43:36 PM, [EMAIL PROTECTED] wrote: look at Options Settings Markup Languages HTML/XHTML There is a setting there that looks like what you are looking for. Thanks. I've already checked all of the options for this setting but it still doesn't address the special and extended characters. I've pretty much decided that I'll have to do this manually. Cheers. -- Chris Montgomery Airtight Web Serviceshttp://www.airtightweb.com Web Development, Web Project Management, Software Sales [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Studio 5 Character Entities for XHTML
Howdy, I'm still using CF Studio 5. These days, I'm working on XHTML sites and have a question about character entities in Studio. By default, the View toolbar in Studio has a button for Extended and Special Characters (it's the Omega symbol, looks sorta like a horseshoe hanging from a nail). If, for example, I want to insert a double quotation mark in a template, clicking on the above button and then clicking again on the double quote mark enters quot; in the template. Using XHTML, I would rather have it enter #34; . Same for all of the other extended and special characters. Does anyone know if it's possible to edit the extended character set that this button uses to enter them in templates? Thanks. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 ~| ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803 Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138488 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Dupes From List
Howdy, Anyone else receiving dupes on this list? Since switching to text-only format yesterday, I'm getting two copies of every message. Even unsubscribed and re-subscribed. Regards. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 OpenOffice.org 1.1 Works Great! Costs Less ;-) http://www.openoffice.org ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138344 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 ColdFusion MX 6.1, now 2.5 times faster. http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803
Re: MX Hosting Site recommendations
Howdy Andy, Tuesday, September 23, 2003, 1:07:07 PM, Andy Ousterhout wrote: I am looking for a new host for my MX with Access site. Any recommendations? http://www.clickdoug.com -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 OpenOffice.org 1.1 Works Great! Costs Less ;-) http://www.openoffice.org ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138209 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Adding Time to a Date
Howdy, Having a major brain fart here... If I have a date (say, 9/15/2003) and a time (say, 8:00 AM), how do you put the two together? In pseudocode, something like this: cfset myDateTime = myDate + myTime Thanks. -- Chris Montgomery ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: Adding Time to a Date
Howdy Matt, Saturday, September 13, 2003, 11:34:05 PM, Matt Robertson wrote: Assuming two different fields each hold date and time: cfset myDateTime=DateFormat(myquery.mydatefield,mm/dd/) TimeFormat(myquery.mytimefield,hh:mm:ss) Again, assuming you want to apply formatting masks to each. If you don't, then just cfset myDateTime=myquery.mydatefield myquery.mytimefield Thanks, Matt. Superb response, as usual. That's it. I'm done for the day. Time to see whats left in the liquor cabinet. Wish I could say the same, still working here. :) -- Chris Montgomery ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Quick CFQueryParam Question
Howdy, When using the CFQueryParam tag to insert string form values (cfsqltype=CF_SQL_VARCHAR), does this automatically Trim the value? Thanks. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: Airtightweb ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
AccessMonger - Anyone Using It?
Howdy, Is anyone using AccessMonger? I have an issue with getting it to work the way I want and am unable to reach the author. If you use it I would like to ask you a question. Thanks. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: AccessMonger - Anyone Using It?
Howdy Matt, Wednesday, September 10, 2003, 7:27:14 PM, Matt Robertson wrote: You're unable to reach me? I haven't seen anything come my way from you. Feel free to email me directly with questions. I have, three times. :) Worst-case, my spam filters are dinging you for some reason. I figured you got tired of my questions and just blacklisted me. Heh. If you email me and hear nothing then just use the contact us form on my site. I'll try that, thanks! -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 OpenOffice.org 1.1 WORKS GREAT! Costs less ;-) ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Appointment Times, Dates Scheduling Issues - Best Practices?
Howdy, I recently took over a CF 4.51 site and am in the process of redesigning it for a client. Database is MS Access. The site is for a massage company that lets corporate clients sign up for on-site massages. Administrators can print copies of the day's on-site massage appointment schedule for massage therapists to take with them to a client's site. Anyway, I'm wondering about the best way to handle building the appointment schedules. The way it is right now, a day's schedule of appointments is created by looping over an event (a date/location) and then an inner loop hits the database for each time slot and builds the appointment/schedule table. There are only about 20 appointment slots per event schedule, but this doesn't seem very efficient to me. For those of you who've worked with building date/time schedules, would it make more sense to convert to using arrays or structures for something like this? I can show representative blocks of code the way it is right now if necessary. Thanks in advance for your thoughts. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: Airtightweb ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CSS guidelines
Howdy Dave, Thursday, August 21, 2003, 12:17:48 PM, Bosky, Dave wrote: What's the difference between using a class inside a table cell tag and using a span tag in a table cell? Something like: td class=myClass/td tdspan class=myClass/span/td I believe the difference is in the first case you are applying your class to a block level element (td) whereas in the latter case the span makes it an inline element. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: MM Exchange lack of proper nav Suggested Design Change
Thursday, August 7, 2003, 11:42:02 PM, Rafael Bleiweiss wrote: I ask what the odds are because if the handful of us who have posted in the past couple days all feel similarly regarding not just the Back functionality, how many other developers out there feel the same way and haven't spoken out? [raising hand] I would have to agree with just about everything Rafael Matt have said in this thread. The dev exchange after the Flash makeover has just plain sucked (for all of the reasons already noted). I applaud their efforts in making their objections heard and offering solutions to fix the problems. Thanks, guys. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Simple Secure Login Model With Multiple Access Levels for MS Access (CF 4.51)
Howdy, I'm looking for a fairly simple security model compatible with MS Access 2000. The intent is to allow different administrators to log in to the admin portion of a client's site. There will be an overall administrator (with access to all areas) and one or two sub-administrators with restricted access to portions of the site or only certain functions. Anyone have any pointers to something like that? Ideally it would be more or less plug and play for a non-fusebox site running on a CF 4.51 server. Thanks. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Fusebox list
To my knowledge, these are the Fusebox lists that are currently active: http://groups.yahoo.com/group/fusebox4/ http://www.topica.com/lists/fusebox/prefs/info.html http://www.topica.com/lists/fbcommunity/prefs/info.html -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: Airtightweb ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: Macromedia Updates Contribute
http://news.com.com/2100-1012-1026181.html?part=dtxtag=nhl Some snippets from the article: Macromedia plans to update its light-duty Web publishing application, adding support for the Mac operating system and integrating controversial antipiracy technology. ... The new version will be the first Macromedia product to use product activation, an increasingly common antipiracy technique in which the installation process for a piece of software ties that copy to a particular PC configuration. ... Erik Larson, senior product manager for Macromedia, said activation technology in Contribute 2 will be based on software by Macrovision, the same company that supplied Intuit. But Macromedia's version will be heavily customized to allow for installation on two PCs and to be forgiving of hardware changes. Larson said use of product activation in other Macromedia products will be guided by comments from Contribute owners. We wanted to get a wide range of feedback about activation, he said. Contribute spans two sets of customers, so we thought it would be a good example. Interesting... -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: Airtightweb ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I need a blog
Howdy Kwang, Saturday, June 7, 2003, 11:36:57 PM, Kwang Suh wrote: I need a place to host my blog. http://www.blogspot.com/ If you want to host your own, here's a tutorial for one in CF: http://www.forgetfoo.com/tutorials/fooblog/ -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: Airtightweb ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: disable flash temporarily
Howdy I-Lin, Thursday, June 5, 2003, 5:06:46 PM, I-Lin Kuo wrote: I'm pretty sure these are flash. It's not a new window that pops up, it's an animated ad overlaying the content. One thing that might help is that after switching to Mozilla :) you can set your preference for handling images, under the Privacy Security preferences section, to Accept images that come from the originating server only. This seems to cut out lots of the ads, including Flash ads, since they often originate from external servers to the viewed site. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: Airtightweb ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Eclipse
Friday, May 30, 2003, 9:06:16 AM, John Paul Ashenfelter wrote: [snip] ... But one advantage of Eclipse is that IBM is solidly behind it, which helps any open source project. [snip] ... I've been working in Websphere Studio Application Developer on and off for 2 years and Eclipse 2.0 is certainly a huge step forward... Just found this: Macromedia also plans to enable Macromedia Dreamweaver(R) MX, its development tool for building ColdFusion applications (announced today, see separate release), to integrate with IBM's WebSphere Studio development environment via Eclipse, an open-source development platform for fast and easy tool integration. Both Macromedia and IBM's support for Eclipse will enable developers to enjoy the best of both development environments within an open and unified application development platform. http://www.prnewswire.com/cgi-bin/stories.pl?ACCT=104STORY=/www/story/04-29-2002/0001716202EDATE= Cheers. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: Airtightweb ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recursion Tutorial?
Some more links on recursion I just found: http://cfhub.com/advanced/customtags/recursion.cfm http://www.cfhub.com/tutorials/ftp2tree/recursion.cfm In addition, you might want to search the CF-Talk archives for the following subject lines: CF recursive question Recursive parent/child relationships How to make recursion in CF HELP: Hierarchy Content -Threading? Recursion in CF Most of the above threads that I saved were in 2000/2001, don't know how far back Michael's archives go. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: Airtightweb ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recursion Tutorial?
Howdy Jake, Tuesday, May 27, 2003, 11:16:23 PM, Jake McKee wrote: ... I am looking for good sources of help/tutorial on recursion. ... Here's some links I've collected. Most of them relate to hierarchical database design but you may find them useful anyway. The last article shows a way to do recursion in CF using a custom tag (which I've used a couple of times). Anyway, I hope these help. http://www.evolt.org/article/Four_ways_to_work_with_hierarchical_data/17/4047/index.html http://www.4guysfromrolla.com/webtech/sqlguru/q121799-1.shtml http://www.4guysfromrolla.com/webtech/sqlguru/q120899-1.shtml http://www.dbmsmag.com/9603d06.html http://www.dbmsmag.com/9604d06.html http://www.dbmsmag.com/9605d06.html http://www.sqlmag.com/Articles/Index.cfm?ArticleID=15715 http://www.intelligententerprise.com/001020/celko.shtml http://www.intelligententerprise.com/001020/celko1_1.shtml http://www.intelligententerprise.com/010918/414warehouse1_1.shtml/bi%7Cbusintel http://www.databasejournal.com/features/mssql/article.php/1477481 http://www.sqlteam.com/item.asp?ItemID=1602 http://www.sqlteam.com/item.asp?ItemID=1353 http://www.onlamp.com/pub/a/onlamp/2001/07/12/aboutSQL.html http://www.sqlteam.com/item.asp?ItemID=8866 http://www.sitepoint.com/article.php/1105 http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html http://www.defusion.com/articles/index.cfm?ArticleID=63 -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: Airtightweb ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PC Configuration Shopping Cart
Thursday, April 3, 2003, 3:48:36 PM, Greg Luce wrote: Anyone know of a pre-built PC Configuration Shopping cart? CFWebstore http://www.cfwebstore.com -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 AIM: AirtightWeb ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: -OT- Javascript and combo boxes
Howdy Thane, Tuesday, April 1, 2003, 10:03:33 AM, Thane Sherrington wrote: Is it possible to use Javascript to select a choice in a combo box? For instance, if I have a form with people listed, and beside each, a combo box with all the departments in the company, can I select a department in the first combobox, and have the other combo boxes automatically switch to that department as well? Yes. Look for the CF_TwoSelectsRelated custom tag in the Macromedia CF Exchange. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sql2k vs mySQL vs postgresql (for win2k)
Howdy Dan, Sunday, March 9, 2003, 8:31:54 PM, dan martin wrote: ... I am wondering if it would make more sense to migrate to an open source db: mySQL or postgresql. I am running win2k with cf5 and would like to keep the db on the same server. One thing you didn't mention was your environment - will this be only for development, or for production, or both? If production, will this be on your own server(s), or third-party shared hosting? Does anyone have experience or comparison information between the 3 choices running on win2k? How much work is it to port access to mysql or postgresql? For sql2k the upgrade tool does most of the work for you. Are there obvious benefits performance or feature wise between the choices? I'm a newbie myself to MySQL (v. 3.23.54 on Win2k) and am still learning my way around. With MyODBC I've found it's pretty easy to get Access to talk to MySQL, so it should be fairly easy to import your Access db to MySQL (I've pulled MySQL tables into Access, just as a test, but haven't gone the other way around...yet). There are several free front-end tools that I've been playing with that you might find worth checking out. They have varying capacities for export/import: - DBTools/DBManager: http://www.dbtools.com.br/EN/ - MySQL Control Center: http://www.mysql.com/products/mysqlcc/index.html - MySQL-Front: http://mysqlfront.venturemedia.de/index.php?act=STf=1t=2s=1a695d95d6c1514352366168370a801d (this tool is no longer being developed, but it still works well and can be downloaded at this URL) - SQLYog: http://www.webyog.com/sqlyog/index.html - eSQLManager: http://www.errorsoft.nl/index.jsp ...and here's a commercial tool (I haven't used this, but you might be interested anyway): - Navicat: http://www.mysqlstudio.com/index.php MySQL should be releasing version 4.1 real soon (no hard date announced on this yet, but what I've picked up from the MySql list, it would appear to be coming very soon). Version 4.1 will support sub-selects. Here's an article covering it: http://www.mysql.com/press/release_2003_05.html Might be worth the wait. Just for grins, here's a few more MySQL related links that may be of interest to you: - PHP MySQL Tips and Tutorials: http://www.sitepoint.com/subcat/98 - MySQL articles on Database Journal: http://www.databasejournal.com/features/mysql/ - Oh, my--MySQL!: http://builder.com.com/article.jhtml?id=u00320020523dol01.htmfromtm=e602 - MySQL articles: http://www.kitebird.com/articles/ - Migrating from Microsoft Access to MySQL: http://www.kitebird.com/articles/access-migrate.html - A collection of Articles about MySQL: http://www.mysql.com/articles/index.html - and of course, the big kahuna, MySQL Reference Manual: http://www.mysql.com/doc/en/index.html A couple more comparisons: - PostgreSQL vs. MySQL: http://www.webtechniques.com/archives/2001/09/jepson/ - MySQL vs. PostgreSQL: http://builder.com.com/article.jhtml?id=u00320020624gcn01.htmfromtm=e602 Hope you get something useful out of all the above. -- Chris Montgomery Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New MM.com
Wednesday, March 5, 2003, 7:02:08 AM, Jochem van Dieten wrote: Overall, I find the site rather slow when using the Flash version. ... I agree. I really dislike the new site. As a result, I switched to the HTML version. I guess I missed the option to do this. Where is it? -- Chris Montgomery ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New MM.com
Wednesday, March 5, 2003, 11:10:51 AM, Jochem van Dieten wrote: But I do like the look and feel of the new site. I do, for the most part. I guess I should've qualified my earlier dislike statement. It is just that it is slow. This is the biggest issue for me, too. Even on my DSL connection it is really slow. Under Accessibility at the bottom of the page. Yeah, I finally found it, but clicking on the HTML Version button had no effect whatsoever. Guess it's off to submit feedback. -- Chris Montgomery ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
BlueDragon Hosting?
Howdy, Is anyone hosting third-party commercial sites running under BlueDragon yet? If so, is there a list of BlueDragon hosts anywhere? -- Chris Montgomerymonty airtightweb.com Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Access and cfquery problem
Howdy Luis, Friday, January 24, 2003, 4:32:42 PM, Luis Lebron wrote: I am trying to run the following query with an Access database cfquery name=UpdateMessage datasource=#DataSource# Update messages set title='#Form.title#',subject='#Form.subject#',body='#Form.body#' where id='#Form.id#' /cfquery I'm guessing that your id field is of type numeric. If so, remove the single quotes and it should work ok, i.e., where id = #form.id#. Hope that helps. -- Chris Montgomerymonty @ airtightweb.com Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
