A colleague installed an eval version of CF4.5.1 on Linux. He wants to enter the
license without reinstalling.
Does anybody know how this is done? I have no experience with Linux whatsoever.
Thx
Pascal Peters
Macromedia Training
Macromedia Certified Instructor
LR Technologies, Belgium
Tel
I got this when doing cfhtmlhead and then cflocation
-Original Message-
From: Dave Clay [mailto:[EMAIL PROTECTED]]
Sent: donderdag 4 april 2002 21:21
To: CF-Talk
Subject: error - header
Can any one tell me why I get this error sometimes? You help would be appreciated.
Thank you
Dave
Structures are NOT ordered and there is no way of keeping them oredered. If you want
an order, use an array.
Pascal
-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]]
Sent: donderdag 4 april 2002 11:18
To: CF-Talk
Subject: Structure Sorting
Hi
I'm looping over a list
Of course, coldfusion has to loop over the keys a certain way. It does it
alphabetically, but that is just the way it is done. If they do it some other way in
MX, you can't complain because structures are NOT oredered.
Pascal
-Original Message-
From: Mark Smyth [mailto:[EMAIL
If you're on cf5: use CFFLUSH.
-Original Message-
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: donderdag 4 april 2002 18:13
To: CF-Talk
Subject: standby screen
Is there a way I can show the user a message saying processing while a
page is processing queries? How do I do this?
I don't use the CT myself, but when a Category or Subcategory isn't selected, I
suppose the form var will be an empty string.
So instead of using ParameterExists (You should use isdefined if you're on cf4+) test
for that empty string.
!-- Check for these variables --
cfif
That's automatic in CF (server side validation, CreateODBCDate, ...). I suggest using
CreateDate and treating the date (dd/mm/) as a list.
Pascal
-Original Message-
From: Tristram Charnley [mailto:[EMAIL PROTECTED]]
Sent: woensdag 3 april 2002 13:37
To: CF-Talk
Subject: CF doing
You're missing a CFOUTPUT around the hidden
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 2 april 2002 18:45
To: CF-Talk
Subject: Re: INPUT
Yup,
Me again,
I'm trying to pass the #user# selected from the down-down menu to the
hidden input field and pass
Use the wddx object in JS (check out the CF help for WDDX)
-Original Message-
From: Justin Hansen [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 2 april 2002 20:07
To: CF-Talk
Subject: RE: Converting a CF Structured Array to a JS Structured Array ?
Sweet! That worked great for CF to JS. Any
If you created a structure data in the session
cfscript
StructDelete(session,data);
/cfscript
If you created individual vars, repeat the line for each var.
-Original Message-
From: YC Nyon [mailto:[EMAIL PROTECTED]]
Sent: maandag 25 maart 2002 15:10
To: CF-Talk
Subject: kill session aka
CF creates it if it doesn't exist. This means on the page the user calls first. On the
next pages it exists if you passed it on the url.
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 22 maart 2002 15:00
To: CF-Talk
Subject: Client Variables
If I have
the client.urltoken and if User B hasn't been to index.cfm it will create
it?
How can it do this without using a cookie and how does it differentiate User
A from User B?
Dave
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 22, 2002 9:05 AM
To: CF-Talk
On CF5 try this
cfoutput query=qTest
cfloop list=#qTest.ColumnList# index=col
#qTest[col][qTest.currentRow]#br
/cfloop
/cfoutput
-Original Message-
From: Critz [mailto:[EMAIL PROTECTED]]
Sent: maandag 18 maart 2002 13:35
To: CF-Talk
Subject: Evaluating # and -
Are you sure you are passing the filename on the URL :
index.cfm?filename=d%3A%5Cbooks%5Ctest%5Cfile%2Eext .
It is just saying that URL.filename doesn't exist.
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: donderdag 14 maart 2002 15:29
To: CF-Talk
Subject: Re: CFSET
ISNumeric(var)
-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]]
Sent: woensdag 13 maart 2002 17:04
To: CF-Talk
Subject: simple test on text field for numeric only ?
I think I know there is no way but to write my own routine, but if I do,
maybe someone has done it before...
Make sure the user for the connection has the right permissions and that the Restrict
SQL Operations to checkboxes for the datasource in the CF administrator are all
unchecked
Pascal
-Original Message-
From: Mak Wing Lok [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 12 maart 2002 12:30
To:
Hi Phil
There is a Customtag cf_directory on the developers exchange that will do it.
If you can't find it, mail me off list. I will send it to you.
Pascal
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 12 maart 2002 12:48
To: CF-Talk
Subject: Re: Deleteing
Try this
cfdirectory action=LIST directory=#dir# name=qName sort=type ASC, name DESC
cfset bDir = 0
cfloop query=qName
cfif qName.type IS dir AND NOT(ListFind(.,..,qName.name))
cfset bDir = 1
cfbreak
cfelseif qName.type IS file
cfbreak
/cfif
/cfloop
cfif bDir
You could have downloaded one of the many versions of that CT from devex
-Original Message-
From: Scott Van Vliet [mailto:[EMAIL PROTECTED]]
Sent: donderdag 7 maart 2002 21:17
To: CF-Talk
Subject: CF_SAVECONTENT
For those of you interested, I have created a custom tag that simulates
Make a previous/next interface!
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 5 maart 2002 15:16
To: CF-Talk
Subject: Large Query return
I have the need to display a query that is returning 43000 plus rows.
The
query itself is in a storedproc and
CF_SQL_NUMERIC works for Access, SQL Server and Oracle. Don't know about
MySQL, but I imagine it will.
-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]]
Sent: maandag 4 maart 2002 9:07
To: CF-Talk
Subject: CFQUERYPARAM: a good generic numeric type?
Was reading Ben
USe cfhtmlhead to put it in the HEAD section of the html. (OR the CT
cf_htmlhead if you want to make your coding easy)
-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: maandag 4 maart 2002 16:36
To: CF-Talk
Subject: Inserting Javascript into your application.cfm
It skips
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 5 maart 2002 3:06
To: CF-Talk
Subject: CFLOCK throwontimeout=no
If you've got a cflock with throwontimeout=no, does it skip over the
block
of code within the cflock, or does it enter it if the
I would have to say CF_SQL_VARCHAR. (CHAR doesn't exist in Access) I am
not sure that it will work if the field is a CHAR in the other
platforms.
-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 5 maart 2002 8:00
To: CF-Talk
Subject: CFQUERYPARAM: a good
lWordList = ArrayToList(myarray,|);
REReplaceNoCase(mystring,([^[:alnum]])(#lWordList#)([^[:alnum]]),\1\3
,ALL);
This will replace the words defined in myarray by empty strings.
-Original Message-
From: James Sleeman [mailto:[EMAIL PROTECTED]]
Sent: zaterdag 2 maart 2002 13:29
To:
The local (variables.) scope is not a structure, so you cannot retreive
them automatically. You can see them using the debugger in CFStudio.
-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED]]
Sent: woensdag 27 februari 2002 18:06
To: CF-Talk
Subject: QQ: local variable
Each directory has at least the . and .. folders, so it is never empty,
.. so your CFELSE is never executed
-Original Message-
From: Robert Obreczarek [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 26 februari 2002 7:44
To: CF-Talk
Subject: cfdirectory prob
Hey gang,
Here's a piece of code
getdirectoryfrompath(d:\dir1\dir2\dir3\test.txt)
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: woensdag 20 februari 2002 17:51
To: CF-Talk
Subject: R: Strip from string
Hi,
I have the following text which I'm passed as a URL.filename
d:\dir1\dir2\dir3\test.txt
Make sure Enable retrieval of long text is checked for your
datasource.
You have to use native drivers (CLOBs don't work with ODBC).
You have to use cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR
value=more than 4 k in your regular inserts.
Should work, I've done it multiple times.
-Original
NO
If you're on CF5
cfsavecontent variable=myvar
cfinclude template=...
/cfsavecontent
cfoutput #replace(myvar, ... )# /cfoutput
-Original Message-
From: Perez, Bismark [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 19 februari 2002 17:37
To: CF-Talk
Subject: Using Replace() to replace hard
That's probably why.
Do you use conditional statements with thistag. executionmode?
If it is a simple CT enclose the code with cfif Thistag.executionmode
IS start ... /cfif
-Original Message-
From: Stephen Adams [mailto:[EMAIL PROTECTED]]
Sent: maandag 18 februari 2002 17:23
To:
index.cfm=
table border=0 cellspacing=0 cellpadding=0
tr
cfform action=create-list.cfm name=checkboxform
method=POST
cfquery name=GetFontFamily datasource=fontstyles
SELECT sti, ID
FROMfontsti
ORDER BY
I don't think it's possible using access. You could probably do it in
MSSQL, but it would involve writing a stored proc to extract all IDs
from your list convert them to numbers (or something like that). Keep
your cf solution, it's much easier.
-Original Message-
From: Richard
They should both work, but you are using ( instead of , in the 2nd
datepart on each line.
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 8 februari 2002 14:50
To: CF-Talk
Subject: T-SQL
HiYa,
Does anyone know the equivalent to this in t-sql
In a tipical install, CF cannot access the network, only the server
where CF is installed!
-Original Message-
From: Pascal Peters
Sent: vrijdag 8 februari 2002 15:06
To: CF-Talk
Subject: RE: Problem with CFFile and permissions
Are you sure that CF is set up with permissions to access
If you want to stop executing the page, use cfabort. If you are in a CT
and want to stop executing the CT but continue the page, use cfexit. It
doesn't matter that you use it in a CFCATCH, it will work anywhere
-Original Message-
From: mark kecko [mailto:[EMAIL PROTECTED]]
Sent:
Replace(error.diagnostics,chr(13)chr(10), ,ALL)
This will convert them to a single whitespace
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: donderdag 7 februari 2002 17:02
To: CF-Talk
Subject: How to Find Hidden Characters -- maybe related to whitesp...
The syntax is incorrect: INSERT INTO ...
For DELETE:
DELETE FROM table
WHERE your filters
PS don't forget the filters or you delete every record in the table
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 5 februari 2002 14:05
To: CF-Talk
Subject: re:
You are passing URL.PID to the page. SO:
DELETE FROM profile
WHERE profile_ID = cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#URL.PID#
This assuming profile_ID is a VARCHAR
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 5 februari 2002 14:23
To: CF-Talk
You have to define Profile_ID as Primary Key.
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 5 februari 2002 14:54
To: CF-Talk
Subject: RE: Deleting entries from database
Thanks...its works. Problem I'm having now is duplicate entires with the
same ID in my
#dateformat(now(), dd, )#
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 5 februari 2002 15:03
To: CF-Talk
Subject: date format
Hello,
I know this is an easy one, but I can't get it to work. How can I have
the current date display as Month,
That is because you want to insert a duplicate profile_ID. This should
not be possible in your application. You will have to re-think the way
you create your PK values.
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 5 februari 2002 15:32
To: CF-Talk
Subject:
Your question isn't very clear, but if you want the selected fonts in the
create-list.cfm page:
In the create-list.cfm you have the var form.select that contains a comma separated
list of fonts checked in the form below. You may want to pass the IDs as avalue
instead of the font-name.
cfinput
If auditQueryName contains the query name and not the query:
cfset myQuery = Evaluate(auditQueryName)
CFQUERY name=GetLastRecord datasource=#application.datasrc#
SELECT MAX(#ListGetAt(myQuery.Columnlist, 1)#) AS key
FROM #auditQueryTable#
/CFQUERY
-Original Message-
From:
BY your order
)
ORDER BY your order
Pascal Peters
Certified ColdFusion (5.0) Advanced Developer
Certified Web Developer
Macromedia Certified Instructor
LR Technologies, Belgium
Tel +32 2 639 68 70
Fax +32 2 639 68 99
Email [EMAIL PROTECTED]
Web www.lrt.be
cfif IsDefined(myArray)
and if you want to make shure it's an array
cfif IsDefined(myArray) AND IsArray(myArray)
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 1 februari 2002 9:21
To: CF-Talk
Subject: Testing for presence of array?
How do you test
.
The expression [ ]*title[ ]*(.*)/[ ]*title[ ]* will match the
title if you have only ONE title tag. If you have more, it will match
everything from the first title to the last /title
Pascal Peters
Certified ColdFusion (5.0) Advanced Developer
Certified Web Developer
Macromedia Certified Instructor
LR
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
ekeda ltd
http://www.ekeda.co.uk
(+44)020-8429-7300
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED
if (lnameStrc.pos[1] NEQ 0)
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: donderdag 31 januari 2002 18:19
To: CF-Talk
Subject: Proper way to check for successful subexpression match?
Hi,
What needs to be in place of whatGoesHere in the following code
block?
This snippet will parse a variable called file and create a list with
all URLs called lURL (pipe delimited)
cfscript
regexp = 'href[[:space:]]*=[[:space:]]*[^]';
cnt = REFindNoCase(regexp,file,1,yes);
while (cnt.pos[1] GT 0) {
text = mid(tmpvar,cnt.pos[2],cnt.len[2]);
text =
This is not a query of queries. Change the 2nd CFQUERY to
CFQUERY Name=PendingProspect DataSource=#application.DSN#
SELECT intCustomerID from tblprospectdetails
where intCustomerID IN #QuotedValueList(CustomerExist.intCustomerID)#
and
Depending on what you want to do, you can probably do One
-Talk
Subject: Re: cfquery from a cfquery
hihi..
thanks for yr reply.
sorry.. i dont know how to use request.DSN..
so how do i declare it..?
and.. if i use request.DSN...
does it mean i dont need to use CFLOCK..?
cheers
han
- Original Message -
From: Pascal Peters [EMAIL PROTECTED
I try to avoid IIF, consider using cfif and
cf_htmlhead/cf_htmlhead. But if you insist:
cfhtmlhead text=style
type=text/css#IIf(request.fieldValues.SQLMethod EQ
'insertSelect',
DE('extrasInsertSelect {display: block;}'),
DE('extrasInsertSelect
{display: none;}'))#/style
Pascal
That's exactly what I ment, but I was in a hurry
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: maandag 28 januari 2002 15:58
To: CF-Talk
Subject: RE: pound signs inside DE('') - help!
I try to avoid IIF, consider using cfif and
cf_htmlhead/cf_htmlhead. But if
Nested CT's were introduced in CF 4.0 if I'm not mistaken. (and so was
the thistag scope) I'm not sure thistag was a structure in CF 4.0, maybe
just a scope.
Pascal
-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: maandag 28 januari 2002 16:29
To: CF-Talk
Subject: thistag
This is actually the way we do it too. But we also include all form
variables comming with the original request.
Pascal
-Original Message-
From: Gilbert, Chris [mailto:[EMAIL PROTECTED]]
Sent: maandag 28 januari 2002 21:14
To: CF-Talk
Subject: RE: Login forms
My preferred approach is
It is still this way.
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: maandag 21 januari 2002 3:25
To: CF-Talk
Subject: Re: Nested Loops Over Queries
No, more like this:
cfquery name=a datasource=#dsn#
SELECT * FROM table1
WHERE ...
/cfquery
cfloop query=a
CF can be set up to run as any user you want to. Go into your services,
right-click on the CF Application Service and select properties. Click
the Log on tab and check this account. Then browse for the account
you want CF to Use. Make sure the account has all the proper rights.
There is a KB
SELECT t_mess, t_subcat_ID
FROM t_msg
WHERE t_mess IN (SELECT MAX(t_mess) FROM t_msg)
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: maandag 21 januari 2002 15:56
To: CF-Talk
Subject: RE: Query error in aggregate function
I still have been unable to get this to
This is because you always access the first record from the outer loop
in the inner loop. Solution in your code below!
-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: maandag 21 januari 2002 16:02
To: CF-Talk
Subject: Problems with looping
Hey all!
Take a look
cfquery datasource=test
INSERT INTO Table
(vehicleType,modelYear,manufacturerName,vehicleDescription,uploadedFile)
VALUES
('#form.vehicleType#','#form.modelYear#','#form.manufacturerName#','#for
m.vehicleDescription#','#variables.uploadedFile#')
/cfquery
-Original Message-
From: Jim
You don't
-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 18 januari 2002 12:19
To: CF-Talk
Subject: RE: A few quick regular expression questions
James and Joel.
Thanks for your replies.
Out of curiosity how would you do a regex to find everything but a
:[EMAIL PROTECTED]]
Sent: vrijdag 18 januari 2002 15:58
To: CF-Talk
Subject: RE: A few quick regular expression questions
You do.
the carrot ^ acts as a negative /[^A-Za-z]/
On Fri, 18 Jan 2002, Pascal Peters wrote:
You don't
-Original Message-
From: Kola Oyedeji [mailto:[EMAIL
I'm no Oracle expert, but this can do it (maybe there is a better way)
cfparam name=form.month default=01
cfset startdate = CreateDate(Year(Now()),form.month,1)
cfset enddate = DateAdd(m,1,startdate)
CFQUERY DATASOURCE=#Application.DSN# NAME=updateguide
SELECT eventid, eventdate, longtitle
FROM
Try this in your application.cfm (must be in the application root):
path = GetDirectoryFromPath(GetCurrentTemplatePath());
path = ReplaceNoCase(GetBaseTemplatePath(),path,);
path = ReplaceNoCase(path,\,/,ALL);
path = ReplaceNoCase(CGI.Script_Name,path,); path=
SELECT LTrim(Rtrim(IsNull(Author, ' ') + IsNull('; ' + secondAuthor, '
')))
AS
Authors
FROM table
-Original Message-
From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 15 januari 2002 22:25
To: CF-Talk
Subject: concatenate blank fields SQL and the pesky
Ok, I have to
Read the KB article
http://www.allaire.com/Handlers/index.cfm?ID=20370Method=Full
As for your code:
cflock timeout=30 throwontimeout=Yes type=EXCLUSIVE
scope=SESSION
cfif NOT IsDefined(session.basket)
cfset session.basket = ArrayNew(2)
/cfif
cfset FoundInBasket = 0
!--- Case 1 - Item already
FOR SQL-Server:
CFQUERY NAME=NameMe DATASOURCE=SomeDNS maxrows=10
SELECT LastName, FirstName, Beard1+Beard2+Beard3+Beard4 AS Total,
HarvestCounty
FROM Table1
Union
SELECT LastName, FirstName, Beard1+Beard2+Beard3+Beard4 AS Total,
HarvestCounty
FROM Table2
ORDER BY Total
Small error: ORDER BY Total DESC !!!
-Original Message-
From: Pascal Peters
Sent: vrijdag 11 januari 2002 16:14
To: CF-Talk
Subject: RE: When Comparing two tables how do I.
FOR SQL-Server:
CFQUERY NAME=NameMe DATASOURCE=SomeDNS maxrows=10
SELECT LastName, FirstName, Beard1
If the .sql file is containing normal sql:
cfquery ...
cfinclude template=path to sql file
/cfquery
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: donderdag 10 januari 2002 17:27
To: CF-Talk
Subject: calling .sql scripts with CF and MySQL: how to?
I believe scaleto=X will do that (X is the maximum value you want)
-Original Message-
From: Shahzad Butt [mailto:[EMAIL PROTECTED]]
Sent: vrijdag 28 december 2001 11:54
To: CF-Talk
Subject: CF5 Graph
Hi
If we use CFGraph Type=bar valueColumn=Total scalefrom.
It shows graph with
The function ArrayAppend returns Yes as a result.
When locking for the session scope, use a lock scope=session.
Otherwise an other block can still write to these variables.
The code to append should read:
cflock scope=session type=EXCLUSIVE timeout=5
!--- If no shopping cart exists, create
How about this? You can decide how many cols you have:
cfoutput
cfif qMyQuery.recordCount
cfscript
cols = 10; // you can change this to any nr of cols
rows = ((qMyQuery.recordCount - 1) \ cols) + 1;
/cfscript
table
cfloop index=i from=1 to=#rows#
tr
cfloop index=j from=1
You can use CFHTTP to do it. Get the page from your guestbook with
cfhttp url=guestbookurl method=GET
resolveurl=true/cfhttp
After that the HTML-page is stored in the variable CFHTTP.fileContent.
You can use this variable to display your guestbook.
Mayby you will have to strip some tags from
Use custom1, custom2 and title
-Original Message-
From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 18 december 2001 21:44
To: CF-Talk
Subject: Verity Question
I don't know which is better in this situation. I am working on a new
site
that will be almost exclusively
is to change the name of the formfield something_date. If
you _absolutly_ want that name kept, create a hidden formfield with the
name 'something' and the value '01/01/2000'.
Pascal Peters
Macromedia Certified Instructor
Certified ColdFusion (5.0) Advanced Developer
Certified Web Developer
LR Technologies
Actually, There is a function that is intended for this kind of
situations:
ListQualify(listVar,')
Pascal
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: maandag 17 december 2001 23:23
To: CF-Talk
Subject: RE: IN condition... help?
no need to initiate a loop.
If You are using FB3, just create a layoutfile for your root circuit and
include the footer there
Pascal
-Original Message-
From: Shahzad Butt [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 18 december 2001 12:25
To: CF-Talk
Subject: Footer
Hi
I want to include footer at end of each page.
=
cfset fusebox.layoutfile = mylayoutfile.cfm
Pascal
-Original Message-
From: Shahzad Butt [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 18 december 2001 12:38
To: CF-Talk
Subject: RE: Footer
Should I stick it in root index.cfm? Or app_global.cfm?
-Original Message-
From: Pascal
The timeout is in seconds. How long it takes to obtain a lock, depends
on the other locks in the application, the code in them, the number of
usrs on your site, In short: it depends.
If throwontimeout = no, CF will just continue executing after the
/cflock without generating an error.
- Original Message -
From: Pascal Peters [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, December 17, 2001 5:49 AM
Subject: RE: Just when you thought the topic of locking was
completelyexhausted...
The timeout is in seconds. How long it takes to obtain a lock, depends
on the other
cfquery name=qCart
datasource=dsMain
dbtype=ODBC
SELECT ItemName, BrandName, RetailEach, RetailUnit, UnitSize,
DetailedDescription, ItemNumber, MainCategory,
SubCategory1, SubCategory2
FROM MasterItemTable
WHERE 0 = 0
cfif
I was to quick in replying:
IsDefined(Category1) ... IsDefined(Category2)
-Original Message-
From: Pascal Peters
Sent: maandag 17 december 2001 16:29
To: CF-Talk
Subject: RE: BrainFART: CFQuery conditional excecution
cfquery name=qCart
datasource=dsMain
dbtype=ODBC
If you're on CF5, use the UDF, otherwise copy the code
http://www.cflib.org/udf.cfm?ID=179
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 11 december 2001 15:01
To: CF-Talk
Subject: Rcurring Event for Calendar
I need to be able to schedule recurring
Yes you can, but you can't use the CFOUTPUT. And to beat Ray (who is
still sleeping), you don't need evaluate if you have CF 4.5+.
cfmail ...
CFLOOP LIST=#FORM.FieldNames# INDEX=ThisField
FIELD=#ThisField#, VALUE=#Form[ThisField]#
/CFLOOP
/cfmail
Pascal
-Original Message-
From: Matt
WHERE cal_date_start = cfqueryparam cfsqltype=CF_SQL_DATE
value=#CreateODBCDate(Now())#
AND cal_date_end = cfqueryparam cfsqltype=CF_SQL_DATE
value=#CreateODBCDate(Now())#
This is independent of your DB. You can also use DB functions to get
the current date
-Original Message-
From:
CF is most probably using a US dateformat (depends on the settings of
your server).
TRY:
cfset targ=#CreateDate(2001,12,01)#
cfoutput#Dateformat(targ,dd/mm/)#/cfoutput
cfset compare=DateDiff(d,targ,Now())
Pascal Peters
Macromedia Certified Instructor
Certified ColdFusion (5.0) Advanced
TRY:
WHERE trunc(eventdate) BETWEEN
TO_DATE('#DateFormat(variables.Begindate,dd/mm/)#','DD/MM/')
AND TO_DATE('#DateFormat(variables.Enddate,dd/mm/)#','DD/MM/')
OR you can use 'MM/DD/' as formatting mask if you prefer
Pascal
-Original Message-
From:
cfsqltype=CF_SQL_VARCHAR
value=#form.myfield#)
Pascal Peters
Macromedia Certified Instructor
Certified ColdFusion (5.0) Advanced Developer
Certified Web Developer
LR Technologies, Belgium
Tel +32 2 639 68 70
Fax +32 2 639 68 99
Email [EMAIL PROTECTED]
Web www.lrt.be
-Original
Heidi
You can set all the parameters in the CF administrator when creating the
connection. If you don't want all settings set in the administrator, you
can pass username and password in cfquery. The server and dbname HAVE
to be set in the ODBC.
cfquery name=qTest datasource=#DS#
Safest method i found:
UPDATE ...DateCreated=
TO_DATE('#DateFormat(form.DateCreated,dd/mm/)#','DD/MM/')
SELECT ...WHERE trunc(DateCreated) =
TO_DATE('#DateFormat(variables.Startdate,dd/mm/)#','DD/MM/')
Pascal
PS: US citizens can use the mask DD-MM- if they like, but with
Use CFSCHEDULE to do the work.
It is stored in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Schedule
Pascal
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 20 november 2001 16:35
To: CF-Talk
Subject: where is scheduled info
Make sure they defined a username and password for the connection in CF
SETTINGS of the CFAdmin ODBC (OR OLEDB) interface.
-Original Message-
From: Douglas Jordon [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 20 november 2001 16:54
To: CF-Talk
Subject: first SQL server datasource on ISP
Hi,
datecompare(date1,date2)
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 20 november 2001 17:11
To: CF-Talk
Subject: RE: Datediff
I am having problems comparing two dates.
My question is how to compare two dates that come from different years.
For example
Didn't read everything. If you want the difference: compare=
DateDiff('d',targ,implm)
Datediff works on entire dates.
Pascal
-Original Message-
From: Pascal Peters
Sent: dinsdag 20 november 2001 17:24
To: CF-Talk
Subject: RE: Datediff
datecompare(date1,date2)
-Original Message
I don't know how to do that, but there is a custom tag that will do that
for you. Check out http://www.erikv.com/downloads.html and download the
sample fusebox application (the file is fbx_sesconverter.cfm)
-Original Message-
From: Edward Chanter [mailto:[EMAIL PROTECTED]]
Sent:
Is your Enable retrieval of long text checked in your datasource?
Otherwise, the long text have a max buffer size(usually set to 65000).
Pascal
-Original Message-
From: Simon Whittaker
Sent: vr 16-11-2001 15:28
To: CF-Talk
Cc:
Pascal Peters
Macromedia Certified Instructor
Certified ColdFusion (5.0) Advanced Developer
Certified Web Developer
LR Technologies, Belgium
Tel +32 2 639 68 70
Fax +32 2 639 68 99
Email [EMAIL PROTECTED]
Web www.lrt.be
-Original Message-
From: Jones, Becky [mailto
Are you using form action=page.cfm enctype=multipart/form-data for
the form?
Pascal
-Original Message-
From: Steven Lancaster
Sent: do 15-11-2001 17:01
To: CF-Talk
Cc:
Subject: CFFILE
I don't understand I
Im I correct in thinking this SQL Is in a variable?
cfquery ...
#PreserveSingleQuotes(myvar)#
/cfquery
Pascal
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]]
Sent: woensdag 14 november 2001 17:17
To: CF-Talk
Subject: ODBC error
The below is an output of what is in the
901 - 1000 of 1018 matches
Mail list logo