Search Results

Search found 18245 results on 730 pages for 'recursive query'.

Page 513/730 | < Previous Page | 509 510 511 512 513 514 515 516 517 518 519 520  | Next Page >

• Erlang: How do you reload an application env configuration?

  - by mwt

  How do you reload an application's configuration? Or, what are good strategies for managing dynamic application configuration? For example, let's say I had log levels and I wanted to change them at runtime. Also, let's assume this is one of many such options. Does it make sense to have a "configuration server" that holds configuration state for other parts of the application to query? Do people do that or did I just make it up?

  Read the article

• How do I use ST_Contains in following case?

  - by Z77

  I have two tables. First with points, and second with polygons. I need to find out which points are in required polygon according to the attribute gid. Using query: SELECT table1.* FROM table1, table2 WHERE table2.gid=1 AND ST_Contains(table2.geom2, table1.geom1); What I get is empty table (only columns without data)... Tnx

  Read the article

• How to send the my sql result to controller in codeigniter as a variable

  - by udaya

  Hi In my mode I am selecting a field as $query1 = $this->db->query("SELECT dPassword FROM tbl_login WHERE dEmailID='[email protected]'"); How to return dpassword as a variable to my controller I tried this way return dpassword;

  Read the article

• Database design for business numbers

  - by Rob Morris

  I'm in need of some help, I need to store the information below into a database, what would the relational database structure be for this: Then I need to create a dropdown for the insurance company followed by another dropdown depending on what the first dropdown selected value was, then once both selects have been chosen display the relevant telephone number. I guess i need to query the database, then display the dropdowns using javascript(jquery) or Ajax?

  Read the article

