parameterized-query
Is this a correct way to allow wildcard search for a user?
Given a textbox name for example, the user requirement wants to be able to do a wildcard search (such as contains, starts with, ends with).[详细]
2023-04-13 03:11 分类:问答How do I pass guid in parameterised query?
My current best code is: string delNonQuery = \"DELETE FROM \" + Settings.DataSource + \" WHERE @keycolumn=@keyuid\";[详细]
2023-03-24 09:41 分类:问答error with SqlCe Parameters
I have made MANY parameterised queries in my time on this lovely planet, and none have thrown an error like this... WTFudge?!?![详细]
2023-03-23 10:21 分类:问答Fixing SQL injection forms in a big asp.net C# web application
I have to fix a project that is vulnerable to SQL injection. All the forms in every page on the project do not use parametrized query but simply string query.[详细]
2023-03-16 23:22 分类:问答How to iterate and dynamically parameterize JPQL queries?
I have a page with simple ID as a URL param. What I do now is run a query to return a number of associated entities that basically need to get iterated over: I need a schedule of games to be returned[详细]
2023-03-15 16:57 分类:问答Passin Bit field parameters to stored procedure using Entity Framework 4.1
All, I\'ve been stuck on the following issue all day. I\'m trying to make a parametrized stored procedure call that includes three bit field parameters. The exception I keep encountering is \"Error c[详细]
2023-03-13 04:30 分类:问答Preventing SQL Injection in C
I am writing a C application that takes some user input and does a few database queries. I am well aware of the risks here of SQL injection and wish to prevent it.[详细]
2023-03-02 00:52 分类:问答Python sqlite3 parameterized drop table
I have a problem with dropping sqlite3 table in python. I am using standard sqlite3 module. self.conn = sqlite3.connect(...)[详细]
2023-02-23 14:04 分类:问答How can I run a SQL Query with a list of String values using the "WHERE [columnname] IN [values]" format in ASP.NET?
I have a SQL query I\'m running in an ASP.NET page. The final parsed SQL needs to contain a list of string values in the WHERE [columnname] IN [values] format. For example, the final query might look[详细]
2023-02-16 03:12 分类:问答about parameterized query
Q: Please , i want to ask ,how to perform a query(select statement) us开发者_如何学编程ing a parametrized query in Informix database ,with a simple example.[详细]
2023-02-14 08:34 分类:问答