RE: CF Mail Problem..
Thats how CFMAIL is supposed to work when you pass a query to it. What you should do is use a CFLOOP query=queryname inside your CFMAIL content section to output the data you need in the table. bye! --- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 1 October 2002 2:51 PM To: CF-Talk Subject: CF Mail Problem.. Hello Forum, Need Help. I am trying to send data generated by a query using CFMAIL tag to a recepient whose email is obtained from a Form. However Instead of including and sending only one email containing all the rows returned by the query to the email address obtained from the Form in the previous page CFMAIL is sending multiple emails to the same email address --one email for each record generate from the query. Thus each email contains only one seperate record. I cant understand why? The recepient email address comes from the Form. The contents of the email is generated by the db query. Any help will be much appreciated. This is my code: CFQUERY name= Get_Products DataSource=XYZ Select * FROM Products WHERE product id=#Form.productid# /CFQUERY cfmail query=Get_Products to=#Form.Email_Address# from=myemail.com subject=Product type=HTML !--- The variables #productid# and #Email_Address# come from the Previous Page (Form.cfm). Table TR TD Productid: Get_Products.productid BR /TD TDDetails: Get_Products.details BR /TD TDModel : Get_Products.modelno BR /TD /TR /Table /cfmail The purpose is to send more details about the product selected by the user in the Form.cfm Page. Thanks Srimanta - Original Message - From: jon hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 4:13 PM Subject: Re: Using Java nulls in CF? For anyone wondering...with smaller files it really doesn't matter, but with a 2.3MB IIS logfile, the Java ReadLine method is about 30-40 percent faster than the old standby looping over the file as a string using chr(10) as a delimiter. -- jon mailto:[EMAIL PROTECTED] Monday, September 30, 2002, 11:43:44 PM, you wrote: jh Actually I didn't even think of using isDefined(), and I think jh you answered my question without knowing it :). jh All I really wanted to do was use java's readLine() method, but jh readLine returns a null when the last line has been read. So I stuck jh isDefined() in there an voila! It worked. jh cfscript jh fr = createObject(java, java.io.FileReader); jh br = createObject(java, java.io.BufferedReader); jh fr.init(filename); jh br.init(fr); jh line = br.readLine(); jh while (isDefined(line)) { jh writeOutput(line 'br'); jh line = br.readLine(); jh } jh fr.close(); jh br.close(); jh /cfscript jh Now I'm going to see if this is any faster than looping over line jh breaks in a string. I hope so after all I tried to get this to work :) __ 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: SQL Text question from a beginner
I took a look on msdn and books online and haven't been able to make much sense of the situation. It appears that one can't define their own data type and accessing this data is less than intuitive. Anyone out there figured out a way to retrieve a couple of pages of data from ms sql? Or accomplish the insertion of dynamic text via some other means? Thanks, John -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:38 PM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ 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: SQL Text question from a beginner
The TEXT datatype should be as easy to use as the VARCHAR datatype you were using earlier... simply change the type of the field to TEXT and suddenly it will hold as much text as you want. --- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 1 October 2002 4:33 PM To: CF-Talk Subject: RE: SQL Text question from a beginner I took a look on msdn and books online and haven't been able to make much sense of the situation. It appears that one can't define their own data type and accessing this data is less than intuitive. Anyone out there figured out a way to retrieve a couple of pages of data from ms sql? Or accomplish the insertion of dynamic text via some other means? Thanks, John -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:38 PM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ 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: CF Mail Problem..
Hi Sabir Many Thanks Mate.. It Works S.. - Original Message - From: Ryan Sabir [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 6:25 PM Subject: RE: CF Mail Problem.. Thats how CFMAIL is supposed to work when you pass a query to it. What you should do is use a CFLOOP query=queryname inside your CFMAIL content section to output the data you need in the table. bye! --- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 1 October 2002 2:51 PM To: CF-Talk Subject: CF Mail Problem.. Hello Forum, Need Help. I am trying to send data generated by a query using CFMAIL tag to a recepient whose email is obtained from a Form. However Instead of including and sending only one email containing all the rows returned by the query to the email address obtained from the Form in the previous page CFMAIL is sending multiple emails to the same email address --one email for each record generate from the query. Thus each email contains only one seperate record. I cant understand why? The recepient email address comes from the Form. The contents of the email is generated by the db query. Any help will be much appreciated. This is my code: CFQUERY name= Get_Products DataSource=XYZ Select * FROM Products WHERE product id=#Form.productid# /CFQUERY cfmail query=Get_Products to=#Form.Email_Address# from=myemail.com subject=Product type=HTML !--- The variables #productid# and #Email_Address# come from the Previous Page (Form.cfm). Table TR TD Productid: Get_Products.productid BR /TD TDDetails: Get_Products.details BR /TD TDModel : Get_Products.modelno BR /TD /TR /Table /cfmail The purpose is to send more details about the product selected by the user in the Form.cfm Page. Thanks Srimanta - Original Message - From: jon hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 4:13 PM Subject: Re: Using Java nulls in CF? For anyone wondering...with smaller files it really doesn't matter, but with a 2.3MB IIS logfile, the Java ReadLine method is about 30-40 percent faster than the old standby looping over the file as a string using chr(10) as a delimiter. -- jon mailto:[EMAIL PROTECTED] Monday, September 30, 2002, 11:43:44 PM, you wrote: jh Actually I didn't even think of using isDefined(), and I think jh you answered my question without knowing it :). jh All I really wanted to do was use java's readLine() method, but jh readLine returns a null when the last line has been read. So I stuck jh isDefined() in there an voila! It worked. jh cfscript jh fr = createObject(java, java.io.FileReader); jh br = createObject(java, java.io.BufferedReader); jh fr.init(filename); jh br.init(fr); jh line = br.readLine(); jh while (isDefined(line)) { jh writeOutput(line 'br'); jh line = br.readLine(); jh } jh fr.close(); jh br.close(); jh /cfscript jh Now I'm going to see if this is any faster than looping over line jh breaks in a string. I hope so after all I tried to get this to work :) __ 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 Mail Problem..
Hi Srimanta, try something like... CFQUERY name= Get_Products DataSource=XYZ Select * FROM Products WHERE product id=#Form.productid# /CFQUERY cfmail to=#Form.Email_Address# from=myemail.com subject=Product type=HTML Table cfloop query=Get_Products TR TD Productid: #Get_Products.productid# BR /TD TDDetails: #Get_Products.details# BR /TD TDModel : #Get_Products.modelno# BR /TD /TR /cfloop /Table /cfmail hth joel -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 1 October 2002 2:51 To: CF-Talk Subject: CF Mail Problem.. Hello Forum, Need Help. I am trying to send data generated by a query using CFMAIL tag to a recepient whose email is obtained from a Form. However Instead of including and sending only one email containing all the rows returned by the query to the email address obtained from the Form in the previous page CFMAIL is sending multiple emails to the same email address --one email for each record generate from the query. Thus each email contains only one seperate record. I cant understand why? The recepient email address comes from the Form. The contents of the email is generated by the db query. Any help will be much appreciated. This is my code: CFQUERY name= Get_Products DataSource=XYZ Select * FROM Products WHERE product id=#Form.productid# /CFQUERY cfmail query=Get_Products to=#Form.Email_Address# from=myemail.com subject=Product type=HTML !--- The variables #productid# and #Email_Address# come from the Previous Page (Form.cfm). Table TR TD Productid: Get_Products.productid BR /TD TDDetails: Get_Products.details BR /TD TDModel : Get_Products.modelno BR /TD /TR /Table /cfmail The purpose is to send more details about the product selected by the user in the Form.cfm Page. Thanks Srimanta - Original Message - From: jon hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 4:13 PM Subject: Re: Using Java nulls in CF? For anyone wondering...with smaller files it really doesn't matter, but with a 2.3MB IIS logfile, the Java ReadLine method is about 30-40 percent faster than the old standby looping over the file as a string using chr(10) as a delimiter. -- jon mailto:[EMAIL PROTECTED] Monday, September 30, 2002, 11:43:44 PM, you wrote: jh Actually I didn't even think of using isDefined(), and I think jh you answered my question without knowing it :). jh All I really wanted to do was use java's readLine() method, but jh readLine returns a null when the last line has been read. So I stuck jh isDefined() in there an voila! It worked. jh cfscript jh fr = createObject(java, java.io.FileReader); jh br = createObject(java, java.io.BufferedReader); jh fr.init(filename); jh br.init(fr); jh line = br.readLine(); jh while (isDefined(line)) { jh writeOutput(line 'br'); jh line = br.readLine(); jh } jh fr.close(); jh br.close(); jh /cfscript jh Now I'm going to see if this is any faster than looping over line jh breaks in a string. I hope so after all I tried to get this to work :) __ 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: SQL Text question from a beginner
Don't forget that there are limitations on how much text a user can cut and paste into a textbox or textarea field in a form. I believe that the limitations are browser dependant... around 8K for IE5+ I seem to remember. At 11:47 PM 9/30/02, you wrote: The TEXT datatype should be as easy to use as the VARCHAR datatype you were using earlier... simply change the type of the field to TEXT and suddenly it will hold as much text as you want. --- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 1 October 2002 4:33 PM To: CF-Talk Subject: RE: SQL Text question from a beginner I took a look on msdn and books online and haven't been able to make much sense of the situation. It appears that one can't define their own data type and accessing this data is less than intuitive. Anyone out there figured out a way to retrieve a couple of pages of data from ms sql? Or accomplish the insertion of dynamic text via some other means? Thanks, John -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:38 PM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ 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: SQL Text question from a beginner
Thanks, you are a mind reader! -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:09 AM To: CF-Talk Subject: RE: SQL Text question from a beginner Don't forget that there are limitations on how much text a user can cut and paste into a textbox or textarea field in a form. I believe that the limitations are browser dependant... around 8K for IE5+ I seem to remember. At 11:47 PM 9/30/02, you wrote: The TEXT datatype should be as easy to use as the VARCHAR datatype you were using earlier... simply change the type of the field to TEXT and suddenly it will hold as much text as you want. --- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 1 October 2002 4:33 PM To: CF-Talk Subject: RE: SQL Text question from a beginner I took a look on msdn and books online and haven't been able to make much sense of the situation. It appears that one can't define their own data type and accessing this data is less than intuitive. Anyone out there figured out a way to retrieve a couple of pages of data from ms sql? Or accomplish the insertion of dynamic text via some other means? Thanks, John -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:38 PM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ 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: SQL Text question from a beginner
My understanding of TEXT type fields is that there is only 16 bytes stored in the database, because the rest of the field's contents are stored elsewhere. And the 16 bytes are only a pointer to it. A TEXT field in SQl can hold up to 2,147,483,647 characters and cannot be used as variables or parameters in stored procedures. Not sure of the exact amount, but it's a WHOLE LOT of info. It's like a MEMO field in Access. A VARCHAR field is limited to 255 characters max, but as I understand it, a TEXT field is unlimited for most practical purposes. Other than setting up the table, and some considerations of searching large amounts of data, once you set the fields up, you access TEXT fields just the same way you access VARCHAR fields and there is no difference to how you work with them. But hold disk space allocations in mind, so dont just go and set up a whole bunch of TEXT fields rather than defining lengths in VARCHAR fields - you'll find your disk space gets out of control real fast. (or so I've been led to believe) Cheers Mike Kear AFP Webworks Windsor, NSW, Australia -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:38 PM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ 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
simple way to email my users.
We've been asked to add email alert functionality to a clients web site. The client is a recruitment company and wants to maintain a list of prospective candidates that can be automatically alerted when the company has new job openings. The clients wants to be able to manually add / remove names to the email list and to enable new job seekers to add themselves or modify their settings through their web site. The settings will be quite simple, a new job seeker can specify to receive alerts for 1) Software development jobs 2) Management jobs 3) all jobs When the recruitment company has a new job requirement they will type it up, assign it to a category, and then have an option to send it out to all the prospective job seekers who have requested for alerts in that category. Before the emails are sent out the company wants a list of all the recipients so that they can manually delete or add people from the list before the mailing is kicked off. I realize this is a simple project and there are numerous ways to get this done. What I'm looking are suggestions on how to get this done very quickly ( 2 week time line) I also want to know if there is an existing product we can buy which with some customization can achieve this for us. Would love to receive recommendations, suggestions or even proposals if you have a fast solution. Thanks. __ 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: SQL Text question from a beginner
No... but scanning is second nature to me... ;-) At 12:08 AM 10/1/02, you wrote: Thanks, you are a mind reader! -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:09 AM To: CF-Talk Subject: RE: SQL Text question from a beginner Don't forget that there are limitations on how much text a user can cut and paste into a textbox or textarea field in a form. I believe that the limitations are browser dependant... around 8K for IE5+ I seem to remember. At 11:47 PM 9/30/02, you wrote: The TEXT datatype should be as easy to use as the VARCHAR datatype you were using earlier... simply change the type of the field to TEXT and suddenly it will hold as much text as you want. --- Ryan Sabir Newgency Pty Ltd 2a Broughton St Paddington 2021 Sydney, Australia Ph (02) 9331 2133 Fax (02) 9331 5199 Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 1 October 2002 4:33 PM To: CF-Talk Subject: RE: SQL Text question from a beginner I took a look on msdn and books online and haven't been able to make much sense of the situation. It appears that one can't define their own data type and accessing this data is less than intuitive. Anyone out there figured out a way to retrieve a couple of pages of data from ms sql? Or accomplish the insertion of dynamic text via some other means? Thanks, John -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:38 PM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ 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: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR
This thread is in context with CF. -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 19:27 To: CF-Talk Subject: Re: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR I am seeing a lot of *FLASH* talk on here.. its kinda disturbing... was wondering if Michael can move all the FLASH talk to another discussion Group (CF-TALK-FLASH) or something like that. Joe - Original Message - From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 30, 2002 12:01 PM Subject: RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR OK then, will I get a super discount on Flash from MM - say 98% as I am only going to use 2% of its features? :-) nah, didnt think so.. N -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 16:38 To: CF-Talk Subject: RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR Actually, I think it makes a lot of sense. I just needed a form with side by side list boxes, make a selection in one and the second is populated with selections that change based on what was selected in the first. Try doing that simply and easily in HTML (without screen refreshes). Flash, ColdFusion CFCs, and Flash Remoting make it a no brainer. Did I use animation? Nope. Did I need the timeline? Nope. In fact, I don't even have it open - I used a single frame and a single layer. There is legitimate use for Flash beyond animation. --- Ben -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:57 AM To: CF-Talk Subject: RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR so you are using an animation tool and doing no an animation? I may just be a tad blinkered, but its like using IE to browser text files and not HTML doesnt make sense... -Original Message- From: Mike Chambers [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 15:35 To: CF-Talk Subject: Flash for data views : WAS Ben's J2EE Book, now new course to be offered by MACR -Original Message- From: Robertson-Ravo, Neil (REC) I like Flash, dont get me wrong, but if all you are doing it linking to a DB for a static form or grid etc, then you may as well use HTML and no I am not anti Flash Remoting - far from it, I just dont see the business benefit (development time = cost) of using say Flash for things which could be developed in normal HTML. If all you are doing is presenting data to the user with no interaction, then there is not much advantage to using Flash. However, if the users interacts with that data in any way, then there are advantages. Namely, the fact that the entire page will not need to be refreshed to update the data view (or to submit data, etc). btw, that workflow requires no animation. I have been working with Flash for about 4 years now, and I dont think i have done any animation for about 2 years. All of my Flash applications consists of one Frame which a bunch of components, and data going back and forth from Flash and the server. What I am driving at is this : there is no real 'Spectrum of Participants' (sorry Ray) of how to get a movie up and running. For what its worth, here is my workflow. 1. create functionality of movie using ActionScript and components. 2. send it to a designer to make it look pretty. btw, as far as time and costs, in a lot of cases i think the developing in Flash is easier / faster than in HTML since I don't have to write a bunch of code that maintains client state across page views. mike chambers [EMAIL PROTECTED] __ 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: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR
Igor, I certainly am 'broad' when it comes to Macromedia :p. I am well aware of who works for/with MM and indeed I have spent a great deal of time on all the mentioned application alpha and beta apps and indeed I have seen some cool stuff. But what I am saying it not dont use it but more like search your library for existing code before deciding the Flash option. Its easy to jump on the bandwagon but its even easier to fall off it. FYI : no I dont use IE as my FTP app, I use command prompt, even better! Oh and as for viewing text docs in IE, sure you can do it, but can you edit them? for that I will stick with Notepad. N -Original Message- From: Ilyinsky, Igor [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 21:35 To: CF-Talk Subject: RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR YES, that is a great analogy. Using flash to present data IS like using IE for viewing Text Documents (sorta), but what's wrong with that? Viewing remote txt documents in IE is in no way inferior to notepad; in fact, I think it's better because you don't need to launch another application, and there are so many other things IE can do (as can Flash). Do you use IE for FTP? I think it is the best (and free-est) FTP Client I have ever used! What about IE for local folder browsing; or other web protocols? Like Flash, IE can be used for many things (and many out of the scope of what it is famous for). Neil, I think you need to broaden your thinking and see the big picture. These people are not just praising Flash because they work for Macromedia (although 3 of them do), but because of all of its powers. Flash will not redefine the possibilities of what can be done on the web; It will simply provide you a with the toolset to do it faster, cheaper, cleaner, and (most importantly) you will only need to do it ONCE for each release. IGOR ILYINSKY CREDIT|FIRST SUISSE|BOSTON GLOBAL WEB SERVICES -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:57 AM To: CF-Talk Subject: RE: Flash for data views : WAS Ben's J2EE Book, now new course t o be offered by MACR so you are using an animation tool and doing no an animation? I may just be a tad blinkered, but its like using IE to browser text files and not HTML doesnt make sense... -Original Message- From: Mike Chambers [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 15:35 To: CF-Talk Subject: Flash for data views : WAS Ben's J2EE Book, now new course to be offered by MACR -Original Message- From: Robertson-Ravo, Neil (REC) I like Flash, dont get me wrong, but if all you are doing it linking to a DB for a static form or grid etc, then you may as well use HTML and no I am not anti Flash Remoting - far from it, I just dont see the business benefit (development time = cost) of using say Flash for things which could be developed in normal HTML. If all you are doing is presenting data to the user with no interaction, then there is not much advantage to using Flash. However, if the users interacts with that data in any way, then there are advantages. Namely, the fact that the entire page will not need to be refreshed to update the data view (or to submit data, etc). btw, that workflow requires no animation. I have been working with Flash for about 4 years now, and I dont think i have done any animation for about 2 years. All of my Flash applications consists of one Frame which a bunch of components, and data going back and forth from Flash and the server. What I am driving at is this : there is no real 'Spectrum of Participants' (sorry Ray) of how to get a movie up and running. For what its worth, here is my workflow. 1. create functionality of movie using ActionScript and components. 2. send it to a designer to make it look pretty. btw, as far as time and costs, in a lot of cases i think the developing in Flash is easier / faster than in HTML since I don't have to write a bunch of code that maintains client state across page views. mike chambers [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
SOT: Virus Checking
Does anyone know of or use a tag that virus checks files that are uploaded?? Regards, Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. -Original Message- From: John Innit [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 09:01 To: CF-Talk Subject: simple way to email my users. We've been asked to add email alert functionality to a clients web site. The client is a recruitment company and wants to maintain a list of prospective candidates that can be automatically alerted when the company has new job openings. The clients wants to be able to manually add / remove names to the email list and to enable new job seekers to add themselves or modify their settings through their web site. The settings will be quite simple, a new job seeker can specify to receive alerts for 1) Software development jobs 2) Management jobs 3) all jobs When the recruitment company has a new job requirement they will type it up, assign it to a category, and then have an option to send it out to all the prospective job seekers who have requested for alerts in that category. Before the emails are sent out the company wants a list of all the recipients so that they can manually delete or add people from the list before the mailing is kicked off. I realize this is a simple project and there are numerous ways to get this done. What I'm looking are suggestions on how to get this done very quickly ( 2 week time line) I also want to know if there is an existing product we can buy which with some customization can achieve this for us. Would love to receive recommendations, suggestions or even proposals if you have a fast solution. Thanks. __ 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: ColdFusion MX service won't start at boot
Thanks for everyone's help on this. The answer came courtesy of Jon Moneymaker. http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=2threa did=455161 In short, don't install CFMX on a virgin box without having altered the Default web site directory in IIS (even if you move it, install CFMX and move it back to C:\Inetpub\wwwroot\ again). -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 __ 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: Browser forgetting form values
CLIENT vars -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 18:02 To: CF-Talk Subject: Browser forgetting form values IE use to remember the values that you would put into a form after submission. It does not do that any more.. or is it the CF MX server? If you enter data into a form and submit it I have a CFTRY/CFCATCH that catches a database error. If you use the browser Back button the data is gone from the form Is there any way to keep the data in the form other then session variables? Thanks __ 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 Mail Problem..
Thanks The code is working. However there is still one problem. The email sent is in html format and includes images within the html tables. How do I ensure that the images are sent to email addresses along with the html tables. At the moment the images are not visible. I am using Outlook express. Any ideas? Thanks again Srimanta - Original Message - From: Joel Nath [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 7:11 PM Subject: RE: CF Mail Problem.. Hi Srimanta, try something like... CFQUERY name= Get_Products DataSource=XYZ Select * FROM Products WHERE product id=#Form.productid# /CFQUERY cfmail to=#Form.Email_Address# from=myemail.com subject=Product type=HTML Table cfloop query=Get_Products TR TD Productid: #Get_Products.productid# BR /TD TDDetails: #Get_Products.details# BR /TD TDModel : #Get_Products.modelno# BR /TD /TR /cfloop /Table /cfmail hth joel -Original Message- From: Srimanta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 1 October 2002 2:51 To: CF-Talk Subject: CF Mail Problem.. Hello Forum, Need Help. I am trying to send data generated by a query using CFMAIL tag to a recepient whose email is obtained from a Form. However Instead of including and sending only one email containing all the rows returned by the query to the email address obtained from the Form in the previous page CFMAIL is sending multiple emails to the same email address --one email for each record generate from the query. Thus each email contains only one seperate record. I cant understand why? The recepient email address comes from the Form. The contents of the email is generated by the db query. Any help will be much appreciated. This is my code: CFQUERY name= Get_Products DataSource=XYZ Select * FROM Products WHERE product id=#Form.productid# /CFQUERY cfmail query=Get_Products to=#Form.Email_Address# from=myemail.com subject=Product type=HTML !--- The variables #productid# and #Email_Address# come from the Previous Page (Form.cfm). Table TR TD Productid: Get_Products.productid BR /TD TDDetails: Get_Products.details BR /TD TDModel : Get_Products.modelno BR /TD /TR /Table /cfmail The purpose is to send more details about the product selected by the user in the Form.cfm Page. Thanks Srimanta - Original Message - From: jon hall [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 4:13 PM Subject: Re: Using Java nulls in CF? For anyone wondering...with smaller files it really doesn't matter, but with a 2.3MB IIS logfile, the Java ReadLine method is about 30-40 percent faster than the old standby looping over the file as a string using chr(10) as a delimiter. -- jon mailto:[EMAIL PROTECTED] Monday, September 30, 2002, 11:43:44 PM, you wrote: jh Actually I didn't even think of using isDefined(), and I think jh you answered my question without knowing it :). jh All I really wanted to do was use java's readLine() method, but jh readLine returns a null when the last line has been read. So I stuck jh isDefined() in there an voila! It worked. jh cfscript jh fr = createObject(java, java.io.FileReader); jh br = createObject(java, java.io.BufferedReader); jh fr.init(filename); jh br.init(fr); jh line = br.readLine(); jh while (isDefined(line)) { jh writeOutput(line 'br'); jh line = br.readLine(); jh } jh fr.close(); jh br.close(); jh /cfscript jh Now I'm going to see if this is any faster than looping over line jh breaks in a string. I hope so after all I tried to get this to work :) __ 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
Cross posting: CF5 eval???
Hi, Looking for an evaluation version of CF5 but all I can find on the macromedia web site is the eval version of MX. Anyone know if I can still get an eval version of CF5 and if so where? Cheers Will __ 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: Cross posting: CF5 eval???
I have the direct links bookmarked, what OS are you looking for? Christine -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 6:31 AM To: CF-Talk Subject: Cross posting: CF5 eval??? Hi, Looking for an evaluation version of CF5 but all I can find on the macromedia web site is the eval version of MX. Anyone know if I can still get an eval version of CF5 and if so where? Cheers Will __ 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: Cross posting: CF5 eval???
ZX Spectrum 48K if you have it :-p (sorry, its lunchtime ) -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 13:17 To: CF-Talk Subject: RE: Cross posting: CF5 eval??? I have the direct links bookmarked, what OS are you looking for? Christine -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 6:31 AM To: CF-Talk Subject: Cross posting: CF5 eval??? Hi, Looking for an evaluation version of CF5 but all I can find on the macromedia web site is the eval version of MX. Anyone know if I can still get an eval version of CF5 and if so where? Cheers Will __ 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
SOT How to set up win XP network to be recognized by OS X
This is a repost with a slightly different flavor: Objective: Connect a windows machine (emulated with VirtualPC) to a network on the host Mac OS X machine. The CF tie-in is that I want to Use CFMX on OS X to manipulate MS-Access databases on the Emulated windows machine. The MS-Access databases will not be used in production, rather, the CF programs will extract the MS-Access data and put it into a more-robust RDBMS (usually validating data, changing the schema, normalizing, etc.). CFML is an excellent language for doing this, This is not just an Mac OS X issue -- A Linux or Unix-based CFMX system often needs to get data from MS-Access databases. Sure there other ways to do this, but they all involve extra steps and/or extra hardware fiddling around -- the elegant way is to write a CF program to directly manipulate the MS-Access tables and create and populate the real RDBMS tables (normalizing and creating relationships in the process). The first step to do this is to get the Host Mac and winXP machines thinking they are on the same network I was trying to do this with winNT under Jaguar. I got a lot of help from Sean Daniels and Dave Watts, but never got it working. They were both using later versions of windows. Yesterday, I bought and installed (under VPC) WinXP Upgrade. (Jeez, and people bitch about the cost of OS X, but that's another story...) I used all the setup wizards and XP works fine -- I can access the Internet, from XP, over the shared IP connection, But, winXP doesn't see the host Mac and the Host Mac doesn't see winXP. Help? TIA Dick __ 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: SQL Text question from a beginner
Well, that is the highest signed integer you can represent with a 16-bit byte, isn't it? -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ 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: SQL Text question from a beginner
Hi, John. I use Access 2000 and when I need more than 255 characters, I use the Memo datatype in Acess...I forget the limit for that datatype, but it's quite large and always enough for everything I've needed... HTH, Rick -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:33 AM To: CF-Talk Subject: RE: SQL Text question from a beginner I took a look on msdn and books online and haven't been able to make much sense of the situation. It appears that one can't define their own data type and accessing this data is less than intuitive. Anyone out there figured out a way to retrieve a couple of pages of data from ms sql? Or accomplish the insertion of dynamic text via some other means? Thanks, John -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:38 PM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ 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: Cross posting: CF5 eval???
Hi Christine, Windows, but I have contacted Unipalm here in the UK and they are sending me a disc!! Cheers anyway will -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 13:17 To: CF-Talk Subject: RE: Cross posting: CF5 eval??? I have the direct links bookmarked, what OS are you looking for? Christine -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 6:31 AM To: CF-Talk Subject: Cross posting: CF5 eval??? Hi, Looking for an evaluation version of CF5 but all I can find on the macromedia web site is the eval version of MX. Anyone know if I can still get an eval version of CF5 and if so where? Cheers Will __ 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: Query of Queries Error
What version? Can you limit your select statement to one query that can cause the error? That will pinpoint the exact column. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Sam Farmer [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:22 PM To: CF-Talk Subject: Query of Queries Error Hi, I have a query of queries that has been working fine until today when I started getting the following error: Query Of Queries runtime error. Unsupported Numeric type conversion in Query of Queries. Thats the extent of the error message provided! The columns seem to match up exactly on database type and length. Can anyone help provide some insight? Thanks, Sam __ 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: SQL Text question from a beginner
hey, it was late, and I had been looking at cf and xsl code for like 8 hours straight.. ;) be nice. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ 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
opinions about XSL
is found this article talking about why xsl is bad http://www.xml.com/pub/a/1999/05/xsl/xslconsidered_1.html any comments? I haven't personally looked into xsl, the syntax always looked like RTF :-) through babelfish and it looks like doing client side work on the server ( ie browser stuff ) i know from my old man who does java that it's quicker to go xml-dom-xml than xsl what's peoples experience? z __ 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: Switching to CFMX
Secondly, this is exactly the sort of issue that makes me very nervous of Fusebox. It tries hard to hide complexity from programmers but this shows just how much code it's really hiding and just how much machinery lurks behind the framework. This is the exact same argument that gets made against ColdFusion. I'm sure those early Word Perfect assembly programmers said the same thing about programmers writing word processing programs in languages like C and *gasp* VisualBasic. Of course, this isn't really FB's fault: Of course this isn't really (C's|C++'s|Java's|VisualBasic's|ColdFusion's) fault. :) Benjamin S. Rogers http://www.c4.net/ v.508.240.0051 f.508.240.0057 __ 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: Cross posting: CF5 eval???
Great, for future reference here is the direct link to the Developer/Trial version of CF 5 for Windows: http://download.macromedia.com/pub/coldfusion/esd/coldfusion-50-win-us_devrel.exe Christine -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 8:39 AM To: CF-Talk Subject: RE: Cross posting: CF5 eval??? Hi Christine, Windows, but I have contacted Unipalm here in the UK and they are sending me a disc!! Cheers anyway will -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 13:17 To: CF-Talk Subject: RE: Cross posting: CF5 eval??? I have the direct links bookmarked, what OS are you looking for? Christine -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 6:31 AM To: CF-Talk Subject: Cross posting: CF5 eval??? Hi, Looking for an evaluation version of CF5 but all I can find on the macromedia web site is the eval version of MX. Anyone know if I can still get an eval version of CF5 and if so where? Cheers Will __ 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
embedding cfmail in a cfoutput
I must be missing something very simple. I'm trying to embed a cfmail in a cfoutput tag and am getting the following error msg. // ERROR MSG A CFMAIL tag is nested inside a CFOUTPUT tag that does not have a GROUP= attribute. This is not allowed. Nesting these tags implies that you want to use grouped processing. However, the top-level tag must specify a top-level group using a GROUP= attribute. // END of ERROR MSG As I understand it I have no need of a group attribute; nor would the group attribute help in this situation. Of course it may be that my understanding is incorrect. :-] PROBLEM: Users fill in a form. They are in a permissioned area. They authenticate their submission by filling in their user username and password. (To be doubly sure that the submitter is the person logged into the site.) The processing page queries the database and sees if the username and password equals the form submitted username and password. If it is a cfmail is sent. If not then an error msg appears. code below: cfquery name=name datasource=aaa SELECT * FROM users WHERE Username='#log_username#' /cfquery cfoutput query=name cfif #username# EQ #form.submittedUsername# AND #password# EQ #form.submittedPassword# cfmail to= from= subject= yadda yadda yadda /cfmail cfelse Your username and password do not match the login records of the current user. /cfif /cfoutput thx, gilbert midonnet __ 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: embedding cfmail in a cfoutput
Do a group on the user id. This way your grouping is done on individual unique values, hence cancelling out the grouping. Hope this makes sense, Dave -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 14:54 To: CF-Talk Subject: embedding cfmail in a cfoutput I must be missing something very simple. I'm trying to embed a cfmail in a cfoutput tag and am getting the following error msg. // ERROR MSG A CFMAIL tag is nested inside a CFOUTPUT tag that does not have a GROUP= attribute. This is not allowed. Nesting these tags implies that you want to use grouped processing. However, the top-level tag must specify a top-level group using a GROUP= attribute. // END of ERROR MSG As I understand it I have no need of a group attribute; nor would the group attribute help in this situation. Of course it may be that my understanding is incorrect. :-] PROBLEM: Users fill in a form. They are in a permissioned area. They authenticate their submission by filling in their user username and password. (To be doubly sure that the submitter is the person logged into the site.) The processing page queries the database and sees if the username and password equals the form submitted username and password. If it is a cfmail is sent. If not then an error msg appears. code below: cfquery name=name datasource=aaa SELECT * FROM users WHERE Username='#log_username#' /cfquery cfoutput query=name cfif #username# EQ #form.submittedUsername# AND #password# EQ #form.submittedPassword# cfmail to= from= subject= yadda yadda yadda /cfmail cfelse Your username and password do not match the login records of the current user. /cfif /cfoutput thx, gilbert midonnet __ 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: Cross posting: CF5 eval???
Chris, not sure if you can tell me. People are asking if CF5 Pro/Ent will be available for sale in the MM store for how long? A MM customer can buy CFMX and perform a downgrade (using the same package (pro or ent)) to CF5? Thanks!! Alex | alex hübner | [EMAIL PROTECTED] | www.cfgigolo.com -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:50 AM To: CF-Talk Subject: RE: Cross posting: CF5 eval??? Great, for future reference here is the direct link to the Developer/Trial version of CF 5 for Windows: http://download.macromedia.com/pub/coldfusion/esd/coldfusion-5 0-win-us_devrel.exe Christine -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 8:39 AM To: CF-Talk Subject: RE: Cross posting: CF5 eval??? Hi Christine, Windows, but I have contacted Unipalm here in the UK and they are sending me a disc!! Cheers anyway will -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 13:17 To: CF-Talk Subject: RE: Cross posting: CF5 eval??? I have the direct links bookmarked, what OS are you looking for? Christine -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 6:31 AM To: CF-Talk Subject: Cross posting: CF5 eval??? Hi, Looking for an evaluation version of CF5 but all I can find on the macromedia web site is the eval version of MX. Anyone know if I can still get an eval version of CF5 and if so where? Cheers Will __ 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: Query of Queries Error
CF MX Enterprise. I have narrowed it down to one column and get the following message: All resulting columns of queries in a SELECT statement containing a UNION operator must have corresponding types. Columns with index number equal 2 have diffent types (INTEGER, VARCHAR). The column with an index of 2 in the second query is a column I have added, however, in this case it has no value. In the first query the column is not added and its an integer column. Any suggestions? Thanks, Sam - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 8:40 AM Subject: RE: Query of Queries Error What version? Can you limit your select statement to one query that can cause the error? That will pinpoint the exact column. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Sam Farmer [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:22 PM To: CF-Talk Subject: Query of Queries Error Hi, I have a query of queries that has been working fine until today when I started getting the following error: Query Of Queries runtime error. Unsupported Numeric type conversion in Query of Queries. Thats the extent of the error message provided! The columns seem to match up exactly on database type and length. Can anyone help provide some insight? Thanks, 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: Cross posting: CF5 eval???
Cheers Christine. have a good day w -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 14:50 To: CF-Talk Subject: RE: Cross posting: CF5 eval??? Great, for future reference here is the direct link to the Developer/Trial version of CF 5 for Windows: http://download.macromedia.com/pub/coldfusion/esd/coldfusion-50-win-us_devre l.exe Christine -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 8:39 AM To: CF-Talk Subject: RE: Cross posting: CF5 eval??? Hi Christine, Windows, but I have contacted Unipalm here in the UK and they are sending me a disc!! Cheers anyway will -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 13:17 To: CF-Talk Subject: RE: Cross posting: CF5 eval??? I have the direct links bookmarked, what OS are you looking for? Christine -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 6:31 AM To: CF-Talk Subject: Cross posting: CF5 eval??? Hi, Looking for an evaluation version of CF5 but all I can find on the macromedia web site is the eval version of MX. Anyone know if I can still get an eval version of CF5 and if so where? Cheers Will __ 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: SQL Text question from a beginner
It is the pointer that points to the data that is 16 bytes long :) Jeremy - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 1:30 PM Subject: RE: SQL Text question from a beginner hey, it was late, and I had been looking at cf and xsl code for like 8 hours straight.. ;) be nice. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ 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: Query of Queries Error
It sounds like you are trying to link up a non integer and integer column from 2 queries. Can you make the added column have some default integer values? === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Sam Farmer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:00 AM To: CF-Talk Subject: Re: Query of Queries Error CF MX Enterprise. I have narrowed it down to one column and get the following message: All resulting columns of queries in a SELECT statement containing a UNION operator must have corresponding types. Columns with index number equal 2 have diffent types (INTEGER, VARCHAR). The column with an index of 2 in the second query is a column I have added, however, in this case it has no value. In the first query the column is not added and its an integer column. Any suggestions? Thanks, Sam - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 8:40 AM Subject: RE: Query of Queries Error What version? Can you limit your select statement to one query that can cause the error? That will pinpoint the exact column. == = Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Sam Farmer [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:22 PM To: CF-Talk Subject: Query of Queries Error Hi, I have a query of queries that has been working fine until today when I started getting the following error: Query Of Queries runtime error. Unsupported Numeric type conversion in Query of Queries. Thats the extent of the error message provided! The columns seem to match up exactly on database type and length. Can anyone help provide some insight? Thanks, 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
OT: Eron Cohen, please email me!
My apologies for the cross-post and my use of the list for this purpose. Judith Dinowitz Editor Fusion Authority http://www.fusionauthority.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
QofQ and dates...
should i be able to do date comparisons in a QofQ? i'm using: cfset FilterDate = #dateadd('d', #arguments.AgeArticlesOnHomePage#, now())# !--- filter the recordset --- cfquery name=FilteredBlogArticles dbtype=query Select * from BlogArticles where articledate = #FilterDate# order by articledate DESC /cfquery and getting: Query Of Queries syntax error. Encountered articledate = { at line 3, column 31. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, returned. Also just noticed: SQL Select * from BlogArticles where articledate = {ts apos;2002-09-24 15:12:35apos;} order by articledate DESC Please try the following: tucked away at the bottom of the page thanks for the help, jb. * [EMAIL PROTECTED] * +44 (0)1372 367147 * http://www.era.co.uk/ http://www.era.co.uk/ * Copyright ERA Technology Ltd. 2002. (www.era.co.uk). All rights reserved. The information supplied in this email should be treated in confidence. No liability whatsoever is accepted for any loss or damage suffered as a result of accessing this message or any attachments. __ 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: Eron Cohen, please email me!
yes, do it again and we'll report you to the list admin :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 15:21 To: CF-Talk Subject: OT: Eron Cohen, please email me! My apologies for the cross-post and my use of the list for this purpose. Judith Dinowitz Editor Fusion Authority http://www.fusionauthority.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: embedding cfmail in a cfoutput -- thx
Dave, It really doesn't make any sense but it works. I'm sure as I work with it more it will sink in. Thx. ummm ... Is this because cfoutput query= loops through the table? ... and this makes it stop at the first match? // glm -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 9:57 AM To: CF-Talk Subject: RE: embedding cfmail in a cfoutput Do a group on the user id. This way your grouping is done on individual unique values, hence cancelling out the grouping. Hope this makes sense, Dave -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 14:54 To: CF-Talk Subject: embedding cfmail in a cfoutput I must be missing something very simple. I'm trying to embed a cfmail in a cfoutput tag and am getting the following error msg. // ERROR MSG A CFMAIL tag is nested inside a CFOUTPUT tag that does not have a GROUP= attribute. This is not allowed. Nesting these tags implies that you want to use grouped processing. However, the top-level tag must specify a top-level group using a GROUP= attribute. // END of ERROR MSG As I understand it I have no need of a group attribute; nor would the group attribute help in this situation. Of course it may be that my understanding is incorrect. :-] PROBLEM: Users fill in a form. They are in a permissioned area. They authenticate their submission by filling in their user username and password. (To be doubly sure that the submitter is the person logged into the site.) The processing page queries the database and sees if the username and password equals the form submitted username and password. If it is a cfmail is sent. If not then an error msg appears. code below: cfquery name=name datasource=aaa SELECT * FROM users WHERE Username='#log_username#' /cfquery cfoutput query=name cfif #username# EQ #form.submittedUsername# AND #password# EQ #form.submittedPassword# cfmail to= from= subject= yadda yadda yadda /cfmail cfelse Your username and password do not match the login records of the current user. /cfif /cfoutput thx, gilbert midonnet __ 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: opinions about XSL
What other option is there to transform xml docs? On Tue, 1 Oct 2002, Zac Spitzer wrote: is found this article talking about why xsl is bad http://www.xml.com/pub/a/1999/05/xsl/xslconsidered_1.html any comments? I haven't personally looked into xsl, the syntax always looked like RTF :-) through babelfish and it looks like doing client side work on the server ( ie browser stuff ) i know from my old man who does java that it's quicker to go xml-dom-xml than xsl what's peoples experience? z __ 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: QofQ and dates...
Try adding a createodcdate around it... cfset FilterDate = dateadd('d', arguments.AgeArticlesOnHomePage, now()) cfquery name=FilteredBlogArticles dbtype=query Select * from BlogArticles where articledate = #CreateODBCDate(FilterDate)# order by articledate DESC /cfquery HTH -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 1, 2002 15:19 To: CF-Talk Subject: QofQ and dates... should i be able to do date comparisons in a QofQ? i'm using: cfset FilterDate = #dateadd('d', #arguments.AgeArticlesOnHomePage#, now())# !--- filter the recordset --- cfquery name=FilteredBlogArticles dbtype=query Select * from BlogArticles where articledate = #FilterDate# order by articledate DESC /cfquery and getting: Query Of Queries syntax error. Encountered articledate = { at line 3, column 31. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, returned. Also just noticed: SQL Select * from BlogArticles where articledate = {ts apos;2002-09-24 15:12:35apos;} order by articledate DESC Please try the following: tucked away at the bottom of the page thanks for the help, jb. * [EMAIL PROTECTED] * +44 (0)1372 367147 * http://www.era.co.uk/ http://www.era.co.uk/ * Copyright ERA Technology Ltd. 2002. (www.era.co.uk). All rights reserved. The information supplied in this email should be treated in confidence. No liability whatsoever is accepted for any loss or damage suffered as a result of accessing this message or any attachments. __ 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: Cross posting: CF5 eval???
Hi Alex, I just checked with customer service and this is what they said: CF 5.0 is available from the Online Store, Modus and via the channel in the MVLP program. Please advise this customer *not* to purchase CFMX and request a downgrade but to use one of the avenues I have suggested. http://www.macromedia.com/software/coldfusion/productinfo/faq/general/#p800 They can also call Zones and ask for CF 5.0 at [EMAIL PROTECTED] or 877-206-4622 Hope that helps! Christine -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:00 AM To: CF-Talk Subject: RE: Cross posting: CF5 eval??? Chris, not sure if you can tell me. People are asking if CF5 Pro/Ent will be available for sale in the MM store for how long? A MM customer can buy CFMX and perform a downgrade (using the same package (pro or ent)) to CF5? Thanks!! Alex | alex hübner | [EMAIL PROTECTED] | www.cfgigolo.com -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:50 AM To: CF-Talk Subject: RE: Cross posting: CF5 eval??? Great, for future reference here is the direct link to the Developer/Trial version of CF 5 for Windows: http://download.macromedia.com/pub/coldfusion/esd/coldfusion-5 0-win-us_devrel.exe Christine -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 8:39 AM To: CF-Talk Subject: RE: Cross posting: CF5 eval??? Hi Christine, Windows, but I have contacted Unipalm here in the UK and they are sending me a disc!! Cheers anyway will -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 13:17 To: CF-Talk Subject: RE: Cross posting: CF5 eval??? I have the direct links bookmarked, what OS are you looking for? Christine -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 6:31 AM To: CF-Talk Subject: Cross posting: CF5 eval??? Hi, Looking for an evaluation version of CF5 but all I can find on the macromedia web site is the eval version of MX. Anyone know if I can still get an eval version of CF5 and if so where? Cheers Will __ 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: QofQ and dates...
Still bitchessame error message - but the SQL at the bottom of the page changes to: SQLSelect * from BlogArticles where articledate = {d apos;2002-09-24apos;} order by articledate DESC What's with the apos; stuff? -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 15:25 To: CF-Talk Subject: RE: QofQ and dates... Try adding a createodcdate around it... cfset FilterDate = dateadd('d', arguments.AgeArticlesOnHomePage, now()) cfquery name=FilteredBlogArticles dbtype=query Select * from BlogArticles where articledate = #CreateODBCDate(FilterDate)# order by articledate DESC /cfquery HTH -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 1, 2002 15:19 To: CF-Talk Subject: QofQ and dates... should i be able to do date comparisons in a QofQ? i'm using: cfset FilterDate = #dateadd('d', #arguments.AgeArticlesOnHomePage#, now())# !--- filter the recordset --- cfquery name=FilteredBlogArticles dbtype=query Select * from BlogArticles where articledate = #FilterDate# order by articledate DESC /cfquery and getting: Query Of Queries syntax error. Encountered articledate = { at line 3, column 31. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, returned. Also just noticed: SQL Select * from BlogArticles where articledate = {ts apos;2002-09-24 15:12:35apos;} order by articledate DESC Please try the following: tucked away at the bottom of the page thanks for the help, jb. * [EMAIL PROTECTED] * +44 (0)1372 367147 * http://www.era.co.uk/ http://www.era.co.uk/ * Copyright ERA Technology Ltd. 2002. (www.era.co.uk). All rights reserved. The information supplied in this email should be treated in confidence. No liability whatsoever is accepted for any loss or damage suffered as a result of accessing this message or any attachments. __ 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: Cross posting: CF5 eval???
Yes! Thanks a lot Chris! []'s Alex | alex hübner | [EMAIL PROTECTED] | www.cfgigolo.com -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:30 AM To: CF-Talk Subject: RE: Cross posting: CF5 eval??? Hi Alex, I just checked with customer service and this is what they said: CF 5.0 is available from the Online Store, Modus and via the channel in the MVLP program. Please advise this customer *not* to purchase CFMX and request a downgrade but to use one of the avenues I have suggested. http://www.macromedia.com/software/coldfusion/productinfo/faq/ general/#p800 They can also call Zones and ask for CF 5.0 at [EMAIL PROTECTED] or 877-206-4622 Hope that helps! Christine -Original Message- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:00 AM To: CF-Talk Subject: RE: Cross posting: CF5 eval??? Chris, not sure if you can tell me. People are asking if CF5 Pro/Ent will be available for sale in the MM store for how long? A MM customer can buy CFMX and perform a downgrade (using the same package (pro or ent)) to CF5? Thanks!! Alex | alex hübner | [EMAIL PROTECTED] | www.cfgigolo.com -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:50 AM To: CF-Talk Subject: RE: Cross posting: CF5 eval??? Great, for future reference here is the direct link to the Developer/Trial version of CF 5 for Windows: http://download.macromedia.com/pub/coldfusion/esd/coldfusion-5 0-win-us_devrel.exe Christine -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 8:39 AM To: CF-Talk Subject: RE: Cross posting: CF5 eval??? Hi Christine, Windows, but I have contacted Unipalm here in the UK and they are sending me a disc!! Cheers anyway will -Original Message- From: Christine Lawson [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 13:17 To: CF-Talk Subject: RE: Cross posting: CF5 eval??? I have the direct links bookmarked, what OS are you looking for? Christine -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 6:31 AM To: CF-Talk Subject: Cross posting: CF5 eval??? Hi, Looking for an evaluation version of CF5 but all I can find on the macromedia web site is the eval version of MX. Anyone know if I can still get an eval version of CF5 and if so where? Cheers Will __ 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: Switching to CFMX
On Monday, Sep 30, 2002, at 17:55 US/Pacific, Nat Papovich wrote: Unfortunately though, Rob's really long index doesn't appear to use Fusebox 3's core file, which I assume, is the complex machinery you mention, Sean. In pre-FB3, there is very little to no machinery used, so long cfswitch statements are the result of the poor design of whoever wrote unfortunate Rob's code, not some implied Fusebox architectural path. Thanx for clarifying. I need to go back and read that FB3 book again! :) I was thinking more along the lines of the impact all the included files had on the code size - the core files *are* machinery. However, if you're reassuring me that with FB3, the 64k limit is unlikely to be hit then that is even better to know - after all, it would not be very encouraging if large Fusebox applications (whatever they may be - we've had discussions before about 'what is a large application?') simply failed on CFMX due to code size. I have encountered this same limitation in CFMX/Java in a really long custom tag written by (surprise) someone else. Sean, do you know if this (64k) limitation is something that can be addressed by Macromedia? Or is it inherent to Java? Or... ? It is inherent in Java's virtual machine - the offset on a jump is 16 bits and that causes a 64k limit. The CFMX compiler tries to work around this in some cases by figuring out that it can rearrange code, but not all files are amenable to this. An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 __ 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: opinions about XSL
The big thing about XSL : + clear separation from content (XML) and presentation logic (XSL), + based on XML + designed for XML transformation + standard and cross-platform = big hype (XSL benefits a lot from the XML hype) I am not a big fan of XSL. The language is ugly and difficult as the article says. Right now : - XSL transformation on the client side is very difficult to implement because you are dependent of the XSL engine available on the client (which might be a very old one with extremely limited capabilities), - XSL transformation on the server side is probably not the best choice, I prefer to use scripting languages such as CFML to manipulate XML and define the presentation logic. It is 100 times more efficient, quicker to develop and to debug than a pure XSL approach. So, XSL works, but there is often better alternatives to transform XML data or define presentation logic. The technology isn't mature enough (and specifications are changing quite often...). However, it might be a good option if you need true cross-platform XML transformation / presentation logic and if the application is heavily based on XML (an XSL stylesheet could be used in Java, .NET, PHP... on the server side and/or the client side). My 2 cents. Benoit Hediard www.benorama.com -Message d'origine- De : Zac Spitzer [mailto:[EMAIL PROTECTED]] Envoyé : mardi 1 octobre 2002 15:47 À : CF-Talk Objet : opinions about XSL is found this article talking about why xsl is bad http://www.xml.com/pub/a/1999/05/xsl/xslconsidered_1.html any comments? I haven't personally looked into xsl, the syntax always looked like RTF :-) through babelfish and it looks like doing client side work on the server ( ie browser stuff ) i know from my old man who does java that it's quicker to go xml-dom-xml than xsl what's peoples experience? z __ 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: Switching to CFMX
On Tuesday, Oct 1, 2002, at 06:49 US/Pacific, Benjamin S. Rogers wrote: This is the exact same argument that gets made against ColdFusion. Not by me. I'm sure those early Word Perfect assembly programmers said the same thing about programmers writing word processing programs in languages like C and *gasp* VisualBasic. Not in my experience. I wrote my first word processing program (a template-driven automobile insurance letter editor) in assembly language in '81 and it was a pain. I wrote my second word processing program (a dual-language, English-Cyrillic, general WP) in C in '84. I, like many other assembly programmers, were quite glad of the additional expressive power in C - and of course we reassured ourselves that it often generated code that was close to what we could do by hand (not always of course, but compiler optimizations improved rapidly in the 80's). Of course, this isn't really FB's fault: Of course this isn't really (C's|C++'s|Java's|VisualBasic's|ColdFusion's) fault. :) Well, actually this hidden complexity *is* ColdFusion's fault. Or at least, pre-MX ColdFusion's fault. Like C, it was not designed to support OO-style frameworks (see the mess that is early X-Windows source code). Now we're seeing a problem that *is* Java's fault - it was designed with inherent limitations. An Architect's View -- http://www.corfield.org/blog/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at http://www.macromedia.com/go/devcon2002 __ 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: encode an image into a .cfm inline
Is this just for the purpose of seeing what fits at different widths? Is it just for your reference or is it for visitors to the site to be able to see? If it's just for you and just for dev., then you can use an old trick I came up with years and years ago. Make a desktop picture with ruled areas delineating the common screen resolutions. Then just resize your browser window to fit within the different bounding lines on the desktop. It's an extremely simple way to check fit. Also, if you use Dreamweaver, there is a feature that will automatically resize the working page window to different standard sizes and it even lets you define your own custom sizes. It's in the lower-right of the document editing window and the window needs to be non-maximized. Kevin Graeme -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 2:12 PM To: CF-Talk Subject: RE: encode an image into a .cfm inline I guess I did not describe this too well. The Rule is a graphic image (a gif in this case) of a Ruler that helps me relate to people using lower resolutions. Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1:54 PM To: CF-Talk Subject: Re: encode an image into a .cfm inline - Original Message - From: Mark W. Breneman [EMAIL PROTECTED] Does anyone have any ideas on if it is possible to encode an image into a cfm? My guess it that it is impossible... but, thought I would ask. I have a graphic ruler that is included in the bottom of all of my pages via onrequestend.cfm only if a cookie vale is set to active. I develop on several servers and often off line as well. I would like to have this ruler available anytime any where. Is there a way of encoding the graphic inline in the .cfm file? I guess I could make a ruler with a HTML table... Not totally sure of what you're after, but the first thing that springs to mind is the hr / tag. But you say ruler, not rule, and mention a HTML table... Could you be more specific? - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ 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: Query of Queries Error
Thanks for you help Raymond. I have it working by giving it a default value of -100. Not ideal as really want it to be null. As a suggestion it would be nice if the QueryAddColumn function took datatype as an argument. Cheers, Sam - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 10:11 AM Subject: RE: Query of Queries Error It sounds like you are trying to link up a non integer and integer column from 2 queries. Can you make the added column have some default integer values? === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Sam Farmer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:00 AM To: CF-Talk Subject: Re: Query of Queries Error CF MX Enterprise. I have narrowed it down to one column and get the following message: All resulting columns of queries in a SELECT statement containing a UNION operator must have corresponding types. Columns with index number equal 2 have diffent types (INTEGER, VARCHAR). The column with an index of 2 in the second query is a column I have added, however, in this case it has no value. In the first query the column is not added and its an integer column. Any suggestions? Thanks, Sam - Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 8:40 AM Subject: RE: Query of Queries Error What version? Can you limit your select statement to one query that can cause the error? That will pinpoint the exact column. == = Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Sam Farmer [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:22 PM To: CF-Talk Subject: Query of Queries Error Hi, I have a query of queries that has been working fine until today when I started getting the following error: Query Of Queries runtime error. Unsupported Numeric type conversion in Query of Queries. Thats the extent of the error message provided! The columns seem to match up exactly on database type and length. Can anyone help provide some insight? Thanks, 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: QofQ and dates...(FIXED)
Using CFQUERYPARAM fixed the problem, Query becomes: !--- filter the recordset --- cfquery name=FilteredBlogArticles dbtype=query Select * from BlogArticles where (articledate = cfqueryparam cfsqltype=cf_sql_date value=#CreateODBCDate(targetdate)#) order by articledate DESC /cfquery -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 15:29 To: CF-Talk Subject: RE: QofQ and dates... Still bitchessame error message - but the SQL at the bottom of the page changes to: SQLSelect * from BlogArticles where articledate = {d apos;2002-09-24apos;} order by articledate DESC What's with the apos; stuff? -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 15:25 To: CF-Talk Subject: RE: QofQ and dates... Try adding a createodcdate around it... cfset FilterDate = dateadd('d', arguments.AgeArticlesOnHomePage, now()) cfquery name=FilteredBlogArticles dbtype=query Select * from BlogArticles where articledate = #CreateODBCDate(FilterDate)# order by articledate DESC /cfquery HTH -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 1, 2002 15:19 To: CF-Talk Subject: QofQ and dates... should i be able to do date comparisons in a QofQ? i'm using: cfset FilterDate = #dateadd('d', #arguments.AgeArticlesOnHomePage#, now())# !--- filter the recordset --- cfquery name=FilteredBlogArticles dbtype=query Select * from BlogArticles where articledate = #FilterDate# order by articledate DESC /cfquery and getting: Query Of Queries syntax error. Encountered articledate = { at line 3, column 31. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, returned. Also just noticed: SQL Select * from BlogArticles where articledate = {ts apos;2002-09-24 15:12:35apos;} order by articledate DESC Please try the following: tucked away at the bottom of the page thanks for the help, jb. * [EMAIL PROTECTED] * +44 (0)1372 367147 * http://www.era.co.uk/ http://www.era.co.uk/ * Copyright ERA Technology Ltd. 2002. (www.era.co.uk). All rights reserved. The information supplied in this email should be treated in confidence. No liability whatsoever is accepted for any loss or damage suffered as a result of accessing this message or any attachments. __ 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: QofQ and dates...
Howdy John, Tuesday, October 1, 2002, 9:29:20 AM, John Beynon wrote: JB Still bitchessame error message - but the SQL at the bottom of the page JB changes to: JB SQLSelect * from BlogArticles where articledate = {d JB apos;2002-09-24apos;} order by articledate DESC JB What's with the apos; stuff? I don't know, but I also had probs with date comparisons in QofQ's. Then I discovered mention of the fact that QofQ's don't allow ODBC dates in comparison operations in Rob Brooks-Bilson's book Programming ColdFusion (Note: Mr. B-B refers to QofQ's as CFSQL): CFSQL doesn't support nested aggregate functions nor does it support ODBC dates in comparison operations. (p. 377) This is the only reference I found thus far that addresses ODBC date comparisons in QofQ's. It may be possible to work this out with a workaround, but I haven't hit on it yet. Chris Montgomerymonty airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 __ 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: encode an image into a .cfm inline
Mark, I think what you are after would be solved by this snippet. Put this in a template (and after testing, test with some URL vars etc) and call the template.cfm in the IMG tag. CFHEADER NAME=Content-Type VALUE=Image/GIF CFCONTENT TYPE=Image/GIF DELETEFILE=no FILE=image.gif RESET=Yes __ 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: QofQ and dates...(FIXED)
Howdy John, Tuesday, October 1, 2002, 9:56:44 AM, John Beynon wrote: JB Using CFQUERYPARAM fixed the problem, Good to know you found the solution! Now I can fix mine. :) Thanks! Chris Montgomerymonty airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 __ 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: QofQ and dates...
John Beynon wrote: should i be able to do date comparisons in a QofQ? Yes. But unfortunately it is impossible to use date objects directly in pass through QofQ's, so you have to fake a prepared statement with cfqueryparam or just use a string representation of a date. In your case, you should be able to use: cfquery name=FilteredBlogArticles dbtype=query Select * from BlogArticles where articledate = cfqueryparam cfsqltype=cf_sql_date value=#FilterDate# order by articledate DESC /cfquery Or: cfquery name=FilteredBlogArticles dbtype=query Select * from BlogArticles where articledate = '2002-10-01' order by articledate DESC /cfquery Jochem __ 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: QofQ and dates...(FIXED)
I sort of got pushed in the right direction by this post in the forums: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=7threadid =364061highlight_key=ykeyword1=query%20of%20queries HTH, John. -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 16:13 To: CF-Talk Subject: Re: QofQ and dates...(FIXED) Howdy John, Tuesday, October 1, 2002, 9:56:44 AM, John Beynon wrote: JB Using CFQUERYPARAM fixed the problem, Good to know you found the solution! Now I can fix mine. :) Thanks! Chris Montgomerymonty @ airtightweb.com -- Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 __ 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: embedding cfmail in a cfoutput -- thx
This is because the cfmail tag uses the cfoutput mechanism internally ( this is why it has the query= atrribute and I think a group= attribute... this is also why you don't need a cfoutput inside a cfmail in order to output variables, because the folks at Allaire originally assumed people would want to do that most of the time ( probably a good assumption :) In any event -- You probably don't want a cfoutput or even a cfloop here anyway -- since the query is designed to return what I can only imagine has to be a single row ( the given user ), what you probably want to do is just have your cfif statement evaluate name.recordcount ( though I'd rename that query also ) and send the email if query.recordcount is greater than zero. No need for a cfoutput there, since cfmail essentially _is_ a cfoutput ... hth S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 Dave, It really doesn't make any sense but it works. I'm sure as I work with it more it will sink in. Thx. ummm ... Is this because cfoutput query= loops through the table? ... and this makes it stop at the first match? // glm -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 9:57 AM To: CF-Talk Subject: RE: embedding cfmail in a cfoutput Do a group on the user id. This way your grouping is done on individual unique values, hence cancelling out the grouping. Hope this makes sense, Dave -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 14:54 To: CF-Talk Subject: embedding cfmail in a cfoutput I must be missing something very simple. I'm trying to embed a cfmail in a cfoutput tag and am getting the following error msg. // ERROR MSG A CFMAIL tag is nested inside a CFOUTPUT tag that does not have a GROUP= attribute. This is not allowed. Nesting these tags implies that you want to use grouped processing. However, the top-level tag must specify a top-level group using a GROUP= attribute. // END of ERROR MSG As I understand it I have no need of a group attribute; nor would the group attribute help in this situation. Of course it may be that my understanding is incorrect. :-] PROBLEM: Users fill in a form. They are in a permissioned area. They authenticate their submission by filling in their user username and password. (To be doubly sure that the submitter is the person logged into the site.) The processing page queries the database and sees if the username and password equals the form submitted username and password. If it is a cfmail is sent. If not then an error msg appears. code below: cfquery name=name datasource=aaa SELECT * FROM users WHERE Username='#log_username#' /cfquery cfoutput query=name cfif #username# EQ #form.submittedUsername# AND #password# EQ #form.submittedPassword# cfmail to= from= subject= yadda yadda yadda /cfmail cfelse Your username and password do not match the login records of the current user. /cfif /cfoutput thx, gilbert midonnet __ 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: opinions about XSL
Alex wrote: What other option is there to transform xml docs? convert the xml to dom, do your mods and then back to xml, as a CF developer, it much easier to work IMHO with the xml dom as structures etc than messing around with... apparently one of the problems with XSL as an approach performance wise is something to do with the way that it progressively processes the xml file and has to do some prediction stuff (read more overhead) as it goes... you can do amazing stuff with xml and css, write a style sheet which hides nodes ( display:none;) now if only we could get everyone to upgrade to mozilla.. then life would be so much easier.. back to workarounds, again :-( __ 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: embedding cfmail in a cfoutput -- thx
Gilbert, I'll try and explain a little more clearly. Basically, yes you're right that the cfoutput query= behaves as a loop. Looping through each record obtained from the specified query - in your case users. Now, sometimes when we are looping an output it becomes necessary to have some kind of control over the order in which it is output/processed. In your own example this is not easily explained as it appears to simply be a syntax requirement of nesting the cfmail tag, more than anything else. Most likely to do with how the cfmail tag itself works. However... Going back to what I was saying about controlling the order of output. Lets take a diary application as an example. We might have a table called appointments, which will store each appointment as an individual lineitem, with a primary key. Now there may be several appointments on a single day (date field). If we did a simple cfoutput on the query, we could get some semblance of fluidity in the output, however it would be much nicer to group on the date field, which would then give us nicely formatted output of a day by day based diary. I'm presuming that you are already aware of the above. Now, if we decided to group the output by the primary key field, we're actually not going to be affecting the final output one iota. Why? Because the original cfoutput on the query is automatically 'grouping' by the primary key field anyway - by the very nature and purpose of primary keys. Maybe someone else might be able to explain all this in a more coherent manner, but thats the basic logic behind it. Dave -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 15:24 To: CF-Talk Subject: RE: embedding cfmail in a cfoutput -- thx Dave, It really doesn't make any sense but it works. I'm sure as I work with it more it will sink in. Thx. ummm ... Is this because cfoutput query= loops through the table? ... and this makes it stop at the first match? // glm -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 9:57 AM To: CF-Talk Subject: RE: embedding cfmail in a cfoutput Do a group on the user id. This way your grouping is done on individual unique values, hence cancelling out the grouping. Hope this makes sense, Dave -Original Message- From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 14:54 To: CF-Talk Subject: embedding cfmail in a cfoutput I must be missing something very simple. I'm trying to embed a cfmail in a cfoutput tag and am getting the following error msg. // ERROR MSG A CFMAIL tag is nested inside a CFOUTPUT tag that does not have a GROUP= attribute. This is not allowed. Nesting these tags implies that you want to use grouped processing. However, the top-level tag must specify a top-level group using a GROUP= attribute. // END of ERROR MSG As I understand it I have no need of a group attribute; nor would the group attribute help in this situation. Of course it may be that my understanding is incorrect. :-] PROBLEM: Users fill in a form. They are in a permissioned area. They authenticate their submission by filling in their user username and password. (To be doubly sure that the submitter is the person logged into the site.) The processing page queries the database and sees if the username and password equals the form submitted username and password. If it is a cfmail is sent. If not then an error msg appears. code below: cfquery name=name datasource=aaa SELECT * FROM users WHERE Username='#log_username#' /cfquery cfoutput query=name cfif #username# EQ #form.submittedUsername# AND #password# EQ #form.submittedPassword# cfmail to= from= subject= yadda yadda yadda /cfmail cfelse Your username and password do not match the login records of the current user. /cfif /cfoutput thx, gilbert midonnet __ 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- Another Javascript problem with forms
Ok, I got my two fields to add up and display in another field with this: onchange=window.document.ExpenseForm.TotalAmount#Line#.value=parseFloat(window.document.ExpenseForm.Mileage#Line#.value)+parseFloat(window.document.ExpenseForm.CostOfMeals#Line#.value);addTotals(); Now I'm trying to add up all the TotalAmounts and put it at the bottom of the form. I need to loop through the entire list from 1 to #list# on each onChange and update the GrandTotal. I can't figure out how to loop in Javascript and hand it a dynamic variable name. I tried this: SCRIPT language=Javascript function addTotals() { i = 0 while (i = #GetFormInfo.RecordCount#) { window.document.ExpenseForm.GrandTotalAmount.value=parseFloat(window.document.ExpenseForm.GrandTotalAmount.value)+parseFloat(eval(window.document.ExpenseForm.TotalAmount+i+.value)); i++ } } /SCRIPT But it doesn't work doesn't appear to go through each variable name. How would I do this? 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
How to get directory from full URL?
I am trying to get a fully resolved directory (i.e. http://www.mysite.com/this/is/a/directory/) from a fully resolved URL (i.e. http://www.mysite.com/this/is/a/directory/and_this_is_a_file.cfm) that I am passing in, but I am having difficulty in finding a simple and elegant way to do so. I looked on cflib.org and didn't find any UDF's there...does anyone have a solution for this? Straight code or a UDF would be great. Thanks Pete __ 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: opinions about XSL
zac. can u explain in brief, or give a brief example of taking an xml node(s) and sending that to a structure? is this what you were talking about? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:25 AM To: CF-Talk Subject: Re: opinions about XSL Alex wrote: What other option is there to transform xml docs? convert the xml to dom, do your mods and then back to xml, as a CF developer, it much easier to work IMHO with the xml dom as structures etc than messing around with... apparently one of the problems with XSL as an approach performance wise is something to do with the way that it progressively processes the xml file and has to do some prediction stuff (read more overhead) as it goes... you can do amazing stuff with xml and css, write a style sheet which hides nodes ( display:none;) now if only we could get everyone to upgrade to mozilla.. then life would be so much easier.. back to workarounds, again :-( __ 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: embedding cfmail in a cfoutput -- thx
This is because the cfmail tag uses the cfoutput mechanism internally ( this is why it has the query= atrribute and I think a group= That helps me explain why cfmail requires grouping if nested within cfoutput. Basically because cfmail *is* a cfoutput (of sorts) and nesting cfoutput tags requires grouping in order to be successful. Isaac is also correct in that you don't actually need the cfoutput in your situation. I hadn't looked at the whole picture and was solely pointing out a solution to nesting cfmail. Dave __ 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: Virus Checking
http://devex.macromedia.com/developer/gallery/info.cfm?ID=DB43FE22-4A73-11D5 -83F600508B94F380method=Full Or just use CFEXECUTE to call your own virus scanner (NAV, Panda, whatever) from the command line. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark Stephenson - Evolution Internet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 4:17 AM To: CF-Talk Subject: SOT: Virus Checking Does anyone know of or use a tag that virus checks files that are uploaded?? Regards, Mark Stephenson New Media Director Evolution Internet T: 0870 757 1631 F: 0870 757 1632 W: www.evolutioninternet.co.uk E: [EMAIL PROTECTED] WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. -Original Message- From: John Innit [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 09:01 To: CF-Talk Subject: simple way to email my users. We've been asked to add email alert functionality to a clients web site. The client is a recruitment company and wants to maintain a list of prospective candidates that can be automatically alerted when the company has new job openings. The clients wants to be able to manually add / remove names to the email list and to enable new job seekers to add themselves or modify their settings through their web site. The settings will be quite simple, a new job seeker can specify to receive alerts for 1) Software development jobs 2) Management jobs 3) all jobs When the recruitment company has a new job requirement they will type it up, assign it to a category, and then have an option to send it out to all the prospective job seekers who have requested for alerts in that category. Before the emails are sent out the company wants a list of all the recipients so that they can manually delete or add people from the list before the mailing is kicked off. I realize this is a simple project and there are numerous ways to get this done. What I'm looking are suggestions on how to get this done very quickly ( 2 week time line) I also want to know if there is an existing product we can buy which with some customization can achieve this for us. Would love to receive recommendations, suggestions or even proposals if you have a fast solution. Thanks. __ 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
Forcing Word to open
Is is possible to force a Word document to open with Word outside the browser in an IE only environment? Thanks __ 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: QofQ and dates...
I don't _think_ QofQ does date comparisons ... However... You could probably transform the dates in the original quer(y|ies) into a separate column i.e. convert(int,convert(varchar,Year(datecolumn)) + convert(varchar,month(datecolumn)) + convert(varchar,day(datecolumn))) AS date This would give you something like 20020615 for the 15th of June 2002 ... Since the string is all numbers, it will sort alphabetically ... Or I'm told you can convert a date to an integer or a float value in SQL Server? ... convert(int,mydatecolumn) then the QofQ could sort or filter on that integer value hth S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 should i be able to do date comparisons in a QofQ? i'm using: cfset FilterDate = #dateadd('d', #arguments.AgeArticlesOnHomePage#, now())# !--- filter the recordset --- cfquery name=FilteredBlogArticles dbtype=query Select * from BlogArticles where articledate = #FilterDate# order by articledate DESC /cfquery and getting: Query Of Queries syntax error. Encountered articledate = { at line 3, column 31. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, returned. Also just noticed: SQL Select * from BlogArticles where articledate = {ts apos;2002-09-24 15:12:35apos;} order by articledate DESC Please try the following: tucked away at the bottom of the page thanks for the help, jb. * [EMAIL PROTECTED] * +44 (0)1372 367147 * http://www.era.co.uk/ http://www.era.co.uk/ __ 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: Browser forgetting form values
I'm still trying to figure out what the exact nature of this problem is (i.e., what settings cause what results) as they don't seem to be consistent. But it's most likely a function of your browser settings (in IE, Internet Options | Temporary Internet Files | Settings | Check for newer versions of stored pages). Also, check that you're not sending back page expiration headers. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 5:07 AM To: CF-Talk Subject: RE: Browser forgetting form values CLIENT vars -Original Message- From: Chad [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 18:02 To: CF-Talk Subject: Browser forgetting form values IE use to remember the values that you would put into a form after submission. It does not do that any more.. or is it the CF MX server? If you enter data into a form and submit it I have a CFTRY/CFCATCH that catches a database error. If you use the browser Back button the data is gone from the form Is there any way to keep the data in the form other then session variables? Thanks __ 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
CF-PayPal
Anyone done any PayPal integration with CF? I have a client that wants to allow customers to select PayPal as a payment option in their cart. Any caveats or problems I need to watch out for? Any brilliant pieces of code or workflow? Off the bat I know that not everyone that's going to select this option will have a PayPal account, others will, etc. Thanks. NIck __ 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: How to get directory from full URL?
I am trying to get a fully resolved directory (i.e. http://www.mysite.com/this/is/a/directory/) from a fully resolved URL (i.e. http://www.mysite.com/this/is/a/directory/and_this_is_a_file.cfm) that I am passing in, but I am having difficulty in finding a simple and elegant way to do so. I looked on cflib.org and didn't find any UDF's there...does anyone have a solution for this? Straight code or a UDF would be great. If you just want to remove the file name: Reverse(ListRest(Reverse(fullurl),/)) Or REReplaceNoCase(fullurl,^(.*)/.*$,\1) hth S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ 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: How to get directory from full URL?
Check the CF Function list. getTemplatePath() will do what you want... Stephen - Original Message - From: Pete Ruckelshaus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 4:32 PM Subject: How to get directory from full URL? I am trying to get a fully resolved directory (i.e. http://www.mysite.com/this/is/a/directory/) from a fully resolved URL (i.e. http://www.mysite.com/this/is/a/directory/and_this_is_a_file.cfm) that I am passing in, but I am having difficulty in finding a simple and elegant way to do so. I looked on cflib.org and didn't find any UDF's there...does anyone have a solution for this? Straight code or a UDF would be great. Thanks Pete __ 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: QofQ and dates...
I'm all fixed on this one (Thread QofQ and dates(FIXED))- using CFQUERYPARAM on the date fixes the problem Thanks all! Jb. -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 16:34 To: CF-Talk Subject: Re: QofQ and dates... I don't _think_ QofQ does date comparisons ... However... You could probably transform the dates in the original quer(y|ies) into a separate column i.e. convert(int,convert(varchar,Year(datecolumn)) + convert(varchar,month(datecolumn)) + convert(varchar,day(datecolumn))) AS date This would give you something like 20020615 for the 15th of June 2002 ... Since the string is all numbers, it will sort alphabetically ... Or I'm told you can convert a date to an integer or a float value in SQL Server? ... convert(int,mydatecolumn) then the QofQ could sort or filter on that integer value hth S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 should i be able to do date comparisons in a QofQ? i'm using: cfset FilterDate = #dateadd('d', #arguments.AgeArticlesOnHomePage#, now())# !--- filter the recordset --- cfquery name=FilteredBlogArticles dbtype=query Select * from BlogArticles where articledate = #FilterDate# order by articledate DESC /cfquery and getting: Query Of Queries syntax error. Encountered articledate = { at line 3, column 31. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, returned. Also just noticed: SQL Select * from BlogArticles where articledate = {ts apos;2002-09-24 15:12:35apos;} order by articledate DESC Please try the following: tucked away at the bottom of the page thanks for the help, jb. * [EMAIL PROTECTED] * +44 (0)1372 367147 * http://www.era.co.uk/ http://www.era.co.uk/ __ 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: How to get directory from full URL?
Or if I've got the wrong end of the stick thispath = ListDeleteAt(cgi.script_name,ListLen(cgi.script_name,/),/); Stephen - Original Message - From: Pete Ruckelshaus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 4:32 PM Subject: How to get directory from full URL? I am trying to get a fully resolved directory (i.e. http://www.mysite.com/this/is/a/directory/) from a fully resolved URL (i.e. http://www.mysite.com/this/is/a/directory/and_this_is_a_file.cfm) that I am passing in, but I am having difficulty in finding a simple and elegant way to do so. I looked on cflib.org and didn't find any UDF's there...does anyone have a solution for this? Straight code or a UDF would be great. Thanks Pete __ 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: How to get directory from full URL?
It does and it doesn't. The application I am working on is a databased 404 redirect system, and getTemplatePath did not return any value since it was trying to get the path of the 404 handler rather than the actual bad page (which I can get via the CGI variables).. Pete - Original Message - From: Stephen Moretti [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 11:44 AM Subject: Re: How to get directory from full URL? Check the CF Function list. getTemplatePath() will do what you want... Stephen - Original Message - From: Pete Ruckelshaus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 4:32 PM Subject: How to get directory from full URL? I am trying to get a fully resolved directory (i.e. http://www.mysite.com/this/is/a/directory/) from a fully resolved URL (i.e. http://www.mysite.com/this/is/a/directory/and_this_is_a_file.cfm) that I am passing in, but I am having difficulty in finding a simple and elegant way to do so. I looked on cflib.org and didn't find any UDF's there...does anyone have a solution for this? Straight code or a UDF would be great. Thanks Pete __ 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: Dot monster redux
Death to the Dot Monster! (Long live the dot monster) Jerry Johnson [EMAIL PROTECTED] 09/30/02 06:35PM Turns out that the little dot monster was due to our cfx_imsmail tag not acting like a proper client. Email clients, by definition, are supposed to add a dot to the beginning of a line in an email if the line begins with a dot. Our cfx tag was not doing that but this is corrected in the latest build. Once these lists are updated to iMS 2.4 (will be released tomorrow) the little dot monster will be no more. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 *** Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2002/nominationform.cfm *** 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 __ 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: How to get directory from full URL?
You can use this #Reverse(ListRest(Reverse(HTTP_REFERER),/))#/ -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:05 PM To: CF-Talk Subject: Re: How to get directory from full URL? It does and it doesn't. The application I am working on is a databased 404 redirect system, and getTemplatePath did not return any value since it was trying to get the path of the 404 handler rather than the actual bad page (which I can get via the CGI variables).. Pete - Original Message - From: Stephen Moretti [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 11:44 AM Subject: Re: How to get directory from full URL? Check the CF Function list. getTemplatePath() will do what you want... Stephen - Original Message - From: Pete Ruckelshaus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 4:32 PM Subject: How to get directory from full URL? I am trying to get a fully resolved directory (i.e. http://www.mysite.com/this/is/a/directory/) from a fully resolved URL (i.e. http://www.mysite.com/this/is/a/directory/and_this_is_a_file.cfm) that I am passing in, but I am having difficulty in finding a simple and elegant way to do so. I looked on cflib.org and didn't find any UDF's there...does anyone have a solution for this? Straight code or a UDF would be great. Thanks Pete __ 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: How to get directory from full URL?
Mr. Dealey gets a cookie! Thanks! I never even thought about using reverse() twice... Pete - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 11:39 AM Subject: Re: How to get directory from full URL? I am trying to get a fully resolved directory (i.e. http://www.mysite.com/this/is/a/directory/) from a fully resolved URL (i.e. http://www.mysite.com/this/is/a/directory/and_this_is_a_file.cfm) that I am passing in, but I am having difficulty in finding a simple and elegant way to do so. I looked on cflib.org and didn't find any UDF's there...does anyone have a solution for this? Straight code or a UDF would be great. If you just want to remove the file name: Reverse(ListRest(Reverse(fullurl),/)) Or REReplaceNoCase(fullurl,^(.*)/.*$,\1) hth S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 __ 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: opinions about XSL
Tony Weeg wrote: zac. can u explain in brief, or give a brief example of taking an xml node(s) and sending that to a structure? using an xml parser in cf 5 or native in MX, you can convert an xml document into a dom object... like a tree of objects or structures of structures take an xml document and convert it to dom you end up with an complex array of array's and structyure and variables... a good example is rss.. rss is really simple syndication, except that so many people can't read a spec and produce well formed or valid rss files see this link here for a good working example http://static.userland.com/gems/backend/sampleRss.xml ok... rss should be something like channel title etc item title description /item and so on... but sometimes you get no channel and only items so you can load the xml into a dom under a var called rss and then say rss.channel.item=rss.item then if you have modified the xml structure or transformed it z __ 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: How to get directory from full URL?
Reverse(ListRest(Reverse(fullurl),/)) Oooh, that's just durn purty. Kevin Graeme __ 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: How to get directory from full URL?
cfset fullyresolvedURL=http://www.mysite.com/this/is/a/directory/and_this_is_a_fi le.cfm cfset fullyresolvedDir=ListDeleteAt(fullyresolvedURL,ListLen(fullyresolvedURL,/) ,/) -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:33 AM To: CF-Talk Subject: How to get directory from full URL? I am trying to get a fully resolved directory (i.e. http://www.mysite.com/this/is/a/directory/) from a fully resolved URL (i.e. http://www.mysite.com/this/is/a/directory/and_this_is_a_file.c fm) that I am passing in, but I am having difficulty in finding a simple and elegant way to do so. I looked on cflib.org and didn't find any UDF's there...does anyone have a solution for this? Straight code or a UDF would be great. __ 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: Forcing Word to open
Yes, I wished more documents would do that, I hate acrobat/word/excel in the browser... Have the link refer to a template.cfm, which contains: CFHEADER NAME=Content-Disposition VALUE=attachment;filename=filenameofworddocument.doc CFCONTENT TYPE=application/msword DELETEFILE=no FILE=pathAndFilenameofworddocument.doc RESET=Yes __ 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: How to get directory from full URL?
Reverse(ListRest(Reverse(fullurl),/)) Oooh, that's just durn purty. Double negative?? You're all sick and twisted individuals ;o) Why not just take the last item off the end of the list? ListDeleteAt(fullurl,ListLen(fullurl,/),/) Having had a look through the various CF functions, if you're after a real physical path and not just a chunk of the URL, then you're going to have to know where the files are in relation to your 404 files. Stephen __ 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: opinions about XSL
convert the xml to dom, do your mods and then back to xml, as a CF developer, it much easier to work IMHO with the xml dom as structures etc than messing around with... DOM is nice, but when you start using large XML files, the DOM is a waste of memory and it is slow - if your luck enough to fit the whole tree into memeory. Its a waste especially if you only need a part of an XML document. XML - XSL (with SAX) - DOM I don't know of a more elegant way to do it. The DOM is great, wonderful, and fabulous for small documents where you need access to the all the nodes. XSL is also great to do XML - PDF transformations (lookup Formatting Objects) I am speaking from the server side btw. I am very *bias* though, here is a link to my free open source XSL IDE http://treebeard.sourceforge.net Cheers, Rob -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 8:25 AM To: CF-Talk Subject: Re: opinions about XSL Alex wrote: What other option is there to transform xml docs? convert the xml to dom, do your mods and then back to xml, as a CF developer, it much easier to work IMHO with the xml dom as structures etc than messing around with... apparently one of the problems with XSL as an approach performance wise is something to do with the way that it progressively processes the xml file and has to do some prediction stuff (read more overhead) as it goes... you can do amazing stuff with xml and css, write a style sheet which hides nodes ( display:none;) now if only we could get everyone to upgrade to mozilla.. then life would be so much easier.. back to workarounds, again :-( __ 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
MS Access Date format
I have a CFGrid where I'd like to control the format the dates are displayed in. I believe my only choice would be to format the field in the query, but I can't get the syntax! Anyone know how to format a date in access SQL? __ 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
CF Engine Posting to SQL TWICE
Ok, I have been doing CF now for over 5 years and I have never seen this happen before and would like a fresh pair of eyes. Form submits Category and Placement. Action page run the queries and then stops. The debug information shows the queries and the information inserted only 1 time. But the database, received 2 rows of the exact same data. A SQL Trace shows the queries running 2 times as if they were in a loop, approx 20 ms apart. The code reads: cfquery name=Renumber datasource=#DSN# update ArticleCategory set Placement = Placement+1 where Placement = '#Placement#' /cfquery cfquery name=InsertArticleCategory datasource=#DSN# insert into ArticleCategory(ArticleCategory, Placement) values('#form.ArticleCategory#', '#form.Placement#') /cfquery The debug shows: Renumber (Records=0, Time=0ms) SQL = update ArticleCategory set Placement = Placement+1 where Placement = '1' InsertArticleCategory (Records=0, Time=10ms) SQL = insert into ArticleCategory(ArticleCategory, Placement) values('test3', '1') But the Database shows: ID CategoryPlacement 18 test3 2 19 test3 1 It even renumber the first entry correctly by setting the placement=placement+1 The code is only running once. Why is the CF engine processing it twice. In addition, this does not happen 100% of the time. Rather, it is about 50-60% of the time. If I run the debug queries in Query Analyzer, it only does the operation 1 time. Therefore I am pointing at the CF engine. We are running CF 5 on Win2k SP 2, IIS. Any help would be appreciated. __ 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: Adding two fields and displaying in a third
At 12:48 PM 9/30/02 -0400, S. Isaac Dealey wrote: you could also use parseInt(string) or parseFloat(string) although if it doesn't find an integer or a string at the beginning of the string it will return NaN rather than . Also if there are non-numeric values on the end of the string it will remove them. Ok, I got my two fields to add up and display in another field with this: onchange=window.document.ExpenseForm.TotalAmount#Line#.value=parseFloat(window.document.ExpenseForm.Mileage#Line#.value)+parseFloat(window.document.ExpenseForm.CostOfMeals#Line#.value);addTotals(); Now I'm trying to add up all the TotalAmounts and put it at the bottom of the form. I need to loop through the entire list from 1 to #list# on each onChange and update the GrandTotal. I can't figure out how to loop in Javascript and hand it a dynamic variable name. I tried this: SCRIPT language=Javascript function addTotals() { i = 0 while (i = #GetFormInfo.RecordCount#) { window.document.ExpenseForm.GrandTotalAmount.value=parseFloat(window.document.ExpenseForm.GrandTotalAmount.value)+parseFloat(eval(window.document.ExpenseForm.TotalAmount+i+.value)); i++ } } /SCRIPT But it doesn't work doesn't appear to go through each variable name. How would I do this? 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: CF Engine Posting to SQL TWICE
How about something like the form being accidently submitted twice c/o a JS submit?? Stephen - Original Message - From: Vance Duke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 6:20 PM Subject: CF Engine Posting to SQL TWICE Ok, I have been doing CF now for over 5 years and I have never seen this happen before and would like a fresh pair of eyes. Form submits Category and Placement. Action page run the queries and then stops. The debug information shows the queries and the information inserted only 1 time. But the database, received 2 rows of the exact same data. A SQL Trace shows the queries running 2 times as if they were in a loop, approx 20 ms apart. The code reads: cfquery name=Renumber datasource=#DSN# update ArticleCategory set Placement = Placement+1 where Placement = '#Placement#' /cfquery cfquery name=InsertArticleCategory datasource=#DSN# insert into ArticleCategory(ArticleCategory, Placement) values('#form.ArticleCategory#', '#form.Placement#') /cfquery The debug shows: Renumber (Records=0, Time=0ms) SQL = update ArticleCategory set Placement = Placement+1 where Placement = '1' InsertArticleCategory (Records=0, Time=10ms) SQL = insert into ArticleCategory(ArticleCategory, Placement) values('test3', '1') But the Database shows: ID CategoryPlacement 18 test3 2 19 test3 1 It even renumber the first entry correctly by setting the placement=placement+1 The code is only running once. Why is the CF engine processing it twice. In addition, this does not happen 100% of the time. Rather, it is about 50-60% of the time. If I run the debug queries in Query Analyzer, it only does the operation 1 time. Therefore I am pointing at the CF engine. We are running CF 5 on Win2k SP 2, IIS. Any help would be appreciated. __ 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: How to get directory from full URL?
Actually, the way that works with testing is: #Reverse(ListRest(Reverse(PATH_TRANSLATED),\\))# You have reversed the string, therefore, you have reversed the delimiter. Just my two cents... Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 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 e-mail listed above. -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:34 AM To: CF-Talk Subject: RE: How to get directory from full URL? Reverse(ListRest(Reverse(fullurl),/)) Oooh, that's just durn purty. Kevin Graeme __ 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: QofQ and dates...
QofQ can do date comparisons. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:34 AM To: CF-Talk Subject: Re: QofQ and dates... I don't _think_ QofQ does date comparisons ... However... You could probably transform the dates in the original quer(y|ies) into a separate column i.e. convert(int,convert(varchar,Year(datecolumn)) + convert(varchar,month(datecolumn)) + convert(varchar,day(datecolumn))) AS date __ 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: MS Access Date format
Disregard, found it in MS Knowledge Base. :-) format('mm-dd-'). -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:19 PM To: CF-Talk Subject: MS Access Date format I have a CFGrid where I'd like to control the format the dates are displayed in. I believe my only choice would be to format the field in the query, but I can't get the syntax! Anyone know how to format a date in access SQL? __ 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 Engine Posting to SQL TWICE
I have seen duplicates in the past. I could only get it to happen on SGI boxes running Netscape. I could never get a double submit to happen on any other platform. So I added this to my submit buttons and have not had any trouble since. input type=button name=Submit value=Place Order onclick=if(this.value == 'Place Order') this.form.submit(); this.value='Please Wait.'; / -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:34 PM To: CF-Talk Subject: Re: CF Engine Posting to SQL TWICE How about something like the form being accidently submitted twice c/o a JS submit?? Stephen - Original Message - From: Vance Duke [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 6:20 PM Subject: CF Engine Posting to SQL TWICE Ok, I have been doing CF now for over 5 years and I have never seen this happen before and would like a fresh pair of eyes. Form submits Category and Placement. Action page run the queries and then stops. The debug information shows the queries and the information inserted only 1 time. But the database, received 2 rows of the exact same data. A SQL Trace shows the queries running 2 times as if they were in a loop, approx 20 ms apart. The code reads: cfquery name=Renumber datasource=#DSN# update ArticleCategory set Placement = Placement+1 where Placement = '#Placement#' /cfquery cfquery name=InsertArticleCategory datasource=#DSN# insert into ArticleCategory(ArticleCategory, Placement) values('#form.ArticleCategory#', '#form.Placement#') /cfquery The debug shows: Renumber (Records=0, Time=0ms) SQL = update ArticleCategory set Placement = Placement+1 where Placement = '1' InsertArticleCategory (Records=0, Time=10ms) SQL = insert into ArticleCategory(ArticleCategory, Placement) values('test3', '1') But the Database shows: ID CategoryPlacement 18 test3 2 19 test3 1 It even renumber the first entry correctly by setting the placement=placement+1 The code is only running once. Why is the CF engine processing it twice. In addition, this does not happen 100% of the time. Rather, it is about 50-60% of the time. If I run the debug queries in Query Analyzer, it only does the operation 1 time. Therefore I am pointing at the CF engine. We are running CF 5 on Win2k SP 2, IIS. Any help would be appreciated. __ 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: QofQ and dates...
Oh cool, thanks for the rejoinder. :) QofQ can do date comparisons. === Raymond Camden, ColdFusion Jedi Master for Hire Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:34 AM To: CF-Talk Subject: Re: QofQ and dates... I don't _think_ QofQ does date comparisons ... However... You could probably transform the dates in the original quer(y|ies) into a separate column i.e. convert(int,convert(varchar,Year(datecolumn)) + convert(varchar,month(datecolumn)) + convert(varchar,day(datecolumn))) AS date __ 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: How to get directory from full URL?
Pardon? Reversed the delimiter? Reverse simply changes the order of the characters. It doesn't hold them up to a mirror and get new characters. Reverse(/) = / Reverse(\) = \ Reverse(/\) = \/ Reverse(\/) = /\ -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:34 PM To: CF-Talk Subject: RE: How to get directory from full URL? Actually, the way that works with testing is: #Reverse(ListRest(Reverse(PATH_TRANSLATED),\\))# You have reversed the string, therefore, you have reversed the delimiter. Just my two cents... Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 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 e-mail listed above. -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:34 AM To: CF-Talk Subject: RE: How to get directory from full URL? Reverse(ListRest(Reverse(fullurl),/)) Oooh, that's just durn purty. Kevin Graeme __ 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: MS Access Date format
CreateODBCDate(date) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:19 PM To: CF-Talk Subject: MS Access Date format I have a CFGrid where I'd like to control the format the dates are displayed in. I believe my only choice would be to format the field in the query, but I can't get the syntax! Anyone know how to format a date in access SQL? __ 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: SQL Text question from a beginner
No worries... I'm j/k with you. I've certainly sent out my fair share of emails while under the influence of heavy doses of caffeine 8^). The ever nice, Mosh 8^) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 9:31 AM To: CF-Talk Subject: RE: SQL Text question from a beginner hey, it was late, and I had been looking at cf and xsl code for like 8 hours straight.. ;) be nice. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ 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: SQL Text question from a beginner
s'all good mang.too bad I cant jive to well with java kinda prefer mahuang and good old thc :) ..tony -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 2:02 PM To: CF-Talk Subject: RE: SQL Text question from a beginner No worries... I'm j/k with you. I've certainly sent out my fair share of emails while under the influence of heavy doses of caffeine 8^). The ever nice, Mosh 8^) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 9:31 AM To: CF-Talk Subject: RE: SQL Text question from a beginner hey, it was late, and I had been looking at cf and xsl code for like 8 hours straight.. ;) be nice. ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:38 AM To: CF-Talk Subject: RE: SQL Text question from a beginner A whopping 16 characters? 8^) Actually, according to my SQL Server reference, the TEXT datatype can store 2,147,483,647 bytes. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:11 AM To: CF-Talk Subject: RE: SQL Text question from a beginner look at the datatype of text it holds 16 bytes of data, i believe. hth tony -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:04 AM To: CF-Talk Subject: SQL Text question from a beginner I am new to web development (if I can call what I am doing web development) and have a sql question and was hoping someone could point me in the right direction. I have put together this data driven website and found access to be insufficient to hold as much text as I wished in a description field. Thus I moved to sql, but am finding the 4000 character limitation for varchar to be a hindrance and not much better than the 255 character limit in access. I found a link a couple minutes ago basically stating I was pretty much limited to 8000 characters no matter the data type I pick save for some concatenation maneuver. So I am wondering how I can just put a blob of text into the database. I can't be the only guy who wants to store a couple pages of text in a field in a database so that it can be queried to populate a web page can I? On it's face it would seem that if I should be able to define my own data type to accommodate my needs? What is the right direction? Thanks, John __ 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: CF Engine Posting to SQL TWICE
I've seen this before. Normally it's because the form's onSubmit event is handled, and the function being called does a form.submit() but doesn't return false to halt further processing. So in effect the form is submitted twice. i.e. script function CheckForm() { if (!Valid) { return false; } document.MyForm.submit(); } /script form name=MyForm action=act_form.cfm method=post onsubmit=CheckForm(); /form To fix this, add a return false; after the document.MyForm.submit(); line in the function. HTH Shawn Grover -Original Message- From: Vance Duke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:20 AM To: CF-Talk Subject: CF Engine Posting to SQL TWICE Ok, I have been doing CF now for over 5 years and I have never seen this happen before and would like a fresh pair of eyes. Form submits Category and Placement. Action page run the queries and then stops. The debug information shows the queries and the information inserted only 1 time. But the database, received 2 rows of the exact same data. A SQL Trace shows the queries running 2 times as if they were in a loop, approx 20 ms apart. The code reads: cfquery name=Renumber datasource=#DSN# update ArticleCategory set Placement = Placement+1 where Placement = '#Placement#' /cfquery cfquery name=InsertArticleCategory datasource=#DSN# insert into ArticleCategory(ArticleCategory, Placement) values('#form.ArticleCategory#', '#form.Placement#') /cfquery The debug shows: Renumber (Records=0, Time=0ms) SQL = update ArticleCategory set Placement = Placement+1 where Placement = '1' InsertArticleCategory (Records=0, Time=10ms) SQL = insert into ArticleCategory(ArticleCategory, Placement) values('test3', '1') But the Database shows: ID CategoryPlacement 18 test3 2 19 test3 1 It even renumber the first entry correctly by setting the placement=placement+1 The code is only running once. Why is the CF engine processing it twice. In addition, this does not happen 100% of the time. Rather, it is about 50-60% of the time. If I run the debug queries in Query Analyzer, it only does the operation 1 time. Therefore I am pointing at the CF engine. We are running CF 5 on Win2k SP 2, IIS. Any help would be appreciated. __ 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 Engine Posting to SQL TWICE
Does the web server log show one hit or two? Kore Peterson Database Development Specialist SEH - Minneapolis 612.758.6739 Vance Duke vance.duke@imagi To: CF-Talk [EMAIL PROTECTED] nuity.com cc: Subject: CF Engine Posting to SQL TWICE 10/01/2002 12:20 PM Please respond to cf-talk Ok, I have been doing CF now for over 5 years and I have never seen this happen before and would like a fresh pair of eyes. Form submits Category and Placement. Action page run the queries and then stops. The debug information shows the queries and the information inserted only 1 time. But the database, received 2 rows of the exact same data. A SQL Trace shows the queries running 2 times as if they were in a loop, approx 20 ms apart. The code reads: cfquery name=Renumber datasource=#DSN# update ArticleCategory set Placement = Placement+1 where Placement = '#Placement#' /cfquery cfquery name=InsertArticleCategory datasource=#DSN# insert into ArticleCategory(ArticleCategory, Placement) values('#form.ArticleCategory#', '#form.Placement#') /cfquery The debug shows: Renumber (Records=0, Time=0ms) SQL = update ArticleCategory set Placement = Placement+1 where Placement = '1' InsertArticleCategory (Records=0, Time=10ms) SQL = insert into ArticleCategory(ArticleCategory, Placement) values('test3', '1') But the Database shows: ID CategoryPlacement 18 test3 2 19 test3 1 It even renumber the first entry correctly by setting the placement=placement+1 The code is only running once. Why is the CF engine processing it twice. In addition, this does not happen 100% of the time. Rather, it is about 50-60% of the time. If I run the debug queries in Query Analyzer, it only does the operation 1 time. Therefore I am pointing at the CF engine. We are running CF 5 on Win2k SP 2, IIS. Any help would be appreciated. __ 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
debit card processing only
Is it possible to help with a company that processes debit card transactions online - like switch and most importantly solo Which is used in the UK? Kodjo Ackah Principal Consultant Concrete Media Ltd 32 Great Sutton Street Clerkenwell London, EC1V 0DX Tel:+44 (0)20 7251 8090 Fax: +44 (0)20 7251 8780 Mobile: +44 (0)7748 79 1038 Office Location: http://www.streetmap.co.uk/streetmap.dll?G2M?X=531852 http://www.streetmap.co.uk/streetmap.dll?G2M?X=531852Y=182204A=YZ=1 Y=182204A=YZ=1 __ 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: How to get directory from full URL?
And here is my example, based on the question at hand: Path_Translated = F:\Websites\4ComPart\IMT_GetsResults\getReturns.cfm Reverse(Path_Translated) = mfc.snruteRteg\stluseRsteG_TMI\traPmoC4\setisbeW\:F Reverse(ListRest(Reverse(PATH_TRANSLATED),\\)) = F:\Websites\4ComPart\IMT_GetsResults Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 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 e-mail listed above. -Original Message- From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:56 PM To: CF-Talk Subject: RE: How to get directory from full URL? Pardon? Reversed the delimiter? Reverse simply changes the order of the characters. It doesn't hold them up to a mirror and get new characters. Reverse(/) = / Reverse(\) = \ Reverse(/\) = \/ Reverse(\/) = /\ -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 1:34 PM To: CF-Talk Subject: RE: How to get directory from full URL? Actually, the way that works with testing is: #Reverse(ListRest(Reverse(PATH_TRANSLATED),\\))# You have reversed the string, therefore, you have reversed the delimiter. Just my two cents... Larry Juncker Senior Cold fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] (515) 574-2122 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 e-mail listed above. -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:34 AM To: CF-Talk Subject: RE: How to get directory from full URL? Reverse(ListRest(Reverse(fullurl),/)) Oooh, that's just durn purty. Kevin Graeme __ 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: Forcing Word to open
Actually, there's no way (that I know of) to FORCE the downloaded file to open word. That's really a function of the browser settings. For example, with IE, you can force all word files to be saved to disk instead of opening in Word. You would do this through the OS (File Options). -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:55 PM To: CF-Talk Subject: RE: Forcing Word to open Yes, I wished more documents would do that, I hate acrobat/word/excel in the browser... Have the link refer to a template.cfm, which contains: CFHEADER NAME=Content-Disposition VALUE=attachment;filename=filenameofworddocument.doc CFCONTENT TYPE=application/msword DELETEFILE=no FILE=pathAndFilenameofworddocument.doc RESET=Yes __ 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
OT: Flash Problem
I've encountered a pretty strange problem in Flash MX and I can't seem to figure out what's wrong. I started what's going to be a fairly large movie in Flash and I've gone through the process of creating all my library images, etc. for the project and am in the process of putting it all together now, but after a certain point (2500 frames appx. and 165 library items) whenever I try to place any object into the document it places the same item on-screen - the item it keeps placing was the last one I used in the timeline. No matter what object I try to place - Button, Graphic, Movie, Sound, etc. .. it always places the same thing on the stage. Anyone have any clue what's up here? Joshua Miller [EMAIL PROTECTED] __ 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