Radicore Forum: How To » Search when some columns are dropdown lists

Home » RADICORE » How To » Search when some columns are dropdown lists

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Search when some columns are dropdown lists [message #538 is a reply to message #537]

Thu, 11 January 2007 14:40

AJM
Messages: 2389
Registered: April 2006
Location: Surrey, UK

Senior Member

I do not understand point #1 - surely you mean to rename the foreign key from 'fklocation_id' to 'location_id' (i.e remove the 'fk' prefix) so that it matches the name of the lookup array. There is no point in ADDING that prefix as it serves no useful purpose.

If you do not wish to rename that field on the database all you have to do is rename the lookup array from 'location_id' to 'fklocation_id'. This just means changing one line of code so would be much easier than changing the database.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Search when some columns are dropdown lists By: David Lee on Mon, 01 January 2007 05:00
		Re: Search when some columns are dropdown lists By: AJM on Mon, 01 January 2007 05:48
		Re: Search when some columns are dropdown lists By: David Lee on Wed, 10 January 2007 12:03
		Re: Search when some columns are dropdown lists By: AJM on Wed, 10 January 2007 12:28
		Re: Search when some columns are dropdown lists By: David Lee on Wed, 10 January 2007 15:32
		Re: Search when some columns are dropdown lists By: AJM on Wed, 10 January 2007 16:10
		Re: Search when some columns are dropdown lists By: David Lee on Wed, 10 January 2007 17:01
		Re: Search when some columns are dropdown lists By: AJM on Wed, 10 January 2007 18:13
		Re: Search when some columns are dropdown lists By: David Lee on Thu, 11 January 2007 14:06
		Re: Search when some columns are dropdown lists By: AJM on Thu, 11 January 2007 14:40
		Re: Search when some columns are dropdown lists By: David Lee on Fri, 12 January 2007 18:17
		Re: Search when some columns are dropdown lists By: AJM on Sat, 13 January 2007 05:13

Previous Topic:	List with pre-defined search active
Next Topic:	flexible approach

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon May 11 01:24:52 EDT 2026

Total time taken to generate the page: 0.01601 seconds