Hi,
text constants have to be set between single quotes:
insert into sometable values ( 5 , 'text' )
If the text contains a single quote, double it:
insert into sometable values ( 5 , 'Don''t do this' )
Martin
Mauricio schrieb:
> Hi,
>
> I would like to
>
> insert into sometable values ( someid , text ) ;
>
> but 'text' contains a few commas, and then it
> would look like
>
> (...) values ( someid , text , text2 , text3 ) ;
>
> Is there a syntax to do that properly, maybe
> like C string constants ("text,\"text\",text\n")?
>
> Thanks,
> Maurício
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
* Codeswift GmbH *
Traunstr. 30
A-5026 Salzburg-Aigen
Tel: +49 (0) 8662 / 494330
Mob: +49 (0) 171 / 4487687
Fax: +49 (0) 12120 / 204645
[EMAIL PROTECTED]
www.codeswift.com / www.swiftcash.at
Codeswift Professional IT Services GmbH
Firmenbuch-Nr. FN 202820s
UID-Nr. ATU 50576309
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
