Hi all!
In reply to an old thread that I found (couldn´t answer there, just
send it to the author?).
I think this could help others running CakePHP against SQL Server
2000:
I know that this thread is quite old, but I just had the same problem
on Windows Server 2003 and SQL Server 2000.
Create new and editing works fine, but the columns created and
modified in the database stay empty.
Couldn´t find any solution in the manual or the group.
After some trying I got it to work, the solution is to change the
datatype from "datetime" to "varchar" in the tables (only for SQL
Server 2000).
Hope this helps somebody..
Fire
On 9 Aug. 2006, 16:34, "Santo Bartez" <[EMAIL PROTECTED]> wrote:
> I've managed to installed CakePHP (1.1.7.3363) on Windows 2000, SQL
> Server 2000, and IIS (w/ISAPI_Rewrite). I've followed the tutorial
> located here grahambird.co.uk/cake/tutorials/scaffolding.php.
>
> I can list and insert and edit entries into the bookmarks with one
> exception. Thecreated/modifieddate fields never insert or update. The
> fields also display as editable fields when editing or inserting an
> entry. If I manually enter values into those fields through the
> scaffold insert/edit form, it updates the table properly.
>
> I'm confused on this behavior and a little lost. I've searched through
> trac.cakephp.org and wiki.cakephp.org and couldn't find anything that
> addressed this issue.
>
> Here's the table:
> CREATE TABLE [bookmarks] {
> [id] [int] IDENTITY (1,1) NOT NULL,
> [name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
> [url] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
> [created] [datetime] NULL,
> [modified] [datetime] NULL,
> CONSTRAINT [PK_bookmarks_6E565CE8] PRIMARY KEY CLUSTERED
> {
> [id]
> } ON [PRIMARY]
>
> } ON [PRIMARY]
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
