Search Results

Search found 8267 results on 331 pages for 'insert'.

Page 17/331 | < Previous Page | 13 14 15 16 17 18 19 20 21 22 23 24  | Next Page >

• mysql and .net: when using tableadapters I’m getting MySqlException “insert command denied for user”

  - by Deveti Putnik

  Hi! I am using mysql as db for my asp.net application. Here are the facts: I am using connection string from web.config which has both username and password. I can do SELECT with tableadapter. When I am trying to do INSERT with tableadapter, I am getting "mysqlexception insert command denied for user" error When I try to do INSERT…

  Read the article

• MySQL Insert Data Question

  - by Nano HE

  Hi, assume I already created a table in MySQL as below CREATE TABLE IF NOT EXISTS `sales` ( `id` smallint(5) unsigned NOT NULL auto_increment, `client_id` smallint(5) unsigned NOT NULL, `order_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `sub_total` decimal(8,2) NOT NULL, `shipping_cost`…

  Read the article

• Insert hex string value to sql server image field is appending extra 0

  - by rotary_engine

  Have an image field and want to insert into this from a hex string: insert into imageTable(imageField) values(convert(image, 0x3C3F78...)) however when I run select the value is return with an extra 0 as 0x03C3F78... This extra 0 is causing a problem in another application, I dont want it. How to stop the extra 0 being added? …

  Read the article

• Mysqli prepared insert statements always returning false

  - by user1754679

  I'm writing prepared statements that are supposed to insert data into a table, on a database that's been pre-selected in the variable $GLOBALS['mysqli']. The connection has been tested, and that's not the problem I'm having. I'm only running into trouble whenever my prepared statement involves INSERT INTO. I know the tablename, and…

  Read the article

• Loading large amounts of data to an Oracle SQL Database

  - by James

  Hey all, I was wondering if anyone had any experience with what I am about to embark on. I have several csv files which are all around a GB or so in size and I need to load them into a an oracle database. While most of my work after loading will be read-only I will need to load updates from time to time. Basically I just need a…

  Read the article

• How to remove insert image button from Yahoo Rich text editor

  - by Nitz

  Hey Guys, I am using ThickBox 3.1 one one page. Now, there is one problem, i am using one form to open thickbox on the button click event. And i am using yahoo text editor on that form. And in the yahoo rich text editor there is one link of image insert.. but i don't know why its not opening. on click of it. the image insert…

  Read the article

• Crystal Reports: Cannot insert some fields from Field Explorer to Report

  - by zdhacz

  I have an existing report (Crystal Reports 11) that is based on two Oracle views. I have made 'Verify database' already, it's done and up to date. My problem is that I can insert some fields to report but some other I cannot. For example: field Name (string(35)) is ok, but similar field Compamy (string(20)) I cannot insert to…

  Read the article

• Insert Statment with Case for avoid duplicate record insertion

  - by rama

  I have written the below SP for Precheck for Duplicate records before insert into Table . but it is not allow me yo write insert staement inside the CASE . how can I write Stored Procedure for fist Check the value @Ordername into table After that if it is not present then it should inserted into Database . CREATE…

  Read the article

• Check if exists, if so, update by 1++, if not insert

  - by Scarface

  Hey guys quick question, I currently have an insert statement $query= "INSERT into new_mail VALUES ('$to1', '0')"; where fields are username, and message_number Currently what I would do to check if the entry exists, is do a select query then check the number of rows with mysql_num_rows (php). If rows==1 then I get the…

  Read the article

• C# mysql one return last_insert_id

  - by Bernhard

  I am trying to create a method in which I can exequte mysql UPDATE, DELETE or INSERT query. The method must work when with an INSERT I ask or do not ask the last_insert_id(). Below is the code that I have at the moment: public int executeUID(MySqlCommand msCommand) { try { this.Open(); …

  Read the article

• Java Insert Help...???

  - by El Classico

  I am trying to do an Insert, Update and Delete on a table in MS Access. Everything works fine for a SELECT statement. But when doing the other three operations, I don't seem to get any errors, but the actions are not reflected on to the DB. Please help... THe INSERT statement is as follows: …

  Read the article

• "No bootable device - insert boot disk" after restart on Ubuntu 10.04 b1 update

  - by anjanesh

  I was making an update on my Ubuntu 10.04 beta1 64-bit PC when, after reboot I get PXE-E61: Mediaa test failure, check cable PXE-M0F: Exiting Intel Boot Agent. No bootable device - insert boot disk and press any key How did my boot record disappear ? BIOS Boot Boot Menu Type :…

  Read the article

• "No bootable device - insert boot disk" after restart on Ubuntu 10.04 b1 update

  - by anjanesh

  I was making an update on my Ubuntu 10.04 beta1 64-bit PC when, after reboot I get PXE-E61: Mediaa test failure, check cable PXE-M0F: Exiting Intel Boot Agent. No bootable device - insert boot disk and press any key How did my boot record disappear ? BIOS Boot Boot Menu Type :…

  Read the article

• Vim Stuck In Insert Mode

  - by Levi Hackwith

  I've been using Vim for several months now via my web host (they allow putty access). All of a sudden, the escape key has become unresponsive. I cannot exist insert or any other mode by simply hitting escape. I have to hit F1 which brings up the help in vim and kicks me into command mode. I'm…

  Read the article

• insert system disk error after switchting SATA cables

  - by Matthias

  I have 5 hard disks built in my computer, two connected by IDE cables, three by SATA. Today I had to return two of the SATA cables to my room mate. So I grabbed another one I had floating around and connected the remaining disk by unplugging my DVD R/W. Now I receive the 'insert system disk…

  Read the article

• Vim Stuck In Insert Mode

  - by Levi Hackwith

  I've been using Vim for several months now via my web host (they allow putty access). All of a sudden, the escape key has become unresponsive. I cannot exist insert or any other mode by simply hitting escape. I have to hit F1 which brings up the help in vim and kicks me into command mode. …

  Read the article

• Cage nuts - which way to insert them?

  - by Ingmar Hupp

  Cage nuts can be inserted (in square holes) either with the flaps horizontal or vertical. I've seen and used both methods, but am still not sure which is best. Is there a recommended way of inserting them? If so, why is it the best way? From my own experience, the horizontal way (on the…

  Read the article

• Insert escaped characters in seq command separator

  - by dhekir

  How do I insert a string containing escaped characters (\n, \t, etc) as separator for the seq command? The standard format includes a newline character: $ seq 3 1 2 3 But if I try to add something plus a newline, the backslash is escaped and a literal "\n" is used…

  Read the article

• MySQL server simple insert/update/delete queries are taking a long time to execute

  - by ElGabbu

  We have a VPS hosting server with a MySQL server running on it. We host several databases for client's websites. Recently we have noticed that insert/update and delete queries are taking a long time to execute sometimes as close as 30 seconds. I use the following command to see…

  Read the article

• Insert text into a div from a poput form and rewrite the inserted text with javascript

  - by kuswantin

  So I read some related questions here before I asked, but can't find the answer to my problem. Hope some javascript master here can find this and bring the light to me. I created another button for nicEdit, a video button and wanted to insert some formatted text into the editor…

  Read the article

• Bulk inserting and updating with Entity Framework (Probably a better alternative?)

  - by Dave

  I have a data set of devices, addresses, and companies that I need to import into our database, with the catch that our database may already include a specific device/address/company that is included in the new data set. If that is the case, I need to update that entry with the…

  Read the article

• insert multiple rows via a php array into mysql

  - by toofarsideways

  I'm passing a large dataset into a mysql table via php using insert commands and I'm wondering if its possible to insert approximately 1000 rows at a time via a query other than appending each value on the end of an mile long string and then executing it. I am using the…

  Read the article

• Using ROWLOCK in an INSERT statement (MS SQL)

  - by RPS

  Would it be wise to use ROWLOCK on an insert statement that is copying large amounts of data and inserting it into the same table? Ex) INSERT INTO TABLE with (rowlock) (id, name) select newid, name) from TABLE with (nolock) where id = 1 Does anybody have…

  Read the article

• Master/Detail insert using BCP?

  - by Joseph

  I've a master table with identity on for the primary key and I've some child tables. When I insert a record to the master table using BCP, how can I use the newly created ID from the master table to insert in the related child tables (May be BCP again)? Will…

  Read the article

• bulk insert image from relative path

  - by Markus

  Hi, I wonder if some can help me out with this little problem. I have the following insert statement: insert into symbol (sy_id, sy_fg_color, sy_bg_color, sy_icon) select 302, 0, 16245177, sy_icon = (select * from openrowset(bulk…

  Read the article

< Previous Page | 13 14 15 16 17 18 19 20 21 22 23 24  | Next Page >