View Single Post
  #2 (permalink)  
Old April 10th, 2016, 09:55 PM
mat41 mat41 is offline
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default

Where is your form? You need to post a form to the page to all this to work:

CompanyID_Merge=Request.Form("CompanyID_Merge")

without a form this can not work. You need a form tag, submit button. Then move your ASP to the top of the page and check of the form collection has a value e.g:

Code:
<% 
if trim(Request.Form("CompanyID_Merge")) <> "" then
	CompanyID_Merge=Request.Form("CompanyID_Merge")
	Conn.Open strConn
	SQL  = "SELECT Projects.CompanyID, Projects.ProjectID, Projects.ProjectName, Projects.SeasonYear, Seasons.Season, " & _
	"Activities.ActivityName WHERE Projects.CompanyID = " & CheckNumber(CompanyID_Merge) & ";"
    SET RS = Conn.Execute(SQL)
else
   response.write "There is nothing in the form collection to process...."
end if
%>
__________________
Wind is your friend
Matt
Reply With Quote