By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,357 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

Varbinary(max)

P: 2
Hi Can someone please post the simplest script that will allow an asp page read and write to/from
m a MS SQL varbinary(max) field. ie image or doc/pdf etc is converted to relevant format and inserted to the field and then read back and converted to original format.

If you can do this - may your children be superheroes
Mar 31 '08 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
If you're still in the development stage, I would rather recommend that you store the path and file name of those files on the table and retrieve it rather than do it this way.

-- CK
Mar 31 '08 #2

P: 2
i can store extensions and filenames on the table and i can upload the file physically to the server - its just i cant seem to find the exact sql to populate the varbinary field using embedded sql in asp. I am under the impression it may not be a simpli insert / values statement in the same way oracle needs a stored procedure. I can see the batcape :-)
Mar 31 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.