Passing variables from ZSQL Methods
Hello, Can someone please point me in the right direction, I have the following python script: print '<SCRIPT LANGUAGE="JavaScript">' print '<!-- Begin' print """if (!assocArray) var assocArray = new Object();""" regions = context.sql_list_region() for region in regions: print """assocArray["region_list="%d"] = new Array("('Select county','',true,true)",""" % region.region_id counties= context.sql_list_county() for county in counties: print '''"('%d')",''' % county.county_id print " ); " print "-->" print "</script>" return printed this connects to two z sql methods, sql_list_region and sql_list_county respectively and the result i get is: <SCRIPT LANGUAGE="JavaScript"> <!-- Begin if (!assocArray) var assocArray = new Object(); assocArray["region_list="2"] = new Array("('Select county','',true,true)", "('1')", "('2')", "('3')", "('4')", "('5')", ........... .......... "('80')", ); assocArray["region_list="3"] = new Array("('Select county','',true,true)", "('1')", "('2')", "('3')", "('4')", "('5')", and so on.......... "('79')", "('80')", ); --> </script> Now one of the problems I am having is that I want to be able to for each region_id to be able to list the related counties, so i passed a variable in the sql_list_county ZSQL Method, which is as follows: arguments: region_id:int=0 select county, county_id from county where region_id=region_id but this returns the whole list for the counties, where as i want to be able to itarate for each region_id. also in the above script, how do i return both the county_id and county within the same print statement? thanks in advance norman
participants (1)
-
Norman Khine