Search Results

Search found 7596 results on 304 pages for 'prepared statement'.

Page 146/304 | < Previous Page | 142 143 144 145 146 147 148 149 150 151 152 153  | Next Page >

• Committing Transaction

  - by Costa

  Hi http://msdn.microsoft.com/en-us/library/ms189797.aspx In this link they are committing a transaction within catch clause IF (XACT_STATE()) = 1, I don't get it, if there is an error why they are committing it? even if the problem in select statement and there is no big deal committing it, why don't just roll it back. Thanks

  Read the article

• java hashmap flaws ?

  - by Tiberiu Hajas

  hi there, if (agents != null) for (Iterator iter = agents.keySet().iterator(); iter .hasNext();) { // some stuffs here } I have the following piece of java code, the agents is a hashmap, wondering if anyone can figure it out why on the line with "for" statement sometimes I got NPE ? is there any flaw with hashmaps ? thanks

  Read the article

• Why does MySQL refuse pipe ('|') character in string on INSERT INTO

  - by Manuel Darveau

  If I try this statement: INSERT INTO TerminalEventChild (id,stringValue) VALUES (64,'version123|'); MySQL fail with : Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''version123' at line 1 SQLState: 42000 ErrorCode: 1064 If I remove the | character, everything works fine. Any idea?

  Read the article

• oracle blob text search

  - by Skay

  Is it possible to search through blob text using sql statement? I can do select * from $table where f1 like '%foo%' if the f1 is varchar, how about f1 is a blob? Any counter part for this?

  Read the article

• Java java.util.ConcurrentModificationException error

  - by vijay

  Hi all, please can anybody help me solve this problem last so many days I could not able to solve this error. I tried using synchronized method and other ways but did not work so please help me Error java.util.ConcurrentModificationException at java.util.AbstractList$Itr.checkForComodification(Unknown Source) at java.util.AbstractList$Itr.remove(Unknown Source) at JCA.startAnalysis(JCA.java:103) at PrgMain2.doPost(PrgMain2.java:235) Code public synchronized void startAnalysis() { //set Starting centroid positions - Start of Step 1 setInitialCentroids(); Iterator<DataPoint> n = mDataPoints.iterator(); //assign DataPoint to clusters loop1: while (true) { for (Cluster c : clusters) { c.addDataPoint(n.next()); if (!n.hasNext()) break loop1; } } //calculate E for all the clusters calcSWCSS(); //recalculate Cluster centroids - Start of Step 2 for (Cluster c : clusters) { c.getCentroid().calcCentroid(); } //recalculate E for all the clusters calcSWCSS(); // List copy = new ArrayList(originalList); //synchronized (c) { for (int i = 0; i < miter; i++) { //enter the loop for cluster 1 for (Cluster c : clusters) { for (Iterator<DataPoint> k = c.getDataPoints().iterator(); k.hasNext(); ) { // synchronized (k) { DataPoint dp = k.next(); System.out.println("Value of DP" +dp); //pick the first element of the first cluster //get the current Euclidean distance double tempEuDt = dp.getCurrentEuDt(); Cluster tempCluster = null; boolean matchFoundFlag = false; //call testEuclidean distance for all clusters for (Cluster d : clusters) { //if testEuclidean < currentEuclidean then if (tempEuDt > dp.testEuclideanDistance(d.getCentroid())) { tempEuDt = dp.testEuclideanDistance(d.getCentroid()); tempCluster = d; matchFoundFlag = true; } //if statement - Check whether the Last EuDt is > Present EuDt } //for variable 'd' - Looping between different Clusters for matching a Data Point. //add DataPoint to the cluster and calcSWCSS if (matchFoundFlag) { tempCluster.addDataPoint(dp); //k.notify(); // if(k.hasNext()) k.remove(); for (Cluster d : clusters) { d.getCentroid().calcCentroid(); } //for variable 'd' - Recalculating centroids for all Clusters calcSWCSS(); } //if statement - A Data Point is eligible for transfer between Clusters. // }// syn } //for variable 'k' - Looping through all Data Points of the current Cluster. }//for variable 'c' - Looping through all the Clusters. }//for variable 'i' - Number of iterations. // syn }

  Read the article

• Can I create a datetime column with default value in sqlite3?

  - by NobodyMan

  Is there a way to create a table in sqlite3 that has a datetime column that defaults to 'now'? The following statement returns a syntax error: create table tbl1(id int primary key, dt datetime default datetime('now'));

  Read the article

• How do you check to see if a variable has changed every second or less in objective c?

  - by James

  I am using an if statement to check the value of a BOOLEAN when i click on a button. When the button is clicked if the value is false i want to display a UIActivityIndicator and if the value is true i want to push the new view. I can do this fine but i want the view to change automatically when the BOOLEAN Becomes true if the user has already clicked the button. So my question is how do you check to see if a value has changed everysecond or less?

  Read the article

• Redirection inside a "Static FBML" tab

  - by thiagoleite

  On Facebook, is it possible to use a redirect statement inside a "Static FBML" tab? I've been trying to use but with no success.

  Read the article

• How do you preform an IF...THEN in a SQL SELECT

  - by Eric Labashosky

  I want to be able to perform a IF...THEN in an SQL SELECT Statement. For Example; SELECT IF(Obsolete = 'N' or InStock = 'Y';1;0) as Salable, * FROM Product

  Read the article

• Question about JSON?

  - by Alex

  Hi all, I have a fairly simple question: In Javascript how can I return the boolean (if its found in the JSON) rather than the actual value? Example: var myJSON = { "foo" : "bar", "bar" : "foo" }; var keyToLookFor = "foo"; var found = myJSON[keyToLookFor]; if (found) { // I know I can test if the string exists in the if } // but is there a way I could just return something like: return found; // instead of testing found in the if statement and then returning true?

  Read the article

• POWERSHELL; Recursive Get-Member for Com Object

  - by Zion

  I have a statement "New-Object -com Indesign.Application.Cs5 | Get-Member" It works as expected for the top level. How would one recurse the entire object tree and output results in a readable/spreadsheet format (if possible).

  Read the article

• Pass a query in URL using jquery

  - by Jean

  Hello, I want to pass a $_GET[''] to a php file, when a button is clicked it must display data from the db. It displays the data without the query. The process.php contains SQL statement to query the db and display values. Thanks Jean

  Read the article

• what is the best approach to impmenting a thread timer

  - by nitroxn

  Hi, What is the best approach in using a timer. Use a System.Timer.Timer class or use a single Thread in a non-terminating loop with a Thread.Sleep statement? Thanks in advance

  Read the article

• Is something wrong with this php GD code?

  - by ThinkingInBits

  if ($img = @imagecreatefromjpeg('./images/upload/13/1.JPG')) { imagejpeg($img, $path, 100); imagedestroy($img); } else { die ("image was not created or saved"); } I'm getting the message: Warning: imagejpeg(): 8 is not a valid Image resource in C:\xampp\htdocs\invivid\libraries\photograph_classes.php on line 276 Warning: imagedestroy(): 8 is not a valid Image resource in C:\xampp\htdocs\invivid\libraries\photograph_classes.php on line 277 The image is being created initially, we know this from the if statement, but why doesn't imagejpeg or imagedestroy work properly?

  Read the article

• Can content provider notify observer without calling NotifyChange() explicity - Android

  - by Amit

  In ContentProvider we explicity notify all registered observers to it by calling getContext().getResolver().notifyChange(URI,ContentObserver); I want to know if this is necessary. Is there any possibility that observers get notified, even we don't use that statement at all in our contentProvider. Is there any other way to do the same thing.

  Read the article

• Silent mode exection with java.exe

  - by srinannapa

  I would like to know if there is a way to execute the "java.exe" as a background process (silent mode execution) Ex: java -cp . MyClass arg1 I want to run the above statement as a background process , without opening command window

  Read the article

• How do I convert a property in MongoDB from text to date type?

  - by Jeff Fritz

  In MongoDB, I have a document with a field called "ClockInTime" that was imported from CSV as a string. What does an appropriate db.ClockTime.update() statement look like to convert these text based values to a date datatype?

  Read the article

• NHibernate Empty Set Clauses in SQL Update Statements

  - by Brian Wilkinson

  I'm getting SQL update statements from NHibernate having a empty set clause ie UPDATE SET WHERE x == ? This propblem is occuring when a child entity is being updated for some reason the sql statement is being run against the Parent Entity, for some reason NHibenate is saying the parent has changed but when the set clause is being built no changes are found, can anyone help. The application I am constructing isn 3 tier. The domain entities are light weight data contract only entities.

  Read the article

• How to store multiple values in TSQL Variables

  - by RPS

  I have the following TSQL Statement: SELECT ProductId, OwnerId FROM Product How I can store the ProductId and OwnerId in a TSQL variable and then return it to the calling application?

  Read the article

• Which option controls the color of this text?

  - by Tomas Lycken

  I have applied a color theme called Vibrant Ink (or some modification of it), and since I installed Visual Studio 2010 Pro Power Tools all my statement completion boxes are undreadable. What setting changes the colors of these boxes? Preferrably, I'd like to change the background color to something darker, but if that's not possible at least I want to change the text color.

  Read the article

• How to set cookies via PHP in the middle of a document?

  - by Sam

  Hi all, how can I set cookies in the middle of a document, without incurring a 'headers already sent' error? What I'm trying to do is make a log out script (the log in cookie setting works...so odd. Is it because it's enclosed in an if statement?) however I've already echoed the page title and some other stuff at the top of the page, before I've made this logout happen. Thanks!

  Read the article

• Bulk update + SQL + self join

  - by Nev_Rahd

  Hello All I would like to update a column in Table with reference to other column(s) in same table. Ex: As in figure below - I would like to update effective endate with min date whichever is greater than effective Start Date of currrent record. How can this be acheived in T-SQL. Can this be done with single update statement ? Thanks.

  Read the article

• Jquery - Hide specific div

  - by Jova

  I have several divs that share a common class. If one of these divs do not have a child div, I want to hide the div. I can find the right div but I'm unable to hide it. This is my code, $(function() { if ($(".adRight.childen('div')").length == 0) { $(this).hide(); } }); What should I use instead of (this)? this refers to the document and not the div the if-statement found.

  Read the article

• Crontab sets 18:00 to 09:00

  - by abubacker

  I just want to set a crontab using that I want to make a program run at every 15 minutes from 18:00 to 09:00 I have given this statement and waited but I don't think it is working */15 18-9 * * 1-6 Program_name Any suggestion would be greatly appreciated

  Read the article

• Why doesn't SQL LIKE work in Microsoft Access?

  - by poo

  I want to my make a search-statement and query things like this select * from table where col like '%vkvk%' But with trial and error I've come to the conclusion that access doesn't work with LIKE or wildcard operators. Does anybody have some other solutions because I ain't so in to access actually, so I really don't know.

  Read the article

< Previous Page | 142 143 144 145 146 147 148 149 150 151 152 153  | Next Page >