Whats Wrong with this Query? Help!-Debugging Info enclosed

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator. 

The following information is meant for the website developer for debugging purposes.  

Error Occurred While Processing Request  
Error Executing Database Query.  
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.  
  
The error occurred in C:\CFusionMX7\wwwroot\logistics\techcheckprocess.c  fm: line 210
 
208 : 		'#form.eq_elechook_loc#',
209 : 		'#form.eq_plant_quant#',
210 : 		'#form.eq_plant_loc#')
211 : </cfquery>
212 : 

 

--------------------------------------------------------------------------------
 
SQL    insert into logistics(event, coordinator, dateofevent, setdatetime, teardatetime, miclapelquant, miclapelloc, michandquant, michandloc, micstandquant, micstandloc, poditabletopquant, poditabletoploc, podistandlgquant, podistandlgloc, podistandquant, podistandsmloc, laptoppcquant, laptoppcloc, laptopmacquant, laptopmacloc, printerbwquant, printerbwloc, printercolorquant, printercolorloc, projbackquant, projbackloc, screenquant, screenloc, projectorquant, projectorloc, videqdvdquant, videqdvdloc, videqvcrquant, videqvcrloc, videqother, videqotherquant, videqotherloc, internetlinequant, internetlineloc, phonelinequant, phonelineloc, lampquant, lamploc, podilightquant, podilightloc, extcordquant, extcordloc, vidconfquant, vidconfloc, webcastquant, webcastloc, other1, other1quant, other1loc, other2, other2quant, other2loc, other3, other3quant, other3loc, stageloc, stagesize, stagetablequant, stagetableplace, stagechairquant, stagechairplace, stageotherquant, stageotherplace, table5roundquant, table5roundloc, table6roundquant, table6roundloc, table8rectanglequant, table8rectangleloc, table6rectanglequant table6rectangleloc, tablecocktailquant, tablecocktailloc, chairfoldingquant, chairfoldingloc, chairfabricquant, chairfabricloc, chaircoversquant chaircoversloc, tablelinenquant, tablelinenloc, trashsmallquant, trashsmallloc, trashlargequant, trashlargeloc, easelquant, easelloc, tent10x10quant, tent10x10loc, tent20x20quant, tent20x20loc, eqstagequant, eqstageloc, electricoutletsquant, electricoutletsloc, plantquant, plantloc) values('a', 'a', 'a', 'a', 'a', '5', 'a', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '5', 'a')  
DATASOURCE   logcheck 
VENDORERRORCODE   -3502 
SQLSTATE   42000 
 
Resources: 
Check the ColdFusion documentation to verify that you are using the correct syntax. 
Search the Knowledge Base to find a solution to your problem. 

 
Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727) 
Remote Address   127.0.0.1 
Referrer   (URL address blocked: See forums rules):8501/logistics/techcheck.cfm 
Date/Time   07-Aug-06 12:25 PM 
 

--------------------------------------------------------------------------------
Debugging Information ColdFusion Server Developer 7,0,1,116466 
Template  /logistics/techcheckprocess.cfm 
Time Stamp  07-Aug-06 12:25 PM 
Locale  English (US) 
User Agent  Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727) 
Remote IP  127.0.0.1 
Host Name  localhost 




--------------------------------------------------------------------------------
Execution Time

Total Time Avg Time Count Template 
31 ms 31 ms 1 C:\CFusionMX7\wwwroot\logistics\techcheckprocess.c  fm 
109 ms   STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN 
140 ms   TOTAL EXECUTION TIME 
red = over 250 ms average execution time 


--------------------------------------------------------------------------------
Exceptions

12:25:23.023 - Database Exception - in C:\CFusionMX7\wwwroot\logistics\techcheckprocess.c  fm : line 210
	    Error Executing Database Query.
	    


