Qry jobs

Objective: Create a Microsoft Access database to log/track incident calls and output a variety of reports. Parameters: - Must be compatible with Access 2016. - Be able to export to Word 2016 and Adobe Acrobat 2017 - Be coded in a generally accepted format that makes clear distinctions between various functions (forms -frm, tables-tbl, reports-rpt, queries-qry, etc.) Details: - Every call (record) will have a unique ID number that starts with the two digits for the year followed by a four-digit number that ascends with each call entry (ie. #23-0001). - There will need to be approximately 20-25 fields with the need to open up additional fields if a particular YES/NO selection is made. - Everything in this database will be based off of the call input form (fields to be pr...

The results of a mySQL query is an excel sheet with three tabs: sub qry 1, sub qry 2, and whole query. Sub qry 1 returns 4 queries which I have highlighted. Similarly, whole query is also highlighted and should return 4 queries, but instead returns 8. Please fix the query so that the query in tab - "Whole Qry" returns 4 rows.

...option to save a text file to DropBox that contains the specified information Details of the first window is provided below, together with the source data that is used by iGenomics to generate its analysis tables, and the output file format is provided below. ________ The format of the file will be a CSV array with the format Columns: “Ref”, (single text letter) “Qry”, (single text letter) “A”, (integer), if null then “0” “B”, (integer), if null then “0” “C”, (integer), if null then “0” “D”, (integer), if null then “0” “-“, (integer), if null then “0” “+”, (integer), if null then “0” Rows: Ref (positi...

- Build a new API for WHMCS which use for register Hong Kong domains from HKDNR. We will provide related SGCL’S API documents. - Support actions: NDN Register Domain RNW Renew Domain TTR Transfer Domain QRY Query Domain NDNA Register Domain with Trustee Service - Support WHMCS 7.x 8.x

I need a PHP script for import in Magento2.4 products via CSV File. The script should check the CSV from a path and import products qry in the database

I have a MS Access program, that has a daily log that is set by todays date. Rarely items need to be back dated, previously we could change the system date restart Access go to the log and enter data.. then change date back. What I was trying to do was make a copy of the form, edit the QRY to ask for a date and open the log. Allow them to enter and close the form. was one way I was thinking. Possibly this could be done on the same log, and just let them change the date. Some follow through of the code would be great too after change so we can make sure it works properly. Team Viewer session it will be easy to show how it works. thanks.

Hi Basically i'm looking for a non-generics version of the...IQueryable's, without going to the db until final execution (no tolists etc till after the join is built) code should be lean and clean, no extra logging, exception handling, external libraries etc Stored Procedures/temp tables are irrelevant, this must work via entity framework IQueryable The way I will use your code is like this dim qOrders=MyIQueryableA dim qClients=MyIQueryableB dim new qry=BrandNewFullJoinFunction(qOrders,qClients)'it might be necessary to add additional parameters here, such as join fields etc, thats ok i should get back all orders, as well as a all clients that do not appear in the qOrders if you can do this for me, youre in! PS. Please send final price. no hourly rates/mileston...

This project has been started. We need someone to test, troubleshoot and complete the project as soon as possible. You will be required to complete the following: 1. Complete the input of PARSEd data into a MS access database table 2. Test and complete the macro that POSTs a access qry to our woocommerce endpoint URL All files and test website will be supplied. Payment upon completion.

android app to link to sql base with 6 tables execute insert , update qry to one table in sql base from android

...LINE 4619 PIPE LINE OPERATION 4712 FREIGHT FORWARDING 4723 SHIPPING AGENTS 4784 VEHCL FIXED FACILIT 4789 TRANSPORT SERVICES 4925 GAS PRODUCTN&DISTRB 1211 COAL/LIGNITE MINING 1213 COAL/LIGN MNG SVCS 1311 CRUDE PETR/NAT GAS 1321 NAT LIQUID GAS PROD 1381 OIL/GAS DRILL SVCES 1382 OIL/GAS EXPLOR SVCE 1389 OIL/GAS FIELD SVCES 1442 SAND/GRAVEL-MNG/QRY 1446 INDUST SAND-MNG/QRY 2411 LOGGING CAMPS&CNTRS 811 TIMBER TRACTS 821 FOREST NURSERY 843 PINE GUM EXTRACTION 849 FOREST PRODUCTS 851 FORESTRY SERVICES ...

[Zimbra, zimlets addon : left menu + iframe] I attached sample source code & Screenshot. ######################### [left menu] ######################### - Dynamic menu list , ( using Mysql query ) (ex) $qry = "select bo_table from g4_board"; admin,amimc,bbs1,bbs2, ... $left_menu_html .= "<a href = '/mbbs/bbs/' target='tabiframe-app'>1. admin</a>"; $left_menu_html .= "<a href = '/mbbs/bbs/' target='tabiframe-app'>2. amimc</a>"; $left_menu_html .= "<a href = '/mbbs/bbs/' target='tabiframe-app'>3. bbs1</a>"; $left_menu_html .= "<a href = '/mbbs/bbs/' target='tabiframe-app'>4. bbs2</a>&qu...

i'm looking for a website developer that can design and build an amazon affiliate like the one at, , i don't want those websites copied use them as a guide only

For an international customer, I'm looking for an IT specialist with the profile mentioned below to work in Prague. Profile: Technology: - DB2, RPG, RPGLE, CL, CLLE, ILE, SQL, SDA, PDM, DFU, RLU and QRY on AS/400 - iSeries, COBOL - Should be able to write HLD and LLD - Should be able to contribute in technical discussions - Code, Analyze and also help the offshore team in their technical queries - Liase with Users , other vendor personnel, etc. - Should be sending a daily update of the work performed to the manager and highlight any challenges in meeting the upcoming tasks Domain Knowledge: - Should have worked for a BFS client, preferably in Core Banking. - Should have experience of working in Managed Service delivery model, driven by stringent SLA's and OLA Soft Ski...

For an international customer, I'm looking for an IT specialist with the profile mentioned below to work in Prague. Profile: Technology: - DB2, RPG, RPGLE, CL, CLLE, ILE, SQL, SDA, PDM, DFU, RLU and QRY on AS/400 - iSeries, COBOL - Should be able to write HLD and LLD - Should be able to contribute in technical discussions - Code, Analyze and also help the offshore team in their technical queries - Liase with Users , other vendor personnel, etc. - Should be sending a daily update of the work performed to the manager and highlight any challenges in meeting the upcoming tasks Domain Knowledge: - Should have worked for a BFS client, preferably in Core Banking. - Should have experience of working in Managed Service delivery model, driven by stringent SLA's and OLA Soft Ski...

For an international customer, I'm looking for an IT specialist with the profile mentioned below to work in Prague. Profile: Technology: - DB2, RPG, RPGLE, CL, CLLE, ILE, SQL, SDA, PDM, DFU, RLU and QRY on AS/400 - iSeries, COBOL - Should be able to write HLD and LLD - Should be able to contribute in technical discussions - Code, Analyze and also help the offshore team in their technical queries - Liase with Users , other vendor personnel, etc. - Should be sending a daily update of the work performed to the manager and highlight any challenges in meeting the upcoming tasks Domain Knowledge: - Should have worked for a BFS client, preferably in Core Banking. - Should have experience of working in Managed Service delivery model, driven by stringent SLA's and OLA Soft Ski...

For an international customer, I'm looking for an IT specialist with the profile mentioned below to work in Prague. Profile: Technology: - DB2, RPG, RPGLE, CL, CLLE, ILE, SQL, SDA, PDM, DFU, RLU and QRY on AS/400 - iSeries, COBOL - Should be able to write HLD and LLD - Should be able to contribute in technical discussions - Code, Analyze and also help the offshore team in their technical queries - Liase with Users , other vendor personnel, etc. - Should be sending a daily update of the work performed to the manager and highlight any challenges in meeting the upcoming tasks Domain Knowledge: - Should have worked for a BFS client, preferably in Core Banking. - Should have experience of working in Managed Service delivery model, driven by stringent SLA's and OLA Soft Ski...

For an international customer, I'm looking for an IT specialist with the profile mentioned below to work in Prague. Profile: Technology: - DB2, RPG, RPGLE, CL, CLLE, ILE, SQL, SDA, PDM, DFU, RLU and QRY on AS/400 - iSeries, COBOL - Should be able to write HLD and LLD - Should be able to contribute in technical discussions - Code, Analyze and also help the offshore team in their technical queries - Liase with Users , other vendor personnel, etc. - Should be sending a daily update of the work performed to the manager and highlight any challenges in meeting the upcoming tasks Domain Knowledge: - Should have worked for a BFS client, preferably in Core Banking. - Should have experience of working in Managed Service delivery model, driven by stringent SLA's and OLA Soft Ski...

For an international customer, I'm looking for an IT specialist with the profile mentioned below to work in Prague. Profile: Technology: - DB2, RPG, RPGLE, CL, CLLE, ILE, SQL, SDA, PDM, DFU, RLU and QRY on AS/400 - iSeries, COBOL - Should be able to write HLD and LLD - Should be able to contribute in technical discussions - Code, Analyze and also help the offshore team in their technical queries - Liase with Users , other vendor personnel, etc. - Should be sending a daily update of the work performed to the manager and highlight any challenges in meeting the upcoming tasks Domain Knowledge: - Should have worked for a BFS client, preferably in Core Banking. - Should have experience of working in Managed Service delivery model, driven by stringent SLA's and OLA Soft Ski...

For an international customer, I'm looking for an IT specialist with the profile mentioned below to work in Prague. Profile: Technology: - DB2, RPG, RPGLE, CL, CLLE, ILE, SQL, SDA, PDM, DFU, RLU and QRY on AS/400 - iSeries, COBOL - Should be able to write HLD and LLD - Should be able to contribute in technical discussions - Code, Analyze and also help the offshore team in their technical queries - Liase with Users , other vendor personnel, etc. - Should be sending a daily update of the work performed to the manager and highlight any challenges in meeting the upcoming tasks Domain Knowledge: - Should have worked for a BFS client, preferably in Core Banking. - Should have experience of working in Managed Service delivery model, driven by stringent SLA's and OLA Soft Ski...

For an international customer, I'm looking for an IT specialist with the profile mentioned below to work in Prague. Profile: Technology: - DB2, RPG, RPGLE, CL, CLLE, ILE, SQL, SDA, PDM, DFU, RLU and QRY on AS/400 - iSeries, COBOL - Should be able to write HLD and LLD - Should be able to contribute in technical discussions - Code, Analyze and also help the offshore team in their technical queries - Liase with Users , other vendor personnel, etc. - Should be sending a daily update of the work performed to the manager and highlight any challenges in meeting the upcoming tasks Domain Knowledge: - Should have worked for a BFS client, preferably in Core Banking. - Should have experience of working in Managed Service delivery model, driven by stringent SLA's and...

For an international customer, I'm looking for an IT specialist with the profile mentioned below to work in Prague. Profile: Technology: - DB2, RPG, RPGLE, CL, CLLE, ILE, SQL, SDA, PDM, DFU, RLU and QRY on AS/400 - iSeries, COBOL - Should be able to write HLD and LLD - Should be able to contribute in technical discussions - Code, Analyze and also help the offshore team in their technical queries - Liase with Users , other vendor personnel, etc. - Should be sending a daily update of the work performed to the manager and highlight any challenges in meeting the upcoming tasks Domain Knowledge: - Should have worked for a BFS client, preferably in Core Banking. - Should have experience of working in Managed Service delivery model, driven by stringent SLA's and...

I am in a middle of development and I am stack and need your help, I am trying to change configurable product to be working like group product like In this page: - you can see that instant the drop down of the option we see a list of all assoiciated products of this configurable with qry field near each one and one add to cart button that add in once any product in the list with more then 1 qty (like group product) - this is my page development but the add to cart not collect the products and add them to cart: ~shahar/ please see in this url

...to be able to be sorted by each field, filtered by each field, filtered by date-range option, and the results to be able to be exported in a csv or excel spreadsheet for the client to download. Along with this, I will need a full query that can be run as a cron job, that will automatically email the base report to the client each day or week (specify weekday). The query is very simple: $qry = "SELECT , , , , , , , AS 'dateAdded' FROM `c` AS c INNER JOIN bdc AS bdc ON = INNER JOIN p AS p ON = WHERE = '$propId' ORDER BY ASC "; NOTE: This is a report showing birthdays that are upcoming. If the date (for

Hi, This should be quite a simple project - nearly found some code online but couldn't quite make it work. I have a table in access with sales by brand and need a a button on the form as well as a drop down for date with "select distinct" dates showing. When the user selects a date and hits the button, it will separate the table and export into multiple seperate excel files breaking the table down by Brand for the date selected. On the xl. file name needs to include brand and date and save to a new folder with that date on it. Please let me know a quote for price and how long it will take. Thanks

See it is the sample: i want this page with/without images converted to word .doc only. no pdf. i want text, if possible images too. i want a tool or process. budget is $30 only. you must show me the sample, with your bid. bids without sample ignored. ask me if you have any questions.

See it is the sample: i want this page with/without images converted to word .doc only. no pdf. i want text, if possible images too. i want a tool or process. budget is $30 only. you must show me the sample, with your bid. bids without sample ignored. ask me if you have any questions.

For an international customer, I'm looking for an IT specialist with the profile mentioned below to work in Prague. Profile: Technology: - DB2, RPG, RPGLE, CL, CLLE, ILE, SQL, SDA, PDM, DFU, RLU and QRY on AS/400 - iSeries, COBOL - Should be able to write HLD and LLD - Should be able to contribute in technical discussions - Code, Analyze and also help the offshore team in their technical queries - Liase with Users , other vendor personnel, etc. - Should be sending a daily update of the work performed to the manager and highlight any challenges in meeting the upcoming tasks Domain Knowledge: - Should have worked for a BFS client, preferably in Core Banking. - Should have experience of working in Managed Service delivery model, driven by stringent SLA's and...

Project 3 Optimise basic algo (start with variable runs and smart picking of values). - include ramp up 4 machines (called Conner001 etc - do snapshot of conner001 and replicate) use 10 days of csv data to be supplied. The first milestone (75% of bid) will be to review this strategy...been achieved then milestone 2 will be the successful application of the queries to separate test data (1-3 days) maintaining reasonable performance. *reasonable. From our recent experience we have both realized it is hard to be specific and that this process is intuitive. I use "reasonable" with fairness and commercial common sense applied. - also query files generated to be YYYYMMDD-ABV-001.qry etc, skip existing files where ABV is abbreviation for algo (eg IH001 for my first one, proje...

Ibm I Series – DB2 web qry reports. We currently run AS400 IBM I series with VAI System 2000. We are running DB2 web query / developer workbench. We have a series of reports that we access on a regular basis. We have an issue with one of our reports related to security. When drilling down into the report we get an access denied. This has happened after our I series update to V7R1M0 We’re looking for someone to clean up the security and fix two reports. If you are an AS400 expert and extremely fluent with DB2 web query and developer workbench we are looking for you. Also if we find the right fit we will want the occasion report created down the road.

Ibm I Series – DB2 web qry reports. We currently run AS400 IBM I series with VAI System 2000. We are running DB2 web query / developer workbench. We have a series of reports that we access on a regular basis. We have an issue with one of our reports related to security. When drilling down into the report we get an access denied. This has happened after our I series update to V7R1M0 We’re looking for someone to clean up the security and fix two reports. If you are an AS400 expert and extremely fluent with DB2 web query and developer workbench we are looking for you. Also if we find the right fit we will want the occasion report created down the road.

Ibm I Series – DB2 web qry reports. We currently run AS400 IBM I series with VAI System 2000. We are running DB2 web query / developer workbench. We have a series of reports that we access on a regular basis. We have an issue with one of our reports related to security. When drilling down into the report we get an access denied. This has happened after our I series update to V7R1M0 We’re looking for someone to clean up the security and fix two reports. If you are an AS400 expert and extremely fluent with DB2 web query and developer workbench we are looking for you. Also if we find the right fit we will want the occasion report created down the road.

...and we will be working together on this project. - This project has a couple of steps - completion of this first step will provide additional work later on. - You must use Fusion tables API PHP library / no exceptions. Tasks create an end point / Select from table of providers eg. qry = "SELECT lat,lng FROM PROVIDERS" get the 200 locations. Now - select all users from another table that are nearby each of the locations above qry = "SELECT lat,lng,Name FROM " + tableid + " WHERE ST_INTERSECTS(lat, CIRCLE(LATLNG("+lat+","+lng+")," + meters + ") returns 50 names in json , and their long / lats of people nearby the nearby the 200 different locations. eg. {location:123432, users:[{&q...

...Data" this has to be a very easy and quick proccess because there are over 50 Routes to be created. 2. Utilization Allocation: a) Utilization by supplier in MS Access: Look at the Queries in the database. It relates to the supplier tabs in the Excel. Most of the calculations have already been completed. Example: If you look at tab "CUSTOM MOLDED PRODUCTS" in the Load and find "QRY: Sub Total Release.." in the database >>Filter>>DeliverDate "12/2/2010" You will see that the Utilization has already been calculated to match Utilization on the Excel sheet. - You need this information for next step 2b. b)Truck Assignment: Assign Results of Utilization Calculation to Number of Trucks Assigned in 1(b) above. So when a file ...

...the bid is over. **public static IList<EventListing> FeaturedEvents(int Max)** { var DB = new ThisTicketComDBDB(); var qry = ("EventListing").OrderDesc("CreatedOn"); // TODO LIMIT TO TOP 5 RESULTS // TODO get random events // = "5"; var events = <EventListing>(); return events; } **public static IList<EventListing> TopEventsPerDate(DateTime SelectedDate, int Max)** { var DB = new ThisTicketComDBDB(); // SELECT @ // FROM [v_EventTimePerDate] // where [StartTime] = @SelectedDate // TO DO // in the database there is a view: v_EventTimePerDate var qry = ("EventListing").OrderDesc("CreatedOn").Where("StartTime", , (-1)); // TODO

...Data" this has to be a very easy and quick proccess because there are over 50 Routes to be created. 2. Utilization Allocation: a) Utilization by supplier in MS Access: Look at the Queries in the database. It relates to the supplier tabs in the Excel. Most of the calculations have already been completed. Example: If you look at tab "CUSTOM MOLDED PRODUCTS" in the Load and find "QRY: Sub Total Release.." in the database >>Filter>>DeliverDate "12/2/2010" You will see that the Utilization has already been calculated to match Utilization on the Excel sheet. - You need this information for next step 2b. b)Truck Assignment: Assign Results of Utilization Calculation to Number of Trucks Assigned in 1(b) above. So when a file ...

...of signing-on to the software for two layers of users, clerks and managers with different access (clerks can't void a money order for example) Connecting to a remote-accessable microsoft SQL database. Have a local configuration file holding the information such as that listed in the image below Adding a fee to each item sold, and having that value changable on the client-side. Being able to qry differen types of reports from the store's table. (ex: all money orders sold today w/total) Printing money orders on a continuous-feed local USB-type printer with pre-printed money orders. (program would print the amount, to:, authorization) Ability to void, and reprint (by voiding and re-printing) Be able to keep sequence as the money order numbers sold according to the...

Convert MS Access Append Qry to VBA code: requirement to append Sybase linked table data into existing MS Access database table based on date period with count; source Sybase table contains over 40 millions rows; Access Database with append query included in zip file ADDED COMMENT: the target database could be MS SQL Server linked table in case the target output exceeds max size of MS Access 2003 database which is 1GB ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement). ## Platfo...

...worker. Each keyword set needs 15 good links, good pr links from google. You get the link from Google search in the browser. I need 15 urls PLUS the name of the website. So Ill need 15x15 = 225 sites/urls - and I do need good PR sites if possible. They're usually at the top of the search. For example keyword - koala infant costume website - K Directory URL (Thats 1 done) 14 more website/urls to go, then move on. A Anyway I can explain it better later on if its not clear. Trust me its a simple google search and copy the top result or 3 or 4 website and url. That's it, should be quite quick and easy work for the right candidate. Thanks ## Deliverables 1) All deliverables will be considered "work

the video says is because im not in the country permitted to view it..but i tried different ips and still same thing.. i want to download this video to view it..but i tried different ips and still same thing.. i want to download this video if you in U.S.A is the first video here the thumbnail is black and white and says OFFICIAL - "el mejor de todos los tiempos"

I have a employee payroll project i made, where the person logs in using their id and the program checks to see if they are a manager or a employee and takes them to the appropritate forms. however i included a begin shift and end shift buttons that should send the current system time to an access database i already have setup. I cant seem to get the qry and the coding right can someone please help?

.../usr/lib/mysql/libmysqlclient_r.so.15 #1 0x006c2caa in memdup_root () from /usr/lib/mysql/libmysqlclient_r.so.15 #2 0x006e6b23 in unpack_fields () from /usr/lib/mysql/libmysqlclient_r.so.15 #3 0x006e70b3 in mysql_read_default_options () from /usr/lib/mysql/libmysqlclient_r.so.15 #4 0x006e54f4 in mysql_free_result () from /usr/lib/mysql/libmysqlclient_r.so.15 #5 0x080d8698 in MYSQL_OBJ::Exec (this=0x899abe0, qry=0x89a2fb8 "SELECT * FROM conntbl WHERE (id1='57783' AND id2='41508') OR (id1='41508' AND id2='57783')") at #6 0x080db4ae in MYSQL_OBJ::RunNextQuery_ifLastResult_isProcessed (this=0x899abe0) at #7 0x080f0c4c in SqlThread (ptr=0x80fa2bf) at #8 0x00c8d73b in __pthread_initialize_minimal_internal () from /lib/libpt...

...t_r.so.15 #1 0x006c2caa in memdup_root () from /usr/lib/mysql/libmysqlclient_r.so.15 #2 0x006e6b23 in unpack_fields () from /usr/lib/mysql/libmysqlclient_r.so.15 #3 0x006e70b3 in mysql_read_default_options () from /usr/lib/mysql/libmysqlclient_r.so.15 #4 0x006e54f4 in mysql_free_result () from /usr/lib/mysql/libmysqlclient_r.so.15 #5 0x080d8698 in MYSQL_OBJ::Exec (this=0x899abe0, qry=0x89a2fb8 "SELECT * FROM conntbl WHERE (id1='57783' AND id2='41508') OR (id1='41508' AND id2='57783')") at #6 0x080db4ae in MYSQL_OBJ::RunNextQuery_ifLastResult_isProcessed (this=0x899abe0) at #7 0x080f0c4c in SqlThread (ptr=0x80fa2bf) at #8 0x00c8d73b in __pthread_initialize_minimal_internal () from /lib/libpthread.so.0 ...

...the project has been initiated: I will provide an example of each report type, however, in summary: List reports is a simple query generating a list of customers Management reports are roll up/summary reports that will need to be grouped at various dimensions Graph reports are simple queries that should return line/bar charts In this project I will ask for three specific qry/reports to be developed to return an example of each report listed above. I’ll provide the specifics of those queries once I’ve passed the sample data. Our goal is to have a working demo available within 1 week for review and feedback and final project delivered w/in one week following that. We'll be available to discuss in as much detail as necessary once w...

This project involves building an HL7 interface for and HL7 compliant server. Interface must be written in C# and ASP.Net 3.5 platform. The desired clas...bidirectional fashion meaning that it should be able to convert received HL7 messages to data values and also convert data values to HL7 message to be sent to the server to perform updates. This is a multi part project. in the first part we like to be able to process following message types: ACK – General acknowledgement ORM – Order (Pharmacy/treatment) ORU – Observation result (Unsolicited) QRY – Query, original mode RAS – Pharmacy/treatment administration RDE – Pharmacy/treatment encoded order RGV – Pharmacy/treatment give Solution must be scalable to accept other message typ...

Once a week, the site will have a contest that viewers can enter their guess about the age and score of a buck from a hunting show.? Before saving the entry, we check to see if there is already an entry for the submitted email address. ## Deliverables The following values should be collected by t...table should also store a timestamp of when the entry was submitted. Before saving the entry, query should run to check if entry for this week has already beden submitted for this week.? Show airs on Thursday, so entries should be validated for prior entry from 5pm thursday until 5pm thursday a week later.? This should work automatically from week to week. Queries should be contained in qry cfc.? Queries should be in coldfusion templates with cfqueryparam rather than stored p...

...methods of a TDataset here end; constructor (aOwner:TComponent); begin inherited; qry:=(self); esy:=(self); end; procedure ; begin (* pseudocode: 0. if cache disabled, call inherited code 1. if SELECT, check is the query is in the cache 2. if so, return what is in the cache 3. else begin call inherited code CreateCacheFile; end; *) if Pos('UPDATE',Uppercase())>0 then dataset:=qry else if Pos('DELETE',Uppercase())>0 then dataset:=qry else if Pos('INSERT',Uppercase())>0 then inherited Open else if Pos('OPEN',Uppercase())>0

Hi, i need a sql qry wich qry over 3 tables. Thing is, this should be a website abaout cocktails. So i have about 50 checkboxes with different kinds of ingredients (e.g. Rum, Vodka etc) So the user can click what they like to use for there Cocktails. So now if the user Checks Rum, Cola and lemon the qry will return "yeah so you got Rum, Cola and lemon . Try a Cuba libre" Because it contains exactly Rum, Cola and lemon. Now the user selects Rum and Cola - The script WONT return cuba libre, because you need also lemon for that. Now the user selects Rum, Vodka, Cola, lemon - The script WILL return cuba libre, because you can do it with the selected ingedients. I will add a .sql file with Database and a Screenshot form Ser...

...that have relations. All VBA code must commented (within reason) and and all variables must be named in some standard method to allow a different programmer to understand the code and make changes with significant difficulty. I recommend using Hungarian notation for naming variables and all Access objects.? Also Use common/standard naming prefixes? for variables and objects (e.g. tbl = table, qry =query, rpt = report, str = string variable, int = integer variable, etc.). Code modules, subroutines, and functions must be named appropriately so that it is obvious what they do at a high level. Avoid "hard coding" and constants in the VBA code.? Instead, set constants in the header (public if necessary) and then set the variables equal to the constants in cod...

...However, the script only executes when a previous document is already in existence in the system. I need the script fixed so that it executes even when there isn't a previous document already uploaded. This script uses PDO, here is a very brief snippet (I've attached the full file for review) ===================== $qry = "CALL addAttachment(:resume_doc, :resume_filetype, :resume_filename, :id)"; $conn->open(); $stmt = $conn->prepare($qry); $conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION); $stmt->bindParam(':resume_doc', $resume_doc); ==================== PLEASE do not bid if you are unfamiliar with PDO. I also have additional scripts that need repair, should you fix this script in a ti...

I need a basic crawler / scraper to be used on a Facebook search to retrieve the names, and their relevant details from that particular page. Ex. I want the first 10 profiles listed here to be taken using php. I am not planning to store the details in a database, and only requires to gather details on the fly. ## Deliverables I only require the simple php code by someone who has experience on the subject.