Using Java's Statement executeQuery method for getting SQL select results
Questions tagged [executequery]
133 questions
0
votes
1 answer
SharePoint All Day Event Inconsistant
I am using an event receiver to ItemUpdated function to keep two calendars in sync. My code words fine but I notice that when "All Day Event" is exported it gives the new list a different end date.
EX:
Original List
Title: Test1
End Date: 1/28/2016…
Shark Tank
- 25
- 5
0
votes
0 answers
Can I update a Sharepoint list by grabbing the list via its ID?
I need to populate a large Sharepoint list (about 100 fields) a several fields/a page at a time (when the user navigates away from a page, store the values he entered on that page into the list).
Rather than six different sets of…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
0
votes
2 answers
executeQuery in postgresql using netbeans?
I have a basic code but its not working. i don't know why. I checked throughout the code by printing after each line but it seems like executequery is giving me hard time. Need help from experts please..
{
package…
Shokouh Dareshiri
- 826
- 1
- 12
- 24
0
votes
1 answer
Can ExecuteQuery return a DBML generated class without having it fetch all the information for that class?
I have a couple of DBML generated classes which are linked together by an id, e.g.
ClassA {
AID,
XID,
Name
}
ClassB {
AID,
ExtraInfo,
ExtraInfo2
}
In using something like db.ClassAs.Where(XID == x) and iterating through…
Faury
- 1
0
votes
2 answers
Run a query script inside a for in loop (Oracle)
I have a function as you can see below. I have a query string because i need to execute it with a parameter. My problem is: how can i put the query inside the "for"? I've tried with
EXECUTE IMMEDIATE query_string
in my for loop but it doesn't…
Light1988
- 77
- 12
0
votes
1 answer
what is the difference between these two exection commands in c#
Do you know the difference between these two conditions?
1
if(reader.hasrows())
{
while(reader.read())
{
}
}
2
while(reader.read())
{
if(reader.hasrows())
{
}
}
Steven Spielberg
0
votes
1 answer
mysql statement WHERE as unknown
I have this sql statement:
selectAllUsersByCriteria = connection.prepareStatement(
"SELECT * FROM Users WHERE ? = ?" );
And the follow method running the statement:
public ArrayList getUsersByCriteria(String 1criteria,…
MDK
- 95
- 1
- 1
- 8
0
votes
1 answer
Unable to execute multiple SQL queries with Data Source connection
I am trying to execute multiple queries but only a part of the queries gets executed.
Here is my code:
public class PostPrReqDaoImpl implements PostPrReqDaoInterface {
@Override
public boolean validate(PostPrReqBean pprb1,PostPrReqBean…
Soumav
- 385
- 1
- 6
- 25
0
votes
1 answer
PHP's PDO: can I prepare a query which will keep unchanged the column if corresponding variable is unset?
Let's say I have a prepared query:
$update_rq = $DB->prepare("
UPDATE `table`
SET
`A` = :a,
`B` = :b,
`C` = :c
WHERE `id` = :id
LIMIT 1
");
If I will execute this query with the following code:
$update_rq->execute(['id' =>…
Vlada Katlinskaya
- 991
- 1
- 10
- 26
0
votes
2 answers
JDBC update database
i have a form and onClick listener i want to update some data on my database exception says that i have a syntax error but when i execute query at mysql console it works here is my code all variables are checked
String temp = …
user3574298
0
votes
2 answers
Insert SQL Query not executed
I am doing the programming on my computer and it works fine-the program, the database itself, inserting to the database is also working fine. But when I publish it and install the program on another computer. It crashes and does not execute the…
shesxue28
- 13
- 3
0
votes
1 answer
Lines after the executeQuery(quer) not executing?
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
String del_user = JOptionPane.showInputDialog(null,"Enter the Username To be deleted :" ,"Delete User !",…
devcodes
- 1,038
- 19
- 38
0
votes
1 answer
PDOException thrown in PHP
I'm getting the error "SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens" when I try to run the below function:
public function find_products($string = '', $fields = array(), $sort_by = '',…
0
votes
1 answer
CREATE Table Execution issues
I cannot figure out what the problem is with my table..
CREATE TABLE PLAYER
(FirstName VARCHAR(15) NOT NULL,
LastName VARCHAR(15) NOT NULL,
BirthDate DATE,
Address …
0
votes
1 answer
Executing particular query at regular intervals in mssql server
I need to execute a query at regular intervals in my server. The query is to select a particular date from a table in my database, check it with the current date, and if current date is higher then do some particular tasks like inserting values to…
njnjnj
- 978
- 4
- 23
- 58