• Sql server Identity issue

  - by pranay

  I have query like below declare @str_CustomerID int Insert into IMDECONP38.[Customer].dbo.CustomerMaster ( CustomerName , CustomerAddress , CustomerEmail , CustomerPhone ) values ( ‘werw12e’ , ‘jkj12kj’ , ‘3212423sdf’ , ‘1212121' ) select @str_CustomerID= scope_identity() after execution it returns null in my parameter i want to get value of identity how can i do that

  Read the article

• Make qwidget in new window in PyQt4

  - by matt

  I'm trying to make a class that extends qwidget, that pops up a new window, I must be missing something fundamental, class NewQuery(QtGui.QWidget): def __init__(self, parent): QtGui.QMainWindow.__init__(self,parent) self.setWindowTitle('Add New Query') grid = QtGui.QGridLayout() label = QtGui.QLabel('blah') grid.addWidget(label,0,0) self.setLayout(grid) self.resize(300,200) when a new instance of this is made in main window's class, and show() called, the content is overlaid on the main window, how can I make it display in a new window?

  Read the article

• Error with characters in a html iframe

  - by dinero beta

  excuse my English I speak Spanish I'm trying to display multiple php and mysql registration, after that the show in an iframe the problem is that apparently in the iframe shows me errors accents and other characters for example: for example (?D?nde cuesta menos y se consume m?s?") this is what shows (?) In the original query or first does not show me that, but in the iframe shows me that error and probe with http-equiv = "content-type" and I worked What else I can do? What should I do? regards

  Read the article

• What Should I know to underestand LINQ better?

  - by Nasser Hajloo

  As LINQ is a good query language in dot net and everyone should be able to work with it. What are the necessary abilities which a programmer should have, before start learning LINQ. And after that, What should he know about LINQ? (important tips)

  Read the article

• ordering by a property on a joined table linq to sql

  - by Gazeth

  I have the following linq query from o in context.Opportunities join i in context.Interactions on o.OpportunityID equals i.OpportunityID into ints from i in ints.DefaultIfEmpty() orderby i.StatusID descending, o.StatusID descending select o Now i want to then do a distinct on the opportunities table but doing so removes my orderby. I know that you can do Distinct().OrderBy but how do i get a reference to the interactions table that was joined when I'm only selecting the opportunity entity?

  Read the article

• Randomly selecting a limited number of records with two conditions in MySQL

  - by andyashton

  I have a MySQL table with a column called "priority". The column can have two values: high or low. I want to select 8 records from the table at random, but I want 6 of them to be high priority, and 2 of them to be low priority. If possibly, I would like to do it in one SQL statement. Is there any way to do two LIMITS in one query based on this kind of criteria?

  Read the article

• Returning Null values with COUNT

  - by Randy B.

  With this query, I get a result that is two short of the table because they are not included in count, and I would like get the NULL values in the result. To do this, I am pretty sure I need to use a subquery of some kind, but I am not sure how, since the attribute in question is an aggregate. SELECT Equipment.SerialNo , Name, COUNT(Assignment.SerialNo) FROM Equipment INNER JOIN Assignment ON Assignment.SerialNo = Equipment.SerialNo GROUP BY Equipment.SerialNo, Name

  Read the article

• How to index small words (3 letters) with SQL Full-text search?

  - by Sly

  I have an Incident table with one row that has the value 'out of office' in the Description column. However the following query does not return that row. SELECT * FROM Incident WHERE CONTAINS( (Incident.Description), '"out*"' ) The word 'out' is not in the noise file (I cleared the noise file completely). Is it because SQL Full-text search does not index small words? Is there a setting for that? Note: I'm on SQL 2005.

  Read the article

• sql delete from rows value

  - by gloris

  The database includes a table with a rows: html/css/java/php How with sql query delete "java"? The result would be: html/css/php

  Read the article

• percentage formula in crystal report 8.5

  - by sathik

  am doing one project using vb6.0+access+crystal report8.5 some error occur during the crystal report. Query Name seqquery: SELECT segment_trans.division_name, sum(segment_trans.Total_value) AS total, division_master.Target FROM segment_trans, division_master GROUP BY segment_trans.division_name, division_master.Target; crystal report percentage formula: {(seqquery.total * 100) / seqquery.Target } Error: This field name is not known. note: Total_value and Target field's datatype "Text" how to solve this ? please help me. Thanks Sathik

  Read the article

• Removing part of a string in PHP

  - by Nik

  I'm trying to take a query: SHOW TABLES; which will display a bunch of tables with the chat_ prefix. I want to remove the chat_ prefix from the string, format the variable (with a link), and display it. How is this accomplished?

  Read the article

• How do I post long strings that contain special characters (like '&' specifically) via an AJAX reque

  - by user298924

  I'm looking to make a Contact/Query form, wherein the end user can send an email to the webmaster. The form has a 'textarea' field, which captures long strings from the user, if I use AJAX to submit the form using GET method, my params tend to break if their is a special character, specifically '&' in the textarea's string.. I'm stuck please help!

  Read the article

• How to fetch the first 2 or 3 rows from Mysql DB using Mysql PHP function?

  - by OM The Eternity

  How to fetch the first two rows from Mysql DB using Mysql PHP function? Is there any function which can give me first 2 or 3 rows from the select query we fired?

  Read the article

• Setting MySQL column names

  - by Richard Mar.

  Say I have these tables: people(id, name), cars(person_id, car) and this query: SELECT c.car FROM people as p, cars as c WHERE c.person_id = p.id AND p.id = 3 I want the c.car column to take its name from the name field in the people table, like this (invalid SQL, just to illustrate): SELECT c.car AS(SELECT name FROM people WHERE id = 3) How do I do that?

  Read the article

• Is there a way (other than sql) to get the mlid for a given nid in drupal?

  - by sprugman

  I've got a node, I want it's menu. As far as I can tell, node_load doesn't include it. Obviously, it's trivial to write a query to find it based on the path node/nid, but is there a Drupal Way to do it?

  Read the article

• retrieving same column twice from a table

  - by GJ

  hello all i hav a table named address which has id, title and parent_id fields. in title column the name of regions and districts are inserted. the regions have parent_id zero and parent_id of the districts are id of the regions. i want a query which display regions in one column and its respective districts in another column. hope u guys understand what i mean.. thank u all.

  Read the article

• how to retrieve the image product in the list of sub-product ( select form ) of a configurable produ

  - by spazione

  can i retrieve the thumbnail product in the list of sub-product ( select form ) of a configurable product ? how to change the query? thanks in advance

  Read the article

• what is a candidate row in SQL?

  - by JuiceBerry123

  What is a candidate row when talking about Oracle and SQL? Using it in a sentence would be as such: "The candidate row is fetched from the table specified in the outer query."

  Read the article

• how to write the SPQuery for getting all data of contact list?

  - by Lalit

  Hi, I am writing the SPQuery for getting the data in contact list of sharepoint site.but how to write that? Means I want to retrieve data as : Name:aaa Cell No: 13123131 Address : something address here.. so on... of given LAst Name in search text box (build by me). how to do that? Means what query i have to write? (Syntax please).

  Read the article

• SELECT GROUP BY latest entry in INBOX msg sent by user

  - by Mohatir S

  i am building a simple PM for my personal website where a user can join and send message to the registered users on my website, i am stuck in grouping and selecting latest user (by latest msg time) in INBOX page my table : id msg_from msg_to msg date in_del out_del i want to show latest user's id each in a group here is my SQL query : SELECT ttalk.id, ttalk.msg_from, users.first_name, users.last_name FROM ttalk INNER JOIN users ON ttalk.msg_from = users.id WHERE ttalk.msg_to = '$_SESSION[user_id]' AND ttalk.in_del='0' GROUP BY ttalk.msg_from DESC LIMIT 500 Thanks in advance :-)

  Read the article

• SQL CE Compact 3.5 Identity columns for a table.

  - by rxm0203

  Is there a query I can write against an INFORMATION_SCHEMA or against the system tables to determine if a column is an identity column in SQL CE version 3.5?

  Read the article

< Previous Page | 509 510 511 512 513 514 515 516 517 518 519 520  | Next Page >