CFTREE appends question mark to URL

[Pinac]

Hi all,

I've made a flash tree with CFTREE, but with AppendKey "yes/no" it appends a
extra question mark at then end of the URL. Resulting in a error on the loaded
page.

You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '? ) as tax FROM
tbl_products as T1 WHERE groupid = 18? ORDER BY ' at line 35

Examples:

AppendKey = "no" / My own url parameters
URL is http://<some_ip>/aws/products.cfm?group=18?

AppendKey = "no" / No own url paremeters
URL is http://<some_ip>/aws/products.cfm?

AppendKey = "yes" / No own url paremeters
URL is http://<some_ip>/aws/products.cfm?CFTREEITEMKEY=Some Text?

AppendKey = "yes" / My own url parameters
URL is http://<some_ip>/aws/products.cfm?group=18?CFTREEITEMKEY=Some Text?

Hope this is enough information.

Thanks in advance

[Mike Nimer]

This is a known issue. For now you will need to parse out the extra ? on the
form action page.

thanks,
--nimer

"Pinac" <webforumsuser@macromedia.com> wrote in message
news:cuu403$o5c$1@forums.macromedia.com...

> Hi all,
>
> I've made a flash tree with CFTREE, but with AppendKey "yes/no" it
> appends a
> extra question mark at then end of the URL. Resulting in a error on the
> loaded
> page.
>
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near '? ) as tax
> FROM
> tbl_products as T1 WHERE groupid = 18? ORDER BY ' at line 35
>
> Examples:
>
> AppendKey = "no" / My own url parameters
> URL is http://<some_ip>/aws/products.cfm?group=18?
>
> AppendKey = "no" / No own url paremeters
> URL is http://<some_ip>/aws/products.cfm?
>
> AppendKey = "yes" / No own url paremeters
> URL is http://<some_ip>/aws/products.cfm?CFTREEITEMKEY=Some Text?
>
> AppendKey = "yes" / My own url parameters
> URL is http://<some_ip>/aws/products.cfm?group=18?CFTREEITEMKEY=Some Text?
>
> Hope this is enough information.
>
> Thanks in advance
>