This is not exactly what you are trying to say:
[^{^}] == anything but { or } or ^
Correct: [^{}]
Pascal
PS Give the REReplace with the backreferencing (see my previous post) a
shot. It is only 1 line to do the same thing.
-Original Message-
From: Paul Vernon [mailto:[EMAIL
QueryAddRow QuerySetCell
Pascal
-Original Message-
From: Dan Farmer [mailto:[EMAIL PROTECTED]
Sent: 13 July 2004 18:55
To: CF-Talk
Subject: adding a record to a query object
I have a query that I wish to add to in the second position. Say if I
wanted
to add a second element
Don't do the replace, just don't include the {} in the REreplace.
Although I may have overlooked something: You really should do a
URLEncodedFormat() of the word (which doesn't work with the
backreferencing).
function MakeLinks(text,dictionary){
var st = StructNew();
var start = 1;
var word =
There is no WHERE clause here, you are adding a new record
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: 09 July 2004 15:18
To: CF-Talk
Subject: SOT: keyword 'Where' error
Is there a problem with this Insert? I get an Incorrect syntax near
the
keyword
The answer is (w{3})? , but in your case: why bother?
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: 03 July 2004 05:52
To: CF-Talk
Subject: RE: Regex help
How would I say
Www is optional?
var linkRE = /^https?\:\/\/[wW]{3}?/;
[Todays Threads]
There are so many different formats that maybe the best approach is just
to look for the protocol? Something like:
linkRE = /^https?:\/\/\S+$/i;
If the link is not correct, they will see it in the new window! If you
have the CF advanced book, Ben had a regexp to check url's that took
care of
Using CF, it is not a very good idea NOT to have an Application.cfm, as
you can't prevent CF from executing the nearest one it can find. If you
don't want to use it, just have one with nothing (well, at least a
return) in it in the root folder of your application.
Pascal
-Original
Watch out with newline characters. If it is coming from windows, there
will also be return characters. I usually do a REReplace of \r\n by
chr(10) first. If you work in multiline mode, it will work correctly.
Multiline mode is not necessary in your first regexp.
-Original Message-
From:
The regexp for this would be (Not tested):
=STAMP:\s+(\d{4}/\d{2}/\d{2}\s+\d{2}:\d{2}/:d{2}).?*\n(.*?)
\s*(:=(=STAMP:|$))
You would be looking for the first and second group.
There are no spaces in the regexp, so watch out for wrap.
I have posted numerous examples on this
Look at Ben's book. It's very good for beginners.
Also http://www.regular-expressions.info/
I also want to point out that the solution also validates $0.00 . If you
want to avoid this, it's a bit more complex:
^\$([1-9]\.\d{2}|0\.([1-9]\d|0[1-9]))$
Pascal
-Original Message-
From:
I am missing the form but I think it is probably something like a loop
over 4 textboxes that have the same name. In your action page (code
posted) you only create one record, with a comma delimited list of
values in it. I suppose you want each line in the form to be a record
and create an array
: Pascal Peters
Sent: woensdag 30 juni 2004 12:10
To: CF-Talk
Subject: RE: first time array
cfloop from=1 to=#form.index# index=i
cfset cassettes_Array[i][1]=form[issue i]
cfset cassettes_Array[i][2]=form[title i]
cfset cassettes_Array[i][3]=form[date i]
cfset cassettes_Array[i][4]=form
The problem is that the dates are sorted alphabetically. I would create a query with acct n°, date in ISO format and file and use query of query. I will post some code in 10' or so
Pascal
-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED]
Sent: woensdag 30 juni 2004 15:46
cfquery dbtype=query name=qFilesSorted
SELECT file
FROM qFiles
ORDER BY acctno, date DESC
/cfquery
cfoutput query=qFilesSorted
#qFilesSorted.file#br/
/cfoutput
HTH, Pascal
-Original Message-
From: Pascal Peters
Sent: woensdag 30 juni 2004 16:16
To: CF-Talk
Subject: RE: Sorting help
-
From: Pascal Peters
Sent: woensdag 30 juni 2004 16:16
To: CF-Talk
Subject: RE: Sorting help!
The problem is that the dates are sorted alphabetically. I
would create a query with acct n°, date in ISO format and
file and use query of query. I will post some code in 10' or so
Pascal
http://www.cflib.org/udf.cfm?ID=507
-Original Message-
From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED]
Sent: woensdag 30 juni 2004 16:27
To: CF-Talk
Subject: The infamous LIST again!
SET LIST VALUE:
cfset cfList = a,b,,d
cfloop index=e list=#cfList#
cfoutput
#e#
Yes, and it nearly does the same thing I'm doing here. Just that I am
formatting the date so it sorts correctly.
-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED]
Sent: woensdag 30 juni 2004 16:46
To: CF-Talk
Subject: Re: Sorting help!
Isnt there an easy way of making
the query
-Original Message-
From: Pascal Peters
Sent: woensdag 30 juni 2004 16:40
To: CF-Talk
Subject: RE: Sorting help!
I misread your original post, so this should do it (adapted
from previous version):
!--- Supposing txt is your file, acctno is digits only and
dates are in mm-dd
How is your form set up to ask for multiple records? You have a page
here that will insert a single record. If you need to insert multiple
records you will need some kind of loop.
And need I repeat: CFQUERYPARAM !!
Pascal
-Original Message-
From: Ammar Jamal
The problem is this can't be done directly. You can sort on the values,
but then you loose the reference to the keys. I would convert the struct
to an array of structs or a 2D array and sort that. You can find UDFs to
do it
http://www.cflib.org/udf.cfm/ArraySort2D
Keep in mind the value property of a select is not supported on all
browsers. I usually consider a textbox/textarea empty if there are only
spaces (I usually trim the values anyway.
Also keep in mind that title and target are properties of the form.
To avoid mixing up formfields and properties, I
I don't see very well what you are trying to do here, but you will
probably need a structur (or maybe array) of structures. The error comes
from the fact that in the second loop, you try to insert a key that
already exists. You can just use array notation instead of structinsert
if you want to
I assume you mean hidden form field instead of variable?
if(!document.myform.myfield.type == hidden) {
// this is not a hidden field
document.myform.myfield.value = whatever;
}
Although this will not work correctly for radio, checkbox and select
too.
-Original Message-
From:
Error in my previous mail:
if(document.myform.myfield.type != hidden) {
Pascal
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
cfset cassettes_Array=ArrayNew(2)
cfset cassettes_Array[ArrayLen(cassettes_Array)][1]=#form.issue#
cfset cassettes_Array[ArrayLen(cassettes_Array)][2]=#form.title#
cfset cassettes_Array[ArrayLen(cassettes_Array)][3]=#form.date1#
cfset
A 2D array requires 2 indexes. Change the first line to
cfset cassettes_Array=ArrayNew(1)
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: dinsdag 29 juni 2004 16:09
To: CF-Talk
Subject: RE: first time array
Thomas... I changed what I had to this: (but now
Did you try span[^]*(.*)/span
The problem is that this is a greedy match (anything from the first span
to the last /span). I don't know if DW supports non greedy matches:
span.*?(.*?)/span
You have to see if the . matches a newline (it probably doesn't). In DW
you could do (.|\n)* instead of .*
Because 2 is the number of dimensions in ArrayNew(2). If you want one
dimension, you have to use ArrayNew(1). You can then still create a 2D
array by creating arrays in the first dimension
Pascal
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: dinsdag 29 juni
me.myLastName = Laureska
cfset me.myCity = Da' Bridge
P
cfdump var=#me#
P
Hello world, my name is cfoutput#me.myFirstName#
#me.myLastName# and i live in #me.myCity#/cfoutput
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004
You can't have more then 100 lines in a message. When you reply, delete
the parts of the original message that are not important to your reply.
Pascal
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: dinsdag 29 juni 2004 16:47
To: CF-Talk
Subject: RE: first
No. It only exists for cf5 (not before and not after)
-Original Message-
From: cfhelp [mailto:[EMAIL PROTECTED]
Sent: dinsdag 29 juni 2004 16:45
To: CF-Talk
Subject: DSNless Connection
Can you do this in CFMX 6.1? The EasyCFM Site shows it for CF5.
Rick Eidson
Partner CTO
I would create an array of structures.
Pascal
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: dinsdag 29 juni 2004 16:59
To: CF-Talk
Subject: RE: first time array
OK... so in the case I have... a form where a client enters
cassette reference material into
Actually, you can't. There are workarounds, but if you have no DSN at
all on your CF server, it's not possible unless you use CF5 AFAIK
-Original Message-
From: Samuel Neff [mailto:[EMAIL PROTECTED]
Sent: dinsdag 29 juni 2004 16:48
To: CF-Talk
Subject: RE: DSNless Connection
Yes
A colleague of mine had that problem. The problem was that he was doing
a JS submit in the onsubmit of the form. This would submit the form
twice.
Pascal
-Original Message-
From: Joshua OConnor-Rose [mailto:[EMAIL PROTECTED]
Sent: dinsdag 29 juni 2004 19:08
To: CF-Talk
Subject:
Form.fieldnames can have duplicate entries if you have a group of
checkboxes or a multiple select. I haven't examined the code closely and
I have no idea what is in the form, but it could be an explanation.
-Original Message-
From: Joshua OConnor-Rose [mailto:[EMAIL PROTECTED]
Sent:
If I understand correctly, you want to replace empty form fields by
zero?
form[ACRES_ i] = Val(form[ACRES_ i]);
form[AMT_ i] = Val(form[AMT_ i]);
amtInsurance = form[ACRES_ i] * form[AMT_ i];
Pascal
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent:
The difficulty is at least one of each.
I think this should do it
^[[:alnum:]]*([a-z][0-9]|[0-9][a-z])[[:alnum:]]*$
Not tested
Pascal
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: dinsdag 29 juni 2004 22:40
To: CF-Talk
Subject: More fun with regular
I repeat:
^[[:alnum:]]*([a-z][0-9]|[0-9][a-z])[[:alnum:]]*$
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: woensdag 30 juni 2004 3:37
To: CF-Talk
Subject: RE: More fun with regular expressions
...but that won't ensure at least one alpha and one
: shouldn't be escaped. What is your regexp? What do you mean by
equivalent in JS?
You can always escape a character by putting a \ in front of it (not for
alnum or you can get strange results), but there is only a limited
number of characters tht need escaping. Another thing you can do is make
I was teaching, but I think a lot of people replied. In short: This is
a client thing and you can't force it. You can try by serving the file
with cfcontent:
cfheader name=Content-Disposition value=attachment;
filename=#filename#
cfcontent type=application/unknown file=#pathToFile#
deletefile=No
Can you give us the code snippet that is not working (and maybe a
description of what you want to achieve with that particular snippet)?
As I said in my previous mail, : doesn't need escaping, so there is
probably another problem with your regexp.
Pascal
PS Learn regexp and love it
This is how I tested and it has the desired result!!!
localeTime = 12:30;
dateString = testing h:mm for JS;
dateString = dateString.replace( new RegExp(h:mm, g), localeTime);
alert(dateString);
You can also use the shorthand for regexp creation
dateString = dateString.replace(/h:mm/g,
You can't have absolute paths in a cfinclude. You will need to create a
CF mapping (e.g. /SomeApplicationName) that points to
D:\SomeApplicationName\ and use that in the include:
cfinclude template=/SomeApplicationName/index.cfm
Pascal
-Original Message-
From: Gonzo Rock
If you're using IIS, make a virtual directory. You could also use
cfcontent and let CF serve the files.
Pascal
-Original Message-
From: Gonzo Rock [mailto:[EMAIL PROTECTED]
Sent: zondag 27 juni 2004 19:29
To: CF-Talk
Subject: Re: cfinclude error...
Ahhh yes... never had to use
Use cfqueryparam to prevent sql injection.
You can do what you described in the application.cfm on the scopes url,
form, cookie. Loop over the scopes and check the vars. The regexps in CF
are different though:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/regexp.htm
Pascal
The regexp you used will not work as intended in CF !
-Original Message-
From: Alistair Davidson [mailto:[EMAIL PROTECTED]
Sent: vrijdag 25 juni 2004 11:35
To: CF-Talk
Subject: RE: Coldfusion Regex
!--- in Application.cfm ---
cfscript
function isValid( strInput ){
: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: 25 June 2004 11:16
To: CF-Talk
Subject: RE: Coldfusion Regex
Use cfqueryparam to prevent sql injection.
You can do what you described in the application.cfm on the
scopes url,
form, cookie. Loop over the scopes and check the vars
In your cfcatch do cfdump var=#cfcatch# to see what is in there
-Original Message-
From: [EMAIL PROTECTED]
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: vrijdag 25 juni 2004 15:52
To: CF-Talk
Subject: Catching this Error
Hi,
I'm trying to catch the error below, but
cfif IsDefined(form.field) ANDLen(form.field)
-Original Message-
From: Milan Mushran [mailto:[EMAIL PROTECTED]
Sent: vrijdag 25 juni 2004 17:51
To: CF-Talk
Subject: Image Issue
Hi Guys,
When I try to upload an image using cffile, How do I check
for an existence of an image on
REReplace(list,,(\s*,)+,,,all)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: woensdag 23 juni 2004 19:59
To: CF-Talk
Subject: listfunction problems
Hi folks, I have a list
like: a, b, d, , f, g, , , , s
But I would like to have:
a, b, d, f, g, s
^\d{5}(-\d{4})?$
Your original one allowed a space too . If you want that it is
^\d{5}([- ]\d{4})?$
If you are not on cfmx, replace \d by [0-9]
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: woensdag 23 juni 2004 17:17
To: CF-Talk
Subject: Quick Regular
MX only!!!
REReplace(str,[^[:print:]\t\r\n],,all)
It also replaces some characters that are usually printable like
paragraph sign or copyright. Maybe use the udf from a previous mail to
convert smart quotes first.
-Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: dinsdag
to an Iframe?
Is there something to clean that code?
Thanks
Pat
_
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: June 22, 2004 06:02
To: CF-Talk
Subject: RE: cleaning up a word file
MX only!!!
REReplace(str,[^[:print:]\t\r\n],,all)
It also replaces some characters
This is the regexp hell. There is no error handling for wrong csv. It
also doesn't handle CR/LF in a quoted value. It's MX, but with some
minor modifications it should work on CF5. But hey, I only had 20' to
write it.
I think you can use cfhttp to do it too.
Pascal
cfsavecontent variable=str
You are mixing server side and client side here. You need to put the JS in the onsubmit of the form (and not in your action page):
form ... confirm('Are you sure you want to RELEASE this PO?');
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: dinsdag 22 juni
Chr(9)
-Original Message-
From: Phillip B [mailto:[EMAIL PROTECTED]
Sent: dinsdag 22 juni 2004 17:05
To: CF-Talk
Subject: Chr() for a tab?
I've looked around and can't find the char() for a tab.
Anyone know off hand?
Thanks
Phillip B.
[Todays Threads]
[This
I don't think query strings are still an issue with search engine bots.
But you can look at sesConvertor on fusium.com
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: dinsdag 22 juni 2004 17:35
To: CF-Talk
Subject: formatting URL params for search engine
window.>
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: dinsdag 22 juni 2004 20:40
To: CF-Talk
Subject: SOT: Body onUnload event (IE only)
I have a quick question that's somewhat off topic but does relate.
The onUnload event that goes in the body tag and
If you want it to work on *nix too, use \/ as delimiter.
-Original Message-
From: Bob Haroche [mailto:[EMAIL PROTECTED]
Sent: maandag 21 juni 2004 20:31
To: CF-Talk
Subject: Re: Determining Directory Where Current Template Is Located
Ah, beautiful. Thanks to both of you.
Use
It will only break on case-sensitive DBs like ORACLE. But even then you
can convert the strings to lowercase
WHERE LOWER(directory) = cfqueryparam cfsqltype=cf_sql_varchar
value=#Lcase(variables.CurrentDirectory)#
(or whatever the lowercase function is on the DB)
Pascal
PS As Barney and I
I forgot to say this is CFMX only
-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]
Sent: zondag 20 juni 2004 10:04
To: CF-Talk
Subject: [Reply To] RE: list problem
many thanks
Seamus
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
If the regular stuff is large, you can even do:
cfquery name=qFoo
select regular stuff
cfif something_is_true
UNION select extra stuff I need
(or maybe jus add to one or more clauses)
/cfif
/cfquery
Depending on what you need to add it may be less readable than your
example. There could also
variables[query].recordCount
If you are not on CFMX, you can create a struct to hold your variables
(lets call it vars) and use the same syntax
cfset vars = StructNew()
cfquery name=vars.query1 ...
...
cfset query = query1
...
#vars[query].reqordcount#
For this I was thinking I need
What version of CF? I don't understand what you mean by empty space? A
single space, blank lines in your display, ...?
The code you provided will replace a select by a single space. It will
break down if you have another select following the first one you match.
Pascal
-Original
.
I would like to replace the entire HTML code by a single space.
-Message d'origine-
De : Pascal Peters [mailto:[EMAIL PROTECTED] Envoy : vendredi
18 juin 2004 12:16 : CF-Talk Objet : RE: Those mysterious RE
What version of CF? I don't understand what you mean by empty
space
:
cfset regex = SELECT size=2
name=X2CC229C91022073EF855A729E25A9E07.*?/select
cfset myhtlmcode= ReReplace(myhtlmcode,#regex#, ,All)
Unfortunately without success. Did I miss something?
-Message d'origine-
De : Pascal Peters [mailto:[EMAIL PROTECTED] Envoy : vendredi
18 juin 2004 12
C'est avec plaisir.
Pascal
-Original Message-
From: Jean-Marc Bottin [mailto:[EMAIL PROTECTED]
Sent: vrijdag 18 juni 2004 12:44
To: CF-Talk
Subject: RE: Those mysterious RE
Pascal,
Sorry my mistake, the closing was in uppercase and in the RE
I put it in lowercase. Thank you
Session.EntityId = REReplaceNoCase(coockie, ^.*EntityId=([^]*).*$,
\1)
-Original Message-
From: Bailey, Neal [mailto:[EMAIL PROTECTED]
Sent: vrijdag 18 juni 2004 18:21
To: CF-Talk
Subject: cookie issues...
Hey guys,
I am having Cookie issues... I don't use them very much so I
AFAIK you can use cookies for client staorage but not for session
storage
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: donderdag 17 juni 2004 16:27
To: CF-Talk
Subject: Re: cfmx and CAPTCHA
On Thursday 17 Jun 2004 15:16 pm, Bryan F. Hogan wrote:
A
If you use fusebox, it dumps them all in the attributes scope. You can still use the CT formurl2attributes (I think) to do that in the application.cfm. You could also not use the prefix, but I wouldn't recommend it.
Pascal
PS I use fusebox
-Oorspronkelijk bericht-
Van: Joshua
If you are trying to find the content of the font tag (CFMX only):
stTmp = ReFindNoCase(font color=red(.*?)/font,test,1,true);
if(stTmp.pos[1]){
value = Mid(test,stTmp.pos[1],stTmp.Len[1]);
}
If you are not on MX and there is ONLY one font tag, use (.*).
If you can have nested font tags, it
I am willing to invest some time in helping people on this list, but at
least they should listen. Use TO_DATE(). Let's say the date comes in a
dd/mm/ format:
DON'T reformat it and when you insert it do
TO_DATE('#thedate#','DD/MM/'). Do that in ALL your queries (not just
UPDATE but also
You can't send screenshots to cf-talk
-Original Message-
From: brobborb [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juni 2004 10:55
To: CF-Talk
Subject: Re: Why does this design go nuts on IE5 for Macintosh?
Please explain what u mean by squished.also, send a
screenshot of
On CF5:
string = cfhttp.fileContent;
start = FindNoCase(font color=red,string);
if(start){
start = start + Len(font color=red);
end = FindNoCase(/font,string,start);
content = Mid(string,start,end-start);
}
else{
// not found
content = ;
}
You don't need to do anything to
What version of CF are you on?
-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juni 2004 13:30
To: CF-Talk
Subject: cfmail and textarea formatting issues
Hello everybody,
I have a text area in my form for users to add comments.
form name=frm
I agree in theory, but you can't use it with cached queries.
You should ALWAYS use CFQUERYPARM on EVERY query, no matter what
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
I didn't look at it since cf5 and they probably changed that in MX. Or
maybe I remember wrong ;-)
-Original Message-
From: Bargiacchi, Damien [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juni 2004 18:28
To: CF-Talk
Subject: RE: cfform and onSubmit
Thank you for your help! I guess
You are filtering on the enrollment table. This makes the left outer
join useless.
Try doing :
WHERE e.EnrollmentDate BETWEEN '#fromDate#' AND '#toDate#'
ORe.EnrollmentDate IS NULL
And of course (Guess what or look at some other threads right now)
-Original Message-
From:
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166612---You are grouping on the paymentDate AND selecting it. This will return
all paymentDates instead of the last.
I didn't have to do something like this yet, but I recall a thread with
some answers not that long ago. It isn't very
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166613---I see you are using session vars, so I would recommend
session.times_logged_on.
But that aside, you have to realize that there is no way of really
blocking more than x attempts to log in on a web app. All methods you
can come up
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166614---The from has to be a valid email address. So I would check that
(download IsEmail from cflib.org):
cfset siteEmail = [EMAIL PROTECTED]
cfif NOT(Len(form.email) AND IsEmail(form.email))
cfset form.email = variables.siteEmail
/cfif
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166618---If you are using oracle, you should definitely use to_date to store
dates. It is probably using a US date format instead of a european.
Another solution is to pass everything as ISO dates -mm-dd. Most DBs
and apps understand it
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166621--- Pascal
This is the original code, and you are correct its in US Format
cfset formatted_date = dateformat(Now(), mm/dd/)
WHERE startdate = #createodbcdate(formatted_date)#
So change it to
WHERE STARTDATE =
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166628---Yes. If you leave out the file, it will get the default file for that
directory. You probably need index.cfm.
-Original Message-
From: Michael Kear [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juni 2004 13:32
To: CF-Talk
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166630---I meant that you will need at least 2 queries because of that!!
The only solution I can come up with on short notice is get the acctNo
and maxdate, loop over that query and query for the detail.
I'm sure there must be a better
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166647---if (theform.Password.value.length6){
alert(The password must be at least 6 characters long.)
theform.Password.focus()
return false;
}
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166651---I am no expert on that, but what date format would be allowed using
cf_sql_date?
My experience is that, due to the different server configs we have in
Europe (and especially Belgium), using to_date was the only safe
alternative
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166688---What format is startdate in ?
-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juni 2004 15:59
To: CF-Talk
Subject: RE: CF Dates with MX 6.1 ?
Archive:
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: 15 June 2004 16:27
To: CF-Talk
Subject: RE: CF Dates with MX 6.1 ?
Archive: http://www.houseoffusion.com/lists.cfm/link=i:4:166688
---
What format is startdate in ?
-Original Message-
From
cffile action=""
filefield=file_#pointeur#
destination=C:\uploaddir\
nameconflict=MAKEUNIQUE
-Original Message-
From: CFDEV [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juni 2004 19:30
To: CF-Talk
Subject: File upload question
Hi,
I have a list of form field file :
form
Can't help you much with that code. What columns are in what tables and what are you trying to achieve? You are definitly missing a join there! And of course, you should be using cfqueryparam !!
Pascal
-Original Message-
From: Robert Orlini
Nonono: this way you can't use cfqueryparam. As for finding something
more readable, this is a matter of opinion. I like to have all the logic
in the cfquery itself. When I look at your code, I find it a lot more
complex than the code Robert had.
There is nothing wrong with using 0 = 0. It just
This is how to do it, but you can't use this. Use
checkForm(document.LoadForm);
The generated page will still look like that, but you can see that
_CF_checkLoadForm(this) executes return checkForm(document.LoadForm);
as last command.
Pascal
-Original Message-
From: Bargiacchi, Damien
You should collect both names. It is very common in other languages to
have more than one word in a last name. Or what if hey put their last
name first?
This said
Lastname = REReplace(form.name,^.*[[:space:]],) OR
LastName = ListLast(form.name, )
-Original Message-
From: Michael Kear
]));
lastname =
Trim(Mid(form.name,lastspace.pos[3],lastspace.len[3]));
}
else{
firstname = form.name;
lastname = ;
}
-Original Message-
From: Pascal Peters
Sent: maandag 14 juni 2004 10:05
To: CF-Talk
Subject: RE: Help with string manipulation please
You should collect both names
RemoveChars(string,1,1)
-Original Message-
From: JT [mailto:[EMAIL PROTECTED]
Sent: maandag 14 juni 2004 14:16
To: CF-Talk
Subject: remove first character
How Do I remove first character in a string.
JT
[Todays Threads]
[This Message]
[Subscription]
[Fast
SELECT ...
FROM ...
WHERE ...
ORDER BY Company, FormsType, FormsDescr, Dept
cfoutput ... group=Company
#q.Company#
cfoutput group=FormsType
#q.FormsType#
cfoutput group=FormsDescr
#q.FormsDescr#
cfoutput
#q.Dept#
-Original Message-
From: Spectrum WebDesign [mailto:[EMAIL PROTECTED]
You cant do it all in once: You will need two passes. Here is a function
that will do what you want:
cfscript
function REFindAndReplace(string,regexp,substring){
var caseSensitive = true;
var scope = one;
var returnSubexpressions = false;
var stReturn = StructNew();
var stTmp = StructNew();
Bryan,
If you want to strip all email addresses like below, use this:
REReplaceNoCase(str,[EMAIL PROTECTED],}?,,all)
If you want to extract the email address:
REReplaceNoCase(str,^.*([EMAIL PROTECTED],}).*$,\1)
Pascal
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL
Use cfqueryparam!!
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juni 2004 15:36
To: CF-Talk
Subject: chars not accepted in SQL?
I get this error when I click SUBMIT in a form where I have
an
301 - 400 of 1018 matches
Mail list logo