<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  <link rel="alternate" type="application/rss+xml" title="© 2007 Göksel DARCAN" href="/?rss" />
<title>© 2007 Göksel DARCAN - Anasayfa</title>

  <link rel="stylesheet" type="text/css" href="style.asp" media="screen">
  
	</head>
	
	<body>
	
 <table align="center" border="0" cellspacing="0" cellpadding="0" style="width:730px;height:600px;">
 <tr><td>
 
	<table align="center" border="0" cellpadding="0" cellspacing="0" class="master">
 
	

   <tr>
    <td colspan="2" style="height:90px;" align="center" style="vertical-align:bottom;"><img id="img_0" src="themes/gothic/menu0_.gif"/><a href="posts.asp" onmouseover="document.getElementById('img_1').src='themes\/gothic\/menu1_.gif';" onmouseout="document.getElementById('img_1').src='themes\/gothic\/menu1.gif';"><img id="img_1" src="themes/gothic/menu1.gif"/></a><a href="photos.asp" onmouseover="document.getElementById('img_2').src='themes\/gothic\/menu2_.gif';" onmouseout="document.getElementById('img_2').src='themes\/gothic\/menu2.gif';"><img id="img_2" src="themes/gothic/menu2.gif"/></a><a href="visitors.asp" onmouseover="document.getElementById('img_3').src='themes\/gothic\/menu3_.gif';" onmouseout="document.getElementById('img_3').src='themes\/gothic\/menu3.gif';"><img id="img_3" src="themes/gothic/menu3.gif"/></a></td>
   </tr>
   <tr>
		<td colspan="2" style="height:30px;" align="right" style="vertical-align:bottom;padding-right:24px;padding-bottom:2px;">
    
			Yazılarda ara: <form name="searchform" style="display:inline" method="GET" action="posts.asp" onsubmit="return checksearch()"><input type="hidden" name="displayby" value="search"><input type="text" name="q" value="" style="background-image:url(themes/gothic/system-search.gif);background-position:middle left;background-repeat:no-repeat;padding-left:18px;"><input type="submit" value="ARA"></form>
			<script language="Javascript" type="text/javascript">
			function checksearch()
				{
				if(document.searchform.q.value.length < 3)
					{
					alert('Arama kriteri çok kısa !\n\nEn az 3 karakter uzunluğunda olmalıdır.');
					return false;
					}
				}
			</script>
		
    </td>
   </tr>
   <tr>
    <td style="width:200px;vertical-align:top;"><div style="height:480px;width:190px;overflow:auto;margin-left:10px;"><div class="divpost"><span class="heading1">Yazılarım :</span><br><a href="posts.asp?displayby=tags&tag=Genel" style="font-size:17px;">Genel</a> <a href="posts.asp?displayby=tags&tag=Motosiklet" style="font-size:11px;">Motosiklet</a> <a href="posts.asp?displayby=tags&tag=Komik" style="font-size:9px;">Komik</a> <a href="posts.asp?displayby=tags&tag=Security" style="font-size:10px;">Security</a> <a href="posts.asp?displayby=tags&tag=System" style="font-size:10px;">System</a> <a href="posts.asp?displayby=tags&tag=Windows" style="font-size:11px;">Windows</a> <a href="posts.asp?displayby=tags&tag=Siyasi" style="font-size:9px;">Siyasi</a> <a href="posts.asp?displayby=tags&tag=Tatar" style="font-size:9px;">Tatar</a> <a href="posts.asp?displayby=tags&tag=Yemek" style="font-size:9px;">Yemek</a> <a href="posts.asp?displayby=tags&tag=Mutfak" style="font-size:9px;">Mutfak</a> <a href="posts.asp?displayby=tags&tag=HTML" style="font-size:11px;">HTML</a> <a href="posts.asp?displayby=tags&tag=Javascript" style="font-size:11px;">Javascript</a> <a href="posts.asp?displayby=tags&tag=Müzik" style="font-size:11px;">Müzik</a> <a href="posts.asp?displayby=tags&tag=CSS" style="font-size:9px;">CSS</a> <a href="posts.asp?displayby=tags&tag=ASP" style="font-size:15px;">ASP</a> <a href="posts.asp?displayby=tags&tag=Yaşam" style="font-size:12px;">Yaşam</a> <a href="posts.asp?displayby=tags&tag=Sağlık" style="font-size:10px;">Sağlık</a> <a href="posts.asp?displayby=tags&tag=SQL" style="font-size:9px;">SQL</a> <a href="posts.asp?displayby=tags&tag=VBScript" style="font-size:9px;">VBScript</a> </div><div class="divpost"><span class="heading1">Arkadaşlarım :</span><br>
<a href="redirect.asp?url=http%3A%2F%2Fwww%2Emesutguner%2Einfo" target="_blank">Mesut</a><br/>
<a href="redirect.asp?url=http%3A%2F%2Fwww%2Esirtmac%2Ecom" target="_blank">Sırtmaç</a><br/>
<a href="redirect.asp?url=http%3A%2F%2Fwww%2Esukla%2Ecom" target="_blank">Saint</a><br/>
<a href="redirect.asp?url=http%3A%2F%2Fwww%2Eorpheus1313%2Einfo" target="_blank">Dilek</a><br/>
</div><div class="divpost"><span class="heading1">Linklerim :</span><br>
<a href="redirect.asp?url=http%3A%2F%2Fwww%2Eblogkardesligi%2Ecom" target="_blank">Blog Kardeşliği</a><br/>
<a href="redirect.asp?url=http%3A%2F%2Fwww%2Eblogspot%2Ecom" target="_blank">Blogspot</a><br/>
<a href="redirect.asp?url=http%3A%2F%2Fwww%2Eblogger%2Ecom" target="_blank">blogger.com</a><br/>
<a href="redirect.asp?url=http%3A%2F%2Fwww%2Eblogcu%2Ecom" target="_blank">blogcu.com</a><br/>
<a href="redirect.asp?url=http%3A%2F%2Fwww%2Epardus%2Eorg%2Etr" target="_blank">Pardus... Özgürlük İçin</a><br/>
<a href="redirect.asp?url=http%3A%2F%2Fwww%2Egoogle%2Ecom%2Etr" target="_blank">Google.TR</a><br/>
</div><div class="divpost">
    Online: 2 ziyaretçi<br>
    51684 kere ziyaret edildi
