Search Results

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

Page 13/428 | < Previous Page | 9 10 11 12 13 14 15 16 17 18 19 20  | Next Page >

• Batch program to display files with complete directory

  - by sijith

  Hi, I want to store the URL of all files with same extension in specific directory to one Log file. IS there any batch command available for this. Exapmle I want to copy all files with *.TXT extension into one log file with its directory extension(URL)

  Read the article

• I need to write a batch file to set the system environmental variables ,

  - by user73628

  I need to write a batch file to set the system environmental variables as shown below WRD_WF_ROOT=e:\wrd_ntl_v23 WRD_Wld_ROOT=e:\wrd_ntl_v23 and I need to run the script for 250 users .

  Read the article

• how to delete only empty directories from a batch file

  - by Martin

  Is there a way to delete all empty sub-directories below a given directory from a batch file? Or is it possible to recursively copy a directory, but excluding any empty directories?

  Read the article

• Spring Batch validation

  - by sergionni

  Hello. Does Spring Batch framework provide its specific validation mechanism? I mean, how it's possible to specify validation bean? My validation is result of @NamedQuery - if query returned result, the validation is OK, else - false.

  Read the article

• DOS Batch file include external file for variables

  - by Michael

  I have a DOS batch file and I want to include external file containing some variables(say configuration variables). Is it possible?

  Read the article

• Read file contents into variable in batch file

  - by Faisal

  I want to read the contents of an external file in a variable inside a batch file. The contents of file contains multiple lines. I found a couple of ways but it either reads the first line or last line or its too complex. I want all content in one variable. Any easier way?

  Read the article

• Writing a batch file to delete files with wildcards

  - by iamthejeff

  I have multiple websites set up in the same folder, and I want to create a batch file that will delete the cache in each of them without having to add a new line for each site. For example I am using this: del /S /Q D:\www\site-name\cache\* Which works, but I have to add a new line for every site in D:\www. The del command doesn't support: del /S /Q D:\www\*\cache\* So what is a better way to do this?

  Read the article

• Executing an application without waiting in Batch file

  - by markattwood

  Is there any way to execute an application without waiting in Batch file. I have tried the start command but it just creates a new Command window.

  Read the article

• Batch file command PAUSE does not work

  - by Samaursa

  I am creating a simple batch file to assist in a few things, and I have some instructions that it prints out as well that I want the user to see before exit. Currently, the window closes very quickly. So I added PAUSE at the end of the file, but it does not want to work. I looked at other questions on SO and have checked to make sure the line endings are CRLF and that I have CRLF at the end of the file. Any suggestions?

  Read the article

• String replacment in batch file

  - by Faisal

  We can replace strings in a batch file using the following command set str="jump over the chair" set str=%str:chair=table% These lines work fine and change the string "jump over the chair" to "jump over the table". Now I want to replace the word "chair" in the string with some variable and I don't know how to do it. set word=table set str="jump over the chair" ?? Any ideas?

  Read the article

• Windows batch command(s) to read first line from text file

  - by Jesse

  How can I read the first line from a text file using a Windows batch file? Since the file is large I only want to deal with the first line.

  Read the article

• Batch closes prematurely on a for /f command

  - by VonC

  I have a batch file (in windows XP, with command extension activated) with the following line: for /f %%s in ('type version.txt') do set VERSION=%%s On some computer, it works just fine (as illustrated by this SO question), but on other it kills cmd (the console window just closes) Why ? Note: the computers seem to have a similar configuration: XpSP2, the user has administrative right, no 'Command processor" defined in HKEY_CURRENT_USER\Software\Microsoft\Command Processor...

  Read the article

• I want to compile a batch file into an exe using c++, i can get through parsing the batch file and w

  - by Nareshkumar Rao

  Ok, here's the thing, I am creating an application in DevC++ that will read in a batch file. then, one by one parsing it using: system(getline(myfile,line)); After setting everything up, I save the newly created file as "main.cpp". The problem is, I want to compile it into an exe, from my program, for the end user. So basically, I'm asking whether I can compile a C++ file from a C++ Exe..

  Read the article

