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: checked>Solid checked>Open checked>Insulated checked>Combination At form submit I update the record: update pgallery set gtype = '#tt#' where id = #picid# Now here's where I screw up: select * from pgallery where listContains(gtype, "1") 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
>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
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
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
