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 Chriss Miller 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: *

  • Users: lhg1
  • Content: Threads
  • Order by date
  1. lhg1

    Automated login using commandling in ubunto

    Hi I would like to use an script to automaticly login to a webpage, and retrive the webpage to a txt file. I tryed to get it to work using curl curl --user name:password http://www.url.com -v >> webpage.log But this does not work, the page is buield in asp and has a form with the login and...
  2. lhg1

    How to use parameters in commanline PHP

    Hi I have a PHP script that I want to use from the commandline, and it has a parameter. Usally I use this in a browser http://host.dk/script.php?tid=2 where I in the script has this. if(!isset($_GET['tid'])) { $tid = "1"; } else { $tid = $_GET['tid']; } I can run it on the...
  3. lhg1

    Text lager then 7

    Hi Does anyone know how to get a tekst larger then 7. I currently using basic HTML in a PHP dokument. Thanks. Lars
  4. lhg1

    Replacing in php

    Hi Trying something witch should be simple. I have a string witch contains a , and i want to replace it with ',' echo preg_replace($patterns, $replacements, $string); echo preg_replace(,, ',', $string); but I'm running into problems with the, can't get the replacement done. Regards LHG
  5. lhg1

    2 SQL combined

    Hi I have 2 SQL's that gives me how - many total pr week - overdye pr week. I'd like it in one SQL and not having to excel the result This is total. SELECT YEAR(CONVERT(VARCHAR, DATEADD(ss, create_date - DATEDIFF(ss, GETDATE(), GETUTCDATE()), '1970-01-01 00:00'), 120)) As year...
  6. lhg1

    Grouping by hour

    Hi I'm trying to make a grouping by hour. The date is set as an integer, but that conversion is fine. I would like output like this Day Amount 01-01-2010 10 02-01-2010 12 03-01-2010 9 In ORACLE something like this SELECT to_char(date, 'yyyy-mm-dd hh24') "Dato"...
  7. lhg1

    SQL Deviding a Grupping

    Hi I am using this piece of code to deliver a status regarding a system select decode(area, 'B','BATCH', 'G','RESEND', 'Y','CR_FIX', 'N','IT_FIX', 'Q','ANALYSIS_IN_PROGRESS', null,'UNKNOWN'...
  8. lhg1

    Deviding a Grupping

    Hi I am using this piece of code to deliver a status regarding a system select decode(area, 'B','BATCH', 'G','RESEND', 'Y','CR_FIX', 'N','IT_FIX', 'Q','ANALYSIS_IN_PROGRESS', null,'UNKNOWN'...
  9. lhg1

    Not selecting if the varchar contains letters

    Hi I'm usint this sql to sort a varchar field, and i works. select field1, field2 from table order by CAST(field1 AS INT) but when just one row contains a letter the sql doesn't return any rows, until the data in the field is an integer again. Is there a way to get it out anyway? - either...
  10. lhg1

    ORDER by on varchar field

    Hi I want to order by a field - that contains a number. But the DB field is a varchar insted of an intiger. This is my sql select field1, field2 from table order by field1 the result is it should be Does anyone know how to sort by number? Thanks LHG
  11. lhg1

    Slow WLST script

    Hi I have a wlst script that is very slow. It can take over 1 hour to run. It is collecting IdleThreads. We have a Dashbord that collects the same, and running a lot quicker. Can any body tell me how to optimize the script. It is running like this. ./wlst.sh scripts/MonitorThreads.py...
  12. lhg1

    SQL join problems

    Hi I building an SQL that retrives data from a lot of tables. But one of the identifiers is not always there, giving me a lot of problem. ex1 - this works as long as g.p_number_import_seq existe, witch is not all the time. select c.campaign_id, d.birth_date, d.first_name,d.last_name...
  13. lhg1

    Only returning enteries with Data

    Hi I have a SQL that returns quite a lot of colums. I using Toad and whot I want is to only return the colums that contains data. Its a select * and the colums that have data are not always the same. My quistion. Is there any way to only return colums that contain data? Regards LHG
  14. lhg1

    Amount pr. week

    Hi I have a need list a amount pr. week but since the date format is quite tricky I can't get it to work. This is an sql to get the tickets. SELECT ticketid CONVERT(VARCHAR, DATEADD(ss, TIME_WORK_START - DATEDIFF(ss, GETDATE(), GETUTCDATE()), '1970-01-01 00:00'), 120), from table The...
  15. lhg1

    X grafik client

    Hi I'm usaly using putty to access my unix platforms. But I have the need to run X grafik I'm familiar with WRQ reflection X - but am looking for a freeware product. Any ideers, or experiences? Thanks lhg
  16. lhg1

    Selecting todays events

    Hi I have a date format that is giving me trouble. I have to convert dates into numbers every time. What I want is an sql that can give me tickets where TIME_WORK_START is today TIME_WORK_START = '21-07-2009' This is an eksample that shows all the tickets from now and 250 hours forward...
  17. lhg1

    Perl script to monitor URLs

    Hi I'm trying to buield a perl script to do simple URL monitoring of URLs I have 2 problems 1. Can't get imput parameters, only when its hardcoded into the script. ex urlcheck.pl www.msn.com I can't get it to accept $url insteed og the hardcoded 2. The check tekst has to be very excact, I...
  18. lhg1

    Help finding Unix admin system

    Hi I'm looking for a system where I can execute unix commands/scripts om unix servers. The idea is to give "Non Unix people" access to execute predefined commands or execute scripts on a server. Ex. Service desk that has the ability to unlock users. Monitoring people can start a deamon when...
  19. lhg1

    Outlook file from recovered partition.

    Hi I've restored a Vista system disk. But I can't seem to find the outlook file. I been looking for the .pst file, but no like that exists on the system. Anyboddy know har to find the data? It was outlook 2007. Regards LHG
  20. lhg1

    Vista won't boot - can't repair

    Hi I have a laptop Vista machine, that won't boot. Every time i start it it goes into windows repair, and can't repair the error. I have no system restore points on it. I have data on there that I need. Best thing would be to get windows to work again. Secound best, get data extracted from...

Part and Inventory Search

Back
Top