Search DaniWeb - query

Handling Real-Time DOM Sync in SSR React App with Dynamic Nested Routes 3 Weeks Ago by Neil_brown001 … from the parent. To add complexity, I'm using React Query for client-side data fetching (with staleTime optimization), and Zustand… Re: Data storage and retrieval - cache or database 2 Weeks Ago by jonathannweyer If the "status" doesn't change frequently, caching is a solid option. You could fetch it from the database the first time it's needed, then store it in a cache (like in-memory or Redis, depending on your setup), and use that for subsequent loads. Re: Question/Answering over SQL Data Using LangGraph Framework 1 Month 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. DeepSeek R1 vs Llama 3.1-405b for Text Classification and Summarization 2 Months Ago by usmanmalik57 … the Fireworks model path, the system instructions, and the user query and generates the response. Reasoning models like DeepSeek return the… Re: Multiple MySQL connections + transactions 1 Month Ago by Reverend Jim … go through the connection object you can't run a query on more than one db at a time. It seems… Re: Query help 14 Years Ago by mwasif Query to create index on Date field [CODE=mysql]ALTER TABLE TIME_TABLE ADD INDEX record_date (record_date);[/CODE] Query Runs in mysql but not in PHP 13 Years Ago by abhi10kumar … an error when I run in PHP here is the query [CODE]select p.pid as pid, s.sid as sid… query to find the 10th maximum salary 18 Years Ago by superhuman Query to find the 10th maximum salary from an employees table which contains empno,empname,empsal as columns.If this table contains n number of records,how to determine the 10th maximum salary Re: query help date time 13 Years Ago by ppohlmann … .. but it is "phped" .. $query= "SELECT * FROM usrteams JOIN games ON (trim(usrteams.team)=… Re: query optimization in sql 16 Years Ago by cgyrob Query optimization is the process of optimizing the performance of a query to utilize as little system resources as possible. Re: query 17 Years Ago by ceyesuma …for you. 9.1. Query API A query in Java Persistence is …Show All [code] package javax.persistence; public interface Query { public List getResultList( ); public Object getSingleResult(…( ); public Query setMaxResults(int maxResult); public Query setFirstResult(int startPosition); public Query setHint(String hintName… query 17 Years Ago by ceyesuma ….SplashApp.class).getContext().getResourceMap(SplashView.class); query = entityManager.createQuery(resourceMap.getString("query.query")); // NOI18N list = org…private javax.swing.JProgressBar progressBar; private javax.persistence.Query query; private javax.swing.JButton refreshButton; private javax.swing… Re: query 17 Years Ago by ceyesuma … instances, to find entities by their primary key, and to query over entities. The set of entities that can be managed… Query Help 15 Years Ago by rukshilag …$result = mysql_query($sql); $num_rows= mysql_num_rows($result); } //another problem query - all records of both tables if($course=='all') { $sql =…mysql_query($sql); $num_rows= mysql_num_rows($result); } //course and completion - problem query if($course!='blank'){ if($cs=='yes'){ $sql = "select *… Query Help 15 Years Ago by CFROG …m stumped. I echoed all the variables immediately before the query and they hold the same values that I use from…the command line and get results. I also echoed the query itself just to be sure and everything is there. Here… is the query. [code] $flat=("SELECT C.Latitude, C.Longitude FROM … Re: Query 15 Years Ago by Airshow …QUOTE=Mike516;1144408]... executing a query in javascript...[/QUOTE] If you mean an SQL query then it will typically be performed… be used to perform an SQL query though Javascript could initiate such a query via Ajax (or possibly ActiveX) …and receive back the query's result as a response. [QUOTE=Mike516;1144408]...… Query help 16 Years Ago by tambia Is there anyway to have (in one query) two separate queries? For example if query one fails then it will not affect the… to get the second line to execute (in a single query) even though the first line would cause an error? Query Help 16 Years Ago by Shuco … on the first queries and the following queries. [B]Next query:[/B] I want to find data that does not match… mismatch last name and SSN next to them. [B]Next query [/B] I want to take all the records that do… for all record and output a total deduction. [B]Next Query.[/B] I want to output all records that match 100… Query Help 14 Years Ago by lm111 … to convert the above function to a query. I'm trying to use the query below but it's not finding a… other char characters. Any idea how I can modify the query below to incorporate the AsciiToString() function? Thank you so much… Query Help... 12 Years Ago by dwdata I have a starting query that displays appointments and I am trying to expand to …) Based on the returned set of rows from the above query, I want to only show THE EARLIEST appt (based on… this can be handled via a JOIN in the original query or if need to do a SUB-SELECT. Any assistance… Re: Query Help 15 Years Ago by almostbob …; */ ?>[/code]I dunno but there has to be a query in there doesnt there? Re: Query Help 15 Years Ago by almostbob [QUOTE=CFROG;1014701]DOH! Okay, let's both just walk away from that one and pretend like it never happened.[/QUOTE] I ran it through a syntax checking editor Syntactically the first one is correct code each line was right in itself It took asking my 18 year old for a hint, he just said "whats the query?" and left :( query 17 Years Ago by kings … tell me wat should i use eg i have a query [ICODE]SELECT * from post_resume WHERE ind_type='IT'and career='Engineering… to know how to combine all three condition into one query...... Query 16 Years Ago by WindFantasyZ …->ip,searchVar) == 0) { cout<<"Found the query" <<endl << p->uri <…->uri,searchVar)==0) { cout<<"Found the query" <<endl << p->ip <… Re: Query help 16 Years Ago by varmadba How will you run 2 separate queries in a single query UPDATE userInfo SET lastLogin=3 WHERE id=5 UPDATE userInfo SET LastLogin=3 WHERE id=5 These are 2 update statements.if you want to run them in a sequence put SEMI COLAN at the end(;) that way even the first fails the rest will execute Query help 16 Years Ago by dottomm … in advance for anyone who can help me with this query. I want to select all from table one and the… matching image from table two. Using the following inner join query works great: [code] $result=mysql_query("SELECT * FROM members inner… Re: Query help 16 Years Ago by dickersonka You can either get the avatar_id from this query Then run an additional query to get the pic, or if you want to consolidate everything in a single let me know, and i'll post one more to consolidate everything. Re: Query help 16 Years Ago by dottomm … is the complete statement [code] //note the * in the first query //this one works, but not if I call the columns… like in the second query. $result=mysql_query("SELECT * FROM members inner join avatars on… Re: Query help 16 Years Ago by dickersonka i meant store the query in a variable, then output it, just to make sure all the semicolons and commas are out there, just as a degub step i think something isn't getting set properly when issuing the query and just want to see it output Re: Query help 16 Years Ago by dickersonka user_id isn't a string is it? if not, it doesn't need the ticks, can you try running it without them? can you try to run the same query in query browser if you have it?