2,570 Topics
 | |
 | 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 … |
| | Hello, I do not see $data defined, so what is it ? ```` function prepared_insert($conn, $table, $data) { $keys = array_keys($data); $keys = array_map('escape_mysql_identifier', $keys); $fields = implode(",", $keys); $table = escape_mysql_identifier($table); $placeholders = str_repeat('?,', count($keys) - 1) . '?'; $sql = "INSERT INTO $table ($fields) VALUES ($placeholders)"; prepared_query($conn, $sql, … |
| | 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. |
The End.