•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Python section within the Software Development category of DaniWeb, a massive community of 392,063 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,251 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Python advertiser:
Views: 1534 | Replies: 4
 |
| |
•
•
Join Date: Jul 2005
Posts: 9
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
hi 
I need some help for this script
I have
--------------------
------------------
#and want to print this out of "for record in result:"
#but there is an error in
10x in advance))
I need some help for this script
I have
--------------------
cursor = conn.cursor()
cursor.execute("select * from playlist limit 5")
result = cursor.fetchall()
# iterate through resultset
playlist_txt = ''
for record in result:
mp3id = record[0]
mp3_title = record[1]
mp3_artist = record[2]
playlist_txt += mp3id + mp3_title + mp3_artist
#print mp3id , " - ", mp3_title , ' - ', mp3_artist , "<br />"
cursor.close()
conn.close()#and want to print this out of "for record in result:"
print playlist_txt
#but there is an error in
playlist_txt += mp3id + mp3_title + mp3_artist
10x in advance
)) 
•
•
Join Date: Jun 2005
Location: Troy
Posts: 1,277
Reputation:
Rep Power: 7
Solved Threads: 36
With Python questions, you definitely need to use CODE tags.
•
•
Join Date: Jul 2005
Posts: 9
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
sorry but I write here for the first time
Now I know 10x
Now I know 10x
•
•
Join Date: Oct 2004
Location: Mojave Desert
Posts: 2,394
Reputation:
Rep Power: 9
Solved Threads: 172
Re: problem with string Can you give us the error message and a little more of your code?
Without that info, I don't know what your resultset looks like. I can only assume that mp3id could be an integer and needs to be converted to a string to work with the + concatination. In this case mp3id = str(record[0]) would do the trick.
Without that info, I don't know what your resultset looks like. I can only assume that mp3id could be an integer and needs to be converted to a string to work with the + concatination. In this case mp3id = str(record[0]) would do the trick.
May 'the Google' be with you!
•
•
Join Date: Jul 2005
Posts: 9
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
10x for the help
I try with this and it work perfect)
Edit: added / to ending [/code]
I try with this and it work perfect
)playlist_txt += str(mp3id) + str(mp3_title) + str(mp3_artist) + '<br>' #playlist_txt += "%s %s %s <br>" % (mp3id, mp3_title, mp3_artist)
Edit: added / to ending [/code]
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Python Marketplace
Hybrid Mode
- Problem formating VB string for clipboard (Visual Basic 4 / 5 / 6)
- Addnew problem (Visual Basic 4 / 5 / 6)
- ANSI string problem (C++)
- Problem While Processing A String List (C++)
- Help with problem (Java)
Other Threads in the Python Forum
- Previous Thread: copy a file
- Next Thread: Opening HTTP sessions with Python
