I need someone to write a simple sql query to copy fields between tables
...support ( SystemEmailTemplate model), these system emails are sent under some conditions form a SQL query are met (DatabaseQuery model) - System Email should be configured one to one (individually). i.e a URL with the kind of email we want to send as a parameter (SystemEmailQueue atributo template_key model). - Programmed tasks with Crons - Project
...the design, the UI must be exactly the way we want it. we will provide images for that. you can create the website locally and then send us the zipped file for us to upload onto the server. You can even create a query which we can run on the server to create the database. Some of the fields will be dropdown values or Y/N booleans, and there will be
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
...moment we have the following scenario: In a Shop System, we can order EBooks (Digital Content). The price is $0 for this books. We have 10 products in the Shopping Cart and send the order and receive an error. That happened with the most combination in the shopping cart, but as well not always. Some products are able to purchase. The error is: Next
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
The scope of the project is to replicate a single query of a java application to a .Net application. The Java application authenticates as follows: 1. User login to a website (We will provide a username/password) 2. There is a link to login to the application,on this page there i the username/token information that is provided, a JNLP file is being
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.
...from the system. This includes the following files: - Current stock (CSV) -Sales of the last 14 days (CSV) -Article Database (EXCEL) The first two CSV files I read about the query function in Excel. I then made a little "program", if you want to call it that, tinkered. I also worked a bit with VBA. However, the tool is very limited. The queried files
...distance limitations. I would be able to fill a xls with vetted questions, I would then send that xls to the asking agency, that information would then be used to populate a master xls, If I am looking for a bartender for Tuesday night in DC, I should be able to query bartenders, DC, who is available that night and contact them. It would be ideal for