On 2010.04.29 5:06 PM, André Knappstein, Controlling wrote:
k select userinfo0_.id as x0_0_
k from user_infos userinfo0_
k where (@p0 in(select views1_.View_Id from User_Views_Map views1_
k where userinfo0_.id=views1_.User_Id))
try this
select userinfo0_.id as x0_0_
from user_infos
hi all, i'm using the client 2.5.2.0 from a net 2.0 project with a window fb
server
i have ths tables:
table:user_infos
column: ID integer
table view_infos
column:ID integer
table:User_Views_Map
column: view_id integer //FK to view_infos.ID
column: User_Id integer //FK to user_infos.ID
k select userinfo0_.id as x0_0_
k from user_infos userinfo0_
k where (@p0 in(select views1_.View_Id from User_Views_Map views1_
k where userinfo0_.id=views1_.User_Id))
I have such an idea, that you cannot use a dynamic parameter at this
place. But I can be wrong.
k note 2: if i do the query
How do you do the query directly to firebird ?
i did the query
using directly the parameter value (as integer and string) :)
it's this query cannot by done with the parameter in this place can samebody
help me to rebuilt it?
On Thu, Apr 29, 2010 at 15:30, korkless korkl...@yahoo.it wrote:
it's a bug or i'm doing samething wrong?
You can't use a parameter there, as server isn't able to infer the
type. Easiest way is to do there a cast.
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ |
Any reason why you are not doing it simpler like this:
to get list of user id's for specific view
SELECT
USER_VIEWS_MAP.USER_ID
FROM
USER_VIEWS_MAP
WHERE
USER_VIEWS_MAP.VIEW_ID = @viewid
and something like this get the user table:
SELECT
USER_INFOS.*
FROM
USER_INFOS
INNER JOIN
thanks all, i resolved reweiting the query in another way,
i was using this query becouse it's autogenerate with nhibernate
--
___
Firebird-net-provider mailing list
