Tom, Thanks for that - interestingly in all the time I've used SQL I've never come across this Dynamic SQL 'N' before, so now I know a little bit more about SQL. In the meantime, the error I'm getting is, as you say, not connected with the 'N'. It is in fact with the way the Dynamic SQL statement is being constructed. The odd thing is if I run this on my office PC (configuration a below) it constructs the query correctly. If I run this at home (configuation b below) it constructs the query incorrectly. Configuration a NT4 Apache SQL/2000 Configuration b XP Internal Server SQL/2000 The problem field is the bMatchAllKeywords which in '0' in configuration a (i.e. correct) and 'On' in configuration b (i.e. incorrect). I'm just posting this message in case anyone says 'yeah i know what it is.......', in the meantime I'll continue to dissect the code (which is a useful exercise in itself) N>
-----Original Message-----
From: [EMAIL PROTECTED] on behalf of Tom Cornilliac
Sent: Wed 08/10/2003 22:54
To: FarCry Developers
Cc:
Subject: [farcry-dev] RE: A question regarding categorisation - partially
resolved
Nick,
The N is supposed to be there. That's not your "run of the mill" SQL query.
setData is using Dynamic SQL to include the datatype along with the value.
~Tom
-----Original Message-----
From: Nick Lansbury [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 12:00 PM
To: FarCry Developers
Subject: [farcry-dev] RE: A question regarding categorisation -
partially resolved
setdata.cfm lines 109 and 141 both have a rogue 'N'
109 - <cfset thisvalue = "N'#propertyvalue[j]#'">
141 - <cfset sql = sql & "#propertyName# = N'#propertyValue#'">
having removed these chars the sql fails trying to write 'On' to an
integer field
N.
----- Original Message -----
From: Nick Lansbury <mailto:[EMAIL PROTECTED]>
To: FarCry Developers <mailto:[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 7:48 PM
Subject: [farcry-dev] RE: A question regarding categorisation
hmm...now that i'm back in front of my farcry pc i see that my
initial problem appears to be that i created a custom rule that extends rulenews.cfc
and in fact when i replace my custom rule with rulenews.cfc it does indeed work
correctly as far as filtering goes (though it still gives me the sql error as
described earlier when matching all content)
anyways, my custom rule is a clone of rulenews.cfc except for
line 1 which is as follows:
<cfcomponent displayname="Nicks Custom News Rule"
extends="farcry.farcry_core.packages.rules.rules" hint="" bCustomRule=1>
my intention was to clone an existing, working rule then make
changes in order to end up with my own rules.
N.
----- Original Message -----
From: Nick Lansbury <mailto:[EMAIL PROTECTED]>
To: FarCry Developers <mailto:[EMAIL PROTECTED]>
Sent: Wednesday, October 08, 2003 7:28 PM
Subject: [farcry-dev] RE: A question regarding
categorisation
sql/2000
N.
----- Original Message -----
From: Tom Cornilliac <mailto:[EMAIL
PROTECTED]>
To: FarCry Developers <mailto:[EMAIL
PROTECTED]>
Sent: Wednesday, October 08, 2003 7:22 PM
Subject: [farcry-dev] RE: A question regarding
categorisation
Nick,
What Db are you using?
~Tom
-----Original Message-----
From: Nick Lansbury [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 11:01 AM
To: FarCry Developers
Subject: [farcry-dev] RE: A question regarding
categorisation
Tom,
I've double-checked any my dmNews items are
definitely categorised as I want them. Interestingly, when I attempt to restrict by
category in the rule my attempt is ignored and all news items are returned
irrespective of their category. When I then check the Does the content need to match
ALL the selected Keywords? box and press 'Go' I get this error message:
UPDATE dbo.ruleNews SET metadata =
N'186BEAEB-B182-6C9C-F0F0828463ED96F4', numPages = N'1', numItems = N'5',
displayMethod = N'displayTeaserBullets', intro = N'', bArchive = N'0',
bMatchAllKeywords = N'on', label = N'' WHERE objectID =
'18641D7A-CB20-7F80-BE06F97E7D189353'
Note all those rogue 'N' chars in there. I'll
continue to investigate. BTW the template throwing the error is
C:\CFusionMX\wwwroot\applications\fourq\_fourq\setData.cfm:
N.
----- Original Message -----
From: Tom Cornilliac <mailto:[EMAIL
PROTECTED]>
To: FarCry Developers <mailto:[EMAIL
PROTECTED]>
Sent: Wednesday, October 08, 2003 5:35 PM
Subject: [farcry-dev] RE: A question regarding
categorisation
You may want to double check the categories on
your dmNews objects. I often forget to click the "Apply categories" button.
~Tom
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL
PROTECTED]
Sent: Wednesday, October 08, 2003 8:05 AM
To: FarCry Developers
Subject: RE: [farcry-dev] RE: A question
regarding categorisation
Hi Tom,
Thanks for that but I'm pretty certain that's
what I tried. (actually I tried this last night and I'm finally writing these notes
today so I'm not in front of the machine that has FarCry on it).
I'll retry tonight. From memory I did what you
suggested and it didn't work so I then selected the 'Does the content need to match
ALL the selected Keywords?' option in the News rule but that gave me an error message.
N.
---
You are currently subscribed to farcry-dev as:
[EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL
PROTECTED]
---
You are currently subscribed to farcry-dev as:
[EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL
PROTECTED]
---
You are currently subscribed to farcry-dev as:
[EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL
PROTECTED]
---
You are currently subscribed to farcry-dev as: [EMAIL
PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---
You are currently subscribed to farcry-dev as: [EMAIL
PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
<<winmail.dat>>
--- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
