Thanks Todd. :) I figured it out -- it was just me being silly -- I've got this script that grabs data to build a sql create table script with from the system and information_schema tables in sql server and I was using that data to create <cfqueryparam> tags to go in a cfm page for a batch ( cause bcp probably won't be able to read from the sql server ) and I was using cf_sql_varchar for all the string data types... so using cf_sql_longvarchar for ntext fields fixed it. :)
fyi. varchar in sql server 2000 has a max length of 8000. Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > I would imagine 255 since that's the highest VARCHAR can > go. > At 07:48 PM 10/6/2002 -0400, you wrote: >>Anybody know if there's an upper limit to the length of >>values passed to sql >>server using <cfqueryparam cfsqltype="cf_sql_varchar">? >> >>Isaac >>Certified Advanced ColdFusion 5 Developer >> >>www.turnkey.to >>954-776-0046 >> >> >>Isaac Dealey >>Certified Advanced ColdFusion 5 Developer >> >>new epoch >>www.turnkey.to >>954-776-0046 >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~| > Archives: > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > Subscription: http://www.houseoffusion.com/index.cfm?sideb > ar=lists&body=lists/cf_talk > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Get the mailserver that powers this list at > http://www.coolfusion.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
