Search Results

Search found 36946 results on 1478 pages for 'sample database'.

Page 129/1478 | < Previous Page | 125 126 127 128 129 130 131 132 133 134 135 136  | Next Page >

• How to use sqlite database from inside MS Access ?

  - by Phong

  I would like to use a sqlite databse inside MS Access in order to use (transfer would be good enough) the content of sqlite database table in MS-Access. How can this be done in VBA ?

  Read the article

• What happened to the "Run" and "Run On" commands in Visual Studio 2010 Database Projects?

  - by Steve Elmer

  Hello, I have migrated a database project from VS2008 to VS2010. While in VS08, I used to be able to right-click on a .sql or .cmd file and select a "Run" or "Run On" command from the context menu. In VS2010, though, these menu items seem to have gone away. I have a number of .sql and .cmd scripts that I am used to being able to run directly from the Visual Studio IDE. Can someone point me in the right direction? Thanks, Steve

  Read the article

• How to backup database file to sdcard on android?

  - by CSharperWithJava

  I'd like to add a feature to my android app that automatically backs up the sqlite database to the sd card. What's the best way to go about this? Any examples/tutorials available?

  Read the article

• get state and county a city belongs to with geonames database?

  - by fayer

  i have downloaded whole database from geonames.com and imported all countries into mysql. i wonder how i can get the continent, country, state, county when i got a city's id? cause i want to make a cascading list menu with these information. thanks!

  Read the article

• How can I change the look of SQL Server Managment Studio based on which database I'm connected to?

  - by Traples

  I'd like to modify the appearance of the query window in SQL Server Management Studio based on which database I'm currently connected to. For example, using a yellow background for production databases. Is there a way to do this?

  Read the article

• What programming languages/platforms are suitable for writing to a database?

  - by matt

  I'm working on a class assignment that involves reading an XML document and inserting the contents into a database. Language choice is wide open - so I figure, why not consider all my options! What languages are able and appropriate for working with databases?

  Read the article

• How do I generate Symfony fixtures YML from exising database data?

  - by frodosghost

  I was wondering if anyone knew how to generate a fixture.yml from data that is already existing in the database? As you can use the build-schema to generate a schema, is there a way to do that for data? symfony propel:build-schema

  Read the article

• How to establish secure connection between java application and database?

  - by Shashi Bhushan

  Recently, in an interview asked me an question : The communication between our application and that of the remote database must be done with https (more secure). How could you do it? I didn't find any clue for any question in google also.

  Read the article

• Are there any embeddable document database engines for Java? Something similar to MongoDB or CouchDB

  - by Juha Syrjälä

  Are there any embeddable document database engines for Java, that do not require separate server. I am looking for something similar to MongoDB or CouchDB.

  Read the article

• How do I use Django to insert a Geometry Field into the database?

  - by alex

  class LocationLog(models.Model): user = models.ForeignKey(User) utm = models.GeometryField(spatial_index=True) This is my database model. I would like to insert a row. I want to insert a circle at point -55, 333. With a radius of 10. How can I put this circle into the geometry field? Of course, then I would want to check which circles overlap a given circle. (my select statement)

  Read the article

• can i deploy sql server express with my desktop application just like buildin database?

  - by MemoryLeak

  can i deploy sql server express with my desktop application just like buildin database? Because I don't want my client to set up separately sql server express! is it easy to integrate sql server express into my desktop application ?

  Read the article

