Javascript ADO Problems Access Database

[robotman757]

I have tried a few different attempts to get form data inserted into my db to no avail. The form that is submitted is dynamically created and could have several hundred form elements. I can get the values into an array and that is working fine. The 2 arrays I have are called fields and fieldval[x] fields never changes, but fieldval represents a different row in the table. The arrays work fine, but I can't seem to loop the array and insert the data into the database. I know the db opens and closes correctly. Any ideas?!! Or examples??

 

[jemminger]

not sure about the exact jscript equivalent since i use vbscript, but i do it like so (approximately):

set rs = server.createobject("adodb.recordset&quot
rs.open "select top 0 from myTable", cn, adOpenStatic, adLockPessimistic, adCmdText

rs.addnew()

for x = 0 to ubound(fieldval)
rs("columnName&quot = fieldval(x)
next

rs.update()

set rs = nothing



=========================================================
while (!succeed) try();
-jeff

 

[robotman757]

Thank you for the response, but I fixed my problem after posting this message. I forgot to come back and post it was fixed!! I had been using vbscript when I first started writing asp pages, but I have learned to like just how much you cn do with javascript!! I will now use javascript for both client and server scripting!!

 

[lisalis99]

What would the exact syntax be for Javscript? I think I can use this... Thanks, Lisa