hi patricia,
it would be really helpful to see an example of 'result' before and
after the call to calc_numbers() as well as the code for calc_numbers
if possible.
this will likely reveal the problem that you are having.
thanks,
-wesley
On 4/12/06, Patricia <[EMAIL PROTECTED]> wrote:
> Hi,
>
> This is my code:
>
> conn = MySQLdb.connect(host = "localhost", user = "root", passwd = "",
> db ="mydb")
> cursor = conn.cursor()
> cursor.execute("""SELECT h, k, l, m, s, t
> FROM targets WHERE target_name = %s""", (target))
> result = cursor.fetchone()
>
> alist = helperfunc.calc_numbers(list(result)) # read below
>
> cursor.close()
> conn.close()
>
> for li in alist:
> if li == '':
> s = s + "<td ALIGN='center'></td>"
> else:
> s = s + "<td ALIGN='center'>%s</td>" % li # problem here
>
>
> calc_numbers is a method in helperfunc.py that takes the list of values
> that I retrieved from the database and then does some calculations
> (addition & division) and also replaces a specific number with ''.
>
> When I display the results, most of the times everything looks right, BUT
> sometimes I get i.e. 15%% instead of 15. I don't understand why %% is
> added to some of the numbers being displayed. I've noticed that the numbers
> that show %% are the ones that have been modified in the calc_numbers
> method. The numbers that are not touched in that method, don't show it.
> When I printed the list obatined from the calc_numbers method, the
> numbers that have not been touched have an L at the end (i'm assuming
> it stands for long). As I said these numbers are displayed correctly
> all the time. I'm really hoping someone can point me to the right direction
> because I've tried different things and nothing seems to work.
>
> Another quick question, my page shows several drop down boxes with
> pre-selected values. When I submit the form or open the page, the
> preselected values appear, but when I press the reload button,
> they don't. (Mozilla)
>
> Thanks,
> Patricia
>
>
>
>
>
> _______________________________________________
> Tutor maillist - Tutor@python.org
> http://mail.python.org/mailman/listinfo/tutor
>
--
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
"Core Python Programming", Prentice Hall, (c)2007,2001
http://corepython.com
wesley.j.chun :: wescpy-at-gmail.com
python training and technical consulting
cyberweb.consulting : silicon valley, ca
http://cyberwebconsulting.com
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
