Returning results from pythod method to web page
Hi there, I'm trying to find a way of returning some results from a MySQL database search into a <OPTION> </OPTION> list in a web page. I've written a python method which gets all the data i need from my database. I've stripped down the results (ie removed all the double and single quotes) so i can split them into the individual results. Heres my problem, i've got a while loop that will loop through each of the results from my database query, but i need some way to pass these results out to my web page. I've tried using: while (i<length): return " <option value=\" "+splitString[i]+" \">"+splitString[i]+" " i = i + 1 Which works but as it uses Return it fall out the loop and only returns the one item in my OPTION list. So i then tried to return a string of all the search results such as: while (i<length): f = " <option value=\" "+splitString[i]+" \">"+splitString[i]+" " i = i + 1 s = f s = s + f return s which returns the last item of the seach results. I've worked out that it does this because i keep overwriting the value of s with f. I've tried to assign s to be empty or " " but i was getting error messages saying s has not been assigned any values. Does anyone know how i could get around this? or does anyone know a better way of returning values from a loop into a web page?? Any feedback (preferably ASAP) would be most apprieciated Cheers Alan
Hi Alan, I advocate separating logic [python] & presentation [dtml], so create [something like] the following python script: result = [] while (i < length): result.append(splitString[i]) i = i + 1 return result but I've just reread your message as I don't quite understand what stringSplit is, so why don't you just return the list as is: return stringSplit then in dtml: <dtml-in myScript> <option>&dtml-sequence-item </dtml-in> Ivan ps please send plain text mail to this list
Hi there, I'm trying to find a way of returning some results from a MySQL database search into a <OPTION> </OPTION> list in a web page. I've written a python method which gets all the data i need from my database. I've stripped down the results (ie removed all the double and single quotes) so i can split them into the individual results. Heres my problem, i've got a while loop that will loop through each of the results from my database query, but i need some way to pass these results out to my web page. I've tried using: while (i<length): return " <option value=\" "+splitString[i]+" \">"+splitString[i]+" " i = i + 1 Which works but as it uses Return it fall out the loop and only returns the one item in my OPTION list. So i then tried to return a string of all the search results such as: while (i<length): f = " <option value=\" "+splitString[i]+" \">"+splitString[i]+" " i = i + 1 s = f s = s + f return s which returns the last item of the seach results. I've worked out that it does this because i keep overwriting the value of s with f. I've tried to assign s to be empty or " " but i was getting error messages saying s has not been assigned any values. Does anyone know how i could get around this? or does anyone know a better way of returning values from a loop into a web page?? Any feedback (preferably ASAP) would be most apprieciated Cheers Alan
participants (2)
-
alankirk -
Ivan Cornell