[thelist] ASP & the Find Method
rudy
r937 at interlog.com
Tue Dec 3 13:58:01 CST 2002
> "Rowset does not support scrolling backward. "
sorry, can't help with that problem, but i have a suggestion
it looks like you are bring back the entire table with your query, and then
trying to find the row with a First_Name field equal to the form field
my recommendation is to let the database do the search, and instead of
returning the entire result set, return just the row you're interested in
here's your query with the appropriate WHERE clause added --
SELECT CallLog_Table.First_Name
, CallLog_Table.Last_Name
, CallLog_Table.Building
, CallLog_Table.Room_Number
, CallLog_Table.Date
, CallLog_Table.Time
, Log_Table.[Last Name]
, Log_Table.[Completed_(Y/N)]
, Log_Table.Completed_By
, Log_Table.Problem
, Log_Table.Resolution
FROM CallLog_Table
INNER
JOIN Log_Table
ON CallLog_Table.Last_Name = Log_Table.[Last Name]
WHERE Log_Table.[First_Name] = 'varFName'
note that everything up and including the single quote in front of varFName
is a string
then you concatenate the value of varFName, and then concatenate the closing
single quote
holler if that didn't make sense
rudy
More information about the thelist
mailing list