<?xml version="1.0" encoding="UTF-8" standalone="no"?><rss xmlns:atom="http://www.w3.org/2005/Atom" xmlns:blogger="http://schemas.google.com/blogger/2008" xmlns:gd="http://schemas.google.com/g/2005" xmlns:georss="http://www.georss.org/georss" xmlns:itunes="http://www.itunes.com/dtds/podcast-1.0.dtd" xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/" xmlns:thr="http://purl.org/syndication/thread/1.0" version="2.0"><channel><atom:id>tag:blogger.com,1999:blog-1800647555860390236</atom:id><lastBuildDate>Wed, 11 Sep 2024 17:19:30 +0000</lastBuildDate><category>php</category><category>ruby</category><category>asp</category><category>java</category><category>ajax</category><category>c#</category><category>software</category><category>javascript</category><category>tools</category><category>html</category><category>perl</category><category>vb.net</category><category>asp.net</category><category>python</category><category>visual basic</category><category>ajax books</category><category>delphi</category><category>sql</category><category>c++ / c</category><category>jsp</category><category>vbscript</category><category>xml</category><title>script merkezi</title><description>ajax, asp, asp.net, php, delphi, ruby, c#, visual basic, vb.net, Perl, c/c++, java, python, html codes</description><link>http://scriptmerkezi.blogspot.com/</link><managingEditor>noreply@blogger.com (script)</managingEditor><generator>Blogger</generator><openSearch:totalResults>164</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><language>en-us</language><itunes:explicit>no</itunes:explicit><itunes:subtitle>ajax, asp, asp.net, php, delphi, ruby, c#, visual basic, vb.net, Perl, c/c++, java, python, html codes</itunes:subtitle><itunes:category text="Education"><itunes:category text="Educational Technology"/></itunes:category><itunes:owner><itunes:email>noreply@blogger.com</itunes:email></itunes:owner><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-8325924611478399251</guid><pubDate>Wed, 26 Sep 2007 19:25:00 +0000</pubDate><atom:updated>2007-09-26T22:28:47.972+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">php</category><title>PHP SMTP Authentication: send an email through an authenticated SMTP server</title><description>Author: Matthew R. Miller, &lt;a href="http://www.bytemycode.com/snippets/snippet/223/"&gt;http://www.bytemycode.com/snippets/snippet/223/&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;p&gt;&amp;lt;?php&lt;br /&gt;function mymail($to,$subject,$message,$headers)&lt;br /&gt;{&lt;br /&gt;// set as global variable&lt;br /&gt;global $GLOBAL;&lt;br /&gt;// get From address&lt;br /&gt;if ( preg_match("/From:.*?[A-Za-z0-9\._%-]+\@[A-Za-z0-9\._%-]+.*/", $headers, $froms) ) {&lt;br /&gt;preg_match("/[A-Za-z0-9\._%-]+\@[A-Za-z0-9\._%-]+/", $froms[0], $fromarr);&lt;br /&gt;$from = $fromarr[0];&lt;br /&gt;}&lt;br /&gt;// Open an SMTP connection&lt;br /&gt;$cp = fsockopen ($GLOBAL["SMTP_SERVER"], $GLOBAL["SMTP_PORT"], &amp;amp;$errno, &amp;amp;$errstr, 1);&lt;br /&gt;if (!$cp)&lt;br /&gt;return "Failed to even make a connection";&lt;br /&gt;$res=fgets($cp,256);&lt;br /&gt;if(substr($res,0,3) != "220") return "Failed to connect";&lt;br /&gt;// Say hello...&lt;br /&gt;fputs($cp, "HELO ".$GLOBAL["SMTP_SERVER"]."\r\n");&lt;br /&gt;$res=fgets($cp,256);&lt;br /&gt;if(substr($res,0,3) != "250") return "Failed to Introduce";&lt;br /&gt;// perform authentication&lt;br /&gt;fputs($cp, "auth login\r\n");&lt;br /&gt;$res=fgets($cp,256);&lt;br /&gt;if(substr($res,0,3) != "334") return "Failed to Initiate Authentication";&lt;br /&gt;fputs($cp, base64_encode($GLOBAL["SMTP_USERNAME"])."\r\n");&lt;br /&gt;$res=fgets($cp,256);&lt;br /&gt;if(substr($res,0,3) != "334") return "Failed to Provide Username for Authentication";&lt;br /&gt;fputs($cp, base64_encode($GLOBAL["SMTP_PASSWORD"])."\r\n");&lt;br /&gt;$res=fgets($cp,256);&lt;br /&gt;if(substr($res,0,3) != "235") return "Failed to Authenticate";&lt;br /&gt;// Mail from...&lt;br /&gt;fputs($cp, "MAIL FROM: &amp;lt;$from&amp;gt;\r\n");&lt;br /&gt;$res=fgets($cp,256);&lt;br /&gt;if(substr($res,0,3) != "250") return "MAIL FROM failed";&lt;br /&gt;// Rcpt to...&lt;br /&gt;fputs($cp, "RCPT TO: &amp;lt;$to&amp;gt;\r\n");&lt;br /&gt;$res=fgets($cp,256);&lt;br /&gt;if(substr($res,0,3) != "250") return "RCPT TO failed";&lt;br /&gt;// Data...&lt;br /&gt;fputs($cp, "DATA\r\n");&lt;br /&gt;$res=fgets($cp,256);&lt;br /&gt;if(substr($res,0,3) != "354") return "DATA failed";&lt;br /&gt;// Send To:, From:, Subject:, other headers, blank line, message, and finish&lt;br /&gt;// with a period on its own line (for end of message)&lt;br /&gt;fputs($cp, "To: $to\r\nFrom: $from\r\nSubject: $subject\r\n$headers\r\n\r\n$message\r\n.\r\n");&lt;br /&gt;$res=fgets($cp,256);&lt;br /&gt;if(substr($res,0,3) != "250") return "Message Body Failed";&lt;br /&gt;// ...And time to quit...&lt;br /&gt;fputs($cp,"QUIT\r\n");&lt;br /&gt;$res=fgets($cp,256);&lt;br /&gt;if(substr($res,0,3) != "221") return "QUIT failed";&lt;br /&gt;return true;&lt;br /&gt;}&lt;br /&gt;?&amp;gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/09/php-smtp-authentication-send-email.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-5263059711526540800</guid><pubDate>Wed, 26 Sep 2007 19:22:00 +0000</pubDate><atom:updated>2007-09-26T22:24:57.512+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">php</category><title>Extracts all email adresses from a given string, and returns them as array</title><description>Author: Jonas John, http://codedump.jonasjohn.de/&lt;br /&gt;&lt;p&gt;&amp;lt;?php&lt;br /&gt;/*&lt;br /&gt;** Function: extract_emails (PHP)&lt;br /&gt;** Desc: This function extracts all E-Mail adresses from a given string, and returns them as array.&lt;br /&gt;** Author: Jonas John&lt;br /&gt;*/&lt;/p&gt;&lt;p&gt;function extract_emails($str)&lt;br /&gt;{&lt;br /&gt;// This regular expression extracts all emails from&lt;br /&gt;// a string:&lt;br /&gt;$regexp = '/([a-z0-9_\.\-])+\@(([a-z0-9\-])+\.)+([a-z0-9]{2,4})+/i';&lt;br /&gt;preg_match_all($regexp, $str, $m);&lt;br /&gt;return isset($m[0]) ? $m[0] : array();&lt;br /&gt;}&lt;br /&gt;?&amp;gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/09/extracts-all-email-adresses-from-given.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-7821090583219319365</guid><pubDate>Wed, 26 Sep 2007 19:17:00 +0000</pubDate><atom:updated>2007-09-26T22:21:38.018+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">php</category><title>Email address validator</title><description>Author: Tobias Ratschiller &amp;amp; izzy, http://www.zend.com/tips/tips.php?id=224&amp;amp;single=1&lt;br /&gt;&lt;p&gt;&amp;lt;?php&lt;br /&gt;&lt;br /&gt;/*&lt;br /&gt;Original script by Tobias Ratschiller.&lt;br /&gt;* top level domain must have at least 2 chars&lt;br /&gt;* there can be more than one dot in the address&lt;br /&gt;*/&lt;/p&gt;&lt;p&gt;function is_email($address) {&lt;br /&gt;$rc1 = (ereg('^[-!#$%&amp;amp;'*+./0-9=?A-Z^_`a-z{}~]+'.&lt;br /&gt;'@'.&lt;br /&gt;'[-!#$%&amp;amp;'*+\/0-9=?A-Z^_`a-z{}~]+.'.&lt;br /&gt;'[-!#$%&amp;amp;'*+\./0-9=?A-Z^_`a-z{}~]+$',&lt;br /&gt;$address));&lt;br /&gt;$rc2 = (preg_match('/.+.ww+$/',$address));&lt;br /&gt;return ($rc1 &amp;amp;&amp;amp; $rc2);&lt;br /&gt;}&lt;br /&gt;?&amp;gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/09/email-address-validator.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-3556710885799563068</guid><pubDate>Wed, 26 Sep 2007 19:09:00 +0000</pubDate><atom:updated>2007-09-26T22:16:27.460+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">php</category><title>Emailer Class</title><description>author: edolecki, http://www.bigbold.com/snippets/tag/php/6&lt;br /&gt;&lt;br /&gt;&lt;p&gt;&amp;lt;?php&lt;br /&gt;import mx.events.EventDispatcher;&lt;br /&gt;import mx.utils.Delegate;&lt;br /&gt;class Emailer {&lt;br /&gt;// required for EventDispatcher:&lt;br /&gt;public var addEventListener:Function;&lt;br /&gt;public var removeEventListener:Function;&lt;br /&gt;private var dispatchEvent:Function;&lt;/p&gt;&lt;p&gt;// use to communicate with php script&lt;br /&gt;private var _lv:LoadVars;&lt;br /&gt;// holds address of sender&lt;br /&gt;private var _sentFrom:String;&lt;br /&gt;// constructor&lt;br /&gt;public function Emailer() {&lt;br /&gt;EventDispatcher.initialize(this);&lt;br /&gt;_lv = new LoadVars();&lt;br /&gt;}&lt;br /&gt;//&lt;br /&gt;private function dataReceived(dataxfer_ok:Boolean):Void {&lt;br /&gt;// if some problem with loadVars transfer, pass back error=2&lt;br /&gt;if (!dataxfer_ok) dispatchEvent({target:this, type:'mailSent', errorFlag:2});&lt;br /&gt;// otherwise pass back error code returned from script&lt;br /&gt;else dispatchEvent({target:this, type:'mailSent', errorFlag:Number(_lv["faultCode"])});&lt;br /&gt;}&lt;br /&gt;// Use loadvars object to send data (set to call dataReceived when script returns data)&lt;br /&gt;public function sendEmail(sub:String, fn:String, fe:String, msg:String, rep:String):Void {&lt;br /&gt;// if user already sent from this address, show error msg&lt;br /&gt;if (_sentFrom == fe) dataReceived(false);&lt;br /&gt;// otherwise set up and send&lt;br /&gt;else {&lt;br /&gt;_sentFrom = fe;&lt;br /&gt;// specify function to handle results, make scope = Emailer&lt;br /&gt;_lv.onLoad = Delegate.create(this, dataReceived);&lt;br /&gt;// set up properties of lv to items to be POSTed&lt;br /&gt;_lv.subject = sub;&lt;br /&gt;_lv.name = fn;&lt;br /&gt;_lv.email = fe;&lt;br /&gt;_lv.message = msg;&lt;br /&gt;_lv.reply = rep;&lt;br /&gt;// call script&lt;br /&gt;_lv.sendAndLoad("sendemail.php", _lv, "POST");&lt;br /&gt;}&lt;br /&gt;}&lt;br /&gt;}&lt;br /&gt;?&amp;gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/09/emailer-class.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-7991489514507315638</guid><pubDate>Thu, 06 Sep 2007 12:14:00 +0000</pubDate><atom:updated>2007-09-06T15:15:45.040+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">asp</category><category domain="http://www.blogger.com/atom/ns#">software</category><category domain="http://www.blogger.com/atom/ns#">tools</category><title>Asp Report Maker</title><description>&lt;img src="http://www.hkvstore.com/aspreportmaker/images/asprptintro.png" /&gt;&lt;br /&gt;&lt;br /&gt;&lt;ul&gt;&lt;li&gt;Detail and Summary Report &lt;/li&gt;&lt;li&gt;Crosstab Report &lt;/li&gt;&lt;li&gt;Simple Charts &lt;/li&gt;&lt;li&gt;Advanced Security &lt;/li&gt;&lt;li&gt;Export to HTML/Excel/Word &lt;/li&gt;&lt;li&gt;Custom View &lt;/li&gt;&lt;li&gt;Customizable Template &lt;/li&gt;&lt;li&gt;Database Synchronization &lt;/li&gt;&lt;/ul&gt;&lt;p&gt;&lt;a href="http://www.hkvstore.com/aspreportmaker/download.asp"&gt;demo&lt;/a&gt;&lt;/p&gt;&lt;ul&gt;&lt;br /&gt;&lt;/ul&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/09/asp-report-maker.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-6984073270193203539</guid><pubDate>Thu, 06 Sep 2007 12:09:00 +0000</pubDate><atom:updated>2007-09-06T15:13:12.730+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">asp</category><category domain="http://www.blogger.com/atom/ns#">software</category><category domain="http://www.blogger.com/atom/ns#">tools</category><category domain="http://www.blogger.com/atom/ns#">xml</category><title>Asp XmlMaker</title><description>&lt;img src="http://www.hkvstore.com/aspxmlmaker/images/intro.png" /&gt;&lt;br /&gt;&lt;br /&gt;&lt;ul&gt;&lt;li&gt;Field as Element/Attribute &lt;/li&gt;&lt;li&gt;Filtering and Sorting &lt;/li&gt;&lt;li&gt;Master/Detail Data &lt;/li&gt;&lt;li&gt;Field Value Formatting &lt;/li&gt;&lt;li&gt;Null Value Handling &lt;/li&gt;&lt;li&gt;Custom View &lt;/li&gt;&lt;li&gt;Customizable Template &lt;/li&gt;&lt;li&gt;Template Extensions &lt;/li&gt;&lt;li&gt;Database Synchronization &lt;/li&gt;&lt;/ul&gt;&lt;p&gt;&lt;a href="http://www.hkvstore.com/aspxmlmaker/download.asp"&gt;demo&lt;/a&gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/09/asp-xmlmaker.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-7063540131574569789</guid><pubDate>Thu, 06 Sep 2007 12:05:00 +0000</pubDate><atom:updated>2007-09-06T15:08:31.233+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">jsp</category><category domain="http://www.blogger.com/atom/ns#">software</category><category domain="http://www.blogger.com/atom/ns#">tools</category><title>Jsp Maker</title><description>&lt;img src="http://www.hkvstore.com/jspmaker/images/jspmain.png" /&gt;&lt;br /&gt;&lt;br /&gt;&lt;ul&gt;&lt;br /&gt;&lt;li&gt;Create JSP for all tables &lt;/li&gt;&lt;li&gt;Form validation &lt;/li&gt;&lt;li&gt;User authentication &lt;/li&gt;&lt;li&gt;Database re-synchronization &lt;/li&gt;&lt;li&gt;Quick Generate Wizard &lt;/li&gt;&lt;li&gt;Customizable template &lt;/li&gt;&lt;li&gt;Master/Detail &lt;/li&gt;&lt;li&gt;File upload to folder or database &lt;/li&gt;&lt;li&gt;CSS stylesheet &lt;/li&gt;&lt;li&gt;Field Aggregation &lt;/li&gt;&lt;/ul&gt;&lt;p&gt;&lt;a href="http://www.hkvstore.com/jspmaker/download.asp"&gt;demo&lt;/a&gt;&lt;/p&gt;&lt;ul&gt;&lt;br /&gt;&lt;/ul&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/09/jsp-maker.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-239564933764622199</guid><pubDate>Thu, 06 Sep 2007 12:01:00 +0000</pubDate><atom:updated>2007-09-06T15:04:35.659+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">php</category><category domain="http://www.blogger.com/atom/ns#">software</category><category domain="http://www.blogger.com/atom/ns#">tools</category><title>Php maker</title><description>&lt;p&gt;&lt;img src="http://www.hkvstore.com/phpmaker/images/phpintro1.png" /&gt;&lt;/p&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt;* Advanced Security&lt;br /&gt;* User registration system&lt;br /&gt;* Export to CSV/HTML/Excel/Word/XML&lt;br /&gt;* File uploading to database or folder&lt;br /&gt;* Master/Detail&lt;br /&gt;* Custom View&lt;br /&gt;* Report&lt;br /&gt;* Customizable template&lt;br /&gt;* Database re-synchronization &lt;/p&gt;&lt;p&gt;&lt;a href="http://www.hkvstore.com/phpmaker/download.asp"&gt;Demo&lt;/a&gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/09/php-maker.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-2056536856878609888</guid><pubDate>Thu, 06 Sep 2007 11:52:00 +0000</pubDate><atom:updated>2007-09-06T15:00:26.692+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">asp.net</category><category domain="http://www.blogger.com/atom/ns#">software</category><category domain="http://www.blogger.com/atom/ns#">tools</category><title>Asp.net Maker</title><description>&lt;img src="http://www.hkvstore.com/aspnetmaker/images/main.png" /&gt;&lt;br /&gt;&lt;br /&gt;* All ASP.NET 2.0 scripts linked up properly&lt;br /&gt;* Optional list, add/copy, view, edit, delete and search pages for each table/view. (See &lt;a href="http://www.hkvstore.com/aspnetmaker/doc/tablesetup.htm" target="_blank"&gt;Table Setup&lt;/a&gt;) Customizable table display order.&lt;br /&gt;* Fully customizable View and Edit format for each field. (See &lt;a href="http://www.hkvstore.com/aspnetmaker/doc/fieldsetup.htm" target="_blank"&gt;Field Setup&lt;/a&gt;) Customizable field display order.&lt;br /&gt;* Various ASP.NET validators&lt;br /&gt;* Optional search features (Basic/Advanced/Both) for each table/view&lt;br /&gt;* Optional Advanced Security to protect data from unauthorized access (See &lt;a href="http://www.hkvstore.com/aspnetmaker/doc/securitysetup.htm" target="_blank"&gt;Security Settings&lt;/a&gt;)&lt;br /&gt;Complete user registration system&lt;br /&gt;* Optional HTML settings. Charset, font, CSS, HTML colors, HTML table settings with preview. (See &lt;a href="http://www.hkvstore.com/aspnetmaker/doc/htmlsetup.htm" target="_blank"&gt;HTML Settings&lt;/a&gt;)&lt;br /&gt;* Fully customizable template&lt;br /&gt;* Master/Detail pages&lt;br /&gt;* Various ASP.NET options (See &lt;a href="http://www.hkvstore.com/aspnetmaker/doc/aspnetsetup.htm" target="_blank"&gt;ASP.NET Settings&lt;/a&gt;)&lt;br /&gt;* Saving and restoring project from &lt;a href="http://www.hkvstore.com/aspnetmaker/doc/projectfile.htm" target="_blank"&gt;Project File&lt;/a&gt;&lt;br /&gt;* &lt;a href="http://www.hkvstore.com/aspnetmaker/doc/sync.htm" target="_blank"&gt;Synchronizes&lt;/a&gt; project settings with changes in database.&lt;br /&gt;* Creates virtual directory in IIS automatically&lt;br /&gt;* Cassini or IIS as testing web server&lt;br /&gt;* CSS stylesheet integration&lt;br /&gt;* Field aggregation (sum, average and count)&lt;br /&gt;* Custom View with built-in visual query builder&lt;br /&gt;* Basic reporting&lt;br /&gt;* ASP.NET inline editing&lt;br /&gt;* Export to HTML/Word/Excel/CSV/XML&lt;br /&gt;* Multi-column Sorting&lt;br /&gt;* User Selectable Page Size&lt;br /&gt;* Table-specific List Page Options&lt;br /&gt;* File Uploading to Folder and Database&lt;br /&gt;* Dynamic Table Loading&lt;br /&gt;* Composite key&lt;br /&gt;* Inline Delete&lt;br /&gt;* Highlight and select row color&lt;br /&gt;* Auto suggest textbox (ASP.NET AJAX)&lt;br /&gt;* Adding option to Selection List (ASP.NET AJAX)&lt;br /&gt;* Dynamic Selection List (ASP.NET AJAX)&lt;br /&gt;* Dynamic User Levels&lt;br /&gt;* Parent User ID&lt;br /&gt;* Auto-login&lt;br /&gt;* Extended quick search&lt;br /&gt;* Multi-page update&lt;br /&gt;* Fully customizable template and extensions&lt;br /&gt;* Audit trail and email notification on Add/Edit/Delete&lt;br /&gt;&lt;br /&gt;&lt;a href="http://www.hkvstore.com/aspnetmaker/download.asp"&gt;demo&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/09/aspnet-maker.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-4977469361697284339</guid><pubDate>Wed, 05 Sep 2007 20:39:00 +0000</pubDate><atom:updated>2007-09-06T00:07:56.534+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">software</category><category domain="http://www.blogger.com/atom/ns#">tools</category><title>Aptana ide</title><description>&lt;a href="http://www.aptana.com/images/screenshot_html_code_assist.png"&gt;&lt;img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 320px; CURSOR: hand" alt="" src="http://www.aptana.com/images/screenshot_html_code_assist.png" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;div&gt;&lt;br /&gt;Aptana is a robust, JavaScript-focused IDE for building dynamic web applications.Highlights &lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;span style="color:#ff0000;"&gt;&lt;br /&gt;include the following features:&lt;br /&gt;&lt;/span&gt;* Code Assist on JavaScript, HTML, and CSS languages, including your own JavaScript functions *Outliner that gives a snapshot view of your JavaScript, HTML, and CSS code structure&lt;br /&gt;* FTP/SFTP uploading, downloading and synchronization&lt;br /&gt;* JavaScript debugger to troubleshoot your code&lt;br /&gt;* Error and warning notification for your code&lt;br /&gt;* Support for Aptana UI customization and extensions&lt;br /&gt;* Cross-platform support&lt;br /&gt;* Free and source open under the &lt;a href="http://www.aptana.com/legal/apl/"&gt;Aptana Public License&lt;/a&gt;, v1.0.&lt;br /&gt;* Please note that milestone 9 is still a preview release &lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;/div&gt;&lt;br /&gt;&lt;div&gt;&lt;a href="http://www.aptana.com/download_all.php"&gt;download&lt;/a&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/09/aptana-is-robust-javascript-focused-ide.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-4930447622217770143</guid><pubDate>Sun, 26 Aug 2007 13:31:00 +0000</pubDate><atom:updated>2007-09-05T23:46:20.882+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">asp</category><category domain="http://www.blogger.com/atom/ns#">asp.net</category><category domain="http://www.blogger.com/atom/ns#">software</category><category domain="http://www.blogger.com/atom/ns#">tools</category><title>Asp express 5.0</title><description>&lt;a href="http://www.aspexpress.com/640/look.jpg"&gt;&lt;img style="WIDTH: 400px; CURSOR: hand" alt="" src="http://www.aspexpress.com/640/look.jpg" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;ul&gt;&lt;li&gt;ASP Express allows you the extreme flexibility of an HTML text editor, while giving you the automation of a great ASP and ASP.Net text editor. Just look at some of the features:ASP Features:Basic Structures, like:SelectIf-ThenDo-WhileFor/Next &lt;/li&gt;&lt;li&gt;ADO Connection Assistant&lt;/li&gt;&lt;li&gt;Here's one of the best ASP or ASP.Net additions to hit an editor in a long time.Automatically insert all the information for an ADO Connection with very little work at all. Just insert your variable names for Connection, Recordset, DSN &amp; SQL Select &amp;amp; Insert Statements. Then - for the best part of all - the SQL Select &amp; Insert Statement Assistants - use your local database copy to easily assemble your SQL Select or Insert Statements!&lt;/li&gt;&lt;li&gt;SQL Builder Assistant(works with MS Access AND SQL Server 7/2000)&lt;/li&gt;&lt;li&gt;Create complex SQL statements to use with your ADO connection - both SELECT (including Inner Join) &amp;amp; INSERT statements. All your tables &amp; fields are automatically accessible from pull-down menus, along with all the variable names you created on the page!Once you've done these short steps, voila - your ADO connection and your basic SQL statement is inserted and you didn't even break a sweat!(For direct SQL Server utilization, SQL tools must be installed on your development computer, like Enterprise Mgr/Client Network Utility) You can even choose to automatically insert the output in an HTML table or a Select List if you want!&lt;/li&gt;&lt;li&gt;Email Asstant&lt;/li&gt;&lt;li&gt;Easily create an ASP document using CDO to do your email jobs&lt;/li&gt;&lt;li&gt;Automatic FORM CODE GENERATOR&lt;/li&gt;&lt;li&gt;Choose your MS Access or SQL Server 7/200 database and table - ASP Express automatically generates the HTML for the input form!Choose between regular form format, or ASP.Net format!&lt;/li&gt;&lt;li&gt;The Express Toolbox&lt;/li&gt;&lt;li&gt;One tab lists all your commonly used ASP, ASP.Net VBScript , Javascript, &amp;amp; HTML tags and Assistants; one tab allows you to have a listing of your local files, and one tab allows for opening and saving your files web site files directly from the File Server using FTP&lt;/li&gt;&lt;li&gt;DataServer Window&lt;/li&gt;&lt;li&gt;Keep your data connections handy during ASP Express sessions - easily see which tables/fields are in the database and much more! &lt;/li&gt;&lt;li&gt;Greatly Improved FTP Capabilites - now FTP'ing of files is easier than ever!&lt;/li&gt;&lt;li&gt;Express Menus&lt;/li&gt;&lt;li&gt;Auto/Pop-up Completion for common ASP syntax such as Response, Request, &amp; Server. Soon - even more (Connection, Recordset, FilesystemObject)&lt;/li&gt;&lt;li&gt;Global ASA Template creation&lt;/li&gt;&lt;li&gt;Simple Key Strokes for opening &amp;amp; closing ASP scriptCode Librarian stocked with many code snippets - allows you to build your own often-used code snippet library!&lt;/li&gt;&lt;li&gt;ASP Hit Counter Assistant&lt;/li&gt;&lt;li&gt;Make any HTML tag phrase 'Response.Write' - ready - highlight and convert your HTML into a Response.Write statement!Go To Line Number FeatureTurn WordWrapping on or off as needed .A 'REQUEST' Assistant for easily adding Request.Form &amp; Request.QueryString Variables &amp;amp; Form Field Text Box Input Names, along with Server Variables in a pull down list!&lt;/li&gt;&lt;li&gt;An Easy RESPONSE Assistant for easily adding Response.Write statements!&lt;br /&gt;Seamlessly add include statements, browsing for the files&lt;/li&gt;&lt;li&gt;Easily Drag &amp; Drop between ASP Express &amp;amp; other applications&lt;/li&gt;&lt;li&gt;When you format your HTML text - it stays highlighted to more easily add other HTML formatting or links to existing text&lt;/li&gt;&lt;li&gt;Easily create an HTML Table from Excel or Access data pasted into ASP Express - with a simple double-click!&lt;/li&gt;&lt;li&gt;Full Search &amp;amp; Replace within open documents or even entire subdirectories!&lt;br /&gt;&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;&lt;a href="http://www.aspexpress.com/download.aspx?id=8"&gt;45 days shareware download&lt;/a&gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/asp-express-50.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-4038071577025846854</guid><pubDate>Sun, 26 Aug 2007 13:15:00 +0000</pubDate><atom:updated>2007-09-05T23:46:20.883+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">php</category><category domain="http://www.blogger.com/atom/ns#">software</category><category domain="http://www.blogger.com/atom/ns#">tools</category><title>phpDesigner 2007 Professional 5.5.1</title><description>&lt;a href="http://www.mpsoftware.eu/images/img_codeexplorer_information.gif"&gt;&lt;img style="FLOAT: left; MARGIN: 0px 10px 10px 0px; WIDTH: 400px; CURSOR: hand" alt="" src="http://www.mpsoftware.eu/images/img_codeexplorer_information.gif" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;span style="color:#cc0000;"&gt;&lt;strong&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Syntax Highlighters &lt;/strong&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="color:#cc0000;"&gt;&lt;strong&gt;&lt;br /&gt;&lt;/strong&gt;&lt;/span&gt;•Intelligent Highlighter that automatically switch between PHP, HTML, CSS, and JavaScript depending on your position!&lt;br /&gt;•PHP (both version 4 and 5 are supported)&lt;br /&gt;•SQL (MySQL, MSSQL 2000, MSSQL 7, Ingres, Interbase 6, Oracle, Sybase)&lt;br /&gt;•HTML/XHTML&lt;br /&gt;•CSS (both version 1 and 2.1 are supported)&lt;br /&gt;•JavaScript&lt;br /&gt;•VBScript&lt;br /&gt;•Java&lt;br /&gt;•C#&lt;br /&gt;•Perl&lt;br /&gt;•Python&lt;br /&gt;•Ruby&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;&lt;span style="color:#990000;"&gt;Intelligent and Advanced Editing&lt;br /&gt;&lt;/span&gt;&lt;/strong&gt;&lt;br /&gt;•PHP code explorer shows all classes, extended classes, interfaces, properties, functions, constants and variables&lt;br /&gt;•Intelligent code suggestions for PHP with full support for PHP 5.2, nested objects and object-oriented programming!&lt;br /&gt;•Intelligent code suggestions for HTML/XHTML&lt;br /&gt;•Intelligent code suggestions for CSS (both version 1 and 2.1 are supported)&lt;br /&gt;•Intelligent code tip are displayed as you type, it shows you description, arguments and returning values for typed PHP functions including what version its available in!&lt;br /&gt;•Highlight (un)matching brackets/tags&lt;br /&gt;•Select or jump to matching brackets/tags&lt;br /&gt;•Automatic indent or close brackets&lt;br /&gt;•Jump to any declaration with filtering by classes, interfaces, functions, variables or constants&lt;br /&gt;•Auto completions and corrections&lt;br /&gt;•Bookmarks (1-9)&lt;br /&gt;•Search and replace in multiple files with support for highlighting search results and regular expression&lt;br /&gt;•Drag-n-drop text and files are supported&lt;br /&gt;•Advanced printing options&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;&lt;span style="color:#990000;"&gt;Project and File Management&lt;/span&gt;&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;•PHP Code explorer shows all classes, extends, interfaces, properties, functions, constants and variables in the project&lt;br /&gt;•Jump to any declaration in project files with filtering by classes, interfaces, functions, variables or constants&lt;br /&gt;•Framework support&lt;br /&gt;•Integration with 3rd party tools like Tortoise SVN or Tortoise CVS in the file and project browser&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;&lt;span style="color:#990000;"&gt;PHP&lt;br /&gt;&lt;/span&gt;&lt;/strong&gt;&lt;br /&gt;•Support for both PHP 4 and PHP 5&lt;br /&gt;•Work with any PHP frameworks!&lt;br /&gt;•Support for PHP heredoc&lt;br /&gt;•Enclose strings with single- or double quotes, linefeed, carriage return or tabs&lt;br /&gt;•PHP server variables&lt;br /&gt;•PHP statement templates (if, else, then, while…)&lt;br /&gt;•PHP code beautifier with many configurations&lt;br /&gt;•phpDocumentor wizard&lt;br /&gt;•Add phpDocumentor documentation to functions and classes with one click!&lt;br /&gt;•phpDocumentor tags&lt;br /&gt;•Smarty tags&lt;br /&gt;•Comment or uncomment with one click!&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;&lt;span style="color:#990000;"&gt;Debug/Run &amp; Preview&lt;/span&gt;&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;•Live syntax check for PHP, HTML and CSS&lt;br /&gt;•Debug/Run PHP using the PHP Interpreter&lt;br /&gt;•Syntax check PHP using the PHP Interpreter&lt;br /&gt;•Localhost Preview&lt;br /&gt;•Preview with Internet Explorer, Firefox, Netscape, Opera and Safari&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;&lt;span style="color:#990000;"&gt;HTML/XHTML&lt;/span&gt;&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;•Support for HTML 4.01 strict/transitional/frameset&lt;br /&gt;•Support for XHTML 1.0 strict/transitional/frameset&lt;br /&gt;•Link-, image-, table-, list-, meta-, flash, forms-, font and color dialog&lt;br /&gt;•Formatting tools&lt;br /&gt;•Color picker&lt;br /&gt;•HTML Tidy (code beutifier for HTML/XHTML)&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;&lt;span style="color:#990000;"&gt;Integrated Help&lt;br /&gt;&lt;/span&gt;&lt;/strong&gt;&lt;br /&gt;•Contextual help for PHP (detailed information about more than 3000 native PHP functions on the fly using the PHP manual)&lt;br /&gt;•Contextual search (search engines)&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;&lt;span style="color:#990000;"&gt;Code Libraries&lt;br /&gt;&lt;/span&gt;&lt;/strong&gt;&lt;br /&gt;•PHP&lt;br /&gt;•phpDocumentor&lt;br /&gt;•Smarty&lt;br /&gt;•SQL (MySQL, MSSQL 2000, MSSQL 7, Ingres, Interbase 6, Oracle, Sybase)&lt;br /&gt;•HTML&lt;br /&gt;•XML&lt;br /&gt;•CSS&lt;br /&gt;•JavaScript&lt;br /&gt;•VBScript&lt;br /&gt;•Java&lt;br /&gt;•C#&lt;br /&gt;•Perl&lt;br /&gt;•Python&lt;br /&gt;•Ruby&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;&lt;span style="color:#990000;"&gt;Tools&lt;br /&gt;&lt;/span&gt;&lt;/strong&gt;&lt;br /&gt;•Application Manager&lt;br /&gt;•Code Snippets&lt;br /&gt;•Code templates allow you to type whole code fragments with one single click!&lt;br /&gt;•Remote FTP editing&lt;br /&gt;•Todo &amp;amp; Bug manager (embedded and external)&lt;br /&gt;•Database connection manager&lt;br /&gt;•Database browser (using phpMyAdmin)&lt;br /&gt;•Date/Time Manager&lt;br /&gt;•SSI&lt;br /&gt;•TortoiseSVN integration&lt;br /&gt;•Export to HTML, RTF and LaTeX&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;&lt;span style="color:#990000;"&gt;File Encoding&lt;/span&gt;&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;•ANSI (iso/windows)&lt;br /&gt;•UTF-8 (with and without BOM)&lt;br /&gt;•UTF 16 LE/BE (with and without BOM)&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;&lt;span style="color:#990000;"&gt;User Interface&lt;br /&gt;&lt;/span&gt;&lt;/strong&gt;&lt;br /&gt;•Fully customizable workspace with drag- and floatable toolbars/panels&lt;br /&gt;•Theme support&lt;br /&gt;•Save/load desktop layout&lt;br /&gt;&lt;br /&gt;&lt;a href="http://www.mpsoftwareweb.com/mirror/mirror.php?app=phpdesigner2007_5_5_1"&gt;Free trial download&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/phpdesigner-2007-professional-551.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-6817732170854988545</guid><pubDate>Thu, 23 Aug 2007 07:15:00 +0000</pubDate><atom:updated>2007-08-23T10:16:41.813+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">ruby</category><title>Print Exception Class Hieararchy</title><description>Author: dr_bob&lt;br /&gt;&lt;br /&gt;require 'pp'&lt;br /&gt;tree = (cr = lambda {h,k h[k] = Hash.new &amp;amp;cr})[{},nil]&lt;br /&gt;ObjectSpace.each_object(Class) {cl if cl.ancestors.include? Exception&lt;br /&gt;then cl.ancestors.reverse.inject(tree){tr,cl tr[cl]} end}&lt;br /&gt;pp tree&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/print-exception-class-hieararchy.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-2142425274173886992</guid><pubDate>Thu, 23 Aug 2007 07:12:00 +0000</pubDate><atom:updated>2007-08-23T10:14:23.395+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">ruby</category><title>Extend Float and FixNum to do calculations in S.I. units</title><description>Source: &lt;a href="http://stephan.walter.name/Ruby_snippets"&gt;http://stephan.walter.name/Ruby_snippets&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;p&gt;module SiUnits&lt;br /&gt;def mega; self * 1000.kilo; end&lt;br /&gt;def kilo; self * 1000; end&lt;br /&gt;def milli; self * 0.001; end&lt;br /&gt;def micro; self * 0.001.milli; end&lt;/p&gt;&lt;p&gt;def seconds; self; end&lt;br /&gt;def minutes; self * 60; end&lt;br /&gt;def hours; self * 60.minutes; end&lt;br /&gt;def days; self * 24.hours; end&lt;br /&gt;def years; self * 365.days; end&lt;/p&gt;&lt;br /&gt;&lt;p&gt;def metres; self; end&lt;br /&gt;def grams; self * 0.001; end&lt;br /&gt;end&lt;/p&gt;&lt;p&gt;class Float; include SiUnits; end&lt;br /&gt;class Fixnum; include SiUnits; end&lt;br /&gt;&lt;br /&gt;p 2.days # =&amp;gt; 172800&lt;br /&gt;p 3.milli.metres # =&amp;gt; 0.003&lt;br /&gt;p 4.kilo.grams # =&amp;gt; 4.0&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/extend-float-and-fixnum-to-do.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-8368230546940592472</guid><pubDate>Thu, 23 Aug 2007 07:06:00 +0000</pubDate><atom:updated>2007-08-23T10:11:25.271+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">ruby</category><title>Extend String to use ActionView's Text Helpers</title><description>Author: curtissummers, &lt;a href="http://www.csummers.org/index.php/2006/08/07/extend-string-to-use-actionviews-text-helpers/"&gt;http://www.csummers.org/index.php/2006/08/07/extend-string-to-use-actionviews-text-helpers/&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;p&gt;#ActionView's TextHelper methods are useful, but I often need to use them in my controller or my model. For several of the TextHelper methods that expect a string as input, it makes sense to extend the String class.&lt;br /&gt;#So, if I want to strip HTML tags, auto link any URLs, and then simple format a comment (in that order) before I save it in the database I can do:&lt;br /&gt;class Comment &amp;lt; ActiveRecord::Base&lt;br /&gt;#...&lt;br /&gt;&lt;br /&gt;def before_save&lt;br /&gt;self.text = self.text.strip_tags.auto_link.simple_format&lt;br /&gt;end&lt;br /&gt;end&lt;/p&gt;&lt;p&gt;# This method is much cleaner than including ActionView::Helpers::TextHelper in whatever class I'm in and passing the string as an argument to each method.&lt;br /&gt;# Below is the magic code. Since TextHelper is a module, we create a Singleton class to reference the methods, create the wrapper methods in their own module, and finally include that module in the String class. Note that not all TextHelper methods are included–just the ones that make sense. Drop this code into a file and require it in your environment or within a plugin.&lt;br /&gt;# ActionView Text Helpers are great!&lt;br /&gt;# Let's extend the String class to allow us to call&lt;br /&gt;# some of these methods directly on a String.&lt;br /&gt;# Note:&lt;br /&gt;# - cycle-related methods are not included&lt;br /&gt;# - concat is not included&lt;br /&gt;# - pluralize is not included because it is in&lt;br /&gt;# ActiveSupport String extensions already&lt;br /&gt;# (though they differ).&lt;br /&gt;# - markdown requires BlueCloth&lt;br /&gt;# - textilize methods require RedCloth&lt;br /&gt;# Example:&lt;br /&gt;# "&amp;lt;b&amp;gt;coolness&amp;lt;/b&amp;gt;".strip_tags -&amp;gt; "coolness"&lt;/p&gt;&lt;p&gt;require 'singleton'&lt;/p&gt;&lt;p&gt;# Singleton to be called in wrapper module&lt;br /&gt;class TextHelperSingleton&lt;br /&gt;include Singleton&lt;br /&gt;include ActionView::Helpers::TextHelper&lt;br /&gt;include ActionView::Helpers::TagHelper #tag_options needed by auto_link&lt;br /&gt;end&lt;/p&gt;&lt;p&gt;# Wrapper module&lt;br /&gt;module MyExtensions #:nodoc:&lt;br /&gt;module CoreExtensions #:nodoc:&lt;br /&gt;module String #:nodoc:&lt;br /&gt;module TextHelper&lt;/p&gt;&lt;p&gt;def auto_link(link = :all, href_options = {}, &amp;block)&lt;br /&gt;TextHelperSingleton.instance.auto_link(self, link, href_options, &amp;amp;block)&lt;br /&gt;end&lt;/p&gt;&lt;p&gt;def excerpt(phrase, radius = 100, excerpt_string = "…")&lt;br /&gt;TextHelperSingleton.instance.excerpt(self, phrase, radius, excerpt_string)&lt;br /&gt;end&lt;/p&gt;&lt;p&gt;def highlight(phrase, highlighter = '&amp;lt;strong class="highlight"&amp;gt;\1&amp;lt;/strong&amp;gt;')&lt;br /&gt;TextHelperSingleton.instance.highlight(self, phrase, highlighter)&lt;br /&gt;end&lt;br /&gt;begin&lt;br /&gt;require_library_or_gem 'bluecloth'&lt;br /&gt;def markdown&lt;br /&gt;TextHelperSingleton.instance.markdown(self)&lt;br /&gt;end&lt;br /&gt;rescue LoadError&lt;br /&gt;# do nothing. method will be undefined&lt;br /&gt;end&lt;br /&gt;def sanitize&lt;br /&gt;TextHelperSingleton.instance.sanitize(self)&lt;br /&gt;end&lt;br /&gt;def simple_format&lt;br /&gt;TextHelperSingleton.instance.simple_format(self)&lt;br /&gt;end&lt;br /&gt;def strip_tags&lt;br /&gt;TextHelperSingleton.instance.strip_tags(self)&lt;br /&gt;end&lt;br /&gt;begin&lt;br /&gt;require_library_or_gem 'redcloth'&lt;br /&gt;def textilize&lt;br /&gt;TextHelperSingleton.instance.textilize(self)&lt;br /&gt;end&lt;br /&gt;def textilize_without_paragraph&lt;br /&gt;TextHelperSingleton.instance.textilize_without_paragraph(self)&lt;br /&gt;end&lt;br /&gt;rescue LoadError&lt;br /&gt;# do nothing. methods will be undefined&lt;br /&gt;end&lt;br /&gt;def truncate(length = 30, truncate_string = "…")&lt;br /&gt;TextHelperSingleton.instance.truncate(self, length, truncate_string)&lt;br /&gt;end&lt;br /&gt;def word_wrap(line_width = 80)&lt;br /&gt;TextHelperSingleton.instance.word_wrap(self, line_width)&lt;br /&gt;end&lt;br /&gt;end&lt;br /&gt;end&lt;br /&gt;end&lt;br /&gt;end&lt;/p&gt;&lt;p&gt;# extend String with the TextHelper functions&lt;br /&gt;class String #:nodoc:&lt;br /&gt;include MyExtensions::CoreExtensions::String::TextHelper&lt;br /&gt;end&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/extend-string-to-use-actionviews-text.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-2833044923878642412</guid><pubDate>Thu, 23 Aug 2007 07:01:00 +0000</pubDate><atom:updated>2007-08-23T10:04:45.183+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">ruby</category><title>Full text searching for ri content</title><description>Author: zenspider, &lt;a href="http://blog.zenspider.com/archives/2006/08/full_text_searc.html"&gt;http://blog.zenspider.com/archives/2006/08/full_text_searc.html&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;p&gt;#From ZenSpider, http://blog.zenspider.com/archives/2006/08/full_text_searc.html:&lt;br /&gt;#Check it out. Quick and dirty searching of ri content:&lt;br /&gt;#Updated using: &lt;a href="http://blog.zenspider.com/archives/2006/08/new_and_improve.html"&gt;http://blog.zenspider.com/archives/2006/08/new_and_improve.html&lt;/a&gt;&lt;br /&gt;# They added path independence and searching of gems and local installed ri/rdoc. Enjoy!#!/usr/local/bin/ruby -w&lt;/p&gt;&lt;p&gt;require 'rdoc/ri/ri_paths'&lt;br /&gt;require 'find'&lt;br /&gt;require 'yaml'&lt;br /&gt;search = ARGV.shift&lt;br /&gt;puts "Searching for #{search}"&lt;br /&gt;puts&lt;br /&gt;dirs = RI::Paths::PATH&lt;br /&gt;dirs.each do dir&lt;br /&gt;Dir.chdir dir do&lt;br /&gt;Find.find('.') do path&lt;br /&gt;next unless test ?f, path&lt;br /&gt;yaml = File.read path&lt;br /&gt;if yaml =~ /#{search}/io then&lt;br /&gt;full_name = $1 if yaml[/full_name: (.*)/]&lt;br /&gt;puts "** FOUND IN: #{full_name}"&lt;br /&gt;data = YAML.load yaml.gsub(/ \!.*/, '')&lt;br /&gt;desc = data['comment'].map { x x.values }.flatten.join("\n").gsub(/&amp;amp;quot;/, "'").gsub(/&amp;amp;lt;/, "&amp;lt;").gsub(/&amp;amp;gt;/, "&amp;gt;").gsub(/&amp;amp;amp;/, "&amp;")&lt;br /&gt;puts&lt;br /&gt;puts desc&lt;br /&gt;puts&lt;br /&gt;end&lt;br /&gt;end&lt;br /&gt;end&lt;br /&gt;end&lt;br /&gt;&lt;br /&gt;# Lets you do stuff like:&lt;br /&gt;% ./risearch.rb duplicate&lt;br /&gt;# Searching for duplicate&lt;br /&gt;&lt;br /&gt;[...]&lt;br /&gt;&lt;br /&gt;** FOUND IN: Array#uniq!&lt;br /&gt;# Removes duplicate elements from self. Returns nil if no changes are made (that is, no duplicates are found).&lt;br /&gt;a = [ 'a', 'a', 'b', 'b', 'c' ]&lt;br /&gt;a.uniq! #=&amp;gt; ['a', 'b', 'c']&lt;br /&gt;b = [ 'a', 'b', 'c' ]&lt;br /&gt;b.uniq! #=&amp;gt; nil&lt;br /&gt;** FOUND IN: Array#&lt;br /&gt;# Set Union---Returns a new array by joining this array with other_array, removing duplicates.&lt;br /&gt;[ 'a', 'b', 'c' ]  [ 'c', 'd', 'a' ]&lt;br /&gt;#=&amp;gt; [ 'a', 'b', 'c', 'd' ]&lt;br /&gt;[...]&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/full-text-searching-for-ri-content.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-8107666672338395786</guid><pubDate>Thu, 23 Aug 2007 06:55:00 +0000</pubDate><atom:updated>2007-08-23T09:59:46.396+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">ruby</category><title>Load a Web page in Ruby and print information</title><description>Author: jswizard , http://www.juretta.com/log/2006/08/13/ruby_net_http_and_open-uri/&lt;br /&gt;&lt;br /&gt;&lt;p&gt;require 'open-uri'&lt;br /&gt;require 'pp'&lt;br /&gt;open('http://www.juretta.com/') do f&lt;br /&gt;# hash with meta information&lt;br /&gt;pp f.meta&lt;/p&gt;&lt;p&gt;#&lt;br /&gt;pp "Content-Type: " + f.content_type&lt;br /&gt;pp "last modified" + f.last_modified.to_s&lt;br /&gt;no = 1&lt;br /&gt;&lt;br /&gt;# print the first three lines&lt;br /&gt;f.each do line&lt;br /&gt;print "#{no}: #{line}"&lt;br /&gt;no += 1&lt;br /&gt;break if no &amp;gt; 4&lt;br /&gt;end&lt;br /&gt;end&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/load-web-page-in-ruby-and-print.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-1661873110568712253</guid><pubDate>Wed, 22 Aug 2007 09:16:00 +0000</pubDate><atom:updated>2007-08-22T12:22:19.753+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">php</category><title>How to Find the Current URL with PHP</title><description>source: &lt;a href="http://discomoose.org/2005/11/02/how-to-find-the-current-url-with-php/"&gt;http://discomoose.org/2005/11/02/how-to-find-the-current-url-with-php/&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;?php&lt;br /&gt;// find out the domain:&lt;br /&gt;$domain = $_SERVER['HTTP_HOST'];&lt;br /&gt;&lt;br /&gt;// find out the path to the current file:&lt;br /&gt;$path = $_SERVER['SCRIPT_NAME'];&lt;br /&gt;&lt;br /&gt;// find out the QueryString:&lt;br /&gt;$queryString = $_SERVER['QUERY_STRING'];&lt;br /&gt;&lt;br /&gt;// put it all together:&lt;br /&gt;$url = "http://" . $domain . $path . "?" . $queryString;&lt;br /&gt;echo "The current URL is: " . $url . "&amp;lt;br /&amp;gt;";&lt;br /&gt;&lt;br /&gt;// An alternative way is to use REQUEST_URI instead of both&lt;br /&gt;// SCRIPT_NAME and QUERY_STRING, if you don't need them seperate:&lt;br /&gt;$url2 = "http://" . $domain . $_SERVER['REQUEST_URI'];&lt;br /&gt;echo "The alternative way: " . $url2;&lt;br /&gt;?&amp;gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/how-to-find-current-url-with-php.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-5117970494105341054</guid><pubDate>Sat, 18 Aug 2007 16:12:00 +0000</pubDate><atom:updated>2007-08-18T19:14:55.438+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">c#</category><title>Encrypting data from one stream to another and attaching hash of the password</title><description>resource: &lt;a href="http://devdistrict.com/CodeDetails.aspx?A=54"&gt;http://devdistrict.com/CodeDetails.aspx?A=54&lt;/a&gt;&lt;br /&gt;using System.Security.Cryptography;&lt;br /&gt;using System.IO;&lt;br /&gt;using System.Data;&lt;br /&gt;using System;&lt;br /&gt;using System.Collections;&lt;br /&gt;using System.ComponentModel;&lt;br /&gt;&lt;br /&gt;public class PasswordEncryptor&lt;br /&gt;{&lt;br /&gt;private byte[] _keyBytes;&lt;br /&gt;private byte[] _IVBytes;&lt;br /&gt;private int _bufferSize=256;&lt;br /&gt;private byte[] _hash;&lt;br /&gt;&lt;br /&gt;public PasswordEncryptor(string password)&lt;br /&gt;{&lt;br /&gt;byte[] saltValueBytes = null;&lt;br /&gt;PasswordDeriveBytes pdb = new PasswordDeriveBytes(password,saltValueBytes,"SHA1",50);&lt;br /&gt;_keyBytes = pdb.GetBytes(32);&lt;br /&gt;_IVBytes = pdb.GetBytes(16);&lt;br /&gt;HashAlgorithm hasher = SHA256.Create();&lt;br /&gt;_hash = hasher.ComputeHash(System.Text.ASCIIEncoding.ASCII.GetBytes("password"));&lt;br /&gt;}&lt;br /&gt;public void EncryptWithHash(Stream input, ref Stream output)&lt;br /&gt;{&lt;br /&gt;output.Write(_hash,0,_hash.Length);&lt;br /&gt;RijndaelManaged rj = new System.Security.Cryptography.RijndaelManaged();&lt;br /&gt;rj.Mode= CipherMode.CBC;&lt;br /&gt;ICryptoTransform trans = rj.CreateEncryptor(_keyBytes, _IVBytes);&lt;br /&gt;CryptoStream cs = new CryptoStream(output, trans, CryptoStreamMode.Write);&lt;br /&gt;byte[] bytes = new byte[_bufferSize];&lt;br /&gt;int byteCount;&lt;br /&gt;while((byteCount = input.Read(bytes, 0, bytes.Length))!= 0)&lt;br /&gt;{&lt;br /&gt;cs.Write(bytes,0,byteCount);&lt;br /&gt;}&lt;br /&gt;cs.FlushFinalBlock();&lt;br /&gt;//cs.Close();&lt;br /&gt;}&lt;br /&gt;public void DecryptWithHash(Stream input, ref Stream output)&lt;br /&gt;{&lt;br /&gt;byte[] inputHash = new byte[_hash.Length];&lt;br /&gt;input.Read(inputHash,0,_hash.Length);&lt;br /&gt;if (inputHash.Length!=_hash.Length) throw new Exception("Invalid Password");&lt;br /&gt;for (int i=0;i&lt;_hash.Length;i++)&lt;br /&gt;{&lt;br /&gt;if (_hash[i]!=inputHash[i]) throw new Exception("Invalid Password");&lt;br /&gt;}&lt;br /&gt;RijndaelManaged rj = new System.Security.Cryptography.RijndaelManaged();&lt;br /&gt;rj.Mode= CipherMode.CBC;&lt;br /&gt;ICryptoTransform trans = rj.CreateDecryptor(_keyBytes, _IVBytes);&lt;br /&gt;CryptoStream cs = new CryptoStream(input, trans, CryptoStreamMode.Read);&lt;br /&gt;byte[] bytes = new byte[_bufferSize];&lt;br /&gt;int byteCount;&lt;br /&gt;while((byteCount = cs.Read(bytes, 0, bytes.Length))!= 0)&lt;br /&gt;{&lt;br /&gt;output.Write(bytes,0,byteCount);&lt;br /&gt;}&lt;br /&gt;cs.Flush();&lt;br /&gt;}&lt;br /&gt;}&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/encrypting-data-from-one-stream-to.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-2118543539472958627</guid><pubDate>Sat, 18 Aug 2007 16:09:00 +0000</pubDate><atom:updated>2007-08-18T19:11:17.337+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">c#</category><title>RC4 Encryption</title><description>author: Rick Sands, &lt;a href="http://www.bytemycode.com/snippets/snippet/93/"&gt;http://www.bytemycode.com/snippets/snippet/93/&lt;/a&gt;&lt;br /&gt;// RC4 Encryption&lt;br /&gt;&lt;br /&gt;/*&lt;br /&gt;From RSA Security's website:&lt;br /&gt;"RC4 is a stream cipher designed by Rivest for RSA Data&lt;br /&gt;Security (now RSA Security). It is a variable key-size stream&lt;br /&gt;cipher with byte-oriented operations. The algorithm is based on&lt;br /&gt;the use of a random permutation. Analysis shows that the period&lt;br /&gt;of the cipher is overwhelmingly likely to be greater than 10^100.&lt;br /&gt;Eight to sixteen machine operations are required per output byte,&lt;br /&gt;and the cipher can be expected to run very quickly in software.&lt;br /&gt;Independent analysts have scrutinized the algorithm and it is&lt;br /&gt;considered secure."&lt;br /&gt;This implementation encodes the byte stream to be encrypted&lt;br /&gt;"in-place".&lt;br /&gt;------------&lt;br /&gt;// Examples:&lt;br /&gt;------------&lt;br /&gt;Byte[] Key = new Byte[5] { 12, 34, 22, 12, 32 };&lt;br /&gt;Byte[] B = new Byte[10] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };&lt;br /&gt;// Examine B array before and after this next call.&lt;br /&gt;RC4(ref B, Key);&lt;br /&gt;// Examine B array before and after this next call.&lt;br /&gt;RC4(ref B, Key);&lt;br /&gt;*/&lt;br /&gt;&lt;br /&gt;public void RC4(ref Byte[] bytes, Byte[] key )&lt;br /&gt;{&lt;br /&gt;Byte[] s = new Byte[256];&lt;br /&gt;Byte[] k = new Byte[256];&lt;br /&gt;Byte temp;&lt;br /&gt;int i, j, t;&lt;br /&gt;int byteLen = bytes.GetLength(0);&lt;br /&gt;int keyLen = key.GetLength(0);&lt;br /&gt;&lt;br /&gt;// Generate "8x8 S-Box" and initialize key index&lt;br /&gt;for (i = 0; i &lt; 256; i++)&lt;br /&gt;{&lt;br /&gt;s[i] = (Byte) i;&lt;br /&gt;k[i] = key[i % keyLen];&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;j = 0;&lt;br /&gt;for (i = 0; i&lt;256; i++)&lt;br /&gt;{&lt;br /&gt;j = (j + s[i] + k[i]) % 256;&lt;br /&gt;// swap&lt;br /&gt;temp = s[i];&lt;br /&gt;s[i] = s[j];&lt;br /&gt;s[j] = temp;&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;i = j = 0;&lt;br /&gt;for (int x = 0; x &lt; byteLen; x++)&lt;br /&gt;{&lt;br /&gt;// The following is used to generate a random byte&lt;br /&gt;i = (i + 1) % 256;&lt;br /&gt;j = (j + s[i]) % 256;&lt;br /&gt;temp = s[i];&lt;br /&gt;s[i] = s[j];&lt;br /&gt;s[j] = temp;&lt;br /&gt;t = ((int)s[i] + s[j]) % 256;&lt;br /&gt;// which is xor'd to the source&lt;br /&gt;bytes[x] ^= s[t];&lt;br /&gt;}&lt;br /&gt;}&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/rc4-encryption.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-3369666264883381301</guid><pubDate>Wed, 15 Aug 2007 14:10:00 +0000</pubDate><atom:updated>2007-08-15T17:13:08.929+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">c#</category><category domain="http://www.blogger.com/atom/ns#">vb.net</category><category domain="http://www.blogger.com/atom/ns#">visual basic</category><title>Use VB Component in C#</title><description>Imports System&lt;br /&gt;Namespace hellovb&lt;br /&gt;Public Class HelloString&lt;br /&gt;Public Function GetString() As String&lt;br /&gt;&lt;br /&gt;Console.WriteLine ("Hello World in Visual Basic Program")&lt;br /&gt;&lt;br /&gt;End Function&lt;br /&gt;End Class&lt;br /&gt;End Namespace &lt;p&gt;&lt;/p&gt;&lt;br /&gt;&lt;p&gt;' Compile it using vbc /t:library hellovb.vb&lt;br /&gt;' This command will generate hellovb.dll&lt;br /&gt;' Hello World program in C# (hellocs.cs)&lt;/p&gt;&lt;br /&gt;&lt;p&gt;using System;&lt;br /&gt;namespace hellocs{&lt;br /&gt;public class displayA&lt;br /&gt;&lt;br /&gt;{&lt;br /&gt;&lt;br /&gt;public void Displayhello()&lt;br /&gt;{&lt;br /&gt;Console.WriteLine("Hello in C# Program");&lt;br /&gt;}&lt;br /&gt;}&lt;br /&gt;}&lt;/p&gt;&lt;p&gt;' Compile it using csc /t:library hellocs.cs&lt;br /&gt;' This command will generate hellocs.dll&lt;br /&gt;' Main program(in c#) in which we will use these libraries&lt;/p&gt;&lt;p&gt;Main Program in C# (maincs.cs)&lt;br /&gt;using System;&lt;br /&gt;using hellocs;&lt;br /&gt;using hellovb;&lt;br /&gt;class maincs&lt;br /&gt;&lt;br /&gt;{&lt;br /&gt;public static void Main()&lt;br /&gt;{&lt;br /&gt;&lt;br /&gt;hellovb.HelloString vb = new hellovb.HelloString(); // namespace.classname of hellovb.vb&lt;br /&gt;vb.GetString(); //Calling vb function&lt;br /&gt;hellocs.displayA cs = new hellocs.displayA(); // namespace.classname of hellocs.cs&lt;br /&gt;cs.Displayhello(); //Calling vb function&lt;br /&gt;}&lt;br /&gt;}&lt;/p&gt;&lt;p&gt;' Compile it using command csc maincs.cs /r:hellocs.dll;hellovb.dll&lt;br /&gt;' Output will be&lt;br /&gt;' Hello World in Visual Basic Program&lt;br /&gt;' Hello in C# Program&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/use-vb-component-in-c.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-3434379745123648355</guid><pubDate>Mon, 13 Aug 2007 18:37:00 +0000</pubDate><atom:updated>2007-08-13T21:41:58.249+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">asp.net</category><title>Using Cryptography to Encrypt Data in ASP.NET</title><description>'author: Wayne Plourde , &lt;a href="http://www.15seconds.com/issue/021210.htm"&gt;http://www.15seconds.com/issue/021210.htm&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&lt;p&gt;Imports System.Diagnostics&lt;br /&gt;Imports System.Security.Cryptography&lt;br /&gt;Imports System.Text&lt;br /&gt;Imports System.IO&lt;/p&gt;&lt;p&gt;Public Class CryptoUtil&lt;br /&gt;'8 bytes randomly selected for both the Key and the Initialization Vector&lt;br /&gt;'the IV is used to encrypt the first block of text so that any repetitive&lt;br /&gt;'patterns are not apparent&lt;br /&gt;Private Shared KEY_64() As Byte = {42, 16, 93, 156, 78, 4, 218, 32}&lt;br /&gt;Private Shared IV_64() As Byte = {55, 103, 246, 79, 36, 99, 167, 3}&lt;/p&gt;&lt;p&gt;'24 byte or 192 bit key and IV for TripleDES&lt;br /&gt;Private Shared KEY_192() As Byte = {42, 16, 93, 156, 78, 4, 218, 32, _&lt;br /&gt;15, 167, 44, 80, 26, 250, 155, 112, _&lt;br /&gt;2, 94, 11, 204, 119, 35, 184, 197}&lt;br /&gt;Private Shared IV_192() As Byte = {55, 103, 246, 79, 36, 99, 167, 3, _&lt;br /&gt;42, 5, 62, 83, 184, 7, 209, 13, _&lt;br /&gt;145, 23, 200, 58, 173, 10, 121, 222}&lt;br /&gt;'Standard DES encryption&lt;br /&gt;Public Shared Function Encrypt(ByVal value As String) As String&lt;br /&gt;If value &amp;lt;&amp;gt; "" Then&lt;br /&gt;Dim cryptoProvider As DESCryptoServiceProvider = _&lt;br /&gt;New DESCryptoServiceProvider()&lt;br /&gt;Dim ms As MemoryStream = New MemoryStream()&lt;br /&gt;Dim cs As CryptoStream = _&lt;br /&gt;New CryptoStream(ms, cryptoProvider.CreateEncryptor(KEY_64, IV_64), _&lt;br /&gt;CryptoStreamMode.Write)&lt;br /&gt;Dim sw As StreamWriter = New StreamWriter(cs)&lt;/p&gt;&lt;p&gt;sw.Write(value)&lt;br /&gt;sw.Flush()&lt;br /&gt;cs.FlushFinalBlock()&lt;br /&gt;ms.Flush()&lt;/p&gt;&lt;p&gt;'convert back to a string&lt;br /&gt;Return Convert.ToBase64String(ms.GetBuffer(), 0, ms.Length)&lt;br /&gt;End If&lt;br /&gt;End Function&lt;br /&gt;&lt;br /&gt;'Standard DES decryption&lt;br /&gt;Public Shared Function Decrypt(ByVal value As String) As String&lt;br /&gt;If value &amp;lt;&amp;gt; "" Then&lt;br /&gt;Dim cryptoProvider As DESCryptoServiceProvider = _&lt;br /&gt;New DESCryptoServiceProvider()&lt;/p&gt;&lt;p&gt;'convert from string to byte array&lt;br /&gt;Dim buffer As Byte() = Convert.FromBase64String(value)&lt;br /&gt;Dim ms As MemoryStream = New MemoryStream(buffer)&lt;br /&gt;Dim cs As CryptoStream = _&lt;br /&gt;New CryptoStream(ms, cryptoProvider.CreateDecryptor(KEY_64, IV_64), _&lt;br /&gt;CryptoStreamMode.Read)&lt;br /&gt;Dim sr As StreamReader = New StreamReader(cs)&lt;br /&gt;Return sr.ReadToEnd()&lt;br /&gt;End If&lt;br /&gt;End Function&lt;/p&gt;&lt;br /&gt;&lt;p&gt;'TRIPLE DES encryption&lt;br /&gt;Public Shared Function EncryptTripleDES(ByVal value As String) As String&lt;br /&gt;If value &amp;lt;&amp;gt; "" Then&lt;br /&gt;Dim cryptoProvider As TripleDESCryptoServiceProvider = _&lt;br /&gt;New TripleDESCryptoServiceProvider()&lt;br /&gt;Dim ms As MemoryStream = New MemoryStream()&lt;br /&gt;Dim cs As CryptoStream = _&lt;br /&gt;New CryptoStream(ms, cryptoProvider.CreateEncryptor(KEY_192, IV_192), _&lt;br /&gt;CryptoStreamMode.Write)&lt;br /&gt;Dim sw As StreamWriter = New StreamWriter(cs)&lt;br /&gt;sw.Write(value)&lt;br /&gt;sw.Flush()&lt;br /&gt;cs.FlushFinalBlock()&lt;br /&gt;ms.Flush()&lt;/p&gt;&lt;p&gt;'convert back to a string&lt;br /&gt;Return Convert.ToBase64String(ms.GetBuffer(), 0, ms.Length)&lt;br /&gt;End If&lt;br /&gt;End Function&lt;br /&gt;&lt;br /&gt;'TRIPLE DES decryption&lt;br /&gt;Public Shared Function DecryptTripleDES(ByVal value As String) As String&lt;br /&gt;If value &amp;lt;&amp;gt; "" Then&lt;br /&gt;Dim cryptoProvider As TripleDESCryptoServiceProvider = _&lt;br /&gt;New TripleDESCryptoServiceProvider()&lt;/p&gt;&lt;p&gt;'convert from string to byte array&lt;br /&gt;Dim buffer As Byte() = Convert.FromBase64String(value)&lt;br /&gt;Dim ms As MemoryStream = New MemoryStream(buffer)&lt;br /&gt;Dim cs As CryptoStream = _&lt;br /&gt;New CryptoStream(ms, cryptoProvider.CreateDecryptor(KEY_192, IV_192), _&lt;br /&gt;CryptoStreamMode.Read)&lt;br /&gt;Dim sr As StreamReader = New StreamReader(cs)&lt;/p&gt;&lt;p&gt;Return sr.ReadToEnd()&lt;br /&gt;End If&lt;br /&gt;End Function&lt;br /&gt;End Class&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/using-cryptography-to-encrypt-data-in.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-5214482245740536978</guid><pubDate>Mon, 13 Aug 2007 18:34:00 +0000</pubDate><atom:updated>2007-08-13T21:36:55.341+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">asp.net</category><category domain="http://www.blogger.com/atom/ns#">c#</category><title>Read Excel files from ASP.NET</title><description>source: aspfree , &lt;a href="http://www.aspfree.com/c/a/ASP.NET-Code/Read-Excel-files-from-ASPNET/"&gt;http://www.aspfree.com/c/a/ASP.NET-Code/Read-Excel-files-from-ASPNET/&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;%@ Page Language="C#" %&amp;gt;&lt;br /&gt;&amp;lt;%@ Import Namespace="System.Data.OleDb" %&amp;gt;&lt;br /&gt;&amp;lt;%@ Import Namespace="System.Data" %&amp;gt;&lt;br /&gt;&amp;lt;%@ Import Namespace="System" %&amp;gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;p&gt;&lt;/p&gt;&lt;p&gt;&amp;lt;script language="C#" runat="server"&amp;gt;&lt;br /&gt;protected void Page_Load(Object Src, EventArgs E)&lt;br /&gt;{&lt;br /&gt;string strConn;&lt;br /&gt;strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +&lt;br /&gt;"Data Source=C:\\exceltest.xls;" +&lt;br /&gt;"Extended Properties=Excel 8.0;";&lt;br /&gt;//You must use the $ after the object you reference in the spreadsheet&lt;br /&gt;OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]",strConn);&lt;/p&gt;&lt;p&gt;DataSet myDataSet = new DataSet();&lt;br /&gt;myCommand.Fill(myDataSet, "ExcelInfo");&lt;br /&gt;DataGrid1.DataSource = myDataSet.Tables["ExcelInfo"].DefaultView;&lt;br /&gt;DataGrid1.DataBind();&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;&amp;lt;/script&amp;gt;&lt;br /&gt;&amp;lt;html&amp;gt;&lt;br /&gt;&amp;lt;head&amp;gt;&amp;lt;/head&amp;gt;&lt;br /&gt;&amp;lt;body&amp;gt;&lt;br /&gt;&amp;lt;p&amp;gt;&amp;lt;asp:Label id=Label1 runat="server"&amp;gt;SpreadSheetContents:&amp;lt;/asp:Label&amp;gt;&amp;lt;/p&amp;gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;asp:DataGrid id=DataGrid1 runat="server"/&amp;gt;\&lt;br /&gt;&amp;lt;/body&amp;gt;&lt;br /&gt;&amp;lt;/html&amp;gt;&lt;br /&gt;&lt;br /&gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/read-excel-files-from-aspnet.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-7775698491581797579</guid><pubDate>Mon, 13 Aug 2007 18:31:00 +0000</pubDate><atom:updated>2007-08-13T21:33:56.449+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">asp.net</category><category domain="http://www.blogger.com/atom/ns#">vb.net</category><title>How to Search an XML File</title><description>source: &lt;a href="http://aspnet101.com/aspnet101/aspnet/codesample.aspx?code=xmlsearch"&gt;http://aspnet101.com/aspnet101/aspnet/codesample.aspx?code=xmlsearch&lt;/a&gt;&lt;br /&gt;&lt;p&gt;&amp;lt;%@ Import Namespace="System.Data" %&amp;gt;&lt;br /&gt;&amp;lt;script language="VB" Runat="server"&amp;gt;&lt;br /&gt;Sub Page_Load(Source as Object, E as EventArgs)&lt;br /&gt;if not Page.IsPostBack then&lt;br /&gt;Dim ds as DataSet = new DataSet()&lt;br /&gt;ds.ReadXml(Server.MapPath("/data/cars.xml"))&lt;br /&gt;ddlPrice.DataSource=ds&lt;br /&gt;ddlPrice.DataTextField="Price"&lt;br /&gt;ddlPrice.DataBind&lt;br /&gt;end if&lt;br /&gt;End Sub&lt;/p&gt;&lt;p&gt;Sub GetCar(Source as Object, E as EventArgs)&lt;br /&gt;Dim dsProducts as DataSet = new DataSet()&lt;br /&gt;dsProducts.ReadXml(Server.MapPath("/data/cars.xml"))&lt;br /&gt;Dim dv as DataView = new DataView(dsProducts.Tables("Products"))&lt;br /&gt;dv.Sort = "Price"&lt;br /&gt;&lt;br /&gt;Dim rowIndex as integer = dv.Find(ddlPrice.SelectedItem.Text)&lt;br /&gt;Dim Price, Vehicle as String&lt;br /&gt;if (rowIndex = -1) Then&lt;br /&gt;Response.Write("Car not found")&lt;br /&gt;else&lt;br /&gt;ph1.visible="True"&lt;br /&gt;Price = dv(rowIndex)("Price").ToString()&lt;br /&gt;lblPrice.text = "Price: " + FormatCurrency(Price) + "&amp;lt;br&amp;gt;"&lt;br /&gt;Vehicle = dv(rowIndex)("Vehicle").ToString()&lt;br /&gt;lblCar.text="Vehicle : " + Vehicle&lt;br /&gt;End If&lt;br /&gt;End Sub&lt;br /&gt;&amp;lt;/script&amp;gt;&lt;br /&gt;&amp;lt;html&amp;gt;&lt;br /&gt;&amp;lt;head&amp;gt;&lt;br /&gt;&amp;lt;meta name="GENERATOR" Content="ASP Express 3.1"&amp;gt;&lt;br /&gt;&amp;lt;title&amp;gt;Searching an XML File&amp;lt;/title&amp;gt;&lt;br /&gt;&amp;lt;/head&amp;gt;&lt;br /&gt;&amp;lt;body&amp;gt;&lt;br /&gt;&amp;lt;form id="form1" Runat="server"&amp;gt;&lt;br /&gt;&amp;lt;asp:DropDownList id="ddlPrice" Runat="server"/&amp;gt;&lt;br /&gt;&amp;lt;asp:Button id="button1"&lt;br /&gt;Text="Get Car"&lt;br /&gt;onclick="GetCar"&lt;br /&gt;Runat="server" /&amp;gt;&amp;lt;br&amp;gt;&lt;br /&gt;&amp;lt;asp:placeholder ID="ph1" Visible="False" Runat="server"&amp;gt;&lt;br /&gt;&amp;lt;asp:Label ID="lblCar" Runat="server" /&amp;gt; --&lt;br /&gt;&amp;lt;asp:Label ID="lblPrice" Runat="server" /&amp;gt;&amp;lt;br&amp;gt;&lt;br /&gt;&amp;lt;/asp:placeholder&amp;gt;&lt;br /&gt;&amp;lt;/form&amp;gt;&lt;br /&gt;&amp;lt;/body&amp;gt;&lt;br /&gt;&amp;lt;/html&amp;gt;&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/how-to-search-xml-file.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-1800647555860390236.post-4598970899411121653</guid><pubDate>Mon, 13 Aug 2007 18:25:00 +0000</pubDate><atom:updated>2007-08-13T21:30:12.397+03:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">sql</category><title>Deleting Duplicate Rows</title><description>--author: barkın ünüulu&lt;br /&gt;&lt;br /&gt;&lt;p&gt;--**************************************&lt;br /&gt;-- Name: Deleting Duplicate Rows&lt;br /&gt;-- Description:The Purpose of this code&lt;br /&gt;-- is to delete the duplicate values occuring in a table. This code is column-orien&lt;br /&gt;-- ted. That means the code works for the duplicate values occuring in a specified&lt;br /&gt;-- column and deletes the values of the rows corresponding to that column.&lt;br /&gt;-- By: barkın ünüulu&lt;br /&gt;--&lt;br /&gt;-- Inputs:I am going to specify the column name as COLUMNNAME and table name as&lt;br /&gt;-- TABLENAME. It should be noted that the developers that are willing to run this c&lt;br /&gt;--ode should put an "id" column in to their tables, which increments automatically&lt;br /&gt;-- Side Effects:As the row number increa&lt;br /&gt;-- ses, the time elapsed for the code increases...&lt;br /&gt;--&lt;br /&gt;--**************************************&lt;br /&gt;&lt;br /&gt;DECLARE @i int&lt;br /&gt;DECLARE @j int&lt;br /&gt;DECLARE @k int&lt;br /&gt;SET @k=(select count(*) FROM TABLENAME)&lt;br /&gt;SET @i=1&lt;br /&gt;WHILE @i&amp;lt;=@k&lt;br /&gt;BEGIN&lt;br /&gt;SET @j=@i+1&lt;br /&gt;WHILE @j&amp;lt;=@k&lt;br /&gt;BEGIN&lt;br /&gt;IF ((select COLUMNNAME FROM TABLENAME WHERE ID=@i)=&lt;br /&gt;(select COLUMNNAME FROM TABLENAME WHERE ID=@j))&lt;br /&gt;begin&lt;br /&gt;DELETE FROM TABLENAME&lt;br /&gt;WHERE ID=@j&lt;br /&gt;end&lt;br /&gt;SET @j=@j+1&lt;br /&gt;end&lt;br /&gt;SET @i=@i+1&lt;br /&gt;END&lt;/p&gt;&lt;div class="blogger-post-footer"&gt;&lt;script type="text/javascript"&gt;&lt;!--
google_ad_client = "pub-0818155412244020";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "336699";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--&gt;
&lt;/script&gt;
&lt;script type="text/javascript"
  src="http://pagead2.googlesyndication.com/pagead/show_ads.js"&gt;
&lt;/script&gt;&lt;/div&gt;</description><link>http://scriptmerkezi.blogspot.com/2007/08/deleting-duplicate-rows.html</link><author>noreply@blogger.com (script)</author><thr:total>0</thr:total></item></channel></rss>