cferror question
I'm setting up a cferror template that collects the following info.
INSERT INTO Errors(HTTPReferrer, Diags, Query, Page)
VALUES ('#ERROR.HTTPReferer# ', '#Error.Diagnostics#', '#Error.QueryString#',
'#ERROR.Template#')
I'm getting a cf error saying that httpreferrer is undefined in error. Is there
a setting in the cf administrator that I'm missing. I have it working on a
different server.
Thanks,
John
~|
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:317544
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cferror question
Thanks G. IIRC HTTPReferer is a CGI variable as in CGI.HTTPReferer check the docs on what vars error returns. G! ~| 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:317550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
inserting null values
I have a form which is throwing the following error upon submit: Element NAME is undefined in FORM The field is set to allow nulls in the database. Is there something else I should be doing to allow a null value to be passed? Thanks ~| 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:316267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: inserting null values
Thanks Charlie, it was a group of radio buttons. cfparam name=form.name default= type=string / did the trick. that's got nothing to do with your database. you're referencing a form field (#form.name#) that doesn't exist. according to the error, you have no form field with the name name. if there is one and it's a checkbox or radio group (and none are checked or selected), they don't get passed into the form scope. you'll need to param them in the form's action: cfparam name=form.name default= type=string / bear in mind that this is not a NULL value. it's an empty string. if you want to insert a true NULL into the database, you'll need to do: cfqueryparam value=#form.name# cfsqltype=cf_sql_char null=#not len(trim(form.name))# / On Thu, Dec 4, 2008 at 8:17 AM, John P [EMAIL PROTECTED] wrote: ~| 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:316270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Error importing from .xls data
Hi, I'm receiving the following error when attempting to import an .xls file. [ODBC Excel Driver] The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. I've read that the data type is chosen by the ODBC driver based on the first 8 records and it appears this may be creating the problem. This Excel workbook has 7 sheets, I've moved the longest columns of each to column B thinking this would solve the problem but hasn't. I'm using cffile for the upload then running cfquery on it to get the results. This application has worked in the past but I have two spreadsheets that are causing an identical problem. Thanks ~| 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:315783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
client variables log database is huge
I suspect that there may be a problem with our ClientStorage_log database as it's currently at 11.5 gigs and has to be cleared out once a month or so. I freed 4.5 gigs of space on this server by moving files off 2 days ago and within 24 hours that space was filled again. Could this be a security hole that is allowing our clientStorage_log db to get filled so quickly? I don't know the size of the clientStorage_log prior to moving the files off the server but it's by far the largest recently modified file in the past 4 days. Coldfusion MX7 server. Thanks ~| 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:315703 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: client variables log database is huge
Thanks to both of you for the information. John I suspect that there may be a problem with our ClientStorage_log database as it's currently at 11.5 gigs and has to be cleared out once a month or so. I freed 4. 5 gigs of space on this server by moving files off 2 days ago and within 24 hours that space was filled again. Could this be a security hole that is allowing our clientStorage_log db to get filled so quickly? I don't know the size of the clientStorage_log prior to moving the files off the server but it's by far the largest recently modified file in the past 4 days. If you're using MS SQL Server to store Client variables, the recovery model you've chosen for the database will control what happens when the database is backed up by scheduled maintenance task. It sounds like you've chosen full or bulk-logged, in which case you are responsible for truncating the transaction log. If you choose the simple recovery model, the transaction log should be truncated automatically, if I recall correctly. You can also reduce the number of database writes by disabling the option in CF to keep track of Client.Hitcount and Client.LastVisit. If you're not using those variables, you should disable that option. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:315710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: client variables log database is huge
Thanks to both of you for the information. John I suspect that there may be a problem with our ClientStorage_log database as it's currently at 11.5 gigs and has to be cleared out once a month or so. I freed 4. 5 gigs of space on this server by moving files off 2 days ago and within 24 hours that space was filled again. Could this be a security hole that is allowing our clientStorage_log db to get filled so quickly? I don't know the size of the clientStorage_log prior to moving the files off the server but it's by far the largest recently modified file in the past 4 days. If you're using MS SQL Server to store Client variables, the recovery model you've chosen for the database will control what happens when the database is backed up by scheduled maintenance task. It sounds like you've chosen full or bulk-logged, in which case you are responsible for truncating the transaction log. If you choose the simple recovery model, the transaction log should be truncated automatically, if I recall correctly. You can also reduce the number of database writes by disabling the option in CF to keep track of Client.Hitcount and Client.LastVisit. If you're not using those variables, you should disable that option. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:315711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
capture url variable?
Hi, I need to capture a url variable then add it to a redirect so my application which is changing servers will still work. Not sure where to start. Thanks, John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312634 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: capture url variable?
Thank you all, that's exactly what I wanted to do. cgi.query_string cflocation URL=somewhere_else?#cgi.query_string# addtoken=no / ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312639 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Setting base url in application.cfc
Thank you both for your suggestions, this was helpful in understanding the scopes of application.cfc. John Try setting application.urlBase in the OnApplicationStart section, unless you really want this to be in the variables scope. -Mike Chabot ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311212 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Setting base url in application.cfc
Hi, I'm interested in setting a base url in my application.cfc which I will be able to reference from all .cfm pages. I've tried it in onReqestStart and onApplicationStart and it doesn't seem to be working, I get a variable base is undefined error. cffunction name=onRequestStart returnType=void cfset base = http://mywebsite.com; /cffunction Thanks, John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
(Server returned: Connection reset)
Hi, I'm running the developer edition of CF8 with a MS2k5 SQL server and receiving the following error on the index page. Other pages are loading using the same datasource with out the error. The site was working fine yesterday. The datasource shows connectivity from the cfide/administrator. All other instances on the cf server appear to be working properly. Not sure where to go from here. Thanks John Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309678 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion 8 install question
Thank you both for the info. John You need to add the data sources into each instance if you plan on actually using them. Unless you have a site using the default instance, you shouldn't need any data sources set up there. I may be wrong, but I seemed to remember if you added data sources to your base instance BEFORE creating the other instances, the data sources will copy over at the time they are created. If you are looking for a magical way to have the data sources automatically add to all instances at once, try Railo. :) Our server admin has set up CF8 with 4 instances. When adding data sources I have to add them to the root cfide/administrator rather than within the instance example: http:mysite.com/:portNumber/cfide/administrator. Seems like the install might be configured incorrectly, does anyone have any experience with setting up multiple instance data sources? Do they just go in the root cfide? Thanks, John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Coldfusion 8 install question
Our server admin has set up CF8 with 4 instances. When adding data sources I have to add them to the root cfide/administrator rather than within the instance example: http:mysite.com/:portNumber/cfide/administrator. Seems like the install might be configured incorrectly, does anyone have any experience with setting up multiple instance data sources? Do they just go in the root cfide? Thanks, John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307870 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Some Flash form text fields displaying white text using Vista
Hi All, I discovered something strange with flash cfform this morning. Some of the text fields which are populated by the database are displaying the text in white while others in black, the white text is invisible on the white background. This issue appears to be related to MS Vista as I have tested on three separate machines running vista with both Firefox and IE7 and had the issue with different versions of Flash Player installed. I have not been able to replicate this issue using XP. Here are two of the form fields, one displays text in white the other black. They look identical to me. Any thoughts? Thanks! John cfinput name=CourseGuestList label=If yes, please list. type=text message=Please describe student presentations. required=no validate= validateAt=onBlur width=150 height=75 value=#GetCourse.CourseGuest# cfinput name=StudentPresentList label=If yes, please describe. type=text message=Please describe student presentations. required=no validate= validateAt=onBlur width=150 height=75 value=#GetCourse.StudentPresent# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301426 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
binary data would be truncated
I'm having a problem with a form which is giving the following error on insert of text fields which contain a paragraph or two of data. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated. This error would seem to me to be created by a MSSQL datatype which is not large enough to hold the inserted data. I was using nvarchar and have since switched to ntext which seems to have fixed the problem. I'm a bit confused as to why nvarchar was causing the error as the data being submitted was well under the nvarchar limit, 2 or 3 paragraphs. I am trimming all of the data I am inserting. Any thoughts? Thanks, John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: binary data would be truncated
Thanks for your help guys. John On SQL Server NVARCHAR can be up to 4000. Just do a Len() in the data to see if it is as long as you think it is. Adrian Nvarchar only allows 255 characters. NText is the field you want if its paragraphs you are storing. Rick Eidson The KChost Radio Network http://www.kchost.net/ Eidson Empire http://www.eidsonsempire.com/ I'm having a problem with a form which is giving the following error on insert of text fields which contain a paragraph or two of data. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated. This error would seem to me to be created by a MSSQL datatype which is not large enough to hold the inserted data. I was using nvarchar and have since switched to ntext which seems to have fixed the problem. I'm a bit confused as to why nvarchar was causing the error as the data being submitted was well under the nvarchar limit, 2 or 3 paragraphs. I am trimming all of the data I am inserting. Any thoughts? Thanks, John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301432 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Some Flash form text fields displaying white text using Vista
Is it possible to change the text color via the cfform style attribute? Have you tried using css to force the colour of the text? Might be a workaround. will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301433 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: changing a css file via coldfusion
Excellent, thank you all for the suggestions. It makes sense now. I think I'll experiment with both methods just to learn the process. Sorry about the double post of the question, I couldn't find my initial submission and thought it didn't post. As always you're very helpful, thanks! ~| 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:293040 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
changing a css file via coldfusion
Is it possible create a way using coldfusion which would allow the user to change the current page style by selecting a link on the page? Seems like it shouldn't be to difficult, I just can't think of how to do it. Thanks, John ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292957 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
changing style sheets
Is there a way to allow the user to change the style sheet of a page using a link on the page? Thanks, John ~| ColdFusion 8 - 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:292908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
remove a number from a series of numbers
Hi, Is it possible to remove a digit from a multi-digit number IE: 2007 would become 207? Thanks, John ~| 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:288286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: remove a number from a series of numbers
I'd like to remove the 2nd Character (zero) from the left Thanks to all for your help. John removeChars(2007, 2, 1) You could start at index '3' in this case since both 2 and 3 are zeros. cheers, barneyb ~| 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:288318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: remove a number from a series of numbers
I ended up using #RemoveChars(2007, 2, 1)# Thanks! Or you could do it with any of the other methods mentioned. There are a lot of ways to do that. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| ColdFusion 8 - 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:288319 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reformatting data in text field
That worked, Thanks for your help ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284478 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
reformatting data in text field
Is there a way to reformat text in a text area to add quotation marks and different line spacing? So a comma separated list: John, Tom, Frank, Bonnie, Jennifer, Richard, Sally Would become this: John, Frank Bonnie, Jennifer Richard, Sally Thanks for your help, John ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
rss.cfc - Getting optional elements to display in feed
Hi all, I've successfully implemented Ray Camden's rss.cfc to create a feed from my query. I'm wondering if it is possible to get optional elements to display in the feed, or do most feed readers only display the required elements; title, link and description? I'd like to show subject and pubdate in my feed as well, they are showing up on the feed xml source file, just not being displayed in my reader. Thanks! John ~| 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:280468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: rss.cfc - Getting optional elements to display in feed
Hi all, I've successfully implemented Ray Camden's rss.cfc to create a feed from my query. I'm wondering if it is possible to get optional elements to display in the feed, or do most feed readers only display the required elements; title, link and description? I'd like to show subject and pubdate in my feed as well, they are showing up on the feed xml source file, just not being displayed in my reader. Thanks! John Disregard, I was able to include my date and subject in the description element. Thanks ~| 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:280480 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Ignoring Application.cfc or .cfm
Is there a tag I can use on my page to ignore an application.cfc in the root directory? Additionally, how many directories above the page being called will CF travel to look for an application.cfc or .cfm file? Will it look keep going until it reaches the server root directory? Thanks! John ~| 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:280119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ignoring Application.cfc or .cfm
Great, thanks Ben! John, Yep, all the way up. And to get it to ignore it, just add one in your own folder. --- Ben -Original Message- From: John P [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 05, 2007 12:29 PM To: CF-Talk Subject: Ignoring Application.cfc or .cfm Is there a tag I can use on my page to ignore an application.cfc in the root directory? Additionally, how many directories above the page being called will CF travel to look for an application.cfc or .cfm file? Will it look keep going until it reaches the server root directory? Thanks! John ~| 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:280123 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Custom tag for generating rss feeds
Hi, Does anyone know of a custom tag which you can create an RSS feed from a cfquery? I've attempted to use Tom Muck's but I get the follow error. XML Parsing Error: xml declaration not at start of external entity Location: http:///rssTest.cfm Line Number 8, Column 1:?xml version=1.0 ? ^ Thank you, John ~| 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:279826 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: setting var inside cffunction
That worked! Thanks Charlie! I've never used cfldap, so i'm not sure you can alias the columns that way (maybe someone who has more familiarity with it can chime in). what i was suggesting was a query of queries. assuming the cfldap returns a standard CF query object (again, an assumption), i figured you could just alias the columns in the query of queries. cfquery name=myQoQ dbtype=query SELECT givenName AS First_Name, sn AS Last_name, (etc) FROM GETIDS /cfquery then cfreturn myQoQ instead of the original LDAP query. On 5/16/07, John P [EMAIL PROTECTED] wrote: ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278505 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: setting var inside cffunction
Thanks for the help Charlie, I've used aliasing to change my collumn names in this way: cffunction name=listUsers access=remote returnType=query output=true cfargument name=userID required=yes cfset var getIDS = cfldap action=query name=GetIDS start=ou=ple,o=blah.com filter=id=#userID# attributes=givenname as First_name,sn as Last_name, mail as email,dbaddress as Address,dbcity as city,dbstate as state,dbzipcode as zipcode,homephone as phone server=ds.blah.com username=uid=asdf,ou=ReadOnly,o=blah.com password=password cfreturn GetIDS /cffunction But I am unable to output the new table data associated with the new column names after I invoke the component. Cfdump does work and displays the collumn names as DBADDRESS AS ADDRESS etc. Any idea what I am doing wrong? Thanks. On 5/15/07, John P [EMAIL PROTECTED] wrote: Here's the function on my .cfc page: The function isn't resetting anything. Your block of cfset tags is simply setting some variables that are local to the function. They are not in any way related to the LDAP query (not the way you have the code written). You could pull all of those cfset tags out, and you'd get the same result. If you're trying to rename the columns, you could do a query of queries (query the LDAP query) and alias the column names the way you want them to appear. Also, scope that #userID# variable as #arguments.userID# :) -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| 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:278318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
setting var inside cffunction
I posted a question yesterday about using cfset inside cffunction and received help, thanks! I've moved my cfsets above my cfldap query (which corrected my initial issue) but problem is the returned values from the cfldap query don't appear to be being set. Perhaps because the cfsets occur in the lines above the cfldap query? I've tested this by doing a cfdump just under invoking the component on another page. The variables returned are the ldap names not the new vars I was attempting to rename them to. I've pasted a portion of yesterdays thread below to make so you have an idea what's happening in my function. Thanks! John --- you have to place your var scoped variables at the top of the function. in this case, you'd do something like: cfset var givenname = / cfset var sn = / cfset var mail = / (etc) above your cfldap call. On 5/14/07, John P [EMAIL PROTECTED] wrote: - Hide quoted text - - Show quoted text - I am attempting to use cffunction to query a database and then cfset the returned variables to a new names. I get the following error when attempting to access the page. Local variable givenname on line 19 must be grouped at the top of the function body. Here's my function that appears on my .cfc page: cfldap action=query name=GetIDS start=ou=ple,o=blah.com filter=id=#userID# attributes=givenname,sn,mail,dbaddress,dbcity,dbstate,dbzipcode,homephone server=ds.blah.com username=uid=asdf,ou=ReadOnly,o=blah.com password=password cfset var givenname = First_name cfset var sn = Last_Name cfset var mail = Addr cfset var dbaddress = ADDRESS cfset var dbcity = City cfset var dbstate = State cfset var dbzipcode = ZIP cfset var homephone = PHONE cfreturn GetIDS /cffunction What am I doing wrong? Is it possible to use cfset inside of a cffunction? Thanks! John ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278173 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: setting var inside cffunction
Here's the function on my .cfc page: cffunction name=listUsers access=remote returnType=query output=true cfargument name=userID required=yes cfset var getIDS = cfset var givenname = First_name cfset var sn = Last_Name cfset var mail = Addr cfset var dbaddress = ADDRESS cfset var dbcity = City cfset var dbstate = State cfset var dbzipcode = ZIP cfset var homephone = PHONE cfldap action=query name=GetIDS start=ou=ple,o=blah.com filter=id=#userID# attributes=givenname,sn,mail,dbaddress,dbcity,dbstate,dbzipcode,homephone server=ds.blah.com username=uid=asdf,ou=ReadOnly,o=blah.com password=password cfreturn GetIDS /cffunction I'm calling the function this way: cfinvoke component=Data method=listusers returnvariable=user cfinvokeargument name=userID value=#SESSION.userID#/ cfinvokeargument name=info value=#session.info#/ /cfinvoke cfdump var=#user# But cfdump only returns column names from ldap not the variables I was attempting to reset them to. I'm confused. You're returning the LDAP query itself (via cfreturn getIDS). where do those single variables (givenname, sn, mail, etc) that you're explicitly setting come into play? On 5/15/07, John P [EMAIL PROTECTED] wrote: ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem using cfset inside cffunction
I am attempting to use cffunction to query a database and then cfset the returned variables to a new names. I get the following error when attempting to access the page. Local variable givenname on line 19 must be grouped at the top of the function body. Here's my function that appears on my .cfc page: cfldap action=query name=GetIDS start=ou=ple,o=blah.com filter=id=#userID# attributes=givenname,sn,mail,dbaddress,dbcity,dbstate,dbzipcode,homephone server=ds.blah.com username=uid=asdf,ou=ReadOnly,o=blah.com password=password cfset var givenname = First_name cfset var sn = Last_Name cfset var mail = Addr cfset var dbaddress = ADDRESS cfset var dbcity = City cfset var dbstate = State cfset var dbzipcode = ZIP cfset var homephone = PHONE cfreturn GetIDS /cffunction What am I doing wrong? Is it possible to use cfset inside of a cffunction? Thanks! John ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Problem using cfset inside cffunction
Great, thanks Charlie. you have to place your var scoped variables at the top of the function. in this case, you'd do something like: cfset var givenname = / cfset var sn = / cfset var mail = / (etc) above your cfldap call. On 5/14/07, John P [EMAIL PROTECTED] wrote: ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278103 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: form data not being inserted into mssql database
Thanks all. Carl, does cfparam as you described discretely tell CF and SQL that the insert is a numerical data type? In what instances is that advised? Why is it necessary? I've isolated the issue to a server memory problem, I believe, and solved it (I hope) by restarting the server. Thank you all for your help. John, You might want to try using CFQUERYPARAM in your insert query. Something like: INSERT INTO STUDENT_ACADEMICS (CUM_GPA) VALUES (cfqueryparam value=#TRIM(FORM.CUM_GPA)# CFSQLTYPE=CF_SQL_NUMERIC) Set the CFSQLTYPE to the appropriate type to match the data type of the SQL field. HTH, Carl Form code: cfform name=ThisForm method=post action=action.cfm cfinput type=Text name=Cum_GPA message=GPA is required required=Yes size=8... Insert: cfquery name=InsertGPA datasource=server INSERT INTO STUDENT_ACADEMICS (CUM_GPA) ~| 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:275969 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: form data not being inserted into mssql database
Unfortunately the failed inserts are random for different users, unique fields, it's a pretty large application. I'd rather that it work correctly but I'll take your suggestion into consideration worse case senario. Could you: cfif NOT Len(FORM.CUM_GPA) cfmail to=blah type=html What the hell is goin on here?? cfdump var=#form# /cfmail redirect user letting them know there's a problem /cfif ~| 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:275859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
form data not being inserted into mssql database
Hi All, I'm maintaining a Coldfusion Application which is storing form data in an MSSQL database. We've recently received complaints from users that not all form data is being inserted to the database. The issue appears to be random. I've tested 4 times and found that only one of my fields is not inserting. I've checked the form field name, insert statement, table name and everything checks out there. The field I am attempting to insert is one number. Out of 279 records, only 3 have not inserted into this field. There are a couple of months between each of these insert dates. I've flooded other fields with paragraphs of text, which insert fine. We've recently (within the last month) applied both Microsoft and Coldfusion updates to the server. Any ideas? Thanks a bunch! ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275782 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: form data not being inserted into mssql database
Coldfusion updates that were performed were 7.0.1 and 7.0.2 I'm researching but does anyone know if these updates affected session variables? Thx John Hi All, I'm maintaining a Coldfusion Application which is storing form data in an MSSQL database. We've recently received complaints from users that not all form data is being inserted to the database. The issue appears to be random. I've tested 4 times and found that only one of my fields is not inserting. I've checked the form field name, insert statement, table name and everything checks out there. The field I am attempting to insert is one number. Out of 279 records, only 3 have not inserted into this field. There are a couple of months between each of these insert dates. I've flooded other fields with paragraphs of text, which insert fine. We've recently (within the last month) applied both Microsoft and Coldfusion updates to the server. Any ideas? Thanks a bunch! ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275786 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: form data not being inserted into mssql database
Form code:
cfform name=ThisForm method=post action=action.cfm
cfinput type=Text name=Cum_GPA message=GPA is required required=Yes
size=8...
Insert:
cfquery name=InsertGPA datasource=server
INSERT INTO STUDENT_ACADEMICS (CUM_GPA)
VALUES ('#TRIM(FORM.CUM_GPA)#')
/cfquery
CUM_GPA is not being inserted for me, however other users have had different
data that is lost. This variable is NOT being stored as a session variable.
Thx John
can you post the form code, insert code, and variable values that did
not insert properly?
On 4/18/07, John P [EMAIL PROTECTED] wrote:
~|
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:275794
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: form data not being inserted into mssql database
CUM_GPA does pass with cfform var=#form# on the action page. I am inserting other records with this insert statement, I left them out of my post for clarity. Yes this is a new insert not an update. can you do a cfdump var=#form# on top of action.cfm and make sure a value (and the value you expect) is being passed? also... you're just inserting a single record? not trying to update a particular existing record? On 4/18/07, John P [EMAIL PROTECTED] wrote: ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: form data not being inserted into mssql database
That's correct, worse still, the issue seems random. I've had other users who have been unsuccessful at submitting variables which have worked for me each time I've tested. At first I thought it might be a session issue, but the example above is a form variable. For some reason Cum_GPA isn't making it into the table and as I mentioned before I did a count on all of the table Cum_GPA = '' and only found three of 200+ entries which were null. It's a required field. I'm not sure where to start. I've combed the release notes for the two coldfusion updates, but nothing jumps out at me which might be a cause. Thx John and you're not getting any errors? the other values in the statement are inserting fine but you get an empty field for CUM_GPA? On 4/18/07, John P [EMAIL PROTECTED] wrote: ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275822 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
