drop down items not appearing for one user

Carolyn Anderson

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.

Scott_Leclerc

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

Carolyn Anderson

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

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

 

---

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).