Search Results

Search found 25547 results on 1022 pages for 'table locking'.

Page 694/1022 | < Previous Page | 690 691 692 693 694 695 696 697 698 699 700 701  | Next Page >

• 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

• mysql category tree search

  - by ffffff

  I have the following schema on MySQL 5.1 CREATE TABLE `mytest` ( `category` varchar(32) , `item_name` varchar(255) KEY `key1` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; category column is filled with like that [:parent_parent_cat_id][:parent_cat_id][:leaf_cat_id] "10000200003000" if you can search all of the under categories :parent_parent_category_id SELECT * FROM mytest WHERE category LIKE "10000%"; it's using index key1; but How to use index when I wanna search :parent_cat_id? SELECT * FROM mytest WHERE category LIKE "%20000%"; Do you have a better solutions?

  Read the article

• How to specify :primary_key starting value in rails schema migration?

  - by RewbieNewbie

  I have a postgres table and a schema that creates a primary id (sequence) that auto increments by 1. How do I specify the starting value? I am happy with the increment value. Here is my schema migration: create_table "ServiceProvider", {:primary_key => :ID} do |t| t.integer "ID", :null => false end Thank you

  Read the article

• How should i output my MySQL data into json in this kind format?

  - by sky

  Im not sure how to output MySQL data into formats below. (eg: timelist, usersex, userage from table users.) timeList = new Array(), userSex = new Array('female','male','male'), userAge = new Array('21','36'), userMid = new Array('liuple','anhu'); Thanks!

  Read the article

• jQuery Sortable Cannot Click After Sort Issue

  - by Johan

  I have a table that is being sorted by the TR tags, everything works fine except that I have to click twice on any item in the list after something has been moved for anything to respond, on links etc. Do I have to call some function after the list has been sorted to re-activate it so that I don't have to click twice on items?

  Read the article

• One label, two different fonts?

  - by 4thSpace

  I need to format text in a label like this: username: some text from this user. This will create additional lines of text that will go on and on and on. Where "username" is bold. This will go into a UILabel, which is in a custom table cell. Is there a way to get this type of layout?

  Read the article

• In SQL, can we always write an inner join statement as a main query and subquery?

  - by Jian Lin

  In SQL, can we always write an inner join statement as a main query and subquery? For example, select * from gifts g where g.giftID in (select giftID from sentGifts); can do a join and show the gifts sent in the sentGifts table, but it won't be able to show the sentTime because that is inside the subquery?

  Read the article

• Update Mysql database with dataset changings? (C#)

  - by Ases

  I'm changing my dataset in my program. And when my job was finished, I'm connecting to mysql database. I don't want to do this job again, how can I send changings to database like this mydatadapter.Update(dataset, " table"); I found this code, but I can't run it :S

  Read the article

• sort date fields to obtain earliest date

  - by manu

  in my database , dates are stored in DD-mm-yyyy format , how can i sort this to obtain the earliest date ? Cursor c = myDb.query(TABLE, new String[]{"dob"}, null, null, null, null, "dob"); I have selected it to order by dob field but its not ordered ... This is the output for the above query 01-03 17:14:51.595: VERBOSE/ORDER DOB(1431): 01-11-1977 01-03 17:14:51.595: VERBOSE/ORDER DOB(1431): 01-12-1988 01-03 17:14:51.614: VERBOSE/ORDER DOB(1431): 15-01-1977 01-03 17:14:51.656: VERBOSE/ORDER DOB(1431): 31-01-1988

  Read the article

• RSS feed publish date-time (GMT) to Unix timestamp format using PHP

  - by PHP-Prabhu

  How do convert RSS feed publish date-time (GMT) to Unix timestamp using PHP? I need to store the date into my table in a TIMESTAMP data type column.

  Read the article

• SQL query to get most

  - by chama

  I have a database with the following tables: Employee (EmpID, FirstName, LastName, RegionID) EmployeeSkills(EmpID, SkillID) [this is a linking table for the M:N relationship between Employees and skills] Skills(SkillID, Description) I need to list the name of the skill that most employees have. I tried doing a max(count(skillID)), sqlserver said that you can't do an aggregate function on an aggregate function. Any other ideas? Thank you in advance!

  Read the article

• Is it bad to have a non-clustered index that contains the primary key from the clustered index?

  - by Don

  If you have a table with a clustered index on the Primary Key (int), is it redundant and bad to have one (ore more) non-clustered indexes that include that primary key column as one of the columns in the non-clustered index?

  Read the article

• Simple tool/steps to obfuscating/scrubbing production data

  - by Krishna Kumar

  I am involved in a project where I need to provide subset of our production data (for a date range) to one of my co-workers for trouble shooting. I would like to scrub the data and insert this in to another table. Please suggest best approach to achieve this

  Read the article

• How to use pdo's prepared statement for order by and limit ?

  - by user198729

  $sql = "SELECT * FROM table ORDER BY :sort :dir LIMIT :start, :results"; $stmt = $dbh->prepare($sql); $stmt->execute(array( 'sort' => $_GET['sort'], 'dir' => $_GET['dir'], 'start' => $_GET['start'], 'results' => $_GET['results'], ) ); I tried to use prepare to do the job,but $stmt->fetchAll(PDO::FETCH_ASSOC); returns nothing.

  Read the article

• Inserting random characters to MYSQL Database

  - by spotlightsnap

  I want to add 100 entry to users table numbers field, random characters length is 10, all entry should be unique as well. How can i achieve this using MYSQL query code ? Or do i need to use PHP ? Help me with code snippets please. Thanks.

  Read the article

• Linux Sendmail Same username multiple domains

  - by Dev Jadeja

  I have configure my sendmail for multiple domains by creating username like [email protected] [email protected] [email protected] in passwd file Now I added entry in file /etc/mail/virtusetable like [email protected] sales\@domain1.com [email protected] sales\@domain2.com [email protected] sales\@domain3.com So when configuring the email client you provide your username as [email protected],[email protected] etc. I tested with webmail and outlook it works. Is this the best way to do it ?.Do i need to put the entry in any there file like genericstable or alias table?

  Read the article

• i want to solve my sql query

  - by Dharmendra

  i have one table bbc(country,region,area,population,gdp) and i want to list the regions with total population of at least 100 million. be careful it is very tuff query

  Read the article

• HTTP triggers for Postgres

  - by HeineyBehinds

  I'm trying to write a Postgres trigger such that when a configuration table is updated, a backend component is notified and can handle the change. I know that Oracle has the concept of a web/HTTP trigger, where you can execute an HTTP GET from the Oracle instance itself to a URL that can then handle the request at the application layer. I'm wondering if Postgres (v. 9.0.5) has the same feature, or comes with anything similar (and, subsequently, how to set it up/configure it)?

  Read the article

• php reading mysql bit field returning weird character

  - by user121196

  I am using mysql_fetch_assoc($query), one of the bit field returns out to be , which is supposedly to be true. The problem is that I also need to output this to xml and it's an illegal xml character. the charset for the db table is utf-8. why does this happen?

  Read the article

• Getting all database entries into organized array

  - by Industrial

  Hi everyone, I have just made the update/add/delete part for the "Closure table" way of organizing query hierarchical data that are shown on page 70 in this slideshare: http://www.slideshare.net/billkarwin/sql-antipatterns-strike-back However, I have a bit of an issue getting the full tree back as an multidimensional array from a single query. Here's what I would like to get back: array ( 'topvalue' = array ( 'Subvalue', 'Subvalue2', 'Subvalue3' = array ('Subvalue 1', 'Subvalue 2', 'Subvalue 3' ) ); );

  Read the article

• Django - 2 fields unique together

  - by webvulture

  Suppose, I want to record say poll choices by users everyday. In this case, i have a table named vote which has columns poll , choice and user-id . So how can i out the constraint (maybe in the django models or wherever possible) that poll and user-id both should not be the same for any entry but like the same user can vote for various different polls once and obviously various users can vote for the same poll. I hope I am clear.

  Read the article

• how to use SMTP + PHP + MYSQL ?

  - by Ronnie Chester Lynwood

  Hello guys I've got a mass mail function that sends e-mail to all emails in my mysql table. but theyr all goes spam. I want to use smtp validate for this function. How can I use smtp validation with "mail($email, $subject, $message, $headers);" ? thank u

  Read the article

• SQL and/or LINQ query for determining daily increases in viewers

  - by Gio

  We're montioring usage of a certain resources by monitoring users logins (We can see user logins growing daily). After filtering out repeat inter day logins for users, we'd like to track the # of users using the service each day, and then using that info to determine overall incremental gains for each calendar day. Our table is pretty simple: class ServiceLogin { String login; DateTime loginTime; }

  Read the article

• Polymorphic association inserts 0 instead of raising error when column is misconfigured as Integer

  - by zetetic

  Here's one that stumped me for a while, though in retrospect it should have been obvious. I was getting the error message NoMethodError: undefined method `constantize' for 0:Fixnum when accessing a model through a polymorphic association. Turns out the table on the belongs_to side of the association had an integer type column instead of a string. Easily fixed, but it seems like Rails ought to raise an error in this situation -- instead it happily adds the row with 0 in the type column.

  Read the article

• Selecting rows distinctively

  - by noway

  Lets assume my database table structure is something like | items | weight | |============|==========| | item_1 | 50 | | item_2 | 90 | | item_2 | 45 | | item_2 | 60 | | item_3 | 40 | In the select statement, I want to show an item only for once with the highest weight also ordered by height. So the result should be : | items | weight | |============|==========| | item_2 | 90 | | item_1 | 50 | | item_3 | 40 | I tried something like SELECT DISTINCT items, weight FROM mytable ORDER BY weight DESC but it didn't work because the results are actually distinct. How can I make that selection?

  Read the article

< Previous Page | 690 691 692 693 694 695 696 697 698 699 700 701  | Next Page >