0x800A000D - Type Mismatch Error

[Lebone Mogotsi]

I am not sure what is goint on. Here's my code

inWeekStart = "11"
inWeekEnd = "14"
Compyear = "2003"

Dim rsSQL, strSQL, cmSQL
dim objReportBuild
set objReportBuild = server.CreateObject("Area_Sales.cZoneMnthReport")
set rsSQL = objReportBuild.ZoneMnthReport(inWeekStart, inWeekEnd,
Compyear)

If I hard code the values when calling the component, the page works.
Does anyone have any idea what I could be doing wrong.

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Bob Barrows]

Lebone Mogotsi wrote:

> I am not sure what is goint on. Here's my code
>
> inWeekStart = "11"
> inWeekEnd = "14"
> Compyear = "2003"
>
> Dim rsSQL, strSQL, cmSQL
> dim objReportBuild
> set objReportBuild = server.CreateObject("Area_Sales.cZoneMnthReport")
> set rsSQL = objReportBuild.ZoneMnthReport(inWeekStart, inWeekEnd,
> Compyear)
>
> If I hard code the values when calling the component, the page works.
> Does anyone have any idea what I could be doing wrong.
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

As a guess, it looks like you are passing strings when the ZoneMthReport is
expecting integers. Try
intWeekStart = CLng("11")

HTH,
Bob Barrows