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?
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'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)...
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 {...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.