</div>
    </div></td>
    <td><div style="height:480px;width:590px;overflow:auto;padding-left:10px;" id="postsdiv">
<div id="masterdiv_32" class="divpost" style="height:75px;"><table border="0" cellspacing="0" cellpadding="0" style="width:539px;layout:fixed;"><tr><td><span class="posttitle">ASP, VBScript Random Password Generator</span><br>
<span class="tags">Etiketler : </span><span class="tagsdisp">ASP,VBScript</span><br>
</td><td align="right" style="vertical-align:bottom;"><a onclick="if(document.getElementById('smdiv_32').style.display=='none'){document.getElementById('smdiv_32').style.display=''}else{document.getElementById('smdiv_32').style.display='none'}" target="xframe" title="E-posta olarak gönder"><img src="themes/gothic/forward.gif" alt="E-posta olarak gönder"></a><a id="adevam_32" onclick="togglepost(32,1)" title="Yazının devamı"><img id="imgdevam_32" src="themes/gothic/plus.gif" alt="Yazının devamı"></a></td></tr></table>
<table border="0" cellspacing="0" cellpadding="0" style="width:539px;layout:fixed;"><tr><td><span class="tags"><b><i>Eklenme tarihi : 12.01.2010 19:33:42</i></b></span><br>
<span class="tags"><b><i>Güncellenme tarihi : 12.01.2010 19:36:48</i></b></span></td>
<td style="vertical-align:top;text-align:right;"><div id="smdiv_32" style="display:none;"><form style="display:inline;" id="frmsm_32" method="POST" target="xframe" action="sendbymail.asp" onsubmit="return checkfrmsm(32);">
<input type="hidden" name="post_id" value="32"><input type="text" name="mailto" value=""><input type="submit" value="GÖNDER">
</form>
</div>
</td></tr></table><br>
<pre style="font-family:'Lucida Console';font-size:9px;line-height:13px;font-weight:bold;color:#DDDDDD;">
<%
arr_l = Array(_
	"A","B","C","D","E","F","G","H",_
	"J","K","L","M","N","P","Q","R",_
	"S","T","U","V","W","X","Y","Z",_
	"a","b","c","d","e","f","g","h",_
	"i","j","k","m","n","p","q","r",_
	"s","t","u","v","w","x","y","z"_
)
arr_n = Array(_
	"2","3","4","5","6","7","8","9"_
)

Function letters(n)
	output = ""
	For i = 1 To n
		Randomize Timer
		k = arr_l(Int((UBound(arr_l)-LBound(arr_l)+1) * Rnd + (LBound(arr_l))))
		output = output & k
	Next
	letters = output
End Function

Function numbers(n)
	output = ""
	For i = 1 To n
		Randomize Timer
		k = arr_n(Int((UBound(arr_n)-LBound(arr_n)+1) * Rnd + (LBound(arr_n))))
		output = output & k
	Next
	numbers = output
End Function

