Search Results

Search found 19603 results on 785 pages for 'variable length'.

Page 118/785 | < Previous Page | 114 115 116 117 118 119 120 121 122 123 124 125  | Next Page >

• Is there limit of "join" or the "where" or length of SQL query ?

  - by Chetan sharma

  Actually i was trying to get data from elgg database based on multiple joins. It generated very big query with lots of JOIN statements and query never respond back. SELECT distinct e.* from test_entities e JOIN test_metadata m1 on e.guid = m1.entity_guid JOIN test_metastrings ms1 on ms1.id = m1.name_id JOIN test_metastrings mv1 on mv1.id = m1.value_id JOIN test_objects_entity obj on e.guid = obj.guid JOIN test_metadata m2 on e.guid = m2.entity_guid JOIN test_metastrings ms2 on ms2.id = m2.name_id JOIN test_metastrings mv2 on mv2.id = m2.value_id JOIN test_metadata m3 on e.guid = m3.entity_guid JOIN test_metastrings ms3 on ms3.id = m3.name_id JOIN test_metastrings mv3 on mv3.id = m3.value_id JOIN test_metadata m4 on e.guid = m4.entity_guid JOIN test_metastrings ms4 on ms4.id = m4.name_id JOIN test_metastrings mv4 on mv4.id = m4.value_id JOIN test_metadata m5 on e.guid = m5.entity_guid JOIN test_metastrings ms5 on ms5.id = m5.name_id JOIN test_metastrings mv5 on mv5.id = m5.value_id JOIN test_metadata m6 on e.guid = m6.entity_guid JOIN test_metastrings ms6 on ms6.id = m6.name_id JOIN test_metastrings mv6 on mv6.id = m6.value_id where ms1.string='expire_date' and mv1.string <= 1272565800 and ms2.string='homecity' and mv2.string LIKE "%dasf%" and ms3.string='schoolname' and mv3.string LIKE "%asdf%" and ms4.string='award_amount' and mv4.string <= 123 and ms5.string='no_of_awards' and mv5.string <= 7 and ms6.string='avg_rating' and mv6.string <= 2 and e.type = 'object' and e.subtype = 5 and e.site_guid = 1 and (obj.title like '%asdf%') OR (obj.description like '%asdf%') and ( (e.access_id = -2 AND e.owner_guid IN ( SELECT guid_one FROM test_entity_relationships WHERE relationship='friend' AND guid_two=5 )) OR (e.access_id IN (2,1) OR (e.owner_guid = 5) OR ( e.access_id = 0 AND e.owner_guid = 5 ) ) and e.enabled='yes') and ( (m1.access_id = -2 AND m1.owner_guid IN ( SELECT guid_one FROM test_entity_relationships WHERE relationship='friend' AND guid_two=5 )) OR (m1.access_id IN (2,1) OR (m1.owner_guid = 5) OR ( m1.access_id = 0 AND m1.owner_guid = 5 ) ) and m1.enabled='yes') and ( (m2.access_id = -2 AND m2.owner_guid IN ( SELECT guid_one FROM test_entity_relationships WHERE relationship='friend' AND guid_two=5 )) OR (m2.access_id IN (2,1) OR (m2.owner_guid = 5) OR ( m2.access_id = 0 AND m2.owner_guid = 5 ) ) and m2.enabled='yes') and ( (m3.access_id = -2 AND m3.owner_guid IN ( SELECT guid_one FROM test_entity_relationships WHERE relationship='friend' AND guid_two=5 )) OR (m3.access_id IN (2,1) OR (m3.owner_guid = 5) OR ( m3.access_id = 0 AND m3.owner_guid = 5 ) ) and m3.enabled='yes') and ( (m4.access_id = -2 AND m4.owner_guid IN ( SELECT guid_one FROM test_entity_relationships WHERE relationship='friend' AND guid_two=5 )) OR (m4.access_id IN (2,1) OR (m4.owner_guid = 5) OR ( m4.access_id = 0 AND m4.owner_guid = 5 ) ) and m4.enabled='yes') and ( (m5.access_id = -2 AND m5.owner_guid IN ( SELECT guid_one FROM test_entity_relationships WHERE relationship='friend' AND guid_two=5 )) OR (m5.access_id IN (2,1) OR (m5.owner_guid = 5) OR ( m5.access_id = 0 AND m5.owner_guid = 5 ) ) and m5.enabled='yes') and ( (m6.access_id = -2 AND m6.owner_guid IN ( SELECT guid_one FROM test_entity_relationships WHERE relationship='friend' AND guid_two=5 )) OR (m6.access_id IN (2,1) OR (m6.owner_guid = 5) OR ( m6.access_id = 0 AND m6.owner_guid = 5 ) ) and m6.enabled='yes') order by obj.title limit 0, 10 this is the query that i am running.

  Read the article

