http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-25T05:31:07 en-us http://livedocs.adobe.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/Variables6.htm#21972 ColdFusion provides the InputBaseN and Val functions for converting strings<br>to integers. For more information, see:<br>http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funct119.htm#wp1224918 <br><br>If you are unable to resolve your problem using those functions, I recommend <br>that you post your issue to the online forums: http://webforums.macromedia.com/coldfusion/. <br>If you believe that your issue might result from a ColdFusion bug, you should also submit <br>a bug report on the Macromedia Feature Request/Bug Report Form. extdw_doc 1 0 2004-10-05T11:10:14 http://livedocs.adobe.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/Variables6.htm#21913 Hi,<br />can anybody help me out with convering a string to int? what function shall i use for this? I am taking a string value in a form and using it in a query it gives me the following error.<br /><br />Error Executing Database Query. <br />Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed. Use the CONVERT function to run this query. <br /> <br />The error occurred in C:\txweb\NS_IT\webform\form.cfm: line 9<br /> <br />7 : WHERE membno = '#form.membno#'<br />8 : AND provno = #form.provno#<br />9 : AND svcdat BETWEEN #form.svcdatfrom# AND #form.svcdatto#<br />10 : AND statcd = 'P'<br />11 : </cfquery><br /><br /> thanks,<br />vakula MANIKONDA 0 0 2004-10-04T09:27:51