Sure. Here's the JSON string being returned by the server. The only
thing that will need some fiddling is that the year is being returned
as a float. Not sure how to get that displayed as just an integer in
JS.
{"COLUMNS":
["REFERENCEID","AUTHOR","DETAIL","REFYEAR","REFTYPE"],"DATA":[[1,"Chen
& Chen","Chinese Herbs and Recipes, Second Revision",2009.0,1],
[16,"Dana Cat","","",1],[5,"Simon Becker","Chinese Medicine Today",
2008.0,1],[14,"tom cat","",2009.0,1],[4,"Becker, Simon","Chinese
Medicine Today",2009.0,2],[3,"Dana","Dana's Secret Pasta Recipe",
2008.0,5],[15,"bob cat","",2007.0,5]]}
On Apr 14, 4:32 pm, MorningZ <morni...@gmail.com> wrote:
> Can you give an example of the JSON to help?
>
> On Apr 14, 9:24 am, Nando <d.na...@gmail.com> wrote:
>
> > Hi,
>
> > I'm a jQuery and Javascript noob, and can't seem to get this to work.
> > The JSON output looks right to me via console.log(result), but the
> > select box isn't being populated. The select box needs to be populated
> > onfocus, because the interface is set up to allow the user to add new
> > options to the select via a popup without a page refresh.
>
> > $(function() {
>
> > $.getJSON('index.cfm?view=listReferenceJSON',
> > function(result,status) {
> > console.log(result)
> > var str = ''
> > for(var i=0; i < result.ROWCOUNT; i++) {
> > str+= '<option value="'+result.DATA.REFERENCEID[i]
> > +'">'+result.DATA.AUTHOR[i]+' ('+result.DATA.REFYEAR[i]+')<option>'
> > }
> > $("refSelectBox").bind('focus', function(event, ui) {
> > $("#refSelectBox").html(str)
> > }
> > });
>
> > });
>
> > <select id="refSelectBox"></select>
>
> > Thanks in advance for any help.
>
> > Nando
