U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » Community » Newbie corner » HowTo bind StaticImage to SQL

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: HowTo bind StaticImage to SQL [message #43615 is a reply to message #43611]

Sat, 13 September 2014 22:26

Didier is currently offline

Didier
Messages: 736
Registered: November 2008
Location: France

Contributor

Hello Jerson,

To put images in SQL I use this:

//========================================
//          IMAGES
// ========================================
TABLE_(IMAGES)
	INT_	(IMG_ID) PRIMARY_KEY AUTO_INCREMENT
	LONGRAW_(IMG_DATA)
END_TABLE

And to update image in sql:

	sql * SqlUpdate(IMAGES)(IMG_DATA, SqlBinary( JPGEncoder().SaveString(img) ) ).Where(IMG_ID == resId);

In fact the image is stored as a string (I don't remember why: it's been 3 years since I wrote this code, maybe because I export it in XML afterwards

Hope this helps

Report message to a moderator

Send a private message to this user

[Message index]

		HowTo bind StaticImage to SQL By: jerson on Sat, 13 September 2014 06:32
		Re: HowTo bind StaticImage to SQL By: Didier on Sat, 13 September 2014 22:26
		Re: HowTo bind StaticImage to SQL By: jerson on Sun, 14 September 2014 05:16
		Re: HowTo bind StaticImage to SQL By: jerson on Mon, 15 September 2014 07:58
		Re: HowTo bind StaticImage to SQL By: koldo on Tue, 16 September 2014 09:46
		Re: HowTo bind StaticImage to SQL By: jerson on Tue, 16 September 2014 10:25
		Re: HowTo bind StaticImage to SQL By: koldo on Wed, 17 September 2014 08:09
		Re: HowTo bind StaticImage to SQL By: jerson on Wed, 17 September 2014 12:32
		Re: HowTo bind StaticImage to SQL By: koldo on Thu, 18 September 2014 08:40

Previous Topic:	StaticImage cannot show BMP file
Next Topic:	>Port 9(say port 10)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sun Aug 24 18:57:08 CEST 2025

Total time taken to generate the page: 0.04449 seconds