mornings80
Community Beginner
mornings80
Community Beginner
Activity
‎Jul 27, 2018
07:41 AM
1 Upvote
Thank you!
... View more
‎Jul 24, 2018
04:44 PM
I am trying to have cfmail send a list (the result of a query) from an access DB. I would like each value separated by some blank lines. I have inserted </br> but they don't get treated as html, they are just sent along with the results: <cfquery name="P1" datasource="DB"> SELECT * FROM Table1 </cfquery> <cfmail query="P1" from='user1@gmail.com' to='user2@gmail.com' subject='Testing CFMail'> <cfoutput> #Col2#</br></br> </cfoutput> </cfmail> The resulting email looks like this: Result1</br></br> Result2</br></br> Result3</br></br> I would like the </br> treated as html and not included in the email. Any suggestions would be appreciated. TIA.
... View more
‎Jul 17, 2018
08:08 AM
Just for future reference in the unlikely event that anyone needs to do something similar, I found a great example that does exactly what I was looking for (written almost 20 years ago ). I hope this helps someone. https://www.irt.org/articles/js140/#8 Published on: Saturday 2nd January 1999 By: Janus Boye
... View more
‎Jul 15, 2018
04:05 PM
I have a list of items in a database. I need a CF page that will allow a person to display all of the items and then prioritize (order) the list from "1 to n" and then have those prioritized numbers inserted back into the database. It seems that I need to somehow combine a cfoutput query="Qry" (to list all of the items) with an <cfinput type="text" (to add an order number) then have the order number inserted back into the database on the submit...but I would sure appreciate some initial guidance. I'm not sure I'm in the ballpark quite yet. TIA
... View more
‎Jul 15, 2018
02:37 PM
Thank you, BKBK!
... View more
‎Jul 13, 2018
04:05 PM
I am using Coldfusion and I would like to display the first few words in a database memo (unlimited text) field as a link for the user to select the whole record. Is it possible to limit the display of the text in the memo field to just a few words? As an example: <A HREF="AFIELD.cfm?ID=#URLEncodedFormat(ID)#"> #AName#: #AText#:
... View more
‎Jul 11, 2018
07:33 PM
1 Upvote
BKBK, thank you so much for your post. I was just one smashed keyboard away from giving up on this whole thing! Your information will be so valuable to others because I have seen so many posts where ppl can not get passed this CF / MS Access hurdle. Thank you very much! I am using Coldfusion Builder 16 trying to add an MSAccess (.mdb) data source. It was your UCanAccess post (above - 5. Re: CF16 and Access datasource) and your alternative (directly above - 9. Re: CF16 and Access datasource) using the "Add New Data Source" in CF that worked for me. Whew! Thanks.
... View more
‎Jul 10, 2018
09:54 PM
Thank you for your reply. I was testing the UCanAccess driver you mentioned. I wasn't sure how to fill out the details when defining the datasource within Coldfusion Admin. Data Source Name: myAccessDSN Driver: ? JDBC URL: ? Driver Class: ? Driver Name: ?
... View more
‎Jul 10, 2018
04:43 PM
Thank you for this information. How did you fill in this information:? I went to the ColdFusion Administrator and configured a datasource as follows: Data Source Name: myAccessDSN Driver: ??? JDBC URL: ???? Driver Class: ???? Driver Name: ????
... View more
AdChoices