Help with ACF to Lucee conversion

[Julian Halliwell]

Is anyone interested in helping a Wisconsin (USA) based company
convert an ACF system to Lucee?

Please contact me off-list for more details.

Julian
http://cfsimplicity.com/

[Nando Breiter]

Hi Julian,

I'm interested. Could you tell me a little more about the ACF to Lucee conversion project?

Thanks,

Nando

Aria Media Sagl
Via Rompada 40
6987 Caslano
Switzerland

+41 (0)91 600 9601
+41 (0)76 303 4477 cell
skype: ariamedia

--
See Lucee at CFCamp Oct 22 & 23 2015 @ Munich Airport, Germany - Get your ticket NOW - http://www.cfcamp.org/
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAC_5Voo74Pw71P5oZ6OAAxA-HXdaWJ-wVXzTZW1N2R2obzWymg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[Julian Halliwell]

Hi Nando, I sent you a private email yesterday. Did you get it?

Julian.

[Nando Breiter]

Hi Julian,

Yes, I got it. Answering now ...

Nando

Aria Media Sagl
Via Rompada 40
6987 Caslano
Switzerland

+41 (0)91 600 9601
+41 (0)76 303 4477 cell
skype: ariamedia

--
See Lucee at CFCamp Oct 22 & 23 2015 @ Munich Airport, Germany - Get your ticket NOW - http://www.cfcamp.org/
---
You received this message because you are subscribed to the Google Groups "Lucee" group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/CAC_5VopbZJxBDwM0Ls9%2BXZc%3Dknnfez678Nb2UkAk%2B83q90JADw%40mail.gmail.com.

[Nils Bettinger]

Hi,

I've got a table with a field within which contains a comma-separated
tag-list (the project is a picture-galery). I want the User to search for
some pictures.

For example:

Database: picproject
table: pictures
field: tags
Value: tor,eingang,licht,lichtung

Another entry:

Database: picproject
table: pictures
field: tags
Value: monitor,bildschirm,anzeige,display

---

So if I do it very simple, I search for something like that:

SELECT * FROM `pictures` WHERE tags LIKE <cfqueryparam
value="#FSearchquery#" cfsqltype="CF_SQL_VARCHAR" maxlength="200">

---

If I search for "tor" I would get both entries mentioned above (tor /
monitor). How can I optimize the searching in general? Has someone a
resource/howto on the web where I can take a look to learn a bit? Thze next
step would be to search for more words and/or etc.

I would be pleased by any sugestions to make the search-function a bit more
sharpened and comfortable.

Best regards,

Nils

[thorste...@googlemail.com]

Hi Nils,

to store comma seperated strings in a field is an antipattern.

I suggest to create another table "tags" and relate it to your pictures table.

Makes life way easier in the long run. ;-)
https://pragprog.com/book/bksqla/sql-antipatterns