Search Results

Search found 47432 results on 1898 pages for 'database link'.

Page 679/1898 | < Previous Page | 675 676 677 678 679 680 681 682 683 684 685 686  | Next Page >

• INNER JOIN Returns Too Many Results

  - by Alon

  I have the following SQL: SELECT * FROM [Database].dbo.[TagsPerItem] INNER JOIN [Database].dbo.[Tag] ON [Tag].Id = [TagsPerItem].TagId WHERE [Tag].Name IN ('home', 'car') and it returns: Id TagId ItemId ItemTable Id Name SiteId 1 1 1 Content 1 home 1 2 1 2 Content 1 home 1 3 1 3 Content 1 home 1 4 2 4 Content 2 car 1 5 2 5 Content 2 car 1 6 2 12 Content 2 car 1 instead of just two records, which these names are "home" and "car". How can I fix it? Thanks.

  Read the article

• Date in Dropdown list box

  - by cinu

  I have 3 drop down list having Date,Month ,Year.So when Updating I want this 3 Field to be a single Datafield in Sql Database. Iam using Asp.Net 2.0 Version(VB.Net).(Now these 3 Dropdown list values are saved as 3 Datafields in sql Database)

  Read the article

• Software Architecture: Unit of Work design pattern discussion

  - by santiagobasulto

  Hey everybody. According Martin Fowler's Unit of Work description: "Maintains a list of objects that are affected by a business transaction and coordinates the writing out of changes and resolution of concurrency problems." Avoiding very small calls to the database, which ends up being very slow I'm wondering. If we just delimit it to database transaction management, won't prepare statements help with this?

  Read the article

• Crate datasource for mysql to different machine in glassfish

  - by Dickson

  I'm using glassfish(v2.11) as my application server and I have another machine for mysql database server. Currently I want to separate the app server and db server, so I create a jdbc datasource to point to mysql server, but it doesn't works as expect, by the way, when I create datasource to point to local machine (glassfish app server and mysql db server in single machine), and It works well. Is there any configuration I need to care of when pointing datasource to different machine which I use to host my database (MySQL 5.1)?

  Read the article

• How do you work with the hierarchyid data type in a dataset or object

  - by Luke101

  Hello, I would like to work with the hierarchyid in a dataset or custom object. I am not sure how to get parents, children, siblings and other functions will the data is in memory. I can do it within the database but once the info is pulled out of the database into a dataset and cached -- how do you work with it then?

  Read the article

• SQLite vs MySQL

  - by Teifion

  SQLite is a flat-file database and MySQL is a normal database. That's great but I'm not sure which is faster where or better for what? What are the pros and cons of each option?

  Read the article

• Where can I find an ADOExpress tutorial?

  - by mawg

  I'm using Delphi 7, totally new to database programming, and need ODBC. I am told that ADOExpress is a good way to go, and that seems fair enough as it comes with Delphi 7. I need to programatically create, populate, modify and query a database (currently MySql, but that might change, hence ODBC). Can anyone recommend a good tutorial? Thanks.

  Read the article

• PHP Date Manipulations

  - by Ajith

  I need to get previous 30 days from a specific date which is available from database(eg: 2010-05-23 12:36:29).I am try it by using date('d', strtotime("-30 days")) Which is getting the currect answer what i looking for but it is not help me to enter date from database.Please help me to solve the issue.

  Read the article

• In @Table(name = "tableName") - make "tableName" a variable in JPA

  - by zengr

  I am using JPA and I need to make the "tableName" a variable. In a database, I have many tables, and my code needs to access the table where I specify it to read. @Entity @Table(name = "tableName") public class Database implements Serializable {...............} Any ideas?

  Read the article

• Can I recover lost data from an .mdf or .ldf file?

  - by goel-kshamata

  I have my .mdf and .ldf database files for a database named dbtrial. I accidentally deleted the data in one table. Is there any way to do this?

  Read the article

• Suggestions on documentation of a DB model when using Entity Framework 4

  - by Junior Ewing

  Any experiences on how to document Entity Framework 4 based Database projects? There is the Document and Summary properties on the Entities, but if we want to regenerate the model from the database at some point, it will be lost! Is there some way to map documentation data inside SQL to the Entities in the EDMX file so it is safe. Suggestions of other best practices? Ideally I want to be able to augo generate html/helpfile documentation from the DB when we deploy.

  Read the article

• How To Run Postgres locally

  - by Rohit Rayudu

  I read the Postgres docs for Flask and they said that to run Postgres you should have the following code app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI'] = postgresql://localhost/[YOUR_DB_NAME]' db = SQLAlchemy(app) How do I know my database name? I wrote db as the name - but I got an error sqlalchemy.exc.OperationalError: (OperationalError) FATAL: database "[db]" does not exist Running Heroku with Flask if that helps

  Read the article

• Problem with Character Set

  - by Mahesh

  Hi, I am in a problem because of the character set. My client sent me a Oracle database 10g. And when i am going to run the scripts on that database it is giving me error that character set mismatch. I am not an Oracle expert. Can anyone please let me know What should i do? Thanks, Mahesh.

  Read the article

• using onDelete with Doctrine 2

  - by tamir

  I can't get the onDelete to work in Doctrine2 (with YAML Mapping). I tried this relation in my Product class: oneToOne: category: targetEntity: Category onDelete: CASCADE But that doesn't work.. EDIT: I've set the ON DELETE: CASCADE manually in the database imported the YAML mapping with doctrine:mapping:import, emptied the database updated it from the schema with doctrine:schema:update and got no ON DELETE in the foreign key.. so looks like even Doctrine doesn't know how to do it lol..

  Read the article

