I just installed it. Sorry I didn't research the list further. I do have
another question on the tutorial. I tried running these sql create statements
and they didn't work. I got 2 errors. I wonder why?
1
SQL query:
CREATE TABLE posts(
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY ,
title VARCHAR( 50 ) ,
body TEXT,
created DATETIME DEFAULT NOT NULL ,
modified DATETIME DEFAULT NOT NULL )
MySQL said: #1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'NOT NULL,
modified DATETIME DEFAULT NOT NULL
)' at line 5
2
SQL query:
1INSERT INTO posts( title, body, created ) VALUES (
'Title strikes back', 'This is really exciting Not.', NOW( ) );
MySQL said: #1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '1INSERT INTO posts (title,body,created)
VALUES ('Title strikes back', 'This ' at line 1
here is the query i didn't run it with the numbers. The first error I got rid
of was the word default on line 6. Why can't the default be not null?:
1. /* First, create our posts table: */
2. CREATE TABLE posts (
3. id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
4. title VARCHAR(50),
5. body TEXT,
6. created DATETIME DEFAULT NOT NULL,
7. modified DATETIME DEFAULT NOT NULL
8. );
9. /* Then insert some posts for testing: */
10. INSERT INTO posts (title,body,created)
11. VALUES ('The title', 'This is the post body.', NOW());
12. INSERT INTO posts (title,body,created)
13. VALUES ('A title once again', 'And the post body follows.', NOW());
14. INSERT INTO posts (title,body,created)
15. VALUES ('Title strikes back', 'This is really exciting! Not.',
NOW());This might be a mysql question but I'm trying to get the cake php
tutorial to work.
----- Original Message ----
From: Gabriel Kolbe <[EMAIL PROTECTED]>
To: [email protected]
Sent: Thursday, October 9, 2008 2:55:42 AM
Subject: Re: newbie question
I user Xampp, and it works like a dream !!
On Thu, Oct 9, 2008 at 4:09 AM, <[EMAIL PROTECTED]> wrote:
>
> I think it may be best if you use a real server!
>
> On 10/08/2008, JRough <[EMAIL PROTECTED]> wrote:
>>
>> I want to try out Cakephp. Do you know if I can use it with XXAMP on
>> Windows just for testing or do I have to install it on a real server?
>>
>> thanks,
>>
>> >
>>
>
>
> --
> Xavier A. Mathews
> Student/Developer/Web-Master
> GG Client Based Tech Support Specialist
> Hazel Crest Illinois
> [EMAIL PROTECTED]
> "Fear of a name, only increases fear of the thing itself."
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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
-~----------~----~----~----~------~----~------~--~---
