python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - prepared-statement

Is it possible to bind variables in select clause?

Can we bind variables in select clause like this: String sql = "select ? name from user"; PreparedStatement = conn.prepareStatement(sql); pstmnt.setString(1, "name"); or can we bi...
test-img

user1167753

java

sql

prepared-statement

Votes: 0

Answers: 1

Latest Answer

You can bind variables wherever you want. But you cannot bind identifier names e.g. database, table and column names (which is what you seem to be trying to do). The result of your sample code will lo...
test-img

Salman A

how to set concatenated string parameter in preparedstatement

I have the following java code: 1- String sql="select * from mytable where params='file_name=?,report_name=?'" 2- stmt.setString(1, fileName); 3- stmt.setString(2, reportName); I get the fo...
test-img

user1167753

java

sql

oracle

jdbc

prepared-statement

Votes: 0

Answers: 1

Latest Answer

Take the bind parameters out of the string literal: String sql="select * from mytable where params='file_name=' || ? || ',report_name=' || ?" Or, create a single bind parameter and pass in ...
test-img

MT0

Converting a Json to include prepared statements for security. Just getting [] or undefined

Someone mentioned on a previous post that I need to use prepared statements in my php to protect from attacks. I'm trying to convert my documents but it seems to be breaking everything. Here is my ori...
test-img

Niwa

php

sql

json

security

prepared-statement

Votes: 0

Answers: 1

Latest Answer

you are binding i but you never declare it $idnum = $_POST['number'] // declare this below session_start it's much cleaner to see if ($stmt = $db->prepare("SELECT * FROM db WHERE id= :id &qu...
test-img

Emma Marshall

Clear prepared statement cache in AWS Keyspaces on table definition change

Is there an easy way to clear prepared statement cache in AWS Keyspaces? Traditional tricks used on manual cassandra nodes cannot be used in the AWS Cloud. In Cassandra, if the table definition change...
test-img

zenbeni

cassandra

prepared-statement

amazon-keyspaces

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs