i am having difficulty adding multiselect fields to mySQL database. i have two..12 items and 32 items resprctively. The validation screen shows them as a single line window with a 'line' (no choice)...when dropped down all the items are there but none selected

The help says the following:

Form Size: This is only useful for select, text or textarea form types. For selects, set this to 0 to be a single select field, set it to a postive number to be a multi select field. For Text fields, set this to the size of the text box, for textarea types, set this to rows,cols to specify the size.

I tried using '1' and i also tried '12' and '32' respectively.

I made this mistake not so long ago. Are you sure you are using the 'multiselect' option, and not just 'select'. Its an easy mistake to make, but obviously the multiselect lets you actually choose more than one

Hope that helps

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

nope...ain't that :(. Should i be putting 'if' statements in the include_form for the multiselect list?

I haven't ever used a multiselect with the include form so I'm not sure what the problem may be but I don't think you should need if statements. Can you paste the html you're using in the include form for this field - just in case it is a simple mistake that you've overlooked?

Also, what happens when you edit these links in admin - can you select multiple options in that field and is it saved properly?

Laura.
The UK High Street

ahh..good idea...let me try that

nope..that didn't work

here is the HTML and the database settings

<select name="software_basic" size="5" multiple>
<option>Powerpoint</option>
<option>Photoshop</option>
<option>Illustrator</option>
<option>CorelDraw</option>
<option>Pagemaker</option>
<option>QuarkXPress</option>
<option>InDesign</option>
<option>Debabelizer</option>
<option>ImageReady</option>
<option>Fireworks</option>
<option>GoLive</option>
<option>SoundForge</option>
<option>ProTools</option>
<option>Dreamweaver</option>
</select>

(its actually 32 items long..i clipped some for this post)

Database info is:

column type ..ENUM
Column Values (listed all the items carefully on a line each)
Form Type:..MULTISELECT
Form size :..32
Form names (same as column values)
Form values (same as column values)

when i go to validate..nothing is selected..:(

I think that you need some 'value's in your html. For example something like

<select name="software_basic" size="5" multiple>
<option value="Powerpoint">Powerpoint</option>
<option value="Photoshop">Photoshop</option>

make sure that the names in "" match exactly those in the database.

Hope that fixes it.

Laura.
The UK High Street

Hi. If you want, PM me your LSQL admin details, and I'll have a look for you. Its probably something simple that you are missing because you have been working on it for quite a while.. that happens to me all the time

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

I think the problem is that your column type is ENUM.

Try changing the type to char or text
Richard White
http://www.AffiliateFirst.com

It looks like its all working to me

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

I took RWhite's suggestion and changed fields from ENUM to TEXT. Now I am able to multi select in link modify mode in the admin (as suggested by Laura). This works well just as i wished it would.

The problem i am having is in the validation stage. there is only one item shown (although usr selected multi). Where are the parameters that define how the validation page appears?

Thanx everyone for your help in this

Oh yes..i also inserted values in my multiselect html form..but that made no difference

IT DOESN'T WORK!!!

Cliaent screaming///'you said it would work!!!...its not working!!!!



Can't make it work (looking for gun to kill myselfr)

Wish I could help!

I've done a quick search on the forum and found that this was a known bug in 2001:

http://www.gossamer-threads.com/...i?post=145412#145412

Which version of Links do you have - it may be fixed in a newer version?

I'll see what else I can find - maybe someone found a fix.

YESS!!

That's exactly the problem!!! Obviously it hasn't been fixed..i'm using the latest version 2.1.1 which we just bought this spring

I did a sesarch as well but missed that...damn..of course i hadn't isolated the exact problem which is the validation page.

I hope there is a fix..i've forged ahead by disabling validation which is really not a satisfactory solution but i have to show some progress..been stalled for days

Thank you Laura and Andy and all...your help is very much appreciated

Re post at: http://www.gossamer-threads.com/...i?post=226336#226336

Any fix for this GT?

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!