Search Results

Search found 47469 results on 1899 pages for 'auto generated value'.

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

• Getting rows which include a value with MySQL

  - by sundowatch

  I have a MySQL query which gets including some vars like that: messages TABLE receiver cols user1 rows : 1,3,5 user2 rows : 2,3 user3 rows : 1,4 I want to get rows which includes '3' value. So I will get 'user1' and 'user2'. I tried that but naturally it doesn't work. mysql_query("SELECT * FROM messages WHERE receiver='3'"); How can I do this?

  Read the article

• NULL value in :conditions =>

  - by Horace Ho

  Contract.all(:conditions => ['voided == ?', 0]).size => 364 Contract.all(:conditions => ['voided != ?', 0]).size => 8 Contract.all.size => 441 the 3 numbers does not added up (364 + 8 != 441). What's the proper way write the :conditions to count the rows which the voided column value is NULL or equal to zero?

  Read the article

• How to retrieve query string value from URL value stored in a variable?

  - by user187580

  Hello, $url = 'http://www.domain.com/file.php?dir=r&hl=100,200&ord=3&key=a+b+c'; If it were a url I could get value of hl by, say, $_GET['hl']. but how do I retrieve the same from $url string. Thanks.

  Read the article

• Jquery return value

  - by Anton

  I used a code: jQuery.fn.MyFunction = function(){ return this.each(function() { attributes = "test"; return attributes; });} But when I call var1 = $(this).MyFunction();alert(var1); I got an [object], but not the "test". How to allow jquery plugin return a some value?

  Read the article

• F# how to return have value a tuple or null

  - by mamu

  let retVal = if reader.Read() then (reader.GetString(0), getBytesData reader 1, reader.GetDateTime(2)) else null F# don't allow null to returned How can i have value return as a tuple or a null?

  Read the article

• getting rows which including a value with mysql

  - by sundowatch

  I have a mysq query which gets including some vars like that: messages TABLE receiver cols user1 rows : 1,3,5 user2 rows : 2,3 user3 rows : 1,4 I want to get rows which includes '3' value. So I will get 'user1' and 'user2'. I tried that but naturally it doesn't work. mysql_query("SELECT * FROM messages WHERE receiver='3'"); How can I do this?

  Read the article

• 'Subquery returned more than 1 value' problem in EntityFramework

  - by plotnick

  I have one 'Transaction' entity object with 'Operations' navproperty with multiplicity of 'Many'. When I'm adding only one operation per transaction nothing happens, but when I'm trying to add more than one operation, db.SaveChanges() throws an exception like 'Subquery returned more than 1 value blah, blah, blah' How can I solve that? Help me guys please... BTW... Could you tell me how can I see the exact query string that EF passes to Sql Server on db.SaveChanges() method?

  Read the article

• return value of main() in windows

  - by sisis

  In Linux, the return value of the main function is stored in $?, and can be shown using echo $?. Is there something equivalent in Windows?

  Read the article

• mass replace of values in more tables by a highest value

  - by nescius

  Hello, I have a table with OWN_ID and OWN_Email - 3ace7cf80edd | [email protected] 3acf6af33ff7 | [email protected] 3acda2524e00 | [email protected] 3ad75583c9a7 | [email protected] 3ad74b018999 | [email protected] etc. the problem is that it should contain only a single ID per Email, also I need to replace all OWN_ID values in another table by highest OWN_ID value of the OWN_Email

  Read the article

• Getting single value from a single row with Mysql/PHP

  - by Ghostrider

  Often I just need to get a single value from MySQL that I know exists there. I use the following construct: $result = end(mysql_fetch_array(mysql_query('SELECT FOUND_ROWS()', $db))); Is there a proper single function in PHP that would do this?

  Read the article

• How to enforce unique field value in java Google App Engine

  - by supercobra

  Hello there, I am try to find out how to enforce uniqueness in fields other than the unique id. Example: @PersistenceCapable(identityType = IdentityType.APPLICATION) public class User implements IsSerializable { @PrimaryKey @Persistent(valueStrategy = IdGeneratorStrategy.IDENTITY) private Long id; @Persistent private String name; @Persistent private String email; // <= I want this to be unique as well } In the example above, how can I enforce uniqueness of the email value across the database? Daniel

  Read the article

• Textbox value changed

  - by developer

  Hi All, Is it possible to know if any of the textbox values have changed in the application. I have around 30 textboxes and I want to run a part of code only if, any of the textboxes value has changed out of the 30. Is there a way I can know that.

  Read the article

• declare field without initial value in php?

  - by Charles

  I don't want to give an initial value. I want to set these later using the set method class Duck { var int id; var set = Array(); } Any idea how to declare without getting error?

  Read the article

• Creating a string variable name from the value of another string

  - by NeonGlow

  In my bash script I have two variables 'CONFIG_OPTION' and 'CONFIG_VALUE' which contain string VENDOR_NAME and Default_Vendor respectively. I need to create a variable with name '$CONFIG_OPTION' ie VENDOR_NAME and assign the value in CONFIG_VALUE to newly created variable. How I can do this? I tried $CONFIG_OPTION=$CONFIG_VALUE But I am getting an error on this line as './Build.bash: line 137: VENDOR_NAME="Default_Vendor": command not found' Thanks.

  Read the article

• JavaScript/jQuery removing character 160 from a node's text() value - Regex

  - by tyndall

  $('#customerAddress').text().replace(/\xA0/,"").replace(/\s+/," "); Going after the value in a span (id=customerAddress) and I'd like to reduce all sections of whitespace to a single whitespace. The /\s+/ whould work except this app gets some character 160's between street address and state/zip What is a better way to write this? this does not currently work.

  Read the article

• Retrieving the value of a concatenated variable within a Java FOR loop

  - by Rajat

  I have been using this "logic" in C++ and VB with success, but am tied up in Java... Simply put, public void DataProviderExample(String user, String pwd, String no_of_links, String link1, String link2, String link3) { for (int i=1;i<=no_of_links;i++) { String link = "link"+i; System.out.println(link); } Now, if the variables link1, link2 and link3 have a value of "X", "Y" and "Z" respectively, upon running this program, I get the following output - link1 link2 link3 What I want is - X Y Z Any ideas?

  Read the article

• HOW TO RETURN VALUE FROM FUNCTION? (c#)

  - by Ole Jak

  So... I want to return value when C# function is called. I need a code example (simple summ of a,b values will be ok) Please help I need something like this ( I know ActionScript so I will write in it): public function sum(valueA:int, valueB:int):int { var summ:int = valueA + valueB; return summ; } How to translate it into C#?

  Read the article

• for_each but for setting each element to a value in C++

  - by Goose Bumper

  I have the following code to assign a value to all the elements of a vector: x = 100; for (int i=0;i<vect.size();i++) { vect[i] = x; } It's straightforward enough, but I'm wondering if there is a function in the STL that does the same thing; something like for_each, but for assignment.

  Read the article

• Appropriate data field type for true/false value?

  - by Industrial

  Hi everybody, What's the most appropriate (read least data consuming) data field to store a true/false/1/0 value in a mySQL database? I have previously used a one character long tinyint, but I am not sure if it's the best solution? Thanks!

  Read the article

• Getting maximum value from table using LINQ

  - by Tena

  I have a table in my database. I want to get the maximum value of a column named NumOfView. I used this code: var advert=(from ad in storedb.Ads where ad.AdScope == "1" select ad.NumOfView).Max(); It works but when there are two or more same maximum values it doesn't work and this message appears: Sequence contains more than one element What should I do now? Your answers will be very helpfull. Thanks

  Read the article

• Best way to add the minus "-" front of decimal value

  - by AlwaysBeCoding

  I would like to ask how i should add the minus sign front of a decimal value. i want the user to add e.g. 100 and behind the scenes to convert it in -100 thank you.

  Read the article

• Selecting count(*) while checking for a value in the results

  - by Rob

  SELECT COUNT(*) as Count, IF(sch.HomeTeamID = 34,true,false) AS Hawaii FROM schedule sch JOIN schools s ON s.ID = 83 WHERE (sch.HomeTeamID = 83 OR sch.AwayTeamID = 83) AND sch.SeasonID = 4 I'm trying to use count() to simplify my result but also include a field that represents wether any of the results' specific column contained a certain value. Is this possible? I'd basically like a row response with all the info I need.

  Read the article

• LOAD DATA LOCAL INFILE custom value

  - by NR03

  How to add a custom value using LOAD DATA LOCAL INFILE? The column time_added is the 7th column and the file has only 2 values for the first and the second column. For the 7th column, time_added I want to use the unix timestamp when loading from file. This code isn't working: $result = mysql_query("LOAD DATA LOCAL INFILE '{$myFile}' INTO TABLE {$table} FIELDS TERMINATED BY ':' LINES TERMINATED BY '\n' SET `time_added`=unix_timestamp()");

  Read the article

• Concatenate multi value into one record.

  - by mikehjun

  I joined two tables together and what I like to do is concatenate multi vaule in one records without duplicated value. TAXLOT_ZONE TID ZONE 1 A 1 A 1 B 1 C 2 D 2 D 2 E 3 A 3 B 4 C 5 D Desirable Final table looks like; TID ZONE 1 A, B, C 2 D, E 3 A, B 4 C 5 D

  Read the article

• Jquery prevent dragging of text value

  - by ipr101

  I have a html textbox on which I've bound a function via jQuery to the paste event to prevent users pasting a value into the textbox. This functionality works well. However it is possible to select some text from another textbox on the page and drag it into the textbox in which pastes are prevented. Is there a jQuery event that I can bind to that will prevent users dragging text into the texbox?

  Read the article

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