Need help running 2 queries in a Cursor PLSQL
variables,plsql,cursor,records,sys-refcursor
In the first cursor, you are selecting 5 columns - OPEN cv_prod FOR Select dd_payment.idpay, dd_pledge.idpledge, dd_pledge.iddonor, dd_payment.paydate, pledgeamt/paymonths In the second cursor, you are only selecting 2 columns - OPEN cv_prod FOR Select dd_pledge.idpledge, sum(pledgeamt/paymonths) Both these cursors are fetched into a variable of the same type which is...
Can I implement a record as a class in programming languages that uses it? [closed]
Of course you can. If you are referring a record just like a row of record from the database: Student Record in database: Student Name: Alice Student ID: S001 Gender: F Student in Struct (Implemented in C) struct Student { char name[MAX]; char id[MAX]; char gender; }; struct Student stud1...
MySQL: Missing some records in mysqlimport
How are you checking the "count of records" in the invoices table? Obviously, we're assuming that you're executing a SQL statement like this: SELECT COUNT(*) FROM invoice ; And that you aren't relying on the estimated number of rows in information_schema.tables to give you a precise count. There's not enough...
Mysql Query to find specific rows for which the particular column value don't exist
select orderid from data group by orderid having sum(ordertype in ('Returned', 'Adjustment')) = 0 and sum(ordertype = 'Refund') > 0 and sum(ordertype = 'Order') > 0 or just select orderid from data group by orderid having sum(ordertype not in ('Refund', 'Order')) = 0 and count(distinct ordertype) = 2 ...
how to retrieve duplicate records and delete them in table A, also insert these duplicate records in another table B (in postgres)
postgresql,delete,duplicates,records
To delete duplicates without having a unique column you can use the ctid virtual column which is essentially the same thing as the rowid in Oracle: delete from table_A t1 where ctid <> (select min(t2.ctid) from table_A t2 where t1.unique_column = t2.unique_column); You can use the returning clause to get...
sql left join returns
sql,left-join,condition,records
As soon as you put a condition in the WHERE clause that references the right table and doesn't accommodate the NULLs that will be produced when the join is unsuccessful, you've transformed it (effectively) back into an INNER JOIN. Try: where B.fixed = 'b580' OR B.fixed IS NULL Or add...
PHP function running on every refresh
After submitting the form: if(isset($_POST["submitTask"])){ insertTask(); header("Location:your_form_page.php"); } This redirection will clear all form submissions as page is redirecting, no form will be submitted....
Libre Office Base: Unable to change or save records in form
libreoffice,records,designmode
Tables in LibreOffice Base need a primary key. Only then you can change and save records.
Erlang. Records. Existing of field
You can use record_info(fields, Record) to get list of record fields. You need to know that records and this function is a little bit tricky. Records are translated to fixed size tuple during compilation and pseudo function record_info is added. #robot{name="Crusher", hobbies=["Crushing people","petting cats"]} becomes: {robot, "Crusher", industrial, ["Crushing people","petting...
Grouping similar records with php
php,postgresql,loops,grouping,records
Ok, so I eventually solved this... esentially this is the code below; improvements welcome :) You need to call the function like so related(array('searched'=>array(),'tosearch'=>array(13))); function: public function related($input){ $searched = $input['searched']; $ar = array(); $bits = array(); if(count($input['tosearch']) != 0){ $get = Easytest::orWhere(function($query) use ($input) { foreach ($input['tosearch'] as $k=>$v)...
Duplicate record from file input [duplicate]
The file need to reach EOF for eof() return true. If there is a white space after the last value you won't reach the EOF till the next read try. you can check if each read has succeeded like this: if(!f>>value) break; or iterate till >> operator will failed like...
Compare 2 tables and add missing records to the first, taking into account year/months
sql,compare,records,missing-data
You can generate the missing records by doing a cross join to generate all combinations and then removing those that are already there. For example: select fd.fulldate, c.D_ACTIECODE from (select distinct fulldate from fact_quantity_tmp) fd cross join (select D_ACTIECODE from C_DS_BD_AP_A) c left join fact_quantity_tmp fqt on fqt.fulldate = fd.fulldate...
SQL - Need to populate sequences for records
For the XXXX part, I think you want row_number(): select 'insert into part_map_set (serialnum, grp, part, offer) values (' || row_number() over (partition by part order by part) ||', ''' || part ||'_grp'', ''' || part || ''', ''' || offer || ''');' from part_map; There may be other reasons...
Displaying certain records from MySQL statement
[Per your edited post] you need to JOIN with both table and Add a ORDER BY Price DESC in your SELECT statement; like select p.`prod_id`, p.`prod_name`, p.`price`, s.`company_name`, s.`phone` from products p join suppliers s on p.supp_id = s.supp_id order by p.`price` desc; ...
How can I get the top N records of a MySQL table by excluding an array of groups?
php,mysql,performance,order,records
You can do this with a LIMIT clause, all you have to do is make sure your WHERE clause filters out categories you don't want. Try this: SELECT * FROM myTable WHERE category NOT IN(category, list) ORDER BY popularity DESC LIMIT 3; The way you'll pass in the list is...
adding text from html input as value into mysql with php
This: <input type="submit" name="button1" value="Send"> needs to go inside your first form, where your other inputs are. <form name="form" method="post"> <input type="text" name="nick"> <input type="text" name="message" height="300px"> <input type="submit" name="button1" value="Send"> </form> And also @Joe T's answer. Many problems wrong with this question it seems...
Count number of special character combination of delimiters
awk,special-characters,aix,records
Using \\ instead of \ works for me. Not sure why exactly. Probably related to how escape characters are interpreted in bash, awk and awk's regex engine but I'm unable to give a good explanation. $ cat test name | ^surname| ^age | ^city | ^country john | ^doe |...
MySQL: get oldest record from most recent group
If I understand what you're asking correctly, you could use EXISTS to eliminate all but the most recent locations per person, and get the min date from the resulting rows. SELECT person_id, location_id, MIN(start_date) since FROM status s WHERE NOT EXISTS ( SELECT 1 FROM status WHERE s.person_id = person_id...
Viewing Nested Records in Rails Console
ruby-on-rails,database,ruby-on-rails-4,console,records
If you want to view all subarticles to one particular Article, you just need to assign it to a variable: a = Article.find(1) - this will assign Article with id = 1 And then call: a.subarticles - this will show all subarticles associated with your Article...
Creating records in mysql
Follow this question for importing data from CSV to mysql. You have to have two tables origins and distinations or better yet create temporary tables origins and distinations. Once you have imported data in mysql, You can get your result by applying cross product on both tables like this INSERT...
XML use XSL to transform a list of records
Here’s a simple stylesheet that checks whether an ID is within an approved list of IDs and uses a “display name” for it in the output. <?xml version="1.0"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0"> <xsl:variable name="desired-ids"> <id name="rd_bl">Red to Blue</id> <id name="pu_gr">Purple to Green</id> </xsl:variable> <xsl:template match="root"> <root> <xsl:apply-templates /> </root> </xsl:template> <xsl:template...
find the unique record on two columns in oracle
You could just write a simple where clause which defines your need. Eg: select distance from TABLE_NAME where ( ("from" = 'Bangalore' and "to" = 'Hyderabad') or ("from" = 'Hyderabad' and "to" ='Bangalore') ) and rownum <= 1 http://sqlfiddle.com/#!4/0fc987/4...
Displaying records with date from current week CakePHP
Try this: $week_start = date('Y-m-d', strtotime("-1 weeks")); $week_end = date('Y-m-d'); $conditions = array( "From >" => $week_start, "From <=" => $week_end, ); ...
Dynamically allocate an array of structs with C++
c++,arrays,dynamic-memory-allocation,records
Well, first up, you're allocating two arrays: bookArr = new Book[arrN]; // <-- leaked bookArr = createRecord(arrN); That's a memory leak. Secondly: (bookArr[i]).title = new char That is allocating one single char that you're trying to copy a whole string into. That should probably be: // two lines please! bookArr[i].title...
How to Pre-populate An Android Database Backed by ContentProvider
android,sql,database,insert,records
obviously ContentProvider is the favored route to go for an Android database You are welcome to your opinion. how does one efficiently populate the resulting database? In terms of pre-population, you would do it the same way that you would pre-populate a database that is not fronted by a...
How many records / rows / nodes is alot in firebase?
database,firebase,real-time,records
I'm quite sure Firebase can return 500k nodes without a problem. The bigger concerns are how long that retrieval will take (especially in this mobile-first era) and what your application will show your user based on that many nodes. A list with 500k rows is hardly useful, so most likely...
Records in PureScript
The Object type constructor is parameterized by a row of types. In kind notation, Object has kind # * -> *. That is, it takes a row of types to a type. ( value :: Number, values :: [Number] ) denotes a row of types (something of kind # *),...
Selecting unique line problems
>>> s1 = open('s1', 'r').readlines() >>> s2 = open('s2', 'r').readlines() >>> s1Codes = [x.split()[0] for x in s1] >>> s2Codes = [x.split()[0] for x in s2] >>> newCodes = [code for code in s2Codes if code not in s1Codes] >>> print (newCodes) 192.168.1.3 Or if you would like to stick...
Segmentation fault when writing data to a dynamic array
c,file,struct,segmentation-fault,records
Well, you get a segfault because you haven't allocated memory for the first entity in your records. So to resolve that you need to records[size-1] = malloc(sizeof(Records)); To put it in this way: You have records that is a pointer to a pointer to Records. When you did records =...
automatically renewing records when the last day of year
sql,document,records,auto-renewing
You count the existing documents for the same year, then add one. So if you want to store a document that belongs to 2013, you first count how many existing documents you have in 2013, then add one. I can't write the sql for you, because you haven't described the...
Getting all records in a set using the Sickle package
Be sure to read the short and sweet Tutorial. For harvesting an entire OAI-PMH repository, you do not need to iterate over sets. Here is the complete code: from sickle import Sickle sickle = Sickle('http://www.duo.uio.no/oai/request') recs = sickle.ListRecords(metadataPrefix="oai_dc") for r in recs: print r If for some reason you really...