Re: Querying a comma separated list
It works perfectly. Thank you, Terry ~| 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:359216 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Querying a comma separated list
I haven't done this is ages and could use some help, please. Here I define a list of checkboxes of picture types: input type=checkbox name=tt value=1 cfif gtype contains '1'checked/cfifSolidbr input type=checkbox name=tt value=2 cfif gtype contains '2'checked/cfifOpenbr input type=checkbox name=tt value=3 cfif gtype contains '3'checked/cfifInsulatedbr input type=checkbox name=tt value=4 cfif gtype contains '4'checked/cfifCombinationbr At form submit I update the record: cfquery name=upcontent datasource=#dsn# maxrows=1 update pgallery set gtype = '#tt#' where id = #picid# /cfquery Now here's where I screw up: cfquery name=getslides datasource=#dsn# select * from pgallery where listContains(gtype, 1) /cfquery Here;s the error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Undefined function 'listContains' in expression. Terry ~| 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:359195 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: deleting an image after using cfimage
no, you have to wait until cf has finished with the file, if you are trying to delete immediately afterwards then that is probably why. You should either try adding a delay, or simply add the images to a list and setup a scheduled task that comes and deletes the files in that list later on. On Thu, Aug 21, 2014 at 1:33 AM, te...@it-werks.com te...@it-werks.com te...@it-werks.com wrote: Thank you Russ. ~| 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:359174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: deleting an image after using cfimage
the file is probably still locked. how long have you waited before trying to delete it ? On Tue, Aug 19, 2014 at 10:57 PM, te...@it-werks.com te...@it-werks.com te...@it-werks.com wrote: Cannot delete an image after using cfimage unless I stop and restart the Coldfusion Application server. Is there a setting I am missing? How can I program it to unlock as soon as it has been re sized or cropped? ~| 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:359172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
deleting an image after using cfimage
Cannot delete an image after using cfimage unless I stop and restart the Coldfusion Application server. Is there a setting I am missing? ~| 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:359160 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Saving updated sort order in mysql jquery list to update database
I have a cfm page that displays a drag and drop ul list and I do not know how to create an array of that sorted list to the mysql database. Any help would be greatly appreciated. I am new to the jquery, jquery-ui plugins, but loving it all so far. Thanks in advance, Terry ~| 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:356843 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Using IN() within a cfquery statement
I have a select name=stuff multiple in a form filled with results from a query. I get the form field value: stuff=selection1,selection5,selection12. How do I then build a cfquery using the stuff variable in the IN() statement? Terry ~| 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:356483 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Safety for image uploads
You must upload the file to a directory that is not web-accessible and cannot execute code. Dave Watts, CTO, Fig Leaf Software Thank you Dave and the others. Now lets say the root is c:\inetpub\wwwroot\domainname and I use cffile to upload the jpg only file to c:\uploads use my cfimage to resize it, convert it to a png and save it to: c:\inetpub\wwwroot\domainname\slideshow\, then add the image to my cf code that runs the slideshow. Do you see any thing I have missed? Terry ~| 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:355950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Safety for image uploads
If you upload the file to something out of web root then you should be safe. Never upload to webroot. Ever. Thank you Raymond and the others. Now lets say the root is c:\inetpub\wwwroot\domainname and I use cffile to upload the jpg only file to c:\uploads use my cfimage to resize it, convert it to a png and save it to: c:\inetpub\wwwroot\domainname\slideshow\, then add the image to my cf code that runs the slideshow. Do you see any thing I have missed? Terry ~| 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:355951 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
hmailserver Coldfusion
Anyone have any experience, comments using hmailserver with Coldfusion? Terry ~| 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:353344 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Inserting data using QODBC
I guess I need to first ask Is anyone on this list using the QODBC, odbc driver for Quickbooks?, before asking for help. Terry ~| 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:345586 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm