RE: Using CFMX and JRUN 4 together

2002-12-02 Thread Robertson-Ravo, Neil (RX)
JSP files will and can be parsed by JRun, though I am pretty sure it is not the 100% implementation which is shipped with JRun 4 - the full product. -Original Message- From: Dave [mailto:[EMAIL PROTECTED]] Sent: 30 November 2002 20:08 To: CF-Talk Subject: Using CFMX and JRUN 4 together

RE: Architecting Tools

2002-12-02 Thread John Beynon
Of hand, I think the community version is about $750 whilst the professional version is about $2500, Jb. -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 03:28 To: CF-Talk Subject: RE: Architecting Tools Any idea, Peter, what Adalon costs? |

Space is removed - unwanted

2002-12-02 Thread Peter Mayer
Hello! If I use the following statement I receive the following output: SirSmith cfoutput cfif q_select.sex is 0SircfelseMadame/cfif #q_select.surname# /cfoutput The space between the cfif statement and the output is removed. Is this a bug? Best regards, Peter

RE: Space is removed - unwanted

2002-12-02 Thread Robertson-Ravo, Neil (RX)
not sure, but try using a nbsp; -Original Message- From: Peter Mayer [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 10:04 To: CF-Talk Subject: Space is removed - unwanted Hello! If I use the following statement I receive the following output: SirSmith cfoutput cfif q_select.sex is

RE: Posting XML - for Craig

2002-12-02 Thread Craig Dudley
String messageBody = request.getAttribute(XMLData); Should read... String XMLData = request.getAttribute(XMLData); My bad, Craig. -Original Message- From: Frank Mamone [mailto:[EMAIL PROTECTED]] Sent: 29 November 2002 20:26 To: CF-Talk Subject: Re: Posting XML - for Craig Hey

RE: Space is removed - unwanted

2002-12-02 Thread Peter Mayer
Well, it happens in a text only email (therefore no nbsp is possible) currently I am composing a string using cfif q_Select.sex is 0cfset a_str_greeting = Sircfelsecfset a_str_greeting = Madame/cfif cfset a_str_greeting = a_Str_greeting q_select.surname This workaround does the job

Personaliztion with Coldfusion ?

2002-12-02 Thread Ian Vaughan
I have a login script, the users logs in and gets validated against a database table CFQUERY DATASOURCE=#Application.DSN# NAME=Security SELECT * FROM staff_admin WHERE Username = '#form.Username#' AND Password = '#form.Password#' /CFQUERY If correct the session variables are set up in the

Re: Space is removed - unwanted

2002-12-02 Thread Gyrus
- Original Message - From: Peter Mayer [EMAIL PROTECTED] Well, it happens in a text only email (therefore no nbsp is possible) --- I have found managing that getting whitespace exactly right in plain text email using CFMAIL is an impossible job sometimes. But

Re: Personaliztion with Coldfusion ?

2002-12-02 Thread Stephen Moretti
Ian, CFQUERY DATASOURCE=#Application.DSN# NAME=Security Hope that this is in CFMX, otherwise you need to be looking at CFLOCK ;o) For example I run a query to return a list of documents in my database table. Some of the records are available to view to everybody, however some of the

logging calls to CFM templates?

2002-12-02 Thread Gyrus
Is there any way of getting stats on calls to individual CFM files? Basically, everything in my apps goes through index.cfm, and obviously I'm a good little coder and try to be as modular as possible. What I want to know is which individual templates are processed most often as an application is

RE: logging calls to CFM templates?

2002-12-02 Thread Robertson-Ravo, Neil (RX)
are you using Fusebox? -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 11:24 To: CF-Talk Subject: logging calls to CFM templates? Is there any way of getting stats on calls to individual CFM files? Basically, everything in my apps goes through

RE: Personaliztion with Coldfusion ?

2002-12-02 Thread Kevan . Windle
Depends how much customisation you want to do, but if you want to set up something more flexibile and extensible you really need to think about building in some kind of roles based access system. Basically you have Objects, Roles, Users: Objects - bits of the site - pages docs whatever These

Re: Message Board

2002-12-02 Thread James Smith
Before I start tearing my hair out does anyone know if both (or either) of these work with MX? The CFBB site says it requires MX SP1 which shouldn't be a problem (but has anyone tried it)? The SMB page doesn't mention MX at all. -- James Smith [EMAIL PROTECTED] - Original Message -

Re: logging calls to CFM templates?

2002-12-02 Thread Peter Mayer
Hello! I would suggest the following solution: a) create a file called mod_log.cfm with some properties (f.e. attributes.pagename, attributes.parameter, ...) b) create a database with fields like sitesection, hitcount ... c) write some sql statements for updating hitcount ... maybe you want

