Re: Times...
Tried it on my SQL 2k box and it took the function. Now I just need to move the data :) Neil - Original Message - From: "Neil H." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, January 13, 2002 1:35 AM Subject: Re: Times... > Can you use stored functions in SQL 7. From what I can see it doesn't like > that format (or something!) > > Thanks, > > Neil > > - Original Message - > From: "Don Vawter" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, January 11, 2002 9:52 PM > Subject: Re: Times... > > > > it is a stored function not a stored procedure > > should work ins sql 7 > > > > - Original Message - > > From: "Neil H." <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Friday, January 11, 2002 6:49 PM > > Subject: Re: Times... > > > > > > > Server: Msg 170, Level 15, State 1, Line 1 > > > Line 1: Incorrect syntax near 'FUNCTION'. > > > Server: Msg 137, Level 15, State 1, Line 9 > > > Must declare the variable '@dt'. > > > Server: Msg 137, Level 15, State 1, Line 10 > > > Must declare the variable '@interval'. > > > Server: Msg 137, Level 15, State 1, Line 11 > > > Must declare the variable '@interval'. > > > Server: Msg 178, Level 15, State 1, Line 13 > > > A RETURN statement with a return status can only be used in a stored > > > procedure. > > > > > > > > > Any ideas? I don't know what the problem is? > > > > > > THanks, > > > > > > Neil > > > > > > - Original Message - > > > From: "Don Vawter" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Friday, January 11, 2002 8:22 PM > > > Subject: Re: Times... > > > > > > > > > > Thanks, now if I could just find a job. > > > > > > > > - Original Message - > > > > From: "Neil H." <[EMAIL PROTECTED]> > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > Sent: Friday, January 11, 2002 5:29 PM > > > > Subject: Re: Times... > > > > > > > > > > > > > You are the man! > > > > > > > > > > thanks! > > > > > > > > > > Neil > > > > > > > > > > - Original Message - > > > > > From: "Don Vawter" <[EMAIL PROTECTED]> > > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > > Sent: Friday, January 11, 2002 6:54 PM > > > > > Subject: Re: Times... > > > > > > > > > > > > > > > > I have a function that groups date time information by an interval > > of > > > > > > time(in minutes). > > > > > > The function is : udf_interval_format(@dt datetime,@interval int) > > > > > > > > > > > > so if you wanted to count the number of rows in an interval you > > would > > > > use: > > > > > > > > > > > > select utility.dbo.udf_interval_format(yourdatetimefield,2) as > > > > > > yourint,count(*) as ct from yourtable > > > > > > group by utility.dbo.udf_interval_format(yourdatetimefield,2) > > > > > > order by utility.dbo.udf_interval_format(yourdatetimefield,2) > > > > > > > > > > > > which would group data every 2 mins. > > > > > > the output of the function is hh:mm > > > > > > > > > > > > Here is the function > > > > > > > > > > > > CREATE FUNCTION udf_interval_format(@dt datetime,@interval int) > > > > > > RETURNS varchar(5) AS > > > > > > BEGIN > > > > > > DECLARE @pieces int > > > > > > DECLARE @st varchar(5) > > > > > > DECLARE @hourpart int > > > > > > DECLARE @minpart int > > > > > > set @pieces = (60*datepart(hour,@dt) > >+datepart(mi,@dt) )/@interval > > > > > > set @hourpart= @pieces*@interval/60 > > > > > > set @minpart =@pieces*@interval - @hourpart*60 > > > > > > set @st= right('00'+cast(@hourpart as > > > > > > varchar),2)+':'+right('00'+cast(@minpart as varchar),2) > > > > > > return @st > > > > > > END > > > > > > > > > > > > > > > > > > > > > > > > - Original Message - > > > > > > From: "Neil H." <[EMAIL PROTECTED]> > > > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > > > Sent: Friday, January 11, 2002 3:54 PM > > > > > > Subject: Times... > > > > > > > > > > > > > > > > > > > Here is a SQL question for yall... > > > > > > > > > > > > > > I have about 3000 rows a day which have a datetime column. I > want > > > to > > > > be > > > > > > > able to graph the number of rows every 2 minutes. I know it > could > > > be > > > > > done > > > > > > > with a lot of looping in CF but what is the best way to tackle > > this > > > > one? > > > > > > > > > > > > > > Thanks, > > > > > > > > > > > > > > Neil > > > > > > > > > > > > > > > > > > > > > > > > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Developer's Exchange Gallery has moved
good luck... went and tried it a few hours ago... datasource errors and a host of other things... way to go :) well give them a few days I suppose... -p -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 01:45 To: CF-Talk Subject: Developer's Exchange Gallery has moved Macromedia have transferred the ColdFusion gallery over to their domain. Check it out at: Peter Tilbrook ColdFusion Applications Developer 2/13 Murrung Crescent Ngunnawal ACT 2913 AUSTRALIA >> All that is gold does not glitter, Not all those who wander are lost; The old that is strong does not wither, Deep roots are not reached by the frost. >From the ashes a fire shall be woken, A light from the shadows shall spring; Renewed shall be blade that was broken, The crownless again shall be king. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Developer's Exchange Gallery has moved
Macromedia have transferred the ColdFusion gallery over to their domain. Check it out at: Peter Tilbrook ColdFusion Applications Developer 2/13 Murrung Crescent Ngunnawal ACT 2913 AUSTRALIA >> All that is gold does not glitter, Not all those who wander are lost; The old that is strong does not wither, Deep roots are not reached by the frost. >From the ashes a fire shall be woken, A light from the shadows shall spring; Renewed shall be blade that was broken, The crownless again shall be king. __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Times...
Can you use stored functions in SQL 7. From what I can see it doesn't like that format (or something!) Thanks, Neil - Original Message - From: "Don Vawter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 11, 2002 9:52 PM Subject: Re: Times... > it is a stored function not a stored procedure > should work ins sql 7 > > - Original Message - > From: "Neil H." <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, January 11, 2002 6:49 PM > Subject: Re: Times... > > > > Server: Msg 170, Level 15, State 1, Line 1 > > Line 1: Incorrect syntax near 'FUNCTION'. > > Server: Msg 137, Level 15, State 1, Line 9 > > Must declare the variable '@dt'. > > Server: Msg 137, Level 15, State 1, Line 10 > > Must declare the variable '@interval'. > > Server: Msg 137, Level 15, State 1, Line 11 > > Must declare the variable '@interval'. > > Server: Msg 178, Level 15, State 1, Line 13 > > A RETURN statement with a return status can only be used in a stored > > procedure. > > > > > > Any ideas? I don't know what the problem is? > > > > THanks, > > > > Neil > > > > - Original Message - > > From: "Don Vawter" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Friday, January 11, 2002 8:22 PM > > Subject: Re: Times... > > > > > > > Thanks, now if I could just find a job. > > > > > > - Original Message - > > > From: "Neil H." <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Friday, January 11, 2002 5:29 PM > > > Subject: Re: Times... > > > > > > > > > > You are the man! > > > > > > > > thanks! > > > > > > > > Neil > > > > > > > > - Original Message - > > > > From: "Don Vawter" <[EMAIL PROTECTED]> > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > Sent: Friday, January 11, 2002 6:54 PM > > > > Subject: Re: Times... > > > > > > > > > > > > > I have a function that groups date time information by an interval > of > > > > > time(in minutes). > > > > > The function is : udf_interval_format(@dt datetime,@interval int) > > > > > > > > > > so if you wanted to count the number of rows in an interval you > would > > > use: > > > > > > > > > > select utility.dbo.udf_interval_format(yourdatetimefield,2) as > > > > > yourint,count(*) as ct from yourtable > > > > > group by utility.dbo.udf_interval_format(yourdatetimefield,2) > > > > > order by utility.dbo.udf_interval_format(yourdatetimefield,2) > > > > > > > > > > which would group data every 2 mins. > > > > > the output of the function is hh:mm > > > > > > > > > > Here is the function > > > > > > > > > > CREATE FUNCTION udf_interval_format(@dt datetime,@interval int) > > > > > RETURNS varchar(5) AS > > > > > BEGIN > > > > > DECLARE @pieces int > > > > > DECLARE @st varchar(5) > > > > > DECLARE @hourpart int > > > > > DECLARE @minpart int > > > > > set @pieces = (60*datepart(hour,@dt) >+datepart(mi,@dt) )/@interval > > > > > set @hourpart= @pieces*@interval/60 > > > > > set @minpart =@pieces*@interval - @hourpart*60 > > > > > set @st= right('00'+cast(@hourpart as > > > > > varchar),2)+':'+right('00'+cast(@minpart as varchar),2) > > > > > return @st > > > > > END > > > > > > > > > > > > > > > > > > > > - Original Message - > > > > > From: "Neil H." <[EMAIL PROTECTED]> > > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > > Sent: Friday, January 11, 2002 3:54 PM > > > > > Subject: Times... > > > > > > > > > > > > > > > > Here is a SQL question for yall... > > > > > > > > > > > > I have about 3000 rows a day which have a datetime column. I want > > to > > > be > > > > > > able to graph the number of rows every 2 minutes. I know it could > > be > > > > done > > > > > > with a lot of looping in CF but what is the best way to tackle > this > > > one? > > > > > > > > > > > > Thanks, > > > > > > > > > > > > Neil > > > > > > > > > > > > > > > > > > > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: hair-tearing Jet SQL problem!
doesn't seem to work with cf-oledb either...in fact, i couldn't even get it to work in an asp-ado environment... - Original Message - From: Richard Meredith-Hardy To: CF-Talk Sent: Friday, January 11, 2002 11:41 AM Subject: Re: hair-tearing Jet SQL problem! In my experience Access via ODBC to CF does not support the DEFAULT clause in CREATE or ALTER table statements. Don't know about an OLEDB connection (I do know OLEDB to Access creates a whole new set of probs eg ODBC date & time formats are not supported). Joseph Thompson wrote: > > I can't wait to see if there is a solution here. I have come up against > this problem again and again. > > I have been able to read the field types with ADO but... modifying those has > been a little mystifying. > I got about this far and then gave up on it. > http://cfhub.com/advanced/ado/ > > > I was reading through the Jet SQL (for Access 2000) > > documentation, and noticed this: > > > > "Note: The DEFAULT statement can be executed only > > through the Jet OLE DB provider and ADO. It will return an > > error message if used through the Access SQL View user > > interface." > > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT - Javascript and CF
Hi Everyone, This is a bit off topic, but if anyone is still up I could use some guideance. I have a query that returns a value in minutes. What I need to do is setup a counter that counts down The minutes then sends a user to another page after so long... Any ideas? Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WOT: EDI with CF
> EDI, my condolences. When will xml be used with that. I used to parse EDI > orders/acks with perl and it was a nightmare. Anyway, what specifically > are you looking to do? Alex, Since this is a fairly involved subject, I'll take it off the list after this. Just checking to see if anyone else here has any experience along this line. Well the company I'm working for has been doing EDI for a few years but the software we are using is not going to be supported anymore. So I was assigned to start learning what we have to be a backup for the EDI coordinator and start evaluating other software. So I'm looking at the whole plate of spaggetti. I've been looking at what is happening with the current setup. We download an EDI text file to a trading partner software, the mapping software translates this to another reformatted text file that is sent to our antique legacy system. The orders are processed there and a text file comes back out. This text file goes back thru the mapping software gets reformatted and is sent back out with the trading partner software. Another text file is sent to a separate ASN(Advance Shipping Notice) software that is processed there. Out comes another text file that gets sent back to the VAN. I'm testing using CF to parse the incoming EDI files insert the resulting data to various SQL7 tables. Then pulling the data from the SQL7 tables to build the outgoing EDI files. Jeff Craig __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFTP help please .. whats wrong here?
Mike, If I can recall correctly. If you are using a form with an enctype="multipart/form-data" and using that variable as your remotefile. It usually has a temp variable from windows. like this. C:\WINNT\ACF56.tmp I usually force the extention on the remotefile. Here is an example of code that I use for ftp images to the server. I don't know if this will help or not. Thanks, Dan - Original Message - From: "Mike Kear" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 8:43 PM Subject: RE: CFFTP help please .. whats wrong here? > I have CF5. The reason I have to do this is the client isn't on a CF hos > t, > so I have to generate static pages and upload them to their old fashioned > html host. > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > > -Original Message- > From: Dan Blickensderfer [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 13, 2002 12:38 PM > To: CF-Talk > Subject: Re: CFFTP help please .. whats wrong here? > > Mike, > > What version of CF Server is installed on server? > > Thanks, > Dan Blickensderfer > > > - Original Message - > From: "Mike Kear" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, January 12, 2002 8:18 PM > Subject: RE: CFFTP help please .. whats wrong here? > > > > Thanks, Jim. I did that but the problem didn't go away. I checked us > in > > g a > > text output that the code you sent me does indeed yield the correct > > directory and file, so that's correct, sure enough. But I guess that w > as > > n't > > the error. I still get an error in tags at the top of the page say > in > > g : > > "The attribute FileOnServer must contain a filename with a .htm or .htm > l > > extension".Could this be the ftp server sending this message?If > i > > t > > was my CF5 server sending the message it would appear in the debugging > > message at the bottom of the template wouldn't it. > > > > I don't get this message when I do it using CuteFTP or the DOS FTP prog > ra > > m. > > > > Any other ideas what could be causing the PUTFILE tag to fall over? > > > > Cheers, > > Mike Kear > > Windsor, NSW, Australia > > AFP WebWorks > > > > > > -Original Message- > > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, January 13, 2002 11:26 AM > > To: CF-Talk > > Subject: Re: CFFTP help please .. whats wrong here? > > > > Yes, if I recall correctly. If the file is in the same directory as th > e > > template, you can use: > > > > localfile="#ExpandPath('filetoupload.html')#" > > > > Jim > > > > > > - Original Message - > > From: "Mike Kear" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Saturday, January 12, 2002 5:18 PM > > Subject: RE: CFFTP help please .. whats wrong here? > > > > > > > Are you saying that the attribute "localfile" in the putfile tag shou > ld > > b > > > e > > > something like > > > localfile="C:\inetpub\wwwroot\clientsite\workingfolder\filetoupload > h > > tm > > > l" > > > rather than localfile="filetoupload.html"? > > > > > > Cheers, > > > Mike Kear > > > Windsor, NSW, Australia > > > AFP WebWorks > > > > > > > > > > > > -Original Message- > > > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > > > Sent: Sunday, January 13, 2002 11:11 AM > > > To: CF-Talk > > > Subject: Re: CFFTP help please .. whats wrong here? > > > > > > Are you using a fully qualified path to designate the 'localfile'? > > > > > > Jim > > > > > > > > > - Original Message - > > > From: "Mike Kear" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Saturday, January 12, 2002 4:57 PM > > > Subject: CFFTP help please .. whats wrong here? > > > > > > > > > > I'm trying to have a CF template automatically upload a file to a c > li > > en > > > t's > > > > site, and I keep getting an error. I don't know what's wrong .. c > an > > > > someone see please? > > > > > > > > The error I'm getting is: "The attribute FileOnServer must contain > a > > > > filename with a .htm or .html extension 500 Illegal PORT command" > > an > > > d > > > the > > > > debugging info says it's to do with the CFFTP tag that's doing the > pu > > tf > > > ile > > > > action. > > > > > > > > I've done all these actions using the DOS window FTP program, so I > kn > > ow > > > I > > > > have all the relevant permissions to do this. > > > > > > > > > > > > Here's my code: (servername and password etc changed to protect th > e > > > > innocent) > > > > > > > > > > > > > > > server="servername.com.au" > > > > username="username" > > > > password="password" > > > > stoponerror="Yes" > > > > port="21" > > > >connection="clientname"> > > > > > > > > > > > > > > > > > > > directory="/home/radio/public_html/therightfolder" > > > > connection="clientname"> > > > > > > > > > > > > > > >stoponerror="Yes" > > > >localfile="filetoupload.html" > > > >remotefile=
RE: CFFTP help please .. whats wrong here?
I have CF5. The reason I have to do this is the client isn't on a CF hos t, so I have to generate static pages and upload them to their old fashioned html host. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Dan Blickensderfer [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 12:38 PM To: CF-Talk Subject: Re: CFFTP help please .. whats wrong here? Mike, What version of CF Server is installed on server? Thanks, Dan Blickensderfer - Original Message - From: "Mike Kear" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 8:18 PM Subject: RE: CFFTP help please .. whats wrong here? > Thanks, Jim. I did that but the problem didn't go away. I checked us in > g a > text output that the code you sent me does indeed yield the correct > directory and file, so that's correct, sure enough. But I guess that w as > n't > the error. I still get an error in tags at the top of the page say in > g : > "The attribute FileOnServer must contain a filename with a .htm or .htm l > extension".Could this be the ftp server sending this message?If i > t > was my CF5 server sending the message it would appear in the debugging > message at the bottom of the template wouldn't it. > > I don't get this message when I do it using CuteFTP or the DOS FTP prog ra > m. > > Any other ideas what could be causing the PUTFILE tag to fall over? > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 13, 2002 11:26 AM > To: CF-Talk > Subject: Re: CFFTP help please .. whats wrong here? > > Yes, if I recall correctly. If the file is in the same directory as th e > template, you can use: > > localfile="#ExpandPath('filetoupload.html')#" > > Jim > > > - Original Message - > From: "Mike Kear" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, January 12, 2002 5:18 PM > Subject: RE: CFFTP help please .. whats wrong here? > > > > Are you saying that the attribute "localfile" in the putfile tag shou ld > b > > e > > something like > > localfile="C:\inetpub\wwwroot\clientsite\workingfolder\filetoupload h > tm > > l" > > rather than localfile="filetoupload.html"? > > > > Cheers, > > Mike Kear > > Windsor, NSW, Australia > > AFP WebWorks > > > > > > > > -Original Message- > > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, January 13, 2002 11:11 AM > > To: CF-Talk > > Subject: Re: CFFTP help please .. whats wrong here? > > > > Are you using a fully qualified path to designate the 'localfile'? > > > > Jim > > > > > > - Original Message - > > From: "Mike Kear" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Saturday, January 12, 2002 4:57 PM > > Subject: CFFTP help please .. whats wrong here? > > > > > > > I'm trying to have a CF template automatically upload a file to a c li > en > > t's > > > site, and I keep getting an error. I don't know what's wrong .. c an > > > someone see please? > > > > > > The error I'm getting is: "The attribute FileOnServer must contain a > > > filename with a .htm or .html extension 500 Illegal PORT command" > an > > d > > the > > > debugging info says it's to do with the CFFTP tag that's doing the pu > tf > > ile > > > action. > > > > > > I've done all these actions using the DOS window FTP program, so I kn > ow > > I > > > have all the relevant permissions to do this. > > > > > > > > > Here's my code: (servername and password etc changed to protect th e > > > innocent) > > > > > > > > > > > server="servername.com.au" > > > username="username" > > > password="password" > > > stoponerror="Yes" > > > port="21" > > >connection="clientname"> > > > > > > > > > > > > > > directory="/home/radio/public_html/therightfolder" > > > connection="clientname"> > > > > > > > > > > >stoponerror="Yes" > > >localfile="filetoupload.html" > > >remotefile=" filetoupload.html" > > >transfermode="ASCII" > > >connection="clientname"> > > > > > > > >connection="clientname" > > >stopOnError = "Yes"> > > > > > > > > > Can you see what's wrong? > > > > > > Cheers, > > > Mike Kear > > > Windsor, NSW, Australia > > > AFP WebWorks > > > > > > > > > > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: anyone done this in Javascript...
in your submit form put the following: openerfile is the one you want to reload Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm - Original Message - From: "Paris Lundis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 8:23 PM Subject: anyone done this in Javascript... > working on a silly file management piece... we want to take things like > deletes and creates and pop them up in a separate window... no big problem > there... > > complete the form.. submit still in new pop-up... then when completed we > want it to auto-close the window, place the user back at the original > creator/calling window and have that window reload itself to get the > changes... > > anyone have any code handy to do such...?? > > -paris > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFTP help please .. whats wrong here?
Mike, What version of CF Server is installed on server? Thanks, Dan Blickensderfer - Original Message - From: "Mike Kear" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 8:18 PM Subject: RE: CFFTP help please .. whats wrong here? > Thanks, Jim. I did that but the problem didn't go away. I checked usin > g a > text output that the code you sent me does indeed yield the correct > directory and file, so that's correct, sure enough. But I guess that was > n't > the error. I still get an error in tags at the top of the page sayin > g : > "The attribute FileOnServer must contain a filename with a .htm or .html > extension".Could this be the ftp server sending this message?If i > t > was my CF5 server sending the message it would appear in the debugging > message at the bottom of the template wouldn't it. > > I don't get this message when I do it using CuteFTP or the DOS FTP progra > m. > > Any other ideas what could be causing the PUTFILE tag to fall over? > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 13, 2002 11:26 AM > To: CF-Talk > Subject: Re: CFFTP help please .. whats wrong here? > > Yes, if I recall correctly. If the file is in the same directory as the > template, you can use: > > localfile="#ExpandPath('filetoupload.html')#" > > Jim > > > - Original Message - > From: "Mike Kear" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, January 12, 2002 5:18 PM > Subject: RE: CFFTP help please .. whats wrong here? > > > > Are you saying that the attribute "localfile" in the putfile tag should > b > > e > > something like > > localfile="C:\inetpub\wwwroot\clientsite\workingfolder\filetoupload.h > tm > > l" > > rather than localfile="filetoupload.html"? > > > > Cheers, > > Mike Kear > > Windsor, NSW, Australia > > AFP WebWorks > > > > > > > > -Original Message- > > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, January 13, 2002 11:11 AM > > To: CF-Talk > > Subject: Re: CFFTP help please .. whats wrong here? > > > > Are you using a fully qualified path to designate the 'localfile'? > > > > Jim > > > > > > - Original Message - > > From: "Mike Kear" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Saturday, January 12, 2002 4:57 PM > > Subject: CFFTP help please .. whats wrong here? > > > > > > > I'm trying to have a CF template automatically upload a file to a cli > en > > t's > > > site, and I keep getting an error. I don't know what's wrong .. can > > > someone see please? > > > > > > The error I'm getting is: "The attribute FileOnServer must contain a > > > filename with a .htm or .html extension 500 Illegal PORT command" > an > > d > > the > > > debugging info says it's to do with the CFFTP tag that's doing the pu > tf > > ile > > > action. > > > > > > I've done all these actions using the DOS window FTP program, so I kn > ow > > I > > > have all the relevant permissions to do this. > > > > > > > > > Here's my code: (servername and password etc changed to protect the > > > innocent) > > > > > > > > > > > server="servername.com.au" > > > username="username" > > > password="password" > > > stoponerror="Yes" > > > port="21" > > >connection="clientname"> > > > > > > > > > > > > > > directory="/home/radio/public_html/therightfolder" > > > connection="clientname"> > > > > > > > > > > >stoponerror="Yes" > > >localfile="filetoupload.html" > > >remotefile=" filetoupload.html" > > >transfermode="ASCII" > > >connection="clientname"> > > > > > > > >connection="clientname" > > >stopOnError = "Yes"> > > > > > > > > > Can you see what's wrong? > > > > > > Cheers, > > > Mike Kear > > > Windsor, NSW, Australia > > > AFP WebWorks > > > > > > > > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
anyone done this in Javascript...
working on a silly file management piece... we want to take things like deletes and creates and pop them up in a separate window... no big problem there... complete the form.. submit still in new pop-up... then when completed we want it to auto-close the window, place the user back at the original creator/calling window and have that window reload itself to get the changes... anyone have any code handy to do such...?? -paris __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFTP help please .. whats wrong here?
Thanks, Jim. I did that but the problem didn't go away. I checked usin g a text output that the code you sent me does indeed yield the correct directory and file, so that's correct, sure enough. But I guess that was n't the error. I still get an error in tags at the top of the page sayin g : "The attribute FileOnServer must contain a filename with a .htm or .html extension".Could this be the ftp server sending this message?If i t was my CF5 server sending the message it would appear in the debugging message at the bottom of the template wouldn't it. I don't get this message when I do it using CuteFTP or the DOS FTP progra m. Any other ideas what could be causing the PUTFILE tag to fall over? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 11:26 AM To: CF-Talk Subject: Re: CFFTP help please .. whats wrong here? Yes, if I recall correctly. If the file is in the same directory as the template, you can use: localfile="#ExpandPath('filetoupload.html')#" Jim - Original Message - From: "Mike Kear" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 5:18 PM Subject: RE: CFFTP help please .. whats wrong here? > Are you saying that the attribute "localfile" in the putfile tag should b > e > something like > localfile="C:\inetpub\wwwroot\clientsite\workingfolder\filetoupload.h tm > l" > rather than localfile="filetoupload.html"? > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > > > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 13, 2002 11:11 AM > To: CF-Talk > Subject: Re: CFFTP help please .. whats wrong here? > > Are you using a fully qualified path to designate the 'localfile'? > > Jim > > > - Original Message - > From: "Mike Kear" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, January 12, 2002 4:57 PM > Subject: CFFTP help please .. whats wrong here? > > > > I'm trying to have a CF template automatically upload a file to a cli en > t's > > site, and I keep getting an error. I don't know what's wrong .. can > > someone see please? > > > > The error I'm getting is: "The attribute FileOnServer must contain a > > filename with a .htm or .html extension 500 Illegal PORT command" an > d > the > > debugging info says it's to do with the CFFTP tag that's doing the pu tf > ile > > action. > > > > I've done all these actions using the DOS window FTP program, so I kn ow > I > > have all the relevant permissions to do this. > > > > > > Here's my code: (servername and password etc changed to protect the > > innocent) > > > > > > > server="servername.com.au" > > username="username" > > password="password" > > stoponerror="Yes" > > port="21" > >connection="clientname"> > > > > > > > > > directory="/home/radio/public_html/therightfolder" > > connection="clientname"> > > > > > > >stoponerror="Yes" > >localfile="filetoupload.html" > >remotefile=" filetoupload.html" > >transfermode="ASCII" > >connection="clientname"> > > > > >connection="clientname" > >stopOnError = "Yes"> > > > > > > Can you see what's wrong? > > > > Cheers, > > Mike Kear > > Windsor, NSW, Australia > > AFP WebWorks > > > > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WOT: EDI with CF
EDI, my condolences. When will xml be used with that. I used to parse EDI orders/acks with perl and it was a nightmare. Anyway, what specifically are you looking to do? On Sat, 12 Jan 2002 [EMAIL PROTECTED] wrote: > Has anyone done anything with EDI using CF? > More specifically handling inbound/outbound EDI data mapping from a VAN > such as GEIS, Sterling, AT&T, etc. > > Jeff Craig > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFTP help please .. whats wrong here?
Yes, if I recall correctly. If the file is in the same directory as the template, you can use: localfile="#ExpandPath('filetoupload.html')#" Jim - Original Message - From: "Mike Kear" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 5:18 PM Subject: RE: CFFTP help please .. whats wrong here? > Are you saying that the attribute "localfile" in the putfile tag should b > e > something like > localfile="C:\inetpub\wwwroot\clientsite\workingfolder\filetoupload.htm > l" > rather than localfile="filetoupload.html"? > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > > > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 13, 2002 11:11 AM > To: CF-Talk > Subject: Re: CFFTP help please .. whats wrong here? > > Are you using a fully qualified path to designate the 'localfile'? > > Jim > > > - Original Message - > From: "Mike Kear" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, January 12, 2002 4:57 PM > Subject: CFFTP help please .. whats wrong here? > > > > I'm trying to have a CF template automatically upload a file to a clien > t's > > site, and I keep getting an error. I don't know what's wrong .. can > > someone see please? > > > > The error I'm getting is: "The attribute FileOnServer must contain a > > filename with a .htm or .html extension 500 Illegal PORT command" an > d > the > > debugging info says it's to do with the CFFTP tag that's doing the putf > ile > > action. > > > > I've done all these actions using the DOS window FTP program, so I know > I > > have all the relevant permissions to do this. > > > > > > Here's my code: (servername and password etc changed to protect the > > innocent) > > > > > > > server="servername.com.au" > > username="username" > > password="password" > > stoponerror="Yes" > > port="21" > >connection="clientname"> > > > > > > > > > directory="/home/radio/public_html/therightfolder" > > connection="clientname"> > > > > > > >stoponerror="Yes" > >localfile="filetoupload.html" > >remotefile=" filetoupload.html" > >transfermode="ASCII" > >connection="clientname"> > > > > >connection="clientname" > >stopOnError = "Yes"> > > > > > > Can you see what's wrong? > > > > Cheers, > > Mike Kear > > Windsor, NSW, Australia > > AFP WebWorks > > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFFTP help please .. whats wrong here?
Are you saying that the attribute "localfile" in the putfile tag should b e something like localfile="C:\inetpub\wwwroot\clientsite\workingfolder\filetoupload.htm l" rather than localfile="filetoupload.html"? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 11:11 AM To: CF-Talk Subject: Re: CFFTP help please .. whats wrong here? Are you using a fully qualified path to designate the 'localfile'? Jim - Original Message - From: "Mike Kear" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 4:57 PM Subject: CFFTP help please .. whats wrong here? > I'm trying to have a CF template automatically upload a file to a clien t's > site, and I keep getting an error. I don't know what's wrong .. can > someone see please? > > The error I'm getting is: "The attribute FileOnServer must contain a > filename with a .htm or .html extension 500 Illegal PORT command" an d the > debugging info says it's to do with the CFFTP tag that's doing the putf ile > action. > > I've done all these actions using the DOS window FTP program, so I know I > have all the relevant permissions to do this. > > > Here's my code: (servername and password etc changed to protect the > innocent) > > > server="servername.com.au" > username="username" > password="password" > stoponerror="Yes" > port="21" >connection="clientname"> > > > > directory="/home/radio/public_html/therightfolder" > connection="clientname"> > > > stoponerror="Yes" >localfile="filetoupload.html" >remotefile=" filetoupload.html" >transfermode="ASCII" >connection="clientname"> > > connection="clientname" >stopOnError = "Yes"> > > > Can you see what's wrong? > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFFTP help please .. whats wrong here?
Are you using a fully qualified path to designate the 'localfile'? Jim - Original Message - From: "Mike Kear" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 4:57 PM Subject: CFFTP help please .. whats wrong here? > I'm trying to have a CF template automatically upload a file to a client's > site, and I keep getting an error. I don't know what's wrong .. can > someone see please? > > The error I'm getting is: "The attribute FileOnServer must contain a > filename with a .htm or .html extension 500 Illegal PORT command" and the > debugging info says it's to do with the CFFTP tag that's doing the putfile > action. > > I've done all these actions using the DOS window FTP program, so I know I > have all the relevant permissions to do this. > > > Here's my code: (servername and password etc changed to protect the > innocent) > > > server="servername.com.au" > username="username" > password="password" > stoponerror="Yes" > port="21" >connection="clientname"> > > > > directory="/home/radio/public_html/therightfolder" > connection="clientname"> > > > stoponerror="Yes" >localfile="filetoupload.html" >remotefile=" filetoupload.html" >transfermode="ASCII" >connection="clientname"> > > connection="clientname" >stopOnError = "Yes"> > > > Can you see what's wrong? > > Cheers, > Mike Kear > Windsor, NSW, Australia > AFP WebWorks > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFFTP help please .. whats wrong here?
I'm trying to have a CF template automatically upload a file to a client's site, and I keep getting an error. I don't know what's wrong .. can someone see please? The error I'm getting is: "The attribute FileOnServer must contain a filename with a .htm or .html extension 500 Illegal PORT command" and the debugging info says it's to do with the CFFTP tag that's doing the putfile action. I've done all these actions using the DOS window FTP program, so I know I have all the relevant permissions to do this. Here's my code: (servername and password etc changed to protect the innocent) Can you see what's wrong? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ANother CFDirectory question
Why not use the type instead, as it will say file or directory? -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Sunday, 13 January 2002 10:12 AM To: CF-Talk Subject: RE: ANother CFDirectory question I got around the pointers using the following code you have to think about the anticipated file naming conventions in regards to the test length. ...show name... Tony -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 12, 2002 3:04 PM To: CF-Talk Subject: Re: ANother CFDirectory question Ahh. Makes sense. So I will just have to account for that then. Thanks. - Original Message - From: "Macarie Neculai" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 5:00 PM Subject: RE: ANother CFDirectory question > Yes, this is normal. The first period is a "pointer" to the directory > himself, the ".." directory represents the parent directory. > > Mack. > > > > > OK, > > I have another question about CFDirectory. When I output the names of > > the files, I am seeing three things that are not right. The first file > > is a period, and the next one is two periods. I am also seeing a file > > called Thumbs.db. Is this normal? > > > > Thanks > > _ > > Bruce Sorge > > ICQ#:145050973 > > Current ICQ status: > > > > SMS: (Send an SMS message to my ICQ): +2783142145050973 > > More ways to contact me: http://wwp.icq.com/145050973 > > _ > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ANother CFDirectory question
> -Original Message- > From: Tony Gruen [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 13, 2002 1:12 AM > To: CF-Talk > Subject: RE: ANother CFDirectory question > > > I got around the pointers using the following code you have to think > about the anticipated file naming conventions in regards to the > test length. > > > ...show name... Maybe you should take into account that on Linux a filename can be less thatn 5 characters (because there is no extension). And even on Win based OS you can still have a filename shorter than 5 characters. I think that the following code is more appropriate: ..#name#... we have a false directory Mack. > > Tony > > -Original Message- > From: Bruce Sorge [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 12, 2002 3:04 PM > To: CF-Talk > Subject: Re: ANother CFDirectory question > > > Ahh. Makes sense. So I will just have to account for that then. Thanks. > > - Original Message - > From: "Macarie Neculai" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, January 12, 2002 5:00 PM > Subject: RE: ANother CFDirectory question > > > > Yes, this is normal. The first period is a "pointer" to the directory > > himself, the ".." directory represents the parent directory. > > > > Mack. > > > > > > > > OK, > > > I have another question about CFDirectory. When I output the names of > > > the files, I am seeing three things that are not right. The first file > > > is a period, and the next one is two periods. I am also seeing a file > > > called Thumbs.db. Is this normal? > > > > > > Thanks __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ANother CFDirectory question
I got around the pointers using the following code you have to think about the anticipated file naming conventions in regards to the test length. ...show name... Tony -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 12, 2002 3:04 PM To: CF-Talk Subject: Re: ANother CFDirectory question Ahh. Makes sense. So I will just have to account for that then. Thanks. - Original Message - From: "Macarie Neculai" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 5:00 PM Subject: RE: ANother CFDirectory question > Yes, this is normal. The first period is a "pointer" to the directory > himself, the ".." directory represents the parent directory. > > Mack. > > > > > OK, > > I have another question about CFDirectory. When I output the names of > > the files, I am seeing three things that are not right. The first file > > is a period, and the next one is two periods. I am also seeing a file > > called Thumbs.db. Is this normal? > > > > Thanks > > _ > > Bruce Sorge > > ICQ#:145050973 > > Current ICQ status: > > > > SMS: (Send an SMS message to my ICQ): +2783142145050973 > > More ways to contact me: http://wwp.icq.com/145050973 > > _ > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ANother CFDirectory question
Ahh. Makes sense. So I will just have to account for that then. Thanks. - Original Message - From: "Macarie Neculai" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 5:00 PM Subject: RE: ANother CFDirectory question > Yes, this is normal. The first period is a "pointer" to the directory > himself, the ".." directory represents the parent directory. > > Mack. > > > > > OK, > > I have another question about CFDirectory. When I output the names of > > the files, I am seeing three things that are not right. The first file > > is a period, and the next one is two periods. I am also seeing a file > > called Thumbs.db. Is this normal? > > > > Thanks > > _ > > Bruce Sorge > > ICQ#:145050973 > > Current ICQ status: > > > > SMS: (Send an SMS message to my ICQ): +2783142145050973 > > More ways to contact me: http://wwp.icq.com/145050973 > > _ > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ANother CFDirectory question
Yes, this is normal. The first period is a "pointer" to the directory himself, the ".." directory represents the parent directory. Mack. > > OK, > I have another question about CFDirectory. When I output the names of > the files, I am seeing three things that are not right. The first file > is a period, and the next one is two periods. I am also seeing a file > called Thumbs.db. Is this normal? > > Thanks > _ > Bruce Sorge > ICQ#:145050973 > Current ICQ status: > > SMS: (Send an SMS message to my ICQ): +2783142145050973 > More ways to contact me: http://wwp.icq.com/145050973 > _ > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: ANother CFDirectory question
OK, I know what thumbs.db is. It is only in files where there are or were images. It is associated with Windows Xp. XP has the ability to show images as thumb nails and film strips. I still do not know why the two periods are there though. - Original Message - From: "Bruce Sorge" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 4:54 PM Subject: ANother CFDirectory question > OK, > I have another question about CFDirectory. When I output the names of > the files, I am seeing three things that are not right. The first file > is a period, and the next one is two periods. I am also seeing a file > called Thumbs.db. Is this normal? > > Thanks > _ > Bruce Sorge > ICQ#:145050973 > Current ICQ status: > > SMS: (Send an SMS message to my ICQ): +2783142145050973 > More ways to contact me: http://wwp.icq.com/145050973 > _ > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ANother CFDirectory question
OK, I have another question about CFDirectory. When I output the names of the files, I am seeing three things that are not right. The first file is a period, and the next one is two periods. I am also seeing a file called Thumbs.db. Is this normal? Thanks _ Bruce Sorge ICQ#:145050973 Current ICQ status: SMS: (Send an SMS message to my ICQ): +2783142145050973 More ways to contact me: http://wwp.icq.com/145050973 _ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFPOP
Anybody out there have any luck with ? I'm playing around with trying to build a webmail app just for the experience ... I keep getting a CF error: Connection Failure The error occurred while processing an element with a general identifier of (CFPOP), Here's the tag it craps out on: Any help would be appreciated TIA __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFDirectory and and Forms
Thanks. That was it. - Original Message - From: "Howie Hamlin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 2:31 PM Subject: Re: CFDirectory and and Forms > The cfdirectory function returns a query...so, you can use the recordcount. Here's an example: > > > #mylist.recordcount# > > HTH, > > -- > Howie Hamlin - inFusion Project Manager > On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 > inFusion Mail Server (iMS) - The Intelligent Mail Server > >>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm > > - Original Message - > From: "Bruce Sorge" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, January 12, 2002 3:22 PM > Subject: CFDirectory and and Forms > > > > Hello again list. > > > > Here is what I am wanting to do I need to be able to count the number of > > files in a particular directory. I am using CFDirectory to find and list > > the files, the problem I am having is counting them. I need to do this > > so that I can wrap these files into a dynamic table and also add a > > couple of form controls to them as well for submitting to a server. > > How do I count the files? > > > > Thanks, > > _ > > Bruce Sorge > > ICQ#:145050973 > > Current ICQ status: > > > > SMS: (Send an SMS message to my ICQ): +2783142145050973 > > More ways to contact me: http://wwp.icq.com/145050973 > > _ > > > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFDirectory and and Forms
The cfdirectory function returns a query...so, you can use the recordcount. Here's an example: #mylist.recordcount# HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm - Original Message - From: "Bruce Sorge" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 3:22 PM Subject: CFDirectory and and Forms > Hello again list. > > Here is what I am wanting to do I need to be able to count the number of > files in a particular directory. I am using CFDirectory to find and list > the files, the problem I am having is counting them. I need to do this > so that I can wrap these files into a dynamic table and also add a > couple of form controls to them as well for submitting to a server. > How do I count the files? > > Thanks, > _ > Bruce Sorge > ICQ#:145050973 > Current ICQ status: > > SMS: (Send an SMS message to my ICQ): +2783142145050973 > More ways to contact me: http://wwp.icq.com/145050973 > _ > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFDirectory and and Forms
Hello again list. Here is what I am wanting to do I need to be able to count the number of files in a particular directory. I am using CFDirectory to find and list the files, the problem I am having is counting them. I need to do this so that I can wrap these files into a dynamic table and also add a couple of form controls to them as well for submitting to a server. How do I count the files? Thanks, _ Bruce Sorge ICQ#:145050973 Current ICQ status: SMS: (Send an SMS message to my ICQ): +2783142145050973 More ways to contact me: http://wwp.icq.com/145050973 _ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[4]: Using RegularExpressions
Well... :) I'll try the Studio feature. Nothing can't go wrong. But nevertheless fine to get some help from a Mac-User :)) But I'll mention here if it worked, when I'm back to work again! Patric Stumpe mail: [EMAIL PROTECTED] DA> I don't know... I don't use studio... DA> If studio supports back references then you are good! DA> Its my understanding that most program editors support grep (and back DA> references), so I would be surprised if studio doesn't. DA> I use BBEdit on the Mac and it supports them. DA> Dick __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[3]: Using RegularExpressions
I don't know... I don't use studio... If studio supports back references then you are good! Its my understanding that most program editors support grep (and back references), so I would be surprised if studio doesn't. I use BBEdit on the Mac and it supports them. Dick At 7:47 PM +0100 1/12/02, Patric Stumpe wrote: >So do you think it would also work in the Extended-Search/Replace-Menu >in Studio or do I have to write a little cfm for that? > > >Patric Stumpe >mail: [EMAIL PROTECTED] > >DA> It is a backreference to remembered text (enclosed in parens) in the >DA> first term (you can have up to 9 such items \1, \2... corresponding >DA> to 9 sets of parens > >DA> So: > >DA> 'a href="([a-z0-9])', 'a href="../\1' > = >DA>|| >DA>|| >DA>|| >DA>remembered replaced with remembered > >DA> The "remembered" text, in this case is" > >DA> any letter or number followinga href=" > >DA> Dick > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
WOT: EDI with CF
Has anyone done anything with EDI using CF? More specifically handling inbound/outbound EDI data mapping from a VAN such as GEIS, Sterling, AT&T, etc. Jeff Craig __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[3]: Using RegularExpressions
So do you think it would also work in the Extended-Search/Replace-Menu in Studio or do I have to write a little cfm for that? Patric Stumpe mail: [EMAIL PROTECTED] DA> It is a backreference to remembered text (enclosed in parens) in the DA> first term (you can have up to 9 such items \1, \2... corresponding DA> to 9 sets of parens DA> So: DA> 'a href="([a-z0-9])', 'a href="../\1' = DA>|| DA>|| DA>|| DA>remembered replaced with remembered DA> The "remembered" text, in this case is" DA> any letter or number followinga href=" DA> Dick __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: Using RegularExpressions
It is a backreference to remembered text (enclosed in parens) in the first term (you can have up to 9 such items \1, \2... corresponding to 9 sets of parens So: 'a href="([a-z0-9])', 'a href="../\1' = || || || remembered replaced with remembered The "remembered" text, in this case is" any letter or number followinga href=" Dick At 7:13 PM +0100 1/12/02, Patric Stumpe wrote: >Hi Dick, > >I'll give it a try on monday. >Is the 'Backslash-1' an Placeholderholder? > >Thanx a lot > > > >Patric >mail: [EMAIL PROTECTED] > >DA> Try > >DA>new = ReReplaceNoCase(old, 'a href="([a-z0-9])', 'a href="../\ 1', >DA> 'all'); > >DA> HTH > >DA> Dick > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: Using RegularExpressions
Hi Dick, I'll give it a try on monday. Is the 'Backslash-1' an Placeholderholder? Thanx a lot Patric mail: [EMAIL PROTECTED] DA> Try DA>new = ReReplaceNoCase(old, 'a href="([a-z0-9])', 'a href="../\1', DA> 'all'); DA> HTH DA> Dick __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Passing variables through a URL
Bud, Thank you so much for taking that much time to explain it to me! You have been VERY helpful! Thanks! Jim Vosika (newbie) -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 12, 2002 8:53 AM To: CF-Talk Subject: Re: Passing variables through a URL On 1/12/02, Jim Vosika penned: >Hi, > I know it's late but I have a newbie question for anyone awake. >I am trying to make a text link that would sort records from a query. I >would like to pass the parameter through the URL that says which column >to sort by but can't figure out how. This brings up another question, am >I using SQL/CFML properly to sort records on the fly. If you could tell >me how to pass the url variable that would be wonderful! Here is my code >so far: Hi Jim. This is the easiest way, but less secure as it will display the table names and allow for someone to manually enter a string to pass to the query: SELECT * FROM Table1 ORDER BY #url.orderBy# Vehicle Type Year Manufacturer Description To add some security, we could check for the valid url variables, changing them to something a little shorter and hiding the table names in the process: SELECT * FROM Table1 ORDER BY #variables.orderBy# Vehicle Type Year Manufacturer Description This way if anyone manually enters anything other than orderBy=vt (or my, mn or vd) vehicleType will be passed to the Order By clause in the query. Plus as I said, you won't be revealing the table names. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Zip Codes
This is something we use for searching for service centers within a certain radius. Hope it helps. SELECT latitude,longitude FROM geocode WHERE zipCode = '#form.zipCode#' SELECT svccode, name, city, state, status, latitude, longitude, distance = sqrt( square( 69.1 * (longitude - #geocode.longitude#) * ( cos(#geocode.latitude#/57.3) ) ) + square( 69.1 * (latitude - #geocode.latitude#) ) ) FROM serviceCenter WHERE sqrt( square( 69.1 * (longitude - #geocode.longitude#) * ( cos(#geocode.latitude#/57.3) ) ) + square( 69.1 * (latitude - #geocode.latitude#) ) ) <= (#form.distance# + 5) --> ORDER BY distance There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: "Tangorre, Michael T." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 9:17 AM Subject: RE: CF and Zip Codes > Basically what I am doing to clarify things is the following: > I wanna be able to search for stores in my database and get the stores > within x number of miles from the visitors enetered zip code.. > > Does this make more sense..sorry for the confusion... I pulled an all > nighter :-) > > > > -Original Message- > From: Jeff Beer [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 12, 2002 11:35 AM > To: CF-Talk > Subject: RE: CF and Zip Codes > > > Hey - Michael - I read your message wrong. If all you need is the distance > between two zips you can have that tag for free. It won't do the radius > calcs (all zips within x miles of a given zip). > > Sorry for the confusion! > > > > > > -Original Message- > From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 12, 2002 11:14 AM > To: CF-Talk > Subject: CF and Zip Codes > > > Has anyone ever done this or know a good way to do it.. > I need to calculate the distance between 2 zip codes using Cold Fusion. > > Michael T. Tangorre > > == > Resident Assistant - Brick > Web Applications Developer > A.U. Webteam Slave :-) > AIM: CrazyFlash4 > == > > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Zip Codes
That's what the CF_ZipRad tag is made to do. It uses the zip code database provided by Bud Jay at http://www.jcsm.com, but can be modifed to work with any zip code DB containing lat and long coordinates. Bud's DB is the lowest cost, most complete one I've ever found, and I'm always looking :-) -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 12, 2002 12:18 PM To: CF-Talk Subject: RE: CF and Zip Codes Basically what I am doing to clarify things is the following: I wanna be able to search for stores in my database and get the stores within x number of miles from the visitors enetered zip code.. Does this make more sense..sorry for the confusion... I pulled an all nighter :-) -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 12, 2002 11:35 AM To: CF-Talk Subject: RE: CF and Zip Codes Hey - Michael - I read your message wrong. If all you need is the distance between two zips you can have that tag for free. It won't do the radius calcs (all zips within x miles of a given zip). Sorry for the confusion! -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 12, 2002 11:14 AM To: CF-Talk Subject: CF and Zip Codes Has anyone ever done this or know a good way to do it.. I need to calculate the distance between 2 zip codes using Cold Fusion. Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Zip Codes
Yes.. Look at the following. Have used it for a long time. http://www.dbactive.com/tags/zipraddoc.htm You'll need to get the ziprad database from here: http://www.jcsm.com/ Lee > -Original Message- > From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 12, 2002 9:18 AM > To: CF-Talk > Subject: RE: CF and Zip Codes > > > Basically what I am doing to clarify things is the following: > I wanna be able to search for stores in my database and get > the stores within x number of miles from the visitors > enetered zip code.. > > Does this make more sense..sorry for the confusion... I > pulled an all nighter :-) > > > > -Original Message- > From: Jeff Beer [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 12, 2002 11:35 AM > To: CF-Talk > Subject: RE: CF and Zip Codes > > > Hey - Michael - I read your message wrong. If all you need > is the distance between two zips you can have that tag for > free. It won't do the radius calcs (all zips within x miles > of a given zip). > > Sorry for the confusion! > > > > > > -Original Message- > From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 12, 2002 11:14 AM > To: CF-Talk > Subject: CF and Zip Codes > > > Has anyone ever done this or know a good way to do it.. > I need to calculate the distance between 2 zip codes using > Cold Fusion. > > Michael T. Tangorre > > > Resident Assistant - Brick > Web Applications Developer > A.U. Webteam Slave :-) > AIM: CrazyFlash4 > > > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Zip Codes
Basically what I am doing to clarify things is the following: I wanna be able to search for stores in my database and get the stores within x number of miles from the visitors enetered zip code.. Does this make more sense..sorry for the confusion... I pulled an all nighter :-) -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 12, 2002 11:35 AM To: CF-Talk Subject: RE: CF and Zip Codes Hey - Michael - I read your message wrong. If all you need is the distance between two zips you can have that tag for free. It won't do the radius calcs (all zips within x miles of a given zip). Sorry for the confusion! -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 12, 2002 11:14 AM To: CF-Talk Subject: CF and Zip Codes Has anyone ever done this or know a good way to do it.. I need to calculate the distance between 2 zip codes using Cold Fusion. Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF and Zip Codes
I have stored procs and functions in SQL Server 2000 for that. Contact me off list if you can use them They won't work in SQL 7 - Original Message - From: "Tangorre, Michael T." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 9:14 AM Subject: CF and Zip Codes > Has anyone ever done this or know a good way to do it.. > I need to calculate the distance between 2 zip codes using Cold Fusion. > > Michael T. Tangorre > > > Resident Assistant - Brick > Web Applications Developer > A.U. Webteam Slave :-) > AIM: CrazyFlash4 > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Aboout ActivePdf
Can you actually create print quality PDF's using ActivePDF? I'd love to make some dynamic reports to use as brochures, etc, containing real-time data from some of our apps. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 2:41 PM To: CF-Talk Subject: RE: Aboout ActivePdf It's relatively quick- we can generate hundreds of report cards in less than a minute. If you are doing bulk prints it is a good way to go. -Original Message- From: sam komolafe [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 2:44 PM To: CF-Talk Subject: Aboout ActivePdf Hi guys, Is anyone in CF community using ActivePdf to automatically generate print output? If yes what are the advantages? thanks sam __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Zip Codes
Hey - Michael - I read your message wrong. If all you need is the distance between two zips you can have that tag for free. It won't do the radius calcs (all zips within x miles of a given zip). Sorry for the confusion! -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 12, 2002 11:14 AM To: CF-Talk Subject: CF and Zip Codes Has anyone ever done this or know a good way to do it.. I need to calculate the distance between 2 zip codes using Cold Fusion. Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF and Zip Codes
Check out http://www.dbactive.com. The front page has a number of zip code related custom tags. [disclaimer: it's my site and my tags. The site blows, but the tags work very well - ] -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 12, 2002 11:14 AM To: CF-Talk Subject: CF and Zip Codes Has anyone ever done this or know a good way to do it.. I need to calculate the distance between 2 zip codes using Cold Fusion. Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF and Zip Codes
Has anyone ever done this or know a good way to do it.. I need to calculate the distance between 2 zip codes using Cold Fusion. Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: dropping backup files
Hello all, Apologies in advance for the OT message. I'm in a small bind. SQL Server 2k on a shared host. My hosted DB's allowed disk space is full and I need to add an index ('primary filegroup is full'). I've backed up and truncated the transaction log and have a complete copy of the DB in case anything goes wrong. Is there any way to drop or delete backup files without having SA or equiv. access? If so, would this restore space to the primary filegroup, or does this depend on how the hosting company has configured SQL Server? I'v read about expiring backups but can't seem to find the options in Enterprise Manager. Any help is greatly appreciated! Jeff __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Passing variables through a URL
On 1/12/02, Jim Vosika penned: >Hi, > I know it's late but I have a newbie question for anyone awake. >I am trying to make a text link that would sort records from a query. I >would like to pass the parameter through the URL that says which column >to sort by but can't figure out how. This brings up another question, am >I using SQL/CFML properly to sort records on the fly. If you could tell >me how to pass the url variable that would be wonderful! Here is my code >so far: Hi Jim. This is the easiest way, but less secure as it will display the table names and allow for someone to manually enter a string to pass to the query: SELECT * FROM Table1 ORDER BY #url.orderBy# Vehicle Type Year Manufacturer Description To add some security, we could check for the valid url variables, changing them to something a little shorter and hiding the table names in the process: SELECT * FROM Table1 ORDER BY #variables.orderBy# Vehicle Type Year Manufacturer Description This way if anyone manually enters anything other than orderBy=vt (or my, mn or vd) vehicleType will be passed to the Order By clause in the query. Plus as I said, you won't be revealing the table names. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Times...
No workie :( Neil - Original Message - From: "Don Vawter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 11, 2002 9:52 PM Subject: Re: Times... > it is a stored function not a stored procedure > should work ins sql 7 > > - Original Message - > From: "Neil H." <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, January 11, 2002 6:49 PM > Subject: Re: Times... > > > > Server: Msg 170, Level 15, State 1, Line 1 > > Line 1: Incorrect syntax near 'FUNCTION'. > > Server: Msg 137, Level 15, State 1, Line 9 > > Must declare the variable '@dt'. > > Server: Msg 137, Level 15, State 1, Line 10 > > Must declare the variable '@interval'. > > Server: Msg 137, Level 15, State 1, Line 11 > > Must declare the variable '@interval'. > > Server: Msg 178, Level 15, State 1, Line 13 > > A RETURN statement with a return status can only be used in a stored > > procedure. > > > > > > Any ideas? I don't know what the problem is? > > > > THanks, > > > > Neil > > > > - Original Message - > > From: "Don Vawter" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Friday, January 11, 2002 8:22 PM > > Subject: Re: Times... > > > > > > > Thanks, now if I could just find a job. > > > > > > - Original Message - > > > From: "Neil H." <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Friday, January 11, 2002 5:29 PM > > > Subject: Re: Times... > > > > > > > > > > You are the man! > > > > > > > > thanks! > > > > > > > > Neil > > > > > > > > - Original Message - > > > > From: "Don Vawter" <[EMAIL PROTECTED]> > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > Sent: Friday, January 11, 2002 6:54 PM > > > > Subject: Re: Times... > > > > > > > > > > > > > I have a function that groups date time information by an interval > of > > > > > time(in minutes). > > > > > The function is : udf_interval_format(@dt datetime,@interval int) > > > > > > > > > > so if you wanted to count the number of rows in an interval you > would > > > use: > > > > > > > > > > select utility.dbo.udf_interval_format(yourdatetimefield,2) as > > > > > yourint,count(*) as ct from yourtable > > > > > group by utility.dbo.udf_interval_format(yourdatetimefield,2) > > > > > order by utility.dbo.udf_interval_format(yourdatetimefield,2) > > > > > > > > > > which would group data every 2 mins. > > > > > the output of the function is hh:mm > > > > > > > > > > Here is the function > > > > > > > > > > CREATE FUNCTION udf_interval_format(@dt datetime,@interval int) > > > > > RETURNS varchar(5) AS > > > > > BEGIN > > > > > DECLARE @pieces int > > > > > DECLARE @st varchar(5) > > > > > DECLARE @hourpart int > > > > > DECLARE @minpart int > > > > > set @pieces = (60*datepart(hour,@dt) >+datepart(mi,@dt) )/@interval > > > > > set @hourpart= @pieces*@interval/60 > > > > > set @minpart =@pieces*@interval - @hourpart*60 > > > > > set @st= right('00'+cast(@hourpart as > > > > > varchar),2)+':'+right('00'+cast(@minpart as varchar),2) > > > > > return @st > > > > > END > > > > > > > > > > > > > > > > > > > > - Original Message - > > > > > From: "Neil H." <[EMAIL PROTECTED]> > > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > > Sent: Friday, January 11, 2002 3:54 PM > > > > > Subject: Times... > > > > > > > > > > > > > > > > Here is a SQL question for yall... > > > > > > > > > > > > I have about 3000 rows a day which have a datetime column. I want > > to > > > be > > > > > > able to graph the number of rows every 2 minutes. I know it could > > be > > > > done > > > > > > with a lot of looping in CF but what is the best way to tackle > this > > > one? > > > > > > > > > > > > Thanks, > > > > > > > > > > > > Neil > > > > > > > > > > > > > > > > > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Using RegularExpressions
Try new = ReReplaceNoCase(old, 'a href="([a-z0-9])', 'a href="../\1', 'all'); HTH Dick At 12:32 PM +0100 1/12/02, SID - ColdFusion wrote: >Hi there, > >I have a weird task to solve. I hope someone of you guys out there can >gimme a hint. >For a redesign of a customers site I have to replace links in >source-code of the original pages to fit into the redesign. The >problem is that those original sites (and their source) are messed up >like hell. >'Cause there are about 250 pages to modify I tried Studios Extended >Search-and-Replace-function to search for those links and replace them >with another via RegExpression because only '' have to be adjusted to 'letters]...">' >There are already other links on those pages that already begin with >'' and so have not to be modified. >My problem with regExp is that it drops the first letter of the actual >link being modified 'cuz I let him/it(?) search for all href's >starting with a letter. So it ends up with (if the link was 'abc.html') >''. So he dropped the 'a'. > >Are there any suggestions on how to use regExp for this? > >Help would be really appreciated... > > > >Patric Stumpe >mail: [EMAIL PROTECTED] > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Using RegularExpressions
Hi there, I have a weird task to solve. I hope someone of you guys out there can gimme a hint. For a redesign of a customers site I have to replace links in source-code of the original pages to fit into the redesign. The problem is that those original sites (and their source) are messed up like hell. 'Cause there are about 250 pages to modify I tried Studios Extended Search-and-Replace-function to search for those links and replace them with another via RegExpression because only '' have to be adjusted to 'letters]...">' There are already other links on those pages that already begin with '' and so have not to be modified. My problem with regExp is that it drops the first letter of the actual link being modified 'cuz I let him/it(?) search for all href's starting with a letter. So it ends up with (if the link was 'abc.html') ''. So he dropped the 'a'. Are there any suggestions on how to use regExp for this? Help would be really appreciated... Patric Stumpe mail: [EMAIL PROTECTED] __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: hair-tearing Jet SQL problem!
In my experience Access via ODBC to CF does not support the DEFAULT clause in CREATE or ALTER table statements. Don't know about an OLEDB connection (I do know OLEDB to Access creates a whole new set of probs eg ODBC date & time formats are not supported). Joseph Thompson wrote: > > I can't wait to see if there is a solution here. I have come up against > this problem again and again. > > I have been able to read the field types with ADO but... modifying those has > been a little mystifying. > I got about this far and then gave up on it. > http://cfhub.com/advanced/ado/ > > > I was reading through the Jet SQL (for Access 2000) > > documentation, and noticed this: > > > > "Note: The DEFAULT statement can be executed only > > through the Jet OLE DB provider and ADO. It will return an > > error message if used through the Access SQL View user > > interface." > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Build your own
CFX_IMAGE does simple graphs "Rick Osborne [Mojo]" wrote: > > Ron Anderson asked: > > Has anyone reached the point of frustration with CFGraph, > > where they've just built their own? > > I did, but I did it in Perl with the GD module. > > http://www.rickosborne.org/<-- Look at the Insomniograph for an example > > I've got a coworker here who says his friend built a Flash version. Email > me off-list if you want to know more about either. > > -R > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Auto Form Generator
I did a generator that I built into a $$$ app I wrote called ContentMonger Pro. Isn't dedicated to forms generation, but is a feature of the system. Supports text, checkbox, select, textarea, radio and hidden form fields. Processes submitted form data as well as allowing their creation via no-coding web interface. $175 for the whole system, or $150 if you find it on Ebay ;D http://foohbar.org/contentmonger/pro --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: sam komolafe [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 6:43 PM To: CF-Talk Subject: Auto Form Generator Hi guys, Is there a tool or custom tag I can use to automatically generate different kinds of form fields and labels to go with those fields. My users want the ability to create different kinds of questionniare templates. Thanks sam __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Passing variables through a URL
Hi, I know it's late but I have a newbie question for anyone awake. I am trying to make a text link that would sort records from a query. I would like to pass the parameter through the URL that says which column to sort by but can't figure out how. This brings up another question, am I using SQL/CFML properly to sort records on the fly. If you could tell me how to pass the url variable that would be wonderful! Here is my code so far: SELECT * FROM Table1 ORDER BY #orderBy# Vehicle Type Year Manufacturer Description #vehicleType# #modelYear# #manufacturerName# #vehicleDescription# Please be critical if there are better ways to do things. This is my first CFM page ever. __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists