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...
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...
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
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...
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"...
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'...
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'...
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...
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
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...
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...
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
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...
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
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...
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...
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.