Response.Write letters(4) & numbers(3)
%>
</pre><br>
<br>
<span class="tags"><b><i><span id="vcnt">3</span> kere görüntülendi...</i></b></span><br>
<a href="javascript:togglecomment('cm_32')">Yorum Ekle</a><br><div id="cm_32" style="display:none;width:570px;"><form target="xframe" id="frm_32" style="display:inline" method="POST" action="savecomment.asp" onsubmit="return checkform1('frm_32')">
<hr>
<span class="tags">Yorum Ekle</span><br>
<input type="hidden" name="post_id" value="32">
<table border="0" cellpadding="3" cellspacing="0" style="width:348px;table-layout:fixed;">
<tr><td align="right" style="width:84px;">Görünen Ad *: </td><td><input type="text" name="commenter_nick"></td></tr>
<tr><td align="right">E-Posta : </td><td><input type="text" name="commenter_email"></td></tr>
<tr><td align="right">Yorum *: </td><td><textarea name="comment_data" style="width:250px;height:150px;"></textarea></td></tr>
<tr><td></td><td><input type="submit" value="EKLE"></td></tr>
<tr><td colspan="2" style="background:#FF8;color:#000;font-size:10px;line-height:12px;font-weight:bold;text-align:justify;width:348px;padding:5px;">Not: E-posta adresiniz sadece yazdığınız mesajla ilgili durumlarda size ulaşabilmek amacıyla yönetici tarafından kullanılmak üzere istenmektedir. Sitenin veya internet'in hiçbir yerinde yayınlanmayacaktır. E-posta adresinizi yazma zorunluluğunuz yoktur.</td></tr>
</table>
</form>
</div>
</div>
<div id="masterdiv_29" class="divpost" style="height:75px;"><table border="0" cellspacing="0" cellpadding="0" style="width:539px;layout:fixed;"><tr><td><span class="posttitle">Hayattan Ne Öğrendim?</span><br>
<span class="tags">Etiketler : </span><span class="tagsdisp">Genel,Yaşam</span><br>
</td><td align="right" style="vertical-align:bottom;"><a onclick="document.getElementById('postsdiv').scrollTop=0;" title="Sayfa başına git"><img src="themes/gothic/go-top.gif" alt="Sayfa başına git"></a><a onclick="if(document.getElementById('smdiv_29').style.display=='none'){document.getElementById('smdiv_29').style.display=''}else{document.getElementById('smdiv_29').style.display='none'}" target="xframe" title="E-posta olarak gönder"><img src="themes/gothic/forward.gif" alt="E-posta olarak gönder"></a><a id="adevam_29" onclick="togglepost(29,2)" title="Yazının devamı"><img id="imgdevam_29" src="themes/gothic/plus.gif" alt="Yazının devamı"></a></td></tr></table>
<table border="0" cellspacing="0" cellpadding="0" style="width:539px;layout:fixed;"><tr><td><span class="tags"><b><i>Eklenme tarihi : 31.12.2009 11:36:44</i></b></span><br>
<span class="tags"><b><i>Güncellenme tarihi : 31.12.2009 11:37:42</i></b></span></td>
<td style="vertical-align:top;text-align:right;"><div id="smdiv_29" style="display:none;"><form style="display:inline;" id="frmsm_29" method="POST" target="xframe" action="sendbymail.asp" onsubmit="return checkfrmsm(29);">
<input type="hidden" name="post_id" value="29"><input type="text" name="mailto" value=""><input type="submit" value="GÖNDER">
</form>
</div>
</td></tr></table><br>
<font face="trebuchet ms,geneva"><em>Hz. Mevlana&rsquo;dan</em></font><font face="trebuchet ms,geneva"> <br />
<br />
Sonsuz bir karanlığın i&ccedil;inden doğdum. Işığı g&ouml;rd&uuml;m, korktum. Ağladım.<br />
Zamanla ışıkta yaşamayı &ouml;ğrendim.<br />
Karanlığı g&ouml;rd&uuml;m, korktum.<br />
G&uuml;n geldi sonsuz karanlığa uğurladım sevdiklerimi...<br />
Ağladım.<br />
<br />
Yaşamayı &ouml;ğrendim.<br />
Doğumun, hayatın bitmeye başladığı an olduğunu;<br />
Aradaki b&ouml;l&uuml;m&uuml;n, &ouml;l&uuml;mden &ccedil;alınan zamanlar olduğunu &ouml;ğrendim.<br />
<br />
Zamanı &ouml;ğrendim.<br />
Yarıştım onunla...<br />
Zamanla yarışılmayacağını, zamanla barışılacağını, zamanla &ouml;ğrendim...<br />
<br />
İnsanı &ouml;ğrendim.<br />
Sonra insanların i&ccedil;inde iyiler ve k&ouml;t&uuml;ler olduğunu...<br />
Sonra da her insanın i&ccedil;inde iyilik ve k&ouml;t&uuml;l&uuml;k bulunduğunu &ouml;ğrendim.<br />
<br />
Sevmeyi &ouml;ğrendim.<br />
Sonra g&uuml;venmeyi...<br />
Sonra da g&uuml;venin sevgiden daha kalıcı olduğunu,<br />
Sevginin g&uuml;venin sağlam zemini &uuml;zerine kurulduğunu &ouml;ğrendim.<br />
<br />
İnsan tenini &ouml;ğrendim.<br />
Sonra tenin altında bir ruh bulunduğunu...<br />
Sonra da ruhun aslında tenin &uuml;st&uuml;nde olduğunu &ouml;ğrendim.<br />
<br />
Evreni &ouml;ğrendim.<br />
Sonra evreni aydınlatmanın yollarını &ouml;ğrendim.<br />
Sonunda evreni aydınlatabilmek i&ccedil;in &ouml;nce &ccedil;evreni aydınlatabilmek gerektiğini &ouml;ğrendim.<br />
<br />
Ekmeği &ouml;ğrendim.<br />
Sonra barış i&ccedil;in ekmeğin bolca &uuml;retilmesi gerektiğini...<br />
Sonra da ekmeği hak&ccedil;a &uuml;leşmenin,&nbsp;<br />
Bolca &uuml;retmek kadar &ouml;nemli olduğunu &ouml;ğrendim.<br />
<br />
Okumayı &ouml;ğrendim.<br />
Kendime yazıyı &ouml;ğrettim sonra...<br />
Ve bir s&uuml;re sonra yazı, kendimi &ouml;ğretti bana...<br />
<br />
Gitmeyi &ouml;ğrendim.<br />
Sonra dayanamayıp d&ouml;nmeyi...<br />
Daha da sonra kendime rağmen gitmeyi...<br />
<br />
D&uuml;nyaya tek başına meydan okumayı &ouml;ğrendim gen&ccedil; yaşta...<br />
Sonra kalabalıklarla birlikte y&uuml;r&uuml;mek gerektiği fikrine vardım.<br />
Sonra da asıl y&uuml;r&uuml;y&uuml;ş&uuml;n kalabalıklara karşı olması gerektiğine aydım.<br />
<br />
D&uuml;ş&uuml;nmeyi &ouml;ğrendim.<br />
Sonra kalıplar i&ccedil;inde d&uuml;ş&uuml;nmeyi &ouml;ğrendim.<br />
Sonra saglıklı d&uuml;ş&uuml;nmenin kalıpları yıkarak d&uuml;ş&uuml;nmek olduğunu &ouml;ğrendim.<br />
<br />
Namusun &ouml;nemini &ouml;ğrendim evde...<br />
Sonra yoksundan namus beklemenin namussuzluk olduğunu;<br />
ger&ccedil;ek namusun, g&uuml;nah elinin altındayken, g&uuml;naha el s&uuml;rmemek olduğunu &ouml;ğrendim.<br />
<br />
Ger&ccedil;eği &ouml;ğrendim bir g&uuml;n...<br />
Ve ger&ccedil;eğin acı olduğunu...<br />
Sonra dozunda acının,<br />
Yemeğe oldugu kadar hayata da lezzet kattığını &ouml;ğrendim.<br />
<br />
Her canlının &ouml;l&uuml;m&uuml; tadacağını,<br />
ama sadece bazılarının hayatı tadacağını &ouml;ğrendim.<br />
<br />
Dostlarım,<br />
<br />
Ben dostlarımı ne kalbimle ne de aklımla severim.<br />
Olur ya...<br />
Kalp durur...<br />
Akıl unutur...<br />
Ben dostlarımı ruhumla severim.<br />
O ne durur, ne de unutur...<br />
<br />
Hz. Mevlana</font>
<br>
<br>
<span class="tags"><b><i><span id="vcnt">7</span> kere görüntülendi...</i></b></span><br>
<a href="javascript:togglecomment('cm_29')">Yorum Ekle</a><br><div id="cm_29" style="display:none;width:570px;"><form target="xframe" id="frm_29" style="display:inline" method="POST" action="savecomment.asp" onsubmit="return checkform1('frm_29')">
<hr>
<span class="tags">Yorum Ekle</span><br>
<input type="hidden" name="post_id" value="29">
<table border="0" cellpadding="3" cellspacing="0" style="width:348px;table-layout:fixed;">
<tr><td align="right" style="width:84px;">Görünen Ad *: </td><td><input type="text" name="commenter_nick"></td></tr>
<tr><td align="right">E-Posta : </td><td><input type="text" name="commenter_email"></td></tr>
<tr><td align="right">Yorum *: </td><td><textarea name="comment_data" style="width:250px;height:150px;"></textarea></td></tr>
<tr><td></td><td><input type="submit" value="EKLE"></td></tr>
<tr><td colspan="2" style="background:#FF8;color:#000;font-size:10px;line-height:12px;font-weight:bold;text-align:justify;width:348px;padding:5px;">Not: E-posta adresiniz sadece yazdığınız mesajla ilgili durumlarda size ulaşabilmek amacıyla yönetici tarafından kullanılmak üzere istenmektedir. Sitenin veya internet'in hiçbir yerinde yayınlanmayacaktır. E-posta adresinizi yazma zorunluluğunuz yoktur.</td></tr>
</table>
</form>
</div>
</div>
<div id="masterdiv_28" class="divpost" style="height:75px;"><table border="0" cellspacing="0" cellpadding="0" style="width:539px;layout:fixed;"><tr><td><span class="posttitle">Recursive Product Count or Recursive Product Search</span><br>
<span class="tags">Etiketler : </span><span class="tagsdisp">ASP,SQL</span><br>
</td><td align="right" style="vertical-align:bottom;"><a onclick="document.getElementById('postsdiv').scrollTop=0;" title="Sayfa başına git"><img src="themes/gothic/go-top.gif" alt="Sayfa başına git"></a><a onclick="if(document.getElementById('smdiv_28').style.display=='none'){document.getElementById('smdiv_28').style.display=''}else{document.getElementById('smdiv_28').style.display='none'}" target="xframe" title="E-posta olarak gönder"><img src="themes/gothic/forward.gif" alt="E-posta olarak gönder"></a><a id="adevam_28" onclick="togglepost(28,3)" title="Yazının devamı"><img id="imgdevam_28" src="themes/gothic/plus.gif" alt="Yazının devamı"></a></td></tr></table>
<table border="0" cellspacing="0" cellpadding="0" style="width:539px;layout:fixed;"><tr><td><span class="tags"><b><i>Eklenme tarihi : 12.10.2008 13:20:49</i></b></span><br>
<span class="tags"><b><i>Güncellenme tarihi : 12.10.2008 13:32:53</i></b></span></td>
<td style="vertical-align:top;text-align:right;"><div id="smdiv_28" style="display:none;"><form style="display:inline;" id="frmsm_28" method="POST" target="xframe" action="sendbymail.asp" onsubmit="return checkfrmsm(28);">
<input type="hidden" name="post_id" value="28"><input type="text" name="mailto" value=""><input type="submit" value="GÖNDER">
</form>
</div>
</td></tr></table><br>
<p>
<font face="tahoma,arial,helvetica,sans-serif">You want a recursive product search or display product count under a category tree.</font><a style="display: none" href="#">This article contains information about postgresql, pgsql, postgres, MS Access</a>
</p>
<p>
<font face="tahoma,arial,helvetica,sans-serif">Let's suppose that you have <em>categories</em> table like below;</font>
</p>
<table border="1" cellspacing="2" cellpadding="2">
	<tbody>
		<tr>
			<td>cat_id [serial NOT NULL]</td>
			<td>parent_id [numeric]</td>
			<td>category_name [character varying]</td>
		</tr>
		<tr>
			<td>1</td>
			<td>0</td>
			<td>Electrical &amp; Electronical</td>
		</tr>
		<tr>
			<td>2</td>
			<td>1</td>
			<td>Capacitor</td>
		</tr>
		<tr>
			<td>3</td>
			<td>1</td>
			<td>Inductor</td>
		</tr>
		<tr>
			<td>4</td>
			<td>0</td>
			<td>Tools &amp; Hardware</td>
		</tr>
		<tr>
			<td>5</td>
			<td>4</td>
			<td>Hand Tools</td>
		</tr>
		<tr>
			<td>6</td>
			<td>4</td>
			<td>Pneumatic Tools</td>
		</tr>
	</tbody>
