No problem Joe, I saw that you're CFC will do something that I need, and
when the page choked....
But I downloaded it from CFZone, I'll let ya know how it works out.
sas
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 100
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527
-----Original Message-----
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 01:37 pm
To: CF-Talk
Subject: Re: Converting query to comma separated list
Thanks Scott,
This pops up every 24-36 hours until I run a script to empty some
logs, as CF-Dynamics still hasn't completed a help desk ticket I left
with them a while back...
I'll be moving to a completely new service over the next few weeks,
and this should all go away.
Cheers,
Joe
----- Original Message -----
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thu, 23 Sep 2004 10:18:25 -0400
Subject: RE: Converting query to comma separated list
To: CF-Talk <[EMAIL PROTECTED]>
Joe,
Got the following error trying to access your site
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Could not allocate space for
object 'clearsoftware_visitors' in database 'clearsoftware_net_01' because
the 'PRIMARY' filegroup is full.
The error occurred in
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\tracker.cfc: line 21
Called from
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\Application.cfm: line 26
Called from D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\tracker.cfc:
line 21
Called from
D:\Inetpub\wwwroot\clearsoftware.net\wwwroot\client\Application.cfm: line 26
19 : <cfprocparam cfsqltype="cf_sql_varchar"
value="#arguments.firstName#" />
20 : <cfprocparam cfsqltype="cf_sql_varchar"
value="#arguments.lastName#" />
21 : <cfprocresult name="result" maxrows="1" />
22 : </cfstoredproc>
23 :
_____
SQL
{call clearsoftware_createVisitor( (param 1) , (param 2) , (param 3) ,
(param 4) , (param 5) , (param 6) )}
DATASOURCE
clearsoftware_glass
VENDORERRORCODE
1105
SQLSTATE
HY000
Please try the following:
* Check the ColdFusion <http://www.macromedia.com/go/proddoc_getdoc>
documentation to verify that you are using the correct syntax.
* Search the Knowledge <http://www.macromedia.com/support/coldfusion/>
Base to find a solution to your problem.
Browser
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)
Remote Address
65.242.127.130
Referrer
Date/Time
23-Sep-04 09:21 AM
Stack Trace (click to expand) <_javascript_:;>
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 100
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527
-----Original Message-----
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 09:37 am
To: CF-Talk
Subject: Re: Converting query to comma separated list
Mark,
I posted a CFC called "queryTool" to my site (http://clearsoftware.net
-> downloads -> queryTool) and to cfcZone.org that converts queries to
delimited formats, XML, arrays, and structures. Perfectly free, seems
to work pretty well.
Cheers,
Joe
----- Original Message -----
From: Mark Henderson <[EMAIL PROTECTED]>
Date: Thu, 23 Sep 2004 22:14:06 +1200
Subject: Re: Converting query to comma separated list
To: CF-Talk <[EMAIL PROTECTED]>
Thank you for the swift replies Andrew and Kola,
and you're right Andrew. I'd already tried something similar, but was making
it more complicated than necessary. Here's what works....
<cfdirectory
name="getAllFolders"
action="">
directory="#serverdir#"
sort="name ASC">
<cfloop query = "getAllFolders">
<cfdirectory
name="getAllFiles"
action="">
directory="#serverdir##name#"
sort="name ASC">
<cfquery dbtype="query" name="getAllFiles_#name#">
SELECT *
FROM getAllFiles
</cfquery>
</cfloop>
adieu
Mark________________________________
_____________________________________
_____
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- Converting query to comma separated list Mark Henderson
- Re: Converting query to comma separated list Andrew Dixon
- RE: Converting query to comma separated list Kola Oyedeji
- Re: Converting query to comma separated list Mark Henderson
- Re: Converting query to comma separated list Andrew Dixon
- Re: Converting query to comma separated list Joe Rinehart
- Re: Converting query to comma separated list Larry Lyons
- RE: Converting query to comma separated list SStewart
- Re: Converting query to comma separated list Joe Rinehart
- RE: Converting query to comma separated list SStewart
- RE: Converting query to comma separated list Mark Henderson