>- see footer for list info -< I don't know about these things - but are they sure its base64 encoded?
I went here: http://www.motobit.com/util/base64-decoder-encoder.asp and tried to decode it, and sure as hell didn't get 9925 And when I tried to encode 9925, I sure as hell didn't get 02P5 I then I wrote a little script to convert the number to all bases from 2 to 36 And this gave me 10011011000101 111121121 2123011 304200 113541 40636 23305 14547 9925 7503 58B1 4696 388D 2E1A 26C5 205E 1CB7 1897 14G5 11AD KB3 IHC H5D FM0 EHJ DGG CID BN7 B0P AA5 9M5 93P 8JV 83K 7NP Which doesn't help you either. So I'm flummoxed. What is that number? Are you sure they haven't just started creating random alphanumeric strings? Rich -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lee Fortnam Sent: 12 April 2006 16:59 To: 'Coldfusion Development' Subject: RE: [CF-Dev] Urgent - Base64 Arithmetic >- see footer for list info -< Cannot do it in the source application but could create a table which holds the BASE64 equivalent for a big list of numbers, say 1 to 50000 and then use this as a look up table. Issue is, how do I get the translation from 9925 to 02P5, ToBase64 gives me OTkyNQ== which as you can imagine is not what I was expecting. Lee Fortnam -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Lynch Sent: 12 April 2006 16:52 To: Coldfusion Development Subject: RE: [CF-Dev] Urgent - Base64 Arithmetic >- see footer for list info -< Failing another solution, create your own table to join the two. If you can effect the data as it comes into the system then you can add a row to this table for every new patient. Adrian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Lee Fortnam Sent: 12 April 2006 16:38 To: 'Coldfusion Development' Subject: [CF-Dev] Urgent - Base64 Arithmetic >- see footer for list info -< Dear All, I am working with a program called InPS Vision (a medical system which uses FoxPro DBF files at the back end). Have hit a problem in that the client wants automated export of information which in itself is not a problem and I have received help from this group in deciding the best way to do it. However, in some tables the patient is referenced with a PAT_ID (in this case equal to 9925), where as in other tables they are referenced using the MASTER_ID of 02P5. I have been trying to find (in amongst the hundred odd tables) a table which links 9925 to 02P5, then some bright spark highlighted the following: "02P5 is 9925 and both are numbers! 02P5 uses 'base64' arithmetic and is case sensitive thus 02p5 = 11589 the sequence is 0-9 ? @ A-Z a-z for the numbers 0-63" The problem is, I need to be able to run dynamic queries against the DB and don't see a way to get to 9925 from 02P5 or vice versa, I have played with ToBase64 but to no avail. Any Ideas????? Lee Fortnam _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
