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 and OLEDB
actually yes I have figured this out with help from another list. With OLEDB
you have to 'SET NOCOUNT ON'. The reason is that OLEDB returns a record
count first, and then the dataset second by default. If you set nocount on,
it returns the dataset without the record count.
---------- Original Message ----------------------------------
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 months without
experiencing this, but just now, all of the sudden, the same thing is
happening to me.
<cfquery name="qryTest" datasource="#request.DSN#">
Exec GetTransferEmailData @TransferId=#Val(URL.TransferId)#
</cfquery>
returns no records, but
<cfquery name="qryTest" datasource="#request.ODBCDSN#">
Exec GetTransferEmailData @TransferId=#Val(URL.TransferId)#
</cfquery>
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 [mailto:[EMAIL PROTECTED]]
Sent: March 30, 2001 3:39 PM
To: CF-Talk
Subject: RE: Stored Procedures and OLEDB
I get a CF error that tells me that query 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: Fri, 30 Mar 2001 15:27:36 -0500
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 problems calling stored procedures with CFQUERY using an
OLEDB DSN?
I changed my DSN from ODBC to OLEDB and now anytime I call a stored
procedure, CF acts like my query isn't there.
Any help is appreciated.
--
Clint Tredway
www.factorxsoftware.com
--
--
Clint Tredway
www.factorxsoftware.com
--
---------- Original Message ------------------------
From: "Bob Silverberg" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 30 Mar 2001 15:27:36 -0500
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 problems calling stored procedures with CFQUERY using an
OLEDB DSN?
I changed my DSN from ODBC to OLEDB and now anytime I call a stored
procedure, CF acts like my query isn't there.
Any help is appreciated.
--
Clint Tredway
www.factorxsoftware.com
--
---------- Original Message ------------------------
From: "Benjamin S. Rogers" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 30 Mar 2001 14:27:38 -0500
Not to discourage you from starting an open source project, but there are
already several in the works. Allaire Forums was open sourced and can be
found at http://www.forumspot.org. There is also Simple Message Board, which
can be found at http://www.simplemessageboard.com/.
You may want to investigate these products and consider throwing your effort
at one of these products instead of starting a new one.
Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057
-----Original Message-----
From: Chris Straight [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 2:17 PM
To: CF-Talk
Subject: RE: Cold Fusion Forums
>From what I understand People are looking for a feature rich forum system
that is cheap and customizable. What about an Open Source Project. I am very
willing to contribute my time and effort as well as code that I have been
working on to create a free to use and modify Forum System. It seems to be
needed. I want to see how many people would be interested in working on such
a thing?
Chris Straight
Web Developer
University of Oregon Bookstore, inc.
http://www.uobookstore.com/
(541) 434-3274
-----Original Message-----
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 1:23 PM
To: CF-Talk
Subject: RE: Cold Fusion Forums
(she hesitates to post to this board....fear of igniting the flames of the
forum gods.....)
What about the bare-bones-bboard found on allaire.com/developer ? I know
it's not exactly feature rich, but as far as a simple threaded messageboard
is concerned, I've been able to integrate it fairly well for a couple of
different clients, massaging the look and feel as I see fit. You have to add
your own login capability if you need it, but it does send emails to the
person posting the message if they choose to receive notification.
It's small, open-source, and free!
There is always the option of writing it yourself....and webmonkey gives you
a tutorial on how if you need it....of course there's always that time issue
thing.... :-)
Cheers,
(did she get away unscathed....)
Erika
--------------------------------
AIM: WebErika5
Yahoo: WebErika
MSN: WebErika
AskMe.com Expert: WebErika
--------------------------------
Erika L. Walker
Vice President
RUWebby, LLC
201-370-4272 (c)
973-244-9120 (o)
153 Rutgers Lane
Parsippany, NJ 07054
--------------------------------
Website Design/Programming
Database Integration
Allaire Partner - ColdFusion
--------------------------------
-----Original Message-----
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 3:58 PM
To: CF-Talk
Subject: RE: Cold Fusion Forums
> I have yet to find a Forum application that fits these and many other
> requirements. Many seem to lack a "multi-threaded" veiw. FuseTalk, for
> example doesn't seem to have a multi-threaded view. All responses on a
> certain subject appear in the order they were posted with no hint as too
> which message is being directly replied to. This behavior is more like a
> mailing list than a forum.
(Here I go again. ;p)
SMB has the option of viewing all threads in a tree-view or in a
thread-view. For example:
Like this:
http://www.simplemessageboard.com/demo/thread.cfm?TID=1030&Expand=NO
Or Like this:
http://www.simplemessageboard.com/demo/thread.cfm?TID=1030
> Simple Message Board - http://www.simplemessageboard.com/
> Price: Free?
Yes. Free. GNU Public License.
> Pros: Price; Clean Design that will fit into most sites without much
> customization
Thanks you. ;p
> Cons: One man operation; Still in pre-release stages
True enough. The current release is functional except for the lack of some
adminstration function.
I've gotten some help on both a version that runs on CFExpress as well as
changes for MySQL... (Linux hooray!)
Tony Schreiber, Senior Partner Man and Machine, Limited
mailto:[EMAIL PROTECTED] http://www.technocraft.com
http://www.linktoss.com _______The Fastest Way to Send a Link to Anyone!
http://www.digitacamera.com ______________DigitA Camera Scripts and Tips
http://www.is300.net ___________The Enthusiast's Home of the Lexus IS300
http://www.cfug-sfl.org ___________South Florida Cold Fusion Users Group
http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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: http://www.houseoffusion.com/index.cfm?sidebar=lists
