On 05/15/2009 03:41, Dennis Cote wrote:
>
> Your database would be simpler if you simply combined these two tables
> into a single table in the first place. It would eliminate the need to
> combine them for this type of query. The tables already have a type
> field to distinguish the email
This isn't a Sqlite question per se, but I know there are some SQL gurus
here who might have some insight into this problem. I apologize for
being off-topic; I can be shameless when I need help. :)>
I have three tables, N, P and E. N contains the fields id and name. The
other two each contain
On 10/21/2008 10:50, Evan Burkitt wrote:
> Roger Binns rogerb-at-rogerbinns.com |Sqlite| wrote:
>>
>> You have the full source to the shell and can change the text printing
>> routine to do whatever you want
>
> Yeah, I know, but that's, like, work. :)
>
> What I w
Roger Binns rogerb-at-rogerbinns.com |Sqlite| wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Evan Burkitt wrote:
>> Roger Binns rogerb-at-rogerbinns.com |Sqlite| wrote:
>>> select cast(column as blob)
>> I'm glad to know this sy
Roger Binns rogerb-at-rogerbinns.com |Sqlite| wrote:
>
> select cast(column as blob)
I'm glad to know this syntax, but no dice. The nulls seem to be
insurmountable barriers.
>
> You have the full source to the shell and can change the text printing
> routine to do whatever you want
Yeah, I
I have some tables which are maintained programmatically, and which have a text
field in which I store a block of text made up of a series of null-separated
strings. I am able to read and write these fields through the program without
problem; reading via sqlite3_column_text() and
6 matches
Mail list logo