You searched for the word(s): userid:846673

More Search Options

RSS Available

• Setup is missing the browse button

  MSI package that I created for web service project is missing the browse button for the location where system admin will choose the location for the website contents. Our company host many different sites and every department has their own directory or file system where the contents need to go. Hope it's making sense. (basically, i just dont want msi to dump stuff inside c:\inetpub\www folder. I want system admin to pick a place where the new site be).

  Posted to Installation and Setup (Forum) by qarjami on 12/24/2009

• Re: something is wrong here...

  Erik 1. Actually, all the ramifications have been done by my team lead and he suggested this would be only way to accomplish what we are trying to achieve. 2. We will only be inserting one row at a time so someone inserting multiple rows is not an issue. 3. How am I spoon fed? I am doing all the work and how is it disrepectfull to anyone. I am lost on this one. I didnot ask anyone to write me the whole script. I wrote it and have had few issues and that is I used this forum to get an answer. 4. I

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by qarjami on 12/10/2009

• Re: something is wrong here...

  Got it. Thanks all for help.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by qarjami on 12/10/2009

• Re: something is wrong here...

  Still the same error. I took out all the lookup statement (select * from watever wehre id-id) and still the same. ------------------------*/ Msg 156, Level 15, State 1, Procedure it_myTrigger, Line 46 Incorrect syntax near the keyword 'FROM'. Msg 102, Level 15, State 1, Procedure it_myTrigger, Line 53 Incorrect syntax near '+'.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by qarjami on 12/9/2009

• Re: something is wrong here...

  It's now working except the last concatenate piece for the email body. Msg 102, Level 15, State 1, Procedure it_myTrigger, Line 53 Incorrect syntax near '+'.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by qarjami on 12/9/2009

• Re: something is wrong here...

  As I understood reading from diff blogs that Trigger handle one record at a time.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by qarjami on 12/9/2009

• something is wrong here...

  Can anyone please verify this trigger? keep getting errors. USE [myDATABASE] GO /****** Object: Trigger [dbo].[it_myTrigger] Script Date: 12/09/2009 07:45:05 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER [dbo].[it_myTrigger] ON [dbo].[Dodge] FOR INSERT AS DECLARE @runDateTime datetime, @UserName varchar(100) set @runDateTime = GETDATE() set @UserName = system_user BEGIN TRY -- INSERTING RECORD INTO ANOTHER DATABASE INSERT INTO [2NDDATABASE].[dbo].[TABLE1] (ID, LName, FName

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by qarjami on 12/8/2009

• Re: update stored procs

  Great. Great. Thanks mike for educating me. It's all working now. I have it in my web services so I had to use public. Then I had to create class wrapper for that web services. I create a client in winform (c#) to verify and it's working. Thanks Again.

  Posted to Data Access and ObjectDataSource Control (Forum) by qarjami on 12/4/2009

• update stored procs

  I have over 40 stored procs (all for update method) and they all take different sets of parameters to update 40 different tables. all the stored proc named after the pertaining table. for example, usp_updateEmployees and this one only takes 6 parameters (id, last, first, dob, doh, status). another example, usp_updateProject and this one takes 4 parameters (id, projectid, startdate, status) I would like to create one generic class where end user will pass table name and parameters. i would like class

  Posted to Data Access and ObjectDataSource Control (Forum) by qarjami on 12/3/2009

• Re: update stored procs

  Thanks Mike for your reply with code. I will check the link too. Just wondering why Static (i know u dont have to create an instance of that class) ? Thanks......

  Posted to Data Access and ObjectDataSource Control (Forum) by qarjami on 12/3/2009