查询联系人数据库的电子邮件时,语法错误 [英] Syntax error when querying contacts database for an email
本文介绍了查询联系人数据库的电子邮件时,语法错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我试图去做通过联系人数据库提供电子邮件地址的搜索,并得到该人的接触ID,如果它发现它,但每次我尝试,我得到一个语法错误
I am trying to do a search through the contacts database for an email address and get the contact ID of that person if it finds it but everytime I try I get a syntax error
01-03 17:15:10.574: E/AndroidRuntime(7907): java.lang.RuntimeException: Unable to start receiver com.app.notifyme.GmailReciever: android.database.sqlite.SQLiteException: near "@gmail": syntax error: , while compiling: SELECT raw_contact_id FROM view_data data WHERE (1) AND ((data1=johnsmith@gmail.com))
01-03 17:15:10.574: E/AndroidRuntime(7907): at android.app.ActivityThread.handleReceiver(ActivityThread.java:2125)
01-03 17:15:10.574: E/AndroidRuntime(7907): at android.app.ActivityThread.access$1500(ActivityThread.java:122)
01-03 17:15:10.574: E/AndroidRuntime(7907): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1196)
01-03 17:15:10.574: E/AndroidRuntime(7907): at android.os.Handler.dispatchMessage(Handler.java:99)
01-03 17:15:10.574: E/AndroidRuntime(7907): at android.os.Looper.loop(Looper.java:137)
01-03 17:15:10.574: E/AndroidRuntime(7907): at android.app.ActivityThread.main(ActivityThread.java:4340)
01-03 17:15:10.574: E/AndroidRuntime(7907): at java.lang.reflect.Method.invokeNative(Native Method)
01-03 17:15:10.574: E/AndroidRuntime(7907): at java.lang.reflect.Method.invoke(Method.java:511)
01-03 17:15:10.574: E/AndroidRuntime(7907): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
01-03 17:15:10.574: E/AndroidRuntime(7907): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
01-03 17:15:10.574: E/AndroidRuntime(7907): at dalvik.system.NativeStart.main(Native Method)
01-03 17:15:10.574: E/AndroidRuntime(7907): Caused by: android.database.sqlite.SQLiteException: near "@gmail": syntax error: , while compiling: SELECT raw_contact_id FROM view_data data WHERE (1) AND ((data1=jtopor0910@gmail.com))
01-03 17:15:10.574: E/AndroidRuntime(7907): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:179)
01-03 17:15:10.574: E/AndroidRuntime(7907): at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:135)
01-03 17:15:10.574: E/AndroidRuntime(7907): at android.content.ContentProviderProxy.query(ContentProviderNative.java:358)
01-03 17:15:10.574: E/AndroidRuntime(7907): at android.content.ContentResolver.query(ContentResolver.java:310)
01-03 17:15:10.574: E/AndroidRuntime(7907): at com.app.notifyme.GmailReciever.createNotification(GmailReciever.java:362)
01-03 17:15:10.574: E/AndroidRuntime(7907): at com.app.notifyme.GmailReciever.onReceive(GmailReciever.java:111)
01-03 17:15:10.574: E/AndroidRuntime(7907): at android.app.ActivityThread.handleReceiver(ActivityThread.java:2118)
这是我的查询
Cursor contact = context.getContentResolver().query(Data.CONTENT_URI,new String[] {Data.RAW_CONTACT_ID},Data.DATA1 + "=" + from,null,null);
什么是错我的语法?它有什么做的 @
?
推荐答案
尝试把引号的邮件,也就是说,在你的方法调用改变第三个参数
Try putting quotes around your email, ie, change the third parameter in your method call to
Data.DATA1 + "='" + from + "'"
这篇关于查询联系人数据库的电子邮件时,语法错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文