Well, just putting the JSON into a JSON viewer (this one is excellent: http://www.codeplex.com/JsonViewer) you pasted into your last post
you have no property of ".ROWCOUNT", so that's a bad start.. this is a quick mock up that works http://paste.pocoo.org/show/112508/ (sorry about the if's... i never trust that the data is intact/ complete) On Apr 14, 10:50 am, Nando <d.na...@gmail.com> wrote: > 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
