Blob insert
Posted in 1999
Hello All, I'm wondering if anyone has any experience in inserting an image (i.e binary file - GIF/JPEG) into a blob type field from the command line. We are using Informix Online and wish to be able to insert a default image into a table. For instance, in the partial HTML form from an AppPage below: <INPUT TYPE="file" NAME=image SIZE=20> Once the form is submitted the following syntax is executed: <?MIBLOCK COND=$(NXST,$image)> <?MISQL SQL="execute procedure insert blob ('$field1','$field2')"> <?/MISQL> <?/MIBLOCK> So the above code will execute a stored procedure that will contain SYSTEM command(s) that insert the default image from a file already on the HD. I remember hearing something about loadblob(?), is there someway this can be achieved? Is there a way a stored procedure can achieve the result with a SYSTEM comman being used? Thanks for your time, Steven Livanes