Tyler, I'm getting this error. It's the same one I've gotten thru this whole process:
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'tblSKUoptions_rel.optionSKUID = tblprod_SKUS.SKUID LEFT OUTER JOIN tblproducts ON tblprod_SKUS.SKU_prodID = tblproducts.prodID LEFT OUTER JOIN tblshiptimes ON tblprod_SKUS.shiptimeID = tblshiptimes.shiptimeID'. Here's the generated SQL: SELECT tblprod_SKUS.SKUID, tblprod_SKUS.merchSKUID, tblprod_SKUS.SKU_prodID, tblprod_SKUS.SKUprice, tblprod_SKUS.SKUsaleprice, tblprod_SKUS.SKUqtyinstock, tblprod_SKUS.shiptimeID, tblshiptimes.shiptimeID, tblshiptimes.shiptimetext, tblSKUoptions_rel.optionID, tblSKUoptions_rel.optionSKUID, tblSKUoptions_rel.option_optionID, tblproducts.prodID, tblproducts.prod_MerchID, tblproducts.prodname FROM tblprod_SKUS LEFT OUTER JOIN tblSKUoptions ON tblSKUoptions_rel.optionSKUID = tblprod_SKUS.SKUID LEFT OUTER JOIN tblproducts ON tblprod_SKUS.SKU_prodID = tblproducts.prodID LEFT OUTER JOIN tblshiptimes ON tblprod_SKUS.shiptimeID = tblshiptimes.shiptimeID WHERE tblprod_SKUS.SKUID = (param 1) And here's my cfquery: <cfquery name="getskuinventory" datasource="#VARIABLES.dsn#"> SELECT tblprod_SKUS.SKUID, tblprod_SKUS.merchSKUID, tblprod_SKUS.SKU_prodID, tblprod_SKUS.SKUprice, tblprod_SKUS.SKUsaleprice, tblprod_SKUS.SKUqtyinstock, tblprod_SKUS.shiptimeID, tblshiptimes.shiptimeID, tblshiptimes.shiptimetext, tblSKUoptions_rel.optionID, tblSKUoptions_rel.optionSKUID, tblSKUoptions_rel.option_optionID, tblproducts.prodID, tblproducts.prod_MerchID, tblproducts.prodname FROM tblprod_SKUS LEFT OUTER JOIN tblSKUoptions ON tblprod_SKUS.SKUID = tblSKUoptions_rel.optionSKUID LEFT OUTER JOIN tblproducts ON tblprod_SKUS.SKU_prodID = tblproducts.prodID LEFT OUTER JOIN tblshiptimes ON tblprod_SKUS.shiptimeID = tblshiptimes.shiptimeID WHERE tblprod_SKUS.SKUID = <cfqueryparam cfsqltype="cf_sql_integer" value="#ARGUMENTS.SKUID#"> </cfquery> Any ideas? Thanks much! Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223401 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
