RE: CFC and ColdfusionQueries

2003-12-08 Thread Andrew Scott
Here it is raymond, If you comment the case statement Dir out, it works fine, but it refuse to work with it in there. output="true">                 switch (type)    {     case 'File':  QueryAddRow(variables.filelist);  QuerySetCell(variables.filelist,'FileName',arguments.Dire

RE: weather feed

2003-12-08 Thread Todd Finney
At 01:18 AM 12/9/2003 -0500, you wrote: > I built my tag. jeeze, four years ago and the pages have never changed. I don't see any mention of it on the depressedpress.com site.  Can I take a look at your work? >I wouldn't hold my breath for XML.  ;^) Actually, according to my contacts at the NO

RE: CFC and ColdfusionQueries

2003-12-08 Thread Raymond Camden
Can you show us all of the code? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: weather feed

2003-12-08 Thread Jim Davis
No need to defend yourself - I parsed the exact same pages you did for my weather tag.  ;^) I was just addressing the wish for XML data.  The METAR format is the closest we'll get for a while - it's the only standardized, designed to be parsed data they offer right now.  The data you and I are p

RE: OT: MySQL and NULL values (was Re: Debugging CFQUERYPARAM)

2003-12-08 Thread Donnie Bachan
In addition: It really screws up dates where it enters a date equivalent to now()-now() if you don't specify a date in a field designated as NOT NULL. Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 "Nitendo Vinces - By Striving You Shall Conquer" [Todays Threads] [This Message] [Subscri

RE: MySQL Question

2003-12-08 Thread Donnie Bachan
Try this: SELECT event_id, title, city, state, zip, event_date FROM Event ev, ref_mma rm WHERE rm.area_id = 7 AND FIND_IN_SET(ev.zip, rm.zips) <> 0 AND active_ind = 1 AND private_ind = 0 The FIND_IN_SET function returns the index of the item (ev.zip) if it is found in the set of comma delimited

RE: weather feed

