I am trying to use the <submit> function to upload both character and binary data to another vortex function.
In this case the binary data is a pdf file. The vortex script at the other end doesn't see anything past the first null character in the pdf file.
Normally in a form element, I use "ENCTYPE="multipart/form-data"".
I'm not at all sure if this will work in the vortex form submitting function. many thanks for any help.
Yes, this will work with Vortex; I assume you're using an <INPUT TYPE=file> tag on the form as well. How exactly are you manipulating the PDF file's variable once in Vortex? Some Vortex functions deal only with strings, and will stop at nul. For example, <send> takes string arguments and will stop at nul, while <fmt>/<strfmt> can deal with binary data.
What is the type of the PDF column in your source table? Have you confirmed that you can select it completely from the table (print it with <fmt "%s" $PDF>)? If it's char or varchar, then it may be truncated at the <SQL> select.
