fixed errors in CF9, and filter out # char in query so query or queries will work