Luciano Evaristo Guerche

A brazilian geek interested in .NET technologies

About Me

Posted: by

Comments

chadb said:

very cool - thanks!
# February 10, 2004 8:41 AM

senkwe said:

I hear Brazil is predominantly Java country. Do you see this is well?
# February 10, 2004 8:44 AM

Luciano Evaristo Guerche said:

senkwe,

Before .Net was release, I believe so (kidding). Actually, Brazil is a big country, so it is hard to have a picture at glance. To answer your question I would have to look for information on some research companies like Gartner. Speaking of the environment I work in, we have teams developing Visual Basic 6 windows applications, teams developing Visual Interdev 6 web applications and teams developing Java web applications using Oracle technology, to name, Oracle JDeveloper and Oracle AS. I do not know of any team developing .Net applications so far. For me, that is very sad, since I have been programming using Microsoft Visual Basic since 1996 (VB 3) and I would prefer programming in .Net tools than in Java ones, since I feel the learning curve for Java is longer.

The problem is we use what the company we work for dictates and it seems my way some day might be Java.

Well, I will try to find further information to answer your question. If I find it I send it to you.
# February 11, 2004 5:21 AM

Luciano Evaristo Guerche said:

Dear senkwe,

I researched the words Brazil ".net framework" and java at google and a lot of stuff was returned. I take a brief look at results returned and I guess much of it is due to the fact there is a project at sun.com named Brazil. Links are just below, you can see by yourself. I also added a link where you can find some brazilian webloggers specialized in Java. If you are interesed in Java technology, I think they might be a starting point for you...

Regards,

Luciano Evaristo Guerche
Jacarei, SP, Brazil

Topic: P2P Java - Brazil project (Sun)
http://www.oreillynet.com/pub/d/465

Brazil Project: The future of web application development
http://research.sun.com/features/brazil/index.html

java.net Webloggers
http://weblogs.java.net/pub/q/webloggers
Look for Brazil on the page and you will find brazilian webloggers there
# February 11, 2004 11:31 AM

Aaron Weiker said:

Pardon my ignorance, but what is processing the work queue? Or were your intentions here at just providing a store and retrieval mechanism and letting something else do the actual processing?
# February 13, 2004 9:55 AM

Roy Osherove said:

It would be easier on the eyes to post this as an article and just provide a short post with a link to it. That way the main feed page does not get too large or hard to read :)
# February 13, 2004 9:59 AM

Luciano Evaristo Guerche said:

Aaron,

I posted just the implementation. As my work queues often involves 1) getting a record, 2) inputing/processing the record in a mainframe system and 3) then setting it as processed, I usually create Visual Basic programs which consumes, processes and sets the work queue through ADO callings to stored procedures similar to the ones I posted.

# February 13, 2004 11:01 AM

Luciano Evaristo Guerche said:

Roy,

Thanks for your comment. I am new to the blog world. When setting/administering my blog I saw there was tabs for posts and articles, but I did not figure out what the differences between articles and posts and how to use articles at all. Would you mind commenting more on articles in .Text?
# February 13, 2004 11:03 AM

Aaron Weiker said:

Luciano,
It would be nice if in further posts you extend this and show examples of you could do your implementation.

I do have some questions/suggestions on why you may have done a few things though. First of all, why did you chose only 3 stages? Would it be more extensible if you instead each row was just one stage, however you had another field that identified a previous row that it was a depedency of. Now assuming you did 3 stages per row to cut down on the number of rows that will be in the table, it makes sense as the larger the table the longer it takes to parse. Then speaking of a large table, what type of cleanup work do you recomend doing on the queue? (how long do records stay in there, do you archive them for future reference, etc)
# February 13, 2004 11:44 AM

Luciano Evaristo Guerche said:

Aaron,

With regard to your question about 3 stages (steps), I did it thinking of a modular/scalable/multiuser plataform. As an example stage 1 could be "get additional customer information from mainframe system and save it to missing fields in the record being processed", stage 2 could be "select our nearest branch which could supply our custumer as soon as possible and set the proper missing fields in the record been processed" and stage 3 could be "send an email to selected branch with customer and requested supplies information". Can you see what I am mean. It is like splitting the whole proccess into parts and putting one clerk in charge of it part. Clerk in charge o stage 2 will proccess only records handled accordingly by clerk in charge of stage 1 and so on. In my case, as some of the stages involves dealing with mainframe connections, which are usually slow, I can run many instances of the module (clerk) in charge of a given stage and work will be done in parallel, each one pulling form the same table, but querying in different mainframe connections, regarded the program enclose each record processing inside a transaction so other instances will not get/mess with the same record. My example was made of 3 stages, but there are systems I work on we deal with lots of stages (steps), each one depending on the results of the previous, all working in parallel. My advice for you would be: stop thinking monolithic, it is not scalable at all.

I am not sure I fully understand what you mean by "you had another field that identified a previous row that it was a depedency of". If you were talking about the Error table, do you agree with me that some processes may produce many errors for a given proccessed record? In the example previously mentioned, when I try to get information from mainframe system might return more than one error message like 1) Too many customers found for given information; 2) Give me more parameters and I will try to narrow the search 3) If you cannot do it, you are out of luck. Then I ask you, how would I fit all these myriad of message just in one field/table?

As for cleanup work, I would recommending you involving infrastructure staff and the user who uses/pays for the system and setting some meetings. Sometimes these meetings are funny because the infrastructure staff request database be as fit as possible and user say he needs the data kept for 10 years or more, just to let him/her be possible to query the database for the queries/summaries they want. ;-) I read some articles long time ago which recommend creating an archive database (ex. CustumersDb and CustumerDbArchive) or replicating tables with a suffix in the same database (ex. Custumers and CustumersArchive) and archiving old data in an established timetable. I guess it would fine, but have not implemented it yet because we have plenty of space in our servers, tables are well indexed and user queries all the data often.

Well, hope I have been clear and you can understand what I say. I am a system analyst, not a writer, so hope you understand my words.
# February 13, 2004 1:36 PM

Wallym said:

Then you are like me, Plip, and David Penton.....
# March 12, 2004 12:45 PM

Fabrice said:

Looks like a great spam resource to me...
# March 12, 2004 12:46 PM

Peter Koen said:

What purpose is there in FOAF files other than enabling easier mail address harvesting for spammers?

By linking your foaf file to a website that can be accessed by everyone you just doomed the mail accounts of everyone in your list...

Another technology that the web doesn't need; Happy Spamming.....
# March 12, 2004 2:09 PM

Luciano Evaristo Guerche said:

Fabrice,

I know there is a way to protect email addresses in FOAF files through hashing, but did not find a way to hash all addresses in batch.
# March 12, 2004 2:10 PM

Luciano Evaristo Guerche said:

Wallym,

I guess my lack of friends is that both Friendster.com and Tribe.net have only english web interfaces and most of my friends do speak only brazilian portuguese. Moreover, Friendster.com is slow and full of bugs.

What about you, Plip, and David Penton?
# March 12, 2004 2:14 PM

Luciano Evaristo Guerche said:

Peter,

Do you know any way of hashing FOAF email addresses in batch?

I hashed some at http://www.ldodds.com/foaf/foaf-a-matic.html, but have not find a way to hash all of them in only one step.
# March 12, 2004 2:21 PM

Adam Kinney said:

Unfortunately that's thr truth of it. You have to wait for more to come. But at least this way it will be easier for the next person in your area to join.
# March 12, 2004 2:28 PM

Morten Frederiksen said:

For batch (and single) conversions, see http://xml.mfd-consult.dk/foaf/sha1ify/ - but note that it (also) requires well-formed XML, currently your file is missing an XML declaration since it's encoded in iso-8859-1, not UTF-8/UTF-16.

Example (add as first line in file): <?xml version="1.0" encoding="iso-8859-1"?>
# March 14, 2004 12:21 PM

Luciano Evaristo Guerche said:

Morten,

Thanks for the tip. I am in a hurry to delivery a new system this month, so I will give it a try as soon as possible.
# March 15, 2004 11:23 AM

TrackBack said:

# May 4, 2004 1:15 PM

Jerry Pisk said:

Your function do not get the date part of a datetime value. The problem is that you're rounding the value instead of stripping the time value and just keeping the integer part:


CREATE FUNCTION [dbo].[up_date_value] (@date datetime) RETURNS datetime AS

RETURN CAST(FLOOR(CAST(@date AS float)) AS datetime)


Your function will return the next day for values in the afternoon. Mine function would return invalid values for negative dates but SQL server doesn't support those. If it did all we'd have to do is to add an IF there and use CEILING for negative dates.
# May 4, 2004 4:52 PM

Jerry Pisk said:

And I look like an idiot, ROUND(value, 0, 1) will truncate, not ROUND :)
# May 4, 2004 4:54 PM

Luciano Evaristo Guerche said:

Dear Jerry,

Thanks for your comments on the code. As you noted on time, ROUND may also TRUNCATE. I guess my code works properly, at least it worked when I tested it last time. Anyway, I am happy there are people out there watching my scarce postings and spending time commenting on it...
# May 4, 2004 5:08 PM

denny said:

Very slick....

somewhere I saw a snipet one time that would take a row of values and make it output as a set of rows...

U used that to make a drop-down-combo in html with one sql call to build the whole list.

/me wonders if I can find that code now?
# May 4, 2004 5:31 PM

TrackBack said:

# May 5, 2004 6:44 AM

Luciano Evaristo Guerche said:

Dear Denny,

I guess the following link may help you somehow:

http://weblogs.asp.net/guerchele/archive/2004/02/10/70767.aspx
# May 5, 2004 8:44 AM

Scott Galloway said:

Try out SauceReader, still beta but it's already pretty good (http://www.synop.com/Products/SauceReader/) has a nice posting interface as well as great RSS reader functionality.
# May 24, 2004 4:06 PM

Dare Obasanjo said:

You can post replies to blog entries from RSS Bandit if you have w.bloggar installed. Just right-click on the post in the list view and select the option for posting a reply to your blog using w.bloggar
# May 24, 2004 4:47 PM

Luciano Evaristo Guerche said:

Scott,

Thanks for the tip, maybe I'll give it a try...
# May 24, 2004 5:01 PM

Luciano Evaristo Guerche said:

Dare,

Thanks for the tip. I tried it and see if it works. Actually I had tried it before, but as I did not have w.bloggar installed it did not work that time.

Just another question: Do you know when RSS Bandit next releases are due?
# May 24, 2004 5:04 PM

Damir Tomicic said:

Thanks to your blog, I have heard about SauceReader.. Very nice app, thanks ;-)
# May 25, 2004 3:11 AM

Softwaremaker said:

Excellent BLOG...

You really took a lot of time to set up your side menu and you have very carefully group each personality into their own category of expertise.

Very good and my hats off to you for a detailed job well done !

Regards,
~WT
# June 2, 2004 1:01 AM

Luciano Evaristo Guerche said:

Dear William Tay,

Thanks for your compliments! By the way, how are things going over there in Singapore? Hope everything is going well...
# June 2, 2004 7:16 AM

Jon Galloway said:

Cool! That'll simplify something I've been wanting to do, which is OPML sync between work, desktop, and laptop OPML files. Looking forward to testing it out this weekend!
# June 4, 2004 5:41 PM

Luciano Evaristo Guerche said:

Jon,

Use, but pay attention my OPML file has only two level "outline". In case you have more than 2, you'll have to tweak it slightly.
# June 4, 2004 6:02 PM

HumanCompiler said:

Thanks! Glad you like my blog! :)
# June 7, 2004 12:49 PM

Manish Sohaney said:

Good sample program. It really helped me.


Manish
# June 7, 2004 2:41 PM

Luciano Evaristo Guerche said:

Manish,

I am glad to know about it.
# June 7, 2004 4:25 PM

darwin lorenzana said:

ok,

ill try it .kinda big file
# June 13, 2004 8:15 PM

Scott Galloway said:

Fantastic! It looks a touch limited (Defalte and GZip) but hey's it's a start!
# June 15, 2004 4:10 PM

Scott Galloway said:

Hmm...I much prefer this one: http://www.yoda.arachsys.com/csharp/singleton.html which covers things like lazy instantiation etc...I really haven't rated a single P&P article - they all seem really dry and academic to me...
# June 16, 2004 2:40 PM

Luciano Evaristo Guerche said:

Scott,

Thanks for pointing out another valuable link. I have just read it and must aggree with you.
# June 16, 2004 2:56 PM

Randy Charles Morin said:

I like!
# June 16, 2004 4:02 PM

TorstenR said:

Luciano, if you have some time in the next days please report your problems with Bandit to me (torsten.rendelmann[at]gmx.net) or Dare Obasanjo, or post some bugs/feature requests at http://dev.rssbandit.org
# June 17, 2004 3:07 PM

jross@rosscode.com (Joel Ross) said:

They just released a beta for 1.1. It says it supports posting via the IBlogExtensions, but I haven't tried it yet. It now also supports ATOM (my main reason for moving to RSS Bandit a couple of months ago).

Joel
# June 17, 2004 3:07 PM

Luciano Evaristo Guerche said:

I missed CodeRush on the list. I haven't used it yet, but heard a lot about it during TechEd 2004 (through blogsphere, of course)
# June 17, 2004 5:05 PM

SBC said:

# June 17, 2004 5:21 PM

Chris said:

Please, don't advertise every single too that hasn't made the list.
# June 17, 2004 9:17 PM

Randy Charles Morin said:

I like the list. The only disagreement is NAnt, which is just an inappropriate solution adopted from the Java world. MSBuild will likely obsolete it.
# June 17, 2004 10:10 PM

