Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
All-Star
32835 Points
5563 Posts
MVP
Nov 27, 2008 04:59 AM|LINK
Hi,goodbrat
Ur r querying A query against the database
Now In u r query that u r requesting contains [column name]
suppose ur query is
Select [TestCol1],[TestCol2],[column name] ........................................
Now Debug that Query by putting breakpoint on the line which is causing the error .
Copy that Query
And run in sql server management studio Query anlyzer
did it run succesfully on that?
I am sure ,not it will give same error on message pane window.
That means there is no column name [column name] in that table from which u want to use that column.
So Please Check That.
PLZ MARK AS ANSWER IF IT HELP U. THANKS.
raghav_khung...
All-Star
32835 Points
5563 Posts
MVP
Re: 'Cannot find column' errors
Nov 27, 2008 04:59 AM|LINK
Hi,goodbrat
Ur r querying A query against the database
Now In u r query that u r requesting contains [column name]
suppose ur query is
Select [TestCol1],[TestCol2],[column name] ........................................
Now Debug that Query by putting breakpoint on the line which is causing the error .
Copy that Query
And run in sql server management studio Query anlyzer
did it run succesfully on that?
I am sure ,not it will give same error on message pane window.
That means there is no column name [column name] in that table from which u want to use that column.
So Please Check That.
PLZ MARK AS ANSWER IF IT HELP U.
THANKS.