• Storing and retrieving dynamically created pdf in sql

  - by mwright

  I have been playing around with creation of pdf documents for a project that I'm working on. I would like to store the generated pdf document in a SQL database and then later be able to retrieve this pdf as well. What are some suggestions for doing this? Can the document be stored in the database without physically creating the document on the server?

  Read the article

• SqlMetal alternative for .NET Compact Framework 2.0

  - by mack369

  Is there any way to generate database models from existing database (sdf file) for .NET Compact Framework 2.0? Since it doesn't support LINQ I cannot use SqlMetal. I'm looking for free for commercial use tool.

  Read the article

• Simple web general localization/translation backend (using mysql)?

  - by Hendrik

  Hi is there a free avaible translation backend with database avaible which can handle multiple users(no login needed), multiple languages (UTF-8) and provides automatic google translation? I just need this tool to fill a database (preferable mysql) with simple tables like this: language | label | text english | _helloworld | Hello World! german | _helloworld | Hallo Welt! I don't care about export since this will have to be created anyways.. Thanks it would be a real timesaver if something with an usable UI exists already.

  Read the article

• Loading an NSArray on iPhone from a dynamic data base url in PHP or ASP

  - by Brad

  I have a database online that I would like to be able to load into an NSArray in my app. I can use arrayWithContentsOfURL with a static file, but I really need to go to a url that generates a plist file from the database and loading it into the array. I can use ASP or PHP. I tried setting the response type to "text/xml", but that doesn't help. Any thoughts?

  Read the article

• store objects in $_GET

  - by mixm

  how can i store an object in the $_GET array in PHP. i want to pass an object containing database information from one page to another page via the $_GET array, so there would be no need to access the database again.

  Read the article

• Where does a Server trigger save in SQL Server?

  - by Mostafa

  A couple of days ago , I was practicing and I wrote some triggers like these : create trigger trg_preventionDrop on all server for drop_database as print 'Can not Drop Database' rollback tran go create trigger trg_preventDeleteTable on database for drop_table as print 'you can not delete any table' rollback tran But the problem is I don't know where it has saved and How can I delete or edit those. Thank you

  Read the article

• What's faster? select [object] or select new {[object].value1, [object].value2} with linq

  - by Darcy

  I was hoping some of you guru's out there know the answer to this question. Which is faster? A or B A: var item = from d in database select d; B: var item = from d in database select new {d.item1, d.item2}; SEEMINGLY, it seems like selecting part of the table object would be faster than selecting the entire object, but something tells me its not necessarily the case.

  Read the article

• in django admin, can we have a multiple select based on choices

  - by Rasiel

  http://docs.djangoproject.com/en/dev/ref/models/fields/#choices i've read through the documentation and this implies using a database table for dynamic data, however it states choices is meant for static data that doesn't change much, if ever. so what if i want to use choices, but have it select multiple because the data i'm using is quite static, e.g days of the week. is there anyway to achieve this without a database table?

  Read the article

• Creating a unique id on each different server using PHP.

  - by text

  I am planning on creating my database table for users of an offline site that use as a kiosk.. Those kiosk are not connected on a network nor to each other, they have a separate webserver and database.. what Is the best thing that I can use to have these users on every kiosk to have their different unique id? I am planning using hash so that when we combine all the data's in every machine on single server we can accommodate each unique ids.

  Read the article

• .Net 4.0 Memory-Mapped Files verses RDMS Storage

  - by Harry

  I'm interested in people's thoughts comparing storing data in a traditional SQL based Database or utilising a Memory-Mapped File such as the one in the new .Net 4.0 runtime. The data in question would be arrays of simple structures. Obvious pros and cons: SQL Database Pros Adhoc query support SQL Management Tools Schema changes (adding more columns and setting default values) Memory-Mapped Pros Lighter overhead? (this is an assumption on my part) Shareable between process threads Any others? Is it worth it for performance gains?

  Read the article

• Ideas for designing an automated content tagging system needed

  - by Benjamin Smith

  I am currently designing a website that amongst other is required to display and organise small amounts of text content (mainly quotes, article stubs, etc.). I currently have a database with 250,000+ items and need to come up with a method of tagging each item with relevant tags which will eventually allow for easy searching/browsing of the content for users. A very simplistic idea I have (and one that I believe is employed by some sites that I have been looking to for inspiration (http://www.brainyquote.com/quotes/topics.html)), is to simply search the database for certain words or phrases and use these words as tags for the content. This can easily be extended so that if for example a user wanted to show all items with a theme of love then I would just return a list of items with words and phrases relating to this theme. This would not be hard to implement but does not provide very good results. For example if I were to search for the month 'May' in the database with the aim of then classifying the items returned as realting to the topic of Spring then I would get back all occurrences of the word May, regardless of the semantic meaning. Another shortcoming of this method is that I believe it would be quite hard to automate the process to any large scale. What I really require is a library that can take an item, break it down and analyse the semantic meaning and also return a list of tags that would correctly classify the item. I know this is a lot to ask and I have a feeling I will end up reverting to the aforementioned method but I just thought I should ask if anyone knew of any pre-existing solution. I think that as the items in the database are short then it is probably quite a hard task to analyse any meaning from them however I may be mistaken. Another path to possibly go down would be to use something like amazon turk to outsource the task which may produce good results but would be expensive. Eventually I would like users to be able to (and want to!) tag content and to vote for the most relevant tags, possibly using a gameification mechanic as motivation however this is some way down the line. A temporary fix may be the best thing if this were the route I decided to go down as I could use the rough results I got as the starting point for a more in depth solution. If you've read this far, thanks for sticking with me, I know I'm spitballing but any input would be really helpful. Thanks.

  Read the article

< Previous Page | 675 676 677 678 679 680 681 682 683 684 685 686  | Next Page >