Re: Checking for existance for data in a column

2002-12-03 Thread Jason Purdy
You can most likely preclude empty/invalid data with SQL. Let's say your field/column name is 'name'. Then with your DBI prepare() call, you can preclude records where name is blank, null, or whatever you'd like. $sth = $dbh->prepare( 'SELECT * FROM table WHERE name IS NOT NULL' ); $sth->execute

Re: Checking for existance for data in a column

2002-12-03 Thread fliptop
On Tue, 3 Dec 2002 at 09:36, T. Murlidharan Nair opined: TMN:any calculations on them obviously. How do I check whether TMN:the column contains data, once I have retrived all the data TMN:using fetchrow_hashref(). you probably should ask on a dbi list. http://www.isc.org/services/public/lists/