Could anyone tell me why I'm getting this error connecting to the mail
server? It's happening all the time and I do not understand why.
"Error","TID=688","04/12/01","02:13:52","Error occurred while attempting to
connect to mail server. - [PT_NOTCONNECTED] Attempt made to use a session
that is
Hi Brian,
Try this URL.
http://www.allaire.com/documents/cf4/cfml_language_reference/contents.html -
I have downloaded this tutorial is very fine. After downloading, just
notify me.
Regards
kishore
- Original Message -
From: [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent:
We have found the mereak mail server at www.icewarp.com to be very stable
and excellent value for money. We have no commercial connection.
Paul Burgess
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 7:05 PM
To: CF-Talk
Subject:
Hi all,
Could someone help me suggestions of the best way and
how i can do this:
I have a page that i need to have filled out with cold
fusion variables and then have it printed when the
person press the print button.
So for example...
A form is filled out by the user..he presses submit
and the
Windows 2000 Professional, IE 5.5, Word 2000, CFAS 4.01.
I'm seeing some slightly weird behaviour when trying to make a Word document
available for download from a web site. I've tried naming the Word document
in several different formats to see what the difference is.
I kinda think the new CF functions as poor man's objects without the
protection and inheritance stuff.
I don't agree with the fact that objects are too complex are not suited for
scripting languages. If used right, they actually save tons of work/time
long term and can actually make our programs
You need to purchase the full version of Adobe Acrobat. This allows for
dynamic publishing of .pdf's for publishing, printing and downloading.
-Original Message-
From: Heidi Belal [mailto:[EMAIL PROTECTED]]
Sent: 12 April 2001 10:13
To: CF-Talk
Subject: printing
Hi all,
Could
On 4/11/01, Peter J. MacDonald penned:
Bud,
I think the single quotes need to be double quotes.
cfif not isdefined('session.id') changed to
cfif not isdefined("session.id")
Single quotes have worked fine for me for 2 years. The default
session.id gets set fine when visitors first come to the
Could anyone tell me why I'm getting this error connecting to the mail
server? It's happening all the time and I do not understand why.
"Error","TID=688","04/12/01","02:13:52","Error occurred while
attempting to
connect to mail server. - [PT_NOTCONNECTED] Attempt made to use a session
that
I am looking for a solution to a downloading problem i am having with a
link. I am thumbnailing images, and am wanting to have a "download" link
next to the thumbnail that will automatically open up the 'save
to' window.
Obvioulsy if i just link directly to the .jpg file, the download
Just read this... Word 2000 is installed on my machine, yet I'm still
getting the duplicate extension. Seems a bit daft... does anyone know of a
way around it, *other* than zipping up the file (don't want to have to
explain to users how to unzip it) or saving it as a different file type?
I'm not sure. I understood that for such variables you should use cfparam,
but I guess in reality there would probably be little or no performance gain
unless you were using it alot.
-Original Message-
From: Bill Davies [mailto:[EMAIL PROTECTED]]
Sent: 11 April 2001 22:17
To: CF-Talk
Allaire claims that the latest CF builds are dramatically faster and
especially on linux. I have not done any formal tests so I can't say it is
true or not. But I can safely say that CF is now finally on a bit of diet.
Memory usage has been down significantly across the board on 24/7 servers
Wasn't even aware there was a 4.5.2? thought it was 4.5.1 SP2?
N
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
Thanks
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 12 April 2001 11:01
To: CF-Talk
Subject: RE: IsDefined('') v. cfset
I'm not sure. I understood that for such variables you should use cfparam,
but I guess in reality there would probably be little or no
cfparam will be more expensive than cfset, just because it tests forthe
existence of a variable before setting it.
However it's like comparing apples to oranges. They are used for different
reasons.
If you have a page that may or may not have a variable passed to it, but you
have code on
the page
How about just putting a link text 'Right click to download' under the
thumbnail. It's not ideal but it works.
Sebastian
on 4/11/01 10:17 PM, scottw at [EMAIL PROTECTED] wrote:
I am looking for a solution to a downloading problem i am having with a
link. I am thumbnailing images, and am
Paul, thanks for the tip. That's a great idea!
I think now that what I would prefer to do is have the shipping
address/contact info print at the top of *every* page that prints. I just
haven't been able to figure out how to do that.
Thanks for the help!
Terri
Original Message
Hi,
I have a field with Smith, John as the contents.
I want to display John Smith...
I'm think I get the total length(a), then the charlength of the comma(b).
Take contents b + 1 and subtract that from a equals (c)
Then display the difference of c to a (d)
and then output c after d to the
you could use the listfirst and listlast functions. assuming that your
names are alwas Last, First:
CFSET thename = "Smith, John"
CFOUTPUT
#listlast(thename)# #listfirst(thename)#
/CFOUTPUT
make sense?
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
Register the doc extension in File Types in your IIS console.
extension : doc
mimetype : application/msword
JUstin
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 10:58 AM
To: CF-Talk
Subject: RE: W2K Pro, IE5.5, .doc files and
Cool. Thanks.
- Original Message -
From: "Christopher Olive, CIO" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 4:55 AM
Subject: RE: Reveral of a field
you could use the listfirst and listlast functions. assuming that your
names are alwas Last,
trim(listLast(field)) " " trim(listFirst(field))
At 12:47 PM 4/12/2001, you wrote:
Hi,
I have a field with Smith, John as the contents.
I want to display John Smith...
I'm think I get the total length(a), then the charlength of the comma(b).
Take contents b + 1 and subtract that from a
Hi all!
I am about to embark on a project using Oracle. The dba has a table with a couple of
columns that are advanced datatypes. Any tips or tricks to get CF to work with this?
(I never used Oracle before until now, so this part is all new to me)
Thanks!
Tim P.
Thanks for the help. I'm rewriting some Informix 4gl's in CF.
-Original Message-
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 4:43 PM
To: CF-Talk
Subject: RE: How to get Julian Date
cfset JulianDate = "#numberformat(dayofyear(Now()), 000)#"
This should
Julian dates are normally based on something in the distant past,
so if you want it to work with existing data you need to make sure
the base date is the same. I think that the base date can be
configured within Informix.
Nick
-Original Message-
From: Paul Sizemore [mailto:[EMAIL
Before I jump into Allaire's WDDX SDK, I'm wondering if this is still a platform that
is being progressed.
The web site www.wddx.org doesn't look like its been updated in 2 or 3 years.
Thanks for any feedback and would love to hear from anyone that's using it to
syndicate content to perl
Good luck with that. I've been asking users of this forum about CFLDAP for
a week now. No one seems to know. I was also able to connect to Bigfoot,
and can not connect to my LDAP server. Wish you the best.
-Original Message-
From: Melissa Fraher [mailto:[EMAIL PROTECTED]]
Sent:
You will need a 2-3 day intro course for the basics (creating, retrieving,
displaying content), after that it gets harder.
- Original Message -
From: "Javier Woodhouse" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, April 11, 2001 9:17 PM
Subject: RE: CF Website
I have a registration form, that queries initially to make sure that the
registrant is not already registered, so it eliminates people from
registering more than one time if they come back to the site, however if
they submit the form and do not think anything has happened, they can use
their back
Some confusion apparent here -
The word Julian appears in two instances that I know of when referring to
dates. There is the Julian calendar and Julian dates.
The Julian calendar refers to the original calendar invented by Julius
Ceasar where a year was 365 1/4 days long. In 1582, Pope
Has anyone seen these before:
~
Error Diagnostic Information
ODBC Error Code = 40001 (Serialization failure)
[Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID
#15) was deadlocked with another process and has been chosen as the
deadlock victim. Rerun your
expire your pages...
I also do a JS location on the action page after the submission page so that
if they hit the reload button, then it wont re=post the form data...
Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
I'm trying to DTS a database from SQL 7.0 to 2000. I keep getting a message
that either the source or destination is improperly licensed. Yet I can
remote DTS from another machine running SQL 2000 to the SQL 2000 in
question. Is there something I need to do to account for 7.0---2000?
I think
I have not found much documentation on this tag either. I was able to
use cfldap to query/authenticate against our LDAP server. The code
below helped me and was posted by a Mike ealier this year. Check the
archives for this list ath houseoffusion.com.
DK
The full user context could look
Wasn't even aware there was a 4.5.2? thought it was 4.5.1 SP2?
D'OH - you know what I mean...
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
Gene,
I found a utility that I use for mirroring files and directories between two
locations with either ftp or via lan. It's called Directory Monitor
http://www.directorymonitor.com/ and it wirks quite well.
Best Regards,
Dennis Powers
UXB Internet
(203) 879-2844
http://www.uxbinfo.com/
www.remotesite.com (and it "ain't" free either)
Carol
Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]
Reply Separator
Subject:Re: CF Website
Author: [EMAIL PROTECTED]
Date: 4/11/01 9:18 PM
If the code inside of your CFMAIL tags are going to be run 70,000 times,
I'd put a lot of effort into optimizing it.
1. The BCC idea is great.
2. Make sure you're not running any unnecessary queries inside of your
CFMAIL
3. Take all the text in the body and place it into a variable such as
You can also set a cookie or session variable when they hit it the first
time and only allow insert queries if there is an abasence of such . . .
Dave
- Original Message -
From: "Terry Bader" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 9:46 AM
At 12:28 AM 04/12/2001 -0400, you wrote:
From what I remember from my CS classes (my degree is in Electronics, not
CS) functions and procedures are devices that use either an individual or
multiple attributes to perform some computation.
;) functions must always return one value.
Sounds like it's the database. Two processes were trying to access the same
data, but one of them had the resource locked.
-Original Message-
From: Edward Chanter [mailto:[EMAIL PROTECTED]]
Sent: April 12, 2001 9:26 AM
To: CF-Talk
Subject: Weird CF Error
Has anyone seen these before:
Can occur with compound queries. You are waiting to access a record/row
which another user/process has locked. That other user/process is waiting
for something that you have locked.
D
- Original Message -
From: "Edward Chanter" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Im attempting to post this for the 4th time. I tried to apply the solution
below and spent a couple hours on it but I can't seem to get it: Code I am
using is below. It has been cut down a bit to make it straight forward. I
can sent the code as an attachment if needed as it seems as though
As the error message suggests, it's a SQL Server error. Look up "deadlock"
in SQL help.
-Original Message-
From: Edward Chanter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 8:26 AM
To: CF-Talk
Subject: Weird CF Error
Has anyone seen these before:
~
Error
I have designed some forms which allow the user to upload jpegs and
QuickTime movies to the server. It was working before, but now I
am getting the following error:
===
Error Occurred While Processing Request
Error Diagnostic
Funny you ask...supposedly Macromedia has contracted to have the site
totally updated and redone. Someone mentioned the new site should be up very
soon as work has already begun.
jon
- Original Message -
From: "Tracy Bost" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday,
Functions have the ability to return a value but don't have to. Procedures
do not return values.
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
Interesting. the lock is not an intentional thing do you know any
way of changing it?
best wishes,
-= Ed
Problems cannot be solved at the same
level of awareness which created them.
- Albert Einstein
Is there anything that one can change in the Application.cfm file which
would mean that the Last Visit counter gets updated at the beginning rather
than the end of a session.?
I think I may have made a change which broke some functionality but I can't
for the life of me work out what that
Very interesting thanks!
best wishes,
-= Ed
Problems cannot be solved at the same
level of awareness which created them.
- Albert Einstein
~~
Structure your ColdFusion code with Fusebox. Get the
Phew, there's me thinking I was way out again!! :-)
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Brian,
What is it that you can't seem to get? I haven't had the time yet to
implement this solution since I've posted it (another priority project got
in the way), so I haven't started testing it, but I may have some moments
this morning to spend on it...
Erika
"Twixt optimist and pessimist,
Check the physical memory available and the disk space available. If you are
uploading "Large" files, they have to be read into memory before being
written to disk. Rule of thumb is that you need at least 2.5 times the size
of the file free on disk or in memory to insure that the upload will
I don't know about how much development is being done with it. However, I recently
completed a project where WDDX was
crucial - both in the web site and in a desktop exe I developed to feed data to the
site.
--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]
Tracy Bost wrote:
Hi folks,
Okay, off the thought ramble for a moment and on to something more pressing
and less theoretical.
Yesterday our network admin updated one of the servers. The hardware
upgrade was necessary and the server needed cleaning. The web server was
changed from Netscape Enterprise server to
Is there a way to check for the existence of a database table (SQL 2000)?
I have a calendar which stores each month's events in a separate table
(events0301), and if the user hits the "last month" button past where the
tables start, it throws an error.
I tried a cftry/cfcatch on the query,
Hey guys!
Thanks for all your suggestions and help. It seems
like formatting an html doc would be the easiset. I
will also look into the pdf cf custom tags, before i
diecide on which to use.
so what if i decide to html for the time being. If i
were to do that all i would need to do was open a
I would be interested to hear more about what you developed.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Greetings,
I'm writing to ask if anyone has an Exchange Server running LDAP (or test
server w/Exchange) that I could use for testing.
Here is the scenario: I'm working on the COM and CFLDAP chapters for Ben's
new advanced book, and I have a lot of code that needs to be tested. Another
user a
A function must return a single value. What language uses functions
that don't?
On the other hand, you're write about procedures. However, procedures
are (were) often used to modify values of the passed parameters, which is
what I was referring to below.
At 03:25 PM 04/12/2001
Its coming very soon, Jon. :)
New look feel, submission process, forums, et al.
Rey Bango
Team Allaire...
- Original Message -
From: "Jon Hall" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 10:17 AM
Subject: Re: Is WDDX alive well ?
Funny you
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'events0301'
HTH,
P.
-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:07 AM
To: CF-Talk
Subject: existence of table
Is there a way to check for the existence of a database
I get this error most often when either the name specified in the "START" or
"USERNAME" parameters does not exist.
Kevin
-Original Message-
From: Melissa Fraher [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 4:29 PM
To: CF-Talk
Subject: CFLDAP problem
Hello.
I get the
FormatBaseN() will only work on an integer. Look at this article for more
info on it.
http://www.fusionauthority.com/alert/index.cfm?alertid=30#tech1
http://www.houseoffusion.com/hof/datatype.cfm
Hi folks,
Okay, off the thought ramble for a moment and on to something more
pressing
and less
Is there a way to check for the existence of a database table (SQL 2000)?
I have a calendar which stores each month's events in a separate table
(events0301), and if the user hits the "last month" button past where the
tables start, it throws an error.
I tried a cftry/cfcatch on the query,
On 4/12/01 10:43 AM Erika L Walker wrote:
Brian,
What is it that you can't seem to get? I haven't had the time yet to
implement this solution since I've posted it (another priority project got
in the way), so I haven't started testing it, but I may have some moments
this morning to spend
I haven't done any new development in it lately, but I regularly use
programs I wrote some time ago.
The pluses: it works well, as advertised.
the minuses: It is pretty verbose.
As I recall, Dave Weiner (Frontier, Userland, Manilla, EditThisPage,
etc.) was put off with allaire for
But why would this work with CF Server 4.0 and not in 4.5? There is no
change in the code or OS?
Thanks!
Hatton
-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:36 AM
To: CF-Talk
Subject: Re: FormatBaseN Blowing up
Perfect! Thanks!
D
-Original Message-
From: Peter Stolz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:32 AM
To: CF-Talk
Subject: RE: existence of table
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'events0301'
HTH,
P.
-Original Message-
From:
On 4/12/01 9:53 AM Brian Peddle wrote:
Im attempting to post this for the 4th time. I tried to apply the solution
below and spent a couple hours on it but I can't seem to get it: Code I am
using is below. It has been cut down a bit to make it straight forward. I
can sent the code as an
You can also use the system stored procedure SP_Tables, passing it the table
name.
Bob
-Original Message-
From: Peter Stolz [mailto:[EMAIL PROTECTED]]
Sent: April 12, 2001 11:32 AM
To: CF-Talk
Subject: RE: existence of table
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME =
Another option would be to make a query to retrieve all of the table names.
You could store the resulting list in the app scope. Then, when you
dynamically construct the table name for a given month, check to make sure it
is in the list of tables before running the query to get the month's
Anyone ever seen this error and know what the problem might be?
"An unexpected system error was detected. (Error code is 4294934528)
This type of error will most likely occur when the server running ColdFusion
is low on memory and/or system resources.
If you continue to experience this error in
good idea! thanks!
D
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:38 AM
To: CF-Talk
Subject: RE: existence of table
Is there a way to check for the existence of a database table (SQL 2000)?
I have a calendar which stores
crucial - both in the web site and in a desktop exe I developed to feed
data to the site about this. .
I too would be interested in hearing more. Have looked into doing something
like this also.
Andrew
~~
Structure your ColdFusion code with
I recall there being some change in the way ints are handled between the two
versions (4.0 4.5). I can't remember the specifics but your symptoms point
to that as being a likely suspect. Anyone who knows the details care to
elaborate?
Steve
-Original Message-
From: C. Hatton Humphrey
There was a change in the way the parser handles things. Specifically the
"length" of an integer value.
DC
- Original Message -
From: "C. Hatton Humphrey" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 11:53
Subject: RE: FormatBaseN Blowing up
But
Kurt,
How are you calling the methods? Can you post some code?
Dain Anderson
Caretaker, CF Comet
http://www.cfcomet.com/
- Original Message -
From: "Kurt Ward" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 12:03 PM
Subject: COM Problem
Anyone
well, have you checked how much memory your system is eating up??
Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]
(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487
Is the COM a standard COM or an automation object? CF will only work with
the latter.
HTH,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
- Original Message
That's an even better idea...by storing the list of tables in my
application.cfm, I never have to query for them at all...just update the
list once a month when the new table is created!
That brings to mind another option.and a performance question.
What would be the performance difference
You could download the eval if you have the hardware:
http://www.microsoft.com/exchange/productinfo/Eval.htm
-Original Message-
From: Dain Anderson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:27 AM
To: CF-Talk
Subject: OT: Test Environment for Forta's Book
How would I make sure that any output I save to a file (CFFile) is
restricted to characters 32-126 of the 127 US_ASCII approved characters? I'm
currently using Repace("xxx","yyy","zzz","all") to replace / escape some
characters (like "" to "amp;") for an XML file.
Paul Sizemore
Finish Line
3308
I would like to refine my sql searches down. From the following sql statement I am
recieving up to 12 returns of the same record. How can I make this so that there is
only 1 return for each record?
cfquery datasource="#datasource#" name="prodpage"
SELECT Products.ItemID,
I am making an form for people to add information each quarter. They need
to be able to compare the figures for each quarter in a table. Their quarter
is set up as a stored procedure so they don't need to add which quarter they
are currently editing (ie: it appends all the rows each quarter so
Did this work well for you in all situations?
Can you share that piece of code?
We resorted to using javascript to open a window and redirect that way. It
is not too satisfactory since it performs differently. I'd like to have it
open in the same window as the page they link from.
Bruce
-
I am working on a new version of a site and have established a second
directory structure which is being accessed through a second instance of
the webserver through a different port.
My question is, how can I set the directory mappings in the CF
administrator so that the root for one site is
Alan,
You could limit your result set by telling the database to only return
distinct Products.ItemID :
SELECT distinct(Products.ItemID), ...
Kevin
At 06:57 AM 4/12/01 -1000, you wrote:
I would like to refine my sql searches down. From the following sql
statement I am recieving up to 12
Is your join correct? Should it, perhaps, be WHERE products.ItemID =
prodPics.itemID?
Is there a 1 to 1 relationship between products and pics?
-Original Message-
From: Alan Koenig [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:58 AM
To: CF-Talk
Subject: SQL Returns
I
Well, one way it to use the DISTINCT keyword. Change your statement from:
SELECT Products.ItemID, etc.
to
SELECT DISTINCT Products.ItemID, etc.
but I'm not sure if that will give you what you want.
Give it a try and see what the result set looks like.
Bob
-Original Message-
Hi!
How do I output a whole list of names from a query
grouped alphabetically? Output example:
A
Allen, Bob
Ames, John
B
Book, Sam
Briant, Max
I'm thinking it's by somehow using the group attribute of
the cfoutput tag or looping through the query, but I'm
not sure exactly how to get
What you really want to do (if you're going to XML) is replace those
characters with numeric entities (XML will bomb on HTML entities unless you
explicitly declare them in your DTD, or use an HTML compliant DTD)
Hence your your amp; is #38;, your non-breaking space is #160; (i think)
and not
Try something like:
cfoutput query="myQuery" group="Item"
tr
td#myQuery.ItemName#/td
cfoutput
td
cfif Val(myQuery.Value)#myQuery.Value#
cfelseinput name="Value"
/cfif
/td
Paul,
You might want to look at the XMLFormat function. It may do what you need.
Tim P.
- Original Message -
From: "Paul Sizemore" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 12:52 PM
Subject: Stripping certain ASCII characters for XML file
How
Try adding "ASCII(lastname) AS thesortkey" into your select clause, then
group by thesortkey and order by lastname at the end of your where clause.
~Simon
Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
this is one way.
CFLOOP index="letter"
list="A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z" delimiters=","
CFQUERY name="list" datasource="database" dbtype="ODBC"
SELECT table.fname, table.lname
FROM table
WHERE table.name Like
in your SQL statement, do an ORDER BY
For example, I want to sort by last name in alphabetical order, my SQL would
be like
SELECT FirstName, LastName, Address
FROM ClientInfo
Order By LastName
From: Christine Kelley [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
I'm trying to use cfinsert for the first time after using SQL queries. I
can get it to work with a local Access Database, no problem. But when I try
to use the Oracle database on the server, it asks for:
table names must be qualified with the database name and table owner, as in
Oops, sorry
ORDER BY table.name; should be: ORDER BY table.lname;
Type O, lost the l :o)
-Original Message-
From: Christine Kelley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 10:28 AM
To: CF-Talk
Subject: cfoutput lists Alphabetically
Hi!
How do I output a whole
1 - 100 of 176 matches
Mail list logo