Search Results

Search found 27337 results on 1094 pages for 't sql'.

Page 906/1094 | < Previous Page | 902 903 904 905 906 907 908 909 910 911 912 913  | Next Page >

• JBoss JDBC warning - "Unable to fill pool"

  - by Marcus

  We're getting this random warning from JBoss.. any idea why? It happens at random times when there are no active threads. Everything works when any processing resumes. 13:49:31,764 WARN [JBossManagedConnectionPool] [ ] Unable to fill pool org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Listener ref used the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack The Connection descriptor used by the client was: //localhost:1521/orcl

  Read the article

• Matrix Transpose TSQL

  - by rmdussa

  Can we do matrix transpose (rows become columns and columns become rows) in standard SQL? 1 2 3 4 5 4 5 6 6 7 7 8 9 8 9 1 3 4 5 6 2 4 5 6 7 changes to 1 4 7 1 2 2 5 8 3 4 3 6 9 5 6 4 6 8 5 6 5 7 9 6 7 how about no of rows < no of column ? let's consider the no of rows it's fixed.

  Read the article

• Casting data in gridview control

  - by boraer

  my gridview data source is a list which takes datas from database but my sql command includes inner join and cannot cast the data and the gridview string like this OptikBOLayer.Exams but it can be string

  Read the article

• Caching and cache invalidation in user controls?

  - by Rishabh Ohri

  HI, In our .aspx pages we have many user controls. each user control executes a sql query. The caching mechanism to be followed is to fragment cache each user control on the page and add the query dependency to the respective queries of the user controls. How to achieve query dependency on fragment cached data for invalidation?

  Read the article

• id autoincrement/sequence emulation with CassandraDB/MongoDB etc

  - by abovesun

  Hi, I'm trying to build small web-system (url shortcutting) using nonsql Cassandra DB, the problem I stack is id auto generation. Did someone already stack with this problem? Thanks. P.S. UUID not works for me, I do need to use ALL numbers from 0 to Long.MAX_VALUE (java). so I do need something that exactly works like sql sequence

  Read the article

• Doctrine DQL execute passing params

  - by Karim web Developer

  I used this DQL in Doctrine $q->update('product') ->set('quantity','?') ->where('id=?'); $q->execute(array(20,5)); I check the server for the query and this the generated sql UPDATE product SET quantity = '20', updated_at = '5' WHERE (id = '2010-04-26 14:34); So I need to know why the arguments aren't in the correct places?

  Read the article

• PDO Parameterized Query - Reuse named placeholders?

  - by gamers2000

  In essence, I have a value that I have to call a couple times in my SQL query. Thus, is it possible to reuse the same named placeholder in the statement e.g. SELECT :Param FROM Table WHERE Column = :Param, then simply bindValue(":Param"), and have the value be there for both :Params?

  Read the article

• How to handle input and parameter validation between layers?

  - by developr

  If I have a 3 layer web forms application that takes user input, I know I can validate that input using validation controls in the presentation layer. Should I also validate in the business and data layers as well to protect against SQL injection and also issues? What validations should go in each layer? Another example would be passing a ID to return a record. Should the data layer ensure that the id is valid or should that happen in BLL / UI?

  Read the article

• Lazy Loading wpf Combobox items

  - by Chris McGrath

  I have an IEnumerable< which lazy loads it's data. I want to just set a Combobox's ItemsSource to the IEnumerable, but when I do it goes and loads all the data anyway (which removes the point of lazy loading). I've tried it with Linq-To-Sql as well since it seems to be a similar theory and it also loads all the data. Is there an easy way to do this?

  Read the article

• How to do a join of 3 files with awk by first Column?

  - by noinflection

  i have three similar files, they are all like this: ID1 Value1a ID2 Value2a . . . IDN Value2n and i want an output like this ID1 Value1a Value1b Value1c ID2 Value2a Value2b Value2c ..... IDN ValueNa ValueNb ValueNc Looking to the first line i want value1A to be the value of id1 in fileA, value1B the value of id1 in fileB, etc, i think of it like a nice sql join. I've tried several things but none of them where even close.

  Read the article

• When we say dbms is it files?

  - by PrithviRaj

  Hi all, when we say rdbms that means it may be oracle, my sql, ms access etc.. But for dbms what are the examples. Is there any example or it just the concept?.

  Read the article

• linq where clause not in select statement

  - by Annie

  Can someone help me to convert from SQL Query to LINQ VB.NET: select rls.* from Roles rls(nolock) where rls.id not in ( select r.ID from usersRole ur (nolock) inner join Roles r(nolock) on ur.RoleID = r.ID where user_id = 'NY1772') Thanks

  Read the article

• Handling national language prefix for checkconstraints

  - by Chris Chilvers

  I'm trying to create a check constraint such as CHECK Type IN (N'Create', N'Remove') for an enumeration's value. Sqlite complains about this syntax and only accepts CHECK Type IN ('Create', 'Remove'). The main database will be Sql Server 2005, but I use sqlite's in memory database for unit tests. Is there any way to get sqlite to recognise the national language (N) prefix? Alternatively, is there an easy way when using FluentNHibernate to adapt an nvarchar constant to match the database's dialect?

  Read the article

• Need to replace HTML single-quote entity in MySQL

  - by modulaaron

  Hi, I currently have the following MySQL statement to replace the HTML entity for a single quote with an actual single quote: update photo_galleries replace(title, '&#39;', '\''); This statement returns an error. I have tried adding additional backslashes, but this does not help at all. I want to run this command using pure SQL (no PHP, etc.). Any suggestions are welcome and appreciated. Thanks.

  Read the article

• Performance Related features for migration from .net 2003 Framework 1.1 to .net 2008 framework 3.5?

  - by KuldipMCA

  I am work on VB.net 2003 Framework 1.1 for last 3.5 years in windows Application. We are currently migrating to VB.net 2008 framework 3.5, but i don't know about the features which related to ADO.net and which is important to performance. I know linq to SQL but our architecture is made in .net 2003 so we should follow this. Any features which is very important to enhance the performance?

  Read the article

• Web Data controls

  - by Nani

  Hi, I need to implement Grouping, Sorting, Collapsable for a sql datasource. I shouldn't use third party tools. From last 2 days I was searching net, but dint got the solution. Plz help me in getting these functionalities using any kind of web data control(grid view, repeater, ..) Thank You

  Read the article

• mysql real escape string error

  - by user547995

  Code mysql_query("INSERT INTO Account(User, Pw, email) VALUES('mysql_real_escape_string($_POST[user])', '$pw','mysql_real_escape_string($_POST[email]) ) ") or die(mysql_error()); Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''mysql_real_escape_string(123) )' at line 1 Please help

  Read the article

• Linq Query with aggregate function

  - by Billy Logan

  Hello everyone, I am trying to figure out how to go about writing a linq query to perform an aggregate like the sql query below: select d.ID, d.FIRST_NAME, d.LAST_NAME, count(s.id) as design_count from tbldesigner d inner join TBLDESIGN s on d.ID = s.DESIGNER_ID where s.COMPLETED = 1 and d.ACTIVE = 1 group by d.ID, d.FIRST_NAME, d.LAST_NAME Having COUNT(s.id) > 0 If this is even possible with a linq query could somebody please provide me with an example. Thanks in Advance, Billy

  Read the article

• Mysql Groupby and Orderby problem

  - by luvboy

  Here is my data structure when i try this sql select rec_id, customer_id, dc_number, balance from payments where customer_id='IHS050018' group by dc_number order by rec_id desc; something is wrong somewhere, idk I need rec_id customer_id dc_number balance 2 IHS050018 DC3 -1 3 IHS050018 52 600 Thanx

  Read the article

• Restore Oracle XE data from *.DBF

  - by asero

  Is it possible to restore oracle database from *.DBF files? If yes, then how? I really find it hard to deal with backup and restore things in Oracle compared to SQL Server. I have a backup of the whole oraclexe folder including these files.

  Read the article

• Creating a file based on the byte() in VB.net

  - by acadia

  Hello, I am retrieving an image from the SQL database into Byte() variable in vb.net Dim img as byte()=dr(0) How do I create a file in my C:\images\ directory from the above img. I want to read the img and then create a file with name bimage.gif Please help

  Read the article

• "Select NOT IN" clause in Linq to Entities

  - by lnetanel

  Hi, Is there a way to use the "NOT IN (select XXX...)" clause in Linq to Entities? All the questions I found were regarding a list of objects (IN (1,2,3)) but I want to generate a query with the following syntax: "select * from table1 where field1 not in(select subfield from subtable)" Be aware that this is Linq to Entities and not Linq to Sql... Is it possible? Thanks!

  Read the article

• List of Lua derived VMs and Languages

  - by Shane Holloway

  Is there a compendium of virtual machines and languages derived or inspired by Lua? By derived, I mean usage beyond embedding and extending with modules. I'm wanting to research the Lua technology tree, and am looking for our combined knowledge of what already exists. Current List: Bright - A C-like Lua Derivative http://bluedino.net/luapix/Bright.pdf Agena - An Algol68/SQL like Lua Derivative http://agena.sourceforge.net/ LuaJIT - A (very impressive) JIT for Lua http://luajit.org MetaLua - An ML-style language extension http://metalua.luaforge.net/

  Read the article

• LINQ Equivalent for Standard Deviation

  - by Steven

  Does LINQ model the aggregate SQL function STDDEV() (standard deviation)? If not, what is the simplest / best-practices way to calculate it? Example: SELECT test_id, AVERAGE(result) avg, STDDEV(result) std FROM tests GROUP BY test_id

  Read the article

• How do I calculate the week number given a date?

  - by GH

  If I have a date, how do I calculate the week number for that date within that year? For example, in 2008, January 1st to January 6th are in week 1 and January 7th to the 13th are in week 2, so if my date was January 10th 2008, my week number would be 2. An algorithm would be great to get me started and sample code would also help - I'm developing in C++ on Windows. Related: Getting week number off a date in MS SQL Server 2005?

  Read the article

< Previous Page | 902 903 904 905 906 907 908 909 910 911 912 913  | Next Page >