Search Results

Search found 5527 results on 222 pages for 'unique constraint'.

Page 100/222 | < Previous Page | 96 97 98 99 100 101 102 103 104 105 106 107  | Next Page >

• views count calculation

  - by Alexey Poimtsev

  Hi, could you give me idea how to calculate unique views of page? If i will increase counter on each page load it will be no good, otherside storing information of viewed pages in session looks like not ideal solution.

  Read the article

• Basic question about encryption - what exactly are keys?

  - by Tomas

  Hi, I was browsing and found good articles about encryption. However, none of them described why the key lenght is important and what exactly the key is used for. My guess is that could work this way: 0101001101010101010 Key: 01010010101010010101 //the longer the key, the longer unique sequence XOR or smth: //result Is this at least a bit how it works or I am missing something? Thanks

  Read the article

• Count total number of callers?

  - by Kristopher Ives

  I'm currently doing this query to find the guy who makes the most calls: SELECT `commenter_name`, COUNT(*) AS `calls` FROM `comments` GROUP BY `commenter_name` ORDER BY `calls` LIMIT 1 What I want now is to be able to find out how many total unique callers. I tried using DISTINCT but I didn't get anywhere.

  Read the article

• Inserting random characters to MYSQL Database

  - by spotlightsnap

  I want to add 100 entry to users table numbers field, random characters length is 10, all entry should be unique as well. How can i achieve this using MYSQL query code ? Or do i need to use PHP ? Help me with code snippets please. Thanks.

  Read the article

• How do I represent integer array as attribute of a class in Visual Studio 2010's UML class diagrams?

  - by AndrejaKo

  How do I represent integer array as attribute of a class in Visual Studio 2010's UML class diagrams? I know hot to add normal integers, but I'm hoping that there is a way to do it other than adding [] to integer's name. I'm new to UML, so I could be missing something obvious here. Should I use Is ordered and Is unique?

  Read the article

• Is it possible to remove a duplicate value from a datatable in c#?

  - by Pandiya Chendur

  I have a datatable with a column MobileNo.... My datatable has 150 rows and each row has MobileNo... Now how to check every MobileNo is unique by parsing all the datarows of the datatable in c#? EDIT: "This datatable is being created by reading a CSV file"

  Read the article

• sqlite, UPDATE OR REPLACE

  - by acidzombie24

  I do something like UPDATE OR REPLACE someTable SET a=1, b=2 WHERE c=3 I expect if it doesnt exist it will be inserted into the DBs. But nothing happens and i get no errors. How can i insert data, replace it if it already exist and use a where for the condition (instead of replacing BC of a unique ID)

  Read the article

• Avoiding overload hell with c# 4.0

  - by dotnetdev

  I am using C# 4.0, how can I avoid the problem of writing lots of similiar methods because they are each parameter-unique (how can the new parameter features avoid overload hell?). Thanks

  Read the article

• Did "general education" classes make you a better programmer?

  - by Big Johnson

  I'm surprised by the number of general education classes computer science students must complete to get their bachelors. For example, I must take: three English classes two history classes public speaking economics biology I hardly think these general education requirements are unique to the university I attend. My question is (for those of you who have degrees), in what ways have these general education requirements improved your career as a programmer?

  Read the article

• How to Calculate longest streak in SQL?

  - by VJ

  I have EMPLOYEE-ID,DATE,IsPresent I want to calculate longest streak for a employee presence.The Present bit will be false for days he didnt come..So I want to calculate the longest number of days he came to office for consecutive dates..I have the Date column field is unique...So I tried this way - Select Id,Count(*) from Employee where IsPresent=1 But the above doesnt work...Can anyone guide me towards how I can calculate streak for this?....I am sure people have come across this...I tried searching online but...didnt understand it well...please help me out..

  Read the article

• Other programming languages that support implicits "a la Scala"

  - by german1981

  Hi. Scala implicits are very powerfull. I'm curious if they are a new/unique feature of Scala, or the concept already existed in other programming languages. Thanks. Note: I have used the tag "implicit" instead of "implicits" because it doesn't exists and I can't create new tags...

  Read the article

• Help getting the following create table function to work with mysql and C#

  - by Matt

  string createTable = "CREATE TABLE IF NOT EXISTS " + m_strDatabase + "_TimeLogs (logName VARCHAR(16), logTime INTEGER, logCountry TEXT, UNIQUE(logName)) TYPE=MyISAM;"; When this runs, no table is created. No errors either. Im using an ODBC connector. the variable passes in the db name, so that the table created would be users_TimeLogs if the database was called users for example. Am I doing something wrong?

  Read the article

• SQL subquery question

  - by seo20

  I have the following SQL SELECT Seq.UserSessionSequenceID, Usr.SessionGuid, Usr.UserSessionID, Usr.SiteID, Seq.Timestamp, Seq.UrlTitle, Seq.Url FROM tblUserSession Usr INNER JOIN tblUserSessionSequence Seq ON Usr.UserSessionID = Seq.UserSessionID WHERE (Usr.Timestamp > DATEADD(mi, -45, GETDATE())) AND (Usr.SiteID = 15) ORDER BY Usr.Timestamp DESC Pretty simple stuff. There are by nature multiple UserSessionIDs rows in tblUserSessionSequence. I ONLY want to return the latest (top 1) row with unique UserSessionID. How do I do that?

  Read the article

• [Android] Putting Serializable Classes into SQL?

  - by CaseyB

  Here's the situation. I have a bunch of objects that implement Serializable that I want to store in a SQL database. I have two questions Is there a way to serialize the object directly into the database Is that the best way to do it or should I Write the object out to a formatting String and put it in the database that way and then parse it back out Write each member to the database with a field that is unique to each object

  Read the article

• Are GUIDs necessary to use interfaces in Delphi?

  - by codeelegance

  The official documentation says they are optional. I know COM interop requires a unique identifier for each interface but every interface example I see has a GUID whether it's used with COM or not? Is there any benefit to including a GUID if its not going to be used with COM?

  Read the article

• Mysql - GROUP BY Avoid using tempoary

  - by jwzk

  The goal of this query is to get a total of unique records (by IP) per ref ID. SELECT COUNT(DISTINCT ip), GROUP_CONCAT(ref.id) FROM `sess` sess JOIN `ref` USING(row_id) WHERE sess.time BETWEEN '2010-04-21 00:00:00' AND '2010-04-21 23:59:59' GROUP BY ref.id ORDER BY sess.time DESC The query works fine, but its using a temporary table. Any ideas?

  Read the article

• Default FileField names for Django files

  - by Adam Nelson

  I have a model: class Example(models.Model): unique_hash = models.CharField(max_length=32,unique=True) content = models.FileField(upload_to='source',blank=True,verbose_name="HTML Content File") I would like to be able to set the content filename to default to a callable, but I don't see any way to have the callable reference unique_hash (or vice versa). Is this possible?

  Read the article

• How can I map UIDs to user names using Perl library functions?

  - by Mike

  I'm looking for a way of mapping a uid (unique number representing a system user) to a user name using Perl. Please don't suggest greping /etc/passwd :) Edit As a clarification, I wasn't looking for a solution that involved reading /etc/passwd explicitly. I realize that under the hood any solution would end up doing this, but I was searching for a library function to do it for me.

  Read the article

• Rich text box with spell checker

  - by user329755

  Hi, I have a very unique requirement for a rich text box with spell check and auto text. The spell check will not happen on any other site thus i need to have the dictionary and the spell check logic in my site only. It should be open source as i will then add auto text feature to that text box. Any help will be appreciated. Thanks.

  Read the article

• Get dialog input field IDs in CKEditor

  - by rt-uk

  Each input field in the CKEditor dialogs are renamed with a unique number, but the number changes depending on what options are visible. I need to reference 'txtUrl' which has an id something like #35_textInput. So far I have discovered that something like this should work: alert(CKEDITOR.instances.myElement.document.$.body.getId('txtUrl')); But it doesn't. Please help.

  Read the article

• FormsAuthentication AuthCookie data type

  - 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

• MYSQL autoincrement a column or just have an integer, difference?

  - by David19801

  Hi, If I have a column, set as primary index, and set as INT. If I don't set it as auto increment and just insert random integers which are unique into it, does that slow down future queries compared to autincrementing? Does it speed things up if I run OPTIMIZE on a table with its primary and only index as INT? (assuming only 2 columns, and second column is just some INT value) (the main worry is the upper limit on the autoincrement as theres lots of adds and deletes in my table)

  Read the article

• Variable Binding Class

  - by Davis

  Hi, I believe this is a tough one... I'm trying to create a collection of variable binding in a class. It is intended to look something like this: Dim x as integer, s as string Dim c as new VBindClass x = 1 s = "Hello" c.Add x, s Debug.Print c.value(x) '= 1 Debug.Print c.value(s) '= "Hello" Is there some function that allow us to retrieve a unique ID for a given variable and also get/set based on variable?

  Read the article

• Generating multiple random numbers

  - by Jasl

  I want to generate 25 unique random numbers and list them in a console. The numbers should be atleast 10 characters long. Any easy way to do that?

  Read the article

• Drupal, Views: can I use 1 filter, for many CCK fields ?

  - by Patrick

  Hi, I'm using Views in Drupal. I want an exposed filter selecting the ndoes containing a specific word. But I noticed I cannot search more then one CCK field per filter. Since I want to expose it, I want an unique text-input field for all CCK Fields: is that possible ? At the moment I can only add a new filter for each CCK field. Thanks

  Read the article

< Previous Page | 96 97 98 99 100 101 102 103 104 105 106 107  | Next Page >