February 2007 Entries

Don't forget add EntitySpaces operands to Where method.

In EntitySpaces you can specify filter to load data. I've wrote the following code EmployeesCollection collection = new EmployeesCollection(); Collection.Query.LastName.L... collection.Query.Load(); and couldn't understand why the filter doesn't work. The reason is that functions similat to Like, LessThan return esWhereItem that will work only after they passed to esDynamicQuery.Where(Object... method.So the correct code must be Dim collection As EmployeesCollection = New EmployeesCollection() ......

Exclude non-stringable columns in EntitySpaces templates.

In MyGeneration template for EntitySpaces (see Template: Ajax Auto Complete WebServices using EntitySpaces) I wanted to loop through all columns of the table but exclude those that can not be converted to string(e.g TimeStamp).It's can be done by calling EntitySpaces esPlugIn methods IsObjectType and IsArrayType foreach(IColumn col in cols) { if(!esPlugIn.IsArrayType(col) && !esPlugIn.IsObjectType(col)) {//exclude fields like TimeStamps //put your code here } } ......

Possible reasons for Access messages "Data Being Updated by Another User"

I was asked to investigate, why in Access 2000 linked table(to SQL server database) any change in data was refused with message returning "Data Being Updated by Another User".The actual message could be misleading, because it returns if Update SQL returns 0 records back.Access creates dynamic SQL passing in WHERE clause current values of fields.However if column was created as BIT NULL and actually has NULL value, access sends in WHERE columnName=0 , which causes mismatch.The problem happened in ......

"Configure Data Source" Wizard reads assemblies from BIN directory regardless of specified Build Output Path in VB WAP project

Today I wanted to add Object Data Source(located in another DLL) to User Control in VB WAP project."Configure Data Source"Wizard showed me "Choose your Business Object" drop-down list with some objects from my DLL, but not the newest, that I've created recently. I've rebuild my projects a few times,cleaned solution,closed and re-opened Visua Studio -it didn't help. My new data classes were not included in the combo-box. When I added class typemanually in the markup view, Wizard reported, that class ......

DotNetnuke 4.4 RewriterUtils.RewriteUrl breaking change in adding QueryString.

I am using modified version of DNN HttpModules\UrlRewrite\UrlR... in particular I am calling their Friend RewriterUtils.RewriteUrl function. In 4.0.3 version it expected URL parameter without QueryString and added queryString from context.Request.QueryString inside the function.But in 4.4. my code stopped working.The reason was that they removed the code to add querystring information from the function and made it responsibility of a caller.It certainly makes sense, but it will be easier ......

«February»
SunMonTueWedThuFriSat
28293031123
45678910
11121314151617
18192021222324
25262728123
45678910