Home > Archive > PERL Beginners > April 2005 > Comparing results of type unknown
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Comparing results of type unknown
|
|
| Manish Sapariya 2005-04-22, 3:57 pm |
| 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
| |
| Chris Devers 2005-04-22, 3:57 pm |
| 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
|
|
|
|
|