Hi everbody, I have the following table (the number of the references is variable): Id | FK_ID| Reference | ----------------------- 1 2100 GI2, GI32 2 2344 GI56 And I need the following result: Id | FK_ID| Reference | ----------------------- 1 2100 GI2 2 2100 GI32 3 2344 GI56 Is there any short way to tr...
So I'm working on a CMS that will allow users to "traverse" through database tables. I'm having some trouble implementing it though, and am wondering if anyone has any suggestions. Table: house name (varchar), town (relationship, using the rel table) Table: town name(varchar), state (relationship, using the rel table) Table: state na...
Working on parsing a bunch of databases put together in an older, more freewheeling time into a new schema. Basically it's one database per year, with database names like foo98, foo99, foo2000, etc. So for the most recent foo data, I can do something like SELECT foo_person.mdname AS middle_name, ... FROM foo_person, foo_place, foo_thin...
Is there a ways to transform text that is in a specific column of a listview control into password characters? Thank you. ...
Hi all, How to change column order in a table using sql query in sql server 2005? I want to rearrange column order in a table using sql query. Please help. ...
I am looking for a single MYSQL script to convert ALL column names in a database to lowercase in one go... I have inherited a MYSQL database that has a lot of mixed case column names (150 tables with a strange naming convention) and I don't want to go through manually each table by table to do this. Has anyone got such a script? Thank...
I have a list of columns that I will be analyzing. Instead of referring back to the specific index such as data[1][2], I'd like to assign a name to a column and then loop through the rows of the columns for different tasks. How do I assign a name to a column and then is this the correct format to refer back to it? for x in range (len(...
I want to select 15 columns from a table of 20 columns. Is there a way to exclude those 5 columns instead of specifying other 15 columns. ...
Hi there, Here is something I'm trying to achieve using Apache Torque (3.3): Table 1: id f_id start_position end_position Table 2: id f_id start end I need to do: select * from table1 inner join table2 on table1.f_id = table2.f_id and ( (table1.start_position <= table2.start and table1.end_position >= table2.end...
Hi, I am having a date column in my table and I want to fetch that in iPhone application, I use following method to fetch values: objPlayer.type = sqlite3_column_int(selectstmt, 1); Now I can't find something like sqlite3_column_date. Which is the method I can use for this purpose. ...
Is there way to display custom column in inbox with senders e - mail? Or better use From name from contacts if it is found on the basis of senders e - mail? Cause sometime sender has so dummy name in "From", sometime it´s empty etc. ...
Is there a way in R to build a new dataset consisting of a given set of vectors -- median1, median2, median3, median4 -- which are median vectors from a previous dataset s? median1 = apply(s[,c("A1","B1","C1","D1","E1","F1","G1","H1","I1")],1,median) median2 = apply(s[,c("A2","B2","C2","D2","E2","F2","G2","H2","I2")],1,median) median3 ...
I have a table full of tabular data. I need to find the index of a column(cell) in the table. For example: <table> <tr> <td>Column1</td> <td>Column2</td> <td>Column3</td> </tr> <tr> <td>foo</td> <td>bar</td> <td>foobar</td> </tr> </table> function TestIndexOf(someTD) { $(someTD) // what's my column index? } ...
Hi all, In my table table1 there are 6 columns Locations,a,b,c,d,e. Locations [a] [b] [c] [d] [e] [1] 10.00 Null Null 20.00 Null [2] Null 30.00 Null Null Null i need the result like Locations [a] [b] [d] [1] 10.00 Null 20.00 [2] Null 30.00 Null My question is how to detect and delete colum...
Hi, I am working on SQL Server 2005 tables. Here I need to add a column named ‘ID’ as ‘IDENTITY’ column (With starting and incrementing values as 1, 1). Now my problem is that these tables already have thousands of records. So could you please suggest the best and easy way to perform this job? Many Thanks, Regards. Anusha. ...
I'm using jQuery to drive my AJAX UI. I have a table of data, and I want to allow the user to reorder the columns in the table by dragging and dropping them. I'd like the user to be able to grab the header for a column and move it. The row of data underneath should follow. Note that I'm not interested in sorting the data or in reordering...
I am using this: SELECT FROM_UNIXTIME(my_unix_timestamp_column, '%Y') AS year FROM table_name WHERE year = 2009; but it gives me an error: Unknown column 'year' in 'where clause'SELECT FROM_UNIXTIME(my_unix_timestamp_column, '%Y') AS year FROM table_name WHERE year = 2009 Both "my_unix_timestamp_column" and "table_name" are correct...
I recently edited the css on my blog and I haveing two issues. From the home page, everything looks fine; but, when I "Continue Reading" or click on a posting header, the new page is a little messed up. At the bottom of the page, it says "Post Comment." I want this removed. And, there is a ton of white space after the end of the post...
Hi, I'm using jquery.columnfilters.js and I'm looking for a compatible table pagination. I have tryed tablesorter & tablepager + jquery.columnfilters.js without success Thanks ...
Hi I have an entity: public class Message:Entity { public virtual IList<Message> ReplayMessages { set; get; } public virtual Message ParentMessage { set; get; } } I try to override the mapping: mapping.HasMany(x => x.ReplayMessages) .AsSet() .KeyColumnNames.Add("ParentId"); but i...