• bphipps-931675 (6/21/2011)


    Celko

    Some version of this mis-use of SQL gets invented again every few months. It is a slow, dangerous mess. Are you familar with the long parameters list idiom? SQL is a data base language, not a tool for writing parsers.

    Don't you just love people who like to shoot stuff down without providing an alternative to the problem at hand.

    If it's such a misuse what is the solution? Write reports that only let the users select one item at a time? My users would consider that a "non-solution".

    Thanks for backing me up on this.

    Todd Fifield