• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Reply to: SQL placeholders

Collapse

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

  • You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
  • You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
  • If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Previously on "SQL placeholders"

Collapse

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

    Leave a comment:


  • Joe Black
    replied
    Originally posted by DimPrawn
    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.
    Last edited by Joe Black; 27 November 2006, 19:29.

    Leave a comment:


  • DimPrawn
    replied
    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.

    Leave a comment:


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

    Leave a comment:


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

    Makes my cost look like petty cash.

    Leave a comment:


  • AtW
    replied
    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?

    Leave a comment:


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

    Leave a comment:


  • AtW
    replied
    Originally posted by DimPrawn
    Worth every penny of the £10,000 processor license!!!
    And your invoice was for how much again...

    Leave a comment:


  • DimPrawn
    replied
    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!!!

    Last edited by DimPrawn; 27 November 2006, 18:49.

    Leave a comment:


  • Joe Black
    replied
    Originally posted by DimPrawn
    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.

    Leave a comment:


  • AtW
    replied
    Ze swines.

    Leave a comment:


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

    NOW GET OVER IT!!!

    Leave a comment:


  • AtW
    replied
    Originally posted by DimPrawn
    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.

    Leave a comment:


  • DimPrawn
    replied
    Originally posted by 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
    Haven't you just answered your own question of why?

    Leave a comment:


  • AtW
    replied
    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

    Leave a comment:

Working...
X