Re: XML Issues with webservices
Ok I've discovered what I think is the root of the problem. I have got the cfc to do a dump of the arguments scope into a cfsavecontent tag and pass that back. When the component is called locally it passes back my orginal xml request. However when I call it as a webservice I get back what looks like a java class named object of org.apache.xerces.dom.DeferredDocumentImpl This means that any operations I perform on this object fail as it is no longer an xml object. Is this a bug with Coldfusion, or should it be doing this for some reason? Surely I can't be the only person that wants to feed a cfc xml via a webservice, or can I? I'm running CF8.01 on IIS, so if it is a bug there's probably not a lot I can do. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323194 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need a fresh perspective
Not sure if this will help or not, but do you needs the PollFK field in the times table. Surely your relationshp is Event -- Date -- Time. If you do a query with some outer joins you should then be able to return Event 1 Date 1 Time 1 Event 1 Date 1 Time 2 Event 1 Date 2 Time 3 Event 2 Date 3 Time 4 Event 2 Date 3 Time 5 and so on. I've been working on an event scheduling application for the past 2 weeks. I'm pretty close to wrapping it up but have now run into an issue on my last part of the display. I'm thinking my data model might be the issue and would like to get some ideas from people on how I might be able to fix it. The way this thing works is: Step 1. user Creates a Title and description for their event Step 2. the user can select as many dates as they want step 3. the user enters in multiple times for each date they selected The structure I'm using for storing the data looks like: Table 1 PollID|UserID|Title|Description Table 2 DateID|PollFK|DateValue Table 3 DateFK|PollFK|TimeValue|Order This structure made the most sense to me only because they can add any number of dates that they want so if they added 15 dates I create a new row for each date and the ID for that date will then relate to the times they enter in step 3. This is what one event might look like in these 3 tables Table 1 PollID | UserID | Title | Description 1 25My Title My Description Table 2 DateID | PollFK | DateValue 112009-06-25 212009-06-26 312009-07-27 Table 3 DateFK | PollFK | TimeValue | Order 1 19:00 AM 1 1 110:00 AM2 1 112:00 PM3 2 111:00 AM1 2 112:00 PM2 3 1 6:30 PM 1 In My last display page I need to show a table similar to this: June July Wed 25 Thur 26 Wed 01 9:00 AM 10:00 AM 12:00 PM11:00 AM 12:00 PM6:30 PM I'm just really struggling to get this layout done with multiple queries. I'm doing one query to group the dates by month then going back and getting the days that were entered in for that month which I can do fine but I can't get the display to show up as I showed above. So I guess my 2 questions are: 1. Does anyone see a more efficient way to store the dates and times, keeping in mind that a user can add as many dates as they want, so creating x amount of columns doesn't really seem feasible. 2. What would be the best way to build my display page? Thanks, Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323195 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need a fresh perspective
@ Jim: i think he does need PollFK in the times table - what if several events are scheduled for same date? @Ben: you data structure look fine. i guess your query that retrieves event's data needs to be tweaked... you definitely DO NOT need SEEVRAL queries - you need just ONE query. can you post what queries you have now? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 05/06/2009 16:49, Jim Cumming wrote: Not sure if this will help or not, but do you needs the PollFK field in the times table. Surely your relationshp is Event -- Date -- Time. If you do a query with some outer joins you should then be able to return Event 1 Date 1 Time 1 Event 1 Date 1 Time 2 Event 1 Date 2 Time 3 Event 2 Date 3 Time 4 Event 2 Date 3 Time 5 and so on. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323196 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need a fresh perspective
Ben, in my Thunderbird you desired query output looks all warped - i can't make out exactly how you need it diplayed... can you try and post it formatted with tabs, or maybe just describe it in words? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 05/06/2009 12:34, Ben Densmore wrote: I've been working on an event scheduling application for the past 2 weeks. I'm pretty close to wrapping it up but have now run into an issue on my last part of the display. I'm thinking my data model might be the issue and would like to get some ideas from people on how I might be able to fix it. The way this thing works is: Step 1. user Creates a Title and description for their event Step 2. the user can select as many dates as they want step 3. the user enters in multiple times for each date they selected The structure I'm using for storing the data looks like: Table 1 PollID|UserID|Title|Description Table 2 DateID|PollFK|DateValue Table 3 DateFK|PollFK|TimeValue|Order This structure made the most sense to me only because they can add any number of dates that they want so if they added 15 dates I create a new row for each date and the ID for that date will then relate to the times they enter in step 3. This is what one event might look like in these 3 tables Table 1 PollID | UserID | Title | Description 1 25My Title My Description Table 2 DateID | PollFK | DateValue 112009-06-25 212009-06-26 312009-07-27 Table 3 DateFK | PollFK | TimeValue | Order 1 19:00 AM 1 1 110:00 AM2 1 112:00 PM3 2 111:00 AM1 2 112:00 PM2 3 1 6:30 PM 1 In My last display page I need to show a table similar to this: June July Wed 25 Thur 26 Wed 01 9:00 AM 10:00 AM 12:00 PM11:00 AM 12:00 PM6:30 PM I'm just really struggling to get this layout done with multiple queries. I'm doing one query to group the dates by month then going back and getting the days that were entered in for that month which I can do fine but I can't get the display to show up as I showed above. So I guess my 2 questions are: 1. Does anyone see a more efficient way to store the dates and times, keeping in mind that a user can add as many dates as they want, so creating x amount of columns doesn't really seem feasible. 2. What would be the best way to build my display page? Thanks, Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323197 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML Issues with webservices
Ok I've discovered what I think is the root of the problem. I have got the cfc to do a dump of the arguments scope into a cfsavecontent tag and pass that back. When the component is called locally it passes back my orginal xml request. However when I call it as a webservice I get back what looks like a java class named object of org.apache.xerces.dom.DeferredDocumentImpl This means that any operations I perform on this object fail as it is no longer an xml object. Is this a bug with Coldfusion, or should it be doing this for some reason? Surely I can't be the only person that wants to feed a cfc xml via a webservice, or can I? I'm running CF8.01 on IIS, so if it is a bug there's probably not a lot I can do. Have you tried converting it to an XML object? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323198 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need a fresh perspective
Hi Azadi, Here is an image of what the output should ultimately be. http://wedapstudios.com/table.png Right now my first query to get the Grouped months looks like this: Select mtsch_DateID, date_format(mtsch_DateVal, '%M') as Month, count(*) as Amount From mtsch_dates Where mtsch_PollFK = cfqueryparam cfsqltype=cf_sql_integer value=#arguments.pollID# / group by date_format(mtsch_DateVal, '%M') Order by mtsch_DateVal I'm then passing in the DateID to another function to grab the list of days: Select mtsch_DateVal as Days,mtsch_DateID From mtsch_dates Where mtsch_PollFK = cfqueryparam cfsqltype=cf_sql_integer value=#arguments.pollID# / Anddate_format(mtsch_DateVal, '%M') = cfqueryparam cfsqltype=cf_sql_varchar value=#arguments.monthvalue / I know I can probably get this all in one query but was having a hard time getting it completely right. I since deleted the query I was using to get the grouped months and then the days. I'll try and tackle doing it all in one query again. Thanks, Ben On Fri, Jun 5, 2009 at 8:26 AM, Azadi Saryev az...@sabai-dee.com wrote: Ben, in my Thunderbird you desired query output looks all warped - i can't make out exactly how you need it diplayed... can you try and post it formatted with tabs, or maybe just describe it in words? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 05/06/2009 12:34, Ben Densmore wrote: I've been working on an event scheduling application for the past 2 weeks. I'm pretty close to wrapping it up but have now run into an issue on my last part of the display. I'm thinking my data model might be the issue and would like to get some ideas from people on how I might be able to fix it. The way this thing works is: Step 1. user Creates a Title and description for their event Step 2. the user can select as many dates as they want step 3. the user enters in multiple times for each date they selected The structure I'm using for storing the data looks like: Table 1 PollID|UserID|Title|Description Table 2 DateID|PollFK|DateValue Table 3 DateFK|PollFK|TimeValue|Order This structure made the most sense to me only because they can add any number of dates that they want so if they added 15 dates I create a new row for each date and the ID for that date will then relate to the times they enter in step 3. This is what one event might look like in these 3 tables Table 1 PollID | UserID | Title | Description 1 25My Title My Description Table 2 DateID | PollFK | DateValue 112009-06-25 212009-06-26 312009-07-27 Table 3 DateFK | PollFK | TimeValue | Order 1 19:00 AM 1 1 110:00 AM2 1 112:00 PM3 2 111:00 AM1 2 112:00 PM2 3 1 6:30 PM 1 In My last display page I need to show a table similar to this: June July Wed 25 Thur 26 Wed 01 9:00 AM 10:00 AM 12:00 PM11:00 AM 12:00 PM6:30 PM I'm just really struggling to get this layout done with multiple queries. I'm doing one query to group the dates by month then going back and getting the days that were entered in for that month which I can do fine but I can't get the display to show up as I showed above. So I guess my 2 questions are: 1. Does anyone see a more efficient way to store the dates and times, keeping in mind that a user can add as many dates as they want, so creating x amount of columns doesn't really seem feasible. 2. What would be the best way to build my display page? Thanks, Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323199 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need a fresh perspective
that's a tricky layout... but only from css part! on the cf part all you need is one query to pull all data (with 2 extra columns aliased to store extracted YEAR** and MONTH from event's dates) and the nested cfoutputs with GROUP attributes: first by year column, then month column, then date column, then finally a cfoutput without any grouping for the times and checkboxes. ** you will need a year as separate column for cases when an event spans over Dec 31 Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 05/06/2009 20:24, Ben Densmore wrote: Hi Azadi, Here is an image of what the output should ultimately be. http://wedapstudios.com/table.png Right now my first query to get the Grouped months looks like this: Select mtsch_DateID, date_format(mtsch_DateVal, '%M') as Month, count(*) as Amount From mtsch_dates Where mtsch_PollFK = cfqueryparam cfsqltype=cf_sql_integer value=#arguments.pollID# / group by date_format(mtsch_DateVal, '%M') Order by mtsch_DateVal I'm then passing in the DateID to another function to grab the list of days: Select mtsch_DateVal as Days,mtsch_DateID From mtsch_dates Where mtsch_PollFK = cfqueryparam cfsqltype=cf_sql_integer value=#arguments.pollID# / Anddate_format(mtsch_DateVal, '%M') = cfqueryparam cfsqltype=cf_sql_varchar value=#arguments.monthvalue / I know I can probably get this all in one query but was having a hard time getting it completely right. I since deleted the query I was using to get the grouped months and then the days. I'll try and tackle doing it all in one query again. Thanks, Ben On Fri, Jun 5, 2009 at 8:26 AM, Azadi Saryev az...@sabai-dee.com wrote: Ben, in my Thunderbird you desired query output looks all warped - i can't make out exactly how you need it diplayed... can you try and post it formatted with tabs, or maybe just describe it in words? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 05/06/2009 12:34, Ben Densmore wrote: I've been working on an event scheduling application for the past 2 weeks. I'm pretty close to wrapping it up but have now run into an issue on my last part of the display. I'm thinking my data model might be the issue and would like to get some ideas from people on how I might be able to fix it. The way this thing works is: Step 1. user Creates a Title and description for their event Step 2. the user can select as many dates as they want step 3. the user enters in multiple times for each date they selected The structure I'm using for storing the data looks like: Table 1 PollID|UserID|Title|Description Table 2 DateID|PollFK|DateValue Table 3 DateFK|PollFK|TimeValue|Order This structure made the most sense to me only because they can add any number of dates that they want so if they added 15 dates I create a new row for each date and the ID for that date will then relate to the times they enter in step 3. This is what one event might look like in these 3 tables Table 1 PollID | UserID | Title | Description 1 25My Title My Description Table 2 DateID | PollFK | DateValue 112009-06-25 212009-06-26 312009-07-27 Table 3 DateFK | PollFK | TimeValue | Order 1 19:00 AM 1 1 110:00 AM2 1 112:00 PM3 2 111:00 AM1 2 112:00 PM2 3 1 6:30 PM 1 In My last display page I need to show a table similar to this: June July Wed 25 Thur 26 Wed 01 9:00 AM 10:00 AM 12:00 PM11:00 AM 12:00 PM6:30 PM I'm just really struggling to get this layout done with multiple queries. I'm doing one query to group the dates by month then going back and getting the days that were entered in for that month which I can do fine but I can't get the display to show up as I showed above. So I guess my 2 questions are: 1. Does anyone see a more efficient way to store the dates and times, keeping in mind that a user can add as many dates as they want, so creating x amount of columns doesn't really seem feasible. 2. What would be the best way to build my display page? Thanks, Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323200 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XML Issues with webservices
Hi Dave, I've tried doing an xmlParse(variable_name) before performing any operations but that errors as well. Is there another method of converting into xml I should know about? Cheers Jim Have you tried converting it to an XML object? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323201 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: XML Issues with webservices
Hi Dave, I've tried doing an xmlParse(variable_name) before performing any operations but that errors as well. Is there another method of converting into xml I should know about? Off the top of my head, I wouldn't be surprised if you have to convert it to a string first. Most Java classes have a toString() method you can invoke. You'd then have to use xmlParse to convert it back into XML. Alternatively, you could just return a string in the first place, instead of XML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323202 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP Problem - is file type extension required?
Dave and Brad, Thanks a bunch for your attention to this matter. I finally got to speak with the author of the web service and he told me that the web service is expecting a web connection with cookie and session ID on the client side. I see Brad noted that a cookie could be part of the problem so I can use the cfhttpparam as he suggests. I'm not sure about the sessionID but I'll try to figure something out. I guess that when CF calls the page from CFHTTP the cookie and session ID are not established (provided) whereas when viewed through a browser it is. I'll still follow up with the suggestion regarding Fiddler and constructing the request. I use Fiddler for other things but never used it to construct requests as you suggest. Regards, Jerry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323203 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP Problem - is file type extension required?
I'm not sure about the sessionID but I'll try to figure something out. I guess that when CF calls the page from CFHTTP the cookie and session ID are not established (provided) whereas when viewed through a browser it is. Those things aren't provided by default when you use CFHTTP. It's up to you to provide them across subsequent requests. If you're only requesting one page, that shouldn't be an issue, but if you request one page which sets a cookie, and are redirected to another page, it could very well be an issue. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323204 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP Problem - is file type extension required?
Gerald Weir wrote: I'm not sure about the sessionID but I'll try to figure something out. I guess that when CF calls the page from CFHTTP the cookie and session ID are not established (provided) whereas when viewed through a browser it is. The cookie is provided when CF calls the page just as it is from a browser. But with CF *you* are responsible to capture the cookie, save the cookie and return the cookie on future calls to the web service. The programmers who created the browser has taken care of all of that for you when you use their tool with cookie enabled web sites. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need a fresh perspective
would you use all joins if you were building the query or do sub queries? I'm still running through in my head how I should write this thing. Ben On Fri, Jun 5, 2009 at 9:51 AM, Azadi Saryev az...@sabai-dee.com wrote: that's a tricky layout... but only from css part! on the cf part all you need is one query to pull all data (with 2 extra columns aliased to store extracted YEAR** and MONTH from event's dates) and the nested cfoutputs with GROUP attributes: first by year column, then month column, then date column, then finally a cfoutput without any grouping for the times and checkboxes. ** you will need a year as separate column for cases when an event spans over Dec 31 Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 05/06/2009 20:24, Ben Densmore wrote: Hi Azadi, Here is an image of what the output should ultimately be. http://wedapstudios.com/table.png Right now my first query to get the Grouped months looks like this: Select mtsch_DateID, date_format(mtsch_DateVal, '%M') as Month, count(*) as Amount From mtsch_dates Where mtsch_PollFK = cfqueryparam cfsqltype=cf_sql_integer value=#arguments.pollID# / group by date_format(mtsch_DateVal, '%M') Order by mtsch_DateVal I'm then passing in the DateID to another function to grab the list of days: Select mtsch_DateVal as Days,mtsch_DateID From mtsch_dates Where mtsch_PollFK = cfqueryparam cfsqltype=cf_sql_integer value=#arguments.pollID# / Anddate_format(mtsch_DateVal, '%M') = cfqueryparam cfsqltype=cf_sql_varchar value=#arguments.monthvalue / I know I can probably get this all in one query but was having a hard time getting it completely right. I since deleted the query I was using to get the grouped months and then the days. I'll try and tackle doing it all in one query again. Thanks, Ben On Fri, Jun 5, 2009 at 8:26 AM, Azadi Saryev az...@sabai-dee.com wrote: Ben, in my Thunderbird you desired query output looks all warped - i can't make out exactly how you need it diplayed... can you try and post it formatted with tabs, or maybe just describe it in words? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 05/06/2009 12:34, Ben Densmore wrote: I've been working on an event scheduling application for the past 2 weeks. I'm pretty close to wrapping it up but have now run into an issue on my last part of the display. I'm thinking my data model might be the issue and would like to get some ideas from people on how I might be able to fix it. The way this thing works is: Step 1. user Creates a Title and description for their event Step 2. the user can select as many dates as they want step 3. the user enters in multiple times for each date they selected The structure I'm using for storing the data looks like: Table 1 PollID|UserID|Title|Description Table 2 DateID|PollFK|DateValue Table 3 DateFK|PollFK|TimeValue|Order This structure made the most sense to me only because they can add any number of dates that they want so if they added 15 dates I create a new row for each date and the ID for that date will then relate to the times they enter in step 3. This is what one event might look like in these 3 tables Table 1 PollID | UserID | Title | Description 1 25My Title My Description Table 2 DateID | PollFK | DateValue 112009-06-25 212009-06-26 312009-07-27 Table 3 DateFK | PollFK | TimeValue | Order 1 19:00 AM 1 1 110:00 AM2 1 112:00 PM3 2 111:00 AM1 2 112:00 PM2 3 1 6:30 PM 1 In My last display page I need to show a table similar to this: June July Wed 25 Thur 26 Wed 01 9:00 AM 10:00 AM 12:00 PM11:00 AM 12:00 PM6:30 PM I'm just really struggling to get this layout done with multiple queries. I'm doing one query to group the dates by month then going back and getting the days that were entered in for that month which I can do fine but I can't get the display to show up as I showed above. So I guess my 2 questions are: 1. Does anyone see a more efficient way to store the dates and times, keeping in mind that a user can add as many dates as they want, so creating x amount of columns doesn't really seem feasible. 2. What would be the best way to build my display page? Thanks, Ben ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:
MS CRM Integration
Happy Friday to you all I have to integrate an existing CF application with Microsoft's CRM. Anyone know of an existing CF component or other code out that to interface with its web services?Because of the urgent time-frame on this, I am hoping I don't have to develop one from scratch. -- Cheers! Michael David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323207 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MS CRM Integration
Maybe you could ping this guy to see how he solved his issue: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:58122/sort:1 On Fri, Jun 5, 2009 at 12:09 PM, Michael David li...@michaeldavid.comwrote: Happy Friday to you all I have to integrate an existing CF application with Microsoft's CRM. Anyone know of an existing CF component or other code out that to interface with its web services?Because of the urgent time-frame on this, I am hoping I don't have to develop one from scratch. -- Cheers! Michael David ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323208 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Moving from CF to Java - redirecting old pages to new ones
All, We have over 100 cfm pages that we'll need to redirect to a reduced number of new, few jsp pages. Is the best way to do this at the server, IIS level or through the webpage level. I'm thinking, detect all requests globally and if they have a .cfm extension, look up that page in a db and serve up the replacment page. Thoughts? Thanks D ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323209 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Moving from CF to Java - redirecting old pages to new ones
I know someone knows a better way but I have done it in the application.cfm using cfheader statuscode=301, statustext=Moved Permanently then another cfheader name=Location value=new url. First detecting whether it's the page in question of course. -- Ryan LeTulle On Fri, Jun 5, 2009 at 12:22 PM, coldfusion.develo...@att.net wrote: All, We have over 100 cfm pages that we'll need to redirect to a reduced number of new, few jsp pages. Is the best way to do this at the server, IIS level or through the webpage level. I'm thinking, detect all requests globally and if they have a .cfm extension, look up that page in a db and serve up the replacment page. Thoughts? Thanks D ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323210 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Need Regex help for finding and Hyperlinks words in String
Happy Friday everyone. I was hoping if anyone can help me with regex and a UDF. I have a string/paragraph which contains words beginning with a specific character. I'd like to find all those words and then assign a hyperlink URL to them. Example: If the string is: Lorem ipsum dolor sit amet, consectetur adipisicing. Elit @username sed do eiusmod tempor incididunt ut labore. Et dolore magnaaliqua. Id like to find (all) words beginning with @ and replace them with lt;a href=/profile.cfm?id=usernamegt;@usernamelt;/agt; I look forward to your reply. Thanks for helping. Mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323211 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need Regex help for finding and Hyperlinks words in String
Mike... cfset VARIABLES.oldstring = 'Lorem ipsum dolor sit amet, consectetur adipisicing. Elit @commadelimited sed do eiusmod tempor incididunt ut labore. Et dolore magnaaliqua. ' cfset VARIABLES.newstring = REReplaceNoCase(VARIABLES.oldstring, '@([[:alnum:]]+)', 'a href=/profile.cfm?id=\1@\1/a', 'ALL') cfdump var=#VARIABLES# Just curious...how far did you get in your own testing? andy -Original Message- From: Mike Francisco [mailto:cfmike...@gmail.com] Sent: Friday, June 05, 2009 1:46 PM To: cf-talk Subject: Need Regex help for finding and Hyperlinks words in String Happy Friday everyone. I was hoping if anyone can help me with regex and a UDF. I have a string/paragraph which contains words beginning with a specific character. I'd like to find all those words and then assign a hyperlink URL to them. Example: If the string is: Lorem ipsum dolor sit amet, consectetur adipisicing. Elit @username sed do eiusmod tempor incididunt ut labore. Et dolore magnaaliqua. Id like to find (all) words beginning with @ and replace them with lt;a href=/profile.cfm?id=usernamegt;@usernamelt;/agt; I look forward to your reply. Thanks for helping. Mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323212 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Need Regex help for finding and Hyperlinks words in String
Thanks Andy. That is it. Actually, I did not go very far since I am not that familiar with Regex. I only knew that Regex was the right thing to use. -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Friday, June 05, 2009 12:17 PM To: cf-talk Subject: RE: Need Regex help for finding and Hyperlinks words in String Mike... cfset VARIABLES.oldstring = 'Lorem ipsum dolor sit amet, consectetur adipisicing. Elit @commadelimited sed do eiusmod tempor incididunt ut labore. Et dolore magnaaliqua. ' cfset VARIABLES.newstring = REReplaceNoCase(VARIABLES.oldstring, '@([[:alnum:]]+)', 'a href=/profile.cfm?id=\1@\1/a', 'ALL') cfdump var=#VARIABLES# Just curious...how far did you get in your own testing? andy ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Need Regex help for finding and Hyperlinks words in String
Great. Glad to help. I def recommend you learn at least the basics of Regex. It's helpful in a wide range of applications. andy -Original Message- From: Mike Francisco [mailto:cfmike...@gmail.com] Sent: Friday, June 05, 2009 2:53 PM To: cf-talk Subject: RE: Need Regex help for finding and Hyperlinks words in String Thanks Andy. That is it. Actually, I did not go very far since I am not that familiar with Regex. I only knew that Regex was the right thing to use. -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Friday, June 05, 2009 12:17 PM To: cf-talk Subject: RE: Need Regex help for finding and Hyperlinks words in String Mike... cfset VARIABLES.oldstring = 'Lorem ipsum dolor sit amet, consectetur adipisicing. Elit @commadelimited sed do eiusmod tempor incididunt ut labore. Et dolore magnaaliqua. ' cfset VARIABLES.newstring = REReplaceNoCase(VARIABLES.oldstring, '@([[:alnum:]]+)', 'a href=/profile.cfm?id=\1@\1/a', 'ALL') cfdump var=#VARIABLES# Just curious...how far did you get in your own testing? andy ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323214 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Generating appopriate transaction IDs
Any aversion to using an auto-increment integer field (if one exists, that is)? I basically use this as a transaction ID in one of my apps. Fawzi Amadu wrote: I am building a electronic advertisement site and I need to generate transaction IDs. Since the page will hopefully be a high volume site, I am wondering the best form of generating transaction IDs. I was considering rand function, but I read that the randrange has an upper recommended upper limit of 100,000,000. TIA ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323215 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
(ot) Sending an inline HTML content for email using yahoo
Hi, I checked some resources for sending an inline HTML content via yahoo and other email accounts to no avail, very weird for some simple stuff. no, not cfmail. Have you done anything like that? Tia The inline html code looks like this html head meta http-equiv=Content-Type content=Multipart/alternative; charset=utf-8 or meta http-equiv=Content-Type content=text/html; charset=utf-8 titlemy stuff/title /head body table width=100% border=0 cellspacing=0 cellpadding=0 trtd Hi, some fancy content here. /td/tr trtd img src=someRemoteServer/fancy.jpg /td/tr /table /body /html ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323216 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Sending an inline HTML content for email using yahoo
Are you asking a question? If you are, I'm not sure what you're asking. Do you need help sending it? Is it not displaying properly? -Original Message- From: Don L [mailto:do...@yahoo.com] Sent: Friday, June 05, 2009 4:37 PM To: cf-talk Subject: (ot) Sending an inline HTML content for email using yahoo Hi, I checked some resources for sending an inline HTML content via yahoo and other email accounts to no avail, very weird for some simple stuff. no, not cfmail. Have you done anything like that? Tia The inline html code looks like this html head meta http-equiv=Content-Type content=Multipart/alternative; charset=utf-8 or meta http-equiv=Content-Type content=text/html; charset=utf-8 titlemy stuff/title /head body table width=100% border=0 cellspacing=0 cellpadding=0 trtd Hi, some fancy content here. /td/tr trtd img src=someRemoteServer/fancy.jpg /td/tr /table /body /html ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323217 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Sending an inline HTML content for email using yahoo
Yeah, was asking the question, why the sample HTML code sent via yahoo mail etc. would not display HTML content? Thks. Are you asking a question? If you are, I'm not sure what you're asking. Do you need help sending it? Is it not displaying properly? Hi, I checked some resources for sending an inline HTML content via yahoo and other email accounts to no avail, very weird for some simple stuff. no, not cfmail. Have you done anything like that? Tia The inline html code looks like this html head meta http-equiv=Content-Type content=Multipart/alternative; charset=utf-8 or meta http-equiv=Content-Type content=text/html; charset=utf-8 titlemy stuff/title /head body table width=100% border=0 cellspacing=0 cellpadding=0 trtd Hi, some fancy content here. /td/tr trtd img src=someRemoteServer/fancy.jpg /td/tr /table /body /html ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323218 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
What would cause this wddx message instead of json formatted data?
Before I get into code, I thought I'd just ask if there is a usual reason why a jquery ajax function (which I have used successfully on other sites) would be returning this mesage in Firebug: wddxPacket version='1.0'header/datastructvar name='LOGIN'stringLogin Successful/string /var/struct/data/wddxPacket Instead of the json formatted data I'm expecting? Is is something typical and obvious usually? If not, I'll start supplying code. Well, I will share this much to get started so you'll see that json is specified as the returntype and dataType: $.ajax ({ cache:false, type: post, url: components/siteManagerData.cfc?method=mGetManagerPermissionsreturntype=json, dataType: json, data:values, success: function(response){ Thanks for any feedback. Rick Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Experienced ColdFusion developer available
I'm announcing my availability for either full or part time positions. Over 10 years of experience including: ColdFusion v.3.11 through 8.01 (including functions and components) JQuery MSSQL Server 7 through 2005 MySQL Sybase MS Access. Some Classic ASP 2.0 I would prefer a full time position in the Raleigh Durham area, however I will entertain telecommuting positions outside of the area. My resume, rates and/or salary requirements ,and references are available upon request. -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4244 Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11