Recent content by Porshe

i get an error of sr=42000 unrecognized column name- what exactly is the syntax for doing a SELECT count on some column from datatable. maybe i'm putting spaces or something? please- any ideas?

it seems that when we do a SELECT Count- it doesn't seem to like the count keyword> any ideas?

We get the error when we run a query from another application you probably never heard of- Gensym. the test connection is okay.

Hi, I set up a connection for an SQL server on win2000 using ODBC. I keep getting an error message that says "Unrecognized column name encountered: UNKNOWN" -its connected to a local server -uses SQL Server authentication- login ID and password --uses ANSI quoted identifiers -use...

i tried goBoating's script and i get an error: Month '-1' out of range 0..11 i used the same data. i don't get it?

i'm going to be setting up a ODBC connection to a Microsoft SQL Server on a win nt machine. It is a local server -the database and ODBC are on the same machine. is there anything that I may need to know to make this successful? is it fairly simple? Thanks,

i'm going to be setting up a ODBC connection to a Microsoft SQL Server on a win nt machine. It is a local server -the database and ODBC are on the same machine. is there anything that I may need to know to make this successful? is it fairly simple? Thanks, Porshe

can anyone tell me if there is a module that could convert this: 10/30/2001 12:30:00 p.m to epoch seconds and will it convert the p.m or a.m also into seconds? thanks for the discussion above- it was really helpful!

ok- sorry... my field is called 'time' and it looks like this: 10/30/2001 12:30:00 p.m 10/29/2001 12:40:00 p.m 10/29/2001 12:40:00 a.m 10/03/2001 10:30:00 p.m 10/14/2001 1:00:00 a.m 10/30/2001 11:00:00 p.m i need to sort it by time that means that if time is in ascending order (time-a)...

hi, i'm trying to sort but i need to skip any spaces, colons and / in the line. any help? thanks!

ok- how about this... My $ip values are stored in a hash. When I send the argument- $ip to file2.pl I have multiple $ip values but it only prints out my last value that is stored in the hash. Is there anyway that I can print out all the values that are stored in $ip? Thanks!

When I get to my foreach my $ip loop, it gets about 4 different $ip results. so, each time it goes through the loop the value for $ip changes. When I get to my file2.pl it seems to be reading in only the last value for $ip. But because of the foreach loop I thought system will open file2.pl...

Thanks it works. Except now I have another problem: I have a loop in file1.pl something like: foreach my $ip (....) { .... #this opens my file2.pl system('export/manager/file2.pl, $ip, $report); system('perl file2.pl' $ip, $report); } In my file2.pl, I have this: $ip=$ARGV[0]...

I have in file1.pl this: system("/export/home/manager/ready/file2.pl", $ip, $report); system("perl proxy.pl $ip"); Which I believe passes the $ip and $report which $report= $date.pl. Now, in file2.pl I have: $report_file_name= $ARGV[0]; open IN...

Hi everyone! If I have file1.pl that creates a variable $report= $date.pl where $date= local, how can I open file2.pl and pass it the file name which is stored in $report? Thanks, Porshe