Hi Glen,
I'm sorry if I wasn't clear enough. I have tried what you
suggested but what I forgot to mention is that I am querying from
multiple tables bu using INNER JOIN. These tables have their own
unique IDs. I have a main table, TableContactList, with the primary
key contactID. The other tables are related to the main table and
they contain names from the TableContactList, where contactID =
Table2ID, Table3ID, Table4ID. So if I use contactID=#contactID#,
how will the query know to get/display the record where contactID =
Table2ID = Table3ID = Table4ID.
If I use the URL syntax, the same error comes up where
contactID is undefined. I also tried this:
mypage.cfm?ContactList.contactID=#URL.ContactList.contactID#
In addition, my main table, ContactList, should I put the
hyperlink from there and just put a login restriction on that query
page before displaying this: mypage.cfm?contactID=#contactID# I did
this as well, but still didn't get to display the specific record I
want.
Any other suggestions, please let me know.
Thanks,
Karla