[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 Query analizer it works. Is there some atiquated CF4.0 code I am using that is not valid with CFMX? Christopher V. Holdman Webmaster - City of Olathe work: 913.971.6286 cell: 913.238.4681
RE: [KCFusion] Client variables
I upgraded from 4.0. I found that if I change my variable from #request# to #form.request# it works. Christopher V. Holdman Webmaster - City of Olathe work: 913.971.6286 cell: 913.238.4681 -Original Message- From: Matt Jones [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 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] Client variables Well I am not sure if this is a problem or not but one of my field names is 'request'and everything works weel on most of the pages of the application except for when I am querying the 'request' field. Is 'request' and reserved word in SQL or ColdFusion? Christopher V. Holdman Webmaster - City of Olathe work: 913.971.6286 cell: 913.238.4681 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 11:04 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Client variables The requested scope CLIENT has not been enabled. Before CLIENT variables can be used, the CLIENT state management system must be enabled using the CFAPPLICATION tag. Do I need to adjust my script because of MX...I am not using any cfapplication tags. Yes, you will need to change/use the cfapplication tag in your application.cfm file. By default session and client management is supported and turned on in the CF Administrator. However, I am pretty sure that you must still turn on the session management in your application file (and hence every CF page that runs). Take a look at the cfapplication tag in your documentation, you will probably need to have clientmanagement=yes and sessionmanagement or something similar set to yes, all in 1 tag. It is pretty easy to setup. If you just upgraded to MX/6.1 from an older version, nothing should have changed and I don't know why you are getting an error now and not before. Are you sure there wasn't an Application.cfm page already running? By design, CF looks in the directory of the file being run, and if it doesn't find the application.cfm file it moves up the directory tree. It continues moving up as far as it can towards the root until it either finds the file or hits the highest level of the directory/web server accessible path. If your application was nested inside of someone else's directory path before, you may have been running the file without knowing it and it may have had client/session variables and management turned on. Good luck Ryan __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[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 'NEW' is starting a new Roman Numeral instead of staying under III. and starting a new row with 'A', 'B', 'C', etc. I have supplied my code below. I am sure I am doing something wrong, but I can't find it. I. FIELD 1 A. FIELD 2 - FIELD 3 B. FIELD 2 - FIELD 3 II. FIELD 1 A. FIELD 2 - FIELD 3 B. FIELD 2 - FIELD 3 III. NEW A. FIELD 1 1. FIELD 2 - FIELD 3 2. FIELD 2 - FIELD 3 B. FIELD 1 1. FIELD 2 - FIELD 3 2. FIELD 2 - FIELD 3 IV. FIELD 1 A. FIELD 2 - FIELD 3 B. FIELD 2 - FIELD 3 ol type="1" cfoutput query="list" group="field1" cfif field1 CONTAINS "NEW" liNEW ol type="A" cfoutput group="field1" li#field1# ol type="1" cfoutput group="field2" li#field2# - #field3#p /cfoutput /ol /cfoutput /ol cfelse li#field1# ol type="A" cfoutput group="field2" li#field2# #field3# /cfoutput /ol /cfif /cfoutput/ol Christopher V. Holdman Webmaster - City of Olathe work: 913.971.6286 cell: 913.238.4681
RE: [KCFusion] Simple Query Question
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 IN ( ' #hlist# ' ) statement...any ideas why? Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 8:29 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Simple Query Question Depend on what the data type of the field you are calling from the table. If it is a numeric field you will not need to have any ' around the numeric values, but if the data type is varchar / char then you will have to have ' around the string. varchar/char select * from table where field1='value1' AND field2 IN ( 'a','b','c') select * from table where field1='value1' 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 Question [EMAIL PROTECTED] fusion.org 03/13/03 04:35 PM Please respond to CF-List I am not receiving any errors but I am not receiving any records and when I do a record count I get 0. Also, why couln;t I just skip the cfset and put #form.value2# instead of #hlist#. Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 4:11 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] Simple Query Question not setup exactly like you have it but you can use the IN sql statment with your list of variables it does not require you to split it up cfset hlist = replace(form.value2, , , ',' , all) cfquery name=query datasource=data select * from table where field1='value1' AND field2 IN ( ' #hlist# ' ) /cfquery Chris Holdman [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] KS.ORGcc: Sent by: Subject: [KCFusion] Simple Query Question [EMAIL PROTECTED] fusion.org 03/13/03 03:58 PM Please respond to CF-List I have a form with a multiple select box that I am want to build a query from, but am having problems. I set up an index loop with an OR statement, but I have obviously set it up wrong beacuase it is adding an OR to the end of the query. How do I set it up to not put an OR after the last index? cfquery name=query datasource=data select * from table where field1='value1' AND ( cfloop index=index list=#form.value2# delimiters=, field2='#index#' OR /cfloop ) /cfquery Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message- From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 3:16 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Printer Friendly Directory Listing style=page-break-after: always if you say 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 11, 2003 3:03 PM To: '[EMAIL PROTECTED]' Subject: [KCFusion] Printer Friendly Directory Listing 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 not have the department title. Is there a way to determine where a printing page break will occur and force the follwoing page to repeat the department title. Below is an example of what I mean and the code I currently use. Department A address phone # - name phone # - name phone # - name Department B address phone # - name phone # - name phone # - name phone # - name phone # - name phone # - name phone # - name phone
RE: [KCFusion] Simple Query Question
That worked Thanks for all the help. Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message- From: Benjamin J. Price [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 9:12 AM To: [EMAIL PROTECTED] 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 IN ( ' #hlist# ' ) statement...any ideas why? Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 8:29 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Simple Query Question Depend on what the data type of the field you are calling from the table. If it is a numeric field you will not need to have any ' around the numeric values, but if the data type is varchar / char then you will have to have ' around the string. varchar/char select * from table where field1='value1' AND field2 IN ( 'a','b','c') select * from table where field1='value1' 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 Question [EMAIL PROTECTED] fusion.org 03/13/03 04:35 PM Please respond to CF-List I am not receiving any errors but I am not receiving any records and when I do a record count I get 0. Also, why couln;t I just skip the cfset and put #form.value2# instead of #hlist#. Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 4:11 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] Simple Query Question not setup exactly like you have it but you can use the IN sql statment with your list of variables it does not require you to split it up cfset hlist = replace(form.value2, , , ',' , all) cfquery name=query datasource=data select * from table where field1='value1' AND field2 IN ( ' #hlist# ' ) /cfquery Chris Holdman [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] KS.ORGcc: Sent by: Subject: [KCFusion] Simple Query Question [EMAIL PROTECTED] fusion.org 03/13/03 03:58 PM Please respond to CF-List I have a form with a multiple select box that I am want to build a query from, but am having problems. I set up an index loop with an OR statement, but I have obviously set it up wrong beacuase it is adding an OR to the end of the query. How do I set it up to not put an OR after the last index? cfquery name=query datasource=data select * from table where field1='value1' AND ( cfloop index=index list=#form.value2# delimiters=, field2='#index#' OR /cfloop ) /cfquery Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message- From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 3:16 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Printer Friendly Directory Listing style=page-break-after: always if you say 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 11, 2003 3:03 PM To: '[EMAIL PROTECTED]' Subject: [KCFusion] Printer Friendly Directory Listing 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
[KCFusion] Simple Query Question
Title: Message I have a form with a multiple select box that I am want to build a query from, but am having problems. I set up an index loop with an OR statement, but I have obviously set it up wrong beacuase it is adding an OR to the end of the query. How do I set it up to not put an OR after the last index? cfquery name="query" datasource="data"select * fromtable wherefield1='value1' AND ( cfloop index="index" list="#form.value2#" delimiters="," field2='#index#' OR /cfloop )/cfquery Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message-From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 3:16 PMTo: '[EMAIL PROTECTED]'Subject: RE: [KCFusion] Printer Friendly Directory Listing if you say 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 11, 2003 3:03 PMTo: '[EMAIL PROTECTED]'Subject: [KCFusion] Printer Friendly Directory Listing 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 not have the department title. Is there a way to determine where a printing page break will occur and force the follwoing page to repeat the department title. Below is an example of what I mean and the code I currently use. Department Aaddressphone # - namephone # - namephone # - name Department Baddressphone # - namephone # - namephone # - namephone # - namephone # - namephone # - namephone # - namephone # - namephone # - name [page break]Department Baddressphone # - namephone # - namephone # - name DepartmentCaddressphone # - namephone # - namephone # - name cfoutput query="list" group="Department" bfont size="+1"#Department#/font/bbr #building#br hr align="left" width="300" cfoutput #Ext# - b#Name#/bbr /cfoutput p/cfoutput Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED]
[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 not have the department title. Is there a way to determine where a printing page break will occur and force the follwoing page to repeat the department title. Below is an example of what I mean and the code I currently use. Department Aaddressphone # - namephone # - namephone # - name Department Baddressphone # - namephone # - namephone # - namephone # - namephone # - namephone # - namephone # - namephone # - namephone # - name [page break]Department Baddressphone # - namephone # - namephone # - name DepartmentCaddressphone # - namephone # - namephone # - name cfoutput query="list" group="Department" bfont size="+1"#Department#/font/bbr #building#br hr align="left" width="300" cfoutput #Ext# - b#Name#/bbr /cfoutput p/cfoutput Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED]
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" name="email" onvalidate="subform" message="Please enter a valid email address"pinput type="submit" value="Submit"/cfform Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message-From: Ramsey Abu-Absi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 12:35 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] ColdFusion and JSP pagesHi Chris,I think the problem is that cfform is an all or nothing deal. You can use your own form validation, or you can use cfform/cfinput, but not a combination of the two. The reason is that cfform generates a _javascript_ function that uses the onsubmit event. So if you specify an onsubmit event, I believe CF will ignore it, or not run it's own validation. I don't think onsubmit is a valid attribute of cfform. (I could be wrong on this).Thanks,RamseyAt 12:36 PM 2/19/2003, you wrote: I have a form where I am using cfform. I would like to also include my own _javascript_ to use for validation, but it is not working. What am I doing wrong?script language="_javascript_"!--function subform(o) { if (o.email.value==''){ alert('email is required!'); o.email.focus(); return false; }else{ if (isemail(o.email.value)==false){ alert('Invalid email address!'); o.email.focus(); o.email.value=o.email.value; return false; }}return true}function isemail(v) {var i=false;if (v!=""){var re=/^([A-Za-z0-9_-]){1,}(\.([A-Za-z0-9_-]){1,})*@(([A-Za-z0-9_-]){1,}\.)+([A-Za-z0-9]){1,}$/;if (re.test(v)==true){ i=true; }}return i;}//--/script/headbodycfform action="" method="post" onsubmit="return subform(this);"input type=text size="40" name="email"pinput type="submit" value="Submit"/cfformChristopher V. Holdman [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Select in Date Range
I get an error ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in criteria expression. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (3:40). Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]] Sent: Monday, February 10, 2003 11:48 AM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] Select in Date Range What 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 success. I want to select betwee two dates. Here is my query, what am I doing wrong. cfquery datasource=date name=name select * from request where closed between '2002-10-01 00:00:00' AND '2002-12-15 00:00:00' order by closed /cfquery Christopher V. Holdman [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Select in Date Range
This worked... cfset date1 = '2002-10-01' cfset date2 = '2002-12-15' cfquery datasource=data name=name select * from request where closed between #CreateODBCDate(date1)# and #CreateODBCDate(date2)# order by closed /cfquery I think the error was because the dates I entered were not in a valid date format, and the I was getting a conversion error trying to convert it. The database was probably trying to compare between character strings, not actual date fields. So I set the dates and use CreateODBCDate to make sure they were using the same date structure. Thank for the comments. Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]] Sent: Monday, February 10, 2003 11:59 AM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] Select in Date Range Ok 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:43 AM Subject: RE: [KCFusion] Select in Date Range I get an error ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC Microsoft Access 97 Driver] Data type mismatch in criteria expression. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (3:40). Christopher V. Holdman Webmaster - City of Olathe (913) 971-6286 (913) 238-4681 Cell [EMAIL PROTECTED] -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]] Sent: Monday, February 10, 2003 11:48 AM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] Select in Date Range What 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 success. I want to select betwee two dates. Here is my query, what am I doing wrong. cfquery datasource=date name=name select * from request where closed between '2002-10-01 00:00:00' AND '2002-12-15 00:00:00' order by closed /cfquery Christopher V. Holdman [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[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 instead of just inserting the code into the jsp page? Christopher V. Holdman [EMAIL PROTECTED]
[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 20020329, need 20020903).Please contact the vendor for the correct version. I just installed Apache 2.0.43, and according to the docs, modulescompiled with versions prior to 2.0.42 need to be recompiled beforethey'll work with this release. Macromedia's web site does have someColdFusion updates, but they only support up to Apache 2.0.40. Does anyone know when they are expecting to have an update for fix for 2.0.43+? Christopher V. Holdman [EMAIL PROTECTED]
[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? Christopher V. Holdman
[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) 493-6010 Pager [EMAIL PROTECTED]