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
Hi there! I'm looking for a project that will open a content-link in a html, after this it will check in a table in the source code how many specific word appear and if it's > 3, the script will back to the first page and click in a specific botton. It should loop at each link (it has several links on the first page, and the procedures must happen
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
...2010), and place those into a SQL Server table. I would therefore like a powershell script that populates a table with: Username, EmailAddress, PrimaryOrAliasIndicator. The script will be run as a scheduled task once per day. Therefore, it should run without user interaction. It is quite ok to delete the table and re-enter on each occasion, rather than
Need GET and PUT APIs for a cloud db. GET Input: Key Process: Check a db table for the key and find associated column value for the key Output: Value PUT: Input: Key, Value Process: Find row of the ke in db table and replace the column data with 'Value'
This is just quick lookup of values from one table, finding the corresponding value in a second table, and then replacing it for the original value. The only issue is that the original values are part of a single field, so the field needs to be parsed first, the value substituted, and then reassembled.
We need you to export a particular table from a sql_file, which we will provide to you, to a csv file. We are having issues to export the file, since the data contains several signs like commas, semicolons, etc, so we can not define a good separator.
Hi, We are seeking a designer to help us with matching place cards, table numbers and pix card for our wedding. very simple. There will be 97 people at our wedding. Our theme colors are nude, blush, white, gold. Our floral is greenery, so a little green may be considered. Place Cards: - Must be self standing, fold in the middle - like a tent - White
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 ...
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