Hey, I didn't write this procedure, and to be honest I don't know what it's doing or why it's necessary, can't I just write directly to a text field?
Anyway, can anyone see what's wrong with this? CREATE PROCEDURE SP_Update_Section_Text @Record_ID int, @SectionText text AS -- Write text DECLARE @ptrval binary(16) SELECT @ptrval = TEXTPTR(section_text) FROM Application_Sections Where document_ID [EMAIL PROTECTED] WRITETEXT Application_Sections.Section_text @ptrval @SectionText GO The cf side is easy enough, the record_id is just an @@identity from an insert I just did, and @sectionText is just some user entered text from a textbox. Any help would be very much appreciated. Tim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211607 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
