Every one who write queries in Oracle knows that for inserting comma (') into a varchar field you need to double it, which will look like this:

insert into shops(shop_name, description)
values ('Adam''s shop', 'selling bugs for free');

But I've found out this one too (and also found out that there are many of you that don't know this trick)
try to write the query with this special character - &  (And)
Oracle will think that this one is a parameter asking you to insert value.
so I said why not double it too.

update shops
set      shop_name='Lorel&&Hardy'
where  code = 69;

Do not try those tricks at home.

I came home last Thursday hopefully finish my little WebService project,
while i opened my project there it was - an error, something about cannot open web pages.
I've tried to open my Consumer Web Application project - same error occurred.
The really strange behavior was while trying to open my COM+  clicking on "my computer" tree node that cause in strange closing window?! no error written.

While surfing the net - i found explanation about how to fix the problem- which include full exhausting description about how to re-install your component services.
so continue goolge up some of my event log errors, and finally I found something that would be good try before starting the component services re-installation.

run those command lines:
regsvr32 oleaut.dll
regsvr32 ole32.dll
afterward, I've tried to enter the COM+ again and it works just fine.
And even my projects are running great (even my undocumented bugs disappear).

I hope it will be helpful for you too, it is worthwhile to attempt this before re-installing the COM+.

A little bit about ICQ - I always have strange problems when my bro install/upgrade versions,
I tell you don't mess with those people.

Try this CIA place,
There are many rumors about the sources for this site data, probably not really CIA data, but this is a great place to learn a little bit more about places in the world.

The Great think I found out that you can compare between countries/locations attributes/data.

I also appreciate this site as a developer for its simplicity, while you can find a lot of data in many variation.

keep it simple!

Damn they good.

Google invite you to upgrade your movies search (for free of-course)
using their new Google Video (still in beta) site.

Try searching for "beitar" and find out who is the best team in israel.

Last week I was hit by the customer-programmer strange relationship.

Two days before ending the coding session we eventually find out that one of our modules is far-away from the customer expectations.

That's of-course not the first time, but again? I was quite sure that this time we did every thing by the book, probably wrong.

After I took a day or two for thinking I want to share my thoughts:

1) Customer: completely not what I meant, I said that…, we need…

The worst case, nightmare of every Developer/Manger and even Customer, when the customer for the first time(last session of coding or even at the acceptance tests) understand that what he said and the things that were understood (written by the team and signed by him) are completely different.

2) Customer: That's good…, yes…, OK… I just want to change the screen instead of all Textboxes to AutoCompleteBox.

That was not written as one of the requirements – of course, why we didn't think about this…

I am not gonna answer those questions (I'll provide my point of view in the future)

Also there are a lot of books and other stuff for this.

We can minimize the appearance of the Second and we can almost prevent the First, but shit happens.

I'll tell you what really annoying me:

- Finally, we got to the prioritize stage for those new add-ins, and right now the customer start showing you his skills/knowledge in development, what's the problem? I saw that in Hattrick also at Google map so why you wrote 1-week? And that's go on for each feature.

From my point of view I've got some advices:

- Don’t spend your time on argue (who was wrong and why), book another meeting for special investigation/conclusion.

- Extending the first sentence, don't miss your main goal! which is to find out what should be done for the next time!

- Understand the Huge Gap between you and your customer. (different terms, expressions)

This will help you both to prevent such incidents.

- Work together but don’t afraid to say what you think, in those special meetings talk about the problems from your point of view but always think about new solutions(for those Gaps).

My last advice:

Enjoy your work, this will help you overcome such b(/s)ad days.

Yesterday I was in Microsoft Windows Vista Meeting,
and I'll gonna tell you my overview about the new tools they represent there:

1) Windows Vista Better Deployment:
WIM - new file format for images.
XImage - tool for creating such kind of images.
As they represent it there the replacement to others such as: Ghost, MagicIso, Drive Image, etc.
The Highlight is that windows Vista keep in single (Master.WIM) Image the Installation images.
Even when we will install new program (SP, for example) we will Add new Image to our Master single Image.
This will decrease file size, reduce installation time and IMHO, the most significant, it will decrease the needs of stupid guidelines.
WPE/PE - Windows PreInstallation Environment, great tool to configure and diagnose hardware problems(GUI Based). will be used before launching the setup process.

You Can Enjoy the Windows Automated Installation Kit (WAIK).
Inside you can find the XImage.exe, WindowsPE etc.
(I didn't try this, yet!, but as everyone out there said it is a must, at least the two tools above.)

2) Windows Better Protection:
Microsoft Client Protection - new product which will help you protect you computer, network, servers, etc.
This tool provide single solution against threats, viruses, hijacks, malicious code, and spy-wares.
you can download a version for your XP in here:

3) Other Cool Tools:
Microsoft USB Flash Drive Manager - Client Side Application which help you create friendly names to your different flash drives, auto-run feature and also backup feature for your files.
IMHO, it seems useless right now, but it is still cool tool.
Microsoft Location Finder - Client Side Application which find your location using your access points, ISP DNS, Subnet etc.
The funny thing is that when introducing this tool it showed us that we located in Dublin while we where sitting in Israel (blame the proxy).
Again, IMHO, there some people in Microsoft which are very bored, I won't use this.

T2S&S
(Time to shower and sleep)

This is introduction, for all those all over the world, that reading my blog: "Yom-Kipur" - is an important day for us (Jewish), this day is dedicated for self criticism. every person(OK, almost everyone) is fasting for one day (for example, this year from Wednesday at 5PM till Thursday at 6PM) while most of us spent the whole day at the synagogue, praying to god to forgive us for all the sins (like coding on Saturday) we done last year.

Yesterday while talking with my atheists friends i got revelation, they all where interested on the result between France to Cyprus (last game at the qualification for Germany 2006) (of course France won), the Israeli team needed Cyprus victory to qualify to the next round.

I was thinking about "Yom-Kipur" War 32 years ago (1973), which start at the day of the Kipur fast, which most of the Israel\Jewish didn't even know it started.

And then felt pride to be Jewish, one special day for thinking about good and wrong, for praying to god.

And for all those atheists, I am pretty sure that if most of the people then ("Yom-Kipur" war) where like you we probably where not here today (losing this game too).

be free, be Jewish!

Hi This is my Technorati Profile
Enjoy it.

Hello all,
I thought about it a lot, should I write my own weblog? Or maybe use an existing?
To write? About what?
which language to choose? (for the programmaholic(i think this is a new word) of you i meant hebrew\english)

finally I decided. . .
I will write about:
programming, .Net, C#, JavaScript/VBScript, VS.Net and its so-so (middling) designer, css, html,
about my secret colleagues, etc.

so, lets the party begin.