At 19:57 28/07/99 , Donald Holten wrote:

I have the followin in my html page:

<!--#call "REQUEST.set('numtemp',GetRuns())"--> <!dtml-call "manage_changeProperty(numtemp = numtemp + 1)"> <!--#call "update_AccessCounter()"-->

numtemp is an integer property of the html page. When trying to run the ZSQL Method update_AccessCounter(), I get an error saying "Invalid integer value for numtemp". Here is update_AccessCounter():

update WRTable set numruns = <!--#sqlvar numtemp type=int-->

The possible cause for this that I can see is GetRuns() is not returning an integer value. If so, how can I force it to? GetRuns currently is:

select numruns from WRTable

And numruns is declared an integer in WRTable. If I am wrong, and GetRuns is sending back an integer, what is causing this error? Thanks! Donner

A Z SQL Method returns a sequence, even if it only contains one element. So you are setting 'numtemp' to a contain a sequence, which is definitely not allowed. Change the code to: <!--#in GetRuns--> <!--#call "REQUEST.set('numtemp', numruns)"--> <!--#/in--> -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | Tel: +31-35-7502100 Fax: +31-35-7502111 | mailto:mj@antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ------------------------------------------