<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
		<id>http://greggsmith.net/wiki/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Admin</id>
		<title>SDU - User contributions [en]</title>
		<link rel="self" type="application/atom+xml" href="http://greggsmith.net/wiki/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Admin"/>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Special:Contributions/Admin"/>
		<updated>2026-04-17T15:52:21Z</updated>
		<subtitle>User contributions</subtitle>
		<generator>MediaWiki 1.26.1</generator>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Attach_Event_Macro&amp;diff=1172</id>
		<title>Attach Event Macro</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Attach_Event_Macro&amp;diff=1172"/>
				<updated>2008-02-11T00:36:35Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: Redirecting to Events and Macros&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;#redirect [[Events and Macros]]&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=1050</id>
		<title>Help:Sandbox</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=1050"/>
				<updated>2008-01-27T21:29:43Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Feel free to try out the wiki syntax in this page.&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;!-- test your skills below this line --&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Here is the query you would use to retrieve all Service Desk contacts with the last name &amp;quot;Smith&amp;quot; :&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot; line&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=html4strict==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=javascript==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;javascript&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=php==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;php&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Top Ten Pages==&lt;br /&gt;
&amp;lt;TopTenPages&amp;gt;10&amp;lt;/TopTenPages&amp;gt;&lt;br /&gt;
[[Special:Popularpages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Newest Pages==&lt;br /&gt;
{{Special:NewestPages/-/10}}&lt;br /&gt;
[[Special:NewestPages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;!--c1--&amp;gt;&amp;lt;div class='codetop'&amp;gt;CODE&amp;lt;/div&amp;gt;&amp;lt;div class='codemain'&amp;gt;&amp;lt;!--ec1--&amp;gt;&amp;lt;br&amp;gt;SELECT *&amp;lt;br&amp;gt;FROM ca_contact&amp;lt;br&amp;gt;WHERE last_name = &amp;amp;#39;Smith&amp;amp;#39;&amp;lt;br&amp;gt;&amp;lt;!--c2--&amp;gt;&amp;lt;/div&amp;gt;&amp;lt;!--ec2--&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&amp;lt;source lang=sql&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
 FROM ca_contact&lt;br /&gt;
 WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=1049</id>
		<title>Help:Sandbox</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=1049"/>
				<updated>2008-01-27T21:29:18Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Feel free to try out the wiki syntax in this page.&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;!-- test your skills below this line --&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Here is the query you would use to retrieve all Service Desk contacts with the last name &amp;quot;Smith&amp;quot; :&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&amp;lt;source lang=&amp;quot;sql&amp;quot; line&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&amp;lt;/pre&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=html4strict==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=javascript==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;javascript&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=php==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;php&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Top Ten Pages==&lt;br /&gt;
&amp;lt;TopTenPages&amp;gt;10&amp;lt;/TopTenPages&amp;gt;&lt;br /&gt;
[[Special:Popularpages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Newest Pages==&lt;br /&gt;
{{Special:NewestPages/-/10}}&lt;br /&gt;
[[Special:NewestPages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;!--c1--&amp;gt;&amp;lt;div class='codetop'&amp;gt;CODE&amp;lt;/div&amp;gt;&amp;lt;div class='codemain'&amp;gt;&amp;lt;!--ec1--&amp;gt;&amp;lt;br&amp;gt;SELECT *&amp;lt;br&amp;gt;FROM ca_contact&amp;lt;br&amp;gt;WHERE last_name = &amp;amp;#39;Smith&amp;amp;#39;&amp;lt;br&amp;gt;&amp;lt;!--c2--&amp;gt;&amp;lt;/div&amp;gt;&amp;lt;!--ec2--&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&amp;lt;source lang=sql&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
 FROM ca_contact&lt;br /&gt;
 WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Pdm_load&amp;diff=1048</id>
		<title>Pdm load</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Pdm_load&amp;diff=1048"/>
				<updated>2008-01-27T21:16:26Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Use pdm_load to load information directly into the database and bypass the GUIs. &lt;br /&gt;
&lt;br /&gt;
== Usage ==&lt;br /&gt;
pdm_load -f [filename] [-a] [-c] [-e] [-h] [-i] [-m] [-v] [-r] [-u] [-x]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{|&lt;br /&gt;
|-&lt;br /&gt;
! Command&lt;br /&gt;
! Description&lt;br /&gt;
! Remarks&lt;br /&gt;
|-&lt;br /&gt;
| -a&lt;br /&gt;
| update all matching data&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -c&lt;br /&gt;
| check only, no change to data&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -e&lt;br /&gt;
| treat escapes literally&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -h&lt;br /&gt;
| help&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -i&lt;br /&gt;
| insert only&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -m&lt;br /&gt;
| notify domsrvr of mass update&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -v&lt;br /&gt;
| verbose&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -r&lt;br /&gt;
| remove&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -u&lt;br /&gt;
| update only&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -x&lt;br /&gt;
| use locale sensitive numeric input formats&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Examples ==&lt;br /&gt;
* A standard load. This load assumes that the file contains ids or uuids for all entries.&lt;br /&gt;
 pdm_load -f extract.txt -v&lt;br /&gt;
&lt;br /&gt;
* Using the -i to load data will force the creation of new ids and uuids. The file being loaded should be void of any id and uuid data.&lt;br /&gt;
 pdm_load -f cnt_data.csv -i -v&lt;br /&gt;
&lt;br /&gt;
* Removing some info (not shared by another application) from a file. Use the -r&lt;br /&gt;
 pdm_load -f InfoToRemove.dat -r -v 2&amp;gt;load.err&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
----&lt;br /&gt;
&amp;lt;div align='center'&amp;gt;&amp;lt;font color=&amp;quot;red&amp;quot;&amp;gt;To make corrections or additions to this article, select the ''edit'' tab above.&amp;lt;br&amp;gt;&lt;br /&gt;
To discuss or ask questions about this article, select the ''discussion'' tab above.&amp;lt;/font&amp;gt;&amp;lt;/div&amp;gt;&lt;br /&gt;
&lt;br /&gt;
[[Category:Commands]]&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Pdm_load&amp;diff=1047</id>
		<title>Pdm load</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Pdm_load&amp;diff=1047"/>
				<updated>2008-01-27T21:14:28Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: /* Examples */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Use pdm_load to load information directly into the database and bypass the GUIs. &lt;br /&gt;
&lt;br /&gt;
== Usage ==&lt;br /&gt;
pdm_load -f [filename] [-a] [-c] [-e] [-h] [-i] [-m] [-v] [-r] [-u] [-x]&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
{|&lt;br /&gt;
|-&lt;br /&gt;
! Command&lt;br /&gt;
! Description&lt;br /&gt;
! Remarks&lt;br /&gt;
|-&lt;br /&gt;
| -a&lt;br /&gt;
| update all matching data&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -c&lt;br /&gt;
| check only, no change to data&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -e&lt;br /&gt;
| treat escapes literally&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -h&lt;br /&gt;
| help&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -i&lt;br /&gt;
| insert only&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -m&lt;br /&gt;
| notify domsrvr of mass update&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -v&lt;br /&gt;
| verbose&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -r&lt;br /&gt;
| remove&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -u&lt;br /&gt;
| update only&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| -x&lt;br /&gt;
| use locale sensitive numeric input formats&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
== Examples ==&lt;br /&gt;
* A standard load. This load assumes that the file contains ids or uuids for all entries.&lt;br /&gt;
&amp;lt;source lang=dos&amp;gt;pdm_load -f extract.txt -v&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
* Using the -i to load data will force the creation of new ids and uuids. The file being loaded should be void of any id and uuid data.&lt;br /&gt;
 pdm_load -f cnt_data.csv -i -v&lt;br /&gt;
&lt;br /&gt;
* Removing some info (not shared by another application) from a file. Use the -r&lt;br /&gt;
 pdm_load -f InfoToRemove.dat -r -v 2&amp;gt;load.err&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
----&lt;br /&gt;
&amp;lt;div align='center'&amp;gt;&amp;lt;font color=&amp;quot;red&amp;quot;&amp;gt;To make corrections or additions to this article, select the ''edit'' tab above.&amp;lt;br&amp;gt;&lt;br /&gt;
To discuss or ask questions about this article, select the ''discussion'' tab above.&amp;lt;/font&amp;gt;&amp;lt;/div&amp;gt;&lt;br /&gt;
&lt;br /&gt;
[[Category:Commands]]&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=1046</id>
		<title>Help:Sandbox</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=1046"/>
				<updated>2008-01-27T20:38:33Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: /* Newest Pages */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Feel free to try out the wiki syntax in this page.&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;!-- test your skills below this line --&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Here is the query you would use to retrieve all Service Desk contacts with the last name &amp;quot;Smith&amp;quot; :&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot; line&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=html4strict==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=javascript==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;javascript&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=php==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;php&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Top Ten Pages==&lt;br /&gt;
&amp;lt;TopTenPages&amp;gt;10&amp;lt;/TopTenPages&amp;gt;&lt;br /&gt;
[[Special:Popularpages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Newest Pages==&lt;br /&gt;
{{Special:NewestPages/-/10}}&lt;br /&gt;
[[Special:NewestPages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;!--c1--&amp;gt;&amp;lt;div class='codetop'&amp;gt;CODE&amp;lt;/div&amp;gt;&amp;lt;div class='codemain'&amp;gt;&amp;lt;!--ec1--&amp;gt;&amp;lt;br&amp;gt;SELECT *&amp;lt;br&amp;gt;FROM ca_contact&amp;lt;br&amp;gt;WHERE last_name = &amp;amp;#39;Smith&amp;amp;#39;&amp;lt;br&amp;gt;&amp;lt;!--c2--&amp;gt;&amp;lt;/div&amp;gt;&amp;lt;!--ec2--&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;pre&amp;gt;&amp;lt;source lang=sql&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
 FROM ca_contact&lt;br /&gt;
 WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&amp;lt;/pre&amp;gt;&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=MediaWiki:Common.css&amp;diff=1045</id>
		<title>MediaWiki:Common.css</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=MediaWiki:Common.css&amp;diff=1045"/>
				<updated>2008-01-27T20:37:10Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: New page: /** CSS placed here will be applied to all skins */ pre { overflow: auto; }&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;/** CSS placed here will be applied to all skins */&lt;br /&gt;
pre { overflow: auto; }&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Simplified_Child_Creation&amp;diff=1041</id>
		<title>Simplified Child Creation</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Simplified_Child_Creation&amp;diff=1041"/>
				<updated>2008-01-27T15:38:39Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: /* Step 1. Create the button */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;This article contains instructions for expediting the child creation process by using information from the parent ticket. &lt;br /&gt;
&lt;br /&gt;
This customization is known to work in all currently supported releases of Service Desk.&lt;br /&gt;
&lt;br /&gt;
== Step 1. Create the button ==&lt;br /&gt;
The first step is to add a &amp;quot;Create a Child&amp;quot; button to the Parent/Child tab. &lt;br /&gt;
&lt;br /&gt;
'''For [[Request|Requests]], [[Incident|Incidents]], and [[Problem|Problems]]:'''&amp;lt;br&amp;gt;&lt;br /&gt;
Add the following code to cr_relreq.htmpl for [[Request|Requests]], in_relreq.htmpl for [[Incident|Incidents]], or pr_relreq.htmpl for [[Problem|Problems]].&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;,&lt;br /&gt;
             &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;,&lt;br /&gt;
             true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
'''For [[Change Order|Change Orders]]:'''&amp;lt;br&amp;gt;&lt;br /&gt;
Add the following code to chg_relchg.htmpl.&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;,&lt;br /&gt;
             &amp;quot;create_new('chg',0,0,0,'','INITFROM=make_child')&amp;quot;,&lt;br /&gt;
             true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
'''For [[Issue|Issues]]:'''&amp;lt;br&amp;gt;&lt;br /&gt;
Add the following code to iss_reliss.htmpl.&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;,&lt;br /&gt;
             &amp;quot;create_new('iss',0,0,0,'','INITFROM=make_child')&amp;quot;,&lt;br /&gt;
             true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
For r11.x releases it is recommended that you edit your pages via the [[Web Screen Painter]]. For older releases you must edit the files directly.&lt;br /&gt;
&lt;br /&gt;
== Step 2. Create the form ==&lt;br /&gt;
The next step is to add a &amp;quot;make_child&amp;quot; form to the main detail page. &lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;1&amp;quot; style=&amp;quot;width:400px;&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
! Ticket Type&lt;br /&gt;
! Detail Page File Name&lt;br /&gt;
|-&lt;br /&gt;
| [[Request]]&lt;br /&gt;
| detail_cr.htmpl&lt;br /&gt;
|-&lt;br /&gt;
| [[Incident]]&lt;br /&gt;
| detail_in.htmpl&lt;br /&gt;
|-&lt;br /&gt;
| [[Problem]]&lt;br /&gt;
| detail_pr.htmpl&lt;br /&gt;
|-&lt;br /&gt;
| [[Change Order]]&lt;br /&gt;
| detail_chg.htmpl&lt;br /&gt;
|-&lt;br /&gt;
| [[Issue]]&lt;br /&gt;
| detail_iss.htmpl&lt;br /&gt;
|-&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The following code provides a few examples of setting name fields, searchable fields, drop-down lists, and free-text fields. Use the examples provided here or add your own. Search the file you are editing for &amp;quot;frm002&amp;quot; and place the make_child form before it. &lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;FORM NAME=&amp;quot;make_child&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=SET.parent VALUE=&amp;quot;$args.persistent_id&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=KEY.parent VALUE=&amp;quot;$args.ref_num&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=SET.customer VALUE=&amp;quot;$args.customer&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=customer_combo_name VALUE=&amp;quot;$args.customer.combo_name&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=SET.category VALUE=&amp;quot;$args.category&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=KEY.category VALUE=&amp;quot;$args.category.sym&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=SET.priority VALUE=&amp;quot;$args.priority&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=SET.description VALUE=&amp;lt;PDM_FMT ESC_STYLE=HTML&amp;gt;&amp;quot;$args.description (created as a child from $args.ref_num)&amp;quot;&amp;lt;/PDM_FMT&amp;gt;&amp;gt;&lt;br /&gt;
&amp;lt;/FORM&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
''Note: For COs only, replace all instances of $args.ref_num with $args.chg_ref_num.''&lt;br /&gt;
&lt;br /&gt;
== Step 3. Clear the web cache ==&lt;br /&gt;
The final step is to clear Service Desk's cache. The methods vary depending on release.&lt;br /&gt;
 &lt;br /&gt;
&amp;lt;font color=&amp;quot;blue&amp;quot;&amp;gt;For r11.x releases&amp;lt;/font&amp;gt; publish your changes via the [[Web Screen Painter]]. The process of publishing automatically initiates a [[pdm_webcache]].&lt;br /&gt;
&lt;br /&gt;
&amp;lt;font color=&amp;quot;blue&amp;quot;&amp;gt;For older releases&amp;lt;/font&amp;gt; execute [[pdm_webcache]] from a command prompt on the [[Primary Server]]. There is no need to run this command on the [[Secondary Server|Secondary Servers]].&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
----&lt;br /&gt;
&amp;lt;div align='center'&amp;gt;&amp;lt;font color=&amp;quot;red&amp;quot;&amp;gt;To make corrections or additions to this article, select the ''edit'' tab above.&amp;lt;br&amp;gt;&lt;br /&gt;
To discuss or ask questions about this article, select the ''discussion'' tab above.&amp;lt;/font&amp;gt;&amp;lt;/div&amp;gt;&lt;br /&gt;
&lt;br /&gt;
[[Category:Customizations]]&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Simplified_Child_Creation&amp;diff=1040</id>
		<title>Simplified Child Creation</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Simplified_Child_Creation&amp;diff=1040"/>
				<updated>2008-01-27T15:37:19Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: /* Step 1. Create the button */&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;This article contains instructions for expediting the child creation process by using information from the parent ticket. &lt;br /&gt;
&lt;br /&gt;
This customization is known to work in all currently supported releases of Service Desk.&lt;br /&gt;
&lt;br /&gt;
== Step 1. Create the button ==&lt;br /&gt;
The first step is to add a &amp;quot;Create a Child&amp;quot; button to the Parent/Child tab. &lt;br /&gt;
&lt;br /&gt;
'''For [[Request|Requests]], [[Incident|Incidents]], and [[Problem|Problems]]:'''&amp;lt;br&amp;gt;&lt;br /&gt;
Add the following code to cr_relreq.htmpl for [[Request|Requests]], in_relreq.htmpl for [[Incident|Incidents]], or pr_relreq.htmpl for [[Problem|Problems]].&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;,&lt;br /&gt;
             &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;,&lt;br /&gt;
             true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
'''For [[Change Order|Change Orders]]:'''&amp;lt;br&amp;gt;&lt;br /&gt;
Add the following code to chg_relchg.htmpl.&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;,&lt;br /&gt;
             &amp;quot;create_new('chg',0,0,0,'','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
'''For [[Issue|Issues]]:'''&amp;lt;br&amp;gt;&lt;br /&gt;
Add the following code to iss_reliss.htmpl.&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;,&lt;br /&gt;
             &amp;quot;create_new('iss',0,0,0,'','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
For r11.x releases it is recommended that you edit your pages via the [[Web Screen Painter]]. For older releases you must edit the files directly.&lt;br /&gt;
&lt;br /&gt;
== Step 2. Create the form ==&lt;br /&gt;
The next step is to add a &amp;quot;make_child&amp;quot; form to the main detail page. &lt;br /&gt;
&lt;br /&gt;
{| border=&amp;quot;1&amp;quot; style=&amp;quot;width:400px;&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
! Ticket Type&lt;br /&gt;
! Detail Page File Name&lt;br /&gt;
|-&lt;br /&gt;
| [[Request]]&lt;br /&gt;
| detail_cr.htmpl&lt;br /&gt;
|-&lt;br /&gt;
| [[Incident]]&lt;br /&gt;
| detail_in.htmpl&lt;br /&gt;
|-&lt;br /&gt;
| [[Problem]]&lt;br /&gt;
| detail_pr.htmpl&lt;br /&gt;
|-&lt;br /&gt;
| [[Change Order]]&lt;br /&gt;
| detail_chg.htmpl&lt;br /&gt;
|-&lt;br /&gt;
| [[Issue]]&lt;br /&gt;
| detail_iss.htmpl&lt;br /&gt;
|-&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
The following code provides a few examples of setting name fields, searchable fields, drop-down lists, and free-text fields. Use the examples provided here or add your own. Search the file you are editing for &amp;quot;frm002&amp;quot; and place the make_child form before it. &lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;FORM NAME=&amp;quot;make_child&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=SET.parent VALUE=&amp;quot;$args.persistent_id&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=KEY.parent VALUE=&amp;quot;$args.ref_num&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=SET.customer VALUE=&amp;quot;$args.customer&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=customer_combo_name VALUE=&amp;quot;$args.customer.combo_name&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=SET.category VALUE=&amp;quot;$args.category&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=KEY.category VALUE=&amp;quot;$args.category.sym&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=SET.priority VALUE=&amp;quot;$args.priority&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;INPUT TYPE=hidden NAME=SET.description VALUE=&amp;lt;PDM_FMT ESC_STYLE=HTML&amp;gt;&amp;quot;$args.description (created as a child from $args.ref_num)&amp;quot;&amp;lt;/PDM_FMT&amp;gt;&amp;gt;&lt;br /&gt;
&amp;lt;/FORM&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
''Note: For COs only, replace all instances of $args.ref_num with $args.chg_ref_num.''&lt;br /&gt;
&lt;br /&gt;
== Step 3. Clear the web cache ==&lt;br /&gt;
The final step is to clear Service Desk's cache. The methods vary depending on release.&lt;br /&gt;
 &lt;br /&gt;
&amp;lt;font color=&amp;quot;blue&amp;quot;&amp;gt;For r11.x releases&amp;lt;/font&amp;gt; publish your changes via the [[Web Screen Painter]]. The process of publishing automatically initiates a [[pdm_webcache]].&lt;br /&gt;
&lt;br /&gt;
&amp;lt;font color=&amp;quot;blue&amp;quot;&amp;gt;For older releases&amp;lt;/font&amp;gt; execute [[pdm_webcache]] from a command prompt on the [[Primary Server]]. There is no need to run this command on the [[Secondary Server|Secondary Servers]].&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
----&lt;br /&gt;
&amp;lt;div align='center'&amp;gt;&amp;lt;font color=&amp;quot;red&amp;quot;&amp;gt;To make corrections or additions to this article, select the ''edit'' tab above.&amp;lt;br&amp;gt;&lt;br /&gt;
To discuss or ask questions about this article, select the ''discussion'' tab above.&amp;lt;/font&amp;gt;&amp;lt;/div&amp;gt;&lt;br /&gt;
&lt;br /&gt;
[[Category:Customizations]]&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=1039</id>
		<title>Help:Sandbox</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=1039"/>
				<updated>2008-01-27T15:32:18Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Feel free to try out the wiki syntax in this page.&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;!-- test your skills below this line --&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Here is the query you would use to retrieve all Service Desk contacts with the last name &amp;quot;Smith&amp;quot; :&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot; line&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=html4strict==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=javascript==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;javascript&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=php==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;php&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Top Ten Pages==&lt;br /&gt;
&amp;lt;TopTenPages&amp;gt;10&amp;lt;/TopTenPages&amp;gt;&lt;br /&gt;
[[Special:Popularpages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Newest Pages==&lt;br /&gt;
{{Special:NewestPages/-/10}}&lt;br /&gt;
[[Special:NewestPages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;!--c1--&amp;gt;&amp;lt;div class='codetop'&amp;gt;CODE&amp;lt;/div&amp;gt;&amp;lt;div class='codemain'&amp;gt;&amp;lt;!--ec1--&amp;gt;&amp;lt;br&amp;gt;SELECT *&amp;lt;br&amp;gt;FROM ca_contact&amp;lt;br&amp;gt;WHERE last_name = &amp;amp;#39;Smith&amp;amp;#39;&amp;lt;br&amp;gt;&amp;lt;!--c2--&amp;gt;&amp;lt;/div&amp;gt;&amp;lt;!--ec2--&amp;gt;&lt;br /&gt;
&lt;br /&gt;
 SELECT *&lt;br /&gt;
 FROM ca_contact&lt;br /&gt;
 WHERE last_name = 'Smith'&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=1037</id>
		<title>Help:Sandbox</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=1037"/>
				<updated>2008-01-27T15:30:14Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Feel free to try out the wiki syntax in this page.&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;!-- test your skills below this line --&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Here is the query you would use to retrieve all Service Desk contacts with the last name &amp;quot;Smith&amp;quot; :&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot; line&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=html4strict==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=javascript==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;javascript&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=php==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;php&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Top Ten Pages==&lt;br /&gt;
&amp;lt;TopTenPages&amp;gt;10&amp;lt;/TopTenPages&amp;gt;&lt;br /&gt;
[[Special:Popularpages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Newest Pages==&lt;br /&gt;
{{Special:NewestPages/-/10}}&lt;br /&gt;
[[Special:NewestPages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;!--c1--&amp;gt;&amp;lt;div class='codetop'&amp;gt;CODE&amp;lt;/div&amp;gt;&amp;lt;div class='codemain'&amp;gt;&amp;lt;!--ec1--&amp;gt;&amp;lt;br&amp;gt;SELECT *&amp;lt;br&amp;gt;FROM ca_contact&amp;lt;br&amp;gt;WHERE last_name = &amp;amp;#39;Smith&amp;amp;#39;&amp;lt;br&amp;gt;&amp;lt;!--c2--&amp;gt;&amp;lt;/div&amp;gt;&amp;lt;!--ec2--&amp;gt;&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Unable_to_View_pdf_Attachments&amp;diff=944</id>
		<title>Unable to View pdf Attachments</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Unable_to_View_pdf_Attachments&amp;diff=944"/>
				<updated>2008-01-26T03:30:29Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Category:Solutions]]&lt;br /&gt;
By default, while r11.x allows the uploading of pdf files as [[Attachment|Attachments]], it does not permit the viewing of them. To add this capability, follow these simple procedures:&lt;br /&gt;
&lt;br /&gt;
# Access '''[[web.xml]]''' located in [[NX_ROOT]]/bopcfg/www/CATALINA_BASE/webapps/CAisd/WEBINF&lt;br /&gt;
# The [[web.xml]] file contains pairings of param-name and param-value. Search for the param-name of '''save_as_dialog_ext'''.&lt;br /&gt;
# Add pdf to the end of the string in the param-value that follows.&lt;br /&gt;
&lt;br /&gt;
Example:&lt;br /&gt;
&amp;lt;source lang=xml&amp;gt;&lt;br /&gt;
&amp;lt;param-name&amp;gt;save_as_dialog_ext&amp;lt;/param-name&amp;gt;&lt;br /&gt;
&amp;lt;param-value&amp;gt;eml,doc,zip,gz,tar,xls,rtf,ppt,pps,msg,pdf&amp;lt;/param-value&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=922</id>
		<title>Help:Sandbox</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=922"/>
				<updated>2008-01-24T18:20:07Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Feel free to try out the wiki syntax in this page.&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;!-- test your skills below this line --&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Here is the query you would use to retrieve all Service Desk contacts with the last name &amp;quot;Smith&amp;quot; :&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot; line&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=html4strict==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=javascript==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;javascript&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=php==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;php&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Top Ten Pages==&lt;br /&gt;
&amp;lt;TopTenPages&amp;gt;10&amp;lt;/TopTenPages&amp;gt;&lt;br /&gt;
[[Special:Popularpages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Newest Pages==&lt;br /&gt;
{{Special:NewestPages/-/10}}&lt;br /&gt;
[[Special:NewestPages|more...]]&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=921</id>
		<title>Help:Sandbox</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=921"/>
				<updated>2008-01-24T18:17:14Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Feel free to try out the wiki syntax in this page.&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;!-- test your skills below this line --&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Here is the query you would use to retrieve all Service Desk contacts with the last name &amp;quot;Smith&amp;quot; :&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot; line&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=html4strict==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Source lang=javascript==&lt;br /&gt;
&amp;lt;source lang=&amp;quot;javascript&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Top Ten Pages==&lt;br /&gt;
&amp;lt;TopTenPages&amp;gt;10&amp;lt;/TopTenPages&amp;gt;&lt;br /&gt;
[[Special:Popularpages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Newest Pages==&lt;br /&gt;
{{Special:NewestPages/-/10}}&lt;br /&gt;
[[Special:NewestPages|more...]]&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=912</id>
		<title>Help:Sandbox</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=912"/>
				<updated>2008-01-24T17:54:36Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Feel free to try out the wiki syntax in this page.&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;!-- test your skills below this line --&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Here is the query you would use to retrieve all Service Desk contacts with the last name &amp;quot;Smith&amp;quot; :&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot; line&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;html4strict&amp;quot;&amp;gt;&lt;br /&gt;
&amp;lt;PDM_IF $args.id != 0&amp;gt;&lt;br /&gt;
ImgBtnCreate(&amp;quot;makechild&amp;quot;, &amp;quot;Create Child&amp;quot;, &amp;quot;create_new('cr',0,0,0,'PRESET=type:$args.type','INITFROM=make_child')&amp;quot;, true, 0,&amp;quot;Create a Child&amp;quot;);&lt;br /&gt;
&amp;lt;/PDM_IF&amp;gt;&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
==Top Ten Pages==&lt;br /&gt;
&amp;lt;TopTenPages&amp;gt;10&amp;lt;/TopTenPages&amp;gt;&lt;br /&gt;
[[Special:Popularpages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Newest Pages==&lt;br /&gt;
{{Special:NewestPages/-/10}}&lt;br /&gt;
[[Special:NewestPages|more...]]&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Yellow_Pages&amp;diff=893</id>
		<title>Yellow Pages</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Yellow_Pages&amp;diff=893"/>
				<updated>2008-01-24T06:10:24Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;{| cellspacing=&amp;quot;20px;&amp;quot; style=&amp;quot;width:100%;height:100%;background-color:#ffffbb;&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
| colspan=&amp;quot;3&amp;quot;  align=&amp;quot;center&amp;quot; | '''The SDU Yellow Pages are publicly available listings of companies and individuals&amp;lt;br&amp;gt;in the business of CA/Unicenter Service Desk.'''&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;''Click on a listings below to view contact information and service offerings.''&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&lt;br /&gt;
|-&lt;br /&gt;
| style=&amp;quot;vertical-align:top;width:33%&amp;quot; | '''CA Software Vendor'''&amp;lt;br&amp;gt;&lt;br /&gt;
----&lt;br /&gt;
&amp;amp;nbsp;&amp;amp;nbsp;&amp;amp;nbsp;[[Yellow_Pages:Example Company|Example Company]]&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
'''Complimentary Software'''&amp;lt;br&amp;gt;&lt;br /&gt;
----&lt;br /&gt;
[[Yellow_Pages:Hagrid Solutions Inc|Hagrid Solutions, Inc.]]&amp;amp;nbsp;[[Image:Flag australia.gif]]&amp;amp;nbsp;[[Image:Flag usa.gif]]&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
'''Education/Training'''&amp;lt;br&amp;gt;&lt;br /&gt;
----&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
| style=&amp;quot;vertical-align:top;width:33%&amp;quot; | '''ITIL Process Consulting'''&amp;lt;br&amp;gt;&lt;br /&gt;
----&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
'''Reporting'''&amp;lt;br&amp;gt;&lt;br /&gt;
----&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
'''Service Desk Consulting'''&amp;lt;br&amp;gt;&lt;br /&gt;
----&lt;br /&gt;
[[Yellow_Pages:Hagrid Solutions Inc|Hagrid Solutions, Inc.]]&amp;amp;nbsp;[[Image:Flag australia.gif]]&amp;amp;nbsp;[[Image:Flag usa.gif]]&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
| style=&amp;quot;vertical-align:top;width:33%&amp;quot; | '''Useful Software Tools'''&amp;lt;br&amp;gt;&lt;br /&gt;
----&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
'''Workflow Development'''&amp;lt;br&amp;gt;&lt;br /&gt;
----&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;br&amp;gt;&lt;br /&gt;
|-&lt;br /&gt;
| colspan=&amp;quot;3&amp;quot;  align=&amp;quot;center&amp;quot; | Interested in advertising on the SDU Yellow Pages?  [[Advertise#Yellow Pages|Click here]] for details.&lt;br /&gt;
|-&lt;br /&gt;
|}&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=891</id>
		<title>Help:Sandbox</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=891"/>
				<updated>2008-01-24T05:49:02Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Feel free to try out the wiki syntax in this page.&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;!-- test your skills below this line --&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Here is the query you would use to retrieve all Service Desk contacts with the last name &amp;quot;Smith&amp;quot; :&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot; line&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Top Ten Pages==&lt;br /&gt;
&amp;lt;TopTenPages&amp;gt;10&amp;lt;/TopTenPages&amp;gt;&lt;br /&gt;
[[Special:Popularpages|more...]]&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Newest Pages==&lt;br /&gt;
{{Special:NewestPages/-/10}}&lt;br /&gt;
[[Special:NewestPages|more...]]&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=890</id>
		<title>Help:Sandbox</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=890"/>
				<updated>2008-01-24T05:44:06Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Feel free to try out the wiki syntax in this page.&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;!-- test your skills below this line --&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Here is the query you would use to retrieve all Service Desk contacts with the last name &amp;quot;Smith&amp;quot; :&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot; line&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==Top Ten Pages==&lt;br /&gt;
&amp;lt;TopTenPages&amp;gt;10&amp;lt;/TopTenPages&amp;gt;&lt;br /&gt;
[[Special:Popularpages|more...]]&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=889</id>
		<title>Help:Sandbox</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Help:Sandbox&amp;diff=889"/>
				<updated>2008-01-24T05:07:39Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Feel free to try out the wiki syntax in this page.&amp;lt;br&amp;gt;&lt;br /&gt;
&amp;lt;!-- test your skills below this line --&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Here is the query you would use to retrieve all Service Desk contacts with the last name &amp;quot;Smith&amp;quot; :&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot;&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;source lang=&amp;quot;sql&amp;quot; line&amp;gt;&lt;br /&gt;
SELECT *&lt;br /&gt;
FROM ca_contact&lt;br /&gt;
WHERE last_name = 'Smith'&lt;br /&gt;
&amp;lt;/source&amp;gt;&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=MediaWiki:Sidebar&amp;diff=554</id>
		<title>MediaWiki:Sidebar</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=MediaWiki:Sidebar&amp;diff=554"/>
				<updated>2008-01-16T16:21:24Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;* navigation&lt;br /&gt;
** Home|Home&lt;br /&gt;
** http://www.servicedeskusers.com/forum/index.php?act=idx|Forum&lt;br /&gt;
** Category:Service Desk|Service Desk Wiki&lt;br /&gt;
** http://www.servicedeskusers.com/forum/index.php?act=calendar|Calendar&lt;br /&gt;
** http://www.servicedeskusers.com/forum/index.php?act=Members|Members&lt;br /&gt;
** http://www.servicedeskusers.com/forum/index.php?act=UserCP&amp;amp;amp;CODE=00|Control Panel&lt;br /&gt;
** Yellow Pages|Yellow Pages&lt;br /&gt;
** Advertise|Advertise on SDU&lt;br /&gt;
* wiki&lt;br /&gt;
** recentchanges-url|recentchanges&lt;br /&gt;
** randompage-url|randompage&lt;br /&gt;
* help&lt;br /&gt;
** http://www.servicedeskusers.com/forum/index.php?act=Help|Forum help&lt;br /&gt;
** helppage|Wiki help&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=MediaWiki:Sidebar&amp;diff=532</id>
		<title>MediaWiki:Sidebar</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=MediaWiki:Sidebar&amp;diff=532"/>
				<updated>2008-01-16T07:10:10Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;* navigation&lt;br /&gt;
** Home|Home&lt;br /&gt;
** http://www.servicedeskusers.com/forum|Forum&lt;br /&gt;
** Category:Service Desk|Service Desk Wiki&lt;br /&gt;
** http://www.servicedeskusers.com/forum/index.php?act=calendar|Calendar&lt;br /&gt;
** http://www.servicedeskusers.com/forum/index.php?act=Members|Members&lt;br /&gt;
** Yellow_Pages:Contents|Yellow Pages&lt;br /&gt;
** Advertise|Advertise on SDU&lt;br /&gt;
* wiki&lt;br /&gt;
** recentchanges-url|recentchanges&lt;br /&gt;
** randompage-url|randompage&lt;br /&gt;
* help&lt;br /&gt;
** http://www.servicedeskusers.com/forum/index.php?act=Help|Forum help&lt;br /&gt;
** helppage|Wiki help&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=MediaWiki:Sidebar&amp;diff=529</id>
		<title>MediaWiki:Sidebar</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=MediaWiki:Sidebar&amp;diff=529"/>
				<updated>2008-01-16T04:47:03Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;* navigation&lt;br /&gt;
** Home|Home&lt;br /&gt;
** http://www.servicedeskusers.com/forum|Forum&lt;br /&gt;
** http://www.servicedeskusers.com/forum/index.php?act=calendar|Calendar&lt;br /&gt;
** http://www.servicedeskusers.com/forum/index.php?act=Members|Members&lt;br /&gt;
** Yellow_Pages|Yellow Pages&lt;br /&gt;
** sitesupport-url|sitesupport&lt;br /&gt;
* wiki&lt;br /&gt;
** recentchanges-url|recentchanges&lt;br /&gt;
** randompage-url|randompage&lt;br /&gt;
** helppage|help&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=SDU:Site_support&amp;diff=528</id>
		<title>SDU:Site support</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=SDU:Site_support&amp;diff=528"/>
				<updated>2008-01-16T04:42:32Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Please contact [mailto:admins@servicedeskusers.com the admins] for questions regarding this site.&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=SDU:Site_support&amp;diff=527</id>
		<title>SDU:Site support</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=SDU:Site_support&amp;diff=527"/>
				<updated>2008-01-16T04:41:41Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Please contact [[mailto:admins@servicedeskusers.com the admins]] for questions regarding this site.&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=SDU:Site_support&amp;diff=526</id>
		<title>SDU:Site support</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=SDU:Site_support&amp;diff=526"/>
				<updated>2008-01-16T04:41:17Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Please contact [[mailto:admins@servicedeskusers.com|the admins]] for questions regarding this site.&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=SDU:Site_support&amp;diff=525</id>
		<title>SDU:Site support</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=SDU:Site_support&amp;diff=525"/>
				<updated>2008-01-16T04:40:28Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Contact [[mailto:admins@servicedeskusers.com]] for questions regarding this site.&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=SDU:Site_support&amp;diff=524</id>
		<title>SDU:Site support</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=SDU:Site_support&amp;diff=524"/>
				<updated>2008-01-16T04:35:45Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Contact admins@servicedeskusers.com for questions regarding this site.&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=MediaWiki:Sidebar&amp;diff=523</id>
		<title>MediaWiki:Sidebar</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=MediaWiki:Sidebar&amp;diff=523"/>
				<updated>2008-01-16T04:32:17Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;* navigation&lt;br /&gt;
** Home|Home&lt;br /&gt;
** http://www.servicedeskusers.com/forum|Forum&lt;br /&gt;
** http://www.servicedeskusers.com/forum/index.php?act=calendar|Calendar&lt;br /&gt;
** http://www.servicedeskusers.com/forum/index.php?act=Members|Members&lt;br /&gt;
** Yellow_Pages|Yellow Pages&lt;br /&gt;
** sitesupport-url|sitesupport&lt;br /&gt;
* wiki functions&lt;br /&gt;
** recentchanges-url|recentchanges&lt;br /&gt;
** randompage-url|randompage&lt;br /&gt;
** helppage|help&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Yellow_Pages&amp;diff=521</id>
		<title>Yellow Pages</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Yellow_Pages&amp;diff=521"/>
				<updated>2008-01-16T03:44:46Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: New page: OakTree Solutions&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Yellow_Pages/OakTree Solutions|OakTree Solutions]]&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=MediaWiki:Mainpage&amp;diff=24</id>
		<title>MediaWiki:Mainpage</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=MediaWiki:Mainpage&amp;diff=24"/>
				<updated>2008-01-11T16:10:17Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Home&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=MediaWiki:Mainpage&amp;diff=5</id>
		<title>MediaWiki:Mainpage</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=MediaWiki:Mainpage&amp;diff=5"/>
				<updated>2008-01-09T17:56:53Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Welcome To SDUwiki&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=MediaWiki:Mainpage&amp;diff=2</id>
		<title>MediaWiki:Mainpage</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=MediaWiki:Mainpage&amp;diff=2"/>
				<updated>2008-01-09T05:07:57Z</updated>
		
		<summary type="html">&lt;p&gt;Admin: New page: Welcome_To_SDUwiki&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;Welcome_To_SDUwiki&lt;/div&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	</feed>