Search Results

Search found 26438 results on 1058 pages for 'calendar table'.

Page 736/1058 | < Previous Page | 732 733 734 735 736 737 738 739 740 741 742 743  | Next Page >

• How get the names of all the tables from a database in a combo box using c#

  - by syedsaleemss

  Im using c# .net windows form application. i have a SQL database with 5 tables. i need to populate a combobox with these table names. only names should be displayed.

  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

• 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

• 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

• 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

• MATLAB: comparing 2 columns content

  - by Patrick

  hi, I need to compare the content of 2 tables, more exactly 2 columns (1 column per table) in Matlab to see, for each element of the firsts column, there is an equal element in the second column. Should I use a for loop or is there any MATLAB function doing this ? thanks

  Read the article

• subqueries in UPDATE SET (sql server 2005)

  - by itdebeloper

  I have a question about using subqueries in an Update statement. My example: UPDATE TRIPS SET locations = city + ', ' FROM (select Distinct city from poi where poi.trip_guid = trips.guid) Is it possible to refer to main table value (trips.guid) in subqueries? When i try to use trips.guid I get the error: "The multi-part identifier "trips.guid" could not be bound."

  Read the article

• MySQL select column length in php

  - by Patrick

  Hello! How do i get the actual max length of a specified column in php? For instance, this table: id - int(11) name - string(20) I want in php to select the maximum number of characters that a field can have, like SELECT length(name) from table1 and it should then return 20 (since its the maximum number of characters for that field).

  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

• 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

• 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

• how to get last weeek dates from today to last 7 days date..

  - by Ranjana

  i have a table with column: Registereddate orgid 2010-06-05 10:16:00 1 2010-06-05 10:10:00 2 2010-06-04 22:31:00 3 ... . . ..... . . . i need to get only last weeek dates and orgid from today to last 7 days date..

  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

• 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

• 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

• 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

• Can I use the same DBML to access different tables?

  - by Sisiutl

  I have many tables with identical schemas but different names. Can I create a single representative DBML/DataContext and re-use it for all the tables, or do I have to drag every table into the dbml designer?

  Read the article

• Is this SQL is valid?

  - by Beck

  UPDATE polls_options SET `votes`=`votes`+1, `percent`=ROUND((`votes`+1) / (SELECT voters FROM polls WHERE poll_id=? LIMIT 1) * 100,1) WHERE option_id=? AND poll_id=? Don't have table data yet, to test it properly. :) And by the way, in what type % integers should be stored in database? Thanks for the help!

  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

• 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

• 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

• Pause animation in EAGLView which is in a UITableViewCell

  - by hanno

  I have an animation in a EAGLView which is itself in a UITableViewCell. How can I pause the animation in the EAGLView when the view is not visible? Normally, I would simply use the responsible UIViewController and listen to viewDidDisappear. But how do I do that if the EAGLView is in a table?

  Read the article

• What is the efficient way to make a permission system?

  - by WEBProject

  Currently im just using something like: in the DB Table: access: home,register,login and then in each page: if(!Functions::has_rights('content')) { Functions::noAccess(); } is there more efficient way to do it, php & MySQL? i may want to gain access even to several parts a page, for example: user can read a page, but doesnt comment to it, and I dont want to build a separate system to each module. Thanks in advanced, Tal.

  Read the article

• Get consolidated results with following tables

  - by Ted

  I have a scenario. Here's my table structure is: ID LoginDate RemovalDate ---------------------------------------- 1 2009/08/01 NULL 2 2009/09/12 2010/01/02 3 2009/08/31 2009/10/29 4 2010/02/17 NULL 5 2009/10/18 2009/11/22 I want a consolidated results of how many ID's were not removed in a particular month. So the result set should be Date NotRemoved_ID -------------------------- 2009/08 2 2009/09 3 2009/10 3 [One ID got removed in 2009/10] 2010/02 2 [Two got removed in 2009/11 and 2010/01] Please help.

  Read the article

• How do I protect this function from SQL injection?

  - by dwbanks

  public static bool TruncateTable(string dbAlias, string tableName) { string sqlStatement = string.Format("TRUNCATE TABLE {0}", tableName); return ExecuteNonQuery(dbAlias, sqlStatement) 0; }

  Read the article

< Previous Page | 732 733 734 735 736 737 738 739 740 741 742 743  | Next Page >