Search Results

Search found 10060 results on 403 pages for 'column'.

Page 235/403 | < Previous Page | 231 232 233 234 235 236 237 238 239 240 241 242  | Next Page >

• how can I insert value into a table in sql server 2000 , 2005, 2008?

  - by ricky roy

  I have a table having a single auto Auto Incremented column. How Can i insert the value. Using Insert into table or some other way Thanks Waiting for your replay..

  Read the article

• Can you send a full result set to an SQL function?

  - by PylonsN00b

  I am working in Postgres and I need to send in a full result set with many rows and column into a stored procedure or a function. Is this possible? If so, where can I see resources for syntax?

  Read the article

• postgresql drop table

  - by Russell

  I have two tables (tbl and tbl_new) that both use the same sequence (tbl_id_seq). I'd like to drop one of those tables. On tbl, I've removed the modifier "not null default nextval('tbl_id_seq'::regclass)" but that modifier remains on tbl_new. I'm getting the following error: ERROR: cannot drop table tbl because other objects depend on it DETAIL: default for table tbl_new column id depends on sequence tbl_id_seq After reviewing http://www.postgresql.org/docs/9.1/static/sql-droptable.html It looks like there is only CASCADE and RESTRICT as options.

  Read the article

• Gnuplot - splot matrix csv data

  - by Jakub Czaplicki

  How can I plot (a 3D plot) a matrix in Gnuplot having such data structure. I cannot find a way to use the first row and column as a x and y ticks (or to ignore them) ,5,6,7,8 1,-6.20,-6.35,-6.59,-6.02 2,-6.39,-6.52,-6.31,-6.00 3,-6.36,-6.48,-6.15,-5.90 4,-5.79,-5.91,-5.87,-5.46 Is the splot 'data.csv' matrix the correct parameter to use ?

  Read the article

• sort arrow is always showing up once sorting is used

  - by kksachin

  we have several pages as tabs where datatable is used in most of the pages.when we sort on a particular coulmn and exit the page and re enter this page the arrow appears(up /down based on how we left) Although the data is not sorted in the direction the arrow shows.i have set preserveSort and preserveDataMode to false. The arrow is set to true in the column's t:commandSortHeader tag in all the pages. is this a bug or am i missing any setting?I have tried to set forceId to false in t:commandSortHeader but of now use.

  Read the article

• solr range query errors

  - by mquinsland

  http://localhost:8983/solr/select?wt=json&q=lat:[35%20to%2038] results in **org.apache.lucene.queryParser.ParseException: Cannot parse 'lat:[35 to 38]': Encountered " "38 "" at line 1, column 11. Was expecting: "]" This is a pretty basic range query and this error will prevent us from using SOLR for our projects

  Read the article

