Re: [firebird-support] Problem in executing query using 'IN' statement.

Fri, 16 Sep 2016 08:11:09 -0700 

 

    On Friday, September 16, 2016 4:35 PM, "'Joje' [email protected] 
[firebird-support]" <[email protected]> wrote:
 
     AND Tb3.NAME _IDS IN  (CAST(Tb2.NAME_ID AS VARCHAR(250))) /*Here Tb3.NAME 
_IDS is varchar & Tb2.NAME _IDS is int so casted into varchar. This line gives 
wrong output */
AND POSITION(Tb2.name_id||',',Tb3.NAME_IDS||','
   <!--#yiv0832104781 #yiv0832104781 
.yiv0832104781ygrp-photo-title{clear:both;font-size:smaller;min-height:15px;overflow:hidden;text-align:center;width:75px;}#yiv0832104781
 
div.yiv0832104781ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px
 solid black;min-height:62px;width:62px;}#yiv0832104781 
div.yiv0832104781photo-title a, #yiv0832104781 div.yiv0832104781photo-title 
a:active, #yiv0832104781 div.yiv0832104781photo-title a:hover, #yiv0832104781 
div.yiv0832104781photo-title a:visited {text-decoration:none;}#yiv0832104781 
div.yiv0832104781attach-table div.yiv0832104781attach-row 
{clear:both;}#yiv0832104781 div.yiv0832104781attach-table 
div.yiv0832104781attach-row div {float:left;}#yiv0832104781 p 
{clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv0832104781 
div.yiv0832104781ygrp-file {width:30px;}#yiv0832104781 
div.yiv0832104781attach-table div.yiv0832104781attach-row div div a 
{text-decoration:none;}#yiv0832104781 div.yiv0832104781attach-table 
div.yiv0832104781attach-row div div span {font-weight:normal;}#yiv0832104781 
div.yiv0832104781ygrp-file-title {font-weight:bold;}#yiv0832104781 
--><!--#yiv0832104781 _filtered #yiv0832104781 {font-family:"Cambria 
Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv0832104781 
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv0832104781 
{font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}#yiv0832104781 
#yiv0832104781 p.yiv0832104781MsoNormal, #yiv0832104781 
li.yiv0832104781MsoNormal, #yiv0832104781 div.yiv0832104781MsoNormal 
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", 
sans-serif;}#yiv0832104781 a:link, #yiv0832104781 
span.yiv0832104781MsoHyperlink 
{color:#0563C1;text-decoration:underline;}#yiv0832104781 a:visited, 
#yiv0832104781 span.yiv0832104781MsoHyperlinkFollowed 
{color:#954F72;text-decoration:underline;}#yiv0832104781 
span.yiv0832104781EmailStyle17 {font-family:"Calibri", 
sans-serif;color:windowtext;}#yiv0832104781 .yiv0832104781MsoChpDefault 
{font-family:"Calibri", sans-serif;} _filtered #yiv0832104781 {margin:72.0pt 
72.0pt 72.0pt 72.0pt;}#yiv0832104781 div.yiv0832104781WordSection1 {}-->

Reply via email to