I'm getting the following error on the line of code below: Syntax error (missing operator) in query expression 'REPLACE(LTRIM(RTRIM(ATTACHMENTS)), ,'')'. Any help would be awesome... -----------the line of code that is giving me problems-------------------------------- objConn.Execute("UPDATE EMAIL_SEND_ATTACHMENTS set ATTACHMENTS =...
Hello! The question is as simple as stated in the title: What's the difference between the following two expressions? $(...) `...` For example, are the two variables test1 and test2 different? test1=$(ls) test2=`ls` ...
This question got me re-thinking about something that always bothered me: Does Java need tuples? Do you feel the lack of them in your day-to-day work? Do you think tuples would simplify otherwise complex data structures you find yourself implementing? ...
Just wondering if there is a better way to write the following PL/SQL piece of code in ORACLE ? IF(p_c_courtesies_cd is not null OR p_c_language_cd is not null OR v_c_name is not null OR v_c_firstname is not null OR v_c_function is not null OR p_c_phone is not null OR p_c_mobile is not null OR p_c_fax is not null OR v_c_email is not n...
Hi! Just tried to execute a small Lua script, but unfortunately I'm doing something wrong. I've no more ideas what the fault might be. function checkPrime( n ) for i = 2, n-1, 1 do if n % i == 0 then return false end end return true end The interpreter says: lua: /home/sebastian/luatest/test.l...
I'm just starting out with C# and to me it seems like Microsoft Called their new system .Net because you have to use the Internet to look everything up to find useful functions and which class they stashed it in. To me it seems nonsensical to require procedure/functions written and designed to stand alone ( non instantiated static obje...
Is there a way in C# sytax for defining a new line? (Like in VB _ ) Example: Instead of: string myStr = "very long string" + "another long string"; This: string myStr = "very long string \something another long string" Or; does compiler handles this and does something like; "string" + "string" -> "stringstring" in this example? ...
hi all, i would like to convert xhtml to dokuwiki syntax using xslt. now, one thing i can not seem to work my head around is how to handle nested lists. the dokuwiki syntax uses an asterisk (*) for a list item which is prepended by two white spaces per nesting level (c.f. wiki syntax). my question: in the following example, how can th...
I have this syntax which works (since it's from the API, pretty much) <% form_tag :action => "whatever" do -%> <div><%= submit_tag 'Save' %></div> <% end -%> and this, which works <%= form_tag({:action => "whatever"}, {:method => "get"})%> Now I have tried to combine them, guessing the syntax. The "get" does not get added ...
I'm using a string builder to build some SQL Scripts. I have a few Boolean Properties that I would like to test and then output different text based on true/false. I've you the C# syntax below when assigning a value to a variable, but it isn't working for this particular situation. Any ideas? What I'm used to doing: string someText ...
As a mostly self-taught programmer, I have never really had anyone explain why certain things should or should not be used. One example (which I picked up years ago and use quite often) is the alternative control structure syntax: x = (y == true) ? "foo" : "bar"; I personally find this syntax easy to follow, especially for short, conc...
Yesterday I found this function: function clone(obj) { return typeof obj === 'undefined' ? this : (clone.prototype = Object(obj), new clone); } I though that i saw alot in Javascript, but this syntax is unknown for me: clone.prototype = Object(obj), new clone Can someone explain me how to read this?? Can you give me li...
Is there anything like lint for crontab? I'd like to know that i've got all my spaces and stars sorted out without waiting for something to not work. ...
There's some code in our project that looks a bit like this: Private Sub Method1() Call InnerMethod End Sub Private Sub Method2() InnerMethod End Sub Private Sub InnerMethod() '' stuff End Sub What's the advantage of doing Method1 over Method2? ...
Can anyone set my MySQL syntax straight please? I am trying to set a user variable called "seconds" to equal the output of the query shown below (and it does work by it's self), but I am constantly geting "You have an error in your SQL syntax" errors. SET @seconds=AVG(t2.epoch-t1.epoch) FROM tmp_4045_metrics AS t1, tmp_4045...
What is the difference between void func(const Class *myClass) and void func(Class *const myClass) See also: http://stackoverflow.com/questions/269882/c-const-question http://stackoverflow.com/questions/455518/how-many-and-which-are-the-uses-of-const-in-c and probably others... ...
What is the proper CSS syntax is for applying multiple pseudo classes to a selector. I'd like to to insert "," after each item in a list except the last one. I am using the following css: ul.phone_numbers li:after { content: ","; } ul.phone_numbers li:last-child:after { content: ""; } This works fine on FF3, Chrome and Safa...
Does the order in which I set properties using the object initializer syntax get executed in the exact same order? For instance if I do this: var s = new Person { FirstName = "Micah", LastName = "Martin", IsLoaded = true } will each property get set in the same order? ...
I am trying to set every row's CheckColor to Blue in the table tblCheckbook (why the hell do people add tbl to the start of every table, I think I know it's a table). I'm using this query UPDATE tblCheckbook SET CheckColor = Blue However, Microsoft SQL Server Management Studio Express complains Invalid column name 'Blue'. T...
I'm trying to perform a group by action on an aliased column (example below) but can't determine the proper syntax. SELECT LastName + ', ' + FirstName AS 'FullName' FROM customers GROUP BY 'FullName' What is the correct syntax? EDIT Extending the question further (I had not expected the answers I had received) wou...