StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4000764
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-10-22T20:37:44.037
FavoriteCount
0
LastActivityDate
2010-10-22T20:37:44.037
LastEditDate
LastEditorUserId
0
OwnerUserId
470838
ParentId
3999283
PostTypeId
2
Score
8
ViewCount
0
LastEditorDisplayName
text
Body
<p>First thing to know is <a href="http://www.rahulsingla.com/blog/2010/05/jquery-encode-decode-arbitrary-objects-to-and-from-json" rel="noreferrer">jQuery Ajax requests do not encode arrays so have you to use something else to encode the data</a> (this is where jquery.JSON.js comes from referenced below). So with a the JSON encoded found there, I then figured out the correct syntax by working with <a href="http://cfquickdocs.com/cf8/?getDoc=cfajaxproxy#cfajaxproxy" rel="noreferrer">cfajaxproxy</a> and studying the URL it generates in Firebug:</p> <p><a href="http://localhost/remote.cfc?method=getResults&argumentCollection=%7B%22q%22%3A%5B1%2C2%5D%7D" rel="noreferrer">http://localhost/remote.cfc?method=getResults&argumentCollection=%7B%22q%22%3A%5B1%2C2%5D%7D</a></p> <p>Yes the "argumentcollection" approach is correct, and the variable "q" with a reference to an array is in there. </p> <p>I used the following code as a test bed:</p> <p><strong>remote.cfc</strong></p> <pre><code><cfcomponent output="false"> <cffunction access="remote" name="getResults" returntype="struct" returnformat="JSON" output="no"> <cfargument name="q" required="true" type="array" /> <cfreturn {a=1,b=2}> </cffunction> </cfcomponent> </code></pre> <p><strong>remote.cfm</strong> to see how cfajaxproxy generates its url</p> <pre><code><cfajaxproxy cfc="Remote" jsclassname="Remote"> <cfoutput> <script language="javascript" type="text/javascript"> var oRemote = new Remote(); alert(oRemote.getResults([1,2])); </script> </cfoutput> </code></pre> <p><strong>remote.html</strong> doing it with jQuery</p> <pre><code><script language="javascript" src="http://code.jquery.com/jquery-1.4.3.min.js"></script> <script language="javascript" src="jquery.JSON.js"></script> <script language="javascript" type="text/javascript"> var argumentCollection = { q: [1,2] }; $.ajax({ url: 'remote.cfc', data: { method: 'getResults', argumentCollection: $.JSON.encode(argumentCollection) }, success: function(response) { alert(response); }, dataType: 'json' }); </script> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow can I send an array variable to a ColdFusion CFC remote method via ajax using jQuery?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USorangepips
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow can I send an array variable to a ColdFusion CFC remote method via ajax using jQuery?
  singulars
  PostTypePostTypeId
  PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
3. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId
1. COWell, I'd say that jQuery does encode arrays, just not in a way that ColdFusion can accept. By default in jQuery 1.4.3, arrays are encoded in a fashion compatible with PHP and Ruby on Rails, by providing multiple parameters, with a parameter name that adds "[]" to the variable name. Using the "traditional" setting, it encodes them the same way an HTML form does for multiple checkboxes, just sending multiple of the parameter. Your approach for figuring this out matched mine. Thanks for the detailed sample code!
  singulars
  PostPostId
  PO
  UserUserId
  USjrduncans

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.