I'm sure it's a requirement many developers have faced before: business needs an audit trail to know who is performing actions in their system. Regardless of how you choose store the audited information, the core of this problem is how to identify the current user. I want to write components, ranging from small domain model classes to ...
Hi all, I've had a very brief look at Windows Identity Foundation (WIF) and it looks to me like I could say that my site is going to accept logins from other sites. e.g. anyone with a gmail or LiveID account will be able to post comments on a thread in my application. When the post comment button is clicked the user is redirected to a pr...
Hi, I'm building a website using ASP.NET and SQL Server, and I use SELECT PK FROM Table WHERE PK = @@identity My question is which is better and more reliable to retrieve the last inserted PK for multiuser website, using @@identity or using this: SELECT MAX(PK) FROM Table WHERE PK = Session ("UserID") ...
I've got a T-SQL script, that converts field to IDENTITY (in a weird way). How do I convert it to PL/SQL? (and, probably, figure out, if there is a simpler way to do this - without creating a temporary table). The T-SQL script: -- alter table ts_changes add TS_THREADID VARCHAR(100) NULL; -- Change Field TS_ID TS_NOTIFICATIONEVENTS t...
What is the magical incantation to create an identity column in Oracle? ...
I stumbled upon the following python weirdity: >>> two = 2 >>> ii = 2 >>> id(two) == id(ii) True >>> [id(i) for i in [42,42,42,42]] [10084276, 10084276, 10084276, 10084276] >>> help(id) Help on built-in function id in module __builtin__: id(...) id(object) -> integer Return the identity of an object. This is guaranteed to b...
I need to write a stored procedure to insert a row into a table. The table has an Identity column called ID. My question is should I return the value and if so, how? As far as I can see, I could return it as the return value, I could return it as an out parameter, or I could do nothing with it. What would a DB programmer do as a...
I know you can compare the length but many hash types have the same lengths. So with just knowing that it is a hash is there a way to identify the type and also if its salted? example of the hash that I am working with is: hash=2bf231b0e98be99a969bd6724f42a691 hash=4ac5a4ff764807d6ef464e27e4d1bee3 hash=4d177cec31d658ed22cc229e45d7265e...
I need to find out if an object with a particular primary key is already attached to a DataContext and get the entity from the DataContext if it is attached. Is there any way at all to do this that doesn't require Reflection with full trust? Ideally, I would like to call GetCachedObject(), but I'd have to use reflection to get at that,...
Hi All, Server is setup using SSL and have come across the need to have multiple DNS names point to the same site hosted on the server. Addresses below are for demonstrative purposes.. For example, application address is: https://www.server.com/application/ . The server's identity JKS indicates that it's www.server.com. The need is t...
I am trying to insert a record and get its newly generated id by executing two queries one by one, but don't know why its giving me the following error. Object cannot be cast from DBNull to other types My code is as below: (I don't want to use sql stored procedures) SqlParameter sqlParam; int lastInsertedVideoId = 0; using (...
Hi, Say I want to develop a site with some CMS embedded in it - e.g., a Wordpress blog and phpbb forum. What's the most convenient way to unify the log-in and sign-up process for my site? Letting users have a different registration process for each part of the site would probably scare any sane user away. EDIT I prefer generic solu...
I have some trouble understanding what happens with class init arguments that are lists like: class A(object): def __init__(self, argument=[]): self.argument = argument[:] or: def __init__(self,argument=None): self.arguments = arguments or [] or: def __init__(self, argument=[]): self.argument = argume...
We have a TFS build agent that runs integration tests. Some of these tests make calls to web services on the internet. Our network uses a proxy to talk to the internet. Since the build agent runs under the identity on Network Service and the settings of Network Service are not configured to use the proxy, the tests fail. How to do one...
How would I create an IDENTITY column in SQLServer with text in the column? Example: ABCD-987065 ABCD-987066 ABCD-987067 ...
I'd like to create a piece of code that can be embedded on many different websites (widget). Is there any way that my code can identify a user without them logging in? I.e, can I use any of the established identity mechanisms floating around the web to reliably identify them across instances of this widget? I don't need to (nor shoul...
Straight out of the MSDN docs for Sql Server 2005: You cannot use TRUNCATE TABLE on tables that: Are referenced by a FOREIGN KEY constraint. Participate in an indexed view. Are published by using transactional replication or merge replication. I want the effect of a TRUNCATE (specifically the fact that it resets IDENTITY ...
Hi, I am building a Python web application and we will need a user identity verification solution... something to verify the users identity during account registration. I was wondering if anyone had any experience in integrating such a solution. What vendors/products out there have worked well with you? Any tips? I don't have any expe...
How do you access the user's Google Account Id / username in code (pre-2.0)? I am building an application that will call a web service to store data and I want to identify the identity of the person sumitting the data. If no user identity information available (pre 2.0) how about the ability to access phone identity (pre 2.0). Thanks i...
I am currently looking for a verification service for personal and business. For example I will have a user either pick a personal or business account for the website. If the user decides on having a personal account than they would have to be check from the verification service to prove their identity. I am not sure if there is even a s...