Re: Strange Problem with Update command

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>
>   update nsefu_stock set symbol = 'WOCKPHARMA-27APR2006xyz' , exchange =
> 'NSE' , series = '' , ind_code = '', grp_code = '', ltp = '514.1', ltq =
> '6', change_percent = '0.6', volume = '658800', atp = '515.11',
> record_date = '2006-03-31', day_open = '512.9', high = '519.8', low =
> '506.2', day_close = '511.05', tsq = '225600', tbq = '123000',
> update_lock = '0' where symbol='WOCKPHARMA-27APR2006' and
> record_date='2006-03-31'   and run in PhpMyAdmin it is updating the
> record
>
>   The only difference in both queries is i changed the set symbol =
> 'WOCKPHARMA-27APR2006xyz'
>

how do you define "symbol" in database?? as varchar or char???

(i guess it's a char > 20 )


-- 
José Miguel Santibáñez
    jms@xxxxxxxxx


PHP Data object relational mapping generator
http://www.metastorage.net/ 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php-objects/

<*> To unsubscribe from this group, send an email to:
    php-objects-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Soap]     [Kernel Newbies]     [Yosemite]     [Yosemite Campsites]

  Powered by Linux