Strategy for handling variable time queries?

I have a typical scenario that I’m struggling with from a performance standpoint. The user selects a value from a dropdown and clicks a button. A stored procedure takes that value as an input parameter,...

Am I vulnerable to sql injection and cross site scripting (a

To start, please pardon my ignorance, I’m not a programmer but rather a student research assistant who happens to need to write some programs.Right now I’m working on a page that will take...

PL SQL Pivot Table VS Custom Json solution

I’m at a point within one of my Oracle APEX projects where I need to implement different levels of security for specific individuals for specific applications.To start, I created a cartesian containing...

Triggered PHP processing

I ask a similar question yesterday but it all got confusing and i thought i would start again and try and explain it a bit better..I am about to design an auction site, much the same as ebay… items...

Most effective way of data collection?

Let’s first get to an important note about my situation:I have 1 table in my MySQL database with approx 10 thousand entries Currently, when collecting information from table #1. I collect a total...

“Lazyloading” information from a database on a PHP page in p

I know proper lazy loading usually requires using objects and a proxy pattern. I’m not there yet as a site needs some redesign. However, is there any way I can still spool out DB data to a page...

AJAX – multiple data

I’m stuck, i’m trying to submit a form using AJAX, but I can’t find a way to send multiple data fields via my AJAX call. $(document).ready(function() $(“#btnSubmit”).click(function()...

ASP.NET Best way to queue a report in sql and then update th

I want to allow users on the website to queue a report (enter the request in a sql table). The queue will be processed by a windows app that will read the queue from the sql server, run the reports, and...