I have never admin'ed a database before, this is tough...
I have created:
and ran the generate command successfully.
here is the error when i run the mysql < Create.sql command:
ERROR 1064 at line 32: You have an error in your SQL syntax near 'To (
toId int not null primary key
auto_increment,' at line 1
Should I not have used "To" as my class name? I forgot to try
changing that last nite before giving up.
Included are Classes.csv and Create.sql
some of these fields will change, but i would like to understand
what went wrong with this one.
At 02:02 PM 4/17/2001 -0700, Jeff Schneiter wrote:
>I have never admin'ed a database before, this is tough...
I'm guessing "To" is your problem as you guessed. Can you try another class
name and let us know?
BTW MySQL and most other databases allow quoting of identifiers to avoid
collisions with SQL reserved words, however, MiddleKit does not yet perform
At 02:23 PM 4/17/2001 -0700, Jeff Schneiter wrote:
>My design will change, i need a "datetime" field,
>and would like a "text" field, because st_msg is
>variable length. how to do those?
datetime is datetime. You'll probably want to grab mxDateTime if you
haven't already, although you can certainly use strings if that's all you
need. MK handles both scenarious.
You get a 'text' if your string is long enough to warrant one. So if you
expect the string can get up to 100,000 characters, then say so in the Max
column and MK will pick the right SQL type for you.
(I reviewed the User's Guide and it doesn't point this out. I will add that
Also, be sure to use the MK from Webware CVS. We have made some fixes and
refinements since the last release.
Feel free to keep asking MK questions.
On Tue, Apr 17, 2001 at 02:02:16PM -0700, Jeff Schneiter wrote:
> ERROR 1064 at line 32: You have an error in your SQL syntax near 'To (
> toId int not null primary key
> auto_increment,' at line 1
> Should I not have used "To" as my class name?
Yes, "to" is a reserved word in MySQL.
A list of words illegal in table names and column names is at:
-Mike (Iron) Orr, iron@... (if mail problems: mso@...)
http://mso.oz.net/ English * Esperanto * Russkiy * Deutsch * Espan~ol