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 >

• java database backup and restore

  - by jawath

  How do I backup / restore any kind of databases inside my java application to flate files.Are there any tools framework available to backup database to flat file like CSV, XML, or secure encrypted file, or restore from csv or xml files to databases, it should be also capable of dumping table vise restore and backup also.

  Read the article

• Marking deleted records in DB tables

  - by Emanuil

  Sometimes you want to mark a DB table record as deleted instead of deleting it permanently, right? How do you do that? So far I've been using a boolean "deleted" field.

  Read the article

• How to prevent image view loading while scrollong in iphone?

  - by Warrior

  I am new to iphone development.i want to check whether the image is loaded in the image view and if the image view is nil then load the image.i want to implement this in cell for row at index path so that i can increase the scrolling performance of the table , How can i do that ? please help me out.Thanks.

  Read the article

• Is there any optimizations I can do with this statement to get the count of used rows?

  - by RPS

  Is there any optimizations I can do with this statement to get the count of used rows. Note: The ProductOrderInfo table has over 40 million rows in it. SELECT @TotalUsed = COUNT(*) FROM ProductInfo WITH (NOLOCK) WHERE ProductInfoId IN ( SELECT ProductInfoId FROM ProductOrderInfo WITH (NOLOCK) );

  Read the article

• MySQL: how to index an "OR" clause

  - by JoséMi

  I'm executing the following query SELECT COUNT(*) FROM table WHERE field1='value' AND (field2 = 1000 OR field3 = 2000) There is one index over field1 and another composited over field2&field3. I see MySQL always selects the field1 index and then makes a join using the other two fields which is quite bad because it needs to join 146.000 rows. Suggestions on how to improve this? Thanks

  Read the article

• Background image flickering when mouseover - IE.

  - by snowalker

  Hello everyone, I have a contact form and I added an image as a background. The background image is flickering when I move the mouse over the fields in IE(6,7,8). If I remove the contact form (made with divs) everything is fine. I tried to build the form with table and I have the same problem. Any solution? Every idea is welcomed! Thanks!

  Read the article

• MySQL - Combine two fields to create a unix timestamp?

  - by Dan

  Hi, I'm trying to retrieve a UNIX timestamp from a query by combining a date and a time field in the table, however it keeps returning as zero. SELECT *, UNIX_TIMESTAMP(startdate starttime) AS start, UNIX_TIMESTAMP(enddate endtime) AS end FROM mytable; Can anyone help me out? Thanks.

  Read the article

• TSql Lookup function

  - by OldMan

  I have a bunch of dimension tables that have unique ID and Name fields. I need a T-SQL function that returns an ID when passed a table name and a value for the name field. I'm guessing the query would build a little query then execute it? Performance isn't an issue since this is a one time ETL thing.

  Read the article

• how to select the records whose several fields' combination will equal to a specific value

  - by poiu2000

  Hi all, Assume I have the following style table, col1 col2 and col3 have same value scopes, I want to select the records when two of the 3 columns have a value combination such as ('ab' and 'bc'), in the following example, the first 3 records should be selected. Any good way to do this? I am using Sybase. | id | col1 | col2 | col3 | 1 ab bc null 2 null ab bc 3 ab ab bc 4 de ab xy Thanks.

  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

• SQL commands generated in Django by running sqlall

  - by k-g-f

  In my Django app, I just ran $ python manage.py sqlall and I see a lot of SQL statements that look like this, when describing FK relationships: ALTER TABLE `app1_model1` ADD CONSTRAINT model2_id_refs_id_728de91f FOREIGN KEY (`model2_id`) REFERENCES `app1_model2` (`id`); Where does "7218de91f" come from? I would like to know because I'd like to manually write SQL statements to accompany models changes in the app so that my db's can be kept up to date.

  Read the article

• php for-loop issue

  - by rajesh1984

  Heya, I have a loop which generates a table code for a specific number of times. What I'm having problems with is to echo a variable inside the loop. The loop runs 10 times, and there are 10 text messages sent to the page, so my problem is how do I get each of the looped tables to echo one of the text messages each time?

  Read the article

