Hello.

I created a select field with CCK. I need to "store" around 1500 values in that select field. I tried to copy all the entries directly into the value field. When saving this amount of entries apache and drupal crashes with the following error: "MySQL Server has gone away".

So somebody told me to use a php code to read this amount of entries out of a sql table.

I tried to find a php code that would work to fetch the data out of a sql table but couldn't get the code to work.

Does anybody has an example code I could use or modify on my behaviour?

Thanks in advance.

Regards
Florian

Comments

wflorian’s picture

wflorian commented

No idea anybody?

I would really appreciate your help.

nextdude’s picture

nextdude commented

Here's an idea: use an autocomplete field.

wflorian’s picture

wflorian commented

Good idea! Unfortunately I need a textfield. But there is no autocomplete option for textfield, so I probably would a third party module. The only one I could find was http://drupal.org/project/textfield_autocomplete. Did you mean this module?

andreiashu’s picture

andreiashu commented

Hey florian,
I know that your issue if for D5 but maybe it will help if you look into the cck_autocomplete module.

nextdude’s picture

nextdude commented

I wasn't thinking of a particular one. There are lots of options. There are several jquery modules...one is http://plugins.jquery.com/project/jq-autocomplete.

karens’s picture

karens commented
Status: Active » Closed (won't fix)

Closing old issues. None of us is using the D5 version any more, so hard to provide any support. Sorry.