Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saidev
Posting Yak Master
101 Posts |
 Posted - 2006-02-14 : 18:39:26
|
| Hi guys,is there anything wrong with this query..? i am passing "accountid" as parameter. it worksfine in the query analyzer when i assign a value.. but it is not working in the application.any thing wrong with this query..? Thanks,sql = "SELECT tblAccountExec.fkOfficeLocation, tblOfficeLocation.fkLSSArea FROM tblAccountExec INNER JOIN tblOfficeLocation ON tblAccountExec.fkOfficeLocation = tblOfficeLocation.pkid WHERE tblAccountExec.pkid = " & accountid |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-14 : 18:44:47
|
| what is the data type of accountid ? Integer or varchar ?----------------------------------'KH'everything that has a beginning has an end |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-02-14 : 20:23:36
|
| When it works in QA but not from the app, the thing to do is capture the sql being submitted to the server using Sql Profiler. The problem usually becomes obvious once you see the sql code. The other thing to do is pay attention to the exception that is being raised by your app. If it's from sql it should tell you what the problem is.Be One with the OptimizerTG |
|
|
|
|
|
|
Sql Query Help