Hi, You should enable the db logging and try the generated sql by hand.
http://www.symfony-project.org/book/1_2/16-Application-Management-Tools On 27 oct, 14:40, erikms <erik.stok...@gmail.com> wrote: > Hi all, > I have an MS SQL database I want to access, and dutifully RTFM, > installed pdo_dblib, libtds, made my database connection > and I can connect, no problem. simple queries also are no problem: > $q = 'Afgh'; > $countries = Doctrine::getTable('MSCountries') > ->createQuery('m') > ->where('m.name like ?', '%' . $q . '%') > ->execute(); > > which gives me, indeed, 'Afghanistan'. > So far, so good. However, when I make my query more complex, say with > ->orWhere('m.name like ?', '%Swit%') > I get an SQL error telling me that the last '?' has not been > substituted. > > So... am I going about this wrong? or is Doctrine being buggy? or is > this a symfony matter? > running symfony-1.4.6 > > -Erik -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
