Re: Which version of MDAC is best with Cold Fusion 4.5.1
Always get the latest mdac which is at version 2.6 right now. Just go to microsoft.com, select download, select keyword and w2k and type in "mdac" and you see the link for it. It's about a 5mb download. Xing - Original Message - From: "Jeffry Houser" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 9:05 PM Subject: Re: Which version of MDAC is best with Cold Fusion 4.5.1 If it's working, don't change anything. I have ColdFusion and the latest version of MDAC (I'm pretty sure 2.5) running on my machines here just fine. Of course with only one user (me) you don't get a lot of server load. At 04:19 PM 02/27/2001 -0500, you wrote: I think I am currently run MDAC 2.1 (no patches) with Cold Fusion Profesional 4.5.1. Presently we are using ODBC against both VFP and Access databases/tables. Our DBA says that they are running MDAC 2.51.5303.5 elsewhere within the organization. Can and/or should I have our DBA upgrade to the 2.51.5303.5 version?? Will Cold Fusion play nice with 2.5, or should we go to the latest patched version of 2.1 ?? ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Stumped !
Jim,
If I understand the base of your problem, it's in trying to get the value of a
dynamically-named form field. Right? If so, it's easy...
formFieldValue = Evaluate("form.sameword" number)
presuming "number" is your incrementing value. Does that do it?
Cheers,
-Max
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stumped !
I had a similar problem,
On the processing page that updated the data base I used the following
Either use a Form or URL variable to pass through the Total Number of Items
in the collection,
cfloop index='index_no' from="1" To="#URL.Max_Count#"
cfquery name="updData" datasource="#DSN#"
update MyTable
set Col1='#evaluate("Form.XXX" index_No)#',
Col2='#evaluate("Form.YYY" index_No)#',
Col3='#evaluate("Form.ZZZ" index_No)#'
..
where Col='#evaluate("Form.WWW" index_No)#'
/cfquery
/cfloop
HTH
Jason Lees
National Express
Email : [EMAIL PROTECTED]
-Original Message-
From: Jim Mixon [mailto:[EMAIL PROTECTED]]
Sent: 28 February 2001 07:37
To: CF-Talk
Subject: Stumped !
quite frankly I am stumped . . . hopefully I can explain this properly here
... . . and get some needed help . . .
Certain fields in a form are dynamically generated, according to the number
of entries in a table . . .
Each dynamically generated field, i am presuming, needs to have its own
field name(name="uniquename"
so I have each field being created with a "name="sameword#number#" where
the number changes with each new field sequentially by adding 1.
since the submitting form fieldname is not yet known to the processing
page, how can I get that data into the designated table using the INSERT
query . . .?
I can certainly recreate the needed names in the processing page, but that
involves a variable which doesnt seem to work in this case . . .
creating a variable to act as a "form.variable-instead-of-fieldname" just
wont work for me . . .
the idea is that the user form would never need updating because it
supplies fields to the user based on entries in another table . . totally
dynamic . . .
each formfield subsequently needs to create its own record in another table
... .
perhaps this is just not doable using CF and SQL alone?
Jim Mixon - CEO
APT POINT NET, Inc. "A Premiere InterNET Gateway" . . .
[EMAIL PROTECTED] http://www.apt.net/
PO Box 160217 Hialeah, FL 33016 305-821-8451
FAX (305) 821-8189 auto-switching FAX
powered by Cold Fusion 4.01 . . . . feel the force!
CF Hosting Now Available . . . . !
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fw: CFQuery of database tables
Winston, I think queryName.ColumnList will help you out (where 'queryName' is the name of your query). It contains a comma-delimited list of all the column names returned by the query. To do what you want you'll need an outer loop over your query results, and then an inner loop that goes over each item in the queryName.ColumnList and displays it's value (you'll need to use Evaluate() for this last part). If you could, please post messages in plain text format, they're easier to read that way and take up less bandwidth. Thanks. Hope that helps, -Max ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: pie chart
that's version 3.1, I'm using 4.5, i can't seems to find the Java classes in the CF directory mak wl - Original Message - From: "David Shadovitz" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 2:57 PM Subject: RE: pie chart CF comes with a pie chart Java applet. Check out the CF 3.1 documentation on the bar and pie chart "graphlets" at http://telecom.fit.edu/cfdocs/user/ug20.htm. (Thanks to Al Musella for tipping me off to this.) -David On Tuesday, February 27, 2001 Sean Renet [SMTP:[EMAIL PROTECTED]] wrote: www.cfxgraphicsserver.com - Original Message - From: "Mak Wing Lok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 4:38 PM Subject: pie chart anyone knows any nice and cool pie chart custom tags? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: pie chart
its in C:\Inetpub\wwwroot\classes\CFGraphs if your inetpub is on your c drive. - Original Message - From: "Mak Wing Lok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 1:41 AM Subject: Re: pie chart that's version 3.1, I'm using 4.5, i can't seems to find the Java classes in the CF directory mak wl - Original Message - From: "David Shadovitz" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 2:57 PM Subject: RE: pie chart CF comes with a pie chart Java applet. Check out the CF 3.1 documentation on the bar and pie chart "graphlets" at http://telecom.fit.edu/cfdocs/user/ug20.htm. (Thanks to Al Musella for tipping me off to this.) -David On Tuesday, February 27, 2001 Sean Renet [SMTP:[EMAIL PROTECTED]] wrote: www.cfxgraphicsserver.com - Original Message - From: "Mak Wing Lok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 4:38 PM Subject: pie chart anyone knows any nice and cool pie chart custom tags? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: pie chart
How would one use these classes to display charts? nik -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: 28 February 2001 10:19 To: CF-Talk Subject: Re: pie chart its in C:\Inetpub\wwwroot\classes\CFGraphs if your inetpub is on your c drive. - Original Message - From: "Mak Wing Lok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 1:41 AM Subject: Re: pie chart that's version 3.1, I'm using 4.5, i can't seems to find the Java classes in the CF directory mak wl - Original Message - From: "David Shadovitz" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 2:57 PM Subject: RE: pie chart CF comes with a pie chart Java applet. Check out the CF 3.1 documentation on the bar and pie chart "graphlets" at http://telecom.fit.edu/cfdocs/user/ug20.htm. (Thanks to Al Musella for tipping me off to this.) -David On Tuesday, February 27, 2001 Sean Renet [SMTP:[EMAIL PROTECTED]] wrote: www.cfxgraphicsserver.com - Original Message - From: "Mak Wing Lok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 4:38 PM Subject: pie chart anyone knows any nice and cool pie chart custom tags? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFQuery of database tables
You could loop round the commma delimted list of column names given by query_name.ColumnList. -Original Message- From: Winston Sia [mailto:[EMAIL PROTECTED]] Sent: 28 February 2001 08:16 To: CF-Talk Cc: [EMAIL PROTECTED] Subject: Fw: CFQuery of database tables This is a multi-part message in MIME format. --=_NextPart_000_020E_01C0A1A1.B3261D40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I'm would like to make a query to each database table, with a "select *" = to output all records. I am going to use CFTABLE to output the results. = Is there any way I can do this wihtout having to specify one by one the = column/field names of that table? I am trying to do this since I want to display or output the whole = contents of all the tables in my database, which I am going to transfer = to Excel sheet. You see, the data I want to get is on IBM DB2, which I want to export to = my local SQL database. And the DB2 is remote, and I have no access to = it. I want to populate my local SQL database with the data on the IBM = DB2 database. We already requested for a comma-delimited text file of all the data of = all the tables of our database, but the DB admin is not responding. So I = am now trying to just get the data ourselves using CF.. manually. Immediate help will be very much appreciated. Thanks, Winston --=_NextPart_000_020E_01C0A1A1.B3261D40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIV style=3D"FONT: 10pt arial"/DIV DIVFONT face=3DArialHi,/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialI'm would like to make a query to each database = table,=20 with a "select *" to output all records. I am going to use CFTABLE to = output the=20 results. Is there any way I can do this wihtout having to specify one by = one the=20 column/field names of that table?/FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialI am trying to do this since I want to display = or output=20 the whole contents of all the tables in my database, which I am going to = transfer to Excel sheet./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialYou see, the data I want to get is on IBM DB2, = which I=20 want to export to my local SQL database. And the DB2 is remote, and I = have no=20 access to it. I want to populate my local SQL database with the data on = the IBM=20 DB2 database./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialWe already requested for a comma-delimited text = file of=20 all the data of all the tables of our database, but the DB admin is not=20 responding. So I am now trying to just get the data ourselves using CF.. = manually./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialImmediate help will be very much = appreciated./FONT/DIV DIVnbsp;/DIV DIVFONT face=3DArialThanks,/FONT/DIV DIVFONT face=3DArialWinston/FONT/DIV/BODY/HTML --=_NextPart_000_020E_01C0A1A1.B3261D40-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ** The opinions expressed in this E-mail are those of the individual and not necessarily the company. This E-mail and any files transmitted with it are confidential and solely for the use of the intended recipients ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: pie chart
thanks, eventually i found it in /allaire/spectra/classes mak wl - Original Message - From: "Sean Renet" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 6:18 PM Subject: Re: pie chart its in C:\Inetpub\wwwroot\classes\CFGraphs if your inetpub is on your c drive. - Original Message - From: "Mak Wing Lok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 1:41 AM Subject: Re: pie chart that's version 3.1, I'm using 4.5, i can't seems to find the Java classes in the CF directory mak wl - Original Message - From: "David Shadovitz" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 2:57 PM Subject: RE: pie chart CF comes with a pie chart Java applet. Check out the CF 3.1 documentation on the bar and pie chart "graphlets" at http://telecom.fit.edu/cfdocs/user/ug20.htm. (Thanks to Al Musella for tipping me off to this.) -David On Tuesday, February 27, 2001 Sean Renet [SMTP:[EMAIL PROTECTED]] wrote: www.cfxgraphicsserver.com - Original Message - From: "Mak Wing Lok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 4:38 PM Subject: pie chart anyone knows any nice and cool pie chart custom tags? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
URGENT: Referring Page Question
Basically i need to find out the first point of entry into a system by a person. I need to find out what was the referring page? Then the information will be stored in a database. As I am new to CF please could you give us a hand with this plz. Any issues using this method of detecting the information. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: pie chart
Well depending on your set up you need to add C:\Inetpub\wwwroot\classes\CFGraphs to your CLASSPATH enviroment variable then just set up an applet like normal cfparam name="Industry" default="Tech,Agriculture" cfparam name="Percent" default="50,50" APPLET CODE="PieChart" CODEBASE="/classes/CFGraphs/" WIDTH="300" HEIGHT="300" PARAM NAME="ChartData.Columns" VALUE="Items,Values" cfoutput PARAM NAME="ChartData.Items" VALUE="#Industry#" PARAM NAME="ChartData.Values" VALUE="#Percent#" /cfoutput PARAM NAME="BackgroundColor" VALUE="0080C0" PARAM NAME="LegendFontName" VALUE="Verdana" PARAM NAME="FontColor" VALUE="FF" PARAM NAME="Title" VALUE="Sean's Test CF Java Applet Pie Chart" PARAM NAME="TitleFontName" VALUE="Times Roman" PARAM NAME="TitleFontHeight" VALUE="16" PARAM NAME="LegendFontHeight" VALUE="14" PARAM NAME="ShowDateTime" VALUE="no" PARAM NAME="RefreshTime" VALUE="10" PARAM NAME="RefreshDataFromURL" VALUE="http://www.development.ws/testfolder/monitor.cfm" /APPLET NOTE: Java is CASE SENSITIVE so PieChart must be capital "P" Capital "C". I don't think I ever got that RefreshDataFromURL parameter to work which is why I went with cfxgraphicserver - Original Message - From: "Nick Betts" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 2:09 AM Subject: RE: pie chart How would one use these classes to display charts? nik -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: 28 February 2001 10:19 To: CF-Talk Subject: Re: pie chart its in C:\Inetpub\wwwroot\classes\CFGraphs if your inetpub is on your c drive. - Original Message - From: "Mak Wing Lok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 1:41 AM Subject: Re: pie chart that's version 3.1, I'm using 4.5, i can't seems to find the Java classes in the CF directory mak wl - Original Message - From: "David Shadovitz" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 2:57 PM Subject: RE: pie chart CF comes with a pie chart Java applet. Check out the CF 3.1 documentation on the bar and pie chart "graphlets" at http://telecom.fit.edu/cfdocs/user/ug20.htm. (Thanks to Al Musella for tipping me off to this.) -David On Tuesday, February 27, 2001 Sean Renet [SMTP:[EMAIL PROTECTED]] wrote: www.cfxgraphicsserver.com - Original Message - From: "Mak Wing Lok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 4:38 PM Subject: pie chart anyone knows any nice and cool pie chart custom tags? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: pie chart
cheers sean! nik -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: 28 February 2001 11:06 To: CF-Talk Subject: Re: pie chart Well depending on your set up you need to add C:\Inetpub\wwwroot\classes\CFGraphs to your CLASSPATH enviroment variable then just set up an applet like normal cfparam name="Industry" default="Tech,Agriculture" cfparam name="Percent" default="50,50" APPLET CODE="PieChart" CODEBASE="/classes/CFGraphs/" WIDTH="300" HEIGHT="300" PARAM NAME="ChartData.Columns" VALUE="Items,Values" cfoutput PARAM NAME="ChartData.Items" VALUE="#Industry#" PARAM NAME="ChartData.Values" VALUE="#Percent#" /cfoutput PARAM NAME="BackgroundColor" VALUE="0080C0" PARAM NAME="LegendFontName" VALUE="Verdana" PARAM NAME="FontColor" VALUE="FF" PARAM NAME="Title" VALUE="Sean's Test CF Java Applet Pie Chart" PARAM NAME="TitleFontName" VALUE="Times Roman" PARAM NAME="TitleFontHeight" VALUE="16" PARAM NAME="LegendFontHeight" VALUE="14" PARAM NAME="ShowDateTime" VALUE="no" PARAM NAME="RefreshTime" VALUE="10" PARAM NAME="RefreshDataFromURL" VALUE="http://www.development.ws/testfolder/monitor.cfm" /APPLET NOTE: Java is CASE SENSITIVE so PieChart must be capital "P" Capital "C". I don't think I ever got that RefreshDataFromURL parameter to work which is why I went with cfxgraphicserver - Original Message - From: "Nick Betts" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 2:09 AM Subject: RE: pie chart How would one use these classes to display charts? nik -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: 28 February 2001 10:19 To: CF-Talk Subject: Re: pie chart its in C:\Inetpub\wwwroot\classes\CFGraphs if your inetpub is on your c drive. - Original Message - From: "Mak Wing Lok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 1:41 AM Subject: Re: pie chart that's version 3.1, I'm using 4.5, i can't seems to find the Java classes in the CF directory mak wl - Original Message - From: "David Shadovitz" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 2:57 PM Subject: RE: pie chart CF comes with a pie chart Java applet. Check out the CF 3.1 documentation on the bar and pie chart "graphlets" at http://telecom.fit.edu/cfdocs/user/ug20.htm. (Thanks to Al Musella for tipping me off to this.) -David On Tuesday, February 27, 2001 Sean Renet [SMTP:[EMAIL PROTECTED]] wrote: www.cfxgraphicsserver.com - Original Message - From: "Mak Wing Lok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 4:38 PM Subject: pie chart anyone knows any nice and cool pie chart custom tags? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: pie chart
heh, I haven't run those things in so long I just took a look and figured
out why I couldn't use the RefreshDataFromURL param. The applet includes
the CF Server Debugging if you have it on so it was blowing it up. So if
you use the code below, your monitor.cfm would look something like
cfparam name="Industry" default="Tech,Agriculture"
cfparam name="Percent" default="90,10"
cfscript
APPLETTEST = QueryNew("Industry,Percent");
if(IsDefined("Industry")) {
for(i = 1; i LTE listlen(Industry); i = i + 1) {
QueryAddRow(APPLETTEST);
QuerySetCell(APPLETTEST, "Industry", listgetat(industry,i));
QuerySetCell(APPLETTEST, "Percent", listgetat(Percent,i));
}
}
/cfscript
Columns:Items,Values
Cfoutput query="APPLETTEST"
#Industry#,#Percent#
/CFOUTPUT
- Original Message -
From: "Sean Renet" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 3:06 AM
Subject: Re: pie chart
Well depending on your set up you need to add
C:\Inetpub\wwwroot\classes\CFGraphs to your CLASSPATH enviroment variable
then just set up an applet like normal
cfparam name="Industry" default="Tech,Agriculture"
cfparam name="Percent" default="50,50"
APPLET CODE="PieChart" CODEBASE="/classes/CFGraphs/" WIDTH="300"
HEIGHT="300"
PARAM NAME="ChartData.Columns" VALUE="Items,Values"
cfoutput
PARAM NAME="ChartData.Items" VALUE="#Industry#"
PARAM NAME="ChartData.Values" VALUE="#Percent#"
/cfoutput
PARAM NAME="BackgroundColor" VALUE="0080C0"
PARAM NAME="LegendFontName" VALUE="Verdana"
PARAM NAME="FontColor" VALUE="FF"
PARAM NAME="Title" VALUE="Sean's Test CF Java Applet Pie Chart"
PARAM NAME="TitleFontName" VALUE="Times Roman"
PARAM NAME="TitleFontHeight" VALUE="16"
PARAM NAME="LegendFontHeight" VALUE="14"
PARAM NAME="ShowDateTime" VALUE="no"
PARAM NAME="RefreshTime" VALUE="10"
PARAM NAME="RefreshDataFromURL"
VALUE="http://www.development.ws/testfolder/monitor.cfm"
/APPLET
NOTE: Java is CASE SENSITIVE so PieChart must be capital "P" Capital "C".
I don't think I ever got that RefreshDataFromURL parameter to work which
is
why I went with cfxgraphicserver
- Original Message -
From: "Nick Betts" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 2:09 AM
Subject: RE: pie chart
How would one use these classes to display charts?
nik
-Original Message-
From: Sean Renet [mailto:[EMAIL PROTECTED]]
Sent: 28 February 2001 10:19
To: CF-Talk
Subject: Re: pie chart
its in C:\Inetpub\wwwroot\classes\CFGraphs if your inetpub is on your c
drive.
- Original Message -
From: "Mak Wing Lok" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 1:41 AM
Subject: Re: pie chart
that's version 3.1, I'm using 4.5, i can't seems to find the Java
classes
in
the CF directory
mak wl
- Original Message -
From: "David Shadovitz" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 2:57 PM
Subject: RE: pie chart
CF comes with a pie chart Java applet. Check out the CF 3.1
documentation
on
the bar and pie chart "graphlets" at
http://telecom.fit.edu/cfdocs/user/ug20.htm. (Thanks to Al Musella
for
tipping
me off to this.)
-David
On Tuesday, February 27, 2001 Sean Renet
[SMTP:[EMAIL PROTECTED]]
wrote:
www.cfxgraphicsserver.com
- Original Message -
From: "Mak Wing Lok" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, February 27, 2001 4:38 PM
Subject: pie chart
anyone knows any nice and cool pie chart custom tags?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this list alive?
Yepper ALIVE and raring too go, Johnny Five is aliveee Actually, I feel like a member of the undead - does that count? Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
Always get the latest mdac which is at version 2.6 right now. Just go to microsoft.com, select download, select keyword and w2k and type in "mdac" and you see the link for it. It's about a 5mb download. If you're running clustered SQL Server, then definitely don't go to 2.6 - it breaks all connectivity with the servers 2.5RTM is more stable Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
What about 2.6a? Lanny Udey Hofstra University [EMAIL PROTECTED] Wednesday, February 28, 2001 Always get the latest mdac which is at version 2.6 right now. Just go to microsoft.com, select download, select keyword and w2k and type in "mdac" and you see the link for it. It's about a 5mb download. If you're running clustered SQL Server, then definitely don't go to 2.6 - it breaks all connectivity with the servers 2.5RTM is more stable Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ColdFusion File Handling
Dave, I think I agree with you for small files. I suspect that on small files the incoming buffer is large enough to deal with the request as a single chunk. Although I've never run any hard tests I remember using this solution a while back and trying upload some huge files and it seemed to do the trick. If you are talking about large files the buffers are going to be flushed at least once. The first time they are flushed the HTTP headers are going to be passed to CF then you have the option to kill the processing. I suspect a I should do some deeper study into exactly how this is all happening ;-) -eric Common sense is genius dressed in its working clothes. -- Ralph Waldo Emerson Eric Barr Zeff Design (p) 212.714.6390 (f) 212.580.7181 -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 18, 2001 2:54 PM To: CF-Talk Subject: RE: ColdFusion File Handling There is no reason that you can't use the HTTP headers to determine size, cgi.content_length will give you a good *approximation* of the file size that is being uploaded. I say approximation because content length is the size of all the content on the page, of which you might have form fields or other variable length data being posted. You could use something like : cfif cgi.content_length GT Application.maxFileSize !--- someone is uploading a file bigger than we permit --- cflocation url="addDocumentError.cfm?error=fileSize" /cfif I have to say this is one of the rather disappointing "features" of CF if you look at the raw information being sent to the server there is enough information for CF to calculate how large a file is (http://www.ietf.org/rfc/rfc1867.txt?number=1867). I think the problem here is that, by the time CF could read the Content-Length HTTP request header, it's too late - the browser has sent the file within the HTTP request body, and the web server has already received it. Before the CF engine receives an HTTP request to process, that request has already been received in its entirety by the web server. The web server deals with issues like malformed requests, so it stands to reason that the file has to be written in full to the web server before CF gets to look at it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Efficiencies and ColdFusion [Was: RE: ColdFusion File Handling
Anyone have thoughts on general performance improvments when generating a LOT of output from ColdFusion? A user was trying to generate CSV output from a select from ColdFusion and it was taking forever. They were generating a line at a time to the file. So then they tried to generate it all in-memory and write it out once - again, very very slow. They ended up 'chunking' it up in 30k chunks of lines and that seemed to be the best. This is the latest server SP, on SPARC Solaris... Any thoughts, additional performance improvements, etc? -- Larry W. Virden URL: mailto:[EMAIL PROTECTED] URL: http://www.purl.org/net/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
If you're running clustered SQL Server, then definitely don't go to 2.6 - it breaks all connectivity with the servers 2.5RTM is more stable What about 2.6a? AFAIK, this still has a few issues - I would still stick with 2.5 (and I am) until it's proven that it works 100% Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: data insert security issues
I sometimes replace and with lt; gt; , which pretty similar to using
htmleditformat() I think.
This stops any code being executed when it is displayed from the database at
least.
Not sure if it's possible to do damage with malicious code in the sql insert
statement,
eg.
insert into table1
(Var1)
values
('#form.var1#')
I can't see how a mailicous value for form.var1 would cause damage? Maybe
I'm wrong.
Why don't you actually try to insert code which will execute when displayed?
Once you have figured out how that works, try and stop it working.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 27 February 2001 19:11
To: CF-Talk
Subject: data insert security issues
If I am allowing users to insert data into a db via a text area in a form
what kind of security issues does that raise? And does anyone have
recommendations
for how to handle those issues?
--
iWon http://www.iwon.com/ - Voted the #1 portal on the Web!
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Efficiencies and ColdFusion [Was: RE: ColdFusion File Handling
Anyone have thoughts on general performance improvments when generating a LOT of output from ColdFusion? A user was trying to generate CSV output from a select from ColdFusion and it was taking forever. They were generating a line at a time to the file. So then they tried to generate it all in-memory and write it out once - again, very very slow. They ended up 'chunking' it up in 30k chunks of lines and that seemed to be the best. This is the latest server SP, on SPARC Solaris... Any thoughts, additional performance improvements, etc? Schedule it, run it later, email them or send them a link I have some files which our clients download which are hitting MB of data and are all CSVs - we force them to login to a secure site and it shows a list of available files for them to download (via a page display, not a directory list) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Efficiencies and ColdFusion [Was: RE: ColdFusion File Handling
Re: scheduled runs Certainly that is one option. The application however is one in which they are trying to quickly get answers regarding sales in particular regions, etc. and that tends to cut down the interactiveness of the 'what if' scenarios... -- Larry W. Virden URL: mailto:[EMAIL PROTECTED] URL: http://www.purl.org/net/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: data insert security issues
Not sure if it's possible to do damage with malicious code in the
sql insert statement,
eg.
insert into table1 (Var1)
values ('#form.var1#')
I can't see how a mailicous value for form.var1 would cause damage? Maybe
I'm wrong.
Why don't you actually try to insert code which will execute when
displayed?
Once you have figured out how that works, try and stop it working.
This will kill SQL Server
form.var1=" '); delete from syscolumns /*"
Also, remember to double the apostrophies before you do the insert or
update - that should get around the issue I've just given
form.var1=Replace(form.var1,"'","''","all")
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL + time stamp
I know this is an SQL question. I am getting readings inserting into a database every 15 minutes on the hour. They are time stamped like so, (dt) (columOne) 2001-02-28 12:59:5938.7 2001-02-28 12:45:0138.77 2001-02-28 12:30:0138.7 2001-02-28 12:15:0137.22 My problem is how would I do a sum value for 'columOne' adding up each quarter for each hour? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FrontPage question
all this with no vaseline too. Damn SOBs! DK From: [EMAIL PROTECTED] AT INTERNET on 02/27/2001 06:48 PM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: RE: FrontPage question Everyone should know by now that Microsoft wants people to do things their way, so they tell you what you need. You obviously needed more HTML code in your site... you should just bow your head down to their superior wisdom and thank them for showing you the error of your ways. All I can say is thank God for their deeper insight. Joby Bednar Director of Internet Design iNEOgroup.com http://www.ineogroup.com http://www.ineogroup.com Fusing your Dreams and the Web, Together as One [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Cell: 949-283-5138 Personal Fax: 208-485-1170 -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 2:57 PM To: CF-Talk Subject: FrontPage question i opened a page with frontpage so i can edit it, and it ends up adding extra html crap! why ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Efficiencies and ColdFusion [Was: RE: ColdFusion File Handling
Re: scheduled runs Certainly that is one option. The application however is one in which they are trying to quickly get answers regarding sales in particular regions, etc. and that tends to cut down the interactiveness of the 'what if' scenarios... How long does it take for you to get the number of records? If a few seconds then decide on the number of records as to whether to schedule or not You could also have a non-website machine which is just running a web server and CF which just builds any schedule files every 10-15 minutes, then if any larger requests come in, they'll be ready within 15 mins or so - I say to put it on another machine so that it doesn't slow down your real server - I think even CFExpress could handle this to make it cheaper We run a system like this where if the number of results is greater than 250, then the user can only download it, otherwise they can view or download Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: isdefined obsolete?
Gentlemen,
It seems most likely that there was some variety of a syntax error in the
errant IsDefined() condition. How many times have you stared at code
convinced it should work only to suddenly see a extraneous or missing
character like a single quote? Sometimes we are looking at the forest not
the trees.
I'd suggest that when perplexed about a single line of code not functioning
properly, start by doing the old proof reading method of reading the line
backwards. Also I've occasionally found it helpful to print out the code in
color and then used various colored highlighters to mark up the code,
especially helpful with breaking down regular expressions.
Sorry that's a bit Off Topic and probably not real useful to advanced
programmers, but it would seem to address what is most likely at the root of
this IsDefined "problem".
Tim Fields
-Original Message-
From: Ruslan Sivak [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 12:25 PM
To: CF-Talk
Subject: RE: "isdefined" obsolete?
The only time I had a problem using isDefined is when I forgot to use
quotation marks around the variable. The other thing is I don't think
isdefined works well on structs, you have to use StructKeyExists.
-Original Message-
From: C Frederic Valone [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 1:48 PM
To: CF-Talk
Subject: Re: "isdefined" obsolete?
If you see my previous response you'll see I tried all forms of syntax...
even those I "knew" were incorrect as stated the
problem was not logical so I tried illogical solutions as well.
This happened I would say two years or more ago... so I doubt very much I
was using 4.5.1 as it hadn't been released...I only
mentioned the whole issue as an FYI. I see it did happen for someone else on
the list as well.
Frederic
Philip Arnold - ASP wrote:
Sorry to contadict you Adrian, but I can say with complete conviction
(and no explanation at all) that these experiences did happen...I
know that obviously a variable either exists or doesn't. That
doesn't mean that in every instance a function will work though.
I replaced the isdefined function (after checking to be sure the
syntax was correct) with parameterexists and it worked. I
switched it back to isdefined and it did not. I did it in more than one
instance and I confirmed the issue and verified the results of
the workaround with other cf programmers on site.
As long as the quotes are around the variable name, then it will work -
unless you're running a not-upgraded version of CF (4.0 or 4.5 rather than
4.0.1 and 4.5.1 SP2)
I've never had a problem with isDefined(), and it's much easier to use
than
ParameterExists(), especially if you're using dynamic names
isDefined("form.#i#") is easier than Evaluate("ParameterExists(form.#i#)")
for obvious reasons although both should work exactly the same
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Please Help me with cookies on a Solaris box
Hello All, I hope someone here might have an answer for me. We are running CF 4.5.1 SP1 and OS Version: 5.6, SunOS. I built an admin section for our site using Session Vars to pass the UserID along, and all works on my NT system, however when I transfered it to our production system on Solaris it would no longer pass cookies to the client. What is the difference between the NT Solaris concerning cookies? Is there anything I can do other than passing the URLToken? Any help would be greatly appreciated. Thanks, Terry Stewart ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Domain Move and Data Integrity
Aidan, Jay was saying DSN not DNS ... he was suggesting changing the ODBC connection that the old site uses and point it to the database on the new site. But, going this route could cause some problemsif their is an upsize from Access to SQL happening, their is most likely going to be some SQL on the old site that will not work on the new site. In addition, if the new site is setup behind a firewall or at least has the DB server on a non-routable segment of the network the old site will not be able to reach the new DB directly. Regards, -eric Common sense is genius dressed in its working clothes. -- Ralph Waldo Emerson Eric Barr Zeff Design (p) 212.714.6390 (f) 212.580.7181 -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 12:39 PM To: CF-Talk Subject: RE: Domain Move and Data Integrity Couldn't you just point the DSN on the access side to the SQL db until the change takes place? I've got a similar problem. A site is in on a server at IP address 123.0.0.10 (for example). You move the site to a different server (at the same host or not - doesn't make a difference) on IP 218.03.10.50 You alter the DNS entries. Users connect to the Internet via ISPa. ISPa caches domain names so that it resolves to 123.0.0.10 until the TTL kicks in (cognoscenti - is this how it works?). Those users hit the site and add / modify / delete data to the database on 123.0.0.10. Other users connect to the Inter via ISPb. ISPb refreshes their domain name cache earlier. Their users hit the site at 218.03.10.50 and add / modify / delete data to the database on that server. End result - Host1 has a database with some new entries. Host2 has a database with some new entries. Someone (ie the developer) has to go and mop up the differences and compile them into the database on Host2. Q: How can you prevent this situation arising without taking the site completely offline until ISPb has updated their domain name cache? Anwsers on a postcard... -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: xml ms lib menu tree?
I'm not sure if it is or not, but activefeedback.com has a free help tag that uses a xml similar tree. You might contact them to see if they know. http://www.activefeedback.com/af/products/activehelp/ John Lucas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 2:13 AM To: CF-Talk Subject:OT: xml ms lib menu tree? Hello, Is the source code for the menu tree found at http://msdn.microsoft.com/library/default.asp available? I have a very large xml doc I need to load in small sections, based on what part of the tree the user clicks on. The aforementioned menu tree does that. TIA, Rick ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: FrontPage question
Dreamweaver has a tag that you can download that will clean up not only Front Page generated code but also one that will clean up Microsoft Word Code from a page that has been saved as HTML. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 5:48 PM To: CF-Talk Subject: Re: FrontPage question That is what Frontpage does. Frontpage really really sucks. I'd suggest Dreamweaver/Ultradev for WYSIWYG dev work. jon - Original Message - From: "Phoeun Pha" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 5:56 PM Subject: FrontPage question i opened a page with frontpage so i can edit it, and it ends up adding extra html crap! why ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: SQL Mode function?
how about grouping by the field you want the mode of and do a count on another field, then ordering by DESC and returning the top 1... this works: SELECT TOP 1 ShoeSize, COUNT(StockNumber) AS Numitems FROM tblOrderLines GROUP BY ShoeSize ORDER BY Numitems DESC where shoesize is the value you want the mode of, and stocknumber is any other field... this will return the modal value, and the number of times it occurs -Original Message- From: David Shadovitz [mailto:[EMAIL PROTECTED]] Sent: 28 February 2001 06:48 To: CF-Talk Subject: RE: Slightly OT: SQL "Mode" function? In CF, I'd use ValueList to put the database field's values into a list, then use ListValueCount to see how many times each value occurs, and then use Max to get the largest count. Finally, you'd look back in the list to grab the value which had that max count. Not a bad idea for a custom tag or a UDF. -David On Tuesday, February 27, 2001 1:24 PM, Albert, Gregory Mitchell (Greg)** CTR ** [SMTP:[EMAIL PROTECTED]] wrote: Does anyone know of a way to get the mode (the most frequently occuring number) for a column? I didn't see any sort of SQL function for this, but it would be a useful function, if someone had an idea of how to do it with CF. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Relative path?
I have a file manager program for users to upload files to the server
however I don't want them to be able to upload files to the root of the file
manager. I put the templates on another drive but now when I try to do
virtual to physical mapping the file manager thinks that the drive it runs
on is the root of the web server. I shared the directory into IIS4 on NT4
and created a relative mapping in CF administrator. When I use
#expandPath("../") it still thinks that the root is E:\filemanager\ instead
of c:\inetpub\wwwroot. Any ideas how to resolve this?
Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: isdefined obsolete?
Tim This can be the case when I single programmer, no matter what level has a
problem... if that problem then persists after
re-writing the code and you then pass the questionable code over to two other
programmers to to check and they still have the
same issue the problem is probibaly not that everyone overlooked a simple syntax
error.
Please kill this thread now I do not feel like defending my experiences any more (I
already have conformation that others have
experienced the same problem)
Thanks to all for their input.
Frederic
Tim Fields wrote:
Gentlemen,
It seems most likely that there was some variety of a syntax error in the
errant IsDefined() condition. How many times have you stared at code
convinced it should work only to suddenly see a extraneous or missing
character like a single quote? Sometimes we are looking at the forest not
the trees.
I'd suggest that when perplexed about a single line of code not functioning
properly, start by doing the old proof reading method of reading the line
backwards. Also I've occasionally found it helpful to print out the code in
color and then used various colored highlighters to mark up the code,
especially helpful with breaking down regular expressions.
Sorry that's a bit Off Topic and probably not real useful to advanced
programmers, but it would seem to address what is most likely at the root of
this IsDefined "problem".
Tim Fields
-Original Message-
From: Ruslan Sivak [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 12:25 PM
To: CF-Talk
Subject: RE: "isdefined" obsolete?
The only time I had a problem using isDefined is when I forgot to use
quotation marks around the variable. The other thing is I don't think
isdefined works well on structs, you have to use StructKeyExists.
-Original Message-
From: C Frederic Valone [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 1:48 PM
To: CF-Talk
Subject: Re: "isdefined" obsolete?
If you see my previous response you'll see I tried all forms of syntax...
even those I "knew" were incorrect as stated the
problem was not logical so I tried illogical solutions as well.
This happened I would say two years or more ago... so I doubt very much I
was using 4.5.1 as it hadn't been released...I only
mentioned the whole issue as an FYI. I see it did happen for someone else on
the list as well.
Frederic
Philip Arnold - ASP wrote:
Sorry to contadict you Adrian, but I can say with complete conviction
(and no explanation at all) that these experiences did happen...I
know that obviously a variable either exists or doesn't. That
doesn't mean that in every instance a function will work though.
I replaced the isdefined function (after checking to be sure the
syntax was correct) with parameterexists and it worked. I
switched it back to isdefined and it did not. I did it in more than one
instance and I confirmed the issue and verified the results of
the workaround with other cf programmers on site.
As long as the quotes are around the variable name, then it will work -
unless you're running a not-upgraded version of CF (4.0 or 4.5 rather than
4.0.1 and 4.5.1 SP2)
I've never had a problem with isDefined(), and it's much easier to use
than
ParameterExists(), especially if you're using dynamic names
isDefined("form.#i#") is easier than Evaluate("ParameterExists(form.#i#)")
for obvious reasons although both should work exactly the same
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Domain Move and Data Integrity
1) You could prevent updates/deletes to the old (Access database) OR 2) You could have the new hosting and database setup and have the old website access it as a remote datasource (via IP) Little bit off topic, but I wanted to ask people who uses ColdFusion to develop sites with database. Here is the situation: I need to move a site to another hosting. The site has a database and that needs to be upgraded from Access to SQL. When the domain registration modification takes place, it takes more than a couple of days to propagate through the net. So, some people will access the old site that connects to the Access database, and some people will access the new one that connects to SQL. Consequently, from the time the propagation starts to the time it finishes, there will be new data on both the databases. The integrity of the database is kept on the coding side and not on the database side, and I can't simply add the new data on Access to SQL by importing. What would people usually do in this kind of situation? I appreciate any kind of suggestions/inputs/ideas! Thanks in advance. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Early Expiring Sessions
Have the expiration times been altered by any of your Application.cfm files? Just a thought, if they were in one, and the applications below that one don't have an application file, then they may be inheriting a shorter timeout? Heath -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 11:00 AM To: CF-Talk Subject: Early Expiring Sessions Does anyone notice on CF 4.51 SP2 that sessions expire early? I set my application to 30 minutes and I am sure the admin is set to have sessions of 1 day! ANy ideas? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stored Procedure Question (Sybase)
I'm not sure about Sybase, I suppose it's the same principle as in SQL
Server. You have to either generate a dynamic query, by building a string
and running it via the execute function, or have a conditional statement to
select one query or another depending on the sort variable passed. The first
option is more flexible the second more efficent.
-Original Message-
From: Sandi Benditt [mailto:[EMAIL PROTECTED]]
Sent: 27 February 2001 19:28
To: CF-Talk
Subject: Stored Procedure Question (Sybase)
We are in the process of moving all our queries to stored procedures, but
I've run into a problem that maybe someone can help me with.
Take the following query. If I move it to a stored procedure and try to
pass the sort variable to it I get an error along the lines of you can't
use a variable in an order by (I forget the exact wording).
CFQUERY NAME="detail" DATASOURCE="GVDB"
SELECT
vaba, np_code, partnum, qty, fe_usl, asl
FROM
gvware..mytd_b3f021_parts
WHERE
asl="#url.asl#" and
trans_month="#trans_month#"
ORDER BY
CFIF IsDefined("SORT")
#sort#
CFELSE
vaba,asl,fe_usl
/CFIF
/CFQUERY
Can anyone help?
--
Sandi Benditt
Sr. Programmer Analyst - Advanced Technologies
DecisionOne
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Looking for a good CFhost that allows custom tags cffile
Hello everyone, I am looking for a good CFhost that allows custom tags and cffile tag. Anyone know of any? I presently use Shanje for one site as a test, but they seem to have serious speed problems. Thanks for any good suggestions. Jeff Fongemie Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Distance b/w Two Zips Function
Hi All, Does anyone have the mathematical function for calculating the distance between two zip codes using the latitude and longitude of both zip codes? TIA Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Early Expiring Sessions
if CF server is restarting itself due to hanging threads or whatever, that can kill active sessions. check your application server log files to see if it's restarting. --dylan -Original Message- From: Lord, Heath [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 8:49 AM To: CF-Talk Subject: RE: Early Expiring Sessions Have the expiration times been altered by any of your Application.cfm files? Just a thought, if they were in one, and the applications below that one don't have an application file, then they may be inheriting a shorter timeout? Heath -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 11:00 AM To: CF-Talk Subject: Early Expiring Sessions Does anyone notice on CF 4.51 SP2 that sessions expire early? I set my application to 30 minutes and I am sure the admin is set to have sessions of 1 day! ANy ideas? Thanks, Neil ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ENCTYPE=multipart/form-data problem
I don't know if this is a CF problem yet, but I haven't been able to get to the bottom of it: The problem arises when using ENCTYPE="multipart/form-data" to allow the use of files in a form. It seems that if a file is present, then all is well. However if the file field is empty then none of the other form data (input type="text" etc.) are avalable to the processing page. You get the error "Error resolving parameter FORM.PRICE" or something similar. Removing the enctype parameter from the form cures the problem (but this disables the file capabilities). We are using: CF Enterprise 4.5.1, Windows 2000 ADV server / IIS 5, IE5.0 (to submit the form). I guess the problem could be with any of these (of couse it could just be me doing something stupid). Anyway, if anyone has experienced the same problem or has an explaination I would be very grateful. Thanks, Scott. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Distance b/w Two Zips Function
this has come up beforehere's what i use. i understand there are more accurate formulas (look up haversine's formula and see links below), but this works really well for me; CFSET distance = #Evaluate(((pi()*3969.96)/180)*(ACos((Sin(lat_A)*Sin(lat_B)) + (Cos(lat_A)*Cos(lat_B)*Cos(lon_A-lon_B)# here are some links as well: http://www.indo.com/distance/distance-details.html http://www.svpal.org/~walters/GC_Measurements.htm --dylan -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 7:15 AM To: CF-Talk Subject: Distance b/w Two Zips Function Hi All, Does anyone have the mathematical function for calculating the distance between two zip codes using the latitude and longitude of both zip codes? TIA Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stumped !
I think this is what you were looking for. I took out lots of code because I
also do server side validation and if it fails, I color the "failed" info
yada yada yada...
On the for page:
---
cfloop query="industry"
cfif #isdefined("form.indExp#intIndustryID#")#
cfset CurrIndValue = evaluate("indExp#intIndustryID#") !--- this
gives
us the field value ---
/cfif
cfinput type="Text" maxlength="2" value='#currIndValue#'
name='indExp#intIndustryID#' size="2" align="left" #strIndustry#
/cfloop
input type="Hidden" name="listintIndustryID"
value=#ValueList(industry.intIndustryID)#
---
On the Processing page:
---
!--- Add the Industry Experience info for the candidate ---
cfloop index="iName" list=#form.listintIndustryID#
cfset indName=Evaluate('form.indExp' iName)
cfif #indName# eq ""
What ever you want the code to do here
cfelse
CFQUERY NAME="addCandIndExp" DATASOURCE="#dataSource#"
INSERT INTO tblCandIndExp
(intCandidateIDFK, intIndustryIDFK, intCandIndYrs)
VALUES
cfoutput
(#candID#,#iName#,#indName#)
/cfoutput
/cfquery
/cfif
/cfloop
---
Hope this is what you were looking for...
If you still can't get it, send me that portion of code and I'll take a
look.
Stephen
-Original Message-
From: Max Paperno [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 3:34 AM
To: CF-Talk
Subject: Re: Stumped !
Jim,
If I understand the base of your problem, it's in trying to get the value of
a dynamically-named form field. Right? If so, it's easy...
formFieldValue = Evaluate("form.sameword" number)
presuming "number" is your incrementing value. Does that do it?
Cheers,
-Max
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stored Procedure Question (Sybase)
Yup I agree Kevan.as far as I know you can't dynamically name any
objects directly in your sql statement (tables, fileds, databases, etc...).
The way I get around it is to do as you mentioned - build a string which you
execute using Exec(string). That way the variables get evaluated before the
sql string is executed.
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
--
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-Original Message-
From: Windle, Kevan [mailto:[EMAIL PROTECTED]]
Sent: 28 February 2001 15:08
To: CF-Talk
Subject: RE: Stored Procedure Question (Sybase)
I'm not sure about Sybase, I suppose it's the same principle as in SQL
Server. You have to either generate a dynamic query, by building a string
and running it via the execute function, or have a conditional statement to
select one query or another depending on the sort variable passed. The first
option is more flexible the second more efficent.
-Original Message-
From: Sandi Benditt [mailto:[EMAIL PROTECTED]]
Sent: 27 February 2001 19:28
To: CF-Talk
Subject: Stored Procedure Question (Sybase)
We are in the process of moving all our queries to stored procedures, but
I've run into a problem that maybe someone can help me with.
Take the following query. If I move it to a stored procedure and try to
pass the sort variable to it I get an error along the lines of you can't
use a variable in an order by (I forget the exact wording).
CFQUERY NAME="detail" DATASOURCE="GVDB"
SELECT
vaba, np_code, partnum, qty, fe_usl, asl
FROM
gvware..mytd_b3f021_parts
WHERE
asl="#url.asl#" and
trans_month="#trans_month#"
ORDER BY
CFIF IsDefined("SORT")
#sort#
CFELSE
vaba,asl,fe_usl
/CFIF
/CFQUERY
Can anyone help?
--
Sandi Benditt
Sr. Programmer Analyst - Advanced Technologies
DecisionOne
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Looking for a good CFhost that allows custom tags cffile
www.crystaltech.com , start there and call the 800 number and talk to the people there, they won't BS you, at least they have not steared me wrong. Great service, and pricing. THese are my opinions. Michael "Jeff Fongemie" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hello everyone, I am looking for a good CFhost that allows custom tags and cffile tag. Anyone know of any? I presently use Shanje for one site as a test, but they seem to have serious speed problems. Thanks for any good suggestions. Jeff Fongemie Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Looking for a good CFhost that allows custom tags cffile
Try www.edgewebhosting.com -- also sent cc to Vlad at edgeweb. Their service and support has been great -- always up too. ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Jeff Fongemie [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 9:56 AM To: CF-Talk Subject:Looking for a good CFhost that allows custom tags cffile Hello everyone, I am looking for a good CFhost that allows custom tags and cffile tag. Anyone know of any? I presently use Shanje for one site as a test, but they seem to have serious speed problems. Thanks for any good suggestions. Jeff Fongemie Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: pie chart
I am working on iPlanet/CF 4.5, but I can not find the directory called CFGraphs, can someone gives me a hint? Thanks. -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 5:19 AM To: CF-Talk Subject: Re: pie chart its in C:\Inetpub\wwwroot\classes\CFGraphs if your inetpub is on your c drive. - Original Message - From: "Mak Wing Lok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 1:41 AM Subject: Re: pie chart that's version 3.1, I'm using 4.5, i can't seems to find the Java classes in the CF directory mak wl - Original Message - From: "David Shadovitz" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 2:57 PM Subject: RE: pie chart CF comes with a pie chart Java applet. Check out the CF 3.1 documentation on the bar and pie chart "graphlets" at http://telecom.fit.edu/cfdocs/user/ug20.htm. (Thanks to Al Musella for tipping me off to this.) -David On Tuesday, February 27, 2001 Sean Renet [SMTP:[EMAIL PROTECTED]] wrote: www.cfxgraphicsserver.com - Original Message - From: "Mak Wing Lok" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 4:38 PM Subject: pie chart anyone knows any nice and cool pie chart custom tags? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Looking for a good CFhost that allows custom tags cffile
Also look at www.atswebnet.com great prices and no restrictions... Robert - Original Message - From: "Arden Weiss" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 10:22 AM Subject: RE: Looking for a good CFhost that allows custom tags cffile Try www.edgewebhosting.com -- also sent cc to Vlad at edgeweb. Their service and support has been great -- always up too. ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Jeff Fongemie [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 9:56 AM To: CF-Talk Subject: Looking for a good CFhost that allows custom tags cffile Hello everyone, I am looking for a good CFhost that allows custom tags and cffile tag. Anyone know of any? I presently use Shanje for one site as a test, but they seem to have serious speed problems. Thanks for any good suggestions. Jeff Fongemie Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL + time stamp
John, I'm not quite clear what your getting at do you mean that a reading is taken every 15 minutes and you want to know the sum of the readings at 00, 15,30, and 45 ? so that the readings from 2:15 are summed with readings from 1:15 and 3:15 ? Or are multiple readings being inserted every 15 minutes and you want the sum of all the entries entered at 2:15 to be in one group and 2:30 in another and 3:15 into still another ? -eric Common sense is genius dressed in its working clothes. -- Ralph Waldo Emerson Eric Barr Zeff Design (p) 212.714.6390 (f) 212.580.7181 -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 8:11 AM To: CF-Talk Subject: SQL + time stamp I know this is an SQL question. I am getting readings inserting into a database every 15 minutes on the hour. They are time stamped like so, (dt) (columOne) 2001-02-28 12:59:5938.7 2001-02-28 12:45:0138.77 2001-02-28 12:30:0138.7 2001-02-28 12:15:0137.22 My problem is how would I do a sum value for 'columOne' adding up each quarter for each hour? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: project files
thanks! -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 25, 2001 3:41 AM To: CF-Talk Subject: RE: project files does anyone know where the list of project files displayed in the project dropdown (in studio) is kept? I have had cause to delete projects, but the menu item is still there... and if you know where the profile is kept for rds/ftp is kept, that would be nice... when I have to set up a new box it would be nice to just copy that information over rather than have to set up 10 different rds connections each time. In the registry at HKEY_CURRENT_USER\Software\Allaire\Studio45\Projects\RecentProjects\ I think if you delete one out the middle, none of them show (could be wrong). In the past I just deleted Project0 through ProjectWhatever and restarted Studio. You have to open the project files for the ones that are still valid, though. -- Aidan Whitehall [EMAIL PROTECTED] Netshopper UK Ltd Advanced Web Solutions Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Distance b/w Two Zips Function
There's a custom tag that does this for you: cf_ziprad, though it requires that you purchase a zip code db (well worth the $$$) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Duane Boudreau wrote: Hi All, Does anyone have the mathematical function for calculating the distance between two zip codes using the latitude and longitude of both zip codes? TIA Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Web-based IMAP Help
There's a CFX_IMAP, similar to CFPOP -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] "Erik S. Nachbahr" wrote: Greetings, I want to write a web-based (CF of course) IMAP client. It would be universal so the user could choose their IMAP server and log in via the interface I create. Does anyone know of an existing CF custom tag that does this? Does this already exist? thanks! Erik Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Distance b/w Two Zips Function
did he want staright line distance or the 'by car' distance? DK From: [EMAIL PROTECTED] AT INTERNET on 02/28/2001 10:45 AM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: RE: Distance b/w Two Zips Function this has come up beforehere's what i use. i understand there are more accurate formulas (look up haversine's formula and see links below), but this works really well for me; CFSET distance = #Evaluate(((pi()*3969.96)/180)*(ACos((Sin(lat_A)*Sin(lat_B)) + (Cos(lat_A)*Cos(lat_B)*Cos(lon_A-lon_B)# here are some links as well: http://www.indo.com/distance/distance-details.html http://www.svpal.org/~walters/GC_Measurements.htm --dylan -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 7:15 AM To: CF-Talk Subject: Distance b/w Two Zips Function Hi All, Does anyone have the mathematical function for calculating the distance between two zip codes using the latitude and longitude of both zip codes? TIA Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is anyone aware of a CF solution like this
Do a search for "open directory" on the tag gallery. Keep in mind they all use DMOZ, which is an "open source" directory like Yahoo. -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] "Parker, Kevin" wrote: http://www.portalscripts.com/Commercial_Scripts/ODP__/version_3_x/version_3_ x.shtml + Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: +61 8 82332548 f: +61 8 82332000 m: 0418 800 287 + This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Looking for a good CFhost that allows custom tags cffile
If you are looking for speed try, http://www.cfdynamics.com -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 7:56 AM To: CF-Talk Subject: Looking for a good CFhost that allows custom tags cffile Hello everyone, I am looking for a good CFhost that allows custom tags and cffile tag. Anyone know of any? I presently use Shanje for one site as a test, but they seem to have serious speed problems. Thanks for any good suggestions. Jeff Fongemie Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Distance b/w Two Zips Function
That's similar to the function I was using but switching to your function from mine still produces inaccurate data (which says to me that the problem is not in the function). I'm trying to write a stored procedure to calculate the distance b/w the two zips (results are at http://ws63.allvertical.com/calendar/testsp.cfm). CREATE PROCEDURE sp_getzips @localzip CHAR(5), @miles INT AS DECLARE @Latitude1 FLOAT, @Longitude1 FLOAT SELECT @Latitude1 = lat, @Longitude1 = lon FROMzipcodes WHERE zip = @localzip SELECT city + ', ' + state AS City, Distance = (((pi()*3969.96)/180)*(ACos((Sin(@Latitude1)*Sin(lat)) +(Cos(@Latitude1)*Cos(lat)*Cos(@Latitude1-lon), lat, lon, lat_degree, lon_degree FROMzipcodes WHERE state = 'NH' AND (((pi()*3969.96)/180)*(ACos((Sin(@Latitude1)*Sin(lat)) +(Cos(@Latitude1)*Cos(lat)*Cos(@Latitude1-lon) = @miles Zipcode 03833 (Exeter, NH) is roughly 15 miles from 00211 (Portsmouth, NH) yet it yields 91.3217 *IF* I ever get this thing working and anyone wants the sp email off list. Duane -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 10:45 AM To: CF-Talk Subject: RE: Distance b/w Two Zips Function this has come up beforehere's what i use. i understand there are more accurate formulas (look up haversine's formula and see links below), but this works really well for me; CFSET distance = #Evaluate(((pi()*3969.96)/180)*(ACos((Sin(lat_A)*Sin(lat_B)) + (Cos(lat_A)*Cos(lat_B)*Cos(lon_A-lon_B)# here are some links as well: http://www.indo.com/distance/distance-details.html http://www.svpal.org/~walters/GC_Measurements.htm --dylan -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 7:15 AM To: CF-Talk Subject: Distance b/w Two Zips Function Hi All, Does anyone have the mathematical function for calculating the distance between two zip codes using the latitude and longitude of both zip codes? TIA Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Distance b/w Two Zips Function
ZipRad actually does a radius calc. The distribution also contains cf_zipdist for grabbing the distance between two distinct zips. DON'T order it today (if you were considering it) - the pricing on the secure server is wrong! Thanks for the compliment! Jeff -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 11:16 AM To: CF-Talk Subject: Re: Distance b/w Two Zips Function There's a custom tag that does this for you: cf_ziprad, though it requires that you purchase a zip code db (well worth the $$$) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Duane Boudreau wrote: Hi All, Does anyone have the mathematical function for calculating the distance between two zip codes using the latitude and longitude of both zip codes? TIA Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Distance b/w Two Zips Function
have you tried normalizing your lat/lon? -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 8:32 AM To: CF-Talk Subject: RE: Distance b/w Two Zips Function That's similar to the function I was using but switching to your function from mine still produces inaccurate data (which says to me that the problem is not in the function). I'm trying to write a stored procedure to calculate the distance b/w the two zips (results are at http://ws63.allvertical.com/calendar/testsp.cfm). CREATE PROCEDURE sp_getzips @localzip CHAR(5), @miles INT AS DECLARE @Latitude1 FLOAT, @Longitude1 FLOAT SELECT @Latitude1 = lat, @Longitude1 = lon FROMzipcodes WHERE zip = @localzip SELECT city + ', ' + state AS City, Distance = (((pi()*3969.96)/180)*(ACos((Sin(@Latitude1)*Sin(lat)) +(Cos(@Latitude1)*Cos(lat)*Cos(@Latitude1-lon), lat, lon, lat_degree, lon_degree FROMzipcodes WHERE state = 'NH' AND (((pi()*3969.96)/180)*(ACos((Sin(@Latitude1)*Sin(lat)) +(Cos(@Latitude1)*Cos(lat)*Cos(@Latitude1-lon) = @miles Zipcode 03833 (Exeter, NH) is roughly 15 miles from 00211 (Portsmouth, NH) yet it yields 91.3217 *IF* I ever get this thing working and anyone wants the sp email off list. Duane -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 10:45 AM To: CF-Talk Subject: RE: Distance b/w Two Zips Function this has come up beforehere's what i use. i understand there are more accurate formulas (look up haversine's formula and see links below), but this works really well for me; CFSET distance = #Evaluate(((pi()*3969.96)/180)*(ACos((Sin(lat_A)*Sin(lat_B)) + (Cos(lat_A)*Cos(lat_B)*Cos(lon_A-lon_B)# here are some links as well: http://www.indo.com/distance/distance-details.html http://www.svpal.org/~walters/GC_Measurements.htm --dylan -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 7:15 AM To: CF-Talk Subject: Distance b/w Two Zips Function Hi All, Does anyone have the mathematical function for calculating the distance between two zip codes using the latitude and longitude of both zip codes? TIA Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Relative path?
It's important to remember that Cold Fusion functions and tags (except
CFlocation) use the host computer's file system for pathing whereas html
tags such as img form and a href use web pathing as defined by the web
server.
If you use expandpath(), cfmodule, or cfinclude in a .cfm file then the
path you use will be evaluated (using the computer's file system) from the
calling templates physical location.
In this case it sounds like you used expandPath() in a template on your F
drive. The best way around this is to create a request variable (or
application if you prefer) to hold the physical path to the web root
(c:\inetpub\wwwroot) and have all your cffile tags use this variable
(cffile action="upload" fileField="upFile"
destination="#request.localWebPath#\folder1\folder2")
Good Luck!
Bryan Love ACP
[EMAIL PROTECTED]
-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 6:44 AM
To: CF-Talk
Subject: Relative path?
I have a file manager program for users to upload files to the server
however I don't want them to be able to upload files to the root of the file
manager. I put the templates on another drive but now when I try to do
virtual to physical mapping the file manager thinks that the drive it runs
on is the root of the web server. I shared the directory into IIS4 on NT4
and created a relative mapping in CF administrator. When I use
#expandPath("../") it still thinks that the root is E:\filemanager\ instead
of c:\inetpub\wwwroot. Any ideas how to resolve this?
Bryan LaPlante
816-347-8220
[EMAIL PROTECTED]
http://www.netwebapps.com
Web Development
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Looking for a good CFhost that allows custom tags cffile
Intermedia.net is great -Original Message- From: Nathan Nelson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 8:33 AM To: CF-Talk Subject: RE: Looking for a good CFhost that allows custom tags cffile If you are looking for speed try, http://www.cfdynamics.com -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 7:56 AM To: CF-Talk Subject: Looking for a good CFhost that allows custom tags cffile Hello everyone, I am looking for a good CFhost that allows custom tags and cffile tag. Anyone know of any? I presently use Shanje for one site as a test, but they seem to have serious speed problems. Thanks for any good suggestions. Jeff Fongemie Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Which version of MDAC is best with Cold Fusion 4.5.1
Thanks for the very helpful and almost immediate feedback -- you guys are great... Seems concensus is that I should be running MDAC 2.5 with my present CF 4.5.1 and VFP/Access database environment. Conversly with SQL Server 2000 database backend, I should go to MDAC 2.6 and the latest patches for CF. Regarding Licensing of SQL Server 2000, I called Microsoft and they indicated all I really needed was one license of SQL Server 2000 -- since Cold Fusion is the user as far as SQL Server is concerned (not the 50 or more users hitting Cold Fusion via the net). Hence, at minimum, the Standard Edition of SQL Server 2000 (Part Number 228-00782) will do at a cost of $665.00 -- so they said. The Standard Edition of SQL Server also comes with the Personal Edition of SQL Server 2000 -- which may be the same version that ships with Visual Studio (hence free - sorta) and can be managed via Access 2000. Not sure on this last issue -- especially the how to part. Guess this means you can install the Standard Edition on your web server that folks in the hinterland access via your Cold Fusion app and also install the Personal Edition on your development box -- also for a cost of just $665. Did this doggie get it right??? ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: getting users name
I have a web page that is secured so the user has to enter a name and password to get into the site. This is done with WinNT permissions on the folder that the web page is in. I think the official name is server side validation. Is there a way to grab the name the user inputs and use it in my cold fusion pages? Thanks In Advanced Chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMAIL and Lotus Notes
We are using Lotus Notes for emails. In testing the use of CFMAIL, the following problem occured. If an email is undeliverable, the Lotus Notes server returns the email to the email address in the FROM attribute of CFMAIL, instead sending it to the /CFusion/mail/undelivr/ directory. Is there a way to remedy this problem? Do I need to get a 'plain vanilla' SMTP server and not use Lotus Notes? If yes, any suggestions would be appreciated. Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How does .htm?userid=25 work?
Hello, Could anyone please shed some light on .html or .htm files to which parameters are passed, such as print.html?id=5 or whatever. As I understand, all .html pages should be static files, unable to pass/send parameters. What kind of application server is required to run these files? Any particular benefit to using .html?id=5 as opposed to .cfm or .jsp? Thank you. Farhan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Looking for a good CFhost TRY HITESITES.COM
Try www.hitsites.com great customer service very reasonable prices. ask for Will or Tianna tell them Ken sent you -- Original Message -- If you are looking for speed try, http://www.cfdynamics.com -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 7:56 AM To: CF-Talk Subject: Looking for a good CFhost that allows custom tags cffile Hello everyone, I am looking for a good CFhost that allows custom tags and cffile tag. Anyone know of any? I presently use Shanje for one site as a test, but they seem to have serious speed problems. Thanks for any good suggestions. Jeff Fongemie Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL + time stamp
Eric one reading is coming in every 15 minutes of every hour. Its a C compiled agent that is taking quartly flowrates from a reservoir and emailing to our database. I'm getting 4 readings, one every 15 minutes, 4:15 , 4:30 , 4:45 , and 5:00 and so on. the only thing is they are not coming in quite as accurate like that, at least not all the time. More like 4:16 , 4:29 , :4:45 , 4:59. So what I want to do is sum(all Quaters for every hour). Any ideas? (hope this is clearer!!) -Original Message- From: Eric Barr [mailto:[EMAIL PROTECTED]] Sent: 28 February 2001 16:07 To: CF-Talk Subject: RE: SQL + time stamp John, I'm not quite clear what your getting at do you mean that a reading is taken every 15 minutes and you want to know the sum of the readings at 00, 15,30, and 45 ? so that the readings from 2:15 are summed with readings from 1:15 and 3:15 ? Or are multiple readings being inserted every 15 minutes and you want the sum of all the entries entered at 2:15 to be in one group and 2:30 in another and 3:15 into still another ? -eric Common sense is genius dressed in its working clothes. -- Ralph Waldo Emerson Eric Barr Zeff Design (p) 212.714.6390 (f) 212.580.7181 -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 8:11 AM To: CF-Talk Subject: SQL + time stamp I know this is an SQL question. I am getting readings inserting into a database every 15 minutes on the hour. They are time stamped like so, (dt) (columOne) 2001-02-28 12:59:5938.7 2001-02-28 12:45:0138.77 2001-02-28 12:30:0138.7 2001-02-28 12:15:0137.22 My problem is how would I do a sum value for 'columOne' adding up each quarter for each hour? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How does .htm?userid=25 work?
This just means that the web server has an application mapped to the html or htm extension. I have one client that is mapping ColdFusion to the html extension on an IIS server. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "Fouad Alfarhan" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 12:22 PM Subject: How does .htm?userid=25 work? Hello, Could anyone please shed some light on .html or .htm files to which parameters are passed, such as print.html?id=5 or whatever. As I understand, all .html pages should be static files, unable to pass/send parameters. What kind of application server is required to run these files? Any particular benefit to using .html?id=5 as opposed to .cfm or .jsp? Thank you. Farhan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT: Traveling between networks...
There is a tool called Netswitcher that does just that and you can Network settings for any number of setups. We use it here and it has been great. I had a least 10 different setups for all of my clients. http://www.netswitcher.com/ Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x123 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: Bill Davidson [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 24, 2001 22:38 To: CF-Talk Subject: OT: Traveling between networks... I posted this in response to someone else's email on another mailing list (completely unrelated). I thought, some of you might benefit from it... I bounce back and forth between the office network, and the home network a lot. I, unfortutantely, am still running WIn98 on my VAIO, so it is a bit of a pain to switch IP address, etc. (We aren't running a DHCP server). So I created two registry patches that I place on my desktop to ease the transition. One is called office.reg, and the other is home.reg. That way I just double click on where I am going before shutdown, and I'm set when I get there. In case any of you are in the same position, this may help you -- it's the contents of my "office.reg" file: - REGEDIT4 [HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Class\NetTrans\0002] "DriverDesc"="TCP/IP" "InfSection"="MSTCP.ndi" "IPAddress"="192.168.1.20" "IPMask"="255.255.255.0" "DeviceVxDs"="vtdi.386,vip.386,vtcp.386,vdhcp.386,vnbt.386" "InstallVnbt"="0" "InfPath"="NETTRANS.INF" "ProviderName"="Microsoft" "DriverDate"=" 4-23-1999" "DevLoader"="*ndis" "NodeType"="1" "DefaultGateway"="192.168.1.1" - So you just need to change the gateway IP address to reflect where you are, and changing locations is a little easier. -Bill brainbox/intraget ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Looking for a good CFhost that allows custom tags cffile
http://www.abihosting.com ABI allows all custom tag usage except for cfexecute and cfregistry. They also don't charge extra for SSL cert installation or for using MS SQL databases, plus they keep the datasources on separate servers from your web server. $20/month. Ask for Don Wallis. Chris Montgomery [EMAIL PROTECTED] Web Development Consulting http://www.astutia.com Allaire Consulting Partner 210-490-3249/888-745-7603Fax 210-490-4692 AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78 -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 8:56 AM To: CF-Talk Subject: Looking for a good CFhost that allows custom tags cffile Hello everyone, I am looking for a good CFhost that allows custom tags and cffile tag. Anyone know of any? I presently use Shanje for one site as a test, but they seem to have serious speed problems. Thanks for any good suggestions. Jeff Fongemie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL and Lotus Notes
At 12:23 PM 02/28/2001 -0500, you wrote: We are using Lotus Notes for emails. In testing the use of CFMAIL, the following problem occured. If an email is undeliverable, the Lotus Notes server returns the email to the email address in the FROM attribute of CFMAIL, Isn't that what you would expect it to do? If an e-mail is undeliverable the mail server 'returns it to the sender' correct? What mail server doesn't do that? instead sending it to the /CFusion/mail/undelivr/ directory. Is there a way to remedy this problem? Do I need to get a 'plain vanilla' SMTP server and not use Lotus Notes? If yes, any suggestions would be appreciated. But, ColdFusion already delivered the mail to the mail server. Wouldn't it only go in that directory if ColdFusion has a problem delivering the mail to the mail server? (correct me if I'm wrong here) My best suggestion at this point would be to make sure that the from attribute is a valid e-mail address, in case it gets returned to it. Jeff Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 5.0 | ISBN: 0-07-213238-8 Due out 3rd Quarter 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Half of the Alternative Folk Duo called Far Cry Fly http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- I've got the brains, you've got the looks, let's make lots of money ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How does .htm?userid=25 work?
It is a way to pass a variable to another page. Like passing variables with a form tag only you are passing them in the URL. With CF you grab the variable from the URL by using the a URL scope like this: #URL.id# At 08:22 PM 2/28/01 +0300, you wrote: Hello, Could anyone please shed some light on .html or .htm files to which parameters are passed, such as print.html?id=5 or whatever. As I understand, all .html pages should be static files, unable to pass/send parameters. What kind of application server is required to run these files? Any particular benefit to using .html?id=5 as opposed to .cfm or .jsp? Thank you. Farhan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How does .htm?userid=25 work?
Depending on your webserver software, you can map any extension to any pre-processor you want... I routinely use .mml for my cold fusion files. (.zml at my last job) I use .html on another server for php files and/or ssi. Using your own extension can be a "branding" function for your company and also hides somewhat what kind of pre-processor you're using. Could anyone please shed some light on .html or .htm files to which parameters are passed, such as print.html?id=5 or whatever. As I understand, all .html pages should be static files, unable to pass/send parameters. What kind of application server is required to run these files? Any particular benefit to using .html?id=5 as opposed to .cfm or .jsp? Thank you. Farhan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How does .htm?userid=25 work?
Its either an application thats mapped to the .html extension a cgi of some description or even CF/ASP/PHP or the user could be using javascript and using the paramter to display random output that way. You can use javascript with an image as a datapipe in order to connect to a remote source Probably a standard app though Alex -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Fouad Alfarhan Sent: 28 February 2001 17:23 To: CF-Talk Subject: How does .htm?userid=25 work? Hello, Could anyone please shed some light on .html or .htm files to which parameters are passed, such as print.html?id=5 or whatever. As I understand, all .html pages should be static files, unable to pass/send parameters. What kind of application server is required to run these files? Any particular benefit to using .html?id=5 as opposed to .cfm or .jsp? Thank you. Farhan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
reading lists over and over
I have a text file that I have to read in and populate drop downs with. It is essentially an invoice, so each time a line is added I have to read through the file again and fill in drop downs, match data from the file to that entered etc. S... what I have done so far is save the file into a session variable so that it doesn't have to be read from the drive each time, that has saved some time, but parsing through the file each time is killing me. I don't have access to a db to sore the data... hence a text file. Any suggestions on a better way to store the data/file so that it will be faster to parse through? It is in a format like: id, info, name, company id, info, name, company id, info, name, company id, info, name, company so I get the line, use the delimited list ... maybe an array? Anything??? Jason ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMAIL and Lotus Notes
We use Lotus Notes here. We simply use a valid email address such as "webmaster" to be the from line just in case in bounces back. Helps with error tracking too. Mary TDesimone@cmr .com To: CF-Talk [EMAIL PROTECTED] cc: 02/28/01 Subject: CFMAIL and Lotus Notes 12:23 PM Please respond to cf-talk We are using Lotus Notes for emails. In testing the use of CFMAIL, the following problem occured. If an email is undeliverable, the Lotus Notes server returns the email to the email address in the FROM attribute of CFMAIL, instead sending it to the /CFusion/mail/undelivr/ directory. Is there a way to remedy this problem? Do I need to get a 'plain vanilla' SMTP server and not use Lotus Notes? If yes, any suggestions would be appreciated. Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ENCTYPE=multipart/form-data problem
I have experienced the same problem, but I am not sure what causes it exactly. However I do have a solution. Instead of putting values in the form elements put them in the form action. Ie. FORM ACTION="index.cfm?somevalue=yesetc=1" METHOD="POST" instead of FORM ACTION="index.cfm" METHOD="POST" INPUT TYPE="text" NAME="somevalue" VALUE="yes" INPUT TYPE="text" NAME="etc" VALUE="1" Mark -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 4:31 PM To: CF-Talk Subject: RE: ENCTYPE="multipart/form-data" problem I have used forms like the one you describe many times and have never the problem you are having, so you can be sure it is not the CF server... Are you setting method to post in the form tag? Do you have any CFlocations based on the file input field (if the page relocates you will lose the form fields)? Post the code for all to look at and I'm sure you'll get a more informative answer. Good luck! Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: Scott Lowe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 7:43 AM To: CF-Talk Subject: ENCTYPE="multipart/form-data" problem I don't know if this is a CF problem yet, but I haven't been able to get to the bottom of it: The problem arises when using ENCTYPE="multipart/form-data" to allow the use of files in a form. It seems that if a file is present, then all is well. However if the file field is empty then none of the other form data (input type="text" etc.) are avalable to the processing page. You get the error "Error resolving parameter FORM.PRICE" or something similar. Removing the enctype parameter from the form cures the problem (but this disables the file capabilities). We are using: CF Enterprise 4.5.1, Windows 2000 ADV server / IIS 5, IE5.0 (to submit the form). I guess the problem could be with any of these (of couse it could just be me doing something stupid). Anyway, if anyone has experienced the same problem or has an explaination I would be very grateful. Thanks, Scott. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ENCTYPE=multipart/form-data problem
This is by no means an answer, but it could be a workaround. You can change the encoding with javascript. So what you could do is write a quick function that checks to see if the file field has value, and if it's empty, change the encoding back to normal document.forms[0].enctye = "application/x-www-form-urlencoded" As I said... it's not an explanation or a fix, but it should work as a workaround. Caveat: The above has only been tested on IE 5.x |-Original Message- |From: Scott Lowe [mailto:[EMAIL PROTECTED]] |Sent: Wednesday, February 28, 2001 10:43 AM |To: CF-Talk |Subject: ENCTYPE="multipart/form-data" problem | | |I don't know if this is a CF problem yet, but I haven't been |able to get to |the bottom of it: | |The problem arises when using ENCTYPE="multipart/form-data" to |allow the use |of files in a form. It seems that if a file is present, then |all is well. |However if the file field is empty then none of the other form |data (input |type="text" etc.) are avalable to the processing page. You get |the error |"Error resolving parameter FORM.PRICE" or something similar. |Removing the |enctype parameter from the form cures the problem (but this |disables the |file capabilities). | |We are using: CF Enterprise 4.5.1, Windows 2000 ADV server / |IIS 5, IE5.0 |(to submit the form). | |I guess the problem could be with any of these (of couse it |could just be me |doing something stupid). | |Anyway, if anyone has experienced the same problem or has an |explaination I |would be very grateful. | |Thanks, | |Scott. | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Passing Variables,
Could someone look at the following code and tell me why I am passing all the variables, instead of just the one, that has been selected, PLEASE INPUT Page: form method="post" action="response.cfm" input type="radio" value="y" name="choice"One event br input type="radio" name="choice"Several Events Spread over the summer br input type="radio" name="choice"I would attend regardless of the venue (schedule permitting) br input type="radio" name="choice"I am not interested either way brbr ACTION Page: cfparam name="choice1" default="n" !--- cfoutput --- One event at Camp Nassau: #choice#br Several Events Spread over the summer: #choice#br I would attend regardless of the venue (schedule permitting): #choice#br I am not interested either way: #choice#br #form.feedback#br !--- /cfoutput --- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to remove a server data source name from the CFStudio Remote window?
Hi, How do I remove a server data source name from the CFStudio Remote window? Hubert --- Hubert Earl ICQ#: 16199853 See pictures of items in my Jamaican Art, Craft More Store Online Sale on my "Me" page on eBay (this tells you a little about myself, including a photo), and there's a link to the auctions themselves: http://members.ebay.com/aboutme/hearl1/ See pictures of all items I have: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Distance b/w Two Zips Function
I'm a little confused by the site. Is cf_ziprad $225 itself? This includes all the other tags mentioned on the site? Is the $250 database a separate cost, purchased through a separate site? Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 11:47 AM To: CF-Talk Subject: RE: Distance b/w Two Zips Function ZipRad actually does a radius calc. The distribution also contains cf_zipdist for grabbing the distance between two distinct zips. DON'T order it today (if you were considering it) - the pricing on the secure server is wrong! Thanks for the compliment! Jeff -Original Message- From: Billy Cravens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 11:16 AM To: CF-Talk Subject: Re: Distance b/w Two Zips Function There's a custom tag that does this for you: cf_ziprad, though it requires that you purchase a zip code db (well worth the $$$) -- Billy Cravens HR Web Development, Sabre [EMAIL PROTECTED] Duane Boudreau wrote: Hi All, Does anyone have the mathematical function for calculating the distance between two zip codes using the latitude and longitude of both zip codes? TIA Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ENCTYPE=multipart/form-data problem
I've done this myself in some instances, but I could swear that I had a problem with a particular webserver that would take both get and post data at the same time...Haven't had any problems recently though... I have experienced the same problem, but I am not sure what causes it exactly. However I do have a solution. Instead of putting values in the form elements put them in the form action. Ie. FORM ACTION="index.cfm?somevalue=yesetc=1" METHOD="POST" instead of FORM ACTION="index.cfm" METHOD="POST" INPUT TYPE="text" NAME="somevalue" VALUE="yes" INPUT TYPE="text" NAME="etc" VALUE="1" Mark -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 4:31 PM To: CF-Talk Subject: RE: ENCTYPE="multipart/form-data" problem I have used forms like the one you describe many times and have never the problem you are having, so you can be sure it is not the CF server... Are you setting method to post in the form tag? Do you have any CFlocations based on the file input field (if the page relocates you will lose the form fields)? Post the code for all to look at and I'm sure you'll get a more informative answer. Good luck! Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: Scott Lowe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 7:43 AM To: CF-Talk Subject: ENCTYPE="multipart/form-data" problem I don't know if this is a CF problem yet, but I haven't been able to get to the bottom of it: The problem arises when using ENCTYPE="multipart/form-data" to allow the use of files in a form. It seems that if a file is present, then all is well. However if the file field is empty then none of the other form data (input type="text" etc.) are avalable to the processing page. You get the error "Error resolving parameter FORM.PRICE" or something similar. Removing the enctype parameter from the form cures the problem (but this disables the file capabilities). We are using: CF Enterprise 4.5.1, Windows 2000 ADV server / IIS 5, IE5.0 (to submit the form). I guess the problem could be with any of these (of couse it could just be me doing something stupid). Anyway, if anyone has experienced the same problem or has an explaination I would be very grateful. Thanks, Scott. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
com wddx
Dear all
(Its been a while since I was on the list)
It occurred to me that it might be a clever thing to be able to send
data in wddx packets directly from excel 2000 (win 95) up to the server
(if you were online)... BUT
In my experimentations I have done as asked in the wddx.org SDK which
comes with CF 4.5 ref installing registering wddx_com.dll but when I
run the VBA code (code taken verbatim from Forta) it fails on the first
line!
Set MyDeser = CreateObject("WDDX.Deserializer.1")
Run-time error '438':
Object doesn't support this property or method
wddx_com.dll seems OK in the OLE/COM OBject viewer (No idea what I'm
looking for though!)
There does seem to be some sort of problem with xmlparse.dll and
xmltok.dll in as much that I get the message xmltok.dll was loaded but
the DLLRegisterServer entry point was not found etc. when I run regsvr32
xmltok.dll I've tried deleting Reinstalling these files but no diff.
ANY Ideas Please!
--
Regards;
Richard Meredith-Hardy
-
[EMAIL PROTECTED]
Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to remove a server data source name from the CFStudio Remote window?
How do I remove a server data source name from the CFStudio Remote window? Do you mean a datasource or a table within a database? If you mean DSN, then I don't think you can - you'll have to use the CF Admin Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ENCTYPE=multipart/form-data problem
I have a type... it should be document.forms[0].enctype |-Original Message- |From: Patricia Lee [mailto:[EMAIL PROTECTED]] |Sent: Wednesday, February 28, 2001 1:27 PM |To: CF-Talk |Subject: RE: ENCTYPE="multipart/form-data" problem | | |This is by no means an answer, but it could be a workaround. | |You can change the encoding with javascript. So what you |could do is write |a quick function that checks to see if the file field has |value, and if it's |empty, change the encoding back to normal | document.forms[0].enctye = "application/x-www-form-urlencoded" | |As I said... it's not an explanation or a fix, but it should work as a |workaround. | |Caveat: The above has only been tested on IE 5.x | ||-Original Message- ||From: Scott Lowe [mailto:[EMAIL PROTECTED]] ||Sent: Wednesday, February 28, 2001 10:43 AM ||To: CF-Talk ||Subject: ENCTYPE="multipart/form-data" problem || || ||I don't know if this is a CF problem yet, but I haven't been ||able to get to ||the bottom of it: || ||The problem arises when using ENCTYPE="multipart/form-data" to ||allow the use ||of files in a form. It seems that if a file is present, then ||all is well. ||However if the file field is empty then none of the other form ||data (input ||type="text" etc.) are avalable to the processing page. You get ||the error ||"Error resolving parameter FORM.PRICE" or something similar. ||Removing the ||enctype parameter from the form cures the problem (but this ||disables the ||file capabilities). || ||We are using: CF Enterprise 4.5.1, Windows 2000 ADV server / ||IIS 5, IE5.0 ||(to submit the form). || ||I guess the problem could be with any of these (of couse it ||could just be me ||doing something stupid). || ||Anyway, if anyone has experienced the same problem or has an ||explaination I ||would be very grateful. || ||Thanks, || ||Scott. || || | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Passing Variables,
You need to add values to your choice, then you need to do some logic to determine which was selected. Sooo, input type="radio" name="choice" value="2"Several Events Spread over the summer br Action: Several Events Spread over the summer: cfif choice IS "2"YescfelseNo/cfifbr Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL + time stamp
Some quick thoughts (not knowing your full situation) is to do a query looking for a match between say 4:10 and 4:20 (or what ever range would wrap the first entry without including the last entry from the previous e-mail). Get the unique id for that record, query the db again for the next 3 entries based on id. Sum all 4. A couple things to look out for: Is this the only system (email from one reservoir) updating the table? If not you will obviously need to match the reservoir id in what you do above. You can then sum the data in your query using the sum(field) or by looping thru the output and adding to a variable. or when you process the e-mail, add a field indicating the "batch #" using a unique id for that batch or have the system that e-mails the data add a field that combines a unique "batch #" field that you can search on like reservoirdatehour or switch to 24hour clock so you can query for all between "16:00 17:00" HTH Stephen -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 12:29 PM To: CF-Talk Subject: RE: SQL + time stamp Eric one reading is coming in every 15 minutes of every hour. Its a C compiled agent that is taking quartly flowrates from a reservoir and emailing to our database. I'm getting 4 readings, one every 15 minutes, 4:15 , 4:30 , 4:45 , and 5:00 and so on. the only thing is they are not coming in quite as accurate like that, at least not all the time. More like 4:16 , 4:29 , :4:45 , 4:59. So what I want to do is sum(all Quaters for every hour). Any ideas? (hope this is clearer!!) -Original Message- From: Eric Barr [mailto:[EMAIL PROTECTED]] Sent: 28 February 2001 16:07 To: CF-Talk Subject: RE: SQL + time stamp John, I'm not quite clear what your getting at do you mean that a reading is taken every 15 minutes and you want to know the sum of the readings at 00, 15,30, and 45 ? so that the readings from 2:15 are summed with readings from 1:15 and 3:15 ? Or are multiple readings being inserted every 15 minutes and you want the sum of all the entries entered at 2:15 to be in one group and 2:30 in another and 3:15 into still another ? -eric Common sense is genius dressed in its working clothes. -- Ralph Waldo Emerson Eric Barr Zeff Design (p) 212.714.6390 (f) 212.580.7181 -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 8:11 AM To: CF-Talk Subject: SQL + time stamp I know this is an SQL question. I am getting readings inserting into a database every 15 minutes on the hour. They are time stamped like so, (dt) (columOne) 2001-02-28 12:59:5938.7 2001-02-28 12:45:0138.77 2001-02-28 12:30:0138.7 2001-02-28 12:15:0137.22 My problem is how would I do a sum value for 'columOne' adding up each quarter for each hour? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problem with CFStudio debugger
Hi, I'm having problems getting CFStudio's debugger to work. Whenever I try to use it to debug code, I get the following error message: Error Occurred While Processing Request Error Diagnostic Information An error has occurred. HTTP/1.0 404 Object Not Found I'd appreciate any advice. H:ubert --- Hubert Earl ICQ#: 16199853 See pictures of items in my Jamaican Art, Craft More Store Online Sale on my "Me" page on eBay (this tells you a little about myself, including a photo), and there's a link to the auctions themselves: http://members.ebay.com/aboutme/hearl1/ See pictures of all items I have: http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Manager of Support
Where do we find him? :) - Original Message - From: "lsellers" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 4:12 PM Subject: RE: Manager of Support Anyone know who the Manager of Support is at Allaire. Waldo. --min ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: com wddx
Are you sure you are putting the wddx com in the References (in your vba)
Justin
-Original Message-
From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 6:53 PM
To: CF-Talk
Subject: com wddx
Dear all
(Its been a while since I was on the list)
It occurred to me that it might be a clever thing to be able to send
data in wddx packets directly from excel 2000 (win 95) up to the server
(if you were online)... BUT
In my experimentations I have done as asked in the wddx.org SDK which
comes with CF 4.5 ref installing registering wddx_com.dll but when I
run the VBA code (code taken verbatim from Forta) it fails on the first
line!
Set MyDeser = CreateObject("WDDX.Deserializer.1")
Run-time error '438':
Object doesn't support this property or method
wddx_com.dll seems OK in the OLE/COM OBject viewer (No idea what I'm
looking for though!)
There does seem to be some sort of problem with xmlparse.dll and
xmltok.dll in as much that I get the message xmltok.dll was loaded but
the DLLRegisterServer entry point was not found etc. when I run regsvr32
xmltok.dll I've tried deleting Reinstalling these files but no diff.
ANY Ideas Please!
--
Regards;
Richard Meredith-Hardy
-
[EMAIL PROTECTED]
Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Manager of Support
(Oh my god who can resist the pun) Where's Waldo? (The Americans will get it, I think it's Where's Wally in England) (I should probably have list privileges revoked for this one, since I have nothing else to add) At 01:22 PM 02/28/2001 -0600, you wrote: Where do we find him? :) - Original Message - From: "lsellers" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, February 27, 2001 4:12 PM Subject: RE: Manager of Support Anyone know who the Manager of Support is at Allaire. Waldo. --min ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: getting users name
it's NT Challenge/Response. (not that that's important...:) look at CGI.AUTH_USER for the login name. (this question has been asked several times recently. kind of interesting how things seem to run in cycles) chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 12:08 PM To: CF-Talk Subject: OT: getting users name I have a web page that is secured so the user has to enter a name and password to get into the site. This is done with WinNT permissions on the folder that the web page is in. I think the official name is server side validation. Is there a way to grab the name the user inputs and use it in my cold fusion pages? Thanks In Advanced Chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Manager of Support
Anyone know who the Manager of Support is at Allaire. Waldo. Where do we find him? :) Probably on CF-Community, where this type of stuff should be Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL + time stamp
My problem is how would I do a sum value for 'columOne' adding up each quarter for each hour? Just a quick question before I head into SQL land - what database server? if you say Access I'll just say "Yuck" and not try Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL + time stamp
try GROUPing on the hour part of the time.
similar to:
SELECT
datepart("hh", dt) as myhour, sum(columnOne) as totalflow
FROM
tablename
WHERE
date criteria here
GROUP BY datepart("hh", dt)
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 12:29 PM
To: CF-Talk
Subject: RE: SQL + time stamp
Eric one reading is coming in every 15 minutes of every hour.
Its a C compiled agent that is taking quartly flowrates from a reservoir and
emailing to our database.
I'm getting 4 readings, one every 15 minutes, 4:15 , 4:30 , 4:45 , and 5:00
and so on.
the only thing is they are not coming in quite as accurate like that, at
least not all the time.
More like 4:16 , 4:29 , :4:45 , 4:59. So what I want to do is sum(all
Quaters for every hour).
Any ideas? (hope this is clearer!!)
-Original Message-
From: Eric Barr [mailto:[EMAIL PROTECTED]]
Sent: 28 February 2001 16:07
To: CF-Talk
Subject: RE: SQL + time stamp
John,
I'm not quite clear what your getting at do you mean that a reading
is taken every 15 minutes and you want to know the sum of the readings
at 00, 15,30, and 45 ? so that the readings from 2:15 are summed with
readings from 1:15 and 3:15 ?
Or are multiple readings being inserted every 15 minutes and you want
the sum of all the entries entered at 2:15 to be in one group and 2:30
in another and 3:15 into still another ?
-eric
Common sense is genius dressed in its working clothes.
-- Ralph Waldo Emerson
Eric Barr
Zeff Design
(p) 212.714.6390
(f) 212.580.7181
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 8:11 AM
To: CF-Talk
Subject: SQL + time stamp
I know this is an SQL question.
I am getting readings inserting into a database every 15 minutes on the
hour.
They are time stamped like so,
(dt) (columOne)
2001-02-28 12:59:5938.7
2001-02-28 12:45:0138.77
2001-02-28 12:30:0138.7
2001-02-28 12:15:0137.22
My problem is how would I do a sum value for 'columOne' adding up each
quarter for each hour?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Earthquake in Seattle
I must say it was pretty scary. Have to go now, evacuating the building... God Bless Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: isdefined obsolete?
Frederic,
Frederic,
Sorry to have touched a nerve, I thought it was a rather innocuous post, so
take it or leave it. You could have considered yourself one of the
experienced programmers that my comments were not useful to and let it lie.
I would certainly agree that if three people thought the syntax looked fine
that it probably was.
If you or anyone else can reproduce the error I think we'd all be interested
because you are calling into question the stability of one of the most used
tags.
Okay, it's dead now.
Tim
-Original Message-
From: C Frederic Valone [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 6:40 AM
To: CF-Talk
Subject: Re: "isdefined" obsolete?
Tim This can be the case when I single programmer, no matter what level
has a problem... if that problem then persists after
re-writing the code and you then pass the questionable code over to two
other programmers to to check and they still have the
same issue the problem is probibaly not that everyone overlooked a simple
syntax error.
Please kill this thread now I do not feel like defending my experiences any
more (I already have conformation that others have
experienced the same problem)
Thanks to all for their input.
Frederic
Tim Fields wrote:
Gentlemen,
It seems most likely that there was some variety of a syntax error in the
errant IsDefined() condition. How many times have you stared at code
convinced it should work only to suddenly see a extraneous or missing
character like a single quote? Sometimes we are looking at the forest not
the trees.
I'd suggest that when perplexed about a single line of code not
functioning
properly, start by doing the old proof reading method of reading the line
backwards. Also I've occasionally found it helpful to print out the code
in
color and then used various colored highlighters to mark up the code,
especially helpful with breaking down regular expressions.
Sorry that's a bit Off Topic and probably not real useful to advanced
programmers, but it would seem to address what is most likely at the root
of
this IsDefined "problem".
Tim Fields
-Original Message-
From: Ruslan Sivak [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 12:25 PM
To: CF-Talk
Subject: RE: "isdefined" obsolete?
The only time I had a problem using isDefined is when I forgot to use
quotation marks around the variable. The other thing is I don't think
isdefined works well on structs, you have to use StructKeyExists.
-Original Message-
From: C Frederic Valone [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 1:48 PM
To: CF-Talk
Subject: Re: "isdefined" obsolete?
If you see my previous response you'll see I tried all forms of syntax...
even those I "knew" were incorrect as stated the
problem was not logical so I tried illogical solutions as well.
This happened I would say two years or more ago... so I doubt very much I
was using 4.5.1 as it hadn't been released...I only
mentioned the whole issue as an FYI. I see it did happen for someone else
on
the list as well.
Frederic
Philip Arnold - ASP wrote:
Sorry to contadict you Adrian, but I can say with complete conviction
(and no explanation at all) that these experiences did happen...I
know that obviously a variable either exists or doesn't. That
doesn't mean that in every instance a function will work though.
I replaced the isdefined function (after checking to be sure the
syntax was correct) with parameterexists and it worked. I
switched it back to isdefined and it did not. I did it in more than
one
instance and I confirmed the issue and verified the results of
the workaround with other cf programmers on site.
As long as the quotes are around the variable name, then it will work -
unless you're running a not-upgraded version of CF (4.0 or 4.5 rather
than
4.0.1 and 4.5.1 SP2)
I've never had a problem with isDefined(), and it's much easier to use
than
ParameterExists(), especially if you're using dynamic names
isDefined("form.#i#") is easier than
Evaluate("ParameterExists(form.#i#)")
for obvious reasons although both should work exactly the same
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
PHP vs. Cold Fusion
Hi, folks! I'll highly appreciate if somebody can send me URL of the page where I can read performance comparison of the both techniques, of course if somebody has it own experience in such things then I'll get to know it with increased attention! P.S. I'm a bit abashed because of my English. I'm sorry. English isn't my native language. -- Regards, Alex mailto:[EMAIL PROTECTED] May all your Internet Dreams come true! http://www.intellinetusa.com/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Question on .htm?user=25 deal
So u mean, i can map my coldfusion server to, let's say, "mycoolextension", and index.mycoolextension will be read as a CFM file?!!! that'll be cool! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ENCTYPE=multipart/form-data problem
I have used forms like the one you describe many times and have never the problem you are having, so you can be sure it is not the CF server... Are you setting method to post in the form tag? Do you have any CFlocations based on the file input field (if the page relocates you will lose the form fields)? Post the code for all to look at and I'm sure you'll get a more informative answer. Good luck! Bryan Love ACP [EMAIL PROTECTED] -Original Message- From: Scott Lowe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 7:43 AM To: CF-Talk Subject: ENCTYPE="multipart/form-data" problem I don't know if this is a CF problem yet, but I haven't been able to get to the bottom of it: The problem arises when using ENCTYPE="multipart/form-data" to allow the use of files in a form. It seems that if a file is present, then all is well. However if the file field is empty then none of the other form data (input type="text" etc.) are avalable to the processing page. You get the error "Error resolving parameter FORM.PRICE" or something similar. Removing the enctype parameter from the form cures the problem (but this disables the file capabilities). We are using: CF Enterprise 4.5.1, Windows 2000 ADV server / IIS 5, IE5.0 (to submit the form). I guess the problem could be with any of these (of couse it could just be me doing something stupid). Anyway, if anyone has experienced the same problem or has an explaination I would be very grateful. Thanks, Scott. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Distance b/w Two Zips Function
are you asking me or him? i wouldn't know his intent. obviously, the code provided is for "crow-flies" calculation. for "turn-by-turn" you can: 1) pay mapquest or comparable service for access to their turn-by-turn engine - or - 2) license a turn-by-turn server from someone like MQ, ESRI, etc. - or - 3) write a bot that goes out and gets the data for you. 1 2 are $$. 3 is free...albeit questionable. :) -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 8:23 AM To: CF-Talk Subject: RE: Distance b/w Two Zips Function did he want staright line distance or the 'by car' distance? DK From: [EMAIL PROTECTED] AT INTERNET on 02/28/2001 10:45 AM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: RE: Distance b/w Two Zips Function this has come up beforehere's what i use. i understand there are more accurate formulas (look up haversine's formula and see links below), but this works really well for me; CFSET distance = #Evaluate(((pi()*3969.96)/180)*(ACos((Sin(lat_A)*Sin(lat_B)) + (Cos(lat_A)*Cos(lat_B)*Cos(lon_A-lon_B)# here are some links as well: http://www.indo.com/distance/distance-details.html http://www.svpal.org/~walters/GC_Measurements.htm --dylan -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 7:15 AM To: CF-Talk Subject: Distance b/w Two Zips Function Hi All, Does anyone have the mathematical function for calculating the distance between two zip codes using the latitude and longitude of both zip codes? TIA Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
