This content has been marked as final. Show 5 replies
You should use URLEncodedFormat() to properly encode the variables in the link
> WHERE song_sng.id_sng=#id_sng.id_sng#
The error seems to occur on this line. If #id_sng.id_sng# is a string, you should use single quotes around the value or use cfqueryparam
WHERE song_sng.id_sng= '#id_sng.id_sng#'
when i use URLEncodedFormat() to encode the variables in the link, i get an error message on the page...
and when i use single quotes around the value, the page shows, but theres no info on the page...
if you click on any song under record "funeral"...with # in the title, you will see that no info appears on the page..
> i get an error message on the page...
What is the error message? It works fine with a title like "Neighborhood #1 (tunnels)".
> the page shows, but theres no info on the page...
That's probably because you're not using URLEncodedFormat. Parameter values (with # signs, spaces, etc) may not be pass correctly if they aren't properly encoded.
In any case a better method is to pass the song id, not the title. For example, if your table contains two columns:
SongID , SongTitle
22, Neighborhood #1 (tunnels)
You should pass the ID (22) as url parameter.
ok...just on my way out, thanks for this, will have a go and get back to you...
worked like an absolute charm...