Inconsistent results in simple script

JOHN PATTEN johnpatten at
Wed Nov 16 15:43:28 EST 2016

Hi Craig,

I have about 1000 students that are in a library system showing them as having checked out an iPad. In the library system it uses the student username and the barcode as the item identifier.

I have another list that shows our iPads by barcode and serial number.

Unfortunately there is no way for me to pull a report that shows the student username and the device serial number in one report. So I was essentially searching for the barcode in both lists and then combining the username from one and the serial number from the other. Ultimately ending up with a list that consists of student username and device serial number.

I hope that is a little clearer. 

Thank you!

John Patten

> On Nov 16, 2016, at 12:22 PM, dunbarx <dunbarx at> wrote:
> HI.
> So, a single list. What is the relationship between the fact that a
> particular barcode refers both to a student and a serial number? In other
> words, if you had a single list, how would "12345" relate to both "john doe"
> and "SDTKNY12345"?
> Would you simply have two lines:
> 12345,johndoe
> 12345,SDTKNY12345 
> Also, I do not understand what you mean when you said:
> "I have cut my username list down to about 30."
> Does that mean that in your 1000 line first list, the usernames appear with
> multiple barcodes? Or are those lines empty? Or is that list now only 30
> lines long?
> It looks like this begs for an array, but I am missing what you expect as
> output. Whatever it is, the procedure will be simple. But I cannot even
> start to advise about that procedure until I know what the answer is.
> Craig
> --
> View this message in context:
> Sent from the Revolution - User mailing list archive at
> _______________________________________________
> use-livecode mailing list
> use-livecode at
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

More information about the Use-livecode mailing list