cfparam name="attributes.book" default="???"
cfparam name="attributes.affid" default=""
cfhttp method="get"
url="http://www.amazon.com/exec/obidos/ASIN/#attributes.book#/icigroup/#attributes.affid#"
resolveurl="yes"
cfset filepath="C:\www\content\books"
cfset content =
I have the datetime set in the database to automatically set it whenever a
new record is made so I don't have to worry about it anymore.
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 1:17 AM
To: [EMAIL PROTECTED]
Subject: RE: Arrays,
Scott,
If you use a DOS command prompt window and go to the 'Verity' directory
under your CF main directory, and then run the program mkvdk from the 'bin'
directory:
eg
c:\coldfusion\verity..\bin\mkvdk
you will be able to access a number of Verity embedded functions (a
function list is
Alternatively, what if I delete a category. Again, I'd have to
retrieve every item, iterate through each list, delete any
entries for that category, then save that item.
Actually, if you don't re-use the numbers, you could leave the redundant
numbers in the denormalised list, as it could
-Original Message-
From: Michel Vuijlsteke
Sent: Thursday, June 22, 2000 11:01 AM
To: '[EMAIL PROTECTED]'
Subject: Re: CFX execution time
Erm, well, that's what I do:
x, y are input parameters. z, status are output parameters, and iter is the
number of iterations requested.
-Original Message-
From: Michel Vuijlsteke
Sent: Thursday, June 22, 2000 11:02 AM
To: '[EMAIL PROTECTED]'
Subject: Re: CFX execution time
Yes it is.
-Original Message-
From: Justin v0.9 MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 21, 2000 6:28 PM
To:
Hi all,
Sorry to post this in here, but we really need someone quite urgently
for this. I've been tasked to find a developer to take over development and
support of a website written in CF. Working remotely is fine, though a
developer in the NW (Liverpool/Southport area) would be preferred by
Instead of using #CFID# in the insert statement. use #URL.CFID# and
#URL.CFTOKEN# and make sure you are passing the parameters on the url from
the previous form
Kalyan Vemula
Web Developer
STONEAGE.COM
Voice: (800)786-6324 x149
Email: [EMAIL PROTECTED]
http://www.stoneage.com
-Original
I got the following error. No mention of the database
D:\FTP\chrisf\Database\bwpc.mdb in the error statement as Mark Ireland
pointed out.
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in date in
USe the PreserveSingleQuotes(string) function.
COld Fusion won't convert with 2 single quotes...
-Original Message-
From: David [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 7:48 AM
To: [EMAIL PROTECTED]
Subject: single quotes
Hi all,
I am a newbie to Coldfusion and have a
The error message from ODBC seems to imply that Access is expecting a
datetime value in CFID. Have you tried adding a date manually?
-Original Message-
From: Chris Farrugia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 2:47 AM
To: [EMAIL PROTECTED]
Subject: RE: Arrays,
Has anyone had any problems implementing advanced security on their site?
We've had success using it on our site for about 3 months but since last
week, the authentication isn't working correctly. It will authenticate
sometimes even if the policy doesn't include the person or group that the
Larry:
This is a repost I sent on this issue on June 6. It will be
pertinent, in my opinion, if you have IIS.
"Since I haven't seen anyone respond to your query I'll venture
my opinion, BUT BEWARE - I'm a newbie, (so take what I say with a word
of caution). When I was going
Hi Chris,
The error I saw indicated a problem with the Date field trying to accept the
CFID field info.
( i.e. [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in
query expression '#CFID#')
Perhaps you have to adjust the order in which your INSERT or UPDATE is
receiving this
You have to go to Tools - Options - click on Hidden Objects and System
Objects
then go back to Tools - Security - User and Group permissions - highlight
the MSSysObjects table and then check the Read Data check box, then click ok
and you are done. Now use the query below and this will give you
Hi, I probably get a contract on building an encyclopdia-application with
ColdFusion soon.
Is there any examples (Tags ?) that you know of already existing with this
functionality ?
Thanks.
Uwe
SD Solutions
Uwe Degenhardt
Fon: 08122/903791
Fax: 08122/903792
Web: http://www.sdsolutions.de
Netscape 4.x and CSS... sigh
1 - You *must* include the comment tag just inside the STYLE tag in the
external .css file
2 - Be careful if you reference images in your external .css file. If you
say an image is in "../images/background.gif " (because that's where it is
*in relation to the .css
Excellent - thanks Dave. Do you know why it was to be set as a variable
first? If I just type it within the textarea tag - it just gets displayed.
Oh well - it works now.
- Original Message -
From: "Dave Watts" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent:
Excellent - thanks Dave. Do you know why it was to be set as
a variable first? If I just type it within the textarea tag -
it just gets displayed. Oh well - it works now.
It doesn't have to be set as a variable first; I do that for convenience. If
you're doing something like this:
cfset
CFSET variables.Result = DeleteClientVariable("client.OldUserID")
Is this code correct? Trouble is, it's not deleting the client variable
(they're stored in a database).
Thanks
--
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions Services
Are there any known problems using CFSTOREDPROC and queries in an Access97
database?
I'm having a hell of a time getting a simple UPDATE query to work (although
SELECT queries work no problem).
If you run the query from within Access, it asks for the variable values and
then updates the
I've never had a problem with cfquery but I have noticed that if I
cflocation directly after I drop a cfcookie, it doesnt set the
cookie.
Jon
Ken Wilson wrote:
I'm getting a few random reports of data loss on an Intranet site and need
to get some input on things I might investigate. I'm
What was the code someone had posted here to eliminate duplicates in a
database.
If you want a "dirty" way to remove duplicate records, then use Distinct
select distinct *
from myTable
where myField='#myValue#'
It's slower than using a Group By, but it returns only the unique records
(on all
I'm working on a project to input user data in a database, however there are
several sections for each user. For example if each user will have a section
containing basic contact info, then info regarding personal computer info
(i.e processor speed, RAM, etc.). Then there would also be a section
try
CFSET variables.Result = DeleteClientVariable("OldUserID")
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 10:42 AM
To: CF-Talk (E-mail)
Subject: DeleteClientVariable() not doing it's stuff
CFSET variables.Result =
Hi,
I'm in a situation where our intranet has been built using ASPs and now part
of the system will be built in CF. I want to have an ASP login screen and
when the user logs into the CF Application, pass the username and password
session variables from ASP to CF.
Is this possible?
TIA,
Debbie
try
CFSET variables.Result = DeleteClientVariable("OldUserID")
*profanity deleted*.
Thanks - that was easy. That'll teach me to scope every variable. Gr
--
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions Services
http://www.netshopperuk.com/
Anyone who would like it, I redid Accuweather 3 to take out the new
adds they have been putting in thier code that just gives a script error.
Email me off list if you would like a copy.
Robert Everland III
Web Developer
Dixon Ticonderoga
Could anyone give me a stored procedure example using a dynamic
variable that is filled in with cfstoredproc. The stored procedure code and
the cfstoredproc command would be very helpful.
Robert Everland III
Web Developer
Dixon Ticonderoga
What happens when SQL server reaches its limit. For instance, my SQL 7
machine has 1 GB or RAM. I set SQL server to use about 900 megs, leaving
some for WinNT Server 4. What happens once SQL 7 reaches the 900 mark.
Will it hang up, or just continue to run at that level. Thanks for any
help.
I dont create tables with sql often enough are there any good tutorials
around?
I think my biggest problems is getting the datatypes correct when specifying
the create or modify table commands
???
thanks
je
--
STORED PROCEDURE
CREATE PROCEDURE adminlogin
@user NVarChar (64),
@password NVarChar (32)
AS
SELECT Comp.COMP_ID_INT, Client.CLIENT_ID_INT
FROM Client, Comp, Comp_Client
WHERE Comp_Client.COMP_ID_INT = Comp.COMP_ID_INT AND
Comp_Client.CLIENT_ID_INT =
I could be incorrect here, but Access "queries" are not the same thing as stored
procs. As best I understand it, they are just save pieces of SQL, which are run
whenever they are
called.. not quite the same thing as stored procedures. You will need to reproduce
the query in CF. Alternately,
DeleteClientVariable("OldUserID") ...
Just erase the "CLIENT." in your parameter.
Noe, it is trying to delete CLIENT.client.OldUserID, and it doesn't exists..
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 10:42 AM
To: CF-Talk (E-mail)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Try:
SELECT Name
FROM MSysObjects
WHERE Type = 1
That'll get you all tables. If you want to exclude all of the system
tables, one of the following added to the WHERE clause should do it.
AND Name Not Like 'MSys%'
- -- OR --
AND Flags = 0
I'm
One thing you can't do in a stored procedure is set the ORDER BY to a
variable, so you have to dynamically build the statement in your stored
procedure. This might come up so I thought I would include it as well
STORED PROCEDURE
CREATE PROCEDURE webclientacctholddaily @caccountid int, @OrderBy
This is a multi-part message in MIME format.
--=_NextPart_000_001A_01BFDC3D.2AD08E50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
What would be the best way to track user movements throughout a site (i.e.
what pages they have requested, what
you mean like this?
cfset userid= attributes.City"_"attributes.State
I find it easier to use associated tables for this. once you put a user into
your database if you have an autonumber or identity field or use the MAXID
tag you will then have a unique id for every user which will be a number.
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01BFDC5E.4A861140
Content-Type: text/plain;
charset="iso-8859-1"
I was able to solve the problem - it was a bit of a "duh?!". I
Test
-Original Message-
From: Zachary Bedell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 11:23 AM
To: '[EMAIL PROTECTED]'
Subject: RE: List of tables in Access 97
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Try:
SELECT Name
FROM MSysObjects
WHERE Type = 1
That'll get
Please excuse me for posting that MIME message - I forgot to turn it off. My
apologies.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What would be the best way to track user movements throughout
a site (i.e.
what pages they have requested, what keywords they have
searched on, their
IP, etc.)? The users are already required to login with a userID
and password. I need to be
Hello All - hope someone can help me with a simple question. When I try to
do a query based on user date range input, using = and = criterion, it
doesn't always recognize the "=" part. I'm thinking this has something to do
with the fact that SQL Server stores date/time instead of date only.
Hi Gina,
I think the easiest way to do this is to put a query in your application.cfm
file that inserts their information into your database:
CFQUERY NAME="record_visitor_page_impressions" DATASOURCE="web_log"
INSERT INTO visit_log
change createodbcdate to createodbcdatetime and see what happens.
Robert Everland III
Web Developer
Dixon Ticonderoga
-Original Message-
From: Smith, Melanie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 11:44 AM
To: '[EMAIL PROTECTED]'
Subject: SQL Server Date comparison
Hi Again,
Is there anyway to automatically authenticate a user (giving them access to
a CF application without having to login) using NT Authentication?
TIA,
Debbie
--
Archives: http://www.eGroups.com/list/cf-talk
Debbie,
I've had luck setting up a User Directory under the Advanced Security
Options and making it point to a specified the Windows NT domain.
Do the following:
(1) Create a User Directory, specifying which NT Domain you want to use.
(2) Create Security Context
(3) Add User Directory to the
Anybody have any insight on this fantastic error message ?
Error Diagnostic Information
unknown exception condition
CFMLInterpreterImp::process
/Ruben Chadien
--
Archives:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Generally it means all heck has broken lose in CFAS, and it's time to
restart the service. You shouldn't get that error unless there's
some degree of corruption in the CFAS process' memory space.
Possible causes include failure to properly lock
Won't most standard web site logging tools do what you need? IIS has one
built in.
.Todd
- Original Message -
From: "Eron Cohen" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, June 22, 2000 11:42 AM
Subject: RE: Tracking users through a site
|
Can I call a cfscript function through a link like a javascript function.
Like ...
a href="javascript:function_name('arg','arg')"blah/a
Tim Bahlke, CIFO
thinkcreate.com
p. 336.230.0575
f. 336.230.0083
actually, that's not technically correct. while access "queries" are closer
to views in this case, CF can treat them like SPs.
Chris Olive,
DOEHRS Website Administrator
-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 11:13 AM
To: [EMAIL
What happens when SQL server reaches its limit. For instance, my SQL 7
machine has 1 GB or RAM. I set SQL server to use about 900 megs, leaving
some for WinNT Server 4. What happens once SQL 7 reaches the 900 mark.
Will it hang up, or just continue to run at that level. Thanks for any
um .. n/m .. misread the question
Todd
- Original Message -
From: "Todd Ashworth" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 22, 2000 12:45 PM
Subject: Re: Tracking users through a site
| Won't most standard web site logging tools do what you need? IIS has one
|
No
- Original Message -
From: Tim Bahlke [EMAIL PROTECTED]
To: Cf-Talk [EMAIL PROTECTED]
Sent: Thursday, June 22, 2000 5:43 PM
Subject: cfscript
Can I call a cfscript function through a link like a javascript
function.
Like ...
a href="javascript:function_name('arg','arg')"blah/a
Jason Egan wrote:
I dont create tables with sql often enough are there any good tutorials
around?
I think my biggest problems is getting the datatypes correct when specifying
the create or modify table commands
Sure, here are the links I have:
http://w3.one.net/~jhoffman/sqltut.htm
yes, to a degree the logging tools would be useful, but this particular set
of information would be used as an audit trail... so it would have to be
permanently stored in a database, and searchable as well.
-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent:
On the memory note I think SQL server will only use a upper limit of 3Gb of
RAM...
~JustinMacCarthy
As I've said, SQL Server LOVES memory, and the more you can give it, the
happier it is, but a 512Mb lower limit should be noted, below that and it
does run slower... 1Gb RAM should give
Interesting - when I try this I get a read error??
[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read
permission on 'MSysObjects'.
je
-Original Message-
From: Zachary Bedell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 11:23 AM
To: '[EMAIL
This is a multi-part message in MIME format.
--=_NextPart_000_0011_01BFDC49.94F5E710
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Since it is a database error the way I would recommend trying to solve this
problem is by first trying to get the
Can I call a cfscript function through a link like a
javascript function.
Like ...
a href="javascript:function_name('arg','arg')"blah/a
No. CFSCRIPT is purely server-side, and is subject to the same limitations
as any other CFML code.
Dave Watts, CTO, Fig Leaf Software
My experience with Sybase has been that the company is incompetent about technical
matters regarding their own products, nonresponsive to support issues and even to
potential buyers,
and their database is a dinosaur that performs poorly compared to SQL Server or
Oracle. Based on my experience
Awesome... thank you very much.
This is exactly what I was looking for.
Stuart Duncan.
At 01:20 AM 6/22/00 -0500, you wrote:
cfparam name="attributes.book" default="???"
cfparam name="attributes.affid" default=""
cfhttp method="get"
No. For that matter, you can't even write a cfscript function.
[EMAIL PROTECTED] 06/22/00 10:43AM
Can I call a cfscript function through a link like a javascript function.
Like ...
a href="javascript:function_name('arg','arg')"blah/a
To add something to what Zac said, I've seen this happen on 4.0.x when using
the Decrypt function on an empty string, a string not properly encrypted, or
using the wrong encryption key. Nasty PCode errors and the like usually
follow.
-Greg Witte
-Original Message-
From: Ruben Chadien
i'm having trouble with the cfsearch command this is the error
message::thanks
Error occurred in tag CFSEARCH
Collection name not found
The error occurred while processing an element with a general identifier of
(CFSEARCH), occupying document position (10:1) to (13:34) in the template
file
Can I call a cfscript function through a link like a javascript
function.
No. CFSCRIPT is simply another way of writing CFML. Like CFML, it is
executed on the server BEFORE the page is sent to the browser. JS is
executed in the client browser and can not make calls or references to CF
I'm stumped on a problem and I'm hoping someone can help. I apologize for
the length of this message but I figured I should give all the info I can.
I have two tables: tblChangeRequest and tblStatus with a one to many
relationship. I'm trying to list all tasks in the change request table with
Hello All - hope someone can help me with a simple question.
When I try to
do a query based on user date range input, using = and = criterion, it
doesn't always recognize the "=" part. I'm thinking this has
something to do
with the fact that SQL Server stores date/time instead of date only.
Can I call a cfscript function through a link like a javascript
function.
Like ...
a href="javascript:function_name('arg','arg')"blah/a
CF is SERVER based, JavaScript is CLIENT based - the CF template is
calculated before it is sent to the browser, so none of the code is seen at
the client
I dont create tables with sql often enough are there any good tutorials
around?
I think my biggest problems is getting the datatypes correct when
specifying the create or modify table commands
Which database server?
If it's SQL Server, then there's only a few you need to use;
Int,
This is a multi-part message in MIME format.
--=_NextPart_000_0007_01BFDC52.8821F8E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi All,
I've tried both of the examples below. Neither work. Help would be =
appreciated. TIA.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Try:
SELECT Name
FROM MSysObjects
WHERE Type = 1
That'll get you all tables. If you want to exclude all of the
system tables, one of the following added to the WHERE clause
should do it.
AND Name Not Like 'MSys%'
-- OR --
AND Flags =
Did this not work
To Unsubscribe visit :
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
steve
- Original Message -
From: "Internet Marketing Corporation" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 22, 2000 6:18 AM
Subject: RE: List of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
yes, to a degree the logging tools would be useful, but this
particular set
of information would be used as an audit trail... so it would
have to be
permanently stored in a database, and searchable as well.
You *could* periodically analyze
cfscript doesn't have functions, so you can't call one even from a page.
But javascript can't interact with CF because CF is executed on the server
and javascript is executed on the browser.
What you can do is use CF to dynamically write the javascript functions you
need.
HTH!
Sharon
At 12:43
At 10:04 AM 6/22/2000 -0700, Karl Simanonok wrote:
My experience with Sybase has been that the company is incompetent about
technical matters regarding their own products, nonresponsive to support
issues and even to potential buyers,
and their database is a dinosaur that performs poorly
hi.
Im new to this list...ive been looking for a list like this for
ages...obviously I haven't looked too hard otherwise I would've
found this a while ago!
Anywho...my issue is this:
cfdirectory action="list" directory="c:\somedirectory\"
name="??" sort="name"
what should go in the name
Hi all!
Problem: A user selects from a group of check boxes and
submits. When going to edit the info, can't figure out the
best way to pull the info back out of the database into the
checkboxes (so users can see and edit which boxes they have
checked).
Background:
I am creating a
Tim, you might want to combine CF and JavaScript for what you want to do.
For example :
cfquery name=q
SELECT Name
FROM dB
/cfquery
cfoutput query=q
a href="javascript:ShowName('#Name#');"#name#/abr
/cfoutput
Hope that helps
~JustinMacCarthy
Yeah, I tried that too but it didn't work.
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 8:31 AM
To: [EMAIL PROTECTED]
Subject: RE: Arrays, databases, and WDDX
The error message from ODBC seems to imply that Access is expecting a
datetime
This is just the advice I was looking for. Thanks Justin!
Tim Bahlke, CIFO
thinkcreate.com
p. 336.230.0575
f. 336.230.0083
-Original Message-
From: Justin v0.9 MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 3:12 PM
To: [EMAIL PROTECTED]
Subject:
Paige;
Try this code:
CFGridColumn Name="Act_Value1" Header="#NumberFormat(Act1,'99,999,999')#"
I set ACT_Value1 to 345.98 and this named my column 346
Hope this is what you were looking for.
H Larry Juncker
L Senior Cold Fusion Programmer
I Heartland Communications Group
We're looking at about 86,000 hits per day on the reporting server, which is
where I need to collect this information. I'm trying to figure out if there
is a way I can track a single user through each visit to the site and record
the entire session to one record in the table. Example, the user
Thanks - this is very helpful. BTW - any characters I need to watch out for
besides # and "?
aloha
Dan
- Original Message -
From: "Jeff" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 21, 2000 3:57 PM
Subject: Re: escaping special characters between cfoutput/cfoutput
Thank you, these are good links, !! W3 !!
Thank you!
je
-Original Message-
From: Ian Potts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 12:54 PM
To: [EMAIL PROTECTED]
Subject: Re: creating tables
Jason Egan wrote:
I don't create tables with sql often enough - are there
Anywho...my issue is this:
cfdirectory action="list" directory="c:\somedirectory\"
name="??" sort="name"
what should go in the name value ? especially if I want to
list the entire contents of the directory.
The name can be whatever you want it to be. You use the name to reference
the
I saw on the tvw.org site you put cfid and cftoken at the end of the
variable. For some reason when I turn off cookies and go through my site, it
gets way way way screwed up and gives me different cfid and cftoken on
everypage. How do I correct this problem?
Robert Everland III
Web Developer
Duane,
I did something similar - writing ram files as people entered clips to a
database of audio and video files. Code goes something like this:
!--
---
If it's a new ramfile, write the file.
Is there a reason why you are running CF as a CGI? If not, then I would
suggest mapping .cfm to iscf.dll (wwwserver/isapi) in WebSite.
Regards,
Howie Hamlin
--
inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668
www.CoolFusion.com
"name" is just the name of the cfdirectory result set.. so if you
named it "MyCFDir", you would loop over the results with a regular
cfoutput or cfloop:
cfloop query="MyCFDir"
/cfloop
note that a cfdirectory will return "." and ".." every time... I always
forget that one and test for
Conrad, Christopher would like to recall the message, "RDS service on
Solaris".
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
One thing you can't do in a stored procedure is set the ORDER BY to a
variable, so you have to dynamically build the statement in your stored
procedure.
Au contraire!
The following was pointed out to me by Oracle ubergenius Thomas Kyte, when I
posted the same message to
I upgraded from Cold Fusion studio 4.0 to 4.0.1.
snip
I made no changes to the webserver (Website Professional).
Any suggestions?
I can't help with the problem you mentioned, but I WOULD point out that - at
least when I was working with Perl -putting executables into a
public-accessable CGI
I'm doing classes at my company training people in some stuff they may not
know and generally getting them ready for the certification. I'm writing up
a lesson plan on Error Catching and the docs on CFERROR are not to helpful.
Does anyone know any articles on CFERROR that have been done on the
I have a cfx tag that returns records and I also have a query that will be
returning records. The records that are to be returned have the same type
of information. How can I output these records together like they were
pulled from the same query? They need to mesh completely - like sorting by
Make sure that you have set up your collection and indexed it using cfcollection (or
cf administrator). If you have, double check the spelling of the collection name in
your cfsearch
tag.
--
Billy Cravens
[EMAIL PROTECTED]
Chip Sigourney wrote:
i'm having trouble with the cfsearch command
"name" is a variable name you want to be able to use to reference the results, which
function as a query. ie, to list file names:
cfdirectory action="list" directory="c:\somedirectory\"
name="dirlist" sort="name"
cfoutput query="dirlist"
#name#
/cfoutput
--
Billy Cravens
[EMAIL PROTECTED]
The name attribute is simply the name of the query that you use to output the contents
of the data.
Here's a working example (directly from the CF documentation):
CFDIRECTORY DIRECTORY="#GetDirectoryFromPath(GetTemplatePath())#"
NAME="myDirectory" SORT="name ASC, size DESC"
!---
We use ASIQ 12. Our system averages 2,000 counts a day from 500 million
records. We find that it runs roughly 70% faster than SQL Server. Now, if
you're running under 10 million records, that may not hold.
And our Cold Fusion system loves it.
We have not experienced your apparent
1 - 100 of 139 matches
Mail list logo