Discussions

John, your boy is one cool cat. It's really wonderful that you have fostered and suppoprted his talent. Great job to you both!

We are cheering for him weekly in Boston.

Executing a python script in via ASPX in IIS7 via

Server.Execute("scriptname.py?arg1=x&arg2=z")

Gives me the following error:

No http handler was found for request type 'GET'

[HttpException (0x80004005): No http handler was found for request type 'GET']
   System.Web.HttpApplication.MapIntegratedHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig, Boolean convertNativeStaticFileModule) +849
   System.Web.HttpServerUtility.Execute(String path, TextWriter writer, Boolean preserveForm) +463

[HttpException (0x80004005): Error executing child request for ~/CGI-BIN/Stock-chart.py.]
   System.Web.HttpServerUtility.Execute(String path, TextWriter writer, Boolean preserveForm) +816
   System.Web.HttpServerUtility.Execute(String path) +8
   ms_sandbox.About.Page_Load(Object sender, EventArgs e) in D:\Dropbox\Dropbox\WebSites\ms-sandbox\ms-sandbox\About.aspx.cs:14
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207


I have added the script handler to IIS and I can call the script directly fine. 
It's only when I try to call it via server.execute that I have this issue. 

Any Ideas?

Turns out the query I was using above was completly wrong to begin with.

long? maxId = db.ResultDatas.Where(model => model.Query == Keyword).Max(res => (long?)res.ResultId) ?? 0;

The above code works, is intuitive and seems to be reasonably performant.

If anyone knows any better please let me know!

string keyword = "michio kaku";
using (MyModelEntities db = new MyModelEntities()) 
{        
        long? maxId = db.ResultDatas.Select(m => m.Query == Keyword).Max(m => db.ResultDatas.Max(r => r.ResultId)); 
}

In the code above, I have an Entity Set named "ResultDatas" with some fields "Query" and "ResultId".

The underlying data store could have 0 to n matches for a given query. I want to return the max(ResultId) of the matched keyword (or null for non-matched sets).

The code above works, but seems ineffecient, can someone explain a better way to do this?

TIA

@blowdart: 

Arrived in the office this morning to a mutilated C9 guy.

I have no idea what sort of evil would engage in such a practice, but I am pretty disheartened.

Is there anyway to get more?

Jamie, John, you guys still around?

I have a service that batches SSRS reports by making calls to the RSExecution web service.

I am having an issue with reports that contain cascading parameters, it seems that I am unable to successfully set a parameter value for a cascading parameter.

Any attempt at running the report programatically results in a ReportParameterValueNotSetException, even though I am sending the report parameter in via theReportExecutionService.SetExecutionParameters method

Ideas or tips?

@ScanIam (and anyone else)

Arguing over a book that you've never actually read is a bit foolish, aye.

Looking for a way for a service to prevent a windows box from sleeping.

Is the SetThreadExecutionState api call the only way via .NET (C# or F#)?

I am John Galt.

/spam