2,569 Topics
 | |
| | I'm facing a database connection error in my MySQL-based application. The credentials are correct, but I keep getting: ERROR 1045 (28000): Access denied for user 'admin'@'localhost' Is it a privilege issue, host misconfiguration, or MySQL version mismatch? Seeking expert developers in the USA to resolve and optimize the database connection.  |
 | This week I'm working on the data warehousing capabilities of my application. Now most people here who have built more than a couple of applications can tell you how useful it is to include a datestamp on records or requests as they come in. The advantages are numerous. So much …  |
| |    here is three Sql table name of them - 1. orders 2.order_item 3. target_value I am trying Two way here is may two code : 1 SELECT I.target_id as Iid, I.target_date as Idate, I.customer_name as Icust, I.target_product as Icat, I.target_pay as Ipay, I.target_rec as Irec, I.active as … |
| | Hey Gang! I'm hitting a point with my (python/mysql/linux) app for processing large amounts of network records where I need to make a design decision. I definitely want my app to have high performance. Because optimization as a skill set is so rare there is no reason not to employ … |
| | Hi What is wrong in my this backup code it always not working and gives me an error SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB; AttachDbFilename=D:\repos\mysales\WindowsFormsApp4\Database1.mdf; Integrated Security=True; "); string database = con.Database.ToString(); if (textBox1.Text == "") { MessageBox.Show("Please Enter Backup File Location"); } else { string cmd = "BACKUP DATABASE …  |
 | The advent of large language models (LLM) has replaced complex scripts with natural language for automating various tasks. You can now use LLM to interact with your databases using natural language, which makes life easier for people who do not have sufficient SQL knowledge. In this article, you will learn …  |
| | Hey! I've been asked to store some data from a client in mysql in an encoded format using python. Nothing could be easier, right? I will later need to decode the same data using mysql exclusively. Given that constraint, I thought that base64 would be the go to since nearly … |
| | A rapid app development platform refers to a software framework or environment designed to expedite the process of creating applications. These platforms typically offer tools, frameworks, and interfaces that streamline the development cycle, allowing developers to build apps more quickly and efficiently. Leveraging features like drag-and-drop interfaces, pre-built templates, reusable … |
 | Keeping things secure is very important. I have been learning about user authentication in web apps but am concerned about data security. It will be really helpful if somebody could help. |
| | Security matters. How can I guard against things like SQL injection or cross-site scripting? It will be really helpful if somebody could help.  |
| | |
| | Hi, My Crystal Report is using VB.NET and Sql server 2005. The report can be displayed but everytime it will prompt me to key in the Username n Password.. is there anyway to automatically pass the login information to reports? thanks =)  |
 | HELLO ALL ! I am new here and a Lerner,beginner. I need help from you all great mind in my project that i have a datatable dt. i retrieve data from sql to a data table named dt in vb.net. now i want to write result in notepad where user …  |
| | Hiya, I need to learn the SQL query that counts all the points from more than one column and orders the matching rows based on most points in descending order. EXAMPLE 1: I do a keyword search for "mobile phone tutorial apps". Note 4 words. Sql should find all the … |
| | Hi Wanted to utilize the php/mysql insert into the FPDI pdf export tool. I have it working just as plain text which is nice. But, i'd like to to have mysql place db entries into it. I've declared my sql connection, just using dreamweaver at the moment. I'm struggling to … |
| | An equipment company wishes to create a database to support the hiring of tools and machinery to clients. The company has three types of equipment: power tools, such as drills and vacuum cleaners, plants such as excavators and scaffolding. Each piece of equipment is identified by a number. Power tools … |
| | I am making a edit blog option for a website. I am done with the code. Whenever i click the edit button it redirects to the form action file and shows a blank page. Here are my codes. # edit-blog.php # <?php include_once('header.php'); include_once('sidebar.php'); include_once('controller/BlogController.php'); $_SESSION['ap-old']['title'] = $_POST['title']; $_SESSION['ap-old']['short_description'] = … |
 | Hello all, I have a question I have 2 ids in a url that I want to extract with php, but it doesn't work, can someone help me below an example this is the url: https://iets.eu/verzoekentest/artiest.php?id=48&9.9 $string=$_GET['id']; list($first,$second)=explode('&',$string); |
| | Hello, I have a typical login page in vb.net (Asp.net). It checks a sql table for a user/pw. If admin1 user they get directed to admin page. if not, they go to basic users page. I put this below code in my web.config page in the testlogin folder. (which I … |
| | Hi,This code creates a friendly link on user mentions in comments... However, it is not case sensitive and vice versa. Examples; @test works @Test doesn't work The regular expression takes both values. But the query is not catching. I figured it would be a case-sensitive collation on the database. But …  |
| | i have 3 tables : users, deposit, withdraw **table users :** id , username, referral 1. 1, a1, null 2. 2, a2, a1 3. 3, a3, a2 4. 4, a4, a1 5. 5, a5, a2 **table deposit :** id, users_id, amount, status, approve_date 1. 1, 1, 10000.00, approve, 2022-10-01 14:52:53 … |
| | Overwhelming inboxes are a typical complaint in the modern day. It might be challenging to keep up with the constant stream of communications and choose the most crucial ones, which is why we have put together this guide on how to handle email overload. Constantly checking your inbox throughout the … |
| | (Thank you Dani for approving this post!) Hi We are researchers from the University of Zurich, Switzerland, and developed a web application experiment for investigating ways to improve code review. If you have **javascript** knowledge, please help us in this **20 – 30 minutes** experiment by using the desktop version … |
| | So, I have made a table called `supplies_table` and inside the table is `id`, `name`, and `files`. And I also made an upload button where it can upload a pdf BLOB file into the `files` column. Yes, it can upload a pdf file in the `files` column but the problem … |
| | |
 | Hi, I want to write a program whose input is the names of the companies and when adding the name of each company, it will take various information from that company of different types, 1- TextBox (daily production rate), 2- CheckBox (select product features), 3- OptionButton (the gender of the …  |
| | Severity Code Description Project File Line Suppression State Error CS1061 'SignupScreen' does not contain a definition for 'BtnSubmit_Click' and no accessible extension method 'BtnSubmit_Click' accepting a first argument of type 'SignupScreen' could be found (are you missing a using directive or an assembly reference?) WpfSignupscreen D:\Visual Studio Work\WpfSignupscreen\WpfSignupscreen\SignupScreen.xaml 23 Active |
 | I need to get a set of results from the db (server) but at times I would get the same result back and I would like to cache the result instead of making the same call to the db. Any ideas? |
 | I have a table with the below sample output. uid atime adate A_in_out 11 8:16 14/05/2014 I 11 13:35 14/05/2014 I 11 17:23 14/05/2014 I 11 21:09 14/05/2014 I 12 14:06 14/05/2014 I 12 22:39 14/05/2014 I 13 8:00 14/05/2014 I 13 17:12 14/05/2014 I I want to build a … |
| | Hi! I need a web application for my business. Should I hire an agency or a freelancer? What's the better value? Thank you. |
| | i want to full source code for attendance capturing such as In and out time, total hours, odd and even punch so pls Any one help me.... |
| | I like to know if its possible to create a web page and provide the TEXT that needs to be SAVED in some kinda file or Table to be provided at the command line in as part of the URL |
| | |
| | I'd like to start learning how to program. I have limited skills in SQL and DOS. I need to learn how to code in a proprietary language that is similar to VB. How do I get started? What's a good code bootcamp recommendation? VB, SQL, C++  |
| | The term SQL stands for Structured Query Language, it's a programming language that's used to update and communicate with the database. SQL skills are indispensable and are in demand as with the boost in technology, data is piling up. And, In today's world this data has become a necessity for … |
| | Hello, I search many days about this problem. I'm curious if in a text file it's possible to sort words in a language in alphabetical order and in another language to ignore them using ArrayList? |
 | # Introduction # As we move into 2022, businesses will continue to look for ways to become more data-driven. This means that knowing how to use Structured Query Language, commonly called SQL or 'Sequel', will remain an essential skill for data scientists, analysts, and developers. In this post, we'll provide … |
| | Hello I create project based on c# , and i make roles like admin and users , so that i want to give special premission to users to perfom tasks . if anyone know how i can make or write this code , please help me . and in advance … |
| | I want to insert the deleted data into another table (Like table history) in sql server database using visual basic 2008 by scanning QR Code data. What I have done in my source code program is like this; Private Sub btnDel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDel.Click … |
| | Write a C++ program that asks the user to enter the number of rooms in a house. For each room, the user must be prompted to enter the following details of each room to be stored as attributes of the class Room. • width length colour Declare 'name' as a … |
 | I am trying to come up with an SQL query to return all the records earlier than a certain year with SQLite using DB Browser. I can't seem to come up with the right regex expressipn to use for filtering only the year from a row for comparison, below is … |
| | hi, i have some problem with my php code. when i run the php, the page keep loading and no output displayed. here is my code: $dayBeforeNew = $_GET['daybefore']; $dayAfterNew = $_GET['dayafter']; $sql = "SELECT reference.LOCID, reference.Region, Sitename, (SELECT `Data Total Traffic` from 4g_statistic where reference.LOCID = 4g_statistic.LOCID AND 4g_statistic.Day …  |
| | I am using intellij for the java coursework which is related to clients and databases. I am receiving the following error Exception in thread "main" java.lang.NullPointerException: Cannot invoke "java.net.URL.toExternalForm()" because "location" is null at java.desktop/javax.swing.ImageIcon.<init>(ImageIcon.java:232) at client.Interface.$$$setupUI$$$(Interface.java) at client.Interface.<init>(Interface.java:54) at client.Application.main(Application.java:317) This is the code: ` ` package client; //region …  |
| | **There are 2 tables as orders$ and 'order items$'** orders$ Table have 4 columns as order_id, customer_id, status, order_date 'order items&' Table have 4 columns as order_id, item_id, product_id, quantity I want to modify the SQL statement to show an average number of products each customer had on their orders. … |
| | How do you print repeated digits from 1 to n after asking a user to enter a int8 number n.The printed digits should be random.say for example a user enters enters n=5 then the program prints randomly 11223412345.You can see the maximum is 5.Also how do you sum up these … |
| | I am using phpmydirectory and am having problems logging in. We had a power outage yesterday and this morning i cannot access my Control Panel. I am just getting teh error message that i have used so many login attempts and when i get to 5 attempts i will need … |
| | So far, we have gotten lots of innovative social media models. I am not too sure if this has already been tried, but I want to innovate on ownership model. Basically, I envision a Reddit that is owned by its mods and users. Maybe a hybrid FB and Reddit. It …  |
| | I posted this the other day and by and large people responded with predictable lack of imagination. I will add additional explicit requirements for the prototype stage. I want to create a prototype of a different type of social media - call it "pro social" media. It would be owned … |
| | how to barcode scanner in xamarin.form and connect sql server DataBase |
 | I'm new to this site and still fairlu new to PHP so not sure if this is were I need to place my question but here goes. I am currently trying to create a filter for my table using PHP. The filter options are already in my database; e.g I … |
The End.