heh - thats exactly what I'm doing at the moment!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 10:09
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] Simple a to z
Does anyone know of a simple a to z list system to save me
writing
cfloop from=65 to=90 index=i
cfoutput
#chr(i)#
/cfoutput
/cfloop
;-)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 10:09
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] Simple a to z
Does anyone know of a simple a to z list system to save
why does 'a' start at 65 - what is 0 - 64? numbers and ???
___
* Regards,
Richard Lovelock
Westminster City Council - Web Support
Cap Gemini Ernst Young
Southbank
95 Wandsworth Road
London
SW8 2HG
( 0870 906 7482
they are the ACSCII codes for A-Z...
-Original Message-
From: Lovelock, Richard J [mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 10:16
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Simple a to z
why does 'a' start at 65 - what is 0 - 64? numbers and ???
so what do the ascii codes 1-64 represent?
___
* Regards,
Richard Lovelock
Westminster City Council - Web Support
Cap Gemini Ernst Young
Southbank
95 Wandsworth Road
London
SW8 2HG
( 0870 906 7482
www.asciitable.com
-Original Message-
From: Lovelock, Richard J [mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 10:25
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Simple a to z
so what do the ascii codes 1-64 represent?
___
*
I use this- it gives you the A-Z but only letters that need to appear:
cfquery name=select_az datasource=#dsn#
SELECT DISTINCT LEFT(*COLUMN*,1) AS MyAlpha
FROM *TABLE*
ORDER BY LEFT(*COLUMN*,1)
/cfquery
HTH
d
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
just found it!!! thanks
___
* Regards,
Richard Lovelock
Westminster City Council - Web Support
Cap Gemini Ernst Young
Southbank
95 Wandsworth Road
London
SW8 2HG
( 0870 906 7482
say you've got a query like:
cfquery
SELECT ID, Name
FROM Table
WHERE ID IN (#IDList#)
/cfquery
where IDList maybe looks like 1,7,2,8,3,6,55,4, etc. How do you get the
query to order by the order specified in your list? Using an access
database, I've got a query like this, but
make the list in the order you want the records to come out in?
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 29, 2003 12:20 PM
Subject: [ cf-dev ] order by
say you've got a query like:
cfquery
SELECT ID, Name
FROM Table
Prob post-process the query data... And store in an array/query!
Ie... You put the list into an array, then loop over the query, find the
position in the array, and then add it to a new array/query or whatever
format you want!
Can't guarantee the order things are going to come out in using that
the list is already in the order i want. but the query is just returning
them in the order they are stored in the table, i.e. by ID, which is
screwing up my order. So I have to specify something in the Order By, or
find another way to do this.
Duncan Cumming
IT Manager
thanks, that'll probably do it.
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
--
Get your domain names
Display them and find out.
-Original Message-
From: Lovelock, Richard J [mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 10:25
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Simple a to z
so what do the ascii codes 1-64 represent?
Hi,
We use fusetalk forums software for one of our clients and its very good. We
are now looking to provide live chat also which can be easily integrated
with coldfusion like fusetalk.
I have looked into fusetalks live chat and think we need more features in
addition , like chatroom moderation
I'd be very interested in this as well - we developed a very rudimentary 'live chat'
system for a football club site, but it's not that good. If anything exists (paid or
otherwise) then that'd be great...
David
-Original Message-
From: Sandeep Shetty [mailto:[EMAIL PROTECTED]
So . I got this far before lunch beer
cfif not isdefined(attributes.search_string)
cfset attributes.search_string = a
/cfif
cfquery name=select_az datasource=WebUserDSN
SELECT EstablishmentName
FROM School_Details
WHERE LEFT(#EstablishmentName#,1) =
try taking off the # #:
cfquery name=select_az datasource=WebUserDSN
SELECT EstablishmentName
FROM School_Details
WHERE LEFT(EstablishmentName,1) = #attributes.search_string#
ORDER BY EstablishmentName
/cfquery
Duncan Cumming
IT Manager
Hmmm. did that and still doesn't work. Should have looked at error message
though
Invalid column name 'a' - er I think thats a little wrong then .
I just wanted to look in school_details and find all records starting with
a
Regards - Paul
should perhaps be
cfquery name=select_az datasource=WebUserDSN
SELECT EstablishmentName
FROM School_Details
WHERE LEFT(EstablishmentName,1) = '#attributes.search_string#'
ORDER BY EstablishmentName
/cfquery
(quotes around the string)
Duncan Cumming
IT Manager
Yep just saw it as your email came through.
Many thanks works ok now . Just the next previous all paging thing to
do
Regards - Paul
*
The information contained within this e-mail (and
We ended up using macromedia communication server instead of fusetalk's
chat.
Very customisable, but more importantly holds very high traffic well.. A
bit expensive - but
we rent it from interlake.net.
you can check on passado.de/mipasado.com and some others - european
friendsreunited
erm... this Query doesnt make sense..
Its basically saying :
SELECT EstablishmentName
FROM School_Details
WHERE'A' = 'A'
ORDER BY EstablishmentName
Which will always be true therefore returning everything...
The WHERE Clause must be a valid column name which can be searched against
Actually is says go to the column named EstablishmentName and return all
records starting with 'a'.
I think. Well it works anyway
Regards - Paul
*
The information contained within this
Paul, did that work?
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 29, 2003 1:34 PM
Subject: Re: [ cf-dev ] a-z
should perhaps be
cfquery name=select_az datasource=WebUserDSN
SELECT EstablishmentName
FROM School_Details
Thanks Russ will look into it and come back
-Original Message-
From: Snake Hollywood [mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 13:51
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Chat Software
Look at www.volano.com
Volano chat is completely configurable, you can make is use
Hi,
The best CF contender is:
http://www.cfchat.net
But if you can, I'd suggest an alternative solution with a Flash
frontend - either via a java server is using Flash Communication Server
(is overkill for just text though). Is easy to customise immensely,
Cheers,
Ross
Thanks Albert will look at this option as well. Does it mean that the chat
site is hosted with interlake.net?
-Original Message-
From: Albert Popkov [mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 13:25
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Chat Software
We ended up using
Hi,
I have the following javascript which basically allows a select list to be
reordered. The original JS place the reordered list into a query string
but I want to place it into a hidden form field. I can get the hidden
field to populate but it never changes the order when then select box
here you go...
Create a Hidden form field thus :
input type=hidden name=linkorderlist value=
!--- select box script, this will allow the user to reorder the list as and
when required ---
script type=text/javascript
!--
// NOTE : linkList is your select list, you could use the argument,
Cheers, thanks for that.
Whilst looking around I found the following via google which seems to work
nicely.
Thanks
Dave
script
function move(foo,way) { j=-1; menuLen=foo.length;
if (way=='up') { lim=0; m=-1 } else { lim=menuLen-1; m=1 };
for (i=0;imenuLen;i++) if (foo.options[i].selected) {
Dave there is no point reordering the hidden field every time you change
the select list, your only doing it so u can submit the order aren't you
?
SO just dump the select list into hidden field at the end when the form
is submitted.
Russ Michaels
Macromedia/Allaire Certified ColdFusion Developer
Ok... I have a function that returns a name of something. However, a client
has asked me to be able to duplicate these functions, but still get
different results so:
Function myfunc() {
return 1;
}
A.func = myfunc;
B = duplicate(a);
C = B.func();
D = duplicate(a);
E = D.func();
Problem
Yes. It's hosted on their servers
http://www.moremx.com/
Hovewer, for passado/mipasado, we also buy rack space there.
-Original Message-
From: Sandeep Shetty [mailto:[EMAIL PROTECTED]
Sent: Monday, September 29, 2003 1:58 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Chat
I'm having fun with CFMx this week.
Now getting this error when trying to use cffile
Security: The requested template has been denied access to
E:\CFusionMX\runtime\servers\default\SERVER-INF\temp\wwwroot-tmp\neotmp5
331.tmp.
The following is the internal exception message: access denied
another good old syntax error. I've stared at this for half an hour, can't see what's
wrong. anyone else any ideas?
cfset fromdate=createdate(year(now()),month(now()),day(now()))
!-- this for gardner --
cfquery datasource=artsoutheast name=grabdiary
SELECT *
FROM story_info
WHERE name =
check your value for enddate, it's trying to insert a null value just now:
{d '2003-10-04'}, , 0,
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
seems like a null enddate?
-Original Message-
From: Ian Westbrook [mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 17:18
To: cfug dev list
Subject: [ cf-dev ] syntax error
another good old syntax error. I've stared at this for half an hour, can't
see what's wrong. anyone else any
I have a SQL question,
I have a Recordset like so (several 10,000 records)
OldFilePath NewFilePath
-
\\a\b\c\d.txt \\12098.txt
I want to loop over the files and Move the files from OldFilePath to
NewFilePath.
I guess I chould use cfexecute do this,
what would be wrong with this:
cfloop query=getPaths
cffile action=Move source=#getPaths.OldFilePath# destination=
#getPaths.NewFilePath#
/cfloop
I'm assuming it would be too slow for that many files?.
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Oh yeah, forgot to mention, outside cf :-)
Justin
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 18:07
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] SQL Server T-SQL question / File system
what would be wrong with this:
cfloop
If you don't want to use cffile, you can generate a script with multiply
copy statements
using a query, save it into a .bat file and then execute it some way or
another.
Either in cold fusion or in SQL using xp_cmdshell (check BOL for a
sample).
-Original Message-
From: Justin
The final II in ASCII stands for Information Interchange, and it
was based heavily on the technology of the times which was paper
(or glass) teletypes. So the first things they put in the table
were datacom control codes (this was in-band signalling - well
before any layered protocols). For
Perhaps you could add to the original query a computed field giving the
position in IDList of the ID of that record. Then you could say ORDER BY
the computed field.
This is conceptually the same as an earlier suggestion but might prove
more efficient for large result sets?
Duncan
-Original
If you don't need video, look at home hiway (ISDNe2). It's a true 64KB
per channel, not like 56K modems where you're lucky to get 33KB. Since
they count as phone calls, you'd also need an 'anytime' ISP account.
And remember to hang up when you go to sleep, because 24/7 is not
acceptable use
I used to work for DirecPC. They had very good service, including TV. That
said, I never price-compared them with competitors, and I have no idea
whether or not they're available in the UK. I suppose that isn't much help,
is it?
~Simon
Simon Horwith
CTO, Etrilogy Ltd.
Member of Team
46 matches
Mail list logo
