Vbnet query Jobs

Suche einen Ghostwriter für eine Online Klausur am 27.01.2023 gegen 16:20 Uhr Thema: Grundlagen Datenbanken, SQL Datenbanktheorie: -Transaktionen -Index -Normalisierung SQL (Structured Query Language): -Datenselektion -Datenmanipulation -Datendefinition -Trigger

...geschrieben auf Symfony 2.5.6 und in eine WP Seite integriert. Dort können die 12 user einsteigen und Ihre Meldungen machen. (Maria DB) Nun aber wird php8 eingeführt und anhand eines Tests habe ich festgestellt dass WP geht aber die Meldeseite nicht mehr lauffähig darauf ist. Habe Sie wieder auf 7.4 zurückgesetzt. Die Fehlermeldung lautet wie folgt: Fatal error: Declaration of PDO::prepare(string $query, array $options = []): PDOStatement|false must be compatible with DoctrineDBALDriverConnection::prepare($prepareString) in /customers/c/b/f/ on line 0 Die Aufgabe bestünde in der Aktualisierung der notwendigen Komponenten um die bestehende Anwendung unter php 8 lauffähig zu machen. Hier die URL zum

Hi, I am using a shopify system. Through this URL shopify shows the product id of a SKU: https://[...]/admin/products/:80 80 = SKU When opening this website in a shopify system it shows the data of a product like this: {"products":[{"id":7584457720037,"title":"Deutschland Fahne | Schwarz Rot Gold | Hissflagge + 2 Ösen | Flagge | 150x90cm | Fußball WM","body_html":"u003cul data-mce-fragment="1"u003enu003cli data-mce-fragment="1"u003eFahnengröße: 90x150 cmu003cbr data-mce-fragment="1"u003eu003cbr data-mce-fragment="1"u003enu003c/liu003enu003cli data-mce-fragment="1"u003eseitlich zwei Metallösen zum Hissenu003cbr data-mce-fragment...

Verbesserung einer bestehenden Excel Datenbank

...amount of RAM is still free -> mysql query caching possible? Since the site is highly dynamic (activity feed, comments, groups and forums, messaging between members), complete caching is difficult to implement. We have already exhausted some possibilities for optimization: * Caching of some repetitive and "expensive" (i.e. slow) queries using static variables and using Wordpress transients. * Caching of various HTML widgets that don't need to update themselves all the time * Deletion of outdated transients, purging and cleaning of old DB entries and logs * Rewriting of plugins to avoid SQL queries within for loops, for example * Memcached and OPCache PHP Extensions were installed * Update to PHP 8 because of JIT still in consideration * Wordpress Plugin: Q...

...simplen Webform abfragen.) Bestätigungsmeldung bei erfolgreichem Import in Google-Calendar bzw Fehlermeldung bei Misserfolg. Job description A PHP script is required which carries out the following steps: Obtaining CSV file from external password protected (session ID) website. (Query login data in a simple web form.) Processing of the related data. Preparation of a custom CSV file according to Google Calendar Standard. Automatic import of the custom CSV file into Google Calendar with a predefined Google account. (Query login data in a simple web form.) Confirmation message for successful import into Google Calendar or error message for failure. ...

Fachinformatiker (m/w/d) in Erfurt Vollzeit Einsatz: 6 Monate mit Option auf Verlängerung Ort: Einweisung vor Ort in Erfurt Arbeitsort: Erfurt bevorzugt / Homeoffice möglich Die Akcay-Schwarz Consulting GmbH mit Sitz in Eschborn, seit mehr als 20 J...Anwendungsentwicklung • Deutsch/Englisch • Einsatztage 6 Monate mit Option auf Verlängerung / Einweisung vor Ort in Erfurt Arbeitsort Erfurt bevorzugt / Homeoffice möglich • Systemsoftware (Entwicklung, Programmierung, Analyse) • Programmieren Ihre Kenntnisse: • Web-Applikationen (Entwicklung, Programmierung) • PHP, Datenbanken JavaScript, Laravel (von Vorteil) • Datenank: SQL • Datenbankdesign • SQL-Query • Deutsch / Englisch – Kenntnisse • Hardwareinst...

I have a large set of car data that I output on my website - Here is an example page: There are many cars in my SQL database and the table plugin pulls certain columns with this query: SELECT Baureihe AS Modell, Motorisierung AS Motor, Motorart AS Kraftstoff, PS AS "Leistung in PS", Hubraum AS Hubraum, HSN AS "Schlüsselnummer HSN", TSN AS "Schlüsselnummer TSN", Getriebeart AS Getriebe, Steuer AS "KfZ Steuer pro Jahr*", Modellrange AS Baujahr, CO2WLT AS 'CO2 Ausstoß nach WLTP', CO2NEF AS 'CO2 Ausstoß nach NEFZ', Modellende AS Modellende, Modellstart AS Modellstart FROM carwiki_OPEL WHERE Baureihe='Crossland X' ORDER BY Steuer The problem is, that every car has a date range in the column n...

Ich brauche nur eine left join Query mit einem MAX() Wert

...technology should contact us. to the order: I would like to get developed a program, which crawls from a certain side the article conditions and the prices of the respective articles. The dealer is a competitor and I would like to match my articles to his prices, or make them cheaper. There are two problems. A safety program is used. If too high or too fast a request is made, there will be a captcha query. The second problem is the amount. There are almost 1,000,000 items. These would have to be compared every day or every two days. That is, in one hour the program would have to generate 40,000 queries in one day, and for two days it would be 20,000 to 25,000 queries per hour. If you want to know more, please contact me personally. I look forward to hearing from you....

