Re: cfgridcolumn dataalign=right
No, since dataAlign only works with Flash and Java applet grids, and headerAlign only works with applet grids. Which it says in the documentation on the tag, by the way. 2009/3/18 John M Bliss bliss.j...@gmail.com Is there a known bug with cfgrid format=html completely ignoring cfgridcolumn's headeralign=right dataalign=right? -- John Bliss IT Professional LinkedIn: http://www.linkedin.com/in/jbliss ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgridcolumn dataalign=right
Oops. Sorry. Googled it before I emailed the group but forgot to RTFM. On Wed, Mar 18, 2009 at 4:40 PM, Brian Kotek brian...@gmail.com wrote: No, since dataAlign only works with Flash and Java applet grids, and headerAlign only works with applet grids. Which it says in the documentation on the tag, by the way. 2009/3/18 John M Bliss bliss.j...@gmail.com Is there a known bug with cfgrid format=html completely ignoring cfgridcolumn's headeralign=right dataalign=right? -- John Bliss IT Professional LinkedIn: http://www.linkedin.com/in/jbliss ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: GROUP BY RIGHT()?
Not sure if you can do that, but you might want to try getting the file extension as a calculated column in the query SELECT ( RIGHT( filename, 3 ) ) AS ext Then, in the CFOutput, you could group=ext .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 11:11 AM To: CF-Talk Subject: GROUP BY RIGHT()? Hello Guys, I've got a query which returns a load of file names which I'm looking to group by their extension. Is there any way to do this dynamically from the name or do I have to make a separate column in the database? Can I do something like this: cfoutput query=myquery group=right(filename, 3) #myquery.filename# /cfoutput Thanks guys for any help, first time I've done any cf in a while, things are feeling a little rusty. Rob ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284358 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GROUP BY RIGHT()?
cfquery name=foo datasource=bar SELECT filename, right(filename, 3) AS ext, othercol FROM table ORDER BY right(filename, 3) /cfquery cfoutput query=foo group=ext that, of course, assumes you only have file extensions of 3 characters. .jpeg or .tiff would throw off the logic. I suppose you could run an instr() function inside of a CASE to determine the position of the dot if need be. On 7/23/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Hello Guys, I've got a query which returns a load of file names which I'm looking to group by their extension. Is there any way to do this dynamically from the name or do I have to make a separate column in the database? Can I do something like this: cfoutput query=myquery group=right(filename, 3) #myquery.filename# /cfoutput Thanks guys for any help, first time I've done any cf in a while, things are feeling a little rusty. Rob ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284359 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GROUP BY RIGHT()?
No, but you could select a column in your query that reads just the first 3 characters of the filename, give it a column alias, order by that column alias, and then use that in your cfoutput group attribute. Something like this (check your particular RDBMS for the Right() function or similar): select filename, right(filename, 3) as lastThreeFileName from my table order by lastThreeFileName cfoutput group=lastThreeFileName/cfoutput On 7/23/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Hello Guys, I've got a query which returns a load of file names which I'm looking to group by their extension. Is there any way to do this dynamically from the name or do I have to make a separate column in the database? Can I do something like this: cfoutput query=myquery group=right(filename, 3) #myquery.filename# /cfoutput Thanks guys for any help, first time I've done any cf in a while, things are feeling a little rusty. Rob ~| ColdFusion 8 beta - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: GROUP BY RIGHT()?
Thanks guys for the suggestion, I'll agree that the calculated column is probably my best bet, you're right Charlie about that assuming the file extension is only 3 characters, however two file extensions with the same last 3 characters isn't all that likely. Now, I'm having a little trouble with this group by: cfoutput query=VARIABLES.Messages group=type #VARIABLES.Messages.type# /cfoutput For some reason it doesn't appear to group properly, either that or I'm forgetting how to use it properly :-D That code snippet outputs like this: Gif Jpg Gif Txt Gif Vcf See how it's not grouping the gifs properly? Any ideas what I'm missing? Thanks guys, Rob -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: 23 July 2007 16:24 To: CF-Talk Subject: Re: GROUP BY RIGHT()? No, but you could select a column in your query that reads just the first 3 characters of the filename, give it a column alias, order by that column alias, and then use that in your cfoutput group attribute. Something like this (check your particular RDBMS for the Right() function or similar): select filename, right(filename, 3) as lastThreeFileName from my table order by lastThreeFileName cfoutput group=lastThreeFileName/cfoutput On 7/23/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Hello Guys, I've got a query which returns a load of file names which I'm looking to group by their extension. Is there any way to do this dynamically from the name or do I have to make a separate column in the database? Can I do something like this: cfoutput query=myquery group=right(filename, 3) #myquery.filename# /cfoutput Thanks guys for any help, first time I've done any cf in a while, things are feeling a little rusty. Rob ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: GROUP BY RIGHT()?
An ORDER BY? Adrian -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: 23 July 2007 16:45 To: CF-Talk Subject: RE: GROUP BY RIGHT()? Thanks guys for the suggestion, I'll agree that the calculated column is probably my best bet, you're right Charlie about that assuming the file extension is only 3 characters, however two file extensions with the same last 3 characters isn't all that likely. Now, I'm having a little trouble with this group by: cfoutput query=VARIABLES.Messages group=type #VARIABLES.Messages.type# /cfoutput For some reason it doesn't appear to group properly, either that or I'm forgetting how to use it properly :-D That code snippet outputs like this: Gif Jpg Gif Txt Gif Vcf See how it's not grouping the gifs properly? Any ideas what I'm missing? Thanks guys, Rob ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: GROUP BY RIGHT()?
did you ORDER BY appropriately? you need to ORDER BY the column(s) on which you're grouping. On 7/23/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Thanks guys for the suggestion, I'll agree that the calculated column is probably my best bet, you're right Charlie about that assuming the file extension is only 3 characters, however two file extensions with the same last 3 characters isn't all that likely. Now, I'm having a little trouble with this group by: cfoutput query=VARIABLES.Messages group=type #VARIABLES.Messages.type# /cfoutput For some reason it doesn't appear to group properly, either that or I'm forgetting how to use it properly :-D That code snippet outputs like this: Gif Jpg Gif Txt Gif Vcf See how it's not grouping the gifs properly? Any ideas what I'm missing? Thanks guys, Rob -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: 23 July 2007 16:24 To: CF-Talk Subject: Re: GROUP BY RIGHT()? No, but you could select a column in your query that reads just the first 3 characters of the filename, give it a column alias, order by that column alias, and then use that in your cfoutput group attribute. Something like this (check your particular RDBMS for the Right() function or similar): select filename, right(filename, 3) as lastThreeFileName from my table order by lastThreeFileName cfoutput group=lastThreeFileName/cfoutput On 7/23/07, Robert Rawlins - Think Blue [EMAIL PROTECTED] wrote: Hello Guys, I've got a query which returns a load of file names which I'm looking to group by their extension. Is there any way to do this dynamically from the name or do I have to make a separate column in the database? Can I do something like this: cfoutput query=myquery group=right(filename, 3) #myquery.filename# /cfoutput Thanks guys for any help, first time I've done any cf in a while, things are feeling a little rusty. Rob ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Trouble with RIGHT function
-Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 24, 2007 3:21 PM Subject: Trouble with RIGHT function 3, 4, 5, 6, When I do this: cfset URL.Group = REPLACE(URL.GROUPS, RIGHT(URL.GROUPS, 1),'') I get 3 4, 5, 6, Does this produce the same error: mid(url.groups, 1, Len(url.groups)-1)) Damien McKenna Web Developer The LIMU Company Making a Difference 610 Crescent Executive Court, Suite 110 Lake Mary, FL 32746 P 407.548.3800 F 407.333.0419 www.thelimucompany.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276148 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Trouble with RIGHT function
Actually that did the trick. Thanks. Does this produce the same error: mid(url.groups, 1, Len(url.groups)-1)) Damien McKenna Web Developer The LIMU Company Making a Difference 610 Crescent Executive Court, Suite 110 Lake Mary, FL 32746 P 407.548.3800 F 407.333.0419 www.thelimucompany.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276149 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Trouble with RIGHT function
The way you're using right() and replace() is incorrect. RIGHT(URL.GROUPS, 1) will return the last character in the string. In this case, a comma. Then with replace(), you're using the result of right() (the comma) and replacing the first instance (and only the first, since you didn't specify ALL in replace) within URL.GROUPS with nothing. What you intended to do is strip off the last character. You should do some checking to make sure there is in fact an extraneous comma at the end, and then do something like this: cfset URL.Group = left(URL.GROUPS,len(URL.GROUPS)-1) That will take the leftmost X characters (X being one less than the total length of the string). It's not necessarily pretty, but it accomplishes what you are trying to do. Rob -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 24, 2007 2:21 PM To: CF-Talk Subject: Trouble with RIGHT function I have a query that is getting a string for the WHERE clause from the a URL variable, and I am building the URL variable in JS on the form submit. What happens is that the JS puts a comma at the end of the string. No big deal. I figured that I would just use the RIGHT function to rebuild the string on the submitted page, stripping the comma off the end. However, it is not working. The original string looks like this: 3, 4, 5, 6, When I do this: cfset URL.Group = REPLACE(URL.GROUPS, RIGHT(URL.GROUPS, 1),'') I get 3 4, 5, 6, I am not sure why this is happening. The only thing that I can think of is that the space between the comma and number is making CF think that 3, is the end of the string. Does this sound correct? Thanks, -- Bruce Sorge I'm a mawg: half man, half dog. I'm my own best friend! ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Trouble with RIGHT function
cfset URL.Group = REPLACE(URL.GROUPS, RIGHT(URL.GROUPS, 1),'') Yeah, you don't want REPLACE there, it's doing exactly what you're telling it: replace the first comma with an empty string. You could do what Damien suggested or also Left(url.groups, len(url.groups)-1) -- Josh ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Trouble with RIGHT function
cfset URL.Group = REPLACE(URL.GROUPS, RIGHT(URL.GROUPS, 1),'') Bruce- Looks like that code's telling CF to replace the first occurrence of right(url.groups,1), which is a comma. So your results are that the first comma in your string is being replaced. I suspect what you actually want is to use left() Something along these lines should do the trick: myVar = left(trim(myVar), len(trim(myVar))-1) -Cameron On 4/24/07, Bruce Sorge [EMAIL PROTECTED] wrote: I have a query that is getting a string for the WHERE clause from the a URL variable, and I am building the URL variable in JS on the form submit. What happens is that the JS puts a comma at the end of the string. No big deal. I figured that I would just use the RIGHT function to rebuild the string on the submitted page, stripping the comma off the end. However, it is not working. The original string looks like this: 3, 4, 5, 6, When I do this: cfset URL.Group = REPLACE(URL.GROUPS, RIGHT(URL.GROUPS, 1),'') I get 3 4, 5, 6, I am not sure why this is happening. The only thing that I can think of is that the space between the comma and number is making CF think that 3, is the end of the string. Does this sound correct? Thanks, -- Bruce Sorge I'm a mawg: half man, half dog. I'm my own best friend! ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: Javascript right click menu, only over object, can accept parameters
jsdomenu from dynamic drive does that, I think. It's pretty cool, but leaks memory, I think. One option is to use hidden fields and mouseovers to have dynamic variables. Let me know if you want more info, I've done something similar. :D On 6/2/06, Andy Matthews [EMAIL PROTECTED] wrote: I've spent all morning looking for this sort of thing. I've found a few possible candidates but nothing that matches, so I'm going to ask around. I'm looking a right click context menu script which will allow me to indicate which objects on the page trigger the script AND allow me to pass parameters to the script so that each link on the menu does something different. Example Andy (id=34,wife=jaime) Shawn (id=32,wife=leslie) The menu would be the same, but when I right click on Andy, then select go to andy's page, the link would take me to the page indicated by the id parameter. The same for if I clicked the what's his wife's name link, which would fire off an alert box displaying the word jaime. Does anyone have something like this? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242176 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: LEFT AND RIGHT OUTER JOIN?
Hmm that is nasty One solution would be to do a union of three selects, one selecting just the case of being in both tables, the next for those records in table 1 only, the last for those records in table 2 only. Kinda lame, but better than nothing. Mark -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 2:24 PM To: CF-Talk Subject: LEFT AND RIGHT OUTER JOIN? I think I have solidly walked into the realm of why are you trying to do this? So any suggestions on alternate ways to look at this problem are welcome. Say I have two tables something like these: TABLE ONE Loc_CD Loc_Name ABC This DEF That DFE The Other TABLE TWO Loc_CD A_Number DEF 123 ALT 456 I need a combined table that would look like this. Loc_CD Loc_NameA_Number ABC This DEF That123 DFE The Other ALT 456 Please presume I did not create the base table and have little control over their structure and data. But I need to somehow derive the combined table. How would one do this, is there such a thing as a double/leftright join? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:217134 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: LEFT AND RIGHT OUTER JOIN?
Hmm that is nasty One solution would be to do a union of three selects, one selecting just the case of being in both tables, the next for those records in table 1 only, the last for those records in table 2 only. Kinda lame, but better than nothing. Mark Actually one doesn't need the first select in the union. Just found a nice page talking about Oracle unions and it showed an example of just this problem. query left join UNION Right join /query Should work. Now I just wish that Oracle 8i understood ANSI left join on syntax. Oh well, someday we will be upgraded to 9i, really they keep say so. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:217138 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: LEFT AND RIGHT OUTER JOIN?
Ugly on so many levels but this may work... SELECT t1.Loc_CD, t1.Loc_Name, t2.A_Number FROM t1 left Join t2 on t1.Loc_CD=t2.Loc_CD UNION SELECT t2.loc_CD, null AS Loc_Name, t2.A_Number FROM t2 WHERE t2.loc_CD NOT IN (SELECT DISTINCT Loc_CD FROM t1) On 9/1/05, Gaulin, Mark [EMAIL PROTECTED] wrote: Hmm that is nasty One solution would be to do a union of three selects, one selecting just the case of being in both tables, the next for those records in table 1 only, the last for those records in table 2 only. Kinda lame, but better than nothing. Mark -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 2:24 PM To: CF-Talk Subject: LEFT AND RIGHT OUTER JOIN? I think I have solidly walked into the realm of why are you trying to do this? So any suggestions on alternate ways to look at this problem are welcome. Say I have two tables something like these: TABLE ONE Loc_CD Loc_Name ABC This DEF That DFE The Other TABLE TWO Loc_CD A_Number DEF 123 ALT 456 I need a combined table that would look like this. Loc_CD Loc_NameA_Number ABC This DEF That123 DFE The Other ALT 456 Please presume I did not create the base table and have little control over their structure and data. But I need to somehow derive the combined table. How would one do this, is there such a thing as a double/leftright join? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:217142 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: LEFT AND RIGHT OUTER JOIN?
select a.loc_cd, b.a_number, a.loc_name from loc a left join loc2 b on a.loc_cd = b. loc_cd UNION select c.loc_cd, c.a_number, d.loc_name from loc2 c left join loc d on c.loc_cd = d.loc_cd Gaulin, Mark wrote: Hmm that is nasty One solution would be to do a union of three selects, one selecting just the case of being in both tables, the next for those records in table 1 only, the last for those records in table 2 only. Kinda lame, but better than nothing. Mark -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 2:24 PM To: CF-Talk Subject: LEFT AND RIGHT OUTER JOIN? I think I have solidly walked into the realm of why are you trying to do this? So any suggestions on alternate ways to look at this problem are welcome. Say I have two tables something like these: TABLE ONE Loc_CD Loc_Name ABCThis DEFThat DFEThe Other TABLE TWO Loc_CD A_Number DEF123 ALT456 I need a combined table that would look like this. Loc_CD Loc_NameA_Number ABCThis DEFThat123 DFEThe Other ALT456 Please presume I did not create the base table and have little control over their structure and data. But I need to somehow derive the combined table. How would one do this, is there such a thing as a double/leftright join? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:217145 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: LEFT AND RIGHT OUTER JOIN?
This is a classic full outer join, as far as I can tell. Using Sql2000: Select TableOne.Loc_CD as T1LocCD, TableOne.Loc_Name, TableTwo.A_Number, TableTwo.Loc_CD as T2LocCD From TableOne FULL OUTER JOIN TableTwo On TableOne.Loc_CD = TableTwo.LocCD If it's absolutely necessary to get TableOne.Loc_CD and TableTwo.Loc_CD into the same column, use a union as such *not tested*: Select TableOne.Loc_CD as LocCD, TableOne.Loc_Name, TableTwo.A_Number, TableTwo.Loc_CD as T2LocCD From TableOne Left OUTER JOIN TableTwo On TableOne.Loc_CD = TableTwo.LocCD Union Select TableTwo.Loc_CD as T1LocCD, TableOne.Loc_Name, TableTwo.A_Number, TableTwo.Loc_CD as T2LocCD From TableTwo FULL OUTER JOIN TableOne On TableTwo.Loc_CD = TableOne.LocCD Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 2:24 PM To: CF-Talk Subject: LEFT AND RIGHT OUTER JOIN? I think I have solidly walked into the realm of why are you trying to do this? So any suggestions on alternate ways to look at this problem are welcome. Say I have two tables something like these: TABLE ONE Loc_CD Loc_Name ABC This DEF That DFE The Other TABLE TWO Loc_CD A_Number DEF 123 ALT 456 I need a combined table that would look like this. Loc_CD Loc_NameA_Number ABC This DEF That123 DFE The Other ALT 456 Please presume I did not create the base table and have little control over their structure and data. But I need to somehow derive the combined table. How would one do this, is there such a thing as a double/leftright join? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:217157 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: Finding the right FORM field...
Just use this instead: form[selproject issueid] example: where Project_Nm = #form[selproject issueid]# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Finding the right FORM field...
From: Morgan Senkal cfloop index=issueID list=FORM.idListA cfloop index=issueID list=#FORM.idListA# #StructFind(FORM,Evaluate(SELPROJECT issueID))# #form[SELFPROJECT#issueID#]# Also CFQUERYPARAM!!! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Finding the right FORM field...
Maybe like this (if form.idListA contains a list of numbers) cfloop index=issueID list=#FORM.idListA# cfquery datasource=Tribal_Matrix name=getProject SELECT * FROM v_Project WHERE Project_Nm = #FORM[SELPROJECT issueID]# /cfquery /cfloop If form.idListA contains the maximum maybe it should be: cfloop index=issueID from=1 to=#FORM.idListA# cfquery datasource=Tribal_Matrix name=getProject SELECT * FROM v_Project WHERE Project_Nm = #FORM[SELPROJECT issueID]# /cfquery /cfloop -Original Message- From: Morgan Senkal [mailto:[EMAIL PROTECTED] Sent: dinsdag 25 mei 2004 19:38 To: CF-Talk Subject: Finding the right FORM field... How is this: Evaluate(SELPROJECT issueID) (issueID is a variable) Equal to this?: Error resolving parameter SELPROJECTFORM.IDLISTA Here is the whole code: cfloop index=issueID list=FORM.idListA cfquery datasource=Tribal_Matrix name=getProject SELECT * FROM v_Project WHERE Project_Nm = #StructFind(FORM,Evaluate(SELPROJECT issueID))# /cfquery /cfloop Basically I'm looping thru a list of numbers.All the FORM fields have established names with one of these numbers at the end, I'd like to loop thru those field names in groups based on the number at the end. So the one in question above would look like FORM[SELPROJECT45] Perhaps I need an explanation of how Evaluate() works...and variables in loops too.Thanks for any help! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Finding the right FORM field...
WHERE Project_Nm = #StructFind(FORM,Evaluate(SELPROJECT issueID))# WHERE Project_Nm = #FORM[SELPROJECT issueID]# Try that.Should work better.Or should tell you issueID contains the wrong data. --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Finding the right FORM field...
Simple, change this: cfloop index=issueID list=FORM.idListA to: cfloop index=issueID list=#FORM.idListA# You just need to identify the list coming from a variable - otherwise it's reading (FORM.idListA) as the actual listing. HTH -Original Message- From: Morgan Senkal [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 1:38 PM To: CF-Talk Subject: Finding the right FORM field... How is this: Evaluate(SELPROJECT issueID) (issueID is a variable) Equal to this?: Error resolving parameter SELPROJECTFORM.IDLISTA Here is the whole code: cfloop index=issueID list=FORM.idListA cfquery datasource=Tribal_Matrix name=getProject SELECT * FROM v_Project WHERE Project_Nm = #StructFind(FORM,Evaluate(SELPROJECT issueID))# /cfquery /cfloop Basically I'm looping thru a list of numbers.All the FORM fields have established names with one of these numbers at the end, I'd like to loop thru those field names in groups based on the number at the end. So the one in question above would look like FORM[SELPROJECT45] Perhaps I need an explanation of how Evaluate() works...and variables in loops too.Thanks for any help! _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Finding the right FORM field...
Thanks so much everyone! The solution was a combination of the suggestions offered: Yes, I had to change the #StructFind(FORM,Evaluate(SELPROJECT issueID))# to the suggested #FORM[SELPROJECT issueID]# The problem with that however, is that's where I had started but it didn't work.So that's when I headed down the evaluate path.But if I returned to my original code and also changed cfloop index=issueID list=FORM.idListA to cfloop index=issueID list=#FORM.idListA# Then presto, the whole shebang fires off like a dream :-) You guys rock! I knew it would be something simple.It always is :P [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF MX *right* book.
People, thanks a lot to you for opinions about MX book! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CF MX *right* book.
We are kinda biased to Ben Forta et al's books - they've sold truckloads - but many other fine authors are out there too. I'm looking for a 6.1 looking title myself. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: CF MX *right* book.
We are kinda biased to Ben Forta et al's books - they've sold truckloads - but many other fine authors are out there too. I'm looking for a 6.1 looking title myself. http://www.oreilly.com/catalog/coldfusion2/ Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CF MX *right* book.
uncle bens advanced macromedia cfmx app dev. is always a nice read! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Alexandr Timchur [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:31 AM To: CF-Talk Subject: CF MX *right* book. Hi All, Can you recommend me a right book discovering new features of ColdFusion MX, especially CFC, without long speech about SQL Coldfusion basics? Thank you! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: RE: CF MX *right* book.
Rob Brooks-Bilson has a book published by O'Reilley which has content for 6.1 release of CFMX. It is called Programming ColdFusion MX, 2nd Edition and you can find details here in our blog. http://www.webapper.net/index.cfm?fuseaction=Fuseblog.ShowCommentsArticleID=20030818084646 Hth Kind Regards - Mike Brunt Original Message --- uncle bens advanced macromedia cfmx app dev. is always a nice read! tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Alexandr Timchur [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 11:31 AM To: CF-Talk Subject: CF MX *right* book. Hi All, Can you recommend me a right book discovering new features of ColdFusion MX, especially CFC, without long speech about SQL Coldfusion basics? Thank you! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: CF MX *right* book.
Alex: You're going to get a slew of different answers here, so by the time everybody chimes in, just about every mx book will have been mentioned :) but i'll throw in a ringing endorsement for the MX Bible by Churvis, Churvis, Arehart, and Helms. charlie - Original Message - From: Alexandr Timchur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 12, 2003 8:30 AM Subject: CF MX *right* book. Hi All, Can you recommend me a right book discovering new features of ColdFusion MX, especially CFC, without long speech about SQL Coldfusion basics? Thank you! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: CF MX *right* book.
I have been very pleased with Mastering ColdFusion MX' by 'Danesh, Camden, Bainum and Rish' published by Sybex. It's a mighty heavy book to lug around... but for a 'keep it nearby complete reference', it can't be beat. The examples are clear and simple... and the book is very well edited. -- Jillian - Original Message - From: Alexandr Timchur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 12, 2003 8:30 AM Subject: CF MX *right* book. Hi All, Can you recommend me a right book discovering new features of ColdFusion MX, especially CFC, without long speech about SQL Coldfusion basics? Thank you! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: CF MX *right* book.
Buy them all, you know you want to. Really though, we bought several that on the face would cover the same material. But when you actually peruse them, they each have different strengths. But I agree that many of them cover material that is often unneeded. To the authors: I'd love separate, focused books instead of the monster tome. The Hal Helms book on CFCs is a great example. It's small but dense with information. Now if I could just buy books like that on CF/SQL interaction, cfscript, cf design frameworks, blah blah. And I've seen authors here complain about not being able to get everything in. I know some of them exist, but they seem the exception rather than the norm. Other developers I've talked to would love a light and tight set of books. -Kevin - Original Message - From: Alexandr Timchur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:30 AM Subject: CF MX *right* book. Hi All, Can you recommend me a right book discovering new features of ColdFusion MX, especially CFC, without long speech about SQL Coldfusion basics? Thank you! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: CF MX *right* book.
Thanks for the kind words. I agree with you about having small, well-focused books but the big publishers (and a depressingly large number of developers) seem to judge books on a dollar per pound basis. That causes authors to HAVE to fluff up the books to hit a minimum contractual page count. Hal Helms See halhelms.com for classes in... Java for ColdFusion Programmers Fusebox 4 Mach-II OO Applications with CFCs -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 3:28 PM To: CF-Talk Subject: Re: CF MX *right* book. Buy them all, you know you want to. Really though, we bought several that on the face would cover the same material. But when you actually peruse them, they each have different strengths. But I agree that many of them cover material that is often unneeded. To the authors: I'd love separate, focused books instead of the monster tome. The Hal Helms book on CFCs is a great example. It's small but dense with information. Now if I could just buy books like that on CF/SQL interaction, cfscript, cf design frameworks, blah blah. And I've seen authors here complain about not being able to get everything in. I know some of them exist, but they seem the exception rather than the norm. Other developers I've talked to would love a light and tight set of books. -Kevin - Original Message - From: Alexandr Timchur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:30 AM Subject: CF MX *right* book. Hi All, Can you recommend me a right book discovering new features of ColdFusion MX, especially CFC, without long speech about SQL Coldfusion basics? Thank you! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: CF MX *right* book.
If one can develop a well-focused book I would be more than willing to donate some money to help the author self-publish. -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 5:11 PM To: CF-Talk Subject: RE: CF MX *right* book. Thanks for the kind words. I agree with you about having small, well-focused books but the big publishers (and a depressingly large number of developers) seem to judge books on a dollar per pound basis. That causes authors to HAVE to fluff up the books to hit a minimum contractual page count. Hal Helms See halhelms.com for classes in... Java for ColdFusion Programmers Fusebox 4 Mach-II OO Applications with CFCs ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
Re: CF MX *right* book.
Heh, I have an excellent example of that - Inside XML from New Riders. The thing is nearly the size of the OED, and is hilariously padded. For instance, there's an entire section of the book devoted to programming Javascript - and not just parsing XML, either, I mean like This is a function; this is how you instantiate variables. The same for Java. Not just XML parsing, but an introduction to the language. All the examples are printed over and over again - completely, with new lines added for each step in the example. If the author was paid by the word, he's likely bought an island fortress by this point. That said, it's a very comprehensive book, and I learned a lot about writing schemas and using fun stuff like XPath (which doesn't work right in MX - rr). It is, however, freakishly huge, and really puts off an aura of geeky competence when someone sees it on your bookshelf. Ooooh, that's a LOT of XML - you must be an expert! - Jim Hal Helms wrote: Thanks for the kind words. I agree with you about having small, well-focused books but the big publishers (and a depressingly large number of developers) seem to judge books on a dollar per pound basis. That causes authors to HAVE to fluff up the books to hit a minimum contractual page count. Hal Helms See halhelms.com for classes in... Java for ColdFusion Programmers Fusebox 4 Mach-II OO Applications with CFCs -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 3:28 PM To: CF-Talk Subject: Re: CF MX *right* book. Buy them all, you know you want to. Really though, we bought several that on the face would cover the same material. But when you actually peruse them, they each have different strengths. But I agree that many of them cover material that is often unneeded. To the authors: I'd love separate, focused books instead of the monster tome. The Hal Helms book on CFCs is a great example. It's small but dense with information. Now if I could just buy books like that on CF/SQL interaction, cfscript, cf design frameworks, blah blah. And I've seen authors here complain about not being able to get everything in. I know some of them exist, but they seem the exception rather than the norm. Other developers I've talked to would love a light and tight set of books. -Kevin - Original Message - From: Alexandr Timchur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:30 AM Subject: CF MX *right* book. Hi All, Can you recommend me a right book discovering new features of ColdFusion MX, especially CFC, without long speech about SQL Coldfusion basics? Thank you! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
Re: CF MX *right* book.
The Reality books fall into this category - FlashMX integration, J2EE integration, etc. - Jim Bryan F. Hogan wrote: If one can develop a well-focused book I would be more than willing to donate some money to help the author self-publish. -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 5:11 PM To: CF-Talk Subject: RE: CF MX *right* book. Thanks for the kind words. I agree with you about having small, well-focused books but the big publishers (and a depressingly large number of developers) seem to judge books on a dollar per pound basis. That causes authors to HAVE to fluff up the books to hit a minimum contractual page count. Hal Helms See halhelms.com for classes in... Java for ColdFusion Programmers Fusebox 4 Mach-II OO Applications with CFCs ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: CF MX *right* book.
Not technical enough for me. -Original Message- From: Jim Campbell [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 5:17 PM To: CF-Talk Subject: Re: CF MX *right* book. The Reality books fall into this category - FlashMX integration, J2EE integration, etc. - Jim Bryan F. Hogan wrote: If one can develop a well-focused book I would be more than willing to donate some money to help the author self-publish. -Original Message- From: Hal Helms [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 5:11 PM To: CF-Talk Subject: RE: CF MX *right* book. Thanks for the kind words. I agree with you about having small, well-focused books but the big publishers (and a depressingly large number of developers) seem to judge books on a dollar per pound basis. That causes authors to HAVE to fluff up the books to hit a minimum contractual page count. Hal Helms See halhelms.com for classes in... Java for ColdFusion Programmers Fusebox 4 Mach-II OO Applications with CFCs ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Re: CF MX *right* book.
I'm starting to buy less and less large books, in fact. I've almost made it a mission to avoid the big ones. I've got Hal Helm's CFC book, and that's just about right for size and content. Dreamweaver MX Extensions, fairly focused and concise. UML Distilled, also focused. Javascript Cookbook from O'Reilly also really exactly what I need. I'm not forking over 50+ dollars for a book that contains material that doesn't belong, it's simply not worth it, my money is better spent elsewhere. As a general rule, I now consider the larger tomes, lesser works. - Calvin - Original Message - From: Hal Helms [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 12, 2003 5:10 PM Subject: RE: CF MX *right* book. Thanks for the kind words. I agree with you about having small, well-focused books but the big publishers (and a depressingly large number of developers) seem to judge books on a dollar per pound basis. That causes authors to HAVE to fluff up the books to hit a minimum contractual page count. Hal Helms See halhelms.com for classes in... Java for ColdFusion Programmers Fusebox 4 Mach-II OO Applications with CFCs -Original Message- From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 3:28 PM To: CF-Talk Subject: Re: CF MX *right* book. Buy them all, you know you want to. Really though, we bought several that on the face would cover the same material. But when you actually peruse them, they each have different strengths. But I agree that many of them cover material that is often unneeded. To the authors: I'd love separate, focused books instead of the monster tome. The Hal Helms book on CFCs is a great example. It's small but dense with information. Now if I could just buy books like that on CF/SQL interaction, cfscript, cf design frameworks, blah blah. And I've seen authors here complain about not being able to get everything in. I know some of them exist, but they seem the exception rather than the norm. Other developers I've talked to would love a light and tight set of books. -Kevin - Original Message - From: Alexandr Timchur [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 12, 2003 10:30 AM Subject: CF MX *right* book. Hi All, Can you recommend me a right book discovering new features of ColdFusion MX, especially CFC, without long speech about SQL Coldfusion basics? Thank you! Alex Timchur ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: String data right truncation
One of the fields you are trying to insert is longer (or a different type) than the db field it is trying to insert into... Neil Can someone please tell me what the error below means? It comes after I submit a form. ODBC Error Code = 22001 (String data right truncation)PP [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hardware Disable Right-Click
You could experiment with the Kiosk mode in Opera, you may be able to lock down actions like that at the browser level while also restricting the terminal to only using that particular application. If you're using a Mac I believe that the iCab browser sports a Kiosk mode as well. Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 * Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 10:01 PM To: CF-Talk Subject: Re: Hardware Disable Right-Click Just put the JavaScript into application.cfm ;-) -Novak - Original Message - From: Matthew Small [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 26, 2003 10:18 AM Subject: OT: Hardware Disable Right-Click Sorry for the OT, but I was wondering if it's possible to hardware disable right-click on the mouse. I'm about to set up some kiosks with a mouse and I don't want them to be able to right-click. I know how to do this in javascript, I just think there's got to be an easier way that to put that script into every webpage I've got. Thank you, Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hardware Disable Right-Click
How about take apart the mouse and break the switch under the right button? -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 1:18 PM To: CF-Talk Subject: OT: Hardware Disable Right-Click Sorry for the OT, but I was wondering if it's possible to hardware disable right-click on the mouse. I'm about to set up some kiosks with a mouse and I don't want them to be able to right-click. I know how to do this in javascript, I just think there's got to be an easier way that to put that script into every webpage I've got. Thank you, Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hardware Disable Right-Click
deploy on macintosh hardware. -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 1:17 PM To: CF-Talk Subject: OT: Hardware Disable Right-Click Sorry for the OT, but I was wondering if it's possible to hardware disable right-click on the mouse. I'm about to set up some kiosks with a mouse and I don't want them to be able to right-click. I know how to do this in javascript, I just think there's got to be an easier way that to put that script into every webpage I've got. Thank you, Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hardware Disable Right-Click
custom built trackball with left button only capability? touch screen interface, no mouse required, since it is a kiosk. will - Original Message - From: DURETTE, STEVEN J (AIT) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 26, 2003 10:18 AM Subject: RE: Hardware Disable Right-Click How about take apart the mouse and break the switch under the right button? -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 1:18 PM To: CF-Talk Subject: OT: Hardware Disable Right-Click Sorry for the OT, but I was wondering if it's possible to hardware disable right-click on the mouse. I'm about to set up some kiosks with a mouse and I don't want them to be able to right-click. I know how to do this in javascript, I just think there's got to be an easier way that to put that script into every webpage I've got. Thank you, Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hardware Disable Right-Click
That's a great idea. Thanks. Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 1:18 PM To: CF-Talk Subject: RE: Hardware Disable Right-Click How about take apart the mouse and break the switch under the right button? -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 1:18 PM To: CF-Talk Subject: OT: Hardware Disable Right-Click Sorry for the OT, but I was wondering if it's possible to hardware disable right-click on the mouse. I'm about to set up some kiosks with a mouse and I don't want them to be able to right-click. I know how to do this in javascript, I just think there's got to be an easier way that to put that script into every webpage I've got. Thank you, Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Hardware Disable Right-Click
Watch out for the windows keys too... Dunno if they get disabled... Stuff like window key - d, ctrl-esc... And the stupid key next to the window key that we all wonder what exactly it does... That's also a right-click... Are there special Kiosk keyboards that are missing all the function keys? -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 11:34 AM To: CF-Talk Subject: RE: Hardware Disable Right-Click That's a great idea. Thanks. Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 -Original Message- From: DURETTE, STEVEN J (AIT) [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 1:18 PM To: CF-Talk Subject: RE: Hardware Disable Right-Click How about take apart the mouse and break the switch under the right button? -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 1:18 PM To: CF-Talk Subject: OT: Hardware Disable Right-Click Sorry for the OT, but I was wondering if it's possible to hardware disable right-click on the mouse. I'm about to set up some kiosks with a mouse and I don't want them to be able to right-click. I know how to do this in javascript, I just think there's got to be an easier way that to put that script into every webpage I've got. Thank you, Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hardware Disable Right-Click
Just put the JavaScript into application.cfm ;-) -Novak - Original Message - From: Matthew Small [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 26, 2003 10:18 AM Subject: OT: Hardware Disable Right-Click Sorry for the OT, but I was wondering if it's possible to hardware disable right-click on the mouse. I'm about to set up some kiosks with a mouse and I don't want them to be able to right-click. I know how to do this in javascript, I just think there's got to be an easier way that to put that script into every webpage I've got. Thank you, Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFILE READ right after UPLOAD not working
What is the value of: #request.ImagePath# Things to check, does it have a trailing slash? Pablo Varando http://www.cfpablo.com http://www.easycfm.com - Original Message - From: Matt Robertson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 26, 2002 5:16 PM Subject: CFFILE READ right after UPLOAD not working This code doesn't work: CFFILE ACTION=Upload FILEFIELD=FileContents DESTINATION=#request.ImagePath# NAMECONFLICT=MAKEUNIQUE ACCEPT=text/plain CFFILE ACTION=READ FILE=#request.ImagePath##file.ServerFile# VARIABLE=ImportTxt Returns a file not found. But its fine (I checked). Thinking I was maybe trying to read the file before the O/S was done writing it, I inserted this loop between the two and sure enough, the code works now. CFSET variables.mycounter=0 CFLOOP INDEX=Num1 FROM=1 TO=1000 CFSET variables.mycounter=variables.mycounter+1 /CFLOOP There's got to be a better way. Anyone have any ideas? --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFILE READ right after UPLOAD not working
All that stuff is perfect. I ran thru that when I was debugging. As I mentioned at the tail end of the message, simply inserting a time delay into the code fixed the problem and it works fine. Like the upload thread hadn't finished before the read thread started. waitasec... hmmm. I'll bet a cflock to single-thread the process would do the trick. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: Pablo Varando [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] date: Mon, 26 Aug 2002 17:18:51 -0700 What is the value of: #request.ImagePath# Things to check, does it have a trailing slash? Pablo Varando http://www.cfpablo.com http://www.easycfm.com - Original Message - From: Matt Robertson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, August 26, 2002 5:16 PM Subject: CFFILE READ right after UPLOAD not working This code doesn't work: CFFILE ACTION=Upload FILEFIELD=FileContents DESTINATION=#request.ImagePath# NAMECONFLICT=MAKEUNIQUE ACCEPT=text/plain CFFILE ACTION=READ FILE=#request.ImagePath##file.ServerFile# VARIABLE=ImportTxt Returns a file not found. But its fine (I checked). Thinking I was maybe trying to read the file before the O/S was done writing it, I inserted this loop between the two and sure enough, the code works now. CFSET variables.mycounter=0 CFLOOP INDEX=Num1 FROM=1 TO=1000 CFSET variables.mycounter=variables.mycounter+1 /CFLOOP There's got to be a better way. Anyone have any ideas? --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFILE READ right after UPLOAD *solved*
That was it. Surrounding the two cffiles with a cflock single-threaded the process and kept one operation from overrunning the other. CFLOCK name=#CreateUUID()# type=EXCLUSIVE timeout=10 cffile blah blah blah... cffile blah blah blah... /CFLOCK __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this right?
quot; -Original Message- From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 11:59 AM To: CF-Talk Subject: Is this right? Hi, How do i insert one '' into a html file. Should be I using some ASCII value for that.If so can any one tell me the ascii value of that Any help on this is apprecited!!! Sudheer Chakka __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Building the right tables and pages?
Hmmmsounds like you need to be introduced the the application.cfm file and session variables. I have some files that might help...contact me off list. Kevin - Original Message - From: "Jeremy Toevs" [EMAIL PROTECTED] To: "" [EMAIL PROTECTED] Sent: Thursday, August 10, 2000 10:16 AM Subject: Building the right tables and pages? Hello, I am currently trying to build a web site using CFM where people can log-on with a username and password into the site and see information that is meant for only them. Basically what the people at Onvia.com have running on your site. On their web site, you enter your email address and password then you are logged in. The page says "Welcome back Jeremy Toevs" and also displays a logout button. All the information that I am set up for is displayed for me. I want to run a site where parents login and can view their kids grades and what not and no other kids grades. I need someones help. I know a little bit about CFM. But not as much as you guys do. I was wondering if you someone could fill me in on how I can set something up similar to what they have running on Onvia.com. I just can't get the tables right and things like that. I notice that when I log on to thier site the page URL is: https://www.onvia.com/usa/my/index.cfm? task=login. The part ...?task=login confuses me. How does it know that it is me logged in. The only way I know how to do it is. ...? loginname=jeremypassword=834kds. I am confused on the pages I need, the coding I need and the tables I need. Basically, I am clueless at this point in my CF writing. What would really help is if someone could set up a few pages: a login page, the page viewed after the login page, and then a page after that. And also an Access Database with the proper tables and email it to me. And I would be able to figure out the rest from their. If you someone could help me out, I would greatly appreciate it. You can contact me @ (503) 570-3157 or e-mail @ [EMAIL PROTECTED] Please lend me a hand. I am building this site to help parents be more involved with their kids school life. It is really important to me. Sorry for the long message. But thank for your time, Jeremy Toevs Office: (503) 570-3157 Fax:(503) 570-5079 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Building the right tables and pages?
Thank you for helping me out with this. I appreciate any help I can get, but like I said, I'm not an expert. So what is this application.cfm and session variables? Jeremy "Kevin Schmidt" [EMAIL PROTECTED] 08/10/00 09:53AM Hmmmsounds like you need to be introduced the the application.cfm file and session variables. I have some files that might help...contact me off list. Kevin - Original Message - From: "Jeremy Toevs" [EMAIL PROTECTED] To: "" [EMAIL PROTECTED] Sent: Thursday, August 10, 2000 10:16 AM Subject: Building the right tables and pages? Hello, I am currently trying to build a web site using CFM where people can log-on with a username and password into the site and see information that is meant for only them. Basically what the people at Onvia.com have running on your site. On their web site, you enter your email address and password then you are logged in. The page says "Welcome back Jeremy Toevs" and also displays a logout button. All the information that I am set up for is displayed for me. I want to run a site where parents login and can view their kids grades and what not and no other kids grades. I need someones help. I know a little bit about CFM. But not as much as you guys do. I was wondering if you someone could fill me in on how I can set something up similar to what they have running on Onvia.com. I just can't get the tables right and things like that. I notice that when I log on to thier site the page URL is: https://www.onvia.com/usa/my/index.cfm? task=login. The part ...?task=login confuses me. How does it know that it is me logged in. The only way I know how to do it is. ...? loginname=jeremypassword=834kds. I am confused on the pages I need, the coding I need and the tables I need. Basically, I am clueless at this point in my CF writing. What would really help is if someone could set up a few pages: a login page, the page viewed after the login page, and then a page after that. And also an Access Database with the proper tables and email it to me. And I would be able to figure out the rest from their. If you someone could help me out, I would greatly appreciate it. You can contact me @ (503) 570-3157 or e-mail @ [EMAIL PROTECTED] Please lend me a hand. I am building this site to help parents be more involved with their kids school life. It is really important to me. Sorry for the long message. But thank for your time, Jeremy Toevs Office: (503) 570-3157 Fax:(503) 570-5079 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Building the right tables and pages?
Take a look over at http://www.cftutorials.com/ for a tutorial on one method of building a login system. that should get you started down the path to success. - Original Message - From: Jeremy Toevs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 10, 2000 11:16 AM Subject: Building the right tables and pages? Hello, I am currently trying to build a web site using CFM where people can log-on with a username and password into the site and see information that is meant for only them. Basically what the people at Onvia.com have running on your site. On their web site, you enter your email address and password then you are logged in. The page says "Welcome back Jeremy Toevs" and also displays a logout button. All the information that I am set up for is displayed for me. I want to run a site where parents login and can view their kids grades and what not and no other kids grades. I need someones help. I know a little bit about CFM. But not as much as you guys do. I was wondering if you someone could fill me in on how I can set something up similar to what they have running on Onvia.com. I just can't get the tables right and things like that. I notice that when I log on to thier site the page URL is: https://www.onvia.com/usa/my/index.cfm? task=login. The part ...?task=login confuses me. How does it know that it is me logged in. The only way I know how to do it is. ...? loginname=jeremypassword=834kds. I am confused on the pages I need, the coding I need and the tables I need. Basically, I am clueless at this point in my CF writing. What would really help is if someone could set up a few pages: a login page, the page viewed after the login page, and then a page after that. And also an Access Database with the proper tables and email it to me. And I would be able to figure out the rest from their. If you someone could help me out, I would greatly appreciate it. You can contact me @ (503) 570-3157 or e-mail @ [EMAIL PROTECTED] Please lend me a hand. I am building this site to help parents be more involved with their kids school life. It is really important to me. Sorry for the long message. But thank for your time, Jeremy Toevs Office: (503) 570-3157 Fax:(503) 570-5079 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Building the right tables and pages?
This is a multi-part message in MIME format. --=_NextPart_000_0003_01C002B3.AA8B20A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Jeremy: Here is a zipped package (its an open source deal from somewhere I don't remember) that will get you started. Read everything and play with it, you should be able to figure it out pretty quick. Matt -Original Message- From: Jeremy Toevs [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 10, 2000 9:16 AM To: Subject: Building the right tables and pages? Hello, I am currently trying to build a web site using CFM where people can log-on with a username and password into the site and see information that is meant for only them. Basically what the people at Onvia.com have running on your site. On their web site, you enter your email address and password then you are logged in. The page says "Welcome back Jeremy Toevs" and also displays a logout button. All the information that I am set up for is displayed for me. I want to run a site where parents login and can view their kids grades and what not and no other kids grades. I need someones help. I know a little bit about CFM. But not as much as you guys do. I was wondering if you someone could fill me in on how I can set something up similar to what they have running on Onvia.com. I just can't get the tables right and things like that. I notice that when I log on to thier site the page URL is: https://www.onvia.com/usa/my/index.cfm? task=login. The part ...?task=login confuses me. How does it know that it is me logged in. The only way I know how to do it is. ...? loginname=jeremypassword=834kds. I am confused on the pages I need, the coding I need and the tables I need. Basically, I am clueless at this point in my CF writing. What would really help is if someone could set up a few pages: a login page, the page viewed after the login page, and then a page after that. And also an Access Database with the proper tables and email it to me. And I would be able to figure out the rest from their. If you someone could help me out, I would greatly appreciate it. You can contact me @ (503) 570-3157 or e-mail @ [EMAIL PROTECTED] Please lend me a hand. I am building this site to help parents be more involved with their kids school life. It is really important to me. Sorry for the long message. But thank for your time, Jeremy Toevs Office: (503) 570-3157 Fax:(503) 570-5079 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --=_NextPart_000_0003_01C002B3.AA8B20A0 Content-Type: application/x-zip-compressed; name="SecurityApplicationShell.ZIP" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="SecurityApplicationShell.ZIP" UEsDBBQIADlYUyY+N2UxUwIAAJ8FAAAJQWRtaW4uY2ZttVNNTxsxED2DxH8YlgtIJS60 hyZKIuUDtUiERiKo6qlybG92hNde2d6g7a/v2BtIEEpLK9WXnfXMvPf8PO4fn/+vdXR4cCccVgFu eal6wGWJpiPykhIQ16gOhXU9GHdgroJyMCrR4VMWYMoDtV2yi0/sotvtUmKqfEJEa3qwKNBD+w8S faV544FDqUwNwQIXQnkPoVAtM/rgeOyEvDYiBr6TuCa2ahyuitDbhnAqziCStprg2sia+lH5dxSL zlZku5IWYaUC+lbOrlEqCdzHX24kCG5gqaD2tIuGthrgVaVRJEUeGlsDYdICqdZK2woekdypA6GW lTK+lU7nigeyJBIN18CThR0YN4SNZkXZjZANWgSOTpBHXGtwylfEh0vUGBrIrQOvHFFEcwwZBtxh AsqdLRMXaQabb+Ce4cmBP0/Av67h0WFf5D/WXKOkGYC5wzVqtVKDbBSvEmZ0x1lbhTkYG07bWcKf Sp7R/gEltG3NhdrpQXYy42hi20lG4yCDfVBmkDXKJxgWcSig8Hj6dbL4Pr+CL4vZDczvxzfXE8jO Gfv2YcLYdDFtEx8772FBlnmMHFwzdnWbtQhFKHUELRSXSUvAoNXwTonaRdNHL6axz9p0VLHpoHBp ZZMwLvf19SCeKDlBjZdUvLWm11+633j4HMINwW193HqYZHMonMp3ymN1fL/ZcGYl5s0W0/cZH25I d7zcw//Z2bp6G3cqfcWbdv+O857G/G2UsfIVY9zcS0ivtKrDC5CdcRuOuXiID3fnvnZxnrv77OnW 2WaEjg5/AVBLAwQUCABCn7om1q89pfgDAAA2CQAADwAAAGFwcGxpY2F0aW9uLmNmbbVWXU8j NxR9Bon/cDu8gESGsPtSWIKUJaBFAopIqNSnyvHcSVxm7FnbA+Tf99jjfG3ZrVRt/ZB4Yvvce4/P uZPzX3r/19jb3RlLqxpP96LmMxJNUykpvDI6l2WNZQpj2Pq5sWf0OacH9mxpWCurlqtEI+Fx+MPx ya/HJ6enp1gYsYu4ADqjMXtHbUPO1LwZglzDUpVKUiMs4gOZHQldkJyzfHbkDTlmUiX5ORNgMUi2 1rL21DokMheOKjObcUFK03TRnVR6Fk84di6UErb+qQp6EVaJacU53ZQJzc+VW/1OhUEC2njiN+V8 wNARKMbCRsuFsiw9wiG3sILgCNyIGeeRj0vTLKyazf3ZekoH8pACMR1vdKOL1nmr2B1hLvM1kd2Y hJykKTiEbKx5UQUColKV2BEoNSYVqxZ6scmqo4Vpl2QV/MKVaehV4QZbD9S6Ye06+lMJBkkqLSoS 8Zpz+rwAdsdhSiShBWAhJUMvoqrAhmsQT01VpfyCSmPBuEUIFCe0DHdpVQQqramXRJLZ4j7Ag4F/ 1+p/HRd7u3u755fXD8PH4R3dD++uBtlofJ/R6Op6+HQ7GWRjhqZQQdZtDXaDZLeUuhKoox70HGUV ygsa84FIfmugDBJlsMfHPtVKtx4MdAmcy3ITTQNrI+zeLm2PpNtaaOiqhtgH2R/s3tvnZaWwLo15 hpy+uy3CeVUzNDDI9i8tw7ETPI8boQ/6R/2jj/g43E8MyDJUdSeUvmPd0oAypQt+Cy0hu1it30bp YzF6IJ/7eoNAeuRe55W1gbYsg/7AcFfydkoxKFzpF1HBrIm5CJZ2rSz/F/xDrp3WKlpxy4fknlWT fM02tJd0hdZAkhs3AlBY/eDGjbhUmouDbIyTl6GBZIeH2LOzJALRlsVei8pxWnsHIDWcp9BwbkYJ 5j2ciW2XMJwQE+Q3GMRfqR+XfwSzc34cDkfE9SzirbcDab0f11WlGYuim0HhgubeNz3+2qqXQfbI
Re: Building the right tables and pages?
If you have the manuals or any documentation read it. It would take me more time than I have to explain it well enough. I yield to others on the list if they have time. - Original Message - From: "Jeremy Toevs" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 10, 2000 10:56 AM Subject: Re: Building the right tables and pages? Thank you for helping me out with this. I appreciate any help I can get, but like I said, I'm not an expert. So what is this application.cfm and session variables? Jeremy "Kevin Schmidt" [EMAIL PROTECTED] 08/10/00 09:53AM Hmmmsounds like you need to be introduced the the application.cfm file and session variables. I have some files that might help...contact me off list. Kevin - Original Message - From: "Jeremy Toevs" [EMAIL PROTECTED] To: "" [EMAIL PROTECTED] Sent: Thursday, August 10, 2000 10:16 AM Subject: Building the right tables and pages? Hello, I am currently trying to build a web site using CFM where people can log-on with a username and password into the site and see information that is meant for only them. Basically what the people at Onvia.com have running on your site. On their web site, you enter your email address and password then you are logged in. The page says "Welcome back Jeremy Toevs" and also displays a logout button. All the information that I am set up for is displayed for me. I want to run a site where parents login and can view their kids grades and what not and no other kids grades. I need someones help. I know a little bit about CFM. But not as much as you guys do. I was wondering if you someone could fill me in on how I can set something up similar to what they have running on Onvia.com. I just can't get the tables right and things like that. I notice that when I log on to thier site the page URL is: https://www.onvia.com/usa/my/index.cfm? task=login. The part ...?task=login confuses me. How does it know that it is me logged in. The only way I know how to do it is. ...? loginname=jeremypassword=834kds. I am confused on the pages I need, the coding I need and the tables I need. Basically, I am clueless at this point in my CF writing. What would really help is if someone could set up a few pages: a login page, the page viewed after the login page, and then a page after that. And also an Access Database with the proper tables and email it to me. And I would be able to figure out the rest from their. If you someone could help me out, I would greatly appreciate it. You can contact me @ (503) 570-3157 or e-mail @ [EMAIL PROTECTED] Please lend me a hand. I am building this site to help parents be more involved with their kids school life. It is really important to me. Sorry for the long message. But thank for your time, Jeremy Toevs Office: (503) 570-3157 Fax:(503) 570-5079 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.