JQuery is Null or Not an Object – Error

February 23, 2013

If so you are sure there is probably a conflict of JQuery objects in 1 SP form.

In this case SharePointBoost Cross-Site Lookup also uses a JQuery object to have their webpart function properly.

http://www.sharepointboost.com/cascaded-lookup.html

clip_image002

To solve the error conflict, you have to use the $.noConflict() method.

http://api.jquery.com/jQuery.noConflict/

Just add an extra line :

$.noConflict();
jQuery(document).ready(function($)
Code here ...

And you can start mixing JQuery Objects in 1 SharePoint form.


Network Environment XP style on W2k8 Server

February 22, 2013

In the past I had the intension to always use the Comments property of a PC to fill in the name of the User and Department.

image

The benefit was that it showed up in the Explorer Network Environment.

image

But in the Windows 2008 server and Windows 7 Clients that DESCRIPTION column had disappeared Sad smile

Solution:

Just copy the Network Environment Shortcut to the Windows 7 clients or W2K8 Server Desktop and your are off again.

image

I hope this can help some more people manage there PC’s in a network.


MS SQL Compressed Back Tool

February 17, 2013

Making MS SQL backups is quite easy using the build-in features.

But it is more efficient using the Compressed Backup Tool which you can download here http://mssqlcompressed.sourceforge.net/doc_command.shtml

The syntax us as follows :

msbp.exe backup "db(database=YourDB)" 
"zip64(level=3;filename=YourDB)" 
"local (path=D:\Temp\YourDB.zip)" 

The benefits are highly compressed backups compared to the native MS SQL backups.

image

Just give it a try


MS SQL ScriptDB tool

February 17, 2013

Description :
ScriptDb is a simple console app written in C# that uses SQL Management Objects (SMO) to script all the objects in a database.

Running this console appl. with following parameters will generate the SQL scripts for Tables and Views.

scriptdb.exe -con:server=(local);
database="YourDBName";trusted_connection=yes 
-outDir:D:\ScriptDB\scripts -v –p 

image

The version posted on http://scriptdb.codeplex.com/ is only against MS SQL version 2000 – 2005.

But someone upgrade the source for MS SQL 2008 !

http://tech.trailmax.info/2012/10/scriptdb/scriptdb/ – 2008 version DotNet 4.0 needed.


SharePoint CAML Queries – How to ?

February 13, 2013

Building CAML queries in SharePoint is not so easy, especially making complex queries using parameters etc.

Well there are tools available in the internet that can help. But maybe you have a tool at hand you didn’t think of immediately ?

Report Builder can do the job :

Open a new report and link to the SharePoint List you want to attack.

Open the Query Designer

image

Select the fields you need and click on the FILTER icon. Add your Filter Field and check the PARAMETER box.

image

Run the Query to test it, and if OK click EDIT as TEXT

image

And voila your CAML Query is properly formatted !