• How do I pass a Python Variable to Bash?

  - by user336537

  Hello, How would I pass a Python variable to the Bash shell? It should work like this: foo="./RetVar.py 42" Replace the double-quotes with `s I have tried printing and sys.exiting the result, but to no avail. How would I accomplish my goal?

  Read the article

• Why do Windows environment variable names use a special escape character?

  - by bde

  I am curious if there is any history behind why the ^ character is used to escape the special characters <, , |, &, and ^ in environment variable names in Windows instead the '\' character that is typically used to escape special characters. Please note that I realize there may be no reason for this, but I'd be interested to hear if there is a reason.

  Read the article

• How to create dynamic incrementing variable using "for" loop in php?

  - by Parth

  How to create dynamic incrementing variable using "for" loop in php? like wise: $track_1,$track_2,$track_3,$track_4..... so on....

  Read the article

• How can fill a variable of my own created data type within Oracle PL/SQL?

  - by Frankie Simon

  In Oracle I've created a data type: TABLE of VARCHAR2(200) I want to have a variable of this type within a Stored Procedure (defined locally, not as an actual table in the DB) and fill it with data. Some online samples show how I'd use my type if it was filled and passed as a parameter to the stored procedure: SELECT column_value currVal FROM table(pMyPassedParameter) However what I want is to fill it during the PL/SQL code itself, with INSERT statements. Anyone knows the syntax of this?

  Read the article

• Reusing a NSString variable - does it cause a memory leak?

  - by Chris S

  Coming from a .NET background I'm use to reusing string variables for storage, so is the code below likely to cause a memory leak? The code is targeting OS X on the iphone/itouch so no automatic GC. -(NSString*) stringExample { NSString *result = @"example"; result = [result stringByAppendingString:@" test"]; // where does "example" go? return result; } What confuses me is an NSStrings are immutable, but you can reuse an 'immutable' variable with no problem.

  Read the article

• How to find the physical address of a variable from user-space in Linux?

  - by Sandip

  I want to find the physical address of a variable defined in a user-space process? Is there any way to do it using root privileges?

  Read the article

• Homemade fstat to get file size, always return 0 length.

  - by Fred

  Hello, I am trying to use my own function to get the file size from a file. I'll use this to allocate memory for a data structure to hold the information on the file. The file size function looks like this: long fileSize(FILE *fp){ long start; fflush(fp); rewind(fp); start = ftell(fp); return (fseek(fp, 0L, SEEK_END) - start); } Any ideas what I'm doing wrong here?

  Read the article

• Haw can i use a value from a session variable within the attribute of a control?

  - by William Calleja

  I have an ASP control custom built and I need to pass a value taken from a session variable to it like so: <custom:control id='mycontrol' value="+Session['myControlValue']+"> ... </custom:control> the above code obviously doesn't work, I need a way to insert the Session value in the control in this way somehow, can anyone help?

  Read the article

• Sorting a list of variable length integers delimited by decimal points...

  - by brewerdc

  Hey guys, I'm in need of some help. I have a list of delimited integer values that I need to sort. An example: Typical (alpha?) sort: 1.1.32.22 11.2.4 2.1.3.4 2.11.23.1.2 2.3.7 3.12.3.5 Correct (numerical) sort: 1.1.32.22 2.1.3.4 2.3.7 2.11.23.1.2 3.12.3.5 11.2.4 I'm having trouble figuring out how to setup the algorithm to do such a sort with n number of decimal delimiters and m number of integer fields. Any ideas? This has to have been done before. Let me know if you need more information. Thanks a bunch! -Daniel

  Read the article

• How to remove a text from a variable? (php)

  - by Glister

  I have a variable $link_item, it's used with echo and gives the strings like <span class="name">Google</span>http://google.com How to remove "<span class="name">Google</span>" from string? It should give just "http://google.com". Heard it can be done with regex(), please help.

  Read the article

• How can I access class variable inside a NSMutableArray object?

  - by ahmet732

  I have "Man" class which also has 2 variable : "description" and "name". At a point, I created Man class and initialize with its own variables (description and name) and pass it to NSMutableArray "collector". How can I access description now ? I tried but i could not get the property

  Read the article

• How to acces a global variable in a callback object in javascript YUI without use window.myvariable

  - by quilovnic

  I have this : var MyObject = function(){ this.url = "monurl"; this.mavar = ""; this.Load = function(){ var callback = { success: function(o){ mavar = o.responseXML.getElementsByTagName("montag")[0].firstChild.nodeValue; } } YAHOO.util.Connect.asyncRequest('GET',url,callback); } } the mavar variable is not accessible. How can I do this ?

  Read the article

• Is there a "fancy" Ruby way to check whether a local variable is both defined and evaluates to true without using ands and ors?

  - by Steven Xu

  This is quite a quick question. I currently use do_this if (testvar ||= false) Which works just fine. But this approach unnerves me because while fast, it does not short-circuit like defined?(testvar) && testvar does, and it instantiates and assigns a value to a local variable that is subsequently never used, which seems inefficient. I enjoy the very reasonable fact that instance variables are nil before assignment, but I'd like for the situation to be just as easy for local variables.

  Read the article

• C++ include statement required if defining a map in a headerfile.

  - by Justin

  I was doing a project for computer course on programming concepts. This project was to be completed in C++ using Object Oriented designs we learned throughout the course. Anyhow, I have two files symboltable.h and symboltable.cpp. I want to use a map as the data structure so I define it in the private section of the header file. I #include <map> in the cpp file before I #include "symboltable.h". I get several errors from the compiler (MS VS 2008 Pro) when I go to debug/run the program the first of which is: Error 1 error C2146: syntax error : missing ';' before identifier 'table' c:\users\jsmith\documents\visual studio 2008\projects\project2\project2\symboltable.h 22 Project2 To fix this I had to #include <map> in the header file, which to me seems strange. Here are the relevant code files: // symboltable.h #include <map> class SymbolTable { public: SymbolTable() {} void insert(string variable, double value); double lookUp(string variable); void init(); // Added as part of the spec given in the conference area. private: map<string, double> table; // Our container for variables and their values. }; and // symboltable.cpp #include <map> #include <string> #include <iostream> using namespace std; #include "symboltable.h" void SymbolTable::insert(string variable, double value) { table[variable] = value; // Creates a new map entry, if variable name already exist it overwrites last value. } double SymbolTable::lookUp(string variable) { if(table.find(variable) == table.end()) // Search for the variable, find() returns a position, if thats the end then we didnt find it. throw exception("Error: Uninitialized variable"); else return table[variable]; } void SymbolTable::init() { table.clear(); // Clears the map, removes all elements. }

  Read the article

• How do I increment a variable so it chooses differnet lines from a text files in a While Loop.

  - by Kirk

  I have a script im writing. Here is whats happening. There is a while loop. In the while loop is a variable which is constant to X. How do i make X change from line one, line two, etc for each cycle of the while loop and pull X from a .txt file. Everything is in root. Thanks

  Read the article

• Most inappropriate function or variable names you have encountered?

  - by Andrioid

  I was reading through my daily doze of RSS when I noticed a link to the python compiler documentation where class names like assList, assName and assTuple exist. While starting names with 'ass' is perfectly acceptable to me, it just sparked this idea that there probably exist much better examples of this. Have you personally used or otherwise encountered any inappropriate function or variable names? Personally I have used 'crap' and 'moo' for temporary purposes, forgot them and at a later point they came too integrated for me to bother with fixing them.

  Read the article

• Can I set an environment variable for an application using a shortcut in Windows?

  - by serpent5

  I have a feeling I should be able add a directory to the PATH environment variable on an application-lifetime basis, but I can't find out how to do this. Is it possible to add a parameter to a Windows shortcut that appends a directory to the current value of PATH for use by the application being linked? Cheers.

  Read the article

• How to get a name of a variable coming into a function as a parameter using F#?

  - by Oldrich Svec

  Is there any way in F# how to get a name of a variable passed into a function? Example: let velocity = 5 let fn v = v.ParentName let name = fn velocity // this would return "velocity" as a string Thank you in advance

  Read the article

• hi all here is another problem of Ajax , strange but ...

  - by Dumbledore of flash

  when i put ajax on my code I send a group of variable via post but when i received the data it is in a obj.responseText ie TEXT format. say i have two files "form.php" and "index.php" ajax is implemented in form.php while index.php returns the text. but my problem is index.php also generates a variable named "tarriff_count" i want to catch systematically and separately this variable, Is there any systematic way to catch variable.also keep in mind "obj.responseText" is very complicated to get a variable from "preg_match" ?

  Read the article

• A more elegant way to parse a string with ruby regular expression using variable grouping?

  - by i0n

  At the moment I have a regular expression that looks like this: ^(cat|dog|bird){1}(cat|dog|bird)?(cat|dog|bird)?$ It matches at least 1, and at most 3 instances of a long list of words and makes the matching words for each group available via the corresponding variable. Is there a way to revise this so that I can return the result for each word in the string without specifying the number of groups beforehand? ^(cat|dog|bird)+$ works but only returns the last match separately , because there is only one group.

  Read the article

• How do I pass an asp variable to a selectcommand?

  - by Anthony

  I am trying to pass a variable "PIN2" that I am retrieving like below to a SelectCommand statement in a asp SqlDataSource tag <% Dim PIN As String = Request.ServerVariables("LOGON_USER") Dim PIN2 As String = Right(PIN, 6) %> Thanks

  Read the article

• How do I access a variable defined in URL when using Zend Framework?

  - by ben

  I had a read of the documentation, but couldn't see an example of how it would be possible to use the variable in traditional PHP style of $_POST['var'] I'm pretty sure my URL is legit: domain.com/module/controller/action/var/value/ Using the above as an example: $var didn't work $_POST['var'] didn't work How is it done?

  Read the article

• Can you still do variable arguments in C the old way?

  - by philcolbourn

  Purely for interest, I am re-learning C after ... I don't know ... 15 - 20 years. I seem to recall that variable arguments were implemented as simple macros. Can anyone remember what they were? Will they still work today?

  Read the article

• In PHP :how can I use include() Function which parameter is variable ?

  - by Nina

  Hi.. I need to use include Function with variable. but,when I try to do it I faced some errors . Code : $year=$_POST['year']; $month=$_POST['month']; $day=$_POST['day']; include "Event.php?year=".$year."&month=".$month."&day=".$day; so,can U help me ? : )

  Read the article

< Previous Page | 114 115 116 117 118 119 120 121 122 123 124 125  | Next Page >