5 Replies Latest reply on Feb 11, 2008 11:04 AM by Newsgroup_User

    common error in CF & SQL

    masoud_amen
      Hi.when I try to delete the last record I've got this error:
      Error Executing Database Query.
      [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'undefined'.

      The error occurred in E:\www\Copy of mymol-old\actions\actCustomizeSub.cfm: line 70

      68 : dbo.tbl_#tableName#.mymol_sub_category_id = #url.molTopic# AND
      69 : dbo.tbl_#tableName#.mymol_sub_subcategory_id = #x#
      70 : ORDER BY dbo.tbl_#tableName#.mymol_sub_subcategory_order
      71 : </CFQUERY>
      72 :



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

      SQL SELECT mymol_sub_subcategory_id FROM dbo.tbl_myOffice_sub WHERE dbo.tbl_myOffice_sub.mymol_sub_site_id = 830 AND dbo.tbl_myOffice_sub.mymol_sub_section = 3 AND dbo.tbl_myOffice_sub.mymol_sub_category_id = 18 AND dbo.tbl_myOffice_sub.mymol_sub_subcategory_id = undefined ORDER BY dbo.tbl_myOffice_sub.mymol_sub_subcategory_order
      DATASOURCE MOL_PORTAL
      VENDORERRORCODE 207
      SQLSTATE 42S22

      I'm not sure but maybe its because of the empty ColdFusion query.If it is so how can I fix it?plz help me with that.
      thank u.