Search Results

Search found 33242 results on 1330 pages for 'database optimization'.

Page 844/1330 | < Previous Page | 840 841 842 843 844 845 846 847 848 849 850 851  | Next Page >

• How to retrive image names from a folder in Asp.net VB.

  - by kavitha kulkarni

  hi, i am using telerik editor for uploading images which are getting stored in images folder. now i want to fetch all images and paths from that image folder and save only image name and path in to seperate database table. can i do this in asp.net VB ? please help.

  Read the article

• calculate number of working days on a rails form

  - by ash34

  I have two fields, 'from_date' and 'to_date' on my rails form. When a user enters the dates I have to display the number of working days i.e, exclude (sat, sun and a list of other official holidays in a database table). Is this something that should be done in the client side javascript Or is this something that should be done by making an ajax request to rails. Can you tell me how I can accomplish this. thanks much.

  Read the article

• Class model for a many-to-many relationship, where relationship has attributes

  - by Greg

  Hi, What would the basic C# code look like to model a many-to-many relationship, where the relationship itself has attributes? And also in this case the many-to-many was referential. So a possible database model for this might look like the following (just to give an example of what I'm talking about) Nodes ID Name Description Relationships Parent_ID Child_ID Relationships_Type

  Read the article

• iPhone - Merge keys in a NSArray (Objective-C)

  - by ncohen

  Hi everyone, I'm having troubles with arrays and keys... I have an array from my database: NSArray *elementArray = [[[menuArray valueForKey:@"meals"] valueForKey:@"recipe"] valueForKey:@"elements"] The problem here is that I would like all my elements of all my meals of all my menus in an array such that: [elementArray objectAtIndex:0] = my first element etc... In the example above, the elements are separated by the keys. How can I get that? Hope it's clear enough... Thanks

  Read the article

• Decent simple SQL Server client

  - by John

  Hi, does anyone know of a very simple SQL Server client tool - that does the same basic functions as Management Studio (i.e. choose a database and run a query - doesn't need an Object Explorer, or anything fancy)? Ideally it would be great to have a single exe or zip file version that I could take around on a USB key - anything to avoid installing the full set of SQL Server client tools all the time! Thanks, John

  Read the article

• Migrating From SQL Server Server 7 To 2005, What should I get excited about?

  - by Jon P

  The company I work for has decided to join the 21st century and upgrade our main database cluster from SQL Server 7 to SQL Server 2005. As a web developer what new whiz-bang features of SQL Server 2005 should I get excited about or get to know? Currently I'm mainly writing CRUD style queries, pretty much exclusively using Stored Procdures for a mixed ASP.net and Classic ASP environment.

  Read the article

• Configuring Quercus to talk to JavaDB

  - by Dan Williams

  I am trying to get the Quercus PHP engine to connect with the JavaDB. I have successfully deployed Quercus in Glassfish, but I can't get Quercus to successfully connect with my database in JavaDB. Can anyone point me to an article or tutorial that treats this subject?

  Read the article

• Oracle enterprise manager java.lang.Exception

  - by folone

  After creating a db using Database Configuration Assistant, I go to Enterprise Manager, log into it, and it tells me, that java.lang.Exception: Exception in sending Request :: null. OracleDBConsole for this db, and iSQLPlus services are started. When I run %ORACLE_HOME%\bin\emctl status dbconsole, it says, EM Daemon is not running. How do I deal with this?

  Read the article

• Get IP Address Information such as Country, LatLong, City using Google Maps Data API

  - by Nullstr1ng

  Can I use Google Maps Data API to get the IP Address informations such as Country, LatLong, City, etc. The result will be in JSON or XML format that I can parse through C#. Is there any C# Library for Google Maps Data API? I found this interesting site http://www.ipinfodb.com/ip_location_api_json.php this guys even offer their IP address location database http://ipinfodb.com/ip_database.php

  Read the article

• How to get Locale from its String representation in Java?

  - by Joonas Pulakka

  Is there a neat way of getting a Locale instance from its "programmatic name" as returned by Locale's toString() method? An obvious and ugly solution would be parsing the String and then constructing a new Locale instance according to that, but maybe there's a better way / ready solution for that? The need is that I want to store some locale specific settings in a SQL database, including Locales themselves, but it would be ugly to use serialized Locale objects there. I would rather store their String representations, which seem to be quite adequate in detail.

  Read the article

• Error- The SQLNCLI provider is not registered on the local machine.

  - by superartsy

  I get the above error in one of my apps. However there is no reference to using the SQLNCLI provider. I know before the ConnectionString had "Provider=SQLNCLI".However now its changed to "Provider=SQLOLEDB" (using OLEDB since the same app connects to Access and SQL database). Why then do I still get the error?

  Read the article

• MySql claims table doesn't exist when it should exist

  - by annelie

  Hello, I'm having trouble (again) connecting to a MySql database from the server (using Devart). It works from my local machine, but on the server it says 'Table 'tp.property' doesn't exist'. The table is there, so why does it think it's not? Thanks, Annelie

  Read the article

• Convert SQLExpress 2005 .mdf to 2008 .mdf ?

  - by Pricey

  Hi I have a Visual Studio solution and an ASP.NET MVC project that uses an mdf sql express 2005 database file in the App_Data. I want to know how I can upgrade this file so it works for sql express 2008 ? Thanks

  Read the article

• how to hash a password?

  - by 5YrsLaterDBA

  My next task will be encrypt password. I am working at the database access layer and my co-work has this comment, implement SHA512 hash, on an empty method which I will implement it. any recommendation about this? thanks

  Read the article

• Why is it a bad practice to pass structs by reference?

  - by Fraga

  I usually save serialized structs to my database!. So I pass them by reference a lot!. Is that a bad practice?

  Read the article

• Ruby on Rails 2.3.5: update_all failing on ActiveRecord

  - by randombits

  I'm trying to update a collection of records in my database using ActiveRecord's update_all. Enter script/console. MyModel.update_all("reserved = 1", :limit => 1000) ActiveRecord thinks limit is a column, says it's unknown and throws an exception. According to the documentation though, my syntax looks sane. This is RoR 2.3.5. When doing MyModel.update_all("reserved = 1") alone, it works just fine.

  Read the article

• SQL Rounding Problems in 2005 and 2000

  - by azamsharp

  I have a value in the database which is 2.700000002. When I run a query in Management studio in SQL SERVER 2005 I get 2.7. But when I run in SQL SERVER 2000 query analyzer it comes 2.700000002. 2.70000002 is correct why is SQL SERVER 2005 trying to change the value by rounding it or selecting the floor value?

  Read the article

• How to call a .NET web service with Kerberos (or NTLM) authentication from Oracle PL/SQL

  - by Niklas

  We are calling a .NET web service from our oracle database using the sys.utl_http package. We have also tested with the sys.utl_dbws package. This works fine when there is no security on the .NET web service. However, we would like to use sys.utl_http or sys.utl_dbws to call a .NET web service with Kerberos or NTLM authentication. We're currently struggling with this. Any hints on how to solve it?

  Read the article

• In Django Combobox choices, how do you lookup description from short value?

  - by MikeN

  In Django models/forms the choices for a combobox often look like this: food_choices = (("",""), ("1", "Falafel"), ("2", "Hummus"), ("3", "Eggplant Stuff, Babaganoush???"), So the value to be stored in the database will be 1/2/3, but the displayed value on the form will be the long description. When we are working in code outside a form, how can we quickly lookup the long description given the short value stored in the model? So I want to map short values to long values: print foo("1") "Falafel"

  Read the article

• Build ATOM Feed Reader for ADO.net DATA Services feed

  - by khalil

  Hi, I have built an ADO.net data services to expose data in a SQL server database as XML. What I want to be able to do is create a feed reader for this ATOM feed in .net or may be a user control which subscribes to this URI based ATOM Feed from ADO.net data service & publishes the latest information on our website

  Read the article

• Store username and password persistent in windows mobile(6.0) app

  - by Stefan

  Hi I need some help developing my mobile app. I have to store user data permant (name, password), so what is the best way to do that? I dont know a special API for it, so where to store persistent data's on a windows phone? Maybe in the win mobile registry or inside a file? Or should I use a light database? Someone has experience with this? thx, Stefan

  Read the article

• DDD: Can I have my persistence layer object implement an interface that uses enum, with implicit con

  - by Maslow

  I have a domain interface public interface ITicket { ... TicketWorkflowStatus StatusId{get;set;} // Enum } but the linq-to-sql persistance layer on the database wants to use int, can I change it in the dbml so that the local type is TicketWorkflowStatus? What are my options?

  Read the article

• Implementing EAV pattern with Hibernate for User -> Settings relationship

  - by Trevor

  I'm trying to setup a simple EAV pattern in my web app using Java/Spring MVC and Hibernate. I can't seem to figure out the magic behind the hibernate XML setup for this scenario. My database table "SETUP" has three columns: user_id (FK) setup_item setup_value The database composite key is made up of user_id | setup_item Here's the Setup.java class: public class Setup implements CommonFormElements, Serializable { private Map data = new HashMap(); private String saveAction; private Integer speciesNamingList; private User user; Logger log = LoggerFactory.getLogger(Setup.class); public String getSaveAction() { return saveAction; } public void setSaveAction(String action) { this.saveAction = action; } public User getUser() { return user; } public void setUser(User user) { this.user = user; } public Integer getSpeciesNamingList() { return speciesNamingList; } public void setSpeciesNamingList(Integer speciesNamingList) { this.speciesNamingList = speciesNamingList; } public Map getData() { return data; } public void setData(Map data) { this.data = data; } } My problem with the Hibernate setup, is that I can't seem to figure out how to map out the fact that a foreign key and the key of a map will construct the composite key of the table... this is due to a lack of experience using Hibernate. Here's my initial attempt at getting this to work: <composite-id> <key-many-to-one foreign-key="id" name="user" column="user_id" class="Business.User"> <meta attribute="use-in-equals">true</meta> </key-many-to-one> </composite-id> <map lazy="false" name="data" table="setup"> <key column="user_id" property-ref="user"/> <composite-map-key class="Command.Setup"> <key-property name="data" column="setup_item" type="string"/> </composite-map-key> <element column="setup_value" not-null="true" type="string"/> </map> Any insight into how to properly map this common scenario would be most appreciated!

  Read the article

• .Net CMS with API to expose content

  - by Peter

  I am looking for a .Net CMS that allows me to expose pages/articles that are created in the CMS to other applications without querying the CMS database. Preferably this would be done through an API and by exposing them through a custom secured webservice. I know Sitefinity can do this. Do you know if Umbraco DotNetNuke can do this? If yes, a link to some documentation of the API is appreciated!

  Read the article

• Freely available dictionary data for Chinese, Japanese, CJK characters

  - by devio

  I am developing an online CJK character dictionary application, and already found the following databases: Unicode Unihan Database Jim Breen's JMDict and KanjiDic CEDict HanDeDict As I am looking for more data, web searches often lead me to online dictionaries, but not the data itself, using the same sources over again. If you know of any CJK-relevant downloadable dictionaries, please add them.

  Read the article

< Previous Page | 840 841 842 843 844 845 846 847 848 849 850 851  | Next Page >