I am building a drag'n'drop gui builder in Javascript. So far so good. As I add items to the GUI and configure them; I have two mechanisms for addressing them: the 'class' - which I use for doing things to all instances of an item (eg CSS, generic functionality and so on and so forth) and which I can bind javascript libraries to... an...
WinForms / C# My application allows the user to specify 1) additional information for 2) a given file, both of which are uploaded to the server. There are two isolated uploads: first the file, and (maybe much) later the metadata. Please assume the file to be always unchanged and available (to the code). When the metadata is uploaded,...
I am using a dataset to insert data being converted from an older database. The requirement is to maintain the current Order_ID numbers. I've tried using: SET IDENTITY_INSERT orders ON; This works when I'm in SqlServer Management Studio, I am able to successfully INSERT INTO orders (order_Id, ...) VALUES ( 1, ...); However, it doe...
Due to a rather brilliant oversight in my current project, we have some guids getting stored in a varchar column in one table, which need to be compared to a uniqueidentifier column in another. How can I do this? SQL server simply says it cannot convert from a character string to a uniqueidentifier. ...
I need to generate unique record id for the given unique string. I tried using uuid format which seems to be good. But we feel that is lengthly. so we need to cutdown the uuid string 9f218a38-12cd-5942-b877-80adc0589315 to smaller. By removing '-' we can save 4 chars. What is the safest part to remove from uuid? We don't need unive...
Say you have a pay-site with some online courses. And you want to make sure that one person doesn't just buy access, and then give the username and password to all his friends, so they can do the courses for free. How would you go about this? What we've thought of so far: IP tracking SMS password for each entry Max number of runs thr...
Hello! I have about 20 classes for different messages and this number are growing. Each class has a unique ID, so I can transform the class on a byte[] with my own method of serialization and then transform a byte[] again on my class with this uniqueID. All my messages are children of a BaseMessage class that already implements the uniq...
I'm implementing a system to send Messages between different parts of a program I'm writing. There are some generic message types as well as some specific to each part of the program. I would like to avoid the hierarchy rot inherent in deriving from a base message class for each type, So i'm encapsulating this type in an int or ushort....
Hi, I'm looking for the best way to create a unique ID as a String in Java. Any guidance appreciated, thanks. I should mention I'm using Java 5. ...
A table I have no control of the schema for, contains a column defined as varchar(50) which stores uniqueidentifiers in the format 'a89b1acd95016ae6b9c8aabb07da2010' (no hyphens) I want to convert these to uniqueidentifiers in SQL for passing to a .Net Guid. However, the following query lines don't work for me: select cast('a89b1acd950...
I am currently working on a project where some (significant) data corruption has occurred. Specifically the database is using GUIDs as primary keys on most tables, however it is not enforcing data integrity between those tables (due to a long-winded "this was bought from another company and integrated with our stuff" discussion). There...
Hello, I am looking to implement a similar url as stackoverflow to an eshop: http://wwww.shop.com/products/123123/product-name But i have a few concerns: 1. does google consider it duplicate content as the page: http://wwww.shop.com/products/123123/ I knew that google alwasy goes down the url, does it not consider the numbers as ...
The value will be used as: from INTEGER UNSIGNED NOT NULL which defines different visitors that haven't login. How to properly generate that number with PHP? EDIT: If using database as follows: create table user_visits( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, primary key(id) ); How to insert a new record into it? ...
Does anybody know how I can map the "UniqueID" property to a managed property so I can display it in the advanced search results? This property is not visible when I try to create a new managed property using Metadata Property Mappings link in shared services administration. Using the SiteData or Lists web service I can see the "ows_Uni...
I'm fairly well versed in SQL server performace but I constanly have to argue down the idea that GUIDs should be used as the default type for Clusterd Primary Keys. Assuming that the table has a fairly low amount of inserts per day (5000 +/- rows / day), what kind of performace issues could we run into? How will page splits affect our ...
I need to store posts from users. Their usernames are unique and I'm sure they can't make posts at the same millisecond. Then the URL of their post would contain /Username/12345678890/title-of-the-post I can't use the Auto_Inc number as I don't know it in the DB. want them to know the number or be able to guess. Is this sufficient e...
I am trying to set a unique identifier in my customer table from the unique identifer from my membership table (asp.net membership). However I am getting a null reference exception when doing so. This is the code. Customer customer = db.Customers.SingleOrDefault(c => c.Id == Convert.ToInt32(formValues["CustomerId"])); Guid userId = ...
Can anyone tell me if there is an equivalent of SCOPE_IDENTITY() when using GUIDs as a primary key in SQL Server? I don't want to create the GUID first and save as a variable as we're using sequential GUIDs as our primary keys. Any idea on what the best way to retrieve the last inserted GUID primary key. Thanks in advance! ...
Is there a common formula that could provide a unique value for a 512 character file path, assuming one 32 bit byte per character, and possibly limiting the characters used in the names? I know that if you just used uppercase letters alone the combination would be grossly more than a 32-bit int, but what about using an identity field wi...
Say I have two classes which extend Event: public class CustomEventOne extends Event { public static const EVENT_TYPE_ONE:String = "click"; //... rest of custom event and public class CustomEventTwo extends Event { public static const EVENT_TYPE_TWO:String = "click"; //... rest of custom event Is it ok that they...