hi,

i just use this query in the sqldatasource:

SELECT TICKETS.REGION, TICKETS.AREA, REGIONS.X, REGIONS.Y FROM TICKETS INNER JOIN REGIONS ON TICKETS.REGION = REGIONS.REGION AND TICKETS.AREA = REGIONS.AREA

but when i Test Query it doesn't work???

there is no syntax error in it


Please help.

hi there...

if there is no syntax error.. what problem do you have?? blank result, then you have problems with the join...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

I am sure that there is no Syntax error
because when i try it on SQlplus it works and
when i try it at the query builder it works

but in the next step "Test Query" it doesn't work


Thanks

if you have no syntax error (again) where is your problem??? can you define why it's doesn't work?? what do you expect, what do you want to receive, what do you effectively receive????

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

hi

More details,

I use SQLdataSource,
when I build my query using Query builder
& try it using 'Execute Query' button
it works and i got the correct result.

BUT at the next step I try the 'Test Query' button
it doesn't work and give a pop up error window that there is expression error
and give me no data.

thanks