Re: New Security Issue with CF
Yes Sent from my iPhone On Jan 4, 2013, at 12:28 PM, Claude Schnéegans schneeg...@internetique.com wrote: but i think the way this one works quite ingenious. I'm not sure if it is as much ingenious as the breach is gross, frankly. Have you seen how the schedule task could have been set? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353772 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Fwd: New Security Issue with CF
I apologize to the list this was not supposed to be sent. Sent from my iPhone Begin forwarded message: From: Steve Artis st...@artisdesigns.commailto:st...@artisdesigns.com Date: January 4, 2013, 12:30:16 PM MST To: cf-talk cf-talk@houseoffusion.commailto:cf-talk@houseoffusion.com Subject: Re: New Security Issue with CF Reply-To: cf-talk@houseoffusion.commailto:cf-talk@houseoffusion.com Yes Sent from my iPhone On Jan 4, 2013, at 12:28 PM, Claude Schnéegans schneeg...@internetique.commailto:schneeg...@internetique.com wrote: but i think the way this one works quite ingenious. I'm not sure if it is as much ingenious as the breach is gross, frankly. Have you seen how the schedule task could have been set? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353775 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFspreadsheet Issue
Hello, I have a question about CFspreadsheet I'm reading a spreadsheet and inserting the data into a SQL server DBeverything works fine unless 1 of my columns in the spreadsheet is blank. I'm getting the following error: Element PHONE is undefined in EXCELQUERYBYNAME. I tried the put a cfif isdefined to see if that would solve it but no lucksame error message. How can I handle this issue? My cfquery is below: cfquery name=insert_Sh_data datasource=#datasource# INSERT into contactrecord ( contact_date, fname, lname, address, city, state, zip, county, cfif isDefined(excelQueryByName.phone)phone,/cfif cfif isDefined(excelQueryByName.cell)cell,/cfif cfif isDefined(excelQueryByName.fax)fax,/cfif cfif isDefined(excelQueryByName.title)title,/cfif cfif isDefined(excelQueryByName.organization)organization,/cfif cfif isDefined(excelQueryByName.email)email,/cfif cfif isDefined(excelQueryByName.general_comments)general_comments,/cfif cfif isDefined(excelQueryByName.fname2)fname2,/cfif cfif isDefined(excelQueryByName.lname2)lname2,/cfif mailing, input_by, input_date, input_time, input_by_id, country, sh_rating ) Values( '#Trim(excelQueryByName.contact_date)#', '#Trim(excelQueryByName.fname)#', '#Trim(excelQueryByName.lname)#', '#Trim(excelQueryByName.address)#', 'Trim(excelQueryByName.city)#', '#Trim(excelQueryByName.state)#', '#Trim(excelQueryByName.zip)#', '#Trim(excelQueryByName.county)#', cfif isDefined(excelQueryByName.phone)'#Trim(excelQueryByName.phone)#',/cfif cfif isDefined(excelQueryByName.cell)'#Trim(excelQueryByName.cell)#',/cfif cfif isDefined(excelQueryByName.fax)'#Trim(excelQueryByName.fax)#',/cfif cfif isDefined(excelQueryByName.title)'#Trim(excelQueryByName.title)#',/cfif cfif isDefined(excelQueryByName.organization)'#Trim(excelQueryByName.organization)#',/cfif cfif isDefined(excelQueryByName.email)'#Trim(excelQueryByName.email)#',/cfif cfif isDefined(excelQueryByName.general_comments)'#Trim(excelQueryByName.general_comments)#',/cfif cfif isDefined(excelQueryByName.fname2)'#Trim(excelQueryByName.fname2)#',/cfif cfif isDefined(excelQueryByName.lname2)'#Trim(excelQueryByName.lname2)#',/cfif '#Trim(excelQueryByName.mailing)#', '#Trim(excelQueryByName.input_by)#', '#Trim(excelQueryByName.input_date)#', '#Trim(excelQueryByName.input_time)#', '#Trim(excelQueryByName.input_by_id)#', '#Trim(excelQueryByName.country)#', '#Trim(excelQueryByName.sh_rating)#' ) /cfquery Thanks in Advance. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352118 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
sartis
Hello, I have a question about CFspreadsheet I'm reading a spreadsheet and inserting the data into a SQL server DBeverything works fine unless 1 of my column in the spreadsheet is blank. I'm getting the following error: Element PHONE is undefined in EXCELQUERYBYNAME. I tried the put a cfif isdefined to see if that would solve it but no lucksame error message. How can I handle this issue? My cfquery is below: cfquery name=insert_Sh_data datasource=#datasource# INSERT into contactrecord ( contact_date, fname, lname, address, city, state, zip, county, cfif isDefined(excelQueryByName.phone)phone,/cfif cfif isDefined(excelQueryByName.cell)cell,/cfif cfif isDefined(excelQueryByName.fax)fax,/cfif cfif isDefined(excelQueryByName.title)title,/cfif cfif isDefined(excelQueryByName.organization)organization,/cfif cfif isDefined(excelQueryByName.email)email,/cfif cfif isDefined(excelQueryByName.general_comments)general_comments,/cfif cfif isDefined(excelQueryByName.fname2)fname2,/cfif cfif isDefined(excelQueryByName.lname2)lname2,/cfif mailing, input_by, input_date, input_time, input_by_id, country, sh_rating ) Values( '#Trim(excelQueryByName.contact_date)#', '#Trim(excelQueryByName.fname)#', '#Trim(excelQueryByName.lname)#', '#Trim(excelQueryByName.address)#', 'Trim(excelQueryByName.city)#', '#Trim(excelQueryByName.state)#', '#Trim(excelQueryByName.zip)#', '#Trim(excelQueryByName.county)#', cfif isDefined(excelQueryByName.phone)'#Trim(excelQueryByName.phone)#',/cfif cfif isDefined(excelQueryByName.cell)'#Trim(excelQueryByName.cell)#',/cfif cfif isDefined(excelQueryByName.fax)'#Trim(excelQueryByName.fax)#',/cfif cfif isDefined(excelQueryByName.title)'#Trim(excelQueryByName.title)#',/cfif cfif isDefined(excelQueryByName.organization)'#Trim(excelQueryByName.organization)#',/cfif cfif isDefined(excelQueryByName.email)'#Trim(excelQueryByName.email)#',/cfif cfif isDefined(excelQueryByName.general_comments)'#Trim(excelQueryByName.general_comments)#',/cfif cfif isDefined(excelQueryByName.fname2)'#Trim(excelQueryByName.fname2)#',/cfif cfif isDefined(excelQueryByName.lname2)'#Trim(excelQueryByName.lname2)#',/cfif '#Trim(excelQueryByName.mailing)#', '#Trim(excelQueryByName.input_by)#', '#Trim(excelQueryByName.input_date)#', '#Trim(excelQueryByName.input_time)#', '#Trim(excelQueryByName.input_by_id)#', '#Trim(excelQueryByName.country)#', '#Trim(excelQueryByName.sh_rating)#' ) /cfquery Thanks in Advance. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
sartis
hello, I'm wondering if someone can help me or point me to an example of the following: I have an application that has a search page. If a user does a search, it can kickback any number of records. I want to be able to display 10 records at a time and then display a show more button and it would load 10 more records(showing the 1-10 too), and the user could click the show more button until the end of the recordset...etc. I do not want a page refresh. What is the best way to accomplish this? Ajax? A cached coldfusion query with hidden divs?? I'm using CF 9, javascript and sql server. Also, if you view the homepage of linkedin, there is a perfect example of what I'm describing there. Thanks. Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350192 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm