hi, in MySQL 5.1, i named a field 'Starting'. However, eachtime i would used an SQL query, it would say invalid SQL syntax. After some google search, i found out that STARTING is a reserved SQL word, but Undocumented. Can anyone tell me what it is? thanks. http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html ...
I've started my own thread on this question so as to have less overhead from posting it on someone else's thread. I have trouble understanding in SQL what the difference is between GROUP BY and ORDER BY. I know there have been threads made about this, but they don't provide me with a useful answer. Here is something along the general ...
I came across a piece of code that is: for(i=((90.0E1,0x5A)<=(0x158,140.70E1)?(.28,3.45E2,0):(95.30E1,26.40E1)<=1.400E2?(1,this):(108.,0x227));i<length;i++) { // some other code here } Can someone help me by explaining the stuff in the for() brackets? Thanks ...
What does '\r' mean? What does it do? I have never seen it before and its giving me headaches. It doesnt seem to have any purpose, since 'a\ra' prints as 'aa', but its not the same as the string 'aa'. Im using python 2.6 ...
We all love do, and I was curious if perhaps this sort of alternate syntax would theoretically be useful outside of the monad world. If so, what other sorts of computations would it simplify? Would it make sense to have something equivalent for Applicative, for example? ...
I can express 3rd page is the title page in YAML title: 3 What about the following? Pages 10 to 15 contains chapter 1 One way is chapter 1: [10, 11, 12, 13, 14, 15] I would prefer a range here. Is there anything like that in YAML? chapter 1: (10..15) ** Update ** The following would be my alternative if there is no ...
How would I implement a word processor on a website I'm making? The point is I want a user to be able to type in text and it have syntax highlighting in the text box they're typing in. Could someone instruct me in how to do this? ...
I try to SUM values from columns, from a query which contains some JOINS. Example: SELECT p.id AS product_id, SUM(out_details.out_details_quantity) AS stock_bought_last_month, SUM(order_details.order_quantity) AS stock_already_commanded FROM product AS p INNER JOIN out_details ON out_details.product_id=p.id INNER JOIN or...
Does anyone know what the syntax is to use the file revision keyword within the code in C#? I know how to use it in SQL Server but I can't seem to get the syntax right. I have already added the property to the file in which I would like to display the version. Thanks! badPanda ...
What is the name of the character at the end of each of these lines? Dim _int As Integer = 1I Dim _short As Short = 1S Dim _long As Long = 1L Dim _single As Single = 1.0F Dim _double As Decimal = 1D I've always called these "type specifiers". I assume that's incorrect as I'm unable to find the official documentation using this term. I...
Possible Duplicate: class << self idiom in Ruby I have a quick Ruby question. I come from a Java/c background, so I understand in Ruby "self" when referenced inside a instance method acts like "this". And "self." prefix for method defines it as a class method. But what does this mean here?? class << self def some_method ...
Just out of curiosity, I was wondering if there are any speed/efficiency differences in using [=] versus [in] versus [like] versus [matches] (for only 1 value) syntax for sql. select field from table where field = value; versus select field from table where field in (value); versus select field from table where field like value; ...
What's the precedence in the next expression? item = (char*)heap + offset; Is it (char*)(heap + offset) or ((char*)heap) + offset? ...
I'm trying to include multiple blockquotes using markdown, but I'm stuck on the syntax for closing out the initial blockquote and starting a new one instead of continuing in the current blockquote and adding additional paragraphs... === Current syntax === > Review1 > -- <cite>Person1</cite> > Review2 > -- <cite>Person2</cite> ...
i'm trying to insert data into xml using php domdocument. however when i hit enter, it just displays a blank page showing no error. what am i doing wrong? UPDATED: <?php error_reporting(E_ALL); ini_set("display_errors", 1); $xmldoc = new DOMDocument(); if(file_exists('test.xml')){ $xmldoc->load('test.xml'); } els...
hey. with the following code <?php if (qtrans_getLanguage() == "en") { echo <?php include( TEMPLATEPATH . '/slider_en.php' ); ?>; }else{ echo <?php include( TEMPLATEPATH . '/slider_de.php' ); ?>; } ?> i'm trying to include a file, based on the chosen language of the website. guess my idea is right but i'm totaly wrong on ...
I've been working with PHP code that generates HTML without any templating, and it's quite spaghetti and difficult to read with the way they've structured it. One way to drastically improve following the flow I've noticed is to use : endif instead of { } blocks in some cases to increase readability. (See http://php.net/manual/en/control-...
hey, Im trying to make a call a jquery function and pass some args with it in the form of $('#button').mouseenter(exampleFunction(arg1,arg2)); function exampleFunction(arg1,arg2) The function works fine with no args written like this. $('#button').mouseenter(exampleFunction); function exampleFunction; but as soon as i add () to p...
I have a very long string which includes many new lines ( it's a really long SQL statement ). The SQL is easier to read when I break it up with newlines. But from time to time, I need to copy the sql statement from code to paste into sql developer. In Perl, I always loved the qq operator, which you can use in place of double quotes: ...
Hi. Does anybody know any tool for validating the syntax of an Regular Expression? I dont want to validate if it matches or not with some text but I want to see if there are syntax errors in the regex (missing parenthisis etc). Also, what about syntax highlighting? It would be a great help when writing complex regex. ...