--------------------------------------------------------------------------------
Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\CFusionMX7\wwwroot\logistics\t  echcheckprocess.cfm
CONTENT_LENGTH=1625
CONTENT_TYPE=application/x-www-form-urlencoded
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFADMIN_LASTPAGE=%2FCFIDE%2Fadministra  tor%2Fdatasources%2Findex%2Ecfm
HTTP_HOST=127.0.0.1:8501
HTTP_REFERER=(URL address blocked: See forums rules):8501/logistics/techcheck.cfm
HTTP_USER_AGENT=Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
PATH_INFO=
PATH_TRANSLATED=C:\CFusionMX7\wwwroot\logistics\te  chcheckprocess.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=localhost
REMOTE_USER=
REQUEST_METHOD=POST
SCRIPT_NAME=/logistics/techcheckprocess.cfm
SERVER_NAME=127.0.0.1
SERVER_PORT=8501
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=
WEB_SERVER_API=

Cookie Variables:
CFADMIN_LASTPAGE=/CFIDE/administrator/datasources/index.cfm

Form Fields:
BGCOORDINATOR=a
BGDATEEVENT=a
BGEVENT=a
BGSETUPDATE=a
BGTEARDOWNDATE=a
EQ_CHACOVER_LOC=
EQ_CHACOVER_QUANT=
EQ_CHAFAB_LOC=
EQ_CHAFAB_QUANT=
EQ_CHAFOLD_LOC=
EQ_CHAFOLD_QUANT=
EQ_EASEL_LOC=
EQ_EASEL_QUANT=
EQ_ELECHOOK_LOC=
EQ_ELECHOOK_QUANT=
EQ_PLANT_LOC=a
EQ_PLANT_QUANT=5
EQ_STAGE_LOC=
EQ_STAGE_QUANT=
EQ_TAB5RO_LOC=
EQ_TAB5RO_QUANT=
EQ_TAB6REC_LOC=
EQ_TAB6REC_QUANT=
EQ_TAB6RO_LOC=
EQ_TAB6RO_QUANT=
EQ_TAB8REC_LOC=
EQ_TAB8REC_QUANT=
EQ_TABCOC_LOC=
EQ_TABCOC_QUANT=
EQ_TABLELINE_LOC=
EQ_TABLELINE_QUANT=
EQ_TENT10X10_LOC=
EQ_TENT10X10_QUANT=
EQ_TENT20X20_LOC=
EQ_TENT20X20_QUANT=
EQ_TRASHLG_LOC=
EQ_TRASHLG_QUANT=
EQ_TRASHSM_LOC=
EQ_TRASHSM_QUANT=
EXTCORD_LOC=
EXTCORD_QUANT=
FIELDNAMES=BGEVENT,BGCOORDINATOR,BGDATEEVENT,BGSET  UPDATE,BGTEARDOWNDATE,MIC_LAPEL_QUANT,MIC_LAPEL_LO  C,MIC_HAND_QUANT,MIC_HAND_LOC,MIC_STAND_QUANT,MIC_  STAND_LOC,PODI_TABLETOP_QUANT,PODI_TABLE_LOC,PODI_  STANDLG_QUANT,PODI_STANDLG_LOC,PODI_STANDSM_QUANT,  PODI_STANDSM_LOC,LAPTOP_PC_QUANT,LAPTOP_PC_LOC,LAP  TOP_MAC_QUANT,LAPTOP_MAC_LOC,PRINT_BNW_QUANT,PRINT  _BNW_LOC,PRINT_COLOR_QUANT,PRINT_COLOR_LOC,PROJ_BA  CK_QUANT,PROJ_BACK_LOC,SCREEN_QUANT,SCREEN_LOC,PRO  J_QUANT,PROJ_LOC,VIDEO_DVD_QUANT,VIDEO_DVD_LOC,VID  EO_VCR_QUANT,VIDEO_VCR_LOC,VIDEO_OTHER,VIDEO_OTHER  _QUANT,VIDEO_OTHER_LOC,INTERNET_QUANT,INTERNET_LOC  ,PHONE_QUANT,PHONE_LOC,LAMP_QUANT,LAMP_LOC,PODILIG  HT_QUANT,PODILIGHT_LOC,EXTCORD_QUANT,EXTCORD_LOC,V  IDCONF_QUANT,VIDCONF_LOC,WEBCAST_QUANT,WEBCAST_LOC  ,OTHER1,OTHER1_QUANT,OTHER1_LOC,OTHER2,OTHER2_QUAN  T,OTHER2_LOC,OTHER3,OTHER3_QUANT,OTHER3_LOC,STAGEL  OC,STAGESIZE,STAGE_TABLE_QUANT,STAGE_TABLE_PLACE,S  TAGE_CHAIR_QUANT,STAGE_CHAIR_PLACE,STAGE_OTHER_QUA  NT,STAGE_OTHER_PLACE,EQ_TAB5RO_QUANT,EQ_TAB5RO_LOC  ,EQ_TAB6RO_QUANT,EQ_TAB6RO_LOC,EQ_TAB8REC_QUANT,EQ  _TAB8REC_LOC,EQ_TAB6REC_QUANT,EQ_TAB6REC_LOC,EQ_TA  BCOC_QUANT,EQ_TABCOC_LOC,EQ_CHAFOLD_QUANT,EQ_CHAFO  LD_LOC,EQ_CHAFAB_QUANT,EQ_CHAFAB_LOC,EQ_CHACOVER_Q  UANT,EQ_CHACOVER_LOC,EQ_TABLELINE_QUANT,EQ_TABLELI  NE_LOC,EQ_TRASHSM_QUANT,EQ_TRASHSM_LOC,EQ_TRASHLG_  QUANT,EQ_TRASHLG_LOC,EQ_EASEL_QUANT,EQ_EASEL_LOC,E  Q_TENT10X10_QUANT,EQ_TENT10X10_LOC,EQ_TENT20X20_QU  ANT,EQ_TENT20X20_LOC,EQ_STAGE_QUANT,EQ_STAGE_LOC,E  Q_ELECHOOK_QUANT,EQ_ELECHOOK_LOC,EQ_PLANT_QUANT,EQ  _PLANT_LOC,SUBMIT
INTERNET_LOC=
INTERNET_QUANT=
LAMP_LOC=
LAMP_QUANT=
LAPTOP_MAC_LOC=
LAPTOP_MAC_QUANT=
LAPTOP_PC_LOC=
LAPTOP_PC_QUANT=
MIC_HAND_LOC=
MIC_HAND_QUANT=
MIC_LAPEL_LOC=a
MIC_LAPEL_QUANT=5
MIC_STAND_LOC=
MIC_STAND_QUANT=
OTHER1=
OTHER1_LOC=
OTHER1_QUANT=
OTHER2=
OTHER2_LOC=
OTHER2_QUANT=
OTHER3=
OTHER3_LOC=
OTHER3_QUANT=
PHONE_LOC=
PHONE_QUANT=
PODILIGHT_LOC=
PODILIGHT_QUANT=
PODI_STANDLG_LOC=
PODI_STANDLG_QUANT=
PODI_STANDSM_LOC=
PODI_STANDSM_QUANT=
PODI_TABLETOP_QUANT=
PODI_TABLE_LOC=
PRINT_BNW_LOC=
PRINT_BNW_QUANT=
PRINT_COLOR_LOC=
PRINT_COLOR_QUANT=
PROJ_BACK_LOC=
PROJ_BACK_QUANT=
PROJ_LOC=
PROJ_QUANT=
SCREEN_LOC=
SCREEN_QUANT=
STAGELOC=
STAGESIZE=
STAGE_CHAIR_PLACE=
STAGE_CHAIR_QUANT=
STAGE_OTHER_PLACE=
STAGE_OTHER_QUANT=
STAGE_TABLE_PLACE=
STAGE_TABLE_QUANT=
SUBMIT=Submit
VIDCONF_LOC=
VIDCONF_QUANT=
VIDEO_DVD_LOC=
VIDEO_DVD_QUANT=
VIDEO_OTHER=
VIDEO_OTHER_LOC=
VIDEO_OTHER_QUANT=
VIDEO_VCR_LOC=
VIDEO_VCR_QUANT=
WEBCAST_LOC=
WEBCAST_QUANT=

Debug Rendering Time: 78 ms