how to update this database table

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

how to update this database table

Logged in as: Guest

arrSession:exec spGetSession 2,3,25816

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> how to update this database table
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

how to update this database table - 9/11/2005 2:45:46 PM

gilgalbiblewheel

Posts: 14
Score: 0
Joined: 4/6/2005
From:
Status: offline

I need some guidance. I have:
[CODE]
<td><%=rs("id")%></br>
<input type="hidden" name="id_<%=intRec%>"
value="<%=rs.Fields("id").Value%>">

<textarea name="gemetria_<%=intRec%>"
id="gemetria_<%=intRec%>">
</textarea>

           <select name="insert" id="insert" size="1" style="width:150;">
           <option value="passages">passages</option>
           <option value="projective link">projective link</option>
           <option value="book number linked to book number">book number linked to book number</option>
           <option value="book number linked to chapter number">book number linked to chapter number</option>
           <option value="book number linked to verse number">book number linked to verse number</option>
           <option value="book number linked to number in text">book number linked to number in text</option>
           <option value="chapter number linked to book number">chapter number linked to book number </option>
           <option value="chapter number linked to book number">chapter number linked to book number</option>
           <option value="chapter number linked to chapter number">chapter number linked to chapter number</option>
           <option value="verse number linked to verse number">verse number linked to verse number</option>
           <option value="book number linked to number in text">book number linked to number in text</option>
           <option value="number linked to book">number linked to book</option>
           <option value="number linked to chapter">number linked to chapter</option>
           <option value="number linked to verse">number linked to verse</option>
           <option value="number linked to number">number linked to number</option>
           <option value="alphanumeric word">alphanumeric word</option>
           <option value="non-alphanumeric word">non-alphanumeric word</option>
           <option value="spoke of number in text">spoke of number in text</option>
           <option value="word gemetrial passage">word gemetrial passage</option>
           </select>
</td>
[/CODE]

To each record I have assigned a textarea, a hidden and a select option dropdown. Within the table where updating is made I already have ID numbered. It has to update where the ID = <%=intRec%>.

I have difficulty setting up the response page. This was a model code where changes should be made:

[CODE]
Dim connStr, ans, i, rs, SQL, objConn
Dim TheString, ArrayTemp, NumberOfWords, Word

Dim insert
Dim passages
Dim intRec

insert = Request.Querystring("insert")
gemetria = Request.Querystring("gemetria")

connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("Kjv.mdb")
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open connStr
Set rs = objConn.Execute("SELECT * FROM insertanswer")

If Not rs.EOF Then
    Dim gemetria
    Dim iCounter
    iCounter = 0
    Do Until rs.EOF

SQL = "UPDATE insertanswer "
SQL = SQL & "SET passages = '" & gemetria & "'"
SQL = SQL & " WHERE id = id_" & intRec
        objConn.Execute(SQL)
[/CODE]

I get:
[QUOTE]Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters [/QUOTE]

Post #: 1

RE: how to update this database table - 9/12/2005 3:02:53 PM

gilgalbiblewheel

Posts: 14
Score: 0
Joined: 4/6/2005
From:
Status: offline

I have:

but because of a loop it goes on and on. I only want to update the textareas where there are things written therein.

How should I do it?

(in reply to gilgalbiblewheel)

Post #: 2

RE: how to update this database table - 9/25/2005 6:45:55 AM

icode4u

Posts: 7
Score: 0
Joined: 9/24/2005
Status: offline

I dont see a where clause in your sql string
Set rs = objConn.Execute("SELECT * FROM insertanswer")
so it will update every record in the table with your request vars.
IF what is not EOF the entire table?
Your only passing one record to be updated with with one textarea and one option value so why are you looping.
update table set column = var where column = var ' one record many fields

(in reply to gilgalbiblewheel)