1064 error sql syntax orders jobs
Project Description: We've built a backend API using .NET...various environments (dev, staging, production) for efficient development and deployment. - Be able to run the backend API for local testing purposes. - Should also be able to make amendments to the .NET API What We Offer: Long-term Collaboration: We value long-term relationships and are looking for someone who can become a part of our team. Proficiency in , JavaScript, .NET API's, and SQL databases Strong understanding of data validation and security best practices, Strong understanding with creating charts, working with CDN's Experience working with existing codebases and contributing to ongoing projects Ability to run backend APIs for local testing Experience setting up development, staging, and produ...
I need a software solution that calculates the matrix exponential using Python. This mathematics task is essential for building dynamic systems, specifically, for the precise analysis and solving of linear equations. Building code to calculate Matrix exponential using Taylor series to calculate exponent. The user must upload a matrix of size 1000*1000 plus epsilon error and get the exponential matrix. It is required to compare epsilon to the Lagrange form of the remainder. If the remainder is smaller, we will return the exponential matrix to the user. It is forbidden to use library functions like numpy or scipy I need to calculate an exponential matrix of M How do I calculate e^M using a Taylor column for the function e^X when the formula is as you know it is sigma from i to a ce...
As someone managing digital applications, experiencing difficulties with our existing app and website is starting to impact our operational efficiency. Therefore, I am in need of a dedicating developer with significant expertise in troubleshooting and resolving bug and error-related issues. Key Aspects of the Tasks: 1. App Revamping: Our app is currently suffering from functional errors that lead to regular crashes. I anticipate these crashes to be rectified effectively and immediately. 2. Website Enhancement: Post-rectification and effective updating of the app, the project would extend to our website to conduct any necessary fixes and updates to maintain its optimum functionality. Ideal Skills and Experience: - Confident in identifying and resolving functional errors. - Knowled...
...matrices. • The option to upload and paste images directly into the editor. • Ability to copy paste "Equations" directly from Microsoft word to editor (can be as image) • Functions including superscript, subscript, bold, italic etc. Ideal Skills and Experience: • Expertise in React js with TypeScript. • Previous experience building text editor components. • Familiarity with features like syntax highlighting, auto suggestions and code formatting. A quick turnaround on this project is essential. Please share any similar projects in your portfolio and your proposed timeline with your bid. some reference editors: -> does not have matrix capability - > does not have image/video upload capability
...taking too long to load, making browsing a frustrating experience for users. Moreover, I'm facing a recurring 502 error. These problems have developed after a major update with Elementor, and it seems it isn't functioning properly as the elements are not loading consistently. In fact, the website only loads correctly around 10% of the time. - You will: - Improve the website's loading speed significantly - Rectify the 502 error permanently - Solve the issue with Elementor causing inconsistent loading of elements and website instability Essential skills and experience: - Proficiency in website optimization techniques - Familiarity with identifying and solving 502 error issues - Detailed understanding and finesse with Elementor and Wordpress -...
I need a proficient web developer to create an internal order-placing system for us. This should not be accessible to the public. Only our customers should be able to log in and place their orders. Here's what I require: - A Web-Based Platform: The system needs to be accessible through a web browser. You'll integrate this system with our existing Zoho Inventory. - Multiple User Support: The software should comfortably accomodate numerous customers placing orders simultaneously. - User-Roles and Access Levels: The system should define different roles, primarily admin and customer roles. Admin role should have full access whereas customer role should allow order placements only. Ideal candidates will have experience in web-based software development and some under...
For our product launch event, we need an application developed that would allow event attendees to place orders easily. The app ideally would function across both Android and iOS platforms. The primary feature of this application would be to scan a QR code, which will then store the product ID. After scanning, users should be able to specify their quantity and upon completion, submit their order. The app is designed to post this data via an API call. The information decoded by the QR code will include the product name and product description. Ideal candidates for this project should have: - Experience developing apps for both Android and iOS - Practical knowledge of implementing QR code scanning functionality - Proficiency in working with APIs - Understanding of how to incorpora...
I am seeking a skilled coder who can devise a dynamic MQL code for handling buy and sell trades. Success in this project means creating a code that can readily address order placement and error handling. Applicants should showcase their past work related to MQL coding and trade handling. Mastery in these fields will be beneficial. A background in real-time data analysis is not a strict requirement, but would be a valuable addition.
For this crucial project, I require a skilled Java developer with a keen eye for design and UX. Your prime focus will be on the following: - Refining the user interface of our current Java IRC chat, bringing in a more modern aesthetic, better layout, and intuitive navigation. - Moving on to syntax improvements, I'll need you to incorporate better error messaging and user-friendly commands. Experience with similar projects and a firm understanding of UX principles would certainly set you apart from others. Let's bring IRC chat into the modern era together.
I nee...transfer of my Windows-based virtual machines (VMs) between Azure accounts. Key Requirements: - Previous experience with Azure and knowledge of Windows platform are essential for this task. - Must have expertise in transferring and configuring VMs. - Familiarity with web servers, as the VMs in question are hosting web-based applications. Your responsibilities would include: - Ensuring smooth, error-free transfer of VMs. - Post-transfer configuration and testing to ensure successful operation. - Providing documentation of the transfer procedure for future reference. Candidates with past experience in similar projects will be given preference, so please provide any relevant work examples. The right person should be ready to start work immediately. Looking forward to your ...
I am currently seeking a skilled developer with extensive experience in Google Tag Manager. A small error has surfaced in a personal project of mine and needs an expeditious resolution. Here's what I am looking for: - A deep knowledge in Google Tag Manager you can demonstrate. - The ability to work swiftly as my project is time sensitive. Please ensure your application includes: - Demonstrable experience in rectifying similar issues. - Google Tag Manager certifications, if available. - Expected timeframe for resolving such issues. I look forward to receiving your application and discussing my project further with you. Let's fix this issue ASAP! Thank you.
As a web developer, I need assistance in building a PHP script to connect an HTML form to a database. I require a seamless integration wher... Duplicate, and Download PDF for data manipulation. - These functions provide a robust database management system ensuring efficient editing, deletion, duplication and downloading of entries. - Integrating text fields, radio buttons, dropdown menus and file upload fields in the HTML form with the database for seamless user input. Skills Needed: - Proven experience in PHP, HTML, JavaScript, and SQL. - Understanding of Database schema and associated concepts. - Attention to detail and good problem-solving skills. - Ability to work under tight deadlines. Please apply if you believe you're the right fit for this project. This needs to be ...
I'm looking for a skilled SQL coder to help with a project management initiative. This includes: - Developing a project-focused database management system - Implementing data extraction, transformation and loading processes The ideal candidate will show proven experience in SQL, especially with data coding. Proficiency in project-oriented tasks will be beneficial. Sound understanding of data analysis and reporting is anticipated.
## Automated / copy - paste bids wil...based job ## ## 8 hours job, Monday - Friday ## ## Experience : 4+ years ## ## Package: INR 65K per month ## ## Selection: Technical interviews (2 rounds) ## ## Open for freelancers from INDIA only ## JD for the Power BI/ Analyst resource MS Dynamics 365 + Power BI + SQL experience is mandatory. Only Power BI + SQL will not work. Experience in (at least 4 years) • Building Power BI reports • Dynamics 365 Business Central (BC) • Working with different connectors via API for the Data warehouse • SQL Server/SQL Queries • Data tools and technologies to proce...
I'm in need of an experienced Java developer, familiar with maven. Here are the project details: - I have the complete, uncompiled Java source code - The code needs to be compiled and run on my Linux system The perfect freelancer for this job should have an in-depth understanding of Java and maven (no try and error!), and ample experience with Linux systems. You will have access to my machine using Anydesk. I believe that an experienced freelancer should finish this project in less than 30 min.
I'm currently ...currently looking for an experienced ESXi 6.5 professional to diagnose and fix persistent server crashes in my environment. Key Requirements: - Expertise in diagnosing and fixing ESXi server crashes. - Experience with network troubleshooting and data corruption resolution. - Ability to analyze potential error logs or messages related to the server crashes. Your primary task will be to identify these crashes' root cause, provide a fix, and propose a preventive maintenance plan. If logs or error messages are present, consider them part of the investigation. I'm hoping to find someone who's highly responsive and committed to resolving this issue as expeditiously as possible. Please note your experience in your bid to help me better u...
I am seeking a software developer who specializes in inventory management tools. The purpose of this project is to develop an inclusive and efficient software that can manage my product inventory, specifically focusing on the mechanic aspect. Key Features Required: - Capabilities to incorporate and manage work orders Ideal skills and experiences: - Proven track record in software development - Specific experience in developing inventory management software - Understanding or work experience in the mechanic field would be advantageous. The successful freelancer will develop a user-friendly interface that streamlines work order management, providing an intuitive and efficient inventory system. Please only consider your bid if you can meet the technical requirements above and hav...
...expertise in Oracle technologies. You will be responsible for designing, developing, implementing, and maintaining Oracle databases to support our organization's applications and business processes. This role requires proficiency in SQL, PL/SQL, database functions, triggers, ETL processes, and database performance tuning. Key Responsibilities: • Design, develop, and implement Oracle databases to meet business requirements. • Perform database administration tasks, including installation, configuration, backup and recovery, and monitoring. • Write efficient SQL and PL/SQL code to support application development, including the creation of functions, stored procedures, triggers, and packages. • Develop and maintain ETL processes to ext...
I'm in need of an experienced Serverless JavaScript developer to help remedy functionality errors detected in my application's data input system. I'm experiencing these issues predominantly within the data processing sector of my application. Ideal Skills: - Proven experience in debugging and problem resolution - Expertise in serverle...system. I'm experiencing these issues predominantly within the data processing sector of my application. Ideal Skills: - Proven experience in debugging and problem resolution - Expertise in serverless JS application - Ideally using Cloudflare Service workers - Knowledge of data processing and retrieval systems Your main task will involve implementing this solution to resolve the functionality error. Past experience with simil...
As an eBay seller, I'm looking for a seasoned freelancer to handle various aspects of my eBay account. My...handle various aspects of my eBay account. My account already has multiple listings which need effective management. Duties will include: - Listing new products regularly - Optimizing existing product descriptions for better visibility and sales - Overseeing inventory management to ensure availability and prevent stock-outs - Handling the process related to international shipping of product orders The ideal candidate should possess experience in eCommerce, specifically eBay account management, and have a great understanding of listing optimization and inventory control. Knowledge of international shipping processes is a must. If you have these skills, I would love to...
1. We have 32 backups from the same database as .sql-files. From one table of this database we need all instances in one csv-file (with the same codepage as stated in the sql-file ). So basicly you must: - import 1st backup on your sql-server - export the table "contracts" to "csv for Excel" - repeat for all 31 other backups - put everything together in one big csv-file that is readable in Excel (pls maintain german umlaute) 2. There should be a menu-item (i.e. "Report"); clicking this asks for the date "Welches Datum?"; the current date is proposed but can be changed by choosing a date in a calendar. The report should consist of: 1. All customers that have been added at the given date. 2. All contracts that have been ad...
I'm experiencing some issues with my WordPress website. It has been manifesting slow loading speeds and multiple error messages have been popping up. Since these issues aren't specific to any particular page or section, it's clear that there's a need for an overall enhancement of the site's performance. Here is what is needed: - Increase the site's loading speed. - Fix the existing error messages that have been frequently occurring. Ideal Skills and Experience: - Proficiency in WordPress. - Website debugging expertise. - A good understanding of website optimization techniques.
...Requirements: 1. Web Scraping: - Use web scraping techniques to extract information from the VFS Global website. 2. Browser Automation: - Implement browser automation to simulate user actions on the website. 3. Data Encryption: - Employ encryption mechanisms for secure data transmission and storage. 4. Logging: - Implement a logging system to track user actions and system activities. 5. Error Handling: - Include error-handling mechanisms to gracefully manage unexpected situations. ### Legal and Ethical Considerations: 1. Compliance: - Ensure that the software complies with legal regulations and terms of service of VFS Global. 2. Ethical Usage: - The software should be used ethically and responsibly, avoiding any misuse or violation of terms. 3. Data Privacy: - Imp...
...OneDrive sync is also required. This position offers the opportunity to collaborate with clients, ensure artwork files are print-ready, and assist in administrative tasks. Responsibilities: - Preflight artwork files and ensure suitability for printing. - Identify errors in artworks and make necessary corrections to create print-ready prepress files. - Collaborate with clients via email regarding orders and artworks. - Assist in improving artwork workflow processes. - Create basic forms (e.g., Google Forms). - Maintain a neat filing system. - Perform general administrative duties and provide support as needed. Requirements: - Previous experience in prepress for printing. - Proficiency in Adobe Illustrator, Photoshop, and other relevant design software. - Familiarity with Micro...
...Project Scope: Configure one CALL function to interact with Office Ally's API, focusing on claim submission or status check. Ensure the CALL function can retrieve data from Office Ally and input it into a specific table within our dbdesk database. Address authentication and data security requirements for the API call. Test the functionality within a sandbox environment to validate data exchange and error handling. Requirements: Proven experience with REST API integration. Strong understanding of authentication protocols and data security. Ability to adhere to compliance and data privacy regulations. Experience with dbdesk or similar database platforms preferred. A proactive approach to troubleshooting and problem-solving. This micro-project is a pivotal step towards enhan...
...Authentication: Integrate AWS Cognito for handling user authentication, registration, and password management. Implement JWT (JSON Web Tokens) for secure communication between the client and the server. REST API Standards: Follow RESTful principles for API design, ensuring endpoints are logically structured and use appropriate HTTP methods (GET, POST, PUT, DELETE). Implement proper status codes and error handling to provide clear feedback to the client. Secure API endpoints using HTTPS and middleware for authentication and authorization. Testing: Write comprehensive unit and integration tests to cover all API endpoints and business logic. Use testing frameworks such as Testify or GoConvey for writing and executing tests. Documentation: Provide detailed API documentation using ...
Transcription of less than 1 hour audio file in verbatim format is required for this project. The ideal freelancer for this job should have experience in transcription and great listening skills to ensure accurate transcription. The following skills and experience are also required: Skills: - Excellent typing skills - Attention to detail - Ability to wo...transcription and great listening skills to ensure accurate transcription. The following skills and experience are also required: Skills: - Excellent typing skills - Attention to detail - Ability to work under tight deadlines Experience: - Previous transcription experience - Familiarity with transcription software and tools - Experience with audio and video files The final transcript should be error-free and delivered in a time...
I am searching for a Python developer proficient in Scrapy to forge web security testing tools. As a key deliverable, these tools must have the features below: - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing Proven experience in creating security software is ideal. The developer should be adept at creating intermediate-level subdomain enumeration features. The project completion requires an understanding and implementation of Scrapy. I expect a functional, well-tested software package at the end of the project.
I am looking for a skilled individual who specializes in Python and Java. Your main objective will be to develop a trading algorithm that minimizes risk—this is the primary goal. The algorithm will be designed to function on the Motivewave platform, which will require your expertise in Java to place orders and data. Moreover, the machine learning techniques you will need to utilize in this project are primarily reinforcement learning methods. The trading algorithm you are to create for this project must be capable of assessing Fibonacci Retracement. It will require a keen understanding of financial data and the use of these data in minimizing risk in trading. Skills and experience required: - Proficiency in Python and Java - Extensive knowledge on Reinforcement Learning - ...
...specializing in ADHD, Anxiety, and Depression, is seeking a meticulous and skilled SEO Blog Proofreader to enhance our online content's visibility and effectiveness. This part-time position is perfect for individuals passionate about mental health, with a keen eye for detail and a solid understanding of SEO best practices. Key Responsibilities: Proofreading and editing blog posts to ensure they are error-free and align with our practice's tone and style. Optimizing content for search engines using Yoast SEO to improve our website's visibility and rankings. Collaborating with our content team to suggest improvements for better reader engagement and SEO performance. Utilizing ChatGPT-4 to assist with content creation and optimization, ensuring all content is up-to-...
I'm searching for a skilled developer to create a React application from scratch with integration to a .NET API. This application will need to make use of an existing SQL database. Key Tasks: - Design and develop a new React application. - Implement integration to a .NET API. - Utilize an existing SQL database. Candidates must have expertise in: - Development of React applications. - Integration of .NET API. - Working with SQL databases. - **Core Functionalities:** - **User Authentication:** Secure login system using email and password. This system should ensure that user data is protected and only authorized users can access the application. - **CRUD Operations:** The ability for users to create, read, update, and delete data within the database seamlessly. ...
For my project, I require an expert well versed in Database Normalisation, specifically forms 1,2,3. The main goals of this normalisation process are to elimina...performance for better usability in my document database. Identification of primary key(s),foreign key(s),partial dependencies,transitive dependencies Ideal candidate skills: - In-depth knowledge of data normalisation - Experience with document databases Responsibilities: - Ensuring data integrity and performance - Applying normalized data to a documented environment Take note that we're not using SQL, NoSQL or Cloud-based systems. Instead, a document database system will be utilised. Your previous experience in such an environment would be a big plus. Your role will be pivotal in assisting this project to reach ...
I'm currently facing an issue with my WooCommerce store. After a customer completes a payment, a 504 time out error occurs during the redirect. This problem is consistent across all the payment gateways I have integrated on my store. Potential causes may include high server load, slow server response time, or network connectivity issues. What I need from you: - Diagnose the exact cause of the 504 timeout error - Propose and implement a solution to fix the problem persistently - Test all payment gateways to ensure the problem is resolved Ideal Skills: - Expertise in WooCommerce - Strong understanding of server management and troubleshooting - Good knowledge of different payment gateway integration - Can work in a fast-paced, tight-deadline environment Please provid...
I'm experiencing an annoying issue with a Google Docs Word document that I've been working on. There's a stubborn horizontal line that appears below a set of bullet points and it won't go away no matter what I try. Frustratingly, I can...The specific line I am trying to get rid of is between Air Sciences Inc and The national snow and Ice data center in the experience section. For this quick project: - You should be familiar with Google Docs, especially with more complex document and formatting issue fixes. - Ideally have experience with similar issues, or at least be skilled in similar software troubleshooting. - I need this error fixed immediately, so proficiency and speed are preferred. Please apply if you can help me fix this issue in my document in the s...
As a cigar/tobacco B2B store, I'm looking for a skilled Opencart developer to create a comprehensive API connection between my online store and ou...applicable taxes in our operations. Ideal Skills: * Proficiency in API development, specifically with Opencart, CenPOS and InforSX * Experience with ERP integration, particularly InforSX * Experiences in payment gateway integration, preferably CenPOS * Knowledge in developing custom tax modules in Opencart The end goal is to automate and streamline our processes, allowing our online store to process orders and maintain live inventory and pricing/tax table and to run the online store more efficiently. Your bid should reflect your understanding and ability to meet these requirements. Success in this project could potentially lead t...
...technicians to interact with each other. This portal will primarily serve three key functions: - Order submission: Doctors should have the capability to relay their lab order requests directly to the laboratory. An intuitive, easy-to-use interface is preferred. - Software Integration: The portal should seamlessly integrate with the existing lab software to facilitate efficient handling of orders. - Results Posting: Once the lab work is complete and results are obtained, they must be posted back to the portal for doctors to view. In terms of user roles, three distinct types should be identified: Doctors, lab technicians, and administrators. Each role will have different access rights and capabilities within the portal. Ideal skills for this project would include length...
I'm in search of a multi-talented individuals who can handle content and copy creation and social media management. I urgently require your skills in: Content/Copy Writer- Writing and editing content: This is my top priority, and I expect your work to be engaging, error-free, and in line with my brand's voice. Social media manager : - Managing social media: Day-to-day handling of my brand's social media accounts is crucial - creating and curating posts, interacting with followers, and driving user engagement. Unfortunately, I can't specify the kind of content I need right now, as it varies. It could be articles, blog posts, website content, or product descriptions. However, you should be equipped to handle any of these types when necessary. The timeframe fo...
For my project, I require an expert well versed in Database Normalisation, specifically forms 1,2,3. The main goals of this normalisation process are to elimina...performance for better usability in my document database. Identification of primary key(s),foreign key(s),partial dependencies,transitive dependencies Ideal candidate skills: - In-depth knowledge of data normalisation - Experience with document databases Responsibilities: - Ensuring data integrity and performance - Applying normalized data to a documented environment Take note that we're not using SQL, NoSQL or Cloud-based systems. Instead, a document database system will be utilised. Your previous experience in such an environment would be a big plus. Your role will be pivotal in assisting this project to reach ...
I'm seeking an experienced app developer to create a dynamic e-commerce mobile application compatible with both iOS and Android platforms. Here's what I'm looking for: Key Functionality: - The app's primary function should revolve around e-commerce. I need a seamless and user-friendly environment for users to browse products, add items to their cart, checkout, and manage their orders. Design: - The design should be highly interactive, encouraging users to engage with the application. I'm looking for clean lines, intuitive navigation, and a balance between visual appeal and functionality. Ideal Skills: - Proficiency in cross-platform app development - Prior experience in e-commerce application development - Excellent UX/UI skills to create an interactive l...
I'm looking to have an food delivery app. It must be designed for Android and iOS platforms. Key features for this project will revolve around the user's ability to place food orders, hence the application should be designed with this in mind. The successful freelancer will ideally have: - Expertise in creating E-commerce apps - Experience in designing food delivery systems - Proficiency with Android and iOS development or only Andriod - Understanding of food ordering process integration and map routing or assing food order to driver Key Features: Code and guidelines for this project using only this subjects - (laravel - php - firebase - mysql - kotlin - apis - android) Admin App or Web owner - 1) Adding Restaurant details and Category for listing Logo - images - a...
...Task: Imagine you are a data scientist recently hired by the government to demonstrate the new SQL database you have created. Imagine the government is also planning on storing the names of people involved in accidents. You produced a relational database in SQL. In your presentation, you should introduce the potential technical, ethical, and legal issues of storing the data. How might an SQL relational database address some of these? Present and describe an entity-relationship diagram (ER diagram) for the database. There are a lot of columns in each table, so do not show them all. Just show primary keys, any foreign keys, and a representative sample of 2 or 3 of the other columns. Present SQL commands for the following, using the full data set from all yea...
...tournament. It needs to facilitate convenient registration for participants, streamline match scheduling, ensure accurate score recording, provide updated standings/results, and include sport-specific rules. Key Features Required: - Participant Registration: A frictionless process for user sign-ups (including payment). - Match Scheduling: An efficient system for scheduling matches. - Scoring System: An error-free structure for logging scores and managing results. - Real-time Results Display: Timely updated standings and results should be directly available on the app. - Sports Rules References: Functionality to provide information regarding tournament rules, regulations, and structure. Ideal Skills & Experience: - Proven experience in mobile app development (preferably a po...
I need assistance involving incorrect output being produced by my PHP/SQL code. I require an expert who's proficient in: - Debugging PHP/SQL, primarily focusing on calculation issues. - Understanding how aggregated functions operate. My problem involves miscalculations within the aggregated functions. An expert in SQL that can accurately rectify this issue is necessary. The successful freelancer should having strong experience in PHP/SQL and great debugging skills.
I'm urgently on the hunt for an experienced WordPress technician, well-versed in resolving a variety of code errors. My site is experiencing several issues including: - "Type array string is deprecated" - "An active PHP session was detected" - "REST API encountered an error" These issues need attention ASAP due to the adverse impact they are having on the functionality of my website. Ideal candidates should possess: - Solid understanding and experience of WordPress platform - Thorough knowledge in PHP language - Proven experience in diagnosing and resolving similar code issues swiftly. This job requires urgency, but also crucial is rigorous attention to detail, as rushed fixes can sometimes cause more damage than the original issue. Please appl...
I'm in need of an expert who can provide me with moderate complexity, artistic patterns for my embroidery orders. They should be specialized in creating designs that take into account the capabilities and limitations of embroidery. Key tasks include: - Create moderate complexity, artistic patterns for embroidery - Convert these designs into DST format Ideal skills and experience: - Strong experience in embroidery design - Proficiency in working with DST file format - Ability to design artistic patterns considering embroidery specifics - Sound ability to interpret moderate complexity design requirements
I'm looking for a highly skilled PHP and SQL professional to assist me in managing my database. Specifically, I need help with: - Database Management: I require someone well-versed with handling databases, ensuring that their structure and performance are optimal. - Data Structuring: My project predominantly deals with tables and requires someone with an in-depth understanding of them to ensure efficient data structuring. Ideal skills and experience for this job would include a strong command of PHP and SQL, a deep understanding of database structures, and substantial experience in database management and structuring, especially tables.
