GROUP BY year, month loop

ok i am having a slight brain fart. have left my reference books at home i want to loop through year, grouping by month displaying sum total. right now i have it grouping by month displaying sum total, but it lumps the year together.. should be simple, and i have search archives.. thanks

gps stuff with cf

just curious if any one has any gps experience. looking at phones that can send / receive gps info. not sure on which one i will go with, probably Nextel, but wanted to see if any one out there had any cf examples on tracking people. not entirely ot. -paul

RE: GROUP BY year, month loop

hey Deanna. i figured it out.. was just the morning fog... thanks.. -paul cfquery name=rsDisMonth datasource=recycle SELECT Year(Offload_Date) as yearEnterd, Month(Offload_Date) as monthEnterd, SUM(Offload_Gallons) AS SumGal FROM tblOffload GROUP BY Year(Offload_Date), Month(Offload_Date)

RE: Dreamweaver and include files

yes, it can dl the trial. ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

JavaScript close window parent

hey guys. this is for file browsing, on a public server then on a SSL server. it pop opens a dir structure of links, you select one it closes the window puts the value in a form field. if i run the code on the local/pub server it closes the window puts the value in the right field.. but

ot: js question :: validate :: select 3 out of 5 fields

ok, Dan switzer started me off with the js below. which forces user to select 1 of 5 fields. that works just like he intended it to! i would like 3 of 5 to be selected. i have messed with all the 0's and 1's with varied results... but none right.. so need to ask for some one out there with js

RE: cftree fckeditor js close window..

OK.. THIS WORKS... cfoutputA href=javascript:getDoc('/EM/Global_Images/#Global_Images.name#');#Global_Images.name#/A/cfoutput this dosnt.. cftreeitem value=#Global_Images.name# display=#Global_Images.name# parent=Global_Images img=#request.publicurl#/EM/Global_Images/paint10.gif

RE: js question :: validate :: select 3 out of 5 fields

i have tried oForm.apple.validateAtLeastOne(banana); oForm.orange.validateAtLeastOne(watermelon); oForm.grape.validateAtLeastOne(apple,orange,banana,watermelon); with mixed results.. always 1 selection that leave to many selcted or not anough... oh well. going home. -paul

cftree fckeditor js close window..

ok first i am using cfdirectory to browse for files that i am trying to feed back to fckeditor. a can brows the files i want.. i am not able to force the pop up that displays my directory structure to close using the window.close(); inside of cftreeitem. also the window to receive the info

ezedit

i am working on a old site that relied heavily on ezedit to update html in a db. it is pretty slow for the end user... what are people using to do wysiwyg inline editing.. ~| Archives:

RE: Qforms N-select related?

i would like to see a working cf/database example of this too! i cant hit the happy hacker site form work.. the site is flagged as extreme? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

testing for format isNumeric

this is pulling from an old oracle database i don't have access to correct any problems with data type mismatches. so looks like there may be alpha characters or other junk in a gallons numeric field that is displayed... what i want to do is if i cant do a calculation to a field do to a data

RE: cf studio

i think all reference to them have been replaced with home site or dreamweaver good luck ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

cfdir cffile over slow connection

ok. just curious what people use for cfdirectory cffile on slow connections to the server? seems like uploads are timing out before they are mover. also cfdirectory is SO slow, make me want to leave the building for a while. queries are standard boring.. is there a dirTree that is faster?

RE: Archiving Dynamic Site to HTML

webzip ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the

RE: CFForm madness. 0_0

wish qforms was built into dwmx.. cough cough... seems like a standard way of validating for over 3 years now... -paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

siteminder :: CFserver 5 :: what's it do??

hey guys. i cant find any good info on what site minder is or does. i know its a part of some security feature in 5 but not sure if it is needed, on our internal server.. any links or info? thanks -paul ~| Archives:

copy search results in dwmx

is there a way to copy the search results or save results into a text file?? say i did a search on: datasource= just to give me a list of all data sources called in a site. so i can then put it into a spread sheet or what not, for maintenance whatnot. if there isn't a way, can i get it in

RE: video formats streaming

thanks Michael its on a secure server just for internal use the only reason they want it streamed is that they are pretty chunky files. training videos that can be over 20 minutes long.. guess i will look into setting up a real server, since we own it. just dislike its format the way they treat

RE: video formats streaming

