CreateParameter for Command object

<i><b>Originally posted by : Ted (TidyTed@yahoo.com)</b></i><br />Does any one know what the numbers in "CreateParameter" mean?<br /><br />cmd.Parameters.Append cmd.CreateParameter("UserName", 200, 1, 35, Request.Form("YourName"))<br /><br />Is there a referece for what they mean anywhere?<br /><br />Thanks<br /><br />Ted<br /><br />

<i><b>Originally posted by : Jon Wright (Jonathan.Wright@bubball.com)</b></i><br />Hi Ted,<br /><br />The numbers are for: datatype, direction, size.<br /><br />i.e The first number in your example '200' is the number for the datatype varchar, the second '1' means that your going to input the value to your database, the third means th size of your datatype - in this case a varchar the size being 35.<br /><br />For a more details on "CreateParameter" and the numbers I recommend you go to the MSDN library page: <br /><br />http://msdn.microsoft.com/library/psdk/dasdk/mdae8o19.htm<br /><br />Best of luck<br /><br />Jonathan Wright<br /><br />------------<br />Ted at 9/4/2000 11:02:47 AM<br /><br />Does any one know what the numbers in "CreateParameter" mean?<br /><br />cmd.Parameters.Append cmd.CreateParameter("UserName", 200, 1, 35, Request.Form("YourName"))<br /><br />Is there a referece for what they mean anywhere?<br /><br />Thanks<br /><br />Ted<br /><br />