CFQUERY -- HELP !!!

[kingjjx]

Hi, If I have this as my URL .. sending to .. usercheck.cfm

http://dynamic.dynojet.com/CFML/test_login/user_check.cfm?Username=dan&password=dynojet

what would my cfquery look like in user_check.cfm ???

thanks
-jon

 

[DeZiner]

SELECT username, password
FROM table_name
WHERE username=URL.username
      AND password=URL.password

And I usually check to be sure that my parameter was passed to avoid an error incase some accesses the page directly.

<cfif isDefined(URL.password)>
Do the page
<cfelse>
<cflocation url=&quot;login.cfm&quot;>

DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic