Search Results

Search found 26283 results on 1052 pages for 'temporary table'.

Page 720/1052 | < Previous Page | 716 717 718 719 720 721 722 723 724 725 726 727  | Next Page >

• one very tuff query i need help

  - by Dharmendra

  table is bbc(name, region, area, population, gdp) Some countries have populations more than three times that of any of their neighbours (in the same region). Give the countries and regions. plese go ahead

  Read the article

• Relational Database arrays (H2, Java)

  - by Daddy Warbox

  I seem to have two options on how to implement arrays, and I want to know which I should go with: Use the ARRAY data type and (from what I understand) effectively serialize data objects into the database (which in my case are just wrapped primitive types; don't know of another way to make this work). Use a separate table and map with foreign keys for each array item. If you have experience with this (especially with H2), which would you recommend?

  Read the article

• Adding new row at the top of the cell in iphone

  - by venkat

  hey all i have a program for inserting new now dynamically in table view. But it displays the inserted row the end.How can i display the inserted row at the first position.

  Read the article

• not case sensitive query in mysql

  - by Mac Taylor

  hey guys i need to query my database and find results : mysql_query("select * from ".ALU_TABLE." where username like '%$q%' or name like '%$q%'"); if i have a name in my table such as Book and i enter book in search box it wont show the Book i need to query my database as not to be case sensitive.

  Read the article

• [jquery/javascript] How select all checkboxes with class "xxx" ?

  - by marc

  Welcome, It it possible to select all checkboxes / uncheck all checkboxes what have class "xxx" ? I can't use "name" and "ID" because there are generated dynamical via PHP and i don't know their name. So maybye i can add class "xxx" for these what i wan't control ? Is is possible ? Or, if not possible. Maybye i can select all / unselect what are inside table with id "selectall" ? Regards

  Read the article

• Updated Timestamp field in MySQL through PHP

  - by Vincent

  All, I have a database table in mysql with a field that is of "TIMESTAMP" type. I need help writing the SQL query to update the field with the current timestamp. UPDATE tb_Test set dt_modified = ????? Thanks,

  Read the article

• SQL java get value assigned to auto increment primary key

  - by iamrohitbanga

  I have a primary key auto increment attribute in my table. I want to know the value assigned to it for a row that is inserted using statement.executeQuery(). How to achieve this in the best possible manner?

  Read the article

• Is there a CSS library which mimics the iPhone grouped UITableView?

  - by cannyboy

  Is there a CSS library which mimics the iPhone grouped UITableView? I want to build a nice looking table which looks exactly like the grouped UITableView. As there are multiple text styles within the each line of text, and I don't need any interactivity except scrolling, it seems it would be easier to build with HTML and display it in a UIWebView. Is there a css library which matches this need?

  Read the article

• How to get user details from OpenID server?

  - by sri

  I'm wanting to save some OpenId fields to a localdatabase table, such as •Full Name •openid url •passworg how to get those attributes from openid server? please send me some example code in asp.net, c#...

  Read the article

• How do I modify the hundards of records based on my query result?

  - by Nano HE

  Hi, I inserted some error record to my table, I can query via the sql below and found hundards of record marked with half. SELECT * FROM `marathon` WHERE gender = 'male' && distance = 'half'; How to write a SQL then I can modify the result rows distance from 'half' to 'full'. Thank you.

  Read the article

• changing existing duplicate entries in mysql

  - by Mladen

  sorry for the (probably) noob question, but I', new at this stuff. i have a table that has column 'position', and I want to, when inserting a new row, change positions of every row that has position lower than row that is inserted. for example, if I add row with position 4, if there is a duplicate, it should become 5, 5 should shift to 6 and so on... also, is there a way to get highest value for column besides testing it in every row via php?

  Read the article

• Mysql optimization

  - by Jens

  I have this mysql table called comments which looks like this: commentID parentID type userID date comment The commentID is set as Primary key, but most of the time I fetch the data using the parentID. How should I set my indexes? Should I just add an index on parentID and let commentID be the primary key?

  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

• How to write stored procedure to do this?

  - by chobo

  I would like to create a stored procedure that takes in a string of comma separated values like this "1,2,3,4", and break it apart and use those numbers to run a query on a different table. so in the same stored procedure it would do something like select somefield from sometable where somefield = 1 select somefield from sometable where somefield = 2 select somefield from sometable where somefield = 3 select somefield from sometable where somefield = 4 Thanks!

  Read the article

• How to save Excel date time cell into MySQL using VBA?

  - by mysqlizor

  The mysql table has a DATETIME field. I want to INSERT a new row into this field using the cell data from the Excel worksheet. But I cannot use the datetime formatted cell value in a INSERT INTO query. How can I implement this?

  Read the article

• MySQL INSERT IGNORE not working

  - by gAMBOOKa

  Here's my table with some sample data a_id | b_id ------------ 1 225 2 494 3 589 When I run this query INSERT IGNORE INTO table_name (a_id, b_id) VALUES ('4', '230') ('2', '494') It inserts both those rows when it's supposed to ignore the second value pair (2, 494) No indexes defined, neither of those columns are primary. What don't I know?

  Read the article

• What is wrong with this SQL syntax?

  - by Finbarr

  UPDATE files SET filepath = REPLACE(filepath, `sites/somedomain.com/files/`, `sites/someotherdomain.com/files/`); I have a table called files with a field called filepath. MySQL returns this error: Unknown column 'sites/somedomain.com/files/' in 'field list'

  Read the article

• How to get number of attributes in a java class?

  - by llm

  I have a java class containing all the columns of a database table as attributes (member variables) and corresponding getters and setters. I want to have a method in this class called getColumnCount() that returns the number of columns (i.e. the number of attributes in the class)? How would I implement this without hardcoding the number? I am open to critisims on this in general and suggestions. Thanks.

  Read the article

• indentationLevel property doesn't appear to do anything?

  - by JoBu1324

  I'm have a number rows I'm inserting into a table using -insertRowsAtIndexPaths:withRowAnimation, and I would like the rows to be indented from the left to distinguish them from the rest of the cells. The indentationLevel property of UITableViewCell looks like it's exactly what I need, but it doesn't seem to do anything. Here's the code I'm using to set the indentation level (dot syntax doesn't make a difference): [cell setIndentationWidth:10]; [cell setIndentationLevel:1]; Is indentationLevel what I want, or should I be looking elsewhere?

  Read the article

• Select number of rows in all tables in the database

  - by Alex N.

  I wonder if this is possible with straight SQL on MySQL. I need to do SELECT COUNT(*) FROM on each table in the database and output results in one result set. Is it possible to do with just SQL?

  Read the article

• Would this Jquery selector work?

  - by Alex

  Hi all, would the following Jquery selector get all of the 4th td elements of all the tables on the current page, and return their text as an array?: var isbn = $.makeArray($("table tr td:nth-child(4)").text());

  Read the article

• R multi plot log-log Label Problem

  - by ACEnglish

  I'm trying to make a graph of a table and graph it in log space. First of all, plot(dat) gives me the grid of graphs Second of all, plot(dat, log="xy") gives me the correct plots of data in log space However, plot(dat, log="xy") ruins the main diagonal's labels of names(dat) R version 2.11.0

  Read the article

• Copy a Doctrine object with all relations

  - by elManolo

  I want to copy a record with all his relations. I'm trying with: $o = Doctrine::getTable('Table')->Find(x); $copy = $object->copy(); $relations = $o->getRelations(); foreach ($relations as $name => $relation) { $copy->$relation = $object->$relation->copy(); } $copy->save(); This code doesn't works, but I think it's on the way.

  Read the article

• Solve:Value was either too large or too small for an Int32.

  - by jithincool

  I am passing query string and the url is as follows- http://localhost:1086/Web/EditMobile.aspx?sno=2. But when i try to enter the url as follows,localhost:1086/Web/EditMobile.aspx?sno=2*3424324423432424* , i get the following error-Value was either too large or too small for an Int32. How do i handle this error. I must get an error report like " the value is not found in the table or database"

  Read the article

• SSIS Package performance during bulk insert

  - by vartika

  SSIS performance degrades when using bulk insert task in for each loop to upload multiple files into one target table. how to maintain SSIS performance

  Read the article

< Previous Page | 716 717 718 719 720 721 722 723 724 725 726 727  | Next Page >