But if
I run it from CF, using either ODBC or OLEDB, I get the following error:
xpsql.cpp: Error 997 from GetProxyAccount on line 472
Has anyone ever seen this before, or has anyone been able to call
xp_cmdshell successfully from CF?
Any suggestions would be greatly appreciated.
Thanks,
Bob
nd/or
techniques for doing this.
Thanks,
Bob
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe:
Ah, that would explain it! I always SET NOCOUNT ON, but, wouldn't you guess
it, I hadn't done that for this query.
Cool, thanks,
Bob
-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: March 30, 2001 4:34 PM
To: CF-Talk
Subject: RE: Stored Procedures
ferId)#
returns no records, but
Exec GetTransferEmailData @TransferId=#Val(URL.TransferId)#
returns one record.
The first example is an OLEDB DSN, the second is an ODBC DSN.
Have you figured anything out yet Clint?
Anybody
Thanks,
Bob
-Original Message-
From: Clint Tredway [m
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 ha
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
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
t
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 Silver
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
We're on SQL2000, which has it's own quite usable SP debugger. I'm not
referring to debugging the SPs themselves, which I always do outside of the
CF environment, but rather debugging problems that CF has calling the SPs.
Bob
-Original Message-
From: Marius Milosav
WHERE HNTQuestion.Category = HNTCategories.HNTCategoryID
AND HNTQuestion.QuestionID = tblAnswers.ANSQuestionID
ORDER BY HNTQuestion.Category, HNTQuestion.QuestionShort
Bob
-Original Message-
From: Michael Kear [mailto:[EMAIL PROTECTED]]
Sent: March 28, 2001 5:33 PM
To: CF-Talk
uld be
better.
Let me know if none of the above helps and I can work on a query using a
virtual table for you.
Bob
-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: March 28, 2001 5:11 PM
To: CF-Talk
Subject: Re: Statement Help!!
would it be wise to try a sub query wit
a huge pain in the
behind). I also find it much simpler to dynamically build my SP calls using
the cfquery syntax.
Could you share the reasons that you've decided to use cfstoredproc as much
as possible, and could you share any of these no doubt useful tips and
tricks?
Thanks,
Bob
-Orig
u aren't using output
parameters, I prefer to use the tag to call my stored procedures.
The syntax would be:
Exec getSRzip @ZIP='#form.TERRITORY_ZIP#'
You may want to try that instead. I find I get much more meaningful error
messages when I use .
Bob
-Original Message-
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
T(DISTINCT
ChildIdentity.ChildID). Note that there will be a performance penalty for
doing this, as the database will have to sort the records.
Bob
-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: March 28, 2001 1:34 PM
To: CF-Talk
Subject: Query boggle
Hey guys and gals,
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
">
I get the error "Just in time compilation error
An unknown attribute 'Your' has been encountered at document position
I may be mistaken about this, but I don't think you're supposed to have
and 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,
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
out on the
"Variables" page of the Cold Fusion Administrator will override those set in
application.cfm, so make sure that your maximum is set high enough for both
types of sessions.
Bob
-Original Message-
From: Terra Durrant [mailto:[EMAIL PROTECTED]]
Sent: March 27, 2001 9:41 AM
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 Me
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
;t the attached
code a bad idea? I was given the impression that it's not a good idea to
monkey around manually with CFs client variable database.
Bob
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: March 23, 2001 3:03 PM
To: CF-Talk
Subject: Re: session variable locki
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 o
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
to the list, or switch the list to a
passed-in parameter.
Hope the above explains the problem with the original code,
Bob
-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 4:15 PM
To: CF-Talk
Subject: RE:Solved the problem( Need assistance
Check your settings in ColdFusion Administrator, under the "Variables" menu
item. The maximum timeout value entered here will override that set in the
tag.
Bob
-Original Message-
From: Chang Liu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 3:52 PM
To: CF-Ta
Your problem is the line where you're creating WordToGet - you don't need
that,
Bob
-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: March 21, 2001 2:42 PM
To: CF-Talk
Subject: RE: Need assistance:Nested CFLOOPs
umm..judgement.defendant is changing..tha
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
Fell
ally do it late at night when it isn't likely that anyone is hitting the
server.
Bob
-Original Message-
From: Drechsler, Jennifer [mailto:[EMAIL PROTECTED]]
Sent: March 20, 2001 2:20 PM
To: CF-Talk
Subject: Verity Search with No Results
I am having a little problem this morning (
utes, it is not uncommon to just
create one big table to hold everything.
>From a programming perspective there is very little difference to the two
approaches (except that you avoid joins with the latter approach), so it's
really an issue that a DBA should decide.
Hope that helps,
Bob
>From with QA:
Tools -> Options -> Connections Tab
Bob
-Original Message-
From: Ken Monroe [mailto:[EMAIL PROTECTED]]
Sent: March 20, 2001 10:10 AM
To: CF-Talk
Subject: SQL Server Timeout
Hello!
I'm running queries (in SQL Server Query Analyzer) against a record set o
you'd like I can look at your query and result page and see if I can
suggest anything,
Bob
-Original Message-
From: Patric Stumpe [mailto:[EMAIL PROTECTED]]
Sent: March 20, 2001 9:26 AM
To: CF-Talk
Subject: Advanced Previous/Next-Records Navigation
Hi fellows,
i have the following pr
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
Subjec
(zapsearch)
FROM zap
WHERE zapsearch > @zapsearch
END
You'd call this by saying "Exec CoolLoop @AdId = {your ad id here}".
I'm not sure how much better (or worse) this would perform vs. a cursor, but
I think it's extremely cool!
Hope that helps, let m
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 t
It sounds like it's a simple as:
,
if you only need to look at one record from get_tobacco,
If you need to compare to all record, try:
Bob
-Original Message-
From: Jon Tillman [mailto:[EMAIL PROTECTED]]
Sent: March 19, 2001 9:24 AM
To: CF-Talk
Subject: Re: selecting mul
e the trigger
update a separate table that contains the name of the table changed, and the
last modified date (which you can get using GETDATE() (in SQL Server)).
Then it doesn't matter what apps you write, the database will always keep
itself up to date.
Bob
-Original Message-
From: Bernd
you could even make
it into a pretty simple custom tag!
Bob
-Original Message-
From: Bernd VanSkiver [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 17, 2001 11:49 PM
To: CF-Talk
Subject: last updated
Is there a way for cf to see when a certain database was last modified?
Wanting to sh
page, rather than frames. You can actually create a pretty nice looking
tabbed dialog just using graphic files for the tabs themselves, and using
tables and colours for the rest of the formatting.
If you're looking for more specific info let me know,
Bob
-Original Message-
From: Mi
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
S
to
reduce the load on it by doing some additional query caching. As I'm typing
this I'm thinking that maybe the result set is corrupted (because of a
problem with SQL Server) and maybe that's creating this error.
Any thoughts or experience with thi
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#'
Look at the List functions within ColdFusion - they are extremely useful.
In your example, you could say
Note that you don't need the # signs inside the tag.
Bob
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: February 7, 2001 1:56 PM
To: CF-Talk
Subject: t
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]]
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,
the query is very large, but it is possible.
If you'd like to see a specific example please let me know.
Generally the best practice is to get the database to do as much filtering
and sorting as you can.
Bob
-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Febru
pier with
cfquery for running stored procs.
Time to go home now,
Bob
-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: February 3, 2001 6:11 PM
To: CF-Talk
Subject: Stored Procedure Problem
I am having problems passing to variables to a stored procedur
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
Hmmm
Haven't had a problem yet, am running CF4.5, Frontpage and Flash 4 all on
the same machine.
Bob Lehman
New Horizon Mgmt and Consulting
440-542-0992
[EMAIL PROTECTED]
Website: www.nhmac.com
Client website: www.nhmac-user.com
- Original Message -
From: "Cornillon, Matthie
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,
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
O
select count(*)
from table
where name = "#name#"
Bob
-Original Message-
From: Mak Wing Lok [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 10:52 PM
To: CF-Talk
Subject: SQL update, how to count afftected rows?
how can i count the affected updated rows? if there any a
r has any suggestions I would appreciate
hearing from you.
Thanks,
Bob
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusio
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
ey
if (isNav) {
theKey = evt.which
} else {
theKey = window.event.keyCode
}
if (theKey == "13") {
document.frmLogin.submit()
}
}
Sample form field:
Bob
-Original Message-
From: Milks, Jim [
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
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
ot;Unknown Data
Access Error".
Bob
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: January 11, 2001 10:54 AM
To: CF-Talk
Subject: RE: Can you cache CFSoredProc?
> I'm using CFStoredProc for Access queries. Is there
> any way to cache them?
You can'
many situations in which
building dynamic sql within a stored proc works very well for me. I do not
agree that it should be avoided - it has many valid uses, and has saved me
hours of coding time.
Bob
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday
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 b
#x27;s own IP address.
I'm not sure if that addresses your problem, but it's something I
encountered so I thought it would be worth sharing.
Bob
-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: January 8, 2001 3:06 PM
To: CF-Talk
Subject: OT: HTTPS setup
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:[
or whether it might not work in
all situations.
As well, anyone who has come up with a different or better solution to
dealing with concurrency issues, I'd love to hear about those too.
Thanks,
Bob
~~
Structure your ColdFusion code with
ables.
Bob
-Original Message-
From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
Sent: December 21, 2000 5:45 PM
To: CF-Talk
Subject: RE: Session Variables
Based on some of the comments in this thread, am I correct in assuming that
cookies must be enabled in the client's browser in
On differece is that you don't need to bother with reading and writing
session variables, or with locking. Query caching is oh so easy.
Bob
-Original Message-
From: Jann VanOver [mailto:[EMAIL PROTECTED]]
Sent: December 21, 2000 5:08 PM
To: CF-Talk
Subject: RE: passing cfquery re
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
sPaid, DuesAdmin.DateofPayment) <
GetDate()
This will give you all of the records for people who have expired.
hth,
Bob
-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 19, 2000 7:01 PM
To: CF-Talk
Subject: (SQL) Date column x year column
ABC123, call the image file
ABC123.jpg. Dynamically create the tag based in the part_id.
3. Do both 1 and 2, that way you could write an update query that would
pre-populate the image name column with the proper file name, and any
inserts into the table could do the same as well.
Bob
-Original
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, 2
This works:
Bob
-Original Message-
From: Dan Haley [mailto:[EMAIL PROTECTED]]
Sent: December 14, 2000 4:20 PM
To: CF-Talk
Subject: Problem with cachedwithin
The following works:
while the following two do not:
Testing with simple outputs of #createtimespan(0
Thanks Justin - that looks like just what I was looking for. Now I've got
to see if I can make it work with a complex form.
Bob
-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: December 13, 2000 10:06 AM
To: CF-Talk
Subject: RE: Unlimited Line Item Su
s I'm
missing an obvious easy solution.
Any suggestions would be greatly appreciated.
Thanks,
Bob
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http:
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 Des
font size), but your table won't resize
itself anymore.
Bob
-Original Message-
From: C Kong [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 11, 2000 6:36 PM
To: CF-Talk
Subject: "squished" table phenomenon - please help!
ok all you html and cf mastersi'm writin
me, I'd do number 2.
Bob
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 11, 2000 6:39 PM
To: CF-Talk
Subject: Is SQL Server FIFO?
I was told that SQL Server processes all SQL statements FIFO, so I dont need
to use cflock around a query statement
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 tag.
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
A wddx packet is not a complex data type - that's one of the main things
that people use wddx for - you can store a structure or a query or an array
in a wddx packet, and then store the packet in a client variable.
Bob
-Original Message-
From: Rick Lamb [mailto:[EMAIL PROTECTED]]
have a limited 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 pag
There are a number of ways, the first two that come to mind are:
1. Store it in a session variable.
2. Convert it to a WDDX packet, then store it in a client or cookie
variable, or pass it via a URL or form parameter. The last two aren't
advisable if the query is of any reasonable size.
I couldn't say which is faster, but you should get rid of those pound signs
(#) within your cfsets. They should look like:
or
Bob
-Original Message-
From: Eric Fickes [mailto:[EMAIL PROTECTED]]
Sent: December 6, 2000 8:58 PM
To: CF-Talk
Subject: IncrementValue() or #counter
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:
Before encryption, date is #date#
Encrypted, date2
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
servers, and this was the fix.
Bob
-Original Message-
From: Rob Sherman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 6:46 PM
To: CF-Talk
Subject: ACL on Resource
Looking for a few other suggestions.. Admin swears he installed CF on NT 4
SP 6a Server as the Administrator
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
like.
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&#
7;
I'm assuming you're using Access, and therefore the yes and no without
quotes should be ok.
Bob
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: November 30, 2000 12:15 PM
To: CF-Talk
Subject: Advanced queries
Hi,
I wonder if someone could help me out with some
FileID#'
(You may need to lose the single quotes on this one - is it a numeric
field?)
Also, try replacing 'Yes' with True (no quotes)
Bob
-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: November 30, 2000 11:52 AM
To: CF-Talk
Subject: UPDATE on a MS A
different
pieces. Take a look at the section of the docs on string functions for
other useful functions.
As for other products, I'm not sure what functionality you're looking for,
but you might want to check out the free used-to-be-Allaire Forums at
www.forumspot.org.
Bob
-Origin
query containing the primary key of the record(s) found
|| END FUSEDOC ||
--->
SELECT #PK#
FROM #chkTable#
WHERE
AND
#fld# = '#Evalua
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
CFQ
xtended find through your code looking for
"server.", "application." and "session."
Good luck finding your problem,
Bob
-Original Message-
From: Jim Gurfein [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 27, 2000 6:52 AM
To: CF-Talk
Subject: Huge - Memory L
If you copied and pasted that text from your cfm file, I can see the
problem:
You have no "=" sign between Name and "Parent_ID". It should say
Name="Parent_ID".
Bob
-Original Message-
From: Tammy Schilling [mailto:[EMAIL PROTECTED]]
Sent: November
t late at night when it isn't likely that anyone is hitting the
server.
Bob
-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: November 22, 2000 10:54 AM
To: CF-Talk
Subject: RE: MORE VERITY PROBLEMS
I'm deleting through the Admin. Files are on the server, col
Sorry, I don't have any other info on it. We were told by Allaire that this
was the way to fix the problem.
Bob
-Original Message-
From: John Grubb [mailto:[EMAIL PROTECTED]]
Sent: November 21, 2000 6:06 PM
To: CF-Talk
Subject: RE: IE CAN'T FIND THE GRID APPLET
Thanks, Bob
returning
products.
If you are interested let me know and I will post what I find out.
Robert Lehman (Bob)
New Horizon Mgmt and Consulting
440-542-0992
Visit our Website at www.nhmac.com
Visit the client Website at www.nhmac-user.com
- Original Message -
From: "Brad Roberts" <[EMAIL P
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 loca
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 [ma
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
401 - 500 of 567 matches
Mail list logo
