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

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

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]

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.

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

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

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; }

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};

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

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 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