I have used the wizard to make a web page, I opted for the refresh on data change feature.
My web page however is only showing the data as at the time I used the web wizard. The data has changed.
I saved the wizard SQL statement and am happy that the field that changes will be an actual changing field. IE @whentype=10, @datachg=N'TABLE=DailyData COLUMN=ID'.
I have run sp_runwebtask manually in query analyser and then refreshed my web page and it works fine.
So how does the updating of data in the table fire off the sp_runwebtask??
Mine doesn't seem to.