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]
