Search results for query: *

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

Hi. I have file.pl that generates data to a result file- data.pl. In the middle of the process, it stops and system opens another file for output. How can I get all the output from 2 different scripts to write to 1 output file (data.pl)? #This is my result file that is opened in file.pl open OF...

Hi! I have a main program that has a big foreach ($ip) loop. In this loop it calls many subroutines. When it goes into a subroutine, how can I get it to go back to the start of the foreach loop? I've tried next and return, but I don't want it to exit out of the main program. sub ShowError {...

Hello! How can I import a value (say $out=123) from find.pl to last.pl? Thanks, Porshe

Hi! I have a script called find.pl that has a variable $source= 132.45.76.89; ($source changes with each foreach loop that I have). I have another script called last.pl that needs to take $source from find.pl, do some stuff with it and give find.pl the results. I'm thinking that I can open...

Hi! I have a quick question. I'm trying to download the IO:Socket module but it seems that there's only the IO:Socket::SSL module that took over the IO"Socket::INET module. Then you have to download another module NET::SSLEAY then you have to download an open SSL file. Does anyone know of a...