List:General Discussion« Previous MessageNext Message »
From:Victor Subervi Date:October 15 2009 7:04pm
Subject:Inserting an Image
View as plain text  
Hi;
I have successfully inserted images, like yesterday, before into MySQL with
the following code:

      sql = 'update productsX set pic1="%s" where ID=2;' % pic1
      cursor.execute(sql)
where pic1 is simply an image uploaded through a form then sent over without
any alteration to another (python) script that uploads it.  Printing it out
looks like this (other variables included):

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 !1A Qa "qs
³ 27Bbc‚ #46Rrt‘¡±²
$'3C’%5DTUƒ“¢£ÑñÿÄ ÿÄ
ÿÚ ?œ*$ý <%60ú@$ý> ô¨2mÒžÚ ¦
ÚRÑ¥¬ò guD|!%bO :ðKT[%¦-² {‘£6
Ô÷“âNI=äÒfÓ
ø/RhËîR”³q1 QüÇ“ƒŸ ƒE Š Š( (¢Š Š(
(¢Š Š( ×ê
´{ –m#¸$Š·÷F_Ë ë}……áRTdH ó
Á#ÐU“ö*DÙõ¨Yt]Óõku-´^4õÊÚ Ú£8Ðð%$
ì84
Ú*ø G¥­·T Vû#µc æ ·uÏ;
Ö"ÓusN\\Ü‹5{ÑʸvoòÝû@
é ¼×CP U
ë¸é«ÝÙ øéí
û’7¼¡@guC q Ó ŠhÙ¶ cFØ
Í\áÓˆÎ;ˆ¦ TÐö©6)WûjØZ`ü
dÂsæ–ÝHQB E@ m5Ð QE EbÜî
íP]›q’Üx̧yn8pÿ߇3IP5–¨¿´©úgL2å©K)aéÒû ¼ 5 ã‚s 8žT
æÕæ*ýµ)Q’­ä4óp› ¦0 ?ÌU]B
r + ç\»]_"éŸ pTŒŸXU] Èò ­
“¬gK ®tTxò^i‰ É 4‡ Rè ¤ à8
Y«›` üM ]ߊóŒ¼G$4>9' )$xç h3ö‰´Ë®­
ôHî.%œ,†ã ຠx S× ¸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¢ö…;= & b*Sê e Æ7xž|p è:@Ö[YÓÚq.1
Ñs¸'€b2 BOÓ_!fÐ… õ¤
%ÁÑ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þzð律¿‰³êÓü)/bC
7¶ Ë´ ß.€Ò ÿJ:ÛÕÀ÷J«ZÍá i:9ò•(5 ಔŽ'
ƒŠ½¥‡ö¡­x ‡ Ž>©UMT3µ- ×ðSýÐ 5†Ñ5
«.³6Yf Õ‘ ºØ‚ ê¬ ¼ xà óñ çÆ vC¨e†Öë‹8J
’¢£à :~Ùö˦ê‰Ó ¹H6æ 8–ä6¤ öñ Ýð
:ž]ƦM
Zíñ´%®lxqÙs^C1ÙI[Ž,à$
¦¢ØÓåm_Pöl¡Ö4m¹à§w
I¸:8„Ÿ£Èîô ø‘º Í t¢‚
û¢t–˜š–*2 ix †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Ðù Ëw—
†Có$µ Á ÇV Jxq4 û 9Ùµ
ýRýâézϪ- V÷®fÞ%%¤ü$žÍ´ñqÓ¹É)ê
pêE$Z6·÷¹ íÖK4NÖâÓK
H|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(÷
7 c6‰’’) R jH(# $pÇu
nÇ3ý ÙsŸîÜçëWVt F±×
‰ ^Ñâ>¬Ó ¾ Kd6áÛã5 3@„4ÒwRœ’N
¤“í¢-º I dEŒÓOJP[î!8SŠ
¨õáA“E P QE H»QÙë Ò ^Œ[bï
$0ò‡ Ïq~ â BOy§ª(8®óg¸Øç. Ú#±d
ñCƒŸˆ<ˆñ *FûŸ,
ŸªÝ»¸Ùò{sGu];U Ð?˾
eH»vü ¦¯å5] ~@'õ§?', '', '', '')

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
Thread
Inserting an ImageVictor Subervi15 Oct
  • Re: Inserting an Imagejoao15 Oct
  • RE: Inserting an ImageGavin Towey15 Oct
    • Re: Inserting an ImageMichael Dykman15 Oct
      • Re: Inserting an ImageVictor Subervi16 Oct