salman.pirani

may i know the options which are for free.thanks

am searching the code for making pdf in asp classic, i have made a form in asp and on submit button i want that it get convert in pdf and get to attached in email. thanks in advance plz help

Please Help Error SELECT AVG® AS Average FROM tform WHERE pt='Taming the Time Monster' Microsoft OLE DB Provider for SQL Server error '80040e07' The average aggregate operation cannot take a varchar data type as an argument. /hr/tform/admin/avrage.asp, line 20 Code<%strConnect ="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=usrtform;Initial Catalog=hrtform;Data Source=intranet;pwd=tform123"set cn= server.createobject("adodb.connection")set rs=server.createobject("adodb.recordset")cn.open strConnect sql="SELECT AVG® AS Average FROM tform WHERE pt='" & Request.Form("id") & "'"response.Write(sql)set rs=cn.execute(sql) %> <% do until rs.EOF%><tr> <%for each x in rs.Fields%> <td><%Response.Write(x.value)%></td> <%next rs.MoveNext%></tr> <%looprs.closecn.close%>

have made some chnages but still having this error plz help Error code -2147467259 <%set conn=Server.CreateObject("ADODB.Connection")strConnect = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/hr/tform/admin/webdata/course.mdb")'set db=server.createobject("adodb.connection")conn.connectiontimeout=120conn.open strConnectset rs=Server.CreateObject("ADODB.recordset")'conn.Provider="Microsoft.Jet.OLEDB.4.0"'conn.Open(Server.MapPath("webdata/course.mdb"))'conn.Open("G:\wwwroot2\hr\tform\admin\webdata\course.mdb")sql="INSERT INTO course (pt,course_owner,"sql=sql & "training_cordinator)"sql=sql & " VALUES "sql=sql & "('" & Request.Form("pt") & "',"sql=sql & "'" & Request.Form("course_owner") & "',"sql=sql & "'" & Request.Form("training_coo") & "')" on error resume nextconn.Execute sql,recaffectedif err<>0 then Response.Write("Error code " & err)else Response.Write("<h3> Programme Title has been created</h3>")end if conn.close%>

dear sir db is corect query is corect i dnt knw whr is the error out putG:\wwwroot2\hr\tform\admin\webdata\course.mdbError code -2147467259INSERT INTO course (pt,course_owner,training_cordinator) VALUES ('sss','w','w') <%set conn=Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open(Server.MapPath("webdata/course.mdb"))response.Write(Server.MapPath("webdata/course.mdb"))sql="INSERT INTO course (pt,course_owner,"sql=sql & "training_cordinator)"sql=sql & " VALUES "sql=sql & "('" & Request.Form("pt") & "',"sql=sql & "'" & Request.Form("course_owner") & "',"sql=sql & "'" & Request.Form("training_coo") & "')" on error resume nextconn.Execute sql,recaffectedif err<>0 then Response.Write("Error code " & err)else Response.Write("<h3> Programme Title has been created</h3>")end ifresponse.Write(sql) conn.close%>

sorry sir, but sir how it will start from one again next year

sir can u please guide me

i hav a query i want that a a refrence number generate autometicly take the max num from database bas and +1 into it but when the year change like in 2013 it will again start from 1 could you help me plz in this regards .thanks

but now i hav another query i want that a a refrence number generate autometicly take the max num from database bas and +1 into it but when the year change like in 2013 it will again start from 1 could you help me plz in this regards . thanks

ow its workig i now exeuting this UPDATE tsf_form SET des_exp1='sss',Vendor='AFN' WHERE empid='234'

its printing this i dnt know whats the error, UPDATE tsf_form SET des_exp1='sss',Vendor='AFN' WHERE empid=234

i tried this but still not working sir plz help <%set conn=Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open "c:/webdata/sxsheet2.mdb"cid=Session("a")if Request.Form("des_exp1")="" thenset rs=Server.CreateObject("ADODB.Recordset")rs.open "SELECT * FROM tsf_form WHERE empid='" & cid & "'",connelsesql="UPDATE tsf_form SET " sql=sql & "des_exp1='" & Request.Form("des_exp1") & "'," sql=sql & "amount1='" & Request.Form("amount1") & "'" sql=sql & " WHERE empid=" & cid & "" on error resume next conn.Execute sql if err<>0 then response.write("No update permissions!") else response.write("Record " & cid & " was updated!") end ifend ifconn.close%>

still nt wrking u were saying abut this rite sql=sql & "Funded_by1='" & Request.Form("Funded_by1") & "',"

where sir ?

hello dear, am executing this query i dnt know why its nt working <%set conn=Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open "c:/webdata/sxsheet2.mdb"cid=Session("a")if cid="" thenset rs=Server.CreateObject("ADODB.Recordset")rs.open "SELECT * FROM tsf_form WHERE empid='" & cid & "'",connelsesql="UPDATE tsf_form SET " sql=sql & "Funded_by1='" & Request.Form("Funded_by1") & "'," sql=sql & " WHERE empid=" & cid & "" on error resume next conn.Execute sql if err<>0 then response.write("No update permissions!") else response.write("Record " & cid & " was updated!") end ifend ifconn.close%>

thank u sir for your response, am at very beginner level so what should i do i just want a date picker which provide me the date in mmddyycan u guide me to any relevent website

1 page <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Untitled Document</title><script language="JavaScript" src="pupdate.js"></script></head><body><form action="ac.asp" method="post"><input type="text" name="choice1_1" onFocus="getCalendarFor(this)"><input name="" type="submit" /></form><script language="JavaScript">if (document.all) {document.writeln("<div id=\"PopUpCalendar\" style=\"position:absolute; left:0px; top:0px; z-index:7; width:200px; height:77px; overflow: visible; visibility: hidden; background-color: #FFFFFF; border: 1px none #000000\" onMouseOver=\"if(ppcTI){clearTimeout(ppcTI);ppcTI=false;}\" onMouseOut=\"ppcTI=setTimeout(\'hideCalendar()\',500)\">");document.writeln("<div id=\"monthSelector\" style=\"position:absolute; left:0px; top:0px; z-index:9; width:181px; height:27px; overflow: visible; visibility:inherit\">");}else if (document.layers) {document.writeln("<layer id=\"PopUpCalendar\" pagex=\"0\" pagey=\"0\" width=\"200\" height=\"200\" z-index=\"100\" visibility=\"hide\" bgcolor=\"#FFFFFF\" onMouseOver=\"if(ppcTI){clearTimeout(ppcTI);ppcTI=false;}\" onMouseOut=\"ppcTI=setTimeout('hideCalendar()',500)\">");document.writeln("<layer id=\"monthSelector\" left=\"0\" top=\"0\" width=\"181\" height=\"27\" z-index=\"9\" visibility=\"inherit\">");}else {document.writeln("<p><font color=\"#FF0000\"><b>Error ! The current browser is either too old or too modern (usind DOM document structure).</b></font></p>");}</script><noscript><p><font color="#FF0000"><b>JavaScript is not activated !</b></font></p></noscript><table border="1" cellspacing="1" cellpadding="2" width="200" bordercolorlight="#000000" bordercolordark="#000000" vspace="0" hspace="0"><form name="ppcMonthList"><tr><td align="center" bgcolor="#CCCCCC"><a href="javascript:moveMonth('Back')" onMouseOver="window.status=' ';return true;"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000"><b>< </b></font></a><font face="MS Sans Serif, sans-serif" size="1"><select name="sItem" onMouseOut="if(ppcIE){window.event.cancelBubble = true;}" onChange="switchMonth(this.options[this.selectedIndex].value)" style="font-family: 'MS Sans Serif', sans-serif; font-size: 9pt"><option value="0" selected>2000 • January</option><option value="1">2000 • February</option><option value="2">2000 • March</option><option value="3">2000 • April</option><option value="4">2000 • May</option><option value="5">2000 • June</option><option value="6">2000 • July</option><option value="7">2000 • August</option><option value="8">2000 • September</option><option value="9">2000 • October</option><option value="10">2000 • November</option><option value="11">2000 • December</option><option value="0">2001 • January</option></select></font><a href="javascript:moveMonth('Forward')" onMouseOver="window.status=' ';return true;"><font face="Arial, Helvetica, sans-serif" size="2" color="#000000"><b> ></b></font></a></td></tr></form></table><table border="1" cellspacing="1" cellpadding="2" bordercolorlight="#000000" bordercolordark="#000000" width="200" vspace="0" hspace="0"><tr align="center" bgcolor="#CCCCCC"><td width="20" bgcolor="#FFFFCC"><b><font face="MS Sans Serif, sans-serif" size="1">Su</font></b></td><td width="20"><b><font face="MS Sans Serif, sans-serif" size="1">Mo</font></b></td><td width="20"><b><font face="MS Sans Serif, sans-serif" size="1">Tu</font></b></td><td width="20"><b><font face="MS Sans Serif, sans-serif" size="1">We</font></b></td><td width="20"><b><font face="MS Sans Serif, sans-serif" size="1">Th</font></b></td><td width="20"><b><font face="MS Sans Serif, sans-serif" size="1">Fr</font></b></td><td width="20" bgcolor="#FFFFCC"><b><font face="MS Sans Serif, sans-serif" size="1">Sa</font></b></td></tr></table><script language="JavaScript">if (document.all) {document.writeln("</div>");document.writeln("<div id=\"monthDays\" style=\"position:absolute; left:0px; top:52px; z-index:8; width:200px; height:17px; overflow: visible; visibility:inherit; background-color: #FFFFFF; border: 1px none #000000\"> </div></div>");}else if (document.layers) {document.writeln("</layer>");document.writeln("<layer id=\"monthDays\" left=\"0\" top=\"52\" width=\"200\" height=\"17\" z-index=\"8\" bgcolor=\"#FFFFFF\" visibility=\"inherit\"> </layer></layer>");}else {/*NOP*/}</script></body></html> 2 page /* PopUp Calendar v2.1© PCI, Inc.,2000 • Freewarewebmaster@personal-connections.com+1 (925) 955 1624Permission granted for unlimited use so faras the copyright notice above remains intact. *//* Settings. Please read readme.html file for instructions*/var ppcDF = "m/d/Y";var ppcMN = new Array("January","February","March","April","May","June","July","August","September","October","November","December");var ppcWN = new Array("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday");var ppcER = new Array(4);ppcER[0] = "Required DHTML functions are not supported in this browser.";ppcER[1] = "Target form field is not assigned or not accessible.";ppcER[2] = "Sorry, the chosen date is not acceptable. Please read instructions on the page.";ppcER[3] = "Unknown error occured while executing this script.";var ppcUC = false;var ppcUX = 4;var ppcUY = 4;/* Do not edit below this line unless you are sure what are you doing! */var ppcIE=(navigator.appName == "Microsoft Internet Explorer");var ppcNN=((navigator.appName == "Netscape")&&(document.layers));var ppcTT="<table width=\"200\" cellspacing=\"1\" cellpadding=\"2\" border=\"1\" bordercolorlight=\"#000000\" bordercolordark=\"#000000\">\n";var ppcCD=ppcTT;var ppcFT="<font face=\"MS Sans Serif, sans-serif\" size=\"1\" color=\"#000000\">";var ppcFC=true;var ppcTI=false;var ppcSV=null;var ppcRL=null;var ppcXC=null;var ppcYC=null;var ppcML=new Array(31,28,31,30,31,30,31,31,30,31,30,31);var ppcWE=new Array("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday");var ppcNow=new Date();var ppcPtr=new Date();if (ppcNN) {window.captureEvents(Event.RESIZE);window.onresize = restoreLayers;document.captureEvents(Event.MOUSEDOWN|Event.MOUSEUP);document.onmousedown = recordXY;document.onmouseup = confirmXY;}function restoreLayers(e) {if (ppcNN) { with (window.document) { open("text/html"); write("<html><head><title>Restoring the layer structure...</title></head>"); write("<body bgcolor=\"#FFFFFF\" onLoad=\"history.go(-1)\">"); write("</body></html>"); close();}}}function recordXY(e) {if (ppcNN) { ppcXC = e.x; ppcYC = e.y; document.routeEvent(e);}}function confirmXY(e) {if (ppcNN) { ppcXC = (ppcXC == e.x) ? e.x : null; ppcYC = (ppcYC == e.y) ? e.y : null; document.routeEvent(e);}}function getCalendarFor(target,rules) {ppcSV = target;ppcRL = rules;if (ppcFC) {setCalendar();ppcFC = false;}if ((ppcSV != null)&&(ppcSV)) { if (ppcIE) { var obj = document.all['PopUpCalendar']; obj.style.left = document.body.scrollLeft+event.clientX; obj.style.top = document.body.scrollTop+event.clientY; obj.style.visibility = "visible";} else if (ppcNN) { var obj = document.layers['PopUpCalendar']; obj.left = ppcXC obj.top = ppcYC obj.visibility = "show";} else {showError(ppcER[0]);}}else {showError(ppcER[1]);}}function switchMonth(param) {var tmp = param.split("|");setCalendar(tmp[0],tmp[1]);}function moveMonth(dir) {var obj = null;var limit = false;var tmp,dptrYear,dptrMonth;if (ppcIE) {obj = document.ppcMonthList.sItem;}else if (ppcNN) {obj = document.layers['PopUpCalendar'].document.layers['monthSelector'].document.ppcMonthList.sItem;}else {showError(ppcER[0]);}if (obj != null) { if ((dir.toLowerCase() == "back")&&(obj.selectedIndex > 0)) {obj.selectedIndex--;} else if ((dir.toLowerCase() == "forward")&&(obj.selectedIndex < 12)) {obj.selectedIndex++;} else {limit = true;}}if (!limit) { tmp = obj.options[obj.selectedIndex].value.split("|"); dptrYear = tmp[0]; dptrMonth = tmp[1]; setCalendar(dptrYear,dptrMonth);}else { if (ppcIE) { obj.style.backgroundColor = "#FF0000"; window.setTimeout("document.ppcMonthList.sItem.style.backgroundColor = '#FFFFFF'",50);}}}function selectDate(param) {var arr = param.split("|");var year = arr[0];var month = arr[1];var date = arr[2];var ptr = parseInt(date);ppcPtr.setDate(ptr);if ((ppcSV != null)&&(ppcSV)) { if (validDate(date)) {ppcSV.value = dateFormat(year,month,date);hideCalendar();} else {showError(ppcER[2]);if (ppcTI) {clearTimeout(ppcTI);ppcTI = false;}}}else { showError(ppcER[1]); hideCalendar();}}function setCalendar(year,month) {if (year == null) {year = getFullYear(ppcNow);}if (month == null) {month = ppcNow.getMonth();setSelectList(year,month);}if (month == 1) {ppcML[1] = (isLeap(year)) ? 29 : 28;}ppcPtr.setYear(year);ppcPtr.setMonth(month);ppcPtr.setDate(1);updateContent();}function updateContent() {generateContent();if (ppcIE) {document.all['monthDays'].innerHTML = ppcCD;}else if (ppcNN) { with (document.layers['PopUpCalendar'].document.layers['monthDays'].document) { open("text/html"); write("<html>\n<head>\n<title>DynDoc</title>\n</head>\n<body bgcolor=\"#FFFFFF\">\n"); write(ppcCD); write("</body>\n</html>"); close();}}else {showError(ppcER[0]);}ppcCD = ppcTT;}function generateContent() {var year = getFullYear(ppcPtr);var month = ppcPtr.getMonth();var date = 1;var day = ppcPtr.getDay();var len = ppcML[month];var bgr,cnt,tmp = "";var j,i = 0;for (j = 0; j < 7; ++j) { if (date > len) {break;} for (i = 0; i < 7; ++i) { bgr = ((i == 0)||(i == 6)) ? "#FFFFCC" : "#FFFFFF"; if (((j == 0)&&(i < day))||(date > len)) {tmp += makeCell(bgr,year,month,0);} else {tmp += makeCell(bgr,year,month,date);++date;}} ppcCD += "<tr align=\"center\">\n" + tmp + "</tr>\n";tmp = "";}ppcCD += "</table>\n";}function makeCell(bgr,year,month,date) {var param = "\'"+year+"|"+month+"|"+date+"\'";var td1 = "<td width=\"20\" bgcolor=\""+bgr+"\" ";var td2 = (ppcIE) ? "</font></span></td>\n" : "</font></a></td>\n";var evt = "onMouseOver=\"this.style.backgroundColor=\'#FF0000\'\" onMouseOut=\"this.style.backgroundColor=\'"+bgr+"\'\" onMouseUp=\"selectDate("+param+")\" ";var ext = "<span Style=\"cursor: hand\">";var lck = "<span Style=\"cursor: default\">";var lnk = "<a href=\"javascript:selectDate("+param+")\" onMouseOver=\"window.status=\' \';return true;\">";var cellValue = (date != 0) ? date+"" : " ";if ((ppcNow.getDate() == date)&&(ppcNow.getMonth() == month)&&(getFullYear(ppcNow) == year)) { cellValue = "<b>"+cellValue+"</b>";}var cellCode = "";if (date == 0) { if (ppcIE) {cellCode = td1+"Style=\"cursor: default\">"+lck+ppcFT+cellValue+td2;} else {cellCode = td1+">"+ppcFT+cellValue+td2;}}else { if (ppcIE) {cellCode = td1+evt+"Style=\"cursor: hand\">"+ext+ppcFT+cellValue+td2;} else { if (date < 10) {cellValue = " " + cellValue + " ";} cellCode = td1+">"+lnk+ppcFT+cellValue+td2;}}return cellCode;}function setSelectList(year,month) {var i = 0;var obj = null;if (ppcIE) {obj = document.ppcMonthList.sItem;}else if (ppcNN) {obj = document.layers['PopUpCalendar'].document.layers['monthSelector'].document.ppcMonthList.sItem;}else {/* NOP */}while (i < 13) { obj.options[i].value = year + "|" + month; obj.options[i].text = year + " • " + ppcMN[month]; i++; month++; if (month == 12) {year++;month = 0;}}}function hideCalendar() {if (ppcIE) {document.all['PopUpCalendar'].style.visibility = "hidden";}else if (ppcNN) {document.layers['PopUpCalendar'].visibility = "hide";window.status = " ";}else {/* NOP */}ppcTI = false;setCalendar();ppcSV = null;if (ppcIE) {var obj = document.ppcMonthList.sItem;}else if (ppcNN) {var obj = document.layers['PopUpCalendar'].document.layers['monthSelector'].document.ppcMonthList.sItem;}else {/* NOP */}obj.selectedIndex = 0;}function showError(message) {window.alert("[ PopUp Calendar ]\n\n" + message);}function isLeap(year) {if ((year%400==0)||((year%4==0)&&(year%100!=0))) {return true;}else {return false;}}function getFullYear(obj) {if (ppcNN) {return obj.getYear() + 1900;}else {return obj.getYear();}}function validDate(date) {var reply = true;if (ppcRL == null) {/* NOP */}else { var arr = ppcRL.split(":"); var mode = arr[0]; var arg = arr[1]; var key = arr[2].charAt(0).toLowerCase(); if (key != "d") { var day = ppcPtr.getDay(); var orn = isEvenOrOdd(date); reply = (mode == "[^]") ? !((day == arg)&&((orn == key)||(key == "a"))) : ((day == arg)&&((orn == key)||(key == "a")));} else {reply = (mode == "[^]") ? (date != arg) : (date == arg);}}return reply;}function isEvenOrOdd(date) {if (date - 21 > 0) {return "e";}else if (date - 14 > 0) {return "o";}else if (date - 7 > 0) {return "e";}else {return "o";}}function dateFormat(year,month,date) {if (ppcDF == null) {ppcDF = "m/d/Y";}var day = ppcPtr.getDay();var crt = "";var str = "";var chars = ppcDF.length;for (var i = 0; i < chars; ++i) { crt = ppcDF.charAt(i); switch (crt) { case "M": str += ppcMN[month]; break; case "m": str += (month<9) ? ("0"+(++month)) : ++month; break; case "Y": str += year; break; case "y": str += year.substring(2); break; case "d": str += ((ppcDF.indexOf("m")!=-1)&&(date<10)) ? ("0"+date) : date; break; case "W": str += ppcWN[day]; break; default: str += crt;}}return unescape(str);} dear Sir , the calender is showing the date or u can say month which is going on/from the present month but i want that it give me the old month too so from where can i do the changes of year and all that . Thanks

