[KCFusion] Error Executing Database Query

Title: Message Another error after migrating to MX From the following code I get an error: Invalid object name 'ae_dt1'. cfquery name="toplist" datasource="otg" maxrows="1"select Distinct(field2) from ae_dt1where field8='PUBLIC'order by field2 desc/cfquery If I so the same query in SQL

RE: [KCFusion] Client variables

, 2003 11:27 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Client variables yes, it is a SCOPE! what version of cf did you upgrade from? -Original Message- From: Chris Holdman [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:21 AM To: '[EMAIL PROTECTED]' Subject: RE

[KCFusion] outine gouping problems

Title: Message I have a query output I am trying to group into an outline form. Below is the outline formatt I am trying to achieve. Under III. I have several rows that have 'NEW' in them and want to expand just that portion of the outline. The problem I get is that every row returning

RE: [KCFusion] Simple Query Question

' AND field2 IN (1,2,3,4) Chris Holdman [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] KS.ORGcc: Sent by: Subject: RE: [KCFusion] Simple Query

RE: [KCFusion] Simple Query Question

] Subject: Re: [KCFusion] Simple Query Question Try IN ( ' #PreserveSingleQuotes(hlist)# ' ) -Ben Price Chris Holdman writes: I am having a problem with the cfset hlist = replace(form.value2, , , ',' , all) Statementfor some reason it is converting the ' to when I insert it in my

[KCFusion] Simple Query Question

apply that to a table tag, and then have multiple tables each having that style, it will have a page break between them. of course, I'm sure it's only ie, but better than nothing. -Original Message-From: Chris Holdman [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 1

[KCFusion] Printer Friendly Directory Listing

Title: Message I have a directory listing pulling from a database and sorting by departments. Everything work great online, but some people are wanting to print it out...when they do sometimes the page break for printing occurs in the middle of a department listing and the second page does

RE: [KCFusion] ColdFusion and JSP pages

Title: Message You are correctI found out that you cannot use onsubmit, but instead you use "onvalidate" in the cfinput tag. So it looks as such script language="_javascript_"!--function subform(o) blah blah blah //--/script cfform action="" method="post"cfinput type=text size="40"

RE: [KCFusion] Select in Date Range

are you getting when you run this? An error or an empty record set? A. - Original Message - From: Chris Holdman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 10, 2003 11:34 AM Subject: [KCFusion] Select in Date Range Okay I know this should be easy but I am not having any

RE: [KCFusion] Select in Date Range

it looks like you are giving Access two strings insted of two dates. Im assuming the field is of type date so either toss # signs around your dates or use the DATEPART function. A. - Original Message - From: Chris Holdman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 10, 2003 11

[KCFusion] ColdFusion and JSP pages

I have a situation where I am need to include a cfm page into a jsp pageI have tried the %@ include file="file.cfm"% but this does not work becuase the jsp page tries to translate the Cold Fusion code into java code. Is there a way to pass the results of a cfm page into a jsp page

[KCFusion]

I've installed ColdFusion and am trying to get it running with Apache.ColdFusion starts up OK, but when I start Apache, I get the followingmessage when it attempts to load the mod_jrun module: Starting Apache:httpd: module "mod_jrun20.c" is not compatible with thisversion of Apache (found

[KCFusion] Novice needs help

I have a novice question. I have a database wherethe ID's are determined by date, time and random number... #DateFormat(Now(), "DDMM")#-#TimeFormat(Now(), "HHmmss")#-#Round(Rand()*1000)# I want to use this ID to do a query on all records for the past week. Is this possible?

[KCFusion] SSN Validation

Has anyone done a validation on Social Security Number to check if it was valid, not juts checking to see if it follows a numeric NNN-NN- pattern, but is an actual valid Social Seciurty Number? Christopher V. Holdman Webmaster - City of Olathe (913) 393-6286 (913) 238-4681 Cell (913)