Don't applaud---Just throw money! :)


>YES!!! I got it.. I set it up to use a recordset object like you said. It works GREAT now!! I am so happy.. Thank you so much for all the help you gave me.. BTW I loved the truegeeks website.. the tree thing with the bottom and side window it NICE! Anyway, Thanks again. I owe you bigtime!! ; )
>
>
>>Joe,
>>I started to address this problem with my last post and decided not to because it is not a SMALL problem. There are two ways of fixing this that we have found.
>>
>>One, if you feel you must stick with sql pass thur, then you will need to dump your use of memo fields. Find how many chars they have entered dived by 256 pull 256 from that number and add one record per until you have inserted all of them. This would be a very ugly work around, but it is doable.
>>
>>Two, switch to record sets. This requires you to change your way of handling data on the asp side. If you need example or more help take a look at our site www.truegeeks.com, you can request full access or just login as a guest to the open source document area. We have several examples of record sets there.
>>
>>HTH
>>Jeff
>>