Luciano Evaristo Guerche - All Comments

re: RE: Separating Date and Time in T-SQL

Muncho — Thu, 08 Oct 2009 14:46:59 GMT

You can use cast(... as int) instead of "ROUND":

cast(cast(cast(@Time as float) as int) as datetime)

You can even omit cast(... as datetime) if you are assigning to a "DATETIME" variable or column. This is because you can assign an integer to a datetime and the value is considered the number of days since 1900-01-01.

PDC 2008 - Day 3 (60 matching sessions) - Luciano Evaristo Guerche | Windows (7) Affinity

Mon, 27 Apr 2009 13:50:52 GMT

Pingback from PDC 2008 - Day 3 (60 matching sessions) - Luciano Evaristo Guerche | Windows (7) Affinity

re: String.Format("My name is {0}", "Luciano Evaristo Guerche") (VB6)

Kostas — Mon, 12 Jan 2009 14:10:02 GMT

Hi,

I thought that vb6 has Strings.Format() function...

Isn't almost the same?

re: How to download PDC Sessions using DownThemAll! Firefox addon

Luciano Evaristo Guerche — Fri, 12 Dec 2008 15:18:55 GMT

Sparky,

Take a look at www.tellingmachine.com/.../One-PowerShell-Script-to-download-them-all.aspx and I guess you'll find the information you are looking for...

re: How to download PDC Sessions using DownThemAll! Firefox addon

sparky — Wed, 10 Dec 2008 03:22:06 GMT

Can someone please tell me what the prefixes in the session numbers mean like BB, ES etc -> I assume it is some sort of level descriptor but can I get an explanation of it if possible. Thanks.

Also, excellent post!

re: An ease way of using ADO Recordset's Filter method to filter a field by multiple values

FLheritier — Mon, 24 Nov 2008 13:29:52 GMT

Don't work with string values ....

re: String.Format("My name is {0}", "Luciano Evaristo Guerche") (VB6)

A Booth — Thu, 20 Nov 2008 14:32:45 GMT

Code fix for anyone who actually wanted to use it

Module:mString.bas

' Usage: sMyString = mString.Format("Some{0}hing", "t")

Public Static Function Format(sFormat As String, ParamArray arParameters()) As String

Dim i As Integer

Format = sFormat

For i = LBound(arParameters) To UBound(aryPlaceHolders)

Format = Replace(Format, "{" & i & "}", arParameters(i))

End Function

re: String.Format("My name is {0}", "Luciano Evaristo Guerche") (VB6)

A Booth — Thu, 20 Nov 2008 14:23:24 GMT

Why not create a COM Object / Module containing a Format method ?

E.G: Module mString.bas

Public Static Function Format(sFormat As String, ParamArray arParameters()) As String

Dim i As Integer

Format = sFormat

For i = LBound(arParameters) To UBound(aryPlaceHolders)

Format = Replace(strOutput, "{" & i & "}", arParameters(i))

End Function

Clearly, it would be nice to expand this to incorporate data type formatting. ( {0:d} for example)

If you really want to emulate/utilize .NET functionality into VB6, look into COM Interop. With this, you can actually use .NET class libraries in VB6, so you would simply create a wrapper class in .NET that exposes String class as a COM object, thereby using the full functionality of .NET's String.Format method and everything else, instead of emulating it in VB6

PDC2008 videolar?? | ??smet'in G??ncesi

PDC2008 videolar?? | ??smet'in G??ncesi — Sat, 15 Nov 2008 19:14:27 GMT

Pingback from PDC2008 videolar?? | ??smet'in G??ncesi

ASP.NET MVC first step

Il blog di Luca Mauri — Sun, 09 Nov 2008 08:39:12 GMT

ASP.NET MVC first step