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
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
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
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
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
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
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
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
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
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
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
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
, 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
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
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.
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 =
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
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,
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
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]]
The SQL Server equivalent is the Text datatype (or nText for unicode).
Bob
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 11:03 AM
To: CF-Talk
Subject: SQL Server equivalent of Access memo
(Sorry if this got asked before... can you
Firstly, you should have your CheckEmail function return false if the
validation fails - it looks like you haven't specified that within the
function.
Then, in your form tag, call the function by doing:
onSubmit="return CheckEmail();"
Bob
-Original Message-
From: Michael Gagnon
I'm not sure what your "main" database is, but standard SQL supports an
Insert Into Select From statement. In Access the query would look like:
INSERT INTO Table1 ( Field1, Field2 )
SELECT Field1, Field2
FROM Table2
Of course, your SELECT statement can include a WHERE clause to choose the
Try using the Replace function as follows:
cfset dispField = Replace(fieldname,Chr(10),"br","All")
Then output dispField instead of fieldname.
Bob
-Original Message-
From: Andy Peterson [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 27, 2000 9:16 AM
To: CF-Talk
Subject: Proper
I don't believe that a cubed root would solve his problem, but it's easy to
do one in CF. Just remember (from your high school math days) that the
cubed root of a number is the same as that number raised to 1/3.
In CF - number cubed: cfset x = number ^ 3
- cube root of number cfset x =
Yes, if you specify a valid SQL Server logon and password (i.e., one that is
setup within SQL Server) in the CF Administrator (under the CF Settings
area), it shouldn't matter which account the CF Server is running under.
Bob
-Original Message-
From: John Fix 3rd [mailto:[EMAIL
I don't know if this will qualify as either neat or elegant, but I believe
that it will work. If not, please forgive me, I haven't tested it
exhaustively ;)
cfset partA = Left(test1,301)
cfif Right(partA,1) EQ " "
cfset final = partA
cfelse
cfset lastword = ListLast(partA," ")
Ok, so I didn't account for punctuation! I guess that's what happens when
you bang code out at 11:15 on a Sunday evening!
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 29, 2000 11:06 PM
To: CF-Talk
Subject: RE: Limit the output of words to 300
It is not unusual for Access to refuse to send any of the data to SQL server
when a problem is encountered during the transfer (e.g., a value in your
Access table is incompatible with the format of your SQL table). Problems
could be with nulls, zero-length strings, etc.
You'll probably have to
First, I apologize for cross-posting this to the Fusebox list, but I think
it's possible that the problem might be fusebox related. The only reason I
say that is because I have just finished my first fusebox site, and it's the
first time I am experiencing this problem.
There is one perplexing
The form.fieldnames variable will contain a list of all the fields
submitted. Be aware that unchecked check boxes and radio buttons will not
appear in this list.
Bob
-Original Message-
From: Jonathan R. Karlen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 31, 2000 1:41 PM
To:
You can do this with Javascript:
document.formName.controlName.focus();
Bob
-Original Message-
From: t nelson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 31, 2000 2:02 PM
To: CF-Talk
Subject: Manipulating Cursor Position In Applications
Hello All,
I have a slight problem on my
I assume you're talking about an Access database. If so, you can just treat
the query as a regular table.
For example, if you have a query called qryMyStuff, which reads a bunch of
tables and returns a result set, you can output the results in CF like so:
CFQUERY NAME="getStuff"
cfset temp = StructClear(session) will clear all session variables. Don't
forget to CFLOCK it.
Bob
-Original Message-
From: Jon Gage [mailto:[EMAIL PROTECTED]]
Sent: November 2, 2000 11:03 AM
To: CF-Talk
Subject: Killing a variable
I'm setting a session variable when people log into
To get all of your answers in one result set, you can use UNION, like so:
SELECT ABCName, COUNT(*) AS num,'abc' as WinType
FROM tblWinners
WHERE Win = 'abc'
GROUP BY ABCName
union all
SELECT NOPName, COUNT(*) AS num,'nop' as WinType
FROM tblWinners
WHERE Win = 'nop'
GROUP BY NOPName
Bob
Just my opinion, but I believe that your performance will be better if you
store the images on disk, rather than putting them into the database.
Bob
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:26 AM
To: CF-Talk
Subject: Uploading Images
This is just a stab in the dark, but that SQL looks an awful lot like the
SQL you use in SQL Server. Does it also work in Access (which Rich is
using) or is there an alternate syntax?
Bob
-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 9:55 AM
What is the text of the error message?
As CFINSERT just inserts whatever fields are passed to it, my guess is that
one of '#First#','#Last#','#Ride#','#Fav_Place#' is not being passed to the
template.
Bob
-Original Message-
From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
Sent: November 3,
John,
I don't know if this applies to your problem, but I recall awhile ago that
we had a problem with the CF_TREE applet, and we had to place a copy of the
CFIDE directory underneath our application directory - it wouldn't simply
pick the applet up from the standard CFIDE location.
Bob
-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 21, 2000 1:44 PM
To: CF-Talk
Subject: RE: IE CAN'T FIND THE GRID APPLET
John,
I don't know if this applies to your problem, but I recall awhile ago that
we had a problem with the CF_TREE applet, and we had to place
I've encountered the same thing. 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 seems that the
If you copied and pasted that text from your cfm file, I can see the
problem:
INPUT TYPE="text" Name"Parent_ID" SIZE="5" MAXLENGTH="5"
You have no "=" sign between Name and "Parent_ID". It should say
Name="Parent_ID".
Bob
-Original Message-
From: Tammy Schilling [mailto:[EMAIL
Just a stab in the dark, but I'd check for locking issues. Unlocked access
to shared memory variables can cause this to happen. One technique to test
for this is to turn "Full Checking" on for Server, Application and Session
variables on your development machine, and then test the site (which
Is "Date" a reserved word? Try changing that column name.
Bob
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: November 27, 2000 4:49 PM
To: CF-Talk
Subject: INSERT into error
I think i have lost my mind... can anyone see the syntax error in my
CFQUERY? The
of
what you can do.
!-- qry_CheckDups.cfm --
!---
|| BEGIN FUSEDOC ||
|| PROPERTIES ||
Fusename: qry_CheckDups.cfm
Author: Bob Silverberg
|| RESPONSIBILITIES ||
I check for duplicates in a table
|| ATTRIBUTES ||
-- DSN: Datasource name for the database
-- PK: Primary key of the table being queried
There are lots of ways to do it, but if you start by finding out whether
there is a period, then you could use ListFirst() and ListLast() with '.' as
a delimiter to get both the first and last part. You could then use the
Mid() function combined with the Len() function to extract the different
I think you need single quotes around the second value you are setting, and
your where clause looks backwards:
Change: CheckedOutBy=#InSol.Name#
To: CheckedOutBy='#InSol.Name#'
Change: Where '#URL.FileID#' = JobInfoUpload.FileID
To: Where JobInfoUpload.FileID = '#URL.FileID#'
(You may need to
Without any report of error messages it's hard to say if there's anything
wrong with your code. It looks like it _could_ run OK. Did you try it? I
think you may want to move the CFMAIL tag inside of the query loop, but I'm
not totally sure of what you're trying to do. You also may want to
.
At least I think the update query I gave you was correct.
Bob
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: November 30, 2000 6:32 PM
To: [EMAIL PROTECTED]
Subject: RE: Advanced queries
Without any report of error messages it's hard to say if there's anything
wrong
Why not just use the Left() function (in either Access or CF) to extract
however much of the text you want to display?
Bob
-Original Message-
From: Rob Eastland [mailto:[EMAIL PROTECTED]]
Sent: November 30, 2000 1:41 PM
To: CF-Talk
Subject: Excerpt
I'm trying to build a tag that gets
I recall encountering this problem, and I believe it had to do with access
control on the CFUSION\BIN directory. The user account that IIS uses must
have access to this directory. I would have thought that the CF install
would take care of this, but I encountered the same problem on one of our
Take a look at www.fuseml.org - interesting stuff.
Bob
-Original Message-
From: Jason Egan [mailto:[EMAIL PROTECTED]]
Sent: December 4, 2000 11:29 AM
To: CF-Talk
Subject: uml
I am going to try and model out the next project with UML - any suggestions
on resources, books, sites... etc?
How about the URLEncodedFormat function?
Bob
-Original Message-
From: Phill Gibson [mailto:[EMAIL PROTECTED]]
Sent: December 5, 2000 1:46 PM
To: CF-Talk
Subject: Encryption problem when passed in URL?
Hi Everyone,
Try this:
htmlhead/headbodycfoutput
cfset date=
I couldn't say which is faster, but you should get rid of those pound signs
(#) within your cfsets. They should look like:
cfset ctr = IncrementValue(ctr)
or
cfset ctr = ctr + 1
Bob
-Original Message-
From: Eric Fickes [mailto:[EMAIL PROTECTED]]
Sent: December 6, 2000 8:58 PM
To:
number of
query combinations, otherwise the chances of it getting bumped out of memory
are greater.
Bob
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: December 7, 2000 10:19 AM
To: [EMAIL PROTECTED]
Subject: RE: passing cfquery results to another page
for these techniques.
Rick
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 9:19 AM
To: CF-Talk
Subject: RE: passing cfquery results to another page
There are a number of ways, the first two that come to mind are:
1. Store it in a session variable.
2
When you declare the input parameter, assign it a value, like so:
CREATE PROC myProc
@Param1 char(10) = ''
AS
SELECT ...
Bob
-Original Message-
From: Andres [mailto:[EMAIL PROTECTED]]
Sent: December 8, 2000 12:01 PM
To: CF-Talk
Subject: Passing variables to a SQL7
If you want ThisVar to contain the value stored in Client.lr#numvar#, then I
think you need to do an Evaluate on it. Otherwise ThisVar is going to be
equal to "Client.lr1". Also (although this wouldn't be causing a problem)
you don't need those # signs inside your CFIF tag.
Bob
-Original
I wouldn't say that the method you suggest is safe. I'd suggest you do one
of two things:
1. Wrap your two queries in a CFTRANSACTION.
2. Write a stored procedure that starts a transaction, does the read, does
the update, commits the transaction and returns the number to your program.
If it
If you use a numeric width rather than a percentage width, it will always
stay the same size.
Try changing your table tag to:
TABLE Border Width=400 CellSpacing=4 Cellpadding=5
Which will always render the table as 400 pixels wide.
Of course, your users might have various settings that will
A fellow CFUGer has a company that has one. Their web site is at
www.scorpiosoft.com. I haven't used the app, but it might be worth a
look-see.
Bob
-Original Message-
From: netman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 12, 2000 11:17 AM
To: CF-Talk
Subject: Help Desk App
Hi all,
Here's the scenario: A user is entering an order, the order will have some
info associated with it, and then the order can have multiple line items
added to it. Each line item will have a number of attributes (like product,
quantity, etc.). In a program like Access, you can create a
name=""
div id=lineitems
input type="text" name="lineitem1" size=20
/div
input type="Button" onclick="AddLineItem()"
/form
/body
/html
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, Decembe
This works:
cfset cache = "CreateTimeSpan(0,2,0,0)"
cfquery name="#qryName#"
datasource="#DSN#"
cachedwithin="#Evaluate(cache)#"
Bob
-Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: December 14, 2000 4:20 PM
To: CF-Talk
Subject: Problem with
The readonly attribute is only supported in IE (according to my
documentation). I wouldn't think that it would cause problems with your
page (NS should ignore it), but it could be the culprit.
Bob
-Original Message-
From: Cami Lawson [mailto:[EMAIL PROTECTED]]
Sent: December 14, 2000
Some possibilities:
1. Add a column to the Parts table, store the name of the image file in that
column, retrieve the name in a query and dynamically create the img tag.
2. Create each image file so that the name is somehow linked to the record
in the database. For example, if the part_id is
The following solution is for SQL Server, I imagine most other DBMSs have a
similar function, so if you aren't using SQL Server it should still lead you
in the right direction.
Assuming that the value stored in YearsPaid is always a number of years (as
opposed to a number of months) and that
If you look in CFUSION\LOG\mail.log it should show you a message for each
undelivered email, stating the reason it was undelivered.
Bob
-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: December 21, 2000 4:54 PM
To: CF-Talk
Subject: CFMAIL and undelivered mail
to another page
How is caching the query different from saving it as a session variable?
Both are kept in memory, right? Except that the cached one will get bumped
if memory is needed?
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 07, 2000 8
No, session variables can work without browser cookies, but it's a royal
pain in the behind. You need to pass the CFID and CFTOKEN between all page
requests (on the URL or in a form field) - as long as the chain is never
broken, your session variables will work. Same goes for client variables.
Hi all,
I am trying to come up with a generic scheme to deal with concurrency issues
in database updates, and I decided that the best approach would be to add a
field to each table with the timestamp datatype. SQL Server will
automatically update this field anytime a record changes. I will
Perhaps I'm missing something here (which is likely), but if you want to
display a PDF file, why don't you just CFLOCATION to the PDF file, which
will cause it to open in the user's browser (if they have the plug-in)?
Bob
-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
I encountered a problem setting up multiple secure sites on the same server
using host headers. If your sites currently all share the same IP address,
you can't set them all up on port 443. The two solutions that I found were:
1. Set up each site on a separate port.
2. Give each site it's own
I just wrote this off the top of my head, so it may not run (I'm not sure
about the double and single quotes), but it gives you some idea of how to
dynamically build SQL statements in a stored proc (if that's what you're
looking for):
CREATE PROC MyProc
@Active bit = NULL,
@Test
In response to the first post, you can do _anything_ you want with
Exec(@sSQL). If @sSQL contains multiple select statements, then your sp
will return multiple result sets.
In response to the most recent comment - although you do lose the advantage
of guaranteed pre-compilation, I have found
If you're only returning one result set, you can call the stored proc with
the CFQUERY tag, which will then allow you to cache the results as well. I
have also found that using CFQUERY rather than CFSTOREDPROC gives me much
more meaningful error messages. I got really tired of seeing "Unknown
Or its own port.
-Original Message-
From: Zachary Bedell [mailto:[EMAIL PROTECTED]]
Sent: January 11, 2001 5:28 PM
To: CF-Talk
Subject: RE: HTTPS setup
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We do have other sites on the same IP, but none of them use SSL.
That shouldn't
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
I used the following code to check for the Enter key being pressed while in
a form field. There may be a better way to write it, but the code below
works for me. It first checks the browser version (because the code to
check for a keystroke is different between browsers). The function, which is
I'm not sure if this addresses what you're trying to do, but if what you
want is for the javascript to execute whenever the tag is included in a
browser page, just enclose the javascript in your script tag, but don't
put it in a function - that way it will be executed as soon as the browser
sees
1 - 100 of 181 matches
Mail list logo
