RE: How to save single quotes into DB

2001-11-20 Thread Pascal Peters
It always work automatically, even with form variables. The only problem might be when you use Evaluate() for dynamic variable names. Then the single quotes don't get escaped. Anyway, you should really use cfqueryparam to avoid all these problems. INSERT INTO TBL (NAME) VALUES (cfqueryparam

RE: How to save single quotes into DB

2001-11-20 Thread JAIME HOI
hey u r rite!!! i was using Evaluate on my form variable, No wonder it didn't work. Now i understand. Thanks Pascal! -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 4:07 PM To: CF-Talk Subject: RE: How to save single quotes into DB

Re: Passing Form Variable forward

2001-11-20 Thread Kay Smoljak
I had some problems with form fields not being passed that had names like new_time, old_date, etc. Apparently CF has built in error validation that uses hidden fields with underscores in the names to tell it which fields to validate and with what validation rule. I don't have it in front of me

Re: How to save single quotes into DB

2001-11-20 Thread Fisichella
Hi, what exactly does cfqueryparam do ??? If I'm not wrong, it can convert data input from form fields, into data type on sql. For example data input from form fields is always in string, we can convert it to data type of money for example ??? Examples would be helpful. Thanks... -

Re: Netscape 4.6

2001-11-20 Thread Peter Tilbrook
The latest 4.x version is 4.78 for Communicator (with all of the cra% you never want nor use - especially if you are a non-AOL hole - but is installed anyway). The latest Navigator only install is 4.08, possibly 4.09. The Netscape 6.2 install failed me today several times at 32% (a server

Re: How to save single quotes into DB

2001-11-20 Thread Peter Tilbrook
hey u r rite!!! i was using Evaluate on my form variable, No wonder it didn't work. Now i understand. Thanks Pascal! H. PASCAL! Those were indeed the days! Who would have thought that 18 years later I would be revelling in the freedom of CF? PASCAL was good for me however! P.s. -

ODBC connection

2001-11-20 Thread Heidi Belal
Hi, I need some help here with the ODBC connection. I've set up the database and datasource so i have the database name, datasource name, user and password for the SQL database but it's all on a different server from where the application actually is. So now my problem is that i want to set up my

RE: No longer a Fusebox virgin, got Fused yesterday

2001-11-20 Thread Neil Clark
You may consider getting stuck into FB3 :-) Neil Team Macromedia ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

Verity K2 anyone...

2001-11-20 Thread Tage Widsell
hi, I just upgraded to CF 5 and I'm looking around at all the shiny new features; One of them being the Verity K2 indexing server. Has anyone tried using it? It looks a _lot_ more complicated than the Verity indexing and searching in previous versions. The feature I really wanted to use was the

RE: ODBC connection

2001-11-20 Thread Pascal Peters
Heidi You can set all the parameters in the CF administrator when creating the connection. If you don't want all settings set in the administrator, you can pass username and password in cfquery. The server and dbname HAVE to be set in the ODBC. cfquery name=qTest datasource=#DS#

CF Server Upgrade Ent or Pro?

2001-11-20 Thread Paul Ihrig
i am having the very humorous time of updating our budget for next fiscal year. we have CF Server Enterprise 4.5 the upgrade to 5 is 2+k while pro is around 600 or so. i have never used security sandboxes in the 3 years i have been noodling cf will never have the amount of servers to do

Re: THE LATE GREAT FUSEBOX DEBATE

2001-11-20 Thread savan . thongvanh
I almost hate to reply to this thread but i gotta throw in my two cents. we all know that fuse box is the attempt to OOP-ize CF so why not just look at it the same way as any other OOP language. it can be powerful if you have full command of the language and cumbersome if not by adding undue

CF Studio Error

2001-11-20 Thread Mate Rados
We have a big problem with the CF Studio. If our users are not local administrators, they are not able to open CF Studio. Do you know if CF Studio can be started whitout local admin rights? Thanks for your help, Mate Rados ~~ Structure your

RE: THE LATE GREAT FUSEBOX DEBATE

2001-11-20 Thread Paris Lundis
I like bastardizing Fusebox... in its purest sense it is ideal like OOP... OOP is still quite abstract as most developers learned non-OOP stuff as a an introduction into computing...code has a lot of dependencies on other things and programs can break for some distant reasons... Fusebox

RE: CF Server Upgrade Ent or Pro?

