You're using session variables in the query, but you're not setting them
anywhere on this page.
- Original Message -
From: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 11:25 PM
Subject: Checkbox woes
I am have a bit of a time with this whole checkbox
I made it this way:
a) with a group and having count 5
I identified which ones. I then copied
them into a temp_table
[group by company having count(*) 5]
b) then I deleted the exact above records
in the original table.
c) Copied them back from the temp_table
I am sure there must be a stored
I am trying to generate some HTML via CF and I want the HTML to come
out
clean. But I end up with lots of whitespace and for the life of me, I
can
not get proper indentation due to all the CFIFS and related CF code.
I have
tried using CFSETTING ENABLECFOUTPUTONLY=NO, but I still end up
with
Guys (and gals),
I've been getting some performance problems with cfdirectory of recent.
Basically I have written a recursive directory listing function which
returns me a query of all the files below a certain folder. This all seems
to work perfectly.
However, recently the number of files
David Collie (itndac) wrote:
You could try to take the value of the buffer in OnRequestEnd, pass it
to a cleanup script (such as the Java version of the HTML Tidy engine)
and return the result from that instead of the original value. YMMV
Could this sort of method be used to auto add
To auto add headers/footers to cfmail, I would create a wrapper custotag
cf_mailplus or something that would do that, and invoke (and pass
parameters on to) cfmail...
-
Hugo Ahlenius E-Mail: [EMAIL PROTECTED]
Project
Questions ..
Is it a mapped drive or UNC path?
DHCP or fixed ip addresses ?
ip/tcp or netbios etc?
You using an ip address or a machine name?
Using DNS or other to lookup that name ?
What else is the box with the files? Is it tuned for file server or
whatever?
WG
-Original Message-
The calls are over UNC using a machine name (so therefore NETBIOS).
The server is a file server.
Neil
-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: 12 June 2003 10:55
To: CF-Talk
Subject: RE: CFDIRECTORY over a LAN
Questions ..
Is it a mapped drive or UNC
Hi,
Have you tried using a the IP address out of interest? Any firewalls
between the boxes?
WG
-Original Message-
From: Neil Middleton [mailto:[EMAIL PROTECTED]
Sent: 12 June 2003 10:51
To: CF-Talk
Subject: RE: CFDIRECTORY over a LAN
The calls are over UNC using a machine name
no firewalls, and I haven't tried using an IP Address.
I will run the test over IP and see if it makes a big difference or not.
-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]
Sent: 12 June 2003 11:04
To: CF-Talk
Subject: RE: CFDIRECTORY over a LAN
Hi,
Have you
On Tuesday 10 Jun 2003 21:17 pm, CF Dude wrote:
It seems that CF5 was able to connect even more than previous versions.
Now I'm starting to get the feeling that CFMX can only connect to
datasources that Java can connect to.
I was all excited about DSN-less connections in CF5, but now I'm
Thanks to Mesh for posting this link to his blog...
http://www.macromedia.com/special/royale/
Royale is the internal code name for a new initiative at Macromedia that
will address the requirements of enterprise programmers who want to develop
rich client applications. Rich client applications
??? As far as I know you can't put bold and italics in a text area.
+---+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
I figured out the issue after some sleep. I was using a method of get for the form and
the vars in my action page were looking for form. not url.
Sleep does has it's puurpose!
~|
Archives:
Was just a thought from Jochem's original answer to the post
Would save a lot of hassle in retrofitting a whole pile of legacy
cfmail's for me... :-(
Oh well, could only dream,
Cheers all DC
| David Collie (itndac) wrote:
|
| You could try to take the value of the buffer in
|
Sorry, just testing. Is the list up?
Portent Interactive
An Internet Marketing Agency
http://www.portentinteractive.com
http://www.searchengineoptimization.cc
~|
Archives:
Hi Neil,
We have run into similar problems with log reading engines using CFX_ReadLine. We
found that on the local machine the reads of, say, a thousand lines from one log file
on a local machine was a small fraction of a second whereas over a network connection
it took many seconds. We
Thanks for the responses. I know which query it is so fixing it is in the
works, one of my colleagues is also looking into it. I still don't think it
makes sense that the query going to a database on a different server woud
cause CF to spike, I'd think it would cause the database server's cpu
We are looking for an email broadcast and scheduling module that can be
integrated into a Coldfusion application. Ideally, the module needs to be
able to schedule a broadcast close to a predetermined time and date and
handle bounce backs of hard and soft bounces. Any information would be
helpful.
I followed this thread and it works fine for me in Flash MX(exporting to Flash 5), I
used option 2(if it matters) http://chattyfig.figleaf.com/ezmlm/ezmlm-cgi/1/62096
Basically, I'm working with a ton of images in mc's with linkage id's and not
exporting on first frame, so I can have a
What does this mean, when I try to view my CFC's self documentation?
Component not found
The component definition file for component 'test' cannot be found on this
server.
--
Ian Skinner
Web Programmer
BloodSource
Sacramento, CA
Hi all,
This didn't reach the list this morning and I need HELP, so I'm
resending. Sorry...
Does anyone know how I can get a copy of Stoneage Print Server? Their
site appears to be down/gone/defunct. I desperately need their software
for an application.
Any help would be greatly appreciated.
iMS-SE can do this. iMS-SE comes with a mail sending engine, scheduler and bounce
mail processing engine. More info is at www.coolfusion.com
Regards,
--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning,
Never mind the fact that I don't speak or read Chinese... I have to
build an app that does. I've looked around and apparently this is a
requirement to get the pages to work right, although I'm not clear on
whether this is simplified or traditional Chinese:
(goes on every page)
thanks Jim
- Original Message -
From: Jim Davis [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 12:49 AM
Subject: RE: session locking ?
If you'd like more information on locking I've a guide here (watch the
wrap):
Best thing I'd suggest is get a copy of iMS (www.coolfusion.com) and use the
scheduler to schedule a mail blast. When using the CFX that sets the mail, set
the return path in it to whatever you want to track. Then you set a chunk of
code in the data template (one of the iMS templates written in CF
woops, wrong list, sorry
-Original Message-
From: Turetsky, Seth [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 1:38 PM
To: CF-Talk
Subject: preloader issue
I followed this thread and it works fine for me in Flash MX(exporting to Flash 5), I
used option 2(if it matters)
Hi,
I was wondering if someone could help me with a CFHTTP issue. We have 2 servers that
are behind a distributed director and one server one the CFHTTP call works correctly
and on server two the CFHTTP call gets a Connection Failure message.
Does anyone have any idea of what the problem
Another technique to try is using cfscript. Because none of your code in cfscript
generates any output (even whitespace), you can have easy-to read logic without
worrying about whitespace. Of course, when you do want to print some HTML you need to
use the WriteOutput() function. Again, you can
I'm thinking this communication and follow up is indeed excellent! Well done
MM and Damon!
On a side note, I missed the part about users of the list giving flak for
complaining, I thought the flak was given for the manner and tone of the
complaints.
Calvin
- Original Message -
From:
Nobody has I guess?
-Original Message-
From: Costas Piliotis
Sent: Wednesday, June 11, 2003 11:53 AM
To: CF-Talk
Subject: CFMX on Cobalt RaQ550
I have a client of mine who has colocated his server, and the colo facility
is having trouble installing cfmx onto that box running the Linux
I'm experiencing a similar difficulty on performance, but I've been assuming
it is network performance causing those issues.
- Original Message -
From: Neil Middleton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 5:58 AM
Subject: RE: CFDIRECTORY over a LAN
When displaying a .pdf file can that be accomplished by
calling it from a button or does it have to be called
from a image - .jpg for instance?
A hyperlink is a hyperlink, whether you put it on text or image - it's
basic HTML...
Displaying a PDF only requires 2 things;
1) the user has Acrobat
I have to save input from a textarea, in which the user has
the opportunity to alter the text in the area(e.g. bold,
italic), into an rtf file. That is to say, I need to save
what the user sees in the textarea into an rtf file so that
when the user opens the rtf file, from say Word the bold
It appears a certain query of mine is causing our CPU to spike. We're
working on the query but what is strange is that it will hose
CF. It was my
uderstanding that CF passes the connection off so I would
think it would be
normal for the database server's CPU to spike but not for CF
to cause
I think you're just tiredovercomplicating it. Note that all I'm doing is
setting the value of the checkbox to 1. You've already got CFPARAMs to
default the values to 0, and you don't need to move those form values to the
session scope that I can see. Try this:
FORM PAGE:
form
(goes on every page)
cfprocessingdirective pageencoding=GB2312
(Goes in application.cfm)
cfcontent type=text/html; charset=GB2312
cfset setEncoding(URL, GB2312)
cfset setEncoding(Form, GB2312)
i would urge you to use unicode. it will simplify things considerably.
What about db inserts,
Hello all,
I'm been struggling with this for about a day now. I'm getting this error
message: [Macromedia][SQLServer JDBC Driver]The DBMS returned an
unspecified error. when I call a stored proc. When I do a trace, it shows
that it ran fine. I can execute it through query analyzer also. Any
Hi Bryan,
According to this article I can, though I haven't yet got it working myself
it seems possible.
http://www.oreillynet.com/pub/a/javascript/2001/12/21/js_toolbar.html
I know the UI functionality comes from JavaScript but everything else is
done with CF. So ultimately the user can markup
What would be the easiest way to import an excel sheet into SQL 2K.
The excel sheet contains the following:
Country name
Country abbreviation
Country code
From Phone Number
To Phone Number
Thanks,
Mike
~|
Archives:
Hi all,
I'm trying to get in touch with Stoneage (www.stoneagesoftware.com) to
buy a copy of their print server. Their site's down. I'm in kind of a
hurry - anyone know how I can reach them?
Ian
Portent Interactive
An Internet Marketing Agency
http://www.portentinteractive.com
I've got an inner join that I'm trying to make work with paging the records
and I *think* I see what the problem is, but I don't know how to proceed...
The inner joins are working correctly. In fact, when I go to output, I
simply group them by property ID, and I get the right number of
This is really one place SQL Server can learn from MySQL... A LIMIT
function would be perfect...
Why not just use the maxrows and startrow function in the cfquery tag? For
the most part it works quite well actually...
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent:
try:
[EMAIL PROTECTED]
Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Company (VICO) Application Demo
www.scorpiosoft.com/vicodemo/login.cfm
- Original Message -
From: Ian Lurie [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June
The drive containing the mails server got filled up and stopped the mail from
being received and processed. I've fixed it.
Sorry, just testing. Is the list up?
Portent Interactive
An Internet Marketing Agency
http://www.portentinteractive.com
http://www.searchengineoptimization.cc
I've run into this one before and it sucks. Your best bet, if you want the
number of unique property ids is to run another query that does a
SELECT COUNT DISTINCT propertyID AS pCount...
But whether or not it will work to use this number as the recordcount is
anyone's guess. You may have to
I think I've got a trial copy around here somewhere - would that help?
Matthew Small
IT Director
Showstopper American Dance Championships
[EMAIL PROTECTED]
843-357-1847
-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 1:43 PM
To: CF-Talk
Matt Robertson wrote:
Whats the Big5 charset and
is it relevant/better than GB2312? Utf-8? Or are they all
interchangeable?
They are not interchangeable and UTF-8 is the most versatile one.
I would want to run this on mySQL and CFMX if possible.
Apart from the other issues, unicode
I've had good luck saving the excell sheet to csv, then using DTS (text)
to import. If there are multiple sheets in the original just save them
each separately as csv. Email me direct if you have any questions.
-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]
Sent:
Um, I've got no association with them at all. Sorry.
/charlie
-Original Message-
From: Marius Milosav [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 2:30 PM
To: CF-Talk
Subject: Re: Stoneage Print Server
try:
[EMAIL PROTECTED]
Marius Milosav
www.scorpiosoft.com
It's
My friend solved the problem by writing a script. I don't know what he
wrote.
Thank you very much for your replies.
-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 3:22 AM
To: CF-Talk
Subject: RE: Consuming CFMX Web Services in ASP.NET
Try
Apart from the other issues, unicode support is very new to MySQL, I am
not even sure there is a stable release with it. Make sure you test
just checked, ver 4.1 appears to have added ucs2, so i guess support is
improving.
~|
Problem solved - the folks at Stoneage just called me. Thanks,
everyone, for your help! This continues to be a great community...
On Thursday, June 12, 2003, at 11:52 AM, Charlie Arehart wrote:
Um, I've got no association with them at all. Sorry.
/charlie
-Original Message-
Hi,
I was wondering if someone could help me with a CFHTTP issue. We have 2
servers that are behind a distributed director and one server one the
CFHTTP call works correctly and on server two the CFHTTP call gets a
Connection Failure message.
Does anyone have any idea of what the problem
on 6/12/03 2:34 PM, Bryan Love at [EMAIL PROTECTED] wrote:
I've run into this one before and it sucks. Your best bet, if you want the
number of unique property ids is to run another query that does a
SELECT COUNT DISTINCT propertyID AS pCount...
But whether or not it will work to use this
seems to be there now...
http://www.stoneagesoftware.com/ProductDetails.cfm?Product_ID_String=8b73249e-9d57-4275-9659-35f47c89f494
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
Yeah they just put the site back up, just for little old me...
On Thursday, June 12, 2003, at 12:25 PM, Paul Hastings wrote:
seems to be there now...
http://www.stoneagesoftware.com/
ProductDetails.cfm?Product_ID_String=8b73249e-9d57-4275-9659-
35f47c89f494
right...but as Phillip mention
Now, if you use a visual editor (see the active edit alternatives
thread), then it returns HTML
this will save you dev time.
Doug
-Original Message-
From: Andrew Henry [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 2:10 PM
To: CF-Talk
Subject:
Hello All:
CFLDAP and UID Output?
Can I perform a query search for UID? I need to output the UID and pass
it to another template when an entry is selected from the LDAP server
output. I can't seem to output the UID. And Ideas?
This gives me a bunch of people but I cant output their UID's...
(Sent with permission)
On-Line Data Solutions, Inc. (www.CoolFusion.com) recognizes the tremendous
value of the ColdFusion User Group and the invaluable role it plays in
strengthening the CF community. In this spirit of community, we would like
to donate a free copy of our award-winning mail
Curious: a visit to http://www.stoneagesoftware.com/ still gets a CFMX error
Could not find the included template /StoneAgeSoftware/Common/Header.cfm..
Though, perhaps more curious, http://www.stoneagesoftware.com/index.cfm)
does not.
You may want to pass that along to them, Ian.
/charlie
[Sorry for the pseudo-spam.]
Although an email today was the first I'd heard of it (annoyingly) the
Boston CFUG seems to have revived itself and will be meeting tonight.
Information here:
http://www.cfugboston.com/index.cfm
The group petered out after it's last director left and this is it's
That error is fixed. The product looks great, but when I tried to download the demo I
got a CFMX error.
This logo and company name looks awfully familiar. Ben Forta was(is?) associated with
stoneage.com.
---
Matt Robertson, [EMAIL PROTECTED]
Just tried it over IP and the performance is the same...
N
-Original Message-
From: Neil Middleton [mailto:[EMAIL PROTECTED]
Sent: 12 June 2003 10:59
To: CF-Talk
Subject: RE: CFDIRECTORY over a LAN
no firewalls, and I haven't tried using an IP Address.
I will run the test
Okay, how about this...
Is there a function or a combination of functions that I can use on the
query results to find the distinct PropertyIDs from a join query?
Say my query returns 10 rows. 2 distinct properties, with 6 rates for one,
and 4 rates for another...so grouped output looks like
Is there some way to calculate #DistinctPropertyCount# some way from the
results of the query? In this case, the RecordCount is correct (10 rows
returned) but what I *really* need is the number of *properties* that are
returned...
You could create a structure, with keys being the value of the
There are just 2 days left on the regular CFUN-03 price of $249! Over
300 people are coming and we only have a few places left. Don't miss
out on this area's biggest CF event, register today!
TeraTech also is offering a few student and unemployed partial scholarships
to CFUN-03. Email me if you
Microsoft announce FrontPage 2003 We've really focused on generating
clean, industry-standard HTML code. they claim.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
LOL! Riiggghhht
-Original Message-
From: Dave Lyons [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 4:39 PM
To: CF-Talk
Subject: OT~ but a good laugh:)
Microsoft announce FrontPage 2003 We've really focused on generating
clean,
Post the code you are using to output the query. The information you are
trying to display could make or break this effort.
I'm assuming you have something like this:
cfoutput query=foo group=propertyID
#propertyID#
?
cfoutput
#some info#...
on 6/12/03 4:16 PM, Scott Weikert at [EMAIL PROTECTED] wrote:
Is there some way to calculate #DistinctPropertyCount# some way from the
results of the query? In this case, the RecordCount is correct (10 rows
returned) but what I *really* need is the number of *properties* that are
returned...
Actually, Frontpage is one of the better code generators. Have you ever looked at
Golive code? Argh...
- Original Message -
From: Dave Lyons [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 4:39 PM
Subject: OT~ but a good laugh:)
Microsoft announce
And you can turn off FrontPage extensions too!
2003 has a neat expiration code, and a even cooler can be opened only by and
cannot save locally features too!
==
Stop spam on your domain, use our gateway!
For hosting solutions http://www.clickdoug.com
ISP
Dave Lyons wrote:
Microsoft announce FrontPage 2003 We've really focused on generating
clean, industry-standard HTML code. they claim.
That would be quite a change. IIRC, during the anti-trust trials Bill
Gates himself has delivered sworn testimony that Frontpage is designed
to only work with
Hi Jim,
Today's email was actually the third email notification we sent out (in
addition to one from Macromedia, though I do not know the extent of that
mailing). At which email address did you receive today's notice? I do not see
any depressedpress.com email addresses included in the email
on 6/12/03 4:47 PM, Bryan Love at [EMAIL PROTECTED] wrote:
Post the code you are using to output the query. The information you are
trying to display could make or break this effort.
I'm assuming you have something like this:
cfoutput query=foo group=propertyID
#propertyID#
?
This is a known issue and has I believe been acknowleged by various
parties.
It is the result of a limitation of the underlying Axis engine that
CFMX uses.
I believe there were plans for Axis in the future (possibly the version
that is used in the next point release of MX - I haven't tried yet)
Hi
I've seen this before. The funny thing is it is was related to Locking.
Other applications running on the same server and under heavy load
included unlocked session vars which seemed to manifest themselves as
errors when using Q of Q. I can only put this down to the lack of
locking screwing
I posted a question earlier with a horrible explanation so here is my
second try. I'm making a car database where you can add as many
attributes with as many options for each attribute. I'm guessing you
need to put the options/attributes as pairs in the attribute column in
the car table. How
as usual you are correct jochem
heres the rest:
Microsoft announce FrontPage 2003 We've really focused on generating
clean, industry-standard HTML code. they claim. We expect it to produce
proprietary, MS-oriented mark-up that only works in IE6. But then we're
cynical. Click here
You probably want to create a CAROPTION table to replace the attributes
column in CAR:
carID | optID | attID
1 | 1 | 2
1 | 2 | 4
1 | 3 | 5
2 | 1 | 1
2 | 2 | 3
2 | 3 | 6
It adds a join, and splits the data, but will make searching enormously
easier.
---
Barney Boisvert, Senior Development
Good point. I still don't understand how I would write the code though
to pair up the option to the attribute. Some times I just can't seem to
get over the learning hurdle. I think age is taking its toll. :)
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent:
I have a query I am trying to run to get a particular record out of the database. The
problem is that one of the fields is
a varchar 255 field that houses a date. I want to convert the date so I can find out
if it is greater than getdate(). I run the following
code and generate this conversion
SELECT CAR.carID, CAR.carname,
OPTIONS.optname
FROM CAR
INNER JOIN CAROPTION ON CAR.carID = CAROPTION.carID
INNER JOIN OPTIONS ON CAROPTION.optID = OPTIONS.optID
That'd return a recordset like this:
1, civic, blue
1, civic, leather
1, civic, alloy
2, accord, red
2, accord, cloth
2,
I have a couple of hosting clients who insist on using FrontPage. They have
great looking sites, until you look at two of them and realise they've got
templates from some site somewhere and just changed the text.
Then I get emails complaining how slow they are to load, and I see that the
How does the data in that column look like?
- Original Message -
From: Eric Creese [EMAIL PROTECTED]
Date: Thursday, June 12, 2003 3:34 pm
Subject: SQL conversion question for SQL Guru
I have a query I am trying to run to get a particular record out
of the database. The problem is
for some dates I got 06/12/2003 and others JUN 12 2003
I did not design this merely walking into a previous mess.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 4:37 PM
To: CF-Talk
Subject: Re: SQL conversion question for SQL Guru
How
Eric Creese wrote:
I have a query I am trying to run to get a particular record out of the database.
The problem is that one of the fields is
a varchar 255 field that houses a date.
Only a date, or other information as well?
I want to convert the date so I can find out if it is greater
This may be of interest...
http://www.databaseanswers.com/data_models/car_dealership/index.htm
--
jon
mailto:[EMAIL PROTECTED]
Thursday, June 12, 2003, 4:47:07 PM, you wrote:
EM I posted a question earlier with a horrible explanation so here is my
EM second try. I'm making a car database
The field actually holds different kids of data based on the record type. I am only
select records that will contain a date
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 4:44 PM
To: CF-Talk
Subject: Re: SQL conversion question for SQL
Hi all,
The day before yesterday, someone mentioned having problems dealing with
lists in SQL. Their final solution ended up using regular expressions, but
I figured that I would still need to deal with lists in SQL in the near
future, so I went and created some list functions in SQL.
Of
HELP HELP HELP . . .
Anyone got any idea why CF may not create sessions??
I simply moved a working functional CF site to another WIn2K Advanced server,
just like the one it came from, and for some reason CF5 will not hold the
create and maintain a session.
Try to log in and it keeps bumping me
It's most likely not the server itself. Remember there are ONLY two
possible ways to track a user's session:
1. Cookies store CFID and CFTOKEN
2. Pass CFID and CFTOKEN in the url string
If you can't create and hold a session using code that you know is good then
one of these two things is
Have you created an application in IIS? If the site doesn't have an
application name, IIS may not be sending the headers to write the cookie to
keep the session...
-Original Message-
From: Staff [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2003 3:22 PM
To: CF-Talk
Subject: CF
We are trying to follow good OO coding standards as we develop our CFCs, but
have hit a minor snag.
Basically, an action page will call a business rule component. But first,
it needs to know where we've stored the components. That's fine, I can set
a variable in Application.cfm. Now the
IIS applications have nothing to do with CF sessions.
- Original Message -
From: Costas Piliotis [EMAIL PROTECTED]
Date: Thursday, June 12, 2003 4:26 pm
Subject: RE: CF Not creating sessions???
Have you created an application in IIS? If the site doesn't have an
application name, IIS
In particular, check under the Home Directory tab of your site in IIS.
Ensure there is an application name there. I think that may be the cause...
Just a hunch though really...
-Original Message-
From: Costas Piliotis
Sent: Thursday, June 12, 2003 3:26 PM
To: CF-Talk
Subject: RE: CF
No you can't. When you use aggregate functions in an SQL statement you MUST
put all of the fields you are selecting into the GROUP BY clause. That
means you will need two queries since you want to select more fields than
you want to GROUP BY.
I wouldn't look down on yourself too much for that.
If the CFCs are related, why not use the same directory? Ie
/root
/root/wwwroot (web files here)
/root/cfcs
If your app was Foo.com, you could make a mapping that points to root,
then all your cfcs would have the path:
foo.cfc.whatever
And of course, if whatever needs to access whoever in the
If you plop the following into Query Analyzer (assuming SqlServer200) I think you will
get what you want:
declare @cid int
set @cid = 2
if object_id('tempdb..#tblAttributeType') is not null drop table #tblAttributeType
if object_id('tempdb..#tblColor') is not null drop table #tblColor
if
1 - 100 of 130 matches
Mail list logo