• What are the Options for Storing Hierarchical Data in a Relational Database?

  - by orangepips

  Good Overviews One more Nested Intervals vs. Adjacency List comparison: the best comparison of Adjacency List, Materialized Path, Nested Set and Nested Interval I've found. Models for hierarchical data: slides with good explanations of tradeoffs and example usage Representing hierarchies in MySQL: very good overview of Nested Set in particular Hierarchical data in RDBMSs: most comprehensive and well organized set of links I've seen, but not much in the way on explanation Options Ones I am aware of and general features: Adjacency List: Columns: ID, ParentID Easy to implement. Cheap node moves, inserts, and deletes. Expensive to find level (can store as a computed column), ancestry & descendants (Bridge Hierarchy combined with level column can solve), path (Lineage Column can solve). Use Common Table Expressions in those databases that support them to traverse. Nested Set (a.k.a Modified Preorder Tree Traversal) First described by Joe Celko - covered in depth in his book Trees and Hierarchies in SQL for Smarties Columns: Left, Right Cheap level, ancestry, descendants Compared to Adjacency List, moves, inserts, deletes more expensive. Requires a specific sort order (e.g. created). So sorting all descendants in a different order requires additional work. Nested Intervals Combination of Nested Sets and Materialized Path where left/right columns are floating point decimals instead of integers and encode the path information. Bridge Table (a.k.a. Closure Table: some good ideas about how to use triggers for maintaining this approach) Columns: ancestor, descendant Stands apart from table it describes. Can include some nodes in more than one hierarchy. Cheap ancestry and descendants (albeit not in what order) For complete knowledge of a hierarchy needs to be combined with another option. Flat Table A modification of the Adjacency List that adds a Level and Rank (e.g. ordering) column to each record. Expensive move and delete Cheap ancestry and descendants Good Use: threaded discussion - forums / blog comments Lineage Column (a.k.a. Materialized Path, Path Enumeration) Column: lineage (e.g. /parent/child/grandchild/etc...) Limit to how deep the hierarchy can be. Descendants cheap (e.g. LEFT(lineage, #) = '/enumerated/path') Ancestry tricky (database specific queries) Database Specific Notes MySQL Use session variables for Adjacency List Oracle Use CONNECT BY to traverse Adjacency Lists PostgreSQL ltree datatype for Materialized Path SQL Server General summary 2008 offers HierarchyId data type appears to help with Lineage Column approach and expand the depth that can be represented.

  Read the article

• I'm building a javascript app, I need a lightweight php script to interact with a database and javas

  - by RobertWHurst

  My app is a very complex game that uses json objects to store its execution state (aka save games). I'm looking for a nice database script that can talk json and interact with javascript via ajax.

  Read the article

• How to create a database table in an installation file for a Drupal Module?

  - by Koning WWWWWWWWWWWWWWWWWWWWWWW

  I am creating a module for Drupal 7.x, and I want to create a database table when the module is installed (enabled for the first time). How can I do this? Thanks.

  Read the article

• Why am I getting this UnicodeEncodeError when I am inserting into the MySQL database?

  - by alex

  UnicodeEncodeError: 'ascii' codec can't encode character u'\xe9' in position 2: ordinal not in range(128) I changed my database default to be utf-8, and not "latin"....but this error still occurs. why?

  Read the article

• How do you manage schema upgrades to a production database?

  - by Mark Harrison

  This seems to be an overlooked area that could really use some insight. What are your best practices for: making an upgrade procedure backing out in case of errors syncing code and database changes testing prior to deployment mechanics of modifying the table etc...

  Read the article

• How do you hook a C++ compiled dll function to a sql database?

  - by Thomas

  I want to do something like: lastName SIMILARTO(lastName, 'Schwarseneger', 2) where lastName is the field in the database, 'Schwarseneger' is the value that lastName field is being compared to and 2 is the maximum number of characters (edit distance) that can differ between the lastName field, and the entered value. I can implement the SIMILARTO function in C++ using the Levenshtein distance (http://en.wikipedia.org/wiki/Levenshtein_distance), but how do hook the function in a dll to a mySQL implementation?

  Read the article

• Is there a tool like phpMyAdmin which can be configured to access just a single database?

  - by Ritesh M Nayak

  Is there a tool like phpMyAdmin which can be configured to access only a single MySQL database in a server? I cannot use phpMyAdmin because it allows access to all databases. A view that can allow a user to create/delete/insert/update tables should do. I remember using a software similar to this but dont remember what it was. It would also be great if its in PHP.

  Read the article

• PHP - How to make/generate a graph image depending on values in a database?

  - by Dodi300

  Hello. How could I make an image graph from values in a database? The idea came from "Steam", which uses a graph to show how many users are online. How could I do the same thing? It seems like the graph is one whole image; not made up of parts. Here's an image of the graph from Steam: Thanks.

  Read the article

• How to insert hyperlink into access database via sql?

  - by CSharperWithJava

  I have a fairly simple MS Access Database that contains some metadata about a bunch of documents and a hyperlink field that links to the document on our network drive. However, when I use a SQL INSERT statement to populate the hyperlink field, the value I give it only becomes the display text, not the actual link. How can I make the value a functional hyperlink? I'd think that the hyperlink data type would actually create hyperlinks. I'm using Access 2002 SP3.

  Read the article

• How do I connect to an Access database over a LAN using Java?

  - by Relequestual

  Do you know of any good guides on how to access an Access database using Java? I know the basics and basic SQL, but I'm thinking more about access control.

  Read the article

• converting web server logs (apache,iis, etc..) to relational Database

  - by Karim

  i have some apache logs and i want to be able to query the data in it. so i wanted to know if its possible to convert this log data to a relational database so i later can query and analyze the data using sql statments. thanks

  Read the article

• Do you know a free test data generator for mysql database?

  - by EugeneP

  Do you know a free test data generator for mysql database? Maybe native tools allow you to generate test data?

  Read the article

• How do i structure my SQL Database (tables, Schemas, users, stored procedures etc.) to prepare it fo

  - by AlexRednic

  I think the title is self explanatory. What I'm looking for is material so I can further my knowledge. I've never developed a full application before so building one from scratch is a bit overwhelming for me. And the first bump in the road is the database. Websites, articles, books, elaborate answers, anything will do as long as they keep me on the right track. Thanks

  Read the article

• What are good open source GUI SQLite database managers?

  - by RageZ

  Is there any good open source SQLite database manager around? I am using sqlitebrowser now but I have to say the interface is not really friendly so I am looking for something better.

  Read the article

< Previous Page | 125 126 127 128 129 130 131 132 133 134 135 136  | Next Page >