RE: Need help with XML to JavaScript

[Warrick, Mark]

That complex of a job, huh?  Ideally I'd just like to learn how to do it on
my own so any links to resources, how-tos, etc would be great.

My other option is to just host a subdomain for every other website that
wants to use our data.  I already know how to do that.  But what I really
would like to do is to provide a simple cut and paste piece of JavaScript
code much like how the many various news sources provide for news feed
integration into other websites and/or something similar to how websites
like Ebay provide JavaScript code (example at savetheangels.com) to less
experienced webmasters who may not fully understand how to intergrate XML
data into their own websites or who do not have the technical capabilities
to do so.

---mark


> -Original Message-
> From: John Dowdell [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 26, 2005 2:05 PM
> To: CF-Talk
> Subject: Re: Need help with XML to JavaScript
>
>
> Mark Warrick wrote:
> > I want to provide data from my database to other websites in
>  > the form of simple cut and paste JavaScript code which other
>  > webmasters can include in their plain HTML websites.
>
> Well, the way commonly used in browsers now to request remote XML data
> without a page-refresh is called "XmlHttpRequest()"... it's the "X" in
> "AJaX".
>
> But if you're providing this for the sites of others then you may need
> to check whether their audiences' browsers are pre-qualified for this
> feature. After that it might be a little tricky to tell any HTML/JS page
> designer how to integrate your code with theirs.
>
> If you'd like to provide data in XML from your server, and have that
> displayed within the HTML pages of varied sites, then it seems like it
> might be easier for most content developers to just specify a SWF than
> to integrate their JavaScript and markup with yours. If you'd prefer
> JavaScript, then do you have an idea of what types of support costs
> would be acceptable for the job...?
>
> jd
>
>
>
>
>
> --
> John Dowdell . Macromedia Developer Support . San Francisco CA USA
> Weblog: http://www.macromedia.com/go/blog_jd
> Aggregator: http://www.macromedia.com/go/weblogs
> Technotes: http://www.macromedia.com/support/
> Spam killed my private email -- public record is best, thanks.
>
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212884
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

CFMAIL Zero Byte File Problem - ColdFusion 5.0

[Warrick, Mark]

Hello All,

I'm getting desperate for a solution here.   I will give the first person 
who helps me solve this problem two tickets to the movies.

I recently moved all my code from a ColdFusion 4.5 enterprise environment 
to a ColdFusion 5.0 enterprise environment.  Nothing about the code has 
changed.

When I run any CFMAIL tags, the following problem occurs intermittently:

unknown exception condition

TagCFMail::sendMessage

Once the problem occurs once, a zero byte CFMAIL file is created in the 
CFUSION/SPOOL directory, and from then on no more message can be sent and 
this error continues forever until I shut down the server, delete all the 
zero byte files, and restart it.

I've tried all of the following suggestions which I've found through my 
many hours of google research.

1) Make sure that the CF Server has full permissions to access to all the 
CFUSION/MAIL directories and that they all exist.  - DONE
2) Install the SMTP patch and restart server. (Macromedia Article: 
http://www.macromedia.com/support/coldfusion/ts/documents/tn17552.htm) - DONE
3) Set registry entry HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\ 
CurrentVersion\Mail to a higher value - DONE - tried all the way up to 
3000.  Does not solve the problem.
4) Make sure you have installed all of the Hotfixes for ColdFusion 5.0 - DONE
5) Make sure there is enough disk space - 10 GB free - DONE
6) Make sure that you have a valid mail server in the administrator 
settings and that you have permission to access it. - DONE
7) Try specifying an SMTP server in the CFMAIL code.  - DONE  No change.

Again, I know this subject has been discussed many times before, but I've 
dug pretty deep through MANY different archives and so far I can't find a 
solution.

Please help.

---mark


---
Mark Warrick
Phone: (714) 771-5782
Email: [EMAIL PROTECTED]
Website: http://www.warrick.net
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184482
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

XML Feed for Amazon w/ColdFusion 4.5 Enterprise

[Warrick, Mark]

Has anyone succesfully tied their system into Amazon's XML feed with
ColdFusion 4.5?  I managed to get it to work with some code I found in their
developer's forums, but it's awfully slow.  (Takes about 10 seconds to load)

Here's the code:









default="asin,imageurlsmall,imageurlmedium,imageurllarge,releasedate,manufac
turer,listprice,ourprice,usedprice,collectibleprice,salesrank,decsription,me
dia,numemdia,Avgcustomerrating">


aURL="http://xml.amazon.com/onca/xml?v=1.0&t=#associatesID#&dev-t=#developer
ID#&#SearchType#=#URLEncodedFormat(term)#&mode=#mode#&type=#resultstype#&pag
e=#page#&f=xml">










")>







 

	
	
StructInsert(productinfo,"LinkURL",ListGetAt(token,2,'"'),true)>



	
StructInsert(productinfo,token,getToken(cfhttp.filecontent,nexttoken,"<>"),t
rue)>

	

	
    	
getToken(cfhttp.filecontent,nexttoken,"<>")>
   
		")>
   
   


	
    	
getToken(cfhttp.filecontent,nexttoken,"<>")>
	
		")>
	
	


	
    	
getToken(cfhttp.filecontent,nexttoken,"<>")>
	
    	
getToken(cfhttp.filecontent,nexttoken,"<>")>
	
	


	
    	
getToken(cfhttp.filecontent,nexttoken,"<>")>
	
		
getToken(cfhttp.filecontent,nexttoken,"<>")>
	
	
StructInsert(productinfo,"similarproducts",similarproducts,true)>



	
StructInsert(productinfo,token,getToken(cfhttp.filecontent,nexttoken,"<>"),t
rue)>



	
	
	
	

  ")>













Based on your search criteria, we believe you may be interested in the
following publications:




#zz#.  
target="_Amazon">#AmazonArray[zz].PRODUCTNAME# by
#AmazonArray[zz].MANUFACTURER#










===
Mark Warrick, CTO ZapConnect.com
Email: [EMAIL PROTECTED]
Phone: (714) 771-5782
===

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: motherboards and RAM

[Warrick, Mark]

Check your motherboard manual for specific RAM configurations.  In general,
I think you can safely assume that if your motherboard is over 2 years old,
it most likely won't support 1GB of RAM because 512MB chips we pretty hard
to get and were very expensive then.  Now they're going for about $150 or
less at Fry's.

If you need a new motherboard, don't go cheap.  Get the board that has the
greatest expandability options.  I recomend Intel chipsets.  IWILL boards
are awesome.  I would recommend an IWILL board with SCSI adapters built in.
You'll end up paying about $500 for the board, but you'll be able to do a
lot more and you'll be able to use it much much longer vs. a cheap board
that you'll likely have to replace in less than 2 years.

---mark

=
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
=


-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 8:56 AM
To: CF-Talk
Subject: ot: motherboards and RAM


Totally OT, so apologies. I notice that alot of people talk about having 1GB
RAM.

Well, I bought 512Mb more today, went to fit it, and then, after lots of
muckinf about, discovered that my motherboard only supportd upto 512MB RAM.

Is this normal? Is my only way around this to buy a new motherboard? This is
another world to me, but some of you clever people out there might know.

TIA

Will
~~
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: bulk updating database from txt file

[Warrick, Mark]

That's one of the brightest ideas I've heard about ColdFusion programming.
Good job, Tony.

---mark

- Original Message -
From: "Tony Schreiber" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, May 26, 2001 7:48 PM
Subject: Re: bulk updating database from txt file


> I have a cf template (well a couple) that actively (via http) solicit
> prices from websites. I had one going that did 300,000 price updates over
> several days.
>
> The best way I found to run this template was via the command line, ie:
>
> e:\cfusion\bin\cfml.exe e:\webroot\scan\pricereport.cfm
>
> No request timeouts, no hung browser windows...
>
> > I have a largish access database (30,000 records) which needs to be
updated
> > from a comma delimited text file.
> > There will be some updated records and some new records.
> > I am not sure how to begin with this
> > My worries are
> > how do I do an update loop when some records will have to be inserted
and
> > some updated.
> > Also this would presumably take a long time to do - how do I handle this
> >
> > Any suggestions welcome (assume I am a bear with very little brain) or
any
> > tutorials on this sort of thing.
> >
> > many thanks
> >
> > Seamus
> >
> >
> >
>
~~
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

need the 4.51 patch - Allaire's site is down!!!!

[Warrick, Mark]

Does anyone have the 4.51 patch (Pro Edition)?  I need it badly, and Allaire's site is 
down.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


~~
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: install problem on NT 2000

[Warrick, Mark]

Nevermind on this one people - I had corrupt install files.  Problem resolved.

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 16, 2001 11:21 AM
> To: CF-Talk
> Subject: install problem on NT 2000
> 
> 
> Hello All,
> 
> Here's the challenge of the day.  I have a CF45Pro CD in Oakland, 
> CA.  I've transferred the install files to a web server in 
> Georgia and I'm controlling that server via PC Anywhere.  I know 
> that the CF45Pro install program will work without the CD because 
> I tried it here in Oakland, and it works fine.  But when I run 
> the install prog on the machine in Georgia via PC Anywhere, the 
> program starts and the indicator hits 99% (program load) and then dies.
> 
> I've check the permissions on the server in Georgia to ensure I'm 
> running the install prog under an Administrator account - and that's fine.
> 
> So... anyone got any clues as to why the install prog would just 
> die upon start?
> 
> Please copy me directly as the matter is kind of urgent.  Thanks! 
>  And did I mention the free movie tickets (2) for anyone that 
> gives the right answer?  :)
> 
> 
> ---mark
> 
> --
> Mark Warrick
> Phone: (714) 547-5386
> Fax: (714) 972-2181
> Personal Email: [EMAIL PROTECTED]
> Personal URL: http://www.warrick.net 
> Business Email: [EMAIL PROTECTED]
> Business URL: http://www.fusioneers.com
> ICQ: 346566
> --
> 
> 
>
~~
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

install problem on NT 2000

[Warrick, Mark]

Hello All,

Here's the challenge of the day.  I have a CF45Pro CD in Oakland, CA.  I've 
transferred the install files to a web server in Georgia and I'm controlling that 
server via PC Anywhere.  I know that the CF45Pro install program will work without the 
CD because I tried it here in Oakland, and it works fine.  But when I run the install 
prog on the machine in Georgia via PC Anywhere, the program starts and the indicator 
hits 99% (program load) and then dies.

I've check the permissions on the server in Georgia to ensure I'm running the install 
prog under an Administrator account - and that's fine.

So... anyone got any clues as to why the install prog would just die upon start?

Please copy me directly as the matter is kind of urgent.  Thanks!  And did I mention 
the free movie tickets (2) for anyone that gives the right answer?  :)


---mark

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


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

slightly OT - Remote SQL installations

[Warrick, Mark]

Hello,

I have to setup a box that lives 3,000 miles away from me.  I'll be using PC Anywhere 
to control the server remotely.  I know I can install ColdFusion server from a file 
and all the various patches I'll need, but I'm not so sure about SQL 7.0.  I've always 
installed SQL straight from the CD.  Does anyone know if it's possible to copy all the 
files off the SQL 7 CD and to a remote installation?

Please copy me directly.

Thanks.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


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

[Warrick, Mark]

Yes, ColdFusion will intepret that as a number.

For example, try this:





TRUE

False





TRUE

False



True

False


Note that generally when something is surrounded by quotes, it's a text object, but in 
this case since the value is a number, it will be evaluated as a number.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 14, 2001 12:20 PM
> To: CF-Talk
> Subject: CF number question
> 
> 
> I have a form variable whose value is "0.00"
> 
> if I do a conditional, would this be right?
> 
> 
> TRUE
> 
> False
> 
> 
> what i am saying is, will "0.00" be the same as 0?  will it read it as a
> string or a number?  or sometimes?  explain!
> 
> 
> thanx
> 
>
~~
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

Sort of OT: ColdFusion Studio - any temp files?

[Warrick, Mark]

Hello,

After working about 4 hours on a rather extensive error-checking template and saving 
religiously every time I made a change, my system suddenly lost power.  Upon 
restarting, the file I had been working on was blank.  And although its size was "6k" 
there was no data in the file.

I've since then started rebuilding the template, but I'd like to know if anyone knows 
of any files that ColdFusion Studio creates while it's working kind of like how MS 
Word does the autosave thing.  I know that at least with MS Word there's temp files 
laying around that you can access and not lose all your work.

It's actually pretty scary to think that CF Studio would waste the file like that.  If 
I had all the templates I was working on today open at that time, I'll bet they would 
all be wasted!

Any clues?

Please copy me directly.

Thanks.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


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

test - please ignore

[Warrick, Mark]

I haven't received a message in over 12 hours.  Just testing the system.

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


~~
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: Action on image

[Warrick, Mark]

I'd love to help, but could you be a tad more specific?

