Forum Replies Created

Viewing 15 posts - 466 through 480 (of 540 total)

  • RE: Substitute NULL value on converted date field?

    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,...

  • RE: ASP Web Front End??

    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...

  • RE: Copy from Database A to Database B

    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...

  • RE: Format Date Field in Web Front End

    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...

  • RE: ASP Web Front End??

    Thanks Steve.

    Phil.

  • RE: Add Report Filter

    Thanks. datetime in answer to your question. I will give your code a try tomorrow.

    Phil.

  • RE: ASP Web Front End??

    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...

  • RE: ASP Web Front End??

    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...

  • RE: ASP Web Front End??

    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...

  • RE: ASP Web Front End??

    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...

  • RE: ASP Web Front End??

    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.

  • RE: Mask Password

    Thanks Steve, I will have a read up on asymmetric keys.

    Phil

  • RE: Mask Password

    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...

  • RE: Mask Password

    Thanks I will have a read.

    Phil

  • RE: Visual Studio 2005

    Thanks Matt. I am just beginning the long journey................SQL Guru by 2030!!

    Many Thanks,

    Phi.

Viewing 15 posts - 466 through 480 (of 540 total)