</table>
<p>
<font face="tahoma,arial,helvetica,sans-serif">...and let's suppose that you have a products table like below;</font>
</p>
<table border="1" cellspacing="2" cellpadding="2">
	<tbody>
		<tr>
			<td>product_id [numeric]</td>
			<td>cat_id [numeric]</td>
			<td>product_name [character varying]</td>
		</tr>
		<tr>
			<td>1&nbsp;</td>
			<td>2</td>
			<td>Capacitor 1</td>
		</tr>
		<tr>
			<td>2</td>
			<td>2</td>
			<td>Capacitor 2</td>
		</tr>
		<tr>
			<td>3</td>
			<td>3</td>
			<td>Inductor 1</td>
		</tr>
		<tr>
			<td>4</td>
			<td>3</td>
			<td>Inductor 2</td>
		</tr>
		<tr>
			<td>5</td>
			<td>5</td>
			<td> Hand Tool1</td>
		</tr>
		<tr>
			<td>6</td>
			<td>5</td>
			<td> Hand Tool2</td>
		</tr>
		<tr>
			<td>7</td>
			<td>6</td>
			<td>Pneumatic Tool 1</td>
		</tr>
		<tr>
			<td>8</td>
			<td>6</td>
			<td>Pneumatic Tool 2</td>
		</tr>
	</tbody>
