Ascension day.
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: vrijdag 21 mei 2004 3:07
To: CF-Talk
Subject: RE: SQL HELP!
what holiday?
tony
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
qProduct.field[theRowIWant]
-Original Message-
From: Nando [mailto:[EMAIL PROTECTED]
Sent: vrijdag 21 mei 2004 13:11
To: CF-Talk
Subject: Selecting by row or CurrentRow
Could someone remind me of the syntax to select by row? I
don't remember where to find that. Thanx
Select
Just add it after the FROM clause. Also keep in mind that if you use
all * in the SELECT clause, you won't be able to access all names in CF.
You have to use aliasses for the names
SELECT stuff.*,
person1.first_name AS first_name1, person1.last_name AS last_name1,
person2.first_name AS
the list quick?
- Original Message -
From: Pascal Peters
To: CF-Talk
Sent: Thursday, May 20, 2004 4:22 AM
Subject: RE: SQL HELP!
Just add it after the FROM clause. Also keep in mind that if you use
all * in the SELECT clause, you won't be able to access all
names in CF.
You have to use
Nathan,
I don't know if you have a correct server side solution yet. Since it's
a holiday here in Belgium (so I have a little time), I took a shot at
it. I didn't start from any of the other solutions posted, but wrote my
own:
cfscript
function ListToRanges(list){
var a = ListToArray(list);
The principle is ok, but there is one catch: you can't do a new
Option() for a select that is in another page. Instead, write a
function in the original page to add an option and call that from the
popup.
function addOpt(text,value){
var opts = document.formname.selectname.options;
(to use and recommend in my classes), but
it has a hard time getting to Belgium so I haven't read it yet. There is
also http://www.regular-expressions.info/ as an online resource.
Pascal Peters
Certified ColdFusion MX Advanced Developer
Macromedia Certified Instructor
LR Technologies
Av. E. De Mot
#trim(form[qty count])#
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: woensdag 19 mei 2004 16:37
To: CF-Talk
Subject: passing a form field
How do I pass a form field which is dynamic. I have
qty#count# as the qunatity field. How do I pass this in a
Do you need to pass it like this or can you transform the list on the
server to make the ranges? Is the list always in numerical order?
-Original Message-
From: Nathan R. Jessop [mailto:[EMAIL PROTECTED]
Sent: woensdag 19 mei 2004 17:00
To: CF-Talk
Subject: re: Arrange sequential
Rename your select filelistselect,
create a hidden field named filelist
and call this JS function in the onsubmit of the form:
function makeList(thisform){
var opts = thisform.filelistselect.options,
val=,
i=0;
for(;iopts.length;i++){
if(opts[i].selected){
if(i==0 ||
Form.qty2 doesn't exist.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: woensdag 19 mei 2004 17:45
To: CF-Talk
Subject: RE: passing a form field
Thanks Doug and Pascal.
Why though do I get this error?
An error occurred while evaluating the _expression_:
The hidden field doesn't need a value and can't be in the select. The
reason that you are not seeing the correct value in the actionpage is
that you don't call the function correctly in the onsubmit or that there
is an error in the function. Maybe a wrong case somewhere. JS is case
sensitive. I've
On CFMX
stTmp = REFindNoCase('msg:(.*?);',str,1,true);
if(stTmp.pos[1]){
message = Mid(str,stTmp.pos[2],stTmp.len[2]);
}
else {
message = ;
}
ON CF5
stTmp = REFindNoCase('msg:(([^]|[^;])*);',str,1,true);
if(stTmp.pos[1]){
message = Mid(str,stTmp.pos[2],stTmp.len[2]);
}
else {
message = ;
}
ON CF5
cfscript
start = 1;
aLog = ArrayNew(1);
commentRegexp = [*]{3}[[:space:]]+([^*]*)[[:space:]]+[*]{3};
timestampRegexp =
[0-9]{1,2}/[0-9]{2}/[0-9]{4}[[:space:]]+[0-9]{2}:[0-9]{2}:[0-9]{2};
while(true){
stTmp = REFind(commentRegexp,str,start,true);
if(stTmp.pos[1]){
stLog = StructNew();
Just a shot in the dark, but couldn't CF misinterpret the var get. It
looks like it's seeing it as something else. Did you try dumping get?
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: dinsdag 18 mei 2004 5:44
To: CF-Talk
Subject: brain fart on #'s
what the
Using cfdirectory action="" directory=qList ... returns a query,
not a list. You should use it as a query. If you absolutly want a list
you can do ValueList(qList.name). Be aware that it also lists
directories. If you use a filter as you do, this shouldn't be a problem.
Pascal
-Original
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]
Sent: dinsdag 18 mei 2004 12:38
To: CF-Talk
Subject: Re: help with string manipulation (Find,Replace)
You end up with a nice wee query of all the log entries for a
Do you mean that queries are easier than arrays
Did you dump get??
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: dinsdag 18 mei 2004 15:59
To: CF-Talk
Subject: what am I doing wrong (#'s question)
what the heck am I doing wrong?
brain fart on the:
get.companyIdNumber[request.nextRecord]
part of
cfscript
stTmp =
REFind([*]{3}[[:space:]]+([^*]+)[[:space:]]+[*]{3},str,1,true);
info = Mid(str,stTmp.pos[2],stTmp.len(2);
/cfscript
cfoutputspan class=time#info#/span/cfoutput
-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: vrijdag 14 mei 2004 17:07
To: CF-Talk
cfscript
stTmp =
REFind([*]{3}([^*]+)([0-9]{1,2}/[0-9]{1,2}/[0-9]{4})[[:space:]]+([0-9]{
1,2}:[0-9]{1,2}:[0-9]{1,2})([^*]+)[*]{3},str,1,true);
user1 = Mid(str,stTmp.pos[2],stTmp.len[2]);
date = Mid(str,stTmp.pos[3],stTmp.len[3]);
time = Mid(str,stTmp.pos[4],stTmp.len[4]);
user2 =
cfscript
start = 1;
aLog = ArrayNew(1);
while(true){
stTmp =
REFind([*]{3}([^*]*[[:space:]])([0-9]{1,2}/[0-9]{1,2}/[0-9]{4})[[:space
:]]+([0-9]{1,2}:[0-9]{1,2}:[0-9]{1,2})([[:space:]][^*]*)[*]{3},str,star
t,true);
if(stTmp.pos[1]){
stLog = StructNew();
stLog = StructNew();
user1 =
It's like a flat file. (a huge comment field in the DB).
Storing the comments in a related table would have made his life easier,
but I don't think he can change the way the data is stored.
-Original Message-
From: Bartlett, Robert E. USNUNK NAVAIR 1490, 54-L4
[mailto:[EMAIL
If your format isn't always the same (*** user timestamp *** OR ***
timestamp user ***) you can't use my code. You need to do it in a
different way. I can help if you want, but if you keep changing the
specs it's not very easy. Also, remind me what version you are on. I'm
writing CF5 regexp for
I'm off to home right now, but I'll send you the code in the morning
(for me GMT+2)
-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: maandag 17 mei 2004 17:15
To: CF-Talk
Subject: Re: help with string manipulation (Find,Replace)
sorry Pascal, my bad. The format
should always use the prefixes when referencing variables
(if they have one).
Pascal Peters
Certified ColdFusion MX Advanced Developer
Macromedia Certified Instructor
LR Technologies
Av. E. De Mot, 19
1000 BRUSSELS, BELGIUM
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe
You can't use cftags in templates called by cferror type validation or
request. You can for types monitor and exception. If the template
throws an error, it is simply bypassed and you see the normal cf error
(You can avoid this by using try/catch wisely in your error template).
This has been like
Still wrong: see my previous post
-Original Message-
From: Robert Redpath [mailto:[EMAIL PROTECTED]
Sent: woensdag 12 mei 2004 16:03
To: CF-Talk
Subject: RE: good error.cfm template
That must be what I was remembering..cferror = no cfmail
[Todays Threads]
[This Message]
According to cfmlhistory the cferror tag has been around since cf4.0.1
The type monitor is deprecated in cf6.0+
The type exception (full use of cf tags) was introduced in cf4.5.0
The types validation and request exist since cf4.0.1
I can't tell about earlier versions as I didn't use them and
Is it possible to find a named anchor passed in the url (if there is
one) in ColdFusion?
Pascal Peters
Certified ColdFusion MX Advanced Developer
Macromedia Certified Instructor
LR Technologies
Av. E. De Mot, 19
1000 BRUSSELS, BELGIUM
[Todays Threads]
[This Message]
[Subscription]
[Fast
Use level to determine the output
SELECT *, LEVEL
FROM NAVMENU
START WITH MNUPARENT = 0
CONNECT BY PRIOR MNUPARENT=MNUCHILD
cfoutput query=qMenu...
#RepeatString(- ,qMenu.level)# #qMenu.MNUDISP#br
/cfoutput
This is simple, but you can do more complicated things by using level
-Original
: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Friday, May 07, 2004 9:14 AM
To: CF-Talk
Subject: RE: grouping output
Use level to determine the output
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
This has been around much longer. If I recall correctly it was
introduced in CF 4.0.1
-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED]
Sent: dinsdag 4 mei 2004 22:52
To: CF-Talk
Subject: Re: Form button
Original Message:
From: Dave Francis
Date: Tue, 4 May 2004
cfif ListFindNoCase(Company,location,execBios,url.page)
-Original Message-
From: Shawn Contreras [mailto:[EMAIL PROTECTED]
Sent: dinsdag 4 mei 2004 5:47
To: CF-Talk
Subject: Re: Navigating pages and displaying an image
equaling the page
OK, here's what I got and it appears to
Are you sure it's because of that. It should escape quotes in a variable
within cfquery. But in any case, use cfqueryparam
Pascal
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: vrijdag 23 april 2004 16:18
To: CF-Talk
Subject: Inserting Comma in DB
Hi
People always seem to recommend Preservesinglequotes for that problem
and this is plain wrong. PreserveSingleQuotes does exactly the opposite
of what you are trying to achieve. It stops cf from escaping single
quotes in vars within a cfquery.
Pascal
-Original Message-
From: Tangorre,
In cf5:
newstring = rereplace(string, [^(]*(\(.*\)).*, \1);
Note that this will return the entire string if there is no parentheses.
You could do it in two steps to avoid that
newstring = ;
stTmp = REFind(\(.*\),string,1,true);
if(stTmp.pos[1]) newstring = Mid(string,stTmp.pos[1],stTmp.len[1]);
What do you mean by not holding? They timeout immediately or after less
than 2 hours? Did you look at the maximum timeout in the administrator?
Pascal
-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: maandag 19 april 2004 21:48
To: CF-Talk
Subject: Session
You have to name the window you open and specify the target in your form.
SCRIPT LANGUAGE=_javascript_ TYPE=text/_javascript_
!--
function Popup(){
var win = window.open(blank.html, form_popup , toolbar=no,scrollbars=yes,width=400,height=300,resizable=yes);
win.focus();
return true;
}
//--
Deanna,
cfset capText = REReplace(text,\b(\w+(\(e?s\))?),\u\1,ALL)
Pascal
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: maandag 19 april 2004 23:00
To: CF-Talk
Subject: Re: CapFirst UDF
Pascal,
Very sweet. But, is there any way to say unless the
didn't happen.
Any other help would be appreciated. This needs to work on
both CFMX and CF5.0.
Jeff
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 3:16 AM
To: CF-Talk
Subject: RE: Odd RegEx question.
In cf5:
newstring
2 options I think:
1. If you can modify the query, you could use ValueList().
cfquery name=GetImages datasource=#request.dsn#
SELECT '../thumbs/' + thumbfile AS thumbpath, ...
/cfquery
cfset ListImages = ValueList(GetImages.thumbpath)
(concatenator may be different depending on database!)
2. If
If you are on MX, it is really easy. On CF5 it's a bit more work (mail
me if you need that version).
cfset capText = REReplace(text,\b(\w),\u\1,ALL)
I didn't test because I'm working on cf5 right now, but it should work.
Pascal
-Original Message-
From: Deanna Schneider
ct
input type=submit name=submit value= Consultar
/cfform
Pascal Peters
Certified ColdFusion MX Advanced Developer
Macromedia Certified Instructor
LR Technologies
Av. E. De Mot, 19
1000 BRUSSELS, BELGIUM
Tel: +32 2 639 68 70
Fax: +32 2 639 68 99
Email: [EMAIL PROTECTED]
Web: www.lrt.be
-Ori
explained and my Spanish isn't very good, but I will take a
Obviously my Spanish is very bad and my Portugeze is even worse ;-)
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Use
WHERE MONTH(maint_report_date) = cfqueryparam
cfsqltype=cf_sql_integer value=#Month(Now())#
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: vrijdag 16 april 2004 14:47
To: CF-Talk
Subject: RE: Query date
Thanks Jochem. I still get an error. See below:
On Unix, Application.cfm has to be with a capital A
Your host is probably using a nix machine
-Original Message-
From: Wurst, Keith D. [mailto:[EMAIL PROTECTED]
Sent: donderdag 15 april 2004 14:02
To: CF-Talk
Subject: Application.cfm vs. application.cfm
hey everyone. i just
You can not do it without calling a CF template, but you can do it
without refreshing your screen. Create a hidden frame to handle requests
to the server without refreshing the current screen. Call the template
to update the record in that hidden frame.
Pascal
-Original Message-
From:
It looks like it rounds the number. Try
#NumberFormat(abs(getRate.Rate),'_.__')#
-Original Message-
From: Kristen Winsor [mailto:[EMAIL PROTECTED]
Sent: dinsdag 13 april 2004 15:16
To: CF-Talk
Subject: Using ABS in CF 5
Why would 3E-005be shown when using
document.theForm.shippingState.selectedIndex =
document.theForm.billingState.selectedIndex;
Assuming your two selects have the same options
Pascal
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: dinsdag 13 april 2004 15:44
To: CF-Talk
Subject: SOT: JS select
Stored Procedures?
-Original Message-
From: Earl, George [mailto:[EMAIL PROTECTED]
Sent: dinsdag 13 april 2004 16:40
To: CF-Talk
Subject: How to streamline a request that uses many cfquery
statements?
This feels like a dumb question, but here goes . . .
Am I correct that in
cfquery name=qTest datasource=#request.dsn#
SELECT theTitle, theDate
FROM theTable
ORDER BY theDate
/cfquery
cfoutput query=qTest group=theDate
== #DateFormat(qTest.theDate, d)# ==br
cfoutput
- #qTest.theTitle#br
/cfoutput
/cfoutput
Pascal
-Original Message-
From: Jake McKee
-Original Message-
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: zondag 28 maart 2004 3:22
To: CF-Talk
Subject: Re: Query Output in a cfscript
Yes, but I'm not trying to actually 'write' the data to a
page at this point. I only want to create the color objects
I suppose this is on IE? I wouldn't try that on another browser (HTML
not valid). Also you need to take empty cells into account at the end of
the table (if there are only nine records for example).
This code will work with any number of columns in the table and any
number of records in your
No, just do (not tested)
cfif IsDefined(form.cfid) AND IsDefined(form.cftoken) AND NOT
(IsDefined(url.cfid) AND IsDefined(url.cftoken))
cfset url.cfid = form.cfid
cfset url.cftoken = form.cftoken
/cfif
cfapplication ...
But do you have control over the sending page (form)? If you do, I would
This could be related to the charset. Are you using utf-8? Can you post
the code for the url and where it comes out wrong? You can mail me
templates off-list if you want to.
Pascal
-Original Message-
From: stylo stylo [mailto:[EMAIL PROTECTED]
Sent: vrijdag 2 april 2004 11:58
To:
cfscript
text = ;
crlf = chr(13) chr(10);
delim = [EMAIL PROTECTED];
start = 1;
cont = true;
fOutput = Replace(fOutput,crlf,chr(10),ALL);
while(cont){
end = Find(delim,fOutput,start);
if(NOT end){
end = Len(fOutput);
cont = false;
}
line = Mid(fOutput,start,end-start);
start = end +
this weekend I will write some code for you. It's easter holidays here and we are leaving on vacation, so I don't know if I will be able to do it. I will be back on the list in a week.
Pascal Peters
Certified ColdFusion MX Advanced Developer
Macromedia Certified Instructor
LR Technologies
Av. E. De Mot
^ start of string
\s* any number of whitespace (spaces, tabs, newlines,...)
( start group (for back reference)
[*]{3} three stars
.+? one or more characters (non greedy match: untill first
match of what comes next)
[*]{3} three stars
.+? one or more characters (non greedy match: untill first
Are you using CF mappings? If you didn't change those it will include
the files from the previous site when you use them.
Are you using the application and session scope to store info? Be sure
to change the name attribute of cfapplication
Pascal
-Original Message-
From: A.Little
][currentRow]#/cfoutput
And I think that for most developers, the output of your test is just as
it should be. I think you should never rely on the order of evaluation
for unscoped vars. ALWAYS scope or you will run into trouble sometime.
Pascal Peters
Certified ColdFusion MX Advanced Developer
This would work if you were looking for a natural number (is this the
term in English: positive integer).
Integer would be
cfif REFind(^[-+]?[0-9]+$,val)
integer
cfelse
not an integer
/cfif
But of course there is a udf on cflib as usual (as Tony already pointed
out)
Pascal
-Original
cfsavecontent variable=str
*** 13/01/200309:47:06TUser1 ***
callno:1126
Some comment1
*** 13/01/200308:30:27TUser2 ***
Some Comment2
/cfsavecontent
cfscript
regexp = ^\s*([*]{3}.+?[*]{3}.+?)\s*(?:[*]{3}.*)?$;
str2 = REReplace(str,regexp,\1);
/cfscript
cfoutputpre#str2#/pre/cfoutput
This
thats true, but there's nothing to stop you copying
form.cfid and form.
token into into the URL scope, and this will do the trick
as long as
its before the the CFapplication tag.
Hmm. How do I ensure it's before the application? It's called
first automatically, no?
NO. You have to
What version of CF?
-Original Message-
From: ScootrS [mailto:[EMAIL PROTECTED]
Sent: dinsdag 30 maart 2004 9:51
To: CF-Talk
Subject: urlencode mangling accented letters
I need to urlencode something. When it involves an accented
letter, the letter comes out mangled as a series
Actually, those 2 lines were meant to replace the cfif's too. You can
replace the whole block by my code (but test it anyway!!).
For your other problem, I see two possibilities:
1. You are using HTMLEditFormat() to display in the textarea. It
replaces CR/LF. Just create a UDF that replaces ,,,
This is for display in HTML, not in a textarea. The p tags would show
and everything would be on one line
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: dinsdag 30 maart 2004 14:22
To: CF-Talk
Subject: RE: help with string manipulation (Find,Replace)
I've always found cfupdate/cfinsert to lack flexibility. Stick to
cfquery.
I haven't seen any CT's to replace the tags btw
Pascal
-Original Message-
From: Marlon Moyer [mailto:[EMAIL PROTECTED]
Sent: maandag 29 maart 2004 23:58
To: CF-Talk
Subject: Replacement for CFUpdate
To do what? Show me the code of your textarea and any code manipulating
the string you display in it and I will try to give you the solution
Pascal
-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: dinsdag 30 maart 2004 14:23
To: CF-Talk
Subject: Re: help with
Write a udf: if the Len() is 1, pad with 0. You can even include the
formatbaseN in the UDF
Pascal
-Original Message-
From: Michael Kear [mailto:[EMAIL PROTECTED]
Sent: dinsdag 30 maart 2004 15:13
To: CF-Talk
Subject: function for decimal to hex and back?
Is there a function to
Don't write it:
http://www.cflib.org/udf.cfm?ID=339
http://www.cflib.org/udf.cfm?ID=340
Pascal
-Original Message-
From: Pascal Peters
Sent: dinsdag 30 maart 2004 15:38
To: CF-Talk
Subject: RE: function for decimal to hex and back?
Write a udf: if the Len() is 1, pad with 0
I think cfqueryparam cfsqltype=CF_SQL_MONEY value=#form.val#
I am not sure. I always use a number to store prices
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: dinsdag 30 maart 2004 17:13
To: CF-Talk
Subject: Money Format in SQL 2000
What's the best way to
SET percentage = cfqueryparam cfsqltype=CF_SQL_NUMERIC
value=#form.percentage# ,
discountprice = price
WHERE ...
Assuming your percentage is numeric. I see you have quotes around it, so
mayby it's a varchar (CF_SQL_VARCHAR)
Don't forget the WHERE clause or you will update all records in the
)
CFQUERY name=change datasource=printprices Update
bookinfo cfqueryparam cfsqltype=CF_SQL_NUMERIC
value=#form.percentage# , discountprice = price Where
bookid = 4 /cfquery done /cfif
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 10:38 AM
What version of CF? What is the code to put the database content in the
textarea? How is it converted?
-Original Message-
From: Colin Wilson [mailto:[EMAIL PROTECTED]
Sent: dinsdag 30 maart 2004 22:53
To: CF-Talk
Subject: Character conversion with textareas
Hi,
I've been
On CFMX only
// replaces whitespace and date/time before first comment
str = REReplace(str,^\s*([*]{3}.*?[*]{3})?\s*,);
// Replaces everything starting from next ***
str = REReplace(str,^(.*?)\s*[*]{3}.*$,\1);
NOT tested, I don't have CFMX running at the moment
Pascal
-Original
Won't work. You can't have a column in the order by that is not in the
group by and TOP 1 only returns the first record, not the first record
for each articlIssueID. I started by replying to this mail this morning
thinking this should be easy, but I didn't find a solution. I
discussed it with my
This is also what we came up with, but it means that if you have 10
issues and 1000 articles, you have to retreive 1000 records to show 10
articles. The Order by clause would have to be
WHERE articleIssueID, articleDate DESC
I can't see how the second solution would help.
Pascal
Did you have CFID and CFTOKEN as cookies too? I think CF will take those
before it looks at the form scope. It would be fairly easy to have some
tests to see what is accepted first. Have the cookies set and have url
and form vars passed to the test page. See what session picks up.
Pascal
Is this a many-to-many relationship (related table)? What I do then is
delete all the colors related to the item and then insert all the ones
selected.
If you don't want to do that, you can pass the original colors as a
hidden value (or select them again in the action page) and make the
If you have one column of a recordset you want to convert to an array,
you can do
ListToArray(Valuelist(qQuery.Column,~),~)
-Original Message-
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED]
Sent: zondag 28 maart 2004 1:56
To: CF-Talk
Subject: Query Output in a cfscript
I have
This means your css files have to be treated by cf, which will slow them
down. An alternative would be to have different css files for different
browsers and declare the css to load as a variable in your app. It will
have the same result and the css files are not parsed by cf. I usually
have a
You are replacing with the text chr(13) chr(10) and not the
characters (CR/LF). It should be one of the following:
cfset Commentary = replace(Commentary,|. ,|. chr(13) chr(10),
ALL)
cfset Commentary = replace(Commentary,|. ,|. #chr(13)##chr(10)#,
ALL)
Pascal
-Original Message-
If you want the last record inserted (even if it was yesterday)
SELECT TOP 1 side_1_comments
FROM status
ORDER BY id DESC
If you want the last record inserted today
SELECT TOP 1 side_1_comments
FROM status
WHERE datechanged = '#DateFormat(Now(), mm/dd/)#'
ORDER BY id DESC
This is assuming
Because before cfmx, structures in CF couldn't preserve the case of the
keys. So when you convert it to js, they needed a consistent way of
creating property names. They chose lower case. They really didn't have
the option to keep your original case.
Bottom line: CF is case insensitive and
This can be done with a LIKE, but it is very inefficient. If you have
the option to modify the db, I would. Replace all lists by related
tables!! It would make this kind of operation very easy.
Now, as I know people don't like to hear: change the db, because
sometimes they can't: here is the
Not this way, but if you are on CFMX, you could do this in your
application.cfm:
cfif test IS session
cfset clientScope = session
cfelse
cfset clientScope = client
/cfif
And in your code
cfset clientScope.var = whatever
cfoutput#clientScope.var#/cfoutput
NOT tested, but it should work. On
You can't use CF functions on a database column. Convert the current
date to the format of the date in your text field:
WHERE prDateSubmitted = cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#Dateformat(Now(),'your mask here')#
Pascal
-Original Message-
From: tony [mailto:[EMAIL
AFAIK cookie, url and form scope are checked
-Oorspronkelijk bericht-
Van: ScootrS [mailto:[EMAIL PROTECTED]
Verzonden: vr 26/03/2004 18:35
Aan: CF-Talk
CC:
Onderwerp: form.cfid checked before a new cfid assigned?
I assume form scope is checked for a cfid first before
a
In 6.1 I can't see a difference for application scope.
Of course there is a difference between
IsDefined(attributes.MyVar)
And
structKeyExists(attributes, MyVar)
As the attributes scope doesn't always exist.
Pascal
-Original Message-
From: Conan Saunders [mailto:[EMAIL PROTECTED]
Alex,
I'm no webserver expert, but can't you just remove the .cfm and .dbm
filters from the application settings of the old site in IIS. I think cf
will no longer treat the request then and you will be redirected in the
same way as for the other files
Pascal
-Original Message-
From:
REReplace(str,[[:alpha:]] ,,all) to strip alphas
If you only want to keep digits:
REReplace(str,[^0-9] ,,all)
But in your example, it would output 77450934 and not 450934
Pascal
-Original Message-
From: brobborb [mailto:[EMAIL PROTECTED]
Sent: dinsdag 23 maart 2004 23:10
To:
Les,
I don't think it is possible, as the post doesn't make a difference
between a select or a text when it arrives on the server. Are you 100%
sure it is identical and there is no typo or whitespace in the text.
First, trim all form variables. If this doesn't solve it, you can test
by having
It's ok to be anal, but don't overcomplicate.
cfset yourNewString =
REReplace(yourOldString,[[:space:]]*,[[:space:]]*,, ,all)
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: maandag 22 maart 2004 5:45
To: CF-Talk
Subject: RE: Add spaces to a text string
or to
He uses SQL Server over ODBC (it's in the error message). Doing what you
suggest will not work here, because he needs the time (maybe date
time) and not the date. Now() returns date time in ODBC format!
I have no idea what is going wrong, but try using cfqueryparam to
eliminate any data
) in the template file
D:\INETPUB\WWWROOT\FUNDMANAGER\ADMIN\FUND\ACT_UPDATESTOCK.CFM.
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: 22 March 2004 11:43
To: CF-Talk
Subject: RE: db error
He uses SQL Server over ODBC (it's in the error message).
Doing what
text = REReplace(text,((#chr(13)#?#chr(10)#)\2)\2+,\1,ALL)
Takes care of windows cr/lf and unix lf.
If you want to include mac cr:
text =
REReplace(text,((#chr(13)#?#chr(10)#|#chr(13)#)\2)\2+,\1,ALL)
should do it, but not tested.
Pascal
-Original Message-
From: Critter
Just use HTMLEditFormat when you put the hidden value in. The form post
should remove the HTML codes and put the original characters back in.
Form:
input type=hidden name=foo
value=#HTMLEditFormat(Encrypt(myvalue,mykey))#
Action:
cfset myvalue = Decrypt(form.foo,mykey)
Pascal
-Original
This will only work on MX. The thing that is going wrong is that CF is
including Line feed in . (most regexp engines aren't). You are better
off treating the string as a list with chr(10) chr(13) as the
delimiters. This will also work in older versions of CF.
-Original Message-
From:
I don't know if it will solve anything, but the cfheader should be
cfheader name=content-disposition value=inline; filename=B605.pdf
If you want to open the file in the browser. To download it (save as
dialog) I use
cfheader name=content-disposition value=attachment;
filename=B605.pdf
Pascal
queryname['Pretty Field Name'][queryname.currentRow]
-Original Message-
From: Craig Earls [mailto:[EMAIL PROTECTED]
Sent: zaterdag 20 maart 2004 3:50
To: CF-Talk
Subject: Queries with pretty column names
I have some CFCs that return queries to a flash app for use
in a
501 - 600 of 1018 matches
Mail list logo
