Viewing 14 posts - 1 through 14 (of 14 total)
Yes I have been wondering on the best field type to store the actual data - I see some versions of the Entity Attribute Value approach use different tables...
January 2, 2007 at 4:20 pm
Hi Carl,
The Entity Attribute Value approach is what I want - interesting to see the number of articles totally slating it and then others raving about it!
Now to plough through...
January 2, 2007 at 11:20 am
OK, thanks for the re-assurance, however my remaining concern is over the best way to store the actual data.
Do I have a column for each field type in the CustomFieldData...
January 2, 2007 at 9:32 am
Hi,
OK, you have me totally lost on the first bit.
I use the path because an Object can have multiple parents so the path enables me to identify where they are...
May 26, 2006 at 10:17 am
Thanks one and all, have worked around the problem.
Cheers,
Julian
May 18, 2006 at 1:58 am
I've been looking through it but am struggling with the fact that I am trying to extract ntext.
So far I have:
ALTER PROCEDURE dbo.proc_Templates_GetTemplateByObjectPath
(
@inputObjectPath varchar(100), @myTemplate NTEXT output
)
AS
SET NOCOUNT...
May 17, 2006 at 2:04 am
Actually don't worry about it, have managed to work it out myself.
Thanks again.
May 12, 2006 at 3:25 am
Hi Peter, thanks for that.
Just one final thing, how do I structure the table search so that when I come across a TemplateID the loop stops and returns the TemplateID?
Cheers,
Julian
May 12, 2006 at 2:26 am
Thanks, I'll check it out.
I've actually managed to get my original code working, but it will need some tweaking at some point so will do more research then.
March 2, 2006 at 2:18 am
Many thanks, I didn't realise I could link the CASE statements together like that.
February 28, 2006 at 4:56 am
Which article are you referring to?
February 28, 2006 at 1:59 am
Hi Karl,
OK, I think I get the idea - will have a play around to see what I can produce.
Cheers,
Julian
February 27, 2006 at 9:04 am
Excellent, thanks for that.
Is it possible to return boolean values as opposed to the text values True and False?
February 23, 2006 at 10:17 am
Viewing 14 posts - 1 through 14 (of 14 total)