RE: Access Question

Try: SELECT* FROM messages WHERE message_date = #CreateODBCDate(attributes.datebox)# H. Howard Owens Internet Operations Coordinator www.insidevc.com [EMAIL PROTECTED] AIM: GoCatGo1956 > -Original Message- > From: Greg Luce [SMTP:[EMAIL PROTECT

When is a cookie set in the browser

When setting a cookie in a page that throws a ColdFusion error, the cookie doesn't get set in the browser. Why is that? Does the instruction to the cookie not get sent until the page is successfully parsed? Thanks -- Aidan Whitehall <[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairban

Re: Running app from server...HELP!

At 01:51 AM 10/24/2001, you wrote: >Hi, > >I've posted this before but I'm at a dead end. I have no idea how to go >about this. > >I'm listing files in a directory on my server. All files are wrapped with > What I want to happen is when a user clicks on a file I >want that file opened in an ed

Re: How to auto generate images?

Hunt around for the CFX_IMAGE tag, it might not be on the developers exchange so a google search is in order... http://www.google.com/search?q=cfx_image At 06:45 AM 10/24/2001, you wrote: >Does anyone know how to dynamically generate formatted images. > >i.e. > >1. A client fills out a web site

Server Installation Question

When setting up cf 4.5, do you have to stop the IIS service?Or does it stop the IIS service? And do you have to reboot after the installation is complete? Just wondering if anyone knows this stuff off the top of their head. Thanks, Kev ~ Kevin Mansel Senior Web Developer

RE: Checking file size before upload.

I don't thinks so. At least not with CF as standard. Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271-2671 Fax: +61-2-6271-2278 http://www.anzfa.gov.au -Original Message- From: Lon Lentz

RE: Comparing Dates Functions

This code should help you out. You can compare the dates down to the second. The function datecompare has an optional parameter (It's the precision of the comparison) The parameter can have any of the following values: sPrecise to the second nPrecise to the minute hPrecise to t

RE: Regular Expression

Michael Try REReplace( string, ".*(URL=)([^[:space:]]+).*", "\2" ) A loose translation - 1) look for any character (.) any number of times(*), followed by 2) the string "URL=", followed by 3) anything other than a space ([^[:space:]]), at least once (+) 4) Replace that whole lot with whatever

RE: Access Default values

> You can set the default value of a field in an Access table's design > view. He wanted to set default values as part of a CREATE TABLE statement. -- Aidan Whitehall <[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~

AS400 Stored Procedure without using CFSTOREDPROC?

The above stored proc works against the AS400. How can I do the same thing but without using the cfstoredproc tag? What would I put here? Thanks, ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http

Comparing Dates Functions

Hello All, I'm having difficulty comparing a date range to DateLastModified, returned from CFDirectory. I've explored most of the date functions but can't find the function and syntax to do the job. Any help would be appreciated. TIA. Have a nice day. Regards, Paige

RE: Access Question

you could try ensuring that Access reads this as a date by using ODBCDateFormat. Also check that message_date is a date field in your db. Cheers Will -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: 19 October 2001 01:45 To: CF-Talk Subject: Access Question I have

RE: WDDX question

