No Perl
:P At 17:12 26/09/02 +0100, you wrote: >ah so not CF > >;-p > >-----Original Message----- >From: Matt Horn [mailto:[EMAIL PROTECTED]] >Sent: 26 September 2002 17:09 >To: [EMAIL PROTECTED] >Subject: RE: RE: [ cf-dev ] Which SQL ?? > > >At 17:03 26/09/02 +0100, you wrote: > >Yep, it is a CF list, but emulation is not a solution, its a workaround >(and > >a bad business decision). > > > >It would be a simulation if they proposed workaround was full featured; I >am > >intrigued to hear how an SP can be emulated within mySQL - at least to the > >same degree that other enterprise servers supply them. >Using perl thats how > >http://www.tangent.org/~brian/talks/dbsummit_perl/slide002.html > > > > >The problem lies within mySQL itself (though these flaws certainly dont >make > >it a bad product by any means). > > > >Neil > > > > > >-----Original Message----- > >From: Matt Horn [mailto:[EMAIL PROTECTED]] > >Sent: 26 September 2002 16:59 > >To: [EMAIL PROTECTED] > >Subject: Re: RE: [ cf-dev ] Which SQL ?? > > > > > >Yes > > > >and it is a good solution to a point > > > >also Stored procs can be emulated in mySQL > > > >At 16:57 26/09/02 +0100, you wrote: > > >point taken, but this is a CF list is it not? > > > > > > >>> "Robertson-Ravo, Neil (REC)" <[EMAIL PROTECTED]> > > > 09/26 4:54 pm >>> > > >thats hardly getting round a problem in mySQL is it? the flaw is within > > >mySQL regardless of the development language! > > > > > > > > > > > >-----Original Message----- > > >From: Adam Bailin [mailto:[EMAIL PROTECTED]] > > >Sent: 26 September 2002 16:51 > > >To: [EMAIL PROTECTED] > > >Subject: Re: [ cf-dev ] Which SQL ?? > > > > > > > > >Another way you can get round subqueries on mySQL is by using query of a > > >query. (CF5 or higher) > > > > > > >>> "Tom Smith" <[EMAIL PROTECTED]> 09/23 2:19 pm >>> > > >the non-development release (of MYSQL) does not support nested sub >queries > > >or stored procedures, which in my eyes is a reason not to use it. this > >means > > >that the functionality is far less that you can expect from SQL >server.... > > >take an example > > > > > >select * from table where id in (select id from table2) > > > > > >would have to be done in at least to queries... > > > > > >psuedo code: > > >cfquery1 > > >select id from table2 > > > > > >cfquery2 > > >select * from table where i_id in (valuelist(cfquery1.id)) > > > > > >this is 2 queries where one should suffice, this is 2 connections where >one > > >should suffice. obviously this example isn't best, but use you >imagination > > >and you should be able to see where this could be problematic... > > > > > >Stored procedures are a fantastic way of using the data in the database >as > > >well... I prefer stored procedures as there is so much you can do with > > >them, and they are definitely much more secure than writing queries... > > >think about doing some data manipulation that you have to do with CF, and > > >the write it back to the database, this shoudl be possible using a stored > > >procedure. > > > > > >I am sure there are other reasons, but I am pretty new to MySQL and it's > >OK, > > >but not nearly as powerful as SQL server... > > > > > >----- Original Message ----- > > >From: <[EMAIL PROTECTED]> > > >To: <[EMAIL PROTECTED]> > > >Sent: Monday, September 23, 2002 11:48 AM > > >Subject: RE: [ cf-dev ] Which SQL ?? > > > > > > > > > > Thanks for all the info so far. > > > > > > > > Just wondering what the special functionality is that SQL2000 has over > > > > mysql. > > > > > > > > It looks like sql2000 is what we need but he bods will ask why and >will > > > > want a non techy answer as to do we spend > > > > > > > > ************************************************************* > > > > This email and any files transmitted with it are confidential > > > > and intended solely for the use of the individual or entity > > > > to whom they are addressed. If you have received this email > > > > in error please notify [EMAIL PROTECTED] > > > > > > > > The views expressed within this email are those of the > > > > individual, and not necessarily those of the organisation > > > > ************************************************************* > > > > > > > > > > > > > > > > > >--------------------------------------------------------------------------- > >- > > >---- > > > > > > > > > > > >�xxxx or do we get mysql for much > > >cheaper. > > > > > >Can anyone let me know why not to use mysql - all that head banging stuff > > >etc.... > > > > > >Regards - Paul. > > > > > > > > > > > > > > > >--------------------------------------------------------------------------- > >- > > >---- > > > > > > > > > > -- > > > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > For human help, e-mail: [EMAIL PROTECTED] > > > > > >__________________________________________________ > > >Do You Yahoo!? > > >Everything you'll ever need on one web page > > >from News and Sport to Email and Music Charts > > >http://uk.my.yahoo.com > > > > > >-- > > >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > >To unsubscribe, e-mail: [EMAIL PROTECTED] > > >For additional commands, e-mail: [EMAIL PROTECTED] > > >For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > >*************************************************************************** > > >This message has been swept for viruses and other > > >unsuitable content by the Ofsted Mail Sweeper in > > >accordance with OFIN 59, however care should be > > >taken when opening any attachments from an untrusted > > >source. > > > >*************************************************************************** > > > > > > > > > > > > > > >********************************************************************** > > >We cannot accept any liability for any loss or damage > > >sustained as a result of software viruses. It is your > > >responsibility to carry out such virus checking as is necessary before > > >opening any attachment to > > >this message. > > > > > >The information in this email and any files transmitted with > > >it may be of a confidential nature and is intended solely for > > >the addressees. If you are not the intended addressee, any > > >disclosure, copying or distribution by you is prohibited and > > >may be unlawful. > > > > > >www.ofsted.gov.uk > > >********************************************************************** > > > > > > > > >-- > > >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > >To unsubscribe, e-mail: [EMAIL PROTECTED] > > >For additional commands, e-mail: [EMAIL PROTECTED] > > >For human help, e-mail: [EMAIL PROTECTED] > > > > > >-- > > >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > >To unsubscribe, e-mail: [EMAIL PROTECTED] > > >For additional commands, e-mail: [EMAIL PROTECTED] > > >For human help, e-mail: [EMAIL PROTECTED] > > > > > > > > >-- > > >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > > > >To unsubscribe, e-mail: [EMAIL PROTECTED] > > >For additional commands, e-mail: [EMAIL PROTECTED] > > >For human help, e-mail: [EMAIL PROTECTED] > > > > > >-- > >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > >For human help, e-mail: [EMAIL PROTECTED] > > > >-- > >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > >For human help, e-mail: [EMAIL PROTECTED] > > >-- >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] > >-- >** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
