# DB query escaping characters problem

**URL:** <https://forum.kirupa.com/t/db-query-escaping-characters-problem/304729>\
**Category:** flash\
**Created:** [February 12, 2010, 4:46pm UTC](https://forum.kirupa.com/t/db-query-escaping-characters-problem/304729 "2010-02-12T16:46:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![spectator](https://avatars.discourse-cdn.com/v4/letter/s/47e85d/32.png) [@spectator](https://forum.kirupa.com/u/spectator)\
**Post date:** [February 12, 2010, 4:46pm UTC](https://forum.kirupa.com/t/db-query-escaping-characters-problem/304729/1 "2010-02-12T16:46:55Z")

</div>

Hello,  
I am having problems with “Unrecognized token with SQL Lite”. The only thing that I am doing is this:

```auto
var addNew:String = 'INSERT INTO table (locations, typeString) VALUES ("'+_tempLocationAr*+'","'+_tempTypeStrAr*+'" )';

```

The problem is in the \_tempTypeStrAr, but I don’t know what kind of character can cause it. \_tempTypeStrAr consists of strings from a textField that are entered, it is the same situation in the \_tempLocationAr. Have you encountered such error before?  
Thank you in advance 🙂