Yo Macromedia: CFMX and UUID Issue!
Queries that return UUIDs from SQL are coming back in Lowercase in CFMX. They didn't do that in CF5 or earlier. They are Uppercase in the database. This is creating issues for where I have had to hard code some UUIDs in JavaScript. Anybody else notice this? What gives? Is it too late to fix it before CFMX comes out? Justin Hansen -- Uhlig Communications Web Developer / Programmer -- [EMAIL PROTECTED] 913-754-4273 -- __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Yo Macromedia: CFMX and UUID Issue!
I believe it's the ODBC... errr... JDBC drivers that they use. They are definitely different. I myself noticed that if I have a field in an access database called "userID", a query for the field "UserID" will fail. I know that's my problem, but still - the ODBC drivers from version 5 didn't really care. I can't bitch because I'm sure the JDBC driver "does it the right way", so now all I have to do is make sure my code "does it the right way". Adam. > -Original Message- > From: Justin Hansen [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 15, 2002 1:59 PM > To: CF-Talk > Subject: Yo Macromedia: CFMX and UUID Issue! > > > Queries that return UUIDs from SQL are coming back in > Lowercase in CFMX. > They didn't do that in CF5 or earlier. They are Uppercase in > the database. > > This is creating issues for where I have had to hard code > some UUIDs in > JavaScript. > > Anybody else notice this? What gives? Is it too late to fix > it before CFMX > comes out? > > Justin Hansen > -- > Uhlig Communications > Web Developer / Programmer > -- > [EMAIL PROTECTED] > 913-754-4273 > -- > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Yo Macromedia: CFMX and UUID Issue!
> Queries that return UUIDs from SQL are coming back in Lowercase in CFMX. > They didn't do that in CF5 or earlier. They are Uppercase in the database. probably some other "quirks" as well. i can't seem to pack cfloop-ed t-sql statements (ie dozens of inserts) into one cfquery any longer __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Yo Macromedia: CFMX and UUID Issue!
Are you saying that CFMX uses JDBC for all datasources and it won't pickup ODBC dtatadources defined thru control panel? What about system DSNs? Thanks! - Original Message - From: "Cantrell, Adam" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 3:02 PM Subject: RE: Yo Macromedia: CFMX and UUID Issue! > I believe it's the ODBC... errr... JDBC drivers that they use. They are > definitely different. I myself noticed that if I have a field in an access > database called "userID", a query for the field "UserID" will fail. I know > that's my problem, but still - the ODBC drivers from version 5 didn't really > care. I can't bitch because I'm sure the JDBC driver "does it the right > way", so now all I have to do is make sure my code "does it the right way". > > Adam. > > > > > -Original Message----- > > From: Justin Hansen [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, May 15, 2002 1:59 PM > > To: CF-Talk > > Subject: Yo Macromedia: CFMX and UUID Issue! > > > > > > Queries that return UUIDs from SQL are coming back in > > Lowercase in CFMX. > > They didn't do that in CF5 or earlier. They are Uppercase in > > the database. > > > > This is creating issues for where I have had to hard code > > some UUIDs in > > JavaScript. > > > > Anybody else notice this? What gives? Is it too late to fix > > it before CFMX > > comes out? > > > > Justin Hansen > > -- > > Uhlig Communications > > Web Developer / Programmer > > -- > > [EMAIL PROTECTED] > > 913-754-4273 > > -- > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Yo Macromedia: CFMX and UUID Issue!
No, CFMX used JDBC as a 'bridge' to ODBC sources it should pick up your defined sources no probs. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 14:19 To: CF-Talk Subject: Re: Yo Macromedia: CFMX and UUID Issue! Are you saying that CFMX uses JDBC for all datasources and it won't pickup ODBC dtatadources defined thru control panel? What about system DSNs? Thanks! - Original Message - From: "Cantrell, Adam" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 3:02 PM Subject: RE: Yo Macromedia: CFMX and UUID Issue! > I believe it's the ODBC... errr... JDBC drivers that they use. They are > definitely different. I myself noticed that if I have a field in an access > database called "userID", a query for the field "UserID" will fail. I know > that's my problem, but still - the ODBC drivers from version 5 didn't really > care. I can't bitch because I'm sure the JDBC driver "does it the right > way", so now all I have to do is make sure my code "does it the right way". > > Adam. > > > > > -Original Message- > > From: Justin Hansen [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, May 15, 2002 1:59 PM > > To: CF-Talk > > Subject: Yo Macromedia: CFMX and UUID Issue! > > > > > > Queries that return UUIDs from SQL are coming back in > > Lowercase in CFMX. > > They didn't do that in CF5 or earlier. They are Uppercase in > > the database. > > > > This is creating issues for where I have had to hard code > > some UUIDs in > > JavaScript. > > > > Anybody else notice this? What gives? Is it too late to fix > > it before CFMX > > comes out? > > > > Justin Hansen > > -- > > Uhlig Communications > > Web Developer / Programmer > > -- > > [EMAIL PROTECTED] > > 913-754-4273 > > -- > > > > > __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Yo Macromedia: CFMX and UUID Issue!
Does having a "bridge" affect performance? Thanks Frank M - Original Message - From: "Neil Clark - =TMM=" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 9:16 AM Subject: RE: Yo Macromedia: CFMX and UUID Issue! > No, CFMX used JDBC as a 'bridge' to ODBC sources it should pick up > your defined sources no probs. > > > > > > > Neil Clark > Team Macromedia > http://www.macromedia.com/go/team > > Announcing Macromedia MX!! > http://www.macromedia.com/software/trial/. > > -Original Message- > From: Frank Mamone [mailto:[EMAIL PROTECTED]] > Sent: 16 May 2002 14:19 > To: CF-Talk > Subject: Re: Yo Macromedia: CFMX and UUID Issue! > > Are you saying that CFMX uses JDBC for all datasources and it won't > pickup > ODBC dtatadources defined thru control panel? What about system DSNs? > > Thanks! > > - Original Message ----- > From: "Cantrell, Adam" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, May 15, 2002 3:02 PM > Subject: RE: Yo Macromedia: CFMX and UUID Issue! > > > > I believe it's the ODBC... errr... JDBC drivers that they use. They > are > > definitely different. I myself noticed that if I have a field in an > access > > database called "userID", a query for the field "UserID" will fail. I > know > > that's my problem, but still - the ODBC drivers from version 5 didn't > really > > care. I can't bitch because I'm sure the JDBC driver "does it the > right > > way", so now all I have to do is make sure my code "does it the right > way". > > > > Adam. > > > > > > > > > -Original Message- > > > From: Justin Hansen [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, May 15, 2002 1:59 PM > > > To: CF-Talk > > > Subject: Yo Macromedia: CFMX and UUID Issue! > > > > > > > > > Queries that return UUIDs from SQL are coming back in > > > Lowercase in CFMX. > > > They didn't do that in CF5 or earlier. They are Uppercase in > > > the database. > > > > > > This is creating issues for where I have had to hard code > > > some UUIDs in > > > JavaScript. > > > > > > Anybody else notice this? What gives? Is it too late to fix > > > it before CFMX > > > comes out? > > > > > > Justin Hansen > > > -- > > > Uhlig Communications > > > Web Developer / Programmer > > > -- > > > [EMAIL PROTECTED] > > > 913-754-4273 > > > -- > > > > > > > > > > __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Yo Macromedia: CFMX and UUID Issue!
Not that I know of... peformance as far as serving pages is concerned is sweet with the new compilation architecture. I have heard that JDBC is faster than ODBC, but even with the bridge I dont think you will suffer any performance issues. If you have CFMX PR, then run a few tests against a CF5 install, thats your best bet though I doubt the idea was to release a product which was slower in performance than its predecessors. Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/. -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: 16 May 2002 14:26 To: CF-Talk Subject: Re: Yo Macromedia: CFMX and UUID Issue! Does having a "bridge" affect performance? Thanks Frank M - Original Message - From: "Neil Clark - =TMM=" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 9:16 AM Subject: RE: Yo Macromedia: CFMX and UUID Issue! > No, CFMX used JDBC as a 'bridge' to ODBC sources it should pick up > your defined sources no probs. > > > > > > > Neil Clark > Team Macromedia > http://www.macromedia.com/go/team > > Announcing Macromedia MX!! > http://www.macromedia.com/software/trial/. > > -Original Message- > From: Frank Mamone [mailto:[EMAIL PROTECTED]] > Sent: 16 May 2002 14:19 > To: CF-Talk > Subject: Re: Yo Macromedia: CFMX and UUID Issue! > > Are you saying that CFMX uses JDBC for all datasources and it won't > pickup > ODBC dtatadources defined thru control panel? What about system DSNs? > > Thanks! > > - Original Message ----- > From: "Cantrell, Adam" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, May 15, 2002 3:02 PM > Subject: RE: Yo Macromedia: CFMX and UUID Issue! > > > > I believe it's the ODBC... errr... JDBC drivers that they use. They > are > > definitely different. I myself noticed that if I have a field in an > access > > database called "userID", a query for the field "UserID" will fail. I > know > > that's my problem, but still - the ODBC drivers from version 5 didn't > really > > care. I can't bitch because I'm sure the JDBC driver "does it the > right > > way", so now all I have to do is make sure my code "does it the right > way". > > > > Adam. > > > > > > > > > -Original Message- > > > From: Justin Hansen [mailto:[EMAIL PROTECTED]] > > > Sent: Wednesday, May 15, 2002 1:59 PM > > > To: CF-Talk > > > Subject: Yo Macromedia: CFMX and UUID Issue! > > > > > > > > > Queries that return UUIDs from SQL are coming back in > > > Lowercase in CFMX. > > > They didn't do that in CF5 or earlier. They are Uppercase in > > > the database. > > > > > > This is creating issues for where I have had to hard code > > > some UUIDs in > > > JavaScript. > > > > > > Anybody else notice this? What gives? Is it too late to fix > > > it before CFMX > > > comes out? > > > > > > Justin Hansen > > > -- > > > Uhlig Communications > > > Web Developer / Programmer > > > -- > > > [EMAIL PROTECTED] > > > 913-754-4273 > > > -- > > > > > > > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Yo Macromedia: CFMX and UUID Issue!
> I have heard that JDBC is faster than ODBC, but even with the > bridge I don't think you will suffer any performance issues. It doesn't make any sense to say "JDBC is faster than ODBC". There are fast and slow JDBC clients, and fast and slow ODBC clients. I doubt that using the best Type 4 JDBC client against MS SQL Server will be as fast as using the standard ODBC client for it. Also, if by "the bridge" you mean the JDBC-ODBC bridge from Sun, if you use that you will certainly suffer performance issues. It's a Type 1 driver if I recall correctly, and designed more for demonstration purposes than anything else from my understanding. > If you have CFMX PR, then run a few tests against a CF5 > install, that's your best bet though I doubt the idea > was to release a product which was slower in performance > than its predecessors. I wouldn't be surprised if CF MX does turn out to be slower than CF 5 - it's more complex, it has to integrate with other products in a way that CF 5 doesn't, and so on. I hope that it's not much slower, though; that should be good enough. I think that the idea was to release a product that integrates fully with J2EE, more than it was to build something faster than CF 5. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Yo Macromedia: CFMX and UUID Issue!
> Are you saying that CFMX uses JDBC for all datasources and it > won't pickup ODBC datadources defined thru control panel? > What about system DSNs? Yes, I'm pretty sure that CF MX uses JDBC for all datasources. This is why it won't support the dynamic connectstring stuff added in CF 5. During the install, if you have CF 5 already installed, it'll create JDBC datasources for all of the previously defined ODBC datasources, but you may have to go in and tweak these datasources to get them to work. Once this is done, CF MX won't use ODBC for anything, and if you subsequently create ODBC datasources in the Control Panel, they won't be created within CF MX. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Yo Macromedia: CFMX and UUID Issue!
I can confirm that. CFMX PR didn't pickup any ODBC datasources on the machine I installed it on. - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 10:02 AM Subject: RE: Yo Macromedia: CFMX and UUID Issue! > > Are you saying that CFMX uses JDBC for all datasources and it > > won't pickup ODBC datadources defined thru control panel? > > What about system DSNs? > > Yes, I'm pretty sure that CF MX uses JDBC for all datasources. This is why > it won't support the dynamic connectstring stuff added in CF 5. During the > install, if you have CF 5 already installed, it'll create JDBC datasources > for all of the previously defined ODBC datasources, but you may have to go > in and tweak these datasources to get them to work. Once this is done, CF MX > won't use ODBC for anything, and if you subsequently create ODBC datasources > in the Control Panel, they won't be created within CF MX. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Yo Macromedia: CFMX and UUID Issue!
Tighter integration is great but performance enhancments are always a good selling point. It's tougher to justify an upgrade to my higher ups if we'll be losing performance. - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 9:51 AM Subject: RE: Yo Macromedia: CFMX and UUID Issue! > > I have heard that JDBC is faster than ODBC, but even with the > > bridge I don't think you will suffer any performance issues. > > It doesn't make any sense to say "JDBC is faster than ODBC". There are fast > and slow JDBC clients, and fast and slow ODBC clients. I doubt that using > the best Type 4 JDBC client against MS SQL Server will be as fast as using > the standard ODBC client for it. > > Also, if by "the bridge" you mean the JDBC-ODBC bridge from Sun, if you use > that you will certainly suffer performance issues. It's a Type 1 driver if I > recall correctly, and designed more for demonstration purposes than anything > else from my understanding. > > > If you have CFMX PR, then run a few tests against a CF5 > > install, that's your best bet though I doubt the idea > > was to release a product which was slower in performance > > than its predecessors. > > I wouldn't be surprised if CF MX does turn out to be slower than CF 5 - it's > more complex, it has to integrate with other products in a way that CF 5 > doesn't, and so on. I hope that it's not much slower, though; that should be > good enough. I think that the idea was to release a product that integrates > fully with J2EE, more than it was to build something faster than CF 5. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Yo Macromedia: CFMX and UUID Issue!
> Tighter integration is great but performance enhancments are > always a good selling point. > > It's tougher to justify an upgrade to my higher ups if we'll > be losing performance. That may be true, but in my opinion, the potential loss of performance is easily offset by the ability to do more in your applications, without as much work as before. If you do that well, your applications may perform significantly better than they did in the past anyway. Like Neil said, you'll have to try it and see; that's what evaluation versions are all about. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Yo Macromedia: CFMX and UUID Issue!
> That may be true, but in my opinion, the potential loss of performance is > easily offset by the ability to do more in your applications, without as plus you get to climb on the buzz word bandwagon for free. webservices, j2eee, xml, internationalization, remoting, gitchy-gitchy-ya-ya __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Yo Macromedia: CFMX and UUID Issue!
Is there like a certification program for gitchy-gitchy-ya-ya - it sounds pretty robust. How does it handle in B2B implementations? > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 16, 2002 10:39 AM > To: CF-Talk > Subject: Re: Yo Macromedia: CFMX and UUID Issue! > > > > That may be true, but in my opinion, the potential loss of > performance is > > easily offset by the ability to do more in your > applications, without as > > plus you get to climb on the buzz word bandwagon for free. > webservices, > j2eee, xml, internationalization, remoting, gitchy-gitchy-ya-ya > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Yo Macromedia: CFMX and UUID Issue!
> Is there like a certification program for gitchy-gitchy-ya-ya - it sounds > pretty robust. How does it handle in B2B implementations? yeah but its requirements are a bit stiff, public singing, disrobing in public places & liberal applications of makeup--i'll never pass __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Yo Macromedia: CFMX and UUID Issue!
>It doesn't make any sense to say "JDBC is faster than ODBC". There are fast >and slow JDBC clients, and fast and slow ODBC clients. I doubt that using >the best Type 4 JDBC client against MS SQL Server will be as fast as using >the standard ODBC client for it. Agreed, I have seen stuff around the programs stating "its fast/faster", but I have also heard "its slow/slower" etc... :) >Also, if by "the bridge" you mean the JDBC-ODBC bridge from Sun, if you se >that you will certainly suffer performance issues. It's a Type 1 driver if >Irecall correctly, and designed more for demonstration purposes than >anything else from my understanding. As for this, I am pretty sure its a bridge. CFMX installs with the IBM JRE (well it did in earlier releases). >I wouldn't be surprised if CF MX does turn out to be slower than CF 5 - hmm, I think its all relative - I too would be happy for more featuresnow wheres that bandwagon - N __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists