You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
var rdr = new Select().From()
.Where("orderitem_sessionid")
.Like("qA9tRFlFeNyu6TK71EY8a5fpVmfFK6ZQMUAyzzylIRBLyRnDL1")
.And("orderitem_productid")
.In(product.All().Where(x => x.product_Category == category));
[/code]
creates this miss-fired SQL
SELECT ID, orderitem_orderid, orderitem_productid, orderitem_qty, orderitem_total, orderitem_sessionid, orderitem_internal, orderitem_measurement FROM orderitems\r\n\r\n WHERE orderitem_sessionid LIKE @0 AND orderitem_productid IN (@1in1,@1in2,@1in3,@1In4,@1in5,@1In6,@1In7,@1In8,@1in9,@1In10,@1In11,@1In12,@1In13,@1In14,@1In15,@1In16,@1In17,@1In18,@1In19,@1in20)
this code:
[code]
var rdr = new Select().From()
.Where("orderitem_sessionid")
.Like("qA9tRFlFeNyu6TK71EY8a5fpVmfFK6ZQMUAyzzylIRBLyRnDL1")
.And("orderitem_productid")
.In(product.All().Where(x => x.product_Category == category));
[/code]
creates this miss-fired SQL
SELECT
ID
,orderitem_orderid
,orderitem_productid
,orderitem_qty
,orderitem_total
,orderitem_sessionid
,orderitem_internal
,orderitem_measurement
FROM orderitems\r\n\r\n WHEREorderitem_sessionid
LIKE @0 ANDorderitem_productid
IN (@1in1,@1in2,@1in3,@1In4,@1in5,@1In6,@1In7,@1In8,@1in9,@1In10,@1In11,@1In12,@1In13,@1In14,@1In15,@1In16,@1In17,@1In18,@1In19,@1in20)notice the @0
this is also same for IsEqualTo, i have tried a smaller string of just five letters and still no joy subsonic allways outputs a zero
The text was updated successfully, but these errors were encountered: