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 strongm 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
  • Order by date
  1. lhg1

    Automated login using commandling in ubunto

    Hi I installed twill on an ubunto linux like this. sudo apt-get install python-twill In the HTML file I can se that the username is added, I cant se the code, I'm not sure if that is if its hidden, or if it didn't work. And I seem not to have made the Login button This is an image of the...
  2. lhg1

    Automated login using commandling in ubunto

    Hi Thanks, it allowed a bit more progress I changed the login names to formvalue 1 "ctl00_mnuLeft1_mSignin_mnuSignin_Username" L1977 formvalue 1 "ctl00_mnuLeft1_mSignin_mnuSignin_Password" larshg But it is still not working, even thou I am not getting an error anymore Any idears? Thanks Lhg
  3. lhg1

    Automated login using commandling in ubunto

    I'm having trouble getting this to work. I tryed to change the formvalue but still I only get this message in twill-sh this is the page I am trying to create a autologin script for. kandu.dk I'm not sure what you ment by the secound "will not work if" Thanks Lhg
  4. lhg1

    Automated login using commandling in ubunto

    Hi I just curl the page and this seems to be the password box. <div style="width: 180px; margin: 3px 3px 7px 3px;"><table cellspacing="0" cellpadding="0" style="width: 100%;"><tr class="mtop"><td><div style="margin: 10px 3px 0px 10px;"><span class=" TitleHaed">Login <img...
  5. 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...
  6. 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...
  7. 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
  8. lhg1

    Replacing in php

    Exelent and it was just what I was looking for. Thanks.
  9. 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
  10. lhg1

    2 SQL combined

    ...As year, DatePart(wk,CONVERT(VARCHAR, DATEADD(ss, create_date - DATEDIFF(ss, GETDATE(), GETUTCDATE()), '1970-01-01 00:00'), 120)) as week, count(*) as amount FROM SC_Helpdesk where ( Assigned_Group = 'IS IT - PF Forvaltning Billing' or Assigned_Group = 'Billing Drift' or Assigned_Group =...
  11. lhg1

    Grouping by hour

    Hi I'm running this throu a PHP adapter, and I think thats the reason for the blank result. I've solvede this in PHP. Thanks. LHG
  12. lhg1

    Grouping by hour

    ...as day, DatePart(hour,CONVERT(VARCHAR, DATEADD(ss, create_date - DATEDIFF(ss, GETDATE(), GETUTCDATE()), '1970-01-01 00:00'), 120)) as Hour, count(*) as Amount from table where CONVERT(VARCHAR, DATEADD(ss, create_date - DATEDIFF(ss, GETDATE(), GETUTCDATE()), '1970-01-01 00:00'), 120)>...
  13. lhg1

    Grouping by hour

    ...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", COUNT(*) FROM table GROUP BY to_char(date, 'yyyy-mm-dd hh24') I've managede to do it in months SELECT MONTH(CONVERT(VARCHAR, DATEADD(ss, create_date -...
  14. 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'...
  15. 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'...
  16. lhg1

    Not selecting if the varchar contains letters

    Fantastic Ended up with this. when Fixed_in__Vendor_ = '' then 999999 when Fixed_in__Vendor_ = NULL then 999999 when IsNumeric(Fixed_in__Vendor_ + '.0e0') = 1 then CAST(Fixed_in__Vendor_ AS INT) else 99999 End"; Thanks
  17. lhg1

    Not selecting if the varchar contains letters

    Great that works. I was trying to empty fields to come last, maby you can spot how that is done This was my attemt when IsNumeric(Fixed_in__Vendor_ + '.0e0') = 1 then CAST(Fixed_in__Vendor_ AS INT) when Fixed_in__Vendor_ = "" then 999999 else 99999 End";
  18. lhg1

    Not selecting if the varchar contains letters

    Interesting, but I can't get it to work I'm using it throu PHP and a function callede @mssql_query Any Ideers?
  19. 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...
  20. lhg1

    ORDER by on varchar field

    Excelent - it works. Thanks LHG

Part and Inventory Search

Back
Top