Search Results

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

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

• How to insert a float into a SQL table in the right 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

• Does an insert made in a transaction is visible by SELECT before transaction is commited

  - by 20c

  I need a confirmation. Client 1 insert rows in a table inside a transaction. Client 2 request this table with a SELECT. If on this client isolation level is set to READ COMMITTED, can you confirm that the SELECT won't returns the rows that aren't yet committed by Client 1. Thanks

  Read the article

• MSBUILD batch targets

  - by Darthg8r

  I want to deploy an application to a list of servers. I have all of the build issues taken care of, but I'm having trouble publishing to a list of servers. I want to read the list of servers from an external file and call a target passing the name of each server in. <ItemGroup> <File Include="$(SolutionFolder)CP\Build\DenormDevServers.txt" /> </ItemGroup> <Target Name="DeployToServer" Inputs="Servers" Outputs="Nothing"> <Message Text="Deployment to server done here. Deploying to server: @(Servers)" /> </Target> <Target Name="Test"> <ReadLinesFromFile File="@(File)"> <Output TaskParameter="Lines" ItemName="Servers" /> </ReadLinesFromFile> <CallTarget Targets="DeployToServer" ContinueOnError="true"></CallTarget> </Target> I can't seem to get it to "Deploy" to each server in the list. The output looks like this: Deployment to server done here. Deploying to server: Notice there is no server name, nor is done more than once. There are 2 lines in DenormDevServers.txt

  Read the article

• Insert text into WPF textbox at caret position

  - by Roice

  How can I insert text into a WPF textbox at caret position? What am I missing? In Win32 you could use CEdit::ReplaceSel(). It should work as if the Paste() command was invoked. But I want to avoid using the clipboard.

  Read the article

• Rails each loop insert tag every 6 items?

  - by dustmoo

  Hello Stack Anon, I have X number of image objects that I need to loop through in a view and want to create a new div every 6 objects or so (for a gallery). I have looked at cycle but it seems to change every other record. Does anyone know of a way to insert code into a view every 6 times? I could probably do it with nested loops but I am kinda stumped on this one. Thanks!

  Read the article

• Getting can't modify frozen string when using string.insert

  - by Richard

  Hi, This is a quick question. I have the following ruby code, which works fine. def add_zeros number, zeros number = number.to_s zeros_to_add = zeros - number.length zeros_to_add.times do number = "0#{number}" end number end But if I replace number = "0#{number}" With number.insert(0, "0") Then I get TypeError: can't modify frozen string, does anyone know why this is?

  Read the article

• Insert the lowest possible unique positve integer in an atomic fashion in MySql

  - by Jason Christa

  Say I have a table with a unique positive integer field. I currently have rows with id's of [1, 2, 3, 4, 5, 8, 12, 35]. Is there a insert query that I could write that would assign the id field to the lowest unique positive integer (in this case 6)? It would have to do this atomically so there isn't the possibility of concurrent inserts wiping out each other or failing.

  Read the article

• Returning the PK during a linq to sql insert

  - by Blankman

  I want to return the PK ID when I insert a new user via linq to sql. how can I do this? i.e. is there anything built in or do I have to do 2 queries?

  Read the article

• Not able to execute trigger at bulk insert in sql

  - by Vishwa

  Hi In bulk insertion only in the last record trigger is executing. Example : if i bulk insert 10 records the trigger is running only for the 10th record. But I need trigger to run on all 10 records. Please help me with an example

  Read the article

• How to round current time in teradata and insert into timestamp(6) feilds

  - by user3471254

  I have a table with date fields of timestamp(6) fields . create table test_time ( t1 timestamp(6) format 'mm/dd/yyyy hh:mm:si' , ); I want to insert into this table with current date and time rounded. i.e. say for example if the current date time is 08/07/2014 10:34:56 then the value in the table should be 08/07/2014 10:00:00 . (or) if current data and time is 08/07/2014 10:54:56 then also the value should be 08/07/2014 10:34:56

  Read the article

• Check if row exists, if not add it [MySQL]

  - by Steven

  I need to add a row to a MySQL database table but only if the row doesn't already exist. My database server just went down so I can't test this, but will this work as expected? INSERT INTO `blocks` (`block_file`,`settings_group`) VALUES ('announcements','announcement_settings') WHERE NOT EXISTS (SELECT `block_file`,`settings_group` FROM `blocks` WHERE `block_file`='announcements' AND `settings_group`='announcement_settings') It seems like sound logic. Is this a valid query or is there a better way of doing this?

  Read the article

