unique identification of a column with tablename.column is sop (at least in the oracle world)
i assume Mr McGaughey is "learning" and thus the reason for our helping instead of engaging in vilification activity speaking of learning where is/are column-name 'headers' defined ? Martin Gainty ______________________________________________ Note de déni et de confidentialité Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Thu, 6 Aug 2009 08:26:07 -0400 > From: sco...@pythian.com > To: tim.bu...@pobox.com > CC: dbi-users@perl.org; link.mcgaug...@gmail.com > Subject: Re: (Fwd) Question regarding DBI status > > Not to speak for Tim on this but here is my 2cents worth, > > Your case here is poor SQL and or table design which you are trying to > account for with DBI. > > If you intend to use the cursor/recordset column 'headers' as unique > identifiers then you should set them up as such. > > ie > Select test.id as user_name, > new.id as user_id, > test.name as old_name, > new.number as Number > from test, new > where test.id=new.id > > Never assume your third party tool will will fix this sort of problem > for you. > > cheers > > Tim Bunce wrote: > > ----- Forwarded message from Link McGaughey <link.mcgaug...@gmail.com> ----- > > > > Date: Wed, 5 Aug 2009 18:41:56 -0400 > > Subject: Question regarding DBI status > > From: Link McGaughey <link.mcgaug...@gmail.com> > > To: tim.bu...@pobox.com > > > > Tim, > > > > I found your information from CPAN, and had a question regarding the > > status of active development for DBI more specifically > > 'fetchrow_hashref'. > > > > The issue that I am having is based around 'JOIN' statements and table > > with same named columns. > > > > I have found several work arounds to my problem, but didn't know if > > there was a version of DBI that left the table name prefixed to the > > column name. (ie table.column). > > > > Any information would be great. > > > > Thanks, > > -Link > > > > ----- End forwarded message ----- > > _________________________________________________________________ Windows Live™: Keep your life in sync. http://windowslive.com/explore?ocid=PID23384::T:WLMTAGL:ON:WL:en-US:NF_BR_sync:082009
