Hi - a legacy database at work contains a bytea field that I want to get the information out of. It's rich text that was for whatever reason, was stored as a blob to keep the formatting codes intact -- I'm not even sure what that means since no one here knows much about it and there is no documentation on the system. Does anyone know how to convert the returned query contents of this bytea field to text (or richtext?) with livecode? It looks like this
x7b5c727466315c616e73695c616... etc. when my basic query is put "SELECT c.reportnumber, c.reportblob from cases c WHERE c.ID = " & tCaseID into tQuery Thanks! I'm a layer2 guy at work but am planning to use Livecode as my programming gateway drug =) _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
