we have a form for insert data, we need on submit to create a query before to process to check if data exist and IF exist show a modal with alert and name of data else process
I need someone freelancer to help me to fix the query below: select count(distinct p.products_id) as total from (products p) left join manufacturers m on (m.manufacturers_id=p.manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on
Query on Office 365 Excel Online to export the data. No bootstrapping. Need to use Dojo or jQuery, or find a way to get it into that format for me to use.
Project Duration: 1 Hour Project Overview When trying to run this query: SET `description` = REPLACE(`description`, 'â€™', ''') WHERE `description` like 'â€™%' We get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right synt...
I am currently getting a 500 error on my website. I traced it back to an SQL query (SELECT XYZ FROM zip_code INNER JOIN city ON zip_code.city_id = city.city_id INNER JOIN region ON city.region_id = region.region_id INNER JOIN country ON region.country_id = country.country_id). The INNER JOIN country ON region.country_id = country.country_id part of
Scrape from a google spreadsheet into a database on Azure or EC2, and create a UI for non-technical people to query. Make sure certain users can add but cannot delete data from the db. Also the UI should sanitize and validate the data before entering it int the database.
...in a webforms. The user should be able to bulk insert the financial data, press the save button and the data be inserted into a database. More lines should be added to the gridview as necessary. I'm not sure if its possible with webforms. I am familiar with mvc but i have been asked to add this to a legacy application and I'm not sure where to start
...corresponding order details are loaded in the GridView. • Display the following columns from the Orders table: i. OrderID, OrderDate, ShipedDate, ShipName, ShipAddress, ShipCity, ShipCountry. 6. If a new category is selected from the ListBox, update the products DropDownList accordingly. • And clear the order details GridView. 7. If a new product is selected from
I have a quick issue I just need some advice on Fixing or a slight change of code. JSON Response is being presented to the app however, it won't append to the Dictionary that I'm trying to use. Paying a maximum of $30AUD for this as it is a quick code fix. Just needs a simple fix.
Select rows to display the columns: name of product/service assign alias as “ProductService”, quantity sold of product (invoice detail), employeeID who is assigned to the invoice; where the employee ID equals 1; sort by name of product/service ascending.
SELECT [kirjaudu nähdäksesi URL:n], SUM([kirjaudu nähdäksesi URL:n] * [kirjaudu nähdäksesi URL:n]) as price FROM Customers INNER JOIN Invoice ON [kirjaudu nähdäksesi URL:n] = [kirjaudu nähdäksesi URL:n] INNER JOIN InvoiceDetail ON [kirjaudu nähdäksesi URL:n] = [kirjaudu nähdäksesi URL:n] group BY [kirjaudu nähdäksesi U...
I have a request table I need a few queries done on. This is an excel sheet. I need to find out quick analytics on our user behavior. It would be excellent to get the %, numbers and graphs depicting results.
Our website is built in c#. It comprise of data-bound controls like (Gridview, Datalist). The problem to solve is to make these responsive .We want the content of these composite databound controls to be responsive which they are not as of now.