Ask Your Question

Revision history [back]

Query for properties with an active status

I'm running a query for active listings, but receiving an error.

Query: (L_Status=Active)

ReplyCode 20206 (INVALID_QUERY_SYNTAX); ReplyText: An invalid value was given for a calculated field [DMQLtoSQL.getSubquery: Calculated field query value cannot be parsed into constituant parts: L_Status]. Error in the application.

Query for properties with an active status

I'm running a query for active listings, but receiving an error.

Query: (L_Status=Active)

ReplyCode 20206 (INVALID_QUERY_SYNTAX); ReplyText: An invalid value was given for a calculated field [DMQLtoSQL.getSubquery: Calculated field query value cannot be parsed into constituant parts: L_Status]. Error in the application.

Query for properties with an active status

I'm running a query for active listings, but receiving an error.

Query: (L_Status=Active)

ReplyCode 20206 (INVALID_QUERY_SYNTAX); ReplyText: An invalid value was given for a calculated field [DMQLtoSQL.getSubquery: Calculated field query value cannot be parsed into constituant parts: L_Status]. Error in the application.

I tried (L_StatusCatID=Active) and also received an error:

ReplyCode 20206 (INVALID_QUERY_SYNTAX); ReplyText: Illegal number in range for field [L_StatusCatID] Error in the application.

I noticed if I use a number for L_StatusCatID, then it works. So the query value type is different than it's return type?

Query for properties with an active status

I'm running a query for active listings, but receiving an error.

Query: (L_Status=Active)

ReplyCode 20206 (INVALID_QUERY_SYNTAX); ReplyText: An invalid value was given for a calculated field [DMQLtoSQL.getSubquery: Calculated field query value cannot be parsed into constituant parts: L_Status]. Error in the application.

I tried (L_StatusCatID=Active) and also received an error:

ReplyCode 20206 (INVALID_QUERY_SYNTAX); ReplyText: Illegal number in range for field [L_StatusCatID] Error in the application.

I noticed if I use a number for L_StatusCatID, then it works. So the query value type is different than it's its return type?

Query for properties with an active status

I'm running a query for active listings, but receiving an error.

Query: (L_Status=Active)

ReplyCode 20206 (INVALID_QUERY_SYNTAX); ReplyText: An invalid value was given for a calculated field [DMQLtoSQL.getSubquery: Calculated field query value cannot be parsed into constituant parts: L_Status]. Error in the application.

I tried (L_StatusCatID=Active) and also received an error:

ReplyCode 20206 (INVALID_QUERY_SYNTAX); ReplyText: Illegal number in range for field [L_StatusCatID] Error in the application.

I noticed if I use a number for L_StatusCatID, then it works. So the query value type is different than its return type?type? Is there a way that I can query all the return values for a field?

Query for properties with an active status

I'm running a query for active listings, but receiving an error.

Query: (L_Status=Active)

ReplyCode 20206 (INVALID_QUERY_SYNTAX); ReplyText: An invalid value was given for a calculated field [DMQLtoSQL.getSubquery: Calculated field query value cannot be parsed into constituant parts: L_Status]. Error in the application.

I tried (L_StatusCatID=Active) and also received an error:

ReplyCode 20206 (INVALID_QUERY_SYNTAX); ReplyText: Illegal number in range for field [L_StatusCatID] Error in the application.

I noticed if I use a number for L_StatusCatID, then it works. So the query value type is different than its return type? Is there a way that I can query all the query & return values for a field?field like status?