为什么查询错误??????????????? [英] Why query error؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟
问题描述
SELECT Excel。[شمارهمبدا] AS [شمارهمبداField],First(Excel。[نوعتماس])AS [نوعتماسField],Count(Excel。[شمارهمبدا])AS NumberOfDups FROM Excel GROUP BY Excel。 [ممارهمبدا],Excel。[نوعتماس] HAVING(Excel。[شمارهمبدا]喜欢'%'+ textbox4.text +')AND((First(Excel。[نوعتماس]))='پیامکوتاه')
我尝试了什么:
请帮帮我? ??
为什么查询错误?????????????
如何使用赞'%'+ textbox4.text +'in查询whitout错误??????????
SELECT Excel.[شماره مبدا] AS [شماره مبدا Field], First(Excel.[نوع تماس]) AS [نوع تماس Field], Count(Excel.[شماره مبدا]) AS NumberOfDups FROM Excel GROUP BY Excel.[شماره مبدا], Excel.[نوع تماس] HAVING (Excel.[شماره مبدا] like '%"+ textbox4.text +"') AND ((First(Excel.[نوع تماس]))='پیام کوتاه') "
What I have tried:
please help me ????
Why Query error؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟
how to use Like'%"+textbox4.text+"' in query whitout errore??????????
推荐答案
首先,不要这样做!永远不要连接字符串来构建SQL命令。你对意外或故意的SQL注入攻击持开放态度,这可能会破坏整个数据库。请使用参数化查询。
然后,它可能只是匹配你的方块的情况括号...
First off, don't do that! Never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead.
Then, it's probably just a case of matching up your square brackets...
AND ((First(Excel.[نوع تماس]))='پیام کوتاه') "
^ ^
| |
Where are the closing brackets?
这篇关于为什么查询错误???????????????的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!