The question mark indicates the position of an SQL parameter, and does not present a problem in it self. I think you should have an additional level of inner exception that includes some actual error message from the database engine.
/Oskar 2011/6/1 scottl2001 <[email protected]>: > > Hello all - > > I have an odd problem here. I created a new table for my web app (MS > SQL Server) and am trying to incorporate it into my web app. I'm > trying to do a simple ListByProperty thru NHibernate, and simply > cannot get the query to work. > > Given this code: > > ListByProperty("StyleNumberCustomerNumber", value) > > I ultimately get the following error via ListAll ancestor > (InnerException) : > > {"could not execute query\r\n[ SELECT this_.StyleID as StyleID11_0_, > this_.AddCustomerName as AddCusto2_11_0_, this_.BlanksCrossReference > as BlanksCr3_11_0_, this_.CharacterWidthTable as Characte4_11_0_, > this_.DateLastPriceChange as DateLast5_11_0_, this_.CreatedDate as > Created6_11_0_, this_.PressStatus as PressSt7_11_0_ FROM StyleMaster > this_ WHERE this_.StyleNumberCustomerNumber = ?]"} > > It simply doesn't recognize the input value (notice the question mark > (?) above), even though it is perfectly valid input. > > Keep in mind it is a brand new table added to the database. > Permissions do not appear to be a problem. Is there something I need > to do, given this is a new table? No problems with any existing > tables with the same type query. > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
