Alex Rivera | Logout

Questions tagged prepared-statement

51 questions · page 1 of 2

Sort by: Newest Votes Active
24
votes
7
answers

PDO error: SQLSTATE[HY000]: General error: 2031

php mysql pdo prepared-statement
asked 2013-06-24T11:38:20.997
18
votes
3
answers

mysqli_stmt::bind_param(): Number of elements in type definition string doesn't match number of bind variables

php mysql mysqli prepared-statement
asked 2013-06-21T13:58:41.327
8
votes
3
answers

Should I use mysqli_real_escape_string or should I use prepared statements?

php mysqli prepared-statement mysql-real-escape-string
asked 2013-04-03T11:36:57.397
13
votes
2
answers

How to see PreparedStatement's SQL string?

java jdbc prepared-statement
asked 2013-03-21T16:27:02.340
24
votes
4
answers

Missing STOPKEY per partition in Oracle plan for paging by local index

sql oracle-database prepared-statement partitioning sql-execution-plan
asked 2013-03-12T09:32:26.120
13
votes
2
answers

Prepared Statement on Postgresql in Rails

sql ruby-on-rails ruby-on-rails-3 postgresql prepared-statement
asked 2012-12-10T17:05:14.233
13
votes
1
answers

getGeneratedKeys() after PreparedStatement.executeBatch()

java sql-server jdbc prepared-statement
asked 2012-11-30T08:57:17.270
9
votes
1
answers

Is it possible to use bind_param for ORDER BY?

php mysqli sql-order-by prepared-statement bindparam
asked 2012-08-18T18:07:21.650
16
votes
4
answers

How can I securely allow user defined SQL queries?

sql sql-injection prepared-statement
asked 2012-07-12T23:07:05.987
71
votes
4
answers

How to use a tablename variable for a java prepared statement insert

java sql variables dynamic prepared-statement
asked 2012-07-03T13:36:51.773
43
votes
2
answers

SQLite/C# Connection Pooling and Prepared Statement Confusion

c# sqlite prepared-statement connection-pooling
asked 2012-05-22T14:11:45.463
37
votes
5
answers

PDO were rows affected during execute statement

php mysql pdo prepared-statement
asked 2012-05-09T19:05:10.930
8
votes
2
answers

mySQLi prepared statement unable to get_result()

php mysqli prepared-statement
asked 2012-05-05T22:31:54.657
9
votes
3
answers

JPA (Hibernate) Native Query for Prepared Statement SLOW

java sql hibernate jpa prepared-statement
asked 2012-01-20T22:53:06.003
9
votes
1
answers

PDO, Mysql and native prepared statements

php mysql pdo prepared-statement
asked 2011-11-28T13:22:01.660
251
votes
10
answers

How can prepared statements protect from SQL injection attacks?

sql security sql-injection prepared-statement
asked 2011-11-24T23:17:08.220
10
votes
1
answers

Why affected_rows always returns -1?

php mysqli prepared-statement rows-affected
asked 2011-11-23T13:38:14.233
22
votes
3
answers

JDBC Prepared Statement . setDate(....) doesn't save the time, just the date.. How can I save the time as well?

java jdbc prepared-statement
asked 2011-07-29T13:47:15.130
28
votes
3
answers

using JDBC preparedStatement in a batch

java jdbc batch-file prepared-statement
asked 2011-07-28T14:31:18.910
98
votes
12
answers

Can parameterized statement stop all SQL injection?

sql prepared-statement sql-injection code-injection exploit
asked 2011-07-22T05:31:11.460
27
votes
2
answers

When to close Prepared Statement

php prepared-statement
asked 2011-07-08T22:52:29.863
9
votes
5
answers

When should a java PreparedStatement be closed?

java prepared-statement
asked 2011-06-15T04:35:04.197
40
votes
3
answers

Java PreparedStatement retrieving last inserted ID

java mysql jdbc prepared-statement
asked 2011-04-01T12:11:48.843
15
votes
6
answers

Oracle JDBC and Oracle CHAR data type

oracle-database jdbc types char prepared-statement
asked 2011-03-16T22:59:28.643
14
votes
1
answers

