Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

1.3.2数据查询失效 #39

Closed
Vincentzzg opened this issue Nov 25, 2016 · 2 comments
Closed

1.3.2数据查询失效 #39

Vincentzzg opened this issue Nov 25, 2016 · 2 comments

Comments

@Vincentzzg
Copy link

今天更新插件的时候升级到了1.3.2,发现数据库操作全都失效了。看了下楼主的提交更新才明白了又是之前那个''的问题。
针对这种 NSString *sqlString = @"SELECT * FROM ':tableName' WHERE conversationId = ':conversationId' ORDER BY messageTime DESC limit ':index',':count'";
语法,前面带:冒号的参数都增加了'',查询OK了
但是
NSArray *recordList = [self.contactInfoTable findAllWithKeyName:@"shortName" value:shortName error:&error];
这种查询又失效了,点进去看了一下,分类里面参数楼主没有加''
2016-11-25 4 38 22

这里似乎又回到了1.3.0的缺少''语法问题

之前的问题 #37 就是这个问题
数据库我不熟,语法也不太懂,只是测试出来是这个问题,楼主看下

@Vincentzzg
Copy link
Author

我又问了下后台的同事,说是字符串类型的参数必须加''

@casatwy
Copy link
Owner

casatwy commented Nov 25, 2016 via email

@casatwy casatwy closed this as completed Nov 25, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants