Gossamer Forum
Home : Products : DBMan : Discussions :

Re: Last try: Select field also pulls related data

Quote Reply
Re: Last try: Select field also pulls related data In reply to
Thank you, Lois, I have now the feeling that finally somebody (exactly) understands what I mean.

I too have thought of the possibility that it may slow down the database, but then: All the &build_select_field_from_db calls slow down the script a bit.

What I had in mind isn't an ordinary, often to use routine. With that I mean that a database search as the one I want, would not slow down more than any other build_select_field_from_db-search. The field to be searched for is given, it's the field called School, called by &build_select_field_from_db("School", "$rec{'School'}"); - a quite slowing-down routine but still a standard routine in DBMan.

The next search (which is the "Copy!"-search according to my description, must be even quicker than the build_select_field_from_db search, because one field is given (example: St Peter School), so the script would have only to look for St Peter School in the School-column and return two more values from the same record, the City and the Country!

Lois, you wrote: "Hope this helps a little". Yes, thank you, Lois, I am grateful, but like you say: Just a little.

Now, if you know the programmer that writes that special code for me, please let her/him contact me for that challenge. I am of course willing to pay for that service if it isn't challenge enough to provide this for free by somebody who reads this.

/CSky


Subject Author Views Date
Thread Last try: Select field also pulls related data csky 3414 Feb 9, 2001, 2:23 PM
Thread Re: Last try: Select field also pulls related data
Karen 3331 Feb 9, 2001, 6:09 PM
Thread Re: Last try: Select field also pulls related data
csky 3347 Feb 9, 2001, 10:19 PM
Thread Re: Last try: Select field also pulls related data
Karen 3342 Feb 10, 2001, 1:16 AM
Thread Re: Last try: Select field also pulls related data
csky 3318 Feb 10, 2001, 10:28 AM
Thread Re: Last try: Select field also pulls related data
LoisC 3303 Feb 10, 2001, 11:04 AM
Post Re: Last try: Select field also pulls related data
csky 3311 Feb 10, 2001, 1:23 PM