Hey all,
I have an app that is running great. User enters a code into a form field, and
it checks the db to see if it's valid. If not they can't move on. Problem is
that now the customer wants to be able to enter either the 2-5 character code
OR the long name. For instance, you could enter AS
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
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 bcc9...@gmail.com wrote:
You should move your check into the WHERE clause of the query (WHERE orgname
=
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 sor...@gmail.com 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
Yeah, I had a brain fart. This fixed it:
cfsetting showdebugoutput=false
!--- Set the orgname to blank first ---
cfparam name=form.orgname default=
!--- Query the organizations table for all of the org names ---
cfquery name=checkName datasource=#request.dataSource#
SELECT orgname,
5 matches
Mail list logo
