Search Results

Search found 31472 results on 1259 pages for 'offline database'.

Page 69/1259 | < Previous Page | 65 66 67 68 69 70 71 72 73 74 75 76  | Next Page >

• Non-Linear Database Retrieval

  - by pws5068

  I'm building an article system, and each article will have one more Tags associated with it (similar to the Tags on this site). The tables are set up something like this: Article_Table Article_ID | Title | Author_ID | Content | Date_Posted | IP ... Tag_Table Tag_ID | Name ... Tag_Intersect_Table Tag_ID | Article_ID Is it possible query an article and all of its associated tags in one database call? If so, how is this done?

  Read the article

• ISBN -> bookdata Lookup to fill in a database

  - by oxinabox.ucc.asn.au

  Ok, I wanting to database a small library. I've only had limmited experience with databeses, and vnone with queerying a websever. I'm going to want to retrieve information like title, Publisher, maybe author, desciption the simplest way i can think of dooing this is looking them up via the isbn. I'm wondering how I should go about doing this. I've coma across isbndb.com before, but the api for accessing it seems rather complex.

  Read the article

• Encrypting an access database

  - by Karthick

  Hi, I have MS Access database which is password protected, i want to encryption with 128-bit encryption. Any inputs? Thanks in advance, Karthick

  Read the article

• AMFPHP Database Sessions

  - by Rick

  I am using AMFPHP w/ a Flex application and am needing to start storing the user sessions in the database instead of the filesystem. I've tried utilizing the session save handler function but no matter what I do it still ends up storing the files on the filesystem. Any ideas?

  Read the article

• Q&A database map like stackoverflow - seperate table for questions titles

  - by Qiao

  I am planning to make Q&A system (quite specific, has nothing to do with IT) I was looking for Stackoverflow database map: http://meta.stackoverflow.com/questions/2677/anatomy-of-a-data-dump/2678#2678 And I am thinking is not it is better practice to make separate table for questions titles. With "firstPostId". Instead of |- PostTypeId | - 1: Question | - 2: Answer So I want to know, why stackoverflow did not use separate table for questions title. Is it "Do not optimize yet" or does it have any logic behind it?

  Read the article

• Sample application using Northwind 2007 Access database

  - by metro

  Is there a sample C# winform application (a starter kit or something ) which use the Northwind 2007 Acess Database version ? some concept like http://northwind.codeplex.com/ ?

  Read the article

• Style guide for database metadata naming

  - by Nulldevice

  We want to establish some database metadata naming rules in our new project. For example: tables are named as nouns in a plural form (courses, books, lessons) if present, an adjective goes before a noun in a table name and is separated by an underscore (red_books, new_lessons) table index column is always named "id" foreign key names are derived from a table name with suffix _id (book_id, red_book_id) so on Does someone know any guide like this?

  Read the article

• what is the difference between triggers, assertions and checks (in database)

  - by Am1rr3zA

  Can anybody explain (or suggest a site or paper) the exact difference between triggers, assertions and checks, and also describe where I should use them? EDIT: I mean in database, not in any other system or language.

  Read the article

• Converting a Table in Oracle Database into an XML file

  - by Geethapriya.VC

  Hi, I need to create XML file, given a table/view in the Database. The actual requirement would be: The code has to get the table/view name as input parameter, read the schema of the same, create a corresponding XML file with the same structure as that of the table/view, and load the XML with the data of the table/view. Language preferred here is JSP. Kindly let me know how to go about this idea. Thanks in advance, Geetha

  Read the article

• Compare 2 database

  - by shantanuo

  I have 2 identical databases. abc15 and abc18. But one of the database has one extra table and I need to find that. I thought the following query should return it, but is it not showing the record that I expect. select * from information_schema.tables as a left join information_schema.tables as b on a.TABLE_SCHEMA=b.TABLE_SCHEMA AND a.TABLE_NAME=b.TABLE_NAME where a.TABLE_SCHEMA = 'abc15' AND b.TABLE_SCHEMA='abc18' and b.TABLE_NAME IS NULL

  Read the article

• Javascript Object Database

  - by Narven

  Hi, is there any javascript object database?? Something like http://www.db4o.com/ but for javascript? thanks

  Read the article

• is there anyway to add a primary autonumber key to an already existing database table

  - by oo

  i have inherited a database application from someone else and there are a few tables that dont have any primary keys. I want to add a new column into an already existing table and have it autonumber (starting from 1). how would i go about doing this?

  Read the article

• Simple ASP.NET Database Query

  - by Steven

  I have loaded my database with one table under "Data Connections" in the "Server Explorer" pane. What is the standard / best-practices way to handle a simple query in a VB ASPX page? My left <div> would be a set of form elements to filter rows, and when the button is clicked, the main <div> would show the columns I want for the rows returned. Note: Answers in C# are okay too, I'll just translate.

  Read the article

• Is it possible to update on Firebird database from a trigger in another Firebird database?

  - by williamsdb

  I have two firebird databases running on the same server and I want to write to a table on one of the databases from a trigger on the other database when certain actions occur. I have had a search and cannot find out if this is possible. Can it be done either natively in firebird or via a UDF? Thanks Neil

  Read the article

• C# DateTime Class and Datetime in database

  - by Spyros

  Hello . I have the following problem. I have an object with some DateTime properties , and a Table in database that I store all that objects , in Sql server I want to store the DateTime properties in some columns of DateTime Datatype, but the format of datetime in sql server is different from the DateTime class in c# and I got an sql exception saying "DateTime cannot be parsed". I know how to solve this by making the format yyyy-MM-dd but is this the proper and best solution to do this?

  Read the article

• Visual Representation Of Database Schema

  - by Richard Knop

  is there some standard about how to graphically represent database schemas? Is UML a defacto standard for this? Also, is there some free tool that can help me convert an sql file (basically bunch of CREATE TABLE queries) into some nice graph (UML or not UML)?

  Read the article

• Storing connections between people in a MySql database

  - by daniel

  I would like to create a database where I store the links between people. I then need to bring back the records detailing which people are connected to which others. I need to output: person1 is connected to person2 is connected with person3 etc. How can I get started with this task?

  Read the article

• [java] best database for desktop application

  - by blow

  Hi all, i have to choose a database for a big desktop application. Which of this db is better: Firebird, JavaDB, hsqldb ? I need perfomance and easy to use, and totally free license. Thank.

  Read the article

• java database backup restore

  - by jawath

  how do i backup /restore any kind of databases inside my java application to flate files.Are there any tools framework available to backup database to flat file like CSV, XML,or secure encrypted file,or restore from csv or xml files to databases ,it should be also capable of dumping table vise restore and backup also

  Read the article

• why restoring database never finishes?

  - by LingAi

  Hi all, I have really wired problems here. I am using MS 2008 sql server at the moment. After I did a tail-log backup, the target database is automatically restoring and keeping on restoring. Does anyone know what's the problem? Thanks, Ling

  Read the article

• Database normalization question

  - by chchrist

  Hi all, I am trying to make a fashion boutique site. In this site each product (t-shirt,jeans etc) belongs to a collection. Each collection has looks (t-shirt,jean,accessories). A product can belong to one collection and to multiple looks. How should I design the database?

  Read the article

• Visual Studio For Database Professionals 2008

  - by Woodie

  Anyone know any a few good references for getting familiar with the SQL Server 2008 Database projects? I am getting a bit overwhelmed and would love to find a walk through for putting this project type to good use. Thanks in advance.

  Read the article

• Local use of MySQL database

  - by waanders

  Hi all, Is it possible to use MySQL local? I mean NOT at a server. I read a lot about MySQL on a webserver with PHP, Joomla etc. I want to program a piece of software and use a database local to store results. Can I use MySQL for that? If so, is ther anyware on the net a good tutorial how to do that?

  Read the article

• Database Testing

  - by vinoj123

  Can anyone expalin in detail how to perform Database Testing. I've basic idea about DDL, DML statements.

  Read the article

• Oracle database links between 10g and 11g

  - by JavaRocky

  Does anyone have experience with database links between 10g and 11g? Is this a supported setup/operation? Is it possible? Are there any problems? Caveats?

  Read the article

< Previous Page | 65 66 67 68 69 70 71 72 73 74 75 76  | Next Page >