Read lock are _not supposed to_ slow your application down. I've never seen
any actual numbers on this, but that has been my understanding. Allaire has
stated that there is very little overhead to read-only locks.
Bob
-Original Message-
From: Steve Vosloo [mailto:[EMAIL PROTECTED]]
Yes. It's excellent, but I wouldn't call it a definitive Transact SQL
reference book. It's more of an advanced SQL techniques book. It won't
teach you the basics, but it will give you some really neat ideas if you
have gotten past the basics.
Bob
-Original Message-
From: Andy Ewings
You've got the right idea, just the wrong syntax. Try:
cfset Type#GetInfo.CurrentRow# = Type
Bob
-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 9:27 AM
To: CF-Talk
Subject: Setting Dynamic Variables
Trying to create a set of variables
If you want to store all of the answers (not just the correct one) for each
question, I think you're actually looking at 3 tables:
tblExam - ExamId(PK), ExamName, ExamDate, etc.
tblQuestion - QuestionID(PK), ExamId(FK), QuestionText, etc.
tblAnswer - AnswerId(PK), QuestionID(FK), AnswerText,
Try using the HTMLEditFormat function on your string.
Bob
-Original Message-
From: Bobby Olsen [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 1:19 PM
To: CF-Talk
Subject: quotes in text
When quotes are entered into a varchar column, the data gets stored
properly.
However, upon
You need to use the to concatenate strings. Change your code to:
cfset errormsg = errormsg Your password and repeated password do not
match.br
Note that you don't need the Evaluate in there either.
Bob
-Original Message-
From: Michael Kear [mailto:[EMAIL PROTECTED]]
Sent: Sunday,
Joshua, try:
update S
set S.updatedate = getdate()
FROM ovdsave S INNER JOIN ovdtemp T
ON S.sonum = T.SONUM
Then go home and get some sleep :)
Bob
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: May 16, 2001 10:22 AM
To: CF-Talk
Subject: Update Statement
I am
I think you need something along the lines of:
Select fieldlist
FROM company_table INNER JOIN slow_stream ON company_table.Name =
slow_stream.company_name
INNER JOIN medium_stream ON company_table.Name = medium_stream.company_name
INNER JOIN fast_stream ON company_table.Name =
You have a comma out of place. try changing:
ISNull(count(go.dMonthlyEventDate, 0)) as EventCount,
to
ISNull(count(go.dMonthlyEventDate),0) as EventCount,
It also looks like you have an extra comma on your FROM line, but the above
is what's causing your count error message.
, 2001 7:18 PM
To: CF-Talk
Subject: RE: Running DTS in Stored rocedure
Im running SQL 7.0 on an NT4.
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 3:53 PM
To: CF-Talk
Subject: RE: Running DTS in Stored rocedure
What version of SQL
The simplest way to do this would be using xp_cmdshell with a command or a
batch file. Although I understand from a previous note that you're having
trouble getting that to run (xp_cmdshell). If my previous suggestion for
your DTS problem didn't work, feel free to email me off list and I'll try
In your SQL:
ORDER BY myField DESC
Bob
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: May 11, 2001 1:33 PM
To: CF-Talk
Subject: Order By
How can I display an output in reverse order by?
I want only the last record to be displayed.
Thansk for your help,
Rich
We had a similar issue with the City field in a database. We maintain a
City table, and each user record only contains the primary key (an integer
id) to the corresponding record in the City table. For the user interface
we created a combo-type box, so that a user could either select their City
What version of SQL server are you running? I just had to set something
like this up on SQL2000, and there are a few pointers I can give you. Also,
which password are you referring to? The user login password, the package
password, etc?
Thanks,
Bob
-Original Message-
From: David
Sure you can. If you want to create 15 different insert statements, that
all insert different columns, then I'd agree that a SP would be pretty much
useless. But if it's the same insert statement, with only the values being
different you can definitely do it in an SP. I just finished an app
Well, you could break the list up into smaller chunks and send each list to
the SP as a parameter (using CFSTOREDPROC). In the SP, default each
parameter to NULL, then dynamically build your SQL statement, and only
include those parameters which are not null.
Bob
-Original Message-
Try:
Create Table ForumID
(ForumID integer not NULL IDENTITY (1,1) PRIMARY KEY CLUSTERED, CategoryID
integer DEFAULT 0)
Bob
-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: May 8, 2001 2:35 PM
To: CF-Talk
Subject: SQL Code problem
Hi,
I'm trying to create a table and
He said when CF Server has been shut down. If the CF server isn't
running, how could it process the site wide error handler? I think he's
asking about this error:
Error Diagnostic Information
An error occurred while attempting to establish a connection to the service.
The most likely cause of
In your DTS package, you will need a Transform Data Task, which will be
created by default if you use the import data wizard. Open this task (by
double clicking), and you should see a dialog box with tabs for Source,
Destination, Transformations, Lookups and Options. Choose the
Transformations
Try:
SELECT MONTH(myDateField) As myMonth FROM ... in your SQL statement. That
should return a column in your result set that just has the month portion of
the date.
Bob
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 7:16 PM
To: CF-Talk
Does anyone know if one can access the Excel COM object using the CFOBJECT
tag without installing the full Excel application on the server? I am
wondering if there is just a type library, or a combination of DLLs that can
be installed on the server, rather than actually installing Excel. If you
- Original Message -
From: Bob Silverberg [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 27, 2001 11:10 AM
Subject: Using Excel COM Object without installing Excel
Does anyone know if one can access the Excel COM object using the CFOBJECT
tag without installing the full Excel
What I have heard from a number of very knowledgeable SQL Server DBAs is
that SQL7 runs better on NT4 than SQL2000. If you're on Windows 2000,
SQL2000 performs better than SQL7.
Bob
-Original Message-
From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]]
Sent: April 27, 2001 12:39 PM
-
From: Bob Silverberg [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 27, 2001 12:39 PM
Subject: RE: Using Excel COM Object without installing Excel
No. I need to take an excel file, open it, and save it as a text file.
Thanks,
Bob
-Original Message-
From: Dave
I've done this, and it works fine. You use xp_cmdshell to call cfml.exe.
Here's an example:
ALTER TRIGGER myTrigger ON dbo.myTable
FOR INSERT
AS
DECLARE @s_SQL varchar(5000), @ClientId as int
SELECT @ClientId = ClientId
FROM Inserted
SET @s_SQL = 'master..xp_cmdshell
http://www.coolfusion.com/moreinfo.cfm?Product_ID=33
I'm not affiliated with the company - I just think it's a cool product.
Bob
-Original Message-
From: William J Wheatley [mailto:[EMAIL PROTECTED]]
Sent: April 25, 2001 5:11 PM
To: CF-Talk
Subject: Sending mail with coldfusion
Ok i
I couldn't agree more. Did you know that if you have client variables
turned on CF will generate two select statements for every single page hit?
And, if you don't turn off global client variable updates (which are turned
on by default), you also generate an INSERT/UPDATE statement for every
Under the SQL Server menu, look at both the Server Network Utility and
Client Network Utility. These both need to be configured to use the same
protocol(s), so the CF client can talk to the SQL Server. We configure ours
to used TCP/IP only for both client and server.
Bob
-Original
to
add to that?
Bob
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Saturday, April 21, 2001 6:33 AM
To: CF-Talk
Subject: RE: SQL 7 and 2000 on same machine?
On 4/20/01, Bob Silverberg penned:
When you install the SQL 2000 client tools on your machine it will
overwrite
the SS7
When you install the SQL 2000 client tools on your machine it will overwrite
the SS7 tools (e.g., Enterprise Manager). You can only have one version of
EM on a machine. That's fine, because you can use the SS2K EM to manage
your SS7 databases (including creating new databases). If you want you
Sounds like it's the database. Two processes were trying to access the same
data, but one of them had the resource locked.
-Original Message-
From: Edward Chanter [mailto:[EMAIL PROTECTED]]
Sent: April 12, 2001 9:26 AM
To: CF-Talk
Subject: Weird CF Error
Has anyone seen these before:
You can also use the system stored procedure SP_Tables, passing it the table
name.
Bob
-Original Message-
From: Peter Stolz [mailto:[EMAIL PROTECTED]]
Sent: April 12, 2001 11:32 AM
To: CF-Talk
Subject: RE: existence of table
SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME =
Well, one way it to use the DISTINCT keyword. Change your statement from:
SELECT Products.ItemID, etc.
to
SELECT DISTINCT Products.ItemID, etc.
but I'm not sure if that will give you what you want.
Give it a try and see what the result set looks like.
Bob
-Original Message-
Try something like:
cfoutput query="myQuery" group="Item"
tr
td#myQuery.ItemName#/td
cfoutput
td
cfif Val(myQuery.Value)#myQuery.Value#
cfelseinput name="Value"
/cfif
/td
You might want to take a look at iMS POST SE at
http://www.coolfusion.com/moreinfo.cfm?Product_ID=33. We just started using
it and I am happy with it so far, and the support has been quite good.
Bob
-Original Message-
From: Brian Peddle [mailto:[EMAIL PROTECTED]]
Sent: April 11, 2001
This doesn't answer your question directly, but if you are really going to
test for the existence of a variable, and create it if it doesn't exist, I'd
suggest using cfparam which will accomplish both of those things in one
step. I only used IsDefined if I want to check for the existence of a
Would the client happen to be a Mac?
-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: April 11, 2001 10:41 AM
To: CF-Talk
Subject: CFLOCATION
has anyone had problems with CFLOCATION just *not* working?
i have this wierd situation where most of the time it works
Does anyone have any idea why I would see the following in my Windows2000
Event Log:
Application popup: cfserver.exe - Unable To Locate DLL : The dynamic link
library borlndmm.dll could not be found in the specified path
For no apparent reason, CFAS was hung (the queued requests just kept going
Are you setting client cookies in your cfapplication tag? If not, the
javascript redirect won't hold onto your session. I'm surprised that
cflocation with addtoken=yes didn't work. I'm sure this all sounds obvious,
but here's what I'd do:
1. Set client cookies in cfapplication (if you aren't
Oh, you might also try the javascript redirect, but manually add the cfid
and cftoken to the end of the URL.
Bob
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 10:35 PM
To: CF-Talk
Subject: RE: Do a CFLOCATION and all my session vars
cfoutput
#Server.ColdFusion.ProductVersion#
/cfoutput
Bob
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: April 10, 2001 8:09 AM
To: CF-Talk
Subject: CF Server Type?
Does anyone know of a tag that will display what type of CF server is
running on a shared host? I am
Check your settings in the Client Network Utility. You should be able to
get there by typing "cliconfg" in the Run... dialog box from the Start Menu.
Make sure you've got TCP/IP enabled. You might also try creating an alias
for the server.
Bob
-Original Message-
From: Peter Froh
You should be able to do it the way you are describing, but you need to tell
SQL server that you are restoring from a device, rather than from a
database.
From the Restore database dialog, there will be three options (on SQL2000 -
I seem to recall that SQL7 was the same):
Restore: (1) Database
Does anyone on the list have any experience with SSL Accelerator cards? We
are looking for a low-cost card for our server, and as part of our
evaluation I'd really appreciate hearing from anyone who has used or looked
at these cards. Any recommendations or products to avoid?
Thanks,
Bob
Although it's not a major reason to upgrade, the client tools that come with
SS2K contain some nice enhancements. If you're building complex stored
procedures, Query Analyzer's built in SP debugger is an excellent tool.
One thing to keep in mind - I've heard from a number of reliable sources
You may already have covered this, but to avoid people sending bad SQL (like
a drop table statement) to your db, make sure that all numeric fields being
passed to the database are surrounded by the Val function:
Don't do:
SELECT * FROM MyTable WHERE MyId = #form.MyId#
Do:
SELECT * FROM
Look at the CFDIRECTORY tag. You can use it to generate a query that
contains info on the size (among other things) of each file in a directory.
Bob
-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 08, 2001 8:35 PM
To: CF-Talk
Subject: reading
There's also a reference available at www.asciitable.com. I find that one
very easy to remember.
Bob
-Original Message-
From: Gordon Burns [mailto:[EMAIL PROTECTED]]
Sent: April 6, 2001 8:06 AM
To: CF-Talk
Subject: RE: ASCII for Tab
At 13:06 06/04/01 +0100 Jason Lees (National
You could use a snippet shortcut. Create a snippet for the CF comment, and
then map that snippet to your key combination.
Bob
-Original Message-
From: Chris Martin [mailto:[EMAIL PROTECTED]]
Sent: April 5, 2001 11:27 AM
To: CF-Talk
Subject: Changing CF Studio Shortcuts
Hi.
I was
Does anyone have any experience sending faxes from a CF application, using a
fax card that is installed in a remote location (in a different city than
the web server)? At this point there will be only one source for the faxes,
but ideally we could send the faxes from anywhere. As the faxes will
On MS SQL Server 2000, I'm trying to run a stored procedure, which in turn
runs the extended stored procedure xp_cmdshell. I have granted the login
access to run this xp. If I run the SP from Query Analyzer (having logged
on with the same login as that specified in the DSN), it works fine. But
This answer may be so simple that I assume I'm missing something, but why
not just allow them to open the word document via their browser directly -
using a URL that points to the word document?
Bob
-Original Message-
From: cassady [mailto:[EMAIL PROTECTED]]
Sent: March 30, 2001 11:15
I don't have any problems doing it. Do you have the most recent version of
MDAC? Are you getting any error messages?
Bob
-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: March 30, 2001 2:44 PM
To: CF-Talk
Subject: Stored Procedures and OLEDB
Has anyone had any
is not available... like on my
login sp, I return a resultcode from the sp, and if I use the OLEDB dsn, CF
tells me the result code is not there...
-- Original Message ----------
From: "Bob Silverberg" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:
--
From: "Bob Silverberg" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Fri, 30 Mar 2001 16:25:30 -0500
OK, this is really weird. I just experienced the exact same thing. I've
been using an OLEDB datasource and SPs for the past several mont
I haven't done that, but I'd start by looking at xp_cmdshell - you might be
able to do something with that and the DIR command.
As for a good mailing list, check out www.swynk.com.
Bob
-Original Message-
From: Akbar Pasha [mailto:[EMAIL PROTECTED]]
Sent: March 29, 2001 2:56 PM
To:
Great! Mind sharing your solution with the rest of us?
Bob
-Original Message-
From: Akbar Pasha [mailto:[EMAIL PROTECTED]]
Sent: March 29, 2001 3:35 PM
To: CF-Talk
Subject: RE: (SQL Stored Proc)
thanx bob. i got it using that.:)
-Original Message-
From: Bob Silverberg
Is PartNumber indexed in the Products table?
Bob
-Original Message-
From: Tracy Bost [mailto:[EMAIL PROTECTED]]
Sent: March 29, 2001 5:06 PM
To: CF-Talk
Subject: Why the long processing time on queries ?
I know this isn't SQL list but can someone please tell me why it could be
taking
With all those tables in there, you may be getting a lot more records than
you expected. Your current syntax will return a count of the number of
records in the joined structure, not a count of the number of unique
ChildID's. If that's what you want, change it to COUNT(DISTINCT
What happens if you change the COUNT(EventID) to COUNT(DISTINCT EventID)?
Bob
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: March 28, 2001 3:09 PM
To: CF-Talk
Subject: Statement Help!!
what i am trying to accomplish here is to show ONLY those contestants that
I notice a few things (don't know if they are causing the problem, but I
noticed them):
1. I don't think you should be putting the @ sign on the names of your
variables in your cfprocparam tag. (Change dbvarname="@ZIP" to
dbvarname="ZIP".
2. In one cfprocparam tag you are surrounding the value
I may need to return more than result set at some point, so I'll need to
figure out why the 1st option isn't working, but for now I'll live with the
other option.
-Original Message-----
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 1:00 PM
To: CF-Talk
Subject: RE
e have any
other ideas or suggestions?
Thanks much,
Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -----
From: "Bob Silverberg" [EMAIL PROTECTED]
To: "CF-Tal
Just add the tblAnswers table to your join, like so:
SELECT
HNTQuestion.QuestionID,
HNTQuestion.Category,
HNTQuestion.QuestionShort,
HNTCategories.HNTCategoryID,
HNTCategories.HNTCategoryName
FROM HNTQuestion, HNTCategories, tblAnswers
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm
- Original Message -
From: "Bob Silverberg" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, March 28, 2001 5:04 PM
Subject: RE: cfstor
Howie,
This is exactly what we need to do for a project (send customized emails via
a SQL Server trigger). We haven't started research on it yet, so if you can
provide or direct us to any info/sample code on this technique it would be
greatly appreciated.
Thanks,
Bob
-Original
I haven't tried this, but what about putting those templates that require
different timeouts in their own directory, and putting an application.cfm
file in that directory with a different value for the SESSIONTIMEOUT
attribute?
Don't forget that the settings for maximum session timeout on the
I believe you mean Client variables, and database is preferable, IMHO, for a
number of reasons including, but not limited to:
- the ability to read the info from the db using standard SQL
- do you really want ColdFusion constantly messing with your Registry?
Bob
-Original Message-
From:
I may be mistaken about this, but I don't think you're supposed to have
frameset and body tags on the same page. I don't know if that's related
to your problem, but it's not a good idea.
Bob
-Original Message-
From: Jay Wigginton [mailto:[EMAIL PROTECTED]]
Sent: March 27, 2001 12:48 PM
Did you try a single quote?
-Original Message-
From: Brian Thornton [mailto:[EMAIL PROTECTED]]
Sent: March 27, 2001 3:22 PM
To: CF-Talk
Subject: CFHTMLHEAD
CFHTMLHEAD TEXT="
script
!-- Hide the script from old browsers --
function loadalert ()
{alert("Your Message to Mike
You can refer to your results as queryname.column[index].
For example, if you had a query called qryMyStuff, and it contained two
columns, MyId and MyName, you could refer to the contents of the name column
of the first record as qryMyStuff.MyName[1].
Bob
-Original Message-
From: megan
Check out http://www.intrafoundation.com/intranethostingtoolkit.html
I haven't used it, but I think it contains all of the functionality you're
looking for.
Bob
-Original Message-
From: Terri Stocke [mailto:[EMAIL PROTECTED]]
Sent: March 23, 2001 9:47 AM
To: CF-Talk
Subject: Querying
No, it won't.
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: March 23, 2001 2:16 PM
To: CF-Talk
Subject: OT NT question
Anyone know if IIS5 will run on NT4.0?
~~
Structure your ColdFusion code with Fusebox. Get the
No, you don't have to lock client variables as the database will take care
of that for you. You only need to lock variables that reside in RAM
(session, application, server). Although I'm not sure how scalable it would
be if Access is your database. On a different issue, isn't the attached
Try:
CFSET CompanyList = "Limited,LTD,LTD.,CO,Co.,Company,,The"
cfoutput query="judgement" startrow="1" maxrows="20"
cfloop index="counter" list="#CompanyList#" delimiters=","
The Defendant IS:#judgement.defendant#
br
Check your settings in ColdFusion Administrator, under the "Variables" menu
item. The maximum timeout value entered here will override that set in the
cfapplication tag.
Bob
-Original Message-
From: Chang Liu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 3:52 PM
To:
The reason it's working is that you changed your inner loop from a LIST loop
to a simple counter loop. The problem you had, as mentioned in a previous
email which has yet to reach the list, was with the combination of the LIST
loop and the WordToGet variable, which was always extracting the same
This is what's referred to as an entity type hierarchy in data modelling
terms. The "proper" way to model these is to create a supertype table that
contains attributes that are common to all members, and then to create
multiple subtype tables that contain information that is specific to a
I've encountered the same thing in the past. Here's what I do when I need
to delete and recreate a collection:
1. Delete the collection using either CF Administrator or CFCOLLECTION.
2. Restart the CFAS.
3. Delete the files found under CFUSION/Verity/Collections/{collection
name}. Note: it
I think you're looking for:
INSERT INTO MtTable3 (ID)
SELECT ID FROM MyTable1 WHERE SpecialID=3
It's as simple as that,
Bob
-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 8:32 PM
To: CF-Talk
Subject: OT: Database Question
Fellow Listers!
It sounds like it's a simple as:
cfif ListFindNoCase(get_tobacco.tobaccoContents,get_content.ContentsID),
if you only need to look at one record from get_tobacco,
If you need to compare to all record, try:
cfif
ListFindNoCase(ValueList(get_tobacco.tobaccoContents),get_content.ContentsID
)
You need to say:
attributes.employee = Replace(attributes.employee, "-", "", "all");
Bob
-Original Message-
From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]
Sent: March 19, 2001 3:43 PM
To: CF-Talk
Subject: crazy replace
hey guys, anyone know what this isn't working. its been a
You could do this in CF by first querying the zap table, and then looping
over those query results and issuing a query against advert_details for each
search term - but I wouldn't do that! This is the type of thing that you
should get the database to do for you.
There are a couple of ways to do
I doubt very much that you can do it in Access, at least not the same way.
I've never tried doing this fancy stuff in Access, so perhaps it is
possible.
Sorry,
Bob
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 7:05 PM
To: CF-Talk
Subject: Re:
If you're talking about an Access database, and all you want is the last
date modified for the mdb file, use the CFDIRECTORY tag. It can read a
directory and return info on files in that directory. If you only have one
mdb file in the directory you can use the filter= attribute so that you
a change to the db. Was
just hoping for an easy automatic way.
Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
ICQ #: 916324
Original Message Follows
From: "Bob Silverberg" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: last up
You just create the content of each tab as a separate page. Clicking on a
tab is a hyperlink that sends them to the correct page. You can either
reload the entire page, or you could do it with frames. I have found it
easier to format it the way I like by using tables and reloading the entire
You cannot have both EMs installed, but the 2K EM _should_ work fine talking
to 7 dbs. I've got it running on a few machines and haven't encountered any
problems.
Bob
-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: March 16, 2001 1:42 PM
To: CF-Talk
Subject: RE:
Has anyone ever seen the error:
CFQuery Retrieval of cached query failed
I just added query caching to a page from an old web site, and it works for
awhile, but then it starts generating this message. We have been having
some major problems with out SQL Server 2000 database, so I was looking
You answered your own question in your last paragraph - you _can_ put
constants and expressions in your select statement.
Try something like this:
INSERT into tbl (MyUUID, name, VersionID)
SELECT '#CreateUUID()#', name, VersionID + 1
FROM tbl
WHERE MYUUID = '#form.MyUUID#'
Bob
-Original
There's a tag on the developer's exchange called CFX_QueryColumns, that
returns the List of Columns in the same order as that returned by the
database. This may help you do what you want.
Bob
-Original Message-
From: Scott Becker [mailto:[EMAIL PROTECTED]]
Sent: February 7, 2001 12:53
Just use a numeric reference to the column's position in your order by. In
your example, if you want to order by the highest total points, just say:
ORDER BY 2
because SUM(AdjPoints) is the second column.
Bob
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent:
Look at the List functions within ColdFusion - they are extremely useful.
In your example, you could say
cfset newfilename = ListFirst(File.ServerFile,".")
Note that you don't need the # signs inside the CFSET tag.
Bob
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
You could do this by storing the query in a shared memory scope, such as
server, application, or session, and then you could use CFOUTPUT or
CFLOOP to iterate through the query and only process records that met
certain criteria.
My guess is that you would get terrible performance from this,
I've been using stored procedures extensively in my latest app, so I thought
I'd pass on some observations and opinions:
Firstly, I don't think you should be appending the @ symbol to your variable
names. Use dbvarname="ID", rather than dbvarname="@ID". As well, it has
been my experience that,
Look into sp_addlogin and sp_adduser.
Bob
-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 3:46 PM
To: CF-Talk
Subject: OT MS SQL Server Question...
I want to add a user via TSQL. I have looked all over and in the books
online. I think I am
There's a tag in the tag gallery called CFX_RestartMachine. I've never used
it, and I'm not sure if it will do what you're looking for, but you might
want to check it out.
Bob
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: January 17, 2001 6:50 AM
To:
Your tag in line 3 reads "cfesleif" - it should be "cfelseif". Don't you
just love those spelling errors!
Bob
-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: January 15, 2001 10:17 AM
To: CF-Talk
Subject: Invalid Token in IsDefined
OK .. I'm getting an error
If you're using SQL Server, try:
cfquery name="qUpdate" datasource="#dsn#"
BEGIN TRAN
update table
set ID = "#ID#"
where name = "#name#"
SELECT @@ROWCOUNT AS RecordCount
COMMIT TRAN
/cfquery
If you're using Access I think the only way to do it would be to run a
second query, after the
You should retrieve the name of the file as it was saved on the server from
the File.ServerFile variable, and use that value to insert into your table.
Bob
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: January 12, 2001 10:26 AM
To: CF-Talk
Subject: HELP!!
i am
1 - 100 of 181 matches
Mail list logo