Search Results

Search found 20997 results on 840 pages for 'column store'.

Page 32/840 | < Previous Page | 28 29 30 31 32 33 34 35 36 37 38 39  | Next Page >

• C++ Generate and store the co-ordinates of an n-cube

  - by Ben

  I want to write a function to generate and store the co-ordinates of an n-cube and I have no idea how to start. Specifically, I wish to generate the co-ordinates for an evenly or randomly distributed cloud of points for this n-cube and store them. What would be a good way to start with this or if possible, a quick solution?

  Read the article

• What's the best, Escape then store Or store then escape the output?

  - by Axel

  Hi, After doing a long search on stackoverflow i didn't find any one talked about this even if it's a big choice, the Question is what's the best in order to prevent both of XSS and SQL injection, Escaping the data then store it in the DB or Store it as it is and escape when output it? Note: it is better if you give some examples of practics if possible. Thanks

  Read the article

• How to convert a table column to another data type

  - by holden

  I have a column with the type of Varchar in my Postgres database which I meant to be integers... and now I want to change them, unfortunately this doesn't seem to work using my rails migration. change_column :table1, :columnB, :integer So I tried doing this: execute 'ALTER TABLE "table1" ALTER COLUMN "columnB" TYPE integer USING CAST(columnB AS INTEGER)' but cast doesn't work in this instance because some of the column are null... any ideas?

  Read the article

• MySQL don't want to store unicode charecter

  - by Qiao

  Why MySQl don't wont to store unicode character ??? Yes, it is rare hieroglyph, you wouldn't see it in the browser. UTF16 is U+2B5EE Warning: #1366 Incorrect string value: '\xF0\xAB\x97\xAE' for column 'ch' at row 1 Is it possible to store this character in MySQL?

  Read the article

• Best way to dynamically get column names from oracle tables

  - by MNC

  Hi, We are using an extractor application that will export data from the database to csv files. Based on some condition variable it extracts data from different tables, and for some conditions we have to use UNION ALL as the data has to be extracted from more than one table. So to satisfy the UNION ALL condition we are using nulls to match the number of columns. Right now all the queries in the system are pre-built based on the condition variable. The problem is whenever there is change in the table projection (i.e new column added, existing column modified, column dropped) we have to manually change the code in the application. Can you please give some suggestions how to extract the column names dynamically so that any changes in the table structure do not require change in the code? My concern is the condition that decides which table to query. The variable condition is like if the condition is A, then load from TableX if the condition is B then load from TableA and TableY. We must know from which table we need to get data. Once we know the table it is straightforward to query the column names from the data dictionary. But there is one more condition, which is that some columns need to be excluded, and these columns are different for each table. I am trying to solve the problem only for dynamically generating the list columns. But my manager told me to make solution on the conceptual level rather than just fixing. This is a very big system with providers and consumers constantly loading and consuming data. So he wanted solution that can be general. So what is the best way for storing condition, tablename, excluded columns? One way is storing in database. Are there any other ways? If yes what is the best? As I have to give at least a couple of ideas before finalizing. Thanks,

  Read the article

• Store java.util.Calendar field into one column

  - by Rasika

  How to store java.util.Calendar field into one column with Datanucleus JDO. By default it is stored into two columns (millisecs, Timezone) with following JDO metadata. field name="startDate" serialized="true" embedded="true" persistence-modifier="persistent" What need to be changed in metadata to store it into single column (Timestamp)? Is it posible query (JDOQL) on calendar field when it is in two clumn?

  Read the article

• Store data in DB as is, or escaped?

  - by Yegor

  Whats a better way to store textual data, such as comments, user profile fields that require them to type something in, etc? Store the escaped data right away (using htmlspecialchars in php for example), or put it thru the same function before its echoed out?

  Read the article

• Cassandra performance slow down with counter column

  - by tubcvt

  I have a cluster (4 node ) and a node have 16 core and 24 gb ram: 192.168.23.114 datacenter1 rack1 Up Normal 44.48 GB 25.00% 192.168.23.115 datacenter1 rack1 Up Normal 44.51 GB 25.00% 192.168.23.116 datacenter1 rack1 Up Normal 44.51 GB 25.00% 192.168.23.117 datacenter1 rack1 Up Normal 44.51 GB 25.00% We use about 10 column family (counter column) to make some system statistic report. Problem on here is that When i set replication_factor of this keyspace from 1 to 2 (contain 10 counter column family ), all cpu of node increase from 10% ( when use replication factor=1) to --- 90%. :( :( who can help me work around that :( . why counter column consume too much cpu time :(. thanks all

  Read the article

• How to store the file in the database ?

  - by Harikrishna

  How to store the file which is uploaded by the user to the database ? I want to store the file in the database how can we do that ? In the back-end I am using sql with c#.net application.

  Read the article

• How to get the Perticluar column value using jquery

  - by rockers

  I used this code to get the perticular column value using jquery.. $("#Grid td:first-child").click(function() { var resultArray = $(this).closest('tr').find('td').text(); alert(resultArray); }); How to get the peticular column value? that is I need grid 4th and 5th column value? thanks

  Read the article

• SQL Server store procedure line number issue

  - by George2

  Hello everyone, I am using SQL Server 2008 Enterprise. I met with issue which says line 9 of store procedure foo is meeting with dead lock issue. My question is how to find exactly the 9th line of the store procedure? My confusion is because of coding format issue, how to locate 9th line correctly. thanks in advance, George

  Read the article

• What are the best ways to store Graphs in persistent storage

  - by nicoslepicos

  I am wondering what the best ways to store graphs in persistent storage are, for later analysis, search, clustering, etc. I see neo4j being an option, I am curious if there are also other graph databases available. Does anyone have any insights into how larger social networks store their graph based data (or other sites that require the storage of graph like models, e.g. RDF). What about options like Cassandra, or MySQL?

  Read the article

• how to get app-store reivew url?

  - by beof

  In my application,I want to remind the user to write a reivew, however,when I copy the link write a review as shown below: http://itunes.apple.com/tw/app/id MyID?mt=8 It is the same as the product link. I follow this guide: http://blogs.oreilly.com/iphone/2008/08/scraping-appstore-reviews.html The US account can successfully link to the page,but the China-Twain Can not ,it pop an alertView saying:Cannot connect to iTunes Store The iTunes Store is not supported in this country. anyone has good suggestions?

  Read the article

• How to store infinite value for Datetime

  - by narmadha

  Hi,I am working With C#.net Desktop Application,Here I need to store ratio,from date and todate,from date will be given by the User,But to date should be Considered as Infinite,Why I need this means,After a month If i am changing the ratio means,at that time,i will give the from date,but to date shoul be considered as Infinite ,this fromdate.Adddays(-1) will be updated with previous todate,so that i need how to store infinte value for datetime,Thanks in Advance....................

  Read the article

• CSS Multi-Column Forms in HTML/ASP.NET

  - by Caveatrob

  I've researched for hours and still haven't found a robust, non-absolute-positioning solution for displaying multiple-column forms and values without using TABLE tags. Can someone point me to a resource specifically oriented towards reproducing table-based, multiple-column forms (like name and address forms) in CSS to standards? Most of the forms I see only have a single column with field/value.

  Read the article

• Store 3d models in game, the best way

  - by subSeven

  What is the best method to store 3d models in game ? I store in vectors: vector triangles (each triangle contain number of texcords, numer of vertex and number of normal), vector points; vector normals; vector texCords;

  Read the article

• How to find if dataTable contains column which name starts with abc

  - by VilemRousi

  In my program I have a dataTable and I´d like to know if is there a column which name starts with abc. For example I have a DataTable and its name is abcdef. I like to find this column using something like this: DataTable.Columns.Constains(ColumnName.StartWith(abc)) Because I know only part of the column name, I cannot use a Contains method. Is there any simple way how to do that? Thanks a lot.

  Read the article

• SSRS Column Grouping with specific order

  - by AmiT

  Hi Experts, Is it possible to change order of records/groups in a result-set from a query using Group By? =I have a query: SELECT Category, Subcategory, ProductName, CreatedDate, Sales From TableCategory tc INNER JOIN TableSubCategory ts ON tc.col1 = ts.col2 INNER JOIN TableProductName tp ON ts.col2 = tp.col3 Group By Category, SubCategory, ProductName, CreatedDate, Sales = Now, I am creating a ssrs report where Category is Primary row group, then SubCategory is its child row group. Then ProductName is a Primary Column Group. It works perfect, But it shows the ProductNames in alphabatic order. I want it to show the ProductNames in custom order(defined by me).Like, ProductNo5 in 3rd column, ProductNo8 in 4th column, ProductNo1 in 5th column ... and so on!

  Read the article

• Count of products NOT sold...per store, per day over the past month

  - by user1893510

  I'm struggling with an interview question. 3 dimension tables (Product, Store and Date) and 1 fact table (Sales). The question asks for a T-SQL solution that will return the count of products not sold, per store, per day over the past month. At this point, my answer is futile but I've spent significant time trying to back into a solution, to no avail, and would like to close the loop. Any guidance is greatly appreciated.

  Read the article

• Issue with Column footer and Summary bands on Jasper reports

  - by lakshmi

  I am creating invoices with Jasper reports. I have a detail section that has the list of all items followed by a column footer which has Totals, Tax etc., and then the return policy in the Summary section. I want to always ensure that the detail is followed by column footer followed by summary bands. How can we ensure this? I found that sometimes the Summary comes before the Column footer. Can someone throw some light on this? Thanks, Lakshmi

  Read the article

• Store children in database preserving information about their order

  - by GUZ

  I am designing database tables for a master-detail scenario. The specific requirement is that it is necessary to store information about the order of children. I see some possible solutions (like adding a column representing a position in the sequence, or a column with foreign key to the previous child) but I would like to know the best practices how to solve such problems. Best regards Lukasz Glaz

  Read the article

• How to get the Particular column value using jquery

  - by rockers

  I used this code to get the particular column value using jquery.. $("#Grid td:first-child").click(function() { var resultArray = $(this).closest('tr').find('td').text(); alert(resultArray); }); How do I get the particular column value? That is, I need grid 4th and 5th column value?

  Read the article

• applying paddingRight to flex grid column not to grid header

  - by Ben

  Whenever I add paddingRight to a column in the flex grid, it adds the padding to the header as well. Is anyone familiar with how I can add paddingRight just to the column and not to the header? Below is the column code where I was specifying the padding. <mx:DataGridColumn width="60" headerText="Type" dataField="Grade" headerStyleName="headerLeft" textAlign="left" draggable="false" resizable="false" headerRenderer="GridHeaderRenderer" paddingRight="5"/>

  Read the article

• Replacing a column in CSV file with another in bash

  - by user2525881

  I have a csv file with a number of columns. I am trying to replace the second column with the second to last column from the same file. For example, if I have a file, sample.csv 1,2,3,4,5,6 a,b,c,d,e,f g,h,i,j,k,l I want to output: 1,5,3,4,5,6 a,e,c,d,e,f g,k,i,j,k,l Can anyone help me with this task? Also note that I will be discarding the last two columns afterwards with the cut function so I am open to separating the csv file to begin with so that I can replace the column in one csv file with another column from another csv file. Whichever is easier to implement. Thanks in advance for any help.

  Read the article

• mysql and indexes with more than one column

  - by clarkk

  How to use indexes with more than one column The original index has an index on block_id, but is it necesarry when it's already in the unique index with two column? Indexes with more than one column (a,b,c) you can search for a, b and c you can search for a and b you can search for a you can not search for a and c Does this apply to unique indexes too? table id block_id account_id name indexes origin PRIMARY KEY (`id`) UNIQUE KEY `block_id` (`block_id`,`account_id`) KEY `block_id` (`block_id`), KEY `account_id` (`account_id`), indexes alternative PRIMARY KEY (`id`) UNIQUE KEY `block_id` (`block_id`,`account_id`) KEY `account_id` (`account_id`),

  Read the article

< Previous Page | 28 29 30 31 32 33 34 35 36 37 38 39  | Next Page >