[thelist] returning values you already have (was: SQL statement construction)
Adrian Fischer
info at aussiebidder.com
Wed Oct 11 23:47:00 CDT 2000
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,
More information about the thelist
mailing list