I'm using the TCL binding of SQLITE and was trying to figure out how to
enter various characters into a text column. To enter a slash, all I
normally would do is to append another slash to it. However, this only
works fine if the slash is not the last character in the field. Consider
the following:
% db eval "insert into t1 values('\')"
% <-- no character
% db eval "insert into t1 values('\\')"
% \\ <-- slash did not escape!!
% db eval "insert into t1 values('\\TEST')"
% \TEST <-- returns as expected
% db eval "insert into t1 values('TEST\\')"
% TEST\\ <-- slash did not escape!!
% db eval "insert into t1 values('\\TEST\\')"
% \\TEST\\ <-- now not even the first slash was escaped!!
In short, what I'm asking is how can I insert text with one slash at the
end?
-Shamil D.
The information transmitted is intended only for the person(s)or entity
to which it is addressed and may contain confidential and/or legally
privileged material. Delivery of this message to any person other than
the intended recipient(s) is not intended in any way to waive privilege
or confidentiality. Any review, retransmission, dissemination or other
use of , or taking of any action in reliance upon, this information by
entities other than the intended recipient is prohibited. If you
receive this in error, please contact the sender and delete the
material from any computer.
For Translation:
http://www.baxter.com/email_disclaimer
