NYCPHP Meetup

Sun Sep 21 14:56:03 EDT 2003

MessageJim, if I had that kind of learning ability I would do so, but unfortunately I can only take things in small bite-sized pieces, therefore, a manual would do me no good as a whole.  Usually when it comes to manuals I can only pick at what I understand and/or need at the moment and apply.  In fact, my entire ability is based on application, not on foreknowledge or logical cognition.  In other words, I know that to make a cake you add these ingredients until it works, not that you already know to do this/that/other based on what you read, because often times what I read makes no sense to me anyway.

Sorry, that's how I've always viewed the world since birth and school.  Somehow I've compensated for this severe ability lacking and done what I needed to get done.  In the case of creating relational data models of complexities ranging from lookup tables to association tables (as is the case of this freelance project I'm working on), mySQL doesn't cut it.  Oracle, SQL Server and even Sybase (that I don't know) would cut it quite well.  That's how I view it.

Phil
  ----- Original Message ----- 
  From: Jim Hendricks 
  To: NYPHP Talk 
  Sent: Sunday, September 21, 2003 2:51 PM
  Subject: Re: [nycphp-talk] Error involving inner SELECT using mySQL - HELP

  I wouldn't categorize mySQL a waste of database.

  It depends on your needs.  Do you need a fast, small, cheap database which is easy to get into and use, or a advanced, expensive, database that takes months of studying to begin to utilize to it's best abilities?

  Oracle, Sybase, MSSQL etc. have been available for quite some time, have many advanced features, but comes at quite a cost in money, maint, learning curve, and resources.  If you app needs high-end database functionality, then you have to be willing to part with some money, time, and resources.

  mySQL on the other hand has not been around as long as the commercial products, and has at it's foundation a small footprint with the majority of the learning curve in learning SQL and has a very low price - free.  So far, mySQL has worked extremly well in many of my apps.  Sometimes I have to rethink my design because I am thinking too much in the "large db" mindset, but that's me, not mySQL.

  It seems to me that you could really benefit from sitting down with the mySQL manual for a short spell, especially the part about mySQL Ansi 92 support.  It might be beneficial to also get aquanted with Oracle's proprietary aspects so you understand what features need a different solution because your assuming an Oracle feature is Ansi 92.

  This would be true no matter what DB product you pick up.  I got my start in SQL with MSSQL.  When I tried to get into Oracle I was ready to call Oracle a piece of garbage because I couldn't do anything with it.  The joins were different, the allocations different, the stored procedure language different, the permissions systems different.  But after weeks of working with the product, I began to learn the Oracle way and realized my judgement of Oracle was not based on the merits/demerits of Oracle, but on my lack of knowledge of the product and what it's target audience is.

  Jim
  ______________________________________________________________
  Jim Hendricks, President, Biz Computing, Inc
  Phone:  (201) 599-9380     Email: jim at bizcomputinginc.com
  Web: www.bizcomputinginc.com 
  Snail:  Jim Hendricks,  Biz Computing, Inc.,  255 McKinley Ave, New Milford, NJ 07646
  ______________________________________________________________

    ----- Original Message ----- 
    From: Phil Powell 
    To: NYPHP Talk 
    Sent: Sunday, September 21, 2003 2:17 PM
    Subject: Re: [nycphp-talk] Error involving inner SELECT using mySQL - HELP

    I did, it seems that mySQL is becoming more and more of a waste of database!

    Can't do subqueries, can't do foreign key constraints, even the datetime field column datatype doesn't allow for the now() function as an input parameter value in INSERT?.. so tell me what GOOD is mySQL anyway????

    I rewrote the entire database table schema relational structure to include another association table and used that, flatting out the query.  However, it's really BAD coding because I have this query generating for every single $row['nnet_produkt_id'] from the outer query results.  BAD BAD BAD.. that means a while loop INSIDE another while loop!

    Can you say performance murder!

    Phil

      ----- Original Message ----- 
      From: Jeff Siegel 
      To: 'NYPHP Talk' 
      Sent: Sunday, September 21, 2003 1:46 PM
      Subject: RE: [nycphp-talk] Error involving inner SELECT using mySQL - HELP

      You need at least ver. 4.1 of mySql. You may also be able to rewrite it.
      See: http://www.mysql.com/doc/en/ANSI_diff_Subqueries.html

      Jeff Siegel
        -----Original Message-----
        From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On Behalf Of Phil Powell
        Sent: Sunday, September 21, 2003 11:54 AM
        To: NYPHP Talk
        Subject: [nycphp-talk] Error involving inner SELECT using mySQL - HELP

        Ok guys, here we go again!

        SELECT s.nnet_produkt_storrelse_navn 
        FROM nnet_produkt_storrelse s, nnet_produkt_varegruppe v, nnet_storrelse_varegruppe_assoc sv 
        WHERE s.nnet_produkt_storrelse.id = sv.nnet_produkt_storrelse id 
         AND sv.nnet_produkt_varegruppe_id = v.nnet_produkt_varegruppe_id 
         AND sv.nnet_produkt_varegruppe_id IN (
           SELECT nnet_produkt_varegruppe_id 
           FROM nnet_produkt_varegruppe
           WHERE nnet_produkt_varegruppe_code =  'FLU17' 
         )
         AND s.nnet_produkt_storrelse_id > 1

        This produces the following error:

        You have an error in your SQL syntax near 'id AND sv.nnet_produkt_varegruppe_id = v.nnet_produkt_varegruppe_id AND sv.nnet_' at line 1

        I don't see anything wrong with this query, it's standard inner SELECT stuff!  I need help... again!

        Phil

--------------------------------------------------------------------------

      _______________________________________________
      talk mailing list
      talk at lists.nyphp.org
      http://lists.nyphp.org/mailman/listinfo/talk

----------------------------------------------------------------------------

    _______________________________________________
    talk mailing list
    talk at lists.nyphp.org
    http://lists.nyphp.org/mailman/listinfo/talk

------------------------------------------------------------------------------

  _______________________________________________
  talk mailing list
  talk at lists.nyphp.org
  http://lists.nyphp.org/mailman/listinfo/talk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030921/0b2b3336/attachment.html>

NYCPHP Meetup

NYPHP.org

[nycphp-talk] Error involving inner SELECT using mySQL - HELP