Re: ot: lcd monitors

2004-12-20 Thread Andy Jarrett
Hi Dave, I managed to get hold of a Compaq 7020 which has been really good to me. With DV input and built in speakers which was a must for me. Andy J www.andyjarrett.co.uk On Sat, 18 Dec 2004 18:07:17 -0500, dave [EMAIL PROTECTED] wrote: any recommends on a 17 lcd? and not a $1000 one either

Re: ColdFusion security framework

2004-12-20 Thread The Wolf
On 12/10/04 6:58 PM, Jim Davis wrote: I've uploaded a zip of the CFCs involved to: ftp://ftp.depressedpress.com/FTP/cfc_DepressedPress.zip I am trying to understand your code, but it's a bit hard w/o knowing the db tables and relationships ... Can you provide the db schema (e.g. Erwin) and

OT: SQL

2004-12-20 Thread Andy Jarrett
Hi there, I am have a table with user id and grade SQL statement. THe Table is - userid | grade 1 | pass 1 | pass 1 | pass 2 | fail 2 | pass 3 | pass 4 | pass 4 | fail 5 | pass The output shows bascially whether the user has passed all courses. So user 1 would be an overall 'Pass' mark as all

time to cluster, I thinkL

2004-12-20 Thread Katz, Dov B (IT)
I'm thinking about clustering I read some of the articles on this (bpurcells, and others, etc) and I'm still a bit confused about which is the best way for Entry Level / simple clustering. Right now I have 1 CFMX6.1 Pro license and a single IIS box, sharing MSSQL2K with CF over 2 1Ghz

Re: OT: SQL

2004-12-20 Thread Mark Drew
Whats the question? On Mon, 20 Dec 2004 11:50:34 +, Andy Jarrett [EMAIL PROTECTED] wrote: Hi there, I am have a table with user id and grade SQL statement. THe Table is - userid | grade 1 | pass 1 | pass 1 | pass 2 | fail 2 | pass 3 | pass 4 | pass 4 | fail 5 | pass The

Re: OT: SQL

2004-12-20 Thread Andy Jarrett
Opps badly worded post sorry. Im trying to create a QoQ SQL statement that would return whether user 1 has passed or failed by checking that all his grades are passes? I've just been playing with another method were i am using the QoQ to return the users marks then just by checking that the

Re: OT: SQL

2004-12-20 Thread Joe Rinehart
Hey Andy, Instead of seeing if they're all Pass, why not just see if there are any failed? For user 1: cffunction name=userFailed returntype=boolean cfargument name=qGrades type=query cfargument name=userId type=numeric cfset var qGetGrades = / cfquery dbType=query name=qGetGrades

RE: SQL

2004-12-20 Thread Pascal Peters
I don' think you can get those who passed and failed in the same query using QofQ. Getting those who failed is easy: cfquery name=qOverall dbtype=query SELECT DISTINCt userid FROM q WHERE pass = 'fail' /cfquery Then you can use your first query and CF to display passed and failed: PaAscal

Re: OT: SQL

2004-12-20 Thread Mark Drew
Or you could Count(mark) where it equals fail and count where it equals pass total them and there you go :D On Mon, 20 Dec 2004 07:41:15 -0500, Joe Rinehart [EMAIL PROTECTED] wrote: Hey Andy, Instead of seeing if they're all Pass, why not just see if there are any failed? For user 1:

Re: How to detect if a session has timed out?

2004-12-20 Thread mark brinkworth
While not comletely foolproof I have done using a cookie that keeps track of the clients view of whether they are logged in or not. If the cookie says they are logged in, but there is no session, then the session has timed out. Just need to set it to something to indicate they are logged in,

Re: css - height 100% - i'd like to kill the crack-addicts who wrote the w3c box model

2004-12-20 Thread Keith Gaughan
S.Isaac Dealey wrote: S.Isaac Dealey wrote: Mime-Version: 1.0 Content-Type: text/plain so after all this time, there's still no standard that allows an adequate means of specifying something as simple as height 100% ... because according to the w3c, 100% of the height of an airplane