• Does UNIQ constraint mean also an index on that field(s)?

  - by Gremo

  As title, should i defined a separate index on email column (for searching purposes) or the index is "automatically" added along with UNIQ_EMAIL_USER constraint? CREATE TABLE IF NOT EXISTS `customer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `first` varchar(255) NOT NULL, `last` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_SLUG` (`slug`), UNIQUE KEY `UNIQ_EMAIL_USER` (`email`,`user_id`), KEY `IDX_USER` (`user_id`) ) ENGINE=InnoDB;

  Read the article

• two sql queries in one place

  - by Luke

  <?php $results = mysql_query("SELECT * FROM ".TBL_SUB_RESULTS." WHERE user_submitted != '$_SESSION[username]' AND home_user = '$_SESSION[username]' OR away_user = '$_SESSION[username]' ") ; $num_rows = mysql_num_rows($results); if ($num_rows > 0) { while( $row = mysql_fetch_assoc($results)) { extract($row); $q = mysql_query("SELECT name FROM ".TBL_FRIENDLY." WHERE id = '$ccompid'"); while( $row = mysql_fetch_assoc($q)) { extract($row); ?> <table cellspacing="10" style='border: 1px dotted' width="300" bgcolor="#eeeeee"> <tr> <td><b><? echo $name; ?></b></td> </tr><tr> <td width="100"><? echo $home_user; ?></td> <td width="50"><? echo $home_score; ?></td> <td>-</td> <td width="50"><? echo $away_score; ?></td> <td width="100"><? echo $away_user; ?></td> </tr><tr> <td colspan="2"><A HREF="confirmresult.php?fixid=<? echo $fix_id; ?>">Accept / Decline</a></td> </tr></table><br> <? } } } else { echo "<b>You currently have no results awaiting confirmation</b>"; } ?> I am trying to run two queries as you can see. But they aren't both working. Is there a better way to structure this, I am having a brain freeze! Thanks OOOH by the way, my SQL wont stay in this form! I will protect it afterwards

  Read the article

• How to use the jquery .load() function to return the innerHTML of an element

  - by Eric

  JQuery Assume this works: $('table td').load('/my/url/ div p'); I would end up with <td><p>Some Text</p></td> I want to end up with <td>Some Text</td> How would I do that?

  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

• How to convert a Word file content (with images and tables) into RFC 822 format using c#?

  - by Pari

  Hi, I want to read a Word file (contains images and table). After that i want to convert it's content into "RFC 822 format ". Looking for some APIS and sample code for above.

  Read the article

• problem with IN clause in SQL

  - by user179056

  Hello, We have observed that there seems to be a maximum number of ids/variables which one can pass in the IN clause of SQL as comma seperated values. To avoid this we are storing all the ids in a table and doing a SELECT within the IN clause. This however means extra database operations to store and retrieve ids. Is there any other way to use IN without SELECT? regards Sameer

  Read the article

• How do you change the layout of JUnit Reports in Hudson?

  - by dave

  So, I'm setting up Hudson right now and couldn't be more pleased. However, I need to display a table in the test results page as opposed to the graph it provides. Does anyone know how I would go about doing this?

  Read the article

• Mysql dynamic query

  - by pradeep

  I have two table in mysql one tbl_a which has one int column id, second tbl_b which has one column song_ids in which data stored seapated by comma like 1,2,3,4 i want to select all id like this select * from tbl_a where id in (select song_id from tbl_b) but its giving me no record as its varchar HOW to do it in mysql

  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

• Django database - how to add this column in raw SQL.

  - by alex

  Suppose I have my models set up already. class books(models.Model): title = models.CharField... ISBN = models.Integer... What if I want to add this column to my table? user = models.ForeignKey(User, unique=True) How would I write the raw SQL in my database so that this column works?

  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

• passing a parameter from an other model on ruby

  - by MAGE

  I'm very newbie in ruby and need your help. I must save a "Topic" and make it like this : @topic = Topic.new(params[:topic]) But I would like to pass an other information to this topic. It has a field "community_id" that link it to a community. The logged user has this information on his table. How can I pass the "community_id" from the logged user to the "community_id" of the "topic" created ? thx for your 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 >