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
We have a Wordpress site that suddenly stopped displayed posts in tags, categories or menus. That is, if you click [kirjaudu nähdäksesi URL:n], it would return "no posts to display" even though the category is showing dozens of posts in the dashboard. The same happens for tags. The menu doesn't display anything. Steps we have taken: 1) Disable all plugins
I already have the possibility to add text under the categories, but in this text i cant configure any style. I would like to be able of editing this text (strong, H1, H2, etc...)
...general information about that category and it's products describing it. A spreadsheet will be provided with 1-3 keywords which can be included in the text. There are 16 main categories as follows: Tablets, Phones, Media Players, Wearable Devices, Sports & Outdoors, Electronic Gadgets, Projectors, Security, Audio & Video, Car Accessories, Health & Lifestyle
Hi, I want someone professional to implement the design on magento front end. I have the design/html already. There are a couple of other fixes, magento extension integration as well.
...products loaded to Prestashop (184.108.40.206) by default they all went to HOME category. We loaded file again after we created Categories - products are assigned to 2 categories and HOME is default. out of 100 products 20 have to categories (HOME and new correct) 80 still seats in HOME How i on those 20 products remove HOME category, that "new correct" will
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 rig...
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.
For this project, I will need the image source and SVG format. There are sample images will be provided and needs to be improved a bit. Preferably if you can follow the google guide to designing icons.
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.
Hi, I need to upload data from an excel to a database by creating a new table, and from there transfer some data to 2 sql tables from that database. More details in the attached excel file. Cosmin
This work involves a pdf file of shipping labels with multiple pages that needs to be sorted based on a reference number in a text file that matches a label/page within a pdf file.. ie A list of alpha numeric letters/numbers are given vertically in a text file that need to be searched within the pdf file and as the pdf file finds the queries within its pages (which is one per page), it creates a n...
Summary: We have 16 shoe categories on our e-commerce site. Your task is to find 100 shoes throughout the site [kirjaudu nähdäksesi URL:n] for each category and provide the article numbers which you can see on the product detail page.
I need you to build a landing page. budget 600 Rs
I have an apparel website and i need some graphics made for the categories im selling.. Ive attached some images of examples and size of graphics i need. Here's list of Catergories Accessories (Socks,Mugs,Phone Cases and Etc) Jackets Featured (Products that were featuring) Backpacks Hats Mens Apparel (T Shirts, Hoodies,Polo) Womens
I need a freelancer to edit my site so to make it show sub sub-categories. Need to make it compatible with my theme. My system is Opencart version: 220.127.116.11. My theme is [kirjaudu nähdäksesi URL:n]
I need a script that will scrape top 5 eBay auctions categories. The script must find the 2 most commonly used categories in the top 5 auctions and extract categories names and numbers. It will source ISBN from CSV than scrape data one by one and create 2 CSV, first with data from "All Categories" and second CSV with data from "Books, Comics & Magazin...
Create an Excel and CSV file -With: Categories | Sub-categories | Sub-sub-categories and Manufacturers (ex: Scuba Diving, Freediving, Masks,..... ex: Yachting, Maintenance, Paint,...) -For: Yachting / Sailing Scuba diving Fishing Water Sports (surf, paddle,.) Apparel -Using: [kirjaudu nähdäksesi URL:n] | [kirjaudu nähdäksesi URL:n] | [kirjaudu nähd&...
I NEED A APP APP IN DIFFRENT PRIZE . EVERY DAY WIN A PRIZE. PRIZE IN WINNER GURANTED IN PUBLIC PRIZE TICKET PRIZE COST DIVIDED IN ADMIN OPTION APP REGISTRATION EVERY PERSON WITH GOOGLE EMAIL OR FACBOOK OR MOBILE NO IF ANY PERSON SHARE APP GET AND JOIN ANY PERSON PER PERSON 10 POINT WIN IF JOIN 10 PERSON GET 100 POINT MEAN RS 2 & USE IN NUMBER IN PRIZE TICKET ADD MONEY FEAUTRE ...
I have a query in place and would like to create a form with drop down boxes that allows the user to run the query based on the criteria they select. I have started the form but am struggling with linking the combo boxes to the query.
...create Mongodb query. It's maybe not the most complex query you ever find but we have not too much experience in MongodDB and how to use all this features. The query will cover all the basis filters and the use of the geospatial feature (just a simple search of maxdistance usign coordinates, we already have this). Basically, the query has to: Search
This is a 5 class text classification problem, currently the accuracy of the 5 classes are just 37%. I require the accuracy to go over 85%. 1)Try oversampling 2) use deep learning use any machine learning algorithm in Python, only payment would be done for algorithm which gives me above 80% accuracy for each class prediction. Ping me for the data, only expert data scientist bid
Hi I have a query which I use in SSRS report builder 2016 to display results in a chart. Query is ok but I would like a column being pivot in the query and have never done this before. Should be less than an hours work and your need to work via Any Desk on my system to change the query. Get in touch if you can help. Thanks, John