sqlite select in thunderbird db

[faustf]

hi guy

i wanna do a select in thunderbird db for grab only a specific mail 

for  discriminate the mail  i    use  a  address email compleate   myname@gmail.com

but   give me  some  error 

this is a code

$Db_mail = _SQLite_Open($percorso_mail_DB)
                                     _SQLite_GetTable2d($Db_mail,"SELECT * FROM messagesText_content WHERE c3author = "& $mail_find&";", $aRow, $iRows, $iCols)


                                        MsgBox(0,'body?',$aRow[1][1])

                                        _SQLite_Close($Db_mail)
                                        _SQLite_Shutdown()

this is  a erorr code

--> Press Ctrl+Alt+F5 to Restart or Ctrl+Break to Stop
!   SQLite.au3 Error
--> Function: _SQLite_Query
--> Query:    SELECT * FROM messagesText_content WHERE c3author =Sara Olivari <sara.olivari@runner.it>;
--> Error:    near "Olivari": syntax error

C:UsersstefanoDocumentsprogrammazioneSANDRO GESTsandro-gest.au3 (321) : ==> Subscript used with non-Array variable.:
MsgBox(0,'body?',$aRow[1][1])
MsgBox(0,'body?',$aRow^ ERROR

if  i use  a  id table  go correct  but  i dont  can discriminate the mail

 

[faustf]

 --> Press Ctrl+Alt+F5 to Restart or Ctrl+Break to Stop
!   SQLite.au3 Error
--> Function: _SQLite_Query
--> Query:    SELECT * FROM messagesText_content WHERE c3author = eofficecom.com@gmail.com;
--> Error:    near "@gmail": syntax error

[kylomas]

faustf,

Try it like this

$Db_mail = _SQLite_Open($percorso_mail_DB)
_SQLite_GetTable2d($Db_mail,"SELECT * FROM messagesText_content WHERE c3author = " & _sqlite_fastescape($mail_find) & ";", $aRow, $iRows, $iCols)


MsgBox(0,'body?',$aRow[1][1])

_SQLite_Close($Db_mail)
_SQLite_Shutdown()

kylomas

[faustf]

o thankz  kylomas you aare  the best i  know  , perfect  

[jchd]

One thing to be aware of when dealing with SQLite3 DBs created by third-party software (FireFox, Thunderbird, Adobe and so many others): you have no guaranty that the SQLite library (either linked in or as DLL) these programs use is compiled with options compatible with the version that comes along with AutoIt. Also many of they use internal extensions(functions, collations, VFS, ...) overloading standard ones.

Also you never know when a specific DB design is planned to be used in particular ways.

To keep things safe you should refrain to write to those DBs (unless the third-party says it is safe) and prefer usage of the sqlite3.dll that generally comes with each such program. For instance FireFox uses a customized version and a non-standard name for the dll.