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