Great news! We're delighted to announce that several major publishers,
including O'Reilly, McGraw Hill/Osbourne, and Sybex, have volunteered free
ColdFusion and tech books for the CF Community Suite, running October 21-24
in the Walt Disney Dolphin in Orlando, Florida.
That means that books like
Does anyone know of a Cold Fusion greeting card script?
I'm looking for a fairly decent one.. doesn't have to be
super-ultra-wow-fantastic.. just decent.
Thanks,
Tony Hicks
--
Search the Holy Bible: http://www.bibleclicks.com
~~
Get the
Why not write your own?
All you need is the following pages/database:
Back-end:
1. Database with - id/email/name/message/senderemail/sendername/pic_id
View:
2. View page - which is populated by a cfquery to database
Choose/Send:
3. Page 1 - choose image - thumbnails of card/s - when thumbnails
Easy layout but it'll be a lot of work.. and its not that I mind the work,
its the total lack of time to do it..
--
Search the Holy Bible: http://www.bibleclicks.com
- Original Message -
From: James Maltby [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 04,
Hi,
Does anyone know how to preselect values using the CF two selected tag?
Cheers.
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives:
I've written one like that in about 1 hour - it's that easy - the only
difficult part is the card and image prep. - which you would have to do
with any off the shelf package anyway...
J
-Original Message-
From: Tony Hicks [mailto:[EMAIL PROTECTED]]
Sent: 04 October 2001 11:06
To:
Here, Here! Please port CF Studio and Server to the MAC OS ... much more
stable environment. Macromedia has a history with Macintosh, it seems only
logical to port it's non-Mac enabled software over to OS X at least. That
was one of my initial thoughts when MM and Allaire merged Finally, Mac
On 10/3/01, [EMAIL PROTECTED] penned:
A much better solution is from www.deepmetrix.com (Live Stats) easy to use
and much more affordable then WebTrends. It runs well as a service and can
give realtime results with low overhead.
It sounded like the original poster wants a solution to compile
I suppose you believe webstar is the most secure web server too
*
Here, Here! Please port CF Studio and Server to the MAC OS ... much more
stable environment.
What about creating a database view with the corrected name? This way, you
don't have to change your Cold Fusion generated SQL, except for the
table/view name or the actual database layout.
Steve
-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC
(Code Below)
I adapted the following code from a JavaScript and a VB Script that perform
the same function. I usually don't have any trouble doing this, but this
time, it's giving me fits. What is supposed to happen is that you pass in 4
variables:
source - UNC Path to the XML Doc
style - UNC
I'm not really in the mood for an argument about What's a better x just
trying to get my opinion out there. Thanks for the offer though. I'm
speaking purely from a development standpoint. I don't CARE what it's being
served by - IIS/Website Pro/Apache ... doesn't really matter, as long as it
I ran across cf_mergequery custom tag. Can someone please give me some
documentation on this tag.
Joshua Tipton
~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 8:35 AM
To: 'CF Talk'
Subject:OT Linked Server
~~
Get the mailserver that powers this list at http://www.coolfusion.com
With the Default1 and Default2 attributes. I used to use the following
for it and never ran into a problem.
cfif Variables.CauseType1 GT 0
CF_TwoSelectsRelated
Name1=CauseType1 Name2=SubCause1 Query=qryGetCauseType Value1=CauseTypeID
Value2=SubCauseID Display1=CauseType Display2=SubCause
All,
I've been using stored procedures for a while now but I've never really
needed to create one that returned multiple result sets. My question is,
how do you do that? Would someone be kind enough to show me a little
pseudo code or a snippet of code on how to accomplish this?
I assume in cf,
Can you use counts with joined tables and a where statement?
This seems like a dumb question...
Goto: http://www.cheshiregroup.com/gilway/subcount3.cfm
My client wants the count of each separate number...next to the
number preferably...
This is tricky because there is 2 tables, one that
Assuming that your version of the CF two selected tag is using the
ChangeMenu function:
CFSCRIPT
Variables.FormName = whateverMyFormNameIs;
Variables.My_Default_Left_ID = 1;
Variables.My_Default_Right_IDs = '2,3,4,5';
/CFSCRIPT
HTML
HEAD
The order of your statements is incorrect. It should be...
SELECT count(t.File) as file3, g.File, t.File
FROM tblfile t, gilway12 g
WHERE t.File=g.File
GROUP BY g.File
Steve
-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct
The order of your statements is incorrect. It should be...
SELECT count(t.File) as file3, g.File, t.File
FROM tblfile t, gilway12 g
WHERE t.File=g.File
GROUP BY g.File
In the GROUP BY clause, you'll need to include all columns listed in the
SELECT:
GROUP BY g.File, t.File
Of
I am hoping that someone in this group may be able to help me. The company
I work for is building a service-based ecommerce website. Because this site
sells website space to other customers, I need to charge these customers
monthly for the services we are providing. Therefore, I believe I am
The only dumb questions are the ones not asked!
hehehe, I don't know the answer though sorry. :-(
Mike
- Original Message -
From: Julia Green [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 04, 2001 10:29 AM
Subject: Important - For a project -- please help
Afternoon all,
Please excuse the slightly OT message.
Its just a quick reminder that tonight (Thursday 4th October) is the 4th
Northern CFUG meeting at The University of York.
The meeting will start at 7.30pm as usual and will go on until drinking time
(9.30), and is going to be in the
If you must store credit card info, it might be a good idea to follow some
of these steps in addition to the typical Secure Certificate and so on. You
should absolutely encrypt them using PGP or some other type of encryption.
I have used CF_PGP on several clients and it works quite well. You
Has anyone be able to make use of calling the ActiveX COM object for the
date picker and pass variables.
//Jaye Morris, Multimedia Developer, Design Technologist
[EMAIL PROTECTED] - [EMAIL PROTECTED]
//www.navtrak.net - www.jayezero.com
Thank you Dave and everyone for responding so promptly!!!
gotta get the order of the statement
it works now, and I get my $35...
Julia Computer Consulting
Web Design @ Reasonable Prices
PO Box 279
Watertown MA 02471-0279
Email: [EMAIL PROTECTED]
http://www.juliagreen.com
Phone:
I have used CF_PGP on several clients and it works quite
well. You could probably use some sort of ASP PGP COM object
with CF instead of paying the $400 for CF_PGP.
I believe that if you use PGP on the server, you're legally required to pay
the license costs, which are significantly more
I have also done this using CFX_PGP. In our case, we FTPed the
order and PGP-encrypted CC info to a Unix server and they moved
the file to a secure location behind a firewall and deleted it
from the FTP folder. You could also do this via VPN.
Another question: has anyone found any shared hosts
cfstoredproc procedure=procedure_name datasource=#maindsn#
cfprocresult name=result1
cfprocresult name=result2
/cfstoredproc
The only difference is you need to add the RESULTSET attribute, like this...
cfprocresult name=result1 resultset=1
cfprocresult name=result2 resultset=2
The RESULTSET
Jeff
I would also be interested in knowing if anyone is aware of a third party
clearing house or payment processor that can provide a very secure credit
card storage service.
Check out WorldPay's FuturePay service:
http://www.worldpay.com/sg/products_services/product_selection/billing.shtml
Yup it's as simple as thatbut the one thing to bear in mind is that the
results of any select statement in your SP (other than those setting values
of variables) will be considered as returnable resultsets
--
Andrew Ewings
Thanks Alex for the quick feedback. I had looked at CF_PGP and was thinking
of using it, I just was not sure it could encrypt data for storage in a
database. I know PGP is pretty secure, just wasn't sure if it was the most
secure form of encryption available. $400 is not that much to spend to
Just FYI - it's a fact. Munging the credit card numbers is harder to crack
than encryption.
For example. You have a key. You add a documented value to the first set
of four numbers and add another number to the second set of four numbers.
(dummy cc number here)
Visa 4563 2784 9001 2483
Add
Howard and everyone else that responded,
Thanks for all your feedback. I will change my variable naming to sometime
more like _dateX and then take off the X on the response page. This seems
rather cludgy but I guess it will have to do. I feel rather peeved that
there is no way in cold fusion to
Thanks all on the list, your emails have helped a lot in learning CF.
We have a very small shop and I'm trying to figure out how to upgrade
IIS to 4 or 5.I thought this happened when we loaded SP6 on the NT40
but when I go to IIS server manager help it tells me am running IIS 3.
Dave Hannum wrote:
Just FYI - it's a fact. Munging the credit card numbers is harder to crack
than encryption.
For example. You have a key. You add a documented value to the first set
of four numbers and add another number to the second set of four numbers.
(dummy cc number here)
Visa
I should point out that this is a very simple form of encryption (call it
whatever you want, it's still encryption), and EASILY hackable. How long do
you think it would take a computer to do brute-force key calculation on such
a simple key, especially considering that CC numbers have patterns in
Hi,
What's the best way to schedule a SQL Server 2000 DTS import/export? The
reason I'm asking is because I've been scheduling by right-clicking on the
DTS package and choosing 'schedule package'. But it doesn't run? Has anyone
experienced similar problems?
Sal
To add to this, you can also create multiple querysets from one query.
Just do:
cfprocresult name=result1 resultset=1
cfprocresult name=result2 resultset=1
cfprocresult name=result3 resultset=1
cfprocresult name=result4 resultset=1
cfprocresult name=result5 resultset=1
In fact, you can also
David Green wrote:
Thanks all on the list, your emails have helped a lot in learning CF.
We have a very small shop and I'm trying to figure out how to upgrade
IIS to 4 or 5.I thought this happened when we loaded SP6 on the NT40
but when I go to IIS server manager help it tells
Each transaction could have a key of it's own stored in a table somewhere.
This could be automatically generated by your application. Or - it could be
fixed.
Dave
- Original Message -
From: Jeff Stone [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 04, 2001
Anybody have any resources enabling regular expression processing in T-SQL?
I try to keep as much processing in stored procs as I can and I would rather
do the regex parsing in SQL Server than on the CF page.
TIA
Don
~~
Get the mailserver that
for IIS4 go to
http://support.microsoft.com/support/iis/install/install_iis4.asp
--- David Green [EMAIL PROTECTED] wrote:
We have a very small shop and I'm trying to figure
out how to upgrade
IIS to 4 or 5.I thought this happened when we
loaded SP6 on the NT40
but when I go to IIS
Yes I am trying to format a phone number (it's kept in the database as
1234567890) for an output form. The problem is that the usual formatting
(CFSET TELEPHONE=(#left(SchoolInfo.TELEPHONE,3)#)
#mid(SchoolInfo.TELEPHONE,4,3)#-#mid(SchoolInfo.TELEPHONE,7,4)#)won't work
for this output so I'm
OK - while we're on the topic. You state . . .that CC numbers have patterns
in them that drastically reduce the number of valid resultsets . . . why not
use brute force to just churn out a bunch of valid credit card numbers and
use them
If you munge (encrypt) the cc numbers with a key -
Thanks everybody. I knew I was close. The resultset attribute was the
key thing I was missing. I guess if I would have read a little deeper, I
could have figured it out.
Thanks again!
Mark
-Original Message-
From: Kwang Suh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001
Except that if you generate a different key for each one. Then your crack
does not work.
Dave
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 04, 2001 12:31 PM
Subject: Re: Storing Credit Cards
Dave Hannum wrote:
I don't recommend against IIS but I do recommend against putting Front Page
customers and ColdFusion customers on the same box. Front Page is for
amateurs, and amateurs should be separated from the people that know what
they're doing.
Get the NT Option Pack 4.0 and all the latest hotfixes and
Hi There,
Upon hitting the back button to go back to a page with
the twoSelectsRelated tag on it, the first select box
maintains its selected option, whereas the second
select box reverts to the options available had the
first option in the first select box been selected,
causing an error when
OK - while we're on the topic. You state . . .that CC
numbers have patterns in them that drastically reduce
the number of valid resultsets . . . why not use brute
force to just churn out a bunch of valid credit card
numbers and use them
If by use them you mean try to make purchase
Use the code below...had the same problem, but if the page is not cached,
then it has to refresh when they hit the back button. they will get a
message saying this, but it tells them to hit refresh because the page has
expired. Never had a complaint here by doing this.
Christian
cfoutput
How about fixing the javascript so that when focus is lost (i.e., the user
backs into the form again) it will reset itself?
Other than that, you could disable the back button and force the use to use
links, which would reset the form because calling a CFM template would
generally cause the
Fellow listers:
I'm sure my question has been asked before but I don't see anything in the
archives that I need.
What happens exactly to session variables if users are forced to go through
a proxy server? Or, put another way, what does a proxy server do to session
variables?
My company
Try:
select ( left(Str(telephone), 3) ) mid(Str(telephone), 4, 3)
- right(Str(telephone), 4)
from ...
Just coding off of the top of my head, so definitely no guarantees. The
idea is that the Str function will eliminate the decimal point. If if
doesn't ,try:
select (
check these people out.. in PA.. own a bunch of small companies... they
could maybe use recruiting application...
http://www.pencor.com/
Paris Lundis
412-292-3135 (Cellular)
[finding the future in the past, passing the future in the present]
[connecting people, places and things]
For those interested
I used the following code snippet which I added to FormUrl2Attributes.cfm
!--- Check wether this string has a _string_ end. if so, remove the
trailing _ ---
!--- This _ was placed so cold fusion's server side validation doesn't
break my form value ---
CFIF NOT
Any system is only as secure as it's programmed and it's server shored up.
Granted, if you're doing business on the web in a manner that you're going
to store credit cards, then you better be able to afford to protect them,
whether it's PGP or other. My point is that PGP is not the end all for
my stupid mistake...
wrong email :)
-p
[finding the future in the past, passing the future in the present]
[connecting people, places and things]
-Original Message-
From: Paris Lundis [EMAIL PROTECTED]
Date: Thu, 04 Oct 2001 14:24:17 -0400
Subject: Re: Greeting Card Script
check
The following gives the desired output for me when TELEPHONE
is defined as char(10) in the database. Are you sure you're
retrieving TELEPHONE as character data and not numeric? Are
you able to output TELEPHONE without any formatting? Are you
able to add 1 to TELEPHONE? If yes, you have a
I have recently joined a company that had their site
built by a consultant agency. This agency build 95% of
the CF/dynamic site pointing to the .com/index.cfm file.
The parameters that are passed through the URL determine
the look and feel and the content that's shown on the
page.
I under
(Symantec use to own Act)
The company that makes Act says they do not support the
inserting of data through ODBC. Has anyone every
successfully done updates and insertions into Act
working around the ODBC issue?
I had to ask.
http://www.act.com
Thanks
if the code, as it is now, is as efficient as your reorg way, I would leave
it alone and come up with a way record the url params and analyze them. Why
re-do it?
A stored procedure in the application.cfm file might work well. There might
even be a way to record the url params in the log
CF_x_eCard is not much of a script at all.. I've tried it.. but thanks
anywho
--
Search the Holy Bible: http://www.bibleclicks.com
- Original Message -
From: Paris Lundis [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 04, 2001 1:41 PM
Subject: Re: Greeting
It sounds like the company building the site either used or tried to use
what is called Fusebox. This is actually a very good methodology and if the
site functions well at present I would not recommend changing it back to a
more conventional build. If the site breaks as a result you won't have
Shot in the dark, but..
Have you tried OLE ? ColdFusion will access OLE datasources just as if
they were ODBC datasources.
At 07:01 PM 10/04/2001 +, you wrote:
(Symantec use to own Act)
The company that makes Act says they do not support the
inserting of data through ODBC. Has
A quick fix _might_ be to force your server to single-threaded requests in your
CF admin ... definitely a performance hit but (with my very limited cf
experience) I understand that each page (template) will be fully locked until
served ... maybe this'll buy you the time to plug in those
Set up the page in the first place to have an onload event that runs the
changeMenu function, something like this:
CFOUTPUTSCRIPT LANGUAGE=JavaScript TYPE=text/javascript
function initPage() {
/*
Make sure the the second select box does not revert
Any system is only as secure as it's programmed and it's
server shored up. Granted, if you're doing business on the
web in a manner that you're going to store credit cards,
then you better be able to afford to protect them, whether
it's PGP or other. My point is that PGP is not the end
How can I list the fieldnames after using a query like cfquery
name=testselect * from table/cfquery?
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives:
If it is fusebox, you could replace the ?'s and the 's with slashes (/) and
your reporting tool may process the files thataway. Good for search engines
too.
Andrew Peterson
IOC Web Administrator
www.ioc.state.il.us
- Original Message -
From: Brunt, Michael [EMAIL PROTECTED]
To: CF-Talk
Columnlist.
Ie,
CFOUTPUTTHe columns are #test.columnlist#/CFOUTPUT
===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email: [EMAIL PROTECTED]
Yahoo IM : morpheus
My ally is the Force, and a
Another shot in the dark. Have you tried the MS DBase odbc driver? Or, can
you create a linked data source to the Act.dbf file thru something like MS
Access. Then use the ODBC for Access? Obviously, much testing would need to
be done before using this in a production env. Not the most efficient
look as this thread on the cf forums
http://forums.allaire.com/coldfusion/messageview.cfm?catid=3threadid=218632
highlight_key=ykeyword1=fusebox
Greg Jordan
Macromedia Certified ColdFusion Developer
Web Project Manager
[EMAIL PROTECTED]
Unified
Try #test.ColumnList#
Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-Original Message-
From: Brian Fox [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 1:03 PM
To: CF-Talk
Subject: Select * From - any
On 10/4/01, Alex Santantonio penned:
If you must store credit card info, it might be a good idea to follow some
of these steps in addition to the typical Secure Certificate and so on. You
should absolutely encrypt them using PGP or some other type of encryption.
I have used CF_PGP on several
On 10/4/01, Megan Cytron penned:
Another question: has anyone found any shared hosts that support
CFX_PGP?
Again, at $16,000.00 for a commercial license, I don't think you'll
find anyone.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions
Is there any function similar to directoryexists to check whether
the directory is writable.
--
saro cf
[EMAIL PROTECTED] - email
(818) 630-2340 x6093 - voicemail/fax
~~
Get the mailserver that powers this list at http://www.coolfusion.com
This is one of the disadvantages building an entire site around a Fusebox
type methodology. Let me guess what the Fuseboxers are going to say...code
your own statistics program? Rght. That is not feasible for every site,
and neither is Fusebox. I think the question is whether or not reworking
CSVs.
that is probably the best route.
Paris Lundis
[finding the future in the past, passing the future in the present]
[connecting people, places and things]
-Original Message-
From: Stephen Kellogg [EMAIL PROTECTED]
Date: Thu, 4 Oct 2001 16:15:19 -0400
Subject: RE:
I use cfx_pwcardcrypt. It's very affordable and setting the
encryption strength to 1024 bits takes a little under 1 second to
decrypt each card number. I store the private key right here on my
computer at home under a secret name then copy it and paste it in
when it's time to submit my
How can I list the fieldnames after using a query like cfquery
name=testselect * from table/cfquery?
Try test.ColumnList
It's a comma separated list of all of the fields in alphabetical order
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
Yeah I figured out the character part when I was reading sql healp. Guess
when I import the data I'll need to automatically convert it from
numericjust another thing to remember to do.
-Original Message-
From: Stephen Hait [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001
I'm working on a multilingual website right now, that pulls the content of
pages from a database broken down into tables by language.
Everything's working fine with the actual site, but while working on the
admin side, I'm having a bit of trouble.
I've tried used (HTMLCodeFormat), but this did
This is a good information, thanks.
Mike Brunt
Sempra Energy
213.244.5226
The nice thing about standards is that there are so many to choose from.
-Original Message-
From: Greg Jordan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 04, 2001 1:08 PM
To: CF-Talk
Subject: RE:
I didn't really propose a one key system. I used it as an example. When I
built one, I used a randomly generated key for each one. I was just
explaining it in it's simplest form.
Tried and true is usually best.
Dave
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk
I picked up one of those cue cats from radio shack today, has anyone ever
written a tag that will use this as a barcode scanner?
Rich
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ:
Here is a free CFX tag that used 3DES encryption and hex encodes the
results for URL safe transfer. Very fast and very secure.
http://dev.myownemail.com/coldfusion/CFX_HexEncode.htm
Chris
--
Original Message
From: Dave Watts[EMAIL PROTECTED]
Subject:
Here is a free CFX tag that used 3DES encryption and hex encodes the
results for URL safe transfer. Very fast and very secure.
http://dev.myownemail.com/coldfusion/CFX_HexEncode.htm
Chris
--
Original Message
From: Dave Watts[EMAIL PROTECTED]
Subject:
Here is a free CFX tag that used 3DES encryption and hex encodes the
results for URL safe transfer. Very fast and very secure.
http://dev.myownemail.com/coldfusion/CFX_HexEncode.htm
Chris
--
Original Message
From: Dave Watts[EMAIL PROTECTED]
Subject:
-- Here is code snippet for my stored procedure:
CREATE PROCEDURE spGetManagers
@OrderBy nvarchar(20) = 'LAST',
@OrderType nvarchar(10) = 'ASC',
@Id int = -1,
@ErrorStatus int OUTPUT,
@ErrorMsg nvarchar(255) OUTPUT
AS
...
-- Here is CF Code calling the stored procedure:
I know what they are, but how would you get them to work
with Act?
CSVs.
that is probably the best route.
Paris Lundis
[finding the future in the past, passing the future in the present]
[connecting people, places and things]
-Original Message-
From: Stephen Kellogg [EMAIL
I built a page for uploading multiple images for a contest. I'm using a nice
java app for PCs which handles multiple file uploads and a regular form
submission for Macs which handles files one at a time. The files upload
nicely on a mac running Navigator and fail with Internet Explorer. I saw an
ok, what if the CC numbers were stored in the database as this...
hga67IAHSIO7283hI:OH:LHSAIYo*(^*23600*A_UAIOUSDOI[pa][p}OQU*(^@#*%(@#IUDASGUIGASGKLGAGSDAIUGTDYIUSA
and the algorithm to crack it lies safely and securely on the server (not in
the root).
is it possible to guess the CC now?
If I can access your server somehow (i.e. some sort of security compromise) and find
that key I don't need to guess.
First place I'd look would be your CF templates. You probably have to read that key
sometime from one of them.
---
Matt Robertson
Has anyone ever looked into developing a CFX tag that makes use
of GnuPG on NT? Given that the PGP commercial server license is
so exhorbitant ($7000+), I, for one, would be willing to pay for
a CFX tag that used the freely available GnuPG... I think shared
hosts would also buy in, since this
I'm pulling out my hair here trying to replace characters with accents
(ie: é, á, etc) as nothing seems to be working in my replace statemen
ts.
I've tried the following, all to no avail:
CFSET newbody_html = REReplace(#FORM.newbody#, #chr(130)#, eacute;
,
ALL)
CFSET newbody_html =
How to preserve the ordering of columnlist returned by cfquery.
By default it is ordering by alphabetical.
I need the same column order specified in table.
-Saro
--
saro cf
[EMAIL PROTECTED] - email
(818) 630-2340 x6093 - voicemail/fax
~~
My company has finally decided that they are going to keep Cold Fusion
around rather than moving the entire site to Java Server Pages (though we
are doing all new dev in jsp). We never upgraded from 4.01 to 4.5. We're
exploring the risks of this upgrade. I've hear that it is necessary to
upgrade
Have you tried specifying the order of the columns (random shot in the
dark, not sure if it works) like this:
CFQUERY
select table1.column1, table1.column2, table1.column2
from table1
/CFQUERY
. . .
I'm just not sure why it would matter the order in which the columns are
returned.
You can still get Cue Cat's?
http://www.zdnet.com/anchordesk/stories/story/0,10738,2778828,00.html
Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
-Original Message-
From: Rich Tretola [SMTP:[EMAIL PROTECTED]]
Sent: Thursday,
1 - 100 of 119 matches
Mail list logo