Re: Data Connection Query

Agni Jonnalagadda — Thu, 23 Feb 2006 15:13:46 GMT

Hi,
You are using single quote in the query string, database thinks single quote as a starting of the string.
You need to escape single quote with one extra single quote then it should work.

So your query should be
SELECT distinct FullName
FROM bi_employee
AS FullName
WHERE LogonName=N''blah''
ORDER BY "FullName"

Agni
INFOPATHdev India

Data Connection Query

delu — Thu, 23 Feb 2006 07:33:27 GMT

I'm confused: I have a data connection:


select distinct "FullName" from "employee" as "FullName" order by "FullName"

When I run this data connection from managed code, everything works fine. But when I put a 'where' statement in it, the result will always be "".


SELECT distinct FullName
FROM bi_employee
AS FullName
WHERE LogonName=N'blah'
ORDER BY "FullName"

When I exclude the "where" statement, everything works fine. the management studio performs the query without an error on manual try.

I assumed the XPath of the result set changed, but I just can't figure out to what. I tried everything I could imagine.

Can anybody help me?

Thanks a lot!!

Code

Re: Data Connection Query

Data Connection Query