[cfaussie] Re: SQL help required

[Mark Woods]

this should only get exact username matches...

SELECT  distinct(acct_code)
FROM  coarext
WHERE cmpy_code = '01'
AND ',' + resp_e_mail + ',' like '%,#request.session.user.username#,%'
note: assuming you are using Access or SQL Server, replace the + with || 
for most other databases

Mark


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#%'
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/


---
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/