Treat the file as a list of lists...
List 1 - Delimiter = #Chr(10)##Chr(13)#
And each element of that list is a list with delimeter ,
HTH
-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2002 16:14
To: CF-Talk
Subject: Looping through a CSV File
I
Or theres a custom cfx tag called something like ... Cfxcsvtoquery that
will take a csv file and convert it into a query variable
HTH
-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2002 16:14
To: CF-Talk
Subject: Looping through a CSV File
I have a
Had problems where by (running XP) if I was in sub dirs of a mapped
drive every now and then studio would reset the dir to the root of the
mapped drives...
Never found a fix.. Use projects now instead.
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: 21
The Maxmum timeout you can add to a session is set in the
CFAdministrator which by default is 20 minutes...
HTH
-Original Message-
From: Justin Hansen [mailto:[EMAIL PROTECTED]]
Sent: 07 March 2002 15:38
To: CF-Talk
Subject: Session Timing out too fast
I know this is kinda vague
.
Cannot convert to number.
Cheers
Will
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: 06 March 2002 12:54
To: CF-Talk
Subject: RE: form variables in structures
CFLOOP COLLECTION=#FORM# ITEM=frmVar
CFOUTPUT
#frmVar# = #FORM[frmVar]#br
Have a look on Forta.com... I was on there earlier and noticed that an
adult site was listed... May be worth having a look to see if you can
find their hosting company...
HTH
-Original Message-
From: J B [mailto:[EMAIL PROTECTED]]
Sent: 06 March 2002 18:30
To: CF-Talk
Subject: Adult
Try using CFEXIT
HTH
-Original Message-
From: Louis Klepner [mailto:[EMAIL PROTECTED]]
Sent: 28 February 2002 13:38
To: CF-Talk
Subject: CFABORT template, not all CF processing?
Sorry about that last one, I guess it's dangerous to hit tab and enter
rapidly...
I was wondering if
You could have a look at www.cueware.com
-Original Message-
From: Tristram Charnley [mailto:[EMAIL PROTECTED]]
Sent: 26 February 2002 15:12
To: CF-Talk
Subject: OT SMS micropayments
Has anyone been using SMS as a means of collecting micropayments for web
content? ie the customer
The part you'll need is http://www.cueware.com/cuepay.cfm
HTH
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: 26 February 2002 15:20
To: CF-Talk
Subject: RE: OT SMS micropayments
You could have a look at www.cueware.com
-Original Message-
From
You could try setting the variable to
Ie at the end of the page CFSET oMyCOMObject =
Although Im not sure whether it wil work
HTH
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 26 February 2002 15:34
To: CF-Talk
Subject: RE: Question Regarding COM/MTS and CF
Theres a custom tag that might be of use to you, CFX_CSVToQuery takes a
CSV file and converts it into a query object for you.. It handles commas
in
HTH
-Original Message-
From: Tracy Bost [mailto:[EMAIL PROTECTED]]
Sent: 21 February 2002 22:40
To: CF-Talk
Subject: Get everything
The from does contain an email address.. However if a friendly name is
included the email address is surrounded by angles and as such the
browser will process them out...
If you view the source of the page then you will see the email addres...
Or alternitavely use HTMLEditFormat() around the
You could use...
URL.filename = ListDeleteAt(URL.filename, ListLen(URL.filename, \),
\)
HTH
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2002 16:51
To: CF-Talk
Subject: R: Strip from string
Hi,
I have the following text which I'm passed as a
You could do it like this...
CFTRANSACTION
CFTRY
CFQUERY NAME=qryID DATASOURCE=#Application.DSN#
SET NOCOUNT ON
INSERT INTO foo (name)
VALUES ('Homer Simpson')
Have a look at http://www.intrafoundation.com/
They've got a kit that will access all this information
HTH
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: 14 February 2002 17:44
To: CF-Talk
Subject: Re: Accessing Accounts on NT via CF
Is there a way to
Not sure about the PDF part, but for doc files you could look at
connecting to the Word COM object on the server and resaving the file
into the format that you want...
www.cfcomet.com should have the information you require on that...
HTH
Mike
-Original Message-
From: [EMAIL
When you do the transfer enssure you select the bottom option (in sql
server 2k) that specifies that tables and objects are moved across..
This will ensure that identity fields etc are copied across
HTH
-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: 13
What happens if you add at the bottom of the page some javascript to
focus the top control...
-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: 14 February 2002 00:23
To: CF-Talk
Subject: how to stop ezEdit grabbing focus
Does anyone with experience of ezEdit (the now
Hi
I am trying the following :
Connecting to a DCOM object on another machine that returns me a 32bit
int. (or H Result in C++ terms)
Below - bLogon fails to return my value. Trying to work out why its not
working from this result.
Any ideas ? Or DCOM / CF guru's on here ;-)
Thanks
Mike
!--- Apply a sessions type scenario to the site ---
CFIF DateDiff(n, Client.LastVisit, Now()) GT 20
CFLOOP LIST=#GetClientVariablesList()# INDEX=idxCliVar
CFIF NOT DeleteClientVariable(idxCliVar)
CFSET Client.#idxCliVar# =
/CFIF
I believe it to work.. However I believe you have to trim() the form
field in the CFFile tag
Although I might be wrong
-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: 18 December 2001 15:22
To: CF-Talk
Subject: File upload on a Mac
My guess is that someone's run
by telephone call at the number
listed above.
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 10:30 AM
To: CF-Talk
Subject: RE: File upload on a Mac
I believe it to work.. However I believe you have to trim() the form
field in the CFFile tag
Replacment
Is it a Windows computer. If so you can use Active X objects to read the
file.
Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 1:11 PM
To: CF-Talk
Subject: RE
Sorry What im trying to do is allow file uploading when the
administrator has disabled the CFFILE tag... I can get the file to the
destination OK however I cannot find a way of working out what the
original file was called...
So I need to find the Orginal name of the file that is uploaded
Ticonderoga
Web Developer Extraordinaire
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 1:11 PM
To: CF-Talk
Subject: RE: CFFile Replacment
Sorry What im trying to do is allow file uploading when the
administrator has disabled
To do what you want to do you will need to use the Evaluate function...
Ie
CFIF Evaluate(#queryName#.recordcount) GT 0 etc
-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: 05 December 2001 17:30
To: CF-Talk
Subject: Stumped: Getting recordcount for
Im attempting to make a replacement to CFFile Uploading capabilities...
Now I can do the upload etc part but does anyone know how to access the
original name to the uploaded file... As I get the temp filename that is
stored on the server, but how do I access the orig filenmae
Answers on a
Tries to jump in before Ray ;)
You should access the FORM using structure syntax rather than Evalute as
this is more efficient
Ie
CFLOOP ITEM=Fields COLLECTION=#FORM#
CFOUTPUT
Form Name = #Fields#
Value = #FORM[Fields]#
/CFOUTPUT
/CFLOOP
HTH
AFIAK you need to set IIS to use the Challenge/Response (or whatever its
callled as it changed its name between nt 4 and 2k) and remove the
anonymouse and basic security.
That way IE will attempt to log you into the site before showing a login
box... If this is successful then you will have
I would assume you would get all requests back
Maybe you could use the Top sql command to ensure that only one record
is delt with
HTH
-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: 29 November 2001 14:31
To: CF-Talk
Subject: maxrows question
Does
Concatonation in access is and in SQL server its +
-Original Message-
From: Jim Watkins [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2001 14:39
To: CF-Talk
Subject: Re: Access problem - Help please
I have tried the + sign but no good. Anybody out there know how to set
up
Youll need a comma
'term[-]term1 term2' should be 'term[-]term1, term2'
HTH
-Original Message-
From: Jim Watkins [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2001 15:17
To: CF-Talk
Subject: Re: Access problem - Help please
OK I used below suggestion and get following error:
Doh!... Should be
term - term1, term2
-Original Message-
From: Jim Watkins [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2001 15:17
To: CF-Talk
Subject: Re: Access problem - Help please
OK I used below suggestion and get following error: [Microsoft][ODBC
Microsoft Access Driver]
Try this...
SELECT distinct coursename,term,term1, 'TERMS:' term ', ' term1 AS
Terms
from courseeval
order by coursename
HTH
-Original Message-
From: Jim Watkins [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2001 16:26
To: CF-Talk
Subject: Re: Access problem - Help please
I
Use the ValueList command
CFSET lstFoo = ValueList(MyQuery.Column)
HTH
Mike
-Original Message-
From: loic jegouzo [mailto:[EMAIL PROTECTED]]
Sent: 27 November 2001 13:07
To: CF-Talk
Subject: put a recordset in a list
This is a multi-part message in MIME format.
Doesn't this
FROM Tickets T,
Mean that in your SQL it should be reffered to as T ?
-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2001 15:37
To: CF-Talk
Subject: Query Help
Ok.. why does it say this:
Error:
[Microsoft][ODBC SQL Server
Theres a setting in CF Admin that will 'purge' unused client variables
which I believe is set by default to 90 days, this value can be changed
with the minimum setting of 1 day... So its more of a clean up
database/registry space rather than timing out a session
HTH
-Original Message-
?
Value out of range
The error occurred while processing an element with a general identifier
of (CFSCRIPT), occupying document position (31:1) to (31:10).
=
Line starts the CFSCRIPT.
Thanks,
Dave
- Original Message -
From: Mike
Make sure that your form tag has the following enctype
ENCTYPE=multipart/form-data
HTH
Mike
-Original Message-
From: Steven Lancaster [mailto:[EMAIL PROTECTED]]
Sent: 15 November 2001 16:02
To: CF-Talk
Subject: CFFILE
I don't understand I have on one page this:
input type=file
Are you sure that its only returning name as if you are looking at it in
your browser the browser will think that the section is a tag...
Ensure that you wrap the output with HTMLEditFormat
Ie
cfoutput
#HTMLEditFormat(makeFriendly.Friendly)#
/cfoutput
HTH
-Original Message-
AFAIK
Sessions are for one server only so if you have cluster servers a
different server cannot access the session details of another server...
However with Client variables (turned off the default location of the
registry to a database such as SQL Server) you can store these in a
central
AFIAK all pages will access CDATA and CGLOBAL as these are the client
varibles data tables... So if you have client variables turned on and
the datasource going to that database then all page requests will update
them...
HTH
Mike
-Original Message-
From: Christian Watt [mailto:[EMAIL
a performance hit, what I want to
know is what CF Server page is called to invoke the query so that I can
update it and include no locks on them.
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 14, 2001 12:45 PM
To: CF-Talk
Subject: RE: CGLOBAL CDATA-SQL
For how to use word... Install word and the VBA help information and
check msdn.microsoft.com as between them they should list all the
commands/functions that you can access with Word
HTH
-Original Message-
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Sent: 14 November 2001 19:34
: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 14, 2001 1:17 PM
To: CF-Talk
Subject: RE: CGLOBAL CDATA-SQL
AFAIK the query is made by the server itself and so you cannot change
the query that it calls...
-Original Message-
From: Christian Watt [mailto:[EMAIL PROTECTED
I also doubt that its an encrypted page as you can remove the CFIDE
files...
Thus it must be called from the bin directory which means the server
itself
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: 14 November 2001 19:54
To: CF-Talk
Subject: RE: CGLOBAL
But surely that means that CF is using double the memory for every
request... Memory to store the session details and memory to store the
session details..
Whats wrong with setting CFAdmin to automatically lock reads... That way
any time you read a shared var ie IsDefined and DSN's etc its
I belieive IIF stands for Inline IF and DE stands for Delay(ed)
Evaluation
HTH
Mike
-Original Message-
From: Steven Lancaster [mailto:[EMAIL PROTECTED]]
Sent: 13 November 2001 16:50
To: CF-Talk
Subject: RE: Radio Button
what does iif and de stand for? I understand what it is doing,
AFAIK the IIF tag evaluates both the true and the false sections as the
function is processed... The best thing to do would be cfparam the
variable and check to see if it contains data.
CFPARAM NAME=FORM.classCodeID DEFAULT=
#IIF(Len(FORM.classCodeID), DE(#FORM.classCodeID#), DE(ALL))#
On the assumption that eventdatestart is a datetime object in your
database then the query will be looking for the date passed and time =
0:00:00. If the inserted records contain timing information on insert
then this will probably not return any records... Try.
WHERE eventdatestart BETWEEN
Try this:
cfloop list=#form.fieldnames# index=x delimiters=,
tr
td
cfoutput#x#/cfoutput
/td
td
cfoutput#form.[x]# /cfoutput
/td
/tr
/cfloop
HTH
Mike
-Original Message-
From: Mike Tangorre [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 2, 2001
Doh! That should probably have been
cfloop collection=#form# item=x
tr
td
cfoutput#x#/cfoutput
/td
td
cfoutput#form.[x]# /cfoutput
/td
/tr
/cfloop
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 2, 2001 17:42
is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 12:42 PM
To: CF-Talk
Subject: RE: Output Issue
Try this:
cfloop list=#form.fieldnames# index=x delimiters=, tr
td
cfoutput#x
You need to change how the try works with transaction...
CFTRANSACTION
CFTRY
!--- Queries Here ---
CFTRANSACTION ACTION=COMMIT/
CFCATCH
!--- We have experienced an error...
You could place the images outside of the wwwroot so that they are not
accessable at all, then use CFCONTENT tag to display the image to the
user after they have been authenticated.
HTH
Mike
-Original Message-
From: Absolute 1 [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25,
Youll need
cfwddx action=CFML2WDDX output=UserDataPacket
input=#Evaluate('application.um.#UmID#_Data')#
HTH
Mike
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 13:49
To: CF-Talk
Subject: CFWDDX problem
CFWDDX problem.. What do I do
Ahh but from the code he posted
The struct is called: application.um.#UmID#_Data
How would you reference that as [] ?
As you posted #Application.Um[UmID].Data# wouldn't that fail as it would
be Application.Um[#UmID#_Data]
Or am I miles off ?
Didn't take it as a put down... Im not the most
You could upload the files and then use COM objects of Word and
Powerpoint to save as html
HTH
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 16:02
To: CF-Talk
Subject: PP or WORD to HTML
Anybody know of an app that will allow you
A site which documents attaching to Office applications etc with
ColdFusion is www.cfcomet.com
What code are you using to access this ?
HTH
Mike
-Original Message-
From: JAIME HOI [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 13, 2001 8:07
To: CF-Talk
Subject: CFOBJECT ERROR
Depends on what you are doing... I recently had the same problem.. I was
saving the results of a db search to a wddx packet in a client var...
Till it got too big.
My work around was to save the search params in the client var and
requery the database to reget the same results
-Original
Use single quotes..
cfset spcheck = You last updated them on #dateformat(thedate, 'dd mm
')#
Or concatonate the variable
cfset spcheck = You last updated them on dateformat(thedate, dd
mm )
HTH
Mike
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent:
Ben Forta SQL in 10 minutes lists them all at the back Very very
usfull if you've accidently called a field date...
Not sure of a web resource tho
Mike
-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 16:01
To: CF-Talk
Subject:
When the CF Server goes into single IP mode then the first IP that
requests any data from CF will become the only IP that CF will send
information too without restarting the CFServer... So if you have 2
machines connecting to CF 200.1.1.1 and 200.1.1.2 if 200.1.1.1 connects
first to the server
AFAIK the same locking principle apply to cf5 as 4 so you must lock all
application/session/server scoped variables
HTH
Mike
-Original Message-
From: Hamid Hossain [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 18:14
To: CF-Talk
Subject: CFLOCK with CF 5.0
is it
What you will probably have to do is use the Find() function in
conjunction with the Chr() function.
Ie to find a carriage return in some text you would
Find(Chr(10) Chr(13), mystring)
HTH
-Original Message-
From: Stephenie Hamilton [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14,
have tried para;, no luck...
--
Stephenie
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 8:42 AM
To: CF-Talk
Subject: RE: finding special characters in a list
What you will probably have to do is use the Find() function in
conjunction
Thats what I get for doin it off the top of my head...
I dont usually need to worry about them both as if I am looking for a
crlf then I set up vairable... But mainly its for formating pages and
so I just look for the one i.e. Replace(sMyString, Chr(13), BR,
ALL)
-Original
Have you put ENCTYPE=multipart/form-data in your posting form...
Ie
FORM ACTION=act_upload.cfm METHOD=Post
ENCTYPE=multipart/form-data
/FORM
HTH
Mike
-Original Message-
From: Paul Smith [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 1:07
To: CF-Talk
Subject: CFFILE Problem
AFAIK...
Whistler is the code name and XP will be the workstation/professional
version of it and windows 2002 will be the server version of the product
HTH
Mike
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 3, 2001 14:35
To: CF-Talk
Subject:
try looking at www.cfdeveloper.co.uk
HTH
Mike
-Original Message-
From: Guy McDowell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 3, 2001 14:52
To: CF-Talk
Subject: Inexpensive Hosting
G'day eh?
I'm trying to find very inexpensive CF hosting to no
avail. Something under $20 CDN
It should hopefully be ok on that front because it will be win2k/nt
stability... Just the games that will probably unstable
-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 3, 2001 18:59
To: CF-Talk
Subject: RE: IE 6 (whistler)
Retiring the
You could try
cfloop query=qry_show_event_sponsors
#EventSponserName##IIF(qry_show_event_sponsors.RecordCount NEQ
qry_show_event_sponsors.CurrentRow, DE(','), DE(''))#
/cfloop
HTH
-Original Message-
From: Chris Martin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 3, 2001
If you are interested... am writing small email app that can send you off
list to have a look at... not finished but should give you the idea
HTH
Mike
-Original Message-
From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 31, 2001 10:14
To: CF-Talk
Subject:
It should be a case of useing CFSET
so say you ahave a COM object of oFoo with a property size
CFSET oFoo.Size = 12
should set the size of 12 amd
CFSET Temp = oFoo.Size
should read the size
HTH
Mike
-Original Message-
From: lsellers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
Try www.cfcomet.com
This website has information about using CFOBJECT with the Office
Applications and should have details about running macros within excel
-Original Message-
From: Chen, Yung-Chih (CIT) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 15:54
To: CF-Talk
try just putting
CFSCRIPT
if (Check_NT.RecordCount gt 0)
..
HTH
Mike
-Original Message-
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 17:10
To: CF-Talk
Subject: Why doe my cfscript if statement fail?
Hi There,
I'm trying to
You could try
FORM
ACTION="http://www.accommodationnewzealand.com/nzl/mkt/creditcardform.cfm"
NAME="myform" METHOD="post"
CFOUTPUT
INPUT TYPE="hidden" NAME="businessname" VALUE="#businessname#"
INPUT TYPE="hidden" NAME="suburb" VALUE="#suburb#"
...
/CFOUTPUT
Click A
Try this instead
cfset variable1 = "stuff"
cfset variable2 = variable1
CFOUTPUT
#variable2#
/CFOUTPUT
Or
cfset variable1 = "stuff"
cfset variable2 = "#variable1#"
CFOUTPUT
#variable2#
/CFOUTPUT
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent:
You will need to put a catch type in... try
CFTRY
CFSWITCH etc etc
(all the stuff)
/CFSWITCH
CFCATCH TYPE="Any"
arhhh!!
/CFCATCH
/CFTRY
-Original Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]]
Sent:
You could try looking at http://www.cfcomet.com
they have all sorts of information about using CF with COM and Office
Applications
-Original Message-
From: Chris Martin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18, 2001 7:16
To: CF-Talk
Subject: Excel Questions
Hey everyone.
The problem is that when CYOriginal EQ 0 the following code is run
NumberFormat(100*Change/CYOriginal, '__._')
and as CYOriginal=0 then you cannot divide (100*Change) by 0
HTH
Mike
-Original Message-
From: Drechsler, Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Friday, January
try this
cfquery name="Get" datasource="wweb"
SELECT id, cbi
FROM wweb
Where cbi = 'CBI'
/CFQUERY
CFOUTPUT
#Get.RecordCount#
/CFOUTPUT
HTH
Mike
-Original Message-
From: Robert Orlini [mailto:[EMAIL
301 - 382 of 382 matches
Mail list logo
