Search Results

Search found 25175 results on 1007 pages for 'dispatch table'.

Page 691/1007 | < Previous Page | 687 688 689 690 691 692 693 694 695 696 697 698  | Next Page >

• Local Databse Storage default data.

  - by kiranmply

  Hi I have developed application using HTML 5 Localstorage. How can I create a TABLE and populate 10000+ rows before initializing my HTML 5 enabled application. Please suggest a pattern.

  Read the article

• Using hibernate with annotations, i want a one-many relationship to be sorted

  - by Chris

  Using hibernate with annotations, i want a one-many relationship to be sorted by the 'created' field on the 'many' table. So far i've got this, which always ends up in a random order: // The notes @OneToMany @JoinColumn(name="task_id") Set<TaskNote> notes; public Set<TaskNote> getNotes() {return notes;} public void setNotes(Set<TaskNote> notes) {this.notes = notes;}

  Read the article

• Rails 3.0 method_missing: undefined method in validator

  - by user567592

  == Schema Information Schema version: 20110111000403 # Table name: places # id :integer not null, primary key name :string(255) latitude :float longitude :float a place can be defined by latitude and longitude or by name # class Place < ActiveRecord::Base validates_precence_of :name, :if = lat_long_not_def? def lat_long_not_def? latitude.blank? || longitude.blank? end end

  Read the article

• MySQL: How to copy rows, but change a few fields?

  - by Andrew

  I have a large number of rows that I would like to copy, but I need to change one field. I can select the rows that I want to copy: select * from Table where Event_ID = "120" Now I want to copy all those rows and create new rows while setting the Event_ID to 155. How can I accomplish this?

  Read the article

• Python templates for huge HTML/XML

  - by newtover

  Hello, Recently I needed to generate a huge HTML page containing a report with several thousand row table. And, obviously, I did not want to build the whole HTML (or the underlying tree) in memory. As result, I built the page with the old good string interpolation, but I do not like the solution. Thus, I wonder whether there are Python templating engines that can yield resulting page content by parts.

  Read the article

• Is there a way to fix the background image of a UITableView

  - by user337174

  Hi I have set the background of my UITable with a custom image. self.tableView.backgroundColor = [UIColor clearColor]; self.tableView.backgroundColor = [UIColor colorWithPatternImage:[UIImage imageNamed:@"background.png"]]; The problem im having is the background image is scrolling and doesn't look good at the top and bottom of the screen where you see the image being joined. Is there a way to fix the position of the background image and just have the table scroll over the top of it?

  Read the article

• SQL Server: compare columns in two tables.

  - by maxt3r

  Hi, I've recently done a migration from a really old version of some application to the current version and i faced some problems while migrating databases. I need a query that could help me to compare columns in two tables. I mean not the data in rows, I need to compare the columns itself to figure out, what changes in table structure I've missed.

  Read the article

• Find amount of updated rows in T-SQL

  - by Alex

  I need to find the amount of updated rows UPDATE Table SET value=2 WHERE value2=1 declare @aaa int set @aaa = @@ROWCOUNT It doesn't work. How can I do that?

  Read the article

• mysql phpmyadmin accepting 4 character but its real length is int 2

  - by Bharanikumar

  Hi , i have employee table and its empid length is INT 3 , But it accepting more then 3 character .... How it is possible (THIS IS TESTED IN PHPMYADMIN)

  Read the article

• How to find size of individual columns and indexes in mysql/innodb database?

  - by taw

  SHOW TABLE STATUS LIKE 'foo' returns Data_length - size of all data, and Index_length - size of all indexes. What's the best way to get per-column and per-index breakdown?

  Read the article

• Do any of the built in asp.net grid controls (or similiar) provide effecient data paging?

  - by Blankman

  I know in asp.net 1.0 the grid display controls would pull all the data in, and then provide paging but the paging was done in memory. Are there any smarter controls that provide paging where they only pull the data relevent to current page being displayed? ie. select 10 rows for the current page, instead of doing a select of ALL the rows in the table.

  Read the article

• Select random line in SQL database

  - by Jensen

  Hi, I would like to select a random line in my database. I saw this solution on a website: SELECT column FROM table ORDER BY RAND() LIMIT 1 This SQL query run but someone said me that it was a non performant query. Is there another solution ? Thx

  Read the article

• Getting rows which include a value with MySQL

  - by sundowatch

  I have a MySQL query which gets including some vars like that: messages TABLE receiver cols user1 rows : 1,3,5 user2 rows : 2,3 user3 rows : 1,4 I want to get rows which includes '3' value. So I will get 'user1' and 'user2'. I tried that but naturally it doesn't work. mysql_query("SELECT * FROM messages WHERE receiver='3'"); How can I do this?

  Read the article

• How Assigning query return value to local a variable, and how to use that in where condition?

  - by Ayyappan.Anbalagan

  I am using mysql stored procedure; I need to assign query retuned value to local variable. And i have to check the condition using the local variable..... or It my query Select Meterial_Id from hemaepdb.transaction where CustId=1; Instead of Meterial_Id i need to get the Meterial_name from Material table.....

  Read the article

• Excel : sum of values depending of other values

  - by gregseth

  Hi, What would be the equivalent Excel formula of this SQL query SELECT SUM(a) FROM table WHERE b < 0; A B ---- ---- 1 0 2 -1 3 4 5 -3 >> 7

  Read the article

• MySQL Joining three tables

  - by text

  I am doing a query with three tables, the problem was one table has many occurrences of id of another. sample data: users: id answers: id:1 user_answer :1 id:1 user_answer :2 id:1 user_answer :3 Questions: id:1 answers :answer description id:2 answers :answer description id:3 answers :answer description How can I get all user information and all answer and its description, I used GROUP by user.id but it only returns only one answer. I want to return something like this list all of users answer: Name Q1 Q2 USERNAME ans1,ans2 ans1,ans2 comma separated description of answer here

  Read the article

• Google App Engine: Which is its RDBMS?

  - by Vimvq1987

  According to this: http://code.google.com/appengine/docs/whatisgoogleappengine.html it seems that GAE only uses Datastore to store data, which is equivalent with Table service on Windows Azure Platform. Does anyone know that which RDBMS it uses? or such thing exists or not?

  Read the article

• How is the scope of a variable/identifier maintained?

  - by eswar

  How is the scope of a variable/identifier maintained in the symbol table of a c/c++ compiler. Please suggest some good links and books to know the how compiling process of c/c++ program is implemented for better understanding.

  Read the article

• Records featch for DataTable

  - by Ravi

  Hi, I have added 1000 records into DataTable using C#.Net. This data table contains TimeStamp column for specified data stored time. Data stored into 10.00AM to 11.00AM every 10 seconds once. Here i want to featch only 10.15AM to 10.30AM records using C#. Thanks

  Read the article

• symfony: difference between doctrine model "User" and symfony "myUser"?

  - by fayer

  what is the difference between the symfony "myUser" and doctrine model "User"? where should i put the methods for an user? eg. $user-createThread(), $user-deleteThread() and so on should $user be an instance of the doctrine model User (cause i have a table called User) or the myUser that extends sfBasicSecurityUser? thanks!

  Read the article

• ParentId and Parent type in Entity Framework

  - by jonathan

  I have many entities (Customers, prospects,...) I have one entity called Notes, which can handle notes for Customers,prospects... The Notes table is then: Id Parent_Id Parent_Type Note How to handle this with Entity Framework ? Thanks Joghn

  Read the article

• MySQL - Limit a left join to the first date-time that occurs?

  - by John M

  Simplified table structure (the tables can't be merged at this time): TableA: dts_received (datetime) dts_completed (datetime) task_a (varchar) TableB: dts_started (datetime) task_b (varchar) What I would like to do is determine how long a task took to complete. The join parameter would be something like ON task_a = task_b AND dts_completed < dts_started The issue is that there may be multiple date-times that occur after the dts_completed. How do I create a join that only returns the first tableB-datetime that occurs after the tableA-datetime?

  Read the article

• How should i store availability calendar information in mysql? for [id] [date] [available/unavailab

  - by Haroldo

  I'm building a simple calendar for holiday cottages to show when they are booked or available. What would be the fastest mysql table design for this, bearing in mind when users mark dates as available/booked they will do so via a start date and an end date. i can see 2 obvious options Store 'booked' data for every day [more rows] or, store 'booked' data with 2 columns a start_date and end_date [more processing?] Which is best or is there another method i'm missing?

  Read the article

• getting rows which including a value with mysql

  - by sundowatch

  I have a mysq query which gets including some vars like that: messages TABLE receiver cols user1 rows : 1,3,5 user2 rows : 2,3 user3 rows : 1,4 I want to get rows which includes '3' value. So I will get 'user1' and 'user2'. I tried that but naturally it doesn't work. mysql_query("SELECT * FROM messages WHERE receiver='3'"); How can I do this?

  Read the article

• How do I see the results of unique records added after adding records to mysql

  - by billy

  I'm a PHP noob. I have a database that I will update weekly with a CSV. So far I've managed to upload the file to the server, open the file with PHP, and insert the data in my table. Now I want to return the unique records that were added (on screen or in a file). How do I do this?

  Read the article

< Previous Page | 687 688 689 690 691 692 693 694 695 696 697 698  | Next Page >