VISTRA Ing.-Büro bietet seit 1994 Beratungsdienstleistungen im internationalen Umfeld (E...des Datenbanksystems (MSSQL) • Anpassung / Erweiterung des ASP.Net Web-Services im Rahmen von SaaS-Lösungen • Betreuung, Optimierung und Support im Microsoft Server Umfeld Ihr Profil • Abgeschlossene Berufsausbildung im Bereich IT oder ein entsprechendes Studium • Erfahrung in der Programmierung, Bestenfalls in der Umsetzung bei SaaS-Projekte • Kenntnisse in den Bereichen Transact Structured Query Language (T-SQL), ASP.net (Sprache: C#), PHP, HTML, CSS, Web-Services • Erfahrung mit Microsoft Team Foundation Server (TFS) und Microsoft Visual Studio Web-Developer (vorteilhaft aber nicht zwingend) • Selbstständige und ergebnisorientierte Arbe...

...1. Not copied 1: 1 from other sources, I can do that myself and is not asked. 2. Ideal: combination of two (opposing) topics (eg sports & literature, or typical women's issues with typical men's themes, pop culture and high culture) -> Questions Ex. see below 3. Entertaining, positive topics, not negative topics like terror, illnesses or accidents (unless there are funny accidents;)) 4. No pure query questions of numerical values ​​or data. 5. Questions for Swiss / International (no German topics such as politics and in-depth geography questions) Assignment: Create 5 questions for a moderated quiz: Combine the areas of culture (literature, poetry, painting, religion, music, history, science) with everyday / pop culture topics (memes, youth language, fast food, s...

...Hier habe ich etwas gefunden, was weiterhelfen würde. Danke für die Angebote Hy, I would like for the plugin ( ) an extension of the search. For the standard search, either tags or categories should be used. Where I use the categories already for a search. The new search is to query publicly or not publicly And select a category. I look forward to your offers. Many thank d...

Bitte melde dich an oder Loge dich ein um Details zu sehen.

...server in Germany () the other one on a server located in Hong-Kong (). If someone (located for example in Australia) is visiting our eshop .com the loading time is very slow. Therefor we are using some optimzation plugins for a better result. But the results are not that much better. If we activate some settings (Avoid landing page redirects, Remove query strings from static resources, Add Expires headers...) the sites will be crashed. Do some one have professional experiance about this subject? Please contact us if you are interessted and if you like to analyse our installations for making an offer. Thanks. ----------------------------------- Wir betreiben 2 WordPress WooCommerce eShops. Einer auf einem Server in Deutschland (

...spezifische Eigenschaften (custom attributes) hinterlegt wurden (System J!2.5 mit Virtuemart 2.0). Da die Artikeleigenschaften nur als „Verweise“ auf andere Datenbankfelder gespeichert werden, steht in der XML nur "kryptischer Kram" drin. Hier der gekürzte, bestehende Code: function daten_holen() { $GLOBALS['datakind'] = 1; $db_tableprefix = db_prefix_aus_config_holen(); $GLOBALS['query'] = ' SELECT ' .$db_tableprefix.'virtuemart_orders.virtuemart_order_id as orderID, ' .$db_tableprefix.'virtuemart_order_items.virtuemart_order_item_id as Positionsnummer, ' .$db_tableprefix.'virtuemart_order_items.virtuemart_product_id as produktID, ' .$db_tableprefix.'...

Hallo, ich suche einen IT-Fachmann für Servereinrichtung mit Expertise in Wordpress. Problembeschreibung: wir haben seit etwa einen Monat massive Probleme mit unserem Wordpress-Blog, z.B. wurden i...Neuerdings steht im Errorlog folgender Fehler: "mod_fcgid: can't apply process slot for /var/www/cgi-bin/cgi_wrapper/cgi_wrapper" Eine weit verbreitete Lösung des Problems für diesen Fehler, nämlich die maximale Anzahl an Prozessen in der zu erhöhen, hat ebenfalls keine Wirkung gezeigt. Auch die Querys in der Datenbank sehen für mich als Laien eher unauffällig aus, es läuft nur ein Query und eine Handvoll Prozesse die sich im Sleep befinden und nach 10Min gekillt werden. Da ich mit meinem Latein am Ende bin, hoffe ich, dass...

psresta shop,drupal,magendo,castom program vbnet psresta shop,drupal,magendo,castom program vbnet, psresta shop,drupal,magendo,castom program vbnet,

psresta shop,drupal,magendo,castom program vbnet psresta shop,drupal,magendo,castom program vbnet, psresta shop,drupal,magendo,castom program vbnet,

Good day Have servers are written quests in Lua (51 files) Task is to look briefly and see if a query in endless loop runs Guten Tag Habe Server questen die in Lua geschrieben sind (51 Dateien) Aufgabe ist kurz anzuschauen und schauen ob eine Abfrage in endlos Schleife läuft um So Schneller um So besser

Find a PHP coder for SQL query Good day Find a PHP coder of a table of all values ​​Auslessen and can be in a table Other transfer and to a log table The still Suche ein PHP Coder Für SQL abfragen Guten Tag Suche ein PHP Coder der von eine Tabelle Alle Werte Auslessen kann und in eine Andere Tabelle Übertragen werden und dazu in eine Log Tabelle Arbeit zeit heute noch

Guten Tag, Ich benötige eine kleine Query die über drei Tabellen via joins verknüpft ist Als Resultat sollen alle Spalten zurückgegeben werden.

...verwalteten Webseite präsentiert. * Es gibt für das Plug-In eine zentrale Konfigurationen (z.B.: Basis-URL der Web-Anwendung). * Das zu entwickelnde Plug-In wird auf mehreren Seiten im TYPO3 Baum eingebunden. * Diese einzelnen Instanzen haben spezifische Filterparameter, welche vom Redakteur angepasst werden können. * Diese Filterparameter werden beim Abrufen der Webanwendung übertragen (via http query), es müssen keine eigenen Filter-Routinen entwickelt werden. * URLs in der Antwort verweisen auf eine Detail-Ansicht. Diese müssen teilweise umgeschrieben werden, um die Darstellung der Details auch im Typo3 zu realisieren. * Die angepasste Antwort wird in die Ausgabe übernommen. Es besteht bereits ein Prototyp, der die Kernfunktionalit&...

I need someone who is proficient in web development to help with passing query parameter string into the SEO title page in a dynamic manner. For example, this is the URL of the framer pager I would like help with: However, when I pass the URL into to check if the query parameter is being passed in the SEO title, it fails and doesn't update. I would like a Framer expert who is also proficient in coding to help me with this project.

I'm in need of an expert server administrator with exte...Your role would be to assess the current setup, make necessary adjustments and ensure that the server is running optimally. - Troubleshooting: The primary issue I'm experiencing is a DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#' (Errcode: 2), query was: DESCRIBE `sessions`. Your expertise in diagnosing and resolving such issues will be crucial. Skills and Experience Required: - Proven experience in Plesk server administration, particularly in configuring and optimizing servers. - Strong troubleshooting abilities, particularly in resolving database query failures. - Ideally, experience in identifying and resolving security vulnerabilities and ...

...with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visualization tools like Tableau would also be beneficial in conveying the results of the database analysis. The ultimate goal of this project is to use data effectively to inform business decisions regarding our customer base. If you find you have these ...

### Query: I'm looking to create a WebAR experience without incurring expensive monthly costs. Could you suggest some cost-effective solutions and the necessary requirements for implementation? ### Requirements: 1. **Open-source Libraries**: - ****: - Technology: JavaScript - Compatibility: WebXR, WebRTC - Cost: Free - **MindAR**: - Technology: JavaScript - Functionality: Marker-based AR - Cost: Free 2. **Frameworks**: - **A-Frame**: - Integration: - Cost: Free - Technology: Web-based framework 3. **Combination Solutions**: - ** with WebXR**: - Technology: JavaScript - Functionality: 3D graphics rendering, AR integration - Cost: Free 4. **Commercial Platforms

I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.

...heavy loads, leading to frequent hangs and disruptions in our operations. To address this critical situation, we are seeking the expertise of an experienced Oracle Advanced DBA freelancer. We require a professional with the following qualifications and skills: - Extensive experience in Oracle Database Administration, particularly in high-load environments - Proficiency in performance tuning, query optimization, and troubleshooting - Familiarity with Oracle Enterprise Manager and other monitoring tools like aws performance insights The main responsibilities will include: - Diagnosing and resolving performance issues - Implementing best practices for database management and optimization - Ensuring high availability and reliability of the database - Providing recommendations f...

...Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and the necessary feedback will be given to the user during the payment and return processes. In addition, a simple test application ...

Bitte melde dich an oder Loge dich ein um Details zu sehen.

I would need a script written in nodejs where a USB NFC reader (specifically the ACR122U or the ACR125U) wait for a NTAG424 DNA tag. Once an NFC tag is tapped write a URL data into the tag as well as encryption keys. Make sure the URL contains query parameters which are mirrored uid, counter, and cmac that are all encrypted. Part of this is to write a nodejs script to validate the above parameters from the URL and decrypt the uid/counter (or some Rust that can do the same)

...bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integration: Connect the backend with the frontend using APIs. The APIs should be well-documented, secure, and efficient, allowing seamless communication between the backend and frontend. Requirements: Proven experience with CodeIgniter 3 and 4. Strong knowledge of SQL query optimization. Expertise in identifying and fixing bugs and security issues. Experience with API development and integration. Ability to work with the existing database structure without alterations. Good communication skills and ability to provide regular updates. Deliverables: Fully upgraded CodeIgniter 4 project with all features and functionalities working as expected. Optimize...

looks like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from S...

I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.

I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration ...be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are high...

i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it

I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...

...availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Automate File Transfer Based on Client and Project: Implement a system that automatically transfers the transport query from one file to another in the local drive based on the client and the current project folders. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the database based on predefined criteria (distance, size, location). Automate Communication: Automate the process of contacting couriers via Outlook, including sending inquiry emai...

...Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Development Additional Notes: a. application will need to determine which template to use based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multipl...

I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused

I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.

...file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weigh...

..."International Chinese Education Demand Monitoring, Prediction and Countermeasures Research based on Big Data", and create a website that can query the real-time popularity of Chinese learning language in all countries, the following is a website layout and function plan: ### Web Site name: Global Chinese Learning monitoring platform ### Website Layout: 1. * * Home page * * -Top navigation bar: contains the site name, search box, and user login / registration options. -Global map: 1. Identify the popularity of Chinese learning in different colors.2, Click each country, can feedback heat data, etc., you can jump to the second plate 2. * * National heat query * * -List of countries: arranged alphabetically for user search. -Search function: enter the name of the c...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.

I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS

...a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriat...

I'm looking for a skilled developer to update...controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a developer who can fix this bug fairly quickly, then will have on...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...