Hi,
I have a query like
so:
SELECT
distinct(acct_code)
FROM coarext
WHERE cmpy_code = '01'
AND resp_e_mail like '%#request.session.user.username#%'
FROM coarext
WHERE cmpy_code = '01'
AND resp_e_mail like '%#request.session.user.username#%'
values in the
resp_e_mail field might include something like this:
cliftosg
or this:
cliftosg,brownej,smithjh
the value of
#request.session.user.username# is always a single username like
"cliftosg".
the problem with my
query above is that the username "browne" and the username "brownej" will
be selected in the statement if the value of resp_e_mail is "cliftosg,brownej,smithjh".
how can i amend the SQL statement to take this into
account? i need to use listfind() or something but am unsure in
SQL.
thanks.... steve
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
