Search Results

Search found 6988 results on 280 pages for 'if else statement'.

Page 125/280 | < Previous Page | 121 122 123 124 125 126 127 128 129 130 131 132  | Next Page >

• Cleaning up a SQL SP with Regex

  - by Douglas Osborne

  1) If I am running a find and replace in SQL 2005 - what would be the regular expression to find tab and space sequences ( or space and tab sequences ) and replace them with just tab? 2) If I have a line which begins with a space - is there a regular expression to convert that leading space to a tab? 3) What would be the regular expression to remove all of the spaces before a CR/LF in a SQL statement? TIA for the help - I know this will be trivial to most of you, Doug

  Read the article

• Remove non-alphanumerical characters excluding space

  - by Cecco

  I have this statement: String cap = Regex.Replace(winCaption, @"[^\w\.@-]", ""); that transforms "Hello | World!?" to "HelloWorld". But I want to preserve space character, for example: "Hello | World!?" to "Hello  World". How can I do this?

  Read the article

• Executable directory where application is running from?

  - by JPJedi

  I need to get the path (not the executable) where my application is running from: System.AppDomain.CurrentDomain.BaseDirectory() When I run the above statement with & "/images/image.jpg" on my local machine it works fine but when I install the application on another machine it says it cannot find the file and there is a lot of extra path information some. I just need the directory of where the app is running. I am coding in VB.NET with Visual Studio 2008. Thanks!

  Read the article

