Fwd: [PHP-DB] PHP ODBC odbc_fetch_array returns uninitialized values for Booleans

2015-06-30 Thread Bruce Bailey
systems. Bruce -- Forwarded message -- From: Bastien Koert phps...@gmail.com Date: Mon, Jun 29, 2015 at 7:21 PM Subject: Re: [PHP-DB] PHP ODBC odbc_fetch_array returns uninitialized values for Booleans To: Bruce Bailey brucebailey...@gmail.com, php-db@lists.php.net

[PHP-DB] PHP ODBC odbc_fetch_array returns uninitialized values for Booleans

2015-06-29 Thread Bruce Bailey
*Description* The PHP function odbc_fetch_array returns uninitialized values for PostgreSQL boolean values. On older systems, this function returned '1' for true and '0' for false values. On our 64 bit system, the boolean values appear to be uninitialized data. *Additional information*

Re: [PHP-DB] PHP ODBC odbc_fetch_array returns uninitialized values for Booleans

2015-06-29 Thread Bastien Koert
Is it a truly a three state field (true, false, null) or just T/F? Perhaps a default value for the field might be better? On Mon, Jun 29, 2015 at 11:42 AM Bruce Bailey brucebailey...@gmail.com wrote: *Description* The PHP function odbc_fetch_array returns uninitialized values for PostgreSQL

Re: [PHP-DB] PHP ODBC and Pervasive.SQL

2004-02-27 Thread Pascal Schaedeli
Robert, Thank you very much for your post: odbtp solved the problem and gave me a head start on moving the site to a Linux box. Pascal Robert Twitty [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi Pascal The odbc extension uses ODBC 2, while Access and Pervasive are most likely

[PHP-DB] PHP ODBC and Pervasive.SQL

2004-02-26 Thread Pascal Schaedeli
Hi, I am executing a SELECT query from PHP (4.3.4) through ODBC on a Pervasive 2000SP4 (all on Windows). odbc_result_all, odbc_fetch_into, and all other php odbc function stop returning records before the end of the effective resultset. Here is what is happening : * In Pervasive: SELECT * FROM

Re: [PHP-DB] PHP ODBC and Pervasive.SQL

2004-02-26 Thread Robert Twitty
Hi Pascal The odbc extension uses ODBC 2, while Access and Pervasive are most likely using ODBC 3. This may or may not be the cause of your problem. Try using the odbtp extension at http://odbtp.sourceforge.net. It uses ODBC 3, and may give you better results. -- bob On Wed, 25 Feb 2004,

Re: [PHP-DB] PHP/ODBC/Apache/Netware/Foxpro Problem

2003-07-14 Thread Robert Twitty
What is the setting of the ODBC connect string parameter SOURCEDB? Does the PC running Apache have permission to access the path specified by SOURCEDB? -- bob On Mon, 14 Jul 2003, YT Lee wrote: I have a Windows XP PC configured as follow: 1. Apache 2.0.46 2. PHP 4.3.2 3. Microsoft Visual

[PHP-DB] PHP/ODBC/Apache/Netware/Foxpro Problem

2003-07-13 Thread YT Lee
I have a Windows XP PC configured as follow: 1. Apache 2.0.46 2. PHP 4.3.2 3. Microsoft Visual Foxpro ODBC Driver The PC is connected to a Netware 3.2 server. The database are implemented as Foxpro 2.6 free tables on the Netware server. The PC is connected to the server via Netware client

[PHP-DB]php-odbc-ctree

2003-05-27 Thread Gabriel Gramajo
Does anybody knows any kind of odbc for c-treeĀ“s databases in linux ? Thanks in advance, Gabriel. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] php- odbc- access

2002-12-11 Thread Edward Peloke
Many of the people who will be using my php site, will also be using an app that runs an access db. I would like to create a page on my webpage that allows the users to click a button, and data is moved from their access db on their machines, to my mysql db. Is this possible? I will know where

RE: [PHP-DB] php- odbc- access

