Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 10 of 10
Search took 0.00 seconds.
Search: Posts Made By: ZeroFactorial
Forum: BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio November 11th, 2009, 04:17 PM
Replies: 16
Views: 2,181
Posted By ZeroFactorial
Thanks again Vince. For anyone that ever...

Thanks again Vince.

For anyone that ever needs this, I added this functionality to the Framework as it may be needed again.
Below you can find what I did to get this working.
...
Forum: BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio November 11th, 2009, 02:02 PM
Replies: 16
Views: 2,181
Posted By ZeroFactorial
Ok right, this goes back to where should the...

Ok right, this goes back to where should the Group By be placed then.
Doesnt seem like the Framework handles this. I will extend the ENTBaseQuery and see if I can get it to work.

I take it...
Forum: BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio November 11th, 2009, 01:51 PM
Replies: 16
Views: 2,181
Posted By ZeroFactorial
One last favor Vince and I should be good to go. ...

One last favor Vince and I should be good to go.
Is there a way to see how the Query String is put together prior to being passed?

I have one Query Parameter and if I select it and add it for...
Forum: BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio November 11th, 2009, 12:39 PM
Replies: 16
Views: 2,181
Posted By ZeroFactorial
Vince, I was able to correct this. I just...

Vince,

I was able to correct this. I just added the Group By at the end of the FromClause method and it worked perfectly.

Thanks for taking the time to help me track this down. [:)]
Forum: BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio November 11th, 2009, 12:33 PM
Replies: 16
Views: 2,181
Posted By ZeroFactorial
Vince, Thanks for the reply. I was able to...

Vince,

Thanks for the reply. I was able to capture the error and it ispointing to the Select Distinct not having a Group By.

Error:
{"Column 'AEHospital.REGION' is invalid in the select...
Forum: BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio November 10th, 2009, 02:29 PM
Replies: 16
Views: 2,181
Posted By ZeroFactorial
Changed try/catch block to this ...

Changed try/catch block to this

protectedoverridestring SelectClause()
{
try
{
return"SELECT DISTINCT AEHospital.REGION, COUNT(CASE WHEN AETransfer.transferDecisionIndex = 0 THEN 'Accepted'...
Forum: BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio November 10th, 2009, 02:00 PM
Replies: 16
Views: 2,181
Posted By ZeroFactorial
the compiler shows this ...

the compiler shows this

'V2.PaidTimeOffDAL.Reports.ReportTransferByRegionQueryData.SelectClause()': not all code paths return a value

Perplexing no? I built the standalone report using the...
Forum: BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio November 10th, 2009, 01:40 PM
Replies: 16
Views: 2,181
Posted By ZeroFactorial
no sir, everything is there from what I can tell,...

no sir, everything is there from what I can tell, do you think since I am using a Select Distinct I need to include the Group By somewhere?

publicclassReportTransferByRegionQueryData :...
Forum: BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio November 10th, 2009, 01:20 PM
Replies: 16
Views: 2,181
Posted By ZeroFactorial
Thanks Vince, I did what you suggested and got...

Thanks Vince, I did what you suggested and got the following:

Not all code paths return a value
This is thrown in my QueryData SelectClause. Is this saying that I should return void here?
...
Forum: BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio November 9th, 2009, 05:58 PM
Replies: 16
Views: 2,181
Posted By ZeroFactorial
Query Builder Help

Having a problem with the Query Builder. I can get all the way to the ReportQuery.aspx but when i click the Preview button I get the following.


if (QueryBuilder1.GetWhereClause(ref...
Showing results 1 to 10 of 10

 


All times are GMT -4. The time now is 01:31 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.