this is bugging me to no end (no pun intended)... I am getting the error:
invalid query: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'Condition, ConstructType, BldgDimensions, Stories,
CurrentParking, MaxParking, P' at line 1
I cannot find a thing wrong with this... any ideas what may be the
problem? All the data types are either int(11) or varchar(50).
John
INSERT INTO tblBuildings (SiteID, Name, Available, MfgWHSqFt,
OfficeSqFt, TotalSqFt, MinSqFtAvailable, MaxSqFtAvailable, Condition,
ConstructType, BldgDimensions, Stories, CurrentParking, MaxParking,
ParkingSurface, PctOccupied, ClearSpan, CeilingMax, PctAC, PctHeated,
FloorType, Sprinkled, DHDoors, DHSize, GLDoors, GLSize, RRDoors, RRSize,
CraneNum, CraneSize, RefrigSize) VALUES ('', '[enter building name]',
'Y', '', '', '', '', '', '- Select -', '- Select -', '', '', '', '', '-
Select -', '', '', '', '', '', '- Select -', 'Y', '', '', '', '', '',
'', '', '', '')
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
