Re: Probably a dumb question but I'm new to PEAR.
| From: | Malcolm Turnbull | Date: | Wed, 20 Mar 2002 17:09:42 +0000 |
| Subject: | Re: Probably a dumb question but I'm new to PEAR. | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-997@lists.php.net to get a copy of this message | ||
Stewart,
In order to prove you wrong I put the spaces back in...
and I didn't get the error again ..
So you were correct
and I am even more confused...
Regards,
Malcolm Turnbull
Group IT Manager -
Crocus.co.uk Ltd &
Waterers Landscape PLC
01344 629661
07715 770523
www.crocus.co.uk - For all your Garden Needs
www.stealthinventory.com - The Open Source Software Audit Tool
----- Original Message -----
From: "Taylor, Stewart" <Stewart.Taylor@uk.thalesgroup.com>
To: "'Malcolm Turnbull'" <malcolm.turnbull@crocus.co.uk>
Cc: <pear-general@lists.php.net>
Sent: Wednesday, March 20, 2002 4:43 PM
Subject: RE: [PEAR] Probably a dumb question but I'm new to PEAR.
> The spaces would not have caused an error: all whitespace (spaces, tabs
etc)
> are completly ignored by the parser (unless within quotes obviously).
>
> -Stewart
>
> -----Original Message-----
> From: Malcolm Turnbull [mailto:malcolm.turnbull@crocus.co.uk]
> Sent: 20 March 2002 16:32
> To: Jan Lehnardt; Morgan Christiansson
> Cc: pear-general@lists.php.net
> Subject: Re: [PEAR] Probably a dumb question but I'm new to PEAR.
>
>
> Now we are getting somewhere !
>
> thanks for the help !
>
> I'd already tried removing the ; from the query but that didn't help...
> but the point about the space between ) and { got me thinking...
>
> I changed
>
> $demoResult = $db->query($sql);
>
> to:
>
> $demoResult=$db->query($sql); // REMOVING THE SPACES
>
> which solved the problem.
>
> I guess I'm a newbie at PHP too..
>
> BUT now when I test for an error after the I get one bugger...
> the error returned is :
>
> DB Error: unknown error
>
> very useful..
>
> I shall keep playing
>
>
>
>
> Regards,
>
> Malcolm Turnbull
>
>
> Group IT Manager -
> Crocus.co.uk Ltd &
> Waterers Landscape PLC
>
>
> 01344 629661
> 07715 770523
>
> www.crocus.co.uk - For all your Garden Needs
> www.stealthinventory.com - The Open Source Software Audit Tool
>
> ----- Original Message -----
> From: "Jan Lehnardt" <jan@php.net>
> To: "Morgan Christiansson" <mog@linux.nu>
> Cc: <malcolm.turnbull@crocus.co.uk>; <pear-general@lists.php.net>
> Sent: Wednesday, March 20, 2002 4:18 PM
> Subject: Re: [PEAR] Probably a dumb question but I'm new to PEAR.
>
>
> > Hi,
> > On 20 Mar 2002 17:13:04 +0100
> > Morgan Christiansson <mog@linux.nu> wrote:
> >
> > > The problem is obvious. =)
> > >
> > > Just remove ; from the SQL query. A ; is only used in SQL clients to
> > > separate queries, API's only permit one query per function call
> > (unless
> > > they have made their own support for ; as most clients have).
> >
> > this wouldn't cause a parse error in PHP but an error from MySQL.
> >
> > Jan
> > --
> > Q: Thank Jan? A: http://geschenke.an.dasmoped.net/
> >
>
>
> --
> PEAR General Mailing List (http://pear.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>