|
Home > Archive > Commerce Server General > October 2005 > How to get d_DateLastChanged column from BasketGroup table?
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 |
How to get d_DateLastChanged column from BasketGroup table?
|
|
|
| Hi,
Is there a way to retrieve the value of the column d_DateLastChanged from
BasketGroup table without using a sqlquery.
Thanks
| |
| Nihit Kaul [MSFT] 2005-10-24, 10:38 am |
| You can load the Basket from the DB and then access the property as an
indexer property on the Basket and see if that works for you. Not sure how
you are wanting to get this value if not by doing a query.
Thanks,
Nihit Kaul[MSFT]
Commerce Server
http://blogs.msdn.com/nihitk
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
--------------------
Thread-Topic: How to get d_DateLastChanged column from BasketGroup table?
thread-index: AcXTJeTGwzHqvX4uQjSy+gn4ARjVTQ==
X-WBNR-Posting-Host: 199.201.1.18
From: "=?Utf-8?B?TUo=?=" <MJ@discussions.microsoft.com>
Subject: How to get d_DateLastChanged column from BasketGroup table?
Date: Mon, 17 Oct 2005 07:20:15 -0700
Lines: 4
Message-ID: <7D34DF81-0EE6-436E-8D5A-348C630F1493@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3682
X-Tomcat-NG: microsoft.public.commerceserver.general
Hi,
Is there a way to retrieve the value of the column d_DateLastChanged
from
BasketGroup table without using a sqlquery.
Thanks
| |
|
| Thanks Nihit for the response. What I meant was that I want to show the value
that is in the d_DateLastChanged of the BasketGroup table. Can I access this
field using basket.orderforms["default"]["d_DateLastChanged"] or is there any
other way ‘cause when I use basket.orderforms["default"]["d_DateLastChanged"]
it fails.
I know this property/field is not visible when I say
basket.orderforms["default"].SomeValue..( I can't see any property for the
d_DateLastChanged). I hope I was able to express what I want to do.
I can get the value using the sql statement but just wanted to check
before moving on to that option if I could get it from the orderforms..
Thanks
"Nihit Kaul [MSFT]" wrote:
> You can load the Basket from the DB and then access the property as an
> indexer property on the Basket and see if that works for you. Not sure how
> you are wanting to get this value if not by doing a query.
>
> Thanks,
>
> Nihit Kaul[MSFT]
> Commerce Server
> http://blogs.msdn.com/nihitk
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> --------------------
> Thread-Topic: How to get d_DateLastChanged column from BasketGroup table?
> thread-index: AcXTJeTGwzHqvX4uQjSy+gn4ARjVTQ==
> X-WBNR-Posting-Host: 199.201.1.18
> From: "=?Utf-8?B?TUo=?=" <MJ@discussions.microsoft.com>
> Subject: How to get d_DateLastChanged column from BasketGroup table?
> Date: Mon, 17 Oct 2005 07:20:15 -0700
> Lines: 4
> Message-ID: <7D34DF81-0EE6-436E-8D5A-348C630F1493@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> Newsgroups: microsoft.public.commerceserver.general
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3682
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Hi,
> Is there a way to retrieve the value of the column d_DateLastChanged
> from
> BasketGroup table without using a sqlquery.
> Thanks
>
| |
| Nihit Kaul [MSFT] 2005-10-24, 10:38 am |
| Did you try directly at the Basket level? E.g.
basket["d_DateLastChanged"]
I think this might be an OrderGroup level property instead of on the
OrderForm.
Thanks,
Nihit Kaul[MSFT]
Commerce Server
http://blogs.msdn.com/nihitk
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
--------------------
Thread-Topic: How to get d_DateLastChanged column from BasketGroup table?
thread-index: AcXT7LCaKMM/tLtHQWKBLflF6zyezQ==
X-WBNR-Posting-Host: 199.201.1.18
From: "=?Utf-8?B?TUo=?=" <MJ@discussions.microsoft.com>
References: <7D34DF81-0EE6-436E-8D5A-348C630F1493@microsoft.com>
<i6ul9O20FHA.1172@TK2MSFTNGXA01.phx.gbl>
Subject: RE: How to get d_DateLastChanged column from BasketGroup table?
Date: Tue, 18 Oct 2005 07:03:17 -0700
Lines: 59
Message-ID: <81152C43-99EA-42D5-A826-56E27EB4279B@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 8bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3690
X-Tomcat-NG: microsoft.public.commerceserver.general
Thanks Nihit for the response. What I meant was that I want to show the
value
that is in the d_DateLastChanged of the BasketGroup table. Can I access
this
field using basket.orderforms["default"]["d_DateLastChanged"] or is there
any
other way ‘cause when I use
basket.orderforms["default"]["d_DateLastChanged"]
it fails.
I know this property/field is not visible when I say
basket.orderforms["default"].SomeValue..( I can't see any property for the
d_DateLastChanged). I hope I was able to express what I want to do.
I can get the value using the sql statement but just wanted to check
before moving on to that option if I could get it from the orderforms..
Thanks
"Nihit Kaul [MSFT]" wrote:
> You can load the Basket from the DB and then access the property as an
> indexer property on the Basket and see if that works for you. Not sure
how
> you are wanting to get this value if not by doing a query.
>
> Thanks,
>
> Nihit Kaul[MSFT]
> Commerce Server
> http://blogs.msdn.com/nihitk
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> --------------------
> Thread-Topic: How to get d_DateLastChanged column from BasketGroup table?
> thread-index: AcXTJeTGwzHqvX4uQjSy+gn4ARjVTQ==
> X-WBNR-Posting-Host: 199.201.1.18
> From: "=?Utf-8?B?TUo=?=" <MJ@discussions.microsoft.com>
> Subject: How to get d_DateLastChanged column from BasketGroup table?
> Date: Mon, 17 Oct 2005 07:20:15 -0700
> Lines: 4
> Message-ID: <7D34DF81-0EE6-436E-8D5A-348C630F1493@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> Newsgroups: microsoft.public.commerceserver.general
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3682
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Hi,
> Is there a way to retrieve the value of the column d_DateLastChanged
> from
> BasketGroup table without using a sqlquery.
> Thanks
>
| |
|
| Thanks Nihit,
It worked.
"Nihit Kaul [MSFT]" wrote:
> Did you try directly at the Basket level? E.g.
>
> basket["d_DateLastChanged"]
>
> I think this might be an OrderGroup level property instead of on the
> OrderForm.
>
> Thanks,
>
> Nihit Kaul[MSFT]
> Commerce Server
> http://blogs.msdn.com/nihitk
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> --------------------
> Thread-Topic: How to get d_DateLastChanged column from BasketGroup table?
> thread-index: AcXT7LCaKMM/tLtHQWKBLflF6zyezQ==
> X-WBNR-Posting-Host: 199.201.1.18
> From: "=?Utf-8?B?TUo=?=" <MJ@discussions.microsoft.com>
> References: <7D34DF81-0EE6-436E-8D5A-348C630F1493@microsoft.com>
> <i6ul9O20FHA.1172@TK2MSFTNGXA01.phx.gbl>
> Subject: RE: How to get d_DateLastChanged column from BasketGroup table?
> Date: Tue, 18 Oct 2005 07:03:17 -0700
> Lines: 59
> Message-ID: <81152C43-99EA-42D5-A826-56E27EB4279B@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 8bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> Newsgroups: microsoft.public.commerceserver.general
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3690
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Thanks Nihit for the response. What I meant was that I want to show the
> value
> that is in the d_DateLastChanged of the BasketGroup table. Can I access
> this
> field using basket.orderforms["default"]["d_DateLastChanged"] or is there
> any
> other way ‘cause when I use
> basket.orderforms["default"]["d_DateLastChanged"]
> it fails.
> I know this property/field is not visible when I say
> basket.orderforms["default"].SomeValue..( I can't see any property for the
> d_DateLastChanged). I hope I was able to express what I want to do.
> I can get the value using the sql statement but just wanted to check
> before moving on to that option if I could get it from the orderforms..
> Thanks
>
>
>
> "Nihit Kaul [MSFT]" wrote:
>
> how
> rights.
>
|
|
|
|
|