Yet Another Pic Problem

Victor Subervi victorsubervi at gmail.com
Thu Oct 15 17:20:11 CEST 2009


Hi;
My code was working fine then I must have inadvertently screwed something
up. The result is a mysql insert/update statement that looks something like
the following:

update productsX set Name=%s, Title=%s, Description=%s, Price=%s,
Bedrooms=%s, Bathrooms=%s, Conditions=%s, Acreage=%s, Construction=%s,
Location=%s, Estate=%s, Address=%s, Furnished=%s, pic1=%s, pic2=%s, pic3=%s,
pic4=%s, pic5=%s, pic6=%s where ID=%s;', ('name1', 'title1', 'descr1',
'1.1', '2', '1', 'New', '1.5', 'New', 'arbor', 'abor', 'abor', 'Furnished',
'ÿØÿàJFIFÿÛC     
""

$(4,$&1'-=-157:::#+?D?8C49:7ÿÛC
7%%77777777777777777777777777777777777777777777777777ÿÀy|"ÿÄ
ÿÄM
 !1AQa"qs³27Bbc‚#46Rrt‘¡±²$'3C’%5DTUƒ“¢£ÑñÿÄÿÄÿÚ
?œ*‹RP’¥¨%
d’pªÔcµkä«”øZÂáîj
Xêxö,
`ú@$ýô¨2mÒžÚ
¦ÚRÑ¥¬òguD|!%bO:ðç’Z…æµËÚvsM¡·¢&T‘œ¬ºâ“ñâ1Ò¶¶KT[%¦-²{‘£6Ô÷“âNI=äÒfÓ
ø/RhËîR”³q1
QüÇ“ƒŸƒEŠŠ(
(¢ŠŠ( (¢ŠŠ( ×ê ´{–mÒYü VTâ†pUŽI
$àQvÃ
ɼÜ/ZÒì{IrÝ,´£Èx
ß#¸$Š·÷F_Ëë}……áRTdHóÁ#ÐU“ö*DÙõ¨Yt]žîêÑ+p}5ùêÿ¹F†vã
Êöy5Ô‚\ˆëO Žc 'ö(Óõku-´^4õÊÚÚ£8Ðð%$ì84Ú*øG¥­·TVû#µc
æ·uÏ;Ö"ÓusN\\Ü‹5{ÑʸvoòÝû@é¼×CPU¤¡%KPJR2I8T+´½¨®{ß{:)kzD‡;&2~1'
¤“ïÙßA¶Õº®íª5ÑúAiMçá’O’8•tÆpHâNÇUºl¤Ûmë¸é«ÝÙøéíû’7¼¡@guC
qÓ
ŠhÙ¶cFØÍ\çðäLJÎ^8$}äí=i²Aj©ôœ
«‰J_u/¥<ƒ‰%*áÓˆÎ;ˆ¦ TÐö©6)WûjØZ`ü
dÂsæ–ÝHQBE@m5ÐQEEbÜîíP]›q’Üx̧yn8pÿ߇3IP5–¨¿´©úgL2å©K)aéÒû¼5ã‚s8žTæÕæ*ýµ)Q’­ä4óp›¦0?ÌU]Br
+ç\»]_"韍pTŒŸXU<dÂsæ–ÝHQB%7FE@m5Ð%14QE%01EbÜî%10íP]›q’Üx̧yn8pÿ߇3IP5–¨¿´©úgL2å©K)aéÒû%15¼%075%04ã‚s8žT%10æÕæ*ýµ)Q’­ä4óp›%07¦0%14?ÌU]Br
+ç\»]_"韍pTŒŸXU>]
Èò ­“¬gK®tTxò^i‰É4‡ Rè ¤à8

