Hi, i'm new at cakephp, and i've a problem with MSSQL and created/modified fields
I did the blog example in mysql without problems. Now, i try to do the same in mssql server and it doesn't work properly. I created the table: CREATE TABLE [enqDocencia].[posts]( [id] [int] IDENTITY(1,1) NOT NULL, [title] [varchar](50) NULL, [body] [text] NULL, [created] [datetime] NULL, [modified] [datetime] NULL, CONSTRAINT [PK__posts__3213E83F1CF15040] PRIMARY KEY CLUSTERED ) ALTER TABLE [enqDocencia].[posts] ADD CONSTRAINT [DF__posts__created__1ED998B2] DEFAULT (NULL) FOR [created] GO ALTER TABLE [enqDocencia].[posts] ADD CONSTRAINT [DF__posts__modified__1FCDBCEB] DEFAULT (NULL) FOR [modified] GO as you can see, i added created and modified fields the problem is that, when i try to add a "blog entry" in cakephp, it returns me this error: *Error: * SQLSTATE[22007]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting date and/or time from character string. *SQL Query: * INSERT INTO [posts] ([created], [modified], [title], [body]) VALUES ('NULL', 'NULL', N'title_ex', N'body post text') *Notice: * If you want to customize this error message, create cakephptest\View\Errors\pdo_error.ctp as you can see, this SQL sentence has two errors: - first, it try tu put 'null' value at 'created' field, but it should be getdate() (current timestamp) - also, it put NULL inside two character ' ' ; then for mssql, is a "string", not NULL value (it should be without ' ' ) i'm very confused, what can I do? I'm doing something wrong? Thanks, -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en.