need some help with coding....

daraptor

OSNN Junior Addict
Joined
26 Jul 2005
Messages
12
hey guyz,
am tryin to build a site...am having some problems.....what am tryin to do is..am tryin to build a travel search site....i have got this airport codes in a access file....and the table names are....code,airport name,state,country.....
what is the exact SQL query to call a airport code by searching the code so that all name,state and country appear.....and also after i get the results ....how do i populate the parent window using the child window.....i hope someone will help me with this....plz guyz.....thanx for the help......
 

Mainframeguy

Debiant by way of Ubuntu
Joined
29 Aug 2002
Messages
3,763
you need to be specific on columns and if this is an access file I would seriously consider switching to SQL server... basically you need to join your tables on the code, probably in a view - then you can use SQL like

select name, state, country from airports_view where code = yourvalue

As for the parent and child windows - you'll need someone else to help you there...
 

fitz

Woah.. I'm still here?
Political Access
Joined
26 Apr 2004
Messages
4,084
If I may also suggest using something besides Access as your backed database.

mySQL on the cheap end or any number of other commercial products besides Access.
 

Geffy

OSNN Veteran Addict
Joined
18 Mar 2002
Messages
7,805
Depends what he's working with, if he's using ASP or ASP.NET then Access is typically the better choice. An alternative is MSSQL Express which I believe is free. This gives you a proper if cut down SQL server to interface with.
 

Members online

No members online now.

Latest profile posts

Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.
Terrahertz wrote on Electronic Punk's profile.
Yo fellas!
Electronic Punk wrote on Sazar's profile.
Where are you buddy?
Perris Calderon wrote on Electronic Punk's profile.
Hey EP! All good with me, applying for Microsoft MVP right now, should have done this a while ago.

Notifications don't work, I only found your response by coming back to hunt up some threads, if you want, give me your email address so we can keep in touch easier!
Perris Calderon wrote on Electronic Punk's profile.
EP, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS

Been running around Quora lately, luv it there!

Forum statistics

Threads
61,997
Messages
673,411
Members
5,591
Latest member
nodee