I see I'm really still a complete klutz at javascript. Thanks very much Stephan! I will give that a try.
On Apr 14, 5:56 pm, MorningZ <morni...@gmail.com> wrote: > 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
