How to extract Sharepoint list using SQL Query

I was searching for Sql query to be able to extract the list from Sharepoint database and found a good link that helped me fix the issue

Querying Sharepoint List Item Versions using SQL

Which actually gives the info on list and full sql query to get the list is here:
Hope this helps... enjoy


Declare @ListID as uniqueidentifier

SET @ListID =(SELECT tp_id FROM dbo.AllLists WHERE tp_title ='New User Request')
   --select @ListID
   
   
SELECT      dbo.UserData.tp_ID,
  dbo.UserData.tp_ListId,
  dbo.UserData.tp_Author,
  dbo.UserData.nvarchar1,
                dbo.UserData.nvarchar2,
  dbo.UserData.nvarchar3,
  dbo.UserData.nvarchar4,
  dbo.UserData.nvarchar5,
                dbo.UserData.nvarchar6,
  dbo.UserData.nvarchar7,
  dbo.UserData.nvarchar8,
  dbo.UserData.nvarchar9 ,
                dbo.UserData.nvarchar10,
  dbo.UserData.nvarchar11,
  dbo.UserData.nvarchar12,
  dbo.UserData.*                  --dont forget to modify this to snatch only the columns you need
FROM            dbo.Lists
INNER JOIN
                dbo.UserData ON dbo.Lists.tp_ID = dbo.UserData.tp_ListId
               
               
WHERE  
(dbo.UserData.tp_ListId =@ListID)

Read more!

Get Legitimate Photoshop for free from Adobe itself right here

Guys, I found out that Adobe is giving its older version of Adobe Photoshop CS2 and all contents within creative suite for free.

It is good for Photoshop learners who just want to learn and trial it out and not go into advanced functions which obviously if they think they need it can purchase latest version of Photoshop.

This is way good for the students learning Photoshop and who are tired of using free crappy photo software.

Here you go guys get your free copy from the ADOBE DOWNLOADS website, all you need to have is Adobe free Account which you don't mind creating to get a free copy. Enjoy happily........ 

Read more!

Fix for An unexpected error occurred while searching for plugins in Wordpress site hosted locally in Wamp server.

I came across unusual error while trying to install the plugins in wordpress development site hosted locally in Wamp server within our company network:

The error said:

“An unexpected error occurred. Something may be wrong with WordPress.org or this server’s configuration. If you continue to have problems, please try the support forums”

It was few hours search which directed me to change the timeout in httpconfig.php and others as well and I tried all of them and finally I found out the blog to fix it which was:

please help:An unexpected error occurred.Something may be wrong with WordPress

The main culprit of the issue was the “proxy” being used for the connection within our company.

To get around the proxy we need to enter the proxy information in wp-config.php as below as mentioned in above link.

If the problem is happening when you search plugins or themes its probably because your connected to a proxy and you need to configure it on your wp-config.php

/** EXAMPLE - proxy settings */
define('WP_PROXY_HOST', 'proxy.url.com');
define('WP_PROXY_PORT', '1234');
define('WP_PROXY_USERNAME', '');
define('WP_PROXY_PASSWORD', '');
define('WP_PROXY_BYPASS_HOSTS', 'localhost');

Thanks to mario.andrade

Read more!

Using Entity Framework Code First and ASP.NET Membership Together A great article by Imar Spaanjaars

I was stuck when Asp membership tables were being deleted when working on Entity Framework code First approach and by looking around got hold of this great article that explained and fixed the exact problem i was having.

The link is below for the guys who are still searching for the fix. 

Using Entity Framework Code First and ASP.NET Membership Together

Some time ago I was involved as a software designer and developer in an MVC 3 project that used Entity Framework Code First 4.1 in a repository layer. During development we postponed dealing with security as requirements were pretty simple (simple logons with a single Administrators role plus the requirement that users should only be able to see their own data). When we were close to deployment, we ran the aspnet_regsql tool against the database that EF had created for us to create the SQL schema and data that the Application Services such as Membership and Roles require. We also added an additional userName parameter to a Get method in the repository to filter records for the currently logged in user. Finally, we added Authorize attributes to a number of controllers to make sure they are only accessible for users that are logged in. We then deployed the application and database, created a number of users using the MvcMembership section we had added to the site, and announced the presence of the site. All of this worked great, but we ran into issues when started work on the next version of the application.

Read more!