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

2009-04-29 Thread Christopher Jones
g')>0"); - Original Message - From: "Mark Casson" To: Sent: Thursday, April 23, 2009 6:10 AM Subject: [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, &#x

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

2009-04-23 Thread Rasmus Lerdorf
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"" wrote

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

2009-04-23 Thread Mark Casson
. > Switch back to double quotes? :-) > > $stmt = OCIParse($conn, "SELECT * FROM v\$sql WHERE > INSTR(SQL_TEXT,'something')>0"); > > - Original Message - > From: "Mark Casson" > To: > Sent: Thursday, April 23, 2009 6:10 AM > Subj

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

2009-04-23 Thread Mark Casson
Noted! :) ""Ford, Mike"" 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 know how much b

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

2009-04-23 Thread Ford, Mike
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 I

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

2009-04-23 Thread Yves Sucaet
Switch back to double quotes? :-) $stmt = OCIParse($conn, "SELECT * FROM v\$sql WHERE INSTR(SQL_TEXT,'something')>0"); - Original Message - From: "Mark Casson" To: Sent: Thursday, April 23, 2009 6:10 AM Subject: [PHP-DB] Re: PHP and table/view name

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

2009-04-23 Thread N . A . Morgan
Escape the embedded single quotes i.e. $stmt = OCIParse($conn, 'SELECT * FROM v$sql WHERE INSTR(SQL_TEXT,\'something\')>0'); Neil -Original Message- From: Mark Casson [mailto:confu...@icube.co.uk] Sent: 23 April 2009 12:10 To: php-db@lists.php.net Subject: [PH

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

2009-04-23 Thread Mark Casson
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 ""Mar

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

2009-04-23 Thread Mark Casson
Hi Guys, Thanks to you both - you are spot on! Shame this is not better documented somewhere. Mark ""Mark Casson"" 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. > > However, using: >

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

2009-04-23 Thread David Robley
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? >