Randy Charles Morin said:

Does SpyMac offer wireless access?
# June 17, 2004 10:12 PM

Lia said:

May you invitemeplease? Thanks a lot !
# June 18, 2004 9:59 AM

Darrell said:

It's because SQL Server doesn't support nested transactions. See my blog post here
http://dotnetjunkies.com/WebLog/darrell.norton/archive/2003/12/24/4921.aspx
(thanks to Frans Bouma for the original enlightenment).
# June 18, 2004 4:35 PM

Uwe said:

Just wondered whether the compiler/optimizier would ever remove the name-representations and only store the numbers of the enums, but I guess this will never happen?!
# June 23, 2004 11:10 AM

Noah Coad (C# MVP) said:

The names/identifiers are part of its underlying type so no, the compiler does not remove this information.
# June 23, 2004 12:14 PM

William Bartholomew said:

I noticed when you run FxCop on an assembly that uses this technique it says you should request special permissions.
# June 23, 2004 6:45 PM

TrackBack said:

U.N.: Mideast needs political solution Egypt gets Israeli, Palestinian pledges Israeli Soldiers' Photos Illuminate Occupation>/a> Intelligence Chief Confirms Clintons Version of Golan Talks Intel chief: Palestinians still want Israel destroyed Pity the poor Palestinians IDF says Hezbollah has taken over...
# June 24, 2004 5:35 AM

Luciano Evaristo Guerche said:

Darrell,

Thanks for the link. I take a look at it and, for sure, your post and comments add to complement what I have talked about. If you know of a better way of workarounding the scenario I depicted in my post, post it on your blog and "trackback" to mine, so I can take a look at it and both can learn from each other.

Regards,

Luciano Evaristo Guerche
Sao Paulo, SP, Brazil
# June 28, 2004 1:31 PM

Luciano Evaristo Guerche said:

I would like to thank everybody who have commented on this post and apologize for not replying ASAP.
# June 28, 2004 1:34 PM

AndrewSeven said:

I think Scott (the guy from rolla) is away...

http://scottonwriting.net/sowblog/posts/1460.aspx
# June 29, 2004 8:45 AM

Luciano Evaristo Guerche said:

Andrew,

Thanks for the tip
# June 29, 2004 9:47 AM

Avonelle Lovhaug said:

I asked for something similar here: http://www.coolbits.nu/558.aspx
and here:
http://blogs.msdn.com/danielfe/archive/2004/06/29/168417.aspx
on Dan's blog. He indicated that they had some concerns about doing that since the products are still in beta. However, they hope to provide additional information soon.
# June 30, 2004 12:50 PM

Luciano Evaristo Guerche said:

Avonelle,

Thanks for your comment and links. Let's wait and see what future reserves for us.
# June 30, 2004 1:26 PM

Randy Charles Morin said:

Thanks Avonelle. Much appreciated.
# July 1, 2004 12:17 AM

Fabrice said:

# July 7, 2004 10:12 PM

Luciano Evaristo Guerche said:

Thanks Fabrice for pointing this URL
# July 8, 2004 9:22 AM

patag said:

Textpad and RegEx rule the world, two of the most powerful tools known to programmers!
# July 8, 2004 7:34 PM

tuhinbal said:

Hi,
Can u tell me how to configure text pad to run sql statements without sqlplus?



Tuhin
Tata Consultancy Services
India
mail id: tuhinbal@rediffmail.com
# July 18, 2004 5:24 AM

Luciano Evaristo Guerche said:

Tuhin,

In Textpad, you can add external programs to be run from Textpad through the tools menu. As I work with SQL server, what I would do is to configure Textpad to run osql.exe passing the file I am working on in Textpad. So, with file containing the SQL statement open on Textpad, I would select Tools > osql menu, osql.exe would be started using current file and Textpad would capture the output to Textpad output area.
# July 18, 2004 10:04 AM

Luciano Evaristo Guerche said:

Tuhin,

In your case, you must check whether Oracle has a command line tool to run SQL statements, like osql.exe in SQL server.
# July 18, 2004 10:05 AM

JDM said:

Or you could just start including content people actually want to read.
# August 19, 2004 3:53 PM

Addy Santo said:

Bloggers are some of the smartest individuals around. Why is it then that as a group they such mind-bogglingly stupid ideas???

Please don't contribute to blog-spam. we get enough noise on weblogs.asp.net as it is.
# August 19, 2004 5:10 PM

Jeffrey Palermo said:

Unsubscribe.
No, really, don't try to create blog chain letters. The point of my blog isn't to help boost somebody else's rating on Google. If on of my posts comes up on google, it should be because it contains content relavent to the search terms. So you are hurting the effectiveness of search engines if you link to sites without related content.
# August 19, 2004 7:10 PM

Luciano Evaristo Guerche said:

Sorry folks, I didn't really meant to make you angry. Just checking how this whole thing would go.
# August 21, 2004 3:44 PM

Jon Galloway said:

For hex conversions, you can use the int.ToString("x") method:

(16).ToString("x") returns "10"
# October 1, 2004 2:34 PM

Jon Galloway said:

For octal:
string oct = Convert.ToString(intValue, 8);
# October 1, 2004 2:39 PM

Jon Galloway said:

Oops, pardon me - I didn't notice this was VB6. Sorry about that. You can delete my comments if you'd like.
# October 1, 2004 2:40 PM

Luciano Evaristo Guerche said:

Jon,

Do not worry about and feel free to add more comments if you want. Thanks for letting me know vb .net has this options embedded. Another thing I have noted after I posted, is that vb6 Hex function works with negative numbers, mine Bin and Oct functions don't, but it was just for fun, so I won't brainstorm to have them working with negatives.
# October 1, 2004 3:03 PM

Ken said:

There is NewsGator for Outlook but it's not free the way Thunderbird's is.
# October 4, 2004 2:12 PM

Adam said:

Unwilling to spend just a little money on Newsgator? Great product -- why should everything be free.
# October 8, 2004 6:20 PM

David Scott said:

I think Intravnews used to be free, could be wrong though. Anyway it looks like it costs $24.95 now.

http://www.intravnews.com

I agree with Adam though, Newsgator rocks.
# October 8, 2004 9:06 PM

matt said:

But newsgator isn't compatible with OE. Anyone got any free (or commercial RSS readers for that matter) that work inside OE (beside the horrible, HORRIBLE newsgroups converters)?
# October 8, 2004 11:22 PM

Luciano Evaristo Guerche said:

Ken,

Thanks for the tip. I have heard of Newsgator, but haven't used it so far. Maybe I download the trial and give it a try.
# October 8, 2004 11:55 PM

Luciano Evaristo Guerche said:

<hr>
Adam,

Everything should be free, so the ones who can afford paying for would have access to.

<hr>
David,

Only version 1.0 was free. I send a lot of feedback, suggestions and when version 1.1 was released I discovered I would have to pay in case I wanted to keep using it

<hr>
Matt,

A lot of campanies, like Microsoft, Yahoo, etc. is already delivering their content through RSS. The only missing part they did not realize yet is that there should be FREE GOOD tools to let information achieve as many as possible.
# October 9, 2004 12:05 AM

Randy Charles Morin said:

Free sucks! MHO.
http://www.google.com/search?q=free+sucks
$29 is worth it and effectively free.
# October 9, 2004 1:03 AM

edween said:

how about any bin/oct/hex convet to decimal... is it possible???
sorry dont know about vb.. just askin for help..
# October 9, 2004 11:47 AM

Luciano Evaristo Guerche said:

Edween,

Option Explicit

Public Function ToDecimal(strNumber As String, intBaseNumber As Integer) As Double
Dim intCurrentDigit As Integer
Dim strValidDigits As String
For intCurrentDigit = 0 To intBaseNumber - 1
If intCurrentDigit < 10 Then
strValidDigits = strValidDigits & intCurrentDigit
Else
strValidDigits = strValidDigits & Chr$((Asc("A") - 10) + intCurrentDigit) & Chr$((Asc("a") - 10) + intCurrentDigit)
End If
Next
strValidDigits = "[" & strValidDigits & "]"
For intCurrentDigit = Len(strNumber) To 1 Step -1
If Not Mid$(strNumber, intCurrentDigit, 1) Like strValidDigits Then
Err.Raise vbObjectError + 1, "ToDecimal", "Invalid number"
End If
Next
For intCurrentDigit = Len(strNumber) To 1 Step -1
If Mid$(strNumber, intCurrentDigit, 1) <> "0" Then
If Mid$(strNumber, intCurrentDigit, 1) Like "[A-Z]" Then
ToDecimal = ToDecimal + ((Asc(Mid$(strNumber, intCurrentDigit, 1)) - Asc("A") + 10) * intBaseNumber ^ (Len(strNumber) - intCurrentDigit))
ElseIf Mid$(strNumber, intCurrentDigit, 1) Like "[a-z]" Then
ToDecimal = ToDecimal + ((Asc(Mid$(strNumber, intCurrentDigit, 1)) - Asc("a") + 10) * intBaseNumber ^ (Len(strNumber) - intCurrentDigit))
Else
ToDecimal = ToDecimal + (Mid$(strNumber, intCurrentDigit, 1) * intBaseNumber ^ (Len(strNumber) - intCurrentDigit))
End If
End If
Next
End Function
# October 10, 2004 11:05 AM

Luciano Evaristo Guerche said:

Edween,

Hope this is the code you asked for:

<pre>
Option Explicit

Public Function ToDecimal(strNumber As String, intBaseNumber As Integer) As Double
Dim intCurrentDigit As Integer
Dim strValidDigits As String
For intCurrentDigit = 0 To intBaseNumber - 1
If intCurrentDigit < 10 Then
strValidDigits = strValidDigits & intCurrentDigit
Else
strValidDigits = strValidDigits & Chr$((Asc("A") - 10) + intCurrentDigit) & Chr$((Asc("a") - 10) + intCurrentDigit)
End If
Next
strValidDigits = "[" & strValidDigits & "]"
For intCurrentDigit = Len(strNumber) To 1 Step -1
If Not Mid$(strNumber, intCurrentDigit, 1) Like strValidDigits Then
Err.Raise vbObjectError + 1, "ToDecimal", "Invalid number"
End If
Next
For intCurrentDigit = Len(strNumber) To 1 Step -1
If Mid$(strNumber, intCurrentDigit, 1) <> "0" Then
If Mid$(strNumber, intCurrentDigit, 1) Like "[A-Z]" Then
ToDecimal = ToDecimal + ((Asc(Mid$(strNumber, intCurrentDigit, 1)) - Asc("A") + 10) * intBaseNumber ^ (Len(strNumber) - intCurrentDigit))
ElseIf Mid$(strNumber, intCurrentDigit, 1) Like "[a-z]" Then
ToDecimal = ToDecimal + ((Asc(Mid$(strNumber, intCurrentDigit, 1)) - Asc("a") + 10) * intBaseNumber ^ (Len(strNumber) - intCurrentDigit))
Else
ToDecimal = ToDecimal + (Mid$(strNumber, intCurrentDigit, 1) * intBaseNumber ^ (Len(strNumber) - intCurrentDigit))
End If
End If
Next
End Function
</pre>
# October 10, 2004 11:08 AM

Luciano Evaristo Guerche said:

Edween,

This is the way you might use it:

? ToDecimal("11111111", 2)
? ToDecimal("377", 8)
? ToDecimal("FF", 16)
? ToDecimal("GG", 16) 'will raise an error
# October 10, 2004 11:10 AM

Luciano Evaristo Guerche said:

Another way of converting Decimal to Bin, Oct and Hex?

There it is:

<pre>
Option Explicit

Public Function FromDecimal(ByVal lngNumber As Long, ByVal intBaseNumber As Integer) As String
Do While lngNumber > 0
If (lngNumber Mod intBaseNumber) < 10 Then
FromDecimal = (lngNumber Mod intBaseNumber) & FromDecimal
Else
FromDecimal = Chr$(Asc("A") + (lngNumber Mod intBaseNumber) - 10) & FromDecimal
End If
lngNumber = lngNumber \ intBaseNumber
Loop
End Function
</pre>
# October 10, 2004 11:21 AM

Luciano Evaristo Guerche said:

And this is how you might use it:

? FromDecimal(255, 2)
11111111
? FromDecimal(255, 8)
377
? FromDecimal(255, 16)
FF
# October 10, 2004 11:22 AM

Bill Bradley said:

Is logmein really free or just a free trial?
# October 26, 2004 3:57 PM

Luciano Evaristo Guerche said:

Bill,

You'll have to pay only if you need PRO features like Click2Share, file transfer and folder synchronization between computers
# October 26, 2004 4:33 PM

Brenton House said:

Mine has been out for about 5 days or more now as well....
# November 8, 2004 9:30 AM

Randy Charles Morin said:

I get this from time-to-time, but usually service is restored w/in minutes.
# November 8, 2004 11:24 AM

kevin said:

Don't you find it's interface rather cluttered?

I tried to switch from RSSBandit to Omea over the weekend with little satisfaction. I was able to import my feeds list without any trouble but navigation through Omea was painful. Maybe it's because RSSBandit is focused on one thing - reading RSS feeds. Omea tries to collect information from a bunch of different places: Websites, RSS, newsgroups, etc... It makes for a a lot of clutter that I don't care about.
# November 8, 2004 12:40 PM

Luciano Evaristo Guerche said:

Kevin,

For me, the best world would be having both Outlook and Outlook Express dealing with email, Neswgroup and RSS feeds. As I use Outlook at office and Outlook Express, if both dealt with these kind of content, that would be a marvelous world.

I used RSSBandit some time ago, even helped translating its text resources to brazilian portuguese, but it become very unstable on my machines on the last releases and I gave it up.

As for Omea Reader, instead of using "All resources" tab, I just select "Feeds" tab and that's my world in Omea. I imported my OPML file and it kept my file structure. Another thing I enjoyed so much is "Views and Categories", especially the "Recent (Today, Yesterday, This week, Last week, This moth and Last month)" option. With this myriad of options, I can read posts by feeds groups, feed and post's age among others.
# November 8, 2004 1:42 PM

Bertrand Le Roy said:

Yippee! I'm Windows Server 2003 SP3.
# November 10, 2004 4:29 PM

Scott Galloway said:

Hmm...yes, not quite slavery (come to that the Pyramids weren't built by slaves either but that's a different story :-)). Look, the guy had a tough break - so do lots of professions (my last girlfriend was a junior doctor - and typically worked 80 hours+ in an NHS hospital with far greater resonsibility and far less wages than any developer). WHat I don't get is this drive towards the 'industrialisation' of software development being seen as positive and separate from the devaluing of the developers - if developers are seen as easily interchangable components then of course they will be valued less. ASP.NET 2.0 is great and all but once the office junior can code a reasonable DB app do you really think employers will value developers? Sorry to rant a bit but it's a slipery slope...
# November 12, 2004 7:26 AM