• Insert Picture into SQL Server 2005 Image Field using only SQL

  - by Germstorm

  Using Ms SQL Server 2005 and Management Studio how do I insert a picture into an Image type field of a table? Most importantly how do I verify if it is there?

  Read the article

• MySQL float values jumping around on insert?

  - by dubayou

  So i have a SQL table setup as such CREATE TABLE IF NOT EXISTS `points` ( `id` int(11) NOT NULL auto_increment, `lat` float(10,6) NOT NULL, `lng` float(10,6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; And im inserting stuff like INSERT INTO `points` (`lat`, `lng`) VALUES ('89.123456','-12.123456'); Gives me a row with lat and lng being 89.123459 and -12.123455 Whats up?

  Read the article

• RTF.Insert(Index,String) doesn't work

  - by mr-developer

  i'm wondering why doesn't this work ? it gives me the exception that the "File Format Is Not Valid" richTextBoxPrintCtrl1.Rtf = richTextBoxPrintCtrl2.Rtf.Insert(richTextBoxPrintCtrl1.SelectionStart, myString);

  Read the article

• Insert a newline character every 64 characters using Python

  - by biffabacon

  Using Python I need to insert a newline character into a string every 64 characters. In Perl it's easy: s/(.{64})/$1\n/ How could this be done using regular expressions in Python? Is there a more pythonic way to do it?

  Read the article

• Batch backup a harddrive without modifying access times C#

  - by johnathan-doena

  I'm trying to write a simple program that will backup my flash drive. I want it to work automatically and silently in the background, and I also want it to be as quick as possible. The thing is, resetting all the access times is useless to me, and something I want to avoid. I know I can read the access times and set them back, but I bet it will fail one day in the future. It would be much simpler to read the files without ever changing it. Also, what is the fastest way to do this? What differences would there be between, say, a flash drive and an external hard drive. I am writing this in C#, as it is the simplest way to do it and it will probably last more generations of Windows..

  Read the article

• Row insertion order entity framework

  - by Wouter

  I'm using a transaction to insert multiple rows in multiple tables. For these rows I would like to add these rows in order. Upon calling SaveChanges all the rows are inserted out of order. When not using a transaction and saving changes after each insertion does keep order, but I really need a transaction for all entries.

  Read the article

• How insert 2 different forms on the same page in Django

  - by xRobot

  I have to insert 2 forms in the same page: 1) Registration form 2) Login form . So if I use this in the views.py: if request.method == 'POST': form = registrationForm(request.POST) if form.is_valid(): form.save() return render_to_response('template.html', { 'form': form, }) I will get error by submitting one of two forms. How can I distinguish the 2 forms submitting in the views ?

  Read the article

• PHP exec() not executing batch files

  - by Andreas Bonini

  I tried googling for this issue and found many people with the same problem but no solution. $result = exec("C:\\Ruby191\\bin\\lessc.bat less\\$file", $output); Here result is an empty string and output an empty array. Same thing with: $result = exec("cmd /c C:\\Ruby191\\bin\\lessc.bat less\\$file", $output); I am sure the path is correct; I am sure exec() is enabled. I tried exec, shell_exec, system and none work. lessc is less CSS.

  Read the article

• How to insert a float into a SQL table in the right locale (in .Net)

  - 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

• Batch adding attribute to attribute sets

  - by JonB

  I have a Magento installation with around 60 attribute sets. I need to add a new attribute to each of the attribute sets. There doesn't seem to anyway of doing this in the admin control panel. I am sure I can work it out by manually entering the correct fields into the database, but is there a way of doing this through the API or through the Import / Export profiles? Any suggestions would be gladly received.

  Read the article

• Javascript insert parameter inside string

  - by amemak

  Hi, I want to ask if there is a way to insert variable inside another string which is part of another statement. For example: function SomeFunction(field) { var someVariable = document.getElementById('<%=' + field + '.ClientID %'); } But I've got an error: Error 6 'string' does not contain a definition for 'ClientID' Thank you.

  Read the article

• Javascript to make input field in edit mode(insert mode)

  - by user234194

  How is it possible to make a input field editable in javascript. I mean onFocus putting it in insert mode so that values can be overwritten. Any suggestions ???

  Read the article

• how to insert check box value in PHP?

  - by jaydp

  hi, I Have multiple checkbox. when i insert checkbox value in database at time i have problem so,please ask me answer. Thanks!

  Read the article

• T-SQL OPENQUERY to MySQL - Insert ID

  - by n0chi

  I am using OPENQUERY to do an insert from MSSQL 2005 to MySQL. How do I get at the last inserted id on the MySQL db back into my MSSQL procedure?

  Read the article

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