Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'SUBTYP_1'.
|
|
The error occurred in C:/home/anthemammo.com/wwwroot/vendcategory.cfm: line 274
Called from C:/home/anthemammo.com/wwwroot/vendcategory.cfm: line 264
Called from C:/home/anthemammo.com/wwwroot/vendcategory.cfm: line 248
Called from C:/home/anthemammo.com/wwwroot/vendcategory.cfm: line 1
Called from C:/home/anthemammo.com/wwwroot/router.cfm: line 12
Called from C:/home/anthemammo.com/wwwroot/vendcategory.cfm: line 274
Called from C:/home/anthemammo.com/wwwroot/vendcategory.cfm: line 264
Called from C:/home/anthemammo.com/wwwroot/vendcategory.cfm: line 248
Called from C:/home/anthemammo.com/wwwroot/vendcategory.cfm: line 1
Called from C:/home/anthemammo.com/wwwroot/router.cfm: line 12
|
272 : <cfif Taxonomy.LEVEL EQ 3 and Taxonomy.SUBTYP_1 NEQ ''>
273 : and SUBTYP_1 = '#Taxonomy.SUBTYP_1#'
274 : <cfelse>
275 : and SUBTYP_1 <> 'EMPTY'
276 : </cfif>
|
|
SQLSTATE |
42S22 |
DATASOURCE |
anthemicumulus |
VENDORERRORCODE |
207 |
SQL |
SELECT distinct [DEPT] ,typ ,subtyp as SUBTYP_1 ,web_url FROM tb_ecomm_taxonomy
where DEPT = 'Firearms' and typ = 'Rifles'
and SUBTYP_1 <> 'EMPTY'
and SUBTYP_2 IS NULL and web_url > ''
|
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
3.235.40.122 |
Referrer |
|
Date/Time |
06-Jun-23 02:44 PM |
|