[ic] Confusing database update via form issue

DB DB at M-and-D.com
Fri Sep 25 16:29:32 UTC 2009


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



More information about the interchange-users mailing list