Search Results

Search found 10691 results on 428 pages for 'batch insert'.

Page 62/428 | < Previous Page | 58 59 60 61 62 63 64 65 66 67 68 69  | Next Page >

• INSERT and transaction serialization in PostreSQL

  - by Alexander

  I have a question. Transaction isolation level is set to serializable. When the one user opens a transaction and INSERTs or UPDATEs data in "table1" and then another user opens a transaction and tries to INSERT data to the same table, does the second user need to wait 'til the first user commits the transaction?

  Read the article

• SVN commit batch

  - by uzay95

  I know there is a command that updates the changes like c:\svn up <working directory> i wonder if there is any command line statement which can commit the changes. ..: Any help would be appreciated :..

  Read the article

• How to change date formate in mysql stored procedure insert statemant "22-12-2010" to "2010-12-22"

  - by Ayyappan.Anbalagan

  I send the registration date parameter to mysql database like "22-12-2010". But my sql date date type is in another formate how can i change the date formate like "2010-12-22" also i have to insert this into table. Give code in c#,asp.net code behind either sql query statement! Cheerss!!!!! **Thanks A.Ayyappan**

  Read the article

• How to use FormView in order to insert complex entity framework objects

  - by dig

  Hello, I'm trying to use formview in order to do insert of a new entity object (called Customer) Customer has a reference to another entity called Address. How can I fill both of them in the same formview? Thanks.

  Read the article

• Batch faulting in a to-many relationship for a collection of objects

  - by indragie

  Scenario: Let's say I have an entity called Author that has a to-many relationship called books to the Book entity (inverse relationship author). If I have an existing collection of Author objects, I want to fault in the books relationship for all of them in a single fetch request. Code This is what I've tried so far: NSArray *authors = ... // array of `Author` objects NSFetchRequest *fetchRequest = [NSFetchRequest fetchRequestWithEntityName:@"Book"]; fetchRequest.returnsObjectsAsFaults = NO; fetchRequest.predicate = [NSPredicate predicateWithFormat:@"author IN %@", authors]; Executing this fetch request does not result in the books relationship of the objects in the authors array being faulted in (inspected via logging). I've also tried doing the fetch request the other way around: NSArray *authors = ... // array of `Author` objects NSFetchRequest *fetchRequest = [NSFetchRequest fetchRequestWithEntityName:@"Author"]; fetchRequest.returnsObjectsAsFaults = NO; fetchRequest.predicate = [NSPredicate predicateWithFormat:@"SELF IN %@", authors]; fetchRequest.relationshipKeypathsForPrefetching = @[@"books"]; This doesn't fire the faults either. What's the appropriate way of going about doing this?

  Read the article

• How to create sql insert query dynamically in mysql

  - by nectar

  I am creating an application where I am generating pins dynamically based on user's input and storing them into mySql database. $sql = "INSERT INTO tblpin ('pinId', 'ownerId', 'usedby', 'status') VALUES for($i=0;$i<$npin;$i++) { ('$pin[$i]','$ownerid', 'Free', '1'); } ;"; how can I do that?

  Read the article

• Insert a Coldfusion struct into a database

  - by Kevin

  If I wanted to save a contact form submission to the database, how can I insert the form scope in as the submission? It's been some time since I used Coldfusion. The contact forms vary depending on what part of the site it was submitted from, so it needs to scale and handle a form with 5 fields or one with 10 fields. I just want to store the data in a blob table.

  Read the article

• Prevent SQL Server Table operations (INSERT and DELETE) on some tables

  - by stckvrflw

  While working with some random sql queries on our databases, we may not want to insert or delete items to some of the database tables by just typing their names by mistake. So how to make them locked to the "editing", to be able to work safe. Thanks.

  Read the article

• VBA How to find last insert id?

  - by Muiter

  I have this code: With shtControleblad Dim strsql_basis As String strsql_basis = "INSERT INTO is_calculatie (offerte_id) VALUES ('" & Sheets("controleblad").Range("D1").Value & "')" rs.Open strsql_basis, oConn, adOpenDynamic, adLockOptimistic Dim last_id As String last_id = "select last_insert_id()" End With The string last_id is not filled. What is wrong? I need to find te last_insert_id so I can use it in an other query.

  Read the article

• Insert at caret position with a Silverlight textbox

  - by Chris S

  In WPF you can insert at the caret position using the CaretIndex property. However this seems to be missing in the Silverlight textbox control. Is it possible using a different technique?

  Read the article

• how to insert a verify code HTML Standard Paypal

  - by user304828

  i have a product , product infor was save in table , and have a field verify_code, i will create a string by md5 and insert to this field, and i want send this verify_code to paypal then i can check response return from paypal if verify_code == response verify_code will do next action how i can do it with html standard paypal?

  Read the article

