We help IT Professionals succeed at work.

Multiple Record Insert (Check if file exist)

Wayne Barron
Wayne Barron asked
on
347 Views
Last Modified: 2012-05-07
Hello all.
This is simple to do in a single record insert.
But, using a Multiple Record Insert, it is not quite working right.

So.
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")
objCommand.ActiveConnection=objConn
row=CInt(Request.Form("row"))
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')"
objCommand.CommandText=sqlOrgInsert
objCommand.Execute
Next
%>

Open in new window

Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Wayne BarronAuthor, Web Developer
CERTIFIED EXPERT
Top Expert 2009

Author

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.

Carrzkiss

Commented:
did u try with ajax ?
seems u need to search for multiple records before insert
Wayne BarronAuthor, Web Developer
CERTIFIED EXPERT
Top Expert 2009

Author

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...
Author, Web Developer
CERTIFIED EXPERT
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.