Multiple Record Insert (Check if file exist)

Hello all.
This is simple to do in a single record insert.
But, using a Multiple Record Insert, it is not quite working right.

The code below works great for Inserting Multiple Records.

I need to check if "Any" of the records exist.  
And if "Any" do then display them to the page.
Then once the user corrects them, then insert all records.

(Hope that makes since)
Code below
Set objRs1=CreateObject("ADODB.RecordSet")
getSQL1 = "SELECT ID, Email, MyFN, MyLN, Status, OrgID FROM Members"
objRs1.Open getSQL1, objConn, 1, 1, 1
Set objCommand=Server.CreateObject("ADODB.Command")
For n=1 to row
strMyStatus = request.Form("Status_" & n)
strMyID = request.Form("MyID_" & n)
strMyFN = request.Form("FirstName_" & n)
strMyLN = request.Form("LastName_" & n)
strMyEmail = request.Form("Email_" & n)
sqlOrgInsert = "Insert into Members (MyFN, MyLN, Email, Status, OrgID, Payment, PayStatus)Values('"&strMyFN&"','"&strMyLN&"','"&strMyEmail&"','NotActive', "&GetMyOrg&", 'MemPayment', 'Yearly')"

Open in new window

LVL 31
Wayne BarronAsked:
Who is Participating?
Wayne BarronConnect With a Mentor Author Commented:
I have gone a different much better easier route.

Each set of Fields that are created, have their own <form>
So, each field, is submitted once that set of fields is completed.
Using something similuar to what I have coded here, but instead of inserting all the records at one time.
I am doing it indivisually.

If I list 1 - set of fields -to- 100 - set of fields.
Each Set have it's own Uniquely nunmbers <form>
So, everything gets submitted perfectly and without issue.

Each record is checked to make sure that it doe not already exist, and then if does not insert.

Right sweet really.

have a good one.
GawaiConnect With a Mentor Commented:
before sqlOrgInsert, u can have a check
sqlCheck = "select * from <tableName> where yourData='value' "
execute that query and..
if objRs1.eof then
'insert records
'record exist; display error
end if
Wayne BarronAuthor Commented:
This does not work on a Multi-Insert.
Have already tried.

As i mentioned above, this is simple on a single record insert, you can use that IF Statement
To check, but this catches the 1 instance of a duplicate and stops the whole thing
AND if you do not have no duplicates, it still stops the whole thing.

Need something else.
Thanks fo for the try though.
I should have posted that I actually did the abvious coding prior to posting.

did u try with ajax ?
seems u need to search for multiple records before insert
Wayne BarronAuthor Commented:
Actually it is using AJAX to a point.
At least to let you know that it is processing.

If you know of a way to do this in AJAX completely.
Then that would be awesome.
As a lot of the site already uses AJAX. (Starting to really love AJAX) now...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.