Solved

Is there a way to perform a cfquery within Javascript

Posted on 2001-08-01
9
563 Views
Last Modified: 2013-12-24
I have a form that when you submit the "add" it executes javascript to validate the entered data.  I would like to validate that the record that the user is trying to add does not already exist in the database (Oracle).  Is there a way to stay on the same form and display an alert if there is match found on the database?
0
Comment
Question by:lindadudley
9 Comments
 
LVL 19

Accepted Solution

by:
cheekycj earned 25 total points
ID: 6341177
do you mean without submitting.. well one option is to query your oracle DB to create a JS array of the primary key.

Then validate against that array before the user submits.. but remember.. if a user has JS disabled.. you are out of luck.

CJ
0
 
LVL 14

Assisted Solution

by:Scott Bennett
Scott Bennett earned 25 total points
ID: 6341369
Another point to be aware of is that if you create a JS array of the user names then if the user views the source code and know anything about javascript, they will be able to see a list of every user name in your system.

I would suggest submitting the form and doing a server-side validation.

-Scott

0
 
LVL 14

Expert Comment

by:Scott Bennett
ID: 6341387
Also, FYI - There is no way for you to do a query against your Oracle database on the client-side. All your queries must be done on the server side.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 19

Expert Comment

by:cheekycj
ID: 6341476
Server side validation is the safest way.

CJ
0
 
LVL 6

Expert Comment

by:dash420
ID: 6343948
In my point view it is always to check this after in separate page i.e. which page ur going to insert into database.
:-)
0
 

Expert Comment

by:MikeForbes
ID: 6347103
I agree whole-heartedly.  I usually will add code to the page that will be doing my insert/update, something like:

<cfquery datasource=#dsname# name="Test">
Select name_id, name
from table
where name_id = #form.name_id#
</cfquery>

<CFIF #Test.RecordCount# GT 0>
Hey, you already exist!
<input type="button" value="Back" onclick="history.back(-1);">
<cfabort>
</cfif>

Mike
0
 
LVL 5

Expert Comment

by:Yog
ID: 6359100
Is it browser specific.

If not, try using the Microsoft.XMLHTTP component. Pretty cool but will work in IE5.0 and above only..

cheers.
0
 
LVL 9

Expert Comment

by:CFDevHead
ID: 10717362
lindadudley,
No comment has been added lately (972 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: split points between cheekycj, SBennett,  dash420 and MikeForbes

Please leave any comments here within 4 days.

-- Please DO NOT accept this comment as an answer ! --

Thanks,

CFDevHead
EE Cleanup Volunteer
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question