| :: Bug Report :: (3) | Post a New Message | Post a Reply |
 Bug Report | Post a Reply |
since: Dec 27, 2006
from: france
i m using your report tool and it seems to work very fine with Tables but not with predefined queries...
I mean that when i point on the table i want to use through your reporting tool; it s calling this line :
<a href="default_report.asp?t=Users"> Users</a>
now if users is a table then it works, but if users is a predefinite query in the database then i get an error like : could'nt find table or query source 'Users' make sure it s spelled correctly...
now i ve looked at your code that is concerned and this is this one :
Set objRS = objConn.Execute("SELECT * FROM [" & strTable & "]")
now strTable can be whether a table whether a Query.... now i don t understand why it happens....
Now there are some queries that work though with your report tool and those queries are not complex..but it seems that if you make queries a little bit more complex (but that can run under access) containing such things :
SELECT D.project, A.l_name AS UserName, B.l_name AS AdName, C.adresse_b, FROM STATE AS C, USERS AS A, USERS AS B, PROJECTs AS D then it won t work... :-(
thanks for your help....
 Re: Bug Report | Post a Reply |
from: Washington, DC
-------------------------
Ghost
| Re: Bug Report | Post a Reply |
since: Dec 27, 2006
from: france
it seems that i used so many connexion.asp file with so many different db, that i ve connected the wonrg DB... it is as simple as that...
thanks for answering anyway...
Everything work perfect.