[ic] Re: MySQL complex search specs in cat table problem

Richard Eddy interchange-users@icdevgroup.org
Sun Aug 25 18:30:02 2002


>>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.
>
>From: "D Zhang - msi" <dzhang@mtspring.com>
>To: <interchange-users@icdevgroup.org>
>Subject: Re: [ic] MySQL complex search specs in cat table problem
>Date: Sat, 24 Aug 2002 11:29:17 -0400
>Reply-To: interchange-users@icdevgroup.org
>
>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

I would appreciate that please David. Thank you.

Richard Eddy.