Very, very happy with http://cfxhosting.com.
They are what you are looking for.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 1:05 PM
To: CF-Talk
Subject: CF_inexpensive_reliable_ISP
Does any have first hand expereince with a
For an Integer or Number field, does it make more sense to default values to
NULL or 0?
When used for calculations, a column with NULL could cause a problem (eg.
NULL * 2).
Columns with NULL will be ignored in and SQL count, but columns with a 0
will be counted.
Is this right? Are there other
NOT myquery.myIntegerColumn
If the column IS 0, this executes
/cfif
I find that useful in certain situations.
Mark
-Original Message-
From: Rice, John J [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 7:34 AM
To: CF-Talk
Subject: NULL or 0
For an Integer or Number field
Lightning
Anyone have any knowledge to share about Lightning.
Rumor blew by that this will be the name for the new CF+++ Server.
Is this just another code name? Is it Neo?
I heard it comes just short of having it's own operating system.
Yet it has everything else you can think of.
-John
CFHTTP does not allow a GET request to pass header information (like
cookies).
CFX_HTTP does allow a GET request to pass header information (like cookies).
I recently was given the task of pulling xml from LiveLink and using xslt
to reformat the xml and xsl to format the xml to html while being
The best way to do something like that may be to
create and html page and use js to open that
page in a new window (window.open()).
Then use js to pass information back
to the opening page from the new window.
You then have all the flexability of html
formatting.
I've used that method for some
This should work:
/**/
WHERE userid='#client.cim_userid#'
AND
TRUNC(dateTaken) = TRUNC(TO_DATE('29-8-2001','dd-mm-'))
AND TRUNC(dateTaken) = TRUNC(TO_DATE('29-8-2001','dd-mm-'))
/**/
making the date variable of course...
I know there is a better way, but off the top of
:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 10:41 AM
To: CF-Talk
Subject: Truncate?
Uh...would someone mind briefing me on the TRUNC or TRUNCATE function? Can't
find either in my SQL or CF references.
- Original Message -
From: Rice, John J
To: CF-Talk
Sent: Thursday
/**/
body onload=document.forms[0].reset();
/**/
will do what you need.
-Rice
-Original Message-
From: Kevin Mansel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 1:21 PM
To: CF-Talk
Subject: Small JS Question
Ok, I have a form, I submit the form, the values are passed.
to add to the two other posts:
GROUP BY in the SQL statement is generally used
to do summary reporting.
you can only SELECT the columns that you GROUP BY
and any other column in the SELECT statement
must be and aggregate function.
GROUP in CFOUTPUT will do the grouping at the
client level not
structure to handle grouping by
company, department, employee
and then all the time in, time out entries for each employee
I think we could all learn by it and I for one would greatly
appreciate it.
Terry Troxel
- Original Message -
From: Rice, John J [EMAIL PROTECTED]
To: CF-Talk [EMAIL
You may want to append an
ORDER BY iCasacApptID
to the second query in your UNION.
-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 11:34 AM
To: CF-Talk
Subject: SQL help/group in CFOUTPUT not working??
hello, I've been working
of names, so adding
Order By 3
to the bottom of the query should work
HTH
Hatton Humphrey
-Original Message-
From: Rice, John J [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 1:00 PM
To: CF-Talk
Subject: RE: SQL help/group in CFOUTPUT not working??
You may want
You may want to check for a Cold Fusion variable that is has
a single or double quote stored in it.
Check the html result of you page for extra quotation marks.
Something like O'Brian in the CF variable strName here
could generate that error.
onclick=alert('#strName#');
strName =
if you are using Oracle use this type of syntax:
AND cas.iCasacApptID = cats.iCasacApptID(+)
The (+) makes an outer join where cats.iCasacApptID may or may
not have a match for cas.iCasacApptID. So all records from cas
will come back. A null will be in the cats column where
there was not a
15 matches
Mail list logo