• How to sleep computer via batch file?

  - by Saebin

  So I want to make a batch file that will sleep my computer after a period of time. The closest thing I have found is placing it in standby, but seems to work differently then the sleep button on my keyboard (longer bootup, doesn't wake on mouse click). Any ideas? Would it be easier in python or c#?

  Read the article

• Batch File Not Executing completely

  - by user339853

  I have made a simple batch file for backing up my repository changes and rebuildig, but it always stops executing after the backup command is run. Have anyone here ever seen this happen before?

  Read the article

• Rename all files in a folder using batch

  - by user270506

  I would like to create a batch file to rename all the files with extension ".log" in a folder to append with today's date. For example : App.log will be appended to App.log06112010 where date is 06112010. Please suggest

  Read the article

• Batch file from UNC path: %~dp0 takes a long time to resolve

  - by Adam

  When I try to use "%~dp0" in batch files stored on remote servers, sometimes it takes a good 45 seconds for the path to resolve! I have a fast connection and doing other things with these remote servers is quick. Is this normal? Is there any way around it? Any help would be greatly appreciated.

  Read the article

• Can't get SubSonic insert to work

  - by Darkwater23

  I'm trying to insert a record into a table without using the SubSonic object in a VB.Net Windows app. (It will take too long to explain why.) Dim q As New SubSonic.Query("tablename") q.QueryType = SubSonic.QueryType.Insert q.AddUpdateSetting("Description", txtDescription.Text) q.Execute() This just updates all the rows in the table. I read in one post that instead of AddUpdateSetting, I should use AddWhere, but that didn't make any sense to me. I don't need a where clause at all. Searching for all:QueryType.Insert at subsonicproject.com didn't return anything (which I thought was weird). Can anyone tell me how to fix this query? Thanks!

  Read the article

• MySQL INSERT with table alias

  - by Max Kielland

  Hello, I happen to have two columns having the same name as two SQL reserved words, Key and Value. When using the SELECT statement I can create a table alias and solve it that way. Now I'm trying to INSERT data and it seems like you can't create table alias in the INSERT statement. INSERT INTO attributeStrings ats (ats.ItemID,ats.Key,ats.Value) VALUES (3,'Categories','TechGUI') I get error at 'ats (ats.ItemID,ats.Key,ats.Value) VALUES (3,'Categories','TechGUI')' indicating that alias can't be created. Are there any ways to solve this without renaming the columns Key and Value?

  Read the article

• Insert rows into MySQL table while changing one value

  - by Jonathan

  Hey all- I have a MySQL table that defines values for a specific customer type. | CustomerType | Key Field 1 | Key Field 2 | Value | Each customer type has 10 values associated with it (based on the other two key fields). I am creating a new customer type (TypeB) that is exactly the same as another customer type (TypeA). I want to insert "TypeB" as the CustomerType but then just copy the values from TypeA's rows for the other three fields. Is there an SQL insert statement to make this happen? Somthing like: insert into customers(customer_type, key1, key2, value) values "TypeB" union select key1, key2, value from customers where customer_type = "TypeA" Thanks- Jonathan

  Read the article

• Please help me to create a insert query (error of foreign key constrant)

  - by Rajesh Rolen- DotNet Developer

  I want to move data from one database's table to another database's table its giving me foreign key error. please tell me how can i insert all those data which is valid except those rows who have error of foreign key. i am using sql server 2005 My query is : SET IDENTITY_INSERT City ON INSERT INTO City ([cityid],[city],[country],[state],[cityinfo] ,[enabled],[countryid],[citycode],[stateid],[latitude],[longitude]) SELECT [cityid],[city],[country],[state],[cityinfo] ,[enabled],[countryid],[citycode],[stateid],[latitude],[longitude] FROM TD.DBo.City getting this error: The INSERT statement conflicted with the FOREIGN KEY constraint "FK__city__countryid__3E52440B". The conflict occurred in database "schoolHigher", table "dbo.country", column 'countryId'. please tell how can i move those data whose foreign key is valid.

  Read the article

• Does DB2 have an "insert or update" statement?

  - by Mikael Eriksson

  From my code (Java) I want to ensure that a row exists in the database (DB2) after my code is executed. My code now does a select and if no result is returned it does an insert. I really don't like this code since it exposes me to concurrency issuses when running in a multi-threaded environment. What I would like to do is to put this logic in DB2 instead of in my Java code. Does DB2 have an "insert-or-update" statement? Or anything like it that I can use? For example: insertupdate into mytable values ('myid') Another way of doing it would probably be to allways do the insert and catch "SQL-code -803 primary key already exists", but I would like to avoid that if possible.

  Read the article

• Insert using strored procedure from nhibernate

  - by jcreddy

  Hi I am using the following code snippets to insert values using stored procedure. the code is executing successfully but no record is inserted in DB. Please suggest with simple example. **---- stored procedure--------** Create PROCEDURE [dbo].[SampleInsert] @id int, @name varchar(50) AS BEGIN insert into test (id, name) values (@id, @name); END **------.hbm file-------** <?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"> <sql-query name="Procedure"> exec SampleInsert :Id,:Name </sql-query> </hibernate-mapping> **--------c# code to insert value using above sp------** ISessionFactory sessionFactory = new Configuration().Configure().BuildSessionFactory(); ISession session = sessionFactory.OpenSession(); IQuery query = session.GetNamedQuery("Procedure"); query.SetParameter("Id", "222"); query.SetParameter("Name", "testsp"); query.SetResultTransformer(new NHibernate.Transform.AliasToBeanConstructorResultTransformer(typeof(Procedure).GetConstructors()[0])); Regards Jcreddy

  Read the article

• Insert using stored procedure from nhibernate

  - by jcreddy

  Hi I am using the following code snippets to insert values using stored procedure. the code is executing successfully but no record is inserted in DB. Please suggest with simple example. **---- stored procedure--------** Create PROCEDURE [dbo].[SampleInsert] @id int, @name varchar(50) AS BEGIN insert into test (id, name) values (@id, @name); END **------.hbm file-------** <?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"> <sql-query name="Procedure"> exec SampleInsert :Id,:Name </sql-query> </hibernate-mapping> **--------c# code to insert value using above sp------** ISessionFactory sessionFactory = new Configuration().Configure().BuildSessionFactory(); ISession session = sessionFactory.OpenSession(); IQuery query = session.GetNamedQuery("Procedure"); query.SetParameter("Id", "222"); query.SetParameter("Name", "testsp"); query.SetResultTransformer(new NHibernate.Transform.AliasToBeanConstructorResultTransformer(typeof(Procedure).GetConstructors()[0])); Regards Jcreddy

  Read the article

• sql: DELETE + INSERT vs UPDATE + INSERT

  - by user93422

  A similar question has been asked, but since it always depends, I'm asking for my specific situation separately. I have a web-site page that shows some data that comes from a database, and to generate the data from that database I have to do some fairly complex multiple joins queries. The data is being updated once a day (nightly). I would like to pre-generate the data for the said view to speed up the page access. For that I am creating a table that contains exact data I need. Question: for my situation, is it reasonable to do complete table wipe followed by insert? or should I do update,insert? SQL wise seems like DELETE + INSERT will be easier (it is single SQL expression). EDIT: RDBMS: MS SQL Server 2008 Ent

  Read the article

< Previous Page | 9 10 11 12 13 14 15 16 17 18 19 20  | Next Page >