I am looking for the syntax for manipulating a table's column with a function in an update statement:
$affected = $lt->update({ Title => 'myfunc(Title)'});
sets all rows to: "myfunc(Title)"
$affected = $lt->update({ Title => myfunc('Title')});
sets all rows to: "Title"
Does not do anything... it does not seem to run myfunc, leaving the Title values to be unchanged.
myfunc should be manipulating Title and return a similar string back.
I am assuming the last code example is the one which really should work, as the \ should force the sql parser to not quote the function.
http://www.iuni.com/...tware/web/index.html
Links Plugins
Code:
$affected = $lt->update({ Title => 'myfunc(Title)'});
sets all rows to: "myfunc(Title)"
Code:
$affected = $lt->update({ Title => myfunc('Title')});
sets all rows to: "Title"
Code:
$affected = $lt->update({ Title => \'myfunc(Title)'});Does not do anything... it does not seem to run myfunc, leaving the Title values to be unchanged.
myfunc should be manipulating Title and return a similar string back.
I am assuming the last code example is the one which really should work, as the \ should force the sql parser to not quote the function.
http://www.iuni.com/...tware/web/index.html
Links Plugins
GT::SQL UPDATE Question