SQL Query Issue in QTP

[rajiv.qtp]

Hello every one,

I am using the following Code -:

Code:

nowMonth=month(now)
nowDay=day(now)
nowYear=year(now)

TodayDate=nowYear&nowMonth&nowDay    
                StartDate=DateSerial(nowYear,nowMonth,nowDay-22)                                        StartMonth=month(StartDate)
StartDay=day(StartDate)
StartYear=year(StartDate)
                    NowStartDate=StartYear&StartMonth&StartDay      
                    
Dim kk
kk=20

And passing the following sql query -:

Code:

"select fromdomain, sum(total) as total,sum(delivered)as delivered,sum(bounced)as bounced,sum(readcount)as readcount,sum(replycount)as replycount,sum(unsub)as unsub from emailinfo where sdate1 >= '"+NowStartDate+"' and sdate1 <= '"+TodayDate+"' group by fromdomain order by fromdomain asc offset "+kk+" limit 20"

This query is causing the problem. If I pass offset 0 or 20 etc then query run perfectly but if I pass the offset value through a variable 'KK'. Its cuase problem.

Can anyone help here ?

Thanks in Advance !

[Jay]

please replace +kk+ to & kk & . should work