Search Results

Search found 32409 results on 1297 pages for 'sql syntax'.

Page 103/1297 | < Previous Page | 99 100 101 102 103 104 105 106 107 108 109 110  | Next Page >

• jQuery selector syntax gives Firefox warning

  - by FreekOne

  The following code stringref = "tab_2"; jQuery('.someclass a:not(.someclass #a_someclass_'+stringref+')').css('color', '#000'); gives me this warning in the FF 3.5.5 error console and I can't figure out why: Warning: Missing closing ')' in negation pseudo-class '#a_someclass_tab_2'. Is my syntax failing me or has FF gone bonkers ?

  Read the article

• Convert this Linq query from query syntax to lambda expression

  - by Jinkinz

  I'm not sure I like linq query syntax...its just not my preference. But I don't know what this query would look like using lambda expressions, can someone help? from securityRoles in user.SecurityRoles from permissions in securityRoles.Permissions where permissions.SecurableEntity.Name == "Unit" && permissions.PermissionType.Name == "Read" orderby permissions.PermissionLevel.Value descending select permissions There is a many-to-many relationship between users and security roles that makes this extra confusing. Thanks! Kelly

  Read the article

• Dynamic SQL to query an Adventureworks table

  - by salvationishere

  I am trying to see a list of tables from Adventureworks DB from "Person" schema in Sql Server 2008. I developed teh following SP, but after running it as follows it gives me error "Incorrect syntax near ')'". Do you know how I can revise this SP or exec statement? CREATE PROCEDURE [getTableNames] @SchemaName VARCHAR(50) AS BEGIN SET NOCOUNT ON; SET @SchemaName = 'PERSON' DECLARE @cmd AS VARCHAR(max) SET @SchemaName = RTRIM(@SchemaName) SET @cmd = N'SELECT TABLE_NAME ' + 'FROM information_schema.Tables ' + 'WHERE TABLE_TYPE = ''BASE TABLE'' AND TABLE_SCHEMA = @SchemaName' END exec sp_executesql getTableNames, N'@SchemaName NVARCHAR(50), @SchemaName'

  Read the article

• sql server modify error

  - by Jaspal

  hi, i m not able to modify table in SQL server. i m new to databases. use work go alter table employee modify id varchar(20) error message is- Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'modify' here is an screenshot thanks

  Read the article

• Syntax proposition

  - by Knowing me knowing you

  I wonder if syntax as follows would be helpful in your opinion as a code readability improvent and self-commenting of code: std::map<std::string name, std::vector<int> scores> myMap; In this example it clearly says and no other comment is needed, what for we are using myMap variable. Looking forward to your opinions.

  Read the article

• iPhone OS syntax highlighting UITextField

  - by Jack

  Hi, I am working on an application and would like to apply some syntax highlighting to some user entered text. I have looked around and some people are suggesting that this can be done in OS 3.2+ but posts seem to be from before the NDA was lifted. Does anyone have any suggestions as to how to go about doing this? I would be interested in releasing the code on github if I could get it implemented well, as I have never done so before. Thanks

  Read the article

• How to quote and reference MS SQL table and field names

  - by artvolk

  Good day! Despite the fact LINQ2SQL and ADO.NET Entity Framework exists there were situations when I need to revert to plain old DataSet (not typed) and friends. While writing SQL for SqlCommand: Is it needed to quote field and table names with []? Is it good to prefix table names with [dbo] I use to use this syntax: SqlCommand command = new SqlCommand("SELECT [Field1], [Field2] FROM [dbo].[TableName]", connection); May be there is a better way? Thanks in advance!

  Read the article

• How to get Haskell syntax highlighting on PHP blog

  - by anderstornvig

  Hi, I'm making a blog in PHP and I'd really like to have syntax highlighting on Haskell code. Are there any tools for that out there? I've found hscolour but I don't know if it's possible to integrate it in PHP. I'm using CakePHP if that makes a difference. Thanks.

  Read the article

• sql server: create table taking forever!

  - by every_answer_gets_a_point

  i am doing this: CREATE TABLE person ( num INT NOT NULL , firstname VARCHAR(20) NULL , lastname VARCHAR(30) NULL ); sql server is just saying "debbuging" and it's not doing anything is there a problem with the syntax or what?

  Read the article

• Equivalent of LIMIT and OFFSET for SQL Server?

  - by Earlz

  In PostgreSQL there is the Limit and Offset keywords which will allow very easy pagination of result sets. What is the equivalent syntax for Sql Server?

  Read the article

• Invalid syntax in this simple Python application.

  - by Sergio Boombastic

  Getting an invalid syntax when creating the template_value variable: class MainPage(webapp.RequestHandler): def get(self): blogPosts_query = BlogPost.all().order('-postDate') blogPosts = blogPosts_query.fetch(10) if users.get_current_user(): url = users.create_logout_url(self.request.uri) url_linktext = 'Logout' else: url = url = users.create_login_url(self.request.uri) url_linktext = 'Login' template_value = ( 'blogPosts': blogPosts, 'url': url, 'url_linktext': url_linktext, ) path = os.path.join(os.path.dirname(__file__), 'index.html') self.response.out.write(template.render(path, template_values)) The error fires specifically on the 'blogPosts': blogPosts line. What am I doing wrong? Thanks!

  Read the article

• How would I duplicate the Rank function in a Sql Server Compact Edition SELECT statement?

  - by AMissico

  It doesn't look like SQL Server Compact Edition supports the RANK() function. (See Functions (SQL Server Compact Edition) at http://msdn.microsoft.com/en-us/library/ms174077(SQL.90).aspx). How would I duplicate the RANK() function in a SQL Server Compact Edition SELECT statement. (Please use Northwind.sdf for any sample select statements, as it is the only one I can open with SQL Server 2005 Management Studio.)

  Read the article

• SQL inserting value of a specific column under multple case

  - by Lo Wai Lun

  Suppose I have got a table which I have to insert the description of the contract under different keys of contract. But when executing, there is a n error near then Is there any limitation of using syntax set ? The below is my SQL declare @i int, @j v nvarchar(MAX) set @i = 1 while (@i<=8) begin set @j = case when @i = 1 then 'CR' when @i = 2 then 'Facebook' else 'N/A' end INSERT INTO CostNature (CNKey, CNNDescription) VALUES (@i , @j ); set @i = @i + 1 end

  Read the article

• Programming languages with python-like syntax but native code generation

  - by maykeye

  Can anyone point to programming language which has python-like syntax, but from the very beginning was designed to generate native code? I'm aware of Boo only, but it uses .net, not native code generation. Well, if nothing else than python-like languages which generate .net/java bytecode are fine too.

  Read the article

• javascript syntax

  - by Michael

  var ret = [] ,xresult = document.evaluate(exp, rootEl, null, XPathResult.UNORDERED_NODE_ITERATOR_TYPE, null) ,result = xresult.iterateNext(); while (result) { ret[ret.length]= result; result = xresult.iterateNext(); } can anyone explain me what is the ret = [],..,... syntax? Initializing array?

  Read the article

• F# constructor syntax - overiding and augmenting new

  - by Benjol

  I have a non-disposable class with Open/Close syntax that I'd like to be able to use, so I'm trying to inherit from it, and work the Open into the new and the Close into Dispose. The second part is ok, but I can't work out how to do the Open: type DisposableOpenCloseClass(openargs) = inherit OpenCloseClass() //do this.Open(openargs) <-- compiler no like interface IDisposable with member this.Dispose() = this.Close() (cf. this question which I asked a long time ago, but I can't join the dots to this one)

  Read the article

• Syntax Highlighter for a Domain Specific Language

  - by Ketan

  Hello Friends I have a DSL for which I intend to create a syntax highlighter for editors like vim, gedit and netbeans. Has anyone tried this before? Many thanks for any directions. Ketan

  Read the article

• SQL Server 2008 > how to get service startup parameter values by query?

  - by Sean Ochoa

  Is it possible to query for the SQL Server 2008 service startup parameter values using T-SQL? I'm specifically looking for the -g parameter that indicates how much memory that SQL Server will leave available for memory allocations within the SQL Server process, but outside the SQL Server memory pool [msdn reference].

  Read the article

• Switch case in where clause (sql server)

  - by user685565

  I want to use case in sql statement where clause but I have a problem as I want to create a where clause condition on the basis of some value and I want to set a not in clause values on the basis of it here is the query where am facing an issue WHERE CODE = 'x' and ID not in ( case when 'app'='A' then '570','592' when 'Q' then ID 592,90 else 592,90 END but its not syntax

  Read the article

• MS SQL Server stored procedure meaning

  - by den-javamaniac

  Hi. I'm developing a simple database architecture in VisualParadigm and lately ran over next code excerpt. IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'getType') AND type in (N'P', N'PC')) DROP PROCEDURE getType; Next goes my stored procedure: CREATE PROCEDURE getType @typeId int AS SELECT * FROM type t WHERE t.type_id = @typeId; Can anyone explain what does it mean? P.S.: It would be great, if you may also check for any syntax errors as I'm totally new to MSSQL and stored procedures.

  Read the article

• What is tagged structure initialization syntax?

  - by httpinterpret

  struct file_operations scull_fops = { .owner = THIS_MODULE, .llseek = scull_llseek, .read = scull_read, .write = scull_write, .ioctl = scull_ioctl, .open = scull_open, .release = scull_release, }; This declaration uses the standard C tagged structure initialization syntax. Can someone elaborate?

  Read the article

• groovy while loop syntax assigning and checking a variable

  - by Jeff Storey

  I was reading a blog post and saw a groovy snippet that looked lik while ( entry = inputStream.nextEntry ) { // do something } In the while loop, is this groovy syntax that will cause the loop to break when entry is null?

  Read the article

• Syntax proposition: readability of templated type declarations

  - by Knowing me knowing you

  I wonder if syntax as follows would be helpful in your opinion as a code readability improvent and self-commenting of code: std::map<std::string name, std::vector<int> scores> myMap; In this example it clearly says and no other comment is needed, what for we are using myMap variable. Looking forward to your opinions.

  Read the article

• C++: Syntax error C2061: Unexpected identifier

  - by Rosarch

  What's wrong with this line of code? bar foo(vector<odp> ftw); It produces error C2061: syntax error: identifier 'vector'

  Read the article

• Syntax highlighting Abbreviations

  - by Nimbuz

  I'm using Google prettify for syntax highlighting and I'd like to modify the colors to match my website theme, but I don't understand some of the abbreviations from these: str = string atw kwd = keyword tag = tag com = comment typ = type? atn dec = declaration? lit pun = punctuation? like colons, braces? pln prettyprint

  Read the article

< Previous Page | 99 100 101 102 103 104 105 106 107 108 109 110  | Next Page >