Yes, you should beable to use cfthrow type=myExeptionType (with a
custom exception type) and then use cferror type=exception
exception=myExeptionType template=myErrorTemplate.cfm
Pascal
-Original Message-
From: Monique Boea [mailto:[EMAIL PROTECTED]
Sent: 13 September 2004 14:02
To:
I believe the bugs have been fixed in a hotfix (hf53813_61). I have no
errors on my server anymore. The hotfix introduces a bug with cfdump (of
the cfcatch structure) I think. There were some discussions on that
topic on this list.
Pascal
-Original Message-
From: Michael Hodgdon
Euh... YES
-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED]
Sent: 10 September 2004 14:17
To: CF-Talk
Subject: [Spam?] Re: uploading jpegs - cffile
You might consider adding PNG files.
Do browsers read those now?
[Todays Threads]
[This Message]
How about grouped output?? Something like
cfoutput query=readsi group=clientname
tr
...
td class=tdtext align=centera class=class2
href="">
name#/a
cfoutput
bra class=class2
href="">
/a
/cfoutput
/td
/tr
/cfoutput
-Original Message-
From: hammerin hankster [mailto:[EMAIL PROTECTED]
scriptrun[script scriptNO] = StructNew()
Pascal
-Original Message-
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: 09 September 2004 07:25
To: CF-Talk
Subject: concatenate a string
Can some please tell me how to concatenate a string on CF ?
cfquery datasource=obscript
// list
for(i = 1;i LE ListLen(list);i=i+1){
element = ListGetAt(list,i);
}
// query
for(i = 1;i LE query.recordCount;i=i+1){
value = query.field[i];
}
Pascal
-Original Message-
From: Andrew Dixon [mailto:[EMAIL PROTECTED]
Sent: 09 September 2004 11:42
To: CF-Talk
Subject:
DELETE FROM EPIC
WHERE ProductCode = 'CHP03' AND supplier = 'ABC'
But you should really have a Primary Key in a table !!!
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: 08 September 2004 12:04
To: CF-Talk
Subject: Delete problem
I know its more of sql
Did you try cf_sql_longvarchar ?
Pascal
-Original Message-
From: Garcia Freddys [mailto:[EMAIL PROTECTED]
Sent: 08 September 2004 16:07
To: CF-Talk
Subject: [Spam?] memo (varbinary) update using CFMX 6.1
Hi everybody,
I'm having some difficulty using CFMX 6.1 to do an update on
Mozilla Firefox
-Original Message-
From: Cornillon, Matthieu (Consultant)
[mailto:[EMAIL PROTECTED]
Sent: 08 September 2004 19:16
To: CF-Talk
Subject: [Spam?] RE: DHTML Drag and Drop pt.2
Guy,
One tip on debugging _javascript_: I am sure there is some smart way to
do
it.
I
In CF it is \1 : a href="">
Pascal
-Original Message-
From: Josen Ruiseco [mailto:[EMAIL PROTECTED]
Sent: 08 September 2004 19:27
To: CF-Talk
Subject: RegEx Problem Trying to Use Matched Text
I am trying to follow the regex example on page 82 of Ben Forta's
regular
Expressions
You could use Application.cfm (or a file that you include in relevant
places) to contain the whole login procedure and use self posting forms
for the login. This way you never leave the page you requested.
IF not logged in
IF not coming from the login form
Show the login form
Abort
IF coming from
body >
query=allphotos'photoslarge/#filenamelarge#'cfif
allphotos.recordcount NEQ allphotos.currentrow,/cfif/cfoutput)
Pascal
-Original Message-
From: Jeffrey Fongemie [mailto:[EMAIL PROTECTED]
Sent: 07 September 2004 16:55
To: CF-Talk
Subject: Looping Question
Hi everyone,
It would be QuotedValueList and this would only work if the query was
altered to include the path:
cfquery name=allphotos datasource=#request.dsn#
SELECT filenamelarge, 'photoslarge' + filenamelarge as filepath
/cfquery
body
>
/cfoutput)
Pascal
-Original Message-
From: Tangorre,
Your problem is with how cf treats lists. The delimiter can't be present
in a value, or it will be treated as separate elements. You will need to
use a proper csv parser that allows a text qualifier (). Have you
considered CFHTTP to read the csv into a query object? In a recent
tread, someone
The cffile just reads the file, it doesn't parse anything.
A text qualifier is a character you place around text in a csv (usually
). When you have a comma in the text (surrounded by quotes), it means
it is just a comma, not a delimiter.
A,B,C,D == 4 elements ABCD
A,B,C,D == 3 elements AB,CD
A
Yes, it would read the data as if it came from a database table using
cfquery.
cfhttp url="" name=qData columns=columns
here if first line not column names textqualifier= delimiter=,
resolveurl=no timeout=20 charset=charset of the page/cfhttp
cfdump var=#qData#
Replace the values with your own
I think is the default qualifier. You can even drop the delimiter (I
think , is the default).
Pascal
-Original Message-
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: 06 September 2004 12:53
To: CF-Talk
Subject: RE: escaping character
Wo - why does that work ? I
Use CFQUERYPARAM !! put the #qData.xxx# in the value attribute and
use the appropriate cfsqltype
Pascal
-Original Message-
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: 06 September 2004 13:26
To: CF-Talk
Subject: RE: escaping character
What am i doing wrong here ?
Refind without the returnsubexpressions argument will return the
position of the match. You need to extract the match yourself (and use
subexpressions for that).
cfscript
stTmp = REFindNoCase(SELECT\s+(.*?)\s+FROM\s,theQuery,1,true);
if(stTmp.pos[1])
NewString =
I hope you are aware that you will only have the last record in the
array as a result of your code. You overwrite it for every record. Maybe
you want a 2-dimensional array?
Your code corrected:
cfsript
csvRecord = Replace(csvRecord, ,,all);
csvArray = ListToArray(csvRecord);
/cfscript
This
I suggested the same thing in my post, but it will not cover empties at
the beginning or the end. Best is to use the udf listfix:
http://www.cflib.org/udf.cfm/listfix
Pascal
-Original Message-
From: Neculai Macarie [mailto:[EMAIL PROTECTED]
Sent: 01 September 2004 12:01
To: CF-Talk
For that, the query needs to be executed. In his example, theQuery is
just a string (probably containing sql)
Pascal
-Original Message-
From: Adam Haskell [mailto:[EMAIL PROTECTED]
Sent: 01 September 2004 14:44
To: CF-Talk
Subject: Re: REFind Help ...
#the_query.columnlist#
1. This will work if you always have a select statement. If (in some
cases) there is no select statement, it will return the whole string.
That is why I usually go with REFind/Mid.
2. If you are looking for a column list, I would also add some \s in the
regexp:
^.*?SELECT\s(.*?)\sFROM\s.*$
If
You can place it wherever you want, but you need to cfinclude it before
you use it
-Original Message-
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: 01 September 2004 15:53
To: CF-Talk
Subject: using udfs
Hi - I am trying to use the listfix.cfm udf, and I am not quit sure
how
We use total commander. It can synchronize a whole directory structure
(over the network or over ftp)
Pascal
-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED]
Sent: 01 September 2004 15:49
To: CF-Talk
Subject: [Spam?] FTP client that works like Dreamweaver's site
Sorry, didn't read your original post very well
Pascal
-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED]
Sent: 01 September 2004 16:04
To: CF-Talk
Subject: [Spam?] Re: FTP client that works like Dreamweaver's site
manager?
On Sep 1, 2004, at 9:59 AM, Pascal
In cf5, arguments is an array. Just use formName and defaultValue
without a prefix (or arguments[1] and arguments[2]).
Pascal
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 31 August 2004 17:22
To: CF-Talk
Subject: [Spam?] Second Pair Of Eyes
Can anyone see
IS this what you want??
function showValues(theForm) {
var currVal = document.getElementById(ptotal);
var sum = 0;
for(var i=0;itheForm.elements.length;i++) {
if(theForm.elements[i].checked)
sum +=parseInt(theForm.elements[i].value);
}
alert(sum);
}
Pascal
-Original Message-
From:
Use regexp?
REReplaceNoCase(str,td width=1\s+/td,,all)
Pascal
-Original Message-
From: Josen Ruiseco [mailto:[EMAIL PROTECTED]
Sent: 31 August 2004 18:28
To: CF-Talk
Subject: CFHTTP and replace() on Multiple Lines
I am calling a document via cfhttp. I am replacing numerous lines
Not in CF5. That is where the problem was.
Pascal
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: 31 August 2004 18:40
To: CF-Talk
Subject: [Spam?] RE: Second Pair Of Eyes
Arguments is an array rather than a structure
If I recall correctly, the Arguments
1. REReplace(filename,\.\w+$,)
2. Replace(filename,_, ,all)
Pascal
-Original Message-
From: Mark Henderson [mailto:[EMAIL PROTECTED]
Sent: 30 August 2004 06:46
To: CF-Talk
Subject: [Spam?] Removing extensions from filelists
I'm currently attempting to incorporate the generation
I don't understand your question exactly, but here are some improvements
that come to mind:
1. USE CFQUERYPARAM !!!
2. Get rid of evaluate
3. Put the loop inside the cfquery (there will be one instead of 5
cfquery)
4. What is the lock for ???
cfquery datasource = #request.dsn# name=
NOT in cf5 it won't (variables became a struct in cf6). But you could
put your vars in a structure and then use that syntax.
Pascal
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: 12 August 2004 18:56
To: CF-Talk
Subject: Re: getting rid of Evaluate in CF 5.0
Find them here http://users.pandora.be/pascal.peters/download/
Pascal
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 12 August 2004 21:58
To: CF-Talk
Subject: RE: Document Icons
Pascal gave me a zip file that covers just about anything your web app
cfscript
lValues = ;
lDuplicates = ;
for(i=1;1 LE ArrayLen(request.arrayName);i=i+1){
if(ListFind(lValues,request.arrayName[i].pointValue))
lDuplicates = ListAppend(lDuplicates,i);
else
lValues =
ListAppend(lValues,request.arrayName[i].pointValue);
}
/cfscript
cfoutputIndexes containing
And the problem is ... ?
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: 11 August 2004 08:34
To: CF-Talk
Subject: scheduled task woes
havin some probs with this scheduled task running
its on a linux server and has been registered with the host too run
the
task
form action="" target=lowerframe
Pascal
-Original Message-
From: Bob Haroche [mailto:[EMAIL PROTECTED]
Sent: 11 August 2004 09:00
To: CF-Talk
Subject: Search Results within a Frameset
I have a search form on nearly every page in a site. Some of those
pages are the top nav page
1. check the admin to see if the scheduled task is actually there
2. check the scheduler log to see if the page runs correctly
3. Have some debug info in riverUpdate.cfm and set the scheduled task to
save the result as a file (using attributes publish=yes, path and
file).
Pascal
-Original
-Original Message-
From: Bob Haroche [mailto:[EMAIL PROTECTED]
Sent: 11 August 2004 16:23
To: CF-Talk
Subject: Re: Search Results within a Frameset
Pascal Peters wrote:
form action="" target=lowerframe
Yes, but what happens if the search form is used on a non-framese
How about storing the day they are displayed in the tips table
Get the first id that is larger than the id of the tip with the latest
date
If this doesn't exist, get the tip with the smallest id
Update the selected tip with today's date
Store the date and tip in the application scope
If the date
How about storing the day they are displayed in the tips table
Get the first id that is larger than the id of the tip with the latest
date
If this doesn't exist, get the tip with the smallest id
Update the selected tip with today's date
Store the date and tip in the application scope
If the date
You can only do new Option() from within the window that has the select.
Write a function to add the option in the opener and call it from the
popup.
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: 10 August 2004 12:23
To: CF-Talk
Subject: _javascript_
\{\w+(\.\w+)*\}
What do you mean by js functions?
Pascal
-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]
Sent: 10 August 2004 16:44
To: CF-Talk
Subject: looking for a regex
Hello
I'm looking for a regex that will identify items in a template file
along the
No it won't, there can't be a ( after the last word, it has to be a }
Pascal
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: 10 August 2004 16:53
To: CF-Talk
Subject: RE: looking for a regex
he means this regex will return things like
cfset t = CreateTime(0,0,0)
cfset end = DateAdd(d,1,t)
cfset step = 15
select
cfloop condition=DateCompare(t,end) LT 0
option value=#TimeFormat(t,'HH:mm:ss')##TimeFormat(t,'hh:mm
tt')#/option
cfset t = DateAdd(n,step,t)
/cfloop
/select
/cfoutput
Pascal
-Original Message-
From: Tony
REReplace(myvar,\D,,all)
-Original Message-
From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED]
Sent: 09 August 2004 04:24
To: CF-Talk
Subject: Re: Val function seems buggy
OK, I expected a bit too much from Val :), needed to get all the
digits
portion of a VAR.Thanks for
cfif FileExists(ExpandPath(image))
-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED]
Sent: 09 August 2004 16:54
To: CF-Talk
Subject: Getting an image.. before display
Imagine the situation.. you have thousands of records in a databse
that refer to some images, you loop
Simplified:
div
cfloop index=i from=1 to=#qTest.recordCount# step=2
#qTest.field[i]#br/
/cfloop
/div
div
cfloop index=i from=2 to=#qTest.recordCount# step=2
#qTest.field[i]#br/
/cfloop
/div
Pascal
-Original Message-
From: Marco Antonio C. Santos [mailto:[EMAIL PROTECTED]
Sent: 09
Actually, I reread my post and it doesn't do what he wants (yours does):
My code
News1 News2
News3 News4
News5 News6
Yours (this is what he asked for)
News1 News4
News2 News5
News3 News6
Pascal
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 09 August
script language=_javascript_
!--
win = window.open('anim.htm','waitWin','height=10,width=260');
win.focus();
//--
/script
cfflush
...
script language=_javascript_
!--
win.close();
//--
/script
Pascal
-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED]
Sent: 05 August 2004
Just to show off
REReplace(number,\.\d\d$,)
Pascal
-Original Message-
From: Ewok [mailto:[EMAIL PROTECTED]
Sent: 06 August 2004 02:58
To: CF-Talk
Subject: Re: trim numbers
any of these should do the trick
NumberFormat(number, 999,999)
-or-
ListFirst(number, .)
-or-
What is going wrong with round?? It works very well for me.
If you want to format afterwards, just use numberformat. What I also do
is use decimalformat and trim the trailing .xx .
So: ListFirst(DecimalFormat(Round(number)),.)
Pascal
-Original Message-
From: Mark Henderson
I can't back you up with data, but don't forget forms (value attributes
of input, option and content of textarea).
Pascal
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
Sent: 06 August 2004 06:10
To: CF-Talk
Subject: (OT?) White space and search engines
I'm
Write a function that accepts the file name and returns the appropriate
icon:
function Image(filename){
var ext = ;
var img = empty;
if(ListLen(filename,.) GT 1) ext = ListLast(filename,.);
else if(ListFindNoCase(doc,rtf,ext)) img = doc;
else if(ListFindNoCase(xls,csv,ext)) img = xls;
else
cfloop from=#query.recordCount# to=1 step=-1 index=i
#query.field[i]#
/cfloop
Pascal
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: 06 August 2004 17:51
To: CF-Talk
Subject: Desc Output
How can I output the results of the query starting from last record
You can't do it in CF, you have to do it in SQL. The easiest way would
be to create a (SQL) function that returns the proper value depending on
the media type.
Pascal
-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED]
Sent: 04 August 2004 17:02
To: CF-Talk
Subject:
I'm coming in late on this one, but I have 2 remarks on Jochem's
solution:
1. the dot doesn't need escaping in a character set. [ .-] should do it.
You hardly need escaping in sets as long as you choose the order of the
characters wisely.
2. I don't know if it matters, but the comment he made on (
This is not a bug, but an error in your code. You need 4 parameters for
createTmeSpan and you are only passing one (myTimeSpan):
1. Put the CreateTimeSpan function in your assignment:
myTimeSpan = CreateTimeSpan(0,0,2,0);
2. Create each parameter individually:
myTimeSpan = StructNew();
It doesn't do that for me, but you can just add cf-talk to your safe
recipients list.
Pascal
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: 03 August 2004 21:48
To: CF-Talk
Subject: Outlook moving messages to cf-talk to 'Junk E-mail' folder??
Anyone else
http://www.google.com/search?q=Rijndael+encryption+in+ColdFusion ???
-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]
Sent: 02 August 2004 17:16
To: CF-Talk
Subject: Rijndael Encryption in CF?
Anybody have any advice on implementing Rijndael encryption in
Or even better: USE CFQUERYPARAM
cfparam name=form.size1qty value=
...
cfquery ...
cfqueryparam cfsqltype=cf_sql_numeric value=#form.size1qty#
null=#YesNoFormat(NOT Len(form.size1qty))#
...
Pascal
-Original Message-
From: Robert Munn [mailto:[EMAIL
NO, CFQUERYPARAM
The cfparam is there because cfqueryparam can't handle the value
attribute if the variable doesn't exist (read my first post entirely)! I
want to insert null if the string is empty.
The point is you should always use cfqueryparam in your queries (as
discussed in about a hundred
Have you tried cf_sql_numeric ?
Pascal
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: 29 July 2004 16:33
To: CF-Talk
Subject: Problems with CFQUERYPARAM
Rick Root wrote:
I'm having a problem with an update query in a web service in which
the
update
You can't use cfqueryparam like this, it won't get evaluated. It has to
be in the cfquery.
cfquery datasource=media name=get_office
select office_id
from office
#request.filter#
where 0=0
cfif len(attributes.office_num)
and office_num in (cfqueryparam list='Yes'
I forgot to delete #request.filter# in the query below
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: 29 July 2004 17:23
To: CF-Talk
Subject: RE: Question about cfqueryparam
You can't use cfqueryparam like this, it won't get evaluated. It has
Those files have the mime-type application/octet-stream and this is
not in your list of accepted mime-types.
Pascal
-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: 28 July 2004 13:42
To: CF-Talk
Subject: mimetype - .log and .ini
When I try to upload either a
Sometimes I have more urgent things to do than to read and answer
cf-talk posts ;-)
Pascal
-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: 28 July 2004 17:14
To: CF-Talk
Subject: Re: mimetype - .log and .ini
that was simple. I was wondering why you've taken so
I ran your code and it worked perfectly. You don't even need the
rootelement tag (there is one). Make sure you don't suppress the output
somehow.
Pascal
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: 27 July 2004 12:07
To: CF-Talk
Subject: RE: XML load
SELECT*
FROM riders, races
WHERE riders.raceid = races.raceid
ORDER BY race_name
cfoutput query=qRaces grouprace_name
#qRaces.race_name# ...
cfoutput
#qRaces.ridername# ...
/cfoutput
/cfoutput
Also, don't do SELECT * but select the fields you need.
Pascal
-Original Message-
From:
SELECT DISTINCT q1.whatever
FROM q1, q2
WHERE q1.id = q2.id
AND q2.blah = 'blah'
Will do the same thing I think
Pascal
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: 27 July 2004 21:08
To: CF-Talk
Subject: Nested Query of Queries
Is it possible to do a nested QoQ
You can use cfwddx to create JS objects/arrays from CF variables. If you
use the query directly, you will need to have the JS wddx object in your
page. Find more info in the cf docs:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/xml51.htm
Pascal
-Original Message-
From: Kevin
Something like this:
cfquery name=q datasource=#dsn#
SELECT id, name, address,phone
FROM users
/cfquery
!--- Load the wddx.js file ---
script type=text/_javascript_ src="">
script
// Use WDDX to move from CFML data to _javascript_
cfwddx action="" input=#q# topLevelVariable=qj
function
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: 26 July 2004 13:59
To: CF-Talk
Subject: RE: HELP. CF and _javascript_ question
Something like this:
cfquery name=q datasource=#dsn#
SELECT id, name, address,phone
FROM users
/cfquery
!--- Load the wddx.js file
Does it actually have the string null??
In that case:
function ReplaceNull(val){
return (val==null)?:val;
}
...
f.addressLine2.value = ReplaceNull(qj.getField(i,addressLine2));
If it is the null value:
function ReplaceNull(val){
return (val==null)?:val;
}
Pascal
-Original Message-
Readonly will allow the focus. It will not be editable (and is not
supported by all browsers). You can use disabled, but that means the
value will not be sent to the action page (no form variable will be
created). If you need to pass it to the action page, you can make a
disabled text field and a
window.opener.location.reload(true); window.close();
Pascal
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: 19 July 2004 18:59
To: CF-Talk
Subject: OT: _javascript_ window
This was touched on before slightly. I have a pop-up that upon closing I
would like
You have to set Report Execution Times Using the following output
mode to tree
Pascal
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: 17 July 2004 04:22
To: CF-Talk
Subject: Re: Dinowitz_Debug
On Fri, 16 Jul 2004 19:36:29 -0400, Michael Dinowitz wrote:
In administrator - System information
You should install CFMX6.1 (If it doesn't say Version 6,1,0,) and
then apply the hotfixes for 6.1.
Pascal
-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: 16 July 2004 13:00
To: CF-Talk
Subject: Re: cfmx hot fixes
Hi
Just apply all the hotfixes for CFMX6.1 Standard for your OS.
-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: 16 July 2004 13:02
To: CF-Talk
Subject: Re: cfmx hot fixes
This is the System Information displayed in cf administrator
System Information
Server
Really hard to say without the cfoutput query
You should do an
ORDER BY eventYear, eventMonth, iteccourse.coursestart asc
And then
cfoutput query=getevents group=eventYear
#getevents.eventYear#br/
cfoutput group=eventMonth
#getevents.eventMonth#br/
cfoutput
#getevents.coursetitle#...br/
AFAIK they didn't
-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: 16 July 2004 13:16
To: CF-Talk
Subject: Re: cfmx hot fixes
ok, I shall do that. But just clarify something.. Have macromedia not
released any 'updater versions' for 6.1? Becuase I don't beleive
You are grouping on coursestart, so it groups on a date (year, month AND
day). Follow the instructions in my previous post.
Pascal
-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: 16 July 2004 13:48
To: CF-Talk
Subject: RE: Problem with SQL WHERE clause and CF
No, But you could use QofQ to sort it afterwards.
OR create a New query, add your rows and then add the original query's
rows
Pascal
-Original Message-
From: Todd [mailto:[EMAIL PROTECTED]
Sent: 16 July 2004 15:09
To: CF-Talk
Subject: Adding rows to a query
QueryAddRow() adds 1
When they vote (don't do a cflocation afterwards!!):
cfcookie name=Gerrard value=done expires=never
Before they vote:
cfif IsDefined(cookie.Gerrard) AND cookie.Gerrard IS done
... don't query the db
cfelse
... query the db
/cfif
Pascal
-Original Message-
From: Asim Manzur
I stand corrected! I still do most development for CF4.5 or CF5 so this
was a natural reaction for me. It won't happen again.
If you are not using CFMX: don't do a cflocation after a cfcookie.
Pascal
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: 16 July 2004
Yes it is compatible
Pascal
-Original Message-
From: Daniel Farmer [mailto:[EMAIL PROTECTED]
Sent: 16 July 2004 20:26
To: CF-Talk
Subject: Re: solutions for code resuse inside the cferror tags ...
Thanks Dave, I did think about using cferror type=exception, was
wondering if that
It shouldn't. The only thing I can think of is that you are in a
cfoutput/cfloop query and that QBarcode is one of your fields. If this
is the case, the problem should disappear if you use the proper prefixes
for your variables!
Pascal
-Original Message-
From: James Smith
I don't know mysql, but if it is a long data type you have to check
Enable long text retrieval in the advanced settings of the data source
in the CF Administrator
Pascal
-Original Message-
From: Asif Rashid [mailto:[EMAIL PROTECTED]
Sent: 14 July 2004 14:39
To: CF-Talk
Subject: CFMX
Do you get the same directory in the output?? ExpandPath will start from
the file called in the request, NOT the file where the function is
called. It is not necessarily the same file (or even in the same
directory). Also, you can do ExpandPath(./) to get the directory
directly.
Pascal
Some more info or some code would be good!
Pascal
-Original Message-
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 12:18
To: CF-Talk
Subject: dynamic insert query
Just wondering how I can go about building a dynamic insert query
???
I need to loop over a
#trim(form[qty i])#
Don't use evaluate if you don't have to.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 15:05
To: CF-Talk
Subject: outputting variable
I tried: #trim(form.qty#i#)# but it does not work. Somewhere I read
the
[Todays
If you're on cf5 or less then you probably (because I can't remember
if
form scope is in a struct in CF5) need to use the following evaluate
in
the value field of the input rather than the structure reference :
#evaluate(form.thisFieldName)#
[Pascal Peters]
Form vars (and some other
I am not used to participate in OT discussions, but I just wanted to say
that a lot of people on this list don't speak or write English natively.
For me, English is only my third language, but I try to write it
correctly. It doesn't amuse me if others make comments like this on the
list. I didn't
i ColdFusion was
unable
to determine the value of the parameter.
On the bottom of the page, however, the form field for qty appears
correctly:
Form Fields:
QTY1=12
QTY2=13
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 13, 2004 9:27 AM
You can't know if cookies are enabled from the server. Als, using
session vars won't help much because they use cookies.
If you are on CFMX:
- Store info in session vars
- Keep session alive for users without cookies by using the
URLSessionFormat() function on every url in your application and
an idea. If they don't exist, it is *likely* that
cookies are blocked.
Pascal
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 16:15
To: CF-Talk
Subject: Re: Checking if cookies are disabled in the browser
Pascal Peters wrote:
You can't know
textarealt;!--- some comment ---gt;
lt;cfparam name=quot;attributes.contentquot;
type=quot;stuctquot;gt;/textarea
Pascal
-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 17:06
To: CF-Talk
Subject: How to display coldfusion code in a text area
Hi all
I'm having the same problem this evening.
-Original Message-
From: G [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 17:44
To: CF-Talk
Subject: Re-appearing posts?
Am I losing my mind, or are old posts re-appearing on the list as new
this
morning?
[Todays Threads]
[This
If this is for form vars:
cfset checkExists = plan_to_attend,contact,alumnimember
cfloop list=#variables.checkExists# index=i
cfif IsDefined(form.#i#)
cfset form[i] = 1
cfelse
cfset form[i] = 0
/cfif
/cfloop
Pascal
PS You could also use StructKeyExists instead of IsDefined, but that has
If this is the actual code you are using, you are creating an infinite
loop because you always start looking at the start position 1 in your
REFind. It will keep matching the first {}.
It really depends what you are trying to grab. If you are trying to get
only the inner parentheses it is not too
201 - 300 of 1018 matches
Mail list logo