web page generation task

• Chlijack

  SSC Rookie

  Points: 36

  More actions

  April 12, 2004 at 7:26 am

  #82648

  Hi all,

  After running the following task I get an error (Server: Msg 8114, Level 16, State 4, Procedure sp_makewebtask, Line 0

  Error converting data type nvarchar to tinyint.)

  Any Ideas?

  USE MyDB

  EXEC sp_makewebtask

    @outputfile='c:\InetPub\WWWRoot\aa\title.html',

    @query='SELECT *

            FROM Titles',

    @HTMLHeader=1,

    @webpagetitle='Title Page',

    @resultstitle= 'Title Page',

    @whentype=8,

    @numunits=l,

    @unittype=2,

    @procname=web_CreateTitlePage

   

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  April 12, 2004 at 8:00 am

  #502406

  You have an L in @numunits instead of a 1.

  ---

  
  Shamless self promotion - read my blog http://sirsql.net