Questions tagged [querying]
516 questions
0
votes
1 answer
How to query for grouped results in Access, based on count of time and day of week?
I have a table in an Access 2013 database, which has many rows of incidents, each of which has a "time" column and a "day_of_week" column. I need to query for a result set that shows a count of incidents during hourly time ranges from 6:00am-5:00pm,…
perspiringprogrammer
- 11
- 1
0
votes
1 answer
How to Query ">", "<" and "<>" in Lucene
Is is possible to query like : age>23 in lucene?
I have been looking into it but I couldn't find anything, can someone guide me through in this regard?
user2742299
0
votes
1 answer
Entity framework sqlquery
I read about querying database using the entity framework
var result = _dbContext.SqlQuery(sql, someParamSqlParameter).ToList();
What if i wanted multiple columns to be returned how could i write that type of query.
I tried this code but it…
Murtaza Munshi
- 1,065
- 4
- 13
- 40
0
votes
1 answer
Querying database with an array of related objects in laravel
I would like to query some offers by skills from my database with laravel.
The relationship between an offer and its skills is a belongsToMany relationship.
How to get all offers that match an array of skills from the database ?
To be clearer here…
Yukulelix
- 1,072
- 2
- 13
- 19
0
votes
1 answer
Generic query in SQLAlchemy
I have following code:
class ArchaeologicalRecord(Base, ObservableMixin, ConcurrentMixin):
author_id = Column(Integer, ForeignKey('authors.id'))
author = relationship('Author', backref=backref('record'))
horizont_id = Column(Integer,…
Alex G.P.
- 9,609
- 6
- 46
- 81
0
votes
2 answers
Breaking down a large number of rows into smaller queries? Parallelism
I want to create a external application which will query one table from a large Oracle database.
The query will run daily and I am expecting to handle 30,000+ rows.
To break down the size of these rows, I would like to create a new thread/ process…
tomaytotomato
- 3,788
- 16
- 64
- 119
0
votes
1 answer
HSQLDB : Get table indices
I need a way to find out if a present table in HSQLDB has any indices, and if so, fetch their detailed information (column_name, type, isPrimary ...etc)
jadkachmar
- 118
- 10
0
votes
1 answer
solr: how to search for date ranges with at least X days?
Given: a list of consultants with a list of intervals when they are NOT available:
1
2013-01-01 2013-01-10
…
Marcel
- 3,749
- 6
- 29
- 35
0
votes
1 answer
Ruby Rails Query In conditional
I have this query that works but I would like to expand it so that I can check for multiple ids such that I pass in a vector of ids. [1,2,3,5] etc... I have tried using SQL IN with no luck.
EventType.find(3).events.all(:include => {:sheet =>…
user2434674
- 520
- 1
- 8
- 19
0
votes
1 answer
Is it possible to query for a range of hashes of a hashed indexed key in mongodb?
I have a hashed based sharding enabled for a key "userId" in a mongodb collection. Is it possible to get all documents whose hashed values of "userId" are between, let's say, "abcd" and "cdef"?
Thanks!
Vyacheslav
- 1,186
- 2
- 15
- 29
0
votes
1 answer
How to count the number of incoming calls a specific number has in callLog.calls? ANDROID QUERY CALL LOGS
I have a phonestatelistener which retrieves the incoming call number
what i want to do is to have that certain number queried and checked in the callLog content provider and get the number of incoming calls that specific number has made on a…
Don JedStryker
- 61
- 2
- 7
0
votes
1 answer
How to query for objects that are not already in an array (refreshing for an array) using parse.com service?
I have a table view that is being populated with an array that is holding strings. This array receives its data from a cloud database on parse.com. It populates successfully in the beginning. I have a refresh button at the bottom of my view…
Sam D20
- 2,535
- 5
- 25
- 43
0
votes
3 answers
two mysqli connections simultaneously
I tried to alter OOP script presented here:
to handle two databases at once (depending on function needs), but it seems not to work at all. I get an error message:
mysqli_query() expects at least 2 parameters, 1 given in ...DAL.php on line…
jakubplus
- 307
- 4
- 17
0
votes
3 answers
Querying the id of an entity using linq
In the following method I am trying to fetch the Username by passing the id value where the ids passed as parameter can be multiple values as in csv's (eg: 1,2) and are returned to the calling function as IEnumerable.
Code Follows as below…
Sumit
- 13
- 4
0
votes
1 answer
How to project a navigation property using Linq to Entities?
I have a database constructed using code first. I found that querying using projection into a concrete type is by far the fastest method, faster than using Include statements. I run into the following problem however:
dim records=(From record in…
Dabblernl
- 15,831
- 18
- 96
- 148