Re: Problems with data type (number converted to char)

Manu wrote:

> No problem sir ;) I'm still looking for help if anyone has an idea!
>
> > oops, didn't even see that. Sorry about that.
> >
> > ;-)
> >
> > Manu wrote:
> >>
> >> This sure will work but, as I told you, the problem is that the select has to be done on *, ans TRIM(*) won't work... Anyway if you know how to make TRIM work for *, i'll be happy to share your knowledge ;)
> >> Thanks
> >>
> >> E.Andreu
> >>
> >> > TRIM(col_name)
> >> >
> >> > Manu wrote:
> >> >>
> >> >> Hello,
> >> >> I'm actually having problems with Oracle 8.1.7 and ASP2 (i don't know if this would happen on other versions, but these are mine).
> >> >> When doing vie ASP a "select * from TABLE where COLUMN='this' and OTHER='that';", the content of the columns that are NUMBER(5) is interpreted by ASP as being a character. I cannot add this number to another one in ASP without doing a cint() to force it to be considered as an integer, or doing a trim(). That's why I think that my 'select' brings me the number and blanks, making ASP consider it as a character.
> >> >> Is there a parameter that would tell Oracle to systematically trim all data? Or at least all data from NUMBER() types? So that the result of my query would not be ' 5 ' nor '5 ' but '5'...
> >> >> Or do you think the problem's elsewhere?
> >> >>
> >> >> Thanks in advance.
> >> >>
> >> >> E.Andreu

I'd be happy to try to help you but you need to explain something ... Exactly why MUST you use SELECT * as opposed to naming the columns?

I do hope it is one grounded in technology rather than some desire to avoid moving our fingers on the keyboard.

Daniel Morgan Received on Tue May 28 2002 - 14:42:54 CDT