www.netsi.dk

"The internet is just a layer on the real world" (don't forget that!)

Monthly Archives: February 2011

SQL: Get a list of all tables in a database

Sometimes if you use a system where you do not have a Manager at hand, perhaps only a web based query window you may find it hard to keep track of all defined tables in the system. I for one cannot remember all the tables used in for instance Dynamicweb CMS. Please note that the example query below is for Microsoft SQL server, I am not sure if it works in other SQL server environments.

Being logged in to the system as administrator you can get a SQL Query textarea like this one below. You can then enter:

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
order by TABLE_NAME

 

The Query Editor of Dynamicweb CMS - very handy

Links


Share



					

		

			
			
		

		

	
				






Nu kan du også finde Android Applikationer via din browser

			
		

			
Jeg har idag set lanceringen af Google Android 3 (Honeycomb) og der var flere spændende ting.


  – køb dine  via en browser


 


image


Dette gør at man kan sidde hjemme ved sin PC og browse applikationerne som er tilgængelig til dit Android device.


Her har jeg f.eks. søgt på “tilbudsavisen”:


image


Efter jeg har logget ind med min Google konto kan jeg at jeg allerede HAR eTilbudsavis installeret.


image


Share
					

		

			
			
		

		

	
				






Publish your pictures directly to Twitter from Google Picasa using “Tvivo” button.

			
		

			
Google Picasa is a very cool free photo/image handling software which can also be extended in various ways. You may add buttons which can for instance publish to Facebook or to . Today I discovered and tested Tvivo button. It will add a button to your Google Picasa application giving a one click publish to Twitter funktionality. Very easy, effective and cool!


Simply visit http://tvivo.espectrale.com/      
and do a one-click installation of the Tweet button      
to your Google Picasa application!      




 


When you click the button you will be taken to a new window where you the first time have to logon to your Twitter account. You may then add the “tweet text” to be shown Twitter together with the link to your image stored at “yfrog.com”.


The Tvivo button which will publish your current image to Twitter


This is an example of a image I have send to Twitter from Google Picasa using Tvivo:


Example of image published to twitter using Tvivo for Google Picasa


The only bad thing I personally can say about this button: The graphical design of the button… Not my taste. Smiley


Related posts – links



Share
					

		

			
			
		

		

	
				






Encode URL in XSLT

			
		

			
If you need to URL encode something in XSLT, you can use  serverside – not perfect, but it gets the job done. Here is the  and below you can find link to a simpel XSLT which has the script implemented.




   1:    <script language="javascript" xmlns="urn:schemas-microsoft-com:xslt" implements-prefix="js">


   2:      <![CDATA[ 


   3:      // This will return a URI encoded string


   4:      function encodeURL(sUrl) {


   5:        sUrl.MoveNext();


   6:        sUrl = sUrl.Current.Value;


   7:        return (sUrl);


   8:      }


   9:      ]]>


  10:    </script>





Find example XSLT here: http://dl.dropbox.com/u/3260327/xslt/js_encodeURL.xslt


Share