Search Results

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

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

• Change MS Access to Exclusive on the fly

  - by Nate

  I have a process in an MS Acess database that the users will usually run once daily, but could be more or less. It takes several minutes and requires temporary exclusive access because it deletes and recreates the main table. I have code to check to see if there are other users in the db before the process starts, but is there a way to change the access to "exclusive" at the beginning, and then change it back to open access at the end? Thanks for any help.

  Read the article

• Transferring Django Model Instances through RPC

  - by live2dream95

  Suppose I have 2 sites that shares a common Model. What would be the best way to transfer a new Model instance created at Site A and save it in Site B's database? Could you please also recommend APIs for sending and receiving the data?

  Read the article

• In php, Prepare string and create XML/RSS Feed

  - by Bill

  I want to create my own RSS/XML feed. I fetch data from the database to display, but keep getting invalid character errors. If the string has an ampersand or other strange characters in it, the XML will be invalid. I tried using urlencode and htmlentities, but these don't capture all possible characters which need to be escaped. Does anyone know of a PHP function which will prepare a string for XML output?

  Read the article

• How to List Some Table Records in Windows Application? - C#.NET

  - by user327387

  Which control should i use? I don't want the records to be displayed on the Windows Application list in the same way records displayed in database as this: I want the records to be displayed statically and a user when right click a record, he/she gets Edit and Remove choices. Of course there has to be static headers at the top. I hope my request is clear. I'm using C#.NET - VS 2008

  Read the article

• Check if a table exists, and if not, create it

  - by Matt

  I'm using a Odbc connection to a mysql server, and was wondering how I would go about checking if a table exists within my database, and if not, create it.

  Read the article

• Negative Primary Keys

  - by bjax

  Are there any repercussions using Negative Primary Keys for tables (Identity Increment -1, Identity Seed -1 in SQL Server 2005)? The reason for this is we're creating a new database to replace an existing one. There are similar tables between the two databases and we'd like the "source" of the information to be transparent to our applications. The approach is to create views that unions tables from both databases. Negative PKs ensures the identities don't overlap.

  Read the article

• The action or event has been blocked by Disabled Mode

  - by mattruma

  I am using Microsoft Access 2007 to move and massage some data between two SQL Servers. Yesterday everything was working correctly, I was able to run queries, update data, and delete data. Today I opened up the Access database to finish my data migration and am now receiving the following message when I try to run some update queries: The action or event has been blocked by Disabled Mode. Any ideas what this is talking about?

  Read the article

• functional test for rails controller privaet method

  - by mohit

  I have a private method in my controller. which is used for some database update. this method i am calling from another controller method. and it works fine. But when i am trying to write a test case for that method then It is tripping on accessing (session variable and params) in my functional all other methods are working fine the problem is only with private method? In my setup method in functional test, I am setting session also.?

  Read the article

• Communicating with remote server in Android

  - by primal

  Hi, As part of the college mini-project, I am developing a micro-blogging platform for Android. I am planning to use Django framework in python to handle the communication between Android and remote server so as to make database API independent. I heard its best practice to use HTTP methods for the communication. Which is the best site/book to learn using HTTP methods for Android? I

  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

• cx_Oracle and output variables

  - by Tim

  I'm trying to do this again an Oracle 10 database: cursor = connection.cursor() lOutput = cursor.var(cx_Oracle.STRING) cursor.execute(""" BEGIN %(out)s := 'N'; END;""", {'out' : lOutput}) print lOutput.value but I'm getting DatabaseError: ORA-01036: illegal variable name/number Is it possible to define PL/SQL blocks in cx_Oracle this way?

  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

• 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

• iphone storing password locally and sending it across to a server securely

  - by amarsh-anand

  I am writing an iPhone app which will start with asking the user to register with a login/passwd. These should be : Saved securely locally Send securely to a remote web-server What do I need to achieve the above? Say, for local storage, shall I save them in a file or database? Shall I encrypt it? For sending it over, is HTTPS sufficient?

  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

• Messaging problems

  - by Luke

  I am creating a messaging system but the problem I face is that when users try and enter certain characters like ' into the message, the database doesnt want to allow it. Any idea what this is?

  Read the article

• Auto refresh when new user comes online

  - by Luke

  Hello. I have a table in the database which includes all active users. I then have a user list which needs refreshing to see who is the latest users online. Whats the best way to tackle this? The user list is always just who is in the active_users table. Thanks for reading.

  Read the article

• Can I get a percentage of the phones that would support a J2ME Midlet application given all the JSR

  - by Dumb Questioner

  Can I get somehow(from a database or other source) a percentage of the phones that would support a J2ME Midlet application given all the JSR's it uses ?

  Read the article

• Datanucleus JDO Retrieve newly generated primary key

  - by DrDro

  I am using datanucleus and jdo in a GWT project. How can I retrieve the generated primary key after adding an element to the database with makePersistent()

  Read the article

• what is wrong with connection string

  - by Hakan

  Can any one help me with this connection string. I can't manage how to fix. Dim constring As String Dim con As SqlCeConnection Dim cmd As SqlCeCommand constring = "(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + \\database.sdf;Password=pswrd;File Mode=shared read" con = New SqlCeConnection() con.Open() Thanks

  Read the article

• ADO.NET Entity Framework record count

  - by Ravi

  Hi, I have stored some records in to database using ADO.NET Entity Framework. I want to know total record count in particular table using ADO.NET Entity Framework in C#.Net . Thanks

  Read the article

• When it comes to updating all rows in a table, does the method of locking matter for performance?

  - by Evan Carroll

  Question is a follow up to this. The SQL in question was UPDATE stats SET visits = (visits+1) And the question is, for the purpose of performance, does it matter if you lock all rows in stats in comparison to locking the table stats? Or, if the database uses a page-lock rather than a table/row lock?

  Read the article

• How can I return a whole mysql result set, and one at a time set each row as an array?

  - by RichardHarrington

  foreach($scraperSites as $site) { //$scraperWriter->addSite( new ScraperSite($site) ); print_r($site); } scraperSites is the array of all sites from the mySQL database; I'm trying to keep $site as an array, (but only with one row worth of data), add it to an object, then move on to the next row.

  Read the article

• Restricting Access in ERB code.

  - by LGFaler

  I am trying to build a CMS using ERB. Is there a way you can give ERB code read-only access to your models? For instance, I want to be able to load any information on my models (Model.all, Model.find_by_slug, Model.find_by_name, Model.other_model.name, etc...), but I don't want to be able to change this data. Can you disable ERB from executing commands that would make database changes (Model.save, Model.update, Model.delete, Model.destroy, etc.)???

  Read the article

• where are the svn folders I checked in?

  - by johnny

  Trying to understand something. I created a d:\svn\repository on my server. I committed folders but when I go back to d:\svn\repository I do not see them. Are they all in a database? Will all my repositories go in that main folder and svn tracks them? What if I have two projects? Thank you.

  Read the article

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