Cold Fusion Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsProgrammingCold Fusion Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old August 7th, 2006, 01:07 PM
MightyMikey MightyMikey is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2006
Posts: 1 MightyMikey User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 m 19 sec
Reputation Power: 0
Whats Wrong with this Query? Help!-Debugging Info enclosed

Whats wrong with this insert query?....
It is going into a MSAccess database and all the fields are not required and they're all text feilds.
HELP!


Code:
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   http://127.0.0.1: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=http://127.0.0.1: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
 

Reply With Quote
  #2  
Old November 5th, 2006, 05:49 PM
ColdFusion ColdFusion is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Nov 2006
Posts: 1 ColdFusion User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 m 10 sec
Reputation Power: 0
Chances are that one of your form items has a quote in it. Use CFQUERYPARAM to try and avoid these types of problems.

Quote:
Originally Posted by MightyMikey
Whats wrong with this insert query?....
It is going into a MSAccess database and all the fields are not required and they're all text feilds.
HELP!


Code:
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
 

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingCold Fusion Development > Whats Wrong with this Query? Help!-Debugging Info enclosed


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap