Windows Server

Simone Basso · Guest

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 · Guest

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] · Guest

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?

mnice · Guest

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:

mnice · Guest

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:

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1