cfhttp multipart facebook
Hi, I'm playing with the facebook graph api, and was attempting to send an image to my wall. According to facebook, you just send the image, your access key a caption... see below my code: cfoutput cfif fileexists(D:\myPath\images\menubar.jpg) cfhttp method=post url=https://graph.facebook.com/me/photos; multipart=yes cfhttpparam type=formfield name=access_token value=myAccessToken cfhttpparam type=file name=source file=D:\myPath\images\menubar.jpg cfhttpparam type=formfield name=message value=this is a test picture. /cfhttp cfdump var=#cfhttp# /cfif /cfoutput When I run this, I get a 400 bad request error (OauthException an unknown error occurred returns from facebook). Does anyone know what I'm doing wrong? 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:340355 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ajax + 2 functions = error
ok, tried this, it failed on the var scoped line instead of the structAppend line... same error message though. I have an ajax handler method which instantiates all of my ajax calls-- also with an access=public. very strange. I am able to call other methods, but I have to create an object for the cfc and then call the method within it. seems ridiculous to do this for the component my code is already in. try replacing your failing line with these 2: var stuctTest = getTest(); structAppend(returnData, structTest); Azadi On 10/11/2010 09:56 , Jessica Kennedy wrote: structAppend(returnData, getTest());//failing here! ~| 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:339074 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: slow cfquery cfqueryparam?
Hey, maybe try something like this? I haven't tested this, but it should theoretically be faster cfset sqlstring = / cfset questionIDLen = arrayLen(questionIDArray)!---put this in a variable so it doesn't re-evaluate 2200 times--- cfset questionIDCheck = 0 cfloop index=i from=2 to=#questionIDLen# !---remove if statement so it doesn't evaluate 2200 times either.--- cfset questionIDCheck = isNumeric(questionIDArray[i] parentQuestionIDArray[i] parentLevelArray[i])!---since all your params were checking for a numeric value, lump together and be sure they are all numeric. probably could use a regEx or other cffunctions to accomplish the same thing if this does not fit the bill--- cfif questionIDCheck!---only add to sql string if it passes the numeric check. --- cfset sqlstring = '#sqlstring#,(#questionIDArray[i]#,#parentQuestionIDArray[i]#,#parentLevelArray[i]#)' /cfif /cfloop !---run query. manually add first line since we didn't loop over it.--- cfquery name=insertData datasource=dbname INSERT INTO parentquestions VALUES (cfqueryparam value=#questionIDArray[1]# cfsqltype=cf_sql_bigint maxlength=20,cfqueryparam value=#parentQuestionIDArray[1]# cfsqltype=cf_sql_bigint maxlength=20,cfqueryparam value=#parentLevelArray[1]# cfsqltype=cf_sql_bigint maxlength=20) #sqlstring# /cfquery ~| 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:339076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ajax + 2 functions = error
I do cache my component, but since I'm testing, I'm forcing a reload on each page load, and I am istantiating the component I call via ajax on every request... still, I did a test to be sure-- I attempted to call getTest() via ajax-- worked perfectly. then attempted to call the original method test() from getTest... failure. I'm really scratching my head on this one! is your component cached in some persistent scope (session/application)? it sounds like you have added the getTest() method after the component has been instantiated - and thus its instance has no idea about the getTest() method added later... Azadi On 10/11/2010 21:50 , Jessica Kennedy wrote: ~| 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:339103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Ajax + 2 functions = error
correct. I believe if you are calling it from the same root domain a public access will work Confusing. Your access is public but you can call it via remote Ajax? ~| 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:339104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Ajax + 2 functions = error
Ok, I have the following 2 functions: !--- test--- cffunction name=test access=public output=No returntype=struct cfscript var returnData = structNew(); structAppend(returnData, getTest());//failing here! returnData.test2 = test2; /cfscript cfreturn returnData /cffunction !--- test2 --- cffunction name=getTest access=public output=No returntype=struct cfscript var returnData = structNew(); returnData.testing = TEST; /cfscript cfreturn returnData /cffunction I am doing an ajax request on test, and getting the error Variable getTest is Undefined, failing at the point of calling the getTest function. I have tested removing the line of code and successfully completed the ajax request, as well as just making the request without ajax involvement and calling both functions. I even var scoped the call to the function-- still no luck. I think I'm doing something dumb, but it's not jumping out at me... any help is greatly appreciated! ~| 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:339063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Array Error
You'll need to use a struct to do your bidding instead of an array-- I don't think you can skip values in arrays, so if your query is returning account_ids 1,2,4,5, #3 would fail. maybe something like... cfquery datasource=cfflex name=q SELECT t1.account_id FROM accounts1 AS t1 LEFT JOIN accounts1 as t2 ON t1.account_id = t2.parent_id WHERE t2.account_id IS NULL /cfquery cfset treeData = structNew() / cfset vleafnodes = arrayNew() / cfloop query=q cfset vleafnodes[q.account_id] = q.account_id /cfloop cfquery name=getRec datasource=cfflex SELECT account_id, name, acc_num, debit, credit, balance, parent_id FROM accounts1 WHERE ... /cfquery cfloop query=getRec cfset vLeaf = false cfif structKeyExists(vleafnodes, getRec.account_id) cfset vLeaf = true /cfif /cfloop Hi All - I am trying to do the following in my code. cfquery datasource=cfflex name=q SELECT t1.account_id FROM accounts1 AS t1 LEFT JOIN accounts1 as t2 ON t1.account_id = t2.parent_id WHERE t2.account_id IS NULL /cfquery cfset treeData = arrayNew(1) / cfset vleafnodes = arrayNew(1) / cfloop query=q cfset vleafnodes[q.account_id] = q.account_id /cfloop cfquery name=getRec datasource=cfflex SELECT account_id, name, acc_num, debit, credit, balance, parent_id FROM accounts1 WHERE ... /cfquery cfloop query=getRec cfif getRec.account_id EQ vleafnodes[getRec.account_id] cfset vLeaf = true cfelse cfset vLeaf = false /cfif /cfloop The array for the vleafnodes looks like below: array 1 [undefined array element] Element 1 is undefined in a Java object of type class coldfusion.runtime.Array. 2 [undefined array element] Element 2 is undefined in a Java object of type class coldfusion.runtime.Array. 3 3 4 4 5 [undefined array element] Element 5 is undefined in a Java object of type class coldfusion.runtime.Array. 6 6 7 7 8 8 using isdefined or isarray to check if the element is defined in a particular position is not helping during the comparision statement cfif getRec.account_id EQ vleafnodes[getRec.account_id] I keep getting the following error Element 1 is undefined in a Java object of type class coldfusion. runtime.Array. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Null Pointers are another name for undefined values
I've gotten this error before. I don't know if this is the same thing or not, but in my case, I got the null pointers error only on the application start, a refresh would make it work. anyway, it took me a few weeks, but the solution (at least in my case) was either checking or unchecking (i can never remember which... so just the opposite of whatever it is now) the maintain connections box in the coldfusion admin under database connections. I had to call my hosting company to get it done, but they complied and I have never had the problem since. HTH! ~| 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:329209 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Working With Images
try googling cfimage, or if you like learning by example, download galleon forums and play around with the avatar uploader. i'm sure there are more (and possibly better) examples but it's the first thing that comes to mind Hello. I was ask to help build a dynamic website for a volunteer fire department were they could add news and photos. Iâm having trouble with the photos. Does anybody know of a free or paid website were I can find some coldfusion code to add, edit, update, and delete images. I would like to be able to add the images to a database and have CF8 crop the images too. Thanks for your time, Barry ~| 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:329090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Setting Static Image Expire
Oh! Sorry, I'm testing on IE 7. Sry if this was ot-- I was thinking I would probably need to implement a cfheader somehow to get the browser to cache images, i was just stuck on how to change the http header for the images that are loades... so not really an issue with CF, just one I thought it could fix... but apparently not =( appreciate the help regardless, though! nothing... really? Yes really. Not to be a jerk or anything but this is OT. You might be better of hitting up a UI list as this is not a cf issue but a browser issue or even worse a (shudder) IE issue. You have not told us what version of IE you are using so we can check it. That is a critical piace of info. There are 3 versions of IE in common use these days 7, 8 and the dreaded 6. I know, cross browser UI can be a total pain... wait strike that... a LIVING NIGHTMARE when it comes to IE. So I feel your pain. It literally could be anything. I would start commenting out parts of the page until you find the offending piece of code. I have had hidden form fields and JS blocks throw off page elements before. I would also try using other roll over techniques (There are dozens) and see if that fixes the problem. HTH and Godspeed. G! On Sat, Dec 5, 2009 at 1:14 PM, Jessica Kennedy police_kidnapped_your_child...@yahoo.com wrote: nothing... really? ~| 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:328899 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Setting Static Image Expire
nothing... really? ~| 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:328890 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Setting Static Image Expire
Well, it's good you didn't see it I guess... It's only on the 5-6 links at the top. Yes, I have combed through every combination of google searches I can think of, but the problem is that I do not know how to implement the information, I have not been able to find a single source that has told me how TO SET caches (most trying to prevent it)-- and especially not how TO cache an IMAGE in IIS. I need someone to tell me EXACTLY how to go about doing this. I know it can't be hard, there are a million resources that almost tell me. Hello, I do not see any image flickering going on with IE. I do see that your background image is a little over 1MB in size. You should really work on optimizing that. A google search provides a lot of info: http://www.google. com/search?hl= ensource=hpq=add+expires+header+to+imagesaq=1oq=add+expiraqi=g10 http://www.google. com/search?hl=en source=hpq=add+expires+header+to+imagesaq=1oq=add+expiraqi=g10if that link doesn't work search for: add expires header to images Randy On Sat, Dec 5, 2009 at 1:14 PM, Jessica Kennedy police_kidnapped_your_child...@yahoo.com wrote: nothing... really? ~| 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:328893 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Setting Static Image Expire
I'm having some issues with the classic flickering images on rollover in IE for one of my sites. here is a link to one of the pages: directfighter.com/http://www.directfighter.com/calendar.cfm?tmonth=10tyear=2009pmtr=srchst= I have tried caching the css page. this helped some on the gigantic background image (which def. needs to be cached or something!), not so much on the flicker for the rollovers. I have looked at doing the preloaded image thing, both the css version where you load a single image with the different states, and using javascript(idk maybe i did the js wrong??), but since I am going from no image at all to a loaded image, pretty much all of those solutions are out =( I also tried the I give up method, where I implemented a different css for IE that simply filled in the bg with a color on hover. no good, still flickering uglier. I then had the thought that perhaps IE was looking through the first css sheet, then looking into the second css, so this solution may have been ever slower. sooo... I passed an ie=1 param into my first stylesheet and simply did an if statement to select either an image or a background color... also a fail. I then called my hosting company, as I don't have access to IIS myself to see if they could help- no. Yslow told me to add expirations to the images for faster loading, which seems like it would work, but I have yet to find how to do this, although I am sure it's extremely easy. I feel like I am missing something very simple, that will make me roll my eyes and want to scream for all the time i've dedicated to this... please help-- any advice would be super! ~| 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:328845 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 POST with Coldfusion
this will create a valid xml header to send along, over cfsavecontent: !---create xml--- cfxml variable=apisend SMS authentification username/username password/password /authentification message sender/sender text/text /message recipients gsm messageId=âclientmsgID1â/gsm gsm messageId=âclientmsgID2â/gsm gsm messageId=âclientmsgID3â/gsm gsm messageId=âclientmsgID4â/gsm /recipients /SMS /cfxml !---send--- cfhttp url=http://www.myserver.com/AddOn/myService/XML/XMLInput; method=POST throwOnError=Yes charset=utf-8 result=getresp cfhttpparam type=XML value=#apisend# /cfhttp !---dump the response--- cfdump var=#getresp.filecontent# Okay, this should be a nut-cracker on this Blog. I need someone to develop a coldfusion script that will communicate to a server/service using XML POST. Parameters are: SMS authentification username/username password/password /authentification message sender/sender text/text /message recipients gsm messageId=âclientmsgID1â/gsm gsm messageId=âclientmsgID2â/gsm gsm messageId=âclientmsgID3â/gsm gsm messageId=âclientmsgID4â/gsm /recipients /SMS service url is:: http://www.myserver.com/AddOn/myService/XML/XMLInput. No replies yet. Okay let me step this up a little bit. $20.00 (Taxable) for anyone on cracks this one. ~| 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:327704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
GetHTTPRequestData().content bytearray
i'm programming a response handler for receiving xml data sent via a 'get' request from a 3rd party api. I have tested my handler without problems using sample xml, however, when the info is sent from the api, I get the error: ByteArray objects cannot be converted to strings. here is the line causing the error: cfset xmlstr = GetHTTPRequestData().content How can I get the xml parsed without throwing this error? I'm sure it's simple, but google has not been kind to me on this one! Thanks for the help! ~| 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:327629 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Trouble with query...
i'm not very familiar with sql server syntax, but would something like this work? SELECT IFNULL(cpn.numCoupons,0) as numCoupons, couponcode, THEORDERDATE FROM tblOrders LEFT JOIN (SELECT count(couponCode) AS numCoupons, THEORDERDATE FROM tblOrders WHERE THEORDERDATE AND couponcode = cfqueryparam value=#getcouponData.couponcode# AND orderpaid = 1) as cpn ON cpn.THEORDERDATE=tblOrders.THEORDERDATE WHERE THEORDERDATE SQL Server I'm trying to report on the number of orders per day that has coupon code associated with them. The problem is, we can have multiple coupons running at the same time. My query just counts the number of coupons used per day. It doesn't filter by couponcode. But the minute I add a WHERE clause, it filters out all the days where coupons weren't used - not what I want. I want to even show the days where coupons were not used. Here's what doesn't work. If I remove the WHERE couponcode clause, it show all days of the couponcode. Which is almost correct, but I need to tell it to show the totals for a particular couponcode. SELECT DATEADD(d,DATEDIFF(d,0,orderdate),0) AS orderdate, count(couponCode) AS numCoupons, couponcode FROM tblOrders WHERE cfif len(form.startDate) and len(form.endDate) orderdate between #createODBCdate(getcouponData.couponstartdate)# and #createODBCdate(getcouponData.couponenddate)# /cfif WHERE couponcode = cfqueryparam value=#getcouponData.couponcode# AND orderpaid = 1 GROUP BY DATEADD(d,DATEDIFF(d,0,orderdate),0), couponcode ORDER BY DATEADD(d,DATEDIFF(d,0,orderdate),0) Thanks, Will ~| 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:327632 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sharing vars between applications
Are the two domains on the same server and sharing the same application name? On Tue, Dec 30, 2008 at 6:12 PM, Jessica Kennedy police_kidnapped_your_child...@yahoo.com wrote: yes, they are. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317298 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
sharing vars between applications
Posted this last week... no response, I am still not any further... any help would be greatly appreciated! OK, I have a member area on my site that is unencrypted. there are a couple of pages that need to be encrypted as they deal with passing credit card info to our cc processor. I'm using crystaltech, so our site has a mirrored site on their shared SSL domain. I thought it would be fairly easy to pass some session vars to the mirrored site and keep the user logged in, but that is clearly not working; i am assuming because the cfid token are the same it is kicking me out of the system on the mirrored site. does anyone have suggestions for how i can accomplish this without moving my entire member area to ssl?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317279 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to deal with multiple sites within one
Dunno if mine is the best solution, but I've got about 10 sites pulling from one db, I put a cfswitch statement from the cgi variable to handle getting people to the correct pages; one if they type in website.com, one for www.website.com. I have not had any problems with this method yet... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317280 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
passing secure vars between applications
OK, I have a member area on my site that is unencrypted. there are a couple of pages that need to be encrypted as they deal with passing credit card info to our cc processor. I'm using crystaltech, so our site has a mirrored site on their shared SSL domain. I thought it would be fairly easy to pass some session vars to the mirrored site and keep the user logged in, but that is clearly not working; i am assuming because the cfid token are the same it is kicking me out of the system on the mirrored site. does anyone have suggestions for how i can accomplish this without moving my entire member area to ssl?? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317108 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: sql query help
didn't work, got an error. changed the isnull to ifnull, got a invalid use of a group function error... I don't even know how to fix that...=( Try this, I think it's what you're looking for: SELECT SUM(ISNULL(o.qty, 0)) as sold, p.sku, p.name, p.points, p. short_description, p.quantity, p.image FROM tblproducts as p LEFT JOIN tblorder_list as o ON p.sku = o.sku #can_afford# WHERE SUM(ISNULL(o.qty, 0)) p.quantity GROUP BY p.sku ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sql query help
NM, got it... changed the where clause to having and moved it below the group by... seems to be working so far! Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316373 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
sql query help
I have a MySQL query to pull all products from the database, no problem. I am trying to get it to only display prodcuts that are in stock, the value should be sold p.quantity in the following query. however, when sold appears as null (very often) it removes the full record, which I don't want. there has to be an easy way to do this... Here is my current query: cfquery name=rsproducts datasource=#application.db# SELECT SUM(o.qty) as sold, p.sku, p.name, p.points, p.short_description, p.quantity, p.image FROM tblproducts as p LEFT JOIN tblorder_list as o ON p.sku=o.sku #can_afford# GROUP BY p.sku /cfquery Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316295 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: BUMP Re: Odd null pointer error
I had this exact problem a couple of months ago. Someone answered the question in the original post, you need to have the maintain connections box either checked or unchecked (i can't remember which, but process of elimination should lead you to the answer!) This should clear up the problem. I had to call my hosting company, but they knew exactly what the problem was and how to fix it with hardly a word from me. Generally the error will occur if the site has been sitting for over 20 minutes, the default connection timeout...or at least this is what i was told, and it seemed to be true. Hope this bug gets fixed soon, that's for sure! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312337 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 js field verification
Well, the CF seems to be functioning properly, so I suppose the js is the
problem. I am not getting any error messages, however. I don't think the
function is running at all, as I added a popup message to either scenario and
still got no results. The tostring() i had to add because i was getting a
javascript error message saying that a numeric value was trying to be used as a
string (most of my vars are numbers).
What's not working, JS, CF? What does the source look like in the browser?
Some tips for you... you don't need the ToString() calls in CF and it's
Javascript not Java (big difference).
Adrian
Hi, I am working on a page where an admin would enter an id number for one
or more of a list of people. as it is important that the numbers match, I
am making a verification field to check the numbers match. All fine and
dandy, however I would like to have js check this before the form is
submitted. The code I have is not working, I am guessing it has to do with
naming the function, but I am pretty much a complete newbie to java. how
can I make this work?
cfoutput query=rscards
!---Convert int to string for java---
cfset chk=chktostring(rscards.dealerid)
cfset javaint=tostring(rscards.dealerid)
cfset java=javatostring(rscards.dealerid)
cfinput type=text name=#javaint# id=#javaint# value=
onvalidate=#java# / cfinput type=text name=#chk# value= id=#chk#
message=oops onvalidate=#java# /#rscards.first_name#
#rscards.last_name# #rscards.dealerid#br /
script type=text/javascript
function #java#(form) {
if(form.#javaint#.value == form.#chk#.value) {
return true;
}
else {
alert(Error: #rscards.first_name# #rscards.last_name#'s info does not
match.);
form.#chk#.focus();
return false;
}
}
/script
/cfoutput
cfinput type=submit value=Submit name=submit /
/cfform
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312338
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 border on each page?
I spent more time than I like to think on a similar problem, just had one page
but it was still very difficult to convince coldfusion to render the image at
the size I needed.
cfdocument format=pdf pageheight=11 pagewidth=8.5 marginbottom=0
marginleft=0 marginright=0 margintop=0
To force the image to the size I needed, I used an empty layer and trial and
error.
body {background:url(images/the-border.jpg) no-repeat fixed}
#Layer1 {
position:absolute;
left:317px;
top:728px;
width:642px;
height:21px;
z-index:11;
}
I added all my text using more layers and was careful to not make any layer
larger than my sizing layer.
Hopefully this will work on multiple pages for you...
I'm trying to create a CFDOCUMENT format=pdf that puts a border
around each page of the document. The content spans several pages.
When I place a background-image in the body and include the
backgroundvisible='yes' property, the border doesn't span the pages
properly. Even if I get the image to cover the first page properly,
the remaining pages are off.
I even tried putting a border in the header and footer, then create a
style left and right on the content, but it didn't pad out properly.
Bordered divs don't span pages either.
This seems like such a simple task. I'm pulling out what little hair I
have left...
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312344
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 js field verification
The info seems to be appearing correctly in the page source:
form name=form id=form action=runform.cfm method=post onsubmit=return
_CF_checkform(this)
input name=2 type=text id=2 / input name=chk2 type=text id=chk2
/John Doe 2br /
script type=text/javascript
function java2(form) {
if(form.2.value == form.chk2.value) {
return true;
}
else {
alert(Error: John Doe's info does not match.);
form.chk2.focus();
return false;
}
}
/script
-
I am really starting to think I'm missing something obvious here...
Jess
The ToString would do it's work before it got to the browser so it's
probably something else.
View the source of the page and see if all the functions and calls to
functions are named correctly.
Adrian
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312348
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 js field verification
I figured it out... the #javaint# field was all numeric, javascript didn't like
that. I just added a few characters to the beginning and it took care of it.
The info seems to be appearing correctly in the page source:
form name=form id=form action=runform.cfm method=post
onsubmit=return _CF_checkform(this)
input name=2 type=text id=2 / input name=chk2 type=text
id=chk2 /John Doe 2br /
script type=text/javascript
function java2(form) {
if(form.2.value == form.chk2.value) {
return true;
}
else {
alert(Error: John Doe's info does not match.);
form.chk2.focus();
return false;
}
}
/script
-
I am really starting to think I'm missing something obvious here...
Jess
The ToString would do it's work before it got to the browser so it's
probably something else.
View the source of the page and see if all the functions and calls
to
functions are named correctly.
Adrian
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312351
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
dynamic js field verification
Hi, I am working on a page where an admin would enter an id number for one or
more of a list of people. as it is important that the numbers match, I am
making a verification field to check the numbers match. All fine and dandy,
however I would like to have js check this before the form is submitted. The
code I have is not working, I am guessing it has to do with naming the
function, but I am pretty much a complete newbie to java. how can I make this
work?
cfoutput query=rscards
!---Convert int to string for java---
cfset chk=chktostring(rscards.dealerid)
cfset javaint=tostring(rscards.dealerid)
cfset java=javatostring(rscards.dealerid)
cfinput type=text name=#javaint# id=#javaint# value=
onvalidate=#java# / cfinput type=text name=#chk# value= id=#chk#
message=oops onvalidate=#java# /#rscards.first_name# #rscards.last_name#
#rscards.dealerid#br /
script type=text/javascript
function #java#(form) {
if(form.#javaint#.value == form.#chk#.value) {
return true;
}
else {
alert(Error: #rscards.first_name# #rscards.last_name#'s info does not match.);
form.#chk#.focus();
return false;
}
}
/script
/cfoutput
cfinput type=submit value=Submit name=submit /
/cfform
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312246
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: putting in cffile
THANK YOU! That worked perfectly! I need to write a .csv file with all data encased in quotation marks, the problem is that cffile output uses double quotes to define the data to input. How can I get around this?? Geez, i know it's got to be something easy... You can either double up on the double quotes in the string, or wrap the contents in single quotes instead of double quotes. For example... cffile contents=This is some awesome text with quotes! cffile contents='This is some awesome text with quotes!' Another way would be to use CFSAVECONTENT... cfsavecontent variable=theOutputThis is some awesome text with quotes!/cfsavecontent cffile contents=#theOutput# -Justin Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311722 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
putting in cffile
I need to write a .csv file with all data encased in quotation marks, the problem is that cffile output uses double quotes to define the data to input. How can I get around this?? Geez, i know it's got to be something easy... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311679 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: securing pdf's?
Thanks for all the tips! I was not able to change most of the pdf's to cfcontent because the pdf's legally could not be altered; however, I found this article on securing pdf's and other documents, thought I would post it since I'm sure someone in the future is bound to have the same problem. I was able to save all my pdf's in a directory and restrict access to 'execute only' for the 'everyone' group, but the file could be called for display or download using the method in the link below. http://mysecretbase.com/How_To_Display_Protected_Files.cfm ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310964 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
securing pdf's?
I have a directory of .pdf files nested within a secure section of my website. However, the application is not firing when a user goes to the direct link to the pdf, so anyone could see the pdf's... does anyone know a way to keep the pdfs from showing unless a user is logged in? Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: undefined value error... weird...
ok... hopefully no one else will encounter this error, but I found a forum that is discussing this issue... the problem isn't in the code but in the way coldfusion 8 is connecting to mysql 5 db... here is the link for those interested: http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1catid=3threadid=1303546highlight_key=ykeyword1=Maintain%20connections#4723205 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Just a little cfcase tip...
well.. I feel marginally less stupid now =) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308659 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: undefined value error... weird...
Duly noted on queryparams! Problem still is that I can't replicate the problem... if I cfdump the vars when I go back to refresh the page the error goes away, and I can't figure out how to get it back. I've considered the issue being in the application variable not declaring first. this code is in a stored template called to the page... could that be it, and if so,,, how can I fix it?? 1. Dump cgi scope to see what's in your server_name variable. 2. More of a heads up - the list is about to jump you for not using cfqueryparam in your WHERE clause. :) Whenever in doubt, dump! hth, Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308598 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: undefined value error... weird...
That might work assuming the error is in fact in the empty array... i needed a full array for a while, but it isn't necessary anymore, so that'll be something I will change. I think the error might be in the application, after all... I got the same error randomly in a secure section of the site where there was nothing else to be blank. at least now i have a pretty good idea of the cause, just not the solution... yet... Are you just trying to grab the server name? Looks like you're jumping thru an extra hoop converting it to an array like that. Just use this: listFirst(cgi.server_name, .) Doubt that solves your problem. Just something I noticed. Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308622 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
undefined value error... weird...
Ok, every once in a while, usually the first time I load my website every few hours, I am getting this error: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. upon refreshing the page, the error goes away completely (even clearing all private data will not bring the error back), which is making it very difficult to pinpoint exactly what the problem is... here is the code I have that is throwing the error, according to Coldfusion it throws on line 8: 4 : cfset finduser = ListToArray(cgi.server_name, .) 5 : cfquery name=rsfinduser datasource=#application.db# 6 : SELECT dealerID, username, first_name, last_name 7 : FROM tblsozo_dealers 8 : WHERE username = '#finduser[1]#' 9 : /cfquery The only thing I could figure is that finduser[1] was undefined, so I added a clause to give finduser[1] a name in the highly unlikely event that it was undefined, to no avail. Also, the error is only throwing on my web server, not on the testing server, don't know if that is important or not. Any help would be greatly appreciated! Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308580 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query help
no luck... I do need the group by clause, my actual query is much larger than the one posted. the problem, for example is this: for five people, paid=no, for five others, paid=yes under one parent sponsor. I am now getting a result of 10, but I need the result to be 5, only counting those people under sponsor who have paid. what am I doing wrong?? =( ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
query help
I'm pretty sure I will smack my head when I hear the answer, but I'll ask anyway... I am using a select count() query to get the number of people directly sponsored by a person... this works fine, the problem is that I only want to have the query count people that meet a certain qualification. There has to be a simple way to do this, my query pretty much looks like this: SELECT COUNT(node.name) FROM tbl1 as node, tbl1 as parent WHERE parent.sponsor=node.name AND node.paid='yes' GROUP BY node.name the AND node.paid='yes' seems to be doing nothing... I'm pretty sure I'm missing something really simple, help! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: credit card storage help
so you're saying I shouldn't do it??? =) ok, you convinced me... I was pretty nervous about doing that anyway... looks like shift4 will do what I need anyway. and for those of you in a similar situation, i would NOT recommend cardservice international for anything even vaguely large-scale. not got at all... thanks for the advice about saving data as separate encrypted fields... I really don't have any choice but to collect some sensitive info so I will employ that technique... even if the data will only be on the database for a max of 20 min, i'm not taking chances! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305961 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
credit card storage help
I need some help finding a secure way to store credit cards on a website I am working on. I know, I know you shouldn't do it unless you absolutely MUST, but it looks like I absolutely must, sad to say. I have to set up reoccurring payments with credit cards that will notify the user if their card is declined and lock them out of certain website features as well. Coding the above is not a problem, I am just very nervous about keeping credit card information on anyone. I know the card #'s need to be stored encrypted, but that's still a pretty broad range of options... any help would be much appreciated! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: credit card storage help
Cardservice international... they store partial card #'s for reference if I am not mistaken... they have a reoccurring billing feature on their website, the only problem is that once a person is entered into the reoccurring cycle, they will run the person's credit card over and over and stick us with the fees regardless of how obvious it is the card is going to decline. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305918 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL Stored Procedure Help!
Jessica Kennedy wrote: I have looked over the various methods for displaying hierarchal data with MySql, and there don't really seem to be many elegant solutions-- the best method (according to many) seemed to be creating a column for lft rgt values as a nested tree structure That is called a nested set and is pretty much optimized for reading. Well, there will be three functions I intend to use this thing for... finding the first available slot for placing someone in a downline- which will probably be used between 20 50 times/day, viewing a particular person's downline, which could be used hundreds or thousands of times per day, calculating bonuses for each person based on their own particular downline, which will be done once weekly. I guess reading will be what is done most in this instance. which is completely impractical in this situation because I would have to re-assign those variable every single time somebody inserted a record into my database (which should be many times/day). How many is many? Let's say that recalculating your nested set is going to take 15 seconds every time it is updated. Is that really a problem? Well... that IS a good point... =) I found the syntax here: http://www.evolt.org/node/4047 however, I know basically nothing about proper syntax for stored procedures, and have really not found a lot that has helped. Why, oh, why is this syntax giving me errors? Because that syntax is for MS SQL Server 6.5 and you are using MySQL. Still don't know the syntax... but it looks like this model is out anyway, so it doesn't matter. Equally as important, does this method of creating a temp table seem like an appropriate solution to my problem? Not if you intend to do this on every request. well, that was the plan. so yeah, guess this is out. What I have done before is used a denormalized model where the records themselves had an adjacency list model, but I maintained a nested set in a separate table. With a trigger on the records themselves that only fired when the ID and/or parentID fields changed and updated the nested set the rest of my code could use either the adjacency list or the nested set depending on what was easiest. The only thing to watch out for is the way you handle concurrency issues in your trigger code. This paragraph confused me to no end, could you please explain a little more? thanks! Jessica ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292123 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MySQL Stored Procedure Help!
Hey, I have posted a couple of times on getting a hierarchal tree 22 levels deep programmed for an MLM company. My original coding was using too much memory, as I was more or less creating a FILO type structure with several arrays. I have looked over the various methods for displaying hierarchal data with MySql, and there don't really seem to be many elegant solutions-- the best method (according to many) seemed to be creating a column for lft rgt values as a nested tree structure, which is completely impractical in this situation because I would have to re-assign those variable every single time somebody inserted a record into my database (which should be many times/day). The best method I have found (I think...) is to create a temporary FILO stack table using a stored procedure. I found the syntax here: http://www.evolt.org/node/4047 however, I know basically nothing about proper syntax for stored procedures, and have really not found a lot that has helped. Why, oh, why is this syntax giving me errors? (other than the obvious change the variables to match those in my database). I'm using navicat 8 for mysql for my database interactions, dunno if that could be the cause or not... Equally as important, does this method of creating a temp table seem like an appropriate solution to my problem? Will this method even work if I have several people wanting to access their genealogy at the same time? Sigh... I feel so over my head... thanks for the help, regardless=). ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
fixing outofmemoryerror: java heap space
Hi, I am running a coldfusion page that calculates a large volume of variables, which has thus far not been a problem. The pages have worked fine (maybe taken a while to load) on my testing server on some web space I have. However, I uploaded the file to its final resting place on a semi-dedicated server, and I am now getting an error 500- outofmemoryerror: java heap space. I have just set up this server-- so I am hoping there is some value I can tweak that will allow this page to run... it is vitally important to the website that it works... does anybody know what I could do? Thanks! ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help cleaning up my code...
hi, I posted a while ago about an outofmemoryerror: java heap space problem.
Anyway, it's looking like the only way to fix this problem is to re-write some
programming. The program I wrote is for displaying a tree structure of
people in a database based on the upline person. IE: i recruit someone, who
recruits 2 people, who recruit 3 pl, so on down to 22 levels with a max of 2
ppl that can be under you. The code that I have works, but it takes of a crazy
amount of memory, which is bad. the working version is viewable at
http://dummbo.triadwebcrafters.com/dealers/dealer_tree.cfm . I know its a lot
of coding, but if somebody can think of a way to make this thing more
manaeable, I would really appreciate it! Here is the coding I have for the
page:
cfparam name=SESSION.dealerid default=999
cfparam name=FORM.dealerID default=#SESSION.dealerID#
cfparam name=form.stoplooping default=0
cfquery name=rsgetname datasource=cfdummbo
SELECT dealerID, first_name, last_name
FROM tbldealers
WHERE dealerID = #FORM.dealerID#
/cfquery
cfset display=0
cfset namesave=ArrayNew(1)
cfset downlinecount=0
cfset newname=ArrayNew(1)
cfset newname[]=#FORM.dealerID#
cfset totalcount=0
cfset oldestdownlinecount=0
cfset looptimes=0
cfset displaynamecount=0
cfset oldtotalcount=-1
cfset oldlevelis=1
cfset division=50
cfset flag=no
cfset accumulation=0
cfset blankcount=0
cfset oldaccumulation=0
cfset oldlevelnumberlow=0
cfset peoplecount=0
cfset totalpeoplecount=0
cfset displaypeoplecount=ArrayNew(1)
cfset qual_count=0
cfset stoplooping=#form.stoplooping#
cfset pagetitle=My Downline
cfinclude template=hidden_header.cfm
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
head
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /
titlecfoutput#title#/cfoutput/title
link href=dealers_style.css rel=stylesheet type=text/css
media=tv,screen,tty /
style type=text/css
table {text-align:center;}
/style
/head
body
div align=centerimg src=images/dealers_main_banner.jpg alt=Dummbo.com
Hot Names...Cool Cash /
/div
h2View All Members In Your Donwline/h2
!--Sets the opening table and creates first part of the 1st level table--
table border=1 cellpadding=5 cellspacing=0 width=100% align=center
tr
tdstrong
cfif #session.dealerID# eq #form.dealerID#
Me, cfoutput#rsgetname.first_name# #rsgetname.last_name#
(ID: #session.dealerid#)/cfoutput
cfelse
a
href=dealer_details.cfm?dealerID=cfoutput#FORM.dealerID#/cfoutputcfoutput#rsgetname.first_name#
#rsgetname.last_name#/cfoutput/a
/cfif
/strong/td
/tr
/table
table border=1 cellpadding=5 cellspacing=0 width=100% align=center
tr
!--Main loop. everything else is inside of this loop.--
cfloop condition=(flag EQ 'no')
cfset stoplooping=#stoplooping# + 1
!--Sets the next name to run. Default is 999, which will display the
SESSION.dealerID parameter.--
cfif #downlinecount# EQ 0
cfset display=
cfelse
cfset display=#looptimes#
/cfif
!--Runs the next name in the list.--
cfquery name=rsmatrix datasource=cfdummbo
SELECT dealerID, first_name, last_name, upline
FROM tblDealers
WHERE upline = #newname[display]#
/cfquery
!--Sets the name and dealerID temporarily, will set permanently in next
section.--
cfset cyclecount=0!--IMPORTANT! Must reset each loop!--
cfoutput query=rsmatrix
cfset downlinecount= downlinecount +1
cfset cyclecount= cyclecount +1
cfset 'namesave#cyclecount#'='#first_name# #last_name#'
cfset 'dealerID#cyclecount#'='#dealerID#'
/cfoutput
!-- This section sets blank or (two dashes'-') value for extra people not
in downline assigns unique ID's to each person --
cfif newname[display] eq 99
cfset totalcount=totalcount+1
cfset namesave[TOTALCOUNT]='--'
cfset newname[TOTALCOUNT]=99
cfset totalcount=totalcount+1
cfset namesave[TOTALCOUNT]='--'
cfset newname[TOTALCOUNT]=99
cfelse
cfif cyclecount eq 0
cfset totalcount=totalcount+1
cfset namesave[TOTALCOUNT]='Blank'
cfset newname[TOTALCOUNT]=99
cfset totalcount=totalcount+1
cfset namesave[TOTALCOUNT]='Blank'
cfset newname[TOTALCOUNT]=99
/cfif
cfif cyclecount eq 1
cfset totalcount=totalcount+1
cfset namesave[TOTALCOUNT]=#NAMESAVE1#
cfset newname[TOTALCOUNT]=#dealerID1#
cfset totalcount=totalcount+1
cfset namesave[TOTALCOUNT]=Blank
cfset newname[TOTALCOUNT]=99
/cfif
cfif cyclecount eq 2
cfset totalcount=totalcount+1
cfset namesave[TOTALCOUNT]=#NAMESAVE1#
cfset newname[TOTALCOUNT]=#dealerID1#
Re: Creating replicated sites with coldfusion
Jessica: Also, have you considered using wildcard DNS? As in http://jessica.sample.com You can do that by simply adding a * A host entry in your DNS manager. Michael This sounds like a good Idea... what would be the proper syntax to use to get the username field if I went with a wildcard variable? I don't have a lot of experience with CGI variables, which seems to be what I will need to do this. Also, I will be using an IIS server, not apache, and I don't think there is a mod_rewrite equivalent with IIS, hopefully somebody can prove me wrong though! ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating replicated sites with coldfusion
Ok, this was what my original thought was... can you explain this part better for me please: This page will parse the cgi.request_uri string into an array based on the / character. -- This is the part that I have been struggling with... thanks! Use a custom 404 page. You will need to update the 404 error handling in your server (Apache, IIS, etc) to point to this new page on all 404 errors. This page will parse the cgi.request_uri string into an array based on the / character. Do a check in the database for the user which matches the value in the last position in the array. (or you can do an 'or' check for each of the positions after the host_name) If the result is eq 1, then display the agent's website. If the result is gt 1, then display a 'choice' of which one the user had intended to type in. If the result is eq 0, then show your 404 error page. William -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer http://William.Seiter.com Hi, I am working on a site for a MLM company that wants each person who signs up with the company to have their own replicated website. The replicated site is really no more than each person having a separate URL that is defined by the username they put in when they sign up- everyone's site is exactly the same otherwise. For example, if I signed up for the program with a username of jessica my replicated website's address would be http://www.sample.com/jessica;. I do not want to have to create a separate folder index page for each every person who signs up, because that seems like it would be kind of ridiculous waste a lot of space, so how can I (firstly) trick the server into believing there is a separate page for each person even without a folder with their username existing in my directory? Second, and I guess this question could be answered by the first, how can I get that username to be pulled from the URL for use in dynamic queries and the like. -More or less, I am just wanting to somehow convert a query string such as http://www.sample.com?username=jessica; into the more user-friendly http://www.sample.com/jessica;. I think i am making this harder than it really is.. hopefully I have made this clear enough to understand, and any help would be greatly appreciated! Thanks!! ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291244 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Creating replicated sites with coldfusion
Hi, I am working on a site for a MLM company that wants each person who signs up with the company to have their own replicated website. The replicated site is really no more than each person having a separate URL that is defined by the username they put in when they sign up- everyone's site is exactly the same otherwise. For example, if I signed up for the program with a username of jessica my replicated website's address would be http://www.sample.com/jessica;. I do not want to have to create a separate folder index page for each every person who signs up, because that seems like it would be kind of ridiculous waste a lot of space, so how can I (firstly) trick the server into believing there is a separate page for each person even without a folder with their username existing in my directory? Second, and I guess this question could be answered by the first, how can I get that username to be pulled from the URL for use in dynamic queries and the like. -More or less, I am just wanting to somehow convert a query string such as http://www.sample.com?username=jessica; into the more user-friendly http://www.sample.com/jessica;. I think i am making this harder than it really is.. hopefully I have made this clear enough to understand, and any help would be greatly appreciated! Thanks!! ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291134 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
