Zugg Software :: View topic

Apprentice Joined: 14 Sep 2007 Posts: 167 Location: aztx

I have a trigger, it captures lines. It puts these lines into a database variable using #addkey
Line1 this is line one
Line2 this is line two
... and so on.

Sometimes, however, the entries for the next lines get put into the data of the last entry. Is this because of the | character?
This is what the problem looks like:
Line1 this is line one
Line2 this is line twoLine3 this is line threeLine4 this is line four

So, how do I fix this? Did I provide enough information for a solution?

Posted: Sat Oct 15, 2011 10:31 am

yes... that is the issue, though i would think it would tend to split your entries premptively...
its a simple fix as well, dont use any of the 'special' characters inside a variable if you can help it

TempEntry=%replace(%1, "|", "_")

That will use an underscore instead of a bar.

#ADDKEY blahblah {@TempEntry=some value}

unfortunately... you will likely have to just delete the current incarnation of the variable

P.S. CMUD, the new version, offers nested (json) DBvariables

Apprentice Joined: 14 Sep 2007 Posts: 167 Location: aztx

Thanks.. I tried replacing them with ~|, but another character would do the job.
Update:
For stringlists and database variables, replace these three characters: | ) (
That's what I've found so far.