• Serialize checkbox array, also get checkboxes with off-value

  - by guzh

  Hi, I was wondering if this is possible. The serialize-string will be inserted in a mySQL-database, so it would be fine if all checkboxes would be inserted and not only the ones that is ticked(on). it's possible to make on column in the database for each of the checkboxes, and use this if/else-statement: if(isset($_GET['checkbox'])) { // It's checked! } else { // not checked! } but its a bit unappropriate...

  Read the article

• Saving any file to in the database, just convert it to a byte array?

  - by Blankman

  Is converting a file to a byte array the best way to save ANY file format to disk or database var binary column? So if someone wants to save a .gif or .doc/.docx or .pdf file, can I just convert it to a bytearray UFT8 and save it to the db as a stream of bytes?

  Read the article

• not single-group grouping function while using regr_slope

  - by Peter Kaleta

  HI I try to run : select year, regr_slope(sum(sale_count),year) as slope, from products group by year It throws "00937. 00000 - "not a single-group group function"" .When i delete year from select clause problem disapears. Shouldn't I be able to select column with which I'm grouping? Oracle 11.2 sqldeveloper ty for help !

  Read the article

• How to access SysListView32 elements in QTP?

  - by Onnesh

  We are having a table of elements in SysListView32. Actually they are a table arranged under 5 columns. How to access 3rd column in the table in SysListView32?

  Read the article

• What's making my page extend slightly beyond the viewport? [CSS]

  - by Jack W-H

  Basically I'm a tad confused. You'll see at http://furnace.howcode.com , in the second column, the bottom scrollbar button is extended slightly beyond the end of the viewport. I'm pretty confused as I've been examining the CSS and can't find anything that's causing this. Can you have a look? It's probably something simple that I've just missed! :) Screenshot:

  Read the article

• ASP.NET site errors output nothing on the page.

  - by d1k_is

  OK, i have been doing some work modding a pre-compiled ASP.NET application (VB codebehind) but i have come across something i have never seen before. When ever theres an error on the loading of a page, the page outputs nothing (no error message, no error message, nothing at all) firefox displays this error: XML Parsing Error: no element found Location: http://site.local/Checkout.aspx Line Number 1, Column 1: Because there is no html output. Is there some sort of setting that im missing that makes IIS/ASP.NET function like this?

  Read the article

• MSSQL - select date field in table

  - by thegunner

  Hi, In my table I have a date column which the date is displayed in the format "2009-11-18 10:55:28.370" How can just get the date value of this field in a select statement. e.g. select id from risks, where creation_date = getdate()

  Read the article

• Determine stale data

  - by Andrei

  Say I have a file of this format 12:04:21 .3 12:10:21 1.3 12:13:21 1.4 12:14:21 1.3 ..and so on I want to find repeated numbers in the second column for, say, 10 consequent timestamps, thereby finding staleness. and I want to output the beginning and and end of the stale timestamp range Can someone help me come up with it? You can use awk, bash Thanks

  Read the article

• Ruby: Dynamically calling available methods raising undefined method (metaprogramming)

  - by user94154

  I have an Activerecord object called Foo: Foo.attribute_names.each do |attribute| puts Foo.find(:all)[0].method(attribute.to_sym).call end Here I'm calling all attributes on this model (ie, querying for each column value). However, sometimes, I'll get an undefined method error. How can ActiveRecord::Base#attribute_names return an attribute name that when converted into its own method call, raises an undefined method error? Thank

  Read the article

• In sql server, is there any way to check whether the schema change will impact on the stored procs?

  - by ziang

  In SQL Server, is there any way to check whether the changes in the schema will impact Stored Procedures (and/or Views)? For example a change of the column name in one table, may break some Stored Procedures; how to check the impacted stored procs?

  Read the article

• PostgreSQL: Why does this simple query not use the index?

  - by David

  I have a table t with a column c, which is an int and has a btree index on it. Why does the following query not utilize this index? explain select c from t group by c; The result I get is: HashAggregate (cost=1005817.55..1005817.71 rows=16 width=4) -> Seq Scan on t (cost=0.00..946059.84 rows=23903084 width=4) My understanding of indexes is limited, but I thought such queries were the purpose of indexes.

  Read the article

• first Occurrence Of Non Blank Cell vba

  - by Madhu Kiran

  Hi, I am trying to write VBA code which works on my Excel sheet. Range("A65536").End(xlUp).Row gives me the row number of the last non blank cell. similarly i am trying to get the row number of the first non blank cell in that particular column. Thanks in advance. madhu

  Read the article

• Unique Constraint At Data Level in GAE

  - by Ngu Soon Hui

  It seems that the unique constraint is not natively supported in GAE, although one can enforce unique check before putting an object to store. But that was in January 2009, what about now? Can I specify unique constraint on a column during schema creation? i.e. class Account(db.Model): name = db.StringProperty() email = db.StringProperty() as unique # something like this @classmethod def create(cls, name, email): a = Account(name=name, email=email) a.put() return a

  Read the article

• Query a stored procedure for it's parameter names and types

  - by ho1

  Is there any easy way to query a stored procedure (Oracle - PL/SQL) for what parameters it expects? I know that I can query USER_SOURCE to get the whole procedure but I'd then have to parse the whole procedure, and if the parameter is of type [table].[column]%TYPE I'd then have to query the table schema as well. Either using just sql or via ODP.Net.

  Read the article

• MySQL More Tables or More Rows

  - by Pez Cuckow

  I am working on a game that I am going to open to the public to have on their game. The game stores lots of information (about 300 rows) per website and spends a lot of time updating values within this MySQL database. Is it better (faster/efficient) to add a new table for every website or to just have 1000's of rows in one table and add a column "website_id" or similar?

  Read the article

• Arrangement of n objects in a n x n square

  - by Hwang

  if have multiples object, how to arrange it so that each number of object in row x column will form a near square? exp:14 objects arrange to something like this: 0 0 0 0 0 0 0 0 0 0 0 0 0 0

  Read the article

• Crystal reports CSV incorrect generation

  - by yauhen

  When setting ExportFormatType.CharacterSeparatedValues crystal report generates every row of data prefixed with column names (Report Headers). Why it does this? How it could be fixed? Usually it is preferred to have single header. For excel export type - generated report looks ok (only single header for all rows). I am using crystal reports 11.5.3700.0. Visual studio 2008, .net 3.5 sp1

  Read the article

• BINDing an ASP.NET 2.0 FormView - CheckBox or RadioButton to Oracle CHAR(1) Y/N

  - by Pete

  Oracle 9i has not BOOLEAN data type. CheckBoxes in ASP.NET are BOOLEAN controls are they not? So using a CHAR(1) column with Y or N values in the Oracle table, how do I bind to a CheckBox or CheckBoxList or RadioButton or RadioButtonList control on an ASP.NET 2.0 web form? I'm using VB, 'specially since I'm a noobie.

  Read the article

• mysql query optimization

  - by vamsivanka

  I would need some help on how to optimize the query. select * from transaction where id < 7500001 order by id desc limit 16 when i do an explain plan on this - the type is "range" and rows is "7500000" According to the some online reference's this is explained as, it took the query 7,500,000 rows to scan and get the data. Is there any way i can optimize so it uses less rows to scan and get the data. Also, id is the primary key column.

  Read the article

< Previous Page | 231 232 233 234 235 236 237 238 239 240 241 242  | Next Page >