Home > Chemistry > Error Occurred While Processing Request - Sign up Here
Error Occurred While Processing Request - Sign up Here Albany Spring Service

Title: Error Occurred While Processing Request - Sign up Here - Albany Spring Service

  • Company Name: Albany Spring Service
  • Phone: 800-352-8470
  • Fax:
  • Address: Albany, NY 12207
contact supplier

Verified Supplier

Error Occurred While Processing Request

Error Executing Database 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 ''type=HEAP SELECT state, state_abv FROM sd3_tax_state'' at line 1
 
The error occurred in /home2/albanysp/public_html/sitedirector/site/customer.cfm: line 191
Called from /home2/albanysp/public_html/sitedirector/site/customer.cfm: line 31
Called from /home2/albanysp/public_html/sitedirector/site/customer.cfm: line 21
Called from /home2/albanysp/public_html/sitedirector/site/customer.cfm: line 5
Called from /home2/albanysp/public_html/sitedirector/site/customer.cfm: line 1
Called from /home2/albanysp/public_html/sitedirector/site/customer.cfm: line 191
Called from /home2/albanysp/public_html/sitedirector/site/customer.cfm: line 31
Called from /home2/albanysp/public_html/sitedirector/site/customer.cfm: line 21
Called from /home2/albanysp/public_html/sitedirector/site/customer.cfm: line 5
Called from /home2/albanysp/public_html/sitedirector/site/customer.cfm: line 1
189 : 						<cfif request.dbType Is "mySQL">
190 : 							<cfquery datasource="#request.dsn#" name="getState" username="#request.dbUserName#" password="#request.dbPassword#">
191 : 							   CREATE TEMPORARY TABLE tmp type=HEAP SELECT state, state_abv FROM #request.taxStateTable#
192 : 							</cfquery>
193 : 							<cfquery datasource="#request.dsn#" name="getState" username="#request.dbUserName#" password="#request.dbPassword#">

VENDORERRORCODE   1064
SQLSTATE   42000
SQL    CREATE TEMPORARY TABLE tmp type=HEAP SELECT state, state_abv FROM sd3_tax_state
DATASOURCE   albanyspringDSN
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 2000)
Remote Address   183.44.126.55
Referrer  
Date/Time   06-Mar-15 05:09 PM
VENDORERRORCODE   1064
SQLSTATE   42000
SQL    CREATE TEMPORARY TABLE tmp type=HEAP SELECT state, state_abv FROM sd3_tax_state
DATASOURCE   albanyspringDSN
Browser   Mozilla/4.0 (compatible; MSIE 6.0; Windows 2000)
Remote Address   183.44.126.55
Referrer  
Date/Time   06-Mar-15 05:09 PM
Stack Trace (click to expand)

Info you may be interested

©2014 biziup.com