JD said:

Mine has been down for a few days too. I logged in with my wife's account every time mine would not work, and her's works without issue. very annoying since I have made this my primary email account.
# November 12, 2004 11:43 AM

Luciano Evaristo Guerche said:

Scott,

I must agree with you on that there is good tools out there or just coming in and I won't argue with you about developers wages compared to other professions, but the main focus here is some companies have been abusing their employess through forcing them to endure overtime working hours/days/weeks. It does not matter how good a programer, the team he/she works to or the tools they use are. If you have many tasks and few resources, they'll have to do overtime. So the focal point here, at least for me, is lack of management, planning and respect.

As for you last girlfriend, I won't ask why relationship didn't last. I guess she didn't have spare time for dating. Just a question for you: How would she feel in case she made a mistake and somebody died because of that mistake, just because whe was asleep (people must sleep), hungry (people must lunch and dinning), or stressed (people may relax sometime, often at weekends)? I guess, the hospital wouldn't raise a penny for helping her or the late's family, for sure. Moreover, you two broke up relationship and a promissing love story might be ended.
# November 12, 2004 11:48 AM

Scott Galloway said:

Luciano...put this way, I'm an over-stretched developer, she was a junior doctor - time together was an issue :-) I totally agree that the main point is the lack of respect for your employees - but it is worth remembering that we have otherwise pretty simple jobs, we're generally not cold or scared and our mistakes won't kill anyone. Also worth remembering that in the long term, companies with these sort of practices will not survive because they will no longer attract talented individuals (indeed that may have been the reason for crunch in the first place, maybe their previous shoddy treatment led to a talent loss). My point was that as development becomes less and less skilled as a profession the the commoditisation of developers will increase, eventually these companies will survive as the resource they use (developers) becomes cheaper and cheaper to employ...and therefore less important to retain for the long term.
# November 12, 2004 12:10 PM

