Search Results

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

Page 236/1300 | < Previous Page | 232 233 234 235 236 237 238 239 240 241 242 243  | Next Page >

• mysql bug database error

  - by user963499

  Why is that when I search a row in my database, it ended up 0 results? In fact, there are rows that meet my search criterion when I view them manually, but the search button doesnt work as it is. Heres how you can see there are rows that have '0000-00-00 00:00:00' in them, but when I used the search feature, it ended up like this: take note that Im entering it in the right field which is 'AcctStopTime'. TIA

  Read the article

• News Portals and database heaviness

  - by jasmine

  What is database design solutions for news portals with high trrafic? Could file system as a good solution? mysql > File system Thanks in advance

  Read the article

• Rails: Serializing objects in a database?

  - by keruilin

  I'm looking for some general guidance on serializing objects in a database. What are serialized objects? What are some best-practice scenarios for serializing objects in a DB? What attributes do you use when creating the column in the DB so you can use a serialized object? How to save a serialized object? And how to access the serialized object and its attributes? (Using hashes?)

  Read the article

• XML Database in C#.net

  - by rookieinfotech

  I am developing a WPF client program for some websites. It uses XML database. I am new to XML. Would someone please explain how to create,append(Most important),edit,read&encrypt XML file. It is a big question,i know . But, it is urgent.Have to complete the work ASAP. Searched in the internet, not getting correct info.

  Read the article

• How to export a mysql database using DOS?

  - by samplera

  I have a database it is quite larger so I wanted to export it using DOS, but I dont know how to. Please help I am using WAMP

  Read the article

• error while fetching empty column from database in iphone

  - by Jaimin

  i wnant to fetch the data fromt the database but getting error when i try to get the empty column... i used the following code to do it.. NSString *aDescription = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 2)]; so if my second column is empty than i get exception

  Read the article

• Select number of rows in all tables in the database

  - by Alex N.

  I wonder if this is possible with straight SQL on MySQL. I need to do SELECT COUNT(*) FROM on each table in the database and output results in one result set. Is it possible to do with just SQL?

  Read the article

• Using an excel as database : How to supply network security

  - by Cmptrb

  Hi, I have published a small website and I'm using an excel file as a database. The problem is that the excel file could be easily downloaded if its path is known ! (e.g. www.mysite.com/myexcel.xls - opens a "save as" window) What can I do, to protect my data. Kind regards.

  Read the article

• Hibernate - Knowing when hitting database vs cache

  - by Marty Pitt

  Given all the smarts around Hibernate and it's various caching strategies, how do I know if a certain operation is resulting in a physical database hit, or coming from the cache?

  Read the article

• How do I clone an OpenLDAP database

  - by elzapp

  I know this is more like a serverfault question than a stackoverflow question, but since serverfault isn't up yet, here I go: I'm supposed to move an application from one redhat server to another, and without very good knowledge of the internal workings of the application, how would I move the OpenLDAP database from the one machine to the other, with schemas and all. What files would I need to copy over? I believe the setup is pretty standard.

  Read the article

• Efficiently store last X items in an MySQL Database

  - by Saif Bechan

  I want to store the last 3 items in an MySQL database in an efficient way. So when the 4th item is stored the first should be deleted. The way I do this not is first run a query getting the items. Than check what I should do then insert/delete. There has to be a better way to do this. Any suggestions?

  Read the article

• Connecting VB.NET to a MySQL Database

  - by Bubby4j

  I have a VB.NET application and I need it to be able to display rows from a MySQL database. How would I do this?

  Read the article

• Inserting a null value into the database.

  - by J Harley

  Good Morning, Say I have an insert statement: Insert INTO tblTest (fieldOne,FieldTwo,fieldThree) VALUES ('valueOne','valueTwo','null') This statement doesn't seem to want to insert a null value into the database... I have also tried to insert the word "nothing". Has anyone any ideas how to make this work? I am using SQL server 2005.

  Read the article

