Re: Very queer errors with Postgres/PHP
| From: | Nathan Crause | Date: | Sun, 19 Nov 2000 14:56:05 +0000 |
| Subject: | Re: Very queer errors with Postgres/PHP | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-4551@lists.php.net to get a copy of this message | ||
Okay, let me see if I can make sense here. Since the error reads "Attribute
't' not found, we can therefore assume that $user is set to "t". Even if
member_id is numeric (or serial or int), it still stands to reason that the
parser is finding an ALPHANUMERIC string (not a number), so it's trying to
find an attribute called 't' instead of purely comparing values. If you can
simulate this error at all, I would suggest you echo the value of $user and
see what it is.
The errors on line 26 and 53 are purely because the pervious lines failed,
and the result variable was not able to be set.
I hope this helps.
"Jeff MacDonald" <jeff@hub.org> wrote in message
news:Pine.BSF.4.21.0011171305240.74672-100000@rage.hub.org...
> the datatype is int4 (actually it's a serial, samething..) there fore
> i didn't use the ''s.. funny thing is tho, i haven't been able to
reproduce
> this error, only my client could. i hate when that happens.
>
> jeff
>
> On Fri, 17 Nov 2000, john slee wrote:
>
> > On Thu, Nov 16, 2000 at 10:19:06PM -0400, Jeff MacDonald wrote:
> >
> > [ snip ]
> >
> > > but.. here's the said lines in each file..
> > >
> > > line 25
> > > $select = pg_exec($dbh,"SELECT password FROM members WHERE member_id =
$user");
> >
> > does it give the same errors if you put ' ' around the $user?
> > we've had similar problems before, but since you haven't stated the data
> > type of member_id.......
> >
> > [ snip ]
> >
> > j.
> >
> >
>
> Jeff MacDonald,
>
> -----------------------------------------------------
> PostgreSQL Inc | Hub.Org Networking Services
> jeff@pgsql.com | jeff@hub.org
> www.pgsql.com | www.hub.org
> 1-902-542-0713 | 1-902-542-3657
> -----------------------------------------------------
> Facsimile : 1 902 542 5386
> IRC Nick : bignose
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>