>- 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 -<
