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. 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]
