CMS: Expanding the database

retroviz · February 27th, 2007, 05:45 PM

okay message on its way thanks.

the criteria "1" was an example as this is a variable parameter.

Instead of:

Quote:

quote:..... WHERE ParentId = 1

if it was:

Code:

WHERE ParentId = @parentId

at what point would I create and insert this variable?

Imar · February 27th, 2007, 05:47 PM

Quote:

quote:if it was:

WHERE ParentId = @parentId

at what point would I create and insert this variable?

That would depend on where you get the variable from....

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

retroviz · February 27th, 2007, 06:15 PM

would be a querystring parameter passed (in the CMS application case) from Content Type i.e. @contentTypeID

so I could have "SELECT * FROM Category WHERE ContentTypeID = @contentTypeID"