Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
OT: Allow Zero Length
- Thread starter jalbao
- Start date
TruthInSatire
Programmer
maybe rudy knows better but this doesn't look fun.
I thought there was a paramater you could set to "true" or "yes" in the sql. I can't find that now. I did find this though... not fun.
Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)
I thought there was a paramater you could set to "true" or "yes" in the sql. I can't find that now. I did find this though... not fun.
Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)
- Thread starter
- #3
Thanks bomboy, but my db accessability is limited. The db guy for our .net app created a wrapper that only allows sql statements. I can't create my own custom connections and objects in order to access the ado property.
It's very odd to me that setting this prop via sql appears to be non-existent... oh well, typical I guess, eh? It's ALWAYS something.
Thanks for your input though - I appreciate it.
btw: I miss writing in CF - this .net stuff is driving me mad.
It's very odd to me that setting this prop via sql appears to be non-existent... oh well, typical I guess, eh? It's ALWAYS something.
Thanks for your input though - I appreciate it.
btw: I miss writing in CF - this .net stuff is driving me mad.
- Thread starter
- #4
Well it looks like I'm outta luck. Found the following link:
According to the article, there is no way to set the "Allow Zero Length" property via sql.
According to the article, there is no way to set the "Allow Zero Length" property via sql.
TruthInSatire
Programmer
you could always just insert NULL's I've adopted that pollicy and love it.
When I used to allow 0 len characters i'd get hung up in my where clause sometimes. half the time the value would be "" and the other half it would be NULL which are both different values.
WHERE value = "" or value is null
if you don't allow 0 len you don't have that problem.
Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)
When I used to allow 0 len characters i'd get hung up in my where clause sometimes. half the time the value would be "" and the other half it would be NULL which are both different values.
WHERE value = "" or value is null
if you don't allow 0 len you don't have that problem.
Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)
sorry i'm late, and sorry, i don't know
but i agree with douglas adams, you should simply allow nulls, and then insert null instead of an empty string
rudy
SQL Consulting
but i agree with douglas adams, you should simply allow nulls, and then insert null instead of an empty string
rudy
SQL Consulting
TruthInSatire
Programmer
thanks rudy. but doug is dead 
he wrote hitch hikers guide to the galaxy. My name is travis.
Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)
he wrote hitch hikers guide to the galaxy. My name is travis.Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)
- Status
Similar threads