1 May
2001
1 May
'01
9:47 p.m.
I am using 2.1.4 (linux), and have stumbled across this little quirk... Create a ZSQL Method as follows: ================ SELECT <dtml-var "_.whrandom.randint(1000,9999)"> AS random_value ================ (Our ZSQL Method is connected to Sybase, but this works on MySQL as well) Then, simply test the ZSQL Method. Here's what I get: Random value ---------------- 2754 SQL used: select 7684 as random_value 2754 is clearly not the same as 7684. This is quite repeatable, with different random numbers each time. This works as expected if I replace the whrandom call with a constant, but I can't imagine how whrandom can be the culprit. Brián Withun