On Wed, 3 Sep 2008 07:51:03 pm Ron_1st wrote: Finally solved.
I did try and try inserting the E in the hint, but put in inside the qotes and not outside it so this works: insert into Insert into clin_consult.temp_image(piccie) values (E'\\211PNG\\015\\012\\032\\012\\....') Thanks to everyone who helped. Syan mailed my via the postgres novice list. I never could intrepret documentation very well. Regards Richard > > On Wednesday 03 September 2008, richard terry wrote: > > On Tue, 2 Sep 2008 09:48:55 pm you wrote: > > Ok, that got me a bit further: This is the resultant (failed) insert > > query . First try using $$ as the delimiters as per my code gives this > > and fails: > > > > insert into > > clin_consult.temp_image(piccie)values($$\\211PNG\\015\\012...... > > ---8<----- > > > \\251\\370\\003>\\241\\324n\\304~\\303\\331\\000\\000\\000\\000IEND\\256B > >`\\202') WARNING: nonstandard use of \\ in a string literal > > LINE 1: insert into clin_consult.temp_image(piccie)values('\\211PNG\... > > ^ > > HINT: Use the escape string syntax for backslashes, e.g., E'\\'. > > > > > > Perhaps someone can understand this and help > > > > Regards > > > > Richard > > In mysql like syntax the command would be > > > LINE 1: insert into clin_consult.temp_image(piccie)values('\\211PNG\... > > ^ > > The ^ is at the position where th error is. > Is the field temp_image existing? > Is the _ also allowed in field names as it looks allowed in table names? > > What is your field an table name and are they following the syntax rules > of posgresql, the database system you use, as I rememeber well? > > > > Just reading what I typed I see clin_consult.temp_image(piccie) (values) > > Do you mean the field -=- clin_consult.temp_image -=- in table -=- piccies > -=- or the table -=- clin_consult.temp_image -=- in filed -=- piccies -=- > ????? > > > > Should the fieldname not be surrond with quotes while a dot in the > name in most caases is not allowed. > As far I know the only safe are just only alphanummeric and underscore > and a name as -=- clin_consult.temp_image -=- looks to me as invalid > without qoutes surrounding this name constuction. > > Try to add a field as 'myfiled' in the table and insert into that filed. > to find out you current fieldname is a invalid field name.Best regards > > > Ron_1st ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user