Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 1,000 results for
sql_server
- Page 1
HTML Navigation Menu Alignment Issue
Programming
Databases
4 Hours Ago
by khan zain
"I'm working on a navigation menu for my [HTML](https://iqratechnology.com/academy/html-training/) page, but it's not behaving as expected. The links aren't aligning properly, and the styling seems a bit wonky. I've included the code below. Can anyone help me figure out what's causing this navigation headache? This my Code <!…
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:…
Question Answering with YouTube Videos Using RAG in LangChain
Programming
Computer Science
5 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-…
This is me venting
Community Center
Meta DaniWeb
6 Days Ago
by Dani
This is definitely not a targeted attack at *anyone*. Please take it just as me having a bad day and venting. I'm kinda tired of people constantly telling me that I'm the reason that DaniWeb traffic has tanked over the years. And if only I had done this differently. Or done that differently. Or listened to members more about this. Or listened to…
Re: What's your favorite productivity hack outside of coding?
Community Center
2 Days Ago
by Reverend Jim
Odd that something so basic and obvious needs to be named. Of course, "Pomodoro Technique" is a lot shorter than "go hide in the server room so my boss won't keep interrupting me so I can get some work done" technique. At least that's what I used to call it.
Re: This is me venting
Community Center
Meta DaniWeb
6 Days Ago
by Reverend Jim
It's hard for me to imagine that all of the pleasure I've gotten out of Daniweb, the challenges, the insights, the friendships since I joined in 2010, are all dependent on the largesse of just one very talented person. I, for one, appreciate all you have done, particularly considering your current health issues. If you feel unappreciated then …
Re: This is me venting
Community Center
Meta DaniWeb
6 Days Ago
by Reverend Jim
Also, in non-computing over the years I have heard comments like "if only I hadn't stopped for coffee I would have missed that accident, or several other variations. The thing is you never know what would have happened if you had made different decisions. Certainly making a different decision may have resulted in things being better. Or they …
Re: This is me venting
Community Center
Meta DaniWeb
2 Days Ago
by jkon
Dani , yes I also believe that you are responsible for the decline of DaniWeb .... BUUUT that was many years ago. We all foreseen the decline of "forums" back in early 2010's , there were many alternatives of what to do , and I strongly believe that you choose the wrong one. I will not repeat what you did or what you could be done …
Re: This is me venting
Community Center
Meta DaniWeb
2 Days Ago
by Dani
> what was missing was a programming hub of news / forum / interviews I have always been a strong proponent of having editorial (news, tutorials, interviews, etc.) complement the user-generated forum discussions. In the past, well over 50% of our gross revenue from advertising went straight into paying for staff writers. IMHO we used to have …
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->…
Mariadb10.11.6 Glarea single failed node startup stuck failure
Programming
Databases
2 Weeks Ago
by mx_983
Basic background information Mariadb Ver 15.1 District 10.11.6 MariaDB Glarea cluster, one with three nodes: Node1:192.168.18.78 Node2: 192.168.18.79 Node3: 192.168.18.80 Among them, Node1 node was restarted after a power outage of 1 hour, and after executing the system ctl start mariadb, it was stuck for a long time (running for 6 hours) …
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
1 Week 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: Online subission forms not sending emails of submitted info
Programming
Web Development
1 Week Ago
by Biiim
Hi David, > More problems. I incorporated the coding Biiim provided. Before any changes, after submission, would display the correct (yellow) screen. After code changed, not only will still not send email but screen turns blank white. URL provider, IONOS, told me that the Host is smtp.ionos.com and the Username and password are for an email…
Re: Online subission forms not sending emails of submitted info
Programming
Web Development
4 Weeks Ago
by Biiim
In your code where you write `mail($to,$subject,$message,$headers);` if you want to get error messages or "do something if it fails" you need to alter it a bit to something like: if(mail($to,$subject,$message,$headers)){ //if successful do something }else{ //if error do something else } //or…
Re: Improve HAVING BY performance
Programming
Databases
2 Weeks Ago
by Biiim
> I don't have experience with MariaDB, but in MySQL, something like that will work as long as I do SELECT sum(points) AS total FROM ... HAVING total > 10. Is that what you were getting at? Kind of, MariaDB is a fork of MySQL from around 2009 or something like that, MySQL 5.* and the creator continued developing MariaDB and Oracle took …
Re: Improve HAVING BY performance
Programming
Databases
2 Weeks Ago
by Dani
> I know that in my experience, OR's are very bad for speed you can get away with a few but they can get very bad when they stop the whole query making use of one of the main indexes, you can actually speed it up by moving the or's into the HAVING usually. Thank you for that tip! I never thought of that, but it totally makes sense!! > …
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.)…
Re: Online subission forms not sending emails of submitted info
Programming
Web Development
4 Weeks Ago
by Dani
I wonder if the problem is that your php mail() function is configured to use SMTP in your php.ini file. A lot of SMTP servers switched over the past year or so to using XOAuth2 for authentication. A username + password in your config settings will no longer suffice to establish a connection. You can see me complaining about it [here](https://www.…
Re: AirTM API: How to Build a Form?
Programming
Web Development
3 Weeks Ago
by Dani
I can see that the URL that you linked me to has 4 steps to create a purchase. The first one is to create a Purchase via an HTTP POST request. That can be done with a cURL request. cURL requests require some backend programming such as via PHP or some other language. Are you using a server-side language to write your web app? If so, which one so…
Re: Do you participate in any other communities?
Community Center
Geeks' Lounge
3 Weeks Ago
by Dani
I was talking to Chris (the DiC founder/owner) a little bit before he decided to shut it down. He was saying he's been so busy with his other businesses that he spent maybe 5 minutes on it over the past 5 years, so he lost interest, and it wasn't paying its server costs. At least in the case of DaniWeb, it *also* isn't even coming close to …
Re: Online subission forms not sending emails of submitted info
Programming
Web Development
2 Weeks Ago
by Biiim
You don't need composer or access to the php.exe. just locate the PHPmailer Directory into your web root, to keep it simple and the require links should point to where it is located. mine is `require 'includes/PHPMailer/src/PHPMailer.php';` cause I put it in a folder called includes, this should be relative to the file that is using it.…
Re: Improve HAVING BY performance
Programming
Databases
1 Week Ago
by Biiim
> INSERT INTO electronics.products(ProductID, ProductName, Price) VALUES ('1','capacitors', 2.50), ('2','resistors', 4.50), ('3','rectifiers', 7.50), ('4','diodes', 10.00), ('5','ICs', 25.00), ... ('50000','...', ...); I don't see any mention of an index on it & your benchmark indicates you don't have one: ALTER TABLE `…
Re: Online subission forms not sending emails of submitted info
Programming
Web Development
1 Week Ago
by david.tigner
More problems. I incorporated the coding Biiim provided. Before any changes, after submission, would display the correct (yellow) screen. After code changed, not only will still not send email but screen turns blank white. URL provider, IONOS, told me that the Host is smtp.ionos.com and the Username and password are for an email address associated …
Re: ASUS Laptops - my experience
Hardware and Software
1 Week Ago
by Reverend Jim
I called Best Buy Friday morning to ask about the status of my laptop. I was told the average wait time was one minute. Fifteen minutes later I was told there were eight calls ahead of me and would I like to leave my number for a callback. I did so and after two more hours of waiting I called the local Best Buy direct. I was told my laptop would be…
Re: Online subission forms not sending emails of submitted info
Programming
Web Development
1 Week Ago
by Dani
> After code changed, not only will still not send email but screen turns blank white. That's a PHP fatal error. It could be a syntax error, or it could also be that PHPMailer is not in the location you're telling PHP to look. Do you have any way of accessing the error log? Without access to the server, perhaps through a web-based control …
Re: Mariadb10.11.6 Glarea single failed node startup stuck failure
Programming
Databases
2 Weeks Ago
by rproffitt
From https://stackoverflow.com/questions/78269177/mariadb10-11-6-galera-single-failed-node-startup-stuck-failure where they call it out as a bug waiting for a fix.
Re: Mariadb10.11.6 Glarea single failed node startup stuck failure
Programming
Databases
1 Week Ago
by rproffitt
The problem is still unresolved. Until the bug is fixed. Be sure to tell all that you don't accept this as a bug and want a fix now.
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