GMan's Mods & Stuff — Blobs :S

Re: Blobs :S

null@example.com (gman) — Tue, 07 Mar 2006 18:20:46 +0000

yes try it as a string wrapped in single quotes. before you add it into your SQL, do the escapeString method on it.

Re: Blobs :S

null@example.com (gavinb) — Fri, 03 Mar 2006 08:45:04 +0000

so do as a string?

Re: Blobs :S

null@example.com (gman) — Fri, 03 Mar 2006 02:58:54 +0000

k. try this... there is already a method called escapeString(). you need to pass in your binary info to this before you add it into your SQL statement. this should safely escape any characters that would cause your query to break. then simply build your SQL statement to include the escaped blob data and execute.

Re: Blobs :S

null@example.com (gavinb) — Wed, 01 Mar 2006 14:34:43 +0000

thanks dude, it'll save me having to use PHP or ftp

Re: Blobs :S

null@example.com (gman) — Wed, 01 Mar 2006 14:07:06 +0000

will try to look into this tonight.

Blobs :S

null@example.com (gavinb) — Wed, 01 Mar 2006 10:08:48 +0000

Hey GMan, just wonder i know its cheeky but i'm kinda desperate, in the mysql u have ways of getting int val's double, long etc, but no way of getting blob data? is this something u could impletement?

a blob is a binary object (i.e used for storing images) and shouldnnt be too hard for u to do

well thanks