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ÂáîjXêxö,...@$ýô¨2mÒžÚ¦ÚrÑ¥¬ògud|!%bO:ðç’Z…æµËÚvsM¡·¢&T‘œ¬ºâ“ñâ1Ò¶¶KT[%¦-²{‘£6Ô÷“âNI=äÒfÓø/RhËîR”³q1QüÇ“ƒŸƒ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¥·TVû#µc æ·uÏ;Ö"Óusn\\Ü‹5{Ñʸvoò�...@é¼×cpu¤¡%kpjr2i8t+´½¨®{ß{:)kzD‡;&2~1'¤“ïÙßa¶Õº®íª5Ñúaimçá’o’8•tÆphânÇuºl¤Ûmë¸é«ÝÙøéíû’7�...@gucqÓŠhÙ¶cfØÍ\çðäLJÎ^8$}äí=i²aj©ôœ «‰J_u/¥<ƒ‰%*áÓˆÎ;ˆ¦ TÐö©6)WûjØZ`ü dÂsæ–Ýhq...@m5ÐqeebÜîíp]›q’Üx̧yn8pÿ߇3ip5–¨¿´©úgl2å©k)aéÒû¼5ã‚s8žTæÕæ*ýµ)Q’ä4óp›¦0?ÌU]Br+ç\»]_"éŸpTŒŸXU<dÂsæ–Ýhqb%...@m5Ð%14qe%01ebÜî%10íp]›q’Üx̧yn8pÿ߇3ip5–¨¿´©úgl2å©k)aéÒû%15¼%075%04ã‚s8žT%10æÕæ*ýµ)Q’ä4óp›%07¦0%14?ÌU]Br+ç\»]_"éŸpTŒŸXU>] Èò “¬gK®tTxò^i‰É4‡ Rè ¤à8Y«›`ü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Î’šÛ27 ó";=&b*Sê eÆ7xž|p è:@Ö[YÓÚq.1Ñs¸'€b2BOÓ_!è>¡¦²Ö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¤öñÝð:ž]ƦMZíñ´%®lxqÛ”ûJ/>†ÀZüõsW3Ê«³ÒF©Öé<…Ñ'ö¢ƒki[6•…äÖhik{£ªóœt÷©\Ï£ènv´¡%...@ÉrŽ«sfgÙs^c1Ùi[Ž,à$¦¢ØÓåm_Pöl¡Ö4m¹à§wI¸: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ó$µ ÁÇVJxq4 û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[aIsñ›rTMÿ'uCÎo|aXôŽ [iù5¼qèÏ·ðȦ¹ê‡¿WWòÕÉðb\¢9á™1œÆû/ )*Ád²¯) R jH(#$pÇunÇ3ýÙsŸîÜçëWVtF±×‰^Ñâ>¬Ó¾kd6áÛã...@„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
-- http://mail.python.org/mailman/listinfo/python-list