...want a sql query that will take 2 dates (startDate & endDate) for a potential reservation and return uniIDs that don’t have any reservations that conflict with the startDate and endDate of the new reservation. The query will be used in a VB.NET form that provides 2 date time pickers for startDate and endDate and then displays the results in a data g...
Hi, I'd like to have the query archive ([log ind for at se URL]) links better organised to help the search engines indexation. See attachment for more details. I think that's an easy thing to do but my PHP skill is too poor for doing that myself. I need it done in one day maximum. Thanks.
SQL Query Optimization Its not writing queries. It is like designing the front page or the database as the master and will accept queries from slave(that is user). We will assume that the user knows to write sql queries(so which means my prof will give them) and i have to choose an algorithm (as shown in the ppt file) and do query optimisation I hope
...code. * Functionally equivalent and with the same look and feel and behavior to the query builder that you can find inside VS2003 and in MSSQL server 2000 Enterprise manager. * * Drag & drop support * Visual Query to SQL string and SQL string to visual query automatic alignment * Left, Right, Full, Cross join support, * Non equijoi...
I need a 5 field form built on a webpage. When it's submitted, it'll compare one field to a list. If a match is found, it'll display a particular message. If it isn't found, it'll display another message. Submitted form data is stored in a flat file somewhere easily accessible by myself, via a password protected page or text file of some sort.
Program should query the Google AdWords Keyword Tool (<[log ind for at se URL]>) and extract related data from **More Specific Keywords** then save the results to a csv file. The program should allow me to enter a large number of words, one per line. The results should be something like: "keywordquery1","relatedword1
...settingA*column2[+/-DayOfMonth] if (column2 < settingB) AND (column3 is < settingC) Thank You ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web
...files. I would like to upload these Excel files into my server & query them using a web form. I can 'save as' these Excel files into any other file format that you reckon would be easier to handle. The Excel files are attached with this bid request. I've designed a crude version of the web form([log ind for at se URL]) which is also attached with this bid...
Description of work: 1. Write a Coldfusion query using multiple tables, change tables if/or as required, re-do my current RSS feed to query all tables. 2. Have the capability to edit information in the tables using a Web form 3. Have the ability to delete an entire record using a Web Form Current Conditions I am writing an article about
...service application which parses entries in IIS log files into Sql Server on a timed basis utilizing application logic in conjunction with setting files and the LogParser 2.2 com object. ## Deliverables **Service Requirements** - All settings to be available to the application after initial setup will reside in standard xml based settings files contained
We need a program that can make queries of domain names. Basically we want a cross between this tool http://...in Google Yahoo and MSN and also time in search engines if possible It would run on our webserver and we would have all rights to it. See attached for images of suggested query page and results page. Thanks for your time and good luck!
Please visit [log ind for at se URL] Here you will see a multiple selection list that is divided up firstly by category, and secondly by alphabetical photograph name. What I want done is the following: The names in the list must be distinctly divided, using something like a red background for the name of the first photograph to show the start of a new category. So, with every new category, a red ...
...shop in Visual Basic .Net and MS SQL Server 2000 as backend. I want a Visual Open Query Builder for that project. User wants to select the fields and search as per his wish. While Create the table I add “Description?? for each field. So the user will select that field and get the result from that. It’s an open query, he can search, what ever he think
...functionality from one query to another. The problem is performance; this new functionality slows down and then crashes Access when I do this. The required functionality is illustrated in the query: “Rank_And_Quartile_Calcs?? : For every test score, I need to determine Rank (e.g. 1 out of 100) and Quartile (e.g. 1st, 2nd, 3rd, 4th). This query works fine
Query a bibilogrpahic database via a web service interface. The program must provide a user interface with several fields such as Author, title. publisher etc which is presented to the user to be filled in. The program contructs the command line required by the web service, wraps it in a soap envelope and sends it off. The results returned will be provided
I need a new query in an existing Access Project: Rank And Quartile. My existing query returns Student, Course, Test Score: I need 2 columns Added, Rank and Quartile. See the attached Excel. Columns F and I are what I need the Access Query to do. ## Deliverables The Access attached file returned, with a new query that has two new columns
...find out why when i run one update query my report runs fine but when i run other update query my report does not work the only difference in the update queries is one calcuates the sales ratio by T_T_V / SALE_PRICE and the other one calcuates the sales ratio by REMAIN_VAL / A_V_I update query CALCULATE SALES RATIO TTV/SP that
...Track) supernodes as possible and harvest search query data from the network. The search data should be output to a .txt file with 1 query on each line. This application should filter non-latin results from the output. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done
...script that will query Yahoo movies (or someone similiar) for movie times and display them on a page that matches my site. Again, if you already have a script, I will consider places besides Yahoo Movies, because I will need this fast. Thanks. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete
...protection, if you are interested in this project, please work-out and document the requirements onsite. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web
...have already started the template for the way we want it setup There will be the following options: 1. Select date range with the hour in 24hr format (will have popup calander option or direct entry) 2. Select the primary or secondary data source (we have two separate tables with the same data for backup purposes) 3. Then an option to select "All
...members on a MS SQL database. The site runs queries and it is all pretty much complete in terms of faculty information. Write back and I'll send you the URL. For our project, we need to query that SQL server to grab any existing data, so we don't have to reinvent the wheel and do everything again. We simply get most of the data from that databas...
...programs for a database query module. Overview Program 1: The test program use 2 classes. Class A is a test class representing a larger system. Class A accesses the public method(s) of a Class B to initiate the creation of a new account object. Class B checks for pre-existing accounts in a small data base(flat file or even raw data as part of the main
...initial html page has a form that inputs a phone number. When the form is submitted, it calls the PHP file: [log ind for at se URL] and then present another HMTL page that has the look up variables displayed. [log ind for at se URL] retrieves the form value and then queries the w3data site using the format of <[log ind for at se URL]$phone>, where
I have a script that current will out put 2 forms content to another cgi and display the form output. I need the a cgi perl script that will insert the content of the forms to a mysql database so I can query the db using this cgi to display the content ex, give me the number of the records from 1/1/2005 -2/1/2005 The database schmea will include 4
Query must be produced using table JOB job_id open closed splitfrom mergedto ====================================== AAAA 1/1/90 1/1/00 BBBB 1/1/80 1/1/00 CCCC 1/1/00 1/1/01 AAAA EEEE DDDD 1/1/00 1/1/01 BBBB EEEE EEEE 1/1/01 FFFF 1/1/01 CCCC ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well
...part, for each employee, re trieve the employee’s name and his or her supervisor’s name. Second query : Retrieve the name of each employee who works on ALL the projects controlled by “R&D?? department. [This is not similar to another query I did that give's an ANY result. ALL needs a divider operator?] Here is what I did. SELECT works...
I need help getting started with the MySQL query browser. I think I need a few scripts to help with the following: Create Customized Views- so I can easily open a table and have selected columns displayed at a preset width. Search and Replace Data: I need an easy way to seach and replace data... (eg replace the string '../../hello' with '
...PHP code to work: $ipinfo = getipdata($ipinfo) // gets array of IP data echo "Organization: " . $ipinfo["org_name"] echo "Starting IP of block: " . $ipinfo["ipstart"] echo "End IP of block: " . $ipinfo["ipend"] The "ipinfo" PHP function you write should make an rwhoisd server query to get the result. More deta...
I am seeking a web-based ad-hoc query tool that allows me to connect to any database or dataset. The tool must have a drag and drop interface for performing the analysis. I am looking for something similar to OLAP cubes. The bidder must show me examples of previous work like the tool that I describe above. The tool must be well documented
Develop web interface for administration of a media database > User interface with roles: admin, ...admin, information provider, user > Categories for information provider > Featured information content > admin content Develop web interface to query database and show result > Query by title or provider or location Web design
...word='chips' word_occurrences - list of words in each document and which document they appear in, e.g: id=1 word_id=1 doc_id=1 id=2 word_id=2 doc_id=1 I think this query is good to select all documents that contain the word 'fish' or 'chips' select DISTINCT([log ind for at se URL]),[log ind for at se URL] from document_index as di,word_occurr...
I need a script that will query Google, Yahoo, MSN, Ask Jeeves, Altavista and Teoma. With a list of search term, and create a database with all the URLs in one row and another row with the domains. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables
...expert how to query the database from command line, for example: $ mysql mysql$ SHOW DATABASES; mysql$ CONNECT mydb; mysql$ SELECT * FROM X, Y WHERE [log ind for at se URL] = [log ind for at se URL] ETC ETC ALL ARTICLES AND SCREENSHOTS/IMAGES MUST BE 100% ORIGINAL ## Deliverables 1) Complete and fully-functional working program(s) in executable form as wel...
I'm looking for someone to create a simple program that will query the Overture search term search engine and return the results into Excel. Overture SE: [log ind for at se URL] The program will have a couple of options 1. Return exact keyword results, view the attached spreadhseet "Keyword Market Demo
...process. As a result, they could register, but never got confirmed. I need the following; I need a query mysql query that I can run against the database to reveal all names that have not completed the registration process. I also need a query for the database that will force confirmation emails to be resent to each user that has not completed
I HAVE NO MONEY! I AM A BROKE COLLEGE STUDENT. This is simply an idea and because I do not fully understand how EBay, [log ind for at se URL], or [log ind for at se URL] work, I have no idea how much it would cost to code or if it is even plausible. I had the idea that an RSS ticker would report back the latest auctions/items-up-for-sale based on the user's input. The ticker would look for it...
...siteaddress=peter http://www.siteaddress=james I need a program that will go to the page that they are linked to and return all data as standard text. In the page there are 11 field titles that are all the same (only the data differs) - please see attached image as an example web page. I want the information for each page pulling back into one row per
...have just setup a mail server with: Postfix + MySQL + maildrop + quota + clamav + courier pop3 + courier imap + greylisting. I can create a domain and user in MySQL, then when an email is sent to that user everything is setup automatically. The hole in this whole operation is that when the domain is deleted from the MySQL / postfix setup, the directories
The creating of a MS Access query (query preferable to hard code) that enables a small set of data to be displayed in chart form. The chart needs to display one set of string variables as the column headings and dates (or days of the current week) as row headings, with names appearing as the charted data. In actual fact it is to monitor the drivers
We are in need of an very fast bulk whois tool. We will not be using it to extract emails, rather it is for a domain analysis setup to see what companies own what domains, and expiration dates of domains, etc... This will ONLY be needed for .com, not .net or .info, etc.. I would need the output stored in a mysql table, Some notes on what
...experienced eBay developer to develop a stand-alone executable that will query eBay and use the data to populate simple delimited text files. We will then use these text files to populate a database from which we will produce print catalogs. We are NOT asking to write any data to eBay. As far as this phase goes, this is a read-only application. The
...results which contain data in a different field (this field will not always contain data). ie: SELECT A, B, C, D FROM tblPics SORT BY A but give priority to rows in which C is not empty. Site code is ASP and database is Access. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source
...it send that information to the KJ. I am open to suggstions on making this possible. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web
I have built a searchable data base of local restaurants and bars for my visitors and everyting has been tested and functions fine. I do have one problem. I would like the output 'prettied' up a bit. Ideally, I would like the output to be shown in PHP Nuke, as it would then match everything, but I'm not sure if this is possible. If not I guess I'd need
...create a program that can query excel file formats and display/print/save in a new view. If the coder does well I have many queries I want built into it later. Program Flow: 1.) Open program 2.) import external file (displays in child window) 3.) query file for needed data 4.) total time for each date 5.) format data into needed format (see
...a [log ind for at se URL] clone query. I am not needing a site. I am simply looking for a query that goes out there and retrieves data on people. You must have your own people search databases to be considered. Serious inquiries onlye ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source