LinkBack URL
About LinkBacksoh that's easy wolffy ... kill the designer. that's always the answer.
oh that's easy wolffy ... kill the designer. that's always the answer.
Quote of the Month:
INSIGHT: When the going gets tough, the tough get going. The smart left a long time ago.
Questions to Ponder:
Are people more violently opposed to fur rather than leather because it's much easier to harass rich women than motorcycle gangs?
iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright © 2008 sbenj69
Sarchasm: The gulf between the author of sarcastic wit and the person who doesn't get it.
I'd have to agree.
Wolffy, in .Net I tried handling the date problem by passing the NULL value from the date field through a constructor of my class which has a Nullable Of DateTime property. Unfortunately, you can't pass a NULL value to a Nullable property for some reason
Anyway, I wanted to handle this via the query that I have to hard code.
However, I've been in touch with some DBA's trying to get this issue resolved.
jmurrayhead
If you agree, give me rep.
If you like it here...throw us a few bones to help support us.
I vote for (e)Originally Posted by Wolffy
Hmm, y'all seem to be posting in circles here JMH & mehere. Obviously sumpin' gotta change sumplace, so which would you like to do:
(a) Change the data
(b) Change the query
(c) Handle the null in code
(d) Write a sproc
(e) Kill the DB designer
?
Yeah, I tried to use Nullable<Date> as well, and found it to be too big a pain in the fistookis. Went with Date.MinValue where a null was needed. Now, how did I do that...hmmm.
Wolffy
.-- ----- ..-. ..-. -.--
Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Void where prohibited by law. Not valid in California. Your mileage may vary.
c'mon just convince your boss to let you kill the db designer
Are you sure it wasn't you
I'd get rid of the null values.
Isn't there anything you can do to fill in the null values?
Something like filling in those values with the actual data?
Once I run into something similar, but fortunately, once I started asking about the hired dates
It so happened that someone had another db where these values were and all I had to do
was import this into the db with nulls and problem solved.
Ask around, who knows, perhaps someone has this data
Okay, so I brought it up during my application demo and the guy who is above all DBA's said, "NULL is bad".
So at least him and I are on the same page. Hopefully we can come up with some solution. One of the databases that my app uses, unfortunately, is not under his control and the lady who is in charge of the data is a complete possessive b!tch. So that's my next hurdle.
jmurrayhead
If you agree, give me rep.
If you like it here...throw us a few bones to help support us.
So now we know who you're gonna kill
Just ask her to create a query using her null values and tell her see if she understands
thru that thick skull of hers that you just can't have a null date of hire
Posting Permissions 
Reply With Quote
Bookmarks