Skip to content

Instantly share code, notes, and snippets.

@jcleblanc
Created January 5, 2011 23:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save jcleblanc/767246 to your computer and use it in GitHub Desktop.
Save jcleblanc/767246 to your computer and use it in GitHub Desktop.
Given these inputs for an INSERT:
<inputs>
<key id="guid" type="xs:string" paramType="path" required="true" />
<key id="title" type="xs:string" paramType="variable" required="true" />
<key id="type" type="xs:string" paramType="variable" private="true" default="nfsimple"/>
<key id="appmsg" type="xs:string" paramType="variable" required="true" />
<key id="category" type="xs:string" paramType="variable" />
<key id="usrmsg" type="xs:string" paramType="variable" />
<key id="sendmsg" type="xs:string" paramType="variable" />
<key id="expiry" type="xs:string" paramType="variable" />
<map id="image" type="xs:string" paramType="variable" />
<map id="choice1" type="xs:string" paramType="variable" required="true"/>
<map id="choice2" type="xs:string" paramType="variable" />
<map id="choice3" type="xs:string" paramType="variable" />
</inputs>
Set the values (and map values) via this query:
insert into social.notifications (guid, title, appmsg, category, image.size, image.width, image.height, image.imageUrl, expiry, choice1.label, choice1.urltemplate) values (me, 'Welcome to SNAPIVille', 'Here\'s some gold. Can you send some back to me?', 'gift', '100x100', 100, 100, 'http://upload.wikimedia.org/wikipedia/en/6/64/FarmVille_logo.png', 1443603778, 'Click Here1', 'http://pulse.yahoo.com/y/apps/DQxo5h58/?snapi_page=index.php&request_button_href_success=1&request_id={id}');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment