Search Results

Search found 36762 results on 1471 pages for 'common table expression'.

Page 283/1471 | < Previous Page | 279 280 281 282 283 284 285 286 287 288 289 290  | Next Page >

• Postgresql: how to create table only if it does not already exist?

  - by Fredriku73

  I am totally new to postgresql. How can I do a condition to create a table only if it does not already exists? Code example appreciated.

  Read the article

• Need a good way to store data in a DB from a table on a webpage that can have N columns.

  - by Abe Miessler

  Users need to be able to add a specific type of column to an otherwise static table on my web page and then save the information they enter in there to the database. I've been told that in reality they will almost never go over 5 columns but I would rather support N. The columns will all be of the same datatype. My first thought was to have an XML column with the values from all added columns in there but I was curious if anyone else had come up with a better solution. Suggestions?

  Read the article

• convert table of input values into 2D array or struct?

  - by Henry

  What's the easiest way to convert a table of values (2D grid like Excel), into a 2D array or struct in ColdFusion? Thought of using dot in the name and eval them to become struct, but AFAIK name attribute of input field can only contains alpha numeric and underscore, and first char must be an alpha char.

  Read the article

• Put indexes on a table with lots of BOOL/TINYINT?

  - by John Tyler

  An old mentor once told me to place indexes on most things you use a WHERE clause for. Should I put an index on BOOL/TINYINT's? There is a significant amount of them in the table I am working with, and often results are filtered by anywhere from 1-20 of these boolean conditions.

  Read the article

• Should searchable date fields in a database table always be indexed?

  - by Spencer Ruport

  If I have a field in a table of some date type and I know that I will always be searching it using comparisons like between, > or < and never = could there be a good reason not to add an index for it?

  Read the article

• Fluent Nhibernate napping to existing database with primary key in joining table of a many to many r

  - by Todd

  I have an existing database with a many to many relationship however the joining table has a primary key ID and 2 foreign keys to do the join. Is it possible to configure the mapping files to handle this? at the moment i am stuck. Thanks

  Read the article

• Is it possible to use CSS to align these divs/spans in a table-like manner?

  - by Justin L.

  I have <div class='line'> <div class='chord_line'> <span class='chord_block'></span> <span class='chord_block'>E</span> <span class='chord_block'>B</span> <span class='chord_block'>C#m</span> <span class='chord_block'>A</span> </div> <div class='lyric_line'> <span class='lyric_block'></span> <span class='lyric_block'>Just a</span> <span class='lyric_block'>small-town girl</span> <span class='lyric_block'>living in a</span> <span class='lyric_block'>lonely world</span> </div> </div> (Excuse me for not being too familiar with proper css conventions for when to use div/spans) I want to be able to display them so that each chord_block span and lyric_block span is aligned vertically, as if they were left-aligned and on the same row of a table. For example: E B C#m A Just a small-town girl living in a lonely world (There will often be cases where an empty chord block is matched up to non-empty lyric block, and vice-versa.) I'm completely new to using CSS to align things, and have had no real understanding/experience of CSS aside from changing background colors and link styles. Is this possible in CSS? If not, how could the div/class nesting structure be revised to make this possible? I could change the spans to divs if necessary. Some things I cannot use: I can't change the structure to group things by a chord_and_lyric_block div (and have their width stretch to the length of the lyric, and stack them horizontally), because I couldn't really copy/select the lyrical lines continuously in their entirety, which is extremely critical. I'm trying to avoid a table-like solution, because this data is not tabular at all. The chord line and the lyric line are meant to be read as one continuous line, not a set of cells. Also, apart from the design philosophy reasons, I think it might have the same problems as the previous thing bullet point. If this is possible, what div/span attributes should I be using? Can you provide sample css? If this is not possible, can it be done with javascript?

  Read the article

• Is there a way to get photo tags and new friendship type events by querying the FQL stream table?

  - by Fletcher Moore

  When you look at your stream on the Facebook website, events such as "FriendX was tagged in an album", "FriendY is attending EventZ", and "FriendK and FriendL are now friends". I've tried various "vague" queries on the stream table, and so far I have been unable to get these types of events. Is this possible, or do I need to query the all of the other tables and write a ton of logic to try to figure out which new events to show and how to show them?

  Read the article

• Simple way to render tuples to a table in ASP.NET 2.0?

  - by njk

  Say I have a data structure like a Dictionary<string, Dictionary<string, int>> or similar, and I want to render this as an HTML table with row-headers as the first string key, and column headers as the second string key. Is there a built-in or other Control for this?

  Read the article

• How to use hook alter form in module to register a user and also save some data in another table?

  - by user363036

  have a general idea on how to use hook alter to modify the feel of the registration form . However the challenge I have is to not only have the user register, but to save some extra data into another table and then redirect user to a new page. How would I get about doing that? Please help

  Read the article

• .NET: Which strategy is better for populating a gridview? using a Data Table and bind it or using a

  - by odiseh

  hi ASP.NET: Which strategy is better for populating a gridview? filling a Data Table and bind it or using a data reader ? Which one has a better performance?

  Read the article

• What is the best way to determine if table already has record with specific ID?

  - by iburlakov

  Hello. I have a short question. Im my current project I'm using LINQ-to-SQl. That is the best way to determine if table has record with specific ID? Thanks in advance.

  Read the article

• JPA Is there a way to do something like SELECT <field>, count(*) FROM <table> GROUP BY <field>

  - by javydreamercsw

  I've been looking in the web for examples on the aggregates like count but it seems all of them are using the aggregate alone. SELECT field, count(*) FROM table GROUP BY field Should have something like: field.value1, x1 field.value2, x2 .... I'm looking for a pure JPA answer for this one. If not I guess I can then do further queries just for the count part but that seems unefficient. Any ideas?

  Read the article

• I have a 18MB MySQL table backup. How can I restore such a large SQL file?

  - by Henryz

  I use a Wordpress plugin called 'Shopp'. It stores product images in the database rather than the filesystem as standard, I didn't think anything of this until now. I have to move server, and so I made a backup, but restoring the backup is proving a horrible task. I need to restore one table called wp_shopp_assets which is 18MB. Any advice is hugely appreciated. Thanks, Henry.

  Read the article

• How can I LIMIT rows updates in MySQL if more than one table is involved?

  - by Taz

  I am trying to run an UPDATE query UPDATE ner.nerdataset, ner.shortabstracts SET ner.nerdataset.ShortAbstract=ner.shortabstracts.ShortAbstract WHERE ner.shortabstracts.Resource=ner.nerdataset.ResourceURI LIMIT 10; As MySQL does not allow the use of LIMIT when more than one table is involved in UPDATE what else can be done to limit this?

  Read the article

• Append Results from two queries and output as a single table.

  - by tHeSiD

  I have two queries that I have to run, I cannon join them But their resultant tables have the same structrure. For example I have select * from products where producttype=magazine select * from products where producttype = book I have to combine the result of these two queries, and then output it as one single result. I have to do this inside a stored procedure. PS These are just examples I provided, i have a complex table structure. The main thing is I cannot join them.

  Read the article

• why i cannot access my website with its ipaddress. but only with sitename. Is this common?

  - by railscoder

  I have website http://waycoolblog.com . but i cannot access through its ip address http://74.220.219.56/ why is this happening. ? My main question is whether this is a common thing. in my app am trying to the resolve the sitename myself and trying to connect with the ipaddress instead of sitename. I want to makesure this that works properly. Thanks.

  Read the article

• How can I tell when a MySQL table was last updated?

  - by RaGE

  In the footer of my page, I would like to add something like "last updated the xx/xx/200x"; with this date being the last time a certain mySQL table has been updated. What is the best way to do that ? Is there a function to retrieve the date ? Should I make an access to the database everytime my footer is displayed ?

  Read the article

• Quickest way to dump Python dictionary (dict) object to a MySQL table?

  - by NJTechGuy

  I have a dict object. I dumped the data using this: for alldata in data: # print all data to screen print data[alldata] Each field had brackets [] and 'None' values for NULLS and date.datetime for date values. How do I dump this dict to MySQL table? Thank you!

  Read the article

• Hi can anyone try how to solve the query for this table structure???

  - by atrueguy

  Employee table structure first_name varchar2(100) last_name varchar2(100) hire_date date show all the employee who hired on the day of the week on which highest number of employees were hired?

  Read the article

• How to update a table using a select group by in a second one and itself as the data source in MySQL

  - by Jader Dias

  I can do this: SELECT t2.value + sum(t3.value) FROM tableA t2, tableB t3 WHERE t2.somekey = t3.somekey GROUP BY t3.somekey But how to do this? UPDATE tableA t1 SET speed = ( SELECT t2.value + sum(t3.value) FROM tableA t2, tableB t3 WHERE t2.somekey = t3.somekey AND t1.somekey = t3.somekey GROUP BY t3.somekey ) ; MySQL says it's illegal since you can't specify target table t1 for update in FROM clause.

  Read the article

• Does unique on a temporary table column create an index?

  - by Bmw

  I have a temporary table that I'm using and I have a unique column, example:myID INT UNIQUE Would this create an index on that column? Or do I have to explicitly create the index?

  Read the article

• Getting a date value in a postgres table column and check if it's bigger than todays date

  - by Roland

  I have a Postgres table called clients. The name column contains certain values eg. test23233 [987665432,2014-02-18] At the end of the value is a date, I need to compare this date, and return all records where this specific date is younger than today I tried select id,name FROM clients where name ~ '(\d{4}\-\d{1,2}\-\d{1,2})'; but this isn't returning any values. How would I go about to achieve the results I want?

  Read the article

• In MySQL, if the movies table has a description field, how to do search on this description?

  - by Jian Lin

  Say, using MySQL, if the movies table has 20,000 records, and each record has a field that is the description of the movie, up to 2k byte long. How can we search for movies with the word "nature" in its description? If possible, it is to be fast, instead of going through all the 20,000 records. (if in some other situations, like for books, where n can be 200,000 or more).

  Read the article

• New to CakePHP -> How To Add Columns To a MySQL Table?

  - by walden

  I had a website made for me a long time ago, and the programmer did it in CakePHP. I'm now editing his scripts. I added a couple columns to a table, and found that doing saveField() on the new column does not do anything. How do I make CakePHP recognize the new columns? I'd appreciate your help. I'm not too familiar with CakePHP, so please go easy on me =)

  Read the article

< Previous Page | 279 280 281 282 283 284 285 286 287 288 289 290  | Next Page >