---mark

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Albert K Arhin [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 18, 2001 12:36 AM
> To: CF-Talk
> Subject: Action on image
> 
> 
> 
> Hi All,
>How do i add a cfm action on an image.
> 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: Remoting and Location of CFML Files

[Warrick, Mark]

You should place the CFM files on the same server that the COldFusion server is on.  
Sure it's possible to use a webserver A to map a network drive to webserver B running 
ColdFusion scripts, but that's subject to internal network failures and is ill 
advised.  Heck, you could even create an ODBC connection to an Access database stored 
on a remote server, but you'll have the same networking issues.

The Internet and networking in general are subject to frequent fluctuations and 
interruptions in service.  If you want a web site that's going to stay up, put all the 
HTML and CF coding on the same server.

Hopefully that helps.


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Teng-Yan Loke [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 18, 2001 2:45 AM
> To: CF-Talk
> Subject: Remoting and Location of CFML Files
> 
> 
> Suppose I have set up a web server (dog) with the CF plug-in for remote CF
> processing, and a CF server (cat) with the network listener 
> module running.
> LOCALPATH and REMOTEPATH are both set to "c:\inetpub\wwwroot".
> 
> Which machine should I place my CFM files? As of now, it seems like they
> have to reside on cat, but my HTML and image files can be on the 
> web server.
> If this is true, wouldn't it seem confusing when it comes to specifying
> paths?
> 
> 
> Loke, Teng-Yan | [EMAIL PROTECTED] | +65-2169725
> E-commerce | novaSPRINT.com (S) Pte Ltd
> 
> 
>
~~
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: Apache web server

[Warrick, Mark]

If you're talking about a browser-requested password, then your problem lies with your 
Apache web server.  Consult your Apache documentation on how to secure (or not secure 
in this case) your web server.

If you're seeing the CF Administrator login page and you've forgotten your password, 
you can reset it by either reinstalling ColdFusion, or by changing the registry value 
of the "UseAdminPassword" key.  In doing so, you'll be able to access the CF 
Administrator pages without logging in.

Open up regedit
Browse to HKEY_LOCAL_MACHINE - SOFTWARE - Allaire - ColdFusion - CurrentVersion - 
Server

In the right column, you will see the UseAdminPassword key and you'll notice that it's 
value is set to "1".

Double click on the UseAdminPassword key to edit its value.

Change the value to 0 and click OK.

Now, reload the CF Administrator login page in your web browser.  You'll automatically 
be taken to the CF Administrator main menu.  Be sure to reset the security settings in 
the CF Administrator.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Trace Faber [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, January 13, 2001 2:22 PM
> To: CF-Talk
> Subject: Apache web server
> 
> 
> Hi Guys,
> 
> I use an Apache web server and am able to view my cf pages 
> (localhost/etc.)
> but I am having trouble getting the cf administrator to recognize 
> the Apache
> web server (from localhost/CFIDE/administrator/index.cfm). The log in page
> comes up but it keeps telling me that I'm using an invalid password when I
> am using the correct one. I re-installed cf to make sure I had 
> the password
> correct. I am not sure what to do. Does anybody have an idea?
> 
> Thanks,
> 
> Trace
> 
> 
>
~~
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: Putting a temporary hold on a quantity

[Warrick, Mark]

I think your problem is more of a policy issue than a programming issue.  What you're 
trying to do is create logic to account for exceptions.  I think the problem would be 
better solved through management decisions than programatic decisions.

Consider this:

When a customer places an order, it is based upon inventory levels you believe to be 
accurate to the best of your knowledge.  Even if the computer says one thing and the 
inventory clerks say the same thing, that doesn't mean that the product is actually 
sitting on the shelf nor does it mean that the product is in deliverable condition.  
With that in mind, you should only update the actual inventory levels once the product 
has been shipped.

If you want to keep track of the order quantities vs. the actual quantity on hand - go 
ahead!  Once the order quantities exceed the last known inventory level, advise the 
customer that the product MIGHT have to be on backorder and explain your policy on 
backorders.

Programatic functions of flushing out bad orders should solve the problem of resetting 
the order quantities on their own, and so the next customer ordering the same product 
would not receive the backorder notice if there is sufficient quantity on hand.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: t nelson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 4:29 PM
> To: CF-Talk
> Subject: Putting a temporary hold on a quantity
> 
> 
> Hi All,
> 
> I have a small dilemma on my hands. I am trying to figure out a 
> way to place 
> a temporary hold on a quantity in my database.
> 
> Here's the scenario:
> 
> I am in the process of finishing up an e-commerce site. like every other 
> commerce site, users can go through items and place them into a shopping 
> cart of sorts until they are ready to check out.
> 
> here's the problem:
> 
> let's say that a customer decides to bail out on the transaction 
> at the last 
> minute.(of course i'll have a button which will allow them to 
> cancel their 
> order) but let's say the persons pc crashes on them before they 
> can finish 
> their order or their phone service gets shut off or the world comes to an 
> end (you get the picture). barring the last scenario, i would hate for 
> another user to lose out on that product simply because it's out of the 
> system in a manner of speaking.
> 
> my question is basically this: is there a way for me to 
> temporarily set the 
> a fore mentioned quantity aside and then after a set time has 
> expired have 
> it reintroduced into my quantity field?
> 
> thanks in advance,
> 
> nelson
>
~~
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: Oracle doesn't store large data.... HELP !?!?!

[Warrick, Mark]

I may be revealing my ignorance of Oracle here, but doesn't the BLOB (as opposed to 
CLOB) field type solve this problem?

---mark


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Mike Amburn [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 9:53 AM
> To: CF-Talk
> Subject: Oracle doesn't store large data HELP !?!?!
> 
> 
> we recently migrated our application from SQL7 to Oracle. personally,
> i'd go back to SQL7 in a heart-beat, but that's not my decision. the
> biggest problem we have is regarding size of data. we have a simple
> table that stores variables as name/value pairs name=Homer,
> city=Atlanta, etc. easy enough. however, some have large values. for
> example, one variable is a comma-delimited list that can reach 1400
> characters. that's a big list. however, SQL7 had no problem at all
> storing and retrieving. Oracle seems to be different. for whatever
> reason, we can update/insert the large value, but we can not select the
> large value. it gives some weird Oracle error about having too small a
> buffer. we have tried to set it as varchar2(4000), long, and CLOB, with
> not success. trying CLOB had a whole set of other errors.
>  
> then there's the issue that some variables are stored as serialized WDDX
> structures, which can be really big. Oracle didn't even try to accept
> that.
>  
> does anyone have a clue what's going on or how to get oracle to play
> fair with large values?
> me + oracle = Sum(desperate + frustrated)
>  
> -Mike
> 
>
~~
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: Varaible Names with "-"

[Warrick, Mark]

This probably isn't the answer you're looking for, but you should rename the column.  
That's just plain bad database design to begin with.  And there's no need to add on 
another layer of unnecessary programming when all you've gotta do is rename the field.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Troy Hiltbrand [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 10:00 AM
> To: CF-Talk
> Subject: Varaible Names with "-"
> 
> 
> Is there any way to pull out the information about a query column 
> that has a
> “-“ in it?  The problem is that with SQL Server 2000, when you do a “for
>  xml” select statement, the column name that is returned has “-“s in it.
> From the documentation in SQL Server 2000, I am not seeing a name 
> to rename
> that.  I am trying to pull out the xml from this query, but in order to do
> this, I need to get at the data with a column name that has a “-“ 
> in it.  If
> anyone has any suggestions, please let me know.  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: rewrite filesize?

[Warrick, Mark]

There's an example of how to do this (minus the DB update) in the CFDIRECTORY docs 
which were included with your copy of ColdFusion server.

http://127.0.0.1/cfdocs/CFML_Language_Reference/2_ColdFusion_Tags/lr2_024..htm

---mark

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Emmet McGovern [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 10:25 AM
> To: CF-Talk
> Subject: rewrite filesize?
> 
> 
> Can anyone show me snippet of code to read a filesize and write it to a
> database? I have a file manager i wrote using cffile but some of 
> the uploads
> are just tooo big.  We upload a fake 4k file now then write the 
> larger file
> overtop of it.  I need to be able to reread the size of the file 
> and update
> the db with the new filesize.
> 
> 
> Thanks,
> 
> 
> Emmet McGovern
> Systems Administrator
> Byte Size Inc
> http://www.oceancity.md
> 
>
~~
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: HotMail in CF

[Warrick, Mark]

Jim,

No, there's no reason that CF shouldn't be used to create something like Hotmail.  In 
fact, if you need a spec to go by, I wrote one on exactly that topic.  Feel free to 
contact me directly for pricing.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Jim Mixon [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 10:29 AM
> To: CF-Talk
> Subject: HotMail in CF
> 
> 
> 
> Feedback please . . .!
> 
> BEFORE I start on this project for this Client,
> any of you wizards know of any reason why a HotMail.com
> cannot be done entirely in CF?
> 
> thanks . . .
> 
> Jim Mixon - CEO
> APT POINT NET, Inc. "A Premiere InterNET Gateway" . . .
> [EMAIL PROTECTED]   http://www.apt.net/
> PO Box 160217 Hialeah, FL 33016 305-418-4111
> FAX (305) 418-4111 press 7 and SEND!
> powered by Cold Fusion 4.01 . . . . feel the force!
> CF Hosting Now Available . . . . ! 
> 
>
~~
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 and FrontPage

[Warrick, Mark]

DON'T DO IT!  Keep FrontPage and ColdFusion development environements COMPLETELY 
separate.  FrontPage will jack up your code.

If you have to use something WYSIWYG, use DreamWeaver.  (a Macromedia product - go 
figure) which doesn't harm CF code at all.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Cornillon, Matthieu [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 10:46 AM
> To: CF-Talk
> Subject: CF and FrontPage
> 
> 
> Hi.  I have a development machine with ColdFusion Studio/Server (single
> license) on it.  For a couple of reasons, I'd like to install FrontPage on
> the same machine to do some simple visual HTML editing that can 
> be a drag in
> CFStudio.  Someone suggested to me that FrontPage might foul things up
> because of Personal Web Server or something else.
> 
> Does anyone have any thoughts/horror stories to share about this?
> 
> Thanks in advance,
> Matthieu
> 
>
~~
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: duplicating inserts

[Warrick, Mark]

There are many ways to prevent duplicate submissions.  One way would be to use 
javascript to reset the history so that the back button would be (sort of) disabled.  
Read about that here: http://developer.irt.org/script/311.htm

Another way is to assign a unique ID ("createUUID()")to the user, carry that value 
through forms and URLs, and then record the unique ID upon submitting the contents of 
the form and the time it happened.  Create some arbitrary number like "user cannot do 
the same function twice within x seconds" and then do a date compare prior to 
inserting the record to figure out if a record has been entered within x seconds by 
the current user.

If you wanted, you could check all fields in the table against the form data and the 
unique id to detect duplicates.

You can also use the pragma-nocache function to expire the form so that even if the 
user backs up, all the contents of the form will be lost, but this doesn't work on all 
browsers.

The multiple CFLOCATION trick might also work well.  Use several of them so that if 
the user tries to back up, they'll have to back up several times.  Logic would tell 
most people that if they have to back up that many times, they probably shouldn't be 
doing it.

Ultimately, a user will find ways to get around all this, but I think you're simply 
trying to avoid mistakes, and a combination of all of the above will most likely 
reduce that error ratio down considerably.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 7:25 AM
> To: CF-Talk
> Subject: duplicating inserts
> 
> 
> Anyone know of a way to stop records from being reinserted into a
> database when a user hits the back button?  I have a page that checks
> for duplications in a database, and if it finds no duplicate, then it
> will insert it into the database.  Problem is, when a user hits the back
> button, it inserts the record again.  Its not finding duplicates more
> than likey because the query is being cached so it doesnt know to look
> again.  But how can I get it to either do nothing including not
> inserting the record a second time or atleast recheck again to see if
> its a duplicate record?  I can't take caching off this machine as these
> are some monster queries and performance is greatly improved by caching
> queries.
> 
> Thanks
> 
>***
>Misty Woodward
>ODS Decision Support
>tel: 913.315.6583
>   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

RE: calling a cfm script into a html page

[Warrick, Mark]

If you're running IIS, you can map all HTML files to be processed by the ColdFusion 
server.

Open up the MMC (Microsoft Management Console).
Right click on the default web site.
Click the Home Directory tab.
Then click the Configuration button.
Notice how .cfm files and .dbm files are mapped to the \cfusion\bin\iscf.dll program.
Duplicate that mapping for .htm and .html files as applicable.

The downside to doing this is that all the .htm and .html pages would now be processed 
through the ColdFusion application server, creating a slight bit of extra overhead for 
the server.  The upside is that you can leave your templates named the way they are 
and include cf templates at will.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Olivier Moulene [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 8:56 AM
> To: CF-Talk
> Subject: calling a cfm script into a html page
> 
> 
> I had to set a tracking Solution.
> Does anybody know how to call a cfm script with url parameters into a html
> page ?
> I've tried with the 

RE: Window 95 Log?

[Warrick, Mark]

There is nothing contained within the Windows 95 operating system that will log 
logins.  There is also nothing within the OS to protect files.

There are, however, various programs which you could install that can run as 
background processes that monitor the user's activities, but even those could be 
easily disabled by the user.

The only way to truly protect your machine is to use an operating system such as 
Windows NT that has built in security.  But still for logging, I believe you're going 
to need a 3rd party logging application.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 7:26 AM
> To: CF-Talk
> Subject: OT: Window 95 Log?
> 
> 
> What Log file will tell me if someone has logged into a windows 
> 95 computer?
> 
> What other then a cmos password can protect a windows?
> 
>
~~
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: Sessions

[Warrick, Mark]

Sounds like you've got other code which is appending the URLs or the string you are 
creating.  Strip down your application.cfm file to only include the code you are 
testing and see what happens.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Michael Ross [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 9:07 AM
> To: CF-Talk
> Subject: Sessions
> 
> 
> I have an app that sets a session id.  The first time you call 
> any page(which uses application.cfm)it sets a number and works 
> great.  If i refresh the page I get a var that looks like this 
> tcom_686_### where tcom is the application name, 686 is a 
> number that is being incremented everytime I call a new session. 
> and  changes randomly.  Anyone ever seen this???
> 
> 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: Date problem

[Warrick, Mark]

I think the proper approach to this problem would be to provide an example of the 
proper date format next to the input field, perhaps even pre-popluating the field with 
today's date in the proper format.

Then on the page it submits to, use the IsDate() function to determine whether the 
date is correctly formatted.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Neil Robinson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 7:26 AM
> To: CF-Talk
> Subject: Date problem
> 
> 
> 
> Apologies if this has already been covered.  I'm having a general problem
> with date formats, specifically if a form field is submitted with 
> a 2-digit
> year then the subsequent template receives it with the day and year digits
> switched round.
> 
> ie 17/01/01 would become 01/01/2017
> 
> This doesn't happen if the form field contains a 4-digit year ie 
> 17/01/2001,
> but as I'm using cfinput validation it doesn't actually force the user to
> use 4 digits.  At present I don't know whether this is a localised setting
> issue or if it's cold fusion or what.  Anyone else come across this?
> 
> TIA
> 
> Neil Robinson
> 
>
~~
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: Conditional loops

[Warrick, Mark]

Yes, you can do conditional loops.

Check the docs 
http://127.0.0.1/cfdocs/CFML_Language_Reference/2_ColdFusion_Tags/lr2_054..htm

Example from docs:

  The following example increments the parameter "CountVar" from 1 to 5. The results 
look exactly like the Index loop example. 

 
 
 
 
 

 
The loop index is #CountVar#. 



The result of this loop in a browser would look something like: 

The loop index is 1. 
The loop index is 2. 
The loop index is 3. 
The loop index is 4. 
The loop index is 5. 

 


---mark

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Ruslan Sivak [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 2:10 PM
> To: CF-Talk
> Subject: Conditional loops
> 
> 
> Is there a way to have conditional loops such as 
> 
> 
>   
> 
>   
> 
> 
>   
> 
> Ruslan Sivak
> Technologist
>
~~
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: random record

[Warrick, Mark]

There are many ways to do this.  Here's one:






SELECT max (CONTACT_ID) as maxid
FROM CONTACTS









SELECT MIN (CONTACT_ID) as random_record
FROM contacts
where CONTACT_ID >= #randnum#



#random_record#




---mark

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Jeremy Bunton [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 1:32 PM
> To: CF-Talk
> Subject: random record
> 
> 
> Can anyone point me in the right direction regarding how I would go about
> pulling a random record from a table every time a user visits the page.
> 
> JLB
> 
> 
> 
>
~~
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: wow...

[Warrick, Mark]

THANK GOD!  This is the best thing to ever happen to Allaire.

(wishing I had bought stock in Allaire)

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 2:05 PM
> To: CF-Talk
> Subject: wow...
> 
> 
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> Everyone seen this? :)
> 
> Macromedia and Allaire to Merge
> 
> 
> http://quote.bloomberg.com/fgcgi.cgi?s=AOmTDYwsyTWFjcm9t&T=marketsquot
> e99_news.ht
> 
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 6.5.8 for non-commercial use 
> 
> iQA/AwUBOmTFpTp1Dv+56bwcEQInywCfVDE6WMqfPiNOTBKz1KSJVgK/KX8An2HS
> fOHTozSvLZoQ6Rif8sPzhuOA
> =XPsZ
> -END PGP SIGNATURE-
> 
> 
>
~~
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: Unable to Verify ODBC

[Warrick, Mark]

Sure.

Open up the Services applet in the Control Panel. Click on the ColdFusion Application 
Server, then Startup.

Look at the "Log On As" options.  The simplest way to solve this problem is to make 
sure that you're using the System Account.

Do the same for the other ColdFusion services: Executive &  RDS.

Now I'm assuming that the DSN you're trying to hook up is for an Access database.  
Find that MDB file on the server and check it's permissions by right-clicking on it, 
choosing properties, then security, then permissions.

If you used the SYSTEM account for the services, then it won't matter what permissions 
are applied here, but if you used any other account, make sure that same account has 
full control of the MDB file.

Hopefully this helps.  Basically, to sum it all up, don't screw with the account 
settings unless you understand Windows NT security!


---mark


--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Peter J. MacDonald [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 10:33 AM
> To: CF-Talk
> Subject: RE: Unable to Verify ODBC
> 
> 
> Mark,
> 
> Could you be a little more specific about the security issues.  I login as
> Administrator and have check all of the directories and files and
> administrator can open them no problem through that.  The 3 different CF
> services where running as default system login and now as administrator.  
> 
> 
> Thank You,
> Peter
> 
> Peter J. MacDonald II
> Creative Computing, Inc.
> 100 Middle Street
> Lincoln, RI 02865
> Phone: 401.727.0183 x208
> Fax: 401.727.4998
> Portable: 401.965.3661
> E-MAIL: [EMAIL PROTECTED]
> Web Page: www.creatcomp.com
> 
> 
> 
> -Original Message-
> From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 11:49
> To: CF-Talk
> Subject: RE: Unable to Verify ODBC
> 
> 
> If you're able to run ODBC connectivity tests through the control 
> panel with
> no problems, but not with the CF Administrator, then you probably have a
> permissions/security conflict.  Make sure that the ColdFusion server is
> running as a SYSTEM account or some other account that has permission to
> access those datasources.
> 
> ---mark
> 
> --
> Mark Warrick
> Phone: (714) 547-5386
> Fax: (714) 972-2181
> Personal Email: [EMAIL PROTECTED]
> Personal URL: http://www.warrick.net 
> Business Email: [EMAIL PROTECTED]
> Business URL: http://www.fusioneers.com
> ICQ: 346566
> --
> 
> 
> > -Original Message-
> > From: Peter J. MacDonald [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 16, 2001 7:55 AM
> > To: CF-Talk
> > Subject: Unable to Verify ODBC
> > 
> > 
> > Help Please,
> > 
> > I have installed CFServer 4.5.1 on an NT Workstation 4.0 Build 5.  I am
> > trying to get it setup and run the Demo Applications.  I have 
> > installed the
> > current MDAC from MS.  I have checked ODBC connectivity through other
> > software and it is fine.  I can also change ODBC information 
> > through the CF
> > Admin interface.  When I run the Administrator test query I get a S1000
> > General ODBC error  Disk or network error.  Any Ideas appreciated.
> > 
> > 
> > Thank You,
> > Peter
> > 
> > Peter J. MacDonald II
> > Creative Computing, Inc.
> > 100 Middle Street
> > Lincoln, RI 02865
> > Phone: 401.727.0183 x208
> > Fax: 401.727.4998
> > Portable: 401.965.3661
> > E-MAIL: [EMAIL PROTECTED]
> > Web Page: www.creatcomp.com
> > 
> > 
> > 
> >
>
~~
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: Allaire Partners (was ColdFusion Newsgroup)

[Warrick, Mark]

I'm posting a response over in the CF-Community list.

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: David E. Crawford [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 10:13 AM
> To: CF-Talk
> Subject: Re: Allaire Partners (was ColdFusion Newsgroup)
> 
> 
> This is not true.  You can become a consulting partner for $500 
> or so.  That
> gets you Not For Resale versions of everything from CF to JRUN for all
> platforms.  That is a very low entry point IMHO.
> 
> DC
> 
> - Original Message -
> From: "Warrick, Mark" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 16, 2001 11:43
> Subject: RE: ColdFusion Newsgroup
> 
> 
> > Allaire caters to big businesses.  That is evident by the high sticker
> price of being a partner with them.  They don't offer any sort of
> partnerships with individual developers (last time I checked).
> >
> > --
> > Mark Warrick
> > Phone: (714) 547-5386
> > Fax: (714) 972-2181
> > Personal Email: [EMAIL PROTECTED]
> > Personal URL: http://www.warrick.net
> > Business Email: [EMAIL PROTECTED]
> > Business URL: http://www.fusioneers.com
> > ICQ: 346566
> > --
> >
> >
> > > -Original Message-
> > > From: Michael [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, January 15, 2001 9:40 PM
> > > To: CF-Talk
> > > Subject: Re: ColdFusion Newsgroup
> > >
> > >
> > > Nice point, but 
> > >
> > >
> > > "Warrick, Mark" <[EMAIL PROTECTED]> wrote in message
> > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > > I think the fact that Allaire doesn't do this is a perfect
> > > example of how
> > > they treat individual developers.
> > > >
> > > > And that's WHY this list exists, and it's why my business
> > > exists as well!
> > > >
> > > > ---mark
> > > >
> > > > --
> > > > Mark Warrick
> > > > Phone: (714) 547-5386
> > > > Fax: (714) 972-2181
> > > > Personal Email: [EMAIL PROTECTED]
> > > > Personal URL: http://www.warrick.net
> > > > Business Email: [EMAIL PROTECTED]
> > > > Business URL: http://www.fusioneers.com
> > > > ICQ: 346566
> > > > --
> > > >
> > > >
> > > > > -Original Message-
> > > > > From: Michael [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Monday, January 15, 2001 5:36 PM
> > > > > To: CF-Talk
> > > > > Subject: ColdFusion Newsgroup
> > > > >
> > > > >
> > > > > I am NOT knock what we (coldfusion developers) have with this
> > > > > list, and
> > > > > group BUT what and why doesn't someone or Allaire start
> > > something in the
> > > > > regular newsgroups?  This is somewhat baffling at times,
> > > the have a
> > > > > dynamite product line, the forums on Allaire are OK kinda
> > > slow, but Ok.
> > > > > I mean why not.
> > > > >
> > > > > Thanks
> > > > >
> > > > > Michael
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>
~~
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: Unable to Verify ODBC

[Warrick, Mark]

If you're able to run ODBC connectivity tests through the control panel with no 
problems, but not with the CF Administrator, then you probably have a 
permissions/security conflict.  Make sure that the ColdFusion server is running as a 
SYSTEM account or some other account that has permission to access those datasources.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Peter J. MacDonald [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 7:55 AM
> To: CF-Talk
> Subject: Unable to Verify ODBC
> 
> 
> Help Please,
> 
> I have installed CFServer 4.5.1 on an NT Workstation 4.0 Build 5.  I am
> trying to get it setup and run the Demo Applications.  I have 
> installed the
> current MDAC from MS.  I have checked ODBC connectivity through other
> software and it is fine.  I can also change ODBC information 
> through the CF
> Admin interface.  When I run the Administrator test query I get a S1000
> General ODBC error  Disk or network error.  Any Ideas appreciated.
> 
> 
> Thank You,
> Peter
> 
> Peter J. MacDonald II
> Creative Computing, Inc.
> 100 Middle Street
> Lincoln, RI 02865
> Phone: 401.727.0183 x208
> Fax: 401.727.4998
> Portable: 401.965.3661
> E-MAIL: [EMAIL PROTECTED]
> Web Page: www.creatcomp.com
> 
> 
> 
>
~~
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: Connecting to an Oracle DB

[Warrick, Mark]

I believe you need to be running the Enterprise version of ColdFusion or have 3rd 
party drivers.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Neil Clark [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 1:13 AM
> To: CF-Talk
> Subject: Connecting to an Oracle DB
> 
> 
> Anyone help me connect to an Oracle DB?  I am having trouble 
> connecting to a
> Siebel DB via an Oracle ODBC driver.  The database is on 8.1.6 EE.
> 
> I can get an ODBC system/file DSN setup up but cannot verify the 
> datasource.
> 
> I have always dealt with NT. ;-/
> 
> Neil
> 
>  Neil Clark
> Senior Web Applications Engineer
> ColdFusion / Spectra / XML
> mcb digital [Allaire Premier Partner]
> Tel. +44 (0)20 8941 3232
> Tel. +44 (0)20 8408 8131 [Direct]
> http://www.mcbdigital.com
> --->
> 
> 
> 
>
~~
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 Newsgroup

[Warrick, Mark]

Allaire caters to big businesses.  That is evident by the high sticker price of being 
a partner with them.  They don't offer any sort of partnerships with individual 
developers (last time I checked).

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Michael [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 15, 2001 9:40 PM
> To: CF-Talk
> Subject: Re: ColdFusion Newsgroup
> 
> 
> Nice point, but ????????
> 
> 
> "Warrick, Mark" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I think the fact that Allaire doesn't do this is a perfect 
> example of how
> they treat individual developers.
> >
> > And that's WHY this list exists, and it's why my business 
> exists as well!
> >
> > ---mark
> >
> > --
> > Mark Warrick
> > Phone: (714) 547-5386
> > Fax: (714) 972-2181
> > Personal Email: [EMAIL PROTECTED]
> > Personal URL: http://www.warrick.net
> > Business Email: [EMAIL PROTECTED]
> > Business URL: http://www.fusioneers.com
> > ICQ: 346566
> > --
> >
> >
> > > -Original Message-
> > > From: Michael [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, January 15, 2001 5:36 PM
> > > To: CF-Talk
> > > Subject: ColdFusion Newsgroup
> > >
> > >
> > > I am NOT knock what we (coldfusion developers) have with this
> > > list, and
> > > group BUT what and why doesn't someone or Allaire start 
> something in the
> > > regular newsgroups?  This is somewhat baffling at times, 
> the have a
> > > dynamite product line, the forums on Allaire are OK kinda 
> slow, but Ok.
> > > I mean why not.
> > >
> > > Thanks
> > >
> > > Michael
> > >
> > >
> > >
> > >
> >
>
~~
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 Newsgroup

[Warrick, Mark]

I think the fact that Allaire doesn't do this is a perfect example of how they treat 
individual developers.

And that's WHY this list exists, and it's why my business exists as well!

---mark

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Michael [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 15, 2001 5:36 PM
> To: CF-Talk
> Subject: ColdFusion Newsgroup
> 
> 
> I am NOT knock what we (coldfusion developers) have with this 
> list, and
> group BUT what and why doesn't someone or Allaire start something in the
> regular newsgroups?  This is somewhat baffling at times, the have a
> dynamite product line, the forums on Allaire are OK kinda slow, but Ok.
> I mean why not.
> 
> Thanks
> 
> Michael
> 
> 
> 
>
~~
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: Cannot define a frameset in .CFM file?

[Warrick, Mark]

You cannot use body tags in frameset pages.  That's why it's blank.

--
Mark Warrick
Phone: (714) 547-5386
Fax: (714) 972-2181
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 15, 2001 12:38 PM
> To: CF-Talk
> Subject: Cannot define a frameset in .CFM file?
> 
> 
> Hi,
> 
> I'm trying to define some frames in a .cfm file and can't seem to get the
> frames to appear and end up with a blank page.  
> It works fine if I simply rename the .cfm file to .htm file.  
> What do I need
> to do?
> 
> The simple page I'm testing with looks like this:
> 
> 
> 
> 
> 
>   Untitled
> 
> 
> 
>  src="../../../Inetpub/wwwroot/dashboard_wip/mainheader.htm" 
> marginwidth="10"
> marginheight="10" scrolling="auto" frameborder="1">
>  src="../../../Inetpub/wwwroot/dashboard_wip/frame3/shellmid.htm"
> marginwidth="10" marginheight="10" scrolling="auto" frameborder="1">
> 
> 
> 
> 
> 
> 
> 
> 
> 
> What's strange is that when I do view the source of the blank page I get:
> 
> 
> 
> 
> 
> 
> 
> 
> Project Tracking Application Global file
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>   Untitled
> 
> 
> 
>  src="../../../Inetpub/wwwroot/dashboard_wip/mainheader.htm" 
> marginwidth="10"
> marginheight="10" scrolling="auto" frameborder="1">
>  src="../../../Inetpub/wwwroot/dashboard_wip/frame3/shellmid.htm"
> marginwidth="10" marginheight="10" scrolling="auto" frameborder="1">
> 
> 
> 
> 
> 
> 
> 
> 
> 
>
~~
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

Slightly OT: Allaire Developer Certification

[Warrick, Mark]

To all Allaire Certified Developers:

If you came to me and told me you were Allaire certified, how would I verify that you 
really are?  I cannot find anything on Allaire's site related to certification.

If there's something on Allaire's site for me to read, please give me a link.  Thanks!

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


~~
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 4.0.1 and Oracle 8i

[Warrick, Mark]

I don't think you can use the Professional edition of 4.01 with Oracle unless you have 
some special drivers that don't come with either CF or Oracle.  (I've tried to do the 
same thing before with no luck.)  The solution to the problem was to upgrade to the 
Enterprise edition.

Try running ANY query on the Oracle DB.  I'm pretty sure nothing is going to work.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 29, 2000 10:21 AM
> To: CF-Talk
> Subject: CF 4.0.1 and Oracle 8i
> 
> 
> I am trying to get return codes (as output parameters, per docs) 
> from Oracle 8i using CFSTOREDPROC in CF 4.0.1 (Professional 
> edition). I keep getting the same error code back, no matter what 
> test data I send Oracle.
> 
> The strange thing is that when I run the same test scenarios in 
> SQL Plus, I get the proper return codes. Is this something with 
> Professional/Enterprise edition do you think? Or is it more a 
> version problem (4.0.x versus 4.5.x)?
> 
> David L. Rice
> Web Applications Developer
> IT-Inc.
> Cell: 205.903.9467
> [EMAIL PROTECTED]
> 
> 
> 
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: This is weird

[Warrick, Mark]

Can we see the code?

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 28, 2000 4:50 PM
> To: CF-Talk
> Subject: This is weird
> 
> 
> 
> I am getting an ODBC error message. Below the message is saying that
> 'retreat' is a column name but it is not. It is the VALUE for the column
> name CommunityEventName.
> 
> Any suggestions. I can't figure this out.
> 
> Sebastian
> 
> --
> 
> ODBC Error Code = 37000 (Syntax error or access violation)
> 
> [Microsoft][ODBC SQL Server Driver][SQL Server]The name 'retreat' is not
> permitted in this context. Only constants, expressions, or 
> variables allowed
> here. Column names are not permitted.
> 
> 
> SQL = "INSERT INTO CommunityEvents (CommunityEventID, CommunityEventName,
> LastUpdate) VALUES(HPRO-12-28-2000, retreat, {ts '2000-12-28 18:42:56'})"
> 
> 
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: CFMAIL

[Warrick, Mark]

No, what he was saying is that if you want to mail text, just include it in the body 
of the CFMAIL message.

If you need to include a text file, use CFINCLUDE within the body of the CFMAIL.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 28, 2000 4:20 PM
> To: CF-Talk
> Subject: Re: CFMAIL
> 
> 
> So this will not mail the attachment, but input the file contents in the
> body of the message.  Is this correct?
> 
> Thanks,
> Robert
> 
> - Original Message -
> From: "Howie Hamlin" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, December 28, 2000 7:01 PM
> Subject: Re: CFMAIL
> 
> 
> > This is not a matter of the client not knowing how to use email.  There
> are
> > lots of email users out there that use text based email clients.  If you
> > mimeattach a file to a mail it will show up as mime encoded on 
> a text-only
> > mail client.
> >
> > A better way to do this is as follows:
> >
> > 
> >  > FILE="#uploadpath#\#serverfile#"
> > VARIABLE="emailfile">
> >
> > 
> >  > TO="#email_address_used#"
> > CC="#form.email_cc#"
> > FROM="#form.email_from#"
> > SUBJECT="#message_subject#"
> > > > > MIMEATTACH="#uploadpath#\#serverfile#"
> > #message_body#
> > #emailfile#
> > 
> >
> > HTH,
> >
> > Howie Hamlin - inFusion Project Manager
> > On-Line Data Solutions, Inc.
> > www.CoolFusion.com
> > 631-737-4668 x101
> > inFusion Mail Server (iMS) - the World's most configurable mail server
> > Get yout free copy of iMS POST-SE Server from CoolFusion!
> >
> > - Original Message -
> > From: "Warrick, Mark" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, December 28, 2000 6:11 PM
> > Subject: RE: CFMAIL
> >
> >
> > > It sounds like your end user doesn't understand how to use email.  I
> would
> > first start with educating them on how to use their email 
> client properly.
> > There's nothing wrong with this method of sending email.  If you want to
> > send text only, put it in the body of the message.
> > >
> > > ---mark
> > >
> > >
> > > --
> > > Mark Warrick
> > > Phone: (714) 547-5386
> > > Efax.com Fax: (801) 730-7289
> > > Personal Email: [EMAIL PROTECTED]
> > > Personal URL: http://www.warrick.net
> > > Business Email: [EMAIL PROTECTED]
> > > Business URL: http://www.fusioneers.com
> > > ICQ: 346566
> > > --
> >
> >
> >
> >
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: CFMAIL

[Warrick, Mark]

You're right Howie.  The text should be included in the body of the message.  Sorry, I 
thought that was obvious.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 28, 2000 4:01 PM
> To: CF-Talk
> Subject: Re: CFMAIL
> 
> 
> This is not a matter of the client not knowing how to use email.  
> There are
> lots of email users out there that use text based email clients.  If you
> mimeattach a file to a mail it will show up as mime encoded on a text-only
> mail client.
> 
> A better way to do this is as follows:
> 
> 
>  FILE="#uploadpath#\#serverfile#"
> VARIABLE="emailfile">
> 
> 
>  TO="#email_address_used#"
> CC="#form.email_cc#"
> FROM="#form.email_from#"
> SUBJECT="#message_subject#"
> > > > MIMEATTACH="#uploadpath#\#serverfile#"
> #message_body#
> #emailfile#
> 
> 
> HTH,
> 
> Howie Hamlin - inFusion Project Manager
> On-Line Data Solutions, Inc.
> www.CoolFusion.com
> 631-737-4668 x101
> inFusion Mail Server (iMS) - the World's most configurable mail server
> Get yout free copy of iMS POST-SE Server from CoolFusion!
> 
> - Original Message -
> From: "Warrick, Mark" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, December 28, 2000 6:11 PM
> Subject: RE: CFMAIL
> 
> 
> > It sounds like your end user doesn't understand how to use 
> email.  I would
> first start with educating them on how to use their email client properly.
> There's nothing wrong with this method of sending email.  If you want to
> send text only, put it in the body of the message.
> >
> > ---mark
> >
> >
> > --
> > Mark Warrick
> > Phone: (714) 547-5386
> > Efax.com Fax: (801) 730-7289
> > Personal Email: [EMAIL PROTECTED]
> > Personal URL: http://www.warrick.net
> > Business Email: [EMAIL PROTECTED]
> > Business URL: http://www.fusioneers.com
> > ICQ: 346566
> > --
> 
> 
> 
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: Whats the deal with the tag ?

[Warrick, Mark]

That tag has nothing to do with Fusebox at all.  It's an HTML tag, and it is used so 
that you don't have to specify a target attribute in each of your links if you're 
using frames or want to open up links into other windows.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Ryan [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 28, 2000 3:57 PM
> To: CF-Talk
> Subject: Whats the deal with the  tag ?
> 
> 
> What is the  tag in fusebox for? Its showing up
> on all my pages, I imagine it comes from cfbodycontent. The problem
> is I am calling one of my fusebox pages from another server and
> it must return a WDDX packet. But this is what I get back:
> 
> http://builder.willconsult.com/signup/">
> .
> 
> Is the  tag necessary? I can I safely pull it out or do you
> recommend keeping it in?
> 
> Thanks,
> Ryan
> 
> 
> 
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: One step method to check then increment a value in db?

[Warrick, Mark]

I'm sure there's several custom tags to do this which might be better than my 
suggestion, but it's simple to do with 2 queries contained within a CFTRANSACTION.

Example (assuming you have an auto increment field named "id_whatever":




INSERT INTO whatever_table (whatever_columns)
VALUES ('#whatever_data#')




SELECT MAX (id_whatever) as newid
FROM whatever_table



#max.newid#


---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 28, 2000 12:40 PM
> To: CF-Talk
> Subject: One step method to check then increment a value in db?
> 
> 
> I'm looking for a simple way to check on and then increment a 
> value in a db
> number field. For example, for a simple hit counter that commits hit
> information to a db field: someone hits the page; you check the 
> database to
> determine the current value of hits on that page; add 1 to it; then update
> the record with the incremented value.
> 
> The method above would require 2  actions as I see it: 
> one to check
> the current value; one to update the field with the incremented value. Is
> there some way to do this without requiring 2 separate actions?
> 
> Thanks for any ideas.
> 
> Paul Sinclair
> 
> 
> 
> 
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: CFMAIL

[Warrick, Mark]

It sounds like your end user doesn't understand how to use email.  I would first start 
with educating them on how to use their email client properly.  There's nothing wrong 
with this method of sending email.  If you want to send text only, put it in the body 
of the message.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 28, 2000 12:01 PM
> To: CF-Talk
> Subject: Re: CFMAIL
> 
> 
> I use the same type of form, but the recipient states they are 
> receiving it
> in MIME format and it needs to be in ascii, is mimeattch the only one that
> works or is there a work around to get it to send in ascii format 
> instead of
> MIME?
> 
> Thanks,
> Robert
> 
> - Original Message -
> From: "Warrick, Mark" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, December 28, 2000 3:02 PM
> Subject: RE: CFMAIL
> 
> 
> > I have a form which sends an email message to a user an which 
> can have an
> attachment.
> >
> > You would obviously first have to have an upload form, but to actually
> mail the attachment, I use this code:
> >
> >  > TO="#email_address_used#"
> > CC="#form.email_cc#"
> > FROM="#form.email_from#"
> > SUBJECT="#message_subject#"
> > MIMEATTACH="#uploadpath#\#serverfile#"
> > >
> >
> > #message_body#
> >
> > 
> >
> > --
> > Mark Warrick
> > Phone: (714) 547-5386
> > Efax.com Fax: (801) 730-7289
> > Personal Email: [EMAIL PROTECTED]
> > Personal URL: http://www.warrick.net
> > Business Email: [EMAIL PROTECTED]
> > Business URL: http://www.fusioneers.com
> > ICQ: 346566
> > --
> >
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, December 28, 2000 11:36 AM
> > > To: CF-Talk
> > > Subject: CFMAIL
> > >
> > >
> > > Good Day,
> > >
> > > I am trying to attach a file in a cfmail form and the command is
> > > mimeattch="path", but the recipient needs it in ascii format 
> and states
> it
> > > comes through as mime format, can this be dome in CFMAIL I can
> > > not find any
> > > documentation on it...
> > >
> > > Any help is appreciated,
> > > Robert
> > >
> > >
> > >
> >
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: CFMAIL

[Warrick, Mark]

I have a form which sends an email message to a user an which can have an attachment.

You would obviously first have to have an upload form, but to actually mail the 
attachment, I use this code:



#message_body#

   

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 28, 2000 11:36 AM
> To: CF-Talk
> Subject: CFMAIL
> 
> 
> Good Day,
> 
> I am trying to attach a file in a cfmail form and the command is
> mimeattch="path", but the recipient needs it in ascii format and states it
> comes through as mime format, can this be dome in CFMAIL I can 
> not find any
> documentation on it...
> 
> Any help is appreciated,
> Robert
> 
> 
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: SQL Dropdown List

[Warrick, Mark]

Now there's an excellent idea!  I like that one.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Sean Daniels [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 28, 2000 11:34 AM
> To: CF-Talk
> Subject: RE: SQL Dropdown List
> 
> 
> I usually add a "sortby" field to all my lookup tables. Make it a smallint
> and then populate it with 1,2,3,4,5 depending on the way you want the
> Dropdown sorted. Then just do one query and order by "sortby". This gives
> youthe most flexibility. If you want Boston at the top for some 
> reason, you
> can do that too.
> 
> > USA (Albequerque) sortby=1
> > USA (Boston) sortby=2
> > USA (Chicago) sortby=3
> > Argentina (Buenos Aires) sortby=4
> > Bolivia (La Paz) sortby=5
> > Canada (Toronto) sortby=6
> 
> 
> - Sean
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: SQL stored procedure and time insert

[Warrick, Mark]

I know this may seem redudant, but give this a try:








--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 28, 2000 10:15 AM
> To: CF-Talk
> Subject: SQL stored procedure and time insert
> 
> 
> 
> I cannot figure out why I am getting this error with SQL Server 
> inserting a
> time value in a stored procedure. Anyone know why?
> 
> 
> 
> ODBC Error Code = 37000 (Syntax error or access violation)
> 
> [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type
> varchar to datetime.
> 
> 
> 
> 
> 
> 
>  cfsqltype="CF_SQL_TIMESTAMP"
> dbvarname="@StartTime"
> value="#StartTime#"
> 
> @StartTime is a DateTime field
> 
> 
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: Vacation Form (LONG RESPONSE)

[Warrick, Mark]

Hello Isabelle,

This is actually alot simpler than it seems.

Here's some brief example specs on this application.  You should expand upon these to 
suit your needs.

Tables needed:

CONTACTS

ID_CONTACT (PK: AUTO INC INT)
FNAME (VARCHAR)
MNAME (VARCHAR)
LNAME (VARCHAR)
SSN (VARCHAR)
EMAIL (VARCHAR)

CONTACT_TYPES (manager, employee, etc.)

ID_CONTACT_TYPE (PK: AUTO INC INT)
CONTACT_TYPE (VARCHAR)

CONTACT_TYPES_TO_CONTACTS (a person might be a part of several different types)

ID_CONTACT_TYPE (INT)
ID_CONTACT (INT)

MANAGERS_EMPLOYEES

ID_MANAGER (FK: ID_CONTACT)
ID_EMPLOYEE (FK: ID_CONTACT)

VACATION_REQUESTS

ID_VACATION_REQUEST (PK: AUTO INC INT)
DT_REQUEST_DATE (DATE/TIME)
ID_EMPLOYEE (FK: ID_CONTACT) (INT)
ID_MANAGER (FK: ID_CONTACT) (INT)
DT_VACATION_START_DATE (DATE/TIME)
DT_VACATION_END_DATE (DATE/TIME)
PENDING (INT)
APPROVED (INT)
TAKEN (INT)


STEP 1: IDENTIFY THE USER
You need to know who the employee is, so you'll to have them "login".  This can be 
done with a login form that asks for their name and possibly the last 4 digits of 
their SSN (or something like that).  Run a query on the contacts table to verify their 
identity.  Then set session var session.id_contact and CFLOCATION to the vacation form.

STEP 2: FIND OUT WHO THIS PERSON'S MANAGER IS
Based upon the session._id_contact, run a query on the MANAGERS_EMPLOYEES table to 
find out which manager is assigned to this user.  Join that query to the contacts 
table to retrieve their name for display on the form.  (This may not be necessary.)

Insert the vacation data into the table, making sure that the following default column 
values are used:  PENDING=1, APPROVED=0, TAKEN=0.

NOTE: STEP 3 could be combined with step 2.

STEP 3: CREATE A SCRIPT TO SEARCH THROUGH PENDING VACATIONS
Create a query which searches the vacations table for all rows where the pending 
column = 1.

Run the same query as described in step 2 to figure out which manager is assigned to 
this employee.

Now based upon the results of the two queries above, create a CFMAIL script containing 
all the contents of the vacation request form which will be sent to the manager.

STEP 4: CFSCHEDULED EVENT
Create a cfschedule for step 3.  The pro of using a cfschedule is that you can 
continously notify the managers about pending vacation requets until they log in to 
ths system and do something about it!  The con is that they'll continue to receive 
messages until they do something about it.  Depending upon how often you want to nag 
the managers will determine what regularity you run the script.  You could also skip 
this step and simply combine step 2 & 3.

STEP 5: MANAGING THE VACATION REQUESTS
So now that the manager has been notified, they'll need to login and approve or not 
approve the form. They login in the same manner as described above for employees.  
Based upon their session.id_contact, run a query on the managers_employees table and 
then a query on the vacations table to figure out whether this manager has any 
employees requesting vacations.  Based upon those results, create a list of vacation 
requests.  Each vacation requets links to the vacation authorization form which is 
dynamically populated based upon a query you'll run to populate it.

The vacation authorization form should not allow the manager to do anything excpet 
change values for the following:
APPROVED?
TAKEN?

Note that the user does not change the pending value because that will be done 
automatically when you update the record.  (Set the PENDING=0)

STEP 6: STATUS NOTIFICATIONS
Finally, using similar logic as described in steps 2,3, and 4, send notifications to 
whomever.  

Hopefully this gives you a nice jump start.

---mark

 
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Isabelle Lynch [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 28, 2000 7:55 AM
> To: CF-Talk
> Subject: Vacation Form
> 
> 
> I am attempting to create a vacation form that works in the following
> manner:
> 
> (1) User completes the form
> (2) Using a drop down list, user selects the appropriate manager, and the
> form is e-mailed to that manager
> (3) Manager receives the form, selects the correct approval/disaproval of
> vacation
> (4) If approved is checked, form automatically goes to the 
> receptionist for
> input into the corporate calendar, and the initial user receives his/her
> approval via e-mail
> (5) If vacation is disaproved, an e-mail is sent to the initial user
> advising that vacation has been disapproved.
> 
> Can this be do

RE: Repeat Question still needing help

[Warrick, Mark]

The file uploading and transfering to another site can be handled with CFFTP.

The querying of a remote datasource could be handled with XML, WDDX, and possibly 
CFHTTP if you can load a script onto the remote server with CFFTP (or whatever).

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 27, 2000 9:05 PM
> To: CF-Talk
> Subject: RE: Repeat Question still needing help
> 
> 
> I want to upload files at a particular website but store them at 
> a seperate
> server where we have additional storage space.  We would also like to be
> able to query that database through our main site.  So how can  write a
> query to a datasource that is on a seperate server?
> 
> Rich
> 
> -Original Message-
> From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 27, 2000 6:16 PM
> To: CF-Talk
> Subject: RE: Repeat Question still needing help
> 
> 
> I'm curious.  What does CFFILE have to do with a remote database?
> 
> Perhaps you could explain the problem in more detail?
> 
> Maybe you've even got a technical spec? (crosses his fingers)
> 
> ---mark
> 
> --
> Mark Warrick
> Phone: (714) 547-5386
> Efax.com Fax: (801) 730-7289
> Personal Email: [EMAIL PROTECTED]
> Personal URL: http://www.warrick.net
> Business Email: [EMAIL PROTECTED]
> Business URL: http://www.fusioneers.com
> ICQ: 346566
> --
> 
> 
> > -Original Message-
> > From: ibtoad [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, December 27, 2000 12:50 PM
> > To: CF-Talk
> > Subject: RE: Repeat Question still needing help
> >
> >
> > Access Database.  I want to be able to upload files using cffile on our
> > website and store them on a seperate server.
> >
> > Rich
> >
> > -Original Message-
> > From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, December 27, 2000 3:22 PM
> > To: CF-Talk
> > Subject: Re: Repeat Question still needing help
> >
> >
> > What kind of database?  In general you can access a desktop or
> > SQL database
> > if you configure it properly in ODBC.  For desktop DBs I'm pretty
> > sure that
> > the ColdFusion service needs to be logged in as a user with 
> rights to the
> > other server.
> >
> > Regards,
> >
> > Howie
> >
> > - Original Message -
> > From: "ibtoad" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, December 27, 2000 3:05 PM
> > Subject: Repeat Question still needing help
> >
> >
> > > Can I query a database from a different
> > > server if I have the datasource name and the full server root?
> > >
> > > Any suggestions would be great,
> > > Rich
> > >
> > >
> >
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free Setup 
from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support  Visit 
SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: cfmail and aol addresses

[Warrick, Mark]

Is it possible you've been banned from sending email to the AOL network?  Try sending 
someone on AOL an email with a normal email client.  See what happens.

It's also highly probable that the messages are actually getting there - just very 
slowly.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Jonathan Karlen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 27, 2000 1:20 PM
> To: CF-Talk
> Subject: cfmail and aol addresses
> 
> 
> For some reason the mail generated by CFMAIL tags on a web site I'm
> buidling are not being delivered to AOL addresses.  Any ide why?
> 
> TIA -
> Jonathan Karlen
> 
> 
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free Setup 
from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support  Visit 
SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: Repeat Question still needing help

[Warrick, Mark]

I'm curious.  What does CFFILE have to do with a remote database?

Perhaps you could explain the problem in more detail?

Maybe you've even got a technical spec? (crosses his fingers)

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 27, 2000 12:50 PM
> To: CF-Talk
> Subject: RE: Repeat Question still needing help
> 
> 
> Access Database.  I want to be able to upload files using cffile on our
> website and store them on a seperate server.
> 
> Rich
> 
> -Original Message-
> From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 27, 2000 3:22 PM
> To: CF-Talk
> Subject: Re: Repeat Question still needing help
> 
> 
> What kind of database?  In general you can access a desktop or 
> SQL database
> if you configure it properly in ODBC.  For desktop DBs I'm pretty 
> sure that
> the ColdFusion service needs to be logged in as a user with rights to the
> other server.
> 
> Regards,
> 
> Howie
> 
> - Original Message -
> From: "ibtoad" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, December 27, 2000 3:05 PM
> Subject: Repeat Question still needing help
> 
> 
> > Can I query a database from a different
> > server if I have the datasource name and the full server root?
> >
> > Any suggestions would be great,
> > Rich
> >
> >
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free Setup 
from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support  Visit 
SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: Repeat Question still needing help

[Warrick, Mark]

It is possible to setup a datasource on your local CF server to a remote database so 
long as you somehow have access to it.  For example, if the remote server is a SQL 
server, then you simply enter in the connection string into the datasource options & 
there you go - it'll work (with some performance degradation) as though it was on the 
same box.

Let's say that a remote server has an Access database on it.  Well, in this case, you 
would have to have a UNC path to the remote drive and then you could setup the remote 
MDB file as a local datasource.

I'm certain that there's a way to exchange data with XML or WDDX but I'll leave those 
tutorials up to the experts in those areas.  I'd be curious to know how one would 
connect to a remote MDB file without a UNC connection.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 27, 2000 12:05 PM
> To: CF-Talk
> Subject: Repeat Question still needing help
> 
> 
> Can I query a database from a different
> server if I have the datasource name and the full server root?
> 
> Any suggestions would be great,
> Rich
> 
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free Setup 
from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support  Visit 
SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: External Datasource help??

[Warrick, Mark]

Set it up as an ODBC datasource on the server from which you are making requests and 
run a query against it.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 27, 2000 8:05 AM
> To: CF-Talk
> Subject: External Datasource help??
> 
> 
> How can I query an external datasource? I have the full root path and the
> datasource name, is this even possible?
> 
> Thanks,
> Rich
> 
> 
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free Setup 
from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support  Visit 
SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: javascript problem

[Warrick, Mark]

Try surrounding the logic with a CFIF statement to exclude processing if the template 
name contains "login.cfm" and see what happens.

Also, I'm not sure about the second javascript call you've got there - the focus call. 
 That may have something to do with it.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: S R [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 26, 2000 3:36 PM
> To: CF-Talk
> Subject: javascript problem
> 
> 
> Happy holidays,
> 
> This problem is boggling my mind. It only happens when I put the 
> code in the 
> 'root' application. I'm trying to test for a 'session.userid' 
> variable that 
> is supposed to be set after someone logs in with the correct username and 
> password. As you can see I am testing it by deleting my session 
> variable and 
> the page with the login screen, which is a pop-up window, does come up. 
> Except that the pop-up window goes into an infinite loop of refreshing 
> itself. I can't figure it out. HELP!!
> 
> Thanks
> 
>  SESSIONMANAGEMENT="Yes" SESSIONTIMEOUT="#CreateTimeSpan(1, 0, 0, 0)#">
> 
> 
>   
> 
> 
> 
> 
> 
>   
>   
> 
>   
> 
>   function openpopup(){
>   
> openpopup=window.open("login.cfm","newWin","width=200,height=150,l
> eft=400, 
> right=300")
>   }
> 
>   
>   
>   
> 
>   
>   
> 
> 
> 
> 
>   
> 
> 
>
~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free Setup 
from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support  Visit 
SoloServer, https://secure.irides.com/clientsetup.cfm.

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

RE: little help here?

[Warrick, Mark]

To simplfy things, I would first run two queries - one for the "yes" images and one 
for the "no" images.  Then I would output those two queries into their respective 
columns.

To make the images display 3 across, set a count when you start outputting the images. 
 Evaluate the count upon each subsequent record output, and when you get to 3, put in 
the appropriate  (or line break) and reset the count.  You would also want to 
evaluate the total recordcount to be sure you close off the table tags correctly.

For example:











 
 


 















--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 22, 2000 10:23 AM
> To: CF-Talk
> Subject: little help here?
> 
> 
> here is my code for my image viewing pages, i have two things to 
> figure out now. one is i have all of the images seperated with a 
> Yes or a No value. they both need to be shown on there own. (all 
> the ones with yes in one section and all the ones with No in 
> thier own section.) thats the first thing i need to figure out, 
> then the next is how do i get them to show up in the format that 
> i want 3 accross the top, 2 in the middle and 3 accross the 
> bottom... can you help me?
> 
>   datasource="gallery"
>  dbtype="ODBC">
> Select *
> >From ImageManager
> 
> 
> 
> Untitled Document
> 
> 
> 
> 
>   
>    
>   
>   
> 
> 
>  src="ImageManager/WebImages/#GetImages.ImageName#" border="0">
> 
> 
> 
> Next 8
> 
> 
> 
> 
> 
> 
> Jay Patton
> Web Pro USA
> 406.549.3337 ext. 203
> 1.888.5WEBPRO
> www.webpro-usa.com
> 
> 
>
~~
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: Fusebox

[Warrick, Mark]

Just to play the devil's advocate here, a system without technical documentation is a 
poorly written system to begin with.  It doesn't matter at that point HOW it was 
written.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Chris Martin [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 22, 2000 8:36 AM
> To: CF-Talk
> Subject: RE: Fusebox
> 
> 
> I can sympathize with this.  Our company bought  a Forums package for our
> site.  Written entirely in fusebox, its a great package and we've 
> never had
> any problems, but when it came time to go through everything and 
> familiarize
> our developers with the code, it was an exercise in futility.  It 
> seems that
> no page actually has any native code in it, the whole thing is made up of
> cfincludes, referencing other templates.  IT just seems a little 
> bit on the
> ridiculous side to write 300 odd 1k templates and cfinclude them in every
> single page.  It was also a nightmare when we had to inventory 
> all our code
> and queries and such.  I wasted about a week trying to document everything
> before I finally gave up.
> 
> -Original Message-
> From: C Frederic Valone [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 22, 2000 11:12 AM
> To: CF-Talk
> Subject: Re: Fusebox
> 
> 
> Just to insert my two cents worth,
> 
> I inherited a site that I have now see was supposed to follow the fusebox
> methodology. It has been a nightmare trying to figure out what they were
> trying to do.
> 
> I may be wrong but it seems to me that too have an include on the 
> index page
> point to an action file that simply points to a display file was not the
> proper implementation.
> 
> Just from looking the fusebox docs over once I see that what I would think
> is the proper implementation of this would be more like this
> 1)an include on the index page that points to an action file that does and
> action
> 2)an include on the index page below the action file that points 
> to a query
> file
> 3)an include on the index page below the query file that points 
> to a display
> file that may show the results returned based on the action and 
> query file.
>  Am I correct in this?
> 
> I will admit that the methodology is a good thing to have to 
> structure code
> and make it easier for a new programmer to come in and see what 
> is going on.
> However in this case the documentation was nearly nonexistant and the fact
> that some of the includes stayed within the directory structure and others
> did not made this application
> extremely hard to follow.
> 
> I am not the only programmer here that felt the same way about this
> application. I am not saying that the methodology is wrong...quite the
> contrary it seems to be simple and expandable. I am saying that no matter
> what  methodolgy someone uses, the results you get will depend on how well
> you understand what the methodology is doing, how
> well you document your work and how closely you follow the specs of the
> methodology.
> 
> Thanks
>  Frederic
>
~~
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: Page Tracking & hits :: User Movments on an Intranet

[Warrick, Mark]

Ooops yes, of course.

You can use the #script_name# variable.

And if you want to do it fusebox style, you can use the following logic instead:










SELECT * FROM counter
WHERE page  = '#page#'






INSERT INTO counter (page,hits)
VALUES ('#page#', 2)



1





#gethits.hits#










UPDATE counter
SET hits = #newhits#
WHERE page = '#page#'









--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 22, 2000 4:44 AM
> To: CF-Talk
> Subject: RE: Page Tracking & hits :: User Movments on an Intranet
> 
> 
> would you also need to insert the name of the page?
> so that you can see what page & how long they where on it?
> 
> thanks for the advice.
> -paul
> 
> > -Original Message-
> > From:   Warrick, Mark [SMTP:[EMAIL PROTECTED]]
> > Sent:   Thursday, December 21, 2000 1:03 PM
> > To: CF-Talk
> > Subject:RE: Page Tracking & hits :: User Movments on an Intranet
> > 
> > Hi Paul,
> > 
> > I really don't think there is a tutorial.  You can use the code below as
> > an example.  This is the easiest way to track visitors.  You 
> would include
> > this into every template.  (by the way, this has nothing to do 
> with server
> > logs)
> > 
> > 
> > 
> > 
> > 
> > 
> > (of course you'll need to create a database for this)
> > 
> > 
> > INSERT INTO access_log (
> > ip,
> > login_date,
> > login_time)
> > VALUES (
> > '#ip#',
> > '#login_date#',
> > '#login_time#')
> > 
> > 
> > ---mark
> > 
> > 
> > --
> > Mark Warrick
> > Phone: (714) 547-5386
> > Efax.com Fax: (801) 730-7289
> > Personal Email: [EMAIL PROTECTED]
> > Personal URL: http://www.warrick.net 
> > Business Email: [EMAIL PROTECTED]
> > Business URL: http://www.fusioneers.com
> > ICQ: 346566
> > --
> > 
> > 
> > > -Original Message-
> > > From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, December 21, 2000 4:51 AM
> > > To: CF-Talk
> > > Subject: RE: Page Tracking & hits :: User Movments on an Intranet
> > > 
> > > 
> > > is there a tutorial for this in the advanced wack book?
> > > guess i should just look my self, sorry.
> > > 
> > > i cant use server logs.
> > > they are turned off
> > > thanks
> > > -paul
> > > 
> > > > -Original Message-
> > > > From:   Warrick, Mark [SMTP:[EMAIL PROTECTED]]
> > > > Sent:   Wednesday, December 20, 2000 1:25 PM
> > > > To: CF-Talk
> > > > Subject:RE: Page Tracking & hits :: User Movments 
> on an Intranet
> > > > 
> > > > The anonymous way would be to assign a random ID to each new visitor
> > and
> > > > then record that ID with every page view (or fuseaction) into a
> > database
> > > > or text file.
> > > > 
> > > > The membership-based way would be to have a user login & then track
> > them
> > > > the same way.
> > > > 
> > > > --
> > > > Mark Warrick
> > > > Phone: (714) 547-5386
> > > > Efax.com Fax: (801) 730-7289
> > > > Personal Email: [EMAIL PROTECTED]
> > > > Personal URL: http://www.warrick.net 
> > > > Business Email: [EMAIL PROTECTED]
> > > > Business URL: http://www.fusioneers.com
> > > > ICQ: 346566
> > > > --
> > > > 
> > > > 
> > > > > -Original Message-
> > > > > From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
> > > > > Sent: Wednesday, December 20, 2000 5:47 AM
> > > > > To: CF-Talk
> > > > > Subject: Page Tracking & hits :: User Movments on an Intranet
&

RE: Session Variables

[Warrick, Mark]

Session variables will remain persistent even if a user goes to another site and they 
will remain pesistent as long as they are not timed out either due to coding or 
default settings of the server.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Kinley Pon [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 21, 2000 12:02 PM
> To: CF-Talk
> Subject: Session Variables
> 
> 
> Hello everyone,
> 
> I was under the understanding that session variables will reset 
> or clear out
> under the following circumstances:
> 1.When the user goes to a different site.
> 2.When the browser closes.
> 3.When the session timeout is reached.
> 
> Sometimes it appears the session variables are not resetting or clearing
> out.
> 
> Am I missing something…
> 
> Justme
> 
> 
>
~~
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: Page Tracking & hits :: User Movments on an Intranet

[Warrick, Mark]

Hi Paul,

I really don't think there is a tutorial.  You can use the code below as an example.  
This is the easiest way to track visitors.  You would include this into every 
template.  (by the way, this has nothing to do with server logs)






(of course you'll need to create a database for this)


INSERT INTO access_log (
ip,
login_date,
login_time)
VALUES (
'#ip#',
'#login_date#',
'#login_time#')


---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 21, 2000 4:51 AM
> To: CF-Talk
> Subject: RE: Page Tracking & hits :: User Movments on an Intranet
> 
> 
> is there a tutorial for this in the advanced wack book?
> guess i should just look my self, sorry.
> 
> i cant use server logs.
> they are turned off
> thanks
> -paul
> 
> > -Original Message-
> > From:   Warrick, Mark [SMTP:[EMAIL PROTECTED]]
> > Sent:   Wednesday, December 20, 2000 1:25 PM
> > To: CF-Talk
> > Subject:RE: Page Tracking & hits :: User Movments on an Intranet
> > 
> > The anonymous way would be to assign a random ID to each new visitor and
> > then record that ID with every page view (or fuseaction) into a database
> > or text file.
> > 
> > The membership-based way would be to have a user login & then track them
> > the same way.
> > 
> > --
> > Mark Warrick
> > Phone: (714) 547-5386
> > Efax.com Fax: (801) 730-7289
> > Personal Email: [EMAIL PROTECTED]
> > Personal URL: http://www.warrick.net 
> > Business Email: [EMAIL PROTECTED]
> > Business URL: http://www.fusioneers.com
> > ICQ: 346566
> > --
> > 
> > 
> > > -Original Message-
> > > From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, December 20, 2000 5:47 AM
> > > To: CF-Talk
> > > Subject: Page Tracking & hits :: User Movments on an Intranet
> > > 
> > > 
> > > hello all!
> > > i know this has been asked befor, but i cant find the email.
> > > 
> > > What software or utilities do you guys use to track user movments on
> > your
> > > site?
> > > i need to see what parts of our intranet are really being utalized &
> > what
> > > isnt.
> > > 
> > > so i can do a rebuild.
> > > 
> > > any helpp would be great!
> > > 
> > > thank you
> > > 
> > > -paul
> > > 
> > > Web Developer, NBBJ
> > > Work: [EMAIL PROTECTED]
> > >   614 241-3534
> > > 
> > > Home: [EMAIL PROTECTED]
> > >   614 449-1681
> > > 
> > >   [EMAIL PROTECTED]
> > > icq:  47658358
> > > 
> > > 
> > > 
> > >
> >
>
~~
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: Page Tracking & hits :: User Movments on an Intranet

[Warrick, Mark]

The anonymous way would be to assign a random ID to each new visitor and then record 
that ID with every page view (or fuseaction) into a database or text file.

The membership-based way would be to have a user login & then track them the same way.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 20, 2000 5:47 AM
> To: CF-Talk
> Subject: Page Tracking & hits :: User Movments on an Intranet
> 
> 
> hello all!
> i know this has been asked befor, but i cant find the email.
> 
> What software or utilities do you guys use to track user movments on your
> site?
> i need to see what parts of our intranet are really being utalized & what
> isnt.
> 
> so i can do a rebuild.
> 
> any helpp would be great!
> 
> thank you
> 
> -paul
> 
> Web Developer, NBBJ
> Work: [EMAIL PROTECTED]
>   614 241-3534
> 
> Home: [EMAIL PROTECTED]
>   614 449-1681
> 
>   [EMAIL PROTECTED]
> icq:  47658358
> 
> 
> 
>
~~
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: Fusebox

[Warrick, Mark]

The fusebox methodology has many benefits, and I really don't think it adds any time 
to the development cycle.  In fact, I'm pretty sure it helps speed up development.

One of the greatest advantages of the style is that you can modularize you code, and 
in doing so, you can assign pieces of your application to various developers without 
worrying about them stepping on each other's toes.

Another advantage is that because it is a documented approach to programming, the next 
programmers won't have to decipher your unique style in order to pick up where you 
left off.

Another advantage is that certain companies (such as mine) require it.  So if you 
don't do it, you're not going to get a job with certain companies.

Lastly, it's very simple to follow the programming flow of a fusebox app.  When 
something goes wrong, you simply search for the fuseaction in the index file and then 
you'll see right away all the templates in a single handy block that could be involved 
with the problem.

I'm sure the folks on the Fusebox list would be happy to help you more with this.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: war ape [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 20, 2000 6:22 AM
> To: CF-Talk
> Subject: Fusebox
> 
> 
> 
> Whats the whole point of Fusebox?
> I don't see how it makes an application any less proprietary
> i i know it helps modularize an application for reuse, but how 
> does it help 
> make the application more understandable to other programmers?
> Most don't use fusebox, so right there its been made harder
> also i think it adds a dense layer of complexity to an application, 
> basically adding another 10-15% work to the appllication.
> I don't see that it does much that could not be achieved with a 
> standardized 
> naming convention.
> Sorry if i seem the philistine, but my mantra has always been simplicity, 
> simplicity is what makes an application more accessible to later 
> programmers
>
~~
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: How can I find the date of the monday of the week containing a given date?

[Warrick, Mark]

Here one way to do it:



Subject: How can I find the date of the monday of the week containing a
given date?






Current Date: #today#




Current Day of the Week: #today_dow#




Days to beginning of week: #days_to_week_begin#





Week begin date: #DateFormat(week_begin_date, "mm-dd-")#





--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Brent Goldman [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 19, 2000 6:29 PM
> To: CF-Talk
> Subject: How can I find the date of the monday of the week containing a
> given date?
> 
> 
> Hello,
> 
> I am currently writing an online scheduling application with 
> ColdFusion.  At 
> one part of the program, I output the next four weeks in case the 
> user wants 
> to quickly jump ahead in time.  Rather than outputting weeks 
> starting from 
> the current day, such as from a Tuesday like today, I want the weeks 
> starting from a Monday.  So today's week would be Dec 18 (Mon) - Dec 24 
> (Sun), not Dec 19 (Tue) - Dec 25 (Mon).
> 
> I've looked at all of the ColdFusion date functions, but I can't 
> figure out 
> how to use them to retrieve the date of the Monday of the week 
> containing a 
> given date.  Does anyone know how to do this?  Someone please help.
> 
> Thanks,
> Brent
>
~~
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) Date column x year column

[Warrick, Mark]

I'm not certain whether this can even be done with SQL.  What I would do is use 
ColdFusion for the calculations and based upon your logic below, either display or not 
display the records.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Owens, Howard [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 19, 2000 4:01 PM
> To: CF-Talk
> Subject: (SQL) Date column x year column
> 
> 
> 
> 
> I hope somebody can help me out with something that is looking like it's a
> SQL problem more advanced than I can handle.
> 
> I have two table -- Primary and DuesAdmin.  I need to select data 
> from each
> table.  The WHERE clause needs to be based on the combination of 
> two columns
> compared to today's date.
> 
> The first clauses would look something like this:
> 
> SELECT Primary.FirstName
>Primary.LastName
>   Primary.Email
>   DuesAdmin.DateofPayment
>   DuesAdmin.YearsPaid
> FROM Primary, DuesAdmin
> 
> 
> OK.
> 
> Now it gets tricky.
> 
> I need to mulitiply DateofPayment by YearsPaid. If that creates a 
> date that
> is something short of day, I want to select that row.
> 
> To put it another way, I've got people who paid 18 months ago and paid for
> one year of membership. I want to find those expired accounts.  I've also
> got people who paid 3 years ago and paid for 3 years (or 2 years, etc.).
> 
> Apparently, I can't multiple the columns and then do a compare (less than)
> with today's date.
> 
> OK, SQL guru's, how would you do this?
> 
> H.
> 
> 
>
~~
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 (new)

[Warrick, Mark]

Actually, I think what you need to read up on is how to "Browse Next N records".  In 
Ben Forta's ColdFusion Web Application Construction Kit (version 4.0) it takes Ben 
about 8 pages of text to describe how this works.  Does your book have that same 
tutorial?  Does anyone have a tutorial on the web for this?

To summarize, what you need to do is pass the record staring points and maxrows counts 
between each search results view.  The counts are based upon the total number of 
records in the results set and the max number of records per page.

---mark
--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 19, 2000 1:54 PM
> To: CF-Talk
> Subject: cfloop help (new)
> 
> 
> Hello all,
> Im kinda new at the coldfusion stuff ive picked it up really fast 
> but im having a problem.
> i have over 200 images in two different categories, and i want to 
> display only 8 at a time so if i were to click on photos i would 
> want to see the first 8 photos in the database and then be able 
> to navigate back and fourth through the images displaying only 8 
> at a time. same with if i were to click on paintings as well. but 
> i honestly even after reading the entire chapter on looping in my 
> ColdFusion 4.5 book still dont quite understand how to make the 
> loop work. if anyone could help me out that would be great. Thanks
> 
> -Jay Patton
> www.webpro-usa.com
> 
> 
>
~~
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: Reading Table Info

[Warrick, Mark]

Not sure about the attributes (I would like to know as well), but you can get the 
column list by doing the following:


SELECT *
FROM tablename



#get_columns.columnlist#


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Dave Hannum [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 19, 2000 1:00 PM
> To: CF-Talk
> Subject: Reading Table Info
> 
> 
> Is there a way to return the attributes of the columns a table in CF?  For
> example, in Oracle - is it a VarChar2 or an Integer field, or in 
> Access - is
> it a Text field or AutoNumber, etc?
> 
> Dave
> 
> 
> > "What we need is a list of specific unknown 
>problems we will encounter"
> 
> David Hannum
> Web Analyst/Programmer
> Ohio University
> [EMAIL PROTECTED]
> (740) 597-2524
> 
> 
> 
> 
> 
>
~~
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: Shopping Cart

[Warrick, Mark]

AbleCommerce is a nice out-of-the-box solution.  (http://www.ablecommerce.com) - It 
requires no ColdFusion knowledge to maintain.

I haven't tried this one, but it's cheaper than AbleCommerce: http://www.cartease.com/

If you want to "roll your own" you might try this tutorial: 
http://hotwired.lycos.com/webmonkey/99/49/index4a.html?tw=programming

I'm sure there's more.  These just came off the top of my head.


---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Eric Homa [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 19, 2000 9:44 AM
> To: CF-Talk
> Subject: Shopping Cart
> 
> 
> Can anyone recommend a shopping cart that is written in CF that 
> can be integrated into our own code?  Any shopping cart 
> experiences, good and bad, would be welcome information.
> 
> Thanks,
> 
> Eric Homa
> compudigital.com
> 
> 
>
~~
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: Multiple submits

[Warrick, Mark]

Yes.  You can use a combination of JavaScript and DHTML.  This works with IE, not sure 
about Netscape.  Try the following example:














 

Your credit card is being processed.  Please wait.













#count#



--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Jon Gage [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 19, 2000 6:57 AM
> To: CF-Talk
> Subject: Multiple submits
> 
> 
> Does anybody have any suggestions for preventing users from 
> hitting a submit
> button multiple times?
> 
> Thanks,
> 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: Undo Delete

[Warrick, Mark]

Sounds like a good idea to me.  Go for it!

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: David Shadovitz [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, December 16, 2000 6:52 PM
> To: CF-Talk
> Subject: OT: Undo Delete
> 
> 
> I'm thinking of changing my typical "Delete" button so that it doesn't
> actually delete a record, but rather flags it as a record to be ignored. 
> I'd also record the date/time that it was flagged.  That way I can offer
> the user the opportunity to Undo the Delete.  I'll probably schedule a
> job to delete all records which have been flagged for more than 1 day.
> 
> Hey, I've been influenced by Jef Raskin's "The Humane Interface" and Alan
> Cooper's "The Inmates are Running the Asylum."
> 
> Any thoughts?
> 
> Here's another use for flagging records:  Our db tables which contain
> scientific data contain an "approved" field, whose default value is
> "false".  After data is inserted into the database, an analyst checks it
> out, and then we toggle the flag to "true".  Of course, our non-admin
> canned queries all include "WHERE approved = true".
> 
> -David
>
~~
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: profiles.

[Warrick, Mark]

If you cannot use cookies, then you have to maintain state by passing some sort of key 
between all URL calls and form fields which looks up the current user's "profile" in a 
database.  This works fine, but it will slow down the system a little bit.  Imagine 
having to call the database upon every page load - that may not seem like a big deal, 
but put a hundred people on it, and you'll notice.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: miles [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 9:24 PM
> To: CF-Talk
> Subject: profiles.
> 
> 
> Hi,
> 
> I have an interesting intellectual problem that I need to 
> solvenot immediately, but sometime in the next three
> months.  I am about to roll out a new website for a client
> and to be honest (the client is aware of this) that its a kluudge
> at best...but it worksthey are happy...Im happy.  Everyone
> is happy.  
> 
> PROBLEM!
> 
> Everyone is NOT happy...me being the one that is not happy.
> The problem is that the site IS a kluudge.   The reason its a 
> kluudge is best left to history.  However in rethinking the site,
> I have come up with a solution that will not only make the 
> site more operable, but easier to maintain in the long run
> and that much easier to develop for in the future.
> 
> What I am wanting to do is modulerize EVERYTHING...
> and its not right now.  And one of those modules is a user
> module...this module will keep all types of user data, it will
> save different user queries (prepackaged ones of course for
> external users of the site, internal users get to create their own
> dynamic queries), last time they logged in, what their page is 
> supposed to look like, who their internal advocates are (this is
> a support website so we assign them a support advocate that
> works with them directly through the life of their support contract)
> and who their sales reps are/wereetc. stuff like that.  
> 
> My question is this...
> 
> I view this kind of data as user "profile" data stuff that will
> essentially never change except for a few times after the end user
> logs in.  They may change what queries they'd like to see, but
> the rest of the data isn't going to change.  What I was thinking
> was to store this user profile data in a tablethen when the
> end user logs in...this "state" or profile data is pulled up and
> then acted upon.  Is there a better way to store this data somewhere...
> and cookies are NOT an option here.  
> 
> Sincerely,
> 
> Miles.
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: jr CF

[Warrick, Mark]

My advice:

Setup a web site which demostrates your skills.  If you can demonstrate that you are 
knowledgeable about EVERY CF tag in the book, I'm sure you'll get a job.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 12, 2000 11:28 AM
> To: CF-Jobs
> Subject: Re: jr CF
> 
> 
> 
>  Things I would recommend:
> 
>  Take the Allaire courses.  The beginner one and the advanced one on 
> Cold Fusion.  Even if you pay for it out of your own pocket.  They 
> aren't substitute for real-world experience, but will probably look
> better on a resume than "I self-taught myself at home for the past 6
> months."  
> 
>  Become active in the local CFUG, or try to start one if there isn't one.
> Go to meetings, and if you can, get involved in the web site (which will
> most likely use Cold Fusion).  Although, recruiting at meetings is 
> generally frowned upon by the CFUG managers, I have been to meetings that 
> do a 'business card swap' at the end of the meeting.  You may 
> even be able 
> to do this sort of work telecommuting for a CFUG if there isn't 
> one local.  
> 
>  Look up local non-profit or volunteer run organizations.  Can you get 
> involved with their web site, will ColdFusion help.  
> 
>  I just don't think it's right for a company to pay someone nothing, 
> (that includes internships) for work.  I wouldn't expect an intern 
> or a jr developer to receive the compensation someone w/ 4+ years 
> experience would, either.  
> 
> 
> > Ellen Swartz wrote:
> > 
> > Very interesting thread.
> > 
> > I am not alone and it does not make me feel any better.
> > I have been struggling for the last 6 months between getting 
> several part-time
> > jobs to make some $ and finding an entry level CF position or 
> internship. I
> > got about 10 interviews with local companies that all ended the 
> same way.
> > "Sorry, you don't have enough experience. Go home, work hard 
> and contact us
> > again when you are ready."
> > 
> > Let's face it. What company is going to hire an accountant with 
> no experience
> > and barely any knowledge?
> > If CF was tought in college we would not be were we are now. We 
> still would
> > not have the real life experience but we would have a lot more 
> knowledge and
> > consequently a lot more chances to find an entry level CF job.
> > 
> > I got to a point where I was wondering if I should pay a 
> company to hire me
> > and give me some real life experience. I would work for freee 
> if I was given
> > the opportunity (only on-site with a local company). It's 
> either that (and I
> > agree I would be taken advantage of) or spent another year 
> strugging learning
> > in 6 months at home what I would probably learn in a month 
> working full time.
> > 
> > Why don't we start something.
> > CF guru could teach one or twice a week and be paid for it.
> > Example: I live in Fort Lauderdale, FL. If an experience CF 
> could give a class
> > to 10 CF beginners at least once a week and get paid by us (how 
> much would
> > have to be determined) maybe we would learn faster and smarter.
> > 
> > 
> 
> -- 
> Jeff Houser
> AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
> --
> DotComIt, LLC
> Computer Consultant specializing in database driven web data
> Lotus Notes/Domino, Cold Fusion
> --
> Half of the Alternative Folk Acoustic Duo called Far Cry Fly 
> http://www.farcryfly.com
> http://www.mp3.com/FarCryFly
> --
> Does Everyone Think I'm a Cynical?
> --
> 
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_jobs or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the 
body.


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: mailmerge witth sql server database

[Warrick, Mark]

Yes, you can use a SQL database or any ODBC compliant DB or just about any type of 
file.  This has absolutely nothing at all to do with ColdFusion whatsoever.

I'm not sure why you would wan to use ColdFusion to do this when MS Word handles it so 
well.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: thanh nguyen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 1:32 PM
> To: CF-Talk
> Subject: mailmerge witth sql server database
> 
> 
> helllo everyone,
> I would like to know if someone has done mailmerge with sql 
> server database, 
> I have mailmerge word document and would like to retrieve the 
> data from the 
> sql server database.  can i use cold fusion do the job,
> thanks
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> 
> Share information about yourself, create your own public profile at 
> http://profiles.msn.com.
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Is Cold Fusion a Typed Language?

[Warrick, Mark]

Thank you!  Great explanation.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Peter Theobald [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 2:17 PM
> To: CF-Talk
> Subject: RE: Is Cold Fusion a Typed Language?
> 
> 
> A strongly typed language requires you to declare the data type 
> of all variables ahead of time. All functions return values that 
> are of a specific type. All operators act on values of specific 
> data types.
> 
> For example, assume you have a function nth( list, n) that 
> returns the nth value of a list where a list is a string with 
> comma separated values. nth might be declared as follows:
>   string nth( string list, integer n)
> 
> It would be an error to pass anything but a string as the first 
> argument. It would be an error to pass anything but an integer as 
> the second argument. It would be an error to assign the results 
> to anything but a string variable.
> 
> string list = "10,20,30,40";
> string val;
> integer n=2;
> integer m;
> 
> val = nth( list, n);( val = the string "20")
> m = nth( list, n);(ERROR because nth returns a STRING not an integer)
> val = nth( list, "3")  (ERROR because "3" is a string)
> val = nth( list, 3)(val = the string "30")
> 
> If you need to get around these restrictions you need to 
> explicitly convert the datatypes:
> 
> m = convert( nth( list, 3), "integer")
> or
> m - (int) convert( nth( list, 3))   (this is how 'C' does it)
> 
> 
> The advantages of a strongly typed language are the 
> compiler/run-time system can catch subtle errors because you are 
> so explicit about what data types are being passed around.
> The disadvantage is it's a pain to have to declare everything 
> ahead of time and to convert values all over the place.
> 
> Most "typed languages" are not quite this strict and will do many 
> automatic conversions for you.
> 
> 
> At 08:21 AM 11/7/00 -0800, Warrick, Mark wrote:
> >For the sake of us non-programmers could you explain what "typed 
> language" means?
> >
> >---mark
> >
> >--
> >Mark Warrick
> >Phone: (714) 547-5386
> >Efax.com Fax: (801) 730-7289
> >Personal Email: [EMAIL PROTECTED]
> >Personal URL: http://www.warrick.net 
> >Business Email: [EMAIL PROTECTED]
> >Business URL: http://www.fusioneers.com
> >ICQ: 346566
> >--
> >
> >
> >> -Original Message-
> >> From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
> >> Sent: Tuesday, November 07, 2000 5:40 AM
> >> To: CF-Talk
> >> Subject: Is Cold Fusion a Typed Language?
> >> 
> >> 
> >> 
> >>   I've heard in quite a few places that ColdFusion is a typed language?
> >> However, it acts as an untyped language.  Can anyone verify 
> for me which 
> >> one is actually true?
> >>   
> >>   You don't declare variables a type when you create them, and you 
> >> can typically change a variable from a string to an integer without 
> >> a second thought.  I was told that ColdFusion handles all data 
> >> conversion internally to take the burden off the user, but for 
> >> efficiency's sake, it's best not to switch the type of a variable if 
> >> you can avoid it.
> >> 
> >>   And if Cold Fusion is a typed language, what are the simple types? 
> >> The standard string, integer, float, and boolean?  
> >> 
> >> -- 
> >> Jeff Houser
> >> AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
> >> --
> >> DotComIt, LLC
> >> Computer Consultant specializing in database driven web data
> >> Lotus Notes/Domino, Cold Fusion
> >> --
> >> Half of the Alternative Folk Acoustic Duo called Far Cry Fly 
> >> http://www.farcryfly.com
> >> http://www.mp3.com/FarCryFly
> >> --
> >> Does Everyone Think I'm a Cynical?
> >> --
> >> --
> >> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >&g

strange SQL error code

[Warrick, Mark]

Anyone ever seen this one?

ODBC Error Code = 01004 (Data truncated)
[Microsoft][ODBC SQL Server Driver]Fractional truncation

On that note, does anyone have a list of Microsoft SQL Error Codes?

Please copy me with your reply.

Thanks.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Is Cold Fusion a Typed Language?

[Warrick, Mark]

For the sake of us non-programmers could you explain what "typed language" means?

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 5:40 AM
> To: CF-Talk
> Subject: Is Cold Fusion a Typed Language?
> 
> 
> 
>   I've heard in quite a few places that ColdFusion is a typed language?
> However, it acts as an untyped language.  Can anyone verify for me which 
> one is actually true?
>   
>   You don't declare variables a type when you create them, and you 
> can typically change a variable from a string to an integer without 
> a second thought.  I was told that ColdFusion handles all data 
> conversion internally to take the burden off the user, but for 
> efficiency's sake, it's best not to switch the type of a variable if 
> you can avoid it.
> 
>   And if Cold Fusion is a typed language, what are the simple types? 
> The standard string, integer, float, and boolean?  
> 
> -- 
> Jeff Houser
> AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
> --
> DotComIt, LLC
> Computer Consultant specializing in database driven web data
> Lotus Notes/Domino, Cold Fusion
> --
> Half of the Alternative Folk Acoustic Duo called Far Cry Fly 
> http://www.farcryfly.com
> http://www.mp3.com/FarCryFly
> --
> Does Everyone Think I'm a Cynical?
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: generating random passwords for a db field

[Warrick, Mark]

Amazing!  We must have been reading each other's minds when we both individually wrote 
that random password code.  (or perhaps this isn't you code?)  Here's my version:
























PASSWORD: #password#


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: AustralianAccommodation.com Pty. Ltd.
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 07, 2000 12:18 AM
> To: CF-Talk
> Subject: Re: generating random passwords for a db field
> 
> 
> i have a random password generating system on my website for when members
> join the cf code that achieves this is as follows i hope this is of some
> help
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> - Original Message -
> From: "David Cummins" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, November 07, 2000 3:25 PM
> Subject: Re: generating random passwords for a db field
> 
> 
> I think the issue is that he's hoping he can do it entirely in SQL, using
> random
> functions in SQL. I believe I had a similar problem, i.e. that SQL only
> generated the random number once, not once for each row. Perhaps
> optimisation
> gone awry?
> 
> You could do it in any of the ways that were suggested, but 
> you're sending a
> lot
> of individual commands to the SQL engine if you want to generate passwords
> for a
> large number of people.
> 
> David Cummins
> 
> Steve Reich wrote:
> >
> > A custom tag seems to be the easy answer, but to solve the 
> problem of why
> > you are getting the same random number with RandRange seems to be your
> > issue. You need to use the Randomize function to generate a random seed
> > value along with RandRange to generate your random numbers. You can find
> > more information and examples in the CFSTU help file...
> >
> > HTH,
> > Steve
> >
> > "Shane Witbeck" <[EMAIL PROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > > What is the BEST way to generate random passwords to populate an
> existing
> > field in a db. I tried using the RandRange(1, 1) function to do this
> but
> > wound up generating the same random number for every record instead of a
> > different random number for every record.
> > >
> > > The passwords generated do not nec. have to be a number, it could be
> > alphanumeric.
> > >
> > > TIA
> > >
> > > Shane Witbeck
> >
> > 
> --
> > --
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
> send
> > a message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> --
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a
> message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Potential problems with "FREE" Server

[Warrick, Mark]

OK licensing issues aside, I think what you are asking for is a comparison sheet of 
the features between CF Express and the pay for version CF Pro or Enteprise.

I'm sure Allaire would be happy to provide that information if you call them and 
explain your situation.

In the mean time though, you can read the release notes and data sheets for each 
product side by side.

For CF Express:
http://www.allaire.com/handlers/index.cfm?ID=13700
http://www.allaire.com/handlers/index.cfm?id=17776&method=full

CF Pro:
http://www.allaire.com/handlers/index.cfm?ID=13456&Method=Full&Title=ColdFusion%204%2E5%20Overview&Cache=False

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Peter Alexandrou [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 06, 2000 11:21 PM
> To: CF-Talk
> Subject: RE: Potential problems with "FREE" Server
> 
> 
> You're on the wrong track here.  The ISP will be using the freely 
> available
> Cold Fusion Express server.  I am not too sure if the Express 
> version can be
> used commercially though.
> 
> > -Original Message-
> > From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, 7 November 2000 14:44
> > To: CF-Talk
> > Subject: RE: Potential problems with "FREE" Server
> >
> >
> > Gee let's think about this for a second.  LICENSING ISSUES?
> > Your ISP cannot legally use "free" software longer than the
> > evaluation period.  And I really don't think Allaire would be
> > too happy to know that their eval copies are being used for a
> > FOR PROFIT server.
> >
> > You'll have to reinstall ColdFusion every time the eval copy
> > runs out.  You'll probably lose all the mappings and CF
> > server settings in the process each time you do that.
> >
> > Why is switching hosting companies not an option?
> >
> > ---mark
> >
> > --
> > Mark Warrick
> > Phone: (714) 547-5386
> > Efax.com Fax: (801) 730-7289
> > Personal Email: [EMAIL PROTECTED]
> > Personal URL: http://www.warrick.net
> > Business Email: [EMAIL PROTECTED]
> > Business URL: http://www.fusioneers.com
> > ICQ: 346566
> > --
> >
> >
> > > -Original Message-
> > > From: Josh R [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, November 06, 2000 2:48 PM
> > > To: CF-Talk
> > > Subject: Potential problems with "FREE" Server
> > >
> > >
> > > I need some ammo here.
> > >
> > > I'm trying to convince our hoster to get something besides
> > the "free" cf
> > > server. (Switching hosters is not an option, unfortunately,
> > so I have to
> > > fight with them.)
> > >
> > > What potential problems can we expect if we run a site on the
> > > free server as
> > > opposed to the Pro server?
> > >
> > > I already know about the cfmail. (They want me to use FormMail.)
> > >
> > > What other problems should I bring up for reasons to
> > upgrade the server?
> > >
> > >
> > __
> > ___
> > > Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com.
> > >
> > > Share information about yourself, create your own public profile at
> > > http://profiles.msn.com.
> > >
> > > --
> > > --
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> > > or send a message with 'unsubscribe' in the body to
> > > [EMAIL PROTECTED]
> >
> > --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Potential problems with "FREE" Server

[Warrick, Mark]

Gee let's think about this for a second.  LICENSING ISSUES?  Your ISP cannot legally 
use "free" software longer than the evaluation period.  And I really don't think 
Allaire would be too happy to know that their eval copies are being used for a FOR 
PROFIT server.

You'll have to reinstall ColdFusion every time the eval copy runs out.  You'll 
probably lose all the mappings and CF server settings in the process each time you do 
that.

Why is switching hosting companies not an option?

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Josh R [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 06, 2000 2:48 PM
> To: CF-Talk
> Subject: Potential problems with "FREE" Server
> 
> 
> I need some ammo here.
> 
> I'm trying to convince our hoster to get something besides the "free" cf 
> server. (Switching hosters is not an option, unfortunately, so I have to 
> fight with them.)
> 
> What potential problems can we expect if we run a site on the 
> free server as 
> opposed to the Pro server?
> 
> I already know about the cfmail. (They want me to use FormMail.)
> 
> What other problems should I bring up for reasons to upgrade the server?
> 
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> 
> Share information about yourself, create your own public profile at 
> http://profiles.msn.com.
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: fusebox

[Warrick, Mark]

I use it regularly and have been for the past year and a half.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 03, 2000 12:53 PM
> To: CF-Talk
> Subject: fusebox
> 
> 
> Is anyone out there using the fusebox methodology? 
> 
> I have recently started this position here and I am the Cold 
> Fusion lead and
> I was toying with the idea of recommending that we use the Fusebox method
> for the complete REdeployment of our corporate Intranet.
> 
> 
> any feedback is well appreciated.
> 
> chris.alvarado
> cold.fusion - developer
> [phone] 512.794.6563
> [email] [EMAIL PROTECTED]
> [web] http://www.tmanage.com
> 
> 
> Privileged/Confidential Information may be contained in this 
> message. It is
> not for use or disclosure outside TManage without a written proprietary
> agreement.  If you are not the addressee indicated in this 
> message, or agent
> responsible for delivery, you may not copy or deliver this message to
> anyone.  Please notify the sender as soon as possible and immediately
> destroy this message and its attachments entirely.
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Hmm..Calculate Elapsed Time

[Warrick, Mark]

I would use a date/time field in the database.  I would use CreateODBCDateTime(Now()) 
for date/time stamps.  And I would use DateDiff for time comparisons.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Willy Ray [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 25, 2000 8:42 AM
> To: CF-Talk
> Subject: Hmm..Calculate Elapsed Time
> 
> 
> 
>I'm timestamping logins and logouts, I want to be able to 
> calculate the time elapsed between the two.  My question is, what 
> format should I be writing these timestamps in, and I'm hoping 
> that there's a function I can use that is smart enough to just 
> subtract time values?  Thoughts?
> 
> Willy
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Error Number 1450 (Win NT)

[Warrick, Mark]

Dump all of your log files.  Optimize your databases.  Scandisk your hard drives.  
Take a look into Allaire's documentation on their site about performance tuning.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Randy Adkins [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 25, 2000 6:54 AM
> To: CF-Talk
> Subject: RE: Error Number 1450 (Win NT)
> 
> 
> 1450
> ERROR_NO_SYSTEM_RESOURCES
> Insufficient system resources exist to complete the requested service.
> 
> 
> Something seems to be running that is drawing all the
> CPU memory thus without the available memoery CF shuts down.
> 
> Try to see what is running to drawn the memory.
> 
> Sorry just a place to start looking.
> 
> -Original Message-
> From: Joshua Miller [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 26, 2000 9:33 AM
> To: CF-Talk
> Subject: Error Number 1450 (Win NT)
> 
> 
> This is a multi-part message in MIME format.
> 
> --=_NextPart_000_0015_01C03F2F.B61ADB00
> Content-Type: multipart/alternative;
>   boundary="=_NextPart_001_0016_01C03F2F.B61ADB00"
> 
> 
> --=_NextPart_001_0016_01C03F2F.B61ADB00
> Content-Type: text/plain;
>   charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
> 
> Hello all  got a new error today and am baffled. I have an application
> that allows a user to update a small amount of text from a form. However,
> for the past 2 days, it's been returning the following error:
> 
> Error writing data from web server to the Cold Fusion Application Server
> 
> Windows NT Error number 1450 occurred.
> 
> The application has worked fine for 3 months without errors and nothing is
> different on the server at all  anyone know the root of this? Or even
> encountered it before?
> 
> Any help appreciated.
> 
> Joshua Miller
> Web Development
> Eagle Technologies Group, Inc.
> Business Solutions for the Next Generation
> www.eagletgi.com
> [EMAIL PROTECTED]
> 
> 
> --=_NextPart_001_0016_01C03F2F.B61ADB00
> Content-Type: text/html;
>   charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
> 
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> Hello =
> all  got a=20
> new error today and am baffled. I have an application that allows a user =
> to=20
> update a small amount of text from a form. However, for the past 2 days, =
> it's=20
> been returning the following error:
>  class=3D140102913-26102000> 
> Error =
> writing data=20
> from web server to the Cold Fusion Application =
> Server
>  class=3D140102913-26102000> 
>  class=3D140102913-26102000>Windows NT Error=20
> number 1450 occurred.
>  class=3D140102913-26102000> 
> The =
> application has=20
> worked fine for 3 months without errors and nothing is different on the =
> server=20
> at all  anyone know the root of this? Or even encountered it=20
> before?
>  class=3D140102913-26102000> 
> Any =
> help=20
> appreciated.
>  
> Joshua MillerWeb =
> Development
> Eagle Technologies Group, =
> Inc.
> Business Solutions for the Next=20
> Generation
>  href=3D"http://www.eagletgi.com/">www.eagletgi.com
>  href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED] NT>
>  
> 
> --=_NextPart_001_0016_01C03F2F.B61ADB00--
> 
> --=_NextPart_000_0015_01C03F2F.B61ADB00
> Content-Type: text/x-vcard;
>   name="Joshua Miller.vcf"
> Content-Transfer-Encoding: quoted-printable
> Content-Disposition: attachment;
>   filename="Joshua Miller.vcf"
> 
> BEGIN:VCARD
> VERSION:2.1
> N:Miller;Joshua
> FN:Joshua Miller
> ORG:Eagle Technologies Group, Inc.;Web Development
> TITLE:Web Developer
> NOTE;ENCODING=3DQUOTED-PRINTABLE:Joshua Miller=3D0D=3D0AWeb Site =
> Development=3D0D=3D0AEagle Technologies Group, Inc.=3D
> =3D0D=3D0ABusiness Solutions for the Next =
> Generation=3D0D=3D0Ahttp://www.eagletgi.co=3D
> [EMAIL PROTECTED]=3D0D=3D0A=3D0D=3D0A =3D0D=3D0A=20
> TEL;WORK;VOICE:(304) 456-4942
> TEL;HOME;VOICE:(304) 456-4942
> ADR;WORK:;Clarksburg, WV;HC 63 Box 52c;Arbovale;WV;24915;United States =
> of America
> LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:Clarksburg, WV=3D0D=3D0AHC 63 Box =
> 52c=3D0D=3D0AArbovale, WV 24915=3D0D=3D0AUnited States=3D
>  of America
> URL:
> URL:http://www.eagletgi.com
> ROLE:Web Application Developer
> BDAY:2826
> EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
> REV:20001005T135238Z
> END:VCARD
> 
> --=_NextPart_000_0015_01C03F2F.B61ADB00--
> 
> --
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a
> message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 
> 
> --

RE: Slightly OT: Cable Modem and TZO

[Warrick, Mark]

Hi Debbie,

I'm also an @Home user.  @Home users are not allowed to host web sites - not even if 
you have a business class account.  Besides that, you don't want to host a web site on 
your server at home because the bandwidth is throttled at 128K on the uploads.  So if 
you had any more than a few users on the site at a time, it would slow down 
considerably.

Also, @Home does not guarantee that the IP address you have today will be good 
tomorrow.  In fact they discourage the user of static IPs for that very reason.  It 
doesn't mean you cannot map a domain name to that IP (you can).  It just means that 
you'll have to contact your ISP who hosts your DNS entries every time the IP changes.  
Now on the good side of this note, in the whole time I've been a user of @home, (about 
18 months) the only time my IP changed was when I moved from one house to another.

Now, this doesn't mean you cannot use your server at home for demos.  You most 
certainly can.  And although the people at @home specifically banned this type of 
usage, they're not out to get you.  They don't have the time or manpower to police all 
the ports of every machine.  They will only terminate your service if you abuse it - 
for example by hosting a web site at home.

And sorry, I've never heard of TZO.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Debbie McDaniel [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 24, 2000 11:32 AM
> To: CF-Talk
> Subject: Slightly OT: Cable Modem and TZO
> 
> 
> Hi everyone,
> 
> I am currently subscribed as a @Home (cable modem) user. I would like to
> host my own personal CF website (.com) on my own server. Has anyone ever
> heard of TZO? Is anyone hosting their own server using @Home (with or
> without TZO)?
> 
> Thanks,
> 
> Deb
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: An Idea about access and paragraphs

[Warrick, Mark]

Try this when outputting data which you feel should contain paragraph breaks:


#Replace(message_body, "#CHR(10)#", "", "ALL")#

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Mark Smeets [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 23, 2000 10:23 AM
> To: CF-Talk
> Subject: An Idea about access and paragraphs
> 
> 
> Hi everyone,
> 
> So, here's my idea. Access cannot literally store paragraphs 
> however you can 
> always put in  at the start of each paragraph/line and achieve the the 
> paragraphs. The drawback to this is that if it is left up to the regular 
> user, they'll probably mess it up.
> 
> So, this is the idea. Is there a way to detect a paragraph break, 
> then when 
> you submit the page, the paragraph break is detected, and then 
> replaced with 
> a  tag. Therefor all the user has to do, is put in a normal paragraph.
> 
> Mark Smeets/stranger0/ICQ #1062196
> 
> "Mr. West, not every situation requires your patented approach of shoot 
> first, shoot later, shoot some more and then when everybody's dead try to 
> ask a question or two" - Wild Wild West
> 
> Official Splitting Adam Homepage
> http://www.splittingadam.com/
> 
> Over the Wall Productions and Web Designs
> http://www.solarcourt.com/
> 
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
> 
> Share information about yourself, create your own public profile at 
> http://profiles.msn.com.
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: CF in permanent infinite restart loop

[Warrick, Mark]

Sounds like you've got a bad script on the server somewhere which is causing an 
infinite loop and locking up the server.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Chris Norloff [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 23, 2000 10:14 AM
> To: CF-Talk
> Subject: CF in permanent infinite restart loop
> 
> 
> Somehow our CF 4.01 on Solaris 2.6 had gotten caught in an 
> infinite loop of restarts.  About every ten seconds it restarts, 
> and constantly refuses all cfm service.
> 
> I've tried stopping/starting CF, iPlanet webserver, and the Unix 
> computer.  I've tried Allaire's recomendation of "stop -force", 
> then delete ServicePid and ServiceRunning (KB 11501) - but that 
> hasn't worked.
> 
> The start script is okay (replaced with a backup) and the 
> odbc.ini file is okay.  No templates can run because the server 
> is too busy constantly restarting itself - so it's not a template problem.
> 
> Any ideas out there?
> 
> thanks,
> Chris Norloff
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: how to prevent link from using IE window

[Warrick, Mark]

Dont use mailto.  Use a form instead.   That way, you won't be launching any other 
programs.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Christopher P. Maher [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, October 22, 2000 4:45 PM
> To: CF-Talk
> Subject: how to prevent link from using IE window
> 
> 
> I have a CF application that uses various statements to prevent browser
> caching. This works well except when a user clicks on a link in, say, an
> e-mail. Then that link opens in the instance of IE my application 
> is using.
> Because of the browser anti-caching when the user hits the back button to
> return to my page, they are told that the page has expired. 
> Refresh and they
> loose their work.
> 
> Is there some way to prevent this from happening (short of making Netscape
> the default browser)? The only solution that is practical would 
> be something
> I can put into the HTML. I cannot configure user computers.
> 
> Basically I want only MY application to run in that particular instance of
> IE. Hope that makes sense.
> 
> Thanks
> 
> ---
> Christopher P. Maher
> mailto:[EMAIL PROTECTED]
> Maher Associates, Inc.
> Actuarial and Computer Consulting
> http://www.maherassociates.com
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Fileexists

[Warrick, Mark]

Check the developer's gallery at Allaire for a tag called CFX_HTTP.  It'll do the job 
and won't hang.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: W Luke [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, October 21, 2000 3:44 AM
> To: CF-Talk
> Subject: Fileexists
> 
> 
> Hi,
> 
> I want to check if a remote file exists on a server.  At the 
> moment I'm just
> using  
>  url="http://193.237.194.136/online.gif" name="getfile" port="80"
> timeout="10">
> 
> Inside a .  But if it can't connect to the server, it just hangs -
> any ideas anyone?
> 
> Thanks
> 
> Will
> 
> --
> Coming soon: http://www.LocalBounty.com
> Local Classified Advertising for the UK
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: fusebox style: too much disk access?

[Warrick, Mark]

Yeah, but hey isn't it cool when you explain your methodology to a client and bad 
mouth all us anal-retentive Fuseboxers and somehow look like you totally know what 
you're doing? (I'm totally kidding, of course.)

I find that no matter what your methodology is, if someone else can easily understand 
and adopt it, then it is truely valuable because that provides added value to the 
service that we all provide.  Imagine how many times you've picked up an application 
after someone else and wished you could understand their logic.

:)

TGIF ---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Jones, Matt [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 20, 2000 3:42 PM
> To: CF-Talk
> Subject: RE: fusebox style: too much disk access?
> 
> 
> If the code is logical, organized, and well written, it shouldn't 
> matter if
> you utilize the Fusebox methodology or not, fusebox assists people with
> accomplishing these things.  If you do it without using the fusebox
> methodology, that doesn't make you wrong.  Any approach to 
> programming that
> is not logical, organized, and well written is a pain to debug, maintain,
> and update, regardless of whether it is in fusebox or not.  The 
> fact that so
> many fuseboxers take offense to non-fuseboxers and vice versa is rather
> disturbing.  We should strive to forward ourselves by not getting into nit
> picky arguments amongst ourselves about matters of style, and focus on
> helping each other with the problems that we all run into. 
> 
> -Original Message-
> From: Peter Theobald [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 20, 2000 3:33 PM
> To: CF-Talk
> Subject: RE: fusebox style: too much disk access?
> 
> 
> Since we're talking about it... I always thought that breaking up an
> application by "type of activity in the file" like dsp for display and qry
> for query didn't make sense. I want to break up my application by logical
> "object" like a user profile, an inventory item, etc..
> 
> 
> At 11:19 AM 10/20/00 -0700, Nat Papovich wrote:
> >What-evah, Dave. Fusebox kicks ass for the very implementation 
> you mention.
> >COMs can be called from a single file (using a new prefix 
> com_filename.cfm
> >if you want), then whenever you need that COM, you cfinclude that file.
> >
> >Maybe it would help us if you made a distinction between 
> application logic
> >encapsulation and business rules encapsulation. If you do both within
> >COM/EJB, then you practically don't even need CF for anything other than
> >CFOUTPUT. If however, you want application logic in COM, but still want
> >business rules in CF, then Fusebox is great. No?
> >
> >It seems to me that if you remove application and business logic from CF,
> >then a structured application architecture (like Fusebox) 
> becomes less of a
> >necessity. What kind of CF architecture do you guys use in EJB/COM-heavy
> >apps?
> >
> >Nat Papovich
> >ICQ 32676414
> >"I'm for truth no matter who tells it."
> >-Malcolm X, 1965
> >
> >
> >-Original Message-
> >From: Dave Watts [mailto:[EMAIL PROTECTED]]
> >Sent: Friday, October 20, 2000 10:12 AM
> >To: CF-Talk
> >Cc: '[EMAIL PROTECTED]'
> >Subject: RE: fusebox style: too much disk access?
> >
> >
> >> > I'm not a Fusebox fan, by any measure, 
> >> 
> >> Why not? What would need to be changed to make you a fan?
> >
> >I'd have to be working on applications where the complex logic 
> is stored in
> >CF, instead of in other application tiers. I don't want to fuel 
> another "Is
> >Fusebox good or bad" thread, but I don't think it fits well with the type
> of
> >applications that we focus on here at Fig Leaf, which typically have lots
> of
> >client-side complexity, like frames, JavaScript, Flash, etc. and 
> have lots
> >of application logic within other application tiers on the server-side,
> like
> >within stored procedures or COM/EJB.
> >
> >On the other hand, if I was working on an application with all of its
> >complexity within CF, I'd probably like Fusebox quite a bit. 
> Once you move
> >most of that complexity from CF to other tiers, though, Fusebox 
> doesn't do
> >much for you, in my opinion.
> >
> >Dave Watts, CTO, Fig Leaf Software
> >http://www.figleaf.com/
> >voice: (202) 797-5496
> >fax: (202) 797-5444
> >-
> --
> -
> >
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >Unsubscribe: 
http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
>message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>---
--

RE: Question

[Warrick, Mark]

Set the string of emails dynamically and use that variable as to="#email_string#".  
Also, output that string to the screen before you commit to going nuts trying to 
figure out what's wrong.  And have a Jolt Coke.  :)

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Les Mizzell [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 20, 2000 1:49 PM
> To: CF-Talk
> Subject:  Question
> 
> 
> Not 100% sure how to handle this...looking for ideas
> 
> I'm sending  after a client fills out a form.
> 
> There's up to 5 different email addresses that the mail might 
> have to go to,
> depending on form input.
> 
> 
> Email *ALWAYS* goes to "email1"
> Needs to go to:
> "email2" (from the form),
> "email3" (from dropdown list on form)
> "email4" (from a database)
> and "email5"(from a database)  as well.
> 
> So, the following should work:
> 
>  
> Problem is, "email2" and "email4" might not exist, while the 
> others do.  Or
> maybe "email5" doesn't exist.
> 
> If the above is the case, then you get email sent out to:
> "somebody@address1;(nothing)" which obviously isn't going to work 
> because of
> the extra added ";" with nothing after it.
> 
> 
> This is probably so simple that I'm just missing it, but I'm not 
> sure how to
> structure this so it gets sent only to addresses that exist, and 
> not to the
> others, which errors out (doesn't send mail).
> 
> That make any sense?  I'm sleep deprived..
> 
> 
> Les Mizzell
> ***
> The main reason Santa is so jolly is
> because he knows where all the bad girls live.
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: CFCONTENT download name

[Warrick, Mark]

That might explain the problem.  The server is running SP6.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 20, 2000 12:37 PM
> To: CF-Talk
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: CFCONTENT download name
> 
> 
> > > > I'm trying to create an MS Word doc based upon a query and 
> > > > information entered on a form preceeding this report 
> > > > processing template.
> > > >
> > > > In the processing template I've tried using:
> > > > 
> > > >
> > > > The query runs, but all the information I entered in the form 
> > > > preceeding it is lost.
> > > > 
> > > > I've tried using:
> > > > 
> > > > 
> > > > This works. The query data and all the info from the preceeding 
> > > > form are there, and a download prompt comes up in the browser.
> > > > 
> > > > HOWEVER, the initial filename in the download prompt is the name 
> > > > of the CFML template which processed it (reports.cfm).
> > > >
> > > > I want the name of the file that shows up in that download 
> > > > prompt to be report.doc so that the user won't have to think 
> > > > about naming the file correctly when they select a place to save 
> > > >it.
> ...
> > > Use this before your CFCONTENT tag:
> > > 
> > > 
> ...
> > Sorry. This doesn't work. The form variables are lost.
> 
> It should work, as should using a "fake" URL on a pre-SP6 server. 
> There are
> examples of both at:
> 
> http://www.figleaf.com/demo/mimetest/
> 
> If you can't get it to work either way, you might post the code.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Instructor seeking book suggestions

[Warrick, Mark]

How about, "How to get a job interview at McDonald's after the ASP market drops out 
due to the break up of Microsoft"?

lol - I'm totally kidding.

How about this one:
Asp Developer's Guide (The Application Development) 

http://www.amazon.com/exec/obidos/ASIN/0072122943/qid=972069509/sr=1-1/104-6914248-2208751

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Lea Anna Davis [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 20, 2000 11:55 AM
> To: CF-Talk
> Subject: Instructor seeking book suggestions
> 
> 
> I teach a Webmaster job training program that includes JavaScript
> (writing code not just cut and pasting) and fairly intensive ColdFusion
> training. I want to also introduce my students (don't shoot me) to ASP
> in order to maximize their opportunities for employment. Most of my
> students do not have any programming experience beyond what I have
> taught them. Does anyone in this fine community have a suggestion for a
> great, understandable ASP book?
> 
> Thanks,
> Lea Anna Davis
> Lively Technical Center
> www.livelytech.com
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: CFCONTENT download name

[Warrick, Mark]

Sorry.  This doesn't work.  The form variables lost.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: tom muck [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 20, 2000 11:36 AM
> To: CF-Talk
> Cc: [EMAIL PROTECTED]
> Subject: Re: CFCONTENT download name
> 
> 
> Use this before your CFCONTENT tag:
> 
> 
> 
> tom
> 
> 
> - Original Message -
> From: "Warrick, Mark" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, October 20, 2000 2:32 PM
> Subject: CFCONTENT download name
> 
> 
> I'm trying to create an MS Word doc based upon a query and 
> information entered
> on a form preceeding this report processing template.
> 
> In the processing template I've tried using:
> 
> 
> The query runs, but all the information I entered in the form 
> preceeding it is
> lost.
> 
> I've tried using:
> 
> 
> This works. The query data and all the info from the preceeding 
> form are there,
> and a download prompt comes up in the browser.
> 
> HOWEVER, the initial filename in the download prompt is the name 
> of the CFML
> template which processed it (reports.cfm).
> 
> I want the name of the file that shows up in that download prompt to be
> report.doc so that the user won't have to think about about 
> naming the file
> correctly when they select a place to save it.
> 
> I've tried the technique suggested by Borkman Lee:
> http://servername/cfdocs/index.cfm/xyz.doc?fuseaction=showWordDoc
> 
> It doesn't work on my server.
> 
> Does anyone else know how to do this?
> 
> Please copy me on your reply as the list sometimes take a few 
> hours to send
> messages to me.
> 
> Thanks!
> 
> OH, and by the way - the first person to answer this correctly is 
> going to get 2
> free movie tickets.
> 
> --
> Mark Warrick
> Phone: (714) 547-5386
> Efax.com Fax: (801) 730-7289
> Personal Email: [EMAIL PROTECTED]
> Personal URL: http://www.warrick.net
> Business Email: [EMAIL PROTECTED]
> Business URL: http://www.fusioneers.com
> ICQ: 346566
> --
> 
> --
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a
> message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: CFCONTENT download name

[Warrick, Mark]

I'm sorry.  This doesn't work.  The same problem happens - I loose all the data from 
the previous form.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: tom muck [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 20, 2000 11:36 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: CFCONTENT download name
> 
> 
> Use this before your CFCONTENT tag:
> 
> 
> 
> tom
> 
> 
> - Original Message -
> From: "Warrick, Mark" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, October 20, 2000 2:32 PM
> Subject: CFCONTENT download name
> 
> 
> I'm trying to create an MS Word doc based upon a query and 
> information entered
> on a form preceeding this report processing template.
> 
> In the processing template I've tried using:
> 
> 
> The query runs, but all the information I entered in the form 
> preceeding it is
> lost.
> 
> I've tried using:
> 
> 
> This works. The query data and all the info from the preceeding 
> form are there,
> and a download prompt comes up in the browser.
> 
> HOWEVER, the initial filename in the download prompt is the name 
> of the CFML
> template which processed it (reports.cfm).
> 
> I want the name of the file that shows up in that download prompt to be
> report.doc so that the user won't have to think about about 
> naming the file
> correctly when they select a place to save it.
> 
> I've tried the technique suggested by Borkman Lee:
> http://servername/cfdocs/index.cfm/xyz.doc?fuseaction=showWordDoc
> 
> It doesn't work on my server.
> 
> Does anyone else know how to do this?
> 
> Please copy me on your reply as the list sometimes take a few 
> hours to send
> messages to me.
> 
> Thanks!
> 
> OH, and by the way - the first person to answer this correctly is 
> going to get 2
> free movie tickets.
> 
> --
> Mark Warrick
> Phone: (714) 547-5386
> Efax.com Fax: (801) 730-7289
> Personal Email: [EMAIL PROTECTED]
> Personal URL: http://www.warrick.net
> Business Email: [EMAIL PROTECTED]
> Business URL: http://www.fusioneers.com
> ICQ: 346566
> --
> 
> --
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a
> message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

CFCONTENT download name

[Warrick, Mark]

I'm trying to create an MS Word doc based upon a query and information entered on a 
form preceeding this report processing template.

In the processing template I've tried using:


The query runs, but all the information I entered in the form preceeding it is lost.

I've tried using:


This works. The query data and all the info from the preceeding form are there, and a 
download prompt comes up in the browser.

HOWEVER, the initial filename in the download prompt is the name of the CFML template 
which processed it (reports.cfm).

I want the name of the file that shows up in that download prompt to be report.doc so 
that the user won't have to think about about naming the file correctly when they 
select a place to save it.

I've tried the technique suggested by Borkman Lee:
http://servername/cfdocs/index.cfm/xyz.doc?fuseaction=showWordDoc

It doesn't work on my server.

Does anyone else know how to do this? 

Please copy me on your reply as the list sometimes take a few hours to send messages 
to me.

Thanks!

OH, and by the way - the first person to answer this correctly is going to get 2 free 
movie tickets.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Editable scrolling text box

[Warrick, Mark]

Use standard HTML: 

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Rosa, Issac [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 20, 2000 10:02 AM
> To: CF-Talk
> Subject: Editable scrolling text box
> 
> 
> Is there a way to create a scrolling input box or specify the 
> height of the
> box and wrap the text?  I have tried using , but the text
> string does not wrap.
> 
> If you have any questions or concerns, please feel free to call me at
> 407-514-5021.
> 
> Thank you,
> 
> > Issac Rosa
> > 
> > IT - National Sales & Marketing
> > OLAP Specialist Team Leader
> > Ofc: 407-514-5021
> > Cell: 407-342-0644
> > Fax: 407-514-5988
> > [EMAIL PROTECTED]
> > 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Output to File, a lot of white space

[Warrick, Mark]

Start all files with:

put cf code here, surround HTML outputs with cfoutput

end all files with:


That will eliminate ALL the extra white space that was not generated as you wanted it 
to be, and it's backwards-compatible with version 4.01.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Paul Sizemore [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 20, 2000 9:15 AM
> To: CF-Talk
> Subject: Output to File, a lot of white space
> 
> 
> I'm writing a file to disk using the Scheduled Task's "Output to file"
> feature. And, when the file is generated on disk it has a lot of extra
> carriage returns, tabs, and spaces. The amount of extra "white" 
> space looks
> a lot like the extra "white" space in my code.  In fact I deleted an extra
> carriage return in my Application.cfm, and a carriage return in 
> the file was
> deleted. 
> I have selected  "Suppress whitespace by default " on the server, used
> , and 
> none of them
> work (I do notice a difference with suppressing the white space). 
> 
> Paul Sizemore
> 
> Finish Line
> 3308 N Mitthoeffer Rd
> Indianapolis, IN 46235
> W: 317-899-1022 ext 3516
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: fusebox style: too much disk access?

[Warrick, Mark]

Wouldn't that be the same concept as 1,000,000 people hitting Yahoo's homepage and 
search script every day?

I think what it comes down to is that a properly built application on a server capable 
of handling those kind of requests is not going to have any problems with the Fusebox 
methodology of coding.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Donald Sparks [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 20, 2000 8:45 AM
> To: CF-Talk
> Subject: Re: fusebox style: too much disk access?
> 
> 
> Okay, I'm not concerned with cfincludes and those related issues. 
> I am concerned with the handling of multiple requests on the 
> index or "fusebox" page (i.e.) a single page. For example say I 
> have 1,000 users on my site. If they are all accessing index.cfm 
> as opposed to 20 to 30 different .cfm pages. How does this affect 
> caching and does it produce any other problems.
> 
> Thank you,
> Don Sparks
> not quite at the 32nd chamber of fusebox.
> 
> - Original Message -
> From: "Steve Nelson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, October 19, 2000 3:23 PM
> Subject: Re: fusebox style: too much disk access?
> 
> 
> > Don't be confused by what Nat is saying, a single "fuseaction" in a
> > Fusebox application may only hit 5-8 files.  It's really not that big a
> > deal.
> >
> > Steve
> >
> > Nat Papovich wrote:
> > >
> > > A simple test of included files suggests that CF's internal 
> file access
> > > functions were pratically built with a cfinclude-heavy architecture in
> mind.
> > > Accessing dozens of files for a single page request is very quick. Out
> of
> > > 100 included files, you might notice a 10 ms increase than if you had
> all
> > > the code on the same page. Now that 10 ms performance hit gives you a
> > > scalable, intelligible architecture. If you have any experience with
> really
> > > large sites, you know that the only safe way to scale a project is to
> break
> > > it into small "minute modules".
> > >
> > > All this is without mentioning CF's ability to cache templates
> > > automatically. Accessing a file from RAM is basically instantaneous.
> > >
> > > If code scalability, readability, longevity, and understandability is
> > > important now or will be important later, you need to adopt a 
> structured
> > > application methodology like Fusebox.
> > >
> > > Nat Papovich
> > > ICQ 32676414
> > > "I'm for truth no matter who tells it."
> > > -Malcolm X, 1965
> > >
> > > -Original Message-
> > > From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, October 19, 2000 1:00 PM
> > > To: CF-Talk
> > > Subject: fusebox style: too much disk access?
> > >
> > > I was reading on the fusebox concept of putting minute modules into
> separate
> > > files and the question is: wouldn't that slow the site by having to
> access
> > > too many different disk files to load one page?
> > >
> > > Cyrill
> > >
> 
>  
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: fill-in-the-value question

[Warrick, Mark]

Just use standard HTML and put whatever CFIF processing you need in it.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Scott Weikert [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 19, 2000 2:13 PM
> To: CF-Talk
> Subject:  fill-in-the-value question
> 
> 
> How, pray tell... when one has several CFINPUTS that are checkboxes, named
> the same but with different numeric values... if one should have 
> a list of a
> portion of those values... does one tell a  tag to check 
> that list
> against the value of the current checkbox field, and check it 
> should it find
> a match?
> 
> Obviously one can't put a  inside a  to check and spit out
> "checked" if it finds it... any thoughts?
> 
> --Scott
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: cfhttp problems/getting system information from users i.e. cpu speed/ram

[Warrick, Mark]

You know, now that I've re-read your message, I think I understand what you're trying 
to do.

Could you send us the URL for the site you're talking about?

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-----
> From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 19, 2000 1:55 PM
> To: CF-Talk
> Subject: RE: cfhttp problems/getting system information from users i.e.
> cpu speed/ram
> 
> 
> Help me to understand how using only HTML (or ColdFusion 
> generated HTML) you could find out that information about 
> someone's system.
> 
> CFHTTP is usually used for fetching files (URLs).
> 
> --
> Mark Warrick
> Phone: (714) 547-5386
> Efax.com Fax: (801) 730-7289
> Personal Email: [EMAIL PROTECTED]
> Personal URL: http://www.warrick.net 
> Business Email: [EMAIL PROTECTED]
> Business URL: http://www.fusioneers.com
> ICQ: 346566
> --
> 
> 
> > -Original Message-
> > From: Edward Peloke [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, October 19, 2000 1:03 PM
> > To: CF-Talk
> > Subject: cfhttp problems/getting system information from users i.e. cpu
> > speed/ram
> > 
> > 
> > Hello,
> > 
> > I am having trouble using cfhttp, everytime I us it I get a connection
> > error, I have read that this is caused by the firewall, is this 
> > true?  What
> > I am trying to do is have our employees go to a website that runs 
> > a check on
> > their system, i.e. hard drive, ram, speed, etc. the website 
> saves all this
> > information into its database but we want to somehow use cf to 
> > save it into
> > ours and I thought the cfhttp tag might help...any suggestions??
> > 
> > THanks,
> > Eddie
> > 
> > 
> > --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> > or send a message with 'unsubscribe' in the body to 
> > [EMAIL PROTECTED]
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: CFPOP

[Warrick, Mark]

After reading through the CFPOP documentation, it doesn't appear that you can control 
the sort order.  I believe you can use ParseDateTime to convert the date-time value to 
something that DateFormat can work with.

IE:  DateFormat(ParseDateTime(popdate), "dd/mm/")

Hope this helps.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Kevin Queen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 19, 2000 1:35 PM
> To: CF-Talk
> Subject: CFPOP
> 
> 
> List,
> I am currently trying to create an e-mail client.  I have a couple of
> questions that I thought were easy but... First, is there a way to reverse
> the message header order, I am currently getting the oldest 
> message first, I
> would like to display the newest first.  Secondly, I would like to format
> the date down to just dd/mm/ but the dateformat function will 
> not work,
> am I going to have to trim out the extra information?
> TIA,
> Kevin Queen
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: cfhttp problems/getting system information from users i.e. cpu speed/ram

[Warrick, Mark]

Help me to understand how using only HTML (or ColdFusion generated HTML) you could 
find out that information about someone's system.

CFHTTP is usually used for fetching files (URLs).

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Edward Peloke [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 19, 2000 1:03 PM
> To: CF-Talk
> Subject: cfhttp problems/getting system information from users i.e. cpu
> speed/ram
> 
> 
> Hello,
> 
> I am having trouble using cfhttp, everytime I us it I get a connection
> error, I have read that this is caused by the firewall, is this 
> true?  What
> I am trying to do is have our employees go to a website that runs 
> a check on
> their system, i.e. hard drive, ram, speed, etc. the website saves all this
> information into its database but we want to somehow use cf to 
> save it into
> ours and I thought the cfhttp tag might help...any suggestions??
> 
> THanks,
> Eddie
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]

RE: fusebox style: too much disk access?

[Warrick, Mark]

The performance hit is nearly undetectable.  Don't worry about it.

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 19, 2000 1:00 PM
> To: CF-Talk
> Subject: fusebox style: too much disk access?
> 
> 
> I was reading on the fusebox concept of putting minute modules 
> into separate
> files and the question is: wouldn't that slow the site by having to access
> too many different disk files to load one page?
> 
> Cyrill
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with 
'unsubscribe' in the body to [EMAIL PROTECTED]