Reply to: SQL placeholders

[DimPrawn]

2006 is 2004 version with a bit of gloss. Same story.

[Joe Black]

Why give any adaptors at all, feck, we'll all implement them in C#!!! It's fun and the project has all the time in the world!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I mean, what are the chances that anyone has data in xls files? It's not like you would expect Mictosoft Biztalk to be able to consume Microsoft XL files out of the box is it. No we'll resort to low level coding everything! More lines of code, that's the answer!

Speaking of which, not having used the latest Biz, what's the story with Orchestrations, since that was more a C flat with the 2004 version.

PS: Yes, on a major project I worked on we did indeed have to build everything, adaptors, pipeline components, custom calls from Orchestrations and even a replacement for the HAT.

Still, it was the word 'Biztalk' which managed to secure them the out of their league project in the first place.

[DimPrawn]

The consultancy doesn't pay income tax on that. Probably all ends up in an company registered offshore, and a donation to New Labour ensures the tax man turns a blind eye. Get real. Income tax.

[AtW]

£1500 per day, it must hurt to pay income tax on that

[DimPrawn]

I'm not implementing it mate. A consultancy that charges £1500/day per developer is.

Makes my cost look like petty cash.

[AtW]

Then paying a few grand for custom adapter should not be a problem then, perhaps you can sacrifice some of your fat threaded-like margin for that?

[DimPrawn]

I'm only adding about £100K to the cost of the project, so cheap.

[AtW]

Worth every penny of the £10,000 processor license!!!

And your invoice was for how much again...

[DimPrawn]

Wow Joe, that's great news.

So all anyone has to do to use Microsoft Biztalk with xls files is to resort to implementing their own custom adaptor?

That's so thoughtful of them not to put an obvious piece of functionality into their product. Hey let's let everyone reinvent the wheel! Why give any adaptors at all, feck, we'll all implement them in C#!!! It's fun and the project has all the time in the world!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I mean, what are the chances that anyone has data in xls files? It's not like you would expect Mictosoft Biztalk to be able to consume Microsoft XL files out of the box is it. No we'll resort to low level coding everything! More lines of code, that's the answer! I mean, testers are free and adding custom code can only be a good thing, right?

Thank goodness for Biztalk!

It's all so easy and "feature rich"!

Worth every penny of the £10,000 processor license!!!

[Joe Black]

They could have made Biztalk able to use xls files but they didn't.

Yes they did. XLS files are only a custom adaptor away.

[AtW]

Ze swines.

[DimPrawn]

They could have made Biztalk able to use xls files but they didn't.

NOW GET OVER IT!!!

[AtW]

Haven't you just answered your own question of why?

They could have made it more powerful while still providing benefits of parsing query only once, just leave table name resolves and stuff like that until the last moment.

[DimPrawn]

I am still on Finisar, but I believe placeholders wise it is fundamendal issue that they can't have the kind of stuff above - they want to compile statement fully, so table name should be known in advance, will have to change it the same way I do now for each query, but then prepare it (once table name is known during batch inserts) and use that prepared statement.

Also ?nnn placeholders don't seem to work in it

Haven't you just answered your own question of why?

[AtW]

I am still on Finisar, but I believe placeholders wise it is fundamendal issue that they can't have the kind of stuff above - they want to compile statement fully, so table name should be known in advance, will have to change it the same way I do now for each query, but then prepare it (once table name is known during batch inserts) and use that prepared statement.

Also ?nnn placeholders don't seem to work in it