| Server-side function | |
| Implemented in | LiveWire 1.0 |
path |
A string representing the name of a file containing BLOb data. This string must be an absolute pathname.
|
Returns
A blob object.
Description
Use this function with an updatable cursor to insert or update a row containing BLOb data. To insert or update a row using SQL and the execute method, use the syntax supported by your database vendor.
On DB2, blobs are limited to 32 KBytes.
Remember that back slash ("\") is the escape character in JavaScript. For this reason, in NT filenames you must either use 2 backslashes or a forward slash.
Example
The following statements update BLOb data from the specified GIF files in columns PHOTO and OFFICE of the current row of the EMPLOYEE table.
// Create a cursor
cursor = database.cursor("SELECT * FROM customer WHERE
customer.ID = " + request.customerID// Position the pointer on the row
cursor.next()// Assign the blob data
cursor.photo = blob("c:/customer/photos/myphoto.gif")
cursor.office = blob("c:/customer/photos/myoffice.gif")// And update the row
cursor.updateRow("employee")
Last Updated: 10/31/97 16:38:00