» Home » querying » Page 1
Querying database vs Querying IQueryable in order to create auto-complete functionality
Category : Programming Languages

I have a texbox control in my wpf application where I will like to get a auto complete listbox as the user types in. In other words I have something like google's search box:

I have managed to do that in two ways and I will like to know which one is more efficient.

First way:

As user types into the textbox every time the texbox changes I update the list

View Replies

How do I design the interface for querying if an optional field is involved as part of querying
Category : Coding

How do I design the interface for querying if an optional field is part of the record.

Record contains (name, foo_type, bar_type, value)

foo_type could be foo1, foo2
bar_type is either bar1, bar2 and is valid only for foo1, if foo2 is stored the value of bar_type is always null.

I would like to filter records which are by a certain bar_type

View Replies

Querying minimum value in SQL Server is a lot longer than querying all the rows
Category : Network & Servers

I'm currently confronted with a strange behaviour in my database when I'm querying a minimum ID for a specific date in a table contains about a hundred million rows. The query is quite simple :

SELECT MIN(Id) FROM Connection WITH(NOLOCK) WHERE DateConnection = '2012-06-26'

This query nevers end, at least I let it run for hours. The DateConnection column is no

View Replies

Querying associated images in one table after querying products from another
Category : Programming Languages

I used this code to connect to a database and fetch results. This worked perfectly until i tried to work in another query to the images table to get associated images. I'm not very experienced with OO programming. So hopefully someone can see where ive gone wrong and help me out.

global $__CMS_CONN__;
$sql = "SELECT * FROM ecom_products";

View Replies

Querying mongodb - Using limit vs re-querying
Category : Coding

The scenario is that:

I am querying for data (duh!)

Potentially filtering some out server-side because to query exactly is not possible/reasonable i.e. complex query

The database may be under considerable load. There may be numerous parallel requests including updates.

So, I could

a) Not limit() the query and just keep streaming data u

View Replies

Querying for not None
Category : Programming Languages

I have a model with a reference property, eg:

class Data(db.Model):
x = db.IntegerProperty()
class Details(db.Model):
data = db.ReferenceProperty(reference_class = Data)

The data reference can be None.

I want to fetch all Details entities which have valid data, ie for which the reference property is not None.


View Replies

TAGS : Querying None

querying csv with vbs
Category : Programming Languages

There's a csv file like so, I can read it easily enough with the code below. But as you can see there are multiple name1, group1, status1, name2, group2, etc columns in the csv. Each user will have a different number of columns. I was wondering if there is a way to use wild cards where I'm calling objRecordset.Fields.Item("Group1") something like ("Group%") or if I can

View Replies

TAGS : querying with

querying rdf triples
Category : Coding

How can I write sparql query where I can compare the variables (?a, ?b), if I have the following eg? (something's wrong with this eg?):

<ont:XXXXX rdf:about="http://www.myOntDomain#C">
<ro:part_of rdf:resource="http://www.myOntDomain#A">
<ro:part_of rdf:resource="http://www.myOntDomain#B">

This doesn

View Replies

TAGS : querying triples

Querying RDF using SPARQL
Category : Coding

Hi I am referencing the material on http://www.dotnetrdf.org/content.asp?pageID=Querying%20with%20SPARQL,
and I need a way to read the content of an RDF file using SPARQL.

How can I set the path for an exsiting RDF file?

Many Thanks,

View Replies

Querying NHibernate
Category : Databases

We are using NHibernate as our ORM for the project and we have only database read only feature. The application will not be updating,deleting or inserting any records into the database it will be just querying the database for records.

My question is which is the best method to query the database with NHibernate in the scenario explained above.

View Replies

2012 / 2017 Copyrights BigHow , All Rights Reserved .