Just put the @
symbol in there too. ie:
AND resp_e_mail like '%#request.session.user.username#@%'
--------Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 3 June 2003 4:26 PM
To: CFAussie Mailing List
Subject: [cfaussie] SQL help requiredHi,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:cliftosgor this:cliftosg,brownej,smithjhthe 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/
IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it.
