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 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
