Search DaniWeb - sql2000

Question Answering with YouTube Videos Using RAG in LangChain 6 Days Ago by usmanmalik57 In previous articles, I explained how to use natural language to interact with [PDF documents](https://www.daniweb.com/programming/computer-science/tutorials/541732/paris-olympics-ticket-information-chatbot-with-memory-using-langchain) and [SQL databases](https://www.daniweb.com/programming/computer-science/tutorials/541771/using-natural-language-… pass data to another asp page 4 Days Ago by Fergus_1 ok so i have a page with a gridview on it and it displays rows from sql table. i have also a link assigned to each row: <asp:GridView ID="GridViewMatters" runat="server" AutoGenerateColumns="False" OnRowDataBound="GridViewMatters_RowDataBound"> <Columns> <asp:… Using Natural Language to Query SQL Databases with Python LangChain Module 1 Week Ago by usmanmalik57 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 how to retrieve information from SQL … Re: How to query database using variable and get all results not just one row 1 Week Ago by Mikekelvin To ensure that you're retrieving all records associated with the current user, you need to make sure that your query accurately filters the data based on the user's identifier (variable_name). Here's how you can modify your query to achieve this: // Assuming $currentUser holds the identifier of the current user // Query database to retrieve … Re: How to query database using variable and get all results not just one row 1 Week Ago by Chris_103 To retrieve all records associated with the current user, you can use the fetchAll() method instead of fetch(). Here's how you can modify your code: ```php // Query database to retrieve records associated with the user $sql = "SELECT * FROM table_name WHERE variable_name = :variable_name"; $stmt = $conn->prepare($sql); $stmt->… Re: How to query database using variable and get all results not just one row 1 Week Ago by Biiim logically, it would be because `WHERE variable_name = :variable_name` matches 1 row in your table maybe try a `var_dump(str_replace(':variable_name',"'some_value'",$sql));var_dump($records);`? run the sql on whichever way you use to access your DB directly I don't use PDO so i'm not too familiar on how it returns results, either … Re: Improve HAVING BY performance 2 Weeks Ago by toneewa I'm a little late to the party, however, I want to share my experience learning MySQL in the past day. I setup a server, a database, and wrote a C++ program to connect to it. It measures the times for 3 SELECTs. The whole product list, using HAVING, and WHERE. I also tested reversing the orders. Query execution time: 0.0002336 seconds … Re: Improve HAVING BY performance 2 Weeks Ago by Dani Here are some articles that can explain it in greater depth: * https://web.dev/learn/performance/why-speed-matters * https://developer.mozilla.org/en-US/docs/Learn/Performance * https://web.dev/explore/fast The HTML page must be downloaded in its entirety before the web browser can begin loading anything else (CSS, Javascript, images, etc.)… How to query database using variable and get all results not just one row 1 Month Ago by nander Hello I am trying to query a database to show records only for the current user using variable I get the correct data but only 1 row with results any guidance? // Query database to retrieve records associated with the user $sql = "SELECT * FROM table_name WHERE variable_name = :variable_name"; $stmt = $conn->prepare($sql); $stmt… Re: Improve HAVING BY performance 1 Month Ago by Reverend Jim I have a friend who spent the better part of a career doing SQL. I wrote up your question and sent it off to him. Just for sh!ts and giggles, he decided to feed it to ChatGPT first. He said that what he got back was what he would have written if he spent a lot of time researching. Here is what ChatGPT said... >Yes, you're correct that … Re: Can someone please advice me for hoe can i prevent xss attacks ? 2 Months Ago by gottaloveit In whatever code language is running on the server, use a well known database library that is well documented and features XSS aka sql injection prevention. Re: How do you use LLM AI tools in your daily programming workflow ? 1 Month Ago by rproffitt I use ChatGPT for quick and dirty work where I need a function to build some apps. My close friend took ChatGPT back to work in December 2022 and they use it for many things. Examples such a SQL queries and regular expressions. He tells me they saved mid 5 figures USD in the first year over outsourcing. It's time and money. Some get a little… Re: Personal preferance question 17 Years Ago by billythehamster Sql Re: My login UI 16 Years Ago by lAZLf Sql.... Re: passing two parameter in Crystal report 13 Years Ago by SkyVValker sql Re: Data column discuss 10 Years Ago by on94 SQL sql stored procedure inser and update 13 Years Ago by kalpa23 sql 2000 i have this sql stored procedure i want the last coloumn fAcc_Total to be updated when a record is inserted. the value in the [COLOR="Red"]fBill_Amount[/COLOR] should be add to the value of the [COLOR="Red"]fAcc_Total[/COLOR] in the same time the record is inserted if there is a value in the previous row of the [… Re: Connect with ms sql server database from Visual Studio Express 9 Years Ago by cgeier [SQL Server connection strings](http://www.connectionstrings.com/sql-server/) In addition, searching for one or more of the following should be helpful: SqlConnection, SqlCommand, DataTable, DataSet. Re: SQL Query checking on a time range 11 Years Ago by cooling SQL Server Recover SQL server 2008 database 13 Years Ago by lordmwesh SQL 2008 database disappeared after canceling copy Hi All, We have an SQL 2008 database of around 12GB. I was trying to create a copy of the database through the Microsoft SQL Management Server Studio. The server is in production mode, and it was taking too long to copy, and had locked off all users, so i canceled the copy, but it was still … Re: Sql??????? 17 Years Ago by ~s.o.s~ SQL stands for Structured Query Language, it is more of a standard than a language. The Database packages which implement SQL are Oracle, MySQL, MS SQL Server 2005, etc. to name a few. PHP is the server side scripting language used to impart dynamic behaviour to the web pages. And it would be a definate plus on your side if you knew the basics of … Re: How To Order By Adding Total Of All Columns In SQL? 1 Year Ago by Fifth Horseman $sql = "SELECT * from keywords WHERE kw1 = ? OR kw2 = ? OR kw3 = ? OR kw4 = ? order by kw1_point desc LIMIT 100"; You're using OR between the clauses. Also, that schema design is... yikes. Why exactly do you need each keyword to have a different score for every document? If I were you I'd just do two tables: one containing … SQL cache dependency with polling-based invalidation 16 Years Ago by serkan sendur sql cache dependency allows for cached data to be evicted and refreshed when it becomes stale. Basically ASP.NET checks for the changes in the datatable in sql server, if it finds one, it refreshes the cached data. Polling based sql cache dependency is very easy to configure as follows : open Visual Studio Command Prompt then execute the … (SQL , PL/SQL) enough for searching jobs in ORACLE ? 17 Years Ago by g.prabu (SQL , PL/SQL) enough for searching jobs in ORACLE ? i have 2.6 years exp with oracle sql, plsql . can i get better JOB ? Re: How to prevent others from seeing contents of sql file 8 Years Ago by jwenting sql files ARE text files. The only way to prevent people from reading them is to make sure they don't have access to whereever they're stored. Re: ms sql database string 10 Years Ago by Ketsuekiame [Sql Connection Strings](http://www.connectionstrings.com/sql-server/) Re: JOIN SQL Having , MYSQL 9 Years Ago by filipgothic $sql = mysql_query ("SELECT fatherid from Sons WHERE name = 'bill' AND <> 'suzy'"); $fathers = mysql_fetch_array($sql); $selection = mysql_query("select name from Fathers where id = ".$fathers['fatherid'].""); echo "Fathers: ";… Re: What's the difference between mysql, phpmyadmin, SQL 11 Years Ago by pritaeas [SQL](http://en.wikipedia.org/wiki/SQL) is a language to query a database for information. [MySQL](http://www.mysql.com/) is a specific brand of server and [PHPMyAdmin](http://www.phpmyadmin.net/home_page/index.php) is a server tool to access the databases on MySQL servers. Re: Can SQL 2005 Run on Windows Server 2012? 8 Years Ago by tarunap SQL Server 2005 (the release version and service packs) and earlier versions of SQL Server are not supported on Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8. Re: difference b/w sql,mysql&oracle? 12 Years Ago by drjohn SQL is the query language used by many relational databases. MySQL and Oracle are relational databases produced by different companies.