Why does mysqli_stmt_num_rows() always return 0?

php mysqli prepared-statement
asked 2011-02-16T12:11:48.663
10
votes
3
answers

C# Prepared Statements - @ sign (at / strudel sign) queries

c# sql sql-server-2005 prepared-statement email-validation
asked 2011-02-10T08:32:45.613
10
votes
4
answers

Do i need to sanitize input if using prepared PHP/MySQL queries?

php mysqli prepared-statement sanitization
asked 2011-01-20T20:10:14.503
12
votes
3
answers

warning:mysql_fetch_array() expects parameter 1 to be resource, object given

php mysqli prepared-statement
asked 2011-01-08T17:02:50.373
9
votes
3
answers

What do the questions marks in SQL prepared statements mean?

php prepared-statement
asked 2011-01-08T06:39:28.710
16
votes
3
answers

bind_result into an array PHP mysqli prepared statement

php arrays mysqli prepared-statement
asked 2010-12-21T07:13:53.537
12
votes
8
answers

Call to a member function prepare() on a non-object PHP Help

php mysqli prepared-statement
asked 2010-12-16T17:09:22.593
28
votes
1
answers

Binding params for PDO statement inside a loop

php foreach pdo prepared-statement
asked 2010-11-13T20:27:15.640
16
votes
5
answers

Retrieve (or simulate) full query from PDO prepared statement

php pdo prepared-statement
asked 2010-09-20T18:54:40.067
23
votes
3
answers

How do I set a full date & time sql using java, and not just the date?

java mysql datetime jdbc prepared-statement
asked 2010-09-09T14:36:50.833
53
votes
7
answers

Variable column names using prepared statements

java sql jdbc prepared-statement
asked 2010-06-28T20:43:10.370
11
votes
6
answers

Can I get the full query that a PreparedStatement is about to execute?

java mysql prepared-statement
asked 2010-06-14T15:32:01.137
44
votes
5
answers

Using prepared statements with JDBCTemplate

java spring jdbc prepared-statement jdbctemplate
asked 2010-06-07T12:05:04.070
22
votes
1
answers

PreparedStatement and setTimestamp in oracle jdbc

java oracle-database jdbc timestamp prepared-statement
asked 2010-05-18T14:30:37.513
18
votes
4
answers

How do I use pdo's prepared statement for order by and limit clauses?

php pdo prepared-statement
asked 2010-04-21T14:04:31.710
196
votes
7
answers

Get query from java.sql.PreparedStatement

java jdbc prepared-statement
asked 2010-04-21T13:21:13.333
11
votes
2
answers

Does the MySQLdb module support prepared statements?

python mysql prepared-statement
asked 2010-03-11T11:37:25.300
30
votes
2
answers

Which should I close first, the PreparedStatement or the Connection?

java jdbc connection prepared-statement
asked 2010-03-02T14:30:46.867
10
votes
5
answers

PHP PDO: how does re-preparing a statement affect performance

php mysql pdo prepared-statement
asked 2010-01-25T13:24:50.357
27
votes
4
answers

Use of PDO in classes

php mysql pdo prepared-statement
asked 2010-01-12T06:57:05.130
13
votes
3
answers

PHP- inserting binary data in mysql using prepared statements

php mysql prepared-statement
asked 2009-11-17T10:24:06.713
65
votes
5
answers

Is there a way to retrieve the autoincrement ID from a prepared statement

java mysql prepared-statement auto-increment
asked 2009-09-03T22:04:26.783
52
votes
5
answers

Python MYSQL update statement

python mysql mysql-python prepared-statement
asked 2009-08-20T16:30:31.337
26
votes
2
answers

Mysqli Prepare Statement - Returning False, but Why?

php mysqli prepared-statement
asked 2009-08-02T20:48:35.597
9
votes
1
answers

mysqli_real_escape_string AND prepared statements?

php mysqli prepared-statement
asked 2009-07-22T01:03:49.527
10
votes
7
answers

How can I put the results of a MySQLi prepared statement into an associative array?

php mysqli prepared-statement associative-array
asked 2009-06-14T23:34:37.447
page 1 of 2 Next →