Re: OT: SQL

2004-12-20 Thread Andy Jarrett
Joe, Sorry, but to add to your solution another problem ( i don't do this on purpose, promise). It will also return 0 where the is no user there, in which case you get a false positive. Mark, you'd have to do the counts as 2 different SQL's statements which was something i was trying to avoid.

updating my date_added from a form fails

2004-12-20 Thread Daniel Kessler
I have an Oracle database with a record where when I update it with now() it works. From that point on, for editing, I carry the date_added through a hidden form field which has the source of INPUT TYPE='Hidden' NAME='date_added' VALUE='2004-12-20 08:50:51.0' When I try and use that hidden

Re: updating my date_added from a form fails

2004-12-20 Thread Charlie Griefer
try wrapping Form.date_added in a createODBCDateTime() function (or just a createODBCDate() if you don't need time). On Mon, 20 Dec 2004 09:03:27 -0500, Daniel Kessler [EMAIL PROTECTED] wrote: I have an Oracle database with a record where when I update it with now() it works. From that point

Re: time to cluster, I thinkL

2004-12-20 Thread Jochem van Dieten
Katz, Dov B (IT) wrote: I'm thinking about clustering I read some of the articles on this (bpurcells, and others, etc) and I'm still a bit confused about which is the best way for Entry Level / simple clustering. Right now I have 1 CFMX6.1 Pro license and a single IIS box, sharing

Re: css - height 100% - i'd like to kill the crack-addicts who wrote the w3c box model

2004-12-20 Thread S . Isaac Dealey
S.Isaac Dealey wrote: S.Isaac Dealey wrote: Except that with the w3c box model there are still a small number of very simple things which are ... I hate to say it, but _FLAT_IMPOSSIBLE_ to accomplish. Whereas this is not the case with the MS box model. An example would be helpful. You

Re: updating my date_added from a form fails

2004-12-20 Thread daniel kessler
Thanks Charlie, that worked great. I guess I assumed that since form value number works fine as a number, date would do the same. Guess it works this way since date is more complex. I appreciate the help. May your code go smoothly today. try wrapping Form.date_added in a createODBCDateTime()

RE: time to cluster, I thinkL

2004-12-20 Thread Katz, Dov B (IT)
Sorry for not making clearer My problem now is heavy load, and general risk of availability by having a SPoF. Both would be mitigated by a more load balanced, redundant system... -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004

Re: time to cluster, I thinkL

2004-12-20 Thread Michael Dinowitz
I'm going to be blasted for this, but clustering is the last resort, not first. 1. Do you have seperate boxes for DB and webserver? (no) 2. Are they maxed in ram? (probably) 3. Are they peaked? (?) 4. Is your network set up tight? (no as it's one server) Just moving the SQL to a new box will

Re: time to cluster, I thinkL

2004-12-20 Thread Anthony Cooper
IMHO I think the first step, assuming you only have a budget for 1 extra machine, would be to move your MSSQL installation onto a separate box to free up some more resources for CF. This'll save you a bit too as you should have most of the software licenses you need too. After you've done that

RE: time to cluster, I think

2004-12-20 Thread Katz, Dov B (IT)
I hear you... So let me give this a try and see if things get any better. Assuming both boxes are on the same network, do you see any network latency cost involved? -Dov -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 9:26 AM To:

Re: time to cluster, I thinkL

2004-12-20 Thread Jochem van Dieten
Katz, Dov B (IT) wrote: Sorry for not making clearer My problem now is heavy load Moving the database to a separate box from the application / webserver would be the first step. general risk of availability by having a SPoF. It is better to have a SPoF with 99.8% uptime then 2 systems

Re: time to cluster, I think

2004-12-20 Thread Michael Dinowitz
This is how I'd do it. The web server has 2 nic cards. The first is set to the external network only and is used for traffic. The second is set to internal only and is used to transfer data to the box from the SQL. This removes excess traffic from the network. The 'net stuff' should be on it's

RE: time to cluster, I think

2004-12-20 Thread Matthew Small
You could do that with a crossover cable from the Web server to the DB server, right? No need for extra switches or anything like that. - Matt Small -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 9:53 AM To: CF-Talk Subject: Re: time

RE: time to cluster, I think

2004-12-20 Thread Dave Watts
I'm thinking about clustering I read some of the articles on this (bpurcells, and others, etc) and I'm still a bit confused about which is the best way for Entry Level / simple clustering. Right now I have 1 CFMX6.1 Pro license and a single IIS box, sharing MSSQL2K with CF over 2 1Ghz

RE: time to cluster, I think

2004-12-20 Thread Dave Watts
You could do that with a crossover cable from the Web server to the DB server, right? No need for extra switches or anything like that. Yes, I'm sure you could. However, within these sorts of environments, typically there's an internal network used for hosting databases and other internal

RE: time to cluster, I think

2004-12-20 Thread Dave Watts
It is better to have a SPoF with 99.8% uptime then 2 systems with 95% uptime each :-) I'm not sure I'd agree with that, as long as only one system is down at any given time! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444

