Search Results

Search found 49727 results on 1990 pages for 'multiple select query'.

Page 377/1990 | < Previous Page | 373 374 375 376 377 378 379 380 381 382 383 384  | Next Page >

• A javascript variable used in multiple Web pages

  - by Paul

  Is there any way to define a variable that can be used in multiple Web pages? For example, a string variable stores a certain value in page A and that value can be accessed in page B. I know cookies can do it. Is there any other way?

  Read the article

• CodeIgniter - numbers in sql query are masked with ``

  - by Checkson

  Hello, i'm using CodeIgniter for developing a community board. As I'm using nested sets to get a nested forum hierarchy, I have to run a lot of queries such as: SELECT `id` FROM `forums` WHERE 1 BETWEEN `lft` AND `rgt` My problem: CodeIgniter is replacing the "1" by "`1`" because the "1" is recognized as a column name. Of course, the query does not work any more. Is there a way to get it working? thx in advance

  Read the article

• Actual AccessDataSource Query With Replaced Parameters

  - by Steven

  I am getting an "Invalid SQL statement" error in my VB code. I have set several SelectQuery parameters. How can I get the actual query with the parameters replaced with actual values?

  Read the article

• Need help Linq query join + count + group by

  - by user233540

  I have two table First table BID Town 1 ABC 2 ABC2 3 ABC Second Table PID BID AmountFirst AmountSecond AmountThird Minority 1__ 1___ 1000_____ 1000________ 1000_____ SC 2__ 2___ 2000_____ 1000_______ 2000_____ ST 3__ 3___ 1000____ 1000_______ 1000_______ SC BID is foreign key in Second table. I want sum AmountFirst + AmountSecond +AmountThird for individualTown e.g for ABC town answer should be : 6000 (summation of PID 1 and PID 2) I want Linq query for this..Please help

  Read the article

• jquery .live() click multiple times

  - by user355227

  Hi, I am trying to make a script that updates the captcha image, that is loaded through live() function... It works, but it only updates the image 1 time on firefox, 2 times on safari... How can I make this to work multiple times? jquery 1.4.2 relevant part of code: /* captcha image change */ var rand = Math.random(); $('a.captcha_refresh').live('click', function() { $('img.captcha').attr("src", 'captchashow.php?sid=' + rand); }); thanks, brm

  Read the article

• Most effective way working with multiple natural languages

  - by Industrial

  Hi! I am currently working with a codeigniter PHP based application and have come to the point where it's about to go off with multiple languages. Is codeigniters own language class the most effective way to handle languages? Is there any specific language-tools/libraries that are commonly used in PHP apps? Thanks!

  Read the article

• Selecting two specific mysql table rows in a single query

  - by Scotta

  Lets say I have a table with 20 entries. They are sorted by date (date is a column name _) in descending order. How would I go about selecting ONLY the newest entry and the 15th oldest entry? I am getting all 15 results by doing the following query SELECT * FROM mytable m WHERE col1 = "zzz" ORDER BY date DESC LIMIT 15;

  Read the article

• Help me with LINQ to entities query, please

  - by plotnick

  I need to build a query to the entities to get records including: AssetWeapon, PersonOut number of records with IsIn = True, number of records with IsIn = False, name of the month of StartTime, Records should be grouped by AssetWeapon thank you guys!

  Read the article

• LINQ Query and DateTimes....

  - by AlwaysBeCoding

  Im trying to get the Sum() from an Entityset with the next query. (from MyObject p in SelectedObject.MyObjectEntitySet where p.AColumn.HasValue && (p.ADate >= dateTimeValue && p.ADate <= dateTimeValue2) select p.AColumn.Value).Sum(); with no luck retrieving correct sum. Any Ideas?

  Read the article

• multiple figure in latex with captions.

  - by asd

  Hi, How can I insert multiple figures each of them has a caption and label, without using minipage. I wrote this code, but just there is one caption :( \begin{figure}[htp] \centering \label{figur}\caption{equation...} \begin{tabular}{cc} % Requires \usepackage{graphicx} \includegraphics[width=60mm]{explicit3185.eps}& \includegraphics[width=60mm]{explicit3183.eps}\\ \includegraphics[width=60mm]{explicit1501.eps}& \includegraphics[width=60mm]{explicit23185.eps}\\ \includegraphics[width=60mm]{explicit23183.eps}& \includegraphics[width=60mm]{explicit21501.eps}\\ \end{tabular} \end{figure}

  Read the article

• How do I query for this in Django?

  - by alex

  | random_code | varchar(200) | YES | UNI | NULL | | MyTable.objects.filter(random_code = None) Is this correct? Will this SELECT where there is no random code set? Above is my table.

  Read the article

• GridView with multiple DataSources

  - by mike1973

  Hello, I have a grid view that will display columns from multiple data sources (3). The data sources are stored procedures that contains a variety of columns not identical, How can i select the columns from these datasources and bind them to the Grid programtically (from code behind)??? Thanks

  Read the article

• how to pass parameters to sql query

  - by Shiny

  Im using Sql compact server.I created table with varchar datas.But i select a particular column member to be an identity.im programming in c#. I want pass the query. how can i achieve this? Im new to this sql compact,

  Read the article

• Created query is not supported by my DB

  - by stacker

  I created an application using seam-gen. The created operation to search the DB ends with and exception (syntax error). The query has a where clause like this: lower(barcode0_.barcode_ean) like lower((?||'%')) limit ? Does hibnerate or seam create the where clause which my DB can't understand? Or is there a workaround for SQL statement related issues in seam?

  Read the article

• Javascript replace query string + with a space

  - by BruceClark

  I'm grabbing the query string parameters and trying to do this: var hello = unescape(helloQueryString); and it returns: this+is+the+string instead of: this is the string Works great if %20's were in there, but it's +'s. Any way to decode these properly so they + signs move to be spaces? Thanks.

  Read the article

• Check value existance while performing a UPDATE query

  - by nimo

  Hi, I need to perform a simple update query where the update should only be done, if there is no value with updating value (item_name). For example, DB table [item_types] item_id(PK) | item_name Assuming there exist item_id with 6, My attempt is UPDATE item_types as k SET k.item_name = 'item_1' WHERE NOT EXISTS (SELECT * FROM item_types as a WHERE a.item_name = 'item_1') AND k.item_id = '6' But this gives me error "You can't specify target table 'k' for update in FROM clause" Could you please explain the error here and how can I achieve this ? Thank you

  Read the article

• What does the below query explain?

  - by Parth

  What does the below query explain? SELECT * FROM `jos_menu` WHERE (id = 69 OR id = 72) I know its very silly question, but sometimes easy things creates mess in my skulls interpreter.. Pls help EDIT Its giving me record for both IDs, why is it doing so? It should five me the record for either 69 or 72....

  Read the article

• help for a query

  - by stighy

  Hi, i've a problem for a table update. follow table structure: Table1 tableid ... ... productID_1 productID_2 productID_3 Table2 productID Total I've to totalize each product in table2. For example: SELECT COUNT(*) as tot, ProductID_1 FROM Table1 GROUP Table1 then the UPDATE table2 SET total =..??? (how can i do) WHERE productID_1 = .... Hope you can help me. Thank you

  Read the article

• Creating an SQL query to list all clients, who spent over 1000$

  - by Lapa

  So, I have three tables with the following rows: Customers (Customer_id and Name), Orders (Customer_id, Product_id, Quantity) and Products (Price). How do I write a query which shows all customers who spent more than 1000$? Do I have to join the tables?

  Read the article

• Changes to multiple entities within a single transaction

  - by Nati

  Hy, I am trying to make changes to multiple entities within a single transaction in app engine platform. As I understand in order to succeed doing so, App Engine needs to know in advance which entities will be updated together, so it knows to store them in a way that supports transactions. And therefore, user must declare that an entity belongs to the same entity group as another entity when you create the entity. How do I declare that one entity belongs to another entity group in creation time? Thanks, Nati

  Read the article

• Multiple reference in SQL

  - by AGarofoli

  Hi! I'm working on a db but i'm kinda new to this so i've bumped into a problem today. I've got some tables: OFFICE, ROOM, EMPLOYEE and DOCUMENT. Document must specify the sender, which can be a single employee, an entire room or an entire office so it must have a reference to the primary keys of those tables. Should I do a "parallel" table for handle it (for example i've done one for handle the multiple recipients documents) or there is another way? Thank you

  Read the article

• mysql query problem

  - by PiePowa

  hey everybody i'm trying to do somthing simple like this SET i = 0; WHILE (i <= 2230686) DO INSERT INTO customers(check) VALUE(0); SET i=i+1; END WHILE; in the phpmyadmin SQL query box and it doesntwork and the mysql doesnt throw an understandable reason any clues ?

  Read the article

• Update query not effecting all rows in database

  - by Webnet

  I have the following query.... UPDATE vehicle_catalog SET parent_id = 0 WHERE parent_id = SUBSTR(id, 0, 5) I need to set all parent_ids to 0 where the first 5 characters of id is the same as the parent_id. This is effecting 0 rows when I'm looking at the data and it should be effecting over 10,000. Any ideas on why this wouldn't be effecting all rows?

  Read the article

• Query to get largest datatype in schema

  - by crazyguy-or-am-i

  What is the query to get the top 5 ...data types ...used in a DB by size? for eg. int(20) is greater than int(4)

  Read the article

• Change query to use a LEFT join

  - by Craig

  I have a query which is failing, as it needs to be using LEFT JOIN, as opposed to the default INNER JOIN used by the 'join' syntax: var users = (from u in this._context.Users join p in this._context.Profiles on u.ProfileID equals p.ID join vw in this._context.vw_Contacts on u.ContactID equals vw.ID orderby u.Code select new { ID = u.ID, profileId = p.ID, u.ContactID, u.Code, u.UserName, vw.FileAs, p.Name, u.LastLogout, u.Inactive, u.Disabled }).ToList(); How would i re-write this so that is utilises a LEFT join?

  Read the article

< Previous Page | 373 374 375 376 377 378 379 380 381 382 383 384  | Next Page >