"Tracking"

OK. For DDL, please refer to the classical Northwind ORDERS table,
problem/challenge, find the longest duration (start_date and
end_date), during which, no orders were placed.

FYI, column names by the order of colid per syscolumns:
OrderID
CustomerID
EmployeeID
OrderDate
RequiredDate
ShippedDate
ShipVia
Freight
ShipName
ShipAddress
ShipCity
ShipRegion
ShipPostalCode
ShipCountry

Any idea/approach? TIA.Does this help?

select o1.OrderDate, o2.OrderDate, DATEDIFF( day, o1.OrderDate,
o2.OrderDate) as days_between
from dbo.Orders o1, dbo.Orders o2
where o1.OrderDate < o2.OrderDate
and not exists
(select * from dbo.Orders o3
where o3.OrderDate < o2.OrderDate
and o1.OrderDate < o3.OrderDate)
group by o1.OrderDate, o2.OrderDate
order by days_between desc

"DonLi" <donli@.yahoo.com> wrote in message
news:9a172893.0404051228.4a675061@.posting.google.c om...
> OK. For DDL, please refer to the classical Northwind ORDERS table,
> problem/challenge, find the longest duration (start_date and
> end_date), during which, no orders were placed.
> FYI, column names by the order of colid per syscolumns:
> OrderID
> CustomerID
> EmployeeID
> OrderDate
> RequiredDate
> ShippedDate
> ShipVia
> Freight
> ShipName
> ShipAddress
> ShipCity
> ShipRegion
> ShipPostalCode
> ShipCountry
> Any idea/approach? TIA.

"marking" the processed elements in data-driven subscription

I would like to use e-mail delivery for the following scenario: new orders
arrive in a table and i
would like to send confirmation messages which contain the content of the
order. The RS has an "every
5 minutes" schedule and should send e-mail just about the new orders to the
customers.
How could I differentiate the new elements from the old ones?
- or -
How can I "mark" the orders, when the confirmation report was created that
they were processed?
Thanks in advance,
Kolos"Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> I would like to use e-mail delivery for the following scenario: new orders
> arrive in a table and i
> would like to send confirmation messages which contain the content of the
> order. The RS has an "every
> 5 minutes" schedule and should send e-mail just about the new orders to
the
> customers.
> How could I differentiate the new elements from the old ones?
> - or -
> How can I "mark" the orders, when the confirmation report was created
that
> they were processed?
> Thanks in advance,
> Kolos
>
>|||"Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> I would like to use e-mail delivery for the following scenario: new orders
> arrive in a table and i
> would like to send confirmation messages which contain the content of the
> order. The RS has an "every
> 5 minutes" schedule and should send e-mail just about the new orders to
the
> customers.
> How could I differentiate the new elements from the old ones?
> - or -
> How can I "mark" the orders, when the confirmation report was created
that
> they were processed?
> Thanks in advance,
> Kolos
>
>|||'
"Bender" <roman.ilic@.avtenta.si> wrote in message
news:%23%23BJFeHgEHA.3416@.TK2MSFTNGP09.phx.gbl...
> "Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
> news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> > I would like to use e-mail delivery for the following scenario: new
orders
> > arrive in a table and i
> > would like to send confirmation messages which contain the content of
the
> > order. The RS has an "every
> > 5 minutes" schedule and should send e-mail just about the new orders to
> the
> > customers.
> >
> > How could I differentiate the new elements from the old ones?
> > - or -
> > How can I "mark" the orders, when the confirmation report was created
> that
> > they were processed?
> >
> > Thanks in advance,
> > Kolos
> >
> >
> >
>
>|||Hi Kolos,
We do something similar.
We have an additional field in our subscription Queue which has a Processed
Flag field (just a BIT). We update this field whenever the entry has been
processed via the data driven subscription's query. If you don't want to
add a field to this table, you could create an additional table recording a
log of processed Orders.
HTH
Matt
"Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> I would like to use e-mail delivery for the following scenario: new orders
> arrive in a table and i
> would like to send confirmation messages which contain the content of the
> order. The RS has an "every
> 5 minutes" schedule and should send e-mail just about the new orders to
the
> customers.
> How could I differentiate the new elements from the old ones?
> - or -
> How can I "mark" the orders, when the confirmation report was created
that
> they were processed?
> Thanks in advance,
> Kolos
>
>|||That's on the right track, but I'd like to also point out that an easy way
to update the "flag" field is to use a stored procedure. Within the sproc
you can return the records affected by the email notice and revisit each row
to update the flag value. =)
Matt
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ucN2OnDrEHA.868@.TK2MSFTNGP10.phx.gbl...
> Hi Kolos,
> We do something similar.
> We have an additional field in our subscription Queue which has a
> Processed
> Flag field (just a BIT). We update this field whenever the entry has been
> processed via the data driven subscription's query. If you don't want to
> add a field to this table, you could create an additional table recording
> a
> log of processed Orders.
> HTH
> Matt
> "Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
> news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
>> I would like to use e-mail delivery for the following scenario: new
>> orders
>> arrive in a table and i
>> would like to send confirmation messages which contain the content of the
>> order. The RS has an "every
>> 5 minutes" schedule and should send e-mail just about the new orders to
> the
>> customers.
>> How could I differentiate the new elements from the old ones?
>> - or -
>> How can I "mark" the orders, when the confirmation report was created
> that
>> they were processed?
>> Thanks in advance,
>> Kolos
>>
>|||lol, actually, I do use a stored procedure. I was being just more general
and wasn't sure of Kolos's particular scenario.
"Matt Temple" <mtemple@.dslextreme.com> wrote in message
news:10q9p1l72kj6iaa@.corp.supernews.com...
> That's on the right track, but I'd like to also point out that an easy way
> to update the "flag" field is to use a stored procedure. Within the sproc
> you can return the records affected by the email notice and revisit each
row
> to update the flag value. =)
> Matt
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ucN2OnDrEHA.868@.TK2MSFTNGP10.phx.gbl...
> > Hi Kolos,
> >
> > We do something similar.
> >
> > We have an additional field in our subscription Queue which has a
> > Processed
> > Flag field (just a BIT). We update this field whenever the entry has
been
> > processed via the data driven subscription's query. If you don't want
to
> > add a field to this table, you could create an additional table
recording
> > a
> > log of processed Orders.
> >
> > HTH
> >
> > Matt
> >
> > "Kolos Daniel" <d1974kol@.mailbox.hu> wrote in message
> > news:OeW5p0GgEHA.556@.tk2msftngp13.phx.gbl...
> >> I would like to use e-mail delivery for the following scenario: new
> >> orders
> >> arrive in a table and i
> >> would like to send confirmation messages which contain the content of
the
> >> order. The RS has an "every
> >> 5 minutes" schedule and should send e-mail just about the new orders to
> > the
> >> customers.
> >>
> >> How could I differentiate the new elements from the old ones?
> >> - or -
> >> How can I "mark" the orders, when the confirmation report was created
> > that
> >> they were processed?
> >>
> >> Thanks in advance,
> >> Kolos
> >>
> >>
> >>
> >
> >
>