Luciano Evaristo Guerche said:

Scott,

Just one more question: In your opinion, do you think this trend (commoditisation) is for good? If you think so, can you post your arguments for our appreciation?
# November 12, 2004 12:21 PM

Frans Bouma said:

ms xml 4.0 is at least 3 years old!
# November 26, 2004 7:32 AM

Luciano Evaristo Guerche said:

Frans,

Which version should I use when developing Visual Basic 6 applications?

I downloaded MSXML 4 from Microsoft download site and did not find there any version newer than 4.
# November 26, 2004 9:10 AM

Shubhangi said:

it is really irritating..my account does not work & other's work..
repenting..as gmail is my main a/c too..
# November 29, 2004 8:35 AM

Luciano Evaristo Guerche said:

Shubhangi,

Let's hope we'll get rid of these hurdles soon. Just commenting: I configured POP access exactly the way the Orkut Help instructs, but it hasn't worked for me so far.
# November 29, 2004 9:12 AM

quaid said:

Send me all your money.
Instructions will follow.
# November 29, 2004 9:25 AM

Luciano Evaristo Guerche said:

Quaid,

Send me your address so I can send you all my money by tomorrow morning. :-))
# November 29, 2004 11:58 AM

Gabriel Rodriguez said:

mail me to gabrielrdz AT hotmail and ill give you an invite.
# November 29, 2004 12:18 PM

sstool said:

jasalor@gmail.com
# November 29, 2004 5:27 PM

siczy said:

siczy@hotmail.com
# December 7, 2004 7:53 PM

TrackBack said:

Luciano Evaristo Guerche: Probably somebody else has already posted about it, but I'll write about it here anyway, so the word spreads faster.
# December 17, 2004 10:05 AM

Hannes Preishuber said:

and sometimes a link is missing :-))
# January 10, 2005 7:29 AM

JB said:

Why is this not on the cover of the VB.NET boxes?
# January 11, 2005 8:39 AM

Alex said:

that's nice :)
# January 11, 2005 1:17 PM

anina said:

i would beg to differ. right now i am in the middle of a huge blog explosion in france. my blog is often used as reference material for others, because i use it with nokia lifeblog, to create movie posts, web posts, photo posts. maybe my blog is on the lighter side of news, but many people enjoy to read it. now i am launching a news portal about tech stuff and happenings. the problem for you guys with the french blogs is that you cant read french. le monde has a blog, l'express has a blog, l'figaro has a blog! it's crazy. it was in the new york times the other day how blogs are exploding here. just to let you know.

my blog you can read under my "journal" link.

take care!

and that's a crazy photo of the vb girls!
# January 20, 2005 2:26 PM

Luciano Evaristo Guerche said:

I have been using it at home and it has worked fine. I have made landline calls to other cities in Brazil and it is superb!
# January 21, 2005 2:29 PM

SBC said:

I got an invitation to Orkut from a friend of mine in Brazil. Nice idea (similar to LinkedIn & Friendster) but it's *very* slow!
# February 4, 2005 7:49 AM

jason said:

Got any spare invites to Gazzag? It looks mighty handy.
# February 16, 2005 2:47 PM

ram said:

i can use an invite too :)
# February 16, 2005 4:25 PM

Luciano Evaristo Gueche said:

If you are reading this feed in a browser (IE, Mozila, Netscapte, etc), click "Contact" on the left panel and send me your email address so that I can send you an invitation
# February 17, 2005 4:31 AM

james blibo said:

Can I have gmail invitation, i.e., if you have any more left? My email address is james.blibo@turner.com.

Thanks in advance...


james
# February 18, 2005 7:57 AM

Luciano Evaristo Guerche said:

James,

Invitation just sent. You'll be receiving it soon.
# February 18, 2005 8:27 AM

Bill Gates said:

so use Hotmail :-)
# February 18, 2005 8:47 AM

Luciano Evaristo Guerche said:

Dear BillG,

Increase my email storage to 1 GB and cut out the obligation to log in at least one time each 30 days and I'll keep using Hotmail.
# February 18, 2005 8:54 AM

David Burton said:

I would like a Gmail invite, if you have any left, I would appreciate it very much. My email is dburton@mygolfstats.com

Thanks,
David Burton
# February 18, 2005 9:14 AM

Luciano Evaristo Guerche said:

David,

Invitation just sent. You'll be receiving it soon.
# February 18, 2005 10:28 AM

Bitbreaker said:

There's an Italian Software (with a good English manual) that allows you to download your Gmail messages thru HTTP and serving them via a local POP3 server (so you have to configure accordingly your favorite email client).

It's URL is http://freepops.sf.net ...
# February 18, 2005 11:12 AM

Luciano Evaristo Guerche said:

Bitbreaker,

I have used FreePOPs and it is really great as a POP3/Web interface bridge, but, in my case, did not work well for SMTP. Moreover, everytime the web interface changes, the program stop working and you have to download a new LUA file or new program release.

Anyway, thanks for the comment.
# February 18, 2005 11:19 AM

Bitbreaker said:

Yes, It's true: everytime the UI changes, the software stop working BUT Gmail interface didn't change so much...yet.

There's another (italian) software that allows you to have a SMTP/Web bridge: HTML2POP3 by Baccan .

Google it...and let me know...eventually.
# February 21, 2005 5:52 AM

Hugo Contreras said:

Hello Luciano, Pls. send me an invitation to Gmail. I would appreciate it.

My email: hlcont@hotmail.com

thanks,
Hugo Contreras
# February 25, 2005 9:44 PM

Luciano Evaristo Guerche said:

Hugo,

Invitation just sent. You'll be receiving it soon.
# February 28, 2005 7:44 AM

Bubu said:

Hi Luciano,

I need a Gmail invitation as a surprise for my special one. So would you please send me one?

My email adress is chocopies1941979@hotmail.com
# February 28, 2005 11:32 AM

Sebastian Contreras said:

Hi Luciano,

I would like to receive an Invitation. My email is genesis_2000@hotmail.com.

greetz
# February 28, 2005 12:40 PM

Luciano Evaristo Guerche said:

Bubu and Sebastian,

Invitation just sent. Enjoy it...
# February 28, 2005 2:07 PM

ricardo principe di mantova said:

ai luciano eu add vc nos meus contact's no flick e colaborei com duas fotos na pagina que vc criou e que so estamos nos dois,valeu e qdo eu for ver algo de tecnologia vierei aqui valeu !
# March 12, 2005 8:56 PM

Luciano Evaristo Guerche said:

Ricardo,

You are welcome.
# March 13, 2005 10:21 AM

sandeep said:

Hi Luciano,

I need a Gmail invitation. Could you please send me one at sandeepisthere@yahoo.co.in
# March 18, 2005 1:30 PM

Mr. Rajesh Chalke said:

Increase my email storage to 1 GB and cut out the obligation to log in at least one time each 30 days and I'll keep using Hotmail.

Is real, fast, simple

I always look for gmail
# March 19, 2005 4:05 AM

Jerry Pisk said:

I think this points to an oversight in the database design - no description should be designed by NULL not by an empty string. Otherwise I think supplying UI elements should be done in the presentation layer, not in the database. Simply return an empty string (or NULL) and have the UI handle the presentation of a missing description value. How are you going to localize it in the database?
# June 8, 2005 4:25 PM

Alex Papadimoulis said:


If you prefer your code to be harder to read, then go with your ISNULL+NULLIF technique. If you think that the programmer who follows you would appreciate something understandable, you should probably use the standard CASE.

That, and what Jerry Pisk said.
# June 8, 2005 5:00 PM

Luciano Evaristo Guerche said:

Jerry and Alex,

Thanks a bunch for the feedback. Actually, in the real situation, I had to dealt with a field whose type was float and the CASE WHEN or ISNULL+NULLIF was used as a workaround to a bad database design defined by another professional long time ago.
# June 9, 2005 10:01 AM

Damien Guard said:

I just tried and found myself marked as somewhere in France.

There doesn't seem to be any way of pre-checking where it's going to draw your flag before it records it :(

They claim you can update it by resubmitting but that isn't working for me.
# June 9, 2005 11:26 AM

Jerry Pisk said:

You can also use COALESCE(NULLIF(<column>, <null value>), <replacement value>) which may be just a tad easier to understand.
# June 9, 2005 4:30 PM

Luciano Evaristo Gueche said:

Damien,

Hopefully, it is a beta service, so we can can wish and hope for a better site in the near future.
# June 12, 2005 8:32 AM

Luciano Evaristo Gueche said:

Jerry,

Since you mentioned COALESCE, I would add it allows more than two paramaters so that instead of ISNULL(ISNULL(ISNULL(x, y), z), t) it could be COALESCE(x, y, z, t). I often use COALESCE when I have to deal with more than two values. Thanks for the tip and feedback.
# June 12, 2005 8:47 AM

Luciano Evaristo Guerche said:

BlogMap! has answered the email I sent them. They tweaked the service, but it is not correctly yet. I am now BlogMapped somewhere in Africa. Let's see what happens next days/weeks. Updates will be reported here.
# June 13, 2005 1:20 PM

Luciano Evaristo Guerche said:

Put tag <meta name="ICBM" content="-23.618138888888888888888888888889, -46.778147222222222222222222222222" /> on the page and asked BlogMap! to ping it and things got done.
# June 29, 2005 7:26 PM

Guy said:

Wouldnt this work better

Newest employee>

SELECT TOP 1 employee.emp_id,
employee.fname,
employee.minit,
employee.lname,
employee.job_id,
jobs.job_desc,
employee.job_lvl,
employee.pub_id,
employee.hire_date
FROM employee
INNER JOIN
jobs
ON employee.job_id = jobs.job_id
ORDER BY jobs.job_desc,
employee.hire_date DESC

Oldest employee>

SELECT TOP 1 employee.emp_id,
employee.fname,
employee.minit,
employee.lname,
employee.job_id,
jobs.job_desc,
employee.job_lvl,
employee.pub_id,
employee.hire_date
FROM employee
INNER JOIN
jobs
ON employee.job_id = jobs.job_id
ORDER BY jobs.job_desc,
employee.hire_date
# September 29, 2005 3:29 AM

Luciano Evaristo Guerche said:

Guy,

Unfortunately, you did not let your email address so that I also could send you an email. Hope you come back and see my reply here.

My queries were done based on tables from Pubs database, which is a sample SQL server database. That said, please run my queries and yours and you'll see they produce different results. Mine returns the newest and the oldest employee (based on hire_date) FOR EACH job_id. Yours returns the newest and the oldest employee FOR THE WHOLE company. In spite of it, thanks a bunch for the feedback.
# September 29, 2005 8:03 AM

Luciano Evaristo Guerche said:

Guy,

I just run your queries and realized they are returning the newest and the oldest (based on hire_date) employees for the "Acquisitions Manager" job and I figured out it is because jobs.job_desc is part of the ORDER BY clause.
# September 29, 2005 8:10 AM

matthew said:

the technique used for this is called a correlated subquery. You might want to have a read about them.
# September 29, 2005 11:50 AM

Luciano Evaristo Guerche said:

Matthew,

Thanks for the tip.
# September 29, 2005 6:04 PM

Leandro Almeida said:

Estou retribuindo a visita que você fez ao meu espaço na internet.
Infelizmente o meu inglês é muito fraco(rsrsrs).
Hoje em dia é mais que necessário falar outros idiomas, mas estou sem tempo...
Paz e bem!
# October 1, 2005 7:14 PM

rodrigo diniz said:

Sei que não tem nada a ver com seu post.. mas como você conseguiu uma blog no weblogs.asp.net?
Se precisar ser MCP , eu sou.
Obrigado
# May 10, 2006 8:01 AM

Luciano Evaristo Guerche said:

Caro Rodrigo,

Tenho este blog já há um bom tempo. Naquela época, interessado em ter um blog no weblogs.asp.net, resolvi enviar uma mensagem para o administrador do site, fazendo a mesma pergunta que você e ele respondeu prontamente, criando uma conta para mim, conforme desejado. Participei de algumas palestras da Microsoft Brasil e é lamentável que estimulem a utilização do The Spoke. No formulário, quando perguntam em que site a pessoa tem blog hospedado, não há opções além de The Spoke e MSN Spaces.

Vale a pena tentar. Envie uma mensagem para o administrador do site, que ainda deve ser o Scott Watermasysk, informe alguns dados a seu respeito (conhecimento técnico, empresas onde trabalha ou trabalhou e que sejam reconhecidas internacionalmente, e os cursos e certificados que possui) e quem sabe não criam uma conta para você também.

Boa sorte!
# May 10, 2006 6:53 PM

Andy Brudtkuhl said:

Why are you still using VB6?
# May 18, 2006 11:19 AM

Rolando Ramirez's WebLog said:

When you try to insert a string value wich has a greater length thana field supports, Sql Server(including

# July 12, 2006 5:03 PM

A Guy said:

Who cares if somone is still using VB6. Does it really matter? Maybe they like VB6 and not .net. Seriously, I use VB6 because there's no real point to update. Mainly because only newer OS's can handle .net and older one's can't. Hence the Reason VB6 is better then .Net
# July 30, 2006 6:41 PM

Nyi Min Thant said:

I seriously require a gmail accounts. Please invite me. my email address is nyiminthant@gmail.com
# August 9, 2006 2:16 PM

Igor said:

Hi Luciano; Please be so kind and send me one Gmail invitation to: sehapovic@yahoo.com Thanks
# August 19, 2006 9:35 AM

Luciano Evaristo Guerche said:

Just figured out that when I posted dbo.PartitionLeft, dbo.PartitionRight and dbo.Partitionusing blog's
# August 24, 2006 11:46 AM

Luciano Evaristo Guerche said:

Tried it again at night and it worked fine.
# August 24, 2006 11:19 PM

Luciano Evaristo Guerche said:

For solving item 2, I have just downloaded Flickr4Writer from http://www.codeplex.com/Wiki/View.aspx?ProjectName=flickr4writer For solving item 4, I right aligned the paragraph, clicked "Change View Mode" button, chose "HTML code", changed

to

, turned back to "Web Layout View" and voila, text is justified.

# August 24, 2006 11:29 PM

Luciano Evaristo Guerche said:

Sandeep, Nyi Min Thant and Igor,

Unfortunately, I haven't any gmail invitation left. When I get more, forward them to you.

--

Luciano Evaristo Guerche

# August 25, 2006 1:30 AM

RK said:

Excellent it's working...
# June 12, 2007 9:24 AM

Prabhat Samuel said:

Incase you are still searching ;)

msdn2.microsoft.com/.../aa700921.aspx

SAM

# June 19, 2007 5:05 AM

Joseph said:

I was wondering if I can apply this to two fields.... recieved date and completed dated to calculat the average turn around time.

Thanks in advance!  BTW awesome blog.  

Please shoot me an email j nospace licari at many nospace strengths dot com

# August 27, 2007 3:18 PM

Luciano Evaristo Guerche said:

Joseph,

No problem, just try

SELECT CAST(AVG(CAST(MyTable.MyDateTimeFinish - MyTable.MyDateTimeStart AS float)) AS datetime)

FROM MyTable

# August 27, 2007 5:06 PM

Joe Chung said:

Lambda expressions were in LISP, which predates Clipper by quite a bit.

# September 17, 2007 6:08 PM

Palermo4 said:

All the MIX08 sessions are online ! To reshape the &quot;WideOpen Web&quot; even faster, check out this

# March 7, 2008 4:53 PM

Matthew said:

Surely there must be an automated way to download them.

visitmix.com/.../MIX08 has a link to visitmix.com/.../MIX08feed/zune/ but it only lists 15 of the files...

# March 8, 2008 4:39 AM

Thinking in Grava said:

Mix08 Session

# March 8, 2008 8:22 AM

Christopher Steen said:

Link Listing - March 8, 2008

# March 8, 2008 11:11 AM

Christopher Steen said:

AJAX ASP.NET AJAX In-Depth: Application Events [Via: swalther ] WPF WPF Wiimote Library (Now With Project...

# March 8, 2008 11:12 AM

rascunho » Blog Archive » links for 2008-03-08 said:

Pingback from  rascunho  &raquo; Blog Archive   &raquo; links for 2008-03-08

# March 8, 2008 3:22 PM

Laurent Duveau said:

Not everything that happens in Vegas stays in Vegas... All sessions/keynotes can be viewed/downloaded

# March 11, 2008 10:57 AM

camp pendleton said:

Pingback from  camp pendleton

# March 11, 2008 10:23 PM

Luciano Evaristo Guerche said:

Posted an updated list with all 88 presentations at weblogs.asp.net/.../mix-2008-88-presentations-wmv-and-mp4-links.aspx

There new post lists title, speaker, description and wmv and mp4 links.

# March 12, 2008 1:11 PM

???????????????????? ?????????????? ?? MIX 2008 at RIA Revolution said:

Pingback from  ???????????????????? ?????????????? ?? MIX 2008 at RIA Revolution

# March 12, 2008 2:18 PM

Community Blogs said:

Jesse Liberty on where to get started in SL2, Brad Abrams exposes new SL2 control skins, Ralf Rottmann

# March 12, 2008 4:09 PM

自由、创新、研究、探索…… said:

Luciano Evaristo Guerche先生在博客里列出了录像直接链接:Mix 2008, 88 presentations (WMV and MP4 links)

# March 12, 2008 8:51 PM

自由、创新、研究、探索…… said:

Luciano Evaristo Guerche先生在博客里列出了录像直接链接:Mix 2008, 88 presentations (WMV and MP4 links)

# March 12, 2008 8:51 PM

Watching the Mix sessions « Freekshow said:

Pingback from  Watching the Mix sessions &laquo; Freekshow

# March 13, 2008 4:58 PM

kim weston said:

Pingback from  kim weston

# March 14, 2008 5:34 AM

wood dale said:

Pingback from  wood dale

# March 15, 2008 4:54 AM

jimmy burke said:

Pingback from  jimmy burke

# March 15, 2008 11:07 PM

chad dawson said:

Pingback from  chad dawson

# March 16, 2008 3:55 AM

luke bryan said:

Pingback from  luke bryan

# March 16, 2008 4:52 PM

Matthew Wills said:

I wish I had found this page before creating my RSS feed:

users.tpg.com.au/.../Zune rss.xml

# March 16, 2008 9:43 PM

jimmy burke said:

Pingback from  jimmy burke

# March 17, 2008 12:02 PM

tim robbins said:

Pingback from  tim robbins

# March 18, 2008 4:54 AM

franco harris said:

Pingback from  franco harris

# March 19, 2008 5:01 AM

marc mcclure said:

Pingback from  marc mcclure

# March 19, 2008 11:01 PM

ryan robbins said:

Pingback from  ryan robbins

# March 19, 2008 11:02 PM

Laurent Duveau said:

Not everything that happens in Vegas stays in Vegas... All sessions/keynotes can be viewed/downloaded

# March 20, 2008 4:15 PM

nicholas stoller said:

Pingback from  nicholas stoller

# March 21, 2008 3:01 AM

ozzie smith said:

Pingback from  ozzie smith

# March 23, 2008 4:55 PM

franco harris said:

Pingback from  franco harris

# March 27, 2008 7:02 PM

the rasx() context » Blog Archive » Random Screenshot: the Songhay System Data Access Layer said:

Pingback from  the rasx() context  &raquo; Blog Archive   &raquo; Random Screenshot: the Songhay System Data Access Layer

# April 2, 2008 4:21 PM

sam carbone said:

Pingback from  sam carbone

# April 20, 2008 1:22 PM

derrick dodge said:

Pingback from  derrick dodge

# April 29, 2008 8:05 PM

DotNetter said:

Nice gadget, dude. Respect.

VB6 is powerful, but has become unwieldy and monolithic and because of its procedural roots is easy to abuse.  VB6's fun but not as powerful or cleanly OO as .net.

# May 15, 2008 6:35 AM

zachary dunlap said:

Pingback from  zachary dunlap

# May 18, 2008 2:52 PM

david said:

If you only need the date part of a datetime variable discarding hours, minutes, seconds a better solution is available here

www.ugmfree.it/TipsTsql.aspx

DECLARE @Today datetime

SELECT @Today = CONVERT(varchar,getdate(),112)

# May 23, 2008 6:46 PM

Juan Roque (Dominican Republic) said:

Excellent application .....wwwwaaaaaaooooooo

# June 6, 2008 4:22 PM

Ben said:

This is the most wonderful code snippit i've ever come across. Having to support legacy applications this code is immediately going into every project I touch.

You sir, are a guru.

# June 25, 2008 8:46 PM

Michael Bartlett said:

Great solution!  Thanks.

# August 18, 2008 3:02 PM

Mike said:

I use VB6 because I write code for the Gov.  Currently the agency I am under contract to does not support dot Net.

Even though I am a .Net programmer I have to use VB6.

# August 25, 2008 1:55 AM

Niraj said:

excellent

# September 5, 2008 10:14 AM

luciano s links said:

Pingback from  luciano s links

# September 9, 2008 11:24 AM

Todd said:

Thanks, this is exactly what I needed!

# September 29, 2008 3:25 PM

Aries said:

Hi Luciano Your Code very helping me

Thank's

# October 29, 2008 12:43 PM

Luciano Evaristo Guerche said:

Only Windows Media Video High Definition and Powerpoint are available so far. But also published Windows Media Video Standard Definition, Windows Media Video for Zune, MP4 and Zip hoping they will be available soon

# October 30, 2008 11:57 AM

Luciano Evaristo Guerche said:

Only Windows Media Video High Definition and Powerpoint are available so far. But also published Windows Media Video Standard Definition, Windows Media Video for Zune, MP4 and Zip hoping they will be available soon

# October 30, 2008 11:57 AM

Luciano Evaristo Guerche said:

To download the files, follow links below:

PDC 2008 - Day 1 (46 matching sessions): weblogs.asp.net/.../pdc-2008-day-1-46-matching-sessions.aspx

PDC 2008 - Day 2 (50 matching sessions): weblogs.asp.net/.../pdc-2008-day-2-50-matching-sessions.aspx

PDC 2008 - Day 3 (60 matching sessions): weblogs.asp.net/.../pdc-2008-day-3-60-matching-sessions.aspx

PDC 2008 - Day 4 (49 matching sessions): weblogs.asp.net/.../pdc-2008-day-4-49-matching-sessions.aspx

# October 30, 2008 12:02 PM

Luciano Evaristo Guerche said:

Wondering how to accomplish same task on Internet Explorer. If anyone knows how to do that, let me know about.

# October 30, 2008 12:21 PM

Luciano Evaristo Guerche said:

To learn how to download all these files at once, take a look at "How to download PDC Sessions using DownThemAll! Firefox addon" (weblogs.asp.net/.../how-to-download-pdc-sessions-using-downthemall-firefox-addon.aspx)

# October 30, 2008 12:57 PM

Luciano Evaristo Guerche said:

To learn how to download all these files at once, take a look at "How to download PDC Sessions using DownThemAll! Firefox addon" (weblogs.asp.net/.../how-to-download-pdc-sessions-using-downthemall-firefox-addon.aspx)

# October 30, 2008 12:57 PM

Luciano Evaristo Guerche said:

To learn how to download all these files at once, take a look at "How to download PDC Sessions using DownThemAll! Firefox addon" (weblogs.asp.net/.../how-to-download-pdc-sessions-using-downthemall-firefox-addon.aspx)

# October 30, 2008 12:58 PM

Luciano Evaristo Guerche said:

To learn how to download all these files at once, take a look at "How to download PDC Sessions using DownThemAll! Firefox addon" (weblogs.asp.net/.../how-to-download-pdc-sessions-using-downthemall-firefox-addon.aspx)

# October 30, 2008 12:58 PM

Manu Ullas said:

MP4, ZIP links are dead.

Thank you!

# November 2, 2008 1:03 AM

Eu said:

heheh empacota tudo!

# February 9, 2012 8:48 AM