Y«›`üM]ߊ󌼀ÑK,¥Iü29ƃž6™iU‡]Ý£ 
È/²G5~xÇ£8öT۱͡§SÀ›«¿éˆÈà¥Æ[;ô‡Qן~4»vÒOܬðu
”ëÐÙ Ë
%®ad“Ÿg¨Ãe1.õõœÛæû2ëËG$4>9' )$xç
h3ö‰´Ë®­ôHî.%œ,†ã
ຐxS×
‡Ž3NûÐËAûêº5Œ‚ˆ ¨qÁৈ
ÓÜh±ìËOÏÚV¢‰
>`ÛTíÅß«.¤¨¥Gžè<€ãŽg½ãP<ìM£h¸1
[ÌÄ®;J)mA- ÐR8:g•ãXjû>‚™W‡Ô
„†Xho8é
÷G‡yÀâ8ñ‡¤õ5ëQ¥‰Ÿ{žCjxo7"LÑÚ­à
ØG#Ú‡‘ž¨t–›-LjFžhÈÂXy¥(…\8)
ŽJð}-ÜKp¬’T–PÔuœî€“Œ
”ôTc¢ö…§íZÒ«õùµMìh‚µ<öwŽ7€É
1Î’šÛ2­7
ó";=&b*Sê eÆ7xž|p
è:@Ö[YÓÚq.1Ñs¸'€b2BOÓ_!è>¡¦²Özòbm©}÷ƒêÂ`ÂFâ¤$õŠ•vq±è–bÍÏR†æ\ˆÃÎiƒãùê°tÏA‡§4Þ
Ú<ÆoÚíkfÐ…õ¤%ÁÑE<Â|Oœ¯ŒÌM4Û-!¦”6€”$`$@‚½t¢ƒˆ_Bš}Æםä(¥Yçk®vqyM÷DÚf…ï9äéiîþÑ
j³é#>‚+™ö‘lU§]^¢)
'Ê”êüÅùéýÊñ÷?jÔÛ®¯iÙ®nÇœ­øÅG‚^ˆû@j@ëA#럔
ú̯všÈÛGɝë†|Ö½ò*θÇßö„â3å2º}ZjþÙ¾M/_
ß½Et_Ä™õiþ°ÖZogV÷m qŽ¾´¤¼:°2zð律¿‰³êÓü)/bC7¶Ë´ß.€Ò
ÿJ:ÛÕÀ÷J«ZÍái:9ò•(5
ಔŽ' ƒŠ½¥‡ö¡­x‡Ž>©UMT3µ-×ðSýÐ 5†Ñ5«.³6YfÕ‘
ºØ‚ê¬
½Ô±"T‰Kß’û¯+½Å•ßSVÕö[c´YnŠÔãñ”…¡F
š󖔝ީ
vq“ÝÀVÝÓp!?"D«„·ajkJ¼xà óñ çÆvC¨e†Öë‹8J’¢£à:~Ùö˦ê‰Ó¹H6æ
8–ä6¤öñÝð
:ž]ƦMZíñ´%®lxqÛ”ûJ/>†ÀZüõsW3Ê«³ÒF©Öé<…Ñ'ö¢ƒKi[6•…äÖhik{
£ªóœt÷©\Ï£ènV´¡%kPJ@ÉRŽ«SfGÙs^C1ÙI[Ž,à$¦¢ØÓåm_Pöl¡Ö4m¹à§wI¸:8„Ÿ£Èîô
ø‘ºÍt¢‚û¢t–˜š–*2ix
†r…i)ÏèÔ
Ë®0ò
ejmÆÔ…¤à¤Ž
ƒß]«rëE¾sIz4†Ën¶z¤ÿMr¶Ñt
ýr)XSö×T|šVïôUÜ¡ûù‘lÚÑ:Æû ]x¡7Ò¤·1±Ù
,C>ÐGJzÛÎÍoCêÛ<¾µl‡å
Çë•üŠ©ûlc;6½z¶ýê(bþ&Ï«O𤽉üœ[}cþùtç b
‡ÓËÐ)7bß'vÿ[#ß.€ÒÃûQÖ¼?ÇVªóªømOCäsn~?é ®™9Úž²çýÄ
ŸVkΫùTÐÞ®¹
÷¶¿“k¯¥Ÿ|Šm›Ÿ‚_#ýÝXéóiOm_&·ù>ùËw—†Có$µ
 ÁÇVJxq4
û
9ÙµýRýâézϪ-V÷®fÞ%%¤ü$žÍ´ñqÓ¹É)êpêE$Z6·÷¹
íÖK4NÖâÓKH|a¶‰ZˆÂ~qÁëéåKÚ;J^v“¨dJ’ú».Ð9:jÀញ
TqÀr

^[¨öÏ}òV·íÚr2ÂœJx„þ‘ùî
ƒý¤Î–[L+
²=¶ØÂYŠÂwP‘ûÉ=I™­ŒÍ!aÓ»IÑŒZ-­0ÓÞZ§BŠœß)g)'xžGˆ©1‹d(÷7c6‰’’„¾ð
rÂF
Ud[aIsñ›rTMÿ'uCÎo|aXôŽ [iù5¼qèÏ·ðȦ¹ꇿWWòÕÉðb\¢9á™1œÆû/ )*Ád²¯) R
jH(#$pÇunÇ3ýÙsŸîÜçëWVtF±×‰
^Ñâ>¬Ó¾Kd6áÛã53@„4ÒwRœ’N¤“í¢-º
IdEŒÓOJP[î!8SŠ¨õáA“EPQEH»QÙëÒ^Œ[bï
$0ò‡Ïq~âBOy§ª(8®óg¸Øç.Ú#±d
ñCƒŸˆ<ˆñ
*FûŸ, ŸªÝ»¸Ùò{sGu];UÐ?˾eH»vü¦¯å5]~@'õ§?‚h$Š(¢€¢Š( (¢€¢©U (ªUh
(¢ƒÿÙ', '', '', '', '', '', '')

MySQL complains about the image in string form. I'm sure the solution is
simple, but I don't know what it is.
TIA,
Victor
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20091015/ca2d8ee6/attachment.html>


More information about the Python-list mailing list