I agree this is MsSQL throwing the error,
but the issue is if the size is over 8k MsSQL is going to treat it as
an Image and boy are Image types a real pain to work with. IMHO
Ben
On Dec 2, 2006, at 12:12 PM, Robert Shubert wrote:
Isn’t SQL the app throwing the error? I don’t think this is a Witango
error, unless the SQL is not being properly created/handled. Still,
since I’m on 2000 I would use a column type of TEXT, is varbinary
(max) a pseudonym? Oh and can you simply put varbinary(10000000000)?
From: Jason Pamental [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 02, 2006 1:30 PM
To: [email protected]
Subject: SPAM:Re: Witango-Talk: SQL Server 2005 / varbinary(max) /
Witango
Thanks Robert - I'm wondering if there is some sort of issue with the
varbinary(max) datatype in SQL Server 2005. That's supposed to allow
the largest files to be inserted, but in the dev studio it shows as
varbin(0). I'll have to try some different datatypes - but is that
the right approach - take the postarg containing the file and insert
it via an insert action, no conversion or anything?
Cheers,
Jason
-----
Jason Pamental
Director of Web Services
North Sails
Office: 401.643.1415
Fax: 401.643.1420
Mobile: 401.743.4406
Email: [EMAIL PROTECTED]
On Dec 2, 2006, at 1:15 PM, Robert Garcia wrote:
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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
