It's a book to buy...
On Wed, 9 May 2001, Gyozo Papp wrote:
>
> Hello,
>
> Joe Celko's 'SQL for Smarties'. Is it a book ( to buy :( )
> or is it available on the web (download :) )?
>
> If the latter stands please can you give me a link to it?
>
>
> ----- Original Message -----
> From: "Philip Hallstrom" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: 2001. május 8. 21:33
> Subject: Re: [PHP] Recursive SQL Queries: Web Directory Categories
>
>
> > Also take a look at Joe Celko's 'SQL for Smarties'. There's a whole
> > chapter on this. It gets kind if burly, but it's pretty cool. It's all
> > done by converting your schema below into a tree structure...
> >
> > (no, i don't have any code since I've just read about it never done it
> > :)
> >
> > -philip
> >
> > In article <[EMAIL PROTECTED]>,
> > Krznaric Michael <[EMAIL PROTECTED]> wrote:
> > >James,
> > >
> > > Take a look at hierarchical queries in MS SQl. If I'm not mistaken,
> > >this is part of the SQL 99 standard and is implemented by many SQL 92
> > >compliant database vendors. I know ORACLE and DB2 support it. I'm not sure
> > >if you already have but I would investigate this topic with MS SQL.
> > >
> > >Mike
> > >
> > >
> > >-----Original Message-----
> > >From: James Crowley [mailto:[EMAIL PROTECTED]]
> > >Sent: Monday, May 07, 2001 1:45 PM
> > >To: [EMAIL PROTECTED]
> > >Subject: [PHP] Recursive SQL Queries: Web Directory Categories
> > >
> > >
> > >Hi,
> > > I have a web directory which allows sub-categories to an unlimited
> > >level.
> > >This is done with a categories table, and assigning a parentid to each...
> > >For example
> > >
> > >ID ParentID Name
> > >1 0 Products
> > >2 1 Sub-Category of Products (Level 1)
> > >3 1 Another Sub-Category (Level 1)
> > >4 2 A sub-sub-category (Level 2)
> > >
> > >What I need to do is return a list of an items parent categories. For
> > >example, if we are in category 4, I want text outputted saying
> > >
> > >Products \ Sub-Category\sub-sub Category
> > >
> > >However, it does not seem possible to do this with a single SQL query. I
> > >have succeeded in creating a recursive one below (in MS SQL):
> > >
> > >CREATE PROCEDURE dbo.dir_recurse(@parentid INT) AS
> > > --// List its parent categories
> > > DECLARE @childid INT
> > > DECLARE hC CURSOR LOCAL FOR SELECT parent FROM categories c WHERE id =
> > >@parentid ORDER BY c.name FOR READ ONLY
> > > OPEN hC
> > > FETCH NEXT FROM hC INTO @childid
> > > WHILE @@FETCH_STATUS = 0 AND @childid != 0
> > > BEGIN
> > > EXECUTE dir_recurse @childid
> > > FETCH NEXT FROM hC INTO @childid
> > > END
> > > CLOSE hC
> > > DEALLOCATE hC
> > > RETURN 0
> > >GO
> > >
> > >However, this returns more than one result set, which neither ASP or PHP (so
> > >therefore it's probably the ODBC driver...) seem to support. Help!
> > >
> > >Regards,
> > >
> > >- James
> > >
> > >Editor, VB Web
> > >==================
> > >Web - http://www.vbweb.co.uk
> > >Email - [EMAIL PROTECTED]
> > >ICQ# - 60612011
> > >==================
> > >
> > >> -----Original Message-----
> > >> From: [EMAIL PROTECTED]
> > >> [mailto:[EMAIL PROTECTED]]
> > >> Sent: 06 May 2001 20:11
> > >> To: [EMAIL PROTECTED]
> > >> Subject: php-general Digest 6 May 2001 19:11:22 -0000 Issue 670
> > >>
> > >>
> > >>
> > >> php-general Digest 6 May 2001 19:11:22 -0000 Issue 670
> > >>
> > >> Topics (messages 51587 through 51649):
> > >>
> > >> IIS instead of PWS!!! what else can i do..
> > >> 51587 by: Thomas Edison Jr.
> > >> 51588 by: Zak Greant
> > >> 51591 by: Thomas Edison Jr.
> > >> 51592 by: Thomas Edison Jr.
> > >> 51593 by: Zak Greant
> > >> 51594 by: Alexander Skwar
> > >>
> > >> Re: PHP on PWS not working!
> > >> 51589 by: Thomas Edison Jr.
> > >> 51590 by: Thomas Edison Jr.
> > >> 51600 by: Phil Driscoll
> > >> 51640 by: Thomas Edison Jr.
> > >> 51644 by: Phil Driscoll
> > >>
> > >> Re: Sorry, what is "PWS"
> > >> 51595 by: Alexander Skwar
> > >>
> > >> Re: "Free" Database Design Program
> > >> 51596 by: Andrzej Swedrzynski
> > >>
> > >> Novedades en Gordos.com
> > >> 51597 by: Gordos.com
> > >>
> > >> PHP as apache module and security.
> > >> 51598 by: Andrzej Swedrzynski
> > >> 51607 by: Estelle Martin
> > >> 51609 by: Andrzej Swedrzynski
> > >>
> > >> Re: nslookup function ?
> > >> 51599 by: Tom Carter
> > >>
> > >> Complete Newbie
> > >> 51601 by: biscut
> > >>
> > >> What is msvcr70.dll??
> > >> 51602 by: Ermanno Iannacci
> > >>
> > >> Re: PEAR where should I start?
> > >> 51603 by: Gyozo Papp
> > >>
> > >> Image displaying problem
> > >> 51604 by: Estelle Martin
> > >>
> > >> Re: class (not class instance) variables
> > >> 51605 by: Gyozo Papp
> > >>
> > >> Re: quicker query?
> > >> 51606 by: Gyozo Papp
> > >>
> > >> searching a MySQL database
> > >> 51608 by: Jamie Saunders
> > >> 51620 by: bill
> > >> 51623 by: John Vanderbeck
> > >>
> > >> Insert data into mysql table
> > >> 51610 by: Mohamedou
> > >>
> > >> Re: wordwrap
> > >> 51611 by: Yasuo Ohgaki
> > >>
> > >> php4apachi.dll
> > >> 51612 by: Darren
> > >>
> > >> best ide for windows
> > >> 51613 by: Alexander Bierbrauer
> > >> 51615 by: Gyozo Papp
> > >> 51617 by: Geir Eivind Mork
> > >> 51618 by: John Vanderbeck
> > >> 51626 by: Henrik Hansen
> > >> 51628 by: Andrzej Swedrzynski
> > >> 51629 by: Gyozo Papp
> > >> 51630 by: Alex Piaz
> > >> 51633 by: Alexander Skwar
> > >> 51634 by: Bjorn Sodergren
> > >> 51635 by: Andrzej Swedrzynski
> > >> 51637 by: John Vanderbeck
> > >> 51639 by: Andrzej Swedrzynski
> > >>
> > >> php.exe [filename .php] vs. run [filename.php] via webserver
> > >> 51614 by: Art
> > >>
> > >> Install problems with PHP and GD
> > >> 51616 by: John Vanderbeck
> > >>
> > >> if string contains...
> > >> 51619 by: Jamie Saunders
> > >> 51621 by: Alvin Tan
> > >> 51622 by: Gyozo Papp
> > >>
> > >> Slightly OT - Backing up mySQL...
> > >> 51624 by: Nick Terzich
> > >> 51625 by: Felix Kronlage
> > >> 51627 by: Henrik Hansen
> > >>
> > >> Re: simple database extraction problem :(
> > >> 51631 by: Manuel Lemos
> > >>
> > >> Can php give me row number?
> > >> 51632 by: Jan Grafstrvm
> > >> 51636 by: Gyozo Papp
> > >> 51642 by: Stephan Ahonen
> > >>
> > >> Flash/PHP/MySQL
> > >> 51638 by: FredrikAT
> > >> 51641 by: Eduardo Pirez Jover
> > >>
> > >> Passing variables to another page - newbie
> > >> 51643 by: Dean Martin
> > >> 51645 by: Jack Dempsey
> > >> 51646 by: John Vanderbeck
> > >> 51647 by: tcuhost.hotmail.com
> > >>
> > >> [OT?] permission denied[OT?]
> > >> 51648 by: Alexander Bierbrauer
> > >>
> > >> file() shooting blanks
> > >> 51649 by: Jay Lepore
> > >>
> > >> Administrivia:
> > >>
> > >> To subscribe to the digest, e-mail:
> > >> [EMAIL PROTECTED]
> > >>
> > >> To unsubscribe from the digest, e-mail:
> > >> [EMAIL PROTECTED]
> > >>
> > >> To post to the list, e-mail:
> > >> [EMAIL PROTECTED]
> > >>
> > >>
> > >> ----------------------------------------------------------------------
> > >>
> > >
> > >
> > >--
> > >PHP General Mailing List (http://www.php.net/)
> > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >For additional commands, e-mail: [EMAIL PROTECTED]
> > >To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > >
> > >--
> > >PHP General Mailing List (http://www.php.net/)
> > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >For additional commands, e-mail: [EMAIL PROTECTED]
> > >To contact the list administrators, e-mail: [EMAIL PROTECTED]
> > >
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
