I stopped using the adodb-odbtp driver, and instead am using the php mssql extension via the native cake 1.2 driver. The php mssql extension is, however, powered by odbtp, so I still get the odbtp benefits. The sql when using this method is generated differently and the view is now treated like a table.
The problem was occurring, I believe, in relation to how cake was trying to get a list of tables -- and the view was not showing up. Switching to mssql resolved that issue. jonathan.snook wrote: > On Apr 9, 4:14 pm, "sumanpaul" <[EMAIL PROTECTED]> wrote: > >> well it should work. if there seems to be problem try baking the >> model. It should show the view. If not then there might be some >> problem with view itself. >> it works for me. may be cake guys need more info to figure out why u r >> having problem. >> > > Just to clarify what Joshua is looking for: he's not speaking of Cake > views but rather of database views. Views should appear to look and > act just like tables. > > Joshua, you mention it's not finding the table. Have you taken a look > at the query Cake is generating? If so, have you tried running it > against the db directly to see if there's something going on. Maybe > some pluralization gone wrong? > > > > > -- Joshua Benner Asst. Network Administrator Information Technology Philadelphia Biblical University 215-702-4558 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
