The daily spammage topic

[Wei Yan]

working on a software release script for a German customer.

downside: all error messages appear in German as well 

https://www.youtube.com/watch?v=0V7qIWUrOR0 ?

[maloki]

No rest for the wicked... And I might have gone and bought a new monitor. SO WHAT IF I CAN'T EAT FOR A MONTH.... I'll stil have WvW...

http://instagr.am/p/Qm1yevl6wf/

[Xiahou Yuan]

No rest for the wicked... And I might have gone and bought a new monitor. SO WHAT IF I CAN'T EAT FOR A MONTH.... I'll stil have WvW...

http://instagr.am/p/Qm1yevl6wf/

Just keep feeding on French souls and you'll be fine.

[Morrigan Silverwake]

working on a software release script for a German customer.

downside: all error messages appear in German as well 

Code: [Select]

Statement: INSERT INTO [docs] ([doc_id], [scan_date], [doc_name], [stamp_date], [stamp_uid], [status_index], [comp_no], [supplier_num], [invoice_num], [invoice_date], [invoice_last_date], [cash_date], [invoice_sum], [invoice_sum_calc], [invoice_currency], [exchange_rate], [vat_sum], [invoice_type], [net_sum], [net_sum_calc], [supplier_name], [order_num], [attrib_d2], [attrib_t1], [attrib_t2], [attrib_t3], [attrib_t4], [attrib_t5], [attrib_t6], [doc_pages]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
 -> Konvertierung des Parameterwertes von String in DateTime fehlgeschlagen.
  -> Die Zeichenfolge wurde nicht als gültiges DateTime erkannt.

### Full exception stack trace ###

Type: System.FormatException
	Message: Konvertierung des Parameterwertes von String in DateTime fehlgeschlagen.
	Source: System.Data
	Thread culture: en-US
	Stacktrace:
	   bei System.Data.OleDb.OleDbParameter.CoerceValue(Object value, NativeDBType destinationType)
	   bei System.Data.OleDb.OleDbParameter.BindParameter(Int32 index, Bindings bindings)
	   bei System.Data.OleDb.OleDbCommand.CreateAccessor()
	   bei System.Data.OleDb.OleDbCommand.InitializeCommand(CommandBehavior behavior, Boolean throwifnotsupported)
	   bei System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
	   bei System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
	   bei System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
	   bei System.Data.Common.DbDataAdapter.UpdateRowExecute(RowUpdatedEventArgs rowUpdatedEvent, IDbCommand dataCommand, StatementType cmdIndex)
	   bei System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
		Type: System.FormatException
		Message: Die Zeichenfolge wurde nicht als gültiges DateTime erkannt.
		Source: mscorlib
		Thread culture: en-US
		Stacktrace:
		   bei System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
		   bei System.Convert.ToDateTime(String value, IFormatProvider provider)
		   bei System.String.System.IConvertible.ToDateTime(IFormatProvider provider)
		   bei System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
		   bei System.Data.OleDb.OleDbParameter.CoerceValue(Object value, NativeDBType destinationType)

and the reason.... because I'm calling the by the software generated variable {Batch Creation Date}, which ALWAYS exists.

except here it's of course called {Stapelerstellungsdatum} -_-

You're not even using EF4? I can hardly remember the days when I had to use untyped datetime values :/

[Xiahou Hui]

My work is doing a great job preventing Guild Wars 2 addiction

[Cao Cao]

hmm funny, I was using sonicwall vpn software today as well 

[Xiahou Hui]

lol I saw your source code, and I installed a syntax highlighting mod for all us programmers and scripters.

Here's something I made once for Bierweek. Feel free to call it bad scripting, and improve it dramatically

Code: [Select]

<?php
$uur = date("G");
$minuut=date("i");
$minuut_split=0;
/* substr($minuut,-1); */
if ($minuut >= 00 && $minuut <= 06)
{
    $tuut = date("g");
    $uur_begin = "begin";
}
if ($minuut >= 07 && $minuut <= 21)
{
    $tuut = date("g");
    $uur_begin = "kwart_over";
}
if ($minuut >= 22 && $minuut <= 51)
{
    $tuut = date("g")+1;
    $uur_begin = "half_en_kwart_voor";
}
if ($minuut >= 52 && $minuut <= 59)
{
    $tuut = date("g")+1;
    $uur_begin = "einde";
}

switch ($tuut)
{
    case 1:
        $uur_tekst="&eacute;&eacute;n";
        break;
    case 2:
        $uur_tekst="twee";
        break;
    case 3:
        $uur_tekst="drie";
        break;
    case 4:
        $uur_tekst="vier";
        break;
    case 5:
        $uur_tekst="vijf";
        break;
    case 6:
        $uur_tekst="zes";
        break;
    case 7:
        $uur_tekst="zeven";
        break;
    case 8:
        $uur_tekst="acht";
        break;
    case 9:
        $uur_tekst="negen";
        break;
    case 10:
        $uur_tekst="tien";
        break;
    case 11:
        $uur_tekst="elf";
        break;
    case 12:
        $uur_tekst="twaalf";
        break;
    case 13:
        $uur_tekst="&eacute;&eacute;n";
        break;
}

if ($uur >= 0 && $uur <= 5) { $dagdeel = "'s nachts"; }
if ($uur >= 6 && $uur <= 11) { $dagdeel = "'s ochtends"; }
if ($uur >= 12 && $uur <= 17) { $dagdeel = "'s middags"; }
if ($uur >= 18 && $uur <= 23) { $dagdeel = "'s avonds"; }

if ($minuut >= 07 && $minuut <= 21) { $minuut_tekst = "kwart over"; }
if ($minuut >= 22 && $minuut <= 36) { $minuut_tekst = "half"; }
if ($minuut >= 37 && $minuut <= 51) { $minuut_tekst = "kwart voor"; }

if ($uur_begin == "begin")
{
    echo("$uur_tekst uur $dagdeel");
}
if ($uur_begin == "kwart_over")
{
    echo("$minuut_tekst $uur_tekst $dagdeel");
}
if ($uur_begin == "half_en_kwart_voor")
{
    echo("$minuut_tekst $uur_tekst $dagdeel");
}
if ($uur_begin == "einde")
{
    echo("$uur_tekst uur $dagdeel");
}
?>

[Wei Yan]

DIE FRENCHIES, DIE GERMANS, DIE DIE DIE.

Also: .

[maloki]

It seems they don't die enough..

and where is Wei when I've just gotten out of the shower? We got work to do! ...

Okay, not what it sounds like, I mean all the things we need to write.. lol :>

[maloki]

Double post? Oh I'm such a whore. I'm also crossposting!

WAY BACK MACHINE FTW! It seems I did NOT join in the summer for 2006 as I thought.. (proably then I started playing gvg with you tho), I joined in November 2005!

http://web.archive.org/web/20060927190911/http://www.dynasty-warriors.net/?module=memberlist

ALMOST 7 years! <3

[Cao Cao]

and where is Wei when I've just gotten out of the shower?

Okay, not what it sounds like

 

[Wei Yan]

It seems they don't die enough..

and where is Wei when I've just gotten out of the shower? We got work to do! ...

Okay, not what it sounds like, I mean all the things we need to write.. lol :>

*searches for whips and handcuffs*

[maloki]

It seems they don't die enough..

and where is Wei when I've just gotten out of the shower? We got work to do! ...

Okay, not what it sounds like, I mean all the things we need to write.. lol :>

*searches for whips and handcuffs*

You know these forums are completely public? Good... Okay..

MOVE ON NOTHING TO SEE HERE

[Wei Yan]

I have nothing to be ashamed off.

Also: still no Himiko, muhahahah. Might have a tough customer with Maloki though.

[maloki]

Y  u call me tough.. I'm an innocent little good girl!


Anyways, the floodgates are open! Awaiting new members to show up now!