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!

  • Congratulations dencom 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. TheNewbie81

    Help with subquery

    hi, I have what i thought was a simple inner query ( new to SQL), i want to first return all records where the time is between a and b and then query the results to find num. i cant see whats wrong with it, any ideas? SELECT NUM FROM CC_SESSION_TABLE WHERE SESSION_NUM =...
  2. TheNewbie81

    stored procedure help

    Hi i have a SP below. which does the following, it takes a triplet of values (msisdn,imei, imsi) and based on the timestamp with the triplet either inserts into table A or Updates the Triplet Timestamp in table A if exists, while also writing to Table B. A = ACTIVE_HANDSETS B =...
  3. TheNewbie81

    return column names using DBI?

    hi, can anyone tell me whats the best way to return the column names for each table to a perl script. I have written a script that retrieves all the values in a table and formats it into HTML. The only thing is that I am unsure how to retrieve the column names. The perl module installed does...
  4. TheNewbie81

    Perl FTP Remote Rename problem

    Hi, I am trying to rename files ona remote server using this simple bit of code, but it doesnt work, can anyone point out what im doing wrong? cheers Jon #!/usr/bin/perl use Net::FTP; $ftp = Net::FTP->new("localhost", Debug => 0); $ftp->login("anonymous",'-anonymous@')...
  5. TheNewbie81

    using find in perl system or qx ?

    hi, why in perl does this return what i want: system(qq[find $DIR -name "file" -exec ls {} \\;]); but this returns nothing? qx{find $DIR -name "file" -exec ls {} \\;}; where $DIR = directory read in from input. Its bugging me!!
  6. TheNewbie81

    interactive shell within perl program?

    Hi, Im trying to start an x25 session from within a perl script. Basically im trying to create a small script which allows a user to enter an x25 address, the script will then execute a x25 command and connect to a device and display the shell of the device so that it can then receive commands...

Part and Inventory Search

Back
Top