hi,
i need the columnname salary varchar (i.e) size of that field...
siva125
Last Activity: Jun 6 '10, 08:56 AM
Joined: Feb 1 '10
Location:
-
How to get the number of characters occupied in particular column
I use this query for my table but it retrives the value for each row. It does not retrieve the size of the column name. I need to know the number of characters occupied in particular column. How do i get this value?
SELECT LEN(salary) AS MyLength FROM employee -
i need to use function as parameter to another function
...Code:function populatedropdown(dayfield, monthfield, yearfield) { var today=new Date() var dayfield=document.getElementById(dayfield) var monthfield=document.getElementById(monthfield) var yearfield=document.getElementById(yearfield) for (var i=1; i<31; i++) dayfield.options[i]=new Option(i, i+1) dayfield.options[today.getDate()]=new Option(today.getDate(), today.getDate(), true, true) //select -
siva125 started a topic I thin pbm in onchange pl find the solution for me...i cant handle thisonchange eventin ASP ClassicI thin pbm in onchange pl find the solution for me...i cant handle thisonchange event
...Code:<html> <body> <form name="f1" method=post style="COLOR: mediumblue" action=loccusdet.asp> <P> </P> <P> </P> <P> BRANCH CODE <INPUT id=text1 name=brcd > LOCKERNO <INPUT id=text2 name=opt1 onchange="window.f1.submit()">
-
any book availble for classic asp
any book material available for classic asp please help if the book material available...i gone for course even i feel some diffculities,,, -
siva125 started a topic i mention the error i dont know what to do i new to script...in ASP Classici mention the error i dont know what to do i new to script...
...Code:<!-- #include file="connection.inc"--> <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> <TITLE></TITLE> </HEAD> <BODY> <FORM NAME=f1 METHOD=post ACTION=errlog.ASP> <% set rs1=server.CreateObject("adodb.recordset") %> <P>MODULELast edited by Frinavale; Feb 17 '10, 03:25 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags. -
thank u .but i did rownum+99 in select command itself it workingLeave a comment:
-
i need to start row number as 100
i use row_number() in my sql query to generate number from 1...,but i need to start with row number from 100,101 like wise i using sql4.2 navigator ,i use auto increment it show error what to do
insert into ideal_ctry(sele ct row_number() over (order by description asc)) as ncode
but i need start with 100,101... -
Insert row number
i use row_number() in my sql query to generate number from 1...,but i need to start with row number from 100,101 like wise i using sql4.2 navigator ,i use auto increment it show error what to do
insert into ideal_ctry(sele ct row_number() over (order by description asc)) as ncode
but i need start with 100,101...
No activity results to display
Leave a comment: