RE: Passing FORM variables to Components?
easy when you know how!
cheers james
-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED]
Sent: 03 February 2005 2:41 pm
To: CF-Talk
Subject: RE: Passing FORM variables to Components?
Pass the FORM scope as a new argument:
TestVariable = ThisRotaDetailAttributes.RollingRotaUpdate(url.rid, FORM)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, 3 February 2005 10:36
To: CF-Talk
Subject: Passing FORM variables to Components?
Hi all,
I have an old CF app that is passing a *varying number* of FORM variables to
a custom tag using (varies according to setup of user, etc):
In the tag:
#MyDayValue#
...
Is there an easy way to pass Form variables to my new CFC to process?
ThisRotaDetailAttributes = CreateObject("Component",
callout.modules.DB_components.database_rota_attributes");
TestVariable = ThisRotaDetailAttributes.RollingRotaUpdate(url.rid);
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192884
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Passing FORM variables to Components?
Hi all,
I have an old CF app that is passing a *varying number* of FORM variables to a
custom tag using (varies
according to setup of user, etc):
In the tag:
#MyDayValue#
...
Is there an easy way to pass Form variables to my new CFC to process?
ThisRotaDetailAttributes = CreateObject("Component",
callout.modules.DB_components.database_rota_attributes");
TestVariable = ThisRotaDetailAttributes.RollingRotaUpdate(url.rid);
Thanks,
Rob
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192881
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX SOAP / XML tutorial?
Evening all It's probably just me but I canna find a decent tutorial on SOAP / XML for CFMX. I'm a soap / xml novice, so the basics definitely need explaining to me! e.g. I've got this VB.NET code to convert, but would I do this with a CFINVOKE? Dim sessionID As String = "" Public Sub testlogin() Dim ov As New authenticationService ' Construct Request Object Dim lr As New loginRequest Dim lrol As New loginRequestOvLogin Dim lrolr As New loginRequestOvLoginRequest ' Set Parameter (ADD UID AND PASSWORD HERE) lrolr.userid = "atestAccount" lrolr.pwd = "aPassword" lrol.request = lrolr lr.ovLogin = lrol ' Send Login Dim lrp As loginResponse = ov.login(lr) sessionID = ov.headerValue.ovHeader.sessionid End Sub ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187751 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFScheduler and java mail exceptions....
Sorry for bumping this, but *any help it appreciated! Thanks Rob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 29 November 2004 10:45 am To: CF-Talk Subject: CFScheduler and java mail exceptions Morning all I've got a scheduled task that distributes about 1400 e-mails to our users. Recently though it's only been sending about 1000 of these e-mails: the remaining 400 do not send (have to send manually). There is nothing in the application.log, but the following is in MailSent.log (x400 lines): "Information","scheduler-4","11/29/04","09:48:35",,"Moved undelivered mail: Mail56511.cfmail to C:\CFusionMX/Mail/Undelivr directory" And the following is in the exception.log (x400 times): "Error","scheduler-4","11/29/04","09:48:35",,"220 tmcmon02-lgn.penmail.bt.com NTMail (v4.30.0013/NT2289.01.57849cd5) ready for ESMTP transfer" javax.mail.MessagingException: 220 tmcmon02-lgn.penmail.bt.com NTMail (v4.30.0013/NT2289.01.57849cd5) ready for ESMTP transfer at com.sun.mail.smtp.SMTPTransport.issueCommand(SMTPTransport.java:879) at com.sun.mail.smtp.SMTPTransport.helo(SMTPTransport.java:511) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:243) at javax.mail.Service.connect(Service.java:234) at coldfusion.mail.MailSpooler.getConnection(MailSpooler.java:871) at coldfusion.mail.MailSpooler.deliver(MailSpooler.java:744) at coldfusion.mail.MailSpooler.sendMail(MailSpooler.java:674) at coldfusion.mail.MailSpooler.deliverStandard(MailSpooler.java:947) at coldfusion.mail.MailSpooler.run(MailSpooler.java:912) at coldfusion.scheduling.ThreadPool.run(ThreadPool.java:201) at coldfusion.scheduling.WorkerThread.run(WorkerThread.java:70) Any ideas as to what I should be looking at to get this fixed? Cheers rob ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185692 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFScheduler and java mail exceptions....
Morning all I've got a scheduled task that distributes about 1400 e-mails to our users. Recently though it's only been sending about 1000 of these e-mails: the remaining 400 do not send (have to send manually). There is nothing in the application.log, but the following is in MailSent.log (x400 lines): "Information","scheduler-4","11/29/04","09:48:35",,"Moved undelivered mail: Mail56511.cfmail to C:\CFusionMX/Mail/Undelivr directory" And the following is in the exception.log (x400 times): "Error","scheduler-4","11/29/04","09:48:35",,"220 tmcmon02-lgn.penmail.bt.com NTMail (v4.30.0013/NT2289.01.57849cd5) ready for ESMTP transfer" javax.mail.MessagingException: 220 tmcmon02-lgn.penmail.bt.com NTMail (v4.30.0013/NT2289.01.57849cd5) ready for ESMTP transfer at com.sun.mail.smtp.SMTPTransport.issueCommand(SMTPTransport.java:879) at com.sun.mail.smtp.SMTPTransport.helo(SMTPTransport.java:511) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:243) at javax.mail.Service.connect(Service.java:234) at coldfusion.mail.MailSpooler.getConnection(MailSpooler.java:871) at coldfusion.mail.MailSpooler.deliver(MailSpooler.java:744) at coldfusion.mail.MailSpooler.sendMail(MailSpooler.java:674) at coldfusion.mail.MailSpooler.deliverStandard(MailSpooler.java:947) at coldfusion.mail.MailSpooler.run(MailSpooler.java:912) at coldfusion.scheduling.ThreadPool.run(ThreadPool.java:201) at coldfusion.scheduling.WorkerThread.run(WorkerThread.java:70) Any ideas as to what I should be looking at to get this fixed? Cheers rob ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185499 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
IIS 6.0 HTTP/1.1 - 1.0 Problem!!
Morning all, A group of users are accessing one of our sites behind a firewall, and the said site has recently been moved to a cfmx server on IIS 6. They access through a 'SRP' server which sends all requests with a HTTP/1.0 header, but our new server does not seem to like this and responds with a 'Bad Request' message with a HTTP1.1 header. How do we configure our new server to accept HTTP/1.0 header requests and respond using the same?? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFmail - From = 'no-one!'
For anyone that cares it was because the sender name had a space in the name - whether it's a valid e-mail address doesn't seem to matter! Bizarre. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 30 September 2004 1:54 pm To: CF-Talk Subject: Re: CFmail - From = 'no-one!' [EMAIL PROTECTED] wrote: > That might well be, but even if we do use a valid e-mail address, the resultant e-mail sender is completely blank. Have you looked at the source of the email as you receive it to make sure it is not some problem on the recipient side? Are you sure it is not some mailer in between that removes it? Try to enable spooling to disk and take a look at what is in the spooldir to find out. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFmail - From = 'no-one!'
That might well be, but even if we do use a valid e-mail address, the resultant e-mail sender is completely blank. This must be a global admin setting??? Thanks rob I would hope that any mailserver nowadays rejects email where the envelope-from is syntactically invalid. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFmail - From = 'no-one!'
Jochem I have tried that, but still blank. With CF5 we were using just a text entry (i.e. not a valid e-mail address). Surely it shouldn't matter if it's not a valid e-mail address, though? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 30 September 2004 11:36 am To: CF-Talk Subject: Re: CFmail - From = 'no-one!' [EMAIL PROTECTED] wrote: > > We recently moved an app from CF5 to CFMX, and the only thing (thankfully!) that seems to be a problem is the from="" parameter of CFMAIL - the sender is always recorded as nothing/no-one/blank in e-mails sent through cfmail on the cfmx server. The exact same CFMAIL block on the CF5 server had a sender in the e-mail that matched the From="Dave Smith" parameter. Are you using a valid emailaddress as From? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFmail - From = 'no-one!'
Morning all, We recently moved an app from CF5 to CFMX, and the only thing (thankfully!) that seems to be a problem is the from="" parameter of CFMAIL - the sender is always recorded as nothing/no-one/blank in e-mails sent through cfmail on the cfmx server. The exact same CFMAIL block on the CF5 server had a sender in the e-mail that matched the From="Dave Smith" parameter. Is there a global setting in the admin panel that affects this, because we can't see anything? Thanks Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Pinging servers from within Coldfusion?
Hi all, I'm sending SMS messages to a provider using CFHTTP. They have supplied me with two gateway addresses, so I've built in a bit of logic to send to another gateway if the first one is not reachable, which works fine. I was thinking though would it possible to ping each server before performing the actual HTTP POST to determine which one responds the fastest and save the extra time would be incurred as CFHTTP timeouts one attempted POST. I know there is a timeout setting in CFHTTP, but thought it would be more efficient to determine which host is more responsive without having to timeout a connection... Many thanks, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Coldfusion MX on SuSe? (And ideally MySQL...)
Hi All, I've got a (fairly beefy) server sitting upstairs working as a router for the cable connection we've got. I thought to myself, why don't I set this up as a dev server for my CFMX apps? The problem is, it's a SuSe linux distro, and I know next to nothing about setting up CFMX on unix, or integrating apache and MySQL with it. Basically I'm asking if any one has got any advice, or a step-by-step idiots guide on the web would be useful. And of course, it'd be handy to know if CFMX & suse & mysql & apache actually works! At a later stage I'd like to run PHP - can this integrate into my CFMX setup without the two crossing swords? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Access a web site through the coldfusion server -retry?
Hi all, Hope your summer weather's better than it is here. :-( I need to do this: You Need you to check via a browser from bridgesupport.intra.dsd.com (i/p address 147.149.139.81) what response you get from http://sms.labs.dsd.com/ipinfo How would I do this? bridgesupport.intra.dsd.com is the remote Coldfusion server for which I have no admin access. Would this be a CFHTTP job? Thanks Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Access a web site through the coldfusion server?
Hi all, Hope your summer weather's better than it is here. :-( I need to do this: - You Need you to check via a browser from bridgesupport.intra.dsd.com (i/p address 147.149.139.81) what response you get from http://sms.labs.dsd.com/ipinfo - How would I do this? bridgesupport.intra.dsd.com is the remote Coldfusion server for which I have no admin access. Would this be a CFHTTP job? Thanks Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Fallback DSN/Database switching?
Thanks brian, I was thinking something along those lines, but thought there might be more to it! I'll give it a try. -Original Message- From: G [mailto:[EMAIL PROTECTED] Sent: 24 June 2004 5:28 pm To: CF-Talk Subject: Re: Fallback DSN/Database switching? This is a very simplistic idea, but in your application.cfm you could test the connection to your primary datasource by running a simple query against the DB, then use CFCATCH to detect any connection errors. If you detect an error, you can change your datasource to the next database, and try again. Could keep running the same piece of code until you either hit a good DB, or run out of datasources. HTH, Brian - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Thursday, June 24, 2004 11:22 AM Subject: Fallback DSN/Database switching? Hi all, I've been wondering... I've got an application that needs to be up pretty much all the time, and if the database goes down for whatever reason we need to do an 'auto switch' to a mirrored database on another machine. Has anyone had any experience of this? Is there a way in Coldfusion to test a DSN, say in the application.cfm, and if it doesn't work switch to another DSN which points to the mirror? *Any* advice regarding this would be v. helpful. Thanks, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Fallback DSN/Database switching?
Hi all, I've been wondering... I've got an application that needs to be up pretty much all the time, and if the database goes down for whatever reason we need to do an 'auto switch' to a mirrored database on another machine. Has anyone had any experience of this? Is there a way in Coldfusion to test a DSN, say in the application.cfm, and if it doesn't work switch to another DSN which points to the mirror? *Any* advice regarding this would be v. helpful. Thanks, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Application Scope goes missing... HELP!!
John, setClientCookies = "Yes" SessionManagement="Yes" SessionTimeout="#CreateTimeSpan(0,1,0,0)#" applicationTimeout = "#CreateTimeSpan(0,8,0,0)#"> -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 17 June 2004 3:48 pm To: CF-Talk Subject: RE: Application Scope goes missing... HELP!! What's your timeout set to for the app? John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Application Scope goes missing... HELP!!
Raymond, The Application dump was captured after the query had happened and was sent to me using the error exception in Application.cfm: It seems to be happening to random queries for random users - if I go to test the query as a logged on user that has just flagged an error it works fine and I myself have never got a 'Error resolving parameter APPLICATION.CALLOUTSCHEMA' error while developing the application! Out of the four errors I've received for this problem (today), two errors had the four correct Application variables stored (shown in a dump) and two had no application scope variables at all - it just seems completely random. Is there something I'm setting wrong in the Application.cfm - Session/Application scope timeout conflicts?? Cheers, Rob -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 17 June 2004 2:11 pm To: CF-Talk Subject: RE: Application Scope goes missing... HELP!! That seems odd for sure. Did you put your cfdump right above the query that causes the error? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Application Scope goes missing... HELP!!
Hi Raymond,
Sorry for late reply.
Here's the application scope dump straight after the Error occurs. As you can see the application.calloutschema exists, which makes things even more worrying!!
Application dump:
BRIDGESCHEMA SA
BRIDGETABLEPREFIX TABLE
CALLOUTSCHEMA CALLOUT
CALLOUTTABLEPREFIX CALL
USERSINFO 25 {ts '2004-06-17 09:38:25'}
Error:
MESSAGE An error occurred while evaluating the _expression_:
#Application.CalloutSchema#
Error near line 66, column 11.
Error resolving parameter APPLICATION.CALLOUTSCHEMA
The application variable CALLOUTSCHEMA does not exist. The cause of this error is very likely one of the following things:
The name of the application variable has been misspelled.
The application variable has not yet been created.
The application variable has timed out.
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: 16 June 2004 12:35 pm
To: CF-Talk
Subject: RE: Application Scope goes missing... HELP!!
If you add a , what do you see?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Application Scope goes missing... HELP!!
Apologies again, looks like a filter cuts out anything below lots of '-': Sorry for second post, original error message got snipped: An error occurred while evaluating the _expression_: #Application.CalloutSchema# Error near line 89, column 10. Error resolving parameter APPLICATION.CALLOUTSCHEMA The application variable CALLOUTSCHEMA does not exist. The cause of this error is very likely one of the following things: The name of the application variable has been misspelled. The application variable has not yet been created. The application variable has timed out. The error occurred while processing an element with a general identifier of (#Application.CalloutSchema#), occupying document position (89:9) to (89:35) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: SQL query style (WAS: SQL search query)
James, Not sure about the join fashion trend (I use the WHERE clause), but I'm pretty sure using cfqueryparam increases query speeds and improves security (from unautorised users: cfqueryparam Verifies the data type of a query parameter and, for DBMSs that support bind variables, enables ColdFusion to use bind variables in the SQL statement. Bind variable usage enhances performance when executing a cfquery statement multiple times. This tag is nested within a cfquery tag, embedded in a query SQL statement. If you specify optional parameters, this tag performs data validation. Macromedia recommends that you use the cfqueryparam tag within every cfquery tag, to help secure your databases from unauthorized users. >From http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b20.htm -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 16 June 2004 11:47 am To: CF-Talk Subject: SQL query style (WAS: SQL search query) While we are on the subject I have noticed recently that more and ore people are joining tables using the... FROM table1 x JOIN table2 y ON x.ID = y.ID And I am wondering if there is a reason for this. Sure I use this syntax for my outer joins but inner joins I still do the old fashioned way in the where clause, for example FROM table1 x, table2 y WHERE x.ID = y.ID This has the added benefit of taking the place of the 'WHERE 0=0' line we recently discussed. What are the benefits of one form of inner join over the other or is it just today's SQL fashion trend? Secondly I notice more and more use of the cfqueryparam tag, what is wrong with simply using WHERE x.ID = #form.id# AND y.var = '#url.string#' type formatting? I have been doing this for about 5 years now and have NEVER found a need for the cfqueryparam tag, I just find it makes the code harder to read. Comments anyone? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Application Scope goes missing... HELP!!
Sorry for second post, original error message got snipped: An error occurred while evaluating the _expression_: #Application.CalloutSchema# Error near line 89, column 10. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Application Scope goes missing... HELP!!
Hi all, Having sporadic and pretty serious problems with the Application scope, which I'm using to store my database's schema name. Here's my Application.cfm: setClientCookies = "Yes" SessionManagement="Yes" SessionTimeout="#CreateTimeSpan(0,1,0,0)#" applicationTimeout = "#CreateTimeSpan(0,8,0,0)#"> Application.BridgeSchema = "B"; Application.BridgeTablePrefix = "TABLE"; Application.CalloutSchema = "CALLOUT"; Application.CalloutTablePrefix = "CALLDEVT"; Application.BridgeSchema = "A"; Application.BridgeTablePrefix = "TABLE"; Application.CalloutSchema = "CALLOUT"; Application.CalloutTablePrefix = "CALL"; An example query that flagged an error: select APPLICATION_REF As ThisApplicID, app.rota_ref As RotaID, rota_name As RotaName, GROUP_NAME As GroupName, application As ApplicationName from #Application.CalloutSchema#.#Application.CalloutTablePrefix#_APPLICATION app, #Application.CalloutSchema#.#Application.CalloutTablePrefix#_GENERIC_GPS generic, #Application.CalloutSchema#.#Application.CalloutTablePrefix#_MSTR_ROTA rot WHERE app.rota_ref = rot.rota_ref AND rot.ROTA2GROUP_ID = generic.GROUP_ID ... And the error message: An error occurred while evaluating the _expression_: #Application.CalloutSchema# Error near line 36, column 13. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Popularity of Cold Fusion
Yeah that is a bit strange: you see very few sites within BT running ASP: it's all (mostly) cfm. -Original Message- From: David Ashworth [mailto:[EMAIL PROTECTED] Sent: 02 April 2004 9:25 am To: CF-Talk Subject: RE: Popularity of Cold Fusion not sure how reliable the survey is given the statement: "Other large enterprises utilising ASP.NET include British Telecom " but a visit to bt.com defaults to: http://www.bt.com/index.jsp tesco too appears to use java servlets too or have I missed something here? -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: 02 April 2004 03:21 To: CF-Talk Subject: Popularity of Cold Fusion I just came across an article that was published last week on netcraft regarding the popularity of ASP.net.. Interesting to see where Cold Fusion comes on the graph and it doesn't even get a mention! ava_ servlets.html> http://news.netcraft.com/archives/2004/03/23/aspnet_overtakes_jsp_and_ja va_s ervlets.html Paul _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Application variable keeps 'disappearing'
> Are you doing development on a shared host? Yikes! Just so you know, this > may eventually result in getting kicked off your hosting provider (assuming > they are a reputable company). Nah, it's a shared development server on the intranet! > If it's a development server in your company that you simply don't have > CFAdmin access to, you should ask your admin what the default timeout and > max timeouts are. I'm guessing that the application timeout length is less than the session timeout I'm setting in Application.cfm, so I'll set the application timeout in application.cfm to the same. For some reason I'd got it into my head that application timeout length could only be set from the Administrator... Thanks for your help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Application variable keeps 'disappearing'
Bizarre - half the message got cut off. Here's the error: Error near line 143, column 10. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Application variable keeps 'disappearing'
Cameron, APPLICATION.CALLOUTSCHEMA isn't used in email_error_report.cfm - all that's going on there is mailing a dump of the error scope to me. I'm using CF 5.0 (sadly). I'm not sure what the application timeout is set in the admin panel as I don't have access to it. Is this different to the session timeout set in Application.cfm? Can the Application timeout be set in Application.cfm? Would you recommend using session vars instead to define my db tables/schema? Sorry for all the questions ;-) The exact error is: An error occurred while evaluating the _expression_: #Application.CalloutSchema# Error near line 143, column 10. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Application variable keeps 'disappearing'
Hi everyone, I'm using the application scope to store the names of the tables and schema to access for an application, set in Application.cfm. Occasionally I'm getting error reports saying that a variable parameter cannot be resolved (and it's always the same one: APPLICATION.CALLOUTSCHEMA). The user has to be logged in and is set a session, but these exceptions seem to be occurring when the user is legitimately logged in. Here's a snippet of Application.cfm: setClientCookies = "Yes" SessionManagement="Yes" SessionTimeout="#CreateTimeSpan(0,1,0,0)#"> Anyone got any ideas why I'm getting this resolving parameter error? Are there any application timeout issues I need to look at? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
localhost:8500 slower than remote host!
Hi again all, Anyone got any ideas why my localhost:8500 Coldfusion server is slower to access/process a page than if the same page were accessed on my remote development coldfusion server? Both Coldfusion servers are geographically at different locations across the uk, but both access the same DB server (which is hosted on another site). All are on the same network. Any suggestions to improve my localhost's performance? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Remove special chars to pass in URL
Hi everyone, Say if I wanted to pass this into a URL: AC(DB)&B(SD) As a single URL variable value, how do I remove special characters? Cheers [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strip HTML from String
Hi Neal, Try: ReReplace(Form.CalloutComments,"<[^>]*>"," ","ALL") Where 'Form.CalloutComments' is your string. Pretty simplistic, but it works. I'm sure someone will come up with something else..! -Original Message- From: Bailey, Neal [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 5:40 pm To: CF-Talk Subject: Strip HTML from String Hello everyone... I saw a while back that someone either posted a snippet or a link to a tag somewhere that would strip out HTML tags from a string. I tried looking though my e-mail but cant seem to find it, also tried looking on a few exchanges but they did not do what I needed. Basically if I have a string that looks like this: code to strip Here is some sample test with a end output of striped code Here is some sample test with a link. end Thanks for any help... Neal Bailey Internet Marketing Manager E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Include a CFMODULE with CFHTMLHEAD?
Thanks barney, I'll give it a whirl. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: 25 February 2004 7:27 pm To: CF-Talk Subject: RE: Include a CFMODULE with CFHTMLHEAD? Cheers, barneyb > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 25, 2004 9:06 AM > To: CF-Talk > Subject: Include a CFMODULE with CFHTMLHEAD? > > Hi everyone, > > I'd like to include a _javascript_ validation bunch of > functions in the header using CFHTMLHEAD. Problem is, this > _javascript_ is called normally using CFMODULE (Attributes have > to set certain JS variables). Is there a way to include the > returned contents of the CFMODULE (the _javascript_) in the > HTML head using CFHTMLHEAD? > > Cheers, > Rob > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Include a CFMODULE with CFHTMLHEAD?
Hi everyone, I'd like to include a _javascript_ validation bunch of functions in the header using CFHTMLHEAD. Problem is, this _javascript_ is called normally using CFMODULE (Attributes have to set certain JS variables). Is there a way to include the returned contents of the CFMODULE (the _javascript_) in the HTML head using CFHTMLHEAD? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMODULE with CFHTMLHEAD?
[Apologies if this occurs twice; I've sent it an hour ago but hasn't appeared on the list so I'm presuming it's gone down the blackhole route.] Hi everyone, I'd like to include a _javascript_ validation bunch of functions in the header using CFHTMLHEAD. Problem is, this _javascript_ is called normally using CFMODULE (Attributes have to set certain JS variables). Is there a way to include the returned contents of the CFMODULE (the _javascript_) in the HTML head using CFHTMLHEAD? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Using Application scope to name DB tables?
Well if you've been using it since CF4.0, don't see why I shouldn't use it now! -Original Message- From: Andrew Peterson [mailto:[EMAIL PROTECTED] Sent: 19 February 2004 2:58 pm To: CF-Talk Subject: RE: Using Application scope to name DB tables? >> Is it generally frowned upon to use the application scope (defined in Application.cfm) to name SQL tables in queries I donâEUR(tm)t know whether it is frowned upon or not, but weâEUR(tm)ve used this method since CF 4.0 without issue. â~º Sincerely, Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Using Application scope to name DB tables?
Is it generally frowned upon to use the application scope (defined in Application.cfm) to name SQL tables in queries? Will this affect perfomance at all? Any other issues? SELECT * FROM #Application.TableSchema#.#Application.TablePrefix#_EMPLOYEE I need to do this really as table names in my application (and tablespace) may potentially change at a later date... Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Multiple SQL queries in one CFquery?
Thanks for the tip - am now getting my hands dirty with Oracle stored procedures! Yum -Original Message- From: Josh [mailto:[EMAIL PROTECTED] Sent: 14 February 2004 3:49 pm To: CF-Talk Subject: Re: Multiple SQL queries in one CFquery? even better, write a stored proc! --- Exciteworks -- expert hosting for less! http://exciteworks.com specializing in reseller accounts [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Multiple SQL queries in one CFquery?
Heh, one step a time. I'm pretty new to all this... -Original Message- From: Josh [mailto:[EMAIL PROTECTED] Sent: 14 February 2004 3:49 pm To: CF-Talk Subject: Re: Multiple SQL queries in one CFquery? even better, write a stored proc! --- Exciteworks -- expert hosting for less! http://exciteworks.com specializing in reseller accounts [EMAIL PROTECTED] wrote: > Afternoon all, > > Basically I've got three cfqueries in a transaction which I think can > be combined into one - and therefore making the database do the hard > work instead of CF. I'm using Oracle 8i by the way. > > What I'd like to do is this: > > > SELECT X, Y, Z > FROM TABLE > WHERE Z = 2 > > IF RECORD COUNT = 0 -- Record count of prev. SELECT statement > INSERT INTO TABLE > VALUES (1, 2, 3) > > ELSE -- RECORD COUNT GTE 1 > UPDATE TABLE > SET X = 1 > Y = 2 > Z = 3 > END IF > > > Is this possible in Oracle 8i & CF 5.0? > > Cheers, > Rob > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Multiple SQL queries in one CFquery?
Afternoon all, Basically I've got three cfqueries in a transaction which I think can be combined into one - and therefore making the database do the hard work instead of CF. I'm using Oracle 8i by the way. What I'd like to do is this: SELECT X, Y, Z FROM TABLE WHERE Z = 2 IF RECORD COUNT = 0 -- Record count of prev. SELECT statement INSERT INTO TABLE VALUES (1, 2, 3) ELSE -- RECORD COUNT GTE 1 UPDATE TABLE SET X = 1 Y = 2 Z = 3 END IF Is this possible in Oracle 8i & CF 5.0? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Application logging & normalisation?
Hi all, Just like your thoughts on this. I've got an application well on the way, with a fully normalised & relational (we'll say it is for arguments sake!) Oracle database running the show underneath. I've got a db table dedicated to keeping logs of the activity this application will produce, which in keeping with the relational model has about 5 links to other tables. Bearing in mind this log table will store a significant amount of data when the applications fully operational - and the data will act as an audit trail - do you recommend: a) Keep the table relational with the rest of the database (5 table links, potential for slow querying to produce reports) b) Have the table as a 'dump' whereby all data except the primary key is inserted and there are not relational links (faster querying for reports) c) Any other suggestions? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Two Destinations for POST form?
Mike, Thanks, I'm making progress now with CFHTTP and CFHTTPPARAM. One problem remains: I'd prefer for the user to see the results of the SMS send, rather than the results of the DB update which is all I can seem to get returned to the user - is there anyway to set CFHTTP to make sure all that is returned from the user is the result of the remote form post? Here is what I've got: UPDATE RAS.TABLE_CALL_LOG SET X_CALL_LOG_NOTES = WHERE X_CALL_LOG_ID = ; -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: 12 January 2004 12:51 pm To: CF-Talk Subject: RE: Two Destinations for POST form? Do an initial post to a local page, then insert these details. Then you can do a CFHTTP post to the SMS provider HTH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 12:47 To: CF-Talk Subject: Two Destinations for POST form? Afternoon all, I trust you had a good weekend? I've got a form that sends a textarea message to an SMS service. This is simple enough, but I want to record the very same message (and who sent it) on the local site's database, meaning the form would have to POST to two destinations. Is this possible? Any ideas? Cheers, Rob _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Two Destinations for POST form?
Afternoon all, I trust you had a good weekend? I've got a form that sends a textarea message to an SMS service. This is simple enough, but I want to record the very same message (and who sent it) on the local site's database, meaning the form would have to POST to two destinations. Is this possible? Any ideas? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Storing big queries in Application Scope to search?
Pete / Calvin, What I really wanted to know is is storing this large query in an application scope and searching the structure using a function such as StructFind to perform a search a 100 times or so in a loop a generally accepted practice? Am I on the right lines using this code (it currently doesn't work!): type="exclusive" scope="application"> SELECT * FROM SAF.DAILY_ROTA WHERE ROTA_REF = type="exclusive" scope="application"> #StructFind(application.ThisForecastResults, "#i#")# -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: 19 December 2003 10:11 am To: CF-Talk Subject: Re: Storing big queries in Application Scope to search? How would you make the cached query solution viable on a load balanced solution with non-sticky sessions? - Calvin - Original Message - From: Pete Freitag To: CF-Talk Sent: Thursday, December 18, 2003 5:27 PM Subject: Re: Storing big queries in Application Scope to search? [EMAIL PROTECTED] wrote: > Hi all, > > Anyone know why this won't work? Its got me stumped! Also, any > comments on whether it's good practice to use the application scope to > store a large set of query results would be useful (i.e. to refer to > that set of results in a loop instead of hammering the database 100's > of times...). Use query of queries instead? Hope someone can see what > I'm getting at! Hi Rob, why not just use a cached query? it is essentially doing the same thing, but is easier to code/read, and allows you to set a different timeout for each query. ___ Pete Freitag http://www.cfdev.com/ Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Storing big queries in Application Scope to search?
Hi all, Anyone know why this won't work? Its got me stumped! Also, any comments on whether it's good practice to use the application scope to store a large set of query results would be useful (i.e. to refer to that set of results in a loop instead of hammering the database 100's of times...). Use query of queries instead? Hope someone can see what I'm getting at! type="exclusive" scope="application"> SELECT * FROM SAF.DAILY_ROTA WHERE ROTA_REF = type="exclusive" scope="application"> #StructFind(application.ThisForecastResults, "802495059")# Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: 5.0 Development Practices
Yeah, I thought about doing that, but you can't perform queries... d'oh.
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 17 December 2003 7:00 pm
To: CF-Talk
Subject: RE: 5.0 Development Practices
You still have custom tags and udfs to play with.
function noSpaghetti() {
..
}
Not as good as cffunction, but still useful.
Ade
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 17 December 2003 18:35
To: CF-Talk
Subject: 5.0 Development Practices
Hi all,
I'm fairly new to CF and I've just started an Application that will run on a
Coldfusion 5.0 server.
So far from all the resources I've been reading (net and books) I'm
beginning to get pretty annoyed at its lack of 'features' compared to CFMX
6.0/6.1. So far as I can tell CF Components, CFFUNCTION etc are only
available in 6+, and I keep coming across occasions when use of that sort of
functionality would be pretty beneficial!
At the moment, my application is very 'spaghetti' code-like, with CFINCLUDES
all over the shop. Is there any way round this in CF 5.0 (and don't say
upgrade!)?
Cheers,
Rob
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
5.0 Development Practices
Hi all, I'm fairly new to CF and I've just started an Application that will run on a Coldfusion 5.0 server. So far from all the resources I've been reading (net and books) I'm beginning to get pretty annoyed at its lack of 'features' compared to CFMX 6.0/6.1. So far as I can tell CF Components, CFFUNCTION etc are only available in 6+, and I keep coming across occasions when use of that sort of functionality would be pretty beneficial! At the moment, my application is very 'spaghetti' code-like, with CFINCLUDES all over the shop. Is there any way round this in CF 5.0 (and don't say upgrade!)? Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Better method for counting records?
Hi all, I've got a main looping through a set of records - say 15 at a time - and within that loop I've got 3 SQL queries performing a count on how many associated records there are for that particular record in the main loop. Kind of like a forum index page to give how many threads, posts etc there are for each forum. i.e. (rough code to give you an idea of what I mean): select * from tablemain #SectionName# select count(case_id) As ThisCount1 from table1 where x = '#mainquery.SectionName#' #countquery1.ThisCount1# select count(case_id) As ThisCount2 from table2 where x = '#mainquery.SectionName#' #countquery2.ThisCount2# select count(case_id) As ThisCount3 from table3 where x = '#mainquery.SectionName#' #countquery3.ThisCount3# My question is, is there a more efficient method for doing this kind of thing? As the tables I am accessing have 1,000s of rows - possibly millions - the page takes a significant amount of time finish processing. I could remove the record counts altogether, but it's preferable for it to remain. Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: VB Functions --> Coldfusion?
Thanks Mike
BTW, I used ReFind("[[:upper:]]",strChar) for IsUpper()
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]
Sent: 22 October 2003 11:05 am
To: CF-Talk
Subject: RE: VB Functions --> Coldfusion?
Left() = Left()
Mid() = Mid()
IsNumeric() = IsNumeric()
CInt() = Val()
CStr() = toString()
IsUpper() = not sure about this one off hand
InStr() = Find() or FindNoCase()
Left() = Left()
HTH
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 10:57
To: CF-Talk
Subject: VB Functions --> Coldfusion?
Hi all,
New to the list/ColdFusion and need some advice from you chaps. Basically, I
want to convert a some VB to run on ColdFusion and was wondering whether
Coldfusion has an equivalent function to the following VB functions. (I need
to know whether it's worth wasting my time.)
Len() - Returns an integer containing either the number of characters in a
string or the number of bytes required to store a variable
Mid() - Returns a string containing a specified number of characters from a
string
IsNumeric() - Returns a Boolean value indicating whether an _expression_ can
be evaluated as a number.
CInt() - Returns an _expression_ that has been converted to a Variant of
subtype Integer.
CStr() - Returns an _expression_ that has been converted to a Variant of
subtype String
IsUpper() - Indicates whether a Unicode character is categorized as an
uppercase letter.
InStr() - Returns an integer specifying the start position of the first
occurrence of one string within another.
Left() - Returns a string containing a specified number of characters from
the left side of a string.
Any feedback would be very helpful.
Thanks,
Rob
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
VB Functions --> Coldfusion?
Hi all, New to the list/ColdFusion and need some advice from you chaps. Basically, I want to convert a some VB to run on ColdFusion and was wondering whether Coldfusion has an equivalent function to the following VB functions. (I need to know whether it's worth wasting my time.) Len() - Returns an integer containing either the number of characters in a string or the number of bytes required to store a variable Mid() - Returns a string containing a specified number of characters from a string IsNumeric() - Returns a Boolean value indicating whether an _expression_ can be evaluated as a number. CInt() - Returns an _expression_ that has been converted to a Variant of subtype Integer. CStr() - Returns an _expression_ that has been converted to a Variant of subtype String IsUpper() - Indicates whether a Unicode character is categorized as an uppercase letter. InStr() - Returns an integer specifying the start position of the first occurrence of one string within another. Left() - Returns a string containing a specified number of characters from the left side of a string. Any feedback would be very helpful. Thanks, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
