Error Diagnostic Information Error 3700

[tbanksjr]

I have tried for several days to fix this problem which appears to have happened all of a sudden. Please help.
There is no coding that refers to NULL 9. I beleive that is where the problem lies or am I way off.

Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)


[Microsoft][ODBC Microsoft Access Driver] Syntax error
(missing operator) in query expression 'NULL 9'.


SQL = "insert into properties(id, flash, areaid, bookid,
propertyname, addr1, addr2, city, state, postalcode, phone,
fax, web, email, Hoursdesc, near, header, directions,
managementid, MinRent, MaxRent, ZeroBedMin, ZeroBedMax,
OneBedMin, OneBedMax, TwoBedMin, TwoBedMax, ThreeBedMin,
ThreeBedMax, FourBedMin, FourBedMax, zerobed, onebed,
twobed, threebed, fourbed, FlrPlan1, size1,
price1,FlrPlan2, size2, price2,FlrPlan3, size3,
price3,FlrPlan4, size4, price4,FlrPlan5, size5,
price5,FlrPlan6, size6, price6,
furnished,shortterm,military,wd,wdhookup,laundryroom,fitness
center,businesscenter,clubhouse,pool,tenniscourts,security,b
usline,garage,coveredparking,fireplace,handicapaccess,gaspai
d,waterpaid, feature1, feature2, feature3, feature4,
feature5, feature6, feature7, feature8, feature9,
feature10, feature11, feature12, feature13, feature14,
feature15, feature16, feature17, feature18, feature19,
feature20, pets, inactive, reset) values(540, NULL 9 ,
1, 'test' , NULL , NULL , NULL , NULL , NULL , NULL ,
NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL ,
100000000 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 ,
0 , 0 , 0 , 0 , NULL , NULL , NULL , NULL , NULL , NULL ,
NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL ,
NULL , NULL , NULL , NULL , 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, NULL , NULL , NULL , NULL ,
NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL ,
NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL ,
NULL , 0 , '01/10/2003 10:19 AM' )"


Data Source = "APARTMENT"


The error occurred while processing an element with a
general identifier of (CFQUERY), occupying document
position (118:1) to (118:39) in the template file
D:\

http://WWWROOT\APARTMENTSOURCE.COM\ADMIN\PROPERTY.CFM.