http://www.cfm-resources.com/cflanguage.cfm?lang_id=70
also:
search results for all forums cfstoredproc:
you have a lot of options really.loop over the list, stick it into a table var or temp table, and do a subselect.play around with it.
(not u neil :P)
-Original Message-
From: Robertson-Ravo, Neil (RX)
To: CF-Talk
Sent: 3/2/04 11:07 AM
Subject: RE: SQL Stored Proc
Two things,
Modify the
your code should work, because your passing in a
string, and using it as the comma seperated list
in an IN clause
no, you have to go to dynamic sql strings for an in clause.
http://www.sqlteam.com/item.asp?ItemID=4599 (follow to part ii, i think it had more)
though, the author came up with
I have a few public folders on an exchange server that I am trying to pull into a db and create a front end to access, allowing viewing and searching and the like.I know outlook allows this kind of functionality, but we need to move it to a web interface.I also want to allow them to continue
this time.
Thanks, Jochem.
Matthew
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 3:42 PM
To: CF-Talk
Subject: Re: tapping an exchange public folder and extracting messages
Smith, Matthew P -CONT(CSC) wrote:
I have a few
all your stuff from the web
- Original Message -
From: Smith, Matthew P -CONT(CSC)
To: CF-Talk
Sent: Thursday, February 19, 2004 3:37 PM
Subject: tapping an exchange public folder and extracting messages
I have a few public folders on an exchange server that I am trying to pull into a db
Thanks, Paul.Look tight; I'll definitely give it a whirl.
(it can't be THAT easy, can it?):-)
Cheers,
Matthew
-Original Message-
From: Paul Vernon [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 4:05 PM
To: CF-Talk
Subject: RE: tapping an exchange public folder and
I don't believe so.If you are using a db that supports multiple SQL comands in onf cfquery tag, you could:
1.do a select instead of the update first
2.set an int(say, @myRowcount to @@rowcount
3.run your update
4.return @myRowcount AS RecordsUpdated
This is off the top of my head and there might
as long as you are using a db that supports multiple sql statements per cfquery tag, you really aren't killing your db that bad.move it to a stored proc and you are really g2g.
I had an app using a self-referncing table that had to do ton of recursive loops with recordsets looping and doing a
did you import to the proper jvm?I had to do this for navy issued certs, and it worked fine.I do not know if there are different keystores for each jvm you might have on there, or if you would have to be sure that you are importing the CA to the proper JVM if the latter is true.
If you find a
onFocus(blur)
?
(or something similar, I didn't have time to look it up.
I've used that a couple times.
Though disabling _javascript_ would allow them to type it in
Matthew P. Smith
Web Developer, Object Oriented
Naval Education Training Professional
Development Technology
Environment:
*/*/*/*/*/*/*/*/*/*/**/*/*/*/*/**/*/*/*/*/*
ColdFusion Server Developer 6,1,0,63958
IIS 5.0
WIN2K
*/*/*/*/*/*/*/*/*/*/**/*/*/*/*/**/*/*/*/*/*
:P
I just did a clean install of MX, removing the CF5 to IIS and MX to its standalone server, now having MX on port 80 and using IIS.
I'm
I'm doing a scheduler app for our intranet.
I have a little problem, nothing major, but I thought I would shoot it out here before I get all jiggy with the date functions.Basically, I want the view to default to the current week.So using the now() function, I need to find the, say, Sunday
Error Occurred While Processing Request
The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.
Null Pointers are another name for undefined values.
cfset tmpDate.day = datePart(d, getDates.startTime)
Thing is,
I am trying to browse to a cfc I am playing with, not passing any method or anything else.The server relocates me to /CFIDE/componentutils/cfcexplorer.cfc?method=getcfcinhtmlname=foo.verifypath=/foo/verify.cfc
And prompts me for the rds or admin password.After entering it, it sends me to the
Clean MX install
I currently have CF 5.0 tied into IIS and MX using the standalone server on my development box at home.I would like to do a clean install of MX using IIS, removing both of the two previous installs.Besides the uninstall in Add/Remove programs, is there anything I need to do to
We had some timeout issues with the first version of CFMX and its default jvm.(I believe the default jvm had a known issue with timing out https requests)After a few posts here and the macromedia forums, I came away with the understanding that the timeout does NOT apply to external processes,
Yes, and there is also Netigrity.
http://www.netegrity.com/ http://www.netegrity.com/
I believe(don't quote me on this) that oblix had better certification for government security requirements.It does not necessarily mean that Netegrity is less secure, they just haven't done the required
Jochem,
Just use the system with a recording proxy and see for yourself.
Could you recommend one?I'd like to delve a little deeper with the stuff we are using here.
Also, could you(or anyone else) recommend a good http sniffer?I'm not sure if they are the same thing, but I would like to
-1001 ext. 1245
[EMAIL PROTECTED]
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, December 12, 2003 9:35 AM
To: CF-Talk
Subject: Re: Single Sign On (implemented in CF)
Smith, Matthew P -CONT(CSC) wrote:
Just use the system with a recording proxy
Thank you, Dave.I'll give them all a try and see which is the easiest to pick up.I appreciate the pointer.
Matthew P. Smith
Web Developer, Object Oriented
Naval Education Training Professional
Development Technology Center
(NETPDTC)
(850)452-1001 ext. 1245
[EMAIL PROTECTED]
I've been doing the CF and IIS portions of Oracle SSO implementation here.I have a meeting but I'll look over this and offer any help I can when I get a chance.
Matthew P. Smith
Web Developer, Object Oriented
Naval Education Training Professional
Development Technology Center
(NETPDTC)
I had some trouble getting QofQ to work with bit data types way back when.I don't think we ever resolved it and just went to tinyint in the db.Has anyone ever gotten bit datatypes to work in QofQ?Is there some work around?
Thanks,
-Original Message-
From: Jochem van Dieten
Either place your security invocation only in the fbx_settings of the circuit(s) you want to protect, or place conditional logic in the root fbx_settings looking at the fusebox.circuit variable, invoking if the final target circuit is one you want to protect.
Matthew P. Smith
Web Developer,
You can reference across dbs
db1..table.column is the syntax I think.That should plug in any query as needed; I think you can alias it to keep things clean as well.
-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 1:51 PM
To: CF-Talk
I'm sure cf has a function for that, but I believe using a list in a IN clause in a stored procedure requires the use of dynamic sql strings.
http://sqlteam.com/item.asp?ItemID=4619 http://sqlteam.com/item.asp?ItemID=4619
This refers to int keys; I don't know if UUIDs would require a
Doesn't the use of cfqueryparam stop injections like that?
Matthew
-Original Message-
From: Jim Campbell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 8:28 AM
To: CF-Talk
Subject: Re: To MAXLENGTH or not that is the question?
Isn't the whole point of maxlength to
Interesting, the CF5 WACK has a good chart, but I couldn't find one in the MX book.It seems odd that they would leave that out.Would there be any differences between the two versions of cf?
If you have access to the CF5 book, it's page 1037.
-Original Message-
From: Tom Kitta
I also discovered that CF_SQL_Numeric does not correspond to MS SQL Server
Numeric type, it is closer to an integer as it killed my decimal point
(rounds down to the closest integer).
CF_SQL_DECIMAL = numeric, decimal
CF_SQL_NUMERIC = numeric, decimal
CF_SQL_MONEY seams to work fine --
Won't the cf engine finish the entire requested template regardless of whether or not the browser/user is still there waiting for it?How does it know to stop?
-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 2:24 PM
To: CF-Talk
Subject: RE:
http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=6 http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=6threadid=684306highlight_key=ykeyword1=No%20more%20data%20available%20to%20read threadid=684306highlight_key=ykeyword1=No%20more%20data%20available%20to%20read
What is the best way to duplicate an entire SQL server from one instance to another?I'd like to pull our production db's from our live sql server to a new dev instance.I'd rather not kill the sql service to unlick the files.
Off the top of my head, I could:
1.dts db by db
2.copy mdfs/ldfs and
Isn't it .., as in
SELECT tb1.id, tb2.name
FROM db1..table1 tb1, db2..table2 tb2
?
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 12:22 PM
To: CF-Talk
Subject: Re: SQL SP
Hi all
Hope someone can help me with this:
How can I tell a
Check your rules if you're in outlook. They sometimes get funky.
-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 4:28 PM
To: CF-Talk
Subject: OT: Dupes From List
Howdy,
Anyone else receiving dupes on this list? Since switching
What is application.cfm defaulting it to? Perhaps the default value you are setting
is not a valid query/structure?
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 8:55 AM
To: CF-Talk
Subject: Why am I getting this not an available
data...loops query...all runs fine today.
But the code below keeps giving that error... :o(
Rick
-Original Message-
From: Smith, Matthew P -CONT(CSC)
[mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 9:49 AM
To: CF-Talk
Subject: RE: Why am
No, then cf will try to resolve the variable as the name of the query and you'll get:
Complex object types cannot be converted to simple values.
Am I correct?
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 9:24 AM
To: CF-Talk
Subject:
SET NOCOUNT ON for the first select?
-Original Message-
From: Reece, Cynthia [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 1:51 PM
To: CF-Talk
Subject: RE: stored procedure doesn't return anything
Hello,
I am trying to run a stored procedure from coldfusion and return
Alternatively, set the procresult to the second record set
cfprocresult name=dr_select resultset=2
Here's the SP with the NOCOUNT mod; use one or the other solution:
!-- stored procedure --
CREATE PROCEDURE sp_doctorsearch (@zipcode INTEGER, @radius INTEGER)
AS
SET NOCOUNT ON
39 matches
Mail list logo