RE: JDBC nightmare

2005-08-27 Thread Dave Watts
> 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 ha

Re: MySQL - CF: Access Denied when using password

2005-08-27 Thread Andrew Grosset
> 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

Re: ODBC nightmare

2005-08-27 Thread Matt Robertson
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 yo

Re: JDBC nightmare

2005-08-27 Thread Claude Schneegans
>>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! U

Flash Forms: Empty CFGrid and insertRow

2005-08-27 Thread Chris Brandt
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 you

Re: Exclude Specific Folders/Files from Verity Search

2005-08-27 Thread Raymond Camden
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 t

Exclude Specific Folders/Files from Verity Search

2005-08-27 Thread Anitha kancharla
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.house

RE: JDBC nightmare

2005-08-27 Thread Dave Watts
> 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 ins

Re: JDBC nightmare

2005-08-27 Thread Claude Schneegans
>>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 PROTEC

Re: ODBC nightmare

2005-08-27 Thread Claude Schneegans
>> 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 t

RE: JDBC nightmare

2005-08-27 Thread Dave Watts
> 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 train

RE: cfopenbb

2005-08-27 Thread Ewok
> 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, Augu

Re: MySQL - CF: Access Denied when using password

2005-08-27 Thread dave
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 s

Re: JDBC nightmare

2005-08-27 Thread Claude Schneegans
>>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 p

Re: MySQL - CF: Access Denied when using password

2005-08-27 Thread Josh Nathanson
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

RE: JDBC nightmare

2005-08-27 Thread Dave Watts
> 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 a

Re: JDBC nightmare

2005-08-27 Thread Claude Schneegans
>>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

RE: JDBC nightmare

2005-08-27 Thread Dave Watts
> 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 ca

RE: SQL Server Instances and CF 7

2005-08-27 Thread Dave Watts
> 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

re: MySQL - CF: Access Denied when using password

2005-08-27 Thread dave
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 var

MySQL - CF: Access Denied when using password

2005-08-27 Thread Josh Nathanson
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 inc

Re: Multiple File Upload

2005-08-27 Thread Mike Chambers
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

Re: JDBC nightmare

2005-08-27 Thread Matt Robertson
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 s

Re: ODBC nightmare

2005-08-27 Thread Matt Robertson
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 Administ

Re: Multiple File Upload

2005-08-27 Thread Rick Root
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

Re: JDBC nightmare

2005-08-27 Thread Claude Schneegans
>>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 compas

Re: ODBC nightmare

2005-08-27 Thread Claude Schneegans
>>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 not

Re: Multiple File Upload

2005-08-27 Thread Claude Schneegans
>>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

Database modeling ide

2005-08-27 Thread Stan Winchester
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 Preside

Re: cfopenbb

2005-08-27 Thread Adam Haskell
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

Is there anything to Railo?

2005-08-27 Thread Will Tomlinson
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 track

Re: Adobe Version Cue 2 uses MySQL!

2005-08-27 Thread Jochem van Dieten
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 ~~