RE:

2002-03-15 Thread Rice, John J
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: Does any have first hand expereince with a inexpensive and reilable CF hosti

RE: NULL or 0

2002-01-31 Thread Rice, John J
IS 0, this executes 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, does it make more sense to default values to N

NULL or 0

2002-01-31 Thread Rice, John J
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 r

Lightning! - New CF Server?

2001-12-05 Thread Rice, John J
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 AND Cookies II

2001-10-25 Thread Rice, John J
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 a

RE: ok, OT JS question

2001-09-17 Thread Rice, John J
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 ti

RE: Small JS Question

2001-08-30 Thread Rice, John J
/**/ /**/ 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. And then I do some inserting into my D

RE: Truncate?

2001-08-30 Thread Rice, John J
:[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: Thu

RE: Systdate Query

2001-08-30 Thread Rice, John J
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 t

RE: Group By..

2001-08-24 Thread Rice, John J
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 PROTECTED]> Sent: Friday, August 24, 2001 7:58 AM Subject: RE: Group By.. > > to add to the two othe

RE: Group By..

2001-08-24 Thread Rice, John J
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 no

RE: SQL help/group in CFOUTPUT not working??????

2001-08-23 Thread Rice, John J
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???

RE: SQL help/group in CFOUTPUT not working??????

2001-08-23 Thread Rice, John J
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 on

RE: Cf in Select Stmt help

2001-08-21 Thread Rice, John J
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 m

RE: new java script problem

2001-08-21 Thread Rice, John J
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 = replace(st