Searching question

[Steve Grosz]

I thought I had this correctly, but I guess not. I have:

<cfquery name="Login1" datasource="#DataSource#">
select Usr_pass from members
where Usr_UserName=#form.UserName#
</cfquery>

I'm trying to search through all records in the table for any field that
matches the UserName from the form that submitted it, and then return
the password field. I keep getting a 'unknown column' error instead.

Where did I screw up?

Steve

[dave_jf]

You need to put quotes around the text on the right side of the =.

<cfquery name="Login1" datasource="#DataSource#">
select Usr_pass from members
where Usr_UserName='#form.UserName#'
</cfquery>


HTH,
--Dave

[Steve Grosz]

Duh!! Sheesh, its too early.... Thanks!

dave_jf wrote:

> You need to put quotes around the text on the right side of the =.
>
> <cfquery name="Login1" datasource="#DataSource#">
> select Usr_pass from members
> where Usr_UserName='#form.UserName#'
> </cfquery>
>
>
> HTH,
> --Dave
>