Search Results

Search found 30217 results on 1209 pages for 'database'.

Page 730/1209 | < Previous Page | 726 727 728 729 730 731 732 733 734 735 736 737  | Next Page >

• sql server - sum Comma seperated value from a column

  - by Aseem Gautam

  There is a column in database which contains comma seperated values like: 0.00,12.45,14.33 and so on. I need to sum this inside a stored procedure. One way which I can think of is to split and convert it into a table using a function and then sum it. Any other ideas?

  Read the article

• SQL Server online backup with MozyPro

  - by Erick Sasse

  Anyone using MozyPro to backup SQL Server databases? I'm concerned about the way it does the backup. It just copies data files the way they are. Not using the backup database command. Is it safe?

  Read the article

• Ruby on Rails: How to get ActiveRecord to show the next id (last + 1)?

  - by randombits

  Is there a compact way with ActiveRecord to query for what id it's going to use next if an object was going to be persisted to the database? In SQL a query like this would look something like: SELECT max(id) + 1 FROM some_table;

  Read the article

• use Data Annotation to my Linq to SQL

  - by Khalid Omar

  i have a mvc web project and i'm using linq to sql i'm using dataannotaion like this public class ClientValidation { [Required] public string name1st { get; set; } } then in the linq class i add that above client class [global::System.Data.Linq.Mapping.TableAttribute(Name = "dbo.Client")] [MetadataType(typeof(ClientValidation))] public…

  Read the article

• Wordpress databse insert() and update() - using NULL values

  - by pygorex1

  Wordpress ships with the wpdb class which handles CRUD operations. The two methods of this class that I'm interested in are the insert() (the C in CRUD) and update() (the U in CRUD). A problem arises when I want to insert a NULL into a mysql database column - the wpdb class escapes PHP null variables to empty strings. How can I tell Wordpress to…

  Read the article

• what is the fast way for find data in sqlCE - windows mobile & C#

  - by Gold

  hi what is the fast way to find and data in sqlCE in windows-mobile (C#) ? i have database with 1000000 records. sql query ? .... or data reader ?.....or wat ?? thank's in advance

  Read the article

• Timeout expired in sql server problem

  - by Avinash

  set con2=server.CreateObject("ADODB.Connection") con2.ConnectionTimeout =1200 con2.open "Driver={SQL Server};server=111.111.111.11;user id=xx;pwd=xxx;Database=xxx" con2.execute("DELETE FROM tablename WHERE fieldid NOT IN(SELECT fieldid FROM tablename2)") con2.close set con2=nothing when i running this query using asp the following error…

  Read the article

• SQL reporting service and language problem

  - by Wasim

  I am encountering a problem when attempting to display Hebrew fonts in SQL Server Reporting Services. I see the fonts perfectly in the database, but when displaying the report all the Hebrew fonts displayed as ????? Any suggestions?

  Read the article

• Support for schema migrations with JPA?

  - by Brabster

  I've been briefly looking at JPA recently, and I was wondering what the deal is with database schema migrations and staying lined up with the classes you've created. Is there support in JPA for this stuff? Utilities? Best Practises? Cheers!

  Read the article

• Cannot populate form with ajax and populate jquery plugin

  - by Azriel_

  I'm trying to populate a form with jquery's populate plugin, but using $.ajax The idea is to retrieve data from my database according to the id in the links (ex of link: get_result_edit.php?id=34), reformulate it to json, return it to my page and fill up the form up with the populate plugin. But somehow i cannot get it to work. Any…

  Read the article

• Tuning MySQL to take advantage of a 4GB VPS

  - by alistair.mp

  Hello, We're running a large site at the moment which has a dedicated VPS for it's database server which is running MySQL and nothing else. At the moment all four CPU cores are running at close to 100% all of the time but the memory usage sticks at around 268MB out of an available 4096MB. I'm wondering what we can do to better…

  Read the article

• Do make indexes containing another index make sense?

  - by Orlando Dilasso

  Given a table (id, col1, col2), does it make sense to create the following indexes: Index1 (col1) not unique Index2 (col1, col2) not unique I am faced with a legacy database that is full of those. Can I safely delete Index1? Anwser needed for SQL Server and Oracle.

  Read the article

• How to fill a GridView with values manually?

  - by user304018

  using two text box, Enter some value in that box and then click add button it should be added in the gridview,and then am continue adding one by one in the girdview...without using any database

  Read the article

• glitchy access website, freezes for 30-60 sec intermittently

  - by afroboy

  asp website with access database freezes for 30-60 seconds intermittently. The site is on an internal 2008 server. About 25 users access the site simultaneously. Is it just the limits of access or can i do something to improve the situation? change any timeout/refresh settings anywhere? or could it be a problem with the…

  Read the article

• Using a lemmatizer in ruby

  - by Shreyas Satish

  I have tried using a stemmer but the words it produces are just not upto the mark. It could be great if you could let me know any lemmatizer script there exists for ruby or a lemmatizer gem or an SQL query that bundles out the lemma of a word in the wordnet database. Cheers !

  Read the article

• Android horizontal scrolling showing Cursor data

  - by androidharry

  I have some text data in database which I have retrieved in a Cursor, and I am displaying it in a ListView. What I want to do now is that when you select click a particular row in the list its text content should be displayed in full screen and the user should be able to scroll horizontally (like scrolling between…

  Read the article

• SSIS flat file insertion failure to rollback

  - by Pramodtech

  I have simple SSIS package which reads data from flat file and insert into SQL database. The file has 90K rows and sometimes because of bad data package fails but it insert the partial records before it fails. What I need is if insertion fails at any time between, no records should be inserted into DB, rollback…

  Read the article

• "'" is displayed as u0027 in facebook app - how to fix that?

  - by Imageree

  I have a facebook app that is displaying random quotes - it is written in php. One quote in the database looks like this: "There's only one rule in photography - never develop colour film in chicken noodle soup. - Freeman Patterson" When it is seen on facebook it looks like this: "Thereu0027s only one rule…

  Read the article

• How to link ms excel 2003 to ms access 2003

  - by Terry

  I have office 2003, and i have develop a database from ms access 2003. What i want is to link ms excel and ms access so as when am updating either of them both will be updated

  Read the article

• Is there an easy way to verify that a server exists on a network with VBScript?

  - by Michael Beck

  Hey, I have the eventual goal of determining that a particular database on a particular server with particular credentials is running, but I would settle, at this point, for the ability to check and see if a server is actually up on the network. Does anyone have a way of doing this? I seem to be drawing a…

  Read the article

• svg diagrams using python

  - by Zitrax

  I am looking for a library to generate svg diagrams in python (I fetch data from a sql database). I have found python-gd, but it has not much documentation and last update was in 2005 so I wonder if there are any other libraries that are good for this purpose. I am mostly thinking about simple line graphs,…

  Read the article

• Is Zend Framework a total waste of my time?

  - by Citizen

  Ok, I'm about 50% done with the "30 minute" quickstart guide from Zend. I must be missing something, because this seems like a total waste of time. The point of this quickguide is to create a guestbook, something I could do in 5 minutes with regular naked non-framework php. Here's my path to zend…

  Read the article

• RowFilter including [ character in search string

  - by JeffC

  I fill a DataSet and allow the user to enter a search string. Instead of hitting the database again, I set the RowFilter to display the selected data. When the user enters a square bracket ( "[" ) I get an error "Error in Like Operator". I know there is a list of characters that need prefixed…

  Read the article

• Spring Security: Authentication returns null

  - by Mike

  Hi! I implemented FilterInvocationSecurityMetadataSource. in getAttribute, i am trying to extract the Authentication object to achieve the user and get his allowed views from the database:Object principal = SecurityContextHolder.getContext().getAuthentication().getPrincipal(); but the…

  Read the article

• ASP.NET custom templates, still ASP.NET controls possible?

  - by Sha Le

  Hello: we currently do not use asp.net controls (no web forms). The way we do is: 1 Read HTML file from disk 2 lookup database, parse tags and populate data finally, Response.Write(page.ToString()); here there is no possibility of using asp.net controls. What I am wondering is, if…

  Read the article

< Previous Page | 726 727 728 729 730 731 732 733 734 735 736 737  | Next Page >