I made an asp file for insert a new record in to a SQL database and is working good, in fact the SQL data base don't let you repeat a record in the DNI column, but when this happend i have a browser message and i want to check the record first for tell to the user to try another if this already exist. Which code can i use?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
<%
Dim oRS, strSQL
strSQL = "SELECT * FROM MyTable WHERE MyFieldToCheck LIKE '" & Request("FieldToCheck") & "'"
oRS.Open strSQL, "DSN", adOpenDynamic, adLockOptimistic
If oRS.EOF Then
oRS.AddNew
' Etc.
Else
Response.Write "Sorry, a record by that name already exists." & vbCr
End If
%>
Hope this helps.
-Dan
You could create a stored procedure to do the checking for you..
CREATE PROC sp_AddRecord
@Value1 VARCHAR(10),
@Value2 VARCHAR(10)
AS
if not(exists(select * from tblTest WHERE Value1 = @Value1 AND Value2 = @Value2))
BEGIN
INSERT INTO tblTest (Value1, Value2)
SELECT @Value1, @Value2
SELECT @@IDENTITY as NewRecordID
END
else
SELECT -1 as NewID
Then you just create the command object, pass it the parameters, execute it to a recordset, and examine the return result. Although it seems like more work, its a more effective way of coding your database decisions...
<%
Set myRS = myConn.Execute("SELECT DNI FROM TABLE WHERE DNI = '" & LocalDNIVariable & "'")
If Not myRS.EOF Then
%>
<script language="javascript">
<!--
alert("You are using a duplicate value of DNI, Please choose another value");
//-->
<%
End If
%>
myConn = your ADODB connection
LocalDNIVariable = where you store the local value of the 'DNI' in your asp file
Business Accounts
Answer for Membership
by: robbertPosted on 2000-09-12 at 17:15:59ID: 4282920
Use SELECT.