3 Replies Latest reply on Apr 17, 2008 6:35 AM by Flashdakota

    Insert # into database

    Flashdakota Level 1
      Hi

      I have a problem.
      I have the following
      <cfset newcolor = "000000">

      <cfquery name="UpdateColor" datasource="#application.db#">
      UPDATE tblsites
      SET SBGCOL = '#newcolor#'
      WHERE USERID = #session.userid#
      </cfquery>

      ...HOWEVER, i want to insert a # before posting the color var!

      Please can someone explain how to do this!

      Thanks in advance
      Delon