I am not familiar with SQL Server 2005, but I know 2000 will throw
errors like that when the length of what you are inserting is greater
than the field length you are inserting into.
Either, change the length of the field in the table schema, or use
<@left > to limit the <@arg> on the insert to make sure it is not
more than the length of the table field.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Dec 2, 2006, at 9:35 AM, Jason Pamental wrote:
Hi all-
I've read through lots of posts about inserting BLOBs, but am
hitting snags trying it out for the first time.
I'd like to use the varbinary(max) data type in SQL Server 2005 so
I can create a full-text index on the files in the system, but when
I try to insert the file (an @arg from a form) I get an error
(String truncation right). Am I missing a step - do I need to do a
conversion on the postarg to binary prior to insert?
Any ideas would be most welcome. My goal is to convert from a
filesystem based storage method for an intranet to a DB-based one.
Thanks-
Jason
-----
Jason Pamental
Director of Web Services
North Sails
Office: 401.643.1415
Fax: 401.643.1420
Mobile: 401.743.4406
Email: [EMAIL PROTECTED]
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
