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.