Re: [PHP-DB] floats

2005-07-19 Thread balwant singh
i run this query at my end, its running... pls check whether you gave the field names properly. With Best Wishes Balwant Singh blackwater dev wrote: I am running a query on MySQL: select * from cars where id =52 It returns the row and I can see that gas mileage is saved as a float with a

[PHP-DB] PHP and Sybase text datatype question

2005-07-19 Thread Frank Hamersley
Has anyone tangled with Sybase text (and/or image) datatypes and the writetext/readtext commands from PHP? I have the CT library linked in, but because Sybase does not support these datatypes as either parameters to stored procedures (or as @variables within stored procs either) I was wondering wh

Re: [PHP-DB] Prepared Statement not working (mysql 5)

2005-07-19 Thread Georg Richter
Am Do, den 14.07.2005 schrieb Marco Bascietto um 13:15: > > It looks like there is a problem with mysqli PS when the client and the > server share the same machine. > Does anyone have a clue on what is going on or point me to some tests I > can do? > There is no problem when running client and

Re: [PHP-DB] mysqli_stmt_bind_result

2005-07-19 Thread Georg Richter
Am So, den 10.07.2005 schrieb d3vnull um 12:06: > > According to the PHP manual it's quite normal that the above throws an error > message, because mysqli_stmt_bind_result() expects one variable for each > database field that you selected. If you just select a few fields from your > database th

[PHP-DB] floats

2005-07-19 Thread blackwater dev
I am running a query on MySQL: select * from cars where id =52 It returns the row and I can see that gas mileage is saved as a float with a value of 23.45. So I then do a query, select * from cars where id=52 and gas_mil=23.45 and the query doesn't retun anything. Why? Do I have to cast this a

[PHP-DB] garbage in odbc_connect error

2005-07-19 Thread Vandana Ponnuru
Hi all, I have PHP-4.3.10 and Apache-2.0 running on a Redhat 9 machine. I am connecting to DB2 using the odbc API. I have different applications running connecting to different databases and the applications were all running perfectly fine. But now, odbc_connect fails with some garbage in the S