All Questions
116 questions
0
votes
0
answers
76
views
Instead of updating, a new post is being created
I'm working on a small CRUD site, and I ran into a problem: when trying to update an existing post, a new one gets created instead of modifying the existing one.
The ID is being passed correctly, I’ve ...
- 43
-1
votes
1
answer
57
views
PHP CRUD data not posting even after db connection successful
I developed the create function for my PHP CRUD, the database connection is successful, but when I post the data, it doesn't do anything. It should either say that the data is posted successfully or ...
- 1
0
votes
0
answers
29
views
How to solve ER_ACCESS_DENIED_ERROR
I am writing a sign up/login page with node, using express, MySQL, dotenv, hbs e bcryptjs and nodemon. I run the code (which is below), but console returns me this error:
code: '...
0
votes
1
answer
36
views
Bound Dropdown List not populating into sql table on save
I have two dropdownlists that are bound to two columns in a sql table1. When I select an item within the dropdownlists and click my save button, the text in the dropdownlist does not appear in the ...
- 15
-1
votes
1
answer
134
views
How can I display book details in Laravel using Eloquent join and where clauses?
Undefined property: Illuminate\Database\Query\Builder::$title
public function show(string $id) {
$books = DB::table("book_tbls")
->where("author_tbls.id", "=&...
- 1
0
votes
0
answers
19
views
How can I update a MySQL record with foreign key in PHP? [duplicate]
Im trying to update a record in MySQL using PHP. The record has 2 foreign keys, member_type and financial_year. Now I use the code below:
public function update($pdo)
{
$stmt = $pdo-&...
- 1
0
votes
2
answers
252
views
Extract data based on two tables with a column data at row level from table 1 and column data at columnar level from table 2
I want to do a select operation between two tables where a single column data from table 1(l_id) is spread into multiple columns in table 2(g_id, p_id), how to write the query
table 1
e_id, name, ...
- 195
-2
votes
1
answer
107
views
How to write deadlock-proof upsert T-SQL? [closed]
For a web api performing standard CRUD operations against a database :
For the DML CUD operations I could see two strategies at the endpoint :
Strategy 1 : CUD SPs accept params for table keys. First ...
- 8,927
0
votes
0
answers
35
views
To delete multiple data from other tables do i have create delete file for every table? [duplicate]
I am stuck at deleting data from my table ! I am deleting data from the table but I if i have to delete rows from multiple rows from another table ! Do i have to create multiple delete files for every ...
-1
votes
1
answer
197
views
Multiple query parameters in Spring Data JPA
What am I doing wrong?
Repository:
@Query(value = "SELECT * FROM agenda WHERE substring(data,1,10) IN (:data0,:data1)", nativeQuery = true)
List<AgendaModel> find(String data0,String ...
- 61
0
votes
0
answers
101
views
Sql Server CRUD LOGGER in all tables
A- I need to create a CRUD logger, and its working as well with folowing script, but the problem is that the script does in only one table...
Objective: Install de trigger above in ALL tables, not in ...
- 1
0
votes
1
answer
79
views
SQLALCHEMY - returning a pretty format [duplicate]
I am trying to create a basic CRUD application with python using sqlalchemy. It is just a virtual contact book, that runs in the terminal.
I have managed to create this and get it working successfully,...
- 65
5
votes
1
answer
20k
views
Most efficient way of updating ~100 million rows in Postgresql database?
I have a database with a single table. This table will need to be updated every few weeks. We need to ingest third-party data into it and it will contain 100-120 million rows. So the flow is basically:...
- 1,075
0
votes
1
answer
156
views
Search through laravel relationship with filtered date
i search data 1 (this exist in database) within date range of 13-04-2022 to 14-04-2022 (there is no data in this date range). From this query that i used on my controller still return the data that ...
0
votes
0
answers
252
views
Laravel 7 CRUD (Update) doesn't have error but db is not updating
I am trying to update a data but it doesn't change in the database. The ajax tells that the data is successful and the console did not show any error. Please help me. I need to finish this before ...
0
votes
1
answer
171
views
How do I display an image from a DataGridView to another PictureBox in a new Windows Form?
What I'm trying yo do is once I clicked on a row in my DataGridView, clicked on the view button, and it opens a new window that displays all the data from the DataGridView to the textboxes. I already ...
0
votes
1
answer
266
views
Showing Datetimepicker value into Datetimepicker box from database
Hello i have database called tbl_data, that have name,address, and 'date' type of data
example : 12/5/2021 (the data saved like this in my db)
I use datetimepicker toolbox to insert date into database,...
- 65
-1
votes
3
answers
582
views
show message when record doesnt exist
I have a database and a website with a textbox. the user can type in the name of a record in the database and then it will be deleted. What I want to add, but can't figure out how, is a way for the ...
- 57
0
votes
0
answers
80
views
How to update many-to-one entities correctly - how to update Order with OrderItem
I would like to ask about the concept, so pseudo-code or example in your preferred language should be enough.
Problem:
Let's say, I have two entities. Order and OrderItem. Order has many OrderItems. ...
- 85
1
vote
1
answer
232
views
Laravel/Ajax: refreshing the table stacks the new data at the bottom (old data stays)
I am using fetchcategory(); in order to refresh my table whenever I try to add, edit, and delete data. My issue is that everytime the table tries to reload, the newly update data stacks at the bottom ...
user16218026
0
votes
1
answer
33k
views
Error starting Tomcat context.Exception: org.springframework.beans.factory.BeanCreationException.Message:Error creating bean with name 'h2Console' def
I have this simple CRUD Spring HTTP Service (see ). I would like to achieve something like . I made use of Thymeleaf and 2 html files: add-edit-employee.html and list-employees.html.
Initial data ...
- 27
0
votes
2
answers
224
views
Query Java doesn't execute
I'm trying to execute a query on eclipse at my Java program, but it always exit with a exception and don't execute the query, I read a lot of posts here but no one of them could help me with this.
...
0
votes
2
answers
2k
views
Where do I execute native SQL queries in Loopback 4?
I'm new to Loopback 4 and I've been trying to execute a native SQL query. I found how to do it, the thing is that don't have any clue of WHERE to put it in my code in order for it to work... here's ...
0
votes
1
answer
229
views
Delete a users data from SQL using PHP
Hi im trying to delete a users booking detials when the user clicks delete in my bookingbeforedeltion.php file but for some reason when I test my php file once I click delete it goes to my delete.php ...
- 49
1
vote
1
answer
675
views
How to add a link to edit and delete each row in a table formulated using php
I have written php code that outputs a php table and for each row, I want to be able to add an extra column to an edit and delete link (CRUD functionality). Currently I have been able to add the extra ...
- 13
0
votes
0
answers
60
views
CREATE statement fails in ASP.NET MVC
My create statement could not work suddenly and it goes straight to an error message (Account cannot be created). I am not sure where I went wrong as I did not make any modification to it at all. In ...
0
votes
1
answer
154
views
Error C1061 "... does not contain a definition for 'TextBox_TextChanged' ......." update SQL Server database with Entity Framework
I have a database table Doctor which contains columns code_doctor (varchar), name (varchar), gender (varchar), salary (int). I want to implement CRUD in this database, using Entity Framework. But, ...
- 23
0
votes
2
answers
526
views
Freeze mysql table
There is a mysql comand to freeze a table ?
In way to not insert other records in it and not modify them.
I am a principiant , thanks to everyone.
- 33
1
vote
0
answers
16
views
flutter sql : got error on return text[list[i], ['item_name']
i got error on return text(list[i],['item_name']) //at bottom of coding .
this is my coding in main.dart
please help me, it doesn't show what error to fix
@override
Widget build(BuildContext ...
- 21
0
votes
1
answer
420
views
Best way to update rows in table
I have an interface where the user adds, edit or delete products, once I save the changes I go to the products table, delete everything by ID and add the products that the user just selected, is this ...
- 29
0
votes
1
answer
139
views
Create Admin LoginPage With Codeigniter
I'm trying to create some admin login. I think my code is correct because when I input wrong email and password the error message appears on login page. However, when I input correct data of my DB, it ...
- 37
0
votes
1
answer
227
views
Windows Form App (.NET Framework) CRUD Project, changes successfully saves into DataGridView, but not the actual Database Table
This is my first time using C# and SQL. I've managed to get the datagridview to work, be it insert, update or delete. However, all the changes that is reflected in the datagridview is NOT updating in ...
0
votes
1
answer
539
views
PostgreSQL: create table with unique timestamp for all rows
I have a record of users' trips with begin/end positions and time in a table like this:
CREATE TABLE trips(id integer, start_timestamp timestamp with time zone,
session_id integer, ...
user12587364
0
votes
1
answer
81
views
PostgreSQL: update table ensuring rows have unique timestamp (no duplicate unix timestamp)
I am having a table of GPS traces with Unix timestamp as shown below:
SELECT * FROM mytable LIMIT 10;
id | lat | lon | seconds | speed
-----------+------------+------------+-...
user12587364
0
votes
2
answers
80
views
Questions about JSP & SQL. Java web application
I am recently working on making a Java web application, which must focus on CRUD(You know). But I am stuck with the read & update & delete operations(Three operations). Only Create Operation ...
1
vote
2
answers
2k
views
Migration issue after scafolding. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
In trying to follow this example.
After scaffolding, when I'm trying to execute the commands:
Add-Migration InitialCreate
Update-Database
I receive this error:
A network-related or instance-...
- 2,264
0
votes
1
answer
2k
views
SQL Server Add Default datetime column for existing table
I want to have a new column in the table that will show the date and time of the inserts, but without modifying the queries to include the column itself.
I have added the new column in the following ...
- 366
0
votes
0
answers
90
views
How do I run a php script on Angular on input change?
It seems that I am having trouble running an SQL query on the server via PHP on Input change. Could someone please take a look on my code and assist me?
The service that is responsible for handling ...
1
vote
2
answers
3k
views
Updating user status using PHP and SQL
Here, I'm trying to get a list of admin users and add and remove it using PHP and SQL.
I listed some users but I couldn't think of removing and adding by updating a Boolean data (made this Boolean ...
- 11
0
votes
0
answers
150
views
CRUD in PHP with junction table using SQL
I have 2 tables in my database: companies and employees. Each company can have multiple employees and each employee can work at multiple companies. Therefore I need a many-to-many relational table ...
- 21
3
votes
2
answers
503
views
PHP MySQL Query Search with Foreign Key
I have 2 tables in my databases, tb_device and tb_label which contain this for example:
tb_device
id (AI) | type | label | etc
-------------------------------------
1 | A123 | 1 ...
- 33
1
vote
1
answer
28
views
Mutiple insertions of the same data on sqllite database
I'm trying to create a simple CRUD form on android development studio.
I can enter data to the database but it seems to only pick up the 'county' texField. So each record is set to whatever was in ...
- 13
0
votes
1
answer
2k
views
Retrieving an SQL statement from an HTML form with the POST method doesn't query the database
I'm currently building a simple CRUD application and decided it would be a nice feature to directly query the database from the browser (i.e from an HTML table) and display ('Read') the results from ...
- 184
0
votes
0
answers
71
views
Is there a way to perform Add Edit Delete Read for FullCalendar?
How to do a FullCalendar with all crud functions in MVC without using json if possible? Just using raw sql.
My current fullcalendar code can only display the current date only. What must I do to in ...
- 21
0
votes
4
answers
105
views
Pdo error with invalid parameters
I have an error since yesterday on my crud and I'm becoming crazy.
For editing entries in my database, I have two files:
edit.php with the editing form identified by the parameter id
see code
doedit....
0
votes
0
answers
47
views
JavaFx:an error while adding a like on my post
I tried to add a like when pressing Like button. I've used a simple add code (I'm pasting it below) but I keep getting errors:
Apr 06, 2018 10:30:08 AM Service.LikeService addlike
SEVERE: null
com....
user8069069
0
votes
0
answers
54
views
query works, nothing happens
Ok, I have changed the code to two different querys and cut the GET_$ID semicolon and place it like the isset POST variables.
Now I get two new errors:
Notice: Undefined index: edit in C:\wamp64\...
0
votes
0
answers
517
views
MYSQL query not regexp
I have written the following query where i want to select rows that don't carry any of abc or cde and bcg.
In the output, I am still getting rows with abc or cde and bcg.
select * from table where ...
- 2,959
1
vote
1
answer
25
views
Deleting rows using join within MYSQL
I have written the following query to delete rows but getting unexpected syntax error
delete from table1 T1
INNER JOIN table2 T2 ON
T1.column1 = T1.column2
where T2.date > '2001-01-16'
Please ...
- 2,959
0
votes
3
answers
228
views
MySQL: Selecting In Between DateTime records
I want to get the count of records between two date-time entries.
I have a column in my table named created_date with the datetime data type.
I want to select rows which were created between 2017-01-...
- 15.5k