Plz Help ASAP

phantom3008 · February 15th, 2007, 05:34 PM

now when i'm trying to save it . it gives an error mess
Microsoft OLE DB Provider for ODBC Drivers (0x80040E31)
Out of range value adjusted for column 'sSim_mthpyldsize' at row 1
/save_inc.asp, line 79

phantom3008 · February 15th, 2007, 05:35 PM

here is what i have . I want to add things in BOLD .
sSim_num = Request.Form("sSim_num")
    sSim_host = split(Request.Form("sSim_host"),"|")
    sSim_dir = split(replace(Request.Form("sSim_dir"),"\","\\")," |")
    sSim_ip = split(Request.Form("sSim_ip"),"|")
    sSim_sid = split(Request.Form("sSim_sid"),"|")
    sSim_num = split(Request.Form("sSim_num"),"|")
    sSim_start = split(Request.Form("sSim_start"),"|")
    sSim_PIN = split(Request.Form("sSim_PIN"),"|")
    sSim_dupPIN = Request.Form("sSim_dupPIN")
    sSim_authKey = split(Request.Form("sSim_authKey"),"|")
      sSim_pyldsize = split(Request.Form("sSim_pyldsize"),"|")
      sSim_contype = split(Request.Form("sSim_contype"),"|")

    sql = "delete from srpcSims where id="&projID
LIne 79:db_conn.execute(sql)
    for i=0 to (sSim_num-1)
        sql = "insert into srpcSims values (null,"&projID&",'"&sSim_host(i)&"','"&sSim_dir(i) &"','"&sSim_ip(i)&"',"&sSim_suid(i)&","&sSim_numBE S(i)&","&sSim_startPIN(i)&","&sSim_numPIN(i)&","&s Sim_dupPIN&",'"&sSim_authKey(i)&"','"&sSim_mthpyld size(i)&"','"&sSim_contype&"')"
        db_conn.execute(sql)
    next

    'generationDate = Request.Form("date")
    'sql = "insert into generationDates values (" & projID & ",'" & generationDate & "')"
    'db_conn.execute(sql)

    'db_rec.close
    db_conn.close
    set db_rec = nothing
    set db_conn = nothing

end if

Plz help

dparsons · February 15th, 2007, 05:44 PM

I think whatever is in this value: sSim_mthpyldsize(i) is to large for the column you are trying to insert into.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

phantom3008 · February 15th, 2007, 05:51 PM

I want to put say 34000 34000 as default in sSim_mthpyldsize(i) so that if needed
it culd be changed,.. so how should i make these fit in there ??

dparsons · February 15th, 2007, 05:53 PM

Set the column in your database to accept that many characters.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

phantom3008 · February 15th, 2007, 05:56 PM

this the info i put in to create the column :
sSim_mthpyldsize datatype:integer flags:unsigned ,def value : null
what change should i make ??

dparsons · February 15th, 2007, 05:59 PM

Hmmm 34000 should go into an INT field just fine. What database are you using

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

phantom3008 · February 15th, 2007, 06:22 PM

k it works now ...thanks

phantom3008 · February 16th, 2007, 11:24 AM

I'm getting this error again and again .i tried to fix this somehow it worked for sometime ,now again i have this prob ....plz help
Microsoft VBScript runtime (0x800A0009)
Subscript out of range: 'i'
/save_inc.asp, line 78

dparsons · February 16th, 2007, 11:27 AM

You are incrementing i outside the bounds of your array. Reevaulate your loop that is looping through your array.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html