Sort Command in 3.5 is adding lines to a variable

stephen barncard stephenREVOLUTION2 at barncard.com
Thu Jul 2 18:42:19 EDT 2009


Pasted-in NULL characters can also train wreck the GLX2 script editor.  I
use Tex-Edit  (not Textedit) for quick text cleaning.    I've seen text from
a database serving Wordpress where users had pasted in NULLs with their
text, not to mention curly quotes, etc.

-------------------------
Stephen Barncard
San Francisco
http://barncard.com


2009/7/2 Paul Looney <support at ahsomme.com>

> Richard,
> It has been a while...
> I went back and checked my records. The problem (probably related to the
> number of characters per line) was thousands of NULL characters in the
> variable. When I removed the NULLs, everything worked fine.
> So now I always trap for NULLs before doing a sort - and have not had a
> repeat of this problem.
> By the way, we are not sure where the NULLS came from. Our best guess is
> that it has something to do with pasting text from a word processor into one
> of our notes fields.
>
> I, too, would like to know the new limit. Mark?
> Paul Looney
>
>
> On Jul 2, 2009, at 12:52 PM, Richard Gaskin wrote:
>
>  Paul Looney wrote:
>>
>>> I have had the opposite happen.
>>> On a large variable, sorting removed lines.
>>> Rev 3.0, OS X 10.5
>>>
>>
>> If memory serves, that was the result of a limitation of the sort command
>> where it could only be used reliably on data in which no single line
>> exceeded 65,535 chars.
>>
>> According to the v3.5 Engine Change Log, that was fixed in v3.5:
>> <http://quality.runrev.com/qacenter/show_bug.cgi?id=5932>
>>
>> Unfortunately the current limit is not noted in the docs for the Sort
>> command, nor in that report, so I don't know exactly what it is in the
>> latest version.  But 64k of text was a lot for a single line, so whatever
>> it's been raised to should be plenty for most common tasks.
>>
>>
>> Timothy's report of the trailing blank line may be a regression error
>> which had been marked as "fixed" in the 3.5 Engine Change Log:
>> <http://quality.runrev.com/qacenter/show_bug.cgi?id=7809>
>>
>> --
>>  Richard Gaskin
>>  Fourth World
>>  Revolution training and consulting: http://www.fourthworld.com
>>  Webzine for Rev developers: http://www.revjournal.com
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



More information about the use-livecode mailing list