My version (thanks to Sergey Z):

SELECT *

FROM [STS_Canada_1].[dbo].[Docs]

WHERE [LeafName] <> 'Attachments' AND [Type] = 1 AND

[ListId] IN

(

SELECT [tp_Id] FROM [Lists]

WHERE [tp_BaseType] <> 1

)

Please let me know if it is wrong.

To Grigory V

http://en.wikipedia.org/wiki/OLAP_cube

“An OLAP (Online analytical processing) cube is a data structure that allows fast analysis of data.[1] It can also be defined as the capability of manipulating and analyzing data from multiple perspectives.

I was doing all this stuff manually :)

“A SharePoint Solution Package (WSP) creation tool for WSS 3.0 & MOSS 2007

No more manually creating the manifest.xml file.

No more manually specifying the DDF file.

http://www.sharepointhillbilly.com/archive/2009/09/10/10-sharepoint-deployment-standards.aspx

“SPD has some wonderful out-of-the-box workflows.  However, these workflows are limited, do not migrate well, and would need to be maintained in production (see #1 above).

“Feature Stapling allows you to create a feature and then associate it with any site definition without ever touching the site definition files themselves.

Trying to install SPS 2003 SP2 on Wss2 SP2, says

“The expected version of the product was not found on your system”

Nice :)

Does anybody have any idea, why?

http://blogs.technet.com/wbaer/archive/2006/12/22/prescan-errors-what-they-mean.aspx

Personally I’ve got this one first:

System.MissingMethodException: Method not found: System.String Microsoft.SharePoint.Administration.SPVirtualServerConfig.get_DefaultZoneOutgoingUrl()

There is an explanation in

<Program Files>\Common Files\Microsoft Shared\web server extensions\12\BIN

You need to files:

prescan.exe

preupgradescanconfig.xml

And examples how to run:

http://blogs.msdn.com/joelo/archive/2007/05/01/your-friend-prescan-what-it-does-part-2.aspx

SPS 2003: prescan.exe /c preupgradescanconfig.

If you want good examples of rst files, download docutils, unpack and go to docs directory.

Every txt there is an absolutely legitimate rst. So if you have docutils installed,

just use rst2html to get html version of those txts.

So finally started using Google Desktop for search in python source code!

Before emails were the only case :)

http://desktop.google.com/features.html

“Google has finally published a new Google Sites API allowing these clients

to move data from Google Sites to SharePoint and other collaboration suites.”

http://www.paulswider.com/2009/09/google-finally-opens-up-api-to-developers.html

http://webanalytics.globalthoughtz.com/index.php/google-announce-two-new-search-features/

http://codespeak.net/pypy/dist/pypy/doc/

“The PyPy project aims at producing a flexible and fast Python implementation. The guiding idea is to translate a Python-level description of the Python language itself to lower level languages.

“I described how to use LINQ from an IronPython application and implied that I didn’t think it was the best idea.

http://nedbatchelder.com/code/coverage/

“Coverage.py is a tool for measuring code coverage of Python programs. It monitors your program, noting which parts of the code have been executed, then analyzes the source to identify code that could have been executed but was not.

http://gizmodo.com/5365362/internet-explorer-now-powered-by-google-chrome

“The Chrome Frame allows IE to use HTML5 and other open source technologies, including high performance JavaScript enhancements, that Internet Explorer's Trident Engine is unable to render.

“Prescan is your friend.

Just use SQL Management Studio Database Task: Generate Scripts. Save all scripts to File.

You all get all functions and procedures with their bodies in a single text file.

Then you can easily open it in Notepad++ and look for all dependencies.

1

http://www.artima.com/weblogs/viewpost.jsp?thread=230001

“It might seem strange that a networking library is the solution to concurrency, but once you divide your task into subprocesses, the next problem is to communicate with these subprocesses.

http://www.boost.org/doc/libs/1_35_0/libs/python/doc/index.html

“Welcome to version 2 of Boost.Python, a C++ library which enables seamless interoperability between C++ and the Python programming language.

http://gojko.net/2009/09/24/top-10-reasons-why-teams-fail-with-acceptance-testing/

No collaboration

Focusing on what, not on how

Tests unusable as live documentation

Expecting acceptance tests to be a full regression suite

Focusing on tools

Not considering acceptance testing as value added act

Gotcha:

Based on this doc http://docs.djangoproject.com/en/dev/ref/templates/api/

I wrongly started to use render_to_string() when returning data to Cherrypy

CherryPy has a logic if it gets something different from string, it encodes it to "ISO-8859-1" ,

everything is fine till you get Russian c

To make Django templates working with CherryPy I’ve done this:

from django.conf import settings

settings.configure()

settings.TEMPLATE_LOADERS = ('django.template.loaders.filesystem.load_template_source',)   

settings.TEMPLATE_DIRS = ( 'templates', )

So finally I love this combination. Nothing can be simpler.

Interesting problem with cherrypy and adodbapi.connect

Two calls to http://server/compare

compare function uses adodbapi.connect, second call fails with InterfaceError (adodbapi.py,252)

added before calling to connect this:

import pythoncom

pythoncom.CoInitialize()

now works

probably it happe

1

http://google-chrome-browser.com/introducing-google-chrome-frame

“With Google Chrome Frame, developers can now take advantage of the latest open web technologies, even in Internet Explorer.

“PP is a python module which provides mechanism for parallel execution of python code on

SMP (systems with multiple processors or cores) and clusters (computers connected via network).

It is light, easy to install and integrate with other python software.

Go to SharePoint List through your favorite browser. Open Page Source Code.

“This document is an introductory tutorial to using regular expressions in Python with the re module.”

http://www.amk.ca/python/howto/regex/

http://www.pyccuracy.org/

http://www.pyccuracy.org/getting_started_3.html

Maxim, Andrey, it is very similar to what you’ve done.

From Twitter “voidspace: The start of a testing infrastructure for Try Python. Not many tests yet however...

“IronPython 2.6 is a version of IronPython targeting compatibility with Python 2.6.

Searching for column name for Title in this (from tp_Fields):

str = '''ERROR:root:((u'12.0.0.6510.0.0<Field ID="{03e45e84-1992-4d42-9116-26f756012634}" RowOrdinal="0" Type="ContentTypeId" Sealed="TRUE" ReadOnly="TRUE" Hidden="TRUE" DisplayName="Content Type ID" Name="ContentTypeId" DisplaceOnUpgrad

“The document is only a namespace entry for a list item

(that is, it corresponds to an item in a non-document library

list that should be filtered out from file system–centric enumerations).”

http://msdn.microsoft.com/en-us/library/dd341149(PROT.13).aspx

http://msdn.microsoft.com/en-us/library/dd341037(PROT.13).aspx

"{tp_Fields}: This field MUST be NULL if the site or list has been flagged to cache all schema data; otherwise, it contains a WSS implementation-specific version string followed by an XML fragment representation of the field definitions

Blog Archive
Blog Archive
About Me
About Me
Loading