RSS Feed: IIUG Forum: IIUG Deutsche

The IIUG Deutsche forum was created for German-speaking Informix users to exchange questions and information about Informix.

urgent | | is inserted in text field with /
Posted by: belajouza@hotmail.com (MEHDI BELAJOUZA) - Sat, 29 Dec 2007 16:49:53 EST
the goal is to insert a string containing | | in a column of
text type

when we try to insert a query containing pipe ||in a text field , the result
of insertion shows that supplementary junk slash are added to pipe as
indicated below for IDS version 9.4

1°/ sample of the begenning of the query that we want to insert in a text
field
select trim(substr(lpad(cpp_id,10,"
"),1,5)||"01"||substr(lpad(cpp_id,10,"0"),6,5))1|1|actor|pps2_6_5f||N|

2°/ result of the insertion
select trim(substr(lpad(cpp_id,10,"
"),1,5)\|\|"01"\|\|substr(lpad(cpp_id,10,"0"),6,5)),
"12","","",decode(cpp_etat,3,72,68) ,(((( ca_dt_creat - 2 units hour -
DBINFO("utc_to_datetime",946684800) )::INTERVAL SECOND(9) TO SECOND \|\|
"")::int + 946684800) *1000) ::int8,(((( NVL(cpp_dt_modif,CURRENT) - 2
units hour - DBINFO("utc_to_datetime",946684800) )::INTERVAL SECOND(9)
TO SECOND \|\| "")::int + 946684800) *1000) ::int8 from cust_access,
cust_ppaid_v2 where ca_id = cpp_id and cpp_numtel <> "default" and
cpp_etat <> 0|

3°/ the tablE structure used is indicated below and the field whre the query
tex t is inserted is sqlselect

{ TABLE "informix".query row size = 131 number of columns = 7 index size
= 12 }
create table "informix".query
(

formid serial not null ,

projectid integer,

name char(30),

database char(30),

arrayname char(30),

lockflag char(1),

sqlselect text
) extent size 16 next size 16 lock mode page;
revoke all on "informix".query from "public";

4°/ question how could we insert the query text with || without suplementary /




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to iiug-deu@iiug.org
2. Include the bracketed message number in the subject line: [25]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

http://rich-casino.atspace.com/index.html
Posted by: janatha@gamele.com (SilentlyKissable) - Sun, 30 Jul 2006 06:01:17 EDT
The following e-mail was sent to you via IIUG Deutsche Forum from SilentlyKissable (janatha@gamele.com) at IP address 203.150.49.81 (203-150-49-81.inter.net.th).



http://rich-casino.atspace.com/index.html

In this story, mice and dwarves clash with a cowardly sorceress stuck in the middle.
http://rich-casino.atspace.com/index.html
<a href



* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to iiug-deu@iiug.org
2. Include the bracketed message number in the subject line: []

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: help Byte Swaped
Posted by: mail@gramberg.de (BERNHARD GR....) - Tue, 18 Apr 2006 01:22:03 EDT
Hi,

this means as well at Unicode,
there are two bytes for a single char.
Is the first Byte the "first"part of the double-byte, or is it
the second.
Here, you can habe these two bytes swapped as well.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to iiug-deu@iiug.org
2. Include the bracketed message number in the subject line: [24]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Querix 4GL - Technical Workshop in Muenchen
Posted by: mail@gramberg.de (BERNHARD GR....) - Mon, 17 Apr 2006 17:06:24 EDT
Hallo,

nicht mehr sehr aktuell.
Wann gibt es wieder einen Workshop in Duetschland (oder Umgebung?)

Gruß Gramberg (in Berlin)




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to iiug-deu@iiug.org
2. Include the bracketed message number in the subject line: [23]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *