Type Mismatch again

[Miguel Orrego]

Hi,

One page passes a strIssueNo to another, so on the 2nd page:

Dim IssueNo
IssueNo = Request.Item("strIssueNo")

This 2nd page is designed to create a new record in a database table,
however I get a Type Mismatch error. This is the line that adds the issue
number:

rsAddNote.Fields("IssueNo") = IssueNo

The field IssueNo is a numerical field in the table, and strIssueNo that is
being passed from the previous page is definitely a number.

What is wrong with my syntax and how can I correct this error?

Thanks in advance.

[Matt Smith]

If you're sure that the data is going to be valid then you can just force
the type with CInt()
If you're not so sure, then try applying IsNumeric() first.
e.g:
dim IssueNo
IssueNo= Request.Item("strIssueNo")
If IsNumeric(IssueNo) then
rsAddNote.Fields("IssueNo") = CInt(IssueNo)
End If

Hope it helps.

Matt

[Tim Williams]

isn't the limit for int around 32000? Seems you'd be hard-pressed to fit
906k into that datatype.

Possible your db field is something else ?

tim



"Miguel Orrego" <miguel@stressedmonkey.net-nospam> wrote in message
news:3f05a610$0$10627$cc9e4d1f@news.dial.pipex.com ...

> Thanks Matt, unfortunately this still doesn't seem to solve the problem.
>
> I am certain that strIssueNumber is a number, because this is the link

that

> the previous page generates to get to this one:
>
>

[url]http://webserver/systems/helpdesk/globm/createnote.asp?strIssueNo=0000000000[/url]

> 0000906741
>
> When I try to use
>
> rsAddNote.Fields("IssueNo") = CInt(IssueNo)
>
> I now get a different error:
>
> Microsoft VBScript runtime error '800a0006'
>
> Overflow: 'CInt'
>
> /systems/helpdesk/globm/createnote.asp, line 39
>
>
>
> The field IssueNo in the database table is an integer field. The database

is

> sql server 7.0
>
> Any ideas?
>
> Thanks.
>
>
>
> "Matt Smith" <_matt@breathemail.net> wrote in message
> news:be43nq$re4$1@hercules.btinternet.com...

> > If you're sure that the data is going to be valid then you can just

force

> > the type with CInt()
> > If you're not so sure, then try applying IsNumeric() first.
> > e.g:
> > dim IssueNo
> > IssueNo= Request.Item("strIssueNo")
> > If IsNumeric(IssueNo) then
> > rsAddNote.Fields("IssueNo") = CInt(IssueNo)
> > End If
> >
> > Hope it helps.
> >
> > Matt
> >
> >

>
>

[Marvin Thompson]

To avoid the overflow, use CLng(strIssueNo)


"Tim Williams" <saxifrax@pacbell*dot*net> wrote in message
news:%23dnyInmQDHA.1564@TK2MSFTNGP12.phx.gbl...

> isn't the limit for int around 32000? Seems you'd be hard-pressed to fit
> 906k into that datatype.
>
> Possible your db field is something else ?
>
> tim
>
>
>
> "Miguel Orrego" <miguel@stressedmonkey.net-nospam> wrote in message
> news:3f05a610$0$10627$cc9e4d1f@news.dial.pipex.com ...

> > Thanks Matt, unfortunately this still doesn't seem to solve the problem.
> >
> > I am certain that strIssueNumber is a number, because this is the link

> that

> > the previous page generates to get to this one:
> >
> >

>

[url]http://webserver/systems/helpdesk/globm/createnote.asp?strIssueNo=0000000000[/url]

> > 0000906741
> >
> > When I try to use
> >
> > rsAddNote.Fields("IssueNo") = CInt(IssueNo)
> >
> > I now get a different error:
> >
> > Microsoft VBScript runtime error '800a0006'
> >
> > Overflow: 'CInt'
> >
> > /systems/helpdesk/globm/createnote.asp, line 39
> >
> >
> >
> > The field IssueNo in the database table is an integer field. The

database

> is

> > sql server 7.0
> >
> > Any ideas?
> >
> > Thanks.
> >
> >
> >
> > "Matt Smith" <_matt@breathemail.net> wrote in message
> > news:be43nq$re4$1@hercules.btinternet.com...

> > > If you're sure that the data is going to be valid then you can just

> force

> > > the type with CInt()
> > > If you're not so sure, then try applying IsNumeric() first.
> > > e.g:
> > > dim IssueNo
> > > IssueNo= Request.Item("strIssueNo")
> > > If IsNumeric(IssueNo) then
> > > rsAddNote.Fields("IssueNo") = CInt(IssueNo)
> > > End If
> > >
> > > Hope it helps.
> > >
> > > Matt
> > >
> > >

> >
> >

>
>