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="student" datasource="#request.mygordon#">
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 "If Instr(rs.KeepPrivate,'Y') Then" but this is of course Cold Fusion. Any help would be tremendously appreciated!!!
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="student" datasource="#request.mygordon#">
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 "If Instr(rs.KeepPrivate,'Y') Then" but this is of course Cold Fusion. Any help would be tremendously appreciated!!!