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

ersity of California, San diego, La Jolla, CA 92093, USA Lab: 858-822-0887 Res: 858-277-8809 http://www.sdsc.edu/~nair - -- 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 and

Script for making declarations

Hi!! I had send this request some time back and I am still looking for a code that will help me make declarations. If you use strict then every variable has to be declared using my and that is what I want to achieve. Let me know if anyone has as script that does this. Thanks and cheers always!!

Script for making declarations

Hi !! Is anyone aware of a script that I could use to make declarations in my perl code. I have a huge CGI which does all the work and it does not use strict. It was written by someone else, and I am cleaning it up. I have broken up this CGI into atleast 10 different CGI's, I now have to mak

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

Oracle stored procedures and Perl CGI

Has anyone executed a stored procedures from a perl CGI. I am having problems when there are many rows returned. I need to finish this soon so please help. Murli The following is my pl/sql code CREATE OR REPLACE PROCEDURE new_worker_select_cur ( f_name IN OUT varchar2, l