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 ------------------------------------------