Search Results

Search found 4685 results on 188 pages for 'queries'.

Page 85/188 | < Previous Page | 81 82 83 84 85 86 87 88 89 90 91 92  | Next Page >

• Creating a Web Service to automatically get information

  - by Sean P

  I want to create some sort of method of creating a web service that will run automatically and run DB queries and some API calls which will then store data that I can use/call without taking the processing or time penalty of doing it every time a user access my web service. Is this possible? If so, point me in the right direction on how to implement something like this Using vb.net and ASP.net Thanks in advance!!

  Read the article

• MVC + Nhibernate + Oracle Schema Configuration

  - by Orkun Balkanci

  Our customer wants us to use a connectionstring with username = "external" and add schemaName "original" infront of our queries like: "select columnA from original.TableA" I dont want to change mapping files which are shared by other projects, tried adding default schema as: <property name="default_schema">original</property> But this doesn't work. Any Help?

  Read the article

• Xpath Query to match immediate sibling nodes in a sequence.

  - by Pritam Damania

  Hi, I'm new to XPATH and I'd like to know if there is a nice way to do this using XPATH queries. I want to match consecutive sibling nodes in a XML tree to certain predefined rules for example if there are three sibling nodes occurring immediately one after the other and they have the attributes value="A", value="B" and value="C", I want the XPATH query to match the first node/last node in such a sequence and I want to extract all such consecutive sequence of nodes from the XML tree so that I can process them later on. Thanks!

  Read the article

• Rails - Find Condition of two model fields

  - by ChrisWesAllen

  I'm trying to find the results of a model where it queries as the result of two conditions. I have a search tag that looks for Model.find(:all, :conditions => "name LIKE params[search]") but I'd like for the search to find all records where "name LIKE params[search] or description LIKE params[search] . Is there any way to add an OR into a condition in rails? or should I make an if statement?

  Read the article

• TFS Edit project-level information permission

  - by user263097

  I'm looking for what specifically the "Edit project-level information" permission allows you to do. So far I've noticed that by default you need this to add/delete areas & iterations, manage check-in policies, create team work item queries. What else am I forgetting?

  Read the article

• Access Creates new file every time I Compact & Repair

  - by NickSentowski

  It didn't always do this, but ever since I split my database and made the front-end an ACCDE file, any time I try to compact and repair either file, a new file called "Database 1" is generated and my original file size doesn't change. Is this normal? My ACCDB is roughly 20MB, and my ACCDE is just over 1M after being used the first time. Before opening, the ACCDE was only 600k (I have lots of forms and queries, and regularly store PDF attachments.

  Read the article

• Paginating data, has to be a better way

  - by John Tyler

  I've read like 10 or so "tutorials", and they all involve the same thing: Pull a count of the data set Pull the relevant data set (LIMIT, OFFSET) IE: SELECT COUNT(*) FROM table WHERE something = ? SELECT * FROM table WHERE something =? LIMIT ? offset ?` Two very similar queries, no? There has to be a better way to do this, my dataset is 600,000+ rows and already sluggish (results are determined by over 30 where clauses, and vary from user to user, but are properly indexed of course).

  Read the article

• Help understand difference in sql query

  - by Anil Namde

  Select user_name [User Name], first_name [First Name], last_name [Last Name] Form tab_user ORDER BY user_name Select user_name [User Name], first_name [First Name], last_name [Last Name] Form tab_user ORDER BY User Name Above are the two queries, Is there any difference because of the user_name used instead of User Name Is there something that should be taken care/worried when using something like this.

  Read the article

• I simple search controller that stores search history, should I use resource routing or non-resource?

  - by vfilby

  I am learning rails and am toying with a simple web-app that integrates with flickr to search photos based on user given criteria and store the query in a search history table. I am seeking the best or 'rails' way of handling this. Should I setup a controller and non-resource routes that handle the search and store the data in a custom table; or should I create a resource for queries with a resource route and an additional path for search?

  Read the article

• Is mysql_query under PHP a blocking function?

  - by susmits

  Suppose I am executing several queries on the server using mysql_query. The results of every query affect the subsequent query. Will every call of mysql_query be completely executed before control moves on to the next one?

  Read the article

• How to make a nested query with an Entity that doesn't really exist (many-to-many)

  - by Calou

  Hi everyone, I'm new with Doctrine2 so my question can be easy to answer (I hope so). First of all, here the SQL query that I'd want : SELECT * FROM Document WHERE id NOT IN (SELECT document_id FROM Documents_Folders) Pretty simple isn't it ? The porblem is that my table 'Documents_Folders' is not an entity. In fact, it was create because I have a many-to-many relation between my entities 'Document' and 'Folder'. I tried several queries, but none worked. Thanks.

  Read the article

• Linq to SQL - Returning two values with one query

  - by Sir Psycho

  Hi, Is it possible to return a single value and an enumerable collection using LINQ to SQL? The problem is, I'm trying to do paging across a large recordset. I only want to return 10 rows at a time so I'm using .Skip(20).Take(10) approach. However I need to know the total number of records so I can show an appropriate page x of y. Trying to avoid two separate queries. Thanks

  Read the article

• MySQL and SQLite differences in SQL

  - by Darth

  I'm writing java application that is using both SQLite and MySQL using JDBC. Are there any differences in SQL for those databases? Can I use same queries for both SQLite and MySQL, or is there any db specific stuff, that doesn't work on the other one? As far I've worked only with MySQL, so I don't really know much about SQLite.

  Read the article

• Finding all areas that intersect with a point and vice-versa - PostGIS

  - by ForeignerBR

  I'm developing a project using PostGIS to hold spatial data where I have records that hold geometry point data and records that hold geometry area data. To solve my problem I'm looking for two queries that can take geographic shapes rather than geometric shapes as parameters. For query A I need it to return all points that intersect with a given area. For query B I need it to return all areas that intersect with a given point.

  Read the article

• How are neural networks used when the number of inputs could be variable?

  - by Jeremy E

  All the examples I have seen of neural networks are for a fixed set of inputs which works good for images and fixed length data. How do you deal with variable length data such sentances, queries or source code. Is there a way to encode variable length data into fixed length inputs and still get the generalization properties of neural networks? Thanks

  Read the article

• NNibernate Reusable QueryOver

  - by colinramsay

  To keep my queries self-contained and potentially reusable, I tended to do this in NH2: public class FeaturedCarFinder : DetachedCriteria { public FeaturedCarFinder(int maxResults) : base(typeof(Car)) { Add(Restrictions.Eq("IsFeatured", true)); SetMaxResults(maxResults); SetProjection(BuildProjections()); SetResultTransformer(typeof(CarViewModelMessage)); } } I'd like to use QueryOver now that I've moved to NH3, but I'm not sure how to do the above using QueryOver?

  Read the article

• How to update two tables in a single query in MS SQL

  - by Aditya Acharya

  Can it be possible to update two tables writing single query. So that i do not to execute two queries and to track whether both are successful.

  Read the article

• Returning records from 3 tables via a Join Table with Propel in Symfony

  - by Jon Winstanley

  I have 3 database tables: article article_has_tag (2 FK's to the other tables) tag I currently show a list of articles with the article's tags shown underneath but the number of queries grows as the list gets longer. I want to loop over all the articles and get the tag objects from each one in turn. Can it be done in 1 propel query?

  Read the article

• Is it safe to use connection.createStatement().executeQuery(String query);?

  - by javanix

  Is it safe to do connection.createStatement().executeQuery(String query);, or should each java.sql.Statement object be created and closed by "hand" on every use, even if the connection is closed in a finally block? If multiple queries are executed in one method by one connection it would use much less code if instantiating and closing each statement wasn't strictly necessary.

  Read the article

• how to detect whether strings are not captured for localization in .po files i.e no equivalent entry

  - by Manjushree

  Hi we have some queries regarding localization/.po files 1 We want to detect the missing strings or strings which are not being captured for L10N. how we can detect that? is that any method or command to update the strings 2 Locale files (.po) for "cn-zh" or another Locale are not complete (missing strings) 3 String has been captured for L10N but does not have a matching pair in .po files

  Read the article

• Transitioning from php to python/pylons/SQLAlchemy -- Are ORMs the standard now?

  - by EmpireJones

  Should I invest a lot of time trying to figure out an ORM style implementation, or is it still common to just stick with standard SQL queries in python/pylons/sqlalchemy?

  Read the article

• How to get unique values when using a UNION mysql query

  - by Roland

  I have 2 sql queries that return results, both contain a contract number, now I want to get the unique values of contract numbers HEre's the query (SELECT contractno, dsignoff FROM campaigns WHERE clientid = 20010490 AND contractno != '' GROUP BY contractno,dsignoff) UNION (SELECT id AS contractno,signoffdate AS dsignoff FROM contract_details WHERE clientid = 20010490) So for example, if the first query before the union returns two results with contract no 10, and the sql query after the union also returns 10, then we have 3 rows in total, however because contractno of all three rows is 10, I need to have only one row returned, Is this possible?

  Read the article

• Improve SQL Server 2005 Query Performance

  - by user366810

  I have a course search engine and when I try to do a search, it takes too long to show search results. You can try to do a search here http://76.12.87.164/cpd/testperformance.cfm At that page you can also see the database tables and indexes, if any. I'm not using Stored Procedures - the queries are inline using Coldfusion. I think I need to create some indexes but I'm not sure what kind (clustered, non-clustered) and on what columns. Thanks

  Read the article

• Changing GORM table name

  - by Matthias Hryniszak

  Hi I'm fighting to get the following mapping working in Grails 1.3.1 and MySQL: class Login { int id String email static mappings = { table 'my_table' id column: "Mgr_id" version: false } } No matter what I do the queries that are being issued refer to "schema.login" table instead of "schema.my_table". This is very frustrating... Can anyone answer why this might not be working?

  Read the article

• SQLite Query to Insert a record If not exists

  - by Tharindu Madushanka

  I want to insert a record into a sqlite table if its actually not inserted. Let's say it has three fields pk, name, address I want to INSERT new record with name if that name not added preveously. Can we do with this in a single Query. Seems like its slightly different from SQL Queries sometimes. Thanks you, Tharindu Madushanka

  Read the article

< Previous Page | 81 82 83 84 85 86 87 88 89 90 91 92  | Next Page >