Thanks for the response, Ben. The reason that I am using a text datatype in which to store the Word document is that I read in the MS SQL 2000 documentation that the image, text, and ntext datatypes are the "Natural" BLOB data types for objects larger than 8000. The documentation also states that these datatypes can be used to store .doc, .xls, .ppt and .txt-type objects. Am I missing something here?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-witango-talk@;witango.com]On Behalf Of Ben Johansen Sent: Tuesday, October 22, 2002 4:57 PM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Inserting a large text file into a table CORRECTED Ok, If you are reading the file in through a File Action, Then the file is a blob (binary large object) And you would have been better off setting the field resumeText to varbinary type .DOC files contain not only the text but formatting and possibly graphics, there for it is not just text and thus the error If you save the file as .TXT then you should be able to read it in and insert into the TEXT field. Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-witango-talk@;witango.com] On Behalf Of Peter Fogg Sent: Tuesday, October 22, 2002 4:46 PM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Inserting a large text file into a table CORRECTED I am trying to insert a Word .doc file into the t_resume table. The fields in the table are: recordID Identity personID int resumeText text fileType char 4 The data is: <@ARG personID> = 123 <@ARG resumeTest> is a Word document <@ARG fileType> = .doc ( a one pare resume ) The following direct DBMS code: INSERT INTO dbo.t_resumes VALUES (<@ARG personID>, '<@ARG resumeText>', '<@ARG fileType>') results in the following error: File: resumeInImageDataType.taf Position: Direct_DBMS Class: DBMS Main Error Number: 105 [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string '��ࡱ�'. 37000. What am I doing wrong? [EMAIL PROTECTED] ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
