Re: CF and ASP
Yea...I found a few on MM exchange. They just need a little modifying --Original Message Text--- From: Larry C. Lyons Date: Mon, 24 Nov 2003 21:04:30 -0500 Bushy wrote: > Can I have some ASP code in my test.cfm file? Its a breadcrumb writting > in ASP. > Why bother? There are several very good bread crumb functions and custom tags on MM exchange and cflib.org. larry [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cf calendar
hi there. looking for a cf based calendar, that can have sql server as its backend, and i can add events to it, and i can extend on it. money isnt an issue. features are where its at! suggestions anyone? thanks. tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
I use an applet from Infomentum called AppleFile 2.5 http://www.infomentum.com/products/download.asp This will allow you to upload multiple files, but you are limited by the number of files because the cf server times out. I have not figured out how to use the requesttimeout var to extend the timeout. But it works much better than html forms (but I have those avail also). -w At 06:49 PM 11/24/2003, you wrote: >50 mb? Criminy. > >Supposedly, CF will release memory it doesn't need. Probably not >immediately. All I can say for sure is its not unusual for CF to eat that >much, by any stretch. > >Not what you want to hear, but if you are thinking of setting up and >allowing Godzilla-size file uploads you really should have your server >memory squared away. As in lots of the stuff available. > >-- >--- >Matt Robertson, [EMAIL PROTECTED] >MSB Designs, Inc. http://mysecretbase.com >--- > >-- > >-- >[ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF and ASP
Bushy wrote: > Can I have some ASP code in my test.cfm file? Its a breadcrumb writting > in ASP. > Why bother? There are several very good bread crumb functions and custom tags on MM exchange and cflib.org. larry [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
50 mb? Criminy. Supposedly, CF will release memory it doesn't need. Probably not immediately. All I can say for sure is its not unusual for CF to eat that much, by any stretch. Not what you want to hear, but if you are thinking of setting up and allowing Godzilla-size file uploads you really should have your server memory squared away. As in lots of the stuff available. -- --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
Just checked I was able to upload 50mb compressed zip. However, doing this caused jrun.exe to swell something fierce (about 100mb). At the moment I have barely enough memory for this, but am wondering if jrun.exe will relinquish this memory, hold onto it for reallocation of subsequent steps, or just keep ballooning. Any thoughts? -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:54 PM To: CF-Talk Subject: RE: Advise about how to upload multiple files Maybe it won't work for you on this job, but CF has a way to handle this in every respect except the sheer size of the job:: Use CFFILE as usual and only accept the MIME type application/x-zip-compressed. You could then use Ben Forta's CFX_Zip to do the unzipping, and take the resulting file list (if cfx_zip doesn't give it to you, use cfdirectory) and use that to build up your post-upload description form, db entries etc. etc. Using CFFILE limits you to about 4mb of upload due to an IIS bug. I've gotten away with 5.6 mb, but I wouldn't bet on that being anything you can rely on. CFFTP could be used instead, I suppose. Never really needed to do BIG uploads with CF. -- --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
Maybe it won't work for you on this job, but CF has a way to handle this in every respect except the sheer size of the job:: Use CFFILE as usual and only accept the MIME type application/x-zip-compressed. You could then use Ben Forta's CFX_Zip to do the unzipping, and take the resulting file list (if cfx_zip doesn't give it to you, use cfdirectory) and use that to build up your post-upload description form, db entries etc. etc. Using CFFILE limits you to about 4mb of upload due to an IIS bug. I've gotten away with 5.6 mb, but I wouldn't bet on that being anything you can rely on. CFFTP could be used instead, I suppose. Never really needed to do BIG uploads with CF. -- --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Unable to Update the CFMX ODBC Server ( Was Error with Web Connector after installing CFMX 6.1)
So umm... anyone ever encounter this error? I can't seem to find a way around it. 0_0 -Gel -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] I fixed this by using 127.0.0.1 . I've now run into another problem: Unable to update the ColdFusion MX ODBC Server. Timeout period expired without completion of F:\CFusionMX\db\slserver52\admin\swcla.exe I get this everytime I try to add a DNS through the CFMX Administrator. Any word on this one? -Gel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
say it is 100mb winzip wont compress it that much then u need to take in consideration the connection speeds. for example, i have i have a 512 cable line...download but only like 124 upload, so if lets say the zip was 75 mb it would take a bout 45 minutes to upload, ouch if u do it this way u will need to use a db that supports transaction and make sure u REALLY use them. also another thing i have noticed is that some ppl who dont know what the are doing with pix save them as progressive jpgs which really mess things up. or they save them in photoshop which also is a disaster.. if u do it the way u say u will also have to make some scripts to dynamically make the upload foldersand set read, & write permissions. i have no idea how to do that. you should maybe look at the MM site and the flash remoting tuts, maybe something there > I hear you, I do have my own server with anti-virus installed which I > hope would catch viruses. One thing I am thinking of is bandwidth. If > I upload over the lan it is a moot point, but over the wan 50 full jpegs > from a digital camera is significant amount of data (100mb maybe), which > can be compressed fairly efficiently via zip. Thus the net time to > upload would be less. Also this would get me around the apparent > multiple upload limitation. After the files are uploaded I am thinking > I just use cfexecute to invoke cli winzip to unzip them, update the db > with the information and invoke the imageprocessor to slice and dice the > pics. I too don't know crap so this might be a very bad idea, but it > seems to make sense (to me). > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 4:20 PM > To: CF-Talk > Subject: RE: Advise about how to upload multiple files > > > > sure but realistic? no > like i said, i maybe wrong cause i dont know crap but.. > > 1st thing to look at would be your server. If its yours then ok but if u > host then i wouldnt think many hostes would let u do that. Why? because > there would be no way to catch a virus or an unaccaptable script type > until its being run and then rut roh, houston we have a problem > > now i could see doing something like this in flash (same issue above > though) where you could upload the folder run the pic names into xml & > make a photo gallery but you still wont have captions > > i made this site 4 my gf (still working on...sometimes, lol) > www.4best-friends.com, my first real attempt at a flash site with > coldfusion back end. look at her photo album, there are over 350 pix and > it took her about 10 minutes to upload them all with the method i gave > earlier. i think thats fairly resonable time. > > > > > >> Actually, I thought this was a unique solution that I wouldn't have >> thought of. + points for creativity. It's not that bad an idea, > assuming >> your users know how to use winzip and you feel like learning >> java.util.zip. It may not be the best solution, but it's an > interesting >> idea at least. >> >> -nathan strutz >> >> >> >> >> > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Heartbeat with Flash?
Here's what I'd do. make a new movie. set the frame rate to 1 (1 frame per second). in frame 30, add a single action: loadVariables("yourUrlToCheck", 1); export the movie. put that in a page, and every 30 seconds, it'll hit whatever URL you specify. The output from the page should be a valid query string (not includeing the question mark). The empty string is valid. The help that comes with Flash is generally pretty good, I thought. Pretty mcuh all I use. cheers, banreyb _ From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:27 PM To: CF-Talk Subject: RE: Heartbeat with Flash? Barney, Thanks for the advice... Unfortunately I haven't really taken much of a look into Flash much or Flash Remoting. What would be the easiest way and could you point me to a couple resources? -Novak -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:16 PM To: CF-Talk Subject: RE: Heartbeat with Flash? It'd be a snap with flash, using either remoting or just a loadVariables call. I know there was a limitation with flash 5 where you couldn't make a movie smaller than 18x18 though. don't know if that's still in place with 6 (mx) and 7 (mx04). _ From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:12 PM To: CF-Talk Subject: Heartbeat with Flash? Hi All, Just tried to send this message out a few moments ago and it seemed to hang. My apologies in advance if it turns into a double post... I currently have an application that has a built in "heartbeat"... A 1x1 pixel iframe that refreshes itself every 30 seconds. This heartbeat updates the database and lets me know that a user is still online. Everything works great except for the fact that MSIE browsers make a "click" sound every time the refresh takes place. It's very annoying. I thought that perhaps I could create a 1x1 pixel flash movie to accomplish the same thing, only without the annoying click. Any ideas as to how difficult this would be to implement? Any other ideas are also more than welcome... -Novak _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
I hear you, I do have my own server with anti-virus installed which I hope would catch viruses. One thing I am thinking of is bandwidth. If I upload over the lan it is a moot point, but over the wan 50 full jpegs from a digital camera is significant amount of data (100mb maybe), which can be compressed fairly efficiently via zip. Thus the net time to upload would be less. Also this would get me around the apparent multiple upload limitation. After the files are uploaded I am thinking I just use cfexecute to invoke cli winzip to unzip them, update the db with the information and invoke the imageprocessor to slice and dice the pics. I too don't know crap so this might be a very bad idea, but it seems to make sense (to me). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:20 PM To: CF-Talk Subject: RE: Advise about how to upload multiple files sure but realistic? no like i said, i maybe wrong cause i dont know crap but.. 1st thing to look at would be your server. If its yours then ok but if u host then i wouldnt think many hostes would let u do that. Why? because there would be no way to catch a virus or an unaccaptable script type until its being run and then rut roh, houston we have a problem now i could see doing something like this in flash (same issue above though) where you could upload the folder run the pic names into xml & make a photo gallery but you still wont have captions i made this site 4 my gf (still working on...sometimes, lol) www.4best-friends.com, my first real attempt at a flash site with coldfusion back end. look at her photo album, there are over 350 pix and it took her about 10 minutes to upload them all with the method i gave earlier. i think thats fairly resonable time. > Actually, I thought this was a unique solution that I wouldn't have > thought of. + points for creativity. It's not that bad an idea, assuming > your users know how to use winzip and you feel like learning > java.util.zip. It may not be the best solution, but it's an interesting > idea at least. > > -nathan strutz > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Heartbeat with Flash?
Barney, Thanks for the advice... Unfortunately I haven't really taken much of a look into Flash much or Flash Remoting. What would be the easiest way and could you point me to a couple resources? -Novak -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:16 PM To: CF-Talk Subject: RE: Heartbeat with Flash? It'd be a snap with flash, using either remoting or just a loadVariables call. I know there was a limitation with flash 5 where you couldn't make a movie smaller than 18x18 though. don't know if that's still in place with 6 (mx) and 7 (mx04). _ From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:12 PM To: CF-Talk Subject: Heartbeat with Flash? Hi All, Just tried to send this message out a few moments ago and it seemed to hang. My apologies in advance if it turns into a double post... I currently have an application that has a built in "heartbeat"... A 1x1 pixel iframe that refreshes itself every 30 seconds. This heartbeat updates the database and lets me know that a user is still online. Everything works great except for the fact that MSIE browsers make a "click" sound every time the refresh takes place. It's very annoying. I thought that perhaps I could create a 1x1 pixel flash movie to accomplish the same thing, only without the annoying click. Any ideas as to how difficult this would be to implement? Any other ideas are also more than welcome... -Novak _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
sure but realistic? no like i said, i maybe wrong cause i dont know crap but.. 1st thing to look at would be your server. If its yours then ok but if u host then i wouldnt think many hostes would let u do that. Why? because there would be no way to catch a virus or an unaccaptable script type until its being run and then rut roh, houston we have a problem now i could see doing something like this in flash (same issue above though) where you could upload the folder run the pic names into xml & make a photo gallery but you still wont have captions i made this site 4 my gf (still working on...sometimes, lol) www.4best-friends.com, my first real attempt at a flash site with coldfusion back end. look at her photo album, there are over 350 pix and it took her about 10 minutes to upload them all with the method i gave earlier. i think thats fairly resonable time. > Actually, I thought this was a unique solution that I wouldn't have > thought of. + points for creativity. It's not that bad an idea, assuming > your users know how to use winzip and you feel like learning > java.util.zip. It may not be the best solution, but it's an interesting > idea at least. > > -nathan strutz > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Heartbeat with Flash?
It'd be a snap with flash, using either remoting or just a loadVariables call. I know there was a limitation with flash 5 where you couldn't make a movie smaller than 18x18 though. don't know if that's still in place with 6 (mx) and 7 (mx04). _ From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:12 PM To: CF-Talk Subject: Heartbeat with Flash? Hi All, Just tried to send this message out a few moments ago and it seemed to hang. My apologies in advance if it turns into a double post... I currently have an application that has a built in "heartbeat"... A 1x1 pixel iframe that refreshes itself every 30 seconds. This heartbeat updates the database and lets me know that a user is still online. Everything works great except for the fact that MSIE browsers make a "click" sound every time the refresh takes place. It's very annoying. I thought that perhaps I could create a 1x1 pixel flash movie to accomplish the same thing, only without the annoying click. Any ideas as to how difficult this would be to implement? Any other ideas are also more than welcome... -Novak _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Heartbeat with Flash?
Hi All, Just tried to send this message out a few moments ago and it seemed to hang. My apologies in advance if it turns into a double post... I currently have an application that has a built in "heartbeat"... A 1x1 pixel iframe that refreshes itself every 30 seconds. This heartbeat updates the database and lets me know that a user is still online. Everything works great except for the fact that MSIE browsers make a "click" sound every time the refresh takes place. It's very annoying. I thought that perhaps I could create a 1x1 pixel flash movie to accomplish the same thing, only without the annoying click. Any ideas as to how difficult this would be to implement? Any other ideas are also more than welcome... -Novak [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
Actually, I thought this was a unique solution that I wouldn't have thought of. + points for creativity. It's not that bad an idea, assuming your users know how to use winzip and you feel like learning java.util.zip. It may not be the best solution, but it's an interesting idea at least. -nathan strutz -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:34 PM To: CF-Talk Subject: RE: Advise about how to upload multiple files i think you are looking at trouble there, not to mention horrific upload times with ppl stopping and starting over, OUCHY!!! but you know what? I dont know jack squat, so dont listen to me > I was just thinking what do you think of forcing users to zip their > pictures into a single archive, then after the upload is complete unzip > the contents, do the database inserts, and post processing? Or would > this be a bad way to go? > > > > Thanks, > > > John > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 3:24 PM > To: CF-Talk > Subject: Re: Advise about how to upload multiple files > > > > you may wanna concider letting them upload say 5 at a time and having 5 > table fields for images in your db. > then just add 5 file fields to the form with names like pic1, pic2, > pic3, > pic4, pic5. then on the action page u need the upload file code for each > field but you really need to check each field to make sure it has > something in it first. you can do this with a simple if statement. then > to > you need to set the serverfile to a unique name cause u can only have 1 > to > do the db insert > > this line is VERY IMPORTANT > > because when u go to do the insert they each need unique names > > something like this (of course change to fit your needs) > > > > > > Sorry there has been an error, please try again > > > > > > > > Filefield="pic1" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > Filefield="pic2" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > Filefield="pic3" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > Filefield="pic4" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > Filefield="pic5" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > INSERT INTO listings (stock, company, model, price, type, year, > condition, newUsed, color, hitchStyle, construction, axels, > sleeps, hauls, floorLength, tires, emptyWeight, description, > overallEquiptment, stallAreaEquiptment, dressingRoom, > foldingRearTack, pic1, pic2, pic3, pic4, pic5) > VALUES ('#form.stock#', '#form.company#', '#form.model#', > '#form.price#', '#form.type#', '#form.year#', '#form.condition#', > '#form.newUsed#', '#form.color#', '#form.hitchStyle#', > '#form.construction#', '#form.axels#', '#form.sleeps#', > '#form.hauls#', '#form.floorLength#', '#form.tires#', > '#form.emptyWeight#', '#form.description#', > '#form.overallEquiptment#', > '#form.stallAreaEquiptment#', '#form.dressingRoom#', > '#form.foldingRearTack#', > '#pic1#', '#pic2#', '#pic3#', '#pic4#', '#pic5#') > > > > > > > > > > >> >> >> Message: http://www.houseoffusion.com/lists.cfm?link=i:4:144953 >> 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=3248.3032.4 > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
how much? > I bet you know more than me :-) > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 3:34 PM > To: CF-Talk > Subject: RE: Advise about how to upload multiple files > > > > i think you are looking at trouble there, not to mention horrific upload > times with ppl stopping and starting over, OUCHY!!! > > but you know what? > I dont know jack squat, so dont listen to me > > > >> I was just thinking what do you think of forcing users to zip their >> pictures into a single archive, then after the upload is complete > unzip >> the contents, do the database inserts, and post processing? Or would >> this be a bad way to go? >> >> >> >> Thanks, >> >> >> John >> >> >> >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> Sent: Monday, November 24, 2003 3:24 PM >> To: CF-Talk >> Subject: Re: Advise about how to upload multiple files >> >> >> >> you may wanna concider letting them upload say 5 at a time and having > 5 >> table fields for images in your db. >> then just add 5 file fields to the form with names like pic1, pic2, >> pic3, >> pic4, pic5. then on the action page u need the upload file code for > each >> field but you really need to check each field to make sure it has >> something in it first. you can do this with a simple if statement. > then >> to >> you need to set the serverfile to a unique name cause u can only have > 1 >> to >> do the db insert >> >> this line is VERY IMPORTANT >> >> because when u go to do the insert they each need unique names >> >> something like this (of course change to fit your needs) >> >> >> >> >> >> Sorry there has been an error, please try again >> >> >> >> >> >> >> >> Filefield="pic1" >> DESTINATION="C:\Websites\folder\site\uploads\" >> Nameconflict="makeunique" accept="image/*"> >> >> >> >> >> >> >> Filefield="pic2" >> DESTINATION="C:\Websites\folder\site\uploads\" >> Nameconflict="makeunique" accept="image/*"> >> >> >> >> >> >> >> Filefield="pic3" >> DESTINATION="C:\Websites\folder\site\uploads\" >> Nameconflict="makeunique" accept="image/*"> >> >> >> >> >> >> >> Filefield="pic4" >> DESTINATION="C:\Websites\folder\site\uploads\" >> Nameconflict="makeunique" accept="image/*"> >> >> >> >> >> >> >> Filefield="pic5" >> DESTINATION="C:\Websites\folder\site\uploads\" >> Nameconflict="makeunique" accept="image/*"> >> >> >> >> >> >> >> INSERT INTO listings (stock, company, model, price, type, year, >> condition, newUsed, color, hitchStyle, construction, axels, >> sleeps, hauls, floorLength, tires, emptyWeight, description, >> overallEquiptment, stallAreaEquiptment, dressingRoom, >> foldingRearTack, pic1, pic2, pic3, pic4, pic5) >> VALUES ('#form.stock#', '#form.company#', '#form.model#', >> '#form.price#', '#form.type#', '#form.year#', '#form.condition#', >> '#form.newUsed#', '#form.color#', '#form.hitchStyle#', >> '#form.construction#', '#form.axels#', '#form.sleeps#', >> '#form.hauls#', '#form.floorLength#', '#form.tires#', >> '#form.emptyWeight#', '#form.description#', >> '#form.overallEquiptment#', >> '#form.stallAreaEquiptment#', '#form.dressingRoom#', >> '#form.foldingRearTack#', >> '#pic1#', '#pic2#', '#pic3#', '#pic4#', '#pic5#') >> >> >> >> >> >> >> >> >> >> >>> >>> >>> Message: http://www.houseoffusion.com/lists.cfm?link=i:4:144953 >>> 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=3248.3032.4 >> >> >> >> >> > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
I bet you know more than me :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 3:34 PM To: CF-Talk Subject: RE: Advise about how to upload multiple files i think you are looking at trouble there, not to mention horrific upload times with ppl stopping and starting over, OUCHY!!! but you know what? I dont know jack squat, so dont listen to me > I was just thinking what do you think of forcing users to zip their > pictures into a single archive, then after the upload is complete unzip > the contents, do the database inserts, and post processing? Or would > this be a bad way to go? > > > > Thanks, > > > John > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 3:24 PM > To: CF-Talk > Subject: Re: Advise about how to upload multiple files > > > > you may wanna concider letting them upload say 5 at a time and having 5 > table fields for images in your db. > then just add 5 file fields to the form with names like pic1, pic2, > pic3, > pic4, pic5. then on the action page u need the upload file code for each > field but you really need to check each field to make sure it has > something in it first. you can do this with a simple if statement. then > to > you need to set the serverfile to a unique name cause u can only have 1 > to > do the db insert > > this line is VERY IMPORTANT > > because when u go to do the insert they each need unique names > > something like this (of course change to fit your needs) > > > > > > Sorry there has been an error, please try again > > > > > > > > Filefield="pic1" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > Filefield="pic2" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > Filefield="pic3" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > Filefield="pic4" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > Filefield="pic5" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > INSERT INTO listings (stock, company, model, price, type, year, > condition, newUsed, color, hitchStyle, construction, axels, > sleeps, hauls, floorLength, tires, emptyWeight, description, > overallEquiptment, stallAreaEquiptment, dressingRoom, > foldingRearTack, pic1, pic2, pic3, pic4, pic5) > VALUES ('#form.stock#', '#form.company#', '#form.model#', > '#form.price#', '#form.type#', '#form.year#', '#form.condition#', > '#form.newUsed#', '#form.color#', '#form.hitchStyle#', > '#form.construction#', '#form.axels#', '#form.sleeps#', > '#form.hauls#', '#form.floorLength#', '#form.tires#', > '#form.emptyWeight#', '#form.description#', > '#form.overallEquiptment#', > '#form.stallAreaEquiptment#', '#form.dressingRoom#', > '#form.foldingRearTack#', > '#pic1#', '#pic2#', '#pic3#', '#pic4#', '#pic5#') > > > > > > > > > > >> >> >> Message: http://www.houseoffusion.com/lists.cfm?link=i:4:144953 >> 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=3248.3032.4 > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
There are a number of Java multi-file uploaders you may want to look at, e.g. http://www.radinks.com/upload/index.php?gg2 (this is just the first I found). One advantage with one at a time is it may be easier to collect all the details about the image at the same time. You'd probably need this screen with editing images and details anyway, right? BTW I run a CF-based hiking site too: http://www.tramper.co.nz/ . Doesn't have individual user image galleries yet, but I'm planning on adding that soon. > forcing users to zip their pictures into a single archive, This might be nice as an option, but I think you should let users upload one at a time the old fashioned way as well. The biggest problem might be your page timing out. In my experience, CF doesn't deal with slow uploads all that well. -Original Message- From: John Munyan [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 November 2003 11:28 a.m. To: CF-Talk Subject: RE: Advise about how to upload multiple files I was just thinking what do you think of forcing users to zip their pictures into a single archive, then after the upload is complete unzip the contents, do the database inserts, and post processing? Or would this be a bad way to go? Thanks, John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 3:24 PM To: CF-Talk Subject: Re: Advise about how to upload multiple files you may wanna concider letting them upload say 5 at a time and having 5 table fields for images in your db. then just add 5 file fields to the form with names like pic1, pic2, pic3, pic4, pic5. then on the action page u need the upload file code for each field but you really need to check each field to make sure it has something in it first. you can do this with a simple if statement. then to you need to set the serverfile to a unique name cause u can only have 1 to do the db insert this line is VERY IMPORTANT because when u go to do the insert they each need unique names something like this (of course change to fit your needs) Sorry there has been an error, please try again Filefield="pic1" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic2" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic3" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic4" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic5" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> INSERT INTO listings (stock, company, model, price, type, year, condition, newUsed, color, hitchStyle, construction, axels, sleeps, hauls, floorLength, tires, emptyWeight, description, overallEquiptment, stallAreaEquiptment, dressingRoom, foldingRearTack, pic1, pic2, pic3, pic4, pic5) VALUES ('#form.stock#', '#form.company#', '#form.model#', '#form.price#', '#form.type#', '#form.year#', '#form.condition#', '#form.newUsed#', '#form.color#', '#form.hitchStyle#', '#form.construction#', '#form.axels#', '#form.sleeps#', '#form.hauls#', '#form.floorLength#', '#form.tires#', '#form.emptyWeight#', '#form.description#', '#form.overallEquiptment#', '#form.stallAreaEquiptment#', '#form.dressingRoom#', '#form.foldingRearTack#', '#pic1#', '#pic2#', '#pic3#', '#pic4#', '#pic5#') > > > Message: http://www.houseoffusion.com/lists.cfm?link=i:4:144953 > 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=3248.3032.4 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: Macromedia Technotes Notification
You can get the same information at the original http://www.fullasagoog.com/ -- along with a high fibre diet of other CF related news. As to the feed itself. Apparently it is manually put together at present and not for general circulation. I suspect this has more to do with reliability than with MM's desire to keep it from everyone :) -- geoff Master of the Goog http://www.fullasagoog.com/ David K wrote: > I'm looking for a way to keep up with the latest TechNotes and Bulletins > from Macromedia. In the Macromedia XML News Aggregator ( > http://www.markme.com/mxna/index.cfm ) I've seen an entry entitled > "ColdFusion TechNote Notification" but can't locate the feed for it. Can > anyone provide the URL? Also, If there's an email signup for email > notifications, I would appreciate the URL or signup instructions for that as > well. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
i think you are looking at trouble there, not to mention horrific upload times with ppl stopping and starting over, OUCHY!!! but you know what? I dont know jack squat, so dont listen to me > I was just thinking what do you think of forcing users to zip their > pictures into a single archive, then after the upload is complete unzip > the contents, do the database inserts, and post processing? Or would > this be a bad way to go? > > > > Thanks, > > > John > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 3:24 PM > To: CF-Talk > Subject: Re: Advise about how to upload multiple files > > > > you may wanna concider letting them upload say 5 at a time and having 5 > table fields for images in your db. > then just add 5 file fields to the form with names like pic1, pic2, > pic3, > pic4, pic5. then on the action page u need the upload file code for each > field but you really need to check each field to make sure it has > something in it first. you can do this with a simple if statement. then > to > you need to set the serverfile to a unique name cause u can only have 1 > to > do the db insert > > this line is VERY IMPORTANT > > because when u go to do the insert they each need unique names > > something like this (of course change to fit your needs) > > > > > > Sorry there has been an error, please try again > > > > > > > > Filefield="pic1" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > Filefield="pic2" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > Filefield="pic3" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > Filefield="pic4" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > Filefield="pic5" > DESTINATION="C:\Websites\folder\site\uploads\" > Nameconflict="makeunique" accept="image/*"> > > > > > > > INSERT INTO listings (stock, company, model, price, type, year, > condition, newUsed, color, hitchStyle, construction, axels, > sleeps, hauls, floorLength, tires, emptyWeight, description, > overallEquiptment, stallAreaEquiptment, dressingRoom, > foldingRearTack, pic1, pic2, pic3, pic4, pic5) > VALUES ('#form.stock#', '#form.company#', '#form.model#', > '#form.price#', '#form.type#', '#form.year#', '#form.condition#', > '#form.newUsed#', '#form.color#', '#form.hitchStyle#', > '#form.construction#', '#form.axels#', '#form.sleeps#', > '#form.hauls#', '#form.floorLength#', '#form.tires#', > '#form.emptyWeight#', '#form.description#', > '#form.overallEquiptment#', > '#form.stallAreaEquiptment#', '#form.dressingRoom#', > '#form.foldingRearTack#', > '#pic1#', '#pic2#', '#pic3#', '#pic4#', '#pic5#') > > > > > > > > > > >> >> >> Message: http://www.houseoffusion.com/lists.cfm?link=i:4:144953 >> 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=3248.3032.4 > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
Have a look at how they do it with this product. You can download and run it for free http://www.web-instan.com/web-instan/overview/2.html I've got a friend doing 10 weeks overseas (on a holiday - some people have all the luck :-) and I just loaded this onto our site so he can upload his digi cam pics to our server from where he is at up to 20 at a time. ** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 25 November 2003 9:54 AM To: CF-Talk Subject: Re: Advise about how to upload multiple files you may wanna concider letting them upload say 5 at a time and having 5 table fields for images in your db. then just add 5 file fields to the form with names like pic1, pic2, pic3, pic4, pic5. then on the action page u need the upload file code for each field but you really need to check each field to make sure it has something in it first. you can do this with a simple if statement. then to you need to set the serverfile to a unique name cause u can only have 1 to do the db insert this line is VERY IMPORTANT because when u go to do the insert they each need unique names something like this (of course change to fit your needs) Sorry there has been an error, please try again Filefield="pic1" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic2" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic3" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic4" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic5" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> INSERT INTO listings (stock, company, model, price, type, year, condition, newUsed, color, hitchStyle, construction, axels, sleeps, hauls, floorLength, tires, emptyWeight, description, overallEquiptment, stallAreaEquiptment, dressingRoom, foldingRearTack, pic1, pic2, pic3, pic4, pic5) VALUES ('#form.stock#', '#form.company#', '#form.model#', '#form.price#', '#form.type#', '#form.year#', '#form.condition#', '#form.newUsed#', '#form.color#', '#form.hitchStyle#', '#form.construction#', '#form.axels#', '#form.sleeps#', '#form.hauls#', '#form.floorLength#', '#form.tires#', '#form.emptyWeight#', '#form.description#', '#form.overallEquiptment#', '#form.stallAreaEquiptment#', '#form.dressingRoom#', '#form.foldingRearTack#', '#pic1#', '#pic2#', '#pic3#', '#pic4#', '#pic5#') > > > Message: http://www.houseoffusion.com/lists.cfm?link=i:4:144953 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
I was just thinking what do you think of forcing users to zip their pictures into a single archive, then after the upload is complete unzip the contents, do the database inserts, and post processing? Or would this be a bad way to go? Thanks, John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 3:24 PM To: CF-Talk Subject: Re: Advise about how to upload multiple files you may wanna concider letting them upload say 5 at a time and having 5 table fields for images in your db. then just add 5 file fields to the form with names like pic1, pic2, pic3, pic4, pic5. then on the action page u need the upload file code for each field but you really need to check each field to make sure it has something in it first. you can do this with a simple if statement. then to you need to set the serverfile to a unique name cause u can only have 1 to do the db insert this line is VERY IMPORTANT because when u go to do the insert they each need unique names something like this (of course change to fit your needs) Sorry there has been an error, please try again Filefield="pic1" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic2" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic3" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic4" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic5" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> INSERT INTO listings (stock, company, model, price, type, year, condition, newUsed, color, hitchStyle, construction, axels, sleeps, hauls, floorLength, tires, emptyWeight, description, overallEquiptment, stallAreaEquiptment, dressingRoom, foldingRearTack, pic1, pic2, pic3, pic4, pic5) VALUES ('#form.stock#', '#form.company#', '#form.model#', '#form.price#', '#form.type#', '#form.year#', '#form.condition#', '#form.newUsed#', '#form.color#', '#form.hitchStyle#', '#form.construction#', '#form.axels#', '#form.sleeps#', '#form.hauls#', '#form.floorLength#', '#form.tires#', '#form.emptyWeight#', '#form.description#', '#form.overallEquiptment#', '#form.stallAreaEquiptment#', '#form.dressingRoom#', '#form.foldingRearTack#', '#pic1#', '#pic2#', '#pic3#', '#pic4#', '#pic5#') > > > Message: http://www.houseoffusion.com/lists.cfm?link=i:4:144953 > 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=3248.3032.4 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Advise about how to upload multiple files
you may wanna concider letting them upload say 5 at a time and having 5 table fields for images in your db. then just add 5 file fields to the form with names like pic1, pic2, pic3, pic4, pic5. then on the action page u need the upload file code for each field but you really need to check each field to make sure it has something in it first. you can do this with a simple if statement. then to you need to set the serverfile to a unique name cause u can only have 1 to do the db insert this line is VERY IMPORTANT because when u go to do the insert they each need unique names something like this (of course change to fit your needs) Sorry there has been an error, please try again Filefield="pic1" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic2" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic3" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic4" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> Filefield="pic5" DESTINATION="C:\Websites\folder\site\uploads\" Nameconflict="makeunique" accept="image/*"> INSERT INTO listings (stock, company, model, price, type, year, condition, newUsed, color, hitchStyle, construction, axels, sleeps, hauls, floorLength, tires, emptyWeight, description, overallEquiptment, stallAreaEquiptment, dressingRoom, foldingRearTack, pic1, pic2, pic3, pic4, pic5) VALUES ('#form.stock#', '#form.company#', '#form.model#', '#form.price#', '#form.type#', '#form.year#', '#form.condition#', '#form.newUsed#', '#form.color#', '#form.hitchStyle#', '#form.construction#', '#form.axels#', '#form.sleeps#', '#form.hauls#', '#form.floorLength#', '#form.tires#', '#form.emptyWeight#', '#form.description#', '#form.overallEquiptment#', '#form.stallAreaEquiptment#', '#form.dressingRoom#', '#form.foldingRearTack#', '#pic1#', '#pic2#', '#pic3#', '#pic4#', '#pic5#') > > > Message: http://www.houseoffusion.com/lists.cfm?link=i:4:144953 > 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=3248.3032.4 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Advise about how to upload multiple files
If you're going to use HTML, you're stuck with a bunch of single file fields, and the need to go browse for each individual picture. Probably a better way to go it to upload the pics one at a time, and then just loop through the upload form/process page until the user says "that's enough". You might be able to find some kind of plugin that'll let you browse for more than one picture at a time and upload them, but I woudn't hold my breath. cheers, barneyb _ From: John Munyan [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 3:10 PM To: CF-Talk Subject: Advise about how to upload multiple files I am wanting to allow users to upload files to my website to construct their own image galleries of hikes they have done. I have a single upload example working. What has me confused is how to allow users to upload multiple files as a single operation. Is this possible? From the searching I have done today it looks like the idea is to create a myriad of form boxes and have users individually select individual images one per form box. Then upload them with a single submit. Given that users could upload from 1 to say 100 pictures (and I wouldn't know in advance how many) how would this best be solved. Is there some tucked away action that would allow users to attach an entire directory of images? That would work fine. Alternatively, what means might be available to use the ctrl or shift key type selection of images so users could just click 1 to x pictures and upload them that would really be the preferred method? As always any advise is very much appreciated! Sincerely, John _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Advise about how to upload multiple files
I am wanting to allow users to upload files to my website to construct their own image galleries of hikes they have done. I have a single upload example working. What has me confused is how to allow users to upload multiple files as a single operation. Is this possible? From the searching I have done today it looks like the idea is to create a myriad of form boxes and have users individually select individual images one per form box. Then upload them with a single submit. Given that users could upload from 1 to say 100 pictures (and I wouldn't know in advance how many) how would this best be solved. Is there some tucked away action that would allow users to attach an entire directory of images? That would work fine. Alternatively, what means might be available to use the ctrl or shift key type selection of images so users could just click 1 to x pictures and upload them that would really be the preferred method? As always any advise is very much appreciated! Sincerely, John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CVS
I think you mean "working directory" not "repository". We have a single staging working directory on our staging server, and one or more working directories on our dev server. We don't do per-developer directories, because of the setup headaches (dsns, dns, mappings, etc). The production server is updated via rsync from the staging server, so it can never contain anything that isn't on the staging server. rsync also has the benefit of being able to natively strip out any CVS garbage on the fly, so the code goes up to the production machines without any of the CVS directories and such. cheers, barneyb _ From: Daryl Walsh [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 1:39 PM To: CF-Talk Subject: CVS when setting up cvs, do people generally have one cvs repository per 'version', i.e., development server = 1 cvs version. staging server = another and the live web site = a third? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Auto-Populate a Word Document
Looking forward to them. -Original Message- From: Samuel R. Neff [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 5:56 PM To: CF-Talk Subject: RE: Auto-Populate a Word Document But there are lots of other ways to do the same thing. I just gave a preso at MAX going over 7 different ways to do this. Breezo with examples will be posted shortly. Best regards, Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CVS
CVS is only used for development. Staging and production should have their own copies of the real files, not a CVS repo. You can use CVS to export from a CVS repo to staging or production. To keep track of the individual versions, i.e., what's in development and what's in production, take a look at branching. HTH, Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- > -Original Message- > From: Daryl Walsh [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 4:39 PM > To: CF-Talk > Subject: CVS > > when setting up cvs, do people generally have one cvs > repository per 'version', i.e., development server = 1 cvs version. > staging server = another and the live web site = a third? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: good place to find contractors?
-Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 3:52 PM To: CF-Talk Subject: Re: good place to find contractors? Christry the CF-Jobs list if you haven't already ;-) .of course I will throw my company's hat into the ring. Full-time CF since 1998 (version 3.1) and we are in Canada...so the exchange rate will save some development cost. Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: chris petersen To: CF-Talk Sent: Monday, November 24, 2003 2:34 PM Subject: SOT: good place to find contractors? Anyone know a good place to look for CF contractors? Also, if anyone on list is seeking additional contract opportunities, please feel free to email me off list. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Auto-Populate a Word Document
But there are lots of other ways to do the same thing. I just gave a preso at MAX going over 7 different ways to do this. Breezo with examples will be posted shortly. Best regards, Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- > -Original Message- > From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 4:46 PM > To: CF-Talk > Subject: RE: Auto-Populate a Word Document > > Sam most of us know this. I in fact detest using office for anything. > However clients want certain things and when they have seen > it done on other sites, and management insists on giving them > this ability it is our obligations as paid employees to do > what is asked. > > -Original Message- > From: Samuel R. Neff [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 4:39 PM > To: CF-Talk > Subject: RE: Auto-Populate a Word Document > > Even MS tells you to never do this. > > "Microsoft does not currently recommend, and does not > support, Automation of Microsoft Office applications from any > unattended, non-interactive client application or component > (including ASP, DCOM, and NT Services), because Office may > exhibit unstable behavior and/or deadlock when run in this > environment." > > http://support.microsoft.com/default.aspx?scid=kb;EN-US;257757 > > Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: good place to find contractors?
Christry the CF-Jobs list if you haven't already ;-) .of course I will throw my company's hat into the ring. Full-time CF since 1998 (version 3.1) and we are in Canada...so the exchange rate will save some development cost. Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: chris petersen To: CF-Talk Sent: Monday, November 24, 2003 2:34 PM Subject: SOT: good place to find contractors? Anyone know a good place to look for CF contractors? Also, if anyone on list is seeking additional contract opportunities, please feel free to email me off list. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CVS
when setting up cvs, do people generally have one cvs repository per 'version', i.e., development server = 1 cvs version. staging server = another and the live web site = a third? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Jar files not being read
Ok, get this, if I unzip the JAR to the WEB-INF/classes directory does NOT work. Unzip the JAR into a random directory, add that directory to the CF class path, and it'll work. Bizarre. Rather annoyed to have to litter my filesystem with random class files, but at least it works. cheers, barneyb _ From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 1:39 PM To: CF-Talk Subject: RE: Jar files not being read Yeah, done that about a million times. Actually got lazy enough to write myself an alias so I didn't have to type the whole command out every time. ; ) _ From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 1:25 PM To: CF-Talk Subject: RE: Jar files not being read Don't you have to restart the service? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: good place to find contractors?
Anyone know a good place to look for CF contractors? Also, if anyone on list is seeking additional contract opportunities, please feel free to email me off list. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DW extension keyboard shortcuts
That would explain it. much thanks. cheers, barneyb _ From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 2:18 PM To: CF-Talk Subject: Re: DW extension keyboard shortcuts > That's what I assumed would happen. It happily displays on the Commands > menu, but no dice in the keyboard shortcut screen. That's because the entry under the Commands menu are dinamycally generated by DW. You need to hardcode the entry inside menus.xml in order to have it show inside the shortcut editor's GUI > I also tried manually > adding it to the menu.xml file, and that didn't work either. Are you sure you are editing the right file? Please check its path under a multiuser operating system: http://www.macromedia.com/support/dreamweaver/ts/documents/multiuser.htm Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DW extension keyboard shortcuts
> That's what I assumed would happen. It happily displays on the Commands > menu, but no dice in the keyboard shortcut screen. That's because the entry under the Commands menu are dinamycally generated by DW. You need to hardcode the entry inside menus.xml in order to have it show inside the shortcut editor's GUI > I also tried manually > adding it to the menu.xml file, and that didn't work either. Are you sure you are editing the right file? Please check its path under a multiuser operating system: http://www.macromedia.com/support/dreamweaver/ts/documents/multiuser.htm Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:ListFind() weirdness
>According to my help, the syntax for Listfind is > >ListFind(List,string,delemiters) (banging head on keyboard, wall, and anything else hard) I am such an idiot. You're completely right. What a rookie mistake to make, and I've been at this game WAY to long to be making rookie mistakes. Doh! Thanks for the help, Seth [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ListFind() weirdness
Yea yea, I was wrong about that part. Sorry folks. I blame it on the snow in Salt Lake... :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ListFind() weirdness
I would think it should pass back 1 since it will treat the string as a 1 element string regardless of what delimiter you specify if it can't find that delimiter. Raymond Camden wrote: > ListFind doesn't accept a 'index' argument. The 3rd argument is the > delimiter, which defualts to a comma. Now, the second example you used, > where you passed 1 as the 3rd arg, should return 0 since 1 doesn't > exist in > the list. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: preventing back button of browser
I wrote that script a while (2 years something) ago with my friend Joseph Thompson (also from the list). http://cfhub.com/contributions/backbutton/ you can probably improve the code (to make it less), anyway, it should be fine as it is. completely server side logic, there is also a live demo you can check. - Original Message - From: Ketan Patel To: CF-Talk Sent: Monday, November 24, 2003 11:31 PM Subject: preventing back button of browser hi all, does anybody know a good way of preventing back button of browser. thanks, ketan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Auto-Populate a Word Document
Sam most of us know this. I in fact detest using office for anything. However clients want certain things and when they have seen it done on other sites, and management insists on giving them this ability it is our obligations as paid employees to do what is asked. -Original Message- From: Samuel R. Neff [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:39 PM To: CF-Talk Subject: RE: Auto-Populate a Word Document Even MS tells you to never do this. "Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when run in this environment." http://support.microsoft.com/default.aspx?scid=kb;EN-US;257757 Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: preventing back button of browser
Technically there really isn't anyway to prevent a back button from being clicked... BUT... you can use _javascript_'s location.replace() function to overwrite the current page location in your browser. Essentially what you'll end up with is a page that has no history so the back button won't be available. -Novak -Original Message- From: Ketan Patel [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 1:31 PM To: CF-Talk Subject: preventing back button of browser hi all, does anybody know a good way of preventing back button of browser. thanks, ketan _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: preventing back button of browser
Ketan, There doesn't seem to be a foolproof way of preventing the back button. Your best bet, IMHO, is to handle it with server side logic. Marlon Ketan Patel wrote: > hi all, > > does anybody know a good way of preventing back button of browser. > > thanks, > ketan > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ListFind() weirdness
ListFind(list, value [, delimiters ]) The third argument of ListFind is not starting position but rather it is the lists delimiter. So your "1" and "2" delimited list does have exaclty 1 list item (as there are no 1's or 2's in your number). - Original Message - From: Seth Johnson To: CF-Talk Sent: Monday, November 24, 2003 4:14 PM Subject: ListFind() weirdness OK, so I'm having some weird behavior with ListFind() on CFMX and CF 5. Here's an example. I create a COMMA DELIMITED list of values, each value actually consists of 3 groups of numbers separated by an underscore. ListFind() is not returning the proper result when this list contains a single value. #ListFind(lstTemp, "4483_035738_8647")# #ListFind(lstTemp, "4483_035738_8647", 1)# #ListFind(lstTemp, "4483_035738_8647", 2)# All of the ListFind()s are returning a value of "1", even though they should be returning 0. In this case, the list and the value I'm looking for are one and the same, so a straight ListFInd() should return an index of 1. However, if I call ListFind() with a starting position of 1, shouldn't it return 0? It works fine if the list contains more than one value, but not if it has just one value. Any help would be VERY much appreciated. Seth Petry-Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Auto-Populate a Word Document
Even MS tells you to never do this. "Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when run in this environment." http://support.microsoft.com/default.aspx?scid=kb;EN-US;257757 Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 4:05 PM > To: CF-Talk > Subject: Re: Auto-Populate a Word Document > > Try this EasyCFM tutorial: > > http://tutorial13.easycfm.com/ > > Peter Tilbrook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ListFind() weirdness
1 is the delimiter. It should return 1 as it correctly does. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:27 PM To: CF-Talk Subject: RE: ListFind() weirdness ListFind doesn't accept a 'index' argument. The 3rd argument is the delimiter, which defualts to a comma. Now, the second example you used, where you passed 1 as the 3rd arg, should return 0 since 1 doesn't exist in the list. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Jar files not being read
Yeah, done that about a million times. Actually got lazy enough to write myself an alias so I didn't have to type the whole command out every time. ; ) _ From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 1:25 PM To: CF-Talk Subject: RE: Jar files not being read Don't you have to restart the service? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ListFind() weirdness
ListFind doesn't accept a 'index' argument. The 3rd argument is the delimiter, which defualts to a comma. Now, the second example you used, where you passed 1 as the 3rd arg, should return 0 since 1 doesn't exist in the list. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ListFind() weirdness
I suppose you could also do a find for the delimeter and if it is not found assume it is not a list as well. S -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:21 PM To: CF-Talk Subject: RE: ListFind() weirdness Wouldn't a list, by nature of it being a list, need more than 1 value to be called a list? If you know the format could you do some ugly code like If (Len(myList) LTE 16> else S -Original Message- From: Seth Johnson [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:14 PM To: CF-Talk Subject: ListFind() weirdness OK, so I'm having some weird behavior with ListFind() on CFMX and CF 5. Here's an example. I create a COMMA DELIMITED list of values, each value actually consists of 3 groups of numbers separated by an underscore. ListFind() is not returning the proper result when this list contains a single value. #ListFind(lstTemp, "4483_035738_8647")# #ListFind(lstTemp, "4483_035738_8647", 1)# #ListFind(lstTemp, "4483_035738_8647", 2)# All of the ListFind()s are returning a value of "1", even though they should be returning 0. In this case, the list and the value I'm looking for are one and the same, so a straight ListFInd() should return an index of 1. However, if I call ListFind() with a starting position of 1, shouldn't it return 0? It works fine if the list contains more than one value, but not if it has just one value. Any help would be VERY much appreciated. Seth Petry-Johnson _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
preventing back button of browser
hi all, does anybody know a good way of preventing back button of browser. thanks, ketan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Jar files not being read
Don't you have to restart the service? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ListFind() weirdness
There is nothing wrong with this. ListFind(list, value [, delimiters ]) The first instance. No delimiter is specified so comma would be default. Since your value is equal to the search string returns index 1. The second instance your delimiter is 1, since your value matches your search string and no 1 is in your value it returns 1. The third instance is the same as above. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ListFind() weirdness
According to my help, the syntax for Listfind is ListFind(List,string,delemiters) I don't think that you can specify start position. Marlon Seth Johnson wrote: > OK, so I'm having some weird behavior with ListFind() on CFMX and CF 5. > > > Here's an example. I create a COMMA DELIMITED list of values, each value > actually consists of 3 groups of numbers separated by an underscore. > ListFind() is not returning the proper result when this list contains a > single value. > > > > > #ListFind(lstTemp, "4483_035738_8647")# > #ListFind(lstTemp, "4483_035738_8647", 1)# > #ListFind(lstTemp, "4483_035738_8647", 2)# > > > > All of the ListFind()s are returning a value of "1", even though they > should > be returning 0. > > > In this case, the list and the value I'm looking for are one and the same, > so a straight ListFInd() should return an index of 1. However, if I call > ListFind() with a starting position of 1, shouldn't it return 0? It works > fine if the list contains more than one value, but not if it has just one > value. > > > Any help would be VERY much appreciated. > > > Seth Petry-Johnson > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE:Unable to Update the CFMX ODBC Server ( Was Error with Web Connector after installing CFMX 6.1)
I fixed this by using 127.0.0.1 . I've now run into another problem: Unable to update the ColdFusion MX ODBC Server. Timeout period expired without completion of F:\CFusionMX\db\slserver52\admin\swcla.exe I get this everytime I try to add a DNS through the CFMX Administrator. Any word on this one? -Gel -Original Message- From: Mahmut Basaran [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 5:17 PM To: CF-Talk Subject: Re: Error with Web Connector after installing CFMX 6.1 I had a similar problem a while ago, although it says "localhost" it's not really using localhost (it's using the static ip of your box). so, if you have any firewalls, ipsec rules etc.. disable them and run the connector executable again. You can also check the log files to dig more info. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ListFind() weirdness
Wouldn't a list, by nature of it being a list, need more than 1 value to be called a list? If you know the format could you do some ugly code like If (Len(myList) LTE 16> else S -Original Message- From: Seth Johnson [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:14 PM To: CF-Talk Subject: ListFind() weirdness OK, so I'm having some weird behavior with ListFind() on CFMX and CF 5. Here's an example. I create a COMMA DELIMITED list of values, each value actually consists of 3 groups of numbers separated by an underscore. ListFind() is not returning the proper result when this list contains a single value. #ListFind(lstTemp, "4483_035738_8647")# #ListFind(lstTemp, "4483_035738_8647", 1)# #ListFind(lstTemp, "4483_035738_8647", 2)# All of the ListFind()s are returning a value of "1", even though they should be returning 0. In this case, the list and the value I'm looking for are one and the same, so a straight ListFInd() should return an index of 1. However, if I call ListFind() with a starting position of 1, shouldn't it return 0? It works fine if the list contains more than one value, but not if it has just one value. Any help would be VERY much appreciated. Seth Petry-Johnson _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: New Lists and other items
It seems that autodiscovery requires a link format other than what I have. I'll look into adding it in the next revision. Till then, you can add this link directly: http://www.houseoffusion.com/cf_lists/RSS.cfm/forumid=4 The forumid reflects the specific forum so 4 is CF-Talk, 5 is CF-Community, etc. All lists automatically have an RSS feed. > Do the RSS feeds support "autodiscovery"? I use FeedDemon 1.0 RC4 and it > didn't seem to like it. > > Peter Tilbrook > Transitional Services - Enterprise eSolutions > Centrelink (http://www.centrelink.gov.au) > 2 Faulding Street > Symonston ACT 2609 > > Tel: (02) 62115927 > > > > > > Important: This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege. If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament. If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Jar files not being read
I just added a JAR to my app's WEB-INF/lib directory and it's behaving very strangely. I can happily instantiate and use the classes from my CF code. I can happily instantiate and use the classes from a custom Java class that is compiled and run with the JAR on the classpath. However, running that custom Java class from CF causes NoClassDefFoundErrors to be thrown, referencing the classes in the JAR. There are several other JARs in the same directory, and I've had no problems at all using their classes directly from CF and/or through custom Java classes from CF. I checked permissions and ownership, and all were as they should be. I also tried unpackaging the JAR and rebuilding it, and that didn't help either. Anyone had anything similar happen to them? Just about gone nuts with this. I'm running 6.1 Standard on RH Linux with Apache 2. TIA, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x12 fax : 360.647.5351 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Error with Web Connector after installing CFMX 6.1
I had a similar problem a while ago, although it says "localhost" it's not really using localhost (it's using the static ip of your box). so, if you have any firewalls, ipsec rules etc.. disable them and run the connector executable again. You can also check the log files to dig more info. - Original Message - From: Angel Stewart To: CF-Talk Sent: Monday, November 24, 2003 11:00 PM Subject: Error with Web Connector after installing CFMX 6.1 I got some errors with CFMX, where it had totally stopped processing CFM pages. All I would get when I visited a CFM page was a blank screen. I've just uninstalled, rebooted..reinstalled and rebooted CFMX. After the reinstall I got a message saying that the web connector installation had failed, and I would have to try manually. I just ran the Web connector wizard, and I get this error message: The connection to the remote JNDI server on host localhost port 2901 has failed (as have all backup hosts listed if any) Please verify that the server is running and the NamingService is available. Any idea what the problem could be and how to fix this? This is on my development PC... -Gel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ListFind() weirdness
OK, so I'm having some weird behavior with ListFind() on CFMX and CF 5. Here's an example. I create a COMMA DELIMITED list of values, each value actually consists of 3 groups of numbers separated by an underscore. ListFind() is not returning the proper result when this list contains a single value. #ListFind(lstTemp, "4483_035738_8647")# #ListFind(lstTemp, "4483_035738_8647", 1)# #ListFind(lstTemp, "4483_035738_8647", 2)# All of the ListFind()s are returning a value of "1", even though they should be returning 0. In this case, the list and the value I'm looking for are one and the same, so a straight ListFInd() should return an index of 1. However, if I call ListFind() with a starting position of 1, shouldn't it return 0? It works fine if the list contains more than one value, but not if it has just one value. Any help would be VERY much appreciated. Seth Petry-Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: New Lists and other items
Do the RSS feeds support "autodiscovery"? I use FeedDemon 1.0 RC4 and it didn't seem to like it. Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 Important: This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege. If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament. If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Auto-Populate a Word Document
Try this EasyCFM tutorial: http://tutorial13.easycfm.com/ Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 Important: This e-mail is intended for the use of the addressee and may contain information that is confidential, commercially valuable or subject to legal or parliamentary privilege. If you are not the intended recipient you are notified that any review, re-transmission, disclosure, use or dissemination of this communication is strictly prohibited by several Commonwealth Acts of Parliament. If you have received this communication in error please notify the sender immediately and delete all copies of this transmission together with any attachments. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Error with Web Connector after installing CFMX 6.1
I got some errors with CFMX, where it had totally stopped processing CFM pages. All I would get when I visited a CFM page was a blank screen. I've just uninstalled, rebooted..reinstalled and rebooted CFMX. After the reinstall I got a message saying that the web connector installation had failed, and I would have to try manually. I just ran the Web connector wizard, and I get this error message: The connection to the remote JNDI server on host localhost port 2901 has failed (as have all backup hosts listed if any) Please verify that the server is running and the NamingService is available. Any idea what the problem could be and how to fix this? This is on my development PC... -Gel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
> Also, you can't run an Access macro on the server without automation which is a big no-no. I don't want to get into the politics of having Access installed on the machine, that's not my concern, it's the users concern. All I want to do get the reasons why people go through so much time and effort to do a DSN less connection in _CFML_. > DTS implies MSSQL and if you're using a DTS to import from an uploaded Excel or Access database, then somehow you must be passing the path to the Excel or Access file to the DTS package. Yep, I was asked for an example through code, but I don't see a need to do it through code. It can be done with the database engines. You'll probably counter and say that in order to run the DTS your doing it through code anyways. My answer would be yes but your calling a stored procedure. Or firing a Macro. > This is really the same as dsn-less connection, just through DTS and not through CF Yep [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DW extension keyboard shortcuts
That's what I assumed would happen. It happily displays on the Commands menu, but no dice in the keyboard shortcut screen. I also tried manually adding it to the menu.xml file, and that didn't work either. barneyb _ From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 12:33 PM To: CF-Talk Subject: Re: DW extension keyboard shortcuts You can assign keyboard shortcuts to menu entries. So, first create the menu entry for your command, then assign a shortcut to it Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ - Original Message - From: Barney Boisvert Newsgroups: cf-talk Sent: Monday, November 24, 2003 9:01 PM Subject: OT: DW extension keyboard shortcuts I beat my head against this one all weekend. In DWMX (not 04), is it possible to assign a keyboard shortcut to a command extension? I couldn't find anything about it either way in the helps. Cheers, barneyb _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
Bryan, DTS implies MSSQL and if you're using a DTS to import from an uploaded Excel or Access database, then somehow you must be passing the path to the Excel or Access file to the DTS package. This is really the same as dsn-less connection, just through DTS and not through CF. Also, you can't run an Access macro on the server without automation which is a big no-no. Best regards, Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DW extension keyboard shortcuts
You can assign keyboard shortcuts to menu entries. So, first create the menu entry for your command, then assign a shortcut to it Massimo Foti Certified Dreamweaver MX Developer Certified Advanced ColdFusion MX Developer http://www.massimocorner.com/ - Original Message - From: Barney Boisvert Newsgroups: cf-talk Sent: Monday, November 24, 2003 9:01 PM Subject: OT: DW extension keyboard shortcuts I beat my head against this one all weekend. In DWMX (not 04), is it possible to assign a keyboard shortcut to a command extension? I couldn't find anything about it either way in the helps. Cheers, barneyb [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DW Stop refeshing site
It's on the Local Info tab when you go into Manage Sites, there's a checkbox, CACHE that will need to be unticked, Jb. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 24 November 2003 20:03 To: CF-Talk Subject: OT: DW Stop refeshing site how can I make it so that dw doesn't have to REFRESH MY SITES when I make changes to files etc? thanks. tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Macromedia Technotes Notification
Fusion Authority keeps up with the tech notes. While it's not immediate like the XML feed is, it does cover them and more. We've got an issue coming out in an hour or so that brings the latest technotes out. > I'm looking for a way to keep up with the latest TechNotes and Bulletins > from Macromedia. In the Macromedia XML News Aggregator ( > http://www.markme.com/mxna/index.cfm ) I've seen an entry entitled > "ColdFusion TechNote Notification" but can't locate the feed for it. Can > anyone provide the URL? Also, If there's an email signup for email > notifications, I would appreciate the URL or signup instructions for that as > well. > > TIA > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: DW Stop refeshing site
how can I make it so that dw doesn't have to REFRESH MY SITES when I make changes to files etc? thanks. tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: DW extension keyboard shortcuts
I beat my head against this one all weekend. In DWMX (not 04), is it possible to assign a keyboard shortcut to a command extension? I couldn't find anything about it either way in the helps. Cheers, barneyb --- Barney Boisvert [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Clearing Trusted Cache in CF 5
Trusted cache will prevent ColdFusion (5 or MX) from checking the disk for the file timestamp. This can have a medium to large-ish performance impact. Huge if your templates are mounted across the network on a file server. You can switch this setting on/off without restarting the server, so you can update a template, flip the switch off, request that page to clear the cache, and then flip the switch on again. All without restarting. This is by design. If you have a large number of pages that you are updating, a restart would probably be better, or (as Jon Block mentioned) a regression script which hits every page in your app (using cfhttp). Macromedia recommends that all performance sensitive sites turn trusted cache on. -- Tom Jordahl Macromedia Server Development -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 9:27 AM To: CF-Talk Subject: Re: Clearing Trusted Cache in CF 5 Only if your site has very rare changes. With trusted cache off, a new change will have a minor delay the first time it is invoked while it compiles, and from then on, it will load just as well as if TC was turned on. I was searching for the Link which discusses this extensively, but am running against a deadline, and don't have the time to look it up. == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP == If you are not satisfied with my service, my job isn't done! - Original Message - From: "Lofback, Chris" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, November 21, 2003 8:22 AM Subject: RE: Clearing Trusted Cache in CF 5 | Really? I thought this was a common recommendation for performance tweaking... | | Chris Lofback | Web Administrator | Ceridian Benefits Services | 3201 34th Street S. | St. Petersburg, FL 33711 | 727-395-8881 | | | -Original Message- | From: Doug White [mailto:[EMAIL PROTECTED] | Sent: Friday, November 21, 2003 9:14 AM | To: CF-Talk | Subject: Re: Clearing Trusted Cache in CF 5 | | | On a production server with frequent changes, it is best that you turn off | trusted cache and leave it off. | | == | Stop spam on your domain, use our gateway! | For hosting solutions http://www.clickdoug.com | Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and PHP | == | If you are not satisfied with my service, my job isn't done! | | - Original Message - | From: "Lofback, Chris" <[EMAIL PROTECTED]> | To: "CF-Talk" <[EMAIL PROTECTED]> | Sent: Friday, November 21, 2003 7:55 AM | Subject: Clearing Trusted Cache in CF 5 | | | Does disabling and then reenabling the Trusted Cache option in CF 5 clear the | template cache? If not, how can I make CF refresh the entire cache? Does it | require a restart? | | | | Thanks, | | Chris | | | | | _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
problems with cfhttp and USPS
Hey, First off, thanks for your help. I am having an issue with cfhttp talking to the USPS intl shipping price server. 9 times out of 10 the results come back with an error. I've heard that there are cfx http tags out there- anyone used one that works on Solaris? Or has anyone seen this problem before and fixed it? Here is the error- http://www.bikesmart.com/vt/test_usps_raw.cfm Server Product ColdFusion Server Version : 5, 0, 0, 0 Edition : Professional Operating System : UNIX OS Version : 5.9, SunOS OS Build Number : Generic_112233-04 Thanks! _ walker fenton [EMAIL PROTECTED] 303.722.5473 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF and ASP
nice thinking see no reason why it shouldn't work as it is two separate page calls.. I like it Steven :-) -Original Message- From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: 24 November 2003 19:41 To: CF-Talk Subject: RE: CF and ASP What if you used an IFRAME. That may work. Dunno though as I have never tried it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 2:39 PM To: CF-Talk Subject: RE: CF and ASP Doubt it the .cfm file will tell the webserver to use the Cold Fusion app server... if it has an asp extension it would then run through the asp.dll I know this can be changed but I doubt that you would be able to get both languages going at the same time... -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 24 November 2003 17:38 To: CF-Talk Subject: RE: CF and ASP Can I have some ASP code in my test.cfm file? Its a breadcrumb writting in ASP. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF and ASP
What if you used an IFRAME. That may work. Dunno though as I have never tried it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 2:39 PM To: CF-Talk Subject: RE: CF and ASP Doubt it the .cfm file will tell the webserver to use the Cold Fusion app server... if it has an asp extension it would then run through the asp.dll I know this can be changed but I doubt that you would be able to get both languages going at the same time... -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 24 November 2003 17:38 To: CF-Talk Subject: RE: CF and ASP Can I have some ASP code in my test.cfm file? Its a breadcrumb writting in ASP. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: On the fly DSN creation, why?
I would greatly appreciate if you could post an example on how to do this. I've asked several times without success. Thanks much! - Original Message - From: Bryan F. Hogan To: CF-Talk Sent: Monday, November 24, 2003 2:03 PM Subject: RE: On the fly DSN creation, why? > Sure, let's say you want to let a user upload an Access database and import it an existing data source. If the database you want to import data is in SQL you can use a DTS. If it is in Access you can use a Macro. > I am currently stuck figuring out how to do the reverse - extract data to a stand alone dynamically generated Access database. Same as above. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF and ASP
Doubt it the .cfm file will tell the webserver to use the Cold Fusion app server... if it has an asp extension it would then run through the asp.dll I know this can be changed but I doubt that you would be able to get both languages going at the same time... -Original Message- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 24 November 2003 17:38 To: CF-Talk Subject: RE: CF and ASP Can I have some ASP code in my test.cfm file? Its a breadcrumb writting in ASP. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Macromedia Technotes Notification
I'm looking for a way to keep up with the latest TechNotes and Bulletins from Macromedia. In the Macromedia XML News Aggregator ( http://www.markme.com/mxna/index.cfm ) I've seen an entry entitled "ColdFusion TechNote Notification" but can't locate the feed for it. Can anyone provide the URL? Also, If there's an email signup for email notifications, I would appreciate the URL or signup instructions for that as well. TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Recursion and Breadcrumbs
Here's the code to the Custom tag I wrote to do this exact thing CategoryID is a required variable. SELECT * FROM tblCategory WHERE CategoryID = #varCategoryID# #getParent.CategoryName#"> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
> Sure, let's say you want to let a user upload an Access database and import it an existing data source. If the database you want to import data is in SQL you can use a DTS. If it is in Access you can use a Macro. > I am currently stuck figuring out how to do the reverse - extract data to a stand alone dynamically generated Access database. Same as above. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Recursion and Breadcrumbs
This is what I generally use. Let me know if you need clarification. username="#request.dsn.user#" password="#request.dsn.pass#"> SELECT catId, parentCatId, catName FROM item_categories WHERE parentId = #arguments.myCatId# ORDER BY category )> -Original Message- From: Jake McKee [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 1:51 PM To: CF-Talk Subject: Recursion and Breadcrumbs After searching high and low, I've found quite a few discussions about using recursion to create breadcrumbs, and other nested "categorical" info. It seems to be a pretty common question, and I would expect that there is a common solution out there, but I can't seem to find one. I'm trying to display: Home > Cat > Sub Cat > Sub Sub Cat > .. Etc. My DB table looks like : Cat ID CatName ParentCatID - - - 1 CDs 0 2 Good CDs 1 3 Bad CDs 1 4 U22 5 Nsync 3 This would display: Home > CDs > Good CDs > U2 Anyone have a straightforward code snippet for this? Thanks! Jake -- My Blog - www.countersinkdg.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
I've been thinking about this today and so-far I can't figure out why the need for DSN-less connections. Could a Macro in your Access database not import data from an uploaded Excel Spreadsheet -Original Message- From: Samuel R. Neff [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 12:14 PM To: CF-Talk Subject: RE: On the fly DSN creation, why? In the example I posted, it was to work with an uploaded Excel spreadsheet. In that case, you don't want a real DSN to it but just a dynamic connection. Besides, someone else asked about the HOW, not just WHY (sorry if I'm encouraging the repurposement of your thread). Sam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Recursion and Breadcrumbs
Hey, I wrote a custom tag to do exactly that. Email me off list at [EMAIL PROTECTED] and I'll get you a copy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
Hi I'm confused on this one. Did you create a DTS to import from the uploaded spreadsheet? If so where does the DSN-less connection come into play? -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 12:14 PM To: CF-Talk Subject: RE: On the fly DSN creation, why? we wanted to do it so that users were able to upload an excel spreadsheet, which could then be manipulated by other people over a period of time. At the time of writing there was no way to do it in MX that appeared to work. So we have a bank of datasources setup in CF which is then monitored by other code and matched up with ODBC datasources via CFRegistry Much much easier (and secure) than installing MS Office on the server (which has the added problem of being really locked down) and trying to use COM [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: Breadcrumb in CF
How can I do something similar in CF using the below ASP code? <% Function BreadCrumbs() Dim lstrPathAry Dim llngMaxIndex Dim lstrPath Dim lstrHTML lstrPathAry = Split(Request.ServerVariables("PATH_INFO"), "/") llngMaxIndex = UBound(lstrPathAry) - 1 lstrHTML = "You are here: " lstrPath = "/" lstrHTML = lstrHTML & "Home " For llngIndex = 1 To llngMaxIndex lstrPath = lstrPath & Server.URLPathEncode(lstrPathAry(llngIndex)) & "/" lstrHTML = lstrHTML & "> " & Server.HTMLEncode(lstrPathAry(llngIndex)) & "" Next BreadCrumbs = lstrHTML End Function %> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Recursion and Breadcrumbs
After searching high and low, I've found quite a few discussions about using recursion to create breadcrumbs, and other nested "categorical" info. It seems to be a pretty common question, and I would expect that there is a common solution out there, but I can't seem to find one. I'm trying to display: Home > Cat > Sub Cat > Sub Sub Cat > .. Etc. My DB table looks like : Cat ID CatName ParentCatID - - - 1 CDs 0 2 Good CDs 1 3 Bad CDs 1 4 U22 5 Nsync 3 This would display: Home > CDs > Good CDs > U2 Anyone have a straightforward code snippet for this? Thanks! Jake -- My Blog - www.countersinkdg.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Ordering a QofQ
This probably has to do with the data type of the field that you're working with. For instance, if price is a text field because you're storing $123.43 instead of a numeric field and just storing 123.43 it would sort alphabetically instead of numerically. You could probably convert the field value to a numeric value in your first query using CAST or INT and that would return it as numeric. Then your sort should work. It's been a while since I've done that, but I think it would work. John Burns -Original Message- From: Brad Roberts [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 12:38 PM To: CF-Talk Subject: Ordering a QofQ I'm building a query dynamically, and then trying to sort it on a numeric column, but it only wants to sort alphabetically. Anyone experience this, or know what I need to do to sort numerically? select * from qResults order by hasPhoto DESC, price DESC -Brad _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Declared SQL variables in select statement error
I think the same answer is implied in Hassan's answer as well.. It would seem that you have told the DBMS to create a local variable and put the query results in the local variable then end, thus losing the local variable. If you want to refer to the result then Hassan's code looks good! Michael Traher -Original Message- From: Chris More [mailto:[EMAIL PROTECTED] Sent: 24 November 2003 15:50 To: CF-Talk Subject: Declared SQL variables in select statement error Why can I execute this statement fine in MS SQL Analyzer: DECLARE @q1 varchar(7) SELECT @q1 = period_name FROM adj_periods WHERE period_id = 1 And If I try to do this in CF: DECLARE @q1 varchar(7) SELECT @q1 = period_name FROM adj_periods WHERE period_id = 1 I get this error: QUERY The QUERY attribute of the tag does not specify the name of an available query This is a simplified version of my problem, but it seems that CF will execute the query without an error but the returned query structure won't exist at all. Has anyone else ran into this problem? Thanks, Chris [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: looking for a good dynamic menu
http://milonic.com Works on everything. More features than you can shake a stick at. I wrote a CF wrapper in the Exchange, and sell a fancier one that includes a license for what is now below the current ver's cost. Neither work with the brand-new version 5, but the older ver was lighter-weight and did everything I could ask for, personally. As soon as I can get my cms upgrade released I'll update both tags. Maybe over the U.S. Thanksgiving holiday week. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -Original Message- From: walker [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 9:43 AM To: CF-Talk Subject: looking for a good dynamic menu Hey all, I need to find a good dynamic menu - kind of like the one found on http://www.jensonusa.com, where the rollover pops down a second list of items to choose from. Does anyone know of one that is cross browser compatible, and works well with cold fusion? Thanks for your help. -w _ walker fenton [EMAIL PROTECTED] 303.722.5473 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: looking for a good dynamic menu
Commercial - http://www.opencube.com/ (light as it loads only the script required by the browser) Other - you can find a number at www.dynamicdrive.com (hvmenu is a good one) Johan www.assetnow.com - Original Message - From: Hassan Arteaga Rodriguez To: CF-Talk Sent: Tuesday, November 25, 2003 7:48 AM Subject: RE: looking for a good dynamic menu U should try fireworks MX !! Regards, __ MSc. Hassan Arteaga Rodríguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. -Original Message- From: walker [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 11:43 AM To: CF-Talk Subject: looking for a good dynamic menu Hey all, I need to find a good dynamic menu - kind of like the one found on http://www.jensonusa.com, where the rollover pops down a second list of items to choose from. Does anyone know of one that is cross browser compatible, and works well with cold fusion? Thanks for your help. -w _ walker fenton [EMAIL PROTECTED] 303.722.5473 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: looking for a good dynamic menu
I'm working on a CF 5 server. At 11:48 AM 11/24/2003, you wrote: >U should try fireworks MX !! > > >Regards, > >__ >MSc. Hassan Arteaga Rodríguez >Microsoft Certified System Engineer. >DIGI- Grupo de Desarrollo >COPEXTEL, S.A. > >-Original Message- >From: walker [mailto:[EMAIL PROTECTED] >Sent: Monday, November 24, 2003 11:43 AM >To: CF-Talk >Subject: looking for a good dynamic menu > >Hey all, > >I need to find a good dynamic menu - kind of like the one found on >http://www.jensonusa.com, where the rollover >pops down a second list of >items to choose from. > >Does anyone know of one that is cross browser compatible, and works well > >with cold fusion? > >Thanks for your help. > >-w > >_ >walker fenton >[EMAIL PROTECTED] >303.722.5473 > > _ > > >-- >[ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF - post to database question
Both options are possible, although the e-mail option would have more possible points of failure (i.e. mail not deliverednot read properlyforgot the attachement etc.) The only really tough part here is extracting the data from the file. There are many customs tags to extract data from Excel files, so have a look at the MM Exchange. Grabbing data out of PROPERLY formatted flat file (CSV...tab delimited etc.) is very easy (but if the formatting is off you're up the creek). You simply use CFFILE to read the file in question. That is read into a variable which you then loop through to parse out the records. Remember that the first row is usually the column names...other than that pay special attention to the row delimiters and the column delimiters (these will allow you to seperate out each record and then each field in that record). On each pass of the loop you insert your data. HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Michael Grove To: CF-Talk Sent: Monday, November 24, 2003 8:44 AM Subject: CF - post to database question I am looking for a way to post information directly to a database from a csv, excel or text delimited file. I am looking for one of two options. Option one would give a user the ability to email the file to a specific email address and the server/web app would pull the data from the file automatically and post it in a database. Option two would be to simply give the user the ability to access a web form and upload the file to the server, which in turn would place the data in a database. Can someone point me in the right direction? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: looking for a good dynamic menu
U should try fireworks MX !! Regards, __ MSc. Hassan Arteaga Rodríguez Microsoft Certified System Engineer. DIGI- Grupo de Desarrollo COPEXTEL, S.A. -Original Message- From: walker [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 11:43 AM To: CF-Talk Subject: looking for a good dynamic menu Hey all, I need to find a good dynamic menu - kind of like the one found on http://www.jensonusa.com, where the rollover pops down a second list of items to choose from. Does anyone know of one that is cross browser compatible, and works well with cold fusion? Thanks for your help. -w _ walker fenton [EMAIL PROTECTED] 303.722.5473 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF - post to database question
I am looking for a way to post information directly to a database from a csv, excel or text delimited file. I am looking for one of two options. Option one would give a user the ability to email the file to a specific email address and the server/web app would pull the data from the file automatically and post it in a database. Option two would be to simply give the user the ability to access a web form and upload the file to the server, which in turn would place the data in a database. Can someone point me in the right direction? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
looking for a good dynamic menu
Hey all, I need to find a good dynamic menu - kind of like the one found on http://www.jensonusa.com, where the rollover pops down a second list of items to choose from. Does anyone know of one that is cross browser compatible, and works well with cold fusion? Thanks for your help. -w _ walker fenton [EMAIL PROTECTED] 303.722.5473 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF and ASP
Can I have some ASP code in my test.cfm file? Its a breadcrumb writting in ASP. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Ordering a QofQ
I'm building a query dynamically, and then trying to sort it on a numeric column, but it only wants to sort alphabetically. Anyone experience this, or know what I need to do to sort numerically? select * from qResults order by hasPhoto DESC, price DESC -Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
> Besides, someone else asked about the HOW, not just WHY (sorry if I'm encouraging the repurposement of your thread). Didn't mean to bother you. I repurposed already. And you answered. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
we wanted to do it so that users were able to upload an excel spreadsheet, which could then be manipulated by other people over a period of time. At the time of writing there was no way to do it in MX that appeared to work. So we have a bank of datasources setup in CF which is then monitored by other code and matched up with ODBC datasources via CFRegistry Much much easier (and secure) than installing MS Office on the server (which has the added problem of being really locked down) and trying to use COM -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 17:05 To: CF-Talk Subject: RE: On the fly DSN creation, why? Hi All, you missed what I was trying to do. I know how, but I want to know why. Why do people like create DSNs on the fly? -Original Message- From: Samuel R. Neff [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 8:34 AM To: CF-Talk Subject: RE: On the fly DSN creation, why? You can do dynamic ODBC connections in MX by creating a datasource to an empty Access database and use that as a proxy, specifying the real connection string in the FROM clause of your query. SELECT Salesperson, SalesAmount FROM "Excel 8.0; DATABASE=#tempFile#; HDR=YES".[Sales$] HTH, Sam _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: On the fly DSN creation, why?
In the example I posted, it was to work with an uploaded Excel spreadsheet. In that case, you don't want a real DSN to it but just a dynamic connection. Besides, someone else asked about the HOW, not just WHY (sorry if I'm encouraging the repurposement of your thread). Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- > -Original Message- > From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 12:05 PM > To: CF-Talk > Subject: RE: On the fly DSN creation, why? > > Hi All, you missed what I was trying to do. I know how, but I > want to know why. Why do people like create DSNs on the fly? > > -Original Message- > From: Samuel R. Neff [mailto:[EMAIL PROTECTED] > Sent: Monday, November 24, 2003 8:34 AM > To: CF-Talk > Subject: RE: On the fly DSN creation, why? > > You can do dynamic ODBC connections in MX by creating a > datasource to an empty Access database and use that as a > proxy, specifying the real connection string in the FROM > clause of your query. > > > SELECT Salesperson, SalesAmount > FROM "Excel 8.0; DATABASE=#tempFile#; HDR=YES".[Sales$] > > HTH, > > Sam > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]