Gossamer Forum: Products: Gossamer Links: Discussions: adding new fields in 3.X

Jul 28, 2005, 12:22 AM

jasy007

User (97 posts)

Jul 28, 2005, 12:22 AM

Post #1 of 5

Shortcut

adding new fields in 3.X

Hi, need help in adding new fields in 3.X like

Job 1
Field:-
A (title)
B (desc)
C (link)
D (yes/no)
E (yes/no)
F (desc2)

Job 2
then modifying add page to display these fields for input

Job3
Multiple search fields for end user like...
Field
A
B
D No
E Yes
similar to admin link search page where is says matches different fields...

Any one has or knows existing step by step guide please let me know.

Thanks!

Jul 28, 2005, 9:24 AM

jasy007

User (97 posts)

Jul 28, 2005, 9:24 AM

Post #2 of 5

Shortcut

Re: [jasy007] adding new fields in 3.X In reply to

btw, anyone able to add numeric value field
example $ value

and in search have extra field option for...
$ value like pull down menu

less than 1
1
2
3
4
5
6
7
8
9
10
above 10

end user select the value range in pull down memu like 5, than gets results with only $5 value.
I found out adding fields in database is easy, but implimenting in LinkSQL seems hard, as I couldn't find much help in searching forums & manuals.

Jul 28, 2005, 9:36 AM

Andy

Veteran / Moderator (18441 posts)

Jul 28, 2005, 9:36 AM

Post #3 of 5

Shortcut

Re: [jasy007] adding new fields in 3.X In reply to

search.cgi?query=xxxx;Price-gt=5;Price-lt=10

..would give results matching;

"Price" greater than 5
"Price" less than 10.

-gt = Greater Than
-lt = Less Than

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jul 28, 2005, 1:08 PM

jasy007

User (97 posts)

Jul 28, 2005, 1:08 PM

Post #4 of 5

Shortcut

Re: [Andy] adding new fields in 3.X In reply to

thanks Andy Unsure

... not much geek so couldn't grab it.

you mean Price-gt & Price-lt is a database fields.

the last Q was part of my main Question... which is how/where to modify to add extra fields other than mySQL... which seems easy... but implementing that in LinkSQL seems hard... unless someone have written guide to do it.

I was not able to find myself anything after searching all over the forums... if you or anyone aware of any such thread that works on 3.X version please let me know. Otherwise I will have to wait for someone kind enough to post a small steps in doing that here.

Thanks!

Aug 4, 2005, 1:30 AM

Andy

Veteran / Moderator (18441 posts)

Aug 4, 2005, 1:30 AM

Post #5 of 5

Shortcut

Re: [jasy007] adding new fields in 3.X In reply to

Hi,

Sorry, what I meant, was;

If you have a field called Price which is an INT field (number), then you can search then with "less than" and "greater than" in search.cgi, with;

Price-gt=1234 - searches Price greater than 1234
Price-lt=1234 - searches Price less than 1234

NB this won't work on CHAR or TEXT fields, as they arn't numerical, and thus a >= or <= syntax can't be used.

Hope that helps.

Andy (mod)
andy@ultranerds.co.uk