CGI.Cert_Subject

[alligatorwoman]

I need to isolate the CN data from the Cert_Subject string. the CN field has
the name and unique id or email for the user. I grab this string and dump it
into a variable but then i need to compare the CN section to a database field,
how can I do this?

*TIA*

[Neculai Macarie]

> I need to isolate the CN data from the Cert_Subject string. the CN field
has

> the name and unique id or email for the user. I grab this string and dump

it

> into a variable but then i need to compare the CN section to a database

field,

> how can I do this?

SELECT fields
FROM users
WHERE database_cn_field = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#variable_with_cn#">

--
<mack />