stored procedure - Ambiguous column name

*** - Greg Jordan Certified ColdFusion Developer Web Project Manager [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http

RE: stored procedure - Ambiguous column name

no -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:21 AM To: CF-Talk Subject: RE: stored procedure - Ambiguous column name i've been trying to work this out for about a week and i am stumped. i keep getting an error related to an

RE: stored procedure - Ambiguous column name

that you are passing through categoryJobDescrID as one of the fields in @orderby without a tablename prefix. Regards Stephen - Original Message - From: Greg Jordan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 3:41 PM Subject: stored procedure - Ambiguous

record session timeout

We have a login app on our intranet which creates a session and records the time/date it was created. Besides using a logout app to record when the session is ended/deleted by the user, is it possible to record when a session is timed out? Thanks Greg --- [This E-mail scanned for viruses by

RE: CF VS ASP - let the trolling being

here is an article from pcmagazine comparing a slew of web applications servers/languages... http://www.pcmag.com/article/0,2997,s=1611a=3125,00.asp The real question for me would be WHY ON EARTH would your current employer switch to ASP if you don't have any experience with it and they are

RE: XML news feed

mojam http://www.mojam.com/affl/index.html -Original Message- From: Shawn Kernes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 3:41 PM To: CF-Talk Subject: RE: XML news feed Anyone know of a feed that provides news on live events, like concert tours? -Original

in need of CF training docs

I am going to be training 3 VB programmers at my work on how to use ColdFusion 5, and before I make up my own tutorial, I was wondering if anyone had any training docs. Any advice on a training method or approach is welcome as well. Thanks! Greg

RE: executing a dts package

maybe not the fix you were looking for...but you could execute it from CF. www.cfcomet.com has an article by Simon Horwith that steps through this method... http://www.cfcomet.com/cfcomet/SQL_Server/index.cfm?ArticleID=A51CB8F7-C297- 4E80-92CC7A8907B0A5B2 -Original Message- From:

RE: Neo information on Macromedia.com

i went to devcon 2000 in DC and the word was (if I recall correctly, from j allaire) NEO in the 1st half of 2002. Does anyone know if this is still the target release date? or maybe when to expect the beta? Greg Jordan Macromedia Certified

RE: Neo information on Macromedia.com

wow. read and understood that when you originally posted the link. thought maybe you might have just a little more insight, but I guess you don't. thanks heaps phil. Greg Jordan Macromedia Certified ColdFusion 5 Developer Web Project Manager [EMAIL

RE: SQL Book

for t-sql i recommend The Guru's Guide to Transact-SQL ISBN 0-201-61576-2 Greg Jordan Macromedia Certified ColdFusion Developer Web Project Manager [EMAIL PROTECTED] Unified Health Services 51 Germantown Court Cordova, TN 38018 PH - (901) 843-2667

RE: CF_Pass_Parameters_to_Index.cfm HELP

(maybe sys admins can shed some light here.) anyways, my $0.02 Greg Jordan Macromedia Certified ColdFusion Developer Web Project Manager [EMAIL PROTECTED] Unified Health Services 51 Germantown Court Cordova, TN 38018 PH - (901) 843-2667 x261 FAX - (901

RE: CF_Pass_Parameters_to_Index.cfm HELP

look as this thread on the cf forums http://forums.allaire.com/coldfusion/messageview.cfm?catid=3threadid=218632 highlight_key=ykeyword1=fusebox Greg Jordan Macromedia Certified ColdFusion Developer Web Project Manager [EMAIL PROTECTED] Unified

RE: creating a static copy of a site

:\Inetpub\wwwroot\saveFilesHere resolveurl=false/cfhttp Greg Jordan Macromedia Certified ColdFusion Developer Web Project Manager [EMAIL PROTECTED] Unified Health Services 51 Germantown Court Cordova, TN 38018 PH - (901) 843-2667 x261 FAX - (901) 843-2672

database structure

I am setting up a database in SQL Server that will hold a sales team listings. The salesperson can be in multiple categories and multiple states. My question is what is the most efficient way of doing this? would it be (1) setting up three tables, one for the salesperson's main record and

RE: html as xml for asp :)

Michael Try something like this... % Dim objXMLDOM Set objXMLDOM = Server.CreateObject(Microsoft.XMLDOM) 'load the widget.xml document objXMLDOM.load(Server.MapPath(widget.xml)) for each objChild in objXMLDOM.documentElement.childNodes Response.write objChild.NodeName -

RE: Good resource on CF/XML integration?

Dave use CF_ObjectDump to see what results you are getting. Also, if you are using cfhttp/get to grab some xml data or file, and there is a querystring involved, make sure you use URLEncodedFormat with the string. Greg -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]]

stored procedure problem

Our previous DBA created a table and used (gasp) spaces in the field names (believe or don't, this person did it more than once and used ALL KINDS of naming conventions). When I called the SP, the #columnList# lists a field that looks like this: A OR B We've got some VB developers who

RE: stored procedure problem

Simon Horwith Macromedia Certified Instructor Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Greg Jordan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 11:44 AM To: CF

RE: stored procedure problem

Instructor Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Greg Jordan [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 11:44 AM To: CF-Talk Subject: stored procedure problem

RE: Contracts invoice forms for freelance?

Paul This subject may be better suited for the CFCommunity List, but...my advice is make sure that EXPLICITLY define what you are and are not going to do. if you leave that open on any point, you could find yourself doing more than you bargained. It is well worth it to nail that down before

RE: Outputting Raw CFML

CF_FileWriteText could most likely do the trick or use the Replace Function using LT; for and GT; for Greg -Original Message- From: Kuehn, Matthew [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 2:18 PM To: CF-Talk Subject: Outputting Raw CFML I want to build an app that

RE: Who's a good merchant these days?

Erika here are a few. SkipJack - http://www.skipjack.com GoRealtime - http://www.gorealtime.com Itransact - http://www.itransact.com but I highly recommend Bank of America services, if you have a b of a account

RE: Who's a good merchant these days?

://www.crescotech.com -Original Message- From: Greg Jordan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 3:06 PM To: CF-Talk Subject: RE: Who's a good merchant these days? Erika here are a few. SkipJack - http://www.skipjack.com GoRealtime - http://www.gorealtime.com Itransact

RE: Blocking IP Range on UU net User

Either of these might be a bit extreme (or not worthy) But I HTH... 1. I would change the form control names every so often and make sure you scope them on the action page. Also add a name to the submit form control and verify it. 2. Or you could create a list of acceptable form control names

RE: custom tag for a progress meter

i found one at the dev exchange(watch for URL wrapping) JS Please Wait http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3473BF-2830-11D4-AA 9700508B94F380method=Full -Original Message- From: Brad Comer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 01, 2001 4:11 PM To:

RE: Creating a Dynamic Menu - SMART @SS

forta's CF_DHTMLMenu http://devex.allaire.com/developer/gallery/info.cfm?id=CA347388-2830-11D4-AA 9700508B94F380method=full -Original Message- From: Steven A. del Sol [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 2:21 PM To: CF-Talk Subject: RE: Creating a Dynamic Menu - SMART

RE: Creating a Dynamic Menu - SMART @SS

: Greg Jordan [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 1:13 PM To: CF-Talk Subject: RE: Creating a Dynamic Menu - SMART @SS forta's CF_DHTMLMenu http://devex.allaire.com/developer/gallery/info.cfm?id=CA347388-2830-11D4-AA 9700508B94F380method=full -Original Message- From

RE: New CF5 Partner Hosting License

unless you go out of business or lose your religion. -Original Message- From: Len Conrad [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 8:11 AM To: CF-Talk Subject: RE: New CF5 Partner Hosting License And where would that leave smaller developers? If the smaller developers

studio upgrade

Does anyone know if CFStudio will be released in a 5.0 version? If so, does anyone know what features will added, changed, etc? Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at

RE: Cold Fusion Magazine? Any Good?

Jeff I'll put it this way regarding CFDJ: It cost me less than $200.00 for a two year subscription, but I have learned more than $200.00 worth of coding examples, tips and received different perspectives on the same issues I am dealing with... Also, check out one of their site at

RE: Is CF still relevant?

I've done sites in ASP, CF and JSP. Each has certain advantages, but for the *majority* of sites I've done CF has been the best tool for the job. And that is what will keep it relevant, for at least a good while longer. But, it is always advisable to learn as many ways as possible to get the

RE: CyberCash

IMHO, they weren't that great to begin with...I've used them on two different sites, with *many* processing problems as well as Operational problems. Code-wise, it wasn't so badI much prefer to use AuthNet, or Bank of America - if possible. now that they are in a *soft* financial situation,

RE: ASP for Cold Fusion Disciples

maybe not from a CF perspective, but http://www.4guysfromrolla.com it pretty good for regarding ASP and I would definitely check out http://java.sun.com/products/jsp/index.html for JSP, if you have not done so already... Greg -Original Message- From: Troy Hiltbrand [mailto:[EMAIL

RE: odbc ole-db, stored proc

did you add an OLE DB DSN in the CF administrator? Greg -Original Message- From: dm [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 3:34 PM To: CF-Talk Subject: RE: odbc ole-db, stored proc running a stored procedure on sql server 2k. sp executes fine from query analyzer and

RE: odbc ole-db

one big advantage with OLE DB over ODBC using SQL Server is this: ODBC - for each database you have to set up an DSN OLE DB - you set up one DSN and all the databases can be referenced via that ONE DSN Greg -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Monday, April

RE: session time out

Nelson I am confused. why would you want to set the cflock to 60 minutes? Greg -Original Message- From: t nelson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 5:22 PM To: CF-Talk Subject: Re: session time out Howdy, I usually set my application like this cfapplication

RE: Escaping apostrophes

I think you could either use the PreserverSingleQuotes function or use REPLACE and add an extra apostrophe for each apostrophe. -Original Message- From: andrew kopelman [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 2:39 PM To: CF-Talk Subject: Escaping apostrophes Hello,

RE: CFX_ONCR_CYBERCASH4

try the free cybercash tag -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 10:40 PM To: CF-Talk Subject: CFX_ONCR_CYBERCASH4 Anyone had any experience with this product? Considering purchasing and using it. Any comments or

RE: Newbie question

make sure that you set the development mappings in studio here's how: go to options in the menu bar settings browse. then click development mappings. set the studio and server path (your web root) and the set the browser path (most likely, http://127.0.0.1/ or http://localhost) HTH G

RE: Win2k

make sure that you check out http://forums.allaire.com/devconf/Index.cfm?Message_ID=683354 -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 9:31 AM To: CF-Talk Subject: Win2k Anyone had any experience of Coldfusion (proffesional)

RE: Password protect ONE form

maybe not the best way, buthave a url with a certain var match like http://www.yoursite.com/form.cfm?ID=thecorrectone verification might look like cfif url.ID IS "thecorrectone" set some variable, session or cookie cfelse DO NOT set some variable, session or cookie /cfif in your menu,

RE: Shopping carts

authorize.net or if your business has a Bank of America account or can get one, their CC processing is a SNAP. -Original Message- From: Savan Thongvanh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 7:45 AM To: CF-Talk Subject: OT: Shopping carts OK, now i have this

RE: Shopping carts

Paul if you go to http://www.bofa.com/merchantservices/index.cfm?template=merch_ic_estores_set tle.cfm (B of A uses CF, not exclusively however) you will notice the option for "settle up". (They also offer another version called "branded", but it doesn't allow seamless integration with your

server setup

Does anyone have or know of references for setting up a webserver with CF? I have be using CF for 3 years, but have never been solely responsible for the server setup and management. A checklist/greatest hits would suffice, but as many KB articles, other articles, tips, tricks, etc. would be

RE: SQL books

The Practical Sql Handbook : Using Structured Query Language ISBN:0201447878 -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 2:27 PM To: CF-Talk Subject: OT: SQL books Hi, I need to buy a good SQL book for reference and help on joins and