[cfaussie] RE: Email and XML or other?

Sun, 26 Oct 2003 18:23:03 -0800

Title: Email and XML or other?
I've spent, like, 10 seconds on this so it's just an idea to throw up.
 
Loop thru all the form elements (same names as the table fields). I haven't tested it and I think the eval bit is wrong. it also leaves it wide open for SQL injection (but any data input still needs checking to be sure all is kosher - not within a day wthout some pre-written UDF's).
 
<cfquery ...>
update tableWhatever set
    <cfloop collection="#FORM#" item="ele">
        #ele# = #eval(FORM[ele])#
    </cfloop>
    where someField = #Form.userID#
</cfquery>
 
 
this make sence?
 
cheers
barry.b
 
   
-----Original Message-----
From: Taco Fleur [mailto:[EMAIL PROTECTED]
Sent: Monday, 27 October 2003 11:05 AM
To: CFAussie Mailing List
Subject: [cfaussie] Email and XML or other?

Wow second question today!

I have about one day to implement a system where all customers are contacted via email, this email contains all their details we have on file for them, the purpose of this is so that they can let us know if the details we have on file are correct or incorrect.

I wanted to automate the process by creating a form they can access to correct their details if not correct, but time does not allow this.

The client has to reply to the email itself and include the correct details, these emails will be hand processed then. To me it looks like it could be done better and more efficient, but the question is - how to do all this in one day?

Does anyone reckon it can be done in one day when mixing XML into it?
That's creating the code to parse the email and create the email...

thanks for any input.

Taco Fleur
07 3535 5072
Tell me and I will forget
Show me and I will remember
Teach me and I will learn

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/

Reply via email to