Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'SUBTYP_1'.
|
|
The error occurred in C:/home/sngtactical.com/wwwroot/vendcategory.cfm: line 274
Called from C:/home/sngtactical.com/wwwroot/vendcategory.cfm: line 264
Called from C:/home/sngtactical.com/wwwroot/vendcategory.cfm: line 248
Called from C:/home/sngtactical.com/wwwroot/vendcategory.cfm: line 1
Called from C:/home/sngtactical.com/wwwroot/router.cfm: line 12
Called from C:/home/sngtactical.com/wwwroot/vendcategory.cfm: line 274
Called from C:/home/sngtactical.com/wwwroot/vendcategory.cfm: line 264
Called from C:/home/sngtactical.com/wwwroot/vendcategory.cfm: line 248
Called from C:/home/sngtactical.com/wwwroot/vendcategory.cfm: line 1
Called from C:/home/sngtactical.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 |
sngtacticalcumulus |
VENDORERRORCODE |
207 |
SQL |
SELECT distinct [DEPT] ,typ ,subtyp as SUBTYP_1 ,web_url FROM tb_ecomm_taxonomy
where DEPT = 'Personal Defense' and typ = 'Knives'
and SUBTYP_1 <> 'EMPTY'
and SUBTYP_2 IS NULL and web_url > ''
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
3.147.104.120 |
Referrer |
|
Date/Time |
23-Apr-24 11:38 AM |
|