"Conversion failed when converting from a character string to uniqueidentifier."

This is probably a simple wuestion but i would appreciate some help

I am trying to get and insert theuserId into a table called "Orders"

I got the user id as

Dim CustomerId As Object = Membership.GetUser(User.Identity.Name).ProviderUserKey.ToString

The button on click command is

worldshop.ShoppingCart.CreateOrder(CustomerId,...................

The Function Has the parameter for Customer Id as follows

Dim dbParam_CustomerId As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_CustomerId.ParameterName = "@.CustomerId"
dbParam_CustomerId.Value = CustomerId
dbParam_CustomerId.DbType = System.Data.DbType.String
command.Parameters.Add(dbParam_CustomerId)

When i run this I am getting the error message

"Conversion failed when converting from a character string to uniqueidentifier."

Can anyone tell me where I am going wrong

many thanks

Martin

What type is CustomerID defined as in the database? It sounds like it is NOT a string, but rather a uniqueidentifier (a GUID).|||

thanks for your reply. i got it sorted out

martin

|||Do you mind sharing with us what your solution was? as I am having the same problem...|||

I'll check and get back to you

martin

|||

sorry about the delay in getting back to you

I was having the same problem. I solved it by instantiating the userid as an object

Dim userId As Object = Membership.GetUser(User.Identity.Name).ProviderUserKey

i passed the object to the function as a guid

ByVal userId As Guid
Dim dbParam_userId As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_userId.ParameterName = "@.UserId"
dbParam_userId.Value = userId
dbParam_userId.DbType = System.Data.DbType.Guid
command.Parameters.Add(dbParam_userId)

last i put the guid into the database as char 36

@.UserId char (36)

HTH