[ic] MySQL complex search specs in cat table problem

[D Zhang - msi]

There seems to be a discussion recently on the topic. And it was suggested
that a perl script should do a better job. If you like to work this way, I
can post a script that works for me.

David Zhang
msihosting.com


----- Original Message -----
From: "Richard Eddy" <reddy@iinet.net.au>
To: <interchange-users@icdevgroup.org>
Sent: Friday, August 23, 2002 10:45 PM
Subject: [ic] MySQL complex search specs in cat table problem


> InterChange with a MySQL database does not seem to like complex search
field
> entries in the CAT table entered like:
>
> mp=0/sf=comment/tf=title/su=yes/sp=eloqresults/se=Eloquence
>
> which it outputs in the browser address line as:
>
> mp=0::sf=comment::tf=title::su=yes::sp=eloqresults::se=Eloquence
>
> Instead, it seems to need complex search field entries to be broken out
into
> separate lines such as:
>
> mp=0
> sf=comment
> tf=title
> su=yes
> sp=eloqresults
> se=Eloquence
>
> which it translates in the browser command line to:
>
> mp=0/sf=comment/tf=title/su=yes/sp=eloqresults/se=Eloquence
>
> and then works just fine.
>
> However, when I use Administration / Tables / Import in the Admin
> environment to upload a replacement CAT table in which complex search
field
> entries have been broken out as above, only the first line -- mp=0 -- is
> placed in the MySQL cat table field.
>
> If I am doing something wrong, will someone please correct me, or provide
a
> work-around which would still enable me to use the Tables / Import
facility
> in the Admin interface to import replacement cat.txt files in which
complex
> search specs will be handled correctly.
>
> I am managing meanwhile by exiting the table at the MySQL level, which is
> not a desirable long-term solution.
>
> Thank you.
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
>