[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