• Return in catch block?

  - by lowlyintern

  Is is wrong to have a return statement in a catch block? What are the alternatives? i.e: public bool SomeFunction() { try { //somecode return true; } catch(Exception ex) { MessageBox.Show(ex.message); return false; } }

  Read the article

• How do I make functions run by g_idle_add/g_timeout_add work asynchronously?

  - by httpinterpret

  g_timeout_add (100, (GSourceFunc) read_next_packets, NULL); I can feel the GUI response is slow because of the above statement. How can I make it work asynchronously so that it doesn't affect the GUI response?

  Read the article

• How can I get the name of all tables in a JavaDB database?

  - by Jonas

  How can i programmatically get the names of all tables in a JavaDB database? Is there any specific SQL-statement over JDBC I can use for this or any built in function in JDBC? I will use it for exporting the tables to XML, and would like to do it this way so I don't miss any tables from the database when exporting.

  Read the article

• How do I implement Advanced combobox in CakePHP

  - by skr

  I have implemented combobox in cakephp using following statement - echo $form->select('brand_id',array($brands),null,array(),'Choose Brand'); for brand and input form for category - echo $form->input('category_id',array('type'=>'select',$categories,'empty'=>'Choose Category')); but none of above option allows me to add my text input to brand or category, like say I want to add an input which is not there in the combobox, how should i go about it. Like a link in the combobox or textbox in combobox? -skr

  Read the article

• How to create a table in a particular database?

  - by liuxingruo

  The create database statement is: CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, column_name3 data_type, .... ) but, I'm wondering how can I create a table in a specific database? thanks, guys!

  Read the article

• spanish characters replaced with wierd string when 'stringWithFormat' is used?

  - by surajbaba

  NSString *myString = [NSString stringWithFormat:@"%@",BernabÈu]; NSLog(@"%@", myString); Above statement prints: Bernab\u00c8u Here 'BernabÈu' is spanish character string Why "\u00c8u" appended .How to get rid of this

  Read the article

• Apple script Editor, write message to the "Result" window

  - by Patrick

  I am using the Mac OS X Apple Script Editor and (while debugging) instead of writing a lot of display dialog statements, I'd like to write the results of some calculation in the window below, called "Result" (I have the German UI here, so the translation is a guess). So is there a write/print statement that I can use for putting messages in the "standard out" window? I am not asking to put the messages in a logfile on the file system, it is purely temporary.

  Read the article

• Select Top N Records Ordered by X, But Have Results in Reverse Order

  - by I. J. Kennedy

  I'm trying to get the top N records (when ordered by some column X), but have the result set in reverse order. The following statement is incorrect, but probably demonstrates what I'm after: SELECT * FROM (SELECT TOP 10 * FROM FooTable ORDER BY X DESC) ORDER BY X ASC For example, column X could be an ID or a timestamp; I want the latest 10 records but want them returned in forward chronological order.

  Read the article

• nhibernate intercept select query

  - by mjmcloug

  Hey, I'm looking at the nhibernate interceptor. It seems to be able to intercept save, update and delete queries but is there anyway I can intercept a select query. The problem I have is that I automatically want to append some additional sql filters to the executing sql statement in certain cases. Any thoughts Thanks Mat

  Read the article

• Serialize checkbox array, also get checkboxes with off-value

  - by guzh

  Hi, I was wondering if this is possible. The serialize-string will be inserted in a mySQL-database, so it would be fine if all checkboxes would be inserted and not only the ones that is ticked(on). it's possible to make on column in the database for each of the checkboxes, and use this if/else-statement: if(isset($_GET['checkbox'])) { // It's checked! } else { // not checked! } but its a bit unappropriate...

  Read the article

• MSSQL - select date field in table

  - by thegunner

  Hi, In my table I have a date column which the date is displayed in the format "2009-11-18 10:55:28.370" How can just get the date value of this field in a select statement. e.g. select id from risks, where creation_date = getdate()

  Read the article

• Add SET QUERY_GOVERNOR_COST_LIMIT with Linq to Entities

  - by boris callens

  I'm in a situation where I want to add the equivalent of the sql statement SET QUERY_GOVERNOR_COST_LIMIT to my query I created with linq to entities. How would I go about that?

  Read the article

• SQLite3 Integer Max Value

  - by peterwkc

  Hello to all, what is the maximum value of data type INTEGER in sqlite3 ? How do you store ip address in database ? What is attached ? How to create table which belongs to a specific database using sql ddl? What is this error about ? error while the list of system catalogue : no such table: temp.sqlite_master Unable to execute statement Does sqlite3 text data type supoports unicode? Thanks.

  Read the article

• something about ansi_nulls

  - by user329820

  Hi I have a question that we always say that null =null is false ,I want to know that when the ansi_nulls is off this statement which is "null=null" is also false? thanks

  Read the article

• How to SELECT the last 10 rows of an SQL table which has no ID field?

  - by Edward Tanguay

  I have an MySQL table with 25000 rows. This is an imported CSV file so I want to look at the last ten rows to make sure it imported everything. However, since there is no ID column, I can't say: SELECT * FROM big_table ORDER BY id DESC What SQL statement would show me the last 10 rows of this table? The structure of the table is simply this: columns are: A, B, C, D, ..., AA, AB, AC, ... (like Excel) all fields are of type TEXT

  Read the article

• Select...Case VB.NET to C# Equivalent

  - by Alex Essilfie

  I just started using C# and I've got a couple of issues. I hook several controls to one event handler as in the following and I want to perform a slightly different action for each control: Private Sub Button_Click(sender as Object, e as EventArgs) _ Handles button1.Click, Button2.Click 'do a general activity Select CType(sender, Button).Name Case button1.Name 'do something Case button2.Name 'do something else Case Else 'do the defalut action End Select End Sub Is there any way of doing the above select statement in C# without having to use nested ifs?

  Read the article

• references in C++

  - by Alexander

  Once I read in a statement that The language feature that "sealed the deal" to include references is operator overloading. Why are references needed to effectively support operator overloading?? Any good explanation?

  Read the article

• rails multiple outer joins syntax

  - by Craig McGuff

  I have the following models user has_many :leave_balances leave_balance belongs_to :user belongs_to :leave_type leave_type has_many :leave_balances I want to output a table format showing user names and their balance by leave type. Not every user can have every balance i.e. outer joins required. I'd like to see something like this: Employee Annual Leave Sick Leave Bob 10 Fred 9 Sara 12 15 I am unsure how to get this out as a single statement? I am thinking something like User.joins(:leave_balances).joins(:leave_type)

  Read the article

• PHP get a boolean when it is set later in the page

  - by Thomas

  In the header of my page I have a conditional statement to check if $foo boolean is set, the trouble is that the $foo boolean doesn't get set until the footer is loaded. Any way to retroactively check the status of this boolean?

  Read the article

• Is it possible to use 'else' in a python list comprehension?

  - by Josh

  Here is the code I was trying to turn into a list comprehension: table = '' for index in xrange(256): if index in ords_to_keep: table += chr(index) else: table += replace_with Is there a way to add the else statement to this comprehension? table = ''.join(chr(index) for index in xrange(15) if index in ords_to_keep) Also, would I be right in concluding that a list comprehension is the most efficient way to do this?

  Read the article

• what does 'legend' mean in sql?

  - by every_answer_gets_a_point

  im doing some practice sql problems one of the questions is: Prepare a shipping statement for customer 'C001' it should show the date, the legend 'Delivery' and the total value of the products shipped on each day. 'delivery' is not a table nor is it a column in any table. what does legend mean??

  Read the article

• Executing Page Page Load from Popup

  - by cem

  Hi, is it possible to trigger Parent's page load event from a popup.When i use javascript function window.parent.document.form.submit,this creates a postback.I want a function which creates "reload" for page because some of my functions work in the "if not postback" statement.

  Read the article

< Previous Page | 121 122 123 124 125 126 127 128 129 130 131 132  | Next Page >