TeraScript-Talk: Handling VARBINARY(MAX)

2018-05-02 Thread Andrej Popovic
Hi all I am looking at a requirement to add the ability to upload binary files into a SQL Server database - varbinary(MAX) - fronted by a TeraScript web. This is using a plain old in a HTML form. I have done this without too many problems in .NET before, but I am a little concerned about the

RE: TeraScript-Talk: Handling VARBINARY(MAX)

2018-05-02 Thread Robert Shubert
Andrej, This should work – but be sure to not handle the data at all and use a directDBMS with the @BIND tag. So: <@ASSIGN binaryData <@ARG file>> Then in a DirectDBMS: INSERT INTO files (data) VALUES (<@BIND binaryData>) notes about TS6: It’s a 32-bit app, so you’re limited