Temat umarl, czy moze uda sie dodac ten ficzer do lms-a? ;-)<br><br><div class="gmail_quote">W dniu 4 kwietnia 2012 14:39 użytkownik Krzysztof Kulesza <span dir="ltr">&lt;<a href="mailto:krzysztof@kulesza.eu">krzysztof@kulesza.eu</a>&gt;</span> napisał:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  

    
  
  <div bgcolor="#FFFFFF" text="#000000">
    a moze pobrac to w taki sposob z bazy<br>
    
    
    <pre><code><span>SELECT</span><span> </span><span>CONCAT</span><span>(</span><span>SUBSTRING</span><span>(</span><span>REPLACE</span><span>(</span><span>mac</span><span>,</span><span> </span><span>&#39;:&#39;</span><span>,</span><span> </span><span>&#39;&#39;</span><span>),</span><span>1</span><span>,</span><span>4</span><span>),</span><span>&#39;.&#39;</span><span>,</span><span>SUBSTRING</span><span>(</span><span>REPLACE</span><span>(</span><span>mac</span><span>,</span><span> </span><span>&#39;:&#39;</span><span>,</span><span> </span><span>&#39;&#39;</span><span>),</span><span>5</span><span>,</span><span>8</span><span>),</span><span>&#39;.&#39;</span><span>,</span><span>SUBSTRING</span><span>(</span><span>REPLACE</span><span>(</span><span>mac</span><span>,</span><span> </span><span>&#39;:&#39;</span><span>,</span><span> </span><span>&#39;&#39;</span><span>),</span><span>9</span><span>,</span><span>12<span>))</span><span> </span><span>AS</span><span> </span><span>ciscomac</span><span> </span><span>FROM</span><span> </span><span>vmacs
</span></span></code></pre>
    
    
    pewnie sie to da zrobic ladniej ale to tak na szybko<span class="HOEnZb"><font color="#888888"><br>
    <pre cols="72">-- 
Krzysztof Kulesza</pre>
  </font></span></div>

<br>_______________________________________________<br>
lms mailing list<br>
<a href="mailto:lms@lists.lms.org.pl">lms@lists.lms.org.pl</a><br>
<a href="http://lists.lms.org.pl/mailman/listinfo/lms" target="_blank">http://lists.lms.org.pl/mailman/listinfo/lms</a><br>
<br></blockquote></div><br>