2003-12-08 Thread Todd Finney
At 11:41 PM 12/8/2003 -0500, you wrote: >They do offer a specialized parsable (tho' not XML) format called "METAR" >that may meet your needs - the trick is knowing where reporting stations >(usually airports) are. I've seen the METAR data.  It's not any easier to parse than the data I'm using.   

RE: Flash Instant Messenger Software?

2003-12-08 Thread Brian LeRoux
Theres a few options. First off, you need to understand flash is like any html element in that it sends a request and then the server sends a response. A chat application usually has at minimum two flash clients sending messages to eachother. One client essentially tells the server to send its mess

RE: weather feed

2003-12-08 Thread Jim Davis
They do offer a specialized parsable (tho' not XML) format called "METAR" that may meet your needs - the trick is knowing where reporting stations (usually airports) are. I looked into this heavily a few years ago but never bothered to create the parser - it may be easier know and there's sample

MySQL Question

2003-12-08 Thread Haggerty, Mike
I have a simple question regarding LIKE clauses in MySQL. I have a table that contains a comma-delimited list of zip codes. I have another table that contains addresses. I would like to pull all the records from the second table where the zip code is contained in the zip code field of the first

OT: MySQL and NULL values (was Re: Debugging CFQUERYPARAM)

2003-12-08 Thread Rick Root
Jochem van Dieten wrote: > Barney Boisvert wrote: >  > Where did you hear that one Jochem?  MySQL enforces NOT NULL just fine.   Jochem and Barney - you're both right.. and wrong, it seems. MySQL absolutely does enforce NOT NULL attributes.  You cannot insert a NULL value into a field specified

RE: Flash Instant Messenger Software?

2003-12-08 Thread Michael T. Tangorre
Have you checked out "Live Person"? http://www.liveperson.com/ Mike   _   From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 7:52 PM To: CF-Talk Subject: RE: Flash Instant Messenger Software? Hi John, Actually the intranet in question deals with financing.  Client

RE: Flash Instant Messenger Software?

2003-12-08 Thread cf-talk
Hi John, Actually the intranet in question deals with financing.  Clients log into the portal and submit their deals.  If they need help they click on the "Live Help" link and chat with a company representative.  Due to the nature of communications a "chat room" wouldn't work.  It needs to be a

Re: Flash Instant Messenger Software?

2003-12-08 Thread John Dowdell
At 12:43 PM 12/8/3, cf-talk wrote: > Does anyone know of some cheap/free "instant messenger" software > that  can embed in a ColdFusion intranet application? If it's page-based, on an intranet, then I'm assuming a chat app would work as well as an IM app...? (A chat is a place you go where you ca

RE: Do you apply tax after shipping costs?

2003-12-08 Thread J E VanOver
Which reinforces my thought that this is a question for your ACCOUNTANT. NOT for this mailing list.   -Original Message-   From: Dennis Powers [mailto:[EMAIL PROTECTED]   Sent: Monday, December 08, 2003 12:52 PM   To: CF-Talk   Subject: RE: Do you apply tax after shipping costs?   >> Do yo

RE: Flash Instant Messenger Software?

2003-12-08 Thread Miller, Kevin
Maybe you could share your solution.  ;-) Kevin -Original Message- From: cf-talk [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:03 PM To: CF-Talk Subject: RE: Flash Instant Messenger Software? Thanks... I filled out the registration form and will take a look... but an ASP

Re: ColdFusion and PostgreSql

2003-12-08 Thread Jochem van Dieten
Emma S wrote: > > Does anybody know how to call PostgreSql function from ColdFusion, if > that function returns result set using cursor? I don't think anybody knows (and if somebody does, please speak up). You will have to revert to a Set Returning Function: http://techdocs.postgresql.org/guide

RE: Flash Instant Messenger Software?

2003-12-08 Thread cf-talk
Thanks... I filled out the registration form and will take a look... but an ASP isn't exactly what I had in mind.  My needs are much more simple... a simple flash movie that sends/retrieves text from a database table. Looks like I'll probably just write one myself and get it over with.  I could

RE: Flash Instant Messenger Software?

2003-12-08 Thread cf
http://talkdesk.com/ > Hi Dan, > > Thanks for the input.  Yes, I know I could do that... but as I mentioned > in my post.  I don't really feel like reinventing the wheel.  I'm > looking for something already written and I can just "plug in" to my > existing intranet application. ;-) > > -Novak >

CFC and ColdfusionQueries

2003-12-08 Thread Andrew Scott
I am hoping someone might be able to help me here, I have a recursive cfc. Now when it is intialized I have variables.asQuery = QueryNew('Field1,Field2') Then inside a function that is recirsive I have QueryAddrow(variables.asQuery) with a querySetCell. Now if I don't recirse this evewryth

Re: The Value of CFQUERYPARAM

2003-12-08 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: > > I asked this question and quite a discussion broke out between the DB > heavyweights (Jochem and Adam I think) Thank you :-) > I've tried my best to find it in the archives but I can't for some > reason. http://www.houseoffusion.com/cf_lists/index.cfm?method=mes

Re:

2003-12-08 Thread Jochem van Dieten
Jochem van Dieten wrote: > Make sure you refer to issue #5230 when you fill out the report: #52305 Jochem -- When you don't want to be surprised by the revolution organize one yourself  - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

ColdFusion and PostgreSql

2003-12-08 Thread Emma S
Hi, Does anybody know how to call PostgreSql function from ColdFusion, if that function returns result set using cursor? Thank you. - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard [Todays Threads] [This Message] [Subscription] [Fast Un

RE: Simple log question...

2003-12-08 Thread Jim T
I have all the latest updates and patches on the system   -Original Message-   From: Dave Watts [mailto:[EMAIL PROTECTED]   Sent: Monday, December 08, 2003 4:18 PM   To: CF-Talk   Subject: RE: Simple log question...   > What are these entries in my log files?   > am I bing attacked?   Yes

Re:

2003-12-08 Thread Jochem van Dieten
Ian Skinner wrote: > I'm inserting varchar data into a Oracle 8i table using cfqueryparam.  For > some reason, if the data contains a single quote ('), the quote is being > doubled ('') when it is stored in the database.  Is this correct behavior? No. It is caused by a bug in CF where function ca

Re: Debugging CFQUERYPARAM

2003-12-08 Thread Jochem van Dieten
Barney Boisvert wrote: > Where did you hear that one Jochem?  MySQL enforces NOT NULL just fine.   > > mysql> create table test (id int not null); > Query OK, 0 rows affected (0.05 sec) > > mysql> insert into test (id) values (null); > ERROR 1048: Column 'id' cannot be null If no DEFAULT value

RE: Simple log question...

2003-12-08 Thread Dave Watts
> What are these entries in my log files? > am I bing attacked? Yes, you're being attacked. > If so how do I stop it .  I use IIS > >  /scripts/..%5c../winnt/system32/cmd.exe /c+dir 500 - >  /scripts/..%5c../winnt/system32/cmd.exe /c+dir 500 - >  /scripts/..%5c../winnt/system32/cmd.exe /c+dir 50

RE: Simple log question...

2003-12-08 Thread Dave Watts
> What are these entries in my log files? > am I bing attacked? Yes, you're being attacked. > If so how do I stop it .  I use IIS > >  /scripts/..%5c../winnt/system32/cmd.exe /c+dir 500 - >  /scripts/..%5c../winnt/system32/cmd.exe /c+dir 500 - >  /scripts/..%5c../winnt/system32/cmd.exe /c+dir 50

Re: CFTicket

2003-12-08 Thread Larry C. Lyons
Larry C. Lyons wrote: > stas wrote: > >> I am looking for a trouble-ticket/customer service type of application >> and >> found CFTicket on the Exchange; the developer is at >> http://www.cornfeed.com/ >> >> Has anyone implemented this solution and have good/bad comments about it? >> >> Thank yo

RE: Flash Instant Messenger Software?

2003-12-08 Thread Dan Farmer
hmmm, this is interesting you just gave me an idea.. I may design one for you. ( no promises though ). >From: "cf-talk" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Flash Instant Messenger Software? >Date: Mon, 8 Dec 2003 13:53:07 -0800 >MIME-V

cfqueryparam explained

2003-12-08 Thread David Collie
Oops, first time posting from the web page... didn't realise it wouldn't carry the subject over :-/ Should be in this thread The Value of CFQUERYPARAM http://www.houseoffusion.com/cf_lists/index.cfm/method=messages&threadid=29170&forumid=4 [Todays Threads] [This Message] [Subscripti

cfqueryparam explained

2003-12-08 Thread David Collie
Hi This is the post I was talking about if anyone is interested.   Its a good explaination of cfqueryparam and made me understand a wee bit more http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=24110&forumid=4 -- dc [ cf5, ora8.1.7, iis5 ] [Todays Threads] [This

RE: Application Modeling/Design/Diagramming

2003-12-08 Thread Simon Horwith
I use Enterprise Architect, an excellent UML tool that's really designed for Java developers more than anyone.  If you do Java development, it's fantastic, though.  For CF development alone, it's got a lot of features that you'll never use, but it's collaboration, use case, sequence, and other UML

Re: Simple log question...

2003-12-08 Thread Marlon Moyer
This looks like nimda or one of the many variants.  So yes, you are being attacked, but if you're patched up, it really shouldn't affect anything.  You could ban the ip at your firewall, but if there's a chance you'll ban valid traffic as well. marlon Jim T wrote: > What are these entries in

RE: Simple log question...

2003-12-08 Thread Jim T
What are these entries in my log files? am I bing attacked? If so how do I stop it .  I use IIS /scripts/..%5c../winnt/system32/cmd.exe /c+dir 500 - /scripts/..%5c../winnt/system32/cmd.exe /c+dir 500 - /scripts/..%5c../winnt/system32/cmd.exe /c+dir 500 - /scripts/..%2f../winnt/system32/cmd.exe

Re:CF & pda types of devices

2003-12-08 Thread Don
Good to know, thanks.  I'm kind of preparing myself for a project that requires tiny devices access but it's very early stage right now. Don >As others have said, if your handheld uses "real" browser that consumes >html, then you just use CF as normal. > >Some things to keep in mind are that IE o

Re:Fusebox - whats the big deal anyway?

2003-12-08 Thread Don
Mike, I appreciate your thoughts and I agree I or one would invest time in Fusebox once a big project which heavily involves FB in one way or another is imminent. Best regards, Don >I really think it depends on what sort of entity the web site is for and >what they want.  If you are dealing wi

RE: I Hate QoQ

2003-12-08 Thread Barney Boisvert
Did you double check (CFDUMP) that all the values are numeric and/or string? CF recordsets aren't strongly typed, but the comparisons are.  Most of the problems I've had are because one field in one record has an ambigious type, and it screws everything up.  Also, I'm not sure passing '1' is going

Re: Application Modeling/Design/Diagramming

2003-12-08 Thread Rizal Firmansyah
Mostly i use PowerDesigner for designing big system. But sometimes i use Visio for medium size application. Rizal At 03:39 AM 12/9/2003, you wrote: >Hello everyone, > >I wanted to get some idea of what everyone uses to layout an application >prior to building it. I'm trying to improve my skills

RE: I Hate QoQ

2003-12-08 Thread Stacy Young
Column is numeric? Try it with a cfqueryparam and set to varchar and see if it works... Stace   _   From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple QoQ won't work?   

RE: I Hate QoQ

2003-12-08 Thread Robert Segal
Problem is that you are querying the query you are creating (name="involved" and you're selecting from involved). -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, 08 December, 2003 4:55 PM To: CF-Talk Subject: I Hate QoQ So any idea why this very simple

Re: I Hate QoQ

2003-12-08 Thread Bryan Stevenson
and you're absolutely sure that the query you are querying returns a 1 or 0 for isPrivate (show us the dump of the first query)?  Could isPrivate ever be NULL? Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] ---

RE: I Hate QoQ

2003-12-08 Thread Tony Weeg
whats a cfdump of the original query return? ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Adam Wayne Lehman [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:55 PM To: CF-Talk Subject

RE: Flash Instant Messenger Software?

2003-12-08 Thread cf-talk
Hi Dan, Thanks for the input.  Yes, I know I could do that... but as I mentioned in my post.  I don't really feel like reinventing the wheel.  I'm looking for something already written and I can just "plug in" to my existing intranet application. ;-) -Novak -Original Message- From: D

RE: Simple question...

2003-12-08 Thread Venable, John
That's true, but he's using cfdump, not sure he wanted to use them at all :-) John -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:38 PM To: CF-Talk Subject: Re: Simple question... Beware dumping the URL scope...rememberyou may h

I Hate QoQ

2003-12-08 Thread Adam Wayne Lehman
So any idea why this very simple QoQ won't work? SELECT isPublic FROM involved WHERE isPublic = 1 isPublic is a valid column name, and the values are either 0 or 1. This is the error I get: Query Of Queries runti

Re: SQL col type

2003-12-08 Thread Mickael
Hi I don't really have that skill set, is that the only way to do this?   - Original Message -   From: Nick de Voil   To: CF-Talk   Sent: Monday, December 08, 2003 3:07 PM   Subject: Re: SQL col type   > I don't know if this is possible or not but I thought I would ask.  I am   using Ac

RE: Whats the easiest way to calculate response times of all obje cts on a web page?

2003-12-08 Thread Dave Watts
> I'm testing a page that has some _javascript_s which pull various > objects from several servers. I know one of them is slow but I'm > looking to find the easiest way to request a URL and get a spreadsheet > with graphs or something showing me what GET requests are taking the > longest amount

Re: Simple question...

2003-12-08 Thread Bryan Stevenson
Beware dumping the URL scope...rememberyou may have set other vars in the URL scope (for whatever reason) before dumping the URL scope.  If you're after the passed params to the page CGI.QUERY_STRING as I first mentioned...be accurate ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Comm

RE: Getting 2 first lines from textarea formatted field

2003-12-08 Thread Spectrum WebDesign
Excellent... Great job... formStripHTML() from CFLIB.org Thanx again - Original Message - From: "cf-talk" <[EMAIL PROTECTED]> Date: Mon, 8 Dec 2003 12:48:34 -0800 To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: Getting 2 first lines from textarea formatted field Take a look at ColdFusion fun

RE: Simple question...

2003-12-08 Thread Che Vilnonis
that is what I thought...thanks for re-asssuring me,   -Original Message-   From: Phillip B. [mailto:[EMAIL PROTECTED]   Sent: Monday, December 08, 2003 4:21 PM   To: CF-Talk   Subject: Re: Simple question...   You should be able to use If anything is there it   will dump it. If not then

Re:How to add attribute to element in xml object?

2003-12-08 Thread Avi Flax
Chris, Thanks! That worked perfectly! I wish I had thought of that! Here's some sample code: >I honestly don't know whether this will work in CF or not, but have you >tried: >xmlPeople.xmlRoot.xmlChildren[1].xmlAttributes.personid = 34442 > >that's the way they be doin it over in actionscript

RE: Simple question...

2003-12-08 Thread Venable, John
    I think that's it. John Venable -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:12 PM To: CF-Talk Subject: Simple question... In CF5, how would I write: IF there is any variable in the URL scope present... then the entire URL

Re: Simple question...

2003-12-08 Thread Phillip B.
You should be able to use If anything is there it will dump it. If not then nothing gets output. -- Phillip B. Che Vilnonis wrote: > In CF5, how would I write: > > IF there is any variable in the URL scope present... > then the entire URL scope. > > I know you can use isdefined("FORM.FIELDNA

Re: Simple question...

2003-12-08 Thread Bryan Stevenson
   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

Simple question...

2003-12-08 Thread Che Vilnonis
In CF5, how would I write: IF there is any variable in the URL scope present... then the entire URL scope. I know you can use isdefined("FORM.FIELDNAMES") for form vars... but what is the magic phrase for all url vars??? Thanks, Che [Todays Threads] [This Message] [Subscription] [Fast Un

RE: Application Modeling/Design/Diagramming

2003-12-08 Thread Venable, John
I have Visio Pro (same thing?) and have been trying to learn it more, but there's a bunch of different types of digrams under software, which one do you use? I know a bit about UML and modelling objects, I guess I'm just not sure how to apply that to CF apps (other than the CFC parts). John ---

RE: Do you apply tax after shipping costs?

2003-12-08 Thread Schuster, Steven
Dennis is correct. I would suggest you get in contact with a local SBA or State agency to help you determine applicable tax laws for shipping, etc. Also, certain goods may or may not be taxable as well. Steve -Original Message- From: Dennis Powers [mailto:[EMAIL PROTECTED] Sent: Mond

RE: Application Modeling/Design/Diagramming

2003-12-08 Thread Michael Wilson
Hi, I use a "version" of the Fusebox Lifecycle Process (FLiP). Even if you don't use Fusebox, understanding the basic procedures of FLiP are helpful in establishing your own methodology and in avoiding "coding yourself into a corner" :). http://www.fusebox.org/index.cfm?&fuseaction=methodology.ste

Re: I could use a JS expert right now.

2003-12-08 Thread Scott Brady
Che Vilnonis wrote: > i don't believe action is a reserved word. "action" is a reserved word for form fields, because you can reference the "action" value (as in field named "action" can cause problems. (Even if you remove the "action" attribute from the form tag, I believe the form still has

RE: Application Modeling/Design/Diagramming

2003-12-08 Thread Schuster, Steven
I use VISIO Enterprise Architect but that's mostly because I do .NET and CF and the .NET is so easy in VISIO. CF is pretty easy as well using VISIO. It also supports UML and other things that I need. Steve -Original Message- From: Venable, John [mailto:[EMAIL PROTECTED] Sent: Monday, D

RE: Do you apply tax after shipping costs?

2003-12-08 Thread Dennis Powers
>> Do you apply applicable taxes before or after the shipping costs? >> right cuz you pay taxes on goods, not services. Taxes are determined state by state.  In Connecticut you pay taxes on the Product + shipping cost. Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company

RE: Flash Instant Messenger Software?

2003-12-08 Thread Dan Farmer
you could create your own messaging app, writing to the application or session variables... >From: "cf-talk" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Flash Instant Messenger Software? >Date: Mon, 8 Dec 2003 12:43:05 -0800 >MIME-Version: 1.0 >Rece

RE: Getting 2 first lines from textarea formatted field

2003-12-08 Thread cf-talk
Take a look at ColdFusion functions... you can use HTMLCodeFormat() Or, if you want to strip out all HTML formatting from the textarea (ie. do not wish to allow it) you can go to CFLIB.ORG and download a function which will strip HTML commands. -Novak -Original Message- From: Spectru

MORE INFO Re: CFFILE MX 6.1 and PNG files

2003-12-08 Thread Bryan Stevenson
OK...I've found that the file type is being read as "image/x-png".  So are there different flavours of PNG files just like JPEG (i.e. PJPEG,JPE,JPG)?? Thanks Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED]

RE: Getting 2 first lines from textarea formatted field

2003-12-08 Thread Spectrum WebDesign
Another problem. Many records from textarea field is formatted with or or font style. How to show only plain textarea without any format? Thanx - Original Message - From: "cf-talk" <[EMAIL PROTECTED]> Date: Mon, 8 Dec 2003 11:47:09 -0800 To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: Getti

Flash Instant Messenger Software?

2003-12-08 Thread cf-talk
Hi All, Before I go and reinvent the wheel... Does anyone know of some cheap/free "instant messenger" software that I can embed in a ColdFusion intranet application? I currently have a ColdFusion/_javascript_/DHTML solution in place but I'd much rather have a Flash "popup window" that floats ove

Application Modeling/Design/Diagramming

2003-12-08 Thread Venable, John
Hello everyone, I wanted to get some idea of what everyone uses to layout an application prior to building it. I'm trying to improve my skills and this is probably the biggest hurdle for me now--how to plan everything out beforehand rather than just jumping in and coding until I get myself into

RE: The Value of CFQUERYPARAM

2003-12-08 Thread kpeterson
Oracle does a hash on the statement and if it does not have a match in memory then it will "recompile" the statement. Any change including whitespace or change of case can cause a "recompile." The use of bind variables can prevent a "recompile." If you choose not to use bind variables on a statemen

CFFILE MX 6.1 and PNG files

2003-12-08 Thread Bryan Stevenson
Hey All, Has anybody had any issues using CFFILE to accept PNG image files?  I've got image/png in my accept list, but it chokes anytime I want to upload a PNG file (accepts GIF and the various JPEG formats with no problems). TIA Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Develo

Re: OT: Do you apply tax after shipping costs?

2003-12-08 Thread Matt Robertson
I would have said 'before' always, but it sounds like someone has experience otherwise?  Its been 'before' in every state I've done an ecommerce site in.  Anyone know any specifics?  If Mary Jo Sminkey (CFWebstore) is listening in, I'm sure she knows. -- ---

RE: OT: GeoTrust Certs @ 25$ ?

2003-12-08 Thread Matt Robertson
>The old name was www.whichssl.org ah yes, thats it... I think they were first and Comodo fired up the .com as a counterattack.   One thing I didn't mention is the hi-pressure sales tactics Comodo uses.  Don't call them unless you are ready to go, otherwise an account rep will try to become your

RE: Do you apply tax after shipping costs?

2003-12-08 Thread Adam Wayne Lehman
No, that's a good question. I think Tony is right cuz you pay taxes on goods, not services. Right? Adam Wayne Lehman Web Systems Developer Johns Hopkins Bloomberg School of Public Health Distance Education Division -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent:

RE: Do you apply tax after shipping costs?

2003-12-08 Thread Stacy Young
That's what I'm figuring...but someone else had just advised me otherwise. Doh. Stace   _   From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 3:07 PM To: CF-Talk Subject: RE: Do you apply tax after shipping costs? before, im pretty sure. your paying taxes for the g

RE: Referencing a .CFC in a sub directory.

2003-12-08 Thread Angel Stewart
Just some additional info, I have gotten the CFCs to work perfectly via the FORM Action attribute using the html pathname of the CFC. Works fine. Can't get the CFINVOKE to work. -Gel -Original Message- From: Angel Stewart [mailto:[EMAIL PROTECTED] Hello all, I have a direc

RE: Do you apply tax after shipping costs?

2003-12-08 Thread Larry Juncker
It depends on the State.  Some states charge tax on the shipping as well. they gotta get every cent they can you know. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 2:07 PM To: CF-Talk Subject: RE: Do you apply tax after shipping costs? befo

Re: SQL col type

2003-12-08 Thread Nick de Voil
> I don't know if this is possible or not but I thought I would ask.  I am using Access and I would like to know if it is possible to return along with my query the type of field that I am querying. If this is MX, and you want to write some Java code, you can do it via the JDBC metadata interface.

RE: Do you apply tax after shipping costs?

2003-12-08 Thread Tony Weeg
before, im pretty sure. your paying taxes for the goods. not the shipping costs. ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 20

OT: Do you apply tax after shipping costs?

2003-12-08 Thread Stacy Young
Shows you how often I do commercial sites. ;-) Do you apply applicable taxes before or after the shipping costs? Thanks! Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees

RE: The Value of CFQUERYPARAM

2003-12-08 Thread Barney Boisvert
If you've got both, it doesn't really matter, though the former is probably a hair faster, and it's certainly easier to read. > -Original Message- > From: Ian Skinner [mailto:[EMAIL PROTECTED] > Sent: Monday, December 08, 2003 11:54 AM > To: CF-Talk > Subject: RE: The Value of CFQUERYPARA

RE: The Value of CFQUERYPARAM

2003-12-08 Thread Raymond Camden
> The second answer still uses the CFQUERYPARAM bonuses for > queries, so if you use the same SQL somewhere else, just > changing the one field, then use CFQUEYPARAM... > > Disadvantage of using CFQUERYPARAM? You can't cache them! You can't use cachedwithin/cachedafter. You can certainly cache

RE: The Value of CFQUERYPARAM

2003-12-08 Thread Ian Skinner
That made little sense.  I meant to write:L SELECT * FROM table WHERE status = 'A'     AND ID = or SELECT * FROM table WHERE status =     AND ID = That should be a better example. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original

RE: The Value of CFQUERYPARAM

2003-12-08 Thread Shawn McKee
Both will work, both will be cached.  IMHO it is easier to read the query if the constants are not bind variables. Shawn McKee -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:54 PM To: CF-Talk Subject: RE: The Value of CFQUERYPARAM Just

RE: The Value of CFQUERYPARAM

2003-12-08 Thread Philip Arnold
> I would think the former from the answers in this forum, but > I'm not sure. Or are they both the same really, and it doesn't matter? The second answer still uses the CFQUERYPARAM bonuses for queries, so if you use the same SQL somewhere else, just changing the one field, then use CFQUEYPARAM...

RE: The Value of CFQUERYPARAM

2003-12-08 Thread Ian Skinner
Just for fun then if you have a mix of constants and variables would it be written like this? SELECT * FROM table WHERE status = 'A'     AND ID = or SELECT * FROM table WHERE status =     AND ID =     or     WHERE STATUS = 'M'     Is there any real advantage of one of these forms ove

RE: OT: GeoTrust Certs @ 25$ ?

2003-12-08 Thread tom
The old name was www.whichssl.org That's good to get another opinion besides that one site.  I had noticed GeoTrust did come out smelling like a rose.  I have a site that uses VeriSign's Pay Flow Pro payment processing.  When I was on the phone to the sales rep at VeriSign, he asked me if I needed

RE: Getting 2 first lines from textarea formatted field

2003-12-08 Thread cf-talk
Left(string, 150) Will get you the first 150 characters... Am I missing something? If you need the first two lines then read in the file and treat it as a Chr(10) delimited list. -Novak -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Monday, December 0

RE: CF & pda types of devices

2003-12-08 Thread Dave Watts
> I have noticed that you can now get an http server for PocketPC.   > I have not tested it but I saw it on the MS SDK 2003. That has been available for quite some time - since Pocket PC 2000, I believe. It can also run ASP! I've run it on my Pocket PCs for a while, just for kicks. However, it on

Getting 2 first lines from textarea formatted field

2003-12-08 Thread Spectrum WebDesign
Hi all i need to get 2 firt lines (or 150 first chars) from textarea formatted field like macromedia search action... Is possible? Thanx in advance -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Thr

Re:CF & pda types of devices

2003-12-08 Thread David Adams
I have noticed that you can now get an http server for PocketPC.  I have not tested it but I saw it on the MS SDK 2003. Dave Adams [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: The Value of CFQUERYPARAM

2003-12-08 Thread Shawn McKee
I just talked to my Oracle DBA and if the query is all constants SELECT M FROM S WHERE W = 'huh' it will get parsed once and put in the cache. SELECT M FROM S WHERE W = '#url.k#' Gets parsed  every time the contents of url.k changes SELECT M FROM S WHERE W = ? ? = 'huh' Is the solutio

RE: The Value of CFQUERYPARAM

2003-12-08 Thread Dave Watts
> Another consideration is that you cannot use CF query caching on > a query that uses CFQUERYPARAM tags.  (At least with CF5 and earlier.) I'm pretty sure this is also true with CFMX. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threa

RE: OT: GeoTrust Certs @ 25$ ?

2003-12-08 Thread Matt Robertson
Tom Nunamaker wrote: >This is an interesting summary of ssl providers: >http://www.sslreview.com/content/table/index.html Interesting, and false.   Both Comodo and Geotrust maintain phony 'independent' ssl 'choice' sites.  sslreview.com changed its name (I forget what it used to be) fairly recent

Re: Re:CF & pda types of devices

2003-12-08 Thread Kevin Graeme
As others have said, if your handheld uses "real" browser that consumes html, then you just use CF as normal. Some things to keep in mind are that IE on a PocketPC is a strange beast and that the capabilities recently changed significantly with the release of Windows Mobile 2003. Prior to the 2003

RE: The Value of CFQUERYPARAM

2003-12-08 Thread d.a.collie
>> Even though the value is static and unchanging, the query will be recompiled every time?  This seems to be a bit counter intuitive to me, but it is basically what I'm trying to confirm. In the most ineloquent and non-technical way (and with respect to Oracle who supports the bind vars) If

RE: The Value of CFQUERYPARAM

2003-12-08 Thread Tom Kitta
As far as I know, yes, it does recompile every time. And it is quite intuitive, just look at the debug of what is sent to the DB server for something like: SELECT M FROM S WHERE W = '#url.k#' and SELECT M FROM S WHERE W = 'huh' Assuming url.k is 'huh' you get the same thing sent to the DB serve

RE: OT: GeoTrust Certs @ 25$ ?

2003-12-08 Thread tom
> > So I moved over to instantssl.com. I'm a reseller there and I pay about > US$42 for each cert.  Naturally, you can retail them for whatever you > want.  It's a very, very easy and truly instant process (note that you > can only self-verify and get instant issuance if you are an instantssl > res

SQL col type

2003-12-08 Thread Mickael
Hello All, I don't know if this is possible or not but I thought I would ask.  I am using Access and I would like to know if it is possible to return along with my query the type of field that I am querying. I am querying one database then inserting info in to another(access) I guess what I am l

RE: The Value of CFQUERYPARAM

2003-12-08 Thread Lofback, Chris
Another consideration is that you cannot use CF query caching on a query that uses CFQUERYPARAM tags.  (At least with CF5 and earlier.) Chris -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 1:36 PM To: CF-Talk Subject: The Value of CFQUERYPAR

alternative to CFFTP

2003-12-08 Thread Dan Farmer
I need to pull files from an FTP site...unfortunatley this ISP is not allowing the tag... great then I asked what tags they disabled... and they wouldn't tell me... [ insert curses here ] anyway, what other options do I have to accomplish the actions of FTP? Basically I need to open and g

  1   2   >