gilgalbiblewheel
Apr 9th 2005, 3:02 pm
All I want to insert is the "new_gemetria" field. Is it necessary to enter all the "p_"s as shown below. Since all the rest of the fields are already inserted.
if linkSet.EOF then
p_new_id = 1
else
p_new_id = linkSet("new_id") + 1
end if
p_new_id_in = Request.querystring("p_new_id")
if p_new_id_in <> "" then
linkSet.Find "new_id = " & p_new_id_in
end if
if p_new_id_in = "" or linkSet.EOF then
p_new_recordType = ""
p_new_book_spoke = ""
p_new_chapter_spoke = ""
p_new_verse_spoke = ""
p_new_book = ""
p_new_chapter = ""
p_new_verse = ""
p_new_text_data = ""
p_new_gemetria = ""
else
p_new_id = p_new_id_in
p_new_recordType = linkSet("new_recordType")
p_new_book_spoke = linkSet("new_book_spoke")
p_new_chapter_spoke = linkSet("new_chapter_spoke")
p_new_verse_spoke = linkSet("new_verse_spoke")
p_new_book = linkSet("new_book")
p_new_chapter = linkSet("new_chapter")
p_new_verse = linkSet("new_verse")
p_new_text_data = linkSet("new_text_data")
p_new_gemetria = linkSet("new_gemetria")
p_existing = p_new_id_in
end if
if linkSet.EOF then
p_new_id = 1
else
p_new_id = linkSet("new_id") + 1
end if
p_new_id_in = Request.querystring("p_new_id")
if p_new_id_in <> "" then
linkSet.Find "new_id = " & p_new_id_in
end if
if p_new_id_in = "" or linkSet.EOF then
p_new_recordType = ""
p_new_book_spoke = ""
p_new_chapter_spoke = ""
p_new_verse_spoke = ""
p_new_book = ""
p_new_chapter = ""
p_new_verse = ""
p_new_text_data = ""
p_new_gemetria = ""
else
p_new_id = p_new_id_in
p_new_recordType = linkSet("new_recordType")
p_new_book_spoke = linkSet("new_book_spoke")
p_new_chapter_spoke = linkSet("new_chapter_spoke")
p_new_verse_spoke = linkSet("new_verse_spoke")
p_new_book = linkSet("new_book")
p_new_chapter = linkSet("new_chapter")
p_new_verse = linkSet("new_verse")
p_new_text_data = linkSet("new_text_data")
p_new_gemetria = linkSet("new_gemetria")
p_existing = p_new_id_in
end if