Cfquery Statements and when are they executed ?????

I have a series of cfquery statements at the top of the page as soon as that page is activated does the server take time to search for all those query results or rather does the cf server wait until the query is requested further down the page from that specific cfquery statement before the

Re: Cfquery Statements and when are they executed ?????

Claude The template is parsed, then executed. The query (and any other) statements are issued as they are encountered. Any queries within a CFIF are only executed if the CFIF is true. You can prove this by constructing a syntactically correct (for CF) query, but one that generates an SQL

Re: Cfquery Statements and when are they executed ?????

Hi, as far as I know queries are executed, when they are encountered in the template. so if you put them on the top of the page, first all the queries are executed. You can verify this by looking at the debug output. I would recommend to break the template to small pieces and put each section

Re: Testing number of characters in CFform textarea

The preferred approach is to do it with JacaScript on the client side and also with CF on the Server side. Client side gives better response (the form is not submitted). ServerSide provides a catch-all if the user has JavaScript disabled. That said, it is also a good idea to include something

RE: Cold fusion on IE Netscape

hi thanx a lot. it just worked fine regards nagesh -Original Message- From: Shane [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 29, 2000 11:26 PM To: [EMAIL PROTECTED] Subject: Re: Cold fusion on IE Netscape One thing, check to make absolutely sure that you have closed every TR

RE: Cold fusion on IE Netscape

hi thanx a lot. it just worked fine regards nagesh -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 29, 2000 4:53 PM To: [EMAIL PROTECTED] Subject: Re: Cold fusion on IE Netscape nagesh NN supports JavaScript like all browers, tolerates

CF-Talk V1 #110

Hello I am on holiday until Monday 14th of August. Please phone Electrum on 0131 555 4241 if it cannot wait until then. Cheers _ This message has been checked for all known viruses by Star Internet delivered through the

Re: Testing number of characters in CFform textarea

Claude, Not to jump in front of Jeff, but you might check out the javascript called, "Limit Textarea" at http://javascript.internet.com/forms/ According to the description, "This script controls a maximum textarea input amount and updates a small counter with how many characters are left with

RE: Testing number of characters in CFform textarea

I couldn't remember where I found that puppy. But, guess what? That's the one I have. No need to wait for Monday :-) I didn't know about the dynamic fix - very nice.. Thanks John. -Original Message- From: John Allred [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 30, 2000 11:15 AM To:

RE: A couple more cflock question

Why did Allaire design Cold Fusion so you need to lock the variables when you use them? Why doesn't Cold Fusion take care of the threading issues and locking? My reasoning is this: 1) Much of the power of CF is it's ability to set session application variables. 2) According to all the threads

RE: Oh man i need help

CFIF #timeformat(time, "hh:mm:tt")# gt "07:59:AM" and #timeformat(time,"hh:mm:tt")# lt "12:01:AM" Additional comments on this; Using TimeFormat to validate a time is REAL dumb - especially if you're using a 12 hour clock... the reason? "01:00:PM" is less than "07:00:AM", but it's 6 hours

RE: Custom Tag for Date and Time

Any one have a custom tag that retrieves both the DateFormat (Now()) and TimeFormat (Now()) as one function that can be inserted into a database? I assume you've got your field as a DateTime format - if not, then change it to be DateTime Also, try to use the database native functions - Now()

RE: SQL and apostrophes

Just put it between double quotes. Most datatypes use doublequotes anyhow.. so it would be last_name="O'Brien" and you should be okay. let me know if i'm retarded or not.. i probably am :-) This actually breaks CFQuery - especially if you use the SQL parameter of the tag BTW, I've checked

RE: Newbie Question on Tables and CF

I've been searching on info on how to create a multiple column table = from one column of data. What I want to be able to do is create a table like so: AdamChris Bob Dan But the code I found outputs like this: AdamBob ChrisDan How do I do this? I'm thinking that I

OT: JavaScript background image question

I know this isn't a CF question, but it's for one of our CF sites... Am I going daft, or is there no JavaScript way of changing the background image of a page - there seems to be controls for just about everything else, but I can't find anything for changing the background image (the Background