• Deleting Duplicates in MySQL

  - by elmaso

  Query was this: CREATE TABLE `query` ( `id` int(11) NOT NULL auto_increment, `searchquery` varchar(255) NOT NULL default '', `datetime` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM first I want to drop the table with: ALTER TABLE `querynew` DROP `id` and then delete the double entries.. I tried it with: INSERT INTO `querynew` SELECT DISTINCT * FROM `query` but with no success.. :( and with ALTER TABLE query ADD UNIQUE ( searchquery ) - is it possible to save the queries only one time?

  Read the article

• Windows batch file to list folders that have a specific file in them

  - by Lee

  I'm trying to create a file that has a list of directories that have a specific file name in them. Let's say I'm trying to find directories that have a file named *.joe in them. I initially tried just a simple dir /ad *.joe > dir_list.txt , but it searches the directory names for *.joe, so no go. Then I concluded that a for loop was probably my best bet. I started with for /d /r %a in ('dir *.joe /b') do @echo %a >> dir_list.txt and it looked like it wasn't executing the dir command. I added the "usebackq", but that seems to only work for the /F command extension. Ideas?

  Read the article

• Using AWK, treate files

  - by Mat

  Hi all, I have something to do that it must be finished before 4.00PM. I want create a batch file with awk, grep or sed that keep all lines beginning with 'INSERT' and delete the other lines. After this, i want replace a string "change)" by "servicechange)" when the 3rd word in the treated line is "donextsit". I don't know how to do this before my deadline (4.00 PM). Please HELP ME!! Thx for your answers. And Sorry for my english ;)

  Read the article

• Insert data into SQL server with best performance

  - by Incognito

  I have an application which intensively uses DB (SQL Server). As it must have high performance I would like to know the fastest way to insert record into DB.Fastest from the standpoint of execution time. What should I use ? As I know the fastest way is to create stored procedure and to call it from code (ADO.NET). Please let me know is there any better way or may be there are is some other practices to increase performance.

  Read the article

• SQL: convert backup file from copy format to insert format

  - by takeshin

  I have a PostgreSQL backup made with PHPPgadmin using Export Copy (instead Copy SQL which is actually what I need). File contains entries like this: COPY tablename(id, field) FROM stdin; ... How to convert this file to SQL format? INSERT INTO tablename... I want to use Pgadmin to to import this file using execute SQL command.

  Read the article

• DOS batch script to list folders that have a specific file in them

  - by Lee

  I'm trying to create a file that has a list of directories that have a specific file name in them. Let's say I'm trying to find directories that have a file named *.joe in them. I initially tried just a simple dir /ad *.joe dir_list.txt , but it searches the directory names for *.joe, so no go. Then I concluded that a for loop was probably my best bet. I started with for /d /r %a in ('dir *.joe /b') do @echo %a dir_list.txt and it looked like it wasn't executing the dir command. I added the "usebackq", but that seems to only work for the /F command extension. Ideas?

  Read the article

• How to insert a float into a SQL table in the rigth locale

  - by SoMoS

  Hello, I have to insert float values into different SQL Servers. Each one can have different locales so in one it the representation could be "42,2" and at another one "42.2" or whatever. How should i construct the query so it works in any SQL Server? Do i need to detect the locale of the server before constructing the query or what? Thanks in advance mates.

  Read the article

• The use of insert in ada?

  - by maddy

  Hi all, Can anyone please tell me the usage of Insert in ada language.I had tried the net but i couldnt just figure out. It would be a great help if anyone could provide me with examples too. Thanks in advance Maddy

  Read the article

• Batch convert latin-1 files to utf-8 using iconv

  - by Jasmo

  I'm having this one PHP project on my OSX which is in latin1 -encoding. Now I need to convert files to UTF8. I'm not much a shell coder and I tried something I found from internet: mkdir new for a in ls -R *; do iconv -f iso-8859-1 -t utf-8 <"$a" new/"$a" ; done But that does not create the directory structure and it gives me heck load of errors when run. Can anyone come up with neat solution?

  Read the article

• Mysql query trouble: uploading

  - by Jakub Zak

  I'm trying for last hour solve this problem. I have a long form and I'm trying to upload info into mysql database. Into table I made. This is the mysql query I'm using: mysql_query("INSERT INTO `users_temp`(`first_name`, `surname`, `birthday`, `nationality`, `email`, `mobile`, `landline`, `address`, `town`, `post_code`, `country`, `password`, `code_conf`) VALUES ([$f_name],[$s_name],[$bday],[$nationality],[$email],[$mobile],[$landline],[$address],[$town],[$post_code],[$country],[$pass],[$conf_code])"); If anyone see any problem why it doesn't work pls let me know. Thank you...

  Read the article

• Is there an api to add a prefix to array keys in PHP?(batch)

  - by user198729

  func($arr); The result should be array('prefix'.$k => ..) Is there?

  Read the article

• Remove a special character and Insert that to a line

  - by Kraj

  How to remove a special character(#) from a big file and insert that character to a particular line for example input.tsv $22 23 24 25 26 33 33 34 35 36 44 45 46 47 48 ID ID1 ID2 ID3 ID4 Output.tsv 22 23 24 25 26 33 33 34 35 36 44 45 46 47 48 $ID ID1 ID2 ID3 ID4 I've used the sed -e 's/#//g' input.tsv file to remove the '$' then how can I include '$' to the line starting with ID

  Read the article

• Generate several sql insert from an sql select sentence

  - by blgnklc

  How can I generate some insert sql sentences using a specific select query. Are there any tool from Ms Sql Server 2008? or else?

  Read the article

• asp.net : I wanted to know how to insert '\n' on the label

  - by veda

  I am just simply creating a web application. I wanted to insert a line break in a label for example label1.Text = "I AM HERE" + "\n" + "I AM NOW HERE"; I wanted to print it as I AM HERE I AM NOW HERE But, it is not working... I don't know why... I even tried label1.Text = "I AM HERE" + '\n' + "I AM NOW HERE"; its not working.. What should I do....

  Read the article

< Previous Page | 58 59 60 61 62 63 64 65 66 67 68 69  | Next Page >