Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Error Found!

View all replies to this thread

Error Found!

Thread began 12/07/2014 5:45 pm by Kumel | Last modified 12/23/2014 2:55 pm by Kumel | 1431 views | 34 replies

12/23/2014 1:50 pmJason ByrnesWebAssist

heres a basic products table.

CREATE TABLE `Products` (
  `ProductID` int(11) NOT NULL AUTO_INCREMENT,
  `ProductSKU` varchar(50) DEFAULT NULL,
  `ProductName` varchar(100) NOT NULL,
  `ProductPrice` float(12,2) NOT NULL,
  `ProductShipping` float(12,2) DEFAULT NULL,
  `ProductWeight` float(12,2) DEFAULT NULL,
  `ProductCartDesc` varchar(250) DEFAULT NULL,
  `ProductShortDesc` varchar(1000) DEFAULT NULL,
  `ProductLongDesc` text,
  `ProductThumb` varchar(100) NOT NULL,
  `ProductImage` varchar(100) NOT NULL,
  PRIMARY KEY (`ProductID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.