Search Results

Search found 39491 results on 1580 pages for 'insert id'.

Page 2/1580 | < Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• Insert new row with data computed from other rows

  - by Tyler McHenry

  Suppose I have a MySQL table called MyTable, that looks like this: +----+------+-------+ | Id | Type | Value | +----+------+-------+ | 0 | A | 1 | | 0 | B | 1 | | 1 | A | 2 | | 1 | B | 3 | | 2 | A | 5 | | 2 | B | 8 | +----+------+-------+ And, for each Id, I want to insert a new row with type C…

  Read the article

• Vim: I don't want to insert!!!

  - by bhh1988

  I could not find anything online addressing this problem, which is surprising. The problem is that I find it very easy to accidentally insert stuff in Vim. I know I can undo by with 'u', but it still is quite annoying and frequent. Often, I enter a command like 'sp file.txt' without realizing that I haven't entered the ':' character yet (so I'm…

  Read the article

• Query performance difference pl/sql forall insert and plain SQL insert

  - by user289429

  We have been using temporary table to store intermediate results in pl/sql Stored procedure. Could anyone tell if there is a performance difference between doing bulk collect insert through pl/sql and a plain SQL insert. Insert into or Cursor for open cursor fetch cursor bulk collect into collection Use FORALL to perform insert Which of…

  Read the article

• In postgresql return result of a function in a rule when performing INSERT INTO RETURNING

  - by Dmitry

  I have a View that has several fields. When i INSERT INTO a view I run a function based on INSERT parametrs. The function returns a value. How can I retrieve The value from rule? INSERT RETURNING Gives me: ERROR: cannot perform INSERT RETURNING on relation "full_subntes" ?????????: You need an unconditional ON INSERT DO INSTEAD rule with a…

  Read the article

• Word 2007 multipage tiff picture insert

  - by flxkid

  I have a multipage TIFF file I need to use in Word 2007. Problem is I can only figure out how to insert the first page the multipage TIFF file. Does Word have the ability to let me select which page of the mulipage tiff I want to insert or do I have to break the TIFF file up (which would be a pain)?

  Read the article

