September 4, 2007 at 8:39 am
Hi all, I have a question. Hopefully someone here can help me. Its possible i may be overthinking it, but i am rather stuck as my sql syntax is not too good yet.
As a background, this is a database migration that started in ACCESS, then moved to PHP and now has to be converted to SQL 2005. It has been a head banging experience the whole way, but a great learning experience at the same time.
Here is the problem. I have an aspx page that has a hyperlink to a specific number (not the id field) called ittnumber. What i did is built a drop down so that when you select a workcenter all the requirements that are open against that worksenter are displayed. You can hyperlink off that ittnumber and it opens a page with the hyperlink in the URL. All that works awesome and i am happy.
The part that is tripping me up is, i built 3 drop downs on the results page that will allow the users that control the requirements to update them in the following way: Approved/disapproved, closed, and disapproval remarks. All I want to accomplish is when someone changes those fields (by default there is nothing selected) do an update. Sounds easy intil you get to figure out how to pull that ittnumber and correlate it to the id column for that particular requirement(this is where i am stuck!)
Here is the table design:
USE [SCX_3215]
GO
/****** Object: Table [dbo].[tbl3215] Script Date: 09/04/2007 14:36:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbl3215](
[id] [int] IDENTITY(1,1) NOT NULL,
[IttNumber] [decimal](18, 0) NOT NULL,
[IttTitle] [varchar](max) NULL,
[IttDescription] [varchar](max) NULL,
[IttJustification] [varchar](max) NULL,
[TechSolution] [varchar](max) NULL,
[DateReceived] [smalldatetime] NULL,
[DateRequired] [smalldatetime] NULL,
[Customer] [varchar](max) NULL,
[OrgID] [varchar](max) NULL,
[Funded] [varchar](max) NULL,
[HBApID] [varchar](max) NULL,
[Disapproved] [varchar](max) NULL,
[DisReason] [varchar](max) NULL,
[Completed] [varchar](max) NULL,
[CompletionDate] [smalldatetime] NULL,
[Priority] [varchar](max) NULL,
CONSTRAINT [PK_tbl3215_1] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
If anyone has questions or needs more information, please let me know.
Thank You
Joe
September 5, 2007 at 11:39 am
you said you were hyperlinking to the IttNumber; why can't you simply change the hyperlink to include the Id and the IttNumber? then you can obviously use it on the page, instead of trying to figure out a way to look it up correctly again.
somepage.aspx?id=12&IttNumber=3245
Lowell
September 5, 2007 at 12:29 pm
in all honesty i never knew you could do that...
i will try it tomorrow at work at let you know.
thanks for the tip
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply