What is valid for a named parameter in a prepared query using PDO_SQLSRV.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi.

Just started using PDO with the nice and shiny SQLSRV driver form
Microsoft for SQL Server.

I seem to be having an issue with named parameters in prepared statements.

Are there limitations to the characters that can be used for named parameters.

UPPER, lower and MixedCase all seem OK, but I think I'm messing up with _.

And my brain JUST fired and told me _ is a single character wildcard
(as when used within a LIKE statement).

Can anyone confirm?

The usernote http://www.php.net/manual/en/pdo.prepared-statements.php#97162
mentions the use of hyphen (-), but not underscore (_).

I'm also going to be converting an old style coding mysql to mysqli
prepared statements (I know very little mysql, so 2 lots of learning
going on here).

Would mysqli have the same behaviour?

Is it driver specific?

Regards,

Richard.

-- 
Richard Quadling
Twitter : EE : Zend : PHPDoc
@RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux