Announcement

Collapse
No announcement yet.

Field lookup sql

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Field lookup sql

    Hi,
    Is it possible to have 2 lookup sql on one select field?
    For example, I have a radio button with 2 options.
    If radio1 is selected, the select field lookup is "select * from table_a a where a.field_1 = {field1}"
    If radio2 is selected, the select field lookup is "select * from table_b"

    I put the query on each radio option value, and use ajax processing. It didn't work.
    Is it possible? Can anyone tell me how?

    Thanks a lot!

  • #2
    Try using a global var as table name in your select, and onChange of your radios modify global var value
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

    Comment


    • #3
      I have the same problem. Using Global Variables for something like that is very bad practice. It seems like there is some bug in SC. I noticed this problem long time ago. Had to deal with globals, but I'm not happy doing it this way. Global VARs should be avoided is possible.
      -----------------------------------------
      Arthur Klisiewicz
      dATA POINT SOFTWARE
      www.datapointsoftware.com

      Comment

      Working...
      X