Search Results

Search found 7086 results on 284 pages for 'proprietary syntax'.

Page 140/284 | < Previous Page | 136 137 138 139 140 141 142 143 144 145 146 147  | Next Page >

• EXTRACT for TIMESTAMP types in SQLite3

  - by umuthorax

  Hi, It seems extract function is not supported by SQLite3 for timestamp types (ref). For example; select extract(year from l_shipdate) as l_year from ... gives the following error; Error: near "from": syntax error I wonder whether there is an alternative way to do this in SQLite3 (or through rewriting the SQL query). Thanks in advance,

  Read the article

• writing an Dynamic query in sqlserver

  - by prince23

  hi, DECLARE @sqlCommand varchar(1000) DECLARE @columnList varchar(75) DECLARE @city varchar(75) DECLARE @region varchar(75) SET @columnList = 'first_name, last_name, city' SET @city = '''London''' SET @region = '''South''' SET @sqlCommand = 'SELECT ' + @columnList + ' FROM dbo.employee WHERE City = ' + @city and 'region = '+@region --and 'region = '+@region print(@sqlCommand) EXEC (@sqlCommand) when i run this command i get an error Msg 156, Level 15, State 1, Line 8 Incorrect syntax near the keyword 'and'. and help would great thank you

  Read the article

• mssql: problem with string concatenation.

  - by 0plus1

  I'm trying this as part of a big query: (CONVERT(varchar(20), AZ_DTA_APP_AGE, 103) + ' ' + (CONVERT(varchar(20), AZ_DTA_APP_AGE, 108)) AS AZ_DTA_APP_AGE why it doesn't work? I get: Syntax error near keyword 'AS' Thank you

  Read the article

• SQL Server Server query - Count distinct DateTime field

  - by strakastroukas

  Supposing we have the following records in an SQL Server table. Date 19/5/2009 12:00:00 pm 19/5/2009 12:15:22 pm 20/5/2009 11:38:00 am What is the SQL syntax for getting something like this one? Date Count 19/5/2009 2 20/5/2009 1

  Read the article

• What is the best way to combine two uints into a ulong in c#

  - by Jason Coyne

  What is the best way to combine two uints into a ulong in c#, setting the high/low uints. I know bitshifting can do it, but I don't know the syntax, or there maybe other APIs to help like BitConverter, but I don't see a method that does what I want.

  Read the article

• Can I use EXISTS keyword in sql query for assignment of result

  - by Shantanu Gupta

  Can I assign a value with EXISTS in the query. Currently it is giving me error Incorrect syntax near '='. But when I uses this query only it runs as expected. IF EXISTS (SELECT @PK_LOGIN_ID=PK_LOGIN_ID FROM dbo.M_LOGIN WHERE LOGIN_NAME=@LOGIN_NAME AND PASSWORD=@PASSWORD AND FK_ROLE_ID=@FK_ROLE_ID) RETURN @PK_LOGIN_ID ELSE RETURN 0

  Read the article

• jQuery Templates vs Partial Views in ASP.NET MVC

  - by Jaco Pretorius

  I'm taking a look at jQuery templates. It looks really interesting - easy syntax, easy to use, very clean. However, I can't really see why it's better to use jQuery templates instead of simply fetching partial views via AJAX. It simply seems like the partial views would be much easier to maintain and helps to avoid duplication of code. I want to use jQuery templates. But when would it be better than partial views?

  Read the article

• jquery .html() vs div creation

  - by Argiropoulos Stavros

  Hello Lets say i have a div <div id='myDiv'></div> If i do: $('#myDiv').html('<div id='mySecondDiv'></div>') is it the same as var mySecondDiv=$('<div></div>'); $('myDiv').add(mySecondDiv); I'm pretty sure i have syntax errors but you get the idea.Are the two methods same?

  Read the article

• Hidden features of PL/SQL

  - by Adam Paynter

  In light of the "Hidden features of..." series of questions, what little-known features of PL/SQL have become useful to you? Edit: Features specific to PL/SQL are preferred over features of Oracle's SQL syntax. However, because PL/SQL can use most of Oracle's SQL constructs, they may be included if they make programming in PL/SQL easier.

  Read the article

• ksh: Iterate through a range

  - by sgreeve

  How can I iterate through a simple range of ints using a for loop in ksh? For example, my script currently does this... for i in 1 2 3 4 5 6 7 do #stuff done ...but I'd like to extend the range way above 7. Is there a better syntax? Thanks!

  Read the article

• HQL Insert Query in Grails

  - by WaZ

  I want to write an insert query in Grails. I have tried all possible combinations but cant get the syntax correct. Can anybody please help? class Person { int age int name } i tried the following: Person.executeUpdate("insert into Person values (20,30)") p.s.:Please do not mention using save()

  Read the article

• How to convert an application to be a database independent app ?

  - by Eslam

  I have a java web application that has informix DB as it's back end database , now i take a decision to make my app work with SqlServer so i changed all the informix related syntax into SqlServer, and i may take a decision in the future to switch into oracle so the pain will be repeated again and again, as a result i decided to make my application a DataBase independent one that's able to work with any DB vendor smoothly, but i have no idea till now about how to do that, so your ideas is welcomed.

  Read the article

• How to test my Firebird SQL queries

  - by Bob

  I'm in the process of learning SQL, and I need a way of verifying that my SQL queries are valid (i.e. no syntax errors). I also would like to check what results they yield on a test database of my choosing and structure. I'm using embedded firebird in my C# .NET application, so I don't really have any tools to work with. Anyone have any tips? Perhaps there are SQL administrators/query IDEs out there that work with Firebird?

  Read the article

• how to make Xcode indentation from beginning of previous line?

  - by Mikkel

  ok, possibly insanely n00b question or something i have overlooked in Xcode prefs: On pressing return, in stead of Xcode's syntax-aware indentation doing smart indent from whatever brackets i've used on the previous line, how can I make it so Xcode indents just from the beginning of the previous line? From the picture below, first block of code is what i got, second block of code is what I want. Visual representation:

  Read the article

• php preg_replace , I need to replace everything after a dot (e.g 340.38888 > need to get clean 340)

  - by Michael

  I need to replace everything after a dot . I know that it can be done with regex but I'm still novice and I don't understand the proper syntax so please help me with this . I tried the bellow code but doesn't work : $x = "340.888888"; $pattern = "/*./" $y = preg_replace($pattern, "", $x); print_r($x); thanks , Michael

  Read the article

• importing csv file into pgsql

  - by running4surival

  ok im trying to upload this csv file onto my table in pgsql but im getting this error ERROR: invalid input syntax for integer: "mlname,mfname,slname,sfname,address,postalcode,membershiptype,hphone,email" CONTEXT: COPY members2, line 1, column id: "mlname,mfname,slname,sfname,address,postalcode,membershiptype,hphone,email" i really understand why im getting this error, both my table and my csv file have the same column names

  Read the article

• Should I invest time in learning Java language these days? (question from a greenhorn)

  - by dave-keiture

  Hi experts, Assuming you've already had a chance to look through the lambda syntax proposed for Java7 (and the other things that have happened with Java, after Oracle has bought Sun + obvious problems in Java Community Process), what do you think is the future of Java language? Should I, as a Java greenhorn, invest time in learning Java language (not talking about the core JVM, which definitely will survive anything, and worth investments), or concentrate on Scala, Groovy, or other hybrid languages on the JVM platform (I've came into Java world from PHP/Ruby). Thanks in advance.

  Read the article

• Some questions about working with Haml

  - by damian

  I am trying to use Haml with Grails but I am having some issues. The plugin for haml has errors to parse empty lines. The plugin generate gsp files, so I think that I can use the online haml html generator. Bug I want something like an editor with syntax highlithing, blocks, etc, and that generate html. Is there something like this? Or only the editor? thanks in advance

  Read the article

• Generated queries contain schema and catalog name

  - by stacker

  I've the same problem as described here In the generated SQL Informix expects catalog:schema.table but what's actually generated is catalog.schema.table which leads to a syntax error. Setting: hibernate.default_catalog= hibernate.default_schema= had no effect. I even removed schema and catalog from the table annotation, this caused a different issues : the query looked like that ..table same for setting catalog and schema to an empty string. Versions seam 2.1.2 Hibernate Annotations 3.3.1.GA.CP01 Hibernate 3.2.4.sp1.cp08 Hibernate EntityManager 3.3.2.GAhibernate Jboss 4.3 (similar to 4.2.3)

  Read the article

• With ARC why use @properties anymore?

  - by trapper

  In non-ARC code retained properties handily take care of memory management for you using the self.property = syntax, so we were taught to use them for practically everything. But now with ARC this memory management is no longer an issue, so does the reason for using properties evaporate? is there still any good reason (obviously other than providing public access to instance variables) to use properties anymore?

  Read the article

• What are the differences in string literals between C#, Visual Basic.NET, and Managed C++?

  - by Kyle Ryan

  I'm referring to the syntax for writing strings in code, including multiline strings and verbatim strings. (Context: I'm working on a tool that scans code, and it's important to determine when tokens are inside a string.) Thanks!

  Read the article

• Passing arguments to an Rspec SpecTask

  - by Bayard Randel

  Rake allows for the following syntax: task :my_task, :arg1, :arg2 do |t, args| puts "Args were: #{args}" end I'd like to be able to do the same, but with RSpecs SpecTask. The following unfortunately fails: desc "Run example with argument" SpecTask.new('my_task'), :datafile do |t, args| t.spec_files = FileList['cvd*_spec.rb -datafile=#{args}'] t.spec_opts = ["-c -f specdoc"] end Is it possible to achieve this with a SpecTask, or is there an alternative approach?

  Read the article

• Can I chain database links in Oracle?

  - by RenderIn

  I have 3 databases. 1 links to 2, 2 links to 3. I'd like to query tables in 3, from 1. I tried third_db_tab@3@2 and it did not work. Wondering if this is possible and if so, what the syntax is.

  Read the article

• How Linux programmers create GUI application without using IDE?

  - by CMW

  Hi, I have read some comments in some forums saying that Linux programmers usually do not use any IDE. They prefer to use Vim and Emacs to do their programming. If I'm not mistaken, Vim and Emacs are just text editors, similar to notepad, but with syntax highlighting. I just want to know how Linux programmers create complicated GUI application without using any IDE. Thanks.

  Read the article

• How do I add complex where clause to Zend Table Select?

  - by AD

  I searched the Web and could not find anything that would show me a good solid example. My question is basically this: How do I convert this: SELECT * FROM table WHERE ((a = 1 AND b = 2) OR (c = 3 OR c = 4)) AND d = 5; To Zend syntax similar to this: $this -select() -from($this-_schema.'.'.$this-_name) -where('a = ?', '1'); So how can it be done? Thank a lot in advance.

  Read the article

< Previous Page | 136 137 138 139 140 141 142 143 144 145 146 147  | Next Page >