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 [login to view URL], SUM([login to view URL] * [login to view URL]) as price FROM Customers INNER JOIN Invoice ON [login to view URL] = [login to view URL] INNER JOIN InvoiceDetail ON [login to view URL] = [login to view URL] group BY [login to view URL] I CAN"T SEEM TO GET THE Customers.Firstname...etc... because of the SUM... I can get one or the other but not both...
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...
I need you to build a landing page. budget 600 Rs
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
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
I have 2 Spreadsheets that I have attached - Data from these 2 spreadsheets will need to fill in the 3rd spreadsheet.
...new table off the excel sheet we run a query to capture unique values using combined Inst and Mid query to extract unique string from excel field. I am encountering a challenge that the table I create from the above query has hidden charachters (?) I only see this after I export it to a text file. I need a query value to clean this up. I have tried
i have a sum query i need that a group by field should be based on a if statement purpose = i have two warehouse's but dont want each item to show double only if its not there in the first do i want it to show from the 2nd job will be done by loggin in remotely its a query based on other query the whole structure might need to be redone should
I need a SQL expert to create a query for me that will display a category list for me in a specific format. I will provide more details to a qualified bidder. Project budget: $30 Delivery Time frame: 1 hour
I have a php page that is taking a long time to execute and in addition in some cases its timing out. I need the mysql query optimized. ** Note: Plz only bid if you can start now Give me a guideline of how you will manage to do it. Provide of how long you think it will take you For your convenience, I've uploaded the file
Looking for someone to create a simple table that pulls and displays pre-sale and on-sale events from [login to view URL] via their API. Had one created by someone using Pythonanywhere but no longer have access to it. Should be a fairly simple project. You can use any language you prefer. I just care about the end result.
I have a mysql query that with large data sets does not complete. I need a mysql expert to tell me where the bottlenecks are and revise to complete faster. With the largest data set, current run time for a limit of 5 rows is over 3 minutes. With all rows 9,000 plus it does not complete. Attached is the query code. I know some variables are missing
Hi there, I need a Web Service to be built using PHP or Python. It would be a Scraper that would scrape google images based on a query and provide a link to that image in a REST API. I want to control the limit of results returned in the first request and when the limit is hit, return further results. For example : If there are 50 results in total
The website is fairly easy, 'standard' ASP with '__viewstate' and the usual, so the php-curl script needs to set the cookies and use those variables. The script needs to login, post (or get) a value in a form with a single text input, and get the result, which is 1 sentence, 2 sentences or 3 sentences, always in the same position. The script needs to get the value from a csv fi...
Need little help with coding In Office 2010 I want from Excel make query in Access. The accd is already open. In Excel I code: Public Function GetCollOntvInBoho(Dosnr) As Collection Dim AccessApp As Object, SqlBoho As String, rsBoho As Object, Coll As New Collection Set AccessApp = GetObject("X:[login to view URL]").Application If Not AccessApp
I wan to build an HTML Page, reading from MS SQL view or query with a filter control to filter data, and to be updated from same MS SQL view or table
...Dynamic Query Builder with JSON as input 1)Use Standard SQL in Google Big Query 2)Define your JSON input file . Parse the JSON to form the exact query . When two or more tables are involved Create View and then Query on the view 3)Use filters for where conditions and also keep in mind regarging Aggregate functions while building query . 4)Use
I am a romance author and looking for a query letter to send to literary agents for consideration for representation of sub-rights management. My author website is [login to view URL] and the book I'm submitting for is Sweet Promise, the first standalone novel in a trilogy (the stories of three siblings). I am only looking for someone
I making website farmer query system which run on localhost in visual studio(ASP.NET). i have a database on farmer query system which is connect with SQL SERVER . But problem is that answer is not display according to query text . 1. Answer display if i type whole querytext as it is in website . if i use single space and single upper case or lower
title sums it up quite well. We have 100k URLs that look like this [login to view URL] to look up products we offer for a particular make/model. If I understand correctly, google is treating all 100k results from our single asp page as 1 page so each result has virtually no juice. I need a pro that both understands SEO and know hows to convert above urls. but that can 1st advise authoritativel...
Small business with a 750 GB MS SQL db - need online trainer on Query Plans / Query Store to three developors. Must be able to provide this service in 1 - 2 hour sessions in Australian work hours. Have practical examples and database to test on.
I have an issue to query from same table to fetch some data select GuestNote,FName,LName,GuestID,[login to view URL] from Ondemands inner join Users on OnDemands.UserID=[login to view URL] where users.userid=3 and users.password='4201' and status='1' this return : FName,LName for userID=3 and return the GuestID which has FName,LName from same UserTable
***** No c/panel logins given don't ask.. Project for files only.. ***** Won't hire you if you can't abide...in-line in safari but scroller menu is there.. And in Chrome all images are inline but missing scroll menu.. Need the CSS fixed for multi browser.. Fix #2. Need to create a query and fetch the date uploaded like the format you see in shot...