Installing Coldfusion 5 in Windows 2003 wasn't a problem at all, I followed
the following tech note and touch wood
haven't had any problems,
http://www.macromedia.com/support/coldfusion/ts/documents/install_cf_win2003.htm
Rafe Fitzpatrick
Senior Developer
http://www.alienationdesign.co.uk
OK...we have established it works (as I suspected it would).BUT is it
SUPPORTED by Macromedia?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 09:40
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Windows 2003 CF 5
Installing Coldfusion 5
Morning all..
there is probably a straightforward way to do this but i can't think of
it...
if i know the rownumber of a table that i want to retrieve how can i tell
CF/ Access to bring me back that specific row in the table (the table
doesn't have a column called row number or anything)
It cant be donewell, not natively, you will have to a TOP and output the
first result after ordering it.
-Original Message-
From: Lovelock, Richard J [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 10:02
To: 'cflist'
Subject: [ cf-dev ] Rownumber in query
Morning all..
there is
Neil,
If you can't be arsed to write a sensible email don't please bother at all.
Robertson-Ravo, Neil (RX) wrote:
It cant be donewell, not natively, you will have to a TOP and output the
first result after ordering it.
-Original Message-
From: Lovelock, Richard J [mailto:[EMAIL
The simplest way, but not the most efficient, is to use Access to bring
Back The first 9 rows i.e
SELECT TOP 9 *
FROM xyz
and then use CFLOOP like this
CFLOOP Query=YourQuery startrow =9 endrow =9
Its not pretty but it works...
-Original Message-
From: Lovelock, Richard J
Morning all..
Morning!
there is probably a straightforward way to do this but i
can't think of it...
if i know the rownumber of a table that i want to retrieve
how can i tell CF/ Access to bring me back that specific row
in the table (the table doesn't have a column called row
Richard,
What you see when you look at a database table in some kind management
tool doesn't necessarily equate to what you'll get if you do a select *
from table.
The only way to reliably retrieve a row from a table is using a unique
identifier.
Given that you're trying to build a
And in the queens English ???
Richard - I have sent you a page number code off list - you can use that
to page your results
As for your query
cfoutput query=query STARTROW=#iStart#
MAXROWS=#iMessagesPerPage#
where you can set istart and iMessagesPerPage to your rownumber and
number of
You would need to specify somehting from that row in a where clause
Select * from table
Where somecolumn = 'somevalue'
If you do not know any field values, you can just select everything or
at least the top 10 if u want record 9 and then just output the row you
want.
E.g
Douglas
Thanks for this. I shall start looking at ASAPI technology. Never really
delved into this before so I guess it should be fun to at least try and
kill my development server with some weird .DLL.
Regards - Paul (I guess no-one has a ready made filter and instructions
they want to let
What are you talking about...
1. It cant be done Natively.
2. You can mimic it via TOP
3. ORDER the results
4. Output the first ..
Whats wrong with that?
:-)
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 10:19
To: [EMAIL PROTECTED]
Subject:
.. We are all cf developers of varying levels of ablity -
one thing about the cf community I always belived was it wasnt so much
as RTFM group
as so many other lanagues are but this list gave good and explained
advice on any code questions
kinda like a certain level of standards -
Rather than a
What are you talking about...
1. It cant be done Natively.
2. You can mimic it via TOP
3. ORDER the results
4. Output the first ..
Whats wrong with that?
:-)
Neil,
I think what stephen was trying to say was that when you have a question on
a list, answering the question with a possible
Hi
I've got a date in a field (ODBC date): how do I delete it? I've tried setting the
field to '' but that throws an error...
CF4.5, Access db
TIA
Ian W
thanks all for the replies - have helped v.much
(and for the records I am very impressed with the levels of respect and
quality of replies on this list - congrats)
___
* Regards,
Richard Lovelock
Westminster City Council -
Hmmm
This looks like a really cool way of doing my IIS login problem as
mentioned before.
However I HATE C/C++. I'm afraid I am an old school Pascal programmer
from Dec PDP/VMS systems. (my god how old is this guy)
C/C++ just confuses the hell out of me. I just hated doing it at uni and
have
cfoutput query=query STARTROW=#iStart#
MAXROWS=#iMessagesPerPage#
Does this not actually perform the query unrestricted and then CF does
the limiting? So that method's not so good if you've got a query qhich
would return 1,000,000 rows and you only want to see 10 of them...
I like the MySQL
have you even read the question Neil? he wants to do a next/previous paging
from a query return, so therefore saying it can't be done is rubbish. He
just didn't know the right way of getting the results he wanted. I'm glad
there are other people on this list that actually read questions, and
if the field is nullable then do
SET myDate = NULL
if not, then you'll have to add a date in the past and then remember that
date as invalid in your app. The problem is that you're trying to add an
invalid date ('') to the column.
-Original Message-
From: Ian Westbrook [mailto:[EMAIL
Tim
that was my understanding - that the DB would still retrieve all rows and CF
limit the output - which I could have done but was trying to avoid and hence
find an alternative method to just bring back the required row (without the
table having a column I can use for this purpose)
this MySQL
Best I post the code I sent so you can see it in context
Its for paging
CFSCRIPT
if (IsDefined(URL.Start) AND IsNumeric(URL.Start))
iStart = URL.Start;
else
iStart = 1;
Ah...OK..sorry lads...its Monday and I am still drunk after a Celtic win ;-)
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 10:37
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Rownumber in query
What are you talking about...
1. It cant be done
I agree
Good tip -
-Original Message-
From: Tim Blair [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 10:43
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Rownumber in query
cfoutput query=query STARTROW=#iStart#
MAXROWS=#iMessagesPerPage#
Does this not actually perform the query
perfect ;-)
ta
Ian W
- Original Message -
From: Rich Wild [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 06, 2003 10:43 AM
Subject: RE: [ cf-dev ] deleting dates...
if the field is nullable then do
SET myDate = NULL
if not, then you'll have to add a date in the
We are thinking of making a site multilanguage. Has anyone any experience on this?
I did something a long time ago and i was planning to have a text table and a language
table.
Then to either send all the texts into the application scope and read them from cf
memory or call the db on every
Have kept this posting from CF-Talk for when I get round to doing our
site -- may be of some use to you.
===start=
I originally thought a db was necessary but was talked out of it when I
saw this method in action: Store a language set in name/value pairs in
a text file, one set per
We personally use tables for this, and load them into Mem.if you need
any infoplease get in touch.
-Original Message-
From: Allan Cliff [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 10:55
To: CF - List
Subject: [ cf-dev ] Multi-language site
We are thinking of making a site
I've just been doing similar... I have different tables for each language.
The site administrators can edit these in the CMS -- they are set up on a
permissions basis to access content in certain languages.
When a user visits the site a session variable is set up called session.lang
defaulted to
in short...
no
CFMX 6.1 is supported on windows 2003
L.
- Original Message -
From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 06, 2003 9:38 AM
Subject: RE: [ cf-dev ] Windows 2003 CF 5
OK...we have established it works (as I suspected it
We do it by having a content table with a language field.
So you simply have to do.
Select * from contentItems where language= '#session.language#'
The site itself is split into separate folders for each language, so we
just dump the /english version into /french folder and translate menus
etc,
Will you tell him how to do it in URDU ?
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 11:05
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Multi-language site
We personally use tables for this, and load them into
I personally was going to have all the texts in 1 table related by textid, languageid,
text,
Then Burn into application memory T1234L1 as variables in a double loop and then read
them from the page depending on a cookie. (if set)
T1234L#Languageid# on each page.
- Original Message -
CFLOOP QUERY=q_GetTexts
CFSET application.T#textid#L#Languageid# = Text
/CFLOOP
Single loop only.
- Original Message -
From: Damian Watson
To: [EMAIL PROTECTED]
Sent: Monday, October 06, 2003 12:40 PM
Subject: Re: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] Multi-language
Isn't that a lot of stuff to hold in memory ? Unless of course you have
masses hehe !
Stephen
-Original Message-
From: Allan Cliff [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 11:48
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ] Multi-language site
CFLOOP
From the books I've read I've always been warned away from storing too
much data in the application scope. I would have thought a relational
table would have been better. If there are a lot of users on the site at
the same time memory will disappear pretty quick. I would probably just
use
Would this be a cached query you're looping then?? Seems that this would
take up a lot of memory in the initial query if you had a lot of content...
How would this compare to including static htm files that had been written
in the CMS (i.e. having a static file per language per page) -- anyone?
has anyone successfully built a system which allows users to automatically
create Virtual Directories in IIS via a CF GUI? Ideally not calling the
IHTK but instead direct calls to the Windows Scripts...?
N
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To
Caching your queroies has to be just as quick.
-Original Message-
From: Allan Cliff [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 12:00
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Re: [cfmail] Re: [ cf-dev ]
Multi-language site
Thats what i wanted to ask.
Is it too much
YES. The WSH vbs scripts do the same thing as IHTK.
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 12:03
To: '[EMAIL PROTECTED]'
Subject: [ cf-dev ] Virtual Directory Creation
has anyone successfully built a system which
Yep, as I thought...will investigate
-Original Message-
From: Snake Hollywood [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 12:35
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Virtual Directory Creation
YES. The WSH vbs scripts do the same thing as IHTK.
-Original
Anyone ever had problems sending a cfmail with a schedule task when using
CC:s? When I run the page via the browser, it runs AOK, but when I run it
via a task - it fails
???
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL
try cfhttp'ing another page on that website - can you get back meaningful
results?
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 15:42
To: '[EMAIL PROTECTED]'
Subject: [ cf-dev ] cfmail schedule task problem
Anyone ever
only thiswhen it runs via the browser...it mails outwhen you do it
via task...it spools and goes undeliverable...?
-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 15:47
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] cfmail schedule task problem
try comma-seperating them instead of semicolons.
you don't have any authentication that restricts it to logged in users,
certain ip addresses etc?
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in
just done itcommas worked.damn semi-colons!! freaking SMTP only :-)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 15:58
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] cfmail schedule task problem
try comma-seperating them instead of
Ok... I have DWMX 6.1 (not 2004 or whatever the new version is called)...
I am creating a site based around XML and XSL. It's easy enough, create XML
packets in CF, and chuck them at the XSL transformation engine (CF5 so MSXML
- yuck!)
Anyway... I can edit the site for a few hours np, and then
Check the mail log as this will give ou a reason for all the undelivered messages that
get placed in UNDELVR
-Original Message-
From: Sandeep Shetty [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 17:55
To: '[EMAIL PROTECTED]'
Subject: [ cf-dev ] Undelivered Emails
Hi,
I have
I believe CFMAIL has been overhauled massively for CFMX6.1 Enterprise -
what version are you using?
R
---
RAWNET LIMITED - Internet, New Media and ebusiness Gurus
Visit our new website at http://www.rawnet.com for more information
about our
In the logs
SMTP server replied No connection to mail server.
Would this be because the other server was not available?
I know the other server was available as it was our exchange server and we
had internet connection at that time.
I must be missing something here
-Original
We are using cf 5
Anyone used cf_activmail? any custom tag/recommendations for more
sending emails more reliably?
-Original Message-
From: Ross Williams [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 18:10
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Undelivered Emails
I believe
MX 6.1 has multi threaded cfmail, enterprise ver capable of millions per
hour whereras CF5 single threaded mail in the thousands, how many are being
sent. MX can keep SMTP server connection open for use on later sends. I
suspect maybe SMTP is busy, maybe there is a time out issue when this si so,
www.coolfusion.com do a good mail product calle dinfusion mail that can
be used instead of cfmail.
Russ Michaels
Macromedia Certified ColdFusion Professional
--
CFMX Hosting
t: 0845 456 3487
f: 07092 212636
tech support: 0906 960 7800
www.cfmxhosting.co.uk
Join our ColdFusion developer
Thanks, will have a look at that.
We are thinking of upgrading to mx standard soon ...
wish the standard version had some of the cool new email features as well ;)
-Original Message-
From: Snake Hollywood [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 18:37
To: [EMAIL PROTECTED]
It does, such as smtp login, multiple mime types, a failto attribute you
probably interested in, new cfmailparam, charset attribute and replyto
Colm
-Original Message-
From: Sandeep Shetty [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 18:52
To: '[EMAIL PROTECTED]'
Subject: RE: [
Cool! Thanks for pointing that out...
-Original Message-
From: Colm Brazel [mailto:[EMAIL PROTECTED]
Sent: 06 October 2003 19:26
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Undelivered Emails
It does, such as smtp login, multiple mime types, a failto attribute you
probably interested
check preferences, invisible elements or is xml added to list of of files
not to code rewrite?
In code format there's a tag library editor I`m not too familiar with, you
can import xml elements
dtd's and the like...
Colm
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]
I just wanted to chime in and give this response a SOLID second nomination.
The mail capabilities in MX (particularly MX 6.1) are fing great. To
loosly quote Lucas, the only load issues with CFMAIL in MX are those of the
mail server, not ColdFusion. if sending e-mail is a prority, I'd upgrade.
Though as noted earlier...the true benefits in CFMAIL 6.1 are only available
in ColdFusion Enterprise edition...so if you are on Pro, you will pay for
the upgrade.
Neil
- Original Message -
From: Simon Horwith [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 06, 2003 8:54
true. I have a tendency to take for granted that not everyone is running
Enterprise. BTW - it's worth the cost if you're going to leverage it's
features ;)
~Simon
Simon Horwith
CTO, Etrilogy Ltd.
Member of Team Macromedia
Macromedia Certified Instructor
Certified Advanced ColdFusion MX
60 matches
Mail list logo