[ic] Writing Tables in Mysql?

Tom giftbound1 at comcast.net
Tue Dec 30 09:46:38 EST 2003


Im trying to get this to work its located here:
http://www.icdevgroup.org/pipermail/interchange-users/2002-March/019170.html

I made the stock_alert table in mysql but what do I make in interchange to
get this to work? Little confused here.

I made this in interchange called stock_alert.mysql but get a 500 error
Database stock_alert stock_alert.txt  __SQLDSN__
ifdef SQLUSER
Database stock_alert USER         __SQLUSER__
endif
ifdef SQLPASS
Database stock_alert PASS         __SQLPASS__
endif
Database stock_alert DEFAULT_TYPE text


Database stock_alert COLUMN_DEF   "uid=int(11) NOT NULL auto_increment"
Database stock_alert COLUMN_DEF   "sku=varchar(20) NOT NULL default ''"
Database stock_alert COLUMN_DEF   "price=decimal(10,2) NOT NULL default ''"
Database stock_alert COLUMN_DEF   "description=varchar(255) NOT NULL default
''"
Database stock_alert COLUMN_DEF   "author=varchar(255) default NULL"
Database stock_alert COLUMN_DEF   "fname=varchar(255) default NULL"
Database stock_alert COLUMN_DEF   "lname=varchar(255) default NULL"
Database stock_alert COLUMN_DEF   "email=varchar(255) NOT NULL default ''"
Database stock_alert COLUMN_DEF   "date=date NOT NULL default '0000-00-00'"

What else do I have to do?



More information about the interchange-users mailing list