sitedatabase Object
(
[_tables] => Array
(
[Product] => sitedrivertable Object
(
[_database] => sitedatabase Object
(
[_tables] => Array
(
)
[_columns] => Array
(
)
[_metaschema_prefix] => richdb_
[_host] => localhost
[_username] => root
[_password] =>
[_dbname] => ls_lms_LIVE
[_conn] => Resource id #36
[_logQueriesToArray] =>
)
[_table_name] => Product
[_id_column_name] => ProductID
[_column_names] => Array
(
[0] => ProductID
[1] => Name
[2] => Tagline
[3] => Description
[4] => ListPrice
[5] => MemberPrice
[6] => Display
[7] => Featured
[8] => ProductCategoryID
[9] => DisciplineID
[10] => FileGroupID
[11] => AccountCideID
[12] => VATCodeID
[13] => AccountCodeID
[14] => Price1Name
[15] => Price2Name
[16] => Price3Name
[17] => Price1
[18] => Price2
[19] => Price3
[20] => Shipping
[21] => MaxQuantity
[22] => Price4Name
[23] => Price5Name
[24] => Price6Name
[25] => Price7Name
[26] => Price8Name
[27] => Price9Name
[28] => Price10Name
[29] => Price11Name
[30] => Price12Name
[31] => Price13Name
[32] => Price4
[33] => Price5
[34] => Price6
[35] => Price7
[36] => Price8
[37] => Price9
[38] => Price10
[39] => Price11
[40] => Price12
[41] => Price13
)
[_column_types] =>
[_column_value_cache] => Array
(
)
[_strDefinition] =>
)
[ProductCategory] => sitedrivertable Object
(
[_database] => sitedatabase Object
(
[_tables] => Array
(
[Product] => sitedrivertable Object
(
[_database] => sitedatabase Object
(
[_tables] => Array
(
)
[_columns] => Array
(
)
[_metaschema_prefix] => richdb_
[_host] => localhost
[_username] => root
[_password] =>
[_dbname] => ls_lms_LIVE
[_conn] => Resource id #36
[_logQueriesToArray] =>
)
[_table_name] => Product
[_id_column_name] => ProductID
[_column_names] => Array
(
[0] => ProductID
[1] => Name
[2] => Tagline
[3] => Description
[4] => ListPrice
[5] => MemberPrice
[6] => Display
[7] => Featured
[8] => ProductCategoryID
[9] => DisciplineID
[10] => FileGroupID
[11] => AccountCideID
[12] => VATCodeID
[13] => AccountCodeID
[14] => Price1Name
[15] => Price2Name
[16] => Price3Name
[17] => Price1
[18] => Price2
[19] => Price3
[20] => Shipping
[21] => MaxQuantity
[22] => Price4Name
[23] => Price5Name
[24] => Price6Name
[25] => Price7Name
[26] => Price8Name
[27] => Price9Name
[28] => Price10Name
[29] => Price11Name
[30] => Price12Name
[31] => Price13Name
[32] => Price4
[33] => Price5
[34] => Price6
[35] => Price7
[36] => Price8
[37] => Price9
[38] => Price10
[39] => Price11
[40] => Price12
[41] => Price13
)
[_column_types] =>
[_column_value_cache] => Array
(
)
[_strDefinition] =>
)
)
[_columns] => Array
(
)
[_metaschema_prefix] => richdb_
[_host] => localhost
[_username] => root
[_password] =>
[_dbname] => ls_lms_LIVE
[_conn] => Resource id #36
[_logQueriesToArray] =>
)
[_table_name] => ProductCategory
[_id_column_name] => ProductCategoryID
[_column_names] => Array
(
[0] => ProductCategoryID
[1] => Name
[2] => Filename
[3] => FileContents
)
[_column_types] =>
[_column_value_cache] => Array
(
)
[_strDefinition] =>
)
)
[_columns] => Array
(
)
[_metaschema_prefix] => richdb_
[_host] => localhost
[_username] => root
[_password] =>
[_dbname] => ls_lms_LIVE
[_conn] => Resource id #36
[_logQueriesToArray] =>
)
getSingleValue unable to parse:
SELECT COUNT(*) FROM Product WHERE ProductCategoryID= and ProductID<> AND Display<>'N'