2002-12-11 Thread Snijders, Mark
don't think it's possible @ once... what I suggest... those people have to make a comma delimited export file, then you make an upload page, where people can upload this file. and you make a script so it will be imported get the point? kind regards ___ Mark

RE: [PHP-DB] php- odbc- access

2002-12-11 Thread SELPH,JASON (HP-Richardson,ex1)
To: [EMAIL PROTECTED] Subject: [PHP-DB] php- odbc- access Many of the people who will be using my php site, will also be using an app that runs an access db. I would like to create a page on my webpage that allows the users to click a button, and data is moved from their access db

Re: [PHP-DB] PHP-ODBC

2002-10-26 Thread Andrew Hill
Nithin, This issue is due to the ODBCINI environment variable not being set by in your PHP script, or the odbc.ini file that variable points to not being readable by the user that Apache runs as. Check out the PHP-ODBC-HOWTO at www.iodbc.org for examples of what environment variables need to

[PHP-DB] PHP-ODBC

2002-10-24 Thread Poduval, Nithin
Hi All, We are also facing a problem in connecting PHP with database, We are trying to access the MS SQL Server 2000 which runs on Windows 2000 from the php in the Linux 7.2. During access the php, it gives the followin message. Warning: SQL error: [iODBC][Driver Manager]Data source name not

[PHP-DB] PHP ODBC

2002-02-21 Thread Paulo Freitas
Hi, I'm running True64 UNIX with ingres 6.4 and openlink ODBC. When i connect thru cgi(C/C++) it works fine but when i connect via PHP 4.1.1 gives me this error: [OpenLink][ODBC][Driver]No key columns found for table referenced by keyset driven cursor., SQL state IM909 in SQLPrepare I

[PHP-DB] PHP, ODBC Access2k - Getting a field value from the last INSERT

2001-11-15 Thread Dan Boitnott
I have a table that I need to update using INSERT INTO table (field1, field2) VALUES (val1, val2) The table has an AutoNumber field for a Primary Key called ID. I need to get the ID that was assigned in the INSERT. With PostgreSQL you do this with oids but as far as I know Access doesn't use

[PHP-DB] PHP ODBC Connection

2001-08-20 Thread jacques charlery
Hi everybody, I'm new to PHP4 and I'm trying my first connection to an odbc database. I'm using RedHat 7.0, PHP 4.0.1pl2, and unixODBC to connect via ODBC to MSSQL running on Windows NT. I've been able to correctly configure unixODBC with easysoft's odbc to odbc bridge. I've created an ms-sql

[PHP-DB] PHP-ODBC-MSSQL (Text type fields)

2001-07-10 Thread Michael Yevdokimov
Hello Did anybody have problems with retrieving data from the fields of type Text.. ?php $dsn = dsn_database; $user = enduser; $pass = ; $query = usp_get_subj 10; $conn = odbc_connect($dsn, $user, $pass); $res = odbc_exec($conn, $query); while (odbc_fetch_row($res)) { //$data =

[PHP-DB] PHP-ODBC-MSSQL (Text type fields) PART II

2001-07-10 Thread Michael Yevdokimov
Hi I found an interesting thing.. But it will just make my work much harder.. comparing to ASP... :o (which I already am not able to use in the project we should deliver to our customer in a few weeks :o ?php // database settings $dsn = dsn_database; $user = enduser; $pass = ;

[PHP-DB] PHP-ODBC-MSSQL PartII

2001-07-10 Thread Michael Yevdokimov
The error which occures during the call of stored procedure is: Warning: SQL error: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index, SQL state S1002 in SQLGetData in d:\Inetpub\wwwroot\local_test\test.php on line 43 Michael Yevdokimov Web developer e-mail: [EMAIL PROTECTED]

[PHP-DB] PHP-ODBC-MSSQL (NT) PART 3

2001-07-10 Thread Michael Yevdokimov
Ok.. I discovered also that everything will work pretty good.. But!! The field on type text should be ALWAYS the LAST in the model of the table.. Otherwise, it will not work what happens in my case.. Good night! Mike Michael Yevdokimov Web developer e-mail: [EMAIL PROTECTED]