cfset and figuring percentages..

2004-07-19 Thread techmike
Okay, I'm familier with doing simple math with cfset but how can I find a percentage with it? Or is there a better way? I just need to figure what percentage varible a is of variable b.. -mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations

Re: cfset and figuring percentages..

2004-07-19 Thread techmike
e: Mon, 19 Jul 2004 08:42:43 -0700 Subject: Re: cfset and figuring percentages.. > > > Ta Da! ;-) > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > >   -

Re: cfset and figuring percentages..

2004-07-19 Thread techmike
categories (like Math) the large list > of CF functions...good read...hehe > > Cheers > > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > >   - Original

Small query question..

2004-07-28 Thread techmike
    SELECT *     FROM #tablename#     WHERE "#url.date#"     ORDER by date     LIMIT 31     (In my testing #url.date# is 03-01-04) Does anyone see a problem with the above query that would cause me to get the first 31 results instead of the 31 results after the WHERE statement?   Rather, I get

Re: Small query question.. (Updated, SQL Syntax)

2004-07-28 Thread techmike
Thats how I normally pull one result..  I guess when I left off the column = it was completely ignoring the WHERE line.. So I guess my whole problem is in my MySQL syntax.. How would one normally return a range of results then..  Ultimatly I'm trying to get all the results for one month.  I can

Re: Small query question.. (Updated, SQL Syntax) (solved)

2004-07-28 Thread techmike
Got it.. WHERE date >= "03-01-04" AND date <= "03-31-04" did what I needed.. -mike -Original Message- From: "techmike" <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Wed, 28 Jul 2004 12:02:27 -0400 Subject: Re: Small query

cfmail and SMTP authentication?

2004-08-19 Thread techmike
Is it possible to use a SMTP server that requires authentication with the cfmail tag? Excuse me for not just googleing it, but I'm stuck behind a proxy at work. -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

RE: cfmail and SMTP authentication?

2004-08-19 Thread techmike
CTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Thu, 19 Aug 2004 10:13:43 -0500 Subject: RE: cfmail and SMTP authentication? > I would imagine that: cfmail's username="usernamevaluehere" and > password="passwordvaluehere" attributes should work just fine for that &g

Re: CFMAIL not sending

2004-08-20 Thread techmike
I assume you have the server specified in CF Admin? Problem I ran into the other day was my server requires SMTP authentication which MX 6.0 and lower doesnt support.   Message would look like it goes, but never does.. Also I noticed when playing with cfmail that it wont send if it is inclosed in

new member: web fetching

2004-05-21 Thread techmike
Hello all, I'm new to the group and coldfusion in general.  I've been tinkering around with server side scripting for awhile but coldfusion is all new to me.  My employer got me involved with some free classes, and I'm very intrigued at how easy this is to learn. Anyway, now my question.  How w

RE: new member: web fetching

2004-05-21 Thread techmike
: web fetching > More specifically please... >   > :) > > -Original Message- > From: Whittingham, P [mailto:[EMAIL PROTECTED] > Sent: Friday, May 21, 2004 8:45 AM > To: CF-Talk > Subject: RE: new member: web fetching > > > cfhttp. > > >

Re: How to validate email address before sending mail

2004-05-21 Thread techmike
Do you want to validate just to make sure it fits the proper format for email, or to test if the domain and box exist? I know of no way to do the later, but you could use regular expressions to validate the format of the email. Do a google for email validation regex -mike -Original Messag

Re: Mailling list script

2004-05-26 Thread techmike
What form of mailing list?  Like read only newsletters or open discussion forums like this? I'm actually working on a mailing list for news letters currently.  So far my progress is as follows. Users can subscribe / unsubscribe (adding and removing them from the database) and they are sent a

Re: MS Access as a backend database

2004-05-26 Thread techmike
It will work, but from what I've read isn't really suggested. If more than a handfull of users will be accessing access (no pun intended) things have the potential to slow down. If you don't want to spend the $$ for sql, go with MySQL which is free and for me has worked flawlessly with Coldfusi

self varible..

2004-05-26 Thread techmike
Its the coldfusion noob again here.. Is there a self varible in coldfusion?  much like $PHP_SELF if your familier with that.. So, if the varible were used in blah.cfm, the content of it would be just blah.cfm. -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [Us

RE: self varible..

2004-05-26 Thread techmike
TED]> Date: Wed, 26 May 2004 16:26:49 +0200 Subject: RE: self varible.. > #GetFileFromPath(GetCurrentTemplatePath())# > > > -----Original Message- > > From: techmike [mailto:[EMAIL PROTECTED] > > Sent: woensdag 26 mei 2004 16:23 > > To: CF-Talk > > Subj

RE: self varible..

2004-05-26 Thread techmike
Is this actually the best way to post a form to itself?  What I'm running into now is it works, however it appends to the end of the url whatever the action is.   Example. blah.com/test.cfm#CGI.SCRIPT_NAME# -mike -Original Message- From: "Alistair Davidson" <[EMAIL PROTECTED]> To: CF-T

RE: self varible..

2004-05-26 Thread techmike
ge not parsing #cgi.script_name# ? > > do you have around it somewhere? > > tw > > -Original Message- > From: techmike [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 26, 2004 12:31 PM > To: CF-Talk > Subject: RE: self varible.. > > Is this actually the be

Re: OT How to prevent someone changing my home page

2004-05-29 Thread techmike
I definatly second Spybot S&D.  The new version (1.3) seems to be a lot more effictive at blocking such things.  fixmy (dot) net is another place you can obtain it along with more spyware info.. -mike -Original Message- From: Gerry Demaret <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED

deleting db entries..

2004-06-01 Thread techmike
I know its advised against deleting database entries, but where am I going wrong here? This statement works, but deletes all table entries rather than the id of the one specfied.. The only thing I can think of is it is a query inside of another query.. Total brainfart here.. DELETE FROM tabl

RE: deleting db entries..

2004-06-02 Thread techmike
yes id is my unique primary key.  I tried adding a cfoutput to display it, and it is correct. I started without the LIMIT 1, but had the same exact results.  So I stuck it in there in hopes it would take care of the problem. -Mike -Original Message- From: Dave Watts <[EMAIL PROTECTED]>

caching..

2004-06-02 Thread techmike
Shouldnt setting the template cache size in administraor to 0 prevent caching? This server is just for my testing, and I don't want anything cached. I deleted a file, but coldfusion seems to of cached it because it still displays even though the file doesnt exist! -Mike [Todays Threads] [Th

RE: caching..

2004-06-02 Thread techmike
y(because of a MSIE bug) you should consider changing > it to > "every visit to the page" :) > > If you have trusted cache off, then ColdFusion is not the one who is > giving > you troubles. Also try to call the template with different url > variables. > Just dummy

RE: caching..

2004-06-02 Thread techmike
old 404 error I had expected.. Weird eh? -Mike -Original Message- From: "techmike" <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Wed, 02 Jun 2004 13:17:33 -0400 Subject: RE: caching.. > I'm using one of the nightly builds of Mozilla Firefox b

Re: Good, free (or cheap) webmail application

2004-06-07 Thread techmike
IIS or Apache? I'm a big fan of Squirrel mail, but I've never be able to get it running right under IIS.  It's PHP btw.  www.hotscripts.com has a pretty nice selection of freebies. -Mike -Original Message- From: "Burns, John D" <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date:

checking if a table exists?

2004-06-08 Thread techmike
Is it possible and if so how to check if a table exists? I'm trying to add a automatic setup to my template, user specifies the DSN, and the template will look to see if the tables exist, and if they don't then create them with some basic entries..   I've never created tables in CFM, but I assu

Re: restricting access by IP address

2004-06-08 Thread techmike
You could use something like whatever Not exactally how secure that would be..  I'm still learning here..  :) -Original Message- From: "Spectrum WebDesign" <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Tue, 08 Jun 2004 09:53:56 -0300 Subject: restricting access by IP addres

Re: CFMAIL flagged as spam

2004-06-09 Thread techmike
What spam filter are the people getting the mail running?  Spamassasin is big on html in the body of the message..  Could be something like that catching it.. -Original Message- From: Robert Redpath <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Wed, 9 Jun 2004 12:00:20 -0400

Re: CFMAIL flagged as spam

2004-06-09 Thread techmike
Better yet, use cfmail to send me the same message to techmike (at) mfcms (dot) com, and I will post the spamassasin results..  :) -Mike -Original Message- From: "techmike" <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Wed, 09 Jun 2004 12:20:00 -04

RE: Spam:Re: CFMAIL flagged as spam

2004-06-09 Thread techmike
Date: Wed, 9 Jun 2004 13:08:24 -0400 Subject: RE: Spam:Re: CFMAIL flagged as spam > One spam software was BrightMail and was Yahoo. >   > I'll send it through spamassain and see what I find. (and to you > techmike) > > -Original Message- > From: techmike [mailto:[E

RE: Spam:Re: CFMAIL flagged as spam

2004-06-09 Thread techmike
EMAIL PROTECTED]> Date: Wed, 9 Jun 2004 13:08:24 -0400 Subject: RE: Spam:Re: CFMAIL flagged as spam > One spam software was BrightMail and was Yahoo. >   > I'll send it through spamassain and see what I find. (and to you > techmike) > > -Original Message- > From:

RE: Spam:Re: CFMAIL flagged as spam

2004-06-09 Thread techmike
e: Wed, 9 Jun 2004 13:08:24 -0400 Subject: RE: Spam:Re: CFMAIL flagged as spam > One spam software was BrightMail and was Yahoo. >   > I'll send it through spamassain and see what I find. (and to you > techmike) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: OT: Web stats software

2004-06-16 Thread techmike
I'm a big fan of analog  www.analog.cx. It run in Windows and Linux under Apache and IIS. Webalizer is pretty nice too, but not as detailed. -Mike -Original Message- From: "Kristopher Pilles" <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: Wed, 16 Jun 2004 09:55:53 -0400 Subje

authentication...

2004-06-17 Thread techmike
I'm looking for a way to password protect a section of a template.  Very minimal security.  (define the password in the template as a varible). I'm having issues writing this though, anyone have a snippet that could give me some ideas? Thanks Mike [Todays Threads] [This Message] [Subscript

caching problems again...

2004-06-22 Thread techmike
From what I've seen with coldfusion MX so far is its caching is garbage, I have caching turned off everywhere I can find the options to, however the following still happens. 1.  I can physically delete a template from the server, but a user can still access it via the web. 2.  I fix a typo in