Search Results

Search found 28627 results on 1146 pages for 'case statement'.

Page 291/1146 | < Previous Page | 287 288 289 290 291 292 293 294 295 296 297 298  | Next Page >

• Phpmyadmin mysql foreign key help

  - by Alan

  Hey guys i'm using phpmyadmin (php & mysql) and i'm having alot of trouble linking the tables using foreign keys. I'm getting negative values for the field countyId (which is the foriegn key). However it is linking to my other table fine and it's cascading fine. So when I go to add data there will be a drop box for the CountyId and the vlaues will look something like this, " -1 1- " Here is my alter statement, ALTER TABLE Baronies ADD FOREIGN KEY (CountyId) REFERENCES Counties (CountyId) ON DELETE CASCADE

  Read the article

• How to implement XXTEA in MySQL?

  - by user339229

  Anyone knows how to implement XXTEA in MySQL? For example - SELECT xxtea_encrypt('text here', 'key here'); possible implementation is by creating a FUNCTION in MySQL using CREATE FUNCTION statement, e.g. CREATE FUNCTION xxtea_encrypt XXTEA Procedures here... RETURN encrypted string Thanks & Best regards

  Read the article

• PHP Echo syntax error with single quote or double quotes?

  - by nepc

  The is a very simple echo statement but I can't solve it? echo '"What is your name?'";

  Read the article

• Adding Refresh Tag to View

  - by RJL

  I need a view to refresh automatically every 20 seconds, and have added the following code to the view header via the views GUI - with no success. The code (or portions of it) are simply displayed on the view and no updating is performed. I've tried omitting both and just the ending ?php statement. If someone can tell me the proper code to use, or a better approach at updating the view automatically, I'd be very appreciative. Thanks. print ";

  Read the article

• pls give reason why this java program always comes to the else part

  - by Anbu

  public class Test { public static void main(String[] args){ if (5.0 5) // (5.0<5) for both case it is going to else System.out.println("5.0 is greater than 5"); else System.out.println("else part always comes here"); /another sample/ if (5.0 == 5) System.out.println("equals"); else System.out.println("not equal"); } } can any one explain the first "if statement" why it always come to else part

  Read the article

• ms-access: difference between .value and .text

  - by every_answer_gets_a_point

  i am passing values from a textbox into a sql statement in ACCESS i do not understand the difference in the usage of these two properties when i set the the .text property to something, how does the .value property get affected? when i do want something to be displayed in the textbox should i be using the value or text property?

  Read the article

• What are the acceptable uses of goto?

  - by Steve Hanov

  What uses of the goto statement do you consider acceptable? I am discussing some coding guidelines for C embedded work, and wondering if there are cases where goto is the cleanest way to do things.

  Read the article

• SQL:Casting a String to IDS with IN clause

  - by Shyju

  DECLARE @STR_IDS VARCHAR(15) SET @STR_IDS='7,15,18' UPDATE TBL_USERS WHERE ID IN @STR_IDS I know the update statement would not work as the ID is of type INT and i am replacing a varachar value there .How can i change the query so that it will be executed like this in effect ? UPDATE TBL_USERS WHERE ID IN (7,15,18) Thanks in advace

  Read the article

• SQL ENQUIRY In how to Get defined number of records

  - by ramadan2050

  I have a select statement, retrieve about 1000 record I want to modify it to return only some records defined by @startIndex and @count e.g. : If I said @startIndex=20 and @count=20 the result will be : from the 21th record to 40th I try to make it, but it take the same time as if I retrieve the 1000 record what is the best way to do that

  Read the article

• mySQL JOIN wont return results with 0 count

  - by MPC

  SELECT categories.*, COUNT(categoryID) AS kritCount FROM categories AS categories LEFT JOIN krits ON categories.id = categoryID WHERE (krits.approved = '1') GROUP BY categories.id So this works great except that it does not return a category that has a 0 count of krits in the category. It will if I remove the WHERE statement but I need the WHERE to only select the krits where the field approved = 1

  Read the article

• auto-import of packages across project in eclipse

  - by Reddy

  I have used file search functionality in eclipse to replace a specific occurrence of text with a replace text which contains a java method name in all files across the workspace. But now in all those files I have to add the import statement (for the method name to resolve). Is there an automatic way of doing this instead of manually searching and importing the package myself in all files?

  Read the article

• reading into table: comma values and quotes SQL

  - by every_answer_gets_a_point

  i have a string like this something = "something, something1, "something2, something else", something3" i need it to be read into a table like this: field1 = "something" field2= "something2" field3 = "something2, something else" field4 = "something3" please notice that the double quotes in the something string signified that the string inside the quotes is to be placed in one field anyone know how to do this with an insert into statement or some other way? the answer can be purely sql or can be vba with sql. thanks!

  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

• Access Voilation in std::pair

  - by sameer karjatkar

  I have an application which is trying to populate a pair . Out of no where the application crashes . The Windbg analysis on the crash dump suggest PRIMARY_PROBLEM_CLASS: INVALID_POINTER_READ DEFAULT_BUCKET_ID: INVALID_POINTER_READ STACK_TEXT: 0389f1dc EPFilter32!std::vector,std::allocator ::size+0xc INVALID_POINTER_READ_c0000005_Test.DLL!std::vector_std::pair_unsigned_int, unsigned_int_,std::allocator_std::pair_unsigned_int,unsigned_int___::size Following is the statement in the code where it fails const branch_info& b1 = en1.m_branches[i1]; where branch_info is std::pair and the en1.m_branches[i1] fetches me a pair value

  Read the article

• Combine First, Middle Initial, Last name and Suffix in T-SQL (No extra spaces)

  - by Paul

  I'm trying not to reinvent the wheel here...I have these four fields [tbl_Contacts].[FirstName], [tbl_Contacts].[MiddleInitial], [tbl_Contacts].[LastName], [tbl_Contacts].[Suffix] And I want to create a FullName field in a view, but I can't have extra spaces if fields are blank...So I can't do FirstName + ' ' + MiddleInitial + ' ' + LastName + ' ' + Suffix...Because if there is no middle initial or suffix I'd have 2 extra spaces in the field. I think I need a Case statement, but I thought someone would have a handy method for this...Also, the middleinitial and suffix may be null.

  Read the article

• Accress Parent Page's Viewstate in ASP.NET

  - by rachmos

  OK, I guess I'm missing something obvious here, but I still can't make it work... I have a page in ASP.NET. I have a nested class inside the page. I have a property in this nested class. How can I access the page's viewstate from the property's Set statement? Thanks!

  Read the article

• 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

• 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

• 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

• How do i escape reserve names in a column? MySQL/Create Table

  - by acidzombie24

  I am generating tables from classes in .NET and one problem is a class may have a field name key which is a reserved mysql keyword. How do i escape it in a create table statement? (Note: The other problem below is text must be a fixed size to be indexed/unique) create table if not exists misc_info ( id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL, key TEXT UNIQUE NOT NULL, value TEXT NOT NULL)ENGINE=INNODB;

  Read the article

• i++ or i+=1 or i= i+1 which one is better for good performance

  - by Ram

  I have 3 options to increment value of an integer by 1 in a C# application i++ i+=1 i=i+1 The result of all three operations would be same but I would like to know which one would be the best to use if I need to use this statement in an application where the performance is critical.

  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

• 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

• 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

• 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

< Previous Page | 287 288 289 290 291 292 293 294 295 296 297 298  | Next Page >