Joe Audette, MCSD, MCDBA, MCSE - All Comments

re: Silverlight + Google Gears = Awesome! at least in Firefox

joeaudette — Thu, 04 Dec 2008 15:29:44 GMT

Hi Craig,

Thanks for the suggestion. I'm already doing something similar when passing in an array of params:

ScriptObject jsArray = HtmlPage.Window.Invoke("createJsArray", parameters.Length) as ScriptObject;

for (int i = 0; i < parameters.Length; i++)

{

HtmlPage.Window.Invoke("assignArray", jsArray, i, parameters[i]);

}

//HtmlPage.Window.Invoke("passArrayTest", jsArray);

return gDb.Invoke("execute", sqlCommand, jsArray) as ScriptObject;

I'm able to execute the sql and get a resultSet object, the problem in IE is when trying to get the field name or value from the resultSet. I've tried a lot of different syntax but I get invalid type or out of range errors in IE 7 using these methods (all of which work in FF):

public string GetFieldName(int fieldIndex)

{

try

{

// these work with Firefox but not IE7

// IE7 throws an invalid argument exception

//return gResult.Invoke("fieldName", parameters).ToString();

return gResult.Invoke("fieldName", fieldIndex).ToString();

//return gResult.Invoke("fieldName", new object[]{fieldIndex}).ToString();

//return HtmlPage.Window.Invoke("getFieldName", new object[]{ gResult, fieldIndex}).ToString();

}

catch (Exception ex)

{

Logger.LogError("GearsResultSet.GetFieldName", ex);

}

return string.Empty;

}

all of these approaches work in FF but not in IE 7. I tried adding your method to the js and invoking it to create a ScriptObject to pass into getFieldName, but the result is the same.

So I can execute, get a resultset , check isValidRow returns true and I can move through the results with moveNext. Its just the fieldName and field methods that break in IE 7. I can even call fieldByName and it works.

Best,

Joe

re: Silverlight + Google Gears = Awesome! at least in Firefox

Craig Sutherland — Thu, 04 Dec 2008 08:55:54 GMT

I also have the same problem with IE7.0. After some playing around I fixed out a work-around (although it is a hack).

To the HTML page that contains the Silverlight control I added a javascript function as follows:

function convertArgs(){

return args;

}

The I call this function first from the Silverlight code-behind to convert the arguments from a .Net array to a javascript array.

Not the best, but at least it now works.

SilverTrader: Resize of Windows « Tales from a Trading Desk

SilverTrader: Resize of Windows « Tales from a Trading Desk — Tue, 02 Dec 2008 00:02:05 GMT

Pingback from SilverTrader: Resize of Windows « Tales from a Trading Desk

Reflective Perspective - Chris Alcock » The Morning Brew #234

Reflective Perspective - Chris Alcock » The Morning Brew #234 — Mon, 01 Dec 2008 10:50:46 GMT

Pingback from Reflective Perspective - Chris Alcock » The Morning Brew #234

myspace defaults

myspace defaults — Sun, 11 May 2008 15:01:35 GMT

Pingback from myspace defaults

One Bookmarking Service to Rule Them All and in The Widget Bind Them

DotNetKicks.com — Sat, 29 Mar 2008 17:26:51 GMT

You've been kicked (a good thing) - Trackback from DotNetKicks.com

re: SubSonic - All Your Databases Are Belong To Us

rrobbins — Wed, 05 Mar 2008 16:19:42 GMT

I've just started to use SubSonic too. It is a great way to automate the creation of your basic table administration (i.e scaffold) for CRUD. This will really save me a lot of time when it comes to that chore.

I hope SubSonic can make a web application portable for MySQL and SQL Server because I frequently have clients that want to change hosting companies which only offer one of the other.