Don Parris wrote:
>  Just getting back to this - Mondays are always hectic.  This recipe is the
>  one I saw and like.  It looks cool!  In my brief efforts tinkering with it,
>  I am not really getting very far.  I saved the recipe, and import it into
>  the file containing all my database functions.  In one of the
>  functions, I have the following:
>  
>  I used the "from tbl_Tabs import *" approach to import the recipe.  If I
>  should be doing this differently, just say so.
>  
>      for record in Results:
>          print '%-15s\t%-15s\t%-15s' % record    
>  # I still want to print to screen, then...
>  
>          mbrPhone = open('mbrPhone.txt', 'w')
>          mbrPhone.write(indent(record, hasHeader=False, separateRows=True))
>          mbrPhone.close()

The problem is you are just passing one record to indent(). It processes the whole table at 
once so you have to pass the list of records, i.e.
        mbrPhone.write(indent(Results, hasHeader=False, separateRows=True))

and do this outside the loop or you will write the file once for every record. So your code 
should look like this:

    for record in Results:
        print '%-15s\t%-15s\t%-15s' % record    
# I still want to print to screen, then...

    # Notice different indent from your code
    mbrPhone = open('mbrPhone.txt', 'w')
    mbrPhone.write(indent(Results, hasHeader=False, separateRows=True))
    mbrPhone.close()

>  
>  I first assumed that "record", and then "Results" could be substituted for
>  "rows", per the recipe.  I also tried "rows", and assigning "record", and
>  then "Results" to "rows".  O.k., you can laugh all you want.  I tried
>  playing with the various arguments, and found that to be of little value.
>  
>  The traceback refers to a type error: iteration over a non-sequence.  The
>  query returns a tuple, as I understand it.  I also understand a tuple to be
>  a sequence.  If this is really as simple as the 3 lines you pointed out
>  above, I know I'm missing something in the implementation.

Yes, a tuple is a sequence. If you still get an error with the code above, please post the e
xact error message and traceback (copy / paste from the output), there is a lot of useful in
formation in it that can be lost if you paraphrase.

Kent

_______________________________________________
Tutor maillist  -  Tutor@[...].org
http://mail.python.org/mailman/listinfo/tutor