help on character set for cfmail

2006-12-22 Thread alex poyaoan
Hi everybody... we set up a mailing system that sends headlines to many people but in different languages.. for the english one's we got no problem but the SPANISH - FRENCH -ITALIAN sometimes doesn't see characters with accents.. is it due to the declared character set? which currently we are

Re: SQL Injection Script

2006-12-22 Thread Robertson-Ravo, Neil (RX)
Doesn't CF7 provide out of the box features to stop this from happening. I This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is

Re: SQL Injection Script

2006-12-22 Thread Jochem van Dieten
Rey Bango wrote: and the value of the query param translates to: ')script id=8000 / But when I go to use it in the code, I'm getting this: URL Parameters: C1=') Is that all you get, or is that all your browsers shows you? Jochem

Re: help on character set for cfmail

2006-12-22 Thread Paul Hastings
alex poyaoan wrote: accents.. is it due to the declared character set? which currently we are using UTF-8 we also tried using this characters charset=ISO-8859-1 but it gives us the same error... is the non-english text ok before you send it? is your data indeed encoded as unicode? what ver of

Re: help on character set for cfmail

2006-12-22 Thread alex poyaoan
alex poyaoan wrote: accents.. is it due to the declared character set? which currently we are using UTF-8 we also tried using this characters charset=ISO-8859-1 but it gives us the same error... is the non-english text ok before you send it? is your data indeed encoded as unicode? what ver

Re: help on character set for cfmail

2006-12-22 Thread Paul Hastings
alex poyaoan wrote: the non english ones before sending is ok the cf version is mx7 and is sent you can dump the out ok via cf? as plain text.. sorry but couldn't understand encoded as unicode... what encoding for the data? where's the data coming from?

Re: help on character set for cfmail

2006-12-22 Thread alex poyaoan
alex poyaoan wrote: the non english ones before sending is ok the cf version is mx7 and is sent you can dump the out ok via cf? as plain text.. sorry but couldn't understand encoded as unicode... what encoding for the data? where's the data coming from? the data is coming from a plain text

Re: help on character set for cfmail

2006-12-22 Thread alex poyaoan
alex poyaoan wrote: the non english ones before sending is ok the cf version is mx7 and is sent you can dump the out ok via cf? as plain text.. sorry but couldn't understand encoded as unicode... what encoding for the data? where's the data coming from? the data is coming

Re: help on character set for cfmail

2006-12-22 Thread Paul Hastings
alex poyaoan wrote: the data is coming from a plain text document copied and pasted on a form and is that page utf-8 encoded? can you send me a test email? ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe

Re: help on character set for cfmail

2006-12-22 Thread Paul Hastings
alex poyaoan wrote: forgot to include that we test the accents and send it to our emails and it all goes right but sending it to people specially in africa some of them doesn't see it.. is there a setting from their email programs for it .. any chance their mail clients can't handle unicode?

Re: help on character set for cfmail

2006-12-22 Thread alex poyaoan
alex poyaoan wrote: the data is coming from a plain text document copied and pasted on a form and is that page utf-8 encoded? can you send me a test email? Yes it is utf-8 encoded yes i can send you an email or what it looks like on the clients emails ... can you give me your email address

Re: help on character set for cfmail

2006-12-22 Thread alex poyaoan
alex poyaoan wrote: the data is coming from a plain text document copied and pasted on a form and is that page utf-8 encoded? can you send me a test email? Yes it is utf-8 encoded yes i can send you an email or what it looks like on the clients emails ... can you give me your email

