Search Results

Search found 956 results on 39 pages for 'querying'.

Page 14/39 | < Previous Page | 10 11 12 13 14 15 16 17 18 19 20 21  | Next Page >

• Printing a variable only when it changes?

  - by user1781639

  First off, my question was a little vague or confusing since I'm not really sure how to phrase my question to be specific. I'm trying to query a database of stockists for a Knitting company (school project using PHP) but I'm looking to print the city as a heading instead of with each stockists information. Here is what I have at the moment: $sql…

  Read the article

• sizeof(class) c++

  - by badkya

  How is it possible for sizeof(class) to return two different values depending on context? The class itself should have the same size right irrespective of where I ask this question? I see a smaller value when querying class size from main() and another when I query class size from an extended class.

  Read the article

• what does synchronization mean in hibernate..

  - by abc

  i read that upon session.flush() The data will be synchronized (but not committed) when session.flush() is called what is synchronized with what.. whether it is DB state that will come to memory by querying or memory state will be copied to Db ? clarify this plz..

  Read the article

• Language independent logic question

  - by Sam

  If one has three fields in a db that they are querying an object by.... One of these fields must always be an associations id. Concerning the other two fields "only one needs to be true" What interpretation do you take or make of "only one needs to be true"?

  Read the article

• Where Does Temporary Tables Gets stored in sql server.

  - by Shantanu Gupta

  Where does temporary tables gets stored in database. I want to drop a temporary table if it already exists. I can do this for securable table by querying at information schema but i done know where temporary tables are stored

  Read the article

• Using a user-defined type as a primary key

  - by Chris Kaminski

  Suppose I have a system where I have metadata such as: table: ====== key name address ... Then suppose I have a user-defined type described as so: datasource datasource-key A) are there systems where it's possible to have keys based on user-defined types? B) if so, how do you decompose the keys into a form suitable for…

  Read the article

• MS Access: index optimisation

  - by Patrick Honorez

  Let's say we have a [Valuations] table containing several values per date and per fund: -FundId -ValDate -Value1 -Value2... The Primary key is obviously FundId+ValDate. I have also indexed the ValDate field since I often query for values on a specific date. My question is: should I also create a specific index for the FundId, or is…

  Read the article

• LDAP user data caching on local database

  - by Eduardo

  I am integrating LDAP authentication in my web enterprise application. I would like to show listing of people name and email. Instead of querying the LDAP server for the name and email each time a listing containing several users I thought about caching the data locally in the database. Do you guys know about caching LDAP data best…

  Read the article

• How can I get FOUND_ROW()s from an active record object in rails?

  - by Justin Tanner

  When querying the database with: @robots = Robot.all(:limit => 50, :offset => 0) What is the best way to get the total number of rows without the :limit? In raw MySQL you could do something like this: SELECT SQL_CALC_FOUND_ROWS * FROM robots LIMIT 0, 50 SELECT FOUND_ROWS();

  Read the article

• Query scope within a table trigger in an Oracle database

  - by sisslack

  I'm been trying to write a table trigger the queries another table that is outside the schema where the trigger will reside. Is this possible? It seems like I have no problem querying tables in my schema but I get: Error: ORA-00942: table or view does not exist when trying trying to query tables outside my schema. The…

  Read the article

• Using SQL Server Views with NHibernate

  - by colinramsay

  I have a site that sells cars. On the frontend, I want to only show cars that are published, and on the backend I want to show all cars. Whether a car is published or not depends on a number of factors, so I wanted to create a view to simplify this. My question is, can I reduce duplication by dynamically telling NHibernate…

  Read the article

• Filtering Linux command output

  - by Raajkumar

  Hi, I need to get a row based on column value just like querying a database. I have a command output like this, Name ID Mem VCPUs State Time(s) Domain-0 0 15485 16 r----- 1779042.1 prime95-01 512 1 -b---- 61.9 Here I need to list only those rows where state is "r".…

  Read the article

• How to use the IN operator in linq

  - by Hallaghan

  I'm querying a view and filtering the results with a column named status. I'd like to query it so I can search for rows with different status, by using the IN operator as I'd do in SQL. As so: SELECT * FROM VIEW WHERE Status in ('....', '.....') How can I achieve this?

  Read the article

• Amazon API library for Python?

  - by Kevin

  What Python libraries do folks use for querying Amazon product data? (Amazon Associates Web Service - used to be called E-Commerce API, or something along those lines). Based on my research, PyAWS (http://pyaws.sourceforge.net/) seems okay, but still pretty raw (and hasn't been updated in a while). Wondering if there's an…

  Read the article

• Good book for sql

  - by Uday

  I always considered database as a storage . but never thought it can be used for querying across tables etc. Which is a good book for sql for a developer. not just the syntax. How to write a query in different ways How internally queries are executed.etc especially related to microsoft sql server

  Read the article

• Primary key in MySQL: INT(n) or UUID as varchar(36)

  - by SODA

  Does it make sense to use UUID as primary key in MySQL? What would be pros and cons of using UUID instead of regular INT, beside trouble of hand querying?

  Read the article

• PHP - get MySQL query results as their native data type?

  - by redidas

  I've tried fetching MySQL query results using mysql_fetch_row() mysql_result() and numeric values are being returned as strings. Is there any way to fetch the data as its datatype stored in the table? The application will be querying many different queries so I will be unable to cast the values as the intended datatype on…

  Read the article

• Oracle Merge vs Select then Insert or Update

  - by DRTauli

  What is faster? the Merge statement MERGE INTO table USING dual ON (rowid = 'some_id') WHEN MATCHED THEN UPDATE SET colname = 'some_val' WHEN NOT MATCHED THEN INSERT (rowid, colname) VALUES ('some_id', 'some_val') or querying a select statement then using an update or insert…

  Read the article

• sqlalchemy natural sorting

  - by teggy

  Currently, i am querying with this code: meta.Session.query(Label).order_by(Label.name).all() and it returns me objects sorted by Label.name in this manner ['1','7','1a','5c']. Is there a way i can have the objects returned in the order with their Label.name sorted like this ['1','1a','5c','7'] Thanks!

  Read the article

• Comparison of IPEndPoint objects not working

  - by Martin Mizzell

  I have an IPEndPoint a and b, whose IPAddress and Port are exactly the same, but the == operator is on the IPEndPoint not returning true. To make things even stranger, I tried to circumvent the problem by simply comparing the IPAddress and Port individually and it is STILL not returning true. Has anyone encountered…

  Read the article

• Is there an efficient way to query a document database?

  - by Zubair

  Since document databases store records in tree like structures the fields will never be at set positions. Does this make querying a document database inefficient, or would indexes just be used as with a normal relational database?

  Read the article

• Assign query results to MySQL variable

  - by 5un5

  I'm querying a big mysql database with only read privileges, and I'd like to set some slow query results to a variable, 'foo', so I can use them again in other queries. I get, ERROR 1193 (HY000): Unknown system variable '$foo' when I enter: set $foo := (select * from table1 join table2 …

  Read the article

• MySQL using function IN with variable

  - by misanov

  I have problem querying table with variable in IN function. SELECT s.date, (SELECT GROUP_CONCAT(value) FROM value WHERE id_value IN(s.ref_values) ) AS vals FROM stats s ORDER BY s.date DESC LIMIT 1 Where s.ref_values is '12,22,54,15'. I get…

  Read the article

• Most efficient way to move a few SQL Server tables to SQLite?

  - by wom

  I have a fairly large SQL Server database; I'd like to pull 4 tables out and dump them directly into an sqlite.db for remote querying (via nightly batch). I was about to write a script to step through(most likely on a unix host kicked off via cron); but there should be a simpler method to export the tables…

  Read the article

• Proper Form Application Design

  - by Soo

  I'm creating a WinForm application in C# and one of its functions is displaying text in text boxes. I'm coding the logic for querying a database in a separate class and am unable to access the text box element in the class I'm creating (I'm getting a "name" does not exist in the current context error). Do…

  Read the article

< Previous Page | 10 11 12 13 14 15 16 17 18 19 20 21  | Next Page >