Which version of CCM?<br><br>Personally, I think modifying SQL directly is a BAD idea unless you really know what you are doing...<br><br><br>J<br><br><div class="gmail_quote">On Mon, Apr 27, 2009 at 9:15 AM, Mike Lydick <span dir="ltr"><<a href="mailto:mike.lydick@gmail.com">mike.lydick@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Telco provider has given us a new DID range that is 2 digits off from the current range. What it the best way to move the relative fields to this new range via sql. The brute force way would be to export update and bat in, but I am thinking SQL might be a better fit.<br>
<br><br>Fields that need updating are<br><br>---LINE---<br>Directory Number:<br>Line Text Label<br>ASCII Line Text Label<br>External Number Mask<br><br>---End User---<br>User ID<br>Telephone Number<br><br><br clear="all">
Best Regards,<br><font color="#888888"><br>Mike Lydick<br><br>
</font><br>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br>