Re: CF sort of "fully qualified objects"

eate table statements need to be create table dbo.tablename ... If it's the first, I don't know what to tell you, the dbo. should be implied. - Carl L ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard

Re: replace function

There's a fourth argument, which says to either replace only the first instance of the substring ("ONE"), or all instances of the substring ("ALL"). "ONE" is the default. To replace all the spaces, you need #Replace(get_ing_img.sbclc_itme, " ", "", "ALL)# See the docs for more details. > I'm

Re: URL/FORM var Obfuscation techniques

https. Since your end-user is going to be submitting forms/going to the site, there's really no point in hiding form/url variable names from them. This will hide it from anyone else. - Carl L ~| Introducing the F

Re: Paired Custom Tags

If you're going to be overloading/replacing cfmail, also bear in mind that you need to wrap the whole thing in a cfoutput tag, or else you end up without any of the inner variable display tags being processed. (speaking from experience) ~~

Re: I want to Create "Page has expired"

You'll have to put a meta tag into your document, telling the browser that the page has expired when you hit it. Here's more information on meta tags: http://www.htmlhelp.com/reference/wilbur/head/meta.html This is, however, only a suggestion; the browser doesn't HAVE to make the page expire,

Re: Cached queries

You can make a function that caches the query object in the application scope. Have the function return type be "query", and when the query is called, check the cache time and re-run the query if the cache has expired. ~| Intro

Re: How to get these query results - Take 2

The easiest way I've seen to do this is to have a "most recent update" date field in the "events" or "documents" table. An insert/update trigger on the "updates" table can guarantee that the "most recent update" field will always be accurate. Then, all you need is a query something like this: