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

Reply via email to