PDA

Click to See Complete Forum and Search --> : ADO & SQLserver text fields


aclmtd
Oct 18th, 2000, 02:12 PM
Could any body advise on the best way to update a text field on SQL server via the ADO command object and a stored proc. The amount of data exceeds 8000 chars so varchar can not be used. I have tried LongVarChar but still no good. I am trying to do this from VBscript within an asp page. The command object only has a limited number of variable types and text is not one of them!