ERROR

Мы сожалеем - хотя мы сделали все возможное: произошла ошибка
Typedatabase
MessageYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near "AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categorie..." at line 5
QuerySELECT (SELECT categories_id FROM categories_description WHERE language_id = 8 AND categories_id = 000) AS cat1, (SELECT categories_id FROM categories_description WHERE language_id = 8 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2, (SELECT categories_id FROM categories_description WHERE language_id = 8 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3, (SELECT categories_id FROM categories_description WHERE language_id = 8 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categories_name FROM categories_description WHERE language_id = 8 AND categories_id = 000) AS cat1name, (SELECT categories_name FROM categories_description WHERE language_id = 8 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name, (SELECT categories_name FROM categories_description WHERE language_id = 8 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name, (SELECT categories_name FROM categories_description WHERE language_id = 8 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4name, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 000) AS cat1url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4url, (SELECT wod_count_products FROM categories WHERE categories_id = 000) AS cat1cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3cnt, (SELECT wod_count_products FROM categories WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4cnt

Author: Scott Millett

Support
Scott Millett is an ASP.NET MVP and lead architect for wiggle.co.uk, an e-commerce company that uses ASP.NET.




8 Ebooks by Scott Millett

Cover of Scott Millett: Professional ASP.NET Design Patterns
Scott Millett: Professional ASP.NET Design Patterns
Professional ASP.NET Design Patterns will show you how to implement design patterns in real ASP.NET applications by introducing you to the basic OOP skills needed to understand and interpret design p …
PDF
English
DRM
€32.99
Cover of Scott Millett: Professional ASP.NET Design Patterns
Scott Millett: Professional ASP.NET Design Patterns
  • Design patterns are time-tested solutions to recurring problems, letting the designer build programs on solutions that have already proved effective
  • Provides developers with more th …
EPUB
English
€32.99
Cover of Scott Millett: NHibernate with ASP.NET Problem Design Solution
Scott Millett: NHibernate with ASP.NET Problem Design Solution
This Wrox Blox demonstrates how to start using NHibernate in line business applications using ASP.NET and VB.NET. Using NHibernate will speed up your application development by removing the need to b …
EPUB
English
DRM
€0.99
Cover of Scott Millett & Nick Tune: Patterns, Principles, and Practices of Domain-Driven Design
Scott Millett & Nick Tune: Patterns, Principles, and Practices of Domain-Driven Design
Methods for managing complex software construction following the practices, principles and patterns of Domain-Driven Design with code examples in C# This book presents the philosophy of Domain-Driven …
PDF
English
DRM
€39.99
Cover of Scott Millett & Nick Tune: Patterns, Principles, and Practices of Domain-Driven Design
Scott Millett & Nick Tune: Patterns, Principles, and Practices of Domain-Driven Design
Methods for managing complex software construction following the practices, principles and patterns of Domain-Driven Design with code examples in C# This book presents the philosophy of Domain-Driven …
EPUB
English
€39.99
Cover of Scott Millett & Jerrel Blankenship: Pro Agile .NET Development with SCRUM
Scott Millett & Jerrel Blankenship: Pro Agile .NET Development with SCRUM
Pro Agile .NET Development with SCRUM guides you through a real-world ASP.NET project and shows how agile methodology is put into practice. There is plenty of literature on the theory behind agile me …
PDF
English
€52.99
Cover of Scott Millett: The Accidental CIO
Scott Millett: The Accidental CIO
An indispensable guide showing IT leaders the way to balance the needs of innovation and exploration with exploitation and operational reliability Many books on modern IT leadership focus solely on s …
PDF
English
DRM
€25.99
Cover of Scott Millett: The Accidental CIO
Scott Millett: The Accidental CIO
An indispensable guide showing IT leaders the way to balance the needs of innovation and exploration with exploitation and operational reliability Many books on modern IT leadership focus solely on s …
EPUB
English
DRM
€25.99