Re: Problem when using SQL_CUR_USE_ODBC on connect

(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@strausesoftware.com> 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 > >