I could not get the BLOB to insert directly from an ARG. I transfer the file to the server to a temp filename and then insert the file after it is on the server.
Troy Sosamon ===== Original Message from [EMAIL PROTECTED] at 10/22/02 5:56 pm >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