Nesting CFLOCK OK?

Just when you think you've asked everything... I'm running into some areas of my code where I'm looping through session variables and am setting other session variables inside the loop. I had already locked the cfset tags exclusively but now have to readonly the entire loop since it's a

RE: Verity (Speeding Up DB Searches)

How can Verity searches of database columns be speeded up? best, paul At 09:26 AM 7/30/00 -0400, you wrote: For static pages, the version of Verity provided with CF only indexes the TITLE and BODY. -- Archives:

Re: OT: JavaScript background image question

I think you need to redisplay the window, something like: myPupUp.document.open(); myPupUp.document.write('TITLEPage Source/TITLE'); myPupUp.document.write('BODY BACKGROUND=images/BG.jpg'); myPupUp.document.close(); HTH Dick At 6:31 PM +0100 7/30/00, Philip Arnold - ASP wrote: I know

Question on error

This is a multi-part message in MIME format. --=_NextPart_000_001B_01BFFA53.D4B192A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Can anyone tell me if there is a difference between the error "Datatype = mismatch" and the error "Type

RE: Verity (Speeding Up DB Searches)

Make sure that you optimize the collection after refreshing the collection. Use the "cfindex action="optimize" " This usually results in dramatic (sometimes 2x for me) speed performance on database collections. -Original Message- From: paul smith [mailto:[EMAIL PROTECTED]] Sent:

Re: Read HTTP Headers

David, I'm not 100% sure but the 'stretch' tool offered by kestral will probably do the job for you it is available free here : http://www.kestral.com.au/devtools/ (along with some other very useful utilities) Jared Clinton. ObjectMastery. David Gassner wrote: Does anyone know of a way to

CF-Talk V1 #111

Hello I am on holiday until Monday 14th of August. Please phone Electrum on 0131 555 4241 if it cannot wait until then. Cheers _ This message has been checked for all known viruses by Star Internet delivered through the

RE: Verity (Speeding Up DB Searches)

Thanks! best, paul At 06:02 PM 7/30/00 -0700, you wrote: Make sure that you optimize the collection after refreshing the collection. Use the "cfindex action="optimize" " This usually results in dramatic (sometimes 2x for me) speed performance on database collections. -Original

Re: Spectra problem, anyone want to help?

Please post to Spectra-Talk where all the Spectra Gurus hang out. I'm using win2000 with cf 4.5 enterprise server on my laptop. When I installed the spectra, i had to check the [Use Cold Fusion Administration Authentication] in the advanced settings of CF admin settings. It returned this

RE: Help! - Passing image file data with wddx

I'm trying to use wddx to pass an image file from one site to another over the web. I've followed the examples in the documentation and think I'm on the right track, but end up with the following error... The problem might be that there is some character in the Base64 string that is an XML

RE: Verity

Does Verity Index Meta Tags? And if it does which meta tags does it index? If it doesn't index meta tags where does it get its information from? For static pages, the version of Verity provided with CF only indexes the TITLE and BODY. Dave Watts, CTO, Fig Leaf Software

A couple more cflock question

Hi once again. I'm about to start going back (g) and locking all my session, application variables, etc properly. Got a couple question. 1. Suppose I'm creations a session variable FROM session variables. For instance: I have: session.subtotal, session.tax, and session.shipping. I want

RE: A couple more cflock question

Hi once again. I'm about to start going back (g) and locking all my session, application variables, etc properly. Got a couple question. 1. Suppose I'm creations a session variable FROM session variables. For instance: I have: session.subtotal, session.tax, and session.shipping. I

RE: A couple more cflock question

Has anyone put together a FAQ about CFLOCK that would show examples and best practices? There are a lot of great optimization tips floating around, and I'd love to find a single source that covers most of them. Things like you just mentioned, such as copying the session to the request scope,

RE: Testing number of characters in CFform textarea

I have a great javascript function that handles this on the client side (not my own code). It has an optional counter that displays the number of characters remaining (counts down as the user enters text). Once your limit is reached, the user is unable to enter more text. I don't have it here