AW: MySQL Auto Increment Field
Barneyb, Railo only retrieves the result when you actually use a result attribute in the query. If you are not using it then it is not slower. On the other hand the result attribute must already contain the value after the cfquery is executed. This is due to the fact that when retrieving AutoInc numbers a different code needs to be executed, containing data that is only available at query execution time. So even if lazy loading would be superb to have when you have a result attribute, it is not possible to execute the necessary code to fill the GENERATEDKEY field of the result struct. PS: Your business card almost put me into trouble with my GF :-) Greetings from Switzerland Gert Franz Railo Technologies Professional Open Source skype: gert.franz g...@getrailo.com +41 76 5680 231 www.getrailo.com -Ursprüngliche Nachricht- Von: Barney Boisvert [mailto:bboisv...@gmail.com] Gesendet: Donnerstag, 1. Oktober 2009 07:36 An: cf-talk Betreff: Re: MySQL Auto Increment Field Just out of curiosity Sean, do you know if the value is lazy loaded, or do you have to pay the cost of retrieving the value on every query (or at least introspecting to determine whether a value is available) regardless? I know you're closest to Railo, but I'm interested in both (all three?) platforms if you've got the info. cheers, barneyb On Wed, Sep 30, 2009 at 10:19 PM, Sean Corfield seancorfi...@gmail.com wrote: On Tue, Sep 29, 2009 at 12:22 PM, Azadi Saryev az...@sabai-dee.com wrote: if you are on CF8, use RESULT attribute of cfquery tag and then get GENERATED_KEY from that result: cfquery name=myquery datasource=... result=qResult INSERT ... /cfquery cfset newID = qResult.GENERATED_KEY As an aside, the generated key is placed into a different element of the result struct for each different database in CF8 (why??!?!) but that is fixed in CF9 which also adds GENERATEDKEY for *all* DB types so you can write portable code (assuming you stick to standard SQL of course and not TSQL - sorry Robert, couldn't resist! :) Railo recently implemented this same feature (both adding the various DB-specific generated key elements as well as the generic GENERATEDKEY element). I don't know whether Open BlueDragon supports this feature yet. Anyone? -- Sean A Corfield -- (904) 302-SEAN Railo Technologies US -- http://getrailo.com/ An Architect's View -- http://corfield.org/ -- Barney Boisvert bboisv...@gmail.com http://www.barneyb.com/ ~| 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:326792 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Debugging jquery post to coldfusion
I am having trouble processing a post to a cf template using a jquery post. I have set up a template to dynamically evaluate the form fields being posted - it isn't working, however it uses the following basic syntax: cfloop list=#FieldNames# index=i cfif i does not contain 'fieldnames' cfset value = evaluate(i) #i# #value# /cfif /cfloop One of the challenges I find with debugging coldfusion and jquery/ajax interactions is seeing what is going on. To address this, and as a way to debug what is going on with the jquery post, I decided to place the above code in a cfmail tag as follows: cfmail to=myem...@someaddress.com from=myem...@someaddress.com server=localhost subject=Test jquery form post cfloop list=#FieldNames# index=i cfif i does not contain 'fieldnames' cfset value = form[i] #i# #value# /cfif /cfloop /cfmail When I post to this template, I find that this doesn't work either? Huh? Can anyone explain why? The code below does work (I get a message with the fieldnames and values) so jquery is posting... cfmail to=myem...@someaddress.com from=myem...@someaddress.com server=localhost subject=Test jquery form post cfloop collection=#form# item=i cfif i does not contain 'fieldnames' cfset value = form[i] #i# #value# /cfif /cfloop /cfmail Any explanation why the first cfmail example wouldn't work? In the meantime, I am going to start recoding my template to use the second method. ~| 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:326793 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Viviotech
Thanks! ~| 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:326794 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Viviotech
It's OS X. The view was named properly, but I went back into the CFQUERY tag and found a field in the query that was not in the view. Fixing that fixed the error, though why that was causing it to say table not found I am not sure. ~| 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:326795 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
reading text from images
hi is there a way in coldfusion to read/scan the text from an image? if not in coldfusion, is there any other means to do this? thanks richard ~| 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:326796 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: reading text from images
Just saw this on the wire yesterday: http://www.labnol.org/internet/perform-ocr-with-google-docs/10059/ Don't know any more about it than that article, but maybe it's helpful. ~| 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:326797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Viviotech
Clearly I replied here to the wrong topic. Oops. ~| 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:326798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: mySQL view coming up table not found?
It's OS X. The view was named properly, but I went back into the CFQUERY tag and found a field in the query that was not in the view. Fixing that fixed the error, though why that was causing it to say table not found I am not sure. ~| 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:326799 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Style attribute not workin in CF8 CFChart?
Just in case anyone else has this problem in the future and finds this via a search, I managed to fix it. I went ahead and moved the xml stylesheet out of the cfsavecontentvariable and into a xml file in the same directory. I then called the xml file via the style attribute. cfchart style=pie.xml This solved the issue on my test server. Why it solved the issue I have no idea, but its working now. ~| 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:326800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Debugging jquery post to coldfusion
A really good way to debug jQuery to CF mechanics is to use Firefox and Firebug. In Firebug you can see AJAX calls. Right click on that line in FB then select copy with parameters, and paste that into a new tab. It'll store all of your passed in vars, and let you see what CF is doing. andy -Original Message- From: Doug Hyde [mailto:deve...@fusesite.com] Sent: Thursday, October 01, 2009 6:32 AM To: cf-talk Subject: Debugging jquery post to coldfusion I am having trouble processing a post to a cf template using a jquery post. I have set up a template to dynamically evaluate the form fields being posted - it isn't working, however it uses the following basic syntax: cfloop list=#FieldNames# index=i cfif i does not contain 'fieldnames' cfset value = evaluate(i) #i# #value# /cfif /cfloop One of the challenges I find with debugging coldfusion and jquery/ajax interactions is seeing what is going on. To address this, and as a way to debug what is going on with the jquery post, I decided to place the above code in a cfmail tag as follows: cfmail to=myem...@someaddress.com from=myem...@someaddress.com server=localhost subject=Test jquery form post cfloop list=#FieldNames# index=i cfif i does not contain 'fieldnames' cfset value = form[i] #i# #value# /cfif /cfloop /cfmail When I post to this template, I find that this doesn't work either? Huh? Can anyone explain why? The code below does work (I get a message with the fieldnames and values) so jquery is posting... cfmail to=myem...@someaddress.com from=myem...@someaddress.com server=localhost subject=Test jquery form post cfloop collection=#form# item=i cfif i does not contain 'fieldnames' cfset value = form[i] #i# #value# /cfif /cfloop /cfmail Any explanation why the first cfmail example wouldn't work? In the meantime, I am going to start recoding my template to use the second method. ~| 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:326801 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Debugging jquery post to coldfusion
Firebug is cool but I also use a reverse proxy called Charles which is extremely useful (http://www.charlesproxy.com/) -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Thursday, October 01, 2009 2:39 PM To: cf-talk Subject: RE: Debugging jquery post to coldfusion A really good way to debug jQuery to CF mechanics is to use Firefox and Firebug. In Firebug you can see AJAX calls. Right click on that line in FB then select copy with parameters, and paste that into a new tab. It'll store all of your passed in vars, and let you see what CF is doing. andy -Original Message- From: Doug Hyde [mailto:deve...@fusesite.com] Sent: Thursday, October 01, 2009 6:32 AM To: cf-talk Subject: Debugging jquery post to coldfusion I am having trouble processing a post to a cf template using a jquery post. I have set up a template to dynamically evaluate the form fields being posted - it isn't working, however it uses the following basic syntax: cfloop list=#FieldNames# index=i cfif i does not contain 'fieldnames' cfset value = evaluate(i) #i# #value# /cfif /cfloop One of the challenges I find with debugging coldfusion and jquery/ajax interactions is seeing what is going on. To address this, and as a way to debug what is going on with the jquery post, I decided to place the above code in a cfmail tag as follows: cfmail to=myem...@someaddress.com from=myem...@someaddress.com server=localhost subject=Test jquery form post cfloop list=#FieldNames# index=i cfif i does not contain 'fieldnames' cfset value = form[i] #i# #value# /cfif /cfloop /cfmail When I post to this template, I find that this doesn't work either? Huh? Can anyone explain why? The code below does work (I get a message with the fieldnames and values) so jquery is posting... cfmail to=myem...@someaddress.com from=myem...@someaddress.com server=localhost subject=Test jquery form post cfloop collection=#form# item=i cfif i does not contain 'fieldnames' cfset value = form[i] #i# #value# /cfif /cfloop /cfmail Any explanation why the first cfmail example wouldn't work? In the meantime, I am going to start recoding my template to use the second method. ~| 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:326802 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Debugging jquery post to coldfusion
Firebug is a great tool and will save you lot of time. CF solution: you can use the cftry..cfcatch and email the errors. Example: cftry !--- your code --- cfcatch type=any cfmail subject= type=html from= to= cfdump var=#cfcatch.detail# -- #cfcatch.message# /cfmail /cfcatch /cftry Hope this helps. I am having trouble processing a post to a cf template using a jquery post. I have set up a template to dynamically evaluate the form fields being posted - it isn't working, however it uses the following basic syntax: cfloop list=#FieldNames# index=i cfif i does not contain 'fieldnames' cfset value = evaluate(i) #i# #value# /cfif /cfloop One of the challenges I find with debugging coldfusion and jquery/ajax interactions is seeing what is going on. To address this, and as a way to debug what is going on with the jquery post, I decided to place the above code in a cfmail tag as follows: cfmail to=myem...@someaddress.com from=myem...@someaddress.com server=localhost subject=Test jquery form post cfloop list=#FieldNames# index=i cfif i does not contain 'fieldnames' cfset value = form[i] #i# #value# /cfif /cfloop /cfmail When I post to this template, I find that this doesn't work either? Huh? Can anyone explain why? The code below does work (I get a message with the fieldnames and values) so jquery is posting... cfmail to=myem...@someaddress.com from=myem...@someaddress.com server=localhost subject=Test jquery form post cfloop collection=#form# item=i cfif i does not contain 'fieldnames' cfset value = form[i] #i# #value# /cfif /cfloop /cfmail Any explanation why the first cfmail example wouldn't work? In the meantime, I am going to start recoding my template to use the second method. ~| 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:326803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Style attribute not workin in CF8 CFChart?
I've used inline styles for charts all the time. I think your problem may have been the whitespace. Next time try trimming the string first. On Thu, Oct 1, 2009 at 7:58 AM, slli...@shayna.com slli...@shayna.com sclarkli...@gmail.com wrote: Just in case anyone else has this problem in the future and finds this via a search, I managed to fix it. I went ahead and moved the xml stylesheet out of the cfsavecontentvariable and into a xml file in the same directory. I then called the xml file via the style attribute. cfchart style=pie.xml This solved the issue on my test server. Why it solved the issue I have no idea, but its working now. ~| 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:326804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Debugging jquery post to coldfusion
I ran into Fiddler a while back. Pretty freaking awesome. It has a FF plugin as well. http://www.fiddler2.com/fiddler2/ On Thu, Oct 1, 2009 at 7:31 AM, Doug Hyde deve...@fusesite.com wrote: I am having trouble processing a post to a cf template using a jquery post. I have set up a template to dynamically evaluate the form fields being posted - it isn't working, however it uses the following basic syntax: cfloop list=#FieldNames# index=i cfif i does not contain 'fieldnames' cfset value = evaluate(i) #i# #value# /cfif /cfloop One of the challenges I find with debugging coldfusion and jquery/ajax interactions is seeing what is going on. To address this, and as a way to debug what is going on with the jquery post, I decided to place the above code in a cfmail tag as follows: cfmail to=myem...@someaddress.com from=myem...@someaddress.com server=localhost subject=Test jquery form post cfloop list=#FieldNames# index=i cfif i does not contain 'fieldnames' cfset value = form[i] #i# #value# /cfif /cfloop /cfmail When I post to this template, I find that this doesn't work either? Huh? Can anyone explain why? The code below does work (I get a message with the fieldnames and values) so jquery is posting... cfmail to=myem...@someaddress.com from=myem...@someaddress.com server=localhost subject=Test jquery form post cfloop collection=#form# item=i cfif i does not contain 'fieldnames' cfset value = form[i] #i# #value# /cfif /cfloop /cfmail Any explanation why the first cfmail example wouldn't work? In the meantime, I am going to start recoding my template to use the second method. ~| 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:326805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Debugging jquery post to coldfusion
Fiddler is good, but for the most part, Firebug is better. -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Thursday, October 01, 2009 9:20 AM To: cf-talk Subject: Re: Debugging jquery post to coldfusion I ran into Fiddler a while back. Pretty freaking awesome. It has a FF plugin as well. http://www.fiddler2.com/fiddler2/ On Thu, Oct 1, 2009 at 7:31 AM, Doug Hyde deve...@fusesite.com wrote: I am having trouble processing a post to a cf template using a jquery post. I have set up a template to dynamically evaluate the form fields being posted - it isn't working, however it uses the following basic syntax: cfloop list=#FieldNames# index=i cfif i does not contain 'fieldnames' cfset value = evaluate(i) #i# #value# /cfif /cfloop One of the challenges I find with debugging coldfusion and jquery/ajax interactions is seeing what is going on. To address this, and as a way to debug what is going on with the jquery post, I decided to place the above code in a cfmail tag as follows: cfmail to=myem...@someaddress.com from=myem...@someaddress.com server=localhost subject=Test jquery form post cfloop list=#FieldNames# index=i cfif i does not contain 'fieldnames' cfset value = form[i] #i# #value# /cfif /cfloop /cfmail When I post to this template, I find that this doesn't work either? Huh? Can anyone explain why? The code below does work (I get a message with the fieldnames and values) so jquery is posting... cfmail to=myem...@someaddress.com from=myem...@someaddress.com server=localhost subject=Test jquery form post cfloop collection=#form# item=i cfif i does not contain 'fieldnames' cfset value = form[i] #i# #value# /cfif /cfloop /cfmail Any explanation why the first cfmail example wouldn't work? In the meantime, I am going to start recoding my template to use the second method. ~| 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:326806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Simple: ? sql add value to column
ok i have a bunch of page numbers that need changed. they are like 10, 14 et.. i need to add 6 to the value i tried a sql stament of UPDATE x_cat SET cat_pg = cat_pg + 6 WHERE (x_cat_id= 632) but my values goto 106, 146, et.. ~| 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:326807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Webservice error
I am redirecting to another URL using cflocation in my webservice, then i am
getting this error, if i comment the cflocation tag then its working fine. Any
help or suggestions will be appreciated lot.
Cannot perform web service invocation login.
The fault returned when invoking the web service operation is:
AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.runtime.AbortException : null]
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.runtime.AbortException : null]
at
coldfusion.xml.rpc.CFComponentSkeleton.__createCFCInvocationException(CFComponentSkeleton.java:723)
at
coldfusion.xml.rpc.CFComponentSkeleton.__invoke(CFComponentSkeleton.java:670)
at InvokeServices.login(E:\ecodes_Dev\InvokeServices.cfc)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:388)
at org.apache.axis.provider... ''
Thanks
chr
~|
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:326808
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Dynamic form issues
Hey all, I'm having an issue trying to figure out something. Here's what I have, a form that's generated dynamically based on fields returned from a query, I'll never know how many form rows their could be. The form action does two separate inserts, thus the need to pass the remaining variables in a structure. All the code below works sort of.. I need to account for fields that aren't passed (check boxes, selects that may or may not be there depending on the users opting to use a data query to auto populate some fields) Any idea how to do this when form.fieldnames is dynamically generated? !--- form template --- http://cf.pastebin.com/m4e72fce9 !--- function factory call --- http://cf.pastebin.com/m133edbe8 !--- creates the argument structure --- http://cf.pastebin.com/m41de171b !--- template factory --- http://cf.pastebin.com/m68b8de0b -- Scott Stewart IT Consultant/ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (919) 874-6229 ~| 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:326809 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple: ? sql add value to column
ok so looks like the column cat_pg is a varchar. so that's why the statement wouldn't work. so i need to what, cast it as a numeric to update it? UPDATE x_cat SET cat_pg = CAST(cat_pg AS NUMERIC) + 6 WHERE (x_cat_id= 632) On Thu, Oct 1, 2009 at 10:45 AM, Paul Ihrig pih...@gmail.com wrote: ok i have a bunch of page numbers that need changed. they are like 10, 14 et.. i need to add 6 to the value i tried a sql stament of UPDATE x_cat SET cat_pg = cat_pg + 6 WHERE (x_cat_id= 632) but my values goto 106, 146, et.. ~| 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:326810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDocument Header Not Responding to Font-Size
I don't know if my problem is the same as the one in this thread but I figure I'd share it if someone finds it useful. After we upgraded from 7 to 8 we discovered the user-provided fonts we registered in CF didn't work properly. The cfdocument text in our generated PDFs reverted to Times and the sizes were all the same. We took that custom font and put it into our Windows system fonts folder and restarted CF; it started to behave again as intended. - Joe ~| 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:326811 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Debugging jquery post to coldfusion
Generally when trying to debug a template, I will log the variables on a
separate page that I can refresh. Simply put the following code either in your
application.cfm or in the onrequest function in the application.cfc
cfsavecontent variable=exc
#now()#
h2FORM/h2
cfdump var=#form#
h2SESSION/h2
cfdump var=#sesion#
/cfsavecontent
cffile action=write file=#expandpath('/log.html')#
nameconflict=overwrite output=#exc#/
This way your debug code is separate from your request page.
~|
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:326812
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Style attribute not workin in CF8 CFChart?
Thanks Ray, I'll try that next time. Sandy Clark On Thu, Oct 1, 2009 at 10:16 AM, Raymond Camden rcam...@gmail.com wrote: I've used inline styles for charts all the time. I think your problem may have been the whitespace. Next time try trimming the string first. On Thu, Oct 1, 2009 at 7:58 AM, slli...@shayna.com slli...@shayna.com sclarkli...@gmail.com wrote: Just in case anyone else has this problem in the future and finds this via a search, I managed to fix it. I went ahead and moved the xml stylesheet out of the cfsavecontentvariable and into a xml file in the same directory. I then called the xml file via the style attribute. cfchart style=pie.xml This solved the issue on my test server. Why it solved the issue I have no idea, but its working now. ~| 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:326813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple: ? sql add value to column
yea u'd cast it...but the real question you have to ask...why is that field a varchar if it's meant to be used as a numeric? ~| 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:326814 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple: ? sql add value to column
Y... these are not thing mortals should question. the data which is the word, is infallible and has come down from on high. it proceeds us by generations and we shall not question it validity, integrity or reliability. On Thu, Oct 1, 2009 at 11:26 AM, Yuliang Ruan yuliangr...@hotmail.comwrote: yea u'd cast it...but the real question you have to ask...why is that field a varchar if it's meant to be used as a numeric? ~| 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:326815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Simple: ? sql add value to column
ok so looks like the column cat_pg is a varchar. so that's why the statement wouldn't work. so i need to what, cast it as a numeric to update it? UPDATE x_cat SET cat_pg = CAST(cat_pg AS NUMERIC) + 6 WHERE (x_cat_id= 632) I recommend that you change the datatype of the column. 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 in ~| 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:326816 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic form issues
Here's what I have, a form that's generated dynamically based on fields returned from a query, I'll never know how many form rows their could be. The form action does two separate inserts, thus the need to pass the remaining variables in a structure. ... I need to account for fields that aren't passed (check boxes, selects that may or may not be there depending on the users opting to use a data query to auto populate some fields) Any idea how to do this when form.fieldnames is dynamically generated? I recommend that you create a form field that contains the number of rows, so that you can loop over the rows in your action page. Then, name the fields for each row dynamically. I didn't look at your code samples to see if that's what you're doing, but there are some examples of this in the official Adobe Advanced ColdFusion 8 courseware available here: http://www.adobe.com/education/instruction/teach/cfcurriculum.html I think it's in unit 3. 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 informatio ~| 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:326817 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple: ? sql add value to column
these are not thing mortals should question. the data which is the word, is infallible and has come down from on high. it proceeds us by generations and we shall not question it validity, integrity or reliability. Your god is a false god. Otherwise, it would have perfect datatypes. Repent before it's too late, idolator, or burn forever in the fires of poorly structured data! 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:326818 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: AW: Viviotech
I've used a viviotech VPS for some time now, actually I have a couple of them over there. Whenever I have a problem, they are quick to respond, and the customer service vs other (larger) companies is night and day. I highly recommend them to everybody I know who is looking for a CF Host. Plus they support railo and openBD. You can get a VPS for 20 bucks a month - why would you ever consider shared hosting again. Rob, we from Railo have a bigger project running at VivioTech and Jordan Michaels has done a terrific job for us in setting up everything we needed. So I can only tell from our experience with their support for dedicated servers. We were and are VERY pleased so far. The team is very responsive and solved all of our problems we had... Greetings from Switzerland Gert Franz Railo Technologies Professional Open Source skype: gert.franz g...@getrailo.com +41 76 5680 231www.getrailo.com -Ursprüngliche Nachricht- Von: Rob Barthle [mailto:r...@barthle.com] Gesendet: Dienstag, 29. September 2009 08:57 An: cf-talk Betreff: Viviotech I am looking at viviotech for a VPS solution. Could I get some unbiased opinions of them? I had a disastrous time with Gearworx (poor server and worse support) and am currently with hostnexus on a shared server that lately has been going down because of activity from other domains. Also for what I am paying for them it wouldn't be much more to go back to a VPS with Vivio. Thanks. ~| 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:326819 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ASPro SQL Inject
I was about to flip the switch from a client's old server (using ASP) to a re-done CF site, doing a diff on the DB before-hand, when I noticed that every record in every table on the old server had one or two cells with an appended SCRIPT tag pointing to a server in Russia. I did a search on the script name ads-t.ru/ads.jsand came up with this article: http://garwarner.blogspot.com/2009/10/cyber-security-awareness-month-day-one.html Coly crap! Had I moved the site over three days ago I would have avoided this extra work. !*@#^(!*@^)*^ Mik Michael Muller office (413) 863-6455 cell (413) 320-5336 skype: michaelBmuller http://MontagueWebWorks.com Information is not knowledge Knowlege is not wisdom Eschew Obfuscation ~| 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:326820 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic form issues
I wrote a CFC that might help: http://formutils.riaforge.org/ On Thu, Oct 1, 2009 at 10:53 AM, Scott Stewart sstwebwo...@bellsouth.netwrote: Hey all, I'm having an issue trying to figure out something. Here's what I have, a form that's generated dynamically based on fields returned from a query, I'll never know how many form rows their could be. The form action does two separate inserts, thus the need to pass the remaining variables in a structure. ~| 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:326821 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dynamic form issues
+1 for FormUtilities.cfc - Very handy. G! On Thu, Oct 1, 2009 at 2:55 PM, Brian Kotek brian...@gmail.com wrote: I wrote a CFC that might help: http://formutils.riaforge.org/ On Thu, Oct 1, 2009 at 10:53 AM, Scott Stewart sstwebwo...@bellsouth.net wrote: Hey all, I'm having an issue trying to figure out something. Here's what I have, a form that's generated dynamically based on fields returned from a query, I'll never know how many form rows their could be. The form action does two separate inserts, thus the need to pass the remaining variables in a structure. ~| 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:326822 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Write HTML content after reading a CSV file
Probably 10 ways to do this. Here's one: 1. read in the csv file with cffile: http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_f_07.html#3545217 2. use this to make it into a query: http://cflib.org/udf/CSVToQuery 3. use this to dump the query as a table: http://cflib.org/udf/queryToTableDump On Wed, Sep 30, 2009 at 8:00 AM, vidya yegnaraman viduka...@gmail.comwrote: Hi, Thanks for the above links. But, I don't want to use the cfsavecontent,since there is huge amount of data and I run out of memory. What am trying to do now is do a cffile read of the csv file, loop through the rows, open a cffile write to create the file and then use a cffile append. But am facing some issues when I read the file and write the data as a html. I am using the following for looping and delimiters. Please suggest me what I can use as a delimiter since there are commas in the data. cfloop index=i list=#csvfile# delimiters=#chr(10)##chr(13)# When I write the list it doesn't show the data properly. It would be great if you have a code sample where in it reads a csv file, loops thru the records and write a html file. There are 5 columns in the csv file. Thanks ~| 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:326823 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Write HTML content after reading a CSV file
cffile action=read file=#ExpandPath('csv.csv')# variable=thiscsv
cffile action=write file=#ExpandPath('csv.htm')# output=table
addnewline=true
cfloop list=#thiscsv# index=thisline delimiters=#Chr(10)#
cffile action=append file=#ExpandPath('csv.htm')# output=tr
addnewline=true
cfloop list=#thisline# index=thiscell
cffile action=append file=#ExpandPath('csv.htm')#
output=td#thiscell#/td addnewline=true
/cfloop
cffile action=append file=#ExpandPath('csv.htm')# output=/tr
addnewline=true
/cfloop
On Thu, Oct 1, 2009 at 2:24 PM, vidya yegnaraman viduka...@gmail.comwrote:
Probably 10 ways to do this. Here's one:
1. read in the csv file with cffile:
http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_f_07.html#3545217
2. use this to make it into a query: http://cflib.org/udf/CSVToQuery
3. use this to dump the query as a table:
http://cflib.org/udf/queryToTableDump
On Wed, Sep 30, 2009 at 8:00 AM, vidya yegnaraman viduka...@gmail.com
wrote:
Hi,
Thanks for the above links.
But, I don't want to use the cfsavecontent,since there is huge amount of
data and I run out of memory. What am trying to do now is do a cffile read
of the csv file, loop through the rows, open a cffile write to create the
file and then use a cffile append. But am facing some issues when I read the
file and write the data as a html.
I am using the following for looping and delimiters. Please suggest me what
I can use as a delimiter since there are commas in the data.
cfloop index=i list=#csvfile# delimiters=#chr(10)##chr(13)#
When I write the list it doesn't show the data properly.
It would be great if you have a code sample where in it reads a csv file,
loops thru the records and write a html file. There are 5 columns in the csv
file.
Thanks
~|
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:326824
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Write HTML content after reading a CSV file
John M Bliss wrote:
cffile action=read file=#ExpandPath('csv.csv')# variable=thiscsv
cffile action=write file=#ExpandPath('csv.htm')# output=table
addnewline=true
cfloop list=#thiscsv# index=thisline delimiters=#Chr(10)#
cffile action=append file=#ExpandPath('csv.htm')# output=tr
addnewline=true
cfloop list=#thisline# index=thiscell
cffile action=append file=#ExpandPath('csv.htm')#
output=td#thiscell#/td addnewline=true
/cfloop
cffile action=append file=#ExpandPath('csv.htm')# output=/tr
addnewline=true
/cfloop
Bad news John, you failed to write a closing tag for the table, your
HTML file is not going to pass validation. ;-)
~|
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:326825
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Write HTML content after reading a CSV file
Oh, hell.
...
cffile action=write file=#ExpandPath('csv.htm')# output=/table
:-)
On Thu, Oct 1, 2009 at 3:01 PM, Ian Skinner h...@ilsweb.com wrote:
John M Bliss wrote:
cffile action=read file=#ExpandPath('csv.csv')# variable=thiscsv
cffile action=write file=#ExpandPath('csv.htm')# output=table
addnewline=true
cfloop list=#thiscsv# index=thisline delimiters=#Chr(10)#
cffile action=append file=#ExpandPath('csv.htm')# output=tr
addnewline=true
cfloop list=#thisline# index=thiscell
cffile action=append file=#ExpandPath('csv.htm')#
output=td#thiscell#/td addnewline=true
/cfloop
cffile action=append file=#ExpandPath('csv.htm')# output=/tr
addnewline=true
/cfloop
Bad news John, you failed to write a closing tag for the table, your
HTML file is not going to pass validation. ;-)
~|
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:326826
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Write HTML content after reading a CSV file
Oh, hell.
...
cffile action=write file=#ExpandPath('csv.htm')# output=/table
:-)
On Thu, Oct 1, 2009 at 3:01 PM, Ian Skinner h...@ilsweb.com wrote:
Thank you John, will try this out. ;-)
~|
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:326827
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldbox plugins vs interceptors for user management
Hi, I am new to Coldbox and come from a Fusebox 4 / Reactor ORM background. I really like Coldbox and am considering building a role based user management system that can be ported from one Coldbox app to another. In version 3.0 beta of Coldbox sample apps there is a sampleloginapp which uses the interceptor design pattern. I have also seen an example of a login.cfc implemened as a plugin. My dilemma is that I am not sure which is a better way to approach this interceptor or plugins? Secondly with plugins how do you separate your data layer from business managers. Do all CFCs live in the plugins directory? Any help would be greatly appreciated. Thanks Regards, Vineet ~| 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:326828 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
