Search Results

Search found 35400 results on 1416 pages for 'string interpolation'.

Page 951/1416 | < Previous Page | 947 948 949 950 951 952 953 954 955 956 957 958  | Next Page >

• How to use a LIKE statement inside an IF statement?

  - by user322652

  I need to be able to check if a variable has a certain string of text inside it. Here's what I have now: --This sample always goes to the ELSE block. IF( @name LIKE '%John%' ) BEGIN --do one thing END ELSE BEGIN --do the other thing END

  Read the article

• How to do bulk update of views?

  - by Shaul

  My database has about 30 views, most of which have a reference to another database on this server (call it DB1). Now, without going into the reasons why, I need to update all those views to DB2, also on the local server. I would hate to have to do this manually on each view. Is there some SQL query I can run that will replace all occurrences of the string 'DB1' with 'DB2' in all my views?

  Read the article

• Excelsheet query

  - by kunj

  Hi, Please tell me how can I find the last word from any particular cell in excel sheet if cell contains multiple words or instructions. For ex- The below string is in particular cell: C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue hills.jpg My requirement is to search only last word in that cell i.e. Blue hills.jpg Your early response is highly appreciated!!!

  Read the article

• [Android] Putting Serializable Classes into SQL?

  - by CaseyB

  Here's the situation. I have a bunch of objects that implement Serializable that I want to store in a SQL database. I have two questions Is there a way to serialize the object directly into the database Is that the best way to do it or should I Write the object out to a formatting String and put it in the database that way and then parse it back out Write each member to the database with a field that is unique to each object

  Read the article

• HTML Special Entity Codes in Actionscript3/Flex

  - by BlairHippo

  I have a Flex/Actionscript 3 application that displays RSS feeds in a Text element. It strips out any HTML formatting present, but it's not handling HTML special entity codes properly -- it's rendering &mdash as the literal string instead of replacing it with an em-dash, etc. Is there any systematic way I can make it handle those codes properly, or am I going to need to manually replace those strings regex style?

  Read the article

• Replace always replacing null values

  - by Mike

  Why does left(FIELD, replace(nullif(charindex('-', FIELD), 0), null, len(FIELD))) always return null? The idea behind the query is that if charindex() returns 0, then convert the results into null, then convert the null into the length of the field. So if '-' does not exist, show the whole string. For some reason it makes every row equal null. Thank you.

  Read the article

• SQL Server varchar to datetime

  - by Dezigo

  I have a field varchar(14) = 20090226115644 I need convert it to - 2009-02-26 11:56:44 (datetime format) My idea. use cast and convert.. but I always have errors. Conversion failed when converting datetime from character string. I made this, but don`t like it.. SELECT SUBSTRING(move,1,4) + '-' + SUBSTRING(move,5,2) + '-' + SUBSTRING(move,7,2) + ' ' + SUBSTRING(move,9,2) + ':' + SUBSTRING(move,11,2) + ':'+SUBSTRING(move,13,2) as new -- FROM [Test].[dbo].[container_events] where move IS not null Result :2009-02-26 11:56:44

  Read the article

• asp.net mvc2 validate type double

  - by ile

  [MetadataType(typeof(Deal_Validation))] public partial class Deal { } public class Deal_Validation { [Required] public string Title { get; set; } public double? EstValue { set; get; } } How to validate EstValue (check if it is of type double?) Thanks

  Read the article

• Grid View Button Passing Data Via On Click

  - by flyersun

  Hi, I'm pretty new to C# and asp.net so aplogies if this is a really stupid question. I'm using a grid view to display a number of records from a database. Each row has an Edit Button. When the button is clicked I want an ID to be passed back to a funtion in my .cs file. How do I bind the rowID to the Button field? I've tired using a hyper link instead but this doens't seem to work because I'm posting back to the same page which already has a Permanter on the URL. asp.net <asp:GridView ID="gvAddresses" runat="server" onrowcommand="Edit_Row"> <Columns> <asp:ButtonField runat="server" ButtonType="Button" Text="Edit"> </Columns> </asp:GridView> c# int ImplantID = Convert.ToInt32(Request.QueryString["ImplantID"]); Session.Add("ImplantID", ImplantID); List<GetImplantDetails> DataObject = ImplantDetails(ImplantID); System.Data.DataSet DSImplant = new DataSet(); System.Data.DataTable DTImplant = new DataTable("Implant"); DSImplant.Tables.Add(DTImplant); DataColumn ColPostCode = new DataColumn(); ColPostCode.ColumnName = "PostCode"; ColPostCode.DataType = typeof(string); DTImplant.Columns.Add(ColPostCode); DataColumn ColConsigneeName = new DataColumn(); ColConsigneeName.ColumnName = "Consignee Name"; ColConsigneeName.DataType = typeof(string); DTImplant.Columns.Add(ColConsigneeName); DataColumn ColIsPrimaryAddress = new DataColumn(); ColIsPrimaryAddress.ColumnName = "Primary"; ColIsPrimaryAddress.DataType = typeof(int); DTImplant.Columns.Add(ColIsPrimaryAddress); DataColumn ColImplantCustomerDetailsID = new DataColumn(); ColImplantCustomerDetailsID.ColumnName = "Implant ID"; ColImplantCustomerDetailsID.DataType = typeof(int); DTImplant.Columns.Add(ColImplantCustomerDetailsID); foreach (GetImplantDetails Object in DataObject) { DataRow DRImplant = DTImplant.NewRow(); DRImplant["PostCode"] = Object.GetPostCode(); DRImplant["Consignee Name"] = Object.GetConsigneeName(); DRImplant["Primary"] = Object.GetIsPrimaryAddress(); DRImplant["Implant ID"] = Object.GeTImplantCustomerDetailsID(); DTImplant.Rows.Add(DRImplant); <--- this is what I need to be added to the button } gvAddresses.DataSource = DTImplant; gvAddresses.DataBind();

  Read the article

• Updating an integer defined column in a MySQL DB with PHP

  - by Zloy Smiertniy

  I have a table defined like this: create table users ( id int(10), age int(3), name varchar (50) ) I want to use a query to update just age, which is an integer, that comes from an html form. When it arrives to the method that updates it, it comes as a string, so I change it to integer with PHP and try to update the table, but it doesn't work $age = intval($age); $q2 = "UPDATE users SET age='$age' where username like '$username';"; mysql_query($q2,$con);

  Read the article

• MySQL: what data type to use for hashed password field and what length?

  - by z-boss

  I'm not sure how password hashing works (will be implementing it later), but need to create database schema now. I'm thinking of limiting passwords to 4-20 characters, but as I understand after encrypting hash string will be of different length. So, how to store these passwords in the database?

  Read the article

• C# regex extracting tags

  - by SysAdmin

  Hi, Say I have a few string like Hi my name is <Name> Hi <name>, shall we go for a <Drink> Is it possible to get the tags captured through c# Regex? like <Name>, <drink> etc? I am not able to get it right..

  Read the article

• Ruby javascript unescape equivalent

  - by vise

  I want to unescape the following string: '\u00020\u0002Standard\u00023\u0002Doe John\u000169\u0002\u0010\u0002Lorem\u0002\u0011\u0002Ipsum\u0002\u0014\u0002' Javascripts unescape function works ok, however how can I unescape it in ruby? Take in mind that unescape(previousString) is 0Standard3Doe John69LoremIpsum.

  Read the article

• Minimize the sequence by putting appropriate operations ' DP'

  - by Vikas

  Given a sequence,say, 222 We have to put a '+' or '* ' between each adjacent pair. '* ' has higher precedence over '+' We have to o/p the string whose evaluation leads to minimum value. O/p must be lexicographically smallest if there are more than one. inp:222 o/p: 2*2+2 Explaination: 2+2+2=6 2+2*2=6 2*2+2=6 of this 3rd is lexicographically smallest. I was wondering how to construct a DP solution for this.

  Read the article

• PHP Regular Expression to quotations to attributes

  - by atwellpub

  hey Guys, I need to run a string of html through a regex function that checks to see if the attributes are closed in quotes, and if they aren't then close them. for example i want <img src=http://www.domain.com/image.gif border=0> to turn into <img src='http://www.domain.com/image.gif' border='0'> Can anyone help me?

  Read the article

• red5: how can i extend ISharedObject ?

  - by ufk

  Hiya. Red5 uses ISharedObject interface to create shared objects and to operate them. because ISharedObject is an interface I'm having issues extending it. I would like to extend the getAttribute, setAttribute, get{Int/String/Map}Attribute so the values will be checked before entered or pulled out. how is it possible to do so ? thanks

  Read the article

• response redirect with '+'

  - by salamonti

  when I write Response.Redirect("Default2.aspx?Name=" + TextBox1.Text); then string input = Request.QueryString["Name"]; if I write yahoo+music in textbox the input will be yahoo music why ? and how can I keep the '+' ?

  Read the article

• PHP utf8 encoding problem

  - by shyam

  How can I encode strings on UTF-16BE format in PHP? For "Demo Message!!!" the encoded string should be '00440065006D006F0020004D00650073007300610067006'. Also, I need to encode Arabic characters to this format.

  Read the article

• What's the best way to use python-syntax config files (in python of course)?

  - by Gabe

  My config file is really just a big python dict, but I have many config files to run different experiments and I want to 'import' a different one based on a command line option. Instinctively I want to do import ConfigFileName where ConfigFileName is a string with the config file's python package name in it... but that doesn't work. Any ideas?

  Read the article

• How to find crc32 of big files ?

  - by Arsheep

  The PHP's crc32 support string as input.And For a file , below code will work OFC. crc32(file_get_contents("myfile.CSV")); But if file goes huge (2 GB) it might raise out of memory Fatal error. So any way around to find checksum of huge files ?

  Read the article

• Insert one DefaultStyledDocument into another DefaultStyledDocument

  - by Paul Reiners

  I want to insert one DefaultStyledDocument into another DefaultStyledDocument. How do I do this? I know of this method: AbstractDocument.insertString(int offs, String str, AttributeSet a) What I really want is something like this: DefaultStyledDocument.insertDocument(int offs, AbstractDocument doc) Is there a way of doing this?

  Read the article

• Any way to force classes to have public static final field in Java?

  - by serg555

  Is there a way to force classes in Java to have public static final field (through interface or abstract class)? Or at least just a public field? I need to make sure somehow that a group of classes have public static final String TYPE = "..."; in them.

  Read the article

• Question on jpa joined table inheritance

  - by soontobeared

  Hi, The 'DiscriminatorColumn' annotation isn't creating any column in my parent entity. Where am I going wrong ? Here's my code @Entity @Inheritance(strategy=InheritanceType.JOINED) @DiscriminatorColumn(name="TYPE", discriminatorType=DiscriminatorType.STRING,length=20) public class WorkUnit extends BaseEntityClass implements Serializable{ @Entity @DiscriminatorValue(value="G") @Table(name="Group_") @PrimaryKeyJoinColumn public class Group extends WorkUnit implements Serializable{

  Read the article

• how to change color of table view title

  - by madhavi

  hello, Can we change the color of the table view title the string which i am showing appears in gray color can we choose color for it .Is there any property of table view title i am not asking for table view header or footer i mean the title - (NSString *)tableView:(UITableView *)tableView titleForHeaderInSection:(NSInteger)section { // Keep space in the following line ........ DONT REMOVE return [NSString stringWithFormat:@"Select your service:"]; }

  Read the article

• C# Threading in a method

  - by user177883

  I have the following method : public List<string> someMethod() { // populate list of strings // dump them to csv file //return to output } Question is: i dont want the user to wait for csv dump, which might take a while. If i use a thread for csvdump, will it complete? before or after the return of output?

  Read the article

< Previous Page | 947 948 949 950 951 952 953 954 955 956 957 958  | Next Page >