drop down items not appearing for one user

Carolyn Anderson
Carolyn Anderson
in AppWorks #1

Has anybody had this? I have a form that has been working for ages (v9.0.2.2 - no possibiity to upgrade to hotfix whatever at the mo), all users can get drop-downs except that for one user, one drop-down doesn't load with items (the form has 4, 3 working ok). It's not user-specific, as I've tested it with userID on our forms-authenticated site and it works ok, think it's pc specific, but there's no obvious things turned off like javacript or popups. The dropdown is working off a business object using a fixed login, so again not dependent on user.

Tagged:

Comments

  • Scott_Leclerc
    Scott_Leclerc
    #2

    What is the code for the Option List of this drop down?

  • Carolyn Anderson
    Carolyn Anderson
    #3

    It's a bog-standard Select statement but passing in the value of a previous drop-down.

     

    SelectSql(

     

    new Climat(),"SELECT PracticeCodes.PracticeCodeName, PracticeCodes.PracticeCodeID FROM PracticeCodes WHERE PracticeCodes.CategoryID = " + EbibleData1.CategoryID1 + " AND PracticeCodes.active = 1 ORDER BY PracticeCodes.PracticeCodeName")

     

    I have tested it as the same user on my own pc and it works fine, it is just his pc that doesn't like it.

     

  • Scott_Leclerc
    Scott_Leclerc
    #4

    What are the differences between the two pc's?  Is the browser verison the same on both?  Are they both running in the same security zone in the browser?

  • Jerome_Pearce
    Jerome_Pearce
    #5

     

    Carolyn wrote:

    It's a bog-standard Select statement but passing in the value of a previous drop-down.

     

    SelectSql(

     

    new Climat(),"SELECT PracticeCodes.PracticeCodeName, PracticeCodes.PracticeCodeID FROM PracticeCodes WHERE PracticeCodes.CategoryID = " + EbibleData1.CategoryID1 + " AND PracticeCodes.active = 1 ORDER BY PracticeCodes.PracticeCodeName")

     

    I have tested it as the same user on my own pc and it works fine, it is just his pc that doesn't like it.

     

    Just to eliomiate any other factors, I would turn that CategoryId1 into a Paramater (using SQLArg()). If not filled, it could be null, and that would probably create an invalid SQL query. In any case it is best practice (ours anyway).

     

Categories

image
OpenText CE Products
AppWorks
Gateway & Platform