Thanks Dean, That was just a typo on my part, the actual code I've been testing with has the quote after it. Looking at the SQL code in the error message those strings seem to encrypt fine as well.
Thanks for any further ideas guys, Rob -----Original Message----- From: Dean Lawrence [mailto:[EMAIL PROTECTED] Sent: 15 June 2007 13:52 To: CF-Talk Subject: Re: Error converting data type varchar to int. On 6/15/07, Robert Rawlins - Think Blue <[EMAIL PROTECTED]> wrote: > > <cfset VARIABLES.DAO.create(1, 'TestUser, 'TestPassword') /> > Rob, I don't know if this was just your typing into the email, but in the above statement you did not place a closing quote after the second value. So instead it should read <cfset VARIABLES.DAO.create(1, 'TestUser', 'TestPassword') /> Dean -- __________________________________________ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281282 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4