2001-11-20 Thread Larry Juncker
If you are using SQL or Oracle, you will need Enterprise to connect using ODBC Otherwise you have to try and fanagal the OLE_DB to work with it. We upgraded to Pro only to find out we should have gone the extra step and gotten Enterprise Larry Juncker Senior Cold Fusion Developer Heartland

OT: hisecweb.inf and rebooting

2001-11-20 Thread Chad Gray
Has anyone else noticed that after installing hisecweb.inf the server shuts down REALLY slow? Anyone have an idea why this would happen? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ:

RE: CF Server Upgrade Ent or Pro?

2001-11-20 Thread Philip Arnold - ASP
If you are using SQL or Oracle, you will need Enterprise to connect using ODBC Otherwise you have to try and fanagal the OLE_DB to work with it. We upgraded to Pro only to find out we should have gone the extra step and gotten Enterprise looks at own server setup CF5 Pro, SQL Server 7 No

How to tell if a number is a multiple of 3?

2001-11-20 Thread Melanie Maddix
Hello, I am trying to figure out how to use CF code to determine whether or not a variable is a multiple of 3. Does anyone have any suggestions? Thank you, Melanie ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ:

RE: How to tell if a number is a multiple of 3?

2001-11-20 Thread Will Swain
divide by 3 and see if the result is a whole number? will -Original Message- From: Melanie Maddix [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 14:34 To: CF-Talk Subject: How to tell if a number is a multiple of 3? Hello, I am trying to figure out how to use CF code to determine

Re: Netscape 4.6

2001-11-20 Thread Alexis Maldonado
yup.. im sure microsoft didnt think that when they decided to take em down.. - Original Message - From: Tangorre, Michael T. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, November 19, 2001 10:23 PM Subject: Netscape 4.6 I just wanted to vent for a minute: Netscape

RE: How to tell if a number is a multiple of 3?

2001-11-20 Thread Nate Smith
Use the mod function. CFIF mynumber MOD 3 EQ 0 !--- it's a multiple --- CFELSE !--- it's not a multiple --- /CFIF - Nate Smith, Lead Developer Macromedia Coldfusion 5 Certified Professional Macromedia Certified Web Site Developer [EMAIL PROTECTED] www.doceus.com

RE: CF Server Upgrade Ent or Pro?

2001-11-20 Thread Ken Wilson
If you are using SQL or Oracle, you will need Enterprise to connect using ODBC Huh? I connect to SQL Server via ODBC with Pro. Enterprise versions gets you native drivers for some DB's but SQL is covered in the Pro version. Ken ~~ Get the

RE: How to tell if a number is a multiple of 3?

2001-11-20 Thread Larry Juncker
CFLOOP FROM=1 to=39 index=a CFIF a MOD 3 EQ 0cfoutput#a#/cfoutput/CFIF /CFLOOP Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Melanie Maddix [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001

RE: Netscape 4.6

2001-11-20 Thread Neil Clark
let me vent for a minute.. Netscape is a pile of dunk. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/

RE: How to tell if a number is a multiple of 3?

2001-11-20 Thread Lon Lentz
x mod 3 eq 0 -Original Message- From: Melanie Maddix [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 9:34 AM To: CF-Talk Subject: How to tell if a number is a multiple of 3? Hello, I am trying to figure out how to use CF code to determine whether or not a variable is a

RE: How to tell if a number is a multiple of 3?

2001-11-20 Thread Dave Wilson
Use MOD 3 Like this: cfloop from=1 to=10 index=current cfoutput#current#/cfoutput cfif current MOD 3 EQ 0 is a multiple of 3 cfelse is NOT a multiple of 3/cfifbr /cfloop HTH, Dave -Original Message- From: Melanie Maddix [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 14:34 To:

AUTO TABLE WIDTH

2001-11-20 Thread William J Wheatley
Whats the Code to AUTOSET the table size of a table so that the table does not have to get to the /table before the table can be displayed? Bill Wheatley Director of Development Certified Advanced ColdFusion 5 Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com

Force Download Directory

2001-11-20 Thread Brockman, Chuck
Is anyone aware of a way to force a directory on a users machine when they download a file? Ex. c:\download_here Thanks in advance, Chuck ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the

RE: Netscape 4.6

2001-11-20 Thread savan . thongvanh
all i've got to say, wow. why does IE get spanked so bad in a parallel comparison on this pge? Jared Clinton [EMAIL PROTECTED] on 11/19/2001 11:32:43 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: RE: Netscape 4.6 Not in all situations, check this

RE: Java Object - String format - WDDX - String format - Java Object

2001-11-20 Thread Joel Parramore
Kinley: If your nested Java class is serializable (i.e., implements the Serializable interface), then you could 1) Serialize the object and save it to a file 2) Read the file back into your ColdFusion page into a string and WDDX serialize it; 3) Pass along the

