|
>Hi,
I have a Oracle DB in which all the information is stored and this information is been consumed by different teams and below is the two options i have to decide on :
1. Write a Stored procedure and give the stored procedure to the respective teams and they can call the stored procedure.
2. Write a stored procedure wrap it as an API and expose the API, different team will call the API exposed and API will in turn hit the SP and return the response to the team.
Like to know what is the PRON and CRONS with these options and what is the best possible solution to go with.
Thanks
|
|
|
|
|
|
Java Lead wrote: 1. Write a Stored procedure and give the stored procedure to the respective teams and they can call the stored procedure.
Callers of the Stored Procedure will need direct access to the Oracle DB.
Java Lead wrote: 2. Write a stored procedure wrap it as an API and expose the API, different team will call the API exposed and API will in turn hit the SP and return the response to the team.
This gives you the most control over the situation and is likely to be the most secure.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
The second option is better than the first one if different teams are working.
|
|
|
|
|
I want to know what are the most sought after technologies for becoming a Full Stack Developer.
I am asking with respect to both, Open Source and Microsoft Stack.
|
|
|
|
|
FORTRAN with a dumb terminal front end.
But seriously, all you're going to get here is opinions. Why not go look up some statistics from survey firms, like Gartner?
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
Hi All,
I saw many posted and infact I worked on JSON based asp.net app which use to JSONSeralizecontents and then pass that data to WEB Services on same machine and then webervice creates objects of it and call an SP with parameters on SQL and the response back to UI. now that was fine until i was on intranet where the app was open with basic username and passowrd however
now I am looking for hosting this app on Internet / Cloud Machine on Amazon so my doubt is that is same Infrastructure still good since
1. I may be looking to get away with the webservice parts which reads json to create object and then use it to create SQL Command with parameters. I wish to get rid of this layer so that I can pass JSON to SQL and perform operation there itself.. or have a very light wrapper for this on web service so need suggestions on it
2. I may also be looking to secure the data which is over the internet. The app will be mainly used on PDA and Laptops Browsers so what is the best way to secure it (https, JWT or some other light weight mechanism).
Also I wish to have SSO enabled for my apps.
Kindly suggest.
cheers
varun sharma
|
|
|
|
|
So, your current application base uses username/password on an intranet, but is it leveraging Basic or Windows authentication? If you're on Windows then you're in luck, that same mechanism can work for an internet site and provide the SSO support that you're looking for.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
Thanks for your kind reply Nathan. I am yet to start development so I shared what I knew before hand with Asp.net + JSON and sql. Finally I am looking to deploy my app on Cloud (AWS or Azure or some other basic cloud so that my customers can use it from anywhere around the world with same performance and speed over the internet). I was initially looking at AJAX + JSON with ASP.NET on front end and oracle at bank end but now i have a SQL guy who can do it better.
I could either do JSON front end (with Ajax call with JSON data) -- webservice (convert JSON in .NET Object or Object) and call -- SQL Stored Proc with SQLCommend and Parameters
I am looking for a better way to do it since this design is almost 8 years old, toady we have latest and better techs which I may not be well aware of son kindly suggest.
cheers
varun sharma
|
|
|
|
|
COULD ANYBODY HELP IN MAKING A WEBSITE TO SELL CARS? I NEED A WEBSITE THAT CAN SEARCH AND LIST OUT DIFFERENT CARS WHICH THE USER WANTS AND DISPLAY IT?? REALLY URGENT.. COULD ANYBODY GIVE AN IDEA HOW TO DO IT OR GIVE ME THE FINAL RESULT SOMEHOW?? THANKS U
|
|
|
|
|
Hmmm.. do you really need to type with "all CAPS"? Adding the word "urgent" does not add value to your post, sometimes it's considered rude and nobody is interested in that. 
|
|
|
|
|
This site does not provide code to order. Nobody here is going to do your work for you, no matter how "urgent" you tell us it is, or how much you shout at us.
If you've taken on a project, but don't know where to start - ie: you've lied to your client - then you'll need to go to a site like freelancer.com and pay someone to do the job for you.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi,
In my project I am using mvc ajax form. we included js file. In that js file somebody written $.validator.unobtrusive.parse. The form id passing in parse is becoming undefined. because of this it's raising issue. how to resolve this issue
$.validator.unobtrusive.parse("#form");
this #form is becoming undefined at run time. any one help me to resolve this issue
|
|
|
|
|
Hi, I'm trying to write code with prepared stmt but only code is displayed. Anyone?
<?php
$con = new mysqli('localhost', 'root', 'cookie', 'homedb');
if ($con->connect_error)
{ echo 'Cannot Connect to mySQL: ', $con->connect_error(); }
else
{
if (isset($_POST['url']))
{
$stmt = $con->prepare('
SELECT url, username, password, purpose, emailused, date-time, count, saved
FROM emailtbl
WHERE url = ? ');
$stmt->bindValue(1, $_POST['url']);
$stmt->execute();
if ($row = $stmt->fetch())
{
echo '
<table class="emailResults">
<caption>
Email Activity for ', htmlspecialchars($_POST['url']), '
</caption>
<thead>
<tr>
<th scope="col">url</th>
<th scope="col">Username</th>
<th scope="col">Password</th>
<th scope="col">Purpose</th>
<th scope="col">E-Mail Used</th>
<th scope="col">date-time</th>
<th scope="col">count</th>
<th scope="col">Saved</th>
</tr>
</thead><tbody>';
do
{
echo '
<tr>';
foreach ($row as $value) echo '
<td>', $value, '</td>';
echo '
</tr>';
}
while ($row = $stmt->fetch());
echo '
</tbody></table>';
}
else echo '<div class="error">No Results Found</div>';
}
else echo '<div class="error">No valid "url" for Query</div>';
}
$stmt = $con->prepare('
UPDATE emailtbl
SET date-time=DATE();
count=count + 1'
WHERE url = ? ');
$stmt->bindParam(s, $_POST['url']);
$stmt->execute();
echo $stmt->error ? '
<div class="error">
url update query error: ' . $stmt->error . '
</div>
' : ( $stmt->affected_rows > 0 ? '
<div class="success">
Success! Updated ' . $stmt->affected_rows . ' records.
</div>
' : '
<div class="error">
FAILED! No records updated.
<div>
');
?>
</body></html>
|
|
|
|
|
I do not understand what you are saying. Please explain clearly what is happening and where you are stuck.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Hi, I'm trying for awhile to code up a MYSQLi dropdown from a database, select a field(url, formatted as "http://www.thisurl.com) and arrive at that destination. I've tried several forums re. compatability (connection/query/output etc..Problem is I blow up at the first query (see screen shot). It's like my PHP isn't working. If someone will advise of the PHP issue maybe I can work out the app code. Any volunteers? Thanks!
--------------------------------------------------------------------- 1
<!DOCTYPE html><html>.
<title>email visit info</title>
<head>
</head>
<BODY>
create and display dropdown from database, url selected provides needed username and password. clicking on selected takes the user(me) to that url<br>
<center>
<form id="testform" name="testform" action="" method="post" accept-charset="UTF-8">
<?php
echo "<center>";echo date('m/d/y');echo "</center>";
$con=mysqli_connect("localhost","root","cookie","homedb");
if(mysqli_errno($con))
{echo "Can't Connect to mySQL:".mysqli_connect_error();}
else
{echo "</br>";}
$id = ''; $url= ''; $username = ''; $password = ''; $purpose = '';
$emailused = ''; $date-time = ''; $count = ''; $saved = '';
echo "<select name= 'url'>";
echo '<option value="">'.' ---select email account ---'.'</option>';
$query = mysqli_query($con,"SELECT url FROM emailtbl");
$query_display = mysqli_query($con,"SELECT * FROM emailtbl");
while($row=mysqli_fetch_array($query))
{ echo "<option class=highlight value='". $row['url']."'>".$row['url']
.'</option>';}
echo '</select>';
?>
<input type="submit" name="submit" value="Submit"/>
</form>
{
$url = $_POST['url'];
// ----------------------- display the table ------------------------
echo '<tr>'.'<td>'.'<table border="1">'.'<tr>'.'
<td bgcolor="#ccffff">'.'url'.'</td>'.'
<td bgcolor="#ccffff">'.'username'.'</td>'.'
<td bgcolor="#ccffff">'.'password'.'</td>'.'
<td bgcolor="#ccffff">'.'purpose'.'</td>'.'
<td bgcolor="#ccffff">'.'emailused'.'</td>'.'
<td bgcolor="#FFD47F">'.'date-time'.'</td>'.'
<td bgcolor="#FFD47F">'.'count'.'</td>'.'
<td bgcolor="#ccffff">'.'saved'.'</td>'.'</tr>';
// while($data = mysqli_fetch_row($fetch))
while($data=mysqli_fetch_row($result))
{
echo ("<tr>
<td>$data[0]</td><td>$data[1]</td><td>$data[2]</td>
<td>$data[3]</td><td>$data[4]</td><td>$data[5]</td>
<td>$data[6]</td><td>$data[7]</td>
</tr>");
}
echo '</table>'.'</td>'.'</tr>'.'</table>';
mysqli_query($con,"UPDATE emailtbl SET
date-time = 'DATE()'; count = 'count + 1';
WHERE url=$url");
?>
</center></body></html>
------------------------------------------------------------------------
2
<?php
echo "<center>";echo date('m/d/y');echo "</center>";
$con=mysqli_connect("localhost","root","cookie","homedb");
if(mysqli_errno($con))
{echo "Can't Connect to mySQL:".mysqli_connect_error();}
else
{echo "</br>";}
$id = ''; $url= ''; $username = ''; $password = ''; $purpose = '';
$emailused = ''; $date-time = ''; $count = ''; $saved = '';
echo "<select name= 'url'>";
echo '<option value="">'.' ---select email account ---'.'</option>';
$query = mysqli_query($con,"SELECT url FROM emailtbl");
$query_display = mysqli_query($con,"SELECT * FROM emailtbl");
while($row=mysqli_fetch_array($query))
{ echo "<option class=highlight value='". $row['url']."'>".$row['url']
.'</option>';}
echo '</select>';
?>
<input type="submit" name="submit" value="Submit"/>
</form>
{
// ----------------------- display the table ------------------------
echo '<tr>'.'<td>'.'<table border="1">'.'<tr>'.'
// ======================anchor attempt=========================
// echo "<a href='".$row['url']."'>".$row['url']."</a>";
// ==========================================================
<td bgcolor="#ccffff">'.'username'.'</td>'.'
<td bgcolor="#ccffff">'.'password'.'</td>'.'
<td bgcolor="#ccffff">'.'purpose'.'</td>'.'
<td bgcolor="#ccffff">'.'emailused'.'</td>'.'
<td bgcolor="#FFD47F">'.'date-time'.'</td>'.'
<td bgcolor="#FFD47F">'.'count'.'</td>'.'
<td bgcolor="#ccffff">'.'saved'.'</td>'.'</tr>';
// while($data = mysqli_fetch_row($fetch))
while($data=mysqli_fetch_row($result))
{
echo ("<tr>
<td>$data[0]</td><td>$data[1]</td><td>$data[2]</td>
<td>$data[3]</td><td>$data[4]</td><td>$data[5]</td>
<td>$data[6]</td><td>$data[7]</td>
</tr>");
}
echo '</table>'.'</td>'.'</tr>'.'</table>';
mysqli_query($con,"UPDATE emailtbl SET
date-time = 'DATE()'; count = 'count + 1';
WHERE url=$url");
?>
</center></body></html>
-----------------------------------------------
3
<!DOCTYPE html><html>
<head>
<title>test 3</title>
</head>
<body><center>
<form id="testform" name="testform" action="" method="post" accept-charset="UTF-8">
<table border=1 cellpadding=2 cellspacing=2 bgcolor="#D4FFAA">
<tr>
<th>url</th><th>username</th><th>password</th><th>purpose</th>
<th>emailused</th><th>date-time</th><th>count</th><th>saved</th>
</tr>
<?php
$connect=mysql_connect("localhost", "root", "cookie") or die("error");
mysql_select_db("homedb", $connect);
$sql="SELECT * from emailtbl";
$result=mysql_query($sql, $connect);
$url='';;
while($res=mysql_fetch_assoc($result))
{
echo "<tr>";
echo "<td>"; echo '<input type="radio" name="url" >'; echo "</td>";
echo "<td>"; echo $res['username']>'; echo "</td>";
echo "<td>"; echo $res['password']; echo "</td>";
echo "<td>"; echo $res['purpose']; echo "</td>";
echo "<td>"; echo $res['emailused']; echo "</td>";
echo "<td>"; echo $res['date-time']; echo "</td>";
echo "<td>"; echo $res['count']; echo "</td>";
echo "<td>"; echo $res['saved']; echo "</td>";
echo "</tr>";
}
?>
</table> </form></body></html>
--------------------------------------------------------
modified 19-Aug-16 9:24am.
|
|
|
|
|
You haven't told us what the error message is, or included a link to the screenshot that you mentioned.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
In a vb.net 2010 web form application, I want to create an error message when the user clicks on a checkbox or a process button. This error message will occur when there is a duplicate record when the same school year appears for the same student.
The problem of the student having more than 1 record for the same school year is nothing I can change since my school is using vendor software. I just basically want to tell the user to fix the problem using the vendor software and then they rerun my supporting web form application.
My goal is to keep the user on the current web form page they are on and allow them to do whatever processing they need to do for another student.
Thus my question is what is the best way to display the error message? Would I use a javascript alert, a regular alert, place the error message within the web page, and/or something you would recommend?
Would you tell me:
1. Why you recommend a particular method?
2. Would you show me the code on how to accomplish this goal and/or point me to the url that will show how to generate this code?
|
|
|
|
|
dcof wrote: Would I use a javascript alert, a regular alert
Those are the same thing.
The easiest way is to use alert("Some Message Here");
However, you can easily do nicer looking dialog boxes using jQuery and jQueryUI. Dialog | jQuery UI[^]
With jQuery UI, you add a div to your page that will display the message, write the necessary jQuery to wireup your dialog and then call it. Very simple and looks way better than alert();.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
I downloaded this app[^]. It runs fine on my PC.
I then followed this[^] to host it in IIS on my server. My server is Server 2012.
I get
This page can’t be displayed
•Make sure the web address http:
•Look for the page with your search engine.
•Refresh the page in a few minutes.
I can ping the server, and I can connect remotely to my SQL Server instance on my server, I just cannot reach this app in IIS on my server. I'm guessing it's not hosted correctly.
I'm not sure how to fix this. My experience in Web stuff is limited. Can anyone point me in the right direction?
Thanks
[UPDATE]
I got it working. I had not opened a port on the router. Don't I feel silly.
If it's not broken, fix it until it is
modified 15-Aug-16 22:36pm.
|
|
|
|
|
What qualities do people look at web developers when they hire them to build a Web site.
How to be become an expert web devloper????
|
|
|
|
|
Read, study and practice, practice, practice.
|
|
|
|
|
Web developers make web applications.
Web designers make web sites.
There is a fairly fundamental difference: developers make the web work and designers make it pretty.
If you're interested in site design, I would suggest looking more deeply into graphic design and specific tools, like DreamWeaver (is that still a thing?), Wix, and WordPress.
If you're interested in development, be prepared to become a subject matter expert on networking, security, web-stack architecture, database technologies, JavaScript, PHP/C#/Java, abstraction, and "The IT Crowd".
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
Nathan Minier wrote: Web developers make web applications.
Web designers make web sites.
There is a fairly fundamental difference: developers make the web work and designers make it pretty.
This is well put, but perhaps not the whole story.
1. For a web site to work well, you would also need someone writing great content, have an understanding of information architecture, web usability, and more. I sometimes teach the Web Editor program at our university, which links text, image handling, usability/accessibility, structuring the site, and also some coding.
2. Even if you are more into the backend of a web site/web application, the level of expertise you would need varies. For example, ASP.NET WebForms is much easier (if you're not good at OO practices) and more similar to a traditional HTML web site than ASP.NET MVC.
To develop web sites, I usually say you need five skills:
1. HTML
2. CSS
3. Database logic (traditionally SQL Server or MySQL)
4. Server code (ASP.NET, PHP)
5. Javascript
Of these five, Javascript could perhaps be omitted, depending on the website's needs, but you can't live without the other four.
If you keep things simple you will find that web development is much easier than most other programming. It's also more rewarding, as you get results very quickly, and people from all over the world can watch your work. Thus, if you're new or relatively new to programming, then web development is a great way to expand on your knowledge.
Good luck!
Petter
|
|
|
|
|
I'm 100% on board with your points about designers. Perhaps a better way to put it is that designers are more invested in the UX while developers generally are more concerned with the plumbing. It's just not my world, so I don't have terribly much to say about it.
That said, I think there are some points of contention in the block that you wrote about developers (I do live in that world, so have a whole hell of a lot to say  ).
petter2012 wrote: For example, ASP.NET WebForms is much easier (if you're not good at OO practices) and more similar to a traditional HTML web site than ASP.NET MVC.
I'm sorry, but IMO this is terrible advice. WebForms obfuscate the dual nature of web applications and lead to confusion, not clarity. It was a bad stop-gap to try and make WinForm developers comfortable using a RAD tool for the web. At this juncture, I think advising learning it is an exceedingly bad idea, and I don't just say that because I'm getting tired of modernizing applications that were written using it. New devs (in the MS stack) should put in the time to learn MVC.NET; it will serve them far better and will improve the state of software overall.
I would also contend that MVC.NET is quite a bit closer to the DHTML pages that I worked on with PHP and CGI gateways in the last 20 years than WebForms. WebForms are much closer to that Adobe Cold Fusion garbage that is like some sort of torture from the very pits of hell.
petter2012 wrote: Of these five, Javascript could perhaps be omitted, depending on the website's needs, but you can't live without the other four.
I'm afraid that I need to argue this point as well.
The fact is that Java(ECMA)Script is the language of the web; modern stacks can even use it for the server-side. Realistically, it's the only item that you mentioned that is a programming element that absolutely needs to be learned for a modern web application. HTML and CSS are important, but those are ostensibly templates and configurations. SQL queries are nice and all, but a decent ORM can stand in. Even server logic can (depending on the application) potentially be ignored as DBMS have begun exposing http data endpoints to support the asychronous nature of the current web application (not to mention those goofy mobile apps).
petter2012 wrote: If you keep things simple you will find that web development is much easier than most other programming.
I would argue that this is true for amateurs using a WYSIWYG toolset to make a web page for their bowling league, not aspiring professional developers. It also serves the aforementioned designers well as a proof-of-concept for their designs. I think that learning code is very much a value-for-dollar item, with the dollar in this case being the time and effort spent on it.
Yes, a CRUD application using total bolierplate can be created and running within minutes if you have even nominal skill, but that's no different from a native application. Developing a robust and useful web application requires at least as much complexity, planning, and headache as a native app; effectively the user's browser is the UI thread.
I guess ultimately what I'm saying is that I don't want to see the people who are just starting out being soft-balled on this. If they want to be a graphic designer then hey, go the designer route. This isn't for everyone, a point on which I think we're all in agreement. But if a fresh face is not intimidated by the depth and breadth of knowledge needed to be a real developer, then they should do it and do it right.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
