[ic] Errors in updating [userdb] fields

Krishna interchange-users@icdevgroup.org
Thu Dec 5 10:46:02 2002


Hi List,

At last I found the solution for the query I posted yesterday. Now the
values are storing in userdb without error. I added one statement to the
following code then it started working.

>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:



added this one ********

[input-filter name=mail_list op=null_to_space][/input-filter]

**********

>    [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