</table>
<p>
<font face="tahoma,arial,helvetica,sans-serif">You just only have to do is adding a new column cat_path [character varying] at each table and write a script to find the category paths and put them on the new column with a delimiter character (I used &quot;.&quot;)</font>
</p>
<table border="1" cellspacing="2" cellpadding="2">
	<tbody>
		<tr>
			<td>cat_id [serial NOT NULL]</td>
			<td>parent_id [numeric]</td>
			<td>category_name [character varying]</td>
			<td>cat_path</td>
		</tr>
		<tr>
			<td>1</td>
			<td>0</td>
			<td>Electrical &amp; Electronical</td>
			<td>.0.1.</td>
		</tr>
		<tr>
			<td>2</td>
			<td>1</td>
			<td>Capacitor</td>
			<td>.0.1.2.</td>
		</tr>
		<tr>
			<td>3</td>
			<td>1</td>
			<td>Inductor</td>
			<td>.0.1.3.</td>
		</tr>
		<tr>
			<td>4</td>
			<td>0</td>
			<td>Tools &amp; Hardware</td>
			<td>.0.4.</td>
		</tr>
		<tr>
			<td>5</td>
			<td>4</td>
			<td>Hand Tools</td>
			<td>.0.4.5.</td>
		</tr>
		<tr>
			<td>6</td>
			<td>4</td>
			<td>Pneumatic Tools</td>
			<td>.0.4.6.</td>
		</tr>
	</tbody>
</table>
<p>
<table border="1" cellspacing="2" cellpadding="2">
	<tbody>
		<tr>
			<td>product_id [numeric]</td>
			<td>cat_id [numeric]</td>
			<td>product_name [character varying]</td>
			<td>cat_path</td>
		</tr>
		<tr>
			<td>1&nbsp;</td>
			<td>2</td>
			<td>Capacitor 1</td>
			<td>.0.1.2.</td>
		</tr>
		<tr>
			<td>2</td>
			<td>2</td>
			<td>Capacitor 2</td>
			<td>.0.1.2.</td>
		</tr>
		<tr>
			<td>3</td>
			<td>3</td>
			<td>Inductor 1</td>
			<td>.0.1.3.</td>
		</tr>
		<tr>
			<td>4</td>
			<td>3</td>
			<td>Inductor 2</td>
			<td>.0.1.3.</td>
		</tr>
		<tr>
			<td>5</td>
			<td>5</td>
			<td> Hand Tool1</td>
			<td>.0.4.5.</td>
		</tr>
		<tr>
			<td>6</td>
			<td>5</td>
			<td> Hand Tool2</td>
			<td>.0.4.5.</td>
		</tr>
		<tr>
			<td>7</td>
			<td>6</td>
			<td>Pneumatic Tool 1</td>
			<td>.0.4.6.</td>
		</tr>
		<tr>
			<td>8</td>
			<td>6</td>
			<td>Pneumatic Tool 2</td>
			<td>.0.4.6.</td>
		</tr>
	</tbody>
</table>
</p>
<p>
<font face="tahoma,arial,helvetica,sans-serif">SQL (MS Access&trade;) query for product count under &quot;capacitor&quot; category:</font><font face="tahoma,arial,helvetica,sans-serif"><br />
</font><font face="tahoma,arial,helvetica,sans-serif">
</font><em><font color="#ff6600"><font face="arial,helvetica,sans-serif"><font size="2">SELECT * FROM products WHERE cat_path ~~ '%.2.%'&quot;,cnn,1,3</font></font></font></em><font face="tahoma,arial,helvetica,sans-serif"><br />
</font><font face="tahoma,arial,helvetica,sans-serif">
count = objRs.RecordCount
</font>
</p>
<font face="tahoma,arial,helvetica,sans-serif">
</font>
<p>
<font face="tahoma,arial,helvetica,sans-serif">
</font><font face="tahoma,arial,helvetica,sans-serif">SQL (POSTGRESQL) query for product count under &quot;capacitor&quot; category:</font><font face="tahoma,arial,helvetica,sans-serif"><br />
</font><font face="tahoma,arial,helvetica,sans-serif">
</font><em><font color="#ff6600"><font face="arial,helvetica,sans-serif"><font size="2">SELECT count(*) FROM products WHERE cat_path ~~ '%.2.%'&quot;,cnn,1,3</font></font></font></em><font face="tahoma,arial,helvetica,sans-serif"><br />
</font><font face="tahoma,arial,helvetica,sans-serif">
count = objRs(&quot;count&quot;)</font>
</p>
<p>
<font face="tahoma,arial,helvetica,sans-serif">SQL (POSTGRESQL) query for product search under &quot;capacitor&quot; category:</font><font face="tahoma,arial,helvetica,sans-serif"><br />
</font><font face="tahoma,arial,helvetica,sans-serif">
</font><em><font color="#ff6600"><font size="2"><font face="arial,helvetica,sans-serif">SELECT count(*) FROM products WHERE product_name ~~ ''%blah blah%' AND cat_path ~~ '%.2.%'&quot;,cnn,1,3</font></font></font></em><font face="tahoma,arial,helvetica,sans-serif"><br />
</font><font face="tahoma,arial,helvetica,sans-serif">
count = objRs(&quot;count&quot;)</font>
</p>
<p>
<font face="tahoma,arial,helvetica,sans-serif">Sample cat_path script written in vbscript (may load CPU to 100%):</font>
</p>
<textarea style="width:400px;height:300px">Set cnn = CreateObject(&quot;ADODB.Connection&quot;)
cnn.Open &quot;dsn=ODBC_DSN_NAME&quot;
Set rs = CreateObject(&quot;ADODB.Recordset&quot;)

Call catpath(0,&quot;.0.&quot;)

Set rs = Nothing
cnn.Close
Set cnn = Nothing

Wscript.Echo &quot;Finished !&quot;

Function catpath(cid,cpth)
	cids = Array()
	cpth = cpth
	rs.Open &quot;SELECT cat_id FROM categories WHERE parent_id=&quot; &amp; cid,cnn,1,3
	Do Until rs.EOF
		s = cpth &amp; rs(&quot;cat_id&quot;) &amp; &quot;.&quot;
		cid = rs(&quot;cat_id&quot;)
		Set rs2 = CreateObject(&quot;ADODB.Recordset&quot;)
		rs2.Open &quot;UPDATE products SET cat_path='&quot; &amp; s &amp; &quot;' WHERE cat_id=&quot; &amp; cid,cnn,1,3
		rs2.Open &quot;UPDATE categories SET cat_path='&quot; &amp; s &amp; &quot;' WHERE cat_id=&quot; &amp; cid,cnn,1,3
		Set rs2 = Nothing
		Redim Preserve cids(UBound(cids)+1)
		cids(UBound(cids)) = Array(cid,s)
		rs.MoveNext
	Loop
	rs.Close	
	For i = LBound(cids) To UBound(cids)
		Call catpath(cids(i)(0),cids(i)(1))
	Next
End Function</textarea><br>
<br>
<span class="tags"><b><i><span id="vcnt">20</span> kere görüntülendi...</i></b></span><br>
<a href="javascript:togglecomment('cm_28')">Yorum Ekle</a><br><div id="cm_28" style="display:none;width:570px;"><form target="xframe" id="frm_28" style="display:inline" method="POST" action="savecomment.asp" onsubmit="return checkform1('frm_28')">
<hr>
<span class="tags">Yorum Ekle</span><br>
<input type="hidden" name="post_id" value="28">
<table border="0" cellpadding="3" cellspacing="0" style="width:348px;table-layout:fixed;">
<tr><td align="right" style="width:84px;">Görünen Ad *: </td><td><input type="text" name="commenter_nick"></td></tr>
<tr><td align="right">E-Posta : </td><td><input type="text" name="commenter_email"></td></tr>
<tr><td align="right">Yorum *: </td><td><textarea name="comment_data" style="width:250px;height:150px;"></textarea></td></tr>
<tr><td></td><td><input type="submit" value="EKLE"></td></tr>
<tr><td colspan="2" style="background:#FF8;color:#000;font-size:10px;line-height:12px;font-weight:bold;text-align:justify;width:348px;padding:5px;">Not: E-posta adresiniz sadece yazdığınız mesajla ilgili durumlarda size ulaşabilmek amacıyla yönetici tarafından kullanılmak üzere istenmektedir. Sitenin veya internet'in hiçbir yerinde yayınlanmayacaktır. E-posta adresinizi yazma zorunluluğunuz yoktur.</td></tr>
</table>
</form>
</div>
</div>
<div id="masterdiv_27" class="divpost" style="height:75px;"><table border="0" cellspacing="0" cellpadding="0" style="width:539px;layout:fixed;"><tr><td><span class="posttitle">&quot;Open With&quot; dialog box when double click drive | Sürücüyü çift tıklayınca &quot;Birlikte Aç&quot; penceresi</span><br>
<span class="tags">Etiketler : </span><span class="tagsdisp">Windows,Security,System</span><br>
</td><td align="right" style="vertical-align:bottom;"><a onclick="document.getElementById('postsdiv').scrollTop=0;" title="Sayfa başına git"><img src="themes/gothic/go-top.gif" alt="Sayfa başına git"></a><a onclick="if(document.getElementById('smdiv_27').style.display=='none'){document.getElementById('smdiv_27').style.display=''}else{document.getElementById('smdiv_27').style.display='none'}" target="xframe" title="E-posta olarak gönder"><img src="themes/gothic/forward.gif" alt="E-posta olarak gönder"></a><a id="adevam_27" onclick="togglepost(27,4)" title="Yazının devamı"><img id="imgdevam_27" src="themes/gothic/plus.gif" alt="Yazının devamı"></a></td></tr></table>
<table border="0" cellspacing="0" cellpadding="0" style="width:539px;layout:fixed;"><tr><td><span class="tags"><b><i>Eklenme tarihi : 18.08.2008 15:40:56</i></b></span><br>
<span class="tags"><b><i>Güncellenme tarihi : 18.08.2008 15:50:46</i></b></span></td>
<td style="vertical-align:top;text-align:right;"><div id="smdiv_27" style="display:none;"><form style="display:inline;" id="frmsm_27" method="POST" target="xframe" action="sendbymail.asp" onsubmit="return checkfrmsm(27);">
<input type="hidden" name="post_id" value="27"><input type="text" name="mailto" value=""><input type="submit" value="GÖNDER">
</form>
</div>
</td></tr></table><br>
<p>
Solution (English):
</p>
<ul>
	<li>Hit WIN+E (a key with windows sign+E) form keyboard or click Start &gt; (All) Programs &gt; Accessories &gt;Windows Explorer</li>
	<li>Click &quot;Tools&quot; then &quot;Folder Options&quot;</li>
	<li>Select &quot;Show hidden files and folders</li>
	<li>Uncheck &quot;Hide protected operating system files&quot;</li>
	<li>Click &quot;OK&quot; to close the window</li>
	<li>Navigate to the problematic drive from left tree</li>
	<li>Find and SHIFT+DELETE autorun.inf file (which target is deleted by antivirus software)</li>
	<li>Restart windows or hit CTRL+ALT+DELETE to open Task Manager, right click explorer.exe from &quot;Processes&quot; tab and click &quot;End Process Tree&quot; (Note that this will shut down everything under the process tree, including IE windows)</li>
	<li>click &quot;New Task&quot; button at the &quot;Applications&quot; tab and write &quot;explorer.exe&quot; then hit ENTER</li>
</ul>
<hr />
<p>
&Ccedil;&ouml;z&uuml;m (T&uuml;rk&ccedil;e):
</p>
<ul>
	<li>Klavyeden WIN+E (pencereli tuş+E) tuşuna basın yada Başlat &gt; (T&uuml;m) Programlar &gt; Donatılar &gt; Windows Explorer tıklayın</li>
	<li>Men&uuml;den &quot;Ara&ccedil;lar&quot; tıklayın sonra &quot;Klas&ouml;r Se&ccedil;enekleri&quot; tıklayın</li>
	<li>&quot;Gizli dosya ve klas&ouml;rleri g&ouml;ster&quot; se&ccedil;in</li>
	<li>&quot;Korunan işletim sistemi dosyalarını gize&quot; se&ccedil;eneğinin işaretini kaldırın</li>
	<li>&quot;Tamam&quot; tıklayarak pencereyi kapatın</li>
	<li>Soldaki klas&ouml;r ağacından sorunlu s&uuml;r&uuml;c&uuml;y&uuml; tıklayın</li>
	<li>(hedefindeki dosya antivir&uuml;s tarafından silinen) autorun.inf &nbsp;dosyasını bulun ve SHIFT+DEL ile silin</li>
	<li>Windows'u yeniden başlatın yada CTRL+ALT+DELETE ile &quot;G&ouml;rev Y&ouml;neticisi&quot;ni başlatın, &quot;İşlemler&quot; sekmesinde &quot;explorer.exe&quot; g&ouml;revini sağ tıklayıp &quot;İşlem ağacını sonlandır&quot; se&ccedil;in (Dikkat ediniz ki bu işlem IE pencereleri dahil t&uuml;m bağlı g&ouml;revleri sonlandıracaktır)</li>
	<li>&quot;Uygulamalar&quot; sekmesinde &quot;Yeni G&ouml;rev&quot; d&uuml;ğmesini tıklayın ve explorer.exe yazıp ENTER'a basın</li>
