Yes. You are checking on checkcode.cfm. That is the page that needs to be modified.
Brian Cain On Feb 12, 2013, at 7:47 PM, Bruce Sorge <[email protected]> wrote: > > The think is that the check is not done when they post, it's done when they > enter the code, then shift the focus form the form field. > > Bruce > On Feb 12, 2013, at 8:42 PM, Brian Cain <[email protected]> wrote: > >> >> You should move your check into the WHERE clause of the query (WHERE >> orgname = '#orgname#' or orglongname ='#orgname#') and change the >> listfindnocase condition to checkname.recordcount GT 0. There is no need to >> return the entire record set and then convert it to a list. Get rid is the >> orgnamelist variable all together. That is a waste of resources. >> >> To be on the safe side you should also use cfqueryparam to wrap the >> variables in your SQL statement to prevent SQL injection attacks. >> >> Brian Cain > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
