whats wrong with my sql?

[loofa]

ok, is what i'm doing here is insert a few fields into a table, which works
fine. then i'm trying to query the table using the same email address that i
used to make the new row to get the quto number made in that row "userid"
now its not giving my any errors but when i pass the variable "id" through the
url its ending up with nothing being in it "id= "
that must meen that nothing is being found in the query..... why?
Thank you for taking a look,
Tommy

<cfif not isdefined("form.email")>
<cflocation url="login.cfm">
</cfif>
<cfinsert datasource="c8k" tablename="useraccounts">
<cfquery name="getid" datasource="c8k">

select userid
from useraccounts
where '%#form.email#%' = email

</cfquery>
<cflocation url="setupcomplete.cfm?id=#getid.userid#">

[mxstu]

Originally posted by: loofa
select userid
from useraccounts
where '%#form.email#%' = email

You shouldn't be using percent signs "%" here. In most databases the "%" sign
is used as a wildcard to find partial matches on text fields. It is used in
conjunction with the LIKE operator, not the equals "=" operator. For example,
you might use a wildcard to find records in a table where the last name begins
with the letters "MAL", like ....

SELECT FirstName,LastName FROM myTable WHERE LastName LIKE 'MAL%'

Since you want to retrieve the record where the email matches exactly, you
should use the equals operator "=" (without the percent signs). Note:
Typically, the comparison value is placed on the right hand side of the
operator not the left.

select userid
from useraccounts
where email = '#form.email#'

Originally posted by: loofa
ok, is what i'm doing here is insert a few fields into a table, which works
fine. then i'm trying to query the table using the same email address that i
used to make the new row to get the quto number made in that row "userid"
now its not giving my any errors but when i pass the variable "id" through the
url its ending up with nothing being in it "id= "
that must meen that nothing is being found in the query


You should probably add some validation/error handling to your page to ensure
that A) the email address is not added more than once and B) an error message
is displayed if the "getid" query returns no information.

Good Luck

[loofa]

thanks

[loofa]

your a genious