thats how the original code was...this is from site director3 and its not my code, i have to get in and hack it so that the client can finally have their site up, i cant wait to ftp it to experthost.com to see what issues i have, but that doesnt happen until i get it complete, here on my devbox @ home.
anyway, here is how the code originally read, and the mssql200 data type is most certainly int(4), im fairly good with this thing we call cf, however, this one has me a bit perplexed??? does anyway else use sitedirector 3, tell me what they have experienced this really is starting to get frustrating???? thanks! tony -----Original Message----- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:03 PM To: CF-Talk Subject: Re: cfquery question??? > below is what i can output on the page, first you see > 175, that is the value of url.id, 3 is the len of the string > url.id and you can view, the site at > > http://www.revolutionwebdesign.com/clients/armynavy/site/department.cfm In the error message, it seems to have a problem with the 175. What's the datatype on that id column? Also, have you tried using cfqueryparam to see if MX will cast that value to the appropriate type? Just a couple thoughts. Regards, Dave. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