Selection Clock

2001-11-20 Thread Joshua Tipton
I need a custom tag that would display a clock for selection of time just like a calendar displays for the selection of a date. Joshua Tipton ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ:

RE: Force Download Directory

2001-11-20 Thread Carlisle, Eric
I don't think you can do that. Perhaps you can make a self extracting zip that extracts to a certain directory. :/ EC -Original Message- From: Brockman, Chuck [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 9:50 AM To: CF-Talk Subject: Force Download

Re: CF Server Upgrade Ent or Pro?

2001-11-20 Thread BILLY CRAVENS
If you're not doing hard-core clustering, or running native Oracle drivers, I've found Pro does the job. I'd guess that 75% of the Enterprise sales are due to the word Enterprise in the title - desk monkeys and power-lunch puppets really like that word. - Original Message - From: Paul

Testing SQL statements

2001-11-20 Thread Angel Stewart
How in the HECK do you enter dates into Oracle? I have tried several variations of a simple date in SQL Plus, and nothing seems to work. I keep getting an error saying Not a valid month. This is with raw SQL, not going through CF. SELECT * FROM tblMainEntry,TblDetailEntry WHERE

Re: CF Server Upgrade Ent or Pro?

2001-11-20 Thread BILLY CRAVENS
Whoever made that decision needs to be fired for wasting the company's money. - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 8:16 AM Subject: RE: CF Server Upgrade Ent or Pro? If you are using SQL or Oracle,

RE: Testing SQL statements

2001-11-20 Thread Joel Parramore
Try SELECT * FROM tblMainEntry,TblDetailEntry WHERE tblMainEntry.EmpID = 60597 AND tblDetailEntry.REcordDate = TO_DATE('11-30-2001','MM-DD-'); assuming tblDetailEntry.REcordDate is a DATE field. Regards, Joel Parramore -Original Message- From: Angel

RE: Testing SQL statements

2001-11-20 Thread Yager, Brian T Contractor/NCCIM
You need to use the to_date function... For Inserting, use to_date on your variableto_date('#mydate#', 'DD-MON- HH:MI:SS AM') And for selecting, you need to use a to_char on your field name... Try this.. SELECT * FROM tblMainEntry,TblDetailEntry WHERE

Re: Testing SQL statements

2001-11-20 Thread Alex
23-JAN-99 On Tue, 20 Nov 2001, Angel Stewart wrote: How in the HECK do you enter dates into Oracle? I have tried several variations of a simple date in SQL Plus, and nothing seems to work. I keep getting an error saying Not a valid month. This is with raw SQL, not going through CF.

Re: Testing SQL statements

2001-11-20 Thread jm12345
doesn't Oracle have a to_date function or something like that? Maybe try that. 23-JAN-99 On Tue, 20 Nov 2001, Angel Stewart wrote: How in the HECK do you enter dates into Oracle? I have tried several variations of a simple date in SQL Plus, and nothing seems to work. I keep

RE: Verity K2 anyone...

2001-11-20 Thread Garza, Jeff
There is a lot of documentation in the Advanced CF Administration guide that's installed with CF5.0. There are full chapters on Verity K2 and the Verity Spider. Unfortunately the interface for K2 within the CF Administrator is very weak. It's actually worse than their OLEDB interface

Re: Testing SQL statements

2001-11-20 Thread cf refactoring
Oracle (or is it SQL+ ?) has a parameter which specifies the format for dates. If you have not reset the default, it is '30-SEP-01' --- Angel Stewart [EMAIL PROTECTED] wrote: How in the HECK do you enter dates into Oracle? I have tried several variations of a simple date in SQL Plus, and

RE: Testing SQL statements

2001-11-20 Thread Pascal Peters
Safest method i found: UPDATE ...DateCreated= TO_DATE('#DateFormat(form.DateCreated,dd/mm/)#','DD/MM/') SELECT ...WHERE trunc(DateCreated) = TO_DATE('#DateFormat(variables.Startdate,dd/mm/)#','DD/MM/') Pascal PS: US citizens can use the mask DD-MM- if they like, but with

Re: AUTO TABLE WIDTH

2001-11-20 Thread Bud
On 11/20/01, William J Wheatley penned: Whats the Code to AUTOSET the table size of a table so that the table does not have to get to the /table before the table can be displayed? What? LOL -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions

where is scheduled info stored

2001-11-20 Thread John McCosker
When a schedule is created through cf admin where is it stored? i.e. a log file (if it is I can't find it) or the registry (...mmm not sure here..) . Users can create a schedule through a secured (web interface) and I'm writing all scheduled data to a txt file, I can do this because customers

RE: Selection Clock

2001-11-20 Thread Larry Juncker
I don't know for sure what you are asking for, but here is code for a simple time request form: !--- Time Selector --- CFOUTPUT form name=getTime What Time: !--- What hour do you want --- select name=hour CFLOOP FROM=1 to=12 index=hr

cfsqltype=cf_sql_timestamp

2001-11-20 Thread Steve Vosloo
hi I'm trying to pass a mssql server 7 timestamp variable into a sql 7 database using a stored proc (cf 4.51) using : cfprocparam type=in cfsqltype=cf_sql_timestamp value=#attributes.contentTimestamp# It gives an error. I've subsequently learned that CF does not support ms sql 7 timestamp data

RE: where is scheduled info stored

2001-11-20 Thread Pascal Peters
Use CFSCHEDULE to do the work. It is stored in the registry: HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Schedule Pascal -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: dinsdag 20 november 2001 16:35 To: CF-Talk Subject: where is scheduled info

first SQL server datasource on ISP

2001-11-20 Thread Douglas Jordon
Hi, I'm trying to get my first SQL server site up on Intermedia. I'm getting this error: OLEDB Error Code = 18456 Login failed for user '(null)'. None of my CFQUERY tags pass a login. On our staging server, where everything works, the database was created with Windows authentication, whereas

Re: AUTO TABLE WIDTH

2001-11-20 Thread William J Wheatley
:) not enough coffee A TABLE will now SHOW on the browser screen until it reaches the /table Because it has to read through the whole table to generate Widths and such but on large tables that can slow down the display of tables by a few seconds. Now there is a CODE you put into the page or

Re: Selection Clock

2001-11-20 Thread Eric Dawson
http://devex.allaire.com/developer/gallery/info.cfm?id=CA34714C-2830-11D4-AA9700508B94F380method=full Eric Dawson From: Joshua Tipton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Selection Clock Date: 20 Nov 2001 06:55:23 -0800 I need a custom tag that

RE: first SQL server datasource on ISP

2001-11-20 Thread Pascal Peters
Make sure they defined a username and password for the connection in CF SETTINGS of the CFAdmin ODBC (OR OLEDB) interface. -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: dinsdag 20 november 2001 16:54 To: CF-Talk Subject: first SQL server datasource on ISP Hi,

RE: AUTO TABLE WIDTH

2001-11-20 Thread Carlisle, Eric
table width=xxx ??? EC -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 10:51 AM To: CF-Talk Subject: Re: AUTO TABLE WIDTH :) not enough coffee A TABLE will now SHOW on the browser screen until it reaches the /table Because it

Re: AUTO TABLE WIDTH

2001-11-20 Thread William J Wheatley
nah its something like aUTO size and a meta tag you stick in the header i'll have to search the web for it see if i can find it Bill Wheatley Director of Development Certified Advanced ColdFusion 5 Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com

RE: AUTO TABLE WIDTH

2001-11-20 Thread Brian Ferrigno
Bill, This is taken from the HTML Reference section of CF Studio: COLS=number of columns Both Netscape (4.0 and above) and Internet Explorer (3.01 and above) claim to support the TABLE COLS=n attribute. The purpose of this attribute is to allow the browser to incrementally display large tables

RE: Datediff

2001-11-20 Thread Declan Maher
I am having problems comparing two dates. My question is how to compare two dates that come from different years. For example if I use the code below to compare a date of 12 Nov 2001 and 28 Feb 2002 to get the date difference I get -257 days. cfset

RE: Datediff

2001-11-20 Thread Tangorre, Michael T.
Use the ABS funcitons, which will return the positive value. The number is correct, Try this: ABS(cfset compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#) Im not sure on the pounds, but play with it. Lemme know if this helps. Mike -Original Message- From: Declan

RE: Datediff

2001-11-20 Thread Pascal Peters
datecompare(date1,date2) -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: dinsdag 20 november 2001 17:11 To: CF-Talk Subject: RE: Datediff I am having problems comparing two dates. My question is how to compare two dates that come from different years. For example

RE: Datediff

2001-11-20 Thread Tangorre, Michael T.
Sorry, I meant: cfset compare = ABS(#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#) Mike -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 11:16 AM To: CF-Talk Subject: RE: Datediff Use the ABS funcitons, which will

RE: Datediff

2001-11-20 Thread Pascal Peters
Didn't read everything. If you want the difference: compare= DateDiff('d',targ,implm) Datediff works on entire dates. Pascal -Original Message- From: Pascal Peters Sent: dinsdag 20 november 2001 17:24 To: CF-Talk Subject: RE: Datediff datecompare(date1,date2) -Original

RE: first SQL server datasource on ISP

2001-11-20 Thread Ken Wilson
Since Intermedia doesn't give you access to the CF Admin to set it at the DSN level, you'll need to pass the user/password in via the cfquery tag. Ken -Original Message- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 10:54 AM To: CF-Talk Subject:

RE: Datediff

2001-11-20 Thread Declan Maher
Mike, Thanks for the reply. The thing with the ABS function is that it only takes the minus sign away.The calculation is actually calculating the dates between 12 Nov 2001 and 28 Feb 2001 NOT 12 Nov 2001 and 28 Feb 2002 as it should.So the number of days is wrong. I am not using cf5 so cant

RE: Datediff

2001-11-20 Thread Declan Maher
Pascal, Pascal,Mike, Thanks. Tried Pascals version and works fine. compare=DateDiff('d',targ,implm) Cheers, Declan -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 16:28 To: CF-Talk Subject: RE: Datediff Didn't read everything. If you want the

Re: AUTO TABLE WIDTH

2001-11-20 Thread William J Wheatley
kewl thanks! Bill Wheatley Director of Development Certified Advanced ColdFusion 5 Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 - Original Message - From: Brian Ferrigno [EMAIL PROTECTED] To: CF-Talk [EMAIL

RE: first SQL server datasource on ISP

2001-11-20 Thread Bud
On 11/20/01, Ken Wilson penned: Since Intermedia doesn't give you access to the CF Admin to set it at the DSN level, you'll need to pass the user/password in via the cfquery tag. Won't they do it for you? -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/

Re: first SQL server datasource on ISP

2001-11-20 Thread Douglas Jordon
I'm not sure. I'm waiting to hear from their support. Bud wrote: On 11/20/01, Ken Wilson penned: Since Intermedia doesn't give you access to the CF Admin to set it at the DSN level, you'll need to pass the user/password in via the cfquery tag. Won't they do it for you? -- Bud

Re: first SQL server datasource on ISP

2001-11-20 Thread Douglas Jordon
Thanks. When I rewrite a query to pass the login, it works. If I end up re-writing my cfquery tags, I assume I should create another login with sp_grantdbaccess rather than use the default. Ken Wilson wrote: Since Intermedia doesn't give you access to the CF Admin to set it at the DSN level,

CF and Browser Detection

2001-11-20 Thread Tangorre, Michael T.
Is there a way in CF to detect the clients browser and version or is JS the only way to go? Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 ~~ Get the

RE: CF and Browser Detection

2001-11-20 Thread Chris Bohill
Try #HTTP_USER_AGENT# -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 16:59 To: CF-Talk Subject: CF and Browser Detection Is there a way in CF to detect the clients browser and version or is JS the only way to go? Michael T. Tangorre

Re: AUTO TABLE WIDTH

2001-11-20 Thread cf refactoring
I believe you're looking for the CSS2 table-layout property. As indicated on this page, it only works in IE. http://www.w3schools.com/css/css_reference.asp --- William J Wheatley [EMAIL PROTECTED] wrote: :) not enough coffee A TABLE will now SHOW on the browser screen until it reaches the

RE: CF and Browser Detection

2001-11-20 Thread Larry Juncker
#CGI.User_Agent# Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 10:59 AM To: CF-Talk Subject: CF and Browser Detection Is there

RE: CF and Browser Detection

2001-11-20 Thread Robert Everland
www.browserhawk.com Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 12:01 PM To: CF-Talk Subject: RE: CF and Browser Detection #CGI.User_Agent# Larry Juncker Senior

OT: SSL

2001-11-20 Thread Kwang Suh
Sorry for the OT question: Is one SSL certificate valid for one whole domain, or is it valid only for one fully qualified domain name? i.e., is it valid for *.mydomain.com, or only mysite.mydomain.com? ~~ Get the mailserver that powers this list

RE: SSL

2001-11-20 Thread Garza, Jeff
I believe that it's only valid for one FQDN. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 10:23 AM To: CF-Talk

RE: SSL

2001-11-20 Thread Paris Lundis
only good for fully qualified... they do sell site wide certificates however. -paris -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 12:23 To: CF-Talk Subject: OT: SSL Sorry for the OT question: Is one SSL certificate valid for one

RE: SSL

2001-11-20 Thread Joseph DeVore
It depends on how you registered the certificate. When you bought it, they asked you what the domain name it would be used for was. In my case 'secure.veloxweb.com'. If I try to use any domain other than 'secure.veloxweb.com' it prompts the client with a certificate mismatch warning. Joseph

Re: SSL

2001-11-20 Thread Kwang Suh
Akk, I found the answer to my question. If anyone else cares, it is possible for an SSL certificate with a name like www.mydomain.com to work on many sites with the .mydomain.com extension. However, the user's browser will warn the user that the domain name doesn't match the common name in the

Re: SSL

2001-11-20 Thread Troy Montour
use an alias.. and have the alias folder point to your other sites folder. that's what I have done in the past.. that way you don't have to worry about viewers getting the alert. so if your SSL Certificate is for mydomain.com you would have mydomain.com/something then when you needed the ssl

RE: SSL

2001-11-20 Thread Paris Lundis
good idea! -Original Message- From: Troy Montour [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 13:01 To: CF-Talk Subject: Re: SSL use an alias.. and have the alias folder point to your other sites folder. that's what I have done in the past.. that way you don't have to

OT: Dreamweaver

2001-11-20 Thread savan . thongvanh
anyone know of a way to use DW4 to locate orphan files on a site? ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:

RE: Dreamweaver

2001-11-20 Thread Cornillon, Matthieu
I thought this was an easy one, but it turns out that it's a little tricky in one spot. Go to the Site Files view of your site. In the local files pane, right-click on the root folder. In the pop-up, select Check Links -- Entire Site. (The Entire Site part is very important: orphaned files

From static to dynamic

2001-11-20 Thread Steven Katz
I have a site which consists of a few hundred catalog pages. The items in the catalog are pictured 9 to a page with accompanying descriptions. The homepage features an item-of-the-day, as well as the past 3 featured items. The entire site is static and regularly updated manually by me. I

Re: SSL

2001-11-20 Thread Kwang Suh
Can't do this for the application I'm working on. - Original Message - From: Troy Montour [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 11:00 AM Subject: Re: SSL use an alias.. and have the alias folder point to your other sites folder. that's what

RE: Updating a graph on the fly?

2001-11-20 Thread Ryan Emerle
I'm looking for the best direction to look for the solution to this problem What kind of graph will be used to represent this data? (i.e. bar, pie, ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ:

RE: Fusebox - opinions?

2001-11-20 Thread Costas Piliotis
That number was the one provided by www.fusebox.org, which I cited in my email. They make the damn product, which IMHO, that makes them more an authority than anyone else. Now lets compare that to http://php.weblogs.com/popularity Statistics. 900,000+ pages found with url.cfm . 6000

RE: cfsqltype=cf_sql_timestamp

2001-11-20 Thread Costas Piliotis
Try Using: #createodbcdate(attributes.contentTimeStamp)# CF function You may want to consider switching to datetime or smalldatetime... Check the MDAC documentation on what that supports. Everything supported in MDAC *should* be supported in cf... -Original Message- From: Steve Vosloo

Re: CF and Browser Detection

2001-11-20 Thread Max Paperno
Here's some code that may be useful. Not the most refined way, but works. Also doesn't return version info. Gecko is NN6. CFPARAM NAME=request.IsMSIE DEFAULT = #IIf( CGI.USER_AGENT CONTAINS MSIE, 1, 0 )# CFPARAM NAME=request.IsOpera DEFAULT = #IIf( CGI.USER_AGENT CONTAINS Opera, 1, 0 )#

Re: Fusebox - opinions?

2001-11-20 Thread Roger B.
1. Pros? Cons? Opinions? I've generally only seen good feedback, but I thought I'd see... I can't recommend Fusebox at this point... the official version is a study in overkill that tries to define the right way for your apps to be built. Some folks love that aspect of it, of course, but I

RE: Studio/FB question

2001-11-20 Thread Owens, Howard
I've always wanted the functionality (and I've requested it in the Forums), that if you held down the option or ctrl key while dragging the file, it would create an include rather than a link. H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956

Re: SSL

2001-11-20 Thread Jim McAtee
Actually, you could use your cert for www.mydomain.com for _any_ host name you like if you don't mind the warning. But then again, that's why the browser is warning the user - because the certifcate was not issued for that host name. It doesn't matter the new name is a just another host in

RE: cfsqltype=cf_sql_timestamp

2001-11-20 Thread Steve Vosloo
unfortunately mssql timestamp has nothing to do with time/date - this is the problem. i need a cfsqltype that supports mssql timestamp. -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 9:03 PM To: CF-Talk Subject: RE:

No cache or page refresh

2001-11-20 Thread one
How do you refresh a page via code or prevent caching of a page? Have seen some other suggestions, but none of them have worked thus far. Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: CF and Browser Detection

2001-11-20 Thread Jon Hall
http://www.digital-jungle.com/cfuseragent/ for a CF way to do it or http://www.webreference.com/tools/browser/javascript.html for Javascript jon - Original Message - From: Tangorre, Michael T. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 11:58 AM

Re: Updating a graph on the fly?

2001-11-20 Thread John Dowdell
At 8:05 PM 11/19/1, Michael Kear wrote: I have a client who has a financial services application - wants his users to enter parameters like age, income, interest rate etc and as the parameters change, there is to be a graph showing how the user's net worth up to age 65 will change... I'd like

RE: cfsqltype=cf_sql_timestamp

2001-11-20 Thread Boardwine, David L.
This code is working in my application. CFPROCPARAM type=IN cfsqltype=CF_SQL_TIMESTAMP dbvarname=RequestsDate value='#NOW()#' HTH -Original Message- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 3:00 PM To: CF-Talk Subject: RE:

RE: Fusebox - opinions?

2001-11-20 Thread Joseph DeVore
Costas, Not that you care, others might - the following email is from one of the founders of Fusebox, Steve Nelson. His message is in regards to the '6174' counter on the FB site. Steve says, That's just the number of people that have created accounts on Fusebox.org. Since there isn't much of

Stored Procedure Question

2001-11-20 Thread Bruce Sorge
OK, I have been using SP for a while with no problems. Now I am encountering an issue. I have a stored procedure that looks like this: CREATE PROCEDURE Next30Days @Next30 DateTime, @TodayDate DateTime AS SELECT Title, Copy, EventDate, EventTime FROMCalendar Where EventDate @Next30 And

Re: Stored Procedure Question

2001-11-20 Thread Kwang Suh
Hmm. Try using CF_SQL_TIMESTAMP. I've NEVER been able to get CF_SQL_DATE to work properly. - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 1:27 PM Subject: Stored Procedure Question OK, I have been using SP for

Re: OT: SSL

2001-11-20 Thread Tony Schreiber
You can buy it both ways. Normally it's for one hostname only, but you can buy both wildcard certificates and multiple host certficates... Sorry for the OT question: Is one SSL certificate valid for one whole domain, or is it valid only for one fully qualified domain name? i.e., is it

Re: Stored Procedure Question

2001-11-20 Thread Bruce Sorge
That was it. Thanks. -- Original Message -- From: Kwang Suh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 20 Nov 2001 13:28:19 -0700 Hmm. Try using CF_SQL_TIMESTAMP. I've NEVER been able to get CF_SQL_DATE to work properly. - Original

Re: Stored Procedure Question

2001-11-20 Thread Brian Silvers
I've had the same problem with SP's and cfstoredproc What I did was change the data types for the input parameters to varchar and do the checking before I enter the cfstoredprocedure tag I do a lot of dynamic SQL building in my sp's and I have had nothing but headaches with cfstoredproc when

  1   2   >