thanks guys. did find out the real server is out of it, even though we own it the port is blocked, we don't have a spare box. the quality is already pretty lousy. the only real reason to stream is to help lbu, but with a 60meg.rm file or 80meg.mpg then i think those 14.4 users are out of luck..

wins ip's other non net guy questions...

ok... some changes where made to the ColdFusion server. WINS ip settings, possibly a dns setting. i have no real way of being able to tell how it affects CF, if at all? now intermittently things are not working. i have no idea what i need to look for we have to drive off site to get physical

ot: video formats streaming

just curious what you guys use to stream video? right now i have a ton of *.rm clips i have converted them to mpeg, but wound up bloating the size a bit. not sure if i should run a real server for streaming or if there is a way to let a viewer watch a mpeg with out them being able to down load

RE: Hierarchical Menus script with CF

http://www.dynamicdrive.com/dynamicindex1/hvmenu/ http://www.dynamicdrive.com/dynamicindex1/hvmenu/hvmenu.zip ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

wins resolution

hey guys.. all the sudden an app i am working on has lost its sense of location. session.is_InsideHere so shows you are not Inside the Building when i am... the only thing has changed is an admin has updated a wins/ip thingy on the server. could that be it? on localhost it is fine...

RE: wins resolution

it worked earlier... i didn't change any thing that should affect the session. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

RE: wins resolution

ok.. i am just not sure what to post. have just taken on this site over the last 2 weeks. it is a fusebox application with a lot of neat things i never played with before. also is a .mil thing ~| Archives:

RE: wins resolution

ok i talked to the server admin. he said he had a problem restarting the server. so could this cause a session var to get hosed? and if so shouldn't it get automatically after the application times out? in 20 minutes? or would the server have to be restarted cleanly.. i just don't understand

RE: Any advice? (multiple selects)

do you have an example of the qform multi select pulling from a db. just the code? i see the example pulling from a structure. -paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

RE: TagCFMail::sendMessage

looks like it was a permissions issue. odd that it was an issue. thanks every body! -paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

request.. why use it?? how to reset it?

ok why use a variable that starts with request.email or what ever? seems hard to reset.. even though it is being pulled from a data base if i change the data variable dosnt seem to reset.. why is that? how do i force the app to grab the new updated varianble? thanks.. -paul

RE: request.. why use it?? how to reset it?

sorry. i mean the request. i have changed every referance to a certain email.. in code in a db but it is still grabing the old email address. it is in a fusebox frame work. thanks -paul -Original Message- From: Ihrig Paul E Cont 88 ABW/EM [mailto:[EMAIL PROTECTED] Sent: Monday, July 07

RE: request.. why use it?? how to reset it?

ok.. found a query to reset the request's. just a weird process. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ:

RE: request.. why use it?? how to reset it?

no looks like the application.cfm calls a seperate page once to set the request variables it is then only refreshed once the application has times out.. 0,2,0,0 whats that 2 days or 2 hours? any way.. just goofy way to set variables.. but then again, i am not a fuseboxer, just fixing old code..

RE: TagCFMail::sendMessage

ok still having the problem. did a test on the mail server and it is fine. ran the patch on the server still having problerms... cf server 5 win 2000 iis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

TagCFMail::sendMessage

ok i am getting errors on all CFMAIL tags on the production servers: the code is fine on the localhost. the guys have given me access to the mail server and it looks fine... but i cant figure out this problem.. also trying to use qforms /lib in the base dir, but cant get it to recognize or

RE: TagCFMail::sendMessage

nope.. Dayton Ohio. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

RE: TagCFMail::sendMessage

http://www.macromedia.com/support/coldfusion/ts/documents/tn17552.htm looks like it is a known issue. guess these guys stuff just stoped working four months ago. will do the patches oon the servers see what happens! thanks.. btw.. great search feature on houseoffusion.

ideas on using cftree to delete files.

hey guys! never really used cftree. looking at some code that i would just like to have a delete function next to each image or file that sends the id to a page that deletes the record from the db deletes the file from the server. just not sure where or if i can have links variables inside a

RE: ideas on using cftree to delete files.

ok i got this.. it works.. but is SO freaking bad... on the tree it displays the imageicone/name then below it show Delete image. i would rather it all be on 1 line, but cant get it to look right. very clumsy not safe/secure.. i sure could use some help... thanks -paul :: tree