Hello,

I have this prg program "c3" that runs from a website "/wconnect/wc.dll?c3~cdr" and has a function called "cdr".
All this function does is collect call detail records from foxpro tables.

In that function I verify the acct number, user name & password INPUT from the webpage with foxpro tables. If input matches the values in my database then I continue with the user request. Next thing the code does is select a foxpro table
and get all the calls :

select &cdrsm
set filter to dcountry==codem and between(ttod(datetime),date1m,date2m) and inlist(compcode,"01","02","03","04","05","06","07","08","09")
scan
   datetimem=datetime
   phonem=alltrim(dcountry)+alltrim(dnumber)
   unitsn=ansdur
   costn=iif(substr(dnumber,1,1)="3",(unitsn*0.17)/60,(unitsn*sirates.rate)/60)
   insert into cdrsc (datetime,phone,units,cost) values ;
                     (datetimem,phonem,unitsn,costn)
endscan

After collecting all the records, I create another webpage with the following code:

*----------create html page

lohtml.htmlheader("Company Response page")
lohtml.sendpar()
lohtml.sendln("Date: "+dtoc(date())+" Time: "+time())
lohtml.sendln("<BR>")
lohtml.sendln("<HR color=#0000ff>")
lohtml.sendln(lcname+"  Daterange : "+dtoc(date1m)+" - "+dtoc(date2m)+" ;<BR>")
lohtml.sendln("<BR>")
lohtml.sendln("<HR color=#0000ff>")
dimension laheaders(4)
laheaders[1]="Date-Time"
laheaders[2]="Phone"
laheaders[3]="Seconds"
laheaders[4]="Cost"
select cdrsc
locate
lohtml.showcursor(@laheaders,"")
lohtml.htmlfooter("Thank you for using our services")

The problem I'm having is this. If the number of records I'm scaning and inserting in the cursor cdrsc is over 65,000 records, It takes about 60 seconds to finish scanning and inserting into cursor, on the otherhand my website times out arround 50 to 56 seconds and the internet explorer displays the webpage "The page cannot be displayed". Is there a way I can extend the time more than 56 seconds before the webpage times out.

Any suggestions!

Thank you

Bob


P.S.

If number of records in the cursor exceed 250, I create a text file, zip it then I create a hyperlink.