Extend your check to include URL.category_id in addition to FORM.category_id. The spider is probably passing "moreinfo.cfm" in the URL.
On 8/18/07, NUGROHO NOTO <[EMAIL PROTECTED]> wrote: > > 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:286554 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
