Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 1,000 results for
sql2008
- Page 1
Question Answering with YouTube Videos Using RAG in LangChain
Programming
Computer Science
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
Programming
Software Development
3 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
Programming
Computer Science
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Web Development
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
Programming
Databases
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
Programming
Databases
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
Programming
Web Development
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
Programming
Databases
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 ?
Programming
Web Development
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 ?
Community Center
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
Programming
Web Development
17 Years Ago
by billythehamster
Sql
Re: My login UI
Programming
Software Development
16 Years Ago
by lAZLf
Sql....
Re: passing two parameter in Crystal report
Programming
Software Development
13 Years Ago
by SkyVValker
sql
Re: Data column discuss
Programming
Software Development
10 Years Ago
by on94
SQL
sql stored procedure inser and update
Programming
Software Development
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
Programming
Software Development
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
Programming
Databases
11 Years Ago
by cooling
SQL Server
Recover SQL server 2008 database
Programming
Databases
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???????
Programming
Web Development
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?
Programming
Web Development
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
Programming
Web Development
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 ?
Programming
Databases
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
Programming
Databases
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
Programming
Software Development
10 Years Ago
by Ketsuekiame
[Sql Connection Strings](http://www.connectionstrings.com/sql-server/)
Re: JOIN SQL Having , MYSQL
Programming
Web Development
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
Programming
Databases
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?
Programming
Databases
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?
Programming
Databases
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.
1
2
3
17
Next
Last
Search
Search
Forum Categories
Hardware/Software
Programming
Digital Media
Community Center
Latest Content
Newest Topics
Latest Topics
Latest Posts
Latest Comments
Top Tags
Topics Feed
Social
Meet People
Forums
Top Members
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
SEO Backlink Checker
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2024 DaniWeb® LLC