|
Home > Archive > Commerce Server General > February 2005 > SaveAsOrder and user_first_name
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SaveAsOrder and user_first_name
|
|
| Simone Basso 2005-02-08, 7:56 am |
| I've a problem, when i save my Basket as an Order, i lose
user_first_name user_last_name value of the presetted value, and in my
DB i've null values.
Somene have an idea?
I don't nothing else than call the SaveAsOrder method..
string bla = (string)OrderGroup["user_first_name"]; // = simone
PurchaseOrder order = OrderGroup.SaveAsOrder();
bla = (string)order["user_first_name"]; // = null
why happen this ??
simone
| |
| Simone Basso 2005-02-08, 5:52 pm |
| Using sql server profiler when i call Save as Order i can see
SaveAsOrder do all this job :
exec sp_executesql N'insert into OrderGroup with(ROWLOCK)
(marshaled_data, order_status_code, user_id, g_UserIDChangedBy,
saved_cy_oadjust_subtotal, ordergroup_id, saved_cy_total_total,
d_DateCreated, order_number, billing_currency, d_DateLastChanged,
order_create_date, total_lineitems) values
(@P1, @P2, @P3, @P4, @P5, @P6, @P7, @P8, @P9, @P10, @P11, @P12, @P13)',
N'@P1 image,@P2 int,@P3 nchar(38),@P4 nchar(38),@P5 money,@P6
nchar(38),@P7 money,@P8 datetime,@P9 nchar(4),@P10 nchar(3),@P11
datetime,@P12 datetime,@P13 int', 0x010[...]E, 4,
N'{8C2F6C92-53B2-413F-8E43-7FE51E006BF0}',
N'{8C2F6C92-53B2-413F-8E43-7FE51E006BF0}', $48.0000,
N'{AAECC855-EE59-41F6-9A9F-6E8B6260C246}', $48.0000, 'Feb 8 2005
3:00:50:000PM', N'1096', N'EUR', 'Feb 8 2005 3:01:53:000PM', 'Feb 8
2005 3:01:54:000PM', 1
insert into OrderFormHeader[...]
insert into OrderFormLineItems[...]
insert into OrderGroupAddresses[..]
delete from BasketGroup WHERE
ordergroup_id=N'8c2f6c92-53b2-413f-8e43-7fe51e006bf0'
seems user_first_name is not saved on Database... 
do i have to set it after SaveAsOrder and resave my order?
| |
| Andre Podnozov [MSFT] 2005-02-10, 5:53 pm |
| Can you list here what you have in the <addressMap> section of your
web.config of OrderWebService?
Thanks
Andre
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation. All rights
reserved.
--------------------
From: "Simone Basso" <smnbss@gmail.com>
Newsgroups: microsoft.public.commerceserver.general
Subject: Re: SaveAsOrder and user_first_name
Date: 8 Feb 2005 06:04:04 -0800
Organization: http://groups.google.com
Lines: 28
Message-ID: <1107871444.591620.199370@f14g2000cwb.googlegroups.com>
References: <1107870798.696055.254960@g14g2000cwa.googlegroups.com>
NNTP-Posting-Host: 81.112.241.210
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1107871459 18439 127.0.0.1 (8 Feb 2005 14:04:19
GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 8 Feb 2005 14:04:19 +0000 (UTC)
In-Reply-To: <1107870798.696055.254960@g14g2000cwa.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=81.112.241.210;
posting-account=Jfo_vA0AAABohVjvTOquravLXn-DhV81
Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED02.phx.gbl!tornado.fastwebnet.it!tiscali!new
sfeed1.ip.tiscali.net!news.glorb.com!postnews.google.com!f14g2000cwb.googleg
roups.com!not-for-mail
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:15583
X-Tomcat-NG: microsoft.public.commerceserver.general
Using sql server profiler when i call Save as Order i can see
SaveAsOrder do all this job :
exec sp_executesql N'insert into OrderGroup with(ROWLOCK)
(marshaled_data, order_status_code, user_id, g_UserIDChangedBy,
saved_cy_oadjust_subtotal, ordergroup_id, saved_cy_total_total,
d_DateCreated, order_number, billing_currency, d_DateLastChanged,
order_create_date, total_lineitems) values
(@P1, @P2, @P3, @P4, @P5, @P6, @P7, @P8, @P9, @P10, @P11, @P12, @P13)',
N'@P1 image,@P2 int,@P3 nchar(38),@P4 nchar(38),@P5 money,@P6
nchar(38),@P7 money,@P8 datetime,@P9 nchar(4),@P10 nchar(3),@P11
datetime,@P12 datetime,@P13 int', 0x010[...]E, 4,
N'{8C2F6C92-53B2-413F-8E43-7FE51E006BF0}',
N'{8C2F6C92-53B2-413F-8E43-7FE51E006BF0}', $48.0000,
N'{AAECC855-EE59-41F6-9A9F-6E8B6260C246}', $48.0000, 'Feb 8 2005
3:00:50:000PM', N'1096', N'EUR', 'Feb 8 2005 3:01:53:000PM', 'Feb 8
2005 3:01:54:000PM', 1
insert into OrderFormHeader[...]
insert into OrderFormLineItems[...]
insert into OrderGroupAddresses[..]
delete from BasketGroup WHERE
ordergroup_id=N'8c2f6c92-53b2-413f-8e43-7fe51e006bf0'
seems user_first_name is not saved on Database...
do i have to set it after SaveAsOrder and resave my order?
| |
|
| Hi,
I have a same problem... also the billing_currency field seems to go null
after the saveasorder call.
using Commerce 2000 sp3
is there something that I (we) are totally missing here... :/
"Simone Basso" wrote:
> I've a problem, when i save my Basket as an Order, i lose
> user_first_name user_last_name value of the presetted value, and in my
> DB i've null values.
>
> Somene have an idea?
>
> I don't nothing else than call the SaveAsOrder method..
>
> string bla = (string)OrderGroup["user_first_name"]; // = simone
> PurchaseOrder order = OrderGroup.SaveAsOrder();
> bla = (string)order["user_first_name"]; // = null
>
> why happen this ??
>
> simone
>
>
| |
|
| To reply my own post 
I found out that in orderformheader table there is billing_currency null and
it takes that value from there and saves it to ordergroup-table. I manually
update billing_currency and now saveasorder keeps the value ok...
maybe there is some cleaver way to deal this but untill then I'll travel
this path
br, mika.
"mnice" wrote:
[vbcol=seagreen]
> Hi,
>
> I have a same problem... also the billing_currency field seems to go null
> after the saveasorder call.
>
> using Commerce 2000 sp3
>
> is there something that I (we) are totally missing here... :/
>
> "Simone Basso" wrote:
>
|
|
|
|
|