Hi there,

I just typed in the code for the WroxAuthor Example, running the page show an error message:

Ausnahmedetails: System.Data.OleDb.OleDbException: Syntaxfehler in JOIN-Operation.

Quellfehler:


Zeile 22: Else
Zeile 23:
Zeile 24: DataGrid1.DataSource=objWroxAuthors.GetAuthorsByBo ok(DropDownList1.SelectedItem.Value)
Zeile 25: Datagrid1.DataBind()
Zeile 26:




It seems to me that the SQL-query( in the compiled WroxAuthors.vb file) for the DataAdapter-object is not correct although i typed it 100% correctly , and the error message also refers to a incorrect JOIN operation:

"SELECT Authors.AuthorFirstName, " & _
                "Authors.AuthorSurname, Books.Title FROM Authors LEFT JOIN Books ON " & _
                "Authors.Book = Book.Title WHERE (((Books.ISBN)='" & ISBN & "'));"

Can anybody tell me what's wrong?

Sorry - it was my fault. The sql command was wrong ! :(