<html><body><div style="font-family: times new roman, new york, times, serif; font-size: 12pt; color: #000000"><div>Dear friends,</div><div><br></div><div>I have to select entries from table which has a phone nomber in to or from column in a table.</div><div><br></div><div>Say a dialog tables and phone number is 1000.</div><div>So i need to fetch all queries where to_uri or from_uri is like 1000.</div><div>I have checked the code, but i didnt find any way to do this OR behaviour.</div><div>Like in following simple example</div><div><br></div><div><p>db_keys[0] = &str_expires_col;<br> db_ops[0] = OP_LT;<br> db_vals[0].type = DB1_INT;<br> db_vals[0].nul = 0;<br> db_vals[0].val.int_val = (int)time(NULL);</p><p>result_cols[user_col= n_result_cols++] = &str_username_col;<br> result_cols[domain_col=n_result_cols++] = &str_domain_col;<br> result_cols[etag_col=n_result_cols++] = &str_etag_col;<br> result_cols[event_col=n_result_cols++] = &str_event_col;</p><p><br></p><p>This can be used where expires coloumn is less then current unix time. But say i want to change the query like expire value is less then xxxxxx but greater then yyyyy Then how can i do that?</p><p>Should i need to use another db_key with OP_GT value?</p><p>What is Operation info we should use for LIKE. I mean i need to select value which is sip:1000@xx.xx.xx.xx via searching for 1000.</p><p><br></p><p>I Hope i had explain the question well. Please let me know in case any confusion in question.</p></div><div><br></div><div><span name="x"></span><div><b><span><br>--<br>Regards,<br><div><br></div>Hemanshu Patel<br><span color="#3366ff" style="color: #3366ff;" data-mce-style="color: #3366ff;">----------------------------------------------------------------------<br></span></span></b><div><div><span style="color: rgb(0, 128, 0); "><strong>P</strong>Help the environment – please don't print this email unless you really need to!</span></div></div></div><span name="x"></span></div><div><br></div></div></body></html>