Search DaniWeb - queries

Re: Question/Answering over SQL Data Using LangGraph Framework 2 Weeks Ago by Pelorus_1 Through its combination of natural language processing and structured query generation, LangGraph makes interfacing with databases and extracting insights over SQL data easier than ever. Re: How Does Google's BERT Algorithm Affect Modern SEO Practices? 1 Month Ago by bngwebguru … shift towards understanding natural language and user intent in search queries. It demonstrates how important it is to create high-quality… practices should prioritize content that directly addresses user needs and queries. Re: How Does Google's BERT Algorithm Affect Modern SEO Practices? 1 Month Ago by scope_2 …, which rewards well-structured, high-quality content. Long-tail, conversational queries perform better, which reduces the effectiveness of keyword stuffing. Featured… providing clear, informative, user-centric content that naturally answers search queries to rank higher. SEO success now depends on the quality… Re: What is MUM algorithm? 2 Months Ago by IM Tools Google's Multitask Unified Model (MUM) is an AI model replacing their old BERT algorithm. It is "multi-modal" processing images, videos, audio, and text in 75 languages. It can also understand the "context" of queries. Re: How would we poison AI web crawls? 2 Months Ago by Dani > I guess AI is replacing traditional search engine queries? ChatGPT traffic still doesn't surpass Google, but it's definitely way up there. I believe it's heading in that direction, yes. Re: SAP db - how to get the time update statistics was performed on a table? 2 Months Ago by peol To check when update statistics was last performed on an SAP table, use database-specific queries! For SAP HANA, check M_TABLES.LAST_COMPILED. In SQL Server, use STATS_DATE. For Oracle, check DBA_TAB_STATISTICS.LAST_ANALYZED. In DB2, use SYSCAT.TABLES.STATS_TIME. Stay optimized, stay ahead! Re: How Does Google's BERT Algorithm Affect Modern SEO Practices? 2 Months Ago by MasoodDidThat …. This update focused on understanding long-tail keywords, full-sentence queries, and keywords containing prepositions such as “for” and “to.” SEO… Re: Multiple MySQL connections + transactions 1 Month Ago by Reverend Jim … you require a separate connection object for each one. Since queries go through the connection object you can't run a… Re: ‘Advanced AI should be treated similar to Weapons of Mass Destruction’ 2 Months Ago by rproffitt UPDATE: Feb 4, 2025 — Google on Tuesday updated its ethical guidelines around artificial intelligence, removing commitments not to apply the technology to weapons or surveillance. Queries exported to separate files file. 10 Years Ago by engrjd91 Hello friends. I have 5 php files having bunch of Inline Queries. I am trying to pluck all the queries from those files and put them in the seperate php file. When I tried to do so, the variables called in the queries are only defined in those files. So its giving me the error of unknown variables. Can anyone suggest me the solution? Re: Queries exported to separate files file. 10 Years Ago by cereal … not a problem, create the list of queries: <?php return array( "query_cities… ); Then require the list: <?php $list = require './queries.php'; # query cities $param = array( $_GET['city_id'] );… Queries in datagridviews 14 Years Ago by Quazy … have a datagridview, and I would like to run some queries (fill queries). when I run a fill query, my dataggridview show… queries inside Enterprise manager 11 Years Ago by mwenyenia07 I am using Oracle enterprise manager 11.2.0.1.0 and very new to oracle in general. Is there a way to write custom sql queries write inside Enterprise manager. I know Tools like sqlplus and Sql Developer can but I desire to use EM since it is browser based. Thanks. queries from multiple database derby 11 Years Ago by Lewin Villar … anf its colums CustID, total I would like to makes queries from data in both of these database. I tried SELECT… Re: queries inside Enterprise manager 11 Years Ago by MaxPayne26 hi, Go to Home>SQL>SQL Commands..here u can write SQL queries Queries in storm maven 9 Years Ago by sassy_94 … array of integer frequencies and i want to run some queries on that array, but i don't have any idea… Re: queries for a search 15 Years Ago by drjohn Have you tried feeding these queries directly into the database, not generating them / choosing them via your php code? You should always start by checking the query itself is correct, then using the php to choose which of your now tried and tested queries to use. Re: queries for a search 15 Years Ago by rukshilag … combine the results of two tables.[/QUOTE] here are my queries - they are giving me a lot of trouble [CODE]//all… Re: queries for a search 15 Years Ago by pritaeas If your tables are indeed exactly the same, you can do something like this: [code] select * from course_participant where name LIKE '%$q%' UNION select * from past_participant where name LIKE '%$q%' [/code] BTW, a lot of your queries are missing FROM... Re: queries for a search 15 Years Ago by rukshilag u mean use phpmyadmin is it? it seems that some of the queries are similar to eachother so some dont run. i changed the arrangement n the ones that ddnt work, work n working ones dont.. Use Parameterized Queries to Avoid SQL Injection Attacks 12 Years Ago by Reverend Jim …result in one or more comments like "use parameterized queries to avoid SQL injection attacks". I won't …do here is give two examples of how to create queries using parameters. The first example uses SQLDB and the … handle the embedded ' One more note - many people write queries that spew out over many lines with no formatting and… multiple queries in one page 14 Years Ago by mpc123 … to show these. How would I make these 10 queries give a result faster than using the example code 10…field names. An example of 1 of the queries is below, all queries come from the same database and table just …slightly different fields. How would I make these 10 queries give faster results. [code=php]<?php $con; $result = … Merging two queries 14 Years Ago by MargateSteve … output records from both in one html table. The two queries are [CODE]SELECT *, COUNT(CASE games.competition WHEN 1 THEN…some sample data, at the end of the post. Both queries work fine on their own but I need to merge… do is perform aggregates between what is currently the two queries, for example, SUM(tmins / tgls) but I would imagine that… How to connect queries from SQL Server 2005 to VB.Net Windows application 18 Years Ago by quiptro …, I have a database with 15 tables and couple of queries created in SQL Server 2005 and I am making a… / DataGridView controls. However I cannot find the queries in the Data Set. The queries exist in the solution but I can't… used for the tables. Can I somehow connect the existing queries to the form? Thanks, Robert How to connect queries from SQL Server 2005 to VB.Net Windows application 18 Years Ago by quiptro …, I have a database with 15 tables and couple of queries created in SQL Server 2005 and I am making a… / DataGridView controls. However I cannot find the queries in the Data Set. The queries exist in the solution but I can't… used for the tables. Can I somehow connect the existing queries to the form? Thanks, Robert MySQL Queries 14 Years Ago by poloblue … I should implement 6 queries within the database that I have created. The queries that should be implemented …:20:00', NULL, NULL);[/CODE] Here are the queries that I implemented but got rejected by the professor […, AVG(Time) FROM pvarrays GROUP BY ArrayIdNo; // NESTED QUERIES SELECT COUNT(*), SUM(Time), MAX(Time), AVG(Time) FROM… multiple sql queries with values from an array 13 Years Ago by mbarandao … the process by creating an array from which the following queries gets their conditional values. [CODE] $SQL = "…GDS34','RFFD43','TF42DC')[/CODE] Now I have two subsequent queries that relies on variables from the preceding query, …here are those queries Denoted as [COLOR="Red"]Q1[/COLOR] … Re: Use Parameterized Queries to Avoid SQL Injection Attacks 12 Years Ago by diafol >Please note the format I use. The queries are spread over several lines. I'm seeing single line snippets. Or did I miss something? Re: Use Parameterized Queries to Avoid SQL Injection Attacks 12 Years Ago by G_Waddell … using a Microsoft SQL Server database: 1. Don't build queries on the fly - use only stored procedures, it forces you… Re: Use Parameterized Queries to Avoid SQL Injection Attacks 12 Years Ago by adam_k … we had this conversation already? Anyway, I agree with parameterized queries but use them with stored procedures as G_Waddell is saying…