This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



Apr 4, 2012, 2:55 PM
31 Posts
topic has been resolvedResolved

Combobox values and limits

  • Category: Server Side JavaScript
  • Platform: Windows
  • Release: 8.5.3
  • Role: Developer
  • Tags: combobox,values
  • Replies: 2
Having a problem with a combobox - I know there is a 64k limit but where exactly is that limit? What should I do differently to get around this?
 
Here is my scenario:
Combobox doing a lookup to an external database view with 182 documents - the column in the comboxbox has CompanyName + City + State - would something like this exceed 64k?
I am not getting an error using the combobox - it is just empty.
 
Here is the code for the combobox: (External database is on same server, selection will be bound to the same database)
 
<xp:comboBox id="comboBox1" value="#{docOrder.ADFirm}">
    <xp:selectItems>
        <xp:this.value><![CDATA[#{javascript:var db = new Array(@Name("[CN]",@Subset(@DbName(),1)), "Folder\Folder2\DATABASE.NSF");
@DbColumn(db,"(ADLookup)",3);}]]></xp:this.value>
    </xp:selectItems>
</xp:comboBox>
 
Thoughts?
 
Thanks,
Kendra 
Apr 4, 2012, 5:57 PM
298 Posts
I think you have to double up on your backslashes
Try two backslashes in your array creation for the file path:                   Also, I am not sure you have to use @Name in your first parameter, not that it should matter, but, why complicate things... I can't imagine your 182 items being over 64K of data unless the data were large text strings. Howard
Apr 4, 2012, 6:56 PM
31 Posts
Re: Combobox values and limits
Bingo - the double slashes worked!! Thanks Howard!

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal