Search Results

Search found 32492 results on 1300 pages for 'reporting database'.

Page 879/1300 | < Previous Page | 875 876 877 878 879 880 881 882 883 884 885 886  | Next Page >

• Long time to load first sql connection in .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 Its after compilation, i essence every time i restart the site, which means every time it needs to actualy create the "first" connection. i understand that setting up connection pooling has overhead, but i have never seen that i should take 7 second to set it up.

  Read the article

• ASP.NET MVC image upload store location (db vs filesystem)

  - by adrin

  I am writing web application using ASP.NET MVC + NHibernate + Postres stack. I wonder if images uploaded should be stored in database as binary blobs or on filesystem (and reference only in db). One advantage of db storage I can think of is easy backup/recovery of all data without reverting to filesystem copy tools. On the other hand I suspect that filesystem access may be faster (but is it especially when dealing with many concurrent requests?) What are your suggestions?

  Read the article

• Selecting first records of a type in a given period

  - by Emanuil Rusev

  I have a database table that stores user comments: comments(id, user_id, created_at) I want to get from it the number of users that have commented for the first time in the past week. Here's what I have so far: SELECT COUNT(DISTINCT `user_id`) FROM `comments` WHERE `created_at` BETWEEN DATE_SUB(NOW(), INTERVAL 7 DAY) AND NOW() This would give the number of users that have commented, but it would not take into consideration whether these comments are first for these users.

  Read the article

• Oracle 10g express edition import

  - by Jasim

  How can i import a DMP file into my oracle 10g expression edition database? I tried with imp but its showing an error: IMP-00010: not a valid export file, header failed verification IMP-00000: Import terminated unsuccessfully How can i solve this?

  Read the article

• Efficient way to build a MySQL update query in Python

  - by ensnare

  I have a class variable called attributes which lists the instance variables I want to update in a database: attributes = ['id', 'first_name', 'last_name', 'name', 'name_url', 'email', 'password', 'password_salt', 'picture_id'] Each of the class attributes are updated upon instantiation. I would like to loop through each of the attributes and build a MySQL update query in the form of: UPDATE members SET id = self._id, first_name = self._first name ... Thanks.

  Read the article

• Application crashes while using the scroll bars in winForm Datagrid view

  - by subbu

  Hi all i have a background worker thread and some unmanaged code dlls , In progress changed event of background worker . I will get the data from my database in a datatable and make this table as my DataSource. But when i use the scrollbards od DataGridView my application crashes.when I try to debug the application it gives "Unhandled exception in TestExe.exe : 0xC0000096: Privileged Instruction.

  Read the article

• Right tool for tracking DB structure changes

  - by termopro

  Right now i have a PHP project and i track all changes in code by SVN. I would also like to track changes made in database structure. Which is the right tool to use ?

  Read the article

• Find all the varchar() fields in sql server?

  - by JD

  Hi, Is it possible to find all the varchar() columns in my database? I am using SQL Server 2008 and would like to get the list in SQL server management console. JD.

  Read the article

• byte[] to image android

  - by Sephy

  Hi everybody, My issue is as follows : I have stored a few pictures into the sqlite database, using the blob format, which seems to work ok. now i want to get my pictures out of the DB and put then back into images... to complicate the matter, their format is variable (png, jpg, maybe something else, im not sure) Is there a way of doing so in android? thank you

  Read the article

• Dynamic picture that displays the visitors IP address?

  - by Rob

  I see this a lot now, jpg files displaying your IP address. To you of course, not to others, they would see their own For example: How is this even possible? If this is possible, would it be possible to log an IP into a MySQL database from the picture as well? Is my IP getting logged when I view this?

  Read the article

• Generate T-SQL for Existing Indexes

  - by Chris S

  How do you programmatically generate T-SQL CREATE statements for existing indexes in a database? SQL Studio provides a "Script Index as-Create to" command that generates code in the form: IF NOT EXISTS(SELECT * FROM sys.indexes WHERE name = N'IX_myindex') CREATE NONCLUSTERED INDEX [IX_myindex] ON [dbo].[mytable] ( [my_id] ASC )WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY] GO How would you do this programmatically (ideally through Python)?

  Read the article

• Beautify Integer values for comparing as strings

  - by Zahra

  Hi. For some reason I need to enter my integer values to database as string, then I want to run a query on them and compare those integers as strings. Is there any way to beautify integer numbers (between 1 and 1 US billion as an example) so I can compare them as strings? Thanks in advance.

  Read the article

• PHP ORM's, multiple tables and efficiency

  - by sunwukung

  Let's say I have a data mapper function that aggregates multiple tables and generates an object instance from that data. The mapper has a typical save() method which delegates to update/insert. When the mapper executes save - ideally it isolates object fields that have been modified, thus preventing the code from blanket bombing the database. How would you go about this?

  Read the article

• Professional way to write project documentation

  - by EugeneP

  What tools and standards do you use to describe your project, database, modules, classes, their interaction for programmers, let's say after the project is finished. Do you use UML? Are there enterprise standards for Java developers, how to write such a documentation let's say from SUN? Are there specific tools that simplify this documentation process & compilation of neccessary docs. If there are good books on project documenting process, please give me links to Amazon.

  Read the article

• Taking backup of data in a table.

  - by Rishabh Ohri

  Hi All, Is there some way to backup the data in a table in sql server by using sql scripts. Note: I dont want to take the backup of the whole database. And later on restore the same data back in case of any failure. Please suggest some solution.

  Read the article

• How can i retrieve a jpg image in my WebView in android

  - by Maxood

  I have a jpg image in my resource folder. Now i want it to be displayed in my WebView along with other text in HTML coming from a database field. How can i retrieve/display that jpg image?

  Read the article

• Unserialize data and check it against an id in MySQL

  - by kylex

  I have a row of IDs in a database that has been serialized. What I'm trying to do is check those serialized IDs against a known ID to see if it should be excluded or not. for example: "SELECT * FROM mydb WHERE id = 4 AND checkID != 'an id in the serialized column' " What's the best way to go about this?

  Read the article

• PayPal debit VISA automatically?

  - by Mark

  If I have a Visa card number saved in my database, is there a way I can charge that Visa automatically through the PayPal API without the user having to enter anything? We want to keep this site as easy and hassle-free to use as possible. It would be a variable amount, based on how they use the site. (Don't worry, proper disclaimers will be in place, and the user will be notified)

  Read the article

• Page_Load after Modal Popup

  - by n0chi

  I have a page with a user control which gets some data updated via a modal popup. Upon clicking "ok" on the modal popup - the new data is being written to the database - but the base page doesnt "reload" to show the updated data. How do I get that to happen?

  Read the article

• Stored Queries?

  - by phpeffedup

  Is it considered crazy to store common SQL queries for my web app in a database for use in execution? Or is that common practice? Or is it impossible? My thinking is, this way, I avoid hard-coding SQL into my application files, and add another level of abstraction. Is this crazy? Is this what a stored procedure is? Or is that something else?

  Read the article

• What is Best way to obtain filename for HTML FILE Uploading on forms?

  - by CitadelCSAlum

  I need to obtain the String for the file that is being uploaded from forms to store in the database. I am using the usual form input file element input type="file" name="some_name" I found a couple JS scripts that allow me to do useless things like display the string in a dialog box, etc. I need this as an element on the request object or as a hidden field on my page when the form is posted.

  Read the article

• Java/JSP/Tomcat web hosting

  - by Zaheer Baloch

  Hello guys, I am looking for a hosting solution for my Java/JSP web application. Do you know any servers which provide Tomcat hosting for v5 or greater and MySQL database?

  Read the article

• i m new to sharepoint and confuse, where coding take place in sharepoint application as other norma

  - by girish

  hello, i m new to sharepoint and bit confuse, i don't understand where coding take place in sharepoint as other asp.net application. how it work if i have to create a page for adding record to database.

  Read the article

• How to auto insert the current user when creating an object in django admin?

  - by FurtiveFelon

  Hi all, I have a database of articles with a submitter = models.ForeignKey(User, editable=False) Where User is imported as follows: from django.contrib.auth.models import User. I would like to auto insert the current active user to the submitter field when a particular user submits the article. Anyone have any suggestions?

  Read the article

• removing non ascii characters from a string using python / django

  - by Gaurav

  I have a string of HTML stored in a database. Unfortunately it contains characters such as ® I want to replace these characters by their HTML equivalent, either in the DB itself or using a Find Replace in my Python / Django code. Any suggestions on how I can do this?

  Read the article

< Previous Page | 875 876 877 878 879 880 881 882 883 884 885 886  | Next Page >