Nothing wrong with the input. There must be some sort of mapping issue. Is there some mapping that needs to take place in NHibernate when adding a new table?
Anyone know? On Jun 2, 4:19 am, Oskar Berggren <[email protected]> wrote: > 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 > > athttp://groups.google.com/group/nhusers?hl=en.- Hide quoted text - > > - Show quoted text - -- 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.
