downloading data as text file

Hi!! I need to provide the users that access my database a way to download data as a text file. The data is stored in a mysql database, has anyone done this, if so I would really appreciate their help. Thanks and Cheers always!! Murli -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional c

Re: checking if its a real number

Thanks to all for replying to my questions. Cheers always!! Murli zentara wrote: On Wed, 26 Feb 2003 16:30:56 -0800, [EMAIL PROTECTED] (T. Murlidharan Nair) wrote: I have a cgi that need to accept only numeric values. ie +ve or -ve real numbers. Is there a quick and easy way to check this

checking if its a real number

I have a cgi that need to accept only numeric values. ie +ve or -ve real numbers. Is there a quick and easy way to check this. I was trying using a reg exp if(/^[-0-9][\.0-9]*/) { do something } but this breaks when the number is say --75.4 It still accepts if it has two - signs. Thanks for

NULL insertion

Hi!! I need to insert NULL into the database using a perl CGI . So if a variable is to be made NULL in perl and it needs to be used in an sql statement what is best way to do it. Do I assign ' \N' to it or 'NULL' ? Thanks and Cheers always!! Murli -- To unsubscribe, e-mail: [EMAIL PROTECTED] Fo

Re: Graphs on the fly

Does this work for Unix? Which module do I use for Unix ... Thanks and Cheers always!! Murli [EMAIL PROTECTED] wrote: In a message dated 1/14/2003 4:33:13 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Can anybody tell me how to install GD for Active State Perl? Thanks a lot.

Graphs on the fly

Hi !! Does any one have a module that I can use to generate bar graphs using a cgi ? Thanks and Cheers always!! Murli -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Nested hash

Hi!! I have a CGI that updated a mysql database, I have a nested hash structure in it. something like $repeats{$solID[i]}{$expId[i]}{$elemenet[$i]}=1 If I am to check this hash is the inner loop written as foreach $k1 (keys %repeats){ foreach $k2 (keys %re

Checking for existance for data in a column

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

Another Hash ref question

I am writing this as part of a module, so it prints fine in the main but not in the method... Any suggestions . sub new{ while (my $hashRef = $sth->fetchrow_hashref()) { foreach $keys(keys %$hashRef){ $self->{'_colData'}{$keys}=$$hashRef{$keys}; pr

fetchrow_hashref

Hi!! I am retriving data in a while loop using fetchrow_hashref How do I assign it to another hash. I am trying the following while (my %hashRef =$sth->fetchrow_hashref()){ foreach $keys (keys %hashRef){ print $keys; print "$hashRef{$keys}\t"; } p

Writings PERL CGI in windows environment

Hi!! Has any one written something similar to using a LWP user agent under windows environment ? If you have an example code that greatly help. Cheers always!! Murli -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Perl MSGraph

Hi!! I must confess this is not a Perl CGI question, but,since we have some Perl gurus here I am taking the liberty to ask this question, hoping that someone might be able to help me out. Has anyone used the MSGraph module developed by Mark Solomon? I am getting having problems with his example

Perl CGI Object handling

Hi !! Well, I am not sure how to pose this question properly, but let me give it a try. I am have a cgi that reads the file and loads it into a mysql database. The entire file is read as an object and the methods associated with that object then does all the work like chacking the data formats and

Oracle stored procedures and Perl CGI

Hi All: This for the benifit of all. I had a wonderful time discussing this topic with David Kirol (one of the members in the list) and was finally able to solve it. David had the following comments " I can think of two approaches. The first involves dynamically creating a temporary table