invalid parameter binding?
I'm getting Invalid Parameter Binding on this function http://pastebin.com/xfh8uLVa The conf_id variable is a UUID string and if I put the value in the query and manually run it I get the results back.. But why am I getting this with cfqueryparam? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354062 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: invalid parameter binding?
Thanks Dave! I've used varchar before and it was working earlier. I had to change the query around a bit and since then I've been getting this error. But I tried botd idstamp and char(36) and got the exact same error both times. I'm using SQL Server 2005. It works find in SQL Server Mgmt Studio Express and if I hardcode the query with an ID. Also, I'm using CF9 if that makes a difference. Anything else you can suggest? On Fri, Jan 25, 2013 at 12:32 PM, Dave Watts dwa...@figleaf.com wrote: I'm getting Invalid Parameter Binding on this function http://pastebin.com/xfh8uLVa The conf_id variable is a UUID string and if I put the value in the query and manually run it I get the results back.. But why am I getting this with cfqueryparam? I'm not sure what database you're using, but I don't think UUID fields are treated as generic strings. You might try using CF_SQL_IDSTAMP or CF_SQL_CHAR(36) for the CFSQLTYPE attribute. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: invalid parameter binding?
Also, using this works.. c.conferenceUID = '#arguments.conf_id#' So I'm not sure what the problem is with cfqueryparam On Fri, Jan 25, 2013 at 12:43 PM, Greg Morphis gmorp...@gmail.com wrote: Thanks Dave! I've used varchar before and it was working earlier. I had to change the query around a bit and since then I've been getting this error. But I tried botd idstamp and char(36) and got the exact same error both times. I'm using SQL Server 2005. It works find in SQL Server Mgmt Studio Express and if I hardcode the query with an ID. Also, I'm using CF9 if that makes a difference. Anything else you can suggest? On Fri, Jan 25, 2013 at 12:32 PM, Dave Watts dwa...@figleaf.com wrote: I'm getting Invalid Parameter Binding on this function http://pastebin.com/xfh8uLVa The conf_id variable is a UUID string and if I put the value in the query and manually run it I get the results back.. But why am I getting this with cfqueryparam? I'm not sure what database you're using, but I don't think UUID fields are treated as generic strings. You might try using CF_SQL_IDSTAMP or CF_SQL_CHAR(36) for the CFSQLTYPE attribute. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354069 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: invalid parameter binding?
What's also weird is that there's an ID field and the UID field. I didn't want to pass the ID around so the UID is passed via urls and forms. So prior to the viewConferenceAttendees function I pass the UID to get the ID. I can dump the resulting query object and 1 row is returned. All good. However when I change the viewConferenceAttendees to accept the ID as oppose to the UID I get the same error: Error Executing Database Query.[Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s). The error occurred in *C:\workforceatm\com\workforceatm\conferenceMain\conferenceMainGateway.cfc: line 546 * 544 : and c.id = cfqueryparam cfsqltype=cf_sql_integer value=#arguments.conf_id# / 545 : cfif structKeyExists(arguments,include_incomplete) and arguments.include_incomplete eq 1*546 :cfelse* 547 : and ac.is_complete = 1 548 : /cfif On Fri, Jan 25, 2013 at 12:47 PM, Greg Morphis gmorp...@gmail.com wrote: Also, using this works.. c.conferenceUID = '#arguments.conf_id#' So I'm not sure what the problem is with cfqueryparam On Fri, Jan 25, 2013 at 12:43 PM, Greg Morphis gmorp...@gmail.com wrote: Thanks Dave! I've used varchar before and it was working earlier. I had to change the query around a bit and since then I've been getting this error. But I tried botd idstamp and char(36) and got the exact same error both times. I'm using SQL Server 2005. It works find in SQL Server Mgmt Studio Express and if I hardcode the query with an ID. Also, I'm using CF9 if that makes a difference. Anything else you can suggest? On Fri, Jan 25, 2013 at 12:32 PM, Dave Watts dwa...@figleaf.com wrote: I'm getting Invalid Parameter Binding on this function http://pastebin.com/xfh8uLVa The conf_id variable is a UUID string and if I put the value in the query and manually run it I get the results back.. But why am I getting this with cfqueryparam? I'm not sure what database you're using, but I don't think UUID fields are treated as generic strings. You might try using CF_SQL_IDSTAMP or CF_SQL_CHAR(36) for the CFSQLTYPE attribute. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354070 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: invalid parameter binding?
This is what the URL looks like /admin/conference/index.cfm?action=view_attendeesconf_id=6f1e0d6d-c35e-4ea2-9e24-39e0e02d442d I reworked the query to use the ID as opposed to the UID and I'm getting the same error. But again, if I remove cfqueryparam it works. cfif structKeyExists(arguments, conf_id) and isnumeric(arguments.conf_id) and c.id = cfqueryparam value=#arguments.conf_id# CFSQLType=cf_sql_numeric / /cfif -- the above gets me the invalid binding error cfif structKeyExists(arguments, conf_id) and isnumeric(arguments.conf_id) and c.id = #arguments.conf_id# /cfif -- but this works fine On Fri, Jan 25, 2013 at 1:05 PM, Dave Watts dwa...@figleaf.com wrote: Also, using this works.. c.conferenceUID = '#arguments.conf_id#' So I'm not sure what the problem is with cfqueryparam I think it's pretty clear - we're not specifying the right parameter type. How many characters are in the UUID? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: invalid parameter binding?
So, just this: and c.id = cfqueryparam value=#arguments.conf_id# / ? still get [Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s). On Fri, Jan 25, 2013 at 1:20 PM, Dave Watts dwa...@figleaf.com wrote: This is what the URL looks like /admin/conference/index.cfm?action=view_attendeesconf_id=6f1e0d6d-c35e-4ea2-9e24-39e0e02d442d I reworked the query to use the ID as opposed to the UID and I'm getting the same error. But again, if I remove cfqueryparam it works. Out of curiosity, what happens if you remove the TYPE attributes from your CFARGUMENT tags and use CFQUERYPARAM with either field? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354074 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: invalid parameter binding?
I removed this section of the query and it worked.. case when ( select 1 from conference_refund cr where ac.id = cr.attendee_conference_id and is_complete = 0 and active = 1 and (acp.date_received is not null or ac.payment_method = 'credit') ) is not null then 2 -- show process_refund when (acp.date_received is not null or ac.payment_method = 'credit') then 1 -- show init_refund else 0 -- show nada end as show_init_process_refund, so looks like back to the drawing board.. but why does it work without the cfqueryparam? and it works fine in SQL Mgmt Studio? On Fri, Jan 25, 2013 at 1:28 PM, Greg Morphis gmorp...@gmail.com wrote: So, just this: and c.id = cfqueryparam value=#arguments.conf_id# / ? still get [Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s). On Fri, Jan 25, 2013 at 1:20 PM, Dave Watts dwa...@figleaf.com wrote: This is what the URL looks like /admin/conference/index.cfm?action=view_attendeesconf_id=6f1e0d6d-c35e-4ea2-9e24-39e0e02d442d I reworked the query to use the ID as opposed to the UID and I'm getting the same error. But again, if I remove cfqueryparam it works. Out of curiosity, what happens if you remove the TYPE attributes from your CFARGUMENT tags and use CFQUERYPARAM with either field? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: invalid parameter binding?
Specifically it doesn't like this: case when (acp.date_received is not null or ac.payment_method = 'credit') then 1 -- show init_refund else 0 -- show nada end as show_init_refund, On Fri, Jan 25, 2013 at 1:31 PM, Greg Morphis gmorp...@gmail.com wrote: I removed this section of the query and it worked.. case when ( select 1 from conference_refund cr where ac.id = cr.attendee_conference_id and is_complete = 0 and active = 1 and (acp.date_received is not null or ac.payment_method = 'credit') ) is not null then 2 -- show process_refund when (acp.date_received is not null or ac.payment_method = 'credit') then 1 -- show init_refund else 0 -- show nada end as show_init_process_refund, so looks like back to the drawing board.. but why does it work without the cfqueryparam? and it works fine in SQL Mgmt Studio? On Fri, Jan 25, 2013 at 1:28 PM, Greg Morphis gmorp...@gmail.com wrote: So, just this: and c.id = cfqueryparam value=#arguments.conf_id# / ? still get [Macromedia][SQLServer JDBC Driver]Invalid parameter binding(s). On Fri, Jan 25, 2013 at 1:20 PM, Dave Watts dwa...@figleaf.com wrote: This is what the URL looks like /admin/conference/index.cfm?action=view_attendeesconf_id=6f1e0d6d-c35e-4ea2-9e24-39e0e02d442d I reworked the query to use the ID as opposed to the UID and I'm getting the same error. But again, if I remove cfqueryparam it works. Out of curiosity, what happens if you remove the TYPE attributes from your CFARGUMENT tags and use CFQUERYPARAM with either field? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: invalid parameter binding?
What I did was just return the data_received value and I already was returning the payment_method so I just used CF code to check the values. Thanks for all your time Dave! On Fri, Jan 25, 2013 at 2:09 PM, Dave Watts dwa...@figleaf.com wrote: Specifically it doesn't like this: case when (acp.date_received is not null or ac.payment_method = 'credit') then 1 -- show init_refund else 0 -- show nada end as show_init_refund, OK, I think this is more complicated than I did before! You might want to try creating a stored procedure, then calling that from CF. That'll let you use parameters. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sql injection attempt
It was attempted via the URL On Wed, Jan 23, 2013 at 11:57 AM, Rob Voyle robvo...@voyle.com wrote: Hi Greg As I continue to update my security processes, I'm curious Was this injection attempt at the url or at a form input. Thanks Rob On 22 Jan 2013 at 11:12, Greg Morphis wrote: I saw some request errors but what were they trying to do? This is what the onRequest error email showed declare @q varchar(8000) select @q = 0x57414954464F522044454C4159202730303A30303A313527 exec(@q) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag= houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:35 3998 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354031 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
sql injection attempt
I saw some request errors but what were they trying to do? This is what the onRequest error email showed declare @q varchar(8000) select @q = 0x57414954464F522044454C4159202730303A30303A313527 exec(@q) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353998 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: sql injection attempt
Ah so they were just checking to see if they could get something to work before possibly trying anything real. Thanks! On Tue, Jan 22, 2013 at 11:15 AM, John M Bliss bliss.j...@gmail.com wrote: That's hex for, ?WAITFOR DELAY '00:00:15' On Tue, Jan 22, 2013 at 11:12 AM, Greg Morphis gmorp...@gmail.com wrote: 0x57414954464F522044454C4159202730303A30303A313527 -- John Bliss - http://about.me/jbliss ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354000 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Tracking Link Click
That's what I would do. Send the user to a page that stores the ID of the movie (or whatever) and then redirect them to the download link. On Mon, Jan 7, 2013 at 11:42 AM, Bruce Sorge sor...@gmail.com wrote: Hello all, I have a site where once a user registers they are taken to a page with three links to a movie to download (normal, hearing impaired and vision impaired). hat I want to do is track which movie is downloaded. The problem is that the movies are stored off site on another server (yousendit.com). So I guess this is an outbound link? How would i go about doing this? Do I do a separate CFM page that tracks the URL then does a quick redirect to the actual download? Thanks, Bruce ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
list of countries and territories
Does anyone have or know of a good list of delimited countries and territories I can use and import into my DB? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list of countries and territories
That is awesome.. thanks Russ! On Mon, Dec 3, 2012 at 1:03 PM, Russ Michaels r...@michaels.me.uk wrote: http://countrylist.net/ On Mon, Dec 3, 2012 at 6:43 PM, Greg Morphis gmorp...@gmail.com wrote: Does anyone have or know of a good list of delimited countries and territories I can use and import into my DB? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list delimiters question
I'm sure there are several ways to do this cfset FORM.some_url = http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099 / cfset params = listgetat(FORM.some_url,2,?) / cfset p = listtoarray(params, ) / cfset chapter_id = 0 / cfloop array=#p# index=i cfif find(chapter_id=, i) cfset chapter_id = listgetat(i, 2, =) / /cfif /cfloop cfdump var=#chapter_id# / On Thu, Nov 15, 2012 at 8:28 AM, morchella morchella.delici...@gmail.comwrote: hey guys! i could use a liitle help. i am trying to get a specific value. in this example chapter_id ListgetAt could work, but the returned form url cold have the value in a different oposition at any time. i thought i could use a delimiter specifiying ,chapter_id= but that dosnt seem to work. cfset FORM.some_url = http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099 / cfset getChapterId = trim(ListLast(FORM.some_url,chapter_id=)) cfset Param2 = ListGetAt(FORM.some_url,2,) Param2: chapter_id=12120 Right, but only some times. getChapterId: 40099Wrong thanks a bunch. i googled every thing from listtoarray to cfdump var=#getPageContext().getRequest().getParameterValues('FORM.some_url')# Which dosnt seem to gel with cf7!! thanks a bunch for clear out the cob webs this am.. -m ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353171 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list delimiters question
no need to convert it to a array (I was trying to go that route but keeping it a list works fine too) cfset params = listgetat(FORM.some_url,2,?) / cfset chapter_id = 0 / cfloop list=#params# delimiters= index=i cfif find(chapter_id=, i) cfset chapter_id = listgetat(i, 2, =) / /cfif /cfloop cfdump var=#chapter_id# / On Thu, Nov 15, 2012 at 8:40 AM, Greg Morphis gmorp...@gmail.com wrote: I'm sure there are several ways to do this cfset FORM.some_url = http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099 / cfset params = listgetat(FORM.some_url,2,?) / cfset p = listtoarray(params, ) / cfset chapter_id = 0 / cfloop array=#p# index=i cfif find(chapter_id=, i) cfset chapter_id = listgetat(i, 2, =) / /cfif /cfloop cfdump var=#chapter_id# / On Thu, Nov 15, 2012 at 8:28 AM, morchella morchella.delici...@gmail.comwrote: hey guys! i could use a liitle help. i am trying to get a specific value. in this example chapter_id ListgetAt could work, but the returned form url cold have the value in a different oposition at any time. i thought i could use a delimiter specifiying ,chapter_id= but that dosnt seem to work. cfset FORM.some_url = http://somesite.com/some_display.cfm?some_id=4184chapter_id=12120passage_id=40099 / cfset getChapterId = trim(ListLast(FORM.some_url,chapter_id=)) cfset Param2 = ListGetAt(FORM.some_url,2,) Param2: chapter_id=12120 Right, but only some times. getChapterId: 40099Wrong thanks a bunch. i googled every thing from listtoarray to cfdump var=#getPageContext().getRequest().getParameterValues('FORM.some_url')# Which dosnt seem to gel with cf7!! thanks a bunch for clear out the cob webs this am.. -m ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list delimiters question
gets the second item in the list (chapter_id=12345) using the = as a delimiter On Thu, Nov 15, 2012 at 8:53 AM, morchella morchella.delici...@gmail.comwrote: not sure what the listgetat 2 is doing? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353178 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list delimiters question
and the first one is separating the parameters from the URL using the ? as a delimiter. On Thu, Nov 15, 2012 at 8:59 AM, Dean Lawrence dean...@gmail.com wrote: It is treading your form.some_url value as a list separated by a question mark. The listgetat is retrieving the second value in the list, which are all the url name-value pairs. On Thu, Nov 15, 2012 at 9:53 AM, morchella morchella.delici...@gmail.com wrote: not sure what the listgetat 2 is doing? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353179 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: query: how to return records that are increments of one year old?
What DB are you using? On Wed, Nov 14, 2012 at 7:43 AM, Eric Bourland e...@ebwebwork.com wrote: Greetings. I need some advice again. I need to use CFSCHEDULE to schedule a task that does the following: * review all records in table 'membersTable', once per day * return records that are one year (365 days) old, then two years old, then three, and so on in increments of years * send a renewal reminder to the UserEmail associated with each found record But I am having trouble building the query to return records that are increments of one year old. How can I form this this query? The column DateCreated notes the date when a record was first created. !--- query membersTable for records that are increments of one year old --- cfquery name=getUser datasource=#APPLICATION.dataSource# SELECT UserID, FirstName, LastName, UserEmail, DateCreated FROM #REQUEST.membersTable# WHERE DateCreated = (DateCreated + increments of one year) /cfquery How should I form that WHERE clause? Thank you for any advice. Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353156 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: query: how to return records that are increments of one year old?
cast(dateadd('y', -1, getdate()) as date) as -- getdate() in MSSQL or trunc(dateadd('y', -1, sysdate)) -- sysdate in Oracle On Wed, Nov 14, 2012 at 7:46 AM, Greg Morphis gmorp...@gmail.com wrote: What DB are you using? On Wed, Nov 14, 2012 at 7:43 AM, Eric Bourland e...@ebwebwork.com wrote: Greetings. I need some advice again. I need to use CFSCHEDULE to schedule a task that does the following: * review all records in table 'membersTable', once per day * return records that are one year (365 days) old, then two years old, then three, and so on in increments of years * send a renewal reminder to the UserEmail associated with each found record But I am having trouble building the query to return records that are increments of one year old. How can I form this this query? The column DateCreated notes the date when a record was first created. !--- query membersTable for records that are increments of one year old --- cfquery name=getUser datasource=#APPLICATION.dataSource# SELECT UserID, FirstName, LastName, UserEmail, DateCreated FROM #REQUEST.membersTable# WHERE DateCreated = (DateCreated + increments of one year) /cfquery How should I form that WHERE clause? Thank you for any advice. Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353158 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: query: how to return records that are increments of one year old?
try that first one, I assume your date column in the DB is storing just the date and not the datetime? if it's storing datetime there would be a problem and you'd have to cast that as a date too. On Wed, Nov 14, 2012 at 7:52 AM, Greg Morphis gmorp...@gmail.com wrote: cast(dateadd('y', -1, getdate()) as date) as -- getdate() in MSSQL or trunc(dateadd('y', -1, sysdate)) -- sysdate in Oracle On Wed, Nov 14, 2012 at 7:46 AM, Greg Morphis gmorp...@gmail.com wrote: What DB are you using? On Wed, Nov 14, 2012 at 7:43 AM, Eric Bourland e...@ebwebwork.comwrote: Greetings. I need some advice again. I need to use CFSCHEDULE to schedule a task that does the following: * review all records in table 'membersTable', once per day * return records that are one year (365 days) old, then two years old, then three, and so on in increments of years * send a renewal reminder to the UserEmail associated with each found record But I am having trouble building the query to return records that are increments of one year old. How can I form this this query? The column DateCreated notes the date when a record was first created. !--- query membersTable for records that are increments of one year old --- cfquery name=getUser datasource=#APPLICATION.dataSource# SELECT UserID, FirstName, LastName, UserEmail, DateCreated FROM #REQUEST.membersTable# WHERE DateCreated = (DateCreated + increments of one year) /cfquery How should I form that WHERE clause? Thank you for any advice. Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353159 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: query: how to return records that are increments of one year old?
a purely MSSQL way would be SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, DATEADD(yy, -1, GETDATE( since 2005 doesn't support that. On Wed, Nov 14, 2012 at 11:02 AM, Leigh cfsearch...@yahoo.com wrote: cast(dateadd('y', -1, getdate()) as date) as -- getdate() in MSSQL I do not think 2005 supports the date type. A CF alternative is using dateAdd(, -1, now()) to get the date and time one year ago. Then use cfqueryparam with type cf_sql_date which automatically drops any time portion. -Leigh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353164 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Rounding, why?
Something is baffling me.. I'm inserting a value into the database and it's rounding the number. I don't know where or why this is happening! On the action page this is what the code looks like when inserting INSERT INTO mytable ( af_id, amount_paid, is_cleared, payment_method_id, action_date, year_paid_for, notes, actionuser ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? ) Query Parameter Value(s) - Parameter #1(cf_sql_integer) = 194 *Parameter #2(cf_sql_numeric) = 35.52* Parameter #3(cf_sql_integer) = 1 Parameter #4(cf_sql_integer) = 1 Parameter #5(cf_sql_timestamp) = 2012-11-12 10:51:54.375 Parameter #6(cf_sql_integer) = 2012 Parameter #7(cf_sql_varchar) = Parameter #8(cf_sql_numeric) = 12985 When I query the database I see 36.00 The table column use to be smallmoney, now it's numeric(19,2).. Does anyone know why this might be happening? And more importantly, how to fix it!? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353130 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Rounding, why?
removing the cfqueryparam cfqueryparam value=#arguments.payment.getamount_paid()# CFSQLType=cf_sql_decimal null=#not len(arguments.payment.getamount_paid())# /, works.. just having #arguments.payment.getamount_paid()# causes it to work fine.. 35.52 is saved as 35.52 in the database. Any ideas as to why this happens? I'm using CF9.0.1 On Mon, Nov 12, 2012 at 11:11 AM, Greg Morphis gmorp...@gmail.com wrote: I tried decimal(19,2) and back to smallmoney and still 36.00 gets inserted into the database table. And changed the type in the cfc to cf_sql_decimal. On Mon, Nov 12, 2012 at 10:56 AM, Greg Morphis gmorp...@gmail.com wrote: Something is baffling me.. I'm inserting a value into the database and it's rounding the number. I don't know where or why this is happening! On the action page this is what the code looks like when inserting INSERT INTO mytable ( af_id, amount_paid, is_cleared, payment_method_id, action_date, year_paid_for, notes, actionuser ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? ) Query Parameter Value(s) - Parameter #1(cf_sql_integer) = 194 *Parameter #2(cf_sql_numeric) = 35.52* Parameter #3(cf_sql_integer) = 1 Parameter #4(cf_sql_integer) = 1 Parameter #5(cf_sql_timestamp) = 2012-11-12 10:51:54.375 Parameter #6(cf_sql_integer) = 2012 Parameter #7(cf_sql_varchar) = Parameter #8(cf_sql_numeric) = 12985 When I query the database I see 36.00 The table column use to be smallmoney, now it's numeric(19,2).. Does anyone know why this might be happening? And more importantly, how to fix it!? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353132 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Rounding, why?
Aha, Google is my friend.. when using cf_sql_decimal you must specify the scale parameter.. scale=2 / makes it all work.. now to go through and make sure everywhere else I'm using the cf_sql_decimal I'm providing the scale parameter. On Mon, Nov 12, 2012 at 11:28 AM, Greg Morphis gmorp...@gmail.com wrote: removing the cfqueryparam cfqueryparam value=#arguments.payment.getamount_paid()# CFSQLType=cf_sql_decimal null=#not len(arguments.payment.getamount_paid())# /, works.. just having #arguments.payment.getamount_paid()# causes it to work fine.. 35.52 is saved as 35.52 in the database. Any ideas as to why this happens? I'm using CF9.0.1 On Mon, Nov 12, 2012 at 11:11 AM, Greg Morphis gmorp...@gmail.com wrote: I tried decimal(19,2) and back to smallmoney and still 36.00 gets inserted into the database table. And changed the type in the cfc to cf_sql_decimal. On Mon, Nov 12, 2012 at 10:56 AM, Greg Morphis gmorp...@gmail.comwrote: Something is baffling me.. I'm inserting a value into the database and it's rounding the number. I don't know where or why this is happening! On the action page this is what the code looks like when inserting INSERT INTO mytable ( af_id, amount_paid, is_cleared, payment_method_id, action_date, year_paid_for, notes, actionuser ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? ) Query Parameter Value(s) - Parameter #1(cf_sql_integer) = 194 *Parameter #2(cf_sql_numeric) = 35.52* Parameter #3(cf_sql_integer) = 1 Parameter #4(cf_sql_integer) = 1 Parameter #5(cf_sql_timestamp) = 2012-11-12 10:51:54.375 Parameter #6(cf_sql_integer) = 2012 Parameter #7(cf_sql_varchar) = Parameter #8(cf_sql_numeric) = 12985 When I query the database I see 36.00 The table column use to be smallmoney, now it's numeric(19,2).. Does anyone know why this might be happening? And more importantly, how to fix it!? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353131 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Rounding, why?
I tried decimal(19,2) and back to smallmoney and still 36.00 gets inserted into the database table. And changed the type in the cfc to cf_sql_decimal. On Mon, Nov 12, 2012 at 10:56 AM, Greg Morphis gmorp...@gmail.com wrote: Something is baffling me.. I'm inserting a value into the database and it's rounding the number. I don't know where or why this is happening! On the action page this is what the code looks like when inserting INSERT INTO mytable ( af_id, amount_paid, is_cleared, payment_method_id, action_date, year_paid_for, notes, actionuser ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? ) Query Parameter Value(s) - Parameter #1(cf_sql_integer) = 194 *Parameter #2(cf_sql_numeric) = 35.52* Parameter #3(cf_sql_integer) = 1 Parameter #4(cf_sql_integer) = 1 Parameter #5(cf_sql_timestamp) = 2012-11-12 10:51:54.375 Parameter #6(cf_sql_integer) = 2012 Parameter #7(cf_sql_varchar) = Parameter #8(cf_sql_numeric) = 12985 When I query the database I see 36.00 The table column use to be smallmoney, now it's numeric(19,2).. Does anyone know why this might be happening? And more importantly, how to fix it!? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353133 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SOT: returning data from ajax and displaying it..
I've got this code: myspan.innerHTML += 'ul' for(i=0; ipresentation.DATA.length; i++) { myspan.innerHTML += 'li class=grey_homepage_texta href=' + presentation.DATA[i][presentation.COLUMNS.findIdx('PATH')] + '' + presentation.DATA[i][presentation.COLUMNS.findIdx('TITLE')] + '/anbsp;nbsp;(' + presentation.DATA[i][presentation.COLUMNS.findIdx('AUTHOR')] + ')nbsp;nbsp;span style=font-size:10px;color:blue;' + presentation.DATA[i][presentation.COLUMNS.findIdx('DATE')] + /span/li } myspan.innerHTML += '/ul' And it's not working properly.. when I look in Firebug I see: span id=output h3Results for your search:/h3 ul/ul li class=grey_homepage_text a href=path_to_filefile 3/a nbsp;nbsp;(foo 2, foo 45)nbsp;nbsp; span style=font-size:10px;color:blue;02-24-2012/span /li li class=grey_homepage_text a href=path_to_filefile b/a nbsp;nbsp;(foo 1)nbsp;nbsp; span style=font-size:10px;color:blue;02-24-2012/span /li /span the ul/ul are on the same line but they're definitely outside the for loop looping over the li's. Any idea how to remedy this? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352621 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: returning data from ajax and displaying it..
Got it.. I just made a long string and then at the end set the innerHTML value to the string.. works like a charm! On Fri, Sep 14, 2012 at 2:15 PM, Greg Morphis gmorp...@gmail.com wrote: I've got this code: myspan.innerHTML += 'ul' for(i=0; ipresentation.DATA.length; i++) { myspan.innerHTML += 'li class=grey_homepage_texta href=' + presentation.DATA[i][presentation.COLUMNS.findIdx('PATH')] + '' + presentation.DATA[i][presentation.COLUMNS.findIdx('TITLE')] + '/anbsp;nbsp;(' + presentation.DATA[i][presentation.COLUMNS.findIdx('AUTHOR')] + ')nbsp;nbsp;span style=font-size:10px;color:blue;' + presentation.DATA[i][presentation.COLUMNS.findIdx('DATE')] + /span/li } myspan.innerHTML += '/ul' And it's not working properly.. when I look in Firebug I see: span id=output h3Results for your search:/h3 ul/ul li class=grey_homepage_text a href=path_to_filefile 3/a nbsp;nbsp;(foo 2, foo 45)nbsp;nbsp; span style=font-size:10px;color:blue;02-24-2012/span /li li class=grey_homepage_text a href=path_to_filefile b/a nbsp;nbsp;(foo 1)nbsp;nbsp; span style=font-size:10px;color:blue;02-24-2012/span /li /span the ul/ul are on the same line but they're definitely outside the for loop looping over the li's. Any idea how to remedy this? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352622 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfajaxproxy... not defined return variable.
I'm playing around with the cfajaxproxy example on adobe livedocs and everything looks right, I get Timestamp: 9/12/2012 10:15:55 AM Error: TypeError: presentation is null Source File: http://localhost:81/resources/demo.cfm?reset=1 Line: 44 here's the code I have.. cfajaxproxy cfc=proxy jsclassname=pres // Use an asynchronous call to get the presentations details. var confPresentations = function(tag_id, year){ var p = new pres(); p.setCallbackHandler(populateConferencePresentations); p.setErrorHandler(myErrorHandler); // Pass the tag and year to CFC getAllConferencePresentations function. p.getAllConferencePresentations(tag_id, year); } // Callback function to display the results of the getAllConferencePresentations // function. var populateConferencePresentations = function(presentation) { var pId = presentation.DATA[0][0]; ... } body form name=simpleAJAX method=post button name=getConferencePresentations onClick=confPresentations(0, 2012)Verify/button !--- set values for testing --- brbr input type=text name=year id=year value=2012 /br / input type=text name=tag_id id=tag_id value=0 /br / brbr span id=output/span /form /body And the proxy.cfc looks like: cfcomponent cfset this.dsn = mydsn cffunction name=getAllConferencePresentations access=remote output=false returntype=json cfargument name=tag_id type=numeric required=false / cfargument name=year type=numeric required=false / cfset var qList = / cfquery name=qList datasource=#this.dsn# select stuff from tables cfreturn qList / /cffunction /cfcomponent The query works fine on the other page so I know the problem is not with that. Any ideas I can try? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
Thanks Ray for the response, I get this in the console when putting a breakpoint on the var pId = ... _cf_clientid186CD443C74F6630BE78C272EDD3CB4E _cf_nocachetrue_cf_nodebug true _cf_rc0 argumentCollection{tag_id:0,year:2012} method getAllConferencePresentations returnFormatjson does that help any? On Wed, Sep 12, 2012 at 10:36 AM, Raymond Camden raymondcam...@gmail.comwrote: I'd perhaps debug this line: var populateConferencePresentations = function(presentation) You can add a breakpoint in Chrome Dev Tools or Firebug. Or - you could simply console.dir(arguments) to see what is being passed to the callback. On Wed, Sep 12, 2012 at 10:23 AM, Greg Morphis gmorp...@gmail.com wrote: I'm playing around with the cfajaxproxy example on adobe livedocs and everything looks right, I get Timestamp: 9/12/2012 10:15:55 AM Error: TypeError: presentation is null Source File: http://localhost:81/resources/demo.cfm?reset=1 Line: 44 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
Since the line throwing the error is: var popConferencePresentations = function(presentation) I put it here: console.dir(arguments); p.setCallbackHandler(popConferencePresentations); Is that right? If so, where should I see the output? Firebug shows: TypeError: presentation is null var pId = presentation.DATA[0][0]; So I put the console.dir(arguments) above var pId = presentation.DATA[0][0]; and I get the same thing in the console. Thanks! On Wed, Sep 12, 2012 at 11:17 AM, Raymond Camden raymondcam...@gmail.comwrote: Hmmm no - can you try console.dir(arguments) (immediately before the line throwing the error) and sharing what is dumped? On Wed, Sep 12, 2012 at 10:53 AM, Greg Morphis gmorp...@gmail.com wrote: Thanks Ray for the response, I get this in the console when putting a breakpoint on the var pId = ... _cf_clientid186CD443C74F6630BE78C272EDD3CB4E _cf_nocachetrue_cf_nodebug true _cf_rc0 argumentCollection{tag_id:0,year:2012} method getAllConferencePresentations returnFormatjson does that help any? On Wed, Sep 12, 2012 at 10:36 AM, Raymond Camden raymondcam...@gmail.comwrote: I'd perhaps debug this line: var populateConferencePresentations = function(presentation) You can add a breakpoint in Chrome Dev Tools or Firebug. Or - you could simply console.dir(arguments) to see what is being passed to the callback. On Wed, Sep 12, 2012 at 10:23 AM, Greg Morphis gmorp...@gmail.com wrote: I'm playing around with the cfajaxproxy example on adobe livedocs and everything looks right, I get Timestamp: 9/12/2012 10:15:55 AM Error: TypeError: presentation is null Source File: http://localhost:81/resources/demo.cfm?reset=1 Line: 44 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
Maybe I don't know how to use firebug that well but I do know they data is being returned from the query. I copied and pasted the query and put it in the cfm file, substituted the dsn name and ran it and it works. Where do I look within firebug to see what's being returned? Thanks On Wed, Sep 12, 2012 at 11:39 AM, Andrew Scott andr...@andyscott.id.auwrote: Greg, There are a multitude of reasons for this, and one of the most simplest for you to debug is what is returned from ColdFusion. For example, if it was me I would take Ray's advice and break point the JS, step over the lines and look at what is around the call and break on the call itself. Then all you need to do is make one last step over, and check the response in the Chrome or Firefox tools to see what has been returned. As the callback from your description is very basic, it means that the data is not being returned from ColdFusion as you think, or in fact nothing is being returned. Simple debug and checks can eliminate this for you, and help you discover at what point the problem is occurring. And as that call back is very simple, my $1 is on the fact that there is nothing being returned from ColdFusion. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 On Thu, Sep 13, 2012 at 2:33 AM, Greg Morphis gmorp...@gmail.com wrote: Since the line throwing the error is: var popConferencePresentations = function(presentation) I put it here: console.dir(arguments); p.setCallbackHandler(popConferencePresentations); Is that right? If so, where should I see the output? Firebug shows: TypeError: presentation is null var pId = presentation.DATA[0][0]; So I put the console.dir(arguments) above var pId = presentation.DATA[0][0]; and I get the same thing in the console. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
I use both Chrome and Firebug, can you tell me what or where to look in Chrome Dev Tools to get you guys the information needed to help? Thanks On Wed, Sep 12, 2012 at 11:51 AM, Andrew Scott andr...@andyscott.id.auwrote: I haven't used firebug in a long time, as I use Chrome now. But from memory you should be able to see from one of the tabs, the actual remote call back to the server. If you click on this call, it should show you what has been returned, as well as what is passed to the server via its headers. Also just because the query is working, doesn't mean the callback is. For example lets look at what the call back offers, and unless you are doing asynchronous calls, I wouldn't even worry about the callback. But the callback if you read the documentation, takes a JSon string an returns or passes it to the callback as a Javascript representation. So that would begin to indicate that the data being returned is not JSon, or is a malformed JSon string. Which would also throw an error when you try to use it the way you are. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352528 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
This is what's in the proxy.cfc in the network tab.. 1. Request URL: http://localhost:81/resources/proxy.cfc?method=getAllConferencePresentationsreturnFormat=jsonargumentCollection=%7B%22tag_id%22%3A0%2C%22year%22%3A2012%7D_cf_nodebug=true_cf_nocache=true_cf_clientid=235E1C59C699DA256BA5C27C5890D98B_cf_rc=0 2. Request Headersview source 1. Referer: http://localhost:81/resources/demo.cfm?reset=1cfdebug=1 2. User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1 3. Query String Parametersview URL encoded 1. method: getAllConferencePresentations 2. returnFormat: json 3. argumentCollection: {tag_id:0,year:2012} 4. _cf_nodebug: true 5. _cf_nocache: true 6. _cf_clientid: 235E1C59C699DA256BA5C27C5890D98B 7. _cf_rc: 0 On Wed, Sep 12, 2012 at 11:57 AM, Andrew Scott andr...@andyscott.id.auwrote: In Chrome, bring up the developer tools, then before you run the page, select network. Then when the call is made back to the server, you should see it in this list. I usually clear this list, so that the call is at the top. But when it is listed you just click the call, and you should see options like response. It is that tab that would show you the information that ColdFusion is returning. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 On Thu, Sep 13, 2012 at 2:54 AM, Greg Morphis gmorp...@gmail.com wrote: I use both Chrome and Firebug, can you tell me what or where to look in Chrome Dev Tools to get you guys the information needed to help? Thanks On Wed, Sep 12, 2012 at 11:51 AM, Andrew Scott andr...@andyscott.id.au wrote: I haven't used firebug in a long time, as I use Chrome now. But from memory you should be able to see from one of the tabs, the actual remote call back to the server. If you click on this call, it should show you what has been returned, as well as what is passed to the server via its headers. Also just because the query is working, doesn't mean the callback is. For example lets look at what the call back offers, and unless you are doing asynchronous calls, I wouldn't even worry about the callback. But the callback if you read the documentation, takes a JSon string an returns or passes it to the callback as a Javascript representation. So that would begin to indicate that the data being returned is not JSon, or is a malformed JSon string. Which would also throw an error when you try to use it the way you are. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
This request has no response data available That's for the proxy.cfc file On Wed, Sep 12, 2012 at 12:07 PM, Andrew Scott andr...@andyscott.id.auwrote: But what is in the response tab Greg? -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 On Thu, Sep 13, 2012 at 3:04 AM, Greg Morphis gmorp...@gmail.com wrote: This is what's in the proxy.cfc in the network tab.. 1. Request URL: http://localhost:81/resources/proxy.cfc?method=getAllConferencePresentationsreturnFormat=jsonargumentCollection=%7B%22tag_id%22%3A0%2C%22year%22%3A2012%7D_cf_nodebug=true_cf_nocache=true_cf_clientid=235E1C59C699DA256BA5C27C5890D98B_cf_rc=0 2. Request Headersview source 1. Referer: http://localhost:81/resources/demo.cfm?reset=1cfdebug=1 2. User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1 3. Query String Parametersview URL encoded 1. method: getAllConferencePresentations 2. returnFormat: json 3. argumentCollection: {tag_id:0,year:2012} 4. _cf_nodebug: true 5. _cf_nocache: true 6. _cf_clientid: 235E1C59C699DA256BA5C27C5890D98B 7. _cf_rc: 0 On Wed, Sep 12, 2012 at 11:57 AM, Andrew Scott andr...@andyscott.id.au wrote: In Chrome, bring up the developer tools, then before you run the page, select network. Then when the call is made back to the server, you should see it in this list. I usually clear this list, so that the call is at the top. But when it is listed you just click the call, and you should see options like response. It is that tab that would show you the information that ColdFusion is returning. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 On Thu, Sep 13, 2012 at 2:54 AM, Greg Morphis gmorp...@gmail.com wrote: I use both Chrome and Firebug, can you tell me what or where to look in Chrome Dev Tools to get you guys the information needed to help? Thanks On Wed, Sep 12, 2012 at 11:51 AM, Andrew Scott andr...@andyscott.id.au wrote: I haven't used firebug in a long time, as I use Chrome now. But from memory you should be able to see from one of the tabs, the actual remote call back to the server. If you click on this call, it should show you what has been returned, as well as what is passed to the server via its headers. Also just because the query is working, doesn't mean the callback is. For example lets look at what the call back offers, and unless you are doing asynchronous calls, I wouldn't even worry about the callback. But the callback if you read the documentation, takes a JSon string an returns or passes it to the callback as a Javascript representation. So that would begin to indicate that the data being returned is not JSon, or is a malformed JSon string. Which would also throw an error when you try to use it the way you are. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
The demo.cfm has this at the top and then the rest is the same cfm code headscript type=text/javascript/* ![CDATA[ */_cf_loadingtexthtml=img alt=' ' src='/CFIDE/scripts/ajax/resources/cf/images/loading.gif'/; _cf_contextpath=; _cf_ajaxscriptsrc=/CFIDE/scripts/ajax; _cf_jsonprefix='//'; _cf_clientid='235E1C59C699DA256BA5C27C5890D98B';/* ]] *//scriptscript type=text/javascript src=/CFIDE/scripts/ajax/messages/cfmessage.jshttp://localhost:81/CFIDE/scripts/ajax/messages/cfmessage.js /script script type=text/javascript src=/CFIDE/scripts/ajax/package/cfajax.js /script script type=text/javascript/* ![CDATA[ */ ColdFusion.Ajax.importTag('CFAJAXPROXY'); /* ]] *//script script type=text/javascript/* ![CDATA[ */ var _cf_proxy=ColdFusion.AjaxProxy.init('/resources/proxy.cfc','proxy'); _cf_proxy.prototype.getAllConferencePresentations=function(tag_id,year) { return ColdFusion.AjaxProxy.invoke(this, getAllConferencePresentations, { tag_id:tag_id,year:year});}; /* ]] *//script On Wed, Sep 12, 2012 at 12:11 PM, Greg Morphis gmorp...@gmail.com wrote: This request has no response data available That's for the proxy.cfc file On Wed, Sep 12, 2012 at 12:07 PM, Andrew Scott andr...@andyscott.id.auwrote: But what is in the response tab Greg? -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 On Thu, Sep 13, 2012 at 3:04 AM, Greg Morphis gmorp...@gmail.com wrote: This is what's in the proxy.cfc in the network tab.. 1. Request URL: http://localhost:81/resources/proxy.cfc?method=getAllConferencePresentationsreturnFormat=jsonargumentCollection=%7B%22tag_id%22%3A0%2C%22year%22%3A2012%7D_cf_nodebug=true_cf_nocache=true_cf_clientid=235E1C59C699DA256BA5C27C5890D98B_cf_rc=0 2. Request Headersview source 1. Referer: http://localhost:81/resources/demo.cfm?reset=1cfdebug=1 2. User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1 3. Query String Parametersview URL encoded 1. method: getAllConferencePresentations 2. returnFormat: json 3. argumentCollection: {tag_id:0,year:2012} 4. _cf_nodebug: true 5. _cf_nocache: true 6. _cf_clientid: 235E1C59C699DA256BA5C27C5890D98B 7. _cf_rc: 0 On Wed, Sep 12, 2012 at 11:57 AM, Andrew Scott andr...@andyscott.id.au wrote: In Chrome, bring up the developer tools, then before you run the page, select network. Then when the call is made back to the server, you should see it in this list. I usually clear this list, so that the call is at the top. But when it is listed you just click the call, and you should see options like response. It is that tab that would show you the information that ColdFusion is returning. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 On Thu, Sep 13, 2012 at 2:54 AM, Greg Morphis gmorp...@gmail.com wrote: I use both Chrome and Firebug, can you tell me what or where to look in Chrome Dev Tools to get you guys the information needed to help? Thanks On Wed, Sep 12, 2012 at 11:51 AM, Andrew Scott andr...@andyscott.id.au wrote: I haven't used firebug in a long time, as I use Chrome now. But from memory you should be able to see from one of the tabs, the actual remote call back to the server. If you click on this call, it should show you what has been returned, as well as what is passed to the server via its headers. Also just because the query is working, doesn't mean the callback is. For example lets look at what the call back offers, and unless you are doing asynchronous calls, I wouldn't even worry about the callback. But the callback if you read the documentation, takes a JSon string an returns or passes it to the callback as a Javascript representation. So that would begin to indicate that the data being returned is not JSon, or is a malformed JSon string. Which would also throw an error when you try to use it the way you are. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352536 Subscription: http
Re: cfajaxproxy... not defined return variable.
What's weird is if I click on the RequestURL http://localhost:81/resources/proxy.cfc?method=getAllConferencePresentationsreturnFormat=jsonargumentCollection=%7B%22tag_id%22%3A0%2C%22year%22%3A2012%7D_cf_nodebug=true_cf_nocache=true_cf_clientid=235E1C59C699DA256BA5C27C5890D98B_cf_rc=0 I get: COLUMNS:[ID,TITLE,PATH,AUTHOR,CONFERENCETITLE,TAG_ID,DATE],DATA:[[44,Affiliate,\/assets\/utilities\/serve.cfm?gid=00666248-bead-4df7-b51f-2790a9bb232e,foo,NASWA UI Committee Meeting,null,July, 16 2012 10:40:04], ... but it still highlights var pId = presentation.DATA[0][0]; saying presentation is undefined. On Wed, Sep 12, 2012 at 12:23 PM, Andrew Scott andr...@andyscott.id.auwrote: Greg, the calling page will not help you here. You need to have the network tabbed active, and then refresh the page or force the call that is having the problem. Once that call is made, it will appear in the list on the left hand side. When you click on that call, which if I read your posting is called proxy.cfc so when you see proxy.cfc appear you click on that call. Then a window will open in the network area, that has many tabs, one of which is the response. Now if you have done that, and it is showing no response data, that means the call is failing and you will need to consult your logs as to why proxy.cfc is failing. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 On Thu, Sep 13, 2012 at 3:13 AM, Greg Morphis gmorp...@gmail.com wrote: The demo.cfm has this at the top and then the rest is the same cfm code headscript type=text/javascript/* ![CDATA[ */_cf_loadingtexthtml=img alt=' ' src='/CFIDE/scripts/ajax/resources/cf/images/loading.gif'/; _cf_contextpath=; _cf_ajaxscriptsrc=/CFIDE/scripts/ajax; _cf_jsonprefix='//'; _cf_clientid='235E1C59C699DA256BA5C27C5890D98B';/* ]] *//scriptscript type=text/javascript src=/CFIDE/scripts/ajax/messages/cfmessage.js http://localhost:81/CFIDE/scripts/ajax/messages/cfmessage.js /script script type=text/javascript src=/CFIDE/scripts/ajax/package/cfajax.js /script script type=text/javascript/* ![CDATA[ */ ColdFusion.Ajax.importTag('CFAJAXPROXY'); /* ]] *//script script type=text/javascript/* ![CDATA[ */ var _cf_proxy=ColdFusion.AjaxProxy.init('/resources/proxy.cfc','proxy'); _cf_proxy.prototype.getAllConferencePresentations=function(tag_id,year) { return ColdFusion.AjaxProxy.invoke(this, getAllConferencePresentations, { tag_id:tag_id,year:year});}; /* ]] *//script ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
But under Network proxy.cfc shows Method: GET Status: (canceled) Type: Pending Initiator: cfajax.js 147 Script Size 13B 0B Time: Pending On Wed, Sep 12, 2012 at 12:36 PM, Greg Morphis gmorp...@gmail.com wrote: What's weird is if I click on the RequestURL http://localhost:81/resources/proxy.cfc?method=getAllConferencePresentationsreturnFormat=jsonargumentCollection=%7B%22tag_id%22%3A0%2C%22year%22%3A2012%7D_cf_nodebug=true_cf_nocache=true_cf_clientid=235E1C59C699DA256BA5C27C5890D98B_cf_rc=0 I get: COLUMNS:[ID,TITLE,PATH,AUTHOR,CONFERENCETITLE,TAG_ID,DATE],DATA:[[44,Affiliate,\/assets\/utilities\/serve.cfm?gid=00666248-bead-4df7-b51f-2790a9bb232e,foo,NASWA UI Committee Meeting,null,July, 16 2012 10:40:04], ... but it still highlights var pId = presentation.DATA[0][0]; saying presentation is undefined. On Wed, Sep 12, 2012 at 12:23 PM, Andrew Scott andr...@andyscott.id.auwrote: Greg, the calling page will not help you here. You need to have the network tabbed active, and then refresh the page or force the call that is having the problem. Once that call is made, it will appear in the list on the left hand side. When you click on that call, which if I read your posting is called proxy.cfc so when you see proxy.cfc appear you click on that call. Then a window will open in the network area, that has many tabs, one of which is the response. Now if you have done that, and it is showing no response data, that means the call is failing and you will need to consult your logs as to why proxy.cfc is failing. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 On Thu, Sep 13, 2012 at 3:13 AM, Greg Morphis gmorp...@gmail.com wrote: The demo.cfm has this at the top and then the rest is the same cfm code headscript type=text/javascript/* ![CDATA[ */_cf_loadingtexthtml=img alt=' ' src='/CFIDE/scripts/ajax/resources/cf/images/loading.gif'/; _cf_contextpath=; _cf_ajaxscriptsrc=/CFIDE/scripts/ajax; _cf_jsonprefix='//'; _cf_clientid='235E1C59C699DA256BA5C27C5890D98B';/* ]] *//scriptscript type=text/javascript src=/CFIDE/scripts/ajax/messages/cfmessage.js http://localhost:81/CFIDE/scripts/ajax/messages/cfmessage.js /script script type=text/javascript src=/CFIDE/scripts/ajax/package/cfajax.js /script script type=text/javascript/* ![CDATA[ */ ColdFusion.Ajax.importTag('CFAJAXPROXY'); /* ]] *//script script type=text/javascript/* ![CDATA[ */ var _cf_proxy=ColdFusion.AjaxProxy.init('/resources/proxy.cfc','proxy'); _cf_proxy.prototype.getAllConferencePresentations=function(tag_id,year) { return ColdFusion.AjaxProxy.invoke(this, getAllConferencePresentations, { tag_id:tag_id,year:year});}; /* ]] *//script ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
I'm not sure if this helps any but the Console tab is full of information: Arguments[2] 1. 0: null 2. 1: undefined 3. callee: function (presentation) 1. arguments: Arguments[2] 1. 0: null 2. 1: undefined 3. callee: function (presentation) 1. arguments: Arguments[2] 1. 0: null 2. 1: undefined 3. callee: function (presentation) 1. arguments: Arguments[2] 1. 0: null 2. 1: undefined 3. callee: function (presentation) 1. arguments: Arguments[2] 1. 0: null 2. 1: undefined On Wed, Sep 12, 2012 at 12:39 PM, Greg Morphis gmorp...@gmail.com wrote: But under Network proxy.cfc shows Method: GET Status: (canceled) Type: Pending Initiator: cfajax.js 147 Script Size 13B 0B Time: Pending On Wed, Sep 12, 2012 at 12:36 PM, Greg Morphis gmorp...@gmail.com wrote: What's weird is if I click on the RequestURL http://localhost:81/resources/proxy.cfc?method=getAllConferencePresentationsreturnFormat=jsonargumentCollection=%7B%22tag_id%22%3A0%2C%22year%22%3A2012%7D_cf_nodebug=true_cf_nocache=true_cf_clientid=235E1C59C699DA256BA5C27C5890D98B_cf_rc=0 I get: COLUMNS:[ID,TITLE,PATH,AUTHOR,CONFERENCETITLE,TAG_ID,DATE],DATA:[[44,Affiliate,\/assets\/utilities\/serve.cfm?gid=00666248-bead-4df7-b51f-2790a9bb232e,foo,NASWA UI Committee Meeting,null,July, 16 2012 10:40:04], ... but it still highlights var pId = presentation.DATA[0][0]; saying presentation is undefined. On Wed, Sep 12, 2012 at 12:23 PM, Andrew Scott andr...@andyscott.id.auwrote: Greg, the calling page will not help you here. You need to have the network tabbed active, and then refresh the page or force the call that is having the problem. Once that call is made, it will appear in the list on the left hand side. When you click on that call, which if I read your posting is called proxy.cfc so when you see proxy.cfc appear you click on that call. Then a window will open in the network area, that has many tabs, one of which is the response. Now if you have done that, and it is showing no response data, that means the call is failing and you will need to consult your logs as to why proxy.cfc is failing. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 On Thu, Sep 13, 2012 at 3:13 AM, Greg Morphis gmorp...@gmail.com wrote: The demo.cfm has this at the top and then the rest is the same cfm code headscript type=text/javascript/* ![CDATA[ */_cf_loadingtexthtml=img alt=' ' src='/CFIDE/scripts/ajax/resources/cf/images/loading.gif'/; _cf_contextpath=; _cf_ajaxscriptsrc=/CFIDE/scripts/ajax; _cf_jsonprefix='//'; _cf_clientid='235E1C59C699DA256BA5C27C5890D98B';/* ]] *//scriptscript type=text/javascript src=/CFIDE/scripts/ajax/messages/cfmessage.js http://localhost:81/CFIDE/scripts/ajax/messages/cfmessage.js /script script type=text/javascript src=/CFIDE/scripts/ajax/package/cfajax.js /script script type=text/javascript/* ![CDATA[ */ ColdFusion.Ajax.importTag('CFAJAXPROXY'); /* ]] *//script script type=text/javascript/* ![CDATA[ */ var _cf_proxy=ColdFusion.AjaxProxy.init('/resources/proxy.cfc','proxy'); _cf_proxy.prototype.getAllConferencePresentations=function(tag_id,year) { return ColdFusion.AjaxProxy.invoke(this, getAllConferencePresentations, { tag_id:tag_id,year:year});}; /* ]] *//script ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352543 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
I noticed that earlier and changed it. It still highlights the var pId = presentation.DATA[0][0]; with a null error On Wed, Sep 12, 2012 at 12:58 PM, Rodney Enke renk...@gmail.com wrote: In your cfc method try changing the returntype=json to returntype=any and add the attribute returnformat=json so you function declaration should look like: cffunction name=getAllConferencePresentations access=remote output=false returntype=any returnformat=json I have not tested this so it may not fix your problem, but I believe json isn't a valid returntype. - Rodney On Wed, Sep 12, 2012 at 12:36 PM, Greg Morphis gmorp...@gmail.com wrote: What's weird is if I click on the RequestURL http://localhost:81/resources/proxy.cfc?method=getAllConferencePresentationsreturnFormat=jsonargumentCollection=%7B%22tag_id%22%3A0%2C%22year%22%3A2012%7D_cf_nodebug=true_cf_nocache=true_cf_clientid=235E1C59C699DA256BA5C27C5890D98B_cf_rc=0 I get: COLUMNS:[ID,TITLE,PATH,AUTHOR,CONFERENCETITLE,TAG_ID,DATE],DATA:[[44,Affiliate,\/assets\/utilities\/serve.cfm?gid=00666248-bead-4df7-b51f-2790a9bb232e,foo,NASWA UI Committee Meeting,null,July, 16 2012 10:40:04], ... but it still highlights var pId = presentation.DATA[0][0]; saying presentation is undefined. On Wed, Sep 12, 2012 at 12:23 PM, Andrew Scott andr...@andyscott.id.au wrote: Greg, the calling page will not help you here. You need to have the network tabbed active, and then refresh the page or force the call that is having the problem. Once that call is made, it will appear in the list on the left hand side. When you click on that call, which if I read your posting is called proxy.cfc so when you see proxy.cfc appear you click on that call. Then a window will open in the network area, that has many tabs, one of which is the response. Now if you have done that, and it is showing no response data, that means the call is failing and you will need to consult your logs as to why proxy.cfc is failing. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 http://plus.google.com/108193156965451149543 On Thu, Sep 13, 2012 at 3:13 AM, Greg Morphis gmorp...@gmail.com wrote: The demo.cfm has this at the top and then the rest is the same cfm code headscript type=text/javascript/* ![CDATA[ */_cf_loadingtexthtml=img alt=' ' src='/CFIDE/scripts/ajax/resources/cf/images/loading.gif'/; _cf_contextpath=; _cf_ajaxscriptsrc=/CFIDE/scripts/ajax; _cf_jsonprefix='//'; _cf_clientid='235E1C59C699DA256BA5C27C5890D98B';/* ]] *//scriptscript type=text/javascript src=/CFIDE/scripts/ajax/messages/cfmessage.js http://localhost:81/CFIDE/scripts/ajax/messages/cfmessage.js /script script type=text/javascript src=/CFIDE/scripts/ajax/package/cfajax.js /script script type=text/javascript/* ![CDATA[ */ ColdFusion.Ajax.importTag('CFAJAXPROXY'); /* ]] *//script script type=text/javascript/* ![CDATA[ */ var _cf_proxy=ColdFusion.AjaxProxy.init('/resources/proxy.cfc','proxy'); _cf_proxy.prototype.getAllConferencePresentations=function(tag_id,year) { return ColdFusion.AjaxProxy.invoke(this, getAllConferencePresentations, { tag_id:tag_id,year:year});}; /* ]] *//script ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
I've tried returntype of query, string, and even taking that attribute off cffunction name=getAllConferencePresentations access=remote output=false returntype=query returnformat=json still not returning it to back to demo.cfm On Wed, Sep 12, 2012 at 1:01 PM, Greg Morphis gmorp...@gmail.com wrote: I noticed that earlier and changed it. It still highlights the var pId = presentation.DATA[0][0]; with a null error On Wed, Sep 12, 2012 at 12:58 PM, Rodney Enke renk...@gmail.com wrote: In your cfc method try changing the returntype=json to returntype=any and add the attribute returnformat=json so you function declaration should look like: cffunction name=getAllConferencePresentations access=remote output=false returntype=any returnformat=json I have not tested this so it may not fix your problem, but I believe json isn't a valid returntype. - Rodney On Wed, Sep 12, 2012 at 12:36 PM, Greg Morphis gmorp...@gmail.com wrote: What's weird is if I click on the RequestURL http://localhost:81/resources/proxy.cfc?method=getAllConferencePresentationsreturnFormat=jsonargumentCollection=%7B%22tag_id%22%3A0%2C%22year%22%3A2012%7D_cf_nodebug=true_cf_nocache=true_cf_clientid=235E1C59C699DA256BA5C27C5890D98B_cf_rc=0 I get: COLUMNS:[ID,TITLE,PATH,AUTHOR,CONFERENCETITLE,TAG_ID,DATE],DATA:[[44,Affiliate,\/assets\/utilities\/serve.cfm?gid=00666248-bead-4df7-b51f-2790a9bb232e,foo,NASWA UI Committee Meeting,null,July, 16 2012 10:40:04], ... but it still highlights var pId = presentation.DATA[0][0]; saying presentation is undefined. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
Sure thing Ray, thanks so much for helping. http://pastebin.com/2M04ZFaQ And I'm not sure if this tells you anything, Firebug gives this error: TypeError: presentation is null onreadystatechange()cfajax.js (line 125) $A.callback(req,_407,_408); On Wed, Sep 12, 2012 at 1:29 PM, Raymond Camden raymondcam...@gmail.comwrote: Can you post your entire CFM again? Please use something like pastebin or gist.github.com so it is in the clear. On Wed, Sep 12, 2012 at 1:04 PM, Greg Morphis gmorp...@gmail.com wrote: I've tried returntype of query, string, and even taking that attribute off cffunction name=getAllConferencePresentations access=remote output=false returntype=query returnformat=json still not returning it to back to demo.cfm On Wed, Sep 12, 2012 at 1:01 PM, Greg Morphis gmorp...@gmail.com wrote: I noticed that earlier and changed it. It still highlights the var pId = presentation.DATA[0][0]; with a null error On Wed, Sep 12, 2012 at 12:58 PM, Rodney Enke renk...@gmail.com wrote: In your cfc method try changing the returntype=json to returntype=any and add the attribute returnformat=json so you function declaration should look like: cffunction name=getAllConferencePresentations access=remote output=false returntype=any returnformat=json I have not tested this so it may not fix your problem, but I believe json isn't a valid returntype. - Rodney On Wed, Sep 12, 2012 at 12:36 PM, Greg Morphis gmorp...@gmail.com wrote: What's weird is if I click on the RequestURL http://localhost:81/resources/proxy.cfc?method=getAllConferencePresentationsreturnFormat=jsonargumentCollection=%7B%22tag_id%22%3A0%2C%22year%22%3A2012%7D_cf_nodebug=true_cf_nocache=true_cf_clientid=235E1C59C699DA256BA5C27C5890D98B_cf_rc=0 I get: COLUMNS:[ID,TITLE,PATH,AUTHOR,CONFERENCETITLE,TAG_ID,DATE],DATA:[[44,Affiliate,\/assets\/utilities\/serve.cfm?gid=00666248-bead-4df7-b51f-2790a9bb232e,foo,NASWA UI Committee Meeting,null,July, 16 2012 10:40:04], ... but it still highlights var pId = presentation.DATA[0][0]; saying presentation is undefined. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
I updated the pastebin to include my cfc file too. In the console I get: Arguments[2] demo.cfm:44 http://localhost:81/resources/demo.cfm why dont you freaking work demo.cfm:45http://localhost:81/resources/demo.cfm There's no arguments listed below arguments. I'll work on getting it online On Wed, Sep 12, 2012 at 1:50 PM, Raymond Camden raymondcam...@gmail.comwrote: Hmpth. This seems right. So dumb question. If you remove ALL the logic in your callback, just keep in console.dir(arguments); and maybe a console.log(why dont you freaking work); does it work correctly? Also - can you put this online? It may be a lot quicker. On Wed, Sep 12, 2012 at 1:45 PM, Greg Morphis gmorp...@gmail.com wrote: Sure thing Ray, thanks so much for helping. http://pastebin.com/2M04ZFaQ And I'm not sure if this tells you anything, Firebug gives this error: TypeError: presentation is null onreadystatechange()cfajax.js (line 125) $A.callback(req,_407,_408); On Wed, Sep 12, 2012 at 1:29 PM, Raymond Camden raymondcam...@gmail.com wrote: Can you post your entire CFM again? Please use something like pastebin or gist.github.com so it is in the clear. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
Nothing, I clicked the triangle and there's a blank line. Here's the file, thanks! http://dev.fallcomm.com/demo.cfm On Wed, Sep 12, 2012 at 2:10 PM, Raymond Camden raymondcam...@gmail.comwrote: Also - when you get arguments[2] in the console, there should be a black triangle you can click to expand it. Do that - let us know what you see. On Wed, Sep 12, 2012 at 2:02 PM, Greg Morphis gmorp...@gmail.com wrote: I updated the pastebin to include my cfc file too. In the console I get: Arguments[2] demo.cfm:44 http://localhost:81/resources/demo.cfm why dont you freaking work demo.cfm:45 http://localhost:81/resources/demo.cfm There's no arguments listed below arguments. I'll work on getting it online On Wed, Sep 12, 2012 at 1:50 PM, Raymond Camden raymondcam...@gmail.com wrote: Hmpth. This seems right. So dumb question. If you remove ALL the logic in your callback, just keep in console.dir(arguments); and maybe a console.log(why dont you freaking work); does it work correctly? Also - can you put this online? It may be a lot quicker. On Wed, Sep 12, 2012 at 1:45 PM, Greg Morphis gmorp...@gmail.com wrote: Sure thing Ray, thanks so much for helping. http://pastebin.com/2M04ZFaQ And I'm not sure if this tells you anything, Firebug gives this error: TypeError: presentation is null onreadystatechange()cfajax.js (line 125) $A.callback(req,_407,_408); On Wed, Sep 12, 2012 at 1:29 PM, Raymond Camden raymondcam...@gmail.com wrote: Can you post your entire CFM again? Please use something like pastebin or gist.github.com so it is in the clear. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajaxproxy... not defined return variable.
That's what it was.. I seem to remember running into that once before when experimenting with cfajax.. doh! Thanks for all of your help On Wed, Sep 12, 2012 at 3:12 PM, Azadi Saryev azadi.sar...@gmail.comwrote: Greg please add type=button to your button in your onlline example to prevent it from acting like a submit button and refreshing the page. when i did this in chrome dev tools, i could see the return from proxy.cfc and the arguments dump. Azadi On Thu, Sep 13, 2012 at 4:18 AM, Greg Morphis gmorp...@gmail.com wrote: Nothing, I clicked the triangle and there's a blank line. Here's the file, thanks! http://dev.fallcomm.com/demo.cfm On Wed, Sep 12, 2012 at 2:10 PM, Raymond Camden raymondcam...@gmail.com wrote: Also - when you get arguments[2] in the console, there should be a black triangle you can click to expand it. Do that - let us know what you see. On Wed, Sep 12, 2012 at 2:02 PM, Greg Morphis gmorp...@gmail.com wrote: I updated the pastebin to include my cfc file too. In the console I get: Arguments[2] demo.cfm:44 http://localhost:81/resources/demo.cfm why dont you freaking work demo.cfm:45 http://localhost:81/resources/demo.cfm There's no arguments listed below arguments. I'll work on getting it online On Wed, Sep 12, 2012 at 1:50 PM, Raymond Camden raymondcam...@gmail.com wrote: Hmpth. This seems right. So dumb question. If you remove ALL the logic in your callback, just keep in console.dir(arguments); and maybe a console.log(why dont you freaking work); does it work correctly? Also - can you put this online? It may be a lot quicker. On Wed, Sep 12, 2012 at 1:45 PM, Greg Morphis gmorp...@gmail.com wrote: Sure thing Ray, thanks so much for helping. http://pastebin.com/2M04ZFaQ And I'm not sure if this tells you anything, Firebug gives this error: TypeError: presentation is null onreadystatechange()cfajax.js (line 125) $A.callback(req,_407,_408); On Wed, Sep 12, 2012 at 1:29 PM, Raymond Camden raymondcam...@gmail.com wrote: Can you post your entire CFM again? Please use something like pastebin or gist.github.com so it is in the clear. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Strange characters displaying..
I moved the cfparams to the top of the page and the characters stopped displaying On Wed, Jun 6, 2012 at 1:53 PM, Greg Morphis gmorp...@gmail.com wrote: What's wrong with this code? It produces this output.. before cfparams  after params           cfswitch expression=#url.action#              cfcase value=get_report                 before cfparams                 cfparam name=url.report_type default=attendee_detail /                 ?cfparam name=url.conf_id default=0 /                 cfparam name=url.regtype default=m /                  after params                 cfswitch expression=#url.report_type#                    cfcase value=attendee_detail                       cfinclude template=dsp_get_report_attendee_detail.cfm/                    /c ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352071 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Strange characters displaying..
Doh, I spoke too soon.. it's showing up at the top of the page.. what in the..? By the way, this is ColdFusion 9. Thanks! On Wed, Jun 6, 2012 at 2:27 PM, Greg Morphis gmorp...@gmail.com wrote: I moved the cfparams to the top of the page and the characters stopped displaying On Wed, Jun 6, 2012 at 1:53 PM, Greg Morphis gmorp...@gmail.com wrote: What's wrong with this code? It produces this output.. before cfparams  after params           cfswitch expression=#url.action#              cfcase value=get_report                 before cfparams                 cfparam name=url.report_type default=attendee_detail /                 ?cfparam name=url.conf_id default=0 /                 cfparam name=url.regtype default=m /                  after params                 cfswitch expression=#url.report_type#                    cfcase value=attendee_detail                       cfinclude template=dsp_get_report_attendee_detail.cfm/                    /cfcase ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Making a website mobile friendly
For the people who have turned their full fledged website into a mobile ready site.. where do you start? We have a CF9 website with flash, jquery, and other javascript, some parts are kinda ugly.. Where do you begin? A whole rewrite? Can you make a separate site and when a mobile device hits your URL it goes there? What's the best way to handle making a website mobile friendly? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Making a website mobile friendly
We'll probably have to have a separate site because there's just too much to hide. I appreciate the links and comments Che and Paul! On Tue, Jul 24, 2012 at 9:52 AM, Paul Vernon paul.ver...@web-architect.co.uk wrote: What's the best way to handle making a website mobile friendly? Well that's a loaded question and the answer is, it depends... Technically, you can simply provide a CSS style sheet for handheld devices which can re-format the layout of the site and turn off elements of the page that aren't particularly suited to mobile devices or alternatively you can create a standalone site. Either way, this will depend entirely on your requirements and I've done both in the past. As examples, my own hobby site simply uses a handheld style sheet to deliver a slightly different layout for the site to make it a bit more flexible for mobiles. http://www.retro-kit.co.uk/. This approach retains most if not all of the main sites content and functionality. One of our clients sites however uses a fully optimised for mobile mini-site that driven from the same CMS and is automatically redirected to if the visitors user agent matches those defined as being handheld. The sites are served on two different sub-domains being http://www.krispykremejobs.co.uk/ and http://m.krispykremejobs.co.uk/ the latter of which is redirected to when the former is visited by a mobile. The mobile version of the site uses a much reduced set of features but enables the core functions to remain and has been quite successful in its approach. The two sites Krispy Kreme sites use a simple cookie to remember the users choice if they end up on the mobile site but would prefer to be on the full site by clicking on the View full site link in the footer. Likewise in the footer of the main site, the mobile link sets the same cookie to indicate the preference for the mobile domain. If no cookie exists the user is directed using the rule set as indicated above. This allows users with advanced smart phones capable of accessing the full site but usually identified as handheld to choose to receive the full site or vice-versa. Paul ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
handling perks or discounts
I'm working on a registration system and I'm trying to add the ability to add perks and discounts based on registration type. For example, if you register as a bronze sponsor you get a free guest, but if you sponsor and exhibit you get the free guest plus a discount off the exhibit fee based on the sponsor level you choose. I'm having a hard time making it dynamic, I just can't see it happening, tunnel vision or something.. Any ideas or thoughts would be appreciated. The system is set up like attendee (general information) attendee_conference (conference specific information per attendee) attendee_conference_sponsor (if they choose to be a sponsor, this has their sponsor information) ... The back end has: conference (main conference table) conference_sponsorlevel (has the various levels per conference) conference_sponsorperks (one to many, sponsorlevel_id to perk) The perks are not standardized, but one almost always perk is a number of free guests.. so I have a column in the conference_sponsorperks table compedRegistrants which if the perk involves an amount of free registrants then they populate that and it works it into the total. But how would I add if and only if they're an exhibitor then take, say 300, off the total? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351158 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: handling perks or discounts
So you're saying have sponsor and sponsor w/ exhibit as 2 different groups? And have the perks assigned to the groups? Maybe, I need to think about it and how involved it'll be to change the current system. Thanks for the idea! On Tue, May 15, 2012 at 9:03 AM, Russ Michaels r...@michaels.me.uk wrote: could you do it with groups. assign a user to a group, and the group they are in defines what perks they have ? so users_table userID GroupID groups_table GroupID Group_name Perks_table perkID Perk_name Perk_groups_lookup perkID groupID a perk can of course be in multiple groups, thus the lookup table On Tue, May 15, 2012 at 2:49 PM, Greg Morphis gmorp...@gmail.com wrote: I'm working on a registration system and I'm trying to add the ability to add perks and discounts based on registration type. For example, if you register as a bronze sponsor you get a free guest, but if you sponsor and exhibit you get the free guest plus a discount off the exhibit fee based on the sponsor level you choose. I'm having a hard time making it dynamic, I just can't see it happening, tunnel vision or something.. Any ideas or thoughts would be appreciated. The system is set up like attendee (general information) attendee_conference (conference specific information per attendee) attendee_conference_sponsor (if they choose to be a sponsor, this has their sponsor information) ... The back end has: conference (main conference table) conference_sponsorlevel (has the various levels per conference) conference_sponsorperks (one to many, sponsorlevel_id to perk) The perks are not standardized, but one almost always perk is a number of free guests.. so I have a column in the conference_sponsorperks table compedRegistrants which if the perk involves an amount of free registrants then they populate that and it works it into the total. But how would I add if and only if they're an exhibitor then take, say 300, off the total? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351161 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: handling perks or discounts
Right there could be multiple sponsor levels per conference and each COULD exhibit and get additional perks based on if they also choose to exhibit.. For example: Bronze: 1 free guest Bronze + Exhibit: 1 free guest $300 off Exhibit fee Silver: 2 free guests Free access to bonus event Silver + Exhibit: 2 free guests Free access to bonus event $500 off exhibit fee They could also JUST exhibit and not be a sponsor in which they would get a different perk entirely.. The system works for the sponsor level just fine, but NOT if they want to be a sponsor and choose to exhibit. They register as a sponsor, choose Silver level and if takes off 2 guests fees.. but I need to be able to ask Would you like to exhibit? and if so then apply the discount perk to the total. On Tue, May 15, 2012 at 9:19 AM, Scott Stewart webmas...@sstwebworks.comwrote: Just My $.02 It sounds like a registrant can gave multiple sponsor levels, link the sponsor level to the registrant as a one to many (one registrant can have multiple sponsor levels) with the perks based on sponsor level, as a one to many, you should be able to query for perks by registrant, through a couple of joins On 5/15/2012 9:49 AM, Greg Morphis wrote: I'm working on a registration system and I'm trying to add the ability to add perks and discounts based on registration type. For example, if you register as a bronze sponsor you get a free guest, but if you sponsor and exhibit you get the free guest plus a discount off the exhibit fee based on the sponsor level you choose. I'm having a hard time making it dynamic, I just can't see it happening, tunnel vision or something.. Any ideas or thoughts would be appreciated. The system is set up like attendee (general information) attendee_conference (conference specific information per attendee) attendee_conference_sponsor (if they choose to be a sponsor, this has their sponsor information) ... The back end has: conference (main conference table) conference_sponsorlevel (has the various levels per conference) conference_sponsorperks (one to many, sponsorlevel_id to perk) The perks are not standardized, but one almost always perk is a number of free guests.. so I have a column in the conference_sponsorperks table compedRegistrants which if the perk involves an amount of free registrants then they populate that and it works it into the total. But how would I add if and only if they're an exhibitor then take, say 300, off the total? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351163 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: handling perks or discounts
Well the registrant is either a Sponsor or Exhibitor type (right now), it's just that Sponsors could also Exhibit. Almost as if I need a flag or something.. but I still need to be able to pull additional perks. I'm not sure what you're asking though. On Tue, May 15, 2012 at 9:33 AM, Scott Stewart webmas...@sstwebworks.comwrote: can you set up exhibitor in the sponsor table and link it to it's acompanying perks? think of the sponsor table as a level table instead of a sponsor table On 5/15/2012 10:28 AM, Greg Morphis wrote: Right there could be multiple sponsor levels per conference and each COULD exhibit and get additional perks based on if they also choose to exhibit.. For example: Bronze: 1 free guest Bronze + Exhibit: 1 free guest $300 off Exhibit fee Silver: 2 free guests Free access to bonus event Silver + Exhibit: 2 free guests Free access to bonus event $500 off exhibit fee They could also JUST exhibit and not be a sponsor in which they would get a different perk entirely.. The system works for the sponsor level just fine, but NOT if they want to be a sponsor and choose to exhibit. They register as a sponsor, choose Silver level and if takes off 2 guests fees.. but I need to be able to ask Would you like to exhibit? and if so then apply the discount perk to the total. On Tue, May 15, 2012 at 9:19 AM, Scott Stewartwebmas...@sstwebworks.com wrote: Just My $.02 It sounds like a registrant can gave multiple sponsor levels, link the sponsor level to the registrant as a one to many (one registrant can have multiple sponsor levels) with the perks based on sponsor level, as a one to many, you should be able to query for perks by registrant, through a couple of joins On 5/15/2012 9:49 AM, Greg Morphis wrote: I'm working on a registration system and I'm trying to add the ability to add perks and discounts based on registration type. For example, if you register as a bronze sponsor you get a free guest, but if you sponsor and exhibit you get the free guest plus a discount off the exhibit fee based on the sponsor level you choose. I'm having a hard time making it dynamic, I just can't see it happening, tunnel vision or something.. Any ideas or thoughts would be appreciated. The system is set up like attendee (general information) attendee_conference (conference specific information per attendee) attendee_conference_sponsor (if they choose to be a sponsor, this has their sponsor information) ... The back end has: conference (main conference table) conference_sponsorlevel (has the various levels per conference) conference_sponsorperks (one to many, sponsorlevel_id to perk) The perks are not standardized, but one almost always perk is a number of free guests.. so I have a column in the conference_sponsorperks table compedRegistrants which if the perk involves an amount of free registrants then they populate that and it works it into the total. But how would I add if and only if they're an exhibitor then take, say 300, off the total? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351165 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: handling perks or discounts
It's a registrant type too, and the registrant type will get a different perk than IF it's added to a sponsor level. Exhibitor may get free access to the bonus event where as Sponsor + Exhibitor would get whatever perk is associated with that sponsor level + usually a discount on the exhibitor fee.. I apologize but I'm still confused with the path you're taking.. On Tue, May 15, 2012 at 9:50 AM, Scott Stewart webmas...@sstwebworks.comwrote: I think we've established that they can be both a sponsor and an exhibitor, You have sponsor levels (bronze, silver and gold) exhibitor just becomes another level. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351168 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: handling perks or discounts
That wont work either. Anyone could put in the coupon codes to get a lower price and if I had to check to make sure they're a sponsor and chose to exhibit to make sure the code was valid that would defeat the purpose... On Tue, May 15, 2012 at 1:19 PM, Cameron Childress camer...@gmail.comwrote: On Tue, May 15, 2012 at 9:49 AM, Greg Morphis gmorp...@gmail.com wrote: But how would I add if and only if they're an exhibitor then take, say 300, off the total? Coupon codes. -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: High school algebra problem
second the mod operator, was going to suggest the same thing: 794622: 254 794623: 255 794624: 0 794625: 1 794626: 2 794627: 3 On Mon, May 14, 2012 at 3:15 PM, Dean Lawrence dean...@gmail.com wrote: You would use the MOD Operator. #794625 MOD 256# will return 1, #794626 MOD 256# will return 2, etc. That will give you your folder number. If the result is 0, then the folder would be 256. On Mon, May 14, 2012 at 4:02 PM, Les Irvin les.cft...@gmail.com wrote: Not exactly a CF question per se, sorry... but... I'm trying to write a formula in CF and my algebra skills are rusty. I'm working with a real estate MLS system that divides their online photos, sequentially, into 256 different directories - numbered 1 through 256. When they get up to directory 256, they start back again at 1. When I asked for a reference table, they explained we don't have one, it just happens automatically. Trouble is, I need to automatically find the photos armed only with the property number. For example (actual data): property #794622 is placed in directory 254. property #794623 is placed in directory 255. property #794624 is placed in directory 256. property #794625 is placed in directory 1. property #794626 is placed in directory 2. property #794627 is placed in directory 3. ...and on and on sequentially... What formula can I use that will allow me to take any property number (say 45 or 1023465 or 332495845745, etc, etc...) and find its corresponding directory number? Thanks in advance for indulging me on this one... Les ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351142 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: isDefined inside a cfloop
you should be able to use form[veteran#v#] to get the value On Mon, Apr 30, 2012 at 9:44 AM, Steve LaBadie slaba...@po-box.esu.eduwrote: I have a form with the results being emailed to the owner of the form. I have several groups of radio buttons and checkboxes. I am using the following to check for the empty form control: Veteran: cfloop from=1 to=10 index=vcfif isDefined(FORM.Veteran#v#)cfoutput#v#/cfoutput/cfif/cfloop This does work for checking if it is empty but does not return a result if it is answered. FYI - I am still using MX7 and am in the process of upgrading to CF9, but need to get this to work for now. Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 http://www.esu.edu http://www.esu.edu/ slaba...@esu.edu ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350890 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: isDefined inside a cfloop
Why not use cfparams on the action page and default the values? You can even default their value to and then if it equals that inform the user they need to go back and choose one. Or in your form on either the Yes or No, use checked=checked to default one or the other to being checked. On Mon, Apr 30, 2012 at 10:31 AM, Steve LaBadie slaba...@po-box.esu.eduwrote: I am using radio buttons as well on the form and I get the same empty results label class=field-label-nostyle for=UnderGradstrongDo you have an Undergraduate Degree?/strong/label label class=field-label-nostyle style=margin-left: 10px !importantYes input type=radio id=UnderGrad name=UnderGrad value=Yes //label label class=field-label-nostyle style=margin-left: 10px !importantNo input type=radio name=UnderGrad value=No //label Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 http://www.esu.edu slaba...@esu.edu -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, April 30, 2012 11:28 AM To: cf-talk Subject: Re: isDefined inside a cfloop label for=VeteranVeteran:/label select name=Veteran id=Veteran optionSelect.../option option value=YesYes/option option value=NoNo/option /select Well that doesn't match what you're looking for in your form processing code at all. First, this will always have a value in your action page, and second, the name of the field will simply be form.veteran, not form.veteran plus some number. Also, you might want to use radio buttons for Boolean questions instead of select boxes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350896 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: isDefined inside a cfloop
As long as you have some separation.. something like: cfparam name=form.process default=0 / cfif isdefined(form.process) and form.process eq 1 cfparam name=form.foo default= / ... cfif form.foo eq Nothing was entered! /cfif ... !--- process form --- cfelse !--- display form --- form input type=hidden name=process value=1 / ... /cfif Something like that.. but I always separate my form from the action page, makes the code less cluttered. On Mon, Apr 30, 2012 at 12:01 PM, Steve LaBadie slaba...@po-box.esu.eduwrote: Greg, Does it matter that form and the action page are on and the same? Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 http://www.esu.edu slaba...@esu.edu -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Monday, April 30, 2012 12:12 PM To: cf-talk Subject: Re: isDefined inside a cfloop Why not use cfparams on the action page and default the values? You can even default their value to and then if it equals that inform the user they need to go back and choose one. Or in your form on either the Yes or No, use checked=checked to default one or the other to being checked. On Mon, Apr 30, 2012 at 10:31 AM, Steve LaBadie slaba...@po-box.esu.eduwrote: I am using radio buttons as well on the form and I get the same empty results label class=field-label-nostyle for=UnderGradstrongDo you have an Undergraduate Degree?/strong/label label class=field-label-nostyle style=margin-left: 10px !importantYes input type=radio id=UnderGrad name=UnderGrad value=Yes //label label class=field-label-nostyle style=margin-left: 10px !importantNo input type=radio name=UnderGrad value=No //label Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 http://www.esu.edu slaba...@esu.edu -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, April 30, 2012 11:28 AM To: cf-talk Subject: Re: isDefined inside a cfloop label for=VeteranVeteran:/label select name=Veteran id=Veteran optionSelect.../option option value=YesYes/option option value=NoNo/option /select Well that doesn't match what you're looking for in your form processing code at all. First, this will always have a value in your action page, and second, the name of the field will simply be form.veteran, not form.veteran plus some number. Also, you might want to use radio buttons for Boolean questions instead of select boxes. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350899 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Display a list of Parent and Child pages by Sort Order, with children arranged under their respective parents
Not sure if SQL Server has it, but Oracle has a START WITH CONNECT BY clause that I've used to display a menu. The table had a parentID and a childID, childern could be parents of other chlidren, for as far as you wanted to go. It looks like you'd have to go the recursive way (from the 2 minutes of googling I did). So if you don't want to go that route, Do what Maureen suggested, QoQs are nice. On Sat, Mar 24, 2012 at 9:02 PM, Maureen mamamaur...@gmail.com wrote: I would select the entire table in a query sorted by sort order, then loop over that query and do a query of queries to get the children and grandchildren for each record. On Sat, Mar 24, 2012 at 1:56 PM, Eric Bourland e...@ebwebwork.com wrote: ColdFusion 9 SQL Server 2005 Hi friends. Do you have time to consider a problem? I am trying to display a list of Parent and Child pages, with children arranged under their respective parents, thus: Parent Child Child Child Parent Child Child Child Grandchild Grandchild ...etc. There will be no more than three levels of pages: Parent, child, grandchild. If possible, I would rather not get into CTE recursion, And it would be very onerous and forbidding to change my existing data tables. Instead, I am wondering, is there simply a way to do this in ColdFusion, using a query and some JOINs, and the correct cfoutput? Here is what I have so far: !--- get table columns for parent, child, grandchild records--- cfquery name=getPages datasource=#APPLICATION.dataSource# SELECT p.PageID ,p.PageTitle ,p.DateCreated ,p.DateModified ,p.SortOrder ,c.PageID ,c.PageTitle ,c.DateCreated ,c.DateModified ,c.SortOrder ,c2.PageID ,c2.PageTitle ,c2.DateCreated ,c2.DateModified ,c2.SortOrder ,p.parentID ,c.parentID ,c2.parentID FROM #REQUEST.contentTable# p left join #REQUEST.contentTable# c on c.parentID = p.pageID left join #REQUEST.contentTable# c2 on c2.parentID = c.PageID ORDER BY p.SortOrder, p.PageTitle, c.SortOrder, c.PageTitle, c2.SortOrder, c2.PageTitle /cfquery And the output: !--- display record information --- cfoutput query=getPages group=PageTitle tr td#getPages.PageID#/td td#getPages.PageTitle#/td td#DateFormat(getPages.DateCreated, d, )#/td td#DateFormat(getPages.DateModified, d, )#/td td#getPages.SortOrder#/td /tr /cfoutput But, that gets me just a list of the pages, sorted in no particular order: http://www.hardrockteam.org/managepages2.cfm Does anyone have any ideas to sort these pages as I noted above? Thank you for any advice. Eric ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Fwd: kony2012
Kinda off topic for this list, don't you think? On Mar 11, 2012 8:08 PM, Brian Thornton br...@cfdeveloper.com wrote: Have you guys seen this video... -- Forwarded message -- From: Fred Day fs...@msn.com Date: Mar 11, 2012 9:06 PM Subject: kony2012 To: Brian Thornton vegasthorn...@gmail.com http://www.youtube.com/watch?v=Y4MnpzG5Sqc ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350356 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Fwd: kony2012
OK, go back to spamming the cf-jobs list ;) On Mar 11, 2012 8:43 PM, Brian Thornton br...@cfdeveloper.com wrote: No... I think it should be on jerrys prediction list... On Mar 11, 2012 9:23 PM, Greg Morphis gmorp...@gmail.com wrote: Kinda off topic for this list, don't you think? On Mar 11, 2012 8:08 PM, Brian Thornton br...@cfdeveloper.com wrote: Have you guys seen this video... -- Forwarded message -- From: Fred Day fs...@msn.com Date: Mar 11, 2012 9:06 PM Subject: kony2012 To: Brian Thornton vegasthorn...@gmail.com http://www.youtube.com/watch?v=Y4MnpzG5Sqc ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350358 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
The value returned from the init function is not of type
What am I missing? Need an extra set of eyes.. I've created hundreds of CFCs.. not sure what I'm missing here.. cfset foo = createobject(component, com.foosite.sponsorLevel.sponsorLevelDAO).init(DSN = application.DSN) / I get The value returned from the init function is not of type com.foosite.sponsorLevel.sponsorLevelDAO. cffunction name=init access=public output=false returntype=com.foosite.sponsorLevel.sponsorLevelDAO cfargument name=dsn type=string required=true cfset variables.dsn = arguments.dsn cfreturn this /cffunction my bean works.. cfset foo = createobject(component, com.foosite.sponsorLevel.sponsorLevel).init() / cfdump var=#foo# / When I look at cfcexplorer I see com.workforceatm.sponsorLevel.sponsorLevel for my bean, but the DAO and Gateway are foosite.com.foosite.sponsorlevel.sponsorlevelGateway Why are the other hundred or so CFCs on my site com.foosite.blah.blah but these two are foosite.com.foosite.blah.blah? Thanks in advance ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: The value returned from the init function is not of type
the beans are all showing up without the extra foosite at the beginning but the DAOs and Gateways are all showing up with it.. so there's something else going on here On Fri, Mar 9, 2012 at 1:20 PM, Greg Morphis gmorp...@gmail.com wrote: What am I missing? Need an extra set of eyes.. I've created hundreds of CFCs.. not sure what I'm missing here.. cfset foo = createobject(component, com.foosite.sponsorLevel.sponsorLevelDAO).init(DSN = application.DSN) / I get The value returned from the init function is not of type com.foosite.sponsorLevel.sponsorLevelDAO. cffunction name=init access=public output=false returntype=com.foosite.sponsorLevel.sponsorLevelDAO cfargument name=dsn type=string required=true cfset variables.dsn = arguments.dsn cfreturn this /cffunction my bean works.. cfset foo = createobject(component, com.foosite.sponsorLevel.sponsorLevel).init() / cfdump var=#foo# / When I look at cfcexplorer I see com.workforceatm.sponsorLevel.sponsorLevel for my bean, but the DAO and Gateway are foosite.com.foosite.sponsorlevel.sponsorlevelGateway Why are the other hundred or so CFCs on my site com.foosite.blah.blah but these two are foosite.com.foosite.bl ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: The value returned from the init function is not of type
Weird. I restarted CF and it's working now. 0_o On Fri, Mar 9, 2012 at 1:26 PM, Greg Morphis gmorp...@gmail.com wrote: the beans are all showing up without the extra foosite at the beginning but the DAOs and Gateways are all showing up with it.. so there's something else going on here On Fri, Mar 9, 2012 at 1:20 PM, Greg Morphis gmorp...@gmail.com wrote: What am I missing? Need an extra set of eyes.. I've created hundreds of CFCs.. not sure what I'm missing here.. cfset foo = createobject(component, com.foosite.sponsorLevel.sponsorLevelDAO).init(DSN = application.DSN) / I get The value returned from the init function is not of type com.foosite.sponsorLevel.sponsorLevelDAO. cffunction name=init access=public output=false returntype=com.foosite.sponsorLevel.sponsorLevelDAO cfargument name=dsn type=string required=true cfset variables.dsn = arguments.dsn cfreturn this /cffunction my bean works.. cfset foo = createobject(component, com.foosite.sponsorLevel.sponsorLevel).init() / cfdump var=#foo# / When I look at cfcexplorer I see com.workforceatm.sponsorLevel.sponsorLevel for my bean, but the DAO and Gateway are foosite.com.foosite.sponsorlevel.sponsorlevelGateway Why are the other hundred or so CFCs on my site com.foosite.blah.blah but these two are foosite.com.foosite.blah ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350340 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
debugging doesn't display on local sevrver
I have CF 9 developer version running on IIS 7, my server is http://localhost:81 I look in the cfadmin and the debugging options are selected, I check Application.cfc and I've got cfsetting requesttimeout=200 showdebugoutput=true enablecfoutputonly=false / And yet, there's no debugging at the bottom showing queries ran, structures, etc. Is it because I have it running in IIS or a different port? Is there a setting I turn on to allow me to see the debugging info? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349002 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging doesn't display on local sevrver
Hey Russ, thanks for the tip, removing the IP addresses worked.. apparently my IP address is ::1 Thanks! On Wed, Dec 7, 2011 at 1:01 PM, Russ Michaels r...@michaels.me.uk wrote: cf only cares about the IP address, by default it allows localhost in the IP restrictions. Try removing all the IP restrictions and see if that helps. Also are u sure you don;t have another cfsetting further down your code disabling the debugging again ? On Wed, Dec 7, 2011 at 6:53 PM, Greg Morphis gmorp...@gmail.com wrote: I have CF 9 developer version running on IIS 7, my server is http://localhost:81 I look in the cfadmin and the debugging options are selected, I check Application.cfc and I've got cfsetting requesttimeout=200 showdebugoutput=true enablecfoutputonly=false / And yet, there's no debugging at the bottom showing queries ran, structures, etc. Is it because I have it running in IIS or a different port? Is there a setting I turn on to allow me to see the debugging info? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349004 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: debugging doesn't display on local sevrver
REMOTE_ADDR=::1REMOTE_HOST=::1 right On Wed, Dec 7, 2011 at 3:36 PM, Carl Von Stetten vonner.li...@vonner.net wrote: That looks like a IPv6 address, rather than the #.#.#.# IPv4 addresses. On 12/7/2011 12:03 PM, Greg Morphis wrote: Hey Russ, thanks for the tip, removing the IP addresses worked.. apparently my IP address is ::1 Thanks! On Wed, Dec 7, 2011 at 1:01 PM, Russ Michaelsr...@michaels.me.uk wrote: cf only cares about the IP address, by default it allows localhost in the IP restrictions. Try removing all the IP restrictions and see if that helps. Also are u sure you don;t have another cfsetting further down your code disabling the debugging again ? On Wed, Dec 7, 2011 at 6:53 PM, Greg Morphisgmorp...@gmail.com wrote: I have CF 9 developer version running on IIS 7, my server is http://localhost:81 I look in the cfadmin and the debugging options are selected, I check Application.cfc and I've got cfsetting requesttimeout=200 showdebugoutput=true enablecfoutputonly=false / And yet, there's no debugging at the bottom showing queries ran, structures, etc. Is it because I have it running in IIS or a different port? Is there a setting I turn on to allow me to see the debugging info? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349011 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF 9 with IIS 7
I just did a fresh install fall cleaning.. of my PC.. I installed IIS and ColdFusion.. however I think I installed the 32 bit version of CF as oppose to the 64 bit (I had the exe saved in my backup) Anyways I have that all sorted out.. if I hit http://localhost/index.cfm I get a CF error file not found.. that's fine. I want to add a site so I can have several.. I added a site and binded it to port 81.. However when I hit http://localhost:81/index.cfm (which DOES exist).. I get an internal 500 error. I've been googling this morning and haven't found much help.. Here's what IIS shows Module: IsapiModule Notification: ExecuteRequestHandler Handler:AboMapperCustom-50513 Error Code: 0x800700c1 Requested URL: http://localhost:81/index.cfm Physical Path: C:\mysite\index.cfm Logon Method:Anonymous Logon User: Anonymous Thanks in advance! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348891 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 with IIS 7
When I installed it I told it to use IIS but I do have IIS 6 compatibility installed. I may uninstall CF 9 and reinstall it making sure I use the 64 bit version. Any other things I can look for? On Tue, Nov 29, 2011 at 10:25 AM, Scott Stewart webmas...@sstwebworks.com wrote: Did you install CF on port 8500, by chance? If it's pre 9.01, you need to have the IIS 6 compatibility mode installed (or whatever it's called), you can install this by going to programs and look for Windows Features.. The easy way is to uninstall what you have, download CF 9,01 and install in IIS 7. On Tue, Nov 29, 2011 at 11:19 AM, Greg Morphis gmorp...@gmail.com wrote: I just did a fresh install fall cleaning.. of my PC.. I installed IIS and ColdFusion.. however I think I installed the 32 bit version of CF as oppose to the 64 bit (I had the exe saved in my backup) Anyways I have that all sorted out.. if I hit http://localhost/index.cfm I get a CF error file not found.. that's fine. I want to add a site so I can have several.. I added a site and binded it to port 81.. However when I hit http://localhost:81/index.cfm (which DOES exist).. I get an internal 500 error. I've been googling this morning and haven't found much help.. Here's what IIS shows Module: IsapiModule Notification: ExecuteRequestHandler Handler: AboMapperCustom-50513 Error Code: 0x800700c1 Requested URL: http://localhost:81/index.cfm Physical Path: C:\mysite\index.cfm Logon Method: Anonymous Logon User: Anonymous Thanks in advance! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348893 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 with IIS 7
I have the site bound to port 81.. And I get an IIS error message when I hit http://localhost:81/ but I don't get an error message when I hit http://localhost:80/ On Tue, Nov 29, 2011 at 10:37 AM, Scott Stewart webmas...@sstwebworks.com wrote: do you have IIS pointing at port 81? On Tue, Nov 29, 2011 at 11:32 AM, Greg Morphis gmorp...@gmail.com wrote: When I installed it I told it to use IIS but I do have IIS 6 compatibility installed. I may uninstall CF 9 and reinstall it making sure I use the 64 bit version. Any other things I can look for? On Tue, Nov 29, 2011 at 10:25 AM, Scott Stewart webmas...@sstwebworks.com wrote: Did you install CF on port 8500, by chance? If it's pre 9.01, you need to have the IIS 6 compatibility mode installed (or whatever it's called), you can install this by going to programs and look for Windows Features.. The easy way is to uninstall what you have, download CF 9,01 and install in IIS 7. On Tue, Nov 29, 2011 at 11:19 AM, Greg Morphis gmorp...@gmail.com wrote: I just did a fresh install fall cleaning.. of my PC.. I installed IIS and ColdFusion.. however I think I installed the 32 bit version of CF as oppose to the 64 bit (I had the exe saved in my backup) Anyways I have that all sorted out.. if I hit http://localhost/index.cfm I get a CF error file not found.. that's fine. I want to add a site so I can have several.. I added a site and binded it to port 81.. However when I hit http://localhost:81/index.cfm (which DOES exist).. I get an internal 500 error. I've been googling this morning and haven't found much help.. Here's what IIS shows Module: IsapiModule Notification: ExecuteRequestHandler Handler: AboMapperCustom-50513 Error Code: 0x800700c1 Requested URL: http://localhost:81/index.cfm Physical Path: C:\mysite\index.cfm Logon Method: Anonymous Logon User: Anonymous Thanks in advance! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348895 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 with IIS 7
That'll work Russ but I'm not familiar with doing that, can you point me to a tutorial or something? How would the site be reached? Thanks On Tue, Nov 29, 2011 at 10:49 AM, Russ Michaels r...@michaels.me.uk wrote: if it works fine on port 80 then why not just stick to using port 80 ? You do not need to use a different port for each site, you just need to make sure each site has a different host header. On Tue, Nov 29, 2011 at 4:40 PM, Greg Morphis gmorp...@gmail.com wrote: I have the site bound to port 81.. And I get an IIS error message when I hit http://localhost:81/ but I don't get an error message when I hit http://localhost:80/ On Tue, Nov 29, 2011 at 10:37 AM, Scott Stewart webmas...@sstwebworks.com wrote: do you have IIS pointing at port 81? On Tue, Nov 29, 2011 at 11:32 AM, Greg Morphis gmorp...@gmail.com wrote: When I installed it I told it to use IIS but I do have IIS 6 compatibility installed. I may uninstall CF 9 and reinstall it making sure I use the 64 bit version. Any other things I can look for? On Tue, Nov 29, 2011 at 10:25 AM, Scott Stewart webmas...@sstwebworks.com wrote: Did you install CF on port 8500, by chance? If it's pre 9.01, you need to have the IIS 6 compatibility mode installed (or whatever it's called), you can install this by going to programs and look for Windows Features.. The easy way is to uninstall what you have, download CF 9,01 and install in IIS 7. On Tue, Nov 29, 2011 at 11:19 AM, Greg Morphis gmorp...@gmail.com wrote: I just did a fresh install fall cleaning.. of my PC.. I installed IIS and ColdFusion.. however I think I installed the 32 bit version of CF as oppose to the 64 bit (I had the exe saved in my backup) Anyways I have that all sorted out.. if I hit http://localhost/index.cfm I get a CF error file not found.. that's fine. I want to add a site so I can have several.. I added a site and binded it to port 81.. However when I hit http://localhost:81/index.cfm (which DOES exist).. I get an internal 500 error. I've been googling this morning and haven't found much help.. Here's what IIS shows Module: IsapiModule Notification: ExecuteRequestHandler Handler: AboMapperCustom-50513 Error Code: 0x800700c1 Requested URL: http://localhost:81/index.cfm Physical Path: C:\mysite\index.cfm Logon Method: Anonymous Logon User: Anonymous Thanks in advance! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348897 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 with IIS 7
So I should be able to add a site, All Unassigned IPs, port 81.. DefaultAppPool and be able to access it by http://localhost:81/ Right? Thanks! On Tue, Nov 29, 2011 at 10:53 AM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Tue, Nov 29, 2011 at 11:50 AM, Greg Morphis gmorp...@gmail.com wrote: That'll work Russ but I'm not familiar with doing that, can you point me to a tutorial or something? How would the site be reached? Thanks download 64Bit, I just went through re-install a couple days ago and it works fine. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348900 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 with IIS 7
That's pretty simple.. I've already uninstalled CF though. And am installing the 64 bit version. I'll attempt this is I can't get it working. I do appreciate all of your help On Tue, Nov 29, 2011 at 11:10 AM, Russ Michaels r...@michaels.me.uk wrote: open c:\windows\system32\drivers\etc\hosts file in notepad, you will need to run notepad as administrator on windows vista or windows 7 or you wont be able to save the file. at the bottom of the file just enter your desired host headers pointing at localhost, I tend to use a dev. sub-domain of the real/live domain for consistency, but you can use whatever you like e.g. 127.0.0.1 dev.mydomain1.com 127.0.0.1 dev.mydomain2.com then set the same host header in IIS for the site russ On Tue, Nov 29, 2011 at 4:53 PM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Tue, Nov 29, 2011 at 11:50 AM, Greg Morphis gmorp...@gmail.com wrote: That'll work Russ but I'm not familiar with doing that, can you point me to a tutorial or something? How would the site be reached? Thanks download 64Bit, I just went through re-install a couple days ago and it works fine. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348901 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
Leigh, you were right! That's what it was but the problem only reared it's ugly head with Access with Unicode.. Since I can't reinstall CF on our prod box your solution saved me from having to replicate the DB in Oracle and then alter the queries to match. This app may not even be used much more so unless I absolutely had to, I didn't want to rewrite it. I appreciate it! On Sat, Nov 12, 2011 at 9:59 AM, wrote: line 53* Do not take the line number as a hint. When there is an error in a query, the error is returned by the driver and CF doesn't know which line caused the error. It will indicate any line in the query. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfajax error
I was tasked in moving an old app on a CF8 server to a CF7 server. The app has some cfajax code that I'm not familiar with. I'm hoping someone here has seen the error.. This is most of an email I sent internally to the person who created in a few years back but thought I'd also ask a larger crowd The error message is a javascript popup and all it shows is: *The page at localhost:8300 says: * SyntaxError: Unexpected token This happens whenever you hit Save on the time_off page (when requesting Time Off). I've added some alerts in the code: DWRUtil.useLoadingMessage(Checking for duplicate request...); //alert(oForm.employee_id.value); //alert(oForm.time_off_start_date.value); //alert(oForm.time_off_end_date.value); DWREngine._execute(_ajaxConfig._cfscriptLocation, null, 'getEmployeeTimeOff', oForm.employee_id.value, oForm.time_off_start_date.value, oForm.time_off_end_date.value, true, handleTimeOffDuplicateCheck); //alert(getEmployeeTimeOff); And all of the alerts go off, including the getEmployeeTimeOff alert. I put an alert at the top of the handleTimeOffDuplicateCheck and it doesn't run. So it's not even making it to that function. I thought maybe it's in that CF function getEmployeeTimeOff so I changed it to static values.. SELECT tt.date_taken, Format(tt.date_taken,'mm/dd/') as text_date_taken, month(tt.date_taken) as date_taken_month, tt.time_off_id, toff.descr as time_off_descr FROM time_taken tt INNER JOIN time_off toff ON toff.time_off_id = tt.time_off_id WHERE tt.employee_id = 'e0012345' AND tt.deletedon is null AND tt.date_taken = 11/11/2011 AND tt.date_taken = 11/11/2011 ORDER BY tt.date_taken which runs in Access and returns 0 rows.. But when I try to add Time Off, same Syntax error. Then I put quotes around the dates knowing this is wrong and should give a DB error.. and it does! Javascript error about types. So it makes it to the CF function, that I assume THAT even works, and then something happens coming back but where? The alert in the Javascript function that should run on return, doesn't run.. but if you throw in an error in the query, it errors.. In Chrome, I do see a couple JavaScript errors: When choosing the person in the drop down it errors: Uncaught TypeError: Cannot set property 'checked' of undefined Which doesn't seem to affect anything.. it's still returns the employee. The element it's referring to would only be there if you're an admin. The error that bothers me is when you hit Save, it errors with: Refused to set unsafe header Referer but it makes it to CF fine, just not back.. I googled that yesterday and nothing stood out. I'm at my wits end and I don't know where else to look in the code. Was something anything that had to be installed on the system? Anything you guys can recommend, suggest, remember.. would be helpful. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348639 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
Hmm the only error Firebug shows is the same oForm.auto_approve is indefined.. it shows a POST to the ajaxfunctions.cfc and it's OK I looked at the response and I see what looks like what you'd see with CF debugging turned on, I see the query buried in the response and that looks okay.. Maybe I'm doing something wrong in Firebug though, I haven't used it much. On Fri, Nov 11, 2011 at 9:01 AM, Dave Watts dwa...@figleaf.com wrote: I was tasked in moving an old app on a CF8 server to a CF7 server. The app has some cfajax code that I'm not familiar with. I'm hoping someone here has seen the error.. If it's actually making an AJAX call, use something like Firebug to view the returned value, and you might see your error immediately. My guess is that the function is returning invalid data of some sort, which is why it's running successfully but the code that calls the function is failing. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348641 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
That would explain why it worked in Prod and gave a different error too.. holy crap, it's making sense.. Now, is there a way to turn off debugging for ajax response but leaving it on for other things? On Fri, Nov 11, 2011 at 10:12 AM, Dave Watts dwa...@figleaf.com wrote: I looked at the response and I see what looks like what you'd see with CF debugging turned on, I see the query buried in the response and that looks okay.. Maybe I'm doing something wrong in Firebug though, I haven't used it much. That's probably the problem right there. If you have CF's server-side debugging enabled for AJAX responses, that'll cause the client-side parser not to be able to read them properly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348643 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
Ahh... I thought there might be some setting in the cfadmin to change that.. Cool, now I'm getting the same error as on production.. now to start looking through logs.. thanks! On Fri, Nov 11, 2011 at 10:27 AM, Dave Watts dwa...@figleaf.com wrote: Now, is there a way to turn off debugging for ajax response but leaving it on for other things? Sure, you can do this on a per-page basis with CFSETTING. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348646 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
I did that, and even have the reverse on the pages where I want to see the debugging.. but all I get is Syntax error in INSERT INTO statement.. I hate Access! On Fri, Nov 11, 2011 at 10:41 AM, Russ Michaels r...@michaels.me.uk wrote: put a cfsetting tag at the top of your ajax pages to override debug out to NO, this will allow you to have debugging enabled on the server without breaking your ajax calls. -- Russ Michaels www.bluethunderinternet.com : Business hosting services solutions www.cfmldeveloper.com: ColdFusion developer community www.michaels.me.uk : my blog www.cfsearch.com : ColdFusion search engine sky ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348649 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
I'm good.. I just need help understanding how to do dates in MSAccess... !--- cfquery datasource=#Request.AppGlobal.ds# --- cfoutput INSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes, cfif form.auto_approve approvedon, approvedby, /cfif actionuser, actiondate, year ) VALUES ( '#form.time_off_id#', '#form.employee_id#', #dateformat(foodate,'mm/dd/')#, '#form.notes#', cfif form.auto_approve now(), '#session.user.employee_id#', /cfif '#session.user.employee_id#', now(), #year(foodate)# ) br //cfoutput !--- /cfquery --- INSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes, actionuser, actiondate, year ) VALUES ( 'VV', 'e0012345', 11/11/2011, '', 'e0012345', now(), 2011 ) Error Executing Database Query. Syntax error in INSERT INTO statement. The error occurred in *C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Production\TWST\time_off_save.cfm: line 53* 51 : '#session.user.employee_id#', 52 :now(),*53 : #year(foodate)#* 54 :) 55 :/cfquery -- SQLINSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes, actionuser, actiondate, year ) VALUES ( 'VV', 'e0012345', 11/11/2011, '', 'e0018207', now(), 2011 ) DATASOURCE blurred_text VENDORERRORCODE 3092 SQLSTATE nbsp; Resources: - Check the ColdFusion documehttp://www.macromedia.com/go/proddoc_getdoc For the love of whatever is up there.. please help if you can.. I tried removing every cfqueryparam and STILL a freaking error.. but I can manually add the date with the query that is generated. On Fri, Nov 11, 2011 at 11:21 AM, Russ Michaels r...@michaels.me.uk wrote: got a url so we can take a look ? On Fri, Nov 11, 2011 at 5:10 PM, Rick Faircloth r...@whitestonemedia.com wrote: What about setting up some alerts with your AJAX variables or using console.log in firebug for the variables to make sure they are all what your are expecting? I find I have to use multiple techniques to debug apps before tracking down a problem. hth, Rick -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Friday, November 11, 2011 11:01 AM To: cf-talk Subject: Re: cfajax error Hmm the only error Firebug shows is the same oForm.auto_approve is indefined.. it shows a POST to the ajaxfunctions.cfc and it's OK I looked at the response and I see what looks like what you'd see with CF debugging turned on, I see the query buried in the response and that looks okay.. Maybe I'm doing something wrong in Firebug though, I haven't used it much. On Fri, Nov 11, 2011 at 9:01 AM, Dave Watts dwa...@figleaf.com wrote: I was tasked in moving an old app on a CF8 server to a CF7 server. The app has some cfajax code that I'm not familiar with. I'm hoping someone here has seen the error.. If it's actually making an AJAX call, use something like Firebug to view the returned value, and you might see your error immediately. My guess is that the function is returning invalid data of some sort, which is why it's running successfully but the code that calls the function is failing. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348654 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
And time_taken looks like this time_off_id Text employee_id Text date_takenDate/Time notes Text approvedon Date/Time approvedby Text actionuserText actiondate Date/Time year Number On Fri, Nov 11, 2011 at 11:52 AM, Greg Morphis gmorp...@gmail.com wrote: I'm good.. I just need help understanding how to do dates in MSAccess... !--- cfquery datasource=#Request.AppGlobal.ds# --- cfoutput INSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes, cfif form.auto_approve approvedon, approvedby, /cfif actionuser, actiondate, year ) VALUES ( '#form.time_off_id#', '#form.employee_id#', #dateformat(foodate,'mm/dd/')#, '#form.notes#', cfif form.auto_approve now(), '#session.user.employee_id#', /cfif '#session.user.employee_id#', now(), #year(foodate)# ) br //cfoutput !--- /cfquery --- INSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes, actionuser, actiondate, year ) VALUES ( 'VV', 'e0012345', 11/11/2011, '', 'e0012345', now(), 2011 ) Error Executing Database Query. Syntax error in INSERT INTO statement. The error occurred in *C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Production\TWST\time_off_save.cfm: line 53* 51 : '#session.user.employee_id#', 52 : now(),*53 : #year(foodate)#* 54 : ) 55 : /cfquery -- SQLINSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes, actionuser, actiondate, year ) VALUES ( 'VV', 'e0012345', 11/11/2011, '', 'e0018207', now(), 2011 ) DATASOURCE blurred_text VENDORERRORCODE 3092 SQLSTATE nbsp; Resources: - Check the ColdFusion documehttp://www.macromedia.com/go/proddoc_getdoc For the love of whatever is up there.. please help if you can.. I tried removing every cfqueryparam and STILL a freaking error.. but I can manually add the date with the query that is generated. On Fri, Nov 11, 2011 at 11:21 AM, Russ Michaels r...@michaels.me.ukwrote: got a url so we can take a look ? On Fri, Nov 11, 2011 at 5:10 PM, Rick Faircloth r...@whitestonemedia.com wrote: What about setting up some alerts with your AJAX variables or using console.log in firebug for the variables to make sure they are all what your are expecting? I find I have to use multiple techniques to debug apps before tracking down a problem. hth, Rick -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Friday, November 11, 2011 11:01 AM To: cf-talk Subject: Re: cfajax error Hmm the only error Firebug shows is the same oForm.auto_approve is indefined.. it shows a POST to the ajaxfunctions.cfc and it's OK I looked at the response and I see what looks like what you'd see with CF debugging turned on, I see the query buried in the response and that looks okay.. Maybe I'm doing something wrong in Firebug though, I haven't used it much. On Fri, Nov 11, 2011 at 9:01 AM, Dave Watts dwa...@figleaf.com wrote: I was tasked in moving an old app on a CF8 server to a CF7 server. The app has some cfajax code that I'm not familiar with. I'm hoping someone here has seen the error.. If it's actually making an AJAX call, use something like Firebug to view the returned value, and you might see your error immediately. My guess is that the function is returning invalid data of some sort, which is why it's running successfully but the code that calls the function is failing. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348655 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
No, date_taken is 11/11/2011 I'll try the createodbcdateformat().. I've never had to use that with Oracle so it's something else to try On Fri, Nov 11, 2011 at 12:11 PM, Dave Watts dwa...@figleaf.com wrote: INSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes, actionuser, actiondate, year ) VALUES ( 'VV', 'e0012345', 11/11/2011, '', 'e0012345', now(), 2011 ) The field date_taken is a Date/Time field, right? You're inserting an empty string, not a Date/Time value. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
Same error.. WTH? foodate is today.. 11/11/2011 Error Executing Database Query. Syntax error in INSERT INTO statement. The error occurred in *C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\Production\TWST\time_off_save.cfm: line 53* 51 : '#session.user.employee_id#', 52 :#createodbcdate(now())#, *53 : #year(foodate)#* 54 :) 55 :/cfquery -- SQLINSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes, actionuser, actiondate, year ) VALUES ( 'VV', 'e0012345', {d '2011-11-11'}, '', 'e0012345', {d '2011-11-11'}, 2011 ) DATASOURCE blurred_text On Fri, Nov 11, 2011 at 12:13 PM, Greg Morphis gmorp...@gmail.com wrote: No, date_taken is 11/11/2011 I'll try the createodbcdateformat().. I've never had to use that with Oracle so it's something else to try On Fri, Nov 11, 2011 at 12:11 PM, Dave Watts dwa...@figleaf.com wrote: INSERT INTO time_taken ( time_off_id, employee_id, date_taken, notes, actionuser, actiondate, year ) VALUES ( 'VV', 'e0012345', 11/11/2011, '', 'e0012345', now(), 2011 ) The field date_taken is a Date/Time field, right? You're inserting an empty string, not a Date/Time value. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348660 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfajax error
So apparently the problem is within the Microsoft Access with Unicode driver.. However we don't have the ODBC service installed on production. I googled manually installing it and it mentioned some SequeLink folder in the db directory.. There's no DB folder or a SequeLink folder.. How can I download these files and set up this service? On Fri, Nov 11, 2011 at 12:25 PM, Dave Watts dwa...@figleaf.com wrote: No, date_taken is 11/11/2011 Sorry, I didn't even see the first item in the VALUES list. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Manual install ODBC services ColdFusion MX7
I'm trying to follow this page: http://kb2.adobe.com/cps/191/tn_19135.html However the directory doesn't exist on our production server.. I copied it from our dev directory to prod.. The page mentions running a CF template: !--- set this to the location of your cfusion directory --- cfset cfusionHome=C:\CFusionMX7 !--- install sequelink --- cftry cfexecute name=#cfusionHome#\db\SequeLink Setup\Setup.exe arguments='!TargetDir=#cfusionHome# !DoDNS=true'/cfexecute cfregistryaction=setbranch =HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\Install Data\ColdFusion MX entry=SqlLinktype=String value=#cfusionHome#\db\slserver54 cfcatch type=Any cfoutput font color=redError Occurred:/font #cfcatch.message#br#cfcatch.detail#p /cfoutput /cfcatch /cftry Is there a way I can manually run the setup in a command line to get the same results? Double clicking on setup.exe yields an Install Shield that never goes away Thanks in advance ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348672 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Manual install ODBC services ColdFusion MX7
it installed but installed incorrectly.. The bin folder is in slserver54 but the service points to slserver52.. I modified the registry to point to slserver54 but get an error when trying to launch the service.. something like 'could not start the service, no error was returned, if you continue to experience this contact your system administrator' I'm copying the db folder from CF8 and will try again, I don't know what else to do. On Fri, Nov 11, 2011 at 2:33 PM, Dave Watts dwa...@figleaf.com wrote: I'm trying to follow this page: http://kb2.adobe.com/cps/191/tn_19135.html However the directory doesn't exist on our production server.. I copied it from our dev directory to prod.. Which directory, exactly, doesn't exist on your production server? The page mentions running a CF template: !--- set this to the location of your cfusion directory --- cfset cfusionHome=C:\CFusionMX7 !--- install sequelink --- cftry cfexecute name=#cfusionHome#\db\SequeLink Setup\Setup.exe arguments='!TargetDir=#cfusionHome# !DoDNS=true'/cfexecute cfregistryaction=setbranch =HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\Install Data\ColdFusion MX entry=SqlLinktype=String value=#cfusionHome#\db\slserver54 cfcatch type=Any cfoutput font color=redError Occurred:/font #cfcatch.message#br#cfcatch.detail#p /cfoutput /cfcatch /cftry Is there a way I can manually run the setup in a command line to get the same results? Double clicking on setup.exe yields an Install Shield that never goes away Sure. Navigate to the directory in question, then type 'setup.exe !TargetDir=your_cf_directory_goes_here !DoDNS=true'. At least, that's what it looks like it should be to me. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Manual install ODBC services ColdFusion MX7
Screw Access.. I'm creating the tables in Oracle and exporting the data.. I'll deal with fixing the queries.. Thanks for all of your help guys! On Fri, Nov 11, 2011 at 2:42 PM, Greg Morphis gmorp...@gmail.com wrote: it installed but installed incorrectly.. The bin folder is in slserver54 but the service points to slserver52.. I modified the registry to point to slserver54 but get an error when trying to launch the service.. something like 'could not start the service, no error was returned, if you continue to experience this contact your system administrator' I'm copying the db folder from CF8 and will try again, I don't know what else to do. On Fri, Nov 11, 2011 at 2:33 PM, Dave Watts dwa...@figleaf.com wrote: I'm trying to follow this page: http://kb2.adobe.com/cps/191/tn_19135.html However the directory doesn't exist on our production server.. I copied it from our dev directory to prod.. Which directory, exactly, doesn't exist on your production server? The page mentions running a CF template: !--- set this to the location of your cfusion directory --- cfset cfusionHome=C:\CFusionMX7 !--- install sequelink --- cftry cfexecute name=#cfusionHome#\db\SequeLink Setup\Setup.exe arguments='!TargetDir=#cfusionHome# !DoDNS=true'/cfexecute cfregistryaction=setbranch =HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\Install Data\ColdFusion MX entry=SqlLinktype=String value=#cfusionHome#\db\slserver54 cfcatch type=Any cfoutput font color=redError Occurred:/font #cfcatch.message#br#cfcatch.detail#p /cfoutput /cfcatch /cftry Is there a way I can manually run the setup in a command line to get the same results? Double clicking on setup.exe yields an Install Shield that never goes away Sure. Navigate to the directory in question, then type 'setup.exe !TargetDir=your_cf_directory_goes_here !DoDNS=true'. At least, that's what it looks like it should be to me. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Manual install ODBC services ColdFusion MX7
Yeah, see my other post.. I can't get a simple insert to work from CF On Fri, Nov 11, 2011 at 4:00 PM, Leigh cfsearch...@yahoo.com wrote: Not to discourage you from switching, but was there a reason you could not just use the access unicode driver? -Leig ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348682 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Access with Unicode error
I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Stripping out special characters...
rereplace(string, [^a-zA-Z0-9-_], , all) On Fri, Nov 4, 2011 at 9:30 AM, Dennis Belmont membersh...@dennisbelmont.com wrote: I'd like to create a function that reviews a string and replaces all characters that aren't alphanumeric, or a dash or underscore. These will generally be short strings, and the function will be used for things like creating friendly page names from navigation text. Some characters would be converted to specific things (spaces to dashes or underscores, ampersands to the word and, etc. ) - that's the easy part because I can look for specific ASCII characters and use Replace() - but most will simply be dropped. For example: navigation text examples = How Do I Join?* The Final Word RD desired converted strings = How-Do-I-Join The-Final-Word R-and-D I thought about looping the strings as a list using spaces as a delimiter, then replacing anything that isn't in a specific ascii range (the letters and numbers), but since I have to look at every character in the string that doesn't work. There's got to be an easier way than doing a replace for every possible ASCII, right? Thanks in advance for any input! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348432 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Stripping out special characters...
I should have read the rest of your question.. I think you'll have to do it multiple times since it's not a blanket replace.. but maybe someone else has another idea On Fri, Nov 4, 2011 at 9:34 AM, Greg Morphis gmorp...@gmail.com wrote: rereplace(string, [^a-zA-Z0-9-_], , all) On Fri, Nov 4, 2011 at 9:30 AM, Dennis Belmont membersh...@dennisbelmont.com wrote: I'd like to create a function that reviews a string and replaces all characters that aren't alphanumeric, or a dash or underscore. These will generally be short strings, and the function will be used for things like creating friendly page names from navigation text. Some characters would be converted to specific things (spaces to dashes or underscores, ampersands to the word and, etc. ) - that's the easy part because I can look for specific ASCII characters and use Replace() - but most will simply be dropped. For example: navigation text examples = How Do I Join?* The Final Word RD desired converted strings = How-Do-I-Join The-Final-Word R-and-D I thought about looping the strings as a list using spaces as a delimiter, then replacing anything that isn't in a specific ascii range (the letters and numbers), but since I have to look at every character in the string that doesn't work. There's got to be an easier way than doing a replace for every possible ASCII, right? Thanks in advance for any input! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access with Unicode error
Is this the driver: com.inzoom.adojni ? I might be able to snag it off the dev server and put it on prod.. I assume that'll require a CF service restart? Thanks Russ! On Fri, Nov 4, 2011 at 11:01 AM, Russ Michaels r...@michaels.me.uk wrote: how uncanny I had this issue just yesterday on a Chinese site that required MSAccess with unicode. You could try with another database to if if the cause is the JDBC driver or the database, Get a newer version of JDBC driver if available. MSAccess is a PITA and has a tendency to corrupt and cause server issues and then you cannot back it up due to the lock file, I would just upsize it to SQL Server if I were and be done with it. Remember that MSSQL Express is also FREE, so it doesn't need to cost your client anything, On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis gmorp...@gmail.com wrote: I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348439 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access with Unicode error
Where is this driver at? I just searched the C, D and E drives and came up empty handed. On Fri, Nov 4, 2011 at 11:19 AM, Russ Michaels r...@michaels.me.uk wrote: yes that's the one and yes cf will need to be restarted On Fri, Nov 4, 2011 at 4:14 PM, Greg Morphis gmorp...@gmail.com wrote: Is this the driver: com.inzoom.adojni ? I might be able to snag it off the dev server and put it on prod.. I assume that'll require a CF service restart? Thanks Russ! On Fri, Nov 4, 2011 at 11:01 AM, Russ Michaels r...@michaels.me.uk wrote: how uncanny I had this issue just yesterday on a Chinese site that required MSAccess with unicode. You could try with another database to if if the cause is the JDBC driver or the database, Get a newer version of JDBC driver if available. MSAccess is a PITA and has a tendency to corrupt and cause server issues and then you cannot back it up due to the lock file, I would just upsize it to SQL Server if I were and be done with it. Remember that MSSQL Express is also FREE, so it doesn't need to cost your client anything, On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis gmorp...@gmail.com wrote: I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access with Unicode error
Not sure if that worked or if a simple service restart worked but it's working now. The files were all the same file size and same dates as well, but either way. Thanks Russ! On Fri, Nov 4, 2011 at 1:03 PM, Russ Michaels r...@michaels.me.uk wrote: izmado.jar is the file you want On Fri, Nov 4, 2011 at 4:32 PM, Greg Morphis gmorp...@gmail.com wrote: Where is this driver at? I just searched the C, D and E drives and came up empty handed. On Fri, Nov 4, 2011 at 11:19 AM, Russ Michaels r...@michaels.me.uk wrote: yes that's the one and yes cf will need to be restarted On Fri, Nov 4, 2011 at 4:14 PM, Greg Morphis gmorp...@gmail.com wrote: Is this the driver: com.inzoom.adojni ? I might be able to snag it off the dev server and put it on prod.. I assume that'll require a CF service restart? Thanks Russ! On Fri, Nov 4, 2011 at 11:01 AM, Russ Michaels r...@michaels.me.uk wrote: how uncanny I had this issue just yesterday on a Chinese site that required MSAccess with unicode. You could try with another database to if if the cause is the JDBC driver or the database, Get a newer version of JDBC driver if available. MSAccess is a PITA and has a tendency to corrupt and cause server issues and then you cannot back it up due to the lock file, I would just upsize it to SQL Server if I were and be done with it. Remember that MSSQL Express is also FREE, so it doesn't need to cost your client anything, On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis gmorp...@gmail.com wrote: I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Access with Unicode error
Low traffic and it wont be used for long, we have an Oracle database if I ever wanted to port it over. Thanks! On Fri, Nov 4, 2011 at 2:14 PM, Russ Michaels r...@michaels.me.uk wrote: unless it is very low traffic DB, i'd still upsize it to MSSQL On Fri, Nov 4, 2011 at 7:04 PM, Greg Morphis gmorp...@gmail.com wrote: Not sure if that worked or if a simple service restart worked but it's working now. The files were all the same file size and same dates as well, but either way. Thanks Russ! On Fri, Nov 4, 2011 at 1:03 PM, Russ Michaels r...@michaels.me.uk wrote: izmado.jar is the file you want On Fri, Nov 4, 2011 at 4:32 PM, Greg Morphis gmorp...@gmail.com wrote: Where is this driver at? I just searched the C, D and E drives and came up empty handed. On Fri, Nov 4, 2011 at 11:19 AM, Russ Michaels r...@michaels.me.uk wrote: yes that's the one and yes cf will need to be restarted On Fri, Nov 4, 2011 at 4:14 PM, Greg Morphis gmorp...@gmail.com wrote: Is this the driver: com.inzoom.adojni ? I might be able to snag it off the dev server and put it on prod.. I assume that'll require a CF service restart? Thanks Russ! On Fri, Nov 4, 2011 at 11:01 AM, Russ Michaels r...@michaels.me.uk wrote: how uncanny I had this issue just yesterday on a Chinese site that required MSAccess with unicode. You could try with another database to if if the cause is the JDBC driver or the database, Get a newer version of JDBC driver if available. MSAccess is a PITA and has a tendency to corrupt and cause server issues and then you cannot back it up due to the lock file, I would just upsize it to SQL Server if I were and be done with it. Remember that MSSQL Express is also FREE, so it doesn't need to cost your client anything, On Fri, Nov 4, 2011 at 2:32 PM, Greg Morphis gmorp...@gmail.com wrote: I've got an old app that has to move servers and I successfully have it running on our dev server. However I can't get the DSN created on our prod server (which should be the same as dev). When I try to create it, I get: Connection verification failed for data source: twst_prod com.inzoom.adojni.ComException: Unspecified error The root cause was that: com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1 We don't have the ODBC Service running on Prod, so I can't try just plain Microsoft Access. I saw this article: http://kb2.adobe.com/cps/000/2d2a7a19.html Control panel - admin tools - ODBC Data Source Admin I created the DSN there and tried to map a DSN to it using the settings in the article. I get a different error: Connection verification failed for data source: twst_prod1 com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider for ODBC Drivers code=0 Type=1 It's a 2 MB access file.. I don't think it's going to exceed the system resources. Is there another way to do this that I'm not aware of? Anything else I can check? Or do I need to convert this to a different database ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348450 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
element undefined in String
this morning I refreshed my local dev and although I haven't have problems in months.. this morning I get Element USER is undefined in a Java object of type class [Ljava.lang.String;. The line ColdFusion points to is: cfif session.user.getid() neq 0 and session.user.getsec_id() neq 0 In the Application.cfc OnSessionStart I have: cfset qUser = createObject(component, com.mydev.sec_login.sec_login).init( ) / cfparam name=session.user default=#qUser# type=struct / This has worked for a long time and only now getting this error.. What gives? When the session is created it should have those default values by the initialization of the bean. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348405 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: element undefined in String
disregard.. I put in a default session.user variable on the page indicated in the error and it pointed me to an error in a CFC I had overlooked late yesterday.. I had typed cfqueryparam name=foo... cfqueryparam doesn't have a name attribute. It should have been value=foo I changed that to value, restarted the service and I'm golden.. On Wed, Nov 2, 2011 at 8:36 AM, Greg Morphis gmorp...@gmail.com wrote: this morning I refreshed my local dev and although I haven't have problems in months.. this morning I get Element USER is undefined in a Java object of type class [Ljava.lang.String;. The line ColdFusion points to is: cfif session.user.getid() neq 0 and session.user.getsec_id() neq 0 In the Application.cfc OnSessionStart I have: cfset qUser = createObject(component, com.mydev.sec_login.sec_login).init( ) / cfparam name=session.user default=#qUser# type=struct / This has worked for a long time and only now getting this error.. What gives? When the session is created it should have those default values by the initialization of the bean. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Wysiwyg editor
What Wysiwyg editor do you guys recommend? We're using the built in fckEditor and people are complaining about pop up warnings from copying and pasting from Word. I believe they are browser security issues but I'm trying to investigate other options ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm