Re: [phpesp-dev] mssql support

[Matthew G. <mat...@gm...>]

I wouldn't be against a proper patch that made the change.

On Wed, 2008-06-18 at 15:43 -0700, Joel Penner (Volt) wrote:
> I’m looking into helping the project’s mssql (sql server) support and
> found that the adodb data dictionary doesn’t quote reserved words.
> What’s the chances of changing a field name for better database
> compatibility? 
> 
>  
> 
> CREATE TABLE phpesp_question (
> 
> id                       INT IDENTITY(1,1) NOT NULL,
> 
> survey_id                INT NOT NULL,
> 
> name                     VARCHAR(30) NOT NULL,
> 
> type_id                  INT NOT NULL,
> 
> result_id                INT NULL,
> 
> length                   INT DEFAULT 0 NOT NULL,
> 
> precise                  INT DEFAULT 0 NOT NULL,
> 
> position                 INT NOT NULL,
> 
> content                  TEXT NULL,
> 
> required                 VARCHAR(1) DEFAULT 'N' NOT NULL,
> 
> deleted                  VARCHAR(1) DEFAULT 'N' NOT NULL,
> 
> public                   VARCHAR(1) DEFAULT 'Y' NOT NULL,
> 
> ans_uniq                 VARCHAR(1) DEFAULT 'N' NOT NULL,
> 
>                  PRIMARY KEY (id)
> 
> )
> 
>  
> 
>  
> 
> SQLState: 42000 Error Code: 156 Message: [Microsoft][SQL Native
> Client][SQL Server]Incorrect syntax near the keyword 'public'.
> 
>  
> 
>  
> 
> Joel Penner
> 
> Volt
> 
> Microsoft Open Source Software Lab
> 
>  
> 
> 
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________ phpESP-devel mailing list php...@li... https://lists.sourceforge.net/lists/listinfo/phpesp-devel
-- 
Matthew Gregg <mat...@gm...>