Hiya chaps
I have a table called movements which tracks the issuing of safety wear etc.
movement_id int (identity yes)
emp_no char(8)
clothing_id int (fk)
create_dte smalldatetime
create_by_emp_n o char(8)
clothing_price decimal
I need to create a function that will check first that a user has or has not received an item (param clothing_id)
if they have not then insert...
pbeeke
Last Activity: Feb 27 '08, 09:37 AM
Joined: Feb 27 '07
Location:
-
Problem In This Code
Can anyone fix this for me. I know that I can achieve what I want using triggers but for some reason our DBA will not allow them. The first part of the code takes a weeks classes and inserts a carbon copy into the table a number of times using a paramater repetitions. On creation of each class there should be and insert into a sessions table and an insert into a slots table. Any help would be great.
CREATE PROCEDURE [dbo].[ins_multiple_we eks]... -
Diary Schedule Insert
Does anyone know how I could take a weeks entries in a table and copy and insert the same entries into the same table but with the starting date a week on.
class_id class_dte class_start_tim e class_end_time class_name class_def_id
6 21/11/2007 13:25 19/11/2007 11:00 19/11/2007 12:00 Spanish 1
8 21/11/2007 14:44 19/11/2007 12:00 19/11/2007 13:00 French 1
9 21/11/2007 14:48 19/11/2007 16:30 19/11/2007 17:30 Maths 3
... -
Sorry Nathan yes you are right I am inserting not updating and yes one of the fields that I want to prefill is the primary key [project_ID] and [emp_no] which is a required paramater needed for the insert.
Thanks in advance -
Can you prefill DataGrid footer template fields
Can you prefill DataGrid footer template fieldswith items from the same datagrid. For example I am using the footer template in the grid in order to add a new record. THe query that updates the record needs a primary key and an employee number - both of which appear on every row in the datagrid. Does anyone know how I can prefill these two footer fields.
Thanks -
Probably A Scope State Problem
Hello I am using asp.net 2.0 and SQL Server Database.
I am using a class object to populate a table in a web form with approx 15 fields (not a datagrid etc) This class uses a DBHelper Class that is basically a wrapper for all sql strored procedures to SQL Server database for this project. There is a button on this form that I use to start an EDIT furnction. When pressed an Edit Form Loads and the same object class is used to populate... -
Forget It I have found what I needed in a responsive forumLeave a comment:
-
Passing Objects
Hello
Can you pass an object to a javascript function. For example I have a calendar example that I want to make more user friendly. The original coding is here
function ShowDate()
{
var cSearchValue=sh owModalDialog(" Calendar.asp",0 ,"dialogwidth=2 98px;dialogheig ht=280px");
if (cSearchValue != -1 && cSearchValue != null && cSearchValue != "")...
No activity results to display
Leave a comment: