Search Results

Search found 5380 results on 216 pages for 'primary'.

Page 89/216 | < Previous Page | 85 86 87 88 89 90 91 92 93 94 95 96  | Next Page >

• SQL conditional row insert

  - by Pablo

  Is it possible to insert a new row if a condition is meet? For example, i have this table with no primary key nor uniqueness +----------+--------+ | image_id | tag_id | +----------+--------+ | 39 | 8 | | 8 | 39 | | 5 | 11 | +----------+--------+ I would like to insert a row if a combination of image_id and tag_id doesn't exists for example; INSERT ..... WHERE image_id!=39 AND tag_id!=8

  Read the article

• Source Control at home

  - by Sash

  I am trying to setup a dev environment at home. My primary development environment is VS.NET 2008 (now it is VS 2010 Premium) with SQL Server 2008. Objectives / Requirements : - Should be simple and lightweight - Should have a Visual Studio plugin (cost should be less than $50, if its not free) - should work just fine with continuous integration systems like TFS and CruiseControl.NET - VSS is not an option. Thanks in advance, SK

  Read the article

• sqlite issue using WHERE statement on a varchar field in Objective-C

  - by Geykel

  Hi, I have this sql statement SELECT * FROM Language WHERE LanguageCode=? where LanguageCode is a varchar(2). When I use sqlite3-prepare-v2 on that statement I got SQLITE_ERROR but if I use SELECT * FROM Language WHERE LanguageID=? where LanguageID is the primary key numeric identity field the statement compiles just fine. Is there any issue filtering by a varchar field using WHERE statement? Thanks

  Read the article

• Using Oracle Sequence in SQL Loader?

  - by Sujee

  Hi, I am using SEQUENCE keyword in SQL Loader control file to generate primary keys. But for a special scenario I would like to use Oracle sequence in the control file. The Oracle documentation for SQL Loader doesn't mentioned anything about it. does SQL Loader support it?

  Read the article

• Setting up a linked server to another server which isn't in a domain without using SQL authenticatio

  - by Telos

  Server A (SQL2005) is in our primary domain, but server B (SQL2000) is just in a windows workgroup. We are not allowed to join it to the domain, or bad things happen... We also can't enable SQL authentication on server B. We've got domain accounts for A, and matching local accounts on server B. I can connect to B from my local PC or A using SSMS and a domain login, but I can't get the linked server to connect. Any ideas how to do this?

  Read the article

• UNIQUE Constraints in SQL (SQL Server)

  - by rockbala

  Why are UNIQUE Constraints needed in database ? Can you provide any examples ? Primary Key is UNIQUE by default... Understandable as they are referred in other tables as Foreign keys... relation is needed to connect them for rdbms platform... but why would one refer to other columns as UNIQUE, what is benefit of doing so ?)

  Read the article

• Deployment project in VisualStudio: Is the output in Debug or Releaase mode?

  - by serhio

  I have a solution in Visual studio containing a winform project(WinProj) and a deployment project for WinProj. I added to the deployment project the primary output from WinProj. Does it be compiled in Debug or Release mode? I am asking because in the WinProj code I have conditional precompiler statements #if DEBUG throw; #endif will or not be considered this code in the setup project?

  Read the article

• Google App Engine datastore-Table creation

  - by megala

  I have one doubt regarding table creation in google app engine datasore using jpa.my consatraints is ,Is it possible to create a table without using primary key.(i.e) without using @Id annotations. Thanks in advance

  Read the article

• LINQ entity query performance

  - by Abdel Olakara

  Hi all, I have a silly question. I would like to know if there is performance deference in these two quries: var cObject = from cust in entities.Customer where cust.id == cid select cust; and var cObject = entities.Customer.First( c=> c.id == cid); My query return only one record as I am querying with the primary key. But do they make any difference?

  Read the article

• Does UserId data type affect FormsAuthentication.SetAuthCookie(UserId.ToString(), false)?

  - by FreshCode

  Does the original data type of the username string in a call to FormsAuthentication.SetAuthCookie(...) make any difference with regards to security or code maintainability? As I understand it, the cookie is encrypted and used to identify a user on each request. I'm curious whether it should affect the design of the primary key on my Users table in my database, eg. Guid vs int or a unique username string.

  Read the article

• how to ssh in perl script

  - by Salman

  Hi I want to SSH to a server and execute a simple command like "id" and get the output of it and store it to a file on my primary server. I do not privileges to install Net::SSH which would make my task very easy. please provide me a solution for this. I tried using backticks but I am not able to store the output on the machine from which my script runs.

  Read the article

• drupal editing user information after registration

  - by Arun

  how to allow user to edit their information after registration. And moreover how add new fields during editing information. for ex: my primary registration holds name,email,picture(optional). I want to get additional information like state,city,... when they wants some customized service. May any one suggest me a solution .

  Read the article

• Giving GUID for data using NDBUnit

  - by jess

  I am using NDBUbit to load data from XML file.Right now,I am manually giving GUID for each record(our primary key for all tables is unique-identifier) in the xml file.But,I wonder if there is a better way to do this?

  Read the article

• How to store array data in MySQL database using PHP & MySQL?

  - by Cyn

  I'm new to php and mysql and I'm trying to learn how to store the following array data from three different arrays friend[], hair_type[], hair_color[] using MySQL and PHP an example would be nice. Thanks Here is the HTML code. <input type="text" name="friend[]" id="friend[]" /> <select id="hair_type[]" name="hair_type[]"> <option value="Hair Type" selected="selected">Hair Type</option> <option value="Straight">Straight</option> <option value="Curly">Curly</option> <option value="Wavey">Wavey</option> <option value="Bald">Bald</option> </select> <select id="hair_color[]" name="hair_color[]"> <option value="Hair Color" selected="selected">Hair Color</option> <option value="Brown">Brown</option> <option value="Black">Black</option> <option value="Red">Red</option> <option value="Blonde">Blonde</option> </select> <input type="text" name="friend[]" id="friend[]" /> <select id="hair_type[]" name="hair_type[]"> <option value="Hair Type" selected="selected">Hair Type</option> <option value="Straight">Straight</option> <option value="Curly">Curly</option> <option value="Wavey">Wavey</option> <option value="Bald">Bald</option> </select> <select id="hair_color[]" name="hair_color[]"> <option value="Hair Color" selected="selected">Hair Color</option> <option value="Brown">Brown</option> <option value="Black">Black</option> <option value="Red">Red</option> <option value="Blonde">Blonde</option> </select> Here is the MySQL tables below. CREATE TABLE friends_hair ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, hair_id INT UNSIGNED NOT NULL, user_id INT UNSIGNED NOT NULL, PRIMARY KEY (id) ); CREATE TABLE hair_types ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, friend TEXT NOT NULL, hair_type TEXT NOT NULL, hair_color TEXT NOT NULL, PRIMARY KEY (id) );

  Read the article

• SQL Comments on Create Table on SQL Server 2008

  - by user494901

  I need to create some pretty big tables in SQL server 2008, while I do have SQL Server Manager Studio, I would like to comment the tables and the columns when I create the table. How do I do this? Example of the query I am running: CREATE TABLE cert_Certifications ( certificationID int PRIMARY KEY IDENTITY, profileID int, cprAdultExp datetime null ) I've tried COMMENT'Expiration Date for the Adult CPR' and COMMENT='Expiration Date for the Adult CPR' after the data type, and SQL server is giving me an error.

  Read the article

• CakePHP: how to get recently created auto-incremented field

  - by junior29101

  I have a user submit a field to the database, it validates, and makes the entry. The primary key of this new row is auto-incremented. The user then gets to another form where that newly created field is required. Can anyone shed any light on this problem? Thanks in advance!

  Read the article

• how to create binary of iphone application

  - by CodeWriter

  hello, On reading the iTunesConnect_DeveloperGuide.pdf, i came across the term binary. This is the paragraph found in the pdf: To submit your application through iTunes Connect and get it posted on the App Store successfully, make sure you have the following: Application binary (includes 57px icon), large 512px icon for use on the App Store, primary screenshot, contract information, export compliance information and applica- tion metadata It is also mentioned that the binary should be a zipped file. Can anyone please explain what is a binary and how to create one? Thanks

  Read the article

