like and not like

[vlad123]

Hi! I have 2 lists with urls. I want to delete all records from a table (link) if link.url like list1.column(0)and not like list2.column(0).
so, to delete all that are in the first list but not in the second list.
I have this:
strsql = "delete * from dbo_link where dbo_link.url like '*" & CStr(Me.lstExclude.Column(0)) & "*'and not like '*" & CStr(Me.lstInclude.Column(0)) & "*';"
DoCmd.RunSQL strsql
Error: syntax error. missing operator in query expression.

the value from Watches (this is the case when the link is in both lists) is this:

"delete * from dbo_link where dbo_link.url like '*

http://finance.yahoo.com/q/is?s=F&annual*'

and not like '*

http://finance.yahoo.com/q/is?s=F&annual*'"

do you have any sugestions?!

 

[PHV]

strsql = "DELETE FROM dbo_link WHERE dbo_link.url LIKE '*" & Me!lstExclude.Column(0) & "*' AND dbo_link.url NOT LIKE '*" & Me!lstInclude.Column(0) & "*'"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vlad123]

Thank you very much! I am a beginner so sometimes I guess I need "glasses" for finding the solution.