yes, that is possible - wddx supports arrays and structures Joseph DeVore VeloxWeb Technologies -Original Message- From: JAAV [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 8:39 AM To: CF-Talk Subject: WDDX question Hello, I'm take my first glance in WDDX. I want to us

RE: problem downloading .exe file (double post)

Thanks Dave, Not sure what is going on with the list, but I sent that mail sometime on thursday. Anyway, I have zipped the files and am offering them for download like that, which makes them smaller and easier to download, obviously, and gets round the problem. Cheers Will -Original Messag

WDDX question

Hello, I'm take my first glance in WDDX. I want to use CFML2JS: may I have CFQuery to use it? I mean I have some Arrays and I need to put in (WDDX) JS format. is it possible? TIA, ~Juandres ~~ Structure your ColdFusion code with Fusebox. Get t

RE: CFHTTP Replacement

Yes, CFX_HTTP - check the tag gallery. Joseph DeVore VeloxWeb Technologies -Original Message- From: David Brooks [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 9:05 PM To: CF-Talk Subject: CFHTTP Replacement Heya all, Anyone know of a good solution, cfx tag or otherwis

Re: Checking file size before upload.

"Lon Lentz" <[EMAIL PROTECTED]> wrote in message > Is there a way to check the size of a file before the server > CFFile-Uploads it? Something like this should help you getting started: WriteOutPut("The selected file's size is greater than the " & #tmtFileSize# & "bytes maximun size

RE: Not Working With MSSQL

You need to use CF_SQL_TIMESTAMP instead of CF_SQL_DATE. > -Original Message- > From: Dave Babbitt [mailto:[EMAIL PROTECTED]] > Sent: 22 October 2001 16:21 > To: CF-Talk > Subject: Not Working With MSSQL > > > Hi Guys! > > Thanx to Ian Rutherford's suggestion, I have discovered the >

CFHTTP Replacement

Heya all, Anyone know of a good solution, cfx tag or otherwise, for a replacement for the CFHTTP tag? I consistently have had problems with CFAS 4.x and 5.0 servers. Thanks for the help! David Brooks ~~ Get the mailserver that powers this list a

RE: Updating an XML file so Flash can use it

You could use SOXML, it provides ColdFusion programmers with an easy to use interface for integration of XML with CF. This custom tag is open-source (of course), free, and action based. These actions include: • XML2CF (Converts a XML document into a complex CF structure) • XML2DOM (Loads the XM

RE: Not Working With MSSQL

This is one of the most stupidest issues with mdac... You actually need to use cfsqltype="cf_sql_timestamp" for SQL Servers. -Original Message- From: Dave Babbitt [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 8:21 AM To: CF-Talk Subject: Not Working With MSSQL Hi Guys!

RE: CF and Excel

www.cfcomet.com has some really good examples of using Excel as a datasource. -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Sunday, October 21, 2001 1:19 PM To: CF-Talk Subject: Re: CF and Excel fairly low tech approach but I have set up an access database that

Updating an XML file so Flash can use it

Hi all, I have a client that needs CF to update an XML file that flash reads to display info. I was wondering if anyone has any tips, tags, or advice to help get me started on my project of updating his existing XML file. Also, I know that CF supports WDDX, which is a dialect of XML, I was wond

RE: Images in database

lewis sellers wrote a tag to read and write binary data give it a look... -paris -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 16:15 To: CF-Talk Subject: Images in database After searching the archives. I know no one likes the ide

RE: ASP access to CF client vars

This is the WDDX SDK you will need in order to familiarize yourself with WDDX for ASP and CFML. http://www.openwddx.org/downloads/sdk/10a/win/wddx_sdk_10a.zip Joseph DeVore VeloxWeb Technologies -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, Octob

RE: ASP access to CF client vars

IMO the best way to do this is with WDDX! http://www.openwddx.org/ Joseph DeVore VeloxWeb Technologies -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 2:19 PM To: CF-Talk Subject: ASP access to CF client vars Has anybody ever de

RE: Submitting forms without showing the action pages

Tom, use the application scope and cfform. I will email you examples off list. Tony Gruen sfnetworks -Original Message- From: Tom Jacobs [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 8:01 PM To: CF-Talk Subject: Submitting forms without showing the action pages This is pro

Re: HOw to auto generate images?

Hey folks, so far I found these two ASP solutions, however no tag in Cold Fusion. Surely that can't be right, there must be something in the wonderful world of Cold Fusion that allows us to do the same thing. Say it ain't so http://www.serverobjects.com/products.htm#aspimage http://www.web

Re: Next Page - Previous Page

If you have access to Ben Forta's CF book (4th ed.), you'll find a few very good chapters on the subject... keywords - session vars, structures, case statements (or if blocks). -Mike "Carlisle, Eric" wrote: > Anyone have any links to sites explaining how to make a report that spans > several pa

ASP access to CF client vars

Has anybody ever developed a way for an ASP page to access and use ColdFusion client variables? I would assume that it would be possible since they are managed through cookies and stored in a database. I work in a development environment that uses both languages (tried to get them to drop ASPs,

FW: setting cf admin password - 2 questions

Yes, if you have CFREGISTRY enabled you can do a lot! This code works for all versions of CF server (I've tested 4.5,5.0) To get the password: #cfusion_decrypt(AdminPassword, password_key)# -- To set the password: #password#(encrypted pa

Re: Cold Fusion and Dynamic PDF Files

http://partners.adobe.com/asn/developer/acrosdk/forms.html www.pdflib.com www.fastio.com www.activePDF.com Ive got some rudimentary examples with the Adobe FDF Toolkit for ActiveX, and CF. Not sure that s the way you want to go. Stephen M. Aylor Aylor Insurance Agency, Inc. Specialized Insu

RE: Checking file size before upload.

Javascript. Joseph DeVore VeloxWeb Technologies -Original Message- From: Lon Lentz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 1:07 PM To: CF-Talk Subject: Checking file size before upload. Is there a way to check the size of a file before the server CFFile-Uploads it

RE: Running app from server...HELP!

Write yourself a plug-in that when loaded will redirect text files from the browser to UltraEdit. Because you are not going to get the browser to hand them off unless its preferences are changed. -Original Message- From: phumes1 [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 8

CF_uicalendar

When the control is in the INLINE mode, i.e. Popup= "NO".. It only registers a date being selected when the user DOUBLECLICKS on a particular date. Why is this? -Gel ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: htt

Re: Access Question

USE #CreateODBCDate(attributes.datebox)# - Original Message - From: "Bryan Love" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, October 22, 2001 4:40 PM Subject: RE: Access Question > It's doing the math. It thinks 10/18/2001 is 10 divided by 18 divided by > 2001.

RE: How to auto generate images?

You could use a PhotoScripter / Photoshop / Mac solution. Info can be found at http://www.mainevent.com/photo.html (but not info on how you would integrate CF). You would create applescript code snippets and piece them together based on the user's options. The user's form submission could gener

How to dynamically auto generate images?

Does anyone know how to dynamically generate formatted images. i.e. 1. A client fills out a web site banner name in a form and presses submit 2. That automatically generates the banner image, with formatting rules like drop shadow, etc. I know Macromedia Generator does this, but its a very heav

Datasource Disappearance

Hi folks, I'm having a bit of a situation here.. I created a new ODBC datasource (MySQL) called tts_intranet. While setting up the correct user account and password to access the database used in this datasource, I clicked on 'Verify All Connections' in the CF Administrator page.. next th

Q: CFFTP IP address

Our client's server folks would like to restrict FTP access to a given set of IP addresses. We're currently using CFFTP on a shared hosting site that posts to their server... Without requiring the host or server folks to think too hard or be responsive (something that might constitute a miracle),

JMail and Cold Fusion

Hi there, just have a question. Has anyone used JMail with Cold Fusion? I have used it with ASP but I'm not sure if the code is the same. Please let me know if you know anything :) Thanks in advance, Kamila > ~~ Your ad could be here. Monies from

RE: Percent calculation

Peter, Here's some code that might help you get what you're after: The original weight is #weight# grams The percent change is #NumberFormat(percent_change * 100, "99.9")#% The percent change reflects an increase, therefore the final weight is #NumberFormat(final_weight,"999.99")# The

See Running Requests?

Is there a way I can see what templates are running on a given cf server? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http:

cf-talk@houseoffusion.com

hi, I am querying more than one table that all contain email addresses. I am merging all of these e-mail addresses into a CFMAIL email blast of all the email addresses. I need advice on how to make sure there aren't duplicate e-mail addresses after all the e-mails are merged and the email is lo

RE: How to auto generate images?

You can use cfx_image to manipulate text and certain elements (ie. overlay images on top of another image and so on) and resave as a new image. I did a pseudo drop shadow with text before by overlaying the same text field in two different colors slighly offset. Just download and install. The do

Re: Repost: OLEDB Pathing Question

This will work in Access. I just tried it out. (ok, kinda missed the original post so this is just a guess, but here is an example of combining two Access databases in one query) http://cfhub.com/forum/index.cfm?FuseAction=Thread&TopicID=1914&Start=Last === o

Checking file size before upload.

Is there a way to check the size of a file before the server CFFile-Uploads it? Lon Lentz Applications Developer and CyberEntomolgist http://Proof-it-Online.Com - Free 15 Day Trial ~~ Your ad could be here. Monies from ads go to support these l

RE: Regular Expression

what OS? try grep URL filename | sed s/URL=//g On Tue, 23 Oct 2001, Ryan Emerle wrote: > > I'm trying to come up with a regular expression that will > > help me turn > > this: > > > > [Object] > > ID=2031 > > URL=http://www.cnn.com/ > > OtherSrvLev=0w33a > > Category=31 > > > > Into: http:/

Submitting forms without showing the action pages

This is probably simple, but I'm new to CF and HTML so it's not obvious. I am creating a questionnaire composed of a series of forms with several questions on each. After a user answers each of the questions and clicks the Submit button, I want to go directly to the next page of questions with

Learn about NEO - the next release of CF Server

http://www.macromedia.com/software/coldfusion/resources/neo/ Peter Tilbrook ColdFusion Applications Developer Australia New Zealand Food Authority Boeing House 55 Blackall Street BARTON ACT 2600 Ph: +61-2-6271-2671 Fax: +61-2-6271-2278 http://www.anzfa.gov.au *

Images in database

After searching the archives. I know no one likes the idea of images stored in databases. BUT i have a database that is already created with images inside. It is from a program called Cumulus. It really appears that CFQUERY cannot handle a MS SQL Image field. If i query the MS SQL db and

Modifying underliverable mail headers

On our intranet I have a form set up so I can take a look at messages that end up in the CFUSION/MAIL/UNDELIVR. It uses CFFILE to bring the contents of a particular message into a textarea. Then I can modify a malformed e-mail address if I can, and re-write the file to the SPOOL directory to be

RE: Access Question

Greg Try the following - should work. SELECT* FROM messages WHERE message_date = #CreateODBCDate(attributes.datebox)# one word of warning this may or may not take the time into consideration, if you test this and it still does not work correctly you'll actually have to use the be

Re: Repost: OLEDB Pathing Question

Hmm. I must be missing something. The article only talks about OLE DB using SQL Server. I've gotten this to work with machines on the same network and across the country, but not like you described it. With SQL Server, you need to have one OLEDB data source already set up in the CF administra

Re: Repost: OLEDB Pathing Question

Have you actually gotten this to work with a database on the same machine? I've been unable to make anything happen with OLEDB without first setting them up in the CF administrator. tom "Larry C. Lyons" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > Because of the HOF server pr

Escaping opening quote char to add data in the database

Help Anyone knows how to escape opening quote char to add data in the database Thanks FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Next Page - Previous Page

http://www.cfvault.com Look at the tutorials section - They have a pretty good one. Mark -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 8:18 AM To: CF-Talk Subject: Next Page - Previous Page Anyone have any links to sites explaining

OT: SQL*NET for Solaris

i am looking for the sql*net for oracle7.3 for Solaris as i need to configure the CF server to access Oracle DB, but i can't seems to find this client software from Oracle web site, where can i get it? mak wl ~~ Get the mailserver that powers this l

Fw: SQL*NET for Solaris

i am looking for the sql*net for oracle7.3 for Solaris as i need to configure the CF server to access Oracle DB, but i can't seems to find this client software from Oracle web site, where can i get it? mak wl ~~ Get the mailserver that powers thi

RE: CF 4 to CF 5 CFContent Causes Windows NT Error Number 5

> I have images on another server via a mapped drive being > served to customers via CFContent. It worked with 4.0 but > 5 causes Windows Nt Error Number 5. I'm not sure what Error 5 means, but my guess is that you had permissions set up so that either the CF 4 server ran as a non-SYSTEM user w

RE: Hiding files - cfhttp & cfcontent

> I can't see how this is possible. On my remote server, I have > the file w.cfm - eventually it will have a load of > statements, calling url.ca which will in turn load > the text file containing a WDDX packet. For now though, I'm > just working with one text file, wddx.txt. Here's how w.cf

RE: dynamically generate page content without refresh a page

> I believe you can do that utilizing frames within a fusebox > scenario. You can just as easily do that utilizing frames without using Fusebox. In fact, anything you can do in Fusebox, you can also do outside of Fusebox. In fairness to Fusebox, the reverse is also true - anything you can do out

RE: Running app from server...HELP!

> I'm listing files in a directory on my server. All files are > wrapped with What I want to happen is when > a user clicks on a file I want that file opened in an editor > on the client PC (not the server). In my case, UltraEdit. Unfortunately for you, you really can't use HTML to contro

Cold Fusion and Dynamic PDF Files

All, I'm going to be working on a dynamic PDF File generator. Has anyone on the list had any experience with generating dynamic PDF files based on some user variables? Based on some user input I need to fill in the blanks in a PDF document and present this to the user. Sincerely, Leon Ooster

JMail and Cold Fusion

Hi there, just have a question. Has anyone used JMail with Cold Fusion? I have used it with ASP but I'm not sure if the code is the same. Please let me know if you know anything :) Thanks in advance, Kamila > > ~~ > > Structure your ColdFusion cod

RE: setting cf admin password - 2 questions

You can unencrypt the templates that make up the CF Administrator and use only the ones that handle the password changes. ---mark === Mark Warrick, Founder of Fusioneers.com Email: [EMAIL PROTECTED] / [EMAIL PROTECTED] Phone: 714-547-5386 / Efax:

SQL question grouping, ordering, sorting

Ok, I have a database of search strings with which users of the site have hit my search engine. I want to build a viewer so I can go in and see what people are doing without actually cracking into the database. My database isn't doing anything fancy. It's one table, consisting, essentially,

Percent calculation

Hi there! I need to find the percentage of a value in ColdFusion but have been getting inconsistent results. eg: Initial Weight: 250 grams Weight Change: 10.7% Final Weight (would be 250 grams plus 10.7%): ?? and also for subtracting (weight reduction), eg: Initial Weight: 250 grams Weight Ch

Sort two-dimensional array

Is it possible to sort a two-dimensional array, specifically by sorting on the first column while still retaining the second column's association with the first? There was something on Depressed Press, but I wasn't quite sure if/how it pertained to my predicament. Any help appreciated. TIA ~~~

Re: problem downloading .exe file (double post)

Will, A fast and easy work around for this is to zip the exe file. :-) James [EMAIL PROTECTED] wrote: > Hi all, I am having a problem setting up a link to download a .exe file. I have a page with a link to the file like so: download but when I click on it and try to download I get the follow