Search Results

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

Page 155/304 | < Previous Page | 151 152 153 154 155 156 157 158 159 160 161 162  | Next Page >

• mysql: managing memory usage

  - by every_answer_gets_a_point

  i am doing a delete with a LIKE statement my keybuffer is 25m, the sort buffer size is 256k the delete has been taking over 2 hours should i increase memory usage? there are about 50 megs of data in the table from which i am deleting, thats about 500,000 rows is there anything else i can do on the adminsitration size to speed up this delete?

  Read the article

• Fastest way to add prefix to array keys?

  - by Kirzilla

  Hello, What is the fastes way to add string prefixes to array keys? was $array = array( '1' => 'val1', '2' => 'val2', ); needed $array = array( 'prefix1' => 'val1', 'prefix2' => 'val2', ); According to http://www.phpbench.com/ (see Modify Loop) I should use "for" statement, but probably there is more elegant way? Thank you.

  Read the article

• get index name within specific table name

  - by AmRoSH

  I need to check if this index not exist in specific table name not in all tables because this select statement select all indexes under this condition. IF NOT EXISTS (SELECT name from sysindexes WHERE name = 'IDX_InsuranceID') CREATE NONCLUSTERED INDEX [IDX_InsuranceID] ON [dbo].[QuoteInsurances] ( [InsuranceID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY] GO Thanks,

  Read the article

• C++ switch table performance

  - by asap

  Does the time taken by a switch statement (or jump table in compiled form) to "decide" where to jump rise by the number of casees it contains?

  Read the article

• IS ResultSet thread safe

  - by javatraniee

  Is ResultSet Thread safe? My question arises because in this i have used a different statement for each query i have delsared a ResultSet as an local variable but it gives me a error of Operation not allowed after ResultSet is closed. But my statements are working as i'm using the statements in insert and delete query.I have commented the ResultSet part and have not got the error !! The source code of my program can be referd to , in my earlier Question .

  Read the article

• String.IsNullOrEmpty() Check for Space

  - by Asim Sajjad

  What does below statement return String.IsNullOrEmpty(" ") is IsNullOrEmpty will need to pass by applying Trim() function of string. String.IsNullOrEmpty(" ".Trim()) or it will trim the string inside ?

  Read the article

• Is it standard behavior for this code to throw a NullPointerException?

  - by Eric

  I've had a big problem in some library code, which I've pinned down to a single statement: System.out.println((String) null); Ok, the code doesn't actually look like that, but it certainly calls println with a null argument. Doing this causes my whole applicaio to throw an unexpected NullPointerException. In general, should println throw this exception under that circumstance, or is this non-standard behavior due to a poor implementation of the out instance?

  Read the article

• restrict users from changing rows inserted 3 hours ago in mysql

  - by htaikthegreat

  Hi, I inserted a number of rows 3 hours ago and I don't want these rows from changing. How can I write sql statement that compare current time with the timstamp in the row and restrict users from changing it if abouve creteria is met. Thanks

  Read the article

• function_exists php

  - by user527800

  Hi all I'm trying to write a function that could receive it's second arg a name of a function. In order to validate function's name (that will be used in an eval statement) I use function_exists such as: if(function_exists($type)){ $toEval= $type.'(\''.$file.'\');'; }else{ But if the arg sent is include or require (with 'once' variations) this code fails (function_exists returns false). How could this be fixed? Thanks, Alex

  Read the article

• How do I combine two rows of same part, but add quantities?

  - by Tom

  I have table "PICKITEM" PARTID QTY A 1 A 3 B 11 C 8 D 5 D 3 I need a select statement that will return one line for like PARTIDs and add the qty field to together, yet also return the rest of the lines in the table as is PARTID QTY A 4 B 11 C 8 D 8 Probably a newb question, but I am new to SQL syntax and queries. Any help in getting me on the right path would be appreciated!

  Read the article

• SQL Join only returning 1 row.

  - by kevin

  Not quite sure what I'm missing, but my SQL statement is only returning one row. SELECT tl.*, (tl.topic_total_rating/tl.topic_rates) as topic_rating, COUNT(pl.post_id) - 1 as reply_count, MIN(pl.post_time) AS topic_time, MAX(pl.post_time) AS topic_bump FROM topic_list tl JOIN post_list pl ON tl.topic_id=pl.post_parent WHERE tl.topic_board_link = %i AND topic_hidden != 1 ORDER BY %s I have two tables (post_list and topic_list), and post_list's post_parent links to a topic_list's topic_id. Instead of returning all the topics (where their board's topic_board_link is n), it only returns one topic.

  Read the article

• MySQL Order By Problem, Why is 1000 being seen as Smaller than 2?

  - by Jack

  I have a strange problem, I am trying to order the output of a set of records by a field called displayOrder. Now even though record A has a displayOrder of 2 and record B has a displayOrder of 1000, record B still shows up before record A. Here's my select statement: SELECT * FROM items ORDER BY displayOrder ASC It works fine until I have a record greater than 9, then 10, 11, 12, etc are seen as smaller than 2, 3, 4 because they start with the number 1. Any way to fox this?

  Read the article

• Imageiio can't create imageinput stream

  - by pie154

  When using imageio.imageio.read iget a can't create ImageInput Stream. I have a catch exception around it so the program survives but i was wondering if theres a way to put an if statement round it that checks to see if it falied and then attempt to read it again if it did. basically asking if there is a test for exceptions?

  Read the article

• &nbsp; displays a tiny line.

  - by Kyle Sevenoaks

  Hi, when I make &nbsp; in my site, it displays a tiny line, which can be hidden on some elements because I'm usually using them on CSS buttons, but I have an if statement that says if this show the result if not show a non breaking space. How do you reset the &nbsp; to display nothing? Thanks.

  Read the article

• Exclude some ids from result in Rails ActiveRecord

  - by Beer Brother

  I have following statement for query articles from some sections Article.all(:joins => :sections, :conditions => { :sections =>{ :id => [3, 4, 6, 7, 8, 9] }, :id_not_in => @some_ids }, :limit => 4) Variable @some_ids is array with ids of articles wich must be excluded from result.

  Read the article

• unprotected access to member in property get

  - by Lenik

  I have a property public ObservableCollection<string> Name { get { return _nameCache; } } _nameCache is updated by multiple threads in other class methods. The updates are guarded by a lock. The question is: should I use the same lock around my return statement? Will not using a lock lead to a race condition?

  Read the article

• SEHException External component has thrown exception in VS2005

  - by sdz

  Hello! I imported inpout32.dll to the program and tried to do the parallel port interfacing for outputting and inputting through the port. But when the execution reaches the statement PortAccess.Output(888,0); it throws the above exception. The PortAccess class is defined in the inpout32.dll file which i downloaded from www.logix4u.net. Can anyone help me with this?

  Read the article

• SQL like conditions

  - by garpunkal

  Hi, What does this mean within my like statement? LIKE '%[ .,!?]' + keyword + '[ .,!?]%' I'm trying to get something, that will match for whole words

  Read the article

• how to run a query from the VBA Editor window in ACCESS?

  - by every_answer_gets_a_point

  i would like to do something like this: DoCmd.OpenQuery "select * from some_table;" how would i do this? please keep in mind i don't want create a new query, save it, and run it, i just want to type the select statement in the vba code and run it.

  Read the article

• stringByAppendingFormat not working

  - by iFloh

  I have an NSString and fail to apply the following statement: NSString *myString = @"some text"; [myNSString stringByAppendingFormat:@"some text = %d", 3]; no log or error, the string just doesn't get changed. I already tried with NSString (as documented) and NSMutableString. any clues most welcome.

  Read the article

• TSQL - MSSQL 2008 add a column and update it in same stored procedure

  - by TortTupper

  if I have a stored procedure say create procure w AS ALTER TABLE t ADD x char(1) UPDATE t set x =1 Even when it lets me create that stored procedure (if I create it when x exists), when it runs, there is an error on the UPDATE statement because column x doesn't exist. What's the conventional way to deal with this, it must come up all the time? I can work around it by putting the UPDATE inside EXEC, is there another/better way? Thanks

  Read the article

• django update object

  - by John

  Hi, How do I run an update and select statement on the same queryset rather than having to do 2 querys, ones to select the object and one to update the object? the sql would be something like update my_table set field_1 = 'some value' where pk_field = some_value Thanks

  Read the article

• Randomly selecting a limited number of records with two conditions in MySQL

  - by andyashton

  I have a MySQL table with a column called "priority". The column can have two values: high or low. I want to select 8 records from the table at random, but I want 6 of them to be high priority, and 2 of them to be low priority. If possibly, I would like to do it in one SQL statement. Is there any way to do two LIMITS in one query based on this kind of criteria?

  Read the article

• if action class method throw exception where is the handler and how to get control after that....???

  - by rozer

  If action class method signature have throws statement and in that method any exceoption occurs then how the flow will move. then suppose we need to take contol of flow and want to show our jsp , what will be the steps please help out.....

  Read the article

• Javascript switch vs. if...else if...else

  - by John Hartsock

  Guys I have a couple of questions: Is there a preformance difference in Javascript between a switch statement and an if...else if....else? If so why? Is the behavior of switch and if...else if...else different across browsers? (FireFox, IE, Chrome, Opera, Safari)

  Read the article

< Previous Page | 151 152 153 154 155 156 157 158 159 160 161 162  | Next Page >