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]