cftree on client

2004-12-20 Thread Ken
Hi all. Is there a way to let the users select files on their own file system and upload them. I am not talking about the browse button that you get with cffile. Something similar to cftree, but on the client side. thanks. ~|

RE: time to cluster, I think

2004-12-20 Thread Katz, Dov B (IT)
Thanks for all the valuable input. I've been improving the code, but it seems that growth of usership is constantly outpacing me (which is a good thing, I guess). I had written something much like the CF_Accelerate tag by brandon purcell, but mine can take a mode parameter to store to File

RE: updating my date_added from a form fails

2004-12-20 Thread Pascal Peters
Or even better, use cfqueryparam -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 20 December 2004 15:09 To: CF-Talk Subject: Re: updating my date_added from a form fails try wrapping Form.date_added in a createODBCDateTime() function (or just a

RE: ColdFusion security framework

2004-12-20 Thread Jim Davis
-Original Message- From: The Wolf [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 6:46 AM To: CF-Talk Subject: Re: ColdFusion security framework On 12/10/04 6:58 PM, Jim Davis wrote: I've uploaded a zip of the CFCs involved to:

Re: updating my date_added from a form fails

2004-12-20 Thread Charlie Griefer
i still wrap date/time values in createODBCDate() functions inside of cfqueryparam tags. probably overkill, but old habits and all... :) On Mon, 20 Dec 2004 16:11:47 +0100, Pascal Peters [EMAIL PROTECTED] wrote: Or even better, use cfqueryparam -Original Message- From: Charlie

Re: cftree on client

2004-12-20 Thread Joe Rinehart
Ken, No - ColdFusion is purely server-side, and can't do anything with the client's filesystem. Using the input type=file name=...'s Browse button will show you whatever their client browser's default mode of handling it is, which in Windows will be the open file dialog. This is the 'tree' most

Re: updating my date_added from a form fails

2004-12-20 Thread Deanna Schneider
Why are you even updating it - if you're just setting it back to the same created date? Also, you can use oracles default sysdate right in your table definition so that you don't have to add a date at all - if you are really just tracking the added date and not the updated date. -

Re: css - height 100% - i'd like to kill the crack-addicts who wrote the w3c box model

2004-12-20 Thread Keith Gaughan
S.Isaac Dealey wrote: S.Isaac Dealey wrote: S.Isaac Dealey wrote: Except that with the w3c box model there are still a small number of very simple things which are ... I hate to say it, but _FLAT_IMPOSSIBLE_ to accomplish. Whereas this is not the case with the MS box model. An example would be

Re: time to cluster, I think

2004-12-20 Thread Michael Dinowitz
Actually, I was suggesting to throw more ram at the machine and seperate the webserver from the SQL. While I do like tight code and DB, it's not the first thing to add; Ram is. I have 5 levels of optimization: 1. Code 2. DB structure 3. Hardware 4. Network 5. Server settings Code and DB take

Re: time to cluster, I thinkL

2004-12-20 Thread Sean Corfield
On Mon, 20 Dec 2004 09:26:18 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: I'm going to be blasted for this, but clustering is the last resort, not first. I would be surprised if anyone blasts you. 1. Do you have seperate boxes for DB and webserver? (no) This would be the first thing I'd

Dynamic Forms Help

2004-12-20 Thread Pedro Mendes
Hello all, In a CFFORM I have a dynamically populated CFSELECT that generates a list of entities, where value = NUMBER (of entity) and display = NAME (of entity) What I am trying to do is paste the name of the selected entity into a TEXTAREA below, depending on the selection. Is this

Re: time to cluster, I thinkL

2004-12-20 Thread Al Musella, DPM
Why do you want to cluster? If it is for reliability, then that is ok. But if you need speed, you may be best off just putting the IIS/CF on one computer and the MSSQL2K on the other computer, since you already have one license of each. The computers are cheaper than the licenses. If you do

Re: Dynamic Forms Help

2004-12-20 Thread Charlie Griefer
dunno if the cfform generated code will affect this, but try adding the following to your cfselect tag: onchange=this.form.TEXTAREA_NAME.value = this.options[this.selectedIndex].text On Mon, 20 Dec 2004 16:07:49 -, Pedro Mendes [EMAIL PROTECTED] wrote: Hello all, In a CFFORM I have a

RE: time to cluster, I thinkL

2004-12-20 Thread Burns, John D
Continuing down this line of questioning, what kind of numbers are you all experiencing when you're having to split to separate servers, go to multiple machines, etc? I'm just curious how many hits these sites are getting that you're seeing bad enough performance to warrant this. Might help me in

Need help with summary report, please

2004-12-20 Thread Claremont, Timothy
I have a table where 25 codes are captured. The underlying columns in the database are: Code1 Code2 .. .. Code25 I need to extract a list of DISTINCT values entered in ALL of the columns, and the count of each of those values across all 25 columns. Note that it is possible to have NO value in a

RE: time to cluster, I thinkL

2004-12-20 Thread Katz, Dov B (IT)
On the heavy site, exceeding 600k page views a day, and pages are pretty large - www.onlysimchas.com Rightnow it's stable, but it spikes to 90-95% cpu during high load times... Moving the DB will probably bring me some more stability while the internals get more renovation.. -dov -Original

Re: time to cluster, I thinkL

2004-12-20 Thread Jochem van Dieten
Burns, John D wrote: Continuing down this line of questioning, what kind of numbers are you all experiencing when you're having to split to separate servers, go to multiple machines, etc? It isn't so much about having to split, but wanting to split. I don't want to run a database server on

Re: JS issue

2004-12-20 Thread Greg Morphis
Yeah it was the missing return in the function call. I didnt want the onSubmit because this form had 2 submit buttons. I needed this to be a separate function, however that got it and I appreciate it! On Fri, 17 Dec 2004 15:54:57 -0500, Ray Champagne [EMAIL PROTECTED] wrote: How are you

Hey, question about Dreamweaver, Fireworks, checking out files, etc...

2004-12-20 Thread Jeff Small
Is there a way that anyone knows of, for you to somehow link your site with fireworks? If I keep a PNG file in a library folder in my site, I check the source PNG file in, so that if anyone needs to change the PNG file, they have to check it out, just like pages within the site, etc. But that

RE: time to cluster, I thinkL

2004-12-20 Thread Emmet McGovern
We have a cluster setup for one of our clients using enterprise and hardware loadbalancing. The sql servers are on internal IP's routing traffic through the secondary nic on the webservers. The site gets roughly 10-16000 visits per day with around 50,000 page views. Every page hits the

Question from a beginner on visible invisible divs

2004-12-20 Thread John Munyan
Hi, I am hoping someone can point me to a tutorial or link(s) explaining how I might be able to created visible/invisible divs. My navigation system is made up a myriad of hikes broken down into categories. I would like to create functionality that presents the page collapsed showing the

Force user to the login page automatically

2004-12-20 Thread Asim Manzur
I have an Application.cfm which timeout the session in 15 min. How is it possible to redirect the user to the logout page automatically when the session expires. i.e. user is on add.cfm page. and he left the screen there and came back to computer after 25 min and he is still on this page. he

RE: time to cluster, I thinkL

2004-12-20 Thread Ben Rogers
In addition, a default install of SQL Server, for instance, will pre-allocate just about all system resources to the SQL Server instance or balance them out among multiple instances. This provides performance benefits over a model in which resources have to be allocated on the fly. From my

RE: time to cluster, I thinkL

2004-12-20 Thread Katz, Dov B (IT)
With a lot of traffic (At least for my website), it practically pays for dedicated hosting. -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:08 PM To: CF-Talk Subject: RE: time to cluster, I thinkL We have a cluster setup for one of

Test Posting

2004-12-20 Thread Gerald Hurst
My last posting did not work, I think. So, I am testing my ability to post. Jerry ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message:

RE: Force user to the login page automatically

2004-12-20 Thread Emmet McGovern
Use a timed javascript redirect. Set the timeout length the same as the session length. You could even do it with a meta refresh. emmet -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:15 AM To: CF-Talk Subject: Force user to the login

Re: Question from a beginner on visible invisible divs

2004-12-20 Thread Greg Morphis
What you want is the display attribute. Divs display is normally set at inline IE div id='divBlock' style=display:block; You can set this to none using JS. document.getElementById('divBlock').style.display='none'; and to set it back document.getElementById('divBlock').style.display='inline'; I

database query

2004-12-20 Thread Ray Champagne
I have two tables in my DB: Companies: company_ID (PK) company_name etc Contacts: contact_company_FK (FK linked to company_ID) contact_name etc What I need to do is query the DB and get all the companies and all the contacts associated with that company, even if there are no contacts for a

Re: Test Posting

2004-12-20 Thread Ray Champagne
You are able. At 11:23 AM 12/20/2004, you wrote: My last posting did not work, I think. So, I am testing my ability to post. Jerry ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net

RE: time to cluster, I thinkL

2004-12-20 Thread Katz, Dov B (IT)
With a lot of traffic (At least for my website), it practically pays for dedicated hosting. On a side note... I noticed you have google adwords. Has it been worth the real estate? Emmet NOTICE: If received in error, please destroy and

RE: time to cluster, I thinkL

2004-12-20 Thread Emmet McGovern
Thanks... I always wondered. I own a couple of hi traffic travel portals for our area and was hesitant to give advertising space up for something like that. e -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:18 PM To: CF-Talk

Re: Question from a beginner on visible invisible divs

2004-12-20 Thread Bryan Stevenson
A quick Google search will find all the info you need on hide/show div. I'd carefully consider your desired navigation If you have 100's of hike you would have to load ALL of them in ONE RQUEST to populate all the hidden divs. That could really suck if these hikes are highly

Re: Force user to the login page automatically

2004-12-20 Thread Asim Manzur
You mean to put the blow code in application.cfm?? InvalidTag language=JavaScript!-- setTimeout('Redirect()',4000); function Redirect() { location.href = '../htmljavascript.htm'; } // --/script Use a timed javascript redirect. Set the timeout length the same as the session length. You

HTTP header containing CFID cookie is being ignored

2004-12-20 Thread Gerald Hurst
My CFM pages are a simple HTML form and a response page containing enough CFML to display CFID, CFTOKEN, and a CLIENT variable or two. These pages work exactly as expected in Internet Explorer and I have watched the HTTP header traffic here and this is also as expected. These pages do not work as

RE: database query

2004-12-20 Thread Emmet McGovern
Select company_ID, company_name, contact_company_FK, contact_name From companies LEFT OUTER JOIN Contacts ON company_ID = contact_company_FK Or RIGHT -e -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 12:23 PM To: CF-Talk Subject:

RE: Force user to the login page automatically

2004-12-20 Thread Emmet McGovern
Sure, or in the header if its shared amongst all the pages. -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 11:32 AM To: CF-Talk Subject: Re: Force user to the login page automatically You mean to put the blow code in application.cfm??

RE: database query

2004-12-20 Thread Ray Champagne
Yea, that is what I did, but keep getting an error saying Join not supported Here is a copy of the error message I get: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Join expression not supported. The error occurred

Re: Question from a beginner on visible invisible divs

2004-12-20 Thread Michael Traher
This is more of a general HTML/Dynamic HTML/javascript type question rather than CF, so there might be better forums for this question. There are proabaly several ways to do this but here is one. Give your div an id attribute with a unique name. Say div id=hike1 and also give it a style

Advertising Re: time to cluster, I thinkL

2004-12-20 Thread Michael Dinowitz
I've found that its worth it based on size and placement. I have the HoF site set to 760 wide content with the remainder as ads. These are seen by most without getting in the way of content. Thanks... I always wondered. I own a couple of hi traffic travel portals for our area and was

Re: updating my date_added from a form fails

2004-12-20 Thread daniel kessler
Why are you even updating it - if you're just setting it back to the same created date? Also, you can use oracles default sysdate right in your table definition so that you don't have to add a date at all - if you are really just tracking the added date and not the updated date. I'm updating

Re: time to cluster, I thinkL

2004-12-20 Thread Umer Farooq
Just my two cents.. We currently run couple of sites that do about.. constant 7Mbps on single CPU 3GB RAM CFMX Pro Server. The system crahses out at around 18-20Mbps (days after Thanksgiving) DB is on a seperate box and seperate nic.. When doing cost estimates keep in mind the

Can cfmail scale?

2004-12-20 Thread Victor Moore
Hi, I was wondering if CFMX 6.1 Enterprise can be used as a platform for relative large number of emails to be sent in a short period of time. This is not for spamming but to notify customers if the service they had subscribed to is being disrupted. They estimate the need to send up to 120K

Re: Can cfmail scale?

2004-12-20 Thread Raymond Camden
One of the big selling points of MX was the speedier email. I _believe_ the quote was 1 million emails an hour for CFMX Enterprise. On Mon, 20 Dec 2004 13:07:00 -0500, Victor Moore [EMAIL PROTECTED] wrote: Hi, I was wondering if CFMX 6.1 Enterprise can be used as a platform for relative

Re: database query

2004-12-20 Thread Greg Morphis
Try: Select company_ID, company_name, contact_company_FK, contact_name From companies, Contacts Where company_ID(+) = contact_company_FK On Mon, 20 Dec 2004 12:37:24 -0500, Ray Champagne [EMAIL PROTECTED] wrote: Yea, that is what I did, but keep getting an error saying Join not supported

Re: Can cfmail scale?

2004-12-20 Thread Umer Farooq
Yes. No problem. However the bottleneck most likly won't be CFMX but your mail server. Make sure to check off.. Maintain connection to SMTP server -- Regards, Farooq Victor Moore wrote: Hi, I was wondering if CFMX 6.1 Enterprise can be used as a platform for relative large number of

RE: Can cfmail scale?

2004-12-20 Thread Ben Forta
Correct, back before 6.1 shipped we clocked Enterprise at over 1,000,000 messages an hour on a dual-CPU box. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004 1:16 PM To: CF-Talk Subject: Re: Can cfmail scale? One of the big selling

Re: database query

2004-12-20 Thread Ray Champagne
Yea, it doesn't like that either. From my Googling, I have found that Access doesn't like the join clause syntax (duh) but I have yet to find the solution. Ray At 01:16 PM 12/20/2004, you wrote: Try: Select company_ID, company_name, contact_company_FK, contact_name From companies, Contacts

Re: Can cfmail scale?

2004-12-20 Thread Victor Moore
I have read the article and that's the reason I thought that CFMX might work. Can multiple email servers be specified or just the one (and backup) in CFadmin? What will be a decent hardware platform to support this? Are there any white papers on this? Thanks Victor On Mon, 20 Dec 2004 13:18:33

RE: database query

2004-12-20 Thread Dave Watts
From my Googling, I have found that Access doesn't like the join clause syntax (duh) but I have yet to find the solution. I don't work with Access much, but I'm pretty sure it does in fact support explicit JOIN syntax. I would recommend that you try creating the query within Access' own query

RE: Can cfmail scale?

2004-12-20 Thread Ben Forta
Victor, no, not multiple. Backup (failover) servers may be specified. The key to successfully sending a large volume of mail is to allocate enough mail processing threads, make sure the mail server can handle concurrent logins and all those threads, and keep SMTP connections open.

RE: css - height 100% - i'd like to kill the crack-addicts who wrote the w3c box model

2004-12-20 Thread Ben Rogers
Well, your problems are manyfold. Firstly, you're depending on behaviour that was never mandated in the specs, that being that a height of 100% means 100% of the available window area or available area. I don't think he's depending on this behavior. He's lamenting the fact that CSS doesn't

RE: database query

2004-12-20 Thread Ray Champagne
Hey everyone: Thanks for the pointers and tips. I found the problem. It was painfully simple. I needed to specify which table I wanted to pull the fields from. I still have to get the select all out of there and only pull what I need, but here is the working query statement: cfquery

Re: Can cfmail scale?

2004-12-20 Thread Umer Farooq
No.. just single and the backup(enterprise only) Whitepaper on the performance.. the hardware used in it.. from todays.. standard is nothing.. my desktop is 3x better :-).. but gives you an idea.. of the power..

