Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: jasonlhoward
- Order by date
-
Select statement error
Try... SQL=" Select * From tbl_customer_support " SQL = SQL & " where op= '" & operator & "'" if operator is a string. If it's numerical then your code would work if it contained valid data. Always, always validate data before using it. :-) -Jason- jasonlhoward
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Always use Replace with Strings?
Hi Steve, I don't know what language you're using but I wrote this little vbscript function that I run on all user-entered data that will be used by SQL. It will make sure that exactly two single quotes exist where as many as 100 existed previously but you can change this to a more sane level...- jasonlhoward
- Post #2
- Forum: Microsoft SQL Server: Programming
-
full-text search condition contained noise word(s)
I am using a SQL full-text index search and I'm getting the ADO error: "ADODB.Fields error '800a0cc1' ... Item cannot be found in the collection corresponding to the requested name or ordinal." The reason I'm getting the ADO error is because SQL Server is producing the message...- jasonlhoward
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
