SQL view error "more column names specified than columns defined"

Posted on : June 20, 2006 3:29 PM | Posted by : Troy
Related Categories: SQL,ColdFusion

If you ever get a ColdFusion error message such as the following:

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]View or function 'dbo.myviewname' has more column names specified than columns defined.

You/somebody probably just added or deleted a column from the view definition. Then, if you have a cfquery that does a "select *" against the view, that error will result.

The fix is to run the following system stored procedure in SQL Query Analyzer, to refresh the view: sp_refreshview 'myviewname'

Comments (0) | Send | del.icio.us | Digg It! | Linking Blogs | 374 Views

Doing a Subquery in SQL

Posted on : June 23, 2005 10:00 AM | Posted by : Troy
Related Categories: SQL

For my own future reference... This will lookup a value (emailaddress) from table2, to use in where clause in table1.

select *
from table1
where EmailAddress = (select EmailAddress from table2 where UserID = '#URL.UID#')

Comments (0) | Send | del.icio.us | Digg It! | Linking Blogs | 132 Views
BlogCFC was created by Raymond Camden. This blog is running version 5.9.002. Contact Blog Owner