help! cfobject and abcpdf

2004-12-20 Thread Eric McCormick
hi all - newbie in desperate need of step-bystep instructions on how to install/register the abcpdf object and how to call it with cfobject using CF5 on windows 2k. ~| Special thanks to the CF Community Suite Silver Sponsor -

RE: database query

2004-12-20 Thread Emmet McGovern
Hah... I was just about to post that you need a where clause. I've been messing with it for the last half hour! I need to ban list reading during work hours. I want my 1/2 hour back! -e -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, December 20, 2004

Plum V1.0 Release Candidate is now available for download

2004-12-20 Thread Adam Churvis
Productivity Enhancement today released the Release Candidate of its new product, Plum, which combines a code generator with a comprehensive application framework and an effective rapid development methodology. Plum can build a complete website with full administrative control over a large

RE: database query

2004-12-20 Thread Ray Champagne
LOL...thanks for your efforts! Are u subscribed to the cf-community list? If not, and you're prone to getting distracted easily, I would not recommend it. I lose hours sometimes, then end up having to make the lost time up later in the day. People with ADD (I suspect I have it) should steer

Re: JS issue

2004-12-20 Thread Larry White
Just curious, but don't you have to convert the form fields to date objects before they can be compared like that? Or are they in a format so they can be compared as strings? Yeah it was the missing return in the function call. I didnt want the onSubmit because this form had 2 submit buttons. I

