|
I have a biology database that I would like to query. There is also a given terminology bank I have access to that has formalizable predicates. I would like to build a query language for this DB using the predicates mentioned. How would you go about it...
Started by Dervin Thunk on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Www.i2b2.org), it's a graphical query language and query engine platform for patient databases in there, you'll see how they approached SQL generation from a clinical graphical query language in an interestingUse BNF....
|
|
I'm starting to use LINQ as a true query language in code to help improve readability. Until recently I was afraid to touch LINQ because of the LINQ to SQL team move under the Entity Framework team (trying to ignore that conversation here) -- will LINQ...
Started by Toran Billups on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I personally lean more.
Var query = from it in someCollection select it.SomeProperty;
I can write the 2.0 framework and is compatible with the query syntax used in the compiler.
Have query syntax.
|
|
I'm trying to write an HQL query which will calculate an average rating for an item. I want the query to return 0 instead of null when there are no rating for a given item - so that I can use my query as a subquery. So is it possible? Is there an HQL ...
Started by Michał Bendowski on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Check http://docs.jboss.org/hibernate/stable/core/reference/en/html/queryhql.html
If nothing....
Example:
COALESCE(id_pati, 0)
Link Wikipedia
Nhibernate docs are out of date.
It returns the first non-null of its arguments.
COALESCE is the official equivalent.
|
Ask your Facebook Friends
|
Is there a (roughly) SQL or XQuery-like language for querying JSON?
I'm thinking of very small datasets that map nicely to JSON where it would be nice to easily answer queries such as "what are all the values of X where Y > 3" or to do the usual SUM...
Started by allclaws on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
I too don't really see a....
I'm not convinced that the bloat of a query language would be beneficial.
Arrays don't have a query language (that I know of) but they have a lot of methods/functions that can for the most part).
|
|
Hello friends. At present i am doing a project regarding SQL injection. I am doing it in such a way that it will find the SQL injection independent of the server side scripting.. whether it may be jsp or asp or php. Now the major problem is I have to ...
Started by DG on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The sql query must; // this will not produce any SQL query from c in ColumnsOf( db.Products ) where c.Contains( "Name" ) select c.Type; //....
The problem with searching the SQL queries in code is very complex and I think imposible.
|
|
Hello.
Suppose I have a set of directed graphs. I need to query those graphs. I would like to get a feeling for my best choice for the graph modeling task. So far I have these options, but please don't hesitate to suggest others:
Proprietary implementation...
Started by Dervin Thunk on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
That will give you best performance do you expect to query....
Pick a couple of general-purpose graph libraries and solve your particular task in a programming (not query!) language.
query language to solve graph problems.
|
|
I'm looking for a builder for HQL in Java. I want to get rid of things like:
StringBuilder builder = new StringBuilder() .append("select stock from ") .append( Stock.class.getName() ) .append( " as stock where stock.id = ") .append( id );
I'd rather have...
Started by Sébastien RoccaSerra on
, 11 posts
by 9 people.
Answer Snippets (Read the full thread at stackoverflow):
First you create are not unique across all....
To do your above query possible through the Criteria API, but a sub-query should accomplish the same thing.
It looks like you want to use the Criteria query API built into Hibernate.
|
|
In MySQL it's like:
select * from table1 where column1 in ('a','b','c');
how to do that in GQL?
Started by Shore on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
It seems everything is in here
You can use one of the following
result = db.GqlQuery("Select __key__ from model where column in ('a','b','c')")
or
result = db.GqlQuery("Select * from model where column in ('a','b','c')")
The call with _ _ key _ _ is ... .
|
|
In R , how can I import the contents of a multiline text file (containing SQL) to a single string?
The sql.txt file looks like this:
SELECT TOP 100 setpoint, tph FROM rates
I need to import that text file into an R string such that it looks like this:...
Started by Tommy O'Dell on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Try paste(sqlString, collapse=" ") The versatile paste() command can do that with argument collapse="" :
R> lines <- readLines("/tmp/sql.txt") R> lines [1] "SELECT TOP 100 " " setpoint, " " tph " "FROM rates" R> sqlcmd <- paste(lines, ... .
|
|
Posted 07 February 2010 - 02:30 AM
I have had a fruitless search both in Google and the forum, but I am sure someone must have thought of this. Lets say you are travelling to Spain and you want to translate cache listings from Spanish to English. Google...
Started by billyrover on
, 11 posts
by 7 people.
Answer Snippets (Read the full thread at groundspeak):
BTW, you might be surprised how frequently ....
Can run a PQ through language translating soft/web page to get a English(ish) version of the PQ a split screen with the language of your choise (of those supported) in each pane of the screen.
|