• is it better to retrive data using web service or directly from database in .net

  - by girish

  i was wondoring which thing is better from below two... first one- retrive data by creating webservice second one- create database connection from code behind call storeprocedure and retive data can anyone one explain how it differs.

  Read the article

• Coping Indexes from old database to new one?

  - by AmRoSH

  Hi, I converted an old sql server database from 2000 to 2005 and forgetten to add old indexes to the new db. is there any way to copy the old indexes to the new db? any help?

  Read the article

• Sample Employe MS SQL Database with data (surname, name, age, address)

  - by Tom

  Hi I need some sample MS SQL Employee database with data such as id, surname, name, age, adress etc. It must be quite big, I search with google, but I don't find any good sample. Can any body help ?

  Read the article

• Manually Add a User to Database ASP.NET?

  - by user364878

  Hello, So when your using ASP.NET Wizards to create a login, it uses a set of auto generated tables using the aspnet_regsql.exe tool... When you create a user using the wizard it generates a very long userID "a40cf936-1596-4560-a26c-450792e2c8c0" I want to add users using another program that connects to this database... but how does visual studio auto-generate this ID. I want to auto-generate it as well Any ideas? Thanks in advance. -Scott

  Read the article

• Linking database column to dropdown control in ASP.Net

  - by kunal

  I am using c# with asp.net and SQL Server 2005 as backend. I want to use dropdown list control in a form to populate a textbox. The dropdown control is linked to a column in the database. How can I code this in c#?

  Read the article

• move data in bulk from oracle to SQL database

  - by Soja

  Hi All... Would like to know which is the best way to move data in bulk from oracle to SQL database programmatically in VB.NET application.This application is suppose to run continuously and moves data from Oracle to SQL whenever data comes. I have found OPENDATASOURCE but does not know the exact syntax. Can someone help me out. Thanks in advance,

  Read the article

• Select random line in SQL database

  - by Jensen

  Hi, I would like to select a random line in my database. I saw this solution on a website: SELECT column FROM table ORDER BY RAND() LIMIT 1 This SQL query run but someone said me that it was a non performant query. Is there another solution ? Thx

  Read the article

• What happens if MySQL database wasn't closed?

  - by mathew

  What happens if MySQL database is not closed? How do we know if it is closed properly?

  Read the article

• Source control system for small database dev team

  - by bjorsig

  I am responsible for a small development team and we deal mainly with database development. We are currently using MS Visual Source Safe as our source control system, but it has its limitations and we are seriously thinking about changing. What system would you choose?

  Read the article

• ASP.NET MVC - Can't access a parent class in a database relationship (LINQ TO SQL)

  - by Alex

  I have a class User and a class History. History has 'User' property, and User has 'Histories' property. So there's a database relationship. But when I create a new User history class and set UserID property, I can't access the 'User' property. var history = new History { UserID = 1 }; // history.User = null ??? How can I get the user?

  Read the article

• Database is very slow when creating an index

  - by kaliyaperumal M

  My database has around 25 core numbers, in that weekly basis I need to create an index and drop index. While creating the index it takes long time to complete, my log file also keeps on increasing, and when I delete some numbers from that table also taking too much time (because weekly basis I have to delete 30 to 50 lack numbers and add 30 to 40 lack new number also). Can u please give me the proper solution..

  Read the article

• Are the ususal database performance-tuning tips invalide for a third-party app like Drupal

  - by Paul Strugger

  When you have a slow database app, the first suggestions that people make is to: Track the slow queries Add appropriate indexes In the case you are building your own application this is very logical, but when you use a CMS like Drupal, that are people have developed and tuned, is this approach valid? I mean, aren't Drupal tables already fine-tuned for performance? Even if I try to see which queries are the slow ones, what could I do about it? Re-write Drupal core?!?

  Read the article

< Previous Page | 232 233 234 235 236 237 238 239 240 241 242 243  | Next Page >