Re: JS issue

2004-12-20 Thread Greg Morphis
Not sure but it works just like that, no converting needed. I was thinking that it would have to be date objects myself but hit that submit on accident and it worked so I havent fooled with it. The dates will be in a mm/dd/ or m/d/yy or m/d/yy or mm/dd/yy format, not sure if that helps or not.

cfobject and abcpdf

2004-12-20 Thread McCormick, Eric
hi all - please help a newbie. i've never registered a com object on my cf server and i don't know how to call it from the cfobject tag. i could really use some step-by-step instructions. thanks so much, eric ~| Special

Re: JS issue

2004-12-20 Thread Larry White
You may want to try comparing something like 9/10/04 and 11/10/04 and see if it works correctly. Datewise, of course Nov is after Sept, but alphabetically 9 would sort higher than 1. It may be by accident the two strings you submitted worked out OK, but not all of them will. Not sure but it

RE: cfobject and abcpdf

2004-12-20 Thread Dave Watts
i've never registered a com object on my cf server and i don't know how to call it from the cfobject tag. You register COM DLLs using regsvr32.exe, which you can call from the command line like so: regsvr32 mydll.dll As for the rest, the specifics will depend on the COM object in question.

Plum

2004-12-20 Thread Adam Churvis
If any of you had a problem with requesting a Beta License Key for the Plum Release Candidate, the problem has now been fixed (I forgot to add the new version to the Licensing Wizard). Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download

Re: JS issue

2004-12-20 Thread Greg Morphis
Doh! good call! I added.. var sDate=new Date(document.siteReferrals.StartDate.value); var eDate=new Date(document.siteReferrals.EndDate.value); and then compared sDate to eDate and this fixed it.. Thanks a bunch! On Mon, 20 Dec 2004 14:21:58 -0400, Larry White [EMAIL PROTECTED]

Re: How to detect if a session has timed out?

2004-12-20 Thread Larry White
It depends on how you are handling the logout. If on login you set Session.Userid, for example, to their true userid and on logout you set it to something like '9', that could flag the fact they have logged out but their session has not expired. Just closing the browser doesn't necessarily

Datestamp

2004-12-20 Thread Jason Smith
After switching a cold fusion application from an access database to mysql I have some strange problems that I am not 100% sure on. Image issues no thumbnails showing up I assume it's related to the original storage location of the images. However one issue I can't seem to correct and has me

Re: Datestamp

2004-12-20 Thread Barney Boisvert
Use CFQUERYPARAM and your problems will vanish. MySQL is picky about using strings as date literals, so it's getting screwed up. CF formats the default MySQL date value (-00-00 00:00:00) as 11/30/02 for some reason. If you look in the DB, it'll be all zeros though. cheers, barneyb On Mon,

Re: database query

2004-12-20 Thread Deanna Schneider
Ray, use the Access query builder wizard. Select your two tables. If the join line between them doesn't show up automatically, drag the field you want to join from one table to the other. Right click on the line and read the join options. One of the three should be the join you're looking for.

AW: AW: IgniteFusion anyone?

2004-12-20 Thread Gert Franz
Beta will be out in January, and we already use it in a production environment... Cheers Gert -Ursprüngliche Nachricht- Von: Ryan Jones [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 17. Dezember 2004 08:50 An: CF-Talk Betreff: Re: AW: IgniteFusion anyone? Gert, is Railo ready for a

Re: ColdFusion security framework

2004-12-20 Thread The Wolf
On 12/20/04 4:17 PM, Jim Davis wrote: Is that what you're looking for? Yes, thanks for the hint! Your security framework is probably very good, but a bit too complex for my needs, I am trying to come up with an easier one for my requirements... Thanks.

Major PHP flaw??

2004-12-20 Thread Bryan Stevenson
Hey All, I just had this sent to me from a local ISP, but without any specificsanybody know anything? I must say it's nice to see that it's no effecting Windows Servers for a change ;-) ~| Special thanks to the CF

Re: Major PHP flaw??

2004-12-20 Thread Bryan Stevenson
and the line monster ate ithere we go for try # 2: Security Notice: There has been an anouncement of a serious security problem with all current versions of PHP, a scripting language that you may be using on your site. PHP is used for many free forum, message board and link management

ColdFusion built-in tags and permission-based security framework

2004-12-20 Thread The Wolf
Hi all, I need to implement a new security framework for my ColdFusion applications (CMS, etc.). I used a role-based security model in the past and I found it too strict, that's why I would like to implement a permission-based security framework now. Check out the following article about the

  1   2   >