DB at M-and-D
Sep 25, 2009, 9:29 AM
Post #1 of 1
(430 views)
Permalink
|
|
Confusing database update via form issue
|
|
Hi - I'm trying to update a field that I added to my orderline table via
this simple form:
[set mv_data_enable]1[/set]
[tag flag write]orderline[/tag]
<FORM METHOD=POST ACTION="[area process]">
<INPUT TYPE=HIDDEN NAME="mv_data_table" VALUE="orderline">
<INPUT TYPE=HIDDEN NAME="mv_data_key" VALUE="14372-1">
<INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="update">
<INPUT TYPE=HIDDEN NAME="mv_update_empty" VALUE="1">
<INPUT TYPE=HIDDEN NAME="mv_data_fields" VALUE="ol_note">
<INPUT TYPE="hidden" name="mv_nextpage" value="updated">
<INPUT TYPE=hidden NAME="mv_todo" VALUE="set">
<INPUT TYPE=TEXT NAME="ol_note" SIZE="8" VALUE="5">
<INPUT TYPE="SUBMIT" name="mv_click" value="Set">
</FORM>
If I try this however, the following error shows up in my log:
No key '14372-1' found for function='update' table='orderline'
There is certainly a record with code 14372-1 in my orderline table.
I suspect the problem may be that IC is mathematically evaluating the
expression 14372-1, getting the result 14371, and failing to find a
matching record.
I've tried things like
<INPUT TYPE=HIDDEN NAME="mv_data_key" VALUE=""14372-1"">
and
<INPUT TYPE=HIDDEN NAME="mv_data_key" VALUE="'14372-1'">
without success. Does anyone have ideas to get this to work?
DB
_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users
|
