<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"><base href="x-msg://750/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">thanks<div>Points I had not considered </div><div><br></div><div>Andrew (from where it is now 4 degrees outside)</div><div><br><div apple-content-edited="true">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Andrew Shortell</div><div>Educator</div><div>CRC Melton</div><div><br></div><div><br></div><div><a href="mailto:shortell@get2me.net">shortell@get2me.net</a> (This List)</div><div>@acsbear8 (twitter)</div></div></span><a href="http://www.vitta.org.au/">VITTA</a> CoM Member</div></span><br class="Apple-interchange-newline"></div><br class="Apple-interchange-newline"></div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<br><div><div>On 29/05/2013, at 9:15 PM, Wayne Eglinton <<a href="mailto:wayne.eglinton@ntschools.net">wayne.eglinton@ntschools.net</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div lang="EN-AU" vlink="purple" link="blue" ocsi="x" style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="font-family: Tahoma; direction: ltr; font-size: x-small; "><div>FYI</div><div> </div><div>living in the NT ... I'm fully aware of the 0 lead character in postcodes. Too bad web-developers don't consider using text for post/zipcodes fields ... often we can't subscribe etc... It can seriously be a pain - and we just go to another website... bad for their business!!!</div><div><div class="BodyFragment"><font size="2"><div class="PlainText"> </div><div class="PlainText"><font face="tahoma">Food for thought for you & your students.</font></div><div class="PlainText"><font face="tahoma"></font> </div><div class="PlainText">Regards,<br><br>Wayne Eglinton<br><br>OLSH College<br>P.O. Box 2508</div><div class="PlainText">Traeger Ave.<br>Alice Springs NT 0871<br><br>P 08 8950 8555</div><div class="PlainText">M 0406 357 972</div></font></div></div><div dir="ltr"><font size="2" face="Tahoma"></font> </div><div id="divRpF349079" style="direction: ltr; "><hr tabindex="-1"><font size="2" face="Tahoma"><b>From:</b><span class="Apple-converted-space"> </span><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>] On Behalf Of Stuart Walkerden (STUW) [<a href="mailto:stuw@huntingtower.vic.edu.au">stuw@huntingtower.vic.edu.au</a>]<br><b>Sent:</b><span class="Apple-converted-space"> </span>28 May 2013 13:20<br><b>To:</b><span class="Apple-converted-space"> </span>Year 12 IT Applications Teachers' Mailing List<br><b>Subject:</b><span class="Apple-converted-space"> </span>Re: [Year 12 IT Apps] Data type for postcode<br></font><br></div><div></div><div><div class="WordSection1"><div style="margin: 0cm 0cm 0pt; font-family: 'Times New Roman', serif; font-size: 12pt; "><span style="font-family: Calibri, sans-serif; color: rgb(31, 73, 125); font-size: 11pt; ">I reckon if it looks like a number, treat it as a number and use a number field type. Whether you perform calculations on it or not is irrelevant. I have always told my students to use postcode as a number and phone as text to allow for leading 0. I wasn’t aware of NT postcodes. I may have to change my line.</span></div><p class="MsoNormal" style="margin: 0cm 0cm 0pt; font-family: 'Times New Roman', serif; font-size: 12pt; "><span style="font-family: Calibri, sans-serif; color: rgb(31, 73, 125); font-size: 11pt; "></span> </p><div style="margin: 0cm 0cm 0pt; font-family: 'Times New Roman', serif; font-size: 12pt; "><span style="font-family: Calibri, sans-serif; color: rgb(31, 73, 125); font-size: 11pt; ">Stuart Walkerden</span></div><div style="margin: 0cm 0cm 0pt; font-family: 'Times New Roman', serif; font-size: 12pt; "><span style="font-family: Calibri, sans-serif; color: rgb(31, 73, 125); font-size: 11pt; ">Huntingtower</span></div><p class="MsoNormal" style="margin: 0cm 0cm 0pt; font-family: 'Times New Roman', serif; font-size: 12pt; "><span style="font-family: Calibri, sans-serif; color: rgb(31, 73, 125); font-size: 11pt; "></span> </p><div><div style="border-width: 1pt medium medium; border-style: solid none none; padding: 3pt 0cm 0cm; border-top-color: rgb(181, 196, 223); "><div style="margin: 0cm 0cm 0pt; font-family: 'Times New Roman', serif; font-size: 12pt; "><b><span lang="EN-US" style="font-family: Tahoma, sans-serif; font-size: 10pt; ">From:</span></b><span lang="EN-US" style="font-family: Tahoma, sans-serif; font-size: 10pt; "><span class="Apple-converted-space"> </span><a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [mailto:itapps-<a href="mailto:bounces@edulists.com.au">bounces@edulists.com.au</a>]<span class="Apple-converted-space"> </span><b>On Behalf Of<span class="Apple-converted-space"> </span></b>Athena Spyratos<br><b>Sent:</b><span class="Apple-converted-space"> </span>Tuesday, 28 May 2013 7:47 AM<br><b>To:</b><span class="Apple-converted-space"> </span>Year 12 IT Applications Teachers' Mailing List<br><b>Subject:</b><span class="Apple-converted-space"> </span>[Year 12 IT Apps] Data type for postcode</span></div></div></div><p class="MsoNormal" style="margin: 0cm 0cm 0pt; font-family: 'Times New Roman', serif; font-size: 12pt; "> </p><div><div><div style="margin: 0cm 0cm 0pt; font-family: 'Times New Roman', serif; font-size: 12pt; "><span style="font-family: Tahoma, sans-serif; font-size: 10pt; ">Fellow IT teachers.</span></div></div><div><div style="margin: 0cm 0cm 0pt; font-family: 'Times New Roman', serif; font-size: 12pt; "><span style="font-family: Tahoma, sans-serif; font-size: 10pt; ">Do we declare the data type for Postcode as number or text? In database, if we apply a validation rule for a Victorian postcode as being between 3000 and 3999, then we declare it as a number. However going over one of the past exam multiple choice questions, the answer they wanted for the data type for Postcode was text. Which answer are the examiners looking for?</span></div></div><div><div style="margin: 0cm 0cm 0pt; font-family: 'Times New Roman', serif; font-size: 12pt; "><span style="font-family: Tahoma, sans-serif; font-size: 10pt; ">Athena</span></div></div></div></div></div></div>_______________________________________________<br><a href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<br>IT Applications Mailing List kindly supported by<br><a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority <br><br><a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br><br><a href="http://www.swinburne.edu.au/ict/schools">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University</div></blockquote></div><br></div></body></html>