• Jetspeed 2.2 Nest or render one portlet inside another

  - by David Just

  I have a requirement to build an extensible wizard in a portlet. This wizard will list components that are installed and forward the user to a sub-wizard that is component specific. The requirement is that the components are to be developed by other people and dynamically plugged into this wizard (Jetspeed reboot is okay). I would like to be able to define the components as portlets themselves who's content is rendered into the primary portlet. Has anybody ever done something like this?

  Read the article

• django-piston: how to get values of a many to many field ?

  - by jzelez

  I have a model with ManyToManyField to another model. I would like to get all the info on a particular record (including the related info from other models) return by JSON. How to get django-piston to display those values? I would be happy with just primary keys. Or can you suggest another option ?

  Read the article

• UITablevViewCellStyle strange behaviour with detailTextLabel

  - by joec

  I have set my UITableViewCellStyle to be Value2, and it shows the detailTextLabel and textLabel, but instead of the detailTextLabel being the small text to the left of the cell, it is now the primary text in the cell, and the textLabel is the small text. Strange behaviour and i'm not sure why? For now i'm just swapping the values over, but I'm pretty sure its not correct. Anyone else experienced this issue? Thanks

  Read the article

• MySQL won't use index for query?

  - by Jack Sleight

  I have this table: CREATE TABLE `point` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `siteid` INT(11) NOT NULL, `lft` INT(11) DEFAULT NULL, `rgt` INT(11) DEFAULT NULL, `level` SMALLINT(6) DEFAULT NULL, PRIMARY KEY (`id`), KEY `point_siteid_site_id` (`siteid`), CONSTRAINT `point_siteid_site_id` FOREIGN KEY (`siteid`) REFERENCES `site` (`id`) ON DELETE CASCADE ) ENGINE=INNODB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci And this query: SELECT * FROM `point` WHERE siteid = 1; Which results in this EXPLAIN information: +----+-------------+-------+------+----------------------+------+---------+------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------+------+----------------------+------+---------+------+------+-------------+ | 1 | SIMPLE | point | ALL | point_siteid_site_id | NULL | NULL | NULL | 6 | Using where | +----+-------------+-------+------+----------------------+------+---------+------+------+-------------+ Question is, why isn't the query using the point_siteid_site_id index?

  Read the article

• How did you get your first programming job?

  - by Gaz

  Hi All, I have some commercial programming experience although it was not my primary role (C# and Java), SCJP 6 cert, some SQL experience and have been doing a lot of Android programming (I have one app with 36,000 downloads). I have a degree in Chemistry and a Diploma in Programming (half a degree made up of 2nd/3rd year uni courses). I'm trying to get my first entry level programmer job but am finding it tough out there.......How did other people get there first jobs in programming?

  Read the article

• How can I create a small relational database in MySQL?

  - by Sergio Tapia

  I need to make a small database in MySQL that has two tables. Clothes and ClotheType Clothes has: ID, Name, Color, Brand, Price, ClotheTypeID ClotheType has: ID, Description In Microsoft SQL it would be: create table Clothes( id int, primary key(id), name varchar(200), color varchar(200), brand varchar(200), price varchar(200), clothetypeid int, foreign key clothetypeid references ClotheType(id) ) I need this in MySQL.

  Read the article

• How to make an id auto_increment from where it last left off after a record delete?

  - by Sammy

  This isn't that big of a deal but I was wondering if it can be done. Right now when I insert a new record, the id field which is auto_increment and set as primary key increases it's value by one: id | first_name | last_name ------------------------------ 1 | John | Smith 2 | Jane | Doe But if I delete record 2, the next one I insert is going to have an id of 3. Is there any way to make it have an id of 2 automatically (without having to manually insert it)?

  Read the article

• join two table for insert data in database in android

  - by shadi

  I have two table(t1,t2) in android, t1 has a primary key that it is foreign key for t2,i want to insert data to this tables,is it necessary to join these two table?if yes, what is code for join these table? i insert data in one of them like this: public long insertQuote(String Quote,int Count1 ) { ContentValues initialValues = new ContentValues(); initialValues.put(GoodName, Quote); initialValues.put(CartID, Count1); return db.insert(DATABASE_TABLE, null, initialValues); }

  Read the article

< Previous Page | 85 86 87 88 89 90 91 92 93 94 95 96  | Next Page >