On Mon, 8 Oct 2007 10:03:40 -0700 (PDT), Ken wrote
> is there a built in function to display numeric values as 
> hexidecimal strings?  to_hexstr (40) would display 0x28

hex() isn't quite what you want.  hex(40) gives 3430, since '4' is 0x34 and
'0' is 0x30.  Moving on...

This is the sort of work I prefer to leave up to the application using SQLite.
 SQLite is a talented, efficient, obedient, and tireless reference librarian,
but asking SQLite to write your thesis is going too far!  But you can sure ask
it for all the facts, arguments, and bibliographic references you need.  It's
your job (or, ditching the school metaphor, the application's job) to present
the data to the consumer in a format palatable to same.

Of course, that's just my take on things.

If you still think you have a need for to_hexstr(), you can add it very
easily.  See http://www.sqlite.org/tclsqlite.html#function .  (By the way,
Author, you might want to rename the example function to not collide with the
built-in hex() function.)

Andy Goth

To unsubscribe, send email to [EMAIL PROTECTED]

Reply via email to