[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Errors in updating [userdb] fields
- Subject: [ic] Errors in updating [userdb] fields
- From: interchange-users@icdevgroup.org (Krishna)
- Date: Wed Dec 4 08:09:01 2002
- In-reply-to: <20021203170002.14134.66239.Mailman@icdevgroup.org>
Hi list,
I am updating only email, mail receipt, shipping method and
Subscriptions. Through following code. When I am trying to submit the
page I got error
" error saving values in userdb: DBD::Pg::st execute failed: ERROR:
Unterminated quoted string at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 981. "
------------------------------------------------------------------------
---
[if session failure]
<br><br>
<B>[calc] delete $Session->{failure}[/calc]</b>
<br>
[/if]
[userdb function=get_shipping_names]
<FORM ACTION="[process]" METHOD="POST">
<INPUT TYPE=hidden NAME=mv_session_id VALUE="[data session id]">
<INPUT TYPE=hidden NAME=mv_order_profile VALUE=account_change>
<INPUT TYPE=hidden NAME=mv_todo VALUE=return>
<INPUT TYPE=hidden NAME=mv_nextpage VALUE=@@MV_PAGE@@>
<INPUT TYPE=HIDDEN NAME=mv_check VALUE="Save_database">
[set Save_database]
[userdb save]
[/set]
email:
<input type="text" name="email" size="50" value="[value email]"
class="formbox12">
<br>
email copy:
<SELECT NAME=email_copy>
<OPTION VALUE="1">Yes
<OPTION [selected name=email_copy value=0] VALUE="0">No
</SELECT>
<br>
ship mode:
<SELECT NAME=mv_shipmode>
[loop option=mv_shipmode list=|[data table=country key='[default country
US]' col=shipmodes]|
]
<OPTION VALUE="[loop-code]"> [shipping-desc [loop-code]]
[/loop]
</SELECT>
<br>
mail subscription:
[display table=userdb type=multiple column=mail_list key="[data
session username]"]
<br>
<INPUT TYPE=SUBMIT VALUE="Save Acct. Info">
</form>
------------------------------------------------------------------------
----
Could you please tell me why I am getting this error instead of saving
these values into the userdb. One strange thing I observed is if select
one value from mailing list then it is saving into userdb without error
if select multiple values from the list then I am getting this error
without saving these values in userdb. Could any please copy this code
and test it for login user. Please note that I want only those fields to
be updated for already registered users.
Thanks in advance,
Krishna