RE: How to save single quotes into DB
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 cfsqltype=CF_SQL_VARCHAR value=#form.myfield#) Pascal Peters Macromedia Certified Instructor Certified ColdFusion (5.0) Advanced Developer Certified Web Developer LR Technologies, Belgium Tel +32 2 639 68 70 Fax +32 2 639 68 99 Email [EMAIL PROTECTED] Web www.lrt.be -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: dinsdag 20 november 2001 4:50 To: CF-Talk Subject: RE: How to save single quotes into DB thanks! but then i juz realise that Coldfusion will automatically handle this part ONLY IF i do not use the form variable directly. I need to assign that form variable to another variable before setting it into DB. Then it works automatically. ! ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to save single quotes into DB
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 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 cfsqltype=CF_SQL_VARCHAR value=#form.myfield#) Pascal Peters Macromedia Certified Instructor Certified ColdFusion (5.0) Advanced Developer Certified Web Developer LR Technologies, Belgium Tel +32 2 639 68 70 Fax +32 2 639 68 99 Email [EMAIL PROTECTED] Web www.lrt.be -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: dinsdag 20 november 2001 4:50 To: CF-Talk Subject: RE: How to save single quotes into DB thanks! but then i juz realise that Coldfusion will automatically handle this part ONLY IF i do not use the form variable directly. I need to assign that form variable to another variable before setting it into DB. Then it works automatically. ! ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Passing Form Variable forward
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 right now so I can't look up the feature, but you might want to check what happens if you change the field name to remove the underscore. HTH, K. Angel Stewart [EMAIL PROTECTED] wrote in message news:000e01c17156$ae9c75a0$0a00a8c0@Gel... Under what circumstances would a form variable NOT be passed forward from one form to the next upon Form Submit? I have a form that contains SEVERAL dynamically generated fields, that need to all be passed forward. However for some reason certain fields just aren't being detected by the ACTION form. If I pass these fields on the URL line, it works. But why should I have to do this? -Gel ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to save single quotes into DB
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... - Original Message - From: JAIME HOI [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 3:08 PM Subject: RE: How to save single quotes into DB 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 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 cfsqltype=CF_SQL_VARCHAR value=#form.myfield#) Pascal Peters Macromedia Certified Instructor Certified ColdFusion (5.0) Advanced Developer Certified Web Developer LR Technologies, Belgium Tel +32 2 639 68 70 Fax +32 2 639 68 99 Email [EMAIL PROTECTED] Web www.lrt.be -Original Message- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: dinsdag 20 november 2001 4:50 To: CF-Talk Subject: RE: How to save single quotes into DB thanks! but then i juz realise that Coldfusion will automatically handle this part ONLY IF i do not use the form variable directly. I need to assign that form variable to another variable before setting it into DB. Then it works automatically. ! ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Netscape 4.6
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 down?). I only install it as a web developer should test under as many lah lah lah, etc etc, bull Opera is beta testing 6.0 of it's small but effective (3.5(ish)Mb as opposed to 20Mb+ opposition). I wrongly assumed that no-one would ever use Opera on one of my sites and will be rectifying the situation ASAP. Never again. You can (in an Intranet/Extranet) dictate the minimum required OS/Browser version. In the real world you are better off making your sites as accessible as possible. Peter Tilbrook ([EMAIL PROTECTED]) Macromedia ColdFusion Applications Developer Cubok Pty. Ltd. Units 7-10 Australian Heritage Village Watson ACT 2602 AUSTRALIA http://www.cubok.com Mobile: 0401 973 415 Tel: +61-2-6262-4080 ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to save single quotes into DB
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. - Pyjama party this weekend - boxer shorts OK. 17 year + reunion ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC connection
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 application.cfm file so that it connects. What i have now is: cfset DS = AB1885000_nfc how do i set the rest up such that it can enter the username and password and the dataserver ip address? Thanks = Heidi Belal www.code-corner.com ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: No longer a Fusebox virgin, got Fused yesterday
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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Verity K2 anyone...
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 XML doc indexing. What I'm wondering is if the K2 means a lot of overhead? Is it generally hard to use and understand? Will there be conflicts with the old style (VDK) searching and indexing? Thanks Tage Widsell Webmaster Propellerhead Software ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC connection
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# username=#username# password=#password# If you are using CF5, you can use the attribute 'connectstring' to establish the connection. The connection is created every time you use the DSN in a database tag (cfquery, cfstoredproc, cfinsert, cfupdate). Coldfusion can reuse an existing connection for that depending on your settings in the ODBC or create a new one if none is available. Hope this helps Pascal -Original Message- From: Heidi Belal [mailto:[EMAIL PROTECTED]] Sent: dinsdag 20 november 2001 11:21 To: CF-Talk Subject: ODBC connection 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 application.cfm file so that it connects. What i have now is: cfset DS = AB1885000_nfc how do i set the rest up such that it can enter the username and password and the dataserver ip address? Thanks Heidi Belal www.code-corner.com ICQ# 32127109 A bus stops at a bus station. A train stops at a train station. On my desk I have a work station... ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Server Upgrade Ent or Pro?
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 clustering. so what are the other difference? please respond ASAP i just want an upgrade http://www.macromedia.com/software/coldfusion/productinfo/new_features/ but i am not sure if i would ever need \\ High-Performance Graph Caching Native Database Drivers Server Sandbox Security Integrated Software Load Balancing Automatic Server Failover Hardware Load Balancer Integration Visual Cluster Administration Application Deployment Services Advanced Application Monitoring SNMP Support Log File Analyzer ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: THE LATE GREAT FUSEBOX DEBATE
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 complexity where an experienced programmer would use a more direct and efficient built in feature i.e., proper use of includes, custom tags, cfx, and what not. so i ask myself when defining a project, why use OOP libraries for something u could do with a scriptlet? if it's big enuff and you need fusebox, use it because it CAN be abbreviated and massaged to your liking. if not, take it easy on yourself and bill like ur using it :P Joseph Thompson [EMAIL PROTECTED] on 11/19/2001 03:41:36 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: Re: THE LATE GREAT FUSEBOX DEBATE Last week in Vancouver he specifically ducked backing any one methodology although he did say a) you should use one b)A methodology is no good if it requires that you re learn everything you know Being a big fan of the rollover form (and hating the form--action--display approach) I found Fusebox a real joy. I didn't have to relearn anything as I always wrote my forms assuming there would be default values. Now i just CFPARAM my values to the Attributes scope. That file, and the query files live seperate so when someone decides to mod the dbase you just need to mod those two files. . I am really curious about Ben Forta's opinion of Fusebox? Has anyone been able to corner him into saying anything one way or the other? ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Studio Error
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 ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: THE LATE GREAT FUSEBOX DEBATE
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 specification is interesting and has some good things about it... notably the centralized index.cfm ... however, I think fused sites would work better if people flattened all the subdirs down to just one index page... we often get plagued by subdirs and sub indexes... lots of open this file and that file.. reminds me of compile time with any other language... notably C and Java... At any rate, I would say the Fusebox specification should be shown to all developers... it is a good centralized sort of design... nice to see we can go to one page to add a new handler if you will that is in fact a page with its own logic... makes sense, like a building directory or book index... the naming convention and idea of breaking things into display and sql isolated files is pretty good.. as it allows me to hop into a project and find broken pieces on other developers work and immediately go to tweaking things.. IN its finest form it isolate things so you can have in a real development environment: 1. A DBA writing SQL. 2. A designer doing the DSP pages. 3. A web master handling the index.cfm files.. 4. A web developer handling the logic and programming.. to me, it makes collaboration able to exist... and I suppose that is in part one of the designs and benefits of OOP... with the FUSE you have 4 points of problems.. with debugging on you can see the pieces.. you can see the variables.. you can see the parts and logic... and isolating things can be alarmingly easy... -paris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 08:52 To: CF-Talk Subject: Re: THE LATE GREAT FUSEBOX DEBATE 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 complexity where an experienced programmer would use a more direct and efficient built in feature i.e., proper use of includes, custom tags, cfx, and what not. so i ask myself when defining a project, why use OOP libraries for something u could do with a scriptlet? if it's big enuff and you need fusebox, use it because it CAN be abbreviated and massaged to your liking. if not, take it easy on yourself and bill like ur using it :P Joseph Thompson [EMAIL PROTECTED] on 11/19/2001 03:41:36 PM Please respond to [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] cc: Subject: Re: THE LATE GREAT FUSEBOX DEBATE Last week in Vancouver he specifically ducked backing any one methodology although he did say a) you should use one b)A methodology is no good if it requires that you re learn everything you know Being a big fan of the rollover form (and hating the form--action--display approach) I found Fusebox a real joy. I didn't have to relearn anything as I always wrote my forms assuming there would be default values. Now i just CFPARAM my values to the Attributes scope. That file, and the query files live seperate so when someone decides to mod the dbase you just need to mod those two files. . I am really curious about Ben Forta's opinion of Fusebox? Has anyone been able to corner him into saying anything one way or the other? ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server Upgrade Ent or Pro?
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 Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 7:06 AM To: CF-Talk Subject: CF Server Upgrade Ent or Pro? 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 clustering. so what are the other difference? please respond ASAP i just want an upgrade http://www.macromedia.com/software/coldfusion/productinfo/new_features/ but i am not sure if i would ever need \\ High-Performance Graph Caching Native Database Drivers Server Sandbox Security Integrated Software Load Balancing Automatic Server Failover Hardware Load Balancer Integration Visual Cluster Administration Application Deployment Services Advanced Application Monitoring SNMP Support Log File Analyzer ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: hisecweb.inf and rebooting
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: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server Upgrade Ent or Pro?
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 problems here... ODBC rather than OLE DB as the testing we did found it to be faster 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. ** ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 multiple of 3. Does anyone have any suggestions? Thank you, Melanie ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to tell if a number is a multiple of 3?
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 whether or not a variable is a multiple of 3. Does anyone have any suggestions? Thank you, Melanie ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Netscape 4.6
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 4.6 is a pile of dunk. Gnite. Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to tell if a number is a multiple of 3?
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 -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 9:37 AM To: CF-Talk Subject: RE: How to tell if a number is a multiple of 3? 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 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: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Server Upgrade Ent or Pro?
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 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to tell if a number is a multiple of 3?
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 8: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 multiple of 3. Does anyone have any suggestions? Thank you, Melanie ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Netscape 4.6
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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to tell if a number is a multiple of 3?
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 multiple of 3. Does anyone have any suggestions? ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: How to tell if a number is a multiple of 3?
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: 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 multiple of 3. Does anyone have any suggestions? Thank you, Melanie ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
AUTO TABLE WIDTH
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 www.aeps2000.com 954-472-6684 X303 ICQ: 417645 ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Force Download Directory
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 community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Netscape 4.6
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 javascript graph in IE http://tavernini.com/lorenz.html (too sloow) and then in netscape and see which one you prefer. Jared Clinton. -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 20 November 2001 2:23 PM To: CF-Talk Subject: Netscape 4.6 I just wanted to vent for a minute: Netscape 4.6 is a pile of dunk. Gnite. Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Java Object - String format - WDDX - String format - Java Object
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 WDDX-packet to whatever other application requires it; 4) WDDX deserialize the string, save it to a file, then use Java to deserialize it back from the file. Or, instead of a file, serialize the Java object to a byte array, or a string, and WDDX-serialize that instead. Regards, Joel Parramore -Original Message- From: Kinley Pon [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 10:00 AM To: CF-Talk Subject: Java Object - String format - WDDX - String format - Java Object Here is something that may be of interest to those Coldfusion, java, and WDDX developers. I am in need of a FUNCTION or METHOD that would take a NESTED Java Object and convert it into a STRING format. I will then WDDX ready the resulting STRING formatted value. I will then WDDX serialize the STRING formatted value. After doing so, I will then pass this WDDX XML formated string and convert it by WDDX deserialization back into a Java Object. Can you help please...I need a FUNCTION would convert a NESTED JAVA OBJECT into a WDDX ready STRING. I am sure there is a Genuis out there that have an answer. talk soon - Kinley ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Selection Clock
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: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Force Download Directory
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 Directory 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 ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Server Upgrade Ent or Pro?
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 Ihrig [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 7:05 AM Subject: CF Server Upgrade Ent or Pro? 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 clustering. so what are the other difference? please respond ASAP i just want an upgrade http://www.macromedia.com/software/coldfusion/productinfo/new_features/ but i am not sure if i would ever need \\ High-Performance Graph Caching Native Database Drivers Server Sandbox Security Integrated Software Load Balancing Automatic Server Failover Hardware Load Balancer Integration Visual Cluster Administration Application Deployment Services Advanced Application Monitoring SNMP Support Log File Analyzer ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Testing SQL statements
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 tblMainEntry.EmpID = 60597 AND tblDetailEntry.REcordDate = '11-30-2001'; DAMMIT to HELLS! -Gel ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF Server Upgrade Ent or Pro?
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, 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 Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 7:06 AM To: CF-Talk Subject: CF Server Upgrade Ent or Pro? 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 clustering. so what are the other difference? please respond ASAP i just want an upgrade http://www.macromedia.com/software/coldfusion/productinfo/new_features/ but i am not sure if i would ever need \\ High-Performance Graph Caching Native Database Drivers Server Sandbox Security Integrated Software Load Balancing Automatic Server Failover Hardware Load Balancer Integration Visual Cluster Administration Application Deployment Services Advanced Application Monitoring SNMP Support Log File Analyzer ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Testing SQL statements
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 Stewart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 10:10 AM
To: CF-Talk
Subject: Testing SQL statements
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 tblMainEntry.EmpID = 60597
AND tblDetailEntry.REcordDate = '11-30-2001';
DAMMIT to HELLS!
-Gel
~~
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: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Testing SQL statements
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 tblMainEntry.EmpID = 60597
AND to_char(tblDetailEntry.REcordDate, 'MM-DD-') = '11-30-2001';
Brian Yager
President - North AL Cold Fusion Users Group
Sr. Systems Analyst
NCCIM/CIC
[EMAIL PROTECTED]
(256) 842-8342
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 9:10 AM
To: CF-Talk
Subject: Testing SQL statements
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 tblMainEntry.EmpID = 60597
AND tblDetailEntry.REcordDate = '11-30-2001';
DAMMIT to HELLS!
-Gel
~~
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Testing SQL statements
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. SELECT * FROM tblMainEntry,TblDetailEntry WHERE tblMainEntry.EmpID = 60597 AND tblDetailEntry.REcordDate = '11-30-2001'; DAMMIT to HELLS! -Gel ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Testing SQL statements
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 getting an error saying Not a valid month. This is with raw SQL, not going through CF. SELECT * FROM tblMainEntry,TblDetailEntry WHERE tblMainEntry.EmpID = 60597 AND tblDetailEntry.REcordDate = '11-30-2001'; DAMMIT to HELLS! -Gel ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Verity K2 anyone...
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 Anyway, dig into the docs and if you are still having problems, shoot me an e-mail offlist. I recently gave a presentation at the PhoenixCFUG on this topic and I can give you a copy of it. Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Tage Widsell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 4:16 AM To: CF-Talk Subject: Verity K2 anyone... 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 XML doc indexing. What I'm wondering is if the K2 means a lot of overhead? Is it generally hard to use and understand? Will there be conflicts with the old style (VDK) searching and indexing? Thanks Tage Widsell Webmaster Propellerhead Software ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Testing SQL statements
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 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 tblMainEntry.EmpID = 60597 AND tblDetailEntry.REcordDate = '11-30-2001'; DAMMIT to HELLS! -Gel ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Testing SQL statements
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 this
method it really doesn't matter
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 20 november 2001 16:10
To: CF-Talk
Subject: Testing SQL statements
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 tblMainEntry.EmpID = 60597
AND tblDetailEntry.REcordDate = '11-30-2001';
DAMMIT to HELLS!
-Gel
~~
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: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AUTO TABLE WIDTH
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 / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
where is scheduled info stored
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 must log in and I can store the text file dynamically after their name. so on request by the user the txt file can be read and schedules can be updated, run and deleted from there on in. I obviously don't want to give users access to CF Admin, didn't cross my mind. I was just wondering instead of creating a txt file does cf allow you to access the info any other way, apart from storing to a DSN or XML packet of course, or am I doing it correct. Thanx ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Selection Clock
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 option value=#hr##hr# /CFLOOP /select !--- What minute do you want --- select name=minute CFLOOP FROM=0 TO=59 INDEX=min step=5 option value=#min#CFIF min LT 100#min#CFELSE#min#/CFIF /CFLOOP /select !--- Do you want AM or PM --- select name=AP option value=AMAM/option option value=PMPM/option /select /form /CFOUTPUT Hope this helps. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 8:55 AM To: CF-Talk Subject: Selection Clock 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 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cfsqltype=cf_sql_timestamp
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 types, which are actually of bin(8) data types. CF thinks they're date/time, which in my case it certainly isn't. Has anyone successfully managed to pass this varibale type into SQL? Thanks Steve Vosloo Vardus (Pty) Ltd ASKA House Fedsure on Main Main Road Newlands 7700 Cape Town Tel: +27 (0)21 670 9880 Fax: +27 (0)21 674 4549 www.vardus.co.za The information contained in this communication is confidential, may be privileged and is intended for the above named addressee(s). If you are not the intended recipient(s), and have received this communication in error, please contact the sender by replying to this email or by telephoning +27 (0)21 670 9880. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Vardus (Pty) Ltd. ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: where is scheduled info stored
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 stored 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 must log in and I can store the text file dynamically after their name. so on request by the user the txt file can be read and schedules can be updated, run and deleted from there on in. I obviously don't want to give users access to CF Admin, didn't cross my mind. I was just wondering instead of creating a txt file does cf allow you to access the info any other way, apart from storing to a DSN or XML packet of course, or am I doing it correct. Thanx ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
first SQL server datasource on ISP
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 the Intermedia database was created with SQL server authentication(as specified by Intermedia). What am I doing wrong? TIA, Doug Jordon ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AUTO TABLE WIDTH
:) 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 the table tag that lets the Browser know this is a PREDEFINED size and to display it on the fly I forget what that code is any idea? Thanks all, 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: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:35 AM Subject: Re: AUTO TABLE WIDTH 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 / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Selection Clock
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 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: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: first SQL server datasource on ISP
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, 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 the Intermedia database was created with SQL server authentication(as specified by Intermedia). What am I doing wrong? TIA, Doug Jordon ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: AUTO TABLE WIDTH
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 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 the table tag that lets the Browser know this is a PREDEFINED size and to display it on the fly I forget what that code is any idea? Thanks all, 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: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:35 AM Subject: Re: AUTO TABLE WIDTH 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 / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AUTO TABLE WIDTH
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 954-472-6684 X303 ICQ: 417645 - Original Message - From: Carlisle, Eric [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 11:02 AM Subject: RE: AUTO TABLE WIDTH 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 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 the table tag that lets the Browser know this is a PREDEFINED size and to display it on the fly I forget what that code is any idea? Thanks all, 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: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:35 AM Subject: Re: AUTO TABLE WIDTH 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 / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: AUTO TABLE WIDTH
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 as the cell data is downloaded. It is part of the 'Complex Table Model' as defined in the W3C specification Tables in HTML documents. However, use of this attribute appears to do nothing in Internet Explorer or Netscape (Communicator preview 2). (It has been included here for completeness). I've never tried this but it might be what you're looking for. Brian Ferrigno -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 9:47 AM To: CF-Talk Subject: AUTO TABLE WIDTH 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 www.aeps2000.com 954-472-6684 X303 ICQ: 417645 ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Datediff
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 compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)# cfset comparison_list=#ListAppend(comparison_list,#compare#)# I have tried other means of doing this but with no success. Can somebody suggest the correct code to use to compare dates that overlap years? Thanks in advance, Declan maher -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 16:03 To: CF-Talk Subject: RE: AUTO TABLE WIDTH 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 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 the table tag that lets the Browser know this is a PREDEFINED size and to display it on the fly I forget what that code is any idea? Thanks all, 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: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:35 AM Subject: Re: AUTO TABLE WIDTH 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 / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Datediff
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 Maher [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 11:11 AM 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 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 compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)# cfset comparison_list=#ListAppend(comparison_list,#compare#)# I have tried other means of doing this but with no success. Can somebody suggest the correct code to use to compare dates that overlap years? Thanks in advance, Declan maher -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 16:03 To: CF-Talk Subject: RE: AUTO TABLE WIDTH 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 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 the table tag that lets the Browser know this is a PREDEFINED size and to display it on the fly I forget what that code is any idea? Thanks all, 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: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:35 AM Subject: Re: AUTO TABLE WIDTH 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 / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Datediff
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 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 compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)# cfset comparison_list=#ListAppend(comparison_list,#compare#)# I have tried other means of doing this but with no success. Can somebody suggest the correct code to use to compare dates that overlap years? Thanks in advance, Declan maher -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 16:03 To: CF-Talk Subject: RE: AUTO TABLE WIDTH 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 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 the table tag that lets the Browser know this is a PREDEFINED size and to display it on the fly I forget what that code is any idea? Thanks all, 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: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:35 AM Subject: Re: AUTO TABLE WIDTH 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 / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Datediff
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 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 Maher [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 11:11 AM 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 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 compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)# cfset comparison_list=#ListAppend(comparison_list,#compare#)# I have tried other means of doing this but with no success. Can somebody suggest the correct code to use to compare dates that overlap years? Thanks in advance, Declan maher -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 16:03 To: CF-Talk Subject: RE: AUTO TABLE WIDTH 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 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 the table tag that lets the Browser know this is a PREDEFINED size and to display it on the fly I forget what that code is any idea? Thanks all, 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: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:35 AM Subject: Re: AUTO TABLE WIDTH 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 / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Datediff
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 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 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 compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#
cfset comparison_list=#ListAppend(comparison_list,#compare#)#
I have tried other means of doing this but with no success.
Can somebody suggest the correct code to use to compare dates that
overlap years?
Thanks in advance,
Declan maher
-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: 20 November 2001 16:03
To: CF-Talk
Subject: RE: AUTO TABLE WIDTH
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 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 the table tag that lets the
Browser know this is a PREDEFINED size and to display it on the fly
I forget what that code is any idea?
Thanks all,
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: Bud [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, November 20, 2001 10:35 AM
Subject: Re: AUTO TABLE WIDTH
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 / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: first SQL server datasource on ISP
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: first SQL server datasource on ISP 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 the Intermedia database was created with SQL server authentication(as specified by Intermedia). What am I doing wrong? TIA, Doug Jordon ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Datediff
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 use a UDF. Any other ideas? Regards, Declan -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 16:21 To: CF-Talk Subject: RE: Datediff 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 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 Maher [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 11:11 AM 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 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 compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)# cfset comparison_list=#ListAppend(comparison_list,#compare#)# I have tried other means of doing this but with no success. Can somebody suggest the correct code to use to compare dates that overlap years? Thanks in advance, Declan maher -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: 20 November 2001 16:03 To: CF-Talk Subject: RE: AUTO TABLE WIDTH 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 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 the table tag that lets the Browser know this is a PREDEFINED size and to display it on the fly I forget what that code is any idea? Thanks all, 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: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:35 AM Subject: Re: AUTO TABLE WIDTH 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 / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Datediff
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 difference: compar=
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 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 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 compare=#DateDiff(d,#DayofYear(#targ#)#,#DayofYear(#implm#)#)#
cfset comparison_list=#ListAppend(comparison_list,#compare#)#
I have tried other means of doing this but with no success.
Can somebody suggest the correct code to use to compare dates that
overlap years?
Thanks in advance,
Declan maher
-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: 20 November 2001 16:03
To: CF-Talk
Subject: RE: AUTO TABLE WIDTH
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 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 the table tag that lets the
Browser know this is a PREDEFINED size and to display it on the fly
I forget what that code is any idea?
Thanks all,
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: Bud [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, November 20, 2001 10:35 AM
Subject: Re: AUTO TABLE WIDTH
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 / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
~~
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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AUTO TABLE WIDTH
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 PROTECTED] Sent: Tuesday, November 20, 2001 11:13 AM Subject: RE: AUTO TABLE WIDTH 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 as the cell data is downloaded. It is part of the 'Complex Table Model' as defined in the W3C specification Tables in HTML documents. However, use of this attribute appears to do nothing in Internet Explorer or Netscape (Communicator preview 2). (It has been included here for completeness). I've never tried this but it might be what you're looking for. Brian Ferrigno -Original Message- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 9:47 AM To: CF-Talk Subject: AUTO TABLE WIDTH 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 www.aeps2000.com 954-472-6684 X303 ICQ: 417645 ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: first SQL server datasource on ISP
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 _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: first SQL server datasource on ISP
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 Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: first SQL server datasource on ISP
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, 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: first SQL server datasource on ISP 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 the Intermedia database was created with SQL server authentication(as specified by Intermedia). What am I doing wrong? TIA, Doug Jordon ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Browser Detection
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 == Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AUTO TABLE WIDTH
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 /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 the table tag that lets the Browser know this is a PREDEFINED size and to display it on the fly I forget what that code is any idea? Thanks all, 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: Bud [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:35 AM Subject: Re: AUTO TABLE WIDTH 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 / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Browser Detection
#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 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 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Browser Detection
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 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 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 ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: SSL
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 at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SSL
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 Subject: OT: SSL 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? ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SSL
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 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 at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SSL
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 DeVore VeloxWeb Technologies -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 9:23 AM To: CF-Talk Subject: OT: SSL 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? ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL
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 certificate. It is possible to get a *.mydomain.com certificate, on a case-by-case basis according to Verisign. - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:29 AM Subject: RE: SSL 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 Subject: OT: SSL 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? ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 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 certificate you would do https://www.mydomain.com/something were something actually is pointing to the other sites web folder so you can make any page secured. or you can point it to one folder. Troy Montour Vampires Inc - Original Message - From: Kwang Suh [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 11:31 AM Subject: Re: SSL 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 certificate. It is possible to get a *.mydomain.com certificate, on a case-by-case basis according to Verisign. - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:29 AM Subject: RE: SSL 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 Subject: OT: SSL 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 at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SSL
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 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 certificate you would do https://www.mydomain.com/something were something actually is pointing to the other sites web folder so you can make any page secured. or you can point it to one folder. Troy Montour Vampires Inc - Original Message - From: Kwang Suh [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 11:31 AM Subject: Re: SSL 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 certificate. It is possible to get a *.mydomain.com certificate, on a case-by-case basis according to Verisign. - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:29 AM Subject: RE: SSL 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 Subject: OT: SSL 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 at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Dreamweaver
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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Dreamweaver
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 reports won't come up otherwise. This is especially confusing since the File menu version of the command doesn't always allow you to run the check on the whole site.) When the report comes up, select Orphaned Files from the drop-down list. HTH, Matthieu -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 1:01 PM To: CF-Talk Subject: OT: Dreamweaver 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
From static to dynamic
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 don't believe it'll take much to fully automate the site, which is what I plan to do, or have done, over the next week or so. Now for my questions: 1. The dynamically-generated pages must remain indexable by search engines. That is, indexing robots must be able to crawl the entire site by following the various links to all of the catalog pages. Do the strings that are passed through the URL appear to search engines as dynamic, and therefore get ignored? 2. It's important that the site remain easily portable from one host to another. I have no plans to move it, but it would be nice to know that it would be a simple matter of plunking it down somewhere else if I needed to. Is there any advantage to using a flat file over a database in terms of portability? How significantly would performance be affected, considering that it's not likely there will ever be more than 1000 rows? I'd be interested in hearing how you'd put this together. Steven ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL
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 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 certificate you would do https://www.mydomain.com/something were something actually is pointing to the other sites web folder so you can make any page secured. or you can point it to one folder. Troy Montour Vampires Inc - Original Message - From: Kwang Suh [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 11:31 AM Subject: Re: SSL 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 certificate. It is possible to get a *.mydomain.com certificate, on a case-by-case basis according to Verisign. - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:29 AM Subject: RE: SSL 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 Subject: OT: SSL 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? ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Updating a graph on the fly?
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: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Fusebox - opinions?
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 developers. 900,000 Hits. Not an accurate guage, but I'd say that entails that the usage is not necessarily all too great. -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 3:18 PM To: CF-Talk Subject: RE: Fusebox - opinions? I'd think that number is kinda small... Compared to what? What would you guess that number was based upon...what was the likely source? Ken ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfsqltype=cf_sql_timestamp
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 [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 7:42 AM To: CF-Talk Subject: cfsqltype=cf_sql_timestamp 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 types, which are actually of bin(8) data types. CF thinks they're date/time, which in my case it certainly isn't. Has anyone successfully managed to pass this varibale type into SQL? Thanks Steve Vosloo Vardus (Pty) Ltd ASKA House Fedsure on Main Main Road Newlands 7700 Cape Town Tel: +27 (0)21 670 9880 Fax: +27 (0)21 674 4549 www.vardus.co.za The information contained in this communication is confidential, may be privileged and is intended for the above named addressee(s). If you are not the intended recipient(s), and have received this communication in error, please contact the sender by replying to this email or by telephoning +27 (0)21 670 9880. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Vardus (Pty) Ltd. ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Browser Detection
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 )# CFPARAM NAME=request.IsGecko DEFAULT = #IIf( CGI.USER_AGENT CONTAINS Gecko, 1, 0 )# CFPARAM NAME=request.IsKonqueror DEFAULT = #IIf( CGI.USER_AGENT CONTAINS Konqueror, 1, 0 )# CFPARAM NAME=request.IsNN DEFAULT = #IIf( request.IsMSIE OR request.IsOpera OR request.IsGecko OR request.IsKonqueror, 0, 1 )# CFPARAM NAME=request.IsMac DEFAULT = #IIf( CGI.USER_AGENT CONTAINS Mac, 1, 0 )# Cheers, -Max At 11/20/2001 11:58 AM -0500, you wrote: Is there a way in CF to detect the clients browser and version or is JS the only way to go? Michael T. Tangorre ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fusebox - opinions?
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 have no patience for the whole thing. OTOH, I highly recommend using a fusebox. The fundamental idea is very useful. To me, the key is to just look at the core concept: cfswitch expression=#fuseaction# cfcase value=showform cfinclude template=myquery.cfm cfinclude template=myform.cfm /cfcase cfcase value=processform cfinclude template=security.cfm cfinclude template=update.cfm cflocation url=index.cfm?fuseaction=showform /cfcase /cfswitch Routing all requests through a central hub creates a handy, self-documenting map of an application's flow, allows modularization without tons of nested includes, and provides a mechanism for turning basic security (or whatever) features on and off on a per-request basis without a lot of conditional or hidden code. Everything else is just extra, and may be completely unnecessary in any given situation. You don't need to move incoming variables into a unified scope, you don't need to nest fuseboxes, you don't need to wrap the whole thing in cf_bodycontent/cfsavecontent and delay rendering, or anything else... there's a ton of benefit to be had from the simple beauty of a CFSWITCH. Not that I'm discouraging use of the extras... there are all kinds of interesting things you can do, above and beyond the basics. But you don't have to use Fusebox and its trappings to make use of a fusebox. -- Roger ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Studio/FB question
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 -Original Message- From: cf refactoring [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 7:54 PM To: CF-Talk Subject: Re: Studio/FB question Studio can be scripted with VBA just like Microsoft Office applications, so you could do that. I'm not sure what the DOM looks like, though. --- Bill Killillay [EMAIL PROTECTED] wrote: I use Fusebox for just about everything and I often find myself reusing a qry, or act files, etc. I was wondering if there was a way to change ColdFusion Studio so that when you drag a file out to a page like fbx_switch that instead of it creating a hyperlink it creates a cfinclude? Can this be done with some scripting? Or is this something that needs to go to Macromedia? Thanks, Bill = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SSL
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 mydomain.com or if it's a completely different domain altogether. If you can't user virtual directories as someone else suggested, then you'll probably just have to replicate content from the other site into local directories. Jim - Original Message - From: Kwang Suh [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:31 AM Subject: Re: SSL 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 certificate. It is possible to get a *.mydomain.com certificate, on a case-by-case basis according to Verisign. - Original Message - From: Garza, Jeff [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 10:29 AM Subject: RE: SSL 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 Subject: OT: SSL 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 at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfsqltype=cf_sql_timestamp
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: cfsqltype=cf_sql_timestamp 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 [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 7:42 AM To: CF-Talk Subject: cfsqltype=cf_sql_timestamp 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 types, which are actually of bin(8) data types. CF thinks they're date/time, which in my case it certainly isn't. Has anyone successfully managed to pass this varibale type into SQL? Thanks Steve Vosloo Vardus (Pty) Ltd ASKA House Fedsure on Main Main Road Newlands 7700 Cape Town Tel: +27 (0)21 670 9880 Fax: +27 (0)21 674 4549 www.vardus.co.za The information contained in this communication is confidential, may be privileged and is intended for the above named addressee(s). If you are not the intended recipient(s), and have received this communication in error, please contact the sender by replying to this email or by telephoning +27 (0)21 670 9880. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Vardus (Pty) Ltd. ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
No cache or page refresh
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 http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Browser Detection
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 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 Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Updating a graph on the fly?
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 to have a graph change as the cursor leaves each field, doing the whole thing in a single page. Is this something I could reasonably get flash to do? Yes, it sounds like you're describing client-side interactivity here, and JavaScript or Flash are strong ways to do this. But as Ryan pointed out, much depends on the type of graph you're making. If you're showing net worth at age 65 then that seems like a single bar, but you may be looking at multiple bars for net worth every five years or so, not sure. (In Flash it's pretty straightforward to resize a movie clip to specific dimensions when selection.getFocus changes, and the filesize will likely be significantly smaller than a DHTML version.) jd John Dowdell, Macromedia Tech Support, San Francisco CA US Search technotes: http://www.macromedia.com/support/search/ Offlist email risks capture by the spam filters. I may not see your email if it's not on the list. Private one-on-one email options are available via Priority Access: http://www.macromedia.com/support/ ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfsqltype=cf_sql_timestamp
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: cfsqltype=cf_sql_timestamp 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: cfsqltype=cf_sql_timestamp 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 [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 7:42 AM To: CF-Talk Subject: cfsqltype=cf_sql_timestamp 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 types, which are actually of bin(8) data types. CF thinks they're date/time, which in my case it certainly isn't. Has anyone successfully managed to pass this varibale type into SQL? Thanks Steve Vosloo Vardus (Pty) Ltd ASKA House Fedsure on Main Main Road Newlands 7700 Cape Town Tel: +27 (0)21 670 9880 Fax: +27 (0)21 674 4549 www.vardus.co.za The information contained in this communication is confidential, may be privileged and is intended for the above named addressee(s). If you are not the intended recipient(s), and have received this communication in error, please contact the sender by replying to this email or by telephoning +27 (0)21 670 9880. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Vardus (Pty) Ltd. ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Fusebox - opinions?
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 an incentive to create accounts, that number is probably pretty low. The point of it is that people ARE standardizing on the free Fusebox framework and that number grows every day. Hell, it's 6191 right now. A friend of mine once told me: You know you're famous when people start suing you. I wouldn't worry too much about people bashing Fusebox. Bad press is still press. In the four years I've been doing this, I've found that people that bash Fusebox tend to bash everything anyway. Very few of them have looked at Fusebox very closely. Tell this guy to join in the Fusebox community and voice his concerns on the Fusebox list. The Fusebox community listens to ideas, if they're good ones, we add them into the spec. Nothing will get changed by voicing concerns on cf-talk. - Steve Nelson Joseph DeVore VeloxWeb Technologies -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 3:07 PM To: CF-Talk Subject: RE: Fusebox - opinions? Here's a quote from fusebox.org: Fusebox is a FREE web application standard in use by 6174 people from around the world 6174. Around the world. Hmmm... I know there's 100 or so active cfug members in Vancouver, BC. Given the amount of metropolitan areas in US and Canada, not to mention parts of Europe, I'd think that number is kinda small... -Original Message- From: Zac Belado [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 2:26 PM To: CF-Talk Subject: RE: Fusebox - opinions? I think the difference is that there is a good chance that an outside contractor might already know Fusebox. That won't be the case for something custom. Maybe this is a regional thing but none of the developers I know use Fusebox at all. Just how many people actively use fusebox? I hear people mention that developers or contractors will be familiar with it but has anyone ever done any sort of polling to determine this? If not its mostly just an anecdotal comment isn't it? ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Stored Procedure Question
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 EventDate @TodayDate Order By EventDate, EventTime GO I have my CF code as such: !--- Setting the date for 30 days out from today. --- cfset Next30 = DateAdd(d, +30, #DateFormat(CreateODBCDate(Now()))#) cfstoredproc datasource=#Attributes.DataBase# procedure=Next30Days cfprocparam cfsqltype=CF_SQL_DATE dbvarname=@Next30 type=In value=#Next30# cfprocparam cfsqltype=CF_SQL_DATE dbvarname=@TodayDate type=In value=#DateFormat(CreateODBCDate(Now()))# cfprocresult name=Next30Days /cfstoredproc And I get this in my browser: ODBC Error Code = S1C00 (Driver not capable) [Microsoft][ODBC SQL Server Driver]Optional feature not implemented SQL = Next30Days Data Source = EVENTS I have poured over this SP and the CF code and I cannot see why I am receiving this. I know that my SQl 2K is working fine because I have other tables with several (over 100 so far) SP and they all work fine. Thanks, ~~ 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: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Stored Procedure Question
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 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 FROM Calendar Where EventDate @Next30 And EventDate @TodayDate Order By EventDate, EventTime GO I have my CF code as such: !--- Setting the date for 30 days out from today. --- cfset Next30 = DateAdd(d, +30, #DateFormat(CreateODBCDate(Now()))#) cfstoredproc datasource=#Attributes.DataBase# procedure=Next30Days cfprocparam cfsqltype=CF_SQL_DATE dbvarname=@Next30 type=In value=#Next30# cfprocparam cfsqltype=CF_SQL_DATE dbvarname=@TodayDate type=In value=#DateFormat(CreateODBCDate(Now()))# cfprocresult name=Next30Days /cfstoredproc And I get this in my browser: ODBC Error Code = S1C00 (Driver not capable) [Microsoft][ODBC SQL Server Driver]Optional feature not implemented SQL = Next30Days Data Source = EVENTS I have poured over this SP and the CF code and I cannot see why I am receiving this. I know that my SQl 2K is working fine because I have other tables with several (over 100 so far) SP and they all work fine. Thanks, ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: SSL
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 valid for *.mydomain.com, or only mysite.mydomain.com? ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Stored Procedure Question
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 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 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 FROM Calendar Where EventDate @Next30 And EventDate @TodayDate Order By EventDate, EventTime GO I have my CF code as such: !--- Setting the date for 30 days out from today. --- cfset Next30 = DateAdd(d, +30, #DateFormat(CreateODBCDate(Now()))#) cfstoredproc datasource=#Attributes.DataBase# procedure=Next30Days cfprocparam cfsqltype=CF_SQL_DATE dbvarname=@Next30 type=In value=#Next30# cfprocparam cfsqltype=CF_SQL_DATE dbvarname=@TodayDate type=In value=#DateFormat(CreateODBCDate(Now()))# cfprocresult name=Next30Days /cfstoredproc And I get this in my browser: ODBC Error Code = S1C00 (Driver not capable) [Microsoft][ODBC SQL Server Driver]Optional feature not implemented SQL = Next30Days Data Source = EVENTS I have poured over this SP and the CF code and I cannot see why I am receiving this. I know that my SQl 2K is working fine because I have other tables with several (over 100 so far) SP and they all work fine. Thanks, ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Stored Procedure Question
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 passing DateTime parameters. That should at least get your sp working again. I got fed up with trying to figure out what the whole cfstoredprocedure tag is doing . That is one of the things I don't like about ColdFusion because sometimes it is very hard to find out what is happening in cases as this. - Original Message - From: Bruce Sorge [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, November 20, 2001 2:27 PM Subject: Stored Procedure Question 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 FROM Calendar Where EventDate @Next30 And EventDate @TodayDate Order By EventDate, EventTime GO I have my CF code as such: !--- Setting the date for 30 days out from today. --- cfset Next30 = DateAdd(d, +30, #DateFormat(CreateODBCDate(Now()))#) cfstoredproc datasource=#Attributes.DataBase# procedure=Next30Days cfprocparam cfsqltype=CF_SQL_DATE dbvarname=@Next30 type=In value=#Next30# cfprocparam cfsqltype=CF_SQL_DATE dbvarname=@TodayDate type=In value=#DateFormat(CreateODBCDate(Now()))# cfprocresult name=Next30Days /cfstoredproc And I get this in my browser: ODBC Error Code = S1C00 (Driver not capable) [Microsoft][ODBC SQL Server Driver]Optional feature not implemented SQL = Next30Days Data Source = EVENTS I have poured over this SP and the CF code and I cannot see why I am receiving this. I know that my SQl 2K is working fine because I have other tables with several (over 100 so far) SP and they all work fine. Thanks, ~~ 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/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
