I just saw Saro's post from early October, complaining about the ordering of
the columns in CFQUERY's ColumnList property.
I have a pure-CFML custom tag, CF_ColumnList, which will return the columns in
the order you'd expect.
The tag is available at Allaire's Developers Exchange; here's a
I have enjoyed participating in CF-Talk, but I no longer have the time to keep
up with the flood. So I am signing off from the list (and from CFDJList and
JS-Jive too). I offer my best wishes to all of you.
-David
~~
Structure your ColdFusion
Are you *sure* that the same data is being inserted each time? Your database
should be designed to prevent this.
Are you looking at the data directly in Access, or are you retrieving it via
CF?
And whom did you say you work for?
-David
On Monday, August 27, 2001 2:51 PM, Joshua King
As Benjamin said, CF Comet is a great place for this type of work. But I
didn't see code there that would address your needs, so here is some *untested*
code along with some tips for CF's odd implementation of COM.
-David
After the CFOBJECT tag, do your work in a CFSCRIPT block.
Don't try to
I'm pretty sure that Ben won't be attracted by lobster.
-David
On Wednesday, August 08, 2001 8:48 PM, Kevin Langevin
[SMTP:[EMAIL PROTECTED]] wrote:
Hey Ben-
How about South Florida? Lobster season starting and all... :)
Kevin Langevin
President, South Florida ColdFusion User Group
Miriam,
* Query to get the OLE Object
* Write it to a file on the server
* Offer a hyperlink to the file on the server
-David
On Monday, August 06, 2001 9:36 AM, Hirschman, Miriam
[SMTP:[EMAIL PROTECTED]] wrote:
-Original Message-
From: Hirschman, Miriam
Sent:
But these variables are simple strings (I think str here means string, not
structure). There's no need to use Duplicate() for simple CFML variables.
You may want to use Duplicate() on the entire Session structure, but not on a
string.
-David
On Tuesday, August 07, Matthew W Jones
I do IDL programming, and its vendor, RSI, also dropped GIF support in favor of
PNG.
-David
On Thursday, August 02, 2001 12:53 PM, Ben Forta [SMTP:[EMAIL PROTECTED]] wrote:
Nick, I said GIF on April 22nd, that is an OLD message. At that time GIF
was in there. It was pulled (and replaced with
This makes no sense. Unless you've got an order by clause, there is no order
to the rows, so choosing rows 2-4 is no different than choosing rows 1-3 or
18-20.
Perhaps you want order by personID asc combined with select top 4, and then
ignore the 1st row in the result.
-David
On Sunday, July
It does as of 4.5.1.
See this Forums thread for info on using a CLOB in a query:
http://forums.allaire.com/coldfusion/messageview.cfm?catid=6threadid=
197041
highlight_key=ykeyword1=Oraclekeyword2=LONG
-David
On Tuesday, July 17, 2001 11:25 PM, Smit,Francois
[SMTP:[EMAIL PROTECTED]] wrote:
I saw this at CF Comet, at
http://www.cfcomet.com/cfcomet/Other/index.cfm?ArticleID=F05079C2-EAB3-4B25-
B9EEA9B47F3186F5. Perhaps this covers your situation.
-David
If your object is external to the Web server, use the CONTEXT=Remote
attribute of CFOBJECT as well as the CLSID (class ID)
You can get the CLSID by using Microsoft's OLEViewer, although I guess you'd
have to run the viewer on the machine with the object. Sorry, that's about the
limit of what I know.
-David
On Tuesday, July 17, 2001 5:47 AM, Christopher Olive, CIO
[SMTP:[EMAIL PROTECTED]] wrote:
actually, i
I'll add O'Reilly's Mastering Regular Expressions by Jeff Friedl,
http://www.oreilly.com/catalog/regex/
-David
On Monday, July 16, 2001 9:01 AM, Will Swain [SMTP:[EMAIL PROTECTED]]
wrote:
Excellent, thanks Robert.
I have decided I am going to crack them.
Will
-Original Message-
I can't resist:
Be careful with your calculations, or you'll go the WRONG WAY CORRIGAN.
(See http://www.thehistorynet.com/AviationHistory/articles/2001/0501_cover.htm)
-David
On Wednesday, July 11, 2001 1:41 PM, [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]] wrote:
I have to write a search
If so, that's one good reason to use CGI.SCRIPT_NAME for the form's action
template.
cfform action=#CGI.SCRIPT_NAME# method=post
-David
On Thursday, July 12, 2001 1:48 PM, Lee Moore [SMTP:[EMAIL PROTECTED]] wrote:
I'm assuming that the form is posting to itself since you did not give the
name
There's a little bit on using COM to access PDF info in CF at CF Comet,
www.cfcomet.com/.
The Adobe website has tons of documentation. See chapter 4 of the
Interapplication Communication (IAC) Overview at
http://partners.adobe.com/asn/developer/acrosdk/docs/iac/IACOverview.pdf.
Objects
How about http://docushare.xerox.com/
-David
On Thursday, July 12, 2001 3:29 PM, bajaria aslam [SMTP:[EMAIL PROTECTED]]
wrote:
Hi All,
sorry to post a question that is not related to
coldfusion.
Does anyone know of any mailing list for Docushare (
it is document management software
CF Studio 4.5:
Select the project in the Projects tab.
Select the globe icon.
Right-click and select Delete Project
-David
On Saturday, July 14, 2001 7:29 PM, Lee Fuller [SMTP:[EMAIL PROTECTED]]
wrote:
Has anyone figured out how to remove a project from the drop-down in
Studio, when that
Depends on the database, since most vendors have extensions to standard SQL.
For MS Access, see reserved words in the online Help index. The Oracle SQL
Reference (http://helios.a.tu-berlin.de:8000/wg73-doc/server/sql73/ch201.html)
lists Oracle- and ANSI-reserved words.
-David
On Tuesday,
Chris,
I know of two ways to do this.
1. CFCONTENT and CFHEADER.
As per http://tech.irt.org/articles/js154/index.htm, you can create your MS
Word template and put CFML placeholders in it, save it as an RTF file, edit the
RTF file to get or accept data, and then serve that filled-in file to
Just put a CFQUERY in the link's template:
CFQUERY
update myTable
set Visits = Visits + 1
where companyID = #companyID#
/CFQUERY
Of course, this will be executed whenever this template is called up, whether
by this hyperlink, some other hyperlink, form submittal, or directly. If you
need to
Your insert statement probably looks like this:
, '#myTextareaValue#', ...
Use PreserveSingleQuotes:
, '#PreserveSingleQuotes(myTextareaValue)#', ...
-David
On Sunday, July 08, 2001 6:53 AM, [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
wrote:
I'm having a problem and can't figure out
Create JS Date objects from the user input and then you can use the
greater-than operator.
function validateDates(f) {
var returnVal = true;
var objStartDate = new Date(f.startDate.value);
var objStopDate = new Date(f.stopDate.value);
if (objStartDate objStopDate) {
Alias the sum and then output that alias.
SELECT SUM(racedaylunch) as mySum
cfoutput#exlunch.mySum#/cfoutput
-David
On Monday, June 25, 2001 9:09 AM, Jeff Fongemie [SMTP:[EMAIL PROTECTED]] wrote:
Hello cf-talk,
Why the heck is this throwing an error? Expression result cannot be
converted
Terri,
Here's some code to handle your first question. It disallows selection of any
item whose value begins with xx.
Add this function to the head section:
function checkSelect(e) {
// Disallow selection of items whose value begins xx
for (var i=0; i e.options.length; i++) {
if
As Mark pointed out, it's bad design to store a list in a field.
This will work in MS Access (using the sample Northwind database that comes
with it):
SELECT Customers.ContactTitle,Employees.Title
FROM Customers, Employees
WHERE InStr(ContactTitle,Title) 0;
In this example, ContactTitle
Ken,
Can you provide details? The following code works OK. It's not because you're
from Florida, is it? ;)
-David from NY and CA
!--- Make a WDDX packet ---
cfset myString = abc'def
cfwddx action=CFML2WDDX input=#myString# output=myStringWDDX
!--- Pass the packet in a form ---
form
With SQL Server 2000, you can retrieve query results directly in XML. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_o
penxml_1hd8.asp and the links under it in the toc.
-David
On Monday, June 25, 2001 10:26 PM, Ryan Sabir [SMTP:[EMAIL PROTECTED]] wrote:
What if you use CFOBJECT ACTION=connect?
-David
On Friday, June 22, 2001 Jordan Saardchit [SMTP:[EMAIL PROTECTED]] wrote:
Does anyone know how to call a static method as opposed to calling the
constructor to instantiate an object using CFOBJECT? I've got a
Singleton object that I am trying
David,
You got that error because Excel is not registered on your server. Assuming
that Excel is in fact installed on your server, you can register it by
following the directions at
http://www.cfcomet.com/cfcomet/Other/index.cfm?ArticleID=32381637-0922-41CA-
BBE305C2D66A7025#2.
Note that
You are populating GradesForPDF in a query loop, so CurrentRow is available.
But are you filling in the FDF in a loop? Can't tell from your code snippet,
but you should be doing something like this:
CFLOOP FROM=1 TO=#GetGrades.RecordCount# INDEX=i
/FDF /Fields [ /V (#GradesForPDF[i][1]#)/T
Here's a method from David Flanagan's JavaScript: The Definitive Guide, 3rd
Edition, Example 16-2, Performing Form Validation,
http://examples.oreilly.com/jscript3/text/16-2.txt
-David
script language=JavaScript1.1
function verify(f)
{
var msg;
var empty_fields = ;
var errors = ;
Jaime,
Are you using stored procedures? See
http://www.allaire.com/Handlers/index.cfm?ID=18372Method=Full
-David
===
Jaime Hoi will have written:
did anyone encounter this error in CF before?
Oracle Error Code = 604
ORA-00604: error
I'm not running 5.0, but Dain Anderson pointed out to me that the order of the
arguments to CreateObject has changed.
Beta 3:
objWord = CreateObject(COM, Word.Application, Local);
RC1:
objWord = CreateObject(COM, Local, Word.Application);
It also may be that looping over collections sometimes
Please explain exactly what you're after.
-David
On Wednesday, June 13, 2001 7:31 PM, David Clay [SMTP:[EMAIL PROTECTED]]
wrote:
Need Help. I am looking for code to be able reselect the options on a
multiple
select form field for and edit page.
It's on the main page. Scroll down to ColdFusion in Context: Augmentation of
Automatic Javascript in that light-green box.
-David
On Sunday, June 10, 2001 10:47 PM, Zac [SMTP:[EMAIL PROTECTED]] wrote:
On Sunday, June 10, 2001, at 09:54 PM, Kay Smoljak wrote:
An interesting discussion of
Sure. Do a CFDIRECTORY ACTION=LIST NAME=qPDFs FILTER=*.pdf on the PDF
files in that directory, and then you've got access to the size of each as
qPDF.Size
-David
On Monday, June 11, 2001 3:37 AM, Steve Vosloo [SMTP:[EMAIL PROTECTED]]
wrote:
Is there any way to dynamically display the size
Seamus,
Option #1: Simply delete everything in the database and then add everything in
the new group list. No need for updates. You can get away with this because
the new group list contains all of the fields (i.e. 2) in the database table,
if I read you right.
Option #2: Remove items
An article on getting at Exchange data via LDAP can be found at
http://www.cfcomet.com/cfcomet/Exchange_Server/index.cfm?ArticleID=F6CAD377-
4023-4EB0-8C52340ED1DF4263
-David
On Thursday, June 07, 2001 11:53 AM, Smith, Daron [SMTP:[EMAIL PROTECTED]]
wrote:
Does anyone have experience using
I just created a task in Outlook 97 and exported it as a CSV file. Then I
deleted the task and imported the CSV file into Outlook. It worked fine. So
you can just create a variety of dummy tasks and export them, and study the
format of the exported file.
Creating a CSV file from CF is no
I should've also mentioned that Outlook's on-line help describes the file
format. In the index, see tasks and then sub-topic standard fields.
-David
On Thursday, June 07, 2001 10:23 PM, David Shadovitz [SMTP:[EMAIL PROTECTED]]
wrote:
I just created a task in Outlook 97 and exported
At the top of the page do this to create a list of all existing QuestionID's:
cfquery name=qQuestionIDsselect QuestionID from Questions/cfquery
cfset QuestionIDs = ValueList(qQuestionIDs.QuestionID)
Let's say you are currently at QuestionID = 3:
cfset QuestionID = 3
In the body, loop over
For Oracle:
select table_name from all_all_tables
all_all_tables describes tables accessible to the current user.
user_all_tables described tables owned by the current user.
Oracle 8i reference:
http://www-wnt.gsi.de/oragsidoc/doc_816/server.816/a76961/toc.htm
-David
On Friday, June 08,
Sebastion,
The code below should do it. Note that this method (both your version and
mine) will choke if the keyword list contains pan or coldfusion,fusion
because of interference between the replacement of a string and the added
span text, or between the replacement of one string and the
You can use this code to examine your form field string. Change myString to
your variable.
table
trthIndex/ththCharacter/ththASCII/th/tr
cfloop from=1 to=#Len(myString)# index=iChar
cfoutputtrtd#iChar#/tdtd#Mid(myString,iChar,1)#/tdtd#Asc(
Mid(myString,iChar,1))#/td/tr/cfoutput
Look into Access' FORMAT function. For operating on dates, it is similar to
DatePart, but you can use a mask such as mmm d to grab the entire date
part of a date/time field.
SELECT Format(myDateTimeField, mmm d ) AS myDate ...
-David
On Monday, May 28, 2001 11:13 PM, Mark Leder
Does it throw any particular error that perhaps you'd like to share?
On Thursday, May 31, 2001 9:41 AM, Tracy Bost [SMTP:[EMAIL PROTECTED]] wrote:
The code below throws an error whenever I try to run it... What am I doing
wrong ?
Thanks in Advance...
CFQUERY name=getproducts
What if you use date/time objects rather than strings? See CreateDateTime.
-David
On Thurs May 31 2001 JAIME HOI [SMTP:[EMAIL PROTECTED]] wrote:
i realised that the date format function is not very accurate. For
example, the below code will return me true, when in fact it should be
false.
Or perhaps it's your File Settings. Under Options | Settings | File Settings,
you can specify the Format when saving to be either PC, Mac or UNIX. If
you've got it set to PC and you're saving to a UNIX machine you'll get the
extra line.
-David
On Wednesday, May 30, 2001 7:46 AM, Will Swain
Here's one place: http://telecom.fit.edu/cfdocs/index.htm
Sorry if this is response #43.
-David
On Sunday, May 27, 2001 12:24 AM, Paul Hastings [SMTP:[EMAIL PROTECTED]] wrote:
* Team Allaire *
anyone know where i can find a copy of the
I should have said to click on User Guide and then on Java Graphlets in the
left-side nav bar.
-David
On Sunday, May 27, 2001 12:53 AM, David Shadovitz [SMTP:[EMAIL PROTECTED]]
wrote:
Here's one place: http://telecom.fit.edu/cfdocs/index.htm
Sorry if this is response #43.
-David
On Sunday
Dunno why you can't replicate the error, since I don't know how UserID is
generated.
But you should just check for (REQUEST.GetClientData.UserID GT 0) AND ...
-David
On Thursday, May 24, 2001 5:48 AM, Paul Smith [SMTP:[EMAIL PROTECTED]]
wrote:
UserID will always be provided, 0 if the user has
Sure. O and 1 are boolean values, but 3 ain't.
What is it you want to check? Whether a UserID is provided?
-David
On Wednesday, May 23, 2001 11:56 PM, Paul Smith [SMTP:[EMAIL PROTECTED]]
wrote:
Is it expected behavior that the error below DOES NOT occur when
REQUEST.GetClientData.UserID=1
Change cfparam name=ReturnCode default=0
to cfset ReturnCode=0
-David
On Thursday, May 24, 2001 1:09 AM, Mark [SMTP:[EMAIL PROTECTED]] wrote:
Hi Ben,
Thanks for the explanation!! The code works great
on the first field (mailone), but then doesn't check
any of the remaining fields. It
Here's a page with late changes and additions to the CF Server and Studio
documentation:
http://www.allaire.com/documents/cf45docs/cfupdate.htm
I've long been bothered by the inability to maintain horizontal cursor
position in Studio. Didn't know that Studio has addressed this.
The
Not yet, but soon. You pioneer and I'll follow ;)
-David
On Friday, May 18, 2001 Reed Powell [SMTP:[EMAIL PROTECTED]] wrote:
Anyone out there doing any sort of integration with the LiveLink document
management product from OpenText?
~~
Good luck!
Brian
At 06:29 AM 05/16/2001 -0400, you wrote:
Date: Tue, 15 May 2001 19:28:54 -0700
From: David Shadovitz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: OT: Flash 5 Player for IE
Message-ID: [EMAIL PROTECTED]
I work on a secure intranet, with no access to the internet
You might not have to live with it. If you use CFHTMLHEAD to write the correct
function, it will be used in lieu of the CF-generated function since it will
follow (and hence overwrite) the CF-generated one.
Not pretty, but it works.
-David
On Wednesday, May 16, 2001 3:49 PM, Jann VanOver
I work on a secure intranet, with no access to the internet. In order to use
Harpoon (MMFCKCF just doesn't sound nice) I need the Flash 5 Player. The
problem is that when you're using IE, Macromedia doesn't offer the chance to
download an installer like it does when you're using Netscape.
I use this code to examine a string:
cfset myString = vffbbfbvf
String: cfoutput#myString#/cfoutputp
table
trthIndex/ththCharacter/ththASCII/th/tr
cfloop from=1 to=#Len(myString)# index=iChar
cfoutputtrtd#iChar#/tdtd#Mid(myString,iChar,1)#/tdtd#Asc(
So it's not just me!
Try using the same accept value in your input type='file' tag.
-David
On Monday, May 14, 2001 5:42 AM, Darren Daniel
[SMTP:[EMAIL PROTECTED]] wrote:
I've got this piece of code to limit the the type of file that is uploaded,
but it doesn't seem to work, it still allows
You may want to read KB article 16259, Best Practice: Enabling Retrieval of
Long Text Fields with CF 4.5,
http://www.allaire.com/Handlers/index.cfm?ID=16259Method=Full
-David
On Friday, May 11, 2001 9:31 AM, FARRAH NG [SMTP:[EMAIL PROTECTED]] wrote:
I have defined a column as CLOB in an oracle
According to the documentation, MessageInfo is not a string, it's an array, so
#aKey.MessageInfo# won't work. Unfortunately I do not have that object on my
machine, so I cannot experiment.
-David
On Friday, May 11, 2001 4:03 AM, Per Kleven [SMTP:[EMAIL PROTECTED]] wrote:
-Original
Don't know whether this helps, but a web search turned up:
SQL 7008N REXX variable variable contains inconsistent data.
Explanation: A variable that contained inconsistent data was passed to REXX.
The command cannot be processed
User Response: If the variable is an SQLDA, verify that the data
Don't try to change a loop index.
Use a CASE tag to take care of the cases for which an action is required, as
you do for VALUE=1. Don't provide a CASE tag for the values for which no
action is required.
And don't forget the pound signs around the expression:
EXPRESSION=#insert_counter#
ListPosition is 0 because ListFind looks for a matching *element*, not a
matching *string*. Use ListContains if you want your search for 1 to return
the index of the 1st element which contains a 1.
-David
On Monday, May 07, 2001 10:52 PM, Joshua Tipton [SMTP:[EMAIL PROTECTED]] wrote:
Why any
I'm no longer receiving CFDJList mail. It looks like they switched over to an
on-line forum. Is it possible to get posts via email?
Thanks.
-David
~~
Structure your ColdFusion code with Fusebox. Get the official book at
Hubert,
If NEWRECORD is YES, your code does only a CFSET. Your page is blank because
there's no HTML code in this case.
-David
On Sunday, May 06, 2001 6:36 AM, Hubert Earl [SMTP:[EMAIL PROTECTED]]
wrote:
Hi,
Thanks for the feedback. Strangely enough, the source shows *none* of my
code.
Aack!
This is a classic many-to-many relationship, best represented by 3 tables:
Table Users (userid, username, other user info)
Table Groups (groupid, groupname, other group info)
Table UsersGroups (userid, groupid)
-David
On Sunday, May 06, 2001 9:38 AM, Michael Lugassy [SMTP:[EMAIL
Let me add to the excellent advice already given:
* Show the code to another programmer (aka peer review)
* Read a good book on general programming practices, including debugging.
One such book is The Practice of Programming by Kernighan Pike. Here are
some section titles from chapter 5,
I'm reposting this. Anyone use Visual SourceSafe (VSS) for more than just
check-in/check-out?
-David
-Original Message-
From: David Shadovitz [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 8:15 PM
To: 'CF-Talk'
Subject:OT: VSS versioning
Our network
And CFSCRIPT from start to finish in the What's New section of
http://www.houseoffusion.com
-David
On Friday, May 04, 2001 11:40 PM, Raymond B. [SMTP:[EMAIL PROTECTED]]
wrote:
http://www.allaire.com/cfdocs/Developing_Web_Applications_with_ColdFusion/20
Concatenation is like this:
select fname+' '+lname as name
But you're using name in the where clause. Is it a field? If so, select name.
If not, modify your where clause.
Also, you're not joining the Users and Vehicles tables.
-David
On Thursday, May 03, 2001 12:49 PM, Angel Stewart
1. Just edit the default template. In your CF Studio folder, it's in Wizards \
HTML and it is called Default Template.htm
2. Options | Settings | HTML tab, then uncheck Lowercase all inserted tags.
-David
On Thursday, May 03, 2001 10:08 AM, Hubert Earl [SMTP:[EMAIL PROTECTED]]
wrote:
Hi,
The new issue of Oracle Magazine has an article Life with Linux: Six Steps for
a Seamless Oracle Install. In addition to the article itself, it contains
many good references.
http://www.oracle.com/oramag/oracle/01-may/index.html?o31linux.html
-David
Our network administrator finally installed VSS, and I've successfully hooked
it into my existing CF Studio projects. But VSS looks pretty limited compared
to what I've used on UNIX systems. (Heck, CMS on the VAX beats it.) I expect
a source control tool to tell me which version of which
*** Team Nobody ***
In CF Studio's Extended Find dialog, if you set Find where to In folder,
you can restrict the search to certain file types. For example, one group of
file types is {*.htm;*.html;*.cfm;*.cfml}.
I'd like to create my own group
a search on that file type, and the next time you do an
Extended Find, that file type will display in your drop-down list.
-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 1:01 PM
To: CF-Talk
Subject: Studio - File types
I have no code for it, but you can use CFOBJECT. The Document class has a
BuiltInDocumentProperties object. Following is what VBA's help says. (And you
can check http://www.cfcomet.com/cfcomet/word/ for help on using CFOBJECT with
Word.)
-David
Using the DocumentProperty Object
Use
Thanks to Bruce H. and John W. as well.
-David
On Tuesday, May 01, 2001 12:02 PM, David Shadovitz [SMTP:[EMAIL PROTECTED]]
wrote:
Nicole,
Wonderful! Thanks.
-David
On Tuesday, May 01, 2001 11:04 AM, Nicole Ambrose [SMTP:[EMAIL PROTECTED]]
wrote:
You can type the file type directly
Peter,
You make two queries, one for the events for which the user has already signed
up, and the other for all events. Populate the select element by looping over
the all-events query. Use CFIF to see if the current event is in the list of
events for which the user has already signed up.
That should do it. Just wanted to mention that you could also try
GROUP BY DATEPART(m,myDateField)
-David
On Tuesday, May 01, 2001 5:05 PM, Bob Silverberg [SMTP:[EMAIL PROTECTED]]
wrote:
Try:
SELECT MONTH(myDateField) As myMonth FROM ... in your SQL statement. That
should return a
*** Team Nobody ***
Jeff,
If you're using Oracle, look into the CONNECT BY clause, explained well at
http://www.arsdigita.com/books/sql/trees.html
-David
On Saturday, April 28, 2001 1:23 PM, Jeffry Houser [SMTP:[EMAIL PROTECTED]]
wrote:
I
Something like
WHERE Users.UserId IN (#ListQualify(form.NOTIFY,')#)
And then
cfset Dear = ValueList(Users.Username)
-David
On Thursday, April 26, 2001 6:48 AM, [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]] wrote:
This works great if only one choice is selected. But it chokes on multiple
Bud,
I'm replying off-list, since I lost track of whether you got any response. I'm
slow at getting through all of my CF-related email.
Here's the MSDN page listing SQL Server 2000 ODBC error messages:
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/tr_err_o
dbc_5stz.htm
Make that "on-list". Fingers, don't fail me now!
-David
-Original Message-
From: David Shadovitz [SMTP:[EMAIL PROTECTED]]
Sent: Saturday, April 21, 2001 11:39 PM
To: CF-Talk
Subject:RE: SQL Server ODBC Errors
Bud,
I'm replying off-list, since I lost track
CF Studio's Files tab displays the Name, Title, Size, Modified and Type of each
file. When displaying this info for files on an FTP site, what controls the
timezone of the "Modified" field? It's determined by the FTP server, right?
Thanks.
-David
Is "Function" really uppercase in the CFINCLUDE file? That'd do it.
-David
On Friday, April 20, 2001 4:06 PM, Bruce, Rodney [SMTP:[EMAIL PROTECTED]]
wrote:
Help
Why would JS work when its on a page between
SCRIPT tags, but when I take the same code and copy it to separate page,
and use
it
in case anyone else is bitten by the same problem.
-David
On Friday, April 20, 2001 5:45 PM, David Shadovitz [SMTP:[EMAIL PROTECTED]]
wrote:
Is "Function" really uppercase in the CFINCLUDE file? That'd do it.
-David
On Friday, April 20, 2001 4:06 PM, Bruce, Rodney [SMTP:[EMAIL
It's because you have
?user=#Trim(list.username)#
as part of the form's action. Eliminate this. Instead, the action page should
use Form.username.
-David
On Wednesday, April 11, 2001 7:36 AM, James Taavon
[SMTP:[EMAIL PROTECTED]] wrote:
I am not sure why I can't figure this out, I
The tag gallery has cf_breadcrumb and cf_breadcrumbtrail. Do a search on
"breadcrumb" at http://devex.allaire.com/developer/gallery/
-David
On Friday, April 13, 2001 4:38 AM, Earl, George [SMTP:[EMAIL PROTECTED]]
wrote:
Does anyone know of a source for a good example of using CF code to
Another option would be to make a query to retrieve all of the table names.
You could store the resulting list in the app scope. Then, when you
dynamically construct the table name for a given month, check to make sure it
is in the list of tables before running the query to get the month's
Let me add some notes on the TOP predicate as implemented in MS Access.
1. If you don't include an ORDER BY clause, a TOP N query will return an
arbitrary set of N records that satisfy the WHERE clause.
2. You may get more than N rows from a TOP N query, since TOP does not choose
between
CF Studio's Database tab shows my Oracle data source's Tables, Views, Queries
and Synonyms. Is there any way that I can have it show my user-defined Oracle
functions?
Thanks.
-David
~~
Structure your ColdFusion code with Fusebox. Get the
I think many CF programmers have abandoned CFTREE in favor of JS/DHTML trees
precisely because Allaire did not provide access to CFTREE's onclick event.
However, it is possible to trap the CFTREE form submittal and get at the
selected node. Here's one way:
* Add a 2nd submit button to the
I'm looking for suggestions:
My intranet app lets users construct a SQL query. I want to guard against
queries which would swamp the system by returning too much data. My plan is to
cap the number of rows that a query can return. Sure, a row may contain many
fields or few, but it's
ctly legal (I'm not sure if it's standard SQL-92
or not).
So you could first check for SELECT DISTINCT and if that exists, replace it
with SELECT DISTINCT COUNT(*) [as whatever]
Mike.
-Original Message-----
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 20
it worked
|-Original Message-
|From: David Shadovitz [mailto:[EMAIL PROTECTED]]
|Sent: Tuesday, April 03, 2001 10:35 PM
|To: CF-Talk
|Subject: Limit Query Results
|
|
|I'm looking for suggestions:
|
|My intranet app lets users construct a SQL query. I want to
|guard against
select count(distinct type) from dbo.titles
gives me a number equal to the number of rows that
use pubs
select distinct type from dbo.titles
would return. Am I still not getting this?
-Original Message-----
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday
AND ID NOT IN #CLIENT.TROLL#
(The RDBMS will translate IN into multiple OR statements and NOT IN into
multiple AND statements.)
-David
On Sunday, April 01, 2001 9:48 AM, W Luke [SMTP:[EMAIL PROTECTED]] wrote:
Hello.
I'm trying to exclude an ID from the WHERE in a query, by looping through a
1 - 100 of 350 matches
Mail list logo
