' Spstring.sql
If exists (select name from sysobjects where name = ' sprocstring ')
drop proc Sprocstring
Go
CREATE PROCEDURE sprocstring
@pTitle varchar (80)
As
SET NOCOUNT on
SELECT
*
From
Titleview
WHERE
Title = @pTitle
or @pTitle = ' * '
' Toolbar.asp
<%
' 05/02/98
' Added The following features:
' Tab Query String Parameter
'-This is the selected tab ' s Tabarray index value.
' Page expiry time
'-the page would expire when downloaded by browser so this user is insured to all data
' would be current.
' DrillDown Tabs
'-Added in the session ("Tabarray") object to keep track of the drill down tabs.
' Search
'-Added javascript window.alert function call to indicate when text isn't found in Rpt view.
' Goto Page Text Box
'-Added textbox and filenew.gif so user can enter and request desired page number.
' Note:netscape 2.0 browsers does not call the ' in ' submit event handler when the image is selected.
' Thus, the user won't be warned when incorrect the data was entered into the Goto page box.
' This problem does is not happen the user selects return.
Response.Expires = 0
' Viewer Tab Images
Drilld = "Drillu = "Previewu = "previewd = "' Set the correct numbers on the paging buttons
Brch = Request.QueryString ("Brch")
If Brch <> "" Then
Brch = "&" & "Brch=" & Brch
BasePage = "<a href=" & Chr (+) & "javascript:parent.parent.location=" rptserver.asp?init=html_frame& Page=1 ' "& Chr (+) &" > "
