[PHP-DB] Re: PHP and table/view names with '$'

Mark Casson wrote: Hi, I am trying to access some of the v$ views using php on iis, with admin privileges. However, using: $stmt = OCIParse($conn, SELECT * FROM v$sql); gives me this error: PHP Notice: undefined variable: sql . . . Is there a way around this? Thanks Mark

[PHP-DB] Re: PHP and table/view names with '$'

Hi Guys, Thanks to you both - you are spot on! Shame this is not better documented somewhere. Mark Mark Casson confu...@icube.co.uk wrote in message news:89.4e.33545.c2d30...@pb1.pair.com... Hi, I am trying to access some of the v$ views using php on iis, with admin privileges.

[PHP-DB] Re: PHP and table/view names with '$'

Hi, Of course, the next problem is that i want to specify a line to find: $stmt = OCIParse($conn, 'SELECT * FROM v$sql WHERE INSTR(SQL_TEXT,'something')0'); and i seem to have to use single quotes in the INSTR function. Is there an alternative way to deal with that? Thanks again Mark Mark

Re: [PHP-DB] Re: PHP and table/view names with '$'

Switch back to double quotes? :-) $stmt = OCIParse($conn, SELECT * FROM v\$sql WHERE INSTR(SQL_TEXT,'something')0); - Original Message - From: Mark Casson confu...@icube.co.uk To: php-db@lists.php.net Sent: Thursday, April 23, 2009 6:10 AM Subject: [PHP-DB] Re: PHP and table/view

RE: [PHP-DB] Re: PHP and table/view names with '$'

On 23 April 2009 11:36, Mark Casson advised: Hi Guys, Thanks to you both - you are spot on! Shame this is not better documented somewhere. I don't know how much better documented it can be than at http://php.net/language.types.string ... ;) Cheers! Mike -- Mike Ford, Electronic

Re: [PHP-DB] Re: PHP and table/view names with '$'

Noted! :) Ford, Mike m.f...@leedsmet.ac.uk wrote in message news:93ed589e60ba254f97435fe6c97f2c6702b92...@leedsmet-exch1.leedsmet.ac.uk... On 23 April 2009 11:36, Mark Casson advised: Hi Guys, Thanks to you both - you are spot on! Shame this is not better documented somewhere. I don't

Re: [PHP-DB] Re: PHP and table/view names with '$'

to double quotes? :-) $stmt = OCIParse($conn, SELECT * FROM v\$sql WHERE INSTR(SQL_TEXT,'something')0); - Original Message - From: Mark Casson confu...@icube.co.uk To: php-db@lists.php.net Sent: Thursday, April 23, 2009 6:10 AM Subject: [PHP-DB] Re: PHP and table/view names

Re: [PHP-DB] Re: PHP and table/view names with '$'

This is well-documented in the String part of the Data Types section: http://www.php.net/manual/en/language.types.string.php -Rasmus Mark Casson wrote: Hi Guys, Thanks to you both - you are spot on! Shame this is not better documented somewhere. Mark Mark Casson