Comparing results of type unknown

Hi List,
I want to compare the two rows of db result returned by
query using DBI module.

If I simply use != operator it gives me error when comparing
the columns which are of char type.

Does there exist anyway wherein I can do one liner compare
irrespective of data types?

OR

checking the column names first and then using appropriate
operator is the only solution?

Thanks,
Manish

On Fri, 22 Apr 2005, Manish Sapariya wrote:

> I want to compare the two rows of db result returned by
> query using DBI module.
>
> If I simply use != operator it gives me error when comparing
> the columns which are of char type.
>
> Does there exist anyway wherein I can do one liner compare
> irrespective of data types?
>
> OR
>
> checking the column names first and then using appropriate
> operator is the only solution?

Show us the code you're using.

Show us a couple of lines of the data you're trying to compare.

Consider that most database servers let you do this sort of thing right
in the SQL statements, so it may make sense to just completely avoid
writing this part of your program in Perl to begin with.



--
Chris Devers