</ul>
<br>
<br>
<span class="tags"><b><i><span id="vcnt">42</span> kere görüntülendi...</i></b></span><br>
<a href="javascript:togglecomment('cm_27')">Yorumlar [1] | Yorum Ekle</a><br><div id="cm_27" style="display:none;width:570px;"><div id="comment_111" style=""><hr>
<span class="tags">hi all :) 










</span><br><span class="tagsdisp">hi all :) 










</span><br><span class="tagsdisp">21.09.2008 21:43:56</span></div><form target="xframe" id="frm_27" style="display:inline" method="POST" action="savecomment.asp" onsubmit="return checkform1('frm_27')">
<hr>
<span class="tags">Yorum Ekle</span><br>
<input type="hidden" name="post_id" value="27">
<table border="0" cellpadding="3" cellspacing="0" style="width:348px;table-layout:fixed;">
<tr><td align="right" style="width:84px;">Görünen Ad *: </td><td><input type="text" name="commenter_nick"></td></tr>
<tr><td align="right">E-Posta : </td><td><input type="text" name="commenter_email"></td></tr>
<tr><td align="right">Yorum *: </td><td><textarea name="comment_data" style="width:250px;height:150px;"></textarea></td></tr>
<tr><td></td><td><input type="submit" value="EKLE"></td></tr>
<tr><td colspan="2" style="background:#FF8;color:#000;font-size:10px;line-height:12px;font-weight:bold;text-align:justify;width:348px;padding:5px;">Not: E-posta adresiniz sadece yazdığınız mesajla ilgili durumlarda size ulaşabilmek amacıyla yönetici tarafından kullanılmak üzere istenmektedir. Sitenin veya internet'in hiçbir yerinde yayınlanmayacaktır. E-posta adresinizi yazma zorunluluğunuz yoktur.</td></tr>
</table>
</form>
</div>
</div>
<div id="masterdiv_25" class="divpost" style="height:75px;"><table border="0" cellspacing="0" cellpadding="0" style="width:539px;layout:fixed;"><tr><td><span class="posttitle">Javascript referer</span><br>
<span class="tags">Etiketler : </span><span class="tagsdisp">HTML,Javascript,ASP</span><br>
</td><td align="right" style="vertical-align:bottom;"><a onclick="document.getElementById('postsdiv').scrollTop=0;" title="Sayfa başına git"><img src="themes/gothic/go-top.gif" alt="Sayfa başına git"></a><a onclick="if(document.getElementById('smdiv_25').style.display=='none'){document.getElementById('smdiv_25').style.display=''}else{document.getElementById('smdiv_25').style.display='none'}" target="xframe" title="E-posta olarak gönder"><img src="themes/gothic/forward.gif" alt="E-posta olarak gönder"></a><a id="adevam_25" onclick="togglepost(25,5)" title="Yazının devamı"><img id="imgdevam_25" src="themes/gothic/plus.gif" alt="Yazının devamı"></a></td></tr></table>
<table border="0" cellspacing="0" cellpadding="0" style="width:539px;layout:fixed;"><tr><td><span class="tags"><b><i>Eklenme tarihi : 07.07.2008 04:57:44</i></b></span><br>
<span class="tags"><b><i>Güncellenme tarihi : 07.07.2008 04:57:50</i></b></span></td>
<td style="vertical-align:top;text-align:right;"><div id="smdiv_25" style="display:none;"><form style="display:inline;" id="frmsm_25" method="POST" target="xframe" action="sendbymail.asp" onsubmit="return checkfrmsm(25);">
<input type="hidden" name="post_id" value="25"><input type="text" name="mailto" value=""><input type="submit" value="GÖNDER">
</form>
</div>
</td></tr></table><br>
<p>
<font face="trebuchet ms,geneva">When you change the url by using&nbsp;Javascript: location.replace(),&nbsp; http_referer value is NULL on the new page so I found the solution. First you have to create an empty anchor invisible ;) and use javascript to click on it.</font> 
</p>
<pre>
<font face="trebuchet ms,geneva" size="2">&lt;a id=&quot;a_1&quot; href=&quot;newurl.asp&quot;&gt;&lt;/a&gt;</font>
</pre>
<pre>
<font face="trebuchet ms,geneva" size="2">&lt;table onclick=&quot;document.getElementById('a_1').click()&quot;&gt;&lt;tr&gt;&lt;td&gt;content&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;</font>
</pre>
<pre>
<font face="trebuchet ms,geneva"><font size="2"><u>newurl.asp:</u>&lt;%Response.Write Request.ServerVariables(&quot;HTTP_REFERER&quot;)%&gt;</font></font>
</pre>
<pre>
<font face="trebuchet ms,geneva" size="2">After this, you have to see the previous url as the referer on the newurl.asp</font>
</pre>
<br>
<br>
<span class="tags"><b><i><span id="vcnt">15</span> kere görüntülendi...</i></b></span><br>
<a href="javascript:togglecomment('cm_25')">Yorumlar [1] | Yorum Ekle</a><br><div id="cm_25" style="display:none;width:570px;"><div id="comment_106" style=""><hr>
<span class="tags">Bush</span><br><span class="tagsdisp">Hello, nice site look this:


End ^) See you
Nice site!
Good.
Cool.

