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
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/
Thanks again everyone. Based on your input, reading the docs, and doing some
evaluation of our own needs, we decided on Red Hat 8.0, which comes with
Perl 5.8.0, Apache 2.0, and with the mod_perl package. It all goes on a Dell
PowerEdge 2600 144 GB (108 usable) RAID 5 with a 512 MB Xeon. Sweeet
On Monday, Dec 2, 2002, at 14:34 US/Pacific, james lundeen wrote:
[..]
i too need to know exactly how to do this. anyone
out there that can help us, it would be much appreciated!-jim
--- Will <[EMAIL PROTECTED]> wrote:
[..]
My questions have been - 1.) "How do I create the
library?", and
Hi!!
I have a CGI that looks up data from a mysql data base and
does a bunch of calculations. I only want to do calculations
on the columns which contains any data. What I mean is for
some colums there is no data available at all. So I don't want to do
any calculations on them obviously. How do
Thanks to all for your input on this.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
On Mon, 2 Dec 2002 21:28:49 -0600, "Scot Robnett" <[EMAIL PROTECTED]> wrote:
> I am working with a university on a web project which entails setting up a
> new server. We're going with Red Hat Linux on Dell hardware (RAID 5
> configuration), but I
On Mon, 2 Dec 2002 at 21:28, Scot Robnett opined:
SR:I am working with a university on a web project which entails setting up a
SR:new server. We're going with Red Hat Linux on Dell hardware (RAID 5
SR:configuration), but I am not sure which version of Perl to recommend. I am
SR:very used to 5.005
thank you for posting this detailed question. i too need to know exactly how to do
this. anyone
out there that can help us, it would be much appreciated!-jim
--- Will <[EMAIL PROTECTED]> wrote:
> Greets Folks,
>
> I usually lurk on this list, but I came across an
> issue which I could rea
