ThisTag.GeneratedContent Mutilated

[webmigit]

Here's one I can't figure out.. I'm writing a custom tag to replicate cfquery.. in short this is only because I can then switch from datasource to connection string in seconds instead of much longer.

First try gave me this failure: It used double quotes wherever I had single quotes.. So to remedy that: PreserveSingleQuotes.. Now it's doing a new thing..

SELECT * FROM RemoteNews
WHERE InChannel=#Channel#
ORDER BY NewsDate DESC

is apparently the only query on the whole site that it trips on.. InChannel is a lookup field treated as a number field.. The database is not hurt.. this code should work but I get an odd error:

[Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression 'InChannel=#Channel#'.

This is not a date field.. I've tried everything I can think of to get it to run.. and nothing works.. is there another way to handle number fields?

Thanks,
Tony Hicks [ Founder of <A href=&quot;

http://www.bibleclicks.com&quot;>Bibleclicks.com</A>,

online bible. ]

 

[webmigit]

PS: Is there another wait the code could be being mutilated that I don't see somehow? [ Founder of <A href=&quot;

http://www.bibleclicks.com&quot;>Bibleclicks.com</A>,

online bible. ]

 

[CFDude]

If your error actually has &quot;#Channel#&quot;, then it looks like your variable is not getting parsed. Maybe you need to put a cfoutput tag around it so that it sends the actual value of the Channel variable?