On Thu, 26 Jul 2001, Dave Cramer wrote:
> ebox=# select eitemcode,itemavail from inventory where itemavail = 1
> limit 1;
> eitemcode | itemavail
> -----------+-----------
> 6100122 | 1
> (1 row)
>
> ebox=# update inventory set itemavail=0 where eitemcode=6100122;
> UPDATE 0
Did eitemcode get left padded with some whitespace character(s)?
Rod
Rod
--
Remove the word 'try' from your vocabulary ...
Don't try. Do it or don't do it ...
Steers try!
Don Aslett