RE: Storing Credit Card Info

2003-06-17 Thread Sicular, Alexander
Isaac, I think this book has been recommended here before... 'Translucent Databases' by Peter Wayner. It deals with all sorts of database/encryption issues. Gl, alex -Original Message- From: Issac Rosa [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 7:02 PM To: CF-Talk Subject:

RE: Storing Credit Card Info

2003-06-17 Thread Tilbrook, Peter
If that link doesn't work go to: http://www.perthweb.com.au/ And click on Developer. == Peter Tilbrook Internet Applications Developer Australian Building Codes Board GPO Box 9839 CANBERRA ACT 2601 AUSTRALIA WWW: http://www.abcb.gov.au/ E-Mail: [EMAIL PROTECTED] Telephone: +61 (02) 621

Re: CFMX UUID Length

2003-06-17 Thread Dave Carabetta
> the prefix is the old-style (random number) CFTOKEN which gets prepended to > the UUID to form the complete new-style CFTOKEN. Not sure why, but that's > the way it works. Might be to allow old-style clients to connect to a > server after it was changed to use the new-style CFTOKEN, but I don't

Re: CFMX UUID Length

2003-06-17 Thread Dave Carabetta
> You could create a udf that strips the extra characters. > Sure, but my point was more just to try and figure out why there was a need for it. As far as I'm concerned, my CDATA and CGLOBAL tables both have CFID columns large enough to store either 35 or 52 character UUID values (with the CFID, o

Re: Empty cfid and cftoken - is this common? The answer

2003-06-17 Thread Bud
>Interesting that your observations yielded that conclusion. I had a similar >problem where a bit of code was deleting the CFTOKEN cookie. In CF 4.5, no >big deal, a new CFID/CFTOKEN is generated because it can't find the >CFID:CFTOKEN pair in the database (i.e., 123:[blank]). In MX, I get a Null >

Re: CFMX UUID Length

2003-06-17 Thread Kwang Suh
You could create a udf that strips the extra characters. - Original Message - From: "Dave Carabetta" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 4:11 PM Subject: RE: CFMX UUID Length > >Pete Freitag has got something related to this on his blog (Ju

Re: Empty cfid and cftoken - is this common? The answer

2003-06-17 Thread Dave Carabetta
> OK, I found an answer to this problem. It is yet just one more > unnecessary behavioral change in MX from presvious versions. > > In my shopping cart application, when I want to delete the client > cookies, I do it manually before the cfapplication tag: > > > > > This has worked great since Col

Re: CF MX Q of Q error....

2003-06-17 Thread Bryan Stevenson
Hey Buddy, I don't have an answer for you, but I've had (and alot of others apparently) issues with QofQs and MX. It tends to whine about datatypes when there is nothing to whine about. Seacrh the list archives on MX and QofQs as some folks have previously posted workarounds. Ultimately I had t

RE: CF MX Q of Q error....

2003-06-17 Thread Matthew Walker
I'd guess it was the where section. Try commenting out and see if it works. Is TDate a datetime column? Try getting rid of the dateFormat() functions. IMO these are presentation functions that should only ever be used when you want to display your data in a human-friendly form. TDATE> '#DateForma

CF MX Q of Q error....

2003-06-17 Thread Buddy
I just upgraded a box to cfmx and now I am debugging the code. I am getting this error on code that worked well in cf5: Error Executing Database Query. Query Of Queries runtime error. Unsupported type comparison. 227 : 228 : Select RAW as TRaw from SelectWMDATA WHERE TDATE> '#DateFormat(LO

Re: Web-based telnet client?

2003-06-17 Thread Kym Kovan
Hi Jim, >The devices are remote power/reboot controllers for colocated servers. I'm >also writing a monitoring application and may incorporate the ability to >automate a power cycling for servers and equipment that won't respond to any >other type of reset. In that case a non-interactive telnet

Re: Storing Credit Card Info

2003-06-17 Thread Matt Robertson
Holy cow... thats a very scary prospect. Obviously an SSL connection is the first step. Then... Encrypt the data. Don't rely on either CF or mySQL's encryption if you can all possibly avoid it. My personal favorite encryption method is cfx_textcrypt from http://perthweb.developer.com.au but

deleting log files

2003-06-17 Thread Owens, Howard
I've created a log file via CFLog. It's in the CFusionMX\logs folder. Daily, I have a template that reads it and e-mails the content to some people. I then want to delete it. CFFile won't delete it. I can't even delete it by hand (another process is using it). I can only delete it via the C

Re: Empty cfid and cftoken - is this common? The answer

2003-06-17 Thread Bud
OK, I found an answer to this problem. It is yet just one more unnecessary behavioral change in MX from presvious versions. In my shopping cart application, when I want to delete the client cookies, I do it manually before the cfapplication tag: This has worked great since ColdFusion 4.0 thr

Storing Credit Card Info

2003-06-17 Thread Issac Rosa
My client has a need to store credit card. What's the best, cost effective, most secure way of doing this? Is it just better to capture the information in the db and then download to a local db, and keep off the server? I'm curious to know what others are doing in this situation. Currently, the

RE: CFMX UUID Length

2003-06-17 Thread Barney Boisvert
the prefix is the old-style (random number) CFTOKEN which gets prepended to the UUID to form the complete new-style CFTOKEN. Not sure why, but that's the way it works. Might be to allow old-style clients to connect to a server after it was changed to use the new-style CFTOKEN, but I don't know.

RE: CFMX UUID Length

2003-06-17 Thread Dave Carabetta
>Pete Freitag has got something related to this on his blog (June 17th >entry): > >http://cfm.blogspot.com/ > Thanks for that. Does anybody know why there's a 17-character prefix to the UUID? If the UUID algorithm is based on time down to the milliseconds (which is what I remember reading somewh

Re: Dreamweaver MX -- grayed out component tab

2003-06-17 Thread Jamie Jackson
Okay, I'm further along now, with your help, but still not there... I no longer have a grayed out component tab, but I have no components, though there are several defined. When I try to refresh components, I get: -- The packages

RE: CFMX UUID Length

2003-06-17 Thread Ryan Kime
Pete Freitag has got something related to this on his blog (June 17th entry): http://cfm.blogspot.com/ -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 4:39 PM To: CF-Talk Subject: CFMX UUID Length In versions of ColdFusion previous to MX

CFMX UUID Length

2003-06-17 Thread Dave Carabetta
In versions of ColdFusion previous to MX, the length of a UUID using the CreateUUID() function was always 35 characters long. However, I'm finding that in MX for JRun with Updater 3, the CreateUUID() function is returning values with a length of 52. It's not the end of the world, but it does for

REPOST: CFMX, CFGRID and CFGRIDUPDATE errors

2003-06-17 Thread Justin Mundy
Date: 06/16/2003 07:10 PM Author: Justin Mundy Short Link: http://www.houseoffusion.com/lists.cfm?link=m:4:24867:125068 Hello, I am looking for some assistance with patching up a CFMX Server on a Windows 2000 platform, that has had CFMX Updater 3 run against it. I am trying to patch the server

Re:_Recurring_Billing_Systems

2003-06-17 Thread Peter Mayer
Hello! Worldpay offers something that might fullfill your needs: http://www.worldpay.com/usa/products_services/billing.shtml Best regards, Peter Originale Nachricht Von: "Duane Boudreau" Betreff: Recurring Billing Systems Datum/Zeit: Dienstag, 17. Juni 2003 20:29:07 > Hi All, >

Abort long running requests

2003-06-17 Thread Peter Mayer
Hello! For a quite long period of time, coldfusion MX (+Updater three) has been using a lot of CPU resources on our server - the top command shows the following data: CPU: 50.4% running: 702:32 task name: cfusion The whole server is working properly (also coldfusion is serving pages as expect

How to share J2EE session with CF MX template? - Continued

2003-06-17 Thread Steve
Andre and Sean, thank you very much for your prompt reply and helpful pointers. Both examples are very helpful. However, it has not worked yet. Andre, I followed your example, In your JSP/Servlet (Map) session.getAttribute("yourCFApplicationName").put("foo","bar"); And then you can acce

Re: xpath sum

2003-06-17 Thread jon hall
Tuesday, June 17, 2003, 3:21:00 PM, you wrote: MF> "jon hall" <[EMAIL PROTECTED]> wrote in message MF> news:[EMAIL PROTECTED] >> This is the error I get. >> >> Can not convert #NUMBER to a NodeList! >> MF> Unfortunately xmlSearch() only accept XPath expressions that return a MF> NodeList, it throws

People, I need your opinion!

2003-06-17 Thread LI, Chunshen \(Don\)
Hello all, I have a little toy that I designed and developed within last few days (on and off, so, it's hours). I had some assumptions. Mainly data entry and data update types of data manipulation functions is essential to many businesses. So, if my assumption has some validity, some CF shops c

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
Jillian Your a god damn star!! Thank you. Problem is solved. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 21:22 To: CF-Talk Subject: RE: Data getting truncated on select In CFMX. -- Jillian > -Original Message- > From: John McCosker [

RE: Application Security in MX

2003-06-17 Thread Raymond Camden
No, imagine you have N applications, but there are all part of uberapp. You would use "uberapp" as your applicationtoken. As for examples, I _believe_ I have a presentation you can download. Check my blog then my main web site. =

RE: Data getting truncated on select

2003-06-17 Thread Jillian Carroll
In CFMX. -- Jillian > -Original Message- > From: John McCosker [mailto:[EMAIL PROTECTED] > Sent: June 17, 2003 1:53 PM > To: CF-Talk > Subject: RE: Data getting truncated on select > > > >>- Have you double checked that in the administrator you > have long text > >>return enabled?

The washup (long): (was: Update on the Installer "Freeze" & Failure to Auto-Start on W indows Issues...)

2003-06-17 Thread Mike Kear
Regular listers will no doubt recall the 'discussion' (to use the mildest word I can find) not so long ago about my hosting company who was having difficulty installing Updater3 on the CFMX server that houses many of my own sites and client sites. (For those that don't, a quick recap - read the ar

RE: OT: printer friendly page break?

2003-06-17 Thread Mark A. Kruger - CFG
Thanks guys -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 9:10 AM To: CF-Talk Subject: Re: OT: printer friendly page break? http://www.javascriptkit.com/dhtmltutors/pagebreak.shtml I was just doing somethign similar a few minutes

Re: Move ColdFusion 5 to new server

2003-06-17 Thread Bryan Stevenson
Run Forest RUN! ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com -

RE: OT: printer friendly page break?

2003-06-17 Thread Philip Arnold
> > Is there an easy way to force a page break at certain sections? > > Use the CSS page-break-before and page-break-after options. Just remember that this is only applicable to the newer browsers, it's a CSS implementation that isn't completely there for any of the early versions of IE or NS that

RE: Application Security in MX

2003-06-17 Thread Robert Shaw
Thanks! Do you have an example? I don't see one in the documentation. Is it as simple as applicationtoken=app1,app2? Thanks again, Rob -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 3:54 PM To: CF-Talk Subject: RE: Application Security in M

Re: Move ColdFusion 5 to new server

2003-06-17 Thread Phillip B
I should have mentioned that I don't have physical access to the servers unfortunately. They are about 300 miles from my desk. Phillip B. www.LoungeRoyale.com www.FillWorks.com - Original Message - From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
>>- Have you double checked that in the administrator you have long text >>return enabled? Without that checked of course, it will only return 64,000 >>characters / whatever value is specified in the text box below. Adminstrative settings in MSSQL or CFMX? -Original Message- From: Ji

RE: Application Security in MX

2003-06-17 Thread Raymond Camden
Use the ApplicationToken attribute for CFLOGIN. This allows you to share them. === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacrom

how to share servlet's session with Cold Fusion MX template?

2003-06-17 Thread Steven Xu
Andre and Sean, thanks for your prompt reply and help. Both examples/pointers are very helpful! I tried both, however, it has not worked yet. Andre, I followed your code example, In your JSP/Servlet (Map) session.getAttribute("yourCFApplicationName").put("foo","bar"); And then you can acc

App Migration CF5 -> CFMX

2003-06-17 Thread Jeff Chastain
I have inherited an application that was designed using CF5 and I have to migrate it to CFMX. The application uses URLs like http://domain/view.cfm/U1 >From what I can tell, CF5 stopped at the view.cfm page call and processed that part of the URL. The view.cfm file then knew how to parse the

RE: Move ColdFusion 5 to new server

2003-06-17 Thread Pete Freitag
I'm not sure about IIS, but its fairly easy to backup your CF settings You can backup the datasources pretty easily, see my blog post: http://cfm.blogspot.com/2003_03_01_cfm_archive.html#90935000 You can also backup all the ColdFusion settings by just backing up this registry key: HKEY_LOCAL_MACH

RE: Data getting truncated on select

2003-06-17 Thread Jillian Carroll
I see that you may have an answer to your problem from another fellow, but a few suggestions (my problems were with PostgreSQL and MySQL): - Have you double checked that in the administrator you have long text return enabled? Without that checked of course, it will only return 64,000 charac

Re: Move ColdFusion 5 to new server

2003-06-17 Thread Bryan Stevenson
Make an image of the exisiting server (Ghost) and you can have the new one up and running in a heartbeat Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] -

Application Security in MX

2003-06-17 Thread Robert Shaw
I'm reviewing the articles on-line regarding CFMX's new security model and it appears the cflogin tag is application specific. We need to have a single login be shared by many applications. What would be the best way to set this up in MX? TIA, Rob __

Move ColdFusion 5 to new server

2003-06-17 Thread Phillip B
I need to move all my web sites and ColdFusion 5 to a new server. Is there an easy way to copy all the settings in IIS, datasources, and ColdFusion or will I need to set everything up from scratch? The current server and the new one are both Win2k.I don't have a lot of time to make the move so

Re: Web-based telnet client?

2003-06-17 Thread Jim McAtee
Now that I think about it, you're probably right. For interactive sessions, anyway. The devices are remote power/reboot controllers for colocated servers. I'm also writing a monitoring application and may incorporate the ability to automate a power cycling for servers and equipment that won't re

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
Yep using CFMX, the text strings are very big, pure html. >>Perhaps you are having >>the same issue. How did you get round this Bryan? -Original Message- From: Bryan Love [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:56 To: CF-Talk Subject: RE: Data getting truncated on select Are

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
Yea I understand the problem you had, but I im not using VARCHAR, but TEXT which is fixed at 16 and has max characters of 2,147,483,647 characters. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:23 To: CF-Talk Subject: RE: Data getting truncated on se

RE: Data getting truncated on select

2003-06-17 Thread Jerry Johnson
How big is this text object that is getting truncated? is it near 32K or 64K in size? What version of CF? What connectiontype are you using for that data source (ODBC or Native drivers)? Jerry Johnson >>> [EMAIL PROTECTED] 06/17/03 02:22PM >>> Last time something like that happened to me I real

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
File is averaging 264 k in size, Using CFMX and ODBC. -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 19:31 To: CF-Talk Subject: RE: Data getting truncated on select How big is this text object that is getting truncated? is it near 32K or 64K in size?

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
Using sql server 7. -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 20:14 To: CF-Talk Subject: RE: Data getting truncated on select John, I have had this problem more than once. Which DBMS are you using? -- Jillian > -Original Message- >

Re: xpath sum

2003-06-17 Thread Massimo, Tiziana e Federica
"jon hall" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > This is the error I get. > > Can not convert #NUMBER to a NodeList! > Unfortunately xmlSearch() only accept XPath expressions that return a NodeList, it throws an error in case the expression returns a string or a number. It's

Re: xpath sum

2003-06-17 Thread Massimo Foti
"jon hall" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > This is the error I get. > > Can not convert #NUMBER to a NodeList! > Unfortunately xmlSearch() only accept XPath expressions that return a NodeList, it throws an error in case the expression returns a string or a number. It's

RE: Data getting truncated on select

2003-06-17 Thread Jillian Carroll
John, I have had this problem more than once. Which DBMS are you using? -- Jillian > -Original Message- > From: John McCosker [mailto:[EMAIL PROTECTED] > Sent: June 17, 2003 12:33 PM > To: CF-Talk > Subject: RE: Data getting truncated on select > > > Yea I understand the problem you

Re: Web-based telnet client?

2003-06-17 Thread CF Dude
Back in the 4.5 days I thought about using CFFILE to run telnet commands. Is this still a possibility? E - Original Message - From: "Jim McAtee" <[EMAIL PROTECTED]> Has anyone here implemented or heard of a telnet client written in CF (v5 or earlier)? I've got some telnet controlled

RE: Data getting truncated on select

2003-06-17 Thread Bryan Love
Are you using CFMX? I've had that problem using WDDX packets in client vars that are stored in the DB because the Java type that CFMX uses is/was (fixed yet? dunno) not large enough to handle the string. Perhaps you are having the same issue. +---+ Br

xpath sum

2003-06-17 Thread jon hall
I've get an xml packet that returns qty available per warehouse, and I want to add up all of the qty's and return a total, but I am getting a crash when I try and use the sum in the xpath statement. The xml looks like this. MIAMI, FL 9642 NORCROSS, GA 7475

RE: Accessing fragment ID from URL?

2003-06-17 Thread Dave Watts
> > I just did a quick test and notice the anchor parameter > > isn't available to CF at all, which suggests to me that > > it is clientside. > > It may not be available from CF, but it's certainly available > in the call to the webserver, before the request is passed to > CF. Perhaps someone a

Odd CFFTP file/dir path issues

2003-06-17 Thread Scott Weikert
I've got two servers that, when deleting a folder and its contents from one, I want to be able to delete that same folder/contents on the other. At any given point, I know which server the code is running on, and can connect to the other server fine via CFFTP. I can also do a directory listing

Re: Accessing fragment ID from URL?

2003-06-17 Thread Howard Fore
On Tuesday, Jun 17, 2003, at 12:12 US/Eastern, Dave Wilson wrote: > I just did a quick test and notice the anchor parameter isn't > available to > CF at all, which suggests to me that it is clientside. It may not be available from CF, but it's certainly available in the call to the webserver, be

Changing a session timeout based on login

2003-06-17 Thread James Johnson
Hello, Searched through the archives but couldn't find the answer. Is there a way to dynamically change a SESSION's timeout property in Application.cfm based on a user's login? For example, a "general" user has a 20 minute timeout, while an "admin" user has a 3 hour timeout. Thanks, James

RE: Web-based telnet client?

2003-06-17 Thread cfhelp
TSt10 is a script for telnet that is very easy to use. Just create the script commands with CF and use CFEXECUTE. You can download it from me http://www.kchost.net/tst10.zip Rick Eidson -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 12:04 PM

RE: Data getting truncated on select

2003-06-17 Thread Janine Jakim
Last time something like that happened to me I realized that in the stored proc I put in the wrong number of characters id: @MacroName VARCHAR(50) instead of @MacroName VARCHAR(500) -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 1:51 PM To: C

Re: Web-based telnet client?

2003-06-17 Thread Michael T. Tangorre
What about using cfexecute? Just an idea... not sure how you can pipe input and output inti it. - Original Message - From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 1:03 PM Subject: Web-based telnet client? > Has anyone here impleme

RE: Web-based telnet client?

2003-06-17 Thread Costas Piliotis
I think you're looking at the wrong technology imho... You can probably just find an ActiveX control or an Applet that'll do that... Probably don't need to use ColdFusion... Maybe some javascript with the applet or some vbscript with the activex control... A quick search on google gets you thi

Web-based telnet client?

2003-06-17 Thread Jim McAtee
Has anyone here implemented or heard of a telnet client written in CF (v5 or earlier)? I've got some telnet controlled devices that I'd like to create a web-based interface for. I'm thinking of perhaps emulating a telnet client, with text screen output and throw in a few buttons and controls for

Re: Dreamweaver MX -- grayed out component tab

2003-06-17 Thread Jamie Jackson
On Fri, 13 Jun 2003 22:12:11 -0400, in cf-talk you wrote: >And is that a CF site? Yes >That's important, and you have to have set up the >site correctly (configured a testing server pointing to a CF server). As far as I know, this is set up. However, from the beginning, I've suspected that it's

Blue dragon installation issues

2003-06-17 Thread Damon Cooper
>I'll make sure someone takes a look at it today. And, no, we don't need your credit >card number. ;-) No credit card required from Macromedia either, for installation issues. For anyone experiencing CF product installation issues, the mechanism to use for "installation issues" (as defined on

RE: Accessing fragment ID from URL?

2003-06-17 Thread Jim Davis
If you just want to track clicks on a page with many inline anchors you can use the technique I've detailed here (it does require JavaScript be enabled): http://ww.depressedpress.com/DepressedPress/Content/ColdFusion/Essays/GI FAsPipe/Index.cfm Otherwise you may need to repeat your client-side an

Re: Dreamweaver MX -- grayed out component tab

2003-06-17 Thread Jamie Jackson
Yes, it's testCFC.cfc Thanks, Jamie On Fri, 13 Jun 2003 16:13:20 -0500, in cf-talk you wrote: >Have you saved the file as something.cfc yet, or is it still untitled? > >-Original Message- >From: Jamie Jackson [mailto:[EMAIL PROTECTED] >Sent: Friday, June 13, 2003 4:11 PM >To: CF-Talk >Su

OT: JXP Files

2003-06-17 Thread cfhelp
I have been talking with a client about moving his hosting over to my service. I just found out that he has jxp files. Is that some form of JSP? What do I need to run them on a Win2k server that already has CF5, PHP and PERL? Rick ~~

Re: OT: SQL problem

2003-06-17 Thread S . Isaac Dealey
Ahh, cool, thanks. :) > S. Isaac Dealey wrote: >>>SELECT CountryName, Value, Year >>>FROM table >>>WHERE >>> (CountryName, Year) IN ( >>> SELECT CountryName, MAX(Year) >>> FROM table >>> GROUP BY CountryName >>> ) >> >> >> Is that a sql92 s

RE: Accessing fragment ID from URL?

2003-06-17 Thread Dave Wilson
Hi, I just did a quick test and notice the anchor parameter isn't available to CF at all, which suggests to me that it is clientside. How about using a document.location call with javascript instead of cflocation? This should let you use location.hash (sorry my javascript is terrible). HTH, Dave

OT: SQL problem

2003-06-17 Thread Don Li
I like a simple solution. -- DDL, create table create table #tbl(CountryName varchar(24), [Value] int, [Year] char(4)); -- DML, populate data insert into #tbl(countryName,[Value],[Year]) values ('Sweden', 80, '1970'); insert into #tbl(countryName,[Value],[Year]) values('Sweden', 20, '1999'); in

Re: Accessing fragment ID from URL?

2003-06-17 Thread Howard Fore
Hmm. Isn't HTTP_REFERER actually the request for the previous page? If page A is requested with http://somehost.com/pageA.cfm?param1=foo#barA and has a link to http://somehost.com/pageB.cfm?param1=foo#barB when pageB.cfm executes, won't the HTTP_REFERER be http://some

Re: SQL float format

2003-06-17 Thread CF Dude
I'm not sure what you're looking to do, but have you tried setting the precision at all? float and real Approximate number data types for use with floating point numeric data. Floating point data is approximate; not all values in the data type range can be precisely represented. Syntax float [

Re: SQL float format

2003-06-17 Thread John Paul Ashenfelter
You can use CAST or CONVERT on the MS-SQL side, or better yet, use one of the ColdFusion formatting functions (NumberFormat, DecimalFormat, etc) to produce the exact output you're after. Regards, John Paul Ashenfelter CTO/TransitionPoint - Original Message - From: "Hugo Ahlenius" <[EMAIL

RE: Log files in MX

2003-06-17 Thread Stephenie Hamilton
Try LogMagic http://www.macromedia.com/cfusion/exchange/index.cfm?view=sn130#loc=en_u s&view=sn105&viewName=Exchange%20Search (watch for url wrap) Or use http://makeashorterlink.com/?F2B9534F4 ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original M

Re: How many tables per datasource?

2003-06-17 Thread John Paul Ashenfelter
- Original Message - From: "Blood Python" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 8:43 AM Subject: How many tables per datasource? > Hi, how's everyone doing? :) > > I never thought about it until today, when i was asked about it while > explai

RE: Accessing fragment ID from URL?

2003-06-17 Thread Dave Wilson
> On Tuesday, Jun 17, 2003, at 10:50 US/Eastern, Adrian Lynch wrote: > > > ListLast("http://somehost.com/pagename.cfm?param1=foo#bar";, "##") > > > > Not sure if there's a CGI var for this. > > Sorry, I should have been more clear. I'd like to be able to > detect the > fragment ID within the re

Log files in MX

2003-06-17 Thread Ciliotta, Mario
Hi, I was wondering if anyone knows of either a custom tag or might have some code that will allow me to read the log file from a CF-MX server. My company has decided that as programmers we have no access to the CF admin and they will mot turn on the Sandbox Security so that I can view them.

Re: CFMX Server Errors :(

2003-06-17 Thread Critz
oi Jochem!! yeah, i am using tcp/ip filtering. unfortunately, i cannot disable it to re-enable it... as I cannot get to that machine for a while :( weird though... like i said.it was all working fine at one time.then just died... Tuesda

Re: SOT: SQL Question - Could CF make this easier?

2003-06-17 Thread [EMAIL PROTECTED]
You can do it easier with SQL by using NOT IN ... WHERE Description NOT IN ('ANISE', 'APPLES',.) HTH Dick On Wednesday, June 11, 2003, at 11:37 AM, Jillian Carroll wrote: > I am creating a drop-down list of items, but I want to keep several > items > from appearing in the drop-down. >

Re: Accessing fragment ID from URL?

2003-06-17 Thread Howard Fore
On Tuesday, Jun 17, 2003, at 10:50 US/Eastern, Adrian Lynch wrote: > ListLast("http://somehost.com/pagename.cfm?param1=foo#bar";, "##") > > Not sure if there's a CGI var for this. Sorry, I should have been more clear. I'd like to be able to detect the fragment ID within the requested page. The p

RE: Accessing fragment ID from URL?

2003-06-17 Thread Adrian Lynch
ListLast("http://somehost.com/pagename.cfm?param1=foo#bar";, "##") Not sure if there's a CGI var for this. Ade -Original Message- From: Howard Fore [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 15:40 To: CF-Talk Subject: Accessing fragment ID from URL? Hi, Maybe I'm just missing it, bu

Accessing fragment ID from URL?

2003-06-17 Thread Howard Fore
Hi, Maybe I'm just missing it, but how do I access the value of a url's fragment id? That is, given a url of "http://somehost.com/pagename.cfm?param1=foo#bar"; how do I find "bar"? It's not in the CGI or URL scopes as far as I can see with CFDUMP. I was coding this in Javascript, I'd use locat

Re: OT: printer friendly page break?

2003-06-17 Thread Jochem van Dieten
Mark A. Kruger - CFG wrote: > > How about a short example? http://www.google.com/search?q=page-break-before%20example :-) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www

Re: How many tables per datasource?

2003-06-17 Thread Jochem van Dieten
Blood Python wrote: > > I never thought about it until today, when i was asked about it while > explaing a bit if mysql for a friend. Is there a rule or best pratice to > know when it's time to create another datasource? Maybe spliting 1 > datasource with many tables on 2 or 3 increases perform

Re: CFMX Server Errors :(

2003-06-17 Thread Jochem van Dieten
Critz wrote: > > os.name: Windows 2000 > os.version: 5.0 > os.arch: x86 > platform: intel-win > web server: IIS > File C:\CFusionMX\runtime\lib\wsconfig\jrunwin32.dll newer than JAR file C:\CFus > ionMX\runtime\lib\wsconfig.jar so not extracted > findServers(): attempting connect to port 2901 on h

Re: OT: printer friendly page break?

2003-06-17 Thread Michael T. Tangorre
http://www.javascriptkit.com/dhtmltutors/pagebreak.shtml I was just doing somethign similar a few minutes ago... Mike - Original Message - From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 10:07 AM Subject: RE: OT: printer f

RE: OT: printer friendly page break?

2003-06-17 Thread Bryan F. Hogan
Check out this link for implementation options. http://www.blooberry.com/indexdot/css/properties/print/pbbefore.htm -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2003 10:08 AM To: CF-Talk Subject: RE: OT: printer friendly page break? Joc

SQL float format

2003-06-17 Thread Hugo Ahlenius
Hi, I have values stored as "float" in an MSSQL2k table. If i store "55.5" as a value in this column, I sometimes get back "55.5000" (a lot of decimals). And sometimes "55" returns "55.0". (returns = cfquery) Any hints tips, references for some RTFM? /H. -

RE: OT: printer friendly page break?

2003-06-17 Thread Mark A. Kruger - CFG
Jochem, How about a short example? -mk -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 2:22 PM To: CF-Talk Subject: Re: OT: printer friendly page break? Janine Jakim wrote: > Is there an easy way to force a page break at certain sectio

RE: CFMX Server Errors :(

2003-06-17 Thread Stephenie Hamilton
Jrun has to be running, ie: check in your services and make sure CF Application Server is started. Then run the connector command again ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Critz [mailto:[EMAIL PROTECTED] Sent: Tuesd

RE: ASP equivalent to CF server variables?

2003-06-17 Thread Lofback, Chris
Thanks! That gets most of what I needed. Is there any way to get the server OS and OS version? Chris > -Original Message- > From: Scott Wilhelm [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 9:39 AM > To: CF-Talk > Subject: RE: ASP equivalent to CF server variables? > > > G

RE: Blue dragon installation issues

2003-06-17 Thread Vince Bonfanti
Hi Ryan, Can you forward an email describing your problem to "[EMAIL PROTECTED]" and attach the "bluedragon.log" file? You can find the log file in the following directory within your webapp: /WEB-INF/bluedragon/work/bluedragon.log I'll make sure someone takes a look at it today. And, no, we d

RE: ASP equivalent to CF server variables?

2003-06-17 Thread Scott Wilhelm
Give this a try. Might be more than you need, but I'm sure it won't hurt :) <[EMAIL PROTECTED]"VBScript"%> test <% On Error Resume Next Response.Write "All Variables : " & Now() & "" dim Header, Footer header = "" footer = "" Response.Write("cookies" & header) for each item in Request.Cooki

SOT: ASP equivalent to CF server variables?

2003-06-17 Thread Lofback, Chris
Well, I'm beating my brains out trying to find this on MSDN, but I'll bet this group knows... I need an ASP equivalent to CF's built-in server variables, like OS, OS Version, HTTP server, etc. How can I get that in ASP classic? ~~~

RE: MS AD

2003-06-17 Thread Shahzad.Butt
Domain Controller (in AD) -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 17 June 2003 12:04 To: CF-Talk Subject: RE: MS AD I would assume it stands for Data Connection" -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Se

Re: CFMX Server Errors :(

2003-06-17 Thread Critz
oi Critz!! I just tried to remove_all_connectors then reattach the iis one. I got an error when I did remove all... and when i tried to attach the IIS one it said: os.name: Windows 2000 os.version: 5.0 os.arch: x86 platform: intel-win web server: IIS File C:\CFusionMX\runtime\lib\wsconfig\jrunwi

RE: How many tables per datasource?

2003-06-17 Thread Adam Wayne Lehman
This is a very interesting question. I don't think there would be any performance benefits, although you could setup different datasources for security purposes or for reporting/tracking. Multiple datasources that access the same db, but use different logins for varied access rights. Assign a diffe

  1   2   >