List:General Discussion« Previous MessageNext Message »
From:Victor Subervi Date:October 16 2009 4:57pm
Subject:Re: Inserting an Image
View as plain text  
Well, I've spent the last 2 days chasing my tail just to discover that there
was some screwy python deal going on. The following code works:

      sql = "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'
where ID=%s;" % (name, title, description, price, bedrooms, bathrooms,
conditions, acreage, construction, location, estate, address, furnished, id)
      cursor.execute(sql)
      cursor.execute('update productsX set pic1=%s, pic2=%s, pic3=%s,
pic4=%s, pic5=%s, pic6=%s where ID=%s;', (pic1, pic2, pic3, pic4, pic5,
pic6, id))
Notice I have to use two separate sql calls and the only differences between
them are that the first have the strings in quotes AND there is a % sign
between the string widgets and the variables that replace them. That's it!
Wonder what the *#&^%( difference that makes.
V

On Thu, Oct 15, 2009 at 4:54 PM, Michael Dykman <mdykman@gmail.com> wrote:

> Victor,
>
> again, your question has more to do with python usage than MySQL
> per-se..  you would be better off pursuing these questions in a python
> forum.
>
>  - michael dykman
>
> On Thu, Oct 15, 2009 at 3:28 PM, Gavin Towey <gtowey@stripped> wrote:
> > "Image in string form"  sounds like you're not inserting binary data,
> rather some sort of encoded data.  Even if it is binary, you'll have to
> escape at least end quote characters, you can see clearly at the top of your
> data there is :
> > 'ÿØÿà JFIF ÿÛC "" $(4,$&1'
> >
> >
> > Another thing to think about is storing image data directly in a database
> is often not a good idea. See these links for more info:
> >
> >
> http://mysqldump.azundris.com/archives/36-Serving-Images-From-A-Database.htmland
> http://hashmysql.org/index.php?title=Storing_files_in_the_database
> >
> > Regards,
> > Gavin Towey
> >
> > -----Original Message-----
> > From: Victor Subervi [mailto:victorsubervi@stripped]
> > Sent: Thursday, October 15, 2009 12:05 PM
> > To: mysql@stripped
> > Subject: Inserting an Image
> >
> > 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| " ÿÄ %5DTUƒ“¢£ÑñÿÄ ÿÄ ÿÚ
?œ*‹RP’¥¨% d’pý> ô¨2mÒžÚ ¦ ÚRÑ¥¬ò
guD|!%bO :ðç’ Z…æ-² {‘£6 Ô÷“âNI=äÒfÓ
ø/RhËîR”³q1 QüÇ#¸$Š·÷F_Ë ë}……áRTdH ó
> > Á#ÐU“ö*DÙõ¨Yt]ž îêÑ +p}5ùêÿ¹F † vã
Êöy5Ô‚\ˆëO Žc 'ö(Óõku-´^4õÊÚ Ú£8Ðð%$
> ì84
> > Ú*ø G¥­¼×CP U
> > ¤¡%KPJR2I8T+´½¨®{ß{:)kzD‡;
&2~1' ¤“ ïÙßA¶Õº®íª5 Ñú
AiMçá ’O ’8 •tÆpH ŠhÙ¶ cFØ
Í\çðäLJÎ^8$} ä í=i² Aj
©ôœ «‰J_u
> > /¥<ƒ‰%*áÓˆÎ;ˆ¦
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
]ߊ󌼀ÑK
> > ,¥Iü29 ƃž6™iU‡]Ý£ È/²G
5~xÇ£8öT۱͡§SÀ
›«¿é %®a d“Ÿ g ¨Ãe1. õõœÛ æû2
ëËG$4>9' )$xç h3ö‰´Ë®­ ôHî.%œ,†ã
ຠx S× ‡Ž3Nû
> > ÐËAûêº5Œ‚ˆ ¨qÁৠˆ
ÓÜh±ìËOÏÚV¢‰ >`G#Ú‡ ‘ž¨ t
> > –›-LjFžhÈÂXy¥(… \8) íZ Ò«õùµMì
> h‚µ<öwŽ7€É
> > 1Î’šÛ2­7 ó ";= & b*Sê e Æ7xž|p è:@Ö[YÓÚq.1
Ñs¸'€b2 BOÓ_!è > ¡
> >
¦²Özòbm©}÷ƒêÂ`ÂFâ
¤ $ õ Š<ÆoÚíkfÐ… õ¤
> > %ÁÑE<Â|Oœ¯ ŒÌM4Û-!¦
Úf…ï9äéiîþÑ
> > j³é#>‚+™ö‘lU§]^¢) 'Ê”êüÅùéýÊ
ñ÷?jÔÛ®¯iÙ®nÇœ­øÅG‚^
ˆßö„â3å2º}ZjþÙ¾M/_ ß½E
t_Ä™õiþ °ÖZogV÷ m qŽ¾´¤
>
¼:°2zð律¿‰³êÓü)/bC
> > 7¶ Ë´ ß.€Ò
ÿJ:ÛÕÀ÷J«ZÍá i:9ò•(5
ಔŽ' ƒŠ½¥‡ö¡­x ‡ Ž>©UMT3µ-
×ðSýÐ 5†Ñ5
> > «.³6Yf Õ‘ ºØ‚ ê¬
> ½Ô±"T‰Kß’û¯+½Å†Öë‹8J ’¢£à
:~Ùö˦ê‰Ó ¹H6æ
8–ä6¤ öñ Ýð
> :ž]ƦM
> > Zíñ´%®lxqÛ”ûJ/>†ÀZ,à$
¦¢ØÓåm_Pöl¡Ö4m¹à§w
I¸:8„Ÿ£Èîô ø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ýâþ‘ùî ƒ
> ý¤Î–[L+
> > ²=¶ØÂYŠÂwP‘ûÉ=I™­ŒÍ!aÓ»IÑŒZ-­0ÓÞZ§BŠœß)g)'xžGˆ©1‹d(÷ 7 c6‰’’„¾ð rÂF Ud[aI
> > sñ›rTMÿ'uCÎo|aXôŽ [iù5¼qèÏ·ðȦ¹
ꇿWWòÕÉðb\¢9 á ÜçëWVt F±× ‰ ^Ñâ>¬Ó
¾ Kd6áÛã5 3@„4ÒwRœ’N ¤“í¢-º I dEŒÓOJP[î!8SŠ
> > ¨õáA“E P QE H»QÙë Ò ^Œ[bï $0ò‡ Ïq~ â
BOy§ª(8®óg¸Ø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
> >
> > The information contained in this transmission may contain privileged and
> confidential information. It is intended only for the use of the person(s)
> named above. If you are not the intended recipient, you are hereby notified
> that any review, dissemination, distribution or duplication of this
> communication is strictly prohibited. If you are not the intended recipient,
> please contact the sender by reply email and destroy all copies of the
> original message.
> >
>
>
>
> --
>  - michael dykman
>  - mdykman@stripped
>
> Don’t worry about people stealing your ideas. If theyats!
>
>   Howard Aiken
>
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