On Friday 13 Jun 2003 05:36 am, Dave Carabetta wrote:
http://www.impossibilities.com/blog/entry_blog-110.html
What I really liked besides his viewpoint was the user's comment at the
bottom linking to http://www.laszlosystems.com/. That is one kick-a**
:nods
Looks like it'll do for Flash what
I've had the same issue.
Go into the MX admin and change the client variable storage to cookies. (Not
great) but this should solve it.
It seems to be some sort of persistance issue. This solved it for me.
-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]
Sent: 13 June 2003
Look at CFCONTENT
[EMAIL PROTECTED] 06/12/03 08:12PM
Hello All,
I'd appreciate it if someone code point me to some coding examples for
downloading datafiles from CF.
Like Cassidy, I'd like to provide my customer with data in an Excel
format.
I believe I can develop some Excel macros that will
Help!
I have an application setup on a CFMX server and everything is fine. It
is a VERY simple app, and one of the pages writes a cookie, then
redirects to another page (was with CFLOCATION, but now changed to JS).
I am trying to move this app to a CF Server 5 machine, and the cookies
won't
We have noticed the same thing. We have an application where the user
enters a job number and using CFDIRECTORY we retrieve all of the files in
several directories that match a pattern using that job number. We then
display a grid of record counts for the user to verify. Once verified the
user
Maybe some owe Peter an apology. It wasn't more than 4 days ago he got
flamed for merely mentioning 'Red Sky Beta'.
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
-Original Message-
From: Damon Cooper [mailto:[EMAIL
Shawn,
Coincidentally I've run through all the avenues you are speaking of as
I'm conflicted with the same issue. Here's my idea, although the
security may not be 'tight' enough for you.
My setup looks like this
com.theSystem.utils (Holds universal methods like 'getDataType')
I hope they are true to their word. I have a site I'm currently working on
using css-p and the client wants to be able to modify the code using FP.
Everytime he does something to the page I'm seeing all kinds of font tags
and span tags and all kinds of other stuff and I have to go and fix it.
Ben
A few suggestions from someone who suffered from this ailment and somehow got it
resolved :)
1. create a temp table with the same data and then query the temp table. This will
eliminate issues with other user locking the main table.
2. change the query to a stored procedure. SPs do run much
Hi,
We have a potential project coming up from a client that uses MS Site Server
for their authentication of services... Does anyone know if CF can integrate
with this for authentication? And if so any problems to be aware of ?
TIA
Mikey
Are you looking for the data file to appear in the browser window,
or
are you looking for the client to save the data file to his/her local drive, and then
execute the macros locally?
Jerry Johnson
[EMAIL PROTECTED] 06/12/03 08:12PM
Hello All,
I'd appreciate it if someone code point me
Allright,
Luckily Im off on holiday this afternoon for two weeks and I don't even
want to be looking at a computer!!!
Is there any way I can stop the list sending me messages without
deleting my account (ie a blank email address or something)?
Had a root about but don't see any options for it.
would cf_html2excel be of any use to you? we use it and from what I
understand it does what you're asking
Cheers
Simon
Jerry Johnson wrote:
Are you looking for the data file to appear in the browser window,
or
are you looking for the client to save the data file to his/her local drive,
unsubscribe
==
Stop spam on your domain, use our gateway!
For hosting solutions http://www.clickdoug.com
ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772
==
If you are not satisfied with my service, my job isn't
oi David!!
set your subscription for web viewing...
Friday, June 13, 2003, 9:32:51 AM, you wrote:
DCi Allright,
DCi Luckily Im off on holiday this afternoon for two weeks and I don't even
DCi want to be looking at a computer!!!
DCi Is there any way I
How do you do that? All I get is the option to change:
First Name
Last Name
Current Password
New Password
Primary Email
Thats all the options I get in 'Edit Account'. None of the others seem
to have any settings that would let me do this...
I could just unsubscibe and then resubsciribe, but
I am looking for a web based project management software package that isn't
overly complex. Free is good, but I am open to suggestions, and no MS
Project.
Any help is appreciated.
---
Kevin Kazmierczak, CCNA
Certified Advanced ColdFusion MX
Alright, I'm sure I'm missing something simple, but ... I'm trying to
force a file download using the following code in a template called
force_download.cfm:
CFSET filename = test.pdf
CFSET fullpath = c:\test.pdf
CFHEADER name=Content-Disposition value=attachment;
#variables.filename#
CFCONTENT
how about M$ Project. :-)
- Original Message -
From: Kazmierczak, Kevin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:11 AM
Subject: OT: Web based Project Management
I am looking for a web based project management software package that
isn't
overly
Instead of: value=attachment;#variables.filename#
shouldn't it be value=attachment;#variables.fullpath #
Not sure without testing.
Shawn
-Original Message-
From: Matt Kornguth [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 7:12 AM
To: CF-Talk
Subject: Force download of file
I have some really large number ranges that I need to store in a SQL Server 2K DB.
The numbers are of the following size:
range start
00
range end
99
That was one generic example. Basically the number represents a phone number range and
This worked for us (IE was the problem for us tho) and remember and
change the content type
!--- TO FORCE A DOWNLOAD---
cfset sFileName = IFormData_ dateformat(now(),mmdd)
timeformat(now(),HHmm) .csv
!--- IE 5.5 has bug and need to give it slightly diff header info ---
cfif FindNoCase(MSIE
Shawn,
From everything I've read, the value should be #variables.filename#.
Gave it a shot anyway ... No luck ... Does essentially the same thing.
Thanks though. Anyone else?
-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:18 AM
To: CF-Talk
Shawn Regan wrote:
Instead of: value=attachment;#variables.filename#
shouldn't it be value=attachment;#variables.fullpath #
Neither, it should be:
value=attachment; filename=#file#
See RFC 2616, section 19.5.1
Since user agents are explicitly forbidden to use the supplied path, it
doesn't
can you store them as varchar and convert them on the fly?
-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:25 AM
To: CF-Talk
Subject: numbers too big
I have some really large number ranges that I need to store in a SQL Server
2K DB.
Are you not having problems with the 0's being knocked off the front of
the phone numbers - I have had to store them as varchars before
HTH
Simon
Michael Tangorre wrote:
I have some really large number ranges that I need to store in a SQL Server 2K DB.
The numbers are of the following size:
check out iTeamwork.com. Fairly basic (not overly complex)...and free :)
charlie
-Original Message-
From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 7:11 AM
To: CF-Talk
Subject: OT: Web based Project Management
I am looking for a web based project
Why 30 digits?, I'm not aware of any numbers of greater than 20 digits, even
with the International diaing code.
Jason Lees
Development Team Leader
National Express.
-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]
Sent: 13 June 2003 15:25
To: CF-Talk
Subject: numbers
Kaz,
check with Jim on that iTemawork, I think he used that a year or so ago when
we were in Alfred.
Mike
- Original Message -
From: Charlie Griefer [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:46 AM
Subject: RE: Web based Project Management
check
Can you confirm this? I would need hard proof.
I appreciate the insight however.
Mike
- Original Message -
From: Jason Lees (National Express) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:48 AM
Subject: RE: numbers too big
Why 30 digits?, I'm not
[sorry if you get this twice, but it doesn't show up here]
Michael Tangorre wrote:
The numbers are of the following size:
range start
00
range end
99
That was one generic example. Basically the number represents a phone number
overly complex. Free is good, but I am open to suggestions, and no MS
Project.
Dan
=== Previous Message Below ===
-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:16 AM
To: CF-Talk
Subject: Re: Web
Michael Tangorre wrote:
The numbers are of the following size:
range start
00
range end
99
That was one generic example. Basically the number represents a phone number range
and I have a range for each country in the world
No specific proof, but thinking about it logially
International dialing allow 4 for Expansion (there aer some 3 digit codes),
For Regional Exchanges allow 4 digits ( Regions), Local Exchanges allow
4 digits, that leaves you five digits spare for individual phones.
That would give you
I've lightly used a php one called dot.project. I think I found it on
SourceForge. I'd be interested in other things you find.
how about M$ Project. :-)
- Original Message -
From: Kazmierczak, Kevin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:11
Hi Jerry,
The latter. I believe I can develop the VBA code to automatically import the
.txt file into Excel once the .txt file is present.
But I have no objections to having the user see the data before they
download. Probably a good idea.
Thanks.
Paige
---Original Message---
It's MM's decision to release info about the beta, not the testers.
M
-Original Message-
From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 8:44 AM
To: CF-Talk
Subject: RE: RED SKY BETA
Maybe some owe Peter an apology. It wasn't more than 4 days ago he got
Good Morning Simon,
Thanks. I wasn't even aware of cf_html2excel, and I dont see it in my CF 5
book. Where can I find info on that?
Paige
---Original Message---
From: [EMAIL PROTECTED]
Date: Friday, June 13, 2003 09:32:11 AM
To: CF-Talk
Subject: Re: Downloading data
would
I just found this site:
http://www.1areacodescountrycodes.com/all-country-code-numbers-countrycodes.htm
which shows some 5 digit country codes...
- Original Message -
From: Jason Lees (National Express) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 11:14
Hi all,
If a datasource verifies OK in CF Admin on a shared host, what would cause
the connection to fail?
I detached a SQL Server database and FTP'd a copy to the host (couldn't get
DTS to work...but that's another problem). He created an ODBC system data
source on his Windows box then set up
Does anybody have any web based bug tracking suggestions?
E
- Original Message -
From: Charlie Griefer [EMAIL PROTECTED]
check out iTeamwork.com. Fairly basic (not overly complex)...and free :)
charlie
~|
Archives:
You may have to specify your username/pwd for the datasource. I have seen
connection issues when this is the case.
HTH
Clint
- Original Message -
From: Dina Hess [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:22 AM
Subject: DBAs/SQL Server experts?
Hi
Is this in MX??
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
Check your application.cfm. Do you have all the right log in info for
SQL?
Dan Phillips
www.CFXHosting.com
1-866-239-4678
[EMAIL PROTECTED]
-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 11:23 AM
To: CF-Talk
Subject: DBAs/SQL Server experts?
I am submitting an HTTP Get command to grab some XML data.
the following data is returned (very simple).
?xml version=1.0 encoding=iso-8859-1 ?
!DOCTYPE hgi (View Source for full doctype...)
- http://www.homemadegourmet.com:81/ca/diststat.xml?DIST=1002#
hgi
-
Lighten up, it's Friday.
Peter I apologize for all the anal jealous bastards (no one in
particular) on this list, cuz MM announced the beta _publicly_ June 2.
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
-Original
http://www.cornfeed.com/index.cfm?p=productsn=cfticket
They have a product called CF Ticket.
Don't have any other info, but I believe the developers are members of this list.
Jerry Johnson
[EMAIL PROTECTED] 06/13/03 11:29AM
Does anybody have any web based bug tracking suggestions?
E
-
have you re-attached the database and restored it? When you restore, you
will need to reset all of your connection info for that database (unless you
are using sa as a login)
-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]
Sent: 13 June 2003 16:23
To: CF-Talk
Subject:
I think you will find that most of the people who complained about the NDA
breach have actaully been on it since Alpha 1!
-Original Message-
From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED]
Sent: 13 June 2003 16:42
To: CF-Talk
Subject: RE: RED SKY BETA
Lighten up, it's Friday.
Peter
I recently installed Bugzilla (http://www.bugzilla.org/). It takes a
little getting used to, but it's decent. My favorite is GNU GNATS
(http://www.gnu.org/software/gnats/), but I have only used it with
TKGnats, and have not tried a web interface on top of it.
Christian
On Friday, June
Actually, I'm running CFMX on my development box and the application has
been ported to a shared server running CF 5. Do you think that is related to
this problem?
- Original Message -
From: Bryan Stevenson [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:37
Bugzilla is good, as is gforge.
http://mozilla.org
http://gforge.org
---
Josh Trefethen
Expert hosting
http://exciteworks.com
-Original Message-
From: CF Dude [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 8:30 AM
To: CF-Talk
Subject: OT
Does anybody have any web based bug
Hey Christian..MM already have a decent bug system for for their
products!
-Original Message-
From: Christian Cantrell [mailto:[EMAIL PROTECTED]
Sent: 13 June 2003 16:43
To: CF-Talk
Subject: Re: OT
I recently installed Bugzilla (http://www.bugzilla.org/). It takes a
little
http://gforge.org
---
Josh Trefethen
Expert hosting
http://exciteworks.com
-Original Message-
From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 7:11 AM
To: CF-Talk
Subject: OT: Web based Project Management
I am looking for a web based project management
You may have to specify your username/pwd for the datasource. I have seen
connection issues when this is the case.
My host did specify a username/password in CF Admin for the datasource. And
the data source verifies fine on his server. That's why I don't understand
why my application isn't
I'm with you adam, it all seemed a little over the top even now, several
days later.
I think just a prod from an official MM guy would have been
sufficient
Its up to *them* to enforce *their* law methinks
Lighten up, it's Friday.
Peter I apologize for all the anal jealous
Hello All:
Does anyone know how to use a hyphen in a variable name for a cfoutput?
For example:
cfset my-name = Jim
cfoutput#my-name#/cfoutput
Im outputting a field in a LDAP server that has a hyphen in its name
and I cant seem to output it in ColdFusion.
Regards,
James Blaha
try and do a solid connection and see if it worksi.e.
cfquery name=queryname
datasource=datasource
username=username
password=password
select * from table
/cfquery
-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]
Sent: 13 June
If your using MX
cfset Variabes['my-name']='Jim'
cfoutput#Variabes['my-name']#/cfoutput
-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 11:49 AM
To: CF-Talk
Subject: Hyphen in a variable name?
Hello All:
Does anyone know how to use a hyphen
have you re-attached the database and restored it? When you restore, you
will need to reset all of your connection info for that database (unless
you
are using sa as a login)
Well, I thought it might have something to do with the detach/reattach
thing, but if the database hadn't been
Basically I have gathered enough information from the help everyone has
provided to solve my problem. If anyone needs xls files with country code,
exhange and other related numbering information this site has them, some
free, some not...
www.numberingplans.com
Thanks again for the help everyone.
James,
Don't know if this will help, but take a look at the RenameQueryColumns
custom tag. Called like this:
CF_RenameQueryColumns
QUERY=getProductName
ACTION=MAKESAFE
NEWQUERY=getProductNameRenamed
MAKEUNIQUE=Yes
try and do a solid connection and see if it worksi.e.
cfquery name=queryname
datasource=datasource
username=username
password=password
select * from table
/cfquery
Tried that already, but I'll give it another go. Thanks.
Check your application.cfm. Do you have all the right log in info for
SQL?
Dan, I have the data source set up in Application.cfm in the request scope.
That's all I need, isn't it? (When we started having problems with this, I
did specify the exact username/password my host used in his CF Admin
yes, it could, especially if the db was created first within EM. As far as
SQL is concerned the system could work AOK but there is no data.
Are you getting ODBC errors of table does not exist etc.
-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]
Sent: 13 June 2003 16:54
Bryan,
Thanks, does this work in CF 5?
Regards,
JB
Bryan F. Hogan wrote:
If your using MX
cfset Variabes['my-name']='Jim'
cfoutput#Variabes['my-name']#/cfoutput
-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 11:49 AM
To: CF-Talk
Subject:
I have a list of organizations, their email, address, phone, contact person
etc...
The displayed table is as follows:
Organization - Address - Phone - Contact Person
a href=mailto:#email#;Organization Name/a - #address# - #phone# -
#contactPerson#
Now, things became a little more complicated.
There is no need for login info in the Application.cfm, as ColdFusion handles
that just fine.
I would think all one needs is the name of the datasource, and possibly the type
ODBC
==
Stop spam on your domain, use our gateway!
For hosting solutions
MX can act quite strange with DSNs
How I get around it screwing things up:
-setup System DSN through Windows ODBC (tell it to use Windows
Authentication)
-setup DSN in CF Admin (this is where you put the username and pass)
If I don't do it in that orderKABOOM!!
HTH
Cheers
Bryan
Not only announced it, but the project manager has been posting constant updates
on this list, and I would imagine it is not a violation of the NDA to discuss
his updates. I for one, hopefully am now part of the solution and not part of
the problem, either perceived or real.
Most Beta projects
No but you can create your own variable scope structure such as
cfset myVariables=StructNew()
cfset myVariables['my-name']='Joe'
cfoutput#myVariables['my-name']#/cfoutput
and it works exactly the same way. But you have to set the value into the
structure you can do a cfset my-name='Joe'
use this around your contactName
codesnip
cfif trim(query.contactEmail) neq
a href=mailto:#trim(contactEmail)##trim(contactName)#/a
cfelse
#trim(contactEmail)#
/cfif
HTH
Clint
- Original Message -
From: mayo [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June
you can not do a cfset my-name='Joe'
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 12:30 PM
To: CF-Talk
Subject: RE: Hyphen in a variable name?
No but you can create your own variable scope structure such as
cfset myVariables=StructNew()
This may be better posted on a SQL board, but I know there are a lot of SQL
Server gurus out there and I need your help!
A client's web host just had to reinstall SQL Server 2000, and I am having a
hard time getting a former user name to work properly, or setup a new user
name.
If I setup a new
You do have to commend them for the effort they have obviously made. Good
PR.
Dana
On Fri, 13 Jun 2003 11:34:02 -0500, Doug White [EMAIL PROTECTED] wrote:
Not only announced it, but the project manager has been posting constant
updates
on this list, and I would imagine it is not a
Not positive about this, but...
I believe that I read somewhere you can't delete the user if it has objects
assigned to it. IE Tables.
Make sure that all of the objects that this owner used to have are changed
to have dbo (or sa) as the owner. Then you might be able to delete the user.
Steve
Matt,
Looks interesting. Where can I get the tag from MM?
Regards,
JB
Matt Kornguth wrote:
James,
Don't know if this will help, but take a look at the RenameQueryColumns
custom tag. Called like this:
CF_RenameQueryColumns
QUERY=getProductName
ACTION=MAKESAFE
Clint,
How does this impact processing speed? Each record will have to be
evaluated, hence 100s of if-elses each time the page is displayed.
-- glm
-Original Message-
From: Clint [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 12:31 PM
To: CF-Talk
Subject: Re: efficient
MX can act quite strange with DSNs
How I get around it screwing things up:
-setup System DSN through Windows ODBC (tell it to use Windows
Authentication)
-setup DSN in CF Admin (this is where you put the username and pass)
If I don't do it in that orderKABOOM!!
Bryan, the DSN
You will probably want to change the object owner for each table to the dbo
user. You do this using the sp_changeobjectowner stored procedure on each
table - either in query analyzer, or a script you've written. I've pasted
the books online entry for this - I have it book marked :)
Adam.
Basically I just wanted to re-open my issue and it is bigger than I first imagined...
anyways, has anyone tried to calculate using any language, what country a phone number
relates to? Basically I thought I had it until I realized that some country codes
overlap if the ones being compared are 2
Are you getting ODBC errors of table does not exist etc.
Yes.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
Heylo
Im using a cftry - cfcatch sort of thing for the first time, and I want to
email myself the error message that gets produced... How do you do this?
TIA,
Ryan
~|
Archives:
Sorry if I missed it, but what's ther error message in full that you're
getting??
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate
Do a search for 'renamequerycolumns' at
http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_usview=sn10
5viewName=Exchange%20Search. Should be the only resulting file. Also,
you may need the CFX_QueryColumns tag as well (also available at MM).
If you have any problems, let me know, I'll
Pretty easy, and fun too, in MX.
cfcatch ...
cfmail to... from.. ect
cfdump var=#cfcatch#
/cfmail
/cfcatch
The same thing will work in other version, but I don't remember when cfdump
came along? 5? MX? If you don't have the dump, you'll just have to do a bit
more
I use this all the time and its very quick.
Clint
- Original Message -
From: mayo [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 13, 2003 11:49 AM
Subject: RE: efficient solution, problems with
Clint,
How does this impact processing speed? Each record will have
Here's the basic idea. You can make it far more complex, but all mechanisms
basically boil down to this.
cftry
... potentially failing code
cfcatch type=any
cfmail to=[EMAIL PROTECTED]
from=[EMAIL PROTECTED]
And it gets even trickier when you take into account the various city codes
that need to be applied after the country code. While it's not a list, ATT
has an online city code look up utility at (make sure to use the lower drop
down menu/button):
Try this
cfquery name=queryname
datasource=datasource
server=servename
username=username
password=password
-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 12:01 PM
To: CF-Talk
Subject: Re: DBAs/SQL Server experts?
try and do
...or why not just alias that column name in your query?
Select [product-code] as productcode
From
Wouldn't that save some processing time? Keep the load off cf?
Best practice to just avoid hyphens and spaces in column names. Use
camelCase to denote extra words.
-Original
thx, I thought I might have been overly worried about something
inconsequential.
-- glm
-Original Message-
From: Clint [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 1:03 PM
To: CF-Talk
Subject: Re: efficient solution, problems with
I use this all the time and its very quick.
You could do it on the SQL side with a custom field. At least you would be
offloading the heavy lifting to SQL. Not sure if it makes sense to tackle it
this way, but just I tested this and it works...
cfquery name=testQuery datasource=testdb
SELECT dbo.test.organization,
dbo.test.address,
Don't want to speak for James, but the aliasing never worked for me. And
I tried every possible combination ... But then again that might have
just been a limitation of the ODBC driver I need to use.
-Original Message-
From: Costas Piliotis [mailto:[EMAIL PROTECTED]
Sent: Friday, June
Hehehe, alright I recant the jealous part.
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 11:33 AM
To: CF-Talk
With what database? I mean, every rdbms out there should support aliased
fields... That's been around like forever... At list since the Ansi-88
standard...
Heck, even MS Access allows you to alias fields...
-Original Message-
From: Matt Kornguth [mailto:[EMAIL PROTECTED]
Sent:
But I emphasize the anal part.
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
-Original Message-
From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 1:25 PM
To: CF-Talk
Subject: RE: RED SKY
Progress database. If you've never heard of it, you're not alone. Our
fulfillment system is completely in Progress.
And I could be wrong, but I don't think it is a rdbms limitation in my
case, but rather a limitation of the OpenLink driver used to connect to
it.
Very possible that James could
Sorry, I just couldn't resist.
Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
-Original Message-
From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 1:31 PM
To: CF-Talk
Subject: RE: RED SKY
I don't find that reported in our own systems but I did fine a knowledge base article
regarding it on Data Direct's web site, take a look:
http://knowledgebase2.datadirect-technologies.com/kbase.nsf/0/f9fd671b87594eb385256c76006cd3c8?OpenDocument
Christine
-Original Message-
From: Tim
1 - 100 of 184 matches
Mail list logo