Difference between revisions of "Help:Sandbox"
| Line 47: | Line 47: | ||
{{Special:NewestPages/-/10}} | {{Special:NewestPages/-/10}} | ||
[[Special:NewestPages|more...]] | [[Special:NewestPages|more...]] | ||
| + | |||
| + | |||
| + | |||
| + | <!--c1--><div class='codetop'>CODE</div><div class='codemain'><!--ec1--><br>SELECT *<br>FROM ca_contact<br>WHERE last_name = 'Smith'<br><!--c2--></div><!--ec2--> | ||
Revision as of 15:30, 27 January 2008
Feel free to try out the wiki syntax in this page.
Here is the query you would use to retrieve all Service Desk contacts with the last name "Smith" :
<source lang="sql">
SELECT *
FROM ca_contact
WHERE last_name = 'Smith'
</source>
<source lang="sql" line> SELECT * FROM ca_contact WHERE last_name = 'Smith' </source>
Contents
Source lang=html4strict
<source lang="html4strict"> <PDM_IF $args.id != 0> ImgBtnCreate("makechild", "Create Child", "create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')", true, 0,"Create a Child"); </PDM_IF> </source>
Source lang=javascript
<source lang="javascript"> <PDM_IF $args.id != 0> ImgBtnCreate("makechild", "Create Child", "create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')", true, 0,"Create a Child"); </PDM_IF> </source>
Source lang=php
<source lang="php"> <PDM_IF $args.id != 0> ImgBtnCreate("makechild", "Create Child", "create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')", true, 0,"Create a Child"); </PDM_IF> </source>
Top Ten Pages
<TopTenPages>10</TopTenPages> more...
Newest Pages
Special:NewestPages/-/10 more...
SELECT *
FROM ca_contact
WHERE last_name = 'Smith'
