RE: PDF opened with CFContent Crashes browser
I am wondering if anyone has any ideas.I am opening some PDF files with CFContent using the following code: CFHEADER NAME=Content-Disposition VALUE=inline; filename=#VARIABLES.file_name# CFCONTENT TYPE=application/pdf FILE=#VARIABLES.file_location# Everything works fine on the machines I've tried in my office, however at least 3 machines in their office crash not when the PDF opens, but rather when they go to close it.A.and they use 4 or 5. I don't know if that matters though. We had a load of problems with the Fast Web View Setting in the Preferences of Acrobat 4 (maybe 5 as well) which _prevented_ the PDF from being opened in the browser. http://www.transedit.co.uk/downloading.htm Just chipping in tuppence :-) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: A Good Data Structure for a Large Binary Tree
Thanks, Steve! Very interesting info. Jack (excuse my super long email, but you might like this) I've been fascinated with binary trees for years. So much so that I've designed my own. I have used three different methods of binary trees. I'm sure there are other techniques, but I haven't tried them. Here are the advantages and disadvantages of the three methods that I know of. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Three Questions
Yes, 2003 can participate as a member server in a 2000 domain. CFMX and .Net can be deployed on the same server. -Original Message- From: Larry [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 23:01 To: CF-Talk Subject: Three Questions Anyone put 2003 in a 2000 domain? Can you deploy CFMX and .Net on the same server and can this server be a member server? Thanks L Marcus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfhttp
Hi, what is the best way to lock cfhttp when facing hi transaction traffic. I was thinking something along the lines of this cflock name=#CreateUUID()# timeout=60CFHTTP METHOD=GET URL="" PATH=#REQUEST.StoreMapRoot# FILE=#MAP_NAME##COOKIE.MAP_COUNT#.gif CFHTTPPARAM TYPE=FORMFIELD VALUE=#XML_STREAM# NAME=xmlparams /CFHTTP/cflock, We have noticed that the pages run very slow that call cfhttp when traffic is at its highest. Thanks for any advice, J. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfhttp
(...Rejoining thread with Cftalk list) John, Makes sense.From what you are saying, the HTTP requests are dependent on a web service, and that is the bottlenecking factor. This means, you won't be able to speed it up, since a web-service-request is needed per request, so serializing your requests might help sometimes, but you're assuming nobody else is also using the web service.. A web service which cant handle concurrency will probably always be your bottleneck. Here are some points to consider: 1) Locking Overhead in this case : If locking were to help (and in this case, I don't see how it would), the overhead would be minimal if you're protecting access to a slow cfhttp request.No matter what you do, you'd be queueing up requests in cf, preventing it from working on any other cf pages being served out. --- what would be nice (and maybe this is possible, I'm not totally up to speed with cf6.1's new features) is if CF could allow you to specify named queues at the server level, and specify that if this web page were to queue up on the cf server, it should go into its own queue. This would prevent (in theory, if done right) all other cf pages to wait for the bottlenecking pages. 2) Question:- Do you need these images stored on disk, or are they just stored to serve out to the user?If the latter, why not run a separate web server which may or may not be CF-based, to proxy requests to the web service, and pushes the content to the browser? You can get a cheap web server hosting account and with a little perl or server-side asp, etc. you can write a page which pushes GIF's based on query strings...i.e. img src=""> d=toweb=server'-This would take the responsibility and load off of your cf server. Just some ideas and comments... -Dov -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 6:34 AM To: Katz, Dov B (IT) Subject: RE: cfhttp Yea your right, how did I get so slack, CreateUUID will be unique per request so effectively undermining the lock. The site I am connecting to as far as I am aware supports concurrency but under heavy traffic cfhttp is slow and in some cases the image never loads. So this led me to think that locking would resolve the issue. Of course there is overhead associated with locking, and I'm wondering would locking by one unique name resolve issues with the cfhttp call. A schedule would not resolve the issue as its created on per request, the user selects what they want and longitude and lititudes are placed into xml which send hte packet to the web service, the service returns a gif image. This could'nt really be done via a schedule as its all interaction based. -Original Message- From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: 02 March 2004 10:59 To: [EMAIL PROTECTED] Subject: RE: cfhttp John, (perhaps repost to the list, it doesnt like me when I use outlook web access) CFLOCK doesn't seem to buy you anything here, especially since the name is unique, and presumably no other lock is created with the same name .. What is your logic? How are you trying to protect from a slowdown? If you are periodically getting images, you might want to run scheduled tasks independently of use of the web app. The bottom line is, I don't understand how you are trying to save the server any work... I usually use CFLOCK like below... CFIF i DONT need to do the intense operations do something with the results of the last run of the intense operations if i am reading from a file i might write within the lock below, i might cflock around the CFFILE read only... with a timeout... CFELSE CFLOCK type=exclusive name=MyLockName LOAD INTENSIVE OPERATIONS, If you are performing an operation which is generating or downloading files, I'd start with a temp file, and then rename it in a single operation. That way if it fails, you lose nothing /CFLOCK /CFIF HTH -dov -Original Message- From: John mccosker [mailto:[EMAIL PROTECTED] Sent: Tue 3/2/2004 4:42 AM To: CF-Talk Cc: Subject: cfhttp Hi, what is the best way to lock cfhttp when facing hi transaction traffic. I was thinking something along the lines of this cflock name=#CreateUUID()# timeout=60CFHTTP METHOD=GET URL="" PATH=#REQUEST.StoreMapRoot# FILE=#MAP_NAME##COOKIE.MAP_COUNT#.gif CFHTTPPARAM TYPE=FORMFIELD VALUE=#XML_STREAM# NAME=xmlparams /CFHTTP/cflock, We have noticed that the pages run very slow that call cfhttp when traffic is at its highest. Thanks for any advice, J. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMail problem
Pretty general question, but one thing might be the number of emails you are trying to send. You might be getting timed out if you are sending a large number. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 CFMail is acting up on me.The same exact tag works only sporadically.I know this is a vastly general question, but does anyone have any experience with the idiosyncracies of the CFMail tag?Is there a list of things that could possibly make the CFMail tag act up? Using CF5. Thanks, Les [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
Have you tried using GenericCursorType for your cursor type? That works for me. (I can give you a sample stored proc that's working for me, if that would be helpful.) - Original Message - From: Richard Crawford [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 01, 2004 6:38 PM Subject: Oracle and Cold Fusion Still having issues. Here is the Stored Procedure in question: == CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT types.cursorType ) as sFirst varchar2(50); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; fetch studentInfo into sFirst, sLast, sOrient; close studentInfo; end; / == And here is where it is called in my Cold Fusion page: == cfstoredproc datasource=DLCampus procedure=dlc_sp_getStudentInfo cfprocparam type=in value=#cookieID# cfsqltype=cf_sql_number cfprocresult name=getName /cfstoredproc == In the database, the table tblStudentInfo is set up as this: == sID number sFirst varchar2(50) sLast varchar2(50) sOrient char(1) == When I execute the stored procedure by going to the CF page in a browser, I get the following error: == Error Executing Database Query. [Macromedia][Oracle JDBC Driver]Unsupported data conversion. == I'm still at a loss, and I can't see what else I can do.Anyone got any suggestions? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Three Questions
yes: no problem with that yes: actually in our intranet server we have CF 6.1 and .NET yes: exactly it's what we have Regards __ MSc. Hassan Arteaga Rodrguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. _ From: Larry [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 06:01 PM To: CF-Talk Subject: Three Questions Anyone put 2003 in a 2000 domain? Can you deploy CFMX and .Net on the same server and can this server be a member server? Thanks L Marcus _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
On Tuesday 02 Mar 2004 13:29 pm, Deanna Schneider wrote: Have you tried using GenericCursorType for your cursor type? That works for We do something like ref_cursor is REF CURSOR and return ref_cursor type. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
global variables for CFCs
Quick question regarding CFCs and global variables.I know that you can create an application.cfm file in your webroot and then if you call a CFC from there, the CFC will have the variables available to it that are set in that file (correct?).I'm trying to build some CFCs for managing some different things on my websites. I'm curious what the best practice is for storing global variables like datasource names, etc.Do you usually just do it in the application.cfm from the directory you're calling or is there some best practice for CFCs? John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
How do I get ...
I've got an event table where I may pull several records of events for a single date. How do I single out the record with the latest start time (time field in MySQL)? Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX Hanging Solutions?
I've been scouring the forums here and on Macromedia regarding CFMX hangs.I have a page on my site that takes more than 1000ms to return (runs about 10 big queries).If I get on this page and hit F5 over and over again, I can see jrun.exe memory size and thread count expand.The memory size never is the issue -- it's the thread count.When it goes over 100, it seems like the machine hangs.Eventually, it does respond, but while it's hanging, the site is cooked. So here's my question: Is it possible for me to wrap a CFLOCK around that entire page, to isolate it to a single thread?It isn't an often-visited page, so I could probably get away with this. Eventually, I'll need break up the query/page...looks like I'll have to do this.Oh, and by the way, whenever I use JDBC drivers, this issue is far worse...so I use ODBC Socket for everything.My setup is Win2K on a dual pentium 5 with 2GB RAM and SQL 7.0.Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX Hanging Solutions?
I've been scouring the forums here and on Macromedia regarding CFMX hangs.I have a page on my site that takes more than 1000ms to return (runs about 10 big queries).If I get on this page and hit F5 over and over again, I can see jrun.exe memory size and thread count expand.The memory size never is the issue -- it's the thread count.When it goes over 100, it seems like the machine hangs.Eventually, it does respond, but while it's hanging, the site is cooked. So here's my question: Is it possible for me to wrap a CFLOCK around that entire page, to isolate it to a single thread?It isn't an often-visited page, so I could probably get away with this. Eventually, I'll need break up the query/page...looks like I'll have to do this.Oh, and by the way, whenever I use JDBC drivers, this issue is far worse...so I use ODBC Socket for everything.My setup is Win2K on a dual pentium 5 with 2GB RAM and SQL 7.0.Thanks! - Sung [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX6.1 in J2EE deployment
Is anyone else experiencing issues with it refusing to answer - the web browser just spins ? We had a serious issue like this today, on three unconnected separate boxes and installs, running different codebases against three different Oracle 9i databases. The only common feature betwen the systems was the CFMX version, and rough time of failure (one of the boxes was fine, till we tried to restart it, then it failed in this manner). Reinstalling by unpacking the .war again seems to fix it. We're on WebLogic 7 with latest SP, if that helps. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
File Exists
How do I check for the existence of a file on the server? Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: global variables for CFCs
On Tuesday 02 Mar 2004 13:46 pm, Burns, John wrote: calling or is there some best practice for CFCs? All your objects should have an init() method, that takes for instance, a dsn name. You'll then have some sort of bootstrap code that calls each of the inits, caches them into the session scope or whatever. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX Hanging Solutions?
On Tuesday 02 Mar 2004 13:53 pm, Sung J. Woo wrote: Is it possible for me to wrap a CFLOCK around that entire page, to isolate it to a single thread? Yes. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: File Exists
FileExists() -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: dinsdag 2 maart 2004 14:57 To: CF-Talk Subject: File Exists How do I check for the existence of a file on the server? Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: File Exists
FileExists() -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 8:57 AM To: CF-Talk Subject: File Exists How do I check for the existence of a file on the server? Cutter _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF render of CSS
That was it - thanks Ben!
It is probably the # that is the problem, CF is looking for a matching # and
is finding the { (which it does not like). Escape the # as ##.
##back {
}
Maybe the question is how do you output special characters?
The CSs code is:
#back {
}
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD20742-2611
301-405-2545 Phone
www.phi.umd.edu
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: CFMX Hanging Solutions?
Sung, Not an answer to the hang, but you might be able to speed up the page (and possibly prevent the hang) by moving the queries to a stored procedure. The speed increase is dramatic. Steve -Original Message- From: Sung J. Woo [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 8:54 AM To: CF-Talk Subject: CFMX Hanging Solutions? I've been scouring the forums here and on Macromedia regarding CFMX hangs.I have a page on my site that takes more than 1000ms to return (runs about 10 big queries).If I get on this page and hit F5 over and over again, I can see jrun.exe memory size and thread count expand.The memory size never is the issue -- it's the thread count.When it goes over 100, it seems like the machine hangs.Eventually, it does respond, but while it's hanging, the site is cooked. So here's my question: Is it possible for me to wrap a CFLOCK around that entire page, to isolate it to a single thread?It isn't an often-visited page, so I could probably get away with this. Eventually, I'll need break up the query/page...looks like I'll have to do this.Oh, and by the way, whenever I use JDBC drivers, this issue is far worse...so I use ODBC Socket for everything.My setup is Win2K on a dual pentium 5 with 2GB RAM and SQL 7.0.Thanks! - Sung _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
[Stats] CF-Talk: February 2004
Searchable archives for this list are available at http://www.listsearch.com/cf-talk.lass CF-Talk Stats February, 2004 Note: Up/Down % as compared with January, 2004 Posts:3308 (Up4%) Authors: 398 (Up2%) Threads: 667 (Down 2%) Top 20 Contributors by Number of Posts Dave Watts118 Barney Boisvert 113 Rob Rohan 113 Jochem van Dieten97 Thomas Chiverton 76 Matt Liotta61 Philip Arnold 57 Jamie Jackson 54 Stuart Kidd53 Pascal Peters 53 Raymond Camden48 Matt Robertson45 Tony Weeg41 Taco Fleur 39 Cameron Childress39 Burns, John36 Jim McAtee 35 Chunshen (Don) Li35 Deanna Schneider 35 Bryan Stevenson32 Top 20 Threads by Number of Posts Macromedia.com running on top of Mach II 80 MySQL and CF38 Which is quicker 31 The Dangers of Java 31 cfx_xslt problem (urgent) 29 Break the block, and SURVIVE, any way?27 Protect action pages25 Serial Number 24 How to order by days of the week, but not alphabetically in thi...24 XML Storage23 MS Update broke security23 query help... 22 Question regarding CFMX 6.222 Content Editor for the web21 Multilingual21 Access Coldfusion MX6.1 problems...sites keep dying20 ColdFusion IDEs20 serving non-CFM files w/ Cold Fusion19 mySQL date ?19 bank of america processing19 Top 20 Search Terms by Number of Requests OpenBase 2 kansas2 -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX Hanging Solutions?
Thanks for your replies, folks.I just slapped this on: cflock scope = Application timeout = 10 type = Exclusive ... code ... /cflock Seems to do the trick -- no matter how many times I bang on that page, the server never goes down.I'll also go the SP route -- I only thought people did SP for security purposes, not for performance.Thanks for all your suggestions! - Sung [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Interesting article on Macromedia Central...
http://news.com.com/2100-1012_3-5167812.html?tag=st_lh Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Symbols instead of correct CHRs in CFMX
I've got some text stored in a database that I'm querying and outputting to a page.For some reason, when we upgraded to CFMX, those characters are now coming out as weird symbols.This is happening with apostrophes, dashes, etc.Any idea why CFMX would have messed this up? John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: global variables for CFCs
I use a CFC with the same name as the app. So for cflib I have a cflib.cfc. Each of my CFCs will make an instance of this CFC when they are created. The cflib.cfc has one method, getSettings(), that returns a struct of settings (dsn, etc). My core site's application.cfm uses the same method to load its data as well. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I get ...
Hi Cutter, Sorry if I'm misunderstanding you, but it sounds like all you need to do is run a cfquery around the date with a maxrow of 1... cfquery name=maxrec datasource=dsn maxrows=1 SELECT id FROM table ORDER BY date_in_question DESC /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cell phone text messaging...
ah, this is what I've been digging to find out.Hmm, well being that AOL is kind of sort of owned by a slightly large company, they prob got the funds to do stuff, eh?cell companies get phone#'s in blocks from the FCC, so it probably is not hard to get the cell#-to-cell company relationship.Now, with WNP, how is this going to change?hmm Doug -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 9:49 AM To: CF-Talk Subject: RE: Cell phone text messaging... But how does AOL know which provider the user has?When you set it up, they don't ask what carrier you have.All you enter is your phone number. John Burns -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 6:13 AM To: CF-Talk Subject: Re: Cell phone text messaging... On Saturday 28 Feb 2004 14:53 pm, Burns, John wrote: Right, but by only giving AOL 3018675309, how does it know that it should be sent to SprintPCS? Or maybe ATT, T-mobile, Cingular, Verizon, etc? The message is just sent to whoever mobile operator the provider is connected to, and they then forward it on just as if you had entered the number into a mobile phone. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How do I get ...
How do I single out the record with the latest start time (time field in MySQL)? select * from table a where a.time = (select max(b.time) from table b) note that this query may return more than one row if the timestamps are the same... http://www.w3schools.com/sql/sql_functions.asp -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
Will Blackie said: I've tried changing over a few of my sites to use the access unicode driver but i suspect that without changing them all i may not see any dramatic improvement - the server is still crashing pretty regularly. When it crashes, are the sites that use the access unicode driver still up like MS SQL Server or are they down like the normal Access sites? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cell phone text messaging...
That's my question.I know locally, 399 has always been Nextel and many of the other exchanges were always one company or another, but now that you can switch numbers between carriers, I don't see how you'd be able to keep up unless you had a direct interface to some kind of data that matched a cell number to a carrieror if there was some kind of standard made for doing this sort of thing. John Burns -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 9:44 AM To: CF-Talk Subject: RE: Cell phone text messaging... ah, this is what I've been digging to find out.Hmm, well being that AOL is kind of sort of owned by a slightly large company, they prob got the funds to do stuff, eh?cell companies get phone#'s in blocks from the FCC, so it probably is not hard to get the cell#-to-cell company relationship.Now, with WNP, how is this going to change?hmm Doug -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 9:49 AM To: CF-Talk Subject: RE: Cell phone text messaging... But how does AOL know which provider the user has?When you set it up, they don't ask what carrier you have.All you enter is your phone number. John Burns -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 6:13 AM To: CF-Talk Subject: Re: Cell phone text messaging... On Saturday 28 Feb 2004 14:53 pm, Burns, John wrote: Right, but by only giving AOL 3018675309, how does it know that it should be sent to SprintPCS? Or maybe ATT, T-mobile, Cingular, Verizon, etc? The message is just sent to whoever mobile operator the provider is connected to, and they then forward it on just as if you had entered the number into a mobile phone. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Symbols instead of correct CHRs in CFMX
Burns, John said: I've got some text stored in a database that I'm querying and outputting to a page.For some reason, when we upgraded to CFMX, those characters are now coming out as weird symbols.This is happening with apostrophes, dashes, etc.Any idea why CFMX would have messed this up? Probably a charset issue. What charset did you use before upgrading, what charset are you using now and how did you configure your charset in the database? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cell phone text messaging...
On Tuesday 02 Mar 2004 14:43 pm, [EMAIL PROTECTED] wrote: so it probably is not hard to get the cell#-to-cell company relationship. You don't need it. You just send your SMS out via whatever text gateway you have (Gnokii and a phone, X25 to SMSC, ...). You don't need a gateway per phone company, any more than you need a mailserver per domain. Now, with WNP, how is this going to change?hmm You mean number porting between providers ? It's not a problem here in Europe, because we don't need a link to every phone co. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Symbols instead of correct CHRs in CFMX
I tried using UTF-8 and also iso-8859-1 The second is the one I had set before the upgrade.Here's the page that I'm working on: http://www.joinbrian.com/index.cfm?action=""> I do know that when I go into the phpMyAdmin MySQL interface and view the table, the text displays correctly there (and that's in html) so I'm assuming CF is doing something to the text at some point.Is there some kind of a function I can use or what might I need to do? John Burns -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 9:53 AM To: CF-Talk Subject: Re: Symbols instead of correct CHRs in CFMX Burns, John said: I've got some text stored in a database that I'm querying and outputting to a page.For some reason, when we upgraded to CFMX, those characters are now coming out as weird symbols.This is happening with apostrophes, dashes, etc.Any idea why CFMX would have messed this up? Probably a charset issue. What charset did you use before upgrading, what charset are you using now and how did you configure your charset in the database? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cell phone text messaging...
Burns, John said: That's my question.I know locally, 399 has always been Nextel and many of the other exchanges were always one company or another, but now that you can switch numbers between carriers, I don't see how you'd be able to keep up unless you had a direct interface to some kind of data that matched a cell number to a carrier That is exactly what they have. In the Netherlands the system is called COIN and is basically an SDH network over which all telco's send route this number to me from now on messages in some predefined XML format for realtime changes and a service organisation maintains a database of all allocations. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cell phone text messaging...
So there's a text gateway?Is this similar to an SMTP server?Can I just send a text to 3018675309 and send it through some gateway and it will establish the carrier or whatever and send it on? Are these gateway connections free? John Burns -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 10:02 AM To: CF-Talk Subject: Re: Cell phone text messaging... On Tuesday 02 Mar 2004 14:43 pm, [EMAIL PROTECTED] wrote: so it probably is not hard to get the cell#-to-cell company relationship. You don't need it. You just send your SMS out via whatever text gateway you have (Gnokii and a phone, X25 to SMSC, ...). You don't need a gateway per phone company, any more than you need a mailserver per domain. Now, with WNP, how is this going to change?hmm You mean number porting between providers ? It's not a problem here in Europe, because we don't need a link to every phone co. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX Hanging Solutions?
Eventually, I'll need break up the query/page...looks like I'll have to do this.Oh, and by the way, whenever I use JDBC drivers, this issue is far worse...so I use ODBC Socket for everything.My setup is Win2K on a dual pentium 5 with 2GB RAM and SQL 7.0.Thanks! I'm not sure whether the JDBC drivers included with CFMX support SQL Server 7, but in general, you'll probably get better results with CFMX against SQL Server 2000. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cell phone text messaging...
Burns, John said: So there's a text gateway?Is this similar to an SMTP server?Can I just send a text to 3018675309 and send it through some gateway and it will establish the carrier or whatever and send it on? Yes. Are these gateway connections free? No. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cell phone text messaging...
On Tuesday 02 Mar 2004 15:04 pm, Jochem van Dieten wrote: That is exactly what they have. In the Netherlands the system is called COIN We have something similar in the UK. Are these gateway connections free? No. But you can implement one cheaply with a serial cable, normal mobile phone, Linux and gnokiid. If you plan to send lots, then there are other options. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cell phone text messaging...
WNP is wireless number portabilitysomehting here in the states of recent. interesting knowledge, thanks.the states are typically behind europe and asia in this stuff.odd, eh?seeing as how telephones and cell phones were invented here. so, john, seems that if you have access to a gateway, you could send to just a cell#.otherwise you will need to get the carrier and stuff from the user.I've seen a couple of sites do the latter. Doug -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 10:02 AM To: CF-Talk Subject: Re: Cell phone text messaging... On Tuesday 02 Mar 2004 14:43 pm, [EMAIL PROTECTED] wrote: so it probably is not hard to get the cell#-to-cell company relationship. You don't need it. You just send your SMS out via whatever text gateway you have (Gnokii and a phone, X25 to SMSC, ...). You don't need a gateway per phone company, any more than you need a mailserver per domain. Now, with WNP, how is this going to change?hmm You mean number porting between providers ? It's not a problem here in Europe, because we don't need a link to every phone co. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Symbols instead of correct CHRs in CFMX
We moved some sites from a MS SQL Server DB and CF 5.0 install over to a CFMX and MySQL environment and we encountered this problem. After searching far and wide the only solution that helped was adding the following to the connection string setting under Advanced Settings for the datasource: useUnicode=truecharacterEncoding=iso-8859-1 This cleared the problem right up. HTH Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
And Now... some Services?????????????
I did a little searching here and there and it seem to mostly be apache related. We don't have any vir-dirs called services ans when we create a directory called services we get an AXIS error. What boggles me is that this happens when calling a .html file from the directory. Doesn't IIS process before CF/Jrun does? This only happens on our servers with CF on top of jrun and not our regular CFMX servers.. Dave Watts:you remember our setup, unless you are trying very hard to forget:) Do you have any ideas on this?? -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX 6.1 Session Replication on JRun 4
Has anyone been successful in setting up the session replication in CFMX 6.1 on Jrun 4? I'm trying to test it out on 1 machine (for now). I have set up 2 server instances (say Server1 and Server2) and deployed CFMX on both. I configured both instances of CFMX to allow J2EE sessions. I clustered those 2 server instances in JRun I added each of the instances as a peer to the other, and pointed the web root to the same index.cfm file. The simple INDEX.CFM for testing is as follows: CFAPPLICATION name=testapp applicationtimeout=#createtimespan(0,0,5,0)# sessionmanagement=Yes sessiontimeout=#createtimespan(0,0,1,0)# CFIF IsDefined(Session.Host) CFOUTPUT#Session.Host#/CFOUTPUT CFELSE First time here. /CFIF BRBR CFSET Session.Host = CGI.HTTP_HOST CFDUMP var=#Session.Host# Now, when I test the two instances (say loclhost:8001 and localhost:8002) I never get confirmation that a session is coming form the other instance. The weird thing (or maybe not) is that the JSessionID, CFID and CFTOKEN are the same on both calls. Any input is appreciated. thanks in advance, Igor cccfug.org [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Logging in a user: Session Variable Require Round Trip?
Hi all, It's the crux of any application. I'm maintaining state through session variables which are set within the cflogin tag on the application.cfm template. Once I verify the user, I set a variable called Session.Agency_No right there in the application.cfm tag (see code below). The problem is that I get an error that this session variable is not set, and I think I know why - a redirect is required in order for the application to set the cookie on the client, correct? This may explain the fact that if I log out (which structClears the session) and log back in, the cookie matches the session variable and the app works. In the past, I've always used a meta refresh in my login page, and I guess I still need one. So, if I need a redirect for session variables, how is it that cfLoginUser does not need one? And what is the preferred method in doing the round trip (Meta refresh, cflocation, getPageContext().forward(), etc.)? Is there any way around it? Does anyone successfully set session variables within the cflogin tag? Thanks in advance for any assistance. cflogin IDLETIMEOUT=1800 cfif cflogin.name is or cflogin.password is H2Error: You must enter text in both fields./H2 cfinclude TEMPLATE=loginform.cfm cfabort cfelse cfquery NAME=loginQuery DATASOURCE=#request.SECURITYdsn# Select a.AgencyNo, a.UserName, a.Password, b.IOCSystem, b.AccessLevel FROM WEBUsers AS a INNER JOIN IOCWebSysAccess AS b on a.AgencyNo = b.AgencyNo and a.Username=b.UserName wherea.AgencyNo = '#form.agency#' AND a.UserName = '#cflogin.name#' AND a.Password = '#cflogin.password#' /cfquery cfif loginQuery.AccessLevel NEQ cfloginuser NAME=#cflogin.name# PASSWORD = #cflogin.password# ROLES=#loginQuery.AccessLevel# CFLOCK SCOPE=SESSION TIMEOUT=100 TYPE=EXCLUSIVE cfif loginQuery.AccessLevel eq ADMIN cfset session.Agency_No = ADMIN cfset session.GroupLevel = ADMIN CFELSEIF loginQuery.AccessLevel eq IOC cfset session.Agency_No = IOC CFSET session.GroupLevel = IOC CFELSEIF loginQuery.AccessLevel eq AGY cfset session.agency_No = cfLogin.Name cfset session.groupLevel = form.Agency CFELSE cfset session.agency_No = loginQuery.AccessLevel /cfif /CFLOCK cfelse H2Your login information is not valid.br Please Try again/H2 cfinclude TEMPLATE=login.cfm cfabort /cfif /cfif /cflogin Sincerely, Andrew Webmaster Illinois Comptroller's Office www.IllinoisComptroller.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: And Now... some Services?????????????
On Tuesday 02 Mar 2004 15:34 pm, Frost, Michael wrote: [stuff] What on earth are you replying too ? Context ? Quotes ? A mail client that understands threading ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cell phone text messaging...
On Tuesday 02 Mar 2004 15:14 pm, [EMAIL PROTECTED] wrote: europe and asia in this stuff. Yup. And in phone technology too. seeing as how telephones and cell phones were invented here. splutter http://www.uh.edu/engines/epi1098.htm the user.I've seen a couple of sites do the latter. You can see www.greatbigblue.com do the former if you like :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Logging in a user: Session Variable Require Round Trip?
Incorrect. When you hit the site the first time, even if you don't specify a session var, the cookie will get set. Tell me - are you using CF MX 6.1? If not, be aware that your session will time out at a different time then your cflogin scope. If you are using CF MX 6.1, you should use loginStorage=session in your cfapplication to tie the two together. If you are using CFMX6.0, then you have to kind of hack around it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Articulate Server
http://www.articulateglobal.com Anyone ever here of it? Is the Enterprise Version just Flash Communication Server with bells and whistles? Should I post this to CF-Talk? I have a client that wants it, but doesn't really have the budget for us to spend hours/weeks integrating it, and no concrete customers to use it ... So it's all a gamble ... And I need to make an intelligent answer. Cheers [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Stored Proc
I'm having trouble passing parameters to a stored procedure in mssql. How do I pass a the string 1,2,3 so that it can be convert into the tinyint. Needless to sa DivisionID is a tinyint. This is the sp - CREATE PROCEDURE spTest ( @arg_DivID CHAR(255) ) AS SELECTTOP 100 PERCENT EmpID, LastName, FirstName, MaxDate, DivisionID, DivisionAbrv, OfficeID, OfficeAbrv, ProjectID, ProjectAbrv FROMdbo.Lvl2ReqEmpInfo WHERE(DivisionID IN (@arg_DivID)) AND (OfficeID IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)) AND (ProjectID IN (0, 1, 2)) ORDER BY DivisionAbrv, OfficeAbrv, ProjectAbrv, LastName, FirstName [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
select boxes and javascript
Hi guys, I'm trying to work out how to trigger my _javascript_ within a select box: cfform name=the_form tr height=12 valign=top td align=leftcfselect name=PropertyDataHouseType class=#SMSformStyle1# option value=forsale Sale/option option value=forrent Rent/option option value=forlease Lease/option /cfselect/td td align=leftnbsp;/td td align=leftnbsp;/td /tr /cfform I've tried all types like onMouseOut, OnChange, onClick, does anyone know what i should be using?It's setting off a script to show the appropriate DIV. Thanks, Stuart [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: select boxes and javascript
On Tuesday 02 Mar 2004 16:10 pm, Stuart Kidd wrote: Lease/option /cfselect/td I've tried all types like onMouseOut, OnChange, onClick, does anyone know You want onChange in the select not the option. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Too many simultaneous K2 searches crash ColdFusion
Hi I'd be grateful for any ideas how to fix following problem or any workarounds.. If I perform simultaneous searches that exceed number of listeners (using K2 search server) I always manage to crash ColdFusion. I have in k2server.ini numlisteners=4 and using MS Web Application Stress Tool call single page with code like this (and nothing else) cfsearch collection=kb01_kb_search_custom name=qryK2 type=SIMPLE criteria=features When I have 4 threads calling this page server stays up. When I change it to 5 threads server crashes immediately after load is started. I also tried named lock around cfsearch and application scope lock as well. Behavior didn't change at all. Platform is Sun Solaris 8 and ColdFusion version is 6.1 Obiviously adding listeners helps but I'd hate to live with idea that in the future all users could be searching at the same time and server would start crashing then. Tero Pikala [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ColdFusion Lists, Arrays, Structures
In response to requests from CF-Talkers, we've made a complete table of contents for ColdFusion Lists, Arrays, Structures available at http://www.protonarts.com - Jeff === Jeff Peters|...specialization is for insects. [EMAIL PROTECTED]|- Lazarus Long ColdFusion Lists, Arrays, Structures Now available at http://www.GrokFusebox.com === [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Stored Proc
On Tuesday 02 Mar 2004 15:56 pm, Doug Kronenbergeer wrote: How do I pass a the string 1,2,3 so that it can be convert into the tinyint. Needless to sa DivisionID is a tinyint. You can't convert something with comma's in to a number. Having said that, your code should work, because your passing in a string, and using it as the comma seperated list in an IN clause - what error do you get ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: select boxes and javascript
You probably want to use the onChange event for the select list itself, something like this (untested code) :
SCRIPT LANGUAGE=_javascript_
function doSwitchDIV(oSelList) {
var val = oSelList.options[oSelList.selectedIndex].value;
if (val == 'forsale') switchDiv('ez');
if (val == 'forrent') switchDiv('full');
if (val == 'forlease') switchDiv('superduper');
}
/SCRIPT
cfform name=the_form
tr height=12 valign=top
td align=leftcfselect name=PropertyDataHouseType class=#SMSformStyle1#
option value=forsaleFor Sale/option
option value=forrentFor Rent/option
option value=forleaseFor Lease/option
/cfselect/td
td align=leftnbsp;/td
td align=leftnbsp;/td
/tr
/cfform
Chris
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 11:10 AM
To: CF-Talk
Subject: select boxes and _javascript_
Hi guys,
I'm trying to work out how to trigger my _javascript_ within a select box:
cfform name=the_form
tr height=12 valign=top
td align=leftcfselect name=PropertyDataHouseType class=#SMSformStyle1#
option value=forsale Sale/option
option value=forrent Rent/option
option value=forlease Lease/option
/cfselect/td
td align=leftnbsp;/td
td align=leftnbsp;/td
/tr
/cfform
I've tried all types like onMouseOut, OnChange, onClick, does anyone know what i should be using?It's setting off a script to show the appropriate DIV.
Thanks,
Stuart
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: CFMX Hanging Solutions?
On Tue, 2004-03-02 at 05:12, Sung Woo wrote: Thanks for your replies, folks.I just slapped this on: cflock scope = Application timeout = 10 type = Exclusive ... code ... /cflock Seems to do the trick -- no matter how many times I bang on that page, the server never goes down.I'll also go the SP route -- I only thought people did SP for security purposes, not for performance.Thanks for all your suggestions! One thing you might lookout for (depending on how you have your system setup) - if you have more then one server cflock might not lock the process on all your servers. I.e. if you get a hit on server A the lock is only good for server A, and if you then get the same page requested from server B your lock can be useless. -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: select boxes and javascript
I'm trying to work out how to trigger my _javascript_ within a select box: Don't use cfselect myself, but here is the html version I would use select name=this > option value=thisThis/option option value=thatThat/option /select -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Logging in a user: Session Variable Require Round Trip?
Ray, I'm using 6.1 (Version: 6,1,0,63958). No change in issue when setting the loginStorage attribute to session. So you are saying that setting the session variables in my cflogin tag in my application.cfm file should work in theory without a redirect? The cflogin works, but the session vars are not set according to this error message: Error Occurred While Processing Request Element AGENCY_NO is undefined in SESSION. The error occurred in D:\CFusionMX\wwwroot\LHF\index.cfm: line 26 24 : IMG SRC=""> 25 : cflock SCOPE=SESSION TIMEOUT=100 TYPE=READONLY 26 : IAgy:/I#session.Agency_No#IBR 27 : /cflock 28 : P And I must say that it is in fact improbable that logging out allows me to log in on the second attempt (as I specified in original message) - I cannot duplicate this now. Thanks. Sincerely, Andrew [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: select boxes and javascript
Thanks for that Chris and Tom,
I think i went over my head as i found this script at http://developer.apple.com/internet/webcontent/examples/choose_form_source.html which seemed to work pretty cool. (Example of it working is at http://developer.apple.com/internet/webcontent/examples/choose_form.html).
I thought i'd try and change the script so instead of using radio buttons it would use a dropdown box... that's where all my troubles started! :)
I tried your code Chris but nothing happened, no errors either.
Am I missing something (apart from _javascript_ knowledge!).
Stuart
-- Original Message --
From: Lofback, Chris [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Tue, 2 Mar 2004 11:21:03 -0500
You probably want to use the onChange event for the select list itself, something like this (untested code) :
SCRIPT LANGUAGE=_javascript_
function doSwitchDIV(oSelList) {
var val = oSelList.options[oSelList.selectedIndex].value;
if (val == 'forsale') switchDiv('ez');
if (val == 'forrent') switchDiv('full');
if (val == 'forlease') switchDiv('superduper');
}
/SCRIPT
cfform name=the_form
tr height=12 valign=top
td align=leftcfselect name=PropertyDataHouseType class=#SMSformStyle1#
option value=forsaleFor Sale/option
option value=forrentFor Rent/option
option value=forleaseFor Lease/option
/cfselect/td
td align=left /td
td align=left /td
/tr
/cfform
Chris
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 11:10 AM
To: CF-Talk
Subject: select boxes and _javascript_
Hi guys,
I'm trying to work out how to trigger my _javascript_ within a select box:
cfform name=the_form
tr height=12 valign=top
td align=leftcfselect name=PropertyDataHouseType class=#SMSformStyle1#
option value=forsale Sale/option
option value=forrent Rent/option
option value=forlease Lease/option
/cfselect/td
td align=left /td
td align=left /td
/tr
/cfform
I've tried all types like onMouseOut, OnChange, onClick, does anyone know what i should be using?It's setting off a script to show the appropriate DIV.
Thanks,
Stuart
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: OT: Interesting article on Macromedia Central...
On Tue, 2004-03-02 at 06:10, Che Vilnonis wrote: http://news.com.com/2100-1012_3-5167812.html?tag=st_lh I just have to comment on Flash a bit because I know MM watches the list and Che open the gate. --- I checked out writting flash code and, I am sure you have heard this, the naming convention is ridiculous. Stage? Actor? Wha? Most developers have spent quite a bit of time learing what object, methods and the like are all about - why come up with a totally unique language describing things that dont need it? By the time I figured out Oh the Stage is pretty much the Screen I had thrown it away. I understand it's like that because of backwards compatiablity - and for artisy types, but can you perhaps make a language pack called developer and artist? like how you have english and chinese. Plus - really - editors should focus more on the code ... who can write code in a 10 x 10 pixel window? Those complaints are from every developer I know that has tried Flash. I realize this is not so much about Central or that interesting article Che posted -I just had to vent -- Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: Interesting article on Macromedia Central...
On Tuesday 02 Mar 2004 16:56 pm, Rob wrote: sure you have heard this, the naming convention is ridiculous. Stage? Actor? Wha? Most developers have spent quite a bit of time learing what It's to do with, as you say, historicaly Flash being a artist-only thing, and they had to come up with friendly names. Hence'd you'd have a list of availdible 'actors' you could place on to your 'stage', rather than a list of instanciated objects and a screen. language pack called developer and artist? like how you have english and chinese. Plus - really - editors should focus more on the code ... who can write code in a 10 x 10 pixel window? Good ideas, but remember big-M is working on Flex - Flash for developers - so I wouldn't expect to many changes - though a language pack sounds a fun idea. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: select boxes and javascript
It works for me.But you must actually select a different option or the onChange event will not fire.So if For Sale is selected and you pull down the list and select For Sale again, nothing will happen because nothing changed...
Chris
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 11:35 AM
To: CF-Talk
Subject: RE: select boxes and _javascript_
Thanks for that Chris and Tom,
I think i went over my head as i found this script at http://developer.apple.com/internet/webcontent/examples/choose_form_source.html which seemed to work pretty cool. (Example of it working is at http://developer.apple.com/internet/webcontent/examples/choose_form.html).
I thought i'd try and change the script so instead of using radio buttons it would use a dropdown box... that's where all my troubles started! :)
I tried your code Chris but nothing happened, no errors either.
Am I missing something (apart from _javascript_ knowledge!).
Stuart
-- Original Message --
From: Lofback, Chris [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Tue, 2 Mar 2004 11:21:03 -0500
You probably want to use the onChange event for the select list itself, something like this (untested code) :
SCRIPT LANGUAGE=_javascript_
function doSwitchDIV(oSelList) {
var val = oSelList.options[oSelList.selectedIndex].value;
if (val == 'forsale') switchDiv('ez');
if (val == 'forrent') switchDiv('full');
if (val == 'forlease') switchDiv('superduper');
}
/SCRIPT
cfform name=the_form
tr height=12 valign=top
td align=leftcfselect name=PropertyDataHouseType class=#SMSformStyle1#
option value=forsaleFor Sale/option
option value=forrentFor Rent/option
option value=forleaseFor Lease/option
/cfselect/td
td align=left /td
td align=left /td
/tr
/cfform
Chris
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 11:10 AM
To: CF-Talk
Subject: select boxes and _javascript_
Hi guys,
I'm trying to work out how to trigger my _javascript_ within a select box:
cfform name=the_form
tr height=12 valign=top
td align=leftcfselect name=PropertyDataHouseType class=#SMSformStyle1#
option value=forsale Sale/option
option value=forrent Rent/option
option value=forlease Lease/option
/cfselect/td
td align=left /td
td align=left /td
/tr
/cfform
I've tried all types like onMouseOut, OnChange, onClick, does anyone know what i should be using?It's setting off a script to show the appropriate DIV.
Thanks,
Stuart
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: OT: Interesting article on Macromedia Central...
On Tue, 2004-03-02 at 06:10, Che Vilnonis wrote: http://news.com.com/2100-1012_3-5167812.html?tag=st_lh I just have to comment on Flash a bit because I know MM watches the list and Che open the gate. --- I checked out writting flash code and, I am sure you have heard this, the naming convention is ridiculous. Stage? Actor? Wha? Most developers have spent quite a bit of time learing what object, methods and the like are all about - why come up with a totally unique language describing things that dont need it? While Stage my seem odd, it doesn't really take that much thought to remember the Stage is the Screen. I just don't see this as a big deal. ActionScript, especially AS2.0, is very powerful. You should really look into it some. Plus - really - editors should focus more on the code ... who can write code in a 10 x 10 pixel window? Those complaints are from every developer I know that has tried Flash. Um, you do know you can resize that window? You can set the IDE to your preferences and simply leave as is. That's normally what I do. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Form Field Submission Casing
I have what I feel like is a basic question, but for some reason I can't figure this out. I have a basic form where I output a list of name/value pairs for editing (i.e., name=value). However, I am dependent on maintaining the casing of the var name. I have made the form field name the name of the variable, but when I post the form, all the field names come in upper cased. I want to be able to do something like this: cfloop collection=#Form# item=formField #formField#=#Form[formField]# /cfloop but the #formField# casing is always NAME instead of Name or name. I have tried a number of different ways of getting at the form field namew (the above way, looping over the Form.fieldnames variable, using cfscript's for fieldname in Form syntax), but it's always upper cased. Is there a way to preserve the casing? I really don't want to have to create a structure mapping or some such workaround with the properly cased names if it's not necessary. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Logging in a user: Session Variable Require Round Trip?
I'm using 6.1 (Version: 6,1,0,63958). No change in issue when setting the loginStorage attribute to session. So you are saying that setting the session variables in my cflogin tag in my application.cfm file should work in theory without a redirect? Yes. The cflogin works, but the session vars are not set according to this error message: Error Occurred While Processing Request Element AGENCY_NO is undefined in SESSION. The error occurred in D:\CFusionMX\wwwroot\LHF\index.cfm: line 26 24 : IMG SRC=""> 25 : cflock SCOPE=SESSION TIMEOUT=100 TYPE=READONLY 26 : IAgy:/I#session.Agency_No#IBR 27 : /cflock 28 : P And I must say that it is in fact improbable that logging out allows me to log in on the second attempt (as I specified in original message) - I cannot duplicate this now. So are you sayign it is working fine now? If so then I'd say the issue was that you were not tieing session to cflogin. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Stored Proc
Two things, Modify the create statement to be : CREATE PROCEDURE spTest @arg_DivID CHAR(255) Its also better practice not to name a user stored procedure with the prefix sp_- use usp_ or something else which does not conflict with system naming. You cannot convert a comma seperated string into a number - its a string not a number. _ From: Doug Kronenbergeer [mailto:[EMAIL PROTECTED] Sent: 02 March 2004 15:56 To: CF-Talk Subject: SQL Stored Proc I'm having trouble passing parameters to a stored procedure in mssql. How do I pass a the string 1,2,3 so that it can be convert into the tinyint. Needless to sa DivisionID is a tinyint. This is the sp - CREATE PROCEDURE spTest ( @arg_DivID CHAR(255) ) AS SELECTTOP 100 PERCENT EmpID, LastName, FirstName, MaxDate, DivisionID, DivisionAbrv, OfficeID, OfficeAbrv, ProjectID, ProjectAbrv FROMdbo.Lvl2ReqEmpInfo WHERE(DivisionID IN (@arg_DivID)) AND (OfficeID IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)) AND (ProjectID IN (0, 1, 2)) ORDER BY DivisionAbrv, OfficeAbrv, ProjectAbrv, LastName, FirstName _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFC location issues
Excuse the long email, but I think I've found a potential solution to a problem that has plagued myself and others. There seems to be two main routes to handle placing and referencing CFCs (I'd love to hear of others): 1) Put the CFCs in a proper place, such as the web root, or a mapping with the /com path, and use their full paths throughout your CFCs to type arguments and return values.This is ideal, though it limits you to a single app per CF instance. 2) Put the CFCs in a app-specific place (within your app root), and use a application variable to store a the stuff that goes before the com. in your package name.You name CFCs using that application variable (#application.cfcroot#com.mydomain.myapp.mycfc), and leave your CFC arguments and return values untyped (because they can't use dynamic names). Option 1 is perfect for dedicated servers (or CFMX instances) with a single application running on them.Option 2 is usually what people resort to in shared environments, and also the best I've come up with for dev servers, where you necessarily have multiple versions of the same application running (such as a development CVS working dir, and then need to check out the live one for a quick fix). As I was driving in to work today, I thought to myself, Gee Barney, Java has the perfect solution to this, the CLASSPATH, why doesn't CF have one of those?So I thought I'd pass the idea around, and see what people thought before I go running to Macromedia.I'm not sure the best way to implement it, but the CFAPPLICATION tag seems like a prime candidate: cfapplication cfcpath=/path/to/dir,/other/dir / Then you could define the search path for CFCs at the application level (where it really ought to be, IMHO), rather than at the server instance level (which only works for dedicated instances, where server and app are the same level).That would also let you define the search path with your application config, rather than the server config, which has benefits, at least to me. Still have to have the server-level mappings and whatever else, but this would put control of CFCs back in the developer's hands, not in the server admins. What do people think about that kind of solution?I think it's a good one, but then I thought of it. Cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x32 fax: 360.647.5351 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Stored Proc
you have a lot of options really.loop over the list, stick it into a table var or temp table, and do a subselect.play around with it. (not u neil :P) -Original Message- From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: 3/2/04 11:07 AM Subject: RE: SQL Stored Proc Two things, Modify the create statement to be : CREATE PROCEDURE spTest @arg_DivID CHAR(255) Its also better practice not to name a user stored procedure with the prefix sp_- use usp_ or something else which does not conflict with system naming. You cannot convert a comma seperated string into a number - its a string not a number. _ From: Doug Kronenbergeer [mailto:[EMAIL PROTECTED] Sent: 02 March 2004 15:56 To: CF-Talk Subject: SQL Stored Proc I'm having trouble passing parameters to a stored procedure in mssql. How do I pass a the string 1,2,3 so that it can be convert into the tinyint. Needless to sa DivisionID is a tinyint. This is the sp - CREATE PROCEDURE spTest ( @arg_DivID CHAR(255) ) AS SELECTTOP 100 PERCENT EmpID, LastName, FirstName, MaxDate, DivisionID, DivisionAbrv, OfficeID, OfficeAbrv, ProjectID, ProjectAbrv FROMdbo.Lvl2ReqEmpInfo WHERE(DivisionID IN (@arg_DivID)) AND (OfficeID IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)) AND (ProjectID IN (0, 1, 2)) ORDER BY DivisionAbrv, OfficeAbrv, ProjectAbrv, LastName, FirstName _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: Interesting article on Macromedia Central...
On Tue, 2004-03-02 at 08:59, Raymond Camden wrote: While Stage my seem odd, it doesn't really take that much thought to remember the Stage is the Screen. I just don't see this as a big deal. ActionScript, especially AS2.0, is very powerful. You should really look into it some. I did look into it some, thats my point. The stage example is just an example... it gets far worse when you get actors and actions and movies etc. ActionScript is not powerful enough for me to just trash everything I have learned an learn a new thing. Example. _javascript_, Java, C++ -- how different are they? Does CF have the same concepts and names for things as those languages? How about VB? C#? yes they do ... ok then theres ActionScript - I am not going to learn it becuase there are few commonalties, and it's too much of a pain. I would like to use Flash, it seems like it has potential but there is no need for me to learn that Stage is the same as Screen (again this is several people talking not just me). It's pretty common knowledge that people learn by drawing from past knowledge and making parallels between new infomation and old information - I'll just wait for flex and see how that one is... Plus - really - editors should focus more on the code ... who can write code in a 10 x 10 pixel window? Those complaints are from every developer I know that has tried Flash. Um, you do know you can resize that window? You can set the IDE to your preferences and simply leave as is. That's normally what I do. Yeah I tried that and it would resize it every now and again with out me asking, and even though you can resize it it seems like an after thought to allow code writting - which is where the power is. Anyway when people go out of their way to make their own editors you know something is wrong. -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Too many simultaneous K2 searches crash ColdFusion
Increase the number of listeners to match (or exceed) the configured number of simultaneous CF requests. (I think the default is 5 or something like that... check the admin)If the two numbers match then it will work, no matter how many users hit your web site. This is because CF will queue up any requests beyond the configured number of simultaneous CF requests, so the verity pool won't be exhausted. Mark -Original Message- From: Tero Pikala [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 11:16 AM To: CF-Talk Subject: Too many simultaneous K2 searches crash ColdFusion Hi I'd be grateful for any ideas how to fix following problem or any workarounds.. If I perform simultaneous searches that exceed number of listeners (using K2 search server) I always manage to crash ColdFusion. I have in k2server.ini numlisteners=4 and using MS Web Application Stress Tool call single page with code like this (and nothing else) cfsearch collection=kb01_kb_search_custom name=qryK2 type=SIMPLE criteria=features When I have 4 threads calling this page server stays up. When I change it to 5 threads server crashes immediately after load is started. I also tried named lock around cfsearch and application scope lock as well. Behavior didn't change at all. Platform is Sun Solaris 8 and ColdFusion version is 6.1 Obiviously adding listeners helps but I'd hate to live with idea that in the future all users could be searching at the same time and server would start crashing then. Tero Pikala _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: Interesting article on Macromedia Central...
Example. _javascript_, Java, C++ -- how different are they? Does CF have the same concepts and names for things as those languages? How about VB? ActionScript seems a lot closer to _javascript_ than CF is, even if you consider just cfscript. As for Java, I'm not sure how you can compare Java and _javascript_ in the same sentence. The main thing they have in common in their name. Yeah I tried that and it would resize it every now and again with out me asking, and even though you can resize it it seems like an after thought to allow code writting - which is where the power is. Anyway when people go out of their way to make their own editors you know something is wrong. Well, I wouldn't call it making their own editor. I live and breathe HomeSite+ but I still spend 30 minutes or so tweaking it when I first install to get it right for me. I don't find it surprising that I have to tweak the Flash IDE when I use it. I assume I would have to tweak _any_ IDE the first time. As for the editor changing layout on you, you may want to ask about that on a Flash list as it may be a known issue with an easy workaround. And of course it may be a real bug. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cell phone text messaging...
LOL...yeah, historical vantage points, eh? Like who really 'invented' the pytagoream theorem?The chinese knoew of this well before the greeks. Spoke to some folks here where I work, Alltel.Seems teh FCC has a clearing house of sorts that keeps the relation of phone # to carrier. Doug -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 10:58 AM To: CF-Talk Subject: Re: Cell phone text messaging... On Tuesday 02 Mar 2004 15:14 pm, [EMAIL PROTECTED] wrote: europe and asia in this stuff. Yup. And in phone technology too. seeing as how telephones and cell phones were invented here. splutter http://www.uh.edu/engines/epi1098.htm the user.I've seen a couple of sites do the latter. You can see www.greatbigblue.com do the former if you like :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: App Skinning via XSL?
This is a little off topic, but I am trying to figure out the best way to completely skin an application.Not just change a few colors via css, but be able to completely change the structure of the end display.What I have is a central application - i.e. code base, that I need to be able to completely change the end display on, on a per customer basis. I have read a couple of articles about using CFMX, XML and XSL to do this on a much smaller scale - i.e. reformat a menu.Has anybody done this on a full application level and if so, any suggestions or warnings? Thanks -- Jeff - This mail sent through IMP: http://horde.org/imp/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Stored Proc
your code should work, because your passing in a string, and using it as the comma seperated list in an IN clause no, you have to go to dynamic sql strings for an in clause. http://www.sqlteam.com/item.asp?ItemID=4599 (follow to part ii, i think it had more) though, the author came up with another approach here: http://sqlteam.com/item.asp?ItemID=11499 -Original Message- From: Thomas Chiverton To: CF-Talk Sent: 3/2/04 10:18 AM Subject: Re: SQL Stored Proc On Tuesday 02 Mar 2004 15:56 pm, Doug Kronenbergeer wrote: How do I pass a the string 1,2,3 so that it can be convert into the tinyint. Needless to sa DivisionID is a tinyint. You can't convert something with comma's in to a number. Having said that, your code should work, because your passing in a string, and using it as the comma seperated list in an IN clause - what error do you get ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFC location issues
On Tue, 2 Mar 2004 09:14:34 -0800, in cf-talk you wrote: As I was driving in to work today, I thought to myself, Gee Barney, Java has the perfect solution to this, the CLASSPATH, why doesn't CF have one of those?So I thought I'd pass the idea around, and see what people thought before I go running to Macromedia.I'm not sure the best way to implement it, but the CFAPPLICATION tag seems like a prime candidate: cfapplication cfcpath=/path/to/dir,/other/dir / Then you could define the search path for CFCs at the application level (where it really ought to be, IMHO), rather than at the server instance level (which only works for dedicated instances, where server and app are the same level).That would also let you define the search path with your application config, rather than the server config, which has benefits, at least to me. Still have to have the server-level mappings and whatever else, but this would put control of CFCs back in the developer's hands, not in the server admins. What do people think about that kind of solution?I think it's a good one, but then I thought of it. Sounds very similar to this thread (which discusses app-specific custom tag directories): http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesThreadID=30147forumid=4#151236 Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: Interesting article on Macromedia Central...
Example. _javascript_, Java, C++ -- how different are they? Does CF have
the same concepts and names for things as those languages? How about VB?
C#? yes they do ... ok then theres ActionScript - I am not going to
learn it becuase there are few commonalties, and it's too much of a
pain. I would like to use Flash, it seems like it has potential but
there is no need for me to learn that Stage is the same as Screen
(again this is several people talking not just me).
If that's your view of AS, then I think you didn't spend much time at all
with it. Here's a sample of a part of an application in ActionScript:
initGame();
function initGame() {
cash = 100;
showCash();
}
// create a shuffled deck
function createDeck() {
// create an ordered deck
suits = [c,d,s,h];
temp = new Array();
for(i=0;i6;i++) {
for(suit=0;suit4;suit++) {
for(num=1;num14;num++) {
temp.push(suits[suit]+num);
}
}
}
// pick random cards until deck has been shuffled
deck = new Array();
while (temp.length 0) {
r = int(Math.random()*temp.length);
deck.push(temp[r]);
temp.splice(r,1);
}
}
// init hand arrays and bet
function initHand() {
playerHand = new Array();
dealerHand = new Array();
showDealerFirstCard = false;
bet = 5;
showBet();
}
// allow the player to increase her bet up to $25
function addToBet() {
bet += 5;
if (bet 25) bet = 25;
showBet();
}
Pretty similar to the other languages you mentioned. Heck, you could lift
that code out and put it in a different language and with only very slight
mods have a working app.
Now considering that this whole discussion is way off topic, I'll stop here.
-Kevin
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: select boxes and javascript
Hi Chris,
Got it to work with that, i was doing something wrong.Thanks! :)
The only thing now is that they are DIVs and have to be positioned exactly but my page is centred!
Cheers,
Stuart
-- Original Message --
From: Lofback, Chris [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Tue, 2 Mar 2004 12:00:18 -0500
It works for me.But you must actually select a different option or the onChange event will not fire.So if For Sale is selected and you pull down the list and select For Sale again, nothing will happen because nothing changed...
Chris
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 11:35 AM
To: CF-Talk
Subject: RE: select boxes and _javascript_
Thanks for that Chris and Tom,
I think i went over my head as i found this script at http://developer.apple.com/internet/webcontent/examples/choose_form_source.html which seemed to work pretty cool. (Example of it working is at http://developer.apple.com/internet/webcontent/examples/choose_form.html).
I thought i'd try and change the script so instead of using radio buttons it would use a dropdown box... that's where all my troubles started! :)
I tried your code Chris but nothing happened, no errors either.
Am I missing something (apart from _javascript_ knowledge!).
Stuart
-- Original Message --
From: Lofback, Chris [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Tue, 2 Mar 2004 11:21:03 -0500
You probably want to use the onChange event for the select list itself, something like this (untested code) :
SCRIPT LANGUAGE=_javascript_
function doSwitchDIV(oSelList) {
var val = oSelList.options[oSelList.selectedIndex].value;
if (val == 'forsale') switchDiv('ez');
if (val == 'forrent') switchDiv('full');
if (val == 'forlease') switchDiv('superduper');
}
/SCRIPT
cfform name=the_form
tr height=12 valign=top
td align=leftcfselect name=PropertyDataHouseType class=#SMSformStyle1#
option value=forsaleFor Sale/option
option value=forrentFor Rent/option
option value=forleaseFor Lease/option
/cfselect/td
td align=left /td
td align=left /td
/tr
/cfform
Chris
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 11:10 AM
To: CF-Talk
Subject: select boxes and _javascript_
Hi guys,
I'm trying to work out how to trigger my _javascript_ within a select box:
cfform name=the_form
tr height=12 valign=top
td align=leftcfselect name=PropertyDataHouseType class=#SMSformStyle1#
option value=forsale Sale/option
option value=forrent Rent/option
option value=forlease Lease/option
/cfselect/td
td align=left /td
td align=left /td
/tr
/cfform
I've tried all types like onMouseOut, OnChange, onClick, does anyone know what i should be using?It's setting off a script to show the appropriate DIV.
Thanks,
Stuart
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: App Skinning via XSL?
I've used it with great success on many small content pieces, but never for an entire application.Personally, I think you'd be much better off with writing a very thing view layer for each client that calls on the central app for all it's non-presentation functionality.XSL is good for certain things, but it gets unweildy very quickly on large or complicated transformations (as reorganizing a site layout would be). My $0.02. Cheers, barneyb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 9:33 AM To: CF-Talk Subject: OT: App Skinning via XSL? This is a little off topic, but I am trying to figure out the best way to completely skin an application.Not just change a few colors via css, but be able to completely change the structure of the end display.What I have is a central application - i.e. code base, that I need to be able to completely change the end display on, on a per customer basis. I have read a couple of articles about using CFMX, XML and XSL to do this on a much smaller scale - i.e. reformat a menu.Has anybody done this on a full application level and if so, any suggestions or warnings? Thanks -- Jeff - This mail sent through IMP: http://horde.org/imp/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
Deanna Schneider wrote: Have you tried using GenericCursorType for your cursor type? That works for me. (I can give you a sample stored proc that's working for me, if that would be helpful.) I'd appreciate that.I tried using GenericCursorType, and the SP would not compile, throwing this error: === PLS-00201: identifier 'GENERICCURSORTYPE' must be declared === Here is how I tried to implement it: === CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT GenericCursorType ) === -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: Interesting article on Macromedia Central...
On Tue, 2004-03-02 at 09:34, Raymond Camden wrote: Example. _javascript_, Java, C++ -- how different are they? Does CF have the same concepts and names for things as those languages? How about VB? ActionScript seems a lot closer to _javascript_ than CF is, even if you consider just cfscript. As for Java, I'm not sure how you can compare Java and _javascript_ in the same sentence. The main thing they have in common in their name. Actually there is a lot in common between _javascript_ and java - syntax, code structure, keywords - there are many many differeces yes - just as there are between C++, VB, and java - but there are many commonalities and to learn one aids in learning the other more then it hinders (in my opinion) Yeah I tried that and it would resize it every now and again with out me asking, and even though you can resize it it seems like an after thought to allow code writting - which is where the power is. Anyway when people go out of their way to make their own editors you know something is wrong. Well, I wouldn't call it making their own editor. I live and breathe HomeSite+ but I still spend 30 minutes or so tweaking it when I first install to get it right for me. I don't find it surprising that I have to tweak the Flash IDE when I use it. I assume I would have to tweak _any_ IDE the first time. As for the editor changing layout on you, you may want to ask about that on a Flash list as it may be a known issue with an easy workaround. And of course it may be a real bug. hehehe. No, I really mean making their own editor http://www.sephiroth.it/python/sepy.php -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: Interesting article on Macromedia Central...
On Tue, 2004-03-02 at 09:47, Kevin Graeme wrote: Pretty similar to the other languages you mentioned. Heck, you could lift that code out and put it in a different language and with only very slight mods have a working app. I agree now assign that method to an object... er... action to an actor... er... movie... Now considering that this whole discussion is way off topic, I'll stop here. me too -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: App Skinning via XSL?
Thanks Barney.This was my main concern - XSL on a little menu looked pretty easy, but for a full layout?I am just trying to find the best way to make the end product look like a completly custom app, but still have one central code base for upgrades, fixes, etc. Thanks -- Je ff Quoting Barney Boisvert [EMAIL PROTECTED]: I've used it with great success on many small content pieces, but never for an entire application.Personally, I think you'd be much better off with writing a very thing view layer for each client that calls on the central app for all it's non-presentation functionality.XSL is good for certain things, but it gets unweildy very quickly on large or complicated transformations (as reorganizing a site layout would be). My $0.02. Cheers, barneyb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 9:33 AM To: CF-Talk Subject: OT: App Skinning via XSL? This is a little off topic, but I am trying to figure out the best way to completely skin an application.Not just change a few colors via css, but be able to completely change the structure of the end display.What I have is a central application - i.e. code base, that I need to be able to completely change the end display on, on a per customer basis. I have read a couple of articles about using CFMX, XML and XSL to do this on a much smaller scale - i.e. reformat a menu.Has anybody done this on a full application level and if so, any suggestions or warnings? Thanks -- Jeff - This mail sent through IMP: http://horde.org/imp/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: App Skinning via XSL?
On Tue, 2004-03-02 at 09:33, [EMAIL PROTECTED] wrote: This is a little off topic, but I am trying to figure out the best way to completely skin an application.Not just change a few colors via css, but be able to completely change the structure of the end display.What I have is a central application - i.e. code base, that I need to be able to completely change the end display on, on a per customer basis. I have read a couple of articles about using CFMX, XML and XSL to do this on a much smaller scale - i.e. reformat a menu.Has anybody done this on a full application level and if so, any suggestions or warnings? I have done this on a couple of projects, mostly with defined an xml menu, rss feed, or misc xml file. Works really well, though I have not tried it on anything greater than tree control or a menu. If you are going to try it, get an XSLT book first - it'll save you a lot of head ache. And a good testing enviroment is really helpful too. Its a pain to workout an XSLT sheet with CF. Google will bring a bunch of options http://treebeard.sf.net - thats one I wrote but there are more powerful (and more expensive) ones out there -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Form Field Submission Casing
Coldfusion is 100% case-insensitive so you wont get the right casing
from the form struct.One way to handle it might be to shadow all of
your form fields with a hidden input called fields like this:
form action="" method=post
input name=firstName type=text size=20 /
input name=fields type=hidden value=firstName /
input name=lastName type=text size=20 /
input name=fields type=hidden value=lastName /
input type=submit value=Submit Me /
/form
when you submit it you will have the following three form variables:
#FORM.FIRSTNAME#, #FORM.LASTNAME#, #FORM.FIELDS#
and #FORM.FIELDS# will be a comma-delimited ordered-list of form fields
with the casing you desire. firstName,lastName
an even SLICKER way to go would be to have a standard _javascript_
function iterate through the form fields and write the list in a hidden
value during an onSubmit.If you want I can write that function for
you.Just pay me via paypal... :-P *joke*
Here's a working example you can use.(Please note that the hidden
input field on the form, fieldList is camelCased.If you change the
case of that field, make sure you change the case in the function too.
Other than that try it out on a coldfusion page and be amazed.)
!--- BEGIN FIELDLIST SOLUTION CODE ---
script language=_javascript_ type=text/_javascript_
// this _javascript_ function iterates through the
// fields aka elements of the form and updates
// the hidden element called fieldList with any
// field names encountered, keeping the proper case
// since some people want strict casing info on their
// fields apparently!;-P
function UpdateFieldList(formRef) {
var fieldList='';
for(i=0;iformRef.elements.length;i++) {
if((formRef.elements[i].name!='')
(formRef.elements[i].name!='fieldList')) {
if(fieldList!='') fieldList=fieldList+',';
fieldList=fieldList+formRef.elements[i].name;
}
}
formRef.fieldList.value=fieldList;
}
/script
form name=myForm action="" method=post
input type=hidden name=fieldList value= /
input type=text name=firstName value=J0e /
input type=text name=LaSTnAMe value=Hax0r /
input type=submit value=SUBMIT ME, PLEASE! /
/form
script language=_javascript_ type=text/_javascript_
// it is important that this function call is made
// only used AFTER the form is already available, i.e.
// written to the page.You could throw it in the
// form's onSubmit event too, if you wanted.
UpdateFieldList(document.forms.myForm);
/script
!--- END FIELDLIST SOLUTION CODE ---
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 11:01 AM
To: CF-Talk
Subject: Form Field Submission Casing
I have what I feel like is a basic question, but for some reason I can't
figure this out. I have a basic form where I output a list of name/value
pairs for editing (i.e., name=value). However, I am dependent on
maintaining
the casing of the var name. I have made the form field name the name of
the
variable, but when I post the form, all the field names come in upper
cased.
I want to be able to do something like this:
cfloop collection=#Form# item=formField
#formField#=#Form[formField]#
/cfloop
but the #formField# casing is always NAME instead of Name or name.
I
have tried a number of different ways of getting at the form field namew
(the above way, looping over the Form.fieldnames variable, using
cfscript's
for fieldname in Form syntax), but it's always upper cased. Is there a
way
to preserve the casing? I really don't want to have to create a
structure
mapping or some such workaround with the properly cased names if it's
not
necessary.
Regards,
Dave.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Oracle and Cold Fusion
Rob wrote: Did you figure out what datatype it is having problems with? i.e. only selecting one field at a time. Can it get just an int ok? All of the datatypes seem to match up just fine.I've gone out of my way to make them all match.If I remove the refcursor from the procedure call, then it gives an error telling me that the procresult is not defined. I mean you are selecting varchar2 and char in your refcursor have you just tried one or the other to see if it has a problem with just one of those datatypes - it's probably a conversion between what the drive says is a query and what cf thinks is a query, but I was hoping the Unsupported data conversion was refering to one of the column types. Hm.I tried with varchar2(50) at each point, and with char(50) at each point.Both gave me the same error. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC location issues
This solution occurred to me too a while back, and I think it is probably the most flexible solution to the whole problem.Right now, the resolution of CFC names is: 1. Current Directory 2. CF Mappings 3. Custom Tags If the application specific CFCPATH attribute was added to the cfapplication tag, then the paths in that attribute could be searched first.If not found, then CF could search just like it currently does. Also, cfapplication might not be the best place to put this.How about the cfsetting tag? cfsetting cfcpath=C:\WebSites\site\cfc;C:\WebSites\lib/ While I'm at it, how about defining CF mappings for an application: cfsetting mappings=com.domain=C:\WebSites\site\cfc;com.domain.cfc=C:\WebSites\lib/ The reason I say this is that if you put this in the cfapplication tag, you cannot access the application or session scopes to obtain any dynamic values to use in the setting value.What if you had a variable that contained to name of the root directory for your cfcs?I'm not saying I would do that--I would problably use the request scope, but the point is that you might want to have access to those scopes before defining the cfcpath attribute. cfsetting cfcpath=#session.workspaceName#\site\cfc;C:\WebSites\lib/ What I just did was define a cfc root for the current developer's workspace directory.This would allow for concurrent development on the same sets of components in different locations on the same server--and the full names wouldn't have to be changed for each workspace. Anyhow, thanks for bringing this up.I wonder if they would do this for us. Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 9:15 AM To: CF-Talk Subject: CFC location issues Excuse the long email, but I think I've found a potential solution to a problem that has plagued myself and others. There seems to be two main routes to handle placing and referencing CFCs (I'd love to hear of others): 1) Put the CFCs in a proper place, such as the web root, or a mapping with the /com path, and use their full paths throughout your CFCs to type arguments and return values.This is ideal, though it limits you to a single app per CF instance. 2) Put the CFCs in a app-specific place (within your app root), and use a application variable to store a the stuff that goes before the com. in your package name.You name CFCs using that application variable (#application.cfcroot#com.mydomain.myapp.mycfc), and leave your CFC arguments and return values untyped (because they can't use dynamic names). Option 1 is perfect for dedicated servers (or CFMX instances) with a single application running on them.Option 2 is usually what people resort to in shared environments, and also the best I've come up with for dev servers, where you necessarily have multiple versions of the same application running (such as a development CVS working dir, and then need to check out the live one for a quick fix). As I was driving in to work today, I thought to myself, Gee Barney, Java has the perfect solution to this, the CLASSPATH, why doesn't CF have one of those?So I thought I'd pass the idea around, and see what people thought before I go running to Macromedia.I'm not sure the best way to implement it, but the CFAPPLICATION tag seems like a prime candidate: cfapplication cfcpath=/path/to/dir,/other/dir / Then you could define the search path for CFCs at the application level (where it really ought to be, IMHO), rather than at the server instance level (which only works for dedicated instances, where server and app are the same level).That would also let you define the search path with your application config, rather than the server config, which has benefits, at least to me. Still have to have the server-level mappings and whatever else, but this would put control of CFCs back in the developer's hands, not in the server admins. What do people think about that kind of solution?I think it's a good one, but then I thought of it. Cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x32 fax: 360.647.5351 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: App Skinning via XSL?
This is a little off topic, but I am trying to figure out the best way to completely skin an application.Not just change a few colors via css, but be able to completely change the structure of the end display.What I have is a central application - i.e. code base, that I need to be able to completely change the end display on, on a per customer basis. I think you're not giving CSS enough credit. Check out the examples at the CSS Zen Garden and you will probably get the idea that you can do what you want with CSS. There are currently 201 skins, all for the same content, and they're more than just changing a few colors. http://www.csszengarden.com/ -Kevin [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: App Skinning via XSL?
On Tue, 2004-03-02 at 10:30, Kevin Graeme wrote: I think you're not giving CSS enough credit. Check out the examples at the CSS Zen Garden and you will probably get the idea that you can do what you want with CSS. There are currently 201 skins, all for the same content, and they're more than just changing a few colors. http://www.csszengarden.com/ That site is amazing :-o - I had no idea -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Inserting records from a text file
I'm inserting records from a text file using the code below.
I think that the problem lies in this code:
cfset DataFile = Replace(DataFile, '#chr(9)##chr(9)#','#chr(9)#
#chr(9)#','all')
cfset DataFile = Replace(DataFile, '#chr(9)##chr(9)#','#chr(9)#
#chr(9)#','all')
When I do the insert, I get this error:
ODBC Error Code = 0 ()
Error while executing the query (non-fatal); ERROR: pg_atoi: error in :
can't parse
If I use this code it works:
cfset DataFile = Replace(DataFile,
'#chr(9)##chr(9)#','#chr(9)#0#chr(9)#','all')
cfset DataFile = Replace(DataFile,
'#chr(9)##chr(9)#','#chr(9)#0#chr(9)#','all')
But I don't want my fields to be populated with 0's, I would rather they
were blank.I assume the problem is that my database is trying to insert a
space into a field that isn't varchar or text... but I'm not sure of an
elegant solution.
*** *** ***
CODE BELOW:
*** ** ***
cfscript
function makeArray(dList,delim)
{
aRec = arrayNew(1);
temp = dList;
counter = 1;
idx = find(delim,temp,1);
while (len(temp))
{
aRec[counter] = spanExcluding(temp,delim);
if ((idx EQ len(temp)) OR (NOT idx))
{
temp = removeChars(temp,1,idx);
aRec[counter + 1] = mid(temp,1,len(temp));
temp = '';
}
else
{
temp = removeChars(temp,1,idx);
}
idx = find(delim,temp,1);
counter = counter + 1;
}
return aRec;
}
/cfscript
cfset new_line = chr(10) /
cfset tab = chr(9) /
cffile
action="">
file=/data/ftp/lungintr/pages/tools/data.txt
variable=DataFile /
cfset DataFile = Replace(DataFile,
'#chr(9)##chr(9)#','#chr(9)#0#chr(9)#','all')
cfset DataFile = Replace(DataFile,
'#chr(9)##chr(9)#','#chr(9)#0#chr(9)#','all')
cfset aDataFile = listToArray(DataFile, new_line)
cfoutput
cftry
cfloop from=1 to=#arrayLen(aDataFile)# index=Record
cfset aRecord = makeArray(aDataFile[record], tab)
cfquery name=insert datasource=#DSN#
INSERT INTO person_temp (
salutation_id,
first_name,
last_name,
title,
qualification,
organization_id,
department_id,
office_id,
status,
role_id,
org_position,
national_board,
userid,
password,
work_phone,
work_phone_ext,
fax_phone,
cell_phone,
pager_phone,
lung_family,
email
)
VALUES (
#aRecord[1]#,
'#aRecord[2]#',
'#aRecord[3]#',
'#aRecord[4]#',
'#aRecord[5]#',
#aRecord[6]#,
#aRecord[7]#,
#aRecord[8]#,
'#aRecord[9]#',
#aRecord[10]#,
'#aRecord[11]#',
'#aRecord[12]#',
'#aRecord[13]#',
'#aRecord[14]#',
'#aRecord[15]#',
'#aRecord[16]#',
'#aRecord[17]#',
'#aRecord[18]#',
'#aRecord[19]#',
'1',
'#aRecord[20]#'
)
/cfquery
/cfloop
Your records have been inserted.
cfcatch type=all
Your records were not inserted.
br /Please check to ensure your data is properly delimited and does not
contain any empty records.
/cfcatch
/cftry
/cfoutput
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
CFLDAP Active Directory 4.5/5 Problems
My company is currently migrating to Active Directory and testing our code against the new servers has been issuing some errors.In CFMX the following code runs fine, but in 4.5/5 it generates the rather non-descript error 'CFLDAP - Operations error'.Anybody have any thoughts?Thanks! (Note: authentication iformation has been replaced with #) cfset varFilter = SamAccountName=# cfldap name=Users server=COWDCC02 action=""> username=# password=# attributes=Mail start=dc=corp,dc=mxtr,dc=net startrow=1 scope=subtree sortcontrol=asc filter = #evaluate(varFilter)# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX 6.1 Session Replication on JRun 4
I hadn't played with this for a while, so I thought I'd give it a try -- seems to work OK; 1) I am running CFMX6.1/JRun on Mac OS X Panther (all updates available applied) 2) Setup 2 server instances cfmx61 and cfmx61b (just duped the existing cfmx61 instance) 3) JMC: created/initialized cfmx61b 4) Set J2EE session variables in both 5) JMC: clustered cfmx61 and cfmx61b 6) wsconfig: connected cluster to Apache 7) Used a simple program (suggested by Sean Corfield) -- see below 8) Run concurrently in several windows of the same browser - each window of the same browser pointed to same domain is treated as the same session - each window of the same browser pointed to different domain is treated as different session 9) Run concurrently in several different browsers (Safari, IE, Mozilla) -different browsers are different sessions 10) JMC: Stop/Start cfmx server instances to see server instance change in browser windows HTH Dick Sean's program cfapplication name=blah sessionmanagement=Yes sessiontimeout=#CreateTimeSpan(0,0,45,0)# setdomaincookies=yes and html body cfif NOT IsDefined(Session.TestA) cfset Session.TestA = 0 /cfif cfset Session.TestA = Session.TestA + 1 cfobject action="" type=java class=jrunx.kernel.JRun name=jr cfset sname = jr.getServerName() cfoutput on server #sname# p Session value = #Session.TestA# p SessionID = #Session.SessionID# /cfoutput /body /html On Mar 2, 2004, at 7:35 AM, Igor Ilyinsky wrote: Has anyone been successful in setting up the session replication in CFMX 6.1 on Jrun 4? I'm trying to test it out on 1 machine (for now). I have set up 2 server instances (say Server1 and Server2) and deployed CFMX on both. I configured both instances of CFMX to allow J2EE sessions. I clustered those 2 server instances in JRun I added each of the instances as a peer to the other, and pointed the web root to the same index.cfm file. The simple INDEX.CFM for testing is as follows: CFAPPLICATION name=testapp applicationtimeout=#createtimespan(0,0,5,0)# sessionmanagement=Yes sessiontimeout=#createtimespan(0,0,1,0)# CFIF IsDefined(Session.Host) CFOUTPUT#Session.Host#/CFOUTPUT CFELSE First time here. /CFIF BRBR CFSET Session.Host = CGI.HTTP_HOST CFDUMP var=#Session.Host# Now, when I test the two instances (say loclhost:8001 and localhost:8002) I never get confirmation that a session is coming form the other instance. The weird thing (or maybe not) is that the JSessionID, CFID and CFTOKEN are the same on both calls. Any input is appreciated. thanks in advance, Igor cccfug.org [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC location issues
CFSETTING probably makes more sense, good call. Or perhaps a new CFMAPPING tag that sets a dynamic mapping that's specific to the current request.Not sure how that would play with CFIMPORT (as it can now use mappings, but only at compile time), but I could see it potentially helping on that front. Cheers, barneyb -Original Message- From: Paul Kenney [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 10:05 AM To: CF-Talk Subject: RE: CFC location issues This solution occurred to me too a while back, and I think it is probably the most flexible solution to the whole problem.Right now, the resolution of CFC names is: 1. Current Directory 2. CF Mappings 3. Custom Tags If the application specific CFCPATH attribute was added to the cfapplication tag, then the paths in that attribute could be searched first.If not found, then CF could search just like it currently does. Also, cfapplication might not be the best place to put this.How about the cfsetting tag? cfsetting cfcpath=C:\WebSites\site\cfc;C:\WebSites\lib/ While I'm at it, how about defining CF mappings for an application: cfsetting mappings=com.domain=C:\WebSites\site\cfc;com.domain.cfc=C:\We bSites\lib/ The reason I say this is that if you put this in the cfapplication tag, you cannot access the application or session scopes to obtain any dynamic values to use in the setting value.What if you had a variable that contained to name of the root directory for your cfcs?I'm not saying I would do that--I would problably use the request scope, but the point is that you might want to have access to those scopes before defining the cfcpath attribute. cfsetting cfcpath=#session.workspaceName#\site\cfc;C:\WebSites\lib/ What I just did was define a cfc root for the current developer's workspace directory.This would allow for concurrent development on the same sets of components in different locations on the same server--and the full names wouldn't have to be changed for each workspace. Anyhow, thanks for bringing this up.I wonder if they would do this for us. Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 9:15 AM To: CF-Talk Subject: CFC location issues Excuse the long email, but I think I've found a potential solution to a problem that has plagued myself and others. There seems to be two main routes to handle placing and referencing CFCs (I'd love to hear of others): 1) Put the CFCs in a proper place, such as the web root, or a mapping with the /com path, and use their full paths throughout your CFCs to type arguments and return values.This is ideal, though it limits you to a single app per CF instance. 2) Put the CFCs in a app-specific place (within your app root), and use a application variable to store a the stuff that goes before the com. in your package name.You name CFCs using that application variable (#application.cfcroot#com.mydomain.myapp.mycfc), and leave your CFC arguments and return values untyped (because they can't use dynamic names). Option 1 is perfect for dedicated servers (or CFMX instances) with a single application running on them.Option 2 is usually what people resort to in shared environments, and also the best I've come up with for dev servers, where you necessarily have multiple versions of the same application running (such as a development CVS working dir, and then need to check out the live one for a quick fix). As I was driving in to work today, I thought to myself, Gee Barney, Java has the perfect solution to this, the CLASSPATH, why doesn't CF have one of those?So I thought I'd pass the idea around, and see what people thought before I go running to Macromedia.I'm not sure the best way to implement it, but the CFAPPLICATION tag seems like a prime candidate: cfapplication cfcpath=/path/to/dir,/other/dir / Then you could define the search path for CFCs at the application level (where it really ought to be, IMHO), rather than at the server instance level (which only works for dedicated instances, where server and app are the same level).That would also let you define the search path with your application config, rather than the server config, which has benefits, at least to me. Still have to have the server-level mappings and whatever else, but this would put control of CFCs back in the developer's hands, not in the server admins. What do people think about that kind of solution?I think it's a good one, but then I thought of it. Cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x32 fax: 360.647.5351 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFLDAP Active Directory 4.5/5 Problems
I have jad the same issue.No workarounds/fixes found by myself as of yet.Fortunately its not a 'most important' issue for me.at least your not alone! Doug -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 12:34 PM To: CF-Talk Subject: CFLDAP Active Directory 4.5/5 Problems My company is currently migrating to Active Directory and testing our code against the new servers has been issuing some errors.In CFMX the following code runs fine, but in 4.5/5 it generates the rather non-descript error 'CFLDAP - Operations error'.Anybody have any thoughts?Thanks! (Note: authentication iformation has been replaced with #) cfset varFilter = SamAccountName=# cfldap name=Users server=COWDCC02 action=""> username=# password=# attributes=Mail start=dc=corp,dc=mxtr,dc=net startrow=1 scope=subtree sortcontrol=asc filter = #evaluate(varFilter)# _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Form Field Submission Casing
Coldfusion is 100% case-insensitive so you wont get the right casing
from the form struct.One way to handle it might be to shadow all of
your form fields with a hidden input called fields like this:
form action="" method=post
input name=firstName type=text size=20 /
input name=fields type=hidden value=firstName /
input name=lastName type=text size=20 /
input name=fields type=hidden value=lastName /
input type=submit value=Submit Me /
/form
when you submit it you will have the following three form variables:
#FORM.FIRSTNAME#, #FORM.LASTNAME#, #FORM.FIELDS#
and #FORM.FIELDS# will be a comma-delimited ordered-list of form fields
with the casing you desire. firstName,lastName
an even SLICKER way to go would be to have a standard _javascript_
function iterate through the form fields and write the list in a hidden
value during an onSubmit.If you want I can write that function for
you.Just pay me via paypal... :-P *joke*
Thanks for confirming what I thought. I decided to use the hidden field
route with a _javascript_ call. However, I didn't use your code (sorry!). I
decided to use God's gift to client-side validation instead (which goes by
the name qForms). Here's my solution in case it may help others out:
objForm = new qForm(frmProperties);
objForm.>
function storeFormFields() {
var str = ;
var struct = objForm.getFields();
var key = ;
for ( key in struct ) {
// We don't want to pass the Submit button and the hidden
// field as values, so do a simple conditional check to
// exclude them
if ( key != 'update' key != 'keyNames' ) {
str += key + ,;
}
}
objForm.keyNames.setValue(str);
}
As you can see, it's much less cumbersome and easier for other developers to
come in and sift through because qForms abstracts so much of the mess of
looping and evaluating. I love qForms.
Regards,
Dave.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: App Skinning via XSL?
I second that.Absolutely stunning. -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 10:45 AM To: CF-Talk Subject: Re: App Skinning via XSL? On Tue, 2004-03-02 at 10:30, Kevin Graeme wrote: I think you're not giving CSS enough credit. Check out the examples at the CSS Zen Garden and you will probably get the idea that you can do what you want with CSS. There are currently 201 skins, all for the same content, and they're more than just changing a few colors. http://www.csszengarden.com/ That site is amazing :-o - I had no idea -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: ActionScript Help
Hello All,
Setting up touch screen kiosk need help with ActionScript in Flash MX. Have
a screen saver script that records mouse movement,once the mouse stops
moving for a certain amount of time the play head goes to and plays an intro
movie. The file seems to have a bug that appears randomly. At different time
intervals the play-back-head jumps back to the intro movie when clicking
around in the kiosk. Have not isolated a time when the play-back-head jumps
back to the intro movie.
Here is the script:
stop();
this.>
_global.mouseXPosition = _root._xmouse; //save mouse position to a global
variable
_global.mouseYPosition = _root._ymouse;
//trace(mouseYPosition); //if you want to test it...
updateAfterEvent(); //reset
}
checkMouse = setInterval(whereMouse,6); //look at the mouse position
every second
function whereMouse(){
oldMouseX = _global.mouseXPosition; // get the current mouse X position for
this function
oldMouseY = _global.mouseYPosition; // get the current mouse Y position for
this function
//trace(oldMouseX + ,+ oldMouseY); //just to test it
if(_root._xmouse==oldMouseX _root._ymouse==oldMouseY){ //if the mouse
hasn't moved for a second
gotoAndStop(Begin);
}
}
Thanks!
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
cfif in cfform error
I have a page that is completely generated with cfoutput.I'm trying to put an cfif in the middle of a cfform, like described in one of my tutorials*, though they're using a form, rather than a cfform.I'm getting an error: --- Context validation error in tag CFIF The tag is not correctly positioned relative to other tags in the template: tag CFIF must have some content. This means that there must be at least one tag, some text, or even just whitespace characters between the CFIF and /CFIF markers. --- There is something between the ifs, so I suspect it's trying to tell me something else, but I can't seem to figure what. Here's the page. It'll look odd cause there's no cf server on this site, but then you'll be able to see the source: http://www.phiresearch.umd.edu/bodyfun/registration_form.cfm thanks for your help. * the tutorial is dreamweaver mx dynamic applications - from the source about pg 180. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Weird Intermittent Problem in IE browser
I've stumbled across a bewildering problem in IE (6.0), and i was wondering if anyone else had every seen something like this. Here's my test page. Some of you may see it correctly in IE, some of you may not. It works fine in other browsers. http://www.consciousliving.it/2004/test.htm What happens, but ONLY on some machines and only on some servers, is that on a page with many international phone numbers listed in this form, with a + sign in the beginning: +39-0523-891933 ALL the phone numbers get truncated so that the +[00]- is removed: 0523-891933 and the really wierd thing is that all the images on the page are not shown (a red X appears in place of the image). I've checked the browser source on a machine where it's not working, and the text for the phone numbers appears correctly in the page source and the image tags also are correct in the page source, so it's only a rendering problem. The above page is not currently working on my machine and it is working on the machine of the person sitting next to me, and both are IE version 6.0.2800.1106 Anyone seen something like this before? I'm totally stumped at the moment. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfif in cfform error
Basically it is telling you that you have a opening/closing CFIF statement without it's partner. Recheck your code for proper opening and closing statements -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 1:48 PM To: CF-Talk Subject: cfif in cfform error I have a page that is completely generated with cfoutput.I'm trying to put an cfif in the middle of a cfform, like described in one of my tutorials*, though they're using a form, rather than a cfform.I'm getting an error: --- Context validation error in tag CFIF The tag is not correctly positioned relative to other tags in the template: tag CFIF must have some content. This means that there must be at least one tag, some text, or even just whitespace characters between the CFIF and /CFIF markers. --- There is something between the ifs, so I suspect it's trying to tell me something else, but I can't seem to figure what. Here's the page. It'll look odd cause there's no cf server on this site, but then you'll be able to see the source: http://www.phiresearch.umd.edu/bodyfun/registration_form.cfm thanks for your help. * the tutorial is dreamweaver mx dynamic applications - from the source about pg 180. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: Interesting article on Macromedia Central...
It's pretty common knowledge that people learn by drawing from past knowledge and making parallels between new infomation and old information This is true, but not always relevant. For example, knowing CF doesn't help you too much with GUI development, which is what Flash is largely about. Example. _javascript_, Java, C++ -- how different are they? Does CF have the same concepts and names for things as those languages? How about VB? C#? yes they do ... ok then theres ActionScript - I am not going to learn it becuase there are few commonalties, and it's too much of a pain. I would like to use Flash, it seems like it has potential but there is no need for me to learn that Stage is the same as Screen (again this is several people talking not just me). While a lot of programmers have trouble with the Flash IDE in general, ActionScript and _javascript_ are essentially the same language - they're both ECMAScript-compliant. ActionScript and _javascript_ are a lot closer than _javascript_ and Java. Yeah I tried that and it would resize it every now and again with out me asking, and even though you can resize it it seems like an after thought to allow code writting - which is where the power is. Anyway when people go out of their way to make their own editors you know something is wrong. I find this surprising coming from the guy who wrote the cfeclipse plugin! You can use any editor you like to write ActionScript. Our own Samuel Neff strongly recommends PrimalScript, if I recall correctly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
