With SQL Server 2000, you can retrieve query results directly in XML. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_o
penxml_1hd8.asp and the links under it in the toc.
-David
On Monday, June 25, 2001 10:26 PM, Ryan Sabir [SMTP:[EMAIL PROTECTED]] wrote:
Please disregard
~~
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/
Unsubscribe:
Is there a custom tag that will take the result set of a query and write it
to an XML file?
CF_QueryToXML, at
http://devex.allaire.com/developer/gallery/info.cfm?ID=04AB8F8C-63C0-11D5-83
F600508B94F380method=Full
does what you want. Here's the description:
QueryToXML allows you to query a
Hello cf-talk,
I need to design a product compatability guide for a client. I'm
looking for the best database setup.
1. We need a drill down feature for product brand, product year, and
product model. A user will first choose the Brand, then the year,
then the model.
2. I'll use
I'm a bit confused. I have 2 identical cfm pages. The pages do very little
CF at all - just a couple of includes. The Only difference is that one of
them has a CFCACHE at the top of the page. The one with the CFCACHE takes
about 171 milliseconds to execute and the one without takes about 60
Hi all. I finally broke down and installed 4.52. Now once a day or so
I'm getting a cfserver.exe Doc Watson and CF is shutting down. Any
idea what to look for? Never happened in over a year of running 4.01.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
where has everyone gone?
~~
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/
Unsubscribe:
I had this too a few weeks ago - eventually it turned out one of the DBs was
corrupt (Access...)
Will
- Original Message -
From: Bud [EMAIL PROTECTED]
Newsgroups: cf-talk
Sent: Tuesday, June 26, 2001 12:51 PM
Subject: Doc Watson
Hi all. I finally broke down and installed 4.52. Now
do you use session vars? do you lock them? we had to apply a fair amount of
CFLOCK to our web apps when we upgraded to 4.5.2 a while back.
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 4:51 AM
To: CF-Talk
Subject: Doc Watson
Hi all. I finally
I am just starting to use CFPOP, does this tag have limitations like CFMAIL does or is
it pretty good?
TIA,
Clint
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
CFPOP has far more limitations that CFMAIL. CFPOP chokes on a number of
different multi-part mail formats for starters. We use a combination of COM
and JMS in place of anything CF/POP3 related. CFMAIL works great, however.
-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
I can send to the group, and I can see my email show up in the
archive, but I have been getting nothing for days. Michael what is going on.
You said yesterday on js-jive it would be fixed within the day. It's been
just about 24 hours since you said that and I haven't gotten anything.
I think I will set it up this way:
These tables are no-brainers:
Brand (BrandID, otherbrandinfo)
Year (YearID, year)
Model (ModelID, othermodelinfo)
The intersection tables can get a little confusing. I would set it up this
way, with one Intersection table:
BrandYearModel
hi,
hi. i'm modifying a form i've built, to allow field names to be dynamically altered
during each iteration of a loop. as it was originally, one of its input clauses might
look like this:
CFINPUT TYPE=text NAME=PremAddress SIZE=30
MAXLENGTH=40 VALUE=#PremAddress#.
however, as i need
Sorry for the OT, but . . . .
I stopped IIS via the IIS administrator. I right clicked on Default Web
Site and then clicked Stop. Now, when I go in and manually try to restart
it, an alert box pops up that says: Internet Services Manager Address
Already In Use. I've tried everthing I know
do you have multiple websites and there is another one running and competing
for the port?
- Original Message -
From: Dave Hannum [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 9:10 AM
Subject: OT: Can't restart IIS server
Sorry for the OT, but . . . .
Just the one site on the server.
Dave
- Original Message -
From: Don Vawter [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 11:14 AM
Subject: Re: Can't restart IIS server
do you have multiple websites and there is another one running and
competing
for
Hi, try this:
VALUE=#PremAddress#_#ThisIter#
- Original Message -
From: [EMAIL PROTECTED]
hi,
hi. i'm modifying a form i've built, to allow field names to be dynamically
altered during each iteration of a loop. as it was originally, one of its
input clauses might look like this:
Sorry then I guess I will leave it up to gurus. The only time I had that
problem was when I had multiple websites competing because I forgot to put
header information in.
- Original Message -
From: Dave Hannum [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001
Well, we delt with it. We bumped the box (didn't want to have to do that,
but . . . ) and now all is fine.
Thanks,
Dave
- Original Message -
From: Dave Hannum [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, June 26, 2001 11:25 AM
Subject: Re: Can't restart IIS server
Why don't you try to connect to the loopback address ( http://127.0.0.1 or
http://localhost ) and see if anything comes up.
- Original Message -
From: Dave Hannum [EMAIL PROTECTED]
Just the one site on the server.
Dave
- Original Message -
From: Don Vawter [EMAIL PROTECTED]
At 11:48 AM 06/26/2001 -0400, you wrote:
Hi!
I have an Access table that holds the hierarchy of headings (for a
topical index) for a large law and policy journal, and I'm very,
very confused about how to use it. The columns it has are
parentheadingID, childHeadingID fields, and haschildren
Hi,
Is there a discussion group or mailing list dedicated to Gordano's NT Mail
suite?
Any pointers appreciated.
--
Will
new media discussion for Berkshire -=- http://cf.lukrative.com
local classifieds -=- http://www.localbounty.com
e: [EMAIL PROTECTED] icq: 31099745
Hi!
For transaction purposes, I need to generate
a text document with certain variables.
I have no idea how to do this.
TAI,
Michael
~~
Structure your ColdFusion code with Fusebox. Get the official book at
I am having the opposite problem. I can read http_referer in IE but not in NN - in a
frameset.
-- Tim Bahlke
- Original Message -
From: Martin Cadirola [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, December 21, 2000 11:42 PM
Subject: JS, http_referer and browser
Who's your ISP? The list is working fine for a number of people. If the list
were the problem it would be an issue for everyone. Sometimes smaller ISPs
take longer to update their DNS cache/settings. And a fair number of them
don't know much about DNS to begin with.
Of course, you knew that
Hi,
IE will never be convinced to set HTTP_REFERER from a window.open() call.
But you can do this trick:
A HREF=popupWindow.cfm
TARGET=WINDOWNAME
ONCLICK=window.open('popupWindow.cfm', 'WINDOWNAME',
'resizable,scrollbars=1,menubar=0,width=400,height=300');return
true;popup/A
(Diagnostic Data: using Oracle 8i, ColdFusion 4.51 SP2, Oracle native
drivers)
I have a table where I store user session information. At some point
over time, the index corrupts itself and i begin to get foreign key
constraints because it'll attempt to insert a row using a key ID that
has
That's proper database design, but don't you think you're pushing it a bit?
I mean, there are only so many years and year numbers never change. I think
it would be just as appropriate to just use the 4-digit year in the lookup
(BrandYearModel) table, and would doing that speed up the queries a
Interesting. This is another good argument for using a key table guys.
Anyway, run the Oracle stored procedure to generate a number, then check for
the existence of that number in the primary key field in the table you want
to insert into. If the number exists, generate another number and
Hi,
I have the following dropdown menu. I would like to be able to redirect to
a new page based on one of the selections below.
I'm not sure of the proper syntax.
CFFORM ACTION=index.cfm METHOD=GET ENABLECAB=Yes NAME=form2
nbsp;nbsp;
SELECT NAME=md
First of all, don't use CFFORM. In fact, NEVER use CFFORM. Roll your own
JavaScripts for validation instead.
Second, use the following code for your nav form:
form action=redirect.cfm method=post onChange
select name=theurl onChange=document.forms[0].submit()
option
| First of all, don't use CFFORM. In fact, NEVER use CFFORM. Roll your own
| JavaScripts for validation instead.
Why not? For _simple_ validation, it's quick, it's easy, and it does the
job. Besides, when you combine it with CF validation and then database
validation on top of that, it's not
Mark, are you suggesting one flat table?
Jeff Fongemie
Mark Warrick [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
That's proper database design, but don't you think you're pushing it a bit?
I mean, there are only so many years and year numbers never change. I think
it would
No, you've thought it out thoroughly. We just differ on opinions is all.
As you pointed out, the parameters of CFFORM are very limited. The issue
about validation on the backend is a totally separate issue and I agree with
you 100%.
The reason I say you shouldn't use CFFORM is twofold: the
FYI
It's not restricted to small ISP's. We have two ATT T1's, one terminated
on a backbone that goes to Washington D.C, the other to Chicago. We don't
manage our own DNS, but we did register some new domain names recently and
they propagated pretty quickly.
I haven't gotten any mails since
Nope, I'm suggesting the same thing as Jeff Houser suggested with one
exception. Instead using a lookup table for years, I suggest just using a
column labled ModelYear and using the 4-digit year. Additionally, I would
format that field as a Date/Time field rather than a numerical or text field
It does. One thing I can say is that more people are getting on, but the
back mail still hasn't gone out. Things will get fixed. No matter what, they
will be.
All the best Mikey D, I know it has your full attention!
All the best,
Kevin
-Original Message-
From: Dylan Bromby
Sent:
Maybe it's because you're from the wrong side of the Liffy? :-)
Just messin.
-Original Message-
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 2:15 PM
To: CF-Talk
Subject: RE: RE: STILL CAN NOT GET CF-TALK EMAIL
FYI
It's not restricted to small ISP's.
If when someone comes down the line saying 'I want to know x info on all
brands from this year' wouldn't it be more efficient to be selecting that
information based on an ID than it would a date time field? I do not have
specific numbers to prove that theory. Has anyone out there had
I'm using code from CFComet to generate an excel spread sheet from a sql
query but i'm having trouble getting the ado connection to open. I think
perhaps the problem is that i'm replacing MyDSN (CFSET Datasource =
MyDSN) with the wrong value. I'm using the name of the datasource that i
specified
My understand, based on what an expert (seminar instructor) said was that
yes, IIF is significantly slower than using CFIF and should be avoided if
possible. But there are cases where IIF can be used where CFIF can't. For
example, one way of alternating the highlight background color on table
So, this did not get through from my host... here's one from my ISP.
This weird!
I haven't received any posts for about 4 days (6 posts) and very
few in the last week.
I tried resubscribing several times through my web host email
address... no luck!
So, I tried subscribing with my ISP
Here's an example of how I use CFIF to alternate row colors. In practice, I
use this with CFOUTPUT, but here I've used CFLOOP so the example is
stand-alone.
--
CFSET bgcolor = FF
TABLE CELLPADDING=5 CELLSPACING=0 BORDER=0 WIDTH=600
Sure it can...
tr bgcolor=cfif getitem.currentrow mod 2bluecfelsewhite/cfif
At 3:40 PM -0700 6/26/01, Bruce Holm wrote:
My understand, based on what an expert (seminar instructor) said was that
yes, IIF is significantly slower than using CFIF and should be avoided if
possible. But there
I just got back on the list today, I think I resubscribed on the 22nd
and got a few messages then nothing until I rebsubscribed again today, and I
have received a few messages so far.
I have cleared my dns servers cache (which was the old ip), but what is
strange is that the messages that I
and much cleaner :)
-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 4:07 PM
To: CF-Talk
Subject: Re: IIF vs if,else
Sure it can...
tr bgcolor=cfif getitem.currentrow mod 2bluecfelsewhite/cfif
At 3:40 PM -0700 6/26/01, Bruce Holm
Does anyone know how to call a static method as opposed to calling the
constructor to instantiate an object using CFOBJECT? I've got a
Singleton object that I am trying to implement, but when you use
CFOBJECT with the CREATE action, it attempts to instantiate the object
by calling the
Sorry if you got this already but since not a soul replied (are there no
Southern CA, IE CF'ers out there?? :-() I'm trying again, my first post was
right before a mail server hiccup I think so maybe the message got
bamboozled somewhere.
I'm interested in starting a CFUG in the Inland Empire
I can send to the group, and I can see my email show up in the
archive, but I have been getting nothing for days. Michael what is going
on.
You said yesterday on js-jive it would be fixed within the day. It's been
just about 24 hours since you said that and I haven't gotten anything.
Please
50 matches
Mail list logo
