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

    here you go CREATE OR REPLACE PROCEDURE UPDATE_INSERT_LAST_CALL( val_msisdn IN VARCHAR2, val_imei IN VARCHAR2, val_imsi IN VARCHAR2, val_call_date IN VARCHAR2) AS val_count NUMBER; val_count1 NUMBER; old_imsi NUMBER; old_imei NUMBER; BEGIN dbms_output.put_line('The next...
  3. TheNewbie81

    stored procedure help

    i managed to do it, i never wrote SQL before so got my head around it in the end.
  4. 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 =...
  5. 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...
  6. TheNewbie81

    Ways to reach private variables in another module?

    Hi, Would that all work if Test2.pm was Test2.pl ?? im having a similar problem
  7. TheNewbie81

    Perl FTP Remote Rename problem

    cheers it was permissions!
  8. TheNewbie81

    Perl FTP Remote Rename problem

    Hi, im getting this "Couldn't rename at ftp.pl line 20" looks like its not picking up the file name??
  9. 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@')...
  10. TheNewbie81

    using find in perl system or qx ?

    thanks guys, much appreciated!
  11. TheNewbie81

    using find in perl system or qx ?

    cheers for the help guys, one more thing .. so can i have @list = qx{find $DIR -name "file" -exec ls {} \\;}; print "@list\n"; or am i being too simple here? :)
  12. TheNewbie81

    using find in perl system or qx ?

    hi sorry, in the case of system(qq[find $DIR -name "file" -exec ls {} \\;]); this prints out all the files to the screen when i execute the script. in the case of qx{find $DIR -name "file" -exec ls {} \\;}; this prints nothing at all? I thought qx and system where similar?
  13. 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!!
  14. TheNewbie81

    interactive shell within perl program?

    cheers for responding. abit of background would help i suppose. I want to the program to be able to start a x25 session to a HLR. in the perl script i will have options for the user to specify the HLR they wish to connect to, this will then open a shell towards this network node that the use...
  15. 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