Re: What's your favorite productivity hack outside of coding? Community Center 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. pass data to another asp page Programming Software Development 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:… This is me venting Community Center Meta DaniWeb 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: This is me venting Community Center Meta DaniWeb 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 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 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 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 … Mariadb10.11.6 Glarea single failed node startup stuck failure Programming Databases 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) … Using Natural Language to Query SQL Databases with Python LangChain Module Programming Computer Science 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: Online subission forms not sending emails of submitted info Programming Web Development 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 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 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 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: Online subission forms not sending emails of submitted info Programming Web Development by Dani The first thing I will say is never output `$_POST[]` content directly into the HTML without escaping it first. You are leaving yourself wide open to an HTML injection attack. Not only that, but you're also leaving yourself open to invalid HTML. All it takes is to wrap your user-sent variables with htmlspecialchars to make sure they're HTML-escaped… Re: Online subission forms not sending emails of submitted info Programming Web Development 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 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 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 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 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 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 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 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 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 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 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. Re: Mariadb10.11.6 Glarea single failed node startup stuck failure Programming Databases by rproffitt I wonder if the last other stable releases show this issue? "Stable release: 11.3.2 / 16 February 2024; 46 days ago" or the most recent release of MariaDB 10.11: MariaDB 10.11.7 Stable (GA) That is, many fixes don't get released for out of date versions. The new version is how many fixes are issued. Re: Mariadb10.11.6 Glarea single failed node startup stuck failure Programming Databases by toneewa I wonder how these IP addresses are issued. Static, dynamic, or is DHCP on? It reminds me of the time a network printer that stopped working, after the power went out. Other devices connected to the network after it's setup. Then, after rebooting, it got a different IP, but the host still thought it was on the old one. I've seen the same thing when… Re: Postfix authentication problem Hardware and Software Linux and Unix by chickenbirds > I am trying to set-up Postfix on my Ubuntu local web development machine for send-only e-mails using Gmail so I can test e-mails sent by a web app I am developing. Even though this is an old post I wanted to reply as I found it while trying to setup my own postfix mailrelay on my private cloud server with Debian that hosts our small … How can I resolve the 'SSL_ERROR_NO_CYPHER_OVERLAP' error in Firefox? Programming Web Development by premdparmar I'm facing an SSL-related issue in Firefox with the 'SSL_ERROR_NO_CYPHER_OVERLAP' error. It seems there's a problem with encryption algorithms between the browser and the server, hindering the establishment of a secure connection. Any guidance or solutions would be appreciated. Re: How can I resolve the 'SSL_ERROR_NO_CYPHER_OVERLAP' error in Firefox? Programming Web Development by Dani Does the web server have an updated SSL certificate installed?