use a (for example python or tcl) script language and do the insert
with a prepared statement
Greetings
Georg
Michael Neuber schrieb:
Auer, Wolfgang schrieb:
Hello,
Do you depend on the CLI programm. You could use SQL Studio to do the
insert.
Regards
Wolfgang
-----Original Message-----
From: Michael Neuber [mailto:[EMAIL PROTECTED] Sent: Mittwoch,
16. August 2006 16:18
To: maxdb@lists.mysql.com
Subject: RE: How to Insert linefeed chatacter in a string: Inserting
Linefeed into String with following //
I am looking for a solution to following problem:
I wanted to insert a string to the a maxDB (7.5.00.34)
containing the a CRLF (Carriage Return Line feed, here marked as \n) :
insert into testtable ( stringattribute) values('ABCDE \n\\www.abc.de')
Had similar probs as described in the thread
RE: How to Insert linefeed chatacter in a string - Derek M. A. Lee-Wo,
June 2 2006 2:18pm
Though, in my case ist really a VARCHAR attribute, and I managed to to
it with a CRLF character in many cases.
However, when the next chars are 2 slashes on the new line, the CLI
obviously thinks there's the end of the previous command, though I am
still writing a string ( closing ' has not yet come !)
Is there a way to make clear to the CLI that I am still writing a string
content and that the new line's // belong to that content?
Regards
M.Neuber
Hm... I'd say I indeed depend on CLI,
it's script based mass data upload what I am doing here.
Experience tells that SQL Studio is not the right thing to use then..
;-)
But...
I found a solution, not toooo nice, but a easily feasable work around:
Its just cutting the string which makes CLI somehow blind for the //.
IOW:
insert into testtable ( stringattribute) values('ABCDE
' ||'//www.abc.de')
-Note that there is a CRLF between the two lines.-
This works.
(BTW: Made a mistake in the first mail, its //www.... not \\www....)
Thanks for replying anyway. :-)
M.Neuber
--
Georg Thomé Dipl. Inf. (FH)
IEE Luxembourg S.A.
IT dept. / software development / DB-administration
tel. 00352/7289896810 fax 00352/7289896109
www.iee.lu / [EMAIL PROTECTED]
This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you are not
the intended recipient and have received this e-mail in error, you are hereby notified that any review, copying or
distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal from your
system. Thank you for your co-operation.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
