Queries from Access

[=?Utf-8?B?SmFtZXM=?=]

Hello all

I am having a odd problem, I have a page that lists users (GridView), this
list links through to another page when you click on the name. The second
page lists all phone calls they received during the previous month
(GridView). I have done this by a Querystring passing SupportId from the
first to the second page.

The second page GridView data source is based on an SQL statement:
"WHERE (supportid = ?) AND
((Right(Left([datetaken],8),5))=Right(D ateAdd("m",-1,Date()),5))"

the [datetaken] field is the date and time the call was received.

This works fine on my computer running it under a local host. However, when
I copy it to my IIS server V6, it does not show any records on the second
page.

Everything else works fine, the list on the first page works ok, even the
second page loads fine but it says No Calls.

Does anyone have a clue why? I have tried almost everything I can think off
but nothing makes a difference.
Many thanks in advance

James

[Patrice]

Finally quite close from my suggestion ;-)

As suggested earlier you may want to avoid converting when not necessary.
Here my personal preference would be to compare date values rather than
converting them to text before doing the comparison.
"James" <Ja***@discussi ons.microsoft.c oma écrit dans le message de news:
50************* *************** **...icrosof t.com...

Hello

I've Done it!!!!! The problem was that UK and USA dates are different, so
I
had to add code to format both dates into UK before comparing them. My
computer it worked fine as its UK same as data, but ASP.Net is obviously
USA
so when on the server it was looking for a day instead of a month.

Final code is:

SELECT supportmember.s upportid, supportmember.d atetaken, icb.[number],
icb.firstname, icb.lastname, RIGHT (LEFT (supportmember. datetaken, 8), 5)
AS
Expr1 FROM (supportmember INNER JOIN icb ON supportmember.m emid =
icb.memid)
WHERE (supportmember. supportid = ?) AND
((Right(Left(Fo rmat([datetaken],"dd/mm/yy"),8),5))=Rig ht(Format(DateA dd("m",-1,Date()),"dd/mm/yy"),5))
ORDER BY supportmember.d atetaken DESC

Wow this one confused me for days.

Many thanks for your help, keep up the good work.

Cheers
James

"James" wrote:

>Hello all

I am having a odd problem, I have a page that lists users (GridView),
this
list links through to another page when you click on the name. The second
page lists all phone calls they received during the previous month
(GridView). I have done this by a Querystring passing SupportId from the
first to the second page.

The second page GridView data source is based on an SQL statement:
"WHERE (supportid = ?) AND
((Right(Left ([datetaken],8),5))=Right(D ateAdd("m",-1,Date()),5))"

the [datetaken] field is the date and time the call was received.

This works fine on my computer running it under a local host. However,
when
I copy it to my IIS server V6, it does not show any records on the second
page.

Everything else works fine, the list on the first page works ok, even the
second page loads fine but it says No Calls.

Does anyone have a clue why? I have tried almost everything I can think
off
but nothing makes a difference.
Many thanks in advance

James