473,800 Members | 2,418 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Search for a field with the same informations

In my table I have a field called "lat" and "lng" which have the coordinates
for showing the markers on my map
http://www.tinemuller.dk/alle_folkeb...downmenu/PVII/. The
problem is that some markers are on the same coordinates so I have to figure
out the query to make in Navicat showing this places so I can make a
printscreen to show in the Google Maps forum for further help. Maybe I only
need to search for "lat"?

Can someone help me with this query?

--
M.v.h.
Tine Müller

homepage: http://tine_muller.homepage.dk/
Jan 2 '08 #1
1 1115
On Wed, 02 Jan 2008 15:32:58 +0100, Tine Müller <ti***@email.dk wrote:
In my table I have a field called "lat" and "lng" which have the
coordinates
for showing the markers on my map
http://www.tinemuller.dk/alle_folkeb...downmenu/PVII/. The
problem is that some markers are on the same coordinates so I have to
figure
out the query to make in Navicat showing this places so I can make a
printscreen to show in the Google Maps forum for further help. Maybe I
only
need to search for "lat"?
I'd certainly think you'll have to match them both offcourse.
Can someone help me with this query?
An SQL group/a group of your specific database flavor seems more
appropriate (if mysql =comp.databases .mysql).
--
Rik Wasmus
Jan 2 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2530
by: Thierry B. | last post by:
Hi, this question is 50% mssql and 50% php. To get field definitions and other informations for table 'myTable', I use with sql server: EXEC sp_help myTable The problem with php is this command returns several result sets, and informations about field types is not in the first one. If I query mssql from php and fetch result, I only get informations about the first one, and
2
2111
by: Gellert, Andre | last post by:
Hello, we upgraded our PostgreSQL from 7.2 to 7.4, because we want to use the enhanced full-text searches, which should be build in now. I can't find any informations how to implement an optimized search in the docs .... Today the search feels like " fieldvarchar30 ~* '^VALUESTRING.*' " , is the full text search based on special indizes, a special table type or whatever ?
8
6387
by: Kona | last post by:
Hello, I would like to access a UDB database on a Sun Solaris 5.8. The client is a XP station. When I list the default odbc drivers, I found "Microsoft ODBC Driver for DB2". But I think it can not be used to access a UDB DB on Unix machine. So where can I find a ODBC driver ? Thank you
3
3036
by: AW | last post by:
Hi all, I have a form (named Offices) with a subform (named Occupants) that connect with the Master/Child Field "office number". I have a combo box that allows a user to pull up a particular office and see the listing of its occupants, no problem. Next, I tried to create a combo box that would allow users to search for a particular occupant within the subform regardless of which office was selected. However, nothing happens. At least...
8
3225
by: Steph | last post by:
Hi. I'm very new to MS Access and have been presented with an Access database of contacts by my employer. I am trying to redesign the main form of the database so that a button entitled 'search' may be clicked on by the user and the user can then search all records by postcode. I want to do this to prevent duplicate data entry.
7
1720
by: John | last post by:
hi, i have created a search form, and i want to search for a specific item in a field. e.g. i have a field called colour, which has record1 = 'red, blue, green' and another record2 = 'red' now, when i do the search, and only type in red, to search for red, it only brings back record 2, and not record 1 as well.
3
2216
by: Sheau Wei | last post by:
This is the search engine code that i create, but it was error and didnt come out the result. Cn u help me to check what wrong with my code? Thanks <Table cellspacing=1 cellPadding=1 align=center> <td colspan=4> <h2 align=center>Bomba inventory searching system</h2> <tr> <td> <h4 Balai Bomba Inventory Searching System</H4> <form name="search" method="post" action="<?=$PHP_SELF?>">
1
2306
by: Nour469 | last post by:
Hello, I have a problem when I run search, I have fields for: name, clientID and phoneNo. When a client calls I need to find them in the database, they might give me the name and it might not be spelled correctly, I need to search by phoneNo. (the fastest way!) I place the cursor in the appropriate field and click search. when the find window opens up, by default, the Look in: field is: 'Main application form: form' and the 'search field...
22
21521
by: GoodGirl | last post by:
Hi : I would like to ask about : how can I write the (simplist) code for search button. I'm bignner in using Access 2007 & VBA . This button will search by name in a query which contains all employees informations then if the name is valid, message box will show and disply all the related informations for the employee.
0
9690
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9551
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10275
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10253
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10033
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9085
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5471
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4149
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2945
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.