Click here to Skip to main content
15,919,358 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionsite tracking Pin
Amit Agarrwal6-Sep-06 23:50
Amit Agarrwal6-Sep-06 23:50 
QuestionSession Problem Pin
monika_vasvani6-Sep-06 23:48
monika_vasvani6-Sep-06 23:48 
AnswerRe: Session Problem Pin
Guffa7-Sep-06 0:17
Guffa7-Sep-06 0:17 
AnswerRe: Session Problem Pin
Jay_se7-Sep-06 0:43
Jay_se7-Sep-06 0:43 
GeneralRe: Session Problem Pin
monika_vasvani7-Sep-06 2:16
monika_vasvani7-Sep-06 2:16 
GeneralRe: Session Problem Pin
_AK_7-Sep-06 2:18
_AK_7-Sep-06 2:18 
GeneralRe: Session Problem Pin
Jay_se7-Sep-06 2:32
Jay_se7-Sep-06 2:32 
GeneralRe: Session Problem Pin
monika_vasvani7-Sep-06 3:03
monika_vasvani7-Sep-06 3:03 
GeneralRe: Session Problem Pin
Jay_se7-Sep-06 3:40
Jay_se7-Sep-06 3:40 
Questionproblem in Gried View -urgent Pin
DotnetRafi6-Sep-06 23:40
DotnetRafi6-Sep-06 23:40 
AnswerRe: problem in Gried View -urgent Pin
_AK_7-Sep-06 2:22
_AK_7-Sep-06 2:22 
QuestionFileUpload Control Pin
doyang6-Sep-06 23:11
doyang6-Sep-06 23:11 
Questiondynamic control Pin
ketan.raval6-Sep-06 21:49
ketan.raval6-Sep-06 21:49 
AnswerRe: dynamic control Pin
Paddy Boyd6-Sep-06 23:34
Paddy Boyd6-Sep-06 23:34 
GeneralRe: dynamic control Pin
ketan.raval7-Sep-06 4:10
ketan.raval7-Sep-06 4:10 
Questionsql config error Pin
yasar khan6-Sep-06 21:12
yasar khan6-Sep-06 21:12 
<%

mysql=("select MAX(cast(SUBSTRING(Appellant_Notice_Number,1,LEN(Appellant_Notice_Number)-5)as int))+1 As vals FROM RegisteredCase where Appellant_Notice_Number is not null")
set rs=con.execute(mysql)
yearvar=year(Date)
if(isNull(rs("vals"))) then
anum="1/"& yearvar
else
anum=rs.fields("vals")&"/"& yearvar
end if
%>

I get the following error in the above code. Plz help me solving this error.
(Note: Appellant_Notice_Number values are, for example 225/2005 or 1/2006 or 15/2005 etc)

Microsoft OLE DB Provider for SQL Server error '80040e14'

Invalid length parameter passed to the substring function.

/adminsite/Adminpages/noticeissue.asp, line 87





adsf e ed w we we w

AnswerRe: sql config error Pin
RichardGrimmer7-Sep-06 5:35
RichardGrimmer7-Sep-06 5:35 
Questiondatagrid Pin
umaheshchandra6-Sep-06 21:11
umaheshchandra6-Sep-06 21:11 
AnswerRe: datagrid Pin
Sathesh Sakthivel7-Sep-06 0:00
Sathesh Sakthivel7-Sep-06 0:00 
Questionneed help wit data binding with hyperlink Pin
neodeaths6-Sep-06 20:48
neodeaths6-Sep-06 20:48 
AnswerRe: need help wit data binding with hyperlink Pin
Jay_se6-Sep-06 20:59
Jay_se6-Sep-06 20:59 
AnswerRe: need help wit data binding with hyperlink Pin
Exelioindia6-Sep-06 23:51
Exelioindia6-Sep-06 23:51 
AnswerRe: need help wit data binding with hyperlink Pin
RichardGrimmer7-Sep-06 5:37
RichardGrimmer7-Sep-06 5:37 
Questionexecuting url without launching a new browser window Pin
Azel Low6-Sep-06 20:42
Azel Low6-Sep-06 20:42 
AnswerRe: executing url without launching a new browser window Pin
MIHAI_MTZ6-Sep-06 21:10
MIHAI_MTZ6-Sep-06 21:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.