• [C#] Linq doesn't insert associated entity on insert.

  - by Tomek

  Hello! I have simple mapping: [Table(Name="Person")] public class Person { private int id; private int state_id; private EntityRef<PersonState> state = new EntityRef<PersonState>(); [Column(IsPrimaryKey = true, Storage = "id", Name="id", …

  Read the article

• How to extent activrerecord,just make id to id.to_i

  - by qichunren

  module ActiveRecord module Mixin alias old_id id def id old_id.to_i end def hello "hellooooooooooooo" end end end ActiveRecord::Base.send :include, ActiveRecord::Mixin I make is because: id column in oracle is number type,not number(10), @user.id return 123.0,not 123,so I would like to do it by extend ar. But my way above does…

  Read the article

• SQL: how to select next id given an id

  - by Marcin K

  There is one table T ( id integer, primary key ( id). I want a parameterized query that, given id i: will return next consecutive id, if i = biggest id in T, query should return the smallest id in T (cyclical)

  Read the article

• Insert a Join Statement - (Insert Data to Multiple Tables) - C#/SQL/T-SQL/.NET

  - by peace

  I have a Winform that has fields need to be filled by a user. All the fields doesn't belong to one table, the data will go to Customer table and CustomerPhone table, so i decided to do multiple inserts. I will insert appropriate data to CustomerPhone first then Insert the rest data to Customer table. Is it possible to Join an Insert OR…

  Read the article

• Insert into Table from #tempTable fails

  - by AJ

  I am simply taking the data from a Table and insert it into #tempTable then delete the data, and insert it back to the table. I get "Insert Error: Column name or number of supplied values does not match table definition." Error. Here are the lines I am running. SELECT * INTO #tempTable FROM dbo.ProductSales SELECT * FROM #tempTable …

  Read the article

• SQL SERVER – Three Methods to Insert Multiple Rows into Single Table – SQL in Sixty Seconds #024 – Video

  - by pinaldave

  One of the biggest ask I have always received from developers is that if there is any way to insert multiple rows into a single table in a single statement. Currently when developers have to insert any value into the table they have to write multiple insert statements. First of all this is not only boring it is also very much time…

  Read the article

• ASP.NET Podcast Show #148 - ASP.NET WebForms to build a Mobile Web Application

  - by Wallym

  Check the podcast site for the original url. This is the video and source code for an ASP.NET WebForms app that I wrote that is optimized for the iPhone and mobile environments.  Subscribe to everything. Subscribe to WMV. Subscribe to M4V for iPhone/iPad. Subscribe to MP3. Download WMV. Download M4V for iPhone/iPad.…

  Read the article

• Select and Insert across dblink

  - by Domtar

  I am having a bit of trouble with a select into insert across a dblink in oracle 10. I am using the following statement: INSERT INTO LOCAL.TABLE_1 ( COL1, COL2) SELECT COL1, COL2 FROM REMOTE.TABLE1@dblink s WHERE COL1 IN ( SELECT COL1 FROM WORKING_TABLE) When I run the statement the following is what gets run against the…

  Read the article

• Insert a list of objects using MyBatis 3

  - by T Soares

  I've tried to insert a list in a database but I've got some the error: org.springframework.jdbc.BadSqlGrammarException: SqlSession operation; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00913: too many values (...). The code that I've used: <insert id="insertListMyObject"…

  Read the article

• Insert multiple values using INSERT INTO

  - by Ben McCormack

  In SQL Server 2005, I'm trying to figure out why I'm not able to insert multiple fields into a table. The following query, which inserts one record, works fine: INSERT INTO [MyDB].[dbo].[MyTable] ([FieldID] ,[Description]) VALUES (1000,N'test') However, the…

  Read the article

• Echo autoincrement id doubt

  - by Marcelo

  Hi, can I print the id, even if it's autoincrement ? Because the way I'm doing I'm using an empty variable for id. $id= ""; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("Não conectou com a base $database"); mysql_query("INSERT INTO table1(id,...) VALUES…

  Read the article

• Event ID 9331 MSExchangeSA & Event ID 9335 MSExchangeSA

  - by George

  I get this two Exchange 2010 Global Address book related event IDs: Event ID 9331 MSExchangeSA OABGen encountered error 80004005 (internal ID 50101f1) accessing the public folder database while generating the offline address list for address list '/'. -\Default Offline Address…

  Read the article

• Jquery Insert element before <tr>

  - by Jerry

  Hi all I am trying to insert a block element Insert something before another . I am not sure if I am using the right method but here is my code. Hope you guys can help. Thanks! Jquery $("#addMatch").click(function(){ $("<td>New…

  Read the article

• Sql Server 2005 multiple insert with c#

  - by bottlenecked

  Hello. I have a class named Entry declared like this: class Entry{ string Id {get;set;} string Name {get;set;} } and then a method that will accept multiple such Entry objects for insertion into the database using ADO.NET: …

  Read the article

• error echo id when i want to echo id for edit

  - by Prasanta Baidya

  I have a entry and edit page of a branch, I want echo id, when I mouse over into edit link in edit button, its show error,: branchedit.php?id=Note:Undefined index:id in line 101, but it work properly in localhost. error picture page link :…

  Read the article

• What could be the Consequence of inserting "id" in any autoincrementing 'id' containing table?

  - by Parth

  What could be the Consequence of inserting "id" in any autoincrementing 'id' containing table? If I have a Tabe in which I have configured the column "id" as the auto incrmented, But still I am using an INSERT query in which id is defined,…

  Read the article

• How do i mount my SD Card? I am using ubuntu 10.04

  - by shobhit

  root@shobhit:/media# lsusb Bus 002 Device 017: ID 14cd:125c Super Top Bus 002 Device 003: ID 0c45:6421 Microdia Bus 002 Device 002: ID 8087:0020 Bus 002 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub Bus 001…

  Read the article

• django redirect url containing id

  - by dana

  hello, i want to add in my settings.py a declaration like: LOGIN_REDIRECT_URL='^private_profile/(?P<id>\d+)/$' #or LOGIN_REDIRECT_URL='/accounts/private_profile/id/' so that when the user with the id 1, for example,is logging…

  Read the article

• Get caller id and append to url in browser automatically

  - by timbad2021

  I am trying to find a caller id device/program that will automatically open a browser and append the incoming phone number to a url when receiving a call. For example: https://www.myphonesearchapp.com/search?q=5733655593 This would…

  Read the article

• Obtaining YouTube video ID in a URL and inputting selected video ID into a URL

  - by Dave

  I've been having trouble in trying to figure this out. What I am trying to do is, obtain the ID of a video from YouTube, and input the 11 character ID into the css of a div of a specific id by using jquery. I know the URL for the…

  Read the article

< Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >