Search Results

Search found 26115 results on 1045 pages for 'table alias'.

Page 708/1045 | < Previous Page | 704 705 706 707 708 709 710 711 712 713 714 715  | Next Page >

• Am I using too much jQuery? When am I crossing the line?

  - by Andrea

  Lately I found myself using jQuery and JavaScript a lot, often to do the same things that I did before using CSS. For example, I alternate table rows color or create buttons and links hover effects using JavaScript/jQuery. Is this acceptable? Or should I keep using CSS for these kinds of things? So the real question is: When I'm using too much jQuery? How can I understand when I'm crossing the line?

  Read the article

• GDI+ Problem encountered in drawing multiples rectangles on the form

  - by Emanuel

  I whant to draw a table in C# Windows Forms using GDI+. When the number of rectangles is too large for all rectangles to be displayed on the form, it does not scroll. And can not access those who did not fit the form. What I need to do to see everything I drawing on the form? Thanks.

  Read the article

• How do I make it save in x-code?

  - by Nathan

  THIS IS USING X-CODE Okay, so I've put in all of the code in order for a page to be saved in a navigation app. I've also made the table refresh once you enter the main screen, but I don't see the page pop up until the second time I come back. How can I make it so it comes up the first time I come in?

  Read the article

• Mysql- "FLUSH TABLES WITH READ LOCK" started automatically

  - by ming yeow

  I would like to understand how this happened. I was running a query that would take a long time, but should not lock up any table. However, my dbs were practically down - it seems like it was being locked up by "FLUSH TABLES WITH READ LOCK" 03:21:31 select type_id, count(*) from guid_target_infos group by type_id 02:38:11 select type_id, count(*) from guid_infos group by type_id 02:24:29 FLUSH TABLES WITH READ LOCK But i did not start this command. can someone tell me why it was started automatically?

  Read the article

• SQL: Is there a more efficient way to calculate elapsed hours, minutes, seconds?

  - by hamlin11

  I'm using Computed Columns to provide me with the following information: Hours, Minutes, and Seconds between a Start DateTime and Finish DateTime (Where Minutes and Seconds are between 0 and 59 and Hours can be any value 0 or greater) Computed Column for Seconds: datediff(second,[Start],[Finish]) % 60 Computed Column for Minutes: floor(datediff(second,[Start],[Finish]) / 60.0) % 60 Computed Column for Hours: floor(datediff(second,[Start],[Finish]) / 3600.0) Here's the table for reference Note: I'm also calculating TotalElapsedSeconds, TotalElapsedMinutes, and TotalElapsedHours in other computed columns, but those are easy. I just feel like I might be missing out on a nice built in function in SQL.

  Read the article

• How get datetime column in sqlite objecite-c

  - by Undolog

  Hi, How do you get a datetime column in sqlite objective-c ? I have a table with 4 fields: pk, datetime, value1 and value 2. pk (primary key), value1 and value2 are integer so I am using: int value1 = sqlite3_column_int(statement, 2); int value1 = sqlite3_column_int(statement, 3); But what should I used for datetime? Thx

  Read the article

• Show child and parent together using CONNECT BY Sql statement

  - by martilyo

  I have an sql statement that currently is just returning all the end parent rows for a list of child rows: SELECT DISTINCT row FROM table heirarchy WHERE parent_row = NULL CONNECT BY nocycle PRIOR parent_row = row START WITH row IN (select statement returning child rows) Is there a way to show the child and its corresponding parent together in the same result set using a modified version of my sql? Thanks.

  Read the article

• How can I make exception handling for all existing SQL server 2005 Stored Procedures, view and funct

  - by Space Cracker

  we have a portal that have SQL server 2005 database that contain about 1750 stored procedures , 250 view and 200 function and 95% of them not have handling exception in their code .. we search about any way that allow us making such a global exception handling in SQL that receive any exception happen in any SP,view or function and stored it in a table we made .. is there something like this in SQL server 2005 or we must write exception handling code on each item ?

  Read the article

• Does Entity Framework currently support custom functions in the Where clause?

  - by André Pena

  Entity Framework currently supports table valued functions and custom functions defined in the SSDL, but I can't find any example of it being used as a criteria, in the where clause. Example: var query = this.db.People; query = query.Where(p = FullText.ContainsInName(p.Id, "George")); In this example, ContainsInName is my custom function that I want to be executed in the where clause of the query. Is it supported?

  Read the article

• MySQL Non Index Queries Analysis

  - by Markii

  I'm using the log queries not using index but it logs all that use indexes but just more advanced or using IFs. Is there a parser or a program out there that can analyze the log and give me a literal output of saying "table.column should be a index" Thanks

  Read the article

• How to play songs programmetically in iPhone from server ?

  - by hib

  Hello all, In my current application I want to show a songs list in table view which is pretty easy but on selection of one of the songs it should be played in any existing audio player in iPhone . How can I do so . Provide me if anyone have good tutorial or example link

  Read the article

• problem with the connectivity/updation using db2(universal driver)

  - by rams

  I choosed a web project in order to do that i am using an IDE (Eclipse), database (DB2 universal driver) and Apache Tomcat server. So, by gods grace every thing has gone well but when I try to update data to DB2 database through JDBC code then I am getting an SQL DB error as :: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2ADMIN.REGISTER where register is my table name and even i logged in as db2admin but i think there is no connectivity established but still its not resolved

  Read the article

• ASP.NET How to call my function when the selected index changes in radio button list without updatin

  - by DedovecES

  I have a table in my form, where I put n-rows, every row contains 1 RadioButtonList, when user select the item in RadioButtonList, I need to get number of selected Item, without updating the page.

  Read the article

• mySQL: Order by field size/length

  - by Sadi

  Here is a table structure (e.g. test): __________________________________________ | Field Name | Data Type | |________________|_________________________| | id | BIGINT (20) | |________________|_________________________| | title | varchar(25) | |________________|_________________________| | description | text | |________________|_________________________| A query like: SELECT * FROM TEST ORDER BY description; But I would like to order by the field size/length of the field description. The field type will be TEXT or BLOB.

  Read the article

• how to change headers data

  - by Moayyad Yaghi

  hello i have the following class class AssetTableModel(QtCore.QAbstractTableModel): def init(self,filename=''): super(AssetTableModel,self).init() self.fileName=filename self.dirty = False self.assets = [] self.setHeaderData(0,QtCore.Qt.Horizontal,QtCore.QVariant('moayyad'),QtCore.Qt.EditRole) and i need to change the headers of the columns or the rows ,i used ( self.setHeaderdata()) but its not working ,i have a table that consistes of 2 columns and 2 rows only. is there any other function that changes headers ??. please help thanx in adnvance

  Read the article

• How I can Optimize this mySQL transaction within java code?

  - by worldpython

  Dear All, I am new to MySql database. I've large table(ID,...). I select ID frequently with java code and.And that make a heavy load on transaction select from tableName where ID=someID notes: 1.Database could be 100,000 records 2.I can't cache result 3.ID is a primary key 4.I try to optimize time needed to return result from query. Any ideas for optimization ? thanks in advance

  Read the article

• MySQL- complex data query in a single statement

  - by yoda

  Hi, Consider the following structure : Ignore the table user_token. Now, imagine that you need to get all the roles related to an user, wich may be through it's related groups or directly related to him. In case the same role appears related to a group and the user directly, the role related to the user will prevail over the role given by the group. Is there any chance this could be done in a single query? Cheers!

  Read the article

• Which is best and easy way to program and show many to many relationship in databse

  - by Mirage

  I have two quantities Cat A , CatB Now the items in Cat A can belong to many items in CatB. and CatB will also have many Items from Cat A. I thinking of having Table1 for Cat A , Table2 for CatB and Table C for relation ship. with PK-A , PK-B Is that correct. How should i make my form in html so that user can select multiple values. Currently i am using select box Any ideas

  Read the article

• Problem in Union Join For MySQL Query

  - by Mac Taylor

  hey guys i managed to select from a table that saves my latest posts but i need to have double condition in selection here is my code : $sql_query = "SELECT b.*,u.username AS MY_Sender FROM TABLE_users u,TABLE_blogs b Where b.reciever = '0' AND u.user_id = b.sender UNION SELECT b.*,u.username AS MY_reciever FROM TABLE_users u,TABLE_blogs b Where b.reciever != '0' AND u.user_id = b.reciever ORDER BY bid DESC LIMIT 0,7 "; but MY_reciever is Null and empty Am i wrong in using UNION for this need ?!

  Read the article

• How can set the background view of a UITableViewCell to the selected background when it is not selec

  - by Tony

  I created a custom implementation of a multi-selectable table view. Multiple rows can be selected programatically. The only part I haven't been able to figure out is how to programatically set the background view of cell to the default system cell selected color/pattern. Does anyone know how to do this? Thanks!

  Read the article

• How to version control data stored in mysql

  - by Shawn

  I'm trying to use a simple mysql database but tweak it so that every field is backed up up to an indefinite number of versions. The best way I can illustrate this is by replacing each and every field of every table with a stack of all the values this field has ever had (each of these values should be timestamped). I guess it's kind of like having customized version control for all my data.. Any ideas on how to do this?

  Read the article

• [H2 and Firebird]auto_increment, identity or trigger plus generator?

  - by blow

  Hi all, in Firebird the only way to have an auto increment coloumn is to setup a generator and use it with a trigger. In H2 db there are auto_increment and identity keywords to do it. What is the best way? Mysql use auto_increment too, but there is some problems with cuncurrence read and table lock, isn't true? Thank you.

  Read the article

• ODBC: when is the best time to create my database?

  - by mawg

  I have a windows program which generates PGP forms which will be filled in later. Those PHP forms will populate a database. It looks very much like MySql, but I can't be certain, so let's call it ODBC. And, yes, it does have to be a windows program. There will also be PHP forms which query the database - examine which tables and fields it contains and then generates forms which can be used to search the database (e.g, it finds a table with fields "employee_name", etc and generates a form which lets you search based on employee name. Let's call that design time and run time. At design time, some manager or IT guy or similar gets to define the nature of the database and at runtime 1) a worker fills in the form daily and 2) management can extract reports. Here's my question: given that the database is defined at "design time" (and populated at run time), where and how is best to do so? 1 I could use an ODBC interface from the windows program, but I am having difficulty finding something good to work with Delphi. Things like ADO and firebird tend to expect you to already have a database and allow you to manipulate it, but I can find no code example of how to create a database and some tables, so ... 2 I could used DOS commands from Delphi in my windows program. I just tried and got a response to MySql --version, but am not sure if MySql etc are more interactive. That is, can I use a script file or a very long stacked command with semicolons and returns separating? e.g 'CREATE DATABASE db; CREATE TABLE t1;' 3) Since the best way to work with databases seems to be PHP, perhaps my windows program could spit out a PHP page which would, when run in a browser, create the database. I have tried to make this as uncomplicated as I can, but please feel free to ask questions. It may be that there are several valid ways, but there is probably one 'better' solution in terms of ease of implementation or maintenance. Better scratch option 3. What if the user later wants to come back and have the windows program change the input form? It needs to update the database too.

  Read the article

• Where binary in SQL

  - by fire

  I have an SQL statement: SELECT * FROM customers WHERE BINARY login='xxx' AND password='yyyy' There are no blob/binary fields in the table, do I need the BINARY after the WHERE what else does it do?

  Read the article

• How do I conditionally select a field from one of two tables?

  - by freakwincy

  I have two tables invoices and pending_payments both of which have the following rows in common: invoice_id and balance. I want to do a select in MySQL that'll work thus: [pseudo-code] if(invoice_id exists in pending_payments table) { select balance from pending_payments where invoice_id = yadayadayada } else { select balance from invoices where invoice_id = yadayadayada } Is this even doable in MySQL? If so, how?

  Read the article

< Previous Page | 704 705 706 707 708 709 710 711 712 713 714 715  | Next Page >