Thanks Rob I recreated your example with the cfartgallery data source in CF.
Here is my method: <cffunction name="data" access="remote" returntype="query"> <cfset var q = ''/> <cfquery name="q" datasource="cfartgallery"> select * from artists </cfquery> <Cfif q.recordcount eq 0> <Cfset q = queryNew("artistID,firstName")> <Cfset queryAddRow(q,1)/> <Cfset q.artistID = 0/> <Cfset q.firstName=''/> </cfif> <Cfreturn q/> </cffunction> Here is my call: <script> $.ajax({ type: 'get', url: 'data.cfc', data: { method: 'data', }, dataType: 'json', success: function (result) { $("#artistID").val(result.DATA[0][2]); $("#firstName").val(result.DATA[0][12]); } }); </script> So how do I output the data on the page? >Well, I don't know what standardiseCfQueryJSON does, but here's what I do: ><cffunction name="listFields" displayname="List Fields" access="remote" >returntype="query"> ><cfargument name="growerID" displayName="Grower ID" type="numeric" hint="I >am the Grower ID" required="true" /> > ><cfset var q = ''/> > <cfquery name="q"> >Select * from `field` >where g_id = <cfqueryparam value="#arguments.growerid#" >cfsqltype="cf_sql_integer" /> >order by fieldname ></cfquery> > <Cfif q.recordcount eq 0> ><Cfset q = queryNew("f_id,FieldName")> ><Cfset queryAddRow(q,1)/> ><Cfset q.f_id = 0/> ><Cfset q.fieldname=''/> ></cfif> > <Cfreturn q/> ></cffunction> > >and then on the calling page: > > $.ajax({ > type: 'get', > url: '/cfcs/field/fields.cfc', > data: { > method: 'fieldData', > fieldID: $("#fielder").val() > }, > dataType: 'json', > success: function (result) { > $("#fieldname").val(result.DATA[0][2]); > $("#acres").val(result.DATA[0][12]); > $("#911num").val(result.DATA[0][6]); >} >}); > >You are taking a Query and putting it in a struct. I would either leave it >a query (as Above) or put it in an array > >HTH, > >Rob > > > > >On Fri, 6 Mar 2015 at 10:20 Torrent Girl <moniqueb...@gmail.com> wrote: > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:360220 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm