Re: mysql NULl value in perl problem

2002-12-05 Thread Matthew Baranowski
Hi David: I am assuming you are using DBI. I am not quite sure what you are asking, but here is some code that might help: while ($hashref = $sth->fetchrow_hashref) #while there are records in the query ... { DO SOME STUFF } The above code is a pretty traditonal way to deal with a statement h

Re: mysql NULl value in perl problem

2002-12-05 Thread Qunfeng Dong
Isn't NULL value in MySQL stored as '\N'? If so, you can check that in your perl script. Qunfeng --- David Wu <[EMAIL PROTECTED]> wrote: > Hi guys, > > Running into a frustrating problem. When I have a > empty table in mysql > database, i tried run a select statement in my perl > script and

Re: mysql NULl value in perl problem

2002-12-05 Thread Paul DuBois
At 14:59 -0800 12/5/02, David Wu wrote: Hi guys, Running into a frustrating problem. When I have a empty table in mysql database, i tried run a select statement in my perl script and supposing get a NULl return value. Is the NULL returned from mysql is described as string in perl or as undef i