Search results for query: *

Hi all, I'm trying to run a Macro in Excel 2000 at startup. I ca't see that there is a command line to do this, Microsoft seemed to have removed it from Office 97. My basic plan is to convert a number of XLS spreadsheets into a CSV text files, but need to remove and change some of the data first.

Tony, Tried your suggestion of "SELECT ... datefield LIKE '$date\%'". This didn't work sadly. Here's my current code as it may help. my $curs = $dbh->prepare("SELECT Device_Name, Event, Checked, Comments FROM tbl_event_log WHERE Device_Name = \"$ipaddress\" GROUP BY Checked DESC LIMIT 5")...

Sorry about the subject line but I can't think of how to describe my problem. My DataBase table contains a field for the date and time, ie 2004-03-06 21:34:12. I want to group by the date only, ei 2004-03-06. I'm using perl to select the data which is then displayed on a web site. I have the...

An error occurred while processing a B2D command.^` Drive: ReadFMTable() CreateFile failed (e:\10.201.5.10\B2D001278.bkf). Error=2 Anyone else seen this before and have an idea on how to fix the problem. Veritas support just say that it's an error that occurs, not very helpful.

Nice and simple, I thinking a long those lines. Thanks for your help.

Is it possible to Query the results of a Query?

Let's start of with the code : my $cur = $dbh->prepare("SELECT Device_Name FROM tbl_admin_systems"); $cur->execute(); my $menudata = $cur->fetchall_arrayref(); my $q = CGI->new; my $action = "/cgi-bin/serverstatus.pl?"; my $menu_value = $q->url_param('ServerList'); my...

Thnaks rosenk, does the I need. I must spent some time going over array's again, one day I'll work it out. Cheers for your help.

Thanks for that, rosenk. However I'm only getting one menu item in my list where as I was getting the entire column of data (array's anyway).

How do I get the real value and not the arrayref into my menu list from this source data? my $cur = $dbh->prepare("SELECT Device_Name FROM tbl_admin_systems"); $cur->execute(); my $menu = $cur->fetchall_arrayref(); my $q = CGI->new; print $q->header; print...

Good stuff, thanks for that.

I'm trying to form a refresh on a page but can't seem to get it function. Using the following code :- my $q = CGI->new: print $q->header; print $q-start_html('Live Status Report', -head=>meta({-http_equiv=>'Refresh'}));

Got my code working but it's causing a number of duplicate errors when passing the data to my table, it clearly something todo with the way my code is looping. Any ideas would be most welcome. my $srvinfo; my @srv; my $sth = $dbh->prepare("SELECT Device_Name, IP_Address FROM...

I'll try and explain the best I can on this one. I have a MySQL table (tbl_disk_space) that I want to populate :- Device_Name Drive Size Used Free server1 C server1 D server2 C 10 1 9 server2 D 5 4 1 My data source is split into the $drive...

Running a mail script on a windows web server and get the following error :- Net::SMTP: Bad protocol 'tcp' at mailer.pl line 13. The script runs fine from the command line but not in the browser. Line 13 contains, $smtp = Net::SMTP->new('(smtp server in here)', Hello => '(Customers...

Philote, Good stuff, it works!!!!!!!!!!!!!!!!!!!!!!!! Great stuff and thatnks for your help.

The servers that this will run on have upto 8 NICS all with different names and address. So I'm trying to get the code to produce this type of output : servername, LAN, 192.168.1.200 servername, SWITCH1, 192.168.1.210 servername, SWITCH2, 192.168.1.220 Once I have the output right I can then...

Philote, Yes I'm all ready to go. I just can't seem to get the output right. I'm sure it's just my code and my lack of Perl knowledge. Here's a version of my code that doesn't work, at least it's a starting point: use strict; use DBI; my ($dbname, $host, $user, $password) = qw...

Thanks for the replies, Perl is installed on each of the servers, so what I'm looking to do is process the information with out the need to transfer text files around. I'm basicly just trying to this output into a database :- servername, LAN, 192.168.1.200 servername, SWITCH1, 192.168.1.210...

I'm trying to gather host information on a number of Windows Boxes. The information source is "ipconfig /all". I want to populate a MySQL DataBase with the following information :- Host Name . . . . . . . . . . . . : servername Ethernet adapter Local Area Connection: (Only the section...