The following worked for me:
<HTML>
<HEAD>
<TITLE>Retrieving Employee Data Based on Criteia from Form</TITLE>
</HEAD>
<cfset username = 'B'>
<BODY>
<CFQUERY NAME="GetEmployees" DATASOURCE="ActionItems">
SELECT userID, userName, fullName, email, password
FROM users...
I just tried this on my database and it worked!
SELECT emplid, first_name_srch,last_name_srch
FROM empl_personal_data
WHERE
(last_name_srch NOT LIKE 'ABBOTT')
AND (first_name_srch LIKE '%B%'
OR last_name_srch LIKE '%B%')
ORDER BY Last_Name_srch
I know because the first time I did
SELECT...
My JavaScript Unleashed book has:
You can give focus to a window in two ways:
1. Indirectly, by giving focus to an object in the window
example myWindow.document.myForm.myInput.focus();
2. Directly, by giving focus to the window
example myWindow.focus()
Hope this is of some help.
Bill
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.