ORACLE and IsNumeric.....
thanks Raymond
I've just solved the problem....Bizarrely, if the field values in Oracle are
varchar(2), ASP interprets the numbers as numbers, but as explained, if the
field values in Oracle are Numbers, ASP doesn't interpret the numbers as
numbers!!
cheers again
Alex
Quote:
> Try:
> response.write north
> to see what is being returned.
> For example, is it 45 or "45".
> > Cheers for reading this post! I'm having a long line of problems trying
to
> > get my application, developed for MS Access to work with a new
> (identical)
> > Oracle DB.
> > A section of the code performs a calculation upon numeric field values.
> When
> > I tried using my new Oracle database I got a "Type Mismatch" error. I
> tried
> > a test...
> > If IsNumeric(north) Then
> > Response.Write "NORTH IS NUMERIC"
> > Else
> > Response.Write "NORTH IS NOT NUMERIC"
> > End If
> > Basically.....The fields with NUMBER datatypes in Oracle aren't being
> > recognised as such. Using CInt isn't an option....it takes too long. Has
> > anyone else had such a problem? It's a mystery (and I'm pulling my hair
> > out), as there's only one numeric datatype with Oracle, so it's not as
if
> > I've chosen then wrong datatype.
> > Any ideas?
> > thanks
> > Alex
