Mark,
Try 'hardcoding' your WHERE keyword into the SP and just pass the
conditions.
ie.
Don't pass 'WHERE yadda = yaddayadda...'
Pass 'yadd = yaddayadda...'
then
...
SELECT count (*) as noofrecords
FROM NPO_IRS_primary
WHERE @where
Courtney E. Payne, Developer
Fig Leaf Software
"We've got you covered"
[EMAIL PROTECTED]
www.figleaf.com
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 1:30 PM
To: CF-Talk
Subject: Re: You are a stored Proc god if you can answer this...
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.
------------------------------------------------------------------------------
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.