i have tried this code previously now am trying it on another datbase but now its not workingplease confirm the error am doing <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Untitled Document</title></head><body><%set conn=Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open "c:/webdata/sxsheet.mdb"set rs = Server.CreateObject("ADODB.recordset")cid=Request.Form("pn")sql="SELECT * FROM info WHERE position_num=" & cid & "" %><table border="1" width="100%"> <tr class="b"><td align="center" valign="middle">Position #</td><td align="center" valign="middle">Status</td><td align="center" valign="middle">Department</td><td align="center" valign="middle">Division</td> <td align="center" valign="middle">Ad Date</td><td align="center" valign="middle">Deadline</td><td align="center" valign="middle">Cv to Dep head</td><td align="center" valign="middle">Interview Date</td> <td align="center" valign="middle">Final candidiate</td><td align="center" valign="middle">Comment</td><td align="center" valign="middle">Forms</td><td align="center" valign="middle">Medical sent</td><td align="center" valign="middle">Medical received</td><td align="center" valign="middle">Medical received comments</td><td align="center" valign="middle">Document Verification</td><td align="center" valign="middle">Document Verification comments</td><td align="center" valign="middle">PS verification</td><td align="center" valign="middle">PS verification comments</td><td align="center" valign="middle">TD card request</td><td align="center" valign="middle">TD card request comments</td><td align="center" valign="middle">FLU </td><td align="center" valign="middle">FLU comments </td><td align="center" valign="middle">doc recved</td> <td align="center" valign="middle">doc recved comments</td> </tr> <%do until rs.EOF%> <tr> <%for each x in rs.Fields%> <td><%Response.Write(x.value)%></td> <%next rs.MoveNext%> </tr> <%loop rs.close conn.close %></table></body></html> thanks

but the loop help me to print the all row mention in the data base against the value given if i will remove the loop i will only print 1 row rite ?

the link doest help my query its showing the codes i hv already incorporated

i wnt that i first colum heading should be programme then in 2 column i should show date like this

its showing thiswhen i write programme instead of x.name <table border="1" width="100%"> <tr> <th>programme</th><th>programme</th> </tr> <tr> <td>w</td> <td>ww</td> </tr> <tr> <td>w</td> <td>ww</td> </tr> <tr> <td>ss</td> <td>sss</td> </tr> <tr> <td>ss</td> <td>sss</td> </tr> </table>

in this code response.write("<th>" & x.name & "</th>") x.name is picking the name mention in database if i write any name instead of x.name so it is writing the same name in evry column head i want i will mention name in code andafter the code execute it will show the name i write not the head mention in data base

just one thing more <%set conn=Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open "c:/webdata/northwind1.mdb"set rs = Server.CreateObject("ADODB.recordset")sql="SELECT pt,pdate FROM Customers WHERE eid=" & Request.Form("id") & ""rs.Open sql, conn %><table border="1" width="100%"> <tr> <% for each x in rs.Fields response.write("<th>" & x.name & "</th>") next%> </tr> <%do until rs.EOF%> <tr> <%for each x in rs.Fields%> <td><%Response.Write(x.value)%></td> <%next rs.MoveNext%> </tr> <%loop rs.close conn.close %>

wow great its working so nice of u love u for that thanks alot god bless u ill try it to shows more filed then if i will have any query i will bother u again...thanks