Framework
Well I've finally read thru Sean Corfield's framework comparison post, presentation and have decided to dive into the CF framework world with Model-Glue. My background includes some VB.NET windows application development I'd like to hear from anyone willing to post. Whether you're using Model-Glue or not, and what you like about the framework you are using - as well as what you don't like. I know this has been beaten to death but we all know that once we decide to learn something new we have to ask for ourselves. TIA, Donna ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFIF inside a Form
I'm trying to use the following code inside a FORM tag that uses POST: cfif getDollDetails.price gt 0 input type=hidden name=price value=#Trim(getDollDetails.price)# cfelse input type=hidden name=price value=#Trim(getDollDetails.srp)# /cfif Is there a trick to doing this because I've written similar code without problems. The error says: An error occurred while evaluating the expression: price GT 0 I'm scoping the price variable and quad checked the name of the query. What am I missing here??? Maybe I'm just vapored locked since it's 4pm??? TIA, Donna ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249514 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFIF inside a Form
Not likely it's null but I went ahead tried it using VAL still get the same error. Any other suggestions? This site is using CF5 if that helps - database is SQL 2000 Thanks, Donna Is it possible there's a null value in that column? That would result in an empty string for CF and gt would be an invalid operator. cfif val(getDollDetails.price) gt 0 might be better. -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 5:02 PM To: CF-Talk Subject: CFIF inside a Form I'm trying to use the following code inside a FORM tag that uses POST: cfif getDollDetails.price gt 0 input type=hidden name=price value=#Trim(getDollDetails.price)# cfelse input type=hidden name=price value=#Trim(getDollDetails.srp)# /cfif Is there a trick to doing this because I've written similar code without problems. The error says: An error occurred while evaluating the expression: price GT 0 I'm scoping the price variable and quad checked the name of the query. What am I missing here??? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249518 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFIF inside a Form
It's not quite 'time' for me to go home - but it's TIME for me to go... You know one of the great things about CF is it tells you exactly which line to look atDUH wrong damn line thanks for the help - it's fixed now and I am going home!!! LOL ~ Donna Other then it's probably nicer to write it like this: input type=hidden name=price value=#trim(iif(getDollDetails.price,getDollDetails.price,getDollDetails.sr p))# I don't see anything wrong with it. Where does getDollDetails get created? You said it's a query? CF debugger sucks sometimes and will give you weird errors when the real error is actually somewhere around it. Check the lines before it and see if there's some typo there or maybe a missed quote somewhere. Russ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249519 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Breadcrumb Trail
Okay, so I've been reading several books on usability and finally decided to break down and add a breadcrumb trail to my site. For my top level I'll need to link to one of 10 pages depending on the category so the only option I see here is either multiple CFIF's or CFCASE to grab the correct page according to categoryID. But I wanted to run it past you all before I write the code to see if I'm missing an obvious easier solution. For those of you wondering why I have 10 different pages for the top level categories it's for SEO reasons and has proven very beneficial. TIA, Donna ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232602 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-Talk: Digest every hour
LMFAOL - spewed Coke here ~| 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:226093 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: AS400, RPG Positions?
I'm trying to help a friend of mine that had been the Manager of Applications for 16 years at a local hospital until a couple weeks ago. They cut about 30 jobs and his was one of them. If you know of anything in the Texarkana (on the Ark/Tx border) area it would be appreciated. Thank you and sorry for the OT post! -- Donna French [EMAIL PROTECTED] http://dgfrench.blogspot.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:226128 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
Blogger Feed to homepage on CF5 ?
Is there a way to feed my latest blogger.com post to my homepage on a site running CF5? Thanks for any help on this. ~ Donna -- Donna French [EMAIL PROTECTED] http://dgfrench.blogspot.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:225449 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
CF5 / SQL 2000 Export to Excel
I have exported the data that I need using the SQL export tool but what I am trying to accomplish is an Excel file for Froogle I need one field as a URL. Is there a way to have SQL or CF version 5 - or combination of both - export my productid field as a URL instead of just the productid alone? Any help or suggestions would be appreciated. TIA, -- Donna French [EMAIL PROTECTED] http://dgfrench.blogspot.com ~| 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:225267 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: CF5 / SQL 2000 Export to Excel
Yes, the productid should be part of a standard URL. I'm using SQL 2000 and getting an error message saying it can't convert the var of the URL to an int. Any pointers? Thank you! ~ Donna Do you mean the productid should be part of a standard URL? If so: SELECT 'http://www.domain.com/page.cfm?id=' + id AS myURL FROM TableName Depending on your database, you may need a different operator, other than the plus (+) sign. Some DBs use pipes (|), some use functions (Concat()). M!ke -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Friday, November 25, 2005 2:22 PM To: CF-Talk Subject: CF5 / SQL 2000 Export to Excel I have exported the data that I need using the SQL export tool but what I am trying to accomplish is an Excel file for Froogle I need one field as a URL. Is there a way to have SQL or CF version 5 - or combination of both - export my productid field as a URL instead of just the productid alone? Any help or suggestions would be appreciated. TIA, -- Donna French [EMAIL PROTECTED] http://dgfrench.blogspot.com ~| 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:225269 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
Time management
I'm the whole IT dept. at the company I work for - development, networking, support, search engine optimization, etc. - and wonder what others out there in the same position use to manage their time? I've taken a couple weeks off and have been getting things here at home organized which has made me realize how UNorganized things at the office are. There are upgrades to the existing site that I want to implement but get caught up in the day-to-day grind of getting things done that are a must. Any suggestions welcome - even if it's a good ole pencil and paper! LOL TIA, Donna -- Donna French [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:220711 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
Pull content from CGI with CF?
How can I pull some content into a CF page that is generated by a CGI? The site I need to do this for is using CF5. TIA, Donna ~| 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:212168 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: Working Code
cfquery name=getDolls datasource=dsn select * from subcategories /cfquery cfif isDefined(form.btn) cfdump var=#form# /cfif cfform action=#cgi.script_name# format=flash cfgrid name=dollGrid query=getDolls rowheaders=false cfgridcolumn name=subcategory cfgridcolumn name=subcategoryid cfgridcolumn name=description cfgridcolumn name=categoryid /cfgrid cfinput type=text name=subcategory label=Subcategory bind={dollGrid.selectedItem.subcategory} cfinput type=text name=subcategoryid label=Subcategory ID bind={dollGrid.selectedItem.subcategoryID} cfinput type=text name=description label=Description bind={dollGrid.selectedItem.description} cfinput type=text name=categoryid label=Category ID bind={dollGrid.selectedItem.categoryID} cfinput type=submit name=btn value=submit /cfform ~| 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:210925 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: working code
I got it working with this code: cfquery name=getDolls datasource=dsn select * from subcategories /cfquery cfif isDefined(form.btn) cfdump var=#form# /cfif cfform action=#cgi.script_name# format=flash cfgrid name=dollGrid query=getDolls rowheaders=false cfgridcolumn name=subcategory cfgridcolumn name=subcategoryid cfgridcolumn name=description cfgridcolumn name=categoryid /cfgrid cfinput type=text name=subcategory label=Subcategory bind={dollGrid.selectedItem.subcategory} cfinput type=text name=subcategoryid label=Subcategory ID bind={dollGrid.selectedItem.subcategoryID} cfinput type=text name=description label=Description bind={dollGrid.selectedItem.description} cfinput type=text name=categoryid label=Category ID bind={dollGrid.selectedItem.categoryID} cfinput type=submit name=btn value=submit /cfform well I know that this works... cfform format=flash width=500 cfformgroup type=panel label=My Grid cfgrid name=myGrid query=stuff selectmode=row colheaders=no cfgridcolumn name=faqType header=FAQ Type cfgridcolumn name=faqQuestion header=Question cfgridcolumn name=faqAnswer header=Answer cfgridcolumn name=faqCatagory header=Category cfgridcolumn name=faqGroup header=Group /cfgrid /cfformgroup cfformgroup type=panel label=Edit me here cfinput type=text name=faqType label=FAQ Type bind={myGrid. selectedItem.faqType} / cfinput type=text name=faqQuestion label=Question bind={myGrid.selectedItem.faqQuestion} / cfinput type=text name=faqAnswer label=Answer bind={myGrid. selectedItem.faqAnswer} cfinput type=text name=faqCatagory label=Category bind={myGrid.selectedItem.faqCatagory} / cfinput type=text name=faqGroup label=Group bind={myGrid. selectedItem.faqGroup} / /cfformgroup cfinput type=submit name=edit value=Edit Me / /cfform I just post and catch changes there based on the form var that track the grid row changes. Hope this helps. :) Gryphn ~| 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:210926 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: Flash Grid
Still no help with this and I'm wondering if there's some Javascript or something that doesn't show in the example? Anyone have some experience with this and able to help? Thanks, Donna ~| 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:210775 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
Flash Grid
I've just started experimenting with CF7 forms and have used one of the sample flash grids to play around with. The grid loads, but the form below it does not load the data when selected as it does in the sample data. Here's the code, any help would be appreciated. TIA, Donna cfquery name=getDolls datasource=mydsn select * from dolls where subcategoryID = 8; /cfquery cfif isDefined(form.btn) cfdump var=#form# /cfif cfform format=flash cfgrid name=dollGrid query=getDolls rowheaders=false cfgridcolumn name=lanesID header=Lanes ID cfgridcolumn name=name header=Name cfgridcolumn name=price header=Price /cfgrid cfinput type=text name=lanesID label=LanesID bind={dollGrid.dataProvider[dollGrid.selectedIndex]['LANESID']} onChange=dollGrid.dataProvider.editField(dollGrid.selectedIndex, 'LANESID', lanesID.text); cfinput type=text name=name label=Name bind={dollGrid.dataProvider[dollGrid.selectedIndex]['NAME']} onChange=dollGrid.dataProvider.editField(dollGrid.selectedIndex, 'NAME', name.text); cfinput type=text name=price label=Price bind={dollGrid.dataProvider[dollGrid.selectedIndex]['PRICE']} onChange=dollGrid.dataProvider.editField(dollGrid.selectedIndex, 'PRICE', price.text); cfinput type=submit name=btn value=submit /cfform ~| 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:210681 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: Certification, Online Learning
I'd like to dig in and take the CFMX7 Certification test toward the end of the summer. I've been using CF since 4.5 and would like to find an online class that's self-paced to help polish my skills and learn the details of the new version features. I've considered eClasses.org and Macromedia University. Any feedback on those two? Or can someone suggest another online learning resource? (Other than the obvious Macromedia documentation and such.) Thanks in advance, Donna French ~| 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:207350 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: OSI Hosting Company?
Just wondering if anyone uses OSI Hosting? Their web site claims they are building a facility here in Texarkana where I live and I'm trying to verify they are legit somehow. Any feedback greatly appreciated. TIA, Donna -- Donna French [EMAIL PROTECTED] http://dgfrench.blogspot.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:199812 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
What to do - stagnant job
I work for a small company and have for about three years now, and I'm either going to have to create something new or find a blunt object to mutilate myself with. They are happy with the web app and what it does as is, so I'm not getting any demands or direction in the way of writing or even editing any code. Although I enjoy small doses of the webmaster side of things, I do not want it to be my full-time job - and at this rate it is going to be. Just wondering (hoping) some of you out there have been in a similar situation at one time or another, and what you did to get out of the rut? TIA!!! -- Donna French [EMAIL PROTECTED] http://dgfrench.blogspot.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:198873 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: sending form data
I have a form that I'd like to send the data from using whatever email account is setup on the user's computer (Outlook or Outlook Express). I've seen this done before but can't remember where and not sure how to go about it. Any help would be greatly appreciated. Thanks, Donna -- Donna French [EMAIL PROTECTED] http://dgfrench.blogspot.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:197206 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: in need of education
I'd be interested to hear what others have to say about www.eclasses.org ? Considering taking the Cold Fusion course(s) but would like to hear from others so thought this would be appropriate here. TIA, Donna On Tue, 01 Feb 2005 18:18:48 +0100, RADEMAKERS Tanguy [EMAIL PROTECTED] wrote: Tim, The O'Reilly book Programming ColdFusion MX is well worth the money - good end to end tutorial with plenty of examples, coupled with a tag and function reference. I've bought both the old CF5 version and the CFMX version because it is the fastest way i know to bring new hires up to speed in CF w/out having to hold their hands. /t -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 5:51 PM To: CF-Talk Subject: in need of education I am rapidly coming to the conclusion that I need some educatin' with respect to structures, arrays, evaluation function, list creation/manipulation .all that sort of stuff I've been doing a lot of learn as you go/googling for solutions etc, but that type of training is costing too much time now.would like to get some structured training on these topics Any suggestions that don't totally empty my wallet would be greatly appreciated... books/classroom/good online training etc. Tim ~| 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:192612 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
OT: eClasses.org ?
Wondering if anyone can give me some feedback on www.eClasses.org? Email off list if you'd like. Thanks, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.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:192652 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: eClasses.org ?
I haven't looked at their interface. Guess I need to check it out. Was looking at taking the CF classes. Anyone else have 2 cents to throw in here? TIA, Donna On Tue, 1 Feb 2005 16:59:41 -0500, Michael T. Tangorre [EMAIL PROTECTED] wrote: From: Donna French [mailto:[EMAIL PROTECTED] Wondering if anyone can give me some feedback on www.eClasses.org? Email off list if you'd like. Checked them out about 2 weeks ago. IMO their interfaces are terrible; generic and cluttered. If I am going to pay for courses on design and such... The people presenting it have better taken the time to ensure theirs is worth looking at! ~| 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:192672 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
CFSELECT Prob
What is wrong with this??? Trying to get an update to work: tdEducation:/td tdselect name=Client_Education Value=#qClient.Client_Education# tabindex=230 option value=Less than 12 yearscfif Client_Education is Less than 12 yearsSELECTED/cfifLess than 12 years/option option value=High School or GEDcfif Client_Education is High School or GEDSELECTED/cfifHigh School or GED/option option value=Some Collegecfif Client_Education is Some CollegeSELECTED/cfifSome College/option option value=College Graduatecfif Client_Education is College GraduateSELECTED/cfifCollege Graduate/option option value=Vocational Trainingcfif Client_Education is Vocational TrainingSELECTED/cfifVocational Training/option option value=Unknowncfif Client_Education is UnknownSELECTED/cfifUnknown/option /select/td Error: An error occurred while evaluating the expression: Client_Education is Less than 12 years Error near line 81, column 67. -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Logware: 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:191394 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: CFSELECT Prob
How can I avoid this so that it just evaluates as a string? Or is there a more efficient way to handle this SELECT? TIA, Donna On Fri, 21 Jan 2005 12:46:35 -0800, Ian Skinner [EMAIL PROTECTED] wrote: Umm, not sure but it looks like CF is trying to evaluate your string as an expression. You can write expressions such as this [foobar LT 99] in long hand as [foobar less then 99]. Almost nobody does, but it is supported by CF. So my first guess would be that your Less Then 12 years string is being treated as an expression. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning ...-Original Message- ...From: Donna French [mailto:[EMAIL PROTECTED] ...Sent: Friday, January 21, 2005 12:41 PM ...To: CF-Talk ...Subject: CFSELECT Prob ... ...What is wrong with this??? ... ...Trying to get an update to work: ... ... tdEducation:/td ... tdselect name=Client_Education ...Value=#qClient.Client_Education# tabindex=230 ... option value=Less than 12 yearscfif Client_Education is ...Less than 12 yearsSELECTED/cfifLess than 12 years/option ... option value=High School or GEDcfif Client_Education is ...High School or GEDSELECTED/cfifHigh School or GED/option ... option value=Some Collegecfif Client_Education is Some ...CollegeSELECTED/cfifSome College/option ... option value=College Graduatecfif Client_Education is ...College GraduateSELECTED/cfifCollege Graduate/option ... option value=Vocational Trainingcfif Client_Education is ...Vocational TrainingSELECTED/cfifVocational Training/option ... option value=Unknowncfif Client_Education is ...UnknownSELECTED/cfifUnknown/option .../select/td ... ...Error: ... ...An error occurred while evaluating the expression: ... ... ... Client_Education is Less than 12 years ... ... ... ...Error near line 81, column 67. ... ...-- ... ...Donna French [EMAIL PROTECTED] ... ...Blog: http://dgfrench.blogspot.com ...Site: http://www.dgfrenchdesigns.com ... ... ~| Logware: 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:191399 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: CFSELECT Prob
Okay, thanks - got it working now: select name=Client_Education Value=#Client_Education# tabindex=230 My eyes are fried - been working 6 hours straight in the afternoon instead of off/on all day. What do you all use to help cut down on eye strain? ;-) Donna On Fri, 21 Jan 2005 13:26:29 -0800, Ian Skinner [EMAIL PROTECTED] wrote: Ok, I just tested your code and it worked just fine on my system. I would then take a look at the value of your variables, Client_Education and qClient.Education. PS. What is the value parameter in your select statement doing? Select tags don't use a value parameter, just the Option child-tags. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning ...-Original Message- ...From: Donna French [mailto:[EMAIL PROTECTED] ...Sent: Friday, January 21, 2005 12:41 PM ...To: CF-Talk ...Subject: CFSELECT Prob ... ...What is wrong with this??? ... ...Trying to get an update to work: ... ... tdEducation:/td ... tdselect name=Client_Education ...Value=#qClient.Client_Education# tabindex=230 ... option value=Less than 12 yearscfif Client_Education is ...Less than 12 yearsSELECTED/cfifLess than 12 years/option ... option value=High School or GEDcfif Client_Education is ...High School or GEDSELECTED/cfifHigh School or GED/option ... option value=Some Collegecfif Client_Education is Some ...CollegeSELECTED/cfifSome College/option ... option value=College Graduatecfif Client_Education is ...College GraduateSELECTED/cfifCollege Graduate/option ... option value=Vocational Trainingcfif Client_Education is ...Vocational TrainingSELECTED/cfifVocational Training/option ... option value=Unknowncfif Client_Education is ...UnknownSELECTED/cfifUnknown/option .../select/td ... ...Error: ... ...An error occurred while evaluating the expression: ... ... ... Client_Education is Less than 12 years ... ... ... ...Error near line 81, column 67. ... ...-- ... ...Donna French [EMAIL PROTECTED] ... ...Blog: http://dgfrench.blogspot.com ...Site: http://www.dgfrenchdesigns.com ... ... ~| 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:191407 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
Another pain with SELECT
I figured out what the problem was on my other SELECT but this one has me stumped. In the previous post I had my field setup as a combo box, so when I changed it to a text box and edited the SELECT Value= it worked properly. But this one I've changed both of the above and it's still throwing an error. Any help or insight would be greatly appreciated before I scream TGIF and run out of here! Code: select name=Client_AnnualIncome Value=#Client_AnnualIncome# tabindex=250 option value= cfif Client_AnnualIncome IS SELECTED/cfifSelect One.../option option value=0-4,999 cfif Client_AnnualIncome IS 0-4,999SELECTED/cfif0-4,999/option Error: Invalid parser construct found on line 100 at position 25. ColdFusion was looking at the following text: Client_PrimaryIncome Invalid expression format. The usual cause is an error in the expression structure. -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Logware: 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:191415 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
checkboxes
what's the best method for dealing with checkboxes? i want to insert a 1 if checked, a 0 if not. should i set the value in my form, or check the checked status in my insert query and set the value there? i know this should be simple but i've stared at it so long now i've confused myself. tia, donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| 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:191273 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: checkboxes
thanks to all - got it and cleared my head a little ;-) Donna On Thu, 20 Jan 2005 15:45:17 -0600, Andy Ousterhout [EMAIL PROTECTED] wrote: Remember that the Form.VarName will only be passed if checked, so in your action page you will need to loop through all possible names to check to see if the Fomr.VarName exists. Andy -Original Message- From: Donna French what's the best method for dealing with checkboxes? i want to insert a 1 if checked, a 0 if not. should i set the value in my form, or check the checked status in my insert query and set the value there? i know this should be simple but i've stared at it so long now i've confused myself. ~| Logware: 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:191291 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: Hosting
I had used ExpertHost until a couple years ago. They were great for most of the smaller sites I developed, but larger sites that get a lot of traffic they buckled on. This was about 3 years ago, so I can't speak for them as of now. I moved to CrystalTech and have had 2 very large sites that get lots of traffic and had never had any problems until the past week or so. I've emailed support 2 or 3 times because one of my main sites was down. I get a response within a very reasonable amount of time (normally 45 minutes or less) and they have let me know what is going on exactly each time. I'll be moving that particular site to CFMX or Blackstone soon and hope that the move away from CF5 will be more stable. But as far as support, service, options, etc. I do not have any complaints. HTH, Donna On Mon, 17 Jan 2005 12:25:30 -0600, James Edmunds [EMAIL PROTECTED] wrote: I have been extremely happy with CrystalTech, which has grown quite a bit in the four years or so I have had sites there, and has nevertheless kept a strong focus on quality hosting and strong support. The support is tremendous. They really respond quickly and will go the extra mile to make sure things are right. HTH, James On Fri, 14 Jan 2005 10:39:51 -0500, Al Everett [EMAIL PROTECTED] wrote: I know this question comes up a lot on the list, but I'm looking for a new CF hosting company. I know that there was even a conversation about the best ones in the last few months, but I'm not getting any love searching the HoF archives. I don't want to re-hash it all again but could someone point me to an archive of a thread or three? Thanks. -- Get Firefox! http://www.spreadfirefox.com/?q=affiliatesamp;id=58370amp;t=1 ~| Logware: 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:190849 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: Hosting
the 45 minutes comment was about getting email support - they have a system that autoresponds to let you know the average daily response time and the norm is 20-45 minutes On Mon, 17 Jan 2005 18:19:50 -0500, dave [EMAIL PROTECTED] wrote: [quote]normally 45 minutes or less[/quote] imo 45 minutes is just too long for a site to be down hostmysite woulda been all over that seems like ppl are reccommending crystaltech cause they have a blackstone beta, well lets not forget hostmysite had that long before crystaltech and they will be the first to commercially offer blackstone as well. seems like they are both very good hostmysites smarterlinux plans are just too good though and if the MM guys are hosting there instead of crystaltech, that says something.. -- Original Message -- From: Donna French [EMAIL PROTECTED] Reply-To: cf-talk@houseoffusion.com Date: Mon, 17 Jan 2005 16:23:24 -0600 I had used ExpertHost until a couple years ago. They were great for most of the smaller sites I developed, but larger sites that get a lot of traffic they buckled on. This was about 3 years ago, so I can't speak for them as of now. I moved to CrystalTech and have had 2 very large sites that get lots of traffic and had never had any problems until the past week or so. I've emailed support 2 or 3 times because one of my main sites was down. I get a response within a very reasonable amount of time (normally 45 minutes or less) and they have let me know what is going on exactly each time. I'll be moving that particular site to CFMX or Blackstone soon and hope that the move away from CF5 will be more stable. But as far as support, service, options, etc. I do not have any complaints. HTH, Donna ~| Logware: 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:190863 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: How to add images to my db the *right* way?
Hey Will - I'm going to give you a little H$LL here on the list - all in good humor of course - and only because you and I have chatted off list. But that code you posted sure looks a lot like CF and not .NET. LMAO I love ya, but I had to do it. Shoot me, sue me, whatever, it's Monday from hell here and I could NOT pass it up! ;-) Donna On Mon, 10 Jan 2005 15:50:38 -0400, Will Tomlinson [EMAIL PROTECTED] wrote: I'm almost finished with the coding on my clothing e-commerce site, but I'm running into a few minor snags. When dealing with images, I usually just add a few image fields in the main table, image1,2,3,etc. It usually works fine and I built this stupidly elaborate process for updating and deleting them. But this clothing db is a little different and the image setup needs to be done right for it all to work as I need. Everything revolves around a model of clothing. The tblprodmodels table has: prodmodelcode-PK varchar prodsellprice title category etc. I also have a tblavailablecolors with availablecolorID - PK (int-autnum) prodmodelcode - FK from tblprodmodels colorname FK from tblallcolors tblallcolors is just a lookup or validation table. Everything works great with me looping available colors into tblavailable colors with a multiple select menu like so: !--- Insert into available colors table --- cfquery datasource=#DSN# INSERT INTO tblavailablecolors (colorname, prodmodelcode) VALUES ('#FORM.prodcolor#', #FORM.model#) /cfquery The problem arises with having, say 10 filefields to upload to my db. I'm uploading and saving each filename with no problem, but how do I loop the filenames into the table? Actually, I need a new linking table. tblavailableimages? Hell, I'm having a brainfart here! How should I tie in the images for a model? And tie it with a color at the same time? GR!!! Will ~| 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:189843 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: Blog software?
Blogfusion looks great and I think I'm going to purchase a copy this week start trying it out more in-depth. Thanks! Donna On Sat, 8 Jan 2005 20:17:47 -0800, Rob [EMAIL PROTECTED] wrote: I use that one too (now) I just ported it BlueDragon, Linux, and Postgres - you can download it here if you wanna http://www.robrohan.com/ On Fri, 7 Jan 2005 14:30:05 -0500, Al Everett [EMAIL PROTECTED] wrote: Ditto from me. That's what I use. On Fri, 7 Jan 2005 18:52:26 +, JediHomer [EMAIL PROTECTED] wrote: You could have a look at Ray Camdens Blog... written in CF http://www.camdenfamily.com/morpheus/blog/ ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189739 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: Blog software?
I'm looking for a good blog software - hoping for CF based. So far, I like Movable Type but it's not CF based and was hoping some of you could point me to another one??? TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| 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:189674 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
Resources for learning CFC's ?
Can anyone point me to good resources online to learn more about CFC's? I've been reading a couple at EasyCFM.com but wanted to read some more and see more examples before I start trying to implement them. TIA, Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| 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:189288 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: Resources for learning CFC's ?
Okay, I've read a couple tutorials and have only learned enough to be dangerous - so PLEASE bare with me. After reading Forta's Using CFC's on the Macromedia site (http://www.macromedia.com/devnet/mx/coldfusion/extreme/bforta_cfc.html) I'm wondering if it is possible - or if anyone has done this. Build a shopping cart using a single CFC and just call a method for whatever the user wants to do (add item, etc.)? I'm probably way behind but I promise I am trying to get up to speed as quickly as possible! TIA, Donna On Tue, 4 Jan 2005 16:33:47 -0500, Troy Murray [EMAIL PROTECTED] wrote: Sean, Aside from the above links, and the pending book from HH, any other suggestions on learning CFC's correctly? -t On Tue, 4 Jan 2005 13:13:48 -0800, Sean Corfield [EMAIL PROTECTED] wrote: On Tue, 4 Jan 2005 15:44:45 -0500, Joe Rinehart [EMAIL PROTECTED] wrote: I don't know if there's a good, free online resource for introductory learning about CFCs: there's probably some tutorials at Macromedia, and a number of us post on CFCs frequently on our blogs. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/building.htm http://www.macromedia.com/devnet/mx/coldfusion/cfcs.html http://www.sitepoint.com/print/components-introduction The ColdFusion WACK by Ben Forta and Hal Helms' Discovering CFCs Be aware that both of those address CFMX 6.0 and are therefore based on what is considered extremely bad practice nowadays (because 6.0 did not support the good practices that 6.1 introduced). Both books talk about using THIS scope and make no mention of declaring local variables with VAR (because 6.0 didn't support it and didn't have the non-public VARIABLES scope). -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 6 invites to give away! 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:189310 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: Resources for learning CFC's ?
Thanks Brian, I've downloaded the sample and I'm curious if anyone else has been a simple cart using a single CFC and various functions within that CFC to add/delete/edit items in the cart? TIA, Donna On Tue, 4 Jan 2005 17:25:38 -0500, Brian Kotek [EMAIL PROTECTED] wrote: I have a sample Fusebox 4 application at my web site (http://www.briankotek.com) under the ColdFusion section. It uses CFCs as the model and includes a basic shopping cart. On Tue, 4 Jan 2005 16:17:00 -0600, Donna French [EMAIL PROTECTED] wrote: Okay, I've read a couple tutorials and have only learned enough to be dangerous - so PLEASE bare with me. After reading Forta's Using CFC's on the Macromedia site (http://www.macromedia.com/devnet/mx/coldfusion/extreme/bforta_cfc.html) I'm wondering if it is possible - or if anyone has done this. Build a shopping cart using a single CFC and just call a method for whatever the user wants to do (add item, etc.)? I'm probably way behind but I promise I am trying to get up to speed as quickly as possible! TIA, Donna On Tue, 4 Jan 2005 16:33:47 -0500, Troy Murray [EMAIL PROTECTED] wrote: Sean, Aside from the above links, and the pending book from HH, any other suggestions on learning CFC's correctly? -t On Tue, 4 Jan 2005 13:13:48 -0800, Sean Corfield [EMAIL PROTECTED] wrote: On Tue, 4 Jan 2005 15:44:45 -0500, Joe Rinehart [EMAIL PROTECTED] wrote: I don't know if there's a good, free online resource for introductory learning about CFCs: there's probably some tutorials at Macromedia, and a number of us post on CFCs frequently on our blogs. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/building.htm http://www.macromedia.com/devnet/mx/coldfusion/cfcs.html http://www.sitepoint.com/print/components-introduction The ColdFusion WACK by Ben Forta and Hal Helms' Discovering CFCs Be aware that both of those address CFMX 6.0 and are therefore based on what is considered extremely bad practice nowadays (because 6.0 did not support the good practices that 6.1 introduced). Both books talk about using THIS scope and make no mention of declaring local variables with VAR (because 6.0 didn't support it and didn't have the non-public VARIABLES scope). -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 6 invites to give away! 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:189314 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: Resources for learning CFC's ?
Okay, thanks. I've been coding VB.NET for about a year now so OO isn't a total mystery to me, but the whole CFC thing has captured my attention - and I'm sure it's partly because of my experience with .NET thus far. I welcome any and all emails on or off list look forward to exploring more into CFC's. Cold Fusion has once again captured my heart! LOL ;-) On Tue, 4 Jan 2005 14:55:46 -0800, Sean Corfield [EMAIL PROTECTED] wrote: On Tue, 4 Jan 2005 16:33:47 -0500, Troy Murray [EMAIL PROTECTED] wrote: Aside from the above links, and the pending book from HH, any other suggestions on learning CFC's correctly? It depends what you mean by correctly - if you mean full-blown OO then that's much harder (and will likely take you months or even years to become proficient with). If you're interested in going OO then: http://livedocs.macromedia.com/wtg/public/machiidevguide/ The concepts and models sections contain a lot of useful general OO information that is not Mach II specific. Otherwise, learn Java and use Java OO books to help you come up to speed on how to do OO right then you can apply what you've learned to CFCs. Part of the problem is that some of the concepts in OO can't be learned in CFCs directly because they don't support certain constructs (interfaces, true constructors etc) but you really need to understand those to be effective in OO. Of course, you can start using CFCs effectively without that but you might not reap any of the real benefits of OO without understanding more of the deeper concepts and constructs... I started down this part 13 years ago and I'm still learning :) -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 6 invites to give away! 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:189317 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: shopping cart, session variables - best practices
The company I work for is currently still running on CF5 and I am in the process of building my first custom shopping cart so thought it would be appropriate to jump into this thread. We are using CrystalTech for shared hosting, and the new site will be running on CFMX and SQL 2000. From what I've read on this post the best practice for my situation would be to use session variables and a structure for the info on each item. Any other tips for building a first shopping cart would be greatly appreciated. Feel free to email me off list! TIA, Donna On Mon, 3 Jan 2005 12:50:33 -0500, mayo [EMAIL PROTECTED] wrote: Sorry for not responding earlier. My laptop was stolen. A big mess. I'm on a shared host so the RAM is somewhat limited. However the client is a small clothing and jewelry business. They have two stores and this is their first venture into on-line sales. Currently they get about 200 unique visitors a week. I don't think they will have over 10 concurrent users of their shopping site for quite a while. gil -Original Message- From: Martin Parry [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 29, 2004 1:26 PM To: CF-Talk Subject: RE: shopping cart, session variables - best practices I think we should really find out the capabilities of Mayo's server/host before we can truly suggest one method over another. In high traffic eComm sites I have seen superb performance using the method described. If, however RAM is not a problem, he isn't experiencing high volumes and is not on another server with xxx websites who all make excessive use of session variables, then yes - maybe he should use session variables.. Mayo - please advise. Martin Parry Macromedia Certified Developer http://www.BeetrootStreet.co.uk -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 29 December 2004 18:02 To: CF-Talk Subject: RE: shopping cart, session variables - best practices Use a structure for storing the basket contents by all means, however instead of session.basketContents, convert the structure to a WDDX object and store it as client.basketContents - That way you're not using precious RAM but cheap disk space. Storing application- and user-specific data is what precious RAM is for! In an application environment with a single application server, you will typically achieve significantly higher performance under load by storing things in memory rather than fetching them from the database for each page request. You may need to provision your server's RAM adequately to ensure you have enough for the number of concurrent users you need to support, but RAM is comparatively cheap. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189189 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: Mailing Webpages
I've also been trying to find the best method for this. I have a small app that someone I believe on this list gave to me or told me about, that sends out emails 200 at a time. This helps so that it's not considered spam. If you'd like I can forward you a copy. I've used basic HTML inside the message for links and text formatting, but nothing beyond that. ~ Donna On Fri, 24 Dec 2004 10:53:16 -0800, John Munyan [EMAIL PROTECTED] wrote: Hi, I was wondering if anyone had any experiences they wanted to share about the best way to email webpages. My initial though was to use cfhttp inside of a cfmail tag but this seems to be rather problematic. Is there preferred way to allow users to click a link which embeds a dynamic cfm page into an email (not an attachment) and sends it to them? Any advice welcome. Thanks, John ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188755 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
Setup datasource thru code?
Is there a way to setup a datasource thru code instead of using the CF Admin? TIA, -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188483 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
SOT: Eclipse plug-ins
Okay, I primarily use CF 5 and MX, SQL 2000, and CSS - and I'm just wondering what plug-ins or added functionality are the Eclipse users getting the most bang from? So far, I'm becoming more and more hooked on CFEclipse, but I'm sure there is LOTS more I could be doing with it. I'm still in the process of checking out the resources but wondered what you guys are using and really seeing the greatest efficiency with? TIA, ~ Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188073 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
SOT: Eclipse Q's
Okay, I've downloaded Eclipse, installed the CFEclipse plug-in, and love it as far as editing code. But I'm wondering what all of you are using to do page layouts? I've also downloaded the CSS Editor but haven't figured out how to access it yet, maybe installed it wrong? Any other tips/tricks you all can throw my way about how to truly get the most from this product would be great. I've already went to Dopefly's resource page and that was great to get started with. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187108 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: Blackstone Beta
Geek gene ...LMAO On Fri, 10 Dec 2004 12:20:13 -0800, Ken Ketsdever [EMAIL PROTECTED] wrote: I think you have a fewer geek gene than the beta bunch. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 12:17 PM To: CF-Talk Subject: Re: Blackstone Beta I implore you. NOW! But I can't tell you why. Pass. Is there a really good reason that people seem so eager to become beta testers for someone else's product? I can see it perhaps if support tells you it addresses a problem you're having with the current generation. Or if you develop products or sell services based on the platform. I'd just as soon wait for the .1 version. - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, December 10, 2004 1:57 AM Subject: Blackstone Beta For those not in the blackstone beta, I implore you to get in on it NOW! http://www.macromedia.com/support/programs/beta.html ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187095 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
OT: Spam Filters
Sorry for the OT post, but I'm hoping someone has setup a great filtering system or list of keywords to filter by that won't mind sharing them. We use CrystalTech hosting and the spam filters are working fine, but the people within the company are driving me nuts asking when they will see a considerable decrease in spam. Right now, I go thru the emails and pull out keywords to filter by and add them to the growing list each day. But I still have users getting a couple hundred spam messages per day. Any help would be greatly appreciated. -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186497 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: Hosting for Coldfusion
www.CrystalTech.com I've used them for years on small sites to very large with high traffic volume - never had any problems HTH ~ Donna On Thu, 2 Dec 2004 10:19:38 -0500, Tangorre, Michael [EMAIL PROTECTED] wrote: From: Steven Wojciechowski [mailto:[EMAIL PROTECTED] If anyone has any other suggestions of good value CF hosting with good bandwidth packages, then please let me know. If not, then I may have to think about redeveloping in PHP ;) This topic comes up all the time. The archives will be the best bet for research on this topic. I would highly recommend www.hostmysite.com as their service and up time are awesome. Depending upon your needs, they have some excellent plans. Mike ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185949 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: Hosting for Coldfusion
I wonder what kinds of problems. I have several small sites running on them, and the company I work for hosts there and uses SQL Server. We get over 50k unique visits per month, 200k+ page views, and never have problems. Would be curious to know if someone is having problems with them what it is for future reference if nothing else. ~ Donna On Thu, 2 Dec 2004 16:01:28 -0500, Burns, John D [EMAIL PROTECTED] wrote: From what people on here say about CrystalTech, at least recently, they don't seem to be all that great. Although, that argument may be more against SQL server and some other services they offer, but regardless, I've seen a lot of complaints on here lately about crystaltech. John -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, December 02, 2004 2:53 PM To: CF-Talk Subject: Re: Hosting for Coldfusion I recommend 3 CF hosts. 1.CRYSTALTECH 2.CRYSTALTECH 3.CRYSTALTECH I doubt anyone does it better! Will ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186012 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: Hosting for Coldfusion
Yeah, the EM issue is a pain, but I've been thru so many crappy web hosting companies I am happy to wait rather than have the others I've been thru again. So they would have to do something major for me to even consider moving at this point. My 2 cents (again) On Thu, 2 Dec 2004 16:37:18 -0500, Burns, John D [EMAIL PROTECTED] wrote: Well, I don't remember all of the complaints from the list, but one person I know personally on this list has crystaltech and when he uses enterprise manager to connect to the SQL server, it lists over 5000+ databases and it can take hours to load the entire list of DBs before he can actually get into his to use it. That just sounds like a crazy problem to have to deal with. I'm sure if you search the archives of the list, you'll find some other problems as well. I'm not anti-crystaltech or anything, I just wanted to contribute what I've heard on the list. I personally use rackspace.com and have a dedicated server there and have had great success. Granted, that was after I was hosting with ClickDoug (Doug White) and he disappeared from the face of the earth, so anything that actually works is a step up for me, but so far, so good. John Burns -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Thursday, December 02, 2004 4:17 PM To: CF-Talk Subject: Re: Hosting for Coldfusion I wonder what kinds of problems. I have several small sites running on them, and the company I work for hosts there and uses SQL Server. We get over 50k unique visits per month, 200k+ page views, and never have problems. Would be curious to know if someone is having problems with them what it is for future reference if nothing else. ~ Donna On Thu, 2 Dec 2004 16:01:28 -0500, Burns, John D [EMAIL PROTECTED] wrote: From what people on here say about CrystalTech, at least recently, they don't seem to be all that great. Although, that argument may be more against SQL server and some other services they offer, but regardless, I've seen a lot of complaints on here lately about crystaltech. John -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, December 02, 2004 2:53 PM To: CF-Talk Subject: Re: Hosting for Coldfusion I recommend 3 CF hosts. 1.CRYSTALTECH 2.CRYSTALTECH 3.CRYSTALTECH I doubt anyone does it better! Will ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186020 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: What's in your toolkit?
Okay, I'm trying to find new tools that make life easier and I'm curious about these that you use: Swishmax Swift3D Navicat DbaMgr2k THX, Donna On Thu, 25 Nov 2004 08:38:18 -0400, Will Tomlinson [EMAIL PROTECTED] wrote: Ok here goes! DreamweaverMX Homesite FlashMX Swishmax Swift3D MySQL Access MSDE SQLServer Navicat DbaMgr2K Those handle all that I do. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185456 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: Scan Docs to Edit
Okay, sorry for the OT post, but I'm trying to help a lawyer friend of mine and not real sure how to tackle this. I need to scan a document then allow them to enter text either on top of the scan, or scan in as a PDF or similar? Any help greatly appreciated. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185360 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: Scan Docs to Edit
Yes but we are talking about very computer illiterate folks here. Need something simple if possible. ~ D On Wed, 24 Nov 2004 14:51:15 -0700, dana tierney [EMAIL PROTECTED] wrote: you need to put text on top of the scanned image? Is Photoshop available? On Wed, 24 Nov 2004 15:41:11 -0600, Donna French [EMAIL PROTECTED] wrote: Okay, sorry for the OT post, but I'm trying to help a lawyer friend of mine and not real sure how to tackle this. I need to scan a document then allow them to enter text either on top of the scan, or scan in as a PDF or similar? Any help greatly appreciated. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185363 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 Datasource
still no luck on this. can anybody help me out? i've entered my local machine name no luck??? On Thu, 18 Nov 2004 15:13:41 -0600, Eric Creese [EMAIL PROTECTED] wrote: GOT THE SERVER NAME RIGHT? YOU MAY HAVE TO USE THE NAME OF YOUR LOCAL MACHINE -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 3:05 PM To: CF-Talk Subject: SQL Datasource I'm trying to setup a SQL Server datasource and keep getting an error. I've imported my database locally from the remote server using DTS, and have named the datasource, database, appropriate datasource type. Any suggestions welcome. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184897 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 Datasource
How do I make sure CF has permission to access SQL server? On Fri, 19 Nov 2004 17:15:19 -, Andy Mcshane [EMAIL PROTECTED] wrote: Is Coldfusion on the same server as the database, if so, I usually just enter 'localhost' for servername. Have you checked that the login details in Coldfusion actually has permission to access the database on SQL server? Andy McShane Head of Development Scout7 Ltd, 324a Lichfield Road, Mere Green, Sutton Coldfield West Midlands United Kingdom B74 2UW Telephone: +44 (0)121 323 2640 Mobile : 07866 430783 Fax: +44 (0)121 323 2010 Email: mailto:[EMAIL PROTECTED] Website: www.scout7.com -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: 19 November 2004 17:10 To: CF-Talk Subject: Re: SQL Datasource still no luck on this. can anybody help me out? i've entered my local machine name no luck??? On Thu, 18 Nov 2004 15:13:41 -0600, Eric Creese [EMAIL PROTECTED] wrote: GOT THE SERVER NAME RIGHT? YOU MAY HAVE TO USE THE NAME OF YOUR LOCAL MACHINE -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 3:05 PM To: CF-Talk Subject: SQL Datasource I'm trying to setup a SQL Server datasource and keep getting an error. I've imported my database locally from the remote server using DTS, and have named the datasource, database, appropriate datasource type. Any suggestions welcome. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184915 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
SQL Datasource
I'm trying to setup a SQL Server datasource and keep getting an error. I've imported my database locally from the remote server using DTS, and have named the datasource, database, appropriate datasource type. Any suggestions welcome. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184813 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
SQL Help Needed
I am redesigning an SQL database and need to know if it's possible to select specific tables/columns from the original into specific tables/columns in the new database. I know I can select the columns I want but moving them into a specified column in the new db that isn't the same structure is what I'm not sure of. Any help appreciated. -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184819 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 Help Needed
Okay, here's what I've come up with we'll see how it goes... SELECT lanesID, subcategoryID, name, availability, price, srp, cost, description FROM dolls_backup INSERT INTO tblProducts(ProdName, ProdDesc, ProdSRP, ProdPrice, ProdCost, SubcatID) VALUES (dolls_backup.name, dolls_backup.description, dolls_backup.srp, dolls_backup.cost, dolls_backup.subcategoryID) ~ Donna On Thu, 18 Nov 2004 13:49:06 -0800, Barney Boisvert [EMAIL PROTECTED] wrote: You'll have to check on the exact syntax, but something like this should work: INSERT INTO myTable (col1, col2, col3) SELECT col4, col5, col6 FROM otherTable The SELECT can be as complex as you want, as long as the columns it returns are the same number and type as what is needed by the INSERT portion. cheers, barneyb On Thu, 18 Nov 2004 15:33:40 -0600, Donna French [EMAIL PROTECTED] wrote: I am redesigning an SQL database and need to know if it's possible to select specific tables/columns from the original into specific tables/columns in the new database. I know I can select the columns I want but moving them into a specified column in the new db that isn't the same structure is what I'm not sure of. Any help appreciated. -- -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184823 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: Help! Error on ValueList
Okay, I've uploaded to my production server - CFMX and MS SQL - and ran the page in test mode and I'm not getting anything. Just a blank page when I run it now. Any ideas/suggestions??? Thank you all for your help! Donna On Wed, 17 Nov 2004 11:16:20 -0700, Scott Brady [EMAIL PROTECTED] wrote: The error message actually tells you the primary issue: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'products'. Make sure it exists and that its name is spelled correctly. It can't find a table called products in the datasource. Make sure you're using the right datasource. Make sure there is actually a table (or query) in Access called products in that datasource. You can also take your query and try running it inside Access to see if it runs there. Scott -- - Scott Brady http://www.scottbrady.net/ ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184631 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: Help! Error on ValueList
I had left the CFAbort from yesterday. Removed that, then the query name was wrong in part of the output. So I've corrected that and have the current code and error: Code: html head titleImages Cleanup/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body !--- CONFIGURATION --- !--- Change these to suit your server --- cfset dsn = mydsn cfset imagesDirectory = c:\inetpub\lanescollectibles\images cfset imagesSubdirectories = 400,200,85 !--- SQL Server is not case-sensitive, so lanesid = lanesID --- cfset imageColumnName = lanesid !--- Change this to FALSE to really do the deletes... --- cfset testMode = true / !--- /CONFIGURATION --- !--- Get all of the filenames --- cfquery datasource=#dsn# name=qGetFilenames SELECT #imageColumnName# FROM products UNION SELECT #imageColumnName# FROM dolls /cfquery !--- Turn the filenames into a list --- cfset fileNames = #ValueList(qGetFilenames.imageColumnName)# / !--- Loop through the various image subdirectories doing cleanup --- cfloop list=#imagesSubdirectories# index=i cfdirectory action=list directory=#imagesDirectory#\#i# name=qDirectory !--- Loop over the files in the directory, deleting any that isn't in the list of existing files --- cfoutput cfloop query=qDirectory cfif not listFind(fileNames, qDirectory.name) cfif not testMode cffile action=delete file=#imagesDirectory#\#i#\#qDirectory.name# cfelse Test Mode: #imagesDirectory#\#i#\#qDirectory.name# would be deleted. br / /cfif /cfif /cfloop /cfoutput /cfloop /body /html Error: Error Diagnostic Information An error occurred while evaluating the expression: fileNames = #ValueList(qGetFilenames.imageColumnName)# Error near line 30, column 7. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184632 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: Help! Error on ValueList SOLVED
Got it working with the following code: html head titleImages Cleanup/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body !--- CONFIGURATION --- !--- Change these to suit your server --- cfset dsn = mydsn cfset imagesDirectory = c:\inetpub\lanescollectibles\images cfset imagesSubdirectories = 400,200,85 !--- SQL Server is not case-sensitive, so lanesid = lanesID --- cfset imageColumnName = lanesid !--- Change this to FALSE to really do the deletes... --- cfset testMode = true / !--- /CONFIGURATION --- !--- Get all of the filenames --- cfquery datasource=#dsn# name=qGetFilenames SELECT #imageColumnName# FROM products UNION SELECT #imageColumnName# FROM dolls /cfquery !--- Turn the filenames into a list --- cfset fileNames = 'ValueList(qGetFilenames.#imageColumnName#)' / !--- Loop through the various image subdirectories doing cleanup --- cfloop list=#imagesSubdirectories# index=i cfdirectory action=list directory=#imagesDirectory#\#i# name=qDirectory !--- Loop over the files in the directory, deleting any that isn't in the list of existing files --- cfoutput cfloop query=qDirectory cfif not listFind(fileNames, qDirectory.name) cfif not testMode cffile action=delete file=#imagesDirectory#\#i#\#qDirectory.name# cfelse Test Mode: #imagesDirectory#\#i#\#qDirectory.name# would be deleted. br / /cfif /cfif /cfloop /cfoutput /cfloop /body /html Thank you to everyone that helped!!! ~ Donna ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184636 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: Help! Error on ValueList
Well, it ALMOST worked - when I tried it in REAL mode I get the following error: Error processing CFFILE Unable to delete the file 'c:\inetpub\lanescollectibles\images\400\..' Access is denied. (error 5) The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (46:9) to (46:79). I'm assuming it's the .. to go up a folder on the server that it's trying to delete. Guess I need to plug in a CFIF to skip that? TIA, Donna On Wed, 17 Nov 2004 12:36:53 -0600, Donna French [EMAIL PROTECTED] wrote: I had left the CFAbort from yesterday. Removed that, then the query name was wrong in part of the output. So I've corrected that and have the current code and error: Code: html head titleImages Cleanup/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body !--- CONFIGURATION --- !--- Change these to suit your server --- cfset dsn = mydsn cfset imagesDirectory = c:\inetpub\lanescollectibles\images cfset imagesSubdirectories = 400,200,85 !--- SQL Server is not case-sensitive, so lanesid = lanesID --- cfset imageColumnName = lanesid !--- Change this to FALSE to really do the deletes... --- cfset testMode = true / !--- /CONFIGURATION --- !--- Get all of the filenames --- cfquery datasource=#dsn# name=qGetFilenames SELECT #imageColumnName# FROM products UNION SELECT #imageColumnName# FROM dolls /cfquery !--- Turn the filenames into a list --- cfset fileNames = #ValueList(qGetFilenames.imageColumnName)# / !--- Loop through the various image subdirectories doing cleanup --- cfloop list=#imagesSubdirectories# index=i cfdirectory action=list directory=#imagesDirectory#\#i# name=qDirectory !--- Loop over the files in the directory, deleting any that isn't in the list of existing files --- cfoutput cfloop query=qDirectory cfif not listFind(fileNames, qDirectory.name) cfif not testMode cffile action=delete file=#imagesDirectory#\#i#\#qDirectory.name# cfelse Test Mode: #imagesDirectory#\#i#\#qDirectory.name# would be deleted. br / /cfif /cfif /cfloop /cfoutput /cfloop /body /html Error: Error Diagnostic Information An error occurred while evaluating the expression: fileNames = #ValueList(qGetFilenames.imageColumnName)# Error near line 30, column 7. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184641 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: Help! Error on ValueList
Doh! I forgot this site is still running on CF5 on the server..duh. Thx, ~ D On Wed, 17 Nov 2004 20:04:06 +0100, Pascal Peters [EMAIL PROTECTED] wrote: Yes you do (only on pre CFMX) -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 20:00 To: CF-Talk Subject: Re: Help! Error on ValueList Well, it ALMOST worked - when I tried it in REAL mode I get the following error: Error processing CFFILE Unable to delete the file 'c:\inetpub\lanescollectibles\images\400\..' Access is denied. (error 5) The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (46:9) to (46:79). I'm assuming it's the .. to go up a folder on the server that it's trying to delete. Guess I need to plug in a CFIF to skip that? TIA, Donna ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184643 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: Help! Error on ValueList SOLVED
Thanks for your help Pascal. Forgive me for not knowing, but can I ask you why I should use the alias instead of the variable ? TIA, Donna On Wed, 17 Nov 2004 19:59:34 +0100, Pascal Peters [EMAIL PROTECTED] wrote: I hardly think this will work correctly. Dumping filenames should give you the string ValueList(qGetFilenames.lanesid). You would need an evaluate to make it work. A better solution is using an alias (see my other post). Pascal -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 19:49 To: CF-Talk Subject: Re: Help! Error on ValueList SOLVED Got it working with the following code: html head titleImages Cleanup/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body !--- CONFIGURATION --- !--- Change these to suit your server --- cfset dsn = mydsn cfset imagesDirectory = c:\inetpub\lanescollectibles\images cfset imagesSubdirectories = 400,200,85 !--- SQL Server is not case-sensitive, so lanesid = lanesID --- cfset imageColumnName = lanesid !--- Change this to FALSE to really do the deletes... --- cfset testMode = true / !--- /CONFIGURATION --- !--- Get all of the filenames --- cfquery datasource=#dsn# name=qGetFilenames SELECT #imageColumnName# FROM products UNION SELECT #imageColumnName# FROM dolls /cfquery !--- Turn the filenames into a list --- cfset fileNames = 'ValueList(qGetFilenames.#imageColumnName#)' / !--- Loop through the various image subdirectories doing cleanup --- cfloop list=#imagesSubdirectories# index=i cfdirectory action=list directory=#imagesDirectory#\#i# name=qDirectory !--- Loop over the files in the directory, deleting any that isn't in the list of existing files --- cfoutput cfloop query=qDirectory cfif not listFind(fileNames, qDirectory.name) cfif not testMode cffile action=delete file=#imagesDirectory#\#i#\#qDirectory.name# cfelse Test Mode: #imagesDirectory#\#i#\#qDirectory.name# would be deleted. br / /cfif /cfif /cfloop /cfoutput /cfloop /body /html Thank you to everyone that helped!!! ~ Donna ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184644 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: Help! Error on ValueList SOLVED
Okay, thank you for your help. I have altered the code to include the alias. Just looking at it without knowing it looked like an unnecessary extra step. Now I have the following error and I'm not sure how to go about fixing it. I want to have it skip the .. directory listing on the server, but can't figure out how after several attempts. Please bare with me, I've ordered CF books and plan to put them to good use! Here's the code and error: !--- Loop through the various image subdirectories doing cleanup --- cfloop list=#imagesSubdirectories# index=i cfdirectory action=list directory=#imagesDirectory#\#i# name=qDirectory !--- Loop over the files in the directory, deleting any that isn't in the list of existing files --- cfoutput cfloop query=qDirectory cfif not listFind(fileNames, qDirectory.name) cfif not testMode cfif #qDirectory.name# IS .. cfelse cffile action=delete file=#imagesDirectory#\#i#\#qDirectory.name#.jpg /cfif cfelse Test Mode: #imagesDirectory#\#i#\#qDirectory.name# would be deleted. br / /cfif /cfif /cfloop /cfoutput /cfloop Error processing CFFILE The path, 'c:\inetpub\lanescollectibles\images\400\..jpg', is illegal. Path specifications cannot include '..' The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (48:11) to (48:85). Thank you! ~ D On Wed, 17 Nov 2004 20:25:49 +0100, Pascal Peters [EMAIL PROTECTED] wrote: You have a dynamically named column that you can't use with the function ValueList(). This leaves two options: Option 1 (use an alias to get a fixed column name): cfquery datasource=#dsn# name=qGetFilenames SELECT #imageColumnName# AS mycol FROM products UNION SELECT #imageColumnName# AS mycol FROM dolls /cfquery cfset fileNames = ValueList(qGetFilenames.mycol) Option 2 (use evaluate): cfquery datasource=#dsn# name=qGetFilenames SELECT #imageColumnName# FROM products UNION SELECT #imageColumnName# FROM dolls /cfquery cfset fileNames = Evaluate(ValueList(qGetFilenames.#imageColumnName#) Evaluate is not a very performant function and should only be used if there is no other option (and there usually is another option) Pascal -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 20:15 To: CF-Talk Subject: Re: Help! Error on ValueList SOLVED Thanks for your help Pascal. Forgive me for not knowing, but can I ask you why I should use the alias instead of the variable ? TIA, Donna ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184650 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: Help! Error on ValueList SOLVED
Tried starting the CFOUTPUT at startrow 2 but then I have to specify a query - so I'm not sure how to work around this??? It seems like a CFIF should work to check for .. but everything I've tried throws an error. ~ D On Wed, 17 Nov 2004 13:36:03 -0600, Donna French [EMAIL PROTECTED] wrote: Okay, thank you for your help. I have altered the code to include the alias. Just looking at it without knowing it looked like an unnecessary extra step. Now I have the following error and I'm not sure how to go about fixing it. I want to have it skip the .. directory listing on the server, but can't figure out how after several attempts. Please bare with me, I've ordered CF books and plan to put them to good use! Here's the code and error: !--- Loop through the various image subdirectories doing cleanup --- cfloop list=#imagesSubdirectories# index=i cfdirectory action=list directory=#imagesDirectory#\#i# name=qDirectory !--- Loop over the files in the directory, deleting any that isn't in the list of existing files --- cfoutput cfloop query=qDirectory cfif not listFind(fileNames, qDirectory.name) cfif not testMode cfif #qDirectory.name# IS .. cfelse cffile action=delete file=#imagesDirectory#\#i#\#qDirectory.name#.jpg /cfif cfelse Test Mode: #imagesDirectory#\#i#\#qDirectory.name# would be deleted. br / /cfif /cfif /cfloop /cfoutput /cfloop Error processing CFFILE The path, 'c:\inetpub\lanescollectibles\images\400\..jpg', is illegal. Path specifications cannot include '..' The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (48:11) to (48:85). Thank you! ~ D On Wed, 17 Nov 2004 20:25:49 +0100, Pascal Peters [EMAIL PROTECTED] wrote: You have a dynamically named column that you can't use with the function ValueList(). This leaves two options: Option 1 (use an alias to get a fixed column name): cfquery datasource=#dsn# name=qGetFilenames SELECT #imageColumnName# AS mycol FROM products UNION SELECT #imageColumnName# AS mycol FROM dolls /cfquery cfset fileNames = ValueList(qGetFilenames.mycol) Option 2 (use evaluate): cfquery datasource=#dsn# name=qGetFilenames SELECT #imageColumnName# FROM products UNION SELECT #imageColumnName# FROM dolls /cfquery cfset fileNames = Evaluate(ValueList(qGetFilenames.#imageColumnName#) Evaluate is not a very performant function and should only be used if there is no other option (and there usually is another option) Pascal -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 20:15 To: CF-Talk Subject: Re: Help! Error on ValueList SOLVED Thanks for your help Pascal. Forgive me for not knowing, but can I ask you why I should use the alias instead of the variable ? TIA, Donna ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184651 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: Help! Error on ValueList SOLVED
Okay, that deleted all files in each directory so I'm having the hosting company restore from backup. Any ideas? Code used: html head titleImages Cleanup/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body !--- CONFIGURATION --- !--- Change these to suit your server --- cfset dsn = mydsn cfset imagesDirectory = c:\inetpub\lanescollectibles\images cfset imagesSubdirectories = 400,200,85 !--- SQL Server is not case-sensitive, so lanesid = lanesID --- cfset imageColumnName = lanesid !--- Change this to FALSE to really do the deletes... --- cfset testMode = FALSE / !--- /CONFIGURATION --- !--- Get all of the filenames --- cfquery datasource=#dsn# name=qGetFilenames SELECT #imageColumnName# AS mycol FROM products UNION SELECT #imageColumnName# AS mycol FROM dolls /cfquery !--- Turn the filenames into a list --- cfset fileNames = ValueList(qGetFilenames.mycol) / !--- Loop through the various image subdirectories doing cleanup --- cfloop list=#imagesSubdirectories# index=i cfdirectory action=list directory=#imagesDirectory#\#i# name=qDirectory !--- Loop over the files in the directory, deleting any that isn't in the list of existing files --- cfoutput cfloop query=qDirectory cfif qDirectory.type IS file AND not listFind(fileNames, qDirectory.name) cfif not testMode cffile action=delete file=#imagesDirectory#\#i#\#qDirectory.name# cfelse Test Mode: #imagesDirectory#\#i#\#qDirectory.name# would be deleted. br / /cfif /cfif /cfloop /cfoutput /cfloop /body /html On Wed, 17 Nov 2004 20:47:41 +0100, Pascal Peters [EMAIL PROTECTED] wrote: There is also a directory . See my previous post for the solution Pascal -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 20:41 To: CF-Talk Subject: Re: Help! Error on ValueList SOLVED Tried starting the CFOUTPUT at startrow 2 but then I have to specify a query - so I'm not sure how to work around this??? It seems like a CFIF should work to check for .. but everything I've tried throws an error. ~ D On Wed, 17 Nov 2004 13:36:03 -0600, Donna French [EMAIL PROTECTED] wrote: Okay, thank you for your help. I have altered the code to include the alias. Just looking at it without knowing it looked like an unnecessary extra step. Now I have the following error and I'm not sure how to go about fixing it. I want to have it skip the .. directory listing on the server, but can't figure out how after several attempts. Please bare with me, I've ordered CF books and plan to put them to good use! Here's the code and error: !--- Loop through the various image subdirectories doing cleanup --- cfloop list=#imagesSubdirectories# index=i cfdirectory action=list directory=#imagesDirectory#\#i# name=qDirectory !--- Loop over the files in the directory, deleting any that isn't in the list of existing files --- cfoutput cfloop query=qDirectory cfif not listFind(fileNames, qDirectory.name) cfif not testMode cfif #qDirectory.name# IS .. cfelse cffile action=delete file=#imagesDirectory#\#i#\#qDirectory.name#.jpg /cfif cfelse Test Mode: #imagesDirectory#\#i#\#qDirectory.name# would be deleted. br / /cfif /cfif /cfloop /cfoutput /cfloop Error processing CFFILE The path, 'c:\inetpub\lanescollectibles\images\400\..jpg', is illegal. Path specifications cannot include '..' The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (48:11) to (48:85). Thank you! ~ D On Wed, 17 Nov 2004 20:25:49 +0100, Pascal Peters [EMAIL PROTECTED] wrote: You have a dynamically named column that you can't use with the function ValueList(). This leaves two options: Option 1 (use an alias to get a fixed column name): cfquery datasource=#dsn# name=qGetFilenames SELECT #imageColumnName# AS mycol FROM products UNION SELECT #imageColumnName# AS mycol FROM dolls /cfquery cfset fileNames = ValueList(qGetFilenames.mycol) Option 2 (use evaluate): cfquery datasource=#dsn# name=qGetFilenames SELECT #imageColumnName# FROM products UNION SELECT #imageColumnName# FROM dolls /cfquery cfset fileNames = Evaluate(ValueList(qGetFilenames.#imageColumnName#) Evaluate is not a very performant function and should only be used if there is no other option (and there usually is another option) Pascal -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 20:15 To: CF-Talk Subject: Re: Help! Error on ValueList SOLVED
Re: Help! Error on ValueList SOLVED
cfset fileNames = valueList(qGetFilesnames.#imageColumnName#) / I didn't write this code - you could probably figure that out by now. But what I'm trying to do is cleanup images off the server. When I first wrote this web app about 3 years ago, I didn't include logic to delete the image files when a product was deleted from the database. And I'm also in the process of re-designing the database, because I have products in two different tables (dolls and products). So don't slap my hand on that one. I had just started doing CF much less database work. I do appreciate all of the help and do not take anyone's time for granted. ~ Donna On Wed, 17 Nov 2004 22:27:49 +0100, Pascal Peters [EMAIL PROTECTED] wrote: Your logic is probably wrong. What does #fileNames# contain??? Just an image name, a relative path, ...? Also, it's not a very good idea to test your code on a live server. Pascal -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 22:14 To: CF-Talk Subject: Re: Help! Error on ValueList SOLVED Okay, that deleted all files in each directory so I'm having the hosting company restore from backup. Any ideas? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184673 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: Help! Error on ValueList SOLVED
Oh okay, I see - the image is referred to by lanesid (img src=images/400/#lanesid#.jpg) On Wed, 17 Nov 2004 22:56:16 +0100, Pascal Peters [EMAIL PROTECTED] wrote: The general idea of what you are doing seems OK. Get the images from your tables and compare them with the images in your file system. I was asking what you are storing in your table. The image file name, the file name without extension, the relative path to te file, the url to the file, ...?? It is deleting all your images because NOT listFind(fileNames, qDirectory.name) always returns true. You have to find out why this happens. My best guess is that your table doesn't store the filename, but something else (the relative path from some directory maybe?). Or maybe you are on a windows server and the stored filename doesn't respect the case (use listFindNoCase then). There could be about a hundred more things that go wrong. You could write a test page first that doesn't do the deletes, but outputs some variables. Pascal -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 22:41 To: CF-Talk Subject: Re: Help! Error on ValueList SOLVED cfset fileNames = valueList(qGetFilesnames.#imageColumnName#) / I didn't write this code - you could probably figure that out by now. But what I'm trying to do is cleanup images off the server. When I first wrote this web app about 3 years ago, I didn't include logic to delete the image files when a product was deleted from the database. And I'm also in the process of re-designing the database, because I have products in two different tables (dolls and products). So don't slap my hand on that one. I had just started doing CF much less database work. I do appreciate all of the help and do not take anyone's time for granted. ~ Donna On Wed, 17 Nov 2004 22:27:49 +0100, Pascal Peters [EMAIL PROTECTED] wrote: Your logic is probably wrong. What does #fileNames# contain??? Just an image name, a relative path, ...? Also, it's not a very good idea to test your code on a live server. Pascal -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: 17 November 2004 22:14 To: CF-Talk Subject: Re: Help! Error on ValueList SOLVED Okay, that deleted all files in each directory so I'm having the hosting company restore from backup. Any ideas? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184678 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
Help! Error on ValueList
Okay, I'm trying to run this code local (CFMX Access) and keep getting an error. Code: !--- CONFIGURATION --- !--- Change these to suit your server --- cfset dsn = lanes cfset imagesDirectory = c:\Documents and Settings\Lanes\My Documents\Web-Images\85 cfset imagesSubdirectories = 400,200,85 !--- SQL Server is not case-sensitive, so lanesid = lanesID --- cfset imageColumnName = lanesid !--- Change this to FALSE to really do the deletes... --- cfset testMode = true / !--- /CONFIGURATION --- !--- Get all of the filenames --- cfquery datasource=#dsn# name=qGetFilenames SELECT #imageColumnName# FROM products UNION SELECT #imageColumnName# FROM dolls /cfquery !--- Turn the filenames into a list --- cfset fileNames = #ValueList(qGetFilesnames.imageColumnName)# / !--- Loop through the various image subdirectories doing cleanup --- cfloop list=#imagesSubdirectories# index=i cfdirectory action=list directory=#imagesDirectory#\#i# name=qDirectory !--- Loop over the files in the directory, deleting any that isn't in the list of existing files --- cfoutput cfloop query=qDirectory cfif not listFind(fileNames, qDirectory.name) cfif not testMode cffile action=delete file=#imagesDirectory#\#i#\#qDirectory.name# cfelse Test Mode: #imagesDirectory#\#i#\#qDirectory.name# would be deleted. br / /cfif /cfif /cfloop /cfoutput /cfloop Error: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'products'. Make sure it exists and that its name is spelled correctly. The Error Occurred in C:\Documents and Settings\Lanes\My Documents\Web\imagesCleanup.cfm: line 29 27 : /cfquery 28 : 29 : !--- Turn the filenames into a list --- 30 : cfset fileNames = #ValueList(qGetFilesnames.imageColumnName)# / 31 : ANY help greatly appreciated. A guy on this list helped with this a while back and I've never sat down and really tried to get it working. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184496 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: Help! Error on ValueList
I added the cfabort and it's throwing an error on the query. Now I'm wondering if Access if case sensitive? That's the only thing I can imagine but I changed my #imageColumnName# to the actual columns from each table and still no luck with this error: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'products'. Make sure it exists and that its name is spelled correctly. The Error Occurred in C:\Documents and Settings\Lanes\My Documents\Web\imagesCleanup.cfm: line 27 25 : UNION 26 : SELECT lanesID FROM dolls 27 : /cfquery 28 : cfabort 29 : !--- Turn the filenames into a list --- On Wed, 17 Nov 2004 12:14:21 +1300, Matthew Walker [EMAIL PROTECTED] wrote: Looks like CF is flagging the wrong line as being in error. Try adding a cfabort immediately after the /cfquery . You'll probably still get the error, suggesting that it's actually the query or (more likely) the database that's wrong. Matthew Walker, ESWsoftware http://www.eswsoftware.com -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Wednesday, 17 November 2004 12:00 p.m. To: CF-Talk Subject: Help! Error on ValueList Okay, I'm trying to run this code local (CFMX Access) and keep getting an error. Code: !--- CONFIGURATION --- !--- Change these to suit your server --- cfset dsn = lanes cfset imagesDirectory = c:\Documents and Settings\Lanes\My Documents\Web-Images\85 cfset imagesSubdirectories = 400,200,85 !--- SQL Server is not case-sensitive, so lanesid = lanesID --- cfset imageColumnName = lanesid !--- Change this to FALSE to really do the deletes... --- cfset testMode = true / !--- /CONFIGURATION --- !--- Get all of the filenames --- cfquery datasource=#dsn# name=qGetFilenames SELECT #imageColumnName# FROM products UNION SELECT #imageColumnName# FROM dolls /cfquery !--- Turn the filenames into a list --- cfset fileNames = #ValueList(qGetFilesnames.imageColumnName)# / !--- Loop through the various image subdirectories doing cleanup --- cfloop list=#imagesSubdirectories# index=i cfdirectory action=list directory=#imagesDirectory#\#i# name=qDirectory !--- Loop over the files in the directory, deleting any that isn't in the list of existing files --- cfoutput cfloop query=qDirectory cfif not listFind(fileNames, qDirectory.name) cfif not testMode cffile action=delete file=#imagesDirectory#\#i#\#qDirectory.name# cfelse Test Mode: #imagesDirectory#\#i#\#qDirectory.name# would be deleted. br / /cfif /cfif /cfloop /cfoutput /cfloop Error: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'products'. Make sure it exists and that its name is spelled correctly. The Error Occurred in C:\Documents and Settings\Lanes\My Documents\Web\imagesCleanup.cfm: line 29 27 : /cfquery 28 : 29 : !--- Turn the filenames into a list --- 30 : cfset fileNames = #ValueList(qGetFilesnames.imageColumnName)# / 31 : ANY help greatly appreciated. A guy on this list helped with this a while back and I've never sat down and really tried to get it working. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184499 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: Need Book Recommendation
I've looked at that one briefly and plan to look at it more in-depth on my next Books a Million outing. THX!!! On Thu, 11 Nov 2004 17:54:57 +0100, Massimo Foti [EMAIL PROTECTED] wrote: I have the CF5 Web App Kit, and have looked at the CFMX WAK but it appears to be mostly the same content as the CF5. So I've started considering the Advanced CFMX WAK or the Certification Study Guide. Can anyone recommend either, or another that would be appropriate for studying CFMX beyond the basics. Both are excellent. I would consider this one as well: http://www.oreilly.com/catalog/coldfusion2/ Check the TOC and sample chapter to get a better idea Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.3.0 - Release Date: 11/13/04 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184314 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
OT: CSS Resources
I am hoping some of you can recommend a good online source for CSS. I'm wanting to add dotted lines and such around paragraphs, and would like to see examples with code of what all can be done with CSS. TIA, -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184318 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
Need Book Recommendation
I have the CF5 Web App Kit, and have looked at the CFMX WAK but it appears to be mostly the same content as the CF5. So I've started considering the Advanced CFMX WAK or the Certification Study Guide. Can anyone recommend either, or another that would be appropriate for studying CFMX beyond the basics. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183956 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 Book Recommendation
I think I probably have some sort of OCD too, I like to have them all so I just ordered all three from Amazon - used. We'll see how well my OCD side can handle the fact that another soul has touched them first. LOL Thanks for everyone that took the time to post. ~ Donna On Thu, 11 Nov 2004 12:26:48 -0400, Matthew Drayer [EMAIL PROTECTED] wrote: Hi Donna, I've always felt that it's a good idea to have the proper docs to go with the version of CF that you are running. Things do change from one release to the next, and while a lot of the content does remain the same, you might miss out on something small, but important. The price for the books is pretty reasonable so, I would pick up all three of them (WAK, AWAK, and CSG). I find the study guide to be a quick and easy way to get an answer on something when you don't necessarily want to flip through the big books. I also utilize the HoF and Macromedia forums extensively (and Google). I used it more as an outline when studying for the cert. exam, drilling into the bigger books for more info when needed. Matt Matthew Drayer Web Development Coordinator HCPro, Inc. Marblehead MA [EMAIL PROTECTED] Matt PS: My co-workers joke that I have a mild case of OCD, so everything has to match...hmmm...maybe that has something to do with it. I have the CF5 Web App Kit, and have looked at the CFMX WAK but it appears to be mostly the same content as the CF5. So I've started considering the Advanced CFMX WAK or the Certification Study Guide. Can anyone recommend either, or another that would be appropriate for studying CFMX beyond the basics. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184027 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
WWOT: Internet Cafe
Anyone have a good Internet Cafe in their town? There isn't one here where I live and I've debated on opening one but I know that providing high-end computers with fast internet access is not going to be enough. Would like to hear about others out there, and if within reasonable driving area visit. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183879 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: WWOT: Internet Cafe
NE Texas On Wed, 10 Nov 2004 10:55:07 -0700, dana tierney [EMAIL PROTECTED] wrote: reasonable driving area from where? On Wed, 10 Nov 2004 11:47:40 -0600, Donna French [EMAIL PROTECTED] wrote: Anyone have a good Internet Cafe in their town? There isn't one here where I live and I've debated on opening one but I know that providing high-end computers with fast internet access is not going to be enough. Would like to hear about others out there, and if within reasonable driving area visit. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183885 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: Problem with Quotation Marks in Textarea Formfield
I'm stabbing in the dark here, but I think you need to remove from around br ??? Help from CF'ers with more experience out there??? ~ Donna On Tue, 9 Nov 2004 12:39:36 -0500, Rick Faircloth [EMAIL PROTECTED] wrote: Thanks for all the input everyone... HTMLEditFormat() is helpingbut... Before adding that code, my statement was #Replace(Application.Article.Body, #Chr(13)#, br, All)# to create paragraphs... Now with HTMLEditFormat() added, I've got: #HTMLEditFormat(Replace(Application.Article.Body, #Chr(13)#, br, All))# This code solves the quote issue, and leaves my paragraphs intact, but not I've got br showing up in the text. Does using HTMLEditFormat() make Replace() unnecessary? Or how should the code be changed? Thanks, Rick -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 11:56 AM To: CF-Talk Subject: RE: Problem with Quotation Marks in Textarea Formfield HTMLEditFormat() Pascal -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 09 November 2004 17:30 To: CF-Talk Subject: Problem with Quotation Marks in Textarea Formfield When a user puts in Quotation Marks in a Textarea formfield the text gets cut off starting with the first quote... How can I avoid this? (I search the HOF archives but didn't find anything helpful...) Thanks, Rick -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~ | Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183757 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=708.628.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.280 / Virus Database: 265.1.0 - Release Date: 11/9/2004 ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183768 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: Inexpensive Hosted Webstore?
Well, it's only the cart side of things but I use it for some customers that want to build their own pages, and sometimes build a catalog system with admin integrate with Mal's E (www.mals-e.com). HTH, Donna On Thu, 04 Nov 2004 13:25:51 -0500, Ray Champagne [EMAIL PROTECTED] wrote: I really hate them, but Yahoo! stores are probably the best free ones that I have run across. I know that sounds like an oxymoron of sorts, but considering your requirements, I would say they are one of your best choices. Ray At 01:23 PM 11/4/2004, you wrote: We have a client that wants to set up an online store to sell a handful of products. They can't spend much for software licensing, site development or a merchant account. They do already have the ability already to run credit cards at their business. Is there a decent, inexpensive means for them to get online without a merchant account? I'm not talking about something to install on their CF web site, like CF Webstore or anything similar. Something hosted elsewhere, where they get a simple email notification of new sales placed online, then they go to a secure web page and retrieve credit card information. It would need the usual capabilities of entering products, uploading product photos, adding sales taxes and computing shipping charges for a selection of shippers. Thanks. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183405 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: CFMAIL and Bulk Email Strategies
I've used the code to slow down CF email sending and it works great. ~ Donna On Thu, 04 Nov 2004 16:26:34 -0400, David K [EMAIL PROTECTED] wrote: Thanks for your (witty) reply, Matt. Makes sense. Worse still is the fact that you do not have an unlimited number of characters in your TO; field. First I've heard of that one... I.m assuming there's a similar limit on the CC BCC fields as well (?). Where might I get the definitive number on that? David K. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183421 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
Date Picker for CF?
Is there any such animal in CF that allows the user to insert a date by using a date picker of some sort instead of manually entering the date (11/5/2004)? TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183449 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: Date Picker for CF?
I found one on Macromedia CF Exchange called Date Picker - I'm cross-eyed at this point but I'm going to plug it in tomorrow and I'll post let you all know how it works out. Thanks! ~ Donna On Thu, 04 Nov 2004 22:28:30 -0800, Jordan Michaels [EMAIL PROTECTED] wrote: Wouldn't be that hard to write one. I made a similar color picker where a user would click on a choose color link and a tiny window would pop-up and let the user puck a color. That color value would then be put into the text field. I used DHTML and javascript. -Jordan Donna French wrote: Is there any such animal in CF that allows the user to insert a date by using a date picker of some sort instead of manually entering the date (11/5/2004)? TIA, Donna ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183451 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: Query Help Needed
Okay, I see what you mean but I'm not sure how to define since they are passed from selects instead of a db field? Thank you for your help, ~ Donna On Wed, 03 Nov 2004 01:59:39 +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: Donna French wrote: Should this code work if I only pass the StartDate, EndDate and Param1Val? No. cfparam name=Param2Val default=null cfparam name=Param3Val default=null cfinclude template=Connections/wdv.cfm cfquery name=rsReport datasource=#MM_wdv_DSN# username=#MM_wdv_USERNAME# password=#MM_wdv_PASSWORD# SELECT COUNT(Clients.Client_ID) as ClientCount FROM Clients WHERE Client_IntakeDate = cfqueryparam value=#Form.StartDate# cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=#Form.EndDate# cfsqltype=cf_sql_date AND #Form.Param1# = cfqueryparam value=#Form.Param1Val# null=no This will throw an error because form.param1 is undefined. AND #Form.Param2# = cfqueryparam value=#Form.Param2Val# null=yes Here both form.param2 and form.param2val are undefined. Remember that your cfparam is for param2val, not form.param2val. (CF might skip past the param2val issue though since it is essentially a constant and the compiler might recognize it as such.) AND #Form.Param3# = cfqueryparam value=#Form.Param3Val# null=yes; Same issue. /cfquery Jochem ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183274 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: Query Help Needed (Solved)
Got it working with this code: SELECT COUNT(*) as ClientCount FROM Clients WHERE Client_IntakeDate = cfqueryparam value=#Trim(Form.StartDate)# cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=#Trim(Form.EndDate)# cfsqltype=cf_sql_date AND #Trim(Form.Param1Select)# = cfqueryparam value=#Trim(Form.Param1Val)# cfif Form.Param2Select NEQ AND #Trim(Form.Param2Select)# = cfqueryparam value=#Trim(Form.Param2Val)# /cfif cfif Form.Param3Select NEQ AND #Trim(Form.Param3Select)# = cfqueryparam value=#Trim(Form.Param3Val)# /cfif ; On Wed, 3 Nov 2004 11:25:16 -0600, Donna French [EMAIL PROTECTED] wrote: Okay, I see what you mean but I'm not sure how to define since they are passed from selects instead of a db field? Thank you for your help, ~ Donna On Wed, 03 Nov 2004 01:59:39 +0100, Jochem van Dieten [EMAIL PROTECTED] wrote: Donna French wrote: Should this code work if I only pass the StartDate, EndDate and Param1Val? No. cfparam name=Param2Val default=null cfparam name=Param3Val default=null cfinclude template=Connections/wdv.cfm cfquery name=rsReport datasource=#MM_wdv_DSN# username=#MM_wdv_USERNAME# password=#MM_wdv_PASSWORD# SELECT COUNT(Clients.Client_ID) as ClientCount FROM Clients WHERE Client_IntakeDate = cfqueryparam value=#Form.StartDate# cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=#Form.EndDate# cfsqltype=cf_sql_date AND #Form.Param1# = cfqueryparam value=#Form.Param1Val# null=no This will throw an error because form.param1 is undefined. AND #Form.Param2# = cfqueryparam value=#Form.Param2Val# null=yes Here both form.param2 and form.param2val are undefined. Remember that your cfparam is for param2val, not form.param2val. (CF might skip past the param2val issue though since it is essentially a constant and the compiler might recognize it as such.) AND #Form.Param3# = cfqueryparam value=#Form.Param3Val# null=yes; Same issue. /cfquery Jochem ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183278 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
Another data type question
Okay, so I've got a SELECT menu that allows the user to choose which DB field they'd like to see results on, then a text box to allow them to enter the appropriate data for the SELECT choice. Now I'm wondering if I should add some sort of CFIF to show the appropriate SELECT for the 2nd portion instead of the text box b/c I'm having problems with it recognizing the datatype on my query to show results. Or is there a way to detect which datatype within my query - possibly CFIF datatype1 use this code, etc. Some of the SELECT drop downs are text in my db, some are checkboxes and some True/False. Any insight or feedback would be greatly appreciated. TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183308 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
SQL for Access Help Needed
I'm working on a small app using CFMX and an Access db having trouble with some SQL that I believe should work. Here's the code: SELECT * FROM Clients WHERE Client_IntakeDate BETWEEN '10/1/2004' AND '10/31/2004' It started as a much larger query but I've taken bit by bit away and this is where it seems to hang up. Am I having a brainfart or shouldn't this work? TIA, Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183153 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 for Access Help Needed
Here's the error I'm getting: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. The Error Occurred in C:\Documents and Settings\Lanes\My Documents\filelib\wdv\reportingTest.cfm: line 14 12 : /head 13 : 14 : body 15 : cfoutput query=rsReport 16 : #Client_LName#br ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183165 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 for Access Help Needed
No, it doesn't work Mike, had already tried that too. On Tue, 2 Nov 2004 13:10:07 -0500, Tangorre, Michael [EMAIL PROTECTED] wrote: SELECT * FROM Clients WHERE Client_IntakeDate BETWEEN '10/1/2004' AND '10/31/2004' WHERE Client_IntakeDate = '10/1/2004' AND Client_IntakeDate = '10/31/2004' I don't use access so I am not sure which operators are available... But give the above a shot. Mike ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183167 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 for Access Help Needed
Well, I changed the query to this: SELECT * FROM Clients WHERE Client_IntakeDate = 10/1/2004 AND Client_IntakeDate = 10/31/2004; and I'm getting an error but I'm not getting any data results either. What the ??? ~ Donna On Tue, 2 Nov 2004 12:49:56 -0600, Donna French [EMAIL PROTECTED] wrote: No, it doesn't work Mike, had already tried that too. On Tue, 2 Nov 2004 13:10:07 -0500, Tangorre, Michael [EMAIL PROTECTED] wrote: SELECT * FROM Clients WHERE Client_IntakeDate BETWEEN '10/1/2004' AND '10/31/2004' WHERE Client_IntakeDate = '10/1/2004' AND Client_IntakeDate = '10/31/2004' I don't use access so I am not sure which operators are available... But give the above a shot. Mike ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183172 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 for Access Help Needed
Thanks Ron, It's working now using the following code: SELECT * FROM Clients WHERE Client_IntakeDate = cfqueryparam value=10/1/2004 cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=10/31/2004 cfsqltype=cf_sql_date; On Tue, 2 Nov 2004 12:56:42 -0600, Donna French [EMAIL PROTECTED] wrote: Well, I changed the query to this: SELECT * FROM Clients WHERE Client_IntakeDate = 10/1/2004 AND Client_IntakeDate = 10/31/2004; and I'm getting an error but I'm not getting any data results either. What the ??? ~ Donna On Tue, 2 Nov 2004 12:49:56 -0600, Donna French [EMAIL PROTECTED] wrote: No, it doesn't work Mike, had already tried that too. On Tue, 2 Nov 2004 13:10:07 -0500, Tangorre, Michael [EMAIL PROTECTED] wrote: SELECT * FROM Clients WHERE Client_IntakeDate BETWEEN '10/1/2004' AND '10/31/2004' WHERE Client_IntakeDate = '10/1/2004' AND Client_IntakeDate = '10/31/2004' I don't use access so I am not sure which operators are available... But give the above a shot. Mike ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183176 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 for Access Help Needed SOLVED
Thanks guys - it's working SELECT * FROM Clients WHERE Client_IntakeDate = cfqueryparam value=10/1/2004 cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=10/31/2004 cfsqltype=cf_sql_date; On Tue, 2 Nov 2004 12:02:09 -0700, Ron Gowen [EMAIL PROTECTED] wrote: or you sure you datatypes in your database are actually dates? or perhaps you could try setting variables to your date values and using the create date function cfset startDate= createdate(10/1/2004) and do the same for you end date then cfset endDate= createdate(10/31/2004) WHERE Client_IntakeDate betweencfqueryparam value=#startDate# cfsqltype=cf_sql_date AND cfqueryparam value=#endDate# cfsqltype=cf_sql_date if that dont work you have a column miss named or something. On Tue, 2 Nov 2004 12:49:56 -0600, Donna French [EMAIL PROTECTED] wrote: No, it doesn't work Mike, had already tried that too. On Tue, 2 Nov 2004 13:10:07 -0500, Tangorre, Michael [EMAIL PROTECTED] wrote: SELECT * FROM Clients WHERE Client_IntakeDate BETWEEN '10/1/2004' AND '10/31/2004' WHERE Client_IntakeDate = '10/1/2004' AND Client_IntakeDate = '10/31/2004' I don't use access so I am not sure which operators are available... But give the above a shot. Mike ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183182 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 for Access Help Needed
okay, since i have you guys brains for a minute or two can i run this past you all and see if it should work... the whole query i'm working on is for a reporting tool and here's the pseudocode/cf code i've come up with so far: SELECT * FROM Clients WHERE Client_IntakeDate = cfqueryparam value=10/1/2004 cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=10/31/2004 cfsqltype=cf_sql_date, #FORM.Param1# = #FORM.Param1Val#, #FORM.Param2# = #FORM.Param2Val# cfif #FORM.Param3# GT 0 , #FORM.Param3# = #FORM.Param3Val# cfelse ; /cfif I'm still trying to figure out the best way to build the output but what I'm considering is using CFCASE/CFSWITCH to determine which field (Param1, etc.) in the db is being called, then the actual value of that field (Param1Val, etc.). The actual HTML page is online if you are thoroughly confused by my post to help you see what I'm trying to accomplish: http://www.dgfrenchdesigns.com/wdv/reportingTest.cfm THANK YOU ALL !!! ~ Donna P.S. I'll be adding CFQUERYPARAM to the query before I test it and start begging for help!!! ;-) On Tue, 2 Nov 2004 20:09:57 +0100, Pascal Peters [EMAIL PROTECTED] wrote: And cfqueryparam takes care of all that. So, once again, USE CFQUERYPARAM. ALWAYS! Pascal -Original Message- From: Dave Jones [mailto:[EMAIL PROTECTED] Sent: 02 November 2004 20:45 To: CF-Talk Subject: Re: SQL for Access Help Needed Access needs # to delimit date fields (SQL Server uses squotes) Dave Jones NetEffect ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183188 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
Data types?
I'm trying to plug in CFQUERYPARAM after the trouble earlier. I'm getting errors and not real sure which data types to specify for each - or if I should try to specify at all ? Here's my query and I'll post the actual db field types below that: SELECT COUNT(Clients.Client_ID) as ClientCount FROM Clients WHERE Client_IntakeDate = cfqueryparam value=10/1/2004 cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=10/31/2004 cfsqltype=cf_sql_date AND Client_County = cfqueryparam value=Cass cfsqltype=cf_sql_varchar AND Client_CountyOfIncident = cfqueryparam value=Bowie cfsqltype=cf_sql_varchar AND PhysicalImpact_Unknown = cfqueryparam value=True cfsqltype=cf_sql_varchar AND Client_Active = cfqueryparam value=Yes cfsqltype=cf_sql_varchar; Client_County - text Client_CountyOfIncident - text PhysicalImpact_Unknown - true/false Client_Active - yes/no (checkbox) Thanks again! -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183202 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: Data types?
cf_sql_bit works THANK YOU! just when i was about to get the sledgehammer... On Tue, 2 Nov 2004 15:48:29 -0500, Joe Rinehart [EMAIL PROTECTED] wrote: Donna, I don't use access, but I'd take a stab at cf_sql_bit for the true/false and yes/no columns. -joe On Tue, 2 Nov 2004 14:34:08 -0600, Donna French [EMAIL PROTECTED] wrote: I'm trying to plug in CFQUERYPARAM after the trouble earlier. I'm getting errors and not real sure which data types to specify for each - or if I should try to specify at all ? Here's my query and I'll post the actual db field types below that: SELECT COUNT(Clients.Client_ID) as ClientCount FROM Clients WHERE Client_IntakeDate = cfqueryparam value=10/1/2004 cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=10/31/2004 cfsqltype=cf_sql_date AND Client_County = cfqueryparam value=Cass cfsqltype=cf_sql_varchar AND Client_CountyOfIncident = cfqueryparam value=Bowie cfsqltype=cf_sql_varchar AND PhysicalImpact_Unknown = cfqueryparam value=True cfsqltype=cf_sql_varchar AND Client_Active = cfqueryparam value=Yes cfsqltype=cf_sql_varchar; Client_County - text Client_CountyOfIncident - text PhysicalImpact_Unknown - true/false Client_Active - yes/no (checkbox) Thanks again! -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183208 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
Query Help Needed
Should this code work if I only pass the StartDate, EndDate and Param1Val? cfparam name=Param2Val default=null cfparam name=Param3Val default=null cfinclude template=Connections/wdv.cfm cfquery name=rsReport datasource=#MM_wdv_DSN# username=#MM_wdv_USERNAME# password=#MM_wdv_PASSWORD# SELECT COUNT(Clients.Client_ID) as ClientCount FROM Clients WHERE Client_IntakeDate = cfqueryparam value=#Form.StartDate# cfsqltype=cf_sql_date AND Client_IntakeDate = cfqueryparam value=#Form.EndDate# cfsqltype=cf_sql_date AND #Form.Param1# = cfqueryparam value=#Form.Param1Val# null=no AND #Form.Param2# = cfqueryparam value=#Form.Param2Val# null=yes AND #Form.Param3# = cfqueryparam value=#Form.Param3Val# null=yes; /cfquery -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183211 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
testing
i haven't received any messages today so just sending a test... -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183071 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
OT: Networking
Does anyone know of a good resource online for networking? I'm having some issues and would like to try to resolve them myself. Or does anyone mind answering questions via email. Either way - please respond off list so this post doesn't drive everyone nuts. Thanks! -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182958 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 - hosting?
www.CrystalTech.com HTH, Donna On Thu, 28 Oct 2004 08:57:57 -0700, DRE [EMAIL PROTECTED] wrote: I know, its a dead horse but I've been out of the loop for a while. I did do a search but didnt find much. Does cfdynamics still have the favorable reputation that it used to? If not, any suggestions. MX sql2000 medium traffic site. Thanks. DRE -- DRE www.webmachineinc.com www.theanticool.com ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182831 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: what is it called..?
GCF - greatest common factor but i have no idea about anything in the CF dept to handle this HTH, Donna On Thu, 21 Oct 2004 16:25:57 +0100, Richard Meredith-Hardy [EMAIL PROTECTED] wrote: ...when you have a value eg 22 which is made up of 2+4+16 so you know of all your options valued 2,4,8,16,32 Etc only 2 and 4 and 16 apply. I know there must be a mathematical name for this, but what? Does anyone have some example CF code to 'decrypt' such numbers? Are there other [simple] ways to do this to handle a large number of options (25, so I don't start having giant numbers?) Something to do with prime numbers perhaps? You can tell I'm not a mathmatician can't you! THANKS! -- Regards; Richard Meredith-Hardy - r[dot]mh[at]flymicro[dot]com Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182196 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 .NET
I've taken a college course and learned the basics of VB.NET and Visual Studio, but we only worked with windows forms - no ASP.NET. So I've been going through the tutorial at W3Schools (www.w3schools.com). They also have tutorials on the .NET framework which you'll need at least a basic understanding of before diving into the others. If you find something else that works great for you let me know. I'm always looking for good tutorials b/c I learn best by example instead of reading page after page of explanation. HTH, Donna On Thu, 21 Oct 2004 12:26:55 -0400, Mickael [EMAIL PROTECTED] wrote: Hi All Sorry for being OT. But could anyone point me to a good resource to learn .NET, from the begining (hopefully skipping console apps). I am interested in Web and Windows apps. Also if anyone could share their thoughts about VB.NET and C# which to learn? Please note that I am not a formal trained programmer. Thanks Mike ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182216 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: Need help with Reporting area
Okay, I've had a day or two to think this over and talk with the client about what they need. My problem or question to all of you is whether I just need to start coding a bunch of IF/THEN statements, or if there is an easier way. Some of the db fields have several options which I've hand-coded into SELECT statements, and others are simply YES/NO. And I'll recap on what I'm trying to accomplish: I want to give the user 3 parameters they can run reports with based on the following db table: Clients -- Client_ID Client_County (Text) based on select statement when Client is added Client_Age (Number) text field Client_Adult (Yes/No) checkbox Client_Education (Text) select There are lots of fields but you get the picture. TIA, Donna On Mon, 18 Oct 2004 20:27:45 -0400, Douglas Knudsen [EMAIL PROTECTED] wrote: you can use the DB to generate dynamically either via the data dictionary if on Oracle or its equivalent in SQL Server. Heck, just use cfquery to select one row from the table and then you can use queryname.colmumnlist even. Depends on how fancy you want all this. Doug On Mon, 18 Oct 2004 16:41:51 -0500, Greg Morphis [EMAIL PROTECTED] wrote: You could build an admin page where it allows the admin to select which columns to place in there... after you run a query.. use #queryName.columnlist# to get the columns On Mon, 18 Oct 2004 16:34:34 -0500, Donna French [EMAIL PROTECTED] wrote: I have the basic idea of what I want to accomplish but I'm trying to figure out if there is an easier way to go about it (as usual). Here's the basics of the app - CFMX and Access Clients (tablename) ClientID Client_FName Client_LName Client_Address the table has various other variables that can be set to True/False - and these will be the variables I need to build the reporting around. What I've done is built a page with several elements the user can specifiy values for: StartDate EndDate Param1 Param2 Param3 Now, what I hope to accomplish is let the user indicate start and end dates (obviously), then let them use a dropdown menu to select a db field and then type a value in a text box next to it (ie: Param1 user selects Sex and enters the value as Femaile), and so on for 2 or 3 parameters. My question is can I dynamically generate the Param1, 2, 3 or do I have to hand-code all these manually? I'm guessing since I only want specific ones I'll have to hand-code but wanted to ask here first. If this made no sense I can post the actual page online for viewing. Thanks! Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182081 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
Need help with Reporting area
I have the basic idea of what I want to accomplish but I'm trying to figure out if there is an easier way to go about it (as usual). Here's the basics of the app - CFMX and Access Clients (tablename) ClientID Client_FName Client_LName Client_Address the table has various other variables that can be set to True/False - and these will be the variables I need to build the reporting around. What I've done is built a page with several elements the user can specifiy values for: StartDate EndDate Param1 Param2 Param3 Now, what I hope to accomplish is let the user indicate start and end dates (obviously), then let them use a dropdown menu to select a db field and then type a value in a text box next to it (ie: Param1 user selects Sex and enters the value as Femaile), and so on for 2 or 3 parameters. My question is can I dynamically generate the Param1, 2, 3 or do I have to hand-code all these manually? I'm guessing since I only want specific ones I'll have to hand-code but wanted to ask here first. If this made no sense I can post the actual page online for viewing. Thanks! Donna -- Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]