CFIF? Still not solved :(

2006-12-22 Thread Doug Brown
Arghhh.. as Captain Jack Sparrow would say. Anybody from the daytime crew wanna shot at this? I cannot seem to write a good enough cfif statement to get this to insert properly. If user does not fill in (asking1) and fills in (asking 2) then asking2 gets inserted. If user fills in (asking1),

Re: CFIF? Still not solved :(

2006-12-22 Thread Adrian
Something like this? cfif len(asking1) Insert asking 1 cfelseif(len(asking2)) Insert asking 2 cfelse Insert default /cfif On 22/12/06, Doug Brown [EMAIL PROTECTED] wrote: Arghhh.. as Captain Jack Sparrow would say. Anybody from the daytime crew wanna shot at this? I cannot

Re: SQL Injection Script

2006-12-22 Thread Will Tomlinson
Doesn't CF7 provide out of the box features to stop this from happening. Read the docs, I'll bet the answer to your question lies there. Hahahahaha! Couldn't help it Neil. :) Will ~| Create robust enterprise, web RIAs.

Re: SQL Injection Script

2006-12-22 Thread Robertson-Ravo, Neil (RX)
Lol, it was rhetorical... This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is

Re: CFIF? Still not solved :(

2006-12-22 Thread Doug Brown
Nope...asking1 will insert, but if asking2 is filled in instead, it will not insert. Doug B. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2

Re: CFIF? Still not solved :(

2006-12-22 Thread Doug Brown
Ok. I finally figured it out. I did it off the value of the radio buttons instead. Thanks for all the help, I think I just needed to sleep on it. cfif #Trim(arguments.price_option)# eq negotiable price = #arguments.asking1#, /cfif cfif #Trim(arguments.price_option)# eq fixed

(SOLVED)CFIF?

2006-12-22 Thread Doug Brown
Doug B. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive:

Damnitt!!!! Was CFIF?

2006-12-22 Thread Doug Brown
Well, I thought I had it solved. If I put $20.00 in the asking1 field and click update, the form comes back as it should with $20.00 showing. If I click update again without changing anything, the form comes back with $0.00 showing in the field. Here is what I did, am I not doing something right

Re: Damnitt!!!! Was CFIF?

2006-12-22 Thread Doug Brown
And here is the radio button and text field input type=radio name=price_option value=negotiable onclick=document.updClassified.asking2.value = '';document.updClassified.asking1.focus(); cfif classAdDetails.price_option eq negotiablechecked/cfif input type=text name=asking1 size=8 value=cfif

RegEx / Smartermail

2006-12-22 Thread Coldfusion
Excuse the cross-post from cf-community but was suggested to post here as well: --- Anyone using Smartermail and use RegEx in Content Filtering? If so, can you provide an example. I am not certain I can use Regex as there is nothing in the docs. TIA!

Re: SQL Injection Script

2006-12-22 Thread Rey Bango
Good morning, Jochem. I used HTMLEditFormat() and it finally pulled out the full value as opposed to the truncated one. Rey... Jochem van Dieten wrote: Rey Bango wrote: and the value of the query param translates to: ')script id=8000 / But when I go to use it in the code, I'm getting

Re: SQL Injection Script

2006-12-22 Thread Rey Bango
I'm using CFMX 6.1. :o) Robertson-Ravo, Neil (RX) wrote: Doesn't CF7 provide out of the box features to stop this from happening. I This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business,

newbie: Tools to use with MySQL

2006-12-22 Thread Dwayne Cole
I feel like i did with eclipse 2 years ago. When I made the switch i was like a baby in a candy store. I'm now ready to switch from Access to mySQL. Yeah, yeah what took me so long? I had my reasons but now I'm ready and I was wondering if anyone could provide me with some recommended

Re: newbie: Tools to use with MySQL

2006-12-22 Thread Will Tomlinson
I'm now ready to switch from Access to mySQL. Yeah, yeah what took me so long? I had my reasons but now I'm ready and I was wondering if anyone could provide me with some recommended administration tools. I've always liked Navicat for mySQL admin: www.navicat.com The free MySQL

RE: newbie: Tools to use with MySQL

2006-12-22 Thread Joshua Cyr
I use the free version of EMS MySQL manager. Works Very well. I prefer over phpmysql and the like. http://www.sqlmanager.net/products/mysql/manager Joshua Cyr Savvy Software 866.870.6358 www.besavvy.com -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: Friday,

RE: newbie: Tools to use with MySQL

2006-12-22 Thread Ray Champagne
Navicat! http://www.navicat.com/ -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: Friday, December 22, 2006 9:47 AM To: CF-Talk Subject: newbie: Tools to use with MySQL I feel like i did with eclipse 2 years ago. When I made the switch i was like a baby

RE: newbie: Tools to use with MySQL

2006-12-22 Thread Coldfusion
NaviCat for MySQL is one of the best GUI interfaces for managing all aspects of MySQL Databases. I still use Homesite+ for CF Development. I tried CFEclipse and not sold on it yet as my core Editor. -Original Message- From: Dwayne Cole [mailto:[EMAIL PROTECTED] Sent: Friday, December

RE: newbie: Tools to use with MySQL

2006-12-22 Thread Dwayne Cole
I still use Homesite+ for CF Development. I tried CFEclipse and not sold on it yet as my core Editor. You don't know what you are missing. Particularly if your spend most of your time looking at the code vs the GUI. But to each his own and I sure you have your reasons. We all do.

RE: newbie: Tools to use with MySQL

2006-12-22 Thread Rick Faircloth
A second for Navicat... it's $100 (if the price is still the same), but when I first began to use MySQL a few years ago, it made the switch from Access a *lot* easier. The interface is very intuitive and it's a complete management tool for your MySQL DB's, including scheduled backup. Highly

Re: CFIF?

2006-12-22 Thread Claude Schneegans
How about this: CFPARAM name=ARGUMENTS.asking1 DEFAULT= CFPARAM name=ARGUMENTS.asking2 DEFAULT= CFSET price = listFirst(#ARGUMENTS.asking1#,#ARGUMENTS.asking1#,0) This way (and since CF ignores empty elements in lists), price will take the first non empty value, and 0 if both are empty. --

Cartweaver for services

2006-12-22 Thread j s
I use cartweaver for products but does anyone know of a similar product for services and invoicing. For example a service company that wants to give it's customer an area for them to look over their invoice and payment history. Hate to build this from scratch.

Re: SQL Injection Script

2006-12-22 Thread Claude Schneegans
I've tried all different types of variations to ensure that the passed data is preserved but its being truncated somehow. How do you know it is truncated? If you just output it without using HTMLEditFormat(), the script ... tag wont be displayed. -- ___

RE: Javascript help

2006-12-22 Thread Dave Watts
Well since we are being smart asses... the question was how can I clear either one when I click on any one of the radio buttons. One person's smart ass is another's stickler for accuracy. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest

Re: SQL Injection Script

2006-12-22 Thread Claude Schneegans
I used HTMLEditFormat() and it finally pulled out I SWEAR I didn't read your last message when I answered the first ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address:

Re: SQL Injection Script

2006-12-22 Thread Rey Bango
Hi Claude, The safeText() method that I pass the url param to fails if I don't wrap the url param in HTMLEditFormat(). So something really hokey is happening and my only assumption is that its being truncated at some point. So unfortunately, its not only relegated to output but also

RE: Javascript help

2006-12-22 Thread Bobby Hartsfield
And here I was thinking you had no sense of humor ;-) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, December 22, 2006 10:43 AM To: CF-Talk Subject: RE: Javascript help Well since we are being smart asses... the question was how can I clear either one

Re: newbie: Tools to use with MySQL

2006-12-22 Thread Jim Wright
I'll throw out my vote for Aqua Data Studio. It is especially good if you have multiple database engines that you manage (SQL Server, MySQL, Postgres, etc), and want a fairly consistent interface to deal with all of them. It has a very nice dump feature, which allows you to dump table

Re: newbie: Tools to use with MySQL

2006-12-22 Thread Jochem van Dieten
Dwayne Cole wrote: I co-locate and every time I need to work with a datasource I download the MSAccess file to my local machine, make the changes then quickly upload the updated version.It's akward. Particularly considering that I manage as many as 25 live data sources (all with the

Re: newbie: Tools to use with MySQL

2006-12-22 Thread Jim Wright
Jochem van Dieten wrote: If you need to change the database, you send it the appropriate SQL command. Either by typing the command yourself, or by using a GUI that translates your clicks to the appropriate command and sends it. And while I would recommend getting away from Access, you

RE: newbie: Tools to use with MySQL

2006-12-22 Thread Dwayne Cole
For me Navicate it is. I downloaded the trial and already I can't wait for the weekend to begin playing with it thanks. Looks like I’m going to enjoy my Christmas toys as much as my sons. Now I What are the top 7 things I should do when I set up mySQL server on my collocated box? I remember

Re: newbie: Tools to use with MySQL

2006-12-22 Thread Dwayne Cole
Thanks Jochem, you have always provided me with extraordinary advice regarding database and ODBC issues. But I need to stop playing around and make this switch, I think I have outgrown MS Access, or I like that I have. One of my MS Access database is 21 megs. It has more than 60 tables and in

Re: Damnitt!!!! Was CFIF?

2006-12-22 Thread Robertson-Ravo, Neil (RX)
You need to stop putting # in your code where it is not required. You do require them in any of the code you posted below. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in

Re: Damnitt!!!! Was CFIF?

2006-12-22 Thread Robertson-Ravo, Neil (RX)
Should read.. Do NOT require! This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is

Utf-8 mysql and hostmysite

2006-12-22 Thread Joshua Cyr
Anyone using hostmysite mysql and have utf-8 working right? The database I can connect to and fix, but the datasource itself I thin is amis. I am trying to communicate my needs, but they are not getting it (yet). Just wondering if others have this working well. Joshua Cyr Savvy Software

AjaxCFC bug?

2006-12-22 Thread Brad Wood
So I have found a bug in AjaxCFC and I am not sure if it is known or not. When passing more than 9 inputs into your AJAX call, they are sorted wrong like so: Input 0 Input 1 Input 10 Input 11 Input 12 Input 13 Input 2 Input 3 Input 4 Input 5 Input 6 Input 7 Input 8 Input 9

Re: MX 6.1 MySQL 5 Datasource issues

2006-12-22 Thread Cutter (CFRelated)
You can try the 3.1.x Connector/J with MX 6.1, but it didn't work at all for me, whereas the 5.x worked fine. Cutter __ http://blog.cutterscrossing.com Adrian Moreno wrote: Get the 3.1.10 Connector/J: http://www.adobe.com/go/6ef0253 Go to MySQL.com and find a link to the latest

Re: Damnitt!!!! Was CFIF?

2006-12-22 Thread Charlie Griefer
they are needed here: price = #Val(arguments.asking1)# and price = #arguments.asking2# just sayin' :) On 12/22/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Should read.. Do NOT require! -Original Message- From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Fri Dec 22

Re: Damnitt!!!! Was CFIF?

2006-12-22 Thread Robertson-Ravo, Neil (RX)
I will give you that, I didn't notice they were outputs! This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may

RE: newbie: Tools to use with MySQL

2006-12-22 Thread Michael E. Carluen
Dwayne, The mySQL Administrator http://www.mysql.com/products/tools/administrator/ allows you to backup and restore your schemas to and from your remote server and local machine. And well, backup files generated from mySQL are .sql files that are pretty much self-contained... you just need to

Fusebox plugin for CFEclipse?

2006-12-22 Thread Ryan Stille
Has anyone got the fusebox plugin working with CFEclipse? I extracted it into my plugins directory but I didn't see any changes within CFEclipse. I'd really like to be able to right click on an include tag and be able to edit the referenced template right from there. Don't know if the

Flash Form cfformgroup layout question

2006-12-22 Thread Paul Henderson
(Sorry for the repost originally sent with a blank subject in error) I have a rookie level flash form question. When I create a horizontal cfformgroup it automatically inserts a left margin of approx 40-50 pixels. Below is the code I'm using. The only attributes that I think could control

Re: Damnitt!!!! Was CFIF?

2006-12-22 Thread Doug Brown
Thanks for the help. Actually the problem was that I was using a dollarFormat() on the text field in my edit page. Thanks for letting me know about the # signs. Doug B. ~| Create robust enterprise, web RIAs. Upgrade

RE: Fusebox plugin for CFEclipse?

2006-12-22 Thread Sandra Clark
The only FB plugin I had ever heard of only supports FB3 (which is not xml). Is this another plugin? Sandra Clark == http://www.shayna.com Training in Cascading Style Sheets and Accessibility -Original Message- From: Ryan Stille [mailto:[EMAIL PROTECTED]

UPS API

2006-12-22 Thread Ciliotta, Mario
Hi all, I was wondering if someone would be willing to share with me the code or an example of a call to UPS and successful generation of the label. I have been able to call the UPS API and transmit my xml request but I cannot seem to be able to generate the gif image of the shipping label.

Re: Flash Form cfformgroup layout question

2006-12-22 Thread Teddy Payne
Try this on for size: cfform format=flash action=submit.cfm height=300 width=600 skin=halosilver cfformgroup type=tabnavigator style=marginTop: 0; marginBottom: 0;fontSize:10; backgroundColor:##e0e7ef; font-family:Verdana, Arial, Helvetica,sans-serif cfformgroup type=page

Re: UPS API

2006-12-22 Thread Eric Haskins
Just a quick thought are you sending the header for image*/*gif I know I was beating my head against the wall on dynamic image gen and I forgot to send the image header Eric On 12/22/06, Ciliotta, Mario [EMAIL PROTECTED] wrote: Hi all, I was wondering if someone would be willing to share

Re: Cartweaver for services

2006-12-22 Thread Mary Jo Sminkey
I use cartweaver for products but does anyone know of a similar product for services and invoicing. For example a service company that wants to give it's customer an area for them to look over their invoice and payment history. Hate to build this from scratch. I'd need more details about

RE: newbie: Tools to use with MySQL

2006-12-22 Thread Will Swain
Free is good!! I'll second the mySQL Administrator recommendation. When I made the switch to mySQL from Access it helped make it a lot easier. -Original Message- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: 22 December 2006 18:46 To: CF-Talk

RE: UPS API

2006-12-22 Thread Eric J. Hoffman
Did you base64 encode the results to make it an image? (I think is how that worked from memory) Eric J. Hoffman Managing Partner 2081 Industrial Blvd StillwaterMN55082 mail: [EMAIL PROTECTED] www: http://www.ejhassociates.com tel:

Web App Security Testing

2006-12-22 Thread Rey Bango
Now that I'm knee deep in web app security, I was referred to this link: http://www.owasp.org/index.php/Category:OWASP_WebScarab_Project Has anyone on here used WebScarab for their web app testing? Rey... ~| Create robust

Re: newbie: Tools to use with MySQL

2006-12-22 Thread andy
Quoting Will Tomlinson [EMAIL PROTECTED]: I like PHPMyAdmin...it's nice and easy to use...and it's free. I'm now ready to switch from Access to mySQL. Yeah, yeah what took me so long? I had my reasons but now I'm ready and I was wondering if anyone could provide me with some recommended

Re: UPS API

2006-12-22 Thread Will Tomlinson
Mario, I have a question for your question. Would you explain more about how to print UPS shipping labels? I'm doing everything BUT that. Thanks, Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion

CASE statement in MySQL

2006-12-22 Thread Josh Nathanson
Hey SQL gurus, I am trying to use a CASE statement in a MySQL query to conditionally update a number of rows in a table. However, if I try to use anything in the THEN clause other than a string, it fails with Error in SQL syntax. I am trying to set values in the table differently depending on

Re: CASE statement in MySQL

2006-12-22 Thread Barney Boisvert
The CASE construct is an expression. The structure of the SQL statement cannot be changed with a CASE construct, all you can do is dynamically compute a value. To put that nother way, you can only use a CASE where you can use a value/expression. Instead of this (what you have): UPDATE myTable

Can't open admin on CFMX/J2EE on Tomcat 5

2006-12-22 Thread Neil Middleton
I've just installed CFMX7 on a Tomcat 5 install and got it to the point where is CF is starting up - but, I have an issue that when I browse to the Administrator I get a HTTP 500 come back at me. The only error in the logs is Could not initialize class org.apache.tomcat.util.http.ServerCookie

RE: AjaxCFC bug?

2006-12-22 Thread Brad Wood
Well, I will take the silent treatment to mean I was the first and only person so far to run into this bug :) ~Brad -Original Message- From: Brad Wood Sent: Friday, December 22, 2006 12:16 PM To: CF-Talk Subject: AjaxCFC bug? So I have found a bug in AjaxCFC and I am not sure if

get server uptime and # of requests

2006-12-22 Thread John Blayter
I have Fusion Reactor EE installed on my production environment but want to develop a mobile website for management so they can see the uptime and number of requests. I looked through the FRAPI documentation and this information is not accessible. Does anyone know of a way to get this information

Re: AjaxCFC bug?

2006-12-22 Thread Rey Bango
Or the fact thats its the Friday before Christmas. :o) Rey Brad Wood wrote: Well, I will take the silent treatment to mean I was the first and only person so far to run into this bug :) ~Brad -Original Message- From: Brad Wood Sent: Friday, December 22, 2006 12:16 PM

cfqueryparam?

2006-12-22 Thread Doug Brown
Using cfqueryparam, what cfsqltype would you use for a text field...cf_sql_longvarchar? Doug B. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2

Re: CASE statement in MySQL

2006-12-22 Thread Dwayne Cole
There a lot of funny business going on in this SQL statement. I would try to accomplish the logic outside the SQL statement. I you need conditionals I would limited to cfif statements any thing more than that seems a little messy for lack of a better term. -- Original Message

Re: CASE statement in MySQL

2006-12-22 Thread Josh Nathanson
Barney, thanks -- that got me going in the right direction, although it wouldn't let me use an expression as the result of the conditional, I think because one of the values in the expression was the value of a column -- however I was able to tweak it so my result could be a simple integer.

Re: CASE statement in MySQL

2006-12-22 Thread Josh Nathanson
There a lot of funny business going on in this SQL statement. I would try to accomplish the logic outside the SQL statement. I you need conditionals I would limited to cfif statements any thing more than that seems a little messy for lack of a better term. Yup it is messy, but the

Re: CASE statement in MySQL

2006-12-22 Thread Barney Boisvert
Sure looks like you're updating positions in a hierarchial collection of help pages using nested sets, though the algorithm is a touch different that what I've always used, and I can't say if it's a bug or if it's just different. However, I can tell you from experience that two sequential queries

Re: CASE statement in MySQL

2006-12-22 Thread Josh Nathanson
Sure looks like you're updating positions in a hierarchial collection of help pages using nested sets, though the algorithm is a touch different that what I've always used, and I can't say if it's a bug or if it's just different. Winner winner, chicken dinner! This query is actually the