Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. maximo1970

    Simple Question

    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.
  2. maximo1970

    See if you can help

    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")...
  3. maximo1970

    See if you can help

    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...
  4. maximo1970

    Getting lots of Event ID 33808.

    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.
  5. maximo1970

    New to MySQL.

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

    New to MySQL.

    Is it possible to Query the results of a Query?
  7. maximo1970

    Dynamic Menus

    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...
  8. maximo1970

    Create dynamic HTML

    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.
  9. maximo1970

    Create dynamic HTML

    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).
  10. maximo1970

    Create dynamic HTML

    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...
  11. maximo1970

    cgi.pm generated HTML question.

    Good stuff, thanks for that.
  12. maximo1970

    cgi.pm generated HTML question.

    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'}));
  13. maximo1970

    Comparing SQL Data.

    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...
  14. maximo1970

    Comparing SQL Data.

    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...
  15. maximo1970

    Any Ideas

    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...
  16. maximo1970

    Not sure how to do this.

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

    Not sure how to do this.

    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...
  18. maximo1970

    Not sure how to do this.

    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...
  19. maximo1970

    Not sure how to do this.

    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...
  20. maximo1970

    Not sure how to do this.

    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...

Part and Inventory Search

Back
Top