ID: 38834
User updated by: aspen dot olmsted at alliance dot biz
Reported By: aspen dot olmsted at alliance dot biz
Status: Open
Bug Type: PDO related
Operating System: Windows XP SP2
PHP Version: 5.1.6
New Comment:
I noticed that the array returned is actually duplicating the columns.
One for each name and then one per number:
array(6) {
["scpFreeText"]=>
string(7895) "<UL class=ul3><B>$2,500$4,999</B>
<LI>2 x 4, Inc
<LI>Alan Brasington Network
<LI>Eleanor S. Applewhaite
<LI>Martha and Thomas G. Armstrong
<LI>Jody and John Arnhold
<LI>Page Ashley
<LI>In Memory of Betty L. Asiel
<LI>Rosalind Case Avrett
<LI>Susan Baker and Michael Lynch
<LI>Lucy and Joel Banker
<LI>Dave Barger
<LI>Richard and Eslyn Bassuk
<LI>Ginette and Joshua Becker
<LI>Margaret and James Bernstein
<LI>Leslie and George C. Biddle
<LI>Marilyn Friedman and Thomas Block
<LI>Harvi and Bob Bloom
<LI>The Blythmour Corporation
<LI>Brian R. Meara Public Relations Inc.
<LI>The Brodsky Organization
<LI>David Brown and Helen Gurley Brown
<LI>Marian Culbertson Hvolbeck
<LI>Mr. and Mrs. Willard C. Butcher
<LI>Frank and Nancy Bynum
<LI>Ms. Deborah Carmichael
<LI>John K. Castle
<LI>Elizabeth and Jay Chandler
<LI>Mr. and Mrs. Michael J. Chasanoff
<LI>Citigroup Private Bank
<LI>Connie and Richard W. Cohen
<LI>Colgate-Palmolive Company
<LI>Con Edison
<LI>Peter and Julie Cummings
<LI>Ms. Marjorie M. Curry
<LI>Matthew J. Cvetic
<LI>D. Ronald Daniel and Lise Scott
<LI>Lucy and Mike Danziger
<LI>Mr. and Mrs. J. Dennis Delafield
<LI>Jamie deRoy
<LI>Gayle and Dan Devin
<LI>Valerie and Charles Diker
<LI>Robert and Marti Dinerstein
<LI>Discovery Communications, Inc.
<LI>DMJM Harris
<LI>Anthony Dolce
<LI>Ms. Domitilia M. dos Santos
<LI>In Memoriam - Mr. and Mrs. Gerald A. Dundon
<LI>Edison Properties, LLC
<LI>Edmar
<LI>Lewis and Judy Eisenberg
<LI>Nancy Donohue and Diane Elam
<LI>Empire BlueCross BlueShield
<LI>Paula S. Epsteen
<LI>Stanley Epstein
<LI>Mr. and Mrs. Leroy Fadem
<LI>Roger N. Farah/Polo Ralph Lauren Foundation
<LI>Fiona Morgan Fein
<LI>Mr. and Mrs. Massimo Ferragamo
<LI>Arlene and Robert Fischer
<LI>Andrew Frackman and Emily Braun
<LI>Juliet Frank
<LI>Freedom Forum
<LI>Cynthia and Eliot Fried
<LI>The Barry Friedberg and Charlotte Moss Family Foundation
<LI>Patrice and Louis Friedman
<LI>In Memory of Ella and George Geiger
<LI>Ms. Lynn Gilbert
<LI>Mr. & Mrs. Richard F. Goodman
<LI>Ms. Beth S. Gould
<LI>Mr. and Mrs. Harry E. Gould, Jr.
<LI>Gray Family Foundation
<LI>Annette Green
<LI>Mr. and Mrs. Maurice R. Greenberg/The Greenberg Foundation
<LI>Naava and Sanford Grossman
<LI>Doris Grzymski
<LI>Ralph and Calla Guild
<LI>Mr. and Mrs. John H. Gutfreund
<LI>Gerry Harper
<LI>Mary W. Harriman Foundation
<LI>Ted & Dina Merrill Hartley
<LI>Mrs. Eva Hartman
<LI>Linda and Mel Heineman
<LI>Marian S. Heiskell
<LI>David M. Helpern
<LI>Buck Henry Charitable Fund Administered by the <BR>
California Community Foundation
<LI>John S. Herold, Inc.
<LI>Ellen and David S. Hirsch
<LI>Jacqueline and Robert Hochberg
<LI>Will Holt
<LI>Carol and Howard Holtzmann
<LI>Ruth W. Houghton
<LI>Mr. and Mrs. Charles O. Hoyt
<LI>Jill and Ken Iscol
<LI>Dr. and Mrs. Julius H. Jacobson II
<LI>Linda and Morton Janklow
<LI>Freda S. Johnson
<LI>Marnee and Eric Kaltman
<LI>The Kandell Fund
<LI>Maury I. Kaplin
<LI>Mr. and Mrs. John A. Kauffmann
<LI>Stuart and Isabel Kessler
<LI>Dr. Herry Kijner
<LI>Kirkland & Ellis LLP
<LI>Victor and Sarah Kovner
<LI>Alice and Dennis Krieger
<LI>Linda L. and Benjamin V. Lambert
<LI>Deborah and Peter Lamm
<LI>Terese and Alvin Lane
<LI>June Noble Larkin
<LI>Lazard
<LI>LeBouef, Lamb, Greene & MacRae, LLP
<LI>Joseph and Juanita Leff
<LI>Linda and Sandy Lindenbaum
<LI>Mr. and Mrs. Robert E. Linton
<LI>Liz Robbins Associates
<LI>Eileen Josten Lowe
<LI>James A. Macdonald Foundation
<LI>Holly & John Madigan
<LI>Richard H.M. and Gail Lowe Maidman
<LI>Flora Major
<LI>The Mallah Group/ICON Parking Systems
<LI>Matthew J. Mallow and Ellen Chesler
<LI>Barbara and J. Robert Mann, Jr.
<LI>Judith and Michael Margulies
<LI>Ronald J. Marino and Christine E. Morrison
<LI>Marion and Terry Martin
<LI>Elaine and Eli Mattioli
<LI>Prakash and Anjali Melwani
<LI>Ellen and Lee Metzendorf
<LI>Bruce Meyers
<LI>Mr. and Mrs. Lewis A. Miller
<LI>Marianne and Steve Mills
<LI>Donald R. Mullen, Jr.
<LI>Suzanne and Thomas Murphy
<LI>The Netter Foundation
<LI>Mr. and Mrs. Donald E. Newhouse
<LI>Elyse and Michael Newhouse
<LI>Colleen and Roger Noall
<LI>Bob O'Brien
<LI>Nancy and Morris W. Offit
<LI>Henna Ong and Peter D. Lawrence
<LI>Herbert Pardes and Nancy Wexler
<LI>Mr. and Mrs. Samuel P. Peabody
<LI>Barbara and Victor Pelson
<LI>Mr. and Mrs. W. Hollis Petersen
<LI>Elaine and Charles Petschek
<LI>In Memory of Nancy Pfifferling
<LI>Mr. and Mrs. Joel I. Picket
<LI>Mr. Evan Picoult
<LI>Marnie and Don Pillsbury
<LI>Ruth Porat and Anthony Paduano
<LI>Nancy D. Portnoy
<LI>Jeffrey and Judith Prussin
<LI>In Memory of Adele S. Rebell
<LI>Paula and Ira M. Resnick
<LI>The Karl F. Reuling Fund
<LI>Yvonne and John Rhea
<LI>Mrs. Henry Hart Rice
<LI>Allan and Reda R. Riley Foundation
<LI>Barbara J. Riley
<LI>Jonathan F. P. Rose
<LI>Susan and Elihu Rose Foundation
<LI>Jeffrey A. and Marjorie G. Rosen
<LI>Robert Rosenkranz and Alexandra Munroe
<LI>The Richard and Hinda Rosenthal Foundation
<LI>Dr. Svetlana Salerno
<LI>Helene and Maurice Saragoussi
<LI>Elaine Sargent
<LI>Robin and Arrien Schiltkamp
<LI>Rudy and Elaine Schott
<LI>Hannelore Schulhof
<LI>Mrs. Richard Selle
<LI>Joseph S. Shapiro
<LI>Gil Shiva
<LI>Ruth Lande Shuman
<LI>Anne and Constantine Sidamon-Eristoff
<LI>Adrianne and William Silver
<LI>Patti and David Silver
<LI>Stephen and Bonnie Simon
<LI>Alan B. Slifka
<LI>Annaliese Soros
<LI>The Stainrook Foundation
<LI>Burton B. Staniar
<LI>Mr. and Mrs. Jack Stein
<LI>Jean Stein, JKW Foundation
<LI>Joshua L. Steiner
<LI>Pavur R. Sundaresan, MD, PhD
<LI>The Susman Family
<LI>Gloria and Philip Talkow
<LI>Marie Therese Taussi
<LI>Margaretta Taylor
<LI>Marilyn and Brainerd Taylor
<LI>Bunny and Sid Todres
<LI>Lee and Marvin S. Traub
<LI>UBS Investment Bank
<LI>Andrea and Paul Vizcarrondo
<LI>Law Offices of Claudia Wagner
<LI>John Wagner
<LI>Mrs. James P. Warburg
<LI>Dan K. Wassong
<LI>Alan and Elaine Weiler
<LI>Liz and Steve Weinstein
<LI>Steve and Linda Weiss
<LI>David Wertheimer
<LI>Judy and Josh Weston
<LI>Ms. Shelby White
<LI>Mr. John C. Whitehead
<LI>The Wien Family Fund
<LI>Mr. and Mrs. Charles Wood
<LI>Cecilia Blewer and Clayton Young
<LI>Twelve Anonymous</LI></UL>
<P><EM>As of July 23, 2006</EM></P>
<P>Deceased</P>
<P>Lincoln Center for the Performing Arts, Inc. is deeply grateful to
the government agencies and elected representatives listed below for
their support for our 200607 season.
<UL class=ul3>
<LI>City of New York, Michael R. Bloomberg, Mayor
<LI>New York City Department of Cultural Affairs, Kate D. Levin,
Commissioner
<LI>New York City Department of Parks and
Recreation,<BR> Adrian Benepe, Commissioner
<LI>New York City Department of Education, Chancellor Joel Klein
<LI>New York City Department of Youth and Community
Development,<BR> Jeanne B. Mullgrav, Commissioner
<LI>New York City Department of Health and Mental Hygiene
<BR> Thomas R. Frieden, MD, Commissioner
<LI>Office of the Manhattan Borough President
<LI>New York City Council, Speaker Christine C. Quinn
<LI>The Honorable Gale A. Brewer, New York City Council
<LI>The Honorable Sheldon Silver, Speaker, New York State Assembly
<LI>The Honorable David A. Paterson, Minority Leader, New York State
Senate
<LI>The Honorable Jose M. Serrano, New York State Senate
<LI>New York State Office of Parks, Recreation and Historic
Preservation
<LI>New York State Council on the Arts
<LI>National Endowment for the Arts</LI></UL>"
[0]=>
string(7895) "<UL class=ul3><B>$2,500$4,999</B>
<LI>2 x 4, Inc
<LI>Alan Brasington Network
<LI>Eleanor S. Applewhaite
<LI>Martha and Thomas G. Armstrong
<LI>Jody and John Arnhold
<LI>Page Ashley
<LI>In Memory of Betty L. Asiel
<LI>Rosalind Case Avrett
<LI>Susan Baker and Michael Lynch
<LI>Lucy and Joel Banker
<LI>Dave Barger
<LI>Richard and Eslyn Bassuk
<LI>Ginette and Joshua Becker
<LI>Margaret and James Bernstein
<LI>Leslie and George C. Biddle
<LI>Marilyn Friedman and Thomas Block
<LI>Harvi and Bob Bloom
<LI>The Blythmour Corporation
<LI>Brian R. Meara Public Relations Inc.
<LI>The Brodsky Organization
<LI>David Brown and Helen Gurley Brown
<LI>Marian Culbertson Hvolbeck
<LI>Mr. and Mrs. Willard C. Butcher
<LI>Frank and Nancy Bynum
<LI>Ms. Deborah Carmichael
<LI>John K. Castle
<LI>Elizabeth and Jay Chandler
<LI>Mr. and Mrs. Michael J. Chasanoff
<LI>Citigroup Private Bank
<LI>Connie and Richard W. Cohen
<LI>Colgate-Palmolive Company
<LI>Con Edison
<LI>Peter and Julie Cummings
<LI>Ms. Marjorie M. Curry
<LI>Matthew J. Cvetic
<LI>D. Ronald Daniel and Lise Scott
<LI>Lucy and Mike Danziger
<LI>Mr. and Mrs. J. Dennis Delafield
<LI>Jamie deRoy
<LI>Gayle and Dan Devin
<LI>Valerie and Charles Diker
<LI>Robert and Marti Dinerstein
<LI>Discovery Communications, Inc.
<LI>DMJM Harris
<LI>Anthony Dolce
<LI>Ms. Domitilia M. dos Santos
<LI>In Memoriam - Mr. and Mrs. Gerald A. Dundon
<LI>Edison Properties, LLC
<LI>Edmar
<LI>Lewis and Judy Eisenberg
<LI>Nancy Donohue and Diane Elam
<LI>Empire BlueCross BlueShield
<LI>Paula S. Epsteen
<LI>Stanley Epstein
<LI>Mr. and Mrs. Leroy Fadem
<LI>Roger N. Farah/Polo Ralph Lauren Foundation
<LI>Fiona Morgan Fein
<LI>Mr. and Mrs. Massimo Ferragamo
<LI>Arlene and Robert Fischer
<LI>Andrew Frackman and Emily Braun
<LI>Juliet Frank
<LI>Freedom Forum
<LI>Cynthia and Eliot Fried
<LI>The Barry Friedberg and Charlotte Moss Family Foundation
<LI>Patrice and Louis Friedman
<LI>In Memory of Ella and George Geiger
<LI>Ms. Lynn Gilbert
<LI>Mr. & Mrs. Richard F. Goodman
<LI>Ms. Beth S. Gould
<LI>Mr. and Mrs. Harry E. Gould, Jr.
<LI>Gray Family Foundation
<LI>Annette Green
<LI>Mr. and Mrs. Maurice R. Greenberg/The Greenberg Foundation
<LI>Naava and Sanford Grossman
<LI>Doris Grzymski
<LI>Ralph and Calla Guild
<LI>Mr. and Mrs. John H. Gutfreund
<LI>Gerry Harper
<LI>Mary W. Harriman Foundation
<LI>Ted & Dina Merrill Hartley
<LI>Mrs. Eva Hartman
<LI>Linda and Mel Heineman
<LI>Marian S. Heiskell
<LI>David M. Helpern
<LI>Buck Henry Charitable Fund Administered by the <BR>
California Community Foundation
<LI>John S. Herold, Inc.
<LI>Ellen and David S. Hirsch
<LI>Jacqueline and Robert Hochberg
<LI>Will Holt
<LI>Carol and Howard Holtzmann
<LI>Ruth W. Houghton
<LI>Mr. and Mrs. Charles O. Hoyt
<LI>Jill and Ken Iscol
<LI>Dr. and Mrs. Julius H. Jacobson II
<LI>Linda and Morton Janklow
<LI>Freda S. Johnson
<LI>Marnee and Eric Kaltman
<LI>The Kandell Fund
<LI>Maury I. Kaplin
<LI>Mr. and Mrs. John A. Kauffmann
<LI>Stuart and Isabel Kessler
<LI>Dr. Herry Kijner
<LI>Kirkland & Ellis LLP
<LI>Victor and Sarah Kovner
<LI>Alice and Dennis Krieger
<LI>Linda L. and Benjamin V. Lambert
<LI>Deborah and Peter Lamm
<LI>Terese and Alvin Lane
<LI>June Noble Larkin
<LI>Lazard
<LI>LeBouef, Lamb, Greene & MacRae, LLP
<LI>Joseph and Juanita Leff
<LI>Linda and Sandy Lindenbaum
<LI>Mr. and Mrs. Robert E. Linton
<LI>Liz Robbins Associates
<LI>Eileen Josten Lowe
<LI>James A. Macdonald Foundation
<LI>Holly & John Madigan
<LI>Richard H.M. and Gail Lowe Maidman
<LI>Flora Major
<LI>The Mallah Group/ICON Parking Systems
<LI>Matthew J. Mallow and Ellen Chesler
<LI>Barbara and J. Robert Mann, Jr.
<LI>Judith and Michael Margulies
<LI>Ronald J. Marino and Christine E. Morrison
<LI>Marion and Terry Martin
<LI>Elaine and Eli Mattioli
<LI>Prakash and Anjali Melwani
<LI>Ellen and Lee Metzendorf
<LI>Bruce Meyers
<LI>Mr. and Mrs. Lewis A. Miller
<LI>Marianne and Steve Mills
<LI>Donald R. Mullen, Jr.
<LI>Suzanne and Thomas Murphy
<LI>The Netter Foundation
<LI>Mr. and Mrs. Donald E. Newhouse
<LI>Elyse and Michael Newhouse
<LI>Colleen and Roger Noall
<LI>Bob O'Brien
<LI>Nancy and Morris W. Offit
<LI>Henna Ong and Peter D. Lawrence
<LI>Herbert Pardes and Nancy Wexler
<LI>Mr. and Mrs. Samuel P. Peabody
<LI>Barbara and Victor Pelson
<LI>Mr. and Mrs. W. Hollis Petersen
<LI>Elaine and Charles Petschek
<LI>In Memory of Nancy Pfifferling
<LI>Mr. and Mrs. Joel I. Picket
<LI>Mr. Evan Picoult
<LI>Marnie and Don Pillsbury
<LI>Ruth Porat and Anthony Paduano
<LI>Nancy D. Portnoy
<LI>Jeffrey and Judith Prussin
<LI>In Memory of Adele S. Rebell
<LI>Paula and Ira M. Resnick
<LI>The Karl F. Reuling Fund
<LI>Yvonne and John Rhea
<LI>Mrs. Henry Hart Rice
<LI>Allan and Reda R. Riley Foundation
<LI>Barbara J. Riley
<LI>Jonathan F. P. Rose
<LI>Susan and Elihu Rose Foundation
<LI>Jeffrey A. and Marjorie G. Rosen
<LI>Robert Rosenkranz and Alexandra Munroe
<LI>The Richard and Hinda Rosenthal Foundation
<LI>Dr. Svetlana Salerno
<LI>Helene and Maurice Saragoussi
<LI>Elaine Sargent
<LI>Robin and Arrien Schiltkamp
<LI>Rudy and Elaine Schott
<LI>Hannelore Schulhof
<LI>Mrs. Richard Selle
<LI>Joseph S. Shapiro
<LI>Gil Shiva
<LI>Ruth Lande Shuman
<LI>Anne and Constantine Sidamon-Eristoff
<LI>Adrianne and William Silver
<LI>Patti and David Silver
<LI>Stephen and Bonnie Simon
<LI>Alan B. Slifka
<LI>Annaliese Soros
<LI>The Stainrook Foundation
<LI>Burton B. Staniar
<LI>Mr. and Mrs. Jack Stein
<LI>Jean Stein, JKW Foundation
<LI>Joshua L. Steiner
<LI>Pavur R. Sundaresan, MD, PhD
<LI>The Susman Family
<LI>Gloria and Philip Talkow
<LI>Marie Therese Taussi
<LI>Margaretta Taylor
<LI>Marilyn and Brainerd Taylor
<LI>Bunny and Sid Todres
<LI>Lee and Marvin S. Traub
<LI>UBS Investment Bank
<LI>Andrea and Paul Vizcarrondo
<LI>Law Offices of Claudia Wagner
<LI>John Wagner
<LI>Mrs. James P. Warburg
<LI>Dan K. Wassong
<LI>Alan and Elaine Weiler
<LI>Liz and Steve Weinstein
<LI>Steve and Linda Weiss
<LI>David Wertheimer
<LI>Judy and Josh Weston
<LI>Ms. Shelby White
<LI>Mr. John C. Whitehead
<LI>The Wien Family Fund
<LI>Mr. and Mrs. Charles Wood
<LI>Cecilia Blewer and Clayton Young
<LI>Twelve Anonymous</LI></UL>
<P><EM>As of July 23, 2006</EM></P>
<P>Deceased</P>
<P>Lincoln Center for the Performing Arts, Inc. is deeply grateful to
the government agencies and elected representatives listed below for
their support for our 200607 season.
<UL class=ul3>
<LI>City of New York, Michael R. Bloomberg, Mayor
<LI>New York City Department of Cultural Affairs, Kate D. Levin,
Commissioner
<LI>New York City Department of Parks and
Recreation,<BR> Adrian Benepe, Commissioner
<LI>New York City Department of Education, Chancellor Joel Klein
<LI>New York City Department of Youth and Community
Development,<BR> Jeanne B. Mullgrav, Commissioner
<LI>New York City Department of Health and Mental Hygiene
<BR> Thomas R. Frieden, MD, Commissioner
<LI>Office of the Manhattan Borough President
<LI>New York City Council, Speaker Christine C. Quinn
<LI>The Honorable Gale A. Brewer, New York City Council
<LI>The Honorable Sheldon Silver, Speaker, New York State Assembly
<LI>The Honorable David A. Paterson, Minority Leader, New York State
Senate
<LI>The Honorable Jose M. Serrano, New York State Senate
<LI>New York State Office of Parks, Recreation and Historic
Preservation
<LI>New York State Council on the Arts
<LI>National Endowment for the Arts</LI></UL>"
["scpLastUpdate"]=>
string(0) ""
[1]=>
string(0) ""
["scpName"]=>
string(0) ""
[2]=>
string(0) ""
}
Previous Comments:
------------------------------------------------------------------------
[2006-09-14 17:59:14] aspen dot olmsted at alliance dot biz
Description:
------------
I am connecting to sql with and retrieving a single row with 3 columns.
One column is a 8000 varchar. If I put the other two columns before
the large varchar everything is fine. If I put them after they come
back empty.
Reproduce code:
---------------
$dbh = new PDO('odbc:lcpeo', 'user', 'password');
$sql = "SELECT scpFreeText, scpLastUpdate,scpName FROM ScreenParts
WHERE scpCode = 1541";
foreach($dbh->query($sql) as $row)
{
var_dump($row);
}
$dbh = null;
Here is the table definition:
CREATE TABLE [ScreenParts] (
[scpCode] [int] NOT NULL CONSTRAINT [DF_ScreenParts_scpCode] DEFAULT
(0),
[scpScreenCode] [int] NOT NULL CONSTRAINT
[DF_ScreenParts_scpScreenCode] DEFAULT (0),
[scpScreenName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL CONSTRAINT [DF_ScreenParts_scpScreenName] DEFAULT (''),
[scpName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL CONSTRAINT [DF_ScreenParts_scpName] DEFAULT (''),
[scpType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
CONSTRAINT [DF_ScreenParts_scpType] DEFAULT (''),
[scpFileName] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL CONSTRAINT [DF_ScreenParts_scpFileName] DEFAULT (''),
[scpParameters] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL CONSTRAINT [DF_ScreenParts_scpParameters] DEFAULT (0),
[scpTOP] [int] NOT NULL CONSTRAINT [DF_ScreenParts_scpTOP] DEFAULT
(0),
[scpLEFT] [int] NOT NULL CONSTRAINT [DF_ScreenParts_scpLEFT] DEFAULT
(0),
[scpWIDTH] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL CONSTRAINT [DF_ScreenParts_scpWIDTH] DEFAULT (''),
[scpHEIGHT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL CONSTRAINT [DF_ScreenParts_scpHEIGHT] DEFAULT (''),
[scpFreeText] [varchar] (8000) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL CONSTRAINT [DF_ScreenParts_scpFreeText] DEFAULT (''),
[scpIncBefore] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL CONSTRAINT [DF_ScreenParts_scpIncBefore] DEFAULT (''),
[scpIncAfter] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL CONSTRAINT [DF_ScreenParts_scpIncAfter] DEFAULT (''),
[scpOrdinal] [int] NOT NULL CONSTRAINT [DF_ScreenParts_scpOrdinal]
DEFAULT (0),
[scpStatus] [int] NOT NULL CONSTRAINT [DF_ScreenParts_scpStatus]
DEFAULT (1),
[scpExtras] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL CONSTRAINT [DF_ScreenParts_scpExtras] DEFAULT (''),
[scpExtraLngCode] [int] NOT NULL CONSTRAINT
[DF_ScreenParts_scpExtraLngCode] DEFAULT (0),
[scpLastUpdate] [datetime] NOT NULL CONSTRAINT
[DF_ScreenParts_scpLastUpdate] DEFAULT (getdate()),
CONSTRAINT [PK_ScreenParts] PRIMARY KEY NONCLUSTERED
(
[scpCode]
) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO
Expected result:
----------------
Values in all 3 fields
Actual result:
--------------
scpLastUpdate and scpName are empty
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=38834&edit=1
