-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 18/04/12 15:38, Jim Sanders wrote: > It's disappointing there isn't a simple "unhex()" function to do the > reverse of the already existing function. That would be a very > elegant solution to this issue, as I am so close.
unhex isn't anywhere near as simple as you think. For your specific case it is, but in the general case it isn't. For example what character set is used? What do you do when an error is encountered (eg an odd number of digits, invalid hex)? Also remember that SQLite is a library. It is running directly inside the app, and is not on the other end of a network connection with a surly administrator. You can modify it and enhance it in any way you deem fit. > I will investigate the dynamic extension thing tomorrow. I don't have > any experience with that, so I'm not sure if it would work but it's > worth looking into. There is a very dated reference page here: http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions > In the worst case scenario I could add PHP into the mix and open the > SQLite databases directly to do a query + host processing. I just > hate to break out of the confines of the Spiceworks application and > it's built in reporting capabilities because I was hoping to share my > finished report back with their community as it would be very useful to > a lot more folks. It looks like Spiceworks has a builtin extension mechanism. At the very least it has a wierd batch language, but presumably it can call external binaries/scripts. Maybe the user groups will have some advice on other approaches. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk+PSyYACgkQmOOfHg372QQ9/gCgwOYadJdd5HaO+Vl3TatT85nW PowAoJZXUHv/mwzBwM+IY7CvFRaoSnZu =Kp6j -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users