Inserting INT type insql database

<i><b>Originally posted by : adit (adit@cdgmmp.com)</b></i><br />YOUR RESPONSE:<br /><br /> <br />Inserting int type<br /> <br />adit - 15 Feb - 01:35:37 AM<br />--------------------------------------------------------------------------------<br />hello<br /><br />i'm looking to insert int type field in to a sql database through ASP. <br /><br />but i'm finding it difficult to do that as it says subscript out of range.<br /><br />all the char type fields are working perfectly.<br /><br />this is what i'm using as my scrpt :-<br /><br />mySQL ="INSERT into viewcard(id,sender,receiver,date,size,text,subject ,url,bg,type,body,last)"<br />viewcard.id.autoincrement=true<br />mySQL=mySQL+" Values("& datcols(0) &",'"&datcols(1)&"','"&datcols(2)&"','"&datcols(3)&"','"&datcols(4)&"','"&datcols(5)&"','"&datcols(6)&"', ....)"<br /><br />please give me some suggestion<br /><br /> <br /> <br /><br />