Tougher Question--over my head

Question

Tougher Question--over my head

Joe M-482062

Right there with Babe

Points: 784
More actions
September 4, 2007 at 8:39 am

#178261

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

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

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Joe M-482062 Right there with Babe Points: 784 More actions · Answer 2

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