Hi all
I hope someone here can help with this. I thought this was going to be
something quite easy but it turns out not to be. We have a site that has been
developeded in Reddot which creates flat asp pages with all of the content from
the cms within the pages. We are using CF to search these
Outcome, FCKeditor still uses {BasicDefault}, does it require something
else to be changed as well?
You need to clear your browser cache for the change to show.
Will
-Original Message-
From: Don L [mailto:[EMAIL PROTECTED]
Sent: 25 January 2008 01:23
To: CF-Talk
Subject: lite spell
For each table, something like:
cfloop query=ExportData
cfloop list=#ExportData.columnList# index=col !--- columnList is a
variable that is present in every query - a comma seperated list of column
names ---
cfset output = output #ExportData[col]# ' ' !--- this will need to
change to
Good question! I did my own custom tag to wrap the indexable(?) content. It
checks the user agent and does a content reset and abort to exclude the
header and footer. Not perfect but it works.
What do these HTML comments look like?
Adrian
-Original Message-
From: Tony Perry
Sent: 25
Suggestions?
I'm even open to hear what Will has to say! :o)
Rick
I just accidentally ran across this thread. Figured maybe you were tryin to use
the cftable tag in conjuction with cfftp. :)
Anyway, I know it's hard to believe, but I have never used the cfftp tag
before. Not one time. I
and where's you blank option which is required for the 'required'
attribute to work?
---
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com
C. Hatton Humphrey wrote:
I'm working on a CFForm with a CFSelect that is required. According
to the LiveDocs you the required attribute requires a
Do you know if the developer had some custom code to search only in the zone
or is it something within Verity? Google doesn't throw up much. Here's
something maybe: http://epubs.siam.org/siam/siam_verhelp.jsp
Adrian
-Original Message-
From: Tony Perry
Sent: 25 January 2008 11:27
To:
The blank option comes through as a part of the CFC results... however
I found the solution yesterday on a couple of different blogs.
Apparently the coding that Adobe used for the CFForm.js validation
script is only initially built to handle the MULTI select when facing
a required. I had to
Adrian,
they look like this:
!--searchzone--!-- verity search tags --
content here within div's etc
!--/searchzone--!-- verity search tags --
Thanks
Tony
Good question! I did my own custom tag to wrap the indexable(?) content. It
checks the user agent and does a content reset and abort to
Adrian
I can't see anything witin the code that is custom, it is just the vspider
command, with a start point, what to exclude and where to put it. I'll take a
look at that link and see what comes from that
Tony
Do you know if the developer had some custom code to search only in the zone
or
Hi long time no post.
I'm using a directory watcher to identify when a file has been FTP'd to
the site and then act on the contents.
We create a file from the uploaded file then call a stored procedure to
process the file in question.
Because it's a bit of a pain, I've put in trace emails to
Use the ColdFusion.RichText.setValue method (created in cfrichtexteditor.js):
ColdFusion.RichText.setValue(_1,_2) Where parameter _1 is the FCKEditor
instance id and parameter _2 is the new value.
The FCKEditor instance id is dynamic so use the DOM to obtain the id from the
generated
Ok, Will, so, I know that's how this editor handles cache, no biggie, but the
more important thing is, are we able to make this editor not to exclude other
javascripts for the same form element as I described above?
Thanks.
Don
Yes, mine is too but I've still had to manually clear the cache
I think Dave is trying to say that CFSchedule kicks off a CFHTTP request TO
that script which has another complex CFFTP script going on. That's 2
points of failure (CFHTTP and then CFFTP) versus just automating this via
machine and perhaps setting up a directory watcher to monitor a directory
and
I'm not sure how Zillow.com's terms supports your My strong password or
else argument (which is what I thought this was) as all you did was show me
their terms of use.
Now try to find one one here -
http://www.sharebuilder.com/sharebuilder/Security/Default.aspx
I can choose any password I want
No matter how I run it, I get the same error...
- Automated Scheduled Task
- Manual Test Run of Scheduled Task
- Run template directly in browser
Then your problem isn't with CFHTTP, it's with the file. Have you set the
TIMEOUT attribute for CFFTP? Have you also set the page timeout using
Anyway, the problem with strong passwords is they're not
easily, if at all, memorable.
That doesn't have to be true:
http://en.wikipedia.org/wiki/Passphrase
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction
I remember this too, from CF5/4.5 days, tho. I thought this was fixed in
the MX rewrite?
On Jan 25, 2008 10:59 AM, Gerald Guido [EMAIL PROTECTED] wrote:
I remember this. We used to fix it by running a query with a syntax error
on
the database. For some reason it will unlock the database.
something like...
SELECT
Colleges,
CASE
when Colleges = 'Harvard' THEN 1
when Colleges = 'Princeton' THEN 2
when Colleges = 'Dartmouth' THEN 3
END AS collegeOrder
FROM
myTable
ORDER BY
collegeOrder
(not tested) :)
On Jan 25, 2008 10:41 AM,
I was trying to do that w/o adding another column. Can it be done?
-Original Message-
From: Todd [mailto:[EMAIL PROTECTED]
Sent: Friday, January 25, 2008 1:50 PM
To: CF-Talk
Subject: Re: OT: SQL Question -- Order by a column's value?
Nope, add a sort_order column and sort your colleges
There is no way to do it with pure SQL alone.
Dominic
Well actually you can do in pure SQL. SQL has code that can be used to create
dynamic columns and values on the fly in your record set and then one can order
on this set. It sort of depends on whether the desire order is permanent or
Confirm that it exists?
cfdump var=#test#
I thought it was just cfhttp.fileContent? I see they added the results
attribute in 7, but there's no additional documentation on it.
On Jan 25, 2008 2:51 PM, Jim McAtee [EMAIL PROTECTED] wrote:
I'm getting an error in CF8 when I attempt to alter the
I agree to a point, Claude... you're right that anything can
be overturned, but having a prior agreement is always good to have
on your side in court.
There would have to be gross negligence on a company's part to
have the prior legal agreement ignored.
I think everyone in our discussion is
Yes, it exists. It fails using either cfhttp.filecontent or some variable
designated through the restults attribute.
- Original Message -
From: Todd [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 25, 2008 1:04 PM
Subject: Re: CFHTTP.Filecontent on left
My only point about Zillow.com's terms holds them unaccountable for any
problems you experiences from using their site. They state:
(A) BREACH OF CONTRACT, (B) BREACH OF WARRANTY, (C) NEGLIGENCE, OR
(D) ANY OTHER CAUSE OF ACTION
Sounds to me like, whether it's because of a weak password or
07/24/1978 is an invalid date format
Ok, now I see what your problem is:
If you're using LSdateFormat, the function (and here is the difference
with dateFaormat)
expect a date. Since 07/24/1978 is not a date, but a string, CF will
try to convert it to a date,
but according the English (UK)
No problems anywhere, but with CFFTP.
I just need to get around the CFHTTP page timeout. And there
should be a way to use the CFFTP tag without having to resort
to jumping through a lot of hoops using third-party software
and contorted methods.
Why won't the tag just work?
Any
You should change the location of the 'spellchecker.cfm' file to the
location of the page on your local system.
As for the request var error, rerun the system after the new location has
been defined above and we can work through that.
William
--
William E. Seiter
Have you ever read a book
I am looking for recommendations on a company to host our DNS. We are
currently using Internap's CoLocation services and their DNS went down again.
3rd time in less than 2 months. Our customers are pissed and I don't blame
them. I need to find another solution and always value the
The page runs successfully until it times out while the
download operation is going on.
I can watch the file being downloaded in Windows Explorer
until the point where the page times out like any other
slow web page. At that point the page shows the error message
and the download stops.
Any
A system that would ingest stories from 1+ rss feeds?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
it seems to me that lsdateformat function takes an english uk
formated date (dd/mm/)
More precisely, I would say it takes a date in the default locale
format, or the locale previously defined by setLocale()
If your server is English, then yes, you are right.
For servers un US, it will take
A quote From O Brother, Where Art Thou?
This stew's awful good.
Wash responds, You think so? I slaughtered this horse last Tuesday. I'm
afraid she's startin' to turn.
Just sayin'... ;)
On Jan 25, 2008 5:33 PM, James Holmes [EMAIL PROTECTED] wrote:
Yes, wildcard certs work fine under Apache
Hi claude,
thanks for this, i am starting to understand the problem now, i will however
take a look at your function as the lsdateformat is starting to give me
nightmares!!!
thanks claude
richard
~|
Adobe® ColdFusion® 8
Thank you, William, I believe I was calling the 'spellchecker.cfm' file in the
correct local location. To further verify this, I tried different relative
path such as using prefix of ../ or ./ or / for {CFIDE}
When the relative path was wrong, it would prompt for {File not found}, as
expected.
Richard
Just a final comment on this:
If you know that your dates are always in the /mm/dd format, then you
should use parseDateTime() to parse them and then format accordingly:
Eg. Assuming your date is in a variable 'd'
Format according to the setLocale() value:
cfset dateDisplay =
Hi Richard
We deal with the same issue here in Australia.
You may have the problem sorted out by now, but you may like to have a look
at some notes I put down a little while ago on this.
http://stannard.net.au/blog/index.cfm/2006/10/25/Date-Objects-vs-Date-String
s-in-ColdFusion
Just an extra
Thanks for the tips on this.
I found this working codes below, but need to know how to put all of
the output into Excel files with the column names.
cfset tbls = Demo,FuncAbility, ...
cfoutput
cfloop list=#tbls# index=i
cfquery datasource=GKeeper name=qryTable
select *
Oh, come on James! What's a little cannibalism between friends! :o)
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: Friday, January 25, 2008 6:44 PM
To: CF-Talk
Subject: Re: SSL Necessary? Important?
Depending on local laws, there are some things to which
HostMySite.com are reliable and give excellent service.
On a connected note it always amazes me how many reqests we get to this list
looking for cheap hosting, personally I'd rather pay a few dollars more for
reliablity and better service.
Here's a quote from Internap's (caching page) website:
i can open sql files and run them by using commands such as the
following:
EXEC master..xp_cmdshell 'osql -E -i \\mycomputernetworkname
\Driveletter\foldername\testing.sql'
You can do this several ways
You can use EXEC master..xp_cmdshell which I am assuming is a call the
CMD or windows
My goal is to run a series of stored procedures. At one point, while I run the
stored procedures, I need to run coldfusion code which has a cfquery tag and
some complex if and else conditions which are easier done in coldfusion than
t-sql.
All I need to do is to open up that page in a browser
ok i have a .xls
with a field called zip, it will have values like this
43202
43206
43207
43208
43212
in my sql table, i have from_zip ans to_zip.
so i would like to see if the zip in the xls file is concurent, if so
put the lowest value in from highest value in to. IF NOT just put
from too to
I think to help we may need to know what your goal is. That is to say,
do you want to have SQL Server read the contents of the cfm file
itself, or perhaps the results of the CFM file? Or do you simply need
to fire off some CF process once your SQL Server process has reached a
certain point.
If
You didn't specify the CF version, but for CF6+ use wget or cURL.
In the old days with CF5 (and still for me) you can actually execute the CF
executable with the page as a parameter.
T
Hello All
Is there a way to execute a coldfusion file from a microsoft sql
server stored procedure?
In
EXEC master..xp_cmdshell 'wget http://www.example.com/index.cfm'
-Original Message-
From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED]
Sent: Friday, January 25, 2008 4:44 PM
To: CF-Talk
Subject: Re: is it possible to open cfml page from sql server stored
procedure?
Yes, you can
Yes, you can use a DTS package to run a script that makes an HTTP call.
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com
Discover Antartica wrote:
Hello All
Is there a way to execute a
Depending on local laws, there are some things to which you simply
can't agree. For example, I can't agree that you can kill me and cook
me for dinner tonight - in most locations you are still going to be
charged with murder, no matter what agreements we had in place.
On Jan 26, 2008 5:40 AM,
I tried the following:
EXEC master..xp_cmdshell 'wget http://www.example.com/index.cfm'
I got this error message:
'wget' is not recognized as an internal or external command,
operable program or batch file.
- Original Message
From: Russ [EMAIL PROTECTED]
To: CF-Talk
You can certainly run CFM pages via their http path. Our dba does that all
the time when he needs to trigger something on the CF side.
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Friday, January 25, 2008 3:34 PM
To: CF-Talk
Subject: SPAM: Re: is it possible to
Hi
i need some clarification on the lsdateformat and dateformat if you can help!
i was under the impression that if i set a locale as English UK and then used
the follwing code:
lsdateformat(07/24/1978,dd/mm/) that it would convert this date into
24/07/1978
but i am getting an error
Yes, the 6 steps are very clean, it saves time and I appreciate it.
But I'm got an err mgs when attempted to use the checker,
Element DATA_STORAGE_1 is undefined in REQUEST.
I was wondering about that when edited the spellchecker.cfm file per
instruction, where's the {DATA_STORAGE_1} var
You're going to have to work around it. Either by setting cfset somevar =
test.filecontent or otherwise.
On Jan 25, 2008 3:19 PM, Jim McAtee [EMAIL PROTECTED] wrote:
Yes, it exists. It fails using either cfhttp.filecontent or some variable
designated through the restults attribute.
I would think it should be able to. Pydu
EXEC master..xp_cmdshell '{yourBrowserExecutable.exe} then
{yourCFtemplatePath/yourCFtemplate.cfm}'
Have not tried it myself, but I really don't see any reason why not other than
security.
Hello All
Is there a way to execute a coldfusion file from a
Hello All
Is there a way to execute a coldfusion file from a microsoft sql server stored
procedure?
In other words, since cf files don't have a .exe extension, is it possible to
open a cfml page from a sql stored procedure?
note:
i can open sql files and run them by using commands such as the
I don't understand the business logic of
from_zip to_zip
20106 20106
(same value for from and to).
But sql-wise, it would be real simple, once you
1) finish import the excel into a db table, your table may look like this:
zipTbl
zipFrom
20106
22002
Then
2) alter your
Hi,
none of these suggestions are working we have the set locale setup in the
application page, we have even tried to put it in the onrequest function
cfset SetLocale(English (UK))
then we are simply trying to run this following code to test it and it is not
working:
cfset dateV =
I confirmed the same error:
cfhttp url=http://www.web-rat.com/; result=test
cfset test.filecontent = replace(test.filecontent,'Todd
Rafferty','Goober','ALL')
cfdump var=#test#
Easy work around, but it appears to be a bug. Unless test is no longer a
true structure anymore.
On Jan 25, 2008 2:51
Have you tried connecting and downloading the file with an FTP client rather
than CF?
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 25 January 2008 18:47
To: CF-Talk
Subject: RE: Why would I get a cfhttp timeout on this cfftp operation?
Yes, to both
Che Vilnonis wrote:
I was trying to do that w/o adding another column. Can it be done?
Yes, see Crow's, Charlie's or my post on using CASE to create an inline
sort column with SQL.
~|
Adobe® ColdFusion® 8 software 8 is the
Yes, I established an mapped FTP resource into Windows Explorer
and I can grab files from the remote server.
I can login to the remote server via ftp in Windows Explorer.
No problems anywhere, but with CFFTP.
I just need to get around the CFHTTP page timeout. And there
should be a way to use
I'm getting an error in CF8 when I attempt to alter the contents of the
filecontent key of a struct returned by CFHTTP. This worked fine in CF5.
I can easily fix it, but what's the reason for the error? There's not
much to go on in the debugging output.
The code:
cfhttp
I'm not sure if the settings were correct, but I tried
setting the scheduled task's timeout to seconds.
Then I tried adding cfsetting timeoutRequest= to the
template, but neither seemed to have an effect.
How many seconds does it run before failing?
But also, if the problem is
hey guys!
i need a little sql help/advice.
i have a table that has 2 columns
from_zip
to_zip
i get xls files from people in the office with massive zip entries.
like:
Zip Code
20106
22002
22401
22402
22404
22407
22408
22412
i want to go through this file and create the from/to fields...
Cool. That did the trick. Thanks to all!
-Original Message-
From: Gaulin, Mark [mailto:[EMAIL PROTECTED]
Sent: Friday, January 25, 2008 2:08 PM
To: CF-Talk
Subject: RE: SQL Question -- Order by a column's value?
Yes, you can do this with a CASE statement. The syntax may depend on you
Sorry, add sort_order column and then do an ORDER BY sort_order and set all
the colleges in the appropriate sorting that you want it to be.
On Jan 25, 2008 1:49 PM, Todd [EMAIL PROTECTED] wrote:
Nope, add a sort_order column and sort your colleges appropriately.
On Jan 25, 2008 1:41 PM, Che
Nope, add a sort_order column and sort your colleges appropriately.
On Jan 25, 2008 1:41 PM, Che Vilnonis [EMAIL PROTECTED] wrote:
Suppose I have a small set of data with a column named Colleges. Is
there
a way to write an ORDER BY statement to say something like...
ORDER BY Colleges
IN NO EVENT WILL ZILLOW.COM OR ANY SUPPLIER BE LIABLE FOR
ANY DAMAGES
I'm sorry, but just from the very begining, this statement has
absolutely no value.
I hope you didn't pay a lawyer to write it.
Nobody can state, in advance on not that he is not liable or responsible.
ONLY a judge in court
I can assure you that I'm not your wife and there are some areas where I'm
very cut to the chase and other areas where I have learned to be more
flexible I guess. :)
On Jan 25, 2008 11:40 AM, Rick Faircloth wrote:
You sound like my wife who's always telling me to be more civil and stop
that my
No matter how I run it, I get the same error...
- Automated Scheduled Task
- Manual Test Run of Scheduled Task
- Run template directly in browser
Is there some other way to run a template that I'm missing?
It just seems crazy to design a tag that allows one type of
functionality, but is limited
I remember this. We used to fix it by running a query with a syntax error on
the database. For some reason it will unlock the database.
On Jan 25, 2008 11:37 AM, Adkins, Randy [EMAIL PROTECTED] wrote:
It is probably locked by the Datasource connection from CF Admin
-Original Message-
Here's some of the Terms for use of Zillow.com... a Real Estate listing
website.
9. LIABILITY LIMITATION; EXCLUSIVE REMEDY. IN NO EVENT WILL ZILLOW.COM OR ANY
SUPPLIER BE LIABLE FOR
ANY DAMAGES, INCLUDING WITHOUT LIMITATION ANY INDIRECT, CONSEQUENTIAL, SPECIAL,
INCIDENTAL, OR
PUNITIVE DAMAGES
Similar to: select no_field from no_table thus would kill the ldb locking
file
-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Friday, January 25, 2008 11:59 AM
To: CF-Talk
Subject: Re: CF App throwing Access access error
I remember this. We used to fix it by
Thanks. I don't think that's it. It's worked for weeks and today I rebooted
the machine CF is on and still I ge the error.
It is probably locked by the Datasource connection from CF Admin
~|
Adobe® ColdFusion® 8 software 8 is
You sound like my wife who's always telling me to be more civil and stop
that my way or the highway kind of talk when I discuss issues. It's not
that it's my way or the highway, I just tend to cut to the chase in getting
to the bottom line and not phrasing my position very diplomatically.
It is probably locked by the Datasource connection from CF Admin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, January 25, 2008 11:35 AM
To: CF-Talk
Subject: CF App throwing Access access error
Everyone is logged out, and there's no lock on the
I'd like to see some proof of this. Is this only with wildcard certs (in
which case it would only work for *.domainname.com), or it is for any kind
of cert (such that you can have www.example.com and www.example2.com) on the
same IP with no SSL problems?
Russ
-Original Message-
Rick,
I get it. I do. What I'm suggesting is instead of cramming down a password
down the throat to use clearly written english description of what a STRONG
password would be and to use validation to determine what's a strong / weak
passwords. There's plenty of javascript / serverside
Thanks for the insight, Dave...
But how would one even use CFFTP if it always depends on
CFHTTP for functionality?
Also (to Tom, too), I tried to set the timeout in the scheduled
task to 9, but that had no effect.
It just seems that if CFFTP is always dependent upon CFHTTP, and
CFHTTP is
I am attempting to use the logger.xml file, as documented here
(http://kb.adobe.com/selfservice/viewContent.do?externalId=94a16ba6sliceId=1)
to customize the behavior of the cflog tag. I would like to use the
various appenders made available by Log4J to output log statements to
other locations in
Philip,
If you are willing to share your code, please email me at [EMAIL PROTECTED]
Thanks,
JL
Philip,
I have just been asked to interface one of our apps with Cybersource.
I would greatly appreciate any code that you have to share.
Thanks.
JL
If anybody is interested I did find
I get about 4 MB of a 25 MB file each time then my scheduled
task, whether I let the scheduler run it or manually trigger
the scheduled task, or even if I run the template directly in
the browser, I get an error from the scheduler log that says
I had a cfhttp timeout error.
Why is
Would you consider gmail to be pretty important if you used it daily like I
do? Let's take a look at what Google says in their EULA:
=
6. Your passwords and account security
6.1 You agree and understand that you are responsible for maintaining
Rick, I made a mistake in my previous email. I meant url?RequestTimeOut=x
Alternatively:
cfsetting requestTimeOut = *value in seconds*
On Jan 25, 2008 9:05 AM, Rick Faircloth [EMAIL PROTECTED] wrote:
Hi, all.
Throwing this problem out again with the code I'm running.
I get about 4 MB of a
Hi, all.
Throwing this problem out again with the code I'm running.
I get about 4 MB of a 25 MB file each time then my scheduled task,
whether I let the scheduler run it or manually trigger the scheduled task,
or even if I run the template directly in the browser, I get an error
from the
Rick, is it really not possible to compromise? It's one thing to enforce
and shove a password down my throat... it's something else to educate the
end-user on what a strong password is.
On Jan 25, 2008 8:46 AM, Rick Faircloth [EMAIL PROTECTED] wrote:
No problem... if you won't let me choose
No problem... if you won't let me choose your password to make sure
you and I are both protected, then you have to agree not to hold me
accountable for any problems that occur as a result of your weak
password. Accept a strong password, or sign a waiver... simple.
-Original Message-
but I can't help on this one guy.
Well, now I'm just going to shut down my servers... all is lost... ;o)
-Original Message-
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
Sent: Friday, January 25, 2008 6:02 AM
To: CF-Talk
Subject: Re: Limit on cfftp getfile file size?
Would you be able to send me the command your dba uses to open a http page
through sql?
- Original Message
From: Andy Matthews [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, January 25, 2008 3:04:17 PM
Subject: RE: SPAM: Re: is it possible to open cfml page from
Yes, wildcard certs work fine under Apache too.
On Jan 26, 2008 2:20 AM, Dave Watts [EMAIL PROTECTED] wrote:
I'd like to see some proof of this. Is this only with
wildcard certs (in which case it would only work for
*.domainname.com), or it is for any kind of cert (such that
you can have
ASpell is the spelling 'core', but you need the javascript/CF page, that
calls the Aspell system.
http://spellerpages.sourceforge.net/
Actually, to make things easier, this guy put out a step by step that you
could follow.
http://www.fantasy-league.com/coldfusion/fckeditor/
Where it refers to
Discover Antartica wrote:
Hello All
Is there a way to execute a coldfusion file from a microsoft sql server
stored procedure?
In other words, since cf files don't have a .exe extension, is it possible to
open a cfml page from a sql stored procedure?
note:
i can open sql files and run
Yes, you can do this with a CASE statement. The syntax may depend on
you db, but on SQL Server
ORDER BY
CASE Colleges
WHEN 'Harvard' THEN 1
WHEN 'Princeton' THEN 2
WHEN 'Dartmouth' THEN 3
ELSE 100
END
This would
Although you can do it as Charlie demonstrated, using CASE, Dominic's
solution is probably the best.
Put the data in a table where it belongs. Then, that same data can be
reused for other purposes.
M!ke
-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED]
Sent: Friday,
On 1/24/08, Rick Faircloth [EMAIL PROTECTED] wrote:
One solution that I have used is to allow users to choose their username,
usually just their email address, but I force a very strong password
on them generated with CF.
Nothing annoys me more, personally, than a web site that won't let me
Yes, you can do this using case statements in your order by:
example:
select * from viewoffers where [EMAIL PROTECTED]
order by
case status
when 'active' then 1
when 'rejected' then 2
else 99
end
Of course, this is really a kludge. The DB should be deisgned a little
better, but
Yes, to both questions.
I'm not sure if the settings were correct, but I tried setting the
scheduled task's timeout to seconds.
Then I tried adding cfsetting timeoutRequest= to the template,
but neither seemed to have an effect.
But also, if the problem is not with CFHTTP, why would
Che Vilnonis wrote:
Suppose I have a small set of data with a column named Colleges. Is there
a way to write an ORDER BY statement to say something like...
ORDER BY Colleges 'Harvard', Colleges 'Princeton', Colleges 'Dartmouth'???
Just wondering... Che
If I understand your question
Do you mean put them in a predifind order based on the college, other than
alphabetical?
If so, and if you have a lookup table for your colleges, you will have to
add a numerical column called 'Ordinal' (or something else) with which you
can set their order. Then simply order by that in your SQL
Well, I was just kinda giving the bottom line. Of course, in the real
world, a much kinder, gentler way of saying it would be appropriate.
I can also compromise by letting you choose your password, but stipulate
that it require one or more of certain characters, a mix of caps and lower
case,
1 - 100 of 118 matches
Mail list logo