<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>dirty mnesia function</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Hi,</FONT>
</P>
<P><FONT SIZE=2>We are trying to get all records from a mnesia's table. </FONT>
<BR><FONT SIZE=2>"dirty_match_object" function is used to this purpose:</FONT>
</P>
<P><FONT SIZE=2> mnesia:dirty_match_object(piuTable, {piuTable,'_','_','_','_','_','_','_','_','_','_','_','_','_'}).</FONT>
</P>
<P><FONT SIZE=2>However some records are not valid when content is returned.</FONT>
<BR><FONT SIZE=2>The following is a valid record returned:</FONT>
</P>
<P> <FONT SIZE=2>{piuTable,{1,2,2,1},</FONT>
<BR><FONT SIZE=2> 2,</FONT>
<BR><FONT SIZE=2> "SC",</FONT>
<BR><FONT SIZE=2> 1,</FONT>
<BR><FONT SIZE=2> 5,</FONT>
<BR><FONT SIZE=2> 2,</FONT>
<BR><FONT SIZE=2> "ROJ_238_007/1",</FONT>
<BR><FONT SIZE=2> "R7A/B",</FONT>
<BR><FONT SIZE=2> "T220089350",</FONT>
<BR><FONT SIZE=2> "SCB_20G",</FONT>
<BR><FONT SIZE=2> 2,</FONT>
<BR><FONT SIZE=2> 2,</FONT>
<BR><FONT SIZE=2> [1]}.</FONT>
<BR>
<BR><FONT SIZE=2>But in the next case, record information is not valid:</FONT>
</P>
<P> <FONT SIZE=2>{piuTable,{1,19,19,2},</FONT>
<BR><FONT SIZE=2> 5,</FONT>
<BR><FONT SIZE=2> "CP-IO",</FONT>
<BR><FONT SIZE=2> 1,</FONT>
<BR><FONT SIZE=2> 5,</FONT>
<BR><FONT SIZE=2> 2,</FONT>
<BR><FONT SIZE=2> "ROJ_237_051/1",</FONT>
<BR><FONT SIZE=2> "R9A",</FONT>
<BR><FONT SIZE=2> "T220110020"|...}.</FONT>
</P>
<P><FONT SIZE=2>some fields are replaced with "|...".</FONT>
</P>
<P><FONT SIZE=2>How we can to get all records in a rigth form througth this function?</FONT>
</P>
<P><FONT SIZE=2>Thanks in advanced.</FONT>
</P>
<P><FONT SIZE=2>Roberto</FONT>
</P>
<BR>
<P><FONT SIZE=2>Roberto Portugal</FONT>
<BR><FONT SIZE=2>System Integrator</FONT>
</P>
<P><FONT SIZE=2>Regional Competence Center</FONT>
<BR><FONT SIZE=2>Ericsson Chile, S.A.</FONT>
<BR><FONT SIZE=2>Av. Vitacura 2808, Las Condes, Santiago, Chile </FONT>
<BR><FONT SIZE=2>Telf.: +56 2 372 53 95</FONT>
<BR><FONT SIZE=2>Fax: +56 2 372 50 57 </FONT>
<BR><FONT SIZE=2>E-mail: roberto.portugal@cec.ericsson.se</FONT>
<BR><FONT SIZE=2><A HREF="http://www.ericsson.com" TARGET="_blank">http://www.ericsson.com</A></FONT>
</P>
</BODY>
</HTML>