[PHP-DB] ORA-01460 error when useing bind sql on oracle from php

2003-11-20 Thread Are Pedersen
I get "ORA-01460: unimplemented or unreasonable conversion requested" when useing bind-sql on Oracle 9i. I am useing OCI 8.1 client in PHP. What is wrong? And what does this message mean? Here is the code: ---***--- $bindarray1=array(':project1'=>$project); $bindarray1[':userid']=$userid; $rs =

[PHP-DB] Re: ORA-01460 error when useing bind sql on oracle from php

2003-11-20 Thread Are Pedersen
Sorry about replying to my own posts, but... Problem solved! As OCIBindByName is binding to the actual variable, that variable must not be changed. I modified my script to look like this: ---***--- $ci=0; foreach ($bindargs as $bindname => $bindvalue){ ${"bindval$ci"}=$bindvalue; OCIBindByNam

[PHP-DB] Parse error on array and SQL query

2003-11-20 Thread Dillon, John
On line 188 and similar: line 187$this=$altIDs[$i]; line 188$query .= "ID='$this'"; I get the error: Parse error: parse error in /home/jdillon/public_html/provreport.php on line 188 Could this be because some setting has been changed on my shared

[PHP-DB] nested sets?

2003-11-20 Thread ma
hi everybody! i try to make a clickable menu. it should be outputed as XML. i found a solution to make it possible to decend only the selected menues. but is there a easier solution? my goal is to first show only the first (level=0) level. if the user clicks on the menu it should select the second

[PHP-DB] Linux/PHP with M$/SQL Server

2003-11-20 Thread Matt Giddings
Has anybody been able to bridge a Linux/php setup to a M$/SQL Server database? Is this possible using JDBC or a Unix ODBC connection to the SQL Server? Any pointers in the right direction would be greatly appreciated. Thanks, Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscr

RE: [PHP-DB] Parse error on array and SQL query

2003-11-20 Thread Hutchins, Richard
Speaking for myself only, I'm probably going to need to see more code than this to be able to help. These two lines appear to be OK. The error might be in what feeds line 187. > -Original Message- > From: Dillon, John [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 20, 2003 9:16 AM >

Re: [PHP-DB] Linux/PHP with M$/SQL Server

2003-11-20 Thread jeffrey_n_Dyke
you can use freetds (http://freetds.org) i think there is even an rpm... Then you just use the mssql_* functions built into php hth Jeff

[PHP-DB] Re: Linux/PHP with M$/SQL Server

2003-11-20 Thread pete M
I use PEAR db which is included wit the php distribution http://pear.php.net/manual/en/package.database.php http://vulcanonet.com/soft/?pack=pear_tut pete Matt Giddings wrote: Has anybody been able to bridge a Linux/php setup to a M$/SQL Server database? Is this possible using JDBC or a Unix O

Re: [PHP-DB] Linux/PHP with M$/SQL Server

2003-11-20 Thread Matt Giddings
Thanks Jeff, I'll look into FreeTDS. Matt [EMAIL PROTECTED] wrote: you can use freetds (http://freetds.org) i think there is even an rpm... Then you just use the mssql_* functions built into php hth Jeff

Re: [PHP-DB] Linux/PHP with M$/SQL Server

2003-11-20 Thread Frank M. Kromann
Hi, It is also described in the documentation at http://php.net/mssql. - Frank > Thanks Jeff, I'll look into FreeTDS. > > Matt > > [EMAIL PROTECTED] wrote: > > >you can use freetds (http://freetds.org) i think there is even an rpm... > >Then you just use the mssql_* functions built into php

Re: [PHP-DB] Linux/PHP with M$/SQL Server

2003-11-20 Thread Matt Giddings
Doh! RTFM. : ) You caught me.. Matt Frank M. Kromann wrote: Hi, It is also described in the documentation at http://php.net/mssql. - Frank Thanks Jeff, I'll look into FreeTDS. Matt [EMAIL PROTECTED] wrote: you can use freetds (http://freetds.org) i think there is even an

RE: [PHP-DB] Parse error on array and SQL query

2003-11-20 Thread Dillon, John
My host provider suggested escaping the SQL: $query .= "ID=\'$this\'"; which gets rid of the php error but gives invalid SQL. After a few exchanges with them it suddenly worked again as: $query .= "ID='$this'";. -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED] Sent: 20

[PHP-DB] how obtain last id past insert?

2003-11-20 Thread Webmaster D.G.R.E.R.
Hi: How i obtain inmediatly the id of last insert ? For example i have a forum, when the user post a question, i send a mail to administrator, but i want to refer the id from this insert, how i do this ? Well i think to make a select max(id) inmediatly but i beliebe that must have any c

Re: [PHP-DB] how obtain last id past insert?

2003-11-20 Thread jeffrey_n_Dyke
if you're using mysql php.net/mysql_insert_id if you're not, there may be a variant for you db hth Jeff "Webmaster

[PHP-DB] Re: Subject: Hitcounter works on production server but not on localhost

2003-11-20 Thread Neil Smth
Its not a permissions thing. You need to ensure that you provide PHP with a full path to the hit counter file : countrerlog.txt is a relative path. c:\\Inetpub\\wwwroot\\WCBE\\countrterlog.txt is a full path. You need to do the same with the relative path to FX_DataCounter/wcbecounter.txt as wel

Re: [PHP-DB] Parse error on array and SQL query

2003-11-20 Thread John W. Holmes
Dillon, John wrote: On line 188 and similar: line 187 $this=$altIDs[$i]; line 188 $query .= "ID='$this'"; I get the error: Parse error: parse error in /home/jdillon/public_html/provreport.php on line 188 Could this be because some setting has been changed on my shared host? $this is normall

Re: [PHP-DB] how obtain last id past insert?

2003-11-20 Thread John W. Holmes
Webmaster D.G.R.E.R. wrote: Hi: How i obtain inmediatly the id of last insert ? For example i have a forum, when the user post a question, i send a mail to administrator, but i want to refer the id from this insert, how i do this ? Well i think to make a select max(id) inmediatly but i

[PHP-DB] RE: Subject: Hitcounter works on production server but not on localhost

2003-11-20 Thread Paul Ihrig
hey niel. thanks man... thats wierd, why does it need to be full? how would i have been able to figure that out? appreciate it.. -Original Message- From: Neil Smth [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 12:53 PM To: Cc: [EMAIL PROTECTED] Subject: Re: Subject: Hitcount

Re: Re: [PHP-DB] Read file

2003-11-20 Thread Neil Smth
OK Error in my last post, the mail reader munged the HTML so if you need as source use the XML data below and hopefully the text below will appear as html code ;-) Cheers - Neil Demo Hotel Loader