Re: Mastodon Community Center Geeks' Lounge by Dani I just stumbled upon this and had no idea that Mastodon was even a thing 6 years ago, pty! I first became aware of them back when Elon bought Twitter (ahem, X) and everyone fled ship trying to find an alternative. Sorry no one replied to this thread until now. Guess you were just too ahead of your time. ;) Claude 3 Opus Vs. Google Gemini Vs. GPT-4 for Zero-Shot Text Classification Programming Computer Science by usmanmalik57 On March 4, 2024, [Anthropic](https://www.anthropic.com/) launched the [Claude 3 family of large language models](https://www.anthropic.com/news/claude-3-family). Anthropic claimed that its Claude 3 Opus model outperforms GPT-4 on various benchmarks. Intrigued by Anthropic's claim, I performed a simple test to compare the performances of Claude … The Rise of AI Scams: Deciphering Reality in a World of Deepfakes Community Center by Johannes C. **Discover the world of AI scams and find out how you can shield yourself against the cunning deceptions of deepfakes.** ![deepfakes-deep-implications.jpg](https://static.daniweb.com/attachments/4/782a49e1fa4e86bd0bedf3957bec4df9.jpg) In an incident that underscores the alarming capabilities of artificial intelligence in the realm of fraud, a… Re: Improve HAVING BY performance Programming Databases by Reverend Jim I'm not very familiar with HAVING but my understanding is that it is used to filter results after a GROUP operation so I can't imagine that indexes would improve performance other than on the original SELECT. Using WHERE would return rows based on one or more criteria, and would benefit from indexing, but HAVING, as I understand, is performed after… Re: 88 Business-Growing Strategies Digital Media Digital Marketing by henrymorgan9522 A growth strategy is an organization's plan for overcoming current and future challenges to realize its goals for expansion. Examples of growth strategy goals include increasing market share and revenue, acquiring assets, and improving the organization's products or services. Multivariate Stock Price Prediction with Transformer Encoder in TensorFlow Programming Computer Science by usmanmalik57 In a [previous tutorial](https://www.daniweb.com/programming/computer-science/tutorials/541123/stock-price-prediction-using-1d-cnn-in-tensorflow-keras), I covered how to predict future stock prices using a deep learning model with 1D CNN layers. This method is effective for basic time series forecasting. Recently, I've enhanced this model by not… TensorFlow Keras Sequence Data Generator for Multimodal Classification Programming Computer Science by usmanmalik57 I recently tackled a challenging research task involving multimodal data for a classification problem using [TensorFlow Keras](https://www.tensorflow.org/guide/keras). One of the trickiest aspects was figuring out how to load multimodal data in batches from storage efficiently. While TensorFlow Keras offers helpful functions for batch-loading … Trump Returns & A Good Year for BTC: ChatGPT’s Bold Predictions for 2024 Community Center by Johannes C. **Who will win an Oscar? Who will be president? When will GPT-5 be released? And will humanity achieve AGI in 2024? Here are ChatGPT's 10 wildest speculations for the new year. ** ![nostradamus-chatgpt.jpg](https://static.daniweb.com/attachments/4/ba0b52e08c3a8a560278083de1d5aa38.jpg) "As a Large Language Model, I am not programmed to … Re: What is most effective social media platform for paid campaign? Digital Media Digital Marketing by trueframe Deciding which social media platform is most effective for your paid campaign depends on several factors, including your target audience, campaign goals, and type of business or product. Each platform has its strengths, and the effectiveness of your campaign will largely depend on where your target audience is most active. Here's a quick overview … Re: What is most effective social media platform for paid campaign? Digital Media Digital Marketing by cat_127 Instagram: Pros: Instagram is highly visual, making it perfect for brands with visually appealing products and services. It is suitable for industries such as fashion, beauty, travel, and lifestyle, as it has a large young user group. Instagram is seamlessly integrated into his Facebook Ads Manager. LinkedIn: Strengths: LinkedIn is a … Re: Design vs. Coding Programming Software Development by Reverend Jim I frequently had to deal with Engineers who felt they could both design software and write it. I only once met an engineer who could do both competently. She got her degree in computer engineering and started in my group as a junior member. She rose quickly through the ranks and even became my boss for a couple of years (my happiest at work) before… Re: Design vs. Coding Programming Software Development by chuckc Reading this I thought, suppose in a group of cave men, some were good at making wheels and some were very good at making wagons. If they switched rolls might they get round wagons with square wheels? On the other hand, if they had a wheel maker who insisted on making square wheels, switching roles might be a good thing. Maybe one size doesn’t … Re: Why am getting different syntax errors when running a Python script Programming Software Development by Tom_45 After I posted this question I noticed that I was missing the raw string indicator and the capture group enclosing parenthesis on the findall, which explains the subscripting error. So, hold off on the answers for now. I'm still having other issues with multiple file runs, though. Re: JTABLE HEADER GROUP Programming Software Development by Jan_315 Hi, I have the same problem. Do you already know the solution? Thanks Re: JTABLE HEADER GROUP Programming Software Development by Jan_315 I have found it. These lines are necessary: private JTable table = new JTable( dm ) { protected JTableHeader createDefaultTableHeader() { return new EtsGroupableTableHeader(columnModel); } }; Re: Trump Returns & A Good Year for BTC: ChatGPT’s Bold Predictions for 2024 Community Center by carriejo810 I did the same for Bard: Who will Win the 2024 US Presidential Election? Answer: In a surprise upset, a strong third-party candidate emerges after the primaries, capturing disaffected voters from both major parties and ultimately winning the 2024 US Presidential Election. Will 2024 be the Hottest Year on Record? Answer: Yes. What will be the … Re: Concat values from same column with different conditions Programming Databases by saadi06 The data that is to be displayed is height like 5ft 2 in.How can I show this using group concat MySql LIKE returns 0 rows Programming Databases by Tunnleram I'm missing something stupid so I need another set of eyes. I have a session value set that's a group concat of a few ids and I want to check to see if an id found by a query is in that group concat. The group concat variable is $session_unitidgrouping The query doesn't return errors, but it doesn't return what I'd expect either. It returns … Filtering logic Programming Databases by Szabi Zsoldos Hi guys, Trying to develop a custom facet like search in Mysql. I have 3 tables for this: 1.Attribute class 2.Attribute class Name 3.Attribute class Value - attributeClassName Id - productId 4.Products Each product has one attribute class Each attribute class has many values Each value is contained in a … group_concat with limit Programming Databases by abhi10kumar How I can group concat of ids with limit 2 and order by id desc? Means, need all the ids except first two ids in desc order. select group_concat(id) as ids from private_tuition_teacher_pdf where client_id = 14 and teacher_id = 15 limit 2 order by id desc Re: Need help for displaying movie database Programming Web Development by diafol Did my GROUP CONCAT DISTINCT query not work for you? Re: Concat is not working in inclause Programming Databases by pritaeas `CONCAT` is a string function, am surprised you even get that one row. The query you get is: select c_id,c_name from category where c_id in ('870,854'); My guess is that the string is being casted to an int again, resulting in 870. Re: Group of Death Simulation Programming Software Development by StuXYZ Group of death is directly dependent on the host nation, it would not be if the host nation didn't get put as the first team in the A group. If the host nation is a cat 3 team, no cat 3 team can play each other, but if the host nation is say a 1, then two things happen, a single 3 is going to either met the host nation or one of the other 3s. … Re: Group Discussions Community Center Meta DaniWeb by Dani Group discussions are definitely something that I want to improve on in the near future, but unfortunately I'm devoting my time elsewhere right now. However, do expect a massive overhaul of discussions in a not-so-far away time. Re: is order by and group by the same? Programming Databases by chrisbliss18 "GROUP BY" and "ORDER BY" are very different. "GROUP BY" associates all records together based on a column. "ORDER BY" sorts a alphabetically based on column. Let's create some sample data for a table called Location. [code]name | state | city --------|-----------|--------------- Joe | … Re: Please help me in a trouble with Oracle Express 10g Edition Programming Databases by urtrivedi group by is used to aggregate you data, you dont need group by so remove group by clause from your query. following is your query [code] SELECT Dname, Dnumber FROM DEPARTMENT [/code] Re: Sql group by error in inner join please help me............ Programming Software Development by Santanu.Das Group By clasue always produce a count or summation of another field. It never shows other feilds, if you tried to so the values of other fields without aggregating them it shows an error message. If you want to group by with a single field you only can get the aggregated fields. The syntax should be select p.prtgst,sum(prd.totaltaxamt)… Re: PHP Mysql Query for order by first and then group by Programming Web Development by Lsmjudoka GROUP BY isn't intended for use like this, it's supposed to be used with a MySQL function like COUNT() or MIN() to return information about a resultset from multiple rows. If you want everything sorted by publisher name first, then by time, you simply need to run the query ordered by two columns: SELECT * FROM `table` WHERE `time` >= '… Why is the ListView box showing same headings twice? Community Center by Papa_Don Group, I've written some code to populate a listview using 3 fields from a database. When creating the listview, I named the individual columns for appearance purposes, (Account No, Company Name and Name). Those columns are being populated appropriately as expected. However data column names are being shown in column 4 5 and 6, but with no … VBA in Excel - Check for Groups Programming Software Development by Papa_Don Group, I'm trying to improve a macro in an EXCEL spreadsheet. The spreadsheet has multiple tabs (sheets), some of which have grouped rows in them. My "cleanup" routine needs to check to see if these grouped rows exist. Is there some code that does this (hopefully boolean)? If it helps, I'm using the following code to group: …