Insert these lines after the root entry of the DS:
[sourcecode lang=“xml“]
[/sourcecode]
Author: rogersennert_sz793679
How to debug the last sql statement in Typo3
Hey … it’s very simple to get the last sql statement. Before the execution of the statement write this:
$GLOBALS['TYPO3_DB']->store_lastBuiltQuery = 1;
Then execute the statement. After that you can query the sql string with:
echo $GLOBALS['TYPO3_DB']->debug_lastBuiltQuery;
Impressum
Provider:
Blue Star Software
Dipl.-Ing. tech. Informatik Roger Sennert
Fritz-Krämer-Weg 3
57258 Freudenberg
phone: +49 2734 436520
Germany
e-mail: info(at)bluestarsoftware.de
VAT identification number according to § 27 a Umsatzsteuergesetz:
DE 216762420
In accordance with § 28 BDSG we object to any kind of commercial use and passing on of our data.
Liability: The contents of this website have been examined carefully and were created to the best of our knowledge. However, we do not claim responsibility for the completeness, topicality, quality and correctness of the information presented on this site.
In spite of careful examination of external links, we do not accept responsibility for their contents. It is the providers of the linked sites who are responsible for their contents. We have made sure that these sites neither break any law nor offend common decency exactly once, that is before they were incorporated into our site.
Data security: Personal data are ascertained only with your knowledge and your consent. If you wish, we will send you all the information about your stored personal data free of charge.
Violation of patent law: If you think that any of the items on this website violates one of your patents, please tell us immediately so that we can change the particular item as soon as possible.
Google Analytics: This website uses Google Analytics, a web analytics service provided by Google, Inc. (”Google”). Google Analytics uses “cookies”, which are text files placed on your computer, to help the website analyze how users use the site. The information generated by the cookie about your use of the website (including your IP address) will be transmitted to and stored by Google on servers in the United States. Google will use this information for the purpose of evaluating your use of the website, compiling reports on website activity for website operators and providing other services relating to website activity and internet usage. Google may also transfer this information to third parties where required to do so by law, or where such third parties process the information on Google’s behalf. Google will not associate your IP address with any other data held by Google. You may refuse the use of cookies by selecting the appropriate settings on your browser, however please note that if you do this you may not be able to use the full functionality of this website. By using this website, you consent to the processing of data about you by Google in the manner and for the purposes set out above.
My Firefox Extensions
Yeah … I know …. everyone is posting such a stuff. So here’s my 😉
Scrolling the tabs of Firefox with the mousewheel
May I’m the only one who like this feature – but I can not live without it.
So if anyone else cares he can try out the miniT-tabscoll.xpi extension at http://mozilla.dorando.at. Have fun.
Lovely DataGridView
Mircosoft did a create job with the DataGridView in .Net 2.0. It’s so easy to display you own data. All you need is a IList implementation. The List< T > was the first which Continue reading
Dictionary with foreach
I’ve just want to mention how to do a foreach with a .NET 2.0 Hashtable:
[sourcecode lang=“c#“]Dictionary< string, int > dict = new Dictionary< string, int >();
dict[„one“] = 1;
dict[„two“] = 2;
dict[„thress“] = 3;
foreach( KeyValuePair< string, int > data in dict)
{
Debug.WriteLine( data.Key + “ => “ + data.Value );
}[/sourcecode] So this time KeyValuePair is our friend.
[IM004] [Microsoft][ODBC Driver Manager]
ERROR [IM004] [Microsoft][ODBC Driver Manager] Fehler beim SQLAllocHandle-Aufruf für Treiber auf SQL_HANDLE_ENV
Yeah … this damm error took me hours of hard work. Continue reading
Hashtable with foreach
You have to use: DictionaryEntry
[sourcecode lang=“c#“]Hashtable ht = new Hashtable();
ht[„one“] = 1;
ht[„two“] = 2;
ht[„three“] = 3;
foreach(DictionaryEntry data in ht)
{
Debug.WriteLine( data.Key + “ => “ data.Value );
}[/sourcecode]