[cfaussie] RE: SQL help required

[WALTERS Scott]

Title: Message

Cut that, didn't read the question first.

 

sry.

-----Original Message-----
From: WALTERS Scott
Sent: Tuesday, 3 June 2003 4:33 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: SQL help required

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 required

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/

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.

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