Re: logging calls to CFM templates?

2002-12-02 Thread Gyrus
are you using Fusebox? My template is loosely based on Fusebox, as in: index.cfm?action=section.page index.cfm contains a switch that runs from #ListFirst(URL.action, .)#, and each section has a switch that runs from #ListRest(URL.action, .)#. Gyrus [EMAIL PROTECTED] work:

Re: logging calls to CFM templates?

2002-12-02 Thread Gyrus
No, you misunderstood the question... It would be pretty easy to build something like this that basically logged which sections and pages are used most often - it would be just a homegrown site stats thing. What I'm actually interested in is what individual CFM templates are used most often. So

RE: logging calls to CFM templates?

2002-12-02 Thread Robertson-Ravo, Neil (RX)
just get a log reader and read the verbose log files which IIS generates. -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 12:43 To: CF-Talk Subject: Re: logging calls to CFM templates? No, you misunderstood the question... It would be pretty easy to

Re: logging calls to CFM templates?

2002-12-02 Thread Gyrus
- Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] just get a log reader and read the verbose log files which IIS generates. --- Not sure, but I think there's still the same misunderstanding here. How would IIS know what CFM template the CF

RE: logging calls to CFM templates?

2002-12-02 Thread Mike Townend
Check your weblogs, they usually display the URL details.. So you could use webtrends or something to parse the log files based on the url strings... Thus which templates were actually being executed.. HTH Mikey -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: logging calls to CFM templates?

2002-12-02 Thread Robertson-Ravo, Neil (RX)
yep, they usually display the data, but in this instance, it seems that you have built an app and you have not factored logging capabilities into it; -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 13:02 To: CF-Talk Subject: Re: logging calls to CFM

Re: Posting XML - for Craig

2002-12-02 Thread Frank Mamone
Thanks! - Original Message - From: Craig Dudley [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 02, 2002 5:03 AM Subject: RE: Posting XML - for Craig String messageBody = request.getAttribute(XMLData); Should read... String XMLData =

Re: Trying to dynamically populate IFrame content pages...somehow.

2002-12-02 Thread Christian Cantrell
Glad it worked out (and that you slept better because of it). I don't know of any other issues with iframes beside browser compatibility. I've always liked the idea of iframes, and thought that they should have been included in the HTML 4.0 specification. It seems that Netscape is

Re: Personaliztion with Coldfusion ?

2002-12-02 Thread Christian Cantrell
This is a good approach. As role or group is a property of a user, the column should go in the table with the other user data. Consider making a new table that contains possible rolls, like this: RoleConfig roleId (pk) name displayName Then have your user table reference

Re: Trying to dynamically populate IFrame content pages...somehow.

2002-12-02 Thread jon hall
IFrame's have been a part of the HTML 4.0 spec which was finalized in 1998, one year after Netscape 4.0 came out. Every browser released since the end of 1998 has supported iframes. Netscape 4.0's version of iframe's are ilayer's. -- jon mailto:[EMAIL PROTECTED] Monday, December 2, 2002,

RE: Personaliztion with Coldfusion ?

2002-12-02 Thread Robertson-Ravo, Neil (RX)
its not only goodits standard. -Original Message- From: Christian Cantrell [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 13:54 To: CF-Talk Subject: Re: Personaliztion with Coldfusion ? This is a good approach. As role or group is a property of a user, the column should go in

Re: Personaliztion with Coldfusion ?

2002-12-02 Thread Ian Vaughan
Hi So how would I build user roles etc into my application, is it something like below, or is there a more elegant way?... First of all how would this query look?? and where would the permissions be set up in your suggestion? I have an admin table that holds user login information with fields

Re: Space is removed - unwanted

2002-12-02 Thread Joshua Miller
With CF5 I noticed that if you have the suppress whitespace option selected in the CFAdmin that it kills whitespace in your CFMAIL deliveries as well. I had though that the Suppress Whitespace option was for making the code less cluttered with whitespace, but apparently it's a global

RE: Trying to dynamically populate IFrame content pages...somehow.

2002-12-02 Thread Rick Faircloth
Thanks for the input, everyone... All versions of IE since ? support IFrames... All versions of Netscape since ? support IFrames...(using the IFrame tag) Wanting to make sure I don't exclude too many users. People in this area tend to use Netscape more than usual today since the biggest local

RE: Trying to dynamically populate IFrame content pages...somehow .

2002-12-02 Thread Lofback, Chris
I've got a chart from Web Review.com that says iFrame support for IE began at v3 (except on Unix: v4.01), Netscape at v6 and Opera at v4.02. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Rick

RE: Trying to dynamically populate IFrame content pages...somehow .

2002-12-02 Thread Rick Faircloth
Ouch. Version 6 of Netscape, huh? People around here tend to use the first version of Netscape that they started with...even Netscape 3. Making the use of iFrames could be very limiting then...and after TWO DAYS of wrestling with getting them to work properly! waa! Anyone making extensive

OT: CFMX JRun Web Server

2002-12-02 Thread Jeff D. Chastain
I have a web server running IIS 5 and CF5. However, I now have a couple of apps that require CFMX, so I was attempting to install the stand-alone JRun server with CFMX (so I can run both CF5 and CFMX on the same box). My question is, how do I setup multiple sites/IPs in the JRun server? I have

Re: CF Studio 4.5 Search Results

2002-12-02 Thread S . Isaac Dealey
Thanks guys, big help... I guess I equated open in browser to viewing the individual template as a base template... Now there's a silly assumption. :) If you view the HTML results in your browser, you can just copy and paste from your browser to a text file so you don't have to worry about

excel attachment

2002-12-02 Thread Robert Orlini
Hello, How do I add an Excel file attachment to a reply email I send via CF's CFMAIL tag to user's that have filled out an online form created with CF? In other words after a user fills out a form, they get a bounce back email thanking them for filling out the form and the email would also

RE: excel attachment

2002-12-02 Thread Kevan . Windle
cfmail to= from= mimeattach=file.xls? or am i missing something? -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 15:11 To: CF-Talk Subject: excel attachment Hello, How do I add an Excel file attachment to a reply email I send via CF's CFMAIL tag

RE: excel attachment

2002-12-02 Thread Lofback, Chris
In CF5, I'd use: CFMAIL ... CFMAILPARAM FILE=c:\foo\bar.xls. /CFMAIL Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002

Re: Trying to dynamically populate IFrame content pages...somehow.

2002-12-02 Thread Christian Cantrell
If your browser baseline includes Netscape 4.x, you will either have to use both tags, like so: iframe scrolling=no frameborder=0 marginheight=0 marginwidth=0 src=http://domain/page.cfm; ilayer src=http://domain/page.cfm;/ilayer nolayer

OT: DTD/XML Schema Standards

2002-12-02 Thread Andy Ousterhout
Are there standard DTD's or XML Schema's for Invoices, Purchase Orders, People, Products, etc? I looked at the W3C site and couldn't find any Andy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

RE: excel attachment

2002-12-02 Thread Robert Orlini
Thanks Chris. I don't have CF5 though, I'm running 4.5.1. Robert O. -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:22 AM To: CF-Talk Subject: RE: excel attachment In CF5, I'd use: CFMAIL ... CFMAILPARAM

RE: CFMX JRun Web Server

2002-12-02 Thread Robertson-Ravo, Neil (RX)
You need to add then within the jrun-web.xml file held in the CFusionMX wwwroot. -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 15:12 To: CF-Talk Subject: OT: CFMX JRun Web Server I have a web server running IIS 5 and CF5. However, I now

RE: excel attachment

2002-12-02 Thread Robert Orlini
Thanks! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:18 AM To: CF-Talk Subject: RE: excel attachment cfmail to= from= mimeattach=file.xls? or am i missing something? -Original Message- From: Robert Orlini

Re: excel attachment

2002-12-02 Thread samcfug
Are you assuming that every recipient of the mail will have either Office installed, or at least the Excel Reader app? = Douglas White group Manager mailto:[EMAIL PROTECTED] http://www.samcfug.org = - Original Message

RE: DTD/XML Schema Standards

2002-12-02 Thread Svee, Eric
Check out http://www.hr-xml.org/channels/projects_main.cfm You might find some useful stuff there. E -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 7:26 AM To: CF-Talk Subject: OT: DTD/XML Schema Standards Are there standard DTD's

RE: Trying to dynamically populate IFrame content pages...somehow.

2002-12-02 Thread Rick Faircloth
Perhaps coding both iFrames and iLayers wouldn't be too much to do to use the effect. So iFrames and iLayers are really the same thing from a coding and output perspective? Same parameters, etc? Rick -Original Message- From: Christian Cantrell [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: excel attachment

2002-12-02 Thread Robert Orlini
Yes, I guess. What are other options? RO -Original Message- From: samcfug [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:36 AM To: CF-Talk Subject: Re: excel attachment Are you assuming that every recipient of the mail will have either Office installed, or at least the

RE: CFMX JRun Web Server

2002-12-02 Thread Jeff D. Chastain
Okay, in jrun-web.xml I see virtual mappings, but what I am looking for is additional sites. For example, going to http://www.siteone.com would point to siteone's home directory vs. pointing to sitetwo's url would go to sitetwo's home directory. I am not looking for http://server/siteone. Does

CFMX crashes

2002-12-02 Thread Shahzad.Butt
We have got a link in our page which calls stored procedure which actually invokes batch script. This batch script copy files from one server to another. When copying is over it net send specified users. This copying takes about 10 mins. I've noticed though after call to this SP I close my browser

RE: CFMX crashes

2002-12-02 Thread Robertson-Ravo, Neil (RX)
use the IIS connectors bat file in the Cfusionmx directory -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 15:42 To: CF-Talk Subject: CFMX crashes We have got a link in our page which calls stored procedure which actually invokes batch script.

RE: Trying to dynamically populate IFrame content pages...somehow.

2002-12-02 Thread Rick Faircloth
I copied the iFrame code I used initially and just changed the IFRAME tag to ILAYER and it worked for in IE 5.5 and NN 6.2.2 to have both versions of the code in there. The alignment was a little off visually in NN, but it was working nonetheless. If that'll get me down to NN 4.0, I'll be

RE: CFMX crashes

2002-12-02 Thread Robertson-Ravo, Neil (RX)
wrong post! :-) -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 15:41 To: CF-Talk Subject: RE: CFMX crashes use the IIS connectors bat file in the Cfusionmx directory -Original Message- From: Shahzad.Butt [mailto:[EMAIL

RE: Personaliztion with Coldfusion ?

2002-12-02 Thread Eric Dawson
where can one get more reading on this? I am in the middle of building the same thing. Eric From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Personaliztion with Coldfusion ? Date: Mon, 2 Dec 2002 13:57:25 - its not

Re: Trying to dynamically populate IFrame content pages...somehow.

2002-12-02 Thread jon hall
It's very similar, but technically it's probably closer to the span tag, with the addition of a src parameter. Being a layer tag, it's a bit more flexible than an iframe, but it's a close to an iframe tag as it gets in ns4. -- jon mailto:[EMAIL PROTECTED] Monday, December 2, 2002, 10:46:30

Re: excel attachment

2002-12-02 Thread Eric Dawson
cfmail to=#Name# #email# from=#form.fromname# #form.from# subject=#form.subject# server=#mailserver##form.body# CFMAILPARAM FILE=#expandpath('.')#\#filename# /cfmail Adds an attachment to an outgoing email. HTH Eric From: Robert Orlini [EMAIL PROTECTED] Reply-To:

RE: excel attachment

2002-12-02 Thread Eric Dawson
what's the app? how much data? I would support web based and excel based data collection. own personal preference. If they don't have excel they can always use the web form. Eric From: Robert Orlini [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: excel

Checking SESSION variable

2002-12-02 Thread FlashGuy
Hi, I have session variable that contains the directory name session.strFileName. I also have another session variable session.ShowMe that contains multiple directory names (comma-delimited) which i'm setting from my database. Basically, i need to check if the directory session.strFileName

Re: Checking SESSION variable

2002-12-02 Thread Randell B Adkins
CFIF LISTCONTAINSNOCASE(session.ShowMe,session.strFileName) I think this is what you are asking. sesion.strFileName = D:\Temp sesion.ShowMe = D:\Temp,D:\Test then the above CFIF statement should return TRUE [EMAIL PROTECTED] 12/02/02 11:08AM Hi, I have session variable that contains the

Re: Checking SESSION variable

2002-12-02 Thread Clint Tredway
cfif findNoCase(session.strFileName,session.ShowMe) do this cfelse do that /cfif HTH Clint - Original Message - From: FlashGuy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 02, 2002 10:08 AM Subject: Checking SESSION variable Hi, I have session

RE: Checking SESSION variable

2002-12-02 Thread Jason Lees (National Express)
Use the find function cfif find(session.showme,session.strfilename,0) gte 0 cfelse . /cfif but from the example that could be ambigious, as there could be more than one mywork2 in different sub folders. Jason Lees Systems Developer National Express Coaches Ltd.

RE: Checking SESSION variable

2002-12-02 Thread Tony Weeg
listcontainsNoCase Description Returns the index of the first element of a list that contains a specified substring within elements. The search is case-insensitive. If no element is found, returns 0. Category List functions Syntax listcontainsNoCase(list, substring [, delimiters ]) ..tony

Re: Checking SESSION variable

2002-12-02 Thread Scott Brady
I have session variable that contains the directory name session.strFileName. I also have another session variable session.ShowMe that contains multiple directory names (comma-delimited) which i'm setting from my database. Basically, i need to check if the directory session.strFileName exists

Re: excel attachment

2002-12-02 Thread Pete Ruckelshaus
You could use .CSV, it is more universal and should answer Douglas' argument :-) Pete - Original Message - From: Robert Orlini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 02, 2002 10:34 AM Subject: RE: excel attachment Yes, I guess. What are other options?

Re: Checking SESSION variable

2002-12-02 Thread FlashGuy
Actually, the session.strFileName would have no path in it. sesion.strFileName = Temp sesion.ShowMe = D:\Temp,D:\Test On Mon, 02 Dec 2002 11:11:43 -0500, Randell B Adkins wrote: CFIF LISTCONTAINSNOCASE(session.ShowMe,session.strFileName) I think this is what you are asking.

OT: CFX_SNMP, usefulness in the CF community

2002-12-02 Thread Ryan Emerle
Hi, I've written a CFX tag that creates a simple and easy interface with SNMP-enabled entities. I am curious of the community's need for such a tag. The tag does the following: * Provides a simple interface to the somewhat complex world of SNMP * Probes multiple SNMP OIDs in a single datagram

Re: Checking SESSION variable

2002-12-02 Thread Randell B Adkins
Then try: CFIF FINDNOCASE(session.strFileName,session.ShowMe,1) GT 0 This will just look for an instance of session.strFileName within the session.ShowMe variable. [EMAIL PROTECTED] 12/02/02 11:24AM Actually, the session.strFileName would have no path in it. sesion.strFileName = Temp

OT - SQL Help

2002-12-02 Thread Tony Carcieri
Hi all, Sorry for the OT but this should be a quick answer. This is in ASP (sorry). If I have the following: sql = SELECT * FROM SomeTable sql = sql WHERE Email = ' Request(un) ' sql = sql OR SEmail = ' Request(un) ' sql = sql AND IsDeleted = 0 sql = sql AND Password = '

Stripping end of cfhttp.filecontent

2002-12-02 Thread Cathy Taylor
This is probably a really easy and dumb question. I have a page that grabs another page and strips most of the ads, images, and unnecessary information. Then it displays the bulk of the page. At the end are more ads and unnecessary junk I'd also like to stip off, but I'm not sure how to do

RE: CFMX crashes

2002-12-02 Thread Shahzad.Butt
This batch file is in DB Server and I can't stick it in Application Server. There is nothing wrong with Batch file. But I was wondering why MX is crashing. It has been working perfect with CF5.0. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 02

Re: OT - SQL Help

2002-12-02 Thread Randell B Adkins
You ( ) around your OR statements Example: sql = SELECT * FROM SomeTable sql = sql WHERE (Email = ' Request(un) ' sql = sql OR SEmail = ' Request(un) ') sql = sql AND IsDeleted = 0 sql = sql AND Password = ' Request(pw) ' sql = sql AND Approved = 1 sql = sql AND

Re: OT: CFX_SNMP, usefulness in the CF community

2002-12-02 Thread jon hall
I'm very interested. Is there a place I can download it? What is the cost? -- jon mailto:[EMAIL PROTECTED] Monday, December 2, 2002, 11:30:54 AM, you wrote: RE Hi, RE I've written a CFX tag that creates a simple and easy interface with SNMP-enabled entities. I am curious of the community's

RE: OT - SQL Help

2002-12-02 Thread Andy Ewings
I'm a bit confused - I'm not sure what you mean by the error you are getting. What scope are you trying to request the variable un from? Is it a form variable or url? Normally you'd access these using Request.Form(un) (for form vars) If they are local vars then just reference them as un. Not

CFMX not compatible with Oracle 8.0.5

2002-12-02 Thread Jim Campbell
This is interesting... According to MM tech support, CFMX's Type 4 JDBC driver will not connect with Oracle 8.0.5. Short of upgrading our instance of Oracle (which, yes, we should get around to one of these days), has anyone had this problem and come up with a way of getting this to work? I'd

RE: OT - SQL Help

2002-12-02 Thread Robertson-Ravo, Neil (RX)
its using Structure notation. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 16:46 To: CF-Talk Subject: RE: OT - SQL Help I'm a bit confused - I'm not sure what you mean by the error you are getting. What scope are you trying to request the

Re: commas in numeric fields...

2002-12-02 Thread Ed Gordon
Rick, Do you have any examples of using onsubmit() that I could see? Is this Java script? I haven't done much Javascript and want to keep this as simple as possible. As for right now, I parse the field myself and pull out non-numerics (dollar sign and commas) but this leaves the user with a fatal

OT: Search Engine Options

2002-12-02 Thread David Hannum
I'm currently researching options for a new enterprise level search engine for here at Ohio University. I know Verity K2 comes with CF, but it is limited and from everything I've read, I don't feel it's anywhere near robust enough for an enterprise level search like we have here (100,000 static

RE: Stripping end of cfhttp.filecontent

2002-12-02 Thread Steve Reich
Try this cfhttp URL=#WWURL# method=get resolveurl=true/cfhttp cfscript // Replace link colors and rename content color = ReReplace(#cfhttp.filecontent#, 800854, 99, All); // Modify all links to second agent page with variable links =

OLEDB Error Code = 3621

2002-12-02 Thread michael firth
Hey gang, Need help with a sqlserver error when running with coldfusion. The datasource, the query structure are fine. Also I am able to read data from the sqlserver database, but when I try to execute a insert statement I get the following error: OLEDB Error Code = 3621 The statement has

RE: OLEDB Error Code = 3621

2002-12-02 Thread Rob Rohan
sp normally means stored procedure. Are you trying to insert into a stored proc? Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: michael firth [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:13 AM To:

Re: OLEDB Error Code = 3621

2002-12-02 Thread John Wilker
sp_ might be invalid for a table name? SP_ is for system procedure IIRC and SQL may not like it being used as a table name. Try to change the table's name and see if that does anything. Can you run the statement in query analyzer manually? At least possibly narrow down the point of failure. On

RE: OLEDB Error Code = 3621

2002-12-02 Thread Mike Townend
My initial thought is that sp_ is used to show system stored procedures... So perhaps SQL Server does not like that naming convention, try chagneing the name of the table... Second thought is if C_Date is a datetime field in SQLServer you will want to wrap the date with a CreateODBCDate HTH

CF Service Starting/Stopping

2002-12-02 Thread Bruce, Rodney S HQISEC/Veridian IT Services
Hello all Sorry I know it is probably in the archives, but my search logic is not working. We are having an issue with the ColdFusion Service Stopping and Starting. But the messages in the event logs don't give details, just say that the service has been stopped/Started.

RE: OLEDB Error Code = 3621

2002-12-02 Thread michael firth
Nah its not a stored procedure, just a short abbreviation for super petros. Mike - Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now ~| Archives:

Re: OLEDB Error Code = 3621

2002-12-02 Thread Scott Brady
OLEDB Error Code = 3621 The statement has been terminated. SQL = Insert into Sp_Signup(Email,C_Date) Values ('[EMAIL PROTECTED]','12/02/02') Data Source = MFXSP Have you tried running that query in Enterprise Manager? My guess is that the problem is with the date value. What's the

Passing parameters

2002-12-02 Thread Cutter (CF_Talk)
For rather odd reasons I am attempting to pass a parameter that looks a little like this: cfparam name=variables.hpimage default=ui:hpimage image='Dr_Andes_final.jpg' width='204' hieght='238' alt='Dr. Jon M. Andes and friends' caption='yes' and call it like:

RE: OT - SQL Help

2002-12-02 Thread Tony Carcieri
No scope. It is written in ASP. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:46 AM To: CF-Talk Subject: RE: OT - SQL Help I'm a bit confused - I'm not sure what you mean by the error you are getting. What scope are you trying to

Re: OLEDB Error Code = 3621

2002-12-02 Thread michael firth
I tryed renaming the table and that didnt seem to work. Plus also the C_Date is a nvarchar field, but what I tryed to do was run the query without the field and still got the oledb error code. Also I did run the query in query analyzer and it worked just fine. Second, I tryed changing the

RE: OLEDB Error Code = 3621

2002-12-02 Thread Mike Townend
To you yes... Not necessarily to SQL Server... If you rename the table does the problem still occur.. HTH -Original Message- From: michael firth [mailto:[EMAIL PROTECTED]] Sent: Monday, December 2, 2002 17:21 To: CF-Talk Subject: RE: OLEDB Error Code = 3621 Nah its not a stored

Re: Passing parameters

2002-12-02 Thread Bryan Stevenson
I'd use URLEncodedFormat() when you pass that mess via the URL ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner

RE: PHP - CF

2002-12-02 Thread Luis Lebron
If you are writing code in different languages you may want to try Code Chare. www.codecharge.com. It lets you write code and exports it to a variety of languages (i.e. cf, php, perl, jsp, etc...) -Original Message- From: Michael Greenberg [mailto:[EMAIL PROTECTED]] Sent: Friday, November

RE: Passing parameters

2002-12-02 Thread Mike Townend
View the source of the browser window... My guess is that it is sending the data out, but the browser doesn't know how to interpret ui:hpimage tags and so hides them HTH -Original Message- From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 2, 2002 17:23 To:

problem fixed! RE: OLEDB Error Code = 3621

2002-12-02 Thread michael firth
Hey gang, Thanks for the assist espically the info on stored procedures, but really wasn't using any. It turns out that in the administrator, in settings, the compress whitespace box was checked and soon as i turn it off it started working. So it wasnt a sql but a coldfusion thing. Thanks,

RE: OT - SQL Help

2002-12-02 Thread Rob Rohan
That is pretty funny, posting an SQL question wrapped in ASP on a Cold Fusion list. I have a question about using linked lists and malloc in C :) Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Tony Carcieri

RE: OT - SQL Help

2002-12-02 Thread Andy Ewings
Sorry - I wasn't particularly clear. What I meant to say was that the request object has a number of collections associated with it (form, querystring, etc...). When I have used the request object I have always referenced an element of one of these collections e,g, request.form(un). Not seen it

RE: OLEDB Error Code = 3621

2002-12-02 Thread Rob Rohan
Is perhaps, the email a primary key and you are inserting a duplicate value? http://www.sqlmag.com/forums/messageview.cfm?catid=9threadid=8008 Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: michael firth

RE: Passing parameters

2002-12-02 Thread Ben Doom
Try using htmleditformat(). I'm assuming here that what you want to do is display it. --Ben Doom Programmer General Lackey Moonbow Software : -Original Message- : From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] : Sent: Monday, December 02, 2002 12:23 PM : To: CF-Talk :

RE: CF Service Starting/Stopping

2002-12-02 Thread Mike Brunt
Rodney, take a look in the ColdFusion error logs, in particular Application and Server logs. If you go into ColdFusion Administrator then Tools-Log Files you can view the logs there. If you need further guidance please give us some examples of any error messages in there, particularly in the

Re: Passing parameters

2002-12-02 Thread Cutter (CF_Talk)
It's not the browser that interprets that parameter string, but rather the CFMX server. This bit of syntax... ui:hpimage image='Dr_Andes_final.jpg' width='204' hieght='238' alt='Dr. Jon M. Andes and friends' caption='yes' ..on it's own calls a custom tag (hpimage.cfm) that writes some rather

RE: OT - SQL Help

2002-12-02 Thread Dave Watts
Sorry - I wasn't particularly clear. What I meant to say was that the request object has a number of collections associated with it (form, querystring, etc...). When I have used the request object I have always referenced an element of one of these collections e,g, request.form(un). Not

RE: OT - SQL Help

2002-12-02 Thread Tony Carcieri
This and CFDJList are the only good lists that are out there where everyone is more than helpful and help/answers are extrememly quick. -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:38 PM To: CF-Talk Subject: RE: OT - SQL Help That is

Re: Passing parameters

2002-12-02 Thread Bryan Stevenson
That's why I said use URLEncodedFormat() to pass the parameter via the URL. If you pass it raw as it stands now, it will not arrive as a whole parameter on the receiving page. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL

RE: OT - SQL Help

2002-12-02 Thread Tony Carcieri
Dave's absolutely right. I am a lil' lazy. The less typing the better! 8^) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:56 PM To: CF-Talk Subject: RE: OT - SQL Help Sorry - I wasn't particularly clear. What I meant to say was that

RE: OT - SQL Help

2002-12-02 Thread Andy Ewings
my ASP's not what it used to be! - so did Randells post sort it? -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 17:59 To: CF-Talk Subject: RE: OT - SQL Help Dave's absolutely right. I am a lil' lazy. The less typing the better! 8^)

  1   2   3   >