Monday, August 3, 2009

is there a workaround for using sql server function getdate()?

Hi,

I'm using Sql Server as my database and have some fields with datetime
data types and default values to call the getdate function. I know
this causes an error because the sql generated is:

Query: INSERT INTO [groups] ([created], [modified], [name]) VALUES
('getdate(', 'getdate(', 'administrators')

As you can see the parser doesn't know what to do with the getdate
function. Is there a workaround for this or should I just handle the
datetime fields manually?

Thanks,
Jason

--~--~---------~--~----~------------~-------~--~----~
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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

No comments: