Search DaniWeb - result-set

Re: Cannot run exe from asp.net 3 Weeks Ago by lennyli ….Run(command, 1, True) 'result = objShell.Run(command) 'result = objShell.Exec(command) ' Clean up Set objShell = Nothing ' Output the result Response.Write("Executable… Re: Digital Marketing Strategy for My Website 1 Week Ago by MasoodDidThat … analytics tracking tools like GA4, GSC, and Microsoft Clarity 3. Set up Meta Ads and the Google Ads platform 4. Make… with a low daily budget on Meta and see the result 9. Do the same with Google Ads and analyze which… platform is giving you the best result 10. Audit website technical seo with the help of Google… Re: How to Implement Lazy Loading for Faster Web Portals 1 Month Ago by Dani …-in user see when they enter from a Google search result? (will they miss new posts ?) Whether it's cached via… a different price or / and availability. The same rule applies: Set appropriate Cache-control headers for your use case. If you… 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. Re: Result set objects into an Array. 13 Years Ago by Ezzaral You must call rs.next() to advance through your result set. Initially your row pointer is positioned before the first result. Typically you will use [ICODE]if(rs.next())[/ICODE] or [ICODE]while(rs.next())[/ICODE] to advance while there are records to read. Re: Result set objects into an Array. 13 Years Ago by oldezwe … code. The error I get is "Before start of result set." I have googled syntax of using prepared statements and… Calling result set in result set. 16 Years Ago by vish_1x1 … line ResultSet Rmenu1 = c1.menu1(); which gives me another result set Rmenu1 which have values from database through menu1(); function. But… to while(Rmenu.next()) it gives error as " Result set is closed". Is it so that a there can… be only one result set at a time or is it a threading issue. Please… return result set in SPs 19 Years Ago by Chagh … select satement in an SP?(i want to return a result set from the SP). i want to migrate from SQL Server… gives the error:"procedure foo can't return a result set in the given context MySQL" in the application. can… i set a cursor out put parameter and return it?(just like… Re: Re use Mysql result set in Perl 13 Years Ago by d5e5 I don't think you can re-use a result set with DBI base on this quote from [URL="http://… in the order in which they are stored within the result set. Currently, records cannot be skipped over or randomly accessed. Furthermore… the cursor. That is, cursors cannot step backwards through a result set.[/QUOTE]I think you could do what you want by… Dynamic columns in result set 13 Years Ago by sngapoonage … table and create a column for each one in my result set? Here is the end product I am looking for ie… my result set. When I say dynamic I mean that as more is… How di I get tehe result set from theese joins? 13 Years Ago by klemme … am joining these 3 tables. I am not sure what result-set i get in return or how to get it actually…. This is what I have: (which gives me an empty result set?) [CODE] function lager_styring($connection) { if (isset($_GET['produkt_id'])) { $P_ID = mysqli_real_escape_string… Data source and result set 15 Years Ago by Xessa Hello. I want to execute an insert command when the result of previously select statement is true. Can i use both data source and result set in my method so i can check if the result is null or not. Or is there a way to see if ds is null? stored procedure seems to only return last row of result set 13 Years Ago by spowel4 …to only return the last row of the result set (i.e. if it should return 10… 11/16/2011 20:30:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[NISUS_GetEDIDocTypes…pEntityID char(10), @pEdxDocType varchar(10) OUTPUT AS BEGIN SET NOCOUNT ON; SELECT @pEdxDocType = EDXDOCTYPE FROM [dbo].[… Empty result set 15 Years Ago by dan_ord …, i get the good old message: MySQL returned an empty result set (i.e. zero rows). I've tried breaking down the… email address, and this works fine, i actually get a result. So i've come to the conclusion that its the… Re: Dynamic columns in result set 13 Years Ago by sngapoonage … can just check for null but if possible, can the result set return ones and zeros instead of the column name or… Re use Mysql result set in Perl 13 Years Ago by vaibhav1983 … the entries. Once I am done looping through all the result sets, I have to re-loop over them again. This…. In PHP we have a function mysql_data_seek to resuse the result set. Do we have something similar in Perl? I am using… Re: Re use Mysql result set in Perl 13 Years Ago by d5e5 …($sql, { Slice => {} }) };[/iCODE] puts all the rows of the result set into an array which you can then loop through as… returned an empty result set if columnName = float 13 Years Ago by emily-bcot …[/CODE] After running the above query, db returned an empty result set. But Seen from table, there are many rows matching data… value to an integer like 'where data=2', the matched result sets will be returned. Please let me know if anyone… filter within result set 10 Years Ago by mgreiner28 … need it to refine my search by city within that result set. I have created a simple form to let the user… I query the search correctly in order to get the result that I need? <?php $connection=mysql_connect('***','****','****') or die(mysql_error… MySQL result set and time.h 16 Years Ago by xcesmess … where id = 'kict'; +------+-------------+ | id | last_update | +------+-------------+ | kict | 1218689222 | +------+-------------+ 1 row in set (0.07 sec) [/CODE] The date string you see in… is where I want to convert the time from the result set cout << res[i][0] << " - "… Re: MySQL result set and time.h 16 Years Ago by Ancient Dragon … you are attempting to convert the date/time in the result set to time_t, that is the wrong way to do it… Loop through result set 19 Years Ago by Juls … trying to run a query once and then reuse the result set in a loop to compare so that to know whether… C# program retrieving result set from SQL Stored Procedure 17 Years Ago by sofia24 Hi there! I've developed a program in C# that calls a stored procedure in SQL server. Is it possible for a stored procedure to pass back a result set with multiple rows? If so how do I access these values in my application. Many Thanks! Re: C# program retrieving result set from SQL Stored Procedure 17 Years Ago by sofia24 Thanks! :) I can now access the result set. How to return a mysql result set 16 Years Ago by ryy705 Hello, mysq_query($query) returns a valid result set. However, [CODE] function query($query) { return mysql_query($query); } [/CODE] returns a 1. Why does this happen? Is there a way around it? Thanks in advance. Only Perl Returning Incompletre Result Set 16 Years Ago by consultant1027 …'ve got a Perl program that is returning an incomplete result set. I can output the mySQL call that Perl is executing… Re: caching datasets or result set. what is the the best option? 2 Years Ago by Dani Sometimes it makes sense to cache query results using third-party solutions such as Memcached. For example, querying the database for related topics is expensive, is needed on every page load, and they almost never change. It makes sense for us to cache the result set for each forum thread in something like Memcached. RESULT OF TWO RELATED SETS OF RANDOM NUMBERS 11 Years Ago by mbocks01 …2 to 7 The second random number working set is a set of 4 different integers from the range 4… the second set is added to the result set..eg Set One: 6 5 7 Set One: 10 6 21 18 Result: 6 18…;Arial", 1, 14)); // NOI18N label3.setText("Result:"); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(… Result set objects into an Array. 13 Years Ago by oldezwe … to do. I have attempted user rs.next() with my result sets and for some reason can not figure out how… Re: Empty result set 15 Years Ago by whiteyoh … * FROM members WHERE login='$login'"; $result = mysql_query($qry); if($result) { if(mysql_num_rows($result) > 0) { $errmsg_arr[] = …$db_password = md5($random_password); $sql = mysql_query("UPDATE members SET passwd='$db_password' WHERE email='$email'"); $subject = "…