Re: Problem when using SQL_CUR_USE_ODBC on connect

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



(This isn't a solution, per se...just a suggestion.)

I don't know how they compare; I've never personally used the ODBC
functions...

But, you may give the MSSQL functions a try:
http://php.net/mssql

- Jon L.

On Mon, Mar 31, 2008 at 3:27 PM, cfs <charlie@xxxxxxxxxxxxxxxxxxx> wrote:

> I'm using PHP with Apache. PHP code connects to MS SQL server using ODBC.
>
> I'm doing a query against a table that is very simple: one column of the
> real data type, one of the text data type.
>
> The text field is set to "testing 1,2,3". The real column is set to
> 10.0199995.
>
> When I use the default connect options, I get both values back fine.
>
> When I use  SQL_CUR_USE_ODBC, which I very much want to use, then the text
> column data comes back as boolean(false).
>
> Does anyone know of a solution?
>
> Table:
>
> CREATE TABLE [dbo].[test1](
> [ID] [int] IDENTITY(1,1) NOT NULL,
>
> [real1] [real] NULL,
>
> [text1] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
>
> CONSTRAINT [PK_test1] PRIMARY KEY CLUSTERED
>
> (
>
> [ID] ASC
>
> )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
>
> ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
>
> Code:
>
> <?php
> $conn = odbc_connect(db-name, user-name,password, SQL_CUR_USE_ODBC);
> $result = odbc_exec($conn, "select * from test1");
> if (odbc_fetch_row($result)) {
>  print "Values: " . odbc_result($result,"real1") . "," .
> odbc_result($result,"text1");
> }
> ?>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux