CF Status in UK
Hi, Could anybody tell me how is ColdFusion doing in UK? Is it not in demand here now? Actually, I came here in UK from India on 29th Jan., 2001 as a Software Consultant through NovaSoft Info. Tech. (Europe) Ltd. (http://www.novasoftinfo.co.uk and http://www.novasoftinfo.com). They hire Software Professionals from India and place them here on Contract basis. My main skills are ColdFusion. I am having 2 yrs exp. in ColdFusion with SQL, Access, JavaScript, HTML, and Dreamweaver etc. I have developed 10 sites using ColdFusion. Now almost two months have been completed and I am still on Bench. Not only myself, there are other 4 ColdFusion professionals they are also on bench. NovaSoft is not able to place anybody. What they are saying is that there is no market for ColdFusion in UK now and the situation will remain same for next 5-6 months atleast. I have already wasted almost 2 months for the process for coming to UK and 2 months on bench and if the situation is going to remain for next 5-6 months, it is going to spoil my career very badly. Moreover, company might take some harsh decisions also. I am in great dilemma now-a-days. Could you please tell me the status of ColdFusion in UK or could anybody guide me overcoming this problem? Any kind of help/suggestion is welcome. Thanks and Regards, Rajesh Kumar For Valentine's Day shop by Brand, Product, Price, Store and Location! http://shop.storerunner.com/shop.asp?pdef=hometrsid=3080 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Status in UK
CF is not as big in the UK as it is in the states, also most companies tend to train there own IT staff in CF as its quite easy to use. If yopu are looking for contract work It might be worth registering with a couple of recruitment agencies, they may well be able to place you much easier and quicker, I would suggest Computer Futures (www.computerfutures.co.uk), mainly becuase they have offices nationwide. I had an interview with Novasoft myself, about a year ago, I wasn't impressed with what they where offering. Good Luck, Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 09:44 To: CF-Talk Subject: CF Status in UK Hi, Could anybody tell me how is ColdFusion doing in UK? Is it not in demand here now? Actually, I came here in UK from India on 29th Jan., 2001 as a Software Consultant through NovaSoft Info. Tech. (Europe) Ltd. (http://www.novasoftinfo.co.uk and http://www.novasoftinfo.com). They hire Software Professionals from India and place them here on Contract basis. My main skills are ColdFusion. I am having 2 yrs exp. in ColdFusion with SQL, Access, JavaScript, HTML, and Dreamweaver etc. I have developed 10 sites using ColdFusion. Now almost two months have been completed and I am still on Bench. Not only myself, there are other 4 ColdFusion professionals they are also on bench. NovaSoft is not able to place anybody. What they are saying is that there is no market for ColdFusion in UK now and the situation will remain same for next 5-6 months atleast. I have already wasted almost 2 months for the process for coming to UK and 2 months on bench and if the situation is going to remain for next 5-6 months, it is going to spoil my career very badly. Moreover, company might take some harsh decisions also. I am in great dilemma now-a-days. Could you please tell me the status of ColdFusion in UK or could anybody guide me overcoming this problem? Any kind of help/suggestion is welcome. Thanks and Regards, Rajesh Kumar For Valentine's Day shop by Brand, Product, Price, Store and Location! http://shop.storerunner.com/shop.asp?pdef=hometrsid=3080 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Status in UK
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 09:44 To: CF-Talk Subject: CF Status in UK Hi, Could anybody tell me how is ColdFusion doing in UK? Is it not in demand here now? The CF contract market in the UK is extremely quiet at the moment, it's very disconcerting... On the other hand you can pretty much have your pick of permanent jobs... A good idea is to try and get involved in the CF community. Join the uk cfug @ : www.cfug.co.uk and their mailing lists. Also join the CF-Community list or CF-Jobs lists at www.houseoffusion.com where this post should really of gone.. Ben -- Ben Lowndes, CF Contractor http://www.lowndes.net/ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Status in UK
There are UK-based CF contracts every week on www.jobserve.com. There was a thread on CF status in the UK on the list a while back, you should be able to find it in the archives. Basically with your experience you shouldn't have any problems if your company know what they're doing. Also, try the cf-jobs list which is more appropriate for this subject. Good luck Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 9:44 AM To: CF-Talk Subject: CF Status in UK Hi, Could anybody tell me how is ColdFusion doing in UK? Is it not in demand here now? Actually, I came here in UK from India on 29th Jan., 2001 as a Software Consultant through NovaSoft Info. Tech. (Europe) Ltd. (http://www.novasoftinfo.co.uk and http://www.novasoftinfo.com). They hire Software Professionals from India and place them here on Contract basis. My main skills are ColdFusion. I am having 2 yrs exp. in ColdFusion with SQL, Access, JavaScript, HTML, and Dreamweaver etc. I have developed 10 sites using ColdFusion. Now almost two months have been completed and I am still on Bench. Not only myself, there are other 4 ColdFusion professionals they are also on bench. NovaSoft is not able to place anybody. What they are saying is that there is no market for ColdFusion in UK now and the situation will remain same for next 5-6 months atleast. I have already wasted almost 2 months for the process for coming to UK and 2 months on bench and if the situation is going to remain for next 5-6 months, it is going to spoil my career very badly. Moreover, company might take some harsh decisions also. I am in great dilemma now-a-days. Could you please tell me the status of ColdFusion in UK or could anybody guide me overcoming this problem? Any kind of help/suggestion is welcome. Thanks and Regards, Rajesh Kumar ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: CF Status in UK
You shouldn't really pay too much attention to agencies or you will certainly go insane, there are good ones out there but the majority seem to be interested in things other than people. If they are saying 5-6 months before they can get you any cf work go else where! Register with as many agencies as you can but use a disposable webmail address as you will be spammed for the rest of your life with totally irrelevant jobs - I am! -- Gavin Lilley Internet / Intranet Developer http://halesowen.ac.uk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 09:44 To: CF-Talk Subject: CF Status in UK Hi, Could anybody tell me how is ColdFusion doing in UK? Is it not in demand here now? Actually, I came here in UK from India on 29th Jan., 2001 as a Software Consultant through NovaSoft Info. Tech. (Europe) Ltd. (http://www.novasoftinfo.co.uk and http://www.novasoftinfo.com). They hire Software Professionals from India and place them here on Contract basis. My main skills are ColdFusion. I am having 2 yrs exp. in ColdFusion with SQL, Access, JavaScript, HTML, and Dreamweaver etc. I have developed 10 sites using ColdFusion. Now almost two months have been completed and I am still on Bench. Not only myself, there are other 4 ColdFusion professionals they are also on bench. NovaSoft is not able to place anybody. What they are saying is that there is no market for ColdFusion in UK now and the situation will remain same for next 5-6 months atleast. I have already wasted almost 2 months for the process for coming to UK and 2 months on bench and if the situation is going to remain for next 5-6 months, it is going to spoil my career very badly. Moreover, company might take some harsh decisions also. I am in great dilemma now-a-days. Could you please tell me the status of ColdFusion in UK or could anybody guide me overcoming this problem? Any kind of help/suggestion is welcome. Thanks and Regards, Rajesh Kumar For Valentine's Day shop by Brand, Product, Price, Store and Location! http://shop.storerunner.com/shop.asp?pdef=hometrsid=3080 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
any way to retrieve the actual SQL used
Hi all Is there any way to retrieve the actual SQL (rather than the records returned) by a dynamic query? ie I have a page that bases its query on the form fields filled in on the previous page. I want to actually use the SQL statement for sth else. It comes out if you turn debugging on, but is it accessible eg as a variable of some sort? Any thoughts are welcome Many thanks in advance Chris chris phillips communisis one plc multimedia team 0113 225 5373 mailto:[EMAIL PROTECTED] http://www.communisis-one.co.uk ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: any way to retrieve the actual SQL used
Is it an SP? If so you can build up a SQL string that you execute by using EXEC(sqlstring). You can then set an output parameter to be the SQL string -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Chris Phillips [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 10:51 To: CF-Talk Subject: any way to retrieve the actual SQL used Hi all Is there any way to retrieve the actual SQL (rather than the records returned) by a dynamic query? ie I have a page that bases its query on the form fields filled in on the previous page. I want to actually use the SQL statement for sth else. It comes out if you turn debugging on, but is it accessible eg as a variable of some sort? Any thoughts are welcome Many thanks in advance Chris chris phillips communisis one plc multimedia team 0113 225 5373 mailto:[EMAIL PROTECTED] http://www.communisis-one.co.uk ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: any way to retrieve the actual SQL used
Why not write the query text into a session variable when you execute it the first time? Nick -Original Message- From: Chris Phillips [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 10:51 AM To: CF-Talk Subject: any way to retrieve the actual SQL used Hi all Is there any way to retrieve the actual SQL (rather than the records returned) by a dynamic query? ie I have a page that bases its query on the form fields filled in on the previous page. I want to actually use the SQL statement for sth else. It comes out if you turn debugging on, but is it accessible eg as a variable of some sort? Any thoughts are welcome Many thanks in advance Chris chris phillips communisis one plc multimedia team 0113 225 5373 mailto:[EMAIL PROTECTED] http://www.communisis-one.co.uk ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Status in UK
Currently there are 76 contract positions, and 344 permie jobs on Jobserve.com You also have to consider that no job is just ColdFusion, and a lot of contract jobs require major amounts of software engineering experience. If you come from a HTML/Coldfusion background with some database design, then you would be considered a 'weak' CF candidate. You need to know how to do requirements analysis, design, implementation, testing and probably done this in low-level languages (C, C++) as well as ColdFusion and probably experience in multiple databases. -Original Message- From: DeVoil, Nick [SMTP:[EMAIL PROTECTED]] Sent: 26 March 2001 10:05 To: CF-Talk Subject:RE: CF Status in UK There are UK-based CF contracts every week on www.jobserve.com. There was a thread on CF status in the UK on the list a while back, you should be able to find it in the archives. Basically with your experience you shouldn't have any problems if your company know what they're doing. Also, try the cf-jobs list which is more appropriate for this subject. Good luck Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 9:44 AM To: CF-Talk Subject: CF Status in UK Hi, Could anybody tell me how is ColdFusion doing in UK? Is it not in demand here now? Actually, I came here in UK from India on 29th Jan., 2001 as a Software Consultant through NovaSoft Info. Tech. (Europe) Ltd. (http://www.novasoftinfo.co.uk and http://www.novasoftinfo.com). They hire Software Professionals from India and place them here on Contract basis. My main skills are ColdFusion. I am having 2 yrs exp. in ColdFusion with SQL, Access, JavaScript, HTML, and Dreamweaver etc. I have developed 10 sites using ColdFusion. Now almost two months have been completed and I am still on Bench. Not only myself, there are other 4 ColdFusion professionals they are also on bench. NovaSoft is not able to place anybody. What they are saying is that there is no market for ColdFusion in UK now and the situation will remain same for next 5-6 months atleast. I have already wasted almost 2 months for the process for coming to UK and 2 months on bench and if the situation is going to remain for next 5-6 months, it is going to spoil my career very badly. Moreover, company might take some harsh decisions also. I am in great dilemma now-a-days. Could you please tell me the status of ColdFusion in UK or could anybody guide me overcoming this problem? Any kind of help/suggestion is welcome. Thanks and Regards, Rajesh Kumar ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Select distinct not working
You have message date as a declared field and you are using it in the order
statement. Since that is in the message table you will get a row for each
date. You would be better of using grouping to do this assumming you want
the latest date, try something like this:
SELECT m.bbsThread, t.bbsThreadTitle, t.bbsCategory, t.bbsIsClosed,
c.bbsCatID, c.bbsCatTitle,max(m.bbsMessageDate)
FROMtbl_BBS_Messages AS m, tbl_BBS_Threads AS t,
tbl_BBS_Categories AS c
GROUP BY
m.bbsThread, t.bbsThreadTitle, t.bbsCategory, t.bbsIsClosed, c.bbsCatID,
c.bbsCatTitle
WHERE DateDiff(d,m.bbsMessageDate, #local.today#)
1
AND t.bbsThreadID = m.bbsThread
AND t.bbsCategory = c.bbsCatID
ORDER BYmax(m.bbsMessageDate), c.bbsCatTitle
-Original Message-
From: Chris Martin [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 20:17
To: CF-Talk
Subject: Select distinct not working
I was wondering if anyone can see anything wrong with this query:
SELECT Distinct m.bbsThread, t.bbsThreadTitle, m.bbsMessageDate,
t.bbsCategory, t.bbsIsClosed, c.bbsCatID, c.bbsCatTitle
FROMtbl_BBS_Messages AS m, tbl_BBS_Threads AS t,
tbl_BBS_Categories AS c
WHERE DateDiff(d,m.bbsMessageDate, #local.today#)
1
AND t.bbsThreadID = m.bbsThread
AND t.bbsCategory = c.bbsCatID
ORDER BYm.bbsMessageDate, c.bbsCatTitle
I run it, and it will return two results for the same thread, even though I
have select distinct in there. Any one know why?
Thanks,
Chris Martin
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 9:41 PM
To: CF-Talk
Subject: Re: Textbox validation
One of the Figleaf guys posted a much nicer version of this using regex a
month or so back, so you may want to check the archives.
Here is what I use to keep people from typing characters in text fields
though.
This goes in head
SCRIPT TYPE="text/javascript"
!--
function letternumber(e)
{
var key;
var keychar;
if (window.event)
key = window.event.keyCode;
else if (e)
key = e.which;
else
return true;
keychar = String.fromCharCode(key);
keychar = keychar.toLowerCase();
// control keys
if ((key==null) || (key==0) || (key==8) ||
(key==9) || (key==13) || (key==27) )
return true;
// alphas and numbers
else if ((("abcdefghijklmnopqrstuvwxyz0123456789 ").indexOf(keychar) -1))
return true;
else
return false;
}
//--
/SCRIPT
Call it with this in you input tag.
onKeyPress="return letternumber(event)"
Just change the characters to whatever you want. It will work for spaces
also.
Of course though, you should never rely on javascript...
jon
- Original Message -
From: "W Luke" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, March 22, 2001 7:39 PM
Subject: Textbox validation
Hi,
On one textbox I need to prohibit users entering more than one word - I
don't want them to enter a space. What's the best way of doing this -
Javascript, or Cold Fusion after the form has been posted?
Thanks.
Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Re. image sizes
There is a simple CF tag called CF_imagesize in the tag gallery which will return dimensions for GIFs and JPGs. Can't remember if it'll work for progressive JPGs though. Anyway, thought I'd mention it 'cos it's probably faster that a CFX if all you want to do is get the image size. Mark At 01:07 PM 3/25/2001, you wrote: Re. image sizes Thats a fair point Kay - we only use it for gifs. Think I'll try your tag out for jpgs. Are you sure CFX_Image came after CFX_GIFGD? Bill Davies www.web21st.net -Original Message- From: CF-Talk [mailto:[EMAIL PROTECTED]] Sent: 25 March 2001 12:25 To: [EMAIL PROTECTED] Subject: CF-Talk-list V1 #232 CF-Talk-list Sun, 25 Mar 2001 Volume 1 : Number 232 In this issue: cfx directory Re: cfx directory Re: Allaire Developers Conference? RE: cfx directory Re: image sizes RE: Reseller recomendations cfx_http tag available? Re: cfx directory Re: cfx directory Re: cfx_http tag available? Re: cfx_http tag available? munchkinlan -- Date: Sun, 25 Mar 2001 11:29:09 -0800 From: "nizam" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: cfx directory Message-ID: 005601c0b561$f2d6ea40$62c497ca@h9c3m9 Hi everybody, I'm using win98 and cf4.5.1...can I know where is the directory for cfx custom tags. I get error that say my cfx_http is not in my database. Why it's happen Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Select distinct not working
Looks like its doing a record for each distinct date in the message table,
when presumably you only wnat the latest. BTW you don't need the codes in
the joins as display fields. You would be better using group for this kind
of thing.
Something like this should work:
SELECT t.bbsThreadTitle,
t.bbsIsClosed, c.bbsCatTitle, Max(m.bbsMessageDate)
FROMtbl_BBS_Messages AS m, tbl_BBS_Threads AS t, tbl_BBS_Categories AS c
GROUP BY
t.bbsThreadTitle,
t.bbsIsClosed, c.bbsCatTitle
WHERE DateDiff(d,m.bbsMessageDate, #local.today#)
1
AND t.bbsThreadID = m.bbsThread
AND t.bbsCategory = c.bbsCatID
ORDER BYMax(m.bbsMessageDate), c.bbsCatTitle
-Original Message-
From: Chris Martin [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 20:17
To: CF-Talk
Subject: Select distinct not working
I was wondering if anyone can see anything wrong with this query:
SELECT Distinct m.bbsThread, t.bbsThreadTitle, m.bbsMessageDate,
t.bbsCategory, t.bbsIsClosed, c.bbsCatID, c.bbsCatTitle
FROMtbl_BBS_Messages AS m, tbl_BBS_Threads AS t,
tbl_BBS_Categories AS c
WHERE DateDiff(d,m.bbsMessageDate, #local.today#)
1
AND t.bbsThreadID = m.bbsThread
AND t.bbsCategory = c.bbsCatID
ORDER BYm.bbsMessageDate, c.bbsCatTitle
I run it, and it will return two results for the same thread, even though I
have select distinct in there. Any one know why?
Thanks,
Chris Martin
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 22, 2001 9:41 PM
To: CF-Talk
Subject: Re: Textbox validation
One of the Figleaf guys posted a much nicer version of this using regex a
month or so back, so you may want to check the archives.
Here is what I use to keep people from typing characters in text fields
though.
This goes in head
SCRIPT TYPE="text/javascript"
!--
function letternumber(e)
{
var key;
var keychar;
if (window.event)
key = window.event.keyCode;
else if (e)
key = e.which;
else
return true;
keychar = String.fromCharCode(key);
keychar = keychar.toLowerCase();
// control keys
if ((key==null) || (key==0) || (key==8) ||
(key==9) || (key==13) || (key==27) )
return true;
// alphas and numbers
else if ((("abcdefghijklmnopqrstuvwxyz0123456789 ").indexOf(keychar) -1))
return true;
else
return false;
}
//--
/SCRIPT
Call it with this in you input tag.
onKeyPress="return letternumber(event)"
Just change the characters to whatever you want. It will work for spaces
also.
Of course though, you should never rely on javascript...
jon
- Original Message -
From: "W Luke" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, March 22, 2001 7:39 PM
Subject: Textbox validation
Hi,
On one textbox I need to prohibit users entering more than one word - I
don't want them to enter a space. What's the best way of doing this -
Javascript, or Cold Fusion after the form has been posted?
Thanks.
Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Calling all FreeLance CF Gurus!
Hi Everyone, Me and My great staff have been very busy working with the casino vendors and tons of marketing teams here in bright Las Vegas! We are in need of a few good freelance REMOTE coders. We have several small projects and one big project due to start in 2 weeks. Obviously this would be a great place for someone to step in create a alliance/partnership which we could constantly send projects to. We want to have a definite individual lined up by the 1st. Since there are a couple of client the prices range with work, but once we take a peek at the following we'll bring you into the loop. We have prepared the scope of work; So you just have to focus on coding. WE DON'T WANT THIRD PARTIES! LOOKING FOR DEDICATED OPEN INDIVIDUALS ONLY. YOU MUST BE WILING TO SIGN A NON_DISCLOSURE/NON-COMPETE. Please complete the linked form at: http://24.234.179.102/emp/1.cfm . The window for application will be open till 3/28/01 at which point we will be making selections. Thanks, Brian Thornton LASVEGAS.COM [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfscheduler weird thing...
Maybe I read the Allaire article wrong, but I assumed that if you want to use the method they suggest (calling the executable and passing it parameters), you would have to reference the physical path to the template you wanted to run, ie D:\Inetpub\wwwroot\directory\file.cfm. Yes, you would. With several servers and a range of sites on each, I assumed you'd have to set up the scheduling software on each machine that had a site for which you wanted to run a scheduled event (...if that made any sense whatsoever!). I dunno what you need to achieve, and maybe I'm not thinking straight (hey, it's now Monday morning and it's been a rough weekend), but I think you should be able to have all you scheduled tasks on one server and have those tasks make changes on the other servers. Scripts executed from a HTTP request should be able to make any changes to a server that are necessary, so a scheduled tasks running on one server should be able to remotely manage/update/whatever other servers. For example, I've just set up something to monitor the CF and SQL Server services on server A from server B. If server B finds a failure on A it runs an ASP script on A to stop and start the necessary services. And ditto about that Friday-feeling *uggh* I think I'm a midweek kinda person, Monday mornings are worse. At least on Fridays there's a weekend to look forward to. ;- Mark ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help - cftoken is killing me
My system works fine in localserver, the nightmare begin when I moved it to my main server. All cflocation without addtoken="yes" will kick the user out. (session check) And the most weird case is that the system works fine using IE5.0 but NOT IE 5.5 It's driving me mad, somebody please help! Thanks in advance - Rudy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
After Update display same name and show changes
Question: I have a form that allows the user to update all the information on someone but brings them back to the first person in the database, and I need to bring them right back to the same person that they were working on, what do I need to do on the action page, I say action page because I believe that is where this code would need to take place. TIA Michael ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFTOKEN Question
Does anyone know how to STOP the CFTOKEN / CFID from being appended to the URL when a form post occurs? I am posting to a website which will only validate the data if the HTTP REFERER is : http://www.mydomain.com AND NOT http://www.mydomain.com?CFID=BALHBALHCFTOKEN=BLAHBLAH Thanks in advance. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: crystal report report
Hi Sima,
thanks a lot!
i didn't know this web address until you told me.
thanks again!
chang
- Original Message -
From: "Sima Lee" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 23, 2001 3:26 PM
Subject: RE: crystal report report
Hi,
GO to :
http://www.mail-archive.com/cf-talk@houseoffusion.com/
Do a search on Stopping/starting CF with NT "AT"
Regards,
Sima Lee
-Original Message-
From: Chang Liu [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 2:12 PM
To: CF-Talk
Subject: Re: crystal report report
Hi Ben,
you said:
There was a cf-talk thread on Wed. 3/21: Stopping/starting CF with NT
"AT"
that addressed doing this automatically with CF running on NT or
Win2K.
I went to houseoffusion.com, however, I couldn't find it.
Could you please tell me how I can find it?
thanks again!
- Original Message -
From: "Braver, Ben" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, March 23, 2001 12:03 PM
Subject: RE: crystal report report
I get this periodically due apparently to a memory leak in an ODBC
driver
or
something.
What solves it immediately is stopping and restarting the CF services.
There was a cf-talk thread on Wed. 3/21: Stopping/starting CF with NT
"AT"
that addressed doing this automatically with CF running on NT or
Win2K.
HTH.
Ben
-Original Message-
From: Chang Liu [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 8:50 AM
To: CF-Talk
Subject: crystal report report
Hi all,
here is my code:
CFREPORT REPORT="Report1.rpt"
{Class.Class_ID} = "3"
/CFREPORT
here is my Error Diagnostic Information:
Report not completed (the report server was busy)
The requested report could not be completed because the server was
extremely
busy serving other report requests. Please notify the site
administrator
that the default TIMEOUT for the report server should be increased.
any ideas?
thanks a lot!
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFTOKEN Question - part 2
Sorry seems as if I never receive email from House of Fusion so I am not sure if this posted or not. Please excuse the 2nd Post. Does anyone know how to STOP the CFTOKEN / CFID from being appended to the URL when a form post occurs? I am posting to a website which will only validate the data if the HTTP REFERER is : http://www.mydomain.com AND NOT http://www.mydomain.com?CFID=BALHBALHCFTOKEN=BLAHBLAH Thanks in advance. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reseller recommendations
I had asked Mickael D. about starting an FAQ page on houseoffusion where we could point the people looking for a host, but he never answered me...(I even offered to do it) :( Wouldn't this be a good idea? I once got flamed for recommending a host on another list (one that I have no ties with other than my use, and also get no kickbacks) so the moderator put together a member's only recommendation of hosts and it proves to be quite useful. This would cut out any advertising, intentional or otherwise... Erika -Original Message- From: Steve Pierce [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 25, 2001 12:12 AM To: CF-Talk Subject: RE: Reseller recomendations Dear Robert (net_man) If you want to advertise your company on the list, you should disclose your association and any financial relationship you have in making your recommendation. I for one am tired of the constant push of atsweb on this list. It is unfair and disrespectful to the hundreds of other web hosting companies on this list. I also applaud the hundreds of other folks on this list who show some restraint and don't post their company's name on the list every time someone asks for a hosting recommendation. It is too bad you can't use the same restraint. As a general courtesy, you should take the time to email the person directly with your suggestion rather than spamming the list. There is no need to keep bombarding the list with your recommendation for a startup webhosting company with almost no track record, incomplete services, and using a shared data service from a small utility company in Georgia. There is one thing to recommend a company because you are customer, it is an entirely different matter to be an employee or somehow have a financial stake in a company that you are constantly pushing. I wish you the best of luck in your startup, but there is no need to be posting blatant and repetitive advertising to this list. We get it. You are involved in a new company. But how about lets post some info on here that is a technical nature about Cold Fusion and not spam advertising for a new webhosting company. - Steve Steve Pierce, HDL -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 24, 2001 7:33 PM To: CF-Talk Subject: Re: Reseller recomendations Checkout www.atswebnet.com Control Panel is almost done, but you can resell accounts for as low as $4.95/month/each domain if you buy the right package. Check it out... Robert - Original Message - From: "ibtoad" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Saturday, March 24, 2001 7:04 PM Subject: Reseller recomendations I am looking to become a reseller where I have access to a control panel with a custom tags directory, cffile, cfdirectory, etc. to my cutomers accounts. Can anyone recommend a host company that offers these features? Thanks, Rich -Original Message- From: Terry Bader [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 24, 2001 6:09 PM To: CF-Talk Subject: cftransaction q: in the book, it says not all odbc drivers support all the lock types so... lets say the back-end is moved over to a non-supported db, what will happen when the application hits the cftransaction? will it break or be ignored?? Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
AOHell
Have you had problems with AOL blocking delivery of email from a list server (apparently mistakenly believing the email is from a spammer)? If so, is there a fix/work-around other than breaking delivery to AOL into smaller "chunks" of messages? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Good Books on JSP?
Good Morning All! it is once again time to learn something new. what is the WACK equivalent to JSP books out there? just got a bug to learn something new! thanks -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Think your good? Prove it!
Which if the following statements are TRUE. should be which of -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 25, 2001 12:02 PM To: CF-Talk Subject: OT: Think your good? Prove it! With my "Certified ColdFusion Developer Study Guide" about to ship, I have put a sample CF exam online. It's not an easy exam, and it'll be different each time you take it. So, if you are feeling brave, give it a try at http://www.forta.com/books/0789725657/ (there's a link at the bottom of that page). Enjoy! --- Ben PS If you have comments or questions about the exam, reply to me directly (not here on the list). The test application is brand new, so any help ironing out the kinks is appreciated. == Ben Forta - Macromedia Inc. E-Mail: [EMAIL PROTECTED] Phone: (248)424-8420 Fax:(248)424-8421 Macromedia: http://www.macromedia.com/ Allaire:http://www.allaire.com/ Personal: http://www.forta.com/ WAP is hot! Want to know more? You need "The WAP Book" - go to http://www.thewapbook.com/ for more info! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Think your good? Prove it!
Thanks, fixed --- Ben -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 9:13 AM To: CF-Talk Subject: RE: Think your good? Prove it! Which if the following statements are TRUE. should be which of -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 25, 2001 12:02 PM To: CF-Talk Subject: OT: Think your good? Prove it! With my "Certified ColdFusion Developer Study Guide" about to ship, I have put a sample CF exam online. It's not an easy exam, and it'll be different each time you take it. So, if you are feeling brave, give it a try at http://www.forta.com/books/0789725657/ (there's a link at the bottom of that page). Enjoy! --- Ben PS If you have comments or questions about the exam, reply to me directly (not here on the list). The test application is brand new, so any help ironing out the kinks is appreciated. == Ben Forta - Macromedia Inc. E-Mail: [EMAIL PROTECTED] Phone: (248)424-8420 Fax:(248)424-8421 Macromedia: http://www.macromedia.com/ Allaire:http://www.allaire.com/ Personal: http://www.forta.com/ WAP is hot! Want to know more? You need "The WAP Book" - go to http://www.thewapbook.com/ for more info! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Think your good? Prove it!
sorry, meant to go to you directly. dough... i failed horribly : ] time to buy a new book. -paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Good Books on JSP?
javascript bible is not bad, or look at O'Reily's there is pretty good too HTH Michael "Paul Ihrig" [EMAIL PROTECTED] wrote in message 1097F6DBC531D2118F180008C7B1682D03A153B5@NBBJCMHEX1">news:1097F6DBC531D2118F180008C7B1682D03A153B5@NBBJCMHEX1... Good Morning All! it is once again time to learn something new. what is the WACK equivalent to JSP books out there? just got a bug to learn something new! thanks -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax: 614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Is this possible?
Hey all, Is it possible to determine what a user has inputted in a form BEFORE the form is submitted? What I would like to do is IF a user makes a selection in the form that conflicts with information already in the db, I want to have a javascript popup alert them to the discrepancy and have them verify if they want to continue. Otherwise, just a regular submit button would be displayed. I have the javascript alert/confirm working alright, but I can't figure out how to get it to check the formfields and only display conditionally. I don't even think this is possible, considering that CF is server-side and essentially what I want to do is have CF determine what was selected BEFORE it is submitted. Is there a way I can determine this with JavaScript (I'm not very good at JS, so "baby steps", please ;). I know I could do this within CF and just have the form submit to an interim confirmation page, but I would rather do this on the client. Thanks! Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Escaping apostrophes
Hello, This must be a basic question, but I found no real answer on the allaire forums. I want to allow users to enter apostrophes in text, which I then save to the database. However, the sql insert will fail as it interprets this apostrophe within the text as one of the apostrophes surrounding the text. Example: INSERT INTO tblUserComments (userid, usercomment) VALUES (12345, 'I don't know what to think') This fails on the ' in don't There must be a better solution than HTMLEditFormat. Thanks in advance. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Good Books on JSP?
he was asking about JSP, not JavaScript. check out Core Servlets and Java Server Pages: http://www.amazon.com/exec/obidos/ASIN/0130893404/o/qid=985617480/sr=8-2/ref =aps_sr_b_1_2/002-0318000-5943236 -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 6:32 AM To: CF-Talk Subject: Re: Good Books on JSP? javascript bible is not bad, or look at O'Reily's there is pretty good too HTH Michael "Paul Ihrig" [EMAIL PROTECTED] wrote in message 1097F6DBC531D2118F180008C7B1682D03A153B5@NBBJCMHEX1">news:1097F6DBC531D2118F180008C7B1682D03A153B5@NBBJCMHEX1... Good Morning All! it is once again time to learn something new. what is the WACK equivalent to JSP books out there? just got a bug to learn something new! thanks -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax: 614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this possible?
yes you can do this. you can reference the form elements by object name. you don't have to submit the form to validate or check values. you can do it using onFocus and/or onBlur. -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 6:34 AM To: CF-Talk Subject: Is this possible? Hey all, Is it possible to determine what a user has inputted in a form BEFORE the form is submitted? What I would like to do is IF a user makes a selection in the form that conflicts with information already in the db, I want to have a javascript popup alert them to the discrepancy and have them verify if they want to continue. Otherwise, just a regular submit button would be displayed. I have the javascript alert/confirm working alright, but I can't figure out how to get it to check the formfields and only display conditionally. I don't even think this is possible, considering that CF is server-side and essentially what I want to do is have CF determine what was selected BEFORE it is submitted. Is there a way I can determine this with JavaScript (I'm not very good at JS, so "baby steps", please ;). I know I could do this within CF and just have the form submit to an interim confirmation page, but I would rather do this on the client. Thanks! Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Good Books on JSP?
You can learn the basics of JSP in a couple of hours but to learn Java ... Starting Java2 by WROX - good starting book for non-programmers Java Server Programming by Wrox - good starting book for using java server side All the Java in a Nutshell books by OReilly for reference java.sun.com docs and tutorials and the JavaDocs stuff.. I'd say the Wrox , and OReilly book on JSP are pretty but the more generic java book would be better value, especially since the JSP book probably spend half the page telling you how to install a webserver , how HTTP work , which you know already etc. etc Justin :-) -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 3:08 PM To: CF-Talk Subject: OT: Good Books on JSP? Good Morning All! it is once again time to learn something new. what is the WACK equivalent to JSP books out there? just got a bug to learn something new! thanks -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax: 614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Escaping apostrophes
try the #preservesinglequotes(text)# function - Original Message - From: "andrew kopelman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, March 26, 2001 2:38 PM Subject: Escaping apostrophes Hello, This must be a basic question, but I found no real answer on the allaire forums. I want to allow users to enter apostrophes in text, which I then save to the database. However, the sql insert will fail as it interprets this apostrophe within the text as one of the apostrophes surrounding the text. Example: INSERT INTO tblUserComments (userid, usercomment) VALUES (12345, 'I don't know what to think') This fails on the ' in don't There must be a better solution than HTMLEditFormat. Thanks in advance. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Escaping apostrophes
PreserveSingleQuotes(). chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: andrew kopelman [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 2:39 PM To: CF-Talk Subject: Escaping apostrophes Hello, This must be a basic question, but I found no real answer on the allaire forums. I want to allow users to enter apostrophes in text, which I then save to the database. However, the sql insert will fail as it interprets this apostrophe within the text as one of the apostrophes surrounding the text. Example: INSERT INTO tblUserComments (userid, usercomment) VALUES (12345, 'I don't know what to think') This fails on the ' in don't There must be a better solution than HTMLEditFormat. Thanks in advance. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [OT: Good Books on JSP?]
First do you already know plain java? That would probably be better to learn. Second, there are jsp custom tags that make using JSP almost like using CF; take a look at www.apache.org's tomcat taglib. Paul Ihrig [EMAIL PROTECTED] wrote: Good Morning All! it is once again time to learn something new. what is the WACK equivalent to JSP books out there? just got a bug to learn something new! thanks -paul Web Developer, NBBJ Work: [EMAIL PROTECTED] 614 241-3534 fax:614 485-5534 Home: [EMAIL PROTECTED] 614 449-1681 icq: 47658358 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this possible?
Thanks, Dylan. That gives me a direction to go in. I'll look this up. Thanks! Original Message Follows From: "Dylan Bromby" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: Is this possible? Date: Mon, 26 Mar 2001 06:39:37 -0800 yes you can do this. you can reference the form elements by object name. you don't have to submit the form to validate or check values. you can do it using onFocus and/or onBlur. -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 6:34 AM To: CF-Talk Subject: Is this possible? Hey all, Is it possible to determine what a user has inputted in a form BEFORE the form is submitted? What I would like to do is IF a user makes a selection in the form that conflicts with information already in the db, I want to have a javascript popup alert them to the discrepancy and have them verify if they want to continue. Otherwise, just a regular submit button would be displayed. I have the javascript alert/confirm working alright, but I can't figure out how to get it to check the formfields and only display conditionally. I don't even think this is possible, considering that CF is server-side and essentially what I want to do is have CF determine what was selected BEFORE it is submitted. Is there a way I can determine this with JavaScript (I'm not very good at JS, so "baby steps", please ;). I know I could do this within CF and just have the form submit to an interim confirmation page, but I would rather do this on the client. Thanks! Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Escaping apostrophes
I think you could either use the PreserverSingleQuotes function or use REPLACE and add an extra apostrophe for each apostrophe. -Original Message- From: andrew kopelman [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 2:39 PM To: CF-Talk Subject: Escaping apostrophes Hello, This must be a basic question, but I found no real answer on the allaire forums. I want to allow users to enter apostrophes in text, which I then save to the database. However, the sql insert will fail as it interprets this apostrophe within the text as one of the apostrophes surrounding the text. Example: INSERT INTO tblUserComments (userid, usercomment) VALUES (12345, 'I don't know what to think') This fails on the ' in don't There must be a better solution than HTMLEditFormat. Thanks in advance. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Think your good? Prove it!
this looks great... took the test, didn't "fail" but i didn't get a great score in my opinion so your new book will be nice to use... also, do you get more credit if the book is bought from the link off your page? just wondering whether to get it from your page or go and reserve it down the street. Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 25, 2001 12:02 PM To: CF-Talk Subject: OT: Think your good? Prove it! With my "Certified ColdFusion Developer Study Guide" about to ship, I have put a sample CF exam online. It's not an easy exam, and it'll be different each time you take it. So, if you are feeling brave, give it a try at http://www.forta.com/books/0789725657/ (there's a link at the bottom of that page). Enjoy! --- Ben PS If you have comments or questions about the exam, reply to me directly (not here on the list). The test application is brand new, so any help ironing out the kinks is appreciated. == Ben Forta - Macromedia Inc. E-Mail: [EMAIL PROTECTED] Phone: (248)424-8420 Fax:(248)424-8421 Macromedia: http://www.macromedia.com/ Allaire:http://www.allaire.com/ Personal: http://www.forta.com/ WAP is hot! Want to know more? You need "The WAP Book" - go to http://www.thewapbook.com/ for more info! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Calling all FreeLance CF Gurus!
HAHAHAA did anyone by chance go to the linked page?? the first question in the appliaction is: Mt. Dew or Dr. Pepper:* | | I thought that was hilarious I wonder which one gets the preference? Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 5:47 AM To: CF-Talk Subject: Calling all FreeLance CF Gurus! Hi Everyone, Me and My great staff have been very busy working with the casino vendors and tons of marketing teams here in bright Las Vegas! We are in need of a few good freelance REMOTE coders. We have several small projects and one big project due to start in 2 weeks. Obviously this would be a great place for someone to step in create a alliance/partnership which we could constantly send projects to. We want to have a definite individual lined up by the 1st. Since there are a couple of client the prices range with work, but once we take a peek at the following we'll bring you into the loop. We have prepared the scope of work; So you just have to focus on coding. WE DON'T WANT THIRD PARTIES! LOOKING FOR DEDICATED OPEN INDIVIDUALS ONLY. YOU MUST BE WILING TO SIGN A NON_DISCLOSURE/NON-COMPETE. Please complete the linked form at: http://24.234.179.102/emp/1.cfm . The window for application will be open till 3/28/01 at which point we will be making selections. Thanks, Brian Thornton LASVEGAS.COM [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Escaping apostrophes
Just thoughts: 1. Search the string before add/update the query and replace the single quote with a never used character like the pipe "|", then when the data needs to be rendered on the browser, just search it before display and replace the pipe with the single quote. 2. Search the string before add/update the query and replace the single quote with a "chr(39)" this literally should replace all single quotes with the actual string chr(39), search the string for chr(39) on output and put pound signs aound it. It seems to me I have tried using the PreserveSingleQuotes function with no success. -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 9:49 AM To: CF-Talk Subject: Re: Escaping apostrophes try the #preservesinglequotes(text)# function - Original Message - From: "andrew kopelman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, March 26, 2001 2:38 PM Subject: Escaping apostrophes Hello, This must be a basic question, but I found no real answer on the allaire forums. I want to allow users to enter apostrophes in text, which I then save to the database. However, the sql insert will fail as it interprets this apostrophe within the text as one of the apostrophes surrounding the text. Example: INSERT INTO tblUserComments (userid, usercomment) VALUES (12345, 'I don't know what to think') This fails on the ' in don't There must be a better solution than HTMLEditFormat. Thanks in advance. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: any way to retrieve the actual SQL used
Thanks both of you Chris ^-Original Message- ^From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] ^Sent: 26 March 2001 10:40 ^To: CF-Talk ^Subject: RE: any way to retrieve the actual SQL used ^ ^ ^Why not write the query text into a session variable when you ^execute it the first time? ^ ^Nick ^ ^-Original Message- ^From: Chris Phillips [mailto:[EMAIL PROTECTED]] ^Sent: Monday, March 26, 2001 10:51 AM ^To: CF-Talk ^Subject: any way to retrieve the actual SQL used ^ ^ ^Hi all ^ ^Is there any way to retrieve the actual SQL (rather than the records ^returned) by a dynamic query? ^ ^ie I have a page that bases its query on the form fields ^filled in on the ^previous page. I want to actually use the SQL statement for sth else. ^ ^It comes out if you turn debugging on, but is it accessible eg ^as a variable ^of some sort? ^ ^Any thoughts are welcome ^ ^Many thanks in advance ^ ^Chris ^ ^ ^ chris phillips ^ communisis one plc multimedia team ^ 0113 225 5373 ^ mailto:[EMAIL PROTECTED] ^ http://www.communisis-one.co.uk ^ ^ ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this possible?
But Terri wants to compare the client-side form element values to what's in the db. In order to do this, she'll have to get the db info into JS. She could query for the data and then convert it to JS via CFWDDX ACTION=CFML2JS. -David On Monday, March 26, 2001 6:40 AM, Dylan Bromby [SMTP:[EMAIL PROTECTED]] wrote: yes you can do this. you can reference the form elements by object name. you don't have to submit the form to validate or check values. you can do it using onFocus and/or onBlur. -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 6:34 AM To: CF-Talk Subject: Is this possible? Hey all, Is it possible to determine what a user has inputted in a form BEFORE the form is submitted? What I would like to do is IF a user makes a selection in the form that conflicts with information already in the db, I want to have a javascript popup alert them to the discrepancy and have them verify if they want to continue. Otherwise, just a regular submit button would be displayed. I have the javascript alert/confirm working alright, but I can't figure out how to get it to check the formfields and only display conditionally. I don't even think this is possible, considering that CF is server-side and essentially what I want to do is have CF determine what was selected BEFORE it is submitted. Is there a way I can determine this with JavaScript (I'm not very good at JS, so "baby steps", please ;). I know I could do this within CF and just have the form submit to an interim confirmation page, but I would rather do this on the client. Thanks! Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Escaping apostrophes
I don't find I need to do anything to escape a " ' " in text placed in forms. Someone here explained why, but I don't recall the reason. I'm using SQL7. best, paul At 08:50 AM 3/26/01 -0600, you wrote: I think you could either use the PreserverSingleQuotes function or use REPLACE and add an extra apostrophe for each apostrophe. -Original Message- From: andrew kopelman [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 2:39 PM To: CF-Talk Subject: Escaping apostrophes Hello, This must be a basic question, but I found no real answer on the allaire forums. I want to allow users to enter apostrophes in text, which I then save to the database. However, the sql insert will fail as it interprets this apostrophe within the text as one of the apostrophes surrounding the text. Example: INSERT INTO tblUserComments (userid, usercomment) VALUES (12345, 'I don't know what to think') This fails on the ' in don't There must be a better solution than HTMLEditFormat. Thanks in advance. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Escaping apostrophes
if you're using SQL Server, your variable can have 's in it and you don't need to use PreserveSingleQuotes(). can you post the code that doesn't work? -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 6:58 AM To: CF-Talk Subject: RE: Escaping apostrophes Just thoughts: 1. Search the string before add/update the query and replace the single quote with a never used character like the pipe "|", then when the data needs to be rendered on the browser, just search it before display and replace the pipe with the single quote. 2. Search the string before add/update the query and replace the single quote with a "chr(39)" this literally should replace all single quotes with the actual string chr(39), search the string for chr(39) on output and put pound signs aound it. It seems to me I have tried using the PreserveSingleQuotes function with no success. -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 9:49 AM To: CF-Talk Subject: Re: Escaping apostrophes try the #preservesinglequotes(text)# function - Original Message - From: "andrew kopelman" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, March 26, 2001 2:38 PM Subject: Escaping apostrophes Hello, This must be a basic question, but I found no real answer on the allaire forums. I want to allow users to enter apostrophes in text, which I then save to the database. However, the sql insert will fail as it interprets this apostrophe within the text as one of the apostrophes surrounding the text. Example: INSERT INTO tblUserComments (userid, usercomment) VALUES (12345, 'I don't know what to think') This fails on the ' in don't There must be a better solution than HTMLEditFormat. Thanks in advance. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Calling all FreeLance CF Gurus!
While I'm still in bed sick, I requested from the poster that job related posts not be reposted to the CF-Talk or other lists. Due to a long thread that started on the jobs list when I posted looking for a job, some people have complained about OT posts. I'm going to try and step in on them now. If we could end this one or move it to CF-Community, I'd appreciate it. Thanks HAHAHAA did anyone by chance go to the linked page?? the first question in the appliaction is: Mt. Dew or Dr. Pepper:* | | I thought that was hilarious I wonder which one gets the preference? Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 5:47 AM To: CF-Talk Subject: Calling all FreeLance CF Gurus! Hi Everyone, Me and My great staff have been very busy working with the casino vendors and tons of marketing teams here in bright Las Vegas! We are in need of a few good freelance REMOTE coders. We have several small projects and one big project due to start in 2 weeks. Obviously this would be a great place for someone to step in create a alliance/partnership which we could constantly send projects to. We want to have a definite individual lined up by the 1st. Since there are a couple of client the prices range with work, but once we take a peek at the following we'll bring you into the loop. We have prepared the scope of work; So you just have to focus on coding. WE DON'T WANT THIRD PARTIES! LOOKING FOR DEDICATED OPEN INDIVIDUALS ONLY. YOU MUST BE WILING TO SIGN A NON_DISCLOSURE/NON-COMPETE. Please complete the linked form at: http://24.234.179.102/emp/1.cfm . The window for application will be open till 3/28/01 at which point we will be making selections. Thanks, Brian Thornton LASVEGAS.COM [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this possible?
what Terri could so is query the DB on loading the page, then validate the
answers with a simple JS function.
script Language="JavaScript" type="text/javascript"
function Check_Items(Item1,Item2){
if (Item1.value!=Item2.value){
alert ("These contradict the DB")
Item1.setfocus();
}
return;
}
/script
then in the page
input type="text" Name="MyInput"
onblur="Check_Items(MyInput,#Db_check_Item#);"
this should work, you might have to wrap round a CFOutput, round the Input
tag.
In theory it should work, give it a try and let me know.
Jason Lees
National Express
Email : [EMAIL PROTECTED]
-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2001 16:00
To: CF-Talk
Subject: RE: Is this possible?
But Terri wants to compare the client-side form element values to what's in
the
db. In order to do this, she'll have to get the db info into JS. She could
query for the data and then convert it to JS via CFWDDX ACTION=CFML2JS.
-David
On Monday, March 26, 2001 6:40 AM, Dylan Bromby [SMTP:[EMAIL PROTECTED]]
wrote:
yes you can do this. you can reference the form elements by object name.
you
don't have to submit the form to validate or check values. you can do it
using onFocus and/or onBlur.
-Original Message-
From: Terri Stocke [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 6:34 AM
To: CF-Talk
Subject: Is this possible?
Hey all,
Is it possible to determine what a user has inputted in a form BEFORE the
form is submitted? What I would like to do is IF a user makes a selection
in
the form that conflicts with information already in the db, I want to have
a
javascript popup alert them to the discrepancy and have them verify if
they
want to continue. Otherwise, just a regular submit button would be
displayed.
I have the javascript alert/confirm working alright, but I can't figure
out
how to get it to check the formfields and only display conditionally. I
don't even think this is possible, considering that CF is server-side and
essentially what I want to do is have CF determine what was selected
BEFORE
it is submitted. Is there a way I can determine this with JavaScript (I'm
not very good at JS, so "baby steps", please ;).
I know I could do this within CF and just have the form submit to an
interim
confirmation page, but I would rather do this on the client.
Thanks!
Terri
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this possible?
Just done some refining of the code. This will work, as long as you are
holding the validation results in a Query.
THe previosu version doesn't work because I was assuming that Item2 was an
object, but its not its a literal.
script Language="JavaScript" type="text/javascript"
function Check_Items(Item1,Item2){
if (Item1.value!='')
return;
if (Item1.value!=Item2){
alert ("These contradict the DB")
Item1.focus();
}
return;
}
/script
cfoutput
input type="text" name="X" value=""
onblur="Check_Items(X,'#MyQuery.MyField#');"
/cfoutput
Jason Lees
National Express
Email : [EMAIL PROTECTED]
-Original Message-
From: Terri Stocke [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2001 15:34
To: CF-Talk
Subject: Is this possible?
Hey all,
Is it possible to determine what a user has inputted in a form BEFORE the
form is submitted? What I would like to do is IF a user makes a selection in
the form that conflicts with information already in the db, I want to have a
javascript popup alert them to the discrepancy and have them verify if they
want to continue. Otherwise, just a regular submit button would be
displayed.
I have the javascript alert/confirm working alright, but I can't figure out
how to get it to check the formfields and only display conditionally. I
don't even think this is possible, considering that CF is server-side and
essentially what I want to do is have CF determine what was selected BEFORE
it is submitted. Is there a way I can determine this with JavaScript (I'm
not very good at JS, so "baby steps", please ;).
I know I could do this within CF and just have the form submit to an interim
confirmation page, but I would rather do this on the client.
Thanks!
Terri
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFInclude a template based on a radio value
HELP PLEEASE!!
I am attempting the following radio button selection and can not for the
life of me figure out how to ONLY CFINCLUDE with a Yes value
bWould you like one of our sales consultants to give you a call?/bfont
SIZE="+1" input TYPE="radio" NAME="Give_a_call" VALUE="Yes"
onClick="checkInfo()" CHECKED/fontfont
SIZE="-1"Yesnbsp;nbsp;nbsp;input TYPE="radio" NAME="Give_a_call"
VALUE="No" onClick="checkInfo()" Nonbsp;nbsp;nbsp;br
I have tried the following checkInfo statement and am getting a continuous
syntax error
SCRIPT
function checkInfo(){
document.write (Give_a_call);
if (this.Give_a_call == "Yes"){
CFINCLUDE template="InfoRequest.cfm"
}
}
/SCRIPT
Any help with this will be GREATLY Appreciated
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Calling all FreeLance CF Gurus!
sorry... i dont mean to support these posts... i agree with them no being here... just thought it was funny Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 10:15 AM To: CF-Talk Subject: Re: Calling all FreeLance CF Gurus! While I'm still in bed sick, I requested from the poster that job related posts not be reposted to the CF-Talk or other lists. Due to a long thread that started on the jobs list when I posted looking for a job, some people have complained about OT posts. I'm going to try and step in on them now. If we could end this one or move it to CF-Community, I'd appreciate it. Thanks HAHAHAA did anyone by chance go to the linked page?? the first question in the appliaction is: Mt. Dew or Dr. Pepper:* | | I thought that was hilarious I wonder which one gets the preference? Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 5:47 AM To: CF-Talk Subject: Calling all FreeLance CF Gurus! Hi Everyone, Me and My great staff have been very busy working with the casino vendors and tons of marketing teams here in bright Las Vegas! We are in need of a few good freelance REMOTE coders. We have several small projects and one big project due to start in 2 weeks. Obviously this would be a great place for someone to step in create a alliance/partnership which we could constantly send projects to. We want to have a definite individual lined up by the 1st. Since there are a couple of client the prices range with work, but once we take a peek at the following we'll bring you into the loop. We have prepared the scope of work; So you just have to focus on coding. WE DON'T WANT THIRD PARTIES! LOOKING FOR DEDICATED OPEN INDIVIDUALS ONLY. YOU MUST BE WILING TO SIGN A NON_DISCLOSURE/NON-COMPETE. Please complete the linked form at: http://24.234.179.102/emp/1.cfm . The window for application will be open till 3/28/01 at which point we will be making selections. Thanks, Brian Thornton LASVEGAS.COM [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this possible?
Ooh, here's where it gets really hairy, though. I neglected to mention in my
first post that I am using the CF_TwoSelectsRelated tag.
Here's the deal. This is an employee suggestion application. The page I am
enhancing is the page where the admin can route the suggestion to the
appropriate group and individual. Each group (e.g. HR, HelpDesk,
Communications, etc.) has one or more default evaluators assigned to it. The
CF_TwoSelects related tag creates a query driven drop-down menu for the
departments. Based on what is selected in the first menu, the second menu is
then "generated" to display the default evaluator(s) for that group. The
users have the option to keep this default value from the second list, or
override it and choose a different value. To choose a different evaluator,
they can either type in the person's first and last name into the provided
text box, or they can click a search button. Clicking that button pulls up a
javascript(from another server) box that queries our LDAP (I didn't write
it), from which the admin can find the user name, click on the button, and
the evaluator's NT id is automatically populated into the text field. My
action page checks to see if the value passed is an NT id or a full name,
and resolves the full name to the NT id if needed.
(The function for the script is in my application.cfm file, since several
pages throughout the app use the name picklist.)
WHEW! Okay. So, probably more information than anyone cares to think about,
but that is what is making this so difficult. Thanks for the code snippets.
They are helpful--but does anyone know how I would incorporate them based on
the way my page is currently set up? Here is a portion of the code on my
page:
cfform name="pick_eval"
action="firstroute_submit.cfm?suggestion_id=#suggestion_id#location=#session.location#"
method="POST" enablecab="Yes"
tr
td valign="top"
bProposed Evaluator Group:BR
BR
Default Evaluator ID:/b/td
td
CF_TwoSelectsRelated QUERY="Evaluators"
DISPLAY1="evaluator_group_name" DISPLAY2="name"
VALUE1="evaluator_group_name"
VALUE2="evaluator_id"
HTMLBETWEEN="BRi(Current suggested group is
#find_groupname.evaluator_group_name#.)/i"
AUTOSELECTFIRST="YES"
EMPTYTEXT1="(choose an evaluation group)"
size2="2"
forceWIDTH2="30"
FORMNAME="pick_eval"
tr
td valign="top"
bDo you wish to use the default Evaluator for this
group?/b/td
td
cfinput type="Radio" name="default_eval" value="yes"
checked="Yes"
bYes/b, assign to the default Evaluator.BR
cfinput type="Radio" name="default_eval" value="no"
No,
override this and assign it to: /td
/tr
tr
td/td
td
input language="JavaScript" type="text"
size="30" name="assigned_eval" value=""
class="textbox" title="no
hint"
input language="JavaScript" name="btn_in_assigned_eval"
type="button" value="Find"
ONCLICK="call_lon(quot;site_users:#session.site_grp#quot;,
quot;assigned_evalquot;,0)"
class="secondarybutton"
BR
(Enter either the person's first and last name, or search for
their
NT userid.)/font/td
/tr
Original Message Follows
From: "Jason Lees (National Express)" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: Is this possible?
Date: Mon, 26 Mar 2001 16:21:24 +0100
what Terri could so is query the DB on loading the page, then validate the
answers with a simple JS function.
script Language="JavaScript" type="text/javascript"
function Check_Items(Item1,Item2){
if (Item1.value!=Item2.value){
alert ("These contradict the DB")
Item1.setfocus();
}
return;
}
/script
then in the page
input type="text" Name="MyInput"
onblur="Check_Items(MyInput,#Db_check_Item#);"
this should work, you might have to wrap round a CFOutput, round the Input
tag.
In theory it should work, give it a try and let me know.
Jason Lees
National Express
Email : [EMAIL PROTECTED]
-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2001 16:00
To: CF-Talk
Subject: RE: Is this possible?
But Terri wants to compare the client-side form element values to what's in
the
db. In order to do this, she'll have to get the db info into JS. She could
query for the data and then convert it to JS via CFWDDX ACTION=CFML2JS.
-David
On Monday, March 26, 2001 6:40 AM, Dylan Bromby [SMTP:[EMAIL PROTECTED]]
wrote:
yes you can do this. you can reference the form elements by object name.
you
don't have to submit the form to validate or check values. you can do it
Re: Calling all FreeLance CF Gurus!
Actually, it was. Besides the soda question (which is to prove if your a real tech or not) the site is just raw. Makes one wonder. sorry... i dont mean to support these posts... i agree with them no being here... just thought it was funny Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 10:15 AM To: CF-Talk Subject: Re: Calling all FreeLance CF Gurus! While I'm still in bed sick, I requested from the poster that job related posts not be reposted to the CF-Talk or other lists. Due to a long thread that started on the jobs list when I posted looking for a job, some people have complained about OT posts. I'm going to try and step in on them now. If we could end this one or move it to CF-Community, I'd appreciate it. Thanks HAHAHAA did anyone by chance go to the linked page?? the first question in the appliaction is: Mt. Dew or Dr. Pepper:* | | I thought that was hilarious I wonder which one gets the preference? Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Brian Thornton [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 5:47 AM To: CF-Talk Subject: Calling all FreeLance CF Gurus! Hi Everyone, Me and My great staff have been very busy working with the casino vendors and tons of marketing teams here in bright Las Vegas! We are in need of a few good freelance REMOTE coders. We have several small projects and one big project due to start in 2 weeks. Obviously this would be a great place for someone to step in create a alliance/partnership which we could constantly send projects to. We want to have a definite individual lined up by the 1st. Since there are a couple of client the prices range with work, but once we take a peek at the following we'll bring you into the loop. We have prepared the scope of work; So you just have to focus on coding. WE DON'T WANT THIRD PARTIES! LOOKING FOR DEDICATED OPEN INDIVIDUALS ONLY. YOU MUST BE WILING TO SIGN A NON_DISCLOSURE/NON-COMPETE. Please complete the linked form at: http://24.234.179.102/emp/1.cfm . The window for application will be open till 3/28/01 at which point we will be making selections. Thanks, Brian Thornton LASVEGAS.COM [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFInclude a template based on a radio value
I think you're going to have to resubmit the page to itself to reload the
page and do the check within a cfif.
Hatton
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 11:00 AM
To: CF-Talk
Subject: CFInclude a template based on a radio value
HELP PLEEASE!!
I am attempting the following radio button selection and can not for the
life of me figure out how to ONLY CFINCLUDE with a Yes value
bWould you like one of our sales consultants to give you a
call?/bfont
SIZE="+1" input TYPE="radio" NAME="Give_a_call" VALUE="Yes"
onClick="checkInfo()" CHECKED/fontfont
SIZE="-1"Yesnbsp;nbsp;nbsp;input TYPE="radio" NAME="Give_a_call"
VALUE="No" onClick="checkInfo()" Nonbsp;nbsp;nbsp;br
I have tried the following checkInfo statement and am getting a continuous
syntax error
SCRIPT
function checkInfo(){
document.write (Give_a_call);
if (this.Give_a_call == "Yes"){
CFINCLUDE template="InfoRequest.cfm"
}
}
/SCRIPT
Any help with this will be GREATLY Appreciated
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Server Troubles
CF Server is eating up my processor to the point where the system has to be stopped and started, or else the server crashes. I can't tell which application is doing it. Just before the crash, Task Manager says "CPU Usage 100%" but the memory usage is still very low. This error message popped up on the home page before the latest crash: [A critical error has occurred at 03/25/01 on page "index.cfm" Diagnostics: ODBC Error Code = () Unable to instantiate environment for 'ODBC.' The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:82).] Any ideas? -Sandy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFInclude a template based on a radio value
I'm might be wrong, but can you include cfml tags inside of a normal script?
Shouldn't that be javascript? Try document.write ("cf...");
-Original Message-
From: Larry Juncker
To: CF-Talk
Sent: 3/26/01 8:00 AM
Subject: CFInclude a template based on a radio value
HELP PLEEASE!!
I am attempting the following radio button selection and can not for the
life of me figure out how to ONLY CFINCLUDE with a Yes value
bWould you like one of our sales consultants to give you a
call?/bfont
SIZE="+1" input TYPE="radio" NAME="Give_a_call" VALUE="Yes"
onClick="checkInfo()" CHECKED/fontfont
SIZE="-1"Yesnbsp;nbsp;nbsp;input TYPE="radio" NAME="Give_a_call"
VALUE="No" onClick="checkInfo()" Nonbsp;nbsp;nbsp;br
I have tried the following checkInfo statement and am getting a
continuous
syntax error
SCRIPT
function checkInfo(){
document.write (Give_a_call);
if (this.Give_a_call == "Yes"){
CFINCLUDE template="InfoRequest.cfm"
}
}
/SCRIPT
Any help with this will be GREATLY Appreciated
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFInclude a template based on a radio value
What you want to do will work but you'll have to refresh the page and pass
the var as a URL or cookie or some other persistent var. Once you see the
webpage the CF is already processed so you can't dynamically drop a
CFINCLUDE in. You could refresh the page with the CFINCLUDE now present
and when it refreshes you'll have it.
Anybody, please correct me if I'm wrong.
J.
John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer
Office: 909-943-8428
www.red-omega.com http://www.red-omega.com
15 people are known to have been crushed to death tilting soda
machines towards them in order to receive free soda.
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 8:00 AM
To: CF-Talk
Subject: CFInclude a template based on a radio value
HELP PLEEASE!!
I am attempting the following radio button selection and can not for the
life of me figure out how to ONLY CFINCLUDE with a Yes value
bWould you like one of our sales consultants to give you a call?/bfont
SIZE="+1" input TYPE="radio" NAME="Give_a_call" VALUE="Yes"
onClick="checkInfo()" CHECKED/fontfont
SIZE="-1"Yesnbsp;nbsp;nbsp;input TYPE="radio" NAME="Give_a_call"
VALUE="No" onClick="checkInfo()" Nonbsp;nbsp;nbsp;br
I have tried the following checkInfo statement and am getting a continuous
syntax error
SCRIPT
function checkInfo(){
document.write (Give_a_call);
if (this.Give_a_call == "Yes"){
CFINCLUDE template="InfoRequest.cfm"
}
}
/SCRIPT
Any help with this will be GREATLY Appreciated
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Escaping apostrophes
This must be a basic question, but I found no real answer on the allaire forums. I want to allow users to enter apostrophes in text, which I then save to the database. However, the sql insert will fail as it interprets this apostrophe within the text as one of the apostrophes surrounding the text. Example: INSERT INTO tblUserComments (userid, usercomment) VALUES (12345, 'I don't know what to think') This fails on the ' in don't There must be a better solution than HTMLEditFormat. OK, here's how it works - you use PreserveSingleQuotes() to keep apostrophies if you're building the SQL in a string before you pass it to CFQuery If you want to put an apostrophie into a field, then you must double it; Replace(myField,"'","''","all") As SQL uses the apostrophies to begin and end a field, you have to tell SQL that it's not the end of the field Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFID / CFToken
Can anyone point me to a place I can find out how to STOP the CFID/CFTOKEN from being appended to the URL when pages are served to the browser? Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Server Troubles
What platform are you running CF Server on (WinNT 4.0, Win2K, .. ?) What version of CF Server are you using? What version of the MDAC (if on Win)? Make sure that you have the latest (well, at least 2.5) MDAC installed. Are you accessing Access DBs? Need more info... Jeff Garza Web Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -Original Message- From: Schlosser, Sandra [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 9:00 AM To: CF-Talk Subject: Server Troubles CF Server is eating up my processor to the point where the system has to be stopped and started, or else the server crashes. I can't tell which application is doing it. Just before the crash, Task Manager says "CPU Usage 100%" but the memory usage is still very low. This error message popped up on the home page before the latest crash: [A critical error has occurred at 03/25/01 on page "index.cfm" Diagnostics: ODBC Error Code = () Unable to instantiate environment for 'ODBC.' The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:82).] Any ideas? -Sandy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Escaping apostrophes
On 26 Mar 2001, at 17:20, Philip Arnold - ASP wrote: OK, here's how it works - you use PreserveSingleQuotes() to keep apostrophies if you're building the SQL in a string before you pass it to CFQuery If you want to put an apostrophie into a field, then you must double it; Replace(myField,"'","''","all") Just to clarify: None of this applies if you're just interpolating variable values into your CFQUERY rather than building the SQL in a string beforehand -- something like this: CFQUERY DATASOURCE="#DSN#" NAME="Bios" SELECT ID, FirstName, LastName, Bio FROM Persons WHERE LastName = '#SearchName#' /CFQUERY In that case, CF automagically doubles your single quotes on its own (unless you use PreserveSingleQuotes()), and you don't have to worry about doing anything special to handle people named "O'Neill". Keith C. Ivey [EMAIL PROTECTED] Webmaster, EEI Communications 66 Canal Center Plaza, Suite 200 Alexandria, VA 22314 Telephone: 703-683-0683 Fax: 703-683-4915 Web Site: http://www.eeicommunications.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFID / CFToken
The CFID and CFTOKEN are NOT automatically appended to the URL when a page is served. I guess you really want to find out how to stop CFID CFTOKEN being passed to the browser as cookies as that is how they are passed by default. Firstly, make sure SETCLIENTCOOKIES is set to NO in your CFAPPLICATION. Secondly, if the above attribute was at any point set to on then any cookies that were set then will still get passed back with browser requests. To stop this you will have to delete them from ther browser by using CFCOOKIE name="cfid" expires="now" ditto for cftoken. -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 17:22 To: CF-Talk Subject: CFID / CFToken Can anyone point me to a place I can find out how to STOP the CFID/CFTOKEN from being appended to the URL when pages are served to the browser? Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf licensing
Where can I look for information on Cold Fusion licensing? Looking to buy Cold Fusion Server and need to know the licensing differences between Professional and Enterprise, like number of sites allowed per license and multi-processor abilities and such. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ #: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFID / CFToken
if, by chance, this is happening as a result of using CFLOCATION, set ADDTOKEN=NO. -Original Message- From: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 8:52 AM To: CF-Talk Subject: RE: CFID / CFToken The CFID and CFTOKEN are NOT automatically appended to the URL when a page is served. I guess you really want to find out how to stop CFID CFTOKEN being passed to the browser as cookies as that is how they are passed by default. Firstly, make sure SETCLIENTCOOKIES is set to NO in your CFAPPLICATION. Secondly, if the above attribute was at any point set to on then any cookies that were set then will still get passed back with browser requests. To stop this you will have to delete them from ther browser by using CFCOOKIE name="cfid" expires="now" ditto for cftoken. -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 17:22 To: CF-Talk Subject: CFID / CFToken Can anyone point me to a place I can find out how to STOP the CFID/CFTOKEN from being appended to the URL when pages are served to the browser? Thanks. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Introducing the DC-CFUG and DC-JRUG mailing lists
Fig Leaf Software is please to announce the formation of two new mailing lists: DC-CFUG and DC-JRUG DC-CFUG: This list is dedicated to serving up announcements, news, and chatter about Washington D.C. area Macromedia Server Tools user groups including ColdFusion (CFUG) and Spectra (SPUG). DC-JRUG: Announcements, news, and chatter about Washington D.C. area Macromedia JRun users groups. You can subscribe by visiting http://chattyfig.figleaf.com Regards, Steve Drucker CEO Fig Leaf Software ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Statement Question/Help
Good day all, I was wondering if anyone could help me with this. i have a statement shown below that works great. however i was wondering if someone might give me an idea of how to do this: i need to display ONLY the contestants that show up in the ResultsManager (this is a table) More than once. the following query displays everyone (with the proper gender that is) but im haveing problems getting it to show just the contestants that have 2 or more events recorded in the ResultsManager. should i edit this query or should i do another one and 'tie' them to gether? im kinda at a loss here, not sure what to do. any help would be greatly appreciatted. here is my statement cfquery name="GetTotalPts" datasource="#datasource#" dbtype="ODBC" username="#username#" password="#password#" SELECT ResultsManager.ContestantID, ContestantManager.FirstName, ContestantManager.LastName, ContestantManager.City, ContestantManager.State, SUM (ResultsManager.AdjPoints) as TOTALPTS FROM ResultsManager INNER JOIN ContestantManager ON ResultsManager.ContestantID = ContestantManager.ContestantID WHERE ContestantManager.Gender = '2' AND ResultsManager.NotAllAround = '0' GROUP BY ResultsManager.ContestantID, ContestantManager.FirstName, ContestantManager.LastName, ContestantManager.City, ContestantManager.State ORDER BY SUM (AdjPoints) DESC /cfquery Thanks a TON!, Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DTS/Com error...
I just tried to run this test DTS on my SQL7 server using code from
CFcomet...
The problem is, I get the error
COM error 0x800401F3. Invalid class string
I'm pretty new to using COM objects and was wondering if this was just
something stupid I needed to add, or what... ?
Marcus
CFTRY
CFOBJECT TYPE="COM" NAME="objDTS" CLASS="DTS.Package" ACTION="CREATE"
CFCATCH TYPE = "Object"
CFSET error_message = "The DTS Package Object Could Not Be
Created."
/CFCATCH
/CFTRY
CFTRY
CFSET r =
objDTS.LoadfromSQLServer"sql_server","sa","",0,"","","","import_dts","")
CFCATCH
CFSET error_message = "The DTS Package Could Not Be Loaded at this
time."
/CFCATCH
/CFTRY
CFIF IsDefined("error_message")
CFOUTPUT#error_message#/CFOUTPUT
/CFIF
CFSET p = objDTS.Execute()
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFInclude a template based on a radio value
When I tried this, the page does not retain any of the form variables.
I know there is a way of sending these with the href, but what about with a
refresh?
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 10:11 AM
To: CF-Talk
Subject: RE: CFInclude a template based on a radio value
What you want to do will work but you'll have to refresh the page and pass
the var as a URL or cookie or some other persistent var. Once you see the
webpage the CF is already processed so you can't dynamically drop a
CFINCLUDE in. You could refresh the page with the CFINCLUDE now present
and when it refreshes you'll have it.
Anybody, please correct me if I'm wrong.
J.
John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer
Office: 909-943-8428
www.red-omega.com http://www.red-omega.com
15 people are known to have been crushed to death tilting soda
machines towards them in order to receive free soda.
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 8:00 AM
To: CF-Talk
Subject: CFInclude a template based on a radio value
HELP PLEEASE!!
I am attempting the following radio button selection and can not for the
life of me figure out how to ONLY CFINCLUDE with a Yes value
bWould you like one of our sales consultants to give you a call?/bfont
SIZE="+1" input TYPE="radio" NAME="Give_a_call" VALUE="Yes"
onClick="checkInfo()" CHECKED/fontfont
SIZE="-1"Yesnbsp;nbsp;nbsp;input TYPE="radio" NAME="Give_a_call"
VALUE="No" onClick="checkInfo()" Nonbsp;nbsp;nbsp;br
I have tried the following checkInfo statement and am getting a continuous
syntax error
SCRIPT
function checkInfo(){
document.write (Give_a_call);
if (this.Give_a_call == "Yes"){
CFINCLUDE template="InfoRequest.cfm"
}
}
/SCRIPT
Any help with this will be GREATLY Appreciated
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DTS/Com error...
Are SQL Server or the SQL Server Enterprise Manager installed on the same
machine as the CF Server?
~Simon
Simon Horwith
Allaire Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com
-Original Message-
From: Marcus [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 12:13 PM
To: CF-Talk
Subject: DTS/Com error...
I just tried to run this test DTS on my SQL7 server using code from
CFcomet...
The problem is, I get the error
COM error 0x800401F3. Invalid class string
I'm pretty new to using COM objects and was wondering if this was just
something stupid I needed to add, or what... ?
Marcus
CFTRY
CFOBJECT TYPE="COM" NAME="objDTS" CLASS="DTS.Package" ACTION="CREATE"
CFCATCH TYPE = "Object"
CFSET error_message = "The DTS Package Object Could Not Be
Created."
/CFCATCH
/CFTRY
CFTRY
CFSET r =
objDTS.LoadfromSQLServer"sql_server","sa","",0,"","","","import_dts","")
CFCATCH
CFSET error_message = "The DTS Package Could Not Be Loaded at this
time."
/CFCATCH
/CFTRY
CFIF IsDefined("error_message")
CFOUTPUT#error_message#/CFOUTPUT
/CFIF
CFSET p = objDTS.Execute()
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
LDAP weirdness
Hi all, Has anyone had problems looping over a query to enter people into an LDAP group? I did this, and now I'm finding that even though I can "see" the people when I do a cf ldap lookup, Netscape Directory Services doesn't really "see" all the people. The server admins say that people are "nested" and only the top person in each nest is recognized. Do I have to go back and delete all those entries and manually add one person at a time to the group? Ugh! Thanks for any thoughts. -Deanna Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Redirection
Need to redirect the user back to the same form / same information they were working on, i.e. I update John Doe after submitting changes I need to take user right back to John Doe's page that he or she was just updating/editing. TIA ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Redirection
Just submit the form to itself... create some logic to look for the submit button and you are all set. If you need an example let me know... -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DTS/Com error...
No... Sql7 lives on a seperate machine called SQL_Server. I take it this is a problem? Marcus Are SQL Server or the SQL Server Enterprise Manager installed on the same machine as the CF Server? ~Simon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help! Best way to get data to fill a remote table!
Hello cf-talk, I have an oracle database on a client's host, but not direct access to it. The table is set up to accept dealer information, simple fields of name, address, web, email. I have an Excel spreadsheet with all the dealer info. The database admin guy wants me to get the info into the oracle table without his help (he won't use SQL Loader or whatever its called). So, anyideas as to the best way to get my data in there? I have about 500 records. I was going to make a query from a local datasourse that would populate a form, that would send to a insert.cfm page on the remote server, populating the remote table. There has to be a better way! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] Internet Guns For Hire (603) 356-0768 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Personal web server install
Hello all, I am trying to install microsofts personal web server on my NT 5.0 machine and I cannot find it on the microsoft site. I can only find PWS for NT 4. does anyone know where the down load is for this/ Thanks Julie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Think your good? Prove it!
Ben's q's are pretty tough. If anyone is contemplating certification there's another useful resource - CF_Buster at http://www.centrasoft.com There's a demo app you can download. I'd be interested to hear which set of questions are more like the real thing because these are certainly easier than Ben's! Tristram Charnley - [EMAIL PROTECTED] "If something is hard to do, its not worth doing!" Homer Simpson. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: 25 March 2001 18:02 To: CF-Talk Subject: OT: Think your good? Prove it! With my "Certified ColdFusion Developer Study Guide" about to ship, I have put a sample CF exam online. It's not an easy exam, and it'll be different each time you take it. So, if you are feeling brave, give it a try at http://www.forta.com/books/0789725657/ (there's a link at the bottom of that page). Enjoy! --- Ben PS If you have comments or questions about the exam, reply to me directly (not here on the list). The test application is brand new, so any help ironing out the kinks is appreciated. == Ben Forta - Macromedia Inc. E-Mail: [EMAIL PROTECTED] Phone: (248)424-8420 Fax:(248)424-8421 Macromedia: http://www.macromedia.com/ Allaire:http://www.allaire.com/ Personal: http://www.forta.com/ WAP is hot! Want to know more? You need "The WAP Book" - go to http://www.thewapbook.com/ for more info! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DTS/Com error...
The DTS COM Object that installs with SQL Server, only runs locally to the best of my knowledge (I don't think it can be called from remote machines the way DCOM objects can). I wrote that code on a machine running SQL Server and Enterprise Manager, so I'm not sure, but I believe you can install the enterprise manager alone on the machine running CFAS, and be able to use the code. ~Simon Simon Horwith Allaire Certified Instructor Certified ColdFusion Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 12:32 PM To: CF-Talk Subject: RE: DTS/Com error... No... Sql7 lives on a seperate machine called SQL_Server. I take it this is a problem? Marcus Are SQL Server or the SQL Server Enterprise Manager installed on the same machine as the CF Server? ~Simon ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Personal web server install
settings---control panel---add/remove programs---add/remove windows components -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 9:32 AM To: CF-Talk Subject: Personal web server install Hello all, I am trying to install microsofts personal web server on my NT 5.0 machine and I cannot find it on the microsoft site. I can only find PWS for NT 4. does anyone know where the down load is for this/ Thanks Julie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Personal web server install
If it wasn't installed by default then it will be on your CD.Windows[productVersion] -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 18:32 To: CF-Talk Subject: Personal web server install Hello all, I am trying to install microsofts personal web server on my NT 5.0 machine and I cannot find it on the microsoft site. I can only find PWS for NT 4. does anyone know where the down load is for this/ Thanks Julie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Think your good? Prove it!
Tristram, Actually, the question in my test are very similar to the real thing, what makes it harder is that it covers some advanced topics that are not in the real test (yet). As such, it's a better gauge in that if you do well on this one you are likely to do well on the real one. --- Ben -Original Message- From: Tristram Charnley [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 12:43 PM To: CF-Talk Subject: RE: Think your good? Prove it! Ben's q's are pretty tough. If anyone is contemplating certification there's another useful resource - CF_Buster at http://www.centrasoft.com There's a demo app you can download. I'd be interested to hear which set of questions are more like the real thing because these are certainly easier than Ben's! Tristram Charnley - [EMAIL PROTECTED] "If something is hard to do, its not worth doing!" Homer Simpson. -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: 25 March 2001 18:02 To: CF-Talk Subject: OT: Think your good? Prove it! With my "Certified ColdFusion Developer Study Guide" about to ship, I have put a sample CF exam online. It's not an easy exam, and it'll be different each time you take it. So, if you are feeling brave, give it a try at http://www.forta.com/books/0789725657/ (there's a link at the bottom of that page). Enjoy! --- Ben PS If you have comments or questions about the exam, reply to me directly (not here on the list). The test application is brand new, so any help ironing out the kinks is appreciated. == Ben Forta - Macromedia Inc. E-Mail: [EMAIL PROTECTED] Phone: (248)424-8420 Fax:(248)424-8421 Macromedia: http://www.macromedia.com/ Allaire:http://www.allaire.com/ Personal: http://www.forta.com/ WAP is hot! Want to know more? You need "The WAP Book" - go to http://www.thewapbook.com/ for more info! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Personal web server install
I am trying to install microsofts personal web server on my NT 5.0 machine and I cannot find it on the microsoft site. I can only find PWS for NT 4. does anyone know where the down load is for this? If you have NT 5 - Windows 2000 - you can install IIS 5/PWS 5 from the CD. Just go to Control Panel ... Add/Remove Software ... Add/Remove Windows Components. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cf licensing
CF is licensed per box, not site or cpu or user (like broadvision). So, you can get a single copy of CF and put it on a 8 way sun box, or even a 64 processor E1. The differences between pro and enterprise are best summed up in this chart: http://www.allaire.com/handlers/index.cfm?ID=13570Method=FullTitle=Edition%20Comparison%20MatrixCache=False Bernd VanSkiver wrote: Where can I look for information on Cold Fusion licensing? Looking to buy Cold Fusion Server and need to know the licensing differences between Professional and Enterprise, like number of sites allowed per license and multi-processor abilities and such. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ #: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Personal web server install
goto add/remove programs then Windows setup Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader -Original Message- From: Julie Clegg [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 12:32 PM To: CF-Talk Subject: Personal web server install Hello all, I am trying to install microsofts personal web server on my NT 5.0 machine and I cannot find it on the microsoft site. I can only find PWS for NT 4. does anyone know where the down load is for this/ Thanks Julie ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Images
When you store an image in the database, how do you go about displaying it on the HTML page? Right now, I am simply storing the URL in the DB to the image file on the hard drive, but looking to storing them in the actual SQL Server dataabase as another solution. I just wanted to find out how one would go about doing this and get any feedback from those who have used this technique. The current design of most HTTP servers that seperates it from a database makes this inefficient. If a database server were to construct a http service/daemon that directly interfaces with it this would be more feasible. At the moment there are few situations that warrant such an overhead (keeping security badge ids, etc being among the few, for example.) --min ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Statement Question/Help
Use a HAVING clause before your ORDER BY clause, e.g. "having count(contestantID) = 2" -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 11:11 AM To: CF-Talk Subject: Statement Question/Help Good day all, I was wondering if anyone could help me with this. i have a statement shown below that works great. however i was wondering if someone might give me an idea of how to do this: i need to display ONLY the contestants that show up in the ResultsManager (this is a table) More than once. the following query displays everyone (with the proper gender that is) but im haveing problems getting it to show just the contestants that have 2 or more events recorded in the ResultsManager. should i edit this query or should i do another one and 'tie' them to gether? im kinda at a loss here, not sure what to do. any help would be greatly appreciatted. here is my statement cfquery name="GetTotalPts" datasource="#datasource#" dbtype="ODBC" username="#username#" password="#password#" SELECT ResultsManager.ContestantID, ContestantManager.FirstName, ContestantManager.LastName, ContestantManager.City, ContestantManager.State, SUM (ResultsManager.AdjPoints) as TOTALPTS FROM ResultsManager INNER JOIN ContestantManager ON ResultsManager.ContestantID = ContestantManager.ContestantID WHERE ContestantManager.Gender = '2' AND ResultsManager.NotAllAround = '0' GROUP BY ResultsManager.ContestantID, ContestantManager.FirstName, ContestantManager.LastName, ContestantManager.City, ContestantManager.State ORDER BY SUM (AdjPoints) DESC /cfquery Thanks a TON!, Jay Patton Web Design / Application Design Web Pro USA p. 406.549.3337 ext. 203 p. 1.888.5WEBPRO ext. 203 e. [EMAIL PROTECTED] url. www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Images
If you store the image's file path in a database Access that path through your regular query as usual and reference that in your img src="#queryname.image_field_name#" tagof course you may want to also store the image's actual width and height properties as well, and maybe an alt description (in the pursuit of well-formed HTML).and pull them into the tag, but, you can get away without the width, height and alt info. Does this help? Erika AIM: WebErika5 Yahoo: WebErika MSN: WebErika AskMe.com Expert: WebErika Erika L. Walker Vice President RUWebby, LLC 201-370-4272 (c) 973-244-9120 (o) 153 Rutgers Lane Parsippany, NJ 07054 Website Design/Programming Database Integration Allaire Partner - ColdFusion -Original Message- From: Brad Squires [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 1:19 PM To: CF-Talk Subject: Database Images This is a multi-part message in MIME format. --=_NextPart_000_0002_01C0B382.A20C2840 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit When you store an image in the database, how do you go about displaying it on the HTML page? Right now, I am simply storing the URL in the DB to the image file on the hard drive, but looking to storing them in the actual SQL Server dataabase as another solution. I just wanted to find out how one would go about doing this and get any feedback from those who have used this technique. Brad Squires --=_NextPart_000_0002_01C0B382.A20C2840 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR/HEAD BODY DIVFONT face=3DArial size=3D2SPAN class=3D250591518-23032001When = you store an=20 image in the database, how do you go about displaying it on the HTML = page? Right=20 now, Inbsp;am simply storing the URL in the DB to the image file on the = hard=20 drive, but looking to storing them in the actual SQL Server dataabase as = another=20 solution. I just wanted to find out how one would go about doing this = and get=20 any feedback from those who have used this = technique./SPAN/FONT/DIV DIVFONT face=3DArial size=3D2SPAN=20 class=3D250591518-23032001/SPAN/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2SPAN class=3D250591518-23032001Brad=20 Squires/SPAN/FONT/DIV DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_0002_01C0B382.A20C2840-- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: cf licensing]
Cool, I had heard that only Enterprise could handle multi-processors so wanted to make sure about that. Is there a developers edition of cf server I can download? Know there is one for JRun, haven't seen one for CF though. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ #: 916324 Edward Smith [EMAIL PROTECTED] wrote: CF is licensed per box, not site or cpu or user (like broadvision). So, you can get a single copy of CF and put it on a 8 way sun box, or even a 64 processor E1. The differences between pro and enterprise are best summed up in this chart: http://www.allaire.com/handlers/index.cfm?ID=13570Method=FullTitle=Edition%20Comparison%20MatrixCache=False Bernd VanSkiver wrote: Where can I look for information on Cold Fusion licensing? Looking to buy Cold Fusion Server and need to know the licensing differences between Professional and Enterprise, like number of sites allowed per license and multi-processor abilities and such. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ #: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Redirection
I emailed you off list Thank You "Clint Tredway" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Just submit the form to itself... create some logic to look for the submit button and you are all set. If you need an example let me know... -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Autopopulating text fields
How can I, or is it even possible to, automatically populate text fields in a form after one field is entered? In the past, I've done something similar using a drop-down list for the first value and populating the other fields based on the selection, but in this case my client needs to be able to enter text to trigger the event rather than selecting from a list. (Even if the drop-down list method was acceptable, there would be over 10,000 items to choose from, and my system hangs just trying to run the query.) This should be doable -- the idea is much like applications I've seen where entering a zipcode populates city and state fields on the fly, but I can't figure out any way to do it. Can anyone point me in the right direction? Thanks! MC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [Re: cf licensing]
The developer version of CF comes with CF Studio. Regards, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - the World's most configurable mail server Get your free copy of iMS POST-SE Server from CoolFusion! - Original Message - From: "Bernd VanSkiver" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, March 26, 2001 1:37 PM Subject: Re: [Re: cf licensing] Cool, I had heard that only Enterprise could handle multi-processors so wanted to make sure about that. Is there a developers edition of cf server I can download? Know there is one for JRun, haven't seen one for CF though. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ #: 916324 Edward Smith [EMAIL PROTECTED] wrote: CF is licensed per box, not site or cpu or user (like broadvision). So, you can get a single copy of CF and put it on a 8 way sun box, or even a 64 processor E1. The differences between pro and enterprise are best summed up in this chart: http://www.allaire.com/handlers/index.cfm?ID=13570Method=FullTitle=Edition %20Comparison%20MatrixCache=False Bernd VanSkiver wrote: Where can I look for information on Cold Fusion licensing? Looking to buy Cold Fusion Server and need to know the licensing differences between Professional and Enterprise, like number of sites allowed per license and multi-processor abilities and such. Bernd VanSkiver [EMAIL PROTECTED] ColdFusion Developer ICQ #: 916324 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database Images
What I do is hold the URL of an image (rather than the image itself) in a database - allows cross reference against db records, and provides quick accessibility to images pertinent to a situation. HTH, Derek IT Star Web Design, Hosting, Database Integration and Internet Marketing http://www.itstar.co.uk/ [EMAIL PROTECTED] -Original Message- From: lsellers [mailto:[EMAIL PROTECTED]] Sent: 26 March 2001 19:09 To: CF-Talk Subject: RE: Database Images When you store an image in the database, how do you go about displaying it on the HTML page? Right now, I am simply storing the URL in the DB to the image file on the hard drive, but looking to storing them in the actual SQL Server dataabase as another solution. I just wanted to find out how one would go about doing this and get any feedback from those who have used this technique. The current design of most HTTP servers that seperates it from a database makes this inefficient. If a database server were to construct a http service/daemon that directly interfaces with it this would be more feasible. At the moment there are few situations that warrant such an overhead (keeping security badge ids, etc being among the few, for example.) --min ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Allaire Developers Conference?
http://www.allaire.com/conference -Original Message- From: Sicular, Alexander [SMTP:[EMAIL PROTECTED]] Sent: Saturday, March 24, 2001 6:28 PM To: CF-Talk Subject: RE: Allaire Developers Conference? orlando. it's on the site. -alexander -Original Message- From: Kevin Mansel [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 24, 2001 6:18 PM To: CF-Talk Subject: Allaire Developers Conference? Is there going to be a third annual developers conference now? If anyone has any links on it, could you please send those to me? Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Joins with multiple databases
Anyone know a way to do joins using SQL on more than one database? Rather than scripting. Thanks, Mark ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Allaire Developers Conference?
You wouldn't happen to have a link would you? At 07:28 PM 3/24/2001 -0500, you wrote: orlando. it's on the site. -alexander -Original Message- From: Kevin Mansel [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 24, 2001 6:18 PM To: CF-Talk Subject: Allaire Developers Conference? Is there going to be a third annual developers conference now? If anyone has any links on it, could you please send those to me? Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AOHell, AND AOL Block CF Mail server.
You have to change your serverID they block the header that says "Cold Fusion Application Server" Best of Luck, Brian - Original Message - From: "paul smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, March 26, 2001 6:08 AM Subject: AOHell Have you had problems with AOL blocking delivery of email from a list server (apparently mistakenly believing the email is from a spammer)? If so, is there a fix/work-around other than breaking delivery to AOL into smaller "chunks" of messages? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IPlanet and ColdFusion
-- Original Message -- From: "Jon Hall" [EMAIL PROTECTED] Anyone know of any source of info for running ColdFusion on a Win2k machine running IPlanet as the web server? If the Win2K version is as good as the Solaris version it'll work fine. Chris Norloff ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IPlanet and ColdFusion
-- Original Message -- From: "Jon Hall" [EMAIL PROTECTED] Anyone know of any source of info for running ColdFusion on a Win2k machine running IPlanet as the web server? If the Win2K version of iPlanet is as good as the Solaris version it'll work fine. Chris Norloff ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: AOHell, AND AOL Block CF Mail server.
CFMAIL TO="#FORM.Email#" FROM="#FromEmail#" SUBJECT="#Subject#" MAILERID = "http://www.myservername.com" Is what I usually use... You have to change your serverID they block the header that says "Cold Fusion Application Server" Best of Luck, Brian - Original Message - From: "paul smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, March 26, 2001 6:08 AM Subject: AOHell Have you had problems with AOL blocking delivery of email from a list server (apparently mistakenly believing the email is from a spammer)? If so, is there a fix/work-around other than breaking delivery to AOL into smaller "chunks" of messages? best, paul ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFQuery and CFloop.....
Hi, can someone give a hand for this:
I have dynamically expanded similar queries, so I would like to put in a
loop,
however, when I tried to create a array to store the query names, it seems
does not work, it may be just how to pass the queryname...
Any suggestion will be greatly appreciated.
--
cfscript
cShip = ArrayNew(1);
cResult = ArrayNew(1);
for(k=1; k LTE 6; k=k+1)
{
cShip[k] = "cc" k;
cResult[k] = 0;
}
/cfscript
cfoutput
cfloop from=1 to=6 index="k"
cfquery name='#cShip[k]#' datasource="meimei" DBTYPE="Oracle80"
select count(*) as total
from tblMei
where customer_name='xxx'
and part_number='xxx'
and ship_date ='mon[k]'
/cfquery
cfset cResult[k] ='#cShip[k]#'.total
#cResult[k]#BR
/cfloop
/cfoutput
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Joins with multiple databases
Here's some info on doing it in MS-SQL. From Help on "FROM": table_source Specifies a table or view, both with or without an alias, to use in the Transact-SQL statement. A maximum of 256 tables can be used in the statement. A table variable may be specified as a table source. If the table or view exists in another database on the same computer running Microsoft® SQL Server(tm), use a fully qualified name in the form database.owner.object_name. If the table or view exists outside the local server on a linked server, use a four-part name in the form linked_server.catalog.schema.object. A four-part table (or view) name constructed using the OPENDATASOURCE function as the server part of the name also may be used to specify the table source. For more information about the function, see OPENDATASOURCE. -Original Message- From: Shark [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 1:20 PM To: CF-Talk Subject: SQL Joins with multiple databases Anyone know a way to do joins using SQL on more than one database? Rather than scripting. Thanks, Mark ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Autopopulating text fields
use the onBlur event to trigger a JS function. That much I know, but how do I run my query inside a javascript function? I'm having trouble passing the javascript variable into a query and passing the query results back into javascript. Thanks. MC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Title Case for proper names.......
I would like to write a regular expression in ColdFusion that would fix the case from the database or a form field (ie ROY G. BIV ~ Roy G. Biv). Right now I have: REReplace(Attributes.original, "([a-z]+)\1 ", "\1", "ALL" ) the one thing I can't figure out is how to apply changes to the \1. In perl you can do stuff like: \l lowercase one char \u uppercase one char \L lowercase to the end of the word \U uppercase to the end of the word I can't seem to figure out if you can do this in Cold Fusion? I have written this using Left, Ucase and Lcase but I would like to do it using a regular expression, it is probably much more efficient. Thank you very much Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Gel's Newbie Snippets:Sequential Search Through Records To Change fields..
Hey all..this is the results of my swearing, coffee, slamming fist on table
and brutally turning the pages of CF WACK :)
This program is supposed to search through a table filled with badly
formatted data. The data cannot be completely cleaned up, but we were tasked
to do so to the best of our ability.
We had to search through the records, and find where a second name began,
and then push that over to a table called JUDGE 2 while also keeping a
record of the original record in Audit table.
We then had to write the new name, which now should contain a single name,
back into the Judge table.
A second program runs through these changed records and switches Last Name
to Firstname.(will be posted at later date).
I am sure this was not the most efficient way to do this, and I am sure the
program can be improved..but for what its worth this is what I did..and it
worked...sorta ;-)
I decided to post it back to the list in case it would be of use to
anyone..maybe provide a starting point to modify their own code.
-
CFSET AlreadyFound = False
CFSET IsACompany = False
CFSET CompanyList = "Limited|LTD|LTD.|Co.|Company|the|LTD,|BANK" !---
This is the list of words to search for---
cfloop query="judgement" !--- The main loop corresponding to the
appropriate query. This will loop over all the records returned by the
query---
cfset tempDefendant = #judgement.defendant# !--- This was necessary
because Coldfusion handles nested lists in strange ways.---
br
cfloop index="x" from="1" to="8" !--- AN index loop was used instead of
a collection loop, because the collection loop refused to cycle through the
Company List for some reason when I attempted to do this. Ideally a
Collection List loop should be used, pointing to the CompanyList
variable
CFSET WordToGet=ListGetAt(#CompanyList#,#x#,'|') !--- Because an
iterative loop was used, we must now get the Word which we are searching for
from the CompanyList with the ListGet At Statement ---
CFIF FindNoCase(#WordToGet#,#tempdefendant#) neq 0
AND NOT
AlreadyFound !--- If the word is in the string Defendant, i.e. the
Defendant is determined to be a company, and the string has not already
been searched and Found to be a Company..then do this---
CFSET IsACompany = True !--- Flag
determining it is a company---
CFSET AlreadyFound = True!--- Flag
declaring that it has been
determined that it is a company and further searchign is unncessary---
/CFIF
/CFLOOP
CFIF IsACompany eq FALSE !--- IF it is NOT a company, and
thus a
person's name..perform the operations---
!--- Search for a comma in the string
cfset pos= FindNoCase(",",#judgement.defendant#)
! If a comma is found, then pull the string up to
the comma and
this will be the first name ---
CFIF pos gt 0
CFSET
Name1=Left(#defendant#,(#pos#-1))
CFOUTPUT
CFSET
name2=mid(#defendant#,(#pos#+1),Len(defendant))
/CFOUTPUT
!--- Ensure that ALL the values are inserted at
once---
CFTRANSACTION
!--- THis is standard SQL for inserting a record into
a table, and
updating a record. We want to UPDATE the Judge table with the new name..and
write the remaining names into a new record in the Judge 2 table. There is a
One To many relationship between Judge 1 and Judge 2.
cfquery name="InsertAudit"
datasource="republic" dbtype="ODBC"
Insert INTO Audit
(defendant,plaintiff,amount,sequence,remarks,reg_date,cost,indicator,counter
,new_number,account)
Values(CFIF #name2# eq '''0'CFELSE'#judgement.defendant#'/CFIF,
'#judgement.plaintiff#', #judgement.amount#,
#judgement.sequence#,'#judgement.remarks#',
#CreateODBCDateTime(judgement.reg_date)#,
'#judgement.cost#','#judgement.indicator#',CFIF judgement.counter is
''0CFELSE#judgement.counter#/cfif,CFIF judgement.new_number is
''0CFELSE#judgement.new_number#/CFIF,'#judgement.account#')
/cfquery
cfquery name="InsertJudge2" datasource="republic" dbtype="ODBC"
Insert INTO Judge2
(defendant,plaintiff,sequence,indicator,counter,new_number)
Values(CFIF #name2# eq '''0'CFELSE'#name2#'/CFIF,
