[thelist] returning values you already have (was: SQL statement construction)

[Adrian Fischer]

Hi Matt,

so are you saying that because I have used usAuthenticate in the WHERE
statement that I dont need to mention it before that?  The iteration after
WHERE is all thats required?

Adrian Fischer

>
usNum,usName,UsEmail,usPassword,usFullname,usStreet,usSuburb,usCity,usState,
> > usZip,usPhone,usAuthenticate FROM changeConfirm  WHERE  usAuthenticate="
.
> > int($form{'CONFIRM'}));

<I see that he selected
> usAuthenticate, even though that was a value he already knew, because he
> used it to construct the WHERE clause. I assume that affects performance,