named parameters

XMLWordPrintable

    • Type: Enhancement
    • Resolution: Duplicate
    • Priority: P4
    • None
    • Affects Version/s: 5.0
    • Component/s: core-libs
    • x86
    • linux

      A DESCRIPTION OF THE REQUEST :
      it would be nice to have named parameters in jdbc like
      select * from table where field1=:param1 and field2=:param2

      JUSTIFICATION :
      one have sometimes query containing one parameter multiple times.
      e.g. select * from table where (field1=:param1 and field2=:param2) or (field1=:param1 and field2=:param3)
      additionally complex queries are more readable.

      EXPECTED VERSUS ACTUAL BEHAVIOR :
      EXPECTED -
      1. see example obove or
      2. via jdbc-escape
      ACTUAL -
      only anonymous parameters allowed.

            Assignee:
            Lance Andersen
            Reporter:
            Girish Manwani (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:
              Imported:
              Indexed: