Re: Query of a query inconsistancies

2004-07-08 Thread Todd Ashworth
It does.On the first line I'm doing a SELECT *.that would include the
OrderDate column, would it not?

- Original Message - 
From: I-Lin Kuo [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, July 08, 2004 10:31 AM
Subject: Re: Query of a query inconsistancies

 Logically, they're different. You shouldn't get any
 results by moving the orderdate condition to the
 bottom query, because qryGetRepeatSales doesn't have a
 date column

 --- Todd [EMAIL PROTECTED] wrote:
  I have these 2 queries:
 
  cfquery datasource=#Application.Read#
  name=qryGetRepeatSales
 SELECT *, COUNT(*) AS totalcount, SUM(Cost) AS
  totalcost
 FROM orders, orderitems
 WHERE orders.OrderID = orderitems.OrderID
 AND OrderDate = '#DateFormat(StartTime,
  -mm-dd)#'
 GROUP BY UserID
 HAVING totalcount  1
  /cfquery
 
  cfquery dbtype=query name=qrySubGetRepeatSales
 SELECT SUM(totalcost) AS totalcost,
  COUNT(totalcount) AS totalcount
 FROM qryGetRepeatSales
  /cfquery
 
  The problem I'm having is when the OrderDate line
  is in the top query, I get the correct results.If
  I move it to the bottom query, the totalcost and
  totalcount end up being 1 or 2 less.The date
  filter really needs to be in the bottom query.What
  am I missing?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: Query of a query inconsistancies

2004-07-08 Thread Todd Ashworth
Ah. That link explains it all.The OrderDate fields are not unique.

Thanks.

- Original Message - 
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, July 08, 2004 17:38 PM
Subject: Re: Query of a query inconsistancies

 Let me guess, you are using MySQL.
 
 
 In standard SQL that would not include the OrderDate column 
 because each field you select without aggregating it needs to be 
 in the list of fields you group by. So in standard SQL this query 
 can not produce any fields other then totalcount, totalcost (both 
 aggregates) and UserID (group by).
 
 For some reason in MySQL this braindead syntax is allowed, but 
 even the manual says the result may be 'unpredictable', which 
 appears to be exactly what you are encountering:
 http://dev.mysql.com/doc/mysql/en/GROUP-BY-hidden-fields.html
 
 It is better to stay away from non standard SQL unless you 
 understand every detail of the consequences.
 
 Jochem
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: coldfusionhosting.com

2004-07-08 Thread Todd Ashworth
http://www.cfm-resources.com/pricing/info/mx.cfm

I have been using them for about 2 years now and have had nothing but
positive experiences.

This plan doesn't have quite as many features as the one you linked to, but
if all you care about is MX, CFFile, and custom tag support, then give it a
look.

- Original Message - 
From: Greg Saunders [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, July 08, 2004 17:16 PM
Subject: coldfusionhosting.com

 Does anyone have any good or bad experience with
 www.coldfusionhosting.com?They offer MX on a shared server for
$20/month,
 along with support for CFFile and your own custom tags.(Details are at
 http://www.coldfusionhosting.com/offering_detail.cfm?OffID=49CATID=6).

 I looked at other hosts recommended in an earlier thread, but I haven't
 seen any that allow custom tags for that kind of price.Any
 recommendations for hosts that would allow this?I know I could get my
own
 custom tags on a dedicated server, but I'm looking for an inexpensive way
 to host a site with my own custom tags.

 Thanks in advance.

 Greg Saunders, Ph.D.
 Senior Learning Scientist
 Carnegie Mellon West
 http://west.cmu.edu
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Error trapping when a file is not found

2004-07-05 Thread Todd Ashworth
In IIS, you can go into the Application Mappings and set an option to Check
if the file exists.Is there a similar option in Apache?

Todd
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Select IDs that only have 1 entry

2004-06-15 Thread Todd Ashworth
I have a table a bit like this:

id whatever1 whatever2
--
10 - blah1 - blah2
12 - abc1 - abc2
10 - xyz1 - xyz2
15 - pdq1 - pdq2

I'm trying to come up with a query that will only pull the rows that have 1 entry and 1 entry only. None of the ones that have duplicates should be returned. In this example, 12 and 15 will be returned, but 10 won't.I can think of a few awkward ways to do it, but am looking for a simple one.I'm not that familiar with MySQL.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




custom 404 troubles

2002-03-27 Thread Todd Ashworth

I have a custom 404 template set up.  When I go to a bad .html file, the
custom 404 comes up properly.  When I go to a bad .cfm it doesn't.  I can't
activate the check that file exists option, because it screws up one of my
custom tags.

I was thinking about doing a meta refresh to the custom 404 from the
standard CF 404 page.  Does anyone know where this file is found?  Also, is
there a better way to handle this?

Todd



This email has been scanned courtesy of SCDinc.com 
System rejects all executable attachments such as:
com, .scr, .vbs, .exe, and .bat


__
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: Why can't I buy JUST CFStudio 5?

2001-10-25 Thread Todd Ashworth

http://dynamic.macromedia.com/bin/MM/store/US/product.jsp?category=/Software
/Development/StandAlones/ColdFusionStudiotype=FULL

Todd

- Original Message -
From: Joshua Miller [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 25, 2001 8:55 AM
Subject: Why can't I buy JUST CFStudio 5?


 Why is it that Macromedia insists on bundling CFStudio5 and UltraDev 4
 together? Why can't I buy just CFStudio5? I can get JRun Studio, I can buy
 UltraDev without CFStudio, I can buy HomeSite but I can't buy just
 CFStudio5. I already own UltraDev4 and I really don't want to pay extra to
 have a second copy just to get CFStudio5 ... what's the logic behind this?

 Also, quit making it sound like it's one product. It's not. It's 2
separate
 applications, proabably on 2 different CDs that you have to install one at
a
 time. What's the deal with trying to make it sound like it's one product
 that has all these new features? It's the same UltraDev4 that's been
around
 for over a year - only Studio is new. Selling bundles is nice, but why
force
 customers into buying a more expensive bundle when they already paid $300
 for one half of it? UltraDev is nice, but I really don't need 2 copies at
 $250-$300 each for one developer.

 When you make them one product, then it will make sense, but now you're
just
 confusing people into thinking that they're getting some hybrid of the two
 in one application - and they're not getting that at all.

 Why the hassle Macromedia? Just sell CFStudio as a standalone product!

 Joshua Miller
 Web Development::Programming
 Eagle Technologies Group, Inc.
 www.eagletgi.com
 [EMAIL PROTECTED]



~~
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: Semicolon at end of SQL Statement???

2001-10-25 Thread Todd Ashworth

You don't use a WHERE clause in an INSERT statement.

Todd

- Original Message -
From: James Taavon [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 25, 2001 12:17 PM
Subject: Semicolon at end of SQL Statement???


 Not that familiar with doing SQL in Access, but this error does not make
 sense to me.

 ODBC Error Code = 37000 (Syntax error or access violation)

 [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of
 SQL statement.

 SQL = insert into tbl_users (fullname) values ('Rich Pragel') where
 username = rpragel

 Data Source = DLLR930


 The error occurred while processing an element with a general identifier
of
 (CFQUERY), occupying document position (1:1) to (1:44) in the template
file
 c:\inetpub\wwwroot\DLLR930\insert.cfm.


 cfquery name=insert datasource=dllr930
 insert into tbl_users (fullname)
 values ('#firstname# #lastname#')
 where username = #url.username#
 /cfquery



~~
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



Ben Forta's online testing application

2001-10-25 Thread Todd Ashworth

Does anyone know where he got the one on his site that he uses to promote
his study guide?

Todd



~~
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



Error logging in to CF Admin

2001-10-05 Thread Todd Ashworth

I'm trying to login to my CF Administrator and I keep getting a page that
only diplays this after I enter the password:

-2146893052 (0x80090304)

Has anyone seen this before?

Todd



~~
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: Error logging in to CF Admin

2001-10-05 Thread Todd Ashworth

This didn't help.  It's happening on 2 different machines too.  They are
running Win2k server, IIS, and CF 5

The web site works .. it's just the CF Admin that doesn't work.

Todd

- Original Message -
From: Dan Phillips [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, October 05, 2001 10:02 AM
Subject: RE: Error logging in to CF Admin


 Yep. Restart the Web Publishing services. If you are on Windows anyway.

 Dan Phillips
 CFXHosting.com

 -Original Message-
 From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
 Sent: Friday, October 05, 2001 9:53 AM
 To: CF-Talk
 Subject: Error logging in to CF Admin


 I'm trying to login to my CF Administrator and I keep getting a page that
 only diplays this after I enter the password:

 -2146893052 (0x80090304)

 Has anyone seen this before?

 Todd



~~
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: CFEXECUTE

2001-10-01 Thread Todd Ashworth

Yeah .. drop the cmd.exe part.  The NAME would be ftp and the ARGUMENT would
be -s:c:\path\to\file\ftpcommands.txt

Todd

- Original Message -
From: Adkins, Randy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, October 01, 2001 2:24 PM
Subject: RE: CFEXECUTE


 If I am not mistaken what is being send would be the
 following command as a whole:

 C:\WINNT\system32\cmd.exe ftp -s:c:\path\to\file\ftpcommands.txt



 -Original Message-
 From: Dave Hannum [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 01, 2001 2:17 PM
 To: CF-Talk
 Subject: CFEXECUTE


 I'm trying to fire off an FTP process with CFEXECUTE.  I need to call FTP
 and then a -s command with a command file.  So far I've got:

 CFEXECUTE
  NAME=C:\WINNT\system32\cmd.exe
  ARGUMENTS=ftp -s:c:\path\to\file\ftpcommands.txt
 /CFEXECUTE

 This does not work.  If I call it just like this from the command line, it
 works fine.  Any suggestions?

 Thanks,
 Dave

 ===
 David R Hannum
 Ohio University
 Web Analyst/Programmer
 (740) 597-2524
 [EMAIL PROTECTED]



~~
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: CFFTP and 80 byte wide files

2001-10-01 Thread Todd Ashworth

Are you talking about the length of the lines in your text file not being
over 80 chars. long?  If so, this is from way back in the good old days when
the punch cards used to program the computers were 80 chars. wide.  Also,
COBOL has some issues with certain things being in certain columns and only
so many (80) chars. wide, for a similar reason.

If you are uploading a text file to a mainframe that is going to be read by
some legacy app., written in COBOL or something, then this makes sense.

If that's not what you are talking about, I have no idea.  Glad it's working
though.

Todd

- Original Message -
From: Dave Hannum [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, October 01, 2001 3:09 PM
Subject: Re: CFFTP and 80 byte wide files


 It's mainframe jibbirish - I don't understand other that the mainfram
 formats to 255 bytes wide unless you specify otherwise.  That's what they
 tell me.  Anyway, you overcome this with arguements sent with your FTP, so
 I'm doing it via CFEXECUTE and the Windows FTP so I can pass it the
command
 to make the file stay 80 bytes wide.  I don't really understand except
that
 it is working now.

 Dave



~~
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



disable back button

2001-09-26 Thread Todd Ashworth

I have an app that I don't want people backing up in.  I've disabled the 
tool bar, the right and middle mouse buttons, and all keypress 
combinations on the keyboard.  The only problem is that the backspace 
key will still work.  The app sees the backspace keypress event and 
calls the function, but when the user clicks OK on the alert box, the 
app still backs up.  Is there any way I can interrupt that process?

Todd



~~
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: Error 109 (was: Error 232)

2001-09-25 Thread Todd Ashworth

I *think* the 109 is caused when a visitor hits the stop button on their
browser before the page loads.

Todd

- Original Message -
From: John McCosker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 25, 2001 9:21 AM
Subject: RE: Error 232


 Error,TID=218,09/24/01,8:53:30,Error number 232 occurred
 attempting to close connection to web server.
 Error,TID=218,09/24/01,8:53:30,Windows NT error number 232
 occurred.

 Our log file is full of these as well, also get occassional 109 errors
 can't find the definition of this one on ms site either.

 Anyone know?



~~
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: AHHHHHHHH Netscape HTML Question

2001-09-24 Thread Todd Ashworth

/tr
tr
td width=4nbsp;/td
table width=616
tr
td
width=616 colspan=2 nowrap
--- snip ---

Right here, you are opening a new table in the middle of nothing.  If I
remember, Netscape has issues with malformed tables.

Todd

- Original Message -
From: Robert Everland [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 24, 2001 2:02 PM
Subject: A Netscape HTML Question


 This @#$^@ HTML will work in everything but Netscape 4 and my eyes hurt
from
 going over and over and over and over again trying to see something.
 Hopefully a new set of eyes will find it.

 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN

 html
 head
 titleUntitled/title
 /head

 body marginheight=0 marginwidth=0 topmargin=0 leftmargin=0
 bgcolor=#FF text=#00


 table border=1 cellpadding=0 cellspacing=0
 tr valign=top
 td width=145nbsp;/td
 td
 table width=620 border=1 cellspacing=0
 cellpadding=0
 tr valign=top
 td
 Bob
 /td
 /tr
 tr valign=bottom
 td width=10nbsp;/td
 td width=400
 Bob
 /td
 td width=210
 align=rightnbsp;/td
 /tr
 tr
 td width=4nbsp;/td
 table width=616
 tr
 td
 width=616 colspan=2 nowrap
 Test
 /td
 /tr
 /table
 /td
 /tr
 /table
 /td
 /tr
 /table


 /body
 /html


 Robert Everland III
 Dixon Ticonderoga
 
~~
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: OT: Suggestion to list

2001-09-18 Thread Todd Ashworth

Couldn't you just use the search feature to find any E-mail sent to cf-talk
and then move it to the appropriate folder all at once?

Todd

- Original Message -
From: Andrew Scott [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, September 18, 2001 10:07 AM
Subject: RE: OT: Suggestion to list


 Sorry to but in here, but I am going to agree with the addition to
 [cf-talk] or something to identify this. And I'll tell you why, most of
 us are windows based users. Out of all these the majority would be using
 a MS product for their email whether it be Outlook or Outlook Express.

 Yes it supports rules, however MS has a very annoying bug where every
 now and then one of two things happens.

 1) You are just receiving email, you close the program down and not
 realized that the program was doing this. Every so often the program
 keeps running in the background, what will 90% of the time happen is
 that all this email coming in will go directly into the inbox and
 because you have closed outlook there are NO rules to be run.

 2) When you open outlook it will sometimes, for no apparent reason or
 even any form of pattern that I can find as yet! Where the rules get
 ignored all together, now to resort the thousands of email I get this is
 very painstaking to move around having to click on each message and look
 at the sent to field to determine which of the 200 folders to put it
 into!!

 Now most would not be affected by those 2 scenarios, however I find that
 outlook does do the above on a regular basis on 9 machines that I have
 sat at and even software wise that is installed before or after is not
 even remotely the same in most cases.

 Point, well the point is if you had to do the above. It would be very
 easy to look at the header and move in groups rather than one by one!


 Regards,
 Andrew Scott



~~
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 Certified Developer

2001-08-29 Thread Todd Ashworth

| Can you guys shoot me an insight as to what is on the test?

Questions.

Seriously, go to forta.com and take the practice tests.  They are very
similar to the real thing.

http://forta.com/books/0789725657/test.cfm

Todd

- Original Message -
From: Joshua Tipton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 2:02 PM
Subject: CF Certified Developer


| Can you guys shoot me an insight as to what is on the test?
|
| Joshua Tipton
|
|
~~
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: ASP vs. Cold Fusion

2001-08-17 Thread Todd Ashworth

You can also telnet into the machine and see if the mailserver is running.
Often times you get something like this:

+OK POP3 dssf.tudelft.nl v2000.70 server ready

I tried using cfexecute, but it wouldn't actually 'return' anything that
could be displayed.  Maybe someone else could figure out a way to do this.

Todd

| I really have no clue as to how this works internally. The test is if your
| mail server shows up in the administrator then the function will work for
| it. Basically, this is the function used in the admin to do that check.
| My thought is that it does a tcp/ip request to the port specified. If so,
| then maybe it can also be used to specify if a server or service is
running
| or not. Use it to check if an FTP server is running on a machine.
|
| At 08:26 AM 8/17/01, you wrote:
| Michael Dinowitz wrote:
|   Checking that the domain exists is easy using the
|   CFUSION_VERIFYMAIL(MailServer, SMTPPort, Timeout) function. It'll
return a
|   Boolean true or false id the mail server exists or not.
| 
| How does this work internally? Does it do a DNS lookup and search for a
| failover server if it can't contact the main server? Many mail domains I
| know (e.g. most academic domains in the Netherlands) have a setup where
| they block all incoming traffic on port 25 and provide a failover server
| that acts as a smarthost for mail to be delivered to the network
| (130.161.0.0/16 and 145.94.0.0/16 need to go through one server at my
| Uni). This allows them to provide central spam blocking and antivirus
| scanning, while the users can still connect to local servers. I would
| however expect that you can not verify my email server, while it is a
| valid and running server (try it).
| Also, many servers don't accept SMTP connections from computers outside
| a trusted domain that don't have an MX record. If your CF server does
| not have an MX record but your SMTP server does, you might get a false
| negative.
| 
| Jochem



~~
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 SP params to CFReport

2001-08-17 Thread Todd Ashworth

What database?  I had a similar issue with Sybase ASA 7.02.  Upgrading to
7.03 solved it.

Todd

- Original Message -
From: DJ Riebesell [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, August 17, 2001 2:16 PM
Subject: Passing SP params to CFReport


| I have tried every variation I can think of to pass in three parameters
into
| a CFReport for use when it calls a stored procedure.
|
| I can call a report that requires no input fine and it displays fine.
|
| When it requires parameters it seems to just hang, like the server is
| prompting for them only I obviously can't see the prompt.  It just gives
me
| the forever spinning globe in my browser.
|
| CF5 with Crystal 8.



~~
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: ASP vs. Cold Fusion

2001-08-17 Thread Todd Ashworth

I telneted to the oli.tudelft.nl on port 110 and that's the response I got
back.

Todd

- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, August 17, 2001 4:57 PM
Subject: Re: ASP vs. Cold Fusion


 Todd Ashworth wrote:
  You can also telnet into the machine and see if the mailserver is
running.
  Often times you get something like this:
 
  +OK POP3 dssf.tudelft.nl v2000.70 server ready

 Of course the port 25 block  failover and MX checks might prevent this
 from working as well.

 Jochem



~~
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: Thoughts

2001-08-15 Thread Todd Ashworth

cfcache is your friend.

  CFML Language Reference

--
  Chapter 1 :  ColdFusion Tags




CFCACHE
CFCACHE allows you to speed up pages considerably in cases where the dynamic
content doesn't need to be retrieved each time a user accesses the page. To
accomplish this, it creates temporary files that contain the static HTML
returned from a particular run of the ColdFusion page.

You can use CFCACHE for simple URLs and URLs that contain URL parameters.

Syntax
CFCACHE
ACTION=CACHE or FLUSH or CLIENTCACHE or OPTIMAL
USERNAME=username
PASSWORD=password
PROTOCOL=protocol_name
TIMEOUT=#DateAdd(datepart, number, date)#
DIRECTORY=directory_name_for_map_file
CACHEDIRECTORY=directory_name_for_cached_pages
EXPIREURL=wildcarded_URL_reference
PORT= port_number

ACTION
Optional. Specifies one of the following:

  a.. CACHE -- Specifies server-side caching. The default is CACHE.
  b.. FLUSH -- Refresh the cached page. If you specify FLUSH, you can also
specify the DIRECTORY and EXPIREURL attributes.
  c.. CLIENTCACHE --Specifies browser caching.
  d.. OPTIMAL--Specifies optimal caching through a combination of
server-side and browser caching.
See the Usage section for more information.

USERNAME
Optional. When required for basic authentication, a valid username.

PASSWORD
Optional. When required for basic authentication, a valid password.

PROTOCOL
Optional. Specifies the protocol used to create pages from cache. Specify
either HTTP:// or HTTPS://. The default is HTTP://.

TIMEOUT
Optional. DateTime that specifies the oldest acceptable cached page. If the
cached page is older than the specified datetime, ColdFusion refreshes the
page. By default, ColdFusion uses all cached pages. For example, if you want
a cached file to be no older than 4 hours, code the following:

CFCACHE TIMEOUT=#DateAdd(h, -4, Now() )#

DIRECTORY
Optional. Used with ACTION=FLUSH. Specifies the fully qualified path of a
directory containing the cfcache.map to be used when ACTION=FLUSH. The
default is the directory of the current page.

CACHEDIRECTORY
Optional. Specifies the fully qualified path of the directory where the
pages are to be cached. The default is the directory of the current page.

EXPIREURL
Optional. Used with ACTION=FLUSH. EXPIREURL takes a wildcarded URL reference
that ColdFusion matches against all mappings in the cfcache.map file. The
default is to flush all mappings. For example, foo.cfm matches foo.cfm;
foo.cfm?* matches foo.cfm?x=5 and foo.cfm?x=9.

PORT
Optional. The port number of the web server from which the page is being
requested. The port number defaults to 80. The port number is useful because
the CFCACHE code calls CFHTTP. If the port number is specified correctly in
the internal call to CFHTTP, the URL of each retrieved document is resolved
to preserve links.

Usage
In its simplest form, all you need to do is code CFCACHE at the top of a
page for it to be cached.

With the ACTION attribute, you can specify server-side caching, browser
caching, or a combination of server-side and browser caching. The advantage
of browser caching is that it takes no ColdFusion resources because the
browser stores the pages in its own cache, thus, improving performance. The
advantage of using a combination of the two forms of caching is that it
optimizes performance; if the browser cache times out, the server can
retrieve the cached data from its own cache.

In addition to the cached files themselves, CFCACHE uses a mapping file to
control caching. It is named cfcache.map and uses a format similar to a
Windows INI file. The mapping of a URL with parameters is stored as follows.
Assume a directory c:\InetPub\wwwroot\dir1 that has a CFM file called
foo.cfm, which can be invoked with or without URL parameters. The
cfcache.map file entries for foo.cfm will look like this:

 [foo.cfm]
Mapping=C:\InetPub\wwwroot\dir1\CFCBD.tmp
SourceTimeStamp=08/31/1999 08:59:04 AM

[foo.cfm?x=5]
Mapping=C:\InetPub\wwwroot\dir1\CFCBE.tmp
SourceTimeStamp=08/31/1999 08:59:04 AM

[foo.cfm?x=9]
Mapping=C:\InetPub\wwwroot\dir1\CFCBF.tmp
SourceTimeStamp=08/31/1999 08:59:04 AM

The cfcache.map file in a given directory stores mappings for that directory
only. Any time the timestamp of the underlying page changes, ColdFusion
updates the cache file for that URL only. ColdFusion uses the
SourceTimeStamp field to determine if the currently cached file is up to
date or needs to be rebuilt.

You can refresh the cache in the following ways:

  a.. TIMEOUT attribute -- ColdFusion tests the timestamp of the cached file
against the TIMEOUT attribute. If the cached file's timestamp is older than
TIMEOUT, the old file is deleted and a new one created. You can use fixed
dates if necessary, but it's preferable to use relative dates. This is the
preferred technique and it works for seconds, hours, days, weeks, years,
etc.
  b.. ACTION=FLUSH -- You use ACTION=FLUSH to 

Re: buying/leasing SQL

2001-08-08 Thread Todd Ashworth

Someone kick the cf-talk server, or kick Zachary .. whichever works ;)

Todd

- Original Message -
From: 'Zachary S. Bedell' [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, August 08, 2001 2:54 PM
Subject: RE: buying/leasing SQL


|
|  1. is it possible to still buy SQL server 7 somehow?
|  does the new (per-cpu) pricing apply to this?
|
| Last I knew, MS allows you to 'downgrade' a SQL 2k license  use it for
| a SQL 7 machine.  You'd have to do it per CPU.
|
|  2. is it possible to lease SQL 7/2000 somewhere?
|
| I think that's against the licensing agreement.  You might be able to
| buy SQL services from an ASP of some sort (put your DBs on their
| server), but I know (from past messages on this list) that the licensing
| for that is a NIGHTMARE, so I doubt you'll find anyone offering that
| service.
|
|  3. is it possible to have the rather high price splitted into
|  monthly payments?
|
| Not unless you've got a good credit card or other financing that you
| could use to purchase it.  MS certainly doesn't make any concessions to
| help people afford their server products
|
|  4. do I have to buy per-cpu license if I use SQL with
|  Coldfusion (IIS) to server dynamic webpages? can I buy
|  per-seat license for this?
|
| You must absolutely buy per-CPU licenses for use with ColdFusion.  The
| license agreement explicitly forbids use of CALs with any kind of
| multiplexing software (which, according to their definition covers CF).
|
|
|
| Depending on your performance needs, you CAN buy a single processor
| license for SQL and set it to use only one processor.  Then you can
| always license  activate the second processor at a later date.
|
| Personally, I've always despised per-CPU licensing as a money grubbing
| technique, but  At least you can split the cost of two CPU licenses
| into two lump sums that way...
| (Would you like us to shoot you twice right now, or once now and once a
| month from now? ;-)
|
|
| Hope that's helpful!
|
| Best regards,
| Zac Bedell
|
~~
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: FuseBox

2001-08-08 Thread Todd Ashworth

Look through some of these:

http://www.mail-archive.com/cgi-bin/htsearch?config=cf-talk_houseoffusion_co
mrestrict=exclude=words=fusebox+dave+watts+business+logic

Todd

- Original Message -
From: Gonzo Rock [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, August 08, 2001 5:31 PM
Subject: FuseBox


 I want to solicit opinions on FuseBox...

 I'm brand new to CF and am wondering if I should really go down that road
now or later... I have a huge app to build... actually already started.

 I am soliciting the downside positions... I can already predict the
fanatical support from the upside contributors :-)

 And with that let the opinions begin

 Thankx,

 Oh... PS... I did a search of the cf-talk archives for FuseBox... But
those whacky signatures;(see below) Show up as the majority of the messages
for FuseBox... not to useful no?

 Txixtxax Cxaxnxex



~~
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



Crystal Reports without cfreport

2001-08-07 Thread Todd Ashworth

Does anyone have an example of connecting to a Crystal Reports report
without using cfreport?  Can this even be done?

Todd



~~
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: Crystal Reports without cfreport

2001-08-07 Thread Todd Ashworth

I do have this file and have been looking over it.  What I most need to do
is have a way to tell Crystal Reports what database file to use while
generating its report.  I found an example that lets you change the DSN, but
that doesn't help since I have 1 DSN and many many different database files.
Supposedly, there is an example in that file you mentioned, but I don't know
enough about ASP to find it.  You wouldn't happen to know which file that
example is in, or how to do it, would you?

Todd

- Original Message -
From: Terri Stocke [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2001 12:55 PM
Subject: Re: Crystal Reports without cfreport


|
| Hi Todd,
|
| Yep, it sure is possible. Here's how we did it, after having no luck with
| CFREPORT (CF 4.0 Enterprise). It wasn't easy, but we finally figured it
out.
| We pass the CF variables into an ASP page, and then call the CFREPORT from
| the ASP page. If you go to Crystaldecisions.com and search for a download
| called ASPXMPS8, it will give you all of the examples you need. Of course,
| you also need the Web Component Service running on your server as well (so
| Crystal Reports can serve the report up via the browser). Here are my
tips:
|
| This is how I passed the information from my page to the ASP page. Note
that
| these are hidden fields only because these values came from my form page.
If
| you have no interim page, you can just send the info directly from your
form
| page:
|
| cfform name=continue action=http://ourserver/open_rpt.asp;
| method=post
| cfoutput
|
|   input type=hidden name=reportname value=#form.reportname#.rpt
|   input type=hidden name=param1 value=cursor
|   input type=hidden name=param2 value=#form.param1#
|   input type=hidden name=param3 value=#form.param2#
|   input type=hidden name=param4 value=#sessid#
|   input type=hidden name=promptOnRefresh value=0
|
| /cfoutput
|
| Note that the field names are named param1, param2, etc. This is what
| you need to name them. Crystal Reports will use whatever is in param1 as
its
| first parameter, whatever is in param2 as its second parameter, etc.
|
| The files you will need from the examples on CrystalDecision's site are:
|
| open_rpt.asp (the main file--this is where you would change the dsn/pw
info)
| rptserver.asp (I'm no ASP expert, but somehow this file tells ASP how to
| communicate with Cr. Rpts.)
| AlwaysRequiredSteps.asp (an include for open_rpt)
| MoreRequiredSteps.asp (another include for open_rpt)
| the JavaViewer and/or ActiveX viewer (allows the report to be viewed in
the
| browser).
|
| Not being an ASP person, I didn't know how to fix this particular problem,
| but if you try to pass more parameters/fields than what open_rpt is
| expecting, you will get an error.
|
| Be patient. You will probably get alot of errors until you get this right
;)
|
| Original Message Follows
| From: Todd Ashworth [EMAIL PROTECTED]
| Reply-To: [EMAIL PROTECTED]
| To: CF-Talk [EMAIL PROTECTED]
| Subject: Crystal Reports without cfreport
| Date: Fri, 17 Aug 2001 10:07:09 -0400
|
| Does anyone have an example of connecting to a Crystal Reports report
| without using cfreport?  Can this even be done?
|
| Todd



~~
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: I don't understand session locking :(

2001-08-06 Thread Todd Ashworth

 body bgcolor=#session.bgcolor#

 Are you saying I need to place a lock around the body tag?

Yep.

Simple rule .. you should always lock a session variable whenever it is
used. :)  For this reason, I prefer and reccomend, Client variables (stored
in a database), but if you have an app where perfomance isn't a major issue,
and you don't plan on ever having to move it to a clustered environment,
then Session variables will be fine.

Todd

- Original Message -
From: Bruce, Rodney [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, August 06, 2001 6:59 PM
Subject: RE: I don't understand session locking :(


 Question here as well

 I have done locks when ever I set a Session var.
 Do I have to use a lock  when ever I use the var?
 i.e:

 CFLOCK type=readonly scope=session
 CFSET session.bgcolor = blue
 /CFLOCK


 body bgcolor=#session.bgcolor#

 Are you saying I need to place a lock around the body tag?




~~
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: I dont understand session locking :(

2001-08-06 Thread Todd Ashworth

 i know why, but i dont know why!  Why won't CF just lock it all the time
 automatically

You can set up automatic read locking in CF Admin, though I *think* it gives
you less control on a line by line level if you need it =-/

  who would want shared data with sessions when they can already use an
application variable for that.

They shouldn't as long as the data isn't dependant upon who is accessing it.
Application variables are application wide, meaning all users see the same
info.  Session variables are user speciffic, meaning each user can have some
different data, but it's still a shared memory variable.  They both exist
for a reason :)

 Also I dont understand nested
 lockings and how it works.  All I usually end up doing is putting a
Session
 lock around every session variable I see.  or if the session is used in a
 CFIF tag, i put the lock around that CFIF tag (not the closing CFIF tag).
 Or if there are a bunch of session variavles being read/written to, i put
a
 session lock over them.  heck, why not just surround the whole page with
one

This might be a 'broad' explanation of why this is bad, but here ya go:  If
you wrap a lock around a section of code, that code can become
single-threaded .. meaning that only one person can have access to that code
at one time.  If you wrap an entire page with a lock, then it potentially
can't be executed by more than 1 person at a time.  This can be a serious
performance issue, as I'm sure you can see.  That's why it's important only
to lock the section of code you absolutely need to.  I might be way off, but
that's just how I've always thought of it .. why lock more than you have to?

Say you have 10 Session variables and 9 are read from and one is written to.
A read lock will allow several people to read from that variable at once,
but prevents someone from writing to it until all the reads are done.
Exclusively locking a variable will not let anyone access the variable in
any way as long as there is one person accessing that variable.  I doesn't
make much sense to exclusively lock all 10 variables when you only have to
do one.  This might cause some serious performance hits if that page is at
all popular.

In the case where you have a bunch of Session variables that are being read
and written to all in a short period of time, you will have to use your best
judgement as to when to locks groups of code, or individual lines.  There is
a performance hit to grouping entire blocks of code in a lock, but there is
also one to making a lock, letting it go, and then recreating a new one
repetatively.

I've only made a very generalised explanation, and I'm probably not 100%
accurate in a few places, but you should get a basic answer to your
questions from it :)

Todd



~~
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: Locked Database

2001-08-06 Thread Todd Ashworth

The simplest way is to make a bogus call to the database that will
definately produce an error (such as a call to a table or column that
doesn't exist).  That will cause the Access engine to drop connections to
the database and will unlock it.  There is a way that works for databases
besides Access, but that should do what you want :)

Todd

- Original Message -
From: CFHelp [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, August 06, 2001 10:11 PM
Subject: Locked Database


 Is there some code I can put into a page to unlock an access database?


 Rick Eidson
 Owner
 http://www.kchost.net/
 KChost is getting ready to launch it's enews service
 Now you can moderate your own affordable newsletter
 Promote you products and services even sell advertising. Plans start at
 $5 a month for 500 emails. FREE Trial account.



~~
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: Locked Database

2001-08-06 Thread Todd Ashworth

 Usually sending a bad query to the data source will break the lock.  You
 can also set disable database connections in the CF Administrator.  If
 you disable db connections, make sure you enable them again, otherwise
 your site won't work :-)

The bogus query is a better option .. it is less intrusive and more
immediate than the disable database connections one.  The other method I
was refering to in my last post is the CFusion_DBConnections_Flush()
function.  That tends to break all DB connections without having to change
anything on the CF server.  To use it, set some temp variable = to the
function .. .eg:  cfset Variables.uselessTempVariable =
CFusion_DBConnections_Flush()

Todd

 Jay Sudowski
 -
 Handy Networks LLC
 TEL: 877-70-HANDY
 FAX: 888-300-2FAX
 URL: www.handynetworks.com http://www.handynetworks.com
 -
 Providing reseller and dedicated Windows 2000 web hosting solutions.



~~
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: Locked Database

2001-08-06 Thread Todd Ashworth

 I'd have to think that Disable Database Connections would also be
 immediate (but I'm honestly not sure). And while it may be more
 intrusive then momentarily unlocking the database with a bad query, if
 Rick's site is popular, disabling database connections to the db may be
 the only way to go because other users may relock the database before he
 can initiate / complete his upload.  Similarly, if users try to query
 his database while he's uploading the database, they will receive an
 error.
...
 - Jay

ack .. I lapsed into the mindset of a database that doesn't need uploading
to update the DB structure.  My bad :(

Todd


 -Original Message-
 From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
 Sent: Monday, August 06, 2001 11:05 PM
 To: CF-Talk
 Subject: Re: Locked Database


  Usually sending a bad query to the data source will break the lock.
  You can also set disable database connections in the CF
  Administrator.  If you disable db connections, make sure you enable
  them again, otherwise your site won't work :-)

 The bogus query is a better option .. it is less intrusive and more
 immediate than the disable database connections one.  The other method
 I was refering to in my last post is the CFusion_DBConnections_Flush()
 function.  That tends to break all DB connections without having to
 change anything on the CF server.  To use it, set some temp variable to
the function .. .eg:  cfset Variables.uselessTempVariable
CFusion_DBConnections_Flush()

 Todd

  Jay Sudowski
  -
  Handy Networks LLC
  TEL: 877-70-HANDY
  FAX: 888-300-2FAX
  URL: www.handynetworks.com http://www.handynetworks.com
  -
  Providing reseller and dedicated Windows 2000 web hosting solutions.

~~
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: form field parameter not recognized

2001-08-03 Thread Todd Ashworth

cfif not IsDefined('form.gname') or not Len(Trim(form.gname))  should
should work better.  It will trap if the field is blank or does not exist,
either one.

As to why it only seems to be happening on the Macs of AOL users, i have no
idea.

Todd

- Original Message -
From: Mark [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 2:10 PM
Subject: form field parameter not recognized


| We're having a strange problem with form field
| parameters not being recognized when being passed to a
| second page even though all the code is there and the
| form field is present.
|
| Here's the code on the original page:
|
| form action=http://www.fancyblooms.com/test.cfm;
| method=post
|
| INPUT NAME=gname TYPE=TEXT SIZE=35
| MAXLENGTH=75 value= style=font-family:
| Verdana,Arial; font-size: 9pt;
|
| ... more form fields here
|
| input type=submit name=next value=Next -
| /form
|
| On the second page, test.cfm, there is a check to make
| sure that the first form field, gname, is not blank.
|
| CFIF form.gname IS 
| bError/bP
|
| ... etc
|
| The error that SOME visitors get is:
|
| Error resolving parameter FORM.GNAME. The specified
| form field cannot be found  
|
| Now, I know the form field is there, and I can't
| duplicate this error under any of the PC based
| browsers we use (IE, Netscape, Opera). The only common
| thing I do know is that the few people that did get
| this error are using AOL 5.0 and are on the MAC
| platform.
|
| I understand that I could use client side validation
| with CFFORM to make sure these fields are not empty,
| but I'm trying to avoid all the Javascript that goes
| along with it.
|
| Is anyone familiar with this problem? Is it AOL and
| MAC related? Any suggestions?
|
| Thanks everyone!
|
| Mark



~~
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



VBScript/CF and Crystal Reports

2001-07-31 Thread Todd Ashworth

In VBScript, you can use something like this to tell Crystal Reports what
database file it should pull its table information from.

set FirstTable = Session(oRpt).Database.Tables.Item(1)

FirstTable.Location = mydatabase.db

Is there something similar in ColdFusion?  Actually, is there ANY way to
tell Crystal Reports what db file you use at runtime?  I want to run the
same report for up to 500 different database files from a web page and I
don't want to have to make a new report for each one.

Todd



~~
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 do these things happen?

2001-07-28 Thread Todd Ashworth

Turn on your debugging and look to see if the query shows up in your list of
run queries.  That will give you a better starting point from which to
figure out what's really going on.

I'm guessing that the ID isn't really getting passed, or it's some weird ID
that doesn't satisfy the if statement.  The other possibility is that
there is some combination of conditions in the if statement that will
cause neither query to be run.

Have you tried outputting the hidden field to see what's really in it?

Todd

- Original Message -
From: Bud [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, July 28, 2001 9:02 AM
Subject: How do these things happen?


 Man. I come across stuff like this and it simply makes me dizzy
 trying to figure out what is wrong.

 While looking at my errors log, I find a bunch of these:

 The QUERY attribute of the tag does not specify the name of an
 available querypThe error occurred while processing an element with
 a general identifier of (CFOUTPUT), occupying document position
 (50:6) to (50:43) in the template file
 F:\USERS\LATIN-LOVECONNECTION\HTDOCS\SEARCH\DETAILS.CFM.

 OK, so at that document position is a cfoutput tag with a query of
 itemsLong. Above that are 2 queries called itemsLong, the one that
 runs depending upon the category ID that's passed. The referer that's
 specified in the rror is correct, so they're not just going there
 without clicking the form button, which will pass the hidden
 category_id field. Whenever I go to the page, itemsLong is run.

 Stuff like this makes me nuts. There is absolutely no rhyme nor
 reason for it other than CF deciding well, I just won't run the
 block of code with the query in it.
 --

 Bud Schneehagen - Tropical Web Creations

 _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
 ColdFusion Solutions / eCommerce Development
 [EMAIL PROTECTED]
 http://www.twcreations.com/
 954.721.3452


~~
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



cfreport and crystal reports

2001-07-27 Thread Todd Ashworth

Is there a way to dynamicly pass the name of the database file that you want
the crystal reports report you are calling to use?

I have one report, but I want it to be able to pull from any number of
different databases.  So far, I haven't been able to figure out how to do
this.  Does anyone know, or have any good links on this sort of thing?

Todd Ashworth --



~~
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: Vote on ColdFusion Enhancements!

2001-07-27 Thread Todd Ashworth

whoa .. sounds like Fusebox version 5.0 :)

Imagine having your fuses all mapped out in 3D.  Cool!

Todd
-
I'd buy that for a dollar.

- Original Message -
From: Angél Stewart [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, July 27, 2001 3:03 PM
Subject: RE: Vote on ColdFusion Enhancements!


| Hmm..well I had an idea for CFSTudio...that might have to be implemented
at the CF Server level to be effective..or not..but
| here it is. Please don't laugh :):
|
| Leverage the power of flash and 3D Virtual Environments to make modular
programming a lot easier.
|
| How about having each 'block' of code being a 3D box..and the input and
output of each piece of code would be represented by
| a double/single headed arrow etc. that would link the boxes together.
|
| You could have a 'library' of these code modules that you could 'drag'
onto the programming area. You would be able to view
| the raw code and change it as well within each module or 3D block. You
hover the mouse over a block and you might see
| pertinent info like a Comment string included by the developer, or if it
is a custom Tag the input and output that the tag
| does as well as a comment string etc.
|
| You can also scroll back and forth, or around in a 3D space to watch the
'flow' of the program as it takes shape, and isolate
| various elements such as Variable names, Umm..whether Client variables or
Session variables...track queries and what hits are
| made to the database and what information is requested and see the results
VISUALLY between the code block and a 3D
| representation of a database so you can think about things like load
balancing etc. right there on the fly to give you a good
| gauge as to how your program will perform and the amount of calls that are
being made etc.
|
| Or Isolate a section of the code flow and then check what Session and
CLient variables should be present at this stage and
| then quickly back track to see where they should be set so you can easily
track errors and see the program flow. You should
| be able to walk through the code by backing up to a Page level and go from
page to page checking variables and output,
| databse calls..and then double click to 'zoom' in on a single page and
then drill down further if necessary into a custom tag
| to see the raw CF Code.(Call an instance of traditional CF Editor)
|
| We could also take this a step further in terms of debugging, and
analysing a program as opposed to actually creating and
| putting together a program like this if that is too radical. So you write
the program normally, and this Virtual Program
| Display or CF-VPD would analyse the .cfm files, check what is called in
which file and then construct a 3D Map of these
| connections that you can then use to track down errors or spot ways to
make your code more efficient.
|
| The Visual 3D representation would take advantage of the rich media
environments that are quite common in the Entertainment,
| world, but haven't quite made it into the mainstream business arena yet.
Adobe and other companies are trying to introduce
| the notion of the 3D web. But the limiting factor on the net is bandwidth,
on a single development workstation that isn't a
| factor however so there's nothing to hold back a Visual approach in that
sense.Enabling this system over a broadband internet
| connection similar to how RPC works now should be included though.
|
| Each 'CFTag' could be represented by some sort of 3D symbol and
connected...I'm thinking something like Visio..but in
| 3D..where you can roll up or down..back and forth through the program with
the mouse. It may sound confusing..but if you
| think about it, it should make development a lot easier, quicker, and more
accessible to a wide variety of people.
|
| Anyways..this is just an idea that has been floating around in my head for
a while..maybe I'm just reading too many Sci Fi
| books. :)
|
|
| -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: Questions to ask for CF developer

2001-07-23 Thread Todd Ashworth

| I had a test at a interview. I had to write a page of HTML by hand with
| pencil and paper. I do not keep all attribute details of every tag in my
| head, so I'm sure they didn't like my response to the test.

Pencil and paper?  What, were they trying to see how well you could function
durring a power outage or something?

I had to take a CF test once where some of the multiple choice questions did
not have a correct answer.  How do you correctly answer a question that has
no correct answer as a choice?  heh.  I don't think they liked my comments
about the test either.

Todd

- Original Message -
From: Shawn Regan [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, July 23, 2001 1:44 PM
Subject: RE: Questions to ask for CF developer


| I think simple questions on CF, HTML or whatever they say they can do can
be
| used as an added decision making tool but not the only thing to base your
| decision on.
|
| We have had people hired that didn't know the basics and they could have
| been weeded out with some simple basic questions. Now this is a problem
when
| the person hiring doesn't know specific questions to ask. So you just need
| to inform the interviewer of some basic stuff this person should already
| know.
|
|
|
| I had a test at a interview. I had to write a page of HTML by hand with
| pencil and paper. I do not keep all attribute details of every tag in my
| head, so I'm sure they didn't like my response to the test. I personally
do
| not think that is a correct way to hire people. Memorizing things is a
basic
| form of knowledge, but how the person applies it is what makes them a
| professional.
|
|
|
| my 2cents
|
| Shawn Regan
| Applications Developer
| Pacific Technology Solutions



~~
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: Intro and questions...what else?

2001-07-18 Thread Todd Ashworth

Welcome,

Pass everything but the password.  It won't kill them to retype just 
that
little bit ;)

Todd

- Original Message -
From: John Paitel [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, July 18, 2001 4:23 PM
Subject: Intro and questions...what else?


| Hey all...
|
| I am new to the list, as well as a relatively new CF programmer
| (1+years),
| and I am going back and filling in the gaps from when I learned what
| I
| needed to at the time. ;-) I have been programming for a few years,
| so
| understanding the programming concepts is not a problem.
|
| I do have a question on a site I am developing for a future personal
| business. I want to allow users to sign up for a trial account. I
| have
| javascript that checks the form for validity (Email address, no 
blank
| fields, etc), but I need to also check the database to make sure 
that
| the
| user account name does not already exist. I can do this easily in 
the
| handler page, but if the username exists, and I send them back, all
| their
| info disappears.
|
| I can take care of this by passing the data back, but I would rather
| not
| keep passing their password back and forth. Is there a way to keep
| the
| data, without passing it back and forth?
|
| John Paitel



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Out of Space? - More Info

2001-07-13 Thread Todd Ashworth

Do you have the exact error message?  Maybe try this:

http://support.microsoft.com/support/kb/articles/Q209/9/40.ASP?LN=EN-USSD=g
nFR=0qry=disk%20spacernk=4src=DHCS_MSPSS_gn_SRCHSPR=ACC2000

Todd Ashworth --
Certified ColdFusion Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: Erika Foster [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, July 13, 2001 9:58 AM
Subject: Re: Out of Space? - More Info


| Okay, troubleshooting this from 1000 miles away over the phone bites.
|
| 1. Its an Access 2000 DB
| 2. The DB is only 1.5 MB
| 3. It will insert records into all tables but one.
| 4. This particular table has 4762 records
| 5. They are able to update records in that table.
| 6. The .mdb and the .ldb files are on the same drive, in the same
directory.
| 7. The drive its on has many GIG of free space.
| 8. We've stopped CF services and restarted, and we've rebooted.
|
| Under the gun here because they need to teach a class on this app tomorrow
| morning!
|
| Any ideas?
|
| THANK YOU!
| Erika Foster
| engineering-environmental Management
| Applications Developer
| (505) 866-1654
| [EMAIL PROTECTED]
| - Original Message -
| From: Erika Foster [EMAIL PROTECTED]
| To: CF-Talk [EMAIL PROTECTED]
| Sent: Friday, July 13, 2001 6:46 AM
| Subject: Re: Out of Space?
|
|
| : Its an Access Database and its about 6mb in size.
| :
| : Ben, I'll check out the .ldb possibility.
| :
| : Thanks!
| :
| : Erika
| :
| : - Original Message -
| : From: Kevin Gilchrist [EMAIL PROTECTED]
| : To: CF-Talk [EMAIL PROTECTED]
| : Sent: Friday, July 13, 2001 11:04 AM
| : Subject: RE: Out of Space?
| :
| :
| : : What kind of database is it?
| : :
| : : -Original Message-
| : : From: Erika Foster [mailto:[EMAIL PROTECTED]]
| : : Sent: Friday, July 13, 2001 8:16 AM
| : : To: CF-Talk
| : : Subject: Out of Space?
| : :
| : :
| : : I have a client who is getting an Disk Space error when trying to add
or
| : : update the database.  They have a couple GIG of empty space on this
| disk.
| : : I'm off site right now and can't do any troubleshooting on the
machine.
| : :
| : : Any suggestions?  What's going on?
| : :
| : : Thanks!
| : :
| : : Erika Foster
| : : engineering-environmental Management
| : : Applications Developer
| : : (505) 866-1654
| : : [EMAIL PROTECTED]
| : :
| :
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



connectstring and server hangs

2001-07-13 Thread Todd Ashworth

We are using connectstring to connect to an ODBC database.  It works fine
unless the connectstring that gets passed has incorrect data in it.  If that
happens, the connection just hangs and doesn't time out .. at least not for
a long time.  Once we get 5 of these in a row, it's bye-bye CF server until
the service is restarted.  This is driving me crazy.  I can't figure out why
this is happening.  Does anyone know exactly how CF and the connectstring
and the database interract?  Is there a way to force either CF or the
database to throw an error instead of just locking a process and sitting
there forever?  Here's what I get in my log file:

  2001-07-13
   15:40:54
   Information
   538


The ColdFusion Application Server started.


2001-07-13
   15:40:48
   Error
   438


ExprParser: CFuncIsDefined::DoIt: unknown


2001-07-13
   15:40:48
   Fatal
   438


Unknown error threshold reached. Restarting service.


2001-07-13
   15:40:28
   Error
   479


!!  CFTrace::logThread(113) has no entry for thread 113


2001-07-13
   15:40:28
   Warning
   479


A request exceeded the timeout. The unresponsive thread count is up to 1.
[C:\Inetpub\wwwroot\gymtime_2\index.cfm]


2001-07-13
   15:40:18
   Error
   438


Unable to write reply -- client browser stopped waiting for request.


2001-07-13
   15:40:18
   Error
   438


Windows NT error number 109 occurred.


2001-07-13
   15:40:18
   Error
   438


Error number 232 occurred attempting to close connection to web server.


2001-07-13
   15:40:18
   Warning
   438


Template: C:\Inetpub\wwwroot\index.cfm, Ran: 19 seconds.


2001-07-13
   15:40:18
   Error
   438


Windows NT error number 232 occurred.


2001-07-13
   15:37:29
   Warning
   113


Template: C:\Inetpub\wwwroot\index.cfm, Ran: 24 seconds.


2001-07-13
   15:37:08
   Error
   245


Unable to write reply -- client browser stopped waiting for request.


2001-07-13
   15:37:08
   Error
   245


Windows NT error number 109 occurred.


2001-07-13
   15:37:08
   Error
   245


Error number 232 occurred attempting to close connection to web server.


2001-07-13
   15:37:08
   Warning
   245


Template: C:\Inetpub\wwwroot\index.cfm, Ran: 27 seconds.


2001-07-13
   15:37:08
   Error
   245


Windows NT error number 232 occurred.


2001-07-13
   15:33:27
   Information
   443


The ColdFusion Application Server started.




Based on that, I can't really tell which service is causing the problem, the
database or CF.  The database engine doesn't seem to be affected by any of
this, so I'm thinking it's something to do with CF.

I'm running CF 5 on NT 4.0 Service pack 6 with IIS 4
The database is Sybase ASA 7.03 running on Win2k Pro Service pack 2
The 2 machines communicate over NetBIOS
My connectstring looks like this
uid=username;pwd=password;dbf=e:\path\to\database\databasefile.db;eng=dbeng
inename;links=netbios;astop=true;astart=false;

The connectstring works fine as long as there is nothing wrong with it.
But, even if something as simple as the username or password is wrong, it
causes a thread to hang.

Help?

Todd



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: OT - Allaire website

2001-07-10 Thread Todd Ashworth

Yes .. I was complaining about that just a few minutes ago.

Moving between most of the pages in the devex section are slow .. not just
the search.

Todd

- Original Message -
From: Zac Belado [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 10, 2001 1:51 PM
Subject: OT - Allaire website


| Is anyone else getting *very* slow searches on the Dev-Exchange site?
|
| I've been doing searches for the last few days and routinely get results
| that take 2 to 3 minutes to return
|
|
| --
|
| Zac Belado
| Application Developer
|
| Bayleaf Software
| #300 948 Homer Street,
| Vancouver, BC,
| V6B 2W7
| Ph: 604.683.1288 x 116
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



SOLVED! finding the referer after a redirect to an error page.

2001-07-09 Thread Todd Ashworth

My bad.  I figured out the answer right after I sent the first message.
It's stored in the CGI.QUERY_STRING as
404;http://www.oursite.com/theirsitename;

That's easy enough to handle :)

Thanks anyway.

Todd

- Original Message -
From: Todd Ashworth [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 10, 2001 12:52 AM
Subject: finding the referer after a redirect to an error page.


| Oh jeez .. let me see if I can explain this ...
|
| We are setting up a site where people can come sign up and get their own
web
| site.  The trick is, we don't want to have to fool with making changes in
| the registry, or IIS.  So, we came up with this brilliant idea of
storing
| a site name in the customer master database that is the name of the
| subdirectory that their site would normaly sit in if we created a folder
for
| them and mapped it in IIS (www.oursite.com/theirsitename).  The idea is
that
| when someone comes looking for www.oursite.com/theirsitename, it won't
| really exist and they will be shuffled off to the default error page.  We
| have replaced the error page with a cf file that parses out
theirsitename
| and then performs a lookup in the database for information associate with
| theirsitename, sets some client variables, and then shoots them off to
the
| main application that everyone REALLY uses.  The client variables contain
| folder paths and database file info that determines what data is displayed
| to what users.
|
| OK .. I hope that made sense.  Anyway .. when the visitor is redirected to
| the 'default error' page, the URL that they were trying to get to gets
lost.
| I don't know enough about IIS or HTTP protocols to know if it's even
| possible to keep track of this information.  Does anyone know how I could
| accomplish this?
|
| Thanks!
|
| Todd
|



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



finding the referer after a redirect to an error page.

2001-07-09 Thread Todd Ashworth

Oh jeez .. let me see if I can explain this ...

We are setting up a site where people can come sign up and get their own web
site.  The trick is, we don't want to have to fool with making changes in
the registry, or IIS.  So, we came up with this brilliant idea of storing
a site name in the customer master database that is the name of the
subdirectory that their site would normaly sit in if we created a folder for
them and mapped it in IIS (www.oursite.com/theirsitename).  The idea is that
when someone comes looking for www.oursite.com/theirsitename, it won't
really exist and they will be shuffled off to the default error page.  We
have replaced the error page with a cf file that parses out theirsitename
and then performs a lookup in the database for information associate with
theirsitename, sets some client variables, and then shoots them off to the
main application that everyone REALLY uses.  The client variables contain
folder paths and database file info that determines what data is displayed
to what users.

OK .. I hope that made sense.  Anyway .. when the visitor is redirected to
the 'default error' page, the URL that they were trying to get to gets lost.
I don't know enough about IIS or HTTP protocols to know if it's even
possible to keep track of this information.  Does anyone know how I could
accomplish this?

Thanks!

Todd



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



connecting to many databases using the same DSN

2001-07-05 Thread Todd Ashworth

OK .. I've asked this question a couple of times and, so far, no one has had
an answer.  Well, I finaly figured out the answer with help from my DBA.
The main question has been How do I connect to different databases using
the same DSN!!

I don't know how usefull anyone else would find this, but it was of major
importance to us, so I'm going to throw it out there in case someone else
ever wants to know how.

Basicly, you use the connectstring parameter of cfquery.  It would look
something like this:

cfquery name=qry_myReallyCoolQuery datasource=#Client.userDSN#
connectstring=uid=#Client.UserID#;pwd=#Client.Password#;dbf=#Client.myDBFil
e#;svr=#Client.myDBServer#;links=#Client.DBServerLink#
cachedwithin=#createTimeSpan(0,0,0,0)#

This connectstring is for a Sybase database/engine.

It breaks down like this:

!--- Begin 1:  You don't have to include these in the connectstring if you
want to use them in cfquery, but for our needs, putting them in the
connectstring makes sense, since we store the whole connectstring in a
Client variable and the uid and pwd passed to the server determines access
permissions. ---
uid = cfquery's username attribute
pwd = cfquery's password attribute
!--- End 1
dbf = the name of the database file you wish to actually connect to as seen
by the computer that runs the database engine (ex:
E:\my_path\to_the\database_file\database.db)
svr = the name of the database engine that CF should look for to find the
dbf (optional if you have one db engine)
links = the protocol info CF might need to connect to the database (in our
case, 'NetBIOS')

I havn't tried this with any other database, so I don't know if the syntax
is the same, but hopefully you get the idea.

If you have any questions, email me and ask away :)

Todd

- Original Message -
From: Todd Ashworth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 29, 2001 10:45 AM
Subject: cffile, cfregistry, and clusters, oh my


 I need some suggestions on several different topics here.

 1.  We have a web app that will be used by many, many people.  We would
like
 to host this app on a cluster of servers.  The catch is, we want everyone
to
 use the same copy of code for the app, but each person/company needs their
 own database.  If we get 1000 companies using this thing, I don't want to
 have to replicate 1000 different DSNs for the different databases accross
 all of the clustered servers.  What I would like to do is find a way to
 connect to the various databases without having to use a DSN.  We tried
 using OLEDB and specifying the database file, but we couldn't get that to
 work.  Maybe someone could explain to me how to get OLEDB to work with
 Sybase 7, or maybe tell me another way to do what I'm trying to do.

 2.  We want people who want to use the app to be able to sign up for it on
 the web site and begin using it almost immediately, without any
intervention
 on our part.  Signing up for the app requires that the sign up program
 creates some folders and registry entries on each server in the cluster.
Is
 there an example, or tutorial where the best way to handle this is
 explained?

 Thanks

 Todd




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



cffile, cfregistry, and clusters, oh my

2001-06-29 Thread Todd Ashworth

I need some suggestions on several different topics here.

1.  We have a web app that will be used by many, many people.  We would like
to host this app on a cluster of servers.  The catch is, we want everyone to
use the same copy of code for the app, but each person/company needs their
own database.  If we get 1000 companies using this thing, I don't want to
have to replicate 1000 different DSNs for the different databases accross
all of the clustered servers.  What I would like to do is find a way to
connect to the various databases without having to use a DSN.  We tried
using OLEDB and specifying the database file, but we couldn't get that to
work.  Maybe someone could explain to me how to get OLEDB to work with
Sybase 7, or maybe tell me another way to do what I'm trying to do.

2.  We want people who want to use the app to be able to sign up for it on
the web site and begin using it almost immediately, without any intervention
on our part.  Signing up for the app requires that the sign up program
creates some folders and registry entries on each server in the cluster.  Is
there an example, or tutorial where the best way to handle this is
explained?

Thanks

Todd



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: cffile, cfregistry, and clusters, oh my

2001-06-29 Thread Todd Ashworth

|  1.  We have a web app that will be used by many, many people.  We
|  would like
|  to host this app on a cluster of servers.  The catch is, we want
|  everyone to
|
| Is it one company per box? Or multiple? If it's one company per box, then
| just use the same DNS name and point to the a different db on your db
server
| for each company.

I'm not sure I understand.  Let me try to explain again.  We have an app.  1
machine isn't going to be able to handle 1000 companies using that app.  So,
we have a cluster of, say, 5 machines and 1 database server.  Any company
can hit any machine in the cluster depending on when they show up.  Right
now, we are using a different DNS for each company.  Since they could hit
and of the 5 machines, we would need to have all 1000 DSNs on all 5
machines.  This doesn't sound like the best idea.  A single DSN where we can
pass the name of the database file to access would be much better, but I'm
having trouble getting this to work.  Is it even possible?

| If it's multiple companies, then use DNS connections. This is possible in
| CF5.

I don't follow this statement.  Also, what if we don't have 5.0 yet?

|  2.  We want people who want to use the app to be able to sign up for it
on
|  the web site and begin using it almost immediately, without any
|  intervention
|  on our part.  Signing up for the app requires that the sign up program
|  creates some folders and registry entries on each server in the
|  cluster.  Is
|
| First, I'd _strongly_ consider rethinking your strategy. Why do you want
to
| use the registry?

To create the DSN entries.

| Why do you want to make physical paths?

We need to create a folder on the image server for each company to store
their images in.  I can see a way to do this, so this isn't much of a
problem.

| If you want each client to be able
| to do, www.myapp.com/companyname,
| then use something like
| www.myapp.com/a.cfm/companyname, to create 'fake' folders.

I'm not sure I follow you here either.

Thanks

Todd



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Drop-down menu and redirect based on selection

2001-06-26 Thread Todd Ashworth

| First of all, don't use CFFORM.  In fact, NEVER use CFFORM.  Roll your own
| JavaScripts for validation instead.

Why not?  For _simple_ validation, it's quick, it's easy, and it does the
job.  Besides, when you combine it with CF validation and then database
validation on top of that, it's not quite as critical that the JS gets it
100% all the time.  Besides, what if some wiseguy makes a copy of your form,
alters the JS and then submits it to your site.  At that point, it's the CF
and database validation that really matter.  Now, I know there are ways to
prevent something like that from happening, but my point is, to me, JS is
just a nice thing I do for the users to save them some time.  I don't rely
on it for any type of serious data validation/formatting.  So, for me, the
default stuff in cfform works just fine, unless I need the data stored in
some format other than the CF_javascript will accept.

Is there something I am not thinking about that I should be?

Todd

- Original Message -
From: Mark Warrick [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 3:55 PM
Subject: RE: Drop-down menu and redirect based on selection


| First of all, don't use CFFORM.  In fact, NEVER use CFFORM.  Roll your own
| JavaScripts for validation instead.
|
| Second, use the following code for your nav form:
|
| form action=redirect.cfm method=post onChange
| select name=theurl onChange=document.forms[0].submit()
| option value=http://www.fusioneers.com;Fusioneers.com
| option value=http://www.warrick.net;Mark's Personal Site
| option value=http://www.houseoffusion.com;House of Fusion
| /select
| input type=submit value=Go!
| /form
|
| And last, make sure you've got backup code just in case the user doesn't
| have JavaScript turned on:
|
| ---redirect.cfm---
| cflocation url=#form.theurl# addtoken=no
|
| ---mark



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



OT: JavaScript Help

2001-06-08 Thread Todd Ashworth

This is slowly driving me insane .. you would think this would be an easy
thing to do (what I'm trying to accomplish, not driving me insane =-p )

I have a table with dynamicly generated rows.  Each row has 2 cells.  The
first cell in each row has an ID.  When a row is clicked it triggers a
JavaScript function and passes the ID of the first cell to it.  When this
happens, I want the function to change the background color of the first
cell.  Here is what I have so far:

function addStudentToList(studentPK) {

tdID = id + studentPK;

if (studentList.Item(studentPK) == studentPK) {
studentList.Remove(studentPK);
document.all.tdID.runtimeStyle.backgroundColor =
document.all.tdID.style.backgroundColor;
}
else {
studentList.Item(studentPK) = studentPK;
document.all.tdID.runtimeStyle.backgroundColor = yellow;
}
}

tdID is the variable that contains the ID of the first cell.  It looks
something like id38, etc.  How do I get JavaScript to evaluate tdID into
its true value and not think that I'm refering to an object named tdID?

Anyone?

Todd



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Need decryptor tag for CFUG presentation

2001-06-08 Thread Todd Ashworth

There is a very grey line here .. maybe.  Take this real life example:

We had a father/son team that worked for my company.  The father was one of
the ones who helped start the company and greatly responisble for making it
successful durring its startup phase.  As the company grew, the ideas about
how it should continue differed between one of the founders and the father.
The father eventually left on somewhat 'bad' terms.  Soon after, his son
also left the company .. also on somewhat bad terms.  The father joined a
company that made similar, but not competing products.  Soon after, that
company decided to make a competing product.  Luckily, the father knew the
industry, but not how the product was made.  Unfortunately, the son worked
on the product itself and knew a fair bit about how it worked.  The son had
some copies of the compiled code.  He and a buddy managed to reverse
engineer it and (as far as we know), deliver the source code to the
competing company so they could learn how the program worked.  I'm sure
the intent was to learn how we did things and, ahem, build on those ideas.
Was this just leanring from another developer to learn how to dome something
better, or, was it plain code theft. Is there a difference in this case
(they were using a different language)?Luckily, they weren't too bright and
wasted time building a product for a market that was already at least 50%
saturated (a lot for market share among government agencies ;), so they
weren't much of a threat .. but still 

Now .. most would certainly agree that this is just flat out wrong, ethicly
as well as legaly, but the grey area is .. how wrong is it, ethicly, to
reverse engineer a program to learn how another developer accomplished
something so that a particular way of doing things can be learned to build a
non competing product?  What about just for personal knowledge?

It's starting to look like, it's just how you look at it ;)

Todd

- Original Message -
From: Kevin Mansel [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 4:44 PM
Subject: RE: Need decryptor tag for CFUG presentation


 Well i'm not talking about plagerism, i'm talking about studying the code,
 how they made it work, etc, etcthen developing your own application,
 that is how a lot of us learned from bookes that we've bought, starting
out
 with cold fusion, I am sure most of us put in a few bits of code mentioned
 in forta's books, and tried it out, then took off with it right?   That is
 what my majority point is.

 kev



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Need decryptor tag for CFUG presentation

2001-06-08 Thread Todd Ashworth

We consulted one ..

Unfortunately, while we *can* prove this, through at least one E-mail, we
legaly intercepted, we didn't have the time or the finances to persue the
matter, since we were actively engaging the Texas Department on Aging in
major contract negotiations and didn't have the resources to spare.  Also,
the son was not an employee of the company in question, so collecting
damages from him, personaly, would be difficult at best.  In short, the
whole legal process would probably cost more than the damages that we would
be awarded.  Better to see them waste their time and money and kill their
own chances of getting in on the market than to take them to court :)

Todd

- Original Message -
From: Steve Drucker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 9:07 PM
Subject: RE: Need decryptor tag for CFUG presentation


 Well, I believe the current federal guidelines indicate a STATUTORY $100K
 per incident fine for the type of copyright infringement you are
describing.

 Time to find an attorney.

 -S



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Error pages

2001-05-28 Thread Todd Ashworth

 This is my first go around so I won't be using cfcatch/cftry (unless I
 really should)

You *always* should, every time you think you *might* run into *any* type of
error .. and even when you don't think you will, at all.  :)

 but I'm wondering how many of you have the error page
 e-mail you with information?

My take is that the app should always E-mail/contact *someone* .. it means
that the user has done something that no one ever expected and someone needs
to do something about it.

 If so, what information do you have it e-mail to you?

All info that the developer needs to fix the prob and that the user should
never see .. directory path, file name, database error, etc.

 Is there a way to have it capture the original error message, the one
 that appears before the pretty new page, and have that e-mailed off to the
 admin?

Look up the help doc on cfcatch/cftry.  The only pretty page that the user
needs to see is that an error has occured and that the 'admins' will fix it
soon.  Anything else should provide contact info to follow-up, if needed.

You should be able to combine both functions into one page, so that the app
displays both the error to the user and also E-mails the problem to the
admin(s).

Todd

  I have just written my first web app with cold fusion and I'm wondering
 what
  standard practice is with cferror
 
  This is my first go around so I won't be using cfcatch/cftry (unless I
  really should) but I'm wondering how many of you have the error page
 e-mail
  you with information? If so, what information do you have it e-mail to
 you?
  Is there a way to have it capture the original error message, the one
 that
  appears before the pretty new page, and have that e-mailed off to the
 admin?
 
  Thanks for your time
 
  Jason Stevens
  CF-developer in training



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



hiding the path of an included file

2001-05-15 Thread Todd Ashworth

I have this in one of my style sheets:

..mask {
cfoutputbehavior :
url(#Attributes.ApplicationPath#/mask_js.htc);/cfoutput
}

When this runs, it shows the path to the mask_js.htc file if someone views
source.  I would like to hide this path, so that no one can download thit
file easily.  Unfortunately, the behavior property only uses URLs, so I
can't specify an unreachable absolute path.

Any ideas?

Todd



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Strange problem (or still asleep)

2001-05-15 Thread Todd Ashworth

Change your OR to AND :)

Todd Ashworth --
Certified ColdFusion Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: David Baskin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 2:20 PM
Subject: Strange problem (or still asleep)


| Hello, i'm running the code below and i'm not getting the expected
results.
| i'm passing in a variable with the length of 5 so i would expect that the
| errorString would not be appended, but in fact it is. The same thing
happens
| when i pass in a variable with the length of 9. I can't seem to figure out
| why this is happening. Can anyone help? Sorry if this is way basic.
|
| david
|
| code:
|
| script
| 
| }else if((LEN(cleanZipcode) NEQ 5) OR (LEN(cleanZipcode) NEQ 9)){
| errorString = ListAppend(errorString, Please enter a valid
| zipcode (too long/short), |);
| errorFlags = ListAppend(errorFlags, zp, |);
| 
| /script
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Here's an idea ... hiding the path of an included file

2001-05-15 Thread Todd Ashworth
 provided sooner.

Please don't think that I just sit around all the time not caring what
happens to our hosting customers with a Scew it!  I'll do it when I get
around to it whenever I feel like it! attitude.  Durring the
afformentioned, very, nasty outage, I gave a few customers my home phone
number so they could contact me, personally, after 'normal' work hours if
they needed/wanted to.

So .. as an aside to How long would the rest of you tolerate your hosting
company having your site broken?   15 minutes?  30minutes?   How about 2
weeks, how many web hosts do you know that give you direct access to
the network administrator who would also give out his home phone number to
some clients when things got rough?

/To Mike

Like I said before, this is NOT an attack against Mike.  He has a *very*
legitimate complaint and I don't blame him for getting frustrated with the
whole mess.  I just wanted to represent our point of view.

Mike, if you have anymore concerns, contact me directly, either through
E-mail, or through the toll free number and personal extension, which I will
provide if you want it.  I don't mind you posting complaints to the list
(all is fair, afterall, other than the off-topic nature), but a lot of
times, due to the nature of the lists, I don't get any of the E-mails until
several hours after they have been posted.  I'd rather address your concerns
sooner than later.

I just don't want there to be any more misunderstandings.

Todd Ashworth
Certified ColdFusion Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)

- Original Message -
From: Mike Kear [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 12:00 PM
Subject: Here's an idea ... hiding the path of an included file


 Hey Todd, here's an idea .. .you could put that project down while you
think
 about it .. then while you're not working on it, you could help me get my
  AND I AM STILL UNABLE TO
 CHECK ITS ALL WORKING.  THE OTHER HAS JUST VANISHED.

 HEY IVE BEEN ASKING FOR A WEEK  . . .   I NEED THE INFORMATION YOU
PROMISED
 TO GET MY SITES GOING AGAIN

 How long would the rest of you tolerate your hosting company having your
 site broken?   15 minutes?  30minutes?   How about 2 weeks??And he
 has time to work on developing pages while my fricken sites are down
MY
 GAWD!

 Cheers,
 Mike Kear
 Windsor, NSW, Australia
 AFP Webworks

 -Original Message-
 From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, May 16, 2001 12:42 AM
 To: CF-Talk
 Subject: hiding the path of an included file

 I have this in one of my style sheets:

 ..mask {
 cfoutputbehavior :
 url(#Attributes.ApplicationPath#/mask_js.htc);/cfoutput
 }

 When this runs, it shows the path to the mask_js.htc file if someone views
 source.  I would like to hide this path, so that no one can download thit
 file easily.  Unfortunately, the behavior property only uses URLs, so I
 can't specify an unreachable absolute path.

 Any ideas?

 Todd



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: [CF-Talk Archiver]

2001-05-14 Thread Todd Ashworth

Yes .. observe the bottom of every E-mail ;)

| Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/

I don't like the format all that much; maybe this new one is better?  :)

Todd

- Original Message -
From: Alex [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, May 14, 2001 9:43 AM
Subject: Re: [CF-Talk Archiver]


| Doesn't CF-Talk already archive the emails?
|
| Peter Tilbrook [EMAIL PROTECTED] wrote:
| I am currently putting the finishing touches on a small CF application
| that reads in email messages, in this case CF-Talk email, stores them in a
| database and makes the database searchable (via Verity).
|
| The final application will be able to do the same with any email address
| but hey CF-Talk deserves posterity so I wrote it for that purpose.
|
| The finished version will be postcardware, ie: send me a postcard and I
| will send you the full code via email.
|
| Cheers!
|
| PT
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Passing 500 client-side variables to the server

2001-05-11 Thread Todd Ashworth

I have a string of about 500 variables that is generated client-side by
JavaScript.  I need to get it to the server somehow.  The string is far too
long to be passed in the URL.  How could I get it to the server for
processing?  Anyone have any ideas?

Todd



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Passing 500 client-side variables to the server

2001-05-11 Thread Todd Ashworth

A hidden form fiield .. oh jeez!!!  I feel so dumb.  I've been working on so
much complicated code that I'm begining to look for a complicated solution
for everything  heh

I'm not the one coding that section, so I'm not sure what they are.  I think
they are just one long '' delimited string.  I think what we have decided
to do is pass the information that the javascript uses to generate the
variables (a date range and a data dictionary) to the server and create the
variables server-side. We might even let the SQL server do it.  This
approach is probably faster overall.

Thanks all!

Todd


- Original Message -
From: Craig Bowes [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, May 11, 2001 6:30 PM
Subject: RE: Passing 500 client-side variables to the server


 There are a number of ways to do this.  You could set a form field to be
 kind of a structure input type=hidden value=var1=value1,var2=value2
by
 using javascript and then have javascript submit the form and have
 coldfusion parse this.  Are these variables stored as a javascript array
or
 just a bunch of different variables?

 -Original Message-
 From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
 Sent: Friday, May 11, 2001 3:32 PM
 To: CF-Talk
 Subject: Passing 500 client-side variables to the server

 I have a string of about 500 variables that is generated client-side by
 JavaScript.  I need to get it to the server somehow.  The string is far
too
 long to be passed in the URL.  How could I get it to the server for
 processing?  Anyone have any ideas?

 Todd




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Problem with page showing blank

2001-05-05 Thread Todd Ashworth

One possible problem .. check to see if you have something that looks like
this:

!--- bunch of stuff goes here --

Note that the !--- doesn't end with a ---, but a --

This tends to screw up your whole page and will cause blank displays.

Todd

- Original Message -
From: Hubert Earl [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, May 05, 2001 11:10 PM
Subject: Problem with page showing blank


 hi,

 i have a form, composed of both htm and cfm tags, which shows blank.  if i
rename it with an htm extension, it appears.  i guess that this indicates
that the problem is in the cfm code, but darned if i could see the problem!
i'd appreciate any suggestions as to what sort of things i should be
checking for.

 hubert
 ---
 Hubert Earl

 ICQ#: 16199853
 AIM: hubertfme

 My Jamaican Art, Craft  More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Problem with page showing blank

2001-05-05 Thread Todd Ashworth

No .. 2 dashes = HTML comment .. 3 dashes = CFML comment. As long as you
don't mix and match the 2, you should be OK in that respect.

Todd

- Original Message -
From: Hubert Earl [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, May 05, 2001 11:42 PM
Subject: Re: Problem with page showing blank


 hi,

 thanks for the feedback.  actually, all my comments use two dashes before
 and after the comment, not three.  could that be the problem?

 hubert
 ---
 Hubert Earl

 ICQ#: 16199853
 AIM: hubertfme

 My Jamaican Art, Craft  More Online Store:
 http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html


 - Original Message -
 From: Todd Ashworth [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Sunday, May 06, 2001 12:25 AM
 Subject: Re: Problem with page showing blank


  One possible problem .. check to see if you have something that looks
like
  this:
 
  !--- bunch of stuff goes here --
 
  Note that the !--- doesn't end with a ---, but a --
 
  This tends to screw up your whole page and will cause blank displays.
 
  Todd
 
  - Original Message -
  From: Hubert Earl [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Saturday, May 05, 2001 11:10 PM
  Subject: Problem with page showing blank
 
 
   hi,
  
   i have a form, composed of both htm and cfm tags, which shows blank.
if
 i
  rename it with an htm extension, it appears.  i guess that this
indicates
  that the problem is in the cfm code, but darned if i could see the
 problem!
  i'd appreciate any suggestions as to what sort of things i should be
  checking for.
  
   hubert
   ---
   Hubert Earl
  
   ICQ#: 16199853
   AIM: hubertfme
  
   My Jamaican Art, Craft  More Online Store:
  http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
  
  
  
  
  
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF-Certification

2001-05-04 Thread Todd Ashworth

Yeah .. don't fail ;)

Actually, on tip is, don't rush!  There is plenty of time to finish the
test.  When I took mine, I felt really pressured and rushed through it.  I
didn't need to .. I finished with 25 minutes to spare.  Also, make sure you
read the instructions for each question.  Sometimes there are multiple
correct answers, so make sure you are aware of how many things you are
supposed to select.

Todd Ashworth --
Certified ColdFusion Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]

- Original Message -
From: Brad Comer [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 04, 2001 11:08 AM
Subject: CF-Certification


| I am going to take the CF Cert. Exam in about an hourany pointers???
|
| Thanks In Advance!
| Brad
| [EMAIL PROTECTED]
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: cfloop help!

2001-05-04 Thread Todd Ashworth

get rid of getusers in getusers.userID

cfoutput query=getusers
#getusers.userID# cfloop query=getm(#userID#,#getm.userID#)
/cfloopp
/cfoutput

Todd

- Original Message -
From: Diana Nichols [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 04, 2001 3:34 PM
Subject: cfloop help!


| I must be blind today - I've used cfloops like this many timesbut the
| output is wrong#@!$@#!^%$
|
| I've reduced the code to see what was happening, and the value of the
userID
| the getusers query is not updating with each iteration of the outputin
| other words, this code:
|
| cfquery name=getusers datasource=#dsn#
| select userID
| from users
| where companyID = 1
| /cfquery
| cfquery name=getm datasource=#dsn2#
| select userID
| from billing
| where companyID = 1
| /cfquery
| table
|
| cfoutput query=getusers
| #getusers.userID# cfloop query=getm(#getusers.userID#,#getm.userID#)
| /cfloopp
| /cfoutput
|
| produces this output:
|
| 1 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 4 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 19 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 22 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 23 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| I don't have a clue what I've done wronghelp, please!
|
| TIA!
| D
|
| *
| Diana Nichols
| Webmistress
| http://www.lavenderthreads.com
| 770.434.7374
|
| One man's magic is another man's engineering. ---Lazarus Long
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Whats happening to Spectra

2001-04-25 Thread Todd Ashworth

Theres been a huge discussion about this the last 2 days or so across many
of the lists.  Check the archives.

http://www.mail-archive.com/cf-talk@houseoffusion.com/

http://www.mail-archive.com/spectra-talk@houseoffusion.com/

http://www.mail-archive.com/cf-community@houseoffusion.com/

Also, here is a letter from MM:

Hi everyone.  We really appreciate everyone's patience over the last few
weeks.  There has been a lot of discussion and concern over the future of
Spectra, and I think that the time is right to shed some light on what we
are thinking.

As you know, Spectra provides developers with a broad set of functionality
and technology.  Enough so, sometimes its breadth proves daunting.
Fundamental to the entire product, however, is its foundation  - the content
object API.  In 1996, when I first started working on Allaire's website, the
foundational change that I went through was around thinking about the site
as composed of 'content objects.' Over the last 5 years, this core concept
has been revised, revolutionized, improved, and expanded. Spectra has been
the product that carried this concept forward. This concept, and the content
object API, have been the most compelling pieces of Spectra since its
inception.

Macromedia's goal is to make dynamic content technology like the content
object API pervasive, approachable, and cost effective for our developers.
To help us better achieve this, we plan to incorporate key components of
Spectra technology - a Java-based version of the COAPI architecture and
other services directly related to dynamic content - into the application
server, as well as delivering next generation dynamic content technologies
such as end-user content contribution and team production through a series
of new product initiatives. This means that version 1.5 will be Spectra's
last feature additive release - we'll invest our resources in making the
core technology that we move into our application server and visual tools
faster, easier, and better.

Macromedia will continue to support Spectra via a community source model,
on-going technical support, training, and consulting, as well as having a
team of engineers working on bug fixes and quality assurance for community
source submissions. Spectra will continue to be offered for sale, using our
partners as the primary sales channel.  We also will do our best to give you
early access to technology previews, alphas, and betas of the new
technologies already under development.

In the world we live and work in, technology changes constantly, we've all
thrived because of our ability to adapt to change.  This is no different - a
change for the Spectra Product Group, and for every developer, customer and
partner out there who has invested their valuable time and mind share into
Spectra.  While I understand the challenge that a change like this can pose,
I am extremely optimistic.  The core vision of the Spectra technology is
compelling  - the opportunity to make this technology available to more
developers, cheaper, and better, is a chance that I relish.  I hope you
share my optimism through this time of change.

You can direct questions and comments to a couple of places:
1) Via Phone at:
866-236-1146 (North America Toll Free)
800-25524731, (International Toll Free)
617-219-3010 (Direct Dial Long Distance)
2) Via Email:
[EMAIL PROTECTED]

I can speak for the Spectra Product Group and Macromedia when I say how much
we value the community of developers that use our products.  Spectra is no
exception. We have an incredible community, and one that we want to
continue.

-c

Todd Ashworth --
Certified ColdFusion Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: Haroon Williams [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, April 25, 2001 9:14 AM
Subject: Whats happening to Spectra


| Is it just a rumour, or has Spectra been discontinued?
|
| Haroon Williams
| Group IT
| Investec Bank
| Tel 011 286 7529
| Fax 011 286 7522
| Cell 082 853 4286
| Email [EMAIL PROTECTED]
|
|
|
|
| *
| NOTICE - This message contains privileged and
| confidential information intended only for the use of the
| addressee named above. If you are not the intended
| recipient of this message, you are hereby notified that
| you must not disseminate, copy or take any action in
| reliance on it. If you have received this message in error,
| please notify Investec Group, its subsidiaries or associates,
| immediately.  Any views expressed in this message are
| those of the individual sender, except where the sender
| specifically states them to be the view of Investec Group,
| its subsidiaries or associates.
| **
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book

Re: problem with orderby in a varchar field

2001-04-25 Thread Todd Ashworth

ORDER BY, not ORDERBY :)

I'm supprised you aren't getting an error.

Todd

- Original Message -
From: paul . [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, April 25, 2001 9:24 AM
Subject: problem with orderby in a varchar field


| HI Guys
| Kindly help
| using orderby is not working ; when I use to make the sort using a field
which is a varchar??
| my query
| select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDERBY
issues ASC
| the issue is a field which is varchar(100)
| kindly suggest
| -paul
|
|
|
| Get 250 color business cards for FREE!
| http://businesscards.lycos.com/vp/fastpath/
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: What about a CHAT solution? Was Re: Character code for a TAB

2001-04-24 Thread Todd Ashworth

What would even be better than a chat room would be to have a collection of
descriptions of all the tags and functions available and the correct syntax
to use them properly ... almost like a reference manual of some kind. ;)

Todd

- Original Message -
From: Dick Applebaum [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 12:47 PM
Subject: What about a CHAT solution? Was Re: Character code for a TAB


| Don't know if a chat would help... you'd just flood the chat room
| with answers... it'd be faster tho
|
| Dick



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: What about a CHAT solution? Was Re: Character code for a TAB

2001-04-24 Thread Todd Ashworth

I know .. I was being a tiny bit sarcastic ;)

Todd Ashworth --
Certified ColdFusion Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]

- Original Message -
From: Michael Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 2:04 PM
Subject: Re: What about a CHAT solution? Was Re: Character code for a TAB


| A complete list of ALL CF functions was posted up to the front of
| www.houseoffusion.com a number of weeks back. And there's always the
| standard docs.
|
|
|  What would even be better than a chat room would be to have a collection
| of
|  descriptions of all the tags and functions available and the correct
| syntax
|  to use them properly ... almost like a reference manual of some kind. ;)
| 
|  Todd
| 
|  - Original Message -
|  From: Dick Applebaum [EMAIL PROTECTED]
|  To: CF-Talk [EMAIL PROTECTED]
|  Sent: Tuesday, April 24, 2001 12:47 PM
|  Subject: What about a CHAT solution? Was Re: Character code for a TAB
| 
| 
|  | Don't know if a chat would help... you'd just flood the chat room
|  | with answers... it'd be faster tho
|  |
|  | Dick
| 
| 
| 
| 
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Image size

2001-04-20 Thread Todd Ashworth

http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3475C6-2830-11D4-AA
9700508B94F380method=Full

Todd Ashworth --

- Original Message -
From: "Skip Ogden" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, April 20, 2001 3:07 PM
Subject: Image size


| The Allaire Developers forum used to have a tag called cfx_imagesize (or
| something close to that). It isn't there any more, or I can't locate it.
|
| Does anyone know of ANY way to automatically create a thumbnail from an
| image as it is uploaded (with cffile)
|
| Thanks...
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Request vs. Application scope

2001-04-19 Thread Todd Ashworth

You also need to lock your application variables, which add some additional
overhead.

Todd

- Original Message -
From: "Andrew Tyrone" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, April 19, 2001 6:17 PM
Subject: RE: Request vs. Application scope


  -Original Message-
  From: Jason Lotz [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, April 19, 2001 4:25 PM
  To: CF-Talk
  Subject: Request vs. Application scope
 
 
  I have noticed that I can easily interchange the use of Application and
  Request scoped variables.  Both are easily accessible in custom
  tags and are
  only exist for the current http request.  So, what are good reasons to
use
  one instead of the other?
 
  Jason


 Application variables are actually good for all requests for the life of
the application (set in the cfapplication tag with the applicationtimeout
attribute).  Request variables are only good for the lifetime of the page
that gets called (including any cfinluded files and custom tags, nested or
not).  Application variables are available to all users and only have to be
set once, unless the application times out.  In this case, they can be set
again, and checked beforehand with IsDefined() so as not to set them when
you don't need to.  Read up on session management in the ColdFusion
documentation.


 - Andy



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Hey Check This Out?!?!

2001-04-19 Thread Todd Ashworth

http://www.mail-archive.com/cgi-bin/htsearch?method=andformat=shortconfig=
cf-talk_houseoffusion_comrestrict=exclude=words=CFTempOnlyForSetVariableN
everUseThisNameInYourCFMLCode1223335654321

Todd Ashworth

- Original Message -
From: "Kevin Mansel" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, April 19, 2001 6:48 PM
Subject: Hey Check This Out?!?!


 Anyone ever seen this



 An error has occurred while processing the expression:

!airheadjb_test=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode122333
5654321


 Invalid token found on line 1 at position 1. ColdFusion was looking at the
following text:

 !
 Invalid expression element. The usual cause of this error is a misspelling
in the expression text.

 The error occurred while processing an element with a general identifier
of (CFFTP), occupying document position (49:1) to (49:208).

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: SQL update not executing?

2001-04-19 Thread Todd Ashworth

This has nothing to do with your current question, but as to your earlier
question, our DBA says it can't be done on the application level (in a web
based environment, due to its stateless nature) and is dubious as a Stored
Procedure.  I'll bug him more about it tomorrow and see if he can't come up
with a 'different' solution.

Todd Ashworth

- Original Message -
From: "Jon Hall" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, April 19, 2001 9:48 PM
Subject: SQL update not executing?


 OK, no response on the question earlier, but maybe someone has seen this
or
 can help me figure out where to look...
 I have a page which every once in a while will execute fully, but there is
 an update statement that does not update the database even though I see
the
 query in my debug. Here is a snip from the debug:

  (Records=0, Time=100ms)
 SQL =
 UPDATE banners
 WITH (ROWLOCK)
 SET views = views + 1, next_rotation = next_rotation + 16
 WHERE adid = 2

 The debug says it happened , however when I go look at the db right after
 this statement and the next_rotation field  hasn't budged! This does not
 happen every time, however it always does happen eventually. It only
happens
 however, when I am stressing the application (which is a banner app...)
with
 a simple 8 frame meta refresh page i did up.

 Some background info, this app is running on my local machines CF
 Server(5b3), the SQL Server is on my local machine (v7).
 The same thing happens though on a CF 4.5 production machine also
though...

 jon



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Hey Check This Out?!?!

2001-04-19 Thread Todd Ashworth

You need to make sure you get all of the URL.  When outlook/outlook express
sends/recieves an E-mail, it tends to break up strings that are over a
certain length.  Make sure you get all the parts and put them back together.
This means that you will probably have to copy and paste them into a browser
manually, each line at a time, for long URLs, like the one I posted.

Or, you could always go to the archive page:

http://www.mail-archive.com/cf-talk@houseoffusion.com/

and search for:


CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321

which is all I did.

Todd Ashworth

- Original Message -
From: "kmansel" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, April 19, 2001 11:08 PM
Subject: Re: Hey Check This Out?!?!


 Nothing came up??

  Original Message 
 From: [EMAIL PROTECTED]
 To: [EMAIL PROTECTED],
 Subject: Re: Hey Check This Out?!?!
 Date: Thu, 19 Apr 2001 19:45:23 -0400

 http://www.mail-archive.com/cgi-bin/htsearch?method=andformat=short;
 config=
 cf-talk_houseoffusion_comrestrict=exclude=words=CFTempOnlyForSetVa
 riableN
 everUseThisNameInYourCFMLCode12233344445654321
 
 Todd Ashworth



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: DNS

2001-04-17 Thread Todd Ashworth

You'll probably get a lot better, more useful info from the DNS folks at
[EMAIL PROTECTED]

You can sign up to the list here: http://isp-lists.isp-planet.com/isp-dns/

Todd Ashworth --

- Original Message -
From: "Dylan Bromby" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 12:02 AM
Subject: OT: DNS


| i'm planning on migrating from MetaIP to Win2K DNS. has anyone made this
| particular migration? any recommendations? has anyone had any trouble with
| DNS on Win2K?
|
| tia.
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: ENcoding URL

2001-04-17 Thread Todd Ashworth

From the CFStudio help files:

Encrypt
Encrypts a string. The Encrypt function uses a symmetric key-based algorithm
in which the key used to encrypt a string is the same key as the one used to
decrypt the string. The security of the encrypted string hinges on
maintaining the secrecy of the key. In particular, Encrypt uses an XOR-based
algorithm that utilizes a pseudo-random 32-bit key based on a seed passed by
the user as a parameter to the function. The resultant data is UUencoded and
may be as much as three times the original size.

See also Decrypt.

Syntax
Encrypt(string, seed)

string
String to be encrypted.

seed
String specifying the seed to be used to generate the 32-bit key needed to
encrypt the string.

Examples
!--- This example shows the use of Encrypt and Decrypt ---
HTML
HEAD
TITLEEncrypt Example/TITLE
/HEAD

BODY BGCOLOR=silver
H3Encrypt Example/H3

PThis function allows for the encryption and decryption of a
string. Try it out by entering your own string and a key of your
own choosing and seeing the results.
CFIF IsDefined("FORM.myString")
   CFSET string = FORM.myString
   CFSET key = FORM.myKey
   CFSET encrypted = encrypt(string, key)
   CFSET decrypted = decrypt(encrypted, key)
   CFOUTPUT
 H4BThe string:/B/H4 #string# BR
 H4BThe key:/B/H4 #key#BR
 H4BEncrypted:/B/H4 #encrypted#BR
 H4BDecrypted:/B/H4 #decrypted#BR
/CFOUTPUT
/CFIF
FORM ACTION="encrypt.cfm" METHOD="post"
PInput your key:
PINPUT TYPE="Text" NAME="myKey" VALUE="foobar"
PInput your string to be encrypted:
PtextArea NAME="myString" cols="40" rows="5" WRAP="VIRTUAL"
This string will be encrypted (try typing some more)
/textArea
INPUT TYPE="Submit" VALUE="Encrypt my String"
/FORM
/BODY
/HTML

Todd

- Original Message -
From: "Pooh Bear" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 6:49 PM
Subject: RE: ENcoding URL


 how do I encrypt the string?! :(


 From: "Dylan Bromby" [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Subject: RE: ENcoding URL
 Date: Tue, 17 Apr 2001 14:11:29 -0700
 
 sure there is.
 
 encrypt the strings. i do it all the time. i also make the key for
 encryption dynamic so the URLs can't be copied  pasted.
 
 on top of which, in some cases i URLEncodedFormat() the already encrypted
 strings. which further makes them undecipherable.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Query string disappear

2001-04-17 Thread Todd Ashworth

Ahh .. my bad .. Jeff is right :)  Pass them in hidden form fields, or by a
form post method, or by frames  that's about it.

Todd

- Original Message -
From: "Garza, Jeff" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 17, 2001 11:10 PM
Subject: RE: Query string disappear


 Todd,

 While I agree with you (I also use the encrypt function to obfuscate my
url
 vars) the original question asked how to pass url variables without them
 showing up and really you can't.

 Jeff Garza
 Webmaster
 Spectrum Astro, Inc.
 [EMAIL PROTECTED]



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: What and why are these errors happening?

2001-04-11 Thread Todd Ashworth

Naa .. the quotes don't matter :)  Being forced to use one type of quotes
over another would cause problems in many situations.  For example:

cfset Request.MyVar = "IsDefined("Session.ID")"

could cause problems, but

cfset Request.MyVar = "IsDefined('Session.ID')"

would be fine :)

Todd Ashworth
Certified ColdFusion Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)

- Original Message -
From: "Peter J. MacDonald" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, April 11, 2001 7:42 PM
Subject: RE: What and why are these errors happening?


 Bud,

 I think the single quotes need to be double quotes.

 cfif not isdefined('session.id') changed to

 cfif not isdefined("session.id")

 Thank You,
 Peter

 Peter J. MacDonald II
 Creative Computing, Inc.
 100 Middle Street
 Lincoln, RI 02865
 Phone: 401.727.0183 x123
 Fax: 401.727.4998
 Portable: 401.965.3661
 E-MAIL: [EMAIL PROTECTED]
 Web Page: www.creatcomp.com



 -Original Message-
 From: Bud [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 11, 2001 6:10 PM
 To: CF-Talk
 Subject: What and why are these errors happening?


 I get this error in my application.log file. All on the same site:

 "Error resolving parameter SESSION.ID The session variable ID does not
 exist.

 In my application.cfm I have:

 cfif not isdefined('session.id')cfset session.id = ""

 So how can that happen? CFAS doesn't show a restart at the time of the
 errors.

 Also. What is this and how do I fix it? :-D

 "Error","TID=140","04/11/01","17:25:37","Unable to write reply --
 timed out writing data back to web server."
 "Error","TID=140","04/11/01","17:25:37","Windows NT error number 1460
 occurred."

 Thanks!
 --

 Bud Schneehagen - Tropical Web Creations

 _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
 ColdFusion Solutions / eCommerce Development
 [EMAIL PROTECTED]
 http://www.twcreations.com/
 954.721.3452

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: when is CF5 release? (a little OT)

2001-04-11 Thread Todd Ashworth

OK .. as a diversion from the current topic, is anyone developing stuff for
CF 5 based on what they have seen so far?  We are building an app that could
benifit from some of CF 5's features. We would like to 'build for' CF 5 if
it will be released within the next 3 months.  Otherwise, we will have to
make do with 4.5 and worry about a later version release, well, later. :)

Todd Ashworth
Certified ColdFusion Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)

- Original Message -
From: "Peter Tilbrook" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, April 11, 2001 9:44 PM
Subject: RE: when is CF5 release?


 It's still in beta (version 3.0 at last check).

 Allaire usually release a couple of "Release Candidates" before shipping
 final code so it will probably be a few months yet.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Documentation (Was: Stupid Question? - Commenting Code That Does Not Show in Browser)

2001-04-03 Thread Todd Ashworth

There is something similar to this that the Fusebox folks use.  It works
pretty well and is standardized.  The theory is that you should be able to
wirte up your documentation about a page and then hand it over to someone
who doesn't know a thing about the project and they would still be able to
write the code.  If you are interested, look up "Fusedocs" on
www.fusebox.org

Todd Ashworth --
Certified ColdFusion Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]

- Original Message -
From: "Jeffry Houser" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, April 03, 2001 7:25 PM
Subject: RE: Documentation (Was: Stupid Question? - Commenting Code That
Does Not Show in Browser)


|
|   I use something similar to that on steroids:
|
| !---
| Date: Self explanatory
| Creator: Jeff Houser, DotComIt (That way I get the credit--blame--when
| something goes wrong)
| Description: Blahblahblah self explanatory
|
| Entering: (I.E. where did we come from?)
| Exiting: (I.E. where are we going too?)(The entering / exiting stuff
| describes the flow of logic)
|
| Dependencies: (Usually I list custom tags here)
|
| Expecting:  (What variables are we expecting to be defined when we enter
| this template? Are they URL variables?  form variables?  Are we going to
| assign default values if they are undefined or throw up an error)
|
| Modification History:
| I'm not great about this one, but typically  I'll include the date, my
name
| / company, and a short description of the modifications.
| ---
|
|Yes, sometimes it can be tedious at times.  As Arden said.. for my
| sanity.  I don't list the name of the current file, because I figure any
| developer should know what file they are looking at.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Response header weirdness ...

2001-03-23 Thread Todd Ashworth

I sent this to the Fusebox list, but haven't gotten a response yet, so I
figured i will try my luck here.

I'm getting this info at the top of some of my pages.

HTTP/1.1 200 OK Server: Microsoft-IIS/4.0 Date: Fri, 23 Mar 2001 13:58:53
GMT Connection: close Content-type: text/html Page-Completion-Status: Normal
Page-Completion-Status: Normal

I never saw this until I started using Fusebox.  I thought it might be
something normal that
I just didn't have turned off, but after looking through the archives and
not really finding much on it, I'm assuming it's not "normal".  Does anyone
know how to prevent this response info from showing up?

Todd Ashworth --



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF DNS

2001-03-22 Thread Todd Ashworth

Yeah .. for BIND on Linux it's just as easy as appending to one text file,
and creating another.  Then just restart the daemon and away you go.

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]

|  -Original Message-
|  From: Jon Hall [mailto:[EMAIL PROTECTED]]
|  Sent: Thursday, March 22, 2001 3:07 PM
|  To: CF-Talk
|  Subject: Re: CF  DNS
| 
| 
|  It's not really that hard to figure out the sturcture of the dns record
|  files. Just open one up and the write a program that will write the same
|  file with the right names in the right places. We wrote a program that
|  writes the dns files for Microsoft DNS server...
| 
|  jon
|  - Original Message -
|  From: "Jason Larson" [EMAIL PROTECTED]
|  To: "CF-Talk" [EMAIL PROTECTED]
|  Sent: Thursday, March 22, 2001 1:29 PM
|  Subject: CF  DNS



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF DNS

2001-03-22 Thread Todd Ashworth

Actually, he asked about both ;)

-- snip --
Or anyone has built a CF app that interface's with a DNS Server Software,
i.e. SimpleDNS (www.simpledns.com)
-- snip --

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: "Len Conrad" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, March 22, 2001 4:55 PM
Subject: Re: CF  DNS


|
| It's not really that hard to figure out the sturcture of the dns record
| files. Just open one up and the write a program that will write the same
| file with the right names in the right places. We wrote a program that
| writes the dns files for Microsoft DNS server...
|
| He's asking about writing an internet domain service in CF, not about
| writing a database admin app that just writes out zone files.
|
| Len
|
|
|
| http://MenAndMice.com/DNS-training : In Austin, TX; SFO, CA; Paris,
| FR
| http://BIND8NT.MEIway.com : ISC BIND 8.2.3 "NT3" for NT4  W2K
| http://IMGate.MEIway.com  : Build free, hi-perf, anti-abuse mail gateways
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Need assistance:Nested CFLOOPs

2001-03-21 Thread Todd Ashworth

When you loop through a list of words, your "counter" isn't a number .. it's
the current word you are on in the list.  Therefore, the first time through,
"counter" is "Limited" .. the second time through, it is LTD.  When you use
"counter" as a number in ListGetAt(#CompanyList#,#counter#,","), I imagine
CF is getting confused and just picking the first thing it finds in the
list.

Try just cfoutputting your "counter" there instead of using ListGetAt() ..
or find the position of your "counter" in your list with ListFind() or
ListFindNoCase() and use that in your ListGetAt()

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: "Angél Stewart" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, March 21, 2001 2:42 PM
Subject: RE: Need assistance:Nested CFLOOPs


| umm..judgement.defendant is changing..thats not the problem.
|
| The problem is that it is not going over the list of words to search for.
| The list called Company List.
|
| So hence you see Limited,Limited,Limited Limited 7 times in the output.
|
| When what you should see is
|
| The Defendant IS:MOHD, SARI
| The Current List Item Is:Limited
| The Defendant IS:MOHD, SARI
| The Current List Item Is:Ltd
| The Defendant IS:MOHD, SARI
| The Current List Item Is:Ltd.
| The Defendant IS:MOHD, SARI
| The Current List Item Is:CO
| The Defendant IS:MOHD, SARI
| The Current List Item Is:CO.
| The Defendant IS:MOHD, SARI
| The Current List Item Is:THE
|
| etc. etc.
| But it is just picking up that first list item, Limited..and although it
is
| going over the thing 7 times..its not reading the other items in the list.
|
| I know there is some simple syntax error somewhere..I just can't find it.
|
| -Gel
|
|
|
| -Original Message-
| From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
| Sent: Wednesday, 21 March 2001 12:59
| To: CF-Talk
| Subject: RE: Need assistance:Nested CFLOOPs
|
|
| I just skimmed through it, and it seemed that your query output is not
| right.
|
| When u do a judgement.defendant inside that query loop, it will always
| remain the same.  it will always output the first row from that query.
| instead, just use defendant.  since you're already inside that query loop,
| it will refer to the query name.  there is no need to specify it
|
|
|
|
| -Original Message-
| From: Angél Stewart [mailto:[EMAIL PROTECTED]]
| Sent: Wednesday, March 21, 2001 9:39 AM
| To: CF-Talk
| Subject: Need assistance:Nested CFLOOPs
|
|
| Hi all.
|
| I am having a problem with a nested CFLOOP refusing to loop!
|
| The Code:
| cfloop query="judgement" startrow="1" endrow="20"
| CFSET CompanyList = "Limited,LTD,LTD.,CO,Co.,Company,,The"
| cfloop index="counter" list="#CompanyList#" delimiters=","
| CFOUTPUT The Defendant
| IS:#judgement.defendant#/cfoutput
| br
| CFSET
| WordToGet=ListGetAt(#CompanyList#,#counter#,",")
| CFOUTPUT The Current List Item
| Is:#WordToGet#/cfoutput
| br
| CFIF Find(judgement.defendant,#Counter#) neq 0
|
| CFOUTPUT  Hey! We Found A Company
| /cfoutput
|
| /cfif
| /CFLOOP
| /CFLOOP
|
| I want to search the defendant field to determine if any of those strings
| are contained within it.
| It cycled fine, until I enclosed it in the CFLOOP query="judgement"...
|
| I expected it to go to the first record in teh Judgement table..
|
| Then loop through the strings to search for, perform the search...and then
| drop out and CFQUERY LOOP back to the top..wher eit would go to the next
| record...and do the same thing.
|
| What's the problem with my code?
|
| This is my output:
|
| The Defendant IS:MOHD, SARI
| The Current List Item Is:Limited
| The Defendant IS:MOHD, SARI
| The Current List Item Is:Limited
| The Defendant IS:MOHD, SARI
| The Current List Item Is:Limited
| The Defendant IS:MOHD, ANSARI
| The Current List Item Is:Limited
| The Defendant IS:MOHD, SARI
| The Current List Item Is:Limited
| The Defendant IS:MOHD, SARI
| The Current List Item Is:Limited
| The Defendant IS:MOHD, SARI
| The Current List Item Is:Limited
| The Defendant IS:MOHD, SARI
|
| So it is clearly not cycling through the list of strings to search for.
|
| -Gel
|
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Java or C Sharp?

2001-03-21 Thread Todd Ashworth

Also maybe worth noting ... according to our guest speaker at our Feb. CFUG,
C# is more or less Java, with just a few little picky details changed.  I
assume that means, if you know one, you know the other ... syntax-wise,
anyway.  Still, i would stick with Java.

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]

- Original Message -
From: "Michael Dinowitz" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, March 21, 2001 3:10 PM
Subject: Re: Java or C Sharp?


| Java. Java classes can plug into CF with CFOBJECT/CreateObject(), Servlets
| work with JRun and Java is finally coming into its own on the server side.
| C# is to new and MS is still working on it and positioning it.
|
|
|  Which is more marketable for me?!!
| 
| 
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



cfexecute and prompts

2001-03-13 Thread Todd Ashworth

I am trying to run a program with cfexecute.  The problem I am having is
that the program has a prompt built into it.  Every time I run it via
cfexecute it gets to the prompt and just sits there waiting on an answer.
Does cfexecute have any provisions for skipping over things like this?  Is
there any way at all to get past the prompt programmatically?

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: [cfexecute and prompts]

2001-03-13 Thread Todd Ashworth

Basicly what I am doing is having someone upload a zip file which I can then
unzip using a command line program.

cfexecute name="#Attributes.ExecutionPath#wzunzip.exe" arguments="-ybc
#Attributes.DirectoryPath##File.ServerFile#
#Attributes.DirectoryPath#"/cfexecute

The first thing the command line program does upon being executed is ask a
question and wait for a response.  Since the execution can never be
completed, it just sits in memory forever.

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: "Alex" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 10:56 AM
Subject: Re: [cfexecute and prompts]


| yes. post your code.
|
| "Todd Ashworth" [EMAIL PROTECTED] wrote:
| I am trying to run a program with cfexecute.  The problem I am having is
| that the program has a prompt built into it.  Every time I run it via
| cfexecute it gets to the prompt and just sits there waiting on an
answer.
| Does cfexecute have any provisions for skipping over things like this?
Is
| there any way at all to get past the prompt programmatically?



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Coldfusion Timesheet application

2001-03-12 Thread Todd Ashworth

http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347421-2830-11D4-AA
9700508B94F380method=Full

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]

- Original Message -
From: "Carlo van Wyk" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, March 12, 2001 8:31 AM
Subject: Coldfusion Timesheet application


| Hi
|
| I'm looking for a simple Coldfusion Timesheet template that is free and
easy
| to modify. Any recomendations. If not - how would you go about setting up
a
| timesheet / expense report template?
|
| Regards
| Carlo
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF Application

2001-03-09 Thread Todd Ashworth

http://www.activefeedback.com/af/

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]

- Original Message -
From: "David Clay" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 09, 2001 12:40 PM
Subject: CF Application


| Does anyone know of a software application that was built in CF to conduct
surveys online.
|
| Your help would be greatly appreciated.
|
| Dave Clay
| Internet Facilitator
| Trus Joist, A Weyerhaeuser Business
| 5995 Greenwood Plaza Blvd, Suite 100
| Greenwood Village, CO 80111
| 303.770.8506
| 303.770.8506
|
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Finding the CF Administrator password

2001-03-09 Thread Todd Ashworth

I could, but I actually _need to know what the password is_ in this case.  I
need it to use it somewhere else and the only place I know I can find it for
sure is in the CF Administrator.  Like I said before, I know how to disable
the password, but that doesn't do me much good. :(

I'm supprised some talented CF hacker hasn't found a way to yank it out of
the registry and convert it back to its original form.

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: "Patricia Lee" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 09, 2001 4:39 PM
Subject: RE: Finding the CF Administrator password


| Not the answer you're looking for
|
| But ...
|
| Couldn't you disable the password so you could get back in and then reset
| the password?
|
| |-Original Message-
| |From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
| |Sent: Friday, March 09, 2001 4:28 PM
| |To: CF-Talk
| |Subject: Finding the CF Administrator password
| |
| |
| |A while back, someone posted something about a CF tag that
| |would find the
| |password for the CF Administrator for you.  Well, I need to find the
| |password for the CF Administrator on one of our machines here.
| | Does anyone
| |know of this tag?  Is there another way to find the password?
| |I know how to
| |disable it, but I actually need to find out what it is, so that doesn't
| |help.  I can see it in the registry, but it's encrypted.
| |Anyone have any
| |ideas?
| |
| |Todd Ashworth --
| |Web Application Developer
| |Network Administrator
| |
| |Saber Corporation
| |314 Oakland Ave.
| |Rock Hill, SC 29730
| |(803) 327-0137 [111]
| |
| |
| |
| |
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Finding the CF Administrator password - Also attn: Uwe

2001-03-09 Thread Todd Ashworth

OK .. 1 more time for those who might have missunderstood   =-p

I DO NOT want to disable the password.  I don't care about getting into the
CF Administrator.  I need to know what the password is because it is the
same password that I need to use to get into something else.  The person who
set up the password is no longer here, so I doubt I have any way of getting
it unless I can find it some place.  I know the password in the CF Admin is
the same one that I need and that's why I'm interested in it.
Unfortunately, when viewed from the registry, it's encrypted.  I was hoping
someone would know how to decrypt it, or knew a handy tag / tool for doing
such.

Uwe mentioned back in December that someone had given him such a tag, so
that's why I thought someone else might know.

Thanks all,

Todd Ashworth --

P.S. Uwe .. If you read this and you still have that tag, I would be most
appreciative if you could send it to me.  Thanks.

- Original Message -
From: "Tony Schreiber" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 09, 2001 4:37 AM
Subject: Re: Finding the CF Administrator password


| You can edit the registery to disable the password. Then log in (no
| password) and enable and change the password...
|
|  A while back, someone posted something about a CF tag that would find
the
|  password for the CF Administrator for you.  Well, I need to find the
|  password for the CF Administrator on one of our machines here.  Does
anyone
|  know of this tag?  Is there another way to find the password?  I know
how to
|  disable it, but I actually need to find out what it is, so that doesn't
|  help.  I can see it in the registry, but it's encrypted.  Anyone have
any
|  ideas?
| 
|  Todd Ashworth --
|  Web Application Developer
|  Network Administrator
| 
|  Saber Corporation
|  314 Oakland Ave.
|  Rock Hill, SC 29730
|  (803) 327-0137 [111]



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Finding the CF Administrator password

2001-03-09 Thread Todd Ashworth

Excellent.  What they are talking about looks likw what might be in the
registry.  This might just do what I want.  If so, that's 2 I owe ya ;)

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]

- Original Message -
From: "Jon Hall" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 09, 2001 5:22 PM
Subject: Re: Finding the CF Administrator password


| Check this link Todd.
| http://www.fusionauthority.com/alert/index.cfm?alertid=6#Tech1
|
| There are undocumented "Administrator" functions called
| CFusion_Encrypt()/CFusion_Decrypt.
| These are probably the functions that were used to encrypt the string...
|
| jon



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Dynamic Select Box??

2001-03-01 Thread Todd Ashworth

http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347197-2830-11D4-AA
9700508B94F380method=Full

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: "ibtoad" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 2:57 PM
Subject: Dynamic Select Box??


| Does anyone know of a custom tag that allows a 2 array select box that is
| dynamically populated?  Is this even possible?  In other words, the 2nd
| column will be populated differently depending on what is selected in teh
| 1st column with both columns being populated through output queries.
|
| Any Ideas?
| Thanks,
| Rich
|
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CF Studio 4.5.2 Error

2001-02-28 Thread Todd Ashworth

It happens to me.  I also get that even when hitting the save icon
sometimes.  I don't know of any fixes.

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: "Reilly, Jim" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 3:42 PM
Subject: CF Studio 4.5.2 Error


|
| When I save a file  (ctrl-s) in CF Studio 4.5.2,
| and my cursor is near a " or a #, it automatically
| adds another "  or # respectively, next to it.
|
| Does this happen to anyone else?   Fixes..?
|
| (this did not happen before I upgraded from 4.5.1)
|
|
| Tkx,
| Jim
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: HELP PLEASE! MS Access Trim Statement

2001-02-28 Thread Todd Ashworth

#ListGetAt('[EMAIL PROTECTED]', 2, "@")#

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: "Troy M. Wussow" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, February 28, 2001 2:28 PM
Subject: OT: HELP PLEASE! MS Access Trim Statement


| I am trying to separate an e-mail address from the domain - everything to
| the right of the "@" symbol.  I have 2 database fields named [Email] and
| [Domain] and I am trying to use either a MID or TRIM statement to copy
just
| the domain information into the [Domain] Field.
|
| Any suggestions would be greatly appreciated!!!
|
| Troy Wussow
| Web Developer - MIS
| National Seminars Group
|
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: CFMAIL not sending outside email messages

2001-02-26 Thread Todd Ashworth

What does your cfmail log file say?  It could be anything from a mail server
issue to a DNS issue.

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: "MIKE GEORGE" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, February 26, 2001 10:32 AM
Subject: CFMAIL not sending outside email messages


When using CFMAIL, and we send email to a person in our agency, the email is
sent fine. But if we try and send to someone outside our agency, the email
does not get sent.

Any ideas?

Thanks


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Referential Integrity

2001-02-26 Thread Todd Ashworth

Both :)

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]

- Original Message - 
From: "Cyrill Vatomsky" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, February 22, 2001 2:48 PM
Subject: Referential Integrity


| HI,
| 
| My question is whether it is better to write CF routines to maintain
| referential integrity of the database (say, hiding a delete button or
| checkbox if child records exist in another table) or to set up "Preserve
| Referential Integrity" rules in MS access and try to catch errors?
| 
| Which leads me to a theoretical question: should I rely more on built-in
| database functions or on CF?
| 
| Thanks,
| 
| Cyrill



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Cheaper Alternative to SQL Server 2000

2001-02-23 Thread Todd Ashworth

http://msdn.microsoft.com/subscriptions/prodinfo/overview.asp

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]

- Original Message -
From: "Jason Larson" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, February 23, 2001 10:56 AM
Subject: RE: Cheaper Alternative to SQL Server 2000


| I am going to be using this server for mostly development, a little bit
for
| Production. Most of the sites that I work on are very small and MS Access
| would work just fine. I have very limited programming knowledge, and I
only
| have experience with Access and SQL Server. One of my clients has a site
| that receives about 6,000 page views a day, and his database is about 30
| Megs on a SQL Server. I don't feel that Access would be able to handle
this
| size of database. My concern would be if I was going to run MySQL, how
much
| difference would there be with writing my queries and what not, to
| accommodate to MySQL?
|
| Does anyone have the link to Subscription page for MS Developer Network? I
| have looked through the site and can't find it.
|
| Thanks for all the feedback that I have received on this post.
|
| Jason Larson
| [EMAIL PROTECTED]



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Allarie/Macromedia ColdFusion Feature Suggestion

2001-02-21 Thread Todd Ashworth

Actually, you can 'simulate' this using hidden frames.  I've actually done
it.  It works pretty well as long as the the client browser supports all of
the features.

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]

- Original Message -
From: "JoshMEagle" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, February 21, 2001 11:38 AM
Subject: Allarie/Macromedia ColdFusion Feature Suggestion


| Proabably a bit late to place this request for 5.0 - but how about 6.0?
|
| Why don't you all make CF capable of grabbing JavaScript variables at will
throughout the page using a function like scriptvar() or jsvar() or
something like that? As many people as use ColdFusion together with
JavaScript, this seems like it would have been addressed in version 1.0 -
but now we're at 5.0 and still no mention of being able to easilly access
JavaScript variables via CF.
|
| And no, I don't mean through a form submission, or in the URL or anything
else - I mean mid page I'd like to be able to do something like:
|
| script
| colorval=thing.style.backgroundColor
| /script
|
| cfoutputYou're using color: #jsvar(colorval)#/cfoutput
|
|
| Not the best example, but you get the idea. I'm sure it presents
logistical problems since CF is processed on the server and JS on the
client, but you all are bright folks, surely you can figure this one out :)
(please?)
|
| Just my $0.02, thanks for listening!
|
| Joshua Miller
| Web Development
| Eagle Technologies Group, Inc.
| Business Solutions for the Next Generation
| www.eagletgi.com
| [EMAIL PROTECTED]
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Allarie/Macromedia ColdFusion Feature Suggestion

2001-02-21 Thread Todd Ashworth

Basically, it's an iframe that has a style sheet associated with it that
makes it invisible.  Netscape doesn't support iframe, so you are limited
in your audience, but if you are developing for a controlled environment in
which everyone uses I.E., it works pretty well.

!-- style sheet --
#ifrmSubmitForm { position: absolute; top: 400; left: 5; visibility:
hidden }

!-- IRAME --
IFRAME id="ifrmSubmitForm" name="ifrmSubmitForm" src=""/IFRAME

I've never tried it with any other type of frames, so you *might* be able to
get Netscape to support it as well, with a little experimenting.

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]

- Original Message -
From: "JoshMEagle" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, February 21, 2001 1:02 PM
Subject: Re: Allarie/Macromedia ColdFusion Feature Suggestion


| Can you explain "hidden frames" a little bit? This sounds interesting and
| although I've been writing JS and HTML for over 5 years, I've never heard
of
| this - PLEASE SHARE!
|
| Thanks!
|
| Joshua Miller
| Web Development
| Eagle Technologies Group, Inc.
| Business Solutions for the Next Generation
| www.eagletgi.com
| [EMAIL PROTECTED]
| - Original Message -
| From: "Todd Ashworth" [EMAIL PROTECTED]
| To: "CF-Talk" [EMAIL PROTECTED]
| Sent: Wednesday, February 21, 2001 6:42 AM
| Subject: Re: Allarie/Macromedia ColdFusion Feature Suggestion
|
|
|  Actually, you can 'simulate' this using hidden frames.  I've actually
done
|  it.  It works pretty well as long as the the client browser supports all
| of
|  the features.
| 
|  Todd Ashworth --
|  Web Application Developer
|  Network Administrator
| 
|  Saber Corporation
|  314 Oakland Ave.
|  Rock Hill, SC 29730
|  (803) 327-0137 [111]
| 
|  - Original Message -
|  From: "JoshMEagle" [EMAIL PROTECTED]
|  To: "CF-Talk" [EMAIL PROTECTED]
|  Sent: Wednesday, February 21, 2001 11:38 AM
|  Subject: Allarie/Macromedia ColdFusion Feature Suggestion
| 
| 
|  | Proabably a bit late to place this request for 5.0 - but how about
6.0?
|  |
|  | Why don't you all make CF capable of grabbing JavaScript variables at
| will
|  throughout the page using a function like scriptvar() or jsvar() or
|  something like that? As many people as use ColdFusion together with
|  JavaScript, this seems like it would have been addressed in version
1.0 -
|  but now we're at 5.0 and still no mention of being able to easilly
access
|  JavaScript variables via CF.
|  |
|  | And no, I don't mean through a form submission, or in the URL or
| anything
|  else - I mean mid page I'd like to be able to do something like:
|  |
|  | script
|  | colorval=thing.style.backgroundColor
|  | /script
|  |
|  | cfoutputYou're using color: #jsvar(colorval)#/cfoutput
|  |
|  |
|  | Not the best example, but you get the idea. I'm sure it presents
|  logistical problems since CF is processed on the server and JS on the
|  client, but you all are bright folks, surely you can figure this one out
| :)
|  (please?)
|  |
|  | Just my $0.02, thanks for listening!
|  |
|  | Joshua Miller
|  | Web Development
|  | Eagle Technologies Group, Inc.
|  | Business Solutions for the Next Generation
|  | www.eagletgi.com
|  | [EMAIL PROTECTED]
|  |
|  |
|  |
| 
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Anyone know of any good CF tests?

2001-02-20 Thread Todd Ashworth

ack .. I would like to recall that last e-mail.  Maybe I should have read
the entire post before responding.  I guess you could take the brainbech
test yourself and write down all of the questions and give it to him on
paper though ;)

Todd Ashworth --
Web Application Developer
Network Administrator

- Original Message -
From: "John Doe" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 12:58 PM
Subject: Anyone know of any good CF tests?


| I am looking to put together a pre-employment test to check the knowledge
| level of a job candidate who claims to be an expert cf developer. Does
| anyone know of any available tests (not online, what I'm looking for is
some
| type of written test) for this purpose? I would like to be able to bring
the
| candidate in and have them take the test under controlled circumstances -
| i.e. I don't want them to be able to do it from home, consult w/friends,
| look things up...I want to make sure I am getting what is being sold, if
you
| see what I mean.
|
| Thanks,
|
| Aaron
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Hidden frames

2001-02-20 Thread Todd Ashworth

I don't use them in my 'every day' applications, but I have used them in the
past to simulate the 'instant feedback' that non web based applications
enjoy.  In one application we had a large form that was split up over
several tabbed layers.  Whenever someone moved to a new tab, the database
was immediately, and transparently updated ... much like Access does when
you switch to the next record in the database.  It was cumbersome to
program, but it was pretty slick once we got it 1/2 way working.

I've also used them for server side form validation to simulate javascript
error checking.

Todd Ashworth --
Web Application Developer
Network Administrator

- Original Message -
From: "Earl, George" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 12:51 PM
Subject: Hidden frames


| How many of you are using hidden frames as a part of your every day CF
| development? What kinds of things are you using them for? Are there any
big
| picture considerations one needs to take with this approach? Do you have
| comments about the good and the bad of going down this path? Thanks!
|
| George
| [EMAIL PROTECTED]
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Anyone know of any good CF tests?

2001-02-20 Thread Todd Ashworth

www.brainbench.com

Todd Ashworth --
Web Application Developer
Network Administrator

- Original Message -
From: "John Doe" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 12:58 PM
Subject: Anyone know of any good CF tests?


| I am looking to put together a pre-employment test to check the knowledge
| level of a job candidate who claims to be an expert cf developer. Does
| anyone know of any available tests (not online, what I'm looking for is
some
| type of written test) for this purpose? I would like to be able to bring
the
| candidate in and have them take the test under controlled circumstances -
| i.e. I don't want them to be able to do it from home, consult w/friends,
| look things up...I want to make sure I am getting what is being sold, if
you
| see what I mean.
|
| Thanks,
|
| Aaron
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Wanted CF Web app development methodology

2001-02-15 Thread Todd Ashworth

www.fusebox.org

www.black-box.org

www.cfobjects.com

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: "Eric V. Hodge" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, February 15, 2001 10:29 AM
Subject: Wanted CF Web app development methodology


| Does anyone know where I could find or be willing to share with me a web
development methodology which highlights the use of cold fusion app
development?
|
| Thanks,
|
| Eric V. Hodge
| Web Developer
| CelTek Systems, LLC
|
| @phone: 703.927.5750
| @fax:  703.567.3085
| @homepage:   www.CelTekSystems.com
| @email:  [EMAIL PROTECTED]
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



  1   2   3   4   5   >