coolio. good suggestions.
many thanks all.
barry.b
--~--~-~--~~~---~--~~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
You received this message because you are subscr
I've used in the past, and it has worked well for me.
Or use a UUID... not much chance of people picking that.
Mark
On Thu, Feb 12, 2009 at 8:51 AM, Nando wrote:
>
> As I know him, Hal seems to think things through very thoroughly, and
> he came to the conclusion that in CF, you need a string
As I know him, Hal seems to think things through very thoroughly, and
he came to the conclusion that in CF, you need a string to represent
null. I think what he came up with is good enough for our purposes,
unless the field is named "Keyboard Graffiti" or something like that
and your application i
I should add that I'm concious of legit data being confused for the
sentinal values, but I recognise Hal Helms collection (via Nando) of
pipe symbols, underscores and a backslash is pretty unique.
hmmm... perhaps I can get away with using some of the less common
ASCII chars - ones not readily ace
@Bob
we need to know whether a notes/comment field has ever had anything
added since the record was first created (ie if it remains NULL).
Empty string could hide something being added and later removed.
Admittedly, the best alternative is a full blown audit trail but
that's a bit heavy handed co
What about using "|\||_||_|_" - a suggestion I picked up from Hal Helms
Nando
On Wed, Feb 11, 2009 at 3:07 PM, Bob Silverberg
wrote:
>
> Interesting question. Interesting in that it made me realize that I
> have never had a need to do this. I think that any time I am allowing
> nulls in stri
Interesting question. Interesting in that it made me realize that I
have never had a need to do this. I think that any time I am allowing
nulls in string fields the app doesn't really care whether they're
specifically nulls or not. So I just accept the default of "" and it
hasn't caused any pro