MSSQL Views

[ksquared]

We have an aspx page that displays data from a query that is working. When we switch the query so that it references a view the page reports an invalid query. In the code below budgetdataview refers to a view, and we change budgetdataview to dtable, which refers to a table. When the table is referenced the page works. When the view is used in the from the page reports an invalid query. Is there something that needs to be included to use a MSsql view?

.dbSQL = "SELECT * FROM dbo.budgetdataview WHERE paiddate BETWEEN '8/1/05' and '8/7/05'"

[Frank]

ASP-db always works with View since day 1. The following display the 'Summary of Sales by Year' view of the SQL northwind DB. Check it out and compare to the View of your DB.

Fk.


Dim x As New Tornado.z
x.dbUnit = "1"
x.dbSkin = "Summermeadow"
x.dbTextHolder = "Title=SQP View"
x.dbType = "SQL"
x.dbProvider = "SQLClient"
x.dbDSN = "i22;northwind;sa;sa"
x.dbSQL = "SELECT * FROM [Summary of Sales by Year]"
x.ASPdbNET()