Varbinary(max)

[tindersticks]

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

[ck9663]

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

[tindersticks]

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 :-)