postgresql connection syntax error at or near “:”
public int RoleTempInsertWithRoleID(string[] connectionValues, ROLEDTO oROLEDTO) { int roleId = 0; int maxRoleId = 0; int maxTempRoleId = 0; int result = 0; try { using (DBConnector oCloudConnection = new DBConnector(connectionValues[0], Convert.ToInt32(connectionValues[1]))) { StringBuilder varname1 = new StringBuilder(); varname1.Append(“SELECT MAX(ROLE_ID) AS MAX_ROLE_ID n”); varname1.Append(“FROM SROLE n”); varname1.Append(“WHERE 1=1 n”); varname1.Append(“AND COMPANY_ID=?COMPANY_ID n”); varname1.Append(“AND PRODUCT_ID=?PRODUCT_ID;”); oCloudConnection.CommandText […]