Difference between revisions of "Help:Sandbox"
(→Newest Pages) |
|||
| Line 52: | Line 52: | ||
<!--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--> | <!--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--> | ||
| − | + | <pre><source lang=sql> | |
| + | SELECT * | ||
FROM ca_contact | FROM ca_contact | ||
WHERE last_name = 'Smith' | WHERE last_name = 'Smith' | ||
| + | </source></pre> | ||
Revision as of 20:38, 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'
<source lang=sql> SELECT * FROM ca_contact WHERE last_name = 'Smith' </source>
