I have a SQL database with a field labeled Revision.  It is set to bit.

 

I have created the following in a cfform.

 

<tr>

            <td width="22%"><b>Revision?</b>&nbsp;&nbsp;</td>

            <td width="44%">

                        <cfset IsChecked=masters.revision>

                        <cfinput type="checkbox"

                                    name="revision"

                                    value="#masters.revision#"

                                    checked="#IsChecked#">

            </td>

--------------------------------------------------------------------------------------------------------------------------

My problem is with the following for updating the information in the database.

 

<!--- Edit or Update? --->

<cfif IsDefined("Form.masterschedule_uuid") Is True>

            <cfupdate datasource="actevents" tablename="masteschedule">

<cfelse>

            <cfinsert datasource="actevents" tablename="masteschedule">

</cfif>

<cflocation url="">

 

 

When I go back to view the information, the revision field is not set to 1 or 0.

 

What am I doing wrong?

 

George Quade

[EMAIL PROTECTED]

Reply via email to