Search results for query: *

Hello all, Please can anyone help me with designing a database schema that I am having some difficulties with? What I have is a load of products that are offered by different shops, like a price comparison website. What I have at present is one table with a row for each product with the...

Hi, I need some help please on building an SQL query. Bear with me as I attempt to explain below: We have users attempting a purchase of a product, if they fail due to insufficient credit an entry is input in a DB table call rev_loss. Here is an example of a row in the table: created_t =...

Hi all, Please can someone help, can anyone explain why the following might suddenly be happening on our Solaris box?: Thu Jan 6 11:59:52 GMT 2005 pin:/export/home/pin> date Thu Jan 6 11:59:54 GMT 2005 pin:/export/home/pin> date Thu Jan 6 10:59:56 GMT 2005 pin:/export/home/pin> date Thu Jan...

Hi all, Please can someone help me or point me in the right direction? I have an excel sheet with example colum shown below: Ring^Standard 300 Image^Colour 150 Game^New 250 I need to create a formula which populates the cell next to it with the cost value (300 = 3 pounds, 150 = 1.50 ...) So...

Hi all, Please can I get some help. I need to copy some files for back up purposes into another directory. All the files are called "pin.conf". I can do: ================ #!/usr/bin/ksh cd /opt/6.5/ for filen in `find . -name pin.conf` do echo ${filen} done ==================...

Hi all, I have to update a table ACCOUNT with a msisdn and bdom (billing day of month) on production. I have a flat file for example: 123456 26 231231 26 131231 26 312312 26 (This is the msisdn in column1 and bdom in column2.) Normally I would then create a script which creates a file...

Hi all, Not sure if anyone can help or point me in the right direction. My windows has been acting funny. All apps look have changed, for example say you go to close notepad you get the window pop up saying do you wish to save before exit and you get the three buttons with writing in well I...

Hi all, Please could I have help with getting the difference bettween 2 values from a DB (they are in unix time format) and putting the output in hh:mm:ss. Below is an eaxmple of what I use to get a value in the format of DD-MON-YYYY on one field: SELECT...

Hi all, I am looking for some help on setting shared memory settings on our production servers, please see the background below: Our production server holds a third party billing product. The production server acts as an Oracle client and the DB is held on another server. On a certain day...

Hi all, I have the following problem which I'm sure is something to do with quoting issues? I want to get the number of lines from a file > num_lines and use this in a sed command to extract the contents to a new file e.g: ======================================= num_lines=`cat ${PINLOG} | wc...

Hi all, I need to read data from a file like e.g. thread:1 file1.c:200 thread:1 file1.c:255 thread:1 file1.c:300 thread:2 file1.c:300 thread:2 file1.c:455 thread:2 file1.c:100 I know how to get each item by e.g. for data in `cat data` do #do something done BUT how do...

Hi all, Please could I get some help with a problem I am having with a shell script, the code is below: ==================================================== #!/usr/bin/ksh set -A array0 green white yellow set -A array1 dog cat rabbit set -A array2 zero one two lj="${array0[1]}" echo ${lj}...

Please help: I have a data file which has many values per line eg: lemur/front-stats-2003102459:<apiCall start=&quot;1066950214507&quot; end=&quot;1066950216147&quot; remoteHost=&quot;xxx&quot; remoteAddr=&quot;xxx&quot; contractID=&quot;oranlc1&quot...

Please, can anyone help. My sound on my XP home is distorted playing any audio files - eg mp3 and also mpg, avi etc (everything!) This was all working fine since I got the computer (Aug) but its now distorted. If I put the speakers through the TV output its fine so it must be XP. It seemed...

I am trying to create a file to then view in excel. I am extracting data from one file (comma seperated) and sending the required fields to another in a .ksh shell script the below works fine but if I want to put a single quote (') before $2 how is this done? I've tried various ways and get...

Hi, I can't seem to delete TABS from say every line in a file? I have tried sed 's/[ \t]*$//' filename > newfile This should deleted all trailing TABS at the end of all the lines in filename? How do I get this to work , I cant use the TAB button in place of the \t from the command line? Thanks