Re: MySQL Query Optimization ... > query can take 15 seconds or more for broader searches. ... What you really need is a precomputed table of distances between zip codes.... any location in one block is within distance of any location in the other). ... The distance table would consist of pairs of three-digit zones that meet ... (comp.lang.php)
Re: Command Button to modify a table ...Dim strSql As String ... You can mock up a query based on this Counter table, turn it into an Append query, and switch to SQL View to get an example of the query string you need to create. ... this number would be used to create 43 unique codes.... (microsoft.public.access.forms)
Nested Looping SQL Querys ...SQL Querys are stored in the .py files and run in the .cgi files. ... the first query results are delimited with and the second with I ... def creationSQL(pubID, productCode, description, suppNo1, all): ... # Return list of checked product codes.... (comp.lang.python)
Re: update query for multiple changes to a single field ... same query and just modify the query for each change. ...criteria for call_type and reset Update TO for the next change. ...Applications... i want to do a single pass update that will change the codes to: ... (microsoft.public.access.queries)
RE: Build A User Defined STR Statement Using Access 2000 ... few codes to check, I will use the text field method. ... I have taken an extract from a query which I currently use to find specific ... I would like a variable to buld up a resulting STR... I then want the database to automatically build a query with the STR ... (microsoft.public.access.modulesdaovba)
