In a message dated 10/9/00 1:10:09 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
<< tried:
CREATE PROCEDURE [Search_RC] @where varchar(255)
AS
SELECT count (*) as noofrecords
FROM NPO_IRS_primary
@where
No luck... >>
Your missing the 'WHERE' part of the where clause .... should be something
like:
WHERE [field] = @where
or if the entire where clause text is contained in @where then you will need
to create the entire SQL statement in SQL and then Execute it.
Bill
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.