Basic CF Comparison Expression Question 1

[rvancleef]

Hello,

I have some ASP background, but now am trying to work in Cold Fusion. From this query I am getting a recordset that contains the field .KeepPrivate

<cfquery name=&quot;student&quot; datasource=&quot;#request.mygordon#&quot;>
SELECT * FROM student WHERE id = '#gordon_id#'
</cfquery>

I then need to present the output to the end user based on the value of .KeepPrivate:

<cfif student.KeepPrivate contains the charactor 'Y'>
<td>N/A</td>
<cfelse>
<td>#student.HomeStreet1#</td>
<cfendif>

In ASP I would use &quot;If Instr(rs.KeepPrivate,'Y') Then&quot; but this is of course Cold Fusion. Any help would be tremendously appreciated!!!

 

[ecobb]

I believe it would be:

<cfif student.KeepPrivate contains &quot;Y&quot;>
<td>N/A</td>
<cfelse>
<td>#student.HomeStreet1#</td>
</cfif>



Hope This Helps!

Ecobb
- I hate computers!

 

[rvancleef]

Perfect!!!

Works like a Charm!