RE: cfopenbb
Look over the bandwidth limitations and unfinished site. It is running on my local dev server right now but let me know if anything looks useful in my CF4em. Many of the features in phpbb are there. As it stands, I dont know when Ill ever get the chance to finish it and I wouldnt mind seeing some of it go to good use http://acoderslife.com/msgbrd/ -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 11:11 PM To: CF-Talk Subject: Re: cfopenbb Same for Galleon as well (ray.camdenfamily.com/forums). I say share and share alike. As it stands, I'm looking at features from phpBB to add (most like the next feature in Galleon will be Stickies). On 8/26/05, Rick Root [EMAIL PROTECTED] wrote: IMO, more than a few developers can really slow down a project in its early stages. Feel free though to rape cfmbb (www.cfmbb.org) for any ideas or code. Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216581 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: Adobe Version Cue 2 uses MySQL!
Kevin Aebig wrote: So Does SQLite and it offers *way* more options. Triggers, stored procedures... there's a reason PHP changed over. And that reason has got nothing to do with capabilities but with the different licensing of the MySQL drivers. Jochem ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216582 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Is there anything to Railo?
I just ran across this. Has anyone used it? http://www.railo.ch/en/documentation/index.cfm?treeID=18 Supports cfc's too. Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216583 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: cfopenbb
Yeah I agree all the way...the oringal date was november butlast I checked discussions were still going on about naming conventions... Adam H On 8/26/05, Rick Root [EMAIL PROTECTED] wrote: IMO, more than a few developers can really slow down a project in its early stages. Feel free though to rape cfmbb (www.cfmbb.org) for any ideas or code. Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216584 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
Database modeling ide
Does anyone have experience with ERCreator 3.0? http://www.modelcreator.com/ I am looking for an affordable database modeling ide that supports at minimum the following: SQL Server, MySQL, PostgreSQL, Oracle, and Access Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 ~| 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:216585 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: Multiple File Upload
The Stickman blog has a cool, cross-browser, single-form implementation This is interesting indeed. However, one still has to select one file at a time, and there is no possibility to select a whole directory. IMO that would be the most usefull feature, but it is limited by the HTTP protocole. ~| 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:216586 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: ODBC nightmare
Figure JDBC has nothing to do with ODBC. So its only natural that a JDBC connection doesn't show in the Windows ODBC applet, and anything in the ODBC applet is not shown in CF's JDBC dsn list. No no, may be I shouldn't have posted the two problems in the same time. My problem with ODBC has nothing to do with the one with JDBC. The problem with ODBC seems to be a case sensitivity problem. 1º When I define an ODBC connection from Windows, the CF Administrator does not see it. 2º I then redifine the same one in the Administrator, then I can see TWO ODBC connections in the registry, both are identical except for the upper case in the file name. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216587 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: JDBC nightmare
Are you doing this to add a dsn programmatically to extend your CFX? Well, the first step would be at least to have a couple of JDBC connections in my system, so I'm just using the CF Administrator to define a couple of them on some databases I have. I've been able to create one on the compassTravel example in the docs, because they explain EXACTY what to do, but when I try to adapt to another Acces file, the verify step tells me that it cannot find the file. Now talking about CFX_JDBCinfo, I doubt I could do it in the same tag, since all the JDBC environment is in JAVA, and the ODBC is in C. I'm looking for an ODBC to JDBC bridge in C, but I doubt it exists. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:216588 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: Multiple File Upload
Claude Schneegans wrote: The Stickman blog has a cool, cross-browser, single-form implementation This is interesting indeed. However, one still has to select one file at a time, and there is no possibility to select a whole directory. IMO that would be the most usefull feature, but it is limited by the HTTP protocole. Well I think the only solution that could do that would be java or an activeX control along with a server side component like a CFC. CFFM, at least, lets you upload a zip file then unzip it on the server, which can be nice, but that was also included in the original posters Other than.. clause. Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216589 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: ODBC nightmare
On 8/27/05, Claude Schneegans [EMAIL PROTECTED] wrote: 1º When I define an ODBC connection from Windows, the CF Administrator does not see it. Yup that is expected behavior, since CF is no longer tied to the ODBC applet like it once was. 2º I then redifine the same one in the Administrator, then I can see TWO ODBC connections Now that is surprising. For the times I have used an ODBC/JDBC bridge dsn, I haven't seen this, and my procedure sounds to be the same: First create the ODBC DSN, then bridge to it in the CF Admin. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216590 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: JDBC nightmare
Establishing a JDBC connection should be as easy as falling off a log. You go to the dsn area, give the thing a name and pick your dsn type. For Access I would pick MS Access with Unicode Support. Then the dialog pops up and I would select the file location via the java applet tree (almost the same as in older CF versions). At that point you can press 'save' and you should be done, assuming no password/login issues to the .mdb file. On 8/27/05, Claude Schneegans [EMAIL PROTECTED] wrote: Are you doing this to add a dsn programmatically to extend your CFX? Well, the first step would be at least to have a couple of JDBC connections in my system, so I'm just using the CF Administrator to define a couple of them on some databases I have. I've been able to create one on the compassTravel example in the docs, because they explain EXACTY what to do, but when I try to adapt to another Acces file, the verify step tells me that it cannot find the file. Now talking about CFX_JDBCinfo, I doubt I could do it in the same tag, since all the JDBC environment is in JAVA, and the ODBC is in C. I'm looking for an ODBC to JDBC bridge in C, but I doubt it exists. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:216591 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: Multiple File Upload
fyi Flash Player 8 will allow multiple files to be uploaded at once. http://blog.oinam.com/archives/2005/08/flash_8_file_up.html (includes CFR examples) mike chambers [EMAIL PROTECTED] Rick Root wrote: Claude Schneegans wrote: The Stickman blog has a cool, cross-browser, single-form implementation This is interesting indeed. However, one still has to select one file at a time, and there is no possibility to select a whole directory. IMO that would be the most usefull feature, but it is limited by the HTTP protocole. Well I think the only solution that could do that would be java or an activeX control along with a server side component like a CFC. CFFM, at least, lets you upload a zip file then unzip it on the server, which can be nice, but that was also included in the original posters Other than.. clause. Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216592 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
MySQL - CF: Access Denied when using password
Hello all, I have set up MySQL on my local box, everything works fine until I try to use a password when creating a datasource in CF Administrator. I get the 1045 Access Denied error. I am able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! ~| 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:216593 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: MySQL - CF: Access Denied when using password
that would be because your local MySQL install doesnt have the same pw's as your live one therefor you are trying to give it a username and password it doesn't have and getting the warning. Not sure how others do it but in my Application.cfm or cfc (shut it will) I set 2 sets of connection variable, 1 live and 1 local and just comment out the one i dont need at the time. like !--- comment out cause we are in local setting !--- set live connection --- cfset application.dsn = myconnection cfset username = jack cfset password = smack --- !--- set local connection -- cfset application.dsn = myconnection cfset username = cfset password = ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Josh Nathanson [EMAIL PROTECTED] Sent: Saturday, August 27, 2005 1:49 PM To: CF-Talk cf-talk@houseoffusion.com Subject: MySQL - CF: Access Denied when using password Hello all, I have set up MySQL on my local box, everything works fine until I try to use a password when creating a datasource in CF Administrator. I get the 1045 Access Denied error. I am able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! ~| 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:216594 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: SQL Server Instances and CF 7
You can set a DSN to use any instance you have installed, you simply name it in the DSN. If you're using CFMX to connect to SQL Server named instances, you will need to specify the appropriate TCP port for each; the name itself won't make any difference. Each named instance will have its own TCP listening port. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:216595 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: JDBC nightmare
I'm trying to install a JDBC DS under CFMX 6.1 It's really a mess! :-( I succeeded to define the compassTravel example as described in the docs, but cannot manage to install any other DS on any other Access database, even scupuleously copiing the path name with same upper and lower case. Apparently one need to give this line in JDBC URL: jdbc:pointbase:compasstravel,database.home=C:/inetsrv/wwwroot/ cfdocs/getting_started/db just to tell where the Acces C:/inetsrv/wwwroot/cfdocs/getting_started/db/compasstravel.mbd is. Why doesn't the Administrator just take C:/inetsrv/wwwroot/cfdocs/getting_started/db/compasstravel.mbd and does whatever needs to be done with it? Another thing is the driver class which need to be com.pointbase.jdbc.jdbcUniversalDriver How can I guess what are the other classes, and I suspect the other drivers available? My question, is this mess any better under CFMX 7, and is it worth upgrading? Yikes! Where to begin ... First, the CompassTravel example you're referring to isn't an Access database. It's a Pointbase database. Pointbase is a Java database server intended for embedded applications. JRun has included it for some time for sample applications; it's better for this purpose because it will work on any platform. There is an Access version of the CompassTravel database in the same directory, but you can't use the Pointbase driver to connect to it. Second, if you want to connect to an Access database, you can use the Microsoft Access option within the CF Administrator. This will handle all the ugly JDBC URL and driver class stuff for you. All you have to do is point it to the Access file you want to use. Under the covers, this uses a product called SequeLink to connect to an ODBC datasource that CF creates for you. SequeLink is a JDBC-to-ODBC bridge. There is also another Access driver that doesn't use ODBC - it's listed within the CF Administrator as Microsoft Access with Unicode. I'm not sure when this was introduced into CFMX, though - I think it was CFMX 6.1. Third, if you want to use other JDBC drivers, you can typically find out the appropriate JDBC URL and driver class syntax from the documentation that comes with those drivers. Finally, it's about the same under CFMX 7, but it's not very messy in either case. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:216596 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: JDBC nightmare
You go to the dsn area, give the thing a name and pick your dsn type. For Access I would pick MS Access with Unicode Support. This is what I have indeed for ODBC connections, but for JDBC, the docs say I must pick Other, then I must enter a JDBC URL line like: jdbc:pointbase:compasstravel,database.home=C:/inetsrv/wwwroot/cfdocs/getting_started/db No browser to a file. I suspect this is proper to CFMX 6 and that it has been inproved in version 7? Then the dialog pops up and I would select the file location via the java applet tree (almost the same as in older CF versions). No applet tree for me, just another line with com.pointbase.jdbc.jdbcUniversalDriver God knows where it comes from :-( -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216597 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: JDBC nightmare
This is what I have indeed for ODBC connections, but for JDBC, the docs say I must pick Other, then I must enter a JDBC URL line like: jdbc:pointbase:compasstravel,database.home=C:/inetsrv/wwwroot/ cfdocs/getting_started/db No browser to a file. I suspect this is proper to CFMX 6 and that it has been inproved in version 7? When you pick Other, you are choosing to use something that CF doesn't know about natively such as Pointbase. All of the selections, including Other, use JDBC because CFMX (being a Java application) can only use JDBC. When you choose Microsoft Access or ODBC Socket, you are using SequeLink, which is a JDBC-to-ODBC bridge. The interface for Other looks the same in CFMX 6 and 7, because there simply isn't too much to it - you enter a JDBC URL and a driver class name. Different JDBC drivers have their own JDBC URL syntax elements, so there's no way CF could give you an interface to let you browse to a file - some JDBC drivers (like Pointbase) use database files, while others (like jTDS, jTurbo or Microsoft's own JDBC driver just to name three that are all used with MS SQL Server) are clients that talk to database servers. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:216598 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: MySQL - CF: Access Denied when using password
Thanks Dave, but I have set up a dummy user locally with the same username and password as that of the live application, so I don't think that is the issue... It works absolutely great as long as I don't try to use a password. For some reason that is what's throwing it off. I have a bunch of apps running remotely on CF/MySQL, and I am trying to move from MS Access to MySQL locally, so I'd like to be able to do that without rewriting all the code, or dealing with the commenting workaround you suggested. Is there some rule against a localhost user other than root connecting to MySQL? I am no expert so I might be missing something really obvious, but this also stumped my trusty web host who is something of a CF guru. I emailed him my MySQL user and db tables and he couldn't find anything wrong that would be causing the error. - Original Message - From: dave [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Saturday, August 27, 2005 1:07 PM Subject: re: MySQL - CF: Access Denied when using password that would be because your local MySQL install doesnt have the same pw's as your live one therefor you are trying to give it a username and password it doesn't have and getting the warning. Not sure how others do it but in my Application.cfm or cfc (shut it will) I set 2 sets of connection variable, 1 live and 1 local and just comment out the one i dont need at the time. like !--- comment out cause we are in local setting !--- set live connection --- cfset application.dsn = myconnection cfset username = jack cfset password = smack --- !--- set local connection -- cfset application.dsn = myconnection cfset username = cfset password = ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Josh Nathanson [EMAIL PROTECTED] Sent: Saturday, August 27, 2005 1:49 PM To: CF-Talk cf-talk@houseoffusion.com Subject: MySQL - CF: Access Denied when using password Hello all, I have set up MySQL on my local box, everything works fine until I try to use a password when creating a datasource in CF Administrator. I get the 1045 Access Denied error. I am able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! ~| 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:216599 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: JDBC nightmare
First, the CompassTravel example you're referring to isn't an Access database. It's a Pointbase database. Pointbase is a Java database server intended for embedded applications. JRun has included it for some time for sample applications; it's better for this purpose because it will work on any platform. There is an Access version of the CompassTravel database in the same directory, but you can't use the Pointbase driver to connect to it. Ah ok, this is why I got confued, I thought I had a JDBC connection to the ACCESS file, And when I tried to modify it for another Acces file, of course, it didn't work. Second, if you want to connect to an Access database, you can use the Microsoft Access option within the CF Administrator. This will handle all the ugly JDBC URL and driver class stuff for you. All you have to do is point it to the Access file you want to use. Under the covers, this uses a product called SequeLink to connect to an ODBC datasource that CF creates for you. SequeLink is a JDBC-to-ODBC bridge. Ah ok, another thing with is not explained in the docs, I thought this would just create an ODBC connection. There is also another Access driver that doesn't use ODBC - it's listed within the CF Administrator as Microsoft Access with Unicode. I'm not sure when this was introduced into CFMX, though - I think it was CFMX 6.1. Yeah, and this one is a JDBC type 3 or 4 driver, ok. Third, if you want to use other JDBC drivers, you can typically find out the appropriate JDBC URL and driver class syntax from the documentation that comes with those drivers. Ok, if I can find where they are ;-) I suppose some of them come with CF? Thank anyway, this is becoming more clear for me. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216600 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: MySQL - CF: Access Denied when using password
i dunno if there is a better work around, i have never really bothered to look, the way i do it takes about 17.4 seconds to do so it's easy enough. Seems as tho there was someting about a local mysql system that just didnt let you use it but it sure looks like thats your fix and as long as you set it in the Application scope its there and only needs changed on one page. Technically, you can do quite a few things with this like in the application.cfm or CFC you can do some logic, like determine if its being called from localhost or from the live server and have it feed it the correct settings. ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Josh Nathanson [EMAIL PROTECTED] Sent: Saturday, August 27, 2005 5:24 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: MySQL - CF: Access Denied when using password Thanks Dave, but I have set up a dummy user locally with the same username and password as that of the live application, so I don't think that is the issue... It works absolutely great as long as I don't try to use a password. For some reason that is what's throwing it off. I have a bunch of apps running remotely on CF/MySQL, and I am trying to move from MS Access to MySQL locally, so I'd like to be able to do that without rewriting all the code, or dealing with the commenting workaround you suggested. Is there some rule against a localhost user other than root connecting to MySQL? I am no expert so I might be missing something really obvious, but this also stumped my trusty web host who is something of a CF guru. I emailed him my MySQL user and db tables and he couldn't find anything wrong that would be causing the error. - Original Message - From: dave To: CF-Talk Sent: Saturday, August 27, 2005 1:07 PM Subject: re: MySQL - CF: Access Denied when using password that would be because your local MySQL install doesnt have the same pw's as your live one therefor you are trying to give it a username and password it doesn't have and getting the warning. Not sure how others do it but in my Application.cfm or cfc (shut it will) I set 2 sets of connection variable, 1 live and 1 local and just comment out the one i dont need at the time. like --- ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Josh Nathanson Sent: Saturday, August 27, 2005 1:49 PM To: CF-Talk Subject: MySQL - CF: Access Denied when using password Hello all, I have set up MySQL on my local box, everything works fine until I try to use a password when creating a datasource in CF Administrator. I get the 1045 Access Denied error. I am able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216601 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: cfopenbb
if you'd like to see things move faster, feel free to volunteer to help! The main page of the website may detour others from offering their assistance. Maybe you should change it if you need more help. -Original Message- From: Matt Woodward [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 2:08 PM To: CF-Talk Subject: Re: cfopenbb Any updates on this effort? The initial buzz seems to have died down. We're working--if you'd like to see things move faster, feel free to volunteer to help! ~| 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:216602 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: JDBC nightmare
Ok, if I can find where they are ;-) I suppose some of them come with CF? The only one that comes with CF, as far as I'm aware, is Pointbase. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:216603 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: ODBC nightmare
Yup that is expected behavior, since CF is no longer tied to the ODBC applet like it once was. Ok, now I understand that is not an Access database then there is no ODBC connection to it. I was confused because there is also a compassTravel Acces database, and I thought the JDBC connection to it would also create an ODBC connection. Now, if I understand well, if I want to make performance comparisions between ODBC and JDBC, I should - create an ODBC connection to an Access database using CF 5 and run an application under CF5, - create a direct JDBC (the one which uses Unicode) connection to the same database and run the application under CFMX. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216604 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: JDBC nightmare
The only one that comes with CF, as far as I'm aware, is Pointbase. And this driver will read ANY database? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216605 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: JDBC nightmare
And this driver will read ANY database? No, Pointbase has its own file format. The Pointbase driver only works with Pointbase databases, to the best of my knowledge. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:216606 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
Exclude Specific Folders/Files from Verity Search
Hi, Is there a way to exclude specific folders while searching is implemented usig verity in coldfusion. Thanks --Anitha ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216607 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: Exclude Specific Folders/Files from Verity Search
I noticed you said you want to exlude them from the search, so I assume you mean that instead of excluding them from the index. If you search on a file based collection, the key value contains the full pathname of the result. You may be able to exclude folders by building logic into your criteria that does stuff like AND NOT cf_key contains c:\thebadpath Another alternative is to use a query of query to filter the results after the query. That may be be a bit simpler. On 8/27/05, Anitha kancharla [EMAIL PROTECTED] wrote: Hi, Is there a way to exclude specific folders while searching is implemented usig verity in coldfusion. Thanks --Anitha ~| 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:216608 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
Flash Forms: Empty CFGrid and insertRow
is it possible to add a row to a CFGrid that starts off empty? I've tried with the built-in insert button and a standalone (with onClick=GridData.insertRow(GridName)) Any suggestions? ~| 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:216609 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: JDBC nightmare
The Pointbase driver only works with Pointbase databases, to the best of my knowledge. Hmmm... So there is no direct JDBC driver that come with CF? Any JDBC connection must go through the ODBC bridge? Then were is the advantage of JDBC? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216610 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: ODBC nightmare
In CF5 you could also make an ODBC connection from within the CF Administrator. If you are going to do performance comparisons make sure the Advanced Settings are all the same. IIRC the recommended UNchecking of Maintain Database Connections is the default in MX' JDBC interface, so make sure you emulate that and everything else in CF 6/7. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216611 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: MySQL - CF: Access Denied when using password
Hello all, I have set up MySQL on my local box, everything works fine until I try to use a password when creating a datasource in CF Administrator. I get the 1045 Access Denied error. I am able to create the datasource fine if I don't use a password, so I know the issue is not caused by incorrect privileges in the mysql.user or mysql.db tables. Also if I do set up the datasource without a password, and try to use a password in a cfquery, I get the same error. My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 Thanks for any assistance! I use SQL server (not sure how similar this is to MySQL) and there were two options when setting it up either use windows authentication or combined windows and sql authentication I chose windows authentication which means I don't have to pass the username and password as windows does that. Maybe that is what is happening in your case? I just modify my application template (on my PC) to reflect no username and password (as on the hosted server they are required). cfscript request.login=; request.password=; /cfscript Incidently I found the whole process of setting up SQL Server locally a total nightmare but eventually I figured it out! Andrew. ~| 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:216612 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: JDBC nightmare
Hmmm... So there is no direct JDBC driver that come with CF? All of the drivers that come with CF are JDBC drivers. Whenever you pick any of the listed datasource types besides Other, you're using JDBC drivers that come with CF. Pointbase is the only driver that comes with CF, for which you have to configure the JDBC URL yourself. Any JDBC connection must go through the ODBC bridge? No, only the Microsoft Access and ODBC Socket datasources use ODBC. All others are pure Java JDBC drivers. Then were is the advantage of JDBC? I don't know if I'd call JDBC an advantage - JDBC is simply how Java applications connect to databases. Since CFMX is a Java application, it uses JDBC. JDBC drivers that connect directly to a database instead of connecting to another middleware layer like ODBC generally perform better than those that don't, so if you're going to use JDBC you're usually better off using pure Java JDBC Type 4 drivers. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:216613 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