Inconsistent results in simple script
JOHN PATTEN
johnpatten at me.com
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
SUSD
> On Nov 16, 2016, at 12:22 PM, dunbarx <dunbarx at aol.com> 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: http://runtime-revolution.278305.n4.nabble.com/Inconsistent-results-in-simple-script-tp4710376p4710377.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
More information about the use-livecode
mailing list