</span><br><span class="tagsdisp">03.08.2008 03:39:53</span></div><form target="xframe" id="frm_25" style="display:inline" method="POST" action="savecomment.asp" onsubmit="return checkform1('frm_25')">
<hr>
<span class="tags">Yorum Ekle</span><br>
<input type="hidden" name="post_id" value="25">
<table border="0" cellpadding="3" cellspacing="0" style="width:348px;table-layout:fixed;">
<tr><td align="right" style="width:84px;">Görünen Ad *: </td><td><input type="text" name="commenter_nick"></td></tr>
<tr><td align="right">E-Posta : </td><td><input type="text" name="commenter_email"></td></tr>
<tr><td align="right">Yorum *: </td><td><textarea name="comment_data" style="width:250px;height:150px;"></textarea></td></tr>
<tr><td></td><td><input type="submit" value="EKLE"></td></tr>
<tr><td colspan="2" style="background:#FF8;color:#000;font-size:10px;line-height:12px;font-weight:bold;text-align:justify;width:348px;padding:5px;">Not: E-posta adresiniz sadece yazdığınız mesajla ilgili durumlarda size ulaşabilmek amacıyla yönetici tarafından kullanılmak üzere istenmektedir. Sitenin veya internet'in hiçbir yerinde yayınlanmayacaktır. E-posta adresinizi yazma zorunluluğunuz yoktur.</td></tr>
</table>
</form>
</div>
</div>
<br>
<table style="display:inline" border="0" cellspacing="2" cellpadding="0"><tr></tr></table><form target="xframe" style="display:inline;" name="frmreadpost" method="POST" action="readpost.asp">
<input type="hidden" name="post_id">
</form>
<script language="Javascript" type="text/javascript">
var stdhgt = document.getElementById('masterdiv_25').style.height.replace('px','')*2/2;
var pcnt = 5;
function togglecomment(cid)
 {
  if (document.getElementById(cid).style.display == 'none')
   {
    document.getElementById(cid).style.display = '';
   }
  else
   {
    document.getElementById(cid).style.display = 'none';
   }
 }
function checkform1(fid)
 {
  var frm = document.getElementById(fid);
  if(frm.commenter_nick.value=='')
   {
    alert('Nickname yazınız');
    return false;
   }
  if(frm.comment_data.value=='')
   {
    alert('Yorum yazınız');
    return false;
   }
  frm.submit();
  frm.commenter_nick.value='';
  frm.commenter_email.value='';
  frm.comment_data.value='';
  return false;
 }
function checkfrmsm(fid)
 {
  var frm = document.getElementById('frmsm_'+fid);
  if(frm.mailto.value=='')
   {
    alert('E-posta adresi yazınız !');
    return false;
   }
  if(frm.mailto.value.search('@') < 0)
   {
    alert('Geçerli bir e-posta adresi yazınız !');
    return false;
   }
  frm.submit();
  frm.mailto.value='';
  document.getElementById('smdiv_'+fid).style.display='none';
  return false;
 }
function togglepost(pid,scnt)
 {
  if(document.getElementById('masterdiv_'+pid).style.overflow=='visible')
   {
    document.getElementById('masterdiv_'+pid).style.overflow='hidden';
    document.getElementById('masterdiv_'+pid).style.height=stdhgt+'px';
    document.getElementById('imgdevam_'+pid).src='themes\/gothic\/plus.gif';
   }
  else
   {
    if(document.getElementById('masterdiv_32').style.overflow=='visible')
     {
      document.getElementById('masterdiv_32').style.overflow='hidden';
      document.getElementById('masterdiv_32').style.height=stdhgt+'px';
      document.getElementById('imgdevam_32').src='themes\/gothic\/plus.gif';
     }
    if(document.getElementById('masterdiv_29').style.overflow=='visible')
     {
      document.getElementById('masterdiv_29').style.overflow='hidden';
      document.getElementById('masterdiv_29').style.height=stdhgt+'px';
      document.getElementById('imgdevam_29').src='themes\/gothic\/plus.gif';
     }
    if(document.getElementById('masterdiv_28').style.overflow=='visible')
     {
      document.getElementById('masterdiv_28').style.overflow='hidden';
      document.getElementById('masterdiv_28').style.height=stdhgt+'px';
      document.getElementById('imgdevam_28').src='themes\/gothic\/plus.gif';
     }
    if(document.getElementById('masterdiv_27').style.overflow=='visible')
     {
      document.getElementById('masterdiv_27').style.overflow='hidden';
      document.getElementById('masterdiv_27').style.height=stdhgt+'px';
      document.getElementById('imgdevam_27').src='themes\/gothic\/plus.gif';
     }
    if(document.getElementById('masterdiv_25').style.overflow=='visible')
     {
      document.getElementById('masterdiv_25').style.overflow='hidden';
      document.getElementById('masterdiv_25').style.height=stdhgt+'px';
      document.getElementById('imgdevam_25').src='themes\/gothic\/plus.gif';
     }
    document.getElementById('masterdiv_'+pid).style.overflow='visible';
    document.getElementById('masterdiv_'+pid).style.height='auto';
    document.getElementById('imgdevam_'+pid).src='themes\/gothic\/minus.gif';
    document.getElementById('imgdevam_'+pid).src='themes\/gothic\/minus.gif';
    document.getElementById('postsdiv').scrollTop=((scnt-1)*(stdhgt+29));
    document.getElementById('vcnt').innerHTML = (document.getElementById('vcnt').innerHTML*2/2)+1;
    document.frmreadpost.post_id.value=pid;
    document.frmreadpost.submit();
   }
 }
</script>
<iframe frameborder="0" name="xframe" width="0" height="0" src="about:blank"></iframe>    </div></td>
   </tr>
  </table>
  </td>
  <td>

	<div class="divpost" style="width:130px;padding:0px;text-align:center;">

<script type="text/javascript"><!--
google_ad_client = "pub-3227559277969830";
//120x600, oluşturulma 30.11.2007
google_ad_slot = "6174438679";
google_ad_width = 120;
google_ad_height = 600;
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>

	</div>

  </td>
  </tr>
  </table>


  <a style="position:absolute;right:5px;top:0px;text-decoration:none;" href="login.asp">&nbsp;&nbsp;&nbsp;&nbsp;</a>

 </body>
</html>

