So I didn't see a question here that really answers this question. It's kinda a newbie question about linq but I would like to know if it would be possible to convert the following sql query (built using C#) into a linq query: public void DoSomeQuery(bool whereCriteria1, bool whereCriteria2) { string sqlQuery = "SELECT p.*"; str...
I have a unicode string in Python and basically need to go through, character by character and replace certain ones based on a list of rules. One such rule is that a is changed to ö if a is after n. Also, if there are two vowel characters in a row, they get replaced by one vowel character and :. So if I have the string "natarook", what i...
Often I stumble upon following approach of defining conditional statement: if(false === $expr) { ... } I have several questions about this. Is there a point of using constant value (false, 1, 0, 123, 'string' etc) as a first operand instead of second in cases when second operand is not too long. For example, I would prefer to...
What is the difference between these four PHP statements? if (isset($data)) { if (!empty($data)) { if ($data != '') { if ($data) { Do they all do the same? ...
I've researched related questions on the site but failed to find a solution. What I have is a user activity table in MySQL. It lists all kind of events of a user within a photo community site. Depending on the event that took place, I need to query certain data from other users. I'll explain it in a more practical way by using two examp...
Is using an if coupled with an immediate return like in the example below an acceptable practise instead of having a if with a block of code inside {} ? Are these equivalent in practise or is there a disadvantage to one of the approaches ? An example in Java: protected void doGet(HttpServletRequest request, HttpServletResponse response...
Looking for some help with the code below. I think there may be an issue with the way I've organized the php call and function calls. I'm a beginner and am trying to allow users to display results from different tables, depending on what link they click. I get this error: Parse error: syntax error, unexpected '{' in /home/content/c/e...
Is there a way that I filter out rows in a HasManyToMany mapping? I have three tables (legacy, not able to change them) Service, Resource and ResourceService. The ResourceService allows multiple resources to link to multiple services but it also has an "Active" column. On my Resource domain object I've mapped the services linked to the...
I have two objects, A and B. They both share the same types of fields, 1 and 2. Their relationship can be expressed in SQL as follows: A's Bs: SELECT * FROM B WHERE B.1 = A.1 AND (B.2 = A.2 OR B.2 IS NULL) B's As: SELECT * FROM A WHERE B.1 = A.1 AND (A.2 = B.2 OR B.2 IS NULL) That's the tricky part - that B.2 can be null and still b...
I would like to control Xml serialization over each item of a List, suppose you have this : public class Item { [XmlElement("id")] public int Id { get; set; } [XmlElement("label")] public string Label { get; set; } #region Conditional serialization public bool ShouldSerializeLabel() { ...
Looking for a while now already for how to accomplish this. Seems that all solutions need unique fields with indexes. ...
OK, the umpteenth conditional column question: I'm writing a stored proc that takes an input parameter that's mapped to one of several flag columns. What's the best way to filter on the requested column? I'm currently on SQL2000, but about to move to SQL2008, so I'll take a contemporary solution if one's available. The table queried in...
I'm involved is a project to migrate a project from Oracle to MySQL. I Have a script that i'm running from the MySQL shell command, called CreateTables.sql that looks like this internally: source table\DropForeignKeys.sql source tables\Site.sql source tables\Language.sql source tables\Country.sql source tables\Locale.sql source tables\T...
$headers=array( $requestMethod." /rest/obj HTTP/1.1", "listable-meta: ".$listablemeta, "meta: ".$nonlistmeta, 'accept: */*', ); In the above example, I'd like to omit the whole line if $listablemeta or $nonlistmeta is blank. Assume $listablemeta is blank. Then the array would be: $headers=array( $request...
Hello, I am doing a game with cocos2d and using chipmunk to manage the physics. What I would like to achieve is what pretty much every nintendo game does that your character may jump and rest in a higher floor (collision shape) without causing a collision as long as the velocity is positive, and that once the velocity is negative the co...
I have a table that contains multiple rows. Each row contains 5 columns (or 5 TDs). Inside of the first TD is a text field and a select box. The 4 other TDs each contain a table that contains a set of radio buttons. <tr bgcolor=#ffffff> <td valign=center> <select name=player1> <option>0</option> <option>1</option> </select> ...
A quick C# question, I would like to know that in my project > Properties > Build, there is a check "Define DEBUG constant", so if I check that and then do this, [Conditional(DEBUG)] public static void Foo() { Console.WriteLine("Executed Foo"); } See it's not "DEBUG" its the DEBUG constant. So will this be okay? Or do I have to ...
This is probably a simple question, but I can't figure it out so I'm asking the community. I have a select list and a text field in a form. They both have the same class. I want to find a clean conditional statement that will allow me to disable a set of radio buttons in another part of the form if the text field is not empty AND some...
I want to switch the value for isFollowing. If it's true I want isFollowing = false and the opposite too. Instead of 'if' statement i am using ? : isFollowing == true ? isFollowing = false : isFollowing = true; But this isn't working. it gives "Only assignment, call, increment, decrement, and new object expressions can be us...
$result=mysqli_fetch_array(mysqli_query($link, $query)); the IF MAYOR image is not working i guess there is a confilct with the original db call? In addition to email reminders, you can also LEND WITH CONFIDENCE because I have have a VERIFIED ACCOUNT and neigh*borrow will GUARANTEE that I return this item or they will replace it up...