Click here to Skip to main content
15,887,214 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
QuestionTrying to create a custom ValidationAttribute Pin
dmikester107-May-14 9:49
dmikester107-May-14 9:49 
Question.NET solution for Accouting Pin
gurusarma5-May-14 19:57
gurusarma5-May-14 19:57 
GeneralRe: .NET solution for Accouting Pin
Richard MacCutchan5-May-14 20:15
mveRichard MacCutchan5-May-14 20:15 
Question"data is updated successfuly..." is shown but database cannot updated Pin
dipesh_karmakar4-May-14 6:01
dipesh_karmakar4-May-14 6:01 
AnswerRe: "data is updated successfuly..." is shown but database cannot updated Pin
Eddy Vluggen4-May-14 8:40
professionalEddy Vluggen4-May-14 8:40 
SuggestionRe: "data is updated successfuly..." is shown but database cannot updated Pin
saroj mnaik11-May-14 9:06
saroj mnaik11-May-14 9:06 
AnswerRe: "data is updated successfuly..." is shown but database cannot updated Pin
saroj mnaik11-May-14 9:12
saroj mnaik11-May-14 9:12 
Questionhow to join all three query results to one in mysql Pin
sr1591-May-14 5:55
sr1591-May-14 5:55 
hi

i have written 3 different select query in mysql based on yesterday,today, tommorow dates to get the birthday details as follows
select concat(name,', ',title) as 'Yesterday 30-04-2014' from personal_details where DOB=curdate() - interval 1 day
select concat(name,', ',title) as 'Today 01-05-2014' from personal_details where DOB=DATE(NOW())
select concat(name,', ',title) as 'Tommorow 02-05-2014' from personal_details where DOB=curdate() + interval 1 day

how to join all 3 query results to one, i need to show as below
Yesterday Today Tomorrow
aaaa gggg nnnnn
bbbb hhhhh mmmm
dddd jjjjj
eeee
ffff


How to achieve this, i am not able to do.

If i tried with join there it wont match any condition and will not work because in each query result i will get unique values.
I tried with another query by putting as below

select a.* from (select CASE DOB WHEN (curdate() - interval 1 day) THEN concat(name,', ',title) ELSE '' END AS 'Yesterday', CASE DOB WHEN (DATE(NOW())) THEN concat(name,', ',title) ELSE '' END AS 'Today',CASE DOB WHEN (curdate() + interval 1 day) THEN concat(name,', ',title) ELSE '' END AS 'Tomorrow' from personal_details ) as a where a.Yesterday IS NOT NULL and a.Today IS NOT NULL and a.Tomorrow IS NOT NULL

It is showing the result like in all the three column some rows will be null

I dont want null values in any column. i want output as above.

How to achieve this. If anybody knows please reply me.

Thanks in advance.
SuggestionRe: how to join all three query results to one in mysql Pin
Richard Deeming1-May-14 6:50
mveRichard Deeming1-May-14 6:50 
QuestionRunning .NET 4.0 Targeted app in .NET 3.5 ONLY environment Pin
TheGreatAndPowerfulOz30-Apr-14 8:57
TheGreatAndPowerfulOz30-Apr-14 8:57 
SuggestionRe: Running .NET 4.0 Targeted app in .NET 3.5 ONLY environment Pin
Matt T Heffron30-Apr-14 10:04
professionalMatt T Heffron30-Apr-14 10:04 
GeneralRe: Running .NET 4.0 Targeted app in .NET 3.5 ONLY environment Pin
TheGreatAndPowerfulOz30-Apr-14 10:13
TheGreatAndPowerfulOz30-Apr-14 10:13 
AnswerRe: Running .NET 4.0 Targeted app in .NET 3.5 ONLY environment Pin
Gerry Schmitz30-Apr-14 10:10
mveGerry Schmitz30-Apr-14 10:10 
GeneralRe: Running .NET 4.0 Targeted app in .NET 3.5 ONLY environment Pin
TheGreatAndPowerfulOz30-Apr-14 10:14
TheGreatAndPowerfulOz30-Apr-14 10:14 
QuestionDevoloping a Calc spreadsheet program using C# Pin
sifi mohamed amine25-Apr-14 3:50
sifi mohamed amine25-Apr-14 3:50 
AnswerRe: Devoloping a Calc spreadsheet program using C# Pin
José Amílcar Casimiro3-May-14 7:38
José Amílcar Casimiro3-May-14 7:38 
QuestionCan't start Windows Service Pin
sifi mohamed amine24-Apr-14 3:55
sifi mohamed amine24-Apr-14 3:55 
GeneralRe: Can't start Windows Service Pin
PIEBALDconsult24-Apr-14 4:18
mvePIEBALDconsult24-Apr-14 4:18 
GeneralRe: Can't start Windows Service Pin
sifi mohamed amine24-Apr-14 4:24
sifi mohamed amine24-Apr-14 4:24 
GeneralRe: Can't start Windows Service Pin
PIEBALDconsult24-Apr-14 5:14
mvePIEBALDconsult24-Apr-14 5:14 
AnswerRe: Can't start Windows Service Pin
jschell27-Apr-14 9:35
jschell27-Apr-14 9:35 
GeneralRe: Can't start Windows Service Pin
sifi mohamed amine2-May-14 4:33
sifi mohamed amine2-May-14 4:33 
QuestionCreate an interface to own API Pin
tommy_tanaka21-Apr-14 1:18
tommy_tanaka21-Apr-14 1:18 
AnswerRe: Create an interface to own API Pin
Bernhard Hiller21-Apr-14 21:34
Bernhard Hiller21-Apr-14 21:34 
QuestionCustom mapping with AutoMapper Pin
USAFHokie8016-Apr-14 5:04
USAFHokie8016-Apr-14 5:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.