Search Results

Search found 31293 results on 1252 pages for 'database agnostic'.

Page 802/1252 | < Previous Page | 798 799 800 801 802 803 804 805 806 807 808 809  | Next Page >

• What is the preferred method of refreshing a combo box when the data changes?

  - by Craig Johnston

  What is the preferred method of refreshing a combo box when the data changes? If a form is open and the combo box data is already loaded, how do you refresh the contents of the combo box without the form having to be closed and reloaded? Do you have to do something on the Click event on the combo box? This would seem to be a potential slow down for the app if there is a hit to the database every time someone clicks on a combo box.

  Read the article

• Long time to load first sql connection in C# .NET

  - by Shrage Smilowitz

  For some reason it takes 7 seconds to open a connection to a sql server database for the firt time, subsequent connections takes a second. any idea what could be the reason? I'm using C# and asp.net

  Read the article

• Are Multi-column Primary Keys in MySQL a optimisation problem?

  - by David

  Been looking into using multi-column primary keys and as performance is extremely important with the size of traffic and database I need to know if there is anything to consider before I start throwing out the unique ID method on many of my tables and start using mulit column primary keys. So, what are the performance/optimisation pros/cons to using multi column primary keys versus a basic single column, auto-inc primary key?

  Read the article

• How do sites look up addresses from UK postcodes?

  - by ctford

  U.K. that require addresses often ask the user to provide a postcode. The site then offers the user a choice between the addresses that match that postcode. Where do these sites get the data to do this? Are there webservices that match postcodes to addresses? Do sites buy a database of addresses that they then query locally?

  Read the article

• Object Pooling managment algorithm.

  - by Talha Bin Shakir

  Hi, Anyone can help me to write an algorithm for object pooling. I am very new in J2EE and i need object pooling for database connection. So please help out. Thanks

  Read the article

• SQL Compact - Hang on invalid file

  - by eWolf

  I use Linq to Sql Compact with code generated by sqlmetal. When I open an invalid database, like eg an mp3, I can create the DataContext without getting an Exception. But when I query any data or call DatabaseExists, the application hangs. Why is no exception thrown? Is this a known problem?

  Read the article

• AutoGen DB models for ASP .NET

  - by Tereno

  Hi there, I am wondering if there's anything out there for ASP .NET that is similar to Django or Ruby on Rails. Specifically, I'm looking for something that allows me to auto-generate the database models by specifying my classes in the controller and what not. Would I be able to achieve those functionality with IronPython or IronRuby? Thanks!

  Read the article

• how to access oracle storedprocedure from from asp.net mvc +nhibernate

  - by sandeep

  how to call a oracle database storedprocedure from asp.net mvc using nhibernate and how to use sys_refcursor to display a data in view pages give me sample application . thanks

  Read the article

• Creating a MySQL view with an auto-incrementing id column

  - by hmemcpy

  I have a MySQL database from which a view is created. Is is possible to add an auto-incrementing id for each row in the view? I tried CREATE ALGORITHM=UNDEFINED DEFINER=`database_name`@`%` SQL SECURITY DEFINER VIEW `MyView` AS set @i = 0; select @i:=@i+1 as `id` ... but that doesn't work in a View. Sorry, my SQL is weak, any help is appreciated.

  Read the article

• Where does the creation of permissions live in Django?

  - by lazerscience

  I need to do some debugging, because the permissions for one of my models are created wrongly. So I tried to find the piece of code where Django creates the permissions upon syncdb and writes them in the database, but I haven't been successful at all; maybe I just overlooked the right lines of code, but if somebody can point me out the right module / line of code where this happens I'd be very happy!

  Read the article

• Upload file and parse in classic asp

  - by Allen

  Any ideas how this can be done thru pure asp? I have various upload scripts, but they all either save a file to a folder or in a database. I can't seem to modify these examples correctly to put the file in an array. Here's the 2 I'm currently using: http://www.asp101.com/articles/jacob/scriptupload.asp|http://www.pscode.com/vb/scripts/ShowCode.asp?txtCodeId=7361&lngWId=4

  Read the article

• Will a SHA256 hash always have 64 characters?

  - by Sergio Tapia

  I'm setting up my database to receive hashed passwords and not accept plain text. Would I go something like this? create table User( username varchar(20) not null, password varchar(64) not null, );

  Read the article

• insert number of days of year, months, days of month

  - by ml

  How can I insert in a database the number of days of the year and at the same time insert in the same record the month, day of the month, and the day of the week? This is my table: tabela/coluna.Dias_ano(registo 1...365) Year:=StrToInt(ano.Text); diasano.Text:= IntToStr( DaysInAYear(Year) ); diasAno| Mes |diames |dia semana | 1 | janeiro | 1 |Segunda | 2 | janeiro | 2 | Terça | ... 365 | Dezembro | 31 | Segunda

  Read the article

• How to Use Accordian Control in GridView

  - by Khilen

  i have Category & subCategory Detail i want that in Header of Accordion i can get Category Detail and when click on that related subcategory is displayed but i am retrieving data from database and even the subcateogry will contain a gridview so please give me example how to make such

  Read the article

• How to create Chat application using Servlets & JSP

  - by Crazy boy

  I want to create chat application using Servlets & JSP. May I know how can I create chat application as I have never created before? How much knowledge I need to have to create chat application? Is there any need of networking API to create chat application? What's the design pattern I need to follow to create that application? Is there any need of database?

  Read the article

• Recovering From An SQL Injection

  - by Bryan

  Let's not go so far as to say that I'm paranoid, but I've been spending hour after hour learning how to prevent SQL injections (and XSS for what it's worth). What I'm wondering is that a SQL injection doesn't seem like it would do permanent harm to my database if I've made daily backups. Doesn't importing yesterday's copy of my tables just restore them and then I can be on my merry way?

  Read the article

• Business Objects: Refresh Data problem with .NET API

  - by jlrolin

  I'm currently using the BO API for .NET to connect to our reports database. In .NET, I'm getting the following error: Your security profile does not include permission to refresh Web Intelligence documents. (WIS 30253) Interestingly enough, I can log into BO, and I can refresh the data and grab prompts as I'm logged in. From .NET, with the same username and password, I can't seem to do so. Anybody have any thoughts on this?

  Read the article

• Will performance of a SQL server degrade if the DB can't fit in the memory?

  - by Carl Hörberg

  Will the performance of a SQL server drastically degrade if the database is bigger than the RAM? Or does only the index have to fit in the memory? I know this is complex, but as a rule of thumb?

  Read the article

• What is the best way to create a form for editing a model attribute which is an array of strings in

  - by foggedin

  Take a model with an attribute that is an array of strings. This attribute is serialized to the database. class MyModel < ActiveRecord::Base serialize :str_array end In the edit view I would like to display a text field for each element of the array allowing the user to view and modify the attributes elements.

  Read the article

• Log all queries in mysql

  - by public static

  Hi, Is it possible for me to turn on audit logging on my mysql database? I basically want to monitor all queries for an hour, and dump the log to a file.

  Read the article

• Hibernate/Lucene/HibernateSearch: find all words that start with specific prefix.

  - by Giuseppe

  I want to get a list of all words in a database table that start with a specific prefix. I've been looking for a way to query the terms in a Lucene index (I need the terms, I don't care about the documents they are from) but without success. Any ideas?

  Read the article

• Frequent error in Oracle ORA-04068: existing state of packages has been discarded

  - by martilyo

  Hi, We're getting this error once a day on a script that runs every two hours, but at different times of the day. ERROR at line 1: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of package body "PACKAGE.NAME" has been invalidated ORA-06508: PL/SQL: could not find program unit being called: "PACKAGE.NAME" ORA-06512: at line 1 Could someone list what conditions can cause this error so that we could investigate? Thanks. UPDATE: Would executing 'ALTER SESSION CLOSE DATABASE LINK DBLINK' invalidate a state of the package?

  Read the article

• How to get SQL Profiler to monitor trigger execution

  - by firedfly

  I have a trace setup for SQL Server Profiler to monitor SQL that is executed on a database. I recently discovered that trigger execution is not included in the trace. After looking through available events for a trace, I do not see any that look like they would include trigger execution. Does anyone know how to setup a trace to monitor the execution of triggers?

  Read the article

• How to change granted role temporarily to achieve "view the site as" someone else

  - by Roy Chan

  Hi Gurus, We are using 2.x spring security right now. I am asked to build an admin tool so that the ROLE_ADMIN can change to any user in the site and view the site as that person (each person on the site may see different stuff depending on the role which is dynamically granted base on the database) and of course the admin should be able to switch back to admin without logging in. Is there a build in function, if not how should I do this? Thanks in advance!

  Read the article

• Cross browser window close event

  - by slik

  Is there a solution for cross browser event. I need to check if user closes their window and to throw an ajax request to my database to sign them out. I've looked everyone but most cases its not working in all browsers. Anyone have a solution? Or Alternative on how to do this perhaps a conditional statement depending on the browser? Thanks!

  Read the article

< Previous Page | 798 799 800 801 802 803 804 805 806 807 808 809  | Next Page >