Monday, March 26, 2012

problems with sp_makewebtask(replaces the tags for nothing )

Hi,
i have a code that uses makewebtask and it works fine in development
enviropment (SQL SERVER 8.00.760(SP3)), when that code is uploaded to
production it doesn't works fine(the tags where data must be inserted,
appears in blank, no data is inserted in template file).
production server has:
sql server enterprise ediction(64-bit) 8.00.2039(SP4)
Can someone help me' where is the problem' version,rights...
regardsHi,
Does the query you define in the @.query parameter for the
sp_makewebtask stored proc produce a non-empty result set when defined
on it's own? (E.g. does running it through Query Analyzer produces a
non-empty result set)|||yes, the same query in query analyzer returns data.
to check that i tried some code like that:(create the file with empty tags)
USE pubs
GO
EXECUTE sp_makewebtask @.outputfile = '\\machine\kfit\TMP\MULTIPLE.HTM',
@.query = 'SELECT title, price FROM titles SELECT au_lname, au_fname
FROM authors SELECT pub_id, pub_name FROM pubs..publishers SELECT au_lname,
au_fname FROM authors',
@.dbname = 'pubs', @.rowcnt = 5, @.whentype = 9
GO
that code returns that in a query analyzer:
"nate.vu@.gmail.com" wrote:

> Hi,
> Does the query you define in the @.query parameter for the
> sp_makewebtask stored proc produce a non-empty result set when defined
> on it's own? (E.g. does running it through Query Analyzer produces a
> non-empty result set)
>|||Sorry for the late reply.
When you port to production do you just call sp_makewebtask? Maybe
instead of that run through the Web wizard and see what results you
get.
I can't really think of anything else. Sorry I can't be of more help

No comments:

Post a Comment