djob66
03-28-2005, 09:55 AM
I have an SQL Stored Procedure that calls different things in a db. Now the issue I'm running into is one of the pieces of info in the db is a "y/n" field, and I need to display that as a checkbox.
<CFSTOREDPROC PROCEDURE="spGetTicket" DATASOURCE="#DS#">
<CFPROCPARAM CFSQLTYPE="cf_sql_interger" VALUE="#Ticket_Number#">
<CFPROCRESULT NAME="qTicket" RESULTSET="1">
</CFSTOREDPROC>
The rest of the fields is elementary, but its that silly checkbox.
<CFIF #qTicket.Escalate# is 1 ????>
<CFINPUT TYPE="checkbox" NAME="Escalated" VALUE=1>
That's as far as I could possibly take it. Any help would be grateful.
<CFSTOREDPROC PROCEDURE="spGetTicket" DATASOURCE="#DS#">
<CFPROCPARAM CFSQLTYPE="cf_sql_interger" VALUE="#Ticket_Number#">
<CFPROCRESULT NAME="qTicket" RESULTSET="1">
</CFSTOREDPROC>
The rest of the fields is elementary, but its that silly checkbox.
<CFIF #qTicket.Escalate# is 1 ????>
<CFINPUT TYPE="checkbox" NAME="Escalated" VALUE=1>
That's as far as I could possibly take it. Any help would be grateful.