RE: CF MX
Hi Neil, I would stave off setting a box up for other people to test, unless they are also on the Beta and are covered by NDA. AFAIK, the NDA covers you and is not scalable to testers. Also, placing Neo Beta on a 'live' server for testing is a big no no and would not go down well with the MACR Legal Dept well not unless you wanted a cease and desist letter :-) My adive to you, remove any and all external installs/testers and you will be OK... this is a crucial time for MM (and indeed any software company in a beta cycle) and jeopardising a cycle can be a disater. Thanks Neil Team Macromedia Spectra http://www.macromedia.com/go/team __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
querying an xls file
Greetings, could anyone advice me what would be the best way to extract data from, an excel xls file, I want to extract each column from each row and insert it into a DSN. I've done something similar before with a txt file, I used CFFILE READ, gave it a variable name looped through the varname and extracted my data using CFSET newLine=Chr(13) Chr(10) as the loop delimeter, but I think xls is slightly different format. Could there possibly be a custom tag for this, any advice would be greatly appreciated, Respectfully, J __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
I can't find RDS Service
Hello, Do you know how can be sure if RDS Service is installed? I've checked in services and I didn't found anything related with RDS service. What is the exact name of the service? can I install again the RDS Service? I'm using CF Server 5 and CF Studio 5 in a w2ksp2 box. Can you help me? Thanks, Juan __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: querying an xls file
Go to http://www.cfcomet.com/cfcomet/excel/ and check out the -- Use Excel files as datasources -- basic to advanced section. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 18 April 2002 10:08 To: CF-Talk Subject: querying an xls file Greetings, could anyone advice me what would be the best way to extract data from, an excel xls file, I want to extract each column from each row and insert it into a DSN. I've done something similar before with a txt file, I used CFFILE READ, gave it a variable name looped through the varname and extracted my data using CFSET newLine=Chr(13) Chr(10) as the loop delimeter, but I think xls is slightly different format. Could there possibly be a custom tag for this, any advice would be greatly appreciated, Respectfully, J __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: querying an xls file
Thanks a million Declan, this is perfect, J -Original Message- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:24 AM To: CF-Talk Subject: RE: querying an xls file Go to http://www.cfcomet.com/cfcomet/excel/ and check out the -- Use Excel files as datasources -- basic to advanced section. -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 18 April 2002 10:08 To: CF-Talk Subject: querying an xls file Greetings, could anyone advice me what would be the best way to extract data from, an excel xls file, I want to extract each column from each row and insert it into a DSN. I've done something similar before with a txt file, I used CFFILE READ, gave it a variable name looped through the varname and extracted my data using CFSET newLine=Chr(13) Chr(10) as the loop delimeter, but I think xls is slightly different format. Could there possibly be a custom tag for this, any advice would be greatly appreciated, Respectfully, J __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: querying an xls file
Hi, If u need to extract data from an Excel sheet , you need not use CFFILE, you can directly use excel as an ODBC datasource You can go the CFIDE administration page, ODBC datasource and create a DSN using the Microsoft Excel Driver and then access it in the same way as u access any other database Regards, Dimple -Original Message- From: John McCosker [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 2:38 PM To: CF-Talk Subject: querying an xls file Greetings, could anyone advice me what would be the best way to extract data from, an excel xls file, I want to extract each column from each row and insert it into a DSN. I've done something similar before with a txt file, I used CFFILE READ, gave it a variable name looped through the varname and extracted my data using CFSET newLine=Chr(13) Chr(10) as the loop delimeter, but I think xls is slightly different format. Could there possibly be a custom tag for this, any advice would be greatly appreciated, Respectfully, J __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE 6.0 Bug
Its the long way to get to Minesweeper, but it works. andy -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 6:16 PM To: CF-Talk Subject: IE 6.0 Bug http://online.securityfocus.com/archive/1/267561 has anyone tried this? -- Sam __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Submitting to popoup window
Hi, From link I'm opening a window where I'm selecting a username from a dropdown selection and then passing that form variable to another template. The first window size is width=340, height=180 If I try to open another window using JS with different width/height settings my form.variable doesn't get passed? users.cfm html head title/title /head body form action=properties-users-action.cfm method=post select name=propertiesuser size=1 class=formfield option value=# selectedSelect...nbsp;/option cfoutput query=Users group=user option value=#User##User#/option /cfoutput /select input type=submit value=Info class=navlinks input type=button value=Close class=navlinks onClick=self.close() /form /body /html properties-users-action.cfm == html head title/title /head body cfoutput FORM.propertiesuser: #FORM.propertiesuser#br /cfoutput /body /html +---+ Philip Humeniuk [EMAIL PROTECTED] [EMAIL PROTECTED] ++ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF MX
Without a doubt, this is a no-no. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 7:22 PM To: CF-Talk Subject: CF MX Anyone know if I could setup a test box for Neo and allow people to test pages on it? I know the NDA is pretty thick but it isn't for profit just for testing. Maybe a MM employee could shed some light or point me to an address to inquire? Thanks, Neil __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: EMERGENCY!!! NEED SOLARIS HELP
The start command is start it's in the coldfusion/bin directory. You might need to enter ./start to run it. As a side note, when you stop the server, we find it's very helpful to check process threads ps -ef |grep cf Sometimes the cfserver thread will freeze and the stop script doesn't kill it. If it isn't kill'ed manually the server will be very unstable and crash/freeze quickly again. Chris Norloff -- Original Message -- from: James Taavon [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Tue, 16 Apr 2002 10:41:51 -0400 I need the stop/startup command for CF on Solaris platform. THANKS IN ADVANCE!!! __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Strange behaviour with excel datasource
Hi all, I'm running two consecutive queries on an excel datasource as follows: first query simply updates values in a single record in the spreadsheet. The spreadsheet then uses these values to calculate APR on a loan using successive approximations method (RATE function in excel). The second query is a select statement in order to extract the resulting APR. Fairly straightforward, however the second query seems to always only retrieve a cached result. I've unchecked the maintain datasource connections in the datasource settings and have even tried using cachedwithin=createtimespan(0,0,0,0) in my cfquery tag, yet I'm still having a cached result being returned. My code is below: cfset loan_amt = ((vehicleadj + optionadj) * #variables.quantity#) - depositadj - balloonadj - tradeinadj cfquery name=enter datasource=finance maxrows=1 UPDATE APR$ SET payments = #quotation.term#, payment_amt = -#monthlyadj#, loan_amt = #loan_amt#, guess = #quotation.apr#/100 WHERE marker = 1 /cfquery cfquery name=get datasource=finance maxrows=1 cachedwithin=#createtimespan(0,0,0,0)# SELECT Rate FROM APR$ WHERE marker = 3 /cfquery cfset apradj = get.rate * 100 Any ideas welcome. TIA Dave __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF MX
At the risk of sounding like a Devil's advocate. If you do this, how would anyone know? Set up a box with software X, and ask people to browse it to test it for you... How are those people ( or anyone else ) going to know if the software being run is ColdFusion 4, 4.5, MX, or some other technology altogether? ( Well, if it were some other technology the extension might give it away, but.. ) At 08:20 AM 4/18/2002 -0400, you wrote: Without a doubt, this is a no-no. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 7:22 PM To: CF-Talk Subject: CF MX Anyone know if I could setup a test box for Neo and allow people to test pages on it? I know the NDA is pretty thick but it isn't for profit just for testing. Maybe a MM employee could shed some light or point me to an address to inquire? Thanks, Neil __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF MX
by dumping the server variables - that's how. -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 7:55 AM To: CF-Talk Subject: RE: CF MX At the risk of sounding like a Devil's advocate. If you do this, how would anyone know? Set up a box with software X, and ask people to browse it to test it for you... How are those people ( or anyone else ) going to know if the software being run is ColdFusion 4, 4.5, MX, or some other technology altogether? ( Well, if it were some other technology the extension might give it away, but.. ) At 08:20 AM 4/18/2002 -0400, you wrote: Without a doubt, this is a no-no. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 7:22 PM To: CF-Talk Subject: CF MX Anyone know if I could setup a test box for Neo and allow people to test pages on it? I know the NDA is pretty thick but it isn't for profit just for testing. Maybe a MM employee could shed some light or point me to an address to inquire? Thanks, Neil __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange behaviour with excel datasource
I have had this problem too (with CF 4.5). I was able to read from the excel data source alright and even update values (once). Then subsequent reads used the OLD value and updates were no longer happening. I wish I could remember the details of the investigation, but we ended up importing the excel file into a SQL server 7 database and using it as the data source. Craig -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 8:52 AM To: CF-Talk Subject: Strange behaviour with excel datasource Hi all, I'm running two consecutive queries on an excel datasource as follows: first query simply updates values in a single record in the spreadsheet. The spreadsheet then uses these values to calculate APR on a loan using successive approximations method (RATE function in excel). The second query is a select statement in order to extract the resulting APR. Fairly straightforward, however the second query seems to always only retrieve a cached result. I've unchecked the maintain datasource connections in the datasource settings and have even tried using cachedwithin=createtimespan(0,0,0,0) in my cfquery tag, yet I'm still having a cached result being returned. My code is below: cfset loan_amt = ((vehicleadj + optionadj) * #variables.quantity#) - depositadj - balloonadj - tradeinadj cfquery name=enter datasource=finance maxrows=1 UPDATE APR$ SET payments = #quotation.term#, payment_amt = -#monthlyadj#, loan_amt = #loan_amt#, guess = #quotation.apr#/100 WHERE marker = 1 /cfquery cfquery name=get datasource=finance maxrows=1 cachedwithin=#createtimespan(0,0,0,0)# SELECT Rate FROM APR$ WHERE marker = 3 /cfquery cfset apradj = get.rate * 100 Any ideas welcome. TIA Dave __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF MX
Jeff, It doesn't matter if no one knows. Its a breach of the NDA/Licence. If you get caught you'll get your wrist slapped. If you don't cease and desist you'll get a get a good legal kicking Why risk getting caught, getting a slapping and losing any goodwill that being a beta tester has built up between you and MM? Schrodinger's Cat - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 1:55 PM Subject: RE: CF MX At the risk of sounding like a Devil's advocate. If you do this, how would anyone know? Set up a box with software X, and ask people to browse it to test it for you... How are those people ( or anyone else ) going to know if the software being run is ColdFusion 4, 4.5, MX, or some other technology altogether? ( Well, if it were some other technology the extension might give it away, but.. ) At 08:20 AM 4/18/2002 -0400, you wrote: Without a doubt, this is a no-no. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 7:22 PM To: CF-Talk Subject: CF MX Anyone know if I could setup a test box for Neo and allow people to test pages on it? I know the NDA is pretty thick but it isn't for profit just for testing. Maybe a MM employee could shed some light or point me to an address to inquire? Thanks, Neil __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF MX
Being a beta tester myself, I consider it a privilege. I am going to do what MM asks, and what I agreed to do when I signed up. Getting to play with Betas and influencing changes to the final product is fun. I want to continue doing this as well, so if you ask me, I would say don't do it. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 8:17 AM To: CF-Talk Subject: Re: CF MX Jeff, It doesn't matter if no one knows. Its a breach of the NDA/Licence. If you get caught you'll get your wrist slapped. If you don't cease and desist you'll get a get a good legal kicking Why risk getting caught, getting a slapping and losing any goodwill that being a beta tester has built up between you and MM? Schrodinger's Cat - Original Message - From: Jeffry Houser [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 1:55 PM Subject: RE: CF MX At the risk of sounding like a Devil's advocate. If you do this, how would anyone know? Set up a box with software X, and ask people to browse it to test it for you... How are those people ( or anyone else ) going to know if the software being run is ColdFusion 4, 4.5, MX, or some other technology altogether? ( Well, if it were some other technology the extension might give it away, but.. ) At 08:20 AM 4/18/2002 -0400, you wrote: Without a doubt, this is a no-no. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 7:22 PM To: CF-Talk Subject: CF MX Anyone know if I could setup a test box for Neo and allow people to test pages on it? I know the NDA is pretty thick but it isn't for profit just for testing. Maybe a MM employee could shed some light or point me to an address to inquire? Thanks, Neil __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF MX
I think the question isn't whether or not you would get caught, but whether or not you have the integrity to abide by the NDA. There's also nothing stopping you from burning copies and selling them on eBay or from publishing a beta to a warez group or file sharing network. If someone doesn't plan on abiding by the agreement, they shouldn't make it. For the record Jeff, I am in no way calling your integrity into question with this message. :) Just my 2 cents. -Cameron -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 8:55 AM To: CF-Talk Subject: RE: CF MX At the risk of sounding like a Devil's advocate. If you do this, how would anyone know? Set up a box with software X, and ask people to browse it to test it for you... How are those people ( or anyone else ) going to know if the software being run is ColdFusion 4, 4.5, MX, or some other technology altogether? ( Well, if it were some other technology the extension might give it away, but.. ) At 08:20 AM 4/18/2002 -0400, you wrote: Without a doubt, this is a no-no. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 7:22 PM To: CF-Talk Subject: CF MX Anyone know if I could setup a test box for Neo and allow people to test pages on it? I know the NDA is pretty thick but it isn't for profit just for testing. Maybe a MM employee could shed some light or point me to an address to inquire? Thanks, Neil __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE 6.0 Bug
works with IE 5.5 too. -craig -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 6:56 AM To: CF-Talk Subject: RE: IE 6.0 Bug Its the long way to get to Minesweeper, but it works. andy -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 6:16 PM To: CF-Talk Subject: IE 6.0 Bug http://online.securityfocus.com/archive/1/267561 has anyone tried this? -- Sam __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cflock over multiple servers.
I have 3 mirrored servers accessing the same SQL-Server DB. They are all running an agent that retrieves news and weather. For redundantcy, They are each running the agent. I have set up a table that keeps track of the last time the agent ran and each server will check the table first before trying to run the agent. If the agent has ran in the last 30 min it will abort. These servers will all be synched up, and as such, they will be trying to run these agents at the exact same time. So I thought I would just put a cflock around the read and make the servers get in line and the first one to the server wins. Heres the question: Will this work? Will this lock reads by other servers? ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Timing a CFHTTP Request
I would like to measure the amount of time that an HTTP request takes to complete. Anyone have an example of how to do this? Tim __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF MX
At the risk of sounding like a Devil's advocate. If you do this, how would anyone know? Set up a box with software X, and ask people to browse it to test it for you... How are those people ( or anyone else ) going to know if the software being run is ColdFusion 4, 4.5, MX, or some other technology altogether? ( Well, if it were some other technology the extension might give it away, but.. ) At last check www.yourserver.com/CFIDE/administrator/index.cfm is still the generic way to get to the CF Admin, and most people don't change that. So just pull up that page on a site and the version number is right in your face. Although I will say this -- if you read section 1.2 of the NDA, it actually discusses what Neil's asking. It actually looks as though there's a bit of leeway. I'd read that and then explicitly send an e-mail to a Macromedia Beta program employee and clarify what it means. Their e-mails are all over the Beta forums. Regards, Dave. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange behaviour with excel datasource
Craig, I've just tried importing to SQL 7, but the problem here is that when importing the data I lose the RATE function. My code is updating the spreadsheet successfully every time. Its only when I go to read the new value (I'm simply using the sheet for apr calculation purposes) that I am getting a consistently cached value. Thanks for your suggestion though, Dave -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: 18 April 2002 14:18 To: CF-Talk Subject: RE: Strange behaviour with excel datasource I have had this problem too (with CF 4.5). I was able to read from the excel data source alright and even update values (once). Then subsequent reads used the OLD value and updates were no longer happening. I wish I could remember the details of the investigation, but we ended up importing the excel file into a SQL server 7 database and using it as the data source. Craig -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 8:52 AM To: CF-Talk Subject: Strange behaviour with excel datasource Hi all, I'm running two consecutive queries on an excel datasource as follows: first query simply updates values in a single record in the spreadsheet. The spreadsheet then uses these values to calculate APR on a loan using successive approximations method (RATE function in excel). The second query is a select statement in order to extract the resulting APR. Fairly straightforward, however the second query seems to always only retrieve a cached result. I've unchecked the maintain datasource connections in the datasource settings and have even tried using cachedwithin=createtimespan(0,0,0,0) in my cfquery tag, yet I'm still having a cached result being returned. My code is below: cfset loan_amt = ((vehicleadj + optionadj) * #variables.quantity#) - depositadj - balloonadj - tradeinadj cfquery name=enter datasource=finance maxrows=1 UPDATE APR$ SET payments = #quotation.term#, payment_amt = -#monthlyadj#, loan_amt = #loan_amt#, guess = #quotation.apr#/100 WHERE marker = 1 /cfquery cfquery name=get datasource=finance maxrows=1 cachedwithin=#createtimespan(0,0,0,0)# SELECT Rate FROM APR$ WHERE marker = 3 /cfquery cfset apradj = get.rate * 100 Any ideas welcome. TIA Dave __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Timing a CFHTTP Request
I would like to measure the amount of time that an HTTP request takes to complete. Anyone have an example of how to do this? Tim Use GetTickCount(). cfset variables.start = GetTickCount() cfhttp request here. cfset variables.end = GetTickCount() cfset variables.totalTime = variables.end - variables.start cfoutput#variables.totalTime#/cfoutput There may be a cleaner way, but I don't know of one. Hope this helps, Dave. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cflock over multiple servers.
No. CFLOCK (and all other tags) run locally on each server, and are not aware of other CFLOCKS on other CF servers. If you want them to all wait in line, the best solution may be to use a CFTRANSACTION around your table check to block the other servers out of that DB table/row till your DB timestamp has been updated. -Cameron I have 3 mirrored servers accessing the same SQL-Server DB. They are all running an agent that retrieves news and weather. For redundantcy, They are each running the agent. I have set up a table that keeps track of the last time the agent ran and each server will check the table first before trying to run the agent. If the agent has ran in the last 30 min it will abort. These servers will all be synched up, and as such, they will be trying to run these agents at the exact same time. So I thought I would just put a cflock around the read and make the servers get in line and the first one to the server wins. Heres the question: Will this work? Will this lock reads by other servers? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Custom1 attribute not working
I am searching from a number of collections and want to show which collection the result came from. I understand that using the custom1 attribute on cfindex should be the way to go and just put the name of the collection in there. The problem is that even though I identify custom1 in the cfindex line, the collection doesn't seem to store it. Following is the cfindex line: cfindex action=REFRESH collection=collection1 key=D:\HTTP\site1 type=PATH urlpath=http://www.mysite.edu/; recurse=Yes custom1=collection 1 When I do a cfdump on the returned query in my cfsearch, the custom1 field is blank for all the records. Any help would be greatly appreciated... Regards, Neil __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
neo question
weird thing just happened. i tried to install the neo beta on my xp pro box and the installation did go fine. the thing is that after the install, i tried to access the cf administrator backend and the cfide directory is not in my wwwroot directory. i did a search on my drive and the cfide directory is nowhere to be found. is this a bug? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Custom1 attribute not working
I think custom1 and custom2 are meant to store extra fields from a query that is being indexed. I don't think they apply to type=PATH, i.e. indexing files. - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available - Original Message - From: Neil Giarratana [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 2:56 PM Subject: Custom1 attribute not working I am searching from a number of collections and want to show which collection the result came from. I understand that using the custom1 attribute on cfindex should be the way to go and just put the name of the collection in there. The problem is that even though I identify custom1 in the cfindex line, the collection doesn't seem to store it. Following is the cfindex line: cfindex action=REFRESH collection=collection1 key=D:\HTTP\site1 type=PATH urlpath=http://www.mysite.edu/; recurse=Yes custom1=collection 1 When I do a cfdump on the returned query in my cfsearch, the custom1 field is blank for all the records. Any help would be greatly appreciated... Regards, Neil __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: neo question
Um - you _do_ know that this isn't the proper place to talk about Neo? Haven't we been over this already? -sigh- Please post your question to the Neo beta forums. Anyone on this list who _could_ help you is bound by NDA, and, if you have discovered a bug, the only way we can help you is if we _know_ about it. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:01 AM To: CF-Talk Subject: neo question weird thing just happened. i tried to install the neo beta on my xp pro box and the installation did go fine. the thing is that after the install, i tried to access the cf administrator backend and the cfide directory is not in my wwwroot directory. i did a search on my drive and the cfide directory is nowhere to be found. is this a bug? __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: neo question
[EMAIL PROTECTED] wrote: weird thing just happened. i tried to install the neo beta on my xp pro box and the installation did go fine. the thing is that after the install, i tried to access the cf administrator backend and the cfide directory is not in my wwwroot directory. i did a search on my drive and the cfide directory is nowhere to be found. is this a bug? You ever heard of this thing called NDA? Or are you one of those people who never read the legal contracts you sign and then complain when you get screwed? Ask in the Beta forums. Jochem __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Fourm DB Design Examples
You can download the existing schema for simple message board... http://www.simplemessageboard.com/ I am trying to design a DB for use with a Foums ap that I am also designing. Can anyone shed some light on a possible DB layout? Examples out there anywhere? *preferrably fusebox* Thanks, Mike __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: neo question
Hi Tony, Ditto to the NDA comments from others, here is the link to the beta forums where you should post your Neo questions: http://betaprograms.macromedia.com/forums/Index.cfm?CFApp=67 Regards, Christine Lawson Macromedia Technical Support -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:01 AM To: CF-Talk Subject: neo question weird thing just happened. i tried to install the neo beta on my xp pro box and the installation did go fine. the thing is that after the install, i tried to access the cf administrator backend and the cfide directory is not in my wwwroot directory. i did a search on my drive and the cfide directory is nowhere to be found. is this a bug? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: neo question
sorry about that. i tried to logon into the forums and i forgot my password. i'm waiting to get a reply and i thought that i could ask the list. it won't happen again. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:05 AM To: CF-Talk Subject: RE: neo question Um - you _do_ know that this isn't the proper place to talk about Neo? Haven't we been over this already? -sigh- Please post your question to the Neo beta forums. Anyone on this list who _could_ help you is bound by NDA, and, if you have discovered a bug, the only way we can help you is if we _know_ about it. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:01 AM To: CF-Talk Subject: neo question weird thing just happened. i tried to install the neo beta on my xp pro box and the installation did go fine. the thing is that after the install, i tried to access the cf administrator backend and the cfide directory is not in my wwwroot directory. i did a search on my drive and the cfide directory is nowhere to be found. is this a bug? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Javascript for invalid CF characters
Hi, I would like a Javascript to valildate a password field for characters which can cause problems with CF like # symbols. I'm not sure what other characters can cuase problems. Any suggestions? __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: UNION vs JOIN
Is there a significant difference in performance using a UNION on four tables versus a JOIN on four tables? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascript for invalid CF characters
Try something like this:
onchange=if (this.value.search(/[^a-zA-Z0-9]/) != -1) {this.value = '';
return;}
This will determine if there are any non-alphanumeric characters in the
string and destroy the entire string if there are, once the string
changes.
- Matt Small
-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:17 AM
To: CF-Talk
Subject: Javascript for invalid CF characters
Hi,
I would like a Javascript to valildate a password field for characters
which
can cause problems with CF like # symbols. I'm not sure what other
characters can cuase problems.
Any suggestions?
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: UNION vs JOIN
Union Adds the rows from a second table, Join combines the tables. It's conceivable that they produce the same result if you're using an outer join, but they're different. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/18/02 10:18AM Is there a significant difference in performance using a UNION on four tables versus a JOIN on four tables? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UNION vs JOIN
they do different things, really. what are you trying to accomplish? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:18 AM To: CF-Talk Subject: OT: UNION vs JOIN Is there a significant difference in performance using a UNION on four tables versus a JOIN on four tables? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: neo question
Yes, for the love of god, PLEASE stop posting questions about neo. It's not that your questions bother me, it just these pissy little NDA police getting their panties all in a bunch. I swear, I think some of these people do nothing BUT search for neo questions so they can refer to the NDA. I don't know if it makes them feel authoritative or what, but HOW ANNOYING! Who cares if he posts a question about neo - are YOU going to be sent to your room by the macromedia police? Do you really think anyone else out there is trying to build a CF to J2EE converter? Do you think anyone in their right mind would even attempt it? You're developers, why don't you just let the MM legal team take care of what they need to do, and CHILL OUT on the legal speak! If you think somebody is going outside of their agreement and it REALLY bothers you so much, write a letter to the lawyers - let them take care of it. EORant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 9:01 AM To: CF-Talk Subject: neo question weird thing just happened. i tried to install the neo beta on my xp pro box and the installation did go fine. the thing is that after the install, i tried to access the cf administrator backend and the cfide directory is not in my wwwroot directory. i did a search on my drive and the cfide directory is nowhere to be found. is this a bug? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Set focus on a CFINPUT field
Can someone point me to how to properly set focus on a CFINPUT field? I have tried document.FORMNAME.FIELDNAME.focus(); and it just does not acknowledge the code. document.FORMNAME.FIELDNAME.VALUE will give me the preset value that I set for the field. Thanks in Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential, and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the email listed above. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UNION vs JOIN
I am combining the results of three tables that are very similar in their setup and the fourth table holds all the relationships. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder they do different things, really. what are you trying to accomplish? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:18 AM To: CF-Talk Subject: OT: UNION vs JOIN Is there a significant difference in performance using a UNION on four tables versus a JOIN on four tables? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
stored procedure - Ambiguous column name
i've been trying to work this out for about a week and i am stumped. i keep
getting an error related to an ambiguous column name. I've checked the sp
over and over (with my admittedly sub-par sql skills) and cannot find
anything wrong. i've included the error and the sp below. any help is
appreciated very much. thanks
***error message***
Error occured at: 04/17/02 16:05:24
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR
1.0.3705)
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name
'categoryJobDescrID'.
SQL = sp_jobs_select
Data Source = **
***error message***
***stored procedure***
CREATE PROCEDURE [yourconsultant].[sp_jobs_select] @keyword varchar(100),
@locationID varchar(500), @categoryJobDescrID varchar(500), @page int, @size
int, @orderby varchar(100), @count int output
AS
DECLARE @sql nvarchar(2000), @where nvarchar(1000)
SET @WHERE='0=0'
IF @keyword IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND jobs.jobName LIKE ' + + @keyword + '%'' OR
jobs.jobDescription LIKE ' + + @keyword + '%'''
END
IF @locationID IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND locationJob.locationID IN (' + @locationID + ')'
END
IF @categoryJobDescrID IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND categoryJobListing.categoryJobDescrID IN (' +
@categoryJobDescrID + ') '
END
SET @sql =(' SELECT jobs.jobid, jobs. empid, jobs.jobname,
jobs.datetimeentered, location.location,
categoryJobDescr.categoryjobdescrname, employers.empName
FROM jobs
JOIN locationJob ON jobs.jobID = locationJob.jobID
JOIN categoryJobListing ON jobs.jobID = categoryJobListing.jobID
JOIN location ON location.locationID = locationJob.locationID
JOIN categoryJobDescr ON categoryJobDescr.categoryJobDescrID
=categoryJobListing.categoryJobDescrID
JOIN employers ON employers.empID = jobs.empID
WHERE ' +@WHERE+'
ORDER BY '+@orderby)
DECLARE @Start int, @End int
SET @Start = (((@Page - 1) * @Size) + 1)
SET @End = (@Start + @Size - 1)
CREATE TABLE #temp
(Row int IDENTITY(1,1) PRIMARY KEY,
JOBID int, EMPID int,
JOBNAME varchar(100),
DATETIMEENTERED datetime,
LOCATION varchar(150),
CATEGORYJOBDESCRNAME varchar(75),
EMPNAME varchar(100)
)
INSERT INTO #temp
EXEC(@sql)
BEGIN
SELECT categoryjobdescrname, datetimeentered, empid, empname, jobid,jobname,
location
FROM #temp
WHERE (Row = @Start) AND (Row = @End)
SET @count = (select count(*) from #temp)
END
DROP TABLE #temp
GO
***stored procedure***
-
Greg Jordan
Certified ColdFusion Developer
Web Project Manager
[EMAIL PROTECTED]
---
[This E-mail scanned for viruses by Declude Virus]
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Set focus on a CFINPUT field
Try setting it through a function.
That is how I do onload events.
script language=Javascript
function focusme()
{
document.PracticeDetail.PName.focus();
}
/script
BODY onload='focusme()' bgcolor=white
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:52 AM
To: CF-Talk
Subject: Set focus on a CFINPUT field
Can someone point me to how to properly set focus on a CFINPUT field?
I have tried document.FORMNAME.FIELDNAME.focus();
and it just does not acknowledge the code.
document.FORMNAME.FIELDNAME.VALUE will give me the preset value that I set for
the field.
Thanks in Advance
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
[EMAIL PROTECTED]
CONFIDENTIALITY NOTICE
The information contained in this e-mail is intended only for the use of the
individual or entity to which it is addressed. This e-mail may contain
information that is privileged, confidential, and/or personal. If the reader of
this message is not the intended recipient (or the employee or agent responsible
to deliver it to the intended recipient), you are hereby notified that any
dissemination, distribution, or copying of this communication is prohibited.
If you have received this communication in error, please notify us at the email
listed above.
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: neo question
I second that --Allan -Original Message- From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 4:45 PM To: CF-Talk Subject: RE: neo question Yes, for the love of god, PLEASE stop posting questions about neo. It's not that your questions bother me, it just these pissy little NDA police getting their panties all in a bunch. I swear, I think some of these people do nothing BUT search for neo questions so they can refer to the NDA. I don't know if it makes them feel authoritative or what, but HOW ANNOYING! Who cares if he posts a question about neo - are YOU going to be sent to your room by the macromedia police? Do you really think anyone else out there is trying to build a CF to J2EE converter? Do you think anyone in their right mind would even attempt it? You're developers, why don't you just let the MM legal team take care of what they need to do, and CHILL OUT on the legal speak! If you think somebody is going outside of their agreement and it REALLY bothers you so much, write a letter to the lawyers - let them take care of it. EORant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 9:01 AM To: CF-Talk Subject: neo question weird thing just happened. i tried to install the neo beta on my xp pro box and the installation did go fine. the thing is that after the install, i tried to access the cf administrator backend and the cfide directory is not in my wwwroot directory. i did a search on my drive and the cfide directory is nowhere to be found. is this a bug? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: neo question
At 09:45 AM 4/18/2002 -0500, you wrote: Yes, for the love of god, PLEASE stop posting questions about neo. It's not that your questions bother me, it just these pissy little NDA police getting their panties all in a bunch. I swear, I think some of these people do nothing BUT search for neo questions so they can refer to the NDA. I don't know if it makes them feel authoritative or what, but HOW ANNOYING! Who cares if he posts a question about neo - are YOU going to be sent to your room by the macromedia police? Do you really think anyone else out there is trying to build a CF to J2EE converter? http://www.n-ary.com/products/bluedragon.cfm ( It used to be called TagServlet, and before that TagFusion ) There used to be more information located at tagservlet.com. Do you think anyone in their right mind would even attempt it? They actually did it before Macromedia. I haven't had a chance to play around with it ( yet ) but it is on my list of things to do. -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 860-223-7946 -- My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Submitting a form only once, iow, preventing impatient user double clicks.
-Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Oh! Oh! I know this one! I know this one! Someone helped me with this just the other day :) Thank you to Angel, Diana, Justin, Thane, Larry and [EMAIL PROTECTED] Unbelievably fast helpful people on this list. Charles Nahm Sonic Networks Inc. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Set focus on a CFINPUT field
Larry, Try this syntax: document.FORMNAME.elements['FIELD_NAME'].focus(); Ryan Pieszak -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 9:52 AM To: CF-Talk Subject: Set focus on a CFINPUT field Can someone point me to how to properly set focus on a CFINPUT field? I have tried document.FORMNAME.FIELDNAME.focus(); and it just does not acknowledge the code. document.FORMNAME.FIELDNAME.VALUE will give me the preset value that I set for the field. Thanks in Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential, and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the email listed above. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: neo question
hehe, I stand corrected. -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 9:56 AM To: CF-Talk Subject: RE: neo question At 09:45 AM 4/18/2002 -0500, you wrote: Yes, for the love of god, PLEASE stop posting questions about neo. It's not that your questions bother me, it just these pissy little NDA police getting their panties all in a bunch. I swear, I think some of these people do nothing BUT search for neo questions so they can refer to the NDA. I don't know if it makes them feel authoritative or what, but HOW ANNOYING! Who cares if he posts a question about neo - are YOU going to be sent to your room by the macromedia police? Do you really think anyone else out there is trying to build a CF to J2EE converter? http://www.n-ary.com/products/bluedragon.cfm ( It used to be called TagServlet, and before that TagFusion ) There used to be more information located at tagservlet.com. Do you think anyone in their right mind would even attempt it? They actually did it before Macromedia. I haven't had a chance to play around with it ( yet ) but it is on my list of things to do. -- Jeffry Houser | mailto:[EMAIL PROTECTED] Need a Web Developer? Contact me! AIM: Reboog711 | Fax / Phone: 860-223-7946 -- My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Submitting a form only once, iow, preventing impatient user d ouble clicks.
Just a side note... I just joined this list a few days ago, and I have to agree with Charles in saying that the response time and actual helpfulness on this list is top-notch. I tip my hat to all of you. Ryan Pieszak -Original Message- From: Charles Nahm [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:21 AM To: CF-Talk Subject: RE: Submitting a form only once, iow, preventing impatient user double clicks. -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Oh! Oh! I know this one! I know this one! Someone helped me with this just the other day :) Thank you to Angel, Diana, Justin, Thane, Larry and [EMAIL PROTECTED] Unbelievably fast helpful people on this list. Charles Nahm Sonic Networks Inc. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
pulling wrong dates from database
I have an SQL database with several tables in it. The Events table is the main one and contains the primary key ID and is an AutoNumber; it is related to each of the other tables: Dates, Internet, Intranet, PPrint which all contain their own ID field and contain the fields BeginDate and EndDate. All relationships are set up as one-to-many. When I access the form for an event, all the beginning and ending dates on the form are the same. I can't figure out what the problem with my code is. Hopefully, someone can tell me what I've done wrong here. Here is my query in my updateaction.cfm file: cfquery name=UpdateEvent datasource=Events UPDATE Events, Dates, times, Internet, Intranet, PPrint SET Events.Inactive = '#form.inactive#', Events.Title = '#form.title#', Events.InterDesc = '#form.InterDesc#', Events.IntraDesc = '#form.IntraDesc#', Events.PrintDesc = '#form.PrintDesc#', Events.InterPub = '#form.InterPub#', Events.IntraPub = '#form.IntraPub#', Events.PrintPub = '#form.PrintPub#', Events.Area = '#form.Area#', Events.location = '#form.Location#', Events.Ticketed = '#form.Ticketed#', Events.Kid = '#form.Kid#', Events.Handicap = '#form.Handicap#', Events.Updatedon = '#form.Updatedon#', Times.EventTime = '#form.Times.EventTime#', Times.Comment = '#form.Comment#', Dates.BeginDate = '#form.Dates.BeginDate#', Dates.EndDate = '#form.Dates.EndDate#', PPrint.BeginDate = '#form.PPrint.BeginDate#', PPrint.EndDate = '#form.PPrint.EndDate#', Internet.BeginDate = '#form.Internet.BeginDate#', Internet.EndDate = '#form.Internet.EndDate#', Intranet.BeginDate = '#form.Intranet.BeginDate#', Intanet.EndDate = '#form.Intranet.EndDate#' WHERE Events.ID = #URL.ID# /cfquery Here is the code in my updateform.cfm file. !--- query to get an event to update--- cfquery name=GetEventtoUpdate datasource=Events SELECT Events.Inactive, Events.Title, Events.InterDesc, Events.IntraDesc, Events.PrintDesc, Events.PrintPub, Events.InterPub, Events.IntraPub, Events.Area, Events.Location, Events.Ticketed, Events.Kid, Events.Handicap, Events.Updatedon, Dates.BeginDate, Dates.EndDate, Times.EventTime, Times.Comment, Internet.BeginDate, Internet.EndDate, PPrint.BeginDate, PPrint.EndDate, Intranet.BeginDate, Intranet.EndDate FROM Events, Dates, Times, Internet, Intranet, PPrint WHERE events.ID = #URL.ID# AND times.id = #URL.ID# AND dates.id = #URL.ID# AND internet.id = #URL.ID# AND intranet.id = #URL.ID# AND pprint.id = #URL.ID# /cfquery !--- end query--- html head titleEdit Event/title /head body !--- define the action page in the form tag. The form variables will pass to this page when form is submitted--- cfoutput query=GetEventtoUpdate form action=updateaction.cfm method=post input type=Hidden name=ID value=#ID#br table border=0 bgcolor=E0E0E0 cellpadding=0 cellspacing=0 width=100% tr td width=100% valign=middle bgcolor=00 align=center table border=0 bgcolor=E0E0E0 cellpadding=0 cellspacing=1 width=100% tr td bgcolor=7D table width=100% cellpadding=2 cellspacing=0 tr td bgcolor=7D valign=middle font color=FFbEditing an Event/b/font /td /tr /table /td /tr td bgcolor=FF table width=100% border=0 cellspacing=0 cellpadding=2 !--- end table layout --- !--- start update form --- trtd/td td align=rightInactive? input type=checkbox name=Inactive value=#GetEventtoUpdate.Inactive# notchecked /td /tr tr td width=100Event Title:/td tdinput type=text name=Events.Title value=#GetEventtoUpdate.Title# size=67 maxlength=255 /td /tr tr tdUpdated on: /td tdinput type=text name=Events.Updatedon value=#Dateformat(GetEventtoUpdate.updatedon, dd, )#/td /tr tr td/td td colspan=2Time:nbsp; nbsp; nbsp;nbsp; nbsp; nbsp;nbsp; nbsp; nbsp;Comment:/td /tr tr td /td tdinput type=text name=Times.EventTime value=#Timeformat(GetEventtoUpdate.EventTime, hh:mm)#br / input type=text name=Times.Comment value=#GetEventtoUpdate.Comment# br / /td /tr tr td/td tdnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;input type=button name=extendBtn value=Add More Times ... onclick=extend();/td /tr tr td/td td colspan=2Beginning Date:nbsp; nbsp; nbsp;Ending Date:/td /tr tr td /td tdinput type=text name=Events.BeginDate value=#DateFormat(GetEventtoUpdate.BeginDate, mm/dd/)# br / input type=text name=Events.EndDate value=#DateFormat(GetEventtoUpdate.EndDate, mm/dd/)# br / /td /tr tr td/td tdnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;input type=button name=extendBtn value=Add More Dates ... onclick=extend();/td /tr tr/tr tr td width=10Area/Section:/td tdinput type=text name=Area value=#GetEventtoUpdate.Area# size=20 maxlength=20 /td /tr tr td width=10Location:/td tdinput type=text name=Location value=#GetEventtoUpdate.Location# size=20 maxlength=20/td /tr tr td width=100 valign=topCategory: /td
RE: Set focus on a CFINPUT field
I have tried that also. Exact code as you have written below.
It appears that the ColdFusion javascript doesn't allow the hardwritten code to
populate.
-Original Message-
From: David DiPietro [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:00 AM
To: CF-Talk
Subject: RE: Set focus on a CFINPUT field
Try setting it through a function.
That is how I do onload events.
script language=Javascript
function focusme()
{
document.PracticeDetail.PName.focus();
}
/script
BODY onload='focusme()' bgcolor=white
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:52 AM
To: CF-Talk
Subject: Set focus on a CFINPUT field
Can someone point me to how to properly set focus on a CFINPUT field?
I have tried document.FORMNAME.FIELDNAME.focus();
and it just does not acknowledge the code.
document.FORMNAME.FIELDNAME.VALUE will give me the preset value that I set for
the field.
Thanks in Advance
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
[EMAIL PROTECTED]
CONFIDENTIALITY NOTICE
The information contained in this e-mail is intended only for the use of the
individual or entity to which it is addressed. This e-mail may contain
information that is privileged, confidential, and/or personal. If the reader of
this message is not the intended recipient (or the employee or agent responsible
to deliver it to the intended recipient), you are hereby notified that any
dissemination, distribution, or copying of this communication is prohibited.
If you have received this communication in error, please notify us at the email
listed above.
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Set focus on a CFINPUT field
Still to no avail -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:06 AM To: CF-Talk Subject: RE: Set focus on a CFINPUT field Larry, Try this syntax: document.FORMNAME.elements['FIELD_NAME'].focus(); Ryan Pieszak -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 9:52 AM To: CF-Talk Subject: Set focus on a CFINPUT field Can someone point me to how to properly set focus on a CFINPUT field? I have tried document.FORMNAME.FIELDNAME.focus(); and it just does not acknowledge the code. document.FORMNAME.FIELDNAME.VALUE will give me the preset value that I set for the field. Thanks in Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential, and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the email listed above. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Set focus on a CFINPUT field
Right, you need to do it as a function in an onLoad event because if you don't it will immediately look for that formfield before it exists. Onload waits until the page is fully loaded before executing the function. BJ = = = Original message = = = Try setting it through a function. That is how I do onload events. script language=Javascript function focusme() ~document.PracticeDetail.PName.focus(); /script BODY onload='focusme()' bgcolor=white -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:52 AM To: CF-Talk Subject: Set focus on a CFINPUT field Can someone point me to how to properly set focus on a CFINPUT field? I have tried document.FORMNAME.FIELDNAME.focus(); and it just does not acknowledge the code. document.FORMNAME.FIELDNAME.VALUE will give me the preset value that I set for the field. Thanks in Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential, and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the email listed above. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: stored procedure - Ambiguous column name
Greg,
categoryJobDescrID is in both you categoryJobDescr and categoryJobListing
table.
The procedure looks ok, so I can only assume that you are passing through
categoryJobDescrID as one of the fields in @orderby without a tablename
prefix.
Regards
Stephen
- Original Message -
From: Greg Jordan [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 3:41 PM
Subject: stored procedure - Ambiguous column name
i've been trying to work this out for about a week and i am stumped. i
keep
getting an error related to an ambiguous column name. I've checked the sp
over and over (with my admittedly sub-par sql skills) and cannot find
anything wrong. i've included the error and the sp below. any help is
appreciated very much. thanks
***error message***
Error occured at: 04/17/02 16:05:24
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR
1.0.3705)
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name
'categoryJobDescrID'.
SQL = sp_jobs_select
Data Source = **
***error message***
***stored procedure***
CREATE PROCEDURE [yourconsultant].[sp_jobs_select] @keyword varchar(100),
@locationID varchar(500), @categoryJobDescrID varchar(500), @page int,
@size
int, @orderby varchar(100), @count int output
AS
DECLARE @sql nvarchar(2000), @where nvarchar(1000)
SET @WHERE='0=0'
IF @keyword IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND jobs.jobName LIKE ' + + @keyword + '%'' OR
jobs.jobDescription LIKE ' + + @keyword + '%'''
END
IF @locationID IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND locationJob.locationID IN (' + @locationID +
')'
END
IF @categoryJobDescrID IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND categoryJobListing.categoryJobDescrID IN (' +
@categoryJobDescrID + ') '
END
SET @sql =(' SELECT jobs.jobid, jobs. empid, jobs.jobname,
jobs.datetimeentered, location.location,
categoryJobDescr.categoryjobdescrname, employers.empName
FROM jobs
JOIN locationJob ON jobs.jobID = locationJob.jobID
JOIN categoryJobListing ON jobs.jobID = categoryJobListing.jobID
JOIN location ON location.locationID = locationJob.locationID
JOIN categoryJobDescr ON categoryJobDescr.categoryJobDescrID
=categoryJobListing.categoryJobDescrID
JOIN employers ON employers.empID = jobs.empID
WHERE ' +@WHERE+'
ORDER BY '+@orderby)
DECLARE @Start int, @End int
SET @Start = (((@Page - 1) * @Size) + 1)
SET @End = (@Start + @Size - 1)
CREATE TABLE #temp
(Row int IDENTITY(1,1) PRIMARY KEY,
JOBID int, EMPID int,
JOBNAME varchar(100),
DATETIMEENTERED datetime,
LOCATION varchar(150),
CATEGORYJOBDESCRNAME varchar(75),
EMPNAME varchar(100)
)
INSERT INTO #temp
EXEC(@sql)
BEGIN
SELECT categoryjobdescrname, datetimeentered, empid, empname,
jobid,jobname,
location
FROM #temp
WHERE (Row = @Start) AND (Row = @End)
SET @count = (select count(*) from #temp)
END
DROP TABLE #temp
GO
***stored procedure***
-
Greg Jordan
Certified ColdFusion Developer
Web Project Manager
[EMAIL PROTECTED]
---
[This E-mail scanned for viruses by Declude Virus]
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UNION vs JOIN
can you give more detail? from just this amount, it sounds like a join may be in the making. are all the tables related via the relationship table? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:00 AM To: CF-Talk Subject: Re: UNION vs JOIN I am combining the results of three tables that are very similar in their setup and the fourth table holds all the relationships. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder they do different things, really. what are you trying to accomplish? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:18 AM To: CF-Talk Subject: OT: UNION vs JOIN Is there a significant difference in performance using a UNION on four tables versus a JOIN on four tables? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Set focus on a CFINPUT field
Larry,
This is the exact code we use for out logon screen:
SCRIPT FOR=window EVENT=onload LANGUAGE=JScript
cfoutputdocument.Logon.elements['Username'].focus();/cfoutput
/SCRIPT
Been working for years.
Ryan Pieszak
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:11 AM
To: CF-Talk
Subject: RE: Set focus on a CFINPUT field
I have tried that also. Exact code as you have written below.
It appears that the ColdFusion javascript doesn't allow the hardwritten code
to
populate.
-Original Message-
From: David DiPietro [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:00 AM
To: CF-Talk
Subject: RE: Set focus on a CFINPUT field
Try setting it through a function.
That is how I do onload events.
script language=Javascript
function focusme()
{
document.PracticeDetail.PName.focus();
}
/script
BODY onload='focusme()' bgcolor=white
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:52 AM
To: CF-Talk
Subject: Set focus on a CFINPUT field
Can someone point me to how to properly set focus on a CFINPUT field?
I have tried document.FORMNAME.FIELDNAME.focus();
and it just does not acknowledge the code.
document.FORMNAME.FIELDNAME.VALUE will give me the preset value that I set
for
the field.
Thanks in Advance
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
[EMAIL PROTECTED]
CONFIDENTIALITY NOTICE
The information contained in this e-mail is intended only for the use of the
individual or entity to which it is addressed. This e-mail may contain
information that is privileged, confidential, and/or personal. If the reader
of
this message is not the intended recipient (or the employee or agent
responsible
to deliver it to the intended recipient), you are hereby notified that any
dissemination, distribution, or copying of this communication is
prohibited.
If you have received this communication in error, please notify us at the
email
listed above.
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: stored procedure - Ambiguous column name
i've been trying to work this out for about a week and i am stumped. i keep getting an error related to an ambiguous column name. I've checked the sp over and over (with my admittedly sub-par sql skills) and cannot find anything wrong. i've included the error and the sp below. any help is appreciated very much. ***error message*** Error occured at: 04/17/02 16:05:24 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'categoryJobDescrID'. I don't see an obvious error, but are you referencing that field in your orderby string? 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Set focus on a CFINPUT field
ColdFusion does not play a roll in this. Check the resulting html. Does the form have a name? Does the field have a name? Check your CaSe, JavaScrIpt is cAsE senSative. BJ = = = Original message = = = I have tried that also. Exact code as you have written below. It appears that the ColdFusion javascript doesn't allow the hardwritten code to populate. -Original Message- From: David DiPietro [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:00 AM To: CF-Talk Subject: RE: Set focus on a CFINPUT field Try setting it through a function. That is how I do onload events. script language=Javascript function focusme() ~document.PracticeDetail.PName.focus(); /script BODY onload='focusme()' bgcolor=white -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:52 AM To: CF-Talk Subject: Set focus on a CFINPUT field Can someone point me to how to properly set focus on a CFINPUT field? I have tried document.FORMNAME.FIELDNAME.focus(); and it just does not acknowledge the code. document.FORMNAME.FIELDNAME.VALUE will give me the preset value that I set for the field. Thanks in Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential, and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the email listed above. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Set focus on a CFINPUT field
What are you using the cfinput for? You might be able to write your own
function that does the trick as well and still allows you to focus on
the textbox. Also, there's no reason that cf generated javascript works
any different that that you write on your own. Can we see the HTML code
for the generated page?
- Matt Small
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:11 AM
To: CF-Talk
Subject: RE: Set focus on a CFINPUT field
I have tried that also. Exact code as you have written below.
It appears that the ColdFusion javascript doesn't allow the hardwritten
code to
populate.
-Original Message-
From: David DiPietro [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:00 AM
To: CF-Talk
Subject: RE: Set focus on a CFINPUT field
Try setting it through a function.
That is how I do onload events.
script language=Javascript
function focusme()
{
document.PracticeDetail.PName.focus();
}
/script
BODY onload='focusme()' bgcolor=white
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:52 AM
To: CF-Talk
Subject: Set focus on a CFINPUT field
Can someone point me to how to properly set focus on a CFINPUT field?
I have tried document.FORMNAME.FIELDNAME.focus();
and it just does not acknowledge the code.
document.FORMNAME.FIELDNAME.VALUE will give me the preset value that I
set for
the field.
Thanks in Advance
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
[EMAIL PROTECTED]
CONFIDENTIALITY NOTICE
The information contained in this e-mail is intended only for the use of
the
individual or entity to which it is addressed. This e-mail may contain
information that is privileged, confidential, and/or personal. If the
reader of
this message is not the intended recipient (or the employee or agent
responsible
to deliver it to the intended recipient), you are hereby notified that
any
dissemination, distribution, or copying of this communication is
prohibited.
If you have received this communication in error, please notify us at
the email
listed above.
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Set focus on a CFINPUT field
I am wondering if my problem is that I am including the CFFORM in a CFINCLUDE for a fuseaction of fuseaction=login.login Could this somehow not be transferring properly? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:13 AM To: CF-Talk Subject: RE: Set focus on a CFINPUT field Right, you need to do it as a function in an onLoad event because if you don't it will immediately look for that formfield before it exists. Onload waits until the page is fully loaded before executing the function. BJ = = = Original message = = = Try setting it through a function. That is how I do onload events. script language=Javascript function focusme() ~document.PracticeDetail.PName.focus(); /script BODY onload='focusme()' bgcolor=white -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:52 AM To: CF-Talk Subject: Set focus on a CFINPUT field Can someone point me to how to properly set focus on a CFINPUT field? I have tried document.FORMNAME.FIELDNAME.focus(); and it just does not acknowledge the code. document.FORMNAME.FIELDNAME.VALUE will give me the preset value that I set for the field. Thanks in Advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential, and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the email listed above. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: stored procedure - Ambiguous column name
Greg,
This error usually indicates a failure to properly alias during a join -
where the driver can't figure out which table to pull jobdescId from.
Mark
-Original Message-
From: Greg Jordan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 9:42 AM
To: CF-Talk
Subject: stored procedure - Ambiguous column name
i've been trying to work this out for about a week and i am stumped. i keep
getting an error related to an ambiguous column name. I've checked the sp
over and over (with my admittedly sub-par sql skills) and cannot find
anything wrong. i've included the error and the sp below. any help is
appreciated very much. thanks
***error message***
Error occured at: 04/17/02 16:05:24
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR
1.0.3705)
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name
'categoryJobDescrID'.
SQL = sp_jobs_select
Data Source = **
***error message***
***stored procedure***
CREATE PROCEDURE [yourconsultant].[sp_jobs_select] @keyword varchar(100),
@locationID varchar(500), @categoryJobDescrID varchar(500), @page int, @size
int, @orderby varchar(100), @count int output
AS
DECLARE @sql nvarchar(2000), @where nvarchar(1000)
SET @WHERE='0=0'
IF @keyword IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND jobs.jobName LIKE ' + + @keyword + '%'' OR
jobs.jobDescription LIKE ' + + @keyword + '%'''
END
IF @locationID IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND locationJob.locationID IN (' + @locationID + ')'
END
IF @categoryJobDescrID IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND categoryJobListing.categoryJobDescrID IN (' +
@categoryJobDescrID + ') '
END
SET @sql =(' SELECT jobs.jobid, jobs. empid, jobs.jobname,
jobs.datetimeentered, location.location,
categoryJobDescr.categoryjobdescrname, employers.empName
FROM jobs
JOIN locationJob ON jobs.jobID = locationJob.jobID
JOIN categoryJobListing ON jobs.jobID = categoryJobListing.jobID
JOIN location ON location.locationID = locationJob.locationID
JOIN categoryJobDescr ON categoryJobDescr.categoryJobDescrID
=categoryJobListing.categoryJobDescrID
JOIN employers ON employers.empID = jobs.empID
WHERE ' +@WHERE+'
ORDER BY '+@orderby)
DECLARE @Start int, @End int
SET @Start = (((@Page - 1) * @Size) + 1)
SET @End = (@Start + @Size - 1)
CREATE TABLE #temp
(Row int IDENTITY(1,1) PRIMARY KEY,
JOBID int, EMPID int,
JOBNAME varchar(100),
DATETIMEENTERED datetime,
LOCATION varchar(150),
CATEGORYJOBDESCRNAME varchar(75),
EMPNAME varchar(100)
)
INSERT INTO #temp
EXEC(@sql)
BEGIN
SELECT categoryjobdescrname, datetimeentered, empid, empname, jobid,jobname,
location
FROM #temp
WHERE (Row = @Start) AND (Row = @End)
SET @count = (select count(*) from #temp)
END
DROP TABLE #temp
GO
***stored procedure***
-
Greg Jordan
Certified ColdFusion Developer
Web Project Manager
[EMAIL PROTECTED]
---
[This E-mail scanned for viruses by Declude Virus]
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: I can't find RDS Service
Do you know how can be sure if RDS Service is installed? I've checked in services and I didn't found anything related with RDS service. What is the exact name of the service? can I install again the RDS Service? I'm using CF Server 5 and CF Studio 5 in a w2ksp2 box. The name of the service is ColdFusion RDS. To the best of my knowledge, you can't install CF 5 without installing the RDS service, so if you installed CF, it should be there. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: stored procedure - Ambiguous column name
no -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:21 AM To: CF-Talk Subject: RE: stored procedure - Ambiguous column name i've been trying to work this out for about a week and i am stumped. i keep getting an error related to an ambiguous column name. I've checked the sp over and over (with my admittedly sub-par sql skills) and cannot find anything wrong. i've included the error and the sp below. any help is appreciated very much. ***error message*** Error occured at: 04/17/02 16:05:24 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705) ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'categoryJobDescrID'. I don't see an obvious error, but are you referencing that field in your @orderby string? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: stored procedure - Ambiguous column name
the default orderby is dateTimeEntered desc. here is cfml. thanks again!
cfparam name=attributes.keywords default=
cfparam name=attributes.locationID default=
cfparam name=attributes.categoryJobDescrID default=
cfparam name=attributes.page default=1
cfparam name=attributes.size default=10
cfparam name=attributes.orderby default=dateTimeEntered desc
cfstoredproc procedure=sp_jobs_select datasource=#request.Datasource#
cfif attributes.keywords IS NOT
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@keyword
value=#attributes.keywords# null=No
cfelse
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@keyword
null=Yes
/cfif
cfif attributes.locationID IS NOT
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbvarname=@locationID
value=#attributes.locationID# null=No
cfelse
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbvarname=@locationID
null=Yes
/cfif
cfif attributes.categoryJobDescrID IS NOT
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbvarname=@categoryJobDescrID value=#attributes.categoryJobDescrID#
null=No
cfelse
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbvarname=@categoryJobDescrID null=Yes
/cfif
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@page
value=#attributes.page# null=No
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@size
value=#attributes.size# null=No
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@orderyby
value=#URLDecode(attributes.orderby)# null=No
cfprocparam type=Out cfsqltype=CF_SQL_INTEGER variable=rowcount
dbvarname=@count null=Yes
cfprocresult name=jobs_select
/cfstoredproc
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:18 AM
To: CF-Talk
Subject: Re: stored procedure - Ambiguous column name
Greg,
categoryJobDescrID is in both you categoryJobDescr and categoryJobListing
table.
The procedure looks ok, so I can only assume that you are passing through
categoryJobDescrID as one of the fields in @orderby without a tablename
prefix.
Regards
Stephen
- Original Message -
From: Greg Jordan [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 3:41 PM
Subject: stored procedure - Ambiguous column name
i've been trying to work this out for about a week and i am stumped. i
keep
getting an error related to an ambiguous column name. I've checked the sp
over and over (with my admittedly sub-par sql skills) and cannot find
anything wrong. i've included the error and the sp below. any help is
appreciated very much. thanks
***error message***
Error occured at: 04/17/02 16:05:24
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR
1.0.3705)
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name
'categoryJobDescrID'.
SQL = sp_jobs_select
Data Source = **
***error message***
***stored procedure***
CREATE PROCEDURE [yourconsultant].[sp_jobs_select] @keyword varchar(100),
@locationID varchar(500), @categoryJobDescrID varchar(500), @page int,
@size
int, @orderby varchar(100), @count int output
AS
DECLARE @sql nvarchar(2000), @where nvarchar(1000)
SET @WHERE='0=0'
IF @keyword IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND jobs.jobName LIKE ' + + @keyword + '%'' OR
jobs.jobDescription LIKE ' + + @keyword + '%'''
END
IF @locationID IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND locationJob.locationID IN (' + @locationID +
')'
END
IF @categoryJobDescrID IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND categoryJobListing.categoryJobDescrID IN (' +
@categoryJobDescrID + ') '
END
SET @sql =(' SELECT jobs.jobid, jobs. empid, jobs.jobname,
jobs.datetimeentered, location.location,
categoryJobDescr.categoryjobdescrname, employers.empName
FROM jobs
JOIN locationJob ON jobs.jobID = locationJob.jobID
JOIN categoryJobListing ON jobs.jobID = categoryJobListing.jobID
JOIN location ON location.locationID = locationJob.locationID
JOIN categoryJobDescr ON categoryJobDescr.categoryJobDescrID
=categoryJobListing.categoryJobDescrID
JOIN employers ON employers.empID = jobs.empID
WHERE ' +@WHERE+'
ORDER BY '+@orderby)
DECLARE @Start int, @End int
SET @Start = (((@Page - 1) * @Size) + 1)
SET @End = (@Start + @Size - 1)
CREATE TABLE #temp
(Row int IDENTITY(1,1) PRIMARY KEY,
JOBID int, EMPID int,
JOBNAME varchar(100),
DATETIMEENTERED datetime,
LOCATION varchar(150),
CATEGORYJOBDESCRNAME varchar(75),
EMPNAME varchar(100)
)
INSERT INTO #temp
EXEC(@sql)
BEGIN
SELECT categoryjobdescrname, datetimeentered, empid, empname,
jobid,jobname,
location
FROM #temp
WHERE (Row = @Start) AND
RE: UNION vs JOIN
If you have a single table with fields from other tables you can join them all fairly simply. Consider the following four tables: cars carid cartypeid carcolorid carmodelid carmodel carmodelid model carcolor carcolorid color cartype cartypeid type You can get the data from all the tables with a join: (i'm using the older syntax cause it is easier, the letters are aliases) select a.carid, b.model, c.color, d.type from cars a, carmodel b, carcolor c, cartype d where a.carmodelid = b.carmodelid and a.carcolorid = c.carmodelid and a.cartypeid = d.cartypeid and a.carid = That will get all the data for one car. Good Fortune, Richard Walters, Webmaster, Davita Laboratory Services [EMAIL PROTECTED] (800) 604-5227 x 3525 [EMAIL PROTECTED] 04/18/02 11:14AM can you give more detail? from just this amount, it sounds like a join may be in the making. are all the tables related via the relationship table? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:00 AM To: CF-Talk Subject: Re: UNION vs JOIN I am combining the results of three tables that are very similar in their setup and the fourth table holds all the relationships. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder they do different things, really. what are you trying to accomplish? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:18 AM To: CF-Talk Subject: OT: UNION vs JOIN Is there a significant difference in performance using a UNION on four tables versus a JOIN on four tables? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Backup CF Schecduler
Is there a way to back-up and restore the list of CF scheduled events? BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: neo question
Sorry you take offence Adam :( But it does help if everyone would honour the NDA - unfortunately its not the case and leaks do get out!, when people 'rant' about NDA it is merely to protect the interests of both MACR and the developers who use the products. Also when people post about its a breach etc... it is only a post to make sure people know that they could get in trouble... no-one gets brownie points, and no one gets off on it - it is a friendly thing to do to protect fellow developers. It is not about who or what someone can do re: CF J2EE convertor (which seems a little pointless with Neo), but the fact that if beta software info gets out and it being beta software - any bad press reflects bad on the product and the company as a whole , which could in turn effect sales - after all.. this is what building software is all about! There are engineers working their asses off 24/7, for millions of dollars of research and technical expertise to build an app which you technically get for pittance compared the cost of building it :-) NDA exists to protect the developer and the company... you wouldn't like it if someone called your bank and asked the bank freely gave away your credit history, details or if someone visited your doctor and he gave sensitive CONFIDENTIAL information to that visitor would you? For me, yes it does bother me when people are frivelous with info, but thats me - I certainly dont get off on stating that it shouldn't be done. I just think its wrong. If you want, in future - then yes the people who you think are authoritive can contact the legals first. But that would be stupid as we are all one big happy developer community!!! Time to get off the subject and move on(under NDA of course :-) Neil __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Javascript for invalid CF characters
Thanks Matt! Worked great.
- Original Message -
From: Matthew R. Small [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 10:31 AM
Subject: RE: Javascript for invalid CF characters
Try something like this:
onchange=if (this.value.search(/[^a-zA-Z0-9]/) != -1) {this.value = '';
return;}
This will determine if there are any non-alphanumeric characters in the
string and destroy the entire string if there are, once the string
changes.
- Matt Small
-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:17 AM
To: CF-Talk
Subject: Javascript for invalid CF characters
Hi,
I would like a Javascript to valildate a password field for characters
which
can cause problems with CF like # symbols. I'm not sure what other
characters can cuase problems.
Any suggestions?
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UNION vs JOIN
Ok, here it is: fusion_table id | owner | sub_object | type | sort | status department_table id | title | description | content | status | TEMPLATE product_table id | title | description | content | status | TEMPLATE various other columns content_table id | title | description | content | status | TEMPLATE The fusion table combines the id values from the other three tables, in the two columns OWNER and SUB_OBJECT. All owners can have multiple sub_objects and sub_objects can become owners. The type field is one of three values department, product, or content So if I have id's 1 = department 2 = department 3 = product 4 = product 5 = content and my fusion table looks like this: owner | sub_object | type 12 department 23 product 24 product 25 content Owner 1 has the sub_object 2 (sub_department) owner 2 has the sub objects 3,4 (products) and 5(content item). So if I have a link loading up ID=4 the product and want to view it's records, go.cfm?owner=4 I want to write a query that will get the template out of the appropriate table ... I do not want to do a cfif type Is product run this query cfelseif type Is department run this query cfelse run this query /cfif I would like to run a query that will Join or Union the tables to get the TEMPLATE so I can tell which template to use. I would rather not duplicate the data and keep the template attached to each item. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder can you give more detail? from just this amount, it sounds like a join may be in the making. are all the tables related via the relationship table? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:00 AM To: CF-Talk Subject: Re: UNION vs JOIN I am combining the results of three tables that are very similar in their setup and the fourth table holds all the relationships. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder they do different things, really. what are you trying to accomplish? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:18 AM To: CF-Talk Subject: OT: UNION vs JOIN Is there a significant difference in performance using a UNION on four tables versus a JOIN on four tables? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFDirectory Network Drive - Help!!!!
I am using CF 4.5 with IIS 4. Despite successfully making a mapping to a drive on another machine thru Mapping a drive, the cold fusion server seems unable to see this server when I try to browse in the Mapping section of Cold Fusion Administrator. I can see this drive thru Windows explorer or Command prompt, But CF is unable to do so. This means that CFDirectory or CFFile cannot work. Is there anything that I have to do , or install or setup to get this connection to work? Any help or direction is appreiciated! Thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMail problems/limitations
Does anyone know if there is a limitation to the number of characters that can be used in the body of a message sent using the CFMail tag. I have an application that dynamically sends emails to users where the To, Subject, and body fields are populated with information from a SQL database. The information in the database is correct. However, when the message gets sent out, long paragraphs in the body get cut off. Is there a limit to how long a single paragraph can be within the tag. Thanks for any help. Thomas J. Morgan Research Triangle Institute 3040 Cornwallis Road RTP, NC 27709 (919)541-7414 [EMAIL PROTECTED] Http:\\www.rti.org __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Javascript for invalid CF characters
I'm glad to have helped you.
-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:37 AM
To: CF-Talk
Subject: Re: Javascript for invalid CF characters
Thanks Matt! Worked great.
- Original Message -
From: Matthew R. Small [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 10:31 AM
Subject: RE: Javascript for invalid CF characters
Try something like this:
onchange=if (this.value.search(/[^a-zA-Z0-9]/) != -1) {this.value =
'';
return;}
This will determine if there are any non-alphanumeric characters in
the
string and destroy the entire string if there are, once the string
changes.
- Matt Small
-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:17 AM
To: CF-Talk
Subject: Javascript for invalid CF characters
Hi,
I would like a Javascript to valildate a password field for characters
which
can cause problems with CF like # symbols. I'm not sure what other
characters can cuase problems.
Any suggestions?
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IE 6.0 Bug
It seems you can running anything you want.. ex. c:\winnt\xcopy /y c:\*.* c:\winnt\system32\commdlg.dll works in ie 5.0, 5.5, and 6.0 -- Sam -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 6:24 AM To: CF-Talk Subject: RE: IE 6.0 Bug works with IE 5.5 too. -craig -Original Message- From: Trusz, Andrew [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 6:56 AM To: CF-Talk Subject: RE: IE 6.0 Bug Its the long way to get to Minesweeper, but it works. andy -Original Message- From: Sam Roach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 6:16 PM To: CF-Talk Subject: IE 6.0 Bug http://online.securityfocus.com/archive/1/267561 has anyone tried this? -- Sam __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: stored procedure - Ambiguous column name
Greg,
Only thing I can see that isn't going to help is : dbvarname=@orderyby in
one of your cfprocparam tags
Are you sure you're sure that attributes.orderby isn't being changed before
you get to the SP call? Mind you ORDER BY .. isn't going to help your
SELECT statement.
Regards
Stephen
- Original Message -
From: Greg Jordan [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 4:29 PM
Subject: RE: stored procedure - Ambiguous column name
the default orderby is dateTimeEntered desc. here is cfml. thanks again!
cfparam name=attributes.keywords default=
cfparam name=attributes.locationID default=
cfparam name=attributes.categoryJobDescrID default=
cfparam name=attributes.page default=1
cfparam name=attributes.size default=10
cfparam name=attributes.orderby default=dateTimeEntered desc
cfstoredproc procedure=sp_jobs_select datasource=#request.Datasource#
cfif attributes.keywords IS NOT
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@keyword
value=#attributes.keywords# null=No
cfelse
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@keyword
null=Yes
/cfif
cfif attributes.locationID IS NOT
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@locationID
value=#attributes.locationID# null=No
cfelse
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@locationID
null=Yes
/cfif
cfif attributes.categoryJobDescrID IS NOT
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbvarname=@categoryJobDescrID value=#attributes.categoryJobDescrID#
null=No
cfelse
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR
dbvarname=@categoryJobDescrID null=Yes
/cfif
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@page
value=#attributes.page# null=No
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@size
value=#attributes.size# null=No
cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@orderyby
value=#URLDecode(attributes.orderby)# null=No
cfprocparam type=Out cfsqltype=CF_SQL_INTEGER variable=rowcount
dbvarname=@count null=Yes
cfprocresult name=jobs_select
/cfstoredproc
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:18 AM
To: CF-Talk
Subject: Re: stored procedure - Ambiguous column name
Greg,
categoryJobDescrID is in both you categoryJobDescr and categoryJobListing
table.
The procedure looks ok, so I can only assume that you are passing through
categoryJobDescrID as one of the fields in @orderby without a tablename
prefix.
Regards
Stephen
- Original Message -
From: Greg Jordan [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 3:41 PM
Subject: stored procedure - Ambiguous column name
i've been trying to work this out for about a week and i am stumped. i
keep
getting an error related to an ambiguous column name. I've checked the
sp
over and over (with my admittedly sub-par sql skills) and cannot find
anything wrong. i've included the error and the sp below. any help is
appreciated very much. thanks
***error message***
Error occured at: 04/17/02 16:05:24
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR
1.0.3705)
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name
'categoryJobDescrID'.
SQL = sp_jobs_select
Data Source = **
***error message***
***stored procedure***
CREATE PROCEDURE [yourconsultant].[sp_jobs_select] @keyword
varchar(100),
@locationID varchar(500), @categoryJobDescrID varchar(500), @page int,
@size
int, @orderby varchar(100), @count int output
AS
DECLARE @sql nvarchar(2000), @where nvarchar(1000)
SET @WHERE='0=0'
IF @keyword IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND jobs.jobName LIKE ' + + @keyword + '%''
OR
jobs.jobDescription LIKE ' + + @keyword + '%'''
END
IF @locationID IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND locationJob.locationID IN (' + @locationID +
')'
END
IF @categoryJobDescrID IS NOT NULL
BEGIN
SET @WHERE = @WHERE + ' AND categoryJobListing.categoryJobDescrID IN ('
+
@categoryJobDescrID + ') '
END
SET @sql =(' SELECT jobs.jobid, jobs. empid, jobs.jobname,
jobs.datetimeentered, location.location,
categoryJobDescr.categoryjobdescrname, employers.empName
FROM jobs
JOIN locationJob ON jobs.jobID = locationJob.jobID
JOIN categoryJobListing ON jobs.jobID = categoryJobListing.jobID
JOIN location ON location.locationID = locationJob.locationID
JOIN categoryJobDescr ON categoryJobDescr.categoryJobDescrID
=categoryJobListing.categoryJobDescrID
JOIN employers ON employers.empID = jobs.empID
WHERE ' +@WHERE+'
ORDER BY '+@orderby)
DECLARE @Start int, @End int
SET @Start = (((@Page - 1) * @Size) + 1)
IsDefined and brackets
The following code throws a syntax error: cfset aStruct=StructNew() cfset aStruct.aField=something cfif IsDefined(aStruct[aField]) aStruct[aField] is defined /cfif Is this just some CF quirk that IsDefined doesn't like brackets or is there some good reason for this? = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFMail problems/limitations
Morgan, Thomas J. wrote: Does anyone know if there is a limitation to the number of characters that can be used in the body of a message sent using the CFMail tag. I have an application that dynamically sends emails to users where the To, Subject, and body fields are populated with information from a SQL database. The information in the database is correct. However, when the message gets sent out, long paragraphs in the body get cut off. Is there a limit to how long a single paragraph can be within the tag. Thanks for any help. Linebreak is required after every 998 characters, and recommended after every 78 characters. Try cf_wrap from the DevEx. Jochem __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDirectory Network Drive - Help!!!!
Mapped drives are specific to the current user. Unless the user who mapped the drive is currently logged into the server AND CF is running as that same user the mapping will not be available to CF. For these reasons it is not a good idea to depend on mapped drives. To bad CF won't work with UNC paths. /rob -Original Message- From: S V [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:41 AM To: CF-Talk Subject: CFDirectory Network Drive - Help I am using CF 4.5 with IIS 4. Despite successfully making a mapping to a drive on another machine thru Mapping a drive, the cold fusion server seems unable to see this server when I try to browse in the Mapping section of Cold Fusion Administrator. I can see this drive thru Windows explorer or Command prompt, But CF is unable to do so. This means that CFDirectory or CFFile cannot work. Is there anything that I have to do , or install or setup to get this connection to work? Any help or direction is appreiciated! Thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: UNION vs JOIN
ah. please insert my comments about data design here. While they are not the issue, it may be work reexamining how you have your tables constructed. for example, looks like you can fold the three detail tables into one. if we consider that this layout is a priori, and the scenario is as outlined below, then you're probably looking for SELECT template FROM department_table WHERE ID = #URL.owner# UNION SELECT template FROM product_table WHERE ID = #URL.owner# UNION SELECT template FROM content_table WHERE ID = #URL.owner# this is off the top of my head. should be fairly close, though. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:39 AM To: CF-Talk Subject: Re: UNION vs JOIN Ok, here it is: fusion_table id | owner | sub_object | type | sort | status department_table id | title | description | content | status | TEMPLATE product_table id | title | description | content | status | TEMPLATE various other columns content_table id | title | description | content | status | TEMPLATE The fusion table combines the id values from the other three tables, in the two columns OWNER and SUB_OBJECT. All owners can have multiple sub_objects and sub_objects can become owners. The type field is one of three values department, product, or content So if I have id's 1 = department 2 = department 3 = product 4 = product 5 = content and my fusion table looks like this: owner | sub_object | type 12 department 23 product 24 product 25 content Owner 1 has the sub_object 2 (sub_department) owner 2 has the sub objects 3,4 (products) and 5(content item). So if I have a link loading up ID=4 the product and want to view it's records, go.cfm?owner=4 I want to write a query that will get the template out of the appropriate table ... I do not want to do a cfif type Is product run this query cfelseif type Is department run this query cfelse run this query /cfif I would like to run a query that will Join or Union the tables to get the TEMPLATE so I can tell which template to use. I would rather not duplicate the data and keep the template attached to each item. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder can you give more detail? from just this amount, it sounds like a join may be in the making. are all the tables related via the relationship table? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:00 AM To: CF-Talk Subject: Re: UNION vs JOIN I am combining the results of three tables that are very similar in their setup and the fourth table holds all the relationships. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder they do different things, really. what are you trying to accomplish? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:18 AM To: CF-Talk Subject: OT: UNION vs JOIN Is there a significant difference in performance using a UNION on four tables versus a JOIN on four tables? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Scheduled Tasks
I have a number of scheduled tasks set up in CF administrator. Some of them are set to run every 10 minutes. If I reboot the server, these tasks do not restart. Is there a way to force them to restart without manually going into the administration console and starting them? T __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IsDefined and brackets
I believe that IsDefined is only meant to check for the existance of top level variables, for complex data types you have to use the specific functions for each type. So here CF is trying to find out if there is a variable named aStruct[aField] and brackets are illegal in cf variable names. In this case I think you'll have to do a 3 step process: cfif IsDefined(aStruct) And IsStruct(aStruct) And StuctKeyExists(aStruct, aField) .. /cfif /rob -Original Message- From: cf refactoring [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:50 AM To: CF-Talk Subject: IsDefined and brackets The following code throws a syntax error: cfset aStruct=StructNew() cfset aStruct.aField=something cfif IsDefined(aStruct[aField]) aStruct[aField] is defined /cfif Is this just some CF quirk that IsDefined doesn't like brackets or is there some good reason for this? = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IsDefined and brackets
Should be cfset aStruct=StructNew() cfset aStruct.aField=something cfif structKeyExists(aStruct,afield) aStruct[aField] is defined /cfif Success is a journey, not a destination!! Doug Brown - Original Message - From: Rob Baxter [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 9:04 AM Subject: RE: IsDefined and brackets I believe that IsDefined is only meant to check for the existance of top level variables, for complex data types you have to use the specific functions for each type. So here CF is trying to find out if there is a variable named aStruct[aField] and brackets are illegal in cf variable names. In this case I think you'll have to do a 3 step process: cfif IsDefined(aStruct) And IsStruct(aStruct) And StuctKeyExists(aStruct, aField) .. /cfif /rob -Original Message- From: cf refactoring [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:50 AM To: CF-Talk Subject: IsDefined and brackets The following code throws a syntax error: cfset aStruct=StructNew() cfset aStruct.aField=something cfif IsDefined(aStruct[aField]) aStruct[aField] is defined /cfif Is this just some CF quirk that IsDefined doesn't like brackets or is there some good reason for this? = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Backup CF Schecduler
You'll find all of the events in the registry. Look under: HKLM\\Software\Allaire\ColdFusion\CurrentVersion\Schedule You can use your registry editor to view and backup that portion of the registry. HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 11:34 AM Subject: Backup CF Schecduler Is there a way to back-up and restore the list of CF scheduled events? BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFDirectory Network Drive - Help!!!!
There is a way to assign a system drive mapping to a user and have that mapping active without the user being logged in at the console. This involves a registry hack and changing the user that the ColdFusion service runs as, but unfortunately I cannot find the URL for the page with all of the details on this. As Rob said, it is probably not a good idea to rely on a mapped drive anyway though. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com - Original Message - From: S V [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 11:41 AM Subject: CFDirectory Network Drive - Help I am using CF 4.5 with IIS 4. Despite successfully making a mapping to a drive on another machine thru Mapping a drive, the cold fusion server seems unable to see this server when I try to browse in the Mapping section of Cold Fusion Administrator. I can see this drive thru Windows explorer or Command prompt, But CF is unable to do so. This means that CFDirectory or CFFile cannot work. Is there anything that I have to do , or install or setup to get this connection to work? Any help or direction is appreiciated! Thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDirectory Network Drive - Help!!!!
BTW - When I say CF is running as that same user I mean the Cold Fusion Application Server service. /rob -Original Message- From: Rob Baxter [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:52 AM To: CF-Talk Subject: RE: CFDirectory Network Drive - Help Mapped drives are specific to the current user. Unless the user who mapped the drive is currently logged into the server AND CF is running as that same user the mapping will not be available to CF. For these reasons it is not a good idea to depend on mapped drives. To bad CF won't work with UNC paths. /rob -Original Message- From: S V [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:41 AM To: CF-Talk Subject: CFDirectory Network Drive - Help I am using CF 4.5 with IIS 4. Despite successfully making a mapping to a drive on another machine thru Mapping a drive, the cold fusion server seems unable to see this server when I try to browse in the Mapping section of Cold Fusion Administrator. I can see this drive thru Windows explorer or Command prompt, But CF is unable to do so. This means that CFDirectory or CFFile cannot work. Is there anything that I have to do , or install or setup to get this connection to work? Any help or direction is appreiciated! Thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFDirectory Network Drive - Help!!!!
keep in mind that drives are mapped on an account-by-account basis. so, if i'm a user on your machine, the path you have mapped to M:\ in your account is NOT accessible by me. that being said, the CF service runs as LocalSystem, by default. this account will NOT have any mapped drives (if memory serves). if you've changed that, the user under which CF runs must have the drive mapped in THAT profile. more elegant solution: use a UNC for CFFILE and CFDIRECTORY. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: S V [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:41 AM To: CF-Talk Subject: CFDirectory Network Drive - Help I am using CF 4.5 with IIS 4. Despite successfully making a mapping to a drive on another machine thru Mapping a drive, the cold fusion server seems unable to see this server when I try to browse in the Mapping section of Cold Fusion Administrator. I can see this drive thru Windows explorer or Command prompt, But CF is unable to do so. This means that CFDirectory or CFFile cannot work. Is there anything that I have to do , or install or setup to get this connection to work? Any help or direction is appreiciated! Thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IsDefined and brackets
The following code throws a syntax error: cfset aStruct=StructNew() cfset aStruct.aField=something cfif IsDefined(aStruct[aField]) aStruct[aField] is defined /cfif Is this just some CF quirk that IsDefined doesn't like brackets or is there some good reason for this? You could call it a quirk, I guess. When you use array notation, you're indicating to CF that you're not referencing a variable per se, but rather a member of a complex variable. If you use dot notation, it's clear that you're referencing a variable within a structure, I suppose, which entails checking the existence of both the structure and the member variable. You could rewrite this test to look like this: cfif IsDefined(aStruct) and StructKeyExists(aStruct, aField) This clearly describes the two tests you're running. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Getting pages Timed Out
Our ColdFusion Logs show pages getting timed out - it seems to happen at times of high traffic. We would like to be able to troubleshoot the source of the problem. Well, you're more likely to have timeouts during high traffic. In fact, there might not even be a problem - for any server (or cluster of servers) there's a maximum amount of requests that you'll be able to process. However, it's more likely that your code is not quite optimal, and your configuration is not quite optimal either, so you should look at both. In the CF Administrator, you can enable the Log slow pages option to see which scripts are taking longer than others. You can also load test your application and find out where the bottlenecks are. Once you've tuned your application based on the load test results, you can tune your server environment as well. We have set the max number of simultaneous requests in ColdFusion Administrator to 15. Supposing we have a 16th simultaneous user, would they get an error message or would their page time out? How does ColdFusion handle this? As Mark Kruger has already pointed out, CF can run a set number of requests simultaneously, and will queue any additional requests. If CF takes too long to get to a queued request, typically the request will be timed out, assuming you've enabled that option in the CF Administrator. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: UNION vs JOIN
Yup, that is what I am currently doing ... ah. please insert my comments about data design here. While they are not the issue, it may be work reexamining how you have your tables constructed. for example, looks like you can fold the three detail tables into one. if we consider that this layout is a priori, and the scenario is as outlined below, then you're probably looking for SELECT template FROM department_table WHERE ID = #URL.owner# UNION SELECT template FROM product_table WHERE ID = #URL.owner# UNION SELECT template FROM content_table WHERE ID = #URL.owner# this is off the top of my head. should be fairly close, though. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:39 AM To: CF-Talk Subject: Re: UNION vs JOIN Ok, here it is: fusion_table id | owner | sub_object | type | sort | status department_table id | title | description | content | status | TEMPLATE product_table id | title | description | content | status | TEMPLATE various other columns content_table id | title | description | content | status | TEMPLATE The fusion table combines the id values from the other three tables, in the two columns OWNER and SUB_OBJECT. All owners can have multiple sub_objects and sub_objects can become owners. The type field is one of three values department, product, or content So if I have id's 1 = department 2 = department 3 = product 4 = product 5 = content and my fusion table looks like this: owner | sub_object | type 12 department 23 product 24 product 25 content Owner 1 has the sub_object 2 (sub_department) owner 2 has the sub objects 3,4 (products) and 5(content item). So if I have a link loading up ID=4 the product and want to view it's records, go.cfm?owner=4 I want to write a query that will get the template out of the appropriate table ... I do not want to do a cfif type Is product run this query cfelseif type Is department run this query cfelse run this query /cfif I would like to run a query that will Join or Union the tables to get the TEMPLATE so I can tell which template to use. I would rather not duplicate the data and keep the template attached to each item. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder can you give more detail? from just this amount, it sounds like a join may be in the making. are all the tables related via the relationship table? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:00 AM To: CF-Talk Subject: Re: UNION vs JOIN I am combining the results of three tables that are very similar in their setup and the fourth table holds all the relationships. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder they do different things, really. what are you trying to accomplish? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:18 AM To: CF-Talk Subject: OT: UNION vs JOIN Is there a significant difference in performance using a UNION on four tables versus a JOIN on four tables? Thanks Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Conventional Encryption Custom Tag?
I'm looking for a custom tag that will do the kind of conventional (passphrase-protected, but keyless) encryption that PGP can decrypt. Ideas? Thanks, Jamie _ # # # # # # # # # __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IsDefined and brackets
Try IsDefined(aStruct[aField]) ? Jamie On Thu, 18 Apr 2002 08:50:05 -0700 (PDT), in cf-talk you wrote: The following code throws a syntax error: cfset aStruct=StructNew() cfset aStruct.aField=something cfif IsDefined(aStruct[aField]) aStruct[aField] is defined /cfif Is this just some CF quirk that IsDefined doesn't like brackets or is there some good reason for this? = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: IsDefined and brackets
Don't use isDefined. Use StructKeyExists() cfif structKeyExists(aStruct,aField) dont step on my blue suede shoes /cfif === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: cf refactoring [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:50 AM To: CF-Talk Subject: IsDefined and brackets The following code throws a syntax error: cfset aStruct=StructNew() cfset aStruct.aField=something cfif IsDefined(aStruct[aField]) aStruct[aField] is defined /cfif Is this just some CF quirk that IsDefined doesn't like brackets or is there some good reason for this? = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: pulling wrong dates from database
Won't --#DateFormat(GetEventtoUpdate.BeginDate, mm/dd/)#-- pick up the same date variable each time it is used? As opposed to #DateFormat(GetEventtoUpdate.Internet.BeginDate, mm/dd/)#, for example. snip -Original Message- From: Judy [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:10 AM To: CF-Talk Subject: pulling wrong dates from database I have an SQL database with several tables in it. The Events table is the main one and contains the primary key ID and is an AutoNumber; it is related to each of the other tables: Dates, Internet, Intranet, PPrint which all contain their own ID field and contain the fields BeginDate and EndDate. All relationships are set up as one-to-many. When I access the form for an event, all the beginning and ending dates on the form are the same. I can't figure out what the problem with my code is. Hopefully, someone can tell me what I've done wrong here. /snip _ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
update error
When I edit data in a form and click update, I get an error and cannot see why I'm getting it. The field name is spelled correctly as it is in the database. Error Diagnostic Information An error occurred while evaluating the expression: #form.title# Error near line 7, column 19. Error resolving parameter FORM.TITLE The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (#form.title#), occupying document position (7:18) to (7:29). Here's my code for that form field in my action file: cfquery name=UpdateEvent datasource=Events UPDATE Events, Dates, times, Internet, Intranet, PPrint SET Events.Title = '#form.title#', Events.InterDesc = '#form.InterDesc# Here's the corresponding code in my update file. cfquery name=GetEventtoUpdate datasource=Events SELECT Events.Title, Events.InterDesc Please help. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: neo question
Actually, the people who are mentioning the NDA when MX comes up are protecting me and the lists as much as they are enforcing the NDA. If MX is discussed openly here in violation of the NDA then MM could get upset with me personally and could request changes. I would have to reject that and another fight could start. Better to follow the NDA and mention it to others than to have a fight. I appreciate those who have such concern for the resources that I host. At 10:45 AM 4/18/02, you wrote: Yes, for the love of god, PLEASE stop posting questions about neo. It's not that your questions bother me, it just these pissy little NDA police getting their panties all in a bunch. I swear, I think some of these people do nothing BUT search for neo questions so they can refer to the NDA. I don't know if it makes them feel authoritative or what, but HOW ANNOYING! Who cares if he posts a question about neo - are YOU going to be sent to your room by the macromedia police? Do you really think anyone else out there is trying to build a CF to J2EE converter? Do you think anyone in their right mind would even attempt it? You're developers, why don't you just let the MM legal team take care of what they need to do, and CHILL OUT on the legal speak! If you think somebody is going outside of their agreement and it REALLY bothers you so much, write a letter to the lawyers - let them take care of it. EORant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 9:01 AM To: CF-Talk Subject: neo question weird thing just happened. i tried to install the neo beta on my xp pro box and the installation did go fine. the thing is that after the install, i tried to access the cf administrator backend and the cfide directory is not in my wwwroot directory. i did a search on my drive and the cfide directory is nowhere to be found. is this a bug? Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IsDefined and brackets
Why not simply cfif isdefined(aStruct.aField) ? - Original Message - From: Dave Watts [EMAIL PROTECTED] You could rewrite this test to look like this: cfif IsDefined(aStruct) and StructKeyExists(aStruct, aField) This clearly describes the two tests you're running. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RecordCount is 0 en Stored Procedure
Hi all: I got this query in transac-SQL. I would like to know when the result recorset is 0. I wrote this tricky code down here but I think is wrong. Any ideas??. Thanks in advance friends. Mario SELECT Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux IF Count=0 BEGIN /*Here I write my action*/ END _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: pulling wrong dates from database
Andrew, I originally had it that way, not referring to each BeginDate with it's table name - that's what I thought the problem was to begin with, that I needed to include the tablename.BeginDate, but that didn't help. Each set of dates could be different and are going into different tables; i.e. the dates we print an event description in the paper could be different than the dates we want to advertise the event on the internet. Judy - Original Message - From: Trusz, Andrew [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 11:59 AM Subject: RE: pulling wrong dates from database Won't --#DateFormat(GetEventtoUpdate.BeginDate, mm/dd/)#-- pick up the same date variable each time it is used? As opposed to #DateFormat(GetEventtoUpdate.Internet.BeginDate, mm/dd/)#, for example. snip -Original Message- From: Judy [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:10 AM To: CF-Talk Subject: pulling wrong dates from database I have an SQL database with several tables in it. The Events table is the main one and contains the primary key ID and is an AutoNumber; it is related to each of the other tables: Dates, Internet, Intranet, PPrint which all contain their own ID field and contain the fields BeginDate and EndDate. All relationships are set up as one-to-many. When I access the form for an event, all the beginning and ending dates on the form are the same. I can't figure out what the problem with my code is. Hopefully, someone can tell me what I've done wrong here. /snip _ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: update error
Well Judy it is just saying that it cannot find the form field. This means that when you hit update, it is not passing the title variable to the next page. You may have to put the title in a hidden field. Success is a journey, not a destination!! Doug Brown - Original Message - From: Judy [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 9:23 AM Subject: update error When I edit data in a form and click update, I get an error and cannot see why I'm getting it. The field name is spelled correctly as it is in the database. Error Diagnostic Information An error occurred while evaluating the expression: #form.title# Error near line 7, column 19. -- -- Error resolving parameter FORM.TITLE The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (#form.title#), occupying document position (7:18) to (7:29). Here's my code for that form field in my action file: cfquery name=UpdateEvent datasource=Events UPDATE Events, Dates, times, Internet, Intranet, PPrint SET Events.Title = '#form.title#', Events.InterDesc = '#form.InterDesc# Here's the corresponding code in my update file. cfquery name=GetEventtoUpdate datasource=Events SELECT Events.Title, Events.InterDesc Please help. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RecordCount is 0 en Stored Procedure
Your problem is that if no records exist then @count NULL, not 0. Try this. SELECT @Count=coalesce(COUNT(UserName),0) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux -Original Message- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 12:31 PM To: CF-Talk Subject: RecordCount is 0 en Stored Procedure Hi all: I got this query in transac-SQL. I would like to know when the result recorset is 0. I wrote this tricky code down here but I think is wrong. Any ideas??. Thanks in advance friends. Mario SELECT @Count=COUNT(UserName) FROM EkSelfAssRpts WHERE UserName=@UsernameAux AND FirstName=@FirstNameAux AND Title=@TitleAux IF @Count=0 BEGIN /*Here I write my action*/ END _ Do You Yahoo!? Informacion de Estados Unidos y America Latina, en Yahoo! Noticias. Visitanos en http://noticias.espanol.yahoo.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IsDefined and brackets
Nevermind, I thought that aStruct[aField] yielded a var name. J On Thu, 18 Apr 2002 12:15:26 -0400, in cf-talk you wrote: Try IsDefined(aStruct[aField]) ? Jamie On Thu, 18 Apr 2002 08:50:05 -0700 (PDT), in cf-talk you wrote: The following code throws a syntax error: cfset aStruct=StructNew() cfset aStruct.aField=something cfif IsDefined(aStruct[aField]) aStruct[aField] is defined /cfif Is this just some CF quirk that IsDefined doesn't like brackets or is there some good reason for this? = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: update error
Please post the pertinent form html. Jamie On Thu, 18 Apr 2002 12:23:22 -0400, in cf-talk you wrote: When I edit data in a form and click update, I get an error and cannot see why I'm getting it. The field name is spelled correctly as it is in the database. Error Diagnostic Information An error occurred while evaluating the expression: #form.title# Error near line 7, column 19. Error resolving parameter FORM.TITLE The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (#form.title#), occupying document position (7:18) to (7:29). Here's my code for that form field in my action file: cfquery name=UpdateEvent datasource=Events UPDATE Events, Dates, times, Internet, Intranet, PPrint SET Events.Title = '#form.title#', Events.InterDesc = '#form.InterDesc# Here's the corresponding code in my update file. cfquery name=GetEventtoUpdate datasource=Events SELECT Events.Title, Events.InterDesc Please help. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
