[Zope-DB] data type problems ZMySQLDA

Alex Cowan alex@funcom.com
Sun, 30 Mar 2003 13:22:58 +0100


You may also have a problem with the column name date since thats also a
reserved word in mysql. You might get away with it but you'll probably have
other problems later.

I tend to use datetime columns as well since they are easier to read from
the db itself (no extra formatting required).

Alex

----- Original Message -----
From: "Michele Marcionelli" <michele@math.ethz.ch>
To: "Josiah Peters" <halo_maniac@hotmail.com>; <zope-db@zope.org>
Sent: Saturday, March 29, 2003 11:33 PM
Subject: Re: [Zope-DB] data type problems ZMySQLDA


> Hello Joey!
>
> The correct syntax is:
>
> CREATE TABLE ezine_news (
>     author varchar(x),
>     name varchar(x),
>     content text,
>     date timestamp
> );
>
> where "x" is the maximal length of the value, in this case "author" and
> "name", usually x=255. I think that x can be an integer from 1 to 255.
>
> Cheers,
> Michele
>
> ----- Original Message -----
> From: "Josiah Peters" <halo_maniac@hotmail.com>
> To: <zope-db@zope.org>
> Sent: Saturday, March 29, 2003 5:13 PM
> Subject: [Zope-DB] data type problems ZMySQLDA
>
>
> > I have been searching around and have not been able to find any
reference
> > information on ZmysqlDA. For some reason when i enter the query:
> >
> > CREATE TABLE ezine_news
> > (
> > author varchar,
> > name varchar,
> > content text,
> > date timestamp,
> > )
> >
> > it will not accept it as a legal query making me unable to finish my
> > database stuff. Since I only have experience with MySQL and those
commands
> > do not seem to be working.
> >
> > thanks in advance.
> >
> > Joey Peters
> >
> > _________________________________________________________________
> > Add photos to your messages with MSN 8. Get 2 months FREE*.
> > http://join.msn.com/?page=features/featuredemail
> >
> >
> > _______________________________________________
> > Zope-DB mailing list
> > Zope-DB@zope.org
> > http://mail.zope.org/mailman/listinfo/zope-db
> >
>
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://mail.zope.org/mailman/listinfo/zope-db
>