Lately... I got many error message in my application log (CF administrator)
--------------------------------------------------------------------- ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'moreinfo' does not match with a table name or alias name used in the query. SQL = "SELECT * FROM Categories WHERE Category_ID = moreinfo.cfm 122.152.140.207, Baiduspider+(+http://www.baidu.com/search/spider_jp.html), ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'moreinfo' does not match with a table name or alias name used in the query.The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (43:1) to (43:112).Date/Time: 08/17/07 19:58:02Browser: Baiduspider+(+http://www.baidu.com/search/spider_jp.html)Remote Address: 122.152.140.207Query String: Product_ID=4239&CFID=620487&CFTOKEN=53082176 -------------------------------------------------------------------- My query script is like this ... <cfif isDefined("Form.Category_ID")> <cfset Category = Val(Form.Category_ID)> <cfelseif isDefined("URL.Category")> <cfset Category = Val(URL.Category)> <!--- Used for search engines ---> <cfelseif isDefined("CGI.path_info") AND Compare(CGI.path_info, CGI.Script_Name)> <CFSET checkcat = Replace(CGI.path_info, CGI.SCRIPT_NAME, "", "all")> <cfset Category = Right(checkcat, Len(checkcat)-1)> <cfelse> <cfoutput><b>A category ID must be entered! </b></cfoutput> <cfabort> </cfif> So... if the category id is not numeric... it will return value as 0 but... how come I got many error like above? I got it every 1 min interval. Sorry if those question is too simple... I am a beginner. Any idea would be appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286546 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
