orm beginner
Trying to get my head wrapped around the new orm features.not doing well J. I used an example I got from Manju's blog.trying to get one to many relationships working. I set up a Contacts.cfc with three one to many cfc's (emails, addresses, phoneNumbers). Then I created an index.cfm to set things up and display results. I got an error. So I commented out all the code on index.cfm and tried again.same error. I'm guessing that would mean the error must be in application.cfc, but it's pretty simple and I don't see what might be wrong. Could the error be coming from one of the other cfc's even though index is commented out? Does Coldfusion attempt to build the map as soon as it see ormenabled = true? Here is the error and below that the code for application cfc Thanks, Mark Error casting an object of type java.lang.String cannot be cast to java.util.Map to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed. java.lang.String cannot be cast to java.util.Map Resources: * Check the ColdFusion http://www.adobe.com/go/prod_doc documentation to verify that you are using the correct syntax. * Search the Knowledge Base http://www.adobe.com/go/prod_support/ to find a solution to your problem. Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.17) Gecko/2009122116 Firefox/3.0.17 GTB6 (.NET CLR 3.5.30729) Remote Address 127.0.0.1 Referrer Date/Time 14-Jan-10 11:18 AM Stack Trace java.lang.ClassCastException: java.lang.String cannot be cast to java.util.Map at coldfusion.orm.hibernate.ConfigurationManager.initConfiguration(Configuratio nManager.java:63) at coldfusion.orm.hibernate.HibernateProvider.InitializeORMForApplication(Hiber nateProvider.java:182) at coldfusion.orm.hibernate.HibernateProvider.beforeApplicationStart(HibernateP rovider.java:85) at coldfusion.filter.ApplicationFilter.fireBeforeAppStartEvent(ApplicationFilte r.java:475) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:221) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletF ilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java: 320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:26 6) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Application.cfc : cfcomponent !---define the application--- cfset this.name = myORMApplication cfset this.ormenabled = true !---store the datasource for the entire application--- cfset this.datasource = OrmTesting ! ORM Setting this tells ORM to drop and create
another beginner orm question
Ok, got past last problem (thanks dave) and have uncommented the code on index.cfm. I followed the example on Manju's blog entitled Coldfusion-ORM: Define One-to-Many and Many to One Relationships. The article was for one related table, mine is for three. I used the built-in Apache database. The orm is creating the tables, though it doesn't seem to be reflecting my latest changes. Anyway, the code is below the error. Thanks, Mark ids for this class must be manually assigned before calling save(): Emails Root cause :org.hibernate.id.IdentifierGenerationException: ids for this class must be manually assigned before calling save(): Emails The error occurred in C:\ColdFusion9\wwwroot\Orm\index.cfm: line 48 46 : */ 47 : 48 : EntitySave(newContact); 49 : 50 : Code for index.cfm (just a test for learning): cfscript /* Create a Contact with one address, one phone number and one email address */ newContact = new Contacts(); newContact.setFirstName(Mark); newContact.setLastName(Fuqua); newAddress = new Addresses(); newAddress.setAddressDescription(2301 Mount Carmel Road); newAddress.setCity(Parkton); newAddress.setState(MD); newAddress.setZip(21120); newEmail = new Emails(); newEmail.setEmailDescription(Work Email); newEmail.setEmail(m...@mdprofinish.com); newPhoneNumber = new PhoneNumbers(); newPhoneNumber.setPhoneDescription(Cell); newPhoneNumber.setPhoneNumber(410-215-7356); /* Associate the Addresses, Emails and PhoneNumbers with Contacts */ newContact.addaddresses(newAddress); newContact.addEmails(newEmail); newContact.addphoneNumbers(newPhoneNumber); /* Establish the relationship from the other side */ newPhoneNumber.setContacts(newContact); newAddress.setContacts(newContact); newEmail.setContacts(newContact); /* Save new Contacts, email, address, phone info should be saved as well */ EntitySave(newContact); DisplayContacts(); /cfscript ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329681 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
insert trouble...zero length
Having trouble with the following code.having trouble with zero length values. The field in the database is empty and when it goes to insert it into another table, it chokes. Is there a way to set a value as default? Or do I have to do a cfif on each value? I'm sure I'm missing something simple here. cfquery name=transferData datasource=brooklineOld SELECT * FROM plumUser Where ContactType = 3 and userId = 34 /cfquery cfloop query=transferData cfquery name=insertNew datasource=brookline INSERT INTO PlumUser(address1, CellPhone, CellPhoneCarrier, CellPhoneEmail, City, CompanyName, ContactType, Country, DateCreated, Email, Extension, Fax, FirstName, HomePhone, LastName, OfficePhone, Password, State, Status, SubShortName, UserName, ZipCode) VALUES( '#transferData.Address1#', '#transferData.CellPhone#', '#transferData.CellPhoneCarrier#', '#transferData.CellPhoneEmail#', '#transferData.City#', '#transferData.CompanyName#',#transferData.ContactType#, '#transferData.Country#', #CreateODBCDate(transferData.DateCreated)#, '#transferData.Email#', '#transferData.Extension#', '#transferData.Fax#', '#transferData.FirstName#', '#transferData.HomePhone#', '#transferData.LastName#', '#transferData.OfficePhone#', '#transferData.Password#', '#transferData.State#',#transferData.Status#, '#transferData.SubShortName#', '#transferData.UserName#', '#transferData.ZipCode#' ) /cfquery /cfloop Thanks, Mark ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: insert trouble...zero length
So I have to put a cfif at each value to check for length greater than zero and if it is not, set the value to for each field...for each iteration? -Original Message- From: Rob Parkhill [mailto:robert.parkh...@gmail.com] Sent: Tuesday, June 16, 2009 1:42 PM To: cf-talk Subject: Re: insert trouble...zero length You will have to make sure that the table you are inserting into can have a NULL as a value, or you will need to modify your code to look at each value and change any NULLs to either a space or a zero depending on the datatype you are inserting. HTH Rob On Tue, Jun 16, 2009 at 1:33 PM, Mark Fuqua MdProfinish m...@mdprofinish.com wrote: Having trouble with the following code.having trouble with zero length values. The field in the database is empty and when it goes to insert it into another table, it chokes. Is there a way to set a value as default? Or do I have to do a cfif on each value? I'm sure I'm missing something simple here. cfquery name=transferData datasource=brooklineOld SELECT * FROM plumUser Where ContactType = 3 and userId = 34 /cfquery cfloop query=transferData cfquery name=insertNew datasource=brookline INSERT INTO PlumUser(address1, CellPhone, CellPhoneCarrier, CellPhoneEmail, City, CompanyName, ContactType, Country, DateCreated, Email, Extension, Fax, FirstName, HomePhone, LastName, OfficePhone, Password, State, Status, SubShortName, UserName, ZipCode) VALUES( '#transferData.Address1#', '#transferData.CellPhone#', '#transferData.CellPhoneCarrier#', '#transferData.CellPhoneEmail#', '#transferData.City#', '#transferData.CompanyName#',#transferData.ContactType#, '#transferData.Country#', #CreateODBCDate(transferData.DateCreated)#, '#transferData.Email#', '#transferData.Extension#', '#transferData.Fax#', '#transferData.FirstName#', '#transferData.HomePhone#', '#transferData.LastName#', '#transferData.OfficePhone#', '#transferData.Password#', '#transferData.State#',#transferData.Status#, '#transferData.SubShortName#', '#transferData.UserName#', '#transferData.ZipCode#' ) /cfquery /cfloop Thanks, Mark ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: insert trouble...zero length
Sorry to ask, but does cfif LEN(TRIM(myquery.MyFieldName)) actually suffice as a check for length or do I have to add = 0... cfif LEN(TRIM(myquery.MyFieldName)) = 0 Seems like you're saying I can do the following and it will work: Values(cfif LEN(TRIM(myquery.MyFieldName))'#myquery.MyFieldName#'cfelse /cfif, REPEAT...) Thanks, Mark -Original Message- From: Alan Rother [mailto:alan.rot...@gmail.com] Sent: Tuesday, June 16, 2009 1:44 PM To: cf-talk Subject: Re: insert trouble...zero length There are several valid ways to handle this. In your destination table you can define a default value if none is provided, this of course does require you to do a CFIF around each item in your insert and you will need to check to see if the value you are about to insert has a length cfif LEN(TRIM(myquery.MyFieldName)) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: insert trouble...zero length
Thank you Peter, I appreciate what you're saying...it's just that I can look at the database and see ContactType is present for each record...so while that, I'm sure, would cause an error, it is not in this case. Sorry, I only code part time, a couple times each year (trying to go full time...really amazed...I like coding), so my mailing list etiquette is pretty rough...I should have responded the first time. Thanks for the help. Mark -Original Message- From: Peter Boughton [mailto:bought...@gmail.com] Sent: Tuesday, June 16, 2009 2:24 PM To: cf-talk Subject: Re: insert trouble...zero length Your problem there is the numeric ContactType field - if it is missing, you get an empty item between the two commas, which is invalid SQL syntax. You can solve it with cfqueryparam by setting the null property based on whether it contains a numeric value or not: cfqueryparam value=#transferData.ContactType# cfsqltype=cf_sql_integer null=#NOT IsNumeric(transferData.ContactType)# / -- Peter Boughton //hybridchill.com //blog.bpsite.net ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: insert trouble...zero length
Another quick question...I've noticed elsewhere, that it is common to set a value to NULL. Is there a benefit to either of these... cfif LEN(TRIM(transferData. Country))'#transferData. Country #'cfelse' '/cfif, cfif LEN(TRIM(transferData.Country))'#transferData.Country#'cfelseNULL/cfif, Thanks, Mark -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Tuesday, June 16, 2009 2:56 PM To: cf-talk Subject: Re: insert trouble...zero length Actually, empty string simply breaks the Boolean check, it's the primary exception. cfif isBoolean(stringVar) ... will at least let it through only if it's actually a value that CF can apply a true/false test to ... From: Peter Boughton bought...@gmail.com Sent: Tuesday, June 16, 2009 2:48 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: insert trouble...zero length Nothing wrong with your mailing list ettiquette - I had to post manually (hof broke) and just got the subject wrong the first time, and posted again so it was correctly threaded. Anyhow, I'd still recommend adding a check against it being missing - unless you're 300% certain it will always be there. Slightly confused that it appears to be one of the string fields - an empty string shouldn't cause an error. :/ -- Peter Boughton //hybridchill.com //blog.bpsite.net ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: TOT - FireFox memory issues
I don't use any plugins...quite behind, I know...but almost anytime my old laptop is screaming along at 100%, all I have to do to restore calm is shut down ff. So I doubt it is the plugins... -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2008 3:36 PM To: CF-Talk Subject: TOT - FireFox memory issues My problem is that Firefox will start out at 60-70 megs of ram but slowly creeps up to 500+ and slows down (and pegs the processor) often to the point of being unusable after 3-5 hours. I have to restart it at least once a day. I have forgotten to turn off FF over the weekend and have had it creep up to 2 GIG's of ram by Monday. I have trimmed down my plug-in usage to the bare minimum of Firebug, the Web Developer tool bar, delicious and Google tool bar. All of which I use everyday, all day. I am pretty dependent on Firebug and the Google and Web Developer tool bars. I can live with out del.icio.us. In an ideal world I would rather not give up anything. Does anyone have any suggestions? I would rather like to avoid a reinstall. If I need to do a reinstall, how can I save my history, cookies, pre-populated form fields, passwords etc.? Or is that part of the problem as well? JSYK, My workstation is a 1 yr old corporate Dell desktop w/XP, and twin dual core P4 2.8's, and 2 gig RAM. It happens on all my FF installs so it is not just this machine. tia G -- Education is a progressive discovery of our own ignorance. - Will Durant ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302576 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: product query - need an expert
Not an expert and this might be really stupid, but what is the advantage of making products with options...why not make each product option a different product? Seems it would simplify what you need to do. Mark -Original Message- From: Mike Little [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2008 8:46 PM To: CF-Talk Subject: product query - need an expert help! i am stuck... ok, for my product catalogue i have included a basic inventory system. product - product_id track_stock BIT stock_level INT reorder_level INT product_to_product_options -- product_id product_options_id stock_level INT reorder_level INT product_options - product_options_id product_option_title basically, if a product has options (eg. small, medium, large) then the stock is tracked at the option level. if not then it is tracked at the product level. my big problem is, how do i determine if a product is available for purchase eg. it has a stock level of zero - either at the product level or for a particular option? i need to develop a system for displaying products on a summary page. any help would truly be appreciated. mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302396 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any Gotcha's in using CF UUID for db record primary key?
What if you have four concurrent users (or four hundred if your app get popular!), what happens if user two gets user three's id when she runs LAST_INSERT_ID()? That's the one of the only reasons I can see for using alternate keys. Whether it is a UUID created in Coldfusion or someother unique value...you KNOW what it is...everytime, because you set it, not the DB. Mark -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2008 8:22 AM To: CF-Talk Subject: RE: Any Gotcha's in using CF UUID for db record primary key? What's the reason for using the db instead of CF to generate the UUID? To keep the load off CF? I was thinking I might use CF in the following manner to generate a UUID for a record: - Create UUID and variable to hold UUID via CF and cfset - User completes form with textual information and photo selection via cffile - Run insert query to create primary textual record, including inserting UUID - Run second insert query to create records in photo table for each cffile field mentioned above, inserting UUID for relational key to textual information After doing some reading in the MySQL 5 docs, it looks like I could use the LAST_INSERT_ID() function to return the auto-incrementing primary key of the main textual record of a property (Real Estate property), then run an insert query for the photo records on another table, using the LAST_INSERT_ID() as the relational key to the primary property table. - User completes form with primary record info and selects photos - Insert query runs creating primary property record - Run another query to retrieve LAST_INSERT_ID() (or just use that value as a variable, #LAST_INSERT_ID()# ???) - Run another query to insert photos into photo table using LAST_INSERT_ID as relational key Using LAST_INSERT_ID(), it seems that I could allow a single input form for two tables, property and property_photos, create a more user-friendly work flow, and avoid the messiness of UUID altogether. Thoughts? Rick -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 11:48 PM To: CF-Talk Subject: RE: Any Gotcha's in using CF UUID for db record primary key? At the same time I kind of DON'T agree with them if you're doing what we were doing: if you're using the key to link tables (so that you can combine multiple databases easily) and using them to link to non-DB information (log files, etc) then it seems like extra work to do a real auto-increment PK as well. I'll second this. Either use UUIDs or don't. In either case, I'd recommend that you use your database's ability to generate these instead of doing it from CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Which approach to take?
If you make the UUID an alternate key, you don't even have to change the structure of you table. Your primary key can stay the same as it is now. Mark -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 12:05 AM To: CF-Talk Subject: RE: Which approach to take? I use the ColdFusion UUID as the ID for the post so I already know the ID before the message is saved. I guess using the UUID would make that approach work well. I'll have to check into that. Rick -Original Message- From: Mike Harman [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 12:11 AM To: CF-Talk Subject: Re: Which approach to take? I guess I'm probably the rebel here, but I just completed some modifications to our company's forum post interface that contains both text input and file attachments. The user enters the title in one input box and if the user wants to attach a file, clicks an 'attach file' link below the text area. When the link is clicked, a javascript function is called and places a file input box on the screen below the link. If clicked again, and input exists in the first file input, another file input box appears below the first. This allows the user to attach as many files as necessary. Once the post button is clicked, the title and post is validated and stored followed by the attachments. I use the ColdFusion UUID as the ID for the post so I already know the ID before the message is saved. I hope this helps, Mike Harman Hi, all... I'm designing part of an app that will allow users to input info and photos for newly constructed communities. (Real Estate site) I'm going to allow the users to input unlimited photos for each community. There will be one table holding the textual info about each property and another table in the db holding the photos. Therefore, the photos will need to be linked via foreign key in the db to the property table. That said, I'm wondering what approach to take for the input of photos. First Approach: 1) Users input textual information and submit 2) Users then click on link to upload photos which will provide the community_id to connect the photos to the property identified in the URL variable. Second Approach: 1) Users input all data on the same page...textual and photos. 2) For processing, textual data is input first 3) New id for the property is retrieved 4) Photos are uploaded, processed, and put into the db connected to the property via the community_id created in the insert query for the textual info. The first approach is more trouble for the user, but easier. The second approach is preferable if I can consistently retrieve that last id inserted without any problem. I know this is discussed and debated from time-to-time, but I thought I'd ask again, now that I'm on CF 8 and MySQL 5.0. Thoughts, anyone? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Any Gotcha's in using CF UUID for db record primary key?
Keep you pk like it is...auto incrementing...and add another field with uuid and then you can reference them -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 7:38 PM To: CF-Talk Subject: RE: Any Gotcha's in using CF UUID for db record primary key? Thanks for the feedback, Dominic. I'll have to do some more research on this approach. I was thinking that the UUID would take the place of using the PK my databases, as in: a href=community.cfm?community_uuid=#url.community_uuid and I would begin to code all my links using the uuid as the relational key instead of the PK. I need to become more familiar with using unique constraints, etc. Rick -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 7:10 PM To: CF-Talk Subject: Re: Any Gotcha's in using CF UUID for db record primary key? Hi Rick, Personally, I would still use an auto-incrementing integer for the PK but have the UUID as a separate field with a unique constraint. Primary keys are not for making a single row unique but for facilitating the relational bit of relational databases (i.e. defining Foreign Key relationships). Having PKs as narrow as possible is better for performance when querying a database across relationships (i.e. using Joins, etc). Of course, as well as having the unique constraint on the GUID, your table should also define a constraint/index that logically defines what makes a row unique (i.e. a combination of account number and sort-code is a logical unique identifier for a bank account and should have a unique index or constraint - but not be a PK). HTH Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301871 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Any Gotcha's in using CF UUID for db record primary key?
I have two tables with alternate keys...one is the user table that has a auto incrementing PK with the email (user name in this application) as a unique alternate key and one table of uploaded file info with an auto incrementing PK with file name (combination of file name and job name) as a unique alternate key. When records are added to either of these tables, records are added to other tables that have to relate to these new records and we can't be sure, with multiple users, of what the auto incrementing PK is (because that is set by the DB), but we do know the alternate key, bacause we actually insert that with the new record. So we can use that alternate key to be sure, 100% sure, we are grabbing the right record's PK. HTH Mark Fuqua -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 7:38 PM To: CF-Talk Subject: RE: Any Gotcha's in using CF UUID for db record primary key? Thanks for the feedback, Dominic. I'll have to do some more research on this approach. I was thinking that the UUID would take the place of using the PK my databases, as in: a href=community.cfm?community_uuid=#url.community_uuid and I would begin to code all my links using the uuid as the relational key instead of the PK. I need to become more familiar with using unique constraints, etc. Rick -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2008 7:10 PM To: CF-Talk Subject: Re: Any Gotcha's in using CF UUID for db record primary key? Hi Rick, Personally, I would still use an auto-incrementing integer for the PK but have the UUID as a separate field with a unique constraint. Primary keys are not for making a single row unique but for facilitating the relational bit of relational databases (i.e. defining Foreign Key relationships). Having PKs as narrow as possible is better for performance when querying a database across relationships (i.e. using Joins, etc). Of course, as well as having the unique constraint on the GUID, your table should also define a constraint/index that logically defines what makes a row unique (i.e. a combination of account number and sort-code is a logical unique identifier for a bank account and should have a unique index or constraint - but not be a PK). HTH Dominic ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hostmysite down?
Working late or early Adam? HostMySite is one of those companies, while not perfect or supernatural by any means, does an admirable job, one that should be emulated. I put them in a class with Starbucks, Toyota and Wegman's grocery stores...truely a class act. They are more expensive than most other hosting companies, but I can't imagine switching. Mark -Original Message- From: Adam Churvis [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2008 5:05 AM To: CF-Talk Subject: RE: Hostmysite down? So let me get this straight... You quickly solve the problem, you take immediate and effective steps to ensure it will most likely never become a problem ever again, you give a clear and concise description of the problem, you assume full responsibility for the problem, you offer immediate and reasonable compensation to those affected by the problem, and you top it all off by sincerely apologizing for the problem? Would you please do us all a favor and take over the operations of the federal government? They could learn a few things from you. Respectfully, Adam Phillip Churvis President Productivity Enhancement -Original Message- From: Jamie Price [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 7:26 PM To: CF-Talk Subject: Re: Hostmysite down? The problem has been diagnosed and for the most part resolved. The main core switch there had a corruption in it's configuration and rebooted, but due to the corruption issue we could not automatically fail over to the hot spare. This was remedied by manually failing over. The total downtime measured for 28 minutes or so, and tonight we will be doing emergency maintainence to resolve the confug issue that prevented the automatic failover. If your site or server(s) were affected by the outage please contact [EMAIL PROTECTED] and a credit of 5% of your monthly fees. Please accept our deepest apologies for the inconvenience, and know that we are working hard to prevent this type of outage from occuring in the future. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301251 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
file upload/virus scan
OK, so I was reading a response to another question, where someone mentioned the importance of scanning uploaded files...I hadn't thought of that. Two questions: 1. If all I allow for uploads is pdf and jpg, is that still neccessary? 2. My site is on a vps so it would be all self serve...what can I use and how do I get it to scan the uploaded file? TIA, Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301123 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Creating a .cfm file on the fly
I've never used besavvy, but when i looked, the develper packages looked much better. If you were develping 10 plus sites per year, it would only be like 250 each. That actually seems pretty reasonable to me. If you are only going to use it on one or two sites, then it is right pricey. Mark -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 10:22 PM To: CF-Talk Subject: Re: Creating a .cfm file on the fly On 3/12/08, C. Hatton Humphrey [EMAIL PROTECTED] wrote: (*cough*) BeSavvvy (*cough*) (*cough*) Rip Off (*cough*) *Single Web Site* Encrypted Source Code Up to 5 Users $1,350 Up to 10 Users $2,250 Up to 20 Users $3,300 Up to 50 Users $5,625 Unlimited Users $9,000 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Bluedragon = open source
I'm pretty sure they meant 'someone' like you or me...that's the idea of NA having a steering committee to determine what gets included in the code base...at least that's how I understand it. -Original Message- From: Tanguy Rademakers [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2008 2:54 PM To: CF-Talk Subject: Re: Bluedragon = open source Exactly. We don't want someone adding cfFooBar to their engine, whilst another uses cfBarFoo (or doesn't have it at all). Ideally I can take a project and run it with no changes on Adobe, or Railo, or Smith, or BD, or ... So i guess this means the CFML language is now set in stone forever? Or by someone, do you just mean someone other than Adobe? I've seen this atitude time and again in the CF community: when Adobe introduces new syntax it's innovative, but when another vendor does it's disruptive. Last year some Adobe fanboy was bitching out the NA list because the syntax of the cfthread tag is different in BD 7 and CF 8 - only to have it come to light that NA implemented cfthread before Adobe, and that it was up to Adobe to maintain compatibility. Read Vince's reply here: http://www.newatlanta.com/c/products/bluedragon/self_help/archiveSearch/deta il?messageId=221043 (yadda yadda wrap) If Adobe don't want to open up their ColdFusion server (fair enough), the least they could do would be to set up some sort of language standard, and a public process to get it altered. Unlikely, IMHO. They have nothing to gain and everything to lose. What you're proposing just makes it easier for others to compete with them. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300983 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hosting Problems
I hate to say it, but I can't imagine getting better service than you'll get at hms. I've been there for a few years and I think the longest I've been on hold before getting someone was like 10 secs. And I'm stupid and a slow learner so I've called A LOT. Good luck though. -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2008 1:19 PM To: CF-Talk Subject: Hosting Problems Hi, we have had severe problems with host my site hosting company, can anyone recommend a really good coldfusion 8 and mysql hosting site. customer service means a great deal to us, so if you have had any really good experiences with a hosting company we would really appreciate to know about it i know there are loads advertised but its more your experiences we are interested in, as any company can talk about how great they are but whether they are is another story. thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300659 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application UI's
Who's your graphics guy? Care to share? -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2008 6:40 PM To: CF-Talk Subject: Re: Application UI's heh, I'd look at it another way: you don't need icons, you need an interface designer to spend a couple of hours making it look good. My graphics guy goes through all my admin back ends and spends a couple of hours messing with the css, placing the buttons and adding icons, and making interface suggestions. The ones that he's done look and feel about 1000% better than anything I could do - and I'm pretty handy with css. -- Kay Smoljak business: www.cleverstarfish.com coldfusion: kay.smoljak.com personal: goatlady.wordpress.com On Fri, Mar 7, 2008 at 7:53 AM, Ryan J. Heldt [EMAIL PROTECTED] wrote: http://cssremix.com is a favorite of mine. However, in my opinion, although a backend can look nice, at the end of the day it should be about getting the job done, so avoid using lots of graphics and other eye candy that can get in the way. People don't necessarily remember something that's well designed, but they will remember something that isn't. Ryan Mike Little wrote: hi guys, just about to start a business to business web application for a client. this sits on the backend of their website. uptil now i have to say my backend application designs are very brrriinnnggg very simple icons with dull backgrounds. just wondered if anyone had come across some inspirational websites (or books) that may help to give me some design motivation? mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cffile and security (repost)
Good Morning, I have been working with cffile for the first time and in the process, read several places that you should upload files to a temp location outside your webroot for security reasons. My original problem was with trying to eliminate spaces from file names...so now this is the process I'm using...upload to a temp file, remove spaces and replace with _ then move the file to final location(code below) My question is, why do I have to go to a temp file first and does the code I'm using below result in the upload being secure in it's final version/location? Also, how do I deal with naming conflicts...does move allow for the same options as upload...rename, overwrite ect.? It doesn't seem to allow for a result struc. [I actually figured this one out...running fileExists before move.] Thanks for the help, just trying to make sure i'm not doing something really stupid. Mark !---Query for job folder name--- cfquery name=jobfolder datasource=#Application.dbDSN# select jobfoldername from jobs where jobId = #session.jobId# /cfquery cfoutput cffile action = upload fileField = FileToUpload destination = c:/temp accept = image/pjpeg, image/jpg, application/pdf nameConflict = MakeUnique result=result cfdump var=#result# cfset NoSpaceServerFileName = reReplace(Result.ServerFileName, \s+,_, all) cffile action=rename source=c:\temp\#Result.serverFileName#.pdf destination=C:\temp\#NoSpaceServerFileName#.pdf cffile action=move source=C:\temp\#NoSpaceServerFileName#.pdf destination=C:\cfusionmx7\wwwroot\pyramidhomeworks\JobAdmin\JobFiles\#jobFo lder.jobFolderName#\#NoSpaceServerFileName#.pdf result=moveresult br /cfdump var=#jobFolder# /cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cffile and security
Good Morning, I have been working with cffile for the first time and in the process, read several places that you should upload files to a temp location outside your webroot for security reasons. My original problem was with trying to eliminate spaces from file names...so now this is the process I'm using...upload to a temp file, remove spaces and replace with _ then move the file (code below) My question is, why do I have to go to a temp file first and is this secure in it's final version/location? Also, how do I deal with naming conflicts...does move allow for the same options as upload...rename, overwrite ect.? It doesn't seem to allow for a result struc. !---Query for job folder name--- cfquery name=jobfolder datasource=#Application.dbDSN# select jobfoldername from jobs where jobId = #session.jobId# /cfquery cfoutput cffile action = upload fileField = FileToUpload destination = c:/temp accept = image/pjpeg, image/jpg, application/pdf nameConflict = MakeUnique result=result cfdump var=#result# cfset NoSpaceServerFileName = reReplace(Result.ServerFileName, \s+,_, all) cffile action=rename source=c:\temp\#Result.serverFileName#.pdf destination=C:\temp\#NoSpaceServerFileName#.pdf cffile action=move source=C:\temp\#NoSpaceServerFileName#.pdf destination=C:\cfusionmx7\wwwroot\pyramidhomeworks\JobAdmin\JobFiles\#jobFo lder.jobFolderName#\#NoSpaceServerFileName#.pdf result=moveresult br /cfdump var=#jobFolder# /cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: comparing data in a loop
Combine the columns using an alias and query for DISTINCT? -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Thursday, February 28, 2008 3:16 PM To: CF-Talk Subject: comparing data in a loop hi, i know there must be a simple answer to this but i am braindead right now and cannot think of it. this is more of a logic question, and i am lacking it right now :) i would appreciate your help please i have data in a query, e.g. col1 col2 col3 --- 1 2 3 1 2 4 1 3 1 etc i need to be able to check that no 2 rows have the same data the problem is, is that i dont know how many columns there will be and i dont know what the unique columns will be. but i have the query and i have an array of unique columns for example i have 'col1' and 'col2' in an array called uniqueColumns() so i need to somehow search through the query to ensure that no 2 rows contain the same data - but only in the unique columns. so on the above example if i did have col1 and col2 in the uniqueColumns array then when searching through the query i need it to tell me that row 1 and 2 have matching unique columns as they both contain: col1 = 1 col2 = 2 i would be very grateful of your help thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfFile
I have a page that uploads a file, either pdf or jpg. I thought everything was working well until I discovered that some of the files are being uploaded without the file extension and some with. In the code below, the server side validation is done, then the file is uploaded, then the information is inserted in the database and then the permissions for who can view the file are placed in a separate table (many to many). Two questions: How can I make sure the database gets all the file names with the extension or that the database gets all the file name without the extension? How do I handle a file name with spaces? The database will have a file name with spaces.will that be automatically handled by the browser? Mark !---check for needed session variables, redirect if missing--- cfif not isdefined(session.jobName)Or not isdefined (session.jobId) cflocation url=#application.absoluteUrlRoot#/JobAdmin/jobAdminLogIn.cfm?message=Your Job Admin Session Has Expired cfabort /cfif cf_ValidateForm errorLocation=#Application.absoluteUrlRoot#/JobAdmin/JobFiles/JobFilesAddFo rm.cfm cf_ValidateInput variableName=Form.jobFileType label=Type of File validationType=varchar(50) required=yes !---cf_ValidateInput variableName=Form.JobFileAccessLevel label=Access Level validationType=varchar(50) required=yes--- cf_ValidateInput variableName=Form.JobFileTitle label=File Title validationType=varchar(50) required=yes cf_ValidateInput variableName=Form.FiletoUpload label=File to Upload validationType=varchar(100) required=yes /cf_ValidateForm !---Query for job folder name--- cfquery name=jobfolder datasource=#Application.dbDSN# select jobfoldername from jobs where jobId = #session.jobId# /cfquery cfoutput cffile action = upload fileField = FiletoUpload destination = c:/Coldfusion8/# Application.absoluteUrlRoot#/JobAdmin/JobFiles/#jobfolder.jobfoldern ame# accept = image/pjpeg, image/jpg, application/pdf nameConflict = MakeUnique result=result /cfoutput cf_InsertRecord table=JobFiles lookupKey=JobFileName lookupKeyType=varchar(100) redirectTo=#Application.absoluteUrlRoot#/JobAdmin/JobFiles/JobFileAccessLis t.cfm?FromAction=1 cf_PrimaryKey primaryKeyColumn=JobFileId primaryKeyType=integer cf_PassColumnToAction column=JobFileType type=varchar(50) value=#Result.serverFileExt# valueIfEmpty=NULL !---cf_PassColumnToAction column=JobFileAccessLevel type=varchar(50) value=#Form.JobFileAccessLevel# valueIfEmpty=NULL--- cf_PassColumnToAction column=JobFileTitle type=varchar(50) value=#Form.JobFileTitle# valueIfEmpty=NULL cf_PassColumnToAction column=JobFileName type=varchar(50) value=#result.serverFile# valueIfEmpty=NULL cf_PassColumnToAction column=JobFileJob type=integer value=#session.jobId# valueIfEmpty=NULL cf_PassChooserToAction spouseTable=PlumRole childTable=JobFileAccess spouseTablePrimaryKey=RoleCode spouseTablePrimaryKeyType=varchar(12) foreignKeyFromChildTableToMainTable=JobFileId foreignKeyFromChildTableToSpouseTable=PlumRole /cf_InsertRecord ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299953 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfFile
Well, one of my users insists he is uploading a pdf, but the file extension
is not getting to the database with the file name, so I just changed it to
#result.serverFileName# which doesn't ever put the file extension in the
file name column of the database (I have the file extension in another
column)...
Anyway, I still need a way to remove the spaces from a file name. I'm
guessing a regular expression of some sort. Will a regular expression do
anything other than tell me if there is a space...it won't remove a space,
will it?
Thanks,
Mark
-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 27, 2008 11:06 AM
To: CF-Talk
Subject: Re: cfFile
Nip it in the bud. Force the user to upload a file with an extension. I have
something that does this that restricts the user to only upload PDF's. BTW I
use the LeftCorner js library... It has a bunch of cf functions translated
to JS.
script type=text/javascript src=js/LeftCorner.js/script
script type=text/javascript
function validate()
{var myformvalue = document.myform.resume.value;
var myformListLen = LeftCorner.ListLen(myformvalue , .);
var myformextention =
LeftCorner.LCase(LeftCorner.ListGetAt(myformvalue,
myformListLen , .));
if (document.myform.resume.value =='')
{
alert('Please select a file to upload.');
document.myform.resume.focus();
return false;
}
if (myformextention !='pdf')
{
alert('Please select a file with pdf as the file
extention.\n\nExample: MyResume.pdf\n\n');
document.myform.resume.focus();
return false;
}
return true;
}
/script
..
form action=#CGI.script_name# method=post name=myform
ONSUBMIT=return validate(); enctype=multipart/form-data
input type=file name=resume id=resume value= /
etc.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299983
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: OT - JS Date picker
Unless you work for free, it is possible that having me rewrite the available free/OS offerings could be the more expensive route. It would seem like the least possible total cost would not necessarily preclude a purchased solution. Although, you could end up spending a lot of time tweaking a purchased solution as well. However, it seems short sighted to exclude a widget you have to pay for, if it ends up saving hours of developer time. Mark -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 20, 2008 9:03 PM To: CF-Talk Subject: Re: OT - JS Date picker If you ask me (which no one did), your boss is too picky to demand that this calendar be free. Your boss needs a better perspective on the issues here... Out of curiosity, why is that? Why shouldn't we ask the community if there is something out there that meets our requirements before dishing out money or having me rewrite the avalible free/OS offerings? Regards, Gerald On Wed, Feb 20, 2008 at 12:51 PM, Rick Faircloth [EMAIL PROTECTED] wrote: If you ask me (which no one did), your boss is too picky to demand that this calendar be free... you don't get to be too picky if you're cheap. Rick -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 20, 2008 12:11 PM To: CF-Talk Subject: Re: OT - JS Date picker Thank you. Looks good. I am mostly looking for a *Time* picker. Actually I have the Calendar working I just need the time picker. www.dynarch.com/projects/calendar The boss man doesn't like how the time selector works. @ Robert Harrison. We are on CF 7 at the moment. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299580 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: No 64-bit on Windows for CF8?
I know what I'd put my money on. -Original Message- From: Vincent Krist [mailto:[EMAIL PROTECTED] Sent: Thursday, February 21, 2008 1:05 PM To: CF-Talk Subject: Re: No 64-bit on Windows for CF8? Will CF8 Standard Edition be able to use the 64-BIT JVM or is it only going to be available to the Enterprise Edition? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299615 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: ColdFusion: Some People Just Don't Know Any Better
It is interesting, that while the developer community has been belly achin' about prices for cf, Adobe has actually raised the price for enterprise 50%. It might also be worth noting that cs3 web premium, which I recently purchased (upgrade thankfully) is priced at 1600. Considerably higher than cf standard. Mark -Original Message- From: Will Swain [mailto:[EMAIL PROTECTED] Sent: Thursday, February 07, 2008 3:42 PM To: CF-Talk Subject: RE: ColdFusion: Some People Just Don't Know Any Better We have seen an official response: http://www.adobe.com/products/coldfusion/buy/ :) Will -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 07 February 2008 19:57 To: CF-Talk Subject: RE: ColdFusion: Some People Just Don't Know Any Better Not anyone who's going to tell you how to run your business, no. But you know that Ben Forta and the rest of the product evangelists are plugged into this list and other well-known CF resources, so presumably someone at Adobe has heard all of these criticisms before. If all of this has been heard before, should've we have seen an official response to this somewhere? I remember at the last CFUnited people brought up that CF should be marketed better to universities. And they're like yea yea we should... but they never did anything about it to my knowledge. Russ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298484 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFC, YES OR NO
Benign I'm sure everyone on this list will say yes to learning oop right away. Well, almost everyone. I'll point you instead to productivityenhancement.com where you can download a framework called PLUM. Plum is a framework that uses the best of what coldfusion was designed to be...a quick, easy to learn, scripting language that makes extensive use of custom tags. Download plum, work through the tutorials you'll be building scalable, robust applications in half the development time as the more seasoned oop developers do. Plum makes extensive use of CFC's, but it also has a few dozen custom tags that make development much faster and easier to learn and creates a natural procedural/oop hybrid framework. Not only will you be up and running much faster, but as you delve into the framework's code, you'll learn, by osmosis, best practices for coldfusion development. When you are ready to learn oop, start with an oop language (oop + coldfusion is a bit of a hack), like AS 3.0 or java or .net/c#. Mark -Original Message- From: Ali [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 06, 2008 10:38 AM To: CF-Talk Subject: CFC, YES OR NO Hi: I am using CF for while now but I have no other programing background. I used Lynda.com video tutorials to learn CF and some other online tutorials like EasyCFM.com. Several days efore I recieved two new CF8 tutorials from Lynda.com(Lynda.com ColdFusion 8 Essential Training | Lynda.com ColdFusion 8 Beyond the Basics) but I got confused completely! David Gassner the tutor has a complete plan to talks about many corners of CF but he starts using CFCs very soon at the middle of the first tutorial. He mentions you can never use CFCs and make all the application using simple CF tags but knowing CFCs helps you make it more reusable and manageable. I found CFCs VERY confusing for myself. I tried to learn it but I didn't get it completely. Maybe because I have no programing background with other languages other than HTML. What do you think? Should I learn it? Does it gradually become the core of CF programing to use CFCs? Please write me your opinions, knowledge and experiences about the subject. Thanks Benign ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFC, YES OR NO
Yes, Plum is easy to learn, although I think most Plum users are much more advanced than I am, so it is worth noting that it can grow with you as your skills grow. The documentation/tutorials are quite complete through the beginning levels and you can probably work through the tutorials in an afternoon. The rest you can pick up on your own. You can use the whole framework and all that it offers or you can use it just for the application framework/security/css management and code all your pages in the traditional manner. I do both within the same applications. I have a hard time understanding why PLUM was not better received with in the coldfusion community as a whole. I understand it is not oop or certainly not pure mvc...I understand it was written by titans within the coldfusion community that didn't get along with other titans within the coldfusion community...I get that the Plum IDE (it is not really an ide, it's a crud generator) is built in .net, which rubs many the wrong way... but it really is a fantastic bit of work... Mark -Original Message- From: Ali [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 06, 2008 1:47 PM To: CF-Talk Subject: Re: CFC, YES OR NO On Feb 6, 2008 7:58 PM, Mark Fuqua [EMAIL PROTECTED] wrote: Benign I'm sure everyone on this list will say yes to learning oop right away. Well, almost everyone. I'll point you instead to productivityenhancement.com where you can download a framework called PLUM. Plum is a framework that uses the best of what coldfusion was designed to be...a quick, easy to learn, scripting language that makes extensive use of custom tags. Download plum, work through the tutorials you'll be building scalable, robust applications in half the development time as the more seasoned oop developers do. Plum makes extensive use of CFC's, but it also has a few dozen custom tags that make development much faster and easier to learn and creates a natural procedural/oop hybrid framework. Not only will you be up and running much faster, but as you delve into the framework's code, you'll learn, by osmosis, best practices for coldfusion development. When you are ready to learn oop, start with an oop language (oop + coldfusion is a bit of a hack), like AS 3.0 or java or .net/c#. Mark -Original Message- From: Ali [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 06, 2008 10:38 AM To: CF-Talk Subject: CFC, YES OR NO Hi: As a matter of fact I saw your suggestion and it looked very nice. Did you ever use the framework yourself? Is it easy to learn? Is it easy to make applications with PLUM? Thanks Ali ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Secure login system
That's pretty smart. -Original Message- From: Al Musella, DPM [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 05, 2008 3:35 PM To: CF-Talk Subject: Re: Secure login system the only other thing I would add is a counter of bad log in attempts. if 5 attempts failed, I would lock out the account for a minute. If more than 20 attempts, I lock it out until I reset it. I have one very important page set up so that the user has to log in with the same set of credentials twice. the first time it appears that it didn't work. I tell the users (only a handful of people) they have to do it twice. I figure anyone hacking in will never try the same set teice. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help with Regular expressions
Trying to wrap my head around this and get it to work with the framework I'm using...what does this say, in words... [^a-z0-9] does it say characters other than a-z, 0-9 or only characters a-z, o-9? thanks -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Monday, February 04, 2008 11:32 AM To: CF-Talk Subject: RE: Help with Regular expressions cfif REFindNoCase([^a-z0-9], yourString) Bad chars /cfif Adrian -Original Message- From: Mark Fuqua Sent: 04 February 2008 16:30 To: CF-Talk Subject: Help with Regular expressions I need to check and see that a form field has no special characters or spaces, only 0-9 and a-z. I'm guessing a regular expression could do that.? I need a regular expression to do a pattern matching test.if it has anything other than a-z or 0-9 it should fail. Thanks Mark Fuqua ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298069 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Help with Regular expressions
I need to check and see that a form field has no special characters or spaces, only 0-9 and a-z. I'm guessing a regular expression could do that.? I need a regular expression to do a pattern matching test.if it has anything other than a-z or 0-9 it should fail. Thanks Mark Fuqua ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Upload progress bar
I think an animated gif like Will suggested would be the easiest way to go and accomplish the most important think...let the user know something is happening. Mark -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Saturday, February 02, 2008 2:49 AM To: CF-Talk Subject: Re: Upload progress bar I've been using Flex do do this for some time now and it works well: http://www.adobe.com/devnet/coldfusion/articles/multifile_upload.html It even checks filesizes before upload and allows multiple files in one operation. On Feb 2, 2008 4:41 PM, s. isaac dealey [EMAIL PROTECTED] wrote: Put simply, you can't. Really? Check this out: http://php5.bluga.net/UploadProgressMeter/demo.php Grumbles to self Well that one isn't working for me with Firefox 2 and a 512kb file (says a 250kb file should be a good demo for most connections)... Instead I get upload complete pretty much instantly followed by a javascript error. However. If you get really creative, I would think you might be able to fake something that's semi accurate some of the time (when the weather is just right). Avoid trying to use Ajax to send the file -- that's liable to just frustrate you even more. Submit the form via an iframe instead and on the request that receives the form submission, check initially for the length of the request data using getHTTPRequestData() It's a rarely used function that almost nobody knows about (of course because it's rarely used) - here's the livedocs article http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/w whelp.htm?context=ColdFusion_Documentationfile=0482.htm I *think* that you can fetch that prior to your cffile tag and use it to figure out how much data is coming up. Though you still would need to have a way of roughly figuring the user's connection speed, which with larger files will also fluctuate during an upload, and there won't be any way to really guage the fluctuation since you don't get any feedback from cf between the start and end of the cffile tag processing. So yeah, the short answer is still no. The long answer is basically not reliably the way you'd want it to work. This might not be a bad time to submit a feature request for CF9 to add an attribute or maybe a sub-tag to the cffile tag that would allow it to execute some kind of progress monitoring code at intervals. If for no other reason than that this question crops up pretty regularly on mailing lists. I would think something like: cffile action=upload filefield=yadda cffileprogress interval=1000 cfset session.fileprogress = cffile.percentcomplete / /cffileprogress /cffile That's a real crude, off the top of my head thought. Interval would be miliseconds, so it'd update the fileprogress once per second and then you'd use a series of ajax calls or the like at similar intervals to update the original page. All of which still hinges on my guess being correct that the page starts executing (or can) before all of the multi-part/formdata is finished transferring. I honestly don't know if the webserver will allow that. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.org/blog ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297997 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
xml problems
NOTE** I sent this quite a while ago, but I think the xml at the bottom may have exceeded the email length allowed by the cftalk filters. So I have put the complete xml mentioned at the end on the server. I have a page that uses anygantt swf chart that uses an xml document to render the gantt chart (www.anychart.com if you're curious). You can find an example of what I am trying to do here www.mdcommercial/jobschedule.cfm This page will render correctly in ie 6 but not firefox. If you view the chart in ie6 and click the link at the bottom that says view xml for this chart, it will show an error message about expecting a semi colon. The xml is built from a cfm page that queries a database for the information. The complete xml that is created is as follows.I don't see where a semi colon should go.or what else might be the problem.any help would be appreciated. Mark View complete generated xml here www.mdcommercial.com/generatedxml.htm (you'll have to view source to see the xml) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297311 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT css/flash question.
I'm using a template from freetemplates.com. The css file seems quite well
done. I want to replace an image with a small flash movie. I thought I
would just eliminate the image, and embed the movie in the html page.
However, when I just put the movie on the page, as is or in between two
div tags, it will display, but nothing on the page below it will. Here is
the code from the page with the swf:
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.1//EN
http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd;
html
head
meta http-equiv=content-type content=text/html; charset=iso-8859-1/
meta name=description content=description/ meta name=keywords
content=keywords/ meta name=author content=author/ link
rel=stylesheet type=text/css href=default.css/ titlePyramid Home
Works/title
/head
body
div class=main
div class=gfxh1Pyramid Homeworks/h1/div
object classid=clsid:d27cdb6e-ae6d-11cf-96b8-44455354
codebase=http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.
cab#version=8,0,0,0 width=766 height=250 id=pyramidHeader6
align=middle
param name=allowScriptAccess value=sameDomain / param name=movie
value=pyramidHeader6.swf /param name=quality
value=high /param name=bgcolor value=#141a27 /embed
src=pyramidHeader6.swf quality=high bgcolor=#141a27 width=766
height=250 name=pyramidHeader6 align=middle
allowScriptAccess=sameDomain type=application/x-shockwave-flash
pluginspage=http://www.macromedia.com/go/getflashplayer; /
div class=menu
a href=index.htmlspanHome/span/a
a href=index.htmlspanAbout Us/span/a
a href=index.htmlspanGallery/span/a
a href=index.htmlspanContact Us/span/a
a href=login/LoginForm.cfm id=lastspanCustomer Log
In/span/a
/div
div class=content
div class=item
..page content continues.
It doesn't seem to matter whether the flash object is wrapped in div tags or
not, everything below the movies goes away.
If I could grow a brain real fast, what I'd really like to do is replace the
image in the div class =gfx referenced on this page to the css template.
The class on the css template looks like so:
/* Header */
..gfx {
background: #222 url(img/dark_pixel.jpg) no-repeat;
height: 240px;
But, one way or the other, what I'd really like to do is get the swf to show
along with the other content below it.
Thanks,
Mark
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296732
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT sql question
I think I need to be using 'IN' within my WHERE clause but I can't seem to get it to work. I have a column with a comma delimited list. This is the latest attempt and it craps out too. SELECT.. ...WHERE JobFileJob = #session.jobId# AND '#session.UserRole#' IN (JobFileAccessLevel) JobFileAccessLevel is a field in the database table that contains a comma delimited list of access levels. Maybe I'm barking up the wrong tree entirely. What I'm trying to do is. ..WHERE jobFileJob=#session.jobId# and jobFileAccessLevel CONTAINS '#session.UserRole#' But I don't think 'contains' exists. Thanks, Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SOT sql question
My mechanic likes to tell me that I should inform him what my car is/is not doing and let him do the diagnosing. Maybe I should try that with this problem also. Using a form, 'JobFileUpload.cfm', files are uploaded to the server to a folder based on JobId and a then a record of jobId, file name, file type and access level/levels is inserted in the database table 'jobFiles'. I know I could do a another table with JobFileId's and Access levels, instead of a list of access levels, but it seems cleaner this way. On JobFileList.cfm, I want to filter on jobId and the current users access level which is stored in #session.PlumUserRoles# Any idea how I might do that? Thanks, Mark -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 12:11 PM To: CF-Talk Subject: Re: SOT sql question On Jan 9, 2008 8:56 AM, Mark Fuqua [EMAIL PROTECTED] wrote: I think I need to be using 'IN' within my WHERE clause but I can't seem to get it to work. I have a column with a comma delimited list. This is the latest attempt and it craps out too. SELECT.. ...WHERE JobFileJob = #session.jobId# AND '#session.UserRole#' IN (JobFileAccessLevel) JobFileAccessLevel is a field in the database table that contains a comma delimited list of access levels. you're doing it backwards :) SELECT foo FROM bar WHERE foobar IN (a,b,c,d) says give me records where the value of foobar is either a OR b OR c Or d. IN, is a shorthand way of writing out a number of OR statements. it'd be wrong of me to not state here that generally speaking, storing comma delimited values in a relational database table is (again, generally) not a good idea and defeats the purpose of a relational database. those values should (likely) be broken out into a new table as individual rows (with an ID column having a FK relationship back to the original table). -- Scientists tell us that the fastest animal on earth, with a top speed of 120 feet per second, is a cow that has been dropped out of a helicopter. - Dave Barry ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296279 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: SOT sql question
Nuf said. I'll do it the right way. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 1:12 PM To: CF-Talk Subject: Re: SOT sql question Mark Fuqua wrote: I know I could do a another table with JobFileId's and Access levels, instead of a list of access levels, but it seems cleaner this way. It is not. You have denormalized your data in such away that doing the type of select you want to do is very difficult. If you had a normalized database scheme with this data in a related table it would be a trivial join and where clause to get the exact records you want. On JobFileList.cfm, I want to filter on jobId and the current users access level which is stored in #session.PlumUserRoles# Any idea how I might do that? If you insist on using this database design you are going to have to use the LIKE operator in the where clause with a bunch of possibilities. Lets say you want to look for an AccessLevel of '3'. You are going to have to write a where clause something like. WHERE accessLevel LIKE '%,3,$' OR accessLevel LIKE '%,3' OR accessLevel LIKE '3,%' ect. And this does not even address the problems of making sure you do not match threes in the possible values of '13', '32', '33' ect. Contrast this with this. SELECT stuff FROM aTable JOIN bTable ON aTable.key = bTable.fKey WHERE bTable.JobFileAccessLevel = 3 Personally I find the latter much cleaner. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296290 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
formating date
I have to use dates in an xml document. The date comes from the database like so. 2008-02-01 00:00:00.0 I need to get rid of the time and replace the dashes with periods to make the format as follows: 2008.02.01 This will be done inside a query loop of maybe 30 records with two dates each. Is there a regular expression that can do this or should I pull date parts out? Thanks, Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
another date format problem
This works #DateAdd(d, 7, 1/28/2008)# And this works #DateFormat(startdate, 'yyy.mm.dd')# I need to combine them. Take the variable startDate, add 7 days and format it like above in one expression. Is that possible? I know this is wrong, but something like this: #DateAdd(d, 7, DateFormat(startDate, 'yyy.mm.dd')# Is this what evaluate is for? Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295721 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: another date format problem
Thanks guys. -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 02, 2008 4:49 PM To: CF-Talk Subject: another date format problem This works #DateAdd(d, 7, 1/28/2008)# And this works #DateFormat(startdate, 'yyy.mm.dd')# I need to combine them. Take the variable startDate, add 7 days and format it like above in one expression. Is that possible? I know this is wrong, but something like this: #DateAdd(d, 7, DateFormat(startDate, 'yyy.mm.dd')# Is this what evaluate is for? Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295726 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: sql editor
Forgive me in advance for the heresy, but try MS Access's query builder. It is pretty easy to use and gives you three choices for viewing the results...one of them is sql. That view gives you the sql you can cut and paste anywhere. Mark -Original Message- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] Sent: Friday, November 30, 2007 7:29 AM To: CF-Talk Subject: sql editor Hi everybody: I need to make some complex cfqueries and I wonder if there any easy to use software is out there I can use to make the sql statements easier than writing down all of them. I don't mind if it is a 3rdparty program or a cfeclipse addon or a dw extension, I just need something to help me drag and drop my Database tables into that and make the relationships and the program gives me the sql script without bugs cause when I write them they have some typo and non-typo bugs and it makes my life really hard. Thanks benign ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293999 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Consultancy
http://www.carehart.org/askcharlie/ -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 1:48 PM To: CF-Talk Subject: Consultancy So, with talk of help/support What are peoples recommendations on ColdFusion consultancy for things like performance monitoring/tweaking etc. Especially UK based but not essential. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ANN: GotCFM.Com is Launched - Dedicated to CF Evangelism
me too. -Original Message- From: Christopher Jordan [mailto:[EMAIL PROTECTED] Sent: Saturday, March 03, 2007 3:29 PM To: CF-Talk Subject: Re: ANN: GotCFM.Com is Launched - Dedicated to CF Evangelism I for one am glad to hear you say that Rey. :o) Chris Rey Bango wrote: Hi Chris, As Andy mentioned, the list is moderated to prevent things such as: - Bogus websites - Spam - Sites that contain any type of inappropriate content such as racism, hate-groups, illegal porn and that sort of stuff And just so everyone knows, I'm very lenient in terms of which CF sites are included into the list but reserve the right to *NOT* add or completely remove a site of they fall into any of the categories above. Rey Christopher Jordan wrote: Hey guys, I just posted two sites, and they're not showing on the list yet. Is there a delay between sites being submitted and when they show on the list, or do I need to re-add the sites? Chris ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271410 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Fusebox Web Site Design Contest Announced
Blah Blah Blah vs. blah blah blah = lots of blah blah blah I would suggest maybe you shouldn't enter the contest. Just a thought. -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 4:35 PM To: CF-Talk Subject: RE: Fusebox Web Site Design Contest Announced The problem with this contest is that people are being asked to contribute a significat amount of time with no guarentee of winning. This isn't like spending a dollar to enter the lottery. I budget a minimum of 20-30 hours of my time with ANY design project. -Original Message- From: Scott Stroz [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 3:22 PM To: CF-Talk Subject: Re: Fusebox Web Site Design Contest Announced I agree with you. In a contest, there is always something to win, but when the only winner is the one who set up the contest, it is not a contest, it's a rip-off ;-) Couldn't that be said of EVERY contest? I would agree with you ONLY if the one setting up the contest was a business who stood to benefit, but we are talking about a group of people who dedicate a lot of their own time for the benefit of the community. And not one of them gets ANY compensation to do so. So, by offering up a prize, they are actually giving someone not only a chance to help the community, but to profit from it as well. -- Scott Stroz ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269361 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FLEX Questions
I hope your five year old enjoys learning flex. It is not licensed to you, or your wife, or your coworker or me, just your daughter. In addition, I believe there is a stipulation about commercial use as well. Mark Fuqua -Original Message- From: So Kenfused [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 07, 2007 9:36 AM To: CF-Talk Subject: Re: FLEX Questions Yes, I bought a copy for my 5 year old in Kindergarten. Bruce Sorge wrote: So I have a daughter who is in HS. That counts? Bruce ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268983 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FLEX Questions
Is Bruce a student? -Original Message- From: So Kenfused [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 5:11 PM To: CF-Talk Subject: Re: FLEX Questions FLEX Builder 2.0 with charting, Educational pricing $99.00. (price for students k-12, college, and teachers). Go to Adobe.com search for educational pricing Bruce Sorge wrote: Well I have been messing with Flash Forms quite a bit and I think that they are pretty cool, so now I think I am ready to take the leap to FLEX. I have been hearing a lot about it so I was wondering: 1. What books/sites do you all recommend to learn Flex? 2. What skills beyond CF are required? 3. Is there a special IDE that is involved for programming in Flex? 4. Any special server site apps that need to be installed? Thanks, ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268915 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FLEX Questions
You guys are kidding, right? -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 5:46 PM To: CF-Talk Subject: RE: FLEX Questions So I have a daughter who is in HS. That counts? Bruce Yup, I assume she will let you use it won't she. Just like the 1st grade daughter some I know is letting him borrow her copy. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FLEX Questions
Here here! I despise thieves. At least if your honest enough to just use a pirated version, you're honest enough to admit what you're looking at in the mirror. Mark Fuqua -Original Message- From: Dale Fraser [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 9:32 PM To: CF-Talk Subject: RE: FLEX Questions I'm not sure this is much better than getting a pirated version. It is not the intention of the scheme, and if you're just not interested in buying it and have to resort to scams like this then you might just as well just get a pirated version. Not sure, but does paying the $79.95 make you sleep better? Regards Dale Fraser http://dale.fraser.id.au/blog -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED] Sent: Wednesday, 7 February 2007 1:02 PM To: CF-Talk Subject: Re: FLEX Questions Flex Builder 2 Win or Mac $79.95 + free shipping. http://www.academicsuperstore.com/item/?tname=270585title=Flex+Builder It does require qualifications but there are several categories (student, teacher, staff, home school, etc) and they'll tell you what is required since it varies based on the Vendor. Definitely worth checking to see if you legitimately meet the criteria. Ken ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: moving from CF 4.5 to 7.0
No personal experience, but I think the info you find about 4.5 to MX or especially 6.1 would translate well. I think 7.0 was mostly about adding features and fixing bugs, not a big rewrite of the code base. Mark -Original Message- From: So Kenfused [mailto:[EMAIL PROTECTED] Sent: Monday, February 05, 2007 2:49 PM To: CF-Talk Subject: moving from CF 4.5 to 7.0 Just started a new job and they are looking at moving from CF 4.5 to CF7. We do have a Dev box, so we can play a little before doing it on the production boxes. I'm finding several posts about going from 4.5 to 5, or MX and the issues people ran into however, I am wondering if anyone who has made the jump from 4.5 to 7 can provide details to any issues they might have experienced. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268736 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Flex 2 and Ben Forta
Rick, A full version of studio is $800. A full version of Adobe creative suite is $1200. Upgrades of course are much less expensive. People are already working on alternatives using primalScript and ANT. For me, I have already set aside my $1000. Adobe's will be the best for sure and will be the only one with a visual design component similar to dreamweaver. And from what I have seen, it is quite useful. To each there own. Mark -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 01, 2006 9:01 PM To: CF-Talk Subject: RE: Flex 2 and Ben Forta It's hard for me to believe an IDE would be worth $1000 (oh, excuse, me $999, which is less than $1000 :P ) Most design software, whether it's for web design, as in Dreamweaver, photo manipulation, as in Photoshop, graphics, as in Illustrator, etc., is not even that much...most of it not anywhere near $1000 unless you get everything in a bundle. Perhaps I'm just showing my ignorance about the Flex IDE, but with it priced so high (I don't, at this point, see how it could possibly be worth that much money), it's wide open for a company with hungrier developers to come in and sell something for half that and take a lot of business from Adobe and Flex...what makes it worth $1000? Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233868 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Flex 2 and Ben Forta
and you would whine less if it was 600? Somehow I doubt it. Mark -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, March 02, 2006 11:09 AM To: CF-Talk Subject: RE: Flex 2 and Ben Forta So what about those of us who just don't like Eclipse? I've tried it several times and each time I return to my copy of Editplus wondering what all of you are raving about. I'm now knocking it, or you Dave, but it I don't care WHAT it can do, the fact is that it's competing against other stuff that can do the same thing and some of those options are free. It just seem a little excessive for Adobe to charge $999. Why not $500? Or even $600. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233924 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Flex 2 and Ben Forta
Free ColdFusion could work. It would have to work for Adobe too though. How about adding one more level... ColdFusion BasicFREE no cfmail, cfchart, cfr's, cfc's, cfforms, no mysql support (essentially the old free version of Blue dragon). License limited to one domain. ColdFusion Standard (renamed professional?) 1200 (although 900 looks better) ColdFusion Enterprise $5000 Adobe would benefit from increased market/developer share as more people became acquainted with the power and simplicity of ColdFusion, then the benefit of ColdFusion Professional for 1200 would be easy to grasp. And once a company needs enterprise level software, $5k is not much, especially if all your apps already run on coldfusion. Mark -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, March 02, 2006 3:11 PM To: CF-Talk Subject: RE: Flex 2 and Ben Forta Hmmm... So CFEclipse must not be a good tool then. Open Office must not be good. Winamp, the Flash player, Linux. All of those must be total trash because they're free. The point I'm wanted to make is that I love ColdFusion and want it to succeed. Some clients/companies simply can't get past the fact that CF costs $1200 minimum to get into ColdFusion when PHP is free. You and I both know the pros and cons to free software like PHP, but the client doesn't see past the dollars signs. And by the way...I said ColdFusion should be free...my names Andy Matthews. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233991 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: What's the name of the latest site for CF coding / archiving?
I think you are referring to Ray's cookbook: http://www.coldfusioncookbook.com/ Mark -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, February 13, 2006 3:37 PM To: CF-Talk Subject: What's the name of the latest site for CF coding / archiving? Hi, all... We were discussing a new site put up recently by one of you guys and I cannot for the life of me remember what it was called and did not save the URL. It was a site for fairly short tips and tutorials to achieve small functionality...shot and quick tips... What was that site? Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232142 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
Some disclaimers: I'm no brainiac, I'm a pretty green programmer and from reading the posts on this list, I am sure 99% of the people who post to this list are smarter than I am. Having put the aforementioned disclosers on the table, I do not understand what MMAdobe could do to make Flex 2.0 more clear either as far as the pricing structure is concerned or the advantages it brings to the table for developers. In addition, I cannot for the life of me understand how the MMAdobe Labs could be more geared towards developers. I am sure there is plenty of marketing hype aimed at IT guys now and tons more to come, but right now MMAdobe is doing their very, very best to reach YOU the developer...especially YOU the ColdFusion developer. Flex will be cheap (or free if you don't want an IDE specifically designed for FLEX) and is essentially, AJAX or FLASH UI without the hacks, headaches, hassle and really steep learning curve. btw...I went to the labs site and couldn't even get the example apps to show...could be a problem on my end however...but don't see why... The examples now posted at MMAdobe Labs require the latest build (beta) of Flash player 8.5. I'm slow, it took me a little while to figure that out. Happy coding fellas, no harm or insult intended. Mark Fuqua ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232009 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: ColdFusion and Flex
Actually, FLEX is free. Period. Flex builder, which is the eclipse based visual IDE MMAdobe has developed for MXML and AS, is said to be $1000. Personally, I will be jumping on FLEX Builder for $1000. But you will be able to develpe flex sites for free if you set up another IDE (I have seen some posts about someone setting up ANT and primal or something like that...didn't read as I am going to buy FLEX builder). Adobe is even allowing a free version of FlexEnterprise Services (which I think for anything I can see doing will be overkill.) with up to 35 concurrent users. I can't wait for Flex2.0 and if you do ColdFusion, you should seriously take another look...Adobe is giving Coldfusion develpers a big foot forward with the Flex to Coldfusion Connector. It is worth your time to take another look Mark -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 3:02 PM To: CF-Talk Subject: Re: OT: ColdFusion and Flex flex is supposed to now be $1000 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231831 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Need Help Extending Components
Just for thought...lots of people (including me) have multiple email addresses and use them interchangeably. Maybe if the email address was also the user name that would reduce the chance of people using multiple email addresses? -Original Message- From: Aaron Roberson [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 7:36 PM To: CF-Talk Subject: Need Help Extending Components Friends, I am creating a newsletter enrollment form on our company website and would like to be able to create a new user for each newsletter subscriber. To do this, I am trying to use the insert query from my insertUser method within my user component to insert newsletter subscribers into the user table. The user CFC contains an insertUser method that inserts basic information such as First and Last names, email addresses and password into one table, billing info into another table, shipping into another, and extra forum related info into yet another table. The newsletter CFC will contain a method that will check for the existance of a user in the USERS table by evaluating the email address, insert a new user into the USERS table if a record does not already exists, and insert the userID and newsletter ID into a linking table that will join the USERS table and a NEWSLETTER table (containing a list of seperate newsletters). MY AIM Overall, there will be three ways a site visitor can create an account; newsletter subscribers, forum users, and shopping cart accounts. Instead of creating a new profile for each of these purposes, I would like each visitor to have access to all three of these features through one user account. That way, if a visitor subscribes to our newsletters, and later want to create a shopping cart account, they can update their existing profile with their shipping and billing information. If they wanted to become a forum poster, they could update their profile with their Yahoo! (or MSN or Google, etc) Messenger account, Avatar, etc. etc. That would make it so that their entire profile could be managed in a single account. Thanks in advance for your suggestions, Aaron ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231535 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: join statements with MS Access
The query builder in access works real well and is pretty easy too. Load in all the tables in your query (I have found it best to load them in the access order l to r) and then add the columns. Of course for this to work, you have to record your relationships in the relationship tool. Works well though. mark -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Monday, January 30, 2006 2:11 AM To: CF-Talk Subject: RE: join statements with MS Access What I have found with access, besides being a pain is to put all your tables names on the FROM line and do your joins on the WHERE line, then let access calculate the inner joins for you. To do that open access and create a new query (like a view in sql server), then right click to see the sql view, paste your query, then close and save. Open the query again and go to sql view and you should see the proper inner joins with the parenthesis the way access likes them. Hope that helps. Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer http://www.aftershockweb.com/ -Original Message- From: CF-Talk [mailto:[EMAIL PROTECTED] Sent: Sunday, January 29, 2006 10:06 PM To: CF-Talk Subject: CF-Talk: Digest every hour Is there anyone on the list who can help me figure out where to put the parenthesis for multiple join statements? This isn't working: SELECT * FROM [ARTISTS] AS [P] INNER JOIN ([ART] AS [A] INNER JOIN [MEDIA] AS [M] ON [M].[mediaid] = [A].[MEDIAID]) ON [A].[artistid] = [P].[ARTID] These tables are from the cfcodeexplorer.mdb that's part of the CF examples. Frustrates the hell out of me because they don't wrap the item they belong to, instead they wrap part of the item they belong to and part of the parent item... and they seem to change places between 0 and 3 joints (after 3 they seem reasonably consistent)... ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230727 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
standard vs. enterprise
I am curious about the difference between ColdFusion standard and enterprise edition. After looking at the comparison matrix at macromedia, it seems the main difference is performance and gateways. Are there other differences? At what point (number of concurrent users +/-) does enterprise become necessary? Can standard run more than one app? Is it easy/simple to manage a coldfusion/sql2005 express set-up with no admin experience? How stable is ColdFusion? Sorry to ask so many questions, I guess I should have started several different threads? Mark Fuqua ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229152 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf open shopping cart
I think alot of this has to do with the size of the communities. I just downloaded the QuickBooks SDK and was interested in finding some information about how to integrate it with my application using web services. Since I am a bit green, I decided to see if someone had already done it and searched for ColdFusion on the site, which also included a search of the developers forums. It returned no results, so I tried cold fusion as two words and got one match. That match was a bust...basically an ad for a third party program which could be used by cold fusion as well as every other language out there. So I tried PHP...it returned over 6500 records! I think our beloved ColdFusion has a rather small following. Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228988 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Verity vs. sql indexing
I know the answer is verity is better at full text searches, but I am curious how much better and at what point. I have a notes table with a memo field. If I have the memo field indexed by the database, how many records does in need to reach before it starts having a hard time with contains searches? The benifet of the database, from my very finite view point, is it gets indexed everytime a new record is added, and the user interface and code would be exactly the same as all my other search pages, which just set the where clause for the select statement. thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228627 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Verity vs. sql indexing
Well, I discovered one problem, Memo fields cannot be indexed, so notes field, if it is to be indexed, is limited to 255 characters. Mark -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Friday, January 06, 2006 9:16 AM To: CF-Talk Subject: Verity vs. sql indexing I know the answer is verity is better at full text searches, but I am curious how much better and at what point. I have a notes table with a memo field. If I have the memo field indexed by the database, how many records does in need to reach before it starts having a hard time with contains searches? The benifet of the database, from my very finite view point, is it gets indexed everytime a new record is added, and the user interface and code would be exactly the same as all my other search pages, which just set the where clause for the select statement. thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228629 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Bug tracking app using Oracle as a backend
Check lighthouse again. I think Ray may have got rid of the flash forms which I think were the primary reason it had to run on 7.0 Mark Fuqua -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Monday, January 02, 2006 1:52 PM To: CF-Talk Subject: Re: Bug tracking app using Oracle as a backend Forgot one more requirement. It has to run on ColdFusion 6.1 or .NET, sorry. I would definitely use Lighthouse if not for the CFMX 7 requirement. Bob Everland ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228154 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Let's *ALL* give something back to House of Fusion!
I was gonna wait til Tuesday, when things are not so crazy, but if you are matching all donations, I'll beat the deadline. What is the deadline for your matching all donations offer? Mark -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Saturday, December 24, 2005 10:02 AM To: CF-Talk Subject: Re: Let's *ALL* give something back to House of Fusion! Any more matching-donor-takers? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227672 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: How can I use a .Net DLL with CFMX?
Hey, I don't know much about Blue Dragon, but I think your frustration is one of the reasons why they decided to develope a CFML compiler for .NET. I am sure there are lots of others, but surely close ties with the Windows OS was one. Mark -Original Message- From: Simon Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 14, 2005 2:25 AM To: CF-Talk Subject: Re: How can I use a .Net DLL with CFMX? were looking for a similar solution, however cannot risk moving to BD (lots of existing code needing to be re-tested etc) Is there no neat way of using a dll without resorting to web services ? Seems the extra overhead of TX/RX in a web service is redundant for using a piece of code that may be on the same machine. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226998 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Custom Tags Folder
Hey there, I don't know if it will work with other applications, but the Churvis's wrote a utility for Plum which converts all the custom tag calls (and there are alot of custom tag calls in a PLUM application) to cfModule. Here is what they wrote about it... ...We created a drag-and-drop utility for converting a safe copy of a Plum application from using CF_ syntax to using CFMODULE syntax, with all the proper closing rules for Plum custom tags (and most others) properly implemented. The perfect companion to Plum -- especially if you're deploying in a shared hosting environment. You can download a copy from www.productivityenhancement.com Post back and let us know if it works for your applications. Mark -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Thursday, December 08, 2005 8:28 AM To: CF-Talk Subject: Re: Custom Tags Folder What tests have you done to show cf_ is faster than cfmodule? On 12/8/05, Snake [EMAIL PROTECTED] wrote: Cfimport is fastest Cf_tagname next Then cfmodule -- === Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226623 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF_Accelerate
smokey- take a pill...or two! -Original Message- From: smokey bear [mailto:[EMAIL PROTECTED] Sent: Saturday, December 03, 2005 12:38 PM To: CF-Talk Subject: Re: CF_Accelerate Why even bother replying when you (a) add no new information to the discussion and (b) are so clearly clueless? h...never heard of it...what does it do to accelerate?? You mentioned locking everywhere...well then it must be old as locking can be handled automatically since version 6.0 ;-) Wouldn't a dual Xeon machine serve that fast anyways?? ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226025 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Shopping Cart Coupon facility
Hey there, Sorry to sound so hack-like, but how about putting a code in the coupon (coupon = jer456 or jer897 for a coupon meant for a jersey) that specifies what the coupon specifically applies to, or a generic code which specifies no required product (coupon = gen345 for generic). Then do a check: if the coupon is not generic, meaning a specific product should be in the cart, call a function that loops over cart contents looking for the specific product type, returning pass/fail result. Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225813 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Shopping Cart Coupon facility
Sorry to sound so hack-like, but how about putting a code in the coupon (coupon = jer456 or jer897 for a coupon meant for a jersey) that specifies what the coupon specifically applies to, with a generic code which specifies no required product (coupon = gen345 for generic). Then if the coupon is not generic, meaning a specific product should be in the cart, call a function that loops over cart contents looking for the specific product type, returning pass/fail result. Mark -Original Message- From: Mike | NZSolutions Ltd [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 9:17 PM To: CF-Talk Subject: Shopping Cart Coupon facility hi there, i have the following function which checks the validity of a coupon code at checkout time. when uploading a new coupon, the site admin can specify a minimum amount spent as well as having it available for any purchase... -- cffunction name=isValid output=false access=public returntype=numeric cfargument name=promotion_uuid type=string required=true cfargument name=customer_id type=numeric required=true cfargument name=order_subtotal type=numeric required=true cfquery name=getPromotion datasource=#Request.App.dsn# password=#Request.App.DBpassword# username=#Request.App.DBusername# SELECT promotion_id FROM promotions WHERE promotion_uuid = cfqueryparam cfsqltype=cf_sql_varchar value=#arguments.promotion_uuid# AND dExpiry = cfqueryparam cfsqltype=cf_sql_date value=#now()# AND amount_min = cfqueryparam cfsqltype=cf_sql_decimal value=#arguments.order_subtotal# scale=2 AND enabled = cfqueryparam cfsqltype=cf_sql_bit value=1 /cfquery cfif getPromotion.recordcount cfquery name=isRedeemed datasource=#Request.App.dsn# password=#Request.App.DBpassword# username=#Request.App.DBusername# SELECT promotion_id FROM promotions_to_customer WHERE promotion_id = cfqueryparam cfsqltype=cf_sql_integer value=#getPromotion.promotion_id# AND customer_id = cfqueryparam cfsqltype=cf_sql_integer value=#arguments.customer_id# /cfquery cfif isRedeemed.recordcount !--- alert customer that this promotion has already been used --- cfreturn -1/ cfelse cfreturn getPromotion.promotion_id/ /cfif cfelse !--- alert customer that this promotion does not exist or order sub total is invalid --- cfreturn 0/ /cfif /cffunction -- now, the client has requested that a particular coupon only be available if the customer has a selected product (or product type eg. jerseys) in their cart. i am a bit lost as to how i should be modifying the above to account for this. any help would be really appreciated. Regards Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225814 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Server 2005 and CF?
Hey,
There are two posts on:
http://weblogs.macromedia.com/mxna/index.cfm?query=byCategorycategoryId=1c
ategoryName=ColdFusion
about this exact topic. Pretty timely eh?
Mark
-Original Message-
From: Dirk De Bock - Lists [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 27, 2005 10:00 AM
To: CF-Talk
Subject: Re: SQL Server 2005 and CF?
I think the driver class name should be
com.microsoft.sqlserver.jdbc.SQLServerDriver
if you drop the jar in the cf lib dir you do not need to change the
classpath
- Original Message -
From: Charlie Griefer [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Sunday, November 27, 2005 1:36 PM
Subject: SQL Server 2005 and CF?
OS: WinXP Professional (SP2)
CF: CFMX 6.1 Professional
DB: SQL Server 2005 Express
Having issues getting a DSN set up (without resorting to ODBC via the
OS). Anybody successfully gotten this working?
I downloaded the SQL Server 2005 JDBC Driver Beta 2 from
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/jdbc.mspx.
Installed to C:\Program Files (the default install).
In the CF Administrator, under datasources, I entered the datasource
name ('comix'), and selected 'Other' for Driver.
Here are the settings that I've tried on the screen that followed:
JDBC URL: jdbc:sqlserver://localhost:1433;databaseName=comix
Driver Class: com.microsoft.sqlserver.jdbc
Driver Name: com.microsoft.sqlserver.jdbc
Error message is:
Connection verification failed for data source: comix
[]java.sql.SQLException: No suitable driver available for comix,
please check the driver setting in resources file, error:
com.microsoft.sqlserver.jdbc
The root cause was that: java.sql.SQLException: No suitable driver
available for comix, please check the driver setting in resources
file, error: com.microsoft.sqlserver.jdbc
I've found bits and pieces of information that are almost relevant,
but none that are 100%. For example:
Kola Oyedeji has a blog posting that discusses JDBC logging with
P6spy and CFMX. Not relevant to SQL Server 2005 (or any version of
SQL Server), but had some good info about JDBC drivers.
(http://64.233.187.104/default?q=cache:27tXDmhYjhkJ:coolskool.blog-city.com/
+meaning+of+bloghl=en)
MM themselves have a tech note, but it's regarding SQL Server 2000, not
2005.
(http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18652)
I also looked at the documentation that came with the driver. The
settings that I've posted above are kind of an amalgam of what I was
able to glean from the 3 sources combined.
Oh...the other variable in the equation is the classpath.
I've tried:
C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.0\enu
C:\Program Files\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar
F:\CFusionMX\lib\sqljdbc.jar
the first two were the location of the jar file by the default driver
installation (tried both with and without the filename itself). The
last was due to a suggestion that Kola had made regarding placing the
jar file in the CFusion\lib directory (I copied the file over
over...wasn't sure if that would require a classpath variable, but
figured it wouldn't hurt to try). CFMX service was cycled after each
time I modified the classpath var.
Been at this for a while, and really ready to give up and take a nap
(it's 7:30 am Sunday morning). Anybody have any info they can share?
Oh, and yes, I've made sure that SQL Server is using TCP on port 1433 :)
Thanks
--
Charlie Griefer
...All the world shall be your enemy, Prince with a Thousand Enemies,
and whenever they catch you, they will kill you. But first they must catch
you, digger, listener, runner, prince with a swift warning.
Be cunning and full of tricks and your people shall never be destroyed.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225341
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: More RAD than Ruby On Rails
Sean, For the record, PLUM is not, primarily, a code generator. It has a code generator, which is quite a time saver. But I would venture a guess that most PLUM users (this is especially true of advanced users) make very little use of the generator. It is the framework, the custom tags and built in components that make PLUM all that it is. Of course creating add, list, edit, delete and search pages or master/detail pages or lists with embedded search functions in just a few minutes is quite nice too. That of course is what the generator is for. And Plum works with all child/parent related tables just like they were individual tables, so even in the IDE, you can get quite sophisticated. Additionally, Plum creates a standard, an alteranate (both the standard and alternate also have large type style sheets) and print style sheets. All of which are, of course, customizable. You can also add other alternate styles and allow your user to pick which style they want to use. In a addition to the css, all you need to create is a thumbnail size screen shot of all the different styles you want your user to be able to choose from. It really is easy and very well done. You should grab yourself a wincrap box and try it for a few days. You will be amazed how far down the rabbit hole goes. Mark -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 23, 2005 2:03 PM To: CF-Talk Subject: Re: More RAD than Ruby On Rails On 11/23/05, Munson, Jacob [EMAIL PROTECTED] wrote: So, do you have the same concern with frameworks like FB, MG, Mach etc.? I am very ignorant of how these frameworks work, so I am curious. I am considering taking the plunge and using FB with my next big project. They aren't code generators. My concern applies primarily to code generators. -- Sean A Corfield -- http://corfield.org/ Got frameworks? If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225161 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CSS table-type layout
Tabular data should be in tables.
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Monday, November 21, 2005 8:01 PM
To: CF-Talk
Subject: RE: CSS table-type layout
You have a ton of these
style type=text/css
#MainContainer
{
width:500px;
height: 500px;
position:absolute;
}
div
{
width:250px;
height: 500px;
float:left;
}
#leftBox
{
background-color:#CC;
border:1px solid #00;
}
#rightBox
{
background-color:#66;
border:1px solid #00;
}
/style
/head
body
div id=MainContainer
div id=leftBoxThis is the left box/div
div id=rightBoxThis is the right box/div
/div
Nested inside of nested items that are nested inside of deeply nested items
of nested items... *trails off*
Or you could just use tables :)
When you get too many columns and rows within columns and rows with a pure
css layout, you're going to go postal trying to write easily
followed/manageable css and worrying about cross browser compatibility.
Every column or row you have that is not the exact same size of atleast one
other column or row in width: will need its own style set too... it gets to
be a big headache for nothing in my opinion.
Tables work across the board and there is nothing wrong with using them.
That's just my pocket change though.
God luck :)
...:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Monday, November 21, 2005 7:50 PM
To: CF-Talk
Subject: CSS table-type layout
Sostill working on my first completely css-based site and I must
say, damn, CSS is impressive, albeit a little hard to get used to. But
once you find out the tricks, etc, it's not as daunting as it seems.
Dave, you were right :)
Anyways, the site I am building is a real estate site, 3 columns, with
the center column containing the content for the site. Now, with a real
estate site, there is always the need to have a lot of info on the page,
along with a picture gallery (gonna use a popup slideshow with thumbs)
for property details. So, for such tabular-style data, how would one
approach a css version of a table with lots of rows and columns? Is
there a trick that I don't know about, or is it just better to use tables?
I want to keep the site 100% css, just to be pure and force myself to
learn it. But, if this is a stupid way to go, then I won't bother and
go with the tried-and-true approach.
--
==
Ray Champagne
Application Developer
CrystalVision Web Site Design
http://www.crystalvision.org
603.433.9559
[EMAIL PROTECTED]
==
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224916
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Reporting / Report Builder Questions
I started to play with cfr's a few weeks ago and had to pull back. I think I was looking at using queries on the calling page. All variables on the calling page are available for the cfr? My plan was to run the queries on the calling page prior to the report. Ran out of time, though I will return to cfr's sometime in the next few days. It would be great if you would post your findings. Mark -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 16, 2005 3:04 PM To: CF-Talk Subject: CF Reporting / Report Builder Questions Ok i'm just diving into Report builder and i'm trying to build a report for the first time. My question is can i have multiple queries instead of just one massive query, and if so how do i referance the values in these other queries. I've found the Report Query tool and have seen the advanced settings but i'm not sure what's going on here.. TIA jonese ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224431 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Ruby on Rails hey, read this one.
The latest update concerning supporting additional databases, (and other updates) was a call for interested parties to help with the porting. The plan is to open up further development to the community. I know you are not alone in wanting MYSQL support, but I think, being as it is a freely supplied piece of software, which took huge effort to put together, Adam and David choose what they felt were the most common databases for version 1.0 (plus I don't think Adam has much respect for MySql, maybe that will change with 5.0). www.productivityenhancement.com Mark -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Monday, November 14, 2005 9:02 AM To: CF-Talk Subject: Re: OT: Ruby on Rails hey, read this one. That's the one problem I can't get around with PLUM. As soon as they can support MySQL, I will certainly revisit the possibility of using PLUM. You know, come to think of it, I wonder if the new Oracle Express free version would work with PLUM; maybe I'll go check that out. Express is 10g and PLUM's system requirements do say 9i, so I don't know whether it'll work or not. --Ferg Barney Boisvert wrote: Yep, you're correct about only the IDE requiring windows. But PLUM itself only supports MSSQL, Access and Oracle 9i. Granted, Oracle isn't Windows-only, but it's also massively non-free. You might be able to develop on one of those, and then deploy to something else, but it'd undoubtedly be a bunch of work. cheers, barneyb On 11/13/05, Dave Watts [EMAIL PROTECTED] wrote: Sadly doesn't mind working on a windows machine rules out a lot more than just Sean. Not to belittle the work they've done in any way (from what I understand, it's pretty impressive), but using Java, Ruby, Python, etc. rather than .NET would have made for a much larger target audience. Java seems the obvious choice, since CF is itself a Java application, but any cross-platform environment would have worked just as well. The only part of PLUM that requires Windows is the IDE, if I recall correctly. The generated application runs on any CF server. The vast majority of CF developers run Windows desktops - despite the popularity of OSX among developers now, I seriously doubt that more than one out of, say, every five hundred CF developers runs something other than Windows. It's worth pointing out that the membership of this list isn't necessarily representative of CF users in general - I suspect that the percentage of non-Windows users is higher here than elsewhere. My evidence for this is purely anecdotal, but I've met a lot of CF developers, most of whom are not readers of this list. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224060 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Ruby on Rails hey, read this one.
Hey, just for the record, I sent this out yesterday at 10:30 am. Don't know why it didn't post til today (most likely on my side since everyone elses posts came through). I am sorry about the triple post, only meant to post once, but posted again when I noticed it was not comming through. Mark -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Sunday, November 13, 2005 1:00 PM To: CF-Talk Subject: Re: OT: Ruby on Rails hey, read this one. Yep, you're correct about only the IDE requiring windows. But PLUM itself only supports MSSQL, Access and Oracle 9i. Granted, Oracle isn't Windows-only, but it's also massively non-free. You might be able to develop on one of those, and then deploy to something else, but it'd undoubtedly be a bunch of work. cheers, barneyb On 11/13/05, Dave Watts [EMAIL PROTECTED] wrote: Sadly doesn't mind working on a windows machine rules out a lot more than just Sean. Not to belittle the work they've done in any way (from what I understand, it's pretty impressive), but using Java, Ruby, Python, etc. rather than .NET would have made for a much larger target audience. Java seems the obvious choice, since CF is itself a Java application, but any cross-platform environment would have worked just as well. The only part of PLUM that requires Windows is the IDE, if I recall correctly. The generated application runs on any CF server. The vast majority of CF developers run Windows desktops - despite the popularity of OSX among developers now, I seriously doubt that more than one out of, say, every five hundred CF developers runs something other than Windows. It's worth pointing out that the membership of this list isn't necessarily representative of CF users in general - I suspect that the percentage of non-Windows users is higher here than elsewhere. My evidence for this is purely anecdotal, but I've met a lot of CF developers, most of whom are not readers of this list. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224035 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
More RAD than Ruby On Rails
Good morning, Could one of the guys who has done work with RoR work through the tutorials for PLUM? It seems to me the two have similar features. It would have to be someone who doesn't mind working on a windows machine (rules out Sean, who might be the best suited). I really can't believe Ruby would be/could be quicker than PLUM. It might be more OO, but it can't be more RAD. Do the mappings, point plum at your database, spend an hour or so in the IDE and modifying the CSS files and tweaking the generated code...and a HUGE amount of work is done. You can have everything listed below, in less than 15 minutes, but to have it the way you really want it will take a few hours. But seriously, in a few hours you can have all the below, formatted the way you want it. Search, add, edit, delete, view and list pages for any table or group of parent/child tables, done. Qforms client side validation and server side validation, done. Complete security system, by module, page or page section, real simple, real easy, real powerful. Along with emailing lost passwords and the whole shebang, done. Verity search capabilities completely set up for you. With easy to add/update indexes, done. CSS files generated for standard, admin and alternative layouts with separate print and large type CSS files, done. (The Print stylesheet does better looking prints then cfdocument tag.) Plus easily generate unit testing and stored proceedures. Plus a ton of custom tags which make development of most pages a piece of cake. Plus, the flexibility to not use any of the PLUM custom tags on any page you need to do complicated coding for, Just put this line at the top of the page cfmodule template=#Request.layout#/Header.cfm pageType=pageType and the application security and CSS and qforms stuff is there for your page. I know this statement will show off my selfishness and insecurity more than I would like... but I am really torn between trying to make sure everyone gives PLUM a good look and selfishly keeping this secret to myself. So pay attention, if you really want to see RAD, spend a day exploring PLUM. David and Adam Churvis have created quite a labor of love. www.productivityenhancement.com Mark ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224019 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Ruby on Rails hey, read this one.
Good morning, Could one of the guys who has done work with RoR work through the tutorials for PLUM? It seems to me the two have similar features. It would have to be someone who doesn't mind working on a windows machine (rules out Sean, who might be the best suited). I really can't believe Ruby would be/could be quicker than PLUM. It might be more OO, but it can't be more RAD. Do the mappings, point plum at your database, spend an hour or so in the IDE and modifying the CSS files and tweaking the generated code...and a HUGE amount of work is done. You can have everything listed below, in less than 15 minutes, but to have it the way you really want it will take a few hours. But seriously, in a few hours you can have all the below, formatted the way you want it. Search, add, edit, delete, view and list pages for any table or group of parent/child tables, done. Qforms client side validation and server side validation, done. Complete security system, by module, page or page section, real simple real easy. Along with emailing lost passwords and the whole shebang, done. Verity search capabilities completely set up for you. With easy to add/update indexes, done. Plus easily generate unit testing and stored proceedures. Plus a ton of custom tags which make development of most pages a piece of cake. Plus, the flexibility to not use any of the custom tag on any page you need to do complicated coding for, Just put this line at the top of the page cfmodule template=#Request.layout#/Header.cfm pageType=pageType ( the pageType attribute determines layout and page level access) and the application security and CSS and qforms stuff is there for your page. I know this shows off my selfishness and insecurity more than I would like to admit, but I am really torn between trying to make sure everyone gives PLUM a good look and selfishly keeping this secret to myself. So pay attention, if you really want to see RAD, spend a day exploring PLUM. David and Adam Churvis have created quite a labor of love. www.productivityenhancement.com Mark ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224018 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Ruby on Rails hey, read this one.
Good morning, Could one of the guys who has done work with RoR work through the tutorials for PLUM? It seems to me the two have similar features. It would have to be someone who doesn't mind working on a windows machine (rules out Sean, who might be the best suited). I really can't believe Ruby would be/could be quicker than PLUM. It might be more OO, but it can't be more RAD. Do the mappings, point plum at your database, spend an hour or so in the IDE and modifying the CSS files and tweaking the generated code...and a HUGE amount of work is done. You can have everything listed below, in less than 15 minutes, but to have it the way you really want it will take a few hours. But seriously, in a few hours you can have all the below, formatted the way you want it. Search, add, edit, delete, view and list pages for any table or group of parent/child tables, done. Qforms client side validation and server side validation, done. Complete security system, by module, page or page section, real simple real easy. Along with emailing lost passwords and the whole shebang, done. Verity search capabilities completely set up for you. With easy to add/update indexes, done. Plus easily generate unit testing and stored proceedures. Plus a ton of custom tags which make development of most pages a piece of cake. Plus, the flexibility to not use any of the custom tag on any page you need to do complicated coding for, Just put this line at the top of the page cfmodule template=#Request.layout#/Header.cfm pageType=pageType ( the pageType attribute determines layout and page level access) and the application security and CSS and qforms stuff is there for your page. I know this shows off my selfishness and insecurity more than I would like to admit, but I am really torn between trying to make sure everyone gives PLUM a good look and selfishly keeping this secret to myself. So pay attention, if you really want to see RAD, spend a day exploring PLUM. David and Adam Churvis have created quite a labor of love. www.productivityenhancement.com Mark -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Friday, November 11, 2005 1:00 AM To: CF-Talk Subject: Re: OT: Ruby on Rails That's the thing, RoR made it so easy to be able to store the image in a database, but still have the speed of a cached copy on the file server. In essence, the first time /image/show/1.jpg is called, RoR will notice there is no file called 1.jpg and will automatically create the 1.jpg file on the filesystem. So from them on, I get the benefit of a quick file serve with the portability to different servers. I'm sure you could do the same with CF, but with RoR it's built in. That's where the main difference is for me between the 2. RoR has a ton of stuff built in that most developers do everyday. It may not be the most efficient, but it can get a lot of stuff done quick. On 11/10/05, Barney Boisvert [EMAIL PROTECTED] wrote: Why can't you do thumbnailing like that with CF? I've done almost exactly that, they only difference is that I store the thumbnail on the filesystem (though it's still served through CF), rather than the DB. cheers, barneyb -- Marlon I am the eagle, I live in high country, In rocky cathedrals that reach to the sky ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224020 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Open source shopping cart
Hey guys, I would love to help, but I don't think my coding skills are up to the task. I could help with documentation and planning though. I would suggest you start by finding a PHP open source shopping cart that has the structure and features you want. That way at least everyone knows what the target is going to be. Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223771 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
dreamweaver upgrade and custom tag completion
Good evening, I know dreamweaver is not real popular with this list, but maybe someone can help me figure this out. I have some custom tags (PLUM) for which another developer created the xml files for tag completion for dreamweaver. I have been using them for quite some time in dreamweaver MX 2004. Just upgraded and they don't work anymore. I guess I have to move them to another folder. This presents me with two problems: Where to put them in dreamweaver8 and I can't remember where I put them for 2004. Any ideas? Thanks, Mark ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223534 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf tutorials
Thanks. I'll be looking foward to the video! We are in Maryland, so that won't work. Thanks, Mark -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 2:26 AM To: CF-Talk Subject: Re: cf tutorials If your in NY I'll be giving 6 intro classes free of charge for people in Brooklyn to get them interested. In addition, I'll be speaking at the next NYCFUG on two topics, one of which is a basic one: comparison statements in ColdFusion 3 approaches to query caching You're welcome to come to both and I'm hoping to get video of them up on the Dinowitz and Associates site (http://www.dinowitzandassociates.com) Hey all, I want my son to learn CF. Is there a series of good tutorials that teach CF in an organized, concise way? I would love him to take some classes, but the money is way tight right now. Thanks, Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222893 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf tutorials
FYI- If anyone would be interested, I found what seems to be a very complete and well organized ColdFusion tutorial at Lynda.com. It is a 15+ hour course taught on quicktime video by a guy named Joey Lott. I think the price of $25/month is quite reasonable. Mark -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 8:08 AM To: CF-Talk Subject: RE: cf tutorials Thanks. I'll be looking foward to the video! We are in Maryland, so that won't work. Thanks, Mark -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 02, 2005 2:26 AM To: CF-Talk Subject: Re: cf tutorials If your in NY I'll be giving 6 intro classes free of charge for people in Brooklyn to get them interested. In addition, I'll be speaking at the next NYCFUG on two topics, one of which is a basic one: comparison statements in ColdFusion 3 approaches to query caching You're welcome to come to both and I'm hoping to get video of them up on the Dinowitz and Associates site (http://www.dinowitzandassociates.com) Hey all, I want my son to learn CF. Is there a series of good tutorials that teach CF in an organized, concise way? I would love him to take some classes, but the money is way tight right now. Thanks, Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222943 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Any Interest in a Completely Free CFML Calendar?
Sean, As you say choice is good. However, the two apps are vastly different. In a brief look at Vivio's, it seems more like outlook exchange, very robust and not based on fusebox. I am not sure these two calendars compete/compare at all. Mark -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Saturday, October 22, 2005 2:56 PM To: CF-Talk Subject: Re: Any Interest in a Completely Free CFML Calendar? On 10/14/05, Jordan Michaels [EMAIL PROTECTED] wrote: For some time now, Vivio Technologies has been debating whether or not to put forth the effort to complete the development of a completely free, (under a modified open-source MIT license) CFML calendar application. cfopen.org has a very basic free open source calendar app: http://cfopen.org/projects/coldcalendar/ (of course, more choice is always good) -- Sean A Corfield -- http://corfield.org/ Got frameworks? If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221944 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Any Interest in a Completely Free CFML Calendar?
Hey Sean, No offense intended, just thought the Vivio calendar offer was a gracious one and was impressed with it's verboseness [is that a word?]. My comment about fusebox is colored by my ignorance of fusebox and frameworks in general and I was only thinking it would make it hard to incorporate/modify for a non-fusebox app. It was not meant as a cut on fusebox at all. Mark -Original Message- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Saturday, October 22, 2005 6:05 PM To: CF-Talk Subject: Re: Any Interest in a Completely Free CFML Calendar? On 10/22/05, Mark Fuqua [EMAIL PROTECTED] wrote: As you say choice is good. However, the two apps are vastly different. In a brief look at Vivio's, it seems more like outlook exchange, very robust and not based on fusebox. I am not sure these two calendars compete/compare at all. I was merely pointing out an existing open source effort - which I noted was very basic. If CFers contributed more to existing open source projects, perhaps they would become more robust and full-featured? (and I don't see what Fusebox has to do with this other than one of the calendars just happens to be written using it). -- Sean A Corfield -- http://corfield.org/ Got frameworks? If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221953 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Dreamweaver, Homesite+ 5.5, Eclipse?
Andy, do you read posts from this list often? Dreamweaver is not well regarded on this list. It is like going to an Apple convention, standing up and asking which version of windows you should use. Seriously, if you are going to use dreamweaver for coding only, there really isn't that much of a learning curve. When you first start it, choose code style and you'll be good to go. The only thing that might take a few minutes is setting up a site. But that really is quite easy and once that is done, you'll be up and running. You can learn the many time savers Dreamweaver allows (code snippets, dragging table/column names from database tab to your coding pane, putting tag editors/tag completion for your own custom tags, and some cool stuff in 8 I haven't tried yet...still using 2004) a little at a time. Tag completion for CF is very good in Dreamweaver. I have been wanting to try CFEclipse for some time now, but I just do not want to take the time to learn it. You have dreamweaver, it is not hard to install and it is easy to learn. Give it a try. Mark -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 19, 2005 9:14 AM To: CF-Talk Subject: Dreamweaver, Homesite+ 5.5, Eclipse? So every few months I go on a crusade to find a text editor better than the one I currently use, Editplus. I've installed lots of them, but can't really spend the time to get up to speed on any of them where I feel like I'm being efficient. Let's be honest, the real reason I'm looking for a new editor is to increase productivity. So, I'd love to hear from some of you what text editors you use, and more specifically, how you have it configured. My company just purchased Studio 8 for all of us and I'm seriously considering giving Dreamweaver 8 a try (code use only), but I just don't know if I can afford the time it would take for me to get used to it. Anyone? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221472 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Dreamweaver, Homesite+ 5.5, Eclipse?
One more thought, then its back to work- FLEX 2.0The possibilities of flex builder and the CF to Flex bridge really excite me in a back-of-the-mind-gitty sort of way. I don't have time to investigate now...but I sure intend to. As I am sure everyone knows already, flexbuilder is an extension/built on top of (don't know which is correct) Eclipse. So, if you plan on working with Flex Builder, might want to make the move to Eclipse even though I think the learning curve will be much steeper. Mark -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 19, 2005 9:14 AM To: CF-Talk Subject: Dreamweaver, Homesite+ 5.5, Eclipse? So every few months I go on a crusade to find a text editor better than the one I currently use, Editplus. I've installed lots of them, but can't really spend the time to get up to speed on any of them where I feel like I'm being efficient. Let's be honest, the real reason I'm looking for a new editor is to increase productivity. So, I'd love to hear from some of you what text editors you use, and more specifically, how you have it configured. My company just purchased Studio 8 for all of us and I'm seriously considering giving Dreamweaver 8 a try (code use only), but I just don't know if I can afford the time it would take for me to get used to it. Anyone? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221481 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT Joins
Can anyone explain to me what type of join is created when the join is done with the WHERE clause as opposed to the FROM clause in a sql statement. What are the advantages the joins in the FROM clause. I know it is because I am still very green but I find WHERE clause joins much easier to write. Thanks, Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221583 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT Joins
Thanks all, for your responses, I was doing family time. Mark -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 19, 2005 8:03 PM To: CF-Talk Subject: OT Joins Can anyone explain to me what type of join is created when the join is done with the WHERE clause as opposed to the FROM clause in a sql statement. What are the advantages the joins in the FROM clause. I know it is because I am still very green but I find WHERE clause joins much easier to write. Thanks, Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221600 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFMX Licenses
I am sure this is an idiot question, but if the shoe fits... What about two servers with one cpu each? Mark -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 18, 2005 11:38 AM To: CF-Talk Subject: RE: CFMX Licenses I would have thought it was obviously, but I'll state it anyway. A single cpu license is for a server with 1 x cpu A 2cpu license is for a server with 2 x cpu CFMX7 covers 2cpu regardless. -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: 18 October 2005 16:05 To: CF-Talk Subject: CFMX Licenses I am searching around to purchase a license, and noticed: MacroMedia ColdFusion MX Standard 7.0 2CPU Does anyone know what the difference is in between a single CPU and 2CPU license, other than the price? TNX. Rick Colman ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221347 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SOT: Thoughts on Requiring Javascript
I like seeing .gov sites written in CF. The reason I think most .gov sites are written in CF is because those contracts are low bid and CF has an advantage there. If you meet the requirements and have the lowest price, you get the job. Mark -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Monday, October 17, 2005 10:27 AM To: CF-Talk Subject: RE: SOT: Thoughts on Requiring Javascript She didnt write it, she simply pointed it out and it's true. http://www.section508.gov/index.cfm?FuseAction=ContentID=12 I love it when .gov sites are written in CF... it makes me feel all giddy. ...:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, October 17, 2005 9:45 AM To: CF-Talk Subject: RE: SOT: Thoughts on Requiring Javascript Sandy... How is having javascript on your website causing a site to be un-accessible? That makes no sense. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED] Sent: Monday, October 17, 2005 6:33 AM To: CF-Talk Subject: RE: SOT: Thoughts on Requiring Javascript I can tell you that section 508 and the WCAG both have a requirement that a page be able to work without javascript in order to be considered accessible. If you are required to build accessible web pages, then that is a major consideration. However, IBM demonstrated an accessible javascript which the new Firefox beta is supporting. Once that is widely available, I believe that the javascript disabled rule for accessibility will be deprecated. Sandra Clark -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED] Sent: Monday, October 17, 2005 12:00 AM To: CF-Talk Subject: Re: SOT: Thoughts on Requiring Javascript I've never supported non-JS. Cross browser JS, yes, but building a non-JS version...? Then what? A version that works in Netscape 2? Maybe a Lynx only version? There comes a point when you can't cater to the lowest common denominator. IMO, JS is pretty darn common place. Those afraid of JS and cookies should probably stick to sneaker net and snail mail :) On 10/15/05, Dawson, Michael [EMAIL PROTECTED] wrote: I'm interested in what you think of requiring JS for a web site. What is the current mentality on JS? I know that to use Gmail, Google Maps and, in our case, Blackboard Learning System, you must enable JS. I would love to get more into AJAX to make my pages easier to build and use, but I'm afraid I may alienate some people. I will say, that as an educational institution, we have some people that will disable JS, but it should be a minimal amount. Let's say that I do require an extensive amount of JS on my site (it will be an intranet), then how far do I go to support non-JS users? Let's also say I create a form that lets me look up a user based on their ID number, name or email address. AJAX will make this task very easy. However, if a person disables JS, should I bother to create a non-JS version of the page? I'm just curious in how far you go to require JS and, if you do, do you give an alternative other than Sorry, this page requires javascript? Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221206 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: embarrasing trouble starting coldfusion
Yes it should and it was. It turns out it was Norton Internet Services. Disable it and I could connect. Wasted a whole weekend figuring that out. Don't I feel stupid. Thanks for the suggestions though. Mark -Original Message- From: Tony [mailto:[EMAIL PROTECTED] Sent: Monday, October 17, 2005 12:36 AM To: CF-Talk Subject: Re: embarrasing trouble starting coldfusion isnt it a service and should start anyway? that is, if its set up for automatic startup. tw On 10/15/05, Mark Fuqua [EMAIL PROTECTED] wrote: Is there a way to force coldfusion to start on my laptop? I used to be able to start coldfusion simply by browsing to a page on my local root. That started to be problematic and then for a while starting coldfusion administrator from the start menu worked. Now, it takes me many many tries to get coldfusion started. It is driving me crazy, though many would say it is a rather short trip. Is there a way to start coldfusion from the run command or something. And how do I tell whether or not it is running. May be I am getting the Page cannot be displayed error while coldfusion is actually running? Thanks, Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221179 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Pluggable Security system/ app architecture (WAS: Re: Any Interest in a Completely Free CFML Calendar?)
M!ke, Is Plum a framework? Well, it is, and it isn't. I am going to pass this thread on to Adam and David to make sure I am not being blasphemous, but at it's simplest, without using any of the Plum custom tags or the IDE (which would be quite silly actually, as for chunks of most projects the IDE and custom tags are quite the time savers) plum is essentially a site wide security model and an easy, consistent way to incorporate your CSS model. After you set-up your plum project, a process that takes about 15 min. and spend some time making the style sheets like you want them (Plum auto-generates a basestyleSheet.css, a large_TypeStyleSheet.css, a printStyleSheet.css, with both standard and alternate layouts as well as bottomNavBar.cfm, footer.cfm, Header.cfm, LeftNavBar.cfm and TopNavBar.cfm) The following two calls setup all your layout and Navigation (If you are curious, the default layouts are very similar to Adam and David's site www.productivityenhancement.com ): cfmodule template=#Request.layout#/Header.cfm pageType=pageType page code goes here cfmodule template=#Request.layout#/Footer.cfm In between those two calls, you can stay within the framework, meaning you use the plum custom tags, or you can put any other code you wish. Once one becomes familiar with the Plum tags, it will surely be a mix, some will be heavy on Plum, some will be light on Plum tags. As far as security goes, it can be done on the module, page, page section or just a line of code with the following call: cf_Authorize roles = ROLE1,ROLE2,ROLEn userMustBeAMemberOf = AnyOfTheseRoles | AllOfTheseRoles So as you can see, Plum really is not a framework as most would define it...it is more like a methodology with a core set of files, functions, tags and an IDE thrown in for fun. Mark -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Saturday, October 15, 2005 9:28 AM To: CF-Talk Subject: RE: Pluggable Security system/ app architecture (WAS: Re: Any Interest in a Completely Free CFML Calendar?) Correct me if I'm wrong, but is Plum a framework and, if so, will the security model be usable without a framework? M!ke -Original Message- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Friday, October 14, 2005 9:18 PM To: CF-Talk Subject: RE: Pluggable Security system/ app architecture (WAS: Re: Any Interest in a Completely Free CFML Calendar?) Check out Plum. www.productivityenhancement.com The next planned release is geared in this direction. Mark ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221116 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
embarrasing trouble starting coldfusion
Is there a way to force coldfusion to start on my laptop? I used to be able to start coldfusion simply by browsing to a page on my local root. That started to be problematic and then for a while starting coldfusion administrator from the start menu worked. Now, it takes me many many tries to get coldfusion started. It is driving me crazy, though many would say it is a rather short trip. Is there a way to start coldfusion from the run command or something. And how do I tell whether or not it is running. May be I am getting the Page cannot be displayed error while coldfusion is actually running? Thanks, Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221120 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Any Interest in a Completely Free CFML Calendar?
I think free with link and reasonable license fee ($75-150/site??) without a link would help pay for development, improvements and future releases. Kudos to the open source crowd...but most of the people who champion the concept the loudest (speaking only of those who advocate but do not contribute time) surely charge for their projects. You will be better able to complete and improve this project if you charge a reasonable price for use of the calendar. Mark ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221097 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Pluggable Security system/ app architecture (WAS: Re: Any Interest in a Completely Free CFML Calendar?)
Check out Plum. www.productivityenhancement.com The next planned release is geared in this direction. Mark ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221100 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: javax.mail.SendFailedException: 550 5.7.1
I don't know if this will help you, but it sure seems timely (posted early this morning) http://www.danvega.org/blog/client/index.cfm/2005/10/12/Sending-mail-with-CF Mail-A-problem--A-solution Mark Fuqua ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220891 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Pakistan Earthquake . Help Plz
I am sure that helped alot. Most compassionate of you. What a dweeb response. Mark -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, October 10, 2005 9:34 AM To: CF-Talk Subject: Re: OT: Pakistan Earthquake . Help Plz On Monday 10 October 2005 04:16, Qasim Rasheed wrote: are also affected. It is estimated that over 30,000 are feared dead and more than 40 thousand injured. There is a massive disruption in Did you know that 20K people die every two days of preventable communicable disease in Africa ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220549 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Multiple inserts and cftranaction tag
I have several pages where many inserts/updates are being performed within a loop: 50-200. I would like them to all go through or have them roll back. I am still quite green and as such, I have a few questions for y'all: 1. Is there a limit to how many queries can be within cftransaction tags? 2. If all the inserts/updates are to one table, will the table be locked or the whole database? 3. Does the transaction tag slow the process down? 4. Does MS Access support the concept of transactions or do I have to wait until I switch the database over to MS sql. 5. Does the transaction process notify of success or failure? Thanks, Mark ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220618 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Why doesn't this query return more than 1 record?
Depending on your join, missing data can cause a row you expect to see not be part of the query result set. Mark -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, October 03, 2005 1:45 PM To: CF-Talk Subject: RE: Why doesn't this query return more than 1 record? No...I'm looping the query on the website... I think I've gone insane...this should be so simple. Rick -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Monday, October 03, 2005 1:23 PM To: CF-Talk Subject: RE: Why doesn't this query return more than 1 record? Thought you might be doing something like: cfoutput #qYourQuery.SomeRow# /cfoutput and only seeing one row, namely the first one. Have you solved it? Ade -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 03 October 2005 18:10 To: CF-Talk Subject: RE: Why doesn't this query return more than 1 record? Oh, I'm so mad! ;o) I'm returning the results to the website and I've also run the query on Navicat... Rick -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Monday, October 03, 2005 12:45 PM To: CF-Talk Subject: RE: Why doesn't this query return more than 1 record? Now don't get mad when I suggest this, but how do you know it's only returning 1 row? Ade -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 03 October 2005 17:34 To: CF-Talk Subject: RE: Why doesn't this query return more than 1 record? It should return 4 records, which are the only ones in the database / table that match...it's a database that I'm developing as I develop the site... I've been over the data at the db, and over the code multiple times and must just be missing something... It's returning only the first record each time...and that's the record that matches the URL.Client_ID...but this code should return more than one record, right? Rick -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Monday, October 03, 2005 11:58 AM To: CF-Talk Subject: RE: Why doesn't this query return more than 1 record? Well how many rows do you expect back? It has to be down to your WHERE clause. Have a look in the tables and see whether more rows fit the criteria you're using. Ade -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 03 October 2005 16:47 To: CF-Talk Subject: Why doesn't this query return more than 1 record? I'm not dumb, I'm not dumb, I'm not dumb. If I repeat it often enough, it has to be true, right? Anyway...why won't this query return more than 1 record? Select FG.Group_ID, FG.Group_Name, C.Client_ID, C.Client_First_Name, C.Client_Middle_Name, C.Client_Last_Name from Family_Groups FG, Clients C where FG.Group_ID = C.Client_Family_ID and C.Client_ID = '#URL.Client_ID#' Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219942 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Why doesn't this query return more than 1 record?
Depending on your join type, missing data can cause a row you expect to see not be part of the query result set. Mark ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219945 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
