Viewing 15 posts - 466 through 480 (of 540 total)
Thanks for the quick response. I looked up the ISNULL prior to posting but could not get it to work!
Tried:
SELECT SalesOrderId, convert (varchar, (ISNULL(CustomFieldValueDate,'No Date',103))AS ExpiryDate, Type
Have tried code below,...
April 17, 2008 at 2:44 am
Thanks Dan. I am a novice programmer so not too hot at writing my own functions at this time!
The site is to enable users (internally) to view data from our...
April 16, 2008 at 6:33 am
I do not think I can do what I want to do! Well not easily and without a lot of thought.....
Basically I am working on a non-production database. I want...
April 14, 2008 at 10:00 am
Thanks Karl. I just managed to format via Visual Web Developer as follows:
Grid View / Edit Column / DataFormatString = {0:dd/MM/yyyy}
I will run the SQL version as I would prefer...
April 4, 2008 at 4:56 am
Thanks. datetime in answer to your question. I will give your code a try tomorrow.
Phil.
March 26, 2008 at 1:44 pm
Thanks guys. Steve I need to read up on Roles etc...........If possible I would like to remove db_owner as suggested.
Steve do you refer to the ApplicationPool Identity regards IIS sending...
March 26, 2008 at 10:33 am
Hi Guys. I have now managed to resolve the Login issue. I had a local SQLEXPRESS installation. I uninstalled this as I read in a post elsewhere that this might...
March 22, 2008 at 8:44 am
OK. I re-created the site. My web.config file looks as follows (see attached .txt file).
The error I receive is as follows:
The user instance login flag is not supported on this...
March 22, 2008 at 4:54 am
Thanks for the reply's gents. I have gone back to basics (deleted the site). I now have to retrace my steps then implement your suggestions and hopefully get it all...
March 22, 2008 at 3:56 am
Hi. SQL Server Configuration is all OK. Server runs a few databases. I have just added aspnetdb as part of the Web Development.
Thanks,
Phil.
March 20, 2008 at 5:46 am
Thanks Steve, I will have a read up on asymmetric keys.
Phil
March 15, 2008 at 10:22 am
Back again. I am running SQL 2005 on a XP Pro machine. Here is what I did:
create master key encryption by password = 'Pufd&s@))%';
create certificate cert_sk_admin with subject = 'Certificate...
March 15, 2008 at 7:09 am
Thanks Matt. I am just beginning the long journey................SQL Guru by 2030!!
Many Thanks,
Phi.
March 11, 2008 at 2:15 am
Viewing 15 posts - 466 through 480 (of 540 total)