• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

need some help with coding....

daraptor

OSNN Junior Addict
#1
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
#2
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?
Staff member
Political User
#3
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.
 
#4
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 posts

Latest profile posts

Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,961
Messages
673,239
Members
89,016
Latest member
ernestrojasn