6,934 Topics
 | |
 | This tutorial demonstrates how to build an AI agent that queries SQLite databases using natural language. You will see how to leverage the [LangGraph framework](https://www.langchain.com/langgraph) and the [OpenAI GPT-4o](https://openai.com/index/gpt-4/) model to retrieve natural language answers from an SQLite database, given a natural language query. So, let's begin without ado. ## … |
 | 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 =)  |
| | I'm working on an SQL query for a complex reporting system that involves multiple tables and joins. However, the query's performance is not meeting my expectations, and I suspect that the way I've structured my joins might be inefficient. Here's a simplified version of my query: SELECT orders.order_id, customers.customer_name, products.product_name, …  |
 | 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 …  |
| | Hello, Got questions on Sql and Php Prepared Statements. How would you check whether the SQL managed to update a row or not ? Which one of the following lines would you add the IF condition to ? 1). mysqli_stmt_execute() 2). mysqli_stmt_affected_rows() Which of the following examples A-D are a …  |
| | 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 … |
| | Helle Fellow Programmers! Unlike last time where I was checking for matching rows count using mysqli_stmt_rows_count(): https://www.daniweb.com/programming/web-development/threads/539306/login-with-prepared-statements-mysqli-stmt-num-rows-function On this thread, I am checking for matching rows count using Sql's COUNT function. This means, both threads are not same so mods do not close them. Issue is, on both threads, no … |
| | 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'] = … |
| | Hi, Are these MySql queries (with Php) correct ? Wild Card match. Fuzzy Match query. Imagine there are 7 columns in the Mysql table. $sql = "SELECT * from $tbl WHERE $col_1 LIKE ? OR $col_2 LIKE ? OR $col_3 LIKE ? OR $col_4 LIKE ? OR $col_5 LIKE ? … |
 | I want to insert the returned values into an array and after to display random string I have this code by it doesn't return back a random value Inside the vid1,vid2,vid3 columsn there is Video Name text that pointing to the video in my File Manager folder $sql = "SELECT … |
 | 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 … |
| | |
| | My code is this. Dim strSQL As String, strSQL2 As String Dim db As Connection, rst As ADODB.Recordset Set db = New Connection db.CursorLocation = adUseClient db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\River Syde RMS\RiverSyde.mdb;" strSQL = "SHAPE {SELECT * FROM Sales where Date1=#" & DTPicker3.Value & "#" Set rst = New ADODB.Recordset If … |
 | 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 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. … |
The End.