ZDM
|
| Posted: 03/04/2002, 3:58 PM |
|
i want do search in several tables in database, but CC take me choice to select only one table...how i can do search in several tables with CC...help me pls...how i can do it...
and more - how i can get result from fields in table from memo in resume(example - primary 200 simbols and rejecting following)
pls pls pls
|
|
|
 |
Ken Hardwick
|
| Posted: 03/04/2002, 4:40 PM |
|
ZDM,
You didn't mention the database you are using, but if it supports joins,
...read on..
One method you might check out is useing database joins.
Like
Select Field1 from Table1
Join
Select Field1 from Table2
Join
Select Field1 from Table3
End results is a single "join" table
with Field1 from all three tables as field1 in the Join table.
Which then, of course, you could do a single search on the one field.
Of course, there is addition fields/information you would have to bring into
you join to make use of your results.
To better understand JOINS do some web searching..
Hope this helps a little.
|
|
|
|
ZDM
|
| Posted: 03/04/2002, 7:46 PM |
|
with other words - if i use access database, i must do one table with connections with fields from another tables...and i use this table for search ?...sorry for confusion but i am beginner and i am not sure that i understand you correctly....
i already have access database with 7 tables and i builded one project with CC , i can use this database or not ?
and i not understand - this , that you wrote me must be make with database in access or make in CC....
i will try make it today, but i am not sure that i understand all which i make with CC (its too visual - he he, thanks to yessoft )....
i do great asp with CC, but not understand "engine" work ;O(
and now i have lots of sources downloaded from sites for asp developing, but this examples wrote with hands - not with CC...
and i am very confused...
whatever - i can build very good search with CC (visual) or not ?
i look that i can select only one table from database in CC.... :O(
and i not understand - how i can select more tables with CC ?
if this possible of course...
thanks for reply Mr Ken Hardwick
|
|
|
|
Sam M
|
| Posted: 03/04/2002, 7:48 PM |
|
When I was first experimenting with joins, I found the best examples on the news groups. A good place to look is http://groups.google.com
They have a 20 year archive with an answer to every concievable problem.
I find the best results by doing a search